GET https://dev.moulinhoche.com/en/accueil

Query Metrics

18 Database Queries
6 Different statements
30.88 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 1.09 ms
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.peut_contenir_page AS peut_contenir_page_6, t0.est_footer AS est_footer_7, t0.est_affiche AS est_affiche_8, t0.ordre AS ordre_9, t0.image AS image_10, t0.nom_route AS nom_route_11, t12.id AS id_13, t12.contenu_fr AS contenu_fr_14, t12.contenu_en AS contenu_en_15, t12.contenu_es AS contenu_es_16, t12.est_modifiable AS est_modifiable_17, t12.image_fond AS image_fond_18, t12.image_contenu AS image_contenu_19, t12.pdf_fr AS pdf_fr_20, t12.pdf_en AS pdf_en_21, t12.pdf_es AS pdf_es_22, t12.sous_menu_id AS sous_menu_id_23, t12.menu_id AS menu_id_24 FROM menu t0 LEFT JOIN page t12 ON t12.menu_id = t0.id WHERE t0.est_actif = ? AND t0.est_footer = ?
Parameters:
[
  1
  0
]
2 0.34 ms
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 = 1 AND m0_.est_footer = 1
Parameters:
[]
3 0.32 ms
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:
[
  253
]
4 0.27 ms
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:
[
  254
]
5 0.26 ms
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:
[
  255
]
6 0.26 ms
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:
[
  256
]
7 0.26 ms
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:
[
  257
]
8 0.25 ms
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:
[
  259
]
9 0.32 ms
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
]
10 4.92 ms
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.menu_id = ?
Parameters:
[
  248
]
11 2.19 ms
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.menu_id = ?
Parameters:
[
  249
]
12 16.37 ms
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.menu_id = ?
Parameters:
[
  250
]
13 1.71 ms
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.menu_id = ?
Parameters:
[
  251
]
14 1.02 ms
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.menu_id = ?
Parameters:
[
  252
]
15 0.43 ms
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
  1
]
16 0.31 ms
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:
[]
17 0.27 ms
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:
[]
18 0.28 ms
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:
[]

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