Query Metrics

58 Database Queries
19 Different statements
75.03 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
11.75 ms
(15.66%)
11
SELECT t0.id AS id_1, t0.text AS text_2, t0.url AS url_3, t0.subitem_position AS subitem_position_4, t0.type AS type_5, t0.svg_icon AS svg_icon_6, t0.parent_id AS parent_id_7, t8.id AS id_9, t8.position AS position_10, t8.menu_id AS menu_id_11, t8.menu_item_id AS menu_item_id_12 FROM menu_item t0 LEFT JOIN menu_item_position t8 ON t8.menu_item_id = t0.id WHERE t0.id = ?
Parameters:
[
  "0a9eb208-7cdf-4caa-b6a1-54926d8ffc52"
]
10.02 ms
(13.36%)
8
SELECT t0.id AS id_1, t0.text AS text_2, t0.url AS url_3, t0.subitem_position AS subitem_position_4, t0.type AS type_5, t0.svg_icon AS svg_icon_6, t0.parent_id AS parent_id_7, t8.id AS id_9, t8.position AS position_10, t8.menu_id AS menu_id_11, t8.menu_item_id AS menu_item_id_12 FROM menu_item t0 LEFT JOIN menu_item_position t8 ON t8.menu_item_id = t0.id WHERE t0.parent_id = ?
Parameters:
[
  "0a9eb208-7cdf-4caa-b6a1-54926d8ffc52"
]
7.15 ms
(9.53%)
4
SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22 FROM media__media t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  98
]
6.45 ms
(8.59%)
4
SELECT t0.id AS id_1, t0.position AS position_2, t0.menu_id AS menu_id_3, t0.menu_item_id AS menu_item_id_4 FROM menu_item_position t0 WHERE t0.menu_id = ? ORDER BY t0.position ASC
Parameters:
[
  "aa1f46fc-bb32-4473-a8c6-c9c5c550d654"
]
6.24 ms
(8.32%)
4
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.source AS source_3, t0.last_modified AS last_modified_4, t0.type AS type_5, t0.variables AS variables_6 FROM template t0 WHERE t0.id = ?
Parameters:
[
  "85d3fbb5-4fc6-45e7-bde3-bc1871a509b1"
]
6.04 ms
(8.04%)
6
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.source AS source_3, t0.last_modified AS last_modified_4, t0.type AS type_5, t0.variables AS variables_6 FROM template t0 WHERE t0.filename = ? LIMIT 1
Parameters:
[
  "content_hero_block.html.twig"
]
5.71 ms
(7.60%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.field_value AS field_value_3, t0.type AS type_4, t0.field_type AS field_type_5, t0.block_id AS block_id_6, t0.media_id AS media_id_7 FROM block_item t0 WHERE t0.block_id = ? ORDER BY t0.type ASC
Parameters:
[
  "7141cafa-97e6-46c5-a53e-34cd3d8db289"
]
4.00 ms
(5.34%)
4
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.template_id AS template_id_4 FROM menu t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "header_menu"
]
3.80 ms
(5.06%)
3
SELECT s0_.id AS id_0, s0_.header_button_text AS header_button_text_1, s0_.header_button_url AS header_button_url_2, s0_.facebook_url AS facebook_url_3, s0_.linkedin_url AS linkedin_url_4, s0_.twitter_url AS twitter_url_5, s0_.youtube_url AS youtube_url_6, s0_.instagram_url AS instagram_url_7, s0_.tiktok_url AS tiktok_url_8, s0_.company_name AS company_name_9, s0_.company_url AS company_url_10, s0_.enable_quizzes AS enable_quizzes_11, s0_.quiz_button_text_upper AS quiz_button_text_upper_12, s0_.quiz_button_text_lower AS quiz_button_text_lower_13, s0_.quiz_button_url AS quiz_button_url_14, s0_.job_recruitment_potential_long_text AS job_recruitment_potential_long_text_15, s0_.job_recruitment_potential_short_text AS job_recruitment_potential_short_text_16, s0_.header_logo_id AS header_logo_id_17, s0_.footer_logo_id AS footer_logo_id_18, s0_.company_logo_id AS company_logo_id_19, s0_.quizzes_image_id AS quizzes_image_id_20 FROM settings s0_ LIMIT 1
Parameters:
[]
3.60 ms
(4.80%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.field_value AS field_value_3, t0.field_type AS field_type_4, t0.datetime_value AS datetime_value_5, t0.content_id AS content_id_6 FROM content_field t0 WHERE t0.content_id = ?
Parameters:
[
  "12bdf4fe-48b7-4660-969f-71b559ed7d95"
]
1.83 ms
(2.44%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.meta_description AS meta_description_3, t0.slug AS slug_4, t0.number_one AS number_one_5, t0.number_two AS number_two_6, t0.number_three AS number_three_7, t0.text_one AS text_one_8, t0.text_two AS text_two_9, t0.text_three AS text_three_10, t0.featured_video AS featured_video_11, t0.featured_video_title AS featured_video_title_12, t0.featured_video_text AS featured_video_text_13, t0.job_board_button AS job_board_button_14, t0.presentation AS presentation_15, t0.svg_icon AS svg_icon_16, t0.template_id AS template_id_17, t0.featured_image_id AS featured_image_id_18, t0.cover_image_id AS cover_image_id_19 FROM sector t0 INNER JOIN content_sector ON t0.id = content_sector.sector_id WHERE content_sector.content_id = ?
Parameters:
[
  "12bdf4fe-48b7-4660-969f-71b559ed7d95"
]
1.67 ms
(2.23%)
1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.meta_description AS meta_description_2, c0_.description AS description_3, c0_.type AS type_4, c0_.is_featured AS is_featured_5, c0_.created_at AS created_at_6, c0_.status AS status_7, c0_.keywords AS keywords_8, c0_.job_board_button AS job_board_button_9, c0_.featured_video AS featured_video_10, c0_.skills AS skills_11, c0_.last_modified AS last_modified_12, c0_.slug AS slug_13, c0_.region AS region_14, c0_.recruitment_potential AS recruitment_potential_15, c0_.job_type AS job_type_16, c0_.sub_sector AS sub_sector_17, c0_.created_by_id AS created_by_id_18, c0_.featured_image_id AS featured_image_id_19, c0_.cover_image_id AS cover_image_id_20, c0_.template_id AS template_id_21, c0_.clone_id AS clone_id_22, c0_.cloned_from_id AS cloned_from_id_23 FROM content c0_ WHERE c0_.slug = ? AND c0_.type = ? AND EXISTS (SELECT 1 FROM content_sector c1_ WHERE c1_.content_id = c0_.id AND c1_.sector_id IN (?))
Parameters:
[
  "responsable-technique"
  1
  Ramsey\Uuid\Lazy\LazyUuidFromString {#2349
    __toString(): "904d1689-716f-4d21-a4c5-125e3b825b6c"
  }
]
1.25 ms
(1.66%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.compatible_pages AS compatible_pages_4, t0.template_id AS template_id_5 FROM block t0 WHERE t0.id = ?
Parameters:
[
  "7141cafa-97e6-46c5-a53e-34cd3d8db289"
]
1.08 ms
(1.44%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.meta_description AS meta_description_3, t0.type AS type_4, t0.title AS title_5, t0.number_one AS number_one_6, t0.number_two AS number_two_7, t0.number_three AS number_three_8, t0.featured_video AS featured_video_9, t0.featured_video_title AS featured_video_title_10, t0.featured_video_text AS featured_video_text_11, t0.job_board_button AS job_board_button_12, t0.text_block_one AS text_block_one_13, t0.slug AS slug_14, t0.identifier AS identifier_15, t0.header_title AS header_title_16, t0.heading AS heading_17, t0.icon_one AS icon_one_18, t0.icon_two AS icon_two_19, t0.icon_three AS icon_three_20, t0.text_figure_one AS text_figure_one_21, t0.text_figure_two AS text_figure_two_22, t0.text_figure_three AS text_figure_three_23, t0.view_box_one AS view_box_one_24, t0.view_box_two AS view_box_two_25, t0.view_box_three AS view_box_three_26, t0.template_id AS template_id_27, t0.featured_image_id AS featured_image_id_28, t0.header_image_id AS header_image_id_29 FROM page t0 WHERE t0.template_id = ? LIMIT 1
Parameters:
[
  "85d3fbb5-4fc6-45e7-bde3-bc1871a509b1"
]
1.06 ms
(1.41%)
1
SELECT t0.id AS id_1, t0.code AS code_2 FROM riasec t0 INNER JOIN content_riasec ON t0.id = content_riasec.riasec_id WHERE content_riasec.content_id = ?
Parameters:
[
  "12bdf4fe-48b7-4660-969f-71b559ed7d95"
]
0.94 ms
(1.25%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.background AS background_4 FROM category t0 INNER JOIN content_category ON t0.id = content_category.category_id WHERE content_category.content_id = ?
Parameters:
[
  "12bdf4fe-48b7-4660-969f-71b559ed7d95"
]
0.91 ms
(1.22%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.api_endpoint AS api_endpoint_3, t0.title AS title_4, t0.has_pagination AS has_pagination_5, t0.text_block_name AS text_block_name_6, t0.page_id AS page_id_7, t0.block_id AS block_id_8 FROM block_position t0 WHERE t0.page_id = ? ORDER BY t0.position ASC
Parameters:
[
  "3b8d8198-8d98-46e6-92f4-2f4a7d52f7d7"
]
0.88 ms
(1.17%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.meta_description AS meta_description_3, t0.slug AS slug_4, t0.number_one AS number_one_5, t0.number_two AS number_two_6, t0.number_three AS number_three_7, t0.text_one AS text_one_8, t0.text_two AS text_two_9, t0.text_three AS text_three_10, t0.featured_video AS featured_video_11, t0.featured_video_title AS featured_video_title_12, t0.featured_video_text AS featured_video_text_13, t0.job_board_button AS job_board_button_14, t0.presentation AS presentation_15, t0.svg_icon AS svg_icon_16, t0.template_id AS template_id_17, t0.featured_image_id AS featured_image_id_18, t0.cover_image_id AS cover_image_id_19 FROM sector t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "distributeurs-conseils-hors-domicile-grossistes-en-boissons"
]
0.66 ms
(0.88%)
1
SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
  43
]

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.