0002: SHOW DATABASES LIKE 'silverspoon-store'
0.0038s
0003: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", "SiteConfig"."ShowCartPostageForm", "SiteConfig"."ShowCartDiscountForm", "SiteConfig"."LastEstimateClean", "SiteConfig"."SiteLocale", "SiteConfig"."ContactPhone", "SiteConfig"."ContactEmail", "SiteConfig"."ContactAddress", "SiteConfig"."ShowPriceAndTax", "SiteConfig"."ShowPriceTaxString", "SiteConfig"."EstimateNumberPrefix", "SiteConfig"."InvoiceNumberPrefix", "SiteConfig"."OrderNumberLength", "SiteConfig"."InvoiceHeaderContent", "SiteConfig"."InvoiceFooterContent", "SiteConfig"."EstimateHeaderContent", "SiteConfig"."EstimateFooterContent", "SiteConfig"."CheckoutRequireTerms", "SiteConfig"."CheckoutTermsContent", "SiteConfig"."CheckoutLoginForm", "SiteConfig"."CheckoutAllowGuest", "SiteConfig"."PaymentSuccessContent", "SiteConfig"."PaymentFailerContent", "SiteConfig"."CookiePolicyButtonTitle", "SiteConfig"."CookiePolicyDescription", "SiteConfig"."CookiePolicyPosition", "SiteConfig"."CookiePolicyIsActive", "SiteConfig"."TileBackground", "SiteConfig"."Title", "SiteConfig"."Tagline", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."CardLogosID", "SiteConfig"."EstimateInvoiceLogoID", "SiteConfig"."CheckoutTermsPageID", "SiteConfig"."DefaultProductImageID", "SiteConfig"."LogoID", "SiteConfig"."IconID", "SiteConfig"."BackgroundID", "SiteConfig"."ContactPageID", "SiteConfig"."ID",
CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName"
ELSE 'SilverStripe\\SiteConfig\\SiteConfig' END AS "RecordClassName"
FROM "SiteConfig"
LIMIT 1
0.0018s
0004: SHOW FULL TABLES WHERE Table_Type != 'VIEW'
0.0058s
0005: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."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.0024s
0006: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."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.0016s
0007: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0014s
0008: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."SEOPageSubject", "Page_Live"."SEOSocialType", "Page_Live"."SEOHideSocialData", "Page_Live"."HomeSort", "Page_Live"."SEOSocialImageID", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'SilverStripe\\ErrorPage\\ErrorPage', 'ilateral\\SilverStripe\\ChildHubPage\\Model\\ChildHubPage', 'ilateral\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'ilateral\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\Blog\\Model\\BlogPost') THEN "BlogPost_Live"."FeaturedImageID" ELSE NULL END AS "FeaturedImageID", "Page_Live"."HomePageID", "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 "BlogPost_Live" ON "BlogPost_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0039s
0009: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."LegacyPath", "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", "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.0025s
0010: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."LegacyPath", "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", "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.0013s
0011: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."LegacyPath", "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", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0012s
0012: SELECT DISTINCT "SocialNavLink"."ClassName", "SocialNavLink"."LastEdited", "SocialNavLink"."Created", "SocialNavLink"."Service", "SocialNavLink"."Title", "SocialNavLink"."URL", "SocialNavLink"."ExtraClasses", "SocialNavLink"."ParentID", "SocialNavLink"."ID",
CASE WHEN "SocialNavLink"."ClassName" IS NOT NULL THEN "SocialNavLink"."ClassName"
ELSE 'ilateral\\SilverStripe\\SocialNav\\Model\\SocialNavLink' END AS "RecordClassName"
FROM "SocialNavLink"
WHERE ("SocialNavLink"."ParentID" = ?)
0.0015s
0013: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."LegacyPath", "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", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0012s
0014: SELECT DISTINCT "CustomMenuHolder"."ClassName", "CustomMenuHolder"."LastEdited", "CustomMenuHolder"."Created", "CustomMenuHolder"."Title", "CustomMenuHolder"."Slug", "CustomMenuHolder"."Order", "CustomMenuHolder"."SiteID", "CustomMenuHolder"."ID",
CASE WHEN "CustomMenuHolder"."ClassName" IS NOT NULL THEN "CustomMenuHolder"."ClassName"
ELSE 'ilateral\\SilverStripe\\CustomMenus\\Model\\CustomMenuHolder' END AS "RecordClassName"
FROM "CustomMenuHolder"
WHERE ("CustomMenuHolder"."SiteID" = ?)
AND ("CustomMenuHolder"."Slug" = ?)
LIMIT 1
0.0015s
0015: SELECT CASE WHEN EXISTS(SELECT *
FROM "CustomMenuLink"
WHERE ("CustomMenuLink"."MenuID" = ?)) THEN 1 ELSE 0 END
0.0013s
0016: SELECT DISTINCT "CustomMenuLink"."ClassName", "CustomMenuLink"."LastEdited", "CustomMenuLink"."Created", "CustomMenuLink"."BaseClass", "CustomMenuLink"."ObjectID", "CustomMenuLink"."SortOrder", "CustomMenuLink"."MenuID", "CustomMenuLink"."ID",
CASE WHEN "CustomMenuLink"."ClassName" IS NOT NULL THEN "CustomMenuLink"."ClassName"
ELSE 'ilateral\\SilverStripe\\CustomMenus\\Model\\CustomMenuLink' END AS "RecordClassName"
FROM "CustomMenuLink"
WHERE ("CustomMenuLink"."MenuID" = ?)
ORDER BY "CustomMenuLink"."SortOrder" ASC
0.0009s
0017: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."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
0018: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."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
0019: SELECT DISTINCT "CatalogueCategory"."ClassName", "CatalogueCategory"."LastEdited", "CatalogueCategory"."Created", "CatalogueCategory"."SEOPageSubject", "CatalogueCategory"."SEOSocialType", "CatalogueCategory"."SEOHideSocialData", "CatalogueCategory"."URLSegment", "CatalogueCategory"."MetaDescription", "CatalogueCategory"."ExtraMeta", "CatalogueCategory"."Title", "CatalogueCategory"."Content", "CatalogueCategory"."Sort", "CatalogueCategory"."Disabled", "CatalogueCategory"."SEOSocialImageID", "CatalogueCategory"."ImageID", "CatalogueCategory"."ParentID", "Category"."HomeSort", "Category"."HomePageID", "CatalogueCategory"."ID",
CASE WHEN "CatalogueCategory"."ClassName" IS NOT NULL THEN "CatalogueCategory"."ClassName"
ELSE 'SilverCommerce\\CatalogueAdmin\\Model\\CatalogueCategory' END AS "RecordClassName"
FROM "CatalogueCategory" LEFT JOIN "Category" ON "Category"."ID" = "CatalogueCategory"."ID"
WHERE ("CatalogueCategory"."ID" = ?)
AND ("CatalogueCategory"."ClassName" IN (?, ?))
ORDER BY "CatalogueCategory"."Sort" ASC
LIMIT 1
0.0019s
0020: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."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
0021: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."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
0022: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."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
0023: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."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.0023s
0024: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."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.0015s
0025: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0013s
0026: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."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
0027: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0012s
0028: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0013s
0029: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."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
0030: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."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
0031: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."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
0032: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."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
0033: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
0.0014s
0034: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."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.0016s
0035: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0012s
0036: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0012s
0037: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."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
0038: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0012s
0039: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0013s
0040: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."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
0041: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."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
0042: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0012s
0043: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."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
0044: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."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
0045: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."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
0046: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0012s
0047: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
0.0014s
0048: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."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
0049: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."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
0050: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."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
0051: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0012s
0052: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."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
0053: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."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
0054: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."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.0013s
0055: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."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
0056: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."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.0013s
0057: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
0.0014s
0058: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."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.0013s
0059: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
0.0014s
0060: SELECT DISTINCT "CustomMenuHolder"."ClassName", "CustomMenuHolder"."LastEdited", "CustomMenuHolder"."Created", "CustomMenuHolder"."Title", "CustomMenuHolder"."Slug", "CustomMenuHolder"."Order", "CustomMenuHolder"."SiteID", "CustomMenuHolder"."ID",
CASE WHEN "CustomMenuHolder"."ClassName" IS NOT NULL THEN "CustomMenuHolder"."ClassName"
ELSE 'ilateral\\SilverStripe\\CustomMenus\\Model\\CustomMenuHolder' END AS "RecordClassName"
FROM "CustomMenuHolder"
WHERE ("CustomMenuHolder"."SiteID" = ?)
AND ("CustomMenuHolder"."Slug" = ?)
LIMIT 1
0.0009s
0061: SELECT CASE WHEN EXISTS(SELECT *
FROM "CustomMenuLink"
WHERE ("CustomMenuLink"."MenuID" = ?)) THEN 1 ELSE 0 END
0.0007s
0062: SELECT DISTINCT "CustomMenuLink"."ClassName", "CustomMenuLink"."LastEdited", "CustomMenuLink"."Created", "CustomMenuLink"."BaseClass", "CustomMenuLink"."ObjectID", "CustomMenuLink"."SortOrder", "CustomMenuLink"."MenuID", "CustomMenuLink"."ID",
CASE WHEN "CustomMenuLink"."ClassName" IS NOT NULL THEN "CustomMenuLink"."ClassName"
ELSE 'ilateral\\SilverStripe\\CustomMenus\\Model\\CustomMenuLink' END AS "RecordClassName"
FROM "CustomMenuLink"
WHERE ("CustomMenuLink"."MenuID" = ?)
ORDER BY "CustomMenuLink"."SortOrder" ASC
0.0008s
0063: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."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
0064: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."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
0065: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."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
0066: SELECT DISTINCT "CustomMenuHolder"."ClassName", "CustomMenuHolder"."LastEdited", "CustomMenuHolder"."Created", "CustomMenuHolder"."Title", "CustomMenuHolder"."Slug", "CustomMenuHolder"."Order", "CustomMenuHolder"."SiteID", "CustomMenuHolder"."ID",
CASE WHEN "CustomMenuHolder"."ClassName" IS NOT NULL THEN "CustomMenuHolder"."ClassName"
ELSE 'ilateral\\SilverStripe\\CustomMenus\\Model\\CustomMenuHolder' END AS "RecordClassName"
FROM "CustomMenuHolder"
WHERE ("CustomMenuHolder"."SiteID" = ?)
AND ("CustomMenuHolder"."Slug" = ?)
LIMIT 1
0.0012s
0067: SELECT CASE WHEN EXISTS(SELECT *
FROM "CustomMenuLink"
WHERE ("CustomMenuLink"."MenuID" = ?)) THEN 1 ELSE 0 END
0.0008s
0068: SELECT DISTINCT "CustomMenuLink"."ClassName", "CustomMenuLink"."LastEdited", "CustomMenuLink"."Created", "CustomMenuLink"."BaseClass", "CustomMenuLink"."ObjectID", "CustomMenuLink"."SortOrder", "CustomMenuLink"."MenuID", "CustomMenuLink"."ID",
CASE WHEN "CustomMenuLink"."ClassName" IS NOT NULL THEN "CustomMenuLink"."ClassName"
ELSE 'ilateral\\SilverStripe\\CustomMenus\\Model\\CustomMenuLink' END AS "RecordClassName"
FROM "CustomMenuLink"
WHERE ("CustomMenuLink"."MenuID" = ?)
ORDER BY "CustomMenuLink"."SortOrder" ASC
0.0007s
0069: SELECT DISTINCT "CatalogueCategory"."ClassName", "CatalogueCategory"."LastEdited", "CatalogueCategory"."Created", "CatalogueCategory"."SEOPageSubject", "CatalogueCategory"."SEOSocialType", "CatalogueCategory"."SEOHideSocialData", "CatalogueCategory"."URLSegment", "CatalogueCategory"."MetaDescription", "CatalogueCategory"."ExtraMeta", "CatalogueCategory"."Title", "CatalogueCategory"."Content", "CatalogueCategory"."Sort", "CatalogueCategory"."Disabled", "CatalogueCategory"."SEOSocialImageID", "CatalogueCategory"."ImageID", "CatalogueCategory"."ParentID", "Category"."HomeSort", "Category"."HomePageID", "CatalogueCategory"."ID",
CASE WHEN "CatalogueCategory"."ClassName" IS NOT NULL THEN "CatalogueCategory"."ClassName"
ELSE 'SilverCommerce\\CatalogueAdmin\\Model\\CatalogueCategory' END AS "RecordClassName"
FROM "CatalogueCategory" LEFT JOIN "Category" ON "Category"."ID" = "CatalogueCategory"."ID"
WHERE ("CatalogueCategory"."ID" = ?)
AND ("CatalogueCategory"."ClassName" IN (?, ?))
ORDER BY "CatalogueCategory"."Sort" ASC
LIMIT 1
0.0009s
0070: SELECT DISTINCT "CatalogueCategory"."ClassName", "CatalogueCategory"."LastEdited", "CatalogueCategory"."Created", "CatalogueCategory"."SEOPageSubject", "CatalogueCategory"."SEOSocialType", "CatalogueCategory"."SEOHideSocialData", "CatalogueCategory"."URLSegment", "CatalogueCategory"."MetaDescription", "CatalogueCategory"."ExtraMeta", "CatalogueCategory"."Title", "CatalogueCategory"."Content", "CatalogueCategory"."Sort", "CatalogueCategory"."Disabled", "CatalogueCategory"."SEOSocialImageID", "CatalogueCategory"."ImageID", "CatalogueCategory"."ParentID", "Category"."HomeSort", "Category"."HomePageID", "CatalogueCategory"."ID",
CASE WHEN "CatalogueCategory"."ClassName" IS NOT NULL THEN "CatalogueCategory"."ClassName"
ELSE 'SilverCommerce\\CatalogueAdmin\\Model\\CatalogueCategory' END AS "RecordClassName"
FROM "CatalogueCategory" LEFT JOIN "Category" ON "Category"."ID" = "CatalogueCategory"."ID"
WHERE ("CatalogueCategory"."ID" = ?)
AND ("CatalogueCategory"."ClassName" IN (?, ?))
ORDER BY "CatalogueCategory"."Sort" ASC
LIMIT 1
0.0009s
0071: SELECT DISTINCT "CatalogueCategory"."ClassName", "CatalogueCategory"."LastEdited", "CatalogueCategory"."Created", "CatalogueCategory"."SEOPageSubject", "CatalogueCategory"."SEOSocialType", "CatalogueCategory"."SEOHideSocialData", "CatalogueCategory"."URLSegment", "CatalogueCategory"."MetaDescription", "CatalogueCategory"."ExtraMeta", "CatalogueCategory"."Title", "CatalogueCategory"."Content", "CatalogueCategory"."Sort", "CatalogueCategory"."Disabled", "CatalogueCategory"."SEOSocialImageID", "CatalogueCategory"."ImageID", "CatalogueCategory"."ParentID", "Category"."HomeSort", "Category"."HomePageID", "CatalogueCategory"."ID",
CASE WHEN "CatalogueCategory"."ClassName" IS NOT NULL THEN "CatalogueCategory"."ClassName"
ELSE 'SilverCommerce\\CatalogueAdmin\\Model\\CatalogueCategory' END AS "RecordClassName"
FROM "CatalogueCategory" LEFT JOIN "Category" ON "Category"."ID" = "CatalogueCategory"."ID"
WHERE ("CatalogueCategory"."ID" = ?)
AND ("CatalogueCategory"."ClassName" IN (?, ?))
ORDER BY "CatalogueCategory"."Sort" ASC
LIMIT 1
0.0013s
0072: SELECT DISTINCT "CatalogueCategory"."ClassName", "CatalogueCategory"."LastEdited", "CatalogueCategory"."Created", "CatalogueCategory"."SEOPageSubject", "CatalogueCategory"."SEOSocialType", "CatalogueCategory"."SEOHideSocialData", "CatalogueCategory"."URLSegment", "CatalogueCategory"."MetaDescription", "CatalogueCategory"."ExtraMeta", "CatalogueCategory"."Title", "CatalogueCategory"."Content", "CatalogueCategory"."Sort", "CatalogueCategory"."Disabled", "CatalogueCategory"."SEOSocialImageID", "CatalogueCategory"."ImageID", "CatalogueCategory"."ParentID", "Category"."HomeSort", "Category"."HomePageID", "CatalogueCategory"."ID",
CASE WHEN "CatalogueCategory"."ClassName" IS NOT NULL THEN "CatalogueCategory"."ClassName"
ELSE 'SilverCommerce\\CatalogueAdmin\\Model\\CatalogueCategory' END AS "RecordClassName"
FROM "CatalogueCategory" LEFT JOIN "Category" ON "Category"."ID" = "CatalogueCategory"."ID"
WHERE ("CatalogueCategory"."ID" = ?)
AND ("CatalogueCategory"."ClassName" IN (?, ?))
ORDER BY "CatalogueCategory"."Sort" ASC
LIMIT 1
0.0012s
0073: SELECT DISTINCT "CatalogueCategory"."ClassName", "CatalogueCategory"."LastEdited", "CatalogueCategory"."Created", "CatalogueCategory"."SEOPageSubject", "CatalogueCategory"."SEOSocialType", "CatalogueCategory"."SEOHideSocialData", "CatalogueCategory"."URLSegment", "CatalogueCategory"."MetaDescription", "CatalogueCategory"."ExtraMeta", "CatalogueCategory"."Title", "CatalogueCategory"."Content", "CatalogueCategory"."Sort", "CatalogueCategory"."Disabled", "CatalogueCategory"."SEOSocialImageID", "CatalogueCategory"."ImageID", "CatalogueCategory"."ParentID", "Category"."HomeSort", "Category"."HomePageID", "CatalogueCategory"."ID",
CASE WHEN "CatalogueCategory"."ClassName" IS NOT NULL THEN "CatalogueCategory"."ClassName"
ELSE 'SilverCommerce\\CatalogueAdmin\\Model\\CatalogueCategory' END AS "RecordClassName"
FROM "CatalogueCategory" LEFT JOIN "Category" ON "Category"."ID" = "CatalogueCategory"."ID"
WHERE ("CatalogueCategory"."ID" = ?)
AND ("CatalogueCategory"."ClassName" IN (?, ?))
ORDER BY "CatalogueCategory"."Sort" ASC
LIMIT 1
0.0015s
0074: SELECT DISTINCT "CatalogueCategory"."ClassName", "CatalogueCategory"."LastEdited", "CatalogueCategory"."Created", "CatalogueCategory"."SEOPageSubject", "CatalogueCategory"."SEOSocialType", "CatalogueCategory"."SEOHideSocialData", "CatalogueCategory"."URLSegment", "CatalogueCategory"."MetaDescription", "CatalogueCategory"."ExtraMeta", "CatalogueCategory"."Title", "CatalogueCategory"."Content", "CatalogueCategory"."Sort", "CatalogueCategory"."Disabled", "CatalogueCategory"."SEOSocialImageID", "CatalogueCategory"."ImageID", "CatalogueCategory"."ParentID", "Category"."HomeSort", "Category"."HomePageID", "CatalogueCategory"."ID",
CASE WHEN "CatalogueCategory"."ClassName" IS NOT NULL THEN "CatalogueCategory"."ClassName"
ELSE 'SilverCommerce\\CatalogueAdmin\\Model\\CatalogueCategory' END AS "RecordClassName"
FROM "CatalogueCategory" LEFT JOIN "Category" ON "Category"."ID" = "CatalogueCategory"."ID"
WHERE ("CatalogueCategory"."ID" = ?)
AND ("CatalogueCategory"."ClassName" IN (?, ?))
ORDER BY "CatalogueCategory"."Sort" ASC
LIMIT 1
0.0009s
0075: SELECT DISTINCT "CatalogueCategory"."ClassName", "CatalogueCategory"."LastEdited", "CatalogueCategory"."Created", "CatalogueCategory"."SEOPageSubject", "CatalogueCategory"."SEOSocialType", "CatalogueCategory"."SEOHideSocialData", "CatalogueCategory"."URLSegment", "CatalogueCategory"."MetaDescription", "CatalogueCategory"."ExtraMeta", "CatalogueCategory"."Title", "CatalogueCategory"."Content", "CatalogueCategory"."Sort", "CatalogueCategory"."Disabled", "CatalogueCategory"."SEOSocialImageID", "CatalogueCategory"."ImageID", "CatalogueCategory"."ParentID", "CatalogueCategory"."ID",
CASE WHEN "CatalogueCategory"."ClassName" IS NOT NULL THEN "CatalogueCategory"."ClassName"
ELSE 'SilverCommerce\\CatalogueAdmin\\Model\\CatalogueCategory' END AS "RecordClassName"
FROM "CatalogueCategory"
WHERE ("CatalogueCategory"."ID" = ?)
ORDER BY "CatalogueCategory"."Sort" ASC
LIMIT 1
0.001s
0076: SELECT DISTINCT "CatalogueCategory"."ClassName", "CatalogueCategory"."LastEdited", "CatalogueCategory"."Created", "CatalogueCategory"."SEOPageSubject", "CatalogueCategory"."SEOSocialType", "CatalogueCategory"."SEOHideSocialData", "CatalogueCategory"."URLSegment", "CatalogueCategory"."MetaDescription", "CatalogueCategory"."ExtraMeta", "CatalogueCategory"."Title", "CatalogueCategory"."Content", "CatalogueCategory"."Sort", "CatalogueCategory"."Disabled", "CatalogueCategory"."SEOSocialImageID", "CatalogueCategory"."ImageID", "CatalogueCategory"."ParentID", "CatalogueCategory"."ID",
CASE WHEN "CatalogueCategory"."ClassName" IS NOT NULL THEN "CatalogueCategory"."ClassName"
ELSE 'SilverCommerce\\CatalogueAdmin\\Model\\CatalogueCategory' END AS "RecordClassName"
FROM "CatalogueCategory"
WHERE ("CatalogueCategory"."ID" = ?)
ORDER BY "CatalogueCategory"."Sort" ASC
LIMIT 1
0.0009s
0077: SELECT DISTINCT "CatalogueCategory"."ClassName", "CatalogueCategory"."LastEdited", "CatalogueCategory"."Created", "CatalogueCategory"."SEOPageSubject", "CatalogueCategory"."SEOSocialType", "CatalogueCategory"."SEOHideSocialData", "CatalogueCategory"."URLSegment", "CatalogueCategory"."MetaDescription", "CatalogueCategory"."ExtraMeta", "CatalogueCategory"."Title", "CatalogueCategory"."Content", "CatalogueCategory"."Sort", "CatalogueCategory"."Disabled", "CatalogueCategory"."SEOSocialImageID", "CatalogueCategory"."ImageID", "CatalogueCategory"."ParentID", "CatalogueCategory"."ID",
CASE WHEN "CatalogueCategory"."ClassName" IS NOT NULL THEN "CatalogueCategory"."ClassName"
ELSE 'SilverCommerce\\CatalogueAdmin\\Model\\CatalogueCategory' END AS "RecordClassName"
FROM "CatalogueCategory"
WHERE ("CatalogueCategory"."ID" = ?)
ORDER BY "CatalogueCategory"."Sort" ASC
LIMIT 1
0.001s
0078: SELECT DISTINCT "CatalogueCategory"."ClassName", "CatalogueCategory"."LastEdited", "CatalogueCategory"."Created", "CatalogueCategory"."SEOPageSubject", "CatalogueCategory"."SEOSocialType", "CatalogueCategory"."SEOHideSocialData", "CatalogueCategory"."URLSegment", "CatalogueCategory"."MetaDescription", "CatalogueCategory"."ExtraMeta", "CatalogueCategory"."Title", "CatalogueCategory"."Content", "CatalogueCategory"."Sort", "CatalogueCategory"."Disabled", "CatalogueCategory"."SEOSocialImageID", "CatalogueCategory"."ImageID", "CatalogueCategory"."ParentID", "CatalogueCategory"."ID",
CASE WHEN "CatalogueCategory"."ClassName" IS NOT NULL THEN "CatalogueCategory"."ClassName"
ELSE 'SilverCommerce\\CatalogueAdmin\\Model\\CatalogueCategory' END AS "RecordClassName"
FROM "CatalogueCategory"
WHERE ("CatalogueCategory"."ID" = ?)
ORDER BY "CatalogueCategory"."Sort" ASC
LIMIT 1
0.0009s
0079: SELECT DISTINCT "CatalogueCategory"."ClassName", "CatalogueCategory"."LastEdited", "CatalogueCategory"."Created", "CatalogueCategory"."SEOPageSubject", "CatalogueCategory"."SEOSocialType", "CatalogueCategory"."SEOHideSocialData", "CatalogueCategory"."URLSegment", "CatalogueCategory"."MetaDescription", "CatalogueCategory"."ExtraMeta", "CatalogueCategory"."Title", "CatalogueCategory"."Content", "CatalogueCategory"."Sort", "CatalogueCategory"."Disabled", "CatalogueCategory"."SEOSocialImageID", "CatalogueCategory"."ImageID", "CatalogueCategory"."ParentID", "CatalogueCategory"."ID",
CASE WHEN "CatalogueCategory"."ClassName" IS NOT NULL THEN "CatalogueCategory"."ClassName"
ELSE 'SilverCommerce\\CatalogueAdmin\\Model\\CatalogueCategory' END AS "RecordClassName"
FROM "CatalogueCategory"
WHERE ("CatalogueCategory"."ID" = ?)
ORDER BY "CatalogueCategory"."Sort" ASC
LIMIT 1
0.0015s
0080: SELECT DISTINCT "CatalogueCategory"."ClassName", "CatalogueCategory"."LastEdited", "CatalogueCategory"."Created", "CatalogueCategory"."SEOPageSubject", "CatalogueCategory"."SEOSocialType", "CatalogueCategory"."SEOHideSocialData", "CatalogueCategory"."URLSegment", "CatalogueCategory"."MetaDescription", "CatalogueCategory"."ExtraMeta", "CatalogueCategory"."Title", "CatalogueCategory"."Content", "CatalogueCategory"."Sort", "CatalogueCategory"."Disabled", "CatalogueCategory"."SEOSocialImageID", "CatalogueCategory"."ImageID", "CatalogueCategory"."ParentID", "CatalogueCategory"."ID",
CASE WHEN "CatalogueCategory"."ClassName" IS NOT NULL THEN "CatalogueCategory"."ClassName"
ELSE 'SilverCommerce\\CatalogueAdmin\\Model\\CatalogueCategory' END AS "RecordClassName"
FROM "CatalogueCategory"
WHERE ("CatalogueCategory"."ID" = ?)
ORDER BY "CatalogueCategory"."Sort" ASC
LIMIT 1
0.0012s
0081: SELECT DISTINCT "CatalogueCategory"."ClassName", "CatalogueCategory"."LastEdited", "CatalogueCategory"."Created", "CatalogueCategory"."SEOPageSubject", "CatalogueCategory"."SEOSocialType", "CatalogueCategory"."SEOHideSocialData", "CatalogueCategory"."URLSegment", "CatalogueCategory"."MetaDescription", "CatalogueCategory"."ExtraMeta", "CatalogueCategory"."Title", "CatalogueCategory"."Content", "CatalogueCategory"."Sort", "CatalogueCategory"."Disabled", "CatalogueCategory"."SEOSocialImageID", "CatalogueCategory"."ImageID", "CatalogueCategory"."ParentID", "CatalogueCategory"."ID",
CASE WHEN "CatalogueCategory"."ClassName" IS NOT NULL THEN "CatalogueCategory"."ClassName"
ELSE 'SilverCommerce\\CatalogueAdmin\\Model\\CatalogueCategory' END AS "RecordClassName"
FROM "CatalogueCategory"
WHERE ("CatalogueCategory"."ID" = ?)
ORDER BY "CatalogueCategory"."Sort" ASC
LIMIT 1
0.0015s
0082: SELECT DISTINCT "CatalogueCategory"."ClassName", "CatalogueCategory"."LastEdited", "CatalogueCategory"."Created", "CatalogueCategory"."SEOPageSubject", "CatalogueCategory"."SEOSocialType", "CatalogueCategory"."SEOHideSocialData", "CatalogueCategory"."URLSegment", "CatalogueCategory"."MetaDescription", "CatalogueCategory"."ExtraMeta", "CatalogueCategory"."Title", "CatalogueCategory"."Content", "CatalogueCategory"."Sort", "CatalogueCategory"."Disabled", "CatalogueCategory"."SEOSocialImageID", "CatalogueCategory"."ImageID", "CatalogueCategory"."ParentID", "CatalogueCategory"."ID",
CASE WHEN "CatalogueCategory"."ClassName" IS NOT NULL THEN "CatalogueCategory"."ClassName"
ELSE 'SilverCommerce\\CatalogueAdmin\\Model\\CatalogueCategory' END AS "RecordClassName"
FROM "CatalogueCategory"
WHERE ("CatalogueCategory"."ID" = ?)
ORDER BY "CatalogueCategory"."Sort" ASC
LIMIT 1
0.0012s
0083: SELECT DISTINCT "CustomMenuHolder"."ClassName", "CustomMenuHolder"."LastEdited", "CustomMenuHolder"."Created", "CustomMenuHolder"."Title", "CustomMenuHolder"."Slug", "CustomMenuHolder"."Order", "CustomMenuHolder"."SiteID", "CustomMenuHolder"."ID",
CASE WHEN "CustomMenuHolder"."ClassName" IS NOT NULL THEN "CustomMenuHolder"."ClassName"
ELSE 'ilateral\\SilverStripe\\CustomMenus\\Model\\CustomMenuHolder' END AS "RecordClassName"
FROM "CustomMenuHolder"
WHERE ("CustomMenuHolder"."SiteID" = ?)
AND ("CustomMenuHolder"."Slug" = ?)
LIMIT 1
0.0014s
0084: SELECT CASE WHEN EXISTS(SELECT *
FROM "CustomMenuLink"
WHERE ("CustomMenuLink"."MenuID" = ?)) THEN 1 ELSE 0 END
0.0012s
0085: SELECT DISTINCT "CustomMenuLink"."ClassName", "CustomMenuLink"."LastEdited", "CustomMenuLink"."Created", "CustomMenuLink"."BaseClass", "CustomMenuLink"."ObjectID", "CustomMenuLink"."SortOrder", "CustomMenuLink"."MenuID", "CustomMenuLink"."ID",
CASE WHEN "CustomMenuLink"."ClassName" IS NOT NULL THEN "CustomMenuLink"."ClassName"
ELSE 'ilateral\\SilverStripe\\CustomMenus\\Model\\CustomMenuLink' END AS "RecordClassName"
FROM "CustomMenuLink"
WHERE ("CustomMenuLink"."MenuID" = ?)
ORDER BY "CustomMenuLink"."SortOrder" ASC
0.0012s
0086: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0013s
0087: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0013s
0088: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0012s
0089: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0013s
0090: SELECT DISTINCT "SocialNavLink"."ClassName", "SocialNavLink"."LastEdited", "SocialNavLink"."Created", "SocialNavLink"."Service", "SocialNavLink"."Title", "SocialNavLink"."URL", "SocialNavLink"."ExtraClasses", "SocialNavLink"."ParentID", "SocialNavLink"."ID",
CASE WHEN "SocialNavLink"."ClassName" IS NOT NULL THEN "SocialNavLink"."ClassName"
ELSE 'ilateral\\SilverStripe\\SocialNav\\Model\\SocialNavLink' END AS "RecordClassName"
FROM "SocialNavLink"
WHERE ("SocialNavLink"."ParentID" = ?)
0.0014s
0091: SELECT CASE WHEN EXISTS(SELECT *
FROM "Link"
WHERE ("Link"."SiteID" = ?)) THEN 1 ELSE 0 END
0.002s
0092: SELECT "Version" FROM "SiteTree" WHERE "ID" = ?
0.0023s
0093: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0013s
0094: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0012s
0095: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0013s
0096: SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", "SiteTree"."Priority", "SiteTree"."ShowCarousel", "SiteTree"."CarouselShowIndicators", "SiteTree"."CarouselShowControls", "SiteTree"."CarouselProfile", "SiteTree"."CarouselInterval", "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"."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.0012s
0097: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0014s
0098: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "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"."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
A comprehensive database of makers' marks can be found at http://www.silvermakersmarks.co.uk. All UK assay offices are covered (past and present) and even our own RBLd mark at the Birmingham assay office has been registered and identified. A superb online resource!
http://www.ascasonline.org - a web-site by the Association of Small Collectors of Antique Silver hosting articles written by it's members on silverware. The private web-site, by the host of the ASCAS site, can be found at www.silvercollection.it and features images/descriptions of his silver collection with items from all over the world.
For those interested in sugar nips, take a look at Dr. Shlosberg's excellent site www.silverteatongs.com from where you can contact the man himself. Alternatively, if you prefer sugar tongs, visit Graham Hodges' specialist web-site for Georgian period tongs at www.silversugartongs.com.
The Wine Label Circle is an association for those with an interest in the studying and collecting of decanter labels, furthering research in to their history and encouraging contemporary design. Their web-site can be found at this link: www.winelabelcircle.org
The Society of Caddy Spoon Collectors was "formed to promote the study of a delightful memento of a gracious era and to assist its collectors". Their website can be found at http://www.caddyspoonsociety.org
For those of you interested in Art & Crafts, you will probably enjoy looking at the many photos of A E Jones items showing in the galleries at this link: www.aejonesboxes.co.uk or for contemporary, Celtic-style silver there is now a web-site dedicated to Alexander Ritchie of Iona at www.alexander-ritchie.co.uk
Where to see spoons:-
The Victoria & Albert Museum, South Kensington, London - www.vam.ac.uk - the recently restored silver galleries are a joy to wander around, with plenty of spoons!
The Gilbert Collection, Somerset House, London - www.gilbert-collection.org.uk - one of the World's greatest collections of silver .
The Ashmolean Museum, Oxford www.ashmol.ox.ac.uk - examples of all early spoons, including all of the apostles.
National Museum & Gallery of Wales, Cardiff - www.nmgw.ac.uk/nmgc/ - a large & wide ranging collections of spoons amongst it's extensive collection.
The National Museum of Scotland. www.museum.scotland.net With approximately 3,000 items, this is the largest and most comprehensive collection of Scottish silver in the world.
Most city museums contain a selection of silver and where appropriate include locally made wares which can often be provincial spoons, e.g. Aberdeen, Bristol, Norwich, Exeter...
Where else to buy spoons on the net :-
www.payneandson.co.uk - one of the finest high street retailers in the UK with a wide ranging stock and a particularly strong range of arts & crafts and modern silver.
www.bexfield.co.uk - home to the Silver Spoon Club of Great Britain and lots of fine spoons on offer.
www.silfren.com - a good selection of silver on offer at realistic prices.
www.coritani.com - very professional and well organised web-site by one of the foremost dealers in spoons, boxes and other items of collectable silver.
www.leopardantiques.com - based in South Africa with a good selection of both Cape and English silver. An excellent links page.
www.steppeshillfarm.com - excellent web-site by a long established family business. Plenty of top quality collectable silver and early porcelain on offer.
www.dartsilverltd.co.uk - Dart Silver Ltd: Antique silver specialists located in Central Scotland. Always a good selection of Scottish Provincial silver in stock.
www.jamesbaldwinantiques.com - an attractively designed and innovative website with specialist sections for Old Sheffield Plate and modern makers.
www.westcountrysilver.co.uk - a website dedicated to the fascinating subject of Exeter & West Country silver that goes hand in hand with the new book by Miles Harrison.
We welcome any suggestions for suitable links. Please contact us with the address details.
