Query Metrics

180 Database Queries
15 Different statements
10.12 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
6.98 ms
(68.94%)
160
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.type_lien AS type_lien_3, t0.lien AS lien_4, t0.position AS position_5, t0.type_fichier AS type_fichier_6, t0.gallery_type AS gallery_type_7, t0.niveau_id AS niveau_id_8, t0.rubric_id AS rubric_id_9, t0.parent_id AS parent_id_10 FROM menu_item t0 WHERE t0.parent_id = ?
Parameters:
[
  1
]
1.11 ms
(10.95%)
1
"COMMIT"
Parameters:
[]
0.54 ms
(5.31%)
1
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image AS image_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.prenom AS prenom_6, t0.nom_famille AS nom_famille_7, t0.email AS email_8, t0.telephone AS telephone_9, t0.lien_bouton AS lien_bouton_10, t0.is_actu AS is_actu_11, t0.caroussel AS caroussel_12, t0.description AS description_13, t0.type_lien_bouton AS type_lien_bouton_14, t0.gabarit AS gabarit_15, t0.vues AS vues_16, t0.texte_libre AS texte_libre_17, t0.img_description AS img_description_18, t0.img_long_description AS img_long_description_19, t0.is_actu_visible AS is_actu_visible_20, t0.special AS special_21, t0.user_id AS user_id_22, t0.seo_id AS seo_id_23, t24.id AS id_25, t24.titre AS titre_26, t24.clefs AS clefs_27, t24.description AS description_28, t0.menu_footer_id AS menu_footer_id_29, t30.id AS id_31, t30.vues AS vues_32, t30.created_at AS created_at_33, t30.updated_at AS updated_at_34, t30.page_id AS page_id_35 FROM page t0 LEFT JOIN seo t24 ON t0.seo_id = t24.id LEFT JOIN analytics t30 ON t30.page_id = t0.id WHERE t0.id = ?
Parameters:
[
  "271"
]
0.45 ms
(4.48%)
7
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.type_lien AS type_lien_3, t0.lien AS lien_4, t0.position AS position_5, t0.type_fichier AS type_fichier_6, t0.gallery_type AS gallery_type_7, t0.niveau_id AS niveau_id_8, t0.rubric_id AS rubric_id_9, t0.parent_id AS parent_id_10 FROM menu_item t0 WHERE t0.rubric_id = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
0.27 ms
(2.62%)
1
UPDATE analytics SET vues = ?, updated_at = ? WHERE id = ?
Parameters:
[
  61
  "2026-04-05 00:29:28"
  63
]
0.11 ms
(1.11%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.lien AS lien_3, t0.updated_at AS updated_at_4, t0.created_at AS created_at_5, t0.page_id AS page_id_6, t7.id AS id_8, t7.titre AS titre_9, t7.image AS image_10, t7.created_at AS created_at_11, t7.updated_at AS updated_at_12, t7.prenom AS prenom_13, t7.nom_famille AS nom_famille_14, t7.email AS email_15, t7.telephone AS telephone_16, t7.lien_bouton AS lien_bouton_17, t7.is_actu AS is_actu_18, t7.caroussel AS caroussel_19, t7.description AS description_20, t7.type_lien_bouton AS type_lien_bouton_21, t7.gabarit AS gabarit_22, t7.vues AS vues_23, t7.texte_libre AS texte_libre_24, t7.img_description AS img_description_25, t7.img_long_description AS img_long_description_26, t7.is_actu_visible AS is_actu_visible_27, t7.special AS special_28, t7.user_id AS user_id_29, t7.seo_id AS seo_id_30, t7.menu_footer_id AS menu_footer_id_31 FROM pages t0 LEFT JOIN page t7 ON t0.page_id = t7.id WHERE t0.page_id = ?
Parameters:
[
  271
]
0.09 ms
(0.94%)
1
SELECT b0_.id AS id_0, b0_.nom AS nom_1, b0_.slug AS slug_2, b0_.type AS type_3, b0_.created_at AS created_at_4, b0_.updated_at AS updated_at_5, b0_.text AS text_6, b0_.image AS image_7, b0_.position AS position_8, b0_.contact AS contact_9, b0_.image_position AS image_position_10, b0_.background AS background_11, b0_.background_grey AS background_grey_12, b0_.titre AS titre_13, b0_.is_type_image_pdf AS is_type_image_pdf_14, b0_.img_description AS img_description_15, b0_.img_long_description AS img_long_description_16, b0_.objet_contact_form AS objet_contact_form_17, b0_.email_destinataire_contact_form AS email_destinataire_contact_form_18, b0_.page_id AS page_id_19, b0_.lien_bouton_id AS lien_bouton_id_20, b0_.lien_image_id AS lien_image_id_21 FROM blocs b0_ WHERE b0_.page_id = ? ORDER BY b0_.position ASC
Parameters:
[
  271
]
0.08 ms
(0.84%)
1
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.type_lien AS type_lien_3, t0.lien AS lien_4, t0.position AS position_5, t0.type_fichier AS type_fichier_6, t0.gallery_type AS gallery_type_7, t0.niveau_id AS niveau_id_8, t0.rubric_id AS rubric_id_9, t0.parent_id AS parent_id_10 FROM menu_item t0 WHERE t0.lien = ? ORDER BY t0.position ASC LIMIT 1
Parameters:
[
  "/page/271"
]
0.08 ms
(0.81%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.created_at AS created_at_3, t0.slug AS slug_4, t0.position AS position_5, t0.lien AS lien_6, t0.type_lien AS type_lien_7, t0.type_fichier AS type_fichier_8, t0.gallery_type AS gallery_type_9 FROM rubrics t0
Parameters:
[]
0.07 ms
(0.74%)
1
"START TRANSACTION"
Parameters:
[]
0.07 ms
(0.73%)
1
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.type_lien AS type_lien_3, t0.lien AS lien_4, t0.position AS position_5, t0.type_fichier AS type_fichier_6, t0.gallery_type AS gallery_type_7, t0.niveau_id AS niveau_id_8, t0.rubric_id AS rubric_id_9, t0.parent_id AS parent_id_10 FROM menu_item t0 WHERE t0.id = ?
Parameters:
[
  23
]
0.07 ms
(0.70%)
1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.parent_id AS parent_id_3 FROM fond_documentaire_categorie t0
Parameters:
[]
0.07 ms
(0.68%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.created_at AS created_at_3, t0.slug AS slug_4, t0.position AS position_5, t0.lien AS lien_6, t0.type_lien AS type_lien_7, t0.type_fichier AS type_fichier_8, t0.gallery_type AS gallery_type_9 FROM rubrics t0 WHERE t0.id = ?
Parameters:
[
  4
]
0.06 ms
(0.62%)
1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.filepath AS filepath_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.publied_at AS publied_at_6, t0.categorie_id AS categorie_id_7 FROM fond_documentaire t0 INNER JOIN fond_documentaire_pages ON t0.id = fond_documentaire_pages.fond_documentaire_id WHERE fond_documentaire_pages.pages_id = ?
Parameters:
[
  271
]
0.05 ms
(0.52%)
1
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.visible AS visible_3, t0.lien AS lien_4, t0.type_lien AS type_lien_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.image_type AS image_type_8, t0.image AS image_9, t0.pictogramme AS pictogramme_10, t0.position AS position_11, t0.text_alternatif AS text_alternatif_12 FROM damier t0 ORDER BY t0.position ASC
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\MenuItem No errors.
App\Entity\FondDocumentaireCategorie No errors.
App\Entity\Page No errors.
App\Entity\User No errors.
App\Entity\Seo No errors.
App\Entity\MenuFooter No errors.
App\Entity\Analytics No errors.
App\Entity\Blocs No errors.
App\Entity\Pages No errors.
App\Entity\NewsCategories No errors.
App\Entity\AccordeonElements No errors.
App\Entity\Damier No errors.
App\Entity\BlocksLinks No errors.
App\Entity\FondDocumentaire No errors.
App\Entity\Menu No errors.
App\Entity\Rubrics No errors.