Query Metrics
30
Database Queries
19
Different statements
28.02 ms
Query time
0
Invalid entities
164
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.88 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 ASC LIMIT 1
Parameters:
[ "website" "pl" "/" ] |
||||||||||||||||||||||||||||||||
| 2 | 2.43 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:
[ "pl" "019dc56d-68ec-73c5-a744-7c8ec2bcfe41" "pl" "live" 0 ] |
||||||||||||||||||||||||||||||||
| 3 | 0.38 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:
[
5
]
|
||||||||||||||||||||||||||||||||
| 4 | 0.12 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:
[
6
]
|
||||||||||||||||||||||||||||||||
| 5 | 1.35 ms |
SELECT DISTINCT a0_.uuid AS uuid_0, a1_.title AS title_1, a1_.workflowPublished AS workflowpublished_2 FROM ar_articles a0_ LEFT JOIN ar_article_dimension_contents a1_ ON (a1_.articleUuid = a0_.uuid) LEFT JOIN ar_article_dimension_content_additional_webspaces a2_ ON a1_.id = a2_.article_dimension_content_id WHERE a1_.locale = ? AND a1_.stage = ? AND a1_.version = ? AND a1_.templateKey IN (?, ?, ?) AND (a1_.mainWebspace = ? OR a2_.name = ?) ORDER BY a1_.workflowPublished DESC
Parameters:
[ "pl" "live" 0 "article" "postlist" "post" "website" "website" ] |
||||||||||||||||||||||||||||||||
| 6 | 0.54 ms |
SELECT COUNT(DISTINCT a0_.uuid) AS sclr_0 FROM ar_articles a0_ LEFT JOIN ar_article_dimension_contents a1_ ON (a1_.articleUuid = a0_.uuid) LEFT JOIN ar_article_dimension_content_additional_webspaces a2_ ON a1_.id = a2_.article_dimension_content_id WHERE a1_.locale = ? AND a1_.stage = ? AND a1_.version = ? AND a1_.templateKey IN (?, ?, ?) AND (a1_.mainWebspace = ? OR a2_.name = ?)
Parameters:
[ "pl" "live" 0 "article" "postlist" "post" "website" "website" ] |
||||||||||||||||||||||||||||||||
| 7 | 2.13 ms |
SELECT a0_.uuid AS uuid_0, a0_.created AS created_1, a0_.changed AS changed_2, a1_.title AS title_3, a1_.customizeWebspaceSettings AS customizewebspacesettings_4, a1_.id AS id_5, a1_.stage AS stage_6, a1_.locale AS locale_7, a1_.ghostLocale AS ghostlocale_8, a1_.availableLocales AS availablelocales_9, a1_.version AS version_10, a1_.shadowLocale AS shadowlocale_11, a1_.shadowLocales AS shadowlocales_12, a1_.templateKey AS templatekey_13, a1_.templateData AS templatedata_14, a1_.seoData AS seodata_15, a1_.seoNoIndex AS seonoindex_16, a1_.seoNoFollow AS seonofollow_17, a1_.seoHideInSitemap AS seohideinsitemap_18, a1_.excerptData AS excerptdata_19, a1_.excerptSegment AS excerptsegment_20, a1_.mainWebspace AS mainwebspace_21, a1_.authored AS authored_22, a1_.lastModified AS lastmodified_23, a1_.workflowPlace AS workflowplace_24, a1_.workflowPublished AS workflowpublished_25, a1_.created AS created_26, a1_.changed AS changed_27, t2_.name AS name_28, t2_.id AS id_29, t2_.created AS created_30, t2_.changed AS changed_31, c3_.category_key AS category_key_32, c3_.default_locale AS default_locale_33, c3_.lft AS lft_34, c3_.rgt AS rgt_35, c3_.depth AS depth_36, c3_.id AS id_37, c3_.created AS created_38, c3_.changed AS changed_39, c4_.translation AS translation_40, c4_.locale AS locale_41, c4_.description AS description_42, c4_.id AS id_43, c4_.created AS created_44, c4_.changed AS changed_45, r5_.webspace AS webspace_46, r5_.locale AS locale_47, r5_.slug AS slug_48, r5_.resource_key AS resource_key_49, r5_.resource_id AS resource_id_50, r5_.id AS id_51, a0_.idUsersCreator AS iduserscreator_52, a0_.idUsersChanger AS iduserschanger_53, a1_.route_id AS route_id_54, a1_.articleUuid AS articleuuid_55, a1_.author_id AS author_id_56, a1_.idUsersCreator AS iduserscreator_57, a1_.idUsersChanger AS iduserschanger_58, t2_.idUsersCreator AS iduserscreator_59, t2_.idUsersChanger AS iduserschanger_60, c3_.idCategoriesParent AS idcategoriesparent_61, c3_.idUsersCreator AS iduserscreator_62, c3_.idUsersChanger AS iduserschanger_63, c4_.idCategories AS idcategories_64, c4_.idUsersCreator AS iduserscreator_65, c4_.idUsersChanger AS iduserschanger_66, r5_.parent_id AS parent_id_67 FROM ar_articles a0_ LEFT JOIN ar_article_dimension_contents a6_ ON (a6_.articleUuid = a0_.uuid) LEFT JOIN ar_article_dimension_contents a1_ ON a0_.uuid = a1_.articleUuid LEFT JOIN ar_article_dimension_content_excerpt_tags a7_ ON a1_.id = a7_.article_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = a7_.tag_id LEFT JOIN ar_article_dimension_content_excerpt_categories a8_ ON a1_.id = a8_.article_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = a8_.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 a1_.route_id = r5_.id WHERE a0_.uuid IN (?, ?, ?, ?) AND a6_.locale = ? AND a6_.stage = ? AND a6_.version = ? AND (((a1_.locale IS NULL OR a1_.locale IN (?)) AND (a1_.stage IS NULL OR a1_.stage IN (?))) AND (a1_.version IS NULL OR a1_.version IN (?)))
Parameters:
[ "pl" "019dcbff-58cf-7c21-8604-42d3b1aa35bc" "019dcbf0-c793-7505-b874-7733864057cb" "019dcbb4-16e0-7c9d-9a23-4c8ae308954c" "019dcba6-bd26-7eae-bd3e-0ec04ff8aa6e" "pl" "live" 0 "pl" "live" 0 ] |
||||||||||||||||||||||||||||||||
| 8 | 0.21 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.article_dimension_content_id AS article_dimension_content_id_3 FROM ar_article_dimension_content_additional_webspaces t0 WHERE t0.article_dimension_content_id = ?
Parameters:
[
5
]
|
||||||||||||||||||||||||||||||||
| 9 | 0.09 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.article_dimension_content_id AS article_dimension_content_id_3 FROM ar_article_dimension_content_additional_webspaces t0 WHERE t0.article_dimension_content_id = ?
Parameters:
[
6
]
|
||||||||||||||||||||||||||||||||
| 10 | 0.15 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.article_dimension_content_id AS article_dimension_content_id_3 FROM ar_article_dimension_content_additional_webspaces t0 WHERE t0.article_dimension_content_id = ?
Parameters:
[
35
]
|
||||||||||||||||||||||||||||||||
| 11 | 0.08 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.article_dimension_content_id AS article_dimension_content_id_3 FROM ar_article_dimension_content_additional_webspaces t0 WHERE t0.article_dimension_content_id = ?
Parameters:
[
36
]
|
||||||||||||||||||||||||||||||||
| 12 | 0.08 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.article_dimension_content_id AS article_dimension_content_id_3 FROM ar_article_dimension_content_additional_webspaces t0 WHERE t0.article_dimension_content_id = ?
Parameters:
[
15
]
|
||||||||||||||||||||||||||||||||
| 13 | 0.07 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.article_dimension_content_id AS article_dimension_content_id_3 FROM ar_article_dimension_content_additional_webspaces t0 WHERE t0.article_dimension_content_id = ?
Parameters:
[
16
]
|
||||||||||||||||||||||||||||||||
| 14 | 0.08 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.article_dimension_content_id AS article_dimension_content_id_3 FROM ar_article_dimension_content_additional_webspaces t0 WHERE t0.article_dimension_content_id = ?
Parameters:
[
59
]
|
||||||||||||||||||||||||||||||||
| 15 | 0.07 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.article_dimension_content_id AS article_dimension_content_id_3 FROM ar_article_dimension_content_additional_webspaces t0 WHERE t0.article_dimension_content_id = ?
Parameters:
[
60
]
|
||||||||||||||||||||||||||||||||
| 16 | 0.13 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.created AS created_3, t0.changed AS changed_4, t0.idUsersCreator AS iduserscreator_5, t0.idUsersChanger AS iduserschanger_6 FROM ta_tags t0 WHERE t0.name IN (?, ?, ?, ?)
Parameters:
[ "Santi" "nurkowanie" "testy" "nurkowanie podlodowe" ] |
||||||||||||||||||||||||||||||||
| 17 | 3.68 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_.id AS id_26, m3_.created AS created_27, m3_.changed AS changed_28, t4_.name AS name_29, t4_.id AS id_30, t4_.created AS created_31, t4_.changed AS changed_32, m5_.title AS title_33, m5_.description AS description_34, m5_.copyright AS copyright_35, m5_.credits AS credits_36, m5_.locale AS locale_37, m5_.id AS id_38, m6_.title AS title_39, m6_.description AS description_40, m6_.copyright AS copyright_41, m6_.credits AS credits_42, m6_.locale AS locale_43, m6_.id AS id_44, s7_.username AS username_45, s7_.password AS password_46, s7_.locale AS locale_47, s7_.salt AS salt_48, s7_.locked AS locked_49, s7_.enabled AS enabled_50, s7_.lastLogin AS lastlogin_51, s7_.confirmationKey AS confirmationkey_52, s7_.passwordResetToken AS passwordresettoken_53, s7_.passwordResetTokenExpiresAt AS passwordresettokenexpiresat_54, s7_.passwordResetTokenEmailsSent AS passwordresettokenemailssent_55, s7_.privateKey AS privatekey_56, s7_.apiKey AS apikey_57, s7_.email AS email_58, s7_.id AS id_59, s7_.created AS created_60, s7_.changed AS changed_61, c8_.firstName AS firstname_62, c8_.middleName AS middlename_63, c8_.lastName AS lastname_64, c8_.birthday AS birthday_65, c8_.salutation AS salutation_66, c8_.formOfAddress AS formofaddress_67, c8_.newsletter AS newsletter_68, c8_.gender AS gender_69, c8_.note AS note_70, c8_.mainEmail AS mainemail_71, c8_.mainPhone AS mainphone_72, c8_.mainFax AS mainfax_73, c8_.mainUrl AS mainurl_74, c8_.id AS id_75, c8_.created AS created_76, c8_.changed AS changed_77, s9_.username AS username_78, s9_.password AS password_79, s9_.locale AS locale_80, s9_.salt AS salt_81, s9_.locked AS locked_82, s9_.enabled AS enabled_83, s9_.lastLogin AS lastlogin_84, s9_.confirmationKey AS confirmationkey_85, s9_.passwordResetToken AS passwordresettoken_86, s9_.passwordResetTokenExpiresAt AS passwordresettokenexpiresat_87, s9_.passwordResetTokenEmailsSent AS passwordresettokenemailssent_88, s9_.privateKey AS privatekey_89, s9_.apiKey AS apikey_90, s9_.email AS email_91, s9_.id AS id_92, s9_.created AS created_93, s9_.changed AS changed_94, c10_.firstName AS firstname_95, c10_.middleName AS middlename_96, c10_.lastName AS lastname_97, c10_.birthday AS birthday_98, c10_.salutation AS salutation_99, c10_.formOfAddress AS formofaddress_100, c10_.newsletter AS newsletter_101, c10_.gender AS gender_102, c10_.note AS note_103, c10_.mainEmail AS mainemail_104, c10_.mainPhone AS mainphone_105, c10_.mainFax AS mainfax_106, c10_.mainUrl AS mainurl_107, c10_.id AS id_108, c10_.created AS created_109, c10_.changed AS changed_110, m0_.idPreviewImage AS idpreviewimage_111, m0_.idCollections AS idcollections_112, m0_.idUsersCreator AS iduserscreator_113, m0_.idUsersChanger AS iduserschanger_114, m1_.idCollectionsMetaDefault AS idcollectionsmetadefault_115, m1_.idCollectionTypes AS idcollectiontypes_116, m1_.idCollectionsParent AS idcollectionsparent_117, m1_.idUsersCreator AS iduserscreator_118, m1_.idUsersChanger AS iduserschanger_119, m2_.idMedia AS idmedia_120, m2_.idUsersCreator AS iduserscreator_121, m2_.idUsersChanger AS iduserschanger_122, m3_.idFileVersionsMetaDefault AS idfileversionsmetadefault_123, m3_.idFiles AS idfiles_124, m3_.idUsersCreator AS iduserscreator_125, m3_.idUsersChanger AS iduserschanger_126, t4_.idUsersCreator AS iduserscreator_127, t4_.idUsersChanger AS iduserschanger_128, m5_.idFileVersions AS idfileversions_129, m6_.idFileVersions AS idfileversions_130, s7_.idContacts AS idcontacts_131, s7_.idUsersCreator AS iduserscreator_132, s7_.idUsersChanger AS iduserschanger_133, c8_.idTitles AS idtitles_134, c8_.avatar AS avatar_135, c8_.idUsersCreator AS iduserscreator_136, c8_.idUsersChanger AS iduserschanger_137, s9_.idContacts AS idcontacts_138, s9_.idUsersCreator AS iduserscreator_139, s9_.idUsersChanger AS iduserschanger_140, c10_.idTitles AS idtitles_141, c10_.avatar AS avatar_142, c10_.idUsersCreator AS iduserscreator_143, c10_.idUsersChanger AS iduserschanger_144 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:
[ 65 98 100 104 102 ] |
||||||||||||||||||||||||||||||||
| 18 | 0.27 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
]
|
||||||||||||||||||||||||||||||||
| 19 | 0.23 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:
[ "pl" "pages" "019dc56d-68ec-73c5-a744-7c8ec2bcfe41" ]
|
||||||||||||||||||||||||||||||||
| 20 | 2.44 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:
[ "pl" "website" 2 "pl" "live" 0 "pl" "live" 0 "main" ] |
||||||||||||||||||||||||||||||||
| 21 | 2.18 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:
[ "pl" "website" 2 "pl" "live" 0 "pl" "live" 0 "main" ] |
||||||||||||||||||||||||||||||||
| 22 | 0.36 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.author_name AS author_name_4, t0.visibility AS visibility_5, t0.allowed_user_ids AS allowed_user_ids_6, t0.exif_enabled AS exif_enabled_7 FROM app_gallery t0 WHERE t0.id = ?
Parameters:
[
"686801a6-92c5-4c31-8ffd-3ba7f92850bc"
]
|
||||||||||||||||||||||||||||||||
| 23 | 0.29 ms |
SELECT t0.id AS id_1, t0.media_id AS media_id_2, t0.position AS position_3, t0.exif_json AS exif_json_4, t0.gallery_id AS gallery_id_5 FROM app_gallery_image t0 WHERE t0.gallery_id = ? ORDER BY t0.position ASC
Parameters:
[
"686801a6-92c5-4c31-8ffd-3ba7f92850bc"
]
|
||||||||||||||||||||||||||||||||
| 24 | 1.96 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_.id AS id_26, m3_.created AS created_27, m3_.changed AS changed_28, m4_.crop_x AS crop_x_29, m4_.crop_y AS crop_y_30, m4_.crop_width AS crop_width_31, m4_.crop_height AS crop_height_32, m4_.format_key AS format_key_33, m5_.title AS title_34, m5_.description AS description_35, m5_.copyright AS copyright_36, m5_.credits AS credits_37, m5_.locale AS locale_38, m5_.id AS id_39, m6_.title AS title_40, m6_.description AS description_41, m6_.copyright AS copyright_42, m6_.credits AS credits_43, m6_.locale AS locale_44, m6_.id AS id_45, s7_.username AS username_46, s7_.password AS password_47, s7_.locale AS locale_48, s7_.salt AS salt_49, s7_.locked AS locked_50, s7_.enabled AS enabled_51, s7_.lastLogin AS lastlogin_52, s7_.confirmationKey AS confirmationkey_53, s7_.passwordResetToken AS passwordresettoken_54, s7_.passwordResetTokenExpiresAt AS passwordresettokenexpiresat_55, s7_.passwordResetTokenEmailsSent AS passwordresettokenemailssent_56, s7_.privateKey AS privatekey_57, s7_.apiKey AS apikey_58, s7_.email AS email_59, s7_.id AS id_60, s7_.created AS created_61, s7_.changed AS changed_62, c8_.firstName AS firstname_63, c8_.middleName AS middlename_64, c8_.lastName AS lastname_65, c8_.birthday AS birthday_66, c8_.salutation AS salutation_67, c8_.formOfAddress AS formofaddress_68, c8_.newsletter AS newsletter_69, c8_.gender AS gender_70, c8_.note AS note_71, c8_.mainEmail AS mainemail_72, c8_.mainPhone AS mainphone_73, c8_.mainFax AS mainfax_74, c8_.mainUrl AS mainurl_75, c8_.id AS id_76, c8_.created AS created_77, c8_.changed AS changed_78, s9_.username AS username_79, s9_.password AS password_80, s9_.locale AS locale_81, s9_.salt AS salt_82, s9_.locked AS locked_83, s9_.enabled AS enabled_84, s9_.lastLogin AS lastlogin_85, s9_.confirmationKey AS confirmationkey_86, s9_.passwordResetToken AS passwordresettoken_87, s9_.passwordResetTokenExpiresAt AS passwordresettokenexpiresat_88, s9_.passwordResetTokenEmailsSent AS passwordresettokenemailssent_89, s9_.privateKey AS privatekey_90, s9_.apiKey AS apikey_91, s9_.email AS email_92, s9_.id AS id_93, s9_.created AS created_94, s9_.changed AS changed_95, c10_.firstName AS firstname_96, c10_.middleName AS middlename_97, c10_.lastName AS lastname_98, c10_.birthday AS birthday_99, c10_.salutation AS salutation_100, c10_.formOfAddress AS formofaddress_101, c10_.newsletter AS newsletter_102, c10_.gender AS gender_103, c10_.note AS note_104, c10_.mainEmail AS mainemail_105, c10_.mainPhone AS mainphone_106, c10_.mainFax AS mainfax_107, c10_.mainUrl AS mainurl_108, c10_.id AS id_109, c10_.created AS created_110, c10_.changed AS changed_111, m11_.type AS type_112, m11_.id AS id_113, m11_.created AS created_114, m11_.changed AS changed_115, m0_.idPreviewImage AS idpreviewimage_116, m0_.idCollections AS idcollections_117, m0_.idUsersCreator AS iduserscreator_118, m0_.idUsersChanger AS iduserschanger_119, m1_.idCollectionsMetaDefault AS idcollectionsmetadefault_120, m1_.idCollectionTypes AS idcollectiontypes_121, m1_.idCollectionsParent AS idcollectionsparent_122, m1_.idUsersCreator AS iduserscreator_123, m1_.idUsersChanger AS iduserschanger_124, m2_.idMedia AS idmedia_125, m2_.idUsersCreator AS iduserscreator_126, m2_.idUsersChanger AS iduserschanger_127, m3_.idFileVersionsMetaDefault AS idfileversionsmetadefault_128, m3_.idFiles AS idfiles_129, m3_.idUsersCreator AS iduserscreator_130, m3_.idUsersChanger AS iduserschanger_131, m4_.fileVersion AS fileversion_132, m5_.idFileVersions AS idfileversions_133, m6_.idFileVersions AS idfileversions_134, s7_.idContacts AS idcontacts_135, s7_.idUsersCreator AS iduserscreator_136, s7_.idUsersChanger AS iduserschanger_137, c8_.idTitles AS idtitles_138, c8_.avatar AS avatar_139, c8_.idUsersCreator AS iduserscreator_140, c8_.idUsersChanger AS iduserschanger_141, s9_.idContacts AS idcontacts_142, s9_.idUsersCreator AS iduserscreator_143, s9_.idUsersChanger AS iduserschanger_144, c10_.idTitles AS idtitles_145, c10_.avatar AS avatar_146, c10_.idUsersCreator AS iduserscreator_147, c10_.idUsersChanger AS iduserschanger_148, m11_.idPreviewImage AS idpreviewimage_149, m11_.idCollections AS idcollections_150, m11_.idUsersCreator AS iduserscreator_151, m11_.idUsersChanger AS iduserschanger_152 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id LEFT JOIN me_files m2_ ON m0_.id = m2_.idMedia LEFT JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles LEFT JOIN me_format_options m4_ ON m3_.id = m4_.fileVersion LEFT JOIN me_file_version_meta m5_ ON m3_.id = m5_.idFileVersions LEFT JOIN me_file_version_meta m6_ ON m3_.idFileVersionsMetaDefault = m6_.id LEFT JOIN se_users s7_ ON m0_.idUsersCreator = s7_.id LEFT JOIN co_contacts c8_ ON s7_.idContacts = c8_.id LEFT JOIN se_users s9_ ON m0_.idUsersChanger = s9_.id LEFT JOIN co_contacts c10_ ON s9_.idContacts = c10_.id LEFT JOIN me_media m11_ ON m0_.idPreviewImage = m11_.id WHERE m0_.id = ?
Parameters:
[
126
]
|
||||||||||||||||||||||||||||||||
| 25 | 1.78 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_.id AS id_26, m3_.created AS created_27, m3_.changed AS changed_28, m4_.crop_x AS crop_x_29, m4_.crop_y AS crop_y_30, m4_.crop_width AS crop_width_31, m4_.crop_height AS crop_height_32, m4_.format_key AS format_key_33, m5_.title AS title_34, m5_.description AS description_35, m5_.copyright AS copyright_36, m5_.credits AS credits_37, m5_.locale AS locale_38, m5_.id AS id_39, m6_.title AS title_40, m6_.description AS description_41, m6_.copyright AS copyright_42, m6_.credits AS credits_43, m6_.locale AS locale_44, m6_.id AS id_45, s7_.username AS username_46, s7_.password AS password_47, s7_.locale AS locale_48, s7_.salt AS salt_49, s7_.locked AS locked_50, s7_.enabled AS enabled_51, s7_.lastLogin AS lastlogin_52, s7_.confirmationKey AS confirmationkey_53, s7_.passwordResetToken AS passwordresettoken_54, s7_.passwordResetTokenExpiresAt AS passwordresettokenexpiresat_55, s7_.passwordResetTokenEmailsSent AS passwordresettokenemailssent_56, s7_.privateKey AS privatekey_57, s7_.apiKey AS apikey_58, s7_.email AS email_59, s7_.id AS id_60, s7_.created AS created_61, s7_.changed AS changed_62, c8_.firstName AS firstname_63, c8_.middleName AS middlename_64, c8_.lastName AS lastname_65, c8_.birthday AS birthday_66, c8_.salutation AS salutation_67, c8_.formOfAddress AS formofaddress_68, c8_.newsletter AS newsletter_69, c8_.gender AS gender_70, c8_.note AS note_71, c8_.mainEmail AS mainemail_72, c8_.mainPhone AS mainphone_73, c8_.mainFax AS mainfax_74, c8_.mainUrl AS mainurl_75, c8_.id AS id_76, c8_.created AS created_77, c8_.changed AS changed_78, s9_.username AS username_79, s9_.password AS password_80, s9_.locale AS locale_81, s9_.salt AS salt_82, s9_.locked AS locked_83, s9_.enabled AS enabled_84, s9_.lastLogin AS lastlogin_85, s9_.confirmationKey AS confirmationkey_86, s9_.passwordResetToken AS passwordresettoken_87, s9_.passwordResetTokenExpiresAt AS passwordresettokenexpiresat_88, s9_.passwordResetTokenEmailsSent AS passwordresettokenemailssent_89, s9_.privateKey AS privatekey_90, s9_.apiKey AS apikey_91, s9_.email AS email_92, s9_.id AS id_93, s9_.created AS created_94, s9_.changed AS changed_95, c10_.firstName AS firstname_96, c10_.middleName AS middlename_97, c10_.lastName AS lastname_98, c10_.birthday AS birthday_99, c10_.salutation AS salutation_100, c10_.formOfAddress AS formofaddress_101, c10_.newsletter AS newsletter_102, c10_.gender AS gender_103, c10_.note AS note_104, c10_.mainEmail AS mainemail_105, c10_.mainPhone AS mainphone_106, c10_.mainFax AS mainfax_107, c10_.mainUrl AS mainurl_108, c10_.id AS id_109, c10_.created AS created_110, c10_.changed AS changed_111, m11_.type AS type_112, m11_.id AS id_113, m11_.created AS created_114, m11_.changed AS changed_115, m0_.idPreviewImage AS idpreviewimage_116, m0_.idCollections AS idcollections_117, m0_.idUsersCreator AS iduserscreator_118, m0_.idUsersChanger AS iduserschanger_119, m1_.idCollectionsMetaDefault AS idcollectionsmetadefault_120, m1_.idCollectionTypes AS idcollectiontypes_121, m1_.idCollectionsParent AS idcollectionsparent_122, m1_.idUsersCreator AS iduserscreator_123, m1_.idUsersChanger AS iduserschanger_124, m2_.idMedia AS idmedia_125, m2_.idUsersCreator AS iduserscreator_126, m2_.idUsersChanger AS iduserschanger_127, m3_.idFileVersionsMetaDefault AS idfileversionsmetadefault_128, m3_.idFiles AS idfiles_129, m3_.idUsersCreator AS iduserscreator_130, m3_.idUsersChanger AS iduserschanger_131, m4_.fileVersion AS fileversion_132, m5_.idFileVersions AS idfileversions_133, m6_.idFileVersions AS idfileversions_134, s7_.idContacts AS idcontacts_135, s7_.idUsersCreator AS iduserscreator_136, s7_.idUsersChanger AS iduserschanger_137, c8_.idTitles AS idtitles_138, c8_.avatar AS avatar_139, c8_.idUsersCreator AS iduserscreator_140, c8_.idUsersChanger AS iduserschanger_141, s9_.idContacts AS idcontacts_142, s9_.idUsersCreator AS iduserscreator_143, s9_.idUsersChanger AS iduserschanger_144, c10_.idTitles AS idtitles_145, c10_.avatar AS avatar_146, c10_.idUsersCreator AS iduserscreator_147, c10_.idUsersChanger AS iduserschanger_148, m11_.idPreviewImage AS idpreviewimage_149, m11_.idCollections AS idcollections_150, m11_.idUsersCreator AS iduserscreator_151, m11_.idUsersChanger AS iduserschanger_152 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id LEFT JOIN me_files m2_ ON m0_.id = m2_.idMedia LEFT JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles LEFT JOIN me_format_options m4_ ON m3_.id = m4_.fileVersion LEFT JOIN me_file_version_meta m5_ ON m3_.id = m5_.idFileVersions LEFT JOIN me_file_version_meta m6_ ON m3_.idFileVersionsMetaDefault = m6_.id LEFT JOIN se_users s7_ ON m0_.idUsersCreator = s7_.id LEFT JOIN co_contacts c8_ ON s7_.idContacts = c8_.id LEFT JOIN se_users s9_ ON m0_.idUsersChanger = s9_.id LEFT JOIN co_contacts c10_ ON s9_.idContacts = c10_.id LEFT JOIN me_media m11_ ON m0_.idPreviewImage = m11_.id WHERE m0_.id = ?
Parameters:
[
127
]
|
||||||||||||||||||||||||||||||||
| 26 | 0.21 ms |
SELECT s0_.webspace_key AS webspace_key_0, s0_.area_key AS area_key_1, s0_.uuid AS uuid_2, s0_.idSnippet AS idsnippet_3 FROM sn_snippet_area s0_ WHERE s0_.webspace_key = ? AND s0_.area_key = ?
Parameters:
[ "website" "footer" ] |
||||||||||||||||||||||||||||||||
| 27 | 1.53 ms |
SELECT s0_.uuid AS uuid_0, s0_.created AS created_1, s0_.changed AS changed_2, s1_.title AS title_3, s1_.id AS id_4, s1_.stage AS stage_5, s1_.locale AS locale_6, s1_.ghostLocale AS ghostlocale_7, s1_.availableLocales AS availablelocales_8, s1_.version AS version_9, s1_.templateKey AS templatekey_10, s1_.templateData AS templatedata_11, s1_.excerptSegment AS excerptsegment_12, s1_.workflowPlace AS workflowplace_13, s1_.workflowPublished AS workflowpublished_14, s1_.created AS created_15, s1_.changed AS changed_16, t2_.name AS name_17, t2_.id AS id_18, t2_.created AS created_19, t2_.changed AS changed_20, c3_.category_key AS category_key_21, c3_.default_locale AS default_locale_22, c3_.lft AS lft_23, c3_.rgt AS rgt_24, c3_.depth AS depth_25, c3_.id AS id_26, c3_.created AS created_27, c3_.changed AS changed_28, c4_.translation AS translation_29, c4_.locale AS locale_30, c4_.description AS description_31, c4_.id AS id_32, c4_.created AS created_33, c4_.changed AS changed_34, s0_.idUsersCreator AS iduserscreator_35, s0_.idUsersChanger AS iduserschanger_36, s1_.snippetUuid AS snippetuuid_37, s1_.idUsersCreator AS iduserscreator_38, s1_.idUsersChanger AS iduserschanger_39, t2_.idUsersCreator AS iduserscreator_40, t2_.idUsersChanger AS iduserschanger_41, c3_.idCategoriesParent AS idcategoriesparent_42, c3_.idUsersCreator AS iduserscreator_43, c3_.idUsersChanger AS iduserschanger_44, c4_.idCategories AS idcategories_45, c4_.idUsersCreator AS iduserscreator_46, c4_.idUsersChanger AS iduserschanger_47 FROM sn_snippets s0_ LEFT JOIN sn_snippet_dimension_contents s5_ ON (s5_.snippetUuid = s0_.uuid) LEFT JOIN sn_snippet_dimension_contents s1_ ON s0_.uuid = s1_.snippetUuid LEFT JOIN sn_snippet_dimension_content_excerpt_tags s6_ ON s1_.id = s6_.snippet_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = s6_.tag_id LEFT JOIN sn_snippet_dimension_content_excerpt_categories s7_ ON s1_.id = s7_.snippet_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = s7_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories AND (c4_.locale = c3_.default_locale OR c4_.locale IN (?)) WHERE s0_.uuid = ? AND s5_.locale = ? AND s5_.stage = ? AND s5_.version = ? AND (((s1_.locale IS NULL OR s1_.locale IN (?)) AND (s1_.stage IS NULL OR s1_.stage IN (?))) AND (s1_.version IS NULL OR s1_.version IN (?)))
Parameters:
[ "pl" "019dc9b1-4673-7509-a45f-18f25a4eefa0" "pl" "live" 0 "pl" "live" 0 ] |
||||||||||||||||||||||||||||||||
| 28 | 1.94 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_.id AS id_26, m3_.created AS created_27, m3_.changed AS changed_28, t4_.name AS name_29, t4_.id AS id_30, t4_.created AS created_31, t4_.changed AS changed_32, m5_.title AS title_33, m5_.description AS description_34, m5_.copyright AS copyright_35, m5_.credits AS credits_36, m5_.locale AS locale_37, m5_.id AS id_38, m6_.title AS title_39, m6_.description AS description_40, m6_.copyright AS copyright_41, m6_.credits AS credits_42, m6_.locale AS locale_43, m6_.id AS id_44, s7_.username AS username_45, s7_.password AS password_46, s7_.locale AS locale_47, s7_.salt AS salt_48, s7_.locked AS locked_49, s7_.enabled AS enabled_50, s7_.lastLogin AS lastlogin_51, s7_.confirmationKey AS confirmationkey_52, s7_.passwordResetToken AS passwordresettoken_53, s7_.passwordResetTokenExpiresAt AS passwordresettokenexpiresat_54, s7_.passwordResetTokenEmailsSent AS passwordresettokenemailssent_55, s7_.privateKey AS privatekey_56, s7_.apiKey AS apikey_57, s7_.email AS email_58, s7_.id AS id_59, s7_.created AS created_60, s7_.changed AS changed_61, c8_.firstName AS firstname_62, c8_.middleName AS middlename_63, c8_.lastName AS lastname_64, c8_.birthday AS birthday_65, c8_.salutation AS salutation_66, c8_.formOfAddress AS formofaddress_67, c8_.newsletter AS newsletter_68, c8_.gender AS gender_69, c8_.note AS note_70, c8_.mainEmail AS mainemail_71, c8_.mainPhone AS mainphone_72, c8_.mainFax AS mainfax_73, c8_.mainUrl AS mainurl_74, c8_.id AS id_75, c8_.created AS created_76, c8_.changed AS changed_77, s9_.username AS username_78, s9_.password AS password_79, s9_.locale AS locale_80, s9_.salt AS salt_81, s9_.locked AS locked_82, s9_.enabled AS enabled_83, s9_.lastLogin AS lastlogin_84, s9_.confirmationKey AS confirmationkey_85, s9_.passwordResetToken AS passwordresettoken_86, s9_.passwordResetTokenExpiresAt AS passwordresettokenexpiresat_87, s9_.passwordResetTokenEmailsSent AS passwordresettokenemailssent_88, s9_.privateKey AS privatekey_89, s9_.apiKey AS apikey_90, s9_.email AS email_91, s9_.id AS id_92, s9_.created AS created_93, s9_.changed AS changed_94, c10_.firstName AS firstname_95, c10_.middleName AS middlename_96, c10_.lastName AS lastname_97, c10_.birthday AS birthday_98, c10_.salutation AS salutation_99, c10_.formOfAddress AS formofaddress_100, c10_.newsletter AS newsletter_101, c10_.gender AS gender_102, c10_.note AS note_103, c10_.mainEmail AS mainemail_104, c10_.mainPhone AS mainphone_105, c10_.mainFax AS mainfax_106, c10_.mainUrl AS mainurl_107, c10_.id AS id_108, c10_.created AS created_109, c10_.changed AS changed_110, m0_.idPreviewImage AS idpreviewimage_111, m0_.idCollections AS idcollections_112, m0_.idUsersCreator AS iduserscreator_113, m0_.idUsersChanger AS iduserschanger_114, m1_.idCollectionsMetaDefault AS idcollectionsmetadefault_115, m1_.idCollectionTypes AS idcollectiontypes_116, m1_.idCollectionsParent AS idcollectionsparent_117, m1_.idUsersCreator AS iduserscreator_118, m1_.idUsersChanger AS iduserschanger_119, m2_.idMedia AS idmedia_120, m2_.idUsersCreator AS iduserscreator_121, m2_.idUsersChanger AS iduserschanger_122, m3_.idFileVersionsMetaDefault AS idfileversionsmetadefault_123, m3_.idFiles AS idfiles_124, m3_.idUsersCreator AS iduserscreator_125, m3_.idUsersChanger AS iduserschanger_126, t4_.idUsersCreator AS iduserscreator_127, t4_.idUsersChanger AS iduserschanger_128, m5_.idFileVersions AS idfileversions_129, m6_.idFileVersions AS idfileversions_130, s7_.idContacts AS idcontacts_131, s7_.idUsersCreator AS iduserscreator_132, s7_.idUsersChanger AS iduserschanger_133, c8_.idTitles AS idtitles_134, c8_.avatar AS avatar_135, c8_.idUsersCreator AS iduserscreator_136, c8_.idUsersChanger AS iduserschanger_137, s9_.idContacts AS idcontacts_138, s9_.idUsersCreator AS iduserscreator_139, s9_.idUsersChanger AS iduserschanger_140, c10_.idTitles AS idtitles_141, c10_.avatar AS avatar_142, c10_.idUsersCreator AS iduserscreator_143, c10_.idUsersChanger AS iduserschanger_144 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:
[
61
]
|
||||||||||||||||||||||||||||||||
| 29 | 1.78 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:
[ "pl" "website" 1 "pl" "live" 0 "pl" "live" 0 "footer" ] |
||||||||||||||||||||||||||||||||
| 30 | 0.60 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 = true OR (w1_.url = ? AND w1_.environment = ?)) AND w0_.webspace_key = ? ORDER BY w0_.id ASC
Parameters:
[ "www.test.maciej-markowski.com" "dev" "website" ]
|
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 | 32 |
| Sulu\Route\Domain\Model\Route | 20 |
| Sulu\Page\Domain\Model\PageDimensionContentNavigationContext | 18 |
| Sulu\Page\Domain\Model\Page | 16 |
| Sulu\Bundle\MediaBundle\Entity\Media | 9 |
| Sulu\Article\Domain\Model\ArticleDimensionContent | 8 |
| Sulu\Bundle\MediaBundle\Entity\File | 8 |
| Sulu\Bundle\MediaBundle\Entity\FileVersion | 8 |
| Sulu\Bundle\MediaBundle\Entity\FileVersionMeta | 8 |
| Sulu\Bundle\MediaBundle\Entity\Collection | 6 |
| Sulu\Bundle\MediaBundle\Entity\CollectionMeta | 5 |
| Sulu\Article\Domain\Model\Article | 4 |
| Sulu\Bundle\TagBundle\Entity\Tag | 4 |
| Sulu\Bundle\CategoryBundle\Entity\Category | 4 |
| Sulu\Bundle\CategoryBundle\Entity\CategoryTranslation | 4 |
| SkinnyDevOps\GalleryBundle\Entity\GalleryImage | 2 |
| Sulu\Snippet\Domain\Model\SnippetDimensionContent | 2 |
| Sulu\Bundle\SecurityBundle\Entity\User | 1 |
| Sulu\Bundle\ContactBundle\Entity\Contact | 1 |
| Sulu\Bundle\MediaBundle\Entity\CollectionType | 1 |
| SkinnyDevOps\GalleryBundle\Entity\Gallery | 1 |
| Sulu\Snippet\Domain\Model\SnippetArea | 1 |
| Sulu\Snippet\Domain\Model\Snippet | 1 |