Query Metrics

181 Database Queries
6 Different statements
377.04 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
267.29 ms
(70.89%)
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
]
46.50 ms
(12.33%)
11
SELECT t0.id AS id_1, t0.vues AS vues_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.page_id AS page_id_5 FROM analytics t0 WHERE t0.page_id = ?
Parameters:
[
  301
]
39.00 ms
(10.34%)
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
]
21.07 ms
(5.59%)
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:
[]
2.75 ms
(0.73%)
1
SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.image AS image_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p0_.prenom AS prenom_5, p0_.nom_famille AS nom_famille_6, p0_.email AS email_7, p0_.telephone AS telephone_8, p0_.lien_bouton AS lien_bouton_9, p0_.is_actu AS is_actu_10, p0_.caroussel AS caroussel_11, p0_.description AS description_12, p0_.type_lien_bouton AS type_lien_bouton_13, p0_.gabarit AS gabarit_14, p0_.vues AS vues_15, p0_.texte_libre AS texte_libre_16, p0_.img_description AS img_description_17, p0_.img_long_description AS img_long_description_18, p0_.is_actu_visible AS is_actu_visible_19, p0_.special AS special_20, n1_.id AS id_21, n1_.nom AS nom_22, n1_.created_at AS created_at_23, n1_.updated_at AS updated_at_24, n1_.image AS image_25, p0_.user_id AS user_id_26, p0_.seo_id AS seo_id_27, p0_.menu_footer_id AS menu_footer_id_28 FROM page p0_ INNER JOIN page_news_categories p2_ ON p0_.id = p2_.page_id INNER JOIN news_categories n1_ ON n1_.id = p2_.news_categories_id WHERE p0_.is_actu = 1 ORDER BY p0_.created_at DESC
Parameters:
[]
0.44 ms
(0.12%)
1
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.clefs AS clefs_3, t0.description AS description_4 FROM seo t0 WHERE t0.id IN (?)
Parameters:
[
  [
    36
  ]
]

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\Page No errors.
App\Entity\NewsCategories No errors.
App\Entity\User No errors.
App\Entity\Seo No errors.
App\Entity\MenuFooter No errors.
App\Entity\Blocs No errors.
App\Entity\Pages No errors.
App\Entity\Analytics No errors.
App\Entity\Rubrics No errors.
App\Entity\MenuItem No errors.
App\Entity\Menu No errors.