1
0.75 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 :
[
"dragoman "
"bg "
"/za-nas/trail "
]
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 = 'dragoman' OR r0_ . webspace IS NULL )) AND r0_ . locale = 'bg' AND r0_ . slug = '/za-nas/trail' ORDER BY r0_ . webspace DESC LIMIT 1 ;
Copy
2
1.52 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 :
[
"bg "
"019df909-36e6-7ae2-84fa-bc65d40aaa0e "
"bg "
"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 (? )
)
)
Copy
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 ('bg' )) WHERE p0_ . uuid = '019df909-36e6-7ae2-84fa-bc65d40aaa0e' AND (((p1_ . locale IS NULL OR p1_ . locale IN ('bg' )) AND (p1_ . stage IS NULL OR p1_ . stage IN ('live' ))) AND (p1_ . version IS NULL OR p1_ . version IN (0 )));
Copy
3
0.42 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 = 99 ;
Copy
4
0.38 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 = 100 ;
Copy
5
0.57 ms
SELECT p0_ . uuid AS uuid_0 , p1_ . title AS title_1 , r2_ . slug AS slug_2 , p0_ . webspaceKey AS webspaceKey_3 , p1_ . linkProvider AS linkProvider_4 , p1_ . linkData AS linkData_5 FROM pa_page_dimension_contents p1_ INNER JOIN pa_pages p0_ ON p1_ . pageUuid = p0_ . uuid LEFT JOIN ro_routes r2_ ON p1_ . route_id = r2_ . id WHERE p0_ . uuid IN (? ) AND p1_ . locale = ? AND p1_ . stage = ? AND p1_ . version = ?
Parameters :
[
"019ddd44-6ef3-770a-bf69-a4d4cbd2cc63 "
"bg "
"live "
0
]
SELECT p0_ . uuid AS uuid_0 , p1_ . title AS title_1 , r2_ . slug AS slug_2 , p0_ . webspaceKey AS webspaceKey_3 , p1_ . linkProvider AS linkProvider_4 , p1_ . linkData AS linkData_5 FROM pa_page_dimension_contents p1_ INNER JOIN pa_pages p0_ ON p1_ . pageUuid = p0_ . uuid LEFT JOIN ro_routes r2_ ON p1_ . route_id = r2_ . id WHERE p0_ . uuid IN ('019ddd44-6ef3-770a-bf69-a4d4cbd2cc63' ) AND p1_ . locale = 'bg' AND p1_ . stage = 'live' AND p1_ . version = 0 ;
Copy
6
1.25 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_ . id AS id_26 , m3_ . created AS created_27 , m3_ . changed AS changed_28 , t4_ . name AS name_29 , t4_ . id AS id_30 , t4_ . created AS created_31 , t4_ . changed AS changed_32 , m5_ . title AS title_33 , m5_ . description AS description_34 , m5_ . copyright AS copyright_35 , m5_ . credits AS credits_36 , m5_ . locale AS locale_37 , m5_ . id AS id_38 , m6_ . title AS title_39 , m6_ . description AS description_40 , m6_ . copyright AS copyright_41 , m6_ . credits AS credits_42 , m6_ . locale AS locale_43 , m6_ . id AS id_44 , s7_ . username AS username_45 , s7_ . password AS password_46 , s7_ . locale AS locale_47 , s7_ . salt AS salt_48 , s7_ . locked AS locked_49 , s7_ . enabled AS enabled_50 , s7_ . lastLogin AS lastLogin_51 , s7_ . confirmationKey AS confirmationKey_52 , s7_ . passwordResetToken AS passwordResetToken_53 , s7_ . passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_54 , s7_ . passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_55 , s7_ . privateKey AS privateKey_56 , s7_ . apiKey AS apiKey_57 , s7_ . email AS email_58 , s7_ . id AS id_59 , s7_ . created AS created_60 , s7_ . changed AS changed_61 , c8_ . firstName AS firstName_62 , c8_ . middleName AS middleName_63 , c8_ . lastName AS lastName_64 , c8_ . birthday AS birthday_65 , c8_ . salutation AS salutation_66 , c8_ . formOfAddress AS formOfAddress_67 , c8_ . newsletter AS newsletter_68 , c8_ . gender AS gender_69 , c8_ . note AS note_70 , c8_ . mainEmail AS mainEmail_71 , c8_ . mainPhone AS mainPhone_72 , c8_ . mainFax AS mainFax_73 , c8_ . mainUrl AS mainUrl_74 , c8_ . id AS id_75 , c8_ . created AS created_76 , c8_ . changed AS changed_77 , s9_ . username AS username_78 , s9_ . password AS password_79 , s9_ . locale AS locale_80 , s9_ . salt AS salt_81 , s9_ . locked AS locked_82 , s9_ . enabled AS enabled_83 , s9_ . lastLogin AS lastLogin_84 , s9_ . confirmationKey AS confirmationKey_85 , s9_ . passwordResetToken AS passwordResetToken_86 , s9_ . passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_87 , s9_ . passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_88 , s9_ . privateKey AS privateKey_89 , s9_ . apiKey AS apiKey_90 , s9_ . email AS email_91 , s9_ . id AS id_92 , s9_ . created AS created_93 , s9_ . changed AS changed_94 , c10_ . firstName AS firstName_95 , c10_ . middleName AS middleName_96 , c10_ . lastName AS lastName_97 , c10_ . birthday AS birthday_98 , c10_ . salutation AS salutation_99 , c10_ . formOfAddress AS formOfAddress_100 , c10_ . newsletter AS newsletter_101 , c10_ . gender AS gender_102 , c10_ . note AS note_103 , c10_ . mainEmail AS mainEmail_104 , c10_ . mainPhone AS mainPhone_105 , c10_ . mainFax AS mainFax_106 , c10_ . mainUrl AS mainUrl_107 , c10_ . id AS id_108 , c10_ . created AS created_109 , c10_ . changed AS changed_110 , m0_ . idPreviewImage AS idPreviewImage_111 , m0_ . idCollections AS idCollections_112 , m0_ . idUsersCreator AS idUsersCreator_113 , m0_ . idUsersChanger AS idUsersChanger_114 , m1_ . idCollectionsMetaDefault AS idCollectionsMetaDefault_115 , m1_ . idCollectionTypes AS idCollectionTypes_116 , m1_ . idCollectionsParent AS idCollectionsParent_117 , m1_ . idUsersCreator AS idUsersCreator_118 , m1_ . idUsersChanger AS idUsersChanger_119 , m2_ . idMedia AS idMedia_120 , m2_ . idUsersCreator AS idUsersCreator_121 , m2_ . idUsersChanger AS idUsersChanger_122 , m3_ . idFileVersionsMetaDefault AS idFileVersionsMetaDefault_123 , m3_ . idFiles AS idFiles_124 , m3_ . idUsersCreator AS idUsersCreator_125 , m3_ . idUsersChanger AS idUsersChanger_126 , t4_ . idUsersCreator AS idUsersCreator_127 , t4_ . idUsersChanger AS idUsersChanger_128 , m5_ . idFileVersions AS idFileVersions_129 , m6_ . idFileVersions AS idFileVersions_130 , s7_ . idContacts AS idContacts_131 , s7_ . idUsersCreator AS idUsersCreator_132 , s7_ . idUsersChanger AS idUsersChanger_133 , c8_ . idTitles AS idTitles_134 , c8_ . avatar AS avatar_135 , c8_ . idUsersCreator AS idUsersCreator_136 , c8_ . idUsersChanger AS idUsersChanger_137 , s9_ . idContacts AS idContacts_138 , s9_ . idUsersCreator AS idUsersCreator_139 , s9_ . idUsersChanger AS idUsersChanger_140 , c10_ . idTitles AS idTitles_141 , c10_ . avatar AS avatar_142 , c10_ . idUsersCreator AS idUsersCreator_143 , c10_ . idUsersChanger AS idUsersChanger_144 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_ . idCollections = m1_ . id INNER JOIN me_files m2_ ON m0_ . id = m2_ . idMedia INNER JOIN me_file_versions m3_ ON m2_ . id = m3_ . idFiles AND (m3_ . version = m2_ . version ) LEFT JOIN me_file_version_tags m11_ ON m3_ . id = m11_ . idFileVersions LEFT JOIN ta_tags t4_ ON t4_ . id = m11_ . idTags LEFT JOIN me_file_version_meta m5_ ON m3_ . id = m5_ . idFileVersions LEFT JOIN me_file_version_meta m6_ ON m3_ . idFileVersionsMetaDefault = m6_ . id LEFT JOIN se_users s7_ ON m0_ . idUsersCreator = s7_ . id LEFT JOIN co_contacts c8_ ON s7_ . idContacts = c8_ . id LEFT JOIN se_users s9_ ON m0_ . idUsersChanger = s9_ . id LEFT JOIN co_contacts c10_ ON s9_ . idContacts = c10_ . id WHERE m0_ . id IN (? ) ORDER BY m0_ . id ASC
SELECT
m0_ . type AS type_0 ,
m0_ . id AS id_1 ,
m0_ . created AS created_2 ,
m0_ . changed AS changed_3 ,
m1_ . style AS style_4 ,
m1_ . lft AS lft_5 ,
m1_ . rgt AS rgt_6 ,
m1_ . depth AS depth_7 ,
m1_ . collection_key AS collection_key_8 ,
m1_ . id AS id_9 ,
m1_ . created AS created_10 ,
m1_ . changed AS changed_11 ,
m2_ . version AS version_12 ,
m2_ . id AS id_13 ,
m2_ . created AS created_14 ,
m2_ . changed AS changed_15 ,
m3_ . name AS name_16 ,
m3_ . version AS version_17 ,
m3_ . subVersion AS subVersion_18 ,
m3_ . size AS size_19 ,
m3_ . downloadCounter AS downloadCounter_20 ,
m3_ . storageOptions AS storageOptions_21 ,
m3_ . mimeType AS mimeType_22 ,
m3_ . properties AS properties_23 ,
m3_ . focusPointX AS focusPointX_24 ,
m3_ . focusPointY AS focusPointY_25 ,
m3_ . id AS id_26 ,
m3_ . created AS created_27 ,
m3_ . changed AS changed_28 ,
t4_ . name AS name_29 ,
t4_ . id AS id_30 ,
t4_ . created AS created_31 ,
t4_ . changed AS changed_32 ,
m5_ . title AS title_33 ,
m5_ . description AS description_34 ,
m5_ . copyright AS copyright_35 ,
m5_ . credits AS credits_36 ,
m5_ . locale AS locale_37 ,
m5_ . id AS id_38 ,
m6_ . title AS title_39 ,
m6_ . description AS description_40 ,
m6_ . copyright AS copyright_41 ,
m6_ . credits AS credits_42 ,
m6_ . locale AS locale_43 ,
m6_ . id AS id_44 ,
s7_ . username AS username_45 ,
s7_ . password AS password_46 ,
s7_ . locale AS locale_47 ,
s7_ . salt AS salt_48 ,
s7_ . locked AS locked_49 ,
s7_ . enabled AS enabled_50 ,
s7_ . lastLogin AS lastLogin_51 ,
s7_ . confirmationKey AS confirmationKey_52 ,
s7_ . passwordResetToken AS passwordResetToken_53 ,
s7_ . passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_54 ,
s7_ . passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_55 ,
s7_ . privateKey AS privateKey_56 ,
s7_ . apiKey AS apiKey_57 ,
s7_ . email AS email_58 ,
s7_ . id AS id_59 ,
s7_ . created AS created_60 ,
s7_ . changed AS changed_61 ,
c8_ . firstName AS firstName_62 ,
c8_ . middleName AS middleName_63 ,
c8_ . lastName AS lastName_64 ,
c8_ . birthday AS birthday_65 ,
c8_ . salutation AS salutation_66 ,
c8_ . formOfAddress AS formOfAddress_67 ,
c8_ . newsletter AS newsletter_68 ,
c8_ . gender AS gender_69 ,
c8_ . note AS note_70 ,
c8_ . mainEmail AS mainEmail_71 ,
c8_ . mainPhone AS mainPhone_72 ,
c8_ . mainFax AS mainFax_73 ,
c8_ . mainUrl AS mainUrl_74 ,
c8_ . id AS id_75 ,
c8_ . created AS created_76 ,
c8_ . changed AS changed_77 ,
s9_ . username AS username_78 ,
s9_ . password AS password_79 ,
s9_ . locale AS locale_80 ,
s9_ . salt AS salt_81 ,
s9_ . locked AS locked_82 ,
s9_ . enabled AS enabled_83 ,
s9_ . lastLogin AS lastLogin_84 ,
s9_ . confirmationKey AS confirmationKey_85 ,
s9_ . passwordResetToken AS passwordResetToken_86 ,
s9_ . passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_87 ,
s9_ . passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_88 ,
s9_ . privateKey AS privateKey_89 ,
s9_ . apiKey AS apiKey_90 ,
s9_ . email AS email_91 ,
s9_ . id AS id_92 ,
s9_ . created AS created_93 ,
s9_ . changed AS changed_94 ,
c10_ . firstName AS firstName_95 ,
c10_ . middleName AS middleName_96 ,
c10_ . lastName AS lastName_97 ,
c10_ . birthday AS birthday_98 ,
c10_ . salutation AS salutation_99 ,
c10_ . formOfAddress AS formOfAddress_100 ,
c10_ . newsletter AS newsletter_101 ,
c10_ . gender AS gender_102 ,
c10_ . note AS note_103 ,
c10_ . mainEmail AS mainEmail_104 ,
c10_ . mainPhone AS mainPhone_105 ,
c10_ . mainFax AS mainFax_106 ,
c10_ . mainUrl AS mainUrl_107 ,
c10_ . id AS id_108 ,
c10_ . created AS created_109 ,
c10_ . changed AS changed_110 ,
m0_ . idPreviewImage AS idPreviewImage_111 ,
m0_ . idCollections AS idCollections_112 ,
m0_ . idUsersCreator AS idUsersCreator_113 ,
m0_ . idUsersChanger AS idUsersChanger_114 ,
m1_ . idCollectionsMetaDefault AS idCollectionsMetaDefault_115 ,
m1_ . idCollectionTypes AS idCollectionTypes_116 ,
m1_ . idCollectionsParent AS idCollectionsParent_117 ,
m1_ . idUsersCreator AS idUsersCreator_118 ,
m1_ . idUsersChanger AS idUsersChanger_119 ,
m2_ . idMedia AS idMedia_120 ,
m2_ . idUsersCreator AS idUsersCreator_121 ,
m2_ . idUsersChanger AS idUsersChanger_122 ,
m3_ . idFileVersionsMetaDefault AS idFileVersionsMetaDefault_123 ,
m3_ . idFiles AS idFiles_124 ,
m3_ . idUsersCreator AS idUsersCreator_125 ,
m3_ . idUsersChanger AS idUsersChanger_126 ,
t4_ . idUsersCreator AS idUsersCreator_127 ,
t4_ . idUsersChanger AS idUsersChanger_128 ,
m5_ . idFileVersions AS idFileVersions_129 ,
m6_ . idFileVersions AS idFileVersions_130 ,
s7_ . idContacts AS idContacts_131 ,
s7_ . idUsersCreator AS idUsersCreator_132 ,
s7_ . idUsersChanger AS idUsersChanger_133 ,
c8_ . idTitles AS idTitles_134 ,
c8_ . avatar AS avatar_135 ,
c8_ . idUsersCreator AS idUsersCreator_136 ,
c8_ . idUsersChanger AS idUsersChanger_137 ,
s9_ . idContacts AS idContacts_138 ,
s9_ . idUsersCreator AS idUsersCreator_139 ,
s9_ . idUsersChanger AS idUsersChanger_140 ,
c10_ . idTitles AS idTitles_141 ,
c10_ . avatar AS avatar_142 ,
c10_ . idUsersCreator AS idUsersCreator_143 ,
c10_ . idUsersChanger AS idUsersChanger_144
FROM
me_media m0_
LEFT JOIN me_collections m1_ ON m0_ . idCollections = m1_ . id
INNER JOIN me_files m2_ ON m0_ . id = m2_ . idMedia
INNER JOIN me_file_versions m3_ ON m2_ . id = m3_ . idFiles
AND (m3_ . version = m2_ . version )
LEFT JOIN me_file_version_tags m11_ ON m3_ . id = m11_ . idFileVersions
LEFT JOIN ta_tags t4_ ON t4_ . id = m11_ . idTags
LEFT JOIN me_file_version_meta m5_ ON m3_ . id = m5_ . idFileVersions
LEFT JOIN me_file_version_meta m6_ ON m3_ . idFileVersionsMetaDefault = m6_ . id
LEFT JOIN se_users s7_ ON m0_ . idUsersCreator = s7_ . id
LEFT JOIN co_contacts c8_ ON s7_ . idContacts = c8_ . id
LEFT JOIN se_users s9_ ON m0_ . idUsersChanger = s9_ . id
LEFT JOIN co_contacts c10_ ON s9_ . idContacts = c10_ . id
WHERE
m0_ . id IN (? )
ORDER BY
m0_ . id ASC
Copy
SELECT m0_ . type AS type_0 , m0_ . id AS id_1 , m0_ . created AS created_2 , m0_ . changed AS changed_3 , m1_ . style AS style_4 , m1_ . lft AS lft_5 , m1_ . rgt AS rgt_6 , m1_ . depth AS depth_7 , m1_ . collection_key AS collection_key_8 , m1_ . id AS id_9 , m1_ . created AS created_10 , m1_ . changed AS changed_11 , m2_ . version AS version_12 , m2_ . id AS id_13 , m2_ . created AS created_14 , m2_ . changed AS changed_15 , m3_ . name AS name_16 , m3_ . version AS version_17 , m3_ . subVersion AS subVersion_18 , m3_ . size AS size_19 , m3_ . downloadCounter AS downloadCounter_20 , m3_ . storageOptions AS storageOptions_21 , m3_ . mimeType AS mimeType_22 , m3_ . properties AS properties_23 , m3_ . focusPointX AS focusPointX_24 , m3_ . focusPointY AS focusPointY_25 , m3_ . id AS id_26 , m3_ . created AS created_27 , m3_ . changed AS changed_28 , t4_ . name AS name_29 , t4_ . id AS id_30 , t4_ . created AS created_31 , t4_ . changed AS changed_32 , m5_ . title AS title_33 , m5_ . description AS description_34 , m5_ . copyright AS copyright_35 , m5_ . credits AS credits_36 , m5_ . locale AS locale_37 , m5_ . id AS id_38 , m6_ . title AS title_39 , m6_ . description AS description_40 , m6_ . copyright AS copyright_41 , m6_ . credits AS credits_42 , m6_ . locale AS locale_43 , m6_ . id AS id_44 , s7_ . username AS username_45 , s7_ . password AS password_46 , s7_ . locale AS locale_47 , s7_ . salt AS salt_48 , s7_ . locked AS locked_49 , s7_ . enabled AS enabled_50 , s7_ . lastLogin AS lastLogin_51 , s7_ . confirmationKey AS confirmationKey_52 , s7_ . passwordResetToken AS passwordResetToken_53 , s7_ . passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_54 , s7_ . passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_55 , s7_ . privateKey AS privateKey_56 , s7_ . apiKey AS apiKey_57 , s7_ . email AS email_58 , s7_ . id AS id_59 , s7_ . created AS created_60 , s7_ . changed AS changed_61 , c8_ . firstName AS firstName_62 , c8_ . middleName AS middleName_63 , c8_ . lastName AS lastName_64 , c8_ . birthday AS birthday_65 , c8_ . salutation AS salutation_66 , c8_ . formOfAddress AS formOfAddress_67 , c8_ . newsletter AS newsletter_68 , c8_ . gender AS gender_69 , c8_ . note AS note_70 , c8_ . mainEmail AS mainEmail_71 , c8_ . mainPhone AS mainPhone_72 , c8_ . mainFax AS mainFax_73 , c8_ . mainUrl AS mainUrl_74 , c8_ . id AS id_75 , c8_ . created AS created_76 , c8_ . changed AS changed_77 , s9_ . username AS username_78 , s9_ . password AS password_79 , s9_ . locale AS locale_80 , s9_ . salt AS salt_81 , s9_ . locked AS locked_82 , s9_ . enabled AS enabled_83 , s9_ . lastLogin AS lastLogin_84 , s9_ . confirmationKey AS confirmationKey_85 , s9_ . passwordResetToken AS passwordResetToken_86 , s9_ . passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_87 , s9_ . passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_88 , s9_ . privateKey AS privateKey_89 , s9_ . apiKey AS apiKey_90 , s9_ . email AS email_91 , s9_ . id AS id_92 , s9_ . created AS created_93 , s9_ . changed AS changed_94 , c10_ . firstName AS firstName_95 , c10_ . middleName AS middleName_96 , c10_ . lastName AS lastName_97 , c10_ . birthday AS birthday_98 , c10_ . salutation AS salutation_99 , c10_ . formOfAddress AS formOfAddress_100 , c10_ . newsletter AS newsletter_101 , c10_ . gender AS gender_102 , c10_ . note AS note_103 , c10_ . mainEmail AS mainEmail_104 , c10_ . mainPhone AS mainPhone_105 , c10_ . mainFax AS mainFax_106 , c10_ . mainUrl AS mainUrl_107 , c10_ . id AS id_108 , c10_ . created AS created_109 , c10_ . changed AS changed_110 , m0_ . idPreviewImage AS idPreviewImage_111 , m0_ . idCollections AS idCollections_112 , m0_ . idUsersCreator AS idUsersCreator_113 , m0_ . idUsersChanger AS idUsersChanger_114 , m1_ . idCollectionsMetaDefault AS idCollectionsMetaDefault_115 , m1_ . idCollectionTypes AS idCollectionTypes_116 , m1_ . idCollectionsParent AS idCollectionsParent_117 , m1_ . idUsersCreator AS idUsersCreator_118 , m1_ . idUsersChanger AS idUsersChanger_119 , m2_ . idMedia AS idMedia_120 , m2_ . idUsersCreator AS idUsersCreator_121 , m2_ . idUsersChanger AS idUsersChanger_122 , m3_ . idFileVersionsMetaDefault AS idFileVersionsMetaDefault_123 , m3_ . idFiles AS idFiles_124 , m3_ . idUsersCreator AS idUsersCreator_125 , m3_ . idUsersChanger AS idUsersChanger_126 , t4_ . idUsersCreator AS idUsersCreator_127 , t4_ . idUsersChanger AS idUsersChanger_128 , m5_ . idFileVersions AS idFileVersions_129 , m6_ . idFileVersions AS idFileVersions_130 , s7_ . idContacts AS idContacts_131 , s7_ . idUsersCreator AS idUsersCreator_132 , s7_ . idUsersChanger AS idUsersChanger_133 , c8_ . idTitles AS idTitles_134 , c8_ . avatar AS avatar_135 , c8_ . idUsersCreator AS idUsersCreator_136 , c8_ . idUsersChanger AS idUsersChanger_137 , s9_ . idContacts AS idContacts_138 , s9_ . idUsersCreator AS idUsersCreator_139 , s9_ . idUsersChanger AS idUsersChanger_140 , c10_ . idTitles AS idTitles_141 , c10_ . avatar AS avatar_142 , c10_ . idUsersCreator AS idUsersCreator_143 , c10_ . idUsersChanger AS idUsersChanger_144 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_ . idCollections = m1_ . id INNER JOIN me_files m2_ ON m0_ . id = m2_ . idMedia INNER JOIN me_file_versions m3_ ON m2_ . id = m3_ . idFiles AND (m3_ . version = m2_ . version ) LEFT JOIN me_file_version_tags m11_ ON m3_ . id = m11_ . idFileVersions LEFT JOIN ta_tags t4_ ON t4_ . id = m11_ . idTags LEFT JOIN me_file_version_meta m5_ ON m3_ . id = m5_ . idFileVersions LEFT JOIN me_file_version_meta m6_ ON m3_ . idFileVersionsMetaDefault = m6_ . id LEFT JOIN se_users s7_ ON m0_ . idUsersCreator = s7_ . id LEFT JOIN co_contacts c8_ ON s7_ . idContacts = c8_ . id LEFT JOIN se_users s9_ ON m0_ . idUsersChanger = s9_ . id LEFT JOIN co_contacts c10_ ON s9_ . idContacts = c10_ . id WHERE m0_ . id IN (13 ) ORDER BY m0_ . id ASC ;
Copy
7
0.65 ms
SELECT t0 . method AS method_1 , t0 . options AS options_2 , t0 . id AS id_3 , t0 . idUsers AS idUsers_4 FROM se_user_two_factors t0 WHERE t0 . idUsers = ?
SELECT t0 . method AS method_1 , t0 . options AS options_2 , t0 . id AS id_3 , t0 . idUsers AS idUsers_4 FROM se_user_two_factors t0 WHERE t0 . idUsers = 1 ;
Copy
8
0.46 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 :
[
"bg "
"pages "
"019df909-36e6-7ae2-84fa-bc65d40aaa0e "
]
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 ('bg' ) AND r0_ . resource_key = 'pages' AND r0_ . resource_id = '019df909-36e6-7ae2-84fa-bc65d40aaa0e' ;
Copy
9
0.47 ms
SELECT s0_ . webspace_key AS webspace_key_0 , s0_ . area_key AS area_key_1 , s0_ . uuid AS uuid_2 , s0_ . idSnippet AS idSnippet_3 FROM sn_snippet_area s0_ WHERE s0_ . webspace_key = ? AND s0_ . area_key = ?
Parameters :
[
"dragoman "
"default "
]
SELECT s0_ . webspace_key AS webspace_key_0 , s0_ . area_key AS area_key_1 , s0_ . uuid AS uuid_2 , s0_ . idSnippet AS idSnippet_3 FROM sn_snippet_area s0_ WHERE s0_ . webspace_key = 'dragoman' AND s0_ . area_key = 'default' ;
Copy
10
1.11 ms
SELECT s0_ . uuid AS uuid_0 , s0_ . created AS created_1 , s0_ . changed AS changed_2 , s1_ . title AS title_3 , s1_ . id AS id_4 , s1_ . stage AS stage_5 , s1_ . locale AS locale_6 , s1_ . ghostLocale AS ghostLocale_7 , s1_ . availableLocales AS availableLocales_8 , s1_ . version AS version_9 , s1_ . templateKey AS templateKey_10 , s1_ . templateData AS templateData_11 , s1_ . excerptSegment AS excerptSegment_12 , s1_ . workflowPlace AS workflowPlace_13 , s1_ . workflowPublished AS workflowPublished_14 , s1_ . created AS created_15 , s1_ . changed AS changed_16 , t2_ . name AS name_17 , t2_ . id AS id_18 , t2_ . created AS created_19 , t2_ . changed AS changed_20 , c3_ . category_key AS category_key_21 , c3_ . default_locale AS default_locale_22 , c3_ . lft AS lft_23 , c3_ . rgt AS rgt_24 , c3_ . depth AS depth_25 , c3_ . id AS id_26 , c3_ . created AS created_27 , c3_ . changed AS changed_28 , c4_ . translation AS translation_29 , c4_ . locale AS locale_30 , c4_ . description AS description_31 , c4_ . id AS id_32 , c4_ . created AS created_33 , c4_ . changed AS changed_34 , s0_ . idUsersCreator AS idUsersCreator_35 , s0_ . idUsersChanger AS idUsersChanger_36 , s1_ . snippetUuid AS snippetUuid_37 , s1_ . idUsersCreator AS idUsersCreator_38 , s1_ . idUsersChanger AS idUsersChanger_39 , t2_ . idUsersCreator AS idUsersCreator_40 , t2_ . idUsersChanger AS idUsersChanger_41 , c3_ . idCategoriesParent AS idCategoriesParent_42 , c3_ . idUsersCreator AS idUsersCreator_43 , c3_ . idUsersChanger AS idUsersChanger_44 , c4_ . idCategories AS idCategories_45 , c4_ . idUsersCreator AS idUsersCreator_46 , c4_ . idUsersChanger AS idUsersChanger_47 FROM sn_snippets s0_ LEFT JOIN sn_snippet_dimension_contents s5_ ON (s5_ . snippetUuid = s0_ . uuid ) LEFT JOIN sn_snippet_dimension_contents s1_ ON s0_ . uuid = s1_ . snippetUuid LEFT JOIN sn_snippet_dimension_content_excerpt_tags s6_ ON s1_ . id = s6_ . snippet_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_ . id = s6_ . tag_id LEFT JOIN sn_snippet_dimension_content_excerpt_categories s7_ ON s1_ . id = s7_ . snippet_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_ . id = s7_ . category_id LEFT JOIN ca_category_translations c4_ ON c3_ . id = c4_ . idCategories AND (c4_ . locale = c3_ . default_locale OR c4_ . locale IN (? )) WHERE s0_ . uuid = ? AND s5_ . locale = ? AND s5_ . stage = ? AND s5_ . version = ? AND (((s1_ . locale IS NULL OR s1_ . locale IN (? )) AND (s1_ . stage IS NULL OR s1_ . stage IN (? ))) AND (s1_ . version IS NULL OR s1_ . version IN (? )))
Parameters :
[
"bg "
"019ddd15-425a-7c95-839e-8ed4f4cd37cf "
"bg "
"live "
0
"bg "
"live "
0
]
SELECT
s0_ . uuid AS uuid_0 ,
s0_ . created AS created_1 ,
s0_ . changed AS changed_2 ,
s1_ . title AS title_3 ,
s1_ . id AS id_4 ,
s1_ . stage AS stage_5 ,
s1_ . locale AS locale_6 ,
s1_ . ghostLocale AS ghostLocale_7 ,
s1_ . availableLocales AS availableLocales_8 ,
s1_ . version AS version_9 ,
s1_ . templateKey AS templateKey_10 ,
s1_ . templateData AS templateData_11 ,
s1_ . excerptSegment AS excerptSegment_12 ,
s1_ . workflowPlace AS workflowPlace_13 ,
s1_ . workflowPublished AS workflowPublished_14 ,
s1_ . created AS created_15 ,
s1_ . changed AS changed_16 ,
t2_ . name AS name_17 ,
t2_ . id AS id_18 ,
t2_ . created AS created_19 ,
t2_ . changed AS changed_20 ,
c3_ . category_key AS category_key_21 ,
c3_ . default_locale AS default_locale_22 ,
c3_ . lft AS lft_23 ,
c3_ . rgt AS rgt_24 ,
c3_ . depth AS depth_25 ,
c3_ . id AS id_26 ,
c3_ . created AS created_27 ,
c3_ . changed AS changed_28 ,
c4_ . translation AS translation_29 ,
c4_ . locale AS locale_30 ,
c4_ . description AS description_31 ,
c4_ . id AS id_32 ,
c4_ . created AS created_33 ,
c4_ . changed AS changed_34 ,
s0_ . idUsersCreator AS idUsersCreator_35 ,
s0_ . idUsersChanger AS idUsersChanger_36 ,
s1_ . snippetUuid AS snippetUuid_37 ,
s1_ . idUsersCreator AS idUsersCreator_38 ,
s1_ . idUsersChanger AS idUsersChanger_39 ,
t2_ . idUsersCreator AS idUsersCreator_40 ,
t2_ . idUsersChanger AS idUsersChanger_41 ,
c3_ . idCategoriesParent AS idCategoriesParent_42 ,
c3_ . idUsersCreator AS idUsersCreator_43 ,
c3_ . idUsersChanger AS idUsersChanger_44 ,
c4_ . idCategories AS idCategories_45 ,
c4_ . idUsersCreator AS idUsersCreator_46 ,
c4_ . idUsersChanger AS idUsersChanger_47
FROM
sn_snippets s0_
LEFT JOIN sn_snippet_dimension_contents s5_ ON (s5_ . snippetUuid = s0_ . uuid )
LEFT JOIN sn_snippet_dimension_contents s1_ ON s0_ . uuid = s1_ . snippetUuid
LEFT JOIN sn_snippet_dimension_content_excerpt_tags s6_ ON s1_ . id = s6_ . snippet_dimension_content_id
LEFT JOIN ta_tags t2_ ON t2_ . id = s6_ . tag_id
LEFT JOIN sn_snippet_dimension_content_excerpt_categories s7_ ON s1_ . id = s7_ . snippet_dimension_content_id
LEFT JOIN ca_categories c3_ ON c3_ . id = s7_ . category_id
LEFT JOIN ca_category_translations c4_ ON c3_ . id = c4_ . idCategories
AND (
c4_ . locale = c3_ . default_locale
OR c4_ . locale IN (? )
)
WHERE
s0_ . uuid = ?
AND s5_ . locale = ?
AND s5_ . stage = ?
AND s5_ . version = ?
AND (
(
(
s1_ . locale IS NULL
OR s1_ . locale IN (? )
)
AND (
s1_ . stage IS NULL
OR s1_ . stage IN (? )
)
)
AND (
s1_ . version IS NULL
OR s1_ . version IN (? )
)
)
Copy
SELECT s0_ . uuid AS uuid_0 , s0_ . created AS created_1 , s0_ . changed AS changed_2 , s1_ . title AS title_3 , s1_ . id AS id_4 , s1_ . stage AS stage_5 , s1_ . locale AS locale_6 , s1_ . ghostLocale AS ghostLocale_7 , s1_ . availableLocales AS availableLocales_8 , s1_ . version AS version_9 , s1_ . templateKey AS templateKey_10 , s1_ . templateData AS templateData_11 , s1_ . excerptSegment AS excerptSegment_12 , s1_ . workflowPlace AS workflowPlace_13 , s1_ . workflowPublished AS workflowPublished_14 , s1_ . created AS created_15 , s1_ . changed AS changed_16 , t2_ . name AS name_17 , t2_ . id AS id_18 , t2_ . created AS created_19 , t2_ . changed AS changed_20 , c3_ . category_key AS category_key_21 , c3_ . default_locale AS default_locale_22 , c3_ . lft AS lft_23 , c3_ . rgt AS rgt_24 , c3_ . depth AS depth_25 , c3_ . id AS id_26 , c3_ . created AS created_27 , c3_ . changed AS changed_28 , c4_ . translation AS translation_29 , c4_ . locale AS locale_30 , c4_ . description AS description_31 , c4_ . id AS id_32 , c4_ . created AS created_33 , c4_ . changed AS changed_34 , s0_ . idUsersCreator AS idUsersCreator_35 , s0_ . idUsersChanger AS idUsersChanger_36 , s1_ . snippetUuid AS snippetUuid_37 , s1_ . idUsersCreator AS idUsersCreator_38 , s1_ . idUsersChanger AS idUsersChanger_39 , t2_ . idUsersCreator AS idUsersCreator_40 , t2_ . idUsersChanger AS idUsersChanger_41 , c3_ . idCategoriesParent AS idCategoriesParent_42 , c3_ . idUsersCreator AS idUsersCreator_43 , c3_ . idUsersChanger AS idUsersChanger_44 , c4_ . idCategories AS idCategories_45 , c4_ . idUsersCreator AS idUsersCreator_46 , c4_ . idUsersChanger AS idUsersChanger_47 FROM sn_snippets s0_ LEFT JOIN sn_snippet_dimension_contents s5_ ON (s5_ . snippetUuid = s0_ . uuid ) LEFT JOIN sn_snippet_dimension_contents s1_ ON s0_ . uuid = s1_ . snippetUuid LEFT JOIN sn_snippet_dimension_content_excerpt_tags s6_ ON s1_ . id = s6_ . snippet_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_ . id = s6_ . tag_id LEFT JOIN sn_snippet_dimension_content_excerpt_categories s7_ ON s1_ . id = s7_ . snippet_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_ . id = s7_ . category_id LEFT JOIN ca_category_translations c4_ ON c3_ . id = c4_ . idCategories AND (c4_ . locale = c3_ . default_locale OR c4_ . locale IN ('bg' )) WHERE s0_ . uuid = '019ddd15-425a-7c95-839e-8ed4f4cd37cf' AND s5_ . locale = 'bg' AND s5_ . stage = 'live' AND s5_ . version = 0 AND (((s1_ . locale IS NULL OR s1_ . locale IN ('bg' )) AND (s1_ . stage IS NULL OR s1_ . stage IN ('live' ))) AND (s1_ . version IS NULL OR s1_ . version IN (0 )));
Copy
11
1.75 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_ . id AS id_26 , m3_ . created AS created_27 , m3_ . changed AS changed_28 , t4_ . name AS name_29 , t4_ . id AS id_30 , t4_ . created AS created_31 , t4_ . changed AS changed_32 , m5_ . title AS title_33 , m5_ . description AS description_34 , m5_ . copyright AS copyright_35 , m5_ . credits AS credits_36 , m5_ . locale AS locale_37 , m5_ . id AS id_38 , m6_ . title AS title_39 , m6_ . description AS description_40 , m6_ . copyright AS copyright_41 , m6_ . credits AS credits_42 , m6_ . locale AS locale_43 , m6_ . id AS id_44 , s7_ . username AS username_45 , s7_ . password AS password_46 , s7_ . locale AS locale_47 , s7_ . salt AS salt_48 , s7_ . locked AS locked_49 , s7_ . enabled AS enabled_50 , s7_ . lastLogin AS lastLogin_51 , s7_ . confirmationKey AS confirmationKey_52 , s7_ . passwordResetToken AS passwordResetToken_53 , s7_ . passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_54 , s7_ . passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_55 , s7_ . privateKey AS privateKey_56 , s7_ . apiKey AS apiKey_57 , s7_ . email AS email_58 , s7_ . id AS id_59 , s7_ . created AS created_60 , s7_ . changed AS changed_61 , c8_ . firstName AS firstName_62 , c8_ . middleName AS middleName_63 , c8_ . lastName AS lastName_64 , c8_ . birthday AS birthday_65 , c8_ . salutation AS salutation_66 , c8_ . formOfAddress AS formOfAddress_67 , c8_ . newsletter AS newsletter_68 , c8_ . gender AS gender_69 , c8_ . note AS note_70 , c8_ . mainEmail AS mainEmail_71 , c8_ . mainPhone AS mainPhone_72 , c8_ . mainFax AS mainFax_73 , c8_ . mainUrl AS mainUrl_74 , c8_ . id AS id_75 , c8_ . created AS created_76 , c8_ . changed AS changed_77 , s9_ . username AS username_78 , s9_ . password AS password_79 , s9_ . locale AS locale_80 , s9_ . salt AS salt_81 , s9_ . locked AS locked_82 , s9_ . enabled AS enabled_83 , s9_ . lastLogin AS lastLogin_84 , s9_ . confirmationKey AS confirmationKey_85 , s9_ . passwordResetToken AS passwordResetToken_86 , s9_ . passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_87 , s9_ . passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_88 , s9_ . privateKey AS privateKey_89 , s9_ . apiKey AS apiKey_90 , s9_ . email AS email_91 , s9_ . id AS id_92 , s9_ . created AS created_93 , s9_ . changed AS changed_94 , c10_ . firstName AS firstName_95 , c10_ . middleName AS middleName_96 , c10_ . lastName AS lastName_97 , c10_ . birthday AS birthday_98 , c10_ . salutation AS salutation_99 , c10_ . formOfAddress AS formOfAddress_100 , c10_ . newsletter AS newsletter_101 , c10_ . gender AS gender_102 , c10_ . note AS note_103 , c10_ . mainEmail AS mainEmail_104 , c10_ . mainPhone AS mainPhone_105 , c10_ . mainFax AS mainFax_106 , c10_ . mainUrl AS mainUrl_107 , c10_ . id AS id_108 , c10_ . created AS created_109 , c10_ . changed AS changed_110 , m0_ . idPreviewImage AS idPreviewImage_111 , m0_ . idCollections AS idCollections_112 , m0_ . idUsersCreator AS idUsersCreator_113 , m0_ . idUsersChanger AS idUsersChanger_114 , m1_ . idCollectionsMetaDefault AS idCollectionsMetaDefault_115 , m1_ . idCollectionTypes AS idCollectionTypes_116 , m1_ . idCollectionsParent AS idCollectionsParent_117 , m1_ . idUsersCreator AS idUsersCreator_118 , m1_ . idUsersChanger AS idUsersChanger_119 , m2_ . idMedia AS idMedia_120 , m2_ . idUsersCreator AS idUsersCreator_121 , m2_ . idUsersChanger AS idUsersChanger_122 , m3_ . idFileVersionsMetaDefault AS idFileVersionsMetaDefault_123 , m3_ . idFiles AS idFiles_124 , m3_ . idUsersCreator AS idUsersCreator_125 , m3_ . idUsersChanger AS idUsersChanger_126 , t4_ . idUsersCreator AS idUsersCreator_127 , t4_ . idUsersChanger AS idUsersChanger_128 , m5_ . idFileVersions AS idFileVersions_129 , m6_ . idFileVersions AS idFileVersions_130 , s7_ . idContacts AS idContacts_131 , s7_ . idUsersCreator AS idUsersCreator_132 , s7_ . idUsersChanger AS idUsersChanger_133 , c8_ . idTitles AS idTitles_134 , c8_ . avatar AS avatar_135 , c8_ . idUsersCreator AS idUsersCreator_136 , c8_ . idUsersChanger AS idUsersChanger_137 , s9_ . idContacts AS idContacts_138 , s9_ . idUsersCreator AS idUsersCreator_139 , s9_ . idUsersChanger AS idUsersChanger_140 , c10_ . idTitles AS idTitles_141 , c10_ . avatar AS avatar_142 , c10_ . idUsersCreator AS idUsersCreator_143 , c10_ . idUsersChanger AS idUsersChanger_144 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_ . idCollections = m1_ . id INNER JOIN me_files m2_ ON m0_ . id = m2_ . idMedia INNER JOIN me_file_versions m3_ ON m2_ . id = m3_ . idFiles AND (m3_ . version = m2_ . version ) LEFT JOIN me_file_version_tags m11_ ON m3_ . id = m11_ . idFileVersions LEFT JOIN ta_tags t4_ ON t4_ . id = m11_ . idTags LEFT JOIN me_file_version_meta m5_ ON m3_ . id = m5_ . idFileVersions LEFT JOIN me_file_version_meta m6_ ON m3_ . idFileVersionsMetaDefault = m6_ . id LEFT JOIN se_users s7_ ON m0_ . idUsersCreator = s7_ . id LEFT JOIN co_contacts c8_ ON s7_ . idContacts = c8_ . id LEFT JOIN se_users s9_ ON m0_ . idUsersChanger = s9_ . id LEFT JOIN co_contacts c10_ ON s9_ . idContacts = c10_ . id WHERE m0_ . id IN (? , ? , ? , ? , ? ) ORDER BY m0_ . id ASC
Parameters :
[
27
28
7
2
1
]
SELECT
m0_ . type AS type_0 ,
m0_ . id AS id_1 ,
m0_ . created AS created_2 ,
m0_ . changed AS changed_3 ,
m1_ . style AS style_4 ,
m1_ . lft AS lft_5 ,
m1_ . rgt AS rgt_6 ,
m1_ . depth AS depth_7 ,
m1_ . collection_key AS collection_key_8 ,
m1_ . id AS id_9 ,
m1_ . created AS created_10 ,
m1_ . changed AS changed_11 ,
m2_ . version AS version_12 ,
m2_ . id AS id_13 ,
m2_ . created AS created_14 ,
m2_ . changed AS changed_15 ,
m3_ . name AS name_16 ,
m3_ . version AS version_17 ,
m3_ . subVersion AS subVersion_18 ,
m3_ . size AS size_19 ,
m3_ . downloadCounter AS downloadCounter_20 ,
m3_ . storageOptions AS storageOptions_21 ,
m3_ . mimeType AS mimeType_22 ,
m3_ . properties AS properties_23 ,
m3_ . focusPointX AS focusPointX_24 ,
m3_ . focusPointY AS focusPointY_25 ,
m3_ . id AS id_26 ,
m3_ . created AS created_27 ,
m3_ . changed AS changed_28 ,
t4_ . name AS name_29 ,
t4_ . id AS id_30 ,
t4_ . created AS created_31 ,
t4_ . changed AS changed_32 ,
m5_ . title AS title_33 ,
m5_ . description AS description_34 ,
m5_ . copyright AS copyright_35 ,
m5_ . credits AS credits_36 ,
m5_ . locale AS locale_37 ,
m5_ . id AS id_38 ,
m6_ . title AS title_39 ,
m6_ . description AS description_40 ,
m6_ . copyright AS copyright_41 ,
m6_ . credits AS credits_42 ,
m6_ . locale AS locale_43 ,
m6_ . id AS id_44 ,
s7_ . username AS username_45 ,
s7_ . password AS password_46 ,
s7_ . locale AS locale_47 ,
s7_ . salt AS salt_48 ,
s7_ . locked AS locked_49 ,
s7_ . enabled AS enabled_50 ,
s7_ . lastLogin AS lastLogin_51 ,
s7_ . confirmationKey AS confirmationKey_52 ,
s7_ . passwordResetToken AS passwordResetToken_53 ,
s7_ . passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_54 ,
s7_ . passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_55 ,
s7_ . privateKey AS privateKey_56 ,
s7_ . apiKey AS apiKey_57 ,
s7_ . email AS email_58 ,
s7_ . id AS id_59 ,
s7_ . created AS created_60 ,
s7_ . changed AS changed_61 ,
c8_ . firstName AS firstName_62 ,
c8_ . middleName AS middleName_63 ,
c8_ . lastName AS lastName_64 ,
c8_ . birthday AS birthday_65 ,
c8_ . salutation AS salutation_66 ,
c8_ . formOfAddress AS formOfAddress_67 ,
c8_ . newsletter AS newsletter_68 ,
c8_ . gender AS gender_69 ,
c8_ . note AS note_70 ,
c8_ . mainEmail AS mainEmail_71 ,
c8_ . mainPhone AS mainPhone_72 ,
c8_ . mainFax AS mainFax_73 ,
c8_ . mainUrl AS mainUrl_74 ,
c8_ . id AS id_75 ,
c8_ . created AS created_76 ,
c8_ . changed AS changed_77 ,
s9_ . username AS username_78 ,
s9_ . password AS password_79 ,
s9_ . locale AS locale_80 ,
s9_ . salt AS salt_81 ,
s9_ . locked AS locked_82 ,
s9_ . enabled AS enabled_83 ,
s9_ . lastLogin AS lastLogin_84 ,
s9_ . confirmationKey AS confirmationKey_85 ,
s9_ . passwordResetToken AS passwordResetToken_86 ,
s9_ . passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_87 ,
s9_ . passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_88 ,
s9_ . privateKey AS privateKey_89 ,
s9_ . apiKey AS apiKey_90 ,
s9_ . email AS email_91 ,
s9_ . id AS id_92 ,
s9_ . created AS created_93 ,
s9_ . changed AS changed_94 ,
c10_ . firstName AS firstName_95 ,
c10_ . middleName AS middleName_96 ,
c10_ . lastName AS lastName_97 ,
c10_ . birthday AS birthday_98 ,
c10_ . salutation AS salutation_99 ,
c10_ . formOfAddress AS formOfAddress_100 ,
c10_ . newsletter AS newsletter_101 ,
c10_ . gender AS gender_102 ,
c10_ . note AS note_103 ,
c10_ . mainEmail AS mainEmail_104 ,
c10_ . mainPhone AS mainPhone_105 ,
c10_ . mainFax AS mainFax_106 ,
c10_ . mainUrl AS mainUrl_107 ,
c10_ . id AS id_108 ,
c10_ . created AS created_109 ,
c10_ . changed AS changed_110 ,
m0_ . idPreviewImage AS idPreviewImage_111 ,
m0_ . idCollections AS idCollections_112 ,
m0_ . idUsersCreator AS idUsersCreator_113 ,
m0_ . idUsersChanger AS idUsersChanger_114 ,
m1_ . idCollectionsMetaDefault AS idCollectionsMetaDefault_115 ,
m1_ . idCollectionTypes AS idCollectionTypes_116 ,
m1_ . idCollectionsParent AS idCollectionsParent_117 ,
m1_ . idUsersCreator AS idUsersCreator_118 ,
m1_ . idUsersChanger AS idUsersChanger_119 ,
m2_ . idMedia AS idMedia_120 ,
m2_ . idUsersCreator AS idUsersCreator_121 ,
m2_ . idUsersChanger AS idUsersChanger_122 ,
m3_ . idFileVersionsMetaDefault AS idFileVersionsMetaDefault_123 ,
m3_ . idFiles AS idFiles_124 ,
m3_ . idUsersCreator AS idUsersCreator_125 ,
m3_ . idUsersChanger AS idUsersChanger_126 ,
t4_ . idUsersCreator AS idUsersCreator_127 ,
t4_ . idUsersChanger AS idUsersChanger_128 ,
m5_ . idFileVersions AS idFileVersions_129 ,
m6_ . idFileVersions AS idFileVersions_130 ,
s7_ . idContacts AS idContacts_131 ,
s7_ . idUsersCreator AS idUsersCreator_132 ,
s7_ . idUsersChanger AS idUsersChanger_133 ,
c8_ . idTitles AS idTitles_134 ,
c8_ . avatar AS avatar_135 ,
c8_ . idUsersCreator AS idUsersCreator_136 ,
c8_ . idUsersChanger AS idUsersChanger_137 ,
s9_ . idContacts AS idContacts_138 ,
s9_ . idUsersCreator AS idUsersCreator_139 ,
s9_ . idUsersChanger AS idUsersChanger_140 ,
c10_ . idTitles AS idTitles_141 ,
c10_ . avatar AS avatar_142 ,
c10_ . idUsersCreator AS idUsersCreator_143 ,
c10_ . idUsersChanger AS idUsersChanger_144
FROM
me_media m0_
LEFT JOIN me_collections m1_ ON m0_ . idCollections = m1_ . id
INNER JOIN me_files m2_ ON m0_ . id = m2_ . idMedia
INNER JOIN me_file_versions m3_ ON m2_ . id = m3_ . idFiles
AND (m3_ . version = m2_ . version )
LEFT JOIN me_file_version_tags m11_ ON m3_ . id = m11_ . idFileVersions
LEFT JOIN ta_tags t4_ ON t4_ . id = m11_ . idTags
LEFT JOIN me_file_version_meta m5_ ON m3_ . id = m5_ . idFileVersions
LEFT JOIN me_file_version_meta m6_ ON m3_ . idFileVersionsMetaDefault = m6_ . id
LEFT JOIN se_users s7_ ON m0_ . idUsersCreator = s7_ . id
LEFT JOIN co_contacts c8_ ON s7_ . idContacts = c8_ . id
LEFT JOIN se_users s9_ ON m0_ . idUsersChanger = s9_ . id
LEFT JOIN co_contacts c10_ ON s9_ . idContacts = c10_ . id
WHERE
m0_ . id IN (? , ? , ? , ? , ? )
ORDER BY
m0_ . id ASC
Copy
SELECT m0_ . type AS type_0 , m0_ . id AS id_1 , m0_ . created AS created_2 , m0_ . changed AS changed_3 , m1_ . style AS style_4 , m1_ . lft AS lft_5 , m1_ . rgt AS rgt_6 , m1_ . depth AS depth_7 , m1_ . collection_key AS collection_key_8 , m1_ . id AS id_9 , m1_ . created AS created_10 , m1_ . changed AS changed_11 , m2_ . version AS version_12 , m2_ . id AS id_13 , m2_ . created AS created_14 , m2_ . changed AS changed_15 , m3_ . name AS name_16 , m3_ . version AS version_17 , m3_ . subVersion AS subVersion_18 , m3_ . size AS size_19 , m3_ . downloadCounter AS downloadCounter_20 , m3_ . storageOptions AS storageOptions_21 , m3_ . mimeType AS mimeType_22 , m3_ . properties AS properties_23 , m3_ . focusPointX AS focusPointX_24 , m3_ . focusPointY AS focusPointY_25 , m3_ . id AS id_26 , m3_ . created AS created_27 , m3_ . changed AS changed_28 , t4_ . name AS name_29 , t4_ . id AS id_30 , t4_ . created AS created_31 , t4_ . changed AS changed_32 , m5_ . title AS title_33 , m5_ . description AS description_34 , m5_ . copyright AS copyright_35 , m5_ . credits AS credits_36 , m5_ . locale AS locale_37 , m5_ . id AS id_38 , m6_ . title AS title_39 , m6_ . description AS description_40 , m6_ . copyright AS copyright_41 , m6_ . credits AS credits_42 , m6_ . locale AS locale_43 , m6_ . id AS id_44 , s7_ . username AS username_45 , s7_ . password AS password_46 , s7_ . locale AS locale_47 , s7_ . salt AS salt_48 , s7_ . locked AS locked_49 , s7_ . enabled AS enabled_50 , s7_ . lastLogin AS lastLogin_51 , s7_ . confirmationKey AS confirmationKey_52 , s7_ . passwordResetToken AS passwordResetToken_53 , s7_ . passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_54 , s7_ . passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_55 , s7_ . privateKey AS privateKey_56 , s7_ . apiKey AS apiKey_57 , s7_ . email AS email_58 , s7_ . id AS id_59 , s7_ . created AS created_60 , s7_ . changed AS changed_61 , c8_ . firstName AS firstName_62 , c8_ . middleName AS middleName_63 , c8_ . lastName AS lastName_64 , c8_ . birthday AS birthday_65 , c8_ . salutation AS salutation_66 , c8_ . formOfAddress AS formOfAddress_67 , c8_ . newsletter AS newsletter_68 , c8_ . gender AS gender_69 , c8_ . note AS note_70 , c8_ . mainEmail AS mainEmail_71 , c8_ . mainPhone AS mainPhone_72 , c8_ . mainFax AS mainFax_73 , c8_ . mainUrl AS mainUrl_74 , c8_ . id AS id_75 , c8_ . created AS created_76 , c8_ . changed AS changed_77 , s9_ . username AS username_78 , s9_ . password AS password_79 , s9_ . locale AS locale_80 , s9_ . salt AS salt_81 , s9_ . locked AS locked_82 , s9_ . enabled AS enabled_83 , s9_ . lastLogin AS lastLogin_84 , s9_ . confirmationKey AS confirmationKey_85 , s9_ . passwordResetToken AS passwordResetToken_86 , s9_ . passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_87 , s9_ . passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_88 , s9_ . privateKey AS privateKey_89 , s9_ . apiKey AS apiKey_90 , s9_ . email AS email_91 , s9_ . id AS id_92 , s9_ . created AS created_93 , s9_ . changed AS changed_94 , c10_ . firstName AS firstName_95 , c10_ . middleName AS middleName_96 , c10_ . lastName AS lastName_97 , c10_ . birthday AS birthday_98 , c10_ . salutation AS salutation_99 , c10_ . formOfAddress AS formOfAddress_100 , c10_ . newsletter AS newsletter_101 , c10_ . gender AS gender_102 , c10_ . note AS note_103 , c10_ . mainEmail AS mainEmail_104 , c10_ . mainPhone AS mainPhone_105 , c10_ . mainFax AS mainFax_106 , c10_ . mainUrl AS mainUrl_107 , c10_ . id AS id_108 , c10_ . created AS created_109 , c10_ . changed AS changed_110 , m0_ . idPreviewImage AS idPreviewImage_111 , m0_ . idCollections AS idCollections_112 , m0_ . idUsersCreator AS idUsersCreator_113 , m0_ . idUsersChanger AS idUsersChanger_114 , m1_ . idCollectionsMetaDefault AS idCollectionsMetaDefault_115 , m1_ . idCollectionTypes AS idCollectionTypes_116 , m1_ . idCollectionsParent AS idCollectionsParent_117 , m1_ . idUsersCreator AS idUsersCreator_118 , m1_ . idUsersChanger AS idUsersChanger_119 , m2_ . idMedia AS idMedia_120 , m2_ . idUsersCreator AS idUsersCreator_121 , m2_ . idUsersChanger AS idUsersChanger_122 , m3_ . idFileVersionsMetaDefault AS idFileVersionsMetaDefault_123 , m3_ . idFiles AS idFiles_124 , m3_ . idUsersCreator AS idUsersCreator_125 , m3_ . idUsersChanger AS idUsersChanger_126 , t4_ . idUsersCreator AS idUsersCreator_127 , t4_ . idUsersChanger AS idUsersChanger_128 , m5_ . idFileVersions AS idFileVersions_129 , m6_ . idFileVersions AS idFileVersions_130 , s7_ . idContacts AS idContacts_131 , s7_ . idUsersCreator AS idUsersCreator_132 , s7_ . idUsersChanger AS idUsersChanger_133 , c8_ . idTitles AS idTitles_134 , c8_ . avatar AS avatar_135 , c8_ . idUsersCreator AS idUsersCreator_136 , c8_ . idUsersChanger AS idUsersChanger_137 , s9_ . idContacts AS idContacts_138 , s9_ . idUsersCreator AS idUsersCreator_139 , s9_ . idUsersChanger AS idUsersChanger_140 , c10_ . idTitles AS idTitles_141 , c10_ . avatar AS avatar_142 , c10_ . idUsersCreator AS idUsersCreator_143 , c10_ . idUsersChanger AS idUsersChanger_144 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_ . idCollections = m1_ . id INNER JOIN me_files m2_ ON m0_ . id = m2_ . idMedia INNER JOIN me_file_versions m3_ ON m2_ . id = m3_ . idFiles AND (m3_ . version = m2_ . version ) LEFT JOIN me_file_version_tags m11_ ON m3_ . id = m11_ . idFileVersions LEFT JOIN ta_tags t4_ ON t4_ . id = m11_ . idTags LEFT JOIN me_file_version_meta m5_ ON m3_ . id = m5_ . idFileVersions LEFT JOIN me_file_version_meta m6_ ON m3_ . idFileVersionsMetaDefault = m6_ . id LEFT JOIN se_users s7_ ON m0_ . idUsersCreator = s7_ . id LEFT JOIN co_contacts c8_ ON s7_ . idContacts = c8_ . id LEFT JOIN se_users s9_ ON m0_ . idUsersChanger = s9_ . id LEFT JOIN co_contacts c10_ ON s9_ . idContacts = c10_ . id WHERE m0_ . id IN (27 , 28 , 7 , 2 , 1 ) ORDER BY m0_ . id ASC ;
Copy
12
0.39 ms
SELECT t0 . method AS method_1 , t0 . options AS options_2 , t0 . id AS id_3 , t0 . idUsers AS idUsers_4 FROM se_user_two_factors t0 WHERE t0 . idUsers = ?
SELECT t0 . method AS method_1 , t0 . options AS options_2 , t0 . id AS id_3 , t0 . idUsers AS idUsers_4 FROM se_user_two_factors t0 WHERE t0 . idUsers = 2 ;
Copy
13
2.70 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 :
[
"bg "
"dragoman "
1
"bg "
"live "
0
"bg "
"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
Copy
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 ('bg' )) 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 = 'dragoman' AND p0_ . depth < = 1 AND p7_ . locale = 'bg' AND p7_ . stage = 'live' AND p7_ . version = 0 AND (((p1_ . locale IS NULL OR p1_ . locale IN ('bg' )) 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 ;
Copy
14
3.53 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 :
[
"bg "
"dragoman "
2
"bg "
"live "
0
"bg "
"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
Copy
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 ('bg' )) 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 = 'dragoman' AND p0_ . depth < = 2 AND p7_ . locale = 'bg' AND p7_ . stage = 'live' AND p7_ . version = 0 AND (((p1_ . locale IS NULL OR p1_ . locale IN ('bg' )) 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 ;
Copy
15
1.03 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 , p0_ . parent_id AS parent_id_56 , p0_ . idUsersCreator AS idUsersCreator_57 , p0_ . idUsersChanger AS idUsersChanger_58 , p1_ . route_id AS route_id_59 , p1_ . pageUuid AS pageUuid_60 , p1_ . author_id AS author_id_61 , p1_ . idUsersCreator AS idUsersCreator_62 , p1_ . idUsersChanger AS idUsersChanger_63 , t2_ . idUsersCreator AS idUsersCreator_64 , t2_ . idUsersChanger AS idUsersChanger_65 , c3_ . idCategoriesParent AS idCategoriesParent_66 , c3_ . idUsersCreator AS idUsersCreator_67 , c3_ . idUsersChanger AS idUsersChanger_68 , c4_ . idCategories AS idCategories_69 , c4_ . idUsersCreator AS idUsersCreator_70 , c4_ . idUsersChanger AS idUsersChanger_71 , r5_ . parent_id AS parent_id_72 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p6_ ON (p6_ . pageUuid = p0_ . uuid ) LEFT JOIN pa_page_dimension_contents p1_ ON p0_ . uuid = p1_ . pageUuid LEFT JOIN pa_page_dimension_content_excerpt_tags p7_ ON p1_ . id = p7_ . page_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_ . id = p7_ . tag_id LEFT JOIN pa_page_dimension_content_excerpt_categories p8_ ON p1_ . id = p8_ . page_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_ . id = p8_ . 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 WHERE p0_ . uuid = ? AND p6_ . locale = ? AND p6_ . stage = ? AND p6_ . 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 (? )))
Parameters :
[
"bg "
"019ddd44-9a6a-7d54-b836-b9a92db6521f "
"bg "
"live "
0
"bg "
"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 ,
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 ,
p0_ . parent_id AS parent_id_56 ,
p0_ . idUsersCreator AS idUsersCreator_57 ,
p0_ . idUsersChanger AS idUsersChanger_58 ,
p1_ . route_id AS route_id_59 ,
p1_ . pageUuid AS pageUuid_60 ,
p1_ . author_id AS author_id_61 ,
p1_ . idUsersCreator AS idUsersCreator_62 ,
p1_ . idUsersChanger AS idUsersChanger_63 ,
t2_ . idUsersCreator AS idUsersCreator_64 ,
t2_ . idUsersChanger AS idUsersChanger_65 ,
c3_ . idCategoriesParent AS idCategoriesParent_66 ,
c3_ . idUsersCreator AS idUsersCreator_67 ,
c3_ . idUsersChanger AS idUsersChanger_68 ,
c4_ . idCategories AS idCategories_69 ,
c4_ . idUsersCreator AS idUsersCreator_70 ,
c4_ . idUsersChanger AS idUsersChanger_71 ,
r5_ . parent_id AS parent_id_72
FROM
pa_pages p0_
LEFT JOIN pa_page_dimension_contents p6_ ON (p6_ . pageUuid = p0_ . uuid )
LEFT JOIN pa_page_dimension_contents p1_ ON p0_ . uuid = p1_ . pageUuid
LEFT JOIN pa_page_dimension_content_excerpt_tags p7_ ON p1_ . id = p7_ . page_dimension_content_id
LEFT JOIN ta_tags t2_ ON t2_ . id = p7_ . tag_id
LEFT JOIN pa_page_dimension_content_excerpt_categories p8_ ON p1_ . id = p8_ . page_dimension_content_id
LEFT JOIN ca_categories c3_ ON c3_ . id = p8_ . 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
WHERE
p0_ . uuid = ?
AND p6_ . locale = ?
AND p6_ . stage = ?
AND p6_ . 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 (? )
)
)
Copy
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 , p0_ . parent_id AS parent_id_56 , p0_ . idUsersCreator AS idUsersCreator_57 , p0_ . idUsersChanger AS idUsersChanger_58 , p1_ . route_id AS route_id_59 , p1_ . pageUuid AS pageUuid_60 , p1_ . author_id AS author_id_61 , p1_ . idUsersCreator AS idUsersCreator_62 , p1_ . idUsersChanger AS idUsersChanger_63 , t2_ . idUsersCreator AS idUsersCreator_64 , t2_ . idUsersChanger AS idUsersChanger_65 , c3_ . idCategoriesParent AS idCategoriesParent_66 , c3_ . idUsersCreator AS idUsersCreator_67 , c3_ . idUsersChanger AS idUsersChanger_68 , c4_ . idCategories AS idCategories_69 , c4_ . idUsersCreator AS idUsersCreator_70 , c4_ . idUsersChanger AS idUsersChanger_71 , r5_ . parent_id AS parent_id_72 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p6_ ON (p6_ . pageUuid = p0_ . uuid ) LEFT JOIN pa_page_dimension_contents p1_ ON p0_ . uuid = p1_ . pageUuid LEFT JOIN pa_page_dimension_content_excerpt_tags p7_ ON p1_ . id = p7_ . page_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_ . id = p7_ . tag_id LEFT JOIN pa_page_dimension_content_excerpt_categories p8_ ON p1_ . id = p8_ . page_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_ . id = p8_ . category_id LEFT JOIN ca_category_translations c4_ ON c3_ . id = c4_ . idCategories AND (c4_ . locale = c3_ . default_locale OR c4_ . locale IN ('bg' )) LEFT JOIN ro_routes r5_ ON p1_ . route_id = r5_ . id WHERE p0_ . uuid = '019ddd44-9a6a-7d54-b836-b9a92db6521f' AND p6_ . locale = 'bg' AND p6_ . stage = 'live' AND p6_ . version = 0 AND (((p1_ . locale IS NULL OR p1_ . locale IN ('bg' )) AND (p1_ . stage IS NULL OR p1_ . stage IN ('live' ))) AND (p1_ . version IS NULL OR p1_ . version IN (0 )));
Copy
16
0.36 ms
SELECT p0_ . lft AS lft_0 , p0_ . rgt AS rgt_1 , p0_ . depth AS depth_2 FROM pa_pages p0_ WHERE p0_ . uuid = ?
Parameters :
[
"019ddd44-9a6a-7d54-b836-b9a92db6521f "
]
SELECT p0_ . lft AS lft_0 , p0_ . rgt AS rgt_1 , p0_ . depth AS depth_2 FROM pa_pages p0_ WHERE p0_ . uuid = '019ddd44-9a6a-7d54-b836-b9a92db6521f' ;
Copy
17
1.72 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 WHERE p0_ . lft > ? AND p0_ . rgt < ? AND p0_ . depth < = ? AND p0_ . webspaceKey = ? 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 (? ))) ORDER BY p0_ . lft ASC
Parameters :
[
"bg "
26
35
2
"dragoman "
"bg "
"live "
0
"bg "
"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 ,
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
WHERE
p0_ . lft > ?
AND p0_ . rgt < ?
AND p0_ . depth < = ?
AND p0_ . webspaceKey = ?
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 (? )
)
)
ORDER BY
p0_ . lft ASC
Copy
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 ('bg' )) 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 WHERE p0_ . lft > 26 AND p0_ . rgt < 35 AND p0_ . depth < = 2 AND p0_ . webspaceKey = 'dragoman' AND p7_ . locale = 'bg' AND p7_ . stage = 'live' AND p7_ . version = 0 AND (((p1_ . locale IS NULL OR p1_ . locale IN ('bg' )) AND (p1_ . stage IS NULL OR p1_ . stage IN ('live' ))) AND (p1_ . version IS NULL OR p1_ . version IN (0 ))) ORDER BY p0_ . lft ASC ;
Copy
18
0.42 ms
SELECT s0_ . webspace_key AS webspace_key_0 , s0_ . area_key AS area_key_1 , s0_ . uuid AS uuid_2 , s0_ . idSnippet AS idSnippet_3 FROM sn_snippet_area s0_ WHERE s0_ . webspace_key = ? AND s0_ . area_key = ?
Parameters :
[
"dragoman "
"default "
]
SELECT s0_ . webspace_key AS webspace_key_0 , s0_ . area_key AS area_key_1 , s0_ . uuid AS uuid_2 , s0_ . idSnippet AS idSnippet_3 FROM sn_snippet_area s0_ WHERE s0_ . webspace_key = 'dragoman' AND s0_ . area_key = 'default' ;
Copy
19
1.05 ms
SELECT s0_ . uuid AS uuid_0 , s0_ . created AS created_1 , s0_ . changed AS changed_2 , s1_ . title AS title_3 , s1_ . id AS id_4 , s1_ . stage AS stage_5 , s1_ . locale AS locale_6 , s1_ . ghostLocale AS ghostLocale_7 , s1_ . availableLocales AS availableLocales_8 , s1_ . version AS version_9 , s1_ . templateKey AS templateKey_10 , s1_ . templateData AS templateData_11 , s1_ . excerptSegment AS excerptSegment_12 , s1_ . workflowPlace AS workflowPlace_13 , s1_ . workflowPublished AS workflowPublished_14 , s1_ . created AS created_15 , s1_ . changed AS changed_16 , t2_ . name AS name_17 , t2_ . id AS id_18 , t2_ . created AS created_19 , t2_ . changed AS changed_20 , c3_ . category_key AS category_key_21 , c3_ . default_locale AS default_locale_22 , c3_ . lft AS lft_23 , c3_ . rgt AS rgt_24 , c3_ . depth AS depth_25 , c3_ . id AS id_26 , c3_ . created AS created_27 , c3_ . changed AS changed_28 , c4_ . translation AS translation_29 , c4_ . locale AS locale_30 , c4_ . description AS description_31 , c4_ . id AS id_32 , c4_ . created AS created_33 , c4_ . changed AS changed_34 , s0_ . idUsersCreator AS idUsersCreator_35 , s0_ . idUsersChanger AS idUsersChanger_36 , s1_ . snippetUuid AS snippetUuid_37 , s1_ . idUsersCreator AS idUsersCreator_38 , s1_ . idUsersChanger AS idUsersChanger_39 , t2_ . idUsersCreator AS idUsersCreator_40 , t2_ . idUsersChanger AS idUsersChanger_41 , c3_ . idCategoriesParent AS idCategoriesParent_42 , c3_ . idUsersCreator AS idUsersCreator_43 , c3_ . idUsersChanger AS idUsersChanger_44 , c4_ . idCategories AS idCategories_45 , c4_ . idUsersCreator AS idUsersCreator_46 , c4_ . idUsersChanger AS idUsersChanger_47 FROM sn_snippets s0_ LEFT JOIN sn_snippet_dimension_contents s5_ ON (s5_ . snippetUuid = s0_ . uuid ) LEFT JOIN sn_snippet_dimension_contents s1_ ON s0_ . uuid = s1_ . snippetUuid LEFT JOIN sn_snippet_dimension_content_excerpt_tags s6_ ON s1_ . id = s6_ . snippet_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_ . id = s6_ . tag_id LEFT JOIN sn_snippet_dimension_content_excerpt_categories s7_ ON s1_ . id = s7_ . snippet_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_ . id = s7_ . category_id LEFT JOIN ca_category_translations c4_ ON c3_ . id = c4_ . idCategories AND (c4_ . locale = c3_ . default_locale OR c4_ . locale IN (? )) WHERE s0_ . uuid = ? AND s5_ . locale = ? AND s5_ . stage = ? AND s5_ . version = ? AND (((s1_ . locale IS NULL OR s1_ . locale IN (? )) AND (s1_ . stage IS NULL OR s1_ . stage IN (? ))) AND (s1_ . version IS NULL OR s1_ . version IN (? )))
Parameters :
[
"bg "
"019ddd15-425a-7c95-839e-8ed4f4cd37cf "
"bg "
"live "
0
"bg "
"live "
0
]
SELECT
s0_ . uuid AS uuid_0 ,
s0_ . created AS created_1 ,
s0_ . changed AS changed_2 ,
s1_ . title AS title_3 ,
s1_ . id AS id_4 ,
s1_ . stage AS stage_5 ,
s1_ . locale AS locale_6 ,
s1_ . ghostLocale AS ghostLocale_7 ,
s1_ . availableLocales AS availableLocales_8 ,
s1_ . version AS version_9 ,
s1_ . templateKey AS templateKey_10 ,
s1_ . templateData AS templateData_11 ,
s1_ . excerptSegment AS excerptSegment_12 ,
s1_ . workflowPlace AS workflowPlace_13 ,
s1_ . workflowPublished AS workflowPublished_14 ,
s1_ . created AS created_15 ,
s1_ . changed AS changed_16 ,
t2_ . name AS name_17 ,
t2_ . id AS id_18 ,
t2_ . created AS created_19 ,
t2_ . changed AS changed_20 ,
c3_ . category_key AS category_key_21 ,
c3_ . default_locale AS default_locale_22 ,
c3_ . lft AS lft_23 ,
c3_ . rgt AS rgt_24 ,
c3_ . depth AS depth_25 ,
c3_ . id AS id_26 ,
c3_ . created AS created_27 ,
c3_ . changed AS changed_28 ,
c4_ . translation AS translation_29 ,
c4_ . locale AS locale_30 ,
c4_ . description AS description_31 ,
c4_ . id AS id_32 ,
c4_ . created AS created_33 ,
c4_ . changed AS changed_34 ,
s0_ . idUsersCreator AS idUsersCreator_35 ,
s0_ . idUsersChanger AS idUsersChanger_36 ,
s1_ . snippetUuid AS snippetUuid_37 ,
s1_ . idUsersCreator AS idUsersCreator_38 ,
s1_ . idUsersChanger AS idUsersChanger_39 ,
t2_ . idUsersCreator AS idUsersCreator_40 ,
t2_ . idUsersChanger AS idUsersChanger_41 ,
c3_ . idCategoriesParent AS idCategoriesParent_42 ,
c3_ . idUsersCreator AS idUsersCreator_43 ,
c3_ . idUsersChanger AS idUsersChanger_44 ,
c4_ . idCategories AS idCategories_45 ,
c4_ . idUsersCreator AS idUsersCreator_46 ,
c4_ . idUsersChanger AS idUsersChanger_47
FROM
sn_snippets s0_
LEFT JOIN sn_snippet_dimension_contents s5_ ON (s5_ . snippetUuid = s0_ . uuid )
LEFT JOIN sn_snippet_dimension_contents s1_ ON s0_ . uuid = s1_ . snippetUuid
LEFT JOIN sn_snippet_dimension_content_excerpt_tags s6_ ON s1_ . id = s6_ . snippet_dimension_content_id
LEFT JOIN ta_tags t2_ ON t2_ . id = s6_ . tag_id
LEFT JOIN sn_snippet_dimension_content_excerpt_categories s7_ ON s1_ . id = s7_ . snippet_dimension_content_id
LEFT JOIN ca_categories c3_ ON c3_ . id = s7_ . category_id
LEFT JOIN ca_category_translations c4_ ON c3_ . id = c4_ . idCategories
AND (
c4_ . locale = c3_ . default_locale
OR c4_ . locale IN (? )
)
WHERE
s0_ . uuid = ?
AND s5_ . locale = ?
AND s5_ . stage = ?
AND s5_ . version = ?
AND (
(
(
s1_ . locale IS NULL
OR s1_ . locale IN (? )
)
AND (
s1_ . stage IS NULL
OR s1_ . stage IN (? )
)
)
AND (
s1_ . version IS NULL
OR s1_ . version IN (? )
)
)
Copy
SELECT s0_ . uuid AS uuid_0 , s0_ . created AS created_1 , s0_ . changed AS changed_2 , s1_ . title AS title_3 , s1_ . id AS id_4 , s1_ . stage AS stage_5 , s1_ . locale AS locale_6 , s1_ . ghostLocale AS ghostLocale_7 , s1_ . availableLocales AS availableLocales_8 , s1_ . version AS version_9 , s1_ . templateKey AS templateKey_10 , s1_ . templateData AS templateData_11 , s1_ . excerptSegment AS excerptSegment_12 , s1_ . workflowPlace AS workflowPlace_13 , s1_ . workflowPublished AS workflowPublished_14 , s1_ . created AS created_15 , s1_ . changed AS changed_16 , t2_ . name AS name_17 , t2_ . id AS id_18 , t2_ . created AS created_19 , t2_ . changed AS changed_20 , c3_ . category_key AS category_key_21 , c3_ . default_locale AS default_locale_22 , c3_ . lft AS lft_23 , c3_ . rgt AS rgt_24 , c3_ . depth AS depth_25 , c3_ . id AS id_26 , c3_ . created AS created_27 , c3_ . changed AS changed_28 , c4_ . translation AS translation_29 , c4_ . locale AS locale_30 , c4_ . description AS description_31 , c4_ . id AS id_32 , c4_ . created AS created_33 , c4_ . changed AS changed_34 , s0_ . idUsersCreator AS idUsersCreator_35 , s0_ . idUsersChanger AS idUsersChanger_36 , s1_ . snippetUuid AS snippetUuid_37 , s1_ . idUsersCreator AS idUsersCreator_38 , s1_ . idUsersChanger AS idUsersChanger_39 , t2_ . idUsersCreator AS idUsersCreator_40 , t2_ . idUsersChanger AS idUsersChanger_41 , c3_ . idCategoriesParent AS idCategoriesParent_42 , c3_ . idUsersCreator AS idUsersCreator_43 , c3_ . idUsersChanger AS idUsersChanger_44 , c4_ . idCategories AS idCategories_45 , c4_ . idUsersCreator AS idUsersCreator_46 , c4_ . idUsersChanger AS idUsersChanger_47 FROM sn_snippets s0_ LEFT JOIN sn_snippet_dimension_contents s5_ ON (s5_ . snippetUuid = s0_ . uuid ) LEFT JOIN sn_snippet_dimension_contents s1_ ON s0_ . uuid = s1_ . snippetUuid LEFT JOIN sn_snippet_dimension_content_excerpt_tags s6_ ON s1_ . id = s6_ . snippet_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_ . id = s6_ . tag_id LEFT JOIN sn_snippet_dimension_content_excerpt_categories s7_ ON s1_ . id = s7_ . snippet_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_ . id = s7_ . category_id LEFT JOIN ca_category_translations c4_ ON c3_ . id = c4_ . idCategories AND (c4_ . locale = c3_ . default_locale OR c4_ . locale IN ('bg' )) WHERE s0_ . uuid = '019ddd15-425a-7c95-839e-8ed4f4cd37cf' AND s5_ . locale = 'bg' AND s5_ . stage = 'live' AND s5_ . version = 0 AND (((s1_ . locale IS NULL OR s1_ . locale IN ('bg' )) AND (s1_ . stage IS NULL OR s1_ . stage IN ('live' ))) AND (s1_ . version IS NULL OR s1_ . version IN (0 )));
Copy
20
0.36 ms
SELECT s0_ . webspace_key AS webspace_key_0 , s0_ . area_key AS area_key_1 , s0_ . uuid AS uuid_2 , s0_ . idSnippet AS idSnippet_3 FROM sn_snippet_area s0_ WHERE s0_ . webspace_key = ? AND s0_ . area_key = ?
Parameters :
[
"dragoman "
"default "
]
SELECT s0_ . webspace_key AS webspace_key_0 , s0_ . area_key AS area_key_1 , s0_ . uuid AS uuid_2 , s0_ . idSnippet AS idSnippet_3 FROM sn_snippet_area s0_ WHERE s0_ . webspace_key = 'dragoman' AND s0_ . area_key = 'default' ;
Copy
21
0.98 ms
SELECT s0_ . uuid AS uuid_0 , s0_ . created AS created_1 , s0_ . changed AS changed_2 , s1_ . title AS title_3 , s1_ . id AS id_4 , s1_ . stage AS stage_5 , s1_ . locale AS locale_6 , s1_ . ghostLocale AS ghostLocale_7 , s1_ . availableLocales AS availableLocales_8 , s1_ . version AS version_9 , s1_ . templateKey AS templateKey_10 , s1_ . templateData AS templateData_11 , s1_ . excerptSegment AS excerptSegment_12 , s1_ . workflowPlace AS workflowPlace_13 , s1_ . workflowPublished AS workflowPublished_14 , s1_ . created AS created_15 , s1_ . changed AS changed_16 , t2_ . name AS name_17 , t2_ . id AS id_18 , t2_ . created AS created_19 , t2_ . changed AS changed_20 , c3_ . category_key AS category_key_21 , c3_ . default_locale AS default_locale_22 , c3_ . lft AS lft_23 , c3_ . rgt AS rgt_24 , c3_ . depth AS depth_25 , c3_ . id AS id_26 , c3_ . created AS created_27 , c3_ . changed AS changed_28 , c4_ . translation AS translation_29 , c4_ . locale AS locale_30 , c4_ . description AS description_31 , c4_ . id AS id_32 , c4_ . created AS created_33 , c4_ . changed AS changed_34 , s0_ . idUsersCreator AS idUsersCreator_35 , s0_ . idUsersChanger AS idUsersChanger_36 , s1_ . snippetUuid AS snippetUuid_37 , s1_ . idUsersCreator AS idUsersCreator_38 , s1_ . idUsersChanger AS idUsersChanger_39 , t2_ . idUsersCreator AS idUsersCreator_40 , t2_ . idUsersChanger AS idUsersChanger_41 , c3_ . idCategoriesParent AS idCategoriesParent_42 , c3_ . idUsersCreator AS idUsersCreator_43 , c3_ . idUsersChanger AS idUsersChanger_44 , c4_ . idCategories AS idCategories_45 , c4_ . idUsersCreator AS idUsersCreator_46 , c4_ . idUsersChanger AS idUsersChanger_47 FROM sn_snippets s0_ LEFT JOIN sn_snippet_dimension_contents s5_ ON (s5_ . snippetUuid = s0_ . uuid ) LEFT JOIN sn_snippet_dimension_contents s1_ ON s0_ . uuid = s1_ . snippetUuid LEFT JOIN sn_snippet_dimension_content_excerpt_tags s6_ ON s1_ . id = s6_ . snippet_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_ . id = s6_ . tag_id LEFT JOIN sn_snippet_dimension_content_excerpt_categories s7_ ON s1_ . id = s7_ . snippet_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_ . id = s7_ . category_id LEFT JOIN ca_category_translations c4_ ON c3_ . id = c4_ . idCategories AND (c4_ . locale = c3_ . default_locale OR c4_ . locale IN (? )) WHERE s0_ . uuid = ? AND s5_ . locale = ? AND s5_ . stage = ? AND s5_ . version = ? AND (((s1_ . locale IS NULL OR s1_ . locale IN (? )) AND (s1_ . stage IS NULL OR s1_ . stage IN (? ))) AND (s1_ . version IS NULL OR s1_ . version IN (? )))
Parameters :
[
"bg "
"019ddd15-425a-7c95-839e-8ed4f4cd37cf "
"bg "
"live "
0
"bg "
"live "
0
]
SELECT
s0_ . uuid AS uuid_0 ,
s0_ . created AS created_1 ,
s0_ . changed AS changed_2 ,
s1_ . title AS title_3 ,
s1_ . id AS id_4 ,
s1_ . stage AS stage_5 ,
s1_ . locale AS locale_6 ,
s1_ . ghostLocale AS ghostLocale_7 ,
s1_ . availableLocales AS availableLocales_8 ,
s1_ . version AS version_9 ,
s1_ . templateKey AS templateKey_10 ,
s1_ . templateData AS templateData_11 ,
s1_ . excerptSegment AS excerptSegment_12 ,
s1_ . workflowPlace AS workflowPlace_13 ,
s1_ . workflowPublished AS workflowPublished_14 ,
s1_ . created AS created_15 ,
s1_ . changed AS changed_16 ,
t2_ . name AS name_17 ,
t2_ . id AS id_18 ,
t2_ . created AS created_19 ,
t2_ . changed AS changed_20 ,
c3_ . category_key AS category_key_21 ,
c3_ . default_locale AS default_locale_22 ,
c3_ . lft AS lft_23 ,
c3_ . rgt AS rgt_24 ,
c3_ . depth AS depth_25 ,
c3_ . id AS id_26 ,
c3_ . created AS created_27 ,
c3_ . changed AS changed_28 ,
c4_ . translation AS translation_29 ,
c4_ . locale AS locale_30 ,
c4_ . description AS description_31 ,
c4_ . id AS id_32 ,
c4_ . created AS created_33 ,
c4_ . changed AS changed_34 ,
s0_ . idUsersCreator AS idUsersCreator_35 ,
s0_ . idUsersChanger AS idUsersChanger_36 ,
s1_ . snippetUuid AS snippetUuid_37 ,
s1_ . idUsersCreator AS idUsersCreator_38 ,
s1_ . idUsersChanger AS idUsersChanger_39 ,
t2_ . idUsersCreator AS idUsersCreator_40 ,
t2_ . idUsersChanger AS idUsersChanger_41 ,
c3_ . idCategoriesParent AS idCategoriesParent_42 ,
c3_ . idUsersCreator AS idUsersCreator_43 ,
c3_ . idUsersChanger AS idUsersChanger_44 ,
c4_ . idCategories AS idCategories_45 ,
c4_ . idUsersCreator AS idUsersCreator_46 ,
c4_ . idUsersChanger AS idUsersChanger_47
FROM
sn_snippets s0_
LEFT JOIN sn_snippet_dimension_contents s5_ ON (s5_ . snippetUuid = s0_ . uuid )
LEFT JOIN sn_snippet_dimension_contents s1_ ON s0_ . uuid = s1_ . snippetUuid
LEFT JOIN sn_snippet_dimension_content_excerpt_tags s6_ ON s1_ . id = s6_ . snippet_dimension_content_id
LEFT JOIN ta_tags t2_ ON t2_ . id = s6_ . tag_id
LEFT JOIN sn_snippet_dimension_content_excerpt_categories s7_ ON s1_ . id = s7_ . snippet_dimension_content_id
LEFT JOIN ca_categories c3_ ON c3_ . id = s7_ . category_id
LEFT JOIN ca_category_translations c4_ ON c3_ . id = c4_ . idCategories
AND (
c4_ . locale = c3_ . default_locale
OR c4_ . locale IN (? )
)
WHERE
s0_ . uuid = ?
AND s5_ . locale = ?
AND s5_ . stage = ?
AND s5_ . version = ?
AND (
(
(
s1_ . locale IS NULL
OR s1_ . locale IN (? )
)
AND (
s1_ . stage IS NULL
OR s1_ . stage IN (? )
)
)
AND (
s1_ . version IS NULL
OR s1_ . version IN (? )
)
)
Copy
SELECT s0_ . uuid AS uuid_0 , s0_ . created AS created_1 , s0_ . changed AS changed_2 , s1_ . title AS title_3 , s1_ . id AS id_4 , s1_ . stage AS stage_5 , s1_ . locale AS locale_6 , s1_ . ghostLocale AS ghostLocale_7 , s1_ . availableLocales AS availableLocales_8 , s1_ . version AS version_9 , s1_ . templateKey AS templateKey_10 , s1_ . templateData AS templateData_11 , s1_ . excerptSegment AS excerptSegment_12 , s1_ . workflowPlace AS workflowPlace_13 , s1_ . workflowPublished AS workflowPublished_14 , s1_ . created AS created_15 , s1_ . changed AS changed_16 , t2_ . name AS name_17 , t2_ . id AS id_18 , t2_ . created AS created_19 , t2_ . changed AS changed_20 , c3_ . category_key AS category_key_21 , c3_ . default_locale AS default_locale_22 , c3_ . lft AS lft_23 , c3_ . rgt AS rgt_24 , c3_ . depth AS depth_25 , c3_ . id AS id_26 , c3_ . created AS created_27 , c3_ . changed AS changed_28 , c4_ . translation AS translation_29 , c4_ . locale AS locale_30 , c4_ . description AS description_31 , c4_ . id AS id_32 , c4_ . created AS created_33 , c4_ . changed AS changed_34 , s0_ . idUsersCreator AS idUsersCreator_35 , s0_ . idUsersChanger AS idUsersChanger_36 , s1_ . snippetUuid AS snippetUuid_37 , s1_ . idUsersCreator AS idUsersCreator_38 , s1_ . idUsersChanger AS idUsersChanger_39 , t2_ . idUsersCreator AS idUsersCreator_40 , t2_ . idUsersChanger AS idUsersChanger_41 , c3_ . idCategoriesParent AS idCategoriesParent_42 , c3_ . idUsersCreator AS idUsersCreator_43 , c3_ . idUsersChanger AS idUsersChanger_44 , c4_ . idCategories AS idCategories_45 , c4_ . idUsersCreator AS idUsersCreator_46 , c4_ . idUsersChanger AS idUsersChanger_47 FROM sn_snippets s0_ LEFT JOIN sn_snippet_dimension_contents s5_ ON (s5_ . snippetUuid = s0_ . uuid ) LEFT JOIN sn_snippet_dimension_contents s1_ ON s0_ . uuid = s1_ . snippetUuid LEFT JOIN sn_snippet_dimension_content_excerpt_tags s6_ ON s1_ . id = s6_ . snippet_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_ . id = s6_ . tag_id LEFT JOIN sn_snippet_dimension_content_excerpt_categories s7_ ON s1_ . id = s7_ . snippet_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_ . id = s7_ . category_id LEFT JOIN ca_category_translations c4_ ON c3_ . id = c4_ . idCategories AND (c4_ . locale = c3_ . default_locale OR c4_ . locale IN ('bg' )) WHERE s0_ . uuid = '019ddd15-425a-7c95-839e-8ed4f4cd37cf' AND s5_ . locale = 'bg' AND s5_ . stage = 'live' AND s5_ . version = 0 AND (((s1_ . locale IS NULL OR s1_ . locale IN ('bg' )) AND (s1_ . stage IS NULL OR s1_ . stage IN ('live' ))) AND (s1_ . version IS NULL OR s1_ . version IN (0 )));
Copy
22
1.71 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 :
[
"bg "
"dragoman "
1
"bg "
"live "
0
"bg "
"live "
0
"footer "
]
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
Copy
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 ('bg' )) 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 = 'dragoman' AND p0_ . depth < = 1 AND p7_ . locale = 'bg' AND p7_ . stage = 'live' AND p7_ . version = 0 AND (((p1_ . locale IS NULL OR p1_ . locale IN ('bg' )) AND (p1_ . stage IS NULL OR p1_ . stage IN ('live' ))) AND (p1_ . version IS NULL OR p1_ . version IN (0 ))) AND p10_ . name IN ('footer' ) ORDER BY p0_ . lft ASC ;
Copy
23
0.47 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 :
[
"dragoman.fxrm.eu/{localization} "
"dev "
"dragoman "
]
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 = 'dragoman.fxrm.eu/{localization}' AND w1_ . environment = 'dev' )) AND w0_ . webspace_key = 'dragoman' ORDER BY w0_ . id ASC ;
Copy