Query Metrics
122
Database Queries
49
Different statements
204.22 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.67 ms |
SELECT DATABASE()
Parameters:
[] |
| 2 | 0.57 ms |
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:
[] |
| 3 | 1.20 ms |
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 IS NULL ORDER BY h0_.online DESC
Parameters:
[
"hu"
]
|
| 4 | 0.63 ms |
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
]
|
| 5 | 0.71 ms |
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 ('1') AND c.class_type = 'Hgabka\\NodeBundle\\Entity\\Node'))
Parameters:
[] |
| 6 | 0.89 ms |
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 =725)
Parameters:
[] |
| 7 | 0.92 ms |
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:
[ 1 "App\Entity\Pages\HomePage" ] |
| 8 | 0.64 ms |
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:
[] |
| 9 | 0.86 ms |
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:
[
9
]
|
| 10 | 1.59 ms |
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" ] |
| 11 | 1.13 ms |
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 11:41:40" "2026-01-31 11:41:40" ] |
| 12 | 1.42 ms |
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:
[ "visszavasarlasi-garancia" "hu" ] |
| 13 | 0.99 ms |
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
]
|
| 14 | 1.66 ms |
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:
[ "kapcsolat" "hu" ] |
| 15 | 0.62 ms |
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
]
|
| 16 | 1.39 ms |
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:
[ "szallitas" "hu" ] |
| 17 | 0.54 ms |
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:
[
19
]
|
| 18 | 0.90 ms |
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:
[ "vegtelen2" "2026-01-31 11:41:40" "2026-01-31 11:41:40" ] |
| 19 | 0.99 ms |
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:
[ "favorites" "hu" ] |
| 20 | 0.41 ms |
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
]
|
| 21 | 1.00 ms |
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:
[ "fooldal_mobile_upper" "2026-01-31 11:41:40" "2026-01-31 11:41:40" ] |
| 22 | 0.65 ms |
SELECT t0.id AS id_1, t0.page_id AS page_id_2, t0.page_entity_name AS page_entity_name_3, t0.page_template AS page_template_4 FROM hg_page_part_page_template_configuration t0 WHERE t0.page_id = ? AND t0.page_entity_name = ? LIMIT 1
Parameters:
[ 1 "App\Entity\Pages\HomePage" ] |
| 23 | 0.61 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.content AS content_4, t0.priority AS priority_5, t0.active AS active_6, t0.highlighted AS highlighted_7, t0.new_badge AS new_badge_8, t0.red_letters AS red_letters_9, t0.strong_letters AS strong_letters_10, t0.label AS label_11, t0.position AS position_12 FROM main_menu_item_entity t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"female"
]
|
| 24 | 0.44 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.content AS content_4, t0.priority AS priority_5, t0.active AS active_6, t0.highlighted AS highlighted_7, t0.new_badge AS new_badge_8, t0.red_letters AS red_letters_9, t0.strong_letters AS strong_letters_10, t0.label AS label_11, t0.position AS position_12 FROM main_menu_item_entity t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"male"
]
|
| 25 | 0.44 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.content AS content_4, t0.priority AS priority_5, t0.active AS active_6, t0.highlighted AS highlighted_7, t0.new_badge AS new_badge_8, t0.red_letters AS red_letters_9, t0.strong_letters AS strong_letters_10, t0.label AS label_11, t0.position AS position_12 FROM main_menu_item_entity t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"brand"
]
|
| 26 | 0.31 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.content AS content_4, t0.priority AS priority_5, t0.active AS active_6, t0.highlighted AS highlighted_7, t0.new_badge AS new_badge_8, t0.red_letters AS red_letters_9, t0.strong_letters AS strong_letters_10, t0.label AS label_11, t0.position AS position_12 FROM main_menu_item_entity t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"discount"
]
|
| 27 | 0.32 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.content AS content_4, t0.priority AS priority_5, t0.active AS active_6, t0.highlighted AS highlighted_7, t0.new_badge AS new_badge_8, t0.red_letters AS red_letters_9, t0.strong_letters AS strong_letters_10, t0.label AS label_11, t0.position AS position_12 FROM main_menu_item_entity t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"novelty"
]
|
| 28 | 0.46 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.content AS content_4, t0.priority AS priority_5, t0.active AS active_6, t0.highlighted AS highlighted_7, t0.new_badge AS new_badge_8, t0.red_letters AS red_letters_9, t0.strong_letters AS strong_letters_10, t0.label AS label_11, t0.position AS position_12 FROM main_menu_item_entity t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"topten"
]
|
| 29 | 0.46 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.content AS content_4, t0.priority AS priority_5, t0.active AS active_6, t0.highlighted AS highlighted_7, t0.new_badge AS new_badge_8, t0.red_letters AS red_letters_9, t0.strong_letters AS strong_letters_10, t0.label AS label_11, t0.position AS position_12 FROM main_menu_item_entity t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"niche"
]
|
| 30 | 0.40 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.content AS content_4, t0.priority AS priority_5, t0.active AS active_6, t0.highlighted AS highlighted_7, t0.new_badge AS new_badge_8, t0.red_letters AS red_letters_9, t0.strong_letters AS strong_letters_10, t0.label AS label_11, t0.position AS position_12 FROM main_menu_item_entity t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"sets"
]
|
| 31 | 0.43 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.content AS content_4, t0.priority AS priority_5, t0.active AS active_6, t0.highlighted AS highlighted_7, t0.new_badge AS new_badge_8, t0.red_letters AS red_letters_9, t0.strong_letters AS strong_letters_10, t0.label AS label_11, t0.position AS position_12 FROM main_menu_item_entity t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"unavailable_soon"
]
|
| 32 | 0.44 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.content AS content_4, t0.priority AS priority_5, t0.active AS active_6, t0.highlighted AS highlighted_7, t0.new_badge AS new_badge_8, t0.red_letters AS red_letters_9, t0.strong_letters AS strong_letters_10, t0.label AS label_11, t0.position AS position_12 FROM main_menu_item_entity t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"fragrance_sample"
]
|
| 33 | 5.29 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price AS price_2, p0_.price_in_euros AS price_in_euros_3, p0_.article_number AS article_number_4, p0_.total_ml AS total_ml_5, p0_.tester AS tester_6, p0_.cellofan AS cellofan_7, p0_.unboxed AS unboxed_8, p0_.hit AS hit_9, p0_.fragrance_sample AS fragrance_sample_10, p0_.is_on_main_page AS is_on_main_page_11, p0_.limited AS limited_12, p0_.reloaded AS reloaded_13, p0_.discount_hidden AS discount_hidden_14, p0_.discount_order_date AS discount_order_date_15, p0_.limit_order_date AS limit_order_date_16, p0_.novelty_order_date AS novelty_order_date_17, p0_.unavailable_soon_order_date AS unavailable_soon_order_date_18, p0_.move_first_order_date AS move_first_order_date_19, p0_.extra_discount AS extra_discount_20, p0_.stock AS stock_21, p0_.active AS active_22, p0_.available AS available_23, p0_.send_to_emag AS send_to_emag_24, p0_.emag_visible AS emag_visible_25, p0_.bb_visible AS bb_visible_26, p0_.sent_to_tharanis AS sent_to_tharanis_27, p0_.available_totally AS available_totally_28, p0_.ean AS ean_29, p0_.position AS position_30, p0_.discount AS discount_31, p0_.discount_price AS discount_price_32, p0_.discount_price_in_euros AS discount_price_in_euros_33, p0_.discount_stock AS discount_stock_34, p0_.discount_constant AS discount_constant_35, p0_.stock_limit AS stock_limit_36, p0_.stock_limit_type AS stock_limit_type_37, p0_.stock_limit_stock AS stock_limit_stock_38, p0_.outlet AS outlet_39, p0_.sold AS sold_40, p0_.fix_priced AS fix_priced_41, p0_.discount_note AS discount_note_42, p0_.stock_limit_note AS stock_limit_note_43, p0_.arukereso_marketplace_disabled AS arukereso_marketplace_disabled_44, p0_.mini_perfume AS mini_perfume_45, p0_.minimum_priced AS minimum_priced_46, p0_.arukereso_appearance AS arukereso_appearance_47, p0_.pepita_appearance AS pepita_appearance_48, p0_.refiller AS refiller_49, p0_.best_price AS best_price_50, p1_.id AS id_51, p1_.article_number AS article_number_52, p1_.name AS name_53, p1_.search_terms AS search_terms_54, p1_.year AS year_55, p1_.gender AS gender_56, p1_.coming_soon AS coming_soon_57, p1_.novelty AS novelty_58, p1_.discount AS discount_59, p1_.unavailable_soon AS unavailable_soon_60, p1_.niche AS niche_61, p1_.exclusive AS exclusive_62, p1_.limited_edition AS limited_edition_63, p1_.outlet AS outlet_64, p1_.rarity AS rarity_65, p1_.available_again AS available_again_66, p1_.limited AS limited_67, p1_.active AS active_68, p1_.info_link AS info_link_69, p1_.description AS description_70, p1_.fragrance_description AS fragrance_description_71, p1_.meta_description AS meta_description_72, p1_.meta_keywords AS meta_keywords_73, p1_.facebook_description AS facebook_description_74, p1_.minimum_price AS minimum_price_75, p1_.discounted_minimum_price AS discounted_minimum_price_76, p1_.url AS url_77, p1_.sold AS sold_78, p1_.just_arrived AS just_arrived_79, p1_.is_on_main_page AS is_on_main_page_80, p1_.discount_order_date AS discount_order_date_81, p1_.novelty_order_date AS novelty_order_date_82, p1_.unavailable_soon_order_date AS unavailable_soon_order_date_83, p1_.move_first_order_date AS move_first_order_date_84, p1_.slogan AS slogan_85, p1_.price_changed_at AS price_changed_at_86, p1_.data_changed_at AS data_changed_at_87, p1_.price_for_sort AS price_for_sort_88, p1_.introduction_price AS introduction_price_89, p1_.special AS special_90, p1_.purchasable AS purchasable_91, p1_.fix_priced AS fix_priced_92, p1_.created_at AS created_at_93, p1_.updated_at AS updated_at_94, p2_.id AS id_95, p2_.name AS name_96, p2_.code AS code_97, p2_.cosmetics AS cosmetics_98, p2_.taska AS taska_99, p2_.gift_set AS gift_set_100, p2_.hidden AS hidden_101, p2_.single_name AS single_name_102, p2_.plural_name AS plural_name_103, p2_.position AS position_104, p2_.`lead` AS lead_105, p2_.seo_description AS seo_description_106, p2_.title AS title_107, b3_.id AS id_108, b3_.name AS name_109, b3_.short_name AS short_name_110, b3_.slug AS slug_111, b3_.search_terms AS search_terms_112, b3_.text AS text_113, b3_.text_female AS text_female_114, b3_.text_male AS text_male_115, b3_.highlighted AS highlighted_116, b3_.main_page_fragrance AS main_page_fragrance_117, b3_.highlighted_in_search AS highlighted_in_search_118, b3_.is_on_main_page AS is_on_main_page_119, b3_.special AS special_120, b3_.special_name AS special_name_121, b3_.slogan AS slogan_122, b3_.`lead` AS lead_123, b3_.active AS active_124, b3_.exclude_from_arukereso AS exclude_from_arukereso_125, f4_.id AS id_126, f4_.name AS name_127, c5_.id AS id_128, c5_.shortening AS shortening_129, c5_.description AS description_130, c5_.full_name AS full_name_131, c5_.short_name AS short_name_132, c5_.position AS position_133, h6_.id AS id_134, h6_.uuid AS uuid_135, h6_.location AS location_136, h6_.content_type AS content_type_137, h6_.metadata AS metadata_138, h6_.filesize AS filesize_139, h6_.url AS url_140, h6_.original_filename AS original_filename_141, h6_.deleted AS deleted_142, h6_.removed_from_file_system AS removed_from_file_system_143, h6_.protected AS protected_144, h6_.created_at AS created_at_145, h6_.updated_at AS updated_at_146, h7_.id AS id_147, h7_.rel AS rel_148, h7_.internal_name AS internal_name_149, h7_.lft AS lft_150, h7_.lvl AS lvl_151, h7_.rgt AS rgt_152, h7_.deleted AS deleted_153, h7_.internal AS internal_154, h7_.created_at AS created_at_155, h7_.updated_at AS updated_at_156, h8_.id AS id_157, h8_.uuid AS uuid_158, h8_.location AS location_159, h8_.content_type AS content_type_160, h8_.metadata AS metadata_161, h8_.filesize AS filesize_162, h8_.url AS url_163, h8_.original_filename AS original_filename_164, h8_.deleted AS deleted_165, h8_.removed_from_file_system AS removed_from_file_system_166, h8_.protected AS protected_167, h8_.created_at AS created_at_168, h8_.updated_at AS updated_at_169, h9_.id AS id_170, h9_.rel AS rel_171, h9_.internal_name AS internal_name_172, h9_.lft AS lft_173, h9_.lvl AS lvl_174, h9_.rgt AS rgt_175, h9_.deleted AS deleted_176, h9_.internal AS internal_177, h9_.created_at AS created_at_178, h9_.updated_at AS updated_at_179, p0_.product_id AS product_id_180, p1_.brand_id AS brand_id_181, p1_.product_category_id AS product_category_id_182, p1_.image_id AS image_id_183, p1_.tester_image_id AS tester_image_id_184, p1_.hover_image_id AS hover_image_id_185, p1_.facebook_image_id AS facebook_image_id_186, p1_.concentration_id AS concentration_id_187, p1_.fragrance_family_id AS fragrance_family_id_188, p1_.price_changer_id AS price_changer_id_189, p1_.data_changer_id AS data_changer_id_190, b3_.image_id AS image_id_191, h6_.folder_id AS folder_id_192, h7_.parent_id AS parent_id_193, h8_.folder_id AS folder_id_194, h9_.parent_id AS parent_id_195 FROM product_packaging p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id LEFT JOIN product_category p2_ ON p1_.product_category_id = p2_.id INNER JOIN brand b3_ ON p1_.brand_id = b3_.id LEFT JOIN fragrance_family f4_ ON p1_.fragrance_family_id = f4_.id LEFT JOIN concentration c5_ ON p1_.concentration_id = c5_.id LEFT JOIN hg_media_media h6_ ON p1_.image_id = h6_.id LEFT JOIN hg_media_folders h7_ ON h6_.folder_id = h7_.id LEFT JOIN hg_media_media h8_ ON p1_.hover_image_id = h8_.id LEFT JOIN hg_media_folders h9_ ON h8_.folder_id = h9_.id INNER JOIN main_menu_offer m10_ ON p0_.id = m10_.product_packaging_id AND (m10_.type = ?) WHERE p1_.active = 1 AND p0_.active = 1 AND (p0_.stock_limit = 0 OR p0_.stock_limit_type = ? OR p0_.stock_limit_stock > 0) AND (p1_.coming_soon IS NULL OR p1_.coming_soon <> 1) ORDER BY RAND() ASC LIMIT 4
Parameters:
[ "discount" "unavailable" ] |
| 34 | 1.57 ms |
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 AND b0_.is_on_main_page = 1 ORDER BY IF(b0_.short_name IS NULL OR b0_.short_name = ?, b0_.name, b0_.short_name) ASC
Parameters:
[ "" ] |
| 35 | 1.35 ms |
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:
[ "brands" "hu" ] |
| 36 | 0.59 ms |
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
]
|
| 37 | 1.69 ms |
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 AND b0_.main_page_fragrance = 1 ORDER BY IF(b0_.short_name IS NULL OR b0_.short_name = ?, b0_.name, b0_.short_name) ASC LIMIT 30
Parameters:
[ "" ] |
| 38 | 8.95 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price AS price_2, p0_.price_in_euros AS price_in_euros_3, p0_.article_number AS article_number_4, p0_.total_ml AS total_ml_5, p0_.tester AS tester_6, p0_.cellofan AS cellofan_7, p0_.unboxed AS unboxed_8, p0_.hit AS hit_9, p0_.fragrance_sample AS fragrance_sample_10, p0_.is_on_main_page AS is_on_main_page_11, p0_.limited AS limited_12, p0_.reloaded AS reloaded_13, p0_.discount_hidden AS discount_hidden_14, p0_.discount_order_date AS discount_order_date_15, p0_.limit_order_date AS limit_order_date_16, p0_.novelty_order_date AS novelty_order_date_17, p0_.unavailable_soon_order_date AS unavailable_soon_order_date_18, p0_.move_first_order_date AS move_first_order_date_19, p0_.extra_discount AS extra_discount_20, p0_.stock AS stock_21, p0_.active AS active_22, p0_.available AS available_23, p0_.send_to_emag AS send_to_emag_24, p0_.emag_visible AS emag_visible_25, p0_.bb_visible AS bb_visible_26, p0_.sent_to_tharanis AS sent_to_tharanis_27, p0_.available_totally AS available_totally_28, p0_.ean AS ean_29, p0_.position AS position_30, p0_.discount AS discount_31, p0_.discount_price AS discount_price_32, p0_.discount_price_in_euros AS discount_price_in_euros_33, p0_.discount_stock AS discount_stock_34, p0_.discount_constant AS discount_constant_35, p0_.stock_limit AS stock_limit_36, p0_.stock_limit_type AS stock_limit_type_37, p0_.stock_limit_stock AS stock_limit_stock_38, p0_.outlet AS outlet_39, p0_.sold AS sold_40, p0_.fix_priced AS fix_priced_41, p0_.discount_note AS discount_note_42, p0_.stock_limit_note AS stock_limit_note_43, p0_.arukereso_marketplace_disabled AS arukereso_marketplace_disabled_44, p0_.mini_perfume AS mini_perfume_45, p0_.minimum_priced AS minimum_priced_46, p0_.arukereso_appearance AS arukereso_appearance_47, p0_.pepita_appearance AS pepita_appearance_48, p0_.refiller AS refiller_49, p0_.best_price AS best_price_50, p1_.id AS id_51, p1_.article_number AS article_number_52, p1_.name AS name_53, p1_.search_terms AS search_terms_54, p1_.year AS year_55, p1_.gender AS gender_56, p1_.coming_soon AS coming_soon_57, p1_.novelty AS novelty_58, p1_.discount AS discount_59, p1_.unavailable_soon AS unavailable_soon_60, p1_.niche AS niche_61, p1_.exclusive AS exclusive_62, p1_.limited_edition AS limited_edition_63, p1_.outlet AS outlet_64, p1_.rarity AS rarity_65, p1_.available_again AS available_again_66, p1_.limited AS limited_67, p1_.active AS active_68, p1_.info_link AS info_link_69, p1_.description AS description_70, p1_.fragrance_description AS fragrance_description_71, p1_.meta_description AS meta_description_72, p1_.meta_keywords AS meta_keywords_73, p1_.facebook_description AS facebook_description_74, p1_.minimum_price AS minimum_price_75, p1_.discounted_minimum_price AS discounted_minimum_price_76, p1_.url AS url_77, p1_.sold AS sold_78, p1_.just_arrived AS just_arrived_79, p1_.is_on_main_page AS is_on_main_page_80, p1_.discount_order_date AS discount_order_date_81, p1_.novelty_order_date AS novelty_order_date_82, p1_.unavailable_soon_order_date AS unavailable_soon_order_date_83, p1_.move_first_order_date AS move_first_order_date_84, p1_.slogan AS slogan_85, p1_.price_changed_at AS price_changed_at_86, p1_.data_changed_at AS data_changed_at_87, p1_.price_for_sort AS price_for_sort_88, p1_.introduction_price AS introduction_price_89, p1_.special AS special_90, p1_.purchasable AS purchasable_91, p1_.fix_priced AS fix_priced_92, p1_.created_at AS created_at_93, p1_.updated_at AS updated_at_94, p2_.id AS id_95, p2_.name AS name_96, p2_.code AS code_97, p2_.cosmetics AS cosmetics_98, p2_.taska AS taska_99, p2_.gift_set AS gift_set_100, p2_.hidden AS hidden_101, p2_.single_name AS single_name_102, p2_.plural_name AS plural_name_103, p2_.position AS position_104, p2_.`lead` AS lead_105, p2_.seo_description AS seo_description_106, p2_.title AS title_107, b3_.id AS id_108, b3_.name AS name_109, b3_.short_name AS short_name_110, b3_.slug AS slug_111, b3_.search_terms AS search_terms_112, b3_.text AS text_113, b3_.text_female AS text_female_114, b3_.text_male AS text_male_115, b3_.highlighted AS highlighted_116, b3_.main_page_fragrance AS main_page_fragrance_117, b3_.highlighted_in_search AS highlighted_in_search_118, b3_.is_on_main_page AS is_on_main_page_119, b3_.special AS special_120, b3_.special_name AS special_name_121, b3_.slogan AS slogan_122, b3_.`lead` AS lead_123, b3_.active AS active_124, b3_.exclude_from_arukereso AS exclude_from_arukereso_125, f4_.id AS id_126, f4_.name AS name_127, c5_.id AS id_128, c5_.shortening AS shortening_129, c5_.description AS description_130, c5_.full_name AS full_name_131, c5_.short_name AS short_name_132, c5_.position AS position_133, h6_.id AS id_134, h6_.uuid AS uuid_135, h6_.location AS location_136, h6_.content_type AS content_type_137, h6_.metadata AS metadata_138, h6_.filesize AS filesize_139, h6_.url AS url_140, h6_.original_filename AS original_filename_141, h6_.deleted AS deleted_142, h6_.removed_from_file_system AS removed_from_file_system_143, h6_.protected AS protected_144, h6_.created_at AS created_at_145, h6_.updated_at AS updated_at_146, h7_.id AS id_147, h7_.rel AS rel_148, h7_.internal_name AS internal_name_149, h7_.lft AS lft_150, h7_.lvl AS lvl_151, h7_.rgt AS rgt_152, h7_.deleted AS deleted_153, h7_.internal AS internal_154, h7_.created_at AS created_at_155, h7_.updated_at AS updated_at_156, h8_.id AS id_157, h8_.uuid AS uuid_158, h8_.location AS location_159, h8_.content_type AS content_type_160, h8_.metadata AS metadata_161, h8_.filesize AS filesize_162, h8_.url AS url_163, h8_.original_filename AS original_filename_164, h8_.deleted AS deleted_165, h8_.removed_from_file_system AS removed_from_file_system_166, h8_.protected AS protected_167, h8_.created_at AS created_at_168, h8_.updated_at AS updated_at_169, h9_.id AS id_170, h9_.rel AS rel_171, h9_.internal_name AS internal_name_172, h9_.lft AS lft_173, h9_.lvl AS lvl_174, h9_.rgt AS rgt_175, h9_.deleted AS deleted_176, h9_.internal AS internal_177, h9_.created_at AS created_at_178, h9_.updated_at AS updated_at_179, p0_.product_id AS product_id_180, p1_.brand_id AS brand_id_181, p1_.product_category_id AS product_category_id_182, p1_.image_id AS image_id_183, p1_.tester_image_id AS tester_image_id_184, p1_.hover_image_id AS hover_image_id_185, p1_.facebook_image_id AS facebook_image_id_186, p1_.concentration_id AS concentration_id_187, p1_.fragrance_family_id AS fragrance_family_id_188, p1_.price_changer_id AS price_changer_id_189, p1_.data_changer_id AS data_changer_id_190, b3_.image_id AS image_id_191, h6_.folder_id AS folder_id_192, h7_.parent_id AS parent_id_193, h8_.folder_id AS folder_id_194, h9_.parent_id AS parent_id_195 FROM product_packaging p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id LEFT JOIN product_category p2_ ON p1_.product_category_id = p2_.id INNER JOIN brand b3_ ON p1_.brand_id = b3_.id LEFT JOIN fragrance_family f4_ ON p1_.fragrance_family_id = f4_.id LEFT JOIN concentration c5_ ON p1_.concentration_id = c5_.id LEFT JOIN hg_media_media h6_ ON p1_.image_id = h6_.id LEFT JOIN hg_media_folders h7_ ON h6_.folder_id = h7_.id LEFT JOIN hg_media_media h8_ ON p1_.hover_image_id = h8_.id LEFT JOIN hg_media_folders h9_ ON h8_.folder_id = h9_.id INNER JOIN main_menu_offer m10_ ON p0_.id = m10_.product_packaging_id AND (m10_.type = ?) WHERE p1_.active = 1 AND p0_.active = 1 AND (p0_.stock_limit = 0 OR p0_.stock_limit_type = ? OR p0_.stock_limit_stock > 0) AND (p1_.coming_soon IS NULL OR p1_.coming_soon <> 1) ORDER BY RAND() ASC LIMIT 4
Parameters:
[ "novelty" "unavailable" ] |
| 39 | 1.54 ms |
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:
[ "top10-niche-noi" "hu" ] |
| 40 | 0.50 ms |
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:
[
7
]
|
| 41 | 0.85 ms |
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:
[ "top10-niche-ferfi" "hu" ] |
| 42 | 0.30 ms |
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:
[
8
]
|
| 43 | 3.95 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price AS price_2, p0_.price_in_euros AS price_in_euros_3, p0_.article_number AS article_number_4, p0_.total_ml AS total_ml_5, p0_.tester AS tester_6, p0_.cellofan AS cellofan_7, p0_.unboxed AS unboxed_8, p0_.hit AS hit_9, p0_.fragrance_sample AS fragrance_sample_10, p0_.is_on_main_page AS is_on_main_page_11, p0_.limited AS limited_12, p0_.reloaded AS reloaded_13, p0_.discount_hidden AS discount_hidden_14, p0_.discount_order_date AS discount_order_date_15, p0_.limit_order_date AS limit_order_date_16, p0_.novelty_order_date AS novelty_order_date_17, p0_.unavailable_soon_order_date AS unavailable_soon_order_date_18, p0_.move_first_order_date AS move_first_order_date_19, p0_.extra_discount AS extra_discount_20, p0_.stock AS stock_21, p0_.active AS active_22, p0_.available AS available_23, p0_.send_to_emag AS send_to_emag_24, p0_.emag_visible AS emag_visible_25, p0_.bb_visible AS bb_visible_26, p0_.sent_to_tharanis AS sent_to_tharanis_27, p0_.available_totally AS available_totally_28, p0_.ean AS ean_29, p0_.position AS position_30, p0_.discount AS discount_31, p0_.discount_price AS discount_price_32, p0_.discount_price_in_euros AS discount_price_in_euros_33, p0_.discount_stock AS discount_stock_34, p0_.discount_constant AS discount_constant_35, p0_.stock_limit AS stock_limit_36, p0_.stock_limit_type AS stock_limit_type_37, p0_.stock_limit_stock AS stock_limit_stock_38, p0_.outlet AS outlet_39, p0_.sold AS sold_40, p0_.fix_priced AS fix_priced_41, p0_.discount_note AS discount_note_42, p0_.stock_limit_note AS stock_limit_note_43, p0_.arukereso_marketplace_disabled AS arukereso_marketplace_disabled_44, p0_.mini_perfume AS mini_perfume_45, p0_.minimum_priced AS minimum_priced_46, p0_.arukereso_appearance AS arukereso_appearance_47, p0_.pepita_appearance AS pepita_appearance_48, p0_.refiller AS refiller_49, p0_.best_price AS best_price_50, p1_.id AS id_51, p1_.article_number AS article_number_52, p1_.name AS name_53, p1_.search_terms AS search_terms_54, p1_.year AS year_55, p1_.gender AS gender_56, p1_.coming_soon AS coming_soon_57, p1_.novelty AS novelty_58, p1_.discount AS discount_59, p1_.unavailable_soon AS unavailable_soon_60, p1_.niche AS niche_61, p1_.exclusive AS exclusive_62, p1_.limited_edition AS limited_edition_63, p1_.outlet AS outlet_64, p1_.rarity AS rarity_65, p1_.available_again AS available_again_66, p1_.limited AS limited_67, p1_.active AS active_68, p1_.info_link AS info_link_69, p1_.description AS description_70, p1_.fragrance_description AS fragrance_description_71, p1_.meta_description AS meta_description_72, p1_.meta_keywords AS meta_keywords_73, p1_.facebook_description AS facebook_description_74, p1_.minimum_price AS minimum_price_75, p1_.discounted_minimum_price AS discounted_minimum_price_76, p1_.url AS url_77, p1_.sold AS sold_78, p1_.just_arrived AS just_arrived_79, p1_.is_on_main_page AS is_on_main_page_80, p1_.discount_order_date AS discount_order_date_81, p1_.novelty_order_date AS novelty_order_date_82, p1_.unavailable_soon_order_date AS unavailable_soon_order_date_83, p1_.move_first_order_date AS move_first_order_date_84, p1_.slogan AS slogan_85, p1_.price_changed_at AS price_changed_at_86, p1_.data_changed_at AS data_changed_at_87, p1_.price_for_sort AS price_for_sort_88, p1_.introduction_price AS introduction_price_89, p1_.special AS special_90, p1_.purchasable AS purchasable_91, p1_.fix_priced AS fix_priced_92, p1_.created_at AS created_at_93, p1_.updated_at AS updated_at_94, p2_.id AS id_95, p2_.name AS name_96, p2_.code AS code_97, p2_.cosmetics AS cosmetics_98, p2_.taska AS taska_99, p2_.gift_set AS gift_set_100, p2_.hidden AS hidden_101, p2_.single_name AS single_name_102, p2_.plural_name AS plural_name_103, p2_.position AS position_104, p2_.`lead` AS lead_105, p2_.seo_description AS seo_description_106, p2_.title AS title_107, b3_.id AS id_108, b3_.name AS name_109, b3_.short_name AS short_name_110, b3_.slug AS slug_111, b3_.search_terms AS search_terms_112, b3_.text AS text_113, b3_.text_female AS text_female_114, b3_.text_male AS text_male_115, b3_.highlighted AS highlighted_116, b3_.main_page_fragrance AS main_page_fragrance_117, b3_.highlighted_in_search AS highlighted_in_search_118, b3_.is_on_main_page AS is_on_main_page_119, b3_.special AS special_120, b3_.special_name AS special_name_121, b3_.slogan AS slogan_122, b3_.`lead` AS lead_123, b3_.active AS active_124, b3_.exclude_from_arukereso AS exclude_from_arukereso_125, f4_.id AS id_126, f4_.name AS name_127, c5_.id AS id_128, c5_.shortening AS shortening_129, c5_.description AS description_130, c5_.full_name AS full_name_131, c5_.short_name AS short_name_132, c5_.position AS position_133, h6_.id AS id_134, h6_.uuid AS uuid_135, h6_.location AS location_136, h6_.content_type AS content_type_137, h6_.metadata AS metadata_138, h6_.filesize AS filesize_139, h6_.url AS url_140, h6_.original_filename AS original_filename_141, h6_.deleted AS deleted_142, h6_.removed_from_file_system AS removed_from_file_system_143, h6_.protected AS protected_144, h6_.created_at AS created_at_145, h6_.updated_at AS updated_at_146, h7_.id AS id_147, h7_.rel AS rel_148, h7_.internal_name AS internal_name_149, h7_.lft AS lft_150, h7_.lvl AS lvl_151, h7_.rgt AS rgt_152, h7_.deleted AS deleted_153, h7_.internal AS internal_154, h7_.created_at AS created_at_155, h7_.updated_at AS updated_at_156, h8_.id AS id_157, h8_.uuid AS uuid_158, h8_.location AS location_159, h8_.content_type AS content_type_160, h8_.metadata AS metadata_161, h8_.filesize AS filesize_162, h8_.url AS url_163, h8_.original_filename AS original_filename_164, h8_.deleted AS deleted_165, h8_.removed_from_file_system AS removed_from_file_system_166, h8_.protected AS protected_167, h8_.created_at AS created_at_168, h8_.updated_at AS updated_at_169, h9_.id AS id_170, h9_.rel AS rel_171, h9_.internal_name AS internal_name_172, h9_.lft AS lft_173, h9_.lvl AS lvl_174, h9_.rgt AS rgt_175, h9_.deleted AS deleted_176, h9_.internal AS internal_177, h9_.created_at AS created_at_178, h9_.updated_at AS updated_at_179, p0_.product_id AS product_id_180, p1_.brand_id AS brand_id_181, p1_.product_category_id AS product_category_id_182, p1_.image_id AS image_id_183, p1_.tester_image_id AS tester_image_id_184, p1_.hover_image_id AS hover_image_id_185, p1_.facebook_image_id AS facebook_image_id_186, p1_.concentration_id AS concentration_id_187, p1_.fragrance_family_id AS fragrance_family_id_188, p1_.price_changer_id AS price_changer_id_189, p1_.data_changer_id AS data_changer_id_190, b3_.image_id AS image_id_191, h6_.folder_id AS folder_id_192, h7_.parent_id AS parent_id_193, h8_.folder_id AS folder_id_194, h9_.parent_id AS parent_id_195 FROM product_packaging p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id LEFT JOIN product_category p2_ ON p1_.product_category_id = p2_.id INNER JOIN brand b3_ ON p1_.brand_id = b3_.id LEFT JOIN fragrance_family f4_ ON p1_.fragrance_family_id = f4_.id LEFT JOIN concentration c5_ ON p1_.concentration_id = c5_.id LEFT JOIN hg_media_media h6_ ON p1_.image_id = h6_.id LEFT JOIN hg_media_folders h7_ ON h6_.folder_id = h7_.id LEFT JOIN hg_media_media h8_ ON p1_.hover_image_id = h8_.id LEFT JOIN hg_media_folders h9_ ON h8_.folder_id = h9_.id INNER JOIN main_menu_offer m10_ ON p0_.id = m10_.product_packaging_id AND (m10_.type = ?) WHERE p1_.active = 1 AND p0_.active = 1 AND (p0_.stock_limit = 0 OR p0_.stock_limit_type = ? OR p0_.stock_limit_stock > 0) AND (p1_.coming_soon IS NULL OR p1_.coming_soon <> 1) ORDER BY RAND() ASC LIMIT 4
Parameters:
[ "niche" "unavailable" ] |
| 44 | 1.06 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.cosmetics AS cosmetics_4, t0.taska AS taska_5, t0.gift_set AS gift_set_6, t0.hidden AS hidden_7, t0.single_name AS single_name_8, t0.plural_name AS plural_name_9, t0.position AS position_10, t0.`lead` AS lead_11, t0.seo_description AS seo_description_12, t0.title AS title_13 FROM product_category t0 WHERE t0.gift_set = ? LIMIT 1
Parameters:
[
1
]
|
| 45 | 1.30 ms |
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:
[ "top10-root" "hu" ] |
| 46 | 0.53 ms |
SELECT t0.remote_url AS remote_url_1, t0.id AS id_2, t0.title AS title_3, t0.page_title AS page_title_4 FROM app_folder_pages t0 WHERE t0.id = ?
Parameters:
[
12
]
|
| 47 | 1.16 ms |
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:
[ "top10-2025-noi" "hu" ] |
| 48 | 0.35 ms |
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:
[
52
]
|
| 49 | 0.96 ms |
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:
[ "top10-2025-ferfi" "hu" ] |
| 50 | 0.33 ms |
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:
[
53
]
|
| 51 | 0.98 ms |
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:
[ "top10-2024-noi" "hu" ] |
| 52 | 0.32 ms |
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:
[
45
]
|
| 53 | 0.94 ms |
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:
[ "top10-2024-ferfi" "hu" ] |
| 54 | 0.43 ms |
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:
[
46
]
|
| 55 | 6.45 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price AS price_2, p0_.price_in_euros AS price_in_euros_3, p0_.article_number AS article_number_4, p0_.total_ml AS total_ml_5, p0_.tester AS tester_6, p0_.cellofan AS cellofan_7, p0_.unboxed AS unboxed_8, p0_.hit AS hit_9, p0_.fragrance_sample AS fragrance_sample_10, p0_.is_on_main_page AS is_on_main_page_11, p0_.limited AS limited_12, p0_.reloaded AS reloaded_13, p0_.discount_hidden AS discount_hidden_14, p0_.discount_order_date AS discount_order_date_15, p0_.limit_order_date AS limit_order_date_16, p0_.novelty_order_date AS novelty_order_date_17, p0_.unavailable_soon_order_date AS unavailable_soon_order_date_18, p0_.move_first_order_date AS move_first_order_date_19, p0_.extra_discount AS extra_discount_20, p0_.stock AS stock_21, p0_.active AS active_22, p0_.available AS available_23, p0_.send_to_emag AS send_to_emag_24, p0_.emag_visible AS emag_visible_25, p0_.bb_visible AS bb_visible_26, p0_.sent_to_tharanis AS sent_to_tharanis_27, p0_.available_totally AS available_totally_28, p0_.ean AS ean_29, p0_.position AS position_30, p0_.discount AS discount_31, p0_.discount_price AS discount_price_32, p0_.discount_price_in_euros AS discount_price_in_euros_33, p0_.discount_stock AS discount_stock_34, p0_.discount_constant AS discount_constant_35, p0_.stock_limit AS stock_limit_36, p0_.stock_limit_type AS stock_limit_type_37, p0_.stock_limit_stock AS stock_limit_stock_38, p0_.outlet AS outlet_39, p0_.sold AS sold_40, p0_.fix_priced AS fix_priced_41, p0_.discount_note AS discount_note_42, p0_.stock_limit_note AS stock_limit_note_43, p0_.arukereso_marketplace_disabled AS arukereso_marketplace_disabled_44, p0_.mini_perfume AS mini_perfume_45, p0_.minimum_priced AS minimum_priced_46, p0_.arukereso_appearance AS arukereso_appearance_47, p0_.pepita_appearance AS pepita_appearance_48, p0_.refiller AS refiller_49, p0_.best_price AS best_price_50, p1_.id AS id_51, p1_.article_number AS article_number_52, p1_.name AS name_53, p1_.search_terms AS search_terms_54, p1_.year AS year_55, p1_.gender AS gender_56, p1_.coming_soon AS coming_soon_57, p1_.novelty AS novelty_58, p1_.discount AS discount_59, p1_.unavailable_soon AS unavailable_soon_60, p1_.niche AS niche_61, p1_.exclusive AS exclusive_62, p1_.limited_edition AS limited_edition_63, p1_.outlet AS outlet_64, p1_.rarity AS rarity_65, p1_.available_again AS available_again_66, p1_.limited AS limited_67, p1_.active AS active_68, p1_.info_link AS info_link_69, p1_.description AS description_70, p1_.fragrance_description AS fragrance_description_71, p1_.meta_description AS meta_description_72, p1_.meta_keywords AS meta_keywords_73, p1_.facebook_description AS facebook_description_74, p1_.minimum_price AS minimum_price_75, p1_.discounted_minimum_price AS discounted_minimum_price_76, p1_.url AS url_77, p1_.sold AS sold_78, p1_.just_arrived AS just_arrived_79, p1_.is_on_main_page AS is_on_main_page_80, p1_.discount_order_date AS discount_order_date_81, p1_.novelty_order_date AS novelty_order_date_82, p1_.unavailable_soon_order_date AS unavailable_soon_order_date_83, p1_.move_first_order_date AS move_first_order_date_84, p1_.slogan AS slogan_85, p1_.price_changed_at AS price_changed_at_86, p1_.data_changed_at AS data_changed_at_87, p1_.price_for_sort AS price_for_sort_88, p1_.introduction_price AS introduction_price_89, p1_.special AS special_90, p1_.purchasable AS purchasable_91, p1_.fix_priced AS fix_priced_92, p1_.created_at AS created_at_93, p1_.updated_at AS updated_at_94, p2_.id AS id_95, p2_.name AS name_96, p2_.code AS code_97, p2_.cosmetics AS cosmetics_98, p2_.taska AS taska_99, p2_.gift_set AS gift_set_100, p2_.hidden AS hidden_101, p2_.single_name AS single_name_102, p2_.plural_name AS plural_name_103, p2_.position AS position_104, p2_.`lead` AS lead_105, p2_.seo_description AS seo_description_106, p2_.title AS title_107, b3_.id AS id_108, b3_.name AS name_109, b3_.short_name AS short_name_110, b3_.slug AS slug_111, b3_.search_terms AS search_terms_112, b3_.text AS text_113, b3_.text_female AS text_female_114, b3_.text_male AS text_male_115, b3_.highlighted AS highlighted_116, b3_.main_page_fragrance AS main_page_fragrance_117, b3_.highlighted_in_search AS highlighted_in_search_118, b3_.is_on_main_page AS is_on_main_page_119, b3_.special AS special_120, b3_.special_name AS special_name_121, b3_.slogan AS slogan_122, b3_.`lead` AS lead_123, b3_.active AS active_124, b3_.exclude_from_arukereso AS exclude_from_arukereso_125, f4_.id AS id_126, f4_.name AS name_127, c5_.id AS id_128, c5_.shortening AS shortening_129, c5_.description AS description_130, c5_.full_name AS full_name_131, c5_.short_name AS short_name_132, c5_.position AS position_133, h6_.id AS id_134, h6_.uuid AS uuid_135, h6_.location AS location_136, h6_.content_type AS content_type_137, h6_.metadata AS metadata_138, h6_.filesize AS filesize_139, h6_.url AS url_140, h6_.original_filename AS original_filename_141, h6_.deleted AS deleted_142, h6_.removed_from_file_system AS removed_from_file_system_143, h6_.protected AS protected_144, h6_.created_at AS created_at_145, h6_.updated_at AS updated_at_146, h7_.id AS id_147, h7_.rel AS rel_148, h7_.internal_name AS internal_name_149, h7_.lft AS lft_150, h7_.lvl AS lvl_151, h7_.rgt AS rgt_152, h7_.deleted AS deleted_153, h7_.internal AS internal_154, h7_.created_at AS created_at_155, h7_.updated_at AS updated_at_156, h8_.id AS id_157, h8_.uuid AS uuid_158, h8_.location AS location_159, h8_.content_type AS content_type_160, h8_.metadata AS metadata_161, h8_.filesize AS filesize_162, h8_.url AS url_163, h8_.original_filename AS original_filename_164, h8_.deleted AS deleted_165, h8_.removed_from_file_system AS removed_from_file_system_166, h8_.protected AS protected_167, h8_.created_at AS created_at_168, h8_.updated_at AS updated_at_169, h9_.id AS id_170, h9_.rel AS rel_171, h9_.internal_name AS internal_name_172, h9_.lft AS lft_173, h9_.lvl AS lvl_174, h9_.rgt AS rgt_175, h9_.deleted AS deleted_176, h9_.internal AS internal_177, h9_.created_at AS created_at_178, h9_.updated_at AS updated_at_179, p0_.product_id AS product_id_180, p1_.brand_id AS brand_id_181, p1_.product_category_id AS product_category_id_182, p1_.image_id AS image_id_183, p1_.tester_image_id AS tester_image_id_184, p1_.hover_image_id AS hover_image_id_185, p1_.facebook_image_id AS facebook_image_id_186, p1_.concentration_id AS concentration_id_187, p1_.fragrance_family_id AS fragrance_family_id_188, p1_.price_changer_id AS price_changer_id_189, p1_.data_changer_id AS data_changer_id_190, b3_.image_id AS image_id_191, h6_.folder_id AS folder_id_192, h7_.parent_id AS parent_id_193, h8_.folder_id AS folder_id_194, h9_.parent_id AS parent_id_195 FROM product_packaging p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id LEFT JOIN product_category p2_ ON p1_.product_category_id = p2_.id INNER JOIN brand b3_ ON p1_.brand_id = b3_.id LEFT JOIN fragrance_family f4_ ON p1_.fragrance_family_id = f4_.id LEFT JOIN concentration c5_ ON p1_.concentration_id = c5_.id LEFT JOIN hg_media_media h6_ ON p1_.image_id = h6_.id LEFT JOIN hg_media_folders h7_ ON h6_.folder_id = h7_.id LEFT JOIN hg_media_media h8_ ON p1_.hover_image_id = h8_.id LEFT JOIN hg_media_folders h9_ ON h8_.folder_id = h9_.id INNER JOIN main_menu_offer m10_ ON p0_.id = m10_.product_packaging_id AND (m10_.type = ?) WHERE p1_.active = 1 AND p0_.active = 1 AND (p0_.stock_limit = 0 OR p0_.stock_limit_type = ? OR p0_.stock_limit_stock > 0) AND (p1_.coming_soon IS NULL OR p1_.coming_soon <> 1) ORDER BY RAND() ASC LIMIT 4
Parameters:
[ "top10" "unavailable" ] |
| 56 | 6.12 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price AS price_2, p0_.price_in_euros AS price_in_euros_3, p0_.article_number AS article_number_4, p0_.total_ml AS total_ml_5, p0_.tester AS tester_6, p0_.cellofan AS cellofan_7, p0_.unboxed AS unboxed_8, p0_.hit AS hit_9, p0_.fragrance_sample AS fragrance_sample_10, p0_.is_on_main_page AS is_on_main_page_11, p0_.limited AS limited_12, p0_.reloaded AS reloaded_13, p0_.discount_hidden AS discount_hidden_14, p0_.discount_order_date AS discount_order_date_15, p0_.limit_order_date AS limit_order_date_16, p0_.novelty_order_date AS novelty_order_date_17, p0_.unavailable_soon_order_date AS unavailable_soon_order_date_18, p0_.move_first_order_date AS move_first_order_date_19, p0_.extra_discount AS extra_discount_20, p0_.stock AS stock_21, p0_.active AS active_22, p0_.available AS available_23, p0_.send_to_emag AS send_to_emag_24, p0_.emag_visible AS emag_visible_25, p0_.bb_visible AS bb_visible_26, p0_.sent_to_tharanis AS sent_to_tharanis_27, p0_.available_totally AS available_totally_28, p0_.ean AS ean_29, p0_.position AS position_30, p0_.discount AS discount_31, p0_.discount_price AS discount_price_32, p0_.discount_price_in_euros AS discount_price_in_euros_33, p0_.discount_stock AS discount_stock_34, p0_.discount_constant AS discount_constant_35, p0_.stock_limit AS stock_limit_36, p0_.stock_limit_type AS stock_limit_type_37, p0_.stock_limit_stock AS stock_limit_stock_38, p0_.outlet AS outlet_39, p0_.sold AS sold_40, p0_.fix_priced AS fix_priced_41, p0_.discount_note AS discount_note_42, p0_.stock_limit_note AS stock_limit_note_43, p0_.arukereso_marketplace_disabled AS arukereso_marketplace_disabled_44, p0_.mini_perfume AS mini_perfume_45, p0_.minimum_priced AS minimum_priced_46, p0_.arukereso_appearance AS arukereso_appearance_47, p0_.pepita_appearance AS pepita_appearance_48, p0_.refiller AS refiller_49, p0_.best_price AS best_price_50, p1_.id AS id_51, p1_.article_number AS article_number_52, p1_.name AS name_53, p1_.search_terms AS search_terms_54, p1_.year AS year_55, p1_.gender AS gender_56, p1_.coming_soon AS coming_soon_57, p1_.novelty AS novelty_58, p1_.discount AS discount_59, p1_.unavailable_soon AS unavailable_soon_60, p1_.niche AS niche_61, p1_.exclusive AS exclusive_62, p1_.limited_edition AS limited_edition_63, p1_.outlet AS outlet_64, p1_.rarity AS rarity_65, p1_.available_again AS available_again_66, p1_.limited AS limited_67, p1_.active AS active_68, p1_.info_link AS info_link_69, p1_.description AS description_70, p1_.fragrance_description AS fragrance_description_71, p1_.meta_description AS meta_description_72, p1_.meta_keywords AS meta_keywords_73, p1_.facebook_description AS facebook_description_74, p1_.minimum_price AS minimum_price_75, p1_.discounted_minimum_price AS discounted_minimum_price_76, p1_.url AS url_77, p1_.sold AS sold_78, p1_.just_arrived AS just_arrived_79, p1_.is_on_main_page AS is_on_main_page_80, p1_.discount_order_date AS discount_order_date_81, p1_.novelty_order_date AS novelty_order_date_82, p1_.unavailable_soon_order_date AS unavailable_soon_order_date_83, p1_.move_first_order_date AS move_first_order_date_84, p1_.slogan AS slogan_85, p1_.price_changed_at AS price_changed_at_86, p1_.data_changed_at AS data_changed_at_87, p1_.price_for_sort AS price_for_sort_88, p1_.introduction_price AS introduction_price_89, p1_.special AS special_90, p1_.purchasable AS purchasable_91, p1_.fix_priced AS fix_priced_92, p1_.created_at AS created_at_93, p1_.updated_at AS updated_at_94, p2_.id AS id_95, p2_.name AS name_96, p2_.code AS code_97, p2_.cosmetics AS cosmetics_98, p2_.taska AS taska_99, p2_.gift_set AS gift_set_100, p2_.hidden AS hidden_101, p2_.single_name AS single_name_102, p2_.plural_name AS plural_name_103, p2_.position AS position_104, p2_.`lead` AS lead_105, p2_.seo_description AS seo_description_106, p2_.title AS title_107, b3_.id AS id_108, b3_.name AS name_109, b3_.short_name AS short_name_110, b3_.slug AS slug_111, b3_.search_terms AS search_terms_112, b3_.text AS text_113, b3_.text_female AS text_female_114, b3_.text_male AS text_male_115, b3_.highlighted AS highlighted_116, b3_.main_page_fragrance AS main_page_fragrance_117, b3_.highlighted_in_search AS highlighted_in_search_118, b3_.is_on_main_page AS is_on_main_page_119, b3_.special AS special_120, b3_.special_name AS special_name_121, b3_.slogan AS slogan_122, b3_.`lead` AS lead_123, b3_.active AS active_124, b3_.exclude_from_arukereso AS exclude_from_arukereso_125, f4_.id AS id_126, f4_.name AS name_127, c5_.id AS id_128, c5_.shortening AS shortening_129, c5_.description AS description_130, c5_.full_name AS full_name_131, c5_.short_name AS short_name_132, c5_.position AS position_133, h6_.id AS id_134, h6_.uuid AS uuid_135, h6_.location AS location_136, h6_.content_type AS content_type_137, h6_.metadata AS metadata_138, h6_.filesize AS filesize_139, h6_.url AS url_140, h6_.original_filename AS original_filename_141, h6_.deleted AS deleted_142, h6_.removed_from_file_system AS removed_from_file_system_143, h6_.protected AS protected_144, h6_.created_at AS created_at_145, h6_.updated_at AS updated_at_146, h7_.id AS id_147, h7_.rel AS rel_148, h7_.internal_name AS internal_name_149, h7_.lft AS lft_150, h7_.lvl AS lvl_151, h7_.rgt AS rgt_152, h7_.deleted AS deleted_153, h7_.internal AS internal_154, h7_.created_at AS created_at_155, h7_.updated_at AS updated_at_156, h8_.id AS id_157, h8_.uuid AS uuid_158, h8_.location AS location_159, h8_.content_type AS content_type_160, h8_.metadata AS metadata_161, h8_.filesize AS filesize_162, h8_.url AS url_163, h8_.original_filename AS original_filename_164, h8_.deleted AS deleted_165, h8_.removed_from_file_system AS removed_from_file_system_166, h8_.protected AS protected_167, h8_.created_at AS created_at_168, h8_.updated_at AS updated_at_169, h9_.id AS id_170, h9_.rel AS rel_171, h9_.internal_name AS internal_name_172, h9_.lft AS lft_173, h9_.lvl AS lvl_174, h9_.rgt AS rgt_175, h9_.deleted AS deleted_176, h9_.internal AS internal_177, h9_.created_at AS created_at_178, h9_.updated_at AS updated_at_179, p0_.product_id AS product_id_180, p1_.brand_id AS brand_id_181, p1_.product_category_id AS product_category_id_182, p1_.image_id AS image_id_183, p1_.tester_image_id AS tester_image_id_184, p1_.hover_image_id AS hover_image_id_185, p1_.facebook_image_id AS facebook_image_id_186, p1_.concentration_id AS concentration_id_187, p1_.fragrance_family_id AS fragrance_family_id_188, p1_.price_changer_id AS price_changer_id_189, p1_.data_changer_id AS data_changer_id_190, b3_.image_id AS image_id_191, h6_.folder_id AS folder_id_192, h7_.parent_id AS parent_id_193, h8_.folder_id AS folder_id_194, h9_.parent_id AS parent_id_195 FROM product_packaging p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id LEFT JOIN product_category p2_ ON p1_.product_category_id = p2_.id INNER JOIN brand b3_ ON p1_.brand_id = b3_.id LEFT JOIN fragrance_family f4_ ON p1_.fragrance_family_id = f4_.id LEFT JOIN concentration c5_ ON p1_.concentration_id = c5_.id LEFT JOIN hg_media_media h6_ ON p1_.image_id = h6_.id LEFT JOIN hg_media_folders h7_ ON h6_.folder_id = h7_.id LEFT JOIN hg_media_media h8_ ON p1_.hover_image_id = h8_.id LEFT JOIN hg_media_folders h9_ ON h8_.folder_id = h9_.id INNER JOIN main_menu_offer m10_ ON p0_.id = m10_.product_packaging_id AND (m10_.type = ?) WHERE p1_.active = 1 AND p0_.active = 1 AND (p0_.stock_limit = 0 OR p0_.stock_limit_type = ? OR p0_.stock_limit_stock > 0) AND (p1_.coming_soon IS NULL OR p1_.coming_soon <> 1) ORDER BY RAND() ASC LIMIT 4
Parameters:
[ "sample" "unavailable" ] |
| 57 | 1.10 ms |
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:
[ "home_above_slider" "2026-01-31 11:41:41" "2026-01-31 11:41:41" ] |
| 58 | 0.85 ms |
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:
[ 1 "App\Entity\Pages\HomePage" "slider_mobile" ] |
| 59 | 0.58 ms |
SELECT t0.id AS id_1 FROM app_slider_mobile_page_parts t0 WHERE t0.id IN (?)
Parameters:
[
1
]
|
| 60 | 1.00 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.is_default AS is_default_2, s0_.from_time AS from_time_3, s0_.to_time AS to_time_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6 FROM slider_mobile s0_ WHERE s0_.is_default = 1 OR (s0_.from_time <= ? AND s0_.to_time >= ?) ORDER BY s0_.is_default ASC, RAND() ASC LIMIT 1
Parameters:
[ "2026-01-31 11:41:41" "2026-01-31 11:41:41" ] |
| 61 | 1.17 ms |
SELECT t0.id AS id_1, t0.link AS link_2, t0.new_window AS new_window_3, t0.active AS active_4, t0.from_time AS from_time_5, t0.to_time AS to_time_6, t0.position AS position_7, t0.slider_mobile_id AS slider_mobile_id_8, t0.image_id AS image_id_9 FROM slider_mobile_image t0 WHERE t0.slider_mobile_id = ? ORDER BY t0.position ASC
Parameters:
[
2
]
|
| 62 | 0.89 ms |
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:
[
59264
]
|
| 63 | 0.83 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.copyright AS copyright_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM hg_media_media_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 59264 "hu" ] |
| 64 | 0.57 ms |
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:
[
59271
]
|
| 65 | 0.65 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.copyright AS copyright_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM hg_media_media_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 59271 "hu" ] |
| 66 | 1.10 ms |
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:
[ "fooldal_mobile_lower" "2026-01-31 11:41:41" "2026-01-31 11:41:41" ] |
| 67 | 1.48 ms |
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:
[ 1 "App\Entity\Pages\HomePage" "home_mobile" ] |
| 68 | 0.80 ms |
SELECT t0.link AS link_1, t0.alt_text AS alt_text_2, t0.image_title AS image_title_3, t0.new_window AS new_window_4, t0.from_time AS from_time_5, t0.to_time AS to_time_6, t0.bordered AS bordered_7, t0.id AS id_8, t0.image_id AS image_id_9 FROM app_home_single_banner_page_parts t0 WHERE t0.id IN (?, ?, ?, ?)
Parameters:
[ 63 30 1 2 ] |
| 69 | 0.57 ms |
SELECT t0.id AS id_1 FROM app_home_mobile_recentlies_page_parts t0 WHERE t0.id IN (?)
Parameters:
[
1
]
|
| 70 | 0.54 ms |
SELECT t0.id AS id_1 FROM app_home_teaser_mobile_page_parts t0 WHERE t0.id IN (?)
Parameters:
[
1
]
|
| 71 | 0.56 ms |
SELECT t0.id AS id_1 FROM app_home_mobile_contact_page_parts t0 WHERE t0.id IN (?)
Parameters:
[
1
]
|
| 72 | 0.59 ms |
SELECT t0.id AS id_1 FROM app_home_mobile_links_page_parts t0 WHERE t0.id IN (?)
Parameters:
[
1
]
|
| 73 | 0.86 ms |
SELECT t0.title AS title_1, t0.id AS id_2 FROM app_home_mobile_blog_teaser_page_parts t0 WHERE t0.id IN (?)
Parameters:
[
1
]
|
| 74 | 0.66 ms |
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:
[
59421
]
|
| 75 | 0.51 ms |
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:
[
59272
]
|
| 76 | 1.33 ms |
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:
[ "blog" "hu" ] |
| 77 | 0.57 ms |
SELECT DATABASE()
Parameters:
[] |
| 78 | 0.46 ms |
SELECT DATABASE()
Parameters:
[] |
| 79 | 13.04 ms |
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) LEFT JOIN app_blog_entry_pages a3_ ON (a3_.id = h2_.ref_id AND h2_.ref_entity_name = ?) 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 AND h0_.lft >= ? AND h0_.rgt <= ? AND h2_.ref_entity_name = ? AND h1_.online = 1 ORDER BY a3_.highlighted DESC, a3_.published_at DESC, RAND() ASC LIMIT 4
Parameters:
[ "hu" "App\Entity\Pages\BlogEntryPage" 316 937 "App\Entity\Pages\BlogEntryPage" ] |
| 80 | 0.74 ms |
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:
[
850
]
|
| 81 | 0.58 ms |
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:
[
849
]
|
| 82 | 0.46 ms |
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:
[
848
]
|
| 83 | 0.34 ms |
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:
[
847
]
|
| 84 | 1.02 ms |
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:
[
59728
]
|
| 85 | 0.89 ms |
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:
[
59670
]
|
| 86 | 0.75 ms |
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:
[
59644
]
|
| 87 | 0.68 ms |
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:
[
59614
]
|
| 88 | 1.75 ms |
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:
[ "blog" "hu" ] |
| 89 | 0.69 ms |
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
]
|
| 90 | 1.02 ms |
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:
[ 1 "App\Entity\Pages\HomePage" "slider" ] |
| 91 | 0.68 ms |
SELECT t0.id AS id_1 FROM app_slider_page_parts t0 WHERE t0.id IN (?)
Parameters:
[
1
]
|
| 92 | 1.19 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.is_default AS is_default_2, s0_.from_time AS from_time_3, s0_.to_time AS to_time_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6 FROM slider s0_ WHERE s0_.is_default = 1 OR (s0_.from_time <= ? AND s0_.to_time >= ?) ORDER BY s0_.is_default ASC, RAND() ASC LIMIT 1
Parameters:
[ "2026-01-31 11:41:41" "2026-01-31 11:41:41" ] |
| 93 | 2.96 ms |
SELECT t0.id AS id_1, t0.link AS link_2, t0.new_window AS new_window_3, t0.active AS active_4, t0.from_time AS from_time_5, t0.to_time AS to_time_6, t0.position AS position_7, t0.slider_id AS slider_id_8, t0.image_id AS image_id_9 FROM slider_image t0 WHERE t0.slider_id = ? ORDER BY t0.position ASC
Parameters:
[
1
]
|
| 94 | 0.79 ms |
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:
[
59269
]
|
| 95 | 0.66 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.copyright AS copyright_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM hg_media_media_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 59269 "hu" ] |
| 96 | 1.54 ms |
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:
[
59270
]
|
| 97 | 0.49 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.copyright AS copyright_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM hg_media_media_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 59270 "hu" ] |
| 98 | 0.67 ms |
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:
[ 1 "App\Entity\Pages\HomePage" "home" ] |
| 99 | 0.80 ms |
SELECT t0.link_left AS link_left_1, t0.alt_text_left AS alt_text_left_2, t0.image_title_left AS image_title_left_3, t0.new_window_left AS new_window_left_4, t0.link_right AS link_right_5, t0.alt_text_right AS alt_text_right_6, t0.image_title_right AS image_title_right_7, t0.new_window_right AS new_window_right_8, t0.from_time AS from_time_9, t0.to_time AS to_time_10, t0.id AS id_11, t0.image_left_id AS image_left_id_12, t0.image_right_id AS image_right_id_13 FROM app_home_double_banner_page_parts t0 WHERE t0.id IN (?, ?)
Parameters:
[ 15 1 ] |
| 100 | 0.53 ms |
SELECT t0.id AS id_1 FROM app_home_recentlies_page_parts t0 WHERE t0.id IN (?)
Parameters:
[
1
]
|
| 101 | 0.41 ms |
SELECT t0.id AS id_1 FROM app_home_line_page_parts t0 WHERE t0.id IN (?, ?)
Parameters:
[ 1 2 ] |
| 102 | 0.52 ms |
SELECT t0.title AS title_1, t0.teaser_type AS teaser_type_2, t0.gender AS gender_3, t0.`rows` AS rows_4, t0.button_title AS button_title_5, t0.button_url AS button_url_6, t0.id AS id_7 FROM app_home_product_teaser_page_parts t0 WHERE t0.id IN (?, ?)
Parameters:
[ 1 2 ] |
| 103 | 0.41 ms |
SELECT t0.title AS title_1, t0.id AS id_2 FROM app_home_blog_teaser_page_parts t0 WHERE t0.id IN (?)
Parameters:
[
1
]
|
| 104 | 37.42 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price AS price_2, p0_.price_in_euros AS price_in_euros_3, p0_.article_number AS article_number_4, p0_.total_ml AS total_ml_5, p0_.tester AS tester_6, p0_.cellofan AS cellofan_7, p0_.unboxed AS unboxed_8, p0_.hit AS hit_9, p0_.fragrance_sample AS fragrance_sample_10, p0_.is_on_main_page AS is_on_main_page_11, p0_.limited AS limited_12, p0_.reloaded AS reloaded_13, p0_.discount_hidden AS discount_hidden_14, p0_.discount_order_date AS discount_order_date_15, p0_.limit_order_date AS limit_order_date_16, p0_.novelty_order_date AS novelty_order_date_17, p0_.unavailable_soon_order_date AS unavailable_soon_order_date_18, p0_.move_first_order_date AS move_first_order_date_19, p0_.extra_discount AS extra_discount_20, p0_.stock AS stock_21, p0_.active AS active_22, p0_.available AS available_23, p0_.send_to_emag AS send_to_emag_24, p0_.emag_visible AS emag_visible_25, p0_.bb_visible AS bb_visible_26, p0_.sent_to_tharanis AS sent_to_tharanis_27, p0_.available_totally AS available_totally_28, p0_.ean AS ean_29, p0_.position AS position_30, p0_.discount AS discount_31, p0_.discount_price AS discount_price_32, p0_.discount_price_in_euros AS discount_price_in_euros_33, p0_.discount_stock AS discount_stock_34, p0_.discount_constant AS discount_constant_35, p0_.stock_limit AS stock_limit_36, p0_.stock_limit_type AS stock_limit_type_37, p0_.stock_limit_stock AS stock_limit_stock_38, p0_.outlet AS outlet_39, p0_.sold AS sold_40, p0_.fix_priced AS fix_priced_41, p0_.discount_note AS discount_note_42, p0_.stock_limit_note AS stock_limit_note_43, p0_.arukereso_marketplace_disabled AS arukereso_marketplace_disabled_44, p0_.mini_perfume AS mini_perfume_45, p0_.minimum_priced AS minimum_priced_46, p0_.arukereso_appearance AS arukereso_appearance_47, p0_.pepita_appearance AS pepita_appearance_48, p0_.refiller AS refiller_49, p0_.best_price AS best_price_50, p1_.id AS id_51, p1_.article_number AS article_number_52, p1_.name AS name_53, p1_.search_terms AS search_terms_54, p1_.year AS year_55, p1_.gender AS gender_56, p1_.coming_soon AS coming_soon_57, p1_.novelty AS novelty_58, p1_.discount AS discount_59, p1_.unavailable_soon AS unavailable_soon_60, p1_.niche AS niche_61, p1_.exclusive AS exclusive_62, p1_.limited_edition AS limited_edition_63, p1_.outlet AS outlet_64, p1_.rarity AS rarity_65, p1_.available_again AS available_again_66, p1_.limited AS limited_67, p1_.active AS active_68, p1_.info_link AS info_link_69, p1_.description AS description_70, p1_.fragrance_description AS fragrance_description_71, p1_.meta_description AS meta_description_72, p1_.meta_keywords AS meta_keywords_73, p1_.facebook_description AS facebook_description_74, p1_.minimum_price AS minimum_price_75, p1_.discounted_minimum_price AS discounted_minimum_price_76, p1_.url AS url_77, p1_.sold AS sold_78, p1_.just_arrived AS just_arrived_79, p1_.is_on_main_page AS is_on_main_page_80, p1_.discount_order_date AS discount_order_date_81, p1_.novelty_order_date AS novelty_order_date_82, p1_.unavailable_soon_order_date AS unavailable_soon_order_date_83, p1_.move_first_order_date AS move_first_order_date_84, p1_.slogan AS slogan_85, p1_.price_changed_at AS price_changed_at_86, p1_.data_changed_at AS data_changed_at_87, p1_.price_for_sort AS price_for_sort_88, p1_.introduction_price AS introduction_price_89, p1_.special AS special_90, p1_.purchasable AS purchasable_91, p1_.fix_priced AS fix_priced_92, p1_.created_at AS created_at_93, p1_.updated_at AS updated_at_94, p2_.id AS id_95, p2_.name AS name_96, p2_.code AS code_97, p2_.cosmetics AS cosmetics_98, p2_.taska AS taska_99, p2_.gift_set AS gift_set_100, p2_.hidden AS hidden_101, p2_.single_name AS single_name_102, p2_.plural_name AS plural_name_103, p2_.position AS position_104, p2_.`lead` AS lead_105, p2_.seo_description AS seo_description_106, p2_.title AS title_107, b3_.id AS id_108, b3_.name AS name_109, b3_.short_name AS short_name_110, b3_.slug AS slug_111, b3_.search_terms AS search_terms_112, b3_.text AS text_113, b3_.text_female AS text_female_114, b3_.text_male AS text_male_115, b3_.highlighted AS highlighted_116, b3_.main_page_fragrance AS main_page_fragrance_117, b3_.highlighted_in_search AS highlighted_in_search_118, b3_.is_on_main_page AS is_on_main_page_119, b3_.special AS special_120, b3_.special_name AS special_name_121, b3_.slogan AS slogan_122, b3_.`lead` AS lead_123, b3_.active AS active_124, b3_.exclude_from_arukereso AS exclude_from_arukereso_125, f4_.id AS id_126, f4_.name AS name_127, c5_.id AS id_128, c5_.shortening AS shortening_129, c5_.description AS description_130, c5_.full_name AS full_name_131, c5_.short_name AS short_name_132, c5_.position AS position_133, h6_.id AS id_134, h6_.uuid AS uuid_135, h6_.location AS location_136, h6_.content_type AS content_type_137, h6_.metadata AS metadata_138, h6_.filesize AS filesize_139, h6_.url AS url_140, h6_.original_filename AS original_filename_141, h6_.deleted AS deleted_142, h6_.removed_from_file_system AS removed_from_file_system_143, h6_.protected AS protected_144, h6_.created_at AS created_at_145, h6_.updated_at AS updated_at_146, h7_.id AS id_147, h7_.rel AS rel_148, h7_.internal_name AS internal_name_149, h7_.lft AS lft_150, h7_.lvl AS lvl_151, h7_.rgt AS rgt_152, h7_.deleted AS deleted_153, h7_.internal AS internal_154, h7_.created_at AS created_at_155, h7_.updated_at AS updated_at_156, h8_.id AS id_157, h8_.uuid AS uuid_158, h8_.location AS location_159, h8_.content_type AS content_type_160, h8_.metadata AS metadata_161, h8_.filesize AS filesize_162, h8_.url AS url_163, h8_.original_filename AS original_filename_164, h8_.deleted AS deleted_165, h8_.removed_from_file_system AS removed_from_file_system_166, h8_.protected AS protected_167, h8_.created_at AS created_at_168, h8_.updated_at AS updated_at_169, h9_.id AS id_170, h9_.rel AS rel_171, h9_.internal_name AS internal_name_172, h9_.lft AS lft_173, h9_.lvl AS lvl_174, h9_.rgt AS rgt_175, h9_.deleted AS deleted_176, h9_.internal AS internal_177, h9_.created_at AS created_at_178, h9_.updated_at AS updated_at_179, p0_.product_id AS product_id_180, p1_.brand_id AS brand_id_181, p1_.product_category_id AS product_category_id_182, p1_.image_id AS image_id_183, p1_.tester_image_id AS tester_image_id_184, p1_.hover_image_id AS hover_image_id_185, p1_.facebook_image_id AS facebook_image_id_186, p1_.concentration_id AS concentration_id_187, p1_.fragrance_family_id AS fragrance_family_id_188, p1_.price_changer_id AS price_changer_id_189, p1_.data_changer_id AS data_changer_id_190, b3_.image_id AS image_id_191, h6_.folder_id AS folder_id_192, h7_.parent_id AS parent_id_193, h8_.folder_id AS folder_id_194, h9_.parent_id AS parent_id_195 FROM product_packaging p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id LEFT JOIN product_category p2_ ON p1_.product_category_id = p2_.id INNER JOIN brand b3_ ON p1_.brand_id = b3_.id LEFT JOIN fragrance_family f4_ ON p1_.fragrance_family_id = f4_.id LEFT JOIN concentration c5_ ON p1_.concentration_id = c5_.id LEFT JOIN hg_media_media h6_ ON p1_.image_id = h6_.id LEFT JOIN hg_media_folders h7_ ON h6_.folder_id = h7_.id LEFT JOIN hg_media_media h8_ ON p1_.hover_image_id = h8_.id LEFT JOIN hg_media_folders h9_ ON h8_.folder_id = h9_.id WHERE p1_.active = 1 AND p0_.active = 1 AND (p0_.stock_limit = 0 OR p0_.stock_limit_stock > 0) AND p0_.available = 1 AND (p1_.coming_soon IS NULL OR p1_.coming_soon <> 1) AND p1_.novelty = 1 AND ((p0_.discount = 1 AND (p0_.discount_stock > 0 OR p0_.discount_constant = 1)) OR ((p0_.discount = 0 OR p0_.discount_stock <= 0) AND p0_.position = 1)) AND p1_.gender = ? ORDER BY p1_.is_on_main_page DESC, RAND() ASC, p0_.discount_order_date DESC, CONCAT(b3_.name, ?, p1_.name) ASC LIMIT 30
Parameters:
[ "n" " " ] |
| 105 | 15.85 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price AS price_2, p0_.price_in_euros AS price_in_euros_3, p0_.article_number AS article_number_4, p0_.total_ml AS total_ml_5, p0_.tester AS tester_6, p0_.cellofan AS cellofan_7, p0_.unboxed AS unboxed_8, p0_.hit AS hit_9, p0_.fragrance_sample AS fragrance_sample_10, p0_.is_on_main_page AS is_on_main_page_11, p0_.limited AS limited_12, p0_.reloaded AS reloaded_13, p0_.discount_hidden AS discount_hidden_14, p0_.discount_order_date AS discount_order_date_15, p0_.limit_order_date AS limit_order_date_16, p0_.novelty_order_date AS novelty_order_date_17, p0_.unavailable_soon_order_date AS unavailable_soon_order_date_18, p0_.move_first_order_date AS move_first_order_date_19, p0_.extra_discount AS extra_discount_20, p0_.stock AS stock_21, p0_.active AS active_22, p0_.available AS available_23, p0_.send_to_emag AS send_to_emag_24, p0_.emag_visible AS emag_visible_25, p0_.bb_visible AS bb_visible_26, p0_.sent_to_tharanis AS sent_to_tharanis_27, p0_.available_totally AS available_totally_28, p0_.ean AS ean_29, p0_.position AS position_30, p0_.discount AS discount_31, p0_.discount_price AS discount_price_32, p0_.discount_price_in_euros AS discount_price_in_euros_33, p0_.discount_stock AS discount_stock_34, p0_.discount_constant AS discount_constant_35, p0_.stock_limit AS stock_limit_36, p0_.stock_limit_type AS stock_limit_type_37, p0_.stock_limit_stock AS stock_limit_stock_38, p0_.outlet AS outlet_39, p0_.sold AS sold_40, p0_.fix_priced AS fix_priced_41, p0_.discount_note AS discount_note_42, p0_.stock_limit_note AS stock_limit_note_43, p0_.arukereso_marketplace_disabled AS arukereso_marketplace_disabled_44, p0_.mini_perfume AS mini_perfume_45, p0_.minimum_priced AS minimum_priced_46, p0_.arukereso_appearance AS arukereso_appearance_47, p0_.pepita_appearance AS pepita_appearance_48, p0_.refiller AS refiller_49, p0_.best_price AS best_price_50, p1_.id AS id_51, p1_.article_number AS article_number_52, p1_.name AS name_53, p1_.search_terms AS search_terms_54, p1_.year AS year_55, p1_.gender AS gender_56, p1_.coming_soon AS coming_soon_57, p1_.novelty AS novelty_58, p1_.discount AS discount_59, p1_.unavailable_soon AS unavailable_soon_60, p1_.niche AS niche_61, p1_.exclusive AS exclusive_62, p1_.limited_edition AS limited_edition_63, p1_.outlet AS outlet_64, p1_.rarity AS rarity_65, p1_.available_again AS available_again_66, p1_.limited AS limited_67, p1_.active AS active_68, p1_.info_link AS info_link_69, p1_.description AS description_70, p1_.fragrance_description AS fragrance_description_71, p1_.meta_description AS meta_description_72, p1_.meta_keywords AS meta_keywords_73, p1_.facebook_description AS facebook_description_74, p1_.minimum_price AS minimum_price_75, p1_.discounted_minimum_price AS discounted_minimum_price_76, p1_.url AS url_77, p1_.sold AS sold_78, p1_.just_arrived AS just_arrived_79, p1_.is_on_main_page AS is_on_main_page_80, p1_.discount_order_date AS discount_order_date_81, p1_.novelty_order_date AS novelty_order_date_82, p1_.unavailable_soon_order_date AS unavailable_soon_order_date_83, p1_.move_first_order_date AS move_first_order_date_84, p1_.slogan AS slogan_85, p1_.price_changed_at AS price_changed_at_86, p1_.data_changed_at AS data_changed_at_87, p1_.price_for_sort AS price_for_sort_88, p1_.introduction_price AS introduction_price_89, p1_.special AS special_90, p1_.purchasable AS purchasable_91, p1_.fix_priced AS fix_priced_92, p1_.created_at AS created_at_93, p1_.updated_at AS updated_at_94, p2_.id AS id_95, p2_.name AS name_96, p2_.code AS code_97, p2_.cosmetics AS cosmetics_98, p2_.taska AS taska_99, p2_.gift_set AS gift_set_100, p2_.hidden AS hidden_101, p2_.single_name AS single_name_102, p2_.plural_name AS plural_name_103, p2_.position AS position_104, p2_.`lead` AS lead_105, p2_.seo_description AS seo_description_106, p2_.title AS title_107, b3_.id AS id_108, b3_.name AS name_109, b3_.short_name AS short_name_110, b3_.slug AS slug_111, b3_.search_terms AS search_terms_112, b3_.text AS text_113, b3_.text_female AS text_female_114, b3_.text_male AS text_male_115, b3_.highlighted AS highlighted_116, b3_.main_page_fragrance AS main_page_fragrance_117, b3_.highlighted_in_search AS highlighted_in_search_118, b3_.is_on_main_page AS is_on_main_page_119, b3_.special AS special_120, b3_.special_name AS special_name_121, b3_.slogan AS slogan_122, b3_.`lead` AS lead_123, b3_.active AS active_124, b3_.exclude_from_arukereso AS exclude_from_arukereso_125, f4_.id AS id_126, f4_.name AS name_127, c5_.id AS id_128, c5_.shortening AS shortening_129, c5_.description AS description_130, c5_.full_name AS full_name_131, c5_.short_name AS short_name_132, c5_.position AS position_133, h6_.id AS id_134, h6_.uuid AS uuid_135, h6_.location AS location_136, h6_.content_type AS content_type_137, h6_.metadata AS metadata_138, h6_.filesize AS filesize_139, h6_.url AS url_140, h6_.original_filename AS original_filename_141, h6_.deleted AS deleted_142, h6_.removed_from_file_system AS removed_from_file_system_143, h6_.protected AS protected_144, h6_.created_at AS created_at_145, h6_.updated_at AS updated_at_146, h7_.id AS id_147, h7_.rel AS rel_148, h7_.internal_name AS internal_name_149, h7_.lft AS lft_150, h7_.lvl AS lvl_151, h7_.rgt AS rgt_152, h7_.deleted AS deleted_153, h7_.internal AS internal_154, h7_.created_at AS created_at_155, h7_.updated_at AS updated_at_156, h8_.id AS id_157, h8_.uuid AS uuid_158, h8_.location AS location_159, h8_.content_type AS content_type_160, h8_.metadata AS metadata_161, h8_.filesize AS filesize_162, h8_.url AS url_163, h8_.original_filename AS original_filename_164, h8_.deleted AS deleted_165, h8_.removed_from_file_system AS removed_from_file_system_166, h8_.protected AS protected_167, h8_.created_at AS created_at_168, h8_.updated_at AS updated_at_169, h9_.id AS id_170, h9_.rel AS rel_171, h9_.internal_name AS internal_name_172, h9_.lft AS lft_173, h9_.lvl AS lvl_174, h9_.rgt AS rgt_175, h9_.deleted AS deleted_176, h9_.internal AS internal_177, h9_.created_at AS created_at_178, h9_.updated_at AS updated_at_179, p0_.product_id AS product_id_180, p1_.brand_id AS brand_id_181, p1_.product_category_id AS product_category_id_182, p1_.image_id AS image_id_183, p1_.tester_image_id AS tester_image_id_184, p1_.hover_image_id AS hover_image_id_185, p1_.facebook_image_id AS facebook_image_id_186, p1_.concentration_id AS concentration_id_187, p1_.fragrance_family_id AS fragrance_family_id_188, p1_.price_changer_id AS price_changer_id_189, p1_.data_changer_id AS data_changer_id_190, b3_.image_id AS image_id_191, h6_.folder_id AS folder_id_192, h7_.parent_id AS parent_id_193, h8_.folder_id AS folder_id_194, h9_.parent_id AS parent_id_195 FROM product_packaging p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id LEFT JOIN product_category p2_ ON p1_.product_category_id = p2_.id INNER JOIN brand b3_ ON p1_.brand_id = b3_.id LEFT JOIN fragrance_family f4_ ON p1_.fragrance_family_id = f4_.id LEFT JOIN concentration c5_ ON p1_.concentration_id = c5_.id LEFT JOIN hg_media_media h6_ ON p1_.image_id = h6_.id LEFT JOIN hg_media_folders h7_ ON h6_.folder_id = h7_.id LEFT JOIN hg_media_media h8_ ON p1_.hover_image_id = h8_.id LEFT JOIN hg_media_folders h9_ ON h8_.folder_id = h9_.id WHERE p1_.active = 1 AND p0_.active = 1 AND (p0_.stock_limit = 0 OR p0_.stock_limit_stock > 0) AND p0_.available = 1 AND (p1_.coming_soon IS NULL OR p1_.coming_soon <> 1) AND p1_.novelty = 1 AND ((p0_.discount = 1 AND (p0_.discount_stock > 0 OR p0_.discount_constant = 1)) OR ((p0_.discount = 0 OR p0_.discount_stock <= 0) AND p0_.position = 1)) AND p1_.gender = ? ORDER BY p1_.is_on_main_page DESC, RAND() ASC, p0_.discount_order_date DESC, CONCAT(b3_.name, ?, p1_.name) ASC LIMIT 30
Parameters:
[ "f" " " ] |
| 106 | 1.17 ms |
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:
[ 1 "App\Entity\Pages\HomePage" "home_bottom" ] |
| 107 | 0.63 ms |
SELECT t0.seo_text AS seo_text_1, t0.id AS id_2 FROM app_home_seo_page_parts t0 WHERE t0.id IN (?)
Parameters:
[
1
]
|
| 108 | 7.23 ms |
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:
[] |
| 109 | 1.42 ms |
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:
[ "top10-2022-noi" "hu" ] |
| 110 | 0.35 ms |
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
]
|
| 111 | 1.52 ms |
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:
[ "top10-2020-noi" "hu" ] |
| 112 | 0.43 ms |
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:
[
2
]
|
| 113 | 1.37 ms |
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:
[ "top10-2022-ferfi" "hu" ] |
| 114 | 0.47 ms |
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:
[
12
]
|
| 115 | 1.94 ms |
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:
[ "top10-2020-ferfi" "hu" ] |
| 116 | 0.45 ms |
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:
[
4
]
|
| 117 | 1.97 ms |
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:
[ "illattanacsadas" "hu" ] |
| 118 | 2.15 ms |
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:
[ "telefonos-rendeles" "hu" ] |
| 119 | 0.65 ms |
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:
[
26
]
|
| 120 | 3.32 ms |
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_exit = 0 OR p0_.only_exit IS NULL) ORDER BY RAND() ASC LIMIT 1
Parameters:
[ "2026-01-31 11:41:41" "2026-01-31 11:41:41" ] |
| 121 | 1.99 ms |
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:
[ "aszf" "hu" ] |
| 122 | 0.44 ms |
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:
[
14
]
|
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.