GET https://mipe-website.erp-smb.com/blog/verification-de-la-verticalite-sur-chantier

Query Metrics

22 Database Queries
7 Different statements
11.96 ms Query time
0 Invalid entities
48 Managed entities

Grouped Statements

Show all queries

Time Count Info
5.23 ms
(43.72%)
15
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.section AS section_4, t0.type AS type_5 FROM setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "website_name"
]
2.49 ms
(20.79%)
2
SELECT m0_.id AS id_0, m0_.name AS name_1, m1_.id AS id_2, m1_.name AS name_3, m1_.position AS position_4, m1_.url AS url_5, m2_.id AS id_6, m2_.name AS name_7, m2_.position AS position_8, m2_.url AS url_9, p3_.id AS id_10, p3_.title AS title_11, p3_.thumbnail AS thumbnail_12, p3_.seo_title AS seo_title_13, p3_.slug AS slug_14, p3_.brief AS brief_15, p3_.content AS content_16, p3_.created_at AS created_at_17, p3_.updated_at AS updated_at_18, p4_.id AS id_19, p4_.title AS title_20, p4_.thumbnail AS thumbnail_21, p4_.seo_title AS seo_title_22, p4_.slug AS slug_23, p4_.brief AS brief_24, p4_.content AS content_25, p4_.created_at AS created_at_26, p4_.updated_at AS updated_at_27, m1_.menu_id AS menu_id_28, m1_.parent_id AS parent_id_29, m1_.page_id AS page_id_30, m2_.menu_id AS menu_id_31, m2_.parent_id AS parent_id_32, m2_.page_id AS page_id_33 FROM menu m0_ LEFT JOIN menu_item m1_ ON m0_.id = m1_.menu_id LEFT JOIN menu_item m2_ ON m1_.id = m2_.parent_id LEFT JOIN page p3_ ON m1_.page_id = p3_.id LEFT JOIN page p4_ ON m2_.page_id = p4_.id WHERE m0_.name = ? ORDER BY m1_.position ASC, m2_.position ASC
Parameters:
[
  "Header"
]
2.00 ms
(16.74%)
1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.brief AS brief_3, p0_.content AS content_4, p0_.source AS source_5, p0_.photo AS photo_6, p0_.seo_title AS seo_title_7, p0_.seo_desc AS seo_desc_8, p0_.published AS published_9, p0_.deleted_at AS deleted_at_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, c1_.id AS id_13, c1_.name AS name_14, c1_.slug AS slug_15, c1_.photo AS photo_16, c1_.description AS description_17, u2_.id AS id_18, u2_.email AS email_19, u2_.roles AS roles_20, u2_.password AS password_21, u2_.name AS name_22, u2_.gender AS gender_23, p0_.created_by_id AS created_by_id_24, c1_.parent_id AS parent_id_25 FROM post p0_ LEFT JOIN post_category p3_ ON p0_.id = p3_.post_id LEFT JOIN category c1_ ON c1_.id = p3_.category_id LEFT JOIN user u2_ ON p0_.created_by_id = u2_.id WHERE p0_.published = 1 AND p0_.slug = ?
Parameters:
[
  "verification-de-la-verticalite-sur-chantier"
]
0.74 ms
(6.23%)
1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.brief AS brief_3, p0_.content AS content_4, p0_.source AS source_5, p0_.photo AS photo_6, p0_.seo_title AS seo_title_7, p0_.seo_desc AS seo_desc_8, p0_.published AS published_9, p0_.deleted_at AS deleted_at_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.created_by_id AS created_by_id_13 FROM post p0_ WHERE p0_.updated_at > ? AND p0_.published = 1 ORDER BY p0_.updated_at ASC LIMIT 1
Parameters:
[
  "2025-08-21 16:27:58"
]
0.54 ms
(4.48%)
1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.brief AS brief_3, p0_.content AS content_4, p0_.source AS source_5, p0_.photo AS photo_6, p0_.seo_title AS seo_title_7, p0_.seo_desc AS seo_desc_8, p0_.published AS published_9, p0_.deleted_at AS deleted_at_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.created_by_id AS created_by_id_13 FROM post p0_ WHERE p0_.published = 1 ORDER BY p0_.updated_at DESC LIMIT 5
Parameters:
[]
0.48 ms
(4.05%)
1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.photo AS photo_3, c0_.description AS description_4, c0_.parent_id AS parent_id_5 FROM category c0_ WHERE c0_.parent_id IS NULL ORDER BY c0_.name ASC
Parameters:
[]
0.48 ms
(3.99%)
1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.brief AS brief_3, p0_.content AS content_4, p0_.source AS source_5, p0_.photo AS photo_6, p0_.seo_title AS seo_title_7, p0_.seo_desc AS seo_desc_8, p0_.published AS published_9, p0_.deleted_at AS deleted_at_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.created_by_id AS created_by_id_13 FROM post p0_ WHERE p0_.updated_at < ? AND p0_.published = 1 ORDER BY p0_.updated_at DESC LIMIT 1
Parameters:
[
  "2025-08-21 16:27:58"
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\MenuItem 20
App\Entity\Setting 15
App\Entity\Post 5
App\Entity\Page 3
App\Entity\Category 2
App\Entity\Menu 2
App\Entity\User 1

Entities Mapping

Class Mapping errors
App\Entity\Post No errors.
App\Entity\Category No errors.
App\Entity\User No errors.
App\Entity\Media No errors.
App\Entity\Setting No errors.
App\Entity\Menu No errors.
App\Entity\MenuItem No errors.
App\Entity\Page No errors.
App\Entity\Section No errors.