Query Metrics
12
Database Queries
4
Different statements
3.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
2.19 ms (56.78%) |
1 |
SELECT p0_.id AS id_0, p0_.prix AS prix_1, p0_.stock AS stock_2, p0_.qte_vendu AS qte_vendu_3, p0_.qte_approvisionne AS qte_approvisionne_4, p0_.qte_retourne AS qte_retourne_5, p0_.nb_reportion AS nb_reportion_6, p0_.stock_en_portion AS stock_en_portion_7, p0_.reference_systeme AS reference_systeme_8, p0_.reference_manuel AS reference_manuel_9, p0_.cree_le AS cree_le_10, p0_.modifie_le AS modifie_le_11, s1_.id AS id_12, s1_.libelle AS libelle_13, s1_.description AS description_14, s1_.image AS image_15, s1_.featured AS featured_16, s1_.image_service AS image_service_17, s1_.slug AS slug_18, s1_.reference_systeme AS reference_systeme_19, s1_.reference_manuel AS reference_manuel_20, s1_.cree_le AS cree_le_21, s1_.modifie_le AS modifie_le_22, p2_.id AS id_23, p2_.libelle AS libelle_24, p2_.prix_ht AS prix_ht_25, p2_.prix_achat AS prix_achat_26, p2_.description AS description_27, p2_.code_barre AS code_barre_28, p2_.code_barre_fournisseur AS code_barre_fournisseur_29, p2_.stock_actuel AS stock_actuel_30, p2_.qte_reapprovissement AS qte_reapprovissement_31, p2_.qte_mini AS qte_mini_32, p2_.qte_vente AS qte_vente_33, p2_.qte_rebus AS qte_rebus_34, p2_.prix_revient AS prix_revient_35, p2_.est_matiere_premiere AS est_matiere_premiere_36, p2_.est_stockable AS est_stockable_37, p2_.est_disponible AS est_disponible_38, p2_.unite AS unite_39, p2_.unite_detail AS unite_detail_40, p2_.nbre_unite AS nbre_unite_41, p2_.stock_alerte AS stock_alerte_42, p2_.reference_systeme AS reference_systeme_43, p2_.reference_manuel AS reference_manuel_44, p2_.cree_le AS cree_le_45, p2_.modifie_le AS modifie_le_46, f3_.id AS id_47, f3_.libelle AS libelle_48, f3_.numero_s AS numero_s_49, f3_.description AS description_50, f3_.supprimer AS supprimer_51, f3_.urlimage AS urlimage_52, f3_.slug AS slug_53, f3_.reference_systeme AS reference_systeme_54, f3_.reference_manuel AS reference_manuel_55, f3_.cree_le AS cree_le_56, f3_.modifie_le AS modifie_le_57, p0_.service_id AS service_id_58, p0_.produit_id AS produit_id_59, p2_.famille_id AS famille_id_60 FROM prix_aapplique p0_ INNER JOIN services s1_ ON p0_.service_id = s1_.id INNER JOIN produit p2_ ON p0_.produit_id = p2_.id INNER JOIN famille f3_ ON p2_.famille_id = f3_.id WHERE p0_.service_id = ?
Parameters:
[
b"\x01—»è¿6|u¬6Ú¸ãàŽv"
]
|
||||||||||||||||||||||||||||
|
1.04 ms (26.93%) |
9 |
SELECT t0.id AS id_1, t0.qte_en_stock AS qte_en_stock_2, t0.auteur_modif AS auteur_modif_3, t0.date_modif AS date_modif_4, t0.produit_id AS produit_id_5 FROM stock t0 WHERE t0.produit_id = ?
Parameters:
[
b"\x01ù╗■,My&Ø\x1A┤\x18 dfv"
]
|
||||||||||||||||||||||||||||
|
0.40 ms (10.35%) |
1 |
SELECT f0_.id AS id_0, f0_.libelle AS libelle_1, f0_.numero_s AS numero_s_2, f0_.description AS description_3, f0_.supprimer AS supprimer_4, f0_.urlimage AS urlimage_5, f0_.slug AS slug_6, f0_.reference_systeme AS reference_systeme_7, f0_.reference_manuel AS reference_manuel_8, f0_.cree_le AS cree_le_9, f0_.modifie_le AS modifie_le_10 FROM famille f0_ WHERE f0_.slug = ? OR f0_.reference_manuel = ?
Parameters:
[ "TA00000002" "TA00000002" ]
|
||||||||||||||||||||||||||||
|
0.23 ms (5.94%) |
1 |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.image AS image_4, t0.featured AS featured_5, t0.image_service AS image_service_6, t0.slug AS slug_7, t0.reference_systeme AS reference_systeme_8, t0.reference_manuel AS reference_manuel_9, t0.cree_le AS cree_le_10, t0.modifie_le AS modifie_le_11 FROM services t0 WHERE t0.libelle = ? LIMIT 1
Parameters:
[
"HEBERGEMENT"
]
|
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\Famille | No errors. |
| App\Entity\Produit | No errors. |
| App\Entity\Services | No errors. |
| App\Entity\PrixAApplique | No errors. |
| App\Entity\DemandeProduitService | No errors. |
| App\Entity\LivraisonServices | No errors. |
| App\Entity\TableServices | No errors. |
| App\Entity\AffectationMateriel | No errors. |
| App\Entity\Employe | No errors. |
| App\Entity\MouvementStock | No errors. |
| App\Entity\SortiesStock | No errors. |
| App\Entity\LigneFacture | No errors. |
| App\Entity\LigneDemandeProduitService | No errors. |
| App\Entity\LigneEntreeStock | No errors. |
| App\Entity\Stock | No errors. |
| App\Entity\ImagesProduit | No errors. |
| App\Entity\LigneSortiesStock | No errors. |
| App\Entity\LigneInventaire | No errors. |