Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          e0_.id AS id_0,
          e0_.locale AS locale_1,
          e0_.slug AS slug_2,
          e0_.title AS title_3,
          e0_.description AS description_4,
          e0_.content_html AS content_html_5,
          e0_.start_at AS start_at_6,
          e0_.end_at AS end_at_7,
          e0_.location AS location_8,
          e0_.image_path AS image_path_9,
          e0_.status AS status_10,
          e0_.requires_registration AS requires_registration_11,
          e0_.price_cents AS price_cents_12,
          e0_.currency AS currency_13,
          e0_.created_at AS created_at_14,
          e0_.updated_at AS updated_at_15
        FROM
          event e0_
        WHERE
          e0_.locale = ?
          AND e0_.status = ?
          AND e0_.start_at >= ?
        ORDER BY
          e0_.start_at ASC,
          e0_.created_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT e0_.id AS id_0, e0_.locale AS locale_1, e0_.slug AS slug_2, e0_.title AS title_3, e0_.description AS description_4, e0_.content_html AS content_html_5, e0_.start_at AS start_at_6, e0_.end_at AS end_at_7, e0_.location AS location_8, e0_.image_path AS image_path_9, e0_.status AS status_10, e0_.requires_registration AS requires_registration_11, e0_.price_cents AS price_cents_12, e0_.currency AS currency_13, e0_.created_at AS created_at_14, e0_.updated_at AS updated_at_15 FROM event e0_ WHERE e0_.locale = 'en' AND e0_.status = 'published' AND e0_.start_at >= '2026-03-01 12:02:00' ORDER BY e0_.start_at ASC, e0_.created_at DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0,
  MIN(sclr_16) AS dctrn_minrownum
FROM
  (
    SELECT
      e0_.id AS id_0,
      e0_.locale AS locale_1,
      e0_.slug AS slug_2,
      e0_.title AS title_3,
      e0_.description AS description_4,
      e0_.content_html AS content_html_5,
      e0_.start_at AS start_at_6,
      e0_.end_at AS end_at_7,
      e0_.location AS location_8,
      e0_.image_path AS image_path_9,
      e0_.status AS status_10,
      e0_.requires_registration AS requires_registration_11,
      e0_.price_cents AS price_cents_12,
      e0_.currency AS currency_13,
      e0_.created_at AS created_at_14,
      e0_.updated_at AS updated_at_15,
      ROW_NUMBER() OVER(
        ORDER BY
          e0_.start_at ASC,
          e0_.created_at DESC
      ) AS sclr_16
    FROM
      event e0_
    WHERE
      e0_.locale = ?
      AND e0_.status = ?
      AND e0_.start_at >= ?
  ) dctrn_result
GROUP BY
  id_0
ORDER BY
  dctrn_minrownum ASC
LIMIT
  6

SELECT DISTINCT id_0, MIN(sclr_16) AS dctrn_minrownum FROM (SELECT e0_.id AS id_0, e0_.locale AS locale_1, e0_.slug AS slug_2, e0_.title AS title_3, e0_.description AS description_4, e0_.content_html AS content_html_5, e0_.start_at AS start_at_6, e0_.end_at AS end_at_7, e0_.location AS location_8, e0_.image_path AS image_path_9, e0_.status AS status_10, e0_.requires_registration AS requires_registration_11, e0_.price_cents AS price_cents_12, e0_.currency AS currency_13, e0_.created_at AS created_at_14, e0_.updated_at AS updated_at_15, ROW_NUMBER() OVER(ORDER BY e0_.start_at ASC, e0_.created_at DESC) AS sclr_16 FROM event e0_ WHERE e0_.locale = 'en' AND e0_.status = 'published' AND e0_.start_at >= '2026-03-01 12:02:00') dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 6;

SELECT
  e0_.id AS id_0,
  e0_.locale AS locale_1,
  e0_.slug AS slug_2,
  e0_.title AS title_3,
  e0_.description AS description_4,
  e0_.content_html AS content_html_5,
  e0_.start_at AS start_at_6,
  e0_.end_at AS end_at_7,
  e0_.location AS location_8,
  e0_.image_path AS image_path_9,
  e0_.status AS status_10,
  e0_.requires_registration AS requires_registration_11,
  e0_.price_cents AS price_cents_12,
  e0_.currency AS currency_13,
  e0_.created_at AS created_at_14,
  e0_.updated_at AS updated_at_15
FROM
  event e0_
WHERE
  e0_.locale = ?
  AND e0_.status = ?
  AND e0_.start_at >= ?
  AND e0_.id IN (?, ?, ?)
ORDER BY
  e0_.start_at ASC,
  e0_.created_at DESC

SELECT e0_.id AS id_0, e0_.locale AS locale_1, e0_.slug AS slug_2, e0_.title AS title_3, e0_.description AS description_4, e0_.content_html AS content_html_5, e0_.start_at AS start_at_6, e0_.end_at AS end_at_7, e0_.location AS location_8, e0_.image_path AS image_path_9, e0_.status AS status_10, e0_.requires_registration AS requires_registration_11, e0_.price_cents AS price_cents_12, e0_.currency AS currency_13, e0_.created_at AS created_at_14, e0_.updated_at AS updated_at_15 FROM event e0_ WHERE e0_.locale = 'en' AND e0_.status = 'published' AND e0_.start_at >= '2026-03-01 12:02:00' AND e0_.id IN ('019b698c-ec18-7633-8cc1-d7145551408a', '019b698c-ec18-7a23-8cc1-d71455d70625', '019b698c-ec18-7e3f-8cc1-d7145600ac42') ORDER BY e0_.start_at ASC, e0_.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.route_name AS route_name_2,
  t0.locale AS locale_3,
  t0.slug AS slug_4,
  t0.title_h1 AS title_h1_5,
  t0.meta_title AS meta_title_6,
  t0.meta_description AS meta_description_7,
  t0.body_html AS body_html_8,
  t0.needs_translation AS needs_translation_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11
FROM
  cms_page t0
WHERE
  t0.route_name = ?
  AND t0.locale = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.route_name AS route_name_2, t0.locale AS locale_3, t0.slug AS slug_4, t0.title_h1 AS title_h1_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.body_html AS body_html_8, t0.needs_translation AS needs_translation_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM cms_page t0 WHERE t0.route_name = 'event' AND t0.locale = 'en' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.route_name AS route_name_2,
  t0.locale AS locale_3,
  t0.slug AS slug_4,
  t0.title_h1 AS title_h1_5,
  t0.meta_title AS meta_title_6,
  t0.meta_description AS meta_description_7,
  t0.body_html AS body_html_8,
  t0.needs_translation AS needs_translation_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11
FROM
  cms_page t0
WHERE
  t0.route_name = ?
  AND t0.locale = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.route_name AS route_name_2, t0.locale AS locale_3, t0.slug AS slug_4, t0.title_h1 AS title_h1_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.body_html AS body_html_8, t0.needs_translation AS needs_translation_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM cms_page t0 WHERE t0.route_name = 'event' AND t0.locale = 'base' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.asset_key AS asset_key_2,
  t0.asset_kind AS asset_kind_3,
  t0.page_id AS page_id_4,
  t0.media_id AS media_id_5
FROM
  cms_page_asset t0
WHERE
  t0.page_id = ?

SELECT t0.id AS id_1, t0.asset_key AS asset_key_2, t0.asset_kind AS asset_kind_3, t0.page_id AS page_id_4, t0.media_id AS media_id_5 FROM cms_page_asset t0 WHERE t0.page_id = '019b4aea-402b-7c45-a5ba-7dc68964ff57';

SELECT
  t0.id AS id_1,
  t0.file_path AS file_path_2,
  t0.original_name AS original_name_3,
  t0.mime_type AS mime_type_4,
  t0.size AS size_5,
  t0.title AS title_6,
  t0.alt_fr AS alt_fr_7,
  t0.alt_en AS alt_en_8,
  t0.created_at AS created_at_9
FROM
  cms_media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.original_name AS original_name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.title AS title_6, t0.alt_fr AS alt_fr_7, t0.alt_en AS alt_en_8, t0.created_at AS created_at_9 FROM cms_media t0 WHERE t0.id = '019b4b0e-9173-70d0-8d17-815cd4e96f16';

SELECT
  t0.id AS id_1,
  t0.file_path AS file_path_2,
  t0.original_name AS original_name_3,
  t0.mime_type AS mime_type_4,
  t0.size AS size_5,
  t0.title AS title_6,
  t0.alt_fr AS alt_fr_7,
  t0.alt_en AS alt_en_8,
  t0.created_at AS created_at_9
FROM
  cms_media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.original_name AS original_name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.title AS title_6, t0.alt_fr AS alt_fr_7, t0.alt_en AS alt_en_8, t0.created_at AS created_at_9 FROM cms_media t0 WHERE t0.id = '019b4b0e-9173-7b1c-8d17-815cd53ccc00';

SELECT
  t0.id AS id_1,
  t0.file_path AS file_path_2,
  t0.original_name AS original_name_3,
  t0.mime_type AS mime_type_4,
  t0.size AS size_5,
  t0.title AS title_6,
  t0.alt_fr AS alt_fr_7,
  t0.alt_en AS alt_en_8,
  t0.created_at AS created_at_9
FROM
  cms_media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.original_name AS original_name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.title AS title_6, t0.alt_fr AS alt_fr_7, t0.alt_en AS alt_en_8, t0.created_at AS created_at_9 FROM cms_media t0 WHERE t0.id = '019b4b0e-9174-7575-9df0-f42b3894badb';

SELECT
  t0.id AS id_1,
  t0.file_path AS file_path_2,
  t0.original_name AS original_name_3,
  t0.mime_type AS mime_type_4,
  t0.size AS size_5,
  t0.title AS title_6,
  t0.alt_fr AS alt_fr_7,
  t0.alt_en AS alt_en_8,
  t0.created_at AS created_at_9
FROM
  cms_media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.original_name AS original_name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.title AS title_6, t0.alt_fr AS alt_fr_7, t0.alt_en AS alt_en_8, t0.created_at AS created_at_9 FROM cms_media t0 WHERE t0.id = '019b4b0e-91ce-7c8b-8354-feccf1f188c0';

SELECT
  t0.id AS id_1,
  t0.file_path AS file_path_2,
  t0.original_name AS original_name_3,
  t0.mime_type AS mime_type_4,
  t0.size AS size_5,
  t0.title AS title_6,
  t0.alt_fr AS alt_fr_7,
  t0.alt_en AS alt_en_8,
  t0.created_at AS created_at_9
FROM
  cms_media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.original_name AS original_name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.title AS title_6, t0.alt_fr AS alt_fr_7, t0.alt_en AS alt_en_8, t0.created_at AS created_at_9 FROM cms_media t0 WHERE t0.id = '019b4b0e-9172-757a-9208-9fa2c29ff0eb';

SELECT
  c0_.id AS id_0,
  c0_.key AS key_1,
  c0_.locale AS locale_2,
  c0_.value_type AS value_type_3,
  c0_.value AS value_4,
  c0_.created_at AS created_at_5,
  c0_.updated_at AS updated_at_6
FROM
  cms_site_setting c0_
WHERE
  c0_.key = ?
  AND c0_.locale = ?

SELECT c0_.id AS id_0, c0_.key AS key_1, c0_.locale AS locale_2, c0_.value_type AS value_type_3, c0_.value AS value_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6 FROM cms_site_setting c0_ WHERE c0_.key = 'header.top_message' AND c0_.locale = 'en';

SELECT
  c0_.id AS id_0,
  c0_.key AS key_1,
  c0_.locale AS locale_2,
  c0_.value_type AS value_type_3,
  c0_.value AS value_4,
  c0_.created_at AS created_at_5,
  c0_.updated_at AS updated_at_6
FROM
  cms_site_setting c0_
WHERE
  c0_.key = ?
  AND c0_.locale IS NULL

SELECT c0_.id AS id_0, c0_.key AS key_1, c0_.locale AS locale_2, c0_.value_type AS value_type_3, c0_.value AS value_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6 FROM cms_site_setting c0_ WHERE c0_.key = 'contact.email' AND c0_.locale IS NULL;

SELECT
  c0_.id AS id_0,
  c0_.key AS key_1,
  c0_.locale AS locale_2,
  c0_.value_type AS value_type_3,
  c0_.value AS value_4,
  c0_.created_at AS created_at_5,
  c0_.updated_at AS updated_at_6
FROM
  cms_site_setting c0_
WHERE
  c0_.key = ?
  AND c0_.locale IS NULL

SELECT c0_.id AS id_0, c0_.key AS key_1, c0_.locale AS locale_2, c0_.value_type AS value_type_3, c0_.value AS value_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6 FROM cms_site_setting c0_ WHERE c0_.key = 'contact.phone_display' AND c0_.locale IS NULL;

SELECT
  c0_.id AS id_0,
  c0_.key AS key_1,
  c0_.locale AS locale_2,
  c0_.value_type AS value_type_3,
  c0_.value AS value_4,
  c0_.created_at AS created_at_5,
  c0_.updated_at AS updated_at_6
FROM
  cms_site_setting c0_
WHERE
  c0_.key = ?
  AND c0_.locale IS NULL

SELECT c0_.id AS id_0, c0_.key AS key_1, c0_.locale AS locale_2, c0_.value_type AS value_type_3, c0_.value AS value_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6 FROM cms_site_setting c0_ WHERE c0_.key = 'contact.phone_e164' AND c0_.locale IS NULL;

SELECT
  c0_.id AS id_0,
  c0_.key AS key_1,
  c0_.locale AS locale_2,
  c0_.value_type AS value_type_3,
  c0_.value AS value_4,
  c0_.created_at AS created_at_5,
  c0_.updated_at AS updated_at_6
FROM
  cms_site_setting c0_
WHERE
  c0_.key = ?
  AND c0_.locale = ?

SELECT c0_.id AS id_0, c0_.key AS key_1, c0_.locale AS locale_2, c0_.value_type AS value_type_3, c0_.value AS value_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6 FROM cms_site_setting c0_ WHERE c0_.key = 'contact.address' AND c0_.locale = 'en';

SELECT
  c0_.id AS id_0,
  c0_.key AS key_1,
  c0_.locale AS locale_2,
  c0_.value_type AS value_type_3,
  c0_.value AS value_4,
  c0_.created_at AS created_at_5,
  c0_.updated_at AS updated_at_6
FROM
  cms_site_setting c0_
WHERE
  c0_.key = ?
  AND c0_.locale IS NULL

SELECT c0_.id AS id_0, c0_.key AS key_1, c0_.locale AS locale_2, c0_.value_type AS value_type_3, c0_.value AS value_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6 FROM cms_site_setting c0_ WHERE c0_.key = 'contact.show_email' AND c0_.locale IS NULL;

SELECT
  c0_.id AS id_0,
  c0_.key AS key_1,
  c0_.locale AS locale_2,
  c0_.value_type AS value_type_3,
  c0_.value AS value_4,
  c0_.created_at AS created_at_5,
  c0_.updated_at AS updated_at_6
FROM
  cms_site_setting c0_
WHERE
  c0_.key = ?
  AND c0_.locale IS NULL

SELECT c0_.id AS id_0, c0_.key AS key_1, c0_.locale AS locale_2, c0_.value_type AS value_type_3, c0_.value AS value_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6 FROM cms_site_setting c0_ WHERE c0_.key = 'contact.show_phone' AND c0_.locale IS NULL;

SELECT
  c0_.id AS id_0,
  c0_.key AS key_1,
  c0_.locale AS locale_2,
  c0_.value_type AS value_type_3,
  c0_.value AS value_4,
  c0_.created_at AS created_at_5,
  c0_.updated_at AS updated_at_6
FROM
  cms_site_setting c0_
WHERE
  c0_.key = ?
  AND c0_.locale IS NULL

SELECT c0_.id AS id_0, c0_.key AS key_1, c0_.locale AS locale_2, c0_.value_type AS value_type_3, c0_.value AS value_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6 FROM cms_site_setting c0_ WHERE c0_.key = 'contact.show_address' AND c0_.locale IS NULL;

SELECT
  c0_.id AS id_0,
  c0_.enabled AS enabled_1,
  c0_.sort_order AS sort_order_2,
  c0_.platform AS platform_3,
  c0_.url AS url_4,
  c0_.icon_class AS icon_class_5,
  c0_.label_fr AS label_fr_6,
  c0_.label_en AS label_en_7
FROM
  cms_social_link c0_
WHERE
  c0_.enabled = ?
  AND c0_.url <> ?
ORDER BY
  c0_.sort_order ASC,
  c0_.platform ASC

SELECT c0_.id AS id_0, c0_.enabled AS enabled_1, c0_.sort_order AS sort_order_2, c0_.platform AS platform_3, c0_.url AS url_4, c0_.icon_class AS icon_class_5, c0_.label_fr AS label_fr_6, c0_.label_en AS label_en_7 FROM cms_social_link c0_ WHERE c0_.enabled = 1 AND c0_.url <> '' ORDER BY c0_.sort_order ASC, c0_.platform ASC;