| 1 |
0.76 ms |
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
Parameters: [
"website"
"en"
"/news/caring-for-statement-plants"
]
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 = '/news/caring-for-statement-plants' ORDER BY r0_.webspace DESC LIMIT 1;
|
| 2 |
1.00 ms |
SELECT a0_.uuid AS uuid_0, a0_.created AS created_1, a0_.changed AS changed_2, a1_.title AS title_3, a1_.customizeWebspaceSettings AS customizeWebspaceSettings_4, a1_.id AS id_5, a1_.stage AS stage_6, a1_.locale AS locale_7, a1_.ghostLocale AS ghostLocale_8, a1_.availableLocales AS availableLocales_9, a1_.version AS version_10, a1_.shadowLocale AS shadowLocale_11, a1_.shadowLocales AS shadowLocales_12, a1_.templateKey AS templateKey_13, a1_.templateData AS templateData_14, a1_.seoData AS seoData_15, a1_.seoNoIndex AS seoNoIndex_16, a1_.seoNoFollow AS seoNoFollow_17, a1_.seoHideInSitemap AS seoHideInSitemap_18, a1_.excerptData AS excerptData_19, a1_.excerptSegment AS excerptSegment_20, a1_.mainWebspace AS mainWebspace_21, a1_.authored AS authored_22, a1_.lastModified AS lastModified_23, a1_.workflowPlace AS workflowPlace_24, a1_.workflowPublished AS workflowPublished_25, a1_.created AS created_26, a1_.changed AS changed_27, t2_.name AS name_28, t2_.id AS id_29, t2_.created AS created_30, t2_.changed AS changed_31, c3_.category_key AS category_key_32, c3_.default_locale AS default_locale_33, c3_.lft AS lft_34, c3_.rgt AS rgt_35, c3_.depth AS depth_36, c3_.id AS id_37, c3_.created AS created_38, c3_.changed AS changed_39, c4_.translation AS translation_40, c4_.locale AS locale_41, c4_.description AS description_42, c4_.id AS id_43, c4_.created AS created_44, c4_.changed AS changed_45, a0_.idUsersCreator AS idUsersCreator_46, a0_.idUsersChanger AS idUsersChanger_47, a1_.route_id AS route_id_48, a1_.articleUuid AS articleUuid_49, a1_.author_id AS author_id_50, a1_.idUsersCreator AS idUsersCreator_51, a1_.idUsersChanger AS idUsersChanger_52, t2_.idUsersCreator AS idUsersCreator_53, t2_.idUsersChanger AS idUsersChanger_54, c3_.idCategoriesParent AS idCategoriesParent_55, c3_.idUsersCreator AS idUsersCreator_56, c3_.idUsersChanger AS idUsersChanger_57, c4_.idCategories AS idCategories_58, c4_.idUsersCreator AS idUsersCreator_59, c4_.idUsersChanger AS idUsersChanger_60 FROM ar_articles a0_ LEFT JOIN ar_article_dimension_contents a1_ ON a0_.uuid = a1_.articleUuid LEFT JOIN ar_article_dimension_content_excerpt_tags a5_ ON a1_.id = a5_.article_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = a5_.tag_id LEFT JOIN ar_article_dimension_content_excerpt_categories a6_ ON a1_.id = a6_.article_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = a6_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories AND (c4_.locale = c3_.default_locale OR c4_.locale IN (?)) WHERE a0_.uuid = ? AND (((a1_.locale IS NULL OR a1_.locale IN (?)) AND (a1_.stage IS NULL OR a1_.stage IN (?))) AND (a1_.version IS NULL OR a1_.version IN (?)))
Parameters: [
"en"
"33333333-0000-4000-8000-000000000105"
"en"
"live"
0
]
SELECT
a0_.uuid AS uuid_0,
a0_.created AS created_1,
a0_.changed AS changed_2,
a1_.title AS title_3,
a1_.customizeWebspaceSettings AS customizeWebspaceSettings_4,
a1_.id AS id_5,
a1_.stage AS stage_6,
a1_.locale AS locale_7,
a1_.ghostLocale AS ghostLocale_8,
a1_.availableLocales AS availableLocales_9,
a1_.version AS version_10,
a1_.shadowLocale AS shadowLocale_11,
a1_.shadowLocales AS shadowLocales_12,
a1_.templateKey AS templateKey_13,
a1_.templateData AS templateData_14,
a1_.seoData AS seoData_15,
a1_.seoNoIndex AS seoNoIndex_16,
a1_.seoNoFollow AS seoNoFollow_17,
a1_.seoHideInSitemap AS seoHideInSitemap_18,
a1_.excerptData AS excerptData_19,
a1_.excerptSegment AS excerptSegment_20,
a1_.mainWebspace AS mainWebspace_21,
a1_.authored AS authored_22,
a1_.lastModified AS lastModified_23,
a1_.workflowPlace AS workflowPlace_24,
a1_.workflowPublished AS workflowPublished_25,
a1_.created AS created_26,
a1_.changed AS changed_27,
t2_.name AS name_28,
t2_.id AS id_29,
t2_.created AS created_30,
t2_.changed AS changed_31,
c3_.category_key AS category_key_32,
c3_.default_locale AS default_locale_33,
c3_.lft AS lft_34,
c3_.rgt AS rgt_35,
c3_.depth AS depth_36,
c3_.id AS id_37,
c3_.created AS created_38,
c3_.changed AS changed_39,
c4_.translation AS translation_40,
c4_.locale AS locale_41,
c4_.description AS description_42,
c4_.id AS id_43,
c4_.created AS created_44,
c4_.changed AS changed_45,
a0_.idUsersCreator AS idUsersCreator_46,
a0_.idUsersChanger AS idUsersChanger_47,
a1_.route_id AS route_id_48,
a1_.articleUuid AS articleUuid_49,
a1_.author_id AS author_id_50,
a1_.idUsersCreator AS idUsersCreator_51,
a1_.idUsersChanger AS idUsersChanger_52,
t2_.idUsersCreator AS idUsersCreator_53,
t2_.idUsersChanger AS idUsersChanger_54,
c3_.idCategoriesParent AS idCategoriesParent_55,
c3_.idUsersCreator AS idUsersCreator_56,
c3_.idUsersChanger AS idUsersChanger_57,
c4_.idCategories AS idCategories_58,
c4_.idUsersCreator AS idUsersCreator_59,
c4_.idUsersChanger AS idUsersChanger_60
FROM
ar_articles a0_
LEFT JOIN ar_article_dimension_contents a1_ ON a0_.uuid = a1_.articleUuid
LEFT JOIN ar_article_dimension_content_excerpt_tags a5_ ON a1_.id = a5_.article_dimension_content_id
LEFT JOIN ta_tags t2_ ON t2_.id = a5_.tag_id
LEFT JOIN ar_article_dimension_content_excerpt_categories a6_ ON a1_.id = a6_.article_dimension_content_id
LEFT JOIN ca_categories c3_ ON c3_.id = a6_.category_id
LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories
AND (
c4_.locale = c3_.default_locale
OR c4_.locale IN (?)
)
WHERE
a0_.uuid = ?
AND (
(
(
a1_.locale IS NULL
OR a1_.locale IN (?)
)
AND (
a1_.stage IS NULL
OR a1_.stage IN (?)
)
)
AND (
a1_.version IS NULL
OR a1_.version IN (?)
)
)
SELECT a0_.uuid AS uuid_0, a0_.created AS created_1, a0_.changed AS changed_2, a1_.title AS title_3, a1_.customizeWebspaceSettings AS customizeWebspaceSettings_4, a1_.id AS id_5, a1_.stage AS stage_6, a1_.locale AS locale_7, a1_.ghostLocale AS ghostLocale_8, a1_.availableLocales AS availableLocales_9, a1_.version AS version_10, a1_.shadowLocale AS shadowLocale_11, a1_.shadowLocales AS shadowLocales_12, a1_.templateKey AS templateKey_13, a1_.templateData AS templateData_14, a1_.seoData AS seoData_15, a1_.seoNoIndex AS seoNoIndex_16, a1_.seoNoFollow AS seoNoFollow_17, a1_.seoHideInSitemap AS seoHideInSitemap_18, a1_.excerptData AS excerptData_19, a1_.excerptSegment AS excerptSegment_20, a1_.mainWebspace AS mainWebspace_21, a1_.authored AS authored_22, a1_.lastModified AS lastModified_23, a1_.workflowPlace AS workflowPlace_24, a1_.workflowPublished AS workflowPublished_25, a1_.created AS created_26, a1_.changed AS changed_27, t2_.name AS name_28, t2_.id AS id_29, t2_.created AS created_30, t2_.changed AS changed_31, c3_.category_key AS category_key_32, c3_.default_locale AS default_locale_33, c3_.lft AS lft_34, c3_.rgt AS rgt_35, c3_.depth AS depth_36, c3_.id AS id_37, c3_.created AS created_38, c3_.changed AS changed_39, c4_.translation AS translation_40, c4_.locale AS locale_41, c4_.description AS description_42, c4_.id AS id_43, c4_.created AS created_44, c4_.changed AS changed_45, a0_.idUsersCreator AS idUsersCreator_46, a0_.idUsersChanger AS idUsersChanger_47, a1_.route_id AS route_id_48, a1_.articleUuid AS articleUuid_49, a1_.author_id AS author_id_50, a1_.idUsersCreator AS idUsersCreator_51, a1_.idUsersChanger AS idUsersChanger_52, t2_.idUsersCreator AS idUsersCreator_53, t2_.idUsersChanger AS idUsersChanger_54, c3_.idCategoriesParent AS idCategoriesParent_55, c3_.idUsersCreator AS idUsersCreator_56, c3_.idUsersChanger AS idUsersChanger_57, c4_.idCategories AS idCategories_58, c4_.idUsersCreator AS idUsersCreator_59, c4_.idUsersChanger AS idUsersChanger_60 FROM ar_articles a0_ LEFT JOIN ar_article_dimension_contents a1_ ON a0_.uuid = a1_.articleUuid LEFT JOIN ar_article_dimension_content_excerpt_tags a5_ ON a1_.id = a5_.article_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = a5_.tag_id LEFT JOIN ar_article_dimension_content_excerpt_categories a6_ ON a1_.id = a6_.article_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = a6_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories AND (c4_.locale = c3_.default_locale OR c4_.locale IN ('en')) WHERE a0_.uuid = '33333333-0000-4000-8000-000000000105' AND (((a1_.locale IS NULL OR a1_.locale IN ('en')) AND (a1_.stage IS NULL OR a1_.stage IN ('live'))) AND (a1_.version IS NULL OR a1_.version IN (0)));
|
| 3 |
0.46 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.article_dimension_content_id AS article_dimension_content_id_3 FROM ar_article_dimension_content_additional_webspaces t0 WHERE t0.article_dimension_content_id = ?
SELECT t0.name AS name_1, t0.id AS id_2, t0.article_dimension_content_id AS article_dimension_content_id_3 FROM ar_article_dimension_content_additional_webspaces t0 WHERE t0.article_dimension_content_id = 40;
|
| 4 |
0.36 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.article_dimension_content_id AS article_dimension_content_id_3 FROM ar_article_dimension_content_additional_webspaces t0 WHERE t0.article_dimension_content_id = ?
SELECT t0.name AS name_1, t0.id AS id_2, t0.article_dimension_content_id AS article_dimension_content_id_3 FROM ar_article_dimension_content_additional_webspaces t0 WHERE t0.article_dimension_content_id = 41;
|
| 5 |
0.66 ms |
SELECT t0.webspace AS webspace_1, t0.locale AS locale_2, t0.slug AS slug_3, t0.resource_key AS resource_key_4, t0.resource_id AS resource_id_5, t0.id AS id_6, t0.parent_id AS parent_id_7 FROM ro_routes t0 WHERE t0.id = ?
SELECT t0.webspace AS webspace_1, t0.locale AS locale_2, t0.slug AS slug_3, t0.resource_key AS resource_key_4, t0.resource_id AS resource_id_5, t0.id AS id_6, t0.parent_id AS parent_id_7 FROM ro_routes t0 WHERE t0.id = 4;
|
| 6 |
1.01 ms |
SELECT c0_.category_key AS category_key_0, c0_.default_locale AS default_locale_1, c0_.lft AS lft_2, c0_.rgt AS rgt_3, c0_.depth AS depth_4, c0_.id AS id_5, c0_.created AS created_6, c0_.changed AS changed_7, c1_.translation AS translation_8, c1_.locale AS locale_9, c1_.description AS description_10, c1_.id AS id_11, c1_.created AS created_12, c1_.changed AS changed_13, c2_.locale AS locale_14, c2_.keyword AS keyword_15, c2_.id AS id_16, c2_.created AS created_17, c2_.changed AS changed_18, c3_.category_key AS category_key_19, c3_.default_locale AS default_locale_20, c3_.lft AS lft_21, c3_.rgt AS rgt_22, c3_.depth AS depth_23, c3_.id AS id_24, c3_.created AS created_25, c3_.changed AS changed_26, c4_.category_key AS category_key_27, c4_.default_locale AS default_locale_28, c4_.lft AS lft_29, c4_.rgt AS rgt_30, c4_.depth AS depth_31, c4_.id AS id_32, c4_.created AS created_33, c4_.changed AS changed_34, c0_.idCategoriesParent AS idCategoriesParent_35, c0_.idUsersCreator AS idUsersCreator_36, c0_.idUsersChanger AS idUsersChanger_37, c1_.idCategories AS idCategories_38, c1_.idUsersCreator AS idUsersCreator_39, c1_.idUsersChanger AS idUsersChanger_40, c2_.idUsersCreator AS idUsersCreator_41, c2_.idUsersChanger AS idUsersChanger_42, c3_.idCategoriesParent AS idCategoriesParent_43, c3_.idUsersCreator AS idUsersCreator_44, c3_.idUsersChanger AS idUsersChanger_45, c4_.idCategoriesParent AS idCategoriesParent_46, c4_.idUsersCreator AS idUsersCreator_47, c4_.idUsersChanger AS idUsersChanger_48 FROM ca_categories c0_ LEFT JOIN ca_category_translations c1_ ON c0_.id = c1_.idCategories LEFT JOIN ca_category_translation_keywords c5_ ON c1_.id = c5_.idCategoryTranslations LEFT JOIN ca_keywords c2_ ON c2_.id = c5_.idKeywords LEFT JOIN ca_categories c3_ ON c0_.idCategoriesParent = c3_.id LEFT JOIN ca_categories c4_ ON c0_.id = c4_.idCategoriesParent WHERE c0_.id IN (?)
SELECT
c0_.category_key AS category_key_0,
c0_.default_locale AS default_locale_1,
c0_.lft AS lft_2,
c0_.rgt AS rgt_3,
c0_.depth AS depth_4,
c0_.id AS id_5,
c0_.created AS created_6,
c0_.changed AS changed_7,
c1_.translation AS translation_8,
c1_.locale AS locale_9,
c1_.description AS description_10,
c1_.id AS id_11,
c1_.created AS created_12,
c1_.changed AS changed_13,
c2_.locale AS locale_14,
c2_.keyword AS keyword_15,
c2_.id AS id_16,
c2_.created AS created_17,
c2_.changed AS changed_18,
c3_.category_key AS category_key_19,
c3_.default_locale AS default_locale_20,
c3_.lft AS lft_21,
c3_.rgt AS rgt_22,
c3_.depth AS depth_23,
c3_.id AS id_24,
c3_.created AS created_25,
c3_.changed AS changed_26,
c4_.category_key AS category_key_27,
c4_.default_locale AS default_locale_28,
c4_.lft AS lft_29,
c4_.rgt AS rgt_30,
c4_.depth AS depth_31,
c4_.id AS id_32,
c4_.created AS created_33,
c4_.changed AS changed_34,
c0_.idCategoriesParent AS idCategoriesParent_35,
c0_.idUsersCreator AS idUsersCreator_36,
c0_.idUsersChanger AS idUsersChanger_37,
c1_.idCategories AS idCategories_38,
c1_.idUsersCreator AS idUsersCreator_39,
c1_.idUsersChanger AS idUsersChanger_40,
c2_.idUsersCreator AS idUsersCreator_41,
c2_.idUsersChanger AS idUsersChanger_42,
c3_.idCategoriesParent AS idCategoriesParent_43,
c3_.idUsersCreator AS idUsersCreator_44,
c3_.idUsersChanger AS idUsersChanger_45,
c4_.idCategoriesParent AS idCategoriesParent_46,
c4_.idUsersCreator AS idUsersCreator_47,
c4_.idUsersChanger AS idUsersChanger_48
FROM
ca_categories c0_
LEFT JOIN ca_category_translations c1_ ON c0_.id = c1_.idCategories
LEFT JOIN ca_category_translation_keywords c5_ ON c1_.id = c5_.idCategoryTranslations
LEFT JOIN ca_keywords c2_ ON c2_.id = c5_.idKeywords
LEFT JOIN ca_categories c3_ ON c0_.idCategoriesParent = c3_.id
LEFT JOIN ca_categories c4_ ON c0_.id = c4_.idCategoriesParent
WHERE
c0_.id IN (?)
SELECT c0_.category_key AS category_key_0, c0_.default_locale AS default_locale_1, c0_.lft AS lft_2, c0_.rgt AS rgt_3, c0_.depth AS depth_4, c0_.id AS id_5, c0_.created AS created_6, c0_.changed AS changed_7, c1_.translation AS translation_8, c1_.locale AS locale_9, c1_.description AS description_10, c1_.id AS id_11, c1_.created AS created_12, c1_.changed AS changed_13, c2_.locale AS locale_14, c2_.keyword AS keyword_15, c2_.id AS id_16, c2_.created AS created_17, c2_.changed AS changed_18, c3_.category_key AS category_key_19, c3_.default_locale AS default_locale_20, c3_.lft AS lft_21, c3_.rgt AS rgt_22, c3_.depth AS depth_23, c3_.id AS id_24, c3_.created AS created_25, c3_.changed AS changed_26, c4_.category_key AS category_key_27, c4_.default_locale AS default_locale_28, c4_.lft AS lft_29, c4_.rgt AS rgt_30, c4_.depth AS depth_31, c4_.id AS id_32, c4_.created AS created_33, c4_.changed AS changed_34, c0_.idCategoriesParent AS idCategoriesParent_35, c0_.idUsersCreator AS idUsersCreator_36, c0_.idUsersChanger AS idUsersChanger_37, c1_.idCategories AS idCategories_38, c1_.idUsersCreator AS idUsersCreator_39, c1_.idUsersChanger AS idUsersChanger_40, c2_.idUsersCreator AS idUsersCreator_41, c2_.idUsersChanger AS idUsersChanger_42, c3_.idCategoriesParent AS idCategoriesParent_43, c3_.idUsersCreator AS idUsersCreator_44, c3_.idUsersChanger AS idUsersChanger_45, c4_.idCategoriesParent AS idCategoriesParent_46, c4_.idUsersCreator AS idUsersCreator_47, c4_.idUsersChanger AS idUsersChanger_48 FROM ca_categories c0_ LEFT JOIN ca_category_translations c1_ ON c0_.id = c1_.idCategories LEFT JOIN ca_category_translation_keywords c5_ ON c1_.id = c5_.idCategoryTranslations LEFT JOIN ca_keywords c2_ ON c2_.id = c5_.idKeywords LEFT JOIN ca_categories c3_ ON c0_.idCategoriesParent = c3_.id LEFT JOIN ca_categories c4_ ON c0_.id = c4_.idCategoriesParent WHERE c0_.id IN (11);
|
| 7 |
1.07 ms |
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_.origin AS origin_26, m3_.aiDisclosureDisabled AS aiDisclosureDisabled_27, m3_.aiDisclosureIconVariant AS aiDisclosureIconVariant_28, m3_.id AS id_29, m3_.created AS created_30, m3_.changed AS changed_31, t4_.name AS name_32, t4_.id AS id_33, t4_.created AS created_34, t4_.changed AS changed_35, m5_.title AS title_36, m5_.description AS description_37, m5_.aiDisclosureText AS aiDisclosureText_38, m5_.copyright AS copyright_39, m5_.credits AS credits_40, m5_.locale AS locale_41, m5_.id AS id_42, m6_.title AS title_43, m6_.description AS description_44, m6_.aiDisclosureText AS aiDisclosureText_45, m6_.copyright AS copyright_46, m6_.credits AS credits_47, m6_.locale AS locale_48, m6_.id AS id_49, s7_.username AS username_50, s7_.password AS password_51, s7_.locale AS locale_52, s7_.salt AS salt_53, s7_.locked AS locked_54, s7_.enabled AS enabled_55, s7_.lastLogin AS lastLogin_56, s7_.confirmationKey AS confirmationKey_57, s7_.passwordResetToken AS passwordResetToken_58, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_59, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_60, s7_.privateKey AS privateKey_61, s7_.apiKey AS apiKey_62, s7_.email AS email_63, s7_.id AS id_64, s7_.created AS created_65, s7_.changed AS changed_66, c8_.firstName AS firstName_67, c8_.middleName AS middleName_68, c8_.lastName AS lastName_69, c8_.birthday AS birthday_70, c8_.salutation AS salutation_71, c8_.formOfAddress AS formOfAddress_72, c8_.newsletter AS newsletter_73, c8_.gender AS gender_74, c8_.note AS note_75, c8_.mainEmail AS mainEmail_76, c8_.mainPhone AS mainPhone_77, c8_.mainFax AS mainFax_78, c8_.mainUrl AS mainUrl_79, c8_.id AS id_80, c8_.created AS created_81, c8_.changed AS changed_82, s9_.username AS username_83, s9_.password AS password_84, s9_.locale AS locale_85, s9_.salt AS salt_86, s9_.locked AS locked_87, s9_.enabled AS enabled_88, s9_.lastLogin AS lastLogin_89, s9_.confirmationKey AS confirmationKey_90, s9_.passwordResetToken AS passwordResetToken_91, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_92, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_93, s9_.privateKey AS privateKey_94, s9_.apiKey AS apiKey_95, s9_.email AS email_96, s9_.id AS id_97, s9_.created AS created_98, s9_.changed AS changed_99, c10_.firstName AS firstName_100, c10_.middleName AS middleName_101, c10_.lastName AS lastName_102, c10_.birthday AS birthday_103, c10_.salutation AS salutation_104, c10_.formOfAddress AS formOfAddress_105, c10_.newsletter AS newsletter_106, c10_.gender AS gender_107, c10_.note AS note_108, c10_.mainEmail AS mainEmail_109, c10_.mainPhone AS mainPhone_110, c10_.mainFax AS mainFax_111, c10_.mainUrl AS mainUrl_112, c10_.id AS id_113, c10_.created AS created_114, c10_.changed AS changed_115, m0_.idPreviewImage AS idPreviewImage_116, m0_.idCollections AS idCollections_117, m0_.idUsersCreator AS idUsersCreator_118, m0_.idUsersChanger AS idUsersChanger_119, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_120, m1_.idCollectionTypes AS idCollectionTypes_121, m1_.idCollectionsParent AS idCollectionsParent_122, m1_.idUsersCreator AS idUsersCreator_123, m1_.idUsersChanger AS idUsersChanger_124, m2_.idMedia AS idMedia_125, m2_.idUsersCreator AS idUsersCreator_126, m2_.idUsersChanger AS idUsersChanger_127, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_128, m3_.idFiles AS idFiles_129, m3_.idUsersCreator AS idUsersCreator_130, m3_.idUsersChanger AS idUsersChanger_131, t4_.idUsersCreator AS idUsersCreator_132, t4_.idUsersChanger AS idUsersChanger_133, m5_.idFileVersions AS idFileVersions_134, m6_.idFileVersions AS idFileVersions_135, s7_.idContacts AS idContacts_136, s7_.idUsersCreator AS idUsersCreator_137, s7_.idUsersChanger AS idUsersChanger_138, c8_.idTitles AS idTitles_139, c8_.avatar AS avatar_140, c8_.idUsersCreator AS idUsersCreator_141, c8_.idUsersChanger AS idUsersChanger_142, s9_.idContacts AS idContacts_143, s9_.idUsersCreator AS idUsersCreator_144, s9_.idUsersChanger AS idUsersChanger_145, c10_.idTitles AS idTitles_146, c10_.avatar AS avatar_147, c10_.idUsersCreator AS idUsersCreator_148, c10_.idUsersChanger AS idUsersChanger_149 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_.origin AS origin_26,
m3_.aiDisclosureDisabled AS aiDisclosureDisabled_27,
m3_.aiDisclosureIconVariant AS aiDisclosureIconVariant_28,
m3_.id AS id_29,
m3_.created AS created_30,
m3_.changed AS changed_31,
t4_.name AS name_32,
t4_.id AS id_33,
t4_.created AS created_34,
t4_.changed AS changed_35,
m5_.title AS title_36,
m5_.description AS description_37,
m5_.aiDisclosureText AS aiDisclosureText_38,
m5_.copyright AS copyright_39,
m5_.credits AS credits_40,
m5_.locale AS locale_41,
m5_.id AS id_42,
m6_.title AS title_43,
m6_.description AS description_44,
m6_.aiDisclosureText AS aiDisclosureText_45,
m6_.copyright AS copyright_46,
m6_.credits AS credits_47,
m6_.locale AS locale_48,
m6_.id AS id_49,
s7_.username AS username_50,
s7_.password AS password_51,
s7_.locale AS locale_52,
s7_.salt AS salt_53,
s7_.locked AS locked_54,
s7_.enabled AS enabled_55,
s7_.lastLogin AS lastLogin_56,
s7_.confirmationKey AS confirmationKey_57,
s7_.passwordResetToken AS passwordResetToken_58,
s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_59,
s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_60,
s7_.privateKey AS privateKey_61,
s7_.apiKey AS apiKey_62,
s7_.email AS email_63,
s7_.id AS id_64,
s7_.created AS created_65,
s7_.changed AS changed_66,
c8_.firstName AS firstName_67,
c8_.middleName AS middleName_68,
c8_.lastName AS lastName_69,
c8_.birthday AS birthday_70,
c8_.salutation AS salutation_71,
c8_.formOfAddress AS formOfAddress_72,
c8_.newsletter AS newsletter_73,
c8_.gender AS gender_74,
c8_.note AS note_75,
c8_.mainEmail AS mainEmail_76,
c8_.mainPhone AS mainPhone_77,
c8_.mainFax AS mainFax_78,
c8_.mainUrl AS mainUrl_79,
c8_.id AS id_80,
c8_.created AS created_81,
c8_.changed AS changed_82,
s9_.username AS username_83,
s9_.password AS password_84,
s9_.locale AS locale_85,
s9_.salt AS salt_86,
s9_.locked AS locked_87,
s9_.enabled AS enabled_88,
s9_.lastLogin AS lastLogin_89,
s9_.confirmationKey AS confirmationKey_90,
s9_.passwordResetToken AS passwordResetToken_91,
s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_92,
s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_93,
s9_.privateKey AS privateKey_94,
s9_.apiKey AS apiKey_95,
s9_.email AS email_96,
s9_.id AS id_97,
s9_.created AS created_98,
s9_.changed AS changed_99,
c10_.firstName AS firstName_100,
c10_.middleName AS middleName_101,
c10_.lastName AS lastName_102,
c10_.birthday AS birthday_103,
c10_.salutation AS salutation_104,
c10_.formOfAddress AS formOfAddress_105,
c10_.newsletter AS newsletter_106,
c10_.gender AS gender_107,
c10_.note AS note_108,
c10_.mainEmail AS mainEmail_109,
c10_.mainPhone AS mainPhone_110,
c10_.mainFax AS mainFax_111,
c10_.mainUrl AS mainUrl_112,
c10_.id AS id_113,
c10_.created AS created_114,
c10_.changed AS changed_115,
m0_.idPreviewImage AS idPreviewImage_116,
m0_.idCollections AS idCollections_117,
m0_.idUsersCreator AS idUsersCreator_118,
m0_.idUsersChanger AS idUsersChanger_119,
m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_120,
m1_.idCollectionTypes AS idCollectionTypes_121,
m1_.idCollectionsParent AS idCollectionsParent_122,
m1_.idUsersCreator AS idUsersCreator_123,
m1_.idUsersChanger AS idUsersChanger_124,
m2_.idMedia AS idMedia_125,
m2_.idUsersCreator AS idUsersCreator_126,
m2_.idUsersChanger AS idUsersChanger_127,
m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_128,
m3_.idFiles AS idFiles_129,
m3_.idUsersCreator AS idUsersCreator_130,
m3_.idUsersChanger AS idUsersChanger_131,
t4_.idUsersCreator AS idUsersCreator_132,
t4_.idUsersChanger AS idUsersChanger_133,
m5_.idFileVersions AS idFileVersions_134,
m6_.idFileVersions AS idFileVersions_135,
s7_.idContacts AS idContacts_136,
s7_.idUsersCreator AS idUsersCreator_137,
s7_.idUsersChanger AS idUsersChanger_138,
c8_.idTitles AS idTitles_139,
c8_.avatar AS avatar_140,
c8_.idUsersCreator AS idUsersCreator_141,
c8_.idUsersChanger AS idUsersChanger_142,
s9_.idContacts AS idContacts_143,
s9_.idUsersCreator AS idUsersCreator_144,
s9_.idUsersChanger AS idUsersChanger_145,
c10_.idTitles AS idTitles_146,
c10_.avatar AS avatar_147,
c10_.idUsersCreator AS idUsersCreator_148,
c10_.idUsersChanger AS idUsersChanger_149
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_.origin AS origin_26, m3_.aiDisclosureDisabled AS aiDisclosureDisabled_27, m3_.aiDisclosureIconVariant AS aiDisclosureIconVariant_28, m3_.id AS id_29, m3_.created AS created_30, m3_.changed AS changed_31, t4_.name AS name_32, t4_.id AS id_33, t4_.created AS created_34, t4_.changed AS changed_35, m5_.title AS title_36, m5_.description AS description_37, m5_.aiDisclosureText AS aiDisclosureText_38, m5_.copyright AS copyright_39, m5_.credits AS credits_40, m5_.locale AS locale_41, m5_.id AS id_42, m6_.title AS title_43, m6_.description AS description_44, m6_.aiDisclosureText AS aiDisclosureText_45, m6_.copyright AS copyright_46, m6_.credits AS credits_47, m6_.locale AS locale_48, m6_.id AS id_49, s7_.username AS username_50, s7_.password AS password_51, s7_.locale AS locale_52, s7_.salt AS salt_53, s7_.locked AS locked_54, s7_.enabled AS enabled_55, s7_.lastLogin AS lastLogin_56, s7_.confirmationKey AS confirmationKey_57, s7_.passwordResetToken AS passwordResetToken_58, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_59, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_60, s7_.privateKey AS privateKey_61, s7_.apiKey AS apiKey_62, s7_.email AS email_63, s7_.id AS id_64, s7_.created AS created_65, s7_.changed AS changed_66, c8_.firstName AS firstName_67, c8_.middleName AS middleName_68, c8_.lastName AS lastName_69, c8_.birthday AS birthday_70, c8_.salutation AS salutation_71, c8_.formOfAddress AS formOfAddress_72, c8_.newsletter AS newsletter_73, c8_.gender AS gender_74, c8_.note AS note_75, c8_.mainEmail AS mainEmail_76, c8_.mainPhone AS mainPhone_77, c8_.mainFax AS mainFax_78, c8_.mainUrl AS mainUrl_79, c8_.id AS id_80, c8_.created AS created_81, c8_.changed AS changed_82, s9_.username AS username_83, s9_.password AS password_84, s9_.locale AS locale_85, s9_.salt AS salt_86, s9_.locked AS locked_87, s9_.enabled AS enabled_88, s9_.lastLogin AS lastLogin_89, s9_.confirmationKey AS confirmationKey_90, s9_.passwordResetToken AS passwordResetToken_91, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_92, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_93, s9_.privateKey AS privateKey_94, s9_.apiKey AS apiKey_95, s9_.email AS email_96, s9_.id AS id_97, s9_.created AS created_98, s9_.changed AS changed_99, c10_.firstName AS firstName_100, c10_.middleName AS middleName_101, c10_.lastName AS lastName_102, c10_.birthday AS birthday_103, c10_.salutation AS salutation_104, c10_.formOfAddress AS formOfAddress_105, c10_.newsletter AS newsletter_106, c10_.gender AS gender_107, c10_.note AS note_108, c10_.mainEmail AS mainEmail_109, c10_.mainPhone AS mainPhone_110, c10_.mainFax AS mainFax_111, c10_.mainUrl AS mainUrl_112, c10_.id AS id_113, c10_.created AS created_114, c10_.changed AS changed_115, m0_.idPreviewImage AS idPreviewImage_116, m0_.idCollections AS idCollections_117, m0_.idUsersCreator AS idUsersCreator_118, m0_.idUsersChanger AS idUsersChanger_119, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_120, m1_.idCollectionTypes AS idCollectionTypes_121, m1_.idCollectionsParent AS idCollectionsParent_122, m1_.idUsersCreator AS idUsersCreator_123, m1_.idUsersChanger AS idUsersChanger_124, m2_.idMedia AS idMedia_125, m2_.idUsersCreator AS idUsersCreator_126, m2_.idUsersChanger AS idUsersChanger_127, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_128, m3_.idFiles AS idFiles_129, m3_.idUsersCreator AS idUsersCreator_130, m3_.idUsersChanger AS idUsersChanger_131, t4_.idUsersCreator AS idUsersCreator_132, t4_.idUsersChanger AS idUsersChanger_133, m5_.idFileVersions AS idFileVersions_134, m6_.idFileVersions AS idFileVersions_135, s7_.idContacts AS idContacts_136, s7_.idUsersCreator AS idUsersCreator_137, s7_.idUsersChanger AS idUsersChanger_138, c8_.idTitles AS idTitles_139, c8_.avatar AS avatar_140, c8_.idUsersCreator AS idUsersCreator_141, c8_.idUsersChanger AS idUsersChanger_142, s9_.idContacts AS idContacts_143, s9_.idUsersCreator AS idUsersCreator_144, s9_.idUsersChanger AS idUsersChanger_145, c10_.idTitles AS idTitles_146, c10_.avatar AS avatar_147, c10_.idUsersCreator AS idUsersCreator_148, c10_.idUsersChanger AS idUsersChanger_149 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 (2) ORDER BY m0_.id ASC;
|
| 8 |
0.54 ms |
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 = ?
Parameters: [
"en"
"de"
"articles"
"33333333-0000-4000-8000-000000000105"
]
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', 'de') AND r0_.resource_key = 'articles' AND r0_.resource_id = '33333333-0000-4000-8000-000000000105';
|
| 9 |
1.40 ms |
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
Parameters: [
"en"
"website"
1
"en"
"live"
0
"en"
"live"
0
"main"
]
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
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 ('en')) 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 = 'website' AND p0_.depth <= 1 AND p7_.locale = 'en' AND p7_.stage = 'live' AND p7_.version = 0 AND (((p1_.locale IS NULL OR p1_.locale IN ('en')) AND (p1_.stage IS NULL OR p1_.stage IN ('live'))) AND (p1_.version IS NULL OR p1_.version IN (0))) AND p10_.name IN ('main') ORDER BY p0_.lft ASC;
|
| 10 |
1.04 ms |
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
Parameters: [
"en"
"website"
1
"en"
"live"
0
"en"
"live"
0
"main"
]
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
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 ('en')) 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 = 'website' AND p0_.depth <= 1 AND p7_.locale = 'en' AND p7_.stage = 'live' AND p7_.version = 0 AND (((p1_.locale IS NULL OR p1_.locale IN ('en')) AND (p1_.stage IS NULL OR p1_.stage IN ('live'))) AND (p1_.version IS NULL OR p1_.version IN (0))) AND p10_.name IN ('main') ORDER BY p0_.lft ASC;
|
| 11 |
0.55 ms |
SELECT w0_.title AS title_0, w0_.webspace_key AS webspace_key_1, w0_.all_domains AS all_domains_2, w0_.content AS content_3, w0_.type AS type_4, w0_.id AS id_5, w1_.url AS url_6, w1_.environment AS environment_7, w1_.id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain WHERE (w0_.all_domains = 1 OR (w1_.url = ? AND w1_.environment = ?)) AND w0_.webspace_key = ? ORDER BY w0_.id ASC
Parameters: [
"hfgmfurdvsg0.zrok.sulu.tools/{localization}"
"dev"
"website"
]
SELECT w0_.title AS title_0, w0_.webspace_key AS webspace_key_1, w0_.all_domains AS all_domains_2, w0_.content AS content_3, w0_.type AS type_4, w0_.id AS id_5, w1_.url AS url_6, w1_.environment AS environment_7, w1_.id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain WHERE (w0_.all_domains = 1 OR (w1_.url = 'hfgmfurdvsg0.zrok.sulu.tools/{localization}' AND w1_.environment = 'dev')) AND w0_.webspace_key = 'website' ORDER BY w0_.id ASC;
|