https://perleshair.com/public/recette/1542

Query Metrics

5 Database Queries
5 Different statements
1.15 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.31 ms
SELECT t0.id AS id_1, t0.date_recette AS date_recette_2, t0.montant AS montant_3, t0.source AS source_4, t0.boutique_id AS boutique_id_5, t0.vente_id AS vente_id_6, t0.facture_service_id AS facture_service_id_7 FROM recette t0 WHERE t0.id = ?
Parameters:
[
  1542
]
2 0.20 ms
SELECT t0.id AS id_1, t0.date_depense AS date_depense_2, t0.montant AS montant_3, t0.description AS description_4, t0.recette_id AS recette_id_5 FROM depense t0 WHERE t0.recette_id = ?
Parameters:
[
  1542
]
3 0.19 ms
SELECT t0.id AS id_1, t0.date_vente AS date_vente_2, t0.description AS description_3, t0.vendeur_id AS vendeur_id_4, t0.client_id AS client_id_5, t0.boutique_id AS boutique_id_6 FROM vente t0 WHERE t0.id = ?
Parameters:
[
  1064
]
4 0.23 ms
SELECT t0.id AS id_1, t0.quantite_vendu AS quantite_vendu_2, t0.prix_unitaire AS prix_unitaire_3, t0.prix_total AS prix_total_4, t0.remise_pourcentage AS remise_pourcentage_5, t0.vente_id AS vente_id_6, t0.produit_id AS produit_id_7 FROM details_vente t0 WHERE t0.vente_id = ?
Parameters:
[
  1064
]
5 0.22 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.prix_unitaire AS prix_unitaire_4, t0.quantite_pr AS quantite_pr_5, t0.cout AS cout_6, t0.image_name AS image_name_7, t0.updated_at AS updated_at_8, t0.unite_mesure AS unite_mesure_9, t0.prix_vente_unitaire AS prix_vente_unitaire_10, t0.categorie_id AS categorie_id_11, t0.utilisateur_id AS utilisateur_id_12 FROM produit t0 WHERE t0.id = ?
Parameters:
[
  160
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Recette No errors.
App\Entity\Boutique No errors.
App\Entity\Vente No errors.
App\Entity\FactureService No errors.
App\Entity\Depense No errors.
App\Entity\User No errors.
App\Entity\Client No errors.
App\Entity\DetailsVente No errors.
App\Entity\Echeance No errors.
App\Entity\Facture No errors.
App\Entity\Produit No errors.
App\Entity\Categorie No errors.
App\Entity\EntreeStock No errors.
App\Entity\SortieStock No errors.
App\Entity\LivraisonProd No errors.
App\Entity\ProduitStock No errors.