0.78 ms (18.46%)
2
SELECT t0 . category_key AS category_key_1 , t0 . default_locale AS default_locale_2 , t0 . lft AS lft_3 , t0 . rgt AS rgt_4 , t0 . depth AS depth_5 , t0 . id AS id_6 , t0 . created AS created_7 , t0 . changed AS changed_8 , t0 . idCategoriesParent AS idCategoriesParent_9 , t0 . idUsersCreator AS idUsersCreator_10 , t0 . idUsersChanger AS idUsersChanger_11 FROM ca_categories t0 INNER JOIN pa_page_dimension_content_excerpt_categories ON t0 . id = pa_page_dimension_content_excerpt_categories . category_id WHERE pa_page_dimension_content_excerpt_categories . page_dimension_content_id = ?
SELECT t0 . category_key AS category_key_1 , t0 . default_locale AS default_locale_2 , t0 . lft AS lft_3 , t0 . rgt AS rgt_4 , t0 . depth AS depth_5 , t0 . id AS id_6 , t0 . created AS created_7 , t0 . changed AS changed_8 , t0 . idCategoriesParent AS idCategoriesParent_9 , t0 . idUsersCreator AS idUsersCreator_10 , t0 . idUsersChanger AS idUsersChanger_11 FROM ca_categories t0 INNER JOIN pa_page_dimension_content_excerpt_categories ON t0 . id = pa_page_dimension_content_excerpt_categories . category_id WHERE pa_page_dimension_content_excerpt_categories . page_dimension_content_id = 13 ;
Copy
0.73 ms (17.19%)
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 , p0_ . parent_id AS parent_id_32 , p0_ . idUsersCreator AS idUsersCreator_33 , p0_ . idUsersChanger AS idUsersChanger_34 , p1_ . route_id AS route_id_35 , p1_ . pageUuid AS pageUuid_36 , p1_ . author_id AS author_id_37 , p1_ . idUsersCreator AS idUsersCreator_38 , p1_ . idUsersChanger AS idUsersChanger_39 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 = ? )) WHERE p0_ . uuid = ?
Parameters :
[
"draft "
0
"en "
"019c6568-0950-703e-b6bb-5473325adc6a "
]
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 , p0_ . parent_id AS parent_id_32 , p0_ . idUsersCreator AS idUsersCreator_33 , p0_ . idUsersChanger AS idUsersChanger_34 , p1_ . route_id AS route_id_35 , p1_ . pageUuid AS pageUuid_36 , p1_ . author_id AS author_id_37 , p1_ . idUsersCreator AS idUsersCreator_38 , p1_ . idUsersChanger AS idUsersChanger_39 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p1_ ON p0_ . uuid = p1_ . pageUuid AND (p1_ . stage = 'draft' AND p1_ . version = 0 AND (p1_ . locale IS NULL OR p1_ . locale = 'en' )) WHERE p0_ . uuid = '019c6568-0950-703e-b6bb-5473325adc6a' ;
Copy
0.51 ms (12.06%)
1
SELECT s0_ . username AS username_0 , s0_ . password AS password_1 , s0_ . locale AS locale_2 , s0_ . salt AS salt_3 , s0_ . locked AS locked_4 , s0_ . enabled AS enabled_5 , s0_ . lastLogin AS lastLogin_6 , s0_ . confirmationKey AS confirmationKey_7 , s0_ . passwordResetToken AS passwordResetToken_8 , s0_ . passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_9 , s0_ . passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_10 , s0_ . privateKey AS privateKey_11 , s0_ . apiKey AS apiKey_12 , s0_ . email AS email_13 , s0_ . id AS id_14 , s0_ . created AS created_15 , s0_ . changed AS changed_16 , s1_ . locale AS locale_17 , s1_ . id AS id_18 , s2_ . name AS name_19 , s2_ . role_key AS role_key_20 , s2_ . securitySystem AS securitySystem_21 , s2_ . anonymous AS anonymous_22 , s2_ . id AS id_23 , s2_ . created AS created_24 , s2_ . changed AS changed_25 , s3_ . context AS context_26 , s3_ . permissions AS permissions_27 , s3_ . id AS id_28 , s0_ . idContacts AS idContacts_29 , s0_ . idUsersCreator AS idUsersCreator_30 , s0_ . idUsersChanger AS idUsersChanger_31 , s1_ . idUsers AS idUsers_32 , s1_ . idRoles AS idRoles_33 , s2_ . idUsersCreator AS idUsersCreator_34 , s2_ . idUsersChanger AS idUsersChanger_35 , s3_ . idRoles AS idRoles_36 FROM se_users s0_ LEFT JOIN se_user_roles s1_ ON s0_ . id = s1_ . idUsers LEFT JOIN se_roles s2_ ON s1_ . idRoles = s2_ . id LEFT JOIN se_permissions s3_ ON s2_ . id = s3_ . idRoles WHERE s0_ . id = ?
SELECT s0_ . username AS username_0 , s0_ . password AS password_1 , s0_ . locale AS locale_2 , s0_ . salt AS salt_3 , s0_ . locked AS locked_4 , s0_ . enabled AS enabled_5 , s0_ . lastLogin AS lastLogin_6 , s0_ . confirmationKey AS confirmationKey_7 , s0_ . passwordResetToken AS passwordResetToken_8 , s0_ . passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_9 , s0_ . passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_10 , s0_ . privateKey AS privateKey_11 , s0_ . apiKey AS apiKey_12 , s0_ . email AS email_13 , s0_ . id AS id_14 , s0_ . created AS created_15 , s0_ . changed AS changed_16 , s1_ . locale AS locale_17 , s1_ . id AS id_18 , s2_ . name AS name_19 , s2_ . role_key AS role_key_20 , s2_ . securitySystem AS securitySystem_21 , s2_ . anonymous AS anonymous_22 , s2_ . id AS id_23 , s2_ . created AS created_24 , s2_ . changed AS changed_25 , s3_ . context AS context_26 , s3_ . permissions AS permissions_27 , s3_ . id AS id_28 , s0_ . idContacts AS idContacts_29 , s0_ . idUsersCreator AS idUsersCreator_30 , s0_ . idUsersChanger AS idUsersChanger_31 , s1_ . idUsers AS idUsers_32 , s1_ . idRoles AS idRoles_33 , s2_ . idUsersCreator AS idUsersCreator_34 , s2_ . idUsersChanger AS idUsersChanger_35 , s3_ . idRoles AS idRoles_36 FROM se_users s0_ LEFT JOIN se_user_roles s1_ ON s0_ . id = s1_ . idUsers LEFT JOIN se_roles s2_ ON s1_ . idRoles = s2_ . id LEFT JOIN se_permissions s3_ ON s2_ . id = s3_ . idRoles WHERE s0_ . id = 1 ;
Copy