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.0014s
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.0012s
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.0009s
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.0031s
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" < '2026-02-07 18:57:59')
ORDER BY "BlogPost_Live"."FeaturedInWidget" DESC, "_SortColumn0" DESC, "BlogPost_Live"."PublishDate" DESC
LIMIT 1
0.0011s
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.0013s
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.0066s
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.0012s
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.001s
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.0008s
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.0008s
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.0005s
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.0008s
0028: SELECT DISTINCT "BlogTag"."Title"
FROM "BlogTag" INNER JOIN "BlogPost_Tags" ON "BlogPost_Tags"."BlogTagID" = "BlogTag"."ID"
WHERE ("BlogPost_Tags"."BlogPostID" = ?)
0.0008s
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.0028s
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.001s
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.0012s
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.0008s
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.0007s
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" < '2026-02-07 18:57:59')
ORDER BY "BlogPost_Live"."FeaturedInWidget" DESC, "_SortColumn0" DESC, "BlogPost_Live"."PublishDate" DESC
LIMIT 1
0.004s
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.0009s
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.0007s
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.0015s
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.0069s
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.0011s
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.0038s
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.0012s
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.0009s
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.0008s
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.0008s
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.0008s
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.0009s
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.0011s
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.0008s
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.0009s
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.0008s
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.001s
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.0008s
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.0008s
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.0008s
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.0009s
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.0011s
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.0008s
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.0009s
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.0009s
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.001s
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.0008s
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.0008s
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.0008s
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.0008s
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.0065s
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.0154s
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.0105s
0073: SELECT "Version" FROM "SiteTree" WHERE "ID" = ?
0.0006s
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.0008s
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.0008s
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.0008s
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.0008s
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.0008s
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.0008s
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.001s
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.0006s
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.0011s
North Canterbury Fishing Report Friday 3rd November 2017 - Fish & Game
North Canterbury Fishing Report Friday 3rd November 2017
North Canterbury
3/11/2017
Richie Cosgrove
Tomorrow is the opening of the High Country lakes, which will be celebrated again this year with a fishing competition at Lake Coleridge, with a great prize pool generously sponsored by Hunting and Fishing.
The focus of the competition is on participation, and every angler who shows their licence at the weight in will be given a ticket for spot prizes.
Above Right: A sight all dry fly anglers wait eagerly for!-Photo Dave Jones.
The competition will be based at Ryton Bay where there will be a Fish & Game tent and weigh station.
Weigh-in is from 9am – 3pm, with the prize draw around 3:30pm.
Those anglers that are lucky enough to weigh a salmon or trout in are reminded they are to be whole and not gutted for this.
Please also ensure you arrive at the weigh-in before 3pm to avoid missing out.
Lake Coleridge is the most popular lake in the region for fishing and this event is a great way for anglers to celebrate the traditional high country opening.
Fish & Game have been stocking the lakes in the area for many years and over the last twelve months, have again released tens of thousands of Chinook salmon smolt and Rainbow trout yearlings into Lake Coleridge and its tributaries, with an additional 5,000 odd rainbows released into the surrounding lakes.
Hopefully we get a break in the weather Saturday morning, with Nor-west winds rising through the day and into Sunday, where fishing may become challenging.
Boat anglers please take appropriate life jackets for all those on board and don’t wait for the waves to grow before deciding to come in, as things can change very quickly on Lake Coleridge.
The larger east coast rivers have not seen a decent fresh for well over a month and it looks like the Nor-west season has finally arrived.
Leading up to Christmas, anglers should make the most of any drop in flows before the next Nor-wester brings the rivers down.
These main rivers should fish well when flows drop off, especially for sea-run trout in the lower reaches as they fatten up on silveries and whitebait.
As seems to be the norm for this time of year, I have heard unconfirmed reports of two salmon taken from the Rakaia and another couple sighted, and it won’t be long before we get confirmation of the first salmon caught for the season.
A good prospect for low country anglers this weekend would be the lower Ashley River, as there is a good flow there which will not be affected by the nor-west rain in the alps.
Good numbers of sea-run Brown trout should also have entered Lake Ellesmere when it was open recently and the lake tributaries would also be worth a look in the evenings and at night over the next month or so.
On the weekend of November 11-12, the Central South Island & North Canterbury regions will be hosting a Salmon Symposium at the Hotel Ashburton for anglers and other interested parties to review the state of our sea-run salmon fishery and the disappointing runs of recent years.
We will have a range of topics and experts to talk to them during the two day symposium.
If you are keen find out more about the event and register to attend please click here to link to the Fish & Game website.
Good luck if you are heading out for a fish over the weekend.
Steve Terry, Fish & Game Officer North Canterbury.