Symfony Profiler

Query Metrics

94 Database Queries
20 Different statements
15.66 ms Query time
0 Invalid entities
145 Managed entities
Queries


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
SELECT p0_.webspaceKey AS webspaceKey_0, p0_.lft AS lft_1, p0_.rgt AS rgt_2, p0_.depth AS depth_3, p0_.uuid AS uuid_4, p0_.created AS created_5, p0_.changed AS changed_6, p1_.title AS title_7, p1_.id AS id_8, p1_.stage AS stage_9, p1_.locale AS locale_10, p1_.ghostLocale AS ghostLocale_11, p1_.availableLocales AS availableLocales_12, p1_.version AS version_13, p1_.shadowLocale AS shadowLocale_14, p1_.shadowLocales AS shadowLocales_15, p1_.templateKey AS templateKey_16, p1_.templateData AS templateData_17, p1_.seoData AS seoData_18, p1_.seoNoIndex AS seoNoIndex_19, p1_.seoNoFollow AS seoNoFollow_20, p1_.seoHideInSitemap AS seoHideInSitemap_21, p1_.excerptData AS excerptData_22, p1_.excerptSegment AS excerptSegment_23, p1_.authored AS authored_24, p1_.lastModified AS lastModified_25, p1_.workflowPlace AS workflowPlace_26, p1_.workflowPublished AS workflowPublished_27, p1_.linkProvider AS linkProvider_28, p1_.linkData AS linkData_29, p1_.created AS created_30, p1_.changed AS changed_31, t2_.name AS name_32, t2_.id AS id_33, t2_.created AS created_34, t2_.changed AS changed_35, c3_.category_key AS category_key_36, c3_.default_locale AS default_locale_37, c3_.lft AS lft_38, c3_.rgt AS rgt_39, c3_.depth AS depth_40, c3_.id AS id_41, c3_.created AS created_42, c3_.changed AS changed_43, c4_.translation AS translation_44, c4_.locale AS locale_45, c4_.description AS description_46, c4_.id AS id_47, c4_.created AS created_48, c4_.changed AS changed_49, p0_.parent_id AS parent_id_50, p0_.idUsersCreator AS idUsersCreator_51, p0_.idUsersChanger AS idUsersChanger_52, p1_.route_id AS route_id_53, p1_.pageUuid AS pageUuid_54, p1_.author_id AS author_id_55, p1_.idUsersCreator AS idUsersCreator_56, p1_.idUsersChanger AS idUsersChanger_57, t2_.idUsersCreator AS idUsersCreator_58, t2_.idUsersChanger AS idUsersChanger_59, c3_.idCategoriesParent AS idCategoriesParent_60, c3_.idUsersCreator AS idUsersCreator_61, c3_.idUsersChanger AS idUsersChanger_62, c4_.idCategories AS idCategories_63, c4_.idUsersCreator AS idUsersCreator_64, c4_.idUsersChanger AS idUsersChanger_65 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid LEFT JOIN pa_page_dimension_content_excerpt_tags p5_ ON p1_.id = p5_.page_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = p5_.tag_id LEFT JOIN pa_page_dimension_content_excerpt_categories p6_ ON p1_.id = p6_.page_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = p6_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories AND (c4_.locale = c3_.default_locale OR c4_.locale IN (?)) WHERE p0_.uuid = ? AND (((p1_.locale IS NULL OR p1_.locale IN (?)) AND (p1_.stage IS NULL OR p1_.stage IN (?))) AND (p1_.version IS NULL OR p1_.version IN (?)))
SELECT 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 = ?
SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.style AS style_4, m1_.lft AS lft_5, m1_.rgt AS rgt_6, m1_.depth AS depth_7, m1_.collection_key AS collection_key_8, m1_.id AS id_9, m1_.created AS created_10, m1_.changed AS changed_11, m2_.version AS version_12, m2_.id AS id_13, m2_.created AS created_14, m2_.changed AS changed_15, m3_.name AS name_16, m3_.version AS version_17, m3_.subVersion AS subVersion_18, m3_.size AS size_19, m3_.downloadCounter AS downloadCounter_20, m3_.storageOptions AS storageOptions_21, m3_.mimeType AS mimeType_22, m3_.properties AS properties_23, m3_.focusPointX AS focusPointX_24, m3_.focusPointY AS focusPointY_25, m3_.origin AS origin_26, m3_.aiDisclosureDisabled AS aiDisclosureDisabled_27, m3_.aiDisclosureIconVariant AS aiDisclosureIconVariant_28, m3_.id AS id_29, m3_.created AS created_30, m3_.changed AS changed_31, t4_.name AS name_32, t4_.id AS id_33, t4_.created AS created_34, t4_.changed AS changed_35, m5_.title AS title_36, m5_.description AS description_37, m5_.aiDisclosureText AS aiDisclosureText_38, m5_.copyright AS copyright_39, m5_.credits AS credits_40, m5_.locale AS locale_41, m5_.id AS id_42, m6_.title AS title_43, m6_.description AS description_44, m6_.aiDisclosureText AS aiDisclosureText_45, m6_.copyright AS copyright_46, m6_.credits AS credits_47, m6_.locale AS locale_48, m6_.id AS id_49, s7_.username AS username_50, s7_.password AS password_51, s7_.locale AS locale_52, s7_.salt AS salt_53, s7_.locked AS locked_54, s7_.enabled AS enabled_55, s7_.lastLogin AS lastLogin_56, s7_.confirmationKey AS confirmationKey_57, s7_.passwordResetToken AS passwordResetToken_58, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_59, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_60, s7_.privateKey AS privateKey_61, s7_.apiKey AS apiKey_62, s7_.email AS email_63, s7_.id AS id_64, s7_.created AS created_65, s7_.changed AS changed_66, c8_.firstName AS firstName_67, c8_.middleName AS middleName_68, c8_.lastName AS lastName_69, c8_.birthday AS birthday_70, c8_.salutation AS salutation_71, c8_.formOfAddress AS formOfAddress_72, c8_.newsletter AS newsletter_73, c8_.gender AS gender_74, c8_.note AS note_75, c8_.mainEmail AS mainEmail_76, c8_.mainPhone AS mainPhone_77, c8_.mainFax AS mainFax_78, c8_.mainUrl AS mainUrl_79, c8_.id AS id_80, c8_.created AS created_81, c8_.changed AS changed_82, s9_.username AS username_83, s9_.password AS password_84, s9_.locale AS locale_85, s9_.salt AS salt_86, s9_.locked AS locked_87, s9_.enabled AS enabled_88, s9_.lastLogin AS lastLogin_89, s9_.confirmationKey AS confirmationKey_90, s9_.passwordResetToken AS passwordResetToken_91, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_92, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_93, s9_.privateKey AS privateKey_94, s9_.apiKey AS apiKey_95, s9_.email AS email_96, s9_.id AS id_97, s9_.created AS created_98, s9_.changed AS changed_99, c10_.firstName AS firstName_100, c10_.middleName AS middleName_101, c10_.lastName AS lastName_102, c10_.birthday AS birthday_103, c10_.salutation AS salutation_104, c10_.formOfAddress AS formOfAddress_105, c10_.newsletter AS newsletter_106, c10_.gender AS gender_107, c10_.note AS note_108, c10_.mainEmail AS mainEmail_109, c10_.mainPhone AS mainPhone_110, c10_.mainFax AS mainFax_111, c10_.mainUrl AS mainUrl_112, c10_.id AS id_113, c10_.created AS created_114, c10_.changed AS changed_115, m0_.idPreviewImage AS idPreviewImage_116, m0_.idCollections AS idCollections_117, m0_.idUsersCreator AS idUsersCreator_118, m0_.idUsersChanger AS idUsersChanger_119, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_120, m1_.idCollectionTypes AS idCollectionTypes_121, m1_.idCollectionsParent AS idCollectionsParent_122, m1_.idUsersCreator AS idUsersCreator_123, m1_.idUsersChanger AS idUsersChanger_124, m2_.idMedia AS idMedia_125, m2_.idUsersCreator AS idUsersCreator_126, m2_.idUsersChanger AS idUsersChanger_127, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_128, m3_.idFiles AS idFiles_129, m3_.idUsersCreator AS idUsersCreator_130, m3_.idUsersChanger AS idUsersChanger_131, t4_.idUsersCreator AS idUsersCreator_132, t4_.idUsersChanger AS idUsersChanger_133, m5_.idFileVersions AS idFileVersions_134, m6_.idFileVersions AS idFileVersions_135, s7_.idContacts AS idContacts_136, s7_.idUsersCreator AS idUsersCreator_137, s7_.idUsersChanger AS idUsersChanger_138, c8_.idTitles AS idTitles_139, c8_.avatar AS avatar_140, c8_.idUsersCreator AS idUsersCreator_141, c8_.idUsersChanger AS idUsersChanger_142, s9_.idContacts AS idContacts_143, s9_.idUsersCreator AS idUsersCreator_144, s9_.idUsersChanger AS idUsersChanger_145, c10_.idTitles AS idTitles_146, c10_.avatar AS avatar_147, c10_.idUsersCreator AS idUsersCreator_148, c10_.idUsersChanger AS idUsersChanger_149 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id INNER JOIN me_files m2_ ON m0_.id = m2_.idMedia INNER JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles AND (m3_.version = m2_.version) LEFT JOIN me_file_version_tags m11_ ON m3_.id = m11_.idFileVersions LEFT JOIN ta_tags t4_ ON t4_.id = m11_.idTags LEFT JOIN me_file_version_meta m5_ ON m3_.id = m5_.idFileVersions LEFT JOIN me_file_version_meta m6_ ON m3_.idFileVersionsMetaDefault = m6_.id LEFT JOIN se_users s7_ ON m0_.idUsersCreator = s7_.id LEFT JOIN co_contacts c8_ ON s7_.idContacts = c8_.id LEFT JOIN se_users s9_ ON m0_.idUsersChanger = s9_.id LEFT JOIN co_contacts c10_ ON s9_.idContacts = c10_.id WHERE m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY m0_.id ASC
SELECT 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 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 = ?
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 = ?
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 = ?
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 (?)))
SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.style AS style_4, m1_.lft AS lft_5, m1_.rgt AS rgt_6, m1_.depth AS depth_7, m1_.collection_key AS collection_key_8, m1_.id AS id_9, m1_.created AS created_10, m1_.changed AS changed_11, m2_.version AS version_12, m2_.id AS id_13, m2_.created AS created_14, m2_.changed AS changed_15, m3_.name AS name_16, m3_.version AS version_17, m3_.subVersion AS subVersion_18, m3_.size AS size_19, m3_.downloadCounter AS downloadCounter_20, m3_.storageOptions AS storageOptions_21, m3_.mimeType AS mimeType_22, m3_.properties AS properties_23, m3_.focusPointX AS focusPointX_24, m3_.focusPointY AS focusPointY_25, m3_.origin AS origin_26, m3_.aiDisclosureDisabled AS aiDisclosureDisabled_27, m3_.aiDisclosureIconVariant AS aiDisclosureIconVariant_28, m3_.id AS id_29, m3_.created AS created_30, m3_.changed AS changed_31, t4_.name AS name_32, t4_.id AS id_33, t4_.created AS created_34, t4_.changed AS changed_35, m5_.title AS title_36, m5_.description AS description_37, m5_.aiDisclosureText AS aiDisclosureText_38, m5_.copyright AS copyright_39, m5_.credits AS credits_40, m5_.locale AS locale_41, m5_.id AS id_42, m6_.title AS title_43, m6_.description AS description_44, m6_.aiDisclosureText AS aiDisclosureText_45, m6_.copyright AS copyright_46, m6_.credits AS credits_47, m6_.locale AS locale_48, m6_.id AS id_49, s7_.username AS username_50, s7_.password AS password_51, s7_.locale AS locale_52, s7_.salt AS salt_53, s7_.locked AS locked_54, s7_.enabled AS enabled_55, s7_.lastLogin AS lastLogin_56, s7_.confirmationKey AS confirmationKey_57, s7_.passwordResetToken AS passwordResetToken_58, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_59, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_60, s7_.privateKey AS privateKey_61, s7_.apiKey AS apiKey_62, s7_.email AS email_63, s7_.id AS id_64, s7_.created AS created_65, s7_.changed AS changed_66, c8_.firstName AS firstName_67, c8_.middleName AS middleName_68, c8_.lastName AS lastName_69, c8_.birthday AS birthday_70, c8_.salutation AS salutation_71, c8_.formOfAddress AS formOfAddress_72, c8_.newsletter AS newsletter_73, c8_.gender AS gender_74, c8_.note AS note_75, c8_.mainEmail AS mainEmail_76, c8_.mainPhone AS mainPhone_77, c8_.mainFax AS mainFax_78, c8_.mainUrl AS mainUrl_79, c8_.id AS id_80, c8_.created AS created_81, c8_.changed AS changed_82, s9_.username AS username_83, s9_.password AS password_84, s9_.locale AS locale_85, s9_.salt AS salt_86, s9_.locked AS locked_87, s9_.enabled AS enabled_88, s9_.lastLogin AS lastLogin_89, s9_.confirmationKey AS confirmationKey_90, s9_.passwordResetToken AS passwordResetToken_91, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_92, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_93, s9_.privateKey AS privateKey_94, s9_.apiKey AS apiKey_95, s9_.email AS email_96, s9_.id AS id_97, s9_.created AS created_98, s9_.changed AS changed_99, c10_.firstName AS firstName_100, c10_.middleName AS middleName_101, c10_.lastName AS lastName_102, c10_.birthday AS birthday_103, c10_.salutation AS salutation_104, c10_.formOfAddress AS formOfAddress_105, c10_.newsletter AS newsletter_106, c10_.gender AS gender_107, c10_.note AS note_108, c10_.mainEmail AS mainEmail_109, c10_.mainPhone AS mainPhone_110, c10_.mainFax AS mainFax_111, c10_.mainUrl AS mainUrl_112, c10_.id AS id_113, c10_.created AS created_114, c10_.changed AS changed_115, m0_.idPreviewImage AS idPreviewImage_116, m0_.idCollections AS idCollections_117, m0_.idUsersCreator AS idUsersCreator_118, m0_.idUsersChanger AS idUsersChanger_119, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_120, m1_.idCollectionTypes AS idCollectionTypes_121, m1_.idCollectionsParent AS idCollectionsParent_122, m1_.idUsersCreator AS idUsersCreator_123, m1_.idUsersChanger AS idUsersChanger_124, m2_.idMedia AS idMedia_125, m2_.idUsersCreator AS idUsersCreator_126, m2_.idUsersChanger AS idUsersChanger_127, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_128, m3_.idFiles AS idFiles_129, m3_.idUsersCreator AS idUsersCreator_130, m3_.idUsersChanger AS idUsersChanger_131, t4_.idUsersCreator AS idUsersCreator_132, t4_.idUsersChanger AS idUsersChanger_133, m5_.idFileVersions AS idFileVersions_134, m6_.idFileVersions AS idFileVersions_135, s7_.idContacts AS idContacts_136, s7_.idUsersCreator AS idUsersCreator_137, s7_.idUsersChanger AS idUsersChanger_138, c8_.idTitles AS idTitles_139, c8_.avatar AS avatar_140, c8_.idUsersCreator AS idUsersCreator_141, c8_.idUsersChanger AS idUsersChanger_142, s9_.idContacts AS idContacts_143, s9_.idUsersCreator AS idUsersCreator_144, s9_.idUsersChanger AS idUsersChanger_145, c10_.idTitles AS idTitles_146, c10_.avatar AS avatar_147, c10_.idUsersCreator AS idUsersCreator_148, c10_.idUsersChanger AS idUsersChanger_149 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id INNER JOIN me_files m2_ ON m0_.id = m2_.idMedia INNER JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles AND (m3_.version = m2_.version) LEFT JOIN me_file_version_tags m11_ ON m3_.id = m11_.idFileVersions LEFT JOIN ta_tags t4_ ON t4_.id = m11_.idTags LEFT JOIN me_file_version_meta m5_ ON m3_.id = m5_.idFileVersions LEFT JOIN me_file_version_meta m6_ ON m3_.idFileVersionsMetaDefault = m6_.id LEFT JOIN se_users s7_ ON m0_.idUsersCreator = s7_.id LEFT JOIN co_contacts c8_ ON s7_.idContacts = c8_.id LEFT JOIN se_users s9_ ON m0_.idUsersChanger = s9_.id LEFT JOIN co_contacts c10_ ON s9_.idContacts = c10_.id WHERE m0_.id IN (?, ?, ?, ?, ?, ?, ?) ORDER BY m0_.id ASC
SELECT 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 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 = ?
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 = ?
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 (?)))
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 = ?
SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.style AS style_4, m1_.lft AS lft_5, m1_.rgt AS rgt_6, m1_.depth AS depth_7, m1_.collection_key AS collection_key_8, m1_.id AS id_9, m1_.created AS created_10, m1_.changed AS changed_11, m2_.version AS version_12, m2_.id AS id_13, m2_.created AS created_14, m2_.changed AS changed_15, m3_.name AS name_16, m3_.version AS version_17, m3_.subVersion AS subVersion_18, m3_.size AS size_19, m3_.downloadCounter AS downloadCounter_20, m3_.storageOptions AS storageOptions_21, m3_.mimeType AS mimeType_22, m3_.properties AS properties_23, m3_.focusPointX AS focusPointX_24, m3_.focusPointY AS focusPointY_25, m3_.origin AS origin_26, m3_.aiDisclosureDisabled AS aiDisclosureDisabled_27, m3_.aiDisclosureIconVariant AS aiDisclosureIconVariant_28, m3_.id AS id_29, m3_.created AS created_30, m3_.changed AS changed_31, t4_.name AS name_32, t4_.id AS id_33, t4_.created AS created_34, t4_.changed AS changed_35, m5_.title AS title_36, m5_.description AS description_37, m5_.aiDisclosureText AS aiDisclosureText_38, m5_.copyright AS copyright_39, m5_.credits AS credits_40, m5_.locale AS locale_41, m5_.id AS id_42, m6_.title AS title_43, m6_.description AS description_44, m6_.aiDisclosureText AS aiDisclosureText_45, m6_.copyright AS copyright_46, m6_.credits AS credits_47, m6_.locale AS locale_48, m6_.id AS id_49, s7_.username AS username_50, s7_.password AS password_51, s7_.locale AS locale_52, s7_.salt AS salt_53, s7_.locked AS locked_54, s7_.enabled AS enabled_55, s7_.lastLogin AS lastLogin_56, s7_.confirmationKey AS confirmationKey_57, s7_.passwordResetToken AS passwordResetToken_58, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_59, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_60, s7_.privateKey AS privateKey_61, s7_.apiKey AS apiKey_62, s7_.email AS email_63, s7_.id AS id_64, s7_.created AS created_65, s7_.changed AS changed_66, c8_.firstName AS firstName_67, c8_.middleName AS middleName_68, c8_.lastName AS lastName_69, c8_.birthday AS birthday_70, c8_.salutation AS salutation_71, c8_.formOfAddress AS formOfAddress_72, c8_.newsletter AS newsletter_73, c8_.gender AS gender_74, c8_.note AS note_75, c8_.mainEmail AS mainEmail_76, c8_.mainPhone AS mainPhone_77, c8_.mainFax AS mainFax_78, c8_.mainUrl AS mainUrl_79, c8_.id AS id_80, c8_.created AS created_81, c8_.changed AS changed_82, s9_.username AS username_83, s9_.password AS password_84, s9_.locale AS locale_85, s9_.salt AS salt_86, s9_.locked AS locked_87, s9_.enabled AS enabled_88, s9_.lastLogin AS lastLogin_89, s9_.confirmationKey AS confirmationKey_90, s9_.passwordResetToken AS passwordResetToken_91, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_92, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_93, s9_.privateKey AS privateKey_94, s9_.apiKey AS apiKey_95, s9_.email AS email_96, s9_.id AS id_97, s9_.created AS created_98, s9_.changed AS changed_99, c10_.firstName AS firstName_100, c10_.middleName AS middleName_101, c10_.lastName AS lastName_102, c10_.birthday AS birthday_103, c10_.salutation AS salutation_104, c10_.formOfAddress AS formOfAddress_105, c10_.newsletter AS newsletter_106, c10_.gender AS gender_107, c10_.note AS note_108, c10_.mainEmail AS mainEmail_109, c10_.mainPhone AS mainPhone_110, c10_.mainFax AS mainFax_111, c10_.mainUrl AS mainUrl_112, c10_.id AS id_113, c10_.created AS created_114, c10_.changed AS changed_115, m0_.idPreviewImage AS idPreviewImage_116, m0_.idCollections AS idCollections_117, m0_.idUsersCreator AS idUsersCreator_118, m0_.idUsersChanger AS idUsersChanger_119, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_120, m1_.idCollectionTypes AS idCollectionTypes_121, m1_.idCollectionsParent AS idCollectionsParent_122, m1_.idUsersCreator AS idUsersCreator_123, m1_.idUsersChanger AS idUsersChanger_124, m2_.idMedia AS idMedia_125, m2_.idUsersCreator AS idUsersCreator_126, m2_.idUsersChanger AS idUsersChanger_127, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_128, m3_.idFiles AS idFiles_129, m3_.idUsersCreator AS idUsersCreator_130, m3_.idUsersChanger AS idUsersChanger_131, t4_.idUsersCreator AS idUsersCreator_132, t4_.idUsersChanger AS idUsersChanger_133, m5_.idFileVersions AS idFileVersions_134, m6_.idFileVersions AS idFileVersions_135, s7_.idContacts AS idContacts_136, s7_.idUsersCreator AS idUsersCreator_137, s7_.idUsersChanger AS idUsersChanger_138, c8_.idTitles AS idTitles_139, c8_.avatar AS avatar_140, c8_.idUsersCreator AS idUsersCreator_141, c8_.idUsersChanger AS idUsersChanger_142, s9_.idContacts AS idContacts_143, s9_.idUsersCreator AS idUsersCreator_144, s9_.idUsersChanger AS idUsersChanger_145, c10_.idTitles AS idTitles_146, c10_.avatar AS avatar_147, c10_.idUsersCreator AS idUsersCreator_148, c10_.idUsersChanger AS idUsersChanger_149 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id INNER JOIN me_files m2_ ON m0_.id = m2_.idMedia INNER JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles AND (m3_.version = m2_.version) LEFT JOIN me_file_version_tags m11_ ON m3_.id = m11_.idFileVersions LEFT JOIN ta_tags t4_ ON t4_.id = m11_.idTags LEFT JOIN me_file_version_meta m5_ ON m3_.id = m5_.idFileVersions LEFT JOIN me_file_version_meta m6_ ON m3_.idFileVersionsMetaDefault = m6_.id LEFT JOIN se_users s7_ ON m0_.idUsersCreator = s7_.id LEFT JOIN co_contacts c8_ ON s7_.idContacts = c8_.id LEFT JOIN se_users s9_ ON m0_.idUsersChanger = s9_.id LEFT JOIN co_contacts c10_ ON s9_.idContacts = c10_.id WHERE m0_.id IN (?, ?) ORDER BY m0_.id ASC
SELECT 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 = ?
SELECT webspaceKey FROM pa_pages WHERE uuid = ? LIMIT 1
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 = ?
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 (?)))
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 = ?
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 (?)))
SELECT page.uuid FROM ro_routes route INNER JOIN pa_page_dimension_contents dc ON dc.route_id = route.id INNER JOIN pa_pages page ON page.uuid = dc.pageUuid WHERE route.slug = ? AND route.locale = ? AND (? IS NULL OR route.webspace = ?) AND dc.stage = 'live' LIMIT 1
SELECT dc.title, route.slug, page.webspaceKey AS webspace,
           dc.templateData, dc.linkProvider, dc.linkData, dc.seoData, dc.authored
    FROM pa_pages page
    INNER JOIN pa_pages parent ON parent.uuid = page.parent_id
    INNER JOIN pa_page_dimension_contents dc ON dc.pageUuid = page.uuid
    INNER JOIN ro_routes route ON route.id = dc.route_id
    WHERE parent.uuid = ?
      AND dc.locale = ?
      AND dc.stage = 'live'
      AND route.slug IS NOT NULL
    ORDER BY CASE
                 WHEN JSON_EXTRACT(dc.templateData, '$.displayOrder')
                      IS NULL THEN 1 ELSE 0
             END,
             CAST(JSON_EXTRACT(dc.templateData, '$.displayOrder')
                  AS SIGNED),
             page.lft
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 = ?
SELECT webspaceKey FROM pa_pages WHERE uuid = ? LIMIT 1
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 = ?
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 (?)))
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 = ?
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 (?)))
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 = ?
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 (?)))
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 = ?
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 (?)))
SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.style AS style_4, m1_.lft AS lft_5, m1_.rgt AS rgt_6, m1_.depth AS depth_7, m1_.collection_key AS collection_key_8, m1_.id AS id_9, m1_.created AS created_10, m1_.changed AS changed_11, m2_.version AS version_12, m2_.id AS id_13, m2_.created AS created_14, m2_.changed AS changed_15, m3_.name AS name_16, m3_.version AS version_17, m3_.subVersion AS subVersion_18, m3_.size AS size_19, m3_.downloadCounter AS downloadCounter_20, m3_.storageOptions AS storageOptions_21, m3_.mimeType AS mimeType_22, m3_.properties AS properties_23, m3_.focusPointX AS focusPointX_24, m3_.focusPointY AS focusPointY_25, m3_.origin AS origin_26, m3_.aiDisclosureDisabled AS aiDisclosureDisabled_27, m3_.aiDisclosureIconVariant AS aiDisclosureIconVariant_28, m3_.id AS id_29, m3_.created AS created_30, m3_.changed AS changed_31, m4_.crop_x AS crop_x_32, m4_.crop_y AS crop_y_33, m4_.crop_width AS crop_width_34, m4_.crop_height AS crop_height_35, m4_.format_key AS format_key_36, m5_.title AS title_37, m5_.description AS description_38, m5_.aiDisclosureText AS aiDisclosureText_39, m5_.copyright AS copyright_40, m5_.credits AS credits_41, m5_.locale AS locale_42, m5_.id AS id_43, m6_.title AS title_44, m6_.description AS description_45, m6_.aiDisclosureText AS aiDisclosureText_46, m6_.copyright AS copyright_47, m6_.credits AS credits_48, m6_.locale AS locale_49, m6_.id AS id_50, s7_.username AS username_51, s7_.password AS password_52, s7_.locale AS locale_53, s7_.salt AS salt_54, s7_.locked AS locked_55, s7_.enabled AS enabled_56, s7_.lastLogin AS lastLogin_57, s7_.confirmationKey AS confirmationKey_58, s7_.passwordResetToken AS passwordResetToken_59, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_60, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_61, s7_.privateKey AS privateKey_62, s7_.apiKey AS apiKey_63, s7_.email AS email_64, s7_.id AS id_65, s7_.created AS created_66, s7_.changed AS changed_67, c8_.firstName AS firstName_68, c8_.middleName AS middleName_69, c8_.lastName AS lastName_70, c8_.birthday AS birthday_71, c8_.salutation AS salutation_72, c8_.formOfAddress AS formOfAddress_73, c8_.newsletter AS newsletter_74, c8_.gender AS gender_75, c8_.note AS note_76, c8_.mainEmail AS mainEmail_77, c8_.mainPhone AS mainPhone_78, c8_.mainFax AS mainFax_79, c8_.mainUrl AS mainUrl_80, c8_.id AS id_81, c8_.created AS created_82, c8_.changed AS changed_83, s9_.username AS username_84, s9_.password AS password_85, s9_.locale AS locale_86, s9_.salt AS salt_87, s9_.locked AS locked_88, s9_.enabled AS enabled_89, s9_.lastLogin AS lastLogin_90, s9_.confirmationKey AS confirmationKey_91, s9_.passwordResetToken AS passwordResetToken_92, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_93, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_94, s9_.privateKey AS privateKey_95, s9_.apiKey AS apiKey_96, s9_.email AS email_97, s9_.id AS id_98, s9_.created AS created_99, s9_.changed AS changed_100, c10_.firstName AS firstName_101, c10_.middleName AS middleName_102, c10_.lastName AS lastName_103, c10_.birthday AS birthday_104, c10_.salutation AS salutation_105, c10_.formOfAddress AS formOfAddress_106, c10_.newsletter AS newsletter_107, c10_.gender AS gender_108, c10_.note AS note_109, c10_.mainEmail AS mainEmail_110, c10_.mainPhone AS mainPhone_111, c10_.mainFax AS mainFax_112, c10_.mainUrl AS mainUrl_113, c10_.id AS id_114, c10_.created AS created_115, c10_.changed AS changed_116, m11_.type AS type_117, m11_.id AS id_118, m11_.created AS created_119, m11_.changed AS changed_120, m0_.idPreviewImage AS idPreviewImage_121, m0_.idCollections AS idCollections_122, m0_.idUsersCreator AS idUsersCreator_123, m0_.idUsersChanger AS idUsersChanger_124, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_125, m1_.idCollectionTypes AS idCollectionTypes_126, m1_.idCollectionsParent AS idCollectionsParent_127, m1_.idUsersCreator AS idUsersCreator_128, m1_.idUsersChanger AS idUsersChanger_129, m2_.idMedia AS idMedia_130, m2_.idUsersCreator AS idUsersCreator_131, m2_.idUsersChanger AS idUsersChanger_132, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_133, m3_.idFiles AS idFiles_134, m3_.idUsersCreator AS idUsersCreator_135, m3_.idUsersChanger AS idUsersChanger_136, m4_.fileVersion AS fileVersion_137, m5_.idFileVersions AS idFileVersions_138, m6_.idFileVersions AS idFileVersions_139, s7_.idContacts AS idContacts_140, s7_.idUsersCreator AS idUsersCreator_141, s7_.idUsersChanger AS idUsersChanger_142, c8_.idTitles AS idTitles_143, c8_.avatar AS avatar_144, c8_.idUsersCreator AS idUsersCreator_145, c8_.idUsersChanger AS idUsersChanger_146, s9_.idContacts AS idContacts_147, s9_.idUsersCreator AS idUsersCreator_148, s9_.idUsersChanger AS idUsersChanger_149, c10_.idTitles AS idTitles_150, c10_.avatar AS avatar_151, c10_.idUsersCreator AS idUsersCreator_152, c10_.idUsersChanger AS idUsersChanger_153, m11_.idPreviewImage AS idPreviewImage_154, m11_.idCollections AS idCollections_155, m11_.idUsersCreator AS idUsersCreator_156, m11_.idUsersChanger AS idUsersChanger_157 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id LEFT JOIN me_files m2_ ON m0_.id = m2_.idMedia LEFT JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles LEFT JOIN me_format_options m4_ ON m3_.id = m4_.fileVersion 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 LEFT JOIN me_media m11_ ON m0_.idPreviewImage = m11_.id WHERE m0_.id = ?
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 = ?
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 (?)))
SELECT m0_.id AS id_0, m1_.version AS version_1, m1_.name AS name_2, m2_.title AS title_3, m3_.title AS title_4 FROM me_media m0_ LEFT JOIN me_files m4_ ON m0_.id = m4_.idMedia LEFT JOIN me_file_versions m1_ ON m4_.id = m1_.idFiles AND (m1_.version = m4_.version) LEFT JOIN me_file_version_meta m3_ ON m1_.idFileVersionsMetaDefault = m3_.id LEFT JOIN me_file_version_meta m2_ ON m1_.id = m2_.idFileVersions AND (m2_.locale = ?) WHERE m0_.id IN (?)
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 = ?
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 = ?
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 (?)))
SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.style AS style_4, m1_.lft AS lft_5, m1_.rgt AS rgt_6, m1_.depth AS depth_7, m1_.collection_key AS collection_key_8, m1_.id AS id_9, m1_.created AS created_10, m1_.changed AS changed_11, m2_.version AS version_12, m2_.id AS id_13, m2_.created AS created_14, m2_.changed AS changed_15, m3_.name AS name_16, m3_.version AS version_17, m3_.subVersion AS subVersion_18, m3_.size AS size_19, m3_.downloadCounter AS downloadCounter_20, m3_.storageOptions AS storageOptions_21, m3_.mimeType AS mimeType_22, m3_.properties AS properties_23, m3_.focusPointX AS focusPointX_24, m3_.focusPointY AS focusPointY_25, m3_.origin AS origin_26, m3_.aiDisclosureDisabled AS aiDisclosureDisabled_27, m3_.aiDisclosureIconVariant AS aiDisclosureIconVariant_28, m3_.id AS id_29, m3_.created AS created_30, m3_.changed AS changed_31, m4_.crop_x AS crop_x_32, m4_.crop_y AS crop_y_33, m4_.crop_width AS crop_width_34, m4_.crop_height AS crop_height_35, m4_.format_key AS format_key_36, m5_.title AS title_37, m5_.description AS description_38, m5_.aiDisclosureText AS aiDisclosureText_39, m5_.copyright AS copyright_40, m5_.credits AS credits_41, m5_.locale AS locale_42, m5_.id AS id_43, m6_.title AS title_44, m6_.description AS description_45, m6_.aiDisclosureText AS aiDisclosureText_46, m6_.copyright AS copyright_47, m6_.credits AS credits_48, m6_.locale AS locale_49, m6_.id AS id_50, s7_.username AS username_51, s7_.password AS password_52, s7_.locale AS locale_53, s7_.salt AS salt_54, s7_.locked AS locked_55, s7_.enabled AS enabled_56, s7_.lastLogin AS lastLogin_57, s7_.confirmationKey AS confirmationKey_58, s7_.passwordResetToken AS passwordResetToken_59, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_60, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_61, s7_.privateKey AS privateKey_62, s7_.apiKey AS apiKey_63, s7_.email AS email_64, s7_.id AS id_65, s7_.created AS created_66, s7_.changed AS changed_67, c8_.firstName AS firstName_68, c8_.middleName AS middleName_69, c8_.lastName AS lastName_70, c8_.birthday AS birthday_71, c8_.salutation AS salutation_72, c8_.formOfAddress AS formOfAddress_73, c8_.newsletter AS newsletter_74, c8_.gender AS gender_75, c8_.note AS note_76, c8_.mainEmail AS mainEmail_77, c8_.mainPhone AS mainPhone_78, c8_.mainFax AS mainFax_79, c8_.mainUrl AS mainUrl_80, c8_.id AS id_81, c8_.created AS created_82, c8_.changed AS changed_83, s9_.username AS username_84, s9_.password AS password_85, s9_.locale AS locale_86, s9_.salt AS salt_87, s9_.locked AS locked_88, s9_.enabled AS enabled_89, s9_.lastLogin AS lastLogin_90, s9_.confirmationKey AS confirmationKey_91, s9_.passwordResetToken AS passwordResetToken_92, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_93, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_94, s9_.privateKey AS privateKey_95, s9_.apiKey AS apiKey_96, s9_.email AS email_97, s9_.id AS id_98, s9_.created AS created_99, s9_.changed AS changed_100, c10_.firstName AS firstName_101, c10_.middleName AS middleName_102, c10_.lastName AS lastName_103, c10_.birthday AS birthday_104, c10_.salutation AS salutation_105, c10_.formOfAddress AS formOfAddress_106, c10_.newsletter AS newsletter_107, c10_.gender AS gender_108, c10_.note AS note_109, c10_.mainEmail AS mainEmail_110, c10_.mainPhone AS mainPhone_111, c10_.mainFax AS mainFax_112, c10_.mainUrl AS mainUrl_113, c10_.id AS id_114, c10_.created AS created_115, c10_.changed AS changed_116, m11_.type AS type_117, m11_.id AS id_118, m11_.created AS created_119, m11_.changed AS changed_120, m0_.idPreviewImage AS idPreviewImage_121, m0_.idCollections AS idCollections_122, m0_.idUsersCreator AS idUsersCreator_123, m0_.idUsersChanger AS idUsersChanger_124, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_125, m1_.idCollectionTypes AS idCollectionTypes_126, m1_.idCollectionsParent AS idCollectionsParent_127, m1_.idUsersCreator AS idUsersCreator_128, m1_.idUsersChanger AS idUsersChanger_129, m2_.idMedia AS idMedia_130, m2_.idUsersCreator AS idUsersCreator_131, m2_.idUsersChanger AS idUsersChanger_132, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_133, m3_.idFiles AS idFiles_134, m3_.idUsersCreator AS idUsersCreator_135, m3_.idUsersChanger AS idUsersChanger_136, m4_.fileVersion AS fileVersion_137, m5_.idFileVersions AS idFileVersions_138, m6_.idFileVersions AS idFileVersions_139, s7_.idContacts AS idContacts_140, s7_.idUsersCreator AS idUsersCreator_141, s7_.idUsersChanger AS idUsersChanger_142, c8_.idTitles AS idTitles_143, c8_.avatar AS avatar_144, c8_.idUsersCreator AS idUsersCreator_145, c8_.idUsersChanger AS idUsersChanger_146, s9_.idContacts AS idContacts_147, s9_.idUsersCreator AS idUsersCreator_148, s9_.idUsersChanger AS idUsersChanger_149, c10_.idTitles AS idTitles_150, c10_.avatar AS avatar_151, c10_.idUsersCreator AS idUsersCreator_152, c10_.idUsersChanger AS idUsersChanger_153, m11_.idPreviewImage AS idPreviewImage_154, m11_.idCollections AS idCollections_155, m11_.idUsersCreator AS idUsersCreator_156, m11_.idUsersChanger AS idUsersChanger_157 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id LEFT JOIN me_files m2_ ON m0_.id = m2_.idMedia LEFT JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles LEFT JOIN me_format_options m4_ ON m3_.id = m4_.fileVersion 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 LEFT JOIN me_media m11_ ON m0_.idPreviewImage = m11_.id WHERE m0_.id = ?
SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.style AS style_4, m1_.lft AS lft_5, m1_.rgt AS rgt_6, m1_.depth AS depth_7, m1_.collection_key AS collection_key_8, m1_.id AS id_9, m1_.created AS created_10, m1_.changed AS changed_11, m2_.version AS version_12, m2_.id AS id_13, m2_.created AS created_14, m2_.changed AS changed_15, m3_.name AS name_16, m3_.version AS version_17, m3_.subVersion AS subVersion_18, m3_.size AS size_19, m3_.downloadCounter AS downloadCounter_20, m3_.storageOptions AS storageOptions_21, m3_.mimeType AS mimeType_22, m3_.properties AS properties_23, m3_.focusPointX AS focusPointX_24, m3_.focusPointY AS focusPointY_25, m3_.origin AS origin_26, m3_.aiDisclosureDisabled AS aiDisclosureDisabled_27, m3_.aiDisclosureIconVariant AS aiDisclosureIconVariant_28, m3_.id AS id_29, m3_.created AS created_30, m3_.changed AS changed_31, m4_.crop_x AS crop_x_32, m4_.crop_y AS crop_y_33, m4_.crop_width AS crop_width_34, m4_.crop_height AS crop_height_35, m4_.format_key AS format_key_36, m5_.title AS title_37, m5_.description AS description_38, m5_.aiDisclosureText AS aiDisclosureText_39, m5_.copyright AS copyright_40, m5_.credits AS credits_41, m5_.locale AS locale_42, m5_.id AS id_43, m6_.title AS title_44, m6_.description AS description_45, m6_.aiDisclosureText AS aiDisclosureText_46, m6_.copyright AS copyright_47, m6_.credits AS credits_48, m6_.locale AS locale_49, m6_.id AS id_50, s7_.username AS username_51, s7_.password AS password_52, s7_.locale AS locale_53, s7_.salt AS salt_54, s7_.locked AS locked_55, s7_.enabled AS enabled_56, s7_.lastLogin AS lastLogin_57, s7_.confirmationKey AS confirmationKey_58, s7_.passwordResetToken AS passwordResetToken_59, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_60, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_61, s7_.privateKey AS privateKey_62, s7_.apiKey AS apiKey_63, s7_.email AS email_64, s7_.id AS id_65, s7_.created AS created_66, s7_.changed AS changed_67, c8_.firstName AS firstName_68, c8_.middleName AS middleName_69, c8_.lastName AS lastName_70, c8_.birthday AS birthday_71, c8_.salutation AS salutation_72, c8_.formOfAddress AS formOfAddress_73, c8_.newsletter AS newsletter_74, c8_.gender AS gender_75, c8_.note AS note_76, c8_.mainEmail AS mainEmail_77, c8_.mainPhone AS mainPhone_78, c8_.mainFax AS mainFax_79, c8_.mainUrl AS mainUrl_80, c8_.id AS id_81, c8_.created AS created_82, c8_.changed AS changed_83, s9_.username AS username_84, s9_.password AS password_85, s9_.locale AS locale_86, s9_.salt AS salt_87, s9_.locked AS locked_88, s9_.enabled AS enabled_89, s9_.lastLogin AS lastLogin_90, s9_.confirmationKey AS confirmationKey_91, s9_.passwordResetToken AS passwordResetToken_92, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_93, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_94, s9_.privateKey AS privateKey_95, s9_.apiKey AS apiKey_96, s9_.email AS email_97, s9_.id AS id_98, s9_.created AS created_99, s9_.changed AS changed_100, c10_.firstName AS firstName_101, c10_.middleName AS middleName_102, c10_.lastName AS lastName_103, c10_.birthday AS birthday_104, c10_.salutation AS salutation_105, c10_.formOfAddress AS formOfAddress_106, c10_.newsletter AS newsletter_107, c10_.gender AS gender_108, c10_.note AS note_109, c10_.mainEmail AS mainEmail_110, c10_.mainPhone AS mainPhone_111, c10_.mainFax AS mainFax_112, c10_.mainUrl AS mainUrl_113, c10_.id AS id_114, c10_.created AS created_115, c10_.changed AS changed_116, m11_.type AS type_117, m11_.id AS id_118, m11_.created AS created_119, m11_.changed AS changed_120, m0_.idPreviewImage AS idPreviewImage_121, m0_.idCollections AS idCollections_122, m0_.idUsersCreator AS idUsersCreator_123, m0_.idUsersChanger AS idUsersChanger_124, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_125, m1_.idCollectionTypes AS idCollectionTypes_126, m1_.idCollectionsParent AS idCollectionsParent_127, m1_.idUsersCreator AS idUsersCreator_128, m1_.idUsersChanger AS idUsersChanger_129, m2_.idMedia AS idMedia_130, m2_.idUsersCreator AS idUsersCreator_131, m2_.idUsersChanger AS idUsersChanger_132, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_133, m3_.idFiles AS idFiles_134, m3_.idUsersCreator AS idUsersCreator_135, m3_.idUsersChanger AS idUsersChanger_136, m4_.fileVersion AS fileVersion_137, m5_.idFileVersions AS idFileVersions_138, m6_.idFileVersions AS idFileVersions_139, s7_.idContacts AS idContacts_140, s7_.idUsersCreator AS idUsersCreator_141, s7_.idUsersChanger AS idUsersChanger_142, c8_.idTitles AS idTitles_143, c8_.avatar AS avatar_144, c8_.idUsersCreator AS idUsersCreator_145, c8_.idUsersChanger AS idUsersChanger_146, s9_.idContacts AS idContacts_147, s9_.idUsersCreator AS idUsersCreator_148, s9_.idUsersChanger AS idUsersChanger_149, c10_.idTitles AS idTitles_150, c10_.avatar AS avatar_151, c10_.idUsersCreator AS idUsersCreator_152, c10_.idUsersChanger AS idUsersChanger_153, m11_.idPreviewImage AS idPreviewImage_154, m11_.idCollections AS idCollections_155, m11_.idUsersCreator AS idUsersCreator_156, m11_.idUsersChanger AS idUsersChanger_157 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id LEFT JOIN me_files m2_ ON m0_.id = m2_.idMedia LEFT JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles LEFT JOIN me_format_options m4_ ON m3_.id = m4_.fileVersion 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 LEFT JOIN me_media m11_ ON m0_.idPreviewImage = m11_.id WHERE m0_.id = ?
SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.style AS style_4, m1_.lft AS lft_5, m1_.rgt AS rgt_6, m1_.depth AS depth_7, m1_.collection_key AS collection_key_8, m1_.id AS id_9, m1_.created AS created_10, m1_.changed AS changed_11, m2_.version AS version_12, m2_.id AS id_13, m2_.created AS created_14, m2_.changed AS changed_15, m3_.name AS name_16, m3_.version AS version_17, m3_.subVersion AS subVersion_18, m3_.size AS size_19, m3_.downloadCounter AS downloadCounter_20, m3_.storageOptions AS storageOptions_21, m3_.mimeType AS mimeType_22, m3_.properties AS properties_23, m3_.focusPointX AS focusPointX_24, m3_.focusPointY AS focusPointY_25, m3_.origin AS origin_26, m3_.aiDisclosureDisabled AS aiDisclosureDisabled_27, m3_.aiDisclosureIconVariant AS aiDisclosureIconVariant_28, m3_.id AS id_29, m3_.created AS created_30, m3_.changed AS changed_31, m4_.crop_x AS crop_x_32, m4_.crop_y AS crop_y_33, m4_.crop_width AS crop_width_34, m4_.crop_height AS crop_height_35, m4_.format_key AS format_key_36, m5_.title AS title_37, m5_.description AS description_38, m5_.aiDisclosureText AS aiDisclosureText_39, m5_.copyright AS copyright_40, m5_.credits AS credits_41, m5_.locale AS locale_42, m5_.id AS id_43, m6_.title AS title_44, m6_.description AS description_45, m6_.aiDisclosureText AS aiDisclosureText_46, m6_.copyright AS copyright_47, m6_.credits AS credits_48, m6_.locale AS locale_49, m6_.id AS id_50, s7_.username AS username_51, s7_.password AS password_52, s7_.locale AS locale_53, s7_.salt AS salt_54, s7_.locked AS locked_55, s7_.enabled AS enabled_56, s7_.lastLogin AS lastLogin_57, s7_.confirmationKey AS confirmationKey_58, s7_.passwordResetToken AS passwordResetToken_59, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_60, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_61, s7_.privateKey AS privateKey_62, s7_.apiKey AS apiKey_63, s7_.email AS email_64, s7_.id AS id_65, s7_.created AS created_66, s7_.changed AS changed_67, c8_.firstName AS firstName_68, c8_.middleName AS middleName_69, c8_.lastName AS lastName_70, c8_.birthday AS birthday_71, c8_.salutation AS salutation_72, c8_.formOfAddress AS formOfAddress_73, c8_.newsletter AS newsletter_74, c8_.gender AS gender_75, c8_.note AS note_76, c8_.mainEmail AS mainEmail_77, c8_.mainPhone AS mainPhone_78, c8_.mainFax AS mainFax_79, c8_.mainUrl AS mainUrl_80, c8_.id AS id_81, c8_.created AS created_82, c8_.changed AS changed_83, s9_.username AS username_84, s9_.password AS password_85, s9_.locale AS locale_86, s9_.salt AS salt_87, s9_.locked AS locked_88, s9_.enabled AS enabled_89, s9_.lastLogin AS lastLogin_90, s9_.confirmationKey AS confirmationKey_91, s9_.passwordResetToken AS passwordResetToken_92, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_93, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_94, s9_.privateKey AS privateKey_95, s9_.apiKey AS apiKey_96, s9_.email AS email_97, s9_.id AS id_98, s9_.created AS created_99, s9_.changed AS changed_100, c10_.firstName AS firstName_101, c10_.middleName AS middleName_102, c10_.lastName AS lastName_103, c10_.birthday AS birthday_104, c10_.salutation AS salutation_105, c10_.formOfAddress AS formOfAddress_106, c10_.newsletter AS newsletter_107, c10_.gender AS gender_108, c10_.note AS note_109, c10_.mainEmail AS mainEmail_110, c10_.mainPhone AS mainPhone_111, c10_.mainFax AS mainFax_112, c10_.mainUrl AS mainUrl_113, c10_.id AS id_114, c10_.created AS created_115, c10_.changed AS changed_116, m11_.type AS type_117, m11_.id AS id_118, m11_.created AS created_119, m11_.changed AS changed_120, m0_.idPreviewImage AS idPreviewImage_121, m0_.idCollections AS idCollections_122, m0_.idUsersCreator AS idUsersCreator_123, m0_.idUsersChanger AS idUsersChanger_124, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_125, m1_.idCollectionTypes AS idCollectionTypes_126, m1_.idCollectionsParent AS idCollectionsParent_127, m1_.idUsersCreator AS idUsersCreator_128, m1_.idUsersChanger AS idUsersChanger_129, m2_.idMedia AS idMedia_130, m2_.idUsersCreator AS idUsersCreator_131, m2_.idUsersChanger AS idUsersChanger_132, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_133, m3_.idFiles AS idFiles_134, m3_.idUsersCreator AS idUsersCreator_135, m3_.idUsersChanger AS idUsersChanger_136, m4_.fileVersion AS fileVersion_137, m5_.idFileVersions AS idFileVersions_138, m6_.idFileVersions AS idFileVersions_139, s7_.idContacts AS idContacts_140, s7_.idUsersCreator AS idUsersCreator_141, s7_.idUsersChanger AS idUsersChanger_142, c8_.idTitles AS idTitles_143, c8_.avatar AS avatar_144, c8_.idUsersCreator AS idUsersCreator_145, c8_.idUsersChanger AS idUsersChanger_146, s9_.idContacts AS idContacts_147, s9_.idUsersCreator AS idUsersCreator_148, s9_.idUsersChanger AS idUsersChanger_149, c10_.idTitles AS idTitles_150, c10_.avatar AS avatar_151, c10_.idUsersCreator AS idUsersCreator_152, c10_.idUsersChanger AS idUsersChanger_153, m11_.idPreviewImage AS idPreviewImage_154, m11_.idCollections AS idCollections_155, m11_.idUsersCreator AS idUsersCreator_156, m11_.idUsersChanger AS idUsersChanger_157 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id LEFT JOIN me_files m2_ ON m0_.id = m2_.idMedia LEFT JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles LEFT JOIN me_format_options m4_ ON m3_.id = m4_.fileVersion 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 LEFT JOIN me_media m11_ ON m0_.idPreviewImage = m11_.id WHERE m0_.id = ?
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 = ?
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 (?)))
SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.style AS style_4, m1_.lft AS lft_5, m1_.rgt AS rgt_6, m1_.depth AS depth_7, m1_.collection_key AS collection_key_8, m1_.id AS id_9, m1_.created AS created_10, m1_.changed AS changed_11, m2_.version AS version_12, m2_.id AS id_13, m2_.created AS created_14, m2_.changed AS changed_15, m3_.name AS name_16, m3_.version AS version_17, m3_.subVersion AS subVersion_18, m3_.size AS size_19, m3_.downloadCounter AS downloadCounter_20, m3_.storageOptions AS storageOptions_21, m3_.mimeType AS mimeType_22, m3_.properties AS properties_23, m3_.focusPointX AS focusPointX_24, m3_.focusPointY AS focusPointY_25, m3_.origin AS origin_26, m3_.aiDisclosureDisabled AS aiDisclosureDisabled_27, m3_.aiDisclosureIconVariant AS aiDisclosureIconVariant_28, m3_.id AS id_29, m3_.created AS created_30, m3_.changed AS changed_31, t4_.name AS name_32, t4_.id AS id_33, t4_.created AS created_34, t4_.changed AS changed_35, m5_.title AS title_36, m5_.description AS description_37, m5_.aiDisclosureText AS aiDisclosureText_38, m5_.copyright AS copyright_39, m5_.credits AS credits_40, m5_.locale AS locale_41, m5_.id AS id_42, m6_.title AS title_43, m6_.description AS description_44, m6_.aiDisclosureText AS aiDisclosureText_45, m6_.copyright AS copyright_46, m6_.credits AS credits_47, m6_.locale AS locale_48, m6_.id AS id_49, s7_.username AS username_50, s7_.password AS password_51, s7_.locale AS locale_52, s7_.salt AS salt_53, s7_.locked AS locked_54, s7_.enabled AS enabled_55, s7_.lastLogin AS lastLogin_56, s7_.confirmationKey AS confirmationKey_57, s7_.passwordResetToken AS passwordResetToken_58, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_59, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_60, s7_.privateKey AS privateKey_61, s7_.apiKey AS apiKey_62, s7_.email AS email_63, s7_.id AS id_64, s7_.created AS created_65, s7_.changed AS changed_66, c8_.firstName AS firstName_67, c8_.middleName AS middleName_68, c8_.lastName AS lastName_69, c8_.birthday AS birthday_70, c8_.salutation AS salutation_71, c8_.formOfAddress AS formOfAddress_72, c8_.newsletter AS newsletter_73, c8_.gender AS gender_74, c8_.note AS note_75, c8_.mainEmail AS mainEmail_76, c8_.mainPhone AS mainPhone_77, c8_.mainFax AS mainFax_78, c8_.mainUrl AS mainUrl_79, c8_.id AS id_80, c8_.created AS created_81, c8_.changed AS changed_82, s9_.username AS username_83, s9_.password AS password_84, s9_.locale AS locale_85, s9_.salt AS salt_86, s9_.locked AS locked_87, s9_.enabled AS enabled_88, s9_.lastLogin AS lastLogin_89, s9_.confirmationKey AS confirmationKey_90, s9_.passwordResetToken AS passwordResetToken_91, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_92, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_93, s9_.privateKey AS privateKey_94, s9_.apiKey AS apiKey_95, s9_.email AS email_96, s9_.id AS id_97, s9_.created AS created_98, s9_.changed AS changed_99, c10_.firstName AS firstName_100, c10_.middleName AS middleName_101, c10_.lastName AS lastName_102, c10_.birthday AS birthday_103, c10_.salutation AS salutation_104, c10_.formOfAddress AS formOfAddress_105, c10_.newsletter AS newsletter_106, c10_.gender AS gender_107, c10_.note AS note_108, c10_.mainEmail AS mainEmail_109, c10_.mainPhone AS mainPhone_110, c10_.mainFax AS mainFax_111, c10_.mainUrl AS mainUrl_112, c10_.id AS id_113, c10_.created AS created_114, c10_.changed AS changed_115, m0_.idPreviewImage AS idPreviewImage_116, m0_.idCollections AS idCollections_117, m0_.idUsersCreator AS idUsersCreator_118, m0_.idUsersChanger AS idUsersChanger_119, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_120, m1_.idCollectionTypes AS idCollectionTypes_121, m1_.idCollectionsParent AS idCollectionsParent_122, m1_.idUsersCreator AS idUsersCreator_123, m1_.idUsersChanger AS idUsersChanger_124, m2_.idMedia AS idMedia_125, m2_.idUsersCreator AS idUsersCreator_126, m2_.idUsersChanger AS idUsersChanger_127, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_128, m3_.idFiles AS idFiles_129, m3_.idUsersCreator AS idUsersCreator_130, m3_.idUsersChanger AS idUsersChanger_131, t4_.idUsersCreator AS idUsersCreator_132, t4_.idUsersChanger AS idUsersChanger_133, m5_.idFileVersions AS idFileVersions_134, m6_.idFileVersions AS idFileVersions_135, s7_.idContacts AS idContacts_136, s7_.idUsersCreator AS idUsersCreator_137, s7_.idUsersChanger AS idUsersChanger_138, c8_.idTitles AS idTitles_139, c8_.avatar AS avatar_140, c8_.idUsersCreator AS idUsersCreator_141, c8_.idUsersChanger AS idUsersChanger_142, s9_.idContacts AS idContacts_143, s9_.idUsersCreator AS idUsersCreator_144, s9_.idUsersChanger AS idUsersChanger_145, c10_.idTitles AS idTitles_146, c10_.avatar AS avatar_147, c10_.idUsersCreator AS idUsersCreator_148, c10_.idUsersChanger AS idUsersChanger_149 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id INNER JOIN me_files m2_ ON m0_.id = m2_.idMedia INNER JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles AND (m3_.version = m2_.version) LEFT JOIN me_file_version_tags m11_ ON m3_.id = m11_.idFileVersions LEFT JOIN ta_tags t4_ ON t4_.id = m11_.idTags LEFT JOIN me_file_version_meta m5_ ON m3_.id = m5_.idFileVersions LEFT JOIN me_file_version_meta m6_ ON m3_.idFileVersionsMetaDefault = m6_.id LEFT JOIN se_users s7_ ON m0_.idUsersCreator = s7_.id LEFT JOIN co_contacts c8_ ON s7_.idContacts = c8_.id LEFT JOIN se_users s9_ ON m0_.idUsersChanger = s9_.id LEFT JOIN co_contacts c10_ ON s9_.idContacts = c10_.id WHERE m0_.id IN (?, ?, ?) ORDER BY m0_.id ASC
SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.style AS style_4, m1_.lft AS lft_5, m1_.rgt AS rgt_6, m1_.depth AS depth_7, m1_.collection_key AS collection_key_8, m1_.id AS id_9, m1_.created AS created_10, m1_.changed AS changed_11, m2_.version AS version_12, m2_.id AS id_13, m2_.created AS created_14, m2_.changed AS changed_15, m3_.name AS name_16, m3_.version AS version_17, m3_.subVersion AS subVersion_18, m3_.size AS size_19, m3_.downloadCounter AS downloadCounter_20, m3_.storageOptions AS storageOptions_21, m3_.mimeType AS mimeType_22, m3_.properties AS properties_23, m3_.focusPointX AS focusPointX_24, m3_.focusPointY AS focusPointY_25, m3_.origin AS origin_26, m3_.aiDisclosureDisabled AS aiDisclosureDisabled_27, m3_.aiDisclosureIconVariant AS aiDisclosureIconVariant_28, m3_.id AS id_29, m3_.created AS created_30, m3_.changed AS changed_31, m4_.crop_x AS crop_x_32, m4_.crop_y AS crop_y_33, m4_.crop_width AS crop_width_34, m4_.crop_height AS crop_height_35, m4_.format_key AS format_key_36, m5_.title AS title_37, m5_.description AS description_38, m5_.aiDisclosureText AS aiDisclosureText_39, m5_.copyright AS copyright_40, m5_.credits AS credits_41, m5_.locale AS locale_42, m5_.id AS id_43, m6_.title AS title_44, m6_.description AS description_45, m6_.aiDisclosureText AS aiDisclosureText_46, m6_.copyright AS copyright_47, m6_.credits AS credits_48, m6_.locale AS locale_49, m6_.id AS id_50, s7_.username AS username_51, s7_.password AS password_52, s7_.locale AS locale_53, s7_.salt AS salt_54, s7_.locked AS locked_55, s7_.enabled AS enabled_56, s7_.lastLogin AS lastLogin_57, s7_.confirmationKey AS confirmationKey_58, s7_.passwordResetToken AS passwordResetToken_59, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_60, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_61, s7_.privateKey AS privateKey_62, s7_.apiKey AS apiKey_63, s7_.email AS email_64, s7_.id AS id_65, s7_.created AS created_66, s7_.changed AS changed_67, c8_.firstName AS firstName_68, c8_.middleName AS middleName_69, c8_.lastName AS lastName_70, c8_.birthday AS birthday_71, c8_.salutation AS salutation_72, c8_.formOfAddress AS formOfAddress_73, c8_.newsletter AS newsletter_74, c8_.gender AS gender_75, c8_.note AS note_76, c8_.mainEmail AS mainEmail_77, c8_.mainPhone AS mainPhone_78, c8_.mainFax AS mainFax_79, c8_.mainUrl AS mainUrl_80, c8_.id AS id_81, c8_.created AS created_82, c8_.changed AS changed_83, s9_.username AS username_84, s9_.password AS password_85, s9_.locale AS locale_86, s9_.salt AS salt_87, s9_.locked AS locked_88, s9_.enabled AS enabled_89, s9_.lastLogin AS lastLogin_90, s9_.confirmationKey AS confirmationKey_91, s9_.passwordResetToken AS passwordResetToken_92, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_93, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_94, s9_.privateKey AS privateKey_95, s9_.apiKey AS apiKey_96, s9_.email AS email_97, s9_.id AS id_98, s9_.created AS created_99, s9_.changed AS changed_100, c10_.firstName AS firstName_101, c10_.middleName AS middleName_102, c10_.lastName AS lastName_103, c10_.birthday AS birthday_104, c10_.salutation AS salutation_105, c10_.formOfAddress AS formOfAddress_106, c10_.newsletter AS newsletter_107, c10_.gender AS gender_108, c10_.note AS note_109, c10_.mainEmail AS mainEmail_110, c10_.mainPhone AS mainPhone_111, c10_.mainFax AS mainFax_112, c10_.mainUrl AS mainUrl_113, c10_.id AS id_114, c10_.created AS created_115, c10_.changed AS changed_116, m11_.type AS type_117, m11_.id AS id_118, m11_.created AS created_119, m11_.changed AS changed_120, m0_.idPreviewImage AS idPreviewImage_121, m0_.idCollections AS idCollections_122, m0_.idUsersCreator AS idUsersCreator_123, m0_.idUsersChanger AS idUsersChanger_124, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_125, m1_.idCollectionTypes AS idCollectionTypes_126, m1_.idCollectionsParent AS idCollectionsParent_127, m1_.idUsersCreator AS idUsersCreator_128, m1_.idUsersChanger AS idUsersChanger_129, m2_.idMedia AS idMedia_130, m2_.idUsersCreator AS idUsersCreator_131, m2_.idUsersChanger AS idUsersChanger_132, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_133, m3_.idFiles AS idFiles_134, m3_.idUsersCreator AS idUsersCreator_135, m3_.idUsersChanger AS idUsersChanger_136, m4_.fileVersion AS fileVersion_137, m5_.idFileVersions AS idFileVersions_138, m6_.idFileVersions AS idFileVersions_139, s7_.idContacts AS idContacts_140, s7_.idUsersCreator AS idUsersCreator_141, s7_.idUsersChanger AS idUsersChanger_142, c8_.idTitles AS idTitles_143, c8_.avatar AS avatar_144, c8_.idUsersCreator AS idUsersCreator_145, c8_.idUsersChanger AS idUsersChanger_146, s9_.idContacts AS idContacts_147, s9_.idUsersCreator AS idUsersCreator_148, s9_.idUsersChanger AS idUsersChanger_149, c10_.idTitles AS idTitles_150, c10_.avatar AS avatar_151, c10_.idUsersCreator AS idUsersCreator_152, c10_.idUsersChanger AS idUsersChanger_153, m11_.idPreviewImage AS idPreviewImage_154, m11_.idCollections AS idCollections_155, m11_.idUsersCreator AS idUsersCreator_156, m11_.idUsersChanger AS idUsersChanger_157 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id LEFT JOIN me_files m2_ ON m0_.id = m2_.idMedia LEFT JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles LEFT JOIN me_format_options m4_ ON m3_.id = m4_.fileVersion 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 LEFT JOIN me_media m11_ ON m0_.idPreviewImage = m11_.id WHERE m0_.id = ?
SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.style AS style_4, m1_.lft AS lft_5, m1_.rgt AS rgt_6, m1_.depth AS depth_7, m1_.collection_key AS collection_key_8, m1_.id AS id_9, m1_.created AS created_10, m1_.changed AS changed_11, m2_.version AS version_12, m2_.id AS id_13, m2_.created AS created_14, m2_.changed AS changed_15, m3_.name AS name_16, m3_.version AS version_17, m3_.subVersion AS subVersion_18, m3_.size AS size_19, m3_.downloadCounter AS downloadCounter_20, m3_.storageOptions AS storageOptions_21, m3_.mimeType AS mimeType_22, m3_.properties AS properties_23, m3_.focusPointX AS focusPointX_24, m3_.focusPointY AS focusPointY_25, m3_.origin AS origin_26, m3_.aiDisclosureDisabled AS aiDisclosureDisabled_27, m3_.aiDisclosureIconVariant AS aiDisclosureIconVariant_28, m3_.id AS id_29, m3_.created AS created_30, m3_.changed AS changed_31, m4_.crop_x AS crop_x_32, m4_.crop_y AS crop_y_33, m4_.crop_width AS crop_width_34, m4_.crop_height AS crop_height_35, m4_.format_key AS format_key_36, m5_.title AS title_37, m5_.description AS description_38, m5_.aiDisclosureText AS aiDisclosureText_39, m5_.copyright AS copyright_40, m5_.credits AS credits_41, m5_.locale AS locale_42, m5_.id AS id_43, m6_.title AS title_44, m6_.description AS description_45, m6_.aiDisclosureText AS aiDisclosureText_46, m6_.copyright AS copyright_47, m6_.credits AS credits_48, m6_.locale AS locale_49, m6_.id AS id_50, s7_.username AS username_51, s7_.password AS password_52, s7_.locale AS locale_53, s7_.salt AS salt_54, s7_.locked AS locked_55, s7_.enabled AS enabled_56, s7_.lastLogin AS lastLogin_57, s7_.confirmationKey AS confirmationKey_58, s7_.passwordResetToken AS passwordResetToken_59, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_60, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_61, s7_.privateKey AS privateKey_62, s7_.apiKey AS apiKey_63, s7_.email AS email_64, s7_.id AS id_65, s7_.created AS created_66, s7_.changed AS changed_67, c8_.firstName AS firstName_68, c8_.middleName AS middleName_69, c8_.lastName AS lastName_70, c8_.birthday AS birthday_71, c8_.salutation AS salutation_72, c8_.formOfAddress AS formOfAddress_73, c8_.newsletter AS newsletter_74, c8_.gender AS gender_75, c8_.note AS note_76, c8_.mainEmail AS mainEmail_77, c8_.mainPhone AS mainPhone_78, c8_.mainFax AS mainFax_79, c8_.mainUrl AS mainUrl_80, c8_.id AS id_81, c8_.created AS created_82, c8_.changed AS changed_83, s9_.username AS username_84, s9_.password AS password_85, s9_.locale AS locale_86, s9_.salt AS salt_87, s9_.locked AS locked_88, s9_.enabled AS enabled_89, s9_.lastLogin AS lastLogin_90, s9_.confirmationKey AS confirmationKey_91, s9_.passwordResetToken AS passwordResetToken_92, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_93, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_94, s9_.privateKey AS privateKey_95, s9_.apiKey AS apiKey_96, s9_.email AS email_97, s9_.id AS id_98, s9_.created AS created_99, s9_.changed AS changed_100, c10_.firstName AS firstName_101, c10_.middleName AS middleName_102, c10_.lastName AS lastName_103, c10_.birthday AS birthday_104, c10_.salutation AS salutation_105, c10_.formOfAddress AS formOfAddress_106, c10_.newsletter AS newsletter_107, c10_.gender AS gender_108, c10_.note AS note_109, c10_.mainEmail AS mainEmail_110, c10_.mainPhone AS mainPhone_111, c10_.mainFax AS mainFax_112, c10_.mainUrl AS mainUrl_113, c10_.id AS id_114, c10_.created AS created_115, c10_.changed AS changed_116, m11_.type AS type_117, m11_.id AS id_118, m11_.created AS created_119, m11_.changed AS changed_120, m0_.idPreviewImage AS idPreviewImage_121, m0_.idCollections AS idCollections_122, m0_.idUsersCreator AS idUsersCreator_123, m0_.idUsersChanger AS idUsersChanger_124, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_125, m1_.idCollectionTypes AS idCollectionTypes_126, m1_.idCollectionsParent AS idCollectionsParent_127, m1_.idUsersCreator AS idUsersCreator_128, m1_.idUsersChanger AS idUsersChanger_129, m2_.idMedia AS idMedia_130, m2_.idUsersCreator AS idUsersCreator_131, m2_.idUsersChanger AS idUsersChanger_132, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_133, m3_.idFiles AS idFiles_134, m3_.idUsersCreator AS idUsersCreator_135, m3_.idUsersChanger AS idUsersChanger_136, m4_.fileVersion AS fileVersion_137, m5_.idFileVersions AS idFileVersions_138, m6_.idFileVersions AS idFileVersions_139, s7_.idContacts AS idContacts_140, s7_.idUsersCreator AS idUsersCreator_141, s7_.idUsersChanger AS idUsersChanger_142, c8_.idTitles AS idTitles_143, c8_.avatar AS avatar_144, c8_.idUsersCreator AS idUsersCreator_145, c8_.idUsersChanger AS idUsersChanger_146, s9_.idContacts AS idContacts_147, s9_.idUsersCreator AS idUsersCreator_148, s9_.idUsersChanger AS idUsersChanger_149, c10_.idTitles AS idTitles_150, c10_.avatar AS avatar_151, c10_.idUsersCreator AS idUsersCreator_152, c10_.idUsersChanger AS idUsersChanger_153, m11_.idPreviewImage AS idPreviewImage_154, m11_.idCollections AS idCollections_155, m11_.idUsersCreator AS idUsersCreator_156, m11_.idUsersChanger AS idUsersChanger_157 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id LEFT JOIN me_files m2_ ON m0_.id = m2_.idMedia LEFT JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles LEFT JOIN me_format_options m4_ ON m3_.id = m4_.fileVersion 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 LEFT JOIN me_media m11_ ON m0_.idPreviewImage = m11_.id WHERE m0_.id = ?
SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.style AS style_4, m1_.lft AS lft_5, m1_.rgt AS rgt_6, m1_.depth AS depth_7, m1_.collection_key AS collection_key_8, m1_.id AS id_9, m1_.created AS created_10, m1_.changed AS changed_11, m2_.version AS version_12, m2_.id AS id_13, m2_.created AS created_14, m2_.changed AS changed_15, m3_.name AS name_16, m3_.version AS version_17, m3_.subVersion AS subVersion_18, m3_.size AS size_19, m3_.downloadCounter AS downloadCounter_20, m3_.storageOptions AS storageOptions_21, m3_.mimeType AS mimeType_22, m3_.properties AS properties_23, m3_.focusPointX AS focusPointX_24, m3_.focusPointY AS focusPointY_25, m3_.origin AS origin_26, m3_.aiDisclosureDisabled AS aiDisclosureDisabled_27, m3_.aiDisclosureIconVariant AS aiDisclosureIconVariant_28, m3_.id AS id_29, m3_.created AS created_30, m3_.changed AS changed_31, m4_.crop_x AS crop_x_32, m4_.crop_y AS crop_y_33, m4_.crop_width AS crop_width_34, m4_.crop_height AS crop_height_35, m4_.format_key AS format_key_36, m5_.title AS title_37, m5_.description AS description_38, m5_.aiDisclosureText AS aiDisclosureText_39, m5_.copyright AS copyright_40, m5_.credits AS credits_41, m5_.locale AS locale_42, m5_.id AS id_43, m6_.title AS title_44, m6_.description AS description_45, m6_.aiDisclosureText AS aiDisclosureText_46, m6_.copyright AS copyright_47, m6_.credits AS credits_48, m6_.locale AS locale_49, m6_.id AS id_50, s7_.username AS username_51, s7_.password AS password_52, s7_.locale AS locale_53, s7_.salt AS salt_54, s7_.locked AS locked_55, s7_.enabled AS enabled_56, s7_.lastLogin AS lastLogin_57, s7_.confirmationKey AS confirmationKey_58, s7_.passwordResetToken AS passwordResetToken_59, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_60, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_61, s7_.privateKey AS privateKey_62, s7_.apiKey AS apiKey_63, s7_.email AS email_64, s7_.id AS id_65, s7_.created AS created_66, s7_.changed AS changed_67, c8_.firstName AS firstName_68, c8_.middleName AS middleName_69, c8_.lastName AS lastName_70, c8_.birthday AS birthday_71, c8_.salutation AS salutation_72, c8_.formOfAddress AS formOfAddress_73, c8_.newsletter AS newsletter_74, c8_.gender AS gender_75, c8_.note AS note_76, c8_.mainEmail AS mainEmail_77, c8_.mainPhone AS mainPhone_78, c8_.mainFax AS mainFax_79, c8_.mainUrl AS mainUrl_80, c8_.id AS id_81, c8_.created AS created_82, c8_.changed AS changed_83, s9_.username AS username_84, s9_.password AS password_85, s9_.locale AS locale_86, s9_.salt AS salt_87, s9_.locked AS locked_88, s9_.enabled AS enabled_89, s9_.lastLogin AS lastLogin_90, s9_.confirmationKey AS confirmationKey_91, s9_.passwordResetToken AS passwordResetToken_92, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_93, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_94, s9_.privateKey AS privateKey_95, s9_.apiKey AS apiKey_96, s9_.email AS email_97, s9_.id AS id_98, s9_.created AS created_99, s9_.changed AS changed_100, c10_.firstName AS firstName_101, c10_.middleName AS middleName_102, c10_.lastName AS lastName_103, c10_.birthday AS birthday_104, c10_.salutation AS salutation_105, c10_.formOfAddress AS formOfAddress_106, c10_.newsletter AS newsletter_107, c10_.gender AS gender_108, c10_.note AS note_109, c10_.mainEmail AS mainEmail_110, c10_.mainPhone AS mainPhone_111, c10_.mainFax AS mainFax_112, c10_.mainUrl AS mainUrl_113, c10_.id AS id_114, c10_.created AS created_115, c10_.changed AS changed_116, m11_.type AS type_117, m11_.id AS id_118, m11_.created AS created_119, m11_.changed AS changed_120, m0_.idPreviewImage AS idPreviewImage_121, m0_.idCollections AS idCollections_122, m0_.idUsersCreator AS idUsersCreator_123, m0_.idUsersChanger AS idUsersChanger_124, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_125, m1_.idCollectionTypes AS idCollectionTypes_126, m1_.idCollectionsParent AS idCollectionsParent_127, m1_.idUsersCreator AS idUsersCreator_128, m1_.idUsersChanger AS idUsersChanger_129, m2_.idMedia AS idMedia_130, m2_.idUsersCreator AS idUsersCreator_131, m2_.idUsersChanger AS idUsersChanger_132, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_133, m3_.idFiles AS idFiles_134, m3_.idUsersCreator AS idUsersCreator_135, m3_.idUsersChanger AS idUsersChanger_136, m4_.fileVersion AS fileVersion_137, m5_.idFileVersions AS idFileVersions_138, m6_.idFileVersions AS idFileVersions_139, s7_.idContacts AS idContacts_140, s7_.idUsersCreator AS idUsersCreator_141, s7_.idUsersChanger AS idUsersChanger_142, c8_.idTitles AS idTitles_143, c8_.avatar AS avatar_144, c8_.idUsersCreator AS idUsersCreator_145, c8_.idUsersChanger AS idUsersChanger_146, s9_.idContacts AS idContacts_147, s9_.idUsersCreator AS idUsersCreator_148, s9_.idUsersChanger AS idUsersChanger_149, c10_.idTitles AS idTitles_150, c10_.avatar AS avatar_151, c10_.idUsersCreator AS idUsersCreator_152, c10_.idUsersChanger AS idUsersChanger_153, m11_.idPreviewImage AS idPreviewImage_154, m11_.idCollections AS idCollections_155, m11_.idUsersCreator AS idUsersCreator_156, m11_.idUsersChanger AS idUsersChanger_157 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id LEFT JOIN me_files m2_ ON m0_.id = m2_.idMedia LEFT JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles LEFT JOIN me_format_options m4_ ON m3_.id = m4_.fileVersion 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 LEFT JOIN me_media m11_ ON m0_.idPreviewImage = m11_.id WHERE m0_.id = ?
SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.style AS style_4, m1_.lft AS lft_5, m1_.rgt AS rgt_6, m1_.depth AS depth_7, m1_.collection_key AS collection_key_8, m1_.id AS id_9, m1_.created AS created_10, m1_.changed AS changed_11, m2_.version AS version_12, m2_.id AS id_13, m2_.created AS created_14, m2_.changed AS changed_15, m3_.name AS name_16, m3_.version AS version_17, m3_.subVersion AS subVersion_18, m3_.size AS size_19, m3_.downloadCounter AS downloadCounter_20, m3_.storageOptions AS storageOptions_21, m3_.mimeType AS mimeType_22, m3_.properties AS properties_23, m3_.focusPointX AS focusPointX_24, m3_.focusPointY AS focusPointY_25, m3_.origin AS origin_26, m3_.aiDisclosureDisabled AS aiDisclosureDisabled_27, m3_.aiDisclosureIconVariant AS aiDisclosureIconVariant_28, m3_.id AS id_29, m3_.created AS created_30, m3_.changed AS changed_31, m4_.crop_x AS crop_x_32, m4_.crop_y AS crop_y_33, m4_.crop_width AS crop_width_34, m4_.crop_height AS crop_height_35, m4_.format_key AS format_key_36, m5_.title AS title_37, m5_.description AS description_38, m5_.aiDisclosureText AS aiDisclosureText_39, m5_.copyright AS copyright_40, m5_.credits AS credits_41, m5_.locale AS locale_42, m5_.id AS id_43, m6_.title AS title_44, m6_.description AS description_45, m6_.aiDisclosureText AS aiDisclosureText_46, m6_.copyright AS copyright_47, m6_.credits AS credits_48, m6_.locale AS locale_49, m6_.id AS id_50, s7_.username AS username_51, s7_.password AS password_52, s7_.locale AS locale_53, s7_.salt AS salt_54, s7_.locked AS locked_55, s7_.enabled AS enabled_56, s7_.lastLogin AS lastLogin_57, s7_.confirmationKey AS confirmationKey_58, s7_.passwordResetToken AS passwordResetToken_59, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_60, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_61, s7_.privateKey AS privateKey_62, s7_.apiKey AS apiKey_63, s7_.email AS email_64, s7_.id AS id_65, s7_.created AS created_66, s7_.changed AS changed_67, c8_.firstName AS firstName_68, c8_.middleName AS middleName_69, c8_.lastName AS lastName_70, c8_.birthday AS birthday_71, c8_.salutation AS salutation_72, c8_.formOfAddress AS formOfAddress_73, c8_.newsletter AS newsletter_74, c8_.gender AS gender_75, c8_.note AS note_76, c8_.mainEmail AS mainEmail_77, c8_.mainPhone AS mainPhone_78, c8_.mainFax AS mainFax_79, c8_.mainUrl AS mainUrl_80, c8_.id AS id_81, c8_.created AS created_82, c8_.changed AS changed_83, s9_.username AS username_84, s9_.password AS password_85, s9_.locale AS locale_86, s9_.salt AS salt_87, s9_.locked AS locked_88, s9_.enabled AS enabled_89, s9_.lastLogin AS lastLogin_90, s9_.confirmationKey AS confirmationKey_91, s9_.passwordResetToken AS passwordResetToken_92, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_93, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_94, s9_.privateKey AS privateKey_95, s9_.apiKey AS apiKey_96, s9_.email AS email_97, s9_.id AS id_98, s9_.created AS created_99, s9_.changed AS changed_100, c10_.firstName AS firstName_101, c10_.middleName AS middleName_102, c10_.lastName AS lastName_103, c10_.birthday AS birthday_104, c10_.salutation AS salutation_105, c10_.formOfAddress AS formOfAddress_106, c10_.newsletter AS newsletter_107, c10_.gender AS gender_108, c10_.note AS note_109, c10_.mainEmail AS mainEmail_110, c10_.mainPhone AS mainPhone_111, c10_.mainFax AS mainFax_112, c10_.mainUrl AS mainUrl_113, c10_.id AS id_114, c10_.created AS created_115, c10_.changed AS changed_116, m11_.type AS type_117, m11_.id AS id_118, m11_.created AS created_119, m11_.changed AS changed_120, m0_.idPreviewImage AS idPreviewImage_121, m0_.idCollections AS idCollections_122, m0_.idUsersCreator AS idUsersCreator_123, m0_.idUsersChanger AS idUsersChanger_124, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_125, m1_.idCollectionTypes AS idCollectionTypes_126, m1_.idCollectionsParent AS idCollectionsParent_127, m1_.idUsersCreator AS idUsersCreator_128, m1_.idUsersChanger AS idUsersChanger_129, m2_.idMedia AS idMedia_130, m2_.idUsersCreator AS idUsersCreator_131, m2_.idUsersChanger AS idUsersChanger_132, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_133, m3_.idFiles AS idFiles_134, m3_.idUsersCreator AS idUsersCreator_135, m3_.idUsersChanger AS idUsersChanger_136, m4_.fileVersion AS fileVersion_137, m5_.idFileVersions AS idFileVersions_138, m6_.idFileVersions AS idFileVersions_139, s7_.idContacts AS idContacts_140, s7_.idUsersCreator AS idUsersCreator_141, s7_.idUsersChanger AS idUsersChanger_142, c8_.idTitles AS idTitles_143, c8_.avatar AS avatar_144, c8_.idUsersCreator AS idUsersCreator_145, c8_.idUsersChanger AS idUsersChanger_146, s9_.idContacts AS idContacts_147, s9_.idUsersCreator AS idUsersCreator_148, s9_.idUsersChanger AS idUsersChanger_149, c10_.idTitles AS idTitles_150, c10_.avatar AS avatar_151, c10_.idUsersCreator AS idUsersCreator_152, c10_.idUsersChanger AS idUsersChanger_153, m11_.idPreviewImage AS idPreviewImage_154, m11_.idCollections AS idCollections_155, m11_.idUsersCreator AS idUsersCreator_156, m11_.idUsersChanger AS idUsersChanger_157 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id LEFT JOIN me_files m2_ ON m0_.id = m2_.idMedia LEFT JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles LEFT JOIN me_format_options m4_ ON m3_.id = m4_.fileVersion 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 LEFT JOIN me_media m11_ ON m0_.idPreviewImage = m11_.id WHERE m0_.id = ?
SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.style AS style_4, m1_.lft AS lft_5, m1_.rgt AS rgt_6, m1_.depth AS depth_7, m1_.collection_key AS collection_key_8, m1_.id AS id_9, m1_.created AS created_10, m1_.changed AS changed_11, m2_.version AS version_12, m2_.id AS id_13, m2_.created AS created_14, m2_.changed AS changed_15, m3_.name AS name_16, m3_.version AS version_17, m3_.subVersion AS subVersion_18, m3_.size AS size_19, m3_.downloadCounter AS downloadCounter_20, m3_.storageOptions AS storageOptions_21, m3_.mimeType AS mimeType_22, m3_.properties AS properties_23, m3_.focusPointX AS focusPointX_24, m3_.focusPointY AS focusPointY_25, m3_.origin AS origin_26, m3_.aiDisclosureDisabled AS aiDisclosureDisabled_27, m3_.aiDisclosureIconVariant AS aiDisclosureIconVariant_28, m3_.id AS id_29, m3_.created AS created_30, m3_.changed AS changed_31, m4_.crop_x AS crop_x_32, m4_.crop_y AS crop_y_33, m4_.crop_width AS crop_width_34, m4_.crop_height AS crop_height_35, m4_.format_key AS format_key_36, m5_.title AS title_37, m5_.description AS description_38, m5_.aiDisclosureText AS aiDisclosureText_39, m5_.copyright AS copyright_40, m5_.credits AS credits_41, m5_.locale AS locale_42, m5_.id AS id_43, m6_.title AS title_44, m6_.description AS description_45, m6_.aiDisclosureText AS aiDisclosureText_46, m6_.copyright AS copyright_47, m6_.credits AS credits_48, m6_.locale AS locale_49, m6_.id AS id_50, s7_.username AS username_51, s7_.password AS password_52, s7_.locale AS locale_53, s7_.salt AS salt_54, s7_.locked AS locked_55, s7_.enabled AS enabled_56, s7_.lastLogin AS lastLogin_57, s7_.confirmationKey AS confirmationKey_58, s7_.passwordResetToken AS passwordResetToken_59, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_60, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_61, s7_.privateKey AS privateKey_62, s7_.apiKey AS apiKey_63, s7_.email AS email_64, s7_.id AS id_65, s7_.created AS created_66, s7_.changed AS changed_67, c8_.firstName AS firstName_68, c8_.middleName AS middleName_69, c8_.lastName AS lastName_70, c8_.birthday AS birthday_71, c8_.salutation AS salutation_72, c8_.formOfAddress AS formOfAddress_73, c8_.newsletter AS newsletter_74, c8_.gender AS gender_75, c8_.note AS note_76, c8_.mainEmail AS mainEmail_77, c8_.mainPhone AS mainPhone_78, c8_.mainFax AS mainFax_79, c8_.mainUrl AS mainUrl_80, c8_.id AS id_81, c8_.created AS created_82, c8_.changed AS changed_83, s9_.username AS username_84, s9_.password AS password_85, s9_.locale AS locale_86, s9_.salt AS salt_87, s9_.locked AS locked_88, s9_.enabled AS enabled_89, s9_.lastLogin AS lastLogin_90, s9_.confirmationKey AS confirmationKey_91, s9_.passwordResetToken AS passwordResetToken_92, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_93, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_94, s9_.privateKey AS privateKey_95, s9_.apiKey AS apiKey_96, s9_.email AS email_97, s9_.id AS id_98, s9_.created AS created_99, s9_.changed AS changed_100, c10_.firstName AS firstName_101, c10_.middleName AS middleName_102, c10_.lastName AS lastName_103, c10_.birthday AS birthday_104, c10_.salutation AS salutation_105, c10_.formOfAddress AS formOfAddress_106, c10_.newsletter AS newsletter_107, c10_.gender AS gender_108, c10_.note AS note_109, c10_.mainEmail AS mainEmail_110, c10_.mainPhone AS mainPhone_111, c10_.mainFax AS mainFax_112, c10_.mainUrl AS mainUrl_113, c10_.id AS id_114, c10_.created AS created_115, c10_.changed AS changed_116, m11_.type AS type_117, m11_.id AS id_118, m11_.created AS created_119, m11_.changed AS changed_120, m0_.idPreviewImage AS idPreviewImage_121, m0_.idCollections AS idCollections_122, m0_.idUsersCreator AS idUsersCreator_123, m0_.idUsersChanger AS idUsersChanger_124, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_125, m1_.idCollectionTypes AS idCollectionTypes_126, m1_.idCollectionsParent AS idCollectionsParent_127, m1_.idUsersCreator AS idUsersCreator_128, m1_.idUsersChanger AS idUsersChanger_129, m2_.idMedia AS idMedia_130, m2_.idUsersCreator AS idUsersCreator_131, m2_.idUsersChanger AS idUsersChanger_132, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_133, m3_.idFiles AS idFiles_134, m3_.idUsersCreator AS idUsersCreator_135, m3_.idUsersChanger AS idUsersChanger_136, m4_.fileVersion AS fileVersion_137, m5_.idFileVersions AS idFileVersions_138, m6_.idFileVersions AS idFileVersions_139, s7_.idContacts AS idContacts_140, s7_.idUsersCreator AS idUsersCreator_141, s7_.idUsersChanger AS idUsersChanger_142, c8_.idTitles AS idTitles_143, c8_.avatar AS avatar_144, c8_.idUsersCreator AS idUsersCreator_145, c8_.idUsersChanger AS idUsersChanger_146, s9_.idContacts AS idContacts_147, s9_.idUsersCreator AS idUsersCreator_148, s9_.idUsersChanger AS idUsersChanger_149, c10_.idTitles AS idTitles_150, c10_.avatar AS avatar_151, c10_.idUsersCreator AS idUsersCreator_152, c10_.idUsersChanger AS idUsersChanger_153, m11_.idPreviewImage AS idPreviewImage_154, m11_.idCollections AS idCollections_155, m11_.idUsersCreator AS idUsersCreator_156, m11_.idUsersChanger AS idUsersChanger_157 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id LEFT JOIN me_files m2_ ON m0_.id = m2_.idMedia LEFT JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles LEFT JOIN me_format_options m4_ ON m3_.id = m4_.fileVersion 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 LEFT JOIN me_media m11_ ON m0_.idPreviewImage = m11_.id WHERE m0_.id = ?
SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.style AS style_4, m1_.lft AS lft_5, m1_.rgt AS rgt_6, m1_.depth AS depth_7, m1_.collection_key AS collection_key_8, m1_.id AS id_9, m1_.created AS created_10, m1_.changed AS changed_11, m2_.version AS version_12, m2_.id AS id_13, m2_.created AS created_14, m2_.changed AS changed_15, m3_.name AS name_16, m3_.version AS version_17, m3_.subVersion AS subVersion_18, m3_.size AS size_19, m3_.downloadCounter AS downloadCounter_20, m3_.storageOptions AS storageOptions_21, m3_.mimeType AS mimeType_22, m3_.properties AS properties_23, m3_.focusPointX AS focusPointX_24, m3_.focusPointY AS focusPointY_25, m3_.origin AS origin_26, m3_.aiDisclosureDisabled AS aiDisclosureDisabled_27, m3_.aiDisclosureIconVariant AS aiDisclosureIconVariant_28, m3_.id AS id_29, m3_.created AS created_30, m3_.changed AS changed_31, m4_.crop_x AS crop_x_32, m4_.crop_y AS crop_y_33, m4_.crop_width AS crop_width_34, m4_.crop_height AS crop_height_35, m4_.format_key AS format_key_36, m5_.title AS title_37, m5_.description AS description_38, m5_.aiDisclosureText AS aiDisclosureText_39, m5_.copyright AS copyright_40, m5_.credits AS credits_41, m5_.locale AS locale_42, m5_.id AS id_43, m6_.title AS title_44, m6_.description AS description_45, m6_.aiDisclosureText AS aiDisclosureText_46, m6_.copyright AS copyright_47, m6_.credits AS credits_48, m6_.locale AS locale_49, m6_.id AS id_50, s7_.username AS username_51, s7_.password AS password_52, s7_.locale AS locale_53, s7_.salt AS salt_54, s7_.locked AS locked_55, s7_.enabled AS enabled_56, s7_.lastLogin AS lastLogin_57, s7_.confirmationKey AS confirmationKey_58, s7_.passwordResetToken AS passwordResetToken_59, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_60, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_61, s7_.privateKey AS privateKey_62, s7_.apiKey AS apiKey_63, s7_.email AS email_64, s7_.id AS id_65, s7_.created AS created_66, s7_.changed AS changed_67, c8_.firstName AS firstName_68, c8_.middleName AS middleName_69, c8_.lastName AS lastName_70, c8_.birthday AS birthday_71, c8_.salutation AS salutation_72, c8_.formOfAddress AS formOfAddress_73, c8_.newsletter AS newsletter_74, c8_.gender AS gender_75, c8_.note AS note_76, c8_.mainEmail AS mainEmail_77, c8_.mainPhone AS mainPhone_78, c8_.mainFax AS mainFax_79, c8_.mainUrl AS mainUrl_80, c8_.id AS id_81, c8_.created AS created_82, c8_.changed AS changed_83, s9_.username AS username_84, s9_.password AS password_85, s9_.locale AS locale_86, s9_.salt AS salt_87, s9_.locked AS locked_88, s9_.enabled AS enabled_89, s9_.lastLogin AS lastLogin_90, s9_.confirmationKey AS confirmationKey_91, s9_.passwordResetToken AS passwordResetToken_92, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_93, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_94, s9_.privateKey AS privateKey_95, s9_.apiKey AS apiKey_96, s9_.email AS email_97, s9_.id AS id_98, s9_.created AS created_99, s9_.changed AS changed_100, c10_.firstName AS firstName_101, c10_.middleName AS middleName_102, c10_.lastName AS lastName_103, c10_.birthday AS birthday_104, c10_.salutation AS salutation_105, c10_.formOfAddress AS formOfAddress_106, c10_.newsletter AS newsletter_107, c10_.gender AS gender_108, c10_.note AS note_109, c10_.mainEmail AS mainEmail_110, c10_.mainPhone AS mainPhone_111, c10_.mainFax AS mainFax_112, c10_.mainUrl AS mainUrl_113, c10_.id AS id_114, c10_.created AS created_115, c10_.changed AS changed_116, m11_.type AS type_117, m11_.id AS id_118, m11_.created AS created_119, m11_.changed AS changed_120, m0_.idPreviewImage AS idPreviewImage_121, m0_.idCollections AS idCollections_122, m0_.idUsersCreator AS idUsersCreator_123, m0_.idUsersChanger AS idUsersChanger_124, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_125, m1_.idCollectionTypes AS idCollectionTypes_126, m1_.idCollectionsParent AS idCollectionsParent_127, m1_.idUsersCreator AS idUsersCreator_128, m1_.idUsersChanger AS idUsersChanger_129, m2_.idMedia AS idMedia_130, m2_.idUsersCreator AS idUsersCreator_131, m2_.idUsersChanger AS idUsersChanger_132, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_133, m3_.idFiles AS idFiles_134, m3_.idUsersCreator AS idUsersCreator_135, m3_.idUsersChanger AS idUsersChanger_136, m4_.fileVersion AS fileVersion_137, m5_.idFileVersions AS idFileVersions_138, m6_.idFileVersions AS idFileVersions_139, s7_.idContacts AS idContacts_140, s7_.idUsersCreator AS idUsersCreator_141, s7_.idUsersChanger AS idUsersChanger_142, c8_.idTitles AS idTitles_143, c8_.avatar AS avatar_144, c8_.idUsersCreator AS idUsersCreator_145, c8_.idUsersChanger AS idUsersChanger_146, s9_.idContacts AS idContacts_147, s9_.idUsersCreator AS idUsersCreator_148, s9_.idUsersChanger AS idUsersChanger_149, c10_.idTitles AS idTitles_150, c10_.avatar AS avatar_151, c10_.idUsersCreator AS idUsersCreator_152, c10_.idUsersChanger AS idUsersChanger_153, m11_.idPreviewImage AS idPreviewImage_154, m11_.idCollections AS idCollections_155, m11_.idUsersCreator AS idUsersCreator_156, m11_.idUsersChanger AS idUsersChanger_157 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id LEFT JOIN me_files m2_ ON m0_.id = m2_.idMedia LEFT JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles LEFT JOIN me_format_options m4_ ON m3_.id = m4_.fileVersion 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 LEFT JOIN me_media m11_ ON m0_.idPreviewImage = m11_.id WHERE m0_.id = ?
SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.style AS style_4, m1_.lft AS lft_5, m1_.rgt AS rgt_6, m1_.depth AS depth_7, m1_.collection_key AS collection_key_8, m1_.id AS id_9, m1_.created AS created_10, m1_.changed AS changed_11, m2_.version AS version_12, m2_.id AS id_13, m2_.created AS created_14, m2_.changed AS changed_15, m3_.name AS name_16, m3_.version AS version_17, m3_.subVersion AS subVersion_18, m3_.size AS size_19, m3_.downloadCounter AS downloadCounter_20, m3_.storageOptions AS storageOptions_21, m3_.mimeType AS mimeType_22, m3_.properties AS properties_23, m3_.focusPointX AS focusPointX_24, m3_.focusPointY AS focusPointY_25, m3_.origin AS origin_26, m3_.aiDisclosureDisabled AS aiDisclosureDisabled_27, m3_.aiDisclosureIconVariant AS aiDisclosureIconVariant_28, m3_.id AS id_29, m3_.created AS created_30, m3_.changed AS changed_31, m4_.crop_x AS crop_x_32, m4_.crop_y AS crop_y_33, m4_.crop_width AS crop_width_34, m4_.crop_height AS crop_height_35, m4_.format_key AS format_key_36, m5_.title AS title_37, m5_.description AS description_38, m5_.aiDisclosureText AS aiDisclosureText_39, m5_.copyright AS copyright_40, m5_.credits AS credits_41, m5_.locale AS locale_42, m5_.id AS id_43, m6_.title AS title_44, m6_.description AS description_45, m6_.aiDisclosureText AS aiDisclosureText_46, m6_.copyright AS copyright_47, m6_.credits AS credits_48, m6_.locale AS locale_49, m6_.id AS id_50, s7_.username AS username_51, s7_.password AS password_52, s7_.locale AS locale_53, s7_.salt AS salt_54, s7_.locked AS locked_55, s7_.enabled AS enabled_56, s7_.lastLogin AS lastLogin_57, s7_.confirmationKey AS confirmationKey_58, s7_.passwordResetToken AS passwordResetToken_59, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_60, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_61, s7_.privateKey AS privateKey_62, s7_.apiKey AS apiKey_63, s7_.email AS email_64, s7_.id AS id_65, s7_.created AS created_66, s7_.changed AS changed_67, c8_.firstName AS firstName_68, c8_.middleName AS middleName_69, c8_.lastName AS lastName_70, c8_.birthday AS birthday_71, c8_.salutation AS salutation_72, c8_.formOfAddress AS formOfAddress_73, c8_.newsletter AS newsletter_74, c8_.gender AS gender_75, c8_.note AS note_76, c8_.mainEmail AS mainEmail_77, c8_.mainPhone AS mainPhone_78, c8_.mainFax AS mainFax_79, c8_.mainUrl AS mainUrl_80, c8_.id AS id_81, c8_.created AS created_82, c8_.changed AS changed_83, s9_.username AS username_84, s9_.password AS password_85, s9_.locale AS locale_86, s9_.salt AS salt_87, s9_.locked AS locked_88, s9_.enabled AS enabled_89, s9_.lastLogin AS lastLogin_90, s9_.confirmationKey AS confirmationKey_91, s9_.passwordResetToken AS passwordResetToken_92, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_93, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_94, s9_.privateKey AS privateKey_95, s9_.apiKey AS apiKey_96, s9_.email AS email_97, s9_.id AS id_98, s9_.created AS created_99, s9_.changed AS changed_100, c10_.firstName AS firstName_101, c10_.middleName AS middleName_102, c10_.lastName AS lastName_103, c10_.birthday AS birthday_104, c10_.salutation AS salutation_105, c10_.formOfAddress AS formOfAddress_106, c10_.newsletter AS newsletter_107, c10_.gender AS gender_108, c10_.note AS note_109, c10_.mainEmail AS mainEmail_110, c10_.mainPhone AS mainPhone_111, c10_.mainFax AS mainFax_112, c10_.mainUrl AS mainUrl_113, c10_.id AS id_114, c10_.created AS created_115, c10_.changed AS changed_116, m11_.type AS type_117, m11_.id AS id_118, m11_.created AS created_119, m11_.changed AS changed_120, m0_.idPreviewImage AS idPreviewImage_121, m0_.idCollections AS idCollections_122, m0_.idUsersCreator AS idUsersCreator_123, m0_.idUsersChanger AS idUsersChanger_124, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_125, m1_.idCollectionTypes AS idCollectionTypes_126, m1_.idCollectionsParent AS idCollectionsParent_127, m1_.idUsersCreator AS idUsersCreator_128, m1_.idUsersChanger AS idUsersChanger_129, m2_.idMedia AS idMedia_130, m2_.idUsersCreator AS idUsersCreator_131, m2_.idUsersChanger AS idUsersChanger_132, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_133, m3_.idFiles AS idFiles_134, m3_.idUsersCreator AS idUsersCreator_135, m3_.idUsersChanger AS idUsersChanger_136, m4_.fileVersion AS fileVersion_137, m5_.idFileVersions AS idFileVersions_138, m6_.idFileVersions AS idFileVersions_139, s7_.idContacts AS idContacts_140, s7_.idUsersCreator AS idUsersCreator_141, s7_.idUsersChanger AS idUsersChanger_142, c8_.idTitles AS idTitles_143, c8_.avatar AS avatar_144, c8_.idUsersCreator AS idUsersCreator_145, c8_.idUsersChanger AS idUsersChanger_146, s9_.idContacts AS idContacts_147, s9_.idUsersCreator AS idUsersCreator_148, s9_.idUsersChanger AS idUsersChanger_149, c10_.idTitles AS idTitles_150, c10_.avatar AS avatar_151, c10_.idUsersCreator AS idUsersCreator_152, c10_.idUsersChanger AS idUsersChanger_153, m11_.idPreviewImage AS idPreviewImage_154, m11_.idCollections AS idCollections_155, m11_.idUsersCreator AS idUsersCreator_156, m11_.idUsersChanger AS idUsersChanger_157 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id LEFT JOIN me_files m2_ ON m0_.id = m2_.idMedia LEFT JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles LEFT JOIN me_format_options m4_ ON m3_.id = m4_.fileVersion 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 LEFT JOIN me_media m11_ ON m0_.idPreviewImage = m11_.id WHERE m0_.id = ?
SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.style AS style_4, m1_.lft AS lft_5, m1_.rgt AS rgt_6, m1_.depth AS depth_7, m1_.collection_key AS collection_key_8, m1_.id AS id_9, m1_.created AS created_10, m1_.changed AS changed_11, m2_.version AS version_12, m2_.id AS id_13, m2_.created AS created_14, m2_.changed AS changed_15, m3_.name AS name_16, m3_.version AS version_17, m3_.subVersion AS subVersion_18, m3_.size AS size_19, m3_.downloadCounter AS downloadCounter_20, m3_.storageOptions AS storageOptions_21, m3_.mimeType AS mimeType_22, m3_.properties AS properties_23, m3_.focusPointX AS focusPointX_24, m3_.focusPointY AS focusPointY_25, m3_.origin AS origin_26, m3_.aiDisclosureDisabled AS aiDisclosureDisabled_27, m3_.aiDisclosureIconVariant AS aiDisclosureIconVariant_28, m3_.id AS id_29, m3_.created AS created_30, m3_.changed AS changed_31, m4_.crop_x AS crop_x_32, m4_.crop_y AS crop_y_33, m4_.crop_width AS crop_width_34, m4_.crop_height AS crop_height_35, m4_.format_key AS format_key_36, m5_.title AS title_37, m5_.description AS description_38, m5_.aiDisclosureText AS aiDisclosureText_39, m5_.copyright AS copyright_40, m5_.credits AS credits_41, m5_.locale AS locale_42, m5_.id AS id_43, m6_.title AS title_44, m6_.description AS description_45, m6_.aiDisclosureText AS aiDisclosureText_46, m6_.copyright AS copyright_47, m6_.credits AS credits_48, m6_.locale AS locale_49, m6_.id AS id_50, s7_.username AS username_51, s7_.password AS password_52, s7_.locale AS locale_53, s7_.salt AS salt_54, s7_.locked AS locked_55, s7_.enabled AS enabled_56, s7_.lastLogin AS lastLogin_57, s7_.confirmationKey AS confirmationKey_58, s7_.passwordResetToken AS passwordResetToken_59, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_60, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_61, s7_.privateKey AS privateKey_62, s7_.apiKey AS apiKey_63, s7_.email AS email_64, s7_.id AS id_65, s7_.created AS created_66, s7_.changed AS changed_67, c8_.firstName AS firstName_68, c8_.middleName AS middleName_69, c8_.lastName AS lastName_70, c8_.birthday AS birthday_71, c8_.salutation AS salutation_72, c8_.formOfAddress AS formOfAddress_73, c8_.newsletter AS newsletter_74, c8_.gender AS gender_75, c8_.note AS note_76, c8_.mainEmail AS mainEmail_77, c8_.mainPhone AS mainPhone_78, c8_.mainFax AS mainFax_79, c8_.mainUrl AS mainUrl_80, c8_.id AS id_81, c8_.created AS created_82, c8_.changed AS changed_83, s9_.username AS username_84, s9_.password AS password_85, s9_.locale AS locale_86, s9_.salt AS salt_87, s9_.locked AS locked_88, s9_.enabled AS enabled_89, s9_.lastLogin AS lastLogin_90, s9_.confirmationKey AS confirmationKey_91, s9_.passwordResetToken AS passwordResetToken_92, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_93, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_94, s9_.privateKey AS privateKey_95, s9_.apiKey AS apiKey_96, s9_.email AS email_97, s9_.id AS id_98, s9_.created AS created_99, s9_.changed AS changed_100, c10_.firstName AS firstName_101, c10_.middleName AS middleName_102, c10_.lastName AS lastName_103, c10_.birthday AS birthday_104, c10_.salutation AS salutation_105, c10_.formOfAddress AS formOfAddress_106, c10_.newsletter AS newsletter_107, c10_.gender AS gender_108, c10_.note AS note_109, c10_.mainEmail AS mainEmail_110, c10_.mainPhone AS mainPhone_111, c10_.mainFax AS mainFax_112, c10_.mainUrl AS mainUrl_113, c10_.id AS id_114, c10_.created AS created_115, c10_.changed AS changed_116, m11_.type AS type_117, m11_.id AS id_118, m11_.created AS created_119, m11_.changed AS changed_120, m0_.idPreviewImage AS idPreviewImage_121, m0_.idCollections AS idCollections_122, m0_.idUsersCreator AS idUsersCreator_123, m0_.idUsersChanger AS idUsersChanger_124, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_125, m1_.idCollectionTypes AS idCollectionTypes_126, m1_.idCollectionsParent AS idCollectionsParent_127, m1_.idUsersCreator AS idUsersCreator_128, m1_.idUsersChanger AS idUsersChanger_129, m2_.idMedia AS idMedia_130, m2_.idUsersCreator AS idUsersCreator_131, m2_.idUsersChanger AS idUsersChanger_132, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_133, m3_.idFiles AS idFiles_134, m3_.idUsersCreator AS idUsersCreator_135, m3_.idUsersChanger AS idUsersChanger_136, m4_.fileVersion AS fileVersion_137, m5_.idFileVersions AS idFileVersions_138, m6_.idFileVersions AS idFileVersions_139, s7_.idContacts AS idContacts_140, s7_.idUsersCreator AS idUsersCreator_141, s7_.idUsersChanger AS idUsersChanger_142, c8_.idTitles AS idTitles_143, c8_.avatar AS avatar_144, c8_.idUsersCreator AS idUsersCreator_145, c8_.idUsersChanger AS idUsersChanger_146, s9_.idContacts AS idContacts_147, s9_.idUsersCreator AS idUsersCreator_148, s9_.idUsersChanger AS idUsersChanger_149, c10_.idTitles AS idTitles_150, c10_.avatar AS avatar_151, c10_.idUsersCreator AS idUsersCreator_152, c10_.idUsersChanger AS idUsersChanger_153, m11_.idPreviewImage AS idPreviewImage_154, m11_.idCollections AS idCollections_155, m11_.idUsersCreator AS idUsersCreator_156, m11_.idUsersChanger AS idUsersChanger_157 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id LEFT JOIN me_files m2_ ON m0_.id = m2_.idMedia LEFT JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles LEFT JOIN me_format_options m4_ ON m3_.id = m4_.fileVersion 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 LEFT JOIN me_media m11_ ON m0_.idPreviewImage = m11_.id WHERE m0_.id = ?
SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.style AS style_4, m1_.lft AS lft_5, m1_.rgt AS rgt_6, m1_.depth AS depth_7, m1_.collection_key AS collection_key_8, m1_.id AS id_9, m1_.created AS created_10, m1_.changed AS changed_11, m2_.version AS version_12, m2_.id AS id_13, m2_.created AS created_14, m2_.changed AS changed_15, m3_.name AS name_16, m3_.version AS version_17, m3_.subVersion AS subVersion_18, m3_.size AS size_19, m3_.downloadCounter AS downloadCounter_20, m3_.storageOptions AS storageOptions_21, m3_.mimeType AS mimeType_22, m3_.properties AS properties_23, m3_.focusPointX AS focusPointX_24, m3_.focusPointY AS focusPointY_25, m3_.origin AS origin_26, m3_.aiDisclosureDisabled AS aiDisclosureDisabled_27, m3_.aiDisclosureIconVariant AS aiDisclosureIconVariant_28, m3_.id AS id_29, m3_.created AS created_30, m3_.changed AS changed_31, m4_.crop_x AS crop_x_32, m4_.crop_y AS crop_y_33, m4_.crop_width AS crop_width_34, m4_.crop_height AS crop_height_35, m4_.format_key AS format_key_36, m5_.title AS title_37, m5_.description AS description_38, m5_.aiDisclosureText AS aiDisclosureText_39, m5_.copyright AS copyright_40, m5_.credits AS credits_41, m5_.locale AS locale_42, m5_.id AS id_43, m6_.title AS title_44, m6_.description AS description_45, m6_.aiDisclosureText AS aiDisclosureText_46, m6_.copyright AS copyright_47, m6_.credits AS credits_48, m6_.locale AS locale_49, m6_.id AS id_50, s7_.username AS username_51, s7_.password AS password_52, s7_.locale AS locale_53, s7_.salt AS salt_54, s7_.locked AS locked_55, s7_.enabled AS enabled_56, s7_.lastLogin AS lastLogin_57, s7_.confirmationKey AS confirmationKey_58, s7_.passwordResetToken AS passwordResetToken_59, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_60, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_61, s7_.privateKey AS privateKey_62, s7_.apiKey AS apiKey_63, s7_.email AS email_64, s7_.id AS id_65, s7_.created AS created_66, s7_.changed AS changed_67, c8_.firstName AS firstName_68, c8_.middleName AS middleName_69, c8_.lastName AS lastName_70, c8_.birthday AS birthday_71, c8_.salutation AS salutation_72, c8_.formOfAddress AS formOfAddress_73, c8_.newsletter AS newsletter_74, c8_.gender AS gender_75, c8_.note AS note_76, c8_.mainEmail AS mainEmail_77, c8_.mainPhone AS mainPhone_78, c8_.mainFax AS mainFax_79, c8_.mainUrl AS mainUrl_80, c8_.id AS id_81, c8_.created AS created_82, c8_.changed AS changed_83, s9_.username AS username_84, s9_.password AS password_85, s9_.locale AS locale_86, s9_.salt AS salt_87, s9_.locked AS locked_88, s9_.enabled AS enabled_89, s9_.lastLogin AS lastLogin_90, s9_.confirmationKey AS confirmationKey_91, s9_.passwordResetToken AS passwordResetToken_92, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_93, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_94, s9_.privateKey AS privateKey_95, s9_.apiKey AS apiKey_96, s9_.email AS email_97, s9_.id AS id_98, s9_.created AS created_99, s9_.changed AS changed_100, c10_.firstName AS firstName_101, c10_.middleName AS middleName_102, c10_.lastName AS lastName_103, c10_.birthday AS birthday_104, c10_.salutation AS salutation_105, c10_.formOfAddress AS formOfAddress_106, c10_.newsletter AS newsletter_107, c10_.gender AS gender_108, c10_.note AS note_109, c10_.mainEmail AS mainEmail_110, c10_.mainPhone AS mainPhone_111, c10_.mainFax AS mainFax_112, c10_.mainUrl AS mainUrl_113, c10_.id AS id_114, c10_.created AS created_115, c10_.changed AS changed_116, m11_.type AS type_117, m11_.id AS id_118, m11_.created AS created_119, m11_.changed AS changed_120, m0_.idPreviewImage AS idPreviewImage_121, m0_.idCollections AS idCollections_122, m0_.idUsersCreator AS idUsersCreator_123, m0_.idUsersChanger AS idUsersChanger_124, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_125, m1_.idCollectionTypes AS idCollectionTypes_126, m1_.idCollectionsParent AS idCollectionsParent_127, m1_.idUsersCreator AS idUsersCreator_128, m1_.idUsersChanger AS idUsersChanger_129, m2_.idMedia AS idMedia_130, m2_.idUsersCreator AS idUsersCreator_131, m2_.idUsersChanger AS idUsersChanger_132, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_133, m3_.idFiles AS idFiles_134, m3_.idUsersCreator AS idUsersCreator_135, m3_.idUsersChanger AS idUsersChanger_136, m4_.fileVersion AS fileVersion_137, m5_.idFileVersions AS idFileVersions_138, m6_.idFileVersions AS idFileVersions_139, s7_.idContacts AS idContacts_140, s7_.idUsersCreator AS idUsersCreator_141, s7_.idUsersChanger AS idUsersChanger_142, c8_.idTitles AS idTitles_143, c8_.avatar AS avatar_144, c8_.idUsersCreator AS idUsersCreator_145, c8_.idUsersChanger AS idUsersChanger_146, s9_.idContacts AS idContacts_147, s9_.idUsersCreator AS idUsersCreator_148, s9_.idUsersChanger AS idUsersChanger_149, c10_.idTitles AS idTitles_150, c10_.avatar AS avatar_151, c10_.idUsersCreator AS idUsersCreator_152, c10_.idUsersChanger AS idUsersChanger_153, m11_.idPreviewImage AS idPreviewImage_154, m11_.idCollections AS idCollections_155, m11_.idUsersCreator AS idUsersCreator_156, m11_.idUsersChanger AS idUsersChanger_157 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id LEFT JOIN me_files m2_ ON m0_.id = m2_.idMedia LEFT JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles LEFT JOIN me_format_options m4_ ON m3_.id = m4_.fileVersion 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 LEFT JOIN me_media m11_ ON m0_.idPreviewImage = m11_.id WHERE m0_.id = ?
SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.style AS style_4, m1_.lft AS lft_5, m1_.rgt AS rgt_6, m1_.depth AS depth_7, m1_.collection_key AS collection_key_8, m1_.id AS id_9, m1_.created AS created_10, m1_.changed AS changed_11, m2_.version AS version_12, m2_.id AS id_13, m2_.created AS created_14, m2_.changed AS changed_15, m3_.name AS name_16, m3_.version AS version_17, m3_.subVersion AS subVersion_18, m3_.size AS size_19, m3_.downloadCounter AS downloadCounter_20, m3_.storageOptions AS storageOptions_21, m3_.mimeType AS mimeType_22, m3_.properties AS properties_23, m3_.focusPointX AS focusPointX_24, m3_.focusPointY AS focusPointY_25, m3_.origin AS origin_26, m3_.aiDisclosureDisabled AS aiDisclosureDisabled_27, m3_.aiDisclosureIconVariant AS aiDisclosureIconVariant_28, m3_.id AS id_29, m3_.created AS created_30, m3_.changed AS changed_31, m4_.crop_x AS crop_x_32, m4_.crop_y AS crop_y_33, m4_.crop_width AS crop_width_34, m4_.crop_height AS crop_height_35, m4_.format_key AS format_key_36, m5_.title AS title_37, m5_.description AS description_38, m5_.aiDisclosureText AS aiDisclosureText_39, m5_.copyright AS copyright_40, m5_.credits AS credits_41, m5_.locale AS locale_42, m5_.id AS id_43, m6_.title AS title_44, m6_.description AS description_45, m6_.aiDisclosureText AS aiDisclosureText_46, m6_.copyright AS copyright_47, m6_.credits AS credits_48, m6_.locale AS locale_49, m6_.id AS id_50, s7_.username AS username_51, s7_.password AS password_52, s7_.locale AS locale_53, s7_.salt AS salt_54, s7_.locked AS locked_55, s7_.enabled AS enabled_56, s7_.lastLogin AS lastLogin_57, s7_.confirmationKey AS confirmationKey_58, s7_.passwordResetToken AS passwordResetToken_59, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_60, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_61, s7_.privateKey AS privateKey_62, s7_.apiKey AS apiKey_63, s7_.email AS email_64, s7_.id AS id_65, s7_.created AS created_66, s7_.changed AS changed_67, c8_.firstName AS firstName_68, c8_.middleName AS middleName_69, c8_.lastName AS lastName_70, c8_.birthday AS birthday_71, c8_.salutation AS salutation_72, c8_.formOfAddress AS formOfAddress_73, c8_.newsletter AS newsletter_74, c8_.gender AS gender_75, c8_.note AS note_76, c8_.mainEmail AS mainEmail_77, c8_.mainPhone AS mainPhone_78, c8_.mainFax AS mainFax_79, c8_.mainUrl AS mainUrl_80, c8_.id AS id_81, c8_.created AS created_82, c8_.changed AS changed_83, s9_.username AS username_84, s9_.password AS password_85, s9_.locale AS locale_86, s9_.salt AS salt_87, s9_.locked AS locked_88, s9_.enabled AS enabled_89, s9_.lastLogin AS lastLogin_90, s9_.confirmationKey AS confirmationKey_91, s9_.passwordResetToken AS passwordResetToken_92, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_93, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_94, s9_.privateKey AS privateKey_95, s9_.apiKey AS apiKey_96, s9_.email AS email_97, s9_.id AS id_98, s9_.created AS created_99, s9_.changed AS changed_100, c10_.firstName AS firstName_101, c10_.middleName AS middleName_102, c10_.lastName AS lastName_103, c10_.birthday AS birthday_104, c10_.salutation AS salutation_105, c10_.formOfAddress AS formOfAddress_106, c10_.newsletter AS newsletter_107, c10_.gender AS gender_108, c10_.note AS note_109, c10_.mainEmail AS mainEmail_110, c10_.mainPhone AS mainPhone_111, c10_.mainFax AS mainFax_112, c10_.mainUrl AS mainUrl_113, c10_.id AS id_114, c10_.created AS created_115, c10_.changed AS changed_116, m11_.type AS type_117, m11_.id AS id_118, m11_.created AS created_119, m11_.changed AS changed_120, m0_.idPreviewImage AS idPreviewImage_121, m0_.idCollections AS idCollections_122, m0_.idUsersCreator AS idUsersCreator_123, m0_.idUsersChanger AS idUsersChanger_124, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_125, m1_.idCollectionTypes AS idCollectionTypes_126, m1_.idCollectionsParent AS idCollectionsParent_127, m1_.idUsersCreator AS idUsersCreator_128, m1_.idUsersChanger AS idUsersChanger_129, m2_.idMedia AS idMedia_130, m2_.idUsersCreator AS idUsersCreator_131, m2_.idUsersChanger AS idUsersChanger_132, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_133, m3_.idFiles AS idFiles_134, m3_.idUsersCreator AS idUsersCreator_135, m3_.idUsersChanger AS idUsersChanger_136, m4_.fileVersion AS fileVersion_137, m5_.idFileVersions AS idFileVersions_138, m6_.idFileVersions AS idFileVersions_139, s7_.idContacts AS idContacts_140, s7_.idUsersCreator AS idUsersCreator_141, s7_.idUsersChanger AS idUsersChanger_142, c8_.idTitles AS idTitles_143, c8_.avatar AS avatar_144, c8_.idUsersCreator AS idUsersCreator_145, c8_.idUsersChanger AS idUsersChanger_146, s9_.idContacts AS idContacts_147, s9_.idUsersCreator AS idUsersCreator_148, s9_.idUsersChanger AS idUsersChanger_149, c10_.idTitles AS idTitles_150, c10_.avatar AS avatar_151, c10_.idUsersCreator AS idUsersCreator_152, c10_.idUsersChanger AS idUsersChanger_153, m11_.idPreviewImage AS idPreviewImage_154, m11_.idCollections AS idCollections_155, m11_.idUsersCreator AS idUsersCreator_156, m11_.idUsersChanger AS idUsersChanger_157 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id LEFT JOIN me_files m2_ ON m0_.id = m2_.idMedia LEFT JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles LEFT JOIN me_format_options m4_ ON m3_.id = m4_.fileVersion 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 LEFT JOIN me_media m11_ ON m0_.idPreviewImage = m11_.id WHERE m0_.id = ?
SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.style AS style_4, m1_.lft AS lft_5, m1_.rgt AS rgt_6, m1_.depth AS depth_7, m1_.collection_key AS collection_key_8, m1_.id AS id_9, m1_.created AS created_10, m1_.changed AS changed_11, m2_.version AS version_12, m2_.id AS id_13, m2_.created AS created_14, m2_.changed AS changed_15, m3_.name AS name_16, m3_.version AS version_17, m3_.subVersion AS subVersion_18, m3_.size AS size_19, m3_.downloadCounter AS downloadCounter_20, m3_.storageOptions AS storageOptions_21, m3_.mimeType AS mimeType_22, m3_.properties AS properties_23, m3_.focusPointX AS focusPointX_24, m3_.focusPointY AS focusPointY_25, m3_.origin AS origin_26, m3_.aiDisclosureDisabled AS aiDisclosureDisabled_27, m3_.aiDisclosureIconVariant AS aiDisclosureIconVariant_28, m3_.id AS id_29, m3_.created AS created_30, m3_.changed AS changed_31, m4_.crop_x AS crop_x_32, m4_.crop_y AS crop_y_33, m4_.crop_width AS crop_width_34, m4_.crop_height AS crop_height_35, m4_.format_key AS format_key_36, m5_.title AS title_37, m5_.description AS description_38, m5_.aiDisclosureText AS aiDisclosureText_39, m5_.copyright AS copyright_40, m5_.credits AS credits_41, m5_.locale AS locale_42, m5_.id AS id_43, m6_.title AS title_44, m6_.description AS description_45, m6_.aiDisclosureText AS aiDisclosureText_46, m6_.copyright AS copyright_47, m6_.credits AS credits_48, m6_.locale AS locale_49, m6_.id AS id_50, s7_.username AS username_51, s7_.password AS password_52, s7_.locale AS locale_53, s7_.salt AS salt_54, s7_.locked AS locked_55, s7_.enabled AS enabled_56, s7_.lastLogin AS lastLogin_57, s7_.confirmationKey AS confirmationKey_58, s7_.passwordResetToken AS passwordResetToken_59, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_60, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_61, s7_.privateKey AS privateKey_62, s7_.apiKey AS apiKey_63, s7_.email AS email_64, s7_.id AS id_65, s7_.created AS created_66, s7_.changed AS changed_67, c8_.firstName AS firstName_68, c8_.middleName AS middleName_69, c8_.lastName AS lastName_70, c8_.birthday AS birthday_71, c8_.salutation AS salutation_72, c8_.formOfAddress AS formOfAddress_73, c8_.newsletter AS newsletter_74, c8_.gender AS gender_75, c8_.note AS note_76, c8_.mainEmail AS mainEmail_77, c8_.mainPhone AS mainPhone_78, c8_.mainFax AS mainFax_79, c8_.mainUrl AS mainUrl_80, c8_.id AS id_81, c8_.created AS created_82, c8_.changed AS changed_83, s9_.username AS username_84, s9_.password AS password_85, s9_.locale AS locale_86, s9_.salt AS salt_87, s9_.locked AS locked_88, s9_.enabled AS enabled_89, s9_.lastLogin AS lastLogin_90, s9_.confirmationKey AS confirmationKey_91, s9_.passwordResetToken AS passwordResetToken_92, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_93, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_94, s9_.privateKey AS privateKey_95, s9_.apiKey AS apiKey_96, s9_.email AS email_97, s9_.id AS id_98, s9_.created AS created_99, s9_.changed AS changed_100, c10_.firstName AS firstName_101, c10_.middleName AS middleName_102, c10_.lastName AS lastName_103, c10_.birthday AS birthday_104, c10_.salutation AS salutation_105, c10_.formOfAddress AS formOfAddress_106, c10_.newsletter AS newsletter_107, c10_.gender AS gender_108, c10_.note AS note_109, c10_.mainEmail AS mainEmail_110, c10_.mainPhone AS mainPhone_111, c10_.mainFax AS mainFax_112, c10_.mainUrl AS mainUrl_113, c10_.id AS id_114, c10_.created AS created_115, c10_.changed AS changed_116, m11_.type AS type_117, m11_.id AS id_118, m11_.created AS created_119, m11_.changed AS changed_120, m0_.idPreviewImage AS idPreviewImage_121, m0_.idCollections AS idCollections_122, m0_.idUsersCreator AS idUsersCreator_123, m0_.idUsersChanger AS idUsersChanger_124, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_125, m1_.idCollectionTypes AS idCollectionTypes_126, m1_.idCollectionsParent AS idCollectionsParent_127, m1_.idUsersCreator AS idUsersCreator_128, m1_.idUsersChanger AS idUsersChanger_129, m2_.idMedia AS idMedia_130, m2_.idUsersCreator AS idUsersCreator_131, m2_.idUsersChanger AS idUsersChanger_132, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_133, m3_.idFiles AS idFiles_134, m3_.idUsersCreator AS idUsersCreator_135, m3_.idUsersChanger AS idUsersChanger_136, m4_.fileVersion AS fileVersion_137, m5_.idFileVersions AS idFileVersions_138, m6_.idFileVersions AS idFileVersions_139, s7_.idContacts AS idContacts_140, s7_.idUsersCreator AS idUsersCreator_141, s7_.idUsersChanger AS idUsersChanger_142, c8_.idTitles AS idTitles_143, c8_.avatar AS avatar_144, c8_.idUsersCreator AS idUsersCreator_145, c8_.idUsersChanger AS idUsersChanger_146, s9_.idContacts AS idContacts_147, s9_.idUsersCreator AS idUsersCreator_148, s9_.idUsersChanger AS idUsersChanger_149, c10_.idTitles AS idTitles_150, c10_.avatar AS avatar_151, c10_.idUsersCreator AS idUsersCreator_152, c10_.idUsersChanger AS idUsersChanger_153, m11_.idPreviewImage AS idPreviewImage_154, m11_.idCollections AS idCollections_155, m11_.idUsersCreator AS idUsersCreator_156, m11_.idUsersChanger AS idUsersChanger_157 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id LEFT JOIN me_files m2_ ON m0_.id = m2_.idMedia LEFT JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles LEFT JOIN me_format_options m4_ ON m3_.id = m4_.fileVersion 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 LEFT JOIN me_media m11_ ON m0_.idPreviewImage = m11_.id WHERE m0_.id = ?
SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.style AS style_4, m1_.lft AS lft_5, m1_.rgt AS rgt_6, m1_.depth AS depth_7, m1_.collection_key AS collection_key_8, m1_.id AS id_9, m1_.created AS created_10, m1_.changed AS changed_11, m2_.version AS version_12, m2_.id AS id_13, m2_.created AS created_14, m2_.changed AS changed_15, m3_.name AS name_16, m3_.version AS version_17, m3_.subVersion AS subVersion_18, m3_.size AS size_19, m3_.downloadCounter AS downloadCounter_20, m3_.storageOptions AS storageOptions_21, m3_.mimeType AS mimeType_22, m3_.properties AS properties_23, m3_.focusPointX AS focusPointX_24, m3_.focusPointY AS focusPointY_25, m3_.origin AS origin_26, m3_.aiDisclosureDisabled AS aiDisclosureDisabled_27, m3_.aiDisclosureIconVariant AS aiDisclosureIconVariant_28, m3_.id AS id_29, m3_.created AS created_30, m3_.changed AS changed_31, m4_.crop_x AS crop_x_32, m4_.crop_y AS crop_y_33, m4_.crop_width AS crop_width_34, m4_.crop_height AS crop_height_35, m4_.format_key AS format_key_36, m5_.title AS title_37, m5_.description AS description_38, m5_.aiDisclosureText AS aiDisclosureText_39, m5_.copyright AS copyright_40, m5_.credits AS credits_41, m5_.locale AS locale_42, m5_.id AS id_43, m6_.title AS title_44, m6_.description AS description_45, m6_.aiDisclosureText AS aiDisclosureText_46, m6_.copyright AS copyright_47, m6_.credits AS credits_48, m6_.locale AS locale_49, m6_.id AS id_50, s7_.username AS username_51, s7_.password AS password_52, s7_.locale AS locale_53, s7_.salt AS salt_54, s7_.locked AS locked_55, s7_.enabled AS enabled_56, s7_.lastLogin AS lastLogin_57, s7_.confirmationKey AS confirmationKey_58, s7_.passwordResetToken AS passwordResetToken_59, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_60, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_61, s7_.privateKey AS privateKey_62, s7_.apiKey AS apiKey_63, s7_.email AS email_64, s7_.id AS id_65, s7_.created AS created_66, s7_.changed AS changed_67, c8_.firstName AS firstName_68, c8_.middleName AS middleName_69, c8_.lastName AS lastName_70, c8_.birthday AS birthday_71, c8_.salutation AS salutation_72, c8_.formOfAddress AS formOfAddress_73, c8_.newsletter AS newsletter_74, c8_.gender AS gender_75, c8_.note AS note_76, c8_.mainEmail AS mainEmail_77, c8_.mainPhone AS mainPhone_78, c8_.mainFax AS mainFax_79, c8_.mainUrl AS mainUrl_80, c8_.id AS id_81, c8_.created AS created_82, c8_.changed AS changed_83, s9_.username AS username_84, s9_.password AS password_85, s9_.locale AS locale_86, s9_.salt AS salt_87, s9_.locked AS locked_88, s9_.enabled AS enabled_89, s9_.lastLogin AS lastLogin_90, s9_.confirmationKey AS confirmationKey_91, s9_.passwordResetToken AS passwordResetToken_92, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_93, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_94, s9_.privateKey AS privateKey_95, s9_.apiKey AS apiKey_96, s9_.email AS email_97, s9_.id AS id_98, s9_.created AS created_99, s9_.changed AS changed_100, c10_.firstName AS firstName_101, c10_.middleName AS middleName_102, c10_.lastName AS lastName_103, c10_.birthday AS birthday_104, c10_.salutation AS salutation_105, c10_.formOfAddress AS formOfAddress_106, c10_.newsletter AS newsletter_107, c10_.gender AS gender_108, c10_.note AS note_109, c10_.mainEmail AS mainEmail_110, c10_.mainPhone AS mainPhone_111, c10_.mainFax AS mainFax_112, c10_.mainUrl AS mainUrl_113, c10_.id AS id_114, c10_.created AS created_115, c10_.changed AS changed_116, m11_.type AS type_117, m11_.id AS id_118, m11_.created AS created_119, m11_.changed AS changed_120, m0_.idPreviewImage AS idPreviewImage_121, m0_.idCollections AS idCollections_122, m0_.idUsersCreator AS idUsersCreator_123, m0_.idUsersChanger AS idUsersChanger_124, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_125, m1_.idCollectionTypes AS idCollectionTypes_126, m1_.idCollectionsParent AS idCollectionsParent_127, m1_.idUsersCreator AS idUsersCreator_128, m1_.idUsersChanger AS idUsersChanger_129, m2_.idMedia AS idMedia_130, m2_.idUsersCreator AS idUsersCreator_131, m2_.idUsersChanger AS idUsersChanger_132, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_133, m3_.idFiles AS idFiles_134, m3_.idUsersCreator AS idUsersCreator_135, m3_.idUsersChanger AS idUsersChanger_136, m4_.fileVersion AS fileVersion_137, m5_.idFileVersions AS idFileVersions_138, m6_.idFileVersions AS idFileVersions_139, s7_.idContacts AS idContacts_140, s7_.idUsersCreator AS idUsersCreator_141, s7_.idUsersChanger AS idUsersChanger_142, c8_.idTitles AS idTitles_143, c8_.avatar AS avatar_144, c8_.idUsersCreator AS idUsersCreator_145, c8_.idUsersChanger AS idUsersChanger_146, s9_.idContacts AS idContacts_147, s9_.idUsersCreator AS idUsersCreator_148, s9_.idUsersChanger AS idUsersChanger_149, c10_.idTitles AS idTitles_150, c10_.avatar AS avatar_151, c10_.idUsersCreator AS idUsersCreator_152, c10_.idUsersChanger AS idUsersChanger_153, m11_.idPreviewImage AS idPreviewImage_154, m11_.idCollections AS idCollections_155, m11_.idUsersCreator AS idUsersCreator_156, m11_.idUsersChanger AS idUsersChanger_157 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id LEFT JOIN me_files m2_ ON m0_.id = m2_.idMedia LEFT JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles LEFT JOIN me_format_options m4_ ON m3_.id = m4_.fileVersion 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 LEFT JOIN me_media m11_ ON m0_.idPreviewImage = m11_.id WHERE m0_.id = ?
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 = ?
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 (?)))
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 = ?
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 (?)))
SELECT dc.title FROM ro_routes route INNER JOIN pa_page_dimension_contents dc ON dc.route_id = route.id WHERE route.slug = '/' AND route.locale = ? AND (? IS NULL OR route.webspace = ?) AND dc.stage = 'live' LIMIT 1
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 = ?
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 (?)))
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 = ?
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 (?)))
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 = ?
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 (?)))
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 = ?
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 (?)))
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 = ?
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 (?)))
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 = ?
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 (?)))
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 = ?
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 (?)))
SELECT page.uuid FROM ro_routes route INNER JOIN pa_page_dimension_contents dc ON dc.route_id = route.id INNER JOIN pa_pages page ON page.uuid = dc.pageUuid WHERE route.slug = ? AND route.locale = ? AND (? IS NULL OR route.webspace = ?) AND dc.stage = 'live' LIMIT 1
SELECT dc.title, route.slug, page.webspaceKey AS webspace,
           dc.templateData, dc.linkProvider, dc.linkData, dc.seoData, dc.authored
    FROM pa_pages page
    INNER JOIN pa_pages parent ON parent.uuid = page.parent_id
    INNER JOIN pa_page_dimension_contents dc ON dc.pageUuid = page.uuid
    INNER JOIN ro_routes route ON route.id = dc.route_id
    WHERE parent.uuid = ?
      AND dc.locale = ?
      AND dc.stage = 'live'
      AND route.slug IS NOT NULL
    ORDER BY CASE
                 WHEN JSON_EXTRACT(dc.templateData, '$.displayOrder')
                      IS NULL THEN 1 ELSE 0
             END,
             CAST(JSON_EXTRACT(dc.templateData, '$.displayOrder')
                  AS SIGNED),
             page.lft
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 = ?
SELECT webspaceKey FROM pa_pages WHERE uuid = ? LIMIT 1
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 = ?
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 (?)))
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 = ?
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 (?)))
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 = ?
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 (?)))
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 = ?
SELECT webspaceKey FROM pa_pages WHERE uuid = ? LIMIT 1
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 = ?
SELECT webspaceKey FROM pa_pages WHERE uuid = ? LIMIT 1
SELECT w0_.title AS title_0, w0_.webspace_key AS webspace_key_1, w0_.all_domains AS all_domains_2, w0_.content AS content_3, w0_.type AS type_4, w0_.id AS id_5, w1_.url AS url_6, w1_.environment AS environment_7, w1_.id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain WHERE (w0_.all_domains = 1 OR (w1_.url = ? AND w1_.environment = ?)) AND w0_.webspace_key = ? ORDER BY w0_.id ASC
Database Connections

Name	Service
default	doctrine.dbal.default_connection
Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
Second Level Cache

Second Level Cache is not enabled.
Managed Entities

default entity manager

Class	Amount of managed objects
Sulu\Bundle\MediaBundle\Entity\Media	27
Sulu\Bundle\MediaBundle\Entity\File	27
Sulu\Bundle\MediaBundle\Entity\FileVersion	27
Sulu\Bundle\MediaBundle\Entity\FileVersionMeta	27
Sulu\Snippet\Domain\Model\SnippetDimensionContent	12
Sulu\Snippet\Domain\Model\SnippetArea	6
Sulu\Snippet\Domain\Model\Snippet	6
Sulu\Route\Domain\Model\Route	3
Sulu\Page\Domain\Model\PageDimensionContent	2
Sulu\Bundle\SecurityBundle\Entity\User	2
Sulu\Bundle\ContactBundle\Entity\Contact	2
Sulu\Page\Domain\Model\Page	1
Sulu\Bundle\MediaBundle\Entity\Collection	1
Sulu\Bundle\MediaBundle\Entity\CollectionMeta	1
Sulu\Bundle\MediaBundle\Entity\CollectionType	1
Entities Mapping

Class	Mapping errors
Sulu\Route\Domain\Model\Route	No errors.
Sulu\Page\Domain\Model\Page	No errors.
Sulu\Bundle\ReferenceBundle\Domain\Model\Reference	No errors.
Sulu\Bundle\TagBundle\Entity\Tag	No errors.
Sulu\Bundle\CategoryBundle\Entity\Category	No errors.
Sulu\Bundle\ContactBundle\Entity\Contact	No errors.
Sulu\Page\Domain\Model\PageDimensionContent	No errors.
Sulu\Bundle\MediaBundle\Entity\Collection	No errors.
Sulu\Bundle\TrashBundle\Domain\Model\TrashItem	No errors.
Sulu\Bundle\CategoryBundle\Entity\CategoryTranslation	No errors.
Sulu\Bundle\SecurityBundle\Entity\User	No errors.
Sulu\Page\Domain\Model\PageDimensionContentNavigationContext	No errors.
Sulu\Bundle\ContactBundle\Entity\ContactTitle	No errors.
Sulu\Article\Domain\Model\Article	No errors.
Sulu\Article\Domain\Model\ArticleDimensionContent	No errors.
Sulu\Snippet\Domain\Model\Snippet	No errors.
Sulu\Snippet\Domain\Model\SnippetDimensionContent	No errors.
Sulu\Bundle\MediaBundle\Entity\Media	No errors.
Sulu\Bundle\MediaBundle\Entity\File	No errors.
Sulu\Bundle\MediaBundle\Entity\FileVersion	No errors.
Sulu\Bundle\MediaBundle\Entity\FileVersionMeta	No errors.
Sulu\Bundle\MediaBundle\Entity\CollectionMeta	No errors.
Sulu\Bundle\MediaBundle\Entity\CollectionType	No errors.
Sulu\Bundle\MediaBundle\Entity\FormatOptions	No errors.
Sulu\Bundle\SecurityBundle\Entity\UserTwoFactor	No errors.
Sulu\Bundle\SecurityBundle\Entity\UserRole	No errors.
Sulu\Bundle\SecurityBundle\Entity\UserSetting	No errors.
Sulu\Bundle\ContactBundle\Entity\ContactLocale	No errors.
Sulu\Bundle\ContactBundle\Entity\ContactAddress	No errors.
Sulu\Bundle\ContactBundle\Entity\AccountContact	No errors.
Sulu\Bundle\ContactBundle\Entity\Url	No errors.
Sulu\Bundle\ContactBundle\Entity\Note	No errors.
Sulu\Bundle\ContactBundle\Entity\Email	No errors.
Sulu\Bundle\ContactBundle\Entity\Phone	No errors.
Sulu\Bundle\ContactBundle\Entity\Fax	No errors.
Sulu\Bundle\ContactBundle\Entity\SocialMediaProfile	No errors.
Sulu\Bundle\ContactBundle\Entity\BankAccount	No errors.
Sulu\Snippet\Domain\Model\SnippetArea	No errors.
Sulu\Bundle\WebsiteBundle\Entity\Analytics	No errors.
Sulu\Bundle\WebsiteBundle\Entity\Domain	No errors.
Symfony Profiler

GET http://chalet-antoine.ewm.dev/en

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping
