GET http://86.65.9.121/es/produits/471?sel=379

Query Metrics

20 Database Queries
6 Different statements
7.16 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.83 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.id = ?
Parameters:
[
  "471"
]
2 0.42 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_.id LIKE ? AND m0_.est_actif = 1 ORDER BY m0_.ordre ASC LIMIT 1
Parameters:
[
  "249"
]
3 0.29 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:
[
  249
]
4 0.54 ms
SELECT p0_.id AS id_0, p0_.libelle_fr AS libelle_fr_1, p0_.libelle_en AS libelle_en_2, p0_.libelle_es AS libelle_es_3, p0_.description_fr AS description_fr_4, p0_.description_en AS description_en_5, p0_.description_es AS description_es_6, p0_.est_actif AS est_actif_7, p0_.ordre AS ordre_8, p0_.sous_menu_id AS sous_menu_id_9, p0_.tag_id AS tag_id_10 FROM produit p0_ INNER JOIN sous_menu s1_ ON p0_.sous_menu_id = s1_.id WHERE s1_.id LIKE ? AND p0_.est_actif = 1 ORDER BY p0_.ordre ASC
Parameters:
[
  "471"
]
5 0.40 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
]
6 0.30 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:
[
  248
]
7 0.29 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:
[
  250
]
8 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:
[
  251
]
9 0.60 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:
[
  252
]
10 0.36 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:
[
  258
]
11 0.35 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
]
12 0.30 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
]
13 0.34 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
]
14 0.30 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
]
15 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:
[
  256
]
16 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:
[
  257
]
17 0.29 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
]
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:
[]
19 0.25 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:
[]
20 0.24 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\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.