Query Metrics
5
Database Queries
5
Different statements
1.15 ms
Query time
0
Invalid entities
Queries
| #▲ | 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. |