0002: SHOW DATABASES LIKE 'hartsbarn-store'
0.0038s
0003: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", "SiteConfig"."ShowCartPostageForm", "SiteConfig"."ShowCartDiscountForm", "SiteConfig"."LastEstimateClean", "SiteConfig"."SiteLocale", "SiteConfig"."ContactPhone", "SiteConfig"."ContactEmail", "SiteConfig"."ContactAddress", "SiteConfig"."ShowPriceAndTax", "SiteConfig"."ShowPriceTaxString", "SiteConfig"."EstimateNumberPrefix", "SiteConfig"."InvoiceNumberPrefix", "SiteConfig"."OrderNumberLength", "SiteConfig"."InvoiceHeaderContent", "SiteConfig"."InvoiceFooterContent", "SiteConfig"."EstimateHeaderContent", "SiteConfig"."EstimateFooterContent", "SiteConfig"."CheckoutRequireTerms", "SiteConfig"."CheckoutTermsContent", "SiteConfig"."CheckoutLoginForm", "SiteConfig"."CheckoutAllowGuest", "SiteConfig"."PaymentSuccessContent", "SiteConfig"."PaymentFailerContent", "SiteConfig"."CookiePolicyButtonTitle", "SiteConfig"."CookiePolicyDescription", "SiteConfig"."CookiePolicyPosition", "SiteConfig"."CookiePolicyIsActive", "SiteConfig"."TileBackground", "SiteConfig"."Title", "SiteConfig"."Tagline", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."CardLogosID", "SiteConfig"."EstimateInvoiceLogoID", "SiteConfig"."CheckoutTermsPageID", "SiteConfig"."DefaultProductImageID", "SiteConfig"."LogoID", "SiteConfig"."IconID", "SiteConfig"."BackgroundID", "SiteConfig"."ContactPageID", "SiteConfig"."ID",
CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName"
ELSE 'SilverStripe\\SiteConfig\\SiteConfig' END AS "RecordClassName"
FROM "SiteConfig"
LIMIT 1
0.0035s
0004: SHOW FULL TABLES WHERE Table_Type != 'VIEW'
0.0061s
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.0029s
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.002s
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.0055s
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" < '2025-08-06 14:52:45')
ORDER BY "_SortColumn0" DESC, "BlogPost_Live"."PublishDate" DESC
LIMIT 1
0.0032s
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.0017s
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.0075s
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.0032s
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.0053s
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.0027s
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.0047s
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.0014s
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.0047s
0017: SELECT CASE WHEN EXISTS(SELECT *
FROM "CustomMenuLink"
WHERE ("CustomMenuLink"."MenuID" = ?)) THEN 1 ELSE 0 END
0.0022s
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.0012s
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.0044s
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.0014s
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.0012s
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.0055s
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.0015s
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"."ParentID" <> "CatalogueCategory"."ID")
AND ("CatalogueCategory"."ParentID" = ?)
ORDER BY "CatalogueCategory"."Sort" ASC
0.0019s
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"."ParentID" <> "CatalogueCategory"."ID")
AND ("CatalogueCategory"."ParentID" = ?)
ORDER BY "CatalogueCategory"."Sort" ASC
0.0013s
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"."ParentID" <> "CatalogueCategory"."ID")
AND ("CatalogueCategory"."ParentID" = ?)
ORDER BY "CatalogueCategory"."Sort" ASC
0.0022s
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"."ParentID" <> "CatalogueCategory"."ID")
AND ("CatalogueCategory"."ParentID" = ?)
ORDER BY "CatalogueCategory"."Sort" ASC
0.0029s
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"."ParentID" <> "CatalogueCategory"."ID")
AND ("CatalogueCategory"."ParentID" = ?)
ORDER BY "CatalogueCategory"."Sort" ASC
0.0028s
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"."ParentID" <> "CatalogueCategory"."ID")
AND ("CatalogueCategory"."ParentID" = ?)
ORDER BY "CatalogueCategory"."Sort" ASC
0.0026s
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"."ParentID" <> "CatalogueCategory"."ID")
AND ("CatalogueCategory"."ParentID" = ?)
ORDER BY "CatalogueCategory"."Sort" ASC
0.0022s
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"."ParentID" <> "CatalogueCategory"."ID")
AND ("CatalogueCategory"."ParentID" = ?)
ORDER BY "CatalogueCategory"."Sort" ASC
0.0012s
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"."ParentID" <> "CatalogueCategory"."ID")
AND ("CatalogueCategory"."ParentID" = ?)
ORDER BY "CatalogueCategory"."Sort" ASC
0.0024s
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"."ParentID" <> "CatalogueCategory"."ID")
AND ("CatalogueCategory"."ParentID" = ?)
ORDER BY "CatalogueCategory"."Sort" ASC
0.0011s
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"."ParentID" <> "CatalogueCategory"."ID")
AND ("CatalogueCategory"."ParentID" = ?)
ORDER BY "CatalogueCategory"."Sort" ASC
0.0023s
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"."ParentID" <> "CatalogueCategory"."ID")
AND ("CatalogueCategory"."ParentID" = ?)
ORDER BY "CatalogueCategory"."Sort" ASC
0.0023s
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"."ParentID" <> "CatalogueCategory"."ID")
AND ("CatalogueCategory"."ParentID" = ?)
ORDER BY "CatalogueCategory"."Sort" ASC
0.0029s
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"."ParentID" <> "CatalogueCategory"."ID")
AND ("CatalogueCategory"."ParentID" = ?)
ORDER BY "CatalogueCategory"."Sort" ASC
0.0056s
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"."ParentID" <> "CatalogueCategory"."ID")
AND ("CatalogueCategory"."ParentID" = ?)
ORDER BY "CatalogueCategory"."Sort" ASC
0.0012s
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.0036s
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"."ParentID" <> "CatalogueCategory"."ID")
AND ("CatalogueCategory"."ParentID" = ?)
ORDER BY "CatalogueCategory"."Sort" ASC
0.0011s
0041: 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.0014s
0042: 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.0011s
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.0028s
0044: 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.0026s
0045: 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.0026s
0046: 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.0033s
0047: 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
0048: 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.0027s
0049: 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.0056s
0050: 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.0013s
0051: 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.0014s
0052: 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
0053: SELECT DISTINCT "CatalogueCategory"."ClassName", "CatalogueCategory"."LastEdited", "CatalogueCategory"."Created", "CatalogueCategory"."SEOPageSubject", "CatalogueCategory"."SEOSocialType", "CatalogueCategory"."SEOHideSocialData", "CatalogueCategory"."URLSegment", "CatalogueCategory"."MetaDescription", "CatalogueCategory"."ExtraMeta", "CatalogueCategory"."Title", "CatalogueCategory"."Content", "CatalogueCategory"."Sort", "CatalogueCategory"."Disabled", "CatalogueCategory"."SEOSocialImageID", "CatalogueCategory"."ImageID", "CatalogueCategory"."ParentID", "CatalogueCategory"."ID",
CASE WHEN "CatalogueCategory"."ClassName" IS NOT NULL THEN "CatalogueCategory"."ClassName"
ELSE 'SilverCommerce\\CatalogueAdmin\\Model\\CatalogueCategory' END AS "RecordClassName"
FROM "CatalogueCategory"
WHERE ("CatalogueCategory"."ID" = ?)
ORDER BY "CatalogueCategory"."Sort" ASC
LIMIT 1
0.0015s
0054: 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.0013s
0055: 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.0014s
0056: 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.0014s
0057: 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.0027s
0058: 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.0028s
0059: 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
0060: 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
0061: 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.0023s
0062: 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
0063: SELECT DISTINCT "CatalogueCategory"."ClassName", "CatalogueCategory"."LastEdited", "CatalogueCategory"."Created", "CatalogueCategory"."SEOPageSubject", "CatalogueCategory"."SEOSocialType", "CatalogueCategory"."SEOHideSocialData", "CatalogueCategory"."URLSegment", "CatalogueCategory"."MetaDescription", "CatalogueCategory"."ExtraMeta", "CatalogueCategory"."Title", "CatalogueCategory"."Content", "CatalogueCategory"."Sort", "CatalogueCategory"."Disabled", "CatalogueCategory"."SEOSocialImageID", "CatalogueCategory"."ImageID", "CatalogueCategory"."ParentID", "CatalogueCategory"."ID",
CASE WHEN "CatalogueCategory"."ClassName" IS NOT NULL THEN "CatalogueCategory"."ClassName"
ELSE 'SilverCommerce\\CatalogueAdmin\\Model\\CatalogueCategory' END AS "RecordClassName"
FROM "CatalogueCategory"
WHERE ("CatalogueCategory"."ID" = ?)
ORDER BY "CatalogueCategory"."Sort" ASC
LIMIT 1
0.0012s
0064: 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
0065: 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.0011s
0066: SELECT DISTINCT "CatalogueCategory"."ClassName", "CatalogueCategory"."LastEdited", "CatalogueCategory"."Created", "CatalogueCategory"."SEOPageSubject", "CatalogueCategory"."SEOSocialType", "CatalogueCategory"."SEOHideSocialData", "CatalogueCategory"."URLSegment", "CatalogueCategory"."MetaDescription", "CatalogueCategory"."ExtraMeta", "CatalogueCategory"."Title", "CatalogueCategory"."Content", "CatalogueCategory"."Sort", "CatalogueCategory"."Disabled", "CatalogueCategory"."SEOSocialImageID", "CatalogueCategory"."ImageID", "CatalogueCategory"."ParentID", "CatalogueCategory"."ID",
CASE WHEN "CatalogueCategory"."ClassName" IS NOT NULL THEN "CatalogueCategory"."ClassName"
ELSE 'SilverCommerce\\CatalogueAdmin\\Model\\CatalogueCategory' END AS "RecordClassName"
FROM "CatalogueCategory"
WHERE ("CatalogueCategory"."ID" = ?)
ORDER BY "CatalogueCategory"."Sort" ASC
LIMIT 1
0.001s
0067: 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.0055s
0068: 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.0014s
0069: SELECT DISTINCT "CatalogueCategory"."ClassName", "CatalogueCategory"."LastEdited", "CatalogueCategory"."Created", "CatalogueCategory"."SEOPageSubject", "CatalogueCategory"."SEOSocialType", "CatalogueCategory"."SEOHideSocialData", "CatalogueCategory"."URLSegment", "CatalogueCategory"."MetaDescription", "CatalogueCategory"."ExtraMeta", "CatalogueCategory"."Title", "CatalogueCategory"."Content", "CatalogueCategory"."Sort", "CatalogueCategory"."Disabled", "CatalogueCategory"."SEOSocialImageID", "CatalogueCategory"."ImageID", "CatalogueCategory"."ParentID", "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.0035s
0070: 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.0017s
0071: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0011s
0072: SELECT DISTINCT "CatalogueCategory"."ClassName", "CatalogueCategory"."LastEdited", "CatalogueCategory"."Created", "CatalogueCategory"."SEOPageSubject", "CatalogueCategory"."SEOSocialType", "CatalogueCategory"."SEOHideSocialData", "CatalogueCategory"."URLSegment", "CatalogueCategory"."MetaDescription", "CatalogueCategory"."ExtraMeta", "CatalogueCategory"."Title", "CatalogueCategory"."Content", "CatalogueCategory"."Sort", "CatalogueCategory"."Disabled", "CatalogueCategory"."SEOSocialImageID", "CatalogueCategory"."ImageID", "CatalogueCategory"."ParentID", "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.0042s
0073: 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.0023s
0074: SELECT CASE WHEN EXISTS(SELECT *
FROM "CustomMenuLink"
WHERE ("CustomMenuLink"."MenuID" = ?)) THEN 1 ELSE 0 END
0.0009s
0075: 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.0011s
0076: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0011s
0077: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0015s
0078: 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.0021s
0079: 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.0056s
0080: 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.0039s
0081: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "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.0048s
0082: 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.0031s
0083: 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.0027s
0084: 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.0033s
0085: 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.0014s
0086: SELECT CASE WHEN EXISTS(SELECT *
FROM "Widget_Live"
WHERE ("Widget_Live"."ParentID" = ?)) THEN 1 ELSE 0 END
0.0021s
0087: 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.0012s
0088: 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.0016s
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", "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.003s
0090: SELECT CASE WHEN EXISTS(SELECT *
FROM "BlogCategory"
WHERE ("BlogCategory"."BlogID" = ?)) THEN 1 ELSE 0 END
0.0011s
0091: 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.0011s
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", "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.0015s
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", "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.0015s
0094: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "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.0015s
0095: 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.0025s
0096: 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.0049s
0097: 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.0023s
0098: 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.0034s
0099: 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.0021s
0100: 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.0016s
0101: 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.003s
0102: 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
0103: 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
0104: SELECT CASE WHEN EXISTS(SELECT *
FROM "CustomMenuLink"
WHERE ("CustomMenuLink"."MenuID" = ?)) THEN 1 ELSE 0 END
0.0013s
0105: SELECT DISTINCT "CustomMenuLink"."ClassName", "CustomMenuLink"."LastEdited", "CustomMenuLink"."Created", "CustomMenuLink"."BaseClass", "CustomMenuLink"."ObjectID", "CustomMenuLink"."SortOrder", "CustomMenuLink"."MenuID", "CustomMenuLink"."ID",
CASE WHEN "CustomMenuLink"."ClassName" IS NOT NULL THEN "CustomMenuLink"."ClassName"
ELSE 'ilateral\\SilverStripe\\CustomMenus\\Model\\CustomMenuLink' END AS "RecordClassName"
FROM "CustomMenuLink"
WHERE ("CustomMenuLink"."MenuID" = ?)
ORDER BY "CustomMenuLink"."SortOrder" ASC
0.0009s
0106: SELECT DISTINCT "CatalogueCategory"."ClassName", "CatalogueCategory"."LastEdited", "CatalogueCategory"."Created", "CatalogueCategory"."SEOPageSubject", "CatalogueCategory"."SEOSocialType", "CatalogueCategory"."SEOHideSocialData", "CatalogueCategory"."URLSegment", "CatalogueCategory"."MetaDescription", "CatalogueCategory"."ExtraMeta", "CatalogueCategory"."Title", "CatalogueCategory"."Content", "CatalogueCategory"."Sort", "CatalogueCategory"."Disabled", "CatalogueCategory"."SEOSocialImageID", "CatalogueCategory"."ImageID", "CatalogueCategory"."ParentID", "Category"."HomeSort", "Category"."HomePageID", "CatalogueCategory"."ID",
CASE WHEN "CatalogueCategory"."ClassName" IS NOT NULL THEN "CatalogueCategory"."ClassName"
ELSE 'SilverCommerce\\CatalogueAdmin\\Model\\CatalogueCategory' END AS "RecordClassName"
FROM "CatalogueCategory" LEFT JOIN "Category" ON "Category"."ID" = "CatalogueCategory"."ID"
WHERE ("CatalogueCategory"."ID" = ?)
AND ("CatalogueCategory"."ClassName" IN (?))
ORDER BY "CatalogueCategory"."Sort" ASC
LIMIT 1
0.0013s
0107: 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.001s
0108: 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.001s
0109: SELECT DISTINCT "CatalogueCategory"."ClassName", "CatalogueCategory"."LastEdited", "CatalogueCategory"."Created", "CatalogueCategory"."SEOPageSubject", "CatalogueCategory"."SEOSocialType", "CatalogueCategory"."SEOHideSocialData", "CatalogueCategory"."URLSegment", "CatalogueCategory"."MetaDescription", "CatalogueCategory"."ExtraMeta", "CatalogueCategory"."Title", "CatalogueCategory"."Content", "CatalogueCategory"."Sort", "CatalogueCategory"."Disabled", "CatalogueCategory"."SEOSocialImageID", "CatalogueCategory"."ImageID", "CatalogueCategory"."ParentID", "CatalogueCategory"."ID",
CASE WHEN "CatalogueCategory"."ClassName" IS NOT NULL THEN "CatalogueCategory"."ClassName"
ELSE 'SilverCommerce\\CatalogueAdmin\\Model\\CatalogueCategory' END AS "RecordClassName"
FROM "CatalogueCategory"
WHERE ("CatalogueCategory"."ID" = ?)
ORDER BY "CatalogueCategory"."Sort" ASC
LIMIT 1
0.001s
0110: 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.0017s
0111: 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.0011s
0112: 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.001s
0113: SELECT CASE WHEN EXISTS(SELECT *
FROM "CustomMenuLink"
WHERE ("CustomMenuLink"."MenuID" = ?)) THEN 1 ELSE 0 END
0.0009s
0114: SELECT DISTINCT "CustomMenuLink"."ClassName", "CustomMenuLink"."LastEdited", "CustomMenuLink"."Created", "CustomMenuLink"."BaseClass", "CustomMenuLink"."ObjectID", "CustomMenuLink"."SortOrder", "CustomMenuLink"."MenuID", "CustomMenuLink"."ID",
CASE WHEN "CustomMenuLink"."ClassName" IS NOT NULL THEN "CustomMenuLink"."ClassName"
ELSE 'ilateral\\SilverStripe\\CustomMenus\\Model\\CustomMenuLink' END AS "RecordClassName"
FROM "CustomMenuLink"
WHERE ("CustomMenuLink"."MenuID" = ?)
ORDER BY "CustomMenuLink"."SortOrder" ASC
0.0012s
0115: 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
0116: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0012s
0117: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0012s
0118: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0011s
0119: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0013s
0120: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0013s
0121: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0013s
0122: SELECT DISTINCT "CustomMenuHolder"."ClassName", "CustomMenuHolder"."LastEdited", "CustomMenuHolder"."Created", "CustomMenuHolder"."Title", "CustomMenuHolder"."Slug", "CustomMenuHolder"."Order", "CustomMenuHolder"."SiteID", "CustomMenuHolder"."ID",
CASE WHEN "CustomMenuHolder"."ClassName" IS NOT NULL THEN "CustomMenuHolder"."ClassName"
ELSE 'ilateral\\SilverStripe\\CustomMenus\\Model\\CustomMenuHolder' END AS "RecordClassName"
FROM "CustomMenuHolder"
WHERE ("CustomMenuHolder"."SiteID" = ?)
AND ("CustomMenuHolder"."Slug" = ?)
LIMIT 1
0.0014s
0123: SELECT CASE WHEN EXISTS(SELECT *
FROM "CustomMenuLink"
WHERE ("CustomMenuLink"."MenuID" = ?)) THEN 1 ELSE 0 END
0.0012s
0124: 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.0011s
0125: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0011s
0126: 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
0127: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0012s
0128: 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.0024s
0129: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0015s
0130: 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.0019s
0131: 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.0014s
0132: SELECT "Version" FROM "SiteTree" WHERE "ID" = ?
0.0024s
0133: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0013s
0134: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0014s
0135: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0011s
0136: SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", "SiteTree"."Priority", "SiteTree"."ShowCarousel", "SiteTree"."CarouselShowIndicators", "SiteTree"."CarouselShowControls", "SiteTree"."CarouselProfile", "SiteTree"."CarouselInterval", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."Version", "SiteTree"."URLSegment", "SiteTree"."Title", "SiteTree"."MenuTitle", "SiteTree"."Content", "SiteTree"."MetaDescription", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", "SiteTree"."ReportClass", "SiteTree"."ParentID", "SiteTree"."ID",
CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree"
WHERE ("SiteTree"."ID" = ?)
ORDER BY "SiteTree"."Sort" ASC
LIMIT 1
0.0012s
0137: 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.016s
0138: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0012s
GUEST BLOG – ERIN SHARES HER RECIPE FOR PUMPKIN PIE » Harts Barn Cookery School
GUEST BLOG – ERIN SHARES HER RECIPE FOR PUMPKIN PIE
Sign Up To Our Newsletter
Pumpkin Pie has got to be the quintessential American autumn treat. As I am an American living in England I recreate this classic pie every year to remind me of home. Until they have tried it, most people I have met in the UK are not convinced they will enjoy a piece of pumpkin pie. When asked to describe pumpkin pie I refer to it as a spiced pumpkin flavoured custard tart. This generally warms people to the idea of it and after they have scoffed it, they are completely in love. Most recipes in found in the states call for tins of pumpkin purée and evaporated milk, two things I would rather not use! This recipe calls for fresh pumpkin and replaces the evaporated milk with double cream. I grow a special type of pumpkin called New England Pie Pumpkin that is perfect for this recipe. This variety is sweeter and less watery than the type for carving. When people ask if I am going to carve my precious beauties, they are often glared at with offensive eyes and are then told the tale of pumpkin pie. When making the pastry, make a double batch, wrap in cling film and place in the freezer, always great to have some spare.
The recipe can be made with butternut squash, but really it should be pumpkin, hence the name.
Pumpkin Pie Pastry 150g plain flour 75g cold butter 1 medium egg, beaten
To make the pastry, cut the butter into small pieces and place with the flour in a large bowl. Rub the butter into the flour gently using your fingertips. This can also be done with a food processor. Continue until the mixture resembles breadcrumbs, working quickly so the dough does not become too warm. Add the egg and stir together with a wooden spoon or rubber spatula to form a dough. Turn the dough onto a lightly floured surface and knead gently to fully combine, form a ball of dough. Wrap in cling film and let rest in the fridge for 30 minutes.
To make pumpkin purée, slice a pumpkin in half and scoop out the seeds. Preheat oven to 200C/180 Fan/Gas Mark 6. Place cut side down on a baking tray and bake for 30 minutes, or until a knife can easily be inserted. Remove from oven and let cool. Scrape pumpkin away from the skin and discard the skin. Purée pumpkin with a food processor or hand blender until smooth. Measure 600grams for the pie. The rest of the puree can be used in soups, made into a sauce, used in cookies, to fill pasta, muffins or simply warmed, seasoned and eaten as a side.
Preheat oven to 180C/160 Fan/Gas Mark 4. On a lightly floured counter, using a rolling pin, roll out pastry to fit a 9inch/23cm pie tin. Place the pastry in the pie tin and trim the edge or pinch together to form a crust. Blind bake using ceramic baking beads or dried beans on top of parchment paper for 10 minutes. Remove baking beans. If the edge of the pastry darkened during the blind baking process, cover with aluminum foil for final baking.
Combine pumpkin purée with cream, eggs, spices and sugars, this can be done in a food processor or in a bowl with a whisk. Gently combine as not to thicken the cream. Pour filling into blind baked pie crust. Bake for 45-50 minutes or until filling has just set. Cool on a baking rack. Serve warm with whipped cream.