Symfony Profiler

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
  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
  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_.text AS text_6,
  p0_.type AS type_7,
  p0_.page_revision_id AS page_revision_id_8
FROM
  page_content_text p0_
WHERE
  p0_.page_revision_id = ?
  AND p0_.name = ?
  AND p0_.type = ?
  AND p0_.text IS NOT NULL
  AND p0_.text <> ''
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_.text AS text_6, p0_.type AS type_7, p0_.page_revision_id AS page_revision_id_8 FROM page_content_text p0_ WHERE p0_.page_revision_id = 1 AND p0_.name = 'hero_banner_title' AND p0_.type = 'text' AND p0_.text IS NOT NULL AND p0_.text <> '' LIMIT 1;

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  page_content_text p0_
WHERE
  p0_.page_revision_id = ?
  AND p0_.name = ?
  AND p0_.type = ?
  AND p0_.text IS NOT NULL
  AND p0_.text <> ''

SELECT COUNT(p0_.id) AS sclr_0 FROM page_content_text p0_ WHERE p0_.page_revision_id = 1 AND p0_.name = 'hero_banner_title' AND p0_.type = 'text' AND p0_.text IS NOT NULL AND p0_.text <> '';

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.resize_parent_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.resize_parent_id = 8;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.created_by AS created_by_4,
  t0.updated_at AS updated_at_5,
  t0.updated_by AS updated_by_6,
  t0.slug AS slug_7
FROM
  event_tag t0
  INNER JOIN event_event_tag ON t0.id = event_event_tag.event_tag_id
WHERE
  event_event_tag.event_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.created_by AS created_by_4, t0.updated_at AS updated_at_5, t0.updated_by AS updated_by_6, t0.slug AS slug_7 FROM event_tag t0 INNER JOIN event_event_tag ON t0.id = event_event_tag.event_tag_id WHERE event_event_tag.event_id = 1;

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

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.created_by AS created_by_4,
  t0.updated_at AS updated_at_5,
  t0.updated_by AS updated_by_6,
  t0.slug AS slug_7
FROM
  article_tag t0
  INNER JOIN article_article_tag ON t0.id = article_article_tag.article_tag_id
WHERE
  article_article_tag.article_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.created_by AS created_by_4, t0.updated_at AS updated_at_5, t0.updated_by AS updated_by_6, t0.slug AS slug_7 FROM article_tag t0 INNER JOIN article_article_tag ON t0.id = article_article_tag.article_tag_id WHERE article_article_tag.article_id = 1;

SELECT
  t0.id AS id_1,
  t0.starts_at AS starts_at_2,
  t0.ends_at AS ends_at_3,
  t0.event_id AS event_id_4
FROM
  event_time t0
WHERE
  t0.event_id = ?
ORDER BY
  t0.starts_at ASC

SELECT t0.id AS id_1, t0.starts_at AS starts_at_2, t0.ends_at AS ends_at_3, t0.event_id AS event_id_4 FROM event_time t0 WHERE t0.event_id = 1 ORDER BY t0.starts_at ASC;

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

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,
  e0_.image_id AS image_id_15
FROM
  event e0_
WHERE
  (
    SELECT
      MAX(e2_.ends_at) AS sclr_16
    FROM
      event_time e2_
    WHERE
      e2_.event_id = e0_.id
  ) > ?
  AND e0_.published_at IS NOT NULL
  AND e0_.published_at < ?
ORDER BY
  sclr_13 ASC
LIMIT
  6

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 04:10:41') AS sclr_13, e0_.image_id AS image_id_15 FROM event e0_ WHERE (SELECT MAX(e2_.ends_at) AS sclr_16 FROM event_time e2_ WHERE e2_.event_id = e0_.id) > '2025-12-06 04:10:41' AND e0_.published_at IS NOT NULL AND e0_.published_at < '2025-12-06 04:10:41' ORDER BY sclr_13 ASC LIMIT 6;

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.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 = 1 ORDER BY t0.updated_at DESC;

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