3.09 ms
(38.60%)
|
2 |
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"
"prismx"
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 = 'prismx' 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;
|
0.81 ms
(10.08%)
|
1 |
SELECT p0_.webspaceKey AS webspaceKey_0, p0_.lft AS lft_1, p0_.rgt AS rgt_2, p0_.depth AS depth_3, p0_.uuid AS uuid_4, p0_.created AS created_5, p0_.changed AS changed_6, p1_.title AS title_7, p1_.id AS id_8, p1_.stage AS stage_9, p1_.locale AS locale_10, p1_.ghostLocale AS ghostLocale_11, p1_.availableLocales AS availableLocales_12, p1_.version AS version_13, p1_.shadowLocale AS shadowLocale_14, p1_.shadowLocales AS shadowLocales_15, p1_.templateKey AS templateKey_16, p1_.templateData AS templateData_17, p1_.seoData AS seoData_18, p1_.seoNoIndex AS seoNoIndex_19, p1_.seoNoFollow AS seoNoFollow_20, p1_.seoHideInSitemap AS seoHideInSitemap_21, p1_.excerptData AS excerptData_22, p1_.excerptSegment AS excerptSegment_23, p1_.authored AS authored_24, p1_.lastModified AS lastModified_25, p1_.workflowPlace AS workflowPlace_26, p1_.workflowPublished AS workflowPublished_27, p1_.linkProvider AS linkProvider_28, p1_.linkData AS linkData_29, p1_.created AS created_30, p1_.changed AS changed_31, t2_.name AS name_32, t2_.id AS id_33, t2_.created AS created_34, t2_.changed AS changed_35, c3_.category_key AS category_key_36, c3_.default_locale AS default_locale_37, c3_.lft AS lft_38, c3_.rgt AS rgt_39, c3_.depth AS depth_40, c3_.id AS id_41, c3_.created AS created_42, c3_.changed AS changed_43, c4_.translation AS translation_44, c4_.locale AS locale_45, c4_.description AS description_46, c4_.id AS id_47, c4_.created AS created_48, c4_.changed AS changed_49, p0_.parent_id AS parent_id_50, p0_.idUsersCreator AS idUsersCreator_51, p0_.idUsersChanger AS idUsersChanger_52, p1_.route_id AS route_id_53, p1_.pageUuid AS pageUuid_54, p1_.author_id AS author_id_55, p1_.idUsersCreator AS idUsersCreator_56, p1_.idUsersChanger AS idUsersChanger_57, t2_.idUsersCreator AS idUsersCreator_58, t2_.idUsersChanger AS idUsersChanger_59, c3_.idCategoriesParent AS idCategoriesParent_60, c3_.idUsersCreator AS idUsersCreator_61, c3_.idUsersChanger AS idUsersChanger_62, c4_.idCategories AS idCategories_63, c4_.idUsersCreator AS idUsersCreator_64, c4_.idUsersChanger AS idUsersChanger_65 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid AND (p1_.stage = ? AND p1_.version = ? AND (p1_.locale IS NULL OR p1_.locale = ?)) LEFT JOIN pa_page_dimension_content_excerpt_tags p5_ ON p1_.id = p5_.page_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = p5_.tag_id LEFT JOIN pa_page_dimension_content_excerpt_categories p6_ ON p1_.id = p6_.page_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = p6_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories WHERE p0_.uuid = ?
Parameters: [
"live"
0
"en"
"019b66af-4641-7213-9d75-9c9e2f1fc583"
]
SELECT
p0_.webspaceKey AS webspaceKey_0,
p0_.lft AS lft_1,
p0_.rgt AS rgt_2,
p0_.depth AS depth_3,
p0_.uuid AS uuid_4,
p0_.created AS created_5,
p0_.changed AS changed_6,
p1_.title AS title_7,
p1_.id AS id_8,
p1_.stage AS stage_9,
p1_.locale AS locale_10,
p1_.ghostLocale AS ghostLocale_11,
p1_.availableLocales AS availableLocales_12,
p1_.version AS version_13,
p1_.shadowLocale AS shadowLocale_14,
p1_.shadowLocales AS shadowLocales_15,
p1_.templateKey AS templateKey_16,
p1_.templateData AS templateData_17,
p1_.seoData AS seoData_18,
p1_.seoNoIndex AS seoNoIndex_19,
p1_.seoNoFollow AS seoNoFollow_20,
p1_.seoHideInSitemap AS seoHideInSitemap_21,
p1_.excerptData AS excerptData_22,
p1_.excerptSegment AS excerptSegment_23,
p1_.authored AS authored_24,
p1_.lastModified AS lastModified_25,
p1_.workflowPlace AS workflowPlace_26,
p1_.workflowPublished AS workflowPublished_27,
p1_.linkProvider AS linkProvider_28,
p1_.linkData AS linkData_29,
p1_.created AS created_30,
p1_.changed AS changed_31,
t2_.name AS name_32,
t2_.id AS id_33,
t2_.created AS created_34,
t2_.changed AS changed_35,
c3_.category_key AS category_key_36,
c3_.default_locale AS default_locale_37,
c3_.lft AS lft_38,
c3_.rgt AS rgt_39,
c3_.depth AS depth_40,
c3_.id AS id_41,
c3_.created AS created_42,
c3_.changed AS changed_43,
c4_.translation AS translation_44,
c4_.locale AS locale_45,
c4_.description AS description_46,
c4_.id AS id_47,
c4_.created AS created_48,
c4_.changed AS changed_49,
p0_.parent_id AS parent_id_50,
p0_.idUsersCreator AS idUsersCreator_51,
p0_.idUsersChanger AS idUsersChanger_52,
p1_.route_id AS route_id_53,
p1_.pageUuid AS pageUuid_54,
p1_.author_id AS author_id_55,
p1_.idUsersCreator AS idUsersCreator_56,
p1_.idUsersChanger AS idUsersChanger_57,
t2_.idUsersCreator AS idUsersCreator_58,
t2_.idUsersChanger AS idUsersChanger_59,
c3_.idCategoriesParent AS idCategoriesParent_60,
c3_.idUsersCreator AS idUsersCreator_61,
c3_.idUsersChanger AS idUsersChanger_62,
c4_.idCategories AS idCategories_63,
c4_.idUsersCreator AS idUsersCreator_64,
c4_.idUsersChanger AS idUsersChanger_65
FROM
pa_pages p0_
LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid
AND (
p1_.stage = ?
AND p1_.version = ?
AND (
p1_.locale IS NULL
OR p1_.locale = ?
)
)
LEFT JOIN pa_page_dimension_content_excerpt_tags p5_ ON p1_.id = p5_.page_dimension_content_id
LEFT JOIN ta_tags t2_ ON t2_.id = p5_.tag_id
LEFT JOIN pa_page_dimension_content_excerpt_categories p6_ ON p1_.id = p6_.page_dimension_content_id
LEFT JOIN ca_categories c3_ ON c3_.id = p6_.category_id
LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories
WHERE
p0_.uuid = ?
SELECT p0_.webspaceKey AS webspaceKey_0, p0_.lft AS lft_1, p0_.rgt AS rgt_2, p0_.depth AS depth_3, p0_.uuid AS uuid_4, p0_.created AS created_5, p0_.changed AS changed_6, p1_.title AS title_7, p1_.id AS id_8, p1_.stage AS stage_9, p1_.locale AS locale_10, p1_.ghostLocale AS ghostLocale_11, p1_.availableLocales AS availableLocales_12, p1_.version AS version_13, p1_.shadowLocale AS shadowLocale_14, p1_.shadowLocales AS shadowLocales_15, p1_.templateKey AS templateKey_16, p1_.templateData AS templateData_17, p1_.seoData AS seoData_18, p1_.seoNoIndex AS seoNoIndex_19, p1_.seoNoFollow AS seoNoFollow_20, p1_.seoHideInSitemap AS seoHideInSitemap_21, p1_.excerptData AS excerptData_22, p1_.excerptSegment AS excerptSegment_23, p1_.authored AS authored_24, p1_.lastModified AS lastModified_25, p1_.workflowPlace AS workflowPlace_26, p1_.workflowPublished AS workflowPublished_27, p1_.linkProvider AS linkProvider_28, p1_.linkData AS linkData_29, p1_.created AS created_30, p1_.changed AS changed_31, t2_.name AS name_32, t2_.id AS id_33, t2_.created AS created_34, t2_.changed AS changed_35, c3_.category_key AS category_key_36, c3_.default_locale AS default_locale_37, c3_.lft AS lft_38, c3_.rgt AS rgt_39, c3_.depth AS depth_40, c3_.id AS id_41, c3_.created AS created_42, c3_.changed AS changed_43, c4_.translation AS translation_44, c4_.locale AS locale_45, c4_.description AS description_46, c4_.id AS id_47, c4_.created AS created_48, c4_.changed AS changed_49, p0_.parent_id AS parent_id_50, p0_.idUsersCreator AS idUsersCreator_51, p0_.idUsersChanger AS idUsersChanger_52, p1_.route_id AS route_id_53, p1_.pageUuid AS pageUuid_54, p1_.author_id AS author_id_55, p1_.idUsersCreator AS idUsersCreator_56, p1_.idUsersChanger AS idUsersChanger_57, t2_.idUsersCreator AS idUsersCreator_58, t2_.idUsersChanger AS idUsersChanger_59, c3_.idCategoriesParent AS idCategoriesParent_60, c3_.idUsersCreator AS idUsersCreator_61, c3_.idUsersChanger AS idUsersChanger_62, c4_.idCategories AS idCategories_63, c4_.idUsersCreator AS idUsersCreator_64, c4_.idUsersChanger AS idUsersChanger_65 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid AND (p1_.stage = 'live' AND p1_.version = 0 AND (p1_.locale IS NULL OR p1_.locale = 'en')) LEFT JOIN pa_page_dimension_content_excerpt_tags p5_ ON p1_.id = p5_.page_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = p5_.tag_id LEFT JOIN pa_page_dimension_content_excerpt_categories p6_ ON p1_.id = p6_.page_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = p6_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories WHERE p0_.uuid = '019b66af-4641-7213-9d75-9c9e2f1fc583';
|
0.60 ms
(7.50%)
|
1 |
SELECT r0_.webspace AS webspace_0, r0_.locale AS locale_1, r0_.slug AS slug_2, r0_.resource_key AS resource_key_3, r0_.resource_id AS resource_id_4, r0_.id AS id_5, r0_.parent_id AS parent_id_6 FROM ro_routes r0_ WHERE r0_.locale IN (?, ?) AND r0_.resource_key = ? AND r0_.resource_id = ?
Parameters: [
"en"
"nl"
"pages"
"019b66af-4641-7213-9d75-9c9e2f1fc583"
]
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', 'nl') AND r0_.resource_key = 'pages' AND r0_.resource_id = '019b66af-4641-7213-9d75-9c9e2f1fc583';
|
0.58 ms
(7.31%)
|
1 |
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 c3_.category_key = ?
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
c3_.category_key = ?
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 c3_.category_key = 'opinie';
|
0.58 ms
(7.24%)
|
1 |
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, 1 AS sclr_8, c0_.idCategoriesParent AS idCategoriesParent_9, c0_.idUsersCreator AS idUsersCreator_10, c0_.idUsersChanger AS idUsersChanger_11 FROM ca_categories c0_ WHERE c0_.category_key = ? LIMIT 1
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, 1 AS sclr_8, c0_.idCategoriesParent AS idCategoriesParent_9, c0_.idUsersCreator AS idUsersCreator_10, c0_.idUsersChanger AS idUsersChanger_11 FROM ca_categories c0_ WHERE c0_.category_key = 'opinie' LIMIT 1;
|
0.54 ms
(6.74%)
|
2 |
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 = 19;
|
0.49 ms
(6.17%)
|
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 = ? OR r0_.webspace IS NULL)) AND r0_.locale = ? AND r0_.slug = ? ORDER BY r0_.webspace DESC LIMIT 1
Parameters: [
"prismx"
"en"
"/opinion"
]
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 = 'prismx' OR r0_.webspace IS NULL)) AND r0_.locale = 'en' AND r0_.slug = '/opinion' ORDER BY r0_.webspace DESC LIMIT 1;
|
0.41 ms
(5.06%)
|
1 |
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: [
"dev.prismx.eu/{localization}"
"dev"
"prismx"
]
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 = 'dev.prismx.eu/{localization}' AND w1_.environment = 'dev')) AND w0_.webspace_key = 'prismx' ORDER BY w0_.id ASC;
|
0.33 ms
(4.14%)
|
1 |
SELECT t0.position AS position_1, t0.id AS id_2, t0.idCategoryTranslations AS idCategoryTranslations_3, t0.idMedia AS idMedia_4 FROM ca_category_translation_medias t0 WHERE t0.idCategoryTranslations = ?
SELECT t0.position AS position_1, t0.id AS id_2, t0.idCategoryTranslations AS idCategoryTranslations_3, t0.idMedia AS idMedia_4 FROM ca_category_translation_medias t0 WHERE t0.idCategoryTranslations = 4;
|
0.30 ms
(3.74%)
|
1 |
SELECT t0.username AS username_1, t0.password AS password_2, t0.locale AS locale_3, t0.salt AS salt_4, t0.locked AS locked_5, t0.enabled AS enabled_6, t0.lastLogin AS lastLogin_7, t0.confirmationKey AS confirmationKey_8, t0.passwordResetToken AS passwordResetToken_9, t0.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_10, t0.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_11, t0.privateKey AS privateKey_12, t0.apiKey AS apiKey_13, t0.email AS email_14, t0.id AS id_15, t0.created AS created_16, t0.changed AS changed_17, t18.method AS method_19, t18.options AS options_20, t18.id AS id_21, t18.idUsers AS idUsers_22, t0.idContacts AS idContacts_23, t0.idUsersCreator AS idUsersCreator_24, t0.idUsersChanger AS idUsersChanger_25 FROM se_users t0 LEFT JOIN se_user_two_factors t18 ON t18.idUsers = t0.id WHERE t0.id = ?
SELECT t0.username AS username_1, t0.password AS password_2, t0.locale AS locale_3, t0.salt AS salt_4, t0.locked AS locked_5, t0.enabled AS enabled_6, t0.lastLogin AS lastLogin_7, t0.confirmationKey AS confirmationKey_8, t0.passwordResetToken AS passwordResetToken_9, t0.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_10, t0.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_11, t0.privateKey AS privateKey_12, t0.apiKey AS apiKey_13, t0.email AS email_14, t0.id AS id_15, t0.created AS created_16, t0.changed AS changed_17, t18.method AS method_19, t18.options AS options_20, t18.id AS id_21, t18.idUsers AS idUsers_22, t0.idContacts AS idContacts_23, t0.idUsersCreator AS idUsersCreator_24, t0.idUsersChanger AS idUsersChanger_25 FROM se_users t0 LEFT JOIN se_user_two_factors t18 ON t18.idUsers = t0.id WHERE t0.id = 1;
|
0.27 ms
(3.44%)
|
1 |
SELECT t0.firstName AS firstName_1, t0.middleName AS middleName_2, t0.lastName AS lastName_3, t0.birthday AS birthday_4, t0.salutation AS salutation_5, t0.formOfAddress AS formOfAddress_6, t0.newsletter AS newsletter_7, t0.gender AS gender_8, t0.note AS note_9, t0.mainEmail AS mainEmail_10, t0.mainPhone AS mainPhone_11, t0.mainFax AS mainFax_12, t0.mainUrl AS mainUrl_13, t0.id AS id_14, t0.created AS created_15, t0.changed AS changed_16, t0.idTitles AS idTitles_17, t0.avatar AS avatar_18, t0.idUsersCreator AS idUsersCreator_19, t0.idUsersChanger AS idUsersChanger_20 FROM co_contacts t0 WHERE t0.id = ?
SELECT t0.firstName AS firstName_1, t0.middleName AS middleName_2, t0.lastName AS lastName_3, t0.birthday AS birthday_4, t0.salutation AS salutation_5, t0.formOfAddress AS formOfAddress_6, t0.newsletter AS newsletter_7, t0.gender AS gender_8, t0.note AS note_9, t0.mainEmail AS mainEmail_10, t0.mainPhone AS mainPhone_11, t0.mainFax AS mainFax_12, t0.mainUrl AS mainUrl_13, t0.id AS id_14, t0.created AS created_15, t0.changed AS changed_16, t0.idTitles AS idTitles_17, t0.avatar AS avatar_18, t0.idUsersCreator AS idUsersCreator_19, t0.idUsersChanger AS idUsersChanger_20 FROM co_contacts t0 WHERE t0.id = 1;
|