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/in-hac-habitasse-platea-dictumst' LIMIT 1;

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.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
  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 < ?
  AND e0_.slug = ?
ORDER BY
  sclr_13 ASC
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 > '2025-12-06 05:22:06') 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 05:22:06' AND e0_.published_at IS NOT NULL AND e0_.published_at < '2025-12-06 05:22:06' AND e0_.slug = 'in-hac-habitasse-platea-dictumst' ORDER BY sclr_13 ASC 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.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;

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:22:06' 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
  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.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 = ?
  AND t0.dynamic = ?
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' AND t0.dynamic = 1 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
  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:22:06' AND ((a0_.ends_at IS NULL OR a0_.ends_at > '2025-12-06 05:22:06')) ORDER BY a0_.starts_at DESC LIMIT 1;

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

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 = 3 AND p0_.name = 'title' AND p0_.type = 'text' AND p0_.text IS NOT NULL AND p0_.text <> '' LIMIT 1;

SELECT
  l0_.id AS id_0,
  l0_.ordinal AS ordinal_1,
  l0_.name AS name_2,
  l0_.address AS address_3,
  l0_.city AS city_4,
  l0_.province AS province_5,
  l0_.country AS country_6,
  l0_.postal_code AS postal_code_7,
  l0_.phone AS phone_8,
  l0_.email AS email_9,
  l0_.main AS main_10,
  l0_.fax AS fax_11,
  l0_.created_at AS created_at_12,
  l0_.created_by AS created_by_13,
  l0_.updated_at AS updated_at_14,
  l0_.updated_by AS updated_by_15
FROM
  location l0_
WHERE
  l0_.main = 1
LIMIT
  1

SELECT l0_.id AS id_0, l0_.ordinal AS ordinal_1, l0_.name AS name_2, l0_.address AS address_3, l0_.city AS city_4, l0_.province AS province_5, l0_.country AS country_6, l0_.postal_code AS postal_code_7, l0_.phone AS phone_8, l0_.email AS email_9, l0_.main AS main_10, l0_.fax AS fax_11, l0_.created_at AS created_at_12, l0_.created_by AS created_by_13, l0_.updated_at AS updated_at_14, l0_.updated_by AS updated_by_15 FROM location l0_ WHERE l0_.main = 1 LIMIT 1;