0001: SET sql_mode = ?
0.0003s
0002: SHOW DATABASES LIKE 'dlitd\_staging'
0.0021s
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.0023s
0005: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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.0008s
0006: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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"."ParentID" = ?)
AND ("SiteTree_Live"."URLSegment" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0006s
0007: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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
0008: 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"."GTMContainer", "SiteConfig"."GTMID", "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.0004s
0009: SELECT DISTINCT "Member"."ClassName", "Member"."LastEdited", "Member"."Created", "Member"."Bio", "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"
WHERE ("Member"."FirstName" = ?)
ORDER BY "Member"."Surname" ASC, "Member"."FirstName" ASC
LIMIT 1
0.0005s
0010: SELECT DISTINCT "APIKey"."ClassName", "APIKey"."LastEdited", "APIKey"."Created", "APIKey"."Token", "APIKey"."PublicKey", "APIKey"."Status", "APIKey"."ID",
CASE WHEN "APIKey"."ClassName" IS NOT NULL THEN "APIKey"."ClassName"
ELSE 'RS\\Model\\APIKey' END AS "RecordClassName"
FROM "APIKey"
WHERE ("APIKey"."ID" = ?)
LIMIT 1
0.0003s
0011: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlogPage', 'CalendarPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'HomePage', 'ImpactPage', 'LeadCapturePage', 'PartnerPage', 'ResourcePage', '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', 'CalendarPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'HomePage', 'ImpactPage', 'LeadCapturePage', 'PartnerPage', 'ResourcePage', '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.0006s
0012: 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
0013: SELECT DISTINCT "NavGroups"."ClassName", "NavGroups"."LastEdited", "NavGroups"."Created", "NavGroups"."Title", "NavGroups"."Heading", "NavGroups"."Key", "NavGroups"."Description", "NavGroups"."Content", "NavGroups"."URL", "NavGroups"."Active", "NavGroups"."Advanced", "NavGroups"."ImageID", "NavGroups"."PageID", "NavGroups"."ID",
CASE WHEN "NavGroups"."ClassName" IS NOT NULL THEN "NavGroups"."ClassName"
ELSE 'RS\\NavBuilder\\Model\\NavGroup' END AS "RecordClassName"
FROM "NavGroups"
WHERE ("NavGroups"."Key" = ?)
AND ("NavGroups"."Active" = ?)
LIMIT 1
0.0006s
0014: SELECT DISTINCT "NavGroups"."ClassName", "NavGroups"."LastEdited", "NavGroups"."Created", "NavGroups"."Title", "NavGroups"."Heading", "NavGroups"."Key", "NavGroups"."Description", "NavGroups"."Content", "NavGroups"."URL", "NavGroups"."Active", "NavGroups"."Advanced", "NavGroups"."ImageID", "NavGroups"."PageID", "NavGroups"."ID",
CASE WHEN "NavGroups"."ClassName" IS NOT NULL THEN "NavGroups"."ClassName"
ELSE 'RS\\NavBuilder\\Model\\NavGroup' END AS "RecordClassName"
FROM "NavGroups"
WHERE ("NavGroups"."Key" = ?)
AND ("NavGroups"."Active" = ?)
LIMIT 1
0.0005s
0015: SELECT CASE WHEN EXISTS(SELECT *
FROM "Link" INNER JOIN "NavGroups_Buttons" ON "NavGroups_Buttons"."LinkID" = "Link"."ID"
WHERE ("NavGroups_Buttons"."NavGroupsID" = ?)) THEN 1 ELSE 0 END
0.0005s
0016: SELECT DISTINCT "NavGroups_Buttons"."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 "NavGroups_Buttons" ON "NavGroups_Buttons"."LinkID" = "Link"."ID"
WHERE ("NavGroups_Buttons"."NavGroupsID" = ?)
ORDER BY "Sort" ASC
0.0012s
0017: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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
0018: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0003s
0019: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0003s
0020: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0003s
0021: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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
0022: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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
0023: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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
0024: SELECT DISTINCT "NavGroupCollections"."ClassName", "NavGroupCollections"."LastEdited", "NavGroupCollections"."Created", "NavGroupCollections"."Title", "NavGroupCollections"."Heading", "NavGroupCollections"."Key", "NavGroupCollections"."Description", "NavGroupCollections"."Status", "NavGroupCollections"."ImageID", "NavGroupCollections"."ID",
CASE WHEN "NavGroupCollections"."ClassName" IS NOT NULL THEN "NavGroupCollections"."ClassName"
ELSE 'RS\\NavBuilder\\Model\\NavGroupCollection' END AS "RecordClassName"
FROM "NavGroupCollections"
WHERE ("NavGroupCollections"."Key" = ?)
AND ("NavGroupCollections"."Status" = ?)
LIMIT 1
0.0005s
0025: SELECT DISTINCT "NavGroupCollections_Groups"."OtherSortOrder", "NavGroups"."ClassName", "NavGroups"."LastEdited", "NavGroups"."Created", "NavGroups"."Title", "NavGroups"."Heading", "NavGroups"."Key", "NavGroups"."Description", "NavGroups"."Content", "NavGroups"."URL", "NavGroups"."Active", "NavGroups"."Advanced", "NavGroups"."ImageID", "NavGroups"."PageID", "NavGroups"."ID",
CASE WHEN "NavGroups"."ClassName" IS NOT NULL THEN "NavGroups"."ClassName"
ELSE 'RS\\NavBuilder\\Model\\NavGroup' END AS "RecordClassName"
FROM "NavGroups" INNER JOIN "NavGroupCollections_Groups" ON "NavGroupCollections_Groups"."NavGroupsID" = "NavGroups"."ID"
WHERE ("NavGroupCollections_Groups"."NavGroupCollectionsID" = ?)
0.001s
0026: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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", "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"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0006s
0027: 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
0028: SELECT CASE WHEN EXISTS(SELECT *
FROM "Link" INNER JOIN "NavGroups_Buttons" ON "NavGroups_Buttons"."LinkID" = "Link"."ID"
WHERE ("NavGroups_Buttons"."NavGroupsID" = ?)) THEN 1 ELSE 0 END
0.0005s
0029: SELECT DISTINCT "NavGroups_Buttons"."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 "NavGroups_Buttons" ON "NavGroups_Buttons"."LinkID" = "Link"."ID"
WHERE ("NavGroups_Buttons"."NavGroupsID" = ?)
ORDER BY "Sort" ASC
0.0011s
0030: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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
0031: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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
0032: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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
0033: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0003s
0034: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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
0035: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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
0036: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0003s
0037: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0003s
0038: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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
0039: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0003s
0040: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0003s
0041: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0003s
0042: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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", "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"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0005s
0043: 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
0044: SELECT CASE WHEN EXISTS(SELECT *
FROM "Link" INNER JOIN "NavGroups_Buttons" ON "NavGroups_Buttons"."LinkID" = "Link"."ID"
WHERE ("NavGroups_Buttons"."NavGroupsID" = ?)) THEN 1 ELSE 0 END
0.0004s
0045: SELECT DISTINCT "NavGroups_Buttons"."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 "NavGroups_Buttons" ON "NavGroups_Buttons"."LinkID" = "Link"."ID"
WHERE ("NavGroups_Buttons"."NavGroupsID" = ?)
ORDER BY "Sort" ASC
0.001s
0046: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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
0047: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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
0048: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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", "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"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0005s
0049: 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
0050: SELECT CASE WHEN EXISTS(SELECT *
FROM "Link" INNER JOIN "NavGroups_Buttons" ON "NavGroups_Buttons"."LinkID" = "Link"."ID"
WHERE ("NavGroups_Buttons"."NavGroupsID" = ?)) THEN 1 ELSE 0 END
0.0005s
0051: SELECT DISTINCT "NavGroups_Buttons"."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 "NavGroups_Buttons" ON "NavGroups_Buttons"."LinkID" = "Link"."ID"
WHERE ("NavGroups_Buttons"."NavGroupsID" = ?)
ORDER BY "Sort" ASC
0.0009s
0052: 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
0053: SELECT DISTINCT "NavGroups"."ClassName", "NavGroups"."LastEdited", "NavGroups"."Created", "NavGroups"."Title", "NavGroups"."Heading", "NavGroups"."Key", "NavGroups"."Description", "NavGroups"."Content", "NavGroups"."URL", "NavGroups"."Active", "NavGroups"."Advanced", "NavGroups"."ImageID", "NavGroups"."PageID", "NavGroups"."ID",
CASE WHEN "NavGroups"."ClassName" IS NOT NULL THEN "NavGroups"."ClassName"
ELSE 'RS\\NavBuilder\\Model\\NavGroup' END AS "RecordClassName"
FROM "NavGroups"
WHERE ("NavGroups"."Key" = ?)
LIMIT 1
0.0003s
0054: SELECT DISTINCT "NavGroups_Buttons"."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 "NavGroups_Buttons" ON "NavGroups_Buttons"."LinkID" = "Link"."ID"
WHERE ("NavGroups_Buttons"."NavGroupsID" = ?)
ORDER BY "Sort" ASC
0.001s
0055: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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
0056: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0003s
0057: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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
0058: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0003s
0059: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0003s
0060: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0003s
0061: 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.0003s
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.0002s
0063: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "ImpactPage_Live"."ImpactID", "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 "ImpactPage_Live" ON "ImpactPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0005s
0064: SELECT DISTINCT "ImpactPoints_Live"."ClassName", "ImpactPoints_Live"."LastEdited", "ImpactPoints_Live"."Created", "ImpactPoints_Live"."Version", "ImpactPoints_Live"."Title", "ImpactPoints_Live"."Description", "ImpactPoints_Live"."Content", "ImpactPoints_Live"."URLSegment", "ImpactPoints_Live"."Endcap", "ImpactPoints_Live"."SortOrder", "ImpactPoints_Live"."ImageID", "ImpactPoints_Live"."ID",
CASE WHEN "ImpactPoints_Live"."ClassName" IS NOT NULL THEN "ImpactPoints_Live"."ClassName"
ELSE 'RS\\Model\\ImpactPoint' END AS "RecordClassName"
FROM "ImpactPoints_Live"
WHERE ("ImpactPoints_Live"."ID" = ?)
ORDER BY "ImpactPoints_Live"."SortOrder" ASC
LIMIT 1
0.0003s
0065: 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
0066: SELECT DISTINCT count(DISTINCT "ImpactMetrics"."ID") AS "Count"
FROM "ImpactMetrics" INNER JOIN "ImpactPoints_Metrics" ON "ImpactPoints_Metrics"."ImpactMetricsID" = "ImpactMetrics"."ID"
WHERE ("ImpactPoints_Metrics"."ImpactPointsID" = ?)
0.0006s
0067: SELECT DISTINCT "ImpactMetrics"."ClassName", "ImpactMetrics"."LastEdited", "ImpactMetrics"."Created", "ImpactMetrics"."Key", "ImpactMetrics"."Value", "ImpactMetrics"."SortOrder", "ImpactMetrics"."ImpactPointID", "ImpactMetrics"."ID",
CASE WHEN "ImpactMetrics"."ClassName" IS NOT NULL THEN "ImpactMetrics"."ClassName"
ELSE 'RS\\Model\\ImpactMetric' END AS "RecordClassName"
FROM "ImpactMetrics" INNER JOIN "ImpactPoints_Metrics" ON "ImpactPoints_Metrics"."ImpactMetricsID" = "ImpactMetrics"."ID"
WHERE ("ImpactPoints_Metrics"."ImpactPointsID" = ?)
ORDER BY "ImpactMetrics"."SortOrder" ASC
0.0004s
0068: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "Element_Live"."AvailableGlobally", "Element_Live"."DisplayContent", "Element_Live"."ContentPosition", "Element_Live"."ContentAlign", "Element_Live"."ElementalInlineStyles", "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.0004s
0069: 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
0070: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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", "ImpactPage_Live"."ImpactID", "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 "ImpactPage_Live" ON "ImpactPage_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.0012s
0071: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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
0072: SELECT DISTINCT count(DISTINCT "ElementalStyleProperties"."ID") AS "Count"
FROM "ElementalStyleProperties"
WHERE ("StyleOwnerClass" IN ('RS\\Elemental\\Model\\UIElementalContent'))
AND ("ElementalStyleProperties"."StyleOwnerID" = ?)
0.0004s
0073: 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
0074: 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.0002s
0075: SELECT DISTINCT count(DISTINCT "ElementalStyleProperties"."ID") AS "Count"
FROM "ElementalStyleProperties"
WHERE ("StyleOwnerClass" IN ('RS\\Elemental\\Model\\UIElementalContent'))
AND ("ElementalStyleProperties"."StyleOwnerID" = ?)
0.0004s
0076: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "UIElementalContent_Live"."Content", "UIElementalContent_Live"."Target", "UIElementalContent_Live"."URL", "UIElementalContent_Live"."LinkLabel", "UIElementalContent_Live"."Advanced", "UIElementalContent_Live"."PageID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "UIElementalContent_Live" ON "UIElementalContent_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0004s
0077: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "UIElementalContent_Buttons" ON "UIElementalContent_Buttons"."LinkID" = "Link"."ID"
WHERE ("UIElementalContent_Buttons"."UIElementalContentID" = ?)
0.0004s
0078: SELECT DISTINCT count(DISTINCT "ElementalStyleProperties"."ID") AS "Count"
FROM "ElementalStyleProperties"
WHERE ("StyleOwnerClass" IN ('RS\\Elemental\\Model\\UIElementalTriptych'))
AND ("ElementalStyleProperties"."StyleOwnerID" = ?)
0.0003s
0079: 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
0080: 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"."CollapseMarginTop", "UIElementalTriptychs_Live"."CollapseMarginBottom", "UIElementalTriptychs_Live"."Spacing", CASE WHEN "Element_Live"."ClassName" IN ('DNADesign\\Elemental\\Models\\BaseElement', 'RS\\Elemental\\Model\\UIElementalBanner', 'RS\\Elemental\\Model\\UIElementalBlogPostList', 'RS\\Elemental\\Model\\UIElementalCalendar', 'RS\\Elemental\\Model\\UIElementalCarousel', 'RS\\Elemental\\Model\\UIElementalColumn', 'RS\\Elemental\\Model\\UIElementalContent', 'RS\\Elemental\\Model\\UIElementalCrowdriffAmp', 'RS\\Elemental\\Model\\UIElementalCrowdriffGallery', 'RS\\Elemental\\Model\\UIElementalFeatureBlock', 'RS\\Elemental\\Model\\UIElementalFeaturedGrid', 'RS\\Elemental\\Model\\UIElementalGallery', 'RS\\Elemental\\Model\\UIElementalGrid', 'RS\\Elemental\\Model\\UIElementalPageHeader', 'RS\\Elemental\\Model\\UIElementalRepeater', 'RS\\Elemental\\Model\\UIElementalSlide', 'RS\\Elemental\\Model\\UIElementalSpacer', '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
0081: 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
0082: 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
0083: 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
0084: 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.001s
0085: 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.0007s
0086: SELECT DISTINCT count(DISTINCT "ElementalStyleProperties"."ID") AS "Count"
FROM "ElementalStyleProperties"
WHERE ("StyleOwnerClass" IN ('RS\\Elemental\\Model\\UIElementalTriptych'))
AND ("ElementalStyleProperties"."StyleOwnerID" = ?)
0.0005s
0087: 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
0088: 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"."CollapseMarginTop", "UIElementalTriptychs_Live"."CollapseMarginBottom", "UIElementalTriptychs_Live"."Spacing", CASE WHEN "Element_Live"."ClassName" IN ('DNADesign\\Elemental\\Models\\BaseElement', 'RS\\Elemental\\Model\\UIElementalBanner', 'RS\\Elemental\\Model\\UIElementalBlogPostList', 'RS\\Elemental\\Model\\UIElementalCalendar', 'RS\\Elemental\\Model\\UIElementalCarousel', 'RS\\Elemental\\Model\\UIElementalColumn', 'RS\\Elemental\\Model\\UIElementalContent', 'RS\\Elemental\\Model\\UIElementalCrowdriffAmp', 'RS\\Elemental\\Model\\UIElementalCrowdriffGallery', 'RS\\Elemental\\Model\\UIElementalFeatureBlock', 'RS\\Elemental\\Model\\UIElementalFeaturedGrid', 'RS\\Elemental\\Model\\UIElementalGallery', 'RS\\Elemental\\Model\\UIElementalGrid', 'RS\\Elemental\\Model\\UIElementalPageHeader', 'RS\\Elemental\\Model\\UIElementalRepeater', 'RS\\Elemental\\Model\\UIElementalSlide', 'RS\\Elemental\\Model\\UIElementalSpacer', '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
0089: 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.0006s
0090: 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
0091: 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
0092: 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
0093: 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.0014s
0094: SELECT DISTINCT count(DISTINCT "ElementalStyleProperties"."ID") AS "Count"
FROM "ElementalStyleProperties"
WHERE ("StyleOwnerClass" IN ('RS\\Elemental\\Model\\UIElementalContent'))
AND ("ElementalStyleProperties"."StyleOwnerID" = ?)
0.0009s
0095: 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.0005s
0096: SELECT DISTINCT count(DISTINCT "ElementalStyleProperties"."ID") AS "Count"
FROM "ElementalStyleProperties"
WHERE ("StyleOwnerClass" IN ('RS\\Elemental\\Model\\UIElementalContent'))
AND ("ElementalStyleProperties"."StyleOwnerID" = ?)
0.0007s
0097: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "UIElementalContent_Live"."Content", "UIElementalContent_Live"."Target", "UIElementalContent_Live"."URL", "UIElementalContent_Live"."LinkLabel", "UIElementalContent_Live"."Advanced", "UIElementalContent_Live"."PageID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "UIElementalContent_Live" ON "UIElementalContent_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0007s
0098: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "UIElementalContent_Buttons" ON "UIElementalContent_Buttons"."LinkID" = "Link"."ID"
WHERE ("UIElementalContent_Buttons"."UIElementalContentID" = ?)
0.0006s
0099: 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.0005s
0100: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "UIElementalSpacer_Live"."Spacing", "UIElementalSpacer_Live"."CollapseSpace", "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 "UIElementalSpacer_Live" ON "UIElementalSpacer_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0008s
0101: SELECT DISTINCT count(DISTINCT "ElementalStyleProperties"."ID") AS "Count"
FROM "ElementalStyleProperties"
WHERE ("StyleOwnerClass" IN ('RS\\Elemental\\Model\\UIElementalCarousel'))
AND ("ElementalStyleProperties"."StyleOwnerID" = ?)
0.0007s
0102: 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.0005s
0103: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "UIElementalCarousels_Live"."Content", "UIElementalCarousels_Live"."Spacing", "UIElementalCarousels_Live"."Easing", "UIElementalCarousels_Live"."Draggable", "UIElementalCarousels_Live"."Loop", "UIElementalCarousels_Live"."Controls", "UIElementalCarousels_Live"."Duration", "UIElementalCarousels_Live"."Delay", "UIElementalCarousels_Live"."Opacity", "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 "UIElementalCarousels_Live" ON "UIElementalCarousels_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0007s
0104: SELECT DISTINCT count(DISTINCT "ElementalStyleProperties"."ID") AS "Count"
FROM "ElementalStyleProperties"
WHERE ("StyleOwnerClass" IN ('RS\\Elemental\\Model\\UIElementalCarousel'))
AND ("ElementalStyleProperties"."StyleOwnerID" = ?)
0.0004s
0105: SELECT DISTINCT count(DISTINCT "Element_Live"."ID") AS "Count"
FROM "Element_Live" LEFT JOIN "UIElementalSlides_Live" ON "UIElementalSlides_Live"."ID" = "Element_Live"."ID" INNER JOIN "UIElementalCarousels_Slides" ON "UIElementalCarousels_Slides"."UIElementalSlidesID" = "Element_Live"."ID"
WHERE ("UIElementalCarousels_Slides"."UIElementalCarouselsID" = ?)
AND (("UIElementalSlides_Live"."Active" != ? OR "UIElementalSlides_Live"."Active" IS NULL))
AND ("Element_Live"."ClassName" IN (?))
0.0007s
0106: SELECT DISTINCT CASE WHEN "Element_Live"."ClassName" IN ('RS\\Elemental\\Model\\UIElementalCarousel') THEN "UIElementalCarousels_Slides"."SortOrder" WHEN "Element_Live"."ClassName" IN ('RS\\Elemental\\Model\\UIElementalSlide') THEN "UIElementalSlides_Live"."SortOrder" WHEN "Element_Live"."ClassName" IN ('RS\\Elemental\\Model\\UIElementalSlide') THEN "UIElementalSlides_Live"."SortOrder" ELSE NULL END AS "SortOrder", "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "Element_Live"."AvailableGlobally", "Element_Live"."DisplayContent", "Element_Live"."ContentPosition", CASE WHEN "Element_Live"."ClassName" IN ('DNADesign\\Elemental\\Models\\BaseElement', 'RS\\Elemental\\Model\\UIElementalBanner', 'RS\\Elemental\\Model\\UIElementalBlogPostList', 'RS\\Elemental\\Model\\UIElementalCalendar', 'RS\\Elemental\\Model\\UIElementalCarousel', 'RS\\Elemental\\Model\\UIElementalColumn', 'RS\\Elemental\\Model\\UIElementalContent', 'RS\\Elemental\\Model\\UIElementalCrowdriffAmp', 'RS\\Elemental\\Model\\UIElementalCrowdriffGallery', 'RS\\Elemental\\Model\\UIElementalFeatureBlock', 'RS\\Elemental\\Model\\UIElementalFeaturedGrid', 'RS\\Elemental\\Model\\UIElementalGallery', 'RS\\Elemental\\Model\\UIElementalGrid', 'RS\\Elemental\\Model\\UIElementalPageHeader', 'RS\\Elemental\\Model\\UIElementalRepeater', 'RS\\Elemental\\Model\\UIElementalSlide', 'RS\\Elemental\\Model\\UIElementalSpacer', '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\\UIElementalSlide') THEN "UIElementalSlides_Live"."ContentAlign" WHEN "Element_Live"."ClassName" IN ('RS\\Elemental\\Model\\UIElementalSlide') THEN "UIElementalSlides_Live"."ContentAlign" ELSE NULL END AS "ContentAlign", "Element_Live"."ElementalInlineStyles", "Element_Live"."Version", CASE WHEN "Element_Live"."ClassName" IN ('DNADesign\\Elemental\\Models\\BaseElement', 'RS\\Elemental\\Model\\UIElementalBanner', 'RS\\Elemental\\Model\\UIElementalBlogPostList', 'RS\\Elemental\\Model\\UIElementalCalendar', 'RS\\Elemental\\Model\\UIElementalCarousel', 'RS\\Elemental\\Model\\UIElementalColumn', 'RS\\Elemental\\Model\\UIElementalContent', 'RS\\Elemental\\Model\\UIElementalCrowdriffAmp', 'RS\\Elemental\\Model\\UIElementalCrowdriffGallery', 'RS\\Elemental\\Model\\UIElementalFeatureBlock', 'RS\\Elemental\\Model\\UIElementalFeaturedGrid', 'RS\\Elemental\\Model\\UIElementalGallery', 'RS\\Elemental\\Model\\UIElementalGrid', 'RS\\Elemental\\Model\\UIElementalPageHeader', 'RS\\Elemental\\Model\\UIElementalRepeater', 'RS\\Elemental\\Model\\UIElementalSlide', 'RS\\Elemental\\Model\\UIElementalSpacer', '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\\UIElementalSlide') THEN "UIElementalSlides_Live"."Title" WHEN "Element_Live"."ClassName" IN ('RS\\Elemental\\Model\\UIElementalSlide') THEN "UIElementalSlides_Live"."Title" ELSE NULL END AS "Title", "Element_Live"."ShowTitle", "Element_Live"."Sort", "Element_Live"."ExtraClass", "Element_Live"."Style", "Element_Live"."TopPageID", "Element_Live"."ParentID", "UIElementalSlides_Live"."Content", "UIElementalSlides_Live"."AspectRatio", "UIElementalSlides_Live"."Orientation", "UIElementalSlides_Live"."Active", "UIElementalSlides_Live"."Opacity", "UIElementalSlides_Live"."BGColor", "UIElementalSlides_Live"."ContentColor", "UIElementalSlides_Live"."BlendMode", "UIElementalSlides_Live"."ImageID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName"
FROM "Element_Live" LEFT JOIN "UIElementalSlides_Live" ON "UIElementalSlides_Live"."ID" = "Element_Live"."ID" INNER JOIN "UIElementalCarousels_Slides" ON "UIElementalCarousels_Slides"."UIElementalSlidesID" = "Element_Live"."ID"
WHERE ("UIElementalCarousels_Slides"."UIElementalCarouselsID" = ?)
AND (("UIElementalSlides_Live"."Active" != ? OR "UIElementalSlides_Live"."Active" IS NULL))
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "UIElementalSlides_Live"."SortOrder" ASC
0.0016s
0107: 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
0108: 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
0109: 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
0110: 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
0111: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."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
0112: 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
0113: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "UIElementalSpacer_Live"."Spacing", "UIElementalSpacer_Live"."CollapseSpace", "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 "UIElementalSpacer_Live" ON "UIElementalSpacer_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0003s
0114: SELECT DISTINCT count(DISTINCT "ElementalStyleProperties"."ID") AS "Count"
FROM "ElementalStyleProperties"
WHERE ("StyleOwnerClass" IN ('RS\\Elemental\\Model\\UIElementalFeaturedGrid'))
AND ("ElementalStyleProperties"."StyleOwnerID" = ?)
0.0004s
0115: 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
0116: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "UIElementalFeaturedGrids_Live"."Content", "UIElementalFeaturedGrids_Live"."ColumnsPerRow", "UIElementalFeaturedGrids_Live"."Spacing", "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 "UIElementalFeaturedGrids_Live" ON "UIElementalFeaturedGrids_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0006s
0117: SELECT CASE WHEN EXISTS(SELECT *
FROM "Element_Live" LEFT JOIN "UIElementalFeatureBlocks_Live" ON "UIElementalFeatureBlocks_Live"."ID" = "Element_Live"."ID" INNER JOIN "UIElementalFeaturedGrids_Features" ON "UIElementalFeaturedGrids_Features"."UIElementalFeatureBlocksID" = "Element_Live"."ID"
WHERE ("UIElementalFeaturedGrids_Features"."UIElementalFeaturedGridsID" = ?)
AND ("UIElementalFeatureBlocks_Live"."Active" = ?)
AND ("Element_Live"."ClassName" IN (?))) THEN 1 ELSE 0 END
0.0005s
0118: SELECT DISTINCT "UIElementalFeaturedGrids_Features"."SortOrder", "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "Element_Live"."AvailableGlobally", "Element_Live"."DisplayContent", "Element_Live"."ContentPosition", "Element_Live"."ContentAlign", "Element_Live"."ElementalInlineStyles", "Element_Live"."Version", CASE WHEN "Element_Live"."ClassName" IN ('DNADesign\\Elemental\\Models\\BaseElement', 'RS\\Elemental\\Model\\UIElementalBanner', 'RS\\Elemental\\Model\\UIElementalBlogPostList', 'RS\\Elemental\\Model\\UIElementalCalendar', 'RS\\Elemental\\Model\\UIElementalCarousel', 'RS\\Elemental\\Model\\UIElementalColumn', 'RS\\Elemental\\Model\\UIElementalContent', 'RS\\Elemental\\Model\\UIElementalCrowdriffAmp', 'RS\\Elemental\\Model\\UIElementalCrowdriffGallery', 'RS\\Elemental\\Model\\UIElementalFeatureBlock', 'RS\\Elemental\\Model\\UIElementalFeaturedGrid', 'RS\\Elemental\\Model\\UIElementalGallery', 'RS\\Elemental\\Model\\UIElementalGrid', 'RS\\Elemental\\Model\\UIElementalPageHeader', 'RS\\Elemental\\Model\\UIElementalRepeater', 'RS\\Elemental\\Model\\UIElementalSlide', 'RS\\Elemental\\Model\\UIElementalSpacer', '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\\UIElementalFeatureBlock') THEN "UIElementalFeatureBlocks_Live"."Title" WHEN "Element_Live"."ClassName" IN ('RS\\Elemental\\Model\\UIElementalFeatureBlock') THEN "UIElementalFeatureBlocks_Live"."Title" ELSE NULL END AS "Title", "Element_Live"."ShowTitle", "Element_Live"."Sort", "Element_Live"."ExtraClass", "Element_Live"."Style", "Element_Live"."TopPageID", "Element_Live"."ParentID", "UIElementalFeatureBlocks_Live"."Content", "UIElementalFeatureBlocks_Live"."AspectRatio", "UIElementalFeatureBlocks_Live"."Orientation", "UIElementalFeatureBlocks_Live"."Fill", "UIElementalFeatureBlocks_Live"."Active", "UIElementalFeatureBlocks_Live"."ImageID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName"
FROM "Element_Live" LEFT JOIN "UIElementalFeatureBlocks_Live" ON "UIElementalFeatureBlocks_Live"."ID" = "Element_Live"."ID" INNER JOIN "UIElementalFeaturedGrids_Features" ON "UIElementalFeaturedGrids_Features"."UIElementalFeatureBlocksID" = "Element_Live"."ID"
WHERE ("UIElementalFeaturedGrids_Features"."UIElementalFeaturedGridsID" = ?)
AND ("UIElementalFeatureBlocks_Live"."Active" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "SortOrder" ASC
0.0012s
0119: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."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
0120: SELECT DISTINCT "UIElementalFeatureBlocks_Buttons"."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 "UIElementalFeatureBlocks_Buttons" ON "UIElementalFeatureBlocks_Buttons"."LinkID" = "Link"."ID"
WHERE ("UIElementalFeatureBlocks_Buttons"."UIElementalFeatureBlocksID" = ?)
LIMIT 1
0.0011s
0121: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "UIElementalFeatureBlocks_Buttons" ON "UIElementalFeatureBlocks_Buttons"."LinkID" = "Link"."ID"
WHERE ("UIElementalFeatureBlocks_Buttons"."UIElementalFeatureBlocksID" = ?)
0.0004s
0122: SELECT DISTINCT "UIElementalFeatureBlocks_Buttons"."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 "UIElementalFeatureBlocks_Buttons" ON "UIElementalFeatureBlocks_Buttons"."LinkID" = "Link"."ID"
WHERE ("UIElementalFeatureBlocks_Buttons"."UIElementalFeatureBlocksID" = ?)
0.0008s
0123: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."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
0124: SELECT DISTINCT "UIElementalFeatureBlocks_Buttons"."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 "UIElementalFeatureBlocks_Buttons" ON "UIElementalFeatureBlocks_Buttons"."LinkID" = "Link"."ID"
WHERE ("UIElementalFeatureBlocks_Buttons"."UIElementalFeatureBlocksID" = ?)
LIMIT 1
0.0011s
0125: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "UIElementalFeatureBlocks_Buttons" ON "UIElementalFeatureBlocks_Buttons"."LinkID" = "Link"."ID"
WHERE ("UIElementalFeatureBlocks_Buttons"."UIElementalFeatureBlocksID" = ?)
0.0005s
0126: SELECT DISTINCT "UIElementalFeatureBlocks_Buttons"."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 "UIElementalFeatureBlocks_Buttons" ON "UIElementalFeatureBlocks_Buttons"."LinkID" = "Link"."ID"
WHERE ("UIElementalFeatureBlocks_Buttons"."UIElementalFeatureBlocksID" = ?)
0.0009s
0127: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."AltText", "Image_Live"."Caption", "Image_Live"."Credit", "Image_Live"."Copyright", "Image_Live"."Description", "Image_Live"."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
0128: SELECT DISTINCT "UIElementalFeatureBlocks_Buttons"."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 "UIElementalFeatureBlocks_Buttons" ON "UIElementalFeatureBlocks_Buttons"."LinkID" = "Link"."ID"
WHERE ("UIElementalFeatureBlocks_Buttons"."UIElementalFeatureBlocksID" = ?)
LIMIT 1
0.0011s
0129: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "UIElementalFeatureBlocks_Buttons" ON "UIElementalFeatureBlocks_Buttons"."LinkID" = "Link"."ID"
WHERE ("UIElementalFeatureBlocks_Buttons"."UIElementalFeatureBlocksID" = ?)
0.0005s
0130: SELECT DISTINCT "UIElementalFeatureBlocks_Buttons"."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 "UIElementalFeatureBlocks_Buttons" ON "UIElementalFeatureBlocks_Buttons"."LinkID" = "Link"."ID"
WHERE ("UIElementalFeatureBlocks_Buttons"."UIElementalFeatureBlocksID" = ?)
0.0009s
0131: SELECT DISTINCT count(DISTINCT "Resources"."ID") AS "Count"
FROM "Resources" INNER JOIN "ImpactPoints_Resources" ON "ImpactPoints_Resources"."ResourcesID" = "Resources"."ID"
WHERE ("ImpactPoints_Resources"."ImpactPointsID" = ?)
0.0005s
0132: SELECT DISTINCT "Resources"."ClassName", "Resources"."LastEdited", "Resources"."Created", "Resources"."Title", "Resources"."URLSegment", "Resources"."Content", "Resources"."SortOrder", "Resources"."ImageID", "Resources"."ID",
CASE WHEN "Resources"."ClassName" IS NOT NULL THEN "Resources"."ClassName"
ELSE 'RS\\Model\\Resource' END AS "RecordClassName"
FROM "Resources" INNER JOIN "ImpactPoints_Resources" ON "ImpactPoints_Resources"."ResourcesID" = "Resources"."ID"
WHERE ("ImpactPoints_Resources"."ImpactPointsID" = ?)
ORDER BY "Resources"."SortOrder" ASC
0.001s
0133: 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
0134: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "Resources_Links" ON "Resources_Links"."LinkID" = "Link"."ID"
WHERE ("Resources_Links"."ResourcesID" = ?)
0.0005s
0135: SELECT DISTINCT "Resources_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 "Resources_Links" ON "Resources_Links"."LinkID" = "Link"."ID"
WHERE ("Resources_Links"."ResourcesID" = ?)
0.0012s
0136: 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
0137: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "Resources_Links" ON "Resources_Links"."LinkID" = "Link"."ID"
WHERE ("Resources_Links"."ResourcesID" = ?)
0.0004s
0138: SELECT DISTINCT "Resources_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 "Resources_Links" ON "Resources_Links"."LinkID" = "Link"."ID"
WHERE ("Resources_Links"."ResourcesID" = ?)
0.001s
0139: 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
0140: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "Resources_Links" ON "Resources_Links"."LinkID" = "Link"."ID"
WHERE ("Resources_Links"."ResourcesID" = ?)
0.0006s
0141: SELECT DISTINCT "Resources_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 "Resources_Links" ON "Resources_Links"."LinkID" = "Link"."ID"
WHERE ("Resources_Links"."ResourcesID" = ?)
0.001s
0142: 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
0143: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "Resources_Links" ON "Resources_Links"."LinkID" = "Link"."ID"
WHERE ("Resources_Links"."ResourcesID" = ?)
0.0004s
0144: SELECT DISTINCT "Resources_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 "Resources_Links" ON "Resources_Links"."LinkID" = "Link"."ID"
WHERE ("Resources_Links"."ResourcesID" = ?)
0.0009s
0145: 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
0146: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "Resources_Links" ON "Resources_Links"."LinkID" = "Link"."ID"
WHERE ("Resources_Links"."ResourcesID" = ?)
0.0005s
0147: SELECT DISTINCT "Resources_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 "Resources_Links" ON "Resources_Links"."LinkID" = "Link"."ID"
WHERE ("Resources_Links"."ResourcesID" = ?)
0.0009s
0148: 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
0149: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "Resources_Links" ON "Resources_Links"."LinkID" = "Link"."ID"
WHERE ("Resources_Links"."ResourcesID" = ?)
0.0005s
0150: SELECT DISTINCT "Resources_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 "Resources_Links" ON "Resources_Links"."LinkID" = "Link"."ID"
WHERE ("Resources_Links"."ResourcesID" = ?)
0.0011s
0151: 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
0152: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "Resources_Links" ON "Resources_Links"."LinkID" = "Link"."ID"
WHERE ("Resources_Links"."ResourcesID" = ?)
0.0005s
0153: SELECT DISTINCT "Resources_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 "Resources_Links" ON "Resources_Links"."LinkID" = "Link"."ID"
WHERE ("Resources_Links"."ResourcesID" = ?)
0.0013s
0154: 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
0155: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "Resources_Links" ON "Resources_Links"."LinkID" = "Link"."ID"
WHERE ("Resources_Links"."ResourcesID" = ?)
0.0006s
0156: SELECT DISTINCT "Resources_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 "Resources_Links" ON "Resources_Links"."LinkID" = "Link"."ID"
WHERE ("Resources_Links"."ResourcesID" = ?)
0.0011s
0157: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "Element_Live"."AvailableGlobally", "Element_Live"."DisplayContent", "Element_Live"."ContentPosition", "Element_Live"."ContentAlign", "Element_Live"."ElementalInlineStyles", "Element_Live"."Version", "Element_Live"."Title", "Element_Live"."ShowTitle", "Element_Live"."Sort", "Element_Live"."ExtraClass", "Element_Live"."Style", "Element_Live"."TopPageID", "Element_Live"."ParentID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName"
FROM "Element_Live"
WHERE ("Element_Live"."ID" = ?)
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0005s
0158: 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
0159: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "SiteTree_Live"."ParentID", "Page_Live"."SSLayoutTemplate", "Page_Live"."SSLayoutClasses", "ElementalPage_Live"."ElementalAreaID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "ElementalPage_Live" ON "ElementalPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("ElementalPage_Live"."ElementalAreaID" = ?)
AND ("SiteTree_Live"."ClassName" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0014s
0160: 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
0161: 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
0162: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "UIElementalBanners_Live"."Content", "UIElementalBanners_Live"."Opacity", "UIElementalBanners_Live"."BGColor", "UIElementalBanners_Live"."ContentColor", "UIElementalBanners_Live"."BlendMode", "UIElementalBanners_Live"."ImageID", CASE WHEN "Element_Live"."ClassName" IN ('DNADesign\\Elemental\\Models\\BaseElement', 'RS\\Elemental\\Model\\UIElementalBanner', 'RS\\Elemental\\Model\\UIElementalBlogPostList', 'RS\\Elemental\\Model\\UIElementalCalendar', 'RS\\Elemental\\Model\\UIElementalCarousel', 'RS\\Elemental\\Model\\UIElementalColumn', 'RS\\Elemental\\Model\\UIElementalContent', 'RS\\Elemental\\Model\\UIElementalCrowdriffAmp', 'RS\\Elemental\\Model\\UIElementalCrowdriffGallery', 'RS\\Elemental\\Model\\UIElementalFeatureBlock', 'RS\\Elemental\\Model\\UIElementalFeaturedGrid', 'RS\\Elemental\\Model\\UIElementalGallery', 'RS\\Elemental\\Model\\UIElementalGrid', 'RS\\Elemental\\Model\\UIElementalPageHeader', 'RS\\Elemental\\Model\\UIElementalRepeater', 'RS\\Elemental\\Model\\UIElementalSlide', 'RS\\Elemental\\Model\\UIElementalSpacer', '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\\UIElementalBanner') THEN "UIElementalBanners_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 "UIElementalBanners_Live" ON "UIElementalBanners_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0007s
0163: 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
0164: SELECT DISTINCT count(DISTINCT "ElementalStyleProperties"."ID") AS "Count"
FROM "ElementalStyleProperties"
WHERE ("StyleOwnerClass" IN ('RS\\Elemental\\Model\\UIElementalBanner'))
AND ("ElementalStyleProperties"."StyleOwnerID" = ?)
0.0005s
0165: SELECT DISTINCT "UIElementalBanners_Buttons"."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 "UIElementalBanners_Buttons" ON "UIElementalBanners_Buttons"."LinkID" = "Link"."ID"
WHERE ("UIElementalBanners_Buttons"."UIElementalBannersID" = ?)
LIMIT 1
0.0008s
0166: SELECT DISTINCT "UIContentCollections"."ClassName", "UIContentCollections"."LastEdited", "UIContentCollections"."Created", "UIContentCollections"."Title", "UIContentCollections"."Key", "UIContentCollections"."Description", "UIContentCollections"."Active", "UIContentCollections"."ID",
CASE WHEN "UIContentCollections"."ClassName" IS NOT NULL THEN "UIContentCollections"."ClassName"
ELSE 'RS\\NavBuilder\\Model\\UIContentCollection' END AS "RecordClassName"
FROM "UIContentCollections"
WHERE ("UIContentCollections"."Key" = ?)
AND ("UIContentCollections"."Active" = ?)
LIMIT 1
0.0005s
0167: 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.0004s
0168: SELECT DISTINCT "UIContent"."ClassName", "UIContent"."LastEdited", "UIContent"."Created", "UIContent"."Title", "UIContent"."Content", "UIContent"."Key", "UIContent"."Active", "UIContent"."SortOrder", "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.0011s
0169: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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
0170: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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
0171: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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
0172: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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
0173: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0009s
0174: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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
0175: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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
0176: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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
0177: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0004s
0178: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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
0179: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0003s
0180: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0003s
0181: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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
0182: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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
0183: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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
0184: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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
0185: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ImageID", "SiteTree_Live"."OGImageID", "SiteTree_Live"."BGVideoPosterID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0003s
0186: SELECT DISTINCT "LeadSources"."ClassName", "LeadSources"."LastEdited", "LeadSources"."Created", "LeadSources"."Title", "LeadSources"."Key", "LeadSources"."ListID", "LeadSources"."SendNotifications", "LeadSources"."ForceEmailThreading", "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
0187: SELECT DISTINCT "LeadSources"."ClassName", "LeadSources"."LastEdited", "LeadSources"."Created", "LeadSources"."Title", "LeadSources"."Key", "LeadSources"."ListID", "LeadSources"."SendNotifications", "LeadSources"."ForceEmailThreading", "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
0188: 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
0189: 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" = ?)
0.0006s
0190: SELECT DISTINCT "LeadSources"."ClassName", "LeadSources"."LastEdited", "LeadSources"."Created", "LeadSources"."Title", "LeadSources"."Key", "LeadSources"."ListID", "LeadSources"."SendNotifications", "LeadSources"."ForceEmailThreading", "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
0191: SELECT DISTINCT "LeadSources"."ClassName", "LeadSources"."LastEdited", "LeadSources"."Created", "LeadSources"."Title", "LeadSources"."Key", "LeadSources"."ListID", "LeadSources"."SendNotifications", "LeadSources"."ForceEmailThreading", "LeadSources"."SortOrder", "LeadSources"."ContentID", "LeadSources"."ID",
CASE WHEN "LeadSources"."ClassName" IS NOT NULL THEN "LeadSources"."ClassName"
ELSE 'RS\\Model\\LeadSource' END AS "RecordClassName"
FROM "LeadSources"
WHERE ("LeadSources"."ID" = ?)
LIMIT 1
0.0003s
0192: 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
0193: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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', 'CalendarPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'HomePage', 'ImpactPage', 'LeadCapturePage', 'PartnerPage', 'ResourcePage', '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', 'CalendarPage', 'CookiePolicyPage', 'ElementalPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'HomePage', 'ImpactPage', 'LeadCapturePage', 'PartnerPage', 'ResourcePage', '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.002s
0194: SELECT "Version" FROM "SiteTree" WHERE "ID" = ?
0.0004s
0195: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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
0196: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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
0197: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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
0198: SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", "SiteTree"."Priority", "SiteTree"."Title", "SiteTree"."SearchContent", "SiteTree"."Keywords", "SiteTree"."ShowInSearch", "SiteTree"."Weight", "SiteTree"."OGTitle", "SiteTree"."OGType", "SiteTree"."OGDescription", "SiteTree"."BGVideoURL", "SiteTree"."BGVideoType", "SiteTree"."BGVideoID", "SiteTree"."BGVideoStatus", "SiteTree"."BGVideoDelay", "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
0199: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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
0200: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."Title", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Keywords", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Weight", "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"."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
Impact Point: Human-Wildlife Conflict - DLITD | Don't Love It To Death
Human-Wildlife Conflict
Average number of bears euthanized in BC every year due to human-wildlife conflict.
570
BC Parks reservations impacted by bear closures in 2022
814
What is YOUR Impact?
Has a trail or park near you been temporarily closed due to human-wildlife conflict? Bears, coyotes, and cougars may frequently appear in the media headlines, but poor human behaviour is to blame. If we don’t make changes, we might lose everything. We need wildlife to remain wild.
A Fatal Attraction
Don’t be the reason a bear (or any animal) loses its life. On average, approximately 570 black bears and 22 grizzlies are “destroyed” by humans per year in British Columbia, with countless other species suffering the same fate.
Wild animals are driven by their keen sense of smell, so leaving attractants out (like bird seed, food, scented toiletries or garbage) is an open invitation. When animals venture into human spaces, it can create dangerous conflicts, sometimes resulting in injury or death to the wildlife, and occasionally, humans.
Pets and Humans Getting Too Close
The BC wilderness is home to many creatures from the animal kingdom, whether they be furry, scaly, feathered or finned. Wild animals see your dog as a predator and can become easily distressed. So, please be considerate and leash your dog.
You can also have negative impacts on wildlife. Entering sensitive habitats (such as salmon spawning streams and rivers) can threaten their natural behaviour and contaminate or destroy the only home they’ve ever known.
It’s time to protect our fellow beings. We share our communities and favourite nature spots with fauna, large and small, and must learn to respect their habitats by reducing attractants, keeping your distance from sensitive ecosystems and not feeding wild animals.
Educate yourself about how to reduce your impact on wildlife.
Things You Can Do Right Now
1 Be Bear Aware and Whale Wise
Understand what it takes to ensure that you are safe and wildlife isn't impacted or killed by carelessness.
2 Reduce Wildlife Attractants at Home or While Travelling
Wild animals have a keen sense of smell and could become habituated to human attractants. Store food, garbage and scented items safely to avoid attracting wildlife.
3 Leave your dog at home or keep them leashed
Your best friend may love you, but they may find out they love chasing wildlife even better. Keep Fido, fellow travellers, and wildlife safe by leaving your dog at home or keeping them on leash (unless in a designated off-leash area).
4 Keep a safe distance from wildlife and don’t feed or approach them for photos
Remember: A fed bear is a dead bear. Let’s keep wildlife wild. Avoid feeding wildlife at all costs to keep both animals and humans safe from conflict.
5 Do not violate or enter sensitive habitats
Sure, getting a bit closer might make for a good photo, but trampling nature to get there isn't cool. Don't wreck habitats. Stick to the trail. Period.
The following organizations offer a series of useful tips on how to minimize your footprint and enjoy the outdoors in a responsible and sustainable way.
The Don't Love it to Death campaign acknowledges the ancestral territories of the First Nations peoples on which we humbly live, work and recreate on.
We strive to respect the land and people whose territory we are visiting. We also commit to creating meaningful and lasting relationships to assist in amplifying the voices of the First Nations people through our learning experiences/journeys.
This website uses cookies
This website or its third-party tools use cookies, which are necessary for its functioning and required to achieve the purposes illustrated in the cookie policy. You accept the use of cookies by closing or dismissing this notice, by clicking a link or button or by continuing to browse otherwise.