GET http://hfgmfurdvsg0.zrok.sulu.tools/de/neuigkeiten

Query Metrics

21 Database Queries
10 Different statements
16.56 ms Query time
0 Invalid entities
47 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.69 ms
SELECT r0_.webspace AS webspace_0, r0_.locale AS locale_1, r0_.slug AS slug_2, r0_.resource_key AS resource_key_3, r0_.resource_id AS resource_id_4, r0_.id AS id_5, r0_.parent_id AS parent_id_6 FROM ro_routes r0_ WHERE ((r0_.webspace = ? OR r0_.webspace IS NULL)) AND r0_.locale = ? AND r0_.slug = ? ORDER BY r0_.webspace DESC LIMIT 1
Parameters:
[
  "website"
  "de"
  "/neuigkeiten"
]
2 0.97 ms
SELECT p0_.webspaceKey AS webspaceKey_0, p0_.lft AS lft_1, p0_.rgt AS rgt_2, p0_.depth AS depth_3, p0_.uuid AS uuid_4, p0_.created AS created_5, p0_.changed AS changed_6, p1_.title AS title_7, p1_.id AS id_8, p1_.stage AS stage_9, p1_.locale AS locale_10, p1_.ghostLocale AS ghostLocale_11, p1_.availableLocales AS availableLocales_12, p1_.version AS version_13, p1_.shadowLocale AS shadowLocale_14, p1_.shadowLocales AS shadowLocales_15, p1_.templateKey AS templateKey_16, p1_.templateData AS templateData_17, p1_.seoData AS seoData_18, p1_.seoNoIndex AS seoNoIndex_19, p1_.seoNoFollow AS seoNoFollow_20, p1_.seoHideInSitemap AS seoHideInSitemap_21, p1_.excerptData AS excerptData_22, p1_.excerptSegment AS excerptSegment_23, p1_.authored AS authored_24, p1_.lastModified AS lastModified_25, p1_.workflowPlace AS workflowPlace_26, p1_.workflowPublished AS workflowPublished_27, p1_.linkProvider AS linkProvider_28, p1_.linkData AS linkData_29, p1_.created AS created_30, p1_.changed AS changed_31, t2_.name AS name_32, t2_.id AS id_33, t2_.created AS created_34, t2_.changed AS changed_35, c3_.category_key AS category_key_36, c3_.default_locale AS default_locale_37, c3_.lft AS lft_38, c3_.rgt AS rgt_39, c3_.depth AS depth_40, c3_.id AS id_41, c3_.created AS created_42, c3_.changed AS changed_43, c4_.translation AS translation_44, c4_.locale AS locale_45, c4_.description AS description_46, c4_.id AS id_47, c4_.created AS created_48, c4_.changed AS changed_49, 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:
[
  "de"
  "11111111-0000-4000-8000-000000000002"
  "de"
  "live"
  0
]
3 0.53 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:
[
  19
]
4 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:
[
  43
]
5 2.48 ms
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 INNER JOIN ro_routes r3_ ON (r3_.resource_key = ? AND r3_.resource_id = a0_.uuid AND r3_.locale = ?) INNER JOIN ro_routes r4_ ON r3_.parent_id = r4_.id INNER JOIN pa_pages p5_ ON (p5_.uuid = ?) INNER JOIN pa_pages p6_ ON (p6_.uuid = r4_.resource_id) WHERE a1_.locale = ? AND a1_.stage = ? AND a1_.version = ? AND (a1_.mainWebspace = ? OR a2_.name = ?) AND (p6_.lft BETWEEN p5_.lft AND p5_.rgt) ORDER BY a1_.workflowPublished DESC LIMIT 5
Parameters:
[
  "articles"
  "de"
  "11111111-0000-4000-8000-000000000002"
  "de"
  "live"
  0
  "website"
  "website"
]
6 0.93 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 INNER JOIN ro_routes r3_ ON (r3_.resource_key = ? AND r3_.resource_id = a0_.uuid AND r3_.locale = ?) INNER JOIN ro_routes r4_ ON r3_.parent_id = r4_.id INNER JOIN pa_pages p5_ ON (p5_.uuid = ?) INNER JOIN pa_pages p6_ ON (p6_.uuid = r4_.resource_id) WHERE a1_.locale = ? AND a1_.stage = ? AND a1_.version = ? AND (a1_.mainWebspace = ? OR a2_.name = ?) AND (p6_.lft BETWEEN p5_.lft AND p5_.rgt)
Parameters:
[
  "articles"
  "de"
  "11111111-0000-4000-8000-000000000002"
  "de"
  "live"
  0
  "website"
  "website"
]
7 3.44 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:
[
  "de"
  "33333333-0000-4000-8000-000000000004"
  "33333333-0000-4000-8000-000000000001"
  "33333333-0000-4000-8000-000000000002"
  "33333333-0000-4000-8000-000000000003"
  "33333333-0000-4000-8000-000000000104"
  "de"
  "live"
  0
  "de"
  "live"
  0
]
8 0.44 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:
[
  58
]
9 0.42 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:
[
  63
]
10 0.32 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:
[
  68
]
11 0.31 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:
[
  73
]
12 0.32 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:
[
  77
]
13 0.41 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:
[
  82
]
14 0.34 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:
[
  86
]
15 0.32 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:
[
  91
]
16 0.36 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:
[
  30
]
17 0.32 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
]
18 0.57 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:
[
  "en"
  "de"
  "pages"
  "11111111-0000-4000-8000-000000000002"
]
19 1.22 ms
SELECT p0_.webspaceKey AS webspaceKey_0, p0_.lft AS lft_1, p0_.rgt AS rgt_2, p0_.depth AS depth_3, p0_.uuid AS uuid_4, p0_.created AS created_5, p0_.changed AS changed_6, p1_.title AS title_7, p1_.id AS id_8, p1_.stage AS stage_9, p1_.locale AS locale_10, p1_.ghostLocale AS ghostLocale_11, p1_.availableLocales AS availableLocales_12, p1_.version AS version_13, p1_.shadowLocale AS shadowLocale_14, p1_.shadowLocales AS shadowLocales_15, p1_.templateKey AS templateKey_16, p1_.templateData AS templateData_17, p1_.seoData AS seoData_18, p1_.seoNoIndex AS seoNoIndex_19, p1_.seoNoFollow AS seoNoFollow_20, p1_.seoHideInSitemap AS seoHideInSitemap_21, p1_.excerptData AS excerptData_22, p1_.excerptSegment AS excerptSegment_23, p1_.authored AS authored_24, p1_.lastModified AS lastModified_25, p1_.workflowPlace AS workflowPlace_26, p1_.workflowPublished AS workflowPublished_27, p1_.linkProvider AS linkProvider_28, p1_.linkData AS linkData_29, p1_.created AS created_30, p1_.changed AS changed_31, t2_.name AS name_32, t2_.id AS id_33, t2_.created AS created_34, t2_.changed AS changed_35, c3_.category_key AS category_key_36, c3_.default_locale AS default_locale_37, c3_.lft AS lft_38, c3_.rgt AS rgt_39, c3_.depth AS depth_40, c3_.id AS id_41, c3_.created AS created_42, c3_.changed AS changed_43, c4_.translation AS translation_44, c4_.locale AS locale_45, c4_.description AS description_46, c4_.id AS id_47, c4_.created AS created_48, c4_.changed AS changed_49, r5_.webspace AS webspace_50, r5_.locale AS locale_51, r5_.slug AS slug_52, r5_.resource_key AS resource_key_53, r5_.resource_id AS resource_id_54, r5_.id AS id_55, p6_.name AS name_56, p6_.id AS id_57, p0_.parent_id AS parent_id_58, p0_.idUsersCreator AS idUsersCreator_59, p0_.idUsersChanger AS idUsersChanger_60, p1_.route_id AS route_id_61, p1_.pageUuid AS pageUuid_62, p1_.author_id AS author_id_63, p1_.idUsersCreator AS idUsersCreator_64, p1_.idUsersChanger AS idUsersChanger_65, t2_.idUsersCreator AS idUsersCreator_66, t2_.idUsersChanger AS idUsersChanger_67, c3_.idCategoriesParent AS idCategoriesParent_68, c3_.idUsersCreator AS idUsersCreator_69, c3_.idUsersChanger AS idUsersChanger_70, c4_.idCategories AS idCategories_71, c4_.idUsersCreator AS idUsersCreator_72, c4_.idUsersChanger AS idUsersChanger_73, r5_.parent_id AS parent_id_74, p6_.page_dimension_content_id AS page_dimension_content_id_75 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p7_ ON (p7_.pageUuid = p0_.uuid) LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid LEFT JOIN pa_page_dimension_content_excerpt_tags p8_ ON p1_.id = p8_.page_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = p8_.tag_id LEFT JOIN pa_page_dimension_content_excerpt_categories p9_ ON p1_.id = p9_.page_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = p9_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories AND (c4_.locale = c3_.default_locale OR c4_.locale IN (?)) LEFT JOIN ro_routes r5_ ON p1_.route_id = r5_.id LEFT JOIN pa_page_dimension_content_navigation_contexts p6_ ON p1_.id = p6_.page_dimension_content_id LEFT JOIN pa_page_dimension_content_navigation_contexts p10_ ON p7_.id = p10_.page_dimension_content_id WHERE p0_.webspaceKey = ? AND p0_.depth <= ? AND p7_.locale = ? AND p7_.stage = ? AND p7_.version = ? AND (((p1_.locale IS NULL OR p1_.locale IN (?)) AND (p1_.stage IS NULL OR p1_.stage IN (?))) AND (p1_.version IS NULL OR p1_.version IN (?))) AND p10_.name IN (?) ORDER BY p0_.lft ASC
Parameters:
[
  "de"
  "website"
  1
  "de"
  "live"
  0
  "de"
  "live"
  0
  "main"
]
20 1.15 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:
[
  "de"
  "website"
  1
  "de"
  "live"
  0
  "de"
  "live"
  0
  "main"
]
21 0.65 ms
SELECT w0_.title AS title_0, w0_.webspace_key AS webspace_key_1, w0_.all_domains AS all_domains_2, w0_.content AS content_3, w0_.type AS type_4, w0_.id AS id_5, w1_.url AS url_6, w1_.environment AS environment_7, w1_.id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain WHERE (w0_.all_domains = 1 OR (w1_.url = ? AND w1_.environment = ?)) AND w0_.webspace_key = ? ORDER BY w0_.id ASC
Parameters:
[
  "hfgmfurdvsg0.zrok.sulu.tools/{localization}"
  "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\Route\Domain\Model\Route 10
Sulu\Article\Domain\Model\ArticleDimensionContent 10
Sulu\Page\Domain\Model\PageDimensionContent 8
Sulu\Page\Domain\Model\Page 5
Sulu\Article\Domain\Model\Article 5
Sulu\Page\Domain\Model\PageDimensionContentNavigationContext 4
Sulu\Bundle\TagBundle\Entity\Tag 2
Sulu\Bundle\CategoryBundle\Entity\CategoryTranslation 2
Sulu\Bundle\CategoryBundle\Entity\Category 1

Entities Mapping

Class Mapping errors
Sulu\Bundle\FormBundle\Entity\Form No errors.
Sulu\Bundle\TrashBundle\Domain\Model\TrashItem No errors.
Sulu\Bundle\MediaBundle\Entity\Collection No errors.
Sulu\Route\Domain\Model\Route No errors.
Sulu\Bundle\ReferenceBundle\Domain\Model\Reference No errors.
Sulu\Bundle\ContactBundle\Entity\ContactTitle No errors.
Sulu\Article\Domain\Model\Article No errors.
Sulu\Bundle\TagBundle\Entity\Tag No errors.
Sulu\Bundle\CategoryBundle\Entity\Category No errors.
Sulu\Bundle\ContactBundle\Entity\Contact No errors.
Sulu\Article\Domain\Model\ArticleDimensionContent No errors.
Sulu\Page\Domain\Model\Page No errors.
Sulu\Page\Domain\Model\PageDimensionContent No errors.
Sulu\Product\Domain\Model\Attribute No errors.
Sulu\Product\Domain\Model\Product No errors.
Sulu\Product\Domain\Model\ProductDimensionContent No errors.
Sulu\Snippet\Domain\Model\Snippet No errors.
Sulu\Snippet\Domain\Model\SnippetDimensionContent No errors.
Sulu\Product\Domain\Model\ProductFamily No errors.
Sulu\Snippet\Domain\Model\SnippetArea No errors.
Sulu\Bundle\CategoryBundle\Entity\CategoryTranslation No errors.
Sulu\Bundle\SecurityBundle\Entity\User No errors.
Sulu\Page\Domain\Model\PageDimensionContentNavigationContext No errors.
Sulu\Article\Domain\Model\ArticleDimensionContentAdditionalWebspace No errors.
Sulu\Bundle\CategoryBundle\Entity\CategoryTranslationMedia No errors.
Sulu\Bundle\CategoryBundle\Entity\Keyword No errors.
Sulu\Bundle\AiPlatformBundle\Domain\Model\RequestLog No errors.
Sulu\Product\Domain\Model\ProductAttributeValue No errors.
Sulu\Bundle\WebsiteBundle\Entity\Analytics No errors.
Sulu\Bundle\WebsiteBundle\Entity\Domain No errors.