Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          a0_.id AS id_0,
          a0_.title AS title_1,
          a0_.author AS author_2,
          a0_.snippet AS snippet_3,
          a0_.content AS content_4,
          a0_.published_at AS published_at_5,
          a0_.created_at AS created_at_6,
          a0_.created_by AS created_by_7,
          a0_.updated_at AS updated_at_8,
          a0_.updated_by AS updated_by_9,
          a0_.slug AS slug_10
        FROM
          article a0_
          INNER JOIN article_article_tag a2_ ON a0_.id = a2_.article_id
          INNER JOIN article_tag a1_ ON a1_.id = a2_.article_tag_id
        WHERE
          a0_.published_at IS NOT NULL
          AND a0_.published_at <= ?
          AND a1_.slug IN (?)
        ORDER BY
          a0_.published_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.author AS author_2, a0_.snippet AS snippet_3, a0_.content AS content_4, a0_.published_at AS published_at_5, a0_.created_at AS created_at_6, a0_.created_by AS created_by_7, a0_.updated_at AS updated_at_8, a0_.updated_by AS updated_by_9, a0_.slug AS slug_10 FROM article a0_ INNER JOIN article_article_tag a2_ ON a0_.id = a2_.article_id INNER JOIN article_tag a1_ ON a1_.id = a2_.article_tag_id WHERE a0_.published_at IS NOT NULL AND a0_.published_at <= '2025-12-06 09:00:48' AND a1_.slug IN ('economics') ORDER BY a0_.published_at DESC) dctrn_result) dctrn_table;

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
  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 = 'news' 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.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_.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 = 4 AND p0_.name = 'title' AND p0_.type = 'text' AND p0_.text IS NOT NULL AND p0_.text <> '' 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 09:00: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
  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.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 = 4 ORDER BY t0.updated_at DESC;

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;

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 09:00:48' AND ((a0_.ends_at IS NULL OR a0_.ends_at > '2025-12-06 09:00:48')) 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 = 4 AND p0_.name = 'banner' AND f1_.path <> '' AND f1_.path IS NOT NULL;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      published_at_5
    FROM
      (
        SELECT
          a0_.id AS id_0,
          a0_.title AS title_1,
          a0_.author AS author_2,
          a0_.snippet AS snippet_3,
          a0_.content AS content_4,
          a0_.published_at AS published_at_5,
          a0_.created_at AS created_at_6,
          a0_.created_by AS created_by_7,
          a0_.updated_at AS updated_at_8,
          a0_.updated_by AS updated_by_9,
          a0_.slug AS slug_10,
          a1_.id AS id_11,
          a1_.name AS name_12,
          a1_.created_at AS created_at_13,
          a1_.created_by AS created_by_14,
          a1_.updated_at AS updated_at_15,
          a1_.updated_by AS updated_by_16,
          a1_.slug AS slug_17
        FROM
          article a0_
          INNER JOIN article_article_tag a2_ ON a0_.id = a2_.article_id
          INNER JOIN article_tag a1_ ON a1_.id = a2_.article_tag_id
        WHERE
          a0_.published_at IS NOT NULL
          AND a0_.published_at <= ?
          AND a1_.slug IN (?)
      ) dctrn_result_inner
    ORDER BY
      published_at_5 DESC
  ) dctrn_result
LIMIT
  12

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, published_at_5 FROM (SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.author AS author_2, a0_.snippet AS snippet_3, a0_.content AS content_4, a0_.published_at AS published_at_5, a0_.created_at AS created_at_6, a0_.created_by AS created_by_7, a0_.updated_at AS updated_at_8, a0_.updated_by AS updated_by_9, a0_.slug AS slug_10, a1_.id AS id_11, a1_.name AS name_12, a1_.created_at AS created_at_13, a1_.created_by AS created_by_14, a1_.updated_at AS updated_at_15, a1_.updated_by AS updated_by_16, a1_.slug AS slug_17 FROM article a0_ INNER JOIN article_article_tag a2_ ON a0_.id = a2_.article_id INNER JOIN article_tag a1_ ON a1_.id = a2_.article_tag_id WHERE a0_.published_at IS NOT NULL AND a0_.published_at <= '2025-12-06 09:00:48' AND a1_.slug IN ('economics')) dctrn_result_inner ORDER BY published_at_5 DESC) dctrn_result LIMIT 12;

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;