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.0007s
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.001s
0007: SELECT DISTINCT "Navigation"."ClassName", "Navigation"."LastEdited", "Navigation"."Created", "Navigation"."Title", "Navigation"."Description", "Navigation"."Key", "Navigation"."ExtraCSS", "Navigation"."Active", "Navigation"."ID",
CASE WHEN "Navigation"."ClassName" IS NOT NULL THEN "Navigation"."ClassName"
ELSE 'RS\\NavBuilder\\Model\\Navigation' END AS "RecordClassName"
FROM "Navigation"
WHERE ("Navigation"."Key" = ?)
AND ("Navigation"."Active" = ?)
LIMIT 1
0.0007s
0008: SELECT DISTINCT "Navigation"."ClassName", "Navigation"."LastEdited", "Navigation"."Created", "Navigation"."Title", "Navigation"."Description", "Navigation"."Key", "Navigation"."ExtraCSS", "Navigation"."Active", "Navigation"."ID",
CASE WHEN "Navigation"."ClassName" IS NOT NULL THEN "Navigation"."ClassName"
ELSE 'RS\\NavBuilder\\Model\\Navigation' END AS "RecordClassName"
FROM "Navigation"
WHERE ("Navigation"."Key" = ?)
AND ("Navigation"."Active" = ?)
LIMIT 1
0.0006s
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.0014s
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.003s
0011: SELECT DISTINCT "Navigation_Links"."Sort", "Link"."ClassName", "Link"."LastEdited", "Link"."Created", "Link"."Anchor", "Link"."ButtonLabel", "Link"."RelOptions", "Link"."ExtraCSS", "Link"."Key", "Link"."Description", "Link"."Title", "Link"."Type", "Link"."URL", "Link"."Email", "Link"."Phone", "Link"."OpenInNewWindow", "Link"."SelectedStyle", "Link"."SiteTreeID", "Link"."ImageID", "Link"."FileID", "NavigationLinks"."RenderMultiLevel", "Link"."ID",
CASE WHEN "Link"."ClassName" IS NOT NULL THEN "Link"."ClassName"
ELSE 'gorriecoe\\Link\\Models\\Link' END AS "RecordClassName"
FROM "Link" LEFT JOIN "NavigationLinks" ON "NavigationLinks"."ID" = "Link"."ID" INNER JOIN "Navigation_Links" ON "Navigation_Links"."NavigationLinksID" = "Link"."ID"
WHERE ("Navigation_Links"."NavigationID" = ?)
AND ("Link"."ClassName" IN (?))
ORDER BY "Sort" ASC
0.0016s
0012: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."OGTitle", "SiteTree_Live"."OGType", "SiteTree_Live"."OGDescription", "SiteTree_Live"."BGVideoURL", "SiteTree_Live"."BGVideoType", "SiteTree_Live"."BGVideoID", "SiteTree_Live"."BGVideoStatus", "SiteTree_Live"."BGVideoDelay", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0008s
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.0016s
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.0011s
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.0004s
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.0019s
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.0006s
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.0007s
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.0007s
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.0006s
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.0007s
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.0008s
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.001s
0024: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0004s
0025: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "Element_Live"."AvailableGlobally", "Element_Live"."VirtualLookupTitle", "Element_Live"."ElementalInlineStyles", "Element_Live"."XS", "Element_Live"."SM", "Element_Live"."MM", "Element_Live"."LG", "Element_Live"."XL", "Element_Live"."XXL", "Element_Live"."Orientation", "Element_Live"."Gap", "Element_Live"."FocusText", "Element_Live"."Overline", "Element_Live"."TypeScale", "Element_Live"."Label", "Element_Live"."ContentPosition", "Element_Live"."ContentAlign", "Element_Live"."Compact", "Element_Live"."Elevation", "Element_Live"."DisplayOverline", "Element_Live"."DisplayContent", "Element_Live"."CollapseMarginTop", "Element_Live"."CollapseMarginBottom", "Element_Live"."Animations", "Element_Live"."DisplayLinks", "Element_Live"."Stackable", "Element_Live"."Prefetch", "Element_Live"."BlockID", "Element_Live"."Version", "Element_Live"."Title", "Element_Live"."ShowTitle", "Element_Live"."Sort", "Element_Live"."ExtraClass", "Element_Live"."Style", "Element_Live"."TopPageID", "Element_Live"."ParentID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName"
FROM "Element_Live"
WHERE ("Element_Live"."ParentID" = ?)
ORDER BY "Element_Live"."Sort" ASC
0.0009s
0026: SELECT DISTINCT count(DISTINCT "ElementalStyleProperties"."ID") AS "Count"
FROM "ElementalStyleProperties"
WHERE ("ElementalStyleProperties"."StyleOwnerClass" IN ('RS\\Elemental\\Model\\UIElementalPageHeader'))
AND ("ElementalStyleProperties"."StyleOwnerID" = ?)
0.0023s
0027: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "UIElementalPageHeader_Live"."Content", "UIElementalPageHeader_Live"."Case", "UIElementalPageHeader_Live"."Animation", "UIElementalPageHeader_Live"."Decoration", "UIElementalPageHeader_Live"."Depth", "UIElementalPageHeader_Live"."ShowUIContent", "UIElementalPageHeader_Live"."BlockTemplate", "UIElementalPageHeader_Live"."ImageID", "UIElementalPageHeader_Live"."PageID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "UIElementalPageHeader_Live" ON "UIElementalPageHeader_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0007s
0028: SELECT DISTINCT count(DISTINCT "AspectRatios"."ID") AS "Count"
FROM "AspectRatios" INNER JOIN "Element_AspectRatios" ON "Element_AspectRatios"."AspectRatiosID" = "AspectRatios"."ID"
WHERE ("Element_AspectRatios"."ElementID" = ?)
0.0033s
0029: SELECT DISTINCT "Element_AspectRatios"."Sort", "AspectRatios"."ClassName", "AspectRatios"."LastEdited", "AspectRatios"."Created", "AspectRatios"."Scale", "AspectRatios"."Ratio", "AspectRatios"."Orientation", "AspectRatios"."ID",
CASE WHEN "AspectRatios"."ClassName" IS NOT NULL THEN "AspectRatios"."ClassName"
ELSE 'RS\\Model\\AspectRatio' END AS "RecordClassName"
FROM "AspectRatios" INNER JOIN "Element_AspectRatios" ON "Element_AspectRatios"."AspectRatiosID" = "AspectRatios"."ID"
WHERE ("Element_AspectRatios"."ElementID" = ?)
ORDER BY "Sort" ASC
0.0006s
0030: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0005s
0031: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."OGTitle", "SiteTree_Live"."OGType", "SiteTree_Live"."OGDescription", "SiteTree_Live"."BGVideoURL", "SiteTree_Live"."BGVideoType", "SiteTree_Live"."BGVideoID", "SiteTree_Live"."BGVideoStatus", "SiteTree_Live"."BGVideoDelay", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "SiteTree_Live"."Title" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."Title" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."Title" ELSE NULL END AS "Title", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "SiteTree_Live"."SearchContent" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."SearchContent" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."SearchContent" ELSE NULL END AS "SearchContent", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "SiteTree_Live"."Keywords" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."Keywords" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."Keywords" ELSE NULL END AS "Keywords", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "SiteTree_Live"."ShowInSearch" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."ShowInSearch" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."ShowInSearch" ELSE NULL END AS "ShowInSearch", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "SiteTree_Live"."Weight" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."Weight" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'CommunityPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'TaxonomyPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."Weight" ELSE NULL END AS "Weight", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "SiteTree_Live"."ParentID", "Page_Live"."SSLayoutTemplate", "Page_Live"."SSLayoutClasses", "ElementalPage_Live"."ElementalAreaID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "ElementalPage_Live" ON "ElementalPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("ElementalPage_Live"."ElementalAreaID" = ?)
AND ("SiteTree_Live"."ClassName" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0035s
0032: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0008s
0033: SELECT DISTINCT count(DISTINCT "ElementalStyleProperties"."ID") AS "Count"
FROM "ElementalStyleProperties"
WHERE ("ElementalStyleProperties"."StyleOwnerClass" IN ('RS\\Elemental\\Model\\UIElementalPageHeader'))
AND ("ElementalStyleProperties"."StyleOwnerID" = ?)
0.0009s
0034: SELECT DISTINCT count(DISTINCT "UIPageHeaderContent"."ID") AS "Count"
FROM "UIPageHeaderContent"
WHERE ("UIPageHeaderContent"."PageHeaderID" = ?)
AND ("UIPageHeaderContent"."Active" = ?)
0.0006s
0035: SELECT DISTINCT count(DISTINCT "ElementalStyleProperties"."ID") AS "Count"
FROM "ElementalStyleProperties"
WHERE ("ElementalStyleProperties"."StyleOwnerClass" IN ('RS\\Elemental\\Model\\UIElementalContent'))
AND ("ElementalStyleProperties"."StyleOwnerID" = ?)
0.0005s
0036: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0005s
0037: SELECT DISTINCT count(DISTINCT "ElementalStyleProperties"."ID") AS "Count"
FROM "ElementalStyleProperties"
WHERE ("ElementalStyleProperties"."StyleOwnerClass" IN ('RS\\Elemental\\Model\\UIElementalContent'))
AND ("ElementalStyleProperties"."StyleOwnerID" = ?)
0.0004s
0038: SELECT DISTINCT count(DISTINCT "AspectRatios"."ID") AS "Count"
FROM "AspectRatios" INNER JOIN "Element_AspectRatios" ON "Element_AspectRatios"."AspectRatiosID" = "AspectRatios"."ID"
WHERE ("Element_AspectRatios"."ElementID" = ?)
0.0004s
0039: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE WHEN "Element_Live"."ClassName" IN ('DNADesign\\Elemental\\Models\\BaseElement', 'RS\\Elemental\\Model\\MosaicTile', 'RS\\Model\\TemplateTile', 'RS\\Model\\Tile', 'RS\\Elemental\\Model\\UIElementalBanner', 'RS\\Elemental\\Model\\UIElementalBlogPostList', 'RS\\Elemental\\Model\\UIElementalCTAGroup', 'RS\\Elemental\\Model\\UIElementalCarousel', 'RS\\Elemental\\Model\\UIElementalColumn', 'RS\\Elemental\\Model\\UIElementalCommunityStats', 'RS\\Elemental\\Model\\UIElementalContent', 'RS\\Elemental\\Model\\UIElementalContentGroup', 'RS\\Elemental\\Model\\UIElementalCrowdriff', 'RS\\Elemental\\Model\\UIElementalFeatureBlock', 'RS\\Elemental\\Model\\UIElementalFeatureMap', 'RS\\Elemental\\Model\\UIElementalFeaturedGrid', 'RS\\Elemental\\Model\\UIElementalGallery', 'RS\\Elemental\\Model\\UIElementalGrid', 'RS\\Elemental\\Model\\UIElementalLocomotiveSection', 'RS\\Elemental\\Model\\UIElementalLogoGarden', 'RS\\Elemental\\Model\\UIElementalMosaic', 'RS\\Elemental\\Model\\UIElementalPageHeader', 'RS\\Elemental\\Model\\UIElementalPartnerList', 'RS\\Elemental\\Model\\UIElementalPartnerMap', 'RS\\Elemental\\Model\\UIElementalRepeater', 'RS\\Elemental\\Model\\UIElementalSlide', 'RS\\Elemental\\Model\\UIElementalSpacer', 'RS\\Elemental\\Model\\UIElementalTimeline', 'RS\\Elemental\\Model\\UIElementalTriptych', 'DNADesign\\Elemental\\Models\\ElementContent', 'DNADesign\\ElementalList\\Model\\ElementList', 'DNADesign\\ElementalVirtual\\Model\\ElementVirtual') THEN "Element_Live"."TypeScale" WHEN "Element_Live"."ClassName" IN ('RS\\Elemental\\Model\\UIElementalContent') THEN "UIElementalContent_Live"."TypeScale" WHEN "Element_Live"."ClassName" IN ('RS\\Elemental\\Model\\UIElementalContent') THEN "UIElementalContent_Live"."TypeScale" ELSE NULL END AS "TypeScale", "UIElementalContent_Live"."Subtitle", "UIElementalContent_Live"."Content", "UIElementalContent_Live"."Columns", "UIElementalContent_Live"."PageID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "UIElementalContent_Live" ON "UIElementalContent_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0005s
0040: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "UIElementalContent_Buttons" ON "UIElementalContent_Buttons"."LinkID" = "Link"."ID"
WHERE ("UIElementalContent_Buttons"."UIElementalContentID" = ?)
0.0003s
0041: SELECT DISTINCT count(DISTINCT "ElementalStyleProperties"."ID") AS "Count"
FROM "ElementalStyleProperties"
WHERE ("ElementalStyleProperties"."StyleOwnerClass" IN ('RS\\Elemental\\Model\\UIElementalTimeline'))
AND ("ElementalStyleProperties"."StyleOwnerID" = ?)
0.0004s
0042: 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.0023s
0043: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "UIElementalTimelines_Live"."SlidesToShow", "UIElementalTimelines_Live"."SlidesToScroll", "UIElementalTimelines_Live"."ScrollLock", "UIElementalTimelines_Live"."ScrollLockDelay", "UIElementalTimelines_Live"."ResizeLock", "UIElementalTimelines_Live"."ScrollPropagate", "UIElementalTimelines_Live"."EventPropagate", "UIElementalTimelines_Live"."AutoplayDelay", "UIElementalTimelines_Live"."Autoplay", "UIElementalTimelines_Live"."Loop", "UIElementalTimelines_Live"."Draggable", "UIElementalTimelines_Live"."DragVelocity", "UIElementalTimelines_Live"."ItemWidth", "UIElementalTimelines_Live"."ExactWidth", "UIElementalTimelines_Live"."Duration", "UIElementalTimelines_Live"."Dots", "UIElementalTimelines_Live"."ArrowsPrev", "UIElementalTimelines_Live"."ArrowsNext", "UIElementalTimelines_Live"."Controls", "UIElementalTimelines_Live"."Effect", "UIElementalTimelines_Live"."Content", "UIElementalTimelines_Live"."Mode", "UIElementalTimelines_Live"."Sorting", "UIElementalTimelines_Live"."ShowStart", "UIElementalTimelines_Live"."ShowEnd", "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 "UIElementalTimelines_Live" ON "UIElementalTimelines_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0006s
0044: SELECT DISTINCT count(DISTINCT "TimelineEvents"."ID") AS "Count"
FROM "TimelineEvents"
WHERE ("TimelineEvents"."Active" = ?)
0.0004s
0045: SELECT DISTINCT count(DISTINCT "File_Live"."ID") AS "Count"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "UIElementalTimelines_Images" ON "UIElementalTimelines_Images"."ImageID" = "File_Live"."ID"
WHERE ("UIElementalTimelines_Images"."UIElementalTimelinesID" = ?)
AND ("File_Live"."ClassName" IN (?))
0.0005s
0046: SELECT DISTINCT "UIElementalTimelines_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "UIElementalTimelines_Images" ON "UIElementalTimelines_Images"."ImageID" = "File_Live"."ID"
WHERE ("UIElementalTimelines_Images"."UIElementalTimelinesID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0013s
0047: SELECT DISTINCT "UIElementalTimelines_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "UIElementalTimelines_Images" ON "UIElementalTimelines_Images"."ImageID" = "File_Live"."ID"
WHERE ("UIElementalTimelines_Images"."UIElementalTimelinesID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0017s
0048: SELECT DISTINCT count(DISTINCT "File_Live"."ID") AS "Count"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "UIElementalTimelines_Images" ON "UIElementalTimelines_Images"."ImageID" = "File_Live"."ID"
WHERE ("UIElementalTimelines_Images"."UIElementalTimelinesID" = ?)
AND ("File_Live"."ClassName" IN (?))
0.0009s
0049: SELECT DISTINCT "UIElementalTimelines_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "UIElementalTimelines_Images" ON "UIElementalTimelines_Images"."ImageID" = "File_Live"."ID"
WHERE ("UIElementalTimelines_Images"."UIElementalTimelinesID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1 OFFSET 1
0.0017s
0050: SELECT DISTINCT count(DISTINCT "TimelineEvents"."ID") AS "Count"
FROM "TimelineEvents"
WHERE ("TimelineEvents"."Active" = ?)
0.0003s
0051: SELECT DISTINCT "TimelineEvents"."ClassName", "TimelineEvents"."LastEdited", "TimelineEvents"."Created", "TimelineEvents"."Title", "TimelineEvents"."URLSegment", "TimelineEvents"."Content", "TimelineEvents"."Summary", "TimelineEvents"."PeriodStart", "TimelineEvents"."PeriodEnd", "TimelineEvents"."Active", "TimelineEvents"."AspectRatio", "TimelineEvents"."ShowTitle", "TimelineEvents"."ShowImage", "TimelineEvents"."ID",
CASE WHEN "TimelineEvents"."ClassName" IS NOT NULL THEN "TimelineEvents"."ClassName"
ELSE 'TimelineEvent' END AS "RecordClassName"
FROM "TimelineEvents"
WHERE ("TimelineEvents"."Active" = ?)
ORDER BY "TimelineEvents"."PeriodStart" DESC
0.0007s
0052: SELECT DISTINCT "TimelineEvents_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "TimelineEvents_Images" ON "TimelineEvents_Images"."ImageID" = "File_Live"."ID"
WHERE ("TimelineEvents_Images"."TimelineEventsID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0016s
0053: SELECT DISTINCT "TimelineEvents_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "TimelineEvents_Images" ON "TimelineEvents_Images"."ImageID" = "File_Live"."ID"
WHERE ("TimelineEvents_Images"."TimelineEventsID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0065s
0054: SELECT DISTINCT "TimelineEvents_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "TimelineEvents_Images" ON "TimelineEvents_Images"."ImageID" = "File_Live"."ID"
WHERE ("TimelineEvents_Images"."TimelineEventsID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0094s
0055: SELECT DISTINCT "TimelineEvents_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "TimelineEvents_Images" ON "TimelineEvents_Images"."ImageID" = "File_Live"."ID"
WHERE ("TimelineEvents_Images"."TimelineEventsID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0014s
0056: SELECT DISTINCT "TimelineEvents_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "TimelineEvents_Images" ON "TimelineEvents_Images"."ImageID" = "File_Live"."ID"
WHERE ("TimelineEvents_Images"."TimelineEventsID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0018s
0057: SELECT DISTINCT "TimelineEvents_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "TimelineEvents_Images" ON "TimelineEvents_Images"."ImageID" = "File_Live"."ID"
WHERE ("TimelineEvents_Images"."TimelineEventsID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0017s
0058: SELECT DISTINCT "TimelineEvents_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "TimelineEvents_Images" ON "TimelineEvents_Images"."ImageID" = "File_Live"."ID"
WHERE ("TimelineEvents_Images"."TimelineEventsID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.002s
0059: SELECT DISTINCT "TimelineEvents_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "TimelineEvents_Images" ON "TimelineEvents_Images"."ImageID" = "File_Live"."ID"
WHERE ("TimelineEvents_Images"."TimelineEventsID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0021s
0060: SELECT DISTINCT "TimelineEvents_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "TimelineEvents_Images" ON "TimelineEvents_Images"."ImageID" = "File_Live"."ID"
WHERE ("TimelineEvents_Images"."TimelineEventsID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0015s
0061: SELECT DISTINCT "TimelineEvents_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "TimelineEvents_Images" ON "TimelineEvents_Images"."ImageID" = "File_Live"."ID"
WHERE ("TimelineEvents_Images"."TimelineEventsID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0047s
0062: 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.0007s
0063: 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.0019s
0064: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."ColorData", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0008s
0065: 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
0066: 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
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.0007s
0068: 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.0007s
0069: 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.0016s
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 "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
0072: 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.002s
0073: 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.0012s
0074: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."OGTitle", "SiteTree_Live"."OGType", "SiteTree_Live"."OGDescription", "SiteTree_Live"."BGVideoURL", "SiteTree_Live"."BGVideoType", "SiteTree_Live"."BGVideoID", "SiteTree_Live"."BGVideoStatus", "SiteTree_Live"."BGVideoDelay", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0019s
0075: 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
0076: 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
0077: 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
0078: 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
0079: 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
0080: 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
0081: 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.0009s
0082: 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.0007s
0083: 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.0019s
0084: 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
0085: 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
0086: SELECT DISTINCT count(DISTINCT "LeadSourceFields"."ID") AS "Count"
FROM "LeadSourceFields"
WHERE ("LeadSourceFields"."LeadSourceID" = ?)
0.0004s
0087: SELECT DISTINCT count(DISTINCT "LeadSources"."ID") AS "Count"
FROM "LeadSources"
WHERE ("LeadSources"."Key" = ?)
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"."Key" = ?)
LIMIT 1
0.0004s
0089: 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.0007s
0090: SELECT DISTINCT "LeadSources"."ClassName", "LeadSources"."LastEdited", "LeadSources"."Created", "LeadSources"."Title", "LeadSources"."Key", "LeadSources"."ListID", "LeadSources"."SendNotifications", "LeadSources"."ForceEmailThreading", "LeadSources"."FormHeading", "LeadSources"."FormClass", "LeadSources"."FormIDOverride", "LeadSources"."FormFootnote", "LeadSources"."FormContent", "LeadSources"."FormSubmitLabel", "LeadSources"."FormMessageLabel", "LeadSources"."RenderAddressFields", "LeadSources"."RenderPhoneField", "LeadSources"."RenderTextArea", "LeadSources"."EventCategory", "LeadSources"."EventAction", "LeadSources"."EventLabel", "LeadSources"."RenderForm", "LeadSources"."RenderFormHeading", "LeadSources"."RenderSiteWide", "LeadSources"."ImplicitOptIn", "LeadSources"."SortOrder", "LeadSources"."ContentID", "LeadSources"."ID",
CASE WHEN "LeadSources"."ClassName" IS NOT NULL THEN "LeadSources"."ClassName"
ELSE 'RS\\Model\\LeadSource' END AS "RecordClassName"
FROM "LeadSources"
WHERE ("LeadSources"."ID" = ?)
LIMIT 1
0.0005s
0091: 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
0092: SELECT DISTINCT count(DISTINCT "LeadSourceFields"."ID") AS "Count"
FROM "LeadSourceFields"
WHERE ("LeadSourceFields"."LeadSourceID" = ?)
0.0003s
0093: SELECT DISTINCT count(DISTINCT "LeadSources"."ID") AS "Count"
FROM "LeadSources"
WHERE ("LeadSources"."Key" = ?)
0.0003s
0094: 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
0095: 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 (23))
0.0012s
0096: 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
0097: 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
0098: 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
0099: SELECT DISTINCT count(DISTINCT "LeadSourceFields"."ID") AS "Count"
FROM "LeadSourceFields"
WHERE ("LeadSourceFields"."LeadSourceID" = ?)
0.0004s
0100: SELECT DISTINCT count(DISTINCT "LeadSources"."ID") AS "Count"
FROM "LeadSources"
WHERE ("LeadSources"."Key" = ?)
0.0003s
0101: 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
0102: 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
0103: SELECT "Version" FROM "SiteTree" WHERE "ID" = ?
0.0006s
0104: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."OGTitle", "SiteTree_Live"."OGType", "SiteTree_Live"."OGDescription", "SiteTree_Live"."BGVideoURL", "SiteTree_Live"."BGVideoType", "SiteTree_Live"."BGVideoID", "SiteTree_Live"."BGVideoStatus", "SiteTree_Live"."BGVideoDelay", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0007s
0105: 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
0106: 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
0107: 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
Project Timeline | Experience The Fraser
Project Timeline
Over a Decade in The Making
The timeline below contains information about the Experience the Fraser’s development over time. It is an exhaustive list, but rather examples of various infrastructure projects, planning, and grant-funded implementation projects since the initiative began.
2026-01Fraser River Tunnel Project Underway
The Fraser River Tunnel Project will introduce a new eight-lane, immersed tube tunnel that replaces the existing George Massey Tunnel on Highway 99. When it opens in 2030, the new tunnel will feature a separated active transportation corridor for cyclists and pedestrians, providing a vital link between Delta and Richmond on the ETF route. Learn more
2025-01Tourism Abbotsford and University of the Fraser Valley Focus on ETF Planning
Tourism Abbotsford partnered with the University of the Fraser Valley (UFV) on an ETF project honouring Abbotsford’s most precious resource—the Fraser River. UFV students conducted projects in urban design and Indigenous storytelling, and gathered community perspectives on the river. Project ideas were presented to the City of Abbotsford for future consideration as the ETF route is developed within the city. Learn more
2025-01Pattullo Bridge Replacement to Open in 2025
The Pattullo Bridge is a key connection between the communities of Surrey and New Westminster along the ETF route. In 2025, the Pattullo will be replaced with a new four-lane, toll-free bridge that provides important improvements for all users, including drivers, cyclists, and pedestrians, as well as the surrounding communities. In the draft terms of reference for rebuilding the Pattullo Bridge, Metro Vancouver ensured a reference to the ETF route and the need to maintain strong connections for pedestrians and cyclists. Learn more
2023-01City of Mission Secures $50,000 in Federal Active Transportation Funding for ETF Planning
The City of Mission received $50,000 in federal active transportation funding to plan and design a key portion of the ETF trail. Funding will guide the construction of a trail segment from Duncan/Gill Avenue to Dyke Road, near the Fraser River and future residential growth areas. This project will bring Mission and other partners one step closer to completing the full ETF trail network. Learn more
2023-01Maple Ridge Purchases Land on the Fraser River Waterfront
In 2023, the City of Maple Ridge acquired 4.28 acres of land on the Fraser River waterfront. The City plans to construct a multi-use pathway that will connect two popular locations within the community - the Port Haney Wharf and Kanaka Creek Regional Park. The new path will be integrated into the ETF route. Learn more
2023-01Coquitlam Plans Riverfront Development
The new Fraser Mills development, located along the banks of the Fraser River in South Coquitlam, will be the city’s first and only waterfront community. When complete, this 96-acre neighbourhood will be home to a collection of residences, restaurants, shops, extensive green space, plazas, and a riverfront access for the ETF route. Learn more
2022-01Entire ETF Route Mapped and Inventoried
In 2022, the ETF route was comprehensively mapped and photographed—an effort that produced detailed summaries for each community. These summaries outline any existing wayfinding, propose new wayfinding locations, and outline potential projects to improve the quality and user experience of the route. Meetings with municipal partners are ongoing. Learn more
2022-01Fraser River Discovery Centre Society Expands Cultural Offerings with $150,000 in Tourism Relief Funding
The Fraser River Discovery Centre Society received $150,000 in Tourism Relief Funding to expand its offerings. These new initiatives include Indigenous events and exhibits that tell the story of the Fraser River from Indigenous perspectives. As part of this approach, the Society will develop a Place of Learning that focuses on Indigenous heritage and teachings of the Fraser River. The project will be developed in coordination with the Musqueam Indian Band and, through them, other Fraser River First Nations. Learn more
2022-01Mission Completes Waterfront Revitalization Master Plan
In 2022, the City of Mission completed the Mission Waterfront Revitalization Master Plan, which outlines plans for a riverfront trail that will be part of the ETF route. Learn more
2021-01$350,000 in Provincial Funding Expands ETF Infrastructure
The ETF received $350,000 through Targeted Regional Tourism Development Initiative (TRTDI) funding to support additional infrastructure projects. The funding helped to complete Chilliwack’s 36-kilometre section of the ETF route, including trail upgrades, wayfinding, and cultural kiosks with local Indigenous cultural interpretation. Learn more
2021-01Maple Ridge Receives $50,000 in Federal Active Transportation Funding for ETF Multi-Use Pathway Planning
The City of Maple Ridge secured $50,000 in federal active transportation funding to complete the assessment and design of a multi-use pathway on the ETF route. The pathway will connect Maple Ridge’s historic Port Haney Wharf to Metro Vancouver’s Kanaka Creek Regional Park, along the north side of the Fraser River. Learn more here and here
2019-01ETF Implementation Prioritized in Fraser Valley and Metro Vancouver Destination Development Strategies
In 2019, Destination BC completed the Fraser Valley and Metro Vancouver Destination Development Strategies. The ETF was prioritized as a strategy for implementation in both documents. Learn more
2015-01New Port Mann Bridge Multi-Use Path Opens
The Port Mann/Highway 1 improvement project reached a major milestone on July 1, 2015 with the opening of a protected path for walking and cycling. The three-metre-wide, multi-use path connects Surrey and Coquitlam, serving as a vital link for cyclists and pedestrians along the ETF route.
2015-01 to 2015-12$685,000 in Provincial Funding Expands the ETF Network
The Provincial Job Creation Partnership Program supported the Experience the Fraser projects between 2015 and 2019 totalling $1.5M.
In 2015, $320,000 and $335,000 grants were received for Experience the Fraser projects, including Regional Park amenities. For example, in Chilliwack, an eight-kilometres stretch of the dyke between Jesperson Road. Additionally, three gates were installed to provide walkers, cyclists and horseback riders with access to the ETF trail.
Job Creation Partnership Program participants were selected with the help of WorkBC Employment Services Centres.
2015-01 to 2019-01$868,000 in Provincial Funding Expands the ETF Network
The Provincial Job Creation Partnership Program supported the Experience the Fraser projects between 2015 and 2019 totalling $1.5M.
In 2018, a $482,942 grant was leveraged with partners from the Island 22 Equestrian Park Society, and the Freshwater Fishers Society of BC for capital improvements in regional parks.
In 2019, and additional $385,215 grant was received for projects including Experience the Fraser wayfinding signs in the Matsqui Trail Regional Park (Abbotsford), trail enhancements at Sumas Mountain Regional Park (Abbotsford), park lot improvements at Neilson Regional Park (Mission), boat launch staging area improvements at Island 22 Regional Park (Chilliwack) and a universally accessible viewing platform at the Cheam Lake Wetlands Regional Park (Electoral Area D).
Job Creation Partnership Program participants were selected with the help of WorkBC Employment Services Centres. Learn more here and here
2012-01Province of BC Signs MOU with Metro Vancouver and Fraser Valley Regional District
In 2012, the Province of BC signed a Memorandum of Understanding (MOU) with the Greater Vancouver Regional District (Metro Vancouver) and the Fraser Valley Regional District.
The MOU outlined the project goals of advancing the development of a world-class recreation, heritage and cultural assets along the Lower Fraser River, which will be showcased as a visitor destination.
FVRD and MV jointly developed a Concept Plan and Implementation Plan that identify trails and blueway routes, implementation strategies, and actions to achieve the ultimate goal of creating a world-class destination. Learn more
2012-01$1 Million in Provincial Funding Supports Parks and Trails along ETF Route
In 2012, the Province allocated $1 million to support parks, trails, and experiences that enhance the ETF initiative. One example of a project made possible by this funding is an ETF exhibit at the Fraser River Discovery Centre in New Westminster, as well as an interpretive panel on the pier. Learn more
2012-01Surrey Bend Regional Park Opens
In 2012, the City of Surrey began the process of developing a 12-acre ecological park along the Fraser River to support the ETF project. Located on forested land in Parsons Channel, Surrey Bend Regional Park features two fish-bearing creeks and viewpoints overlooking the river. It officially opened in 2016. Learn more
2009-04Province of BC Allocates $2.5 Million for Experience the Fraser (ETF) Project
In 2009, the Province of BC, through the Ministry of Tourism, Arts, Culture and Sport, provided $1.25 million each to Metro Vancouver (MV) and the Fraser Valley Regional District (FVRD) to initiate the development of a regional trail network, river-based infrastructure, and heritage features throughout the Lower Fraser River Corridor. Learn more
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.