Query Metrics
37
Database Queries
8
Different statements
19.45 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.75 ms |
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:
[] |
| 2 | 0.69 ms |
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 | 0.53 ms |
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_mobile"
]
|
| 4 | 0.47 ms |
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:
[
"dfc8e0f2-b0d5-47c8-9f1f-3cc87c44c025"
]
|
| 5 | 0.55 ms |
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:
[
"header.html.twig"
]
|
| 6 | 0.79 ms |
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
]
|
| 7 | 0.68 ms |
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"
]
|
| 8 | 0.60 ms |
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"
]
|
| 9 | 0.60 ms |
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"
]
|
| 10 | 0.51 ms |
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:
[
"51839ab5-c33b-49f9-9e4a-0a022b9dabf8"
]
|
| 11 | 0.61 ms |
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:
[
"8d8fc9ee-1a47-41fb-8029-094cb6947c90"
]
|
| 12 | 1.30 ms |
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:
[
"f912c3e4-d87c-4719-9ee5-f6705c9c36aa"
]
|
| 13 | 0.51 ms |
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
]
|
| 14 | 0.48 ms |
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:
[
"0630d741-b860-4f8b-a648-6d7ab8b7da22"
]
|
| 15 | 0.40 ms |
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:
[
"34452ed1-f42c-4b16-b61c-2a20e00ff736"
]
|
| 16 | 0.39 ms |
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:
[
"34452ed1-f42c-4b16-b61c-2a20e00ff736"
]
|
| 17 | 0.41 ms |
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:
[
"bda92b50-6efb-47ee-beb3-75d9168e040a"
]
|
| 18 | 0.37 ms |
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:
[
"bda92b50-6efb-47ee-beb3-75d9168e040a"
]
|
| 19 | 0.38 ms |
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:
[
"b4a57b9d-02a7-4cae-a628-02bd1c007833"
]
|
| 20 | 0.38 ms |
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:
[
"b4a57b9d-02a7-4cae-a628-02bd1c007833"
]
|
| 21 | 0.29 ms |
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:
[
"footer_menu_1"
]
|
| 22 | 0.28 ms |
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:
[
"footer_menu_2"
]
|
| 23 | 0.48 ms |
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:
[
"footer.html.twig"
]
|
| 24 | 0.83 ms |
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:
[
100
]
|
| 25 | 0.52 ms |
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:
[
"c51db180-2888-48d2-8e73-31993aca8001"
]
|
| 26 | 0.44 ms |
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:
[
"4703669b-dbaa-4982-be63-86dc52b1ba0e"
]
|
| 27 | 0.43 ms |
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:
[
"817e5a8b-b2e1-48a9-8bec-6484cf3fd86d"
]
|
| 28 | 0.47 ms |
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:
[
"817e5a8b-b2e1-48a9-8bec-6484cf3fd86d"
]
|
| 29 | 0.49 ms |
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:
[
"c78b76db-822e-4fcd-8aed-111015f69c6c"
]
|
| 30 | 0.50 ms |
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:
[
"c78b76db-822e-4fcd-8aed-111015f69c6c"
]
|
| 31 | 0.48 ms |
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:
[
"f46849e0-fa75-4df5-91ad-3f274cd4f046"
]
|
| 32 | 0.41 ms |
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:
[
"f46849e0-fa75-4df5-91ad-3f274cd4f046"
]
|
| 33 | 0.42 ms |
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:
[
"38d3121a-c7c7-4033-b023-c6d0386754a7"
]
|
| 34 | 0.39 ms |
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:
[
"38d3121a-c7c7-4033-b023-c6d0386754a7"
]
|
| 35 | 0.55 ms |
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:
[
101
]
|
| 36 | 0.61 ms |
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:
[
"base.html.twig"
]
|
| 37 | 0.46 ms |
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:
[
"base.html.twig"
]
|
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\Template | No errors. |
| App\Entity\Settings | No errors. |
| Sonata\MediaBundle\Entity\BaseMedia | No errors. |
| App\Entity\SonataMediaMedia | No errors. |
| App\Entity\Menu | No errors. |
| App\Entity\MenuItemPosition | No errors. |
| Sonata\MediaBundle\Entity\BaseGalleryItem | No errors. |
| App\Entity\SonataMediaGalleryItem | No errors. |
| App\Entity\MenuItem | No errors. |