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 ('suus-backend.dev5.pl', '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_.content AS content_9,
  p0_.publication_date_start AS publication_date_start_10,
  p0_.publication_date_end AS publication_date_end_11,
  p0_.created_at AS created_at_12,
  p0_.updated_at AS updated_at_13,
  p0_.id AS id_14,
  p0_.site_id AS site_id_15,
  p0_.page_id AS page_id_16
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_.content AS content_9, p0_.publication_date_start AS publication_date_start_10, p0_.publication_date_end AS publication_date_end_11, p0_.created_at AS created_at_12, p0_.updated_at AS updated_at_13, p0_.id AS id_14, p0_.site_id AS site_id_15, p0_.page_id AS page_id_16 FROM page__snapshot p0_ WHERE (p0_.publication_date_start <= '2025-04-16 11:08:36' AND (p0_.publication_date_end IS NULL OR p0_.publication_date_end >= '2025-04-16 11:08:36')) AND p0_.enabled = 1 AND p0_.site_id = 9 AND p0_.url = '/api/get-blog-posts' 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_.content AS content_9,
  p0_.publication_date_start AS publication_date_start_10,
  p0_.publication_date_end AS publication_date_end_11,
  p0_.created_at AS created_at_12,
  p0_.updated_at AS updated_at_13,
  p0_.id AS id_14,
  p0_.site_id AS site_id_15,
  p0_.page_id AS page_id_16
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_.content AS content_9, p0_.publication_date_start AS publication_date_start_10, p0_.publication_date_end AS publication_date_end_11, p0_.created_at AS created_at_12, p0_.updated_at AS updated_at_13, p0_.id AS id_14, p0_.site_id AS site_id_15, p0_.page_id AS page_id_16 FROM page__snapshot p0_ WHERE (p0_.publication_date_start <= '2025-04-16 11:08:36' AND (p0_.publication_date_end IS NULL OR p0_.publication_date_end >= '2025-04-16 11:08:36')) AND p0_.enabled = 1 AND p0_.site_id = 9 AND p0_.url = '/api/get-blog-posts' 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_.content AS content_9,
  p0_.publication_date_start AS publication_date_start_10,
  p0_.publication_date_end AS publication_date_end_11,
  p0_.created_at AS created_at_12,
  p0_.updated_at AS updated_at_13,
  p0_.id AS id_14,
  p0_.site_id AS site_id_15,
  p0_.page_id AS page_id_16
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_.content AS content_9, p0_.publication_date_start AS publication_date_start_10, p0_.publication_date_end AS publication_date_end_11, p0_.created_at AS created_at_12, p0_.updated_at AS updated_at_13, p0_.id AS id_14, p0_.site_id AS site_id_15, p0_.page_id AS page_id_16 FROM page__snapshot p0_ WHERE (p0_.publication_date_start <= '2025-04-16 11:08:36' AND (p0_.publication_date_end IS NULL OR p0_.publication_date_end >= '2025-04-16 11:08:36')) AND p0_.enabled = 1 AND p0_.site_id = 9 AND p0_.route_name = 'api-get-blog-posts' 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.enabled = ?
  AND t0.id = ?
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.enabled = 1 AND t0.id = '1' LIMIT 1;

SELECT
  p0_.page_id AS sclr_0,
  p0_.name AS name_1,
  p0_.url AS url_2,
  p0_.content AS content_3,
  p0_.position AS position_4
FROM
  page__snapshot p0_
WHERE
  (
    p0_.route_name = 'page_slug'
    AND p0_.enabled = 1
    AND p0_.site_id = ?
    AND p0_.parent_id = ?
  )
  AND p0_.publication_date_end IS NULL

SELECT p0_.page_id AS sclr_0, p0_.name AS name_1, p0_.url AS url_2, p0_.content AS content_3, p0_.position AS position_4 FROM page__snapshot p0_ WHERE (p0_.route_name = 'page_slug' AND p0_.enabled = 1 AND p0_.site_id = '1' AND p0_.parent_id = '24') AND p0_.publication_date_end IS NULL;