| 1 |
0.75 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"
"/"
]
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 = 'website' OR r0_.webspace IS NULL)) AND r0_.locale = 'de' AND r0_.slug = '/' ORDER BY r0_.webspace DESC LIMIT 1;
|
| 2 |
0.98 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"
"019e53b6-9d81-7e08-a498-67201e47584b"
"de"
"live"
0
]
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 (?)
)
)
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 ('de')) WHERE p0_.uuid = '019e53b6-9d81-7e08-a498-67201e47584b' AND (((p1_.locale IS NULL OR p1_.locale IN ('de')) AND (p1_.stage IS NULL OR p1_.stage IN ('live'))) AND (p1_.version IS NULL OR p1_.version IN (0)));
|
| 3 |
0.56 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 = ?
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 = 5;
|
| 4 |
0.55 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 = ?
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 = 6;
|
| 5 |
0.61 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"
"en"
"pages"
"019e53b6-9d81-7e08-a498-67201e47584b"
]
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 ('de', 'en') AND r0_.resource_key = 'pages' AND r0_.resource_id = '019e53b6-9d81-7e08-a498-67201e47584b';
|
| 6 |
0.62 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: [
"website"
"webspace_settings"
]
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 = 'website' AND s0_.area_key = 'webspace_settings';
|
| 7 |
0.69 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"
"019e690e-6f58-7c4d-8cb7-2e4ec6a7a351"
"de"
"live"
0
"de"
"live"
0
]
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 (?)
)
)
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 ('de')) WHERE s0_.uuid = '019e690e-6f58-7c4d-8cb7-2e4ec6a7a351' AND s5_.locale = 'de' AND s5_.stage = 'live' AND s5_.version = 0 AND (((s1_.locale IS NULL OR s1_.locale IN ('de')) AND (s1_.stage IS NULL OR s1_.stage IN ('live'))) AND (s1_.version IS NULL OR s1_.version IN (0)));
|
| 8 |
0.91 ms |
SELECT c0_.lft AS lft_0, c0_.rgt AS rgt_1, c0_.depth AS depth_2, c0_.name AS name_3, c0_.externalId AS externalId_4, c0_.number AS number_5, c0_.corporation AS corporation_6, c0_.note AS note_7, c0_.uid AS uid_8, c0_.registerNumber AS registerNumber_9, c0_.placeOfJurisdiction AS placeOfJurisdiction_10, c0_.mainEmail AS mainEmail_11, c0_.mainPhone AS mainPhone_12, c0_.mainFax AS mainFax_13, c0_.mainUrl AS mainUrl_14, c0_.id AS id_15, c0_.created AS created_16, c0_.changed AS changed_17, c1_.category_key AS category_key_18, c1_.default_locale AS default_locale_19, c1_.lft AS lft_20, c1_.rgt AS rgt_21, c1_.depth AS depth_22, c1_.id AS id_23, c1_.created AS created_24, c1_.changed AS changed_25, c2_.translation AS translation_26, c2_.locale AS locale_27, c2_.description AS description_28, c2_.id AS id_29, c2_.created AS created_30, c2_.changed AS changed_31, c3_.main AS main_32, c3_.id AS id_33, c4_.title AS title_34, c4_.primaryAddress AS primaryAddress_35, c4_.deliveryAddress AS deliveryAddress_36, c4_.billingAddress AS billingAddress_37, c4_.street AS street_38, c4_.number AS number_39, c4_.addition AS addition_40, c4_.zip AS zip_41, c4_.city AS city_42, c4_.state AS state_43, c4_.countryCode AS countryCode_44, c4_.postboxNumber AS postboxNumber_45, c4_.postboxPostcode AS postboxPostcode_46, c4_.postboxCity AS postboxCity_47, c4_.latitude AS latitude_48, c4_.longitude AS longitude_49, c4_.note AS note_50, c4_.id AS id_51, c5_.name AS name_52, c5_.id AS id_53, c6_.lft AS lft_54, c6_.rgt AS rgt_55, c6_.depth AS depth_56, c6_.name AS name_57, c6_.externalId AS externalId_58, c6_.number AS number_59, c6_.corporation AS corporation_60, c6_.note AS note_61, c6_.uid AS uid_62, c6_.registerNumber AS registerNumber_63, c6_.placeOfJurisdiction AS placeOfJurisdiction_64, c6_.mainEmail AS mainEmail_65, c6_.mainPhone AS mainPhone_66, c6_.mainFax AS mainFax_67, c6_.mainUrl AS mainUrl_68, c6_.id AS id_69, c6_.created AS created_70, c6_.changed AS changed_71, c7_.url AS url_72, c7_.id AS id_73, c8_.name AS name_74, c8_.id AS id_75, c9_.phone AS phone_76, c9_.id AS id_77, c10_.name AS name_78, c10_.id AS id_79, c11_.email AS email_80, c11_.id AS id_81, c12_.name AS name_82, c12_.id AS id_83, c13_.value AS value_84, c13_.id AS id_85, c14_.fax AS fax_86, c14_.id AS id_87, c15_.name AS name_88, c15_.id AS id_89, c16_.bankName AS bankName_90, c16_.bic AS bic_91, c16_.iban AS iban_92, c16_.public AS public_93, c16_.id AS id_94, t17_.name AS name_95, t17_.id AS id_96, c18_.firstName AS firstName_97, c18_.middleName AS middleName_98, c18_.lastName AS lastName_99, c18_.birthday AS birthday_100, c18_.salutation AS salutation_101, c18_.formOfAddress AS formOfAddress_102, c18_.newsletter AS newsletter_103, c18_.gender AS gender_104, c18_.note AS note_105, c18_.mainEmail AS mainEmail_106, c18_.mainPhone AS mainPhone_107, c18_.mainFax AS mainFax_108, c18_.mainUrl AS mainUrl_109, c18_.id AS id_110, c18_.created AS created_111, c18_.changed AS changed_112, m19_.type AS type_113, m19_.id AS id_114, m19_.created AS created_115, m19_.changed AS changed_116, c0_.idContactsMain AS idContactsMain_117, c0_.idAccountsParent AS idAccountsParent_118, c0_.logo AS logo_119, c0_.idUsersCreator AS idUsersCreator_120, c0_.idUsersChanger AS idUsersChanger_121, c1_.idCategoriesParent AS idCategoriesParent_122, c1_.idUsersCreator AS idUsersCreator_123, c1_.idUsersChanger AS idUsersChanger_124, c2_.idCategories AS idCategories_125, c2_.idUsersCreator AS idUsersCreator_126, c2_.idUsersChanger AS idUsersChanger_127, c3_.idAddresses AS idAddresses_128, c3_.idAccounts AS idAccounts_129, c4_.idAdressTypes AS idAdressTypes_130, c6_.idContactsMain AS idContactsMain_131, c6_.idAccountsParent AS idAccountsParent_132, c6_.logo AS logo_133, c6_.idUsersCreator AS idUsersCreator_134, c6_.idUsersChanger AS idUsersChanger_135, c7_.idUrlTypes AS idUrlTypes_136, c9_.idPhoneTypes AS idPhoneTypes_137, c11_.idEmailTypes AS idEmailTypes_138, c14_.idFaxTypes AS idFaxTypes_139, t17_.idUsersCreator AS idUsersCreator_140, t17_.idUsersChanger AS idUsersChanger_141, c18_.idTitles AS idTitles_142, c18_.avatar AS avatar_143, c18_.idUsersCreator AS idUsersCreator_144, c18_.idUsersChanger AS idUsersChanger_145, m19_.idPreviewImage AS idPreviewImage_146, m19_.idCollections AS idCollections_147, m19_.idUsersCreator AS idUsersCreator_148, m19_.idUsersChanger AS idUsersChanger_149 FROM co_accounts c0_ LEFT JOIN co_account_categories c20_ ON c0_.id = c20_.idAccounts LEFT JOIN ca_categories c1_ ON c1_.id = c20_.idCategories LEFT JOIN ca_category_translations c2_ ON c1_.id = c2_.idCategories LEFT JOIN co_account_addresses c3_ ON c0_.id = c3_.idAccounts LEFT JOIN co_addresses c4_ ON c3_.idAddresses = c4_.id LEFT JOIN co_address_types c5_ ON c4_.idAdressTypes = c5_.id LEFT JOIN co_accounts c6_ ON c0_.idAccountsParent = c6_.id LEFT JOIN co_account_urls c21_ ON c0_.id = c21_.idAccounts LEFT JOIN co_urls c7_ ON c7_.id = c21_.idUrls LEFT JOIN co_url_types c8_ ON c7_.idUrlTypes = c8_.id LEFT JOIN co_account_phones c22_ ON c0_.id = c22_.idAccounts LEFT JOIN co_phones c9_ ON c9_.id = c22_.idPhones LEFT JOIN co_phone_types c10_ ON c9_.idPhoneTypes = c10_.id LEFT JOIN co_account_emails c23_ ON c0_.id = c23_.idAccounts LEFT JOIN co_emails c11_ ON c11_.id = c23_.idEmails LEFT JOIN co_email_types c12_ ON c11_.idEmailTypes = c12_.id LEFT JOIN co_account_notes c24_ ON c0_.id = c24_.idAccounts LEFT JOIN co_notes c13_ ON c13_.id = c24_.idNotes LEFT JOIN co_account_faxes c25_ ON c0_.id = c25_.idAccounts LEFT JOIN co_faxes c14_ ON c14_.id = c25_.idFaxes LEFT JOIN co_fax_types c15_ ON c14_.idFaxTypes = c15_.id LEFT JOIN co_account_bank_accounts c26_ ON c0_.id = c26_.idAccounts LEFT JOIN co_bank_account c16_ ON c16_.id = c26_.idBankAccounts LEFT JOIN co_account_tags c27_ ON c0_.id = c27_.idAccounts LEFT JOIN ta_tags t17_ ON t17_.id = c27_.idTags LEFT JOIN co_contacts c18_ ON c0_.idContactsMain = c18_.id LEFT JOIN co_account_medias c28_ ON c0_.id = c28_.idAccounts LEFT JOIN me_media m19_ ON m19_.id = c28_.idMedias WHERE c0_.id IN (?) ORDER BY c0_.id ASC
SELECT
c0_.lft AS lft_0,
c0_.rgt AS rgt_1,
c0_.depth AS depth_2,
c0_.name AS name_3,
c0_.externalId AS externalId_4,
c0_.number AS number_5,
c0_.corporation AS corporation_6,
c0_.note AS note_7,
c0_.uid AS uid_8,
c0_.registerNumber AS registerNumber_9,
c0_.placeOfJurisdiction AS placeOfJurisdiction_10,
c0_.mainEmail AS mainEmail_11,
c0_.mainPhone AS mainPhone_12,
c0_.mainFax AS mainFax_13,
c0_.mainUrl AS mainUrl_14,
c0_.id AS id_15,
c0_.created AS created_16,
c0_.changed AS changed_17,
c1_.category_key AS category_key_18,
c1_.default_locale AS default_locale_19,
c1_.lft AS lft_20,
c1_.rgt AS rgt_21,
c1_.depth AS depth_22,
c1_.id AS id_23,
c1_.created AS created_24,
c1_.changed AS changed_25,
c2_.translation AS translation_26,
c2_.locale AS locale_27,
c2_.description AS description_28,
c2_.id AS id_29,
c2_.created AS created_30,
c2_.changed AS changed_31,
c3_.main AS main_32,
c3_.id AS id_33,
c4_.title AS title_34,
c4_.primaryAddress AS primaryAddress_35,
c4_.deliveryAddress AS deliveryAddress_36,
c4_.billingAddress AS billingAddress_37,
c4_.street AS street_38,
c4_.number AS number_39,
c4_.addition AS addition_40,
c4_.zip AS zip_41,
c4_.city AS city_42,
c4_.state AS state_43,
c4_.countryCode AS countryCode_44,
c4_.postboxNumber AS postboxNumber_45,
c4_.postboxPostcode AS postboxPostcode_46,
c4_.postboxCity AS postboxCity_47,
c4_.latitude AS latitude_48,
c4_.longitude AS longitude_49,
c4_.note AS note_50,
c4_.id AS id_51,
c5_.name AS name_52,
c5_.id AS id_53,
c6_.lft AS lft_54,
c6_.rgt AS rgt_55,
c6_.depth AS depth_56,
c6_.name AS name_57,
c6_.externalId AS externalId_58,
c6_.number AS number_59,
c6_.corporation AS corporation_60,
c6_.note AS note_61,
c6_.uid AS uid_62,
c6_.registerNumber AS registerNumber_63,
c6_.placeOfJurisdiction AS placeOfJurisdiction_64,
c6_.mainEmail AS mainEmail_65,
c6_.mainPhone AS mainPhone_66,
c6_.mainFax AS mainFax_67,
c6_.mainUrl AS mainUrl_68,
c6_.id AS id_69,
c6_.created AS created_70,
c6_.changed AS changed_71,
c7_.url AS url_72,
c7_.id AS id_73,
c8_.name AS name_74,
c8_.id AS id_75,
c9_.phone AS phone_76,
c9_.id AS id_77,
c10_.name AS name_78,
c10_.id AS id_79,
c11_.email AS email_80,
c11_.id AS id_81,
c12_.name AS name_82,
c12_.id AS id_83,
c13_.value AS value_84,
c13_.id AS id_85,
c14_.fax AS fax_86,
c14_.id AS id_87,
c15_.name AS name_88,
c15_.id AS id_89,
c16_.bankName AS bankName_90,
c16_.bic AS bic_91,
c16_.iban AS iban_92,
c16_.public AS public_93,
c16_.id AS id_94,
t17_.name AS name_95,
t17_.id AS id_96,
c18_.firstName AS firstName_97,
c18_.middleName AS middleName_98,
c18_.lastName AS lastName_99,
c18_.birthday AS birthday_100,
c18_.salutation AS salutation_101,
c18_.formOfAddress AS formOfAddress_102,
c18_.newsletter AS newsletter_103,
c18_.gender AS gender_104,
c18_.note AS note_105,
c18_.mainEmail AS mainEmail_106,
c18_.mainPhone AS mainPhone_107,
c18_.mainFax AS mainFax_108,
c18_.mainUrl AS mainUrl_109,
c18_.id AS id_110,
c18_.created AS created_111,
c18_.changed AS changed_112,
m19_.type AS type_113,
m19_.id AS id_114,
m19_.created AS created_115,
m19_.changed AS changed_116,
c0_.idContactsMain AS idContactsMain_117,
c0_.idAccountsParent AS idAccountsParent_118,
c0_.logo AS logo_119,
c0_.idUsersCreator AS idUsersCreator_120,
c0_.idUsersChanger AS idUsersChanger_121,
c1_.idCategoriesParent AS idCategoriesParent_122,
c1_.idUsersCreator AS idUsersCreator_123,
c1_.idUsersChanger AS idUsersChanger_124,
c2_.idCategories AS idCategories_125,
c2_.idUsersCreator AS idUsersCreator_126,
c2_.idUsersChanger AS idUsersChanger_127,
c3_.idAddresses AS idAddresses_128,
c3_.idAccounts AS idAccounts_129,
c4_.idAdressTypes AS idAdressTypes_130,
c6_.idContactsMain AS idContactsMain_131,
c6_.idAccountsParent AS idAccountsParent_132,
c6_.logo AS logo_133,
c6_.idUsersCreator AS idUsersCreator_134,
c6_.idUsersChanger AS idUsersChanger_135,
c7_.idUrlTypes AS idUrlTypes_136,
c9_.idPhoneTypes AS idPhoneTypes_137,
c11_.idEmailTypes AS idEmailTypes_138,
c14_.idFaxTypes AS idFaxTypes_139,
t17_.idUsersCreator AS idUsersCreator_140,
t17_.idUsersChanger AS idUsersChanger_141,
c18_.idTitles AS idTitles_142,
c18_.avatar AS avatar_143,
c18_.idUsersCreator AS idUsersCreator_144,
c18_.idUsersChanger AS idUsersChanger_145,
m19_.idPreviewImage AS idPreviewImage_146,
m19_.idCollections AS idCollections_147,
m19_.idUsersCreator AS idUsersCreator_148,
m19_.idUsersChanger AS idUsersChanger_149
FROM
co_accounts c0_
LEFT JOIN co_account_categories c20_ ON c0_.id = c20_.idAccounts
LEFT JOIN ca_categories c1_ ON c1_.id = c20_.idCategories
LEFT JOIN ca_category_translations c2_ ON c1_.id = c2_.idCategories
LEFT JOIN co_account_addresses c3_ ON c0_.id = c3_.idAccounts
LEFT JOIN co_addresses c4_ ON c3_.idAddresses = c4_.id
LEFT JOIN co_address_types c5_ ON c4_.idAdressTypes = c5_.id
LEFT JOIN co_accounts c6_ ON c0_.idAccountsParent = c6_.id
LEFT JOIN co_account_urls c21_ ON c0_.id = c21_.idAccounts
LEFT JOIN co_urls c7_ ON c7_.id = c21_.idUrls
LEFT JOIN co_url_types c8_ ON c7_.idUrlTypes = c8_.id
LEFT JOIN co_account_phones c22_ ON c0_.id = c22_.idAccounts
LEFT JOIN co_phones c9_ ON c9_.id = c22_.idPhones
LEFT JOIN co_phone_types c10_ ON c9_.idPhoneTypes = c10_.id
LEFT JOIN co_account_emails c23_ ON c0_.id = c23_.idAccounts
LEFT JOIN co_emails c11_ ON c11_.id = c23_.idEmails
LEFT JOIN co_email_types c12_ ON c11_.idEmailTypes = c12_.id
LEFT JOIN co_account_notes c24_ ON c0_.id = c24_.idAccounts
LEFT JOIN co_notes c13_ ON c13_.id = c24_.idNotes
LEFT JOIN co_account_faxes c25_ ON c0_.id = c25_.idAccounts
LEFT JOIN co_faxes c14_ ON c14_.id = c25_.idFaxes
LEFT JOIN co_fax_types c15_ ON c14_.idFaxTypes = c15_.id
LEFT JOIN co_account_bank_accounts c26_ ON c0_.id = c26_.idAccounts
LEFT JOIN co_bank_account c16_ ON c16_.id = c26_.idBankAccounts
LEFT JOIN co_account_tags c27_ ON c0_.id = c27_.idAccounts
LEFT JOIN ta_tags t17_ ON t17_.id = c27_.idTags
LEFT JOIN co_contacts c18_ ON c0_.idContactsMain = c18_.id
LEFT JOIN co_account_medias c28_ ON c0_.id = c28_.idAccounts
LEFT JOIN me_media m19_ ON m19_.id = c28_.idMedias
WHERE
c0_.id IN (?)
ORDER BY
c0_.id ASC
SELECT c0_.lft AS lft_0, c0_.rgt AS rgt_1, c0_.depth AS depth_2, c0_.name AS name_3, c0_.externalId AS externalId_4, c0_.number AS number_5, c0_.corporation AS corporation_6, c0_.note AS note_7, c0_.uid AS uid_8, c0_.registerNumber AS registerNumber_9, c0_.placeOfJurisdiction AS placeOfJurisdiction_10, c0_.mainEmail AS mainEmail_11, c0_.mainPhone AS mainPhone_12, c0_.mainFax AS mainFax_13, c0_.mainUrl AS mainUrl_14, c0_.id AS id_15, c0_.created AS created_16, c0_.changed AS changed_17, c1_.category_key AS category_key_18, c1_.default_locale AS default_locale_19, c1_.lft AS lft_20, c1_.rgt AS rgt_21, c1_.depth AS depth_22, c1_.id AS id_23, c1_.created AS created_24, c1_.changed AS changed_25, c2_.translation AS translation_26, c2_.locale AS locale_27, c2_.description AS description_28, c2_.id AS id_29, c2_.created AS created_30, c2_.changed AS changed_31, c3_.main AS main_32, c3_.id AS id_33, c4_.title AS title_34, c4_.primaryAddress AS primaryAddress_35, c4_.deliveryAddress AS deliveryAddress_36, c4_.billingAddress AS billingAddress_37, c4_.street AS street_38, c4_.number AS number_39, c4_.addition AS addition_40, c4_.zip AS zip_41, c4_.city AS city_42, c4_.state AS state_43, c4_.countryCode AS countryCode_44, c4_.postboxNumber AS postboxNumber_45, c4_.postboxPostcode AS postboxPostcode_46, c4_.postboxCity AS postboxCity_47, c4_.latitude AS latitude_48, c4_.longitude AS longitude_49, c4_.note AS note_50, c4_.id AS id_51, c5_.name AS name_52, c5_.id AS id_53, c6_.lft AS lft_54, c6_.rgt AS rgt_55, c6_.depth AS depth_56, c6_.name AS name_57, c6_.externalId AS externalId_58, c6_.number AS number_59, c6_.corporation AS corporation_60, c6_.note AS note_61, c6_.uid AS uid_62, c6_.registerNumber AS registerNumber_63, c6_.placeOfJurisdiction AS placeOfJurisdiction_64, c6_.mainEmail AS mainEmail_65, c6_.mainPhone AS mainPhone_66, c6_.mainFax AS mainFax_67, c6_.mainUrl AS mainUrl_68, c6_.id AS id_69, c6_.created AS created_70, c6_.changed AS changed_71, c7_.url AS url_72, c7_.id AS id_73, c8_.name AS name_74, c8_.id AS id_75, c9_.phone AS phone_76, c9_.id AS id_77, c10_.name AS name_78, c10_.id AS id_79, c11_.email AS email_80, c11_.id AS id_81, c12_.name AS name_82, c12_.id AS id_83, c13_.value AS value_84, c13_.id AS id_85, c14_.fax AS fax_86, c14_.id AS id_87, c15_.name AS name_88, c15_.id AS id_89, c16_.bankName AS bankName_90, c16_.bic AS bic_91, c16_.iban AS iban_92, c16_.public AS public_93, c16_.id AS id_94, t17_.name AS name_95, t17_.id AS id_96, c18_.firstName AS firstName_97, c18_.middleName AS middleName_98, c18_.lastName AS lastName_99, c18_.birthday AS birthday_100, c18_.salutation AS salutation_101, c18_.formOfAddress AS formOfAddress_102, c18_.newsletter AS newsletter_103, c18_.gender AS gender_104, c18_.note AS note_105, c18_.mainEmail AS mainEmail_106, c18_.mainPhone AS mainPhone_107, c18_.mainFax AS mainFax_108, c18_.mainUrl AS mainUrl_109, c18_.id AS id_110, c18_.created AS created_111, c18_.changed AS changed_112, m19_.type AS type_113, m19_.id AS id_114, m19_.created AS created_115, m19_.changed AS changed_116, c0_.idContactsMain AS idContactsMain_117, c0_.idAccountsParent AS idAccountsParent_118, c0_.logo AS logo_119, c0_.idUsersCreator AS idUsersCreator_120, c0_.idUsersChanger AS idUsersChanger_121, c1_.idCategoriesParent AS idCategoriesParent_122, c1_.idUsersCreator AS idUsersCreator_123, c1_.idUsersChanger AS idUsersChanger_124, c2_.idCategories AS idCategories_125, c2_.idUsersCreator AS idUsersCreator_126, c2_.idUsersChanger AS idUsersChanger_127, c3_.idAddresses AS idAddresses_128, c3_.idAccounts AS idAccounts_129, c4_.idAdressTypes AS idAdressTypes_130, c6_.idContactsMain AS idContactsMain_131, c6_.idAccountsParent AS idAccountsParent_132, c6_.logo AS logo_133, c6_.idUsersCreator AS idUsersCreator_134, c6_.idUsersChanger AS idUsersChanger_135, c7_.idUrlTypes AS idUrlTypes_136, c9_.idPhoneTypes AS idPhoneTypes_137, c11_.idEmailTypes AS idEmailTypes_138, c14_.idFaxTypes AS idFaxTypes_139, t17_.idUsersCreator AS idUsersCreator_140, t17_.idUsersChanger AS idUsersChanger_141, c18_.idTitles AS idTitles_142, c18_.avatar AS avatar_143, c18_.idUsersCreator AS idUsersCreator_144, c18_.idUsersChanger AS idUsersChanger_145, m19_.idPreviewImage AS idPreviewImage_146, m19_.idCollections AS idCollections_147, m19_.idUsersCreator AS idUsersCreator_148, m19_.idUsersChanger AS idUsersChanger_149 FROM co_accounts c0_ LEFT JOIN co_account_categories c20_ ON c0_.id = c20_.idAccounts LEFT JOIN ca_categories c1_ ON c1_.id = c20_.idCategories LEFT JOIN ca_category_translations c2_ ON c1_.id = c2_.idCategories LEFT JOIN co_account_addresses c3_ ON c0_.id = c3_.idAccounts LEFT JOIN co_addresses c4_ ON c3_.idAddresses = c4_.id LEFT JOIN co_address_types c5_ ON c4_.idAdressTypes = c5_.id LEFT JOIN co_accounts c6_ ON c0_.idAccountsParent = c6_.id LEFT JOIN co_account_urls c21_ ON c0_.id = c21_.idAccounts LEFT JOIN co_urls c7_ ON c7_.id = c21_.idUrls LEFT JOIN co_url_types c8_ ON c7_.idUrlTypes = c8_.id LEFT JOIN co_account_phones c22_ ON c0_.id = c22_.idAccounts LEFT JOIN co_phones c9_ ON c9_.id = c22_.idPhones LEFT JOIN co_phone_types c10_ ON c9_.idPhoneTypes = c10_.id LEFT JOIN co_account_emails c23_ ON c0_.id = c23_.idAccounts LEFT JOIN co_emails c11_ ON c11_.id = c23_.idEmails LEFT JOIN co_email_types c12_ ON c11_.idEmailTypes = c12_.id LEFT JOIN co_account_notes c24_ ON c0_.id = c24_.idAccounts LEFT JOIN co_notes c13_ ON c13_.id = c24_.idNotes LEFT JOIN co_account_faxes c25_ ON c0_.id = c25_.idAccounts LEFT JOIN co_faxes c14_ ON c14_.id = c25_.idFaxes LEFT JOIN co_fax_types c15_ ON c14_.idFaxTypes = c15_.id LEFT JOIN co_account_bank_accounts c26_ ON c0_.id = c26_.idAccounts LEFT JOIN co_bank_account c16_ ON c16_.id = c26_.idBankAccounts LEFT JOIN co_account_tags c27_ ON c0_.id = c27_.idAccounts LEFT JOIN ta_tags t17_ ON t17_.id = c27_.idTags LEFT JOIN co_contacts c18_ ON c0_.idContactsMain = c18_.id LEFT JOIN co_account_medias c28_ ON c0_.id = c28_.idAccounts LEFT JOIN me_media m19_ ON m19_.id = c28_.idMedias WHERE c0_.id IN (1) ORDER BY c0_.id ASC;
|
| 9 |
0.67 ms |
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_.id AS id_26, m3_.created AS created_27, m3_.changed AS changed_28, t4_.name AS name_29, t4_.id AS id_30, t4_.created AS created_31, t4_.changed AS changed_32, m5_.title AS title_33, m5_.description AS description_34, m5_.copyright AS copyright_35, m5_.credits AS credits_36, m5_.locale AS locale_37, m5_.id AS id_38, m6_.title AS title_39, m6_.description AS description_40, m6_.copyright AS copyright_41, m6_.credits AS credits_42, m6_.locale AS locale_43, m6_.id AS id_44, s7_.username AS username_45, s7_.password AS password_46, s7_.locale AS locale_47, s7_.salt AS salt_48, s7_.locked AS locked_49, s7_.enabled AS enabled_50, s7_.lastLogin AS lastLogin_51, s7_.confirmationKey AS confirmationKey_52, s7_.passwordResetToken AS passwordResetToken_53, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_54, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_55, s7_.privateKey AS privateKey_56, s7_.apiKey AS apiKey_57, s7_.email AS email_58, s7_.id AS id_59, s7_.created AS created_60, s7_.changed AS changed_61, c8_.firstName AS firstName_62, c8_.middleName AS middleName_63, c8_.lastName AS lastName_64, c8_.birthday AS birthday_65, c8_.salutation AS salutation_66, c8_.formOfAddress AS formOfAddress_67, c8_.newsletter AS newsletter_68, c8_.gender AS gender_69, c8_.note AS note_70, c8_.mainEmail AS mainEmail_71, c8_.mainPhone AS mainPhone_72, c8_.mainFax AS mainFax_73, c8_.mainUrl AS mainUrl_74, c8_.id AS id_75, c8_.created AS created_76, c8_.changed AS changed_77, s9_.username AS username_78, s9_.password AS password_79, s9_.locale AS locale_80, s9_.salt AS salt_81, s9_.locked AS locked_82, s9_.enabled AS enabled_83, s9_.lastLogin AS lastLogin_84, s9_.confirmationKey AS confirmationKey_85, s9_.passwordResetToken AS passwordResetToken_86, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_87, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_88, s9_.privateKey AS privateKey_89, s9_.apiKey AS apiKey_90, s9_.email AS email_91, s9_.id AS id_92, s9_.created AS created_93, s9_.changed AS changed_94, c10_.firstName AS firstName_95, c10_.middleName AS middleName_96, c10_.lastName AS lastName_97, c10_.birthday AS birthday_98, c10_.salutation AS salutation_99, c10_.formOfAddress AS formOfAddress_100, c10_.newsletter AS newsletter_101, c10_.gender AS gender_102, c10_.note AS note_103, c10_.mainEmail AS mainEmail_104, c10_.mainPhone AS mainPhone_105, c10_.mainFax AS mainFax_106, c10_.mainUrl AS mainUrl_107, c10_.id AS id_108, c10_.created AS created_109, c10_.changed AS changed_110, m0_.idPreviewImage AS idPreviewImage_111, m0_.idCollections AS idCollections_112, m0_.idUsersCreator AS idUsersCreator_113, m0_.idUsersChanger AS idUsersChanger_114, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_115, m1_.idCollectionTypes AS idCollectionTypes_116, m1_.idCollectionsParent AS idCollectionsParent_117, m1_.idUsersCreator AS idUsersCreator_118, m1_.idUsersChanger AS idUsersChanger_119, m2_.idMedia AS idMedia_120, m2_.idUsersCreator AS idUsersCreator_121, m2_.idUsersChanger AS idUsersChanger_122, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_123, m3_.idFiles AS idFiles_124, m3_.idUsersCreator AS idUsersCreator_125, m3_.idUsersChanger AS idUsersChanger_126, t4_.idUsersCreator AS idUsersCreator_127, t4_.idUsersChanger AS idUsersChanger_128, m5_.idFileVersions AS idFileVersions_129, m6_.idFileVersions AS idFileVersions_130, s7_.idContacts AS idContacts_131, s7_.idUsersCreator AS idUsersCreator_132, s7_.idUsersChanger AS idUsersChanger_133, c8_.idTitles AS idTitles_134, c8_.avatar AS avatar_135, c8_.idUsersCreator AS idUsersCreator_136, c8_.idUsersChanger AS idUsersChanger_137, s9_.idContacts AS idContacts_138, s9_.idUsersCreator AS idUsersCreator_139, s9_.idUsersChanger AS idUsersChanger_140, c10_.idTitles AS idTitles_141, c10_.avatar AS avatar_142, c10_.idUsersCreator AS idUsersCreator_143, c10_.idUsersChanger AS idUsersChanger_144 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
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_.id AS id_26,
m3_.created AS created_27,
m3_.changed AS changed_28,
t4_.name AS name_29,
t4_.id AS id_30,
t4_.created AS created_31,
t4_.changed AS changed_32,
m5_.title AS title_33,
m5_.description AS description_34,
m5_.copyright AS copyright_35,
m5_.credits AS credits_36,
m5_.locale AS locale_37,
m5_.id AS id_38,
m6_.title AS title_39,
m6_.description AS description_40,
m6_.copyright AS copyright_41,
m6_.credits AS credits_42,
m6_.locale AS locale_43,
m6_.id AS id_44,
s7_.username AS username_45,
s7_.password AS password_46,
s7_.locale AS locale_47,
s7_.salt AS salt_48,
s7_.locked AS locked_49,
s7_.enabled AS enabled_50,
s7_.lastLogin AS lastLogin_51,
s7_.confirmationKey AS confirmationKey_52,
s7_.passwordResetToken AS passwordResetToken_53,
s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_54,
s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_55,
s7_.privateKey AS privateKey_56,
s7_.apiKey AS apiKey_57,
s7_.email AS email_58,
s7_.id AS id_59,
s7_.created AS created_60,
s7_.changed AS changed_61,
c8_.firstName AS firstName_62,
c8_.middleName AS middleName_63,
c8_.lastName AS lastName_64,
c8_.birthday AS birthday_65,
c8_.salutation AS salutation_66,
c8_.formOfAddress AS formOfAddress_67,
c8_.newsletter AS newsletter_68,
c8_.gender AS gender_69,
c8_.note AS note_70,
c8_.mainEmail AS mainEmail_71,
c8_.mainPhone AS mainPhone_72,
c8_.mainFax AS mainFax_73,
c8_.mainUrl AS mainUrl_74,
c8_.id AS id_75,
c8_.created AS created_76,
c8_.changed AS changed_77,
s9_.username AS username_78,
s9_.password AS password_79,
s9_.locale AS locale_80,
s9_.salt AS salt_81,
s9_.locked AS locked_82,
s9_.enabled AS enabled_83,
s9_.lastLogin AS lastLogin_84,
s9_.confirmationKey AS confirmationKey_85,
s9_.passwordResetToken AS passwordResetToken_86,
s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_87,
s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_88,
s9_.privateKey AS privateKey_89,
s9_.apiKey AS apiKey_90,
s9_.email AS email_91,
s9_.id AS id_92,
s9_.created AS created_93,
s9_.changed AS changed_94,
c10_.firstName AS firstName_95,
c10_.middleName AS middleName_96,
c10_.lastName AS lastName_97,
c10_.birthday AS birthday_98,
c10_.salutation AS salutation_99,
c10_.formOfAddress AS formOfAddress_100,
c10_.newsletter AS newsletter_101,
c10_.gender AS gender_102,
c10_.note AS note_103,
c10_.mainEmail AS mainEmail_104,
c10_.mainPhone AS mainPhone_105,
c10_.mainFax AS mainFax_106,
c10_.mainUrl AS mainUrl_107,
c10_.id AS id_108,
c10_.created AS created_109,
c10_.changed AS changed_110,
m0_.idPreviewImage AS idPreviewImage_111,
m0_.idCollections AS idCollections_112,
m0_.idUsersCreator AS idUsersCreator_113,
m0_.idUsersChanger AS idUsersChanger_114,
m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_115,
m1_.idCollectionTypes AS idCollectionTypes_116,
m1_.idCollectionsParent AS idCollectionsParent_117,
m1_.idUsersCreator AS idUsersCreator_118,
m1_.idUsersChanger AS idUsersChanger_119,
m2_.idMedia AS idMedia_120,
m2_.idUsersCreator AS idUsersCreator_121,
m2_.idUsersChanger AS idUsersChanger_122,
m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_123,
m3_.idFiles AS idFiles_124,
m3_.idUsersCreator AS idUsersCreator_125,
m3_.idUsersChanger AS idUsersChanger_126,
t4_.idUsersCreator AS idUsersCreator_127,
t4_.idUsersChanger AS idUsersChanger_128,
m5_.idFileVersions AS idFileVersions_129,
m6_.idFileVersions AS idFileVersions_130,
s7_.idContacts AS idContacts_131,
s7_.idUsersCreator AS idUsersCreator_132,
s7_.idUsersChanger AS idUsersChanger_133,
c8_.idTitles AS idTitles_134,
c8_.avatar AS avatar_135,
c8_.idUsersCreator AS idUsersCreator_136,
c8_.idUsersChanger AS idUsersChanger_137,
s9_.idContacts AS idContacts_138,
s9_.idUsersCreator AS idUsersCreator_139,
s9_.idUsersChanger AS idUsersChanger_140,
c10_.idTitles AS idTitles_141,
c10_.avatar AS avatar_142,
c10_.idUsersCreator AS idUsersCreator_143,
c10_.idUsersChanger AS idUsersChanger_144
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
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_.id AS id_26, m3_.created AS created_27, m3_.changed AS changed_28, t4_.name AS name_29, t4_.id AS id_30, t4_.created AS created_31, t4_.changed AS changed_32, m5_.title AS title_33, m5_.description AS description_34, m5_.copyright AS copyright_35, m5_.credits AS credits_36, m5_.locale AS locale_37, m5_.id AS id_38, m6_.title AS title_39, m6_.description AS description_40, m6_.copyright AS copyright_41, m6_.credits AS credits_42, m6_.locale AS locale_43, m6_.id AS id_44, s7_.username AS username_45, s7_.password AS password_46, s7_.locale AS locale_47, s7_.salt AS salt_48, s7_.locked AS locked_49, s7_.enabled AS enabled_50, s7_.lastLogin AS lastLogin_51, s7_.confirmationKey AS confirmationKey_52, s7_.passwordResetToken AS passwordResetToken_53, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_54, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_55, s7_.privateKey AS privateKey_56, s7_.apiKey AS apiKey_57, s7_.email AS email_58, s7_.id AS id_59, s7_.created AS created_60, s7_.changed AS changed_61, c8_.firstName AS firstName_62, c8_.middleName AS middleName_63, c8_.lastName AS lastName_64, c8_.birthday AS birthday_65, c8_.salutation AS salutation_66, c8_.formOfAddress AS formOfAddress_67, c8_.newsletter AS newsletter_68, c8_.gender AS gender_69, c8_.note AS note_70, c8_.mainEmail AS mainEmail_71, c8_.mainPhone AS mainPhone_72, c8_.mainFax AS mainFax_73, c8_.mainUrl AS mainUrl_74, c8_.id AS id_75, c8_.created AS created_76, c8_.changed AS changed_77, s9_.username AS username_78, s9_.password AS password_79, s9_.locale AS locale_80, s9_.salt AS salt_81, s9_.locked AS locked_82, s9_.enabled AS enabled_83, s9_.lastLogin AS lastLogin_84, s9_.confirmationKey AS confirmationKey_85, s9_.passwordResetToken AS passwordResetToken_86, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_87, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_88, s9_.privateKey AS privateKey_89, s9_.apiKey AS apiKey_90, s9_.email AS email_91, s9_.id AS id_92, s9_.created AS created_93, s9_.changed AS changed_94, c10_.firstName AS firstName_95, c10_.middleName AS middleName_96, c10_.lastName AS lastName_97, c10_.birthday AS birthday_98, c10_.salutation AS salutation_99, c10_.formOfAddress AS formOfAddress_100, c10_.newsletter AS newsletter_101, c10_.gender AS gender_102, c10_.note AS note_103, c10_.mainEmail AS mainEmail_104, c10_.mainPhone AS mainPhone_105, c10_.mainFax AS mainFax_106, c10_.mainUrl AS mainUrl_107, c10_.id AS id_108, c10_.created AS created_109, c10_.changed AS changed_110, m0_.idPreviewImage AS idPreviewImage_111, m0_.idCollections AS idCollections_112, m0_.idUsersCreator AS idUsersCreator_113, m0_.idUsersChanger AS idUsersChanger_114, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_115, m1_.idCollectionTypes AS idCollectionTypes_116, m1_.idCollectionsParent AS idCollectionsParent_117, m1_.idUsersCreator AS idUsersCreator_118, m1_.idUsersChanger AS idUsersChanger_119, m2_.idMedia AS idMedia_120, m2_.idUsersCreator AS idUsersCreator_121, m2_.idUsersChanger AS idUsersChanger_122, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_123, m3_.idFiles AS idFiles_124, m3_.idUsersCreator AS idUsersCreator_125, m3_.idUsersChanger AS idUsersChanger_126, t4_.idUsersCreator AS idUsersCreator_127, t4_.idUsersChanger AS idUsersChanger_128, m5_.idFileVersions AS idFileVersions_129, m6_.idFileVersions AS idFileVersions_130, s7_.idContacts AS idContacts_131, s7_.idUsersCreator AS idUsersCreator_132, s7_.idUsersChanger AS idUsersChanger_133, c8_.idTitles AS idTitles_134, c8_.avatar AS avatar_135, c8_.idUsersCreator AS idUsersCreator_136, c8_.idUsersChanger AS idUsersChanger_137, s9_.idContacts AS idContacts_138, s9_.idUsersCreator AS idUsersCreator_139, s9_.idUsersChanger AS idUsersChanger_140, c10_.idTitles AS idTitles_141, c10_.avatar AS avatar_142, c10_.idUsersCreator AS idUsersCreator_143, c10_.idUsersChanger AS idUsersChanger_144 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 (2) ORDER BY m0_.id ASC;
|
| 10 |
0.44 ms |
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 = ?
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 = 1;
|
| 11 |
0.74 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"
]
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
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 ('de')) 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 = 'website' AND p0_.depth <= 1 AND p7_.locale = 'de' AND p7_.stage = 'live' AND p7_.version = 0 AND (((p1_.locale IS NULL OR p1_.locale IN ('de')) AND (p1_.stage IS NULL OR p1_.stage IN ('live'))) AND (p1_.version IS NULL OR p1_.version IN (0))) AND p10_.name IN ('main') ORDER BY p0_.lft ASC;
|
| 12 |
0.82 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: [
"website"
"footer_settings"
]
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 = 'website' AND s0_.area_key = 'footer_settings';
|
| 13 |
1.23 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"
"019e53f1-44e9-7342-b776-8f14acaa497d"
"de"
"live"
0
"de"
"live"
0
]
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 (?)
)
)
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 ('de')) WHERE s0_.uuid = '019e53f1-44e9-7342-b776-8f14acaa497d' AND s5_.locale = 'de' AND s5_.stage = 'live' AND s5_.version = 0 AND (((s1_.locale IS NULL OR s1_.locale IN ('de')) AND (s1_.stage IS NULL OR s1_.stage IN ('live'))) AND (s1_.version IS NULL OR s1_.version IN (0)));
|
| 14 |
0.62 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: [
"019e6356-9517-71d2-b5d4-c50edfe20a0c"
"019e6355-fc30-7703-9b29-547420b12ea2"
"019e6355-3997-774f-a3a7-1a2ee881a628"
"019e63f1-79bc-7423-95f0-a91637588b9e"
"019e5978-c198-7f1f-ae84-75fc8fe8d5d4"
"019e597f-6060-7bf4-97d0-c7ecd2db2037"
"019e59ad-252a-7afc-9650-4d7f1e29598c"
"019e59aa-556c-7aa4-ad6c-226c3bdb21f6"
"019e592a-8c79-7f82-be6e-aa98d29f6e29"
"019e5939-7aa5-795e-b5d8-e85b896eb572"
"019e5931-e7e6-7cdf-a4bc-165d6dcb60ae"
"de"
"live"
0
]
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 ('019e6356-9517-71d2-b5d4-c50edfe20a0c', '019e6355-fc30-7703-9b29-547420b12ea2', '019e6355-3997-774f-a3a7-1a2ee881a628', '019e63f1-79bc-7423-95f0-a91637588b9e', '019e5978-c198-7f1f-ae84-75fc8fe8d5d4', '019e597f-6060-7bf4-97d0-c7ecd2db2037', '019e59ad-252a-7afc-9650-4d7f1e29598c', '019e59aa-556c-7aa4-ad6c-226c3bdb21f6', '019e592a-8c79-7f82-be6e-aa98d29f6e29', '019e5939-7aa5-795e-b5d8-e85b896eb572', '019e5931-e7e6-7cdf-a4bc-165d6dcb60ae') AND p1_.locale = 'de' AND p1_.stage = 'live' AND p1_.version = 0;
|
| 15 |
0.59 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: [
"neu.element13.cloud-4-fsn.securewebserver.de"
"dev"
"website"
]
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 = 'neu.element13.cloud-4-fsn.securewebserver.de' AND w1_.environment = 'dev')) AND w0_.webspace_key = 'website' ORDER BY w0_.id ASC;
|