0002: SHOW DATABASES LIKE 'hartsbarn-store'
0.0032s
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.0113s
0004: SHOW FULL TABLES WHERE Table_Type != 'VIEW'
0.0055s
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.0153s
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.0136s
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.012s
0008: SELECT DISTINCT "PublishDate" IS NULL AS "_SortColumn0", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'NewsletterPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'ilateral\\SilverStripe\\ChildHubPage\\Model\\ChildHubPage', 'ilateral\\SilverStripe\\Gallery\\Model\\GalleryHub', 'ilateral\\SilverStripe\\Testimonials\\Model\\TestimonialsHolderPage', '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" WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\Blog\\Model\\BlogPost') THEN "BlogPost_Live"."FeaturedImageID" ELSE NULL END AS "FeaturedImageID", "BlogPost_Live"."FeaturedInWidget", "BlogPost_Live"."PublishDate", "BlogPost_Live"."AuthorNames", "BlogPost_Live"."Summary", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live" LEFT JOIN "BlogPost_Live" ON "BlogPost_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
AND ("PublishDate" < '2026-08-04 23:59:46')
ORDER BY "_SortColumn0" DESC, "BlogPost_Live"."PublishDate" DESC
LIMIT 1
0.0029s
0009: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."SEOPageSubject", "Page_Live"."SEOSocialType", "Page_Live"."SEOHideSocialData", "Page_Live"."InheritSideBar", "Page_Live"."HomeSort", "Page_Live"."SEOSocialImageID", "Page_Live"."SideBarID", "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" INNER JOIN "BlogPost_Live" ON "SiteTree_Live"."ID" = "BlogPost_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0036s
0010: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."SEOPageSubject", "Page_Live"."SEOSocialType", "Page_Live"."SEOHideSocialData", "Page_Live"."InheritSideBar", "Page_Live"."HomeSort", "Page_Live"."SEOSocialImageID", "Page_Live"."SideBarID", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'NewsletterPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'ilateral\\SilverStripe\\ChildHubPage\\Model\\ChildHubPage', 'ilateral\\SilverStripe\\Gallery\\Model\\GalleryHub', 'ilateral\\SilverStripe\\Testimonials\\Model\\TestimonialsHolderPage', '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.0086s
0011: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "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.0033s
0012: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "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.0016s
0013: SELECT DISTINCT "SystemMessage"."ClassName", "SystemMessage"."LastEdited", "SystemMessage"."Created", "SystemMessage"."Content", "SystemMessage"."ButtonText", "SystemMessage"."StartDate", "SystemMessage"."ExpiryDate", "SystemMessage"."Delay", "SystemMessage"."Type", "SystemMessage"."MessageType", "SystemMessage"."LinkID", "SystemMessage"."ID",
CASE WHEN "SystemMessage"."ClassName" IS NOT NULL THEN "SystemMessage"."ClassName"
ELSE 'ilateral\\SilverStripe\\SystemMessages\\SystemMessage' END AS "RecordClassName"
FROM "SystemMessage"
WHERE ("SystemMessage"."StartDate" < ?)
AND ("SystemMessage"."ExpiryDate" > ?)
ORDER BY "SystemMessage"."StartDate" ASC
0.0052s
0014: SELECT DISTINCT "SystemMessage"."ClassName", "SystemMessage"."LastEdited", "SystemMessage"."Created", "SystemMessage"."Content", "SystemMessage"."ButtonText", "SystemMessage"."StartDate", "SystemMessage"."ExpiryDate", "SystemMessage"."Delay", "SystemMessage"."Type", "SystemMessage"."MessageType", "SystemMessage"."LinkID", "SystemMessage"."ID",
CASE WHEN "SystemMessage"."ClassName" IS NOT NULL THEN "SystemMessage"."ClassName"
ELSE 'ilateral\\SilverStripe\\SystemMessages\\SystemMessage' END AS "RecordClassName"
FROM "SystemMessage"
WHERE ("SystemMessage"."StartDate" < ?)
AND ("SystemMessage"."ExpiryDate" > ?)
ORDER BY "SystemMessage"."StartDate" ASC
0.0044s
0015: 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.0045s
0016: 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.0025s
0017: SELECT CASE WHEN EXISTS(SELECT *
FROM "CustomMenuLink"
WHERE ("CustomMenuLink"."MenuID" = ?)) THEN 1 ELSE 0 END
0.002s
0018: 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.0019s
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.0064s
0020: 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.0017s
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.0016s
0022: 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.0023s
0023: 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"."ParentID" <> "CatalogueCategory"."ID")
AND ("CatalogueCategory"."ParentID" = ?)
ORDER BY "CatalogueCategory"."Sort" ASC
0.0044s
0024: 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.0018s
0025: 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.0066s
0026: 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.0068s
0027: 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.0063s
0028: 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.0057s
0029: 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.0029s
0030: 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.0041s
0031: 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.0024s
0032: 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.0126s
0033: 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.0045s
0034: 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.0066s
0035: 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.0034s
0036: 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.0097s
0037: 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.0066s
0038: 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.01s
0039: 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"."ParentID" <> "CatalogueCategory"."ID")
AND ("CatalogueCategory"."ParentID" = ?)
ORDER BY "CatalogueCategory"."Sort" ASC
0.0025s
0040: 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.0059s
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"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
0.0034s
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.0068s
0043: 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"."ParentID" <> "CatalogueCategory"."ID")
AND ("CatalogueCategory"."ParentID" = ?)
ORDER BY "CatalogueCategory"."Sort" ASC
0.0054s
0044: 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.002s
0045: SELECT CASE WHEN EXISTS(SELECT *
FROM "CustomMenuLink"
WHERE ("CustomMenuLink"."MenuID" = ?)) THEN 1 ELSE 0 END
0.0019s
0046: 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.0082s
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"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0071s
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.0088s
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.0023s
0050: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."SEOPageSubject", "Page_Live"."SEOSocialType", "Page_Live"."SEOHideSocialData", "Page_Live"."InheritSideBar", "Page_Live"."HomeSort", "Page_Live"."SEOSocialImageID", "Page_Live"."SideBarID", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'NewsletterPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'ilateral\\SilverStripe\\ChildHubPage\\Model\\ChildHubPage', 'ilateral\\SilverStripe\\Gallery\\Model\\GalleryHub', 'ilateral\\SilverStripe\\Testimonials\\Model\\TestimonialsHolderPage', '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.0041s
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", "Page_Live"."SEOPageSubject", "Page_Live"."SEOSocialType", "Page_Live"."SEOHideSocialData", "Page_Live"."InheritSideBar", "Page_Live"."HomeSort", "Page_Live"."SEOSocialImageID", "Page_Live"."SideBarID", "Page_Live"."FeaturedImageID", "Page_Live"."HomePageID", "NewsletterPage_Live"."EmbedCode", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "NewsletterPage_Live" ON "NewsletterPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0042s
0052: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "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"
WHERE ("File_Live"."ID" = ?)
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.002s
0053: SELECT CASE WHEN EXISTS(SELECT *
FROM "BlogCategory" INNER JOIN "BlogPost_Categories" ON "BlogPost_Categories"."BlogCategoryID" = "BlogCategory"."ID"
WHERE ("BlogPost_Categories"."BlogPostID" = ?)) THEN 1 ELSE 0 END
0.0035s
0054: SELECT CASE WHEN EXISTS(SELECT *
FROM "BlogTag" INNER JOIN "BlogPost_Tags" ON "BlogPost_Tags"."BlogTagID" = "BlogTag"."ID"
WHERE ("BlogPost_Tags"."BlogPostID" = ?)) THEN 1 ELSE 0 END
0.0102s
0055: SELECT DISTINCT "Member"."ClassName", "Member"."LastEdited", "Member"."Created", "Member"."URLSegment", "Member"."BlogProfileSummary", "Member"."Company", "Member"."Phone", "Member"."Mobile", "Member"."VerificationCode", "Member"."iCalKey", "Member"."FirstName", "Member"."Surname", "Member"."Email", "Member"."TempIDHash", "Member"."TempIDExpired", "Member"."Password", "Member"."AutoLoginHash", "Member"."AutoLoginExpired", "Member"."PasswordEncryption", "Member"."Salt", "Member"."PasswordExpiry", "Member"."LockedOutUntil", "Member"."Locale", "Member"."FailedLoginCount", "Member"."BlogProfileImageID", "Member"."ID",
CASE WHEN "Member"."ClassName" IS NOT NULL THEN "Member"."ClassName"
ELSE 'SilverStripe\\Security\\Member' END AS "RecordClassName"
FROM "Member" INNER JOIN "BlogPost_Authors" ON "BlogPost_Authors"."MemberID" = "Member"."ID"
WHERE ("BlogPost_Authors"."BlogPostID" = ?)
ORDER BY "Member"."Surname" ASC, "Member"."FirstName" ASC
0.0044s
0056: SELECT DISTINCT "WidgetArea_Live"."ClassName", "WidgetArea_Live"."LastEdited", "WidgetArea_Live"."Created", "WidgetArea_Live"."Version", "WidgetArea_Live"."ID",
CASE WHEN "WidgetArea_Live"."ClassName" IS NOT NULL THEN "WidgetArea_Live"."ClassName"
ELSE 'SilverStripe\\Widgets\\Model\\WidgetArea' END AS "RecordClassName"
FROM "WidgetArea_Live"
WHERE ("WidgetArea_Live"."ID" = ?)
LIMIT 1
0.0103s
0057: SELECT CASE WHEN EXISTS(SELECT *
FROM "Widget_Live"
WHERE ("Widget_Live"."ParentID" = ?)) THEN 1 ELSE 0 END
0.0112s
0058: SELECT DISTINCT "Widget_Live"."ClassName", "Widget_Live"."LastEdited", "Widget_Live"."Created", "Widget_Live"."Version", "Widget_Live"."Title", "Widget_Live"."Sort", "Widget_Live"."Enabled", "Widget_Live"."ParentID", "Widget_Live"."ID",
CASE WHEN "Widget_Live"."ClassName" IS NOT NULL THEN "Widget_Live"."ClassName"
ELSE 'SilverStripe\\Widgets\\Model\\Widget' END AS "RecordClassName"
FROM "Widget_Live"
WHERE ("Widget_Live"."ParentID" = ?)
AND ("Widget_Live"."Enabled" = ?)
ORDER BY "Widget_Live"."Sort" ASC
0.0124s
0059: SELECT DISTINCT "Widget_Live"."ClassName", "Widget_Live"."LastEdited", "Widget_Live"."Created", "BlogCategoriesWidget_Live"."Limit", "BlogCategoriesWidget_Live"."Order", "BlogCategoriesWidget_Live"."Direction", "BlogCategoriesWidget_Live"."BlogID", "Widget_Live"."ID",
CASE WHEN "Widget_Live"."ClassName" IS NOT NULL THEN "Widget_Live"."ClassName"
ELSE 'SilverStripe\\Widgets\\Model\\Widget' END AS "RecordClassName", "Widget_Live"."Sort"
FROM "Widget_Live" LEFT JOIN "BlogCategoriesWidget_Live" ON "BlogCategoriesWidget_Live"."ID" = "Widget_Live"."ID"
WHERE ("Widget_Live"."ID" = ?)
AND ("Widget_Live"."ClassName" IN (?))
ORDER BY "Widget_Live"."Sort" ASC
LIMIT 1
0.0221s
0060: 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", "Page_Live"."SEOPageSubject", "Page_Live"."SEOSocialType", "Page_Live"."SEOHideSocialData", "Page_Live"."InheritSideBar", "Page_Live"."HomeSort", "Page_Live"."SEOSocialImageID", "Page_Live"."SideBarID", "Page_Live"."FeaturedImageID", "Page_Live"."HomePageID", "Blog_Live"."PostsPerPage", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "Blog_Live" ON "Blog_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0034s
0061: SELECT CASE WHEN EXISTS(SELECT *
FROM "BlogCategory"
WHERE ("BlogCategory"."BlogID" = ?)) THEN 1 ELSE 0 END
0.0059s
0062: SELECT DISTINCT "BlogCategory"."ClassName", "BlogCategory"."LastEdited", "BlogCategory"."Created", "BlogCategory"."Title", "BlogCategory"."URLSegment", "BlogCategory"."BlogID", "BlogCategory"."ID",
CASE WHEN "BlogCategory"."ClassName" IS NOT NULL THEN "BlogCategory"."ClassName"
ELSE 'SilverStripe\\Blog\\Model\\BlogCategory' END AS "RecordClassName"
FROM "BlogCategory"
WHERE ("BlogCategory"."BlogID" = ?)
ORDER BY "BlogCategory"."Title" ASC
0.0074s
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", "Page_Live"."SEOPageSubject", "Page_Live"."SEOSocialType", "Page_Live"."SEOHideSocialData", "Page_Live"."InheritSideBar", "Page_Live"."HomeSort", "Page_Live"."SEOSocialImageID", "Page_Live"."SideBarID", "Page_Live"."FeaturedImageID", "Page_Live"."HomePageID", "Blog_Live"."PostsPerPage", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "Blog_Live" ON "Blog_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0038s
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", "Page_Live"."SEOPageSubject", "Page_Live"."SEOSocialType", "Page_Live"."SEOHideSocialData", "Page_Live"."InheritSideBar", "Page_Live"."HomeSort", "Page_Live"."SEOSocialImageID", "Page_Live"."SideBarID", "Page_Live"."FeaturedImageID", "Page_Live"."HomePageID", "Blog_Live"."PostsPerPage", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "Blog_Live" ON "Blog_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0026s
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", "Page_Live"."SEOPageSubject", "Page_Live"."SEOSocialType", "Page_Live"."SEOHideSocialData", "Page_Live"."InheritSideBar", "Page_Live"."HomeSort", "Page_Live"."SEOSocialImageID", "Page_Live"."SideBarID", "Page_Live"."FeaturedImageID", "Page_Live"."HomePageID", "Blog_Live"."PostsPerPage", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "Blog_Live" ON "Blog_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0033s
0066: SELECT DISTINCT "Widget_Live"."ClassName", "Widget_Live"."LastEdited", "Widget_Live"."Created", "App_Widgets_EventsWidget_Live"."NumberToShow", CASE WHEN "Widget_Live"."ClassName" IN ('SilverStripe\\Widgets\\Model\\Widget', 'App\\Widgets\\CalltoActionWidget', 'App\\Widgets\\EventsWidget', 'App\\Widgets\\ProductWidget', 'ilateral\\SilverStripe\\Testimonials\\Model\\TestimonialWidget', 'SilverStripe\\Blog\\Widgets\\BlogArchiveWidget', 'SilverStripe\\Blog\\Widgets\\BlogCategoriesWidget', 'SilverStripe\\Blog\\Widgets\\BlogFeaturedPostsWidget', 'SilverStripe\\Blog\\Widgets\\BlogRecentPostsWidget', 'SilverStripe\\Blog\\Widgets\\BlogTagsCloudWidget', 'SilverStripe\\Blog\\Widgets\\BlogTagsWidget') THEN "Widget_Live"."Title" WHEN "Widget_Live"."ClassName" IN ('App\\Widgets\\EventsWidget') THEN "App_Widgets_EventsWidget_Live"."Title" ELSE NULL END AS "Title", "Widget_Live"."ID",
CASE WHEN "Widget_Live"."ClassName" IS NOT NULL THEN "Widget_Live"."ClassName"
ELSE 'SilverStripe\\Widgets\\Model\\Widget' END AS "RecordClassName", "Widget_Live"."Sort"
FROM "Widget_Live" LEFT JOIN "App_Widgets_EventsWidget_Live" ON "App_Widgets_EventsWidget_Live"."ID" = "Widget_Live"."ID"
WHERE ("Widget_Live"."ID" = ?)
AND ("Widget_Live"."ClassName" IN (?))
ORDER BY "Widget_Live"."Sort" ASC
LIMIT 1
0.0047s
0067: SELECT CASE WHEN EXISTS(SELECT *
FROM "CatalogueProduct" LEFT JOIN "Product" ON "Product"."ID" = "CatalogueProduct"."ID" LEFT JOIN "SimpleBookings_EventProduct" ON "SimpleBookings_EventProduct"."ID" = "CatalogueProduct"."ID" LEFT JOIN "SimpleBookings_EventDate" AS "dates_SimpleBookings_EventDate" ON "dates_SimpleBookings_EventDate"."EventID" = "CatalogueProduct"."ID"
WHERE ("dates_SimpleBookings_EventDate"."Start" > ?)
AND ("CatalogueProduct"."ClassName" IN (?))
LIMIT 3) THEN 1 ELSE 0 END
0.0075s
0068: SELECT DISTINCT "Widget_Live"."ClassName", "Widget_Live"."LastEdited", "Widget_Live"."Created", "App_Widgets_ProductWidget_Live"."CategoryID", CASE WHEN "Widget_Live"."ClassName" IN ('SilverStripe\\Widgets\\Model\\Widget', 'App\\Widgets\\CalltoActionWidget', 'App\\Widgets\\EventsWidget', 'App\\Widgets\\ProductWidget', 'ilateral\\SilverStripe\\Testimonials\\Model\\TestimonialWidget', 'SilverStripe\\Blog\\Widgets\\BlogArchiveWidget', 'SilverStripe\\Blog\\Widgets\\BlogCategoriesWidget', 'SilverStripe\\Blog\\Widgets\\BlogFeaturedPostsWidget', 'SilverStripe\\Blog\\Widgets\\BlogRecentPostsWidget', 'SilverStripe\\Blog\\Widgets\\BlogTagsCloudWidget', 'SilverStripe\\Blog\\Widgets\\BlogTagsWidget') THEN "Widget_Live"."Title" WHEN "Widget_Live"."ClassName" IN ('App\\Widgets\\ProductWidget') THEN "App_Widgets_ProductWidget_Live"."Title" ELSE NULL END AS "Title", "Widget_Live"."ID",
CASE WHEN "Widget_Live"."ClassName" IS NOT NULL THEN "Widget_Live"."ClassName"
ELSE 'SilverStripe\\Widgets\\Model\\Widget' END AS "RecordClassName", "Widget_Live"."Sort"
FROM "Widget_Live" LEFT JOIN "App_Widgets_ProductWidget_Live" ON "App_Widgets_ProductWidget_Live"."ID" = "Widget_Live"."ID"
WHERE ("Widget_Live"."ID" = ?)
AND ("Widget_Live"."ClassName" IN (?))
ORDER BY "Widget_Live"."Sort" ASC
LIMIT 1
0.0059s
0069: SELECT DISTINCT RAND() AS "_SortColumn0", "CatalogueProduct"."ClassName", "CatalogueProduct"."LastEdited", "CatalogueProduct"."Created", "CatalogueProduct"."Stocked", "CatalogueProduct"."StockLevel", "CatalogueProduct"."LowStock", "CatalogueProduct"."AvailableOutOfStock", "CatalogueProduct"."SEOPageSubject", "CatalogueProduct"."SEOSocialType", "CatalogueProduct"."SEOHideSocialData", "CatalogueProduct"."URLSegment", "CatalogueProduct"."MetaDescription", "CatalogueProduct"."ExtraMeta", "CatalogueProduct"."Title", "CatalogueProduct"."BasePrice", "CatalogueProduct"."StockID", "CatalogueProduct"."Content", "CatalogueProduct"."ContentSummary", "CatalogueProduct"."Weight", "CatalogueProduct"."Disabled", "CatalogueProduct"."SEOSocialImageID", "CatalogueProduct"."TaxRateID", "CatalogueProduct"."TaxCategoryID", "Product"."HomeSort", "Product"."HomePageID", "CatalogueProduct"."ID",
CASE WHEN "CatalogueProduct"."ClassName" IS NOT NULL THEN "CatalogueProduct"."ClassName"
ELSE 'SilverCommerce\\CatalogueAdmin\\Model\\CatalogueProduct' END AS "RecordClassName"
FROM "CatalogueProduct" LEFT JOIN "Product" ON "Product"."ID" = "CatalogueProduct"."ID"
WHERE ("CatalogueProduct"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "_SortColumn0" ASC
LIMIT 1
0.0136s
0070: SELECT CASE WHEN EXISTS(SELECT *
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "CatalogueProduct_Images" ON "CatalogueProduct_Images"."ImageID" = "File_Live"."ID"
WHERE ("CatalogueProduct_Images"."CatalogueProductID" = ?)
AND ("File_Live"."ClassName" IN (?))) THEN 1 ELSE 0 END
0.0031s
0071: SELECT DISTINCT "CatalogueProduct_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "CatalogueProduct_Images" ON "CatalogueProduct_Images"."ImageID" = "File_Live"."ID"
WHERE ("CatalogueProduct_Images"."CatalogueProductID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "SortOrder" ASC
LIMIT 1
0.0088s
0072: SELECT DISTINCT "CatalogueCategory_Products"."SortOrder", "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" INNER JOIN "CatalogueCategory_Products" ON "CatalogueCategory_Products"."CatalogueCategoryID" = "CatalogueCategory"."ID"
WHERE ("CatalogueCategory_Products"."CatalogueProductID" = ?)
AND (("CatalogueCategory"."Disabled" != ? OR "CatalogueCategory"."Disabled" IS NULL))
ORDER BY "CatalogueCategory"."Sort" ASC
LIMIT 1
0.0051s
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", "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.0075s
0074: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "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.006s
0075: 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.005s
0076: SELECT CASE WHEN EXISTS(SELECT *
FROM "CustomMenuLink"
WHERE ("CustomMenuLink"."MenuID" = ?)) THEN 1 ELSE 0 END
0.0063s
0077: 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.0032s
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", "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.0051s
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", "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.01s
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", "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.0058s
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.0021s
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.0072s
0083: 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.0039s
0084: 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.0043s
0085: SELECT CASE WHEN EXISTS(SELECT *
FROM "CustomMenuLink"
WHERE ("CustomMenuLink"."MenuID" = ?)) THEN 1 ELSE 0 END
0.0013s
0086: 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.0045s
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.005s
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.0063s
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.0045s
0090: 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.0049s
0091: 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.006s
0092: 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.0111s
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.0075s
0094: 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.0067s
0095: SELECT CASE WHEN EXISTS(SELECT *
FROM "CustomMenuLink"
WHERE ("CustomMenuLink"."MenuID" = ?)) THEN 1 ELSE 0 END
0.0048s
0096: 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.0041s
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.0068s
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.0087s
0099: 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.002s
0100: 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.0043s
0101: 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.0048s
0102: 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.0036s
0103: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "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.0099s
0104: SELECT "Version" FROM "SiteTree" WHERE "ID" = ?
0.0084s
0105: 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.0031s
0106: 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.0042s
0107: 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.0082s
0108: 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.0041s
0109: 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.0049s
0110: 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.0047s
Musings from a Cookery School Principal » Harts Barn Cookery School
Musings from a Cookery School Principal
Sign Up To Our Newsletter
I often get asked about my job as Principal of the Cookery School so I thought I’d share what actually goes on here in a “typical” week.
It was always my aim to develop a Cookery School that was accessible to everyone and non elitist so “cooking for all” really seemed to encapsulate my vision from day one.
A colleague of mine, runs a creative business offering art and craft activities, now she calls herself ‘eclectic’ due to the diversity of art projects she runs – we’ve even collaborated on cook and craft projects, among others.
Eclectic is a word I have been thinking a lot about recently and I feel it is a good word to describe life running a cookery school with the vision of offering ‘cooking for all’.
Eclectic (English Oxford Dictionary)
adjective Deriving ideas, style, or taste from a broad and diverse range of sources.
(“universities offering an eclectic mix of courses”)
noun A person who derives ideas, style, or taste from a broad and diverse range of sources.
When I started the Cookery School, I believed that the range of cooking classes would be the ‘bread and butter’ of the business. During 5 years of ‘cooking for all’ (our birthday is on June 11th) I can put my hands up and say how wrong I was! We work diversely for our customers from bread classes to creating an edible canvas for a corporate team day! Every week we seem to find ourselves either developing a new idea, a new menu, a new party idea, a new collaboration or a new class!
Last week has just bought back to me how eclectic the running of a cookery school can be, this is what it looked like:
Monday – Gloscol and Forest Sensory Group hire the cookery school to run classes for people with daily challenges such as Learning difficulties and loss of sight.
Tuesday – Creating a very special 18th Birthday cake (for my daughter) as well as taking calls, responding to email enquiries and having a meeting regarding cookery school accounts!
Wednesday – Planting herbs and edible flowers in our courtyard. Mainly curly leaf and flat leaf parsley but also tarragon, borage, chives and violas. I’m always getting asked about edible flowers and being a trained horticulturist it’s an area I can get really carried away by.
Thursday – Teaching cookie making to a group of teenagers in Care that come to the Cookery School every week to learn skills, have fun and relax – this was then followed by prepping for a big day on Friday.
Friday – Hosting and teaching a 26 strong corporate team. The theme was ‘Healthy Eating – avoiding refined foods’. Our remit was requested by the client whose team had suffered a selection of absences due to ill health since the beginning of the year. 20 dishes with no refined flour, no sugar, no gluten. Tasty and eclectic!
Saturday – Teaching a group of 8 all about the basics of Pastry making. My heart went out to one attendee whose wife had passed away earlier this year and he wanted to make pastry like his wife used. This we achieved by the end of the lesson, he was a very happy man and this made my weekend. Satisfaction by shortcrust.
Sunday – We took the Cookery School on the road to Cheltenham where we hosted a Chocolate Making party for 8 very excited 9 year old girls.
It seems every week here at the Cookery School we have something different on the menu. Yes we are certainly ‘eclectic’ and yes we are certainly diverse – I guess that is what comes with having the ethos of ‘Cooking for All’ at the heart of your business – and I wouldn’t have it any other way!