0003: SET SESSION sql_mode='REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE';
0.0001s
0004: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."OGTitle", "SiteTree_Live"."OGType", "SiteTree_Live"."OGDescription", "SiteTree_Live"."BGVideoURL", "SiteTree_Live"."BGVideoType", "SiteTree_Live"."BGVideoID", "SiteTree_Live"."BGVideoStatus", "SiteTree_Live"."BGVideoDelay", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "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"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."URLSegment" = ?)
AND ("SiteTree_Live"."ParentID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0013s
0005: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", "SiteConfig"."CookieConsentTitle", "SiteConfig"."CookieConsentContent", "SiteConfig"."AdminEmail", "SiteConfig"."SupportEmail", "SiteConfig"."NoReplyEmail", "SiteConfig"."Copyright", "SiteConfig"."Credit", "SiteConfig"."PhoneNumber", "SiteConfig"."TollFreeNumber", "SiteConfig"."FaxNumber", "SiteConfig"."GTMID", "SiteConfig"."GoogleMapsAddress", "SiteConfig"."Title", "SiteConfig"."Tagline", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."LayoutDefaultImageID", "SiteConfig"."ID",
CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName"
ELSE 'SilverStripe\\SiteConfig\\SiteConfig' END AS "RecordClassName"
FROM "SiteConfig"
LIMIT 1
0.0003s
0006: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "SiteTree_Live"."Keywords" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."Keywords" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."Keywords" ELSE NULL END AS "Keywords", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."SSLayoutTemplate" WHEN "SiteTree_Live"."ClassName" IN ('CookiePolicyPage') THEN "CookiePolicyPage_Live"."SSLayoutTemplate" ELSE NULL END AS "SSLayoutTemplate", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."SSLayoutClasses" WHEN "SiteTree_Live"."ClassName" IN ('CookiePolicyPage') THEN "CookiePolicyPage_Live"."SSLayoutClasses" ELSE NULL END AS "SSLayoutClasses", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "SiteTree_Live"."Title" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."Title" ELSE NULL END AS "Title", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "SiteTree_Live"."SearchContent" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."SearchContent" ELSE NULL END AS "SearchContent", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "SiteTree_Live"."ShowInSearch" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."ShowInSearch" ELSE NULL END AS "ShowInSearch", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "SiteTree_Live"."Weight" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."Weight" ELSE NULL END AS "Weight", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", "SiteTree_Live"."Sort"
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"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0011s
0007: SELECT DISTINCT "Navigation"."ClassName", "Navigation"."LastEdited", "Navigation"."Created", "Navigation"."Title", "Navigation"."Description", "Navigation"."Key", "Navigation"."ExtraCSS", "Navigation"."Active", "Navigation"."ID",
CASE WHEN "Navigation"."ClassName" IS NOT NULL THEN "Navigation"."ClassName"
ELSE 'RS\\NavBuilder\\Model\\Navigation' END AS "RecordClassName"
FROM "Navigation"
WHERE ("Navigation"."Key" = ?)
AND ("Navigation"."Active" = ?)
LIMIT 1
0.0007s
0008: SELECT DISTINCT "Navigation"."ClassName", "Navigation"."LastEdited", "Navigation"."Created", "Navigation"."Title", "Navigation"."Description", "Navigation"."Key", "Navigation"."ExtraCSS", "Navigation"."Active", "Navigation"."ID",
CASE WHEN "Navigation"."ClassName" IS NOT NULL THEN "Navigation"."ClassName"
ELSE 'RS\\NavBuilder\\Model\\Navigation' END AS "RecordClassName"
FROM "Navigation"
WHERE ("Navigation"."Key" = ?)
AND ("Navigation"."Active" = ?)
LIMIT 1
0.0007s
0009: SELECT DISTINCT "Navigation_PrimaryLinks"."Sort", "Link"."ClassName", "Link"."LastEdited", "Link"."Created", "Link"."Anchor", "Link"."ButtonLabel", "Link"."RelOptions", "Link"."ExtraCSS", "Link"."Key", "Link"."Description", "Link"."Title", "Link"."Type", "Link"."URL", "Link"."Email", "Link"."Phone", "Link"."OpenInNewWindow", "Link"."SelectedStyle", "Link"."SiteTreeID", "Link"."ImageID", "Link"."FileID", "NavigationLinks"."RenderMultiLevel", "Link"."ID",
CASE WHEN "Link"."ClassName" IS NOT NULL THEN "Link"."ClassName"
ELSE 'gorriecoe\\Link\\Models\\Link' END AS "RecordClassName"
FROM "Link" LEFT JOIN "NavigationLinks" ON "NavigationLinks"."ID" = "Link"."ID" INNER JOIN "Navigation_PrimaryLinks" ON "Navigation_PrimaryLinks"."NavigationLinksID" = "Link"."ID"
WHERE ("Navigation_PrimaryLinks"."NavigationID" = ?)
AND ("Link"."ClassName" IN (?))
ORDER BY "Sort" ASC
LIMIT 1
0.002s
0010: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" LEFT JOIN "NavigationLinks" ON "NavigationLinks"."ID" = "Link"."ID" INNER JOIN "Navigation_Links" ON "Navigation_Links"."NavigationLinksID" = "Link"."ID"
WHERE ("Navigation_Links"."NavigationID" = ?)
AND ("Link"."ClassName" IN (?))
0.0006s
0011: SELECT DISTINCT "Navigation_Links"."Sort", "Link"."ClassName", "Link"."LastEdited", "Link"."Created", "Link"."Anchor", "Link"."ButtonLabel", "Link"."RelOptions", "Link"."ExtraCSS", "Link"."Key", "Link"."Description", "Link"."Title", "Link"."Type", "Link"."URL", "Link"."Email", "Link"."Phone", "Link"."OpenInNewWindow", "Link"."SelectedStyle", "Link"."SiteTreeID", "Link"."ImageID", "Link"."FileID", "NavigationLinks"."RenderMultiLevel", "Link"."ID",
CASE WHEN "Link"."ClassName" IS NOT NULL THEN "Link"."ClassName"
ELSE 'gorriecoe\\Link\\Models\\Link' END AS "RecordClassName"
FROM "Link" LEFT JOIN "NavigationLinks" ON "NavigationLinks"."ID" = "Link"."ID" INNER JOIN "Navigation_Links" ON "Navigation_Links"."NavigationLinksID" = "Link"."ID"
WHERE ("Navigation_Links"."NavigationID" = ?)
AND ("Link"."ClassName" IN (?))
ORDER BY "Sort" ASC
0.0016s
0012: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."OGTitle", "SiteTree_Live"."OGType", "SiteTree_Live"."OGDescription", "SiteTree_Live"."BGVideoURL", "SiteTree_Live"."BGVideoType", "SiteTree_Live"."BGVideoID", "SiteTree_Live"."BGVideoStatus", "SiteTree_Live"."BGVideoDelay", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "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"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0009s
0013: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" LEFT JOIN "NavigationLinks" ON "NavigationLinks"."ID" = "Link"."ID" INNER JOIN "NavigationLinks_Links" ON "NavigationLinks_Links"."ChildID" = "Link"."ID"
WHERE ("NavigationLinks_Links"."NavigationLinksID" = ?)
AND ("Link"."ClassName" IN (?))
0.0019s
0014: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."OGTitle", "SiteTree_Live"."OGType", "SiteTree_Live"."OGDescription", "SiteTree_Live"."BGVideoURL", "SiteTree_Live"."BGVideoType", "SiteTree_Live"."BGVideoID", "SiteTree_Live"."BGVideoStatus", "SiteTree_Live"."BGVideoDelay", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "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"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0006s
0015: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" LEFT JOIN "NavigationLinks" ON "NavigationLinks"."ID" = "Link"."ID" INNER JOIN "NavigationLinks_Links" ON "NavigationLinks_Links"."ChildID" = "Link"."ID"
WHERE ("NavigationLinks_Links"."NavigationLinksID" = ?)
AND ("Link"."ClassName" IN (?))
0.0007s
0016: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."OGTitle", "SiteTree_Live"."OGType", "SiteTree_Live"."OGDescription", "SiteTree_Live"."BGVideoURL", "SiteTree_Live"."BGVideoType", "SiteTree_Live"."BGVideoID", "SiteTree_Live"."BGVideoStatus", "SiteTree_Live"."BGVideoDelay", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "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"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0007s
0017: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" LEFT JOIN "NavigationLinks" ON "NavigationLinks"."ID" = "Link"."ID" INNER JOIN "NavigationLinks_Links" ON "NavigationLinks_Links"."ChildID" = "Link"."ID"
WHERE ("NavigationLinks_Links"."NavigationLinksID" = ?)
AND ("Link"."ClassName" IN (?))
0.0007s
0018: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."OGTitle", "SiteTree_Live"."OGType", "SiteTree_Live"."OGDescription", "SiteTree_Live"."BGVideoURL", "SiteTree_Live"."BGVideoType", "SiteTree_Live"."BGVideoID", "SiteTree_Live"."BGVideoStatus", "SiteTree_Live"."BGVideoDelay", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "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"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0006s
0019: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" LEFT JOIN "NavigationLinks" ON "NavigationLinks"."ID" = "Link"."ID" INNER JOIN "NavigationLinks_Links" ON "NavigationLinks_Links"."ChildID" = "Link"."ID"
WHERE ("NavigationLinks_Links"."NavigationLinksID" = ?)
AND ("Link"."ClassName" IN (?))
0.0042s
0020: SELECT DISTINCT count(DISTINCT "Socials"."ID") AS "Count"
FROM "Socials" INNER JOIN "SiteConfig_Socials" ON "SiteConfig_Socials"."SocialsID" = "Socials"."ID"
WHERE ("SiteConfig_Socials"."SiteConfigID" = ?)
0.0007s
0021: SELECT DISTINCT "Navigation"."ClassName", "Navigation"."LastEdited", "Navigation"."Created", "Navigation"."Title", "Navigation"."Description", "Navigation"."Key", "Navigation"."ExtraCSS", "Navigation"."Active", "Navigation"."ID",
CASE WHEN "Navigation"."ClassName" IS NOT NULL THEN "Navigation"."ClassName"
ELSE 'RS\\NavBuilder\\Model\\Navigation' END AS "RecordClassName"
FROM "Navigation"
WHERE ("Navigation"."Key" = ?)
AND ("Navigation"."Active" = ?)
LIMIT 1
0.0005s
0022: SELECT DISTINCT "Navigation"."ClassName", "Navigation"."LastEdited", "Navigation"."Created", "Navigation"."Title", "Navigation"."Description", "Navigation"."Key", "Navigation"."ExtraCSS", "Navigation"."Active", "Navigation"."ID",
CASE WHEN "Navigation"."ClassName" IS NOT NULL THEN "Navigation"."ClassName"
ELSE 'RS\\NavBuilder\\Model\\Navigation' END AS "RecordClassName"
FROM "Navigation"
WHERE ("Navigation"."Key" = ?)
AND ("Navigation"."Active" = ?)
LIMIT 1
0.0005s
0023: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "ElementalPage_Live"."ElementalAreaID", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "SiteTree_Live"."Title" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."Title" ELSE NULL END AS "Title", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "SiteTree_Live"."SearchContent" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."SearchContent" ELSE NULL END AS "SearchContent", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "SiteTree_Live"."Keywords" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."Keywords" ELSE NULL END AS "Keywords", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "SiteTree_Live"."ShowInSearch" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."ShowInSearch" ELSE NULL END AS "ShowInSearch", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "SiteTree_Live"."Weight" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."Weight" ELSE NULL END AS "Weight", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "ElementalPage_Live" ON "ElementalPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0008s
0024: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0004s
0025: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "Element_Live"."AvailableGlobally", "Element_Live"."VirtualLookupTitle", "Element_Live"."ElementalInlineStyles", "Element_Live"."XS", "Element_Live"."SM", "Element_Live"."MM", "Element_Live"."LG", "Element_Live"."XL", "Element_Live"."XXL", "Element_Live"."Orientation", "Element_Live"."Gap", "Element_Live"."FocusText", "Element_Live"."Overline", "Element_Live"."TypeScale", "Element_Live"."Label", "Element_Live"."ContentPosition", "Element_Live"."ContentAlign", "Element_Live"."Compact", "Element_Live"."Elevation", "Element_Live"."DisplayOverline", "Element_Live"."DisplayContent", "Element_Live"."CollapseMarginTop", "Element_Live"."CollapseMarginBottom", "Element_Live"."Animations", "Element_Live"."DisplayLinks", "Element_Live"."Stackable", "Element_Live"."Prefetch", "Element_Live"."BlockID", "Element_Live"."Version", "Element_Live"."Title", "Element_Live"."ShowTitle", "Element_Live"."Sort", "Element_Live"."ExtraClass", "Element_Live"."Style", "Element_Live"."TopPageID", "Element_Live"."ParentID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName"
FROM "Element_Live"
WHERE ("Element_Live"."ParentID" = ?)
ORDER BY "Element_Live"."Sort" ASC
0.0012s
0026: SELECT DISTINCT count(DISTINCT "ElementalStyleProperties"."ID") AS "Count"
FROM "ElementalStyleProperties"
WHERE ("ElementalStyleProperties"."StyleOwnerClass" IN ('RS\\Elemental\\Model\\UIElementalPageHeader'))
AND ("ElementalStyleProperties"."StyleOwnerID" = ?)
0.0009s
0027: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "UIElementalPageHeader_Live"."Content", "UIElementalPageHeader_Live"."Case", "UIElementalPageHeader_Live"."Animation", "UIElementalPageHeader_Live"."Decoration", "UIElementalPageHeader_Live"."Depth", "UIElementalPageHeader_Live"."ShowUIContent", "UIElementalPageHeader_Live"."BlockTemplate", "UIElementalPageHeader_Live"."ImageID", "UIElementalPageHeader_Live"."PageID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "UIElementalPageHeader_Live" ON "UIElementalPageHeader_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0006s
0028: SELECT DISTINCT count(DISTINCT "AspectRatios"."ID") AS "Count"
FROM "AspectRatios" INNER JOIN "Element_AspectRatios" ON "Element_AspectRatios"."AspectRatiosID" = "AspectRatios"."ID"
WHERE ("Element_AspectRatios"."ElementID" = ?)
0.001s
0029: SELECT DISTINCT "Element_AspectRatios"."Sort", "AspectRatios"."ClassName", "AspectRatios"."LastEdited", "AspectRatios"."Created", "AspectRatios"."Scale", "AspectRatios"."Ratio", "AspectRatios"."Orientation", "AspectRatios"."ID",
CASE WHEN "AspectRatios"."ClassName" IS NOT NULL THEN "AspectRatios"."ClassName"
ELSE 'RS\\Model\\AspectRatio' END AS "RecordClassName"
FROM "AspectRatios" INNER JOIN "Element_AspectRatios" ON "Element_AspectRatios"."AspectRatiosID" = "AspectRatios"."ID"
WHERE ("Element_AspectRatios"."ElementID" = ?)
ORDER BY "Sort" ASC
0.001s
0030: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0004s
0031: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."OGTitle", "SiteTree_Live"."OGType", "SiteTree_Live"."OGDescription", "SiteTree_Live"."BGVideoURL", "SiteTree_Live"."BGVideoType", "SiteTree_Live"."BGVideoID", "SiteTree_Live"."BGVideoStatus", "SiteTree_Live"."BGVideoDelay", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "SiteTree_Live"."Title" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."Title" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."Title" ELSE NULL END AS "Title", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "SiteTree_Live"."SearchContent" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."SearchContent" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."SearchContent" ELSE NULL END AS "SearchContent", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "SiteTree_Live"."Keywords" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."Keywords" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."Keywords" ELSE NULL END AS "Keywords", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "SiteTree_Live"."ShowInSearch" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."ShowInSearch" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."ShowInSearch" ELSE NULL END AS "ShowInSearch", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "SiteTree_Live"."Weight" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."Weight" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."Weight" ELSE NULL END AS "Weight", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "SiteTree_Live"."ParentID", "Page_Live"."SSLayoutTemplate", "Page_Live"."SSLayoutClasses", "ElementalPage_Live"."ElementalAreaID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "ElementalPage_Live" ON "ElementalPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("ElementalPage_Live"."ElementalAreaID" = ?)
AND ("SiteTree_Live"."ClassName" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.002s
0032: 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"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "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.0008s
0033: SELECT DISTINCT count(DISTINCT "ElementalStyleProperties"."ID") AS "Count"
FROM "ElementalStyleProperties"
WHERE ("ElementalStyleProperties"."StyleOwnerClass" IN ('RS\\Elemental\\Model\\UIElementalPageHeader'))
AND ("ElementalStyleProperties"."StyleOwnerID" = ?)
0.0006s
0034: SELECT DISTINCT count(DISTINCT "UIPageHeaderContent"."ID") AS "Count"
FROM "UIPageHeaderContent"
WHERE ("UIPageHeaderContent"."PageHeaderID" = ?)
AND ("UIPageHeaderContent"."Active" = ?)
0.0003s
0035: SELECT DISTINCT count(DISTINCT "ElementalStyleProperties"."ID") AS "Count"
FROM "ElementalStyleProperties"
WHERE ("ElementalStyleProperties"."StyleOwnerClass" IN ('RS\\Elemental\\Model\\UIElementalContent'))
AND ("ElementalStyleProperties"."StyleOwnerID" = ?)
0.0005s
0036: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0004s
0037: SELECT DISTINCT count(DISTINCT "ElementalStyleProperties"."ID") AS "Count"
FROM "ElementalStyleProperties"
WHERE ("ElementalStyleProperties"."StyleOwnerClass" IN ('RS\\Elemental\\Model\\UIElementalContent'))
AND ("ElementalStyleProperties"."StyleOwnerID" = ?)
0.0007s
0038: SELECT DISTINCT count(DISTINCT "AspectRatios"."ID") AS "Count"
FROM "AspectRatios" INNER JOIN "Element_AspectRatios" ON "Element_AspectRatios"."AspectRatiosID" = "AspectRatios"."ID"
WHERE ("Element_AspectRatios"."ElementID" = ?)
0.0004s
0039: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE WHEN "Element_Live"."ClassName" IN ('DNADesign\\Elemental\\Models\\BaseElement', 'RS\\Elemental\\Model\\MosaicTile', 'RS\\Model\\TemplateTile', 'RS\\Model\\Tile', 'RS\\Elemental\\Model\\UIElementalBanner', 'RS\\Elemental\\Model\\UIElementalBlogPostList', 'RS\\Elemental\\Model\\UIElementalCTAGroup', 'RS\\Elemental\\Model\\UIElementalCarousel', 'RS\\Elemental\\Model\\UIElementalColumn', 'RS\\Elemental\\Model\\UIElementalCommunityStats', 'RS\\Elemental\\Model\\UIElementalContent', 'RS\\Elemental\\Model\\UIElementalContentGroup', 'RS\\Elemental\\Model\\UIElementalCrowdriff', 'RS\\Elemental\\Model\\UIElementalFeatureBlock', 'RS\\Elemental\\Model\\UIElementalFeatureMap', 'RS\\Elemental\\Model\\UIElementalFeaturedGrid', 'RS\\Elemental\\Model\\UIElementalGallery', 'RS\\Elemental\\Model\\UIElementalGrid', 'RS\\Elemental\\Model\\UIElementalLocomotiveSection', 'RS\\Elemental\\Model\\UIElementalLogoGarden', 'RS\\Elemental\\Model\\UIElementalMosaic', 'RS\\Elemental\\Model\\UIElementalPageHeader', 'RS\\Elemental\\Model\\UIElementalPartnerList', 'RS\\Elemental\\Model\\UIElementalPartnerMap', 'RS\\Elemental\\Model\\UIElementalRepeater', 'RS\\Elemental\\Model\\UIElementalSlide', 'RS\\Elemental\\Model\\UIElementalSpacer', 'RS\\Elemental\\Model\\UIElementalTimeline', 'RS\\Elemental\\Model\\UIElementalTriptych', 'DNADesign\\Elemental\\Models\\ElementContent', 'DNADesign\\ElementalList\\Model\\ElementList', 'DNADesign\\ElementalVirtual\\Model\\ElementVirtual') THEN "Element_Live"."TypeScale" WHEN "Element_Live"."ClassName" IN ('RS\\Elemental\\Model\\UIElementalContent') THEN "UIElementalContent_Live"."TypeScale" WHEN "Element_Live"."ClassName" IN ('RS\\Elemental\\Model\\UIElementalContent') THEN "UIElementalContent_Live"."TypeScale" ELSE NULL END AS "TypeScale", "UIElementalContent_Live"."Subtitle", "UIElementalContent_Live"."Content", "UIElementalContent_Live"."Columns", "UIElementalContent_Live"."PageID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "UIElementalContent_Live" ON "UIElementalContent_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0006s
0040: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "UIElementalContent_Buttons" ON "UIElementalContent_Buttons"."LinkID" = "Link"."ID"
WHERE ("UIElementalContent_Buttons"."UIElementalContentID" = ?)
0.0006s
0041: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "UIElementalTriptychs_Live"."Content", "UIElementalTriptychs_Live"."Mode", "UIElementalTriptychs_Live"."DisplayContentPanel", "UIElementalTriptychs_Live"."Spacing", CASE WHEN "Element_Live"."ClassName" IN ('DNADesign\\Elemental\\Models\\BaseElement', 'RS\\Elemental\\Model\\MosaicTile', 'RS\\Model\\TemplateTile', 'RS\\Model\\Tile', 'RS\\Elemental\\Model\\UIElementalBanner', 'RS\\Elemental\\Model\\UIElementalBlogPostList', 'RS\\Elemental\\Model\\UIElementalCTAGroup', 'RS\\Elemental\\Model\\UIElementalCarousel', 'RS\\Elemental\\Model\\UIElementalColumn', 'RS\\Elemental\\Model\\UIElementalCommunityStats', 'RS\\Elemental\\Model\\UIElementalContent', 'RS\\Elemental\\Model\\UIElementalContentGroup', 'RS\\Elemental\\Model\\UIElementalCrowdriff', 'RS\\Elemental\\Model\\UIElementalFeatureBlock', 'RS\\Elemental\\Model\\UIElementalFeatureMap', 'RS\\Elemental\\Model\\UIElementalFeaturedGrid', 'RS\\Elemental\\Model\\UIElementalGallery', 'RS\\Elemental\\Model\\UIElementalGrid', 'RS\\Elemental\\Model\\UIElementalLocomotiveSection', 'RS\\Elemental\\Model\\UIElementalLogoGarden', 'RS\\Elemental\\Model\\UIElementalMosaic', 'RS\\Elemental\\Model\\UIElementalPageHeader', 'RS\\Elemental\\Model\\UIElementalPartnerList', 'RS\\Elemental\\Model\\UIElementalPartnerMap', 'RS\\Elemental\\Model\\UIElementalRepeater', 'RS\\Elemental\\Model\\UIElementalSlide', 'RS\\Elemental\\Model\\UIElementalSpacer', 'RS\\Elemental\\Model\\UIElementalTimeline', 'RS\\Elemental\\Model\\UIElementalTriptych', 'DNADesign\\Elemental\\Models\\ElementContent', 'DNADesign\\ElementalList\\Model\\ElementList', 'DNADesign\\ElementalVirtual\\Model\\ElementVirtual') THEN "Element_Live"."Title" WHEN "Element_Live"."ClassName" IN ('RS\\Elemental\\Model\\UIElementalTriptych') THEN "UIElementalTriptychs_Live"."Title" ELSE NULL END AS "Title", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "UIElementalTriptychs_Live" ON "UIElementalTriptychs_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0009s
0042: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "UIElementalTriptychs_Links" ON "UIElementalTriptychs_Links"."LinkID" = "Link"."ID"
WHERE ("UIElementalTriptychs_Links"."UIElementalTriptychsID" = ?)
0.0005s
0043: SELECT DISTINCT count(DISTINCT "AspectRatios"."ID") AS "Count"
FROM "AspectRatios" INNER JOIN "Element_AspectRatios" ON "Element_AspectRatios"."AspectRatiosID" = "AspectRatios"."ID"
WHERE ("Element_AspectRatios"."ElementID" = ?)
0.0005s
0044: SELECT DISTINCT "Element_AspectRatios"."Sort", "AspectRatios"."ClassName", "AspectRatios"."LastEdited", "AspectRatios"."Created", "AspectRatios"."Scale", "AspectRatios"."Ratio", "AspectRatios"."Orientation", "AspectRatios"."ID",
CASE WHEN "AspectRatios"."ClassName" IS NOT NULL THEN "AspectRatios"."ClassName"
ELSE 'RS\\Model\\AspectRatio' END AS "RecordClassName"
FROM "AspectRatios" INNER JOIN "Element_AspectRatios" ON "Element_AspectRatios"."AspectRatiosID" = "AspectRatios"."ID"
WHERE ("Element_AspectRatios"."ElementID" = ?)
AND ("AspectRatios"."Scale" != ? OR "AspectRatios"."Scale" IS NULL)
ORDER BY "Sort" DESC
LIMIT 1
0.0006s
0045: SELECT DISTINCT "UIElementalTriptychs_Images"."SortOrder", "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"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "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" INNER JOIN "UIElementalTriptychs_Images" ON "UIElementalTriptychs_Images"."ImageID" = "File_Live"."ID"
WHERE ("UIElementalTriptychs_Images"."UIElementalTriptychsID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "SortOrder" ASC
LIMIT 1
0.0016s
0046: SELECT DISTINCT "Element_AspectRatios"."Sort", "AspectRatios"."ClassName", "AspectRatios"."LastEdited", "AspectRatios"."Created", "AspectRatios"."Scale", "AspectRatios"."Ratio", "AspectRatios"."Orientation", "AspectRatios"."ID",
CASE WHEN "AspectRatios"."ClassName" IS NOT NULL THEN "AspectRatios"."ClassName"
ELSE 'RS\\Model\\AspectRatio' END AS "RecordClassName"
FROM "AspectRatios" INNER JOIN "Element_AspectRatios" ON "Element_AspectRatios"."AspectRatiosID" = "AspectRatios"."ID"
WHERE ("Element_AspectRatios"."ElementID" = ?)
ORDER BY "Sort" ASC
0.0009s
0047: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "UIElementalTriptychs_Live"."Content", "UIElementalTriptychs_Live"."Mode", "UIElementalTriptychs_Live"."DisplayContentPanel", "UIElementalTriptychs_Live"."Spacing", CASE WHEN "Element_Live"."ClassName" IN ('DNADesign\\Elemental\\Models\\BaseElement', 'RS\\Elemental\\Model\\MosaicTile', 'RS\\Model\\TemplateTile', 'RS\\Model\\Tile', 'RS\\Elemental\\Model\\UIElementalBanner', 'RS\\Elemental\\Model\\UIElementalBlogPostList', 'RS\\Elemental\\Model\\UIElementalCTAGroup', 'RS\\Elemental\\Model\\UIElementalCarousel', 'RS\\Elemental\\Model\\UIElementalColumn', 'RS\\Elemental\\Model\\UIElementalCommunityStats', 'RS\\Elemental\\Model\\UIElementalContent', 'RS\\Elemental\\Model\\UIElementalContentGroup', 'RS\\Elemental\\Model\\UIElementalCrowdriff', 'RS\\Elemental\\Model\\UIElementalFeatureBlock', 'RS\\Elemental\\Model\\UIElementalFeatureMap', 'RS\\Elemental\\Model\\UIElementalFeaturedGrid', 'RS\\Elemental\\Model\\UIElementalGallery', 'RS\\Elemental\\Model\\UIElementalGrid', 'RS\\Elemental\\Model\\UIElementalLocomotiveSection', 'RS\\Elemental\\Model\\UIElementalLogoGarden', 'RS\\Elemental\\Model\\UIElementalMosaic', 'RS\\Elemental\\Model\\UIElementalPageHeader', 'RS\\Elemental\\Model\\UIElementalPartnerList', 'RS\\Elemental\\Model\\UIElementalPartnerMap', 'RS\\Elemental\\Model\\UIElementalRepeater', 'RS\\Elemental\\Model\\UIElementalSlide', 'RS\\Elemental\\Model\\UIElementalSpacer', 'RS\\Elemental\\Model\\UIElementalTimeline', 'RS\\Elemental\\Model\\UIElementalTriptych', 'DNADesign\\Elemental\\Models\\ElementContent', 'DNADesign\\ElementalList\\Model\\ElementList', 'DNADesign\\ElementalVirtual\\Model\\ElementVirtual') THEN "Element_Live"."Title" WHEN "Element_Live"."ClassName" IN ('RS\\Elemental\\Model\\UIElementalTriptych') THEN "UIElementalTriptychs_Live"."Title" ELSE NULL END AS "Title", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "UIElementalTriptychs_Live" ON "UIElementalTriptychs_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0009s
0048: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "UIElementalTriptychs_Links" ON "UIElementalTriptychs_Links"."LinkID" = "Link"."ID"
WHERE ("UIElementalTriptychs_Links"."UIElementalTriptychsID" = ?)
0.0006s
0049: SELECT DISTINCT count(DISTINCT "AspectRatios"."ID") AS "Count"
FROM "AspectRatios" INNER JOIN "Element_AspectRatios" ON "Element_AspectRatios"."AspectRatiosID" = "AspectRatios"."ID"
WHERE ("Element_AspectRatios"."ElementID" = ?)
0.0004s
0050: SELECT DISTINCT "Element_AspectRatios"."Sort", "AspectRatios"."ClassName", "AspectRatios"."LastEdited", "AspectRatios"."Created", "AspectRatios"."Scale", "AspectRatios"."Ratio", "AspectRatios"."Orientation", "AspectRatios"."ID",
CASE WHEN "AspectRatios"."ClassName" IS NOT NULL THEN "AspectRatios"."ClassName"
ELSE 'RS\\Model\\AspectRatio' END AS "RecordClassName"
FROM "AspectRatios" INNER JOIN "Element_AspectRatios" ON "Element_AspectRatios"."AspectRatiosID" = "AspectRatios"."ID"
WHERE ("Element_AspectRatios"."ElementID" = ?)
AND ("AspectRatios"."Scale" != ? OR "AspectRatios"."Scale" IS NULL)
ORDER BY "Sort" DESC
LIMIT 1
0.0005s
0051: SELECT DISTINCT "UIElementalTriptychs_Images"."SortOrder", "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"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "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" INNER JOIN "UIElementalTriptychs_Images" ON "UIElementalTriptychs_Images"."ImageID" = "File_Live"."ID"
WHERE ("UIElementalTriptychs_Images"."UIElementalTriptychsID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "SortOrder" ASC
LIMIT 1
0.0014s
0052: SELECT DISTINCT "Element_AspectRatios"."Sort", "AspectRatios"."ClassName", "AspectRatios"."LastEdited", "AspectRatios"."Created", "AspectRatios"."Scale", "AspectRatios"."Ratio", "AspectRatios"."Orientation", "AspectRatios"."ID",
CASE WHEN "AspectRatios"."ClassName" IS NOT NULL THEN "AspectRatios"."ClassName"
ELSE 'RS\\Model\\AspectRatio' END AS "RecordClassName"
FROM "AspectRatios" INNER JOIN "Element_AspectRatios" ON "Element_AspectRatios"."AspectRatiosID" = "AspectRatios"."ID"
WHERE ("Element_AspectRatios"."ElementID" = ?)
ORDER BY "Sort" ASC
0.0006s
0053: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "UIElementalTriptychs_Live"."Content", "UIElementalTriptychs_Live"."Mode", "UIElementalTriptychs_Live"."DisplayContentPanel", "UIElementalTriptychs_Live"."Spacing", CASE WHEN "Element_Live"."ClassName" IN ('DNADesign\\Elemental\\Models\\BaseElement', 'RS\\Elemental\\Model\\MosaicTile', 'RS\\Model\\TemplateTile', 'RS\\Model\\Tile', 'RS\\Elemental\\Model\\UIElementalBanner', 'RS\\Elemental\\Model\\UIElementalBlogPostList', 'RS\\Elemental\\Model\\UIElementalCTAGroup', 'RS\\Elemental\\Model\\UIElementalCarousel', 'RS\\Elemental\\Model\\UIElementalColumn', 'RS\\Elemental\\Model\\UIElementalCommunityStats', 'RS\\Elemental\\Model\\UIElementalContent', 'RS\\Elemental\\Model\\UIElementalContentGroup', 'RS\\Elemental\\Model\\UIElementalCrowdriff', 'RS\\Elemental\\Model\\UIElementalFeatureBlock', 'RS\\Elemental\\Model\\UIElementalFeatureMap', 'RS\\Elemental\\Model\\UIElementalFeaturedGrid', 'RS\\Elemental\\Model\\UIElementalGallery', 'RS\\Elemental\\Model\\UIElementalGrid', 'RS\\Elemental\\Model\\UIElementalLocomotiveSection', 'RS\\Elemental\\Model\\UIElementalLogoGarden', 'RS\\Elemental\\Model\\UIElementalMosaic', 'RS\\Elemental\\Model\\UIElementalPageHeader', 'RS\\Elemental\\Model\\UIElementalPartnerList', 'RS\\Elemental\\Model\\UIElementalPartnerMap', 'RS\\Elemental\\Model\\UIElementalRepeater', 'RS\\Elemental\\Model\\UIElementalSlide', 'RS\\Elemental\\Model\\UIElementalSpacer', 'RS\\Elemental\\Model\\UIElementalTimeline', 'RS\\Elemental\\Model\\UIElementalTriptych', 'DNADesign\\Elemental\\Models\\ElementContent', 'DNADesign\\ElementalList\\Model\\ElementList', 'DNADesign\\ElementalVirtual\\Model\\ElementVirtual') THEN "Element_Live"."Title" WHEN "Element_Live"."ClassName" IN ('RS\\Elemental\\Model\\UIElementalTriptych') THEN "UIElementalTriptychs_Live"."Title" ELSE NULL END AS "Title", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "UIElementalTriptychs_Live" ON "UIElementalTriptychs_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0012s
0054: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "UIElementalTriptychs_Links" ON "UIElementalTriptychs_Links"."LinkID" = "Link"."ID"
WHERE ("UIElementalTriptychs_Links"."UIElementalTriptychsID" = ?)
0.0006s
0055: SELECT DISTINCT count(DISTINCT "AspectRatios"."ID") AS "Count"
FROM "AspectRatios" INNER JOIN "Element_AspectRatios" ON "Element_AspectRatios"."AspectRatiosID" = "AspectRatios"."ID"
WHERE ("Element_AspectRatios"."ElementID" = ?)
0.0004s
0056: SELECT DISTINCT "Element_AspectRatios"."Sort", "AspectRatios"."ClassName", "AspectRatios"."LastEdited", "AspectRatios"."Created", "AspectRatios"."Scale", "AspectRatios"."Ratio", "AspectRatios"."Orientation", "AspectRatios"."ID",
CASE WHEN "AspectRatios"."ClassName" IS NOT NULL THEN "AspectRatios"."ClassName"
ELSE 'RS\\Model\\AspectRatio' END AS "RecordClassName"
FROM "AspectRatios" INNER JOIN "Element_AspectRatios" ON "Element_AspectRatios"."AspectRatiosID" = "AspectRatios"."ID"
WHERE ("Element_AspectRatios"."ElementID" = ?)
AND ("AspectRatios"."Scale" != ? OR "AspectRatios"."Scale" IS NULL)
ORDER BY "Sort" DESC
LIMIT 1
0.0005s
0057: SELECT DISTINCT "UIElementalTriptychs_Images"."SortOrder", "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"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "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" INNER JOIN "UIElementalTriptychs_Images" ON "UIElementalTriptychs_Images"."ImageID" = "File_Live"."ID"
WHERE ("UIElementalTriptychs_Images"."UIElementalTriptychsID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "SortOrder" ASC
LIMIT 1
0.0012s
0058: SELECT DISTINCT "Element_AspectRatios"."Sort", "AspectRatios"."ClassName", "AspectRatios"."LastEdited", "AspectRatios"."Created", "AspectRatios"."Scale", "AspectRatios"."Ratio", "AspectRatios"."Orientation", "AspectRatios"."ID",
CASE WHEN "AspectRatios"."ClassName" IS NOT NULL THEN "AspectRatios"."ClassName"
ELSE 'RS\\Model\\AspectRatio' END AS "RecordClassName"
FROM "AspectRatios" INNER JOIN "Element_AspectRatios" ON "Element_AspectRatios"."AspectRatiosID" = "AspectRatios"."ID"
WHERE ("Element_AspectRatios"."ElementID" = ?)
ORDER BY "Sort" ASC
0.0004s
0059: SELECT DISTINCT count(DISTINCT "ElementalStyleProperties"."ID") AS "Count"
FROM "ElementalStyleProperties"
WHERE ("ElementalStyleProperties"."StyleOwnerClass" IN ('RS\\Elemental\\Model\\UIElementalContent'))
AND ("ElementalStyleProperties"."StyleOwnerID" = ?)
0.0006s
0060: SELECT DISTINCT count(DISTINCT "ElementalStyleProperties"."ID") AS "Count"
FROM "ElementalStyleProperties"
WHERE ("ElementalStyleProperties"."StyleOwnerClass" IN ('RS\\Elemental\\Model\\UIElementalContent'))
AND ("ElementalStyleProperties"."StyleOwnerID" = ?)
0.0005s
0061: SELECT DISTINCT count(DISTINCT "AspectRatios"."ID") AS "Count"
FROM "AspectRatios" INNER JOIN "Element_AspectRatios" ON "Element_AspectRatios"."AspectRatiosID" = "AspectRatios"."ID"
WHERE ("Element_AspectRatios"."ElementID" = ?)
0.0003s
0062: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE WHEN "Element_Live"."ClassName" IN ('DNADesign\\Elemental\\Models\\BaseElement', 'RS\\Elemental\\Model\\MosaicTile', 'RS\\Model\\TemplateTile', 'RS\\Model\\Tile', 'RS\\Elemental\\Model\\UIElementalBanner', 'RS\\Elemental\\Model\\UIElementalBlogPostList', 'RS\\Elemental\\Model\\UIElementalCTAGroup', 'RS\\Elemental\\Model\\UIElementalCarousel', 'RS\\Elemental\\Model\\UIElementalColumn', 'RS\\Elemental\\Model\\UIElementalCommunityStats', 'RS\\Elemental\\Model\\UIElementalContent', 'RS\\Elemental\\Model\\UIElementalContentGroup', 'RS\\Elemental\\Model\\UIElementalCrowdriff', 'RS\\Elemental\\Model\\UIElementalFeatureBlock', 'RS\\Elemental\\Model\\UIElementalFeatureMap', 'RS\\Elemental\\Model\\UIElementalFeaturedGrid', 'RS\\Elemental\\Model\\UIElementalGallery', 'RS\\Elemental\\Model\\UIElementalGrid', 'RS\\Elemental\\Model\\UIElementalLocomotiveSection', 'RS\\Elemental\\Model\\UIElementalLogoGarden', 'RS\\Elemental\\Model\\UIElementalMosaic', 'RS\\Elemental\\Model\\UIElementalPageHeader', 'RS\\Elemental\\Model\\UIElementalPartnerList', 'RS\\Elemental\\Model\\UIElementalPartnerMap', 'RS\\Elemental\\Model\\UIElementalRepeater', 'RS\\Elemental\\Model\\UIElementalSlide', 'RS\\Elemental\\Model\\UIElementalSpacer', 'RS\\Elemental\\Model\\UIElementalTimeline', 'RS\\Elemental\\Model\\UIElementalTriptych', 'DNADesign\\Elemental\\Models\\ElementContent', 'DNADesign\\ElementalList\\Model\\ElementList', 'DNADesign\\ElementalVirtual\\Model\\ElementVirtual') THEN "Element_Live"."TypeScale" WHEN "Element_Live"."ClassName" IN ('RS\\Elemental\\Model\\UIElementalContent') THEN "UIElementalContent_Live"."TypeScale" WHEN "Element_Live"."ClassName" IN ('RS\\Elemental\\Model\\UIElementalContent') THEN "UIElementalContent_Live"."TypeScale" ELSE NULL END AS "TypeScale", "UIElementalContent_Live"."Subtitle", "UIElementalContent_Live"."Content", "UIElementalContent_Live"."Columns", "UIElementalContent_Live"."PageID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "UIElementalContent_Live" ON "UIElementalContent_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0006s
0063: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "UIElementalContent_Buttons" ON "UIElementalContent_Buttons"."LinkID" = "Link"."ID"
WHERE ("UIElementalContent_Buttons"."UIElementalContentID" = ?)
0.0006s
0064: SELECT DISTINCT count(DISTINCT "ElementalStyleProperties"."ID") AS "Count"
FROM "ElementalStyleProperties"
WHERE ("ElementalStyleProperties"."StyleOwnerClass" IN ('RS\\Elemental\\Model\\UIElementalGallery'))
AND ("ElementalStyleProperties"."StyleOwnerID" = ?)
0.0007s
0065: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "UIElementalGalleries_Live"."SlidesToShow", "UIElementalGalleries_Live"."SlidesToScroll", "UIElementalGalleries_Live"."ScrollLock", "UIElementalGalleries_Live"."ScrollLockDelay", "UIElementalGalleries_Live"."ResizeLock", "UIElementalGalleries_Live"."ScrollPropagate", "UIElementalGalleries_Live"."EventPropagate", "UIElementalGalleries_Live"."AutoplayDelay", "UIElementalGalleries_Live"."Autoplay", "UIElementalGalleries_Live"."Loop", "UIElementalGalleries_Live"."Draggable", "UIElementalGalleries_Live"."DragVelocity", "UIElementalGalleries_Live"."ItemWidth", "UIElementalGalleries_Live"."ExactWidth", "UIElementalGalleries_Live"."Duration", "UIElementalGalleries_Live"."Dots", "UIElementalGalleries_Live"."ArrowsPrev", "UIElementalGalleries_Live"."ArrowsNext", "UIElementalGalleries_Live"."Controls", "UIElementalGalleries_Live"."Effect", "UIElementalGalleries_Live"."Content", "UIElementalGalleries_Live"."Layout", "UIElementalGalleries_Live"."LayoutOption", "UIElementalGalleries_Live"."Fill", "UIElementalGalleries_Live"."Interactive", "UIElementalGalleries_Live"."UseSelectedGallery", "UIElementalGalleries_Live"."GalleryID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "UIElementalGalleries_Live" ON "UIElementalGalleries_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.001s
0066: SELECT DISTINCT "Galleries"."ClassName", "Galleries"."LastEdited", "Galleries"."Created", "Galleries"."Title", "Galleries"."Content", "Galleries"."Key", "Galleries"."Sort", "Galleries"."ThumbnailID", "Galleries"."PageID", "Galleries"."ID",
CASE WHEN "Galleries"."ClassName" IS NOT NULL THEN "Galleries"."ClassName"
ELSE 'RS\\Model\\Gallery' END AS "RecordClassName"
FROM "Galleries"
WHERE ("Galleries"."ID" = ?)
LIMIT 1
0.0005s
0067: SELECT DISTINCT count(DISTINCT "AspectRatios"."ID") AS "Count"
FROM "AspectRatios" INNER JOIN "Element_AspectRatios" ON "Element_AspectRatios"."AspectRatiosID" = "AspectRatios"."ID"
WHERE ("Element_AspectRatios"."ElementID" = ?)
0.0004s
0068: SELECT DISTINCT "Element_AspectRatios"."Sort", "AspectRatios"."ClassName", "AspectRatios"."LastEdited", "AspectRatios"."Created", "AspectRatios"."Scale", "AspectRatios"."Ratio", "AspectRatios"."Orientation", "AspectRatios"."ID",
CASE WHEN "AspectRatios"."ClassName" IS NOT NULL THEN "AspectRatios"."ClassName"
ELSE 'RS\\Model\\AspectRatio' END AS "RecordClassName"
FROM "AspectRatios" INNER JOIN "Element_AspectRatios" ON "Element_AspectRatios"."AspectRatiosID" = "AspectRatios"."ID"
WHERE ("Element_AspectRatios"."ElementID" = ?)
AND ("AspectRatios"."Scale" != ? OR "AspectRatios"."Scale" IS NULL)
ORDER BY "Sort" DESC
LIMIT 1
0.0005s
0069: SELECT DISTINCT "Galleries_Images"."SortOrder", "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"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "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" INNER JOIN "Galleries_Images" ON "Galleries_Images"."ImageID" = "File_Live"."ID"
WHERE ("Galleries_Images"."GalleriesID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "SortOrder" ASC
0.0015s
0070: SELECT DISTINCT "Element_AspectRatios"."Sort", "AspectRatios"."ClassName", "AspectRatios"."LastEdited", "AspectRatios"."Created", "AspectRatios"."Scale", "AspectRatios"."Ratio", "AspectRatios"."Orientation", "AspectRatios"."ID",
CASE WHEN "AspectRatios"."ClassName" IS NOT NULL THEN "AspectRatios"."ClassName"
ELSE 'RS\\Model\\AspectRatio' END AS "RecordClassName"
FROM "AspectRatios" INNER JOIN "Element_AspectRatios" ON "Element_AspectRatios"."AspectRatiosID" = "AspectRatios"."ID"
WHERE ("Element_AspectRatios"."ElementID" = ?)
ORDER BY "Sort" ASC
0.0008s
0071: SELECT DISTINCT "Element_AspectRatios"."Sort", "AspectRatios"."ClassName", "AspectRatios"."LastEdited", "AspectRatios"."Created", "AspectRatios"."Scale", "AspectRatios"."Ratio", "AspectRatios"."Orientation", "AspectRatios"."ID",
CASE WHEN "AspectRatios"."ClassName" IS NOT NULL THEN "AspectRatios"."ClassName"
ELSE 'RS\\Model\\AspectRatio' END AS "RecordClassName"
FROM "AspectRatios" INNER JOIN "Element_AspectRatios" ON "Element_AspectRatios"."AspectRatiosID" = "AspectRatios"."ID"
WHERE ("Element_AspectRatios"."ElementID" = ?)
ORDER BY "Sort" ASC
0.0007s
0072: SELECT DISTINCT "Element_AspectRatios"."Sort", "AspectRatios"."ClassName", "AspectRatios"."LastEdited", "AspectRatios"."Created", "AspectRatios"."Scale", "AspectRatios"."Ratio", "AspectRatios"."Orientation", "AspectRatios"."ID",
CASE WHEN "AspectRatios"."ClassName" IS NOT NULL THEN "AspectRatios"."ClassName"
ELSE 'RS\\Model\\AspectRatio' END AS "RecordClassName"
FROM "AspectRatios" INNER JOIN "Element_AspectRatios" ON "Element_AspectRatios"."AspectRatiosID" = "AspectRatios"."ID"
WHERE ("Element_AspectRatios"."ElementID" = ?)
ORDER BY "Sort" ASC
0.0006s
0073: SELECT DISTINCT "Element_AspectRatios"."Sort", "AspectRatios"."ClassName", "AspectRatios"."LastEdited", "AspectRatios"."Created", "AspectRatios"."Scale", "AspectRatios"."Ratio", "AspectRatios"."Orientation", "AspectRatios"."ID",
CASE WHEN "AspectRatios"."ClassName" IS NOT NULL THEN "AspectRatios"."ClassName"
ELSE 'RS\\Model\\AspectRatio' END AS "RecordClassName"
FROM "AspectRatios" INNER JOIN "Element_AspectRatios" ON "Element_AspectRatios"."AspectRatiosID" = "AspectRatios"."ID"
WHERE ("Element_AspectRatios"."ElementID" = ?)
ORDER BY "Sort" ASC
0.0005s
0074: SELECT DISTINCT "Element_AspectRatios"."Sort", "AspectRatios"."ClassName", "AspectRatios"."LastEdited", "AspectRatios"."Created", "AspectRatios"."Scale", "AspectRatios"."Ratio", "AspectRatios"."Orientation", "AspectRatios"."ID",
CASE WHEN "AspectRatios"."ClassName" IS NOT NULL THEN "AspectRatios"."ClassName"
ELSE 'RS\\Model\\AspectRatio' END AS "RecordClassName"
FROM "AspectRatios" INNER JOIN "Element_AspectRatios" ON "Element_AspectRatios"."AspectRatiosID" = "AspectRatios"."ID"
WHERE ("Element_AspectRatios"."ElementID" = ?)
ORDER BY "Sort" ASC
0.0006s
0075: SELECT DISTINCT "Element_AspectRatios"."Sort", "AspectRatios"."ClassName", "AspectRatios"."LastEdited", "AspectRatios"."Created", "AspectRatios"."Scale", "AspectRatios"."Ratio", "AspectRatios"."Orientation", "AspectRatios"."ID",
CASE WHEN "AspectRatios"."ClassName" IS NOT NULL THEN "AspectRatios"."ClassName"
ELSE 'RS\\Model\\AspectRatio' END AS "RecordClassName"
FROM "AspectRatios" INNER JOIN "Element_AspectRatios" ON "Element_AspectRatios"."AspectRatiosID" = "AspectRatios"."ID"
WHERE ("Element_AspectRatios"."ElementID" = ?)
ORDER BY "Sort" ASC
0.0008s
0076: SELECT DISTINCT "Element_AspectRatios"."Sort", "AspectRatios"."ClassName", "AspectRatios"."LastEdited", "AspectRatios"."Created", "AspectRatios"."Scale", "AspectRatios"."Ratio", "AspectRatios"."Orientation", "AspectRatios"."ID",
CASE WHEN "AspectRatios"."ClassName" IS NOT NULL THEN "AspectRatios"."ClassName"
ELSE 'RS\\Model\\AspectRatio' END AS "RecordClassName"
FROM "AspectRatios" INNER JOIN "Element_AspectRatios" ON "Element_AspectRatios"."AspectRatiosID" = "AspectRatios"."ID"
WHERE ("Element_AspectRatios"."ElementID" = ?)
ORDER BY "Sort" ASC
0.0007s
0077: SELECT DISTINCT "Element_AspectRatios"."Sort", "AspectRatios"."ClassName", "AspectRatios"."LastEdited", "AspectRatios"."Created", "AspectRatios"."Scale", "AspectRatios"."Ratio", "AspectRatios"."Orientation", "AspectRatios"."ID",
CASE WHEN "AspectRatios"."ClassName" IS NOT NULL THEN "AspectRatios"."ClassName"
ELSE 'RS\\Model\\AspectRatio' END AS "RecordClassName"
FROM "AspectRatios" INNER JOIN "Element_AspectRatios" ON "Element_AspectRatios"."AspectRatiosID" = "AspectRatios"."ID"
WHERE ("Element_AspectRatios"."ElementID" = ?)
ORDER BY "Sort" ASC
0.0017s
0078: SELECT DISTINCT count(DISTINCT "ElementalStyleProperties"."ID") AS "Count"
FROM "ElementalStyleProperties"
WHERE ("ElementalStyleProperties"."StyleOwnerClass" IN ('RS\\Elemental\\Model\\UIElementalContent'))
AND ("ElementalStyleProperties"."StyleOwnerID" = ?)
0.0007s
0079: SELECT DISTINCT count(DISTINCT "ElementalStyleProperties"."ID") AS "Count"
FROM "ElementalStyleProperties"
WHERE ("ElementalStyleProperties"."StyleOwnerClass" IN ('RS\\Elemental\\Model\\UIElementalContent'))
AND ("ElementalStyleProperties"."StyleOwnerID" = ?)
0.0003s
0080: SELECT DISTINCT count(DISTINCT "AspectRatios"."ID") AS "Count"
FROM "AspectRatios" INNER JOIN "Element_AspectRatios" ON "Element_AspectRatios"."AspectRatiosID" = "AspectRatios"."ID"
WHERE ("Element_AspectRatios"."ElementID" = ?)
0.0005s
0081: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE WHEN "Element_Live"."ClassName" IN ('DNADesign\\Elemental\\Models\\BaseElement', 'RS\\Elemental\\Model\\MosaicTile', 'RS\\Model\\TemplateTile', 'RS\\Model\\Tile', 'RS\\Elemental\\Model\\UIElementalBanner', 'RS\\Elemental\\Model\\UIElementalBlogPostList', 'RS\\Elemental\\Model\\UIElementalCTAGroup', 'RS\\Elemental\\Model\\UIElementalCarousel', 'RS\\Elemental\\Model\\UIElementalColumn', 'RS\\Elemental\\Model\\UIElementalCommunityStats', 'RS\\Elemental\\Model\\UIElementalContent', 'RS\\Elemental\\Model\\UIElementalContentGroup', 'RS\\Elemental\\Model\\UIElementalCrowdriff', 'RS\\Elemental\\Model\\UIElementalFeatureBlock', 'RS\\Elemental\\Model\\UIElementalFeatureMap', 'RS\\Elemental\\Model\\UIElementalFeaturedGrid', 'RS\\Elemental\\Model\\UIElementalGallery', 'RS\\Elemental\\Model\\UIElementalGrid', 'RS\\Elemental\\Model\\UIElementalLocomotiveSection', 'RS\\Elemental\\Model\\UIElementalLogoGarden', 'RS\\Elemental\\Model\\UIElementalMosaic', 'RS\\Elemental\\Model\\UIElementalPageHeader', 'RS\\Elemental\\Model\\UIElementalPartnerList', 'RS\\Elemental\\Model\\UIElementalPartnerMap', 'RS\\Elemental\\Model\\UIElementalRepeater', 'RS\\Elemental\\Model\\UIElementalSlide', 'RS\\Elemental\\Model\\UIElementalSpacer', 'RS\\Elemental\\Model\\UIElementalTimeline', 'RS\\Elemental\\Model\\UIElementalTriptych', 'DNADesign\\Elemental\\Models\\ElementContent', 'DNADesign\\ElementalList\\Model\\ElementList', 'DNADesign\\ElementalVirtual\\Model\\ElementVirtual') THEN "Element_Live"."TypeScale" WHEN "Element_Live"."ClassName" IN ('RS\\Elemental\\Model\\UIElementalContent') THEN "UIElementalContent_Live"."TypeScale" WHEN "Element_Live"."ClassName" IN ('RS\\Elemental\\Model\\UIElementalContent') THEN "UIElementalContent_Live"."TypeScale" ELSE NULL END AS "TypeScale", "UIElementalContent_Live"."Subtitle", "UIElementalContent_Live"."Content", "UIElementalContent_Live"."Columns", "UIElementalContent_Live"."PageID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "UIElementalContent_Live" ON "UIElementalContent_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0012s
0082: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "UIElementalContent_Buttons" ON "UIElementalContent_Buttons"."LinkID" = "Link"."ID"
WHERE ("UIElementalContent_Buttons"."UIElementalContentID" = ?)
0.0005s
0083: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "UIElementalTriptychs_Live"."Content", "UIElementalTriptychs_Live"."Mode", "UIElementalTriptychs_Live"."DisplayContentPanel", "UIElementalTriptychs_Live"."Spacing", CASE WHEN "Element_Live"."ClassName" IN ('DNADesign\\Elemental\\Models\\BaseElement', 'RS\\Elemental\\Model\\MosaicTile', 'RS\\Model\\TemplateTile', 'RS\\Model\\Tile', 'RS\\Elemental\\Model\\UIElementalBanner', 'RS\\Elemental\\Model\\UIElementalBlogPostList', 'RS\\Elemental\\Model\\UIElementalCTAGroup', 'RS\\Elemental\\Model\\UIElementalCarousel', 'RS\\Elemental\\Model\\UIElementalColumn', 'RS\\Elemental\\Model\\UIElementalCommunityStats', 'RS\\Elemental\\Model\\UIElementalContent', 'RS\\Elemental\\Model\\UIElementalContentGroup', 'RS\\Elemental\\Model\\UIElementalCrowdriff', 'RS\\Elemental\\Model\\UIElementalFeatureBlock', 'RS\\Elemental\\Model\\UIElementalFeatureMap', 'RS\\Elemental\\Model\\UIElementalFeaturedGrid', 'RS\\Elemental\\Model\\UIElementalGallery', 'RS\\Elemental\\Model\\UIElementalGrid', 'RS\\Elemental\\Model\\UIElementalLocomotiveSection', 'RS\\Elemental\\Model\\UIElementalLogoGarden', 'RS\\Elemental\\Model\\UIElementalMosaic', 'RS\\Elemental\\Model\\UIElementalPageHeader', 'RS\\Elemental\\Model\\UIElementalPartnerList', 'RS\\Elemental\\Model\\UIElementalPartnerMap', 'RS\\Elemental\\Model\\UIElementalRepeater', 'RS\\Elemental\\Model\\UIElementalSlide', 'RS\\Elemental\\Model\\UIElementalSpacer', 'RS\\Elemental\\Model\\UIElementalTimeline', 'RS\\Elemental\\Model\\UIElementalTriptych', 'DNADesign\\Elemental\\Models\\ElementContent', 'DNADesign\\ElementalList\\Model\\ElementList', 'DNADesign\\ElementalVirtual\\Model\\ElementVirtual') THEN "Element_Live"."Title" WHEN "Element_Live"."ClassName" IN ('RS\\Elemental\\Model\\UIElementalTriptych') THEN "UIElementalTriptychs_Live"."Title" ELSE NULL END AS "Title", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "UIElementalTriptychs_Live" ON "UIElementalTriptychs_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0009s
0084: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "UIElementalTriptychs_Links" ON "UIElementalTriptychs_Links"."LinkID" = "Link"."ID"
WHERE ("UIElementalTriptychs_Links"."UIElementalTriptychsID" = ?)
0.0013s
0085: SELECT DISTINCT count(DISTINCT "AspectRatios"."ID") AS "Count"
FROM "AspectRatios" INNER JOIN "Element_AspectRatios" ON "Element_AspectRatios"."AspectRatiosID" = "AspectRatios"."ID"
WHERE ("Element_AspectRatios"."ElementID" = ?)
0.0003s
0086: SELECT DISTINCT "Element_AspectRatios"."Sort", "AspectRatios"."ClassName", "AspectRatios"."LastEdited", "AspectRatios"."Created", "AspectRatios"."Scale", "AspectRatios"."Ratio", "AspectRatios"."Orientation", "AspectRatios"."ID",
CASE WHEN "AspectRatios"."ClassName" IS NOT NULL THEN "AspectRatios"."ClassName"
ELSE 'RS\\Model\\AspectRatio' END AS "RecordClassName"
FROM "AspectRatios" INNER JOIN "Element_AspectRatios" ON "Element_AspectRatios"."AspectRatiosID" = "AspectRatios"."ID"
WHERE ("Element_AspectRatios"."ElementID" = ?)
AND ("AspectRatios"."Scale" != ? OR "AspectRatios"."Scale" IS NULL)
ORDER BY "Sort" DESC
LIMIT 1
0.0004s
0087: SELECT DISTINCT "UIElementalTriptychs_Images"."SortOrder", "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"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "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" INNER JOIN "UIElementalTriptychs_Images" ON "UIElementalTriptychs_Images"."ImageID" = "File_Live"."ID"
WHERE ("UIElementalTriptychs_Images"."UIElementalTriptychsID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "SortOrder" ASC
LIMIT 1
0.0016s
0088: SELECT DISTINCT "Element_AspectRatios"."Sort", "AspectRatios"."ClassName", "AspectRatios"."LastEdited", "AspectRatios"."Created", "AspectRatios"."Scale", "AspectRatios"."Ratio", "AspectRatios"."Orientation", "AspectRatios"."ID",
CASE WHEN "AspectRatios"."ClassName" IS NOT NULL THEN "AspectRatios"."ClassName"
ELSE 'RS\\Model\\AspectRatio' END AS "RecordClassName"
FROM "AspectRatios" INNER JOIN "Element_AspectRatios" ON "Element_AspectRatios"."AspectRatiosID" = "AspectRatios"."ID"
WHERE ("Element_AspectRatios"."ElementID" = ?)
ORDER BY "Sort" ASC
0.0008s
0089: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "UIElementalTriptychs_Live"."Content", "UIElementalTriptychs_Live"."Mode", "UIElementalTriptychs_Live"."DisplayContentPanel", "UIElementalTriptychs_Live"."Spacing", CASE WHEN "Element_Live"."ClassName" IN ('DNADesign\\Elemental\\Models\\BaseElement', 'RS\\Elemental\\Model\\MosaicTile', 'RS\\Model\\TemplateTile', 'RS\\Model\\Tile', 'RS\\Elemental\\Model\\UIElementalBanner', 'RS\\Elemental\\Model\\UIElementalBlogPostList', 'RS\\Elemental\\Model\\UIElementalCTAGroup', 'RS\\Elemental\\Model\\UIElementalCarousel', 'RS\\Elemental\\Model\\UIElementalColumn', 'RS\\Elemental\\Model\\UIElementalCommunityStats', 'RS\\Elemental\\Model\\UIElementalContent', 'RS\\Elemental\\Model\\UIElementalContentGroup', 'RS\\Elemental\\Model\\UIElementalCrowdriff', 'RS\\Elemental\\Model\\UIElementalFeatureBlock', 'RS\\Elemental\\Model\\UIElementalFeatureMap', 'RS\\Elemental\\Model\\UIElementalFeaturedGrid', 'RS\\Elemental\\Model\\UIElementalGallery', 'RS\\Elemental\\Model\\UIElementalGrid', 'RS\\Elemental\\Model\\UIElementalLocomotiveSection', 'RS\\Elemental\\Model\\UIElementalLogoGarden', 'RS\\Elemental\\Model\\UIElementalMosaic', 'RS\\Elemental\\Model\\UIElementalPageHeader', 'RS\\Elemental\\Model\\UIElementalPartnerList', 'RS\\Elemental\\Model\\UIElementalPartnerMap', 'RS\\Elemental\\Model\\UIElementalRepeater', 'RS\\Elemental\\Model\\UIElementalSlide', 'RS\\Elemental\\Model\\UIElementalSpacer', 'RS\\Elemental\\Model\\UIElementalTimeline', 'RS\\Elemental\\Model\\UIElementalTriptych', 'DNADesign\\Elemental\\Models\\ElementContent', 'DNADesign\\ElementalList\\Model\\ElementList', 'DNADesign\\ElementalVirtual\\Model\\ElementVirtual') THEN "Element_Live"."Title" WHEN "Element_Live"."ClassName" IN ('RS\\Elemental\\Model\\UIElementalTriptych') THEN "UIElementalTriptychs_Live"."Title" ELSE NULL END AS "Title", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "UIElementalTriptychs_Live" ON "UIElementalTriptychs_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0006s
0090: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "UIElementalTriptychs_Links" ON "UIElementalTriptychs_Links"."LinkID" = "Link"."ID"
WHERE ("UIElementalTriptychs_Links"."UIElementalTriptychsID" = ?)
0.0004s
0091: SELECT DISTINCT count(DISTINCT "AspectRatios"."ID") AS "Count"
FROM "AspectRatios" INNER JOIN "Element_AspectRatios" ON "Element_AspectRatios"."AspectRatiosID" = "AspectRatios"."ID"
WHERE ("Element_AspectRatios"."ElementID" = ?)
0.0004s
0092: SELECT DISTINCT "Element_AspectRatios"."Sort", "AspectRatios"."ClassName", "AspectRatios"."LastEdited", "AspectRatios"."Created", "AspectRatios"."Scale", "AspectRatios"."Ratio", "AspectRatios"."Orientation", "AspectRatios"."ID",
CASE WHEN "AspectRatios"."ClassName" IS NOT NULL THEN "AspectRatios"."ClassName"
ELSE 'RS\\Model\\AspectRatio' END AS "RecordClassName"
FROM "AspectRatios" INNER JOIN "Element_AspectRatios" ON "Element_AspectRatios"."AspectRatiosID" = "AspectRatios"."ID"
WHERE ("Element_AspectRatios"."ElementID" = ?)
AND ("AspectRatios"."Scale" != ? OR "AspectRatios"."Scale" IS NULL)
ORDER BY "Sort" DESC
LIMIT 1
0.0004s
0093: SELECT DISTINCT "UIElementalTriptychs_Images"."SortOrder", "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"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "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" INNER JOIN "UIElementalTriptychs_Images" ON "UIElementalTriptychs_Images"."ImageID" = "File_Live"."ID"
WHERE ("UIElementalTriptychs_Images"."UIElementalTriptychsID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "SortOrder" ASC
LIMIT 1
0.0018s
0094: SELECT DISTINCT "Element_AspectRatios"."Sort", "AspectRatios"."ClassName", "AspectRatios"."LastEdited", "AspectRatios"."Created", "AspectRatios"."Scale", "AspectRatios"."Ratio", "AspectRatios"."Orientation", "AspectRatios"."ID",
CASE WHEN "AspectRatios"."ClassName" IS NOT NULL THEN "AspectRatios"."ClassName"
ELSE 'RS\\Model\\AspectRatio' END AS "RecordClassName"
FROM "AspectRatios" INNER JOIN "Element_AspectRatios" ON "Element_AspectRatios"."AspectRatiosID" = "AspectRatios"."ID"
WHERE ("Element_AspectRatios"."ElementID" = ?)
ORDER BY "Sort" ASC
0.0009s
0095: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "UIElementalTriptychs_Live"."Content", "UIElementalTriptychs_Live"."Mode", "UIElementalTriptychs_Live"."DisplayContentPanel", "UIElementalTriptychs_Live"."Spacing", CASE WHEN "Element_Live"."ClassName" IN ('DNADesign\\Elemental\\Models\\BaseElement', 'RS\\Elemental\\Model\\MosaicTile', 'RS\\Model\\TemplateTile', 'RS\\Model\\Tile', 'RS\\Elemental\\Model\\UIElementalBanner', 'RS\\Elemental\\Model\\UIElementalBlogPostList', 'RS\\Elemental\\Model\\UIElementalCTAGroup', 'RS\\Elemental\\Model\\UIElementalCarousel', 'RS\\Elemental\\Model\\UIElementalColumn', 'RS\\Elemental\\Model\\UIElementalCommunityStats', 'RS\\Elemental\\Model\\UIElementalContent', 'RS\\Elemental\\Model\\UIElementalContentGroup', 'RS\\Elemental\\Model\\UIElementalCrowdriff', 'RS\\Elemental\\Model\\UIElementalFeatureBlock', 'RS\\Elemental\\Model\\UIElementalFeatureMap', 'RS\\Elemental\\Model\\UIElementalFeaturedGrid', 'RS\\Elemental\\Model\\UIElementalGallery', 'RS\\Elemental\\Model\\UIElementalGrid', 'RS\\Elemental\\Model\\UIElementalLocomotiveSection', 'RS\\Elemental\\Model\\UIElementalLogoGarden', 'RS\\Elemental\\Model\\UIElementalMosaic', 'RS\\Elemental\\Model\\UIElementalPageHeader', 'RS\\Elemental\\Model\\UIElementalPartnerList', 'RS\\Elemental\\Model\\UIElementalPartnerMap', 'RS\\Elemental\\Model\\UIElementalRepeater', 'RS\\Elemental\\Model\\UIElementalSlide', 'RS\\Elemental\\Model\\UIElementalSpacer', 'RS\\Elemental\\Model\\UIElementalTimeline', 'RS\\Elemental\\Model\\UIElementalTriptych', 'DNADesign\\Elemental\\Models\\ElementContent', 'DNADesign\\ElementalList\\Model\\ElementList', 'DNADesign\\ElementalVirtual\\Model\\ElementVirtual') THEN "Element_Live"."Title" WHEN "Element_Live"."ClassName" IN ('RS\\Elemental\\Model\\UIElementalTriptych') THEN "UIElementalTriptychs_Live"."Title" ELSE NULL END AS "Title", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "UIElementalTriptychs_Live" ON "UIElementalTriptychs_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0008s
0096: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "UIElementalTriptychs_Links" ON "UIElementalTriptychs_Links"."LinkID" = "Link"."ID"
WHERE ("UIElementalTriptychs_Links"."UIElementalTriptychsID" = ?)
0.0005s
0097: SELECT DISTINCT count(DISTINCT "AspectRatios"."ID") AS "Count"
FROM "AspectRatios" INNER JOIN "Element_AspectRatios" ON "Element_AspectRatios"."AspectRatiosID" = "AspectRatios"."ID"
WHERE ("Element_AspectRatios"."ElementID" = ?)
0.0004s
0098: SELECT DISTINCT "Element_AspectRatios"."Sort", "AspectRatios"."ClassName", "AspectRatios"."LastEdited", "AspectRatios"."Created", "AspectRatios"."Scale", "AspectRatios"."Ratio", "AspectRatios"."Orientation", "AspectRatios"."ID",
CASE WHEN "AspectRatios"."ClassName" IS NOT NULL THEN "AspectRatios"."ClassName"
ELSE 'RS\\Model\\AspectRatio' END AS "RecordClassName"
FROM "AspectRatios" INNER JOIN "Element_AspectRatios" ON "Element_AspectRatios"."AspectRatiosID" = "AspectRatios"."ID"
WHERE ("Element_AspectRatios"."ElementID" = ?)
AND ("AspectRatios"."Scale" != ? OR "AspectRatios"."Scale" IS NULL)
ORDER BY "Sort" DESC
LIMIT 1
0.0005s
0099: SELECT DISTINCT "UIElementalTriptychs_Images"."SortOrder", "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"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "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" INNER JOIN "UIElementalTriptychs_Images" ON "UIElementalTriptychs_Images"."ImageID" = "File_Live"."ID"
WHERE ("UIElementalTriptychs_Images"."UIElementalTriptychsID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "SortOrder" ASC
LIMIT 1
0.0013s
0100: SELECT DISTINCT "Element_AspectRatios"."Sort", "AspectRatios"."ClassName", "AspectRatios"."LastEdited", "AspectRatios"."Created", "AspectRatios"."Scale", "AspectRatios"."Ratio", "AspectRatios"."Orientation", "AspectRatios"."ID",
CASE WHEN "AspectRatios"."ClassName" IS NOT NULL THEN "AspectRatios"."ClassName"
ELSE 'RS\\Model\\AspectRatio' END AS "RecordClassName"
FROM "AspectRatios" INNER JOIN "Element_AspectRatios" ON "Element_AspectRatios"."AspectRatiosID" = "AspectRatios"."ID"
WHERE ("Element_AspectRatios"."ElementID" = ?)
ORDER BY "Sort" ASC
0.0004s
0101: SELECT DISTINCT count(DISTINCT "ElementalStyleProperties"."ID") AS "Count"
FROM "ElementalStyleProperties"
WHERE ("ElementalStyleProperties"."StyleOwnerClass" IN ('RS\\Elemental\\Model\\UIElementalContent'))
AND ("ElementalStyleProperties"."StyleOwnerID" = ?)
0.0006s
0102: SELECT DISTINCT count(DISTINCT "ElementalStyleProperties"."ID") AS "Count"
FROM "ElementalStyleProperties"
WHERE ("ElementalStyleProperties"."StyleOwnerClass" IN ('RS\\Elemental\\Model\\UIElementalContent'))
AND ("ElementalStyleProperties"."StyleOwnerID" = ?)
0.0004s
0103: SELECT DISTINCT count(DISTINCT "AspectRatios"."ID") AS "Count"
FROM "AspectRatios" INNER JOIN "Element_AspectRatios" ON "Element_AspectRatios"."AspectRatiosID" = "AspectRatios"."ID"
WHERE ("Element_AspectRatios"."ElementID" = ?)
0.0004s
0104: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE WHEN "Element_Live"."ClassName" IN ('DNADesign\\Elemental\\Models\\BaseElement', 'RS\\Elemental\\Model\\MosaicTile', 'RS\\Model\\TemplateTile', 'RS\\Model\\Tile', 'RS\\Elemental\\Model\\UIElementalBanner', 'RS\\Elemental\\Model\\UIElementalBlogPostList', 'RS\\Elemental\\Model\\UIElementalCTAGroup', 'RS\\Elemental\\Model\\UIElementalCarousel', 'RS\\Elemental\\Model\\UIElementalColumn', 'RS\\Elemental\\Model\\UIElementalCommunityStats', 'RS\\Elemental\\Model\\UIElementalContent', 'RS\\Elemental\\Model\\UIElementalContentGroup', 'RS\\Elemental\\Model\\UIElementalCrowdriff', 'RS\\Elemental\\Model\\UIElementalFeatureBlock', 'RS\\Elemental\\Model\\UIElementalFeatureMap', 'RS\\Elemental\\Model\\UIElementalFeaturedGrid', 'RS\\Elemental\\Model\\UIElementalGallery', 'RS\\Elemental\\Model\\UIElementalGrid', 'RS\\Elemental\\Model\\UIElementalLocomotiveSection', 'RS\\Elemental\\Model\\UIElementalLogoGarden', 'RS\\Elemental\\Model\\UIElementalMosaic', 'RS\\Elemental\\Model\\UIElementalPageHeader', 'RS\\Elemental\\Model\\UIElementalPartnerList', 'RS\\Elemental\\Model\\UIElementalPartnerMap', 'RS\\Elemental\\Model\\UIElementalRepeater', 'RS\\Elemental\\Model\\UIElementalSlide', 'RS\\Elemental\\Model\\UIElementalSpacer', 'RS\\Elemental\\Model\\UIElementalTimeline', 'RS\\Elemental\\Model\\UIElementalTriptych', 'DNADesign\\Elemental\\Models\\ElementContent', 'DNADesign\\ElementalList\\Model\\ElementList', 'DNADesign\\ElementalVirtual\\Model\\ElementVirtual') THEN "Element_Live"."TypeScale" WHEN "Element_Live"."ClassName" IN ('RS\\Elemental\\Model\\UIElementalContent') THEN "UIElementalContent_Live"."TypeScale" WHEN "Element_Live"."ClassName" IN ('RS\\Elemental\\Model\\UIElementalContent') THEN "UIElementalContent_Live"."TypeScale" ELSE NULL END AS "TypeScale", "UIElementalContent_Live"."Subtitle", "UIElementalContent_Live"."Content", "UIElementalContent_Live"."Columns", "UIElementalContent_Live"."PageID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "UIElementalContent_Live" ON "UIElementalContent_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0007s
0105: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "UIElementalContent_Buttons" ON "UIElementalContent_Buttons"."LinkID" = "Link"."ID"
WHERE ("UIElementalContent_Buttons"."UIElementalContentID" = ?)
0.0006s
0106: SELECT DISTINCT count(DISTINCT "ElementalStyleProperties"."ID") AS "Count"
FROM "ElementalStyleProperties"
WHERE ("ElementalStyleProperties"."StyleOwnerClass" IN ('RS\\Elemental\\Model\\UIElementalLogoGarden'))
AND ("ElementalStyleProperties"."StyleOwnerID" = ?)
0.0003s
0107: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "UIElementalLogoGardens_Live"."Content", "UIElementalLogoGardens_Live"."AnimationStyle", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "UIElementalLogoGardens_Live" ON "UIElementalLogoGardens_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0007s
0108: SELECT DISTINCT "UIElementalLogoGardens_Links"."Sort", "Link"."ClassName", "Link"."LastEdited", "Link"."Created", "Link"."Anchor", "Link"."ButtonLabel", "Link"."RelOptions", "Link"."ExtraCSS", "Link"."Key", "Link"."Description", "Link"."Title", "Link"."Type", "Link"."URL", "Link"."Email", "Link"."Phone", "Link"."OpenInNewWindow", "Link"."SelectedStyle", "Link"."SiteTreeID", "Link"."ImageID", "Link"."FileID", "Link"."ID",
CASE WHEN "Link"."ClassName" IS NOT NULL THEN "Link"."ClassName"
ELSE 'gorriecoe\\Link\\Models\\Link' END AS "RecordClassName"
FROM "Link" INNER JOIN "UIElementalLogoGardens_Links" ON "UIElementalLogoGardens_Links"."LinkID" = "Link"."ID"
WHERE ("UIElementalLogoGardens_Links"."UIElementalLogoGardensID" = ?)
ORDER BY "Sort" ASC
0.001s
0109: SELECT DISTINCT count(DISTINCT "Partners_Live"."ID") AS "Count"
FROM "Partners_Live" INNER JOIN "UIElementalLogoGardens_Partners" ON "UIElementalLogoGardens_Partners"."PartnersID" = "Partners_Live"."ID"
WHERE ("UIElementalLogoGardens_Partners"."UIElementalLogoGardensID" = ?)
0.0005s
0110: SELECT DISTINCT "UIElementalLogoGardens_Partners"."Sort", "Partners_Live"."ClassName", "Partners_Live"."LastEdited", "Partners_Live"."Created", "Partners_Live"."OGTitle", "Partners_Live"."OGType", "Partners_Live"."OGDescription", "Partners_Live"."Title", "Partners_Live"."SearchContent", "Partners_Live"."Keywords", "Partners_Live"."ShowInSearch", "Partners_Live"."Weight", "Partners_Live"."Version", "Partners_Live"."URLSegment", "Partners_Live"."Excerpt", "Partners_Live"."Description", "Partners_Live"."Tips", "Partners_Live"."URL", "Partners_Live"."VideoURL", "Partners_Live"."Phone", "Partners_Live"."TollFree", "Partners_Live"."Address", "Partners_Live"."PostalCode", "Partners_Live"."Province", "Partners_Live"."Hours", "Partners_Live"."PlaceType", "Partners_Live"."SortOrder", "Partners_Live"."ImageID", "Partners_Live"."OGImageID", "Partners_Live"."LogoID", "Partners_Live"."CityID", "Partners_Live"."ElementalAreaID", "Partners_Live"."ID",
CASE WHEN "Partners_Live"."ClassName" IS NOT NULL THEN "Partners_Live"."ClassName"
ELSE 'RS\\Model\\Partner' END AS "RecordClassName"
FROM "Partners_Live" INNER JOIN "UIElementalLogoGardens_Partners" ON "UIElementalLogoGardens_Partners"."PartnersID" = "Partners_Live"."ID"
WHERE ("UIElementalLogoGardens_Partners"."UIElementalLogoGardensID" = ?)
ORDER BY "Sort" ASC
0.0017s
0111: 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"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "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.0007s
0112: 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"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "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.0006s
0113: 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"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "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.0007s
0114: 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"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "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.0006s
0115: 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"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "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.0006s
0116: 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"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "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.0005s
0117: 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"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "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.0004s
0118: 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"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "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.0004s
0119: 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"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "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.0004s
0120: 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"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "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.0006s
0121: 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"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "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.0005s
0122: 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"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "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.0005s
0123: 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"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "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.0005s
0124: 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"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "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.0005s
0125: 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"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "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.0004s
0126: 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"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "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.0004s
0127: 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"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "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.0005s
0128: SELECT DISTINCT "UIContentCollections"."ClassName", "UIContentCollections"."LastEdited", "UIContentCollections"."Created", "UIContentCollections"."Title", "UIContentCollections"."Key", "UIContentCollections"."Description", "UIContentCollections"."Active", "UIContentCollections"."ID",
CASE WHEN "UIContentCollections"."ClassName" IS NOT NULL THEN "UIContentCollections"."ClassName"
ELSE 'RS\\NavBuilder\\Model\\UIContentCollection' END AS "RecordClassName"
FROM "UIContentCollections"
WHERE ("UIContentCollections"."Key" = ?)
AND ("UIContentCollections"."Active" = ?)
LIMIT 1
0.0034s
0129: SELECT DISTINCT "UIContent"."ClassName", "UIContent"."LastEdited", "UIContent"."Created", "UIContent"."XS", "UIContent"."SM", "UIContent"."MM", "UIContent"."LG", "UIContent"."XL", "UIContent"."XXL", "UIContent"."Orientation", "UIContent"."Gap", "UIContent"."Title", "UIContent"."Content", "UIContent"."Key", "UIContent"."Active", "UIContent"."ShowHeader", "UIContent"."DisplayContent", "UIContent"."MediaBlock", "UIContent"."LinksAsButtons", "UIContent"."AspectRatio", "UIContent"."SortOrder", "UIContent"."ImageID", "UIContent"."ID",
CASE WHEN "UIContent"."ClassName" IS NOT NULL THEN "UIContent"."ClassName"
ELSE 'RS\\Model\\UIContent' END AS "RecordClassName"
FROM "UIContent" INNER JOIN "UIContent_UIContentCollections" ON "UIContent_UIContentCollections"."UIContentID" = "UIContent"."ID"
WHERE ("UIContent_UIContentCollections"."UIContentCollectionsID" = ?)
AND (("UIContent"."Active" != ? OR "UIContent"."Active" IS NULL))
ORDER BY "UIContent"."SortOrder" ASC
0.0018s
0130: 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"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "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.0007s
0131: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "UIContent_Links" ON "UIContent_Links"."LinkID" = "Link"."ID"
WHERE ("UIContent_Links"."UIContentID" = ?)
0.0006s
0132: SELECT DISTINCT "UIContent_Links"."Sort", "Link"."ClassName", "Link"."LastEdited", "Link"."Created", "Link"."Anchor", "Link"."ButtonLabel", "Link"."RelOptions", "Link"."ExtraCSS", "Link"."Key", "Link"."Description", "Link"."Title", "Link"."Type", "Link"."URL", "Link"."Email", "Link"."Phone", "Link"."OpenInNewWindow", "Link"."SelectedStyle", "Link"."SiteTreeID", "Link"."ImageID", "Link"."FileID", "Link"."ID",
CASE WHEN "Link"."ClassName" IS NOT NULL THEN "Link"."ClassName"
ELSE 'gorriecoe\\Link\\Models\\Link' END AS "RecordClassName"
FROM "Link" INNER JOIN "UIContent_Links" ON "UIContent_Links"."LinkID" = "Link"."ID"
WHERE ("UIContent_Links"."UIContentID" = ?)
ORDER BY "Sort" ASC
0.0011s
0133: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."OGTitle", "SiteTree_Live"."OGType", "SiteTree_Live"."OGDescription", "SiteTree_Live"."BGVideoURL", "SiteTree_Live"."BGVideoType", "SiteTree_Live"."BGVideoID", "SiteTree_Live"."BGVideoStatus", "SiteTree_Live"."BGVideoDelay", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "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"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0005s
0134: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "UIContent_Links" ON "UIContent_Links"."LinkID" = "Link"."ID"
WHERE ("UIContent_Links"."UIContentID" = ?)
0.0006s
0135: SELECT DISTINCT "UIContent_Links"."Sort", "Link"."ClassName", "Link"."LastEdited", "Link"."Created", "Link"."Anchor", "Link"."ButtonLabel", "Link"."RelOptions", "Link"."ExtraCSS", "Link"."Key", "Link"."Description", "Link"."Title", "Link"."Type", "Link"."URL", "Link"."Email", "Link"."Phone", "Link"."OpenInNewWindow", "Link"."SelectedStyle", "Link"."SiteTreeID", "Link"."ImageID", "Link"."FileID", "Link"."ID",
CASE WHEN "Link"."ClassName" IS NOT NULL THEN "Link"."ClassName"
ELSE 'gorriecoe\\Link\\Models\\Link' END AS "RecordClassName"
FROM "Link" INNER JOIN "UIContent_Links" ON "UIContent_Links"."LinkID" = "Link"."ID"
WHERE ("UIContent_Links"."UIContentID" = ?)
ORDER BY "Sort" ASC
0.0011s
0136: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."OGTitle", "SiteTree_Live"."OGType", "SiteTree_Live"."OGDescription", "SiteTree_Live"."BGVideoURL", "SiteTree_Live"."BGVideoType", "SiteTree_Live"."BGVideoID", "SiteTree_Live"."BGVideoStatus", "SiteTree_Live"."BGVideoDelay", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "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"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0006s
0137: SELECT DISTINCT "Navigation"."ClassName", "Navigation"."LastEdited", "Navigation"."Created", "Navigation"."Title", "Navigation"."Description", "Navigation"."Key", "Navigation"."ExtraCSS", "Navigation"."Active", "Navigation"."ID",
CASE WHEN "Navigation"."ClassName" IS NOT NULL THEN "Navigation"."ClassName"
ELSE 'RS\\NavBuilder\\Model\\Navigation' END AS "RecordClassName"
FROM "Navigation"
WHERE ("Navigation"."Key" = ?)
AND ("Navigation"."Active" = ?)
LIMIT 1
0.0005s
0138: SELECT DISTINCT "Navigation_Links"."Sort", "Link"."ClassName", "Link"."LastEdited", "Link"."Created", "Link"."Anchor", "Link"."ButtonLabel", "Link"."RelOptions", "Link"."ExtraCSS", "Link"."Key", "Link"."Description", "Link"."Title", "Link"."Type", "Link"."URL", "Link"."Email", "Link"."Phone", "Link"."OpenInNewWindow", "Link"."SelectedStyle", "Link"."SiteTreeID", "Link"."ImageID", "Link"."FileID", "NavigationLinks"."RenderMultiLevel", "Link"."ID",
CASE WHEN "Link"."ClassName" IS NOT NULL THEN "Link"."ClassName"
ELSE 'gorriecoe\\Link\\Models\\Link' END AS "RecordClassName"
FROM "Link" LEFT JOIN "NavigationLinks" ON "NavigationLinks"."ID" = "Link"."ID" INNER JOIN "Navigation_Links" ON "Navigation_Links"."NavigationLinksID" = "Link"."ID"
WHERE ("Navigation_Links"."NavigationID" = ?)
AND ("Link"."ClassName" IN (?))
ORDER BY "Sort" ASC
0.0015s
0139: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."OGTitle", "SiteTree_Live"."OGType", "SiteTree_Live"."OGDescription", "SiteTree_Live"."BGVideoURL", "SiteTree_Live"."BGVideoType", "SiteTree_Live"."BGVideoID", "SiteTree_Live"."BGVideoStatus", "SiteTree_Live"."BGVideoDelay", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "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"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0006s
0140: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."OGTitle", "SiteTree_Live"."OGType", "SiteTree_Live"."OGDescription", "SiteTree_Live"."BGVideoURL", "SiteTree_Live"."BGVideoType", "SiteTree_Live"."BGVideoID", "SiteTree_Live"."BGVideoStatus", "SiteTree_Live"."BGVideoDelay", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "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"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0019s
0141: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."OGTitle", "SiteTree_Live"."OGType", "SiteTree_Live"."OGDescription", "SiteTree_Live"."BGVideoURL", "SiteTree_Live"."BGVideoType", "SiteTree_Live"."BGVideoID", "SiteTree_Live"."BGVideoStatus", "SiteTree_Live"."BGVideoDelay", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "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"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0005s
0142: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."OGTitle", "SiteTree_Live"."OGType", "SiteTree_Live"."OGDescription", "SiteTree_Live"."BGVideoURL", "SiteTree_Live"."BGVideoType", "SiteTree_Live"."BGVideoID", "SiteTree_Live"."BGVideoStatus", "SiteTree_Live"."BGVideoDelay", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "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"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0004s
0143: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."OGTitle", "SiteTree_Live"."OGType", "SiteTree_Live"."OGDescription", "SiteTree_Live"."BGVideoURL", "SiteTree_Live"."BGVideoType", "SiteTree_Live"."BGVideoID", "SiteTree_Live"."BGVideoStatus", "SiteTree_Live"."BGVideoDelay", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "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"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0004s
0144: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."OGTitle", "SiteTree_Live"."OGType", "SiteTree_Live"."OGDescription", "SiteTree_Live"."BGVideoURL", "SiteTree_Live"."BGVideoType", "SiteTree_Live"."BGVideoID", "SiteTree_Live"."BGVideoStatus", "SiteTree_Live"."BGVideoDelay", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "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"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0004s
0145: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."OGTitle", "SiteTree_Live"."OGType", "SiteTree_Live"."OGDescription", "SiteTree_Live"."BGVideoURL", "SiteTree_Live"."BGVideoType", "SiteTree_Live"."BGVideoID", "SiteTree_Live"."BGVideoStatus", "SiteTree_Live"."BGVideoDelay", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "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"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0004s
0146: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "UIContent_Links" ON "UIContent_Links"."LinkID" = "Link"."ID"
WHERE ("UIContent_Links"."UIContentID" = ?)
0.0005s
0147: SELECT DISTINCT count(DISTINCT "UIContent"."ID") AS "Count"
FROM "UIContent" INNER JOIN "UIContent_UIContentCollections" ON "UIContent_UIContentCollections"."UIContentID" = "UIContent"."ID"
WHERE ("UIContent_UIContentCollections"."UIContentCollectionsID" = ?)
0.0007s
0148: SELECT DISTINCT "LeadSources"."ClassName", "LeadSources"."LastEdited", "LeadSources"."Created", "LeadSources"."Title", "LeadSources"."Key", "LeadSources"."ListID", "LeadSources"."SendNotifications", "LeadSources"."ForceEmailThreading", "LeadSources"."FormHeading", "LeadSources"."FormClass", "LeadSources"."FormIDOverride", "LeadSources"."FormFootnote", "LeadSources"."FormContent", "LeadSources"."FormSubmitLabel", "LeadSources"."FormMessageLabel", "LeadSources"."RenderAddressFields", "LeadSources"."RenderPhoneField", "LeadSources"."RenderTextArea", "LeadSources"."EventCategory", "LeadSources"."EventAction", "LeadSources"."EventLabel", "LeadSources"."RenderForm", "LeadSources"."RenderFormHeading", "LeadSources"."RenderSiteWide", "LeadSources"."ImplicitOptIn", "LeadSources"."SortOrder", "LeadSources"."ContentID", "LeadSources"."ID",
CASE WHEN "LeadSources"."ClassName" IS NOT NULL THEN "LeadSources"."ClassName"
ELSE 'RS\\Model\\LeadSource' END AS "RecordClassName"
FROM "LeadSources"
WHERE ("LeadSources"."RenderSiteWide" = ?)
0.0005s
0149: SELECT DISTINCT "LeadSources"."ClassName", "LeadSources"."LastEdited", "LeadSources"."Created", "LeadSources"."Title", "LeadSources"."Key", "LeadSources"."ListID", "LeadSources"."SendNotifications", "LeadSources"."ForceEmailThreading", "LeadSources"."FormHeading", "LeadSources"."FormClass", "LeadSources"."FormIDOverride", "LeadSources"."FormFootnote", "LeadSources"."FormContent", "LeadSources"."FormSubmitLabel", "LeadSources"."FormMessageLabel", "LeadSources"."RenderAddressFields", "LeadSources"."RenderPhoneField", "LeadSources"."RenderTextArea", "LeadSources"."EventCategory", "LeadSources"."EventAction", "LeadSources"."EventLabel", "LeadSources"."RenderForm", "LeadSources"."RenderFormHeading", "LeadSources"."RenderSiteWide", "LeadSources"."ImplicitOptIn", "LeadSources"."SortOrder", "LeadSources"."ContentID", "LeadSources"."ID",
CASE WHEN "LeadSources"."ClassName" IS NOT NULL THEN "LeadSources"."ClassName"
ELSE 'RS\\Model\\LeadSource' END AS "RecordClassName"
FROM "LeadSources"
WHERE ("LeadSources"."Key" = ?)
LIMIT 1
0.0004s
0150: SELECT DISTINCT "LeadSources"."ClassName", "LeadSources"."LastEdited", "LeadSources"."Created", "LeadSources"."Title", "LeadSources"."Key", "LeadSources"."ListID", "LeadSources"."SendNotifications", "LeadSources"."ForceEmailThreading", "LeadSources"."FormHeading", "LeadSources"."FormClass", "LeadSources"."FormIDOverride", "LeadSources"."FormFootnote", "LeadSources"."FormContent", "LeadSources"."FormSubmitLabel", "LeadSources"."FormMessageLabel", "LeadSources"."RenderAddressFields", "LeadSources"."RenderPhoneField", "LeadSources"."RenderTextArea", "LeadSources"."EventCategory", "LeadSources"."EventAction", "LeadSources"."EventLabel", "LeadSources"."RenderForm", "LeadSources"."RenderFormHeading", "LeadSources"."RenderSiteWide", "LeadSources"."ImplicitOptIn", "LeadSources"."SortOrder", "LeadSources"."ContentID", "LeadSources"."ID",
CASE WHEN "LeadSources"."ClassName" IS NOT NULL THEN "LeadSources"."ClassName"
ELSE 'RS\\Model\\LeadSource' END AS "RecordClassName"
FROM "LeadSources"
WHERE ("LeadSources"."ID" = ?)
LIMIT 1
0.0005s
0151: SELECT DISTINCT "LeadOptins"."ClassName", "LeadOptins"."LastEdited", "LeadOptins"."Created", "LeadOptins"."Label", "LeadOptins"."Description", "LeadOptins"."LeadSourceID", "LeadOptins"."ID",
CASE WHEN "LeadOptins"."ClassName" IS NOT NULL THEN "LeadOptins"."ClassName"
ELSE 'RS\\Model\\LeadOptin' END AS "RecordClassName"
FROM "LeadOptins"
WHERE ("LeadOptins"."LeadSourceID" = ?)
0.0003s
0152: SELECT DISTINCT count(DISTINCT "LeadSourceFields"."ID") AS "Count"
FROM "LeadSourceFields"
WHERE ("LeadSourceFields"."LeadSourceID" = ?)
0.0003s
0153: SELECT DISTINCT count(DISTINCT "LeadSources"."ID") AS "Count"
FROM "LeadSources"
WHERE ("LeadSources"."Key" = ?)
0.0003s
0154: SELECT DISTINCT "LeadSources"."ClassName", "LeadSources"."LastEdited", "LeadSources"."Created", "LeadSources"."Title", "LeadSources"."Key", "LeadSources"."ListID", "LeadSources"."SendNotifications", "LeadSources"."ForceEmailThreading", "LeadSources"."FormHeading", "LeadSources"."FormClass", "LeadSources"."FormIDOverride", "LeadSources"."FormFootnote", "LeadSources"."FormContent", "LeadSources"."FormSubmitLabel", "LeadSources"."FormMessageLabel", "LeadSources"."RenderAddressFields", "LeadSources"."RenderPhoneField", "LeadSources"."RenderTextArea", "LeadSources"."EventCategory", "LeadSources"."EventAction", "LeadSources"."EventLabel", "LeadSources"."RenderForm", "LeadSources"."RenderFormHeading", "LeadSources"."RenderSiteWide", "LeadSources"."ImplicitOptIn", "LeadSources"."SortOrder", "LeadSources"."ContentID", "LeadSources"."ID",
CASE WHEN "LeadSources"."ClassName" IS NOT NULL THEN "LeadSources"."ClassName"
ELSE 'RS\\Model\\LeadSource' END AS "RecordClassName"
FROM "LeadSources"
WHERE ("LeadSources"."Key" = ?)
LIMIT 1
0.0004s
0155: SELECT DISTINCT "LeadSources"."ClassName", "LeadSources"."LastEdited", "LeadSources"."Created", "LeadSources"."Title", "LeadSources"."Key", "LeadSources"."ListID", "LeadSources"."SendNotifications", "LeadSources"."ForceEmailThreading", "LeadSources"."FormHeading", "LeadSources"."FormClass", "LeadSources"."FormIDOverride", "LeadSources"."FormFootnote", "LeadSources"."FormContent", "LeadSources"."FormSubmitLabel", "LeadSources"."FormMessageLabel", "LeadSources"."RenderAddressFields", "LeadSources"."RenderPhoneField", "LeadSources"."RenderTextArea", "LeadSources"."EventCategory", "LeadSources"."EventAction", "LeadSources"."EventLabel", "LeadSources"."RenderForm", "LeadSources"."RenderFormHeading", "LeadSources"."RenderSiteWide", "LeadSources"."ImplicitOptIn", "LeadSources"."SortOrder", "LeadSources"."ContentID", "LeadSources"."ID",
CASE WHEN "LeadSources"."ClassName" IS NOT NULL THEN "LeadSources"."ClassName"
ELSE 'RS\\Model\\LeadSource' END AS "RecordClassName"
FROM "LeadSources"
WHERE ("LeadSources"."Key" = ?)
LIMIT 1
0.0005s
0156: SELECT DISTINCT "LeadSources"."ClassName", "LeadSources"."LastEdited", "LeadSources"."Created", "LeadSources"."Title", "LeadSources"."Key", "LeadSources"."ListID", "LeadSources"."SendNotifications", "LeadSources"."ForceEmailThreading", "LeadSources"."FormHeading", "LeadSources"."FormClass", "LeadSources"."FormIDOverride", "LeadSources"."FormFootnote", "LeadSources"."FormContent", "LeadSources"."FormSubmitLabel", "LeadSources"."FormMessageLabel", "LeadSources"."RenderAddressFields", "LeadSources"."RenderPhoneField", "LeadSources"."RenderTextArea", "LeadSources"."EventCategory", "LeadSources"."EventAction", "LeadSources"."EventLabel", "LeadSources"."RenderForm", "LeadSources"."RenderFormHeading", "LeadSources"."RenderSiteWide", "LeadSources"."ImplicitOptIn", "LeadSources"."SortOrder", "LeadSources"."ContentID", "LeadSources"."ID",
CASE WHEN "LeadSources"."ClassName" IS NOT NULL THEN "LeadSources"."ClassName"
ELSE 'RS\\Model\\LeadSource' END AS "RecordClassName"
FROM "LeadSources"
WHERE ("LeadSources"."ID" = ?)
LIMIT 1
0.0003s
0157: SELECT DISTINCT "LeadOptins"."ClassName", "LeadOptins"."LastEdited", "LeadOptins"."Created", "LeadOptins"."Label", "LeadOptins"."Description", "LeadOptins"."LeadSourceID", "LeadOptins"."ID",
CASE WHEN "LeadOptins"."ClassName" IS NOT NULL THEN "LeadOptins"."ClassName"
ELSE 'RS\\Model\\LeadOptin' END AS "RecordClassName"
FROM "LeadOptins"
WHERE ("LeadOptins"."LeadSourceID" = ?)
0.0002s
0158: SELECT DISTINCT count(DISTINCT "LeadSourceFields"."ID") AS "Count"
FROM "LeadSourceFields"
WHERE ("LeadSourceFields"."LeadSourceID" = ?)
0.0002s
0159: SELECT DISTINCT count(DISTINCT "LeadSources"."ID") AS "Count"
FROM "LeadSources"
WHERE ("LeadSources"."Key" = ?)
0.0002s
0160: SELECT DISTINCT "LeadSources"."ClassName", "LeadSources"."LastEdited", "LeadSources"."Created", "LeadSources"."Title", "LeadSources"."Key", "LeadSources"."ListID", "LeadSources"."SendNotifications", "LeadSources"."ForceEmailThreading", "LeadSources"."FormHeading", "LeadSources"."FormClass", "LeadSources"."FormIDOverride", "LeadSources"."FormFootnote", "LeadSources"."FormContent", "LeadSources"."FormSubmitLabel", "LeadSources"."FormMessageLabel", "LeadSources"."RenderAddressFields", "LeadSources"."RenderPhoneField", "LeadSources"."RenderTextArea", "LeadSources"."EventCategory", "LeadSources"."EventAction", "LeadSources"."EventLabel", "LeadSources"."RenderForm", "LeadSources"."RenderFormHeading", "LeadSources"."RenderSiteWide", "LeadSources"."ImplicitOptIn", "LeadSources"."SortOrder", "LeadSources"."ContentID", "LeadSources"."ID",
CASE WHEN "LeadSources"."ClassName" IS NOT NULL THEN "LeadSources"."ClassName"
ELSE 'RS\\Model\\LeadSource' END AS "RecordClassName"
FROM "LeadSources"
WHERE ("LeadSources"."Key" = ?)
LIMIT 1
0.0003s
0161: SELECT DISTINCT "LeadSources"."ClassName", "LeadSources"."LastEdited", "LeadSources"."Created", "LeadSources"."Title", "LeadSources"."Key", "LeadSources"."ListID", "LeadSources"."SendNotifications", "LeadSources"."ForceEmailThreading", "LeadSources"."FormHeading", "LeadSources"."FormClass", "LeadSources"."FormIDOverride", "LeadSources"."FormFootnote", "LeadSources"."FormContent", "LeadSources"."FormSubmitLabel", "LeadSources"."FormMessageLabel", "LeadSources"."RenderAddressFields", "LeadSources"."RenderPhoneField", "LeadSources"."RenderTextArea", "LeadSources"."EventCategory", "LeadSources"."EventAction", "LeadSources"."EventLabel", "LeadSources"."RenderForm", "LeadSources"."RenderFormHeading", "LeadSources"."RenderSiteWide", "LeadSources"."ImplicitOptIn", "LeadSources"."SortOrder", "LeadSources"."ContentID", "LeadSources"."ID",
CASE WHEN "LeadSources"."ClassName" IS NOT NULL THEN "LeadSources"."ClassName"
ELSE 'RS\\Model\\LeadSource' END AS "RecordClassName"
FROM "LeadSources" LEFT JOIN "LeadSources_Pages" AS "pages_LeadSources_Pages" ON "pages_LeadSources_Pages"."LeadSourcesID" = "LeadSources"."ID" LEFT JOIN "SiteTree_Live" AS "pages_SiteTree" ON "pages_LeadSources_Pages"."SiteTreeID" = "pages_SiteTree"."ID"
WHERE ("pages_SiteTree"."ID" IN (2))
0.0014s
0162: SELECT DISTINCT "LeadSources"."ClassName", "LeadSources"."LastEdited", "LeadSources"."Created", "LeadSources"."Title", "LeadSources"."Key", "LeadSources"."ListID", "LeadSources"."SendNotifications", "LeadSources"."ForceEmailThreading", "LeadSources"."FormHeading", "LeadSources"."FormClass", "LeadSources"."FormIDOverride", "LeadSources"."FormFootnote", "LeadSources"."FormContent", "LeadSources"."FormSubmitLabel", "LeadSources"."FormMessageLabel", "LeadSources"."RenderAddressFields", "LeadSources"."RenderPhoneField", "LeadSources"."RenderTextArea", "LeadSources"."EventCategory", "LeadSources"."EventAction", "LeadSources"."EventLabel", "LeadSources"."RenderForm", "LeadSources"."RenderFormHeading", "LeadSources"."RenderSiteWide", "LeadSources"."ImplicitOptIn", "LeadSources"."SortOrder", "LeadSources"."ContentID", "LeadSources"."ID",
CASE WHEN "LeadSources"."ClassName" IS NOT NULL THEN "LeadSources"."ClassName"
ELSE 'RS\\Model\\LeadSource' END AS "RecordClassName"
FROM "LeadSources"
WHERE ("LeadSources"."Key" = ?)
LIMIT 1
0.0004s
0163: SELECT DISTINCT "LeadSources"."ClassName", "LeadSources"."LastEdited", "LeadSources"."Created", "LeadSources"."Title", "LeadSources"."Key", "LeadSources"."ListID", "LeadSources"."SendNotifications", "LeadSources"."ForceEmailThreading", "LeadSources"."FormHeading", "LeadSources"."FormClass", "LeadSources"."FormIDOverride", "LeadSources"."FormFootnote", "LeadSources"."FormContent", "LeadSources"."FormSubmitLabel", "LeadSources"."FormMessageLabel", "LeadSources"."RenderAddressFields", "LeadSources"."RenderPhoneField", "LeadSources"."RenderTextArea", "LeadSources"."EventCategory", "LeadSources"."EventAction", "LeadSources"."EventLabel", "LeadSources"."RenderForm", "LeadSources"."RenderFormHeading", "LeadSources"."RenderSiteWide", "LeadSources"."ImplicitOptIn", "LeadSources"."SortOrder", "LeadSources"."ContentID", "LeadSources"."ID",
CASE WHEN "LeadSources"."ClassName" IS NOT NULL THEN "LeadSources"."ClassName"
ELSE 'RS\\Model\\LeadSource' END AS "RecordClassName"
FROM "LeadSources"
WHERE ("LeadSources"."ID" = ?)
LIMIT 1
0.0004s
0164: SELECT DISTINCT "LeadOptins"."ClassName", "LeadOptins"."LastEdited", "LeadOptins"."Created", "LeadOptins"."Label", "LeadOptins"."Description", "LeadOptins"."LeadSourceID", "LeadOptins"."ID",
CASE WHEN "LeadOptins"."ClassName" IS NOT NULL THEN "LeadOptins"."ClassName"
ELSE 'RS\\Model\\LeadOptin' END AS "RecordClassName"
FROM "LeadOptins"
WHERE ("LeadOptins"."LeadSourceID" = ?)
0.0005s
0165: SELECT DISTINCT count(DISTINCT "LeadSourceFields"."ID") AS "Count"
FROM "LeadSourceFields"
WHERE ("LeadSourceFields"."LeadSourceID" = ?)
0.0003s
0166: SELECT DISTINCT count(DISTINCT "LeadSources"."ID") AS "Count"
FROM "LeadSources"
WHERE ("LeadSources"."Key" = ?)
0.0003s
0167: SELECT DISTINCT "LeadSources"."ClassName", "LeadSources"."LastEdited", "LeadSources"."Created", "LeadSources"."Title", "LeadSources"."Key", "LeadSources"."ListID", "LeadSources"."SendNotifications", "LeadSources"."ForceEmailThreading", "LeadSources"."FormHeading", "LeadSources"."FormClass", "LeadSources"."FormIDOverride", "LeadSources"."FormFootnote", "LeadSources"."FormContent", "LeadSources"."FormSubmitLabel", "LeadSources"."FormMessageLabel", "LeadSources"."RenderAddressFields", "LeadSources"."RenderPhoneField", "LeadSources"."RenderTextArea", "LeadSources"."EventCategory", "LeadSources"."EventAction", "LeadSources"."EventLabel", "LeadSources"."RenderForm", "LeadSources"."RenderFormHeading", "LeadSources"."RenderSiteWide", "LeadSources"."ImplicitOptIn", "LeadSources"."SortOrder", "LeadSources"."ContentID", "LeadSources"."ID",
CASE WHEN "LeadSources"."ClassName" IS NOT NULL THEN "LeadSources"."ClassName"
ELSE 'RS\\Model\\LeadSource' END AS "RecordClassName"
FROM "LeadSources"
WHERE ("LeadSources"."Key" = ?)
LIMIT 1
0.0004s
0168: SELECT DISTINCT "LeadSources"."ClassName", "LeadSources"."LastEdited", "LeadSources"."Created", "LeadSources"."Title", "LeadSources"."Key", "LeadSources"."ListID", "LeadSources"."SendNotifications", "LeadSources"."ForceEmailThreading", "LeadSources"."FormHeading", "LeadSources"."FormClass", "LeadSources"."FormIDOverride", "LeadSources"."FormFootnote", "LeadSources"."FormContent", "LeadSources"."FormSubmitLabel", "LeadSources"."FormMessageLabel", "LeadSources"."RenderAddressFields", "LeadSources"."RenderPhoneField", "LeadSources"."RenderTextArea", "LeadSources"."EventCategory", "LeadSources"."EventAction", "LeadSources"."EventLabel", "LeadSources"."RenderForm", "LeadSources"."RenderFormHeading", "LeadSources"."RenderSiteWide", "LeadSources"."ImplicitOptIn", "LeadSources"."SortOrder", "LeadSources"."ContentID", "LeadSources"."ID",
CASE WHEN "LeadSources"."ClassName" IS NOT NULL THEN "LeadSources"."ClassName"
ELSE 'RS\\Model\\LeadSource' END AS "RecordClassName"
FROM "LeadSources"
WHERE ("LeadSources"."Key" = ?)
LIMIT 1
0.0008s
0169: SELECT DISTINCT "LeadSources"."ClassName", "LeadSources"."LastEdited", "LeadSources"."Created", "LeadSources"."Title", "LeadSources"."Key", "LeadSources"."ListID", "LeadSources"."SendNotifications", "LeadSources"."ForceEmailThreading", "LeadSources"."FormHeading", "LeadSources"."FormClass", "LeadSources"."FormIDOverride", "LeadSources"."FormFootnote", "LeadSources"."FormContent", "LeadSources"."FormSubmitLabel", "LeadSources"."FormMessageLabel", "LeadSources"."RenderAddressFields", "LeadSources"."RenderPhoneField", "LeadSources"."RenderTextArea", "LeadSources"."EventCategory", "LeadSources"."EventAction", "LeadSources"."EventLabel", "LeadSources"."RenderForm", "LeadSources"."RenderFormHeading", "LeadSources"."RenderSiteWide", "LeadSources"."ImplicitOptIn", "LeadSources"."SortOrder", "LeadSources"."ContentID", "LeadSources"."ID",
CASE WHEN "LeadSources"."ClassName" IS NOT NULL THEN "LeadSources"."ClassName"
ELSE 'RS\\Model\\LeadSource' END AS "RecordClassName"
FROM "LeadSources"
WHERE ("LeadSources"."ID" = ?)
LIMIT 1
0.0012s
0170: SELECT DISTINCT "LeadOptins"."ClassName", "LeadOptins"."LastEdited", "LeadOptins"."Created", "LeadOptins"."Label", "LeadOptins"."Description", "LeadOptins"."LeadSourceID", "LeadOptins"."ID",
CASE WHEN "LeadOptins"."ClassName" IS NOT NULL THEN "LeadOptins"."ClassName"
ELSE 'RS\\Model\\LeadOptin' END AS "RecordClassName"
FROM "LeadOptins"
WHERE ("LeadOptins"."LeadSourceID" = ?)
0.0004s
0171: SELECT DISTINCT count(DISTINCT "LeadSourceFields"."ID") AS "Count"
FROM "LeadSourceFields"
WHERE ("LeadSourceFields"."LeadSourceID" = ?)
0.0003s
0172: SELECT DISTINCT count(DISTINCT "LeadSources"."ID") AS "Count"
FROM "LeadSources"
WHERE ("LeadSources"."Key" = ?)
0.0003s
0173: SELECT DISTINCT "LeadSources"."ClassName", "LeadSources"."LastEdited", "LeadSources"."Created", "LeadSources"."Title", "LeadSources"."Key", "LeadSources"."ListID", "LeadSources"."SendNotifications", "LeadSources"."ForceEmailThreading", "LeadSources"."FormHeading", "LeadSources"."FormClass", "LeadSources"."FormIDOverride", "LeadSources"."FormFootnote", "LeadSources"."FormContent", "LeadSources"."FormSubmitLabel", "LeadSources"."FormMessageLabel", "LeadSources"."RenderAddressFields", "LeadSources"."RenderPhoneField", "LeadSources"."RenderTextArea", "LeadSources"."EventCategory", "LeadSources"."EventAction", "LeadSources"."EventLabel", "LeadSources"."RenderForm", "LeadSources"."RenderFormHeading", "LeadSources"."RenderSiteWide", "LeadSources"."ImplicitOptIn", "LeadSources"."SortOrder", "LeadSources"."ContentID", "LeadSources"."ID",
CASE WHEN "LeadSources"."ClassName" IS NOT NULL THEN "LeadSources"."ClassName"
ELSE 'RS\\Model\\LeadSource' END AS "RecordClassName"
FROM "LeadSources"
WHERE ("LeadSources"."Key" = ?)
LIMIT 1
0.0005s
0174: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."OGTitle", "SiteTree_Live"."OGType", "SiteTree_Live"."OGDescription", "SiteTree_Live"."BGVideoURL", "SiteTree_Live"."BGVideoType", "SiteTree_Live"."BGVideoID", "SiteTree_Live"."BGVideoStatus", "SiteTree_Live"."BGVideoDelay", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "SiteTree_Live"."Title" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."Title" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."Title" ELSE NULL END AS "Title", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "SiteTree_Live"."SearchContent" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."SearchContent" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."SearchContent" ELSE NULL END AS "SearchContent", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "SiteTree_Live"."Keywords" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."Keywords" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."Keywords" ELSE NULL END AS "Keywords", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "SiteTree_Live"."ShowInSearch" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."ShowInSearch" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."ShowInSearch" ELSE NULL END AS "ShowInSearch", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "SiteTree_Live"."Weight" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."Weight" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."Weight" ELSE NULL END AS "Weight", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "SiteTree_Live"."ParentID", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."SSLayoutTemplate" WHEN "SiteTree_Live"."ClassName" IN ('CookiePolicyPage') THEN "CookiePolicyPage_Live"."SSLayoutTemplate" WHEN "SiteTree_Live"."ClassName" IN ('CookiePolicyPage') THEN "CookiePolicyPage_Live"."SSLayoutTemplate" ELSE NULL END AS "SSLayoutTemplate", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."SSLayoutClasses" WHEN "SiteTree_Live"."ClassName" IN ('CookiePolicyPage') THEN "CookiePolicyPage_Live"."SSLayoutClasses" WHEN "SiteTree_Live"."ClassName" IN ('CookiePolicyPage') THEN "CookiePolicyPage_Live"."SSLayoutClasses" ELSE NULL END AS "SSLayoutClasses", "CookiePolicyPage_Live"."FooterContent", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
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"
WHERE ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0022s
0175: SELECT "Version" FROM "SiteTree" WHERE "ID" = ?
0.0004s
0176: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."OGTitle", "SiteTree_Live"."OGType", "SiteTree_Live"."OGDescription", "SiteTree_Live"."BGVideoURL", "SiteTree_Live"."BGVideoType", "SiteTree_Live"."BGVideoID", "SiteTree_Live"."BGVideoStatus", "SiteTree_Live"."BGVideoDelay", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "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"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0005s
0177: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."OGTitle", "SiteTree_Live"."OGType", "SiteTree_Live"."OGDescription", "SiteTree_Live"."BGVideoURL", "SiteTree_Live"."BGVideoType", "SiteTree_Live"."BGVideoID", "SiteTree_Live"."BGVideoStatus", "SiteTree_Live"."BGVideoDelay", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "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"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0004s
0178: SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", "SiteTree"."Priority", "SiteTree"."OGTitle", "SiteTree"."OGType", "SiteTree"."OGDescription", "SiteTree"."BGVideoURL", "SiteTree"."BGVideoType", "SiteTree"."BGVideoID", "SiteTree"."BGVideoStatus", "SiteTree"."BGVideoDelay", "SiteTree"."Title", "SiteTree"."SearchContent", "SiteTree"."Keywords", "SiteTree"."ShowInSearch", "SiteTree"."Weight", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."Version", "SiteTree"."URLSegment", "SiteTree"."MenuTitle", "SiteTree"."Content", "SiteTree"."MetaDescription", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", "SiteTree"."ReportClass", "SiteTree"."ImageID", "SiteTree"."OGImageID", "SiteTree"."BGVideoPosterID", "SiteTree"."ParentID", "SiteTree"."ID",
CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree"
WHERE ("SiteTree"."ID" = ?)
ORDER BY "SiteTree"."Sort" ASC
LIMIT 1
0.0005s
0179: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."OGTitle", "SiteTree_Live"."OGType", "SiteTree_Live"."OGDescription", "SiteTree_Live"."BGVideoURL", "SiteTree_Live"."BGVideoType", "SiteTree_Live"."BGVideoID", "SiteTree_Live"."BGVideoStatus", "SiteTree_Live"."BGVideoDelay", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "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"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0006s
About Experience the Fraser | Experience The Fraser
About Experience The Fraser
Together, we are creating one of the world's greatest river destinations
You're invited to explore the river, Experience the Fraser, and see why it is one of the greatest river destinations in the world. The Canyon to Coast Trail, its parallel blueways, and shared cultural experiences will be one of Canada's largest active tourism networks and a catalyst for active and healthy living, climate impact reduction, and economic development. Experience the Fraser drives sustainable tourism and serves to preserve, protect, and enhance the Lower Fraser ecosystem.
A World-Class Destination
Experience The Fraser connects communities through shared stories of life along the Lower Fraser Corridor. Explore a network of trails, natural features and attractions—see why the Lower Fraser is one of the greatest river destinations in the world.
Connecting Iconic Experiences
The Canyon to Coast Trail and blueways link people to the many parks, natural features, cultural and historic sites, and recreational opportunities like sturgeon fishing along the river are abundant. Shared stories along this iconic route illustrate the cultural significance of the Lower Fraser, deepening ties between river communities.
Strengthening Connections
Experience the Fraser showcases the Lower Fraser River Corridor as one of the great river destinations of the world, strengthening our physical, emotional and spiritual connections to this beautiful region.
Bridging communities from the Hope to the Salish Sea, Experience the Fraser creates opportunity as it honours the river, its features, wildlife and people.
Experience the Fraser believes in S’ólh Téméxw te íkw’élò - Xólhmet te mekw' stám ít kwelát, which means "This is our land - We have to look after everything that belongs to us." - Halq'eméylem language, traditionally spoken by the Stó꞉lō people.
Guided by Indigenous partnerships and values, Experience the Fraser is dedicated to preserving heritage, protecting the environment and linking this outstanding suite of river attractions to opening new opportunities for sustainable recreation and business in the Lower Fraser.
The Lower Fraser's natural magnificence draws people from all over the world, generating $12.7 billion annually for BC's Tourism industry. It's a catalyst for sustainable tourism and climate impact reduction. Its historic greenways and blueways seamlessly connect our communities' culture, parks and recreation.
Let's celebrate shared heritage and culture
With your support, Experience the Fraser champions the expansion of the Canyon to Coast Trail and its connected blueways. Local stories and your input are vital to its planning. In partnership with First Nations, all levels of government, partner organizations and community members, we showcase the Lower Fraser River Corridor as one of the great river destinations of the world.
Touchpoints - A
In 2009, Experience the Fraser began as a government-funded initiative. Today, almost half of the Canyon to Coast Trail is complete. Our communities are expanding the Trail and its connected blueways to open new experiences along the Lower Fraser River Corridor.
Touchpoints - B
Touchpoints along the Trail will share stories from life on the Lower Fraser, welcoming trail users to deepen their understanding as they experience the Fraser along municipal, regional and provincial trails.
Touchpoints - C
When it is completed, it will connect 16 municipalities and many First Nations communities from the Hope to the Salish Sea. As this project embarks on its next phase of development, Partners and trail enthusiasts are invited to sign up to and shape the Experience the Fraser project; don't let your stories go untold.
Don't let your stories go untold
When it is completed, it will connect 16 municipalities and many First Nations communities from the Hope to the Salish Sea. As this project embarks on its next phase of development, Partners and trail enthusiasts are invited to sign up and shape Experience the Fraser.
This website or its third-party tools use cookies, which are necessary for its functioning and required to achieve the purposes illustrated in the cookie policy. You accept the use of cookies by closing or dismissing this notice, by clicking a link or button or by continuing to browse otherwise.