Query Metrics
66
Database Queries
27
Different statements
94.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
23.49 ms (24.97%) |
18 |
SELECT h0_.id AS id_0, h0_.lft AS lft_1, h0_.lvl AS lvl_2, h0_.rgt AS rgt_3, h0_.deleted AS deleted_4, h0_.hidden_from_nav AS hidden_from_nav_5, h0_.ref_entity_name AS ref_entity_name_6, h0_.internal_name AS internal_name_7, h1_.id AS id_8, h1_.lang AS lang_9, h1_.online AS online_10, h1_.title AS title_11, h1_.slug AS slug_12, h1_.url AS url_13, h1_.weight AS weight_14, h1_.created AS created_15, h1_.updated AS updated_16, h2_.id AS id_17, h2_.type AS type_18, h2_.owner AS owner_19, h2_.created AS created_20, h2_.updated AS updated_21, h2_.ref_id AS ref_id_22, h2_.ref_entity_name AS ref_entity_name_23, h0_.parent_id AS parent_id_24, h1_.node_id AS node_id_25, h1_.public_node_version_id AS public_node_version_id_26, h2_.node_translation_id AS node_translation_id_27, h2_.origin_id AS origin_id_28 FROM hg_node_nodes h0_ INNER JOIN hg_node_node_translations h1_ ON h0_.id = h1_.node_id LEFT JOIN hg_node_node_versions h2_ ON h1_.public_node_version_id = h2_.id AND (h1_.public_node_version_id = h2_.id) WHERE h0_.deleted = 0 AND h0_.internal_name = ? AND h1_.lang = ? AND h1_.online = 1 ORDER BY h1_.weight ASC, h1_.title ASC
Parameters:
[ "homepage" "hu" ] |
|
19.68 ms (20.92%) |
1 |
SELECT h0_.id AS id_0, h0_.lft AS lft_1, h0_.lvl AS lvl_2, h0_.rgt AS rgt_3, h0_.deleted AS deleted_4, h0_.hidden_from_nav AS hidden_from_nav_5, h0_.ref_entity_name AS ref_entity_name_6, h0_.internal_name AS internal_name_7, h1_.id AS id_8, h1_.lang AS lang_9, h1_.online AS online_10, h1_.title AS title_11, h1_.slug AS slug_12, h1_.url AS url_13, h1_.weight AS weight_14, h1_.created AS created_15, h1_.updated AS updated_16, h2_.id AS id_17, h2_.type AS type_18, h2_.owner AS owner_19, h2_.created AS created_20, h2_.updated AS updated_21, h2_.ref_id AS ref_id_22, h2_.ref_entity_name AS ref_entity_name_23, h0_.parent_id AS parent_id_24, h1_.node_id AS node_id_25, h1_.public_node_version_id AS public_node_version_id_26, h2_.node_translation_id AS node_translation_id_27, h2_.origin_id AS origin_id_28 FROM hg_node_nodes h0_ LEFT JOIN hg_node_node_translations h1_ ON h0_.id = h1_.node_id AND (h1_.lang = ?) LEFT JOIN hg_node_node_versions h2_ ON h1_.public_node_version_id = h2_.id AND (h1_.public_node_version_id = h2_.id) JOIN (SELECT DISTINCT o.object_identifier AS id FROM parfumhu.acl_object_identities AS o INNER JOIN parfumhu.acl_classes c ON c.id = o.class_id LEFT JOIN parfumhu.acl_entries e ON ( e.class_id = o.class_id AND (e.object_identity_id = o.id OR e.object_identity_id IS NULL) ) LEFT JOIN parfumhu.acl_security_identities s ON ( s.id = e.security_identity_id ) WHERE c.class_type = "Hgabka\\NodeBundle\\Entity\\Node" AND (s.identifier = "IS_AUTHENTICATED_ANONYMOUSLY") AND e.mask & 1 > 0) ta_ ON h0_.id = ta_.id WHERE h0_.deleted = 0 AND ((h0_.hidden_from_nav <> 1 OR h0_.internal_name IS NOT NULL)) ORDER BY h1_.weight ASC, h1_.title ASC
Parameters:
[
"hu"
]
|
|
7.35 ms (7.82%) |
1 |
SELECT a0_.highlighted AS highlighted_0, a0_.short_title AS short_title_1, a0_.`lead` AS lead_2, a0_.published_at AS published_at_3, a0_.`author` AS author_4, a0_.id AS id_5, a0_.title AS title_6, a0_.page_title AS page_title_7, a0_.image_id AS image_id_8, a0_.thumb_id AS thumb_id_9, a0_.home_thumb_id AS home_thumb_id_10 FROM app_blog_entry_pages a0_ INNER JOIN hg_node_node_versions h1_ ON (h1_.ref_id = ? AND h1_.ref_entity_name = ? AND h1_.type = ?) INNER JOIN hg_node_node_translations h2_ ON h1_.node_translation_id = h2_.id INNER JOIN hg_node_nodes h3_ ON h2_.node_id = h3_.id WHERE a0_.published_at < ? AND h3_.parent_id = ? AND h2_.online = 1 ORDER BY a0_.published_at DESC LIMIT 1
Parameters:
[ 245 "App\Entity\Pages\BlogEntryPage" "public" "2023-04-26 00:00:00" 3 ] |
|
6.01 ms (6.38%) |
1 |
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.short_name AS short_name_2, b0_.slug AS slug_3, b0_.search_terms AS search_terms_4, b0_.text AS text_5, b0_.text_female AS text_female_6, b0_.text_male AS text_male_7, b0_.highlighted AS highlighted_8, b0_.main_page_fragrance AS main_page_fragrance_9, b0_.highlighted_in_search AS highlighted_in_search_10, b0_.is_on_main_page AS is_on_main_page_11, b0_.special AS special_12, b0_.special_name AS special_name_13, b0_.slogan AS slogan_14, b0_.`lead` AS lead_15, b0_.active AS active_16, b0_.exclude_from_arukereso AS exclude_from_arukereso_17, b0_.image_id AS image_id_18 FROM brand b0_ WHERE b0_.active = 1 ORDER BY b0_.name ASC
Parameters:
[] |
|
4.66 ms (4.95%) |
1 |
SELECT a0_.highlighted AS highlighted_0, a0_.short_title AS short_title_1, a0_.`lead` AS lead_2, a0_.published_at AS published_at_3, a0_.`author` AS author_4, a0_.id AS id_5, a0_.title AS title_6, a0_.page_title AS page_title_7, a0_.image_id AS image_id_8, a0_.thumb_id AS thumb_id_9, a0_.home_thumb_id AS home_thumb_id_10 FROM app_blog_entry_pages a0_ INNER JOIN hg_node_node_versions h1_ ON (h1_.ref_id = ? AND h1_.ref_entity_name = ? AND h1_.type = ?) INNER JOIN hg_node_node_translations h2_ ON h1_.node_translation_id = h2_.id INNER JOIN hg_node_nodes h3_ ON h2_.node_id = h3_.id WHERE a0_.published_at > ? AND h3_.parent_id = ? AND h2_.online = 1 ORDER BY a0_.published_at ASC LIMIT 1
Parameters:
[ 245 "App\Entity\Pages\BlogEntryPage" "public" "2023-04-26 00:00:00" 3 ] |
|
3.68 ms (3.91%) |
6 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.owner AS owner_3, t0.created AS created_4, t0.updated AS updated_5, t0.ref_id AS ref_id_6, t0.ref_entity_name AS ref_entity_name_7, t0.node_translation_id AS node_translation_id_8, t0.origin_id AS origin_id_9 FROM hg_node_node_versions t0 WHERE t0.ref_id = ? AND t0.ref_entity_name = ? LIMIT 1
Parameters:
[ 245 "App\Entity\Pages\BlogEntryPage" ] |
|
3.52 ms (3.74%) |
3 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.place AS place_2, p0_.url AS url_3, p0_.start_time AS start_time_4, p0_.end_time AS end_time_5, p0_.priority AS priority_6, p0_.new_window AS new_window_7, p0_.image_alt AS image_alt_8, p0_.image_title AS image_title_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, h1_.id AS id_12, h1_.uuid AS uuid_13, h1_.location AS location_14, h1_.content_type AS content_type_15, h1_.metadata AS metadata_16, h1_.filesize AS filesize_17, h1_.url AS url_18, h1_.original_filename AS original_filename_19, h1_.deleted AS deleted_20, h1_.removed_from_file_system AS removed_from_file_system_21, h1_.protected AS protected_22, h1_.created_at AS created_at_23, h1_.updated_at AS updated_at_24, h2_.id AS id_25, h2_.uuid AS uuid_26, h2_.location AS location_27, h2_.content_type AS content_type_28, h2_.metadata AS metadata_29, h2_.filesize AS filesize_30, h2_.url AS url_31, h2_.original_filename AS original_filename_32, h2_.deleted AS deleted_33, h2_.removed_from_file_system AS removed_from_file_system_34, h2_.protected AS protected_35, h2_.created_at AS created_at_36, h2_.updated_at AS updated_at_37, p0_.image_id AS image_id_38, p0_.hover_image_id AS hover_image_id_39, h1_.folder_id AS folder_id_40, h2_.folder_id AS folder_id_41 FROM placed_banner p0_ LEFT JOIN hg_media_media h1_ ON p0_.image_id = h1_.id LEFT JOIN hg_media_media h2_ ON p0_.hover_image_id = h2_.id WHERE p0_.place = ? AND (p0_.start_time IS NULL OR p0_.start_time <= ?) AND (p0_.end_time IS NULL OR p0_.end_time >= ?)
Parameters:
[ "vegtelen1" "2026-01-31 14:10:30" "2026-01-31 14:10:30" ] |
|
3.50 ms (3.72%) |
8 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.page_title AS page_title_3 FROM app_topten_pages t0 WHERE t0.id = ?
Parameters:
[
13
]
|
|
3.35 ms (3.56%) |
4 |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.location AS location_3, t0.content_type AS content_type_4, t0.metadata AS metadata_5, t0.filesize AS filesize_6, t0.url AS url_7, t0.original_filename AS original_filename_8, t0.deleted AS deleted_9, t0.removed_from_file_system AS removed_from_file_system_10, t0.protected AS protected_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.folder_id AS folder_id_14 FROM hg_media_media t0 WHERE t0.id = ?
Parameters:
[
51726
]
|
|
2.72 ms (2.89%) |
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.display_from AS display_from_2, p0_.display_to AS display_to_3, p0_.link AS link_4, p0_.only_homepage AS only_homepage_5, p0_.new_window AS new_window_6, p0_.mobile AS mobile_7, p0_.only_exit AS only_exit_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10, h1_.id AS id_11, h1_.uuid AS uuid_12, h1_.location AS location_13, h1_.content_type AS content_type_14, h1_.metadata AS metadata_15, h1_.filesize AS filesize_16, h1_.url AS url_17, h1_.original_filename AS original_filename_18, h1_.deleted AS deleted_19, h1_.removed_from_file_system AS removed_from_file_system_20, h1_.protected AS protected_21, h1_.created_at AS created_at_22, h1_.updated_at AS updated_at_23, p0_.image_id AS image_id_24, h1_.folder_id AS folder_id_25 FROM popup p0_ LEFT JOIN hg_media_media h1_ ON p0_.image_id = h1_.id WHERE (p0_.display_from IS NULL OR p0_.display_from <= ?) AND (p0_.display_to IS NULL OR p0_.display_to >= ?) AND p0_.only_homepage = 0 AND (p0_.only_exit = 0 OR p0_.only_exit IS NULL) ORDER BY RAND() ASC LIMIT 1
Parameters:
[ "2026-01-31 14:10:30" "2026-01-31 14:10:30" ] |
|
2.05 ms (2.18%) |
4 |
SELECT t0.show_title AS show_title_1, t0.excluded_from_sitemap AS excluded_from_sitemap_2, t0.id AS id_3, t0.title AS title_4, t0.page_title AS page_title_5 FROM app_content_pages t0 WHERE t0.id = ?
Parameters:
[
29
]
|
|
1.92 ms (2.04%) |
1 |
SELECT h0_.id AS id_0, h0_.lft AS lft_1, h0_.lvl AS lvl_2, h0_.rgt AS rgt_3, h0_.deleted AS deleted_4, h0_.hidden_from_nav AS hidden_from_nav_5, h0_.ref_entity_name AS ref_entity_name_6, h0_.internal_name AS internal_name_7, h1_.id AS id_8, h1_.lang AS lang_9, h1_.online AS online_10, h1_.title AS title_11, h1_.slug AS slug_12, h1_.url AS url_13, h1_.weight AS weight_14, h1_.created AS created_15, h1_.updated AS updated_16, h2_.id AS id_17, h2_.type AS type_18, h2_.owner AS owner_19, h2_.created AS created_20, h2_.updated AS updated_21, h2_.ref_id AS ref_id_22, h2_.ref_entity_name AS ref_entity_name_23, h0_.parent_id AS parent_id_24, h1_.node_id AS node_id_25, h1_.public_node_version_id AS public_node_version_id_26, h2_.node_translation_id AS node_translation_id_27, h2_.origin_id AS origin_id_28 FROM hg_node_nodes h0_ INNER JOIN hg_node_node_translations h1_ ON h0_.id = h1_.node_id LEFT JOIN hg_node_node_versions h2_ ON h1_.public_node_version_id = h2_.id AND (h1_.public_node_version_id = h2_.id) WHERE h0_.deleted = 0 AND (h0_.lft <= 814 AND h0_.rgt >= 815) ORDER BY h0_.lft ASC
Parameters:
[] |
|
1.26 ms (1.34%) |
1 |
SELECT h0_.id AS id_0, h0_.lang AS lang_1, h0_.online AS online_2, h0_.title AS title_3, h0_.slug AS slug_4, h0_.url AS url_5, h0_.weight AS weight_6, h0_.created AS created_7, h0_.updated AS updated_8, h1_.id AS id_9, h1_.type AS type_10, h1_.owner AS owner_11, h1_.created AS created_12, h1_.updated AS updated_13, h1_.ref_id AS ref_id_14, h1_.ref_entity_name AS ref_entity_name_15, h0_.node_id AS node_id_16, h0_.public_node_version_id AS public_node_version_id_17, h1_.node_translation_id AS node_translation_id_18, h1_.origin_id AS origin_id_19 FROM hg_node_node_translations h0_ INNER JOIN hg_node_nodes h2_ ON h0_.node_id = h2_.id AND (h0_.node_id = h2_.id) LEFT JOIN hg_node_node_versions h1_ ON h0_.public_node_version_id = h1_.id AND (h0_.public_node_version_id = h1_.id) WHERE h2_.deleted = 0 AND h0_.lang = ? AND h0_.url = ? ORDER BY h0_.online DESC
Parameters:
[ "hu" "blog/noi-magazin/valtoztasd-meg-a-hozzaallasod" ] |
|
1.18 ms (1.26%) |
1 |
SELECT t0.content AS content_1, t0.id AS id_2 FROM hg_page_part_text_page_parts t0 WHERE t0.id IN (?)
Parameters:
[
385
]
|
|
1.14 ms (1.21%) |
3 |
SELECT DATABASE()
Parameters:
[] |
|
1.01 ms (1.07%) |
1 |
SELECT o.id AS acl_id, o.object_identifier, o.parent_object_identity_id, o.entries_inheriting, c.class_type, e.id AS ace_id, e.object_identity_id, e.field_name, e.ace_order, e.mask, e.granting, e.granting_strategy, e.audit_success, e.audit_failure, s.username, s.identifier AS security_identifier FROM acl_object_identities o INNER JOIN acl_classes c ON c.id = o.class_id LEFT JOIN acl_entries e ON ( e.class_id = o.class_id AND (e.object_identity_id = o.id OR e.object_identity_id IS NULL) ) LEFT JOIN acl_security_identities s ON ( s.id = e.security_identity_id ) WHERE (o.id =1043)
Parameters:
[] |
|
0.97 ms (1.03%) |
1 |
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.meta_author AS meta_author_4, t0.meta_robots AS meta_robots_5, t0.og_type AS og_type_6, t0.og_title AS og_title_7, t0.og_description AS og_description_8, t0.extra_metadata AS extra_metadata_9, t0.ref_id AS ref_id_10, t0.ref_entity_name AS ref_entity_name_11, t0.og_url AS og_url_12, t0.og_article_author AS og_article_author_13, t0.og_article_publisher AS og_article_publisher_14, t0.og_article_section AS og_article_section_15, t0.twitter_title AS twitter_title_16, t0.twitter_description AS twitter_description_17, t0.twitter_site AS twitter_site_18, t0.twitter_creator AS twitter_creator_19, t0.og_image_id AS og_image_id_20, t0.twitter_image_id AS twitter_image_id_21 FROM hg_seo_seo t0 WHERE t0.ref_id = ? AND t0.ref_entity_name = ? LIMIT 1
Parameters:
[ 245 "App\Entity\Pages\BlogEntryPage" ] |
|
0.87 ms (0.93%) |
1 |
SELECT a.ancestor_id FROM acl_object_identities o INNER JOIN acl_classes c ON c.id = o.class_id INNER JOIN acl_object_identity_ancestors a ON a.object_identity_id = o.id WHERE ((o.object_identifier IN ('319') AND c.class_type = 'Hgabka\\NodeBundle\\Entity\\Node'))
Parameters:
[] |
|
0.82 ms (0.87%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.page_title AS page_title_3 FROM app_home_pages t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.79 ms (0.84%) |
1 |
SELECT t0.highlighted AS highlighted_1, t0.short_title AS short_title_2, t0.`lead` AS lead_3, t0.published_at AS published_at_4, t0.`author` AS author_5, t0.id AS id_6, t0.title AS title_7, t0.page_title AS page_title_8, t0.image_id AS image_id_9, t0.thumb_id AS thumb_id_10, t0.home_thumb_id AS home_thumb_id_11 FROM app_blog_entry_pages t0 WHERE t0.id = ?
Parameters:
[
245
]
|
|
0.77 ms (0.82%) |
1 |
SELECT h0_.id AS id_0, h0_.meta_title AS meta_title_1, h0_.meta_description AS meta_description_2, h0_.meta_author AS meta_author_3, h0_.meta_robots AS meta_robots_4, h0_.og_type AS og_type_5, h0_.og_title AS og_title_6, h0_.og_description AS og_description_7, h0_.extra_metadata AS extra_metadata_8, h0_.ref_id AS ref_id_9, h0_.ref_entity_name AS ref_entity_name_10, h0_.og_url AS og_url_11, h0_.og_article_author AS og_article_author_12, h0_.og_article_publisher AS og_article_publisher_13, h0_.og_article_section AS og_article_section_14, h0_.twitter_title AS twitter_title_15, h0_.twitter_description AS twitter_description_16, h0_.twitter_site AS twitter_site_17, h0_.twitter_creator AS twitter_creator_18, h0_.og_image_id AS og_image_id_19, h0_.twitter_image_id AS twitter_image_id_20 FROM hg_seo_seo h0_ WHERE h0_.ref_id IS NULL AND h0_.ref_entity_name IS NULL ORDER BY h0_.id DESC LIMIT 1
Parameters:
[] |
|
0.76 ms (0.81%) |
1 |
SELECT t0.id AS id_1, t0.page_id AS page_id_2, t0.page_entityname AS page_entityname_3, t0.context AS context_4, t0.sequencenumber AS sequencenumber_5, t0.page_part_id AS page_part_id_6, t0.page_part_entityname AS page_part_entityname_7, t0.created AS created_8, t0.updated AS updated_9 FROM hg_page_part_page_part_refs t0 WHERE t0.page_id = ? AND t0.page_entityname = ? AND t0.context = ? ORDER BY t0.sequencenumber ASC
Parameters:
[ 245 "App\Entity\Pages\BlogEntryPage" "blog_entry" ] |
|
0.69 ms (0.74%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.page_title AS page_title_3 FROM app_brand_pages t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.67 ms (0.72%) |
1 |
SELECT t0.id AS id_1, t0.domain AS domain_2, t0.origin AS origin_3, t0.target AS target_4, t0.permanent AS permanent_5 FROM hg_settings_redirect t0
Parameters:
[] |
|
0.47 ms (0.50%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.page_title AS page_title_3, t0.image_id AS image_id_4 FROM app_blog_pages t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.41 ms (0.43%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.page_title AS page_title_3 FROM app_favorites_pages t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.33 ms (0.35%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.page_title AS page_title_3 FROM app_contact_pages t0 WHERE t0.id = ?
Parameters:
[
1
]
|
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.