Query Metrics
71
Database Queries
17
Different statements
100.99 ms
Query time
0
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
37.31 ms (36.94%) |
26 |
SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4, t0.type AS type_5, t0.title AS title_6, t0.fixed_header_title AS fixed_header_title_7, t0.body AS body_8, t0.lft AS lft_9, t0.lvl AS lvl_10, t0.rgt AS rgt_11, t0.symlink_variable_pattern AS symlink_variable_pattern_12, t0.show_in_menu AS show_in_menu_13, t0.alias AS alias_14, t0.deletable AS deletable_15, t0.class AS class_16, t0.body_class AS body_class_17, t0.breadcrumbs AS breadcrumbs_18, t0.controller AS controller_19, t0.feature AS feature_20, t0.icon_class AS icon_class_21, t0.hide_title AS hide_title_22, t0.robots AS robots_23, t0.concept AS concept_24, t0.target AS target_25, t0.parent_id AS parent_id_26, t0.symlink_id AS symlink_id_27, t0.mega_menu_item_id AS mega_menu_item_id_28, t0.hero_configuration_id AS hero_configuration_id_29, t0.connexys_page_configuration_id AS connexys_page_configuration_id_30 FROM page t0 WHERE t0.parent_id = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.lft ASC
Parameters:
[
67
]
|
|
14.43 ms (14.29%) |
12 |
SELECT t0.id AS id_1, t0.`name` AS name_2, t0.defaults AS defaults_3, t0.staticPrefix AS staticPrefix_4, t0.variable_pattern AS variable_pattern_5, t0.requirements AS requirements_6, t0.options AS options_7, t0.host AS host_8, t0.schemes AS schemes_9, t0.`methods` AS methods_10, t0.`condition` AS condition_11, t0.locale AS locale_12, t0.page_id AS page_id_13 FROM route t0 WHERE t0.page_id = ?
Parameters:
[
123
]
|
|
6.81 ms (6.74%) |
5 |
SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4, t0.type AS type_5, t0.title AS title_6, t0.fixed_header_title AS fixed_header_title_7, t0.body AS body_8, t0.lft AS lft_9, t0.lvl AS lvl_10, t0.rgt AS rgt_11, t0.symlink_variable_pattern AS symlink_variable_pattern_12, t0.show_in_menu AS show_in_menu_13, t0.alias AS alias_14, t0.deletable AS deletable_15, t0.class AS class_16, t0.body_class AS body_class_17, t0.breadcrumbs AS breadcrumbs_18, t0.controller AS controller_19, t0.feature AS feature_20, t0.icon_class AS icon_class_21, t0.hide_title AS hide_title_22, t0.robots AS robots_23, t0.concept AS concept_24, t0.target AS target_25, t0.parent_id AS parent_id_26, t0.symlink_id AS symlink_id_27, t0.mega_menu_item_id AS mega_menu_item_id_28, t0.hero_configuration_id AS hero_configuration_id_29, t0.connexys_page_configuration_id AS connexys_page_configuration_id_30 FROM page t0 WHERE t0.alias = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
"header_navigation"
]
|
|
6.46 ms (6.40%) |
4 |
SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4, t0.type AS type_5, t0.title AS title_6, t0.fixed_header_title AS fixed_header_title_7, t0.body AS body_8, t0.lft AS lft_9, t0.lvl AS lvl_10, t0.rgt AS rgt_11, t0.symlink_variable_pattern AS symlink_variable_pattern_12, t0.show_in_menu AS show_in_menu_13, t0.alias AS alias_14, t0.deletable AS deletable_15, t0.class AS class_16, t0.body_class AS body_class_17, t0.breadcrumbs AS breadcrumbs_18, t0.controller AS controller_19, t0.feature AS feature_20, t0.icon_class AS icon_class_21, t0.hide_title AS hide_title_22, t0.robots AS robots_23, t0.concept AS concept_24, t0.target AS target_25, t0.parent_id AS parent_id_26, t0.symlink_id AS symlink_id_27, t0.mega_menu_item_id AS mega_menu_item_id_28, t0.hero_configuration_id AS hero_configuration_id_29, t0.connexys_page_configuration_id AS connexys_page_configuration_id_30 FROM page t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
123
]
|
|
5.26 ms (5.21%) |
4 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.location AS location_3, t0.script AS script_4, t0.type AS type_5 FROM google_tag_manager t0 WHERE t0.location = ?
Parameters:
[
"heading_start"
]
|
|
5.21 ms (5.16%) |
3 |
SELECT p0_.meta_title AS meta_title_0, p0_.meta_description AS meta_description_1, p0_.id AS id_2, p0_.deleted_at AS deleted_at_3, p0_.type AS type_4, p0_.title AS title_5, p0_.fixed_header_title AS fixed_header_title_6, p0_.body AS body_7, p0_.lft AS lft_8, p0_.lvl AS lvl_9, p0_.rgt AS rgt_10, p0_.symlink_variable_pattern AS symlink_variable_pattern_11, p0_.show_in_menu AS show_in_menu_12, p0_.alias AS alias_13, p0_.deletable AS deletable_14, p0_.class AS class_15, p0_.body_class AS body_class_16, p0_.breadcrumbs AS breadcrumbs_17, p0_.controller AS controller_18, p0_.feature AS feature_19, p0_.icon_class AS icon_class_20, p0_.hide_title AS hide_title_21, p0_.robots AS robots_22, p0_.concept AS concept_23, p0_.target AS target_24, r1_.id AS id_25, r1_.`name` AS name_26, r1_.defaults AS defaults_27, r1_.staticPrefix AS staticPrefix_28, r1_.variable_pattern AS variable_pattern_29, r1_.requirements AS requirements_30, r1_.options AS options_31, r1_.host AS host_32, r1_.schemes AS schemes_33, r1_.`methods` AS methods_34, r1_.`condition` AS condition_35, r1_.locale AS locale_36, p0_.parent_id AS parent_id_37, p0_.symlink_id AS symlink_id_38, p0_.mega_menu_item_id AS mega_menu_item_id_39, p0_.hero_configuration_id AS hero_configuration_id_40, p0_.connexys_page_configuration_id AS connexys_page_configuration_id_41, r1_.page_id AS page_id_42 FROM page p0_ LEFT JOIN route r1_ ON p0_.id = r1_.page_id WHERE (p0_.parent_id = ? AND p0_.show_in_menu = 1) AND (p0_.deleted_at IS NULL) ORDER BY p0_.lft ASC
Parameters:
[
2
]
|
|
4.44 ms (4.39%) |
4 |
SELECT t0.name AS name_1, t0.section AS section_2, t0.value AS value_3, t0.type AS type_4 FROM configuration_setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"site_open_graph_image"
]
|
|
3.63 ms (3.60%) |
1 |
SELECT p0_.meta_title AS meta_title_0, p0_.meta_description AS meta_description_1, p0_.id AS id_2, p0_.deleted_at AS deleted_at_3, p0_.type AS type_4, p0_.title AS title_5, p0_.fixed_header_title AS fixed_header_title_6, p0_.body AS body_7, p0_.lft AS lft_8, p0_.lvl AS lvl_9, p0_.rgt AS rgt_10, p0_.symlink_variable_pattern AS symlink_variable_pattern_11, p0_.show_in_menu AS show_in_menu_12, p0_.alias AS alias_13, p0_.deletable AS deletable_14, p0_.class AS class_15, p0_.body_class AS body_class_16, p0_.breadcrumbs AS breadcrumbs_17, p0_.controller AS controller_18, p0_.feature AS feature_19, p0_.icon_class AS icon_class_20, p0_.hide_title AS hide_title_21, p0_.robots AS robots_22, p0_.concept AS concept_23, p0_.target AS target_24, r1_.id AS id_25, r1_.`name` AS name_26, r1_.defaults AS defaults_27, r1_.staticPrefix AS staticPrefix_28, r1_.variable_pattern AS variable_pattern_29, r1_.requirements AS requirements_30, r1_.options AS options_31, r1_.host AS host_32, r1_.schemes AS schemes_33, r1_.`methods` AS methods_34, r1_.`condition` AS condition_35, r1_.locale AS locale_36, p0_.parent_id AS parent_id_37, p0_.symlink_id AS symlink_id_38, p0_.mega_menu_item_id AS mega_menu_item_id_39, p0_.hero_configuration_id AS hero_configuration_id_40, p0_.connexys_page_configuration_id AS connexys_page_configuration_id_41, r1_.page_id AS page_id_42 FROM page p0_ LEFT JOIN route r1_ ON p0_.id = r1_.page_id WHERE (p0_.rgt < 178 AND p0_.lft > 119 AND p0_.show_in_menu = 1) AND (p0_.deleted_at IS NULL) ORDER BY p0_.lft ASC
Parameters:
[] |
|
2.72 ms (2.69%) |
2 |
SELECT f0_.name AS name_0, f0_.active AS active_1 FROM feature f0_
Parameters:
[] |
|
2.66 ms (2.63%) |
2 |
SELECT t0.id AS id_1, t0.`name` AS name_2, t0.defaults AS defaults_3, t0.staticPrefix AS staticPrefix_4, t0.variable_pattern AS variable_pattern_5, t0.requirements AS requirements_6, t0.options AS options_7, t0.host AS host_8, t0.schemes AS schemes_9, t0.`methods` AS methods_10, t0.`condition` AS condition_11, t0.locale AS locale_12, t0.page_id AS page_id_13 FROM route t0 WHERE t0.`name` = ? LIMIT 1
Parameters:
[
"aanbiedingen"
]
|
|
2.36 ms (2.34%) |
2 |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.file_size AS file_size_3, t0.file_mime_type AS file_mime_type_4, t0.meta_information AS meta_information_5, t0.updated_at AS updated_at_6, t0.external_id AS external_id_7, t0.folder_id AS folder_id_8 FROM asset t0 WHERE t0.id = ?
Parameters:
[
"924"
]
|
|
1.82 ms (1.81%) |
1 |
SELECT DATABASE()
Parameters:
[] |
|
1.79 ms (1.78%) |
1 |
SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4, t0.type AS type_5, t0.title AS title_6, t0.fixed_header_title AS fixed_header_title_7, t0.body AS body_8, t0.lft AS lft_9, t0.lvl AS lvl_10, t0.rgt AS rgt_11, t0.symlink_variable_pattern AS symlink_variable_pattern_12, t0.show_in_menu AS show_in_menu_13, t0.alias AS alias_14, t0.deletable AS deletable_15, t0.class AS class_16, t0.body_class AS body_class_17, t0.breadcrumbs AS breadcrumbs_18, t0.controller AS controller_19, t0.feature AS feature_20, t0.icon_class AS icon_class_21, t0.hide_title AS hide_title_22, t0.robots AS robots_23, t0.concept AS concept_24, t0.target AS target_25, t0.parent_id AS parent_id_26, t0.symlink_id AS symlink_id_27, t0.mega_menu_item_id AS mega_menu_item_id_28, t0.hero_configuration_id AS hero_configuration_id_29, t0.connexys_page_configuration_id AS connexys_page_configuration_id_30 FROM page t0 WHERE t0.id = ?
Parameters:
[
45
]
|
|
1.69 ms (1.67%) |
1 |
SELECT p0_.meta_title AS meta_title_0, p0_.meta_description AS meta_description_1, p0_.id AS id_2, p0_.deleted_at AS deleted_at_3, p0_.type AS type_4, p0_.title AS title_5, p0_.fixed_header_title AS fixed_header_title_6, p0_.body AS body_7, p0_.lft AS lft_8, p0_.lvl AS lvl_9, p0_.rgt AS rgt_10, p0_.symlink_variable_pattern AS symlink_variable_pattern_11, p0_.show_in_menu AS show_in_menu_12, p0_.alias AS alias_13, p0_.deletable AS deletable_14, p0_.class AS class_15, p0_.body_class AS body_class_16, p0_.breadcrumbs AS breadcrumbs_17, p0_.controller AS controller_18, p0_.feature AS feature_19, p0_.icon_class AS icon_class_20, p0_.hide_title AS hide_title_21, p0_.robots AS robots_22, p0_.concept AS concept_23, p0_.target AS target_24, r1_.id AS id_25, r1_.`name` AS name_26, r1_.defaults AS defaults_27, r1_.staticPrefix AS staticPrefix_28, r1_.variable_pattern AS variable_pattern_29, r1_.requirements AS requirements_30, r1_.options AS options_31, r1_.host AS host_32, r1_.schemes AS schemes_33, r1_.`methods` AS methods_34, r1_.`condition` AS condition_35, r1_.locale AS locale_36, p0_.parent_id AS parent_id_37, p0_.symlink_id AS symlink_id_38, p0_.mega_menu_item_id AS mega_menu_item_id_39, p0_.hero_configuration_id AS hero_configuration_id_40, p0_.connexys_page_configuration_id AS connexys_page_configuration_id_41, r1_.page_id AS page_id_42 FROM page p0_ LEFT JOIN route r1_ ON p0_.id = r1_.page_id WHERE (p0_.rgt < 180 AND p0_.lft > 179 AND p0_.show_in_menu = 1) AND (p0_.deleted_at IS NULL) ORDER BY p0_.lft ASC
Parameters:
[] |
|
1.63 ms (1.61%) |
1 |
SELECT t0.id AS id_1, t0.value AS value_2, t0.appearance AS appearance_3 FROM tag t0 INNER JOIN page_tag ON t0.id = page_tag.tag_id WHERE page_tag.page_id = ?
Parameters:
[
45
]
|
|
1.47 ms (1.46%) |
1 |
SELECT t0.id AS id_1, t0.source AS source_2, t0.destination AS destination_3, t0.is_permanent AS is_permanent_4 FROM redirect t0 WHERE t0.source = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
"/aanbiedingen"
]
|
|
1.31 ms (1.29%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.score AS score_4, t0.message AS message_5, t0.review_fields AS review_fields_6, t0.external_url AS external_url_7, t0.external_id AS external_id_8, t0.external_reference AS external_reference_9, t0.external_hash AS external_hash_10 FROM review t0
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| parent | doctrine.dbal.parent_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| parent | doctrine.orm.parent_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\CustomTranslation | No errors. |
| App\Entity\CompanyMatchUser | No errors. |
| App\Entity\CompanyMatch | No errors. |
| App\Entity\Vacancy | No errors. |
| App\Entity\WebServiceApiKey | No errors. |
| App\Entity\Redirect | No errors. |
| App\Entity\Route | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\RedirectRoute | No errors. |
| App\Entity\MegaMenuItem | No errors. |
| App\Entity\HeroConfiguration | No errors. |
| App\Entity\ConnexysPageConfiguration | No errors. |
| App\Entity\Tag | No errors. |
| App\Entity\ConfigurationSetting | No errors. |
| App\Entity\Feature | No errors. |
| App\Entity\Review | No errors. |
| App\Entity\Asset | No errors. |
| App\Entity\AssetFolder | No errors. |
| App\Entity\GoogleTagManager | No errors. |
parent entity manager
No loaded entities.