Query Metrics
8
Database Queries
7
Different statements
96.78 ms
Query time
0
Invalid entities
3396
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.64 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.illustration AS illustration_3, t0.catalogue_pdf AS catalogue_pdf_4 FROM brand t0
Parameters:
[]
|
||||||||||||||||||||||||||||
| 2 | 86.34 ms |
SELECT t0.id AS id_1, t0.article_code AS article_code_2, t0.name AS name_3, t0.slug AS slug_4, t0.description AS description_5, t0.weight AS weight_6, t0.illustration AS illustration_7, t0.price_unitaire AS price_unitaire_8, t0.price_palette AS price_palette_9, t0.stock AS stock_10, t0.is_homepage AS is_homepage_11, t0.tva AS tva_12, t0.in_home AS in_home_13, t0.numbre_unite_palette AS numbre_unite_palette_14, t0.in_paint AS in_paint_15, t0.in_labo AS in_labo_16, t0.pvc AS pvc_17, t0.category_id AS category_id_18, t0.grain_id AS grain_id_19, t0.con_mastic_id AS con_mastic_id_20, t0.con_appret_id AS con_appret_id_21, t0.con_vernis_id AS con_vernis_id_22, t0.rapidite_id AS rapidite_id_23, t0.malette_id AS malette_id_24, t0.couleur_all_id AS couleur_all_id_25, t0.filter_dimension_cale_id AS filter_dimension_cale_id_26, t0.dimension_double_face_id AS dimension_double_face_id_27, t0.buse_id AS buse_id_28, t0.product_parent_id AS product_parent_id_29, t0.con_antigravillon_id AS con_antigravillon_id_30, t0.con_degraissant_id AS con_degraissant_id_31, t0.capacite_aspirateur_id AS capacite_aspirateur_id_32, t0.con_polish_id AS con_polish_id_33, t0.con_savon_id AS con_savon_id_34, t0.con_diluant_id AS con_diluant_id_35, t0.con_gobelet_id AS con_gobelet_id_36, t0.con_bidon_plastique_id AS con_bidon_plastique_id_37, t0.con_durcisseur_id AS con_durcisseur_id_38, t0.dimansion_filtre_cabine_id AS dimansion_filtre_cabine_id_39, t0.diametre_zikzak_id AS diametre_zikzak_id_40, t0.diametre_agrafes_id AS diametre_agrafes_id_41, t0.dimension_chariot_kraft_id AS dimension_chariot_kraft_id_42, t0.dimension_papier_cale_id AS dimension_papier_cale_id_43, t0.filtre_cone_id AS filtre_cone_id_44, t0.dimension_micro_bruch_id AS dimension_micro_bruch_id_45, t0.pinceau_dimension_id AS pinceau_dimension_id_46, t0.regle_dosage_id AS regle_dosage_id_47, t0.dimension_kraft_id AS dimension_kraft_id_48, t0.dimension_tireau_id AS dimension_tireau_id_49, t0.taille_fine_tape_id AS taille_fine_tape_id_50, t0.effet_id AS effet_id_51, t0.aspirateur_id AS aspirateur_id_52, t0.ponceuse_id AS ponceuse_id_53, t0.type_pistole_id AS type_pistole_id_54, t0.sol_plafond_id AS sol_plafond_id_55, t0.acier_alu_id AS acier_alu_id_56, t0.taille_id AS taille_id_57, t0.dimension_all_id AS dimension_all_id_58, t0.matiere_id AS matiere_id_59, t0.masquage_id AS masquage_id_60, t0.nettoyage_id AS nettoyage_id_61, t0.durcisseur_id AS durcisseur_id_62, t0.accessoire_aspirateur_id AS accessoire_aspirateur_id_63, t0.vitrage_id AS vitrage_id_64, t0.type_raccord_id AS type_raccord_id_65, t0.type_materiel_id AS type_materiel_id_66, t0.materiel_id AS materiel_id_67, t0.colle_joint_id AS colle_joint_id_68, t0.adhesif_id AS adhesif_id_69, t0.type_ponceuse_id AS type_ponceuse_id_70, t0.type_mastic_id AS type_mastic_id_71, t0.type_diluant_id AS type_diluant_id_72, t0.accessoire_id AS accessoire_id_73, t0.accessoire_polisseuse_id AS accessoire_polisseuse_id_74, t0.debosseleur_marteau_id AS debosseleur_marteau_id_75, t0.equerre_tirage_griffe_id AS equerre_tirage_griffe_id_76, t0.chaine_raccord_id AS chaine_raccord_id_77, t0.barre_debosslage_id AS barre_debosslage_id_78, t0.masse_magnetique_chario_id AS masse_magnetique_chario_id_79, t80.id AS id_81, t80.code AS code_82, t80.produit_id AS produit_id_83 FROM product t0 LEFT JOIN code_barre t80 ON t80.produit_id = t0.id
Parameters:
[]
|
||||||||||||||||||||||||||||
| 3 | 4.27 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.btn_title AS btn_title_4, t0.btn_url AS btn_url_5, t0.illustration AS illustration_6 FROM header t0
Parameters:
[]
|
||||||||||||||||||||||||||||
| 4 | 3.90 ms |
SELECT q0_.id AS id_0, q0_.qty AS qty_1, q0_.active AS active_2, q0_.price AS price_3, q0_.in_palette AS in_palette_4, q0_.order_palette AS order_palette_5, q0_.order_qte AS order_qte_6, q0_.object_id AS object_id_7 FROM qty_carton q0_ WHERE q0_.active = ? ORDER BY q0_.order_qte ASC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
| 5 | 0.60 ms |
SELECT q0_.id AS id_0, q0_.qty AS qty_1, q0_.active AS active_2, q0_.price AS price_3, q0_.in_palette AS in_palette_4, q0_.order_palette AS order_palette_5, q0_.order_qte AS order_qte_6, q0_.object_id AS object_id_7 FROM qty_carton q0_ WHERE q0_.in_palette = ? ORDER BY q0_.order_palette ASC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
| 6 | 0.42 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.illustration AS illustration_3, t0.catalogue_pdf AS catalogue_pdf_4 FROM brand t0
Parameters:
[] |
||||||||||||||||||||||||||||
| 7 | 0.33 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.illustration AS illustration_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.illustration_two AS illustration_two_6, t0.description AS description_7, t0.parent_id_id AS parent_id_id_8 FROM category t0 WHERE t0.parent_id_id IS NULL
Parameters:
[] |
||||||||||||||||||||||||||||
| 8 | 0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.illustration AS illustration_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.illustration_two AS illustration_two_6, t0.description AS description_7, t0.parent_id_id AS parent_id_id_8 FROM category t0
Parameters:
[] |
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Product | 1171 |
| App\Entity\CodeBarre | 902 |
| App\Entity\ProductParent | 848 |
| App\Entity\DimensionAll | 104 |
| App\Entity\Category | 63 |
| App\Entity\QtyCarton | 50 |
| App\Entity\Grain | 23 |
| App\Entity\Brand | 17 |
| App\Entity\CouleurAll | 14 |
| App\Entity\TypePistole | 10 |
| App\Entity\Header | 10 |
| App\Entity\FilterDimensionCale | 8 |
| App\Entity\TypeMastic | 8 |
| App\Entity\Rapidite | 7 |
| App\Entity\Buse | 7 |
| App\Entity\DimensionDoubleFace | 7 |
| App\Entity\Accessoire | 6 |
| App\Entity\ConAppret | 6 |
| App\Entity\TypeDiluant | 5 |
| App\Entity\DimensionPapierCale | 5 |
| App\Entity\DimansionFiltreCabine | 5 |
| App\Entity\Taille | 5 |
| App\Entity\ConMastic | 5 |
| App\Entity\RegleDosage | 4 |
| App\Entity\ConGobelet | 4 |
| App\Entity\ConDurcisseur | 4 |
| App\Entity\ConDiluant | 4 |
| App\Entity\Adhesif | 4 |
| App\Entity\TailleFineTape | 4 |
| App\Entity\DimensionTireau | 4 |
| App\Entity\DimensionKraft | 4 |
| App\Entity\Vitrage | 4 |
| App\Entity\Matiere | 4 |
| App\Entity\Ponceuse | 4 |
| App\Entity\Materiel | 4 |
| App\Entity\ConBidonPlastique | 3 |
| App\Entity\PinceauDimension | 3 |
| App\Entity\ConVernis | 3 |
| App\Entity\Effet | 3 |
| App\Entity\Masquage | 3 |
| App\Entity\ColleJoint | 3 |
| App\Entity\DiametreAgrafes | 3 |
| App\Entity\ConDegraissant | 3 |
| App\Entity\TypePonceuse | 3 |
| App\Entity\CapaciteAspirateur | 3 |
| App\Entity\Aspirateur | 3 |
| App\Entity\TypeRaccord | 3 |
| App\Entity\DimensionMicroBruch | 2 |
| App\Entity\Durcisseur | 2 |
| App\Entity\FiltreCone | 2 |
| App\Entity\DimensionChariotKraft | 2 |
| App\Entity\ConAntigravillon | 2 |
| App\Entity\Nettoyage | 2 |
| App\Entity\DiametreZikzak | 2 |
| App\Entity\AcierAlu | 2 |
| App\Entity\SolPlafond | 2 |
| App\Entity\Malette | 2 |
| App\Entity\AccessoireAspirateur | 2 |
| App\Entity\TypeMateriel | 2 |
| App\Entity\ConPolish | 2 |