Query Metrics

9 Database Queries
4 Different statements
8.84 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
5.52 ms
(62.41%)
2
SELECT p0_.id AS id_0, p0_.item_order AS item_order_1, p0_.json_data AS json_data_2, p0_.json_data_preview AS json_data_preview_3, p1_.id AS id_4, p1_.name AS name_5, p1_.active AS active_6, p1_.has_newsletter AS has_newsletter_7, p1_.slug AS slug_8, p1_.type AS type_9, p1_.slugs AS slugs_10, p1_.metas AS metas_11, p1_.has_form_application AS has_form_application_12, b2_.id AS id_13, b2_.name AS name_14, b2_.path AS path_15, b2_.type AS type_16, b2_.image AS image_17, b2_.subBlock AS subBlock_18, b2_.form_type AS form_type_19, p0_.block_id AS block_id_20, p0_.page_id AS page_id_21, p0_.language_id AS language_id_22, b2_.module_id AS module_id_23 FROM page_block p0_ LEFT JOIN page p1_ ON p0_.page_id = p1_.id LEFT JOIN block b2_ ON p0_.block_id = b2_.id WHERE p1_.slug = ? AND p0_.block_id IS NOT NULL AND p1_.type = ? AND p0_.json_data LIKE ? ORDER BY p0_.item_order ASC
Parameters:
[
  "header"
  "header"
  "%"lang_block":"fr"%"
]
1.79 ms
(20.29%)
5
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.has_newsletter AS has_newsletter_4, t0.slug AS slug_5, t0.type AS type_6, t0.slugs AS slugs_7, t0.metas AS metas_8, t0.has_form_application AS has_form_application_9 FROM page t0 WHERE t0.id = ?
Parameters:
[
  3
]
1.16 ms
(13.09%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.active AS active_2, p0_.has_newsletter AS has_newsletter_3, p0_.slug AS slug_4, p0_.type AS type_5, p0_.slugs AS slugs_6, p0_.metas AS metas_7, p0_.has_form_application AS has_form_application_8 FROM page p0_ WHERE p0_.slug LIKE ? AND p0_.active = 1
Parameters:
[
  "create-appointment"
]
0.37 ms
(4.21%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.json_data AS json_data_3 FROM menu t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "main_menu"
]

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\PageBlock No errors.
App\Entity\Block No errors.
App\Entity\Language No errors.
App\Entity\Module No errors.
App\Entity\Content No errors.