Symfony Profiler

SELECT
  r0_.webspace AS webspace_0,
  r0_.locale AS locale_1,
  r0_.slug AS slug_2,
  r0_.resource_key AS resource_key_3,
  r0_.resource_id AS resource_id_4,
  r0_.id AS id_5,
  r0_.parent_id AS parent_id_6
FROM
  ro_routes r0_
WHERE
  (
    (
      r0_.webspace = ?
      OR r0_.webspace IS NULL
    )
  )
  AND r0_.locale = ?
  AND r0_.slug = ?
ORDER BY
  r0_.webspace DESC
LIMIT
  1

SELECT r0_.webspace AS webspace_0, r0_.locale AS locale_1, r0_.slug AS slug_2, r0_.resource_key AS resource_key_3, r0_.resource_id AS resource_id_4, r0_.id AS id_5, r0_.parent_id AS parent_id_6 FROM ro_routes r0_ WHERE ((r0_.webspace = 'website' OR r0_.webspace IS NULL)) AND r0_.locale = 'en' AND r0_.slug = '/' ORDER BY r0_.webspace DESC LIMIT 1;

SELECT
  p0_.webspaceKey AS webspaceKey_0,
  p0_.lft AS lft_1,
  p0_.rgt AS rgt_2,
  p0_.depth AS depth_3,
  p0_.uuid AS uuid_4,
  p0_.created AS created_5,
  p0_.changed AS changed_6,
  p1_.title AS title_7,
  p1_.id AS id_8,
  p1_.stage AS stage_9,
  p1_.locale AS locale_10,
  p1_.ghostLocale AS ghostLocale_11,
  p1_.availableLocales AS availableLocales_12,
  p1_.version AS version_13,
  p1_.shadowLocale AS shadowLocale_14,
  p1_.shadowLocales AS shadowLocales_15,
  p1_.templateKey AS templateKey_16,
  p1_.templateData AS templateData_17,
  p1_.seoData AS seoData_18,
  p1_.seoNoIndex AS seoNoIndex_19,
  p1_.seoNoFollow AS seoNoFollow_20,
  p1_.seoHideInSitemap AS seoHideInSitemap_21,
  p1_.excerptData AS excerptData_22,
  p1_.excerptSegment AS excerptSegment_23,
  p1_.authored AS authored_24,
  p1_.lastModified AS lastModified_25,
  p1_.workflowPlace AS workflowPlace_26,
  p1_.workflowPublished AS workflowPublished_27,
  p1_.linkProvider AS linkProvider_28,
  p1_.linkData AS linkData_29,
  p1_.created AS created_30,
  p1_.changed AS changed_31,
  t2_.name AS name_32,
  t2_.id AS id_33,
  t2_.created AS created_34,
  t2_.changed AS changed_35,
  c3_.category_key AS category_key_36,
  c3_.default_locale AS default_locale_37,
  c3_.lft AS lft_38,
  c3_.rgt AS rgt_39,
  c3_.depth AS depth_40,
  c3_.id AS id_41,
  c3_.created AS created_42,
  c3_.changed AS changed_43,
  c4_.translation AS translation_44,
  c4_.locale AS locale_45,
  c4_.description AS description_46,
  c4_.id AS id_47,
  c4_.created AS created_48,
  c4_.changed AS changed_49,
  p0_.parent_id AS parent_id_50,
  p0_.idUsersCreator AS idUsersCreator_51,
  p0_.idUsersChanger AS idUsersChanger_52,
  p1_.route_id AS route_id_53,
  p1_.pageUuid AS pageUuid_54,
  p1_.author_id AS author_id_55,
  p1_.idUsersCreator AS idUsersCreator_56,
  p1_.idUsersChanger AS idUsersChanger_57,
  t2_.idUsersCreator AS idUsersCreator_58,
  t2_.idUsersChanger AS idUsersChanger_59,
  c3_.idCategoriesParent AS idCategoriesParent_60,
  c3_.idUsersCreator AS idUsersCreator_61,
  c3_.idUsersChanger AS idUsersChanger_62,
  c4_.idCategories AS idCategories_63,
  c4_.idUsersCreator AS idUsersCreator_64,
  c4_.idUsersChanger AS idUsersChanger_65
FROM
  pa_pages p0_
  LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid
  AND (
    p1_.stage = ?
    AND p1_.version = ?
    AND (
      p1_.locale IS NULL
      OR p1_.locale = ?
    )
  )
  LEFT JOIN pa_page_dimension_content_excerpt_tags p5_ ON p1_.id = p5_.page_dimension_content_id
  LEFT JOIN ta_tags t2_ ON t2_.id = p5_.tag_id
  LEFT JOIN pa_page_dimension_content_excerpt_categories p6_ ON p1_.id = p6_.page_dimension_content_id
  LEFT JOIN ca_categories c3_ ON c3_.id = p6_.category_id
  LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories
WHERE
  p0_.uuid = ?

SELECT p0_.webspaceKey AS webspaceKey_0, p0_.lft AS lft_1, p0_.rgt AS rgt_2, p0_.depth AS depth_3, p0_.uuid AS uuid_4, p0_.created AS created_5, p0_.changed AS changed_6, p1_.title AS title_7, p1_.id AS id_8, p1_.stage AS stage_9, p1_.locale AS locale_10, p1_.ghostLocale AS ghostLocale_11, p1_.availableLocales AS availableLocales_12, p1_.version AS version_13, p1_.shadowLocale AS shadowLocale_14, p1_.shadowLocales AS shadowLocales_15, p1_.templateKey AS templateKey_16, p1_.templateData AS templateData_17, p1_.seoData AS seoData_18, p1_.seoNoIndex AS seoNoIndex_19, p1_.seoNoFollow AS seoNoFollow_20, p1_.seoHideInSitemap AS seoHideInSitemap_21, p1_.excerptData AS excerptData_22, p1_.excerptSegment AS excerptSegment_23, p1_.authored AS authored_24, p1_.lastModified AS lastModified_25, p1_.workflowPlace AS workflowPlace_26, p1_.workflowPublished AS workflowPublished_27, p1_.linkProvider AS linkProvider_28, p1_.linkData AS linkData_29, p1_.created AS created_30, p1_.changed AS changed_31, t2_.name AS name_32, t2_.id AS id_33, t2_.created AS created_34, t2_.changed AS changed_35, c3_.category_key AS category_key_36, c3_.default_locale AS default_locale_37, c3_.lft AS lft_38, c3_.rgt AS rgt_39, c3_.depth AS depth_40, c3_.id AS id_41, c3_.created AS created_42, c3_.changed AS changed_43, c4_.translation AS translation_44, c4_.locale AS locale_45, c4_.description AS description_46, c4_.id AS id_47, c4_.created AS created_48, c4_.changed AS changed_49, p0_.parent_id AS parent_id_50, p0_.idUsersCreator AS idUsersCreator_51, p0_.idUsersChanger AS idUsersChanger_52, p1_.route_id AS route_id_53, p1_.pageUuid AS pageUuid_54, p1_.author_id AS author_id_55, p1_.idUsersCreator AS idUsersCreator_56, p1_.idUsersChanger AS idUsersChanger_57, t2_.idUsersCreator AS idUsersCreator_58, t2_.idUsersChanger AS idUsersChanger_59, c3_.idCategoriesParent AS idCategoriesParent_60, c3_.idUsersCreator AS idUsersCreator_61, c3_.idUsersChanger AS idUsersChanger_62, c4_.idCategories AS idCategories_63, c4_.idUsersCreator AS idUsersCreator_64, c4_.idUsersChanger AS idUsersChanger_65 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid AND (p1_.stage = 'live' AND p1_.version = 0 AND (p1_.locale IS NULL OR p1_.locale = 'en')) LEFT JOIN pa_page_dimension_content_excerpt_tags p5_ ON p1_.id = p5_.page_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = p5_.tag_id LEFT JOIN pa_page_dimension_content_excerpt_categories p6_ ON p1_.id = p6_.page_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = p6_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories WHERE p0_.uuid = '019c04f5-eb3f-763e-8192-97bfca2d5563';

SELECT
  t0.name AS name_1,
  t0.id AS id_2,
  t0.page_dimension_content_id AS page_dimension_content_id_3
FROM
  pa_page_dimension_content_navigation_contexts t0
WHERE
  t0.page_dimension_content_id = ?

SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = 5;

SELECT
  t0.name AS name_1,
  t0.id AS id_2,
  t0.page_dimension_content_id AS page_dimension_content_id_3
FROM
  pa_page_dimension_content_navigation_contexts t0
WHERE
  t0.page_dimension_content_id = ?

SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = 6;

SELECT
  r0_.webspace AS webspace_0,
  r0_.locale AS locale_1,
  r0_.slug AS slug_2,
  r0_.resource_key AS resource_key_3,
  r0_.resource_id AS resource_id_4,
  r0_.id AS id_5,
  r0_.parent_id AS parent_id_6
FROM
  ro_routes r0_
WHERE
  r0_.locale IN (?)
  AND r0_.resource_key = ?
  AND r0_.resource_id = ?

SELECT r0_.webspace AS webspace_0, r0_.locale AS locale_1, r0_.slug AS slug_2, r0_.resource_key AS resource_key_3, r0_.resource_id AS resource_id_4, r0_.id AS id_5, r0_.parent_id AS parent_id_6 FROM ro_routes r0_ WHERE r0_.locale IN ('en') AND r0_.resource_key = 'pages' AND r0_.resource_id = '019c04f5-eb3f-763e-8192-97bfca2d5563';