Symfony Profiler

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
  h0_.id AS id_0,
  h0_.lft AS lft_1,
  h0_.lvl AS lvl_2,
  h0_.rgt AS rgt_3,
  h0_.deleted AS deleted_4,
  h0_.hidden_from_nav AS hidden_from_nav_5,
  h0_.ref_entity_name AS ref_entity_name_6,
  h0_.internal_name AS internal_name_7,
  h1_.id AS id_8,
  h1_.lang AS lang_9,
  h1_.online AS online_10,
  h1_.title AS title_11,
  h1_.slug AS slug_12,
  h1_.url AS url_13,
  h1_.weight AS weight_14,
  h1_.created AS created_15,
  h1_.updated AS updated_16,
  h2_.id AS id_17,
  h2_.type AS type_18,
  h2_.owner AS owner_19,
  h2_.created AS created_20,
  h2_.updated AS updated_21,
  h2_.ref_id AS ref_id_22,
  h2_.ref_entity_name AS ref_entity_name_23,
  h0_.parent_id AS parent_id_24,
  h1_.node_id AS node_id_25,
  h1_.public_node_version_id AS public_node_version_id_26,
  h2_.node_translation_id AS node_translation_id_27,
  h2_.origin_id AS origin_id_28
FROM
  hg_node_nodes h0_
  LEFT JOIN hg_node_node_translations h1_ ON h0_.id = h1_.node_id
  AND (h1_.lang = ?)
  LEFT JOIN hg_node_node_versions h2_ ON h1_.public_node_version_id = h2_.id
  AND (
    h1_.public_node_version_id = h2_.id
  )
  JOIN (
    SELECT
      DISTINCT o.object_identifier AS id
    FROM
      parfumhu.acl_object_identities AS o
      INNER JOIN parfumhu.acl_classes c ON c.id = o.class_id
      LEFT JOIN parfumhu.acl_entries e ON (
        e.class_id = o.class_id
        AND (
          e.object_identity_id = o.id
          OR e.object_identity_id IS NULL
        )
      )
      LEFT JOIN parfumhu.acl_security_identities s ON (s.id = e.security_identity_id)
    WHERE
      c.class_type = "Hgabka\\NodeBundle\\Entity\\Node"
      AND (
        s.identifier = "IS_AUTHENTICATED_ANONYMOUSLY"
      )
      AND e.mask & 1 > 0
  ) ta_ ON h0_.id = ta_.id
WHERE
  h0_.deleted = 0
  AND (
    (
      h0_.hidden_from_nav <> 1
      OR h0_.internal_name IS NOT NULL
    )
  )
ORDER BY
  h1_.weight ASC,
  h1_.title ASC

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 = 'hu') LEFT JOIN hg_node_node_versions h2_ ON h1_.public_node_version_id = h2_.id AND (h1_.public_node_version_id = h2_.id) JOIN (SELECT DISTINCT o.object_identifier AS id FROM parfumhu.acl_object_identities AS o
INNER JOIN parfumhu.acl_classes c ON c.id = o.class_id
LEFT JOIN parfumhu.acl_entries e ON (
    e.class_id = o.class_id AND (e.object_identity_id = o.id
    OR e.object_identity_id IS NULL)
)
LEFT JOIN parfumhu.acl_security_identities s ON (
s.id = e.security_identity_id
)
WHERE c.class_type = "Hgabka\\NodeBundle\\Entity\\Node"
AND (s.identifier = "IS_AUTHENTICATED_ANONYMOUSLY")
AND e.mask & 1 > 0) ta_ ON h0_.id = ta_.id WHERE h0_.deleted = 0 AND ((h0_.hidden_from_nav <> 1 OR h0_.internal_name IS NOT NULL)) ORDER BY h1_.weight ASC, h1_.title ASC;

SELECT
  h0_.id AS id_0,
  h0_.lft AS lft_1,
  h0_.lvl AS lvl_2,
  h0_.rgt AS rgt_3,
  h0_.deleted AS deleted_4,
  h0_.hidden_from_nav AS hidden_from_nav_5,
  h0_.ref_entity_name AS ref_entity_name_6,
  h0_.internal_name AS internal_name_7,
  h1_.id AS id_8,
  h1_.lang AS lang_9,
  h1_.online AS online_10,
  h1_.title AS title_11,
  h1_.slug AS slug_12,
  h1_.url AS url_13,
  h1_.weight AS weight_14,
  h1_.created AS created_15,
  h1_.updated AS updated_16,
  h2_.id AS id_17,
  h2_.type AS type_18,
  h2_.owner AS owner_19,
  h2_.created AS created_20,
  h2_.updated AS updated_21,
  h2_.ref_id AS ref_id_22,
  h2_.ref_entity_name AS ref_entity_name_23,
  h0_.parent_id AS parent_id_24,
  h1_.node_id AS node_id_25,
  h1_.public_node_version_id AS public_node_version_id_26,
  h2_.node_translation_id AS node_translation_id_27,
  h2_.origin_id AS origin_id_28
FROM
  hg_node_nodes h0_
  INNER JOIN hg_node_node_translations h1_ ON h0_.id = h1_.node_id
  LEFT JOIN hg_node_node_versions h2_ ON h1_.public_node_version_id = h2_.id
  AND (
    h1_.public_node_version_id = h2_.id
  )
WHERE
  h0_.deleted = 0
  AND (
    h0_.lft <= 628
    AND h0_.rgt >= 629
  )
ORDER BY
  h0_.lft 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_.lft <= 628 AND h0_.rgt >= 629) ORDER BY h0_.lft ASC;

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

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;

SELECT
  a0_.highlighted AS highlighted_0,
  a0_.short_title AS short_title_1,
  a0_.`lead` AS lead_2,
  a0_.published_at AS published_at_3,
  a0_.`author` AS author_4,
  a0_.id AS id_5,
  a0_.title AS title_6,
  a0_.page_title AS page_title_7,
  a0_.image_id AS image_id_8,
  a0_.thumb_id AS thumb_id_9,
  a0_.home_thumb_id AS home_thumb_id_10
FROM
  app_blog_entry_pages a0_
  INNER JOIN hg_node_node_versions h1_ ON (
    h1_.ref_id = ?
    AND h1_.ref_entity_name = ?
    AND h1_.type = ?
  )
  INNER JOIN hg_node_node_translations h2_ ON h1_.node_translation_id = h2_.id
  INNER JOIN hg_node_nodes h3_ ON h2_.node_id = h3_.id
WHERE
  a0_.published_at < ?
  AND h3_.parent_id = ?
  AND h2_.online = 1
ORDER BY
  a0_.published_at DESC
LIMIT
  1

SELECT a0_.highlighted AS highlighted_0, a0_.short_title AS short_title_1, a0_.`lead` AS lead_2, a0_.published_at AS published_at_3, a0_.`author` AS author_4, a0_.id AS id_5, a0_.title AS title_6, a0_.page_title AS page_title_7, a0_.image_id AS image_id_8, a0_.thumb_id AS thumb_id_9, a0_.home_thumb_id AS home_thumb_id_10 FROM app_blog_entry_pages a0_ INNER JOIN hg_node_node_versions h1_ ON (h1_.ref_id = 748 AND h1_.ref_entity_name = 'App\\Entity\\Pages\\BlogEntryPage' AND h1_.type = 'public') INNER JOIN hg_node_node_translations h2_ ON h1_.node_translation_id = h2_.id INNER JOIN hg_node_nodes h3_ ON h2_.node_id = h3_.id WHERE a0_.published_at < '2024-08-13 00:00:00' AND h3_.parent_id = 4 AND h2_.online = 1 ORDER BY a0_.published_at DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.owner AS owner_3,
  t0.created AS created_4,
  t0.updated AS updated_5,
  t0.ref_id AS ref_id_6,
  t0.ref_entity_name AS ref_entity_name_7,
  t0.node_translation_id AS node_translation_id_8,
  t0.origin_id AS origin_id_9
FROM
  hg_node_node_versions t0
WHERE
  t0.ref_id = ?
  AND t0.ref_entity_name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.owner AS owner_3, t0.created AS created_4, t0.updated AS updated_5, t0.ref_id AS ref_id_6, t0.ref_entity_name AS ref_entity_name_7, t0.node_translation_id AS node_translation_id_8, t0.origin_id AS origin_id_9 FROM hg_node_node_versions t0 WHERE t0.ref_id = 748 AND t0.ref_entity_name = 'App\\Entity\\Pages\\BlogEntryPage' LIMIT 1;

SELECT
  a0_.highlighted AS highlighted_0,
  a0_.short_title AS short_title_1,
  a0_.`lead` AS lead_2,
  a0_.published_at AS published_at_3,
  a0_.`author` AS author_4,
  a0_.id AS id_5,
  a0_.title AS title_6,
  a0_.page_title AS page_title_7,
  a0_.image_id AS image_id_8,
  a0_.thumb_id AS thumb_id_9,
  a0_.home_thumb_id AS home_thumb_id_10
FROM
  app_blog_entry_pages a0_
  INNER JOIN hg_node_node_versions h1_ ON (
    h1_.ref_id = ?
    AND h1_.ref_entity_name = ?
    AND h1_.type = ?
  )
  INNER JOIN hg_node_node_translations h2_ ON h1_.node_translation_id = h2_.id
  INNER JOIN hg_node_nodes h3_ ON h2_.node_id = h3_.id
WHERE
  a0_.published_at > ?
  AND h3_.parent_id = ?
  AND h2_.online = 1
ORDER BY
  a0_.published_at ASC
LIMIT
  1

SELECT a0_.highlighted AS highlighted_0, a0_.short_title AS short_title_1, a0_.`lead` AS lead_2, a0_.published_at AS published_at_3, a0_.`author` AS author_4, a0_.id AS id_5, a0_.title AS title_6, a0_.page_title AS page_title_7, a0_.image_id AS image_id_8, a0_.thumb_id AS thumb_id_9, a0_.home_thumb_id AS home_thumb_id_10 FROM app_blog_entry_pages a0_ INNER JOIN hg_node_node_versions h1_ ON (h1_.ref_id = 748 AND h1_.ref_entity_name = 'App\\Entity\\Pages\\BlogEntryPage' AND h1_.type = 'public') INNER JOIN hg_node_node_translations h2_ ON h1_.node_translation_id = h2_.id INNER JOIN hg_node_nodes h3_ ON h2_.node_id = h3_.id WHERE a0_.published_at > '2024-08-13 00:00:00' AND h3_.parent_id = 4 AND h2_.online = 1 ORDER BY a0_.published_at ASC 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 = 56153;

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

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

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

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.display_from AS display_from_2,
  p0_.display_to AS display_to_3,
  p0_.link AS link_4,
  p0_.only_homepage AS only_homepage_5,
  p0_.new_window AS new_window_6,
  p0_.mobile AS mobile_7,
  p0_.only_exit AS only_exit_8,
  p0_.created_at AS created_at_9,
  p0_.updated_at AS updated_at_10,
  h1_.id AS id_11,
  h1_.uuid AS uuid_12,
  h1_.location AS location_13,
  h1_.content_type AS content_type_14,
  h1_.metadata AS metadata_15,
  h1_.filesize AS filesize_16,
  h1_.url AS url_17,
  h1_.original_filename AS original_filename_18,
  h1_.deleted AS deleted_19,
  h1_.removed_from_file_system AS removed_from_file_system_20,
  h1_.protected AS protected_21,
  h1_.created_at AS created_at_22,
  h1_.updated_at AS updated_at_23,
  p0_.image_id AS image_id_24,
  h1_.folder_id AS folder_id_25
FROM
  popup p0_
  LEFT JOIN hg_media_media h1_ ON p0_.image_id = h1_.id
WHERE
  (
    p0_.display_from IS NULL
    OR p0_.display_from <= ?
  )
  AND (
    p0_.display_to IS NULL
    OR p0_.display_to >= ?
  )
  AND p0_.only_homepage = 0
  AND (
    p0_.only_exit = 0
    OR p0_.only_exit IS NULL
  )
ORDER BY
  RAND() ASC
LIMIT
  1

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 <= '2026-01-31 14:10:49') AND (p0_.display_to IS NULL OR p0_.display_to >= '2026-01-31 14:10:49') AND p0_.only_homepage = 0 AND (p0_.only_exit = 0 OR p0_.only_exit IS NULL) ORDER BY RAND() ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.page_id AS page_id_2,
  t0.page_entityname AS page_entityname_3,
  t0.context AS context_4,
  t0.sequencenumber AS sequencenumber_5,
  t0.page_part_id AS page_part_id_6,
  t0.page_part_entityname AS page_part_entityname_7,
  t0.created AS created_8,
  t0.updated AS updated_9
FROM
  hg_page_part_page_part_refs t0
WHERE
  t0.page_id = ?
  AND t0.page_entityname = ?
  AND t0.context = ?
ORDER BY
  t0.sequencenumber ASC

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 = 748 AND t0.page_entityname = 'App\\Entity\\Pages\\BlogEntryPage' AND t0.context = 'blog_entry' ORDER BY t0.sequencenumber 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;

SELECT
  t0.content AS content_1,
  t0.id AS id_2
FROM
  hg_page_part_text_page_parts t0
WHERE
  t0.id IN (?)

SELECT t0.content AS content_1, t0.id AS id_2 FROM hg_page_part_text_page_parts t0 WHERE t0.id IN (964);

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

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 = 748 AND t0.ref_entity_name = 'App\\Entity\\Pages\\BlogEntryPage' LIMIT 1;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  h0_.id AS id_0,
  h0_.lang AS lang_1,
  h0_.online AS online_2,
  h0_.title AS title_3,
  h0_.slug AS slug_4,
  h0_.url AS url_5,
  h0_.weight AS weight_6,
  h0_.created AS created_7,
  h0_.updated AS updated_8,
  h1_.id AS id_9,
  h1_.type AS type_10,
  h1_.owner AS owner_11,
  h1_.created AS created_12,
  h1_.updated AS updated_13,
  h1_.ref_id AS ref_id_14,
  h1_.ref_entity_name AS ref_entity_name_15,
  h0_.node_id AS node_id_16,
  h0_.public_node_version_id AS public_node_version_id_17,
  h1_.node_translation_id AS node_translation_id_18,
  h1_.origin_id AS origin_id_19
FROM
  hg_node_node_translations h0_
  INNER JOIN hg_node_nodes h2_ ON h0_.node_id = h2_.id
  AND (h0_.node_id = h2_.id)
  LEFT JOIN hg_node_node_versions h1_ ON h0_.public_node_version_id = h1_.id
  AND (
    h0_.public_node_version_id = h1_.id
  )
WHERE
  h2_.deleted = 0
  AND h0_.lang = ?
  AND h0_.url = ?
ORDER BY
  h0_.online DESC

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 = 'hu' AND h0_.url = 'blog/illatfigyelo/giorgio-armani-acqua-di-gio-parfum-az-idotlen-elegancia-es-frissesseg-illata' ORDER BY h0_.online DESC;