1.16 ms (15.13%)
5
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 , m5_ . crop_x AS crop_x_31 , m5_ . crop_y AS crop_y_32 , m5_ . crop_width AS crop_width_33 , m5_ . crop_height AS crop_height_34 , m5_ . format_key AS format_key_35 , m6_ . title AS title_36 , m6_ . description AS description_37 , m6_ . copyright AS copyright_38 , m6_ . credits AS credits_39 , m6_ . locale AS locale_40 , m6_ . id AS id_41 , m7_ . title AS title_42 , m7_ . description AS description_43 , m7_ . copyright AS copyright_44 , m7_ . credits AS credits_45 , m7_ . locale AS locale_46 , m7_ . id AS id_47 , m8_ . locale AS locale_48 , m8_ . id AS id_49 , m9_ . locale AS locale_50 , m9_ . id AS id_51 , s10_ . username AS username_52 , s10_ . password AS password_53 , s10_ . locale AS locale_54 , s10_ . salt AS salt_55 , s10_ . locked AS locked_56 , s10_ . enabled AS enabled_57 , s10_ . lastLogin AS lastLogin_58 , s10_ . confirmationKey AS confirmationKey_59 , s10_ . passwordResetToken AS passwordResetToken_60 , s10_ . passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_61 , s10_ . passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_62 , s10_ . privateKey AS privateKey_63 , s10_ . apiKey AS apiKey_64 , s10_ . email AS email_65 , s10_ . id AS id_66 , s10_ . created AS created_67 , s10_ . changed AS changed_68 , c11_ . firstName AS firstName_69 , c11_ . middleName AS middleName_70 , c11_ . lastName AS lastName_71 , c11_ . birthday AS birthday_72 , c11_ . salutation AS salutation_73 , c11_ . formOfAddress AS formOfAddress_74 , c11_ . newsletter AS newsletter_75 , c11_ . gender AS gender_76 , c11_ . note AS note_77 , c11_ . mainEmail AS mainEmail_78 , c11_ . mainPhone AS mainPhone_79 , c11_ . mainFax AS mainFax_80 , c11_ . mainUrl AS mainUrl_81 , c11_ . id AS id_82 , c11_ . created AS created_83 , c11_ . changed AS changed_84 , s12_ . username AS username_85 , s12_ . password AS password_86 , s12_ . locale AS locale_87 , s12_ . salt AS salt_88 , s12_ . locked AS locked_89 , s12_ . enabled AS enabled_90 , s12_ . lastLogin AS lastLogin_91 , s12_ . confirmationKey AS confirmationKey_92 , s12_ . passwordResetToken AS passwordResetToken_93 , s12_ . passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_94 , s12_ . passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_95 , s12_ . privateKey AS privateKey_96 , s12_ . apiKey AS apiKey_97 , s12_ . email AS email_98 , s12_ . id AS id_99 , s12_ . created AS created_100 , s12_ . changed AS changed_101 , c13_ . firstName AS firstName_102 , c13_ . middleName AS middleName_103 , c13_ . lastName AS lastName_104 , c13_ . birthday AS birthday_105 , c13_ . salutation AS salutation_106 , c13_ . formOfAddress AS formOfAddress_107 , c13_ . newsletter AS newsletter_108 , c13_ . gender AS gender_109 , c13_ . note AS note_110 , c13_ . mainEmail AS mainEmail_111 , c13_ . mainPhone AS mainPhone_112 , c13_ . mainFax AS mainFax_113 , c13_ . mainUrl AS mainUrl_114 , c13_ . id AS id_115 , c13_ . created AS created_116 , c13_ . changed AS changed_117 , m14_ . id AS id_118 , m14_ . created AS created_119 , m14_ . changed AS changed_120 , m0_ . idMediaTypes AS idMediaTypes_121 , m0_ . idPreviewImage AS idPreviewImage_122 , m0_ . idCollections AS idCollections_123 , m0_ . idUsersCreator AS idUsersCreator_124 , m0_ . idUsersChanger AS idUsersChanger_125 , m2_ . idCollectionsMetaDefault AS idCollectionsMetaDefault_126 , m2_ . idCollectionTypes AS idCollectionTypes_127 , m2_ . idCollectionsParent AS idCollectionsParent_128 , m2_ . idUsersCreator AS idUsersCreator_129 , m2_ . idUsersChanger AS idUsersChanger_130 , m3_ . idMedia AS idMedia_131 , m3_ . idUsersCreator AS idUsersCreator_132 , m3_ . idUsersChanger AS idUsersChanger_133 , m4_ . idFileVersionsMetaDefault AS idFileVersionsMetaDefault_134 , m4_ . idFiles AS idFiles_135 , m4_ . idUsersCreator AS idUsersCreator_136 , m4_ . idUsersChanger AS idUsersChanger_137 , m5_ . fileVersion AS fileVersion_138 , m6_ . idFileVersions AS idFileVersions_139 , m7_ . idFileVersions AS idFileVersions_140 , m8_ . idFileVersions AS idFileVersions_141 , m9_ . idFileVersions AS idFileVersions_142 , s10_ . idContacts AS idContacts_143 , s10_ . idUsersCreator AS idUsersCreator_144 , s10_ . idUsersChanger AS idUsersChanger_145 , c11_ . idTitles AS idTitles_146 , c11_ . avatar AS avatar_147 , c11_ . idUsersCreator AS idUsersCreator_148 , c11_ . idUsersChanger AS idUsersChanger_149 , s12_ . idContacts AS idContacts_150 , s12_ . idUsersCreator AS idUsersCreator_151 , s12_ . idUsersChanger AS idUsersChanger_152 , c13_ . idTitles AS idTitles_153 , c13_ . avatar AS avatar_154 , c13_ . idUsersCreator AS idUsersCreator_155 , c13_ . idUsersChanger AS idUsersChanger_156 , m14_ . idMediaTypes AS idMediaTypes_157 , m14_ . idPreviewImage AS idPreviewImage_158 , m14_ . idCollections AS idCollections_159 , m14_ . idUsersCreator AS idUsersCreator_160 , m14_ . idUsersChanger AS idUsersChanger_161 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 LEFT JOIN me_files m3_ ON m0_ . id = m3_ . idMedia LEFT JOIN me_file_versions m4_ ON m3_ . id = m4_ . idFiles LEFT JOIN me_format_options m5_ ON m4_ . id = m5_ . fileVersion 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 LEFT JOIN me_media m14_ ON m0_ . idPreviewImage = m14_ . id WHERE m0_ . id = ?
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 ,
m5_ . crop_x AS crop_x_31 ,
m5_ . crop_y AS crop_y_32 ,
m5_ . crop_width AS crop_width_33 ,
m5_ . crop_height AS crop_height_34 ,
m5_ . format_key AS format_key_35 ,
m6_ . title AS title_36 ,
m6_ . description AS description_37 ,
m6_ . copyright AS copyright_38 ,
m6_ . credits AS credits_39 ,
m6_ . locale AS locale_40 ,
m6_ . id AS id_41 ,
m7_ . title AS title_42 ,
m7_ . description AS description_43 ,
m7_ . copyright AS copyright_44 ,
m7_ . credits AS credits_45 ,
m7_ . locale AS locale_46 ,
m7_ . id AS id_47 ,
m8_ . locale AS locale_48 ,
m8_ . id AS id_49 ,
m9_ . locale AS locale_50 ,
m9_ . id AS id_51 ,
s10_ . username AS username_52 ,
s10_ . password AS password_53 ,
s10_ . locale AS locale_54 ,
s10_ . salt AS salt_55 ,
s10_ . locked AS locked_56 ,
s10_ . enabled AS enabled_57 ,
s10_ . lastLogin AS lastLogin_58 ,
s10_ . confirmationKey AS confirmationKey_59 ,
s10_ . passwordResetToken AS passwordResetToken_60 ,
s10_ . passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_61 ,
s10_ . passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_62 ,
s10_ . privateKey AS privateKey_63 ,
s10_ . apiKey AS apiKey_64 ,
s10_ . email AS email_65 ,
s10_ . id AS id_66 ,
s10_ . created AS created_67 ,
s10_ . changed AS changed_68 ,
c11_ . firstName AS firstName_69 ,
c11_ . middleName AS middleName_70 ,
c11_ . lastName AS lastName_71 ,
c11_ . birthday AS birthday_72 ,
c11_ . salutation AS salutation_73 ,
c11_ . formOfAddress AS formOfAddress_74 ,
c11_ . newsletter AS newsletter_75 ,
c11_ . gender AS gender_76 ,
c11_ . note AS note_77 ,
c11_ . mainEmail AS mainEmail_78 ,
c11_ . mainPhone AS mainPhone_79 ,
c11_ . mainFax AS mainFax_80 ,
c11_ . mainUrl AS mainUrl_81 ,
c11_ . id AS id_82 ,
c11_ . created AS created_83 ,
c11_ . changed AS changed_84 ,
s12_ . username AS username_85 ,
s12_ . password AS password_86 ,
s12_ . locale AS locale_87 ,
s12_ . salt AS salt_88 ,
s12_ . locked AS locked_89 ,
s12_ . enabled AS enabled_90 ,
s12_ . lastLogin AS lastLogin_91 ,
s12_ . confirmationKey AS confirmationKey_92 ,
s12_ . passwordResetToken AS passwordResetToken_93 ,
s12_ . passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_94 ,
s12_ . passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_95 ,
s12_ . privateKey AS privateKey_96 ,
s12_ . apiKey AS apiKey_97 ,
s12_ . email AS email_98 ,
s12_ . id AS id_99 ,
s12_ . created AS created_100 ,
s12_ . changed AS changed_101 ,
c13_ . firstName AS firstName_102 ,
c13_ . middleName AS middleName_103 ,
c13_ . lastName AS lastName_104 ,
c13_ . birthday AS birthday_105 ,
c13_ . salutation AS salutation_106 ,
c13_ . formOfAddress AS formOfAddress_107 ,
c13_ . newsletter AS newsletter_108 ,
c13_ . gender AS gender_109 ,
c13_ . note AS note_110 ,
c13_ . mainEmail AS mainEmail_111 ,
c13_ . mainPhone AS mainPhone_112 ,
c13_ . mainFax AS mainFax_113 ,
c13_ . mainUrl AS mainUrl_114 ,
c13_ . id AS id_115 ,
c13_ . created AS created_116 ,
c13_ . changed AS changed_117 ,
m14_ . id AS id_118 ,
m14_ . created AS created_119 ,
m14_ . changed AS changed_120 ,
m0_ . idMediaTypes AS idMediaTypes_121 ,
m0_ . idPreviewImage AS idPreviewImage_122 ,
m0_ . idCollections AS idCollections_123 ,
m0_ . idUsersCreator AS idUsersCreator_124 ,
m0_ . idUsersChanger AS idUsersChanger_125 ,
m2_ . idCollectionsMetaDefault AS idCollectionsMetaDefault_126 ,
m2_ . idCollectionTypes AS idCollectionTypes_127 ,
m2_ . idCollectionsParent AS idCollectionsParent_128 ,
m2_ . idUsersCreator AS idUsersCreator_129 ,
m2_ . idUsersChanger AS idUsersChanger_130 ,
m3_ . idMedia AS idMedia_131 ,
m3_ . idUsersCreator AS idUsersCreator_132 ,
m3_ . idUsersChanger AS idUsersChanger_133 ,
m4_ . idFileVersionsMetaDefault AS idFileVersionsMetaDefault_134 ,
m4_ . idFiles AS idFiles_135 ,
m4_ . idUsersCreator AS idUsersCreator_136 ,
m4_ . idUsersChanger AS idUsersChanger_137 ,
m5_ . fileVersion AS fileVersion_138 ,
m6_ . idFileVersions AS idFileVersions_139 ,
m7_ . idFileVersions AS idFileVersions_140 ,
m8_ . idFileVersions AS idFileVersions_141 ,
m9_ . idFileVersions AS idFileVersions_142 ,
s10_ . idContacts AS idContacts_143 ,
s10_ . idUsersCreator AS idUsersCreator_144 ,
s10_ . idUsersChanger AS idUsersChanger_145 ,
c11_ . idTitles AS idTitles_146 ,
c11_ . avatar AS avatar_147 ,
c11_ . idUsersCreator AS idUsersCreator_148 ,
c11_ . idUsersChanger AS idUsersChanger_149 ,
s12_ . idContacts AS idContacts_150 ,
s12_ . idUsersCreator AS idUsersCreator_151 ,
s12_ . idUsersChanger AS idUsersChanger_152 ,
c13_ . idTitles AS idTitles_153 ,
c13_ . avatar AS avatar_154 ,
c13_ . idUsersCreator AS idUsersCreator_155 ,
c13_ . idUsersChanger AS idUsersChanger_156 ,
m14_ . idMediaTypes AS idMediaTypes_157 ,
m14_ . idPreviewImage AS idPreviewImage_158 ,
m14_ . idCollections AS idCollections_159 ,
m14_ . idUsersCreator AS idUsersCreator_160 ,
m14_ . idUsersChanger AS idUsersChanger_161
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
LEFT JOIN me_files m3_ ON m0_ . id = m3_ . idMedia
LEFT JOIN me_file_versions m4_ ON m3_ . id = m4_ . idFiles
LEFT JOIN me_format_options m5_ ON m4_ . id = m5_ . fileVersion
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
LEFT JOIN me_media m14_ ON m0_ . idPreviewImage = m14_ . id
WHERE
m0_ . id = ?
Copy
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 , m5_ . crop_x AS crop_x_31 , m5_ . crop_y AS crop_y_32 , m5_ . crop_width AS crop_width_33 , m5_ . crop_height AS crop_height_34 , m5_ . format_key AS format_key_35 , m6_ . title AS title_36 , m6_ . description AS description_37 , m6_ . copyright AS copyright_38 , m6_ . credits AS credits_39 , m6_ . locale AS locale_40 , m6_ . id AS id_41 , m7_ . title AS title_42 , m7_ . description AS description_43 , m7_ . copyright AS copyright_44 , m7_ . credits AS credits_45 , m7_ . locale AS locale_46 , m7_ . id AS id_47 , m8_ . locale AS locale_48 , m8_ . id AS id_49 , m9_ . locale AS locale_50 , m9_ . id AS id_51 , s10_ . username AS username_52 , s10_ . password AS password_53 , s10_ . locale AS locale_54 , s10_ . salt AS salt_55 , s10_ . locked AS locked_56 , s10_ . enabled AS enabled_57 , s10_ . lastLogin AS lastLogin_58 , s10_ . confirmationKey AS confirmationKey_59 , s10_ . passwordResetToken AS passwordResetToken_60 , s10_ . passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_61 , s10_ . passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_62 , s10_ . privateKey AS privateKey_63 , s10_ . apiKey AS apiKey_64 , s10_ . email AS email_65 , s10_ . id AS id_66 , s10_ . created AS created_67 , s10_ . changed AS changed_68 , c11_ . firstName AS firstName_69 , c11_ . middleName AS middleName_70 , c11_ . lastName AS lastName_71 , c11_ . birthday AS birthday_72 , c11_ . salutation AS salutation_73 , c11_ . formOfAddress AS formOfAddress_74 , c11_ . newsletter AS newsletter_75 , c11_ . gender AS gender_76 , c11_ . note AS note_77 , c11_ . mainEmail AS mainEmail_78 , c11_ . mainPhone AS mainPhone_79 , c11_ . mainFax AS mainFax_80 , c11_ . mainUrl AS mainUrl_81 , c11_ . id AS id_82 , c11_ . created AS created_83 , c11_ . changed AS changed_84 , s12_ . username AS username_85 , s12_ . password AS password_86 , s12_ . locale AS locale_87 , s12_ . salt AS salt_88 , s12_ . locked AS locked_89 , s12_ . enabled AS enabled_90 , s12_ . lastLogin AS lastLogin_91 , s12_ . confirmationKey AS confirmationKey_92 , s12_ . passwordResetToken AS passwordResetToken_93 , s12_ . passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_94 , s12_ . passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_95 , s12_ . privateKey AS privateKey_96 , s12_ . apiKey AS apiKey_97 , s12_ . email AS email_98 , s12_ . id AS id_99 , s12_ . created AS created_100 , s12_ . changed AS changed_101 , c13_ . firstName AS firstName_102 , c13_ . middleName AS middleName_103 , c13_ . lastName AS lastName_104 , c13_ . birthday AS birthday_105 , c13_ . salutation AS salutation_106 , c13_ . formOfAddress AS formOfAddress_107 , c13_ . newsletter AS newsletter_108 , c13_ . gender AS gender_109 , c13_ . note AS note_110 , c13_ . mainEmail AS mainEmail_111 , c13_ . mainPhone AS mainPhone_112 , c13_ . mainFax AS mainFax_113 , c13_ . mainUrl AS mainUrl_114 , c13_ . id AS id_115 , c13_ . created AS created_116 , c13_ . changed AS changed_117 , m14_ . id AS id_118 , m14_ . created AS created_119 , m14_ . changed AS changed_120 , m0_ . idMediaTypes AS idMediaTypes_121 , m0_ . idPreviewImage AS idPreviewImage_122 , m0_ . idCollections AS idCollections_123 , m0_ . idUsersCreator AS idUsersCreator_124 , m0_ . idUsersChanger AS idUsersChanger_125 , m2_ . idCollectionsMetaDefault AS idCollectionsMetaDefault_126 , m2_ . idCollectionTypes AS idCollectionTypes_127 , m2_ . idCollectionsParent AS idCollectionsParent_128 , m2_ . idUsersCreator AS idUsersCreator_129 , m2_ . idUsersChanger AS idUsersChanger_130 , m3_ . idMedia AS idMedia_131 , m3_ . idUsersCreator AS idUsersCreator_132 , m3_ . idUsersChanger AS idUsersChanger_133 , m4_ . idFileVersionsMetaDefault AS idFileVersionsMetaDefault_134 , m4_ . idFiles AS idFiles_135 , m4_ . idUsersCreator AS idUsersCreator_136 , m4_ . idUsersChanger AS idUsersChanger_137 , m5_ . fileVersion AS fileVersion_138 , m6_ . idFileVersions AS idFileVersions_139 , m7_ . idFileVersions AS idFileVersions_140 , m8_ . idFileVersions AS idFileVersions_141 , m9_ . idFileVersions AS idFileVersions_142 , s10_ . idContacts AS idContacts_143 , s10_ . idUsersCreator AS idUsersCreator_144 , s10_ . idUsersChanger AS idUsersChanger_145 , c11_ . idTitles AS idTitles_146 , c11_ . avatar AS avatar_147 , c11_ . idUsersCreator AS idUsersCreator_148 , c11_ . idUsersChanger AS idUsersChanger_149 , s12_ . idContacts AS idContacts_150 , s12_ . idUsersCreator AS idUsersCreator_151 , s12_ . idUsersChanger AS idUsersChanger_152 , c13_ . idTitles AS idTitles_153 , c13_ . avatar AS avatar_154 , c13_ . idUsersCreator AS idUsersCreator_155 , c13_ . idUsersChanger AS idUsersChanger_156 , m14_ . idMediaTypes AS idMediaTypes_157 , m14_ . idPreviewImage AS idPreviewImage_158 , m14_ . idCollections AS idCollections_159 , m14_ . idUsersCreator AS idUsersCreator_160 , m14_ . idUsersChanger AS idUsersChanger_161 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 LEFT JOIN me_files m3_ ON m0_ . id = m3_ . idMedia LEFT JOIN me_file_versions m4_ ON m3_ . id = m4_ . idFiles LEFT JOIN me_format_options m5_ ON m4_ . id = m5_ . fileVersion 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 LEFT JOIN me_media m14_ ON m0_ . idPreviewImage = m14_ . id WHERE m0_ . id = 17 ;
Copy
1.13 ms (14.80%)
2
SELECT f0_ . defaultLocale AS defaultLocale_0 , f0_ . id AS id_1 , f1_ . title AS title_2 , f1_ . subject AS subject_3 , f1_ . fromEmail AS fromEmail_4 , f1_ . fromName AS fromName_5 , f1_ . toEmail AS toEmail_6 , f1_ . toName AS toName_7 , f1_ . mailText AS mailText_8 , f1_ . submitLabel AS submitLabel_9 , f1_ . successText AS successText_10 , f1_ . sendAttachments AS sendAttachments_11 , f1_ . deactivateAttachmentSave AS deactivateAttachmentSave_12 , f1_ . deactivateNotifyMails AS deactivateNotifyMails_13 , f1_ . deactivateCustomerMails AS deactivateCustomerMails_14 , f1_ . replyTo AS replyTo_15 , f1_ . locale AS locale_16 , f1_ . id AS id_17 , f1_ . created AS created_18 , f1_ . changed AS changed_19 , f2_ . keyName AS keyName_20 , f2_ . orderNumber AS orderNumber_21 , f2_ . type AS type_22 , f2_ . width AS width_23 , f2_ . required AS required_24 , f2_ . defaultLocale AS defaultLocale_25 , f2_ . id AS id_26 , f3_ . title AS title_27 , f3_ . placeholder AS placeholder_28 , f3_ . defaultValue AS defaultValue_29 , f3_ . shortTitle AS shortTitle_30 , f3_ . locale AS locale_31 , f3_ . options AS options_32 , f3_ . id AS id_33 , f4_ . type AS type_34 , f4_ . email AS email_35 , f4_ . name AS name_36 , f4_ . id AS id_37 , f1_ . idForms AS idForms_38 , f1_ . idUsersCreator AS idUsersCreator_39 , f1_ . idUsersChanger AS idUsersChanger_40 , f2_ . idForms AS idForms_41 , f3_ . idFormFields AS idFormFields_42 , f4_ . idFormTranslations AS idFormTranslations_43 FROM fo_forms f0_ LEFT JOIN fo_form_translations f1_ ON f0_ . id = f1_ . idForms LEFT JOIN fo_form_fields f2_ ON f0_ . id = f2_ . idForms LEFT JOIN fo_form_field_translations f3_ ON f2_ . id = f3_ . idFormFields LEFT JOIN fo_form_translation_receivers f4_ ON f1_ . id = f4_ . idFormTranslations WHERE f0_ . id = ? ORDER BY f2_ . orderNumber ASC
SELECT
f0_ . defaultLocale AS defaultLocale_0 ,
f0_ . id AS id_1 ,
f1_ . title AS title_2 ,
f1_ . subject AS subject_3 ,
f1_ . fromEmail AS fromEmail_4 ,
f1_ . fromName AS fromName_5 ,
f1_ . toEmail AS toEmail_6 ,
f1_ . toName AS toName_7 ,
f1_ . mailText AS mailText_8 ,
f1_ . submitLabel AS submitLabel_9 ,
f1_ . successText AS successText_10 ,
f1_ . sendAttachments AS sendAttachments_11 ,
f1_ . deactivateAttachmentSave AS deactivateAttachmentSave_12 ,
f1_ . deactivateNotifyMails AS deactivateNotifyMails_13 ,
f1_ . deactivateCustomerMails AS deactivateCustomerMails_14 ,
f1_ . replyTo AS replyTo_15 ,
f1_ . locale AS locale_16 ,
f1_ . id AS id_17 ,
f1_ . created AS created_18 ,
f1_ . changed AS changed_19 ,
f2_ . keyName AS keyName_20 ,
f2_ . orderNumber AS orderNumber_21 ,
f2_ . type AS type_22 ,
f2_ . width AS width_23 ,
f2_ . required AS required_24 ,
f2_ . defaultLocale AS defaultLocale_25 ,
f2_ . id AS id_26 ,
f3_ . title AS title_27 ,
f3_ . placeholder AS placeholder_28 ,
f3_ . defaultValue AS defaultValue_29 ,
f3_ . shortTitle AS shortTitle_30 ,
f3_ . locale AS locale_31 ,
f3_ . options AS options_32 ,
f3_ . id AS id_33 ,
f4_ . type AS type_34 ,
f4_ . email AS email_35 ,
f4_ . name AS name_36 ,
f4_ . id AS id_37 ,
f1_ . idForms AS idForms_38 ,
f1_ . idUsersCreator AS idUsersCreator_39 ,
f1_ . idUsersChanger AS idUsersChanger_40 ,
f2_ . idForms AS idForms_41 ,
f3_ . idFormFields AS idFormFields_42 ,
f4_ . idFormTranslations AS idFormTranslations_43
FROM
fo_forms f0_
LEFT JOIN fo_form_translations f1_ ON f0_ . id = f1_ . idForms
LEFT JOIN fo_form_fields f2_ ON f0_ . id = f2_ . idForms
LEFT JOIN fo_form_field_translations f3_ ON f2_ . id = f3_ . idFormFields
LEFT JOIN fo_form_translation_receivers f4_ ON f1_ . id = f4_ . idFormTranslations
WHERE
f0_ . id = ?
ORDER BY
f2_ . orderNumber ASC
Copy
SELECT f0_ . defaultLocale AS defaultLocale_0 , f0_ . id AS id_1 , f1_ . title AS title_2 , f1_ . subject AS subject_3 , f1_ . fromEmail AS fromEmail_4 , f1_ . fromName AS fromName_5 , f1_ . toEmail AS toEmail_6 , f1_ . toName AS toName_7 , f1_ . mailText AS mailText_8 , f1_ . submitLabel AS submitLabel_9 , f1_ . successText AS successText_10 , f1_ . sendAttachments AS sendAttachments_11 , f1_ . deactivateAttachmentSave AS deactivateAttachmentSave_12 , f1_ . deactivateNotifyMails AS deactivateNotifyMails_13 , f1_ . deactivateCustomerMails AS deactivateCustomerMails_14 , f1_ . replyTo AS replyTo_15 , f1_ . locale AS locale_16 , f1_ . id AS id_17 , f1_ . created AS created_18 , f1_ . changed AS changed_19 , f2_ . keyName AS keyName_20 , f2_ . orderNumber AS orderNumber_21 , f2_ . type AS type_22 , f2_ . width AS width_23 , f2_ . required AS required_24 , f2_ . defaultLocale AS defaultLocale_25 , f2_ . id AS id_26 , f3_ . title AS title_27 , f3_ . placeholder AS placeholder_28 , f3_ . defaultValue AS defaultValue_29 , f3_ . shortTitle AS shortTitle_30 , f3_ . locale AS locale_31 , f3_ . options AS options_32 , f3_ . id AS id_33 , f4_ . type AS type_34 , f4_ . email AS email_35 , f4_ . name AS name_36 , f4_ . id AS id_37 , f1_ . idForms AS idForms_38 , f1_ . idUsersCreator AS idUsersCreator_39 , f1_ . idUsersChanger AS idUsersChanger_40 , f2_ . idForms AS idForms_41 , f3_ . idFormFields AS idFormFields_42 , f4_ . idFormTranslations AS idFormTranslations_43 FROM fo_forms f0_ LEFT JOIN fo_form_translations f1_ ON f0_ . id = f1_ . idForms LEFT JOIN fo_form_fields f2_ ON f0_ . id = f2_ . idForms LEFT JOIN fo_form_field_translations f3_ ON f2_ . id = f3_ . idFormFields LEFT JOIN fo_form_translation_receivers f4_ ON f1_ . id = f4_ . idFormTranslations WHERE f0_ . id = 2 ORDER BY f2_ . orderNumber ASC ;
Copy