Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.order_local AS order_local_4,
  t0.order_global AS order_global_5,
  t0.new_window AS new_window_6,
  t0.hidden AS hidden_7,
  t0.locked AS locked_8,
  t0.published AS published_9,
  t0.nesting_level AS nesting_level_10,
  t0.path AS path_11,
  t0.parent_slug AS parent_slug_12,
  t0.homepage AS homepage_13,
  t0.noindex AS noindex_14,
  t0.redirect_type AS redirect_type_15,
  t0.redirect_external AS redirect_external_16,
  t0.nav_text AS nav_text_17,
  t0.dynamic AS dynamic_18,
  t0.sitemap AS sitemap_19,
  t0.dropdown_text AS dropdown_text_20,
  t0.locked_user_types AS locked_user_types_21,
  t0.dropdown_only AS dropdown_only_22,
  t0.created_at AS created_at_23,
  t0.created_by AS created_by_24,
  t0.updated_at AS updated_at_25,
  t0.updated_by AS updated_by_26,
  t0.parent_id AS parent_id_27,
  t0.canonical_id AS canonical_id_28,
  t0.meta_id AS meta_id_29,
  t0.redirect_internal_id AS redirect_internal_id_30
FROM
  page t0
WHERE
  t0.path = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.order_local AS order_local_4, t0.order_global AS order_global_5, t0.new_window AS new_window_6, t0.hidden AS hidden_7, t0.locked AS locked_8, t0.published AS published_9, t0.nesting_level AS nesting_level_10, t0.path AS path_11, t0.parent_slug AS parent_slug_12, t0.homepage AS homepage_13, t0.noindex AS noindex_14, t0.redirect_type AS redirect_type_15, t0.redirect_external AS redirect_external_16, t0.nav_text AS nav_text_17, t0.dynamic AS dynamic_18, t0.sitemap AS sitemap_19, t0.dropdown_text AS dropdown_text_20, t0.locked_user_types AS locked_user_types_21, t0.dropdown_only AS dropdown_only_22, t0.created_at AS created_at_23, t0.created_by AS created_by_24, t0.updated_at AS updated_at_25, t0.updated_by AS updated_by_26, t0.parent_id AS parent_id_27, t0.canonical_id AS canonical_id_28, t0.meta_id AS meta_id_29, t0.redirect_internal_id AS redirect_internal_id_30 FROM page t0 WHERE t0.path = 'parent/child' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.published AS published_2,
  t0.template AS template_3,
  t0.created_at AS created_at_4,
  t0.created_by AS created_by_5,
  t0.updated_at AS updated_at_6,
  t0.updated_by AS updated_by_7,
  t0.page_id AS page_id_8
FROM
  page_revision t0
WHERE
  t0.page_id = ?
ORDER BY
  t0.updated_at DESC

SELECT t0.id AS id_1, t0.published AS published_2, t0.template AS template_3, t0.created_at AS created_at_4, t0.created_by AS created_by_5, t0.updated_at AS updated_at_6, t0.updated_by AS updated_by_7, t0.page_id AS page_id_8 FROM page_revision t0 WHERE t0.page_id = 7 ORDER BY t0.updated_at DESC;

SELECT
  t0.id AS id_1,
  t0.value AS value_2
FROM
  setting t0

SELECT t0.id AS id_1, t0.value AS value_2 FROM setting t0;

SELECT
  t0.id AS id_1,
  t0.value AS value_2
FROM
  setting t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.value AS value_2 FROM setting t0 WHERE t0.id = 'oh_media_script_head_open';

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.append_base_title AS append_base_title_4,
  t0.image_id AS image_id_5
FROM
  meta t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.append_base_title AS append_base_title_4, t0.image_id AS image_id_5 FROM meta t0 WHERE t0.id = 7;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.order_local AS order_local_4,
  t0.order_global AS order_global_5,
  t0.new_window AS new_window_6,
  t0.hidden AS hidden_7,
  t0.locked AS locked_8,
  t0.published AS published_9,
  t0.nesting_level AS nesting_level_10,
  t0.path AS path_11,
  t0.parent_slug AS parent_slug_12,
  t0.homepage AS homepage_13,
  t0.noindex AS noindex_14,
  t0.redirect_type AS redirect_type_15,
  t0.redirect_external AS redirect_external_16,
  t0.nav_text AS nav_text_17,
  t0.dynamic AS dynamic_18,
  t0.sitemap AS sitemap_19,
  t0.dropdown_text AS dropdown_text_20,
  t0.locked_user_types AS locked_user_types_21,
  t0.dropdown_only AS dropdown_only_22,
  t0.created_at AS created_at_23,
  t0.created_by AS created_by_24,
  t0.updated_at AS updated_at_25,
  t0.updated_by AS updated_by_26,
  t0.parent_id AS parent_id_27,
  t0.canonical_id AS canonical_id_28,
  t0.meta_id AS meta_id_29,
  t0.redirect_internal_id AS redirect_internal_id_30
FROM
  page t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.order_local AS order_local_4, t0.order_global AS order_global_5, t0.new_window AS new_window_6, t0.hidden AS hidden_7, t0.locked AS locked_8, t0.published AS published_9, t0.nesting_level AS nesting_level_10, t0.path AS path_11, t0.parent_slug AS parent_slug_12, t0.homepage AS homepage_13, t0.noindex AS noindex_14, t0.redirect_type AS redirect_type_15, t0.redirect_external AS redirect_external_16, t0.nav_text AS nav_text_17, t0.dynamic AS dynamic_18, t0.sitemap AS sitemap_19, t0.dropdown_text AS dropdown_text_20, t0.locked_user_types AS locked_user_types_21, t0.dropdown_only AS dropdown_only_22, t0.created_at AS created_at_23, t0.created_by AS created_by_24, t0.updated_at AS updated_at_25, t0.updated_by AS updated_by_26, t0.parent_id AS parent_id_27, t0.canonical_id AS canonical_id_28, t0.meta_id AS meta_id_29, t0.redirect_internal_id AS redirect_internal_id_30 FROM page t0 WHERE t0.id = 6;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.append_base_title AS append_base_title_4,
  t0.image_id AS image_id_5
FROM
  meta t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.append_base_title AS append_base_title_4, t0.image_id AS image_id_5 FROM meta t0 WHERE t0.id = 6;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.order_local AS order_local_3,
  p0_.order_global AS order_global_4,
  p0_.new_window AS new_window_5,
  p0_.hidden AS hidden_6,
  p0_.locked AS locked_7,
  p0_.published AS published_8,
  p0_.nesting_level AS nesting_level_9,
  p0_.path AS path_10,
  p0_.parent_slug AS parent_slug_11,
  p0_.homepage AS homepage_12,
  p0_.noindex AS noindex_13,
  p0_.redirect_type AS redirect_type_14,
  p0_.redirect_external AS redirect_external_15,
  p0_.nav_text AS nav_text_16,
  p0_.dynamic AS dynamic_17,
  p0_.sitemap AS sitemap_18,
  p0_.dropdown_text AS dropdown_text_19,
  p0_.locked_user_types AS locked_user_types_20,
  p0_.dropdown_only AS dropdown_only_21,
  p0_.created_at AS created_at_22,
  p0_.created_by AS created_by_23,
  p0_.updated_at AS updated_at_24,
  p0_.updated_by AS updated_by_25,
  p0_.parent_id AS parent_id_26,
  p0_.canonical_id AS canonical_id_27,
  p0_.meta_id AS meta_id_28,
  p0_.redirect_internal_id AS redirect_internal_id_29
FROM
  page p0_
WHERE
  p0_.homepage = 1
LIMIT
  1

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.order_local AS order_local_3, p0_.order_global AS order_global_4, p0_.new_window AS new_window_5, p0_.hidden AS hidden_6, p0_.locked AS locked_7, p0_.published AS published_8, p0_.nesting_level AS nesting_level_9, p0_.path AS path_10, p0_.parent_slug AS parent_slug_11, p0_.homepage AS homepage_12, p0_.noindex AS noindex_13, p0_.redirect_type AS redirect_type_14, p0_.redirect_external AS redirect_external_15, p0_.nav_text AS nav_text_16, p0_.dynamic AS dynamic_17, p0_.sitemap AS sitemap_18, p0_.dropdown_text AS dropdown_text_19, p0_.locked_user_types AS locked_user_types_20, p0_.dropdown_only AS dropdown_only_21, p0_.created_at AS created_at_22, p0_.created_by AS created_by_23, p0_.updated_at AS updated_at_24, p0_.updated_by AS updated_by_25, p0_.parent_id AS parent_id_26, p0_.canonical_id AS canonical_id_27, p0_.meta_id AS meta_id_28, p0_.redirect_internal_id AS redirect_internal_id_29 FROM page p0_ WHERE p0_.homepage = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.token AS token_2,
  t0.name AS name_3,
  t0.ext AS ext_4,
  t0.path AS path_5,
  t0.browser AS browser_6,
  t0.locked AS locked_7,
  t0.mime_type AS mime_type_8,
  t0.size AS size_9,
  t0.width AS width_10,
  t0.height AS height_11,
  t0.alt AS alt_12,
  t0.image AS image_13,
  t0.created_at AS created_at_14,
  t0.created_by AS created_by_15,
  t0.updated_at AS updated_at_16,
  t0.updated_by AS updated_by_17,
  t0.folder_id AS folder_id_18,
  t0.resize_parent_id AS resize_parent_id_19
FROM
  file t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.token AS token_2, t0.name AS name_3, t0.ext AS ext_4, t0.path AS path_5, t0.browser AS browser_6, t0.locked AS locked_7, t0.mime_type AS mime_type_8, t0.size AS size_9, t0.width AS width_10, t0.height AS height_11, t0.alt AS alt_12, t0.image AS image_13, t0.created_at AS created_at_14, t0.created_by AS created_by_15, t0.updated_at AS updated_at_16, t0.updated_by AS updated_by_17, t0.folder_id AS folder_id_18, t0.resize_parent_id AS resize_parent_id_19 FROM file t0 WHERE t0.id = '27';

SELECT
  p.path
FROM
  `page_revision` pr
  JOIN `page` p on p.id = pr.page_id
WHERE
  p.published IS NOT NULL
  AND p.published < UTC_TIMESTAMP()
  AND p.dynamic = 1
  AND (
    p.homepage IS NULL
    OR p.homepage = 0
  )
  AND (
    SELECT
      pr_sub.id
    FROM
      `page_revision` pr_sub
    WHERE
      pr_sub.page_id = p.id
      AND pr_sub.published = 1
    ORDER BY
      pr_sub.updated_at DESC
    LIMIT
      1
  ) = pr.id
  AND pr.template = ?

SELECT p.path
            FROM `page_revision` pr
            JOIN `page` p on p.id = pr.page_id
            WHERE p.published IS NOT NULL
            AND p.published < UTC_TIMESTAMP()
            AND p.dynamic = 1
            AND (p.homepage IS NULL OR p.homepage = 0)
            AND (
                SELECT pr_sub.id
                FROM `page_revision` pr_sub
                WHERE pr_sub.page_id = p.id
                AND pr_sub.published = 1
                ORDER BY pr_sub.updated_at DESC
                LIMIT 1
            ) = pr.id
            AND pr.template = 'App\\Form\\Page\\NewsPage';

SELECT
  t0.id AS id_1,
  t0.value AS value_2
FROM
  setting t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.value AS value_2 FROM setting t0 WHERE t0.id = 'oh_media_script_head_close';

SELECT
  t0.id AS id_1,
  t0.value AS value_2
FROM
  setting t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.value AS value_2 FROM setting t0 WHERE t0.id = 'oh_media_script_body_open';

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.content AS content_2,
  a0_.starts_at AS starts_at_3,
  a0_.ends_at AS ends_at_4,
  a0_.dismissible AS dismissible_5,
  a0_.dismissible_days AS dismissible_days_6,
  a0_.created_at AS created_at_7,
  a0_.created_by AS created_by_8,
  a0_.updated_at AS updated_at_9,
  a0_.updated_by AS updated_by_10
FROM
  alert a0_
WHERE
  a0_.starts_at IS NOT NULL
  AND a0_.starts_at < ?
  AND (
    (
      a0_.ends_at IS NULL
      OR a0_.ends_at > ?
    )
  )
ORDER BY
  a0_.starts_at DESC
LIMIT
  1

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.content AS content_2, a0_.starts_at AS starts_at_3, a0_.ends_at AS ends_at_4, a0_.dismissible AS dismissible_5, a0_.dismissible_days AS dismissible_days_6, a0_.created_at AS created_at_7, a0_.created_by AS created_by_8, a0_.updated_at AS updated_at_9, a0_.updated_by AS updated_by_10 FROM alert a0_ WHERE a0_.starts_at IS NOT NULL AND a0_.starts_at < '2025-12-06 05:01:48' AND ((a0_.ends_at IS NULL OR a0_.ends_at > '2025-12-06 05:01:48')) ORDER BY a0_.starts_at DESC LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.order_local AS order_local_3,
  p0_.order_global AS order_global_4,
  p0_.new_window AS new_window_5,
  p0_.hidden AS hidden_6,
  p0_.locked AS locked_7,
  p0_.published AS published_8,
  p0_.nesting_level AS nesting_level_9,
  p0_.path AS path_10,
  p0_.parent_slug AS parent_slug_11,
  p0_.homepage AS homepage_12,
  p0_.noindex AS noindex_13,
  p0_.redirect_type AS redirect_type_14,
  p0_.redirect_external AS redirect_external_15,
  p0_.nav_text AS nav_text_16,
  p0_.dynamic AS dynamic_17,
  p0_.sitemap AS sitemap_18,
  p0_.dropdown_text AS dropdown_text_19,
  p0_.locked_user_types AS locked_user_types_20,
  p0_.dropdown_only AS dropdown_only_21,
  p0_.created_at AS created_at_22,
  p0_.created_by AS created_by_23,
  p0_.updated_at AS updated_at_24,
  p0_.updated_by AS updated_by_25,
  p0_.parent_id AS parent_id_26,
  p0_.canonical_id AS canonical_id_27,
  p0_.meta_id AS meta_id_28,
  p0_.redirect_internal_id AS redirect_internal_id_29
FROM
  page p0_
WHERE
  p0_.hidden = 0
  AND p0_.nesting_level <= ?
  AND p0_.published IS NOT NULL
  AND p0_.published <= ?
  AND (
    (
      SELECT
        COUNT(p1_.id) AS sclr_30
      FROM
        page_revision p1_
      WHERE
        p1_.page_id = p0_.id
        AND p1_.published = 1
    ) > 0
  )
ORDER BY
  p0_.order_global ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.order_local AS order_local_3, p0_.order_global AS order_global_4, p0_.new_window AS new_window_5, p0_.hidden AS hidden_6, p0_.locked AS locked_7, p0_.published AS published_8, p0_.nesting_level AS nesting_level_9, p0_.path AS path_10, p0_.parent_slug AS parent_slug_11, p0_.homepage AS homepage_12, p0_.noindex AS noindex_13, p0_.redirect_type AS redirect_type_14, p0_.redirect_external AS redirect_external_15, p0_.nav_text AS nav_text_16, p0_.dynamic AS dynamic_17, p0_.sitemap AS sitemap_18, p0_.dropdown_text AS dropdown_text_19, p0_.locked_user_types AS locked_user_types_20, p0_.dropdown_only AS dropdown_only_21, p0_.created_at AS created_at_22, p0_.created_by AS created_by_23, p0_.updated_at AS updated_at_24, p0_.updated_by AS updated_by_25, p0_.parent_id AS parent_id_26, p0_.canonical_id AS canonical_id_27, p0_.meta_id AS meta_id_28, p0_.redirect_internal_id AS redirect_internal_id_29 FROM page p0_ WHERE p0_.hidden = 0 AND p0_.nesting_level <= 3 AND p0_.published IS NOT NULL AND p0_.published <= '2025-12-06 05:01:48' AND ((SELECT COUNT(p1_.id) AS sclr_30 FROM page_revision p1_ WHERE p1_.page_id = p0_.id AND p1_.published = 1) > 0) ORDER BY p0_.order_global ASC;

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  page_content_image p0_
  INNER JOIN file f1_ ON p0_.image_id = f1_.id
WHERE
  p0_.page_revision_id = ?
  AND p0_.name = ?
  AND f1_.path <> ''
  AND f1_.path IS NOT NULL

SELECT COUNT(p0_.id) AS sclr_0 FROM page_content_image p0_ INNER JOIN file f1_ ON p0_.image_id = f1_.id WHERE p0_.page_revision_id = 7 AND p0_.name = 'banner' AND f1_.path <> '' AND f1_.path IS NOT NULL;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.created_at AS created_at_2,
  p0_.created_by AS created_by_3,
  p0_.updated_at AS updated_at_4,
  p0_.updated_by AS updated_by_5,
  p0_.page_revision_id AS page_revision_id_6,
  p0_.image_id AS image_id_7
FROM
  page_content_image p0_
  INNER JOIN file f1_ ON p0_.image_id = f1_.id
WHERE
  p0_.page_revision_id = ?
  AND p0_.name = ?
  AND f1_.path <> ''
  AND f1_.path IS NOT NULL
LIMIT
  1

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.created_at AS created_at_2, p0_.created_by AS created_by_3, p0_.updated_at AS updated_at_4, p0_.updated_by AS updated_by_5, p0_.page_revision_id AS page_revision_id_6, p0_.image_id AS image_id_7 FROM page_content_image p0_ INNER JOIN file f1_ ON p0_.image_id = f1_.id WHERE p0_.page_revision_id = 7 AND p0_.name = 'banner' AND f1_.path <> '' AND f1_.path IS NOT NULL LIMIT 1;