Query Metrics
9
Database Queries
7
Different statements
21.84 ms
Query time
0
Invalid entities
557
Managed entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.84 ms |
SELECT t0.id AS id_1, t0.settings_key AS settings_key_2, t0.settings_val AS settings_val_3 FROM setting t0
Parameters:
[] |
2 | 0.72 ms |
SELECT t0.id AS id_1, t0.settings_key AS settings_key_2, t0.settings_val AS settings_val_3 FROM setting t0
Parameters:
[] |
3 | 2.24 ms |
SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.name AS name_3, t0.`lead` AS lead_4, t0.content AS content_5, t0.right_column AS right_column_6, t0.gallery_content AS gallery_content_7, t0.type_key AS type_key_8, t0.visible AS visible_9, t0.priority_news AS priority_news_10, t0.full_width AS full_width_11, t0.hide_right_column AS hide_right_column_12, t0.hide_submenu AS hide_submenu_13, t0.show_subpage_panels AS show_subpage_panels_14, t0.show_subpage_links AS show_subpage_links_15, t0.show_subpage_news AS show_subpage_news_16, t0.use_parent_header AS use_parent_header_17, t0.list_order AS list_order_18, t0.seo_title AS seo_title_19, t0.custom_tabs AS custom_tabs_20, t0.seo_keywords AS seo_keywords_21, t0.seo_description AS seo_description_22, t0.seo_url AS seo_url_23, t0.parent_id AS parent_id_24, t0.image_name AS image_name_25, t0.image_alt AS image_alt_26, t0.image2_name AS image2_name_27, t0.image2_alt AS image2_alt_28, t0.image3_name AS image3_name_29, t0.image3_alt AS image3_alt_30, t0.heading AS heading_31, t0.external_link AS external_link_32, t0.page_date AS page_date_33, t0.parent_id AS parent_id_34 FROM page t0 WHERE t0.id = ?
Parameters:
[
"1123"
]
|
4 | 0.91 ms |
SELECT t0.id AS id_1, t0.settings_key AS settings_key_2, t0.settings_val AS settings_val_3 FROM setting t0
Parameters:
[] |
5 | 3.71 ms |
SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.deletedAt AS deletedAt_3, t0.name AS name_4, t0.field0 AS field0_5, t0.field1 AS field1_6, t0.field2 AS field2_7, t0.field3 AS field3_8, t0.field4 AS field4_9, t0.field5 AS field5_10, t0.field6 AS field6_11, t0.field7 AS field7_12, t0.field8 AS field8_13, t0.field9 AS field9_14, t0.field10 AS field10_15, t0.field11 AS field11_16, t0.file1_name AS file1_name_17, t0.file2_name AS file2_name_18, t0.type_key AS type_key_19, t0.visible AS visible_20, t0.list_order AS list_order_21 FROM dictionary t0 WHERE t0.visible = ? AND ((t0.deletedAt IS NULL)) ORDER BY t0.list_order ASC
Parameters:
[
1
]
|
6 | 1.11 ms |
SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.deletedAt AS deletedAt_3, t0.name AS name_4, t0.field0 AS field0_5, t0.field1 AS field1_6, t0.field2 AS field2_7, t0.field3 AS field3_8, t0.field4 AS field4_9, t0.field5 AS field5_10, t0.field6 AS field6_11, t0.field7 AS field7_12, t0.field8 AS field8_13, t0.field9 AS field9_14, t0.field10 AS field10_15, t0.field11 AS field11_16, t0.file1_name AS file1_name_17, t0.file2_name AS file2_name_18, t0.type_key AS type_key_19, t0.visible AS visible_20, t0.list_order AS list_order_21 FROM dictionary t0 WHERE t0.visible = ? AND t0.type_key = ? AND ((t0.deletedAt IS NULL)) ORDER BY t0.field2 DESC
Parameters:
[ 1 "events" ] |
7 | 7.82 ms |
SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.name AS name_3, t0.`lead` AS lead_4, t0.content AS content_5, t0.right_column AS right_column_6, t0.gallery_content AS gallery_content_7, t0.type_key AS type_key_8, t0.visible AS visible_9, t0.priority_news AS priority_news_10, t0.full_width AS full_width_11, t0.hide_right_column AS hide_right_column_12, t0.hide_submenu AS hide_submenu_13, t0.show_subpage_panels AS show_subpage_panels_14, t0.show_subpage_links AS show_subpage_links_15, t0.show_subpage_news AS show_subpage_news_16, t0.use_parent_header AS use_parent_header_17, t0.list_order AS list_order_18, t0.seo_title AS seo_title_19, t0.custom_tabs AS custom_tabs_20, t0.seo_keywords AS seo_keywords_21, t0.seo_description AS seo_description_22, t0.seo_url AS seo_url_23, t0.parent_id AS parent_id_24, t0.image_name AS image_name_25, t0.image_alt AS image_alt_26, t0.image2_name AS image2_name_27, t0.image2_alt AS image2_alt_28, t0.image3_name AS image3_name_29, t0.image3_alt AS image3_alt_30, t0.heading AS heading_31, t0.external_link AS external_link_32, t0.page_date AS page_date_33, t0.parent_id AS parent_id_34 FROM page t0 WHERE t0.visible = ? ORDER BY t0.list_order ASC
Parameters:
[
1
]
|
8 | 2.72 ms |
SELECT p0_.id AS id_0, p0_.updated_at AS updated_at_1, p0_.name AS name_2, p0_.`lead` AS lead_3, p0_.content AS content_4, p0_.right_column AS right_column_5, p0_.gallery_content AS gallery_content_6, p0_.type_key AS type_key_7, p0_.visible AS visible_8, p0_.priority_news AS priority_news_9, p0_.full_width AS full_width_10, p0_.hide_right_column AS hide_right_column_11, p0_.hide_submenu AS hide_submenu_12, p0_.show_subpage_panels AS show_subpage_panels_13, p0_.show_subpage_links AS show_subpage_links_14, p0_.show_subpage_news AS show_subpage_news_15, p0_.use_parent_header AS use_parent_header_16, p0_.list_order AS list_order_17, p0_.seo_title AS seo_title_18, p0_.custom_tabs AS custom_tabs_19, p0_.seo_keywords AS seo_keywords_20, p0_.seo_description AS seo_description_21, p0_.seo_url AS seo_url_22, p0_.parent_id AS parent_id_23, p0_.image_name AS image_name_24, p0_.image_alt AS image_alt_25, p0_.image2_name AS image2_name_26, p0_.image2_alt AS image2_alt_27, p0_.image3_name AS image3_name_28, p0_.image3_alt AS image3_alt_29, p0_.heading AS heading_30, p0_.external_link AS external_link_31, p0_.page_date AS page_date_32, p0_.parent_id AS parent_id_33 FROM page p0_ WHERE p0_.type_key = ? AND p0_.visible = ? AND p0_.page_date <= ? ORDER BY p0_.priority_news DESC, p0_.page_date DESC, p0_.id ASC
Parameters:
[ "news" 1 "2025-07-23 18:44:04" ] |
9 | 0.78 ms |
SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.name AS name_3, t0.`lead` AS lead_4, t0.content AS content_5, t0.right_column AS right_column_6, t0.gallery_content AS gallery_content_7, t0.type_key AS type_key_8, t0.visible AS visible_9, t0.priority_news AS priority_news_10, t0.full_width AS full_width_11, t0.hide_right_column AS hide_right_column_12, t0.hide_submenu AS hide_submenu_13, t0.show_subpage_panels AS show_subpage_panels_14, t0.show_subpage_links AS show_subpage_links_15, t0.show_subpage_news AS show_subpage_news_16, t0.use_parent_header AS use_parent_header_17, t0.list_order AS list_order_18, t0.seo_title AS seo_title_19, t0.custom_tabs AS custom_tabs_20, t0.seo_keywords AS seo_keywords_21, t0.seo_description AS seo_description_22, t0.seo_url AS seo_url_23, t0.parent_id AS parent_id_24, t0.image_name AS image_name_25, t0.image_alt AS image_alt_26, t0.image2_name AS image2_name_27, t0.image2_alt AS image2_alt_28, t0.image3_name AS image3_name_29, t0.image3_alt AS image3_alt_30, t0.heading AS heading_31, t0.external_link AS external_link_32, t0.page_date AS page_date_33, t0.parent_id AS parent_id_34 FROM page t0 WHERE t0.parent_id = ? ORDER BY t0.list_order ASC
Parameters:
[
1123
]
|
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.
Managed Entities
default entity manager
Class | Amount of managed objects |
---|---|
App\Entity\Dictionary | 303 |
App\Entity\Page | 176 |
App\Entity\Setting | 78 |
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Page | No errors. |
App\Entity\Setting | No errors. |
App\Entity\Dictionary | No errors. |