GET http://86.65.9.121/en/produits/categorie/469

Query Metrics

26 Database Queries
7 Different statements
9.79 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
3.93 ms
(40.17%)
12
SELECT t0.id AS id_1, t0.contenu_fr AS contenu_fr_2, t0.contenu_en AS contenu_en_3, t0.contenu_es AS contenu_es_4, t0.est_modifiable AS est_modifiable_5, t0.image_fond AS image_fond_6, t0.image_contenu AS image_contenu_7, t0.pdf_fr AS pdf_fr_8, t0.pdf_en AS pdf_en_9, t0.pdf_es AS pdf_es_10, t0.sous_menu_id AS sous_menu_id_11, t0.menu_id AS menu_id_12 FROM page t0 WHERE t0.menu_id = ?
Parameters:
[
  248
]
2.68 ms
(27.37%)
6
SELECT t0.id AS id_1, t0.contenu_fr AS contenu_fr_2, t0.contenu_en AS contenu_en_3, t0.contenu_es AS contenu_es_4, t0.est_modifiable AS est_modifiable_5, t0.image_fond AS image_fond_6, t0.image_contenu AS image_contenu_7, t0.pdf_fr AS pdf_fr_8, t0.pdf_en AS pdf_en_9, t0.pdf_es AS pdf_es_10, t0.sous_menu_id AS sous_menu_id_11, t0.menu_id AS menu_id_12 FROM page t0 WHERE t0.sous_menu_id = ?
Parameters:
[
  465
]
0.79 ms
(8.08%)
3
SELECT p0_.id AS id_0, p0_.mail_destinataire AS mail_destinataire_1, p0_.mail_expediteur AS mail_expediteur_2, p0_.facebook AS facebook_3, p0_.instagram AS instagram_4, p0_.latitude AS latitude_5, p0_.longitude AS longitude_6, p0_.linkedin AS linkedin_7 FROM parametres_globaux p0_ LIMIT 1
Parameters:
[]
0.78 ms
(7.94%)
1
SELECT t0.id AS id_1, t0.libelle_fr AS libelle_fr_2, t0.libelle_en AS libelle_en_3, t0.libelle_es AS libelle_es_4, t0.est_actif AS est_actif_5, t0.ordre AS ordre_6, t0.code_couleur AS code_couleur_7, t0.image AS image_8, t0.menu_id AS menu_id_9, t10.id AS id_11, t10.contenu_fr AS contenu_fr_12, t10.contenu_en AS contenu_en_13, t10.contenu_es AS contenu_es_14, t10.est_modifiable AS est_modifiable_15, t10.image_fond AS image_fond_16, t10.image_contenu AS image_contenu_17, t10.pdf_fr AS pdf_fr_18, t10.pdf_en AS pdf_en_19, t10.pdf_es AS pdf_es_20, t10.sous_menu_id AS sous_menu_id_21, t10.menu_id AS menu_id_22 FROM sous_menu t0 LEFT JOIN page t10 ON t10.sous_menu_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
  469
]
0.74 ms
(7.60%)
2
SELECT m0_.id AS id_0, m0_.libelle_fr AS libelle_fr_1, m0_.libelle_en AS libelle_en_2, m0_.libelle_es AS libelle_es_3, m0_.est_actif AS est_actif_4, m0_.peut_contenir_page AS peut_contenir_page_5, m0_.est_footer AS est_footer_6, m0_.est_affiche AS est_affiche_7, m0_.ordre AS ordre_8, m0_.image AS image_9, m0_.nom_route AS nom_route_10 FROM menu m0_ WHERE m0_.est_actif = ? AND m0_.est_footer = ?
Parameters:
[
  1
  0
]
0.48 ms
(4.88%)
1
SELECT s0_.id AS id_0, s0_.libelle_fr AS libelle_fr_1, s0_.libelle_en AS libelle_en_2, s0_.libelle_es AS libelle_es_3, s0_.est_actif AS est_actif_4, s0_.ordre AS ordre_5, s0_.code_couleur AS code_couleur_6, s0_.image AS image_7, s0_.menu_id AS menu_id_8 FROM sous_menu s0_ INNER JOIN menu m1_ ON s0_.menu_id = m1_.id WHERE m1_.libelle_fr LIKE ?
Parameters:
[
  "%Nos Produits%"
]
0.39 ms
(3.97%)
1
SELECT t0.id AS id_1, t0.libelle_fr AS libelle_fr_2, t0.libelle_en AS libelle_en_3, t0.libelle_es AS libelle_es_4, t0.description_fr AS description_fr_5, t0.description_en AS description_en_6, t0.description_es AS description_es_7, t0.est_actif AS est_actif_8, t0.ordre AS ordre_9, t0.sous_menu_id AS sous_menu_id_10, t0.tag_id AS tag_id_11 FROM produit t0 WHERE t0.sous_menu_id = ?
Parameters:
[
  469
]

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\SousMenu No errors.
App\Entity\Menu No errors.
App\Entity\Page No errors.
App\Entity\Produit No errors.
App\Entity\Tag No errors.
App\Entity\ParametresGlobaux No errors.