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 ASC
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 = 'pl' AND r0_.slug = '/kursy/ice-diver' ORDER BY r0_.webspace ASC 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
  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
  AND (
    c4_.locale = c3_.default_locale
    OR c4_.locale IN (?)
  )
WHERE
  p0_.uuid = ?
  AND (
    (
      (
        p1_.locale IS NULL
        OR p1_.locale IN (?)
      )
      AND (
        p1_.stage IS NULL
        OR p1_.stage IN (?)
      )
    )
    AND (
      p1_.version IS NULL
      OR p1_.version IN (?)
    )
  )

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 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 AND (c4_.locale = c3_.default_locale OR c4_.locale IN ('pl')) WHERE p0_.uuid = '019dcb6d-45cc-77da-878e-32540dd64f24' AND (((p1_.locale IS NULL OR p1_.locale IN ('pl')) AND (p1_.stage IS NULL OR p1_.stage IN ('live'))) AND (p1_.version IS NULL OR p1_.version IN (0)));

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 = 116;

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 = 117;

SELECT
  m0_.type AS type_0,
  m0_.id AS id_1,
  m0_.created AS created_2,
  m0_.changed AS changed_3,
  m1_.style AS style_4,
  m1_.lft AS lft_5,
  m1_.rgt AS rgt_6,
  m1_.depth AS depth_7,
  m1_.collection_key AS collection_key_8,
  m1_.id AS id_9,
  m1_.created AS created_10,
  m1_.changed AS changed_11,
  m2_.version AS version_12,
  m2_.id AS id_13,
  m2_.created AS created_14,
  m2_.changed AS changed_15,
  m3_.name AS name_16,
  m3_.version AS version_17,
  m3_.subVersion AS subversion_18,
  m3_.size AS size_19,
  m3_.downloadCounter AS downloadcounter_20,
  m3_.storageOptions AS storageoptions_21,
  m3_.mimeType AS mimetype_22,
  m3_.properties AS properties_23,
  m3_.focusPointX AS focuspointx_24,
  m3_.focusPointY AS focuspointy_25,
  m3_.id AS id_26,
  m3_.created AS created_27,
  m3_.changed AS changed_28,
  t4_.name AS name_29,
  t4_.id AS id_30,
  t4_.created AS created_31,
  t4_.changed AS changed_32,
  m5_.title AS title_33,
  m5_.description AS description_34,
  m5_.copyright AS copyright_35,
  m5_.credits AS credits_36,
  m5_.locale AS locale_37,
  m5_.id AS id_38,
  m6_.title AS title_39,
  m6_.description AS description_40,
  m6_.copyright AS copyright_41,
  m6_.credits AS credits_42,
  m6_.locale AS locale_43,
  m6_.id AS id_44,
  s7_.username AS username_45,
  s7_.password AS password_46,
  s7_.locale AS locale_47,
  s7_.salt AS salt_48,
  s7_.locked AS locked_49,
  s7_.enabled AS enabled_50,
  s7_.lastLogin AS lastlogin_51,
  s7_.confirmationKey AS confirmationkey_52,
  s7_.passwordResetToken AS passwordresettoken_53,
  s7_.passwordResetTokenExpiresAt AS passwordresettokenexpiresat_54,
  s7_.passwordResetTokenEmailsSent AS passwordresettokenemailssent_55,
  s7_.privateKey AS privatekey_56,
  s7_.apiKey AS apikey_57,
  s7_.email AS email_58,
  s7_.id AS id_59,
  s7_.created AS created_60,
  s7_.changed AS changed_61,
  c8_.firstName AS firstname_62,
  c8_.middleName AS middlename_63,
  c8_.lastName AS lastname_64,
  c8_.birthday AS birthday_65,
  c8_.salutation AS salutation_66,
  c8_.formOfAddress AS formofaddress_67,
  c8_.newsletter AS newsletter_68,
  c8_.gender AS gender_69,
  c8_.note AS note_70,
  c8_.mainEmail AS mainemail_71,
  c8_.mainPhone AS mainphone_72,
  c8_.mainFax AS mainfax_73,
  c8_.mainUrl AS mainurl_74,
  c8_.id AS id_75,
  c8_.created AS created_76,
  c8_.changed AS changed_77,
  s9_.username AS username_78,
  s9_.password AS password_79,
  s9_.locale AS locale_80,
  s9_.salt AS salt_81,
  s9_.locked AS locked_82,
  s9_.enabled AS enabled_83,
  s9_.lastLogin AS lastlogin_84,
  s9_.confirmationKey AS confirmationkey_85,
  s9_.passwordResetToken AS passwordresettoken_86,
  s9_.passwordResetTokenExpiresAt AS passwordresettokenexpiresat_87,
  s9_.passwordResetTokenEmailsSent AS passwordresettokenemailssent_88,
  s9_.privateKey AS privatekey_89,
  s9_.apiKey AS apikey_90,
  s9_.email AS email_91,
  s9_.id AS id_92,
  s9_.created AS created_93,
  s9_.changed AS changed_94,
  c10_.firstName AS firstname_95,
  c10_.middleName AS middlename_96,
  c10_.lastName AS lastname_97,
  c10_.birthday AS birthday_98,
  c10_.salutation AS salutation_99,
  c10_.formOfAddress AS formofaddress_100,
  c10_.newsletter AS newsletter_101,
  c10_.gender AS gender_102,
  c10_.note AS note_103,
  c10_.mainEmail AS mainemail_104,
  c10_.mainPhone AS mainphone_105,
  c10_.mainFax AS mainfax_106,
  c10_.mainUrl AS mainurl_107,
  c10_.id AS id_108,
  c10_.created AS created_109,
  c10_.changed AS changed_110,
  m0_.idPreviewImage AS idpreviewimage_111,
  m0_.idCollections AS idcollections_112,
  m0_.idUsersCreator AS iduserscreator_113,
  m0_.idUsersChanger AS iduserschanger_114,
  m1_.idCollectionsMetaDefault AS idcollectionsmetadefault_115,
  m1_.idCollectionTypes AS idcollectiontypes_116,
  m1_.idCollectionsParent AS idcollectionsparent_117,
  m1_.idUsersCreator AS iduserscreator_118,
  m1_.idUsersChanger AS iduserschanger_119,
  m2_.idMedia AS idmedia_120,
  m2_.idUsersCreator AS iduserscreator_121,
  m2_.idUsersChanger AS iduserschanger_122,
  m3_.idFileVersionsMetaDefault AS idfileversionsmetadefault_123,
  m3_.idFiles AS idfiles_124,
  m3_.idUsersCreator AS iduserscreator_125,
  m3_.idUsersChanger AS iduserschanger_126,
  t4_.idUsersCreator AS iduserscreator_127,
  t4_.idUsersChanger AS iduserschanger_128,
  m5_.idFileVersions AS idfileversions_129,
  m6_.idFileVersions AS idfileversions_130,
  s7_.idContacts AS idcontacts_131,
  s7_.idUsersCreator AS iduserscreator_132,
  s7_.idUsersChanger AS iduserschanger_133,
  c8_.idTitles AS idtitles_134,
  c8_.avatar AS avatar_135,
  c8_.idUsersCreator AS iduserscreator_136,
  c8_.idUsersChanger AS iduserschanger_137,
  s9_.idContacts AS idcontacts_138,
  s9_.idUsersCreator AS iduserscreator_139,
  s9_.idUsersChanger AS iduserschanger_140,
  c10_.idTitles AS idtitles_141,
  c10_.avatar AS avatar_142,
  c10_.idUsersCreator AS iduserscreator_143,
  c10_.idUsersChanger AS iduserschanger_144
FROM
  me_media m0_
  LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id
  INNER JOIN me_files m2_ ON m0_.id = m2_.idMedia
  INNER JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles
  AND (m3_.version = m2_.version)
  LEFT JOIN me_file_version_tags m11_ ON m3_.id = m11_.idFileVersions
  LEFT JOIN ta_tags t4_ ON t4_.id = m11_.idTags
  LEFT JOIN me_file_version_meta m5_ ON m3_.id = m5_.idFileVersions
  LEFT JOIN me_file_version_meta m6_ ON m3_.idFileVersionsMetaDefault = m6_.id
  LEFT JOIN se_users s7_ ON m0_.idUsersCreator = s7_.id
  LEFT JOIN co_contacts c8_ ON s7_.idContacts = c8_.id
  LEFT JOIN se_users s9_ ON m0_.idUsersChanger = s9_.id
  LEFT JOIN co_contacts c10_ ON s9_.idContacts = c10_.id
WHERE
  m0_.id IN (?, ?, ?)
ORDER BY
  m0_.id ASC

SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.style AS style_4, m1_.lft AS lft_5, m1_.rgt AS rgt_6, m1_.depth AS depth_7, m1_.collection_key AS collection_key_8, m1_.id AS id_9, m1_.created AS created_10, m1_.changed AS changed_11, m2_.version AS version_12, m2_.id AS id_13, m2_.created AS created_14, m2_.changed AS changed_15, m3_.name AS name_16, m3_.version AS version_17, m3_.subVersion AS subversion_18, m3_.size AS size_19, m3_.downloadCounter AS downloadcounter_20, m3_.storageOptions AS storageoptions_21, m3_.mimeType AS mimetype_22, m3_.properties AS properties_23, m3_.focusPointX AS focuspointx_24, m3_.focusPointY AS focuspointy_25, m3_.id AS id_26, m3_.created AS created_27, m3_.changed AS changed_28, t4_.name AS name_29, t4_.id AS id_30, t4_.created AS created_31, t4_.changed AS changed_32, m5_.title AS title_33, m5_.description AS description_34, m5_.copyright AS copyright_35, m5_.credits AS credits_36, m5_.locale AS locale_37, m5_.id AS id_38, m6_.title AS title_39, m6_.description AS description_40, m6_.copyright AS copyright_41, m6_.credits AS credits_42, m6_.locale AS locale_43, m6_.id AS id_44, s7_.username AS username_45, s7_.password AS password_46, s7_.locale AS locale_47, s7_.salt AS salt_48, s7_.locked AS locked_49, s7_.enabled AS enabled_50, s7_.lastLogin AS lastlogin_51, s7_.confirmationKey AS confirmationkey_52, s7_.passwordResetToken AS passwordresettoken_53, s7_.passwordResetTokenExpiresAt AS passwordresettokenexpiresat_54, s7_.passwordResetTokenEmailsSent AS passwordresettokenemailssent_55, s7_.privateKey AS privatekey_56, s7_.apiKey AS apikey_57, s7_.email AS email_58, s7_.id AS id_59, s7_.created AS created_60, s7_.changed AS changed_61, c8_.firstName AS firstname_62, c8_.middleName AS middlename_63, c8_.lastName AS lastname_64, c8_.birthday AS birthday_65, c8_.salutation AS salutation_66, c8_.formOfAddress AS formofaddress_67, c8_.newsletter AS newsletter_68, c8_.gender AS gender_69, c8_.note AS note_70, c8_.mainEmail AS mainemail_71, c8_.mainPhone AS mainphone_72, c8_.mainFax AS mainfax_73, c8_.mainUrl AS mainurl_74, c8_.id AS id_75, c8_.created AS created_76, c8_.changed AS changed_77, s9_.username AS username_78, s9_.password AS password_79, s9_.locale AS locale_80, s9_.salt AS salt_81, s9_.locked AS locked_82, s9_.enabled AS enabled_83, s9_.lastLogin AS lastlogin_84, s9_.confirmationKey AS confirmationkey_85, s9_.passwordResetToken AS passwordresettoken_86, s9_.passwordResetTokenExpiresAt AS passwordresettokenexpiresat_87, s9_.passwordResetTokenEmailsSent AS passwordresettokenemailssent_88, s9_.privateKey AS privatekey_89, s9_.apiKey AS apikey_90, s9_.email AS email_91, s9_.id AS id_92, s9_.created AS created_93, s9_.changed AS changed_94, c10_.firstName AS firstname_95, c10_.middleName AS middlename_96, c10_.lastName AS lastname_97, c10_.birthday AS birthday_98, c10_.salutation AS salutation_99, c10_.formOfAddress AS formofaddress_100, c10_.newsletter AS newsletter_101, c10_.gender AS gender_102, c10_.note AS note_103, c10_.mainEmail AS mainemail_104, c10_.mainPhone AS mainphone_105, c10_.mainFax AS mainfax_106, c10_.mainUrl AS mainurl_107, c10_.id AS id_108, c10_.created AS created_109, c10_.changed AS changed_110, m0_.idPreviewImage AS idpreviewimage_111, m0_.idCollections AS idcollections_112, m0_.idUsersCreator AS iduserscreator_113, m0_.idUsersChanger AS iduserschanger_114, m1_.idCollectionsMetaDefault AS idcollectionsmetadefault_115, m1_.idCollectionTypes AS idcollectiontypes_116, m1_.idCollectionsParent AS idcollectionsparent_117, m1_.idUsersCreator AS iduserscreator_118, m1_.idUsersChanger AS iduserschanger_119, m2_.idMedia AS idmedia_120, m2_.idUsersCreator AS iduserscreator_121, m2_.idUsersChanger AS iduserschanger_122, m3_.idFileVersionsMetaDefault AS idfileversionsmetadefault_123, m3_.idFiles AS idfiles_124, m3_.idUsersCreator AS iduserscreator_125, m3_.idUsersChanger AS iduserschanger_126, t4_.idUsersCreator AS iduserscreator_127, t4_.idUsersChanger AS iduserschanger_128, m5_.idFileVersions AS idfileversions_129, m6_.idFileVersions AS idfileversions_130, s7_.idContacts AS idcontacts_131, s7_.idUsersCreator AS iduserscreator_132, s7_.idUsersChanger AS iduserschanger_133, c8_.idTitles AS idtitles_134, c8_.avatar AS avatar_135, c8_.idUsersCreator AS iduserscreator_136, c8_.idUsersChanger AS iduserschanger_137, s9_.idContacts AS idcontacts_138, s9_.idUsersCreator AS iduserscreator_139, s9_.idUsersChanger AS iduserschanger_140, c10_.idTitles AS idtitles_141, c10_.avatar AS avatar_142, c10_.idUsersCreator AS iduserscreator_143, c10_.idUsersChanger AS iduserschanger_144 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id INNER JOIN me_files m2_ ON m0_.id = m2_.idMedia INNER JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles AND (m3_.version = m2_.version) LEFT JOIN me_file_version_tags m11_ ON m3_.id = m11_.idFileVersions LEFT JOIN ta_tags t4_ ON t4_.id = m11_.idTags LEFT JOIN me_file_version_meta m5_ ON m3_.id = m5_.idFileVersions LEFT JOIN me_file_version_meta m6_ ON m3_.idFileVersionsMetaDefault = m6_.id LEFT JOIN se_users s7_ ON m0_.idUsersCreator = s7_.id LEFT JOIN co_contacts c8_ ON s7_.idContacts = c8_.id LEFT JOIN se_users s9_ ON m0_.idUsersChanger = s9_.id LEFT JOIN co_contacts c10_ ON s9_.idContacts = c10_.id WHERE m0_.id IN (81, 82, 83) ORDER BY m0_.id ASC;

SELECT
  t0.method AS method_1,
  t0.options AS options_2,
  t0.id AS id_3,
  t0.idUsers AS idusers_4
FROM
  se_user_two_factors t0
WHERE
  t0.idUsers = ?

SELECT t0.method AS method_1, t0.options AS options_2, t0.id AS id_3, t0.idUsers AS idusers_4 FROM se_user_two_factors t0 WHERE t0.idUsers = 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_.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 ('pl') AND r0_.resource_key = 'pages' AND r0_.resource_id = '019dcb6d-45cc-77da-878e-32540dd64f24';

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,
  r5_.webspace AS webspace_50,
  r5_.locale AS locale_51,
  r5_.slug AS slug_52,
  r5_.resource_key AS resource_key_53,
  r5_.resource_id AS resource_id_54,
  r5_.id AS id_55,
  p6_.name AS name_56,
  p6_.id AS id_57,
  p0_.parent_id AS parent_id_58,
  p0_.idUsersCreator AS iduserscreator_59,
  p0_.idUsersChanger AS iduserschanger_60,
  p1_.route_id AS route_id_61,
  p1_.pageUuid AS pageuuid_62,
  p1_.author_id AS author_id_63,
  p1_.idUsersCreator AS iduserscreator_64,
  p1_.idUsersChanger AS iduserschanger_65,
  t2_.idUsersCreator AS iduserscreator_66,
  t2_.idUsersChanger AS iduserschanger_67,
  c3_.idCategoriesParent AS idcategoriesparent_68,
  c3_.idUsersCreator AS iduserscreator_69,
  c3_.idUsersChanger AS iduserschanger_70,
  c4_.idCategories AS idcategories_71,
  c4_.idUsersCreator AS iduserscreator_72,
  c4_.idUsersChanger AS iduserschanger_73,
  r5_.parent_id AS parent_id_74,
  p6_.page_dimension_content_id AS page_dimension_content_id_75
FROM
  pa_pages p0_
  LEFT JOIN pa_page_dimension_contents p7_ ON (p7_.pageUuid = p0_.uuid)
  LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid
  LEFT JOIN pa_page_dimension_content_excerpt_tags p8_ ON p1_.id = p8_.page_dimension_content_id
  LEFT JOIN ta_tags t2_ ON t2_.id = p8_.tag_id
  LEFT JOIN pa_page_dimension_content_excerpt_categories p9_ ON p1_.id = p9_.page_dimension_content_id
  LEFT JOIN ca_categories c3_ ON c3_.id = p9_.category_id
  LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories
  AND (
    c4_.locale = c3_.default_locale
    OR c4_.locale IN (?)
  )
  LEFT JOIN ro_routes r5_ ON p1_.route_id = r5_.id
  LEFT JOIN pa_page_dimension_content_navigation_contexts p6_ ON p1_.id = p6_.page_dimension_content_id
  LEFT JOIN pa_page_dimension_content_navigation_contexts p10_ ON p7_.id = p10_.page_dimension_content_id
WHERE
  p0_.webspaceKey = ?
  AND p0_.depth <= ?
  AND p7_.locale = ?
  AND p7_.stage = ?
  AND p7_.version = ?
  AND (
    (
      (
        p1_.locale IS NULL
        OR p1_.locale IN (?)
      )
      AND (
        p1_.stage IS NULL
        OR p1_.stage IN (?)
      )
    )
    AND (
      p1_.version IS NULL
      OR p1_.version IN (?)
    )
  )
  AND p10_.name IN (?)
ORDER BY
  p0_.lft ASC