0002: SHOW DATABASES LIKE 'ss\_uhl\_web\_production'
0.0009s
0003: SHOW FULL TABLES WHERE Table_Type != 'VIEW'
0.0034s
0004: SHOW FULL FIELDS IN "Fluent_Domain"
0.0017s
0005: SHOW COLLATION LIKE 'utf8mb3_general_ci'
0.0005s
0006: SELECT DISTINCT "Fluent_Domain"."ClassName", "Fluent_Domain"."LastEdited", "Fluent_Domain"."Created", "Fluent_Domain"."Domain", "Fluent_Domain"."DefaultLocaleID", "Fluent_Domain"."ID",
CASE WHEN "Fluent_Domain"."ClassName" IS NOT NULL THEN "Fluent_Domain"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\Domain' END AS "RecordClassName"
FROM "Fluent_Domain"
0.0004s
0007: SHOW FULL FIELDS IN "Fluent_Locale"
0.0019s
0008: SELECT DISTINCT "Fluent_Locale"."ClassName", "Fluent_Locale"."LastEdited", "Fluent_Locale"."Created", "Fluent_Locale"."Title", "Fluent_Locale"."Locale", "Fluent_Locale"."URLSegment", "Fluent_Locale"."IsGlobalDefault", "Fluent_Locale"."UseDefaultCode", "Fluent_Locale"."Sort", "Fluent_Locale"."Timezone", "Fluent_Locale"."DomainID", "Fluent_Locale"."ID",
CASE WHEN "Fluent_Locale"."ClassName" IS NOT NULL THEN "Fluent_Locale"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\Locale' END AS "RecordClassName"
FROM "Fluent_Locale"
ORDER BY "Fluent_Locale"."Sort" ASC, "Fluent_Locale"."Locale" ASC
0.0004s
0009: SELECT DISTINCT "Fluent_FallbackLocale"."ClassName", "Fluent_FallbackLocale"."LastEdited", "Fluent_FallbackLocale"."Created", "Fluent_FallbackLocale"."Sort", "Fluent_FallbackLocale"."ParentID", "Fluent_FallbackLocale"."LocaleID", "Fluent_FallbackLocale"."ID",
CASE WHEN "Fluent_FallbackLocale"."ClassName" IS NOT NULL THEN "Fluent_FallbackLocale"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\FallbackLocale' END AS "RecordClassName"
FROM "Fluent_FallbackLocale"
WHERE ("Fluent_FallbackLocale"."ParentID" = ?)
ORDER BY "Fluent_FallbackLocale"."Sort" ASC
0.0008s
0010: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE (COALESCE("SiteTree_Localised_de_DE"."URLSegment", "SiteTree_Live"."URLSegment") = ?)
AND ("SiteTree_Live"."ParentID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0017s
0011: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" = ?)
AND (COALESCE("SiteTree_Localised_de_DE"."URLSegment", "SiteTree_Live"."URLSegment") = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0006s
0012: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0004s
0013: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."CookieConsentTitle"
ELSE "SiteConfig"."CookieConsentTitle" END
AS "CookieConsentTitle", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."CookieConsentContent"
ELSE "SiteConfig"."CookieConsentContent" END
AS "CookieConsentContent", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."FormularDatenschutztext"
ELSE "SiteConfig"."FormularDatenschutztext" END
AS "FormularDatenschutztext", "SiteConfig"."ExtraCSS", "SiteConfig"."bingAPIKey", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."CostHint"
ELSE "SiteConfig"."CostHint" END
AS "CostHint", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."HintPayment"
ELSE "SiteConfig"."HintPayment" END
AS "HintPayment", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."HintAfterPayment"
ELSE "SiteConfig"."HintAfterPayment" END
AS "HintAfterPayment", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."ReceiptHeader"
ELSE "SiteConfig"."ReceiptHeader" END
AS "ReceiptHeader", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."ReceiptFooter"
ELSE "SiteConfig"."ReceiptFooter" END
AS "ReceiptFooter", "SiteConfig"."AdminNotificationMail", "SiteConfig"."AllowedCountries", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."ContactEmail"
ELSE "SiteConfig"."ContactEmail" END
AS "ContactEmail", "SiteConfig"."ContactPhone", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."Copyright"
ELSE "SiteConfig"."Copyright" END
AS "Copyright", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."ApplyFormReply"
ELSE "SiteConfig"."ApplyFormReply" END
AS "ApplyFormReply", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."ApplyFormReplySubject"
ELSE "SiteConfig"."ApplyFormReplySubject" END
AS "ApplyFormReplySubject", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."FooterContent"
ELSE "SiteConfig"."FooterContent" END
AS "FooterContent", "SiteConfig"."PrimaryColor", "SiteConfig"."SecondaryColor", "SiteConfig"."FontColor", "SiteConfig"."SideBarColor", "SiteConfig"."JobDefaultRecipient", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."QuickApplyButtonCaption"
ELSE "SiteConfig"."QuickApplyButtonCaption" END
AS "QuickApplyButtonCaption", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."QuickApplyTitle"
ELSE "SiteConfig"."QuickApplyTitle" END
AS "QuickApplyTitle", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."CookieConsentHint"
ELSE "SiteConfig"."CookieConsentHint" END
AS "CookieConsentHint", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."TrackingCode"
ELSE "SiteConfig"."TrackingCode" END
AS "TrackingCode", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."BadgeTitle"
ELSE "SiteConfig"."BadgeTitle" END
AS "BadgeTitle", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."BadgeSubTitle"
ELSE "SiteConfig"."BadgeSubTitle" END
AS "BadgeSubTitle", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."BadgeExternalLink"
ELSE "SiteConfig"."BadgeExternalLink" END
AS "BadgeExternalLink", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."ContactButtonCaption"
ELSE "SiteConfig"."ContactButtonCaption" END
AS "ContactButtonCaption", "SiteConfig"."BadgeColor", "SiteConfig"."ShippingCost", "SiteConfig"."ShippingFreeTreshold", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."ReceiptHeaderText"
ELSE "SiteConfig"."ReceiptHeaderText" END
AS "ReceiptHeaderText", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."FooterFirstMenuTitle"
ELSE "SiteConfig"."FooterFirstMenuTitle" END
AS "FooterFirstMenuTitle", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."FooterSecondMenuTitle"
ELSE "SiteConfig"."FooterSecondMenuTitle" END
AS "FooterSecondMenuTitle", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."FooterThirdMenuTitle"
ELSE "SiteConfig"."FooterThirdMenuTitle" END
AS "FooterThirdMenuTitle", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."FooterFourthMenuTitle"
ELSE "SiteConfig"."FooterFourthMenuTitle" END
AS "FooterFourthMenuTitle", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."FooterFifthMenuTitle"
ELSE "SiteConfig"."FooterFifthMenuTitle" END
AS "FooterFifthMenuTitle", "SiteConfig"."AccountingMailAddress", "SiteConfig"."ExternalContent", "SiteConfig"."PurchaseCompleteMessageUnpaid", "SiteConfig"."ManualPaymentInformation", "SiteConfig"."LatePaymentHint", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."Title"
ELSE "SiteConfig"."Title" END
AS "Title", CASE
WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN "SiteConfig_Localised_de_DE"."Tagline"
ELSE "SiteConfig"."Tagline" END
AS "Tagline", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."CMSLogoID", "SiteConfig"."ContactTeamMemberID", "SiteConfig"."ReceiptLogoID", "SiteConfig"."TermsPageID", "SiteConfig"."CustomerGroupID", "SiteConfig"."DefaultProductImageID", "SiteConfig"."BadgeLinkedPageID", "SiteConfig"."ContactLinkedPageID", "SiteConfig"."DefaultHeaderImageID", "SiteConfig"."DealerPageID", "SiteConfig"."ID",
CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName"
ELSE 'SilverStripe\\SiteConfig\\SiteConfig' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteConfig_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteConfig" LEFT JOIN "SiteConfig_Localised" AS "SiteConfig_Localised_de_DE" ON "SiteConfig"."ID" = "SiteConfig_Localised_de_DE"."RecordID" AND "SiteConfig_Localised_de_DE"."Locale" = ?
LIMIT 1
0.0029s
0014: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."ShowContactPerson", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGTitleCustom"
ELSE "Page_Live"."OGTitleCustom" END
AS "OGTitleCustom", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGDescriptionCustom"
ELSE "Page_Live"."OGDescriptionCustom" END
AS "OGDescriptionCustom", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."SubTitle"
ELSE "Page_Live"."SubTitle" END
AS "SubTitle", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInTopBar", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."MetaTitle"
ELSE "Page_Live"."MetaTitle" END
AS "MetaTitle", "Page_Live"."ShowPageHeaderTitle", "Page_Live"."ShowQuickApply", "Page_Live"."ShowInNaviEingeklappt", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."RelatedPagesHeadline"
ELSE "Page_Live"."RelatedPagesHeadline" END
AS "RelatedPagesHeadline", "Page_Live"."ShowSolidNavigation", "Page_Live"."ContactTeamMemberID", "Page_Live"."OGImageCustomID", "Page_Live"."PinterestImageCustomID", "Page_Live"."HeaderImageID", "Page_Live"."CustomCanonicalSiteID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale", "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_de_DE" ON "Page_Live"."ID" = "Page_Localised_de_DE"."RecordID" AND "Page_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0018s
0015: SELECT "ID"
FROM "SiteTree_Localised_Live"
WHERE ("RecordID" = ?)
AND ("Locale" = ?)
LIMIT 1
0.0003s
0016: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."ShowContactPerson", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGTitleCustom"
ELSE "Page_Live"."OGTitleCustom" END
AS "OGTitleCustom", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGDescriptionCustom"
ELSE "Page_Live"."OGDescriptionCustom" END
AS "OGDescriptionCustom", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."SubTitle"
ELSE "Page_Live"."SubTitle" END
AS "SubTitle", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInTopBar", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."MetaTitle"
ELSE "Page_Live"."MetaTitle" END
AS "MetaTitle", "Page_Live"."ShowPageHeaderTitle", "Page_Live"."ShowQuickApply", "Page_Live"."ShowInNaviEingeklappt", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."RelatedPagesHeadline"
ELSE "Page_Live"."RelatedPagesHeadline" END
AS "RelatedPagesHeadline", "Page_Live"."ShowSolidNavigation", "Page_Live"."ContactTeamMemberID", "Page_Live"."OGImageCustomID", "Page_Live"."PinterestImageCustomID", "Page_Live"."HeaderImageID", "Page_Live"."CustomCanonicalSiteID", CASE
WHEN "ProductCategoryHolder_Localised_de_DE"."ID" IS NOT NULL THEN "ProductCategoryHolder_Localised_de_DE"."CategoryStyle"
ELSE "ProductCategoryHolder_Live"."CategoryStyle" END
AS "CategoryStyle", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "ProductCategoryHolder_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "ProductCategoryHolder_Live" ON "ProductCategoryHolder_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_de_DE" ON "Page_Live"."ID" = "Page_Localised_de_DE"."RecordID" AND "Page_Localised_de_DE"."Locale" = ? LEFT JOIN "ProductCategoryHolder_Localised_Live" AS "ProductCategoryHolder_Localised_de_DE" ON "ProductCategoryHolder_Live"."ID" = "ProductCategoryHolder_Localised_de_DE"."RecordID" AND "ProductCategoryHolder_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0016s
0017: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
0018: SELECT "ID"
FROM "SiteTree_Localised_Live"
WHERE ("RecordID" = ?)
AND ("Locale" = ?)
LIMIT 1
0.0001s
0019: SELECT DISTINCT "Fluent_FallbackLocale"."ClassName", "Fluent_FallbackLocale"."LastEdited", "Fluent_FallbackLocale"."Created", "Fluent_FallbackLocale"."Sort", "Fluent_FallbackLocale"."ParentID", "Fluent_FallbackLocale"."LocaleID", "Fluent_FallbackLocale"."ID",
CASE WHEN "Fluent_FallbackLocale"."ClassName" IS NOT NULL THEN "Fluent_FallbackLocale"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\FallbackLocale' END AS "RecordClassName"
FROM "Fluent_FallbackLocale"
WHERE ("Fluent_FallbackLocale"."ParentID" = ?)
ORDER BY "Fluent_FallbackLocale"."Sort" ASC
0.0002s
0020: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."ShowContactPerson", CASE
WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."OGTitleCustom"
ELSE "Page_Live"."OGTitleCustom" END
AS "OGTitleCustom", CASE
WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."OGDescriptionCustom"
ELSE "Page_Live"."OGDescriptionCustom" END
AS "OGDescriptionCustom", CASE
WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."SubTitle"
ELSE "Page_Live"."SubTitle" END
AS "SubTitle", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInTopBar", CASE
WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."MetaTitle"
ELSE "Page_Live"."MetaTitle" END
AS "MetaTitle", "Page_Live"."ShowPageHeaderTitle", "Page_Live"."ShowQuickApply", "Page_Live"."ShowInNaviEingeklappt", CASE
WHEN "Page_Localised_fr_FR"."ID" IS NOT NULL THEN "Page_Localised_fr_FR"."RelatedPagesHeadline"
ELSE "Page_Live"."RelatedPagesHeadline" END
AS "RelatedPagesHeadline", "Page_Live"."ShowSolidNavigation", "Page_Live"."ContactTeamMemberID", "Page_Live"."OGImageCustomID", "Page_Live"."PinterestImageCustomID", "Page_Live"."HeaderImageID", "Page_Live"."CustomCanonicalSiteID", CASE
WHEN "ProductCategoryHolder_Localised_fr_FR"."ID" IS NOT NULL THEN "ProductCategoryHolder_Localised_fr_FR"."CategoryStyle"
ELSE "ProductCategoryHolder_Live"."CategoryStyle" END
AS "CategoryStyle", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'fr_FR' AS "Locale", CASE WHEN "ProductCategoryHolder_Localised_fr_FR"."ID" IS NOT NULL THEN 'fr_FR'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "ProductCategoryHolder_Live" ON "ProductCategoryHolder_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_fr_FR" ON "SiteTree_Live"."ID" = "SiteTree_Localised_fr_FR"."RecordID" AND "SiteTree_Localised_fr_FR"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_fr_FR" ON "Page_Live"."ID" = "Page_Localised_fr_FR"."RecordID" AND "Page_Localised_fr_FR"."Locale" = ? LEFT JOIN "ProductCategoryHolder_Localised_Live" AS "ProductCategoryHolder_Localised_fr_FR" ON "ProductCategoryHolder_Live"."ID" = "ProductCategoryHolder_Localised_fr_FR"."RecordID" AND "ProductCategoryHolder_Localised_fr_FR"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
AND (("SiteTree_Localised_fr_FR"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0006s
0021: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN "SiteTree_Localised_fr_FR"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'fr_FR' AS "Locale", CASE WHEN "SiteTree_Localised_fr_FR"."ID" IS NOT NULL THEN 'fr_FR'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_fr_FR" ON "SiteTree_Live"."ID" = "SiteTree_Localised_fr_FR"."RecordID" AND "SiteTree_Localised_fr_FR"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_fr_FR"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0003s
0022: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."CropData", "Image_Live"."AltText", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0014s
0023: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
0024: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
0025: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."ShowContactPerson", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGTitleCustom"
ELSE "Page_Live"."OGTitleCustom" END
AS "OGTitleCustom", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGDescriptionCustom"
ELSE "Page_Live"."OGDescriptionCustom" END
AS "OGDescriptionCustom", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."SubTitle"
ELSE "Page_Live"."SubTitle" END
AS "SubTitle", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInTopBar", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."MetaTitle"
ELSE "Page_Live"."MetaTitle" END
AS "MetaTitle", "Page_Live"."ShowPageHeaderTitle", "Page_Live"."ShowQuickApply", "Page_Live"."ShowInNaviEingeklappt", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."RelatedPagesHeadline"
ELSE "Page_Live"."RelatedPagesHeadline" END
AS "RelatedPagesHeadline", "Page_Live"."ShowSolidNavigation", "Page_Live"."ContactTeamMemberID", "Page_Live"."OGImageCustomID", "Page_Live"."PinterestImageCustomID", "Page_Live"."HeaderImageID", "Page_Live"."CustomCanonicalSiteID", CASE
WHEN "CookiePolicyPage_Localised_de_DE"."ID" IS NOT NULL THEN "CookiePolicyPage_Localised_de_DE"."FooterContent"
ELSE "CookiePolicyPage_Live"."FooterContent" END
AS "FooterContent", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "CookiePolicyPage_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "CookiePolicyPage_Live" ON "CookiePolicyPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_de_DE" ON "Page_Live"."ID" = "Page_Localised_de_DE"."RecordID" AND "Page_Localised_de_DE"."Locale" = ? LEFT JOIN "CookiePolicyPage_Localised_Live" AS "CookiePolicyPage_Localised_de_DE" ON "CookiePolicyPage_Live"."ID" = "CookiePolicyPage_Localised_de_DE"."RecordID" AND "CookiePolicyPage_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ClassName" IN (?))
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0018s
0026: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
0027: SELECT DISTINCT "TeamMember"."ClassName", "TeamMember"."LastEdited", "TeamMember"."Created", "TeamMember"."LinkedIn", CASE
WHEN "TeamMember_Localised_de_DE"."ID" IS NOT NULL THEN "TeamMember_Localised_de_DE"."Title"
ELSE "TeamMember"."Title" END
AS "Title", CASE
WHEN "TeamMember_Localised_de_DE"."ID" IS NOT NULL THEN "TeamMember_Localised_de_DE"."Position"
ELSE "TeamMember"."Position" END
AS "Position", "TeamMember"."Phone", "TeamMember"."Mobile", "TeamMember"."Mail", "TeamMember"."Fax", "TeamMember"."Sort", "TeamMember"."URLSegment", "TeamMember"."TeamPageID", "TeamMember"."ImageID", "TeamMember"."ID",
CASE WHEN "TeamMember"."ClassName" IS NOT NULL THEN "TeamMember"."ClassName"
ELSE 'Team\\DataObjects\\TeamMember' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "TeamMember_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "TeamMember" LEFT JOIN "TeamMember_Localised" AS "TeamMember_Localised_de_DE" ON "TeamMember"."ID" = "TeamMember_Localised_de_DE"."RecordID" AND "TeamMember_Localised_de_DE"."Locale" = ?
WHERE ("TeamMember"."ID" = ?)
AND (("TeamMember_Localised_de_DE"."ID" IS NOT NULL))
LIMIT 1
0.0024s
0028: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."CropData", "Image_Live"."AltText", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0002s
0029: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."ShowContactPerson", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGTitleCustom"
ELSE "Page_Live"."OGTitleCustom" END
AS "OGTitleCustom", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGDescriptionCustom"
ELSE "Page_Live"."OGDescriptionCustom" END
AS "OGDescriptionCustom", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."SubTitle"
ELSE "Page_Live"."SubTitle" END
AS "SubTitle", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInTopBar", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."MetaTitle"
ELSE "Page_Live"."MetaTitle" END
AS "MetaTitle", "Page_Live"."ShowPageHeaderTitle", "Page_Live"."ShowQuickApply", "Page_Live"."ShowInNaviEingeklappt", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."RelatedPagesHeadline"
ELSE "Page_Live"."RelatedPagesHeadline" END
AS "RelatedPagesHeadline", "Page_Live"."ShowSolidNavigation", "Page_Live"."ContactTeamMemberID", "Page_Live"."OGImageCustomID", "Page_Live"."PinterestImageCustomID", "Page_Live"."HeaderImageID", "Page_Live"."CustomCanonicalSiteID", CASE
WHEN "RequestedProductListPage_Localised_de_DE"."ID" IS NOT NULL THEN "RequestedProductListPage_Localised_de_DE"."RequestAnswer"
ELSE "RequestedProductListPage_Live"."RequestAnswer" END
AS "RequestAnswer", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "RequestedProductListPage_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "RequestedProductListPage_Live" ON "RequestedProductListPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_de_DE" ON "Page_Live"."ID" = "Page_Localised_de_DE"."RecordID" AND "Page_Localised_de_DE"."Locale" = ? LEFT JOIN "RequestedProductListPage_Localised_Live" AS "RequestedProductListPage_Localised_de_DE" ON "RequestedProductListPage_Live"."ID" = "RequestedProductListPage_Localised_de_DE"."RecordID" AND "RequestedProductListPage_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ClassName" IN (?))
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0017s
0030: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."ShowContactPerson", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGTitleCustom"
ELSE "Page_Live"."OGTitleCustom" END
AS "OGTitleCustom", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."OGDescriptionCustom"
ELSE "Page_Live"."OGDescriptionCustom" END
AS "OGDescriptionCustom", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."SubTitle"
ELSE "Page_Live"."SubTitle" END
AS "SubTitle", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInTopBar", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."MetaTitle"
ELSE "Page_Live"."MetaTitle" END
AS "MetaTitle", "Page_Live"."ShowPageHeaderTitle", "Page_Live"."ShowQuickApply", "Page_Live"."ShowInNaviEingeklappt", CASE
WHEN "Page_Localised_de_DE"."ID" IS NOT NULL THEN "Page_Localised_de_DE"."RelatedPagesHeadline"
ELSE "Page_Live"."RelatedPagesHeadline" END
AS "RelatedPagesHeadline", "Page_Live"."ShowSolidNavigation", "Page_Live"."ContactTeamMemberID", "Page_Live"."OGImageCustomID", "Page_Live"."PinterestImageCustomID", "Page_Live"."HeaderImageID", "Page_Live"."CustomCanonicalSiteID", CASE
WHEN "SilverShop_CartPage_Localised_de_DE"."ID" IS NOT NULL THEN "SilverShop_CartPage_Localised_de_DE"."ButtonCaption"
ELSE "SilverShop_CartPage_Live"."ButtonCaption" END
AS "ButtonCaption", "SilverShop_CartPage_Live"."LinkedPageID", "SilverShop_CartPage_Live"."CheckoutPageID", "SilverShop_CartPage_Live"."ContinuePageID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SilverShop_CartPage_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SilverShop_CartPage_Live" ON "SilverShop_CartPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_de_DE" ON "Page_Live"."ID" = "Page_Localised_de_DE"."RecordID" AND "Page_Localised_de_DE"."Locale" = ? LEFT JOIN "SilverShop_CartPage_Localised_Live" AS "SilverShop_CartPage_Localised_de_DE" ON "SilverShop_CartPage_Live"."ID" = "SilverShop_CartPage_Localised_de_DE"."RecordID" AND "SilverShop_CartPage_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ClassName" IN (?))
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0015s
0031: SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count"
FROM "SiteTree_Live" INNER JOIN "Page_RelatedPages" ON "Page_RelatedPages"."SiteTreeID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("Page_RelatedPages"."PageID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
0.0011s
0032: SELECT "Version" FROM "SiteTree" WHERE "ID" = ?
0.001s
0033: SELECT "BaseTable"."RecordID" as "LatestID", MAX("SiteTree_Localised_Versions"."Version") as "LatestVersion" FROM "SiteTree_Localised" AS "BaseTable" INNER JOIN "SiteTree_Localised_Versions" ON "BaseTable"."RecordID" = "SiteTree_Localised_Versions"."RecordID" AND "SiteTree_Localised_Versions"."Locale" = ? INNER JOIN "SiteTree_Versions" ON "SiteTree_Versions"."RecordID" = "SiteTree_Localised_Versions"."RecordID" AND "SiteTree_Versions"."Version" = "SiteTree_Localised_Versions"."Version" WHERE "BaseTable"."Locale" = ? AND "BaseTable"."RecordID" IN (?) GROUP BY "LatestID"
0.0019s
0034: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
0035: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
0036: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
0037: SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", "SiteTree"."Priority", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree"."MetaDescription" END
AS "MetaDescription", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree"."ReportClass" END
AS "ReportClass", "SiteTree"."ParentID", "SiteTree"."ID",
CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree" LEFT JOIN "SiteTree_Localised" AS "SiteTree_Localised_de_DE" ON "SiteTree"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree"."Sort" ASC
LIMIT 1
0.0004s
0038: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
0039: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN "SiteTree_Localised_de_DE"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'de_DE' AS "Locale", CASE WHEN "SiteTree_Localised_de_DE"."ID" IS NOT NULL THEN 'de_DE'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_de_DE" ON "SiteTree_Live"."ID" = "SiteTree_Localised_de_DE"."RecordID" AND "SiteTree_Localised_de_DE"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_de_DE"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
Sand, Kies & Splitt: Baustoffe für jede Anwendung » UHL
Diese Website verwendet Cookies
Wir verwenden Cookies, um Inhalte zu personalisieren, Funktionen für soziale Medien bereitzustellen und unseren Datenverkehr zu analysieren. Wir geben auch Informationen über Ihre Nutzung unserer Website an unsere Partner für soziale Medien und Analysen weiter, die diese möglicherweise mit anderen Informationen kombinieren, die Sie ihnen zur Verfügung gestellt haben oder die sie durch Ihre Nutzung ihrer Dienste gesammelt haben. Sie stimmen unseren Cookies zu, wenn Sie unsere Website weiterhin nutzen. Für weitere Informationen zu unserem Datenschutz klicken Sie bitte hier.
Französisch
