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 = 'events' 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 = 3 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 = 3;

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 07:20:03' AND ((a0_.ends_at IS NULL OR a0_.ends_at > '2025-12-06 07:20:03')) 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 07:20:03' 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(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          e0_.id AS id_0,
          e0_.name AS name_1,
          e0_.snippet AS snippet_2,
          e0_.description AS description_3,
          e0_.location AS location_4,
          e0_.ticket_url AS ticket_url_5,
          e0_.timezone AS timezone_6,
          e0_.published_at AS published_at_7,
          e0_.created_at AS created_at_8,
          e0_.created_by AS created_by_9,
          e0_.updated_at AS updated_at_10,
          e0_.updated_by AS updated_by_11,
          e0_.slug AS slug_12,
          (
            SELECT
              MIN(e1_.starts_at) AS sclr_14
            FROM
              event_time e1_
            WHERE
              e1_.event_id = e0_.id
              AND e1_.ends_at > ?
          ) AS sclr_13
        FROM
          event e0_
          INNER JOIN event_event_tag e3_ ON e0_.id = e3_.event_id
          INNER JOIN event_tag e2_ ON e2_.id = e3_.event_tag_id
        WHERE
          (
            SELECT
              MAX(e4_.ends_at) AS sclr_15
            FROM
              event_time e4_
            WHERE
              e4_.event_id = e0_.id
          ) > ?
          AND e0_.published_at IS NOT NULL
          AND e0_.published_at < ?
          AND e2_.slug IN (?)
        ORDER BY
          sclr_13 ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.snippet AS snippet_2, e0_.description AS description_3, e0_.location AS location_4, e0_.ticket_url AS ticket_url_5, e0_.timezone AS timezone_6, e0_.published_at AS published_at_7, e0_.created_at AS created_at_8, e0_.created_by AS created_by_9, e0_.updated_at AS updated_at_10, e0_.updated_by AS updated_by_11, e0_.slug AS slug_12, (SELECT MIN(e1_.starts_at) AS sclr_14 FROM event_time e1_ WHERE e1_.event_id = e0_.id AND e1_.ends_at > '2025-12-06 07:20:03') AS sclr_13 FROM event e0_ INNER JOIN event_event_tag e3_ ON e0_.id = e3_.event_id INNER JOIN event_tag e2_ ON e2_.id = e3_.event_tag_id WHERE (SELECT MAX(e4_.ends_at) AS sclr_15 FROM event_time e4_ WHERE e4_.event_id = e0_.id) > '2025-12-06 07:20:03' AND e0_.published_at IS NOT NULL AND e0_.published_at < '2025-12-06 07:20:03' AND e2_.slug IN ('free') ORDER BY sclr_13 ASC) dctrn_result) dctrn_table;

SELECT
  e0_.id AS id_0,
  e0_.name AS name_1,
  e0_.created_at AS created_at_2,
  e0_.created_by AS created_by_3,
  e0_.updated_at AS updated_at_4,
  e0_.updated_by AS updated_by_5,
  e0_.slug AS slug_6
FROM
  event_tag e0_
  INNER JOIN event_event_tag e2_ ON e0_.id = e2_.event_tag_id
  INNER JOIN event e1_ ON e1_.id = e2_.event_id
WHERE
  e1_.published_at IS NOT NULL
  AND e1_.published_at <= ?

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.created_at AS created_at_2, e0_.created_by AS created_by_3, e0_.updated_at AS updated_at_4, e0_.updated_by AS updated_by_5, e0_.slug AS slug_6 FROM event_tag e0_ INNER JOIN event_event_tag e2_ ON e0_.id = e2_.event_tag_id INNER JOIN event e1_ ON e1_.id = e2_.event_id WHERE e1_.published_at IS NOT NULL AND e1_.published_at <= '2025-12-06 07:20:03';

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 = 3 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 = 3 AND p0_.name = 'banner' AND f1_.path <> '' AND f1_.path IS NOT NULL LIMIT 1;