Query Metrics
28
Database Queries
14
Different statements
75.27 ms
Query time
0
Invalid entities
213
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
45.04 ms (59.84%) |
6 |
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" ] |
||||||||||||||||||||||||||
|
11.46 ms (15.23%) |
6 |
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
]
|
||||||||||||||||||||||||||
|
6.72 ms (8.93%) |
2 |
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" 215 216 "pakom" "hr" "live" 0 "hr" "live" 0 ] |
||||||||||||||||||||||||||
|
3.57 ms (4.74%) |
2 |
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-dd8f-7b81-963e-ddcc8558c659" "hr" "live" 0 "hr" "live" 0 ] |
||||||||||||||||||||||||||
|
1.65 ms (2.19%) |
1 |
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-dd8f-7b81-963e-ddcc8558c659" "hr" "live" 0 ] |
||||||||||||||||||||||||||
|
1.17 ms (1.56%) |
1 |
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 ] |
||||||||||||||||||||||||||
|
0.94 ms (1.24%) |
1 |
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/vanjska-zastita-od-topline/tende/mag" ] |
||||||||||||||||||||||||||
|
0.87 ms (1.15%) |
2 |
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
]
|
||||||||||||||||||||||||||
|
0.84 ms (1.11%) |
2 |
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:
[
425
]
|
||||||||||||||||||||||||||
|
0.77 ms (1.02%) |
1 |
SELECT w0_.title AS title_0, w0_.webspace_key AS webspace_key_1, w0_.all_domains AS all_domains_2, w0_.content AS content_3, w0_.type AS type_4, w0_.id AS id_5, w1_.url AS url_6, w1_.environment AS environment_7, w1_.id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain WHERE (w0_.all_domains = 1 OR (w1_.url = ? AND w1_.environment = ?)) AND w0_.webspace_key = ? ORDER BY w0_.id ASC
Parameters:
[ "new.pakom-el.hr" "dev" "pakom" ] |
||||||||||||||||||||||||||
|
0.65 ms (0.87%) |
1 |
SELECT DISTINCT a0_.size AS size_0 FROM app_product a0_ WHERE a0_.id IN (?, ?, ?, ?) ORDER BY a0_.size ASC
Parameters:
[ 71 72 73 74 ]
|
||||||||||||||||||||||||||
|
0.65 ms (0.86%) |
1 |
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-dd8f-7b81-963e-ddcc8558c659" ] |
||||||||||||||||||||||||||
|
0.54 ms (0.72%) |
1 |
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
]
|
||||||||||||||||||||||||||
|
0.39 ms (0.52%) |
1 |
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:
[
71
]
|
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 | 6 |
| Sulu\Bundle\MediaBundle\Entity\File | 6 |
| Sulu\Bundle\MediaBundle\Entity\FileVersion | 6 |
| Sulu\Bundle\MediaBundle\Entity\FileVersionMeta | 6 |
| App\Entity\User | 2 |
| App\Entity\Product | 1 |
| App\Entity\Ribbon | 1 |
| Sulu\Bundle\ContactBundle\Entity\Contact | 1 |
| Sulu\Bundle\MediaBundle\Entity\Collection | 1 |
| Sulu\Bundle\MediaBundle\Entity\CollectionMeta | 1 |
| Sulu\Bundle\MediaBundle\Entity\CollectionType | 1 |