Symfony Profiler

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short_name AS short_name_3,
  t0.slug AS slug_4,
  t0.search_terms AS search_terms_5,
  t0.text AS text_6,
  t0.text_female AS text_female_7,
  t0.text_male AS text_male_8,
  t0.highlighted AS highlighted_9,
  t0.main_page_fragrance AS main_page_fragrance_10,
  t0.highlighted_in_search AS highlighted_in_search_11,
  t0.is_on_main_page AS is_on_main_page_12,
  t0.special AS special_13,
  t0.special_name AS special_name_14,
  t0.slogan AS slogan_15,
  t0.`lead` AS lead_16,
  t0.active AS active_17,
  t0.exclude_from_arukereso AS exclude_from_arukereso_18,
  t0.image_id AS image_id_19
FROM
  brand t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.slug AS slug_4, t0.search_terms AS search_terms_5, t0.text AS text_6, t0.text_female AS text_female_7, t0.text_male AS text_male_8, t0.highlighted AS highlighted_9, t0.main_page_fragrance AS main_page_fragrance_10, t0.highlighted_in_search AS highlighted_in_search_11, t0.is_on_main_page AS is_on_main_page_12, t0.special AS special_13, t0.special_name AS special_name_14, t0.slogan AS slogan_15, t0.`lead` AS lead_16, t0.active AS active_17, t0.exclude_from_arukereso AS exclude_from_arukereso_18, t0.image_id AS image_id_19 FROM brand t0 WHERE t0.slug = 'carolina-herrera' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.article_number AS article_number_2,
  t0.name AS name_3,
  t0.search_terms AS search_terms_4,
  t0.year AS year_5,
  t0.gender AS gender_6,
  t0.coming_soon AS coming_soon_7,
  t0.novelty AS novelty_8,
  t0.discount AS discount_9,
  t0.unavailable_soon AS unavailable_soon_10,
  t0.niche AS niche_11,
  t0.exclusive AS exclusive_12,
  t0.limited_edition AS limited_edition_13,
  t0.outlet AS outlet_14,
  t0.rarity AS rarity_15,
  t0.available_again AS available_again_16,
  t0.limited AS limited_17,
  t0.active AS active_18,
  t0.info_link AS info_link_19,
  t0.description AS description_20,
  t0.fragrance_description AS fragrance_description_21,
  t0.meta_description AS meta_description_22,
  t0.meta_keywords AS meta_keywords_23,
  t0.facebook_description AS facebook_description_24,
  t0.minimum_price AS minimum_price_25,
  t0.discounted_minimum_price AS discounted_minimum_price_26,
  t0.url AS url_27,
  t0.sold AS sold_28,
  t0.just_arrived AS just_arrived_29,
  t0.is_on_main_page AS is_on_main_page_30,
  t0.discount_order_date AS discount_order_date_31,
  t0.novelty_order_date AS novelty_order_date_32,
  t0.unavailable_soon_order_date AS unavailable_soon_order_date_33,
  t0.move_first_order_date AS move_first_order_date_34,
  t0.slogan AS slogan_35,
  t0.price_changed_at AS price_changed_at_36,
  t0.data_changed_at AS data_changed_at_37,
  t0.price_for_sort AS price_for_sort_38,
  t0.introduction_price AS introduction_price_39,
  t0.special AS special_40,
  t0.purchasable AS purchasable_41,
  t0.fix_priced AS fix_priced_42,
  t0.created_at AS created_at_43,
  t0.updated_at AS updated_at_44,
  t0.brand_id AS brand_id_45,
  t0.product_category_id AS product_category_id_46,
  t0.image_id AS image_id_47,
  t0.tester_image_id AS tester_image_id_48,
  t0.hover_image_id AS hover_image_id_49,
  t0.facebook_image_id AS facebook_image_id_50,
  t0.concentration_id AS concentration_id_51,
  t0.fragrance_family_id AS fragrance_family_id_52,
  t0.price_changer_id AS price_changer_id_53,
  t0.data_changer_id AS data_changer_id_54
FROM
  product t0
WHERE
  t0.brand_id = ?

SELECT t0.id AS id_1, t0.article_number AS article_number_2, t0.name AS name_3, t0.search_terms AS search_terms_4, t0.year AS year_5, t0.gender AS gender_6, t0.coming_soon AS coming_soon_7, t0.novelty AS novelty_8, t0.discount AS discount_9, t0.unavailable_soon AS unavailable_soon_10, t0.niche AS niche_11, t0.exclusive AS exclusive_12, t0.limited_edition AS limited_edition_13, t0.outlet AS outlet_14, t0.rarity AS rarity_15, t0.available_again AS available_again_16, t0.limited AS limited_17, t0.active AS active_18, t0.info_link AS info_link_19, t0.description AS description_20, t0.fragrance_description AS fragrance_description_21, t0.meta_description AS meta_description_22, t0.meta_keywords AS meta_keywords_23, t0.facebook_description AS facebook_description_24, t0.minimum_price AS minimum_price_25, t0.discounted_minimum_price AS discounted_minimum_price_26, t0.url AS url_27, t0.sold AS sold_28, t0.just_arrived AS just_arrived_29, t0.is_on_main_page AS is_on_main_page_30, t0.discount_order_date AS discount_order_date_31, t0.novelty_order_date AS novelty_order_date_32, t0.unavailable_soon_order_date AS unavailable_soon_order_date_33, t0.move_first_order_date AS move_first_order_date_34, t0.slogan AS slogan_35, t0.price_changed_at AS price_changed_at_36, t0.data_changed_at AS data_changed_at_37, t0.price_for_sort AS price_for_sort_38, t0.introduction_price AS introduction_price_39, t0.special AS special_40, t0.purchasable AS purchasable_41, t0.fix_priced AS fix_priced_42, t0.created_at AS created_at_43, t0.updated_at AS updated_at_44, t0.brand_id AS brand_id_45, t0.product_category_id AS product_category_id_46, t0.image_id AS image_id_47, t0.tester_image_id AS tester_image_id_48, t0.hover_image_id AS hover_image_id_49, t0.facebook_image_id AS facebook_image_id_50, t0.concentration_id AS concentration_id_51, t0.fragrance_family_id AS fragrance_family_id_52, t0.price_changer_id AS price_changer_id_53, t0.data_changer_id AS data_changer_id_54 FROM product t0 WHERE t0.brand_id = 15;

SELECT
  t0.id AS id_1,
  t0.shortening AS shortening_2,
  t0.description AS description_3,
  t0.full_name AS full_name_4,
  t0.short_name AS short_name_5,
  t0.position AS position_6
FROM
  concentration t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.shortening AS shortening_2, t0.description AS description_3, t0.full_name AS full_name_4, t0.short_name AS short_name_5, t0.position AS position_6 FROM concentration t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.shortening AS shortening_2,
  t0.description AS description_3,
  t0.full_name AS full_name_4,
  t0.short_name AS short_name_5,
  t0.position AS position_6
FROM
  concentration t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.shortening AS shortening_2, t0.description AS description_3, t0.full_name AS full_name_4, t0.short_name AS short_name_5, t0.position AS position_6 FROM concentration t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.shortening AS shortening_2,
  t0.description AS description_3,
  t0.full_name AS full_name_4,
  t0.short_name AS short_name_5,
  t0.position AS position_6
FROM
  concentration t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.shortening AS shortening_2, t0.description AS description_3, t0.full_name AS full_name_4, t0.short_name AS short_name_5, t0.position AS position_6 FROM concentration t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.shortening AS shortening_2,
  t0.description AS description_3,
  t0.full_name AS full_name_4,
  t0.short_name AS short_name_5,
  t0.position AS position_6
FROM
  concentration t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.shortening AS shortening_2, t0.description AS description_3, t0.full_name AS full_name_4, t0.short_name AS short_name_5, t0.position AS position_6 FROM concentration t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.price AS price_3,
  t0.price_in_euros AS price_in_euros_4,
  t0.article_number AS article_number_5,
  t0.total_ml AS total_ml_6,
  t0.tester AS tester_7,
  t0.cellofan AS cellofan_8,
  t0.unboxed AS unboxed_9,
  t0.hit AS hit_10,
  t0.fragrance_sample AS fragrance_sample_11,
  t0.is_on_main_page AS is_on_main_page_12,
  t0.limited AS limited_13,
  t0.reloaded AS reloaded_14,
  t0.discount_hidden AS discount_hidden_15,
  t0.discount_order_date AS discount_order_date_16,
  t0.limit_order_date AS limit_order_date_17,
  t0.novelty_order_date AS novelty_order_date_18,
  t0.unavailable_soon_order_date AS unavailable_soon_order_date_19,
  t0.move_first_order_date AS move_first_order_date_20,
  t0.extra_discount AS extra_discount_21,
  t0.stock AS stock_22,
  t0.active AS active_23,
  t0.available AS available_24,
  t0.send_to_emag AS send_to_emag_25,
  t0.emag_visible AS emag_visible_26,
  t0.bb_visible AS bb_visible_27,
  t0.sent_to_tharanis AS sent_to_tharanis_28,
  t0.available_totally AS available_totally_29,
  t0.ean AS ean_30,
  t0.position AS position_31,
  t0.discount AS discount_32,
  t0.discount_price AS discount_price_33,
  t0.discount_price_in_euros AS discount_price_in_euros_34,
  t0.discount_stock AS discount_stock_35,
  t0.discount_constant AS discount_constant_36,
  t0.stock_limit AS stock_limit_37,
  t0.stock_limit_type AS stock_limit_type_38,
  t0.stock_limit_stock AS stock_limit_stock_39,
  t0.outlet AS outlet_40,
  t0.sold AS sold_41,
  t0.fix_priced AS fix_priced_42,
  t0.discount_note AS discount_note_43,
  t0.stock_limit_note AS stock_limit_note_44,
  t0.arukereso_marketplace_disabled AS arukereso_marketplace_disabled_45,
  t0.mini_perfume AS mini_perfume_46,
  t0.minimum_priced AS minimum_priced_47,
  t0.arukereso_appearance AS arukereso_appearance_48,
  t0.pepita_appearance AS pepita_appearance_49,
  t0.refiller AS refiller_50,
  t0.best_price AS best_price_51,
  t0.product_id AS product_id_52
FROM
  product_packaging t0
WHERE
  t0.product_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_in_euros AS price_in_euros_4, t0.article_number AS article_number_5, t0.total_ml AS total_ml_6, t0.tester AS tester_7, t0.cellofan AS cellofan_8, t0.unboxed AS unboxed_9, t0.hit AS hit_10, t0.fragrance_sample AS fragrance_sample_11, t0.is_on_main_page AS is_on_main_page_12, t0.limited AS limited_13, t0.reloaded AS reloaded_14, t0.discount_hidden AS discount_hidden_15, t0.discount_order_date AS discount_order_date_16, t0.limit_order_date AS limit_order_date_17, t0.novelty_order_date AS novelty_order_date_18, t0.unavailable_soon_order_date AS unavailable_soon_order_date_19, t0.move_first_order_date AS move_first_order_date_20, t0.extra_discount AS extra_discount_21, t0.stock AS stock_22, t0.active AS active_23, t0.available AS available_24, t0.send_to_emag AS send_to_emag_25, t0.emag_visible AS emag_visible_26, t0.bb_visible AS bb_visible_27, t0.sent_to_tharanis AS sent_to_tharanis_28, t0.available_totally AS available_totally_29, t0.ean AS ean_30, t0.position AS position_31, t0.discount AS discount_32, t0.discount_price AS discount_price_33, t0.discount_price_in_euros AS discount_price_in_euros_34, t0.discount_stock AS discount_stock_35, t0.discount_constant AS discount_constant_36, t0.stock_limit AS stock_limit_37, t0.stock_limit_type AS stock_limit_type_38, t0.stock_limit_stock AS stock_limit_stock_39, t0.outlet AS outlet_40, t0.sold AS sold_41, t0.fix_priced AS fix_priced_42, t0.discount_note AS discount_note_43, t0.stock_limit_note AS stock_limit_note_44, t0.arukereso_marketplace_disabled AS arukereso_marketplace_disabled_45, t0.mini_perfume AS mini_perfume_46, t0.minimum_priced AS minimum_priced_47, t0.arukereso_appearance AS arukereso_appearance_48, t0.pepita_appearance AS pepita_appearance_49, t0.refiller AS refiller_50, t0.best_price AS best_price_51, t0.product_id AS product_id_52 FROM product_packaging t0 WHERE t0.product_id = 49615 ORDER BY t0.position ASC;

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

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;

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 = ?

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 = 45680;

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 = ?

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 = 45681;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.product_id AS product_id_3,
  t0.image_id AS image_id_4
FROM
  product_extra_image t0
WHERE
  t0.product_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.image_id AS image_id_4 FROM product_extra_image t0 WHERE t0.product_id = 49615 ORDER BY t0.position ASC;

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 = ?

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 = 45682;

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 = ?

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 = 45683;

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

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 = 'homepage' AND h1_.lang = 'hu' AND h1_.online = 1 ORDER BY h1_.weight ASC, h1_.title ASC;

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 = ?

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 = 1;

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 >= ?
  )

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 = 'vegtelen1' AND (p0_.start_time IS NULL OR p0_.start_time <= '2026-01-31 14:06:09') AND (p0_.end_time IS NULL OR p0_.end_time >= '2026-01-31 14:06:09');

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

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 = 'visszavasarlasi-garancia' AND h1_.lang = 'hu' AND h1_.online = 1 ORDER BY h1_.weight ASC, h1_.title ASC;

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 = ?

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 = 29;