0002: SHOW DATABASES LIKE 'hartsbarn-store'
0.0027s
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.0014s
0004: SHOW FULL TABLES WHERE Table_Type != 'VIEW'
0.0042s
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.002s
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.0015s
0007: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0014s
0008: SELECT DISTINCT "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-04-24 12:55:50')
ORDER BY "_SortColumn0" DESC, "BlogPost_Live"."PublishDate" DESC
LIMIT 1
0.0018s
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.0015s
0010: 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
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.0012s
0012: 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.0018s
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.0009s
0014: 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.0011s
0015: SELECT DISTINCT "CustomMenuHolder"."ClassName", "CustomMenuHolder"."LastEdited", "CustomMenuHolder"."Created", "CustomMenuHolder"."Title", "CustomMenuHolder"."Slug", "CustomMenuHolder"."Order", "CustomMenuHolder"."SiteID", "CustomMenuHolder"."ID",
CASE WHEN "CustomMenuHolder"."ClassName" IS NOT NULL THEN "CustomMenuHolder"."ClassName"
ELSE 'ilateral\\SilverStripe\\CustomMenus\\Model\\CustomMenuHolder' END AS "RecordClassName"
FROM "CustomMenuHolder"
WHERE ("CustomMenuHolder"."SiteID" = ?)
AND ("CustomMenuHolder"."Slug" = ?)
LIMIT 1
0.0012s
0016: SELECT CASE WHEN EXISTS(SELECT *
FROM "CustomMenuLink"
WHERE ("CustomMenuLink"."MenuID" = ?)) THEN 1 ELSE 0 END
0.0008s
0017: SELECT DISTINCT "CustomMenuLink"."ClassName", "CustomMenuLink"."LastEdited", "CustomMenuLink"."Created", "CustomMenuLink"."BaseClass", "CustomMenuLink"."ObjectID", "CustomMenuLink"."SortOrder", "CustomMenuLink"."MenuID", "CustomMenuLink"."ID",
CASE WHEN "CustomMenuLink"."ClassName" IS NOT NULL THEN "CustomMenuLink"."ClassName"
ELSE 'ilateral\\SilverStripe\\CustomMenus\\Model\\CustomMenuLink' END AS "RecordClassName"
FROM "CustomMenuLink"
WHERE ("CustomMenuLink"."MenuID" = ?)
ORDER BY "CustomMenuLink"."SortOrder" ASC
0.0007s
0018: 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
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.001s
0020: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0011s
0021: 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
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", "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
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.0013s
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.0009s
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.001s
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.0008s
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.0009s
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.0014s
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.0009s
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.0008s
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.0009s
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.0009s
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.001s
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.0008s
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.0009s
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.0012s
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.0008s
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.0009s
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.0009s
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.0009s
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.0009s
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"."ID" = ?)
ORDER BY "CatalogueCategory"."Sort" ASC
LIMIT 1
0.0011s
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.001s
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.001s
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.0008s
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.0007s
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.0011s
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.0009s
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.0009s
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.001s
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.0008s
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.0009s
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.001s
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.0013s
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.0011s
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.001s
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.0011s
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.0009s
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.0009s
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.0008s
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.0011s
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.0014s
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.0013s
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.002s
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"."ParentID" <> "CatalogueCategory"."ID")
AND ("CatalogueCategory"."ParentID" = ?)
ORDER BY "CatalogueCategory"."Sort" ASC
0.0014s
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"."ID" = ?)
ORDER BY "CatalogueCategory"."Sort" ASC
LIMIT 1
0.0011s
0069: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
0.0023s
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"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0011s
0071: SELECT DISTINCT "CatalogueCategory"."ClassName", "CatalogueCategory"."LastEdited", "CatalogueCategory"."Created", "CatalogueCategory"."SEOPageSubject", "CatalogueCategory"."SEOSocialType", "CatalogueCategory"."SEOHideSocialData", "CatalogueCategory"."URLSegment", "CatalogueCategory"."MetaDescription", "CatalogueCategory"."ExtraMeta", "CatalogueCategory"."Title", "CatalogueCategory"."Content", "CatalogueCategory"."Sort", "CatalogueCategory"."Disabled", "CatalogueCategory"."SEOSocialImageID", "CatalogueCategory"."ImageID", "CatalogueCategory"."ParentID", "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.0021s
0072: 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.0012s
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.0016s
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.001s
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.0012s
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.0011s
0079: 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.0025s
0080: 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.0013s
0081: 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.0025s
0082: 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.0015s
0083: 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.0021s
0084: 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.0017s
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.0016s
0086: SELECT CASE WHEN EXISTS(SELECT *
FROM "Widget_Live"
WHERE ("Widget_Live"."ParentID" = ?)) THEN 1 ELSE 0 END
0.0015s
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.0014s
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.0018s
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.002s
0090: SELECT CASE WHEN EXISTS(SELECT *
FROM "BlogCategory"
WHERE ("BlogCategory"."BlogID" = ?)) THEN 1 ELSE 0 END
0.0012s
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.0012s
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.0013s
0094: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "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.0012s
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.002s
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.0026s
0097: SELECT DISTINCT "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", "SimpleBookings_EventProduct"."Deliverable", "CatalogueProduct"."ID",
CASE WHEN "CatalogueProduct"."ClassName" IS NOT NULL THEN "CatalogueProduct"."ClassName"
ELSE 'SilverCommerce\\CatalogueAdmin\\Model\\CatalogueProduct' END AS "RecordClassName", "Start"
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 (?))
ORDER BY "Start" ASC
LIMIT 3
0.0017s
0098: 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.0022s
0099: 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
0100: 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
0101: 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.002s
0102: 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.0015s
0103: SELECT DISTINCT "SimpleBookings_EventDate"."ClassName", "SimpleBookings_EventDate"."LastEdited", "SimpleBookings_EventDate"."Created", "SimpleBookings_EventDate"."Start", "SimpleBookings_EventDate"."End", "SimpleBookings_EventDate"."Spaces", "SimpleBookings_EventDate"."EventID", "SimpleBookings_EventDate"."ID",
CASE WHEN "SimpleBookings_EventDate"."ClassName" IS NOT NULL THEN "SimpleBookings_EventDate"."ClassName"
ELSE 'ilateral\\SimpleBookings\\Model\\EventDate' END AS "RecordClassName"
FROM "SimpleBookings_EventDate"
WHERE ("SimpleBookings_EventDate"."EventID" = ?)
AND (("SimpleBookings_EventDate"."Start" > ?))
ORDER BY "SimpleBookings_EventDate"."Start" ASC
LIMIT 1
0.0016s
0104: 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.0022s
0105: 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.0032s
0106: 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.0014s
0107: 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.0029s
0108: 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.0015s
0109: 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.0017s
0110: 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.0017s
0111: SELECT CASE WHEN EXISTS(SELECT *
FROM "CustomMenuLink"
WHERE ("CustomMenuLink"."MenuID" = ?)) THEN 1 ELSE 0 END
0.001s
0112: SELECT DISTINCT "CustomMenuLink"."ClassName", "CustomMenuLink"."LastEdited", "CustomMenuLink"."Created", "CustomMenuLink"."BaseClass", "CustomMenuLink"."ObjectID", "CustomMenuLink"."SortOrder", "CustomMenuLink"."MenuID", "CustomMenuLink"."ID",
CASE WHEN "CustomMenuLink"."ClassName" IS NOT NULL THEN "CustomMenuLink"."ClassName"
ELSE 'ilateral\\SilverStripe\\CustomMenus\\Model\\CustomMenuLink' END AS "RecordClassName"
FROM "CustomMenuLink"
WHERE ("CustomMenuLink"."MenuID" = ?)
ORDER BY "CustomMenuLink"."SortOrder" ASC
0.0008s
0113: 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.0011s
0114: 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.0011s
0115: 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.0011s
0116: 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
0117: 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
0118: 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
0119: 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
0120: SELECT CASE WHEN EXISTS(SELECT *
FROM "CustomMenuLink"
WHERE ("CustomMenuLink"."MenuID" = ?)) THEN 1 ELSE 0 END
0.0011s
0121: 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.0013s
0122: 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
0123: 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
0124: 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
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.0013s
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.0013s
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.0012s
0129: 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.0013s
0130: SELECT CASE WHEN EXISTS(SELECT *
FROM "CustomMenuLink"
WHERE ("CustomMenuLink"."MenuID" = ?)) THEN 1 ELSE 0 END
0.001s
0131: 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.001s
0132: 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
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.001s
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.001s
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.001s
0136: 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
0137: 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.0018s
0138: 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.0013s
0139: SELECT "Version" FROM "SiteTree" WHERE "ID" = ?
0.0013s
0140: 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
0141: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowCarousel", "SiteTree_Live"."CarouselShowIndicators", "SiteTree_Live"."CarouselShowControls", "SiteTree_Live"."CarouselProfile", "SiteTree_Live"."CarouselInterval", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0009s
0142: 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
0143: 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.0011s
0144: 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
0145: 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
A little bit of love and comfort food.. » Harts Barn Cookery School
A little bit of love and comfort food..
Sign Up To Our Newsletter
Something we do very well here in the UK is a good stew. In fact, it is up there in my top go- to comfort foods. And it’s Brexit and weather proof – we can produce all the beautiful ingredients for a winning stew right here on our island. February is definitely the time of year to bring out the stew! We all need a bit of comfort when it’s freezing outside and the skies are grey. It’s a great way to bring everyone together as well, serving the masses from a lovely casserole dish, knowing that everyone will leave the table satisfied and been given a big, warm hug! For me, there has to be some warm, crusty bread as well to accompany the offering or even some lovely homemade dumplings. Delicious! For those of you that haven’t taken the slow cooker out from the back of the cupboard yet, I urge you to do it now, plug it in and get the aromas filling the kitchen. You won’t regret it.
We should all take a bit of time out to bring comfort in to the home – isn’t it love that makes the difference between a house and home? With Valentine’s Day nearly upon us, it’s hard to ignore the symbols of love that seem to pop up in every high street and supermarket this time of year. Whilst enforced romance might not be everyone’s cup of tea, I would say take the message of love and embrace it anyway! Take on the challenge of bringing a little self-love in to your life! That might mean different things to different people but for me it would mean taking some time out and getting in to the kitchen to prepare something that I know warms my soul. I’ve already mentioned a stew but I wanted to share a recipe with you that offers something a little different. I cannot recommend this soup enough. Don’t be put off by the long list of ingredients – a lot will come under store cupboard ingredients so if you have to buy them, they will keep. I would recommend however, making sure you use fresh ginger for this recipe. Ginger is brilliantly warming and this recipe is very much about giving you that warm glow from within and it’s my little Valentine’s gift for you.. With love, Yvette x
Blend the garlic, spring onions, fish sauce and coriander to a paste. Tip paste into a bowl with the egg and mince. Mix well.
Form the meat mixture in to bite size balls. Bake in a hot oven at 180˚c for approx 10 mins until partially cooked through. Add the stock, lemongrass, garlic, ginger, spring onions, sugar, salt, lime juice, fish sauce and star anise to a pan. Simmer for 30 mins to infuse the flavours. Strain the mixture and taste for seasoning. Add the meatballs and simmer for 15 mins until cooked through. Cook the noodles and add to your serving bowls. Ladle the soup and meatballs over the noodles Serve with fresh coriander, chilli and soy sauce.