0001: SET sql_mode = ?
0.0003s
0002: SHOW DATABASES LIKE 'etf\_dev'
0.0005s
0003: SET SESSION sql_mode='REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE';
0.0001s
0004: SHOW FULL TABLES WHERE Table_Type != 'VIEW'
0.0015s
0005: 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
0006: 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"."LayoutTools", "SiteConfig"."Title", "SiteConfig"."Tagline", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."LayoutDefaultImageID", "SiteConfig"."ID",
CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName"
ELSE 'SilverStripe\\SiteConfig\\SiteConfig' END AS "RecordClassName"
FROM "SiteConfig"
LIMIT 1
0.0005s
0007: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', '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', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_Live"."SSLayoutClasses" WHEN "SiteTree_Live"."ClassName" IN ('CookiePolicyPage') THEN "CookiePolicyPage_Live"."SSLayoutClasses" ELSE NULL END AS "SSLayoutClasses", "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.0007s
0008: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "LocomotivePage_Live"."ProgressBar", "LocomotivePage_Live"."Mobile", "LocomotivePage_Live"."Tablet", "LocomotivePage_Live"."ReloadOnContextChange", "LocomotivePage_Live"."TouchMultiplier", "LocomotivePage_Live"."Multiplier", "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" LEFT JOIN "LocomotivePage_Live" ON "LocomotivePage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0008s
0009: 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
0010: SELECT DISTINCT "Navigation"."ClassName", "Navigation"."LastEdited", "Navigation"."Created", "Navigation"."Title", "Navigation"."Description", "Navigation"."Key", "Navigation"."ExtraCSS", "Navigation"."Active", "Navigation"."ID",
CASE WHEN "Navigation"."ClassName" IS NOT NULL THEN "Navigation"."ClassName"
ELSE 'RS\\NavBuilder\\Model\\Navigation' END AS "RecordClassName"
FROM "Navigation"
WHERE ("Navigation"."Key" = ?)
AND ("Navigation"."Active" = ?)
LIMIT 1
0.0003s
0011: 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.0015s
0012: 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.0005s
0013: 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.001s
0014: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."OGTitle", "SiteTree_Live"."OGType", "SiteTree_Live"."OGDescription", "SiteTree_Live"."BGVideoURL", "SiteTree_Live"."BGVideoType", "SiteTree_Live"."BGVideoID", "SiteTree_Live"."BGVideoStatus", "SiteTree_Live"."BGVideoDelay", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0006s
0015: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" LEFT JOIN "NavigationLinks" ON "NavigationLinks"."ID" = "Link"."ID" INNER JOIN "NavigationLinks_Links" ON "NavigationLinks_Links"."ChildID" = "Link"."ID"
WHERE ("NavigationLinks_Links"."NavigationLinksID" = ?)
AND ("Link"."ClassName" IN (?))
0.0006s
0016: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."OGTitle", "SiteTree_Live"."OGType", "SiteTree_Live"."OGDescription", "SiteTree_Live"."BGVideoURL", "SiteTree_Live"."BGVideoType", "SiteTree_Live"."BGVideoID", "SiteTree_Live"."BGVideoStatus", "SiteTree_Live"."BGVideoDelay", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0005s
0017: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" LEFT JOIN "NavigationLinks" ON "NavigationLinks"."ID" = "Link"."ID" INNER JOIN "NavigationLinks_Links" ON "NavigationLinks_Links"."ChildID" = "Link"."ID"
WHERE ("NavigationLinks_Links"."NavigationLinksID" = ?)
AND ("Link"."ClassName" IN (?))
0.0006s
0018: SELECT DISTINCT count(DISTINCT "Social"."ID") AS "Count"
FROM "Social"
WHERE ("SocialOwnerClass" IN ('SilverStripe\\SiteConfig\\SiteConfig'))
AND ("Social"."SocialOwnerID" = ?)
0.0009s
0019: SELECT DISTINCT "Social"."ClassName", "Social"."LastEdited", "Social"."Created", "Social"."Network", "Social"."URL", "Social"."SortOrder", "Social"."SocialOwnerID", "Social"."SocialOwnerClass", "Social"."ID",
CASE WHEN "Social"."ClassName" IS NOT NULL THEN "Social"."ClassName"
ELSE 'RS\\Model\\Social' END AS "RecordClassName"
FROM "Social"
WHERE ("SocialOwnerClass" IN ('SilverStripe\\SiteConfig\\SiteConfig'))
AND ("Social"."SocialOwnerID" = ?)
ORDER BY "Social"."SortOrder" ASC
0.0008s
0020: 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", "Page_Live"."SSLayoutTemplate", "Page_Live"."SSLayoutClasses", "ElementalPage_Live"."ElementalAreaID", "LeadCapturePage_Live"."FormHeading", "LeadCapturePage_Live"."FormClass", "LeadCapturePage_Live"."FormIDOverride", "LeadCapturePage_Live"."FormFootnote", "LeadCapturePage_Live"."FormContent", "LeadCapturePage_Live"."RenderAddressFields", "LeadCapturePage_Live"."RenderTextArea", "LeadCapturePage_Live"."RenderForm", "LeadCapturePage_Live"."RenderFormHeading", "LeadCapturePage_Live"."LeadSourceID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "ElementalPage_Live" ON "ElementalPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "LeadCapturePage_Live" ON "LeadCapturePage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0019s
0021: 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", "Page_Live"."SSLayoutTemplate", "Page_Live"."SSLayoutClasses", "ElementalPage_Live"."ElementalAreaID", "LeadCapturePage_Live"."FormHeading", "LeadCapturePage_Live"."FormClass", "LeadCapturePage_Live"."FormIDOverride", "LeadCapturePage_Live"."FormFootnote", "LeadCapturePage_Live"."FormContent", "LeadCapturePage_Live"."RenderAddressFields", "LeadCapturePage_Live"."RenderTextArea", "LeadCapturePage_Live"."RenderForm", "LeadCapturePage_Live"."RenderFormHeading", "LeadCapturePage_Live"."LeadSourceID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "ElementalPage_Live" ON "ElementalPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "LeadCapturePage_Live" ON "LeadCapturePage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.002s
0022: 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", "Page_Live"."SSLayoutTemplate", "Page_Live"."SSLayoutClasses", "ElementalPage_Live"."ElementalAreaID", "LeadCapturePage_Live"."FormHeading", "LeadCapturePage_Live"."FormClass", "LeadCapturePage_Live"."FormIDOverride", "LeadCapturePage_Live"."FormFootnote", "LeadCapturePage_Live"."FormContent", "LeadCapturePage_Live"."RenderAddressFields", "LeadCapturePage_Live"."RenderTextArea", "LeadCapturePage_Live"."RenderForm", "LeadCapturePage_Live"."RenderFormHeading", "LeadCapturePage_Live"."LeadSourceID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "ElementalPage_Live" ON "ElementalPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "LeadCapturePage_Live" ON "LeadCapturePage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0017s
0023: SELECT DISTINCT "Navigation"."ClassName", "Navigation"."LastEdited", "Navigation"."Created", "Navigation"."Title", "Navigation"."Description", "Navigation"."Key", "Navigation"."ExtraCSS", "Navigation"."Active", "Navigation"."ID",
CASE WHEN "Navigation"."ClassName" IS NOT NULL THEN "Navigation"."ClassName"
ELSE 'RS\\NavBuilder\\Model\\Navigation' END AS "RecordClassName"
FROM "Navigation"
WHERE ("Navigation"."Key" = ?)
AND ("Navigation"."Active" = ?)
LIMIT 1
0.0004s
0024: 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"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0006s
0025: 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
0026: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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", "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.0004s
0027: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0003s
0028: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "Element_Live"."AvailableGlobally", "Element_Live"."ElementalInlineStyles", "Element_Live"."FocusText", "Element_Live"."Label", "Element_Live"."ContentPosition", "Element_Live"."ContentAlign", "Element_Live"."Compact", "Element_Live"."Elevation", "Element_Live"."DisplayContent", "Element_Live"."CollapseMarginTop", "Element_Live"."CollapseMarginBottom", "Element_Live"."Animations", "Element_Live"."DisplayLinks", "Element_Live"."Stackable", "Element_Live"."Version", "Element_Live"."Title", "Element_Live"."ShowTitle", "Element_Live"."Sort", "Element_Live"."ExtraClass", "Element_Live"."Style", "Element_Live"."TopPageID", "Element_Live"."ParentID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName"
FROM "Element_Live"
WHERE ("Element_Live"."ParentID" = ?)
ORDER BY "Element_Live"."Sort" ASC
0.0007s
0029: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "Element_Live"."AvailableGlobally", "Element_Live"."ElementalInlineStyles", "Element_Live"."FocusText", "Element_Live"."Label", "Element_Live"."ContentPosition", "Element_Live"."ContentAlign", "Element_Live"."Compact", "Element_Live"."Elevation", "Element_Live"."DisplayContent", "Element_Live"."CollapseMarginTop", "Element_Live"."CollapseMarginBottom", "Element_Live"."Animations", "Element_Live"."DisplayLinks", "Element_Live"."Stackable", "Element_Live"."Version", "Element_Live"."Title", "Element_Live"."ShowTitle", "Element_Live"."Sort", "Element_Live"."ExtraClass", "Element_Live"."Style", "Element_Live"."TopPageID", "Element_Live"."ParentID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName"
FROM "Element_Live"
WHERE ("Element_Live"."ParentID" = ?)
ORDER BY "Element_Live"."Sort" ASC
0.0007s
0030: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0003s
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", "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", "Page_Live"."SSLayoutTemplate", "Page_Live"."SSLayoutClasses", "ElementalPage_Live"."ElementalAreaID", "LocomotivePage_Live"."ProgressBar", "LocomotivePage_Live"."Mobile", "LocomotivePage_Live"."Tablet", "LocomotivePage_Live"."ReloadOnContextChange", "LocomotivePage_Live"."TouchMultiplier", "LocomotivePage_Live"."Multiplier", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "ElementalPage_Live" ON "ElementalPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "LocomotivePage_Live" ON "LocomotivePage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("ElementalPage_Live"."ElementalAreaID" = ?)
AND ("SiteTree_Live"."ClassName" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.002s
0032: SELECT DISTINCT count(DISTINCT "ElementalStyleProperties"."ID") AS "Count"
FROM "ElementalStyleProperties"
WHERE ("StyleOwnerClass" IN ('RS\\Elemental\\Model\\UIElementalPageHeader'))
AND ("ElementalStyleProperties"."StyleOwnerID" = ?)
0.0005s
0033: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE WHEN "Element_Live"."ClassName" IN ('DNADesign\\Elemental\\Models\\BaseElement', 'RS\\Elemental\\Model\\UIElementalBanner', 'RS\\Elemental\\Model\\UIElementalBlogPostList', 'RS\\Elemental\\Model\\UIElementalCTAGroup', 'RS\\Elemental\\Model\\UIElementalCarousel', 'RS\\Elemental\\Model\\UIElementalColumn', 'RS\\Elemental\\Model\\UIElementalContent', 'RS\\Elemental\\Model\\UIElementalContentGroup', 'RS\\Elemental\\Model\\UIElementalFeatureBlock', 'RS\\Elemental\\Model\\UIElementalFeaturedGrid', 'RS\\Elemental\\Model\\UIElementalGallery', 'RS\\Elemental\\Model\\UIElementalGrid', 'RS\\Elemental\\Model\\UIElementalLocomotiveSection', 'RS\\Elemental\\Model\\UIElementalLogoGarden', 'RS\\Elemental\\Model\\UIElementalPageHeader', '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"."ContentPosition" WHEN "Element_Live"."ClassName" IN ('RS\\Elemental\\Model\\UIElementalPageHeader') THEN "UIElementalPageHeader_Live"."ContentPosition" WHEN "Element_Live"."ClassName" IN ('RS\\Elemental\\Model\\UIElementalPageHeader') THEN "UIElementalPageHeader_Live"."ContentPosition" ELSE NULL END AS "ContentPosition", "UIElementalPageHeader_Live"."Content", "UIElementalPageHeader_Live"."Target", "UIElementalPageHeader_Live"."URL", "UIElementalPageHeader_Live"."LinkLabel", "UIElementalPageHeader_Live"."BlockTemplate", "UIElementalPageHeader_Live"."Size", "UIElementalPageHeader_Live"."Case", "UIElementalPageHeader_Live"."Animation", "UIElementalPageHeader_Live"."Flare", "UIElementalPageHeader_Live"."Depth", "UIElementalPageHeader_Live"."Alignment", "UIElementalPageHeader_Live"."AlignContent", "UIElementalPageHeader_Live"."Advanced", "UIElementalPageHeader_Live"."ShowUIContent", "UIElementalPageHeader_Live"."ImageID", "UIElementalPageHeader_Live"."PageID", CASE WHEN "Element_Live"."ClassName" IN ('DNADesign\\Elemental\\Models\\BaseElement', 'RS\\Elemental\\Model\\UIElementalBanner', 'RS\\Elemental\\Model\\UIElementalBlogPostList', 'RS\\Elemental\\Model\\UIElementalCTAGroup', 'RS\\Elemental\\Model\\UIElementalCarousel', 'RS\\Elemental\\Model\\UIElementalColumn', 'RS\\Elemental\\Model\\UIElementalContent', 'RS\\Elemental\\Model\\UIElementalContentGroup', 'RS\\Elemental\\Model\\UIElementalFeatureBlock', 'RS\\Elemental\\Model\\UIElementalFeaturedGrid', 'RS\\Elemental\\Model\\UIElementalGallery', 'RS\\Elemental\\Model\\UIElementalGrid', 'RS\\Elemental\\Model\\UIElementalLocomotiveSection', 'RS\\Elemental\\Model\\UIElementalLogoGarden', 'RS\\Elemental\\Model\\UIElementalPageHeader', '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"."ContentAlign" WHEN "Element_Live"."ClassName" IN ('RS\\Elemental\\Model\\UIElementalPageHeader') THEN "UIElementalPageHeader_Live"."ContentAlign" ELSE NULL END AS "ContentAlign", "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
0034: SELECT DISTINCT count(DISTINCT "ElementalStyleProperties"."ID") AS "Count"
FROM "ElementalStyleProperties"
WHERE ("StyleOwnerClass" IN ('RS\\Elemental\\Model\\UIElementalPageHeader'))
AND ("ElementalStyleProperties"."StyleOwnerID" = ?)
0.0006s
0035: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "UIElementalPageHeader_Buttons" ON "UIElementalPageHeader_Buttons"."LinkID" = "Link"."ID"
WHERE ("UIElementalPageHeader_Buttons"."UIElementalPageHeaderID" = ?)
0.0003s
0036: 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"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0005s
0037: SELECT DISTINCT count(DISTINCT "ElementalStyleProperties"."ID") AS "Count"
FROM "ElementalStyleProperties"
WHERE ("StyleOwnerClass" IN ('RS\\Elemental\\Model\\UIElementalLocomotiveSection'))
AND ("ElementalStyleProperties"."StyleOwnerID" = ?)
0.0006s
0038: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "UIElementalLocomotiveSections_Live"."Content", "UIElementalLocomotiveSections_Live"."Opacity", "UIElementalLocomotiveSections_Live"."BGColor", "UIElementalLocomotiveSections_Live"."ContentColor", "UIElementalLocomotiveSections_Live"."AspectRatio", "UIElementalLocomotiveSections_Live"."BlendMode", "UIElementalLocomotiveSections_Live"."ImageID", CASE WHEN "Element_Live"."ClassName" IN ('DNADesign\\Elemental\\Models\\BaseElement', 'RS\\Elemental\\Model\\UIElementalBanner', 'RS\\Elemental\\Model\\UIElementalBlogPostList', 'RS\\Elemental\\Model\\UIElementalCTAGroup', 'RS\\Elemental\\Model\\UIElementalCarousel', 'RS\\Elemental\\Model\\UIElementalColumn', 'RS\\Elemental\\Model\\UIElementalContent', 'RS\\Elemental\\Model\\UIElementalContentGroup', 'RS\\Elemental\\Model\\UIElementalFeatureBlock', 'RS\\Elemental\\Model\\UIElementalFeaturedGrid', 'RS\\Elemental\\Model\\UIElementalGallery', 'RS\\Elemental\\Model\\UIElementalGrid', 'RS\\Elemental\\Model\\UIElementalLocomotiveSection', 'RS\\Elemental\\Model\\UIElementalLogoGarden', 'RS\\Elemental\\Model\\UIElementalPageHeader', '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"."ContentPosition" WHEN "Element_Live"."ClassName" IN ('RS\\Elemental\\Model\\UIElementalLocomotiveSection') THEN "UIElementalLocomotiveSections_Live"."ContentPosition" ELSE NULL END AS "ContentPosition", "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 "UIElementalLocomotiveSections_Live" ON "UIElementalLocomotiveSections_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0007s
0039: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0003s
0040: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0003s
0041: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "UIElementalLocomotiveSections_Links" ON "UIElementalLocomotiveSections_Links"."LinkID" = "Link"."ID"
WHERE ("UIElementalLocomotiveSections_Links"."UIElementalLocomotiveSectionsID" = ?)
0.0008s
0042: SELECT DISTINCT "UIElementalLocomotiveSections_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 "UIElementalLocomotiveSections_Links" ON "UIElementalLocomotiveSections_Links"."LinkID" = "Link"."ID"
WHERE ("UIElementalLocomotiveSections_Links"."UIElementalLocomotiveSectionsID" = ?)
ORDER BY "Sort" ASC
0.0016s
0043: 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
0044: 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"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0007s
0045: SELECT DISTINCT count(DISTINCT "ElementalStyleProperties"."ID") AS "Count"
FROM "ElementalStyleProperties"
WHERE ("StyleOwnerClass" IN ('RS\\Elemental\\Model\\UIElementalTriptych'))
AND ("ElementalStyleProperties"."StyleOwnerID" = ?)
0.0007s
0046: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "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
0047: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "UIElementalTriptychs_Live"."Content", "UIElementalTriptychs_Live"."AspectRatio", "UIElementalTriptychs_Live"."Orientation", "UIElementalTriptychs_Live"."Fill", "UIElementalTriptychs_Live"."ForceParallax", "UIElementalTriptychs_Live"."Spacing", CASE WHEN "Element_Live"."ClassName" IN ('DNADesign\\Elemental\\Models\\BaseElement', 'RS\\Elemental\\Model\\UIElementalBanner', 'RS\\Elemental\\Model\\UIElementalBlogPostList', 'RS\\Elemental\\Model\\UIElementalCTAGroup', 'RS\\Elemental\\Model\\UIElementalCarousel', 'RS\\Elemental\\Model\\UIElementalColumn', 'RS\\Elemental\\Model\\UIElementalContent', 'RS\\Elemental\\Model\\UIElementalContentGroup', 'RS\\Elemental\\Model\\UIElementalFeatureBlock', 'RS\\Elemental\\Model\\UIElementalFeaturedGrid', 'RS\\Elemental\\Model\\UIElementalGallery', 'RS\\Elemental\\Model\\UIElementalGrid', 'RS\\Elemental\\Model\\UIElementalLocomotiveSection', 'RS\\Elemental\\Model\\UIElementalLogoGarden', 'RS\\Elemental\\Model\\UIElementalPageHeader', 'RS\\Elemental\\Model\\UIElementalRepeater', 'RS\\Elemental\\Model\\UIElementalSlide', 'RS\\Elemental\\Model\\UIElementalSpacer', 'RS\\Elemental\\Model\\UIElementalTimeline', 'RS\\Elemental\\Model\\UIElementalTriptych', 'DNADesign\\Elemental\\Models\\ElementContent', 'DNADesign\\ElementalList\\Model\\ElementList', 'DNADesign\\ElementalVirtual\\Model\\ElementVirtual') THEN "Element_Live"."Title" WHEN "Element_Live"."ClassName" IN ('RS\\Elemental\\Model\\UIElementalTriptych') THEN "UIElementalTriptychs_Live"."Title" ELSE NULL END AS "Title", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "UIElementalTriptychs_Live" ON "UIElementalTriptychs_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0009s
0048: SELECT DISTINCT count(DISTINCT "File_Live"."ID") AS "Count"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "UIElementalTriptychs_Images" ON "UIElementalTriptychs_Images"."ImageID" = "File_Live"."ID"
WHERE ("UIElementalTriptychs_Images"."UIElementalTriptychsID" = ?)
AND ("File_Live"."ClassName" IN (?))
0.0005s
0049: 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 "UIElementalTriptychs_Images" ON "UIElementalTriptychs_Images"."ImageID" = "File_Live"."ID"
WHERE ("UIElementalTriptychs_Images"."UIElementalTriptychsID" = ?)
AND ("File_Live"."ClassName" IN (?))
0.0004s
0050: 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 "UIElementalTriptychs_Images" ON "UIElementalTriptychs_Images"."ImageID" = "File_Live"."ID"
WHERE ("UIElementalTriptychs_Images"."UIElementalTriptychsID" = ?)
AND ("File_Live"."ClassName" IN (?))
0.0004s
0051: SELECT DISTINCT "UIElementalTriptychs_Images"."Sort", "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"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "UIElementalTriptychs_Images" ON "UIElementalTriptychs_Images"."ImageID" = "File_Live"."ID"
WHERE ("UIElementalTriptychs_Images"."UIElementalTriptychsID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "Sort" ASC
LIMIT 3
0.0012s
0052: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "UIElementalTriptychs_Buttons" ON "UIElementalTriptychs_Buttons"."LinkID" = "Link"."ID"
WHERE ("UIElementalTriptychs_Buttons"."UIElementalTriptychsID" = ?)
0.0006s
0053: SELECT DISTINCT count(DISTINCT "ElementalStyleProperties"."ID") AS "Count"
FROM "ElementalStyleProperties"
WHERE ("StyleOwnerClass" IN ('RS\\Elemental\\Model\\UIElementalLocomotiveSection'))
AND ("ElementalStyleProperties"."StyleOwnerID" = ?)
0.0003s
0054: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "UIElementalLocomotiveSections_Live"."Content", "UIElementalLocomotiveSections_Live"."Opacity", "UIElementalLocomotiveSections_Live"."BGColor", "UIElementalLocomotiveSections_Live"."ContentColor", "UIElementalLocomotiveSections_Live"."AspectRatio", "UIElementalLocomotiveSections_Live"."BlendMode", "UIElementalLocomotiveSections_Live"."ImageID", CASE WHEN "Element_Live"."ClassName" IN ('DNADesign\\Elemental\\Models\\BaseElement', 'RS\\Elemental\\Model\\UIElementalBanner', 'RS\\Elemental\\Model\\UIElementalBlogPostList', 'RS\\Elemental\\Model\\UIElementalCTAGroup', 'RS\\Elemental\\Model\\UIElementalCarousel', 'RS\\Elemental\\Model\\UIElementalColumn', 'RS\\Elemental\\Model\\UIElementalContent', 'RS\\Elemental\\Model\\UIElementalContentGroup', 'RS\\Elemental\\Model\\UIElementalFeatureBlock', 'RS\\Elemental\\Model\\UIElementalFeaturedGrid', 'RS\\Elemental\\Model\\UIElementalGallery', 'RS\\Elemental\\Model\\UIElementalGrid', 'RS\\Elemental\\Model\\UIElementalLocomotiveSection', 'RS\\Elemental\\Model\\UIElementalLogoGarden', 'RS\\Elemental\\Model\\UIElementalPageHeader', '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"."ContentPosition" WHEN "Element_Live"."ClassName" IN ('RS\\Elemental\\Model\\UIElementalLocomotiveSection') THEN "UIElementalLocomotiveSections_Live"."ContentPosition" ELSE NULL END AS "ContentPosition", "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 "UIElementalLocomotiveSections_Live" ON "UIElementalLocomotiveSections_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0005s
0055: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0003s
0056: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "UIElementalLocomotiveSections_Links" ON "UIElementalLocomotiveSections_Links"."LinkID" = "Link"."ID"
WHERE ("UIElementalLocomotiveSections_Links"."UIElementalLocomotiveSectionsID" = ?)
0.0004s
0057: SELECT DISTINCT "UIElementalLocomotiveSections_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 "UIElementalLocomotiveSections_Links" ON "UIElementalLocomotiveSections_Links"."LinkID" = "Link"."ID"
WHERE ("UIElementalLocomotiveSections_Links"."UIElementalLocomotiveSectionsID" = ?)
ORDER BY "Sort" ASC
0.001s
0058: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."OGTitle", "SiteTree_Live"."OGType", "SiteTree_Live"."OGDescription", "SiteTree_Live"."BGVideoURL", "SiteTree_Live"."BGVideoType", "SiteTree_Live"."BGVideoID", "SiteTree_Live"."BGVideoStatus", "SiteTree_Live"."BGVideoDelay", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0004s
0059: 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"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0004s
0060: SELECT DISTINCT count(DISTINCT "ElementalStyleProperties"."ID") AS "Count"
FROM "ElementalStyleProperties"
WHERE ("StyleOwnerClass" IN ('RS\\Elemental\\Model\\UIElementalLocomotiveSection'))
AND ("ElementalStyleProperties"."StyleOwnerID" = ?)
0.0004s
0061: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "UIElementalLocomotiveSections_Live"."Content", "UIElementalLocomotiveSections_Live"."Opacity", "UIElementalLocomotiveSections_Live"."BGColor", "UIElementalLocomotiveSections_Live"."ContentColor", "UIElementalLocomotiveSections_Live"."AspectRatio", "UIElementalLocomotiveSections_Live"."BlendMode", "UIElementalLocomotiveSections_Live"."ImageID", CASE WHEN "Element_Live"."ClassName" IN ('DNADesign\\Elemental\\Models\\BaseElement', 'RS\\Elemental\\Model\\UIElementalBanner', 'RS\\Elemental\\Model\\UIElementalBlogPostList', 'RS\\Elemental\\Model\\UIElementalCTAGroup', 'RS\\Elemental\\Model\\UIElementalCarousel', 'RS\\Elemental\\Model\\UIElementalColumn', 'RS\\Elemental\\Model\\UIElementalContent', 'RS\\Elemental\\Model\\UIElementalContentGroup', 'RS\\Elemental\\Model\\UIElementalFeatureBlock', 'RS\\Elemental\\Model\\UIElementalFeaturedGrid', 'RS\\Elemental\\Model\\UIElementalGallery', 'RS\\Elemental\\Model\\UIElementalGrid', 'RS\\Elemental\\Model\\UIElementalLocomotiveSection', 'RS\\Elemental\\Model\\UIElementalLogoGarden', 'RS\\Elemental\\Model\\UIElementalPageHeader', '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"."ContentPosition" WHEN "Element_Live"."ClassName" IN ('RS\\Elemental\\Model\\UIElementalLocomotiveSection') THEN "UIElementalLocomotiveSections_Live"."ContentPosition" ELSE NULL END AS "ContentPosition", "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 "UIElementalLocomotiveSections_Live" ON "UIElementalLocomotiveSections_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0004s
0062: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0003s
0063: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "UIElementalLocomotiveSections_Links" ON "UIElementalLocomotiveSections_Links"."LinkID" = "Link"."ID"
WHERE ("UIElementalLocomotiveSections_Links"."UIElementalLocomotiveSectionsID" = ?)
0.0004s
0064: SELECT DISTINCT "UIElementalLocomotiveSections_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 "UIElementalLocomotiveSections_Links" ON "UIElementalLocomotiveSections_Links"."LinkID" = "Link"."ID"
WHERE ("UIElementalLocomotiveSections_Links"."UIElementalLocomotiveSectionsID" = ?)
ORDER BY "Sort" ASC
0.001s
0065: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."OGTitle", "SiteTree_Live"."OGType", "SiteTree_Live"."OGDescription", "SiteTree_Live"."BGVideoURL", "SiteTree_Live"."BGVideoType", "SiteTree_Live"."BGVideoID", "SiteTree_Live"."BGVideoStatus", "SiteTree_Live"."BGVideoDelay", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0006s
0066: 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"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0007s
0067: SELECT DISTINCT count(DISTINCT "ElementalStyleProperties"."ID") AS "Count"
FROM "ElementalStyleProperties"
WHERE ("StyleOwnerClass" IN ('RS\\Elemental\\Model\\UIElementalTriptych'))
AND ("ElementalStyleProperties"."StyleOwnerID" = ?)
0.0007s
0068: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0003s
0069: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "UIElementalTriptychs_Live"."Content", "UIElementalTriptychs_Live"."AspectRatio", "UIElementalTriptychs_Live"."Orientation", "UIElementalTriptychs_Live"."Fill", "UIElementalTriptychs_Live"."ForceParallax", "UIElementalTriptychs_Live"."Spacing", CASE WHEN "Element_Live"."ClassName" IN ('DNADesign\\Elemental\\Models\\BaseElement', 'RS\\Elemental\\Model\\UIElementalBanner', 'RS\\Elemental\\Model\\UIElementalBlogPostList', 'RS\\Elemental\\Model\\UIElementalCTAGroup', 'RS\\Elemental\\Model\\UIElementalCarousel', 'RS\\Elemental\\Model\\UIElementalColumn', 'RS\\Elemental\\Model\\UIElementalContent', 'RS\\Elemental\\Model\\UIElementalContentGroup', 'RS\\Elemental\\Model\\UIElementalFeatureBlock', 'RS\\Elemental\\Model\\UIElementalFeaturedGrid', 'RS\\Elemental\\Model\\UIElementalGallery', 'RS\\Elemental\\Model\\UIElementalGrid', 'RS\\Elemental\\Model\\UIElementalLocomotiveSection', 'RS\\Elemental\\Model\\UIElementalLogoGarden', 'RS\\Elemental\\Model\\UIElementalPageHeader', 'RS\\Elemental\\Model\\UIElementalRepeater', 'RS\\Elemental\\Model\\UIElementalSlide', 'RS\\Elemental\\Model\\UIElementalSpacer', 'RS\\Elemental\\Model\\UIElementalTimeline', 'RS\\Elemental\\Model\\UIElementalTriptych', 'DNADesign\\Elemental\\Models\\ElementContent', 'DNADesign\\ElementalList\\Model\\ElementList', 'DNADesign\\ElementalVirtual\\Model\\ElementVirtual') THEN "Element_Live"."Title" WHEN "Element_Live"."ClassName" IN ('RS\\Elemental\\Model\\UIElementalTriptych') THEN "UIElementalTriptychs_Live"."Title" ELSE NULL END AS "Title", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "UIElementalTriptychs_Live" ON "UIElementalTriptychs_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0006s
0070: 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 "UIElementalTriptychs_Images" ON "UIElementalTriptychs_Images"."ImageID" = "File_Live"."ID"
WHERE ("UIElementalTriptychs_Images"."UIElementalTriptychsID" = ?)
AND ("File_Live"."ClassName" IN (?))
0.0005s
0071: 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 "UIElementalTriptychs_Images" ON "UIElementalTriptychs_Images"."ImageID" = "File_Live"."ID"
WHERE ("UIElementalTriptychs_Images"."UIElementalTriptychsID" = ?)
AND ("File_Live"."ClassName" IN (?))
0.0004s
0072: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "UIElementalTriptychs_Buttons" ON "UIElementalTriptychs_Buttons"."LinkID" = "Link"."ID"
WHERE ("UIElementalTriptychs_Buttons"."UIElementalTriptychsID" = ?)
0.0003s
0073: 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 "UIElementalTriptychs_Images" ON "UIElementalTriptychs_Images"."ImageID" = "File_Live"."ID"
WHERE ("UIElementalTriptychs_Images"."UIElementalTriptychsID" = ?)
AND ("File_Live"."ClassName" IN (?))
0.0004s
0074: SELECT DISTINCT "UIElementalTriptychs_Images"."Sort", "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"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "UIElementalTriptychs_Images" ON "UIElementalTriptychs_Images"."ImageID" = "File_Live"."ID"
WHERE ("UIElementalTriptychs_Images"."UIElementalTriptychsID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "Sort" ASC
LIMIT 3
0.0012s
0075: SELECT DISTINCT count(DISTINCT "ElementalStyleProperties"."ID") AS "Count"
FROM "ElementalStyleProperties"
WHERE ("StyleOwnerClass" IN ('RS\\Elemental\\Model\\UIElementalLocomotiveSection'))
AND ("ElementalStyleProperties"."StyleOwnerID" = ?)
0.0006s
0076: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "UIElementalLocomotiveSections_Live"."Content", "UIElementalLocomotiveSections_Live"."Opacity", "UIElementalLocomotiveSections_Live"."BGColor", "UIElementalLocomotiveSections_Live"."ContentColor", "UIElementalLocomotiveSections_Live"."AspectRatio", "UIElementalLocomotiveSections_Live"."BlendMode", "UIElementalLocomotiveSections_Live"."ImageID", CASE WHEN "Element_Live"."ClassName" IN ('DNADesign\\Elemental\\Models\\BaseElement', 'RS\\Elemental\\Model\\UIElementalBanner', 'RS\\Elemental\\Model\\UIElementalBlogPostList', 'RS\\Elemental\\Model\\UIElementalCTAGroup', 'RS\\Elemental\\Model\\UIElementalCarousel', 'RS\\Elemental\\Model\\UIElementalColumn', 'RS\\Elemental\\Model\\UIElementalContent', 'RS\\Elemental\\Model\\UIElementalContentGroup', 'RS\\Elemental\\Model\\UIElementalFeatureBlock', 'RS\\Elemental\\Model\\UIElementalFeaturedGrid', 'RS\\Elemental\\Model\\UIElementalGallery', 'RS\\Elemental\\Model\\UIElementalGrid', 'RS\\Elemental\\Model\\UIElementalLocomotiveSection', 'RS\\Elemental\\Model\\UIElementalLogoGarden', 'RS\\Elemental\\Model\\UIElementalPageHeader', '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"."ContentPosition" WHEN "Element_Live"."ClassName" IN ('RS\\Elemental\\Model\\UIElementalLocomotiveSection') THEN "UIElementalLocomotiveSections_Live"."ContentPosition" ELSE NULL END AS "ContentPosition", "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 "UIElementalLocomotiveSections_Live" ON "UIElementalLocomotiveSections_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0006s
0077: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0003s
0078: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "UIElementalLocomotiveSections_Links" ON "UIElementalLocomotiveSections_Links"."LinkID" = "Link"."ID"
WHERE ("UIElementalLocomotiveSections_Links"."UIElementalLocomotiveSectionsID" = ?)
0.0005s
0079: SELECT DISTINCT "UIElementalLocomotiveSections_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 "UIElementalLocomotiveSections_Links" ON "UIElementalLocomotiveSections_Links"."LinkID" = "Link"."ID"
WHERE ("UIElementalLocomotiveSections_Links"."UIElementalLocomotiveSectionsID" = ?)
ORDER BY "Sort" ASC
0.0011s
0080: 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"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0006s
0081: SELECT DISTINCT count(DISTINCT "ElementalStyleProperties"."ID") AS "Count"
FROM "ElementalStyleProperties"
WHERE ("StyleOwnerClass" IN ('DNADesign\\Elemental\\Models\\ElementContent'))
AND ("ElementalStyleProperties"."StyleOwnerID" = ?)
0.0007s
0082: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0003s
0083: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementContent_Live"."HTML", "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 "ElementContent_Live" ON "ElementContent_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0005s
0084: 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.0006s
0085: SELECT DISTINCT "UIContent"."ClassName", "UIContent"."LastEdited", "UIContent"."Created", "UIContent"."Title", "UIContent"."Content", "UIContent"."Key", "UIContent"."Active", "UIContent"."ShowHeader", "UIContent"."MediaBlock", "UIContent"."LinksAsButtons", "UIContent"."AspectRatio", "UIContent"."Orientation", "UIContent"."SortOrder", "UIContent"."ImageID", "UIContent"."ID",
CASE WHEN "UIContent"."ClassName" IS NOT NULL THEN "UIContent"."ClassName"
ELSE 'RS\\Models\\UIContent' END AS "RecordClassName"
FROM "UIContent" INNER JOIN "UIContent_UIContentCollections" ON "UIContent_UIContentCollections"."UIContentID" = "UIContent"."ID"
WHERE ("UIContent_UIContentCollections"."UIContentCollectionsID" = ?)
AND (("UIContent"."Active" != ? OR "UIContent"."Active" IS NULL))
ORDER BY "UIContent"."SortOrder" ASC
0.0015s
0086: 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"."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
0087: 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
0088: 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.0013s
0089: 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
0090: SELECT DISTINCT count(DISTINCT "Social"."ID") AS "Count"
FROM "Social"
WHERE ("SocialOwnerClass" IN ('SilverStripe\\SiteConfig\\SiteConfig'))
AND ("Social"."SocialOwnerID" = ?)
0.0006s
0091: SELECT DISTINCT "Social"."ClassName", "Social"."LastEdited", "Social"."Created", "Social"."Network", "Social"."URL", "Social"."SortOrder", "Social"."SocialOwnerID", "Social"."SocialOwnerClass", "Social"."ID",
CASE WHEN "Social"."ClassName" IS NOT NULL THEN "Social"."ClassName"
ELSE 'RS\\Model\\Social' END AS "RecordClassName"
FROM "Social"
WHERE ("SocialOwnerClass" IN ('SilverStripe\\SiteConfig\\SiteConfig'))
AND ("Social"."SocialOwnerID" = ?)
ORDER BY "Social"."SortOrder" ASC
0.0004s
0092: 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", "Page_Live"."SSLayoutTemplate", "Page_Live"."SSLayoutClasses", "ElementalPage_Live"."ElementalAreaID", "LeadCapturePage_Live"."FormHeading", "LeadCapturePage_Live"."FormClass", "LeadCapturePage_Live"."FormIDOverride", "LeadCapturePage_Live"."FormFootnote", "LeadCapturePage_Live"."FormContent", "LeadCapturePage_Live"."RenderAddressFields", "LeadCapturePage_Live"."RenderTextArea", "LeadCapturePage_Live"."RenderForm", "LeadCapturePage_Live"."RenderFormHeading", "LeadCapturePage_Live"."LeadSourceID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "ElementalPage_Live" ON "ElementalPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "LeadCapturePage_Live" ON "LeadCapturePage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.002s
0093: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."OGTitle", "SiteTree_Live"."OGType", "SiteTree_Live"."OGDescription", "SiteTree_Live"."BGVideoURL", "SiteTree_Live"."BGVideoType", "SiteTree_Live"."BGVideoID", "SiteTree_Live"."BGVideoStatus", "SiteTree_Live"."BGVideoDelay", "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", "Page_Live"."SSLayoutTemplate", "Page_Live"."SSLayoutClasses", "ElementalPage_Live"."ElementalAreaID", "LeadCapturePage_Live"."FormHeading", "LeadCapturePage_Live"."FormClass", "LeadCapturePage_Live"."FormIDOverride", "LeadCapturePage_Live"."FormFootnote", "LeadCapturePage_Live"."FormContent", "LeadCapturePage_Live"."RenderAddressFields", "LeadCapturePage_Live"."RenderTextArea", "LeadCapturePage_Live"."RenderForm", "LeadCapturePage_Live"."RenderFormHeading", "LeadCapturePage_Live"."LeadSourceID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "ElementalPage_Live" ON "ElementalPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "LeadCapturePage_Live" ON "LeadCapturePage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0019s
0094: 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", "Page_Live"."SSLayoutTemplate", "Page_Live"."SSLayoutClasses", "ElementalPage_Live"."ElementalAreaID", "LeadCapturePage_Live"."FormHeading", "LeadCapturePage_Live"."FormClass", "LeadCapturePage_Live"."FormIDOverride", "LeadCapturePage_Live"."FormFootnote", "LeadCapturePage_Live"."FormContent", "LeadCapturePage_Live"."RenderAddressFields", "LeadCapturePage_Live"."RenderTextArea", "LeadCapturePage_Live"."RenderForm", "LeadCapturePage_Live"."RenderFormHeading", "LeadCapturePage_Live"."LeadSourceID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "ElementalPage_Live" ON "ElementalPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "LeadCapturePage_Live" ON "LeadCapturePage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0015s
0095: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "UIContent_Links" ON "UIContent_Links"."LinkID" = "Link"."ID"
WHERE ("UIContent_Links"."UIContentID" = ?)
0.0005s
0096: 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
0097: SELECT DISTINCT "Navigation_Links"."Sort", "Link"."ClassName", "Link"."LastEdited", "Link"."Created", "Link"."Anchor", "Link"."ButtonLabel", "Link"."RelOptions", "Link"."ExtraCSS", "Link"."Key", "Link"."Description", "Link"."Title", "Link"."Type", "Link"."URL", "Link"."Email", "Link"."Phone", "Link"."OpenInNewWindow", "Link"."SelectedStyle", "Link"."SiteTreeID", "Link"."ImageID", "Link"."FileID", "NavigationLinks"."RenderMultiLevel", "Link"."ID",
CASE WHEN "Link"."ClassName" IS NOT NULL THEN "Link"."ClassName"
ELSE 'gorriecoe\\Link\\Models\\Link' END AS "RecordClassName"
FROM "Link" LEFT JOIN "NavigationLinks" ON "NavigationLinks"."ID" = "Link"."ID" INNER JOIN "Navigation_Links" ON "Navigation_Links"."NavigationLinksID" = "Link"."ID"
WHERE ("Navigation_Links"."NavigationID" = ?)
AND ("Link"."ClassName" IN (?))
ORDER BY "Sort" ASC
0.0015s
0098: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."OGTitle", "SiteTree_Live"."OGType", "SiteTree_Live"."OGDescription", "SiteTree_Live"."BGVideoURL", "SiteTree_Live"."BGVideoType", "SiteTree_Live"."BGVideoID", "SiteTree_Live"."BGVideoStatus", "SiteTree_Live"."BGVideoDelay", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0006s
0099: 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
0100: 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
0101: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "UIContent_Links" ON "UIContent_Links"."LinkID" = "Link"."ID"
WHERE ("UIContent_Links"."UIContentID" = ?)
0.0005s
0102: 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.0008s
0103: 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"."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.0006s
0104: 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"."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
0105: 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"."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.0008s
0106: 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
0107: SELECT DISTINCT count(DISTINCT "LeadSourceFields"."ID") AS "Count"
FROM "LeadSourceFields"
WHERE ("LeadSourceFields"."LeadSourceID" = ?)
0.0004s
0108: SELECT DISTINCT count(DISTINCT "LeadSources"."ID") AS "Count"
FROM "LeadSources"
WHERE ("LeadSources"."Key" = ?)
0.0003s
0109: 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"."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
0110: 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"."SortOrder", "LeadSources"."ContentID", "LeadSources"."ID",
CASE WHEN "LeadSources"."ClassName" IS NOT NULL THEN "LeadSources"."ClassName"
ELSE 'RS\\Model\\LeadSource' END AS "RecordClassName"
FROM "LeadSources"
WHERE ("LeadSources"."Key" = ?)
LIMIT 1
0.0008s
0111: 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"."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
0112: 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
0113: SELECT DISTINCT count(DISTINCT "LeadSourceFields"."ID") AS "Count"
FROM "LeadSourceFields"
WHERE ("LeadSourceFields"."LeadSourceID" = ?)
0.0003s
0114: SELECT DISTINCT count(DISTINCT "LeadSources"."ID") AS "Count"
FROM "LeadSources"
WHERE ("LeadSources"."Key" = ?)
0.0003s
0115: 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"."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
0116: 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"."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 (?))
0.0017s
0117: 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"."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
0118: 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"."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
0119: SELECT DISTINCT "LeadOptins"."ClassName", "LeadOptins"."LastEdited", "LeadOptins"."Created", "LeadOptins"."Label", "LeadOptins"."Description", "LeadOptins"."LeadSourceID", "LeadOptins"."ID",
CASE WHEN "LeadOptins"."ClassName" IS NOT NULL THEN "LeadOptins"."ClassName"
ELSE 'RS\\Model\\LeadOptin' END AS "RecordClassName"
FROM "LeadOptins"
WHERE ("LeadOptins"."LeadSourceID" = ?)
0.0005s
0120: SELECT DISTINCT count(DISTINCT "LeadSourceFields"."ID") AS "Count"
FROM "LeadSourceFields"
WHERE ("LeadSourceFields"."LeadSourceID" = ?)
0.0004s
0121: SELECT DISTINCT "Group"."ClassName", "Group"."LastEdited", "Group"."Created", "Group"."Title", "Group"."Description", "Group"."Code", "Group"."Locked", "Group"."Sort", "Group"."HtmlEditorConfig", "Group"."ParentID", "Group"."ID",
CASE WHEN "Group"."ClassName" IS NOT NULL THEN "Group"."ClassName"
ELSE 'SilverStripe\\Security\\Group' END AS "RecordClassName"
FROM "Group"
WHERE ("Group"."Code" = ?)
LIMIT 1
0.0007s
0122: SELECT "Group"."ID"
FROM "Group"
WHERE ("Group"."ParentID" IN (?))
0.0003s
0123: SELECT DISTINCT "Member"."ClassName", "Member"."LastEdited", "Member"."Created", "Member"."Bio", "Member"."Position", "Member"."UUID", "Member"."FirstName", "Member"."Surname", "Member"."Email", "Member"."TempIDHash", "Member"."TempIDExpired", "Member"."Password", "Member"."AutoLoginHash", "Member"."AutoLoginExpired", "Member"."PasswordEncryption", "Member"."Salt", "Member"."PasswordExpiry", "Member"."LockedOutUntil", "Member"."Locale", "Member"."FailedLoginCount", "Member"."ImageID", "Member"."APIKeyID", "Member"."ID",
CASE WHEN "Member"."ClassName" IS NOT NULL THEN "Member"."ClassName"
ELSE 'SilverStripe\\Security\\Member' END AS "RecordClassName"
FROM "Member" INNER JOIN "Group_Members" ON "Group_Members"."MemberID" = "Member"."ID"
WHERE ("Group_Members"."GroupID" = ?)
ORDER BY "Member"."Surname" ASC
0.0015s
0124: SELECT DISTINCT count(DISTINCT "LeadSources"."ID") AS "Count"
FROM "LeadSources"
WHERE ("LeadSources"."Key" = ?)
0.0004s
0125: 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"."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
0126: 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", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', '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', 'GalleryPage', 'HomePage', 'LeadCapturePage', 'LocomotivePage', 'SiteMapPage', 'ContactPage', 'ContestPage', 'RedirectionPage') THEN "Page_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.0021s
0127: SELECT "Version" FROM "SiteTree" WHERE "ID" = ?
0.0004s
0128: 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
0129: 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
0130: 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.0004s
0131: 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
Home | Experience The Fraser
ExperiencetheFraser
From the Salish Sea to Hope.
We are creating one of the world’s greatest river destinations
Connecting communities from the Salish Sea to Hope, we are creating new opportunities to Experience the Fraser through a network of greenways and blueways. The Coast to Canyon Trail builds deeper connections to the river destination through centuries-old stories of life on the Lower Fraser.
Aenean massa. Sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem.
~ Jane Smith
Bridging communities from the Salish Sea to Hope
The multi-modal transportation network is a catalyst for active and healthy living, climate impact reduction, and economic development. The Canyon to Coast Trail network links a suite of outstanding visitor attractions and enhances land and water-based recreational opportunities throughout the region.
Even the all-powerful Pointing has no control about the blind texts it is an almost unorthographic life One day however a small line of blind text by the name of Lorem Ipsum decided to leave for the far World of Grammar.
Aenean massa. Sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem.
~ Jane Smith
Let’s celebrate our shared culture & heritage
Communities have a monumental opportunity to champion the Coast to Canyon Trail and connect one of Canada’s largest active transportation networks. Local stories, engagement, and planning is vital. Together, we will showcase the Lower Fraser River Corridor and its landscapes, features, wildlife, and people as one of the great river destinations of the world.
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.
