Query Metrics

30 Database Queries
14 Different statements
86.62 ms Query time
0 Invalid entities
220 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.76 ms
SELECT r0_.webspace AS webspace_0, r0_.locale AS locale_1, r0_.slug AS slug_2, r0_.resource_key AS resource_key_3, r0_.resource_id AS resource_id_4, r0_.id AS id_5, r0_.parent_id AS parent_id_6 FROM ro_routes r0_ WHERE ((r0_.webspace = ? OR r0_.webspace IS NULL)) AND r0_.locale = ? AND r0_.slug = ? ORDER BY r0_.webspace DESC LIMIT 1
Parameters:
[
  "pakom"
  "hr"
  "/shop/unutarnja-sjenila/rolo-sjenila/rfl-unutarnje-rolo-sjenilo-za-zasjenjenje-s-rucnim-upravljanjem"
]
2 1.58 ms
SELECT p0_.webspaceKey AS webspaceKey_0, p0_.lft AS lft_1, p0_.rgt AS rgt_2, p0_.depth AS depth_3, p0_.uuid AS uuid_4, p0_.created AS created_5, p0_.changed AS changed_6, p1_.title AS title_7, p1_.id AS id_8, p1_.stage AS stage_9, p1_.locale AS locale_10, p1_.ghostLocale AS ghostLocale_11, p1_.availableLocales AS availableLocales_12, p1_.version AS version_13, p1_.shadowLocale AS shadowLocale_14, p1_.shadowLocales AS shadowLocales_15, p1_.templateKey AS templateKey_16, p1_.templateData AS templateData_17, p1_.seoData AS seoData_18, p1_.seoNoIndex AS seoNoIndex_19, p1_.seoNoFollow AS seoNoFollow_20, p1_.seoHideInSitemap AS seoHideInSitemap_21, p1_.excerptData AS excerptData_22, p1_.excerptSegment AS excerptSegment_23, p1_.authored AS authored_24, p1_.lastModified AS lastModified_25, p1_.workflowPlace AS workflowPlace_26, p1_.workflowPublished AS workflowPublished_27, p1_.linkProvider AS linkProvider_28, p1_.linkData AS linkData_29, p1_.created AS created_30, p1_.changed AS changed_31, t2_.name AS name_32, t2_.id AS id_33, t2_.created AS created_34, t2_.changed AS changed_35, c3_.category_key AS category_key_36, c3_.default_locale AS default_locale_37, c3_.lft AS lft_38, c3_.rgt AS rgt_39, c3_.depth AS depth_40, c3_.id AS id_41, c3_.created AS created_42, c3_.changed AS changed_43, c4_.translation AS translation_44, c4_.locale AS locale_45, c4_.description AS description_46, c4_.id AS id_47, c4_.created AS created_48, c4_.changed AS changed_49, p0_.parent_id AS parent_id_50, p0_.idUsersCreator AS idUsersCreator_51, p0_.idUsersChanger AS idUsersChanger_52, p1_.route_id AS route_id_53, p1_.pageUuid AS pageUuid_54, p1_.author_id AS author_id_55, p1_.idUsersCreator AS idUsersCreator_56, p1_.idUsersChanger AS idUsersChanger_57, t2_.idUsersCreator AS idUsersCreator_58, t2_.idUsersChanger AS idUsersChanger_59, c3_.idCategoriesParent AS idCategoriesParent_60, c3_.idUsersCreator AS idUsersCreator_61, c3_.idUsersChanger AS idUsersChanger_62, c4_.idCategories AS idCategories_63, c4_.idUsersCreator AS idUsersCreator_64, c4_.idUsersChanger AS idUsersChanger_65 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid LEFT JOIN pa_page_dimension_content_excerpt_tags p5_ ON p1_.id = p5_.page_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = p5_.tag_id LEFT JOIN pa_page_dimension_content_excerpt_categories p6_ ON p1_.id = p6_.page_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = p6_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories AND (c4_.locale = c3_.default_locale OR c4_.locale IN (?)) WHERE p0_.uuid = ? AND (((p1_.locale IS NULL OR p1_.locale IN (?)) AND (p1_.stage IS NULL OR p1_.stage IN (?))) AND (p1_.version IS NULL OR p1_.version IN (?)))
Parameters:
[
  "hr"
  "01a0a54a-ebde-763c-afa8-84a5a5293c11"
  "hr"
  "live"
  0
]
3 0.47 ms
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters:
[
  569
]
4 0.33 ms
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters:
[
  570
]
5 2.10 ms
SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.style AS style_4, m1_.lft AS lft_5, m1_.rgt AS rgt_6, m1_.depth AS depth_7, m1_.collection_key AS collection_key_8, m1_.id AS id_9, m1_.created AS created_10, m1_.changed AS changed_11, m2_.version AS version_12, m2_.id AS id_13, m2_.created AS created_14, m2_.changed AS changed_15, m3_.name AS name_16, m3_.version AS version_17, m3_.subVersion AS subVersion_18, m3_.size AS size_19, m3_.downloadCounter AS downloadCounter_20, m3_.storageOptions AS storageOptions_21, m3_.mimeType AS mimeType_22, m3_.properties AS properties_23, m3_.focusPointX AS focusPointX_24, m3_.focusPointY AS focusPointY_25, m3_.origin AS origin_26, m3_.aiDisclosureDisabled AS aiDisclosureDisabled_27, m3_.aiDisclosureIconVariant AS aiDisclosureIconVariant_28, m3_.id AS id_29, m3_.created AS created_30, m3_.changed AS changed_31, t4_.name AS name_32, t4_.id AS id_33, t4_.created AS created_34, t4_.changed AS changed_35, m5_.title AS title_36, m5_.description AS description_37, m5_.aiDisclosureText AS aiDisclosureText_38, m5_.copyright AS copyright_39, m5_.credits AS credits_40, m5_.locale AS locale_41, m5_.id AS id_42, m6_.title AS title_43, m6_.description AS description_44, m6_.aiDisclosureText AS aiDisclosureText_45, m6_.copyright AS copyright_46, m6_.credits AS credits_47, m6_.locale AS locale_48, m6_.id AS id_49, s7_.username AS username_50, s7_.password AS password_51, s7_.locale AS locale_52, s7_.salt AS salt_53, s7_.locked AS locked_54, s7_.enabled AS enabled_55, s7_.lastLogin AS lastLogin_56, s7_.confirmationKey AS confirmationKey_57, s7_.passwordResetToken AS passwordResetToken_58, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_59, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_60, s7_.privateKey AS privateKey_61, s7_.apiKey AS apiKey_62, s7_.email AS email_63, s7_.id AS id_64, s7_.created AS created_65, s7_.changed AS changed_66, s7_.tracking AS tracking_67, s7_.buying_and_selling AS buying_and_selling_68, s7_.delivery AS delivery_69, s7_.marketing AS marketing_70, c8_.firstName AS firstName_71, c8_.middleName AS middleName_72, c8_.lastName AS lastName_73, c8_.birthday AS birthday_74, c8_.salutation AS salutation_75, c8_.formOfAddress AS formOfAddress_76, c8_.newsletter AS newsletter_77, c8_.gender AS gender_78, c8_.note AS note_79, c8_.mainEmail AS mainEmail_80, c8_.mainPhone AS mainPhone_81, c8_.mainFax AS mainFax_82, c8_.mainUrl AS mainUrl_83, c8_.id AS id_84, c8_.created AS created_85, c8_.changed AS changed_86, s9_.username AS username_87, s9_.password AS password_88, s9_.locale AS locale_89, s9_.salt AS salt_90, s9_.locked AS locked_91, s9_.enabled AS enabled_92, s9_.lastLogin AS lastLogin_93, s9_.confirmationKey AS confirmationKey_94, s9_.passwordResetToken AS passwordResetToken_95, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_96, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_97, s9_.privateKey AS privateKey_98, s9_.apiKey AS apiKey_99, s9_.email AS email_100, s9_.id AS id_101, s9_.created AS created_102, s9_.changed AS changed_103, s9_.tracking AS tracking_104, s9_.buying_and_selling AS buying_and_selling_105, s9_.delivery AS delivery_106, s9_.marketing AS marketing_107, c10_.firstName AS firstName_108, c10_.middleName AS middleName_109, c10_.lastName AS lastName_110, c10_.birthday AS birthday_111, c10_.salutation AS salutation_112, c10_.formOfAddress AS formOfAddress_113, c10_.newsletter AS newsletter_114, c10_.gender AS gender_115, c10_.note AS note_116, c10_.mainEmail AS mainEmail_117, c10_.mainPhone AS mainPhone_118, c10_.mainFax AS mainFax_119, c10_.mainUrl AS mainUrl_120, c10_.id AS id_121, c10_.created AS created_122, c10_.changed AS changed_123, m0_.idPreviewImage AS idPreviewImage_124, m0_.idCollections AS idCollections_125, m0_.idUsersCreator AS idUsersCreator_126, m0_.idUsersChanger AS idUsersChanger_127, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_128, m1_.idCollectionTypes AS idCollectionTypes_129, m1_.idCollectionsParent AS idCollectionsParent_130, m1_.idUsersCreator AS idUsersCreator_131, m1_.idUsersChanger AS idUsersChanger_132, m2_.idMedia AS idMedia_133, m2_.idUsersCreator AS idUsersCreator_134, m2_.idUsersChanger AS idUsersChanger_135, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_136, m3_.idFiles AS idFiles_137, m3_.idUsersCreator AS idUsersCreator_138, m3_.idUsersChanger AS idUsersChanger_139, t4_.idUsersCreator AS idUsersCreator_140, t4_.idUsersChanger AS idUsersChanger_141, m5_.idFileVersions AS idFileVersions_142, m6_.idFileVersions AS idFileVersions_143, s7_.idUsersCreator AS idUsersCreator_144, s7_.idUsersChanger AS idUsersChanger_145, s7_.cart_id AS cart_id_146, s7_.idContacts AS idContacts_147, c8_.idTitles AS idTitles_148, c8_.avatar AS avatar_149, c8_.idUsersCreator AS idUsersCreator_150, c8_.idUsersChanger AS idUsersChanger_151, s9_.idUsersCreator AS idUsersCreator_152, s9_.idUsersChanger AS idUsersChanger_153, s9_.cart_id AS cart_id_154, s9_.idContacts AS idContacts_155, c10_.idTitles AS idTitles_156, c10_.avatar AS avatar_157, c10_.idUsersCreator AS idUsersCreator_158, c10_.idUsersChanger AS idUsersChanger_159 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id INNER JOIN me_files m2_ ON m0_.id = m2_.idMedia INNER JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles AND (m3_.version = m2_.version) LEFT JOIN me_file_version_tags m11_ ON m3_.id = m11_.idFileVersions LEFT JOIN ta_tags t4_ ON t4_.id = m11_.idTags LEFT JOIN me_file_version_meta m5_ ON m3_.id = m5_.idFileVersions LEFT JOIN me_file_version_meta m6_ ON m3_.idFileVersionsMetaDefault = m6_.id LEFT JOIN se_users s7_ ON m0_.idUsersCreator = s7_.id LEFT JOIN co_contacts c8_ ON s7_.idContacts = c8_.id LEFT JOIN se_users s9_ ON m0_.idUsersChanger = s9_.id LEFT JOIN co_contacts c10_ ON s9_.idContacts = c10_.id WHERE m0_.id IN (?) ORDER BY m0_.id ASC
Parameters:
[
  88
]
6 0.41 ms
SELECT t0.method AS method_1, t0.options AS options_2, t0.id AS id_3, t0.idUsers AS idUsers_4 FROM se_user_two_factors t0 WHERE t0.idUsers = ?
Parameters:
[
  2
]
7 0.53 ms
SELECT r0_.webspace AS webspace_0, r0_.locale AS locale_1, r0_.slug AS slug_2, r0_.resource_key AS resource_key_3, r0_.resource_id AS resource_id_4, r0_.id AS id_5, r0_.parent_id AS parent_id_6 FROM ro_routes r0_ WHERE r0_.locale IN (?) AND r0_.resource_key = ? AND r0_.resource_id = ?
Parameters:
[
  "hr"
  "pages"
  "01a0a54a-ebde-763c-afa8-84a5a5293c11"
]
8 13.50 ms
SELECT DISTINCT a0_.size AS size_0 FROM app_product a0_ WHERE a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.size ASC
Parameters:
[
  20341
  20342
  20343
  20344
  20345
  20346
  20347
  20348
  20349
  20350
  20351
  20352
  20353
  20354
  20355
  20356
  20357
  20358
  20359
  20360
  20361
  20362
  20363
  20364
  20365
  20366
  20367
  20368
  20369
  20370
  20371
  20372
  20373
  20374
  20375
  20376
  20377
  20378
  20379
  20380
  20381
  20382
  20383
  20384
  20385
  20386
  20387
  20388
  20389
  20390
  20391
  20392
  20393
  20394
  20395
  20396
  20397
  20398
  20399
  20400
  20401
  20402
  20403
  20404
  20405
  20406
  20407
  20408
  20409
  20410
  20411
  20412
  20413
  20414
  20415
  20416
  20417
  20418
  20419
  20420
  20421
  20422
  20423
  20424
  20425
  20426
  20427
  20428
  20429
  20430
  20431
  20432
  20433
  20434
  20435
  20436
  20437
  20438
  20439
  20440
  20441
  20442
  20443
  20444
  20445
  20446
  20447
  20448
  20449
  20450
  20451
  20452
  20453
  20454
  20455
  20456
  20457
  20458
  20459
  20460
  20461
  20462
  20463
  20464
  20465
  20466
  20467
  20468
  20469
  20470
  20471
  20472
  20473
  20474
  20475
  20476
  20477
  20478
  20479
  20480
  20481
  20482
  20483
  20484
  20485
  20486
  20487
  20488
  20489
  20490
  20491
  20492
  20493
  20494
  20495
  20496
  20497
  20498
  20499
  20500
  20501
  20502
  20503
  20504
  20505
  20506
  20507
  20508
  20509
  20510
  20511
  20512
  20513
  20514
  20515
  20516
  20517
  20518
  20519
  20520
  20521
  20522
  20523
  20524
  20525
  20526
  20527
  20528
  20529
  20530
  20531
  20532
  20533
  20534
  20535
  20536
  20537
  20538
  20539
  20540
  20541
  20542
  20543
  20544
  20545
  20546
  20547
  20548
  20549
  20550
  20551
  20552
  20553
  20554
  20555
  20556
  20557
  20558
  20559
  20560
  20561
  20562
  20563
  20564
  20565
  20566
  20567
  20568
  20569
  20570
  20571
  20572
  20573
  20574
  20575
  20576
  20577
  20578
  20579
  20580
  20581
  20582
  20583
  20584
  20585
  20586
  20587
  20588
  20589
  20590
  20591
  20592
  20593
  20594
  20595
  20596
  20597
  20598
  20599
  20600
  20601
  20602
  20603
  20604
  20605
  20606
  20607
  20608
  20609
  20610
  20611
  20612
  20613
  20614
  20615
  20616
  20617
  20618
  20619
  20620
  20621
  20622
  20623
  20624
  20625
  20626
  20627
  20628
  20629
  20630
  20631
  20632
  20633
  20634
  20635
  20636
  20637
  20638
  20639
  20640
  20641
  20642
  20643
  20644
  20645
  20646
  20647
  20648
  20649
  20650
  20651
  20652
  20653
  20654
  20655
  20656
  20657
  20658
  20659
  20660
  20661
  20662
  20663
  20664
  20665
  20666
  20667
  20668
  20669
  20670
  20671
  20672
  20673
  20674
  20675
  20676
  20677
  20678
  20679
  20680
  20681
  20682
  20683
  20684
  20685
  20686
  20687
  20688
  20689
  20690
  20691
  20692
  20693
  20694
  20695
  20696
  20697
  20698
  20699
  20700
  20701
  20702
  20703
  20704
  20705
  20706
  20707
  20708
  20709
  20710
  20711
  20712
  20713
  20714
  20715
  20716
  20717
  20718
  20719
  20720
  20721
  20722
  20723
  20724
  20725
  20726
  20727
  20728
  20729
  20730
  20731
  20732
  20733
  20734
  20735
  20736
  20737
  20738
  20739
  20740
  20741
  20742
  20743
  20744
  20745
  20746
  20747
  20748
  20749
  20750
  20751
  20752
  20753
  20754
  20755
  20756
  20757
  20758
  20759
  20760
  20761
  20762
  20763
  20764
  20765
  20766
  20767
  20768
  20769
  20770
  20771
  20772
  20773
  20774
  20775
  20776
  20777
  20778
  20779
  20780
  20781
  20782
  20783
  20784
  20785
  20786
  20787
  20788
  20789
  20790
  20791
  20792
  20793
  20794
  20795
  20796
  20797
  20798
  20799
  20800
  20801
  20802
  20803
  20804
  20805
  20806
  20807
  20808
  20809
  20810
  20811
  20812
  20813
  20814
  20815
  20816
  20817
  20818
  20819
  20820
  20821
  20822
  20823
  20824
  20825
  20826
  20827
  20828
  20829
  20830
  20831
  20832
  20833
  20834
  20835
  20836
  20837
  20838
  20839
  20840
  20841
  20842
  20843
  20844
  20845
  20846
  20847
  20848
  20849
  20850
  20851
  20852
  20853
  20854
  20855
  20856
  20857
  20858
  20859
  20860
  20861
  20862
  20863
  20864
  20865
  20866
  20867
  20868
  20869
  20870
  20871
  20872
  20873
  20874
  20875
  20876
  20877
  20878
  20879
  20880
  20881
  20882
  20883
  20884
  20885
  20886
  20887
  20888
  20889
  20890
  20891
  20892
  20893
  20894
  20895
  20896
  20897
  20898
  20899
  20900
  20901
  20902
  20903
  20904
  20905
  20906
  20907
  20908
  20909
  20910
  20911
  20912
  20913
  20914
  20915
  20916
  20917
  20918
  20919
  20920
  20921
  20922
  20923
  20924
  20925
  20926
  20927
  20928
  20929
  20930
  20931
  20932
  20933
  20934
  20935
  20936
  20937
  20938
  20939
  20940
  20941
  20942
  20943
  20944
  20945
  20946
  20947
  20948
  20949
  20950
  20951
  20952
  20953
  20954
  20955
  20956
  20957
  20958
  20959
  20960
  20961
  20962
  20963
  20964
  20965
  20966
  20967
  20968
  20969
  20970
  20971
  20972
  20973
  20974
  20975
  20976
  20977
  20978
  20979
  20980
  20981
  20982
  20983
  20984
  20985
  20986
  20987
  20988
  20989
  20990
  20991
  20992
  20993
  20994
  20995
  20996
  20997
  20998
  20999
  21000
  21001
  21002
  21003
  21004
  21005
  21006
  21007
  21008
  21009
  21010
  21011
  21012
  21013
  21014
  21015
  21016
  21017
  21018
  21019
  21020
  21021
  21022
  21023
  21024
  21025
  21026
  21027
  21028
  21029
  21030
  21031
  21032
  21033
  21034
  21035
  21036
  21037
  21038
  21039
  21040
  21041
  21042
  21043
  21044
  21045
  21046
  21047
  21048
  21049
  21050
  21051
  21052
  21053
  21054
  21055
  21056
  21057
  21058
  21059
  21060
  21061
  21062
  21063
  21064
  21065
  21066
  21067
  21068
  21069
  21070
  21071
  21072
  21073
  21074
  21075
  21076
  21077
  21078
  21079
  21080
  21081
  21082
  21083
  21084
  21085
  21086
  21087
  21088
  21089
  21090
  21091
  21092
  21093
  21094
  21095
  21096
  21097
  21098
  21099
  21100
  21101
  21102
  21103
  21104
  21105
  21106
  21107
  21108
  21109
  21110
  21111
  21112
  21113
  21114
  21115
  21116
  21117
  21118
  21119
  21120
  21121
  21122
  21123
  21124
  21125
  21126
  21127
  21128
  21129
  21130
  21131
  21132
  21133
  21134
  21135
  21136
  21137
  21138
  21139
  21140
  21141
  21142
  21143
  21144
  21145
  21146
  21147
  21148
  21149
  21150
  21151
  21152
  21153
  21154
  21155
  21156
  21157
  21158
  21159
  21160
  21161
  21162
  21163
  21164
  21165
  21166
  21167
  21168
  21169
  21170
  21171
  21172
  21173
  21174
  21175
  21176
  21177
  21178
  21179
  21180
  21181
  21182
  21183
  21184
  21185
  21186
  21187
  21188
  21189
  21190
  21191
  21192
  21193
  21194
  21195
  21196
  21197
  21198
  21199
  21200
  21201
  21202
  21203
  21204
  21205
  21206
  21207
  21208
  21209
  21210
  21211
  21212
  21213
  21214
  21215
  21216
  21217
  21218
  21219
  21220
  21221
  21222
  21223
  21224
  21225
  21226
  21227
  21228
  21229
  21230
  21231
  21232
  21233
  21234
  21235
  21236
  21237
  21238
  21239
  21240
  21241
  21242
  21243
  21244
  21245
  21246
  21247
  21248
  21249
  21250
  21251
  21252
  21253
  21254
  21255
  21256
  21257
  21258
  21259
  21260
  21261
  21262
  21263
  21264
  21265
  21266
  21267
  21268
  21269
  21270
  21271
  21272
  21273
  21274
  21275
  21276
  21277
  21278
  21279
  21280
  21281
  21282
  21283
  21284
  21285
  21286
  21287
  21288
  21289
  21290
  21291
  21292
  21293
  21294
  21295
  21296
  21297
  21298
  21299
  21300
  21301
  21302
  21303
  21304
  21305
  21306
  21307
  21308
  21309
  21310
  21311
  21312
  21313
  21314
  21315
  21316
  21317
  21318
  21319
  21320
  21321
  21322
  21323
  21324
  21325
  21326
  21327
  21328
  21329
  21330
  21331
  21332
  21333
  21334
  21335
  21336
  21337
  21338
  21339
  21340
  21341
  21342
  21343
  21344
  21345
  21346
  21347
  21348
  21349
  21350
  21351
  21352
  21353
  21354
  21355
  21356
  21357
  21358
  21359
  21360
  21361
  21362
  21363
  21364
  21365
  21366
  21367
  21368
  21369
  21370
  21371
  21372
  21373
  21374
  21375
  21376
  21377
  21378
  21379
  21380
  21381
  21382
  21383
  21384
  21385
  21386
  21387
  21388
  21389
  21390
  21391
  21392
  21393
  21394
  21395
  21396
  21397
  21398
  21399
  21400
  21401
  21402
  21403
  21404
  21405
  21406
  21407
  21408
  21409
  21410
  21411
  21412
  21413
  21414
  21415
  21416
  21417
  21418
  21419
  21420
  21421
  21422
  21423
  21424
  21425
  21426
  21427
  21428
  21429
  21430
  21431
  21432
  21433
  21434
  21435
  21436
  21437
  21438
  21439
  21440
  21441
  21442
  21443
  21444
  21445
  21446
  21447
  21448
  21449
  21450
  21451
  21452
  21453
  21454
  21455
  21456
  21457
  21458
  21459
  21460
  21461
  21462
  21463
  21464
  21465
  21466
  21467
  21468
  21469
  21470
  21471
  21472
  21473
  21474
  21475
  21476
  21477
  21478
  21479
  21480
  21481
  21482
  21483
  21484
  21485
  21486
  21487
  21488
  21489
  21490
  21491
  21492
  21493
  21494
  21495
  21496
  21497
  21498
  21499
  21500
  21501
  21502
  21503
  21504
  21505
  21506
  21507
  21508
  21509
  21510
  21511
  21512
  21513
  21514
  21515
  21516
  21517
  21518
  21519
  21520
  21521
  21522
  21523
  21524
  21525
  21526
  21527
  21528
  21529
  21530
  21531
  21532
  21533
  21534
  21535
  21536
  21537
  21538
  21539
  21540
  21541
  21542
  21543
  21544
  21545
  21546
  21547
  21548
  21549
  21550
  21551
  21552
  21553
  21554
  21555
  21556
  21557
  21558
  21559
  21560
  21561
  21562
  21563
  21564
  21565
  21566
  21567
  21568
  21569
  21570
  21571
  21572
  21573
  21574
  21575
  21576
  21577
  21578
  21579
  21580
  21581
  21582
  21583
  21584
  21585
  21586
  21587
  21588
  21589
  21590
  21591
  21592
  21593
  21594
  21595
  21596
  21597
  21598
  21599
  21600
  21601
  21602
  21603
  21604
  21605
  21606
  21607
  21608
  21609
  21610
  21611
  21612
  21613
  21614
  21615
  21616
  21617
  21618
  21619
  21620
  21621
  21622
  21623
  21624
  21625
  21626
  21627
  21628
  21629
  21630
  21631
  21632
  21633
  21634
  21635
  21636
  21637
  21638
  21639
  21640
  21641
  21642
  21643
  21644
  21645
  21646
  21647
  21648
  21649
  21650
  21651
  21652
  21653
  21654
  21655
  21656
  21657
  21658
  21659
  21660
  21661
  21662
  21663
  21664
  21665
  21666
  21667
  21668
  21669
  21670
  21671
  21672
  21673
  21674
  21675
  21676
  21677
  21678
  21679
  21680
  21681
  21682
  21683
  21684
  21685
  21686
  21687
  21688
  21689
  21690
  21691
  21692
  21693
  21694
  21695
  21696
  21697
  21698
  21699
  21700
  21701
  21702
  21703
  21704
  21705
  21706
  21707
  21708
  21709
  21710
  21711
  21712
  21713
  21714
  21715
  21716
  21717
  21718
  21719
  21720
  21721
  21722
  21723
  21724
  21725
  21726
  21727
  21728
  21729
  21730
  21731
  21732
  21733
  21734
  21735
  21736
  21737
  21738
  21739
  21740
  21741
  21742
  21743
  21744
  21745
  21746
  21747
  21748
  21749
  21750
  21751
  21752
  21753
  21754
  21755
  21756
  21757
  21758
  21759
  21760
  21761
  21762
  21763
  21764
  21765
  21766
  21767
  21768
  21769
  21770
  21771
  21772
  21773
  21774
  21775
  21776
  21777
  21778
  21779
  21780
  21781
  21782
  21783
  21784
  21785
  21786
  21787
  21788
  21789
  21790
  21791
  21792
  21793
  21794
  21795
  21796
  21797
  21798
  21799
  21800
  21801
  21802
  21803
  21804
  21805
  21806
  21807
  21808
  21809
  21810
  21811
  21812
  21813
  21814
  21815
  21816
  21817
  21818
  21819
  21820
  21821
  21822
  21823
  21824
  21825
  21826
  21827
  21828
  21829
  21830
  21831
  21832
  21833
  21834
  21835
  21836
  21837
  21838
  21839
  21840
  21841
  21842
  21843
  21844
  21845
  21846
  21847
  21848
  21849
  21850
  21851
  21852
  21853
  21854
  21855
  21856
  21857
  21858
  21859
  21860
  21861
  21862
  21863
  21864
  21865
  21866
  21867
  21868
  21869
  21870
  21871
  21872
  21873
  21874
  21875
  21876
  21877
  21878
  21879
  21880
  21881
  21882
  21883
  21884
  21885
  21886
  21887
  21888
  21889
  21890
  21891
  21892
  21893
  21894
  21895
  21896
  21897
  21898
  21899
  21900
  21901
  21902
  21903
  21904
  21905
  21906
  21907
  21908
  21909
  21910
  21911
  21912
  21913
  21914
  21915
  21916
  21917
  21918
  21919
  21920
  21921
  21922
  21923
  21924
  21925
  21926
  21927
  21928
  21929
  21930
  21931
  21932
  21933
  21934
  21935
  21936
  21937
  21938
  21939
  21940
  21941
  21942
  21943
  21944
  21945
  21946
  21947
  21948
  21949
  21950
  21951
  21952
  21953
  21954
  21955
  21956
  21957
  21958
  21959
  21960
  21961
  21962
  21963
  21964
  21965
  21966
  21967
  21968
  21969
  21970
  21971
  21972
  21973
  21974
  21975
  21976
  21977
  21978
  21979
  21980
  21981
  21982
  21983
  21984
  21985
  21986
  21987
  21988
  21989
  21990
  21991
  21992
  21993
  21994
  21995
  21996
  21997
  21998
  21999
  22000
  22001
  22002
  22003
  22004
  22005
  22006
  22007
  22008
  22009
  22010
  22011
  22012
  22013
  22014
  22015
  22016
  22017
  22018
  22019
  22020
  22021
  22022
  22023
  22024
  22025
  22026
  22027
  22028
  22029
  22030
  22031
  22032
  22033
  22034
  22035
  22036
  22037
  22038
  22039
  22040
  22041
  22042
  22043
  22044
  22045
  22046
  22047
  22048
  22049
  22050
  22051
  22052
  22053
  22054
  22055
  22056
  22057
  22058
  22059
  22060
  22061
  22062
  22063
  22064
  22065
  22066
  22067
  22068
  22069
  22070
  22071
  22072
  22073
  22074
  22075
  22076
  22077
  22078
  22079
  22080
  22081
  22082
  22083
  22084
  22085
  22086
  22087
  22088
  22089
  22090
  22091
  22092
  22093
  22094
  22095
  22096
  22097
  22098
  22099
  22100
  22101
  22102
  22103
  22104
  22105
  22106
  22107
  22108
  22109
  22110
  22111
  22112
  22113
  22114
  22115
  22116
  22117
  22118
  22119
  22120
  22121
  22122
  22123
  22124
  22125
  22126
  22127
  22128
  22129
  22130
  22131
  22132
  22133
  22134
  22135
  22136
  22137
  22138
  22139
  22140
  22141
  22142
  22143
  22144
  22145
  22146
  22147
  22148
  22149
  22150
  22151
  22152
  22153
  22154
  22155
  22156
  22157
  22158
  22159
  22160
  22161
  22162
  22163
  22164
  22165
  22166
  22167
  22168
  22169
  22170
  22171
  22172
  22173
  22174
  22175
  22176
  22177
  22178
  22179
  22180
  22181
  22182
  22183
  22184
  22185
  22186
  22187
  22188
  22189
  22190
  22191
  22192
  22193
  22194
  22195
  22196
  22197
  22198
  22199
  22200
  22201
  22202
  22203
  22204
  22205
  22206
  22207
  22208
  22209
  22210
  22211
  22212
  22213
  22214
  22215
  22216
  22217
  22218
  22219
  22220
  22221
  22222
  22223
  22224
  22225
  22226
  22227
  22228
  22229
  22230
  22231
  22232
  22233
  22234
  22235
  22236
  22237
  22238
  22239
  22240
  22241
  22242
  22243
  22244
  22245
  22246
  22247
  22248
  22249
  22250
  22251
  22252
  22253
  22254
  22255
  22256
  22257
  22258
  22259
  22260
  22261
  22262
  22263
  22264
  22265
  22266
  22267
  22268
  22269
  22270
  22271
  22272
  22273
  22274
  22275
  22276
  22277
  22278
  22279
  22280
  22281
  22282
  22283
  22284
  22285
  22286
  22287
  22288
  22289
  22290
  22291
  22292
  22293
  22294
  22295
  22296
  22297
  22298
  22299
  22300
  22301
  22302
  22303
  22304
  22305
  22306
  22307
  22308
  22309
  22310
  22311
  22312
  22313
  22314
  22315
  22316
  22317
  22318
  22319
  22320
  22321
  22322
  22323
  22324
  22325
  22326
  22327
  22328
  22329
  22330
  22331
  22332
  22333
  22334
  22335
  22336
  22337
  22338
  22339
  22340
  22341
  22342
  22343
  22344
  22345
  22346
  22347
  22348
  22349
  22350
  22351
  22352
  22353
  22354
  22355
  22356
  22357
  22358
  22359
  22360
  22361
  22362
  22363
  22364
]
9 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.model AS model_4, t0.size AS size_5, t0.glass AS glass_6, t0.price AS price_7, t0.ean AS ean_8, t0.volume AS volume_9, t0.width AS width_10, t0.depth AS depth_11, t0.height AS height_12, t0.weight AS weight_13, t0.package_weight AS package_weight_14, t0.delivery AS delivery_15 FROM app_product t0 WHERE t0.id = ?
Parameters:
[
  20341
]
10 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.background AS background_4, t0.text_color AS text_color_5, t0.active AS active_6 FROM app_ribbon t0 WHERE t0.active = ?
Parameters:
[
  1
]
11 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.background AS background_4, t0.text_color AS text_color_5, t0.active AS active_6 FROM app_ribbon t0 WHERE t0.active = ?
Parameters:
[
  1
]
12 6.80 ms
SELECT p0_.webspaceKey AS webspaceKey_0, p0_.lft AS lft_1, p0_.rgt AS rgt_2, p0_.depth AS depth_3, p0_.uuid AS uuid_4, p0_.created AS created_5, p0_.changed AS changed_6, p1_.title AS title_7, p1_.id AS id_8, p1_.stage AS stage_9, p1_.locale AS locale_10, p1_.ghostLocale AS ghostLocale_11, p1_.availableLocales AS availableLocales_12, p1_.version AS version_13, p1_.shadowLocale AS shadowLocale_14, p1_.shadowLocales AS shadowLocales_15, p1_.templateKey AS templateKey_16, p1_.templateData AS templateData_17, p1_.seoData AS seoData_18, p1_.seoNoIndex AS seoNoIndex_19, p1_.seoNoFollow AS seoNoFollow_20, p1_.seoHideInSitemap AS seoHideInSitemap_21, p1_.excerptData AS excerptData_22, p1_.excerptSegment AS excerptSegment_23, p1_.authored AS authored_24, p1_.lastModified AS lastModified_25, p1_.workflowPlace AS workflowPlace_26, p1_.workflowPublished AS workflowPublished_27, p1_.linkProvider AS linkProvider_28, p1_.linkData AS linkData_29, p1_.created AS created_30, p1_.changed AS changed_31, t2_.name AS name_32, t2_.id AS id_33, t2_.created AS created_34, t2_.changed AS changed_35, c3_.category_key AS category_key_36, c3_.default_locale AS default_locale_37, c3_.lft AS lft_38, c3_.rgt AS rgt_39, c3_.depth AS depth_40, c3_.id AS id_41, c3_.created AS created_42, c3_.changed AS changed_43, c4_.translation AS translation_44, c4_.locale AS locale_45, c4_.description AS description_46, c4_.id AS id_47, c4_.created AS created_48, c4_.changed AS changed_49, r5_.webspace AS webspace_50, r5_.locale AS locale_51, r5_.slug AS slug_52, r5_.resource_key AS resource_key_53, r5_.resource_id AS resource_id_54, r5_.id AS id_55, p6_.name AS name_56, p6_.id AS id_57, p0_.parent_id AS parent_id_58, p0_.idUsersCreator AS idUsersCreator_59, p0_.idUsersChanger AS idUsersChanger_60, p1_.route_id AS route_id_61, p1_.pageUuid AS pageUuid_62, p1_.author_id AS author_id_63, p1_.idUsersCreator AS idUsersCreator_64, p1_.idUsersChanger AS idUsersChanger_65, t2_.idUsersCreator AS idUsersCreator_66, t2_.idUsersChanger AS idUsersChanger_67, c3_.idCategoriesParent AS idCategoriesParent_68, c3_.idUsersCreator AS idUsersCreator_69, c3_.idUsersChanger AS idUsersChanger_70, c4_.idCategories AS idCategories_71, c4_.idUsersCreator AS idUsersCreator_72, c4_.idUsersChanger AS idUsersChanger_73, r5_.parent_id AS parent_id_74, p6_.page_dimension_content_id AS page_dimension_content_id_75 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p7_ ON (p7_.pageUuid = p0_.uuid) LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid LEFT JOIN pa_page_dimension_content_excerpt_tags p8_ ON p1_.id = p8_.page_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = p8_.tag_id LEFT JOIN pa_page_dimension_content_excerpt_categories p9_ ON p1_.id = p9_.page_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = p9_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories AND (c4_.locale = c3_.default_locale OR c4_.locale IN (?)) LEFT JOIN ro_routes r5_ ON p1_.route_id = r5_.id LEFT JOIN pa_page_dimension_content_navigation_contexts p6_ ON p1_.id = p6_.page_dimension_content_id LEFT JOIN pa_page_dimension_content_navigation_contexts p10_ ON p7_.id = p10_.page_dimension_content_id WHERE p0_.webspaceKey = ? AND p0_.depth <= ? AND p7_.locale = ? AND p7_.stage = ? AND p7_.version = ? AND (((p1_.locale IS NULL OR p1_.locale IN (?)) AND (p1_.stage IS NULL OR p1_.stage IN (?))) AND (p1_.version IS NULL OR p1_.version IN (?))) AND p10_.name IN (?) ORDER BY p0_.lft ASC
Parameters:
[
  "hr"
  "pakom"
  15
  "hr"
  "live"
  0
  "hr"
  "live"
  0
  "shop"
]
13 1.95 ms
SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.style AS style_4, m1_.lft AS lft_5, m1_.rgt AS rgt_6, m1_.depth AS depth_7, m1_.collection_key AS collection_key_8, m1_.id AS id_9, m1_.created AS created_10, m1_.changed AS changed_11, m2_.version AS version_12, m2_.id AS id_13, m2_.created AS created_14, m2_.changed AS changed_15, m3_.name AS name_16, m3_.version AS version_17, m3_.subVersion AS subVersion_18, m3_.size AS size_19, m3_.downloadCounter AS downloadCounter_20, m3_.storageOptions AS storageOptions_21, m3_.mimeType AS mimeType_22, m3_.properties AS properties_23, m3_.focusPointX AS focusPointX_24, m3_.focusPointY AS focusPointY_25, m3_.origin AS origin_26, m3_.aiDisclosureDisabled AS aiDisclosureDisabled_27, m3_.aiDisclosureIconVariant AS aiDisclosureIconVariant_28, m3_.id AS id_29, m3_.created AS created_30, m3_.changed AS changed_31, t4_.name AS name_32, t4_.id AS id_33, t4_.created AS created_34, t4_.changed AS changed_35, m5_.title AS title_36, m5_.description AS description_37, m5_.aiDisclosureText AS aiDisclosureText_38, m5_.copyright AS copyright_39, m5_.credits AS credits_40, m5_.locale AS locale_41, m5_.id AS id_42, m6_.title AS title_43, m6_.description AS description_44, m6_.aiDisclosureText AS aiDisclosureText_45, m6_.copyright AS copyright_46, m6_.credits AS credits_47, m6_.locale AS locale_48, m6_.id AS id_49, s7_.username AS username_50, s7_.password AS password_51, s7_.locale AS locale_52, s7_.salt AS salt_53, s7_.locked AS locked_54, s7_.enabled AS enabled_55, s7_.lastLogin AS lastLogin_56, s7_.confirmationKey AS confirmationKey_57, s7_.passwordResetToken AS passwordResetToken_58, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_59, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_60, s7_.privateKey AS privateKey_61, s7_.apiKey AS apiKey_62, s7_.email AS email_63, s7_.id AS id_64, s7_.created AS created_65, s7_.changed AS changed_66, s7_.tracking AS tracking_67, s7_.buying_and_selling AS buying_and_selling_68, s7_.delivery AS delivery_69, s7_.marketing AS marketing_70, c8_.firstName AS firstName_71, c8_.middleName AS middleName_72, c8_.lastName AS lastName_73, c8_.birthday AS birthday_74, c8_.salutation AS salutation_75, c8_.formOfAddress AS formOfAddress_76, c8_.newsletter AS newsletter_77, c8_.gender AS gender_78, c8_.note AS note_79, c8_.mainEmail AS mainEmail_80, c8_.mainPhone AS mainPhone_81, c8_.mainFax AS mainFax_82, c8_.mainUrl AS mainUrl_83, c8_.id AS id_84, c8_.created AS created_85, c8_.changed AS changed_86, s9_.username AS username_87, s9_.password AS password_88, s9_.locale AS locale_89, s9_.salt AS salt_90, s9_.locked AS locked_91, s9_.enabled AS enabled_92, s9_.lastLogin AS lastLogin_93, s9_.confirmationKey AS confirmationKey_94, s9_.passwordResetToken AS passwordResetToken_95, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_96, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_97, s9_.privateKey AS privateKey_98, s9_.apiKey AS apiKey_99, s9_.email AS email_100, s9_.id AS id_101, s9_.created AS created_102, s9_.changed AS changed_103, s9_.tracking AS tracking_104, s9_.buying_and_selling AS buying_and_selling_105, s9_.delivery AS delivery_106, s9_.marketing AS marketing_107, c10_.firstName AS firstName_108, c10_.middleName AS middleName_109, c10_.lastName AS lastName_110, c10_.birthday AS birthday_111, c10_.salutation AS salutation_112, c10_.formOfAddress AS formOfAddress_113, c10_.newsletter AS newsletter_114, c10_.gender AS gender_115, c10_.note AS note_116, c10_.mainEmail AS mainEmail_117, c10_.mainPhone AS mainPhone_118, c10_.mainFax AS mainFax_119, c10_.mainUrl AS mainUrl_120, c10_.id AS id_121, c10_.created AS created_122, c10_.changed AS changed_123, m0_.idPreviewImage AS idPreviewImage_124, m0_.idCollections AS idCollections_125, m0_.idUsersCreator AS idUsersCreator_126, m0_.idUsersChanger AS idUsersChanger_127, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_128, m1_.idCollectionTypes AS idCollectionTypes_129, m1_.idCollectionsParent AS idCollectionsParent_130, m1_.idUsersCreator AS idUsersCreator_131, m1_.idUsersChanger AS idUsersChanger_132, m2_.idMedia AS idMedia_133, m2_.idUsersCreator AS idUsersCreator_134, m2_.idUsersChanger AS idUsersChanger_135, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_136, m3_.idFiles AS idFiles_137, m3_.idUsersCreator AS idUsersCreator_138, m3_.idUsersChanger AS idUsersChanger_139, t4_.idUsersCreator AS idUsersCreator_140, t4_.idUsersChanger AS idUsersChanger_141, m5_.idFileVersions AS idFileVersions_142, m6_.idFileVersions AS idFileVersions_143, s7_.idUsersCreator AS idUsersCreator_144, s7_.idUsersChanger AS idUsersChanger_145, s7_.cart_id AS cart_id_146, s7_.idContacts AS idContacts_147, c8_.idTitles AS idTitles_148, c8_.avatar AS avatar_149, c8_.idUsersCreator AS idUsersCreator_150, c8_.idUsersChanger AS idUsersChanger_151, s9_.idUsersCreator AS idUsersCreator_152, s9_.idUsersChanger AS idUsersChanger_153, s9_.cart_id AS cart_id_154, s9_.idContacts AS idContacts_155, c10_.idTitles AS idTitles_156, c10_.avatar AS avatar_157, c10_.idUsersCreator AS idUsersCreator_158, c10_.idUsersChanger AS idUsersChanger_159 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id INNER JOIN me_files m2_ ON m0_.id = m2_.idMedia INNER JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles AND (m3_.version = m2_.version) LEFT JOIN me_file_version_tags m11_ ON m3_.id = m11_.idFileVersions LEFT JOIN ta_tags t4_ ON t4_.id = m11_.idTags LEFT JOIN me_file_version_meta m5_ ON m3_.id = m5_.idFileVersions LEFT JOIN me_file_version_meta m6_ ON m3_.idFileVersionsMetaDefault = m6_.id LEFT JOIN se_users s7_ ON m0_.idUsersCreator = s7_.id LEFT JOIN co_contacts c8_ ON s7_.idContacts = c8_.id LEFT JOIN se_users s9_ ON m0_.idUsersChanger = s9_.id LEFT JOIN co_contacts c10_ ON s9_.idContacts = c10_.id WHERE m0_.id IN (?) ORDER BY m0_.id ASC
Parameters:
[
  12
]
14 0.36 ms
SELECT t0.method AS method_1, t0.options AS options_2, t0.id AS id_3, t0.idUsers AS idUsers_4 FROM se_user_two_factors t0 WHERE t0.idUsers = ?
Parameters:
[
  1
]
15 1.81 ms
SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.style AS style_4, m1_.lft AS lft_5, m1_.rgt AS rgt_6, m1_.depth AS depth_7, m1_.collection_key AS collection_key_8, m1_.id AS id_9, m1_.created AS created_10, m1_.changed AS changed_11, m2_.version AS version_12, m2_.id AS id_13, m2_.created AS created_14, m2_.changed AS changed_15, m3_.name AS name_16, m3_.version AS version_17, m3_.subVersion AS subVersion_18, m3_.size AS size_19, m3_.downloadCounter AS downloadCounter_20, m3_.storageOptions AS storageOptions_21, m3_.mimeType AS mimeType_22, m3_.properties AS properties_23, m3_.focusPointX AS focusPointX_24, m3_.focusPointY AS focusPointY_25, m3_.origin AS origin_26, m3_.aiDisclosureDisabled AS aiDisclosureDisabled_27, m3_.aiDisclosureIconVariant AS aiDisclosureIconVariant_28, m3_.id AS id_29, m3_.created AS created_30, m3_.changed AS changed_31, t4_.name AS name_32, t4_.id AS id_33, t4_.created AS created_34, t4_.changed AS changed_35, m5_.title AS title_36, m5_.description AS description_37, m5_.aiDisclosureText AS aiDisclosureText_38, m5_.copyright AS copyright_39, m5_.credits AS credits_40, m5_.locale AS locale_41, m5_.id AS id_42, m6_.title AS title_43, m6_.description AS description_44, m6_.aiDisclosureText AS aiDisclosureText_45, m6_.copyright AS copyright_46, m6_.credits AS credits_47, m6_.locale AS locale_48, m6_.id AS id_49, s7_.username AS username_50, s7_.password AS password_51, s7_.locale AS locale_52, s7_.salt AS salt_53, s7_.locked AS locked_54, s7_.enabled AS enabled_55, s7_.lastLogin AS lastLogin_56, s7_.confirmationKey AS confirmationKey_57, s7_.passwordResetToken AS passwordResetToken_58, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_59, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_60, s7_.privateKey AS privateKey_61, s7_.apiKey AS apiKey_62, s7_.email AS email_63, s7_.id AS id_64, s7_.created AS created_65, s7_.changed AS changed_66, s7_.tracking AS tracking_67, s7_.buying_and_selling AS buying_and_selling_68, s7_.delivery AS delivery_69, s7_.marketing AS marketing_70, c8_.firstName AS firstName_71, c8_.middleName AS middleName_72, c8_.lastName AS lastName_73, c8_.birthday AS birthday_74, c8_.salutation AS salutation_75, c8_.formOfAddress AS formOfAddress_76, c8_.newsletter AS newsletter_77, c8_.gender AS gender_78, c8_.note AS note_79, c8_.mainEmail AS mainEmail_80, c8_.mainPhone AS mainPhone_81, c8_.mainFax AS mainFax_82, c8_.mainUrl AS mainUrl_83, c8_.id AS id_84, c8_.created AS created_85, c8_.changed AS changed_86, s9_.username AS username_87, s9_.password AS password_88, s9_.locale AS locale_89, s9_.salt AS salt_90, s9_.locked AS locked_91, s9_.enabled AS enabled_92, s9_.lastLogin AS lastLogin_93, s9_.confirmationKey AS confirmationKey_94, s9_.passwordResetToken AS passwordResetToken_95, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_96, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_97, s9_.privateKey AS privateKey_98, s9_.apiKey AS apiKey_99, s9_.email AS email_100, s9_.id AS id_101, s9_.created AS created_102, s9_.changed AS changed_103, s9_.tracking AS tracking_104, s9_.buying_and_selling AS buying_and_selling_105, s9_.delivery AS delivery_106, s9_.marketing AS marketing_107, c10_.firstName AS firstName_108, c10_.middleName AS middleName_109, c10_.lastName AS lastName_110, c10_.birthday AS birthday_111, c10_.salutation AS salutation_112, c10_.formOfAddress AS formOfAddress_113, c10_.newsletter AS newsletter_114, c10_.gender AS gender_115, c10_.note AS note_116, c10_.mainEmail AS mainEmail_117, c10_.mainPhone AS mainPhone_118, c10_.mainFax AS mainFax_119, c10_.mainUrl AS mainUrl_120, c10_.id AS id_121, c10_.created AS created_122, c10_.changed AS changed_123, m0_.idPreviewImage AS idPreviewImage_124, m0_.idCollections AS idCollections_125, m0_.idUsersCreator AS idUsersCreator_126, m0_.idUsersChanger AS idUsersChanger_127, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_128, m1_.idCollectionTypes AS idCollectionTypes_129, m1_.idCollectionsParent AS idCollectionsParent_130, m1_.idUsersCreator AS idUsersCreator_131, m1_.idUsersChanger AS idUsersChanger_132, m2_.idMedia AS idMedia_133, m2_.idUsersCreator AS idUsersCreator_134, m2_.idUsersChanger AS idUsersChanger_135, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_136, m3_.idFiles AS idFiles_137, m3_.idUsersCreator AS idUsersCreator_138, m3_.idUsersChanger AS idUsersChanger_139, t4_.idUsersCreator AS idUsersCreator_140, t4_.idUsersChanger AS idUsersChanger_141, m5_.idFileVersions AS idFileVersions_142, m6_.idFileVersions AS idFileVersions_143, s7_.idUsersCreator AS idUsersCreator_144, s7_.idUsersChanger AS idUsersChanger_145, s7_.cart_id AS cart_id_146, s7_.idContacts AS idContacts_147, c8_.idTitles AS idTitles_148, c8_.avatar AS avatar_149, c8_.idUsersCreator AS idUsersCreator_150, c8_.idUsersChanger AS idUsersChanger_151, s9_.idUsersCreator AS idUsersCreator_152, s9_.idUsersChanger AS idUsersChanger_153, s9_.cart_id AS cart_id_154, s9_.idContacts AS idContacts_155, c10_.idTitles AS idTitles_156, c10_.avatar AS avatar_157, c10_.idUsersCreator AS idUsersCreator_158, c10_.idUsersChanger AS idUsersChanger_159 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id INNER JOIN me_files m2_ ON m0_.id = m2_.idMedia INNER JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles AND (m3_.version = m2_.version) LEFT JOIN me_file_version_tags m11_ ON m3_.id = m11_.idFileVersions LEFT JOIN ta_tags t4_ ON t4_.id = m11_.idTags LEFT JOIN me_file_version_meta m5_ ON m3_.id = m5_.idFileVersions LEFT JOIN me_file_version_meta m6_ ON m3_.idFileVersionsMetaDefault = m6_.id LEFT JOIN se_users s7_ ON m0_.idUsersCreator = s7_.id LEFT JOIN co_contacts c8_ ON s7_.idContacts = c8_.id LEFT JOIN se_users s9_ ON m0_.idUsersChanger = s9_.id LEFT JOIN co_contacts c10_ ON s9_.idContacts = c10_.id WHERE m0_.id IN (?) ORDER BY m0_.id ASC
Parameters:
[
  14
]
16 1.73 ms
SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.style AS style_4, m1_.lft AS lft_5, m1_.rgt AS rgt_6, m1_.depth AS depth_7, m1_.collection_key AS collection_key_8, m1_.id AS id_9, m1_.created AS created_10, m1_.changed AS changed_11, m2_.version AS version_12, m2_.id AS id_13, m2_.created AS created_14, m2_.changed AS changed_15, m3_.name AS name_16, m3_.version AS version_17, m3_.subVersion AS subVersion_18, m3_.size AS size_19, m3_.downloadCounter AS downloadCounter_20, m3_.storageOptions AS storageOptions_21, m3_.mimeType AS mimeType_22, m3_.properties AS properties_23, m3_.focusPointX AS focusPointX_24, m3_.focusPointY AS focusPointY_25, m3_.origin AS origin_26, m3_.aiDisclosureDisabled AS aiDisclosureDisabled_27, m3_.aiDisclosureIconVariant AS aiDisclosureIconVariant_28, m3_.id AS id_29, m3_.created AS created_30, m3_.changed AS changed_31, t4_.name AS name_32, t4_.id AS id_33, t4_.created AS created_34, t4_.changed AS changed_35, m5_.title AS title_36, m5_.description AS description_37, m5_.aiDisclosureText AS aiDisclosureText_38, m5_.copyright AS copyright_39, m5_.credits AS credits_40, m5_.locale AS locale_41, m5_.id AS id_42, m6_.title AS title_43, m6_.description AS description_44, m6_.aiDisclosureText AS aiDisclosureText_45, m6_.copyright AS copyright_46, m6_.credits AS credits_47, m6_.locale AS locale_48, m6_.id AS id_49, s7_.username AS username_50, s7_.password AS password_51, s7_.locale AS locale_52, s7_.salt AS salt_53, s7_.locked AS locked_54, s7_.enabled AS enabled_55, s7_.lastLogin AS lastLogin_56, s7_.confirmationKey AS confirmationKey_57, s7_.passwordResetToken AS passwordResetToken_58, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_59, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_60, s7_.privateKey AS privateKey_61, s7_.apiKey AS apiKey_62, s7_.email AS email_63, s7_.id AS id_64, s7_.created AS created_65, s7_.changed AS changed_66, s7_.tracking AS tracking_67, s7_.buying_and_selling AS buying_and_selling_68, s7_.delivery AS delivery_69, s7_.marketing AS marketing_70, c8_.firstName AS firstName_71, c8_.middleName AS middleName_72, c8_.lastName AS lastName_73, c8_.birthday AS birthday_74, c8_.salutation AS salutation_75, c8_.formOfAddress AS formOfAddress_76, c8_.newsletter AS newsletter_77, c8_.gender AS gender_78, c8_.note AS note_79, c8_.mainEmail AS mainEmail_80, c8_.mainPhone AS mainPhone_81, c8_.mainFax AS mainFax_82, c8_.mainUrl AS mainUrl_83, c8_.id AS id_84, c8_.created AS created_85, c8_.changed AS changed_86, s9_.username AS username_87, s9_.password AS password_88, s9_.locale AS locale_89, s9_.salt AS salt_90, s9_.locked AS locked_91, s9_.enabled AS enabled_92, s9_.lastLogin AS lastLogin_93, s9_.confirmationKey AS confirmationKey_94, s9_.passwordResetToken AS passwordResetToken_95, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_96, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_97, s9_.privateKey AS privateKey_98, s9_.apiKey AS apiKey_99, s9_.email AS email_100, s9_.id AS id_101, s9_.created AS created_102, s9_.changed AS changed_103, s9_.tracking AS tracking_104, s9_.buying_and_selling AS buying_and_selling_105, s9_.delivery AS delivery_106, s9_.marketing AS marketing_107, c10_.firstName AS firstName_108, c10_.middleName AS middleName_109, c10_.lastName AS lastName_110, c10_.birthday AS birthday_111, c10_.salutation AS salutation_112, c10_.formOfAddress AS formOfAddress_113, c10_.newsletter AS newsletter_114, c10_.gender AS gender_115, c10_.note AS note_116, c10_.mainEmail AS mainEmail_117, c10_.mainPhone AS mainPhone_118, c10_.mainFax AS mainFax_119, c10_.mainUrl AS mainUrl_120, c10_.id AS id_121, c10_.created AS created_122, c10_.changed AS changed_123, m0_.idPreviewImage AS idPreviewImage_124, m0_.idCollections AS idCollections_125, m0_.idUsersCreator AS idUsersCreator_126, m0_.idUsersChanger AS idUsersChanger_127, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_128, m1_.idCollectionTypes AS idCollectionTypes_129, m1_.idCollectionsParent AS idCollectionsParent_130, m1_.idUsersCreator AS idUsersCreator_131, m1_.idUsersChanger AS idUsersChanger_132, m2_.idMedia AS idMedia_133, m2_.idUsersCreator AS idUsersCreator_134, m2_.idUsersChanger AS idUsersChanger_135, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_136, m3_.idFiles AS idFiles_137, m3_.idUsersCreator AS idUsersCreator_138, m3_.idUsersChanger AS idUsersChanger_139, t4_.idUsersCreator AS idUsersCreator_140, t4_.idUsersChanger AS idUsersChanger_141, m5_.idFileVersions AS idFileVersions_142, m6_.idFileVersions AS idFileVersions_143, s7_.idUsersCreator AS idUsersCreator_144, s7_.idUsersChanger AS idUsersChanger_145, s7_.cart_id AS cart_id_146, s7_.idContacts AS idContacts_147, c8_.idTitles AS idTitles_148, c8_.avatar AS avatar_149, c8_.idUsersCreator AS idUsersCreator_150, c8_.idUsersChanger AS idUsersChanger_151, s9_.idUsersCreator AS idUsersCreator_152, s9_.idUsersChanger AS idUsersChanger_153, s9_.cart_id AS cart_id_154, s9_.idContacts AS idContacts_155, c10_.idTitles AS idTitles_156, c10_.avatar AS avatar_157, c10_.idUsersCreator AS idUsersCreator_158, c10_.idUsersChanger AS idUsersChanger_159 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id INNER JOIN me_files m2_ ON m0_.id = m2_.idMedia INNER JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles AND (m3_.version = m2_.version) LEFT JOIN me_file_version_tags m11_ ON m3_.id = m11_.idFileVersions LEFT JOIN ta_tags t4_ ON t4_.id = m11_.idTags LEFT JOIN me_file_version_meta m5_ ON m3_.id = m5_.idFileVersions LEFT JOIN me_file_version_meta m6_ ON m3_.idFileVersionsMetaDefault = m6_.id LEFT JOIN se_users s7_ ON m0_.idUsersCreator = s7_.id LEFT JOIN co_contacts c8_ ON s7_.idContacts = c8_.id LEFT JOIN se_users s9_ ON m0_.idUsersChanger = s9_.id LEFT JOIN co_contacts c10_ ON s9_.idContacts = c10_.id WHERE m0_.id IN (?) ORDER BY m0_.id ASC
Parameters:
[
  11
]
17 1.71 ms
SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.style AS style_4, m1_.lft AS lft_5, m1_.rgt AS rgt_6, m1_.depth AS depth_7, m1_.collection_key AS collection_key_8, m1_.id AS id_9, m1_.created AS created_10, m1_.changed AS changed_11, m2_.version AS version_12, m2_.id AS id_13, m2_.created AS created_14, m2_.changed AS changed_15, m3_.name AS name_16, m3_.version AS version_17, m3_.subVersion AS subVersion_18, m3_.size AS size_19, m3_.downloadCounter AS downloadCounter_20, m3_.storageOptions AS storageOptions_21, m3_.mimeType AS mimeType_22, m3_.properties AS properties_23, m3_.focusPointX AS focusPointX_24, m3_.focusPointY AS focusPointY_25, m3_.origin AS origin_26, m3_.aiDisclosureDisabled AS aiDisclosureDisabled_27, m3_.aiDisclosureIconVariant AS aiDisclosureIconVariant_28, m3_.id AS id_29, m3_.created AS created_30, m3_.changed AS changed_31, t4_.name AS name_32, t4_.id AS id_33, t4_.created AS created_34, t4_.changed AS changed_35, m5_.title AS title_36, m5_.description AS description_37, m5_.aiDisclosureText AS aiDisclosureText_38, m5_.copyright AS copyright_39, m5_.credits AS credits_40, m5_.locale AS locale_41, m5_.id AS id_42, m6_.title AS title_43, m6_.description AS description_44, m6_.aiDisclosureText AS aiDisclosureText_45, m6_.copyright AS copyright_46, m6_.credits AS credits_47, m6_.locale AS locale_48, m6_.id AS id_49, s7_.username AS username_50, s7_.password AS password_51, s7_.locale AS locale_52, s7_.salt AS salt_53, s7_.locked AS locked_54, s7_.enabled AS enabled_55, s7_.lastLogin AS lastLogin_56, s7_.confirmationKey AS confirmationKey_57, s7_.passwordResetToken AS passwordResetToken_58, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_59, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_60, s7_.privateKey AS privateKey_61, s7_.apiKey AS apiKey_62, s7_.email AS email_63, s7_.id AS id_64, s7_.created AS created_65, s7_.changed AS changed_66, s7_.tracking AS tracking_67, s7_.buying_and_selling AS buying_and_selling_68, s7_.delivery AS delivery_69, s7_.marketing AS marketing_70, c8_.firstName AS firstName_71, c8_.middleName AS middleName_72, c8_.lastName AS lastName_73, c8_.birthday AS birthday_74, c8_.salutation AS salutation_75, c8_.formOfAddress AS formOfAddress_76, c8_.newsletter AS newsletter_77, c8_.gender AS gender_78, c8_.note AS note_79, c8_.mainEmail AS mainEmail_80, c8_.mainPhone AS mainPhone_81, c8_.mainFax AS mainFax_82, c8_.mainUrl AS mainUrl_83, c8_.id AS id_84, c8_.created AS created_85, c8_.changed AS changed_86, s9_.username AS username_87, s9_.password AS password_88, s9_.locale AS locale_89, s9_.salt AS salt_90, s9_.locked AS locked_91, s9_.enabled AS enabled_92, s9_.lastLogin AS lastLogin_93, s9_.confirmationKey AS confirmationKey_94, s9_.passwordResetToken AS passwordResetToken_95, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_96, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_97, s9_.privateKey AS privateKey_98, s9_.apiKey AS apiKey_99, s9_.email AS email_100, s9_.id AS id_101, s9_.created AS created_102, s9_.changed AS changed_103, s9_.tracking AS tracking_104, s9_.buying_and_selling AS buying_and_selling_105, s9_.delivery AS delivery_106, s9_.marketing AS marketing_107, c10_.firstName AS firstName_108, c10_.middleName AS middleName_109, c10_.lastName AS lastName_110, c10_.birthday AS birthday_111, c10_.salutation AS salutation_112, c10_.formOfAddress AS formOfAddress_113, c10_.newsletter AS newsletter_114, c10_.gender AS gender_115, c10_.note AS note_116, c10_.mainEmail AS mainEmail_117, c10_.mainPhone AS mainPhone_118, c10_.mainFax AS mainFax_119, c10_.mainUrl AS mainUrl_120, c10_.id AS id_121, c10_.created AS created_122, c10_.changed AS changed_123, m0_.idPreviewImage AS idPreviewImage_124, m0_.idCollections AS idCollections_125, m0_.idUsersCreator AS idUsersCreator_126, m0_.idUsersChanger AS idUsersChanger_127, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_128, m1_.idCollectionTypes AS idCollectionTypes_129, m1_.idCollectionsParent AS idCollectionsParent_130, m1_.idUsersCreator AS idUsersCreator_131, m1_.idUsersChanger AS idUsersChanger_132, m2_.idMedia AS idMedia_133, m2_.idUsersCreator AS idUsersCreator_134, m2_.idUsersChanger AS idUsersChanger_135, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_136, m3_.idFiles AS idFiles_137, m3_.idUsersCreator AS idUsersCreator_138, m3_.idUsersChanger AS idUsersChanger_139, t4_.idUsersCreator AS idUsersCreator_140, t4_.idUsersChanger AS idUsersChanger_141, m5_.idFileVersions AS idFileVersions_142, m6_.idFileVersions AS idFileVersions_143, s7_.idUsersCreator AS idUsersCreator_144, s7_.idUsersChanger AS idUsersChanger_145, s7_.cart_id AS cart_id_146, s7_.idContacts AS idContacts_147, c8_.idTitles AS idTitles_148, c8_.avatar AS avatar_149, c8_.idUsersCreator AS idUsersCreator_150, c8_.idUsersChanger AS idUsersChanger_151, s9_.idUsersCreator AS idUsersCreator_152, s9_.idUsersChanger AS idUsersChanger_153, s9_.cart_id AS cart_id_154, s9_.idContacts AS idContacts_155, c10_.idTitles AS idTitles_156, c10_.avatar AS avatar_157, c10_.idUsersCreator AS idUsersCreator_158, c10_.idUsersChanger AS idUsersChanger_159 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id INNER JOIN me_files m2_ ON m0_.id = m2_.idMedia INNER JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles AND (m3_.version = m2_.version) LEFT JOIN me_file_version_tags m11_ ON m3_.id = m11_.idFileVersions LEFT JOIN ta_tags t4_ ON t4_.id = m11_.idTags LEFT JOIN me_file_version_meta m5_ ON m3_.id = m5_.idFileVersions LEFT JOIN me_file_version_meta m6_ ON m3_.idFileVersionsMetaDefault = m6_.id LEFT JOIN se_users s7_ ON m0_.idUsersCreator = s7_.id LEFT JOIN co_contacts c8_ ON s7_.idContacts = c8_.id LEFT JOIN se_users s9_ ON m0_.idUsersChanger = s9_.id LEFT JOIN co_contacts c10_ ON s9_.idContacts = c10_.id WHERE m0_.id IN (?) ORDER BY m0_.id ASC
Parameters:
[
  16
]
18 1.51 ms
SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.style AS style_4, m1_.lft AS lft_5, m1_.rgt AS rgt_6, m1_.depth AS depth_7, m1_.collection_key AS collection_key_8, m1_.id AS id_9, m1_.created AS created_10, m1_.changed AS changed_11, m2_.version AS version_12, m2_.id AS id_13, m2_.created AS created_14, m2_.changed AS changed_15, m3_.name AS name_16, m3_.version AS version_17, m3_.subVersion AS subVersion_18, m3_.size AS size_19, m3_.downloadCounter AS downloadCounter_20, m3_.storageOptions AS storageOptions_21, m3_.mimeType AS mimeType_22, m3_.properties AS properties_23, m3_.focusPointX AS focusPointX_24, m3_.focusPointY AS focusPointY_25, m3_.origin AS origin_26, m3_.aiDisclosureDisabled AS aiDisclosureDisabled_27, m3_.aiDisclosureIconVariant AS aiDisclosureIconVariant_28, m3_.id AS id_29, m3_.created AS created_30, m3_.changed AS changed_31, t4_.name AS name_32, t4_.id AS id_33, t4_.created AS created_34, t4_.changed AS changed_35, m5_.title AS title_36, m5_.description AS description_37, m5_.aiDisclosureText AS aiDisclosureText_38, m5_.copyright AS copyright_39, m5_.credits AS credits_40, m5_.locale AS locale_41, m5_.id AS id_42, m6_.title AS title_43, m6_.description AS description_44, m6_.aiDisclosureText AS aiDisclosureText_45, m6_.copyright AS copyright_46, m6_.credits AS credits_47, m6_.locale AS locale_48, m6_.id AS id_49, s7_.username AS username_50, s7_.password AS password_51, s7_.locale AS locale_52, s7_.salt AS salt_53, s7_.locked AS locked_54, s7_.enabled AS enabled_55, s7_.lastLogin AS lastLogin_56, s7_.confirmationKey AS confirmationKey_57, s7_.passwordResetToken AS passwordResetToken_58, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_59, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_60, s7_.privateKey AS privateKey_61, s7_.apiKey AS apiKey_62, s7_.email AS email_63, s7_.id AS id_64, s7_.created AS created_65, s7_.changed AS changed_66, s7_.tracking AS tracking_67, s7_.buying_and_selling AS buying_and_selling_68, s7_.delivery AS delivery_69, s7_.marketing AS marketing_70, c8_.firstName AS firstName_71, c8_.middleName AS middleName_72, c8_.lastName AS lastName_73, c8_.birthday AS birthday_74, c8_.salutation AS salutation_75, c8_.formOfAddress AS formOfAddress_76, c8_.newsletter AS newsletter_77, c8_.gender AS gender_78, c8_.note AS note_79, c8_.mainEmail AS mainEmail_80, c8_.mainPhone AS mainPhone_81, c8_.mainFax AS mainFax_82, c8_.mainUrl AS mainUrl_83, c8_.id AS id_84, c8_.created AS created_85, c8_.changed AS changed_86, s9_.username AS username_87, s9_.password AS password_88, s9_.locale AS locale_89, s9_.salt AS salt_90, s9_.locked AS locked_91, s9_.enabled AS enabled_92, s9_.lastLogin AS lastLogin_93, s9_.confirmationKey AS confirmationKey_94, s9_.passwordResetToken AS passwordResetToken_95, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_96, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_97, s9_.privateKey AS privateKey_98, s9_.apiKey AS apiKey_99, s9_.email AS email_100, s9_.id AS id_101, s9_.created AS created_102, s9_.changed AS changed_103, s9_.tracking AS tracking_104, s9_.buying_and_selling AS buying_and_selling_105, s9_.delivery AS delivery_106, s9_.marketing AS marketing_107, c10_.firstName AS firstName_108, c10_.middleName AS middleName_109, c10_.lastName AS lastName_110, c10_.birthday AS birthday_111, c10_.salutation AS salutation_112, c10_.formOfAddress AS formOfAddress_113, c10_.newsletter AS newsletter_114, c10_.gender AS gender_115, c10_.note AS note_116, c10_.mainEmail AS mainEmail_117, c10_.mainPhone AS mainPhone_118, c10_.mainFax AS mainFax_119, c10_.mainUrl AS mainUrl_120, c10_.id AS id_121, c10_.created AS created_122, c10_.changed AS changed_123, m0_.idPreviewImage AS idPreviewImage_124, m0_.idCollections AS idCollections_125, m0_.idUsersCreator AS idUsersCreator_126, m0_.idUsersChanger AS idUsersChanger_127, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_128, m1_.idCollectionTypes AS idCollectionTypes_129, m1_.idCollectionsParent AS idCollectionsParent_130, m1_.idUsersCreator AS idUsersCreator_131, m1_.idUsersChanger AS idUsersChanger_132, m2_.idMedia AS idMedia_133, m2_.idUsersCreator AS idUsersCreator_134, m2_.idUsersChanger AS idUsersChanger_135, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_136, m3_.idFiles AS idFiles_137, m3_.idUsersCreator AS idUsersCreator_138, m3_.idUsersChanger AS idUsersChanger_139, t4_.idUsersCreator AS idUsersCreator_140, t4_.idUsersChanger AS idUsersChanger_141, m5_.idFileVersions AS idFileVersions_142, m6_.idFileVersions AS idFileVersions_143, s7_.idUsersCreator AS idUsersCreator_144, s7_.idUsersChanger AS idUsersChanger_145, s7_.cart_id AS cart_id_146, s7_.idContacts AS idContacts_147, c8_.idTitles AS idTitles_148, c8_.avatar AS avatar_149, c8_.idUsersCreator AS idUsersCreator_150, c8_.idUsersChanger AS idUsersChanger_151, s9_.idUsersCreator AS idUsersCreator_152, s9_.idUsersChanger AS idUsersChanger_153, s9_.cart_id AS cart_id_154, s9_.idContacts AS idContacts_155, c10_.idTitles AS idTitles_156, c10_.avatar AS avatar_157, c10_.idUsersCreator AS idUsersCreator_158, c10_.idUsersChanger AS idUsersChanger_159 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id INNER JOIN me_files m2_ ON m0_.id = m2_.idMedia INNER JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles AND (m3_.version = m2_.version) LEFT JOIN me_file_version_tags m11_ ON m3_.id = m11_.idFileVersions LEFT JOIN ta_tags t4_ ON t4_.id = m11_.idTags LEFT JOIN me_file_version_meta m5_ ON m3_.id = m5_.idFileVersions LEFT JOIN me_file_version_meta m6_ ON m3_.idFileVersionsMetaDefault = m6_.id LEFT JOIN se_users s7_ ON m0_.idUsersCreator = s7_.id LEFT JOIN co_contacts c8_ ON s7_.idContacts = c8_.id LEFT JOIN se_users s9_ ON m0_.idUsersChanger = s9_.id LEFT JOIN co_contacts c10_ ON s9_.idContacts = c10_.id WHERE m0_.id IN (?) ORDER BY m0_.id ASC
Parameters:
[
  15
]
19 1.47 ms
SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.style AS style_4, m1_.lft AS lft_5, m1_.rgt AS rgt_6, m1_.depth AS depth_7, m1_.collection_key AS collection_key_8, m1_.id AS id_9, m1_.created AS created_10, m1_.changed AS changed_11, m2_.version AS version_12, m2_.id AS id_13, m2_.created AS created_14, m2_.changed AS changed_15, m3_.name AS name_16, m3_.version AS version_17, m3_.subVersion AS subVersion_18, m3_.size AS size_19, m3_.downloadCounter AS downloadCounter_20, m3_.storageOptions AS storageOptions_21, m3_.mimeType AS mimeType_22, m3_.properties AS properties_23, m3_.focusPointX AS focusPointX_24, m3_.focusPointY AS focusPointY_25, m3_.origin AS origin_26, m3_.aiDisclosureDisabled AS aiDisclosureDisabled_27, m3_.aiDisclosureIconVariant AS aiDisclosureIconVariant_28, m3_.id AS id_29, m3_.created AS created_30, m3_.changed AS changed_31, t4_.name AS name_32, t4_.id AS id_33, t4_.created AS created_34, t4_.changed AS changed_35, m5_.title AS title_36, m5_.description AS description_37, m5_.aiDisclosureText AS aiDisclosureText_38, m5_.copyright AS copyright_39, m5_.credits AS credits_40, m5_.locale AS locale_41, m5_.id AS id_42, m6_.title AS title_43, m6_.description AS description_44, m6_.aiDisclosureText AS aiDisclosureText_45, m6_.copyright AS copyright_46, m6_.credits AS credits_47, m6_.locale AS locale_48, m6_.id AS id_49, s7_.username AS username_50, s7_.password AS password_51, s7_.locale AS locale_52, s7_.salt AS salt_53, s7_.locked AS locked_54, s7_.enabled AS enabled_55, s7_.lastLogin AS lastLogin_56, s7_.confirmationKey AS confirmationKey_57, s7_.passwordResetToken AS passwordResetToken_58, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_59, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_60, s7_.privateKey AS privateKey_61, s7_.apiKey AS apiKey_62, s7_.email AS email_63, s7_.id AS id_64, s7_.created AS created_65, s7_.changed AS changed_66, s7_.tracking AS tracking_67, s7_.buying_and_selling AS buying_and_selling_68, s7_.delivery AS delivery_69, s7_.marketing AS marketing_70, c8_.firstName AS firstName_71, c8_.middleName AS middleName_72, c8_.lastName AS lastName_73, c8_.birthday AS birthday_74, c8_.salutation AS salutation_75, c8_.formOfAddress AS formOfAddress_76, c8_.newsletter AS newsletter_77, c8_.gender AS gender_78, c8_.note AS note_79, c8_.mainEmail AS mainEmail_80, c8_.mainPhone AS mainPhone_81, c8_.mainFax AS mainFax_82, c8_.mainUrl AS mainUrl_83, c8_.id AS id_84, c8_.created AS created_85, c8_.changed AS changed_86, s9_.username AS username_87, s9_.password AS password_88, s9_.locale AS locale_89, s9_.salt AS salt_90, s9_.locked AS locked_91, s9_.enabled AS enabled_92, s9_.lastLogin AS lastLogin_93, s9_.confirmationKey AS confirmationKey_94, s9_.passwordResetToken AS passwordResetToken_95, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_96, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_97, s9_.privateKey AS privateKey_98, s9_.apiKey AS apiKey_99, s9_.email AS email_100, s9_.id AS id_101, s9_.created AS created_102, s9_.changed AS changed_103, s9_.tracking AS tracking_104, s9_.buying_and_selling AS buying_and_selling_105, s9_.delivery AS delivery_106, s9_.marketing AS marketing_107, c10_.firstName AS firstName_108, c10_.middleName AS middleName_109, c10_.lastName AS lastName_110, c10_.birthday AS birthday_111, c10_.salutation AS salutation_112, c10_.formOfAddress AS formOfAddress_113, c10_.newsletter AS newsletter_114, c10_.gender AS gender_115, c10_.note AS note_116, c10_.mainEmail AS mainEmail_117, c10_.mainPhone AS mainPhone_118, c10_.mainFax AS mainFax_119, c10_.mainUrl AS mainUrl_120, c10_.id AS id_121, c10_.created AS created_122, c10_.changed AS changed_123, m0_.idPreviewImage AS idPreviewImage_124, m0_.idCollections AS idCollections_125, m0_.idUsersCreator AS idUsersCreator_126, m0_.idUsersChanger AS idUsersChanger_127, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_128, m1_.idCollectionTypes AS idCollectionTypes_129, m1_.idCollectionsParent AS idCollectionsParent_130, m1_.idUsersCreator AS idUsersCreator_131, m1_.idUsersChanger AS idUsersChanger_132, m2_.idMedia AS idMedia_133, m2_.idUsersCreator AS idUsersCreator_134, m2_.idUsersChanger AS idUsersChanger_135, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_136, m3_.idFiles AS idFiles_137, m3_.idUsersCreator AS idUsersCreator_138, m3_.idUsersChanger AS idUsersChanger_139, t4_.idUsersCreator AS idUsersCreator_140, t4_.idUsersChanger AS idUsersChanger_141, m5_.idFileVersions AS idFileVersions_142, m6_.idFileVersions AS idFileVersions_143, s7_.idUsersCreator AS idUsersCreator_144, s7_.idUsersChanger AS idUsersChanger_145, s7_.cart_id AS cart_id_146, s7_.idContacts AS idContacts_147, c8_.idTitles AS idTitles_148, c8_.avatar AS avatar_149, c8_.idUsersCreator AS idUsersCreator_150, c8_.idUsersChanger AS idUsersChanger_151, s9_.idUsersCreator AS idUsersCreator_152, s9_.idUsersChanger AS idUsersChanger_153, s9_.cart_id AS cart_id_154, s9_.idContacts AS idContacts_155, c10_.idTitles AS idTitles_156, c10_.avatar AS avatar_157, c10_.idUsersCreator AS idUsersCreator_158, c10_.idUsersChanger AS idUsersChanger_159 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id INNER JOIN me_files m2_ ON m0_.id = m2_.idMedia INNER JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles AND (m3_.version = m2_.version) LEFT JOIN me_file_version_tags m11_ ON m3_.id = m11_.idFileVersions LEFT JOIN ta_tags t4_ ON t4_.id = m11_.idTags LEFT JOIN me_file_version_meta m5_ ON m3_.id = m5_.idFileVersions LEFT JOIN me_file_version_meta m6_ ON m3_.idFileVersionsMetaDefault = m6_.id LEFT JOIN se_users s7_ ON m0_.idUsersCreator = s7_.id LEFT JOIN co_contacts c8_ ON s7_.idContacts = c8_.id LEFT JOIN se_users s9_ ON m0_.idUsersChanger = s9_.id LEFT JOIN co_contacts c10_ ON s9_.idContacts = c10_.id WHERE m0_.id IN (?) ORDER BY m0_.id ASC
Parameters:
[
  13
]
20 7.97 ms
SELECT p0_.webspaceKey AS webspaceKey_0, p0_.lft AS lft_1, p0_.rgt AS rgt_2, p0_.depth AS depth_3, p0_.uuid AS uuid_4, p0_.created AS created_5, p0_.changed AS changed_6, p1_.title AS title_7, p1_.id AS id_8, p1_.stage AS stage_9, p1_.locale AS locale_10, p1_.ghostLocale AS ghostLocale_11, p1_.availableLocales AS availableLocales_12, p1_.version AS version_13, p1_.shadowLocale AS shadowLocale_14, p1_.shadowLocales AS shadowLocales_15, p1_.templateKey AS templateKey_16, p1_.templateData AS templateData_17, p1_.seoData AS seoData_18, p1_.seoNoIndex AS seoNoIndex_19, p1_.seoNoFollow AS seoNoFollow_20, p1_.seoHideInSitemap AS seoHideInSitemap_21, p1_.excerptData AS excerptData_22, p1_.excerptSegment AS excerptSegment_23, p1_.authored AS authored_24, p1_.lastModified AS lastModified_25, p1_.workflowPlace AS workflowPlace_26, p1_.workflowPublished AS workflowPublished_27, p1_.linkProvider AS linkProvider_28, p1_.linkData AS linkData_29, p1_.created AS created_30, p1_.changed AS changed_31, t2_.name AS name_32, t2_.id AS id_33, t2_.created AS created_34, t2_.changed AS changed_35, c3_.category_key AS category_key_36, c3_.default_locale AS default_locale_37, c3_.lft AS lft_38, c3_.rgt AS rgt_39, c3_.depth AS depth_40, c3_.id AS id_41, c3_.created AS created_42, c3_.changed AS changed_43, c4_.translation AS translation_44, c4_.locale AS locale_45, c4_.description AS description_46, c4_.id AS id_47, c4_.created AS created_48, c4_.changed AS changed_49, r5_.webspace AS webspace_50, r5_.locale AS locale_51, r5_.slug AS slug_52, r5_.resource_key AS resource_key_53, r5_.resource_id AS resource_id_54, r5_.id AS id_55, p6_.name AS name_56, p6_.id AS id_57, p0_.parent_id AS parent_id_58, p0_.idUsersCreator AS idUsersCreator_59, p0_.idUsersChanger AS idUsersChanger_60, p1_.route_id AS route_id_61, p1_.pageUuid AS pageUuid_62, p1_.author_id AS author_id_63, p1_.idUsersCreator AS idUsersCreator_64, p1_.idUsersChanger AS idUsersChanger_65, t2_.idUsersCreator AS idUsersCreator_66, t2_.idUsersChanger AS idUsersChanger_67, c3_.idCategoriesParent AS idCategoriesParent_68, c3_.idUsersCreator AS idUsersCreator_69, c3_.idUsersChanger AS idUsersChanger_70, c4_.idCategories AS idCategories_71, c4_.idUsersCreator AS idUsersCreator_72, c4_.idUsersChanger AS idUsersChanger_73, r5_.parent_id AS parent_id_74, p6_.page_dimension_content_id AS page_dimension_content_id_75 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p7_ ON (p7_.pageUuid = p0_.uuid) LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid LEFT JOIN pa_page_dimension_content_excerpt_tags p8_ ON p1_.id = p8_.page_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = p8_.tag_id LEFT JOIN pa_page_dimension_content_excerpt_categories p9_ ON p1_.id = p9_.page_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = p9_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories AND (c4_.locale = c3_.default_locale OR c4_.locale IN (?)) LEFT JOIN ro_routes r5_ ON p1_.route_id = r5_.id LEFT JOIN pa_page_dimension_content_navigation_contexts p6_ ON p1_.id = p6_.page_dimension_content_id LEFT JOIN pa_page_dimension_content_navigation_contexts p10_ ON p7_.id = p10_.page_dimension_content_id WHERE p0_.webspaceKey = ? AND p0_.depth <= ? AND p7_.locale = ? AND p7_.stage = ? AND p7_.version = ? AND (((p1_.locale IS NULL OR p1_.locale IN (?)) AND (p1_.stage IS NULL OR p1_.stage IN (?))) AND (p1_.version IS NULL OR p1_.version IN (?))) AND p10_.name IN (?) ORDER BY p0_.lft ASC
Parameters:
[
  "hr"
  "pakom"
  15
  "hr"
  "live"
  0
  "hr"
  "live"
  0
  "shop"
]
21 6.22 ms
SELECT p0_.webspaceKey AS webspaceKey_0, p0_.lft AS lft_1, p0_.rgt AS rgt_2, p0_.depth AS depth_3, p0_.uuid AS uuid_4, p0_.created AS created_5, p0_.changed AS changed_6, p1_.title AS title_7, p1_.id AS id_8, p1_.stage AS stage_9, p1_.locale AS locale_10, p1_.ghostLocale AS ghostLocale_11, p1_.availableLocales AS availableLocales_12, p1_.version AS version_13, p1_.shadowLocale AS shadowLocale_14, p1_.shadowLocales AS shadowLocales_15, p1_.templateKey AS templateKey_16, p1_.templateData AS templateData_17, p1_.seoData AS seoData_18, p1_.seoNoIndex AS seoNoIndex_19, p1_.seoNoFollow AS seoNoFollow_20, p1_.seoHideInSitemap AS seoHideInSitemap_21, p1_.excerptData AS excerptData_22, p1_.excerptSegment AS excerptSegment_23, p1_.authored AS authored_24, p1_.lastModified AS lastModified_25, p1_.workflowPlace AS workflowPlace_26, p1_.workflowPublished AS workflowPublished_27, p1_.linkProvider AS linkProvider_28, p1_.linkData AS linkData_29, p1_.created AS created_30, p1_.changed AS changed_31, t2_.name AS name_32, t2_.id AS id_33, t2_.created AS created_34, t2_.changed AS changed_35, c3_.category_key AS category_key_36, c3_.default_locale AS default_locale_37, c3_.lft AS lft_38, c3_.rgt AS rgt_39, c3_.depth AS depth_40, c3_.id AS id_41, c3_.created AS created_42, c3_.changed AS changed_43, c4_.translation AS translation_44, c4_.locale AS locale_45, c4_.description AS description_46, c4_.id AS id_47, c4_.created AS created_48, c4_.changed AS changed_49, r5_.webspace AS webspace_50, r5_.locale AS locale_51, r5_.slug AS slug_52, r5_.resource_key AS resource_key_53, r5_.resource_id AS resource_id_54, r5_.id AS id_55, p6_.name AS name_56, p6_.id AS id_57, p0_.parent_id AS parent_id_58, p0_.idUsersCreator AS idUsersCreator_59, p0_.idUsersChanger AS idUsersChanger_60, p1_.route_id AS route_id_61, p1_.pageUuid AS pageUuid_62, p1_.author_id AS author_id_63, p1_.idUsersCreator AS idUsersCreator_64, p1_.idUsersChanger AS idUsersChanger_65, t2_.idUsersCreator AS idUsersCreator_66, t2_.idUsersChanger AS idUsersChanger_67, c3_.idCategoriesParent AS idCategoriesParent_68, c3_.idUsersCreator AS idUsersCreator_69, c3_.idUsersChanger AS idUsersChanger_70, c4_.idCategories AS idCategories_71, c4_.idUsersCreator AS idUsersCreator_72, c4_.idUsersChanger AS idUsersChanger_73, r5_.parent_id AS parent_id_74, p6_.page_dimension_content_id AS page_dimension_content_id_75 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p7_ ON (p7_.pageUuid = p0_.uuid) LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid LEFT JOIN pa_page_dimension_content_excerpt_tags p8_ ON p1_.id = p8_.page_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = p8_.tag_id LEFT JOIN pa_page_dimension_content_excerpt_categories p9_ ON p1_.id = p9_.page_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = p9_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories AND (c4_.locale = c3_.default_locale OR c4_.locale IN (?)) LEFT JOIN ro_routes r5_ ON p1_.route_id = r5_.id LEFT JOIN pa_page_dimension_content_navigation_contexts p6_ ON p1_.id = p6_.page_dimension_content_id LEFT JOIN pa_page_dimension_content_navigation_contexts p10_ ON p7_.id = p10_.page_dimension_content_id WHERE p0_.webspaceKey = ? AND p0_.depth <= ? AND p7_.locale = ? AND p7_.stage = ? AND p7_.version = ? AND (((p1_.locale IS NULL OR p1_.locale IN (?)) AND (p1_.stage IS NULL OR p1_.stage IN (?))) AND (p1_.version IS NULL OR p1_.version IN (?))) AND p10_.name IN (?) ORDER BY p0_.lft ASC
Parameters:
[
  "hr"
  "pakom"
  15
  "hr"
  "live"
  0
  "hr"
  "live"
  0
  "shop"
]
22 8.20 ms
SELECT p0_.webspaceKey AS webspaceKey_0, p0_.lft AS lft_1, p0_.rgt AS rgt_2, p0_.depth AS depth_3, p0_.uuid AS uuid_4, p0_.created AS created_5, p0_.changed AS changed_6, p1_.title AS title_7, p1_.id AS id_8, p1_.stage AS stage_9, p1_.locale AS locale_10, p1_.ghostLocale AS ghostLocale_11, p1_.availableLocales AS availableLocales_12, p1_.version AS version_13, p1_.shadowLocale AS shadowLocale_14, p1_.shadowLocales AS shadowLocales_15, p1_.templateKey AS templateKey_16, p1_.templateData AS templateData_17, p1_.seoData AS seoData_18, p1_.seoNoIndex AS seoNoIndex_19, p1_.seoNoFollow AS seoNoFollow_20, p1_.seoHideInSitemap AS seoHideInSitemap_21, p1_.excerptData AS excerptData_22, p1_.excerptSegment AS excerptSegment_23, p1_.authored AS authored_24, p1_.lastModified AS lastModified_25, p1_.workflowPlace AS workflowPlace_26, p1_.workflowPublished AS workflowPublished_27, p1_.linkProvider AS linkProvider_28, p1_.linkData AS linkData_29, p1_.created AS created_30, p1_.changed AS changed_31, t2_.name AS name_32, t2_.id AS id_33, t2_.created AS created_34, t2_.changed AS changed_35, c3_.category_key AS category_key_36, c3_.default_locale AS default_locale_37, c3_.lft AS lft_38, c3_.rgt AS rgt_39, c3_.depth AS depth_40, c3_.id AS id_41, c3_.created AS created_42, c3_.changed AS changed_43, c4_.translation AS translation_44, c4_.locale AS locale_45, c4_.description AS description_46, c4_.id AS id_47, c4_.created AS created_48, c4_.changed AS changed_49, r5_.webspace AS webspace_50, r5_.locale AS locale_51, r5_.slug AS slug_52, r5_.resource_key AS resource_key_53, r5_.resource_id AS resource_id_54, r5_.id AS id_55, p6_.name AS name_56, p6_.id AS id_57, p0_.parent_id AS parent_id_58, p0_.idUsersCreator AS idUsersCreator_59, p0_.idUsersChanger AS idUsersChanger_60, p1_.route_id AS route_id_61, p1_.pageUuid AS pageUuid_62, p1_.author_id AS author_id_63, p1_.idUsersCreator AS idUsersCreator_64, p1_.idUsersChanger AS idUsersChanger_65, t2_.idUsersCreator AS idUsersCreator_66, t2_.idUsersChanger AS idUsersChanger_67, c3_.idCategoriesParent AS idCategoriesParent_68, c3_.idUsersCreator AS idUsersCreator_69, c3_.idUsersChanger AS idUsersChanger_70, c4_.idCategories AS idCategories_71, c4_.idUsersCreator AS idUsersCreator_72, c4_.idUsersChanger AS idUsersChanger_73, r5_.parent_id AS parent_id_74, p6_.page_dimension_content_id AS page_dimension_content_id_75 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p7_ ON (p7_.pageUuid = p0_.uuid) LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid LEFT JOIN pa_page_dimension_content_excerpt_tags p8_ ON p1_.id = p8_.page_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = p8_.tag_id LEFT JOIN pa_page_dimension_content_excerpt_categories p9_ ON p1_.id = p9_.page_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = p9_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories AND (c4_.locale = c3_.default_locale OR c4_.locale IN (?)) LEFT JOIN ro_routes r5_ ON p1_.route_id = r5_.id LEFT JOIN pa_page_dimension_content_navigation_contexts p6_ ON p1_.id = p6_.page_dimension_content_id LEFT JOIN pa_page_dimension_content_navigation_contexts p10_ ON p7_.id = p10_.page_dimension_content_id WHERE p0_.webspaceKey = ? AND p0_.depth <= ? AND p7_.locale = ? AND p7_.stage = ? AND p7_.version = ? AND (((p1_.locale IS NULL OR p1_.locale IN (?)) AND (p1_.stage IS NULL OR p1_.stage IN (?))) AND (p1_.version IS NULL OR p1_.version IN (?))) AND p10_.name IN (?) ORDER BY p0_.lft ASC
Parameters:
[
  "hr"
  "pakom"
  15
  "hr"
  "live"
  0
  "hr"
  "live"
  0
  "shop"
]
23 7.20 ms
SELECT p0_.webspaceKey AS webspaceKey_0, p0_.lft AS lft_1, p0_.rgt AS rgt_2, p0_.depth AS depth_3, p0_.uuid AS uuid_4, p0_.created AS created_5, p0_.changed AS changed_6, p1_.title AS title_7, p1_.id AS id_8, p1_.stage AS stage_9, p1_.locale AS locale_10, p1_.ghostLocale AS ghostLocale_11, p1_.availableLocales AS availableLocales_12, p1_.version AS version_13, p1_.shadowLocale AS shadowLocale_14, p1_.shadowLocales AS shadowLocales_15, p1_.templateKey AS templateKey_16, p1_.templateData AS templateData_17, p1_.seoData AS seoData_18, p1_.seoNoIndex AS seoNoIndex_19, p1_.seoNoFollow AS seoNoFollow_20, p1_.seoHideInSitemap AS seoHideInSitemap_21, p1_.excerptData AS excerptData_22, p1_.excerptSegment AS excerptSegment_23, p1_.authored AS authored_24, p1_.lastModified AS lastModified_25, p1_.workflowPlace AS workflowPlace_26, p1_.workflowPublished AS workflowPublished_27, p1_.linkProvider AS linkProvider_28, p1_.linkData AS linkData_29, p1_.created AS created_30, p1_.changed AS changed_31, t2_.name AS name_32, t2_.id AS id_33, t2_.created AS created_34, t2_.changed AS changed_35, c3_.category_key AS category_key_36, c3_.default_locale AS default_locale_37, c3_.lft AS lft_38, c3_.rgt AS rgt_39, c3_.depth AS depth_40, c3_.id AS id_41, c3_.created AS created_42, c3_.changed AS changed_43, c4_.translation AS translation_44, c4_.locale AS locale_45, c4_.description AS description_46, c4_.id AS id_47, c4_.created AS created_48, c4_.changed AS changed_49, r5_.webspace AS webspace_50, r5_.locale AS locale_51, r5_.slug AS slug_52, r5_.resource_key AS resource_key_53, r5_.resource_id AS resource_id_54, r5_.id AS id_55, p6_.name AS name_56, p6_.id AS id_57, p0_.parent_id AS parent_id_58, p0_.idUsersCreator AS idUsersCreator_59, p0_.idUsersChanger AS idUsersChanger_60, p1_.route_id AS route_id_61, p1_.pageUuid AS pageUuid_62, p1_.author_id AS author_id_63, p1_.idUsersCreator AS idUsersCreator_64, p1_.idUsersChanger AS idUsersChanger_65, t2_.idUsersCreator AS idUsersCreator_66, t2_.idUsersChanger AS idUsersChanger_67, c3_.idCategoriesParent AS idCategoriesParent_68, c3_.idUsersCreator AS idUsersCreator_69, c3_.idUsersChanger AS idUsersChanger_70, c4_.idCategories AS idCategories_71, c4_.idUsersCreator AS idUsersCreator_72, c4_.idUsersChanger AS idUsersChanger_73, r5_.parent_id AS parent_id_74, p6_.page_dimension_content_id AS page_dimension_content_id_75 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p7_ ON (p7_.pageUuid = p0_.uuid) LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid LEFT JOIN pa_page_dimension_content_excerpt_tags p8_ ON p1_.id = p8_.page_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = p8_.tag_id LEFT JOIN pa_page_dimension_content_excerpt_categories p9_ ON p1_.id = p9_.page_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = p9_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories AND (c4_.locale = c3_.default_locale OR c4_.locale IN (?)) LEFT JOIN ro_routes r5_ ON p1_.route_id = r5_.id LEFT JOIN pa_page_dimension_content_navigation_contexts p6_ ON p1_.id = p6_.page_dimension_content_id LEFT JOIN pa_page_dimension_content_navigation_contexts p10_ ON p7_.id = p10_.page_dimension_content_id WHERE p0_.webspaceKey = ? AND p0_.depth <= ? AND p7_.locale = ? AND p7_.stage = ? AND p7_.version = ? AND (((p1_.locale IS NULL OR p1_.locale IN (?)) AND (p1_.stage IS NULL OR p1_.stage IN (?))) AND (p1_.version IS NULL OR p1_.version IN (?))) AND p10_.name IN (?) ORDER BY p0_.lft ASC
Parameters:
[
  "hr"
  "pakom"
  15
  "hr"
  "live"
  0
  "hr"
  "live"
  0
  "shop"
]
24 7.80 ms
SELECT p0_.webspaceKey AS webspaceKey_0, p0_.lft AS lft_1, p0_.rgt AS rgt_2, p0_.depth AS depth_3, p0_.uuid AS uuid_4, p0_.created AS created_5, p0_.changed AS changed_6, p1_.title AS title_7, p1_.id AS id_8, p1_.stage AS stage_9, p1_.locale AS locale_10, p1_.ghostLocale AS ghostLocale_11, p1_.availableLocales AS availableLocales_12, p1_.version AS version_13, p1_.shadowLocale AS shadowLocale_14, p1_.shadowLocales AS shadowLocales_15, p1_.templateKey AS templateKey_16, p1_.templateData AS templateData_17, p1_.seoData AS seoData_18, p1_.seoNoIndex AS seoNoIndex_19, p1_.seoNoFollow AS seoNoFollow_20, p1_.seoHideInSitemap AS seoHideInSitemap_21, p1_.excerptData AS excerptData_22, p1_.excerptSegment AS excerptSegment_23, p1_.authored AS authored_24, p1_.lastModified AS lastModified_25, p1_.workflowPlace AS workflowPlace_26, p1_.workflowPublished AS workflowPublished_27, p1_.linkProvider AS linkProvider_28, p1_.linkData AS linkData_29, p1_.created AS created_30, p1_.changed AS changed_31, t2_.name AS name_32, t2_.id AS id_33, t2_.created AS created_34, t2_.changed AS changed_35, c3_.category_key AS category_key_36, c3_.default_locale AS default_locale_37, c3_.lft AS lft_38, c3_.rgt AS rgt_39, c3_.depth AS depth_40, c3_.id AS id_41, c3_.created AS created_42, c3_.changed AS changed_43, c4_.translation AS translation_44, c4_.locale AS locale_45, c4_.description AS description_46, c4_.id AS id_47, c4_.created AS created_48, c4_.changed AS changed_49, r5_.webspace AS webspace_50, r5_.locale AS locale_51, r5_.slug AS slug_52, r5_.resource_key AS resource_key_53, r5_.resource_id AS resource_id_54, r5_.id AS id_55, p6_.name AS name_56, p6_.id AS id_57, p0_.parent_id AS parent_id_58, p0_.idUsersCreator AS idUsersCreator_59, p0_.idUsersChanger AS idUsersChanger_60, p1_.route_id AS route_id_61, p1_.pageUuid AS pageUuid_62, p1_.author_id AS author_id_63, p1_.idUsersCreator AS idUsersCreator_64, p1_.idUsersChanger AS idUsersChanger_65, t2_.idUsersCreator AS idUsersCreator_66, t2_.idUsersChanger AS idUsersChanger_67, c3_.idCategoriesParent AS idCategoriesParent_68, c3_.idUsersCreator AS idUsersCreator_69, c3_.idUsersChanger AS idUsersChanger_70, c4_.idCategories AS idCategories_71, c4_.idUsersCreator AS idUsersCreator_72, c4_.idUsersChanger AS idUsersChanger_73, r5_.parent_id AS parent_id_74, p6_.page_dimension_content_id AS page_dimension_content_id_75 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p7_ ON (p7_.pageUuid = p0_.uuid) LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid LEFT JOIN pa_page_dimension_content_excerpt_tags p8_ ON p1_.id = p8_.page_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = p8_.tag_id LEFT JOIN pa_page_dimension_content_excerpt_categories p9_ ON p1_.id = p9_.page_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = p9_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories AND (c4_.locale = c3_.default_locale OR c4_.locale IN (?)) LEFT JOIN ro_routes r5_ ON p1_.route_id = r5_.id LEFT JOIN pa_page_dimension_content_navigation_contexts p6_ ON p1_.id = p6_.page_dimension_content_id LEFT JOIN pa_page_dimension_content_navigation_contexts p10_ ON p7_.id = p10_.page_dimension_content_id WHERE p0_.webspaceKey = ? AND p0_.depth <= ? AND p7_.locale = ? AND p7_.stage = ? AND p7_.version = ? AND (((p1_.locale IS NULL OR p1_.locale IN (?)) AND (p1_.stage IS NULL OR p1_.stage IN (?))) AND (p1_.version IS NULL OR p1_.version IN (?))) AND p10_.name IN (?) ORDER BY p0_.lft ASC
Parameters:
[
  "hr"
  "pakom"
  15
  "hr"
  "live"
  0
  "hr"
  "live"
  0
  "shop"
]
25 1.72 ms
SELECT p0_.webspaceKey AS webspaceKey_0, p0_.lft AS lft_1, p0_.rgt AS rgt_2, p0_.depth AS depth_3, p0_.uuid AS uuid_4, p0_.created AS created_5, p0_.changed AS changed_6, p1_.title AS title_7, p1_.id AS id_8, p1_.stage AS stage_9, p1_.locale AS locale_10, p1_.ghostLocale AS ghostLocale_11, p1_.availableLocales AS availableLocales_12, p1_.version AS version_13, p1_.shadowLocale AS shadowLocale_14, p1_.shadowLocales AS shadowLocales_15, p1_.templateKey AS templateKey_16, p1_.templateData AS templateData_17, p1_.seoData AS seoData_18, p1_.seoNoIndex AS seoNoIndex_19, p1_.seoNoFollow AS seoNoFollow_20, p1_.seoHideInSitemap AS seoHideInSitemap_21, p1_.excerptData AS excerptData_22, p1_.excerptSegment AS excerptSegment_23, p1_.authored AS authored_24, p1_.lastModified AS lastModified_25, p1_.workflowPlace AS workflowPlace_26, p1_.workflowPublished AS workflowPublished_27, p1_.linkProvider AS linkProvider_28, p1_.linkData AS linkData_29, p1_.created AS created_30, p1_.changed AS changed_31, t2_.name AS name_32, t2_.id AS id_33, t2_.created AS created_34, t2_.changed AS changed_35, c3_.category_key AS category_key_36, c3_.default_locale AS default_locale_37, c3_.lft AS lft_38, c3_.rgt AS rgt_39, c3_.depth AS depth_40, c3_.id AS id_41, c3_.created AS created_42, c3_.changed AS changed_43, c4_.translation AS translation_44, c4_.locale AS locale_45, c4_.description AS description_46, c4_.id AS id_47, c4_.created AS created_48, c4_.changed AS changed_49, r5_.webspace AS webspace_50, r5_.locale AS locale_51, r5_.slug AS slug_52, r5_.resource_key AS resource_key_53, r5_.resource_id AS resource_id_54, r5_.id AS id_55, p6_.name AS name_56, p6_.id AS id_57, p0_.parent_id AS parent_id_58, p0_.idUsersCreator AS idUsersCreator_59, p0_.idUsersChanger AS idUsersChanger_60, p1_.route_id AS route_id_61, p1_.pageUuid AS pageUuid_62, p1_.author_id AS author_id_63, p1_.idUsersCreator AS idUsersCreator_64, p1_.idUsersChanger AS idUsersChanger_65, t2_.idUsersCreator AS idUsersCreator_66, t2_.idUsersChanger AS idUsersChanger_67, c3_.idCategoriesParent AS idCategoriesParent_68, c3_.idUsersCreator AS idUsersCreator_69, c3_.idUsersChanger AS idUsersChanger_70, c4_.idCategories AS idCategories_71, c4_.idUsersCreator AS idUsersCreator_72, c4_.idUsersChanger AS idUsersChanger_73, r5_.parent_id AS parent_id_74, p6_.page_dimension_content_id AS page_dimension_content_id_75 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p7_ ON (p7_.pageUuid = p0_.uuid) LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid LEFT JOIN pa_page_dimension_content_excerpt_tags p8_ ON p1_.id = p8_.page_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = p8_.tag_id LEFT JOIN pa_page_dimension_content_excerpt_categories p9_ ON p1_.id = p9_.page_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = p9_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories AND (c4_.locale = c3_.default_locale OR c4_.locale IN (?)) LEFT JOIN ro_routes r5_ ON p1_.route_id = r5_.id LEFT JOIN pa_page_dimension_content_navigation_contexts p6_ ON p1_.id = p6_.page_dimension_content_id WHERE p0_.uuid = ? AND p7_.locale = ? AND p7_.stage = ? AND p7_.version = ? AND (((p1_.locale IS NULL OR p1_.locale IN (?)) AND (p1_.stage IS NULL OR p1_.stage IN (?))) AND (p1_.version IS NULL OR p1_.version IN (?))) ORDER BY p0_.lft ASC
Parameters:
[
  "hr"
  "01a0a54a-ebde-763c-afa8-84a5a5293c11"
  "hr"
  "live"
  0
  "hr"
  "live"
  0
]
26 2.88 ms
SELECT p0_.webspaceKey AS webspaceKey_0, p0_.lft AS lft_1, p0_.rgt AS rgt_2, p0_.depth AS depth_3, p0_.uuid AS uuid_4, p0_.created AS created_5, p0_.changed AS changed_6, p1_.title AS title_7, p1_.id AS id_8, p1_.stage AS stage_9, p1_.locale AS locale_10, p1_.ghostLocale AS ghostLocale_11, p1_.availableLocales AS availableLocales_12, p1_.version AS version_13, p1_.shadowLocale AS shadowLocale_14, p1_.shadowLocales AS shadowLocales_15, p1_.templateKey AS templateKey_16, p1_.templateData AS templateData_17, p1_.seoData AS seoData_18, p1_.seoNoIndex AS seoNoIndex_19, p1_.seoNoFollow AS seoNoFollow_20, p1_.seoHideInSitemap AS seoHideInSitemap_21, p1_.excerptData AS excerptData_22, p1_.excerptSegment AS excerptSegment_23, p1_.authored AS authored_24, p1_.lastModified AS lastModified_25, p1_.workflowPlace AS workflowPlace_26, p1_.workflowPublished AS workflowPublished_27, p1_.linkProvider AS linkProvider_28, p1_.linkData AS linkData_29, p1_.created AS created_30, p1_.changed AS changed_31, t2_.name AS name_32, t2_.id AS id_33, t2_.created AS created_34, t2_.changed AS changed_35, c3_.category_key AS category_key_36, c3_.default_locale AS default_locale_37, c3_.lft AS lft_38, c3_.rgt AS rgt_39, c3_.depth AS depth_40, c3_.id AS id_41, c3_.created AS created_42, c3_.changed AS changed_43, c4_.translation AS translation_44, c4_.locale AS locale_45, c4_.description AS description_46, c4_.id AS id_47, c4_.created AS created_48, c4_.changed AS changed_49, r5_.webspace AS webspace_50, r5_.locale AS locale_51, r5_.slug AS slug_52, r5_.resource_key AS resource_key_53, r5_.resource_id AS resource_id_54, r5_.id AS id_55, p6_.name AS name_56, p6_.id AS id_57, p0_.parent_id AS parent_id_58, p0_.idUsersCreator AS idUsersCreator_59, p0_.idUsersChanger AS idUsersChanger_60, p1_.route_id AS route_id_61, p1_.pageUuid AS pageUuid_62, p1_.author_id AS author_id_63, p1_.idUsersCreator AS idUsersCreator_64, p1_.idUsersChanger AS idUsersChanger_65, t2_.idUsersCreator AS idUsersCreator_66, t2_.idUsersChanger AS idUsersChanger_67, c3_.idCategoriesParent AS idCategoriesParent_68, c3_.idUsersCreator AS idUsersCreator_69, c3_.idUsersChanger AS idUsersChanger_70, c4_.idCategories AS idCategories_71, c4_.idUsersCreator AS idUsersCreator_72, c4_.idUsersChanger AS idUsersChanger_73, r5_.parent_id AS parent_id_74, p6_.page_dimension_content_id AS page_dimension_content_id_75 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p7_ ON (p7_.pageUuid = p0_.uuid) LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid LEFT JOIN pa_page_dimension_content_excerpt_tags p8_ ON p1_.id = p8_.page_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = p8_.tag_id LEFT JOIN pa_page_dimension_content_excerpt_categories p9_ ON p1_.id = p9_.page_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = p9_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories AND (c4_.locale = c3_.default_locale OR c4_.locale IN (?)) LEFT JOIN ro_routes r5_ ON p1_.route_id = r5_.id LEFT JOIN pa_page_dimension_content_navigation_contexts p6_ ON p1_.id = p6_.page_dimension_content_id WHERE p0_.lft < ? AND p0_.rgt > ? AND p0_.webspaceKey = ? AND p7_.locale = ? AND p7_.stage = ? AND p7_.version = ? AND (((p1_.locale IS NULL OR p1_.locale IN (?)) AND (p1_.stage IS NULL OR p1_.stage IN (?))) AND (p1_.version IS NULL OR p1_.version IN (?))) ORDER BY p0_.lft ASC
Parameters:
[
  "hr"
  115
  116
  "pakom"
  "hr"
  "live"
  0
  "hr"
  "live"
  0
]
27 1.60 ms
SELECT p0_.webspaceKey AS webspaceKey_0, p0_.lft AS lft_1, p0_.rgt AS rgt_2, p0_.depth AS depth_3, p0_.uuid AS uuid_4, p0_.created AS created_5, p0_.changed AS changed_6, p1_.title AS title_7, p1_.id AS id_8, p1_.stage AS stage_9, p1_.locale AS locale_10, p1_.ghostLocale AS ghostLocale_11, p1_.availableLocales AS availableLocales_12, p1_.version AS version_13, p1_.shadowLocale AS shadowLocale_14, p1_.shadowLocales AS shadowLocales_15, p1_.templateKey AS templateKey_16, p1_.templateData AS templateData_17, p1_.seoData AS seoData_18, p1_.seoNoIndex AS seoNoIndex_19, p1_.seoNoFollow AS seoNoFollow_20, p1_.seoHideInSitemap AS seoHideInSitemap_21, p1_.excerptData AS excerptData_22, p1_.excerptSegment AS excerptSegment_23, p1_.authored AS authored_24, p1_.lastModified AS lastModified_25, p1_.workflowPlace AS workflowPlace_26, p1_.workflowPublished AS workflowPublished_27, p1_.linkProvider AS linkProvider_28, p1_.linkData AS linkData_29, p1_.created AS created_30, p1_.changed AS changed_31, t2_.name AS name_32, t2_.id AS id_33, t2_.created AS created_34, t2_.changed AS changed_35, c3_.category_key AS category_key_36, c3_.default_locale AS default_locale_37, c3_.lft AS lft_38, c3_.rgt AS rgt_39, c3_.depth AS depth_40, c3_.id AS id_41, c3_.created AS created_42, c3_.changed AS changed_43, c4_.translation AS translation_44, c4_.locale AS locale_45, c4_.description AS description_46, c4_.id AS id_47, c4_.created AS created_48, c4_.changed AS changed_49, r5_.webspace AS webspace_50, r5_.locale AS locale_51, r5_.slug AS slug_52, r5_.resource_key AS resource_key_53, r5_.resource_id AS resource_id_54, r5_.id AS id_55, p6_.name AS name_56, p6_.id AS id_57, p0_.parent_id AS parent_id_58, p0_.idUsersCreator AS idUsersCreator_59, p0_.idUsersChanger AS idUsersChanger_60, p1_.route_id AS route_id_61, p1_.pageUuid AS pageUuid_62, p1_.author_id AS author_id_63, p1_.idUsersCreator AS idUsersCreator_64, p1_.idUsersChanger AS idUsersChanger_65, t2_.idUsersCreator AS idUsersCreator_66, t2_.idUsersChanger AS idUsersChanger_67, c3_.idCategoriesParent AS idCategoriesParent_68, c3_.idUsersCreator AS idUsersCreator_69, c3_.idUsersChanger AS idUsersChanger_70, c4_.idCategories AS idCategories_71, c4_.idUsersCreator AS idUsersCreator_72, c4_.idUsersChanger AS idUsersChanger_73, r5_.parent_id AS parent_id_74, p6_.page_dimension_content_id AS page_dimension_content_id_75 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p7_ ON (p7_.pageUuid = p0_.uuid) LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid LEFT JOIN pa_page_dimension_content_excerpt_tags p8_ ON p1_.id = p8_.page_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = p8_.tag_id LEFT JOIN pa_page_dimension_content_excerpt_categories p9_ ON p1_.id = p9_.page_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = p9_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories AND (c4_.locale = c3_.default_locale OR c4_.locale IN (?)) LEFT JOIN ro_routes r5_ ON p1_.route_id = r5_.id LEFT JOIN pa_page_dimension_content_navigation_contexts p6_ ON p1_.id = p6_.page_dimension_content_id WHERE p0_.uuid = ? AND p7_.locale = ? AND p7_.stage = ? AND p7_.version = ? AND (((p1_.locale IS NULL OR p1_.locale IN (?)) AND (p1_.stage IS NULL OR p1_.stage IN (?))) AND (p1_.version IS NULL OR p1_.version IN (?))) ORDER BY p0_.lft ASC
Parameters:
[
  "hr"
  "01a0a54a-ebde-763c-afa8-84a5a5293c11"
  "hr"
  "live"
  0
  "hr"
  "live"
  0
]
28 2.94 ms
SELECT p0_.webspaceKey AS webspaceKey_0, p0_.lft AS lft_1, p0_.rgt AS rgt_2, p0_.depth AS depth_3, p0_.uuid AS uuid_4, p0_.created AS created_5, p0_.changed AS changed_6, p1_.title AS title_7, p1_.id AS id_8, p1_.stage AS stage_9, p1_.locale AS locale_10, p1_.ghostLocale AS ghostLocale_11, p1_.availableLocales AS availableLocales_12, p1_.version AS version_13, p1_.shadowLocale AS shadowLocale_14, p1_.shadowLocales AS shadowLocales_15, p1_.templateKey AS templateKey_16, p1_.templateData AS templateData_17, p1_.seoData AS seoData_18, p1_.seoNoIndex AS seoNoIndex_19, p1_.seoNoFollow AS seoNoFollow_20, p1_.seoHideInSitemap AS seoHideInSitemap_21, p1_.excerptData AS excerptData_22, p1_.excerptSegment AS excerptSegment_23, p1_.authored AS authored_24, p1_.lastModified AS lastModified_25, p1_.workflowPlace AS workflowPlace_26, p1_.workflowPublished AS workflowPublished_27, p1_.linkProvider AS linkProvider_28, p1_.linkData AS linkData_29, p1_.created AS created_30, p1_.changed AS changed_31, t2_.name AS name_32, t2_.id AS id_33, t2_.created AS created_34, t2_.changed AS changed_35, c3_.category_key AS category_key_36, c3_.default_locale AS default_locale_37, c3_.lft AS lft_38, c3_.rgt AS rgt_39, c3_.depth AS depth_40, c3_.id AS id_41, c3_.created AS created_42, c3_.changed AS changed_43, c4_.translation AS translation_44, c4_.locale AS locale_45, c4_.description AS description_46, c4_.id AS id_47, c4_.created AS created_48, c4_.changed AS changed_49, r5_.webspace AS webspace_50, r5_.locale AS locale_51, r5_.slug AS slug_52, r5_.resource_key AS resource_key_53, r5_.resource_id AS resource_id_54, r5_.id AS id_55, p6_.name AS name_56, p6_.id AS id_57, p0_.parent_id AS parent_id_58, p0_.idUsersCreator AS idUsersCreator_59, p0_.idUsersChanger AS idUsersChanger_60, p1_.route_id AS route_id_61, p1_.pageUuid AS pageUuid_62, p1_.author_id AS author_id_63, p1_.idUsersCreator AS idUsersCreator_64, p1_.idUsersChanger AS idUsersChanger_65, t2_.idUsersCreator AS idUsersCreator_66, t2_.idUsersChanger AS idUsersChanger_67, c3_.idCategoriesParent AS idCategoriesParent_68, c3_.idUsersCreator AS idUsersCreator_69, c3_.idUsersChanger AS idUsersChanger_70, c4_.idCategories AS idCategories_71, c4_.idUsersCreator AS idUsersCreator_72, c4_.idUsersChanger AS idUsersChanger_73, r5_.parent_id AS parent_id_74, p6_.page_dimension_content_id AS page_dimension_content_id_75 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p7_ ON (p7_.pageUuid = p0_.uuid) LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid LEFT JOIN pa_page_dimension_content_excerpt_tags p8_ ON p1_.id = p8_.page_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = p8_.tag_id LEFT JOIN pa_page_dimension_content_excerpt_categories p9_ ON p1_.id = p9_.page_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = p9_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories AND (c4_.locale = c3_.default_locale OR c4_.locale IN (?)) LEFT JOIN ro_routes r5_ ON p1_.route_id = r5_.id LEFT JOIN pa_page_dimension_content_navigation_contexts p6_ ON p1_.id = p6_.page_dimension_content_id WHERE p0_.lft < ? AND p0_.rgt > ? AND p0_.webspaceKey = ? AND p7_.locale = ? AND p7_.stage = ? AND p7_.version = ? AND (((p1_.locale IS NULL OR p1_.locale IN (?)) AND (p1_.stage IS NULL OR p1_.stage IN (?))) AND (p1_.version IS NULL OR p1_.version IN (?))) ORDER BY p0_.lft ASC
Parameters:
[
  "hr"
  115
  116
  "pakom"
  "hr"
  "live"
  0
  "hr"
  "live"
  0
]
29 0.79 ms
SELECT w0_.title AS title_0, w0_.webspace_key AS webspace_key_1, w0_.all_domains AS all_domains_2, w0_.content AS content_3, w0_.type AS type_4, w0_.id AS id_5, w1_.url AS url_6, w1_.environment AS environment_7, w1_.id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain WHERE (w0_.all_domains = 1 OR (w1_.url = ? AND w1_.environment = ?)) AND w0_.webspace_key = ? ORDER BY w0_.id ASC
Parameters:
[
  "new.pakom-el.hr"
  "dev"
  "pakom"
]
30 1.22 ms
SELECT p0_.uuid AS uuid_0, p1_.title AS title_1, r2_.slug AS slug_2, p0_.webspaceKey AS webspaceKey_3, p1_.linkProvider AS linkProvider_4, p1_.linkData AS linkData_5 FROM pa_page_dimension_contents p1_ INNER JOIN pa_pages p0_ ON p1_.pageUuid = p0_.uuid LEFT JOIN ro_routes r2_ ON p1_.route_id = r2_.id WHERE p0_.uuid IN (?, ?, ?, ?, ?) AND p1_.locale = ? AND p1_.stage = ? AND p1_.version = ?
Parameters:
[
  "019e77eb-a1e0-7703-ae9a-506b674a3983"
  "019e6edf-01c9-74b7-86bd-af058e886dc0"
  "019e746c-6ebc-74cf-a5c4-383845e60a95"
  "019e6e90-5d8e-7c0d-bbbf-24422c30c71a"
  "019e756c-e086-7d24-bf2c-092e06ab9b14"
  "hr"
  "live"
  0
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
Sulu\Page\Domain\Model\PageDimensionContent 70
Sulu\Page\Domain\Model\PageDimensionContentNavigationContext 41
Sulu\Route\Domain\Model\Route 35
Sulu\Page\Domain\Model\Page 35
Sulu\Bundle\MediaBundle\Entity\Media 7
Sulu\Bundle\MediaBundle\Entity\File 7
Sulu\Bundle\MediaBundle\Entity\FileVersion 7
Sulu\Bundle\MediaBundle\Entity\FileVersionMeta 7
App\Entity\User 2
Sulu\Bundle\MediaBundle\Entity\Collection 2
Sulu\Bundle\MediaBundle\Entity\CollectionMeta 2
Sulu\Bundle\ContactBundle\Entity\Contact 2
Sulu\Bundle\MediaBundle\Entity\CollectionType 1
App\Entity\Product 1
App\Entity\Ribbon 1

Entities Mapping

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