Query Metrics
15
Database Queries
12
Different statements
15.73 ms
Query time
0
Invalid entities
33
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.96 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:
[ "immodirekt" "de" "/impressum" ] |
||||||||||||||||||||||||||||
| 2 | 2.64 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" "01a042e0-7d76-721a-8a16-664e212cce34" "de" "live" 0 ] |
||||||||||||||||||||||||||||
| 3 | 0.63 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:
[
45
]
|
||||||||||||||||||||||||||||
| 4 | 0.23 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:
[
46
]
|
||||||||||||||||||||||||||||
| 5 | 0.66 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:
[ "de" "pages" "01a042e0-7d76-721a-8a16-664e212cce34" ]
|
||||||||||||||||||||||||||||
| 6 | 1.56 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 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:
[ "de" "01a042e0-7d76-721a-8a16-664e212cce34" "de" "live" 0 "de" "live" 0 ] |
||||||||||||||||||||||||||||
| 7 | 1.27 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 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:
[ "de" 30 31 "immodirekt" "de" "live" 0 "de" "live" 0 ] |
||||||||||||||||||||||||||||
| 8 | 0.50 ms |
SELECT s0_.webspace_key AS webspace_key_0, s0_.area_key AS area_key_1, s0_.uuid AS uuid_2, s0_.idSnippet AS idSnippet_3 FROM sn_snippet_area s0_ WHERE s0_.webspace_key = ? AND s0_.area_key = ?
Parameters:
[ "immodirekt" "header" ] |
||||||||||||||||||||||||||||
| 9 | 1.72 ms |
SELECT s0_.uuid AS uuid_0, s0_.created AS created_1, s0_.changed AS changed_2, s1_.title AS title_3, s1_.id AS id_4, s1_.stage AS stage_5, s1_.locale AS locale_6, s1_.ghostLocale AS ghostLocale_7, s1_.availableLocales AS availableLocales_8, s1_.version AS version_9, s1_.templateKey AS templateKey_10, s1_.templateData AS templateData_11, s1_.excerptSegment AS excerptSegment_12, s1_.workflowPlace AS workflowPlace_13, s1_.workflowPublished AS workflowPublished_14, s1_.created AS created_15, s1_.changed AS changed_16, t2_.name AS name_17, t2_.id AS id_18, t2_.created AS created_19, t2_.changed AS changed_20, c3_.category_key AS category_key_21, c3_.default_locale AS default_locale_22, c3_.lft AS lft_23, c3_.rgt AS rgt_24, c3_.depth AS depth_25, c3_.id AS id_26, c3_.created AS created_27, c3_.changed AS changed_28, c4_.translation AS translation_29, c4_.locale AS locale_30, c4_.description AS description_31, c4_.id AS id_32, c4_.created AS created_33, c4_.changed AS changed_34, s0_.idUsersCreator AS idUsersCreator_35, s0_.idUsersChanger AS idUsersChanger_36, s1_.snippetUuid AS snippetUuid_37, s1_.idUsersCreator AS idUsersCreator_38, s1_.idUsersChanger AS idUsersChanger_39, t2_.idUsersCreator AS idUsersCreator_40, t2_.idUsersChanger AS idUsersChanger_41, c3_.idCategoriesParent AS idCategoriesParent_42, c3_.idUsersCreator AS idUsersCreator_43, c3_.idUsersChanger AS idUsersChanger_44, c4_.idCategories AS idCategories_45, c4_.idUsersCreator AS idUsersCreator_46, c4_.idUsersChanger AS idUsersChanger_47 FROM sn_snippets s0_ LEFT JOIN sn_snippet_dimension_contents s5_ ON (s5_.snippetUuid = s0_.uuid) LEFT JOIN sn_snippet_dimension_contents s1_ ON s0_.uuid = s1_.snippetUuid LEFT JOIN sn_snippet_dimension_content_excerpt_tags s6_ ON s1_.id = s6_.snippet_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = s6_.tag_id LEFT JOIN sn_snippet_dimension_content_excerpt_categories s7_ ON s1_.id = s7_.snippet_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = s7_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories AND (c4_.locale = c3_.default_locale OR c4_.locale IN (?)) WHERE s0_.uuid = ? AND s5_.locale = ? AND s5_.stage = ? AND s5_.version = ? AND (((s1_.locale IS NULL OR s1_.locale IN (?)) AND (s1_.stage IS NULL OR s1_.stage IN (?))) AND (s1_.version IS NULL OR s1_.version IN (?)))
Parameters:
[ "de" "01a042ed-72be-7d69-8eed-eb4024032688" "de" "live" 0 "de" "live" 0 ] |
||||||||||||||||||||||||||||
| 10 | 1.36 ms |
SELECT s0_.uuid AS uuid_0, s0_.created AS created_1, s0_.changed AS changed_2, s1_.title AS title_3, s1_.id AS id_4, s1_.stage AS stage_5, s1_.locale AS locale_6, s1_.ghostLocale AS ghostLocale_7, s1_.availableLocales AS availableLocales_8, s1_.version AS version_9, s1_.templateKey AS templateKey_10, s1_.templateData AS templateData_11, s1_.excerptSegment AS excerptSegment_12, s1_.workflowPlace AS workflowPlace_13, s1_.workflowPublished AS workflowPublished_14, s1_.created AS created_15, s1_.changed AS changed_16, t2_.name AS name_17, t2_.id AS id_18, t2_.created AS created_19, t2_.changed AS changed_20, c3_.category_key AS category_key_21, c3_.default_locale AS default_locale_22, c3_.lft AS lft_23, c3_.rgt AS rgt_24, c3_.depth AS depth_25, c3_.id AS id_26, c3_.created AS created_27, c3_.changed AS changed_28, c4_.translation AS translation_29, c4_.locale AS locale_30, c4_.description AS description_31, c4_.id AS id_32, c4_.created AS created_33, c4_.changed AS changed_34, s0_.idUsersCreator AS idUsersCreator_35, s0_.idUsersChanger AS idUsersChanger_36, s1_.snippetUuid AS snippetUuid_37, s1_.idUsersCreator AS idUsersCreator_38, s1_.idUsersChanger AS idUsersChanger_39, t2_.idUsersCreator AS idUsersCreator_40, t2_.idUsersChanger AS idUsersChanger_41, c3_.idCategoriesParent AS idCategoriesParent_42, c3_.idUsersCreator AS idUsersCreator_43, c3_.idUsersChanger AS idUsersChanger_44, c4_.idCategories AS idCategories_45, c4_.idUsersCreator AS idUsersCreator_46, c4_.idUsersChanger AS idUsersChanger_47 FROM sn_snippets s0_ LEFT JOIN sn_snippet_dimension_contents s5_ ON (s5_.snippetUuid = s0_.uuid) LEFT JOIN sn_snippet_dimension_contents s1_ ON s0_.uuid = s1_.snippetUuid LEFT JOIN sn_snippet_dimension_content_excerpt_tags s6_ ON s1_.id = s6_.snippet_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = s6_.tag_id LEFT JOIN sn_snippet_dimension_content_excerpt_categories s7_ ON s1_.id = s7_.snippet_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = s7_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories AND (c4_.locale = c3_.default_locale OR c4_.locale IN (?)) WHERE s0_.uuid 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:
[ "de" "01a042ed-0571-7b7a-b623-08b725a8d414" "01a04355-84f1-79e2-9d87-456cdf55bbf6" "01a042ed-422d-79f2-876d-338937bdf8ed" "01a04355-adfa-7bd8-8875-b3e19421ea91" "01a042ed-5879-745c-92f8-23c019e72c6a" "de" "live" 0 "de" "live" 0 ] |
||||||||||||||||||||||||||||
| 11 | 1.72 ms |
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:
[ "01a042e0-57ba-730e-9e18-cca068a2eacd" "01a033af-0e54-7f0e-9b16-18e91bb9b240" "01a042e0-2c7e-7711-b1a3-2921668e9b54" "01a042e0-1498-79b1-b6ca-fab904441f24" "01a042df-ef1f-7d98-95fd-527728a96608" "01a042df-ddb0-7d6e-a1e5-350ca8871135" "01a042df-bf7a-759c-af22-745b262ee46f" "01a042df-aa1a-7d45-a5f2-1d04e3aa1b20" "01a042df-8037-7ca2-bb10-9c5ae6b8584c" "01a042df-6dc6-7b8e-b7f7-3def0b56c25f" "01a042df-5b57-79e7-bdaa-9e430b2ede52" "01a042df-4611-7347-a86b-e53f08b1fa87" "01a042de-b8bf-7cc0-b645-3d4bc1e42103" "01a042e0-44cb-7187-8dfe-d4bb4cbe3e03" "01a04344-8955-7794-b45a-ae7895c4cd51" "01a04343-b570-7b18-a037-09c9fc55aa91" "01a04355-1ab7-7d55-8a45-1a5eb2d126bf" "01a04353-aecf-782f-8887-252cc2be761d" "de" "live" 0 ] |
||||||||||||||||||||||||||||
| 12 | 0.33 ms |
SELECT s0_.webspace_key AS webspace_key_0, s0_.area_key AS area_key_1, s0_.uuid AS uuid_2, s0_.idSnippet AS idSnippet_3 FROM sn_snippet_area s0_ WHERE s0_.webspace_key = ? AND s0_.area_key = ?
Parameters:
[ "immodirekt" "footer" ] |
||||||||||||||||||||||||||||
| 13 | 0.78 ms |
SELECT s0_.uuid AS uuid_0, s0_.created AS created_1, s0_.changed AS changed_2, s1_.title AS title_3, s1_.id AS id_4, s1_.stage AS stage_5, s1_.locale AS locale_6, s1_.ghostLocale AS ghostLocale_7, s1_.availableLocales AS availableLocales_8, s1_.version AS version_9, s1_.templateKey AS templateKey_10, s1_.templateData AS templateData_11, s1_.excerptSegment AS excerptSegment_12, s1_.workflowPlace AS workflowPlace_13, s1_.workflowPublished AS workflowPublished_14, s1_.created AS created_15, s1_.changed AS changed_16, t2_.name AS name_17, t2_.id AS id_18, t2_.created AS created_19, t2_.changed AS changed_20, c3_.category_key AS category_key_21, c3_.default_locale AS default_locale_22, c3_.lft AS lft_23, c3_.rgt AS rgt_24, c3_.depth AS depth_25, c3_.id AS id_26, c3_.created AS created_27, c3_.changed AS changed_28, c4_.translation AS translation_29, c4_.locale AS locale_30, c4_.description AS description_31, c4_.id AS id_32, c4_.created AS created_33, c4_.changed AS changed_34, s0_.idUsersCreator AS idUsersCreator_35, s0_.idUsersChanger AS idUsersChanger_36, s1_.snippetUuid AS snippetUuid_37, s1_.idUsersCreator AS idUsersCreator_38, s1_.idUsersChanger AS idUsersChanger_39, t2_.idUsersCreator AS idUsersCreator_40, t2_.idUsersChanger AS idUsersChanger_41, c3_.idCategoriesParent AS idCategoriesParent_42, c3_.idUsersCreator AS idUsersCreator_43, c3_.idUsersChanger AS idUsersChanger_44, c4_.idCategories AS idCategories_45, c4_.idUsersCreator AS idUsersCreator_46, c4_.idUsersChanger AS idUsersChanger_47 FROM sn_snippets s0_ LEFT JOIN sn_snippet_dimension_contents s5_ ON (s5_.snippetUuid = s0_.uuid) LEFT JOIN sn_snippet_dimension_contents s1_ ON s0_.uuid = s1_.snippetUuid LEFT JOIN sn_snippet_dimension_content_excerpt_tags s6_ ON s1_.id = s6_.snippet_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = s6_.tag_id LEFT JOIN sn_snippet_dimension_content_excerpt_categories s7_ ON s1_.id = s7_.snippet_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = s7_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories AND (c4_.locale = c3_.default_locale OR c4_.locale IN (?)) WHERE s0_.uuid = ? AND s5_.locale = ? AND s5_.stage = ? AND s5_.version = ? AND (((s1_.locale IS NULL OR s1_.locale IN (?)) AND (s1_.stage IS NULL OR s1_.stage IN (?))) AND (s1_.version IS NULL OR s1_.version IN (?)))
Parameters:
[ "de" "01a042ed-9d3b-7616-9666-f4dfa43e2bab" "de" "live" 0 "de" "live" 0 ] |
||||||||||||||||||||||||||||
| 14 | 0.50 ms |
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:
[ "01a042e0-6905-77bd-895b-654b1ba5c1f7" "01a042e0-9255-75e1-a978-c407e48c76ff" "01a042e0-7d76-721a-8a16-664e212cce34" "de" "live" 0 ] |
||||||||||||||||||||||||||||
| 15 | 0.87 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:
[ "stage.immobilienkauf-direkt.de" "dev" "immodirekt" ] |
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\Snippet\Domain\Model\SnippetDimensionContent | 14 |
| Sulu\Snippet\Domain\Model\Snippet | 7 |
| Sulu\Page\Domain\Model\PageDimensionContent | 4 |
| Sulu\Route\Domain\Model\Route | 2 |
| Sulu\Page\Domain\Model\Page | 2 |
| Sulu\Snippet\Domain\Model\SnippetArea | 2 |
| Sulu\Bundle\SecurityBundle\Entity\User | 1 |
| Sulu\Bundle\ContactBundle\Entity\Contact | 1 |