| 1 |
0.59 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"
"de"
"/informationen/sub-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 = 'de' AND r0_.slug = '/informationen/sub-1' ORDER BY r0_.webspace DESC LIMIT 1;
|
| 2 |
0.75 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, 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 (?)))
Parameters: [
"de"
"019e3b0a-6a60-779a-8238-330a63c8c855"
"de"
"live"
0
]
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 ('de')) WHERE p0_.uuid = '019e3b0a-6a60-779a-8238-330a63c8c855' AND (((p1_.locale IS NULL OR p1_.locale IN ('de')) AND (p1_.stage IS NULL OR p1_.stage IN ('live'))) AND (p1_.version IS NULL OR p1_.version IN (0)));
|
| 3 |
0.29 ms |
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 = 57;
|
| 4 |
0.20 ms |
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 = 58;
|
| 5 |
0.31 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: [
"de"
"pages"
"019e3b0a-6a60-779a-8238-330a63c8c855"
]
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 ('de') AND r0_.resource_key = 'pages' AND r0_.resource_id = '019e3b0a-6a60-779a-8238-330a63c8c855';
|
| 6 |
0.28 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: [
"de"
"website"
2
"de"
"live"
0
"de"
"live"
0
"headline"
]
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 ('de')) 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 <= 2 AND p7_.locale = 'de' AND p7_.stage = 'live' AND p7_.version = 0 AND (((p1_.locale IS NULL OR p1_.locale IN ('de')) AND (p1_.stage IS NULL OR p1_.stage IN ('live'))) AND (p1_.version IS NULL OR p1_.version IN (0))) AND p10_.name IN ('headline') ORDER BY p0_.lft ASC;
|
| 7 |
0.26 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: [
"de"
"website"
3
"de"
"live"
0
"de"
"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 ('de')) 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 <= 3 AND p7_.locale = 'de' AND p7_.stage = 'live' AND p7_.version = 0 AND (((p1_.locale IS NULL OR p1_.locale IN ('de')) 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;
|
| 8 |
0.26 ms |
SELECT f0_.defaultLocale AS defaultLocale_0, f0_.id AS id_1, f1_.title AS title_2, f1_.subject AS subject_3, f1_.fromEmail AS fromEmail_4, f1_.fromName AS fromName_5, f1_.toEmail AS toEmail_6, f1_.toName AS toName_7, f1_.mailText AS mailText_8, f1_.submitLabel AS submitLabel_9, f1_.successText AS successText_10, f1_.sendAttachments AS sendAttachments_11, f1_.deactivateAttachmentSave AS deactivateAttachmentSave_12, f1_.deactivateNotifyMails AS deactivateNotifyMails_13, f1_.deactivateCustomerMails AS deactivateCustomerMails_14, f1_.replyTo AS replyTo_15, f1_.locale AS locale_16, f1_.id AS id_17, f1_.created AS created_18, f1_.changed AS changed_19, f2_.keyName AS keyName_20, f2_.orderNumber AS orderNumber_21, f2_.type AS type_22, f2_.width AS width_23, f2_.required AS required_24, f2_.defaultLocale AS defaultLocale_25, f2_.id AS id_26, f3_.title AS title_27, f3_.placeholder AS placeholder_28, f3_.defaultValue AS defaultValue_29, f3_.shortTitle AS shortTitle_30, f3_.locale AS locale_31, f3_.options AS options_32, f3_.id AS id_33, f4_.type AS type_34, f4_.email AS email_35, f4_.name AS name_36, f4_.id AS id_37, f1_.idForms AS idForms_38, f1_.idUsersCreator AS idUsersCreator_39, f1_.idUsersChanger AS idUsersChanger_40, f2_.idForms AS idForms_41, f3_.idFormFields AS idFormFields_42, f4_.idFormTranslations AS idFormTranslations_43 FROM fo_forms f0_ LEFT JOIN fo_form_translations f1_ ON f0_.id = f1_.idForms LEFT JOIN fo_form_fields f2_ ON f0_.id = f2_.idForms LEFT JOIN fo_form_field_translations f3_ ON f2_.id = f3_.idFormFields LEFT JOIN fo_form_translation_receivers f4_ ON f1_.id = f4_.idFormTranslations WHERE f0_.id = ? ORDER BY f2_.orderNumber ASC
SELECT
f0_.defaultLocale AS defaultLocale_0,
f0_.id AS id_1,
f1_.title AS title_2,
f1_.subject AS subject_3,
f1_.fromEmail AS fromEmail_4,
f1_.fromName AS fromName_5,
f1_.toEmail AS toEmail_6,
f1_.toName AS toName_7,
f1_.mailText AS mailText_8,
f1_.submitLabel AS submitLabel_9,
f1_.successText AS successText_10,
f1_.sendAttachments AS sendAttachments_11,
f1_.deactivateAttachmentSave AS deactivateAttachmentSave_12,
f1_.deactivateNotifyMails AS deactivateNotifyMails_13,
f1_.deactivateCustomerMails AS deactivateCustomerMails_14,
f1_.replyTo AS replyTo_15,
f1_.locale AS locale_16,
f1_.id AS id_17,
f1_.created AS created_18,
f1_.changed AS changed_19,
f2_.keyName AS keyName_20,
f2_.orderNumber AS orderNumber_21,
f2_.type AS type_22,
f2_.width AS width_23,
f2_.required AS required_24,
f2_.defaultLocale AS defaultLocale_25,
f2_.id AS id_26,
f3_.title AS title_27,
f3_.placeholder AS placeholder_28,
f3_.defaultValue AS defaultValue_29,
f3_.shortTitle AS shortTitle_30,
f3_.locale AS locale_31,
f3_.options AS options_32,
f3_.id AS id_33,
f4_.type AS type_34,
f4_.email AS email_35,
f4_.name AS name_36,
f4_.id AS id_37,
f1_.idForms AS idForms_38,
f1_.idUsersCreator AS idUsersCreator_39,
f1_.idUsersChanger AS idUsersChanger_40,
f2_.idForms AS idForms_41,
f3_.idFormFields AS idFormFields_42,
f4_.idFormTranslations AS idFormTranslations_43
FROM
fo_forms f0_
LEFT JOIN fo_form_translations f1_ ON f0_.id = f1_.idForms
LEFT JOIN fo_form_fields f2_ ON f0_.id = f2_.idForms
LEFT JOIN fo_form_field_translations f3_ ON f2_.id = f3_.idFormFields
LEFT JOIN fo_form_translation_receivers f4_ ON f1_.id = f4_.idFormTranslations
WHERE
f0_.id = ?
ORDER BY
f2_.orderNumber ASC
SELECT f0_.defaultLocale AS defaultLocale_0, f0_.id AS id_1, f1_.title AS title_2, f1_.subject AS subject_3, f1_.fromEmail AS fromEmail_4, f1_.fromName AS fromName_5, f1_.toEmail AS toEmail_6, f1_.toName AS toName_7, f1_.mailText AS mailText_8, f1_.submitLabel AS submitLabel_9, f1_.successText AS successText_10, f1_.sendAttachments AS sendAttachments_11, f1_.deactivateAttachmentSave AS deactivateAttachmentSave_12, f1_.deactivateNotifyMails AS deactivateNotifyMails_13, f1_.deactivateCustomerMails AS deactivateCustomerMails_14, f1_.replyTo AS replyTo_15, f1_.locale AS locale_16, f1_.id AS id_17, f1_.created AS created_18, f1_.changed AS changed_19, f2_.keyName AS keyName_20, f2_.orderNumber AS orderNumber_21, f2_.type AS type_22, f2_.width AS width_23, f2_.required AS required_24, f2_.defaultLocale AS defaultLocale_25, f2_.id AS id_26, f3_.title AS title_27, f3_.placeholder AS placeholder_28, f3_.defaultValue AS defaultValue_29, f3_.shortTitle AS shortTitle_30, f3_.locale AS locale_31, f3_.options AS options_32, f3_.id AS id_33, f4_.type AS type_34, f4_.email AS email_35, f4_.name AS name_36, f4_.id AS id_37, f1_.idForms AS idForms_38, f1_.idUsersCreator AS idUsersCreator_39, f1_.idUsersChanger AS idUsersChanger_40, f2_.idForms AS idForms_41, f3_.idFormFields AS idFormFields_42, f4_.idFormTranslations AS idFormTranslations_43 FROM fo_forms f0_ LEFT JOIN fo_form_translations f1_ ON f0_.id = f1_.idForms LEFT JOIN fo_form_fields f2_ ON f0_.id = f2_.idForms LEFT JOIN fo_form_field_translations f3_ ON f2_.id = f3_.idFormFields LEFT JOIN fo_form_translation_receivers f4_ ON f1_.id = f4_.idFormTranslations WHERE f0_.id = 1 ORDER BY f2_.orderNumber ASC;
|
| 9 |
0.36 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: [
"de"
"website"
2
"de"
"live"
0
"de"
"live"
0
"footline"
]
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 ('de')) 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 <= 2 AND p7_.locale = 'de' AND p7_.stage = 'live' AND p7_.version = 0 AND (((p1_.locale IS NULL OR p1_.locale IN ('de')) AND (p1_.stage IS NULL OR p1_.stage IN ('live'))) AND (p1_.version IS NULL OR p1_.version IN (0))) AND p10_.name IN ('footline') ORDER BY p0_.lft ASC;
|
| 10 |
0.22 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: [
"2026-laute-kyff.k2.netwit.de"
"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 = '2026-laute-kyff.k2.netwit.de' AND w1_.environment = 'dev')) AND w0_.webspace_key = 'website' ORDER BY w0_.id ASC;
|