https://carfit.staging.idp.lu/fr/jobs

Query Metrics

22 Database Queries
8 Different statements
15.10 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 4.73 ms
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"%"
]
2 3.71 ms
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:
[
  "footer"
  "footer"
  "%"lang_block":"fr"%"
]
3 0.39 ms
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_.slugs LIKE ? AND p0_.active = 1
Parameters:
[
  "%jobs%"
]
4 0.49 ms
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"
]
5 1.51 ms
SELECT c0_.id AS id_0, c0_.json AS json_1, c0_.language AS language_2, c0_.target AS target_3, c0_.json_preview AS json_preview_4, c0_.page_block_id AS page_block_id_5, c0_.block_children_id AS block_children_id_6 FROM content c0_ LEFT JOIN block_children b1_ ON c0_.block_children_id = b1_.id LEFT JOIN page_block p2_ ON c0_.page_block_id = p2_.id LEFT JOIN page p3_ ON p2_.page_id = p3_.id WHERE p3_.id = ? AND p2_.language_id = ?
Parameters:
[
  13
  1
]
6 0.36 ms
SELECT t0.id AS id_1, t0.item_order AS item_order_2, t0.json_data AS json_data_3, t0.json_data_preview AS json_data_preview_4, t0.block_id AS block_id_5, t0.page_id AS page_id_6, t0.language_id AS language_id_7 FROM page_block t0 WHERE t0.id = ?
Parameters:
[
  51
]
7 0.36 ms
SELECT t0.id AS id_1, t0.item_order AS item_order_2, t0.json_data AS json_data_3, t0.json_data_preview AS json_data_preview_4, t0.block_id AS block_id_5, t0.page_id AS page_id_6, t0.language_id AS language_id_7 FROM page_block t0 WHERE t0.id = ?
Parameters:
[
  54
]
8 0.23 ms
SELECT t0.id AS id_1, t0.item_order AS item_order_2, t0.json_data AS json_data_3, t0.json_data_preview AS json_data_preview_4, t0.block_id AS block_id_5, t0.page_id AS page_id_6, t0.language_id AS language_id_7 FROM page_block t0 WHERE t0.id = ?
Parameters:
[
  64
]
9 0.20 ms
SELECT t0.id AS id_1, t0.item_order AS item_order_2, t0.json_data AS json_data_3, t0.json_data_preview AS json_data_preview_4, t0.block_id AS block_id_5, t0.page_id AS page_id_6, t0.language_id AS language_id_7 FROM page_block t0 WHERE t0.id = ?
Parameters:
[
  181
]
10 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.type AS type_4, t0.image AS image_5, t0.subBlock AS subBlock_6, t0.form_type AS form_type_7, t0.module_id AS module_id_8 FROM block t0 WHERE t0.id = ?
Parameters:
[
  1
]
11 0.31 ms
SELECT t0.id AS id_1, t0.json_data AS json_data_2, t0.json_data_preview AS json_data_preview_3, t0.page_block_id AS page_block_id_4, t0.block_id AS block_id_5 FROM block_children t0 WHERE t0.page_block_id = ?
Parameters:
[
  51
]
12 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.type AS type_4, t0.image AS image_5, t0.subBlock AS subBlock_6, t0.form_type AS form_type_7, t0.module_id AS module_id_8 FROM block t0 WHERE t0.id = ?
Parameters:
[
  2
]
13 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.type AS type_4, t0.image AS image_5, t0.subBlock AS subBlock_6, t0.form_type AS form_type_7, t0.module_id AS module_id_8 FROM block t0 WHERE t0.id = ?
Parameters:
[
  21
]
14 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.type AS type_4, t0.image AS image_5, t0.subBlock AS subBlock_6, t0.form_type AS form_type_7, t0.module_id AS module_id_8 FROM block t0 WHERE t0.id = ?
Parameters:
[
  19
]
15 0.27 ms
SELECT t0.id AS id_1, t0.json_data AS json_data_2, t0.json_data_preview AS json_data_preview_3, t0.page_block_id AS page_block_id_4, t0.block_id AS block_id_5 FROM block_children t0 WHERE t0.page_block_id = ?
Parameters:
[
  54
]
16 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.type AS type_4, t0.image AS image_5, t0.subBlock AS subBlock_6, t0.form_type AS form_type_7, t0.module_id AS module_id_8 FROM block t0 WHERE t0.id = ?
Parameters:
[
  18
]
17 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.type AS type_4, t0.image AS image_5, t0.subBlock AS subBlock_6, t0.form_type AS form_type_7, t0.module_id AS module_id_8 FROM block t0 WHERE t0.id = ?
Parameters:
[
  20
]
18 0.41 ms
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
]
19 0.23 ms
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:
[
  4
]
20 0.21 ms
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:
[
  6
]
21 0.20 ms
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:
[
  8
]
22 0.20 ms
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:
[
  40
]

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\Language No errors.
App\Entity\Content No errors.
App\Entity\Menu No errors.
App\Entity\PageBlock No errors.
App\Entity\Page No errors.
App\Entity\Block No errors.
App\Entity\Module No errors.
App\Entity\BlockChildren No errors.
App\Entity\Timeline No errors.
App\Entity\BlockItem No errors.