Symfony Profiler

SELECT 
  t0.enabled AS enabled_1, 
  t0.name AS name_2, 
  t0.relative_path AS relative_path_3, 
  t0.host AS host_4, 
  t0.enabled_from AS enabled_from_5, 
  t0.enabled_to AS enabled_to_6, 
  t0.is_default AS is_default_7, 
  t0.created_at AS created_at_8, 
  t0.updated_at AS updated_at_9, 
  t0.locale AS locale_10, 
  t0.title AS title_11, 
  t0.meta_keywords AS meta_keywords_12, 
  t0.meta_description AS meta_description_13, 
  t0.id AS id_14 
FROM 
  page__site t0 
WHERE 
  t0.host IN (?) 
  AND t0.enabled = ? 
ORDER BY 
  t0.is_default DESC

SELECT t0.enabled AS enabled_1, t0.name AS name_2, t0.relative_path AS relative_path_3, t0.host AS host_4, t0.enabled_from AS enabled_from_5, t0.enabled_to AS enabled_to_6, t0.is_default AS is_default_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.locale AS locale_10, t0.title AS title_11, t0.meta_keywords AS meta_keywords_12, t0.meta_description AS meta_description_13, t0.id AS id_14 FROM page__site t0 WHERE t0.host IN ('www.vb.dev2.intercode.ca', 'localhost') AND t0.enabled = 1 ORDER BY t0.is_default DESC;

SELECT 
  p0_.route_name AS route_name_0, 
  p0_.page_alias AS page_alias_1, 
  p0_.type AS type_2, 
  p0_.position AS position_3, 
  p0_.enabled AS enabled_4, 
  p0_.decorate AS decorate_5, 
  p0_.name AS name_6, 
  p0_.url AS url_7, 
  p0_.parent_id AS parent_id_8, 
  p0_.target_id AS target_id_9, 
  p0_.content AS content_10, 
  p0_.publication_date_start AS publication_date_start_11, 
  p0_.publication_date_end AS publication_date_end_12, 
  p0_.created_at AS created_at_13, 
  p0_.updated_at AS updated_at_14, 
  p0_.id AS id_15, 
  p0_.site_id AS site_id_16, 
  p0_.page_id AS page_id_17 
FROM 
  page__snapshot p0_ 
WHERE 
  (
    p0_.publication_date_start <= ? 
    AND (
      p0_.publication_date_end IS NULL 
      OR p0_.publication_date_end >= ?
    )
  ) 
  AND p0_.enabled = 1 
  AND p0_.site_id = ? 
  AND p0_.url = ? 
LIMIT 
  1

SELECT p0_.route_name AS route_name_0, p0_.page_alias AS page_alias_1, p0_.type AS type_2, p0_.position AS position_3, p0_.enabled AS enabled_4, p0_.decorate AS decorate_5, p0_.name AS name_6, p0_.url AS url_7, p0_.parent_id AS parent_id_8, p0_.target_id AS target_id_9, p0_.content AS content_10, p0_.publication_date_start AS publication_date_start_11, p0_.publication_date_end AS publication_date_end_12, p0_.created_at AS created_at_13, p0_.updated_at AS updated_at_14, p0_.id AS id_15, p0_.site_id AS site_id_16, p0_.page_id AS page_id_17 FROM page__snapshot p0_ WHERE (p0_.publication_date_start <= '2026-04-03 12:12:12' AND (p0_.publication_date_end IS NULL OR p0_.publication_date_end >= '2026-04-03 12:12:12')) AND p0_.enabled = 1 AND p0_.site_id = 1 AND p0_.url = '/login' LIMIT 1;

SELECT 
  p0_.id AS id_0, 
  p0_.translateId AS translateId_1, 
  p0_.pageId AS pageId_2, 
  p0_.siteId AS siteId_3 
FROM 
  page_translate p0_ 
WHERE 
  p0_.pageId = ?

SELECT p0_.id AS id_0, p0_.translateId AS translateId_1, p0_.pageId AS pageId_2, p0_.siteId AS siteId_3 FROM page_translate p0_ WHERE p0_.pageId = 3;

SELECT 
  p0_.route_name AS route_name_0, 
  p0_.page_alias AS page_alias_1, 
  p0_.type AS type_2, 
  p0_.position AS position_3, 
  p0_.enabled AS enabled_4, 
  p0_.decorate AS decorate_5, 
  p0_.edited AS edited_6, 
  p0_.name AS name_7, 
  p0_.slug AS slug_8, 
  p0_.url AS url_9, 
  p0_.custom_url AS custom_url_10, 
  p0_.request_method AS request_method_11, 
  p0_.title AS title_12, 
  p0_.meta_keyword AS meta_keyword_13, 
  p0_.meta_description AS meta_description_14, 
  p0_.javascript AS javascript_15, 
  p0_.stylesheet AS stylesheet_16, 
  p0_.raw_headers AS raw_headers_17, 
  p0_.template AS template_18, 
  p0_.created_at AS created_at_19, 
  p0_.updated_at AS updated_at_20, 
  p0_.id AS id_21, 
  p0_.site_id AS site_id_22, 
  p0_.parent_id AS parent_id_23, 
  p0_.target_id AS target_id_24 
FROM 
  page__page p0_ 
WHERE 
  p0_.id = ? 
  AND p0_.enabled = 1

SELECT p0_.route_name AS route_name_0, p0_.page_alias AS page_alias_1, p0_.type AS type_2, p0_.position AS position_3, p0_.enabled AS enabled_4, p0_.decorate AS decorate_5, p0_.edited AS edited_6, p0_.name AS name_7, p0_.slug AS slug_8, p0_.url AS url_9, p0_.custom_url AS custom_url_10, p0_.request_method AS request_method_11, p0_.title AS title_12, p0_.meta_keyword AS meta_keyword_13, p0_.meta_description AS meta_description_14, p0_.javascript AS javascript_15, p0_.stylesheet AS stylesheet_16, p0_.raw_headers AS raw_headers_17, p0_.template AS template_18, p0_.created_at AS created_at_19, p0_.updated_at AS updated_at_20, p0_.id AS id_21, p0_.site_id AS site_id_22, p0_.parent_id AS parent_id_23, p0_.target_id AS target_id_24 FROM page__page p0_ WHERE p0_.id = '42' AND p0_.enabled = 1;

SELECT 
  p0_.route_name AS route_name_0, 
  p0_.page_alias AS page_alias_1, 
  p0_.type AS type_2, 
  p0_.position AS position_3, 
  p0_.enabled AS enabled_4, 
  p0_.decorate AS decorate_5, 
  p0_.name AS name_6, 
  p0_.url AS url_7, 
  p0_.parent_id AS parent_id_8, 
  p0_.target_id AS target_id_9, 
  p0_.content AS content_10, 
  p0_.publication_date_start AS publication_date_start_11, 
  p0_.publication_date_end AS publication_date_end_12, 
  p0_.created_at AS created_at_13, 
  p0_.updated_at AS updated_at_14, 
  p0_.id AS id_15, 
  p0_.site_id AS site_id_16, 
  p0_.page_id AS page_id_17 
FROM 
  page__snapshot p0_ 
WHERE 
  (
    p0_.publication_date_start <= ? 
    AND (
      p0_.publication_date_end IS NULL 
      OR p0_.publication_date_end >= ?
    )
  ) 
  AND p0_.enabled = 1 
  AND p0_.site_id = ? 
  AND p0_.route_name = ? 
LIMIT 
  1

SELECT p0_.route_name AS route_name_0, p0_.page_alias AS page_alias_1, p0_.type AS type_2, p0_.position AS position_3, p0_.enabled AS enabled_4, p0_.decorate AS decorate_5, p0_.name AS name_6, p0_.url AS url_7, p0_.parent_id AS parent_id_8, p0_.target_id AS target_id_9, p0_.content AS content_10, p0_.publication_date_start AS publication_date_start_11, p0_.publication_date_end AS publication_date_end_12, p0_.created_at AS created_at_13, p0_.updated_at AS updated_at_14, p0_.id AS id_15, p0_.site_id AS site_id_16, p0_.page_id AS page_id_17 FROM page__snapshot p0_ WHERE (p0_.publication_date_start <= '2026-04-03 12:12:12' AND (p0_.publication_date_end IS NULL OR p0_.publication_date_end >= '2026-04-03 12:12:12')) AND p0_.enabled = 1 AND p0_.site_id = 1 AND p0_.route_name = 'sonata_user_security_login' LIMIT 1;

SELECT 
  t0.enabled AS enabled_1, 
  t0.name AS name_2, 
  t0.relative_path AS relative_path_3, 
  t0.host AS host_4, 
  t0.enabled_from AS enabled_from_5, 
  t0.enabled_to AS enabled_to_6, 
  t0.is_default AS is_default_7, 
  t0.created_at AS created_at_8, 
  t0.updated_at AS updated_at_9, 
  t0.locale AS locale_10, 
  t0.title AS title_11, 
  t0.meta_keywords AS meta_keywords_12, 
  t0.meta_description AS meta_description_13, 
  t0.id AS id_14 
FROM 
  page__site t0 
WHERE 
  t0.host IN (?) 
  AND t0.enabled = ? 
ORDER BY 
  t0.is_default DESC

SELECT t0.enabled AS enabled_1, t0.name AS name_2, t0.relative_path AS relative_path_3, t0.host AS host_4, t0.enabled_from AS enabled_from_5, t0.enabled_to AS enabled_to_6, t0.is_default AS is_default_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.locale AS locale_10, t0.title AS title_11, t0.meta_keywords AS meta_keywords_12, t0.meta_description AS meta_description_13, t0.id AS id_14 FROM page__site t0 WHERE t0.host IN ('www.vb.dev2.intercode.ca', 'localhost') AND t0.enabled = 1 ORDER BY t0.is_default DESC;

SELECT 
  p0_.route_name AS route_name_0, 
  p0_.page_alias AS page_alias_1, 
  p0_.type AS type_2, 
  p0_.position AS position_3, 
  p0_.enabled AS enabled_4, 
  p0_.decorate AS decorate_5, 
  p0_.name AS name_6, 
  p0_.url AS url_7, 
  p0_.parent_id AS parent_id_8, 
  p0_.target_id AS target_id_9, 
  p0_.content AS content_10, 
  p0_.publication_date_start AS publication_date_start_11, 
  p0_.publication_date_end AS publication_date_end_12, 
  p0_.created_at AS created_at_13, 
  p0_.updated_at AS updated_at_14, 
  p0_.id AS id_15, 
  p0_.site_id AS site_id_16, 
  p0_.page_id AS page_id_17 
FROM 
  page__snapshot p0_ 
WHERE 
  (
    p0_.publication_date_start <= ? 
    AND (
      p0_.publication_date_end IS NULL 
      OR p0_.publication_date_end >= ?
    )
  ) 
  AND p0_.enabled = 1 
  AND p0_.site_id = ? 
  AND p0_.route_name = ? 
LIMIT 
  1

SELECT p0_.route_name AS route_name_0, p0_.page_alias AS page_alias_1, p0_.type AS type_2, p0_.position AS position_3, p0_.enabled AS enabled_4, p0_.decorate AS decorate_5, p0_.name AS name_6, p0_.url AS url_7, p0_.parent_id AS parent_id_8, p0_.target_id AS target_id_9, p0_.content AS content_10, p0_.publication_date_start AS publication_date_start_11, p0_.publication_date_end AS publication_date_end_12, p0_.created_at AS created_at_13, p0_.updated_at AS updated_at_14, p0_.id AS id_15, p0_.site_id AS site_id_16, p0_.page_id AS page_id_17 FROM page__snapshot p0_ WHERE (p0_.publication_date_start <= '2026-04-03 12:12:12' AND (p0_.publication_date_end IS NULL OR p0_.publication_date_end >= '2026-04-03 12:12:12')) AND p0_.enabled = 1 AND p0_.site_id = 1 AND p0_.route_name = '_page_internal_global' LIMIT 1;

SELECT 
  p0_.id AS id_0, 
  p0_.translateId AS translateId_1, 
  p0_.pageId AS pageId_2, 
  p0_.siteId AS siteId_3 
FROM 
  page_translate p0_ 
WHERE 
  p0_.pageId = ?

SELECT p0_.id AS id_0, p0_.translateId AS translateId_1, p0_.pageId AS pageId_2, p0_.siteId AS siteId_3 FROM page_translate p0_ WHERE p0_.pageId = 79;

SELECT 
  p0_.route_name AS route_name_0, 
  p0_.page_alias AS page_alias_1, 
  p0_.type AS type_2, 
  p0_.position AS position_3, 
  p0_.enabled AS enabled_4, 
  p0_.decorate AS decorate_5, 
  p0_.edited AS edited_6, 
  p0_.name AS name_7, 
  p0_.slug AS slug_8, 
  p0_.url AS url_9, 
  p0_.custom_url AS custom_url_10, 
  p0_.request_method AS request_method_11, 
  p0_.title AS title_12, 
  p0_.meta_keyword AS meta_keyword_13, 
  p0_.meta_description AS meta_description_14, 
  p0_.javascript AS javascript_15, 
  p0_.stylesheet AS stylesheet_16, 
  p0_.raw_headers AS raw_headers_17, 
  p0_.template AS template_18, 
  p0_.created_at AS created_at_19, 
  p0_.updated_at AS updated_at_20, 
  p0_.id AS id_21, 
  p0_.site_id AS site_id_22, 
  p0_.parent_id AS parent_id_23, 
  p0_.target_id AS target_id_24 
FROM 
  page__page p0_ 
WHERE 
  p0_.id = ? 
  AND p0_.enabled = 1

SELECT p0_.route_name AS route_name_0, p0_.page_alias AS page_alias_1, p0_.type AS type_2, p0_.position AS position_3, p0_.enabled AS enabled_4, p0_.decorate AS decorate_5, p0_.edited AS edited_6, p0_.name AS name_7, p0_.slug AS slug_8, p0_.url AS url_9, p0_.custom_url AS custom_url_10, p0_.request_method AS request_method_11, p0_.title AS title_12, p0_.meta_keyword AS meta_keyword_13, p0_.meta_description AS meta_description_14, p0_.javascript AS javascript_15, p0_.stylesheet AS stylesheet_16, p0_.raw_headers AS raw_headers_17, p0_.template AS template_18, p0_.created_at AS created_at_19, p0_.updated_at AS updated_at_20, p0_.id AS id_21, p0_.site_id AS site_id_22, p0_.parent_id AS parent_id_23, p0_.target_id AS target_id_24 FROM page__page p0_ WHERE p0_.id = '84' AND p0_.enabled = 1;

SELECT 
  a0_.id AS id_0, 
  a0_.locale AS locale_1, 
  a0_.message AS message_2, 
  a0_.enabled AS enabled_3, 
  a0_.start_date AS start_date_4, 
  a0_.end_date AS end_date_5, 
  a0_.createdDate AS createdDate_6, 
  a0_.modifiedDate AS modifiedDate_7 
FROM 
  alert_banner a0_ 
WHERE 
  a0_.locale = ? 
  AND a0_.enabled = 1 
  AND a0_.start_date <= ? 
  AND a0_.end_date >= ?

SELECT a0_.id AS id_0, a0_.locale AS locale_1, a0_.message AS message_2, a0_.enabled AS enabled_3, a0_.start_date AS start_date_4, a0_.end_date AS end_date_5, a0_.createdDate AS createdDate_6, a0_.modifiedDate AS modifiedDate_7 FROM alert_banner a0_ WHERE a0_.locale = 'fr' AND a0_.enabled = 1 AND a0_.start_date <= '2026-04-03 12:12:12' AND a0_.end_date >= '2026-04-03 12:12:12';

SELECT 
  t0.enabled AS enabled_1, 
  t0.name AS name_2, 
  t0.relative_path AS relative_path_3, 
  t0.host AS host_4, 
  t0.enabled_from AS enabled_from_5, 
  t0.enabled_to AS enabled_to_6, 
  t0.is_default AS is_default_7, 
  t0.created_at AS created_at_8, 
  t0.updated_at AS updated_at_9, 
  t0.locale AS locale_10, 
  t0.title AS title_11, 
  t0.meta_keywords AS meta_keywords_12, 
  t0.meta_description AS meta_description_13, 
  t0.id AS id_14 
FROM 
  page__site t0 
WHERE 
  t0.enabled = ?

SELECT t0.enabled AS enabled_1, t0.name AS name_2, t0.relative_path AS relative_path_3, t0.host AS host_4, t0.enabled_from AS enabled_from_5, t0.enabled_to AS enabled_to_6, t0.is_default AS is_default_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.locale AS locale_10, t0.title AS title_11, t0.meta_keywords AS meta_keywords_12, t0.meta_description AS meta_description_13, t0.id AS id_14 FROM page__site t0 WHERE t0.enabled = 1;

SELECT 
  COUNT(w0_.id) AS sclr_0 
FROM 
  wicrew_cruise w0_ 
WHERE 
  w0_.locale = ? 
  AND w0_.active = ? 
  AND w0_.departure_date >= ? 
  AND (
    w0_.published_from IS NULL 
    OR w0_.published_from <= ?
  ) 
  AND (
    w0_.published_to IS NULL 
    OR w0_.published_to >= ?
  )

SELECT COUNT(w0_.id) AS sclr_0 FROM wicrew_cruise w0_ WHERE w0_.locale = 'fr' AND w0_.active = 1 AND w0_.departure_date >= '2026-04-03' AND (w0_.published_from IS NULL OR w0_.published_from <= '2026-04-03') AND (w0_.published_to IS NULL OR w0_.published_to >= '2026-04-03');