0002: SHOW DATABASES LIKE 'fishandgamedev'
0.0007s
0003: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "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.0016s
0004: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."URLSegment" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0011s
0005: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."URLSegment" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0012s
0006: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."URLSegment" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0011s
0007: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "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
0008: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "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
0009: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "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
0010: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", "SiteConfig"."AllowedCountries", "SiteConfig"."CodeSnippetHTMLHead", "SiteConfig"."CodeSnippetHTMLBodyStart", "SiteConfig"."CodeSnippetHTMLBodyEnd", "SiteConfig"."FooterText", "SiteConfig"."FacebookURL", "SiteConfig"."TwitterURL", "SiteConfig"."YouTubeURL", "SiteConfig"."LinkedInURL", "SiteConfig"."VimeoURL", "SiteConfig"."GooglePlusURL", "SiteConfig"."InstagramURL", "SiteConfig"."SoundCloudURL", "SiteConfig"."MyspaceURL", "SiteConfig"."PinterestURL", "SiteConfig"."TumblrURL", "SiteConfig"."CampaignMonitorListID", "SiteConfig"."StaticCacheURLsToProcess", "SiteConfig"."StaticCacheURLsToCleanUp", "SiteConfig"."StaticCacheSkippedURLs", "SiteConfig"."StaticCacheProcessedURLs", "SiteConfig"."Title", "SiteConfig"."Tagline", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."TermsPageID", "SiteConfig"."CustomerGroupID", "SiteConfig"."DefaultProductImageID", "SiteConfig"."SocialMediaImageID", "SiteConfig"."PlaceholderImageID", "SiteConfig"."MenuImageID", "SiteConfig"."ID",
CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName"
ELSE 'SilverStripe\\SiteConfig\\SiteConfig' END AS "RecordClassName"
FROM "SiteConfig"
LIMIT 1
0.0025s
0011: SELECT DISTINCT "PublishDate" IS NULL AS "_SortColumn0", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "BlogPost_Live"."FeaturedInWidget", "BlogPost_Live"."PublishDate", "BlogPost_Live"."AuthorNames", "BlogPost_Live"."Summary", "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 "BlogPost_Live" ON "BlogPost_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
AND ("PublishDate" < '2025-06-29 16:04:48')
ORDER BY "BlogPost_Live"."FeaturedInWidget" DESC, "_SortColumn0" DESC, "BlogPost_Live"."PublishDate" DESC
LIMIT 1
0.0009s
0012: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."Icon", "Page_Live"."ThemeClass", "Page_Live"."IntroText", "Page_Live"."LegacyID", "Page_Live"."ElementalAreaID", "Page_Live"."ImageFolderID", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BragPage', 'HomePage', 'ListingPageImageCards', 'NewsletterPage', 'PaymentPage', 'RegionHolderPage', 'RegionPage', 'RegulationsPage', 'RegulationsViewPage', 'SearchResultsPage', 'TopicHolderPage', 'TopicPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverShop\\Page\\AccountPage', 'SilverShop\\Page\\CartPage', 'SilverShop\\Page\\CheckoutPage', 'SilverShop\\Page\\Product', 'SilverShop\\Page\\ProductCategory', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm') THEN "Page_Live"."ImageID" WHEN "SiteTree_Live"."ClassName" IN ('SilverShop\\Page\\Product') THEN "SilverShop_Product_Live"."ImageID" ELSE NULL END AS "ImageID", "Page_Live"."MenuImageID", "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 "SilverShop_Product_Live" ON "SilverShop_Product_Live"."ID" = "SiteTree_Live"."ID" INNER JOIN "BlogPost_Live" ON "SiteTree_Live"."ID" = "BlogPost_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0012s
0013: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."Icon", "Page_Live"."ThemeClass", "Page_Live"."IntroText", "Page_Live"."LegacyID", "Page_Live"."ElementalAreaID", "Page_Live"."ImageFolderID", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BragPage', 'HomePage', 'ListingPageImageCards', 'NewsletterPage', 'PaymentPage', 'RegionHolderPage', 'RegionPage', 'RegulationsPage', 'RegulationsViewPage', 'SearchResultsPage', 'TopicHolderPage', 'TopicPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverShop\\Page\\AccountPage', 'SilverShop\\Page\\CartPage', 'SilverShop\\Page\\CheckoutPage', 'SilverShop\\Page\\Product', 'SilverShop\\Page\\ProductCategory', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm') THEN "Page_Live"."ImageID" WHEN "SiteTree_Live"."ClassName" IN ('SilverShop\\Page\\Product') THEN "SilverShop_Product_Live"."ImageID" ELSE NULL END AS "ImageID", "Page_Live"."MenuImageID", "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 "SilverShop_Product_Live" ON "SilverShop_Product_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0011s
0014: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."Icon", "Page_Live"."ThemeClass", "Page_Live"."IntroText", "Page_Live"."LegacyID", "Page_Live"."ElementalAreaID", "Page_Live"."ImageFolderID", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BragPage', 'HomePage', 'ListingPageImageCards', 'NewsletterPage', 'PaymentPage', 'RegionHolderPage', 'RegionPage', 'RegulationsPage', 'RegulationsViewPage', 'SearchResultsPage', 'TopicHolderPage', 'TopicPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverShop\\Page\\AccountPage', 'SilverShop\\Page\\CartPage', 'SilverShop\\Page\\CheckoutPage', 'SilverShop\\Page\\Product', 'SilverShop\\Page\\ProductCategory', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm') THEN "Page_Live"."ImageID" WHEN "SiteTree_Live"."ClassName" IN ('SilverShop\\Page\\Product') THEN "SilverShop_Product_Live"."ImageID" ELSE NULL END AS "ImageID", "Page_Live"."MenuImageID", "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 "SilverShop_Product_Live" ON "SilverShop_Product_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.001s
0015: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."Icon", "Page_Live"."ThemeClass", "Page_Live"."IntroText", "Page_Live"."LegacyID", "Page_Live"."ElementalAreaID", "Page_Live"."ImageFolderID", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BragPage', 'HomePage', 'ListingPageImageCards', 'NewsletterPage', 'PaymentPage', 'RegionHolderPage', 'RegionPage', 'RegulationsPage', 'RegulationsViewPage', 'SearchResultsPage', 'TopicHolderPage', 'TopicPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverShop\\Page\\AccountPage', 'SilverShop\\Page\\CartPage', 'SilverShop\\Page\\CheckoutPage', 'SilverShop\\Page\\Product', 'SilverShop\\Page\\ProductCategory', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm') THEN "Page_Live"."ImageID" WHEN "SiteTree_Live"."ClassName" IN ('SilverShop\\Page\\Product') THEN "SilverShop_Product_Live"."ImageID" ELSE NULL END AS "ImageID", "Page_Live"."MenuImageID", "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 "SilverShop_Product_Live" ON "SilverShop_Product_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.001s
0016: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited")
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
0.0065s
0017: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "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.0011s
0018: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."Icon", "Page_Live"."ThemeClass", "Page_Live"."IntroText", "Page_Live"."LegacyID", "Page_Live"."ElementalAreaID", "Page_Live"."ImageFolderID", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BragPage', 'HomePage', 'ListingPageImageCards', 'NewsletterPage', 'PaymentPage', 'RegionHolderPage', 'RegionPage', 'RegulationsPage', 'RegulationsViewPage', 'SearchResultsPage', 'TopicHolderPage', 'TopicPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverShop\\Page\\AccountPage', 'SilverShop\\Page\\CartPage', 'SilverShop\\Page\\CheckoutPage', 'SilverShop\\Page\\Product', 'SilverShop\\Page\\ProductCategory', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm') THEN "Page_Live"."ImageID" WHEN "SiteTree_Live"."ClassName" IN ('SilverShop\\Page\\Product') THEN "SilverShop_Product_Live"."ImageID" ELSE NULL END AS "ImageID", "Page_Live"."MenuImageID", "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 "SilverShop_Product_Live" ON "SilverShop_Product_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0011s
0019: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "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
0020: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "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.0013s
0021: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "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
0022: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."Icon", "Page_Live"."ThemeClass", "Page_Live"."IntroText", "Page_Live"."LegacyID", "Page_Live"."ElementalAreaID", "Page_Live"."ImageFolderID", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BragPage', 'HomePage', 'ListingPageImageCards', 'NewsletterPage', 'PaymentPage', 'RegionHolderPage', 'RegionPage', 'RegulationsPage', 'RegulationsViewPage', 'SearchResultsPage', 'TopicHolderPage', 'TopicPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverShop\\Page\\AccountPage', 'SilverShop\\Page\\CartPage', 'SilverShop\\Page\\CheckoutPage', 'SilverShop\\Page\\Product', 'SilverShop\\Page\\ProductCategory', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm') THEN "Page_Live"."ImageID" WHEN "SiteTree_Live"."ClassName" IN ('SilverShop\\Page\\Product') THEN "SilverShop_Product_Live"."ImageID" ELSE NULL END AS "ImageID", "Page_Live"."MenuImageID", "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 "SilverShop_Product_Live" ON "SilverShop_Product_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.001s
0023: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."Icon", "Page_Live"."ThemeClass", "Page_Live"."IntroText", "Page_Live"."LegacyID", "Page_Live"."ElementalAreaID", "Page_Live"."ImageFolderID", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BragPage', 'HomePage', 'ListingPageImageCards', 'NewsletterPage', 'PaymentPage', 'RegionHolderPage', 'RegionPage', 'RegulationsPage', 'RegulationsViewPage', 'SearchResultsPage', 'TopicHolderPage', 'TopicPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverShop\\Page\\AccountPage', 'SilverShop\\Page\\CartPage', 'SilverShop\\Page\\CheckoutPage', 'SilverShop\\Page\\Product', 'SilverShop\\Page\\ProductCategory', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm') THEN "Page_Live"."ImageID" WHEN "SiteTree_Live"."ClassName" IN ('SilverShop\\Page\\Product') THEN "SilverShop_Product_Live"."ImageID" ELSE NULL END AS "ImageID", "Page_Live"."MenuImageID", "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 "SilverShop_Product_Live" ON "SilverShop_Product_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.001s
0024: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."Icon", "Page_Live"."ThemeClass", "Page_Live"."IntroText", "Page_Live"."LegacyID", "Page_Live"."ElementalAreaID", "Page_Live"."ImageFolderID", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BragPage', 'HomePage', 'ListingPageImageCards', 'NewsletterPage', 'PaymentPage', 'RegionHolderPage', 'RegionPage', 'RegulationsPage', 'RegulationsViewPage', 'SearchResultsPage', 'TopicHolderPage', 'TopicPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverShop\\Page\\AccountPage', 'SilverShop\\Page\\CartPage', 'SilverShop\\Page\\CheckoutPage', 'SilverShop\\Page\\Product', 'SilverShop\\Page\\ProductCategory', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm') THEN "Page_Live"."ImageID" WHEN "SiteTree_Live"."ClassName" IN ('SilverShop\\Page\\Product') THEN "SilverShop_Product_Live"."ImageID" ELSE NULL END AS "ImageID", "Page_Live"."MenuImageID", "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 "SilverShop_Product_Live" ON "SilverShop_Product_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.001s
0025: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited")
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
0.0063s
0026: SELECT DISTINCT "SiteAlertBanner_Live"."ClassName", "SiteAlertBanner_Live"."LastEdited", "SiteAlertBanner_Live"."Created", "SiteAlertBanner_Live"."Icon", "SiteAlertBanner_Live"."Version", "SiteAlertBanner_Live"."Title", "SiteAlertBanner_Live"."Description", "SiteAlertBanner_Live"."Global", "SiteAlertBanner_Live"."DisableDismiss", "SiteAlertBanner_Live"."CurrentTheme", "SiteAlertBanner_Live"."DisplayedPageID", "SiteAlertBanner_Live"."ButtonLinkID", "SiteAlertBanner_Live"."ID",
CASE WHEN "SiteAlertBanner_Live"."ClassName" IS NOT NULL THEN "SiteAlertBanner_Live"."ClassName"
ELSE 'DNADesign\\AlertBanner\\AlertBanner' END AS "RecordClassName"
FROM "SiteAlertBanner_Live"
ORDER BY "SiteAlertBanner_Live"."ID" DESC
0.0004s
0027: 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
0028: SELECT DISTINCT "BlogTag"."Title"
FROM "BlogTag" INNER JOIN "BlogPost_Tags" ON "BlogPost_Tags"."BlogTagID" = "BlogTag"."ID"
WHERE ("BlogPost_Tags"."BlogPostID" = ?)
0.0007s
0029: SELECT DISTINCT "Member"."ClassName", "Member"."LastEdited", "Member"."Created", "Member"."URLSegment", "Member"."BlogProfileSummary", "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"."DefaultShippingAddressID", "Member"."DefaultBillingAddressID", "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.0027s
0030: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."SortID", "File_Live"."FileContentCache", "File_Live"."Description", "File_Live"."LegacyID", "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
0031: 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.0007s
0032: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "Element_Live"."Version", "Element_Live"."Title", "Element_Live"."ShowTitle", "Element_Live"."Sort", "Element_Live"."ExtraClass", "Element_Live"."Style", "Element_Live"."TopPageID", "Element_Live"."ParentID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName"
FROM "Element_Live"
WHERE ("Element_Live"."ParentID" = ?)
ORDER BY "Element_Live"."Sort" ASC
0.0007s
0033: 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.0006s
0034: SELECT DISTINCT "PublishDate" IS NULL AS "_SortColumn0", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "SiteTree_Live"."ParentID", "Page_Live"."Icon", "Page_Live"."ThemeClass", "Page_Live"."IntroText", "Page_Live"."LegacyID", "Page_Live"."ElementalAreaID", "Page_Live"."ImageFolderID", "Page_Live"."ImageID", "Page_Live"."MenuImageID", "BlogPost_Live"."FeaturedInWidget", "BlogPost_Live"."PublishDate", "BlogPost_Live"."AuthorNames", "BlogPost_Live"."Summary", "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 ("Page_Live"."ElementalAreaID" = ?)
AND ("SiteTree_Live"."ClassName" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
AND ("PublishDate" < '2025-06-29 16:04:48')
ORDER BY "BlogPost_Live"."FeaturedInWidget" DESC, "_SortColumn0" DESC, "BlogPost_Live"."PublishDate" DESC
LIMIT 1
0.0037s
0035: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "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
0036: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "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
0037: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "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
0038: 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.0006s
0039: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementContent_Live"."HTML", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementContent_Live" ON "ElementContent_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0007s
0040: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited")
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
0.0064s
0041: SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."URLSegment" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
0.001s
0042: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "SiteTree_Live"."ParentID", "Page_Live"."Icon", "Page_Live"."ThemeClass", "Page_Live"."IntroText", "Page_Live"."LegacyID", "Page_Live"."ElementalAreaID", "Page_Live"."ImageFolderID", "Page_Live"."ImageID", "Page_Live"."MenuImageID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."URLSegment" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0034s
0043: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "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
0044: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "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
0045: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "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
0046: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "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
0047: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "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
0048: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "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
0049: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "RedirectorPage_Live"."RedirectionType", "RedirectorPage_Live"."ExternalURL", "RedirectorPage_Live"."LinkToID", "RedirectorPage_Live"."LinkToFileID", "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 "RedirectorPage_Live" ON "RedirectorPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0007s
0050: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."Icon", "Page_Live"."ThemeClass", "Page_Live"."IntroText", "Page_Live"."LegacyID", "Page_Live"."ElementalAreaID", "Page_Live"."ImageFolderID", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BragPage', 'HomePage', 'ListingPageImageCards', 'NewsletterPage', 'PaymentPage', 'RegionHolderPage', 'RegionPage', 'RegulationsPage', 'RegulationsViewPage', 'SearchResultsPage', 'TopicHolderPage', 'TopicPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverShop\\Page\\AccountPage', 'SilverShop\\Page\\CartPage', 'SilverShop\\Page\\CheckoutPage', 'SilverShop\\Page\\Product', 'SilverShop\\Page\\ProductCategory', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm') THEN "Page_Live"."ImageID" WHEN "SiteTree_Live"."ClassName" IN ('SilverShop\\Page\\Product') THEN "SilverShop_Product_Live"."ImageID" ELSE NULL END AS "ImageID", "Page_Live"."MenuImageID", "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 "SilverShop_Product_Live" ON "SilverShop_Product_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0009s
0051: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "RedirectorPage_Live"."RedirectionType", "RedirectorPage_Live"."ExternalURL", "RedirectorPage_Live"."LinkToID", "RedirectorPage_Live"."LinkToFileID", "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 "RedirectorPage_Live" ON "RedirectorPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0007s
0052: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "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"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "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
0054: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."Icon", "Page_Live"."ThemeClass", "Page_Live"."IntroText", "Page_Live"."LegacyID", "Page_Live"."ElementalAreaID", "Page_Live"."ImageFolderID", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BragPage', 'HomePage', 'ListingPageImageCards', 'NewsletterPage', 'PaymentPage', 'RegionHolderPage', 'RegionPage', 'RegulationsPage', 'RegulationsViewPage', 'SearchResultsPage', 'TopicHolderPage', 'TopicPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverShop\\Page\\AccountPage', 'SilverShop\\Page\\CartPage', 'SilverShop\\Page\\CheckoutPage', 'SilverShop\\Page\\Product', 'SilverShop\\Page\\ProductCategory', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm') THEN "Page_Live"."ImageID" WHEN "SiteTree_Live"."ClassName" IN ('SilverShop\\Page\\Product') THEN "SilverShop_Product_Live"."ImageID" ELSE NULL END AS "ImageID", "Page_Live"."MenuImageID", "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 "SilverShop_Product_Live" ON "SilverShop_Product_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0009s
0055: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "RedirectorPage_Live"."RedirectionType", "RedirectorPage_Live"."ExternalURL", "RedirectorPage_Live"."LinkToID", "RedirectorPage_Live"."LinkToFileID", "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 "RedirectorPage_Live" ON "RedirectorPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0007s
0056: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "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
0057: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "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
0058: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "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
0059: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."Icon", "Page_Live"."ThemeClass", "Page_Live"."IntroText", "Page_Live"."LegacyID", "Page_Live"."ElementalAreaID", "Page_Live"."ImageFolderID", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BragPage', 'HomePage', 'ListingPageImageCards', 'NewsletterPage', 'PaymentPage', 'RegionHolderPage', 'RegionPage', 'RegulationsPage', 'RegulationsViewPage', 'SearchResultsPage', 'TopicHolderPage', 'TopicPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverShop\\Page\\AccountPage', 'SilverShop\\Page\\CartPage', 'SilverShop\\Page\\CheckoutPage', 'SilverShop\\Page\\Product', 'SilverShop\\Page\\ProductCategory', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm') THEN "Page_Live"."ImageID" WHEN "SiteTree_Live"."ClassName" IN ('SilverShop\\Page\\Product') THEN "SilverShop_Product_Live"."ImageID" ELSE NULL END AS "ImageID", "Page_Live"."MenuImageID", "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 "SilverShop_Product_Live" ON "SilverShop_Product_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0009s
0060: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "RedirectorPage_Live"."RedirectionType", "RedirectorPage_Live"."ExternalURL", "RedirectorPage_Live"."LinkToID", "RedirectorPage_Live"."LinkToFileID", "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 "RedirectorPage_Live" ON "RedirectorPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0007s
0061: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "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
0062: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "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
0063: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."Icon", "Page_Live"."ThemeClass", "Page_Live"."IntroText", "Page_Live"."LegacyID", "Page_Live"."ElementalAreaID", "Page_Live"."ImageFolderID", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BragPage', 'HomePage', 'ListingPageImageCards', 'NewsletterPage', 'PaymentPage', 'RegionHolderPage', 'RegionPage', 'RegulationsPage', 'RegulationsViewPage', 'SearchResultsPage', 'TopicHolderPage', 'TopicPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverShop\\Page\\AccountPage', 'SilverShop\\Page\\CartPage', 'SilverShop\\Page\\CheckoutPage', 'SilverShop\\Page\\Product', 'SilverShop\\Page\\ProductCategory', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm') THEN "Page_Live"."ImageID" WHEN "SiteTree_Live"."ClassName" IN ('SilverShop\\Page\\Product') THEN "SilverShop_Product_Live"."ImageID" ELSE NULL END AS "ImageID", "Page_Live"."MenuImageID", "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 "SilverShop_Product_Live" ON "SilverShop_Product_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0009s
0064: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "RedirectorPage_Live"."RedirectionType", "RedirectorPage_Live"."ExternalURL", "RedirectorPage_Live"."LinkToID", "RedirectorPage_Live"."LinkToFileID", "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 "RedirectorPage_Live" ON "RedirectorPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0007s
0065: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "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
0066: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "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
0067: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "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
0068: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "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
0069: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."Icon", "Page_Live"."ThemeClass", "Page_Live"."IntroText", "Page_Live"."LegacyID", "Page_Live"."ElementalAreaID", "Page_Live"."ImageFolderID", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BragPage', 'HomePage', 'ListingPageImageCards', 'NewsletterPage', 'PaymentPage', 'RegionHolderPage', 'RegionPage', 'RegulationsPage', 'RegulationsViewPage', 'SearchResultsPage', 'TopicHolderPage', 'TopicPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverShop\\Page\\AccountPage', 'SilverShop\\Page\\CartPage', 'SilverShop\\Page\\CheckoutPage', 'SilverShop\\Page\\Product', 'SilverShop\\Page\\ProductCategory', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm') THEN "Page_Live"."ImageID" WHEN "SiteTree_Live"."ClassName" IN ('SilverShop\\Page\\Product') THEN "SilverShop_Product_Live"."ImageID" ELSE NULL END AS "ImageID", "Page_Live"."MenuImageID", "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 "SilverShop_Product_Live" ON "SilverShop_Product_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.001s
0070: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited")
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
0.0063s
0071: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited")
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
0.0062s
0072: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited")
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
0.0062s
0073: SELECT "Version" FROM "SiteTree" WHERE "ID" = ?
0.0005s
0074: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "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.0014s
0075: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "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
0076: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "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
0077: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "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
0078: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "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
0079: SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", "SiteTree"."Priority", "SiteTree"."MetaTitle", "SiteTree"."CodeSnippetHTMLHead", "SiteTree"."CodeSnippetHTMLBodyStart", "SiteTree"."CodeSnippetHTMLBodyEnd", "SiteTree"."DMSFilesSortBy", "SiteTree"."PaginateResults", "SiteTree"."DMSItemsPerPage", "SiteTree"."DMSCombineFolders", "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"."SocialMediaImageID", "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.0007s
0080: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "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
0081: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "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
0082: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "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
0083: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."CodeSnippetHTMLHead", "SiteTree_Live"."CodeSnippetHTMLBodyStart", "SiteTree_Live"."CodeSnippetHTMLBodyEnd", "SiteTree_Live"."DMSFilesSortBy", "SiteTree_Live"."PaginateResults", "SiteTree_Live"."DMSItemsPerPage", "SiteTree_Live"."DMSCombineFolders", "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"."SocialMediaImageID", "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
Canterbury Anglers get Covid-19 bonus - Fish & Game
Canterbury Anglers get Covid-19 bonus
North Canterbury
15/05/2020
Richie Cosgrove
Anglers in North Canterbury who have spent the last seven weeks in various forms of lockdown are now able to fish selected lakes and rivers that would be normally closed at this time of year.
The North Canterbury Fish & Game Council applied to the Minister of Conservation for an amendment to the Sports Fishing Notice, North Canterbury anglers can now fish these selected waterways.
“This is great news for Canterbury anglers who had lost fishing opportunities due to a combination of Covid-19 restrictions. We thank the Minister for her support of North Canterbury anglers and her speedy decision” says Alan Strong, Chairman of the North Canterbury Fish and Game Council.
“The extension of the season will be a welcome relief during these stressful times, and we encourage people to enjoy the spectacular freshwater fishing opportunities that the North Canterbury region has to offer, as well as to allow them the chance to go out and catch a trout for the table” Strong says.
The Covid-19 pandemic and the subsequent lockdown imposed by the Government meant that anglers were unable to utilise the last six weeks of the traditional fishing season.
North Canterbury Fish & Game CEO Rasmus Gabrielsson says “For the last four years most waterways in the North Canterbury region have closed at the end of April, and as a result our reduced winter season (1 May to 30 September) has offered less opportunities compared to most other South Island regions”.
“This lack of winter fishing opportunity is something that North Canterbury Fish & Game is looking to rectify long term, through a review of the fishing regulations for next season. However, the Council deemed it appropriate to consider allowing more opportunity sooner. So, we applied to the Minister of Conservation for a one-off amendment and extension to the current fishing season. These are extraordinary circumstances that certainly justify practical adjustment to ensure anglers get some local recreation opportunities to get into the outdoors” Gabrielsson says.
The extension applies to a selected number of waterways that anglers can fish in, close to our population centres which gives anglers the opportunity to fish locally and close to home in keeping with Covid-19 conditions.
The waterways and lower sections of larger rivers included in the application were carefully selected to ensure that no known major spawning areas are put at risk. Because important spawning areas are protected it is not considered any additional harvest pressure, or angling opportunities will risk endangering the long-term sustainability of sports fish populations.
In addition to applying for this one-off extension the North Canterbury region will also be undertaking a wider angling regulation review later this month. More information regarding the proposed regulation changes will be available on the Fish & Game website from 18 May, and we will be inviting anglers to make their submissions to us in writing so the Council can consider them at their 17 June Council meeting.
Waterway
Season extension
Methods/daily bag limits
Lake Coleridge
Extend fishing for the month of May. This will then join onto the winter season which starts at the 1 of June.
Status Quo
Lake Lyndon
Extend fishing for the month of May. This will then join onto the winter season which starts at the 1 of June.
Status Quo
Lake Pearson
Extend fishing for the month of May. This will then join onto the winter season which starts at the 1 of June.
Status Quo
Rakaia River
Downstream of the Coleridge Tailrace (white posts). Allow fishing throughout the winter season of 1 May to 30 September.
All methods, 2 trout, 0 salmon.
Heathcote River
Allow fishing throughout the winter season of 1 May to 30 September.
All methods, 2 trout, 0 salmon.
Avon River
Downstream of Barbaboes St Bridge, Allow fishing throughout the winter season of 1 May to 30 September.
All methods, 2 trout, 0 salmon.
Waimakariri River
Downstream of confluence with Staircase Stream. Allow fishing throughout the winter season of 1 May to 30 September.
All methods, 2 trout, 0 salmon.
Ashley River
Downstream of the Ashley Gorge Road. Allow fishing throughout the winter season of 1 May to 30 September.
All methods, 2 trout, 0 salmon.
Hurunui River
Downstream of the confluence with the South Branch Hurunui River. Allow fishing throughout the winter season of 1 May to 30 September.
All methods, 2 trout, 0 salmon.
Waiau River
Downstream of the confluence with the Hope River. Allow fishing throughout the winter season of 1 May to 30 September.