1.49 ms
(42.43%)
|
1 |
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_.id AS id_28, m4_.created AS created_29, m4_.changed AS changed_30, t5_.name AS name_31, t5_.id AS id_32, t5_.created AS created_33, t5_.changed AS changed_34, m6_.title AS title_35, m6_.description AS description_36, m6_.copyright AS copyright_37, m6_.credits AS credits_38, m6_.locale AS locale_39, m6_.id AS id_40, m7_.title AS title_41, m7_.description AS description_42, m7_.copyright AS copyright_43, m7_.credits AS credits_44, m7_.locale AS locale_45, m7_.id AS id_46, m8_.locale AS locale_47, m8_.id AS id_48, m9_.locale AS locale_49, m9_.id AS id_50, s10_.username AS username_51, s10_.password AS password_52, s10_.locale AS locale_53, s10_.salt AS salt_54, s10_.locked AS locked_55, s10_.enabled AS enabled_56, s10_.lastLogin AS lastLogin_57, s10_.confirmationKey AS confirmationKey_58, s10_.passwordResetToken AS passwordResetToken_59, s10_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_60, s10_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_61, s10_.privateKey AS privateKey_62, s10_.apiKey AS apiKey_63, s10_.email AS email_64, s10_.id AS id_65, s10_.created AS created_66, s10_.changed AS changed_67, c11_.firstName AS firstName_68, c11_.middleName AS middleName_69, c11_.lastName AS lastName_70, c11_.birthday AS birthday_71, c11_.salutation AS salutation_72, c11_.formOfAddress AS formOfAddress_73, c11_.newsletter AS newsletter_74, c11_.gender AS gender_75, c11_.note AS note_76, c11_.mainEmail AS mainEmail_77, c11_.mainPhone AS mainPhone_78, c11_.mainFax AS mainFax_79, c11_.mainUrl AS mainUrl_80, c11_.id AS id_81, c11_.created AS created_82, c11_.changed AS changed_83, s12_.username AS username_84, s12_.password AS password_85, s12_.locale AS locale_86, s12_.salt AS salt_87, s12_.locked AS locked_88, s12_.enabled AS enabled_89, s12_.lastLogin AS lastLogin_90, s12_.confirmationKey AS confirmationKey_91, s12_.passwordResetToken AS passwordResetToken_92, s12_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_93, s12_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_94, s12_.privateKey AS privateKey_95, s12_.apiKey AS apiKey_96, s12_.email AS email_97, s12_.id AS id_98, s12_.created AS created_99, s12_.changed AS changed_100, c13_.firstName AS firstName_101, c13_.middleName AS middleName_102, c13_.lastName AS lastName_103, c13_.birthday AS birthday_104, c13_.salutation AS salutation_105, c13_.formOfAddress AS formOfAddress_106, c13_.newsletter AS newsletter_107, c13_.gender AS gender_108, c13_.note AS note_109, c13_.mainEmail AS mainEmail_110, c13_.mainPhone AS mainPhone_111, c13_.mainFax AS mainFax_112, c13_.mainUrl AS mainUrl_113, c13_.id AS id_114, c13_.created AS created_115, c13_.changed AS changed_116, m0_.idMediaTypes AS idMediaTypes_117, m0_.idPreviewImage AS idPreviewImage_118, m0_.idCollections AS idCollections_119, m0_.idUsersCreator AS idUsersCreator_120, m0_.idUsersChanger AS idUsersChanger_121, m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_122, m2_.idCollectionTypes AS idCollectionTypes_123, m2_.idCollectionsParent AS idCollectionsParent_124, m2_.idUsersCreator AS idUsersCreator_125, m2_.idUsersChanger AS idUsersChanger_126, m3_.idMedia AS idMedia_127, m3_.idUsersCreator AS idUsersCreator_128, m3_.idUsersChanger AS idUsersChanger_129, m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_130, m4_.idFiles AS idFiles_131, m4_.idUsersCreator AS idUsersCreator_132, m4_.idUsersChanger AS idUsersChanger_133, t5_.idUsersCreator AS idUsersCreator_134, t5_.idUsersChanger AS idUsersChanger_135, m6_.idFileVersions AS idFileVersions_136, m7_.idFileVersions AS idFileVersions_137, m8_.idFileVersions AS idFileVersions_138, m9_.idFileVersions AS idFileVersions_139, s10_.idContacts AS idContacts_140, s10_.idUsersCreator AS idUsersCreator_141, s10_.idUsersChanger AS idUsersChanger_142, c11_.idTitles AS idTitles_143, c11_.avatar AS avatar_144, c11_.idUsersCreator AS idUsersCreator_145, c11_.idUsersChanger AS idUsersChanger_146, s12_.idContacts AS idContacts_147, s12_.idUsersCreator AS idUsersCreator_148, s12_.idUsersChanger AS idUsersChanger_149, c13_.idTitles AS idTitles_150, c13_.avatar AS avatar_151, c13_.idUsersCreator AS idUsersCreator_152, c13_.idUsersChanger AS idUsersChanger_153 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_.id AS id_28,
m4_.created AS created_29,
m4_.changed AS changed_30,
t5_.name AS name_31,
t5_.id AS id_32,
t5_.created AS created_33,
t5_.changed AS changed_34,
m6_.title AS title_35,
m6_.description AS description_36,
m6_.copyright AS copyright_37,
m6_.credits AS credits_38,
m6_.locale AS locale_39,
m6_.id AS id_40,
m7_.title AS title_41,
m7_.description AS description_42,
m7_.copyright AS copyright_43,
m7_.credits AS credits_44,
m7_.locale AS locale_45,
m7_.id AS id_46,
m8_.locale AS locale_47,
m8_.id AS id_48,
m9_.locale AS locale_49,
m9_.id AS id_50,
s10_.username AS username_51,
s10_.password AS password_52,
s10_.locale AS locale_53,
s10_.salt AS salt_54,
s10_.locked AS locked_55,
s10_.enabled AS enabled_56,
s10_.lastLogin AS lastLogin_57,
s10_.confirmationKey AS confirmationKey_58,
s10_.passwordResetToken AS passwordResetToken_59,
s10_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_60,
s10_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_61,
s10_.privateKey AS privateKey_62,
s10_.apiKey AS apiKey_63,
s10_.email AS email_64,
s10_.id AS id_65,
s10_.created AS created_66,
s10_.changed AS changed_67,
c11_.firstName AS firstName_68,
c11_.middleName AS middleName_69,
c11_.lastName AS lastName_70,
c11_.birthday AS birthday_71,
c11_.salutation AS salutation_72,
c11_.formOfAddress AS formOfAddress_73,
c11_.newsletter AS newsletter_74,
c11_.gender AS gender_75,
c11_.note AS note_76,
c11_.mainEmail AS mainEmail_77,
c11_.mainPhone AS mainPhone_78,
c11_.mainFax AS mainFax_79,
c11_.mainUrl AS mainUrl_80,
c11_.id AS id_81,
c11_.created AS created_82,
c11_.changed AS changed_83,
s12_.username AS username_84,
s12_.password AS password_85,
s12_.locale AS locale_86,
s12_.salt AS salt_87,
s12_.locked AS locked_88,
s12_.enabled AS enabled_89,
s12_.lastLogin AS lastLogin_90,
s12_.confirmationKey AS confirmationKey_91,
s12_.passwordResetToken AS passwordResetToken_92,
s12_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_93,
s12_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_94,
s12_.privateKey AS privateKey_95,
s12_.apiKey AS apiKey_96,
s12_.email AS email_97,
s12_.id AS id_98,
s12_.created AS created_99,
s12_.changed AS changed_100,
c13_.firstName AS firstName_101,
c13_.middleName AS middleName_102,
c13_.lastName AS lastName_103,
c13_.birthday AS birthday_104,
c13_.salutation AS salutation_105,
c13_.formOfAddress AS formOfAddress_106,
c13_.newsletter AS newsletter_107,
c13_.gender AS gender_108,
c13_.note AS note_109,
c13_.mainEmail AS mainEmail_110,
c13_.mainPhone AS mainPhone_111,
c13_.mainFax AS mainFax_112,
c13_.mainUrl AS mainUrl_113,
c13_.id AS id_114,
c13_.created AS created_115,
c13_.changed AS changed_116,
m0_.idMediaTypes AS idMediaTypes_117,
m0_.idPreviewImage AS idPreviewImage_118,
m0_.idCollections AS idCollections_119,
m0_.idUsersCreator AS idUsersCreator_120,
m0_.idUsersChanger AS idUsersChanger_121,
m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_122,
m2_.idCollectionTypes AS idCollectionTypes_123,
m2_.idCollectionsParent AS idCollectionsParent_124,
m2_.idUsersCreator AS idUsersCreator_125,
m2_.idUsersChanger AS idUsersChanger_126,
m3_.idMedia AS idMedia_127,
m3_.idUsersCreator AS idUsersCreator_128,
m3_.idUsersChanger AS idUsersChanger_129,
m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_130,
m4_.idFiles AS idFiles_131,
m4_.idUsersCreator AS idUsersCreator_132,
m4_.idUsersChanger AS idUsersChanger_133,
t5_.idUsersCreator AS idUsersCreator_134,
t5_.idUsersChanger AS idUsersChanger_135,
m6_.idFileVersions AS idFileVersions_136,
m7_.idFileVersions AS idFileVersions_137,
m8_.idFileVersions AS idFileVersions_138,
m9_.idFileVersions AS idFileVersions_139,
s10_.idContacts AS idContacts_140,
s10_.idUsersCreator AS idUsersCreator_141,
s10_.idUsersChanger AS idUsersChanger_142,
c11_.idTitles AS idTitles_143,
c11_.avatar AS avatar_144,
c11_.idUsersCreator AS idUsersCreator_145,
c11_.idUsersChanger AS idUsersChanger_146,
s12_.idContacts AS idContacts_147,
s12_.idUsersCreator AS idUsersCreator_148,
s12_.idUsersChanger AS idUsersChanger_149,
c13_.idTitles AS idTitles_150,
c13_.avatar AS avatar_151,
c13_.idUsersCreator AS idUsersCreator_152,
c13_.idUsersChanger AS idUsersChanger_153
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_.id AS id_28, m4_.created AS created_29, m4_.changed AS changed_30, t5_.name AS name_31, t5_.id AS id_32, t5_.created AS created_33, t5_.changed AS changed_34, m6_.title AS title_35, m6_.description AS description_36, m6_.copyright AS copyright_37, m6_.credits AS credits_38, m6_.locale AS locale_39, m6_.id AS id_40, m7_.title AS title_41, m7_.description AS description_42, m7_.copyright AS copyright_43, m7_.credits AS credits_44, m7_.locale AS locale_45, m7_.id AS id_46, m8_.locale AS locale_47, m8_.id AS id_48, m9_.locale AS locale_49, m9_.id AS id_50, s10_.username AS username_51, s10_.password AS password_52, s10_.locale AS locale_53, s10_.salt AS salt_54, s10_.locked AS locked_55, s10_.enabled AS enabled_56, s10_.lastLogin AS lastLogin_57, s10_.confirmationKey AS confirmationKey_58, s10_.passwordResetToken AS passwordResetToken_59, s10_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_60, s10_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_61, s10_.privateKey AS privateKey_62, s10_.apiKey AS apiKey_63, s10_.email AS email_64, s10_.id AS id_65, s10_.created AS created_66, s10_.changed AS changed_67, c11_.firstName AS firstName_68, c11_.middleName AS middleName_69, c11_.lastName AS lastName_70, c11_.birthday AS birthday_71, c11_.salutation AS salutation_72, c11_.formOfAddress AS formOfAddress_73, c11_.newsletter AS newsletter_74, c11_.gender AS gender_75, c11_.note AS note_76, c11_.mainEmail AS mainEmail_77, c11_.mainPhone AS mainPhone_78, c11_.mainFax AS mainFax_79, c11_.mainUrl AS mainUrl_80, c11_.id AS id_81, c11_.created AS created_82, c11_.changed AS changed_83, s12_.username AS username_84, s12_.password AS password_85, s12_.locale AS locale_86, s12_.salt AS salt_87, s12_.locked AS locked_88, s12_.enabled AS enabled_89, s12_.lastLogin AS lastLogin_90, s12_.confirmationKey AS confirmationKey_91, s12_.passwordResetToken AS passwordResetToken_92, s12_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_93, s12_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_94, s12_.privateKey AS privateKey_95, s12_.apiKey AS apiKey_96, s12_.email AS email_97, s12_.id AS id_98, s12_.created AS created_99, s12_.changed AS changed_100, c13_.firstName AS firstName_101, c13_.middleName AS middleName_102, c13_.lastName AS lastName_103, c13_.birthday AS birthday_104, c13_.salutation AS salutation_105, c13_.formOfAddress AS formOfAddress_106, c13_.newsletter AS newsletter_107, c13_.gender AS gender_108, c13_.note AS note_109, c13_.mainEmail AS mainEmail_110, c13_.mainPhone AS mainPhone_111, c13_.mainFax AS mainFax_112, c13_.mainUrl AS mainUrl_113, c13_.id AS id_114, c13_.created AS created_115, c13_.changed AS changed_116, m0_.idMediaTypes AS idMediaTypes_117, m0_.idPreviewImage AS idPreviewImage_118, m0_.idCollections AS idCollections_119, m0_.idUsersCreator AS idUsersCreator_120, m0_.idUsersChanger AS idUsersChanger_121, m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_122, m2_.idCollectionTypes AS idCollectionTypes_123, m2_.idCollectionsParent AS idCollectionsParent_124, m2_.idUsersCreator AS idUsersCreator_125, m2_.idUsersChanger AS idUsersChanger_126, m3_.idMedia AS idMedia_127, m3_.idUsersCreator AS idUsersCreator_128, m3_.idUsersChanger AS idUsersChanger_129, m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_130, m4_.idFiles AS idFiles_131, m4_.idUsersCreator AS idUsersCreator_132, m4_.idUsersChanger AS idUsersChanger_133, t5_.idUsersCreator AS idUsersCreator_134, t5_.idUsersChanger AS idUsersChanger_135, m6_.idFileVersions AS idFileVersions_136, m7_.idFileVersions AS idFileVersions_137, m8_.idFileVersions AS idFileVersions_138, m9_.idFileVersions AS idFileVersions_139, s10_.idContacts AS idContacts_140, s10_.idUsersCreator AS idUsersCreator_141, s10_.idUsersChanger AS idUsersChanger_142, c11_.idTitles AS idTitles_143, c11_.avatar AS avatar_144, c11_.idUsersCreator AS idUsersCreator_145, c11_.idUsersChanger AS idUsersChanger_146, s12_.idContacts AS idContacts_147, s12_.idUsersCreator AS idUsersCreator_148, s12_.idUsersChanger AS idUsersChanger_149, c13_.idTitles AS idTitles_150, c13_.avatar AS avatar_151, c13_.idUsersCreator AS idUsersCreator_152, c13_.idUsersChanger AS idUsersChanger_153 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 (108, 103) ORDER BY m0_.id ASC;
|
0.94 ms
(26.74%)
|
1 |
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_.id AS id_28, m4_.created AS created_29, m4_.changed AS changed_30, t5_.name AS name_31, t5_.id AS id_32, t5_.created AS created_33, t5_.changed AS changed_34, m6_.title AS title_35, m6_.description AS description_36, m6_.copyright AS copyright_37, m6_.credits AS credits_38, m6_.locale AS locale_39, m6_.id AS id_40, m7_.title AS title_41, m7_.description AS description_42, m7_.copyright AS copyright_43, m7_.credits AS credits_44, m7_.locale AS locale_45, m7_.id AS id_46, m8_.locale AS locale_47, m8_.id AS id_48, m9_.locale AS locale_49, m9_.id AS id_50, s10_.username AS username_51, s10_.password AS password_52, s10_.locale AS locale_53, s10_.salt AS salt_54, s10_.locked AS locked_55, s10_.enabled AS enabled_56, s10_.lastLogin AS lastLogin_57, s10_.confirmationKey AS confirmationKey_58, s10_.passwordResetToken AS passwordResetToken_59, s10_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_60, s10_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_61, s10_.privateKey AS privateKey_62, s10_.apiKey AS apiKey_63, s10_.email AS email_64, s10_.id AS id_65, s10_.created AS created_66, s10_.changed AS changed_67, c11_.firstName AS firstName_68, c11_.middleName AS middleName_69, c11_.lastName AS lastName_70, c11_.birthday AS birthday_71, c11_.salutation AS salutation_72, c11_.formOfAddress AS formOfAddress_73, c11_.newsletter AS newsletter_74, c11_.gender AS gender_75, c11_.note AS note_76, c11_.mainEmail AS mainEmail_77, c11_.mainPhone AS mainPhone_78, c11_.mainFax AS mainFax_79, c11_.mainUrl AS mainUrl_80, c11_.id AS id_81, c11_.created AS created_82, c11_.changed AS changed_83, s12_.username AS username_84, s12_.password AS password_85, s12_.locale AS locale_86, s12_.salt AS salt_87, s12_.locked AS locked_88, s12_.enabled AS enabled_89, s12_.lastLogin AS lastLogin_90, s12_.confirmationKey AS confirmationKey_91, s12_.passwordResetToken AS passwordResetToken_92, s12_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_93, s12_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_94, s12_.privateKey AS privateKey_95, s12_.apiKey AS apiKey_96, s12_.email AS email_97, s12_.id AS id_98, s12_.created AS created_99, s12_.changed AS changed_100, c13_.firstName AS firstName_101, c13_.middleName AS middleName_102, c13_.lastName AS lastName_103, c13_.birthday AS birthday_104, c13_.salutation AS salutation_105, c13_.formOfAddress AS formOfAddress_106, c13_.newsletter AS newsletter_107, c13_.gender AS gender_108, c13_.note AS note_109, c13_.mainEmail AS mainEmail_110, c13_.mainPhone AS mainPhone_111, c13_.mainFax AS mainFax_112, c13_.mainUrl AS mainUrl_113, c13_.id AS id_114, c13_.created AS created_115, c13_.changed AS changed_116, m0_.idMediaTypes AS idMediaTypes_117, m0_.idPreviewImage AS idPreviewImage_118, m0_.idCollections AS idCollections_119, m0_.idUsersCreator AS idUsersCreator_120, m0_.idUsersChanger AS idUsersChanger_121, m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_122, m2_.idCollectionTypes AS idCollectionTypes_123, m2_.idCollectionsParent AS idCollectionsParent_124, m2_.idUsersCreator AS idUsersCreator_125, m2_.idUsersChanger AS idUsersChanger_126, m3_.idMedia AS idMedia_127, m3_.idUsersCreator AS idUsersCreator_128, m3_.idUsersChanger AS idUsersChanger_129, m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_130, m4_.idFiles AS idFiles_131, m4_.idUsersCreator AS idUsersCreator_132, m4_.idUsersChanger AS idUsersChanger_133, t5_.idUsersCreator AS idUsersCreator_134, t5_.idUsersChanger AS idUsersChanger_135, m6_.idFileVersions AS idFileVersions_136, m7_.idFileVersions AS idFileVersions_137, m8_.idFileVersions AS idFileVersions_138, m9_.idFileVersions AS idFileVersions_139, s10_.idContacts AS idContacts_140, s10_.idUsersCreator AS idUsersCreator_141, s10_.idUsersChanger AS idUsersChanger_142, c11_.idTitles AS idTitles_143, c11_.avatar AS avatar_144, c11_.idUsersCreator AS idUsersCreator_145, c11_.idUsersChanger AS idUsersChanger_146, s12_.idContacts AS idContacts_147, s12_.idUsersCreator AS idUsersCreator_148, s12_.idUsersChanger AS idUsersChanger_149, c13_.idTitles AS idTitles_150, c13_.avatar AS avatar_151, c13_.idUsersCreator AS idUsersCreator_152, c13_.idUsersChanger AS idUsersChanger_153 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_.id AS id_28,
m4_.created AS created_29,
m4_.changed AS changed_30,
t5_.name AS name_31,
t5_.id AS id_32,
t5_.created AS created_33,
t5_.changed AS changed_34,
m6_.title AS title_35,
m6_.description AS description_36,
m6_.copyright AS copyright_37,
m6_.credits AS credits_38,
m6_.locale AS locale_39,
m6_.id AS id_40,
m7_.title AS title_41,
m7_.description AS description_42,
m7_.copyright AS copyright_43,
m7_.credits AS credits_44,
m7_.locale AS locale_45,
m7_.id AS id_46,
m8_.locale AS locale_47,
m8_.id AS id_48,
m9_.locale AS locale_49,
m9_.id AS id_50,
s10_.username AS username_51,
s10_.password AS password_52,
s10_.locale AS locale_53,
s10_.salt AS salt_54,
s10_.locked AS locked_55,
s10_.enabled AS enabled_56,
s10_.lastLogin AS lastLogin_57,
s10_.confirmationKey AS confirmationKey_58,
s10_.passwordResetToken AS passwordResetToken_59,
s10_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_60,
s10_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_61,
s10_.privateKey AS privateKey_62,
s10_.apiKey AS apiKey_63,
s10_.email AS email_64,
s10_.id AS id_65,
s10_.created AS created_66,
s10_.changed AS changed_67,
c11_.firstName AS firstName_68,
c11_.middleName AS middleName_69,
c11_.lastName AS lastName_70,
c11_.birthday AS birthday_71,
c11_.salutation AS salutation_72,
c11_.formOfAddress AS formOfAddress_73,
c11_.newsletter AS newsletter_74,
c11_.gender AS gender_75,
c11_.note AS note_76,
c11_.mainEmail AS mainEmail_77,
c11_.mainPhone AS mainPhone_78,
c11_.mainFax AS mainFax_79,
c11_.mainUrl AS mainUrl_80,
c11_.id AS id_81,
c11_.created AS created_82,
c11_.changed AS changed_83,
s12_.username AS username_84,
s12_.password AS password_85,
s12_.locale AS locale_86,
s12_.salt AS salt_87,
s12_.locked AS locked_88,
s12_.enabled AS enabled_89,
s12_.lastLogin AS lastLogin_90,
s12_.confirmationKey AS confirmationKey_91,
s12_.passwordResetToken AS passwordResetToken_92,
s12_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_93,
s12_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_94,
s12_.privateKey AS privateKey_95,
s12_.apiKey AS apiKey_96,
s12_.email AS email_97,
s12_.id AS id_98,
s12_.created AS created_99,
s12_.changed AS changed_100,
c13_.firstName AS firstName_101,
c13_.middleName AS middleName_102,
c13_.lastName AS lastName_103,
c13_.birthday AS birthday_104,
c13_.salutation AS salutation_105,
c13_.formOfAddress AS formOfAddress_106,
c13_.newsletter AS newsletter_107,
c13_.gender AS gender_108,
c13_.note AS note_109,
c13_.mainEmail AS mainEmail_110,
c13_.mainPhone AS mainPhone_111,
c13_.mainFax AS mainFax_112,
c13_.mainUrl AS mainUrl_113,
c13_.id AS id_114,
c13_.created AS created_115,
c13_.changed AS changed_116,
m0_.idMediaTypes AS idMediaTypes_117,
m0_.idPreviewImage AS idPreviewImage_118,
m0_.idCollections AS idCollections_119,
m0_.idUsersCreator AS idUsersCreator_120,
m0_.idUsersChanger AS idUsersChanger_121,
m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_122,
m2_.idCollectionTypes AS idCollectionTypes_123,
m2_.idCollectionsParent AS idCollectionsParent_124,
m2_.idUsersCreator AS idUsersCreator_125,
m2_.idUsersChanger AS idUsersChanger_126,
m3_.idMedia AS idMedia_127,
m3_.idUsersCreator AS idUsersCreator_128,
m3_.idUsersChanger AS idUsersChanger_129,
m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_130,
m4_.idFiles AS idFiles_131,
m4_.idUsersCreator AS idUsersCreator_132,
m4_.idUsersChanger AS idUsersChanger_133,
t5_.idUsersCreator AS idUsersCreator_134,
t5_.idUsersChanger AS idUsersChanger_135,
m6_.idFileVersions AS idFileVersions_136,
m7_.idFileVersions AS idFileVersions_137,
m8_.idFileVersions AS idFileVersions_138,
m9_.idFileVersions AS idFileVersions_139,
s10_.idContacts AS idContacts_140,
s10_.idUsersCreator AS idUsersCreator_141,
s10_.idUsersChanger AS idUsersChanger_142,
c11_.idTitles AS idTitles_143,
c11_.avatar AS avatar_144,
c11_.idUsersCreator AS idUsersCreator_145,
c11_.idUsersChanger AS idUsersChanger_146,
s12_.idContacts AS idContacts_147,
s12_.idUsersCreator AS idUsersCreator_148,
s12_.idUsersChanger AS idUsersChanger_149,
c13_.idTitles AS idTitles_150,
c13_.avatar AS avatar_151,
c13_.idUsersCreator AS idUsersCreator_152,
c13_.idUsersChanger AS idUsersChanger_153
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_.id AS id_28, m4_.created AS created_29, m4_.changed AS changed_30, t5_.name AS name_31, t5_.id AS id_32, t5_.created AS created_33, t5_.changed AS changed_34, m6_.title AS title_35, m6_.description AS description_36, m6_.copyright AS copyright_37, m6_.credits AS credits_38, m6_.locale AS locale_39, m6_.id AS id_40, m7_.title AS title_41, m7_.description AS description_42, m7_.copyright AS copyright_43, m7_.credits AS credits_44, m7_.locale AS locale_45, m7_.id AS id_46, m8_.locale AS locale_47, m8_.id AS id_48, m9_.locale AS locale_49, m9_.id AS id_50, s10_.username AS username_51, s10_.password AS password_52, s10_.locale AS locale_53, s10_.salt AS salt_54, s10_.locked AS locked_55, s10_.enabled AS enabled_56, s10_.lastLogin AS lastLogin_57, s10_.confirmationKey AS confirmationKey_58, s10_.passwordResetToken AS passwordResetToken_59, s10_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_60, s10_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_61, s10_.privateKey AS privateKey_62, s10_.apiKey AS apiKey_63, s10_.email AS email_64, s10_.id AS id_65, s10_.created AS created_66, s10_.changed AS changed_67, c11_.firstName AS firstName_68, c11_.middleName AS middleName_69, c11_.lastName AS lastName_70, c11_.birthday AS birthday_71, c11_.salutation AS salutation_72, c11_.formOfAddress AS formOfAddress_73, c11_.newsletter AS newsletter_74, c11_.gender AS gender_75, c11_.note AS note_76, c11_.mainEmail AS mainEmail_77, c11_.mainPhone AS mainPhone_78, c11_.mainFax AS mainFax_79, c11_.mainUrl AS mainUrl_80, c11_.id AS id_81, c11_.created AS created_82, c11_.changed AS changed_83, s12_.username AS username_84, s12_.password AS password_85, s12_.locale AS locale_86, s12_.salt AS salt_87, s12_.locked AS locked_88, s12_.enabled AS enabled_89, s12_.lastLogin AS lastLogin_90, s12_.confirmationKey AS confirmationKey_91, s12_.passwordResetToken AS passwordResetToken_92, s12_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_93, s12_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_94, s12_.privateKey AS privateKey_95, s12_.apiKey AS apiKey_96, s12_.email AS email_97, s12_.id AS id_98, s12_.created AS created_99, s12_.changed AS changed_100, c13_.firstName AS firstName_101, c13_.middleName AS middleName_102, c13_.lastName AS lastName_103, c13_.birthday AS birthday_104, c13_.salutation AS salutation_105, c13_.formOfAddress AS formOfAddress_106, c13_.newsletter AS newsletter_107, c13_.gender AS gender_108, c13_.note AS note_109, c13_.mainEmail AS mainEmail_110, c13_.mainPhone AS mainPhone_111, c13_.mainFax AS mainFax_112, c13_.mainUrl AS mainUrl_113, c13_.id AS id_114, c13_.created AS created_115, c13_.changed AS changed_116, m0_.idMediaTypes AS idMediaTypes_117, m0_.idPreviewImage AS idPreviewImage_118, m0_.idCollections AS idCollections_119, m0_.idUsersCreator AS idUsersCreator_120, m0_.idUsersChanger AS idUsersChanger_121, m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_122, m2_.idCollectionTypes AS idCollectionTypes_123, m2_.idCollectionsParent AS idCollectionsParent_124, m2_.idUsersCreator AS idUsersCreator_125, m2_.idUsersChanger AS idUsersChanger_126, m3_.idMedia AS idMedia_127, m3_.idUsersCreator AS idUsersCreator_128, m3_.idUsersChanger AS idUsersChanger_129, m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_130, m4_.idFiles AS idFiles_131, m4_.idUsersCreator AS idUsersCreator_132, m4_.idUsersChanger AS idUsersChanger_133, t5_.idUsersCreator AS idUsersCreator_134, t5_.idUsersChanger AS idUsersChanger_135, m6_.idFileVersions AS idFileVersions_136, m7_.idFileVersions AS idFileVersions_137, m8_.idFileVersions AS idFileVersions_138, m9_.idFileVersions AS idFileVersions_139, s10_.idContacts AS idContacts_140, s10_.idUsersCreator AS idUsersCreator_141, s10_.idUsersChanger AS idUsersChanger_142, c11_.idTitles AS idTitles_143, c11_.avatar AS avatar_144, c11_.idUsersCreator AS idUsersCreator_145, c11_.idUsersChanger AS idUsersChanger_146, s12_.idContacts AS idContacts_147, s12_.idUsersCreator AS idUsersCreator_148, s12_.idUsersChanger AS idUsersChanger_149, c13_.idTitles AS idTitles_150, c13_.avatar AS avatar_151, c13_.idUsersCreator AS idUsersCreator_152, c13_.idUsersChanger AS idUsersChanger_153 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 (103) ORDER BY m0_.id ASC;
|
0.33 ms
(9.30%)
|
1 |
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_.id AS id_28, m4_.created AS created_29, m4_.changed AS changed_30, t5_.name AS name_31, t5_.id AS id_32, t5_.created AS created_33, t5_.changed AS changed_34, m6_.title AS title_35, m6_.description AS description_36, m6_.copyright AS copyright_37, m6_.credits AS credits_38, m6_.locale AS locale_39, m6_.id AS id_40, m7_.title AS title_41, m7_.description AS description_42, m7_.copyright AS copyright_43, m7_.credits AS credits_44, m7_.locale AS locale_45, m7_.id AS id_46, m8_.locale AS locale_47, m8_.id AS id_48, m9_.locale AS locale_49, m9_.id AS id_50, s10_.username AS username_51, s10_.password AS password_52, s10_.locale AS locale_53, s10_.salt AS salt_54, s10_.locked AS locked_55, s10_.enabled AS enabled_56, s10_.lastLogin AS lastLogin_57, s10_.confirmationKey AS confirmationKey_58, s10_.passwordResetToken AS passwordResetToken_59, s10_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_60, s10_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_61, s10_.privateKey AS privateKey_62, s10_.apiKey AS apiKey_63, s10_.email AS email_64, s10_.id AS id_65, s10_.created AS created_66, s10_.changed AS changed_67, c11_.firstName AS firstName_68, c11_.middleName AS middleName_69, c11_.lastName AS lastName_70, c11_.birthday AS birthday_71, c11_.salutation AS salutation_72, c11_.formOfAddress AS formOfAddress_73, c11_.newsletter AS newsletter_74, c11_.gender AS gender_75, c11_.note AS note_76, c11_.mainEmail AS mainEmail_77, c11_.mainPhone AS mainPhone_78, c11_.mainFax AS mainFax_79, c11_.mainUrl AS mainUrl_80, c11_.id AS id_81, c11_.created AS created_82, c11_.changed AS changed_83, s12_.username AS username_84, s12_.password AS password_85, s12_.locale AS locale_86, s12_.salt AS salt_87, s12_.locked AS locked_88, s12_.enabled AS enabled_89, s12_.lastLogin AS lastLogin_90, s12_.confirmationKey AS confirmationKey_91, s12_.passwordResetToken AS passwordResetToken_92, s12_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_93, s12_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_94, s12_.privateKey AS privateKey_95, s12_.apiKey AS apiKey_96, s12_.email AS email_97, s12_.id AS id_98, s12_.created AS created_99, s12_.changed AS changed_100, c13_.firstName AS firstName_101, c13_.middleName AS middleName_102, c13_.lastName AS lastName_103, c13_.birthday AS birthday_104, c13_.salutation AS salutation_105, c13_.formOfAddress AS formOfAddress_106, c13_.newsletter AS newsletter_107, c13_.gender AS gender_108, c13_.note AS note_109, c13_.mainEmail AS mainEmail_110, c13_.mainPhone AS mainPhone_111, c13_.mainFax AS mainFax_112, c13_.mainUrl AS mainUrl_113, c13_.id AS id_114, c13_.created AS created_115, c13_.changed AS changed_116, m0_.idMediaTypes AS idMediaTypes_117, m0_.idPreviewImage AS idPreviewImage_118, m0_.idCollections AS idCollections_119, m0_.idUsersCreator AS idUsersCreator_120, m0_.idUsersChanger AS idUsersChanger_121, m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_122, m2_.idCollectionTypes AS idCollectionTypes_123, m2_.idCollectionsParent AS idCollectionsParent_124, m2_.idUsersCreator AS idUsersCreator_125, m2_.idUsersChanger AS idUsersChanger_126, m3_.idMedia AS idMedia_127, m3_.idUsersCreator AS idUsersCreator_128, m3_.idUsersChanger AS idUsersChanger_129, m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_130, m4_.idFiles AS idFiles_131, m4_.idUsersCreator AS idUsersCreator_132, m4_.idUsersChanger AS idUsersChanger_133, t5_.idUsersCreator AS idUsersCreator_134, t5_.idUsersChanger AS idUsersChanger_135, m6_.idFileVersions AS idFileVersions_136, m7_.idFileVersions AS idFileVersions_137, m8_.idFileVersions AS idFileVersions_138, m9_.idFileVersions AS idFileVersions_139, s10_.idContacts AS idContacts_140, s10_.idUsersCreator AS idUsersCreator_141, s10_.idUsersChanger AS idUsersChanger_142, c11_.idTitles AS idTitles_143, c11_.avatar AS avatar_144, c11_.idUsersCreator AS idUsersCreator_145, c11_.idUsersChanger AS idUsersChanger_146, s12_.idContacts AS idContacts_147, s12_.idUsersCreator AS idUsersCreator_148, s12_.idUsersChanger AS idUsersChanger_149, c13_.idTitles AS idTitles_150, c13_.avatar AS avatar_151, c13_.idUsersCreator AS idUsersCreator_152, c13_.idUsersChanger AS idUsersChanger_153 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
Parameters: [
89
96
94
93
95
86
85
81
83
88
87
91
90
84
116
]
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_.id AS id_28,
m4_.created AS created_29,
m4_.changed AS changed_30,
t5_.name AS name_31,
t5_.id AS id_32,
t5_.created AS created_33,
t5_.changed AS changed_34,
m6_.title AS title_35,
m6_.description AS description_36,
m6_.copyright AS copyright_37,
m6_.credits AS credits_38,
m6_.locale AS locale_39,
m6_.id AS id_40,
m7_.title AS title_41,
m7_.description AS description_42,
m7_.copyright AS copyright_43,
m7_.credits AS credits_44,
m7_.locale AS locale_45,
m7_.id AS id_46,
m8_.locale AS locale_47,
m8_.id AS id_48,
m9_.locale AS locale_49,
m9_.id AS id_50,
s10_.username AS username_51,
s10_.password AS password_52,
s10_.locale AS locale_53,
s10_.salt AS salt_54,
s10_.locked AS locked_55,
s10_.enabled AS enabled_56,
s10_.lastLogin AS lastLogin_57,
s10_.confirmationKey AS confirmationKey_58,
s10_.passwordResetToken AS passwordResetToken_59,
s10_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_60,
s10_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_61,
s10_.privateKey AS privateKey_62,
s10_.apiKey AS apiKey_63,
s10_.email AS email_64,
s10_.id AS id_65,
s10_.created AS created_66,
s10_.changed AS changed_67,
c11_.firstName AS firstName_68,
c11_.middleName AS middleName_69,
c11_.lastName AS lastName_70,
c11_.birthday AS birthday_71,
c11_.salutation AS salutation_72,
c11_.formOfAddress AS formOfAddress_73,
c11_.newsletter AS newsletter_74,
c11_.gender AS gender_75,
c11_.note AS note_76,
c11_.mainEmail AS mainEmail_77,
c11_.mainPhone AS mainPhone_78,
c11_.mainFax AS mainFax_79,
c11_.mainUrl AS mainUrl_80,
c11_.id AS id_81,
c11_.created AS created_82,
c11_.changed AS changed_83,
s12_.username AS username_84,
s12_.password AS password_85,
s12_.locale AS locale_86,
s12_.salt AS salt_87,
s12_.locked AS locked_88,
s12_.enabled AS enabled_89,
s12_.lastLogin AS lastLogin_90,
s12_.confirmationKey AS confirmationKey_91,
s12_.passwordResetToken AS passwordResetToken_92,
s12_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_93,
s12_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_94,
s12_.privateKey AS privateKey_95,
s12_.apiKey AS apiKey_96,
s12_.email AS email_97,
s12_.id AS id_98,
s12_.created AS created_99,
s12_.changed AS changed_100,
c13_.firstName AS firstName_101,
c13_.middleName AS middleName_102,
c13_.lastName AS lastName_103,
c13_.birthday AS birthday_104,
c13_.salutation AS salutation_105,
c13_.formOfAddress AS formOfAddress_106,
c13_.newsletter AS newsletter_107,
c13_.gender AS gender_108,
c13_.note AS note_109,
c13_.mainEmail AS mainEmail_110,
c13_.mainPhone AS mainPhone_111,
c13_.mainFax AS mainFax_112,
c13_.mainUrl AS mainUrl_113,
c13_.id AS id_114,
c13_.created AS created_115,
c13_.changed AS changed_116,
m0_.idMediaTypes AS idMediaTypes_117,
m0_.idPreviewImage AS idPreviewImage_118,
m0_.idCollections AS idCollections_119,
m0_.idUsersCreator AS idUsersCreator_120,
m0_.idUsersChanger AS idUsersChanger_121,
m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_122,
m2_.idCollectionTypes AS idCollectionTypes_123,
m2_.idCollectionsParent AS idCollectionsParent_124,
m2_.idUsersCreator AS idUsersCreator_125,
m2_.idUsersChanger AS idUsersChanger_126,
m3_.idMedia AS idMedia_127,
m3_.idUsersCreator AS idUsersCreator_128,
m3_.idUsersChanger AS idUsersChanger_129,
m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_130,
m4_.idFiles AS idFiles_131,
m4_.idUsersCreator AS idUsersCreator_132,
m4_.idUsersChanger AS idUsersChanger_133,
t5_.idUsersCreator AS idUsersCreator_134,
t5_.idUsersChanger AS idUsersChanger_135,
m6_.idFileVersions AS idFileVersions_136,
m7_.idFileVersions AS idFileVersions_137,
m8_.idFileVersions AS idFileVersions_138,
m9_.idFileVersions AS idFileVersions_139,
s10_.idContacts AS idContacts_140,
s10_.idUsersCreator AS idUsersCreator_141,
s10_.idUsersChanger AS idUsersChanger_142,
c11_.idTitles AS idTitles_143,
c11_.avatar AS avatar_144,
c11_.idUsersCreator AS idUsersCreator_145,
c11_.idUsersChanger AS idUsersChanger_146,
s12_.idContacts AS idContacts_147,
s12_.idUsersCreator AS idUsersCreator_148,
s12_.idUsersChanger AS idUsersChanger_149,
c13_.idTitles AS idTitles_150,
c13_.avatar AS avatar_151,
c13_.idUsersCreator AS idUsersCreator_152,
c13_.idUsersChanger AS idUsersChanger_153
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_.id AS id_28, m4_.created AS created_29, m4_.changed AS changed_30, t5_.name AS name_31, t5_.id AS id_32, t5_.created AS created_33, t5_.changed AS changed_34, m6_.title AS title_35, m6_.description AS description_36, m6_.copyright AS copyright_37, m6_.credits AS credits_38, m6_.locale AS locale_39, m6_.id AS id_40, m7_.title AS title_41, m7_.description AS description_42, m7_.copyright AS copyright_43, m7_.credits AS credits_44, m7_.locale AS locale_45, m7_.id AS id_46, m8_.locale AS locale_47, m8_.id AS id_48, m9_.locale AS locale_49, m9_.id AS id_50, s10_.username AS username_51, s10_.password AS password_52, s10_.locale AS locale_53, s10_.salt AS salt_54, s10_.locked AS locked_55, s10_.enabled AS enabled_56, s10_.lastLogin AS lastLogin_57, s10_.confirmationKey AS confirmationKey_58, s10_.passwordResetToken AS passwordResetToken_59, s10_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_60, s10_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_61, s10_.privateKey AS privateKey_62, s10_.apiKey AS apiKey_63, s10_.email AS email_64, s10_.id AS id_65, s10_.created AS created_66, s10_.changed AS changed_67, c11_.firstName AS firstName_68, c11_.middleName AS middleName_69, c11_.lastName AS lastName_70, c11_.birthday AS birthday_71, c11_.salutation AS salutation_72, c11_.formOfAddress AS formOfAddress_73, c11_.newsletter AS newsletter_74, c11_.gender AS gender_75, c11_.note AS note_76, c11_.mainEmail AS mainEmail_77, c11_.mainPhone AS mainPhone_78, c11_.mainFax AS mainFax_79, c11_.mainUrl AS mainUrl_80, c11_.id AS id_81, c11_.created AS created_82, c11_.changed AS changed_83, s12_.username AS username_84, s12_.password AS password_85, s12_.locale AS locale_86, s12_.salt AS salt_87, s12_.locked AS locked_88, s12_.enabled AS enabled_89, s12_.lastLogin AS lastLogin_90, s12_.confirmationKey AS confirmationKey_91, s12_.passwordResetToken AS passwordResetToken_92, s12_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_93, s12_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_94, s12_.privateKey AS privateKey_95, s12_.apiKey AS apiKey_96, s12_.email AS email_97, s12_.id AS id_98, s12_.created AS created_99, s12_.changed AS changed_100, c13_.firstName AS firstName_101, c13_.middleName AS middleName_102, c13_.lastName AS lastName_103, c13_.birthday AS birthday_104, c13_.salutation AS salutation_105, c13_.formOfAddress AS formOfAddress_106, c13_.newsletter AS newsletter_107, c13_.gender AS gender_108, c13_.note AS note_109, c13_.mainEmail AS mainEmail_110, c13_.mainPhone AS mainPhone_111, c13_.mainFax AS mainFax_112, c13_.mainUrl AS mainUrl_113, c13_.id AS id_114, c13_.created AS created_115, c13_.changed AS changed_116, m0_.idMediaTypes AS idMediaTypes_117, m0_.idPreviewImage AS idPreviewImage_118, m0_.idCollections AS idCollections_119, m0_.idUsersCreator AS idUsersCreator_120, m0_.idUsersChanger AS idUsersChanger_121, m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_122, m2_.idCollectionTypes AS idCollectionTypes_123, m2_.idCollectionsParent AS idCollectionsParent_124, m2_.idUsersCreator AS idUsersCreator_125, m2_.idUsersChanger AS idUsersChanger_126, m3_.idMedia AS idMedia_127, m3_.idUsersCreator AS idUsersCreator_128, m3_.idUsersChanger AS idUsersChanger_129, m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_130, m4_.idFiles AS idFiles_131, m4_.idUsersCreator AS idUsersCreator_132, m4_.idUsersChanger AS idUsersChanger_133, t5_.idUsersCreator AS idUsersCreator_134, t5_.idUsersChanger AS idUsersChanger_135, m6_.idFileVersions AS idFileVersions_136, m7_.idFileVersions AS idFileVersions_137, m8_.idFileVersions AS idFileVersions_138, m9_.idFileVersions AS idFileVersions_139, s10_.idContacts AS idContacts_140, s10_.idUsersCreator AS idUsersCreator_141, s10_.idUsersChanger AS idUsersChanger_142, c11_.idTitles AS idTitles_143, c11_.avatar AS avatar_144, c11_.idUsersCreator AS idUsersCreator_145, c11_.idUsersChanger AS idUsersChanger_146, s12_.idContacts AS idContacts_147, s12_.idUsersCreator AS idUsersCreator_148, s12_.idUsersChanger AS idUsersChanger_149, c13_.idTitles AS idTitles_150, c13_.avatar AS avatar_151, c13_.idUsersCreator AS idUsersCreator_152, c13_.idUsersChanger AS idUsersChanger_153 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 (89, 96, 94, 93, 95, 86, 85, 81, 83, 88, 87, 91, 90, 84, 116) ORDER BY m0_.id ASC;
|
0.20 ms
(5.82%)
|
1 |
SELECT t0.lft AS lft_1, t0.rgt AS rgt_2, t0.depth AS depth_3, t0.name AS name_4, t0.externalId AS externalId_5, t0.number AS number_6, t0.corporation AS corporation_7, t0.note AS note_8, t0.uid AS uid_9, t0.registerNumber AS registerNumber_10, t0.placeOfJurisdiction AS placeOfJurisdiction_11, t0.mainEmail AS mainEmail_12, t0.mainPhone AS mainPhone_13, t0.mainFax AS mainFax_14, t0.mainUrl AS mainUrl_15, t0.id AS id_16, t0.created AS created_17, t0.changed AS changed_18, t0.idContactsMain AS idContactsMain_19, t0.idAccountsParent AS idAccountsParent_20, t0.logo AS logo_21, t0.idUsersCreator AS idUsersCreator_22, t0.idUsersChanger AS idUsersChanger_23, t0.media AS media_24, t0.logoAlt AS logoAlt_25 FROM co_accounts t0 WHERE t0.id = ?
SELECT t0.lft AS lft_1, t0.rgt AS rgt_2, t0.depth AS depth_3, t0.name AS name_4, t0.externalId AS externalId_5, t0.number AS number_6, t0.corporation AS corporation_7, t0.note AS note_8, t0.uid AS uid_9, t0.registerNumber AS registerNumber_10, t0.placeOfJurisdiction AS placeOfJurisdiction_11, t0.mainEmail AS mainEmail_12, t0.mainPhone AS mainPhone_13, t0.mainFax AS mainFax_14, t0.mainUrl AS mainUrl_15, t0.id AS id_16, t0.created AS created_17, t0.changed AS changed_18, t0.idContactsMain AS idContactsMain_19, t0.idAccountsParent AS idAccountsParent_20, t0.logo AS logo_21, t0.idUsersCreator AS idUsersCreator_22, t0.idUsersChanger AS idUsersChanger_23, t0.media AS media_24, t0.logoAlt AS logoAlt_25 FROM co_accounts t0 WHERE t0.id = '1';
|
0.19 ms
(5.36%)
|
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, w1_.id ASC
Parameters: [
"preprod.fereol-depannage.com"
"dev"
"fereol"
]
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 = 'preprod.fereol-depannage.com' AND w1_.environment = 'dev')) AND w0_.webspace_key = 'fereol' ORDER BY w0_.id ASC, w1_.id ASC;
|
0.14 ms
(4.08%)
|
1 |
SELECT t0.id AS id_1, t0.created AS created_2, t0.changed AS changed_3, t0.idMediaTypes AS idMediaTypes_4, t0.idPreviewImage AS idPreviewImage_5, t0.idCollections AS idCollections_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM me_media t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.created AS created_2, t0.changed AS changed_3, t0.idMediaTypes AS idMediaTypes_4, t0.idPreviewImage AS idPreviewImage_5, t0.idCollections AS idCollections_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM me_media t0 WHERE t0.id = 41;
|
0.11 ms
(3.14%)
|
1 |
SELECT t0.name AS name_1, t0.version AS version_2, t0.subVersion AS subVersion_3, t0.size AS size_4, t0.downloadCounter AS downloadCounter_5, t0.storageOptions AS storageOptions_6, t0.mimeType AS mimeType_7, t0.properties AS properties_8, t0.focusPointX AS focusPointX_9, t0.focusPointY AS focusPointY_10, t0.id AS id_11, t0.created AS created_12, t0.changed AS changed_13, t0.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_14, t0.idFiles AS idFiles_15, t0.idUsersCreator AS idUsersCreator_16, t0.idUsersChanger AS idUsersChanger_17 FROM me_file_versions t0 WHERE t0.idFiles = ?
SELECT t0.name AS name_1, t0.version AS version_2, t0.subVersion AS subVersion_3, t0.size AS size_4, t0.downloadCounter AS downloadCounter_5, t0.storageOptions AS storageOptions_6, t0.mimeType AS mimeType_7, t0.properties AS properties_8, t0.focusPointX AS focusPointX_9, t0.focusPointY AS focusPointY_10, t0.id AS id_11, t0.created AS created_12, t0.changed AS changed_13, t0.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_14, t0.idFiles AS idFiles_15, t0.idUsersCreator AS idUsersCreator_16, t0.idUsersChanger AS idUsersChanger_17 FROM me_file_versions t0 WHERE t0.idFiles = 41;
|
0.11 ms
(3.12%)
|
1 |
SELECT t0.version AS version_1, t0.id AS id_2, t0.created AS created_3, t0.changed AS changed_4, t0.idMedia AS idMedia_5, t0.idUsersCreator AS idUsersCreator_6, t0.idUsersChanger AS idUsersChanger_7 FROM me_files t0 WHERE t0.idMedia = ?
SELECT t0.version AS version_1, t0.id AS id_2, t0.created AS created_3, t0.changed AS changed_4, t0.idMedia AS idMedia_5, t0.idUsersCreator AS idUsersCreator_6, t0.idUsersChanger AS idUsersChanger_7 FROM me_files t0 WHERE t0.idMedia = 41;
|