0002: SHOW DATABASES LIKE 'essentials\_demo'
0.0011s
0003: SHOW FULL TABLES WHERE Table_Type != 'VIEW'
0.006s
0004: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaCanonicalURL", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."MetaImageID", "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.0045s
0006: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."ShowSharingLinks", "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"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0012s
0007: SELECT DISTINCT "SiteTree_Versions"."ClassName", "SiteTree_Versions"."LastEdited", "SiteTree_Versions"."Created", "SiteTree_Versions"."Priority", "SiteTree_Versions"."ShareTokenSalt", "SiteTree_Versions"."MetaTitle", "SiteTree_Versions"."MetaCanonicalURL", "SiteTree_Versions"."CanViewType", "SiteTree_Versions"."CanEditType", "SiteTree_Versions"."Version", "SiteTree_Versions"."URLSegment", "SiteTree_Versions"."Title", "SiteTree_Versions"."MenuTitle", "SiteTree_Versions"."Content", "SiteTree_Versions"."MetaDescription", "SiteTree_Versions"."ExtraMeta", "SiteTree_Versions"."ShowInMenus", "SiteTree_Versions"."ShowInSearch", "SiteTree_Versions"."Sort", "SiteTree_Versions"."HasBrokenFile", "SiteTree_Versions"."HasBrokenLink", "SiteTree_Versions"."ReportClass", "SiteTree_Versions"."MetaImageID", "SiteTree_Versions"."ParentID", "SiteTree_Versions"."ID",
CASE WHEN "SiteTree_Versions"."ClassName" IS NOT NULL THEN "SiteTree_Versions"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", "SiteTree_Versions"."RecordID", "SiteTree_Versions"."WasPublished", "SiteTree_Versions"."WasDeleted", "SiteTree_Versions"."WasDraft", "SiteTree_Versions"."AuthorID", "SiteTree_Versions"."PublisherID"
FROM "SiteTree_Versions"
WHERE ("SiteTree_Versions"."RecordID" = ?)
ORDER BY "SiteTree_Versions"."LastEdited" DESC, "SiteTree_Versions"."Version" DESC
0.0014s
0008: SELECT DISTINCT "Notification_Violator_Live"."ClassName", "Notification_Violator_Live"."LastEdited", "Notification_Violator_Live"."Created", "Notification_Violator_Live"."StartTime", "Notification_Violator_Live"."EndTime", "Notification_Violator_Live"."Version", "Notification_Violator_Live"."Title", "Notification_Violator_Live"."Content", "Notification_Violator_Live"."Sort", "Notification_Violator_Live"."ShowOnce", "Notification_Violator_Live"."CookieName", "Notification_Violator_Live"."ID",
CASE WHEN "Notification_Violator_Live"."ClassName" IS NOT NULL THEN "Notification_Violator_Live"."ClassName"
ELSE 'Dynamic\\Notifications\\Model\\Violator' END AS "RecordClassName"
FROM "Notification_Violator_Live"
ORDER BY "Notification_Violator_Live"."Sort" ASC
0.0069s
0009: SELECT DISTINCT "Notification_PopUp_Live"."ClassName", "Notification_PopUp_Live"."LastEdited", "Notification_PopUp_Live"."Created", "Notification_PopUp_Live"."StartTime", "Notification_PopUp_Live"."EndTime", "Notification_PopUp_Live"."Version", "Notification_PopUp_Live"."Title", "Notification_PopUp_Live"."Content", "Notification_PopUp_Live"."ShowOnce", "Notification_PopUp_Live"."CookieName", "Notification_PopUp_Live"."ImageID", "Notification_PopUp_Live"."ContentLinkID", "Notification_PopUp_Live"."ID",
CASE WHEN "Notification_PopUp_Live"."ClassName" IS NOT NULL THEN "Notification_PopUp_Live"."ClassName"
ELSE 'Dynamic\\Notifications\\Model\\PopUp' END AS "RecordClassName"
FROM "Notification_PopUp_Live"
WHERE ("Notification_PopUp_Live"."StartTime" <= ?)
AND ("Notification_PopUp_Live"."EndTime" >= ?)
0.0008s
0010: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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"."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.0011s
0011: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaCanonicalURL", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."MetaImageID", "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"."ShowInMenus" = ?)
AND ("SiteTree_Live"."ParentID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
0.0013s
0012: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaCanonicalURL", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."MetaImageID", "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" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
0.0011s
0013: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaCanonicalURL", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."MetaImageID", "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
0014: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaCanonicalURL", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."MetaImageID", "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" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
0.001s
0015: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaCanonicalURL", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."MetaImageID", "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" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
0.0012s
0016: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaCanonicalURL", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."MetaImageID", "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" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
0.0014s
0017: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaCanonicalURL", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."MetaImageID", "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" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
0.0014s
0018: SELECT CASE WHEN EXISTS(SELECT *
FROM "LinkField_Link_Live"
WHERE ("LinkField_Link_Live"."OwnerClass" IN ('SilverStripe\\SiteConfig\\SiteConfig'))
AND ("LinkField_Link_Live"."OwnerRelation" = ?)
AND ("LinkField_Link_Live"."OwnerID" = ?)) THEN 1 ELSE 0 END
0.0009s
0019: SELECT DISTINCT "LinkField_Link_Live"."ClassName", "LinkField_Link_Live"."LastEdited", "LinkField_Link_Live"."Created", "LinkField_Link_Live"."ExtraClass", "LinkField_Link_Live"."Style", "LinkField_Link_Live"."Version", "LinkField_Link_Live"."LinkText", "LinkField_Link_Live"."OpenInNew", "LinkField_Link_Live"."Sort", "LinkField_Link_Live"."IconID", "LinkField_Link_Live"."OwnerID", "LinkField_Link_Live"."OwnerClass", "LinkField_Link_Live"."OwnerRelation", "LinkField_Link_Live"."ID",
CASE WHEN "LinkField_Link_Live"."ClassName" IS NOT NULL THEN "LinkField_Link_Live"."ClassName"
ELSE 'SilverStripe\\LinkField\\Models\\Link' END AS "RecordClassName"
FROM "LinkField_Link_Live"
WHERE ("LinkField_Link_Live"."OwnerClass" IN ('SilverStripe\\SiteConfig\\SiteConfig'))
AND ("LinkField_Link_Live"."OwnerRelation" = ?)
AND ("LinkField_Link_Live"."OwnerID" = ?)
ORDER BY "LinkField_Link_Live"."Sort" ASC
0.0008s
0020: SELECT DISTINCT "LinkField_Link_Live"."ClassName", "LinkField_Link_Live"."LastEdited", "LinkField_Link_Live"."Created", "LinkField_SiteTreeLink_Live"."Anchor", "LinkField_SiteTreeLink_Live"."QueryString", "LinkField_SiteTreeLink_Live"."PageID", "LinkField_Link_Live"."ID",
CASE WHEN "LinkField_Link_Live"."ClassName" IS NOT NULL THEN "LinkField_Link_Live"."ClassName"
ELSE 'SilverStripe\\LinkField\\Models\\Link' END AS "RecordClassName", "LinkField_Link_Live"."Sort"
FROM "LinkField_Link_Live" LEFT JOIN "LinkField_SiteTreeLink_Live" ON "LinkField_SiteTreeLink_Live"."ID" = "LinkField_Link_Live"."ID"
WHERE ("LinkField_Link_Live"."ID" = ?)
AND ("LinkField_Link_Live"."ClassName" IN (?))
ORDER BY "LinkField_Link_Live"."Sort" ASC
LIMIT 1
0.001s
0021: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaCanonicalURL", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."MetaImageID", "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
0022: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "BlockPage_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 "BlockPage_Live" ON "BlockPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0026s
0023: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.007s
0024: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "Element_Live"."AvailableGlobally", "Element_Live"."VirtualLookupTitle", "Element_Live"."TopTitle", "Element_Live"."BackgroundColor", "Element_Live"."TopPadding", "Element_Live"."BottomPadding", "Element_Live"."TopMargin", "Element_Live"."BottomMargin", "Element_Live"."RoundedTop", "Element_Live"."RoundedRight", "Element_Live"."RoundedBottom", "Element_Live"."RoundedLeft", "Element_Live"."RoundedMDTop", "Element_Live"."RoundedMDRight", "Element_Live"."RoundedMDBottom", "Element_Live"."RoundedMDLeft", "Element_Live"."UnsetBackgroundColor", "Element_Live"."ImgRoundedTop", "Element_Live"."ImgRoundedRight", "Element_Live"."ImgRoundedBottom", "Element_Live"."ImgRoundedLeft", "Element_Live"."ImageWidth", "Element_Live"."ContentSize", "Element_Live"."ButtonColor", "Element_Live"."DisableImageCrop", "Element_Live"."TopPaddingXS", "Element_Live"."BottomPaddingXS", "Element_Live"."TopPaddingSM", "Element_Live"."BottomPaddingSM", "Element_Live"."TopPaddingMD", "Element_Live"."BottomPaddingMD", "Element_Live"."TopPaddingLG", "Element_Live"."BottomPaddingLG", "Element_Live"."TopPaddingXL", "Element_Live"."BottomPaddingXL", "Element_Live"."TopMarginXS", "Element_Live"."BottomMarginXS", "Element_Live"."TopMarginSM", "Element_Live"."BottomMarginSM", "Element_Live"."TopMarginMD", "Element_Live"."BottomMarginMD", "Element_Live"."TopMarginLG", "Element_Live"."BottomMarginLG", "Element_Live"."TopMarginXL", "Element_Live"."BottomMarginXL", "Element_Live"."SizeXS", "Element_Live"."SizeSM", "Element_Live"."SizeMD", "Element_Live"."SizeLG", "Element_Live"."SizeXL", "Element_Live"."OffsetXS", "Element_Live"."OffsetSM", "Element_Live"."OffsetMD", "Element_Live"."OffsetLG", "Element_Live"."OffsetXL", "Element_Live"."VisibilityXS", "Element_Live"."VisibilitySM", "Element_Live"."VisibilityMD", "Element_Live"."VisibilityLG", "Element_Live"."VisibilityXL", "Element_Live"."TitleClass", "Element_Live"."TitleTag", "Element_Live"."Version", "Element_Live"."Title", "Element_Live"."ShowTitle", "Element_Live"."Sort", "Element_Live"."ExtraClass", "Element_Live"."Style", "Element_Live"."BackgroundImageID", "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.0021s
0025: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0022s
0026: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaCanonicalURL", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."MetaImageID", "SiteTree_Live"."ParentID", "Page_Live"."ShowSharingLinks", "BlockPage_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 "BlockPage_Live" ON "BlockPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("BlockPage_Live"."ElementalAreaID" = ?)
AND ("SiteTree_Live"."ClassName" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0025s
0027: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementContent_Live"."ContentAlign", "ElementContent_Live"."ContentColumns", "ElementContent_Live"."ContentVerticalAlign", "ElementContent_Live"."ExtraColumnGap", "ElementContent_Live"."MediaType", "ElementContent_Live"."MediaCaption", "ElementContent_Live"."MediaRatio", "ElementContent_Live"."MediaPosition", "ElementContent_Live"."MediaVideoFullURL", "ElementContent_Live"."MediaVideoProvider", "ElementContent_Live"."MediaVideoHasOverlay", "ElementContent_Live"."MediaVideoEmbeddedName", "ElementContent_Live"."MediaVideoEmbeddedURL", "ElementContent_Live"."MediaVideoEmbeddedDescription", "ElementContent_Live"."MediaVideoEmbeddedThumbnail", "ElementContent_Live"."MediaVideoEmbeddedCreated", "ElementContent_Live"."HTML", "ElementContent_Live"."ElementLinkID", "ElementContent_Live"."MediaImageMobileID", "ElementContent_Live"."MediaImageID", "ElementContent_Live"."MediaVideoCustomThumbnailID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementContent_Live" ON "ElementContent_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?, ?, ?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0011s
0028: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementContent_Live"."ContentAlign", "ElementContent_Live"."ContentColumns", "ElementContent_Live"."ContentVerticalAlign", "ElementContent_Live"."ExtraColumnGap", "ElementContent_Live"."MediaType", "ElementContent_Live"."MediaCaption", "ElementContent_Live"."MediaRatio", "ElementContent_Live"."MediaPosition", "ElementContent_Live"."MediaVideoFullURL", "ElementContent_Live"."MediaVideoProvider", "ElementContent_Live"."MediaVideoHasOverlay", "ElementContent_Live"."MediaVideoEmbeddedName", "ElementContent_Live"."MediaVideoEmbeddedURL", "ElementContent_Live"."MediaVideoEmbeddedDescription", "ElementContent_Live"."MediaVideoEmbeddedThumbnail", "ElementContent_Live"."MediaVideoEmbeddedCreated", "ElementContent_Live"."HTML", "ElementContent_Live"."ElementLinkID", "ElementContent_Live"."MediaImageMobileID", "ElementContent_Live"."MediaImageID", "ElementContent_Live"."MediaVideoCustomThumbnailID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementContent_Live" ON "ElementContent_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?, ?, ?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0011s
0029: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0008s
0030: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementRow_Live"."BackgroundFullWidth", "ElementRow_Live"."IsFluid", "ElementRow_Live"."CustomSectionClass", "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 "ElementRow_Live" ON "ElementRow_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0009s
0031: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementHeroMedia_Live"."MediaType", "ElementHeroMedia_Live"."AutoPlay", "ElementHeroMedia_Live"."Cinematic", "ElementHeroMedia_Live"."Content", "ElementHeroMedia_Live"."ImageID", "ElementHeroMedia_Live"."ImageMobileID", "ElementHeroMedia_Live"."VideoID", "ElementHeroMedia_Live"."EmbedVideoID", "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 "ElementHeroMedia_Live" ON "ElementHeroMedia_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.001s
0032: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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"."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.0009s
0033: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementRow_Live"."BackgroundFullWidth", "ElementRow_Live"."IsFluid", "ElementRow_Live"."CustomSectionClass", "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 "ElementRow_Live" ON "ElementRow_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0009s
0034: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementAccordion_Live"."OpenFirstPanel", "ElementAccordion_Live"."Content", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementAccordion_Live" ON "ElementAccordion_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0008s
0035: SELECT CASE WHEN EXISTS(SELECT *
FROM "BaseElementObject_Live" LEFT JOIN "AccordionPanel_Live" ON "AccordionPanel_Live"."ID" = "BaseElementObject_Live"."ID"
WHERE ("AccordionPanel_Live"."AccordionID" = ?)
AND ("BaseElementObject_Live"."ClassName" IN (?))) THEN 1 ELSE 0 END
0.0009s
0036: SELECT DISTINCT "BaseElementObject_Live"."ClassName", "BaseElementObject_Live"."LastEdited", "BaseElementObject_Live"."Created", "BaseElementObject_Live"."Version", "BaseElementObject_Live"."Title", "BaseElementObject_Live"."ShowTitle", "BaseElementObject_Live"."Content", "BaseElementObject_Live"."ImageID", "BaseElementObject_Live"."ElementLinkID", "AccordionPanel_Live"."Sort", "AccordionPanel_Live"."AccordionID", "BaseElementObject_Live"."ID",
CASE WHEN "BaseElementObject_Live"."ClassName" IS NOT NULL THEN "BaseElementObject_Live"."ClassName"
ELSE 'Dynamic\\BaseObject\\Model\\BaseElementObject' END AS "RecordClassName"
FROM "BaseElementObject_Live" LEFT JOIN "AccordionPanel_Live" ON "AccordionPanel_Live"."ID" = "BaseElementObject_Live"."ID"
WHERE ("AccordionPanel_Live"."AccordionID" = ?)
AND ("BaseElementObject_Live"."ClassName" IN (?))
ORDER BY "AccordionPanel_Live"."Sort" ASC
0.0009s
0037: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.001s
0038: SELECT DISTINCT "LinkField_Link_Live"."ClassName", "LinkField_Link_Live"."LastEdited", "LinkField_Link_Live"."Created", "LinkField_Link_Live"."ExtraClass", "LinkField_Link_Live"."Style", "LinkField_Link_Live"."Version", "LinkField_Link_Live"."LinkText", "LinkField_Link_Live"."OpenInNew", "LinkField_Link_Live"."Sort", "LinkField_Link_Live"."IconID", "LinkField_Link_Live"."OwnerID", "LinkField_Link_Live"."OwnerClass", "LinkField_Link_Live"."OwnerRelation", "LinkField_Link_Live"."ID",
CASE WHEN "LinkField_Link_Live"."ClassName" IS NOT NULL THEN "LinkField_Link_Live"."ClassName"
ELSE 'SilverStripe\\LinkField\\Models\\Link' END AS "RecordClassName"
FROM "LinkField_Link_Live"
WHERE ("LinkField_Link_Live"."ID" = ?)
ORDER BY "LinkField_Link_Live"."Sort" ASC
LIMIT 1
0.001s
0039: SELECT DISTINCT "LinkField_Link_Live"."ClassName", "LinkField_Link_Live"."LastEdited", "LinkField_Link_Live"."Created", "LinkField_ExternalLink_Live"."ExternalUrl", "LinkField_Link_Live"."ID",
CASE WHEN "LinkField_Link_Live"."ClassName" IS NOT NULL THEN "LinkField_Link_Live"."ClassName"
ELSE 'SilverStripe\\LinkField\\Models\\Link' END AS "RecordClassName", "LinkField_Link_Live"."Sort"
FROM "LinkField_Link_Live" LEFT JOIN "LinkField_ExternalLink_Live" ON "LinkField_ExternalLink_Live"."ID" = "LinkField_Link_Live"."ID"
WHERE ("LinkField_Link_Live"."ID" = ?)
AND ("LinkField_Link_Live"."ClassName" IN (?, ?))
ORDER BY "LinkField_Link_Live"."Sort" ASC
LIMIT 1
0.0008s
0040: SELECT DISTINCT "LinkField_Link_Live"."ClassName", "LinkField_Link_Live"."LastEdited", "LinkField_Link_Live"."Created", "LinkField_Link_Live"."ExtraClass", "LinkField_Link_Live"."Style", "LinkField_Link_Live"."Version", "LinkField_Link_Live"."LinkText", "LinkField_Link_Live"."OpenInNew", "LinkField_Link_Live"."Sort", "LinkField_Link_Live"."IconID", "LinkField_Link_Live"."OwnerID", "LinkField_Link_Live"."OwnerClass", "LinkField_Link_Live"."OwnerRelation", "LinkField_Link_Live"."ID",
CASE WHEN "LinkField_Link_Live"."ClassName" IS NOT NULL THEN "LinkField_Link_Live"."ClassName"
ELSE 'SilverStripe\\LinkField\\Models\\Link' END AS "RecordClassName"
FROM "LinkField_Link_Live"
WHERE ("LinkField_Link_Live"."ID" = ?)
ORDER BY "LinkField_Link_Live"."Sort" ASC
LIMIT 1
0.0009s
0041: SELECT DISTINCT "LinkField_Link_Live"."ClassName", "LinkField_Link_Live"."LastEdited", "LinkField_Link_Live"."Created", "LinkField_SiteTreeLink_Live"."Anchor", "LinkField_SiteTreeLink_Live"."QueryString", "LinkField_SiteTreeLink_Live"."PageID", "LinkField_Link_Live"."ID",
CASE WHEN "LinkField_Link_Live"."ClassName" IS NOT NULL THEN "LinkField_Link_Live"."ClassName"
ELSE 'SilverStripe\\LinkField\\Models\\Link' END AS "RecordClassName", "LinkField_Link_Live"."Sort"
FROM "LinkField_Link_Live" LEFT JOIN "LinkField_SiteTreeLink_Live" ON "LinkField_SiteTreeLink_Live"."ID" = "LinkField_Link_Live"."ID"
WHERE ("LinkField_Link_Live"."ID" = ?)
AND ("LinkField_Link_Live"."ClassName" IN (?))
ORDER BY "LinkField_Link_Live"."Sort" ASC
LIMIT 1
0.001s
0042: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaCanonicalURL", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."MetaImageID", "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
0043: SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "BlogPost_Live" ON "BlogPost_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ClassName" IN (?))
AND ("PublishDate" < '2026-02-20 09:29:09')
0.0012s
0044: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementBlogPosts_Live"."Limit", "ElementBlogPosts_Live"."Content", "ElementBlogPosts_Live"."BlogID", "ElementBlogPosts_Live"."CategoryID", "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 "ElementBlogPosts_Live" ON "ElementBlogPosts_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.001s
0045: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaCanonicalURL", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."MetaImageID", "SiteTree_Live"."ParentID", "Page_Live"."ShowSharingLinks", "Blog_Live"."PostsPerPage", "Blog_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 "Blog_Live" ON "Blog_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0011s
0046: SELECT DISTINCT "PublishDate" IS NULL AS "_SortColumn0", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaCanonicalURL", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."MetaImageID", "SiteTree_Live"."ParentID", "Page_Live"."ShowSharingLinks", "BlogPost_Live"."FeaturedInWidget", "BlogPost_Live"."PublishDate", "BlogPost_Live"."AuthorNames", "BlogPost_Live"."Summary", "BlogPost_Live"."ElementalAreaID", "BlogPost_Live"."FeaturedImageID", "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 "BlogPost_Live" ON "BlogPost_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
AND ("PublishDate" < '2026-02-20 09:29:09')
ORDER BY "SiteTree_Live"."Created" DESC
LIMIT 3
0.0017s
0047: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaCanonicalURL", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."MetaImageID", "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
0048: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaCanonicalURL", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."MetaImageID", "SiteTree_Live"."ParentID", "Page_Live"."ShowSharingLinks", "Blog_Live"."PostsPerPage", "Blog_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 "Blog_Live" ON "Blog_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.001s
0049: SELECT CASE WHEN EXISTS(SELECT *
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "BlogPost_Live" ON "BlogPost_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
AND ("PublishDate" < '2026-02-20 09:29:09')
LIMIT 3) THEN 1 ELSE 0 END
0.001s
0050: SELECT DISTINCT "PublishDate" IS NULL AS "_SortColumn0", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaCanonicalURL", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."MetaImageID", "SiteTree_Live"."ParentID", "Page_Live"."ShowSharingLinks", "BlogPost_Live"."FeaturedInWidget", "BlogPost_Live"."PublishDate", "BlogPost_Live"."AuthorNames", "BlogPost_Live"."Summary", "BlogPost_Live"."ElementalAreaID", "BlogPost_Live"."FeaturedImageID", "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 "BlogPost_Live" ON "BlogPost_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
AND ("PublishDate" < '2026-02-20 09:29:09')
ORDER BY "_SortColumn0" DESC, "BlogPost_Live"."PublishDate" DESC
LIMIT 3
0.0017s
0051: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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"."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.0011s
0052: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaCanonicalURL", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."MetaImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0008s
0053: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaCanonicalURL", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."MetaImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0008s
0054: SELECT CASE WHEN EXISTS(SELECT *
FROM "BlogCategory" INNER JOIN "BlogPost_Categories" ON "BlogPost_Categories"."BlogCategoryID" = "BlogCategory"."ID"
WHERE ("BlogPost_Categories"."BlogPostID" = ?)) THEN 1 ELSE 0 END
0.0012s
0055: SELECT CASE WHEN EXISTS(SELECT *
FROM "BlogTag" INNER JOIN "BlogPost_Tags" ON "BlogPost_Tags"."BlogTagID" = "BlogTag"."ID"
WHERE ("BlogPost_Tags"."BlogPostID" = ?)) THEN 1 ELSE 0 END
0.001s
0056: SELECT DISTINCT "Member"."ClassName", "Member"."LastEdited", "Member"."Created", "Member"."FeatureFlag_Betamask", "Member"."URLSegment", "Member"."BlogProfileSummary", "Member"."FacebookProfileURL", "Member"."TwitterHandle", "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"."BlogProfileImageID", "Member"."ID",
CASE WHEN "Member"."ClassName" IS NOT NULL THEN "Member"."ClassName"
ELSE 'SilverStripe\\Security\\Member' END AS "RecordClassName"
FROM "Member" INNER JOIN "BlogPost_Authors" ON "BlogPost_Authors"."MemberID" = "Member"."ID"
WHERE ("BlogPost_Authors"."BlogPostID" = ?)
ORDER BY "Member"."Surname" ASC, "Member"."FirstName" ASC
0.0037s
0057: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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"."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.0011s
0058: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaCanonicalURL", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."MetaImageID", "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
0059: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaCanonicalURL", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."MetaImageID", "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
0060: SELECT CASE WHEN EXISTS(SELECT *
FROM "BlogCategory" INNER JOIN "BlogPost_Categories" ON "BlogPost_Categories"."BlogCategoryID" = "BlogCategory"."ID"
WHERE ("BlogPost_Categories"."BlogPostID" = ?)) THEN 1 ELSE 0 END
0.0008s
0061: SELECT CASE WHEN EXISTS(SELECT *
FROM "BlogTag" INNER JOIN "BlogPost_Tags" ON "BlogPost_Tags"."BlogTagID" = "BlogTag"."ID"
WHERE ("BlogPost_Tags"."BlogPostID" = ?)) THEN 1 ELSE 0 END
0.0007s
0062: SELECT DISTINCT "Member"."ClassName", "Member"."LastEdited", "Member"."Created", "Member"."FeatureFlag_Betamask", "Member"."URLSegment", "Member"."BlogProfileSummary", "Member"."FacebookProfileURL", "Member"."TwitterHandle", "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"."BlogProfileImageID", "Member"."ID",
CASE WHEN "Member"."ClassName" IS NOT NULL THEN "Member"."ClassName"
ELSE 'SilverStripe\\Security\\Member' END AS "RecordClassName"
FROM "Member" INNER JOIN "BlogPost_Authors" ON "BlogPost_Authors"."MemberID" = "Member"."ID"
WHERE ("BlogPost_Authors"."BlogPostID" = ?)
ORDER BY "Member"."Surname" ASC, "Member"."FirstName" ASC
0.0009s
0063: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0008s
0064: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaCanonicalURL", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."MetaImageID", "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.001s
0065: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaCanonicalURL", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."MetaImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0008s
0066: SELECT CASE WHEN EXISTS(SELECT *
FROM "BlogCategory" INNER JOIN "BlogPost_Categories" ON "BlogPost_Categories"."BlogCategoryID" = "BlogCategory"."ID"
WHERE ("BlogPost_Categories"."BlogPostID" = ?)) THEN 1 ELSE 0 END
0.0007s
0067: SELECT CASE WHEN EXISTS(SELECT *
FROM "BlogTag" INNER JOIN "BlogPost_Tags" ON "BlogPost_Tags"."BlogTagID" = "BlogTag"."ID"
WHERE ("BlogPost_Tags"."BlogPostID" = ?)) THEN 1 ELSE 0 END
0.0007s
0068: SELECT DISTINCT "Member"."ClassName", "Member"."LastEdited", "Member"."Created", "Member"."FeatureFlag_Betamask", "Member"."URLSegment", "Member"."BlogProfileSummary", "Member"."FacebookProfileURL", "Member"."TwitterHandle", "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"."BlogProfileImageID", "Member"."ID",
CASE WHEN "Member"."ClassName" IS NOT NULL THEN "Member"."ClassName"
ELSE 'SilverStripe\\Security\\Member' END AS "RecordClassName"
FROM "Member" INNER JOIN "BlogPost_Authors" ON "BlogPost_Authors"."MemberID" = "Member"."ID"
WHERE ("BlogPost_Authors"."BlogPostID" = ?)
ORDER BY "Member"."Surname" ASC, "Member"."FirstName" ASC
0.001s
0069: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementCallToAction_Live"."CtaLinkID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementContent_Live" ON "ElementContent_Live"."ID" = "Element_Live"."ID" LEFT JOIN "ElementCallToAction_Live" ON "ElementCallToAction_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0008s
0070: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementCard_Live"."Content", "ElementCard_Live"."Position", "ElementCard_Live"."ImageID", "ElementCard_Live"."ElementLinkID", "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 "ElementCard_Live" ON "ElementCard_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.001s
0071: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0008s
0072: SELECT DISTINCT "LinkField_Link_Live"."ClassName", "LinkField_Link_Live"."LastEdited", "LinkField_Link_Live"."Created", "LinkField_Link_Live"."ExtraClass", "LinkField_Link_Live"."Style", "LinkField_Link_Live"."Version", "LinkField_Link_Live"."LinkText", "LinkField_Link_Live"."OpenInNew", "LinkField_Link_Live"."Sort", "LinkField_Link_Live"."IconID", "LinkField_Link_Live"."OwnerID", "LinkField_Link_Live"."OwnerClass", "LinkField_Link_Live"."OwnerRelation", "LinkField_Link_Live"."ID",
CASE WHEN "LinkField_Link_Live"."ClassName" IS NOT NULL THEN "LinkField_Link_Live"."ClassName"
ELSE 'SilverStripe\\LinkField\\Models\\Link' END AS "RecordClassName"
FROM "LinkField_Link_Live"
WHERE ("LinkField_Link_Live"."ID" = ?)
ORDER BY "LinkField_Link_Live"."Sort" ASC
LIMIT 1
0.0007s
0073: SELECT DISTINCT "LinkField_Link_Live"."ClassName", "LinkField_Link_Live"."LastEdited", "LinkField_Link_Live"."Created", "LinkField_SiteTreeLink_Live"."Anchor", "LinkField_SiteTreeLink_Live"."QueryString", "LinkField_SiteTreeLink_Live"."PageID", "LinkField_Link_Live"."ID",
CASE WHEN "LinkField_Link_Live"."ClassName" IS NOT NULL THEN "LinkField_Link_Live"."ClassName"
ELSE 'SilverStripe\\LinkField\\Models\\Link' END AS "RecordClassName", "LinkField_Link_Live"."Sort"
FROM "LinkField_Link_Live" LEFT JOIN "LinkField_SiteTreeLink_Live" ON "LinkField_SiteTreeLink_Live"."ID" = "LinkField_Link_Live"."ID"
WHERE ("LinkField_Link_Live"."ID" = ?)
AND ("LinkField_Link_Live"."ClassName" IN (?))
ORDER BY "LinkField_Link_Live"."Sort" ASC
LIMIT 1
0.0008s
0074: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaCanonicalURL", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."MetaImageID", "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.001s
0075: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementCard_Live"."Content", "ElementCard_Live"."Position", "ElementCard_Live"."ImageID", "ElementCard_Live"."ElementLinkID", "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 "ElementCard_Live" ON "ElementCard_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0008s
0076: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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"."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.0009s
0077: SELECT DISTINCT "LinkField_Link_Live"."ClassName", "LinkField_Link_Live"."LastEdited", "LinkField_Link_Live"."Created", "LinkField_Link_Live"."ExtraClass", "LinkField_Link_Live"."Style", "LinkField_Link_Live"."Version", "LinkField_Link_Live"."LinkText", "LinkField_Link_Live"."OpenInNew", "LinkField_Link_Live"."Sort", "LinkField_Link_Live"."IconID", "LinkField_Link_Live"."OwnerID", "LinkField_Link_Live"."OwnerClass", "LinkField_Link_Live"."OwnerRelation", "LinkField_Link_Live"."ID",
CASE WHEN "LinkField_Link_Live"."ClassName" IS NOT NULL THEN "LinkField_Link_Live"."ClassName"
ELSE 'SilverStripe\\LinkField\\Models\\Link' END AS "RecordClassName"
FROM "LinkField_Link_Live"
WHERE ("LinkField_Link_Live"."ID" = ?)
ORDER BY "LinkField_Link_Live"."Sort" ASC
LIMIT 1
0.0007s
0078: SELECT DISTINCT "LinkField_Link_Live"."ClassName", "LinkField_Link_Live"."LastEdited", "LinkField_Link_Live"."Created", "LinkField_SiteTreeLink_Live"."Anchor", "LinkField_SiteTreeLink_Live"."QueryString", "LinkField_SiteTreeLink_Live"."PageID", "LinkField_Link_Live"."ID",
CASE WHEN "LinkField_Link_Live"."ClassName" IS NOT NULL THEN "LinkField_Link_Live"."ClassName"
ELSE 'SilverStripe\\LinkField\\Models\\Link' END AS "RecordClassName", "LinkField_Link_Live"."Sort"
FROM "LinkField_Link_Live" LEFT JOIN "LinkField_SiteTreeLink_Live" ON "LinkField_SiteTreeLink_Live"."ID" = "LinkField_Link_Live"."ID"
WHERE ("LinkField_Link_Live"."ID" = ?)
AND ("LinkField_Link_Live"."ClassName" IN (?))
ORDER BY "LinkField_Link_Live"."Sort" ASC
LIMIT 1
0.0009s
0079: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaCanonicalURL", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."MetaImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0008s
0080: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementCard_Live"."Content", "ElementCard_Live"."Position", "ElementCard_Live"."ImageID", "ElementCard_Live"."ElementLinkID", "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 "ElementCard_Live" ON "ElementCard_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0008s
0081: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0008s
0082: SELECT DISTINCT "LinkField_Link_Live"."ClassName", "LinkField_Link_Live"."LastEdited", "LinkField_Link_Live"."Created", "LinkField_Link_Live"."ExtraClass", "LinkField_Link_Live"."Style", "LinkField_Link_Live"."Version", "LinkField_Link_Live"."LinkText", "LinkField_Link_Live"."OpenInNew", "LinkField_Link_Live"."Sort", "LinkField_Link_Live"."IconID", "LinkField_Link_Live"."OwnerID", "LinkField_Link_Live"."OwnerClass", "LinkField_Link_Live"."OwnerRelation", "LinkField_Link_Live"."ID",
CASE WHEN "LinkField_Link_Live"."ClassName" IS NOT NULL THEN "LinkField_Link_Live"."ClassName"
ELSE 'SilverStripe\\LinkField\\Models\\Link' END AS "RecordClassName"
FROM "LinkField_Link_Live"
WHERE ("LinkField_Link_Live"."ID" = ?)
ORDER BY "LinkField_Link_Live"."Sort" ASC
LIMIT 1
0.0006s
0083: SELECT DISTINCT "LinkField_Link_Live"."ClassName", "LinkField_Link_Live"."LastEdited", "LinkField_Link_Live"."Created", "LinkField_SiteTreeLink_Live"."Anchor", "LinkField_SiteTreeLink_Live"."QueryString", "LinkField_SiteTreeLink_Live"."PageID", "LinkField_Link_Live"."ID",
CASE WHEN "LinkField_Link_Live"."ClassName" IS NOT NULL THEN "LinkField_Link_Live"."ClassName"
ELSE 'SilverStripe\\LinkField\\Models\\Link' END AS "RecordClassName", "LinkField_Link_Live"."Sort"
FROM "LinkField_Link_Live" LEFT JOIN "LinkField_SiteTreeLink_Live" ON "LinkField_SiteTreeLink_Live"."ID" = "LinkField_Link_Live"."ID"
WHERE ("LinkField_Link_Live"."ID" = ?)
AND ("LinkField_Link_Live"."ClassName" IN (?))
ORDER BY "LinkField_Link_Live"."Sort" ASC
LIMIT 1
0.0007s
0084: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaCanonicalURL", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."MetaImageID", "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
0085: SELECT CASE WHEN EXISTS(SELECT *
FROM "Dynamic_Slide_Live" INNER JOIN "ElementCarousel_Slides" ON "ElementCarousel_Slides"."Dynamic_SlideID" = "Dynamic_Slide_Live"."ID"
WHERE ("ElementCarousel_Slides"."ElementCarouselID" = ?)) THEN 1 ELSE 0 END
0.001s
0086: SELECT DISTINCT count(DISTINCT "Dynamic_Slide_Live"."ID") AS "Count"
FROM "Dynamic_Slide_Live" INNER JOIN "ElementCarousel_Slides" ON "ElementCarousel_Slides"."Dynamic_SlideID" = "Dynamic_Slide_Live"."ID"
WHERE ("ElementCarousel_Slides"."ElementCarouselID" = ?)
0.0007s
0087: SELECT DISTINCT count(DISTINCT "Dynamic_Slide_Live"."ID") AS "Count"
FROM "Dynamic_Slide_Live" INNER JOIN "ElementCarousel_Slides" ON "ElementCarousel_Slides"."Dynamic_SlideID" = "Dynamic_Slide_Live"."ID"
WHERE ("ElementCarousel_Slides"."ElementCarouselID" = ?)
0.0006s
0088: SELECT DISTINCT "ElementCarousel_Slides"."SortOrder", "Dynamic_Slide_Live"."ClassName", "Dynamic_Slide_Live"."LastEdited", "Dynamic_Slide_Live"."Created", "Dynamic_Slide_Live"."Version", "Dynamic_Slide_Live"."Title", "Dynamic_Slide_Live"."ShowTitle", "Dynamic_Slide_Live"."Content", "Dynamic_Slide_Live"."ID",
CASE WHEN "Dynamic_Slide_Live"."ClassName" IS NOT NULL THEN "Dynamic_Slide_Live"."ClassName"
ELSE 'Dynamic\\Carousel\\Model\\Slide' END AS "RecordClassName"
FROM "Dynamic_Slide_Live" INNER JOIN "ElementCarousel_Slides" ON "ElementCarousel_Slides"."Dynamic_SlideID" = "Dynamic_Slide_Live"."ID"
WHERE ("ElementCarousel_Slides"."ElementCarouselID" = ?)
0.0008s
0089: SELECT DISTINCT "Dynamic_Slide_Live"."ClassName", "Dynamic_Slide_Live"."LastEdited", "Dynamic_Slide_Live"."Created", "Dynamic_VideoSlide_Live"."VideoType", "Dynamic_VideoSlide_Live"."VideoID", "Dynamic_VideoSlide_Live"."EmbedVideoID", "Dynamic_Slide_Live"."ID",
CASE WHEN "Dynamic_Slide_Live"."ClassName" IS NOT NULL THEN "Dynamic_Slide_Live"."ClassName"
ELSE 'Dynamic\\Carousel\\Model\\Slide' END AS "RecordClassName"
FROM "Dynamic_Slide_Live" LEFT JOIN "Dynamic_VideoSlide_Live" ON "Dynamic_VideoSlide_Live"."ID" = "Dynamic_Slide_Live"."ID"
WHERE ("Dynamic_Slide_Live"."ID" = ?)
AND ("Dynamic_Slide_Live"."ClassName" IN (?))
LIMIT 1
0.0006s
0090: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementCarousel_Live"."Controls", "ElementCarousel_Live"."Indicators", "ElementCarousel_Live"."Transitions", "ElementCarousel_Live"."Autoplay", "ElementCarousel_Live"."Interval", "ElementCarousel_Live"."Content", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementCarousel_Live" ON "ElementCarousel_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.001s
0091: SELECT CASE WHEN EXISTS(SELECT *
FROM "Dynamic_Slide_Live" INNER JOIN "ElementCarousel_Slides" ON "ElementCarousel_Slides"."Dynamic_SlideID" = "Dynamic_Slide_Live"."ID"
WHERE ("ElementCarousel_Slides"."ElementCarouselID" = ?)) THEN 1 ELSE 0 END
0.0009s
0092: SELECT DISTINCT "ElementCarousel_Slides"."SortOrder", "Dynamic_Slide_Live"."ClassName", "Dynamic_Slide_Live"."LastEdited", "Dynamic_Slide_Live"."Created", "Dynamic_Slide_Live"."Version", "Dynamic_Slide_Live"."Title", "Dynamic_Slide_Live"."ShowTitle", "Dynamic_Slide_Live"."Content", "Dynamic_Slide_Live"."ID",
CASE WHEN "Dynamic_Slide_Live"."ClassName" IS NOT NULL THEN "Dynamic_Slide_Live"."ClassName"
ELSE 'Dynamic\\Carousel\\Model\\Slide' END AS "RecordClassName"
FROM "Dynamic_Slide_Live" INNER JOIN "ElementCarousel_Slides" ON "ElementCarousel_Slides"."Dynamic_SlideID" = "Dynamic_Slide_Live"."ID"
WHERE ("ElementCarousel_Slides"."ElementCarouselID" = ?)
ORDER BY "SortOrder" ASC
0.001s
0093: SELECT DISTINCT "Dynamic_Slide_Live"."ClassName", "Dynamic_Slide_Live"."LastEdited", "Dynamic_Slide_Live"."Created", "Dynamic_ImageSlide_Live"."ImageID", "Dynamic_ImageSlide_Live"."ImageMobileID", "Dynamic_ImageSlide_Live"."ElementLinkID", "Dynamic_Slide_Live"."ID",
CASE WHEN "Dynamic_Slide_Live"."ClassName" IS NOT NULL THEN "Dynamic_Slide_Live"."ClassName"
ELSE 'Dynamic\\Carousel\\Model\\Slide' END AS "RecordClassName"
FROM "Dynamic_Slide_Live" LEFT JOIN "Dynamic_ImageSlide_Live" ON "Dynamic_ImageSlide_Live"."ID" = "Dynamic_Slide_Live"."ID"
WHERE ("Dynamic_Slide_Live"."ID" = ?)
AND ("Dynamic_Slide_Live"."ClassName" IN (?))
LIMIT 1
0.0007s
0094: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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"."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.0009s
0095: SELECT DISTINCT "Dynamic_Slide_Live"."ClassName", "Dynamic_Slide_Live"."LastEdited", "Dynamic_Slide_Live"."Created", "Dynamic_ImageSlide_Live"."ImageID", "Dynamic_ImageSlide_Live"."ImageMobileID", "Dynamic_ImageSlide_Live"."ElementLinkID", "Dynamic_Slide_Live"."ID",
CASE WHEN "Dynamic_Slide_Live"."ClassName" IS NOT NULL THEN "Dynamic_Slide_Live"."ClassName"
ELSE 'Dynamic\\Carousel\\Model\\Slide' END AS "RecordClassName"
FROM "Dynamic_Slide_Live" LEFT JOIN "Dynamic_ImageSlide_Live" ON "Dynamic_ImageSlide_Live"."ID" = "Dynamic_Slide_Live"."ID"
WHERE ("Dynamic_Slide_Live"."ID" = ?)
AND ("Dynamic_Slide_Live"."ClassName" IN (?))
LIMIT 1
0.0007s
0096: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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"."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.0009s
0097: SELECT DISTINCT "Dynamic_Slide_Live"."ClassName", "Dynamic_Slide_Live"."LastEdited", "Dynamic_Slide_Live"."Created", "Dynamic_VideoSlide_Live"."VideoType", "Dynamic_VideoSlide_Live"."VideoID", "Dynamic_VideoSlide_Live"."EmbedVideoID", "Dynamic_Slide_Live"."ID",
CASE WHEN "Dynamic_Slide_Live"."ClassName" IS NOT NULL THEN "Dynamic_Slide_Live"."ClassName"
ELSE 'Dynamic\\Carousel\\Model\\Slide' END AS "RecordClassName"
FROM "Dynamic_Slide_Live" LEFT JOIN "Dynamic_VideoSlide_Live" ON "Dynamic_VideoSlide_Live"."ID" = "Dynamic_Slide_Live"."ID"
WHERE ("Dynamic_Slide_Live"."ID" = ?)
AND ("Dynamic_Slide_Live"."ClassName" IN (?))
LIMIT 1
0.001s
0098: SELECT DISTINCT "EmbedObject"."ClassName", "EmbedObject"."LastEdited", "EmbedObject"."Created", "EmbedObject"."SourceURL", "EmbedObject"."Title", "EmbedObject"."Type", "EmbedObject"."Version", "EmbedObject"."Width", "EmbedObject"."Height", "EmbedObject"."ThumbnailURL", "EmbedObject"."ThumbnailWidth", "EmbedObject"."ThumbnailHeight", "EmbedObject"."ProviderURL", "EmbedObject"."ProviderName", "EmbedObject"."AuthorURL", "EmbedObject"."AuthorName", "EmbedObject"."EmbedHTML", "EmbedObject"."URL", "EmbedObject"."Origin", "EmbedObject"."WebPage", "EmbedObject"."ID",
CASE WHEN "EmbedObject"."ClassName" IS NOT NULL THEN "EmbedObject"."ClassName"
ELSE 'nathancox\\EmbedField\\Model\\EmbedObject' END AS "RecordClassName"
FROM "EmbedObject"
WHERE ("EmbedObject"."ID" = ?)
LIMIT 1
0.0011s
0099: SELECT DISTINCT count(DISTINCT "Dynamic_Slide_Live"."ID") AS "Count"
FROM "Dynamic_Slide_Live" INNER JOIN "ElementCarousel_Slides" ON "ElementCarousel_Slides"."Dynamic_SlideID" = "Dynamic_Slide_Live"."ID"
WHERE ("ElementCarousel_Slides"."ElementCarouselID" = ?)
0.0009s
0100: SELECT DISTINCT "ElementCarousel_Slides"."SortOrder", "Dynamic_Slide_Live"."ClassName", "Dynamic_Slide_Live"."LastEdited", "Dynamic_Slide_Live"."Created", "Dynamic_Slide_Live"."Version", "Dynamic_Slide_Live"."Title", "Dynamic_Slide_Live"."ShowTitle", "Dynamic_Slide_Live"."Content", "Dynamic_Slide_Live"."ID",
CASE WHEN "Dynamic_Slide_Live"."ClassName" IS NOT NULL THEN "Dynamic_Slide_Live"."ClassName"
ELSE 'Dynamic\\Carousel\\Model\\Slide' END AS "RecordClassName"
FROM "Dynamic_Slide_Live" INNER JOIN "ElementCarousel_Slides" ON "ElementCarousel_Slides"."Dynamic_SlideID" = "Dynamic_Slide_Live"."ID"
WHERE ("ElementCarousel_Slides"."ElementCarouselID" = ?)
ORDER BY "SortOrder" ASC
0.001s
0101: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementCarousel_Live"."Controls", "ElementCarousel_Live"."Indicators", "ElementCarousel_Live"."Transitions", "ElementCarousel_Live"."Autoplay", "ElementCarousel_Live"."Interval", "ElementCarousel_Live"."Content", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementCarousel_Live" ON "ElementCarousel_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0009s
0102: SELECT CASE WHEN EXISTS(SELECT *
FROM "Dynamic_Slide_Live" INNER JOIN "ElementCarousel_Slides" ON "ElementCarousel_Slides"."Dynamic_SlideID" = "Dynamic_Slide_Live"."ID"
WHERE ("ElementCarousel_Slides"."ElementCarouselID" = ?)) THEN 1 ELSE 0 END
0.0009s
0103: SELECT DISTINCT "ElementCarousel_Slides"."SortOrder", "Dynamic_Slide_Live"."ClassName", "Dynamic_Slide_Live"."LastEdited", "Dynamic_Slide_Live"."Created", "Dynamic_Slide_Live"."Version", "Dynamic_Slide_Live"."Title", "Dynamic_Slide_Live"."ShowTitle", "Dynamic_Slide_Live"."Content", "Dynamic_Slide_Live"."ID",
CASE WHEN "Dynamic_Slide_Live"."ClassName" IS NOT NULL THEN "Dynamic_Slide_Live"."ClassName"
ELSE 'Dynamic\\Carousel\\Model\\Slide' END AS "RecordClassName"
FROM "Dynamic_Slide_Live" INNER JOIN "ElementCarousel_Slides" ON "ElementCarousel_Slides"."Dynamic_SlideID" = "Dynamic_Slide_Live"."ID"
WHERE ("ElementCarousel_Slides"."ElementCarouselID" = ?)
ORDER BY "SortOrder" ASC
0.0009s
0104: SELECT DISTINCT "Dynamic_Slide_Live"."ClassName", "Dynamic_Slide_Live"."LastEdited", "Dynamic_Slide_Live"."Created", "Dynamic_ImageSlide_Live"."ImageID", "Dynamic_ImageSlide_Live"."ImageMobileID", "Dynamic_ImageSlide_Live"."ElementLinkID", "Dynamic_Slide_Live"."ID",
CASE WHEN "Dynamic_Slide_Live"."ClassName" IS NOT NULL THEN "Dynamic_Slide_Live"."ClassName"
ELSE 'Dynamic\\Carousel\\Model\\Slide' END AS "RecordClassName"
FROM "Dynamic_Slide_Live" LEFT JOIN "Dynamic_ImageSlide_Live" ON "Dynamic_ImageSlide_Live"."ID" = "Dynamic_Slide_Live"."ID"
WHERE ("Dynamic_Slide_Live"."ID" = ?)
AND ("Dynamic_Slide_Live"."ClassName" IN (?))
LIMIT 1
0.0006s
0105: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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"."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
0106: SELECT DISTINCT "Dynamic_Slide_Live"."ClassName", "Dynamic_Slide_Live"."LastEdited", "Dynamic_Slide_Live"."Created", "Dynamic_ImageSlide_Live"."ImageID", "Dynamic_ImageSlide_Live"."ImageMobileID", "Dynamic_ImageSlide_Live"."ElementLinkID", "Dynamic_Slide_Live"."ID",
CASE WHEN "Dynamic_Slide_Live"."ClassName" IS NOT NULL THEN "Dynamic_Slide_Live"."ClassName"
ELSE 'Dynamic\\Carousel\\Model\\Slide' END AS "RecordClassName"
FROM "Dynamic_Slide_Live" LEFT JOIN "Dynamic_ImageSlide_Live" ON "Dynamic_ImageSlide_Live"."ID" = "Dynamic_Slide_Live"."ID"
WHERE ("Dynamic_Slide_Live"."ID" = ?)
AND ("Dynamic_Slide_Live"."ClassName" IN (?))
LIMIT 1
0.0006s
0107: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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"."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 count(DISTINCT "Dynamic_Slide_Live"."ID") AS "Count"
FROM "Dynamic_Slide_Live" INNER JOIN "ElementCarousel_Slides" ON "ElementCarousel_Slides"."Dynamic_SlideID" = "Dynamic_Slide_Live"."ID"
WHERE ("ElementCarousel_Slides"."ElementCarouselID" = ?)
0.0007s
0109: SELECT DISTINCT "ElementCarousel_Slides"."SortOrder", "Dynamic_Slide_Live"."ClassName", "Dynamic_Slide_Live"."LastEdited", "Dynamic_Slide_Live"."Created", "Dynamic_Slide_Live"."Version", "Dynamic_Slide_Live"."Title", "Dynamic_Slide_Live"."ShowTitle", "Dynamic_Slide_Live"."Content", "Dynamic_Slide_Live"."ID",
CASE WHEN "Dynamic_Slide_Live"."ClassName" IS NOT NULL THEN "Dynamic_Slide_Live"."ClassName"
ELSE 'Dynamic\\Carousel\\Model\\Slide' END AS "RecordClassName"
FROM "Dynamic_Slide_Live" INNER JOIN "ElementCarousel_Slides" ON "ElementCarousel_Slides"."Dynamic_SlideID" = "Dynamic_Slide_Live"."ID"
WHERE ("ElementCarousel_Slides"."ElementCarouselID" = ?)
ORDER BY "SortOrder" ASC
0.0008s
0110: SELECT DISTINCT "Dynamic_Slide_Live"."ClassName", "Dynamic_Slide_Live"."LastEdited", "Dynamic_Slide_Live"."Created", "Dynamic_ImageSlide_Live"."ImageID", "Dynamic_ImageSlide_Live"."ImageMobileID", "Dynamic_ImageSlide_Live"."ElementLinkID", "Dynamic_Slide_Live"."ID",
CASE WHEN "Dynamic_Slide_Live"."ClassName" IS NOT NULL THEN "Dynamic_Slide_Live"."ClassName"
ELSE 'Dynamic\\Carousel\\Model\\Slide' END AS "RecordClassName"
FROM "Dynamic_Slide_Live" LEFT JOIN "Dynamic_ImageSlide_Live" ON "Dynamic_ImageSlide_Live"."ID" = "Dynamic_Slide_Live"."ID"
WHERE ("Dynamic_Slide_Live"."ID" = ?)
AND ("Dynamic_Slide_Live"."ClassName" IN (?))
LIMIT 1
0.0007s
0111: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0008s
0112: SELECT DISTINCT "Dynamic_Slide_Live"."ClassName", "Dynamic_Slide_Live"."LastEdited", "Dynamic_Slide_Live"."Created", "Dynamic_ImageSlide_Live"."ImageID", "Dynamic_ImageSlide_Live"."ImageMobileID", "Dynamic_ImageSlide_Live"."ElementLinkID", "Dynamic_Slide_Live"."ID",
CASE WHEN "Dynamic_Slide_Live"."ClassName" IS NOT NULL THEN "Dynamic_Slide_Live"."ClassName"
ELSE 'Dynamic\\Carousel\\Model\\Slide' END AS "RecordClassName"
FROM "Dynamic_Slide_Live" LEFT JOIN "Dynamic_ImageSlide_Live" ON "Dynamic_ImageSlide_Live"."ID" = "Dynamic_Slide_Live"."ID"
WHERE ("Dynamic_Slide_Live"."ID" = ?)
AND ("Dynamic_Slide_Live"."ClassName" IN (?))
LIMIT 1
0.0006s
0113: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0008s
0114: SELECT DISTINCT "ElementCarousel_Slides"."SortOrder", "Dynamic_Slide_Live"."ClassName", "Dynamic_Slide_Live"."LastEdited", "Dynamic_Slide_Live"."Created", "Dynamic_Slide_Live"."Version", "Dynamic_Slide_Live"."Title", "Dynamic_Slide_Live"."ShowTitle", "Dynamic_Slide_Live"."Content", "Dynamic_Slide_Live"."ID",
CASE WHEN "Dynamic_Slide_Live"."ClassName" IS NOT NULL THEN "Dynamic_Slide_Live"."ClassName"
ELSE 'Dynamic\\Carousel\\Model\\Slide' END AS "RecordClassName"
FROM "Dynamic_Slide_Live" INNER JOIN "ElementCarousel_Slides" ON "ElementCarousel_Slides"."Dynamic_SlideID" = "Dynamic_Slide_Live"."ID"
WHERE ("ElementCarousel_Slides"."ElementCarouselID" = ?)
ORDER BY "SortOrder" ASC
0.0008s
0115: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementCarousel_Live"."Controls", "ElementCarousel_Live"."Indicators", "ElementCarousel_Live"."Transitions", "ElementCarousel_Live"."Autoplay", "ElementCarousel_Live"."Interval", "ElementCarousel_Live"."Content", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementCarousel_Live" ON "ElementCarousel_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0009s
0116: SELECT CASE WHEN EXISTS(SELECT *
FROM "Dynamic_Slide_Live" INNER JOIN "ElementCarousel_Slides" ON "ElementCarousel_Slides"."Dynamic_SlideID" = "Dynamic_Slide_Live"."ID"
WHERE ("ElementCarousel_Slides"."ElementCarouselID" = ?)) THEN 1 ELSE 0 END
0.001s
0117: SELECT DISTINCT "ElementCarousel_Slides"."SortOrder", "Dynamic_Slide_Live"."ClassName", "Dynamic_Slide_Live"."LastEdited", "Dynamic_Slide_Live"."Created", "Dynamic_Slide_Live"."Version", "Dynamic_Slide_Live"."Title", "Dynamic_Slide_Live"."ShowTitle", "Dynamic_Slide_Live"."Content", "Dynamic_Slide_Live"."ID",
CASE WHEN "Dynamic_Slide_Live"."ClassName" IS NOT NULL THEN "Dynamic_Slide_Live"."ClassName"
ELSE 'Dynamic\\Carousel\\Model\\Slide' END AS "RecordClassName"
FROM "Dynamic_Slide_Live" INNER JOIN "ElementCarousel_Slides" ON "ElementCarousel_Slides"."Dynamic_SlideID" = "Dynamic_Slide_Live"."ID"
WHERE ("ElementCarousel_Slides"."ElementCarouselID" = ?)
ORDER BY "SortOrder" ASC
0.0011s
0118: SELECT DISTINCT "Dynamic_Slide_Live"."ClassName", "Dynamic_Slide_Live"."LastEdited", "Dynamic_Slide_Live"."Created", "Dynamic_ImageSlide_Live"."ImageID", "Dynamic_ImageSlide_Live"."ImageMobileID", "Dynamic_ImageSlide_Live"."ElementLinkID", "Dynamic_Slide_Live"."ID",
CASE WHEN "Dynamic_Slide_Live"."ClassName" IS NOT NULL THEN "Dynamic_Slide_Live"."ClassName"
ELSE 'Dynamic\\Carousel\\Model\\Slide' END AS "RecordClassName"
FROM "Dynamic_Slide_Live" LEFT JOIN "Dynamic_ImageSlide_Live" ON "Dynamic_ImageSlide_Live"."ID" = "Dynamic_Slide_Live"."ID"
WHERE ("Dynamic_Slide_Live"."ID" = ?)
AND ("Dynamic_Slide_Live"."ClassName" IN (?))
LIMIT 1
0.001s
0119: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.001s
0120: SELECT DISTINCT "Dynamic_Slide_Live"."ClassName", "Dynamic_Slide_Live"."LastEdited", "Dynamic_Slide_Live"."Created", "Dynamic_ImageSlide_Live"."ImageID", "Dynamic_ImageSlide_Live"."ImageMobileID", "Dynamic_ImageSlide_Live"."ElementLinkID", "Dynamic_Slide_Live"."ID",
CASE WHEN "Dynamic_Slide_Live"."ClassName" IS NOT NULL THEN "Dynamic_Slide_Live"."ClassName"
ELSE 'Dynamic\\Carousel\\Model\\Slide' END AS "RecordClassName"
FROM "Dynamic_Slide_Live" LEFT JOIN "Dynamic_ImageSlide_Live" ON "Dynamic_ImageSlide_Live"."ID" = "Dynamic_Slide_Live"."ID"
WHERE ("Dynamic_Slide_Live"."ID" = ?)
AND ("Dynamic_Slide_Live"."ClassName" IN (?))
LIMIT 1
0.0011s
0121: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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"."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.0011s
0122: SELECT DISTINCT count(DISTINCT "Dynamic_Slide_Live"."ID") AS "Count"
FROM "Dynamic_Slide_Live" INNER JOIN "ElementCarousel_Slides" ON "ElementCarousel_Slides"."Dynamic_SlideID" = "Dynamic_Slide_Live"."ID"
WHERE ("ElementCarousel_Slides"."ElementCarouselID" = ?)
0.0009s
0123: SELECT DISTINCT "ElementCarousel_Slides"."SortOrder", "Dynamic_Slide_Live"."ClassName", "Dynamic_Slide_Live"."LastEdited", "Dynamic_Slide_Live"."Created", "Dynamic_Slide_Live"."Version", "Dynamic_Slide_Live"."Title", "Dynamic_Slide_Live"."ShowTitle", "Dynamic_Slide_Live"."Content", "Dynamic_Slide_Live"."ID",
CASE WHEN "Dynamic_Slide_Live"."ClassName" IS NOT NULL THEN "Dynamic_Slide_Live"."ClassName"
ELSE 'Dynamic\\Carousel\\Model\\Slide' END AS "RecordClassName"
FROM "Dynamic_Slide_Live" INNER JOIN "ElementCarousel_Slides" ON "ElementCarousel_Slides"."Dynamic_SlideID" = "Dynamic_Slide_Live"."ID"
WHERE ("ElementCarousel_Slides"."ElementCarouselID" = ?)
ORDER BY "SortOrder" ASC
0.0012s
0124: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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"."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.0011s
0125: SELECT DISTINCT "LinkField_Link_Live"."ClassName", "LinkField_Link_Live"."LastEdited", "LinkField_Link_Live"."Created", "LinkField_Link_Live"."ExtraClass", "LinkField_Link_Live"."Style", "LinkField_Link_Live"."Version", "LinkField_Link_Live"."LinkText", "LinkField_Link_Live"."OpenInNew", "LinkField_Link_Live"."Sort", "LinkField_Link_Live"."IconID", "LinkField_Link_Live"."OwnerID", "LinkField_Link_Live"."OwnerClass", "LinkField_Link_Live"."OwnerRelation", "LinkField_Link_Live"."ID",
CASE WHEN "LinkField_Link_Live"."ClassName" IS NOT NULL THEN "LinkField_Link_Live"."ClassName"
ELSE 'SilverStripe\\LinkField\\Models\\Link' END AS "RecordClassName"
FROM "LinkField_Link_Live"
WHERE ("LinkField_Link_Live"."ID" = ?)
ORDER BY "LinkField_Link_Live"."Sort" ASC
LIMIT 1
0.0009s
0126: SELECT DISTINCT "LinkField_Link_Live"."ClassName", "LinkField_Link_Live"."LastEdited", "LinkField_Link_Live"."Created", "LinkField_SiteTreeLink_Live"."Anchor", "LinkField_SiteTreeLink_Live"."QueryString", "LinkField_SiteTreeLink_Live"."PageID", "LinkField_Link_Live"."ID",
CASE WHEN "LinkField_Link_Live"."ClassName" IS NOT NULL THEN "LinkField_Link_Live"."ClassName"
ELSE 'SilverStripe\\LinkField\\Models\\Link' END AS "RecordClassName", "LinkField_Link_Live"."Sort"
FROM "LinkField_Link_Live" LEFT JOIN "LinkField_SiteTreeLink_Live" ON "LinkField_SiteTreeLink_Live"."ID" = "LinkField_Link_Live"."ID"
WHERE ("LinkField_Link_Live"."ID" = ?)
AND ("LinkField_Link_Live"."ClassName" IN (?))
ORDER BY "LinkField_Link_Live"."Sort" ASC
LIMIT 1
0.0009s
0127: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaCanonicalURL", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."MetaImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0008s
0128: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementCustomerService_Live"."Address", "ElementCustomerService_Live"."Address2", "ElementCustomerService_Live"."City", "ElementCustomerService_Live"."State", "ElementCustomerService_Live"."PostalCode", "ElementCustomerService_Live"."Country", "ElementCustomerService_Live"."LatLngOverride", "ElementCustomerService_Live"."Lat", "ElementCustomerService_Live"."Lng", "ElementCustomerService_Live"."Hours", "ElementCustomerService_Live"."Content", "ElementCustomerService_Live"."LocationName", "ElementCustomerService_Live"."Website", "ElementCustomerService_Live"."Phone", "ElementCustomerService_Live"."Email", "ElementCustomerService_Live"."Fax", "ElementCustomerService_Live"."ElementLinkID", "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 "ElementCustomerService_Live" ON "ElementCustomerService_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0014s
0129: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementEmbeddedCode_Live"."Content", "ElementEmbeddedCode_Live"."Code", "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 "ElementEmbeddedCode_Live" ON "ElementEmbeddedCode_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0011s
0130: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementForm_Live"."Content", "ElementForm_Live"."SubmitButtonText", "ElementForm_Live"."ClearButtonText", "ElementForm_Live"."OnCompleteMessage", "ElementForm_Live"."ShowClearButton", "ElementForm_Live"."DisableSaveSubmissions", "ElementForm_Live"."EnableLiveValidation", "ElementForm_Live"."DisplayErrorMessagesAtTop", "ElementForm_Live"."DisableAuthenicatedFinishAction", "ElementForm_Live"."DisableCsrfSecurityToken", "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 "ElementForm_Live" ON "ElementForm_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0011s
0131: SELECT DISTINCT "EditableFormField_Live"."ClassName", "EditableFormField_Live"."LastEdited", "EditableFormField_Live"."Created", "EditableFormField_Live"."Version", "EditableFormField_Live"."Name", "EditableFormField_Live"."Title", "EditableFormField_Live"."Default", "EditableFormField_Live"."Sort", "EditableFormField_Live"."Required", "EditableFormField_Live"."CustomErrorMessage", "EditableFormField_Live"."ExtraClass", "EditableFormField_Live"."RightTitle", "EditableFormField_Live"."ShowOnLoad", "EditableFormField_Live"."ShowInSummary", "EditableFormField_Live"."Placeholder", "EditableFormField_Live"."DisplayRulesConjunction", "EditableFormField_Live"."ParentID", "EditableFormField_Live"."ParentClass", "EditableFormField_Live"."ID",
CASE WHEN "EditableFormField_Live"."ClassName" IS NOT NULL THEN "EditableFormField_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableFormField' END AS "RecordClassName"
FROM "EditableFormField_Live"
WHERE ("EditableFormField_Live"."ParentClass" IN ('DNADesign\\ElementalUserForms\\Model\\ElementForm'))
AND ("EditableFormField_Live"."ParentID" = ?)
ORDER BY "EditableFormField_Live"."Sort" ASC
0.0012s
0132: SELECT DISTINCT "EditableFormField_Live"."ClassName", "EditableFormField_Live"."LastEdited", "EditableFormField_Live"."Created", "EditableTextField_Live"."MinLength", "EditableTextField_Live"."MaxLength", "EditableTextField_Live"."Rows", "EditableTextField_Live"."Autocomplete", "EditableFormField_Live"."ID",
CASE WHEN "EditableFormField_Live"."ClassName" IS NOT NULL THEN "EditableFormField_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableFormField' END AS "RecordClassName", "EditableFormField_Live"."Sort"
FROM "EditableFormField_Live" LEFT JOIN "EditableTextField_Live" ON "EditableTextField_Live"."ID" = "EditableFormField_Live"."ID"
WHERE ("EditableFormField_Live"."ID" = ?)
AND ("EditableFormField_Live"."ClassName" IN (?))
ORDER BY "EditableFormField_Live"."Sort" ASC
LIMIT 1
0.001s
0133: SELECT DISTINCT "EditableFormField_Live"."ClassName", "EditableFormField_Live"."LastEdited", "EditableFormField_Live"."Created", "EditableTextField_Live"."MinLength", "EditableTextField_Live"."MaxLength", "EditableTextField_Live"."Rows", "EditableTextField_Live"."Autocomplete", "EditableFormField_Live"."ID",
CASE WHEN "EditableFormField_Live"."ClassName" IS NOT NULL THEN "EditableFormField_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableFormField' END AS "RecordClassName", "EditableFormField_Live"."Sort"
FROM "EditableFormField_Live" LEFT JOIN "EditableTextField_Live" ON "EditableTextField_Live"."ID" = "EditableFormField_Live"."ID"
WHERE ("EditableFormField_Live"."ID" = ?)
AND ("EditableFormField_Live"."ClassName" IN (?))
ORDER BY "EditableFormField_Live"."Sort" ASC
LIMIT 1
0.0009s
0134: SELECT "EditableFormField_Live"."Name", "EditableFormField_Live"."Sort" AS "_SortColumn0"
FROM "EditableFormField_Live"
WHERE ("EditableFormField_Live"."ParentClass" IN ('DNADesign\\ElementalUserForms\\Model\\ElementForm'))
AND ("EditableFormField_Live"."ParentID" = ?)
AND ("EditableFormField_Live"."Required" = ?)
ORDER BY "_SortColumn0" ASC
0.0009s
0135: SELECT DISTINCT "UserDefinedForm_EmailRecipient"."ClassName", "UserDefinedForm_EmailRecipient"."LastEdited", "UserDefinedForm_EmailRecipient"."Created", "UserDefinedForm_EmailRecipient"."EmailAddress", "UserDefinedForm_EmailRecipient"."EmailSubject", "UserDefinedForm_EmailRecipient"."EmailFrom", "UserDefinedForm_EmailRecipient"."EmailReplyTo", "UserDefinedForm_EmailRecipient"."EmailBody", "UserDefinedForm_EmailRecipient"."EmailBodyHtml", "UserDefinedForm_EmailRecipient"."EmailTemplate", "UserDefinedForm_EmailRecipient"."SendPlain", "UserDefinedForm_EmailRecipient"."HideFormData", "UserDefinedForm_EmailRecipient"."HideInvisibleFields", "UserDefinedForm_EmailRecipient"."CustomRulesCondition", "UserDefinedForm_EmailRecipient"."SendEmailFromFieldID", "UserDefinedForm_EmailRecipient"."SendEmailToFieldID", "UserDefinedForm_EmailRecipient"."SendEmailSubjectFieldID", "UserDefinedForm_EmailRecipient"."FormID", "UserDefinedForm_EmailRecipient"."FormClass", "UserDefinedForm_EmailRecipient"."ID",
CASE WHEN "UserDefinedForm_EmailRecipient"."ClassName" IS NOT NULL THEN "UserDefinedForm_EmailRecipient"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\Recipient\\EmailRecipient' END AS "RecordClassName"
FROM "UserDefinedForm_EmailRecipient"
WHERE ("UserDefinedForm_EmailRecipient"."FormClass" IN ('DNADesign\\ElementalUserForms\\Model\\ElementForm'))
AND ("UserDefinedForm_EmailRecipient"."FormID" = ?)
0.0009s
0136: SELECT DISTINCT "EditableFormField_Live"."ClassName", "EditableFormField_Live"."LastEdited", "EditableFormField_Live"."Created", "EditableFormField_Live"."Version", "EditableFormField_Live"."Name", "EditableFormField_Live"."Title", "EditableFormField_Live"."Default", "EditableFormField_Live"."Sort", "EditableFormField_Live"."Required", "EditableFormField_Live"."CustomErrorMessage", "EditableFormField_Live"."ExtraClass", "EditableFormField_Live"."RightTitle", "EditableFormField_Live"."ShowOnLoad", "EditableFormField_Live"."ShowInSummary", "EditableFormField_Live"."Placeholder", "EditableFormField_Live"."DisplayRulesConjunction", "EditableFormField_Live"."ParentID", "EditableFormField_Live"."ParentClass", "EditableFormField_Live"."ID",
CASE WHEN "EditableFormField_Live"."ClassName" IS NOT NULL THEN "EditableFormField_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableFormField' END AS "RecordClassName"
FROM "EditableFormField_Live"
WHERE ("EditableFormField_Live"."ParentClass" IN ('DNADesign\\ElementalUserForms\\Model\\ElementForm'))
AND ("EditableFormField_Live"."ParentID" = ?)
ORDER BY "EditableFormField_Live"."Sort" ASC
0.001s
0137: SELECT DISTINCT "EditableCustomRule_Live"."ClassName", "EditableCustomRule_Live"."LastEdited", "EditableCustomRule_Live"."Created", "EditableCustomRule_Live"."Version", "EditableCustomRule_Live"."Display", "EditableCustomRule_Live"."ConditionOption", "EditableCustomRule_Live"."FieldValue", "EditableCustomRule_Live"."ParentID", "EditableCustomRule_Live"."ConditionFieldID", "EditableCustomRule_Live"."ID",
CASE WHEN "EditableCustomRule_Live"."ClassName" IS NOT NULL THEN "EditableCustomRule_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableCustomRule' END AS "RecordClassName"
FROM "EditableCustomRule_Live"
WHERE ("EditableCustomRule_Live"."ParentID" = ?)
0.0007s
0138: SELECT DISTINCT "EditableCustomRule_Live"."ClassName", "EditableCustomRule_Live"."LastEdited", "EditableCustomRule_Live"."Created", "EditableCustomRule_Live"."Version", "EditableCustomRule_Live"."Display", "EditableCustomRule_Live"."ConditionOption", "EditableCustomRule_Live"."FieldValue", "EditableCustomRule_Live"."ParentID", "EditableCustomRule_Live"."ConditionFieldID", "EditableCustomRule_Live"."ID",
CASE WHEN "EditableCustomRule_Live"."ClassName" IS NOT NULL THEN "EditableCustomRule_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableCustomRule' END AS "RecordClassName"
FROM "EditableCustomRule_Live"
WHERE ("EditableCustomRule_Live"."ParentID" = ?)
0.0007s
0139: SELECT DISTINCT "EditableCustomRule_Live"."ClassName", "EditableCustomRule_Live"."LastEdited", "EditableCustomRule_Live"."Created", "EditableCustomRule_Live"."Version", "EditableCustomRule_Live"."Display", "EditableCustomRule_Live"."ConditionOption", "EditableCustomRule_Live"."FieldValue", "EditableCustomRule_Live"."ParentID", "EditableCustomRule_Live"."ConditionFieldID", "EditableCustomRule_Live"."ID",
CASE WHEN "EditableCustomRule_Live"."ClassName" IS NOT NULL THEN "EditableCustomRule_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableCustomRule' END AS "RecordClassName"
FROM "EditableCustomRule_Live"
WHERE ("EditableCustomRule_Live"."ParentID" = ?)
0.0008s
0140: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementPhotoGallery_Live"."Content", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementPhotoGallery_Live" ON "ElementPhotoGallery_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0011s
0141: SELECT CASE WHEN EXISTS(SELECT *
FROM "BaseElementObject_Live" LEFT JOIN "GalleryImage_Live" ON "GalleryImage_Live"."ID" = "BaseElementObject_Live"."ID"
WHERE ("GalleryImage_Live"."PhotoGalleryID" = ?)
AND ("BaseElementObject_Live"."ClassName" IN (?))) THEN 1 ELSE 0 END
0.001s
0142: SELECT DISTINCT "BaseElementObject_Live"."ClassName", "BaseElementObject_Live"."LastEdited", "BaseElementObject_Live"."Created", "BaseElementObject_Live"."Version", "BaseElementObject_Live"."Title", "BaseElementObject_Live"."ShowTitle", "BaseElementObject_Live"."Content", "BaseElementObject_Live"."ImageID", "BaseElementObject_Live"."ElementLinkID", "GalleryImage_Live"."Credits", "GalleryImage_Live"."Location", "GalleryImage_Live"."SortOrder", "GalleryImage_Live"."PhotoGalleryID", "BaseElementObject_Live"."ID",
CASE WHEN "BaseElementObject_Live"."ClassName" IS NOT NULL THEN "BaseElementObject_Live"."ClassName"
ELSE 'Dynamic\\BaseObject\\Model\\BaseElementObject' END AS "RecordClassName"
FROM "BaseElementObject_Live" LEFT JOIN "GalleryImage_Live" ON "GalleryImage_Live"."ID" = "BaseElementObject_Live"."ID"
WHERE ("GalleryImage_Live"."PhotoGalleryID" = ?)
AND ("BaseElementObject_Live"."ClassName" IN (?))
ORDER BY "GalleryImage_Live"."SortOrder" ASC
0.0012s
0143: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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"."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.0009s
0144: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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"."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.0011s
0145: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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"."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.0011s
0146: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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"."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.0012s
0147: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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"."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.0012s
0148: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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"."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.0011s
0149: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementImage_Live"."ImageID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementImage_Live" ON "ElementImage_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0011s
0150: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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"."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.0009s
0151: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "LinksElement_Live"."Content", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "LinksElement_Live" ON "LinksElement_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0012s
0152: SELECT CASE WHEN EXISTS(SELECT *
FROM "LinkListObject_Live"
WHERE ("LinkListObject_Live"."LinkListID" = ?)) THEN 1 ELSE 0 END
0.001s
0153: SELECT DISTINCT "LinkListObject_Live"."ClassName", "LinkListObject_Live"."LastEdited", "LinkListObject_Live"."Created", "LinkListObject_Live"."Version", "LinkListObject_Live"."Title", "LinkListObject_Live"."ShowTitle", "LinkListObject_Live"."Content", "LinkListObject_Live"."SortOrder", "LinkListObject_Live"."LinkListID", "LinkListObject_Live"."LinkID", "LinkListObject_Live"."ID",
CASE WHEN "LinkListObject_Live"."ClassName" IS NOT NULL THEN "LinkListObject_Live"."ClassName"
ELSE 'Dynamic\\Elements\\Links\\Model\\LinkListObject' END AS "RecordClassName"
FROM "LinkListObject_Live"
WHERE ("LinkListObject_Live"."LinkListID" = ?)
ORDER BY "LinkListObject_Live"."SortOrder" ASC
0.0008s
0154: SELECT DISTINCT "LinkField_Link_Live"."ClassName", "LinkField_Link_Live"."LastEdited", "LinkField_Link_Live"."Created", "LinkField_Link_Live"."ExtraClass", "LinkField_Link_Live"."Style", "LinkField_Link_Live"."Version", "LinkField_Link_Live"."LinkText", "LinkField_Link_Live"."OpenInNew", "LinkField_Link_Live"."Sort", "LinkField_Link_Live"."IconID", "LinkField_Link_Live"."OwnerID", "LinkField_Link_Live"."OwnerClass", "LinkField_Link_Live"."OwnerRelation", "LinkField_Link_Live"."ID",
CASE WHEN "LinkField_Link_Live"."ClassName" IS NOT NULL THEN "LinkField_Link_Live"."ClassName"
ELSE 'SilverStripe\\LinkField\\Models\\Link' END AS "RecordClassName"
FROM "LinkField_Link_Live"
WHERE ("LinkField_Link_Live"."ID" = ?)
ORDER BY "LinkField_Link_Live"."Sort" ASC
LIMIT 1
0.0009s
0155: SELECT DISTINCT "LinkField_Link_Live"."ClassName", "LinkField_Link_Live"."LastEdited", "LinkField_Link_Live"."Created", "LinkField_SiteTreeLink_Live"."Anchor", "LinkField_SiteTreeLink_Live"."QueryString", "LinkField_SiteTreeLink_Live"."PageID", "LinkField_Link_Live"."ID",
CASE WHEN "LinkField_Link_Live"."ClassName" IS NOT NULL THEN "LinkField_Link_Live"."ClassName"
ELSE 'SilverStripe\\LinkField\\Models\\Link' END AS "RecordClassName", "LinkField_Link_Live"."Sort"
FROM "LinkField_Link_Live" LEFT JOIN "LinkField_SiteTreeLink_Live" ON "LinkField_SiteTreeLink_Live"."ID" = "LinkField_Link_Live"."ID"
WHERE ("LinkField_Link_Live"."ID" = ?)
AND ("LinkField_Link_Live"."ClassName" IN (?))
ORDER BY "LinkField_Link_Live"."Sort" ASC
LIMIT 1
0.0008s
0156: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaCanonicalURL", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."MetaImageID", "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
0157: SELECT DISTINCT "LinkField_Link_Live"."ClassName", "LinkField_Link_Live"."LastEdited", "LinkField_Link_Live"."Created", "LinkField_Link_Live"."ExtraClass", "LinkField_Link_Live"."Style", "LinkField_Link_Live"."Version", "LinkField_Link_Live"."LinkText", "LinkField_Link_Live"."OpenInNew", "LinkField_Link_Live"."Sort", "LinkField_Link_Live"."IconID", "LinkField_Link_Live"."OwnerID", "LinkField_Link_Live"."OwnerClass", "LinkField_Link_Live"."OwnerRelation", "LinkField_Link_Live"."ID",
CASE WHEN "LinkField_Link_Live"."ClassName" IS NOT NULL THEN "LinkField_Link_Live"."ClassName"
ELSE 'SilverStripe\\LinkField\\Models\\Link' END AS "RecordClassName"
FROM "LinkField_Link_Live"
WHERE ("LinkField_Link_Live"."ID" = ?)
ORDER BY "LinkField_Link_Live"."Sort" ASC
LIMIT 1
0.0008s
0158: SELECT DISTINCT "LinkField_Link_Live"."ClassName", "LinkField_Link_Live"."LastEdited", "LinkField_Link_Live"."Created", "LinkField_SiteTreeLink_Live"."Anchor", "LinkField_SiteTreeLink_Live"."QueryString", "LinkField_SiteTreeLink_Live"."PageID", "LinkField_Link_Live"."ID",
CASE WHEN "LinkField_Link_Live"."ClassName" IS NOT NULL THEN "LinkField_Link_Live"."ClassName"
ELSE 'SilverStripe\\LinkField\\Models\\Link' END AS "RecordClassName", "LinkField_Link_Live"."Sort"
FROM "LinkField_Link_Live" LEFT JOIN "LinkField_SiteTreeLink_Live" ON "LinkField_SiteTreeLink_Live"."ID" = "LinkField_Link_Live"."ID"
WHERE ("LinkField_Link_Live"."ID" = ?)
AND ("LinkField_Link_Live"."ClassName" IN (?))
ORDER BY "LinkField_Link_Live"."Sort" ASC
LIMIT 1
0.0008s
0159: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaCanonicalURL", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."MetaImageID", "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.001s
0160: SELECT DISTINCT "LinkField_Link_Live"."ClassName", "LinkField_Link_Live"."LastEdited", "LinkField_Link_Live"."Created", "LinkField_Link_Live"."ExtraClass", "LinkField_Link_Live"."Style", "LinkField_Link_Live"."Version", "LinkField_Link_Live"."LinkText", "LinkField_Link_Live"."OpenInNew", "LinkField_Link_Live"."Sort", "LinkField_Link_Live"."IconID", "LinkField_Link_Live"."OwnerID", "LinkField_Link_Live"."OwnerClass", "LinkField_Link_Live"."OwnerRelation", "LinkField_Link_Live"."ID",
CASE WHEN "LinkField_Link_Live"."ClassName" IS NOT NULL THEN "LinkField_Link_Live"."ClassName"
ELSE 'SilverStripe\\LinkField\\Models\\Link' END AS "RecordClassName"
FROM "LinkField_Link_Live"
WHERE ("LinkField_Link_Live"."ID" = ?)
ORDER BY "LinkField_Link_Live"."Sort" ASC
LIMIT 1
0.0008s
0161: SELECT DISTINCT "LinkField_Link_Live"."ClassName", "LinkField_Link_Live"."LastEdited", "LinkField_Link_Live"."Created", "LinkField_SiteTreeLink_Live"."Anchor", "LinkField_SiteTreeLink_Live"."QueryString", "LinkField_SiteTreeLink_Live"."PageID", "LinkField_Link_Live"."ID",
CASE WHEN "LinkField_Link_Live"."ClassName" IS NOT NULL THEN "LinkField_Link_Live"."ClassName"
ELSE 'SilverStripe\\LinkField\\Models\\Link' END AS "RecordClassName", "LinkField_Link_Live"."Sort"
FROM "LinkField_Link_Live" LEFT JOIN "LinkField_SiteTreeLink_Live" ON "LinkField_SiteTreeLink_Live"."ID" = "LinkField_Link_Live"."ID"
WHERE ("LinkField_Link_Live"."ID" = ?)
AND ("LinkField_Link_Live"."ClassName" IN (?))
ORDER BY "LinkField_Link_Live"."Sort" ASC
LIMIT 1
0.0009s
0162: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaCanonicalURL", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."MetaImageID", "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
0163: SELECT DISTINCT "LinkField_Link_Live"."ClassName", "LinkField_Link_Live"."LastEdited", "LinkField_Link_Live"."Created", "LinkField_Link_Live"."ExtraClass", "LinkField_Link_Live"."Style", "LinkField_Link_Live"."Version", "LinkField_Link_Live"."LinkText", "LinkField_Link_Live"."OpenInNew", "LinkField_Link_Live"."Sort", "LinkField_Link_Live"."IconID", "LinkField_Link_Live"."OwnerID", "LinkField_Link_Live"."OwnerClass", "LinkField_Link_Live"."OwnerRelation", "LinkField_Link_Live"."ID",
CASE WHEN "LinkField_Link_Live"."ClassName" IS NOT NULL THEN "LinkField_Link_Live"."ClassName"
ELSE 'SilverStripe\\LinkField\\Models\\Link' END AS "RecordClassName"
FROM "LinkField_Link_Live"
WHERE ("LinkField_Link_Live"."ID" = ?)
ORDER BY "LinkField_Link_Live"."Sort" ASC
LIMIT 1
0.0008s
0164: SELECT DISTINCT "LinkField_Link_Live"."ClassName", "LinkField_Link_Live"."LastEdited", "LinkField_Link_Live"."Created", "LinkField_SiteTreeLink_Live"."Anchor", "LinkField_SiteTreeLink_Live"."QueryString", "LinkField_SiteTreeLink_Live"."PageID", "LinkField_Link_Live"."ID",
CASE WHEN "LinkField_Link_Live"."ClassName" IS NOT NULL THEN "LinkField_Link_Live"."ClassName"
ELSE 'SilverStripe\\LinkField\\Models\\Link' END AS "RecordClassName", "LinkField_Link_Live"."Sort"
FROM "LinkField_Link_Live" LEFT JOIN "LinkField_SiteTreeLink_Live" ON "LinkField_SiteTreeLink_Live"."ID" = "LinkField_Link_Live"."ID"
WHERE ("LinkField_Link_Live"."ID" = ?)
AND ("LinkField_Link_Live"."ClassName" IN (?))
ORDER BY "LinkField_Link_Live"."Sort" ASC
LIMIT 1
0.0008s
0165: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaCanonicalURL", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."MetaImageID", "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
0166: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementOembed_Live"."Content", "ElementOembed_Live"."EmbedTitle", "ElementOembed_Live"."EmbedDescription", "ElementOembed_Live"."EmbedSourceURL", "ElementOembed_Live"."EmbedVideoID", "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 "ElementOembed_Live" ON "ElementOembed_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0012s
0167: SELECT DISTINCT "EmbedObject"."ClassName", "EmbedObject"."LastEdited", "EmbedObject"."Created", "EmbedObject"."SourceURL", "EmbedObject"."Title", "EmbedObject"."Type", "EmbedObject"."Version", "EmbedObject"."Width", "EmbedObject"."Height", "EmbedObject"."ThumbnailURL", "EmbedObject"."ThumbnailWidth", "EmbedObject"."ThumbnailHeight", "EmbedObject"."ProviderURL", "EmbedObject"."ProviderName", "EmbedObject"."AuthorURL", "EmbedObject"."AuthorName", "EmbedObject"."EmbedHTML", "EmbedObject"."URL", "EmbedObject"."Origin", "EmbedObject"."WebPage", "EmbedObject"."ID",
CASE WHEN "EmbedObject"."ClassName" IS NOT NULL THEN "EmbedObject"."ClassName"
ELSE 'nathancox\\EmbedField\\Model\\EmbedObject' END AS "RecordClassName"
FROM "EmbedObject"
WHERE ("EmbedObject"."ID" = ?)
LIMIT 1
0.0009s
0168: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementSponsor_Live"."Limit", "ElementSponsor_Live"."Content", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementSponsor_Live" ON "ElementSponsor_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0012s
0169: SELECT CASE WHEN EXISTS(SELECT *
FROM "BaseElementObject_Live" INNER JOIN "ElementSponsor_Sponsors" ON "ElementSponsor_Sponsors"."SponsorID" = "BaseElementObject_Live"."ID"
WHERE ("ElementSponsor_Sponsors"."ElementSponsorID" = ?)
AND ("BaseElementObject_Live"."ClassName" IN (?))) THEN 1 ELSE 0 END
0.0027s
0170: SELECT DISTINCT "ElementSponsor_Sponsors"."SponsorSort", "BaseElementObject_Live"."ClassName", "BaseElementObject_Live"."LastEdited", "BaseElementObject_Live"."Created", "BaseElementObject_Live"."Version", "BaseElementObject_Live"."Title", "BaseElementObject_Live"."ShowTitle", "BaseElementObject_Live"."Content", "BaseElementObject_Live"."ImageID", "BaseElementObject_Live"."ElementLinkID", "BaseElementObject_Live"."ID",
CASE WHEN "BaseElementObject_Live"."ClassName" IS NOT NULL THEN "BaseElementObject_Live"."ClassName"
ELSE 'Dynamic\\BaseObject\\Model\\BaseElementObject' END AS "RecordClassName"
FROM "BaseElementObject_Live" INNER JOIN "ElementSponsor_Sponsors" ON "ElementSponsor_Sponsors"."SponsorID" = "BaseElementObject_Live"."ID"
WHERE ("ElementSponsor_Sponsors"."ElementSponsorID" = ?)
AND ("BaseElementObject_Live"."ClassName" IN (?))
ORDER BY "SponsorSort" ASC
0.0014s
0171: SELECT DISTINCT count(DISTINCT "BaseElementObject_Live"."ID") AS "Count"
FROM "BaseElementObject_Live" INNER JOIN "ElementSponsor_Sponsors" ON "ElementSponsor_Sponsors"."SponsorID" = "BaseElementObject_Live"."ID"
WHERE ("ElementSponsor_Sponsors"."ElementSponsorID" = ?)
AND ("BaseElementObject_Live"."ClassName" IN (?))
0.0012s
0172: SELECT DISTINCT count(DISTINCT "BaseElementObject_Live"."ID") AS "Count"
FROM "BaseElementObject_Live" INNER JOIN "ElementSponsor_Sponsors" ON "ElementSponsor_Sponsors"."SponsorID" = "BaseElementObject_Live"."ID"
WHERE ("ElementSponsor_Sponsors"."ElementSponsorID" = ?)
AND ("BaseElementObject_Live"."ClassName" IN (?))
0.0011s
0173: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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"."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.0014s
0174: SELECT DISTINCT count(DISTINCT "BaseElementObject_Live"."ID") AS "Count"
FROM "BaseElementObject_Live" INNER JOIN "ElementSponsor_Sponsors" ON "ElementSponsor_Sponsors"."SponsorID" = "BaseElementObject_Live"."ID"
WHERE ("ElementSponsor_Sponsors"."ElementSponsorID" = ?)
AND ("BaseElementObject_Live"."ClassName" IN (?))
0.0013s
0175: SELECT DISTINCT count(DISTINCT "BaseElementObject_Live"."ID") AS "Count"
FROM "BaseElementObject_Live" INNER JOIN "ElementSponsor_Sponsors" ON "ElementSponsor_Sponsors"."SponsorID" = "BaseElementObject_Live"."ID"
WHERE ("ElementSponsor_Sponsors"."ElementSponsorID" = ?)
AND ("BaseElementObject_Live"."ClassName" IN (?))
0.0011s
0176: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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"."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.0012s
0177: SELECT DISTINCT count(DISTINCT "BaseElementObject_Live"."ID") AS "Count"
FROM "BaseElementObject_Live" INNER JOIN "ElementSponsor_Sponsors" ON "ElementSponsor_Sponsors"."SponsorID" = "BaseElementObject_Live"."ID"
WHERE ("ElementSponsor_Sponsors"."ElementSponsorID" = ?)
AND ("BaseElementObject_Live"."ClassName" IN (?))
0.0013s
0178: SELECT DISTINCT count(DISTINCT "BaseElementObject_Live"."ID") AS "Count"
FROM "BaseElementObject_Live" INNER JOIN "ElementSponsor_Sponsors" ON "ElementSponsor_Sponsors"."SponsorID" = "BaseElementObject_Live"."ID"
WHERE ("ElementSponsor_Sponsors"."ElementSponsorID" = ?)
AND ("BaseElementObject_Live"."ClassName" IN (?))
0.001s
0179: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.001s
0180: SELECT DISTINCT count(DISTINCT "BaseElementObject_Live"."ID") AS "Count"
FROM "BaseElementObject_Live" INNER JOIN "ElementSponsor_Sponsors" ON "ElementSponsor_Sponsors"."SponsorID" = "BaseElementObject_Live"."ID"
WHERE ("ElementSponsor_Sponsors"."ElementSponsorID" = ?)
AND ("BaseElementObject_Live"."ClassName" IN (?))
0.001s
0181: SELECT DISTINCT count(DISTINCT "BaseElementObject_Live"."ID") AS "Count"
FROM "BaseElementObject_Live" INNER JOIN "ElementSponsor_Sponsors" ON "ElementSponsor_Sponsors"."SponsorID" = "BaseElementObject_Live"."ID"
WHERE ("ElementSponsor_Sponsors"."ElementSponsorID" = ?)
AND ("BaseElementObject_Live"."ClassName" IN (?))
0.0008s
0182: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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"."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.0009s
0183: SELECT DISTINCT count(DISTINCT "BaseElementObject_Live"."ID") AS "Count"
FROM "BaseElementObject_Live" INNER JOIN "ElementSponsor_Sponsors" ON "ElementSponsor_Sponsors"."SponsorID" = "BaseElementObject_Live"."ID"
WHERE ("ElementSponsor_Sponsors"."ElementSponsorID" = ?)
AND ("BaseElementObject_Live"."ClassName" IN (?))
0.0011s
0184: SELECT DISTINCT count(DISTINCT "BaseElementObject_Live"."ID") AS "Count"
FROM "BaseElementObject_Live" INNER JOIN "ElementSponsor_Sponsors" ON "ElementSponsor_Sponsors"."SponsorID" = "BaseElementObject_Live"."ID"
WHERE ("ElementSponsor_Sponsors"."ElementSponsorID" = ?)
AND ("BaseElementObject_Live"."ClassName" IN (?))
0.001s
0185: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.001s
0186: SELECT DISTINCT count(DISTINCT "BaseElementObject_Live"."ID") AS "Count"
FROM "BaseElementObject_Live" INNER JOIN "ElementSponsor_Sponsors" ON "ElementSponsor_Sponsors"."SponsorID" = "BaseElementObject_Live"."ID"
WHERE ("ElementSponsor_Sponsors"."ElementSponsorID" = ?)
AND ("BaseElementObject_Live"."ClassName" IN (?))
0.0011s
0187: SELECT DISTINCT count(DISTINCT "BaseElementObject_Live"."ID") AS "Count"
FROM "BaseElementObject_Live" INNER JOIN "ElementSponsor_Sponsors" ON "ElementSponsor_Sponsors"."SponsorID" = "BaseElementObject_Live"."ID"
WHERE ("ElementSponsor_Sponsors"."ElementSponsorID" = ?)
AND ("BaseElementObject_Live"."ClassName" IN (?))
0.001s
0188: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.001s
0189: SELECT DISTINCT count(DISTINCT "BaseElementObject_Live"."ID") AS "Count"
FROM "BaseElementObject_Live" INNER JOIN "ElementSponsor_Sponsors" ON "ElementSponsor_Sponsors"."SponsorID" = "BaseElementObject_Live"."ID"
WHERE ("ElementSponsor_Sponsors"."ElementSponsorID" = ?)
AND ("BaseElementObject_Live"."ClassName" IN (?))
0.0026s
0190: SELECT DISTINCT count(DISTINCT "BaseElementObject_Live"."ID") AS "Count"
FROM "BaseElementObject_Live" INNER JOIN "ElementSponsor_Sponsors" ON "ElementSponsor_Sponsors"."SponsorID" = "BaseElementObject_Live"."ID"
WHERE ("ElementSponsor_Sponsors"."ElementSponsorID" = ?)
AND ("BaseElementObject_Live"."ClassName" IN (?))
0.001s
0191: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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"."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.0014s
0192: SELECT DISTINCT count(DISTINCT "BaseElementObject_Live"."ID") AS "Count"
FROM "BaseElementObject_Live" INNER JOIN "ElementSponsor_Sponsors" ON "ElementSponsor_Sponsors"."SponsorID" = "BaseElementObject_Live"."ID"
WHERE ("ElementSponsor_Sponsors"."ElementSponsorID" = ?)
AND ("BaseElementObject_Live"."ClassName" IN (?))
0.0012s
0193: SELECT DISTINCT count(DISTINCT "BaseElementObject_Live"."ID") AS "Count"
FROM "BaseElementObject_Live" INNER JOIN "ElementSponsor_Sponsors" ON "ElementSponsor_Sponsors"."SponsorID" = "BaseElementObject_Live"."ID"
WHERE ("ElementSponsor_Sponsors"."ElementSponsorID" = ?)
AND ("BaseElementObject_Live"."ClassName" IN (?))
0.0008s
0194: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.001s
0195: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementStaff_Live"."Content", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementStaff_Live" ON "ElementStaff_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0009s
0196: SELECT CASE WHEN EXISTS(SELECT *
FROM "StaffMember_Live" INNER JOIN "ElementStaff_Staff" ON "ElementStaff_Staff"."StaffMemberID" = "StaffMember_Live"."ID"
WHERE ("ElementStaff_Staff"."ElementStaffID" = ?)) THEN 1 ELSE 0 END
0.0008s
0197: SELECT DISTINCT "ElementStaff_Staff"."SortOrder", "StaffMember_Live"."ClassName", "StaffMember_Live"."LastEdited", "StaffMember_Live"."Created", "StaffMember_Live"."Version", "StaffMember_Live"."Name", "StaffMember_Live"."Content", "StaffMember_Live"."Position", "StaffMember_Live"."ImageID", "StaffMember_Live"."EmailLinkID", "StaffMember_Live"."PhoneLinkID", "StaffMember_Live"."LinkedInLinkID", "StaffMember_Live"."ID",
CASE WHEN "StaffMember_Live"."ClassName" IS NOT NULL THEN "StaffMember_Live"."ClassName"
ELSE 'Dynamic\\Essentials\\Model\\StaffMember' END AS "RecordClassName"
FROM "StaffMember_Live" INNER JOIN "ElementStaff_Staff" ON "ElementStaff_Staff"."StaffMemberID" = "StaffMember_Live"."ID"
WHERE ("ElementStaff_Staff"."ElementStaffID" = ?)
0.0009s
0198: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.001s
0199: SELECT DISTINCT "LinkField_Link_Live"."ClassName", "LinkField_Link_Live"."LastEdited", "LinkField_Link_Live"."Created", "LinkField_Link_Live"."ExtraClass", "LinkField_Link_Live"."Style", "LinkField_Link_Live"."Version", "LinkField_Link_Live"."LinkText", "LinkField_Link_Live"."OpenInNew", "LinkField_Link_Live"."Sort", "LinkField_Link_Live"."IconID", "LinkField_Link_Live"."OwnerID", "LinkField_Link_Live"."OwnerClass", "LinkField_Link_Live"."OwnerRelation", "LinkField_EmailLink_Live"."Email", "LinkField_Link_Live"."ID",
CASE WHEN "LinkField_Link_Live"."ClassName" IS NOT NULL THEN "LinkField_Link_Live"."ClassName"
ELSE 'SilverStripe\\LinkField\\Models\\Link' END AS "RecordClassName"
FROM "LinkField_Link_Live" LEFT JOIN "LinkField_EmailLink_Live" ON "LinkField_EmailLink_Live"."ID" = "LinkField_Link_Live"."ID"
WHERE ("LinkField_Link_Live"."ID" = ?)
AND ("LinkField_Link_Live"."ClassName" IN (?))
ORDER BY "LinkField_Link_Live"."Sort" ASC
LIMIT 1
0.001s
0200: SELECT DISTINCT "LinkField_Link_Live"."ClassName", "LinkField_Link_Live"."LastEdited", "LinkField_Link_Live"."Created", "LinkField_Link_Live"."ExtraClass", "LinkField_Link_Live"."Style", "LinkField_Link_Live"."Version", "LinkField_Link_Live"."LinkText", "LinkField_Link_Live"."OpenInNew", "LinkField_Link_Live"."Sort", "LinkField_Link_Live"."IconID", "LinkField_Link_Live"."OwnerID", "LinkField_Link_Live"."OwnerClass", "LinkField_Link_Live"."OwnerRelation", "LinkField_PhoneLink_Live"."Phone", "LinkField_Link_Live"."ID",
CASE WHEN "LinkField_Link_Live"."ClassName" IS NOT NULL THEN "LinkField_Link_Live"."ClassName"
ELSE 'SilverStripe\\LinkField\\Models\\Link' END AS "RecordClassName"
FROM "LinkField_Link_Live" LEFT JOIN "LinkField_PhoneLink_Live" ON "LinkField_PhoneLink_Live"."ID" = "LinkField_Link_Live"."ID"
WHERE ("LinkField_Link_Live"."ID" = ?)
AND ("LinkField_Link_Live"."ClassName" IN (?))
ORDER BY "LinkField_Link_Live"."Sort" ASC
LIMIT 1
0.0009s
0201: SELECT DISTINCT "LinkField_Link_Live"."ClassName", "LinkField_Link_Live"."LastEdited", "LinkField_Link_Live"."Created", "LinkField_Link_Live"."ExtraClass", "LinkField_Link_Live"."Style", "LinkField_Link_Live"."Version", "LinkField_Link_Live"."LinkText", "LinkField_Link_Live"."OpenInNew", "LinkField_Link_Live"."Sort", "LinkField_Link_Live"."IconID", "LinkField_Link_Live"."OwnerID", "LinkField_Link_Live"."OwnerClass", "LinkField_Link_Live"."OwnerRelation", "LinkField_ExternalLink_Live"."ExternalUrl", "LinkField_Link_Live"."ID",
CASE WHEN "LinkField_Link_Live"."ClassName" IS NOT NULL THEN "LinkField_Link_Live"."ClassName"
ELSE 'SilverStripe\\LinkField\\Models\\Link' END AS "RecordClassName"
FROM "LinkField_Link_Live" LEFT JOIN "LinkField_ExternalLink_Live" ON "LinkField_ExternalLink_Live"."ID" = "LinkField_Link_Live"."ID"
WHERE ("LinkField_Link_Live"."ID" = ?)
AND ("LinkField_Link_Live"."ClassName" IN (?, ?))
ORDER BY "LinkField_Link_Live"."Sort" ASC
LIMIT 1
0.0009s
0202: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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"."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
0203: SELECT DISTINCT "LinkField_Link_Live"."ClassName", "LinkField_Link_Live"."LastEdited", "LinkField_Link_Live"."Created", "LinkField_Link_Live"."ExtraClass", "LinkField_Link_Live"."Style", "LinkField_Link_Live"."Version", "LinkField_Link_Live"."LinkText", "LinkField_Link_Live"."OpenInNew", "LinkField_Link_Live"."Sort", "LinkField_Link_Live"."IconID", "LinkField_Link_Live"."OwnerID", "LinkField_Link_Live"."OwnerClass", "LinkField_Link_Live"."OwnerRelation", "LinkField_EmailLink_Live"."Email", "LinkField_Link_Live"."ID",
CASE WHEN "LinkField_Link_Live"."ClassName" IS NOT NULL THEN "LinkField_Link_Live"."ClassName"
ELSE 'SilverStripe\\LinkField\\Models\\Link' END AS "RecordClassName"
FROM "LinkField_Link_Live" LEFT JOIN "LinkField_EmailLink_Live" ON "LinkField_EmailLink_Live"."ID" = "LinkField_Link_Live"."ID"
WHERE ("LinkField_Link_Live"."ID" = ?)
AND ("LinkField_Link_Live"."ClassName" IN (?))
ORDER BY "LinkField_Link_Live"."Sort" ASC
LIMIT 1
0.001s
0204: SELECT DISTINCT "LinkField_Link_Live"."ClassName", "LinkField_Link_Live"."LastEdited", "LinkField_Link_Live"."Created", "LinkField_Link_Live"."ExtraClass", "LinkField_Link_Live"."Style", "LinkField_Link_Live"."Version", "LinkField_Link_Live"."LinkText", "LinkField_Link_Live"."OpenInNew", "LinkField_Link_Live"."Sort", "LinkField_Link_Live"."IconID", "LinkField_Link_Live"."OwnerID", "LinkField_Link_Live"."OwnerClass", "LinkField_Link_Live"."OwnerRelation", "LinkField_PhoneLink_Live"."Phone", "LinkField_Link_Live"."ID",
CASE WHEN "LinkField_Link_Live"."ClassName" IS NOT NULL THEN "LinkField_Link_Live"."ClassName"
ELSE 'SilverStripe\\LinkField\\Models\\Link' END AS "RecordClassName"
FROM "LinkField_Link_Live" LEFT JOIN "LinkField_PhoneLink_Live" ON "LinkField_PhoneLink_Live"."ID" = "LinkField_Link_Live"."ID"
WHERE ("LinkField_Link_Live"."ID" = ?)
AND ("LinkField_Link_Live"."ClassName" IN (?))
ORDER BY "LinkField_Link_Live"."Sort" ASC
LIMIT 1
0.001s
0205: SELECT DISTINCT "LinkField_Link_Live"."ClassName", "LinkField_Link_Live"."LastEdited", "LinkField_Link_Live"."Created", "LinkField_Link_Live"."ExtraClass", "LinkField_Link_Live"."Style", "LinkField_Link_Live"."Version", "LinkField_Link_Live"."LinkText", "LinkField_Link_Live"."OpenInNew", "LinkField_Link_Live"."Sort", "LinkField_Link_Live"."IconID", "LinkField_Link_Live"."OwnerID", "LinkField_Link_Live"."OwnerClass", "LinkField_Link_Live"."OwnerRelation", "LinkField_ExternalLink_Live"."ExternalUrl", "LinkField_Link_Live"."ID",
CASE WHEN "LinkField_Link_Live"."ClassName" IS NOT NULL THEN "LinkField_Link_Live"."ClassName"
ELSE 'SilverStripe\\LinkField\\Models\\Link' END AS "RecordClassName"
FROM "LinkField_Link_Live" LEFT JOIN "LinkField_ExternalLink_Live" ON "LinkField_ExternalLink_Live"."ID" = "LinkField_Link_Live"."ID"
WHERE ("LinkField_Link_Live"."ID" = ?)
AND ("LinkField_Link_Live"."ClassName" IN (?, ?))
ORDER BY "LinkField_Link_Live"."Sort" ASC
LIMIT 1
0.0009s
0206: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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"."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.0009s
0207: SELECT DISTINCT "LinkField_Link_Live"."ClassName", "LinkField_Link_Live"."LastEdited", "LinkField_Link_Live"."Created", "LinkField_Link_Live"."ExtraClass", "LinkField_Link_Live"."Style", "LinkField_Link_Live"."Version", "LinkField_Link_Live"."LinkText", "LinkField_Link_Live"."OpenInNew", "LinkField_Link_Live"."Sort", "LinkField_Link_Live"."IconID", "LinkField_Link_Live"."OwnerID", "LinkField_Link_Live"."OwnerClass", "LinkField_Link_Live"."OwnerRelation", "LinkField_EmailLink_Live"."Email", "LinkField_Link_Live"."ID",
CASE WHEN "LinkField_Link_Live"."ClassName" IS NOT NULL THEN "LinkField_Link_Live"."ClassName"
ELSE 'SilverStripe\\LinkField\\Models\\Link' END AS "RecordClassName"
FROM "LinkField_Link_Live" LEFT JOIN "LinkField_EmailLink_Live" ON "LinkField_EmailLink_Live"."ID" = "LinkField_Link_Live"."ID"
WHERE ("LinkField_Link_Live"."ID" = ?)
AND ("LinkField_Link_Live"."ClassName" IN (?))
ORDER BY "LinkField_Link_Live"."Sort" ASC
LIMIT 1
0.0011s
0208: SELECT DISTINCT "LinkField_Link_Live"."ClassName", "LinkField_Link_Live"."LastEdited", "LinkField_Link_Live"."Created", "LinkField_Link_Live"."ExtraClass", "LinkField_Link_Live"."Style", "LinkField_Link_Live"."Version", "LinkField_Link_Live"."LinkText", "LinkField_Link_Live"."OpenInNew", "LinkField_Link_Live"."Sort", "LinkField_Link_Live"."IconID", "LinkField_Link_Live"."OwnerID", "LinkField_Link_Live"."OwnerClass", "LinkField_Link_Live"."OwnerRelation", "LinkField_PhoneLink_Live"."Phone", "LinkField_Link_Live"."ID",
CASE WHEN "LinkField_Link_Live"."ClassName" IS NOT NULL THEN "LinkField_Link_Live"."ClassName"
ELSE 'SilverStripe\\LinkField\\Models\\Link' END AS "RecordClassName"
FROM "LinkField_Link_Live" LEFT JOIN "LinkField_PhoneLink_Live" ON "LinkField_PhoneLink_Live"."ID" = "LinkField_Link_Live"."ID"
WHERE ("LinkField_Link_Live"."ID" = ?)
AND ("LinkField_Link_Live"."ClassName" IN (?))
ORDER BY "LinkField_Link_Live"."Sort" ASC
LIMIT 1
0.0008s
0209: SELECT DISTINCT "LinkField_Link_Live"."ClassName", "LinkField_Link_Live"."LastEdited", "LinkField_Link_Live"."Created", "LinkField_Link_Live"."ExtraClass", "LinkField_Link_Live"."Style", "LinkField_Link_Live"."Version", "LinkField_Link_Live"."LinkText", "LinkField_Link_Live"."OpenInNew", "LinkField_Link_Live"."Sort", "LinkField_Link_Live"."IconID", "LinkField_Link_Live"."OwnerID", "LinkField_Link_Live"."OwnerClass", "LinkField_Link_Live"."OwnerRelation", "LinkField_ExternalLink_Live"."ExternalUrl", "LinkField_Link_Live"."ID",
CASE WHEN "LinkField_Link_Live"."ClassName" IS NOT NULL THEN "LinkField_Link_Live"."ClassName"
ELSE 'SilverStripe\\LinkField\\Models\\Link' END AS "RecordClassName"
FROM "LinkField_Link_Live" LEFT JOIN "LinkField_ExternalLink_Live" ON "LinkField_ExternalLink_Live"."ID" = "LinkField_Link_Live"."ID"
WHERE ("LinkField_Link_Live"."ID" = ?)
AND ("LinkField_Link_Live"."ClassName" IN (?, ?))
ORDER BY "LinkField_Link_Live"."Sort" ASC
LIMIT 1
0.0007s
0210: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementStatCounters_Live"."Content", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementStatCounters_Live" ON "ElementStatCounters_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0009s
0211: SELECT CASE WHEN EXISTS(SELECT *
FROM "StatCounterObject"
WHERE ("StatCounterObject"."ElementStatCountersID" = ?)) THEN 1 ELSE 0 END
0.0008s
0212: SELECT DISTINCT "StatCounterObject"."ClassName", "StatCounterObject"."LastEdited", "StatCounterObject"."Created", "StatCounterObject"."Title", "StatCounterObject"."Statistic", "StatCounterObject"."Label", "StatCounterObject"."SortOrder", "StatCounterObject"."StatType", "StatCounterObject"."ElementStatCountersID", "StatCounterObject"."ID",
CASE WHEN "StatCounterObject"."ClassName" IS NOT NULL THEN "StatCounterObject"."ClassName"
ELSE 'Dynamic\\Elements\\StatCounters\\Model\\StatCounter' END AS "RecordClassName"
FROM "StatCounterObject"
WHERE ("StatCounterObject"."ElementStatCountersID" = ?)
ORDER BY "StatCounterObject"."SortOrder" ASC
0.0007s
0213: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementTestimonials_Live"."Limit", "ElementTestimonials_Live"."Content", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementTestimonials_Live" ON "ElementTestimonials_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.001s
0214: SELECT DISTINCT count(DISTINCT "TestimonialCategory"."ID") AS "Count"
FROM "TestimonialCategory" INNER JOIN "ElementTestimonials_TestimonialCategories" ON "ElementTestimonials_TestimonialCategories"."TestimonialCategoryID" = "TestimonialCategory"."ID"
WHERE ("ElementTestimonials_TestimonialCategories"."ElementTestimonialsID" = ?)
0.0009s
0215: SELECT "TestimonialCategory"."ID"
FROM "TestimonialCategory" INNER JOIN "ElementTestimonials_TestimonialCategories" ON "ElementTestimonials_TestimonialCategories"."TestimonialCategoryID" = "TestimonialCategory"."ID"
WHERE ("ElementTestimonials_TestimonialCategories"."ElementTestimonialsID" = ?)
0.0007s
0216: SELECT CASE WHEN EXISTS(SELECT *
FROM "Testimonial" LEFT JOIN "Testimonial_TestimonialCategories" AS "testimonialcategories_Testimonial_TestimonialCategories" ON "testimonialcategories_Testimonial_TestimonialCategories"."TestimonialID" = "Testimonial"."ID" LEFT JOIN "TestimonialCategory" AS "testimonialcategories_TestimonialCategory" ON "testimonialcategories_Testimonial_TestimonialCategories"."TestimonialCategoryID" = "testimonialcategories_TestimonialCategory"."ID"
WHERE (("testimonialcategories_TestimonialCategory"."ID" IN (1, 2)))
LIMIT 3) THEN 1 ELSE 0 END
0.0015s
0217: SELECT DISTINCT RAND() AS "_SortColumn0", "Testimonial"."ClassName", "Testimonial"."LastEdited", "Testimonial"."Created", "Testimonial"."Title", "Testimonial"."Content", "Testimonial"."Name", "Testimonial"."Position", "Testimonial"."Affiliation", "Testimonial"."ID",
CASE WHEN "Testimonial"."ClassName" IS NOT NULL THEN "Testimonial"."ClassName"
ELSE 'Dynamic\\Elements\\Model\\Testimonial' END AS "RecordClassName"
FROM "Testimonial" LEFT JOIN "Testimonial_TestimonialCategories" AS "testimonialcategories_Testimonial_TestimonialCategories" ON "testimonialcategories_Testimonial_TestimonialCategories"."TestimonialID" = "Testimonial"."ID" LEFT JOIN "TestimonialCategory" AS "testimonialcategories_TestimonialCategory" ON "testimonialcategories_Testimonial_TestimonialCategories"."TestimonialCategoryID" = "testimonialcategories_TestimonialCategory"."ID"
WHERE (("testimonialcategories_TestimonialCategory"."ID" IN (1, 2)))
ORDER BY "_SortColumn0" ASC
LIMIT 3
0.001s
0218: SELECT DISTINCT count(DISTINCT "Testimonial"."ID") AS "Count"
FROM "Testimonial" LEFT JOIN "Testimonial_TestimonialCategories" AS "testimonialcategories_Testimonial_TestimonialCategories" ON "testimonialcategories_Testimonial_TestimonialCategories"."TestimonialID" = "Testimonial"."ID" LEFT JOIN "TestimonialCategory" AS "testimonialcategories_TestimonialCategory" ON "testimonialcategories_Testimonial_TestimonialCategories"."TestimonialCategoryID" = "testimonialcategories_TestimonialCategory"."ID"
WHERE (("testimonialcategories_TestimonialCategory"."ID" IN (1, 2)))
0.0009s
0219: SELECT DISTINCT RAND() AS "_SortColumn0", "Testimonial"."ClassName", "Testimonial"."LastEdited", "Testimonial"."Created", "Testimonial"."Title", "Testimonial"."Content", "Testimonial"."Name", "Testimonial"."Position", "Testimonial"."Affiliation", "Testimonial"."ID",
CASE WHEN "Testimonial"."ClassName" IS NOT NULL THEN "Testimonial"."ClassName"
ELSE 'Dynamic\\Elements\\Model\\Testimonial' END AS "RecordClassName"
FROM "Testimonial" LEFT JOIN "Testimonial_TestimonialCategories" AS "testimonialcategories_Testimonial_TestimonialCategories" ON "testimonialcategories_Testimonial_TestimonialCategories"."TestimonialID" = "Testimonial"."ID" LEFT JOIN "TestimonialCategory" AS "testimonialcategories_TestimonialCategory" ON "testimonialcategories_Testimonial_TestimonialCategories"."TestimonialCategoryID" = "testimonialcategories_TestimonialCategory"."ID"
WHERE (("testimonialcategories_TestimonialCategory"."ID" IN (1, 2)))
ORDER BY "_SortColumn0" ASC
LIMIT 3
0.0012s
0220: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "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"."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.0012s
0221: SELECT CASE WHEN EXISTS(SELECT *
FROM "SocialMetaBusinessLocation_Live"
WHERE ("SocialMetaBusinessLocation_Live"."SocialMetaConfigOfClass" IN ('SilverStripe\\SiteConfig\\SiteConfig'))
AND ("SocialMetaBusinessLocation_Live"."SocialMetaConfigOfID" = ?)
AND ("SocialMetaBusinessLocation_Live"."ShowInFooter" = ?)) THEN 1 ELSE 0 END
0.0013s
0222: SELECT CASE WHEN EXISTS(SELECT *
FROM "NavigationColumn"
WHERE ("NavigationColumn"."ConfigID" = ?)) THEN 1 ELSE 0 END
0.0009s
0223: SELECT DISTINCT "NavigationColumn"."ClassName", "NavigationColumn"."LastEdited", "NavigationColumn"."Created", "NavigationColumn"."Title", "NavigationColumn"."SortOrder", "NavigationColumn"."ConfigID", "NavigationColumn"."ID",
CASE WHEN "NavigationColumn"."ClassName" IS NOT NULL THEN "NavigationColumn"."ClassName"
ELSE 'Dynamic\\Base\\Model\\NavigationColumn' END AS "RecordClassName"
FROM "NavigationColumn"
WHERE ("NavigationColumn"."ConfigID" = ?)
ORDER BY "NavigationColumn"."SortOrder" ASC
0.0008s
0224: SELECT DISTINCT "NavigationGroup"."ClassName", "NavigationGroup"."LastEdited", "NavigationGroup"."Created", "NavigationGroup"."Title", "NavigationGroup"."SortOrder", "NavigationGroup"."NavigationColumnID", "NavigationGroup"."ID",
CASE WHEN "NavigationGroup"."ClassName" IS NOT NULL THEN "NavigationGroup"."ClassName"
ELSE 'Dynamic\\Base\\Model\\NavigationGroup' END AS "RecordClassName"
FROM "NavigationGroup"
WHERE ("NavigationGroup"."NavigationColumnID" = ?)
ORDER BY "NavigationGroup"."SortOrder" ASC
0.001s
0225: SELECT DISTINCT count(DISTINCT "LinkField_Link_Live"."ID") AS "Count"
FROM "LinkField_Link_Live"
WHERE ("LinkField_Link_Live"."OwnerClass" IN ('Dynamic\\Base\\Model\\NavigationGroup'))
AND ("LinkField_Link_Live"."OwnerRelation" = ?)
AND ("LinkField_Link_Live"."OwnerID" = ?)
0.0009s
0226: SELECT DISTINCT "NavigationGroup"."ClassName", "NavigationGroup"."LastEdited", "NavigationGroup"."Created", "NavigationGroup"."Title", "NavigationGroup"."SortOrder", "NavigationGroup"."NavigationColumnID", "NavigationGroup"."ID",
CASE WHEN "NavigationGroup"."ClassName" IS NOT NULL THEN "NavigationGroup"."ClassName"
ELSE 'Dynamic\\Base\\Model\\NavigationGroup' END AS "RecordClassName"
FROM "NavigationGroup"
WHERE ("NavigationGroup"."NavigationColumnID" = ?)
ORDER BY "NavigationGroup"."SortOrder" ASC
0.0009s
0227: SELECT DISTINCT count(DISTINCT "LinkField_Link_Live"."ID") AS "Count"
FROM "LinkField_Link_Live"
WHERE ("LinkField_Link_Live"."OwnerClass" IN ('Dynamic\\Base\\Model\\NavigationGroup'))
AND ("LinkField_Link_Live"."OwnerRelation" = ?)
AND ("LinkField_Link_Live"."OwnerID" = ?)
0.0008s
0228: SELECT DISTINCT "NavigationGroup"."ClassName", "NavigationGroup"."LastEdited", "NavigationGroup"."Created", "NavigationGroup"."Title", "NavigationGroup"."SortOrder", "NavigationGroup"."NavigationColumnID", "NavigationGroup"."ID",
CASE WHEN "NavigationGroup"."ClassName" IS NOT NULL THEN "NavigationGroup"."ClassName"
ELSE 'Dynamic\\Base\\Model\\NavigationGroup' END AS "RecordClassName"
FROM "NavigationGroup"
WHERE ("NavigationGroup"."NavigationColumnID" = ?)
ORDER BY "NavigationGroup"."SortOrder" ASC
0.0009s
0229: SELECT DISTINCT count(DISTINCT "LinkField_Link_Live"."ID") AS "Count"
FROM "LinkField_Link_Live"
WHERE ("LinkField_Link_Live"."OwnerClass" IN ('Dynamic\\Base\\Model\\NavigationGroup'))
AND ("LinkField_Link_Live"."OwnerRelation" = ?)
AND ("LinkField_Link_Live"."OwnerID" = ?)
0.0009s
0230: SELECT CASE WHEN EXISTS(SELECT *
FROM "AppContentItem"
WHERE ("AppContentItem"."SiteConfigID" = ?)) THEN 1 ELSE 0 END
0.001s
0231: SELECT CASE WHEN EXISTS(SELECT *
FROM "LinkField_Link_Live" LEFT JOIN "LinkField_ExternalLink_Live" ON "LinkField_ExternalLink_Live"."ID" = "LinkField_Link_Live"."ID" LEFT JOIN "SocialLink_Live" ON "SocialLink_Live"."ID" = "LinkField_Link_Live"."ID"
WHERE ("LinkField_Link_Live"."OwnerClass" IN ('SilverStripe\\SiteConfig\\SiteConfig'))
AND ("LinkField_Link_Live"."OwnerRelation" = ?)
AND ("LinkField_Link_Live"."OwnerID" = ?)
AND ("LinkField_Link_Live"."ClassName" IN (?))) THEN 1 ELSE 0 END
0.0014s
0232: SELECT DISTINCT "LinkField_Link_Live"."ClassName", "LinkField_Link_Live"."LastEdited", "LinkField_Link_Live"."Created", "LinkField_Link_Live"."ExtraClass", "LinkField_Link_Live"."Style", "LinkField_Link_Live"."Version", "LinkField_Link_Live"."LinkText", "LinkField_Link_Live"."OpenInNew", "LinkField_Link_Live"."Sort", "LinkField_Link_Live"."IconID", "LinkField_Link_Live"."OwnerID", "LinkField_Link_Live"."OwnerClass", "LinkField_Link_Live"."OwnerRelation", "LinkField_ExternalLink_Live"."ExternalUrl", "SocialLink_Live"."SocialChannel", "LinkField_Link_Live"."ID",
CASE WHEN "LinkField_Link_Live"."ClassName" IS NOT NULL THEN "LinkField_Link_Live"."ClassName"
ELSE 'SilverStripe\\LinkField\\Models\\Link' END AS "RecordClassName"
FROM "LinkField_Link_Live" LEFT JOIN "LinkField_ExternalLink_Live" ON "LinkField_ExternalLink_Live"."ID" = "LinkField_Link_Live"."ID" LEFT JOIN "SocialLink_Live" ON "SocialLink_Live"."ID" = "LinkField_Link_Live"."ID"
WHERE ("LinkField_Link_Live"."OwnerClass" IN ('SilverStripe\\SiteConfig\\SiteConfig'))
AND ("LinkField_Link_Live"."OwnerRelation" = ?)
AND ("LinkField_Link_Live"."OwnerID" = ?)
AND ("LinkField_Link_Live"."ClassName" IN (?))
ORDER BY "LinkField_Link_Live"."Sort" ASC
0.0018s
0233: SELECT CASE WHEN EXISTS(SELECT *
FROM "AppLogo"
WHERE ("AppLogo"."SiteConfigID" = ?)) THEN 1 ELSE 0 END
0.0011s
0234: SELECT "Version" FROM "SiteTree" WHERE "ID" = ?
0.001s
0235: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaCanonicalURL", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."MetaImageID", "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.001s
0236: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaCanonicalURL", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."MetaImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0011s
0237: SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", "SiteTree"."Priority", "SiteTree"."ShareTokenSalt", "SiteTree"."MetaTitle", "SiteTree"."MetaCanonicalURL", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."Version", "SiteTree"."URLSegment", "SiteTree"."Title", "SiteTree"."MenuTitle", "SiteTree"."Content", "SiteTree"."MetaDescription", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", "SiteTree"."ReportClass", "SiteTree"."MetaImageID", "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.0011s
0238: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaCanonicalURL", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."MetaImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0012s
Elements | Precision MFG Co.
Showcase
Element Showcase
A comprehensive showcase of all available elements in alphabetical order.
Collapsible Content
Accordion Element
Expandable accordion panels for FAQs and organized content.
Content for What materials do you work with?
We machine a wide variety of materials including aluminum, steel, stainless steel, brass, bronze, copper, and engineered plastics like Delrin, UHMW, and Nylon.
Showcase team members with photos, names, titles, and bios.
John Peterson
President & CEO
John co-founded Precision MFG Co. in 1985. He holds a degree in Mechanical Engineering from UW-Madison and has over 40 years of experience in the manufacturing industry.
Sarah joined Precision MFG Co. in 2005. She earned her Industrial Engineering degree from Michigan Tech and holds a Six Sigma Black Belt certification.