3.36 ms (3.61%)
|
2 |
SELECT m0_.id AS id_0, m0_.created AS created_1, m0_.changed AS changed_2, m1_.name AS name_3, m1_.description AS description_4, m1_.id AS id_5, m2_.style AS style_6, m2_.lft AS lft_7, m2_.rgt AS rgt_8, m2_.depth AS depth_9, m2_.collection_key AS collection_key_10, m2_.id AS id_11, m2_.created AS created_12, m2_.changed AS changed_13, m3_.version AS version_14, m3_.id AS id_15, m3_.created AS created_16, m3_.changed AS changed_17, m4_.name AS name_18, m4_.version AS version_19, m4_.subVersion AS subVersion_20, m4_.size AS size_21, m4_.downloadCounter AS downloadCounter_22, m4_.storageOptions AS storageOptions_23, m4_.mimeType AS mimeType_24, m4_.properties AS properties_25, m4_.focusPointX AS focusPointX_26, m4_.focusPointY AS focusPointY_27, m4_.origin AS origin_28, m4_.aiDisclosureDisabled AS aiDisclosureDisabled_29, m4_.aiDisclosureIconVariant AS aiDisclosureIconVariant_30, m4_.id AS id_31, m4_.created AS created_32, m4_.changed AS changed_33, t5_.name AS name_34, t5_.id AS id_35, t5_.created AS created_36, t5_.changed AS changed_37, m6_.title AS title_38, m6_.description AS description_39, m6_.aiDisclosureText AS aiDisclosureText_40, m6_.copyright AS copyright_41, m6_.credits AS credits_42, m6_.locale AS locale_43, m6_.id AS id_44, m7_.title AS title_45, m7_.description AS description_46, m7_.aiDisclosureText AS aiDisclosureText_47, m7_.copyright AS copyright_48, m7_.credits AS credits_49, m7_.locale AS locale_50, m7_.id AS id_51, m8_.locale AS locale_52, m8_.id AS id_53, m9_.locale AS locale_54, m9_.id AS id_55, s10_.username AS username_56, s10_.password AS password_57, s10_.locale AS locale_58, s10_.salt AS salt_59, s10_.locked AS locked_60, s10_.enabled AS enabled_61, s10_.lastLogin AS lastLogin_62, s10_.confirmationKey AS confirmationKey_63, s10_.passwordResetToken AS passwordResetToken_64, s10_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_65, s10_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_66, s10_.privateKey AS privateKey_67, s10_.apiKey AS apiKey_68, s10_.email AS email_69, s10_.id AS id_70, s10_.created AS created_71, s10_.changed AS changed_72, c11_.firstName AS firstName_73, c11_.middleName AS middleName_74, c11_.lastName AS lastName_75, c11_.birthday AS birthday_76, c11_.salutation AS salutation_77, c11_.formOfAddress AS formOfAddress_78, c11_.newsletter AS newsletter_79, c11_.gender AS gender_80, c11_.note AS note_81, c11_.mainEmail AS mainEmail_82, c11_.mainPhone AS mainPhone_83, c11_.mainFax AS mainFax_84, c11_.mainUrl AS mainUrl_85, c11_.id AS id_86, c11_.created AS created_87, c11_.changed AS changed_88, s12_.username AS username_89, s12_.password AS password_90, s12_.locale AS locale_91, s12_.salt AS salt_92, s12_.locked AS locked_93, s12_.enabled AS enabled_94, s12_.lastLogin AS lastLogin_95, s12_.confirmationKey AS confirmationKey_96, s12_.passwordResetToken AS passwordResetToken_97, s12_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_98, s12_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_99, s12_.privateKey AS privateKey_100, s12_.apiKey AS apiKey_101, s12_.email AS email_102, s12_.id AS id_103, s12_.created AS created_104, s12_.changed AS changed_105, c13_.firstName AS firstName_106, c13_.middleName AS middleName_107, c13_.lastName AS lastName_108, c13_.birthday AS birthday_109, c13_.salutation AS salutation_110, c13_.formOfAddress AS formOfAddress_111, c13_.newsletter AS newsletter_112, c13_.gender AS gender_113, c13_.note AS note_114, c13_.mainEmail AS mainEmail_115, c13_.mainPhone AS mainPhone_116, c13_.mainFax AS mainFax_117, c13_.mainUrl AS mainUrl_118, c13_.id AS id_119, c13_.created AS created_120, c13_.changed AS changed_121, m0_.idMediaTypes AS idMediaTypes_122, m0_.idPreviewImage AS idPreviewImage_123, m0_.idCollections AS idCollections_124, m0_.idUsersCreator AS idUsersCreator_125, m0_.idUsersChanger AS idUsersChanger_126, m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_127, m2_.idCollectionTypes AS idCollectionTypes_128, m2_.idCollectionsParent AS idCollectionsParent_129, m2_.idUsersCreator AS idUsersCreator_130, m2_.idUsersChanger AS idUsersChanger_131, m3_.idMedia AS idMedia_132, m3_.idUsersCreator AS idUsersCreator_133, m3_.idUsersChanger AS idUsersChanger_134, m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_135, m4_.idFiles AS idFiles_136, m4_.idUsersCreator AS idUsersCreator_137, m4_.idUsersChanger AS idUsersChanger_138, t5_.idUsersCreator AS idUsersCreator_139, t5_.idUsersChanger AS idUsersChanger_140, m6_.idFileVersions AS idFileVersions_141, m7_.idFileVersions AS idFileVersions_142, m8_.idFileVersions AS idFileVersions_143, m9_.idFileVersions AS idFileVersions_144, s10_.idContacts AS idContacts_145, s10_.idUsersCreator AS idUsersCreator_146, s10_.idUsersChanger AS idUsersChanger_147, c11_.idTitles AS idTitles_148, c11_.avatar AS avatar_149, c11_.idUsersCreator AS idUsersCreator_150, c11_.idUsersChanger AS idUsersChanger_151, s12_.idContacts AS idContacts_152, s12_.idUsersCreator AS idUsersCreator_153, s12_.idUsersChanger AS idUsersChanger_154, c13_.idTitles AS idTitles_155, c13_.avatar AS avatar_156, c13_.idUsersCreator AS idUsersCreator_157, c13_.idUsersChanger AS idUsersChanger_158 FROM me_media m0_ LEFT JOIN me_media_types m1_ ON m0_.idMediaTypes = m1_.id LEFT JOIN me_collections m2_ ON m0_.idCollections = m2_.id INNER JOIN me_files m3_ ON m0_.id = m3_.idMedia INNER JOIN me_file_versions m4_ ON m3_.id = m4_.idFiles AND (m4_.version = m3_.version) LEFT JOIN me_file_version_tags m14_ ON m4_.id = m14_.idFileVersions LEFT JOIN ta_tags t5_ ON t5_.id = m14_.idTags LEFT JOIN me_file_version_meta m6_ ON m4_.id = m6_.idFileVersions LEFT JOIN me_file_version_meta m7_ ON m4_.idFileVersionsMetaDefault = m7_.id LEFT JOIN me_file_version_content_languages m8_ ON m4_.id = m8_.idFileVersions LEFT JOIN me_file_version_publish_languages m9_ ON m4_.id = m9_.idFileVersions LEFT JOIN se_users s10_ ON m0_.idUsersCreator = s10_.id LEFT JOIN co_contacts c11_ ON s10_.idContacts = c11_.id LEFT JOIN se_users s12_ ON m0_.idUsersChanger = s12_.id LEFT JOIN co_contacts c13_ ON s12_.idContacts = c13_.id WHERE m0_.id IN (?) ORDER BY m0_.id ASC
SELECT
m0_.id AS id_0,
m0_.created AS created_1,
m0_.changed AS changed_2,
m1_.name AS name_3,
m1_.description AS description_4,
m1_.id AS id_5,
m2_.style AS style_6,
m2_.lft AS lft_7,
m2_.rgt AS rgt_8,
m2_.depth AS depth_9,
m2_.collection_key AS collection_key_10,
m2_.id AS id_11,
m2_.created AS created_12,
m2_.changed AS changed_13,
m3_.version AS version_14,
m3_.id AS id_15,
m3_.created AS created_16,
m3_.changed AS changed_17,
m4_.name AS name_18,
m4_.version AS version_19,
m4_.subVersion AS subVersion_20,
m4_.size AS size_21,
m4_.downloadCounter AS downloadCounter_22,
m4_.storageOptions AS storageOptions_23,
m4_.mimeType AS mimeType_24,
m4_.properties AS properties_25,
m4_.focusPointX AS focusPointX_26,
m4_.focusPointY AS focusPointY_27,
m4_.origin AS origin_28,
m4_.aiDisclosureDisabled AS aiDisclosureDisabled_29,
m4_.aiDisclosureIconVariant AS aiDisclosureIconVariant_30,
m4_.id AS id_31,
m4_.created AS created_32,
m4_.changed AS changed_33,
t5_.name AS name_34,
t5_.id AS id_35,
t5_.created AS created_36,
t5_.changed AS changed_37,
m6_.title AS title_38,
m6_.description AS description_39,
m6_.aiDisclosureText AS aiDisclosureText_40,
m6_.copyright AS copyright_41,
m6_.credits AS credits_42,
m6_.locale AS locale_43,
m6_.id AS id_44,
m7_.title AS title_45,
m7_.description AS description_46,
m7_.aiDisclosureText AS aiDisclosureText_47,
m7_.copyright AS copyright_48,
m7_.credits AS credits_49,
m7_.locale AS locale_50,
m7_.id AS id_51,
m8_.locale AS locale_52,
m8_.id AS id_53,
m9_.locale AS locale_54,
m9_.id AS id_55,
s10_.username AS username_56,
s10_.password AS password_57,
s10_.locale AS locale_58,
s10_.salt AS salt_59,
s10_.locked AS locked_60,
s10_.enabled AS enabled_61,
s10_.lastLogin AS lastLogin_62,
s10_.confirmationKey AS confirmationKey_63,
s10_.passwordResetToken AS passwordResetToken_64,
s10_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_65,
s10_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_66,
s10_.privateKey AS privateKey_67,
s10_.apiKey AS apiKey_68,
s10_.email AS email_69,
s10_.id AS id_70,
s10_.created AS created_71,
s10_.changed AS changed_72,
c11_.firstName AS firstName_73,
c11_.middleName AS middleName_74,
c11_.lastName AS lastName_75,
c11_.birthday AS birthday_76,
c11_.salutation AS salutation_77,
c11_.formOfAddress AS formOfAddress_78,
c11_.newsletter AS newsletter_79,
c11_.gender AS gender_80,
c11_.note AS note_81,
c11_.mainEmail AS mainEmail_82,
c11_.mainPhone AS mainPhone_83,
c11_.mainFax AS mainFax_84,
c11_.mainUrl AS mainUrl_85,
c11_.id AS id_86,
c11_.created AS created_87,
c11_.changed AS changed_88,
s12_.username AS username_89,
s12_.password AS password_90,
s12_.locale AS locale_91,
s12_.salt AS salt_92,
s12_.locked AS locked_93,
s12_.enabled AS enabled_94,
s12_.lastLogin AS lastLogin_95,
s12_.confirmationKey AS confirmationKey_96,
s12_.passwordResetToken AS passwordResetToken_97,
s12_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_98,
s12_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_99,
s12_.privateKey AS privateKey_100,
s12_.apiKey AS apiKey_101,
s12_.email AS email_102,
s12_.id AS id_103,
s12_.created AS created_104,
s12_.changed AS changed_105,
c13_.firstName AS firstName_106,
c13_.middleName AS middleName_107,
c13_.lastName AS lastName_108,
c13_.birthday AS birthday_109,
c13_.salutation AS salutation_110,
c13_.formOfAddress AS formOfAddress_111,
c13_.newsletter AS newsletter_112,
c13_.gender AS gender_113,
c13_.note AS note_114,
c13_.mainEmail AS mainEmail_115,
c13_.mainPhone AS mainPhone_116,
c13_.mainFax AS mainFax_117,
c13_.mainUrl AS mainUrl_118,
c13_.id AS id_119,
c13_.created AS created_120,
c13_.changed AS changed_121,
m0_.idMediaTypes AS idMediaTypes_122,
m0_.idPreviewImage AS idPreviewImage_123,
m0_.idCollections AS idCollections_124,
m0_.idUsersCreator AS idUsersCreator_125,
m0_.idUsersChanger AS idUsersChanger_126,
m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_127,
m2_.idCollectionTypes AS idCollectionTypes_128,
m2_.idCollectionsParent AS idCollectionsParent_129,
m2_.idUsersCreator AS idUsersCreator_130,
m2_.idUsersChanger AS idUsersChanger_131,
m3_.idMedia AS idMedia_132,
m3_.idUsersCreator AS idUsersCreator_133,
m3_.idUsersChanger AS idUsersChanger_134,
m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_135,
m4_.idFiles AS idFiles_136,
m4_.idUsersCreator AS idUsersCreator_137,
m4_.idUsersChanger AS idUsersChanger_138,
t5_.idUsersCreator AS idUsersCreator_139,
t5_.idUsersChanger AS idUsersChanger_140,
m6_.idFileVersions AS idFileVersions_141,
m7_.idFileVersions AS idFileVersions_142,
m8_.idFileVersions AS idFileVersions_143,
m9_.idFileVersions AS idFileVersions_144,
s10_.idContacts AS idContacts_145,
s10_.idUsersCreator AS idUsersCreator_146,
s10_.idUsersChanger AS idUsersChanger_147,
c11_.idTitles AS idTitles_148,
c11_.avatar AS avatar_149,
c11_.idUsersCreator AS idUsersCreator_150,
c11_.idUsersChanger AS idUsersChanger_151,
s12_.idContacts AS idContacts_152,
s12_.idUsersCreator AS idUsersCreator_153,
s12_.idUsersChanger AS idUsersChanger_154,
c13_.idTitles AS idTitles_155,
c13_.avatar AS avatar_156,
c13_.idUsersCreator AS idUsersCreator_157,
c13_.idUsersChanger AS idUsersChanger_158
FROM
me_media m0_
LEFT JOIN me_media_types m1_ ON m0_.idMediaTypes = m1_.id
LEFT JOIN me_collections m2_ ON m0_.idCollections = m2_.id
INNER JOIN me_files m3_ ON m0_.id = m3_.idMedia
INNER JOIN me_file_versions m4_ ON m3_.id = m4_.idFiles
AND (m4_.version = m3_.version)
LEFT JOIN me_file_version_tags m14_ ON m4_.id = m14_.idFileVersions
LEFT JOIN ta_tags t5_ ON t5_.id = m14_.idTags
LEFT JOIN me_file_version_meta m6_ ON m4_.id = m6_.idFileVersions
LEFT JOIN me_file_version_meta m7_ ON m4_.idFileVersionsMetaDefault = m7_.id
LEFT JOIN me_file_version_content_languages m8_ ON m4_.id = m8_.idFileVersions
LEFT JOIN me_file_version_publish_languages m9_ ON m4_.id = m9_.idFileVersions
LEFT JOIN se_users s10_ ON m0_.idUsersCreator = s10_.id
LEFT JOIN co_contacts c11_ ON s10_.idContacts = c11_.id
LEFT JOIN se_users s12_ ON m0_.idUsersChanger = s12_.id
LEFT JOIN co_contacts c13_ ON s12_.idContacts = c13_.id
WHERE
m0_.id IN (?)
ORDER BY
m0_.id ASC
SELECT m0_.id AS id_0, m0_.created AS created_1, m0_.changed AS changed_2, m1_.name AS name_3, m1_.description AS description_4, m1_.id AS id_5, m2_.style AS style_6, m2_.lft AS lft_7, m2_.rgt AS rgt_8, m2_.depth AS depth_9, m2_.collection_key AS collection_key_10, m2_.id AS id_11, m2_.created AS created_12, m2_.changed AS changed_13, m3_.version AS version_14, m3_.id AS id_15, m3_.created AS created_16, m3_.changed AS changed_17, m4_.name AS name_18, m4_.version AS version_19, m4_.subVersion AS subVersion_20, m4_.size AS size_21, m4_.downloadCounter AS downloadCounter_22, m4_.storageOptions AS storageOptions_23, m4_.mimeType AS mimeType_24, m4_.properties AS properties_25, m4_.focusPointX AS focusPointX_26, m4_.focusPointY AS focusPointY_27, m4_.origin AS origin_28, m4_.aiDisclosureDisabled AS aiDisclosureDisabled_29, m4_.aiDisclosureIconVariant AS aiDisclosureIconVariant_30, m4_.id AS id_31, m4_.created AS created_32, m4_.changed AS changed_33, t5_.name AS name_34, t5_.id AS id_35, t5_.created AS created_36, t5_.changed AS changed_37, m6_.title AS title_38, m6_.description AS description_39, m6_.aiDisclosureText AS aiDisclosureText_40, m6_.copyright AS copyright_41, m6_.credits AS credits_42, m6_.locale AS locale_43, m6_.id AS id_44, m7_.title AS title_45, m7_.description AS description_46, m7_.aiDisclosureText AS aiDisclosureText_47, m7_.copyright AS copyright_48, m7_.credits AS credits_49, m7_.locale AS locale_50, m7_.id AS id_51, m8_.locale AS locale_52, m8_.id AS id_53, m9_.locale AS locale_54, m9_.id AS id_55, s10_.username AS username_56, s10_.password AS password_57, s10_.locale AS locale_58, s10_.salt AS salt_59, s10_.locked AS locked_60, s10_.enabled AS enabled_61, s10_.lastLogin AS lastLogin_62, s10_.confirmationKey AS confirmationKey_63, s10_.passwordResetToken AS passwordResetToken_64, s10_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_65, s10_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_66, s10_.privateKey AS privateKey_67, s10_.apiKey AS apiKey_68, s10_.email AS email_69, s10_.id AS id_70, s10_.created AS created_71, s10_.changed AS changed_72, c11_.firstName AS firstName_73, c11_.middleName AS middleName_74, c11_.lastName AS lastName_75, c11_.birthday AS birthday_76, c11_.salutation AS salutation_77, c11_.formOfAddress AS formOfAddress_78, c11_.newsletter AS newsletter_79, c11_.gender AS gender_80, c11_.note AS note_81, c11_.mainEmail AS mainEmail_82, c11_.mainPhone AS mainPhone_83, c11_.mainFax AS mainFax_84, c11_.mainUrl AS mainUrl_85, c11_.id AS id_86, c11_.created AS created_87, c11_.changed AS changed_88, s12_.username AS username_89, s12_.password AS password_90, s12_.locale AS locale_91, s12_.salt AS salt_92, s12_.locked AS locked_93, s12_.enabled AS enabled_94, s12_.lastLogin AS lastLogin_95, s12_.confirmationKey AS confirmationKey_96, s12_.passwordResetToken AS passwordResetToken_97, s12_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_98, s12_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_99, s12_.privateKey AS privateKey_100, s12_.apiKey AS apiKey_101, s12_.email AS email_102, s12_.id AS id_103, s12_.created AS created_104, s12_.changed AS changed_105, c13_.firstName AS firstName_106, c13_.middleName AS middleName_107, c13_.lastName AS lastName_108, c13_.birthday AS birthday_109, c13_.salutation AS salutation_110, c13_.formOfAddress AS formOfAddress_111, c13_.newsletter AS newsletter_112, c13_.gender AS gender_113, c13_.note AS note_114, c13_.mainEmail AS mainEmail_115, c13_.mainPhone AS mainPhone_116, c13_.mainFax AS mainFax_117, c13_.mainUrl AS mainUrl_118, c13_.id AS id_119, c13_.created AS created_120, c13_.changed AS changed_121, m0_.idMediaTypes AS idMediaTypes_122, m0_.idPreviewImage AS idPreviewImage_123, m0_.idCollections AS idCollections_124, m0_.idUsersCreator AS idUsersCreator_125, m0_.idUsersChanger AS idUsersChanger_126, m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_127, m2_.idCollectionTypes AS idCollectionTypes_128, m2_.idCollectionsParent AS idCollectionsParent_129, m2_.idUsersCreator AS idUsersCreator_130, m2_.idUsersChanger AS idUsersChanger_131, m3_.idMedia AS idMedia_132, m3_.idUsersCreator AS idUsersCreator_133, m3_.idUsersChanger AS idUsersChanger_134, m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_135, m4_.idFiles AS idFiles_136, m4_.idUsersCreator AS idUsersCreator_137, m4_.idUsersChanger AS idUsersChanger_138, t5_.idUsersCreator AS idUsersCreator_139, t5_.idUsersChanger AS idUsersChanger_140, m6_.idFileVersions AS idFileVersions_141, m7_.idFileVersions AS idFileVersions_142, m8_.idFileVersions AS idFileVersions_143, m9_.idFileVersions AS idFileVersions_144, s10_.idContacts AS idContacts_145, s10_.idUsersCreator AS idUsersCreator_146, s10_.idUsersChanger AS idUsersChanger_147, c11_.idTitles AS idTitles_148, c11_.avatar AS avatar_149, c11_.idUsersCreator AS idUsersCreator_150, c11_.idUsersChanger AS idUsersChanger_151, s12_.idContacts AS idContacts_152, s12_.idUsersCreator AS idUsersCreator_153, s12_.idUsersChanger AS idUsersChanger_154, c13_.idTitles AS idTitles_155, c13_.avatar AS avatar_156, c13_.idUsersCreator AS idUsersCreator_157, c13_.idUsersChanger AS idUsersChanger_158 FROM me_media m0_ LEFT JOIN me_media_types m1_ ON m0_.idMediaTypes = m1_.id LEFT JOIN me_collections m2_ ON m0_.idCollections = m2_.id INNER JOIN me_files m3_ ON m0_.id = m3_.idMedia INNER JOIN me_file_versions m4_ ON m3_.id = m4_.idFiles AND (m4_.version = m3_.version) LEFT JOIN me_file_version_tags m14_ ON m4_.id = m14_.idFileVersions LEFT JOIN ta_tags t5_ ON t5_.id = m14_.idTags LEFT JOIN me_file_version_meta m6_ ON m4_.id = m6_.idFileVersions LEFT JOIN me_file_version_meta m7_ ON m4_.idFileVersionsMetaDefault = m7_.id LEFT JOIN me_file_version_content_languages m8_ ON m4_.id = m8_.idFileVersions LEFT JOIN me_file_version_publish_languages m9_ ON m4_.id = m9_.idFileVersions LEFT JOIN se_users s10_ ON m0_.idUsersCreator = s10_.id LEFT JOIN co_contacts c11_ ON s10_.idContacts = c11_.id LEFT JOIN se_users s12_ ON m0_.idUsersChanger = s12_.id LEFT JOIN co_contacts c13_ ON s12_.idContacts = c13_.id WHERE m0_.id IN (81) ORDER BY m0_.id ASC;
|