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.0005s
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.0006s
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.0004s
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.0016s
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.0008s
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.0013s
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.0006s
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.0005s
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.0004s
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.0006s
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.0005s
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.0004s
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.0004s
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.0004s
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.0004s
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.0003s
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.0003s
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.0005s
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.0007s
0026: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementVirtual_Live"."LinkedElementID", "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 "ElementVirtual_Live" ON "ElementVirtual_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0004s
0027: 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"."ID" = ?)
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0005s
0028: SELECT DISTINCT count(DISTINCT "ElementalStyleProperties"."ID") AS "Count"
FROM "ElementalStyleProperties"
WHERE ("ElementalStyleProperties"."StyleOwnerClass" IN ('RS\\Elemental\\Model\\UIElementalPageHeader'))
AND ("ElementalStyleProperties"."StyleOwnerID" = ?)
0.0004s
0029: 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.0005s
0030: 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.0008s
0031: 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
0032: 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
0033: 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.0018s
0034: 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
0035: SELECT DISTINCT count(DISTINCT "ElementalStyleProperties"."ID") AS "Count"
FROM "ElementalStyleProperties"
WHERE ("ElementalStyleProperties"."StyleOwnerClass" IN ('RS\\Elemental\\Model\\UIElementalPageHeader'))
AND ("ElementalStyleProperties"."StyleOwnerID" = ?)
0.0006s
0036: SELECT DISTINCT count(DISTINCT "UIPageHeaderContent"."ID") AS "Count"
FROM "UIPageHeaderContent"
WHERE ("UIPageHeaderContent"."PageHeaderID" = ?)
AND ("UIPageHeaderContent"."Active" = ?)
0.0003s
0037: 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
0038: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "UIElementalFeatureMaps_Live"."Content", "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 "UIElementalFeatureMaps_Live" ON "UIElementalFeatureMaps_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0004s
0039: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "UIElementalFeatureMaps_Links" ON "UIElementalFeatureMaps_Links"."LinkID" = "Link"."ID"
WHERE ("UIElementalFeatureMaps_Links"."UIElementalFeatureMapsID" = ?)
0.0003s
0040: 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.0003s
0041: 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", "LeadCapturePage_Live"."FormHeading", "LeadCapturePage_Live"."FormClass", "LeadCapturePage_Live"."FormIDOverride", "LeadCapturePage_Live"."FormFootnote", "LeadCapturePage_Live"."FormContent", "LeadCapturePage_Live"."RenderAddressFields", "LeadCapturePage_Live"."RenderTextArea", "LeadCapturePage_Live"."RenderForm", "LeadCapturePage_Live"."RenderFormHeading", "LeadCapturePage_Live"."LeadSourceID", "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" LEFT JOIN "LeadCapturePage_Live" ON "LeadCapturePage_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.0019s
0042: 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.0003s
0043: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "UIElementalCTAGroups_Live"."Content", "UIElementalCTAGroups_Live"."PageID", "UIElementalCTAGroups_Live"."ElementalAreaID", "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 "UIElementalCTAGroups_Live" ON "UIElementalCTAGroups_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0004s
0044: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "UIElementalCTAGroups_Links" ON "UIElementalCTAGroups_Links"."LinkID" = "Link"."ID"
WHERE ("UIElementalCTAGroups_Links"."UIElementalCTAGroupsID" = ?)
0.0003s
0045: 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.0002s
0046: SELECT DISTINCT count(DISTINCT "Element_Live"."ID") AS "Count"
FROM "Element_Live"
WHERE ("Element_Live"."ParentID" = ?)
0.0003s
0047: 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.0005s
0048: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "MosaicTiles_Live"."Content", "MosaicTiles_Live"."Key", "MosaicTiles_Live"."ProxyClassName", "MosaicTiles_Live"."Active", "MosaicTiles_Live"."Alternate", "MosaicTiles_Live"."AspectRatio", "MosaicTiles_Live"."Accent", "MosaicTiles_Live"."Layout", "MosaicTiles_Live"."Template", "MosaicTiles_Live"."ImageID", "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 "MosaicTiles_Live" ON "MosaicTiles_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0005s
0049: 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.0003s
0050: 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", "UIElementalCTAGroups_Live"."Content", "UIElementalCTAGroups_Live"."PageID", "UIElementalCTAGroups_Live"."ElementalAreaID", "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" LEFT JOIN "UIElementalCTAGroups_Live" ON "UIElementalCTAGroups_Live"."ID" = "Element_Live"."ID"
WHERE ("UIElementalCTAGroups_Live"."ElementalAreaID" = ?)
AND ("Element_Live"."ClassName" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0014s
0051: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "MosaicTiles_Live"."Content", "MosaicTiles_Live"."Key", "MosaicTiles_Live"."ProxyClassName", "MosaicTiles_Live"."Active", "MosaicTiles_Live"."Alternate", "MosaicTiles_Live"."AspectRatio", "MosaicTiles_Live"."Accent", "MosaicTiles_Live"."Layout", "MosaicTiles_Live"."Template", "MosaicTiles_Live"."ImageID", "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 "MosaicTiles_Live" ON "MosaicTiles_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0005s
0052: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "MosaicTiles_Live"."Content", "MosaicTiles_Live"."Key", "MosaicTiles_Live"."ProxyClassName", "MosaicTiles_Live"."Active", "MosaicTiles_Live"."Alternate", "MosaicTiles_Live"."AspectRatio", "MosaicTiles_Live"."Accent", "MosaicTiles_Live"."Layout", "MosaicTiles_Live"."Template", "MosaicTiles_Live"."ImageID", "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 "MosaicTiles_Live" ON "MosaicTiles_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0004s
0053: 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.0005s
0054: 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.0015s
0055: 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.001s
0056: 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
0057: 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.0015s
0058: 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
0059: 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
0060: 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
0061: 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
0062: 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
0063: 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
0064: 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
0065: 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
0066: 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
0067: 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
0068: 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.0003s
0069: 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.0003s
0070: 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
0071: 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
0072: 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.0006s
0073: 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
0074: 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
0075: 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.0007s
0076: 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
0077: SELECT DISTINCT count(DISTINCT "LeadSourceFields"."ID") AS "Count"
FROM "LeadSourceFields"
WHERE ("LeadSourceFields"."LeadSourceID" = ?)
0.0008s
0078: SELECT DISTINCT count(DISTINCT "LeadSources"."ID") AS "Count"
FROM "LeadSources"
WHERE ("LeadSources"."Key" = ?)
0.0006s
0079: 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
0080: 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.0006s
0081: 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
0082: 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
0083: SELECT DISTINCT count(DISTINCT "LeadSourceFields"."ID") AS "Count"
FROM "LeadSourceFields"
WHERE ("LeadSourceFields"."LeadSourceID" = ?)
0.0004s
0084: SELECT DISTINCT count(DISTINCT "LeadSources"."ID") AS "Count"
FROM "LeadSources"
WHERE ("LeadSources"."Key" = ?)
0.0005s
0085: 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
0086: 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 (24))
0.0011s
0087: 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
0088: 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
0089: 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
0090: SELECT DISTINCT count(DISTINCT "LeadSourceFields"."ID") AS "Count"
FROM "LeadSourceFields"
WHERE ("LeadSourceFields"."LeadSourceID" = ?)
0.0003s
0091: SELECT DISTINCT count(DISTINCT "LeadSources"."ID") AS "Count"
FROM "LeadSources"
WHERE ("LeadSources"."Key" = ?)
0.0003s
0092: 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
0093: 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
0094: SELECT "Version" FROM "SiteTree" WHERE "ID" = ?
0.0003s
0095: 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
0096: 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
0097: 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
0098: 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
Experience the Fraser | Trail Status Map | Experience The Fraser
Trail Status Map
The interactive map below provides an overview of the progress made to date by the communities connected by the Canyon to Coast multi-use trail. This illustrative map highlights the trail path as it winds along the Fraser River, highlighting key points of interest and projects. Explore deeper by clicking on the community icons to learn about potential projects and the status of the trail in each community.
Resources for Communities
Get in touch to learn more about the project and how you can be a part of developing one of the world's greatest river destinations.
Connect with grant and funding opportunities.
Get access to detailed maps and planning resources.
This website uses cookies
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.