GET https://trustsulu.distantaccess.com/ka/blog

Query Metrics

12 Database Queries
10 Different statements
20.17 ms Query time
0 Invalid entities
42 Managed entities

Grouped Statements

Show all queries

Time Count Info
6.88 ms
(34.10%)
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, 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:
[
  "ka"
  "trust"
  2
  "ka"
  "live"
  0
  "ka"
  "live"
  0
  "main"
]
2.78 ms
(13.80%)
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:
[
  "ka"
  "019eca79-f054-7f3c-a04f-726ea86dcdbb"
  "ka"
  "live"
  0
  "ka"
  "live"
  0
]
2.02 ms
(10.02%)
1
SELECT DISTINCT a0_.uuid AS uuid_0, a1_.title AS title_1, a1_.workflowPublished AS workflowPublished_2 FROM ar_articles a0_ INNER 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 ASC
Parameters:
[
  "ka"
  "live"
  0
  "article"
  "trust"
  "trust"
]
1.52 ms
(7.56%)
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:
[
  48
]
1.49 ms
(7.40%)
2
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
]
1.39 ms
(6.89%)
1
SELECT COUNT(DISTINCT a0_.uuid) AS sclr_0 FROM ar_articles a0_ INNER 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:
[
  "ka"
  "live"
  0
  "article"
  "trust"
  "trust"
]
1.19 ms
(5.88%)
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"
  "fr"
  "es"
  "it"
  "ka"
  "pages"
  "019ebba9-02e7-784b-9d90-cb53bbbfd69c"
]
1.15 ms
(5.71%)
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:
[
  "trustsulu.distantaccess.com/ka"
  "dev"
  "trust"
]
1.02 ms
(5.07%)
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:
[
  "ka"
  "019ebba9-02e7-784b-9d90-cb53bbbfd69c"
  "ka"
  "live"
  0
]
0.72 ms
(3.57%)
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:
[
  "trust"
  "ka"
  "/blog"
]

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\Route\Domain\Model\Route 12
Sulu\Page\Domain\Model\PageDimensionContent 12
Sulu\Page\Domain\Model\Page 7
Sulu\Page\Domain\Model\PageDimensionContentNavigationContext 6
Sulu\Article\Domain\Model\ArticleDimensionContent 2
Sulu\Bundle\SecurityBundle\Entity\User 1
Sulu\Bundle\ContactBundle\Entity\Contact 1
Sulu\Article\Domain\Model\Article 1