Query Metrics
29
Database Queries
16
Different statements
39.31 ms
Query time
0
Invalid entities
58
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
10.11 ms (25.73%) |
1 |
SELECT c0_.firstName AS firstName_0, c0_.middleName AS middleName_1, c0_.lastName AS lastName_2, c0_.birthday AS birthday_3, c0_.salutation AS salutation_4, c0_.formOfAddress AS formOfAddress_5, c0_.newsletter AS newsletter_6, c0_.gender AS gender_7, c0_.note AS note_8, c0_.mainEmail AS mainEmail_9, c0_.mainPhone AS mainPhone_10, c0_.mainFax AS mainFax_11, c0_.mainUrl AS mainUrl_12, c0_.id AS id_13, c0_.created AS created_14, c0_.changed AS changed_15, c1_.main AS main_16, c1_.id AS id_17, c2_.lft AS lft_18, c2_.rgt AS rgt_19, c2_.depth AS depth_20, c2_.name AS name_21, c2_.externalId AS externalId_22, c2_.number AS number_23, c2_.corporation AS corporation_24, c2_.note AS note_25, c2_.uid AS uid_26, c2_.registerNumber AS registerNumber_27, c2_.placeOfJurisdiction AS placeOfJurisdiction_28, c2_.mainEmail AS mainEmail_29, c2_.mainPhone AS mainPhone_30, c2_.mainFax AS mainFax_31, c2_.mainUrl AS mainUrl_32, c2_.id AS id_33, c2_.created AS created_34, c2_.changed AS changed_35, c3_.firstName AS firstName_36, c3_.middleName AS middleName_37, c3_.lastName AS lastName_38, c3_.birthday AS birthday_39, c3_.salutation AS salutation_40, c3_.formOfAddress AS formOfAddress_41, c3_.newsletter AS newsletter_42, c3_.gender AS gender_43, c3_.note AS note_44, c3_.mainEmail AS mainEmail_45, c3_.mainPhone AS mainPhone_46, c3_.mainFax AS mainFax_47, c3_.mainUrl AS mainUrl_48, c3_.id AS id_49, c3_.created AS created_50, c3_.changed AS changed_51, c4_.main AS main_52, c4_.id AS id_53, c5_.title AS title_54, c5_.primaryAddress AS primaryAddress_55, c5_.deliveryAddress AS deliveryAddress_56, c5_.billingAddress AS billingAddress_57, c5_.street AS street_58, c5_.number AS number_59, c5_.addition AS addition_60, c5_.zip AS zip_61, c5_.city AS city_62, c5_.state AS state_63, c5_.countryCode AS countryCode_64, c5_.postboxNumber AS postboxNumber_65, c5_.postboxPostcode AS postboxPostcode_66, c5_.postboxCity AS postboxCity_67, c5_.latitude AS latitude_68, c5_.longitude AS longitude_69, c5_.note AS note_70, c5_.id AS id_71, c6_.name AS name_72, c6_.id AS id_73, c7_.locale AS locale_74, c7_.id AS id_75, c8_.email AS email_76, c8_.id AS id_77, c9_.name AS name_78, c9_.id AS id_79, c10_.fax AS fax_80, c10_.id AS id_81, c11_.name AS name_82, c11_.id AS id_83, c12_.value AS value_84, c12_.id AS id_85, c13_.phone AS phone_86, c13_.id AS id_87, c14_.name AS name_88, c14_.id AS id_89, t15_.name AS name_90, t15_.id AS id_91, c16_.url AS url_92, c16_.id AS id_93, c17_.name AS name_94, c17_.id AS id_95, c18_.title AS title_96, c18_.id AS id_97, c19_.position AS position_98, c19_.id AS id_99, m20_.type AS type_100, m20_.id AS id_101, m20_.created AS created_102, m20_.changed AS changed_103, c21_.category_key AS category_key_104, c21_.default_locale AS default_locale_105, c21_.lft AS lft_106, c21_.rgt AS rgt_107, c21_.depth AS depth_108, c21_.id AS id_109, c21_.created AS created_110, c21_.changed AS changed_111, c22_.translation AS translation_112, c22_.locale AS locale_113, c22_.description AS description_114, c22_.id AS id_115, c22_.created AS created_116, c22_.changed AS changed_117, c23_.bankName AS bankName_118, c23_.bic AS bic_119, c23_.iban AS iban_120, c23_.public AS public_121, c23_.id AS id_122, c0_.idTitles AS idTitles_123, c0_.avatar AS avatar_124, c0_.idUsersCreator AS idUsersCreator_125, c0_.idUsersChanger AS idUsersChanger_126, c1_.idPositions AS idPositions_127, c1_.idContacts AS idContacts_128, c1_.idAccounts AS idAccounts_129, c2_.idContactsMain AS idContactsMain_130, c2_.idAccountsParent AS idAccountsParent_131, c2_.logo AS logo_132, c2_.idUsersCreator AS idUsersCreator_133, c2_.idUsersChanger AS idUsersChanger_134, c3_.idTitles AS idTitles_135, c3_.avatar AS avatar_136, c3_.idUsersCreator AS idUsersCreator_137, c3_.idUsersChanger AS idUsersChanger_138, c4_.idAddresses AS idAddresses_139, c4_.idContacts AS idContacts_140, c5_.idAdressTypes AS idAdressTypes_141, c7_.idContacts AS idContacts_142, c8_.idEmailTypes AS idEmailTypes_143, c10_.idFaxTypes AS idFaxTypes_144, c13_.idPhoneTypes AS idPhoneTypes_145, t15_.idUsersCreator AS idUsersCreator_146, t15_.idUsersChanger AS idUsersChanger_147, c16_.idUrlTypes AS idUrlTypes_148, m20_.idPreviewImage AS idPreviewImage_149, m20_.idCollections AS idCollections_150, m20_.idUsersCreator AS idUsersCreator_151, m20_.idUsersChanger AS idUsersChanger_152, c21_.idCategoriesParent AS idCategoriesParent_153, c21_.idUsersCreator AS idUsersCreator_154, c21_.idUsersChanger AS idUsersChanger_155, c22_.idCategories AS idCategories_156, c22_.idUsersCreator AS idUsersCreator_157, c22_.idUsersChanger AS idUsersChanger_158 FROM co_contacts c0_ LEFT JOIN co_account_contacts c1_ ON c0_.id = c1_.idContacts LEFT JOIN co_accounts c2_ ON c1_.idAccounts = c2_.id LEFT JOIN co_contacts c3_ ON c2_.idContactsMain = c3_.id LEFT JOIN co_contact_addresses c4_ ON c0_.id = c4_.idContacts LEFT JOIN co_addresses c5_ ON c4_.idAddresses = c5_.id LEFT JOIN co_address_types c6_ ON c5_.idAdressTypes = c6_.id LEFT JOIN co_contact_locales c7_ ON c0_.id = c7_.idContacts LEFT JOIN co_contact_emails c24_ ON c0_.id = c24_.idContacts LEFT JOIN co_emails c8_ ON c8_.id = c24_.idEmails LEFT JOIN co_email_types c9_ ON c8_.idEmailTypes = c9_.id LEFT JOIN co_contact_faxes c25_ ON c0_.id = c25_.idContacts LEFT JOIN co_faxes c10_ ON c10_.id = c25_.idFaxes LEFT JOIN co_fax_types c11_ ON c10_.idFaxTypes = c11_.id LEFT JOIN co_contact_notes c26_ ON c0_.id = c26_.idContacts LEFT JOIN co_notes c12_ ON c12_.id = c26_.idNotes LEFT JOIN co_contact_phones c27_ ON c0_.id = c27_.idContacts LEFT JOIN co_phones c13_ ON c13_.id = c27_.idPhones LEFT JOIN co_phone_types c14_ ON c13_.idPhoneTypes = c14_.id LEFT JOIN co_contact_tags c28_ ON c0_.id = c28_.idContacts LEFT JOIN ta_tags t15_ ON t15_.id = c28_.idTags LEFT JOIN co_contact_urls c29_ ON c0_.id = c29_.idContacts LEFT JOIN co_urls c16_ ON c16_.id = c29_.idUrls LEFT JOIN co_url_types c17_ ON c16_.idUrlTypes = c17_.id LEFT JOIN co_contact_titles c18_ ON c0_.idTitles = c18_.id LEFT JOIN co_positions c19_ ON c1_.idPositions = c19_.id LEFT JOIN co_contact_medias c30_ ON c0_.id = c30_.idContacts LEFT JOIN me_media m20_ ON m20_.id = c30_.idMedias LEFT JOIN co_contact_categories c31_ ON c0_.id = c31_.idContacts LEFT JOIN ca_categories c21_ ON c21_.id = c31_.idCategories LEFT JOIN ca_category_translations c22_ ON c21_.id = c22_.idCategories LEFT JOIN co_contact_bank_accounts c32_ ON c0_.id = c32_.idContacts LEFT JOIN co_bank_account c23_ ON c23_.id = c32_.idBankAccounts WHERE c0_.id IN (?) ORDER BY c0_.id ASC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
|
4.22 ms (10.75%) |
8 |
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:
[
3
]
|
||||||||||||||||||||||||||||||
|
3.38 ms (8.61%) |
6 |
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:
[
68
]
|
||||||||||||||||||||||||||||||
|
3.25 ms (8.27%) |
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 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:
[ "en" "website" 1 "en" "live" 0 "en" "live" 0 "main" ] |
||||||||||||||||||||||||||||||
|
3.02 ms (7.69%) |
1 |
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, c8_.firstName AS firstName_67, c8_.middleName AS middleName_68, c8_.lastName AS lastName_69, c8_.birthday AS birthday_70, c8_.salutation AS salutation_71, c8_.formOfAddress AS formOfAddress_72, c8_.newsletter AS newsletter_73, c8_.gender AS gender_74, c8_.note AS note_75, c8_.mainEmail AS mainEmail_76, c8_.mainPhone AS mainPhone_77, c8_.mainFax AS mainFax_78, c8_.mainUrl AS mainUrl_79, c8_.id AS id_80, c8_.created AS created_81, c8_.changed AS changed_82, s9_.username AS username_83, s9_.password AS password_84, s9_.locale AS locale_85, s9_.salt AS salt_86, s9_.locked AS locked_87, s9_.enabled AS enabled_88, s9_.lastLogin AS lastLogin_89, s9_.confirmationKey AS confirmationKey_90, s9_.passwordResetToken AS passwordResetToken_91, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_92, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_93, s9_.privateKey AS privateKey_94, s9_.apiKey AS apiKey_95, s9_.email AS email_96, s9_.id AS id_97, s9_.created AS created_98, s9_.changed AS changed_99, c10_.firstName AS firstName_100, c10_.middleName AS middleName_101, c10_.lastName AS lastName_102, c10_.birthday AS birthday_103, c10_.salutation AS salutation_104, c10_.formOfAddress AS formOfAddress_105, c10_.newsletter AS newsletter_106, c10_.gender AS gender_107, c10_.note AS note_108, c10_.mainEmail AS mainEmail_109, c10_.mainPhone AS mainPhone_110, c10_.mainFax AS mainFax_111, c10_.mainUrl AS mainUrl_112, c10_.id AS id_113, c10_.created AS created_114, c10_.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, t4_.idUsersCreator AS idUsersCreator_132, t4_.idUsersChanger AS idUsersChanger_133, m5_.idFileVersions AS idFileVersions_134, m6_.idFileVersions AS idFileVersions_135, s7_.idContacts AS idContacts_136, s7_.idUsersCreator AS idUsersCreator_137, s7_.idUsersChanger AS idUsersChanger_138, c8_.idTitles AS idTitles_139, c8_.avatar AS avatar_140, c8_.idUsersCreator AS idUsersCreator_141, c8_.idUsersChanger AS idUsersChanger_142, s9_.idContacts AS idContacts_143, s9_.idUsersCreator AS idUsersCreator_144, s9_.idUsersChanger AS idUsersChanger_145, c10_.idTitles AS idTitles_146, c10_.avatar AS avatar_147, c10_.idUsersCreator AS idUsersCreator_148, c10_.idUsersChanger AS idUsersChanger_149 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:
[ 2 1 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (6.30%) |
1 |
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:
[ "en" "33333333-0000-4000-8000-000000000004" "33333333-0000-4000-8000-000000000003" "33333333-0000-4000-8000-000000000002" "en" "live" 0 "en" "live" 0 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (6.13%) |
1 |
SELECT DISTINCT a0_.uuid AS uuid_0, a1_.title AS title_1, a1_.templateKey AS templateKey_2, a1_.workflowPublished AS workflowPublished_3 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_.mainWebspace = ? OR a2_.name = ?) ORDER BY a1_.workflowPublished DESC LIMIT 3
Parameters:
[ "en" "live" 0 "website" "website" ] |
||||||||||||||||||||||||||||||
|
1.98 ms (5.03%) |
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:
[ "en" "01a1126d-6b9a-7244-b872-7758db00e230" "en" "live" 0 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (4.44%) |
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, 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, p0_.parent_id AS parent_id_56, p0_.idUsersCreator AS idUsersCreator_57, p0_.idUsersChanger AS idUsersChanger_58, p1_.route_id AS route_id_59, p1_.pageUuid AS pageUuid_60, p1_.author_id AS author_id_61, p1_.idUsersCreator AS idUsersCreator_62, p1_.idUsersChanger AS idUsersChanger_63, t2_.idUsersCreator AS idUsersCreator_64, t2_.idUsersChanger AS idUsersChanger_65, c3_.idCategoriesParent AS idCategoriesParent_66, c3_.idUsersCreator AS idUsersCreator_67, c3_.idUsersChanger AS idUsersChanger_68, c4_.idCategories AS idCategories_69, c4_.idUsersCreator AS idUsersCreator_70, c4_.idUsersChanger AS idUsersChanger_71, r5_.parent_id AS parent_id_72 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p6_ ON (p6_.pageUuid = p0_.uuid) LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid LEFT JOIN pa_page_dimension_content_excerpt_tags p7_ ON p1_.id = p7_.page_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = p7_.tag_id LEFT JOIN pa_page_dimension_content_excerpt_categories p8_ ON p1_.id = p8_.page_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = p8_.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 WHERE p0_.uuid IN (?, ?, ?) AND p6_.locale = ? AND p6_.stage = ? AND p6_.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 (?)))
Parameters:
[ "en" "11111111-0000-4000-8000-000000000001" "11111111-0000-4000-8000-000000000003" "11111111-0000-4000-8000-000000000002" "en" "live" 0 "en" "live" 0 ] |
||||||||||||||||||||||||||||||
|
1.40 ms (3.57%) |
1 |
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_.shadowLocale AS shadowLocale_10, s1_.shadowLocales AS shadowLocales_11, s1_.templateKey AS templateKey_12, s1_.templateData AS templateData_13, s1_.excerptSegment AS excerptSegment_14, s1_.workflowPlace AS workflowPlace_15, s1_.workflowPublished AS workflowPublished_16, s1_.created AS created_17, s1_.changed AS changed_18, t2_.name AS name_19, t2_.id AS id_20, t2_.created AS created_21, t2_.changed AS changed_22, c3_.category_key AS category_key_23, c3_.default_locale AS default_locale_24, c3_.lft AS lft_25, c3_.rgt AS rgt_26, c3_.depth AS depth_27, c3_.id AS id_28, c3_.created AS created_29, c3_.changed AS changed_30, c4_.translation AS translation_31, c4_.locale AS locale_32, c4_.description AS description_33, c4_.id AS id_34, c4_.created AS created_35, c4_.changed AS changed_36, s0_.idUsersCreator AS idUsersCreator_37, s0_.idUsersChanger AS idUsersChanger_38, s1_.snippetUuid AS snippetUuid_39, s1_.idUsersCreator AS idUsersCreator_40, s1_.idUsersChanger AS idUsersChanger_41, t2_.idUsersCreator AS idUsersCreator_42, t2_.idUsersChanger AS idUsersChanger_43, c3_.idCategoriesParent AS idCategoriesParent_44, c3_.idUsersCreator AS idUsersCreator_45, c3_.idUsersChanger AS idUsersChanger_46, c4_.idCategories AS idCategories_47, c4_.idUsersCreator AS idUsersCreator_48, c4_.idUsersChanger AS idUsersChanger_49 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 IN (?) 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:
[ "en" "22222222-0000-4000-8000-000000000001" "en" "live" 0 "en" "live" 0 ] |
||||||||||||||||||||||||||||||
|
1.01 ms (2.56%) |
1 |
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_.mainWebspace = ? OR a2_.name = ?)
Parameters:
[ "en" "live" 0 "website" "website" ] |
||||||||||||||||||||||||||||||
|
0.99 ms (2.53%) |
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:
[ "11111111-0000-4000-8000-000000000001" "en" "live" 0 ] |
||||||||||||||||||||||||||||||
|
0.97 ms (2.46%) |
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:
[ "website" "en" "/" ] |
||||||||||||||||||||||||||||||
|
0.97 ms (2.46%) |
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:
[ "hfgmfurdvsg0.zrok.sulu.tools/{localization}" "dev" "website" ] |
||||||||||||||||||||||||||||||
|
0.89 ms (2.27%) |
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:
[ "en" "de" "pages" "01a1126d-6b9a-7244-b872-7758db00e230" ]
|
||||||||||||||||||||||||||||||
|
0.47 ms (1.20%) |
1 |
SELECT t0.webspace AS webspace_1, t0.locale AS locale_2, t0.slug AS slug_3, t0.resource_key AS resource_key_4, t0.resource_id AS resource_id_5, t0.id AS id_6, t0.parent_id AS parent_id_7 FROM ro_routes t0 WHERE t0.id = ?
Parameters:
[
4
]
|
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 | 10 |
| Sulu\Route\Domain\Model\Route | 9 |
| Sulu\Article\Domain\Model\ArticleDimensionContent | 6 |
| Sulu\Page\Domain\Model\Page | 5 |
| Sulu\Bundle\MediaBundle\Entity\FileVersionMeta | 4 |
| Sulu\Page\Domain\Model\PageDimensionContentNavigationContext | 4 |
| Sulu\Article\Domain\Model\Article | 3 |
| Sulu\Snippet\Domain\Model\SnippetDimensionContent | 2 |
| Sulu\Bundle\TagBundle\Entity\Tag | 2 |
| Sulu\Bundle\MediaBundle\Entity\Media | 2 |
| Sulu\Bundle\MediaBundle\Entity\File | 2 |
| Sulu\Bundle\MediaBundle\Entity\FileVersion | 2 |
| Sulu\Snippet\Domain\Model\Snippet | 1 |
| Sulu\Bundle\CategoryBundle\Entity\Category | 1 |
| Sulu\Bundle\CategoryBundle\Entity\CategoryTranslation | 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 |