0002: SHOW DATABASES LIKE 'nature-gifts-store'
0.0022s
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"."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"."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.0009s
0004: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."FeaturedImageID", "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.0043s
0005: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."FeaturedImageID", "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.0022s
0006: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."FeaturedImageID", "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
0007: 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", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0014s
0008: SELECT DISTINCT "SocialNavLink"."ClassName", "SocialNavLink"."LastEdited", "SocialNavLink"."Created", "SocialNavLink"."Service", "SocialNavLink"."URL", "SocialNavLink"."ExtraClasses", "SocialNavLink"."ParentID", "SocialNavLink"."ID",
CASE WHEN "SocialNavLink"."ClassName" IS NOT NULL THEN "SocialNavLink"."ClassName"
ELSE 'DFT\\SilverStripe\\SocialNav\\Model\\SocialNavLink' END AS "RecordClassName"
FROM "SocialNavLink"
WHERE ("SocialNavLink"."ParentID" = ?)
0.002s
0009: 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", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0017s
0010: 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 'DFT\\SilverStripe\\CustomMenus\\Model\\CustomMenuHolder' END AS "RecordClassName"
FROM "CustomMenuHolder"
WHERE ("CustomMenuHolder"."SiteID" = ?)
AND ("CustomMenuHolder"."Slug" = ?)
LIMIT 1
0.0028s
0011: SELECT CASE WHEN EXISTS(SELECT *
FROM "CustomMenuLink"
WHERE ("CustomMenuLink"."MenuID" = ?)) THEN 1 ELSE 0 END
0.0012s
0012: 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 'DFT\\SilverStripe\\CustomMenus\\Model\\CustomMenuLink' END AS "RecordClassName"
FROM "CustomMenuLink"
WHERE ("CustomMenuLink"."MenuID" = ?)
ORDER BY "CustomMenuLink"."SortOrder" ASC
0.0008s
0013: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."FeaturedImageID", "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
0014: SELECT DISTINCT "CatalogueCategory_Live"."ClassName", "CatalogueCategory_Live"."LastEdited", "CatalogueCategory_Live"."Created", "CatalogueCategory_Live"."Version", "CatalogueCategory_Live"."URLSegment", "CatalogueCategory_Live"."MetaDescription", "CatalogueCategory_Live"."ExtraMeta", "CatalogueCategory_Live"."Title", "CatalogueCategory_Live"."Content", "CatalogueCategory_Live"."Sort", "CatalogueCategory_Live"."Disabled", "CatalogueCategory_Live"."ImageID", "CatalogueCategory_Live"."ParentID", "Category_Live"."HomePageID", "CatalogueCategory_Live"."ID",
CASE WHEN "CatalogueCategory_Live"."ClassName" IS NOT NULL THEN "CatalogueCategory_Live"."ClassName"
ELSE 'SilverCommerce\\CatalogueAdmin\\Model\\CatalogueCategory' END AS "RecordClassName"
FROM "CatalogueCategory_Live" LEFT JOIN "Category_Live" ON "Category_Live"."ID" = "CatalogueCategory_Live"."ID"
WHERE ("CatalogueCategory_Live"."ID" = ?)
AND ("CatalogueCategory_Live"."ClassName" IN (?))
ORDER BY "CatalogueCategory_Live"."Sort" ASC
LIMIT 1
0.0031s
0015: SELECT DISTINCT "CatalogueCategory_Live"."ClassName", "CatalogueCategory_Live"."LastEdited", "CatalogueCategory_Live"."Created", "CatalogueCategory_Live"."Version", "CatalogueCategory_Live"."URLSegment", "CatalogueCategory_Live"."MetaDescription", "CatalogueCategory_Live"."ExtraMeta", "CatalogueCategory_Live"."Title", "CatalogueCategory_Live"."Content", "CatalogueCategory_Live"."Sort", "CatalogueCategory_Live"."Disabled", "CatalogueCategory_Live"."ImageID", "CatalogueCategory_Live"."ParentID", "Category_Live"."HomePageID", "CatalogueCategory_Live"."ID",
CASE WHEN "CatalogueCategory_Live"."ClassName" IS NOT NULL THEN "CatalogueCategory_Live"."ClassName"
ELSE 'SilverCommerce\\CatalogueAdmin\\Model\\CatalogueCategory' END AS "RecordClassName"
FROM "CatalogueCategory_Live" LEFT JOIN "Category_Live" ON "Category_Live"."ID" = "CatalogueCategory_Live"."ID"
WHERE ("CatalogueCategory_Live"."ID" = ?)
AND ("CatalogueCategory_Live"."ClassName" IN (?))
ORDER BY "CatalogueCategory_Live"."Sort" ASC
LIMIT 1
0.0051s
0016: SELECT DISTINCT "CatalogueCategory_Live"."ClassName", "CatalogueCategory_Live"."LastEdited", "CatalogueCategory_Live"."Created", "CatalogueCategory_Live"."Version", "CatalogueCategory_Live"."URLSegment", "CatalogueCategory_Live"."MetaDescription", "CatalogueCategory_Live"."ExtraMeta", "CatalogueCategory_Live"."Title", "CatalogueCategory_Live"."Content", "CatalogueCategory_Live"."Sort", "CatalogueCategory_Live"."Disabled", "CatalogueCategory_Live"."ImageID", "CatalogueCategory_Live"."ParentID", "Category_Live"."HomePageID", "CatalogueCategory_Live"."ID",
CASE WHEN "CatalogueCategory_Live"."ClassName" IS NOT NULL THEN "CatalogueCategory_Live"."ClassName"
ELSE 'SilverCommerce\\CatalogueAdmin\\Model\\CatalogueCategory' END AS "RecordClassName"
FROM "CatalogueCategory_Live" LEFT JOIN "Category_Live" ON "Category_Live"."ID" = "CatalogueCategory_Live"."ID"
WHERE ("CatalogueCategory_Live"."ID" = ?)
AND ("CatalogueCategory_Live"."ClassName" IN (?))
ORDER BY "CatalogueCategory_Live"."Sort" ASC
LIMIT 1
0.0011s
0017: SELECT DISTINCT "CatalogueCategory_Live"."ClassName", "CatalogueCategory_Live"."LastEdited", "CatalogueCategory_Live"."Created", "CatalogueCategory_Live"."Version", "CatalogueCategory_Live"."URLSegment", "CatalogueCategory_Live"."MetaDescription", "CatalogueCategory_Live"."ExtraMeta", "CatalogueCategory_Live"."Title", "CatalogueCategory_Live"."Content", "CatalogueCategory_Live"."Sort", "CatalogueCategory_Live"."Disabled", "CatalogueCategory_Live"."ImageID", "CatalogueCategory_Live"."ParentID", "Category_Live"."HomePageID", "CatalogueCategory_Live"."ID",
CASE WHEN "CatalogueCategory_Live"."ClassName" IS NOT NULL THEN "CatalogueCategory_Live"."ClassName"
ELSE 'SilverCommerce\\CatalogueAdmin\\Model\\CatalogueCategory' END AS "RecordClassName"
FROM "CatalogueCategory_Live" LEFT JOIN "Category_Live" ON "Category_Live"."ID" = "CatalogueCategory_Live"."ID"
WHERE ("CatalogueCategory_Live"."ID" = ?)
AND ("CatalogueCategory_Live"."ClassName" IN (?))
ORDER BY "CatalogueCategory_Live"."Sort" ASC
LIMIT 1
0.001s
0018: SELECT DISTINCT "CatalogueCategory_Live"."ClassName", "CatalogueCategory_Live"."LastEdited", "CatalogueCategory_Live"."Created", "CatalogueCategory_Live"."Version", "CatalogueCategory_Live"."URLSegment", "CatalogueCategory_Live"."MetaDescription", "CatalogueCategory_Live"."ExtraMeta", "CatalogueCategory_Live"."Title", "CatalogueCategory_Live"."Content", "CatalogueCategory_Live"."Sort", "CatalogueCategory_Live"."Disabled", "CatalogueCategory_Live"."ImageID", "CatalogueCategory_Live"."ParentID", "Category_Live"."HomePageID", "CatalogueCategory_Live"."ID",
CASE WHEN "CatalogueCategory_Live"."ClassName" IS NOT NULL THEN "CatalogueCategory_Live"."ClassName"
ELSE 'SilverCommerce\\CatalogueAdmin\\Model\\CatalogueCategory' END AS "RecordClassName"
FROM "CatalogueCategory_Live" LEFT JOIN "Category_Live" ON "Category_Live"."ID" = "CatalogueCategory_Live"."ID"
WHERE ("CatalogueCategory_Live"."ID" = ?)
AND ("CatalogueCategory_Live"."ClassName" IN (?))
ORDER BY "CatalogueCategory_Live"."Sort" ASC
LIMIT 1
0.0023s
0019: SELECT DISTINCT "CatalogueCategory_Live"."ClassName", "CatalogueCategory_Live"."LastEdited", "CatalogueCategory_Live"."Created", "CatalogueCategory_Live"."Version", "CatalogueCategory_Live"."URLSegment", "CatalogueCategory_Live"."MetaDescription", "CatalogueCategory_Live"."ExtraMeta", "CatalogueCategory_Live"."Title", "CatalogueCategory_Live"."Content", "CatalogueCategory_Live"."Sort", "CatalogueCategory_Live"."Disabled", "CatalogueCategory_Live"."ImageID", "CatalogueCategory_Live"."ParentID", "Category_Live"."HomePageID", "CatalogueCategory_Live"."ID",
CASE WHEN "CatalogueCategory_Live"."ClassName" IS NOT NULL THEN "CatalogueCategory_Live"."ClassName"
ELSE 'SilverCommerce\\CatalogueAdmin\\Model\\CatalogueCategory' END AS "RecordClassName"
FROM "CatalogueCategory_Live" LEFT JOIN "Category_Live" ON "Category_Live"."ID" = "CatalogueCategory_Live"."ID"
WHERE ("CatalogueCategory_Live"."ID" = ?)
AND ("CatalogueCategory_Live"."ClassName" IN (?))
ORDER BY "CatalogueCategory_Live"."Sort" ASC
LIMIT 1
0.0054s
0020: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."FeaturedImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.001s
0021: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."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"."FeaturedImageID", "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.0017s
0022: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."FeaturedImageID", "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.0025s
0023: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."FeaturedImageID", "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.0053s
0024: 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", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.004s
0025: 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", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0058s
0026: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "GalleryHub_Live"."ShowSideBar", "GalleryHub_Live"."ShowImageTitles", "GalleryHub_Live"."ThumbnailWidth", "GalleryHub_Live"."ThumbnailHeight", "GalleryHub_Live"."ThumbnailResizeType", "GalleryHub_Live"."ThumbnailsPerPage", "GalleryHub_Live"."PaddedImageBackground", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "SiteTree_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" ELSE NULL END AS "FeaturedImageID", "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 "GalleryHub_Live" ON "GalleryHub_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0029s
0027: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."FeaturedImageID", "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.0025s
0028: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."FeaturedImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0055s
0029: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."FeaturedImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0011s
0030: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."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"."FeaturedImageID", "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.0036s
0031: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."FeaturedImageID", "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.003s
0032: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."FeaturedImageID", "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.0072s
0033: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."FeaturedImageID", "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
0034: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."FeaturedImageID", "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
0035: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."FeaturedImageID", "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
0036: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."FeaturedImageID", "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.0032s
0037: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."FeaturedImageID", "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.0067s
0038: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."FeaturedImageID", "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
0039: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."FeaturedImageID", "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
0040: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."FeaturedImageID", "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.0032s
0041: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."FeaturedImageID", "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.0065s
0042: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."FeaturedImageID", "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.0024s
0043: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."FeaturedImageID", "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.0045s
0044: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."FeaturedImageID", "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.0049s
0045: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."FeaturedImageID", "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.0015s
0046: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."FeaturedImageID", "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.0036s
0047: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "GalleryPage_Live"."ImageWidth", "GalleryPage_Live"."ImageHeight", "GalleryPage_Live"."ImageResizeType", "GalleryPage_Live"."GalleryID", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "SiteTree_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" ELSE NULL END AS "FeaturedImageID", "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 "GalleryHub_Live" ON "GalleryHub_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "GalleryPage_Live" ON "GalleryPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0051s
0048: SELECT DISTINCT "Gallery_Live"."ClassName", "Gallery_Live"."LastEdited", "Gallery_Live"."Created", "Gallery_Live"."Version", "Gallery_Live"."Name", "Gallery_Live"."Code", "Gallery_Live"."ID",
CASE WHEN "Gallery_Live"."ClassName" IS NOT NULL THEN "Gallery_Live"."ClassName"
ELSE 'DFT\\SilverStripe\\Gallery\\Model\\Gallery' END AS "RecordClassName"
FROM "Gallery_Live"
WHERE ("Gallery_Live"."ID" = ?)
LIMIT 1
0.004s
0049: SELECT CASE WHEN EXISTS(SELECT *
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN (SELECT DISTINCT "GalleryImage_Live"."ClassName", "GalleryImage_Live"."LastEdited", "GalleryImage_Live"."Created", "GalleryImage_Live"."Version", "GalleryImage_Live"."SortOrder", "GalleryImage_Live"."ImageID", "GalleryImage_Live"."GalleryID", "GalleryImage_Live"."ID",
CASE WHEN "GalleryImage_Live"."ClassName" IS NOT NULL THEN "GalleryImage_Live"."ClassName"
ELSE 'DFT\\SilverStripe\\Gallery\\Model\\GalleryImage' END AS "RecordClassName"
FROM "GalleryImage_Live"
WHERE ("GalleryImage_Live"."GalleryID" = ?)
ORDER BY "GalleryImage_Live"."SortOrder" ASC) AS "GalleryImage" ON "GalleryImage"."ImageID" = "File_Live"."ID"
WHERE ("File_Live"."ClassName" IN (?))) THEN 1 ELSE 0 END
0.0018s
0050: SELECT DISTINCT "GalleryImage"."ClassName" AS "GalleryImage_ClassName", "GalleryImage"."LastEdited" AS "GalleryImage_LastEdited", "GalleryImage"."Created" AS "GalleryImage_Created", "GalleryImage"."Version" AS "GalleryImage_Version", "GalleryImage"."SortOrder" AS "GalleryImage_SortOrder", "GalleryImage"."ImageID" AS "GalleryImage_ImageID", "GalleryImage"."GalleryID" AS "GalleryImage_GalleryID", "GalleryImage"."ID" AS "GalleryImage_ID", "GalleryImage"."RecordClassName" AS "GalleryImage_RecordClassName", "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", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName", "SortOrder"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN (SELECT DISTINCT "GalleryImage_Live"."ClassName", "GalleryImage_Live"."LastEdited", "GalleryImage_Live"."Created", "GalleryImage_Live"."Version", "GalleryImage_Live"."SortOrder", "GalleryImage_Live"."ImageID", "GalleryImage_Live"."GalleryID", "GalleryImage_Live"."ID",
CASE WHEN "GalleryImage_Live"."ClassName" IS NOT NULL THEN "GalleryImage_Live"."ClassName"
ELSE 'DFT\\SilverStripe\\Gallery\\Model\\GalleryImage' END AS "RecordClassName"
FROM "GalleryImage_Live"
WHERE ("GalleryImage_Live"."GalleryID" = ?)
ORDER BY "GalleryImage_Live"."SortOrder" ASC) AS "GalleryImage" ON "GalleryImage"."ImageID" = "File_Live"."ID"
WHERE ("File_Live"."ClassName" IN (?))
ORDER BY "SortOrder" ASC
LIMIT 18
0.0028s
0051: SELECT DISTINCT "GalleryImage"."ClassName" AS "GalleryImage_ClassName", "GalleryImage"."LastEdited" AS "GalleryImage_LastEdited", "GalleryImage"."Created" AS "GalleryImage_Created", "GalleryImage"."Version" AS "GalleryImage_Version", "GalleryImage"."SortOrder" AS "GalleryImage_SortOrder", "GalleryImage"."ImageID" AS "GalleryImage_ImageID", "GalleryImage"."GalleryID" AS "GalleryImage_GalleryID", "GalleryImage"."ID" AS "GalleryImage_ID", "GalleryImage"."RecordClassName" AS "GalleryImage_RecordClassName", "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", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName", "SortOrder"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN (SELECT DISTINCT "GalleryImage_Live"."ClassName", "GalleryImage_Live"."LastEdited", "GalleryImage_Live"."Created", "GalleryImage_Live"."Version", "GalleryImage_Live"."SortOrder", "GalleryImage_Live"."ImageID", "GalleryImage_Live"."GalleryID", "GalleryImage_Live"."ID",
CASE WHEN "GalleryImage_Live"."ClassName" IS NOT NULL THEN "GalleryImage_Live"."ClassName"
ELSE 'DFT\\SilverStripe\\Gallery\\Model\\GalleryImage' END AS "RecordClassName"
FROM "GalleryImage_Live"
WHERE ("GalleryImage_Live"."GalleryID" = ?)
ORDER BY "GalleryImage_Live"."SortOrder" ASC) AS "GalleryImage" ON "GalleryImage"."ImageID" = "File_Live"."ID"
WHERE ("File_Live"."ClassName" IN (?))
ORDER BY "SortOrder" ASC
LIMIT 18
0.0055s
0052: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0021s
0053: SELECT DISTINCT "Gallery_Live"."ClassName", "Gallery_Live"."LastEdited", "Gallery_Live"."Created", "Gallery_Live"."Version", "Gallery_Live"."Name", "Gallery_Live"."Code", "Gallery_Live"."ID",
CASE WHEN "Gallery_Live"."ClassName" IS NOT NULL THEN "Gallery_Live"."ClassName"
ELSE 'DFT\\SilverStripe\\Gallery\\Model\\Gallery' END AS "RecordClassName"
FROM "Gallery_Live"
WHERE ("Gallery_Live"."ID" = ?)
LIMIT 1
0.0044s
0054: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "SiteTree_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" ELSE NULL END AS "FeaturedImageID", "SiteTree_Live"."ParentID", "Page_Live"."HomeSort", "Page_Live"."HomePageID", "GalleryHub_Live"."ShowSideBar", "GalleryHub_Live"."ShowImageTitles", "GalleryHub_Live"."ThumbnailWidth", "GalleryHub_Live"."ThumbnailHeight", "GalleryHub_Live"."ThumbnailResizeType", "GalleryHub_Live"."ThumbnailsPerPage", "GalleryHub_Live"."PaddedImageBackground", "GalleryPage_Live"."ImageWidth", "GalleryPage_Live"."ImageHeight", "GalleryPage_Live"."ImageResizeType", "GalleryPage_Live"."GalleryID", "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 "GalleryHub_Live" ON "GalleryHub_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "GalleryPage_Live" ON "GalleryPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("GalleryPage_Live"."GalleryID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0022s
0055: 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", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0015s
0056: SELECT DISTINCT "Gallery_Live"."ClassName", "Gallery_Live"."LastEdited", "Gallery_Live"."Created", "Gallery_Live"."Version", "Gallery_Live"."Name", "Gallery_Live"."Code", "Gallery_Live"."ID",
CASE WHEN "Gallery_Live"."ClassName" IS NOT NULL THEN "Gallery_Live"."ClassName"
ELSE 'DFT\\SilverStripe\\Gallery\\Model\\Gallery' END AS "RecordClassName"
FROM "Gallery_Live"
WHERE ("Gallery_Live"."ID" = ?)
LIMIT 1
0.0014s
0057: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "SiteTree_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" ELSE NULL END AS "FeaturedImageID", "SiteTree_Live"."ParentID", "Page_Live"."HomeSort", "Page_Live"."HomePageID", "GalleryHub_Live"."ShowSideBar", "GalleryHub_Live"."ShowImageTitles", "GalleryHub_Live"."ThumbnailWidth", "GalleryHub_Live"."ThumbnailHeight", "GalleryHub_Live"."ThumbnailResizeType", "GalleryHub_Live"."ThumbnailsPerPage", "GalleryHub_Live"."PaddedImageBackground", "GalleryPage_Live"."ImageWidth", "GalleryPage_Live"."ImageHeight", "GalleryPage_Live"."ImageResizeType", "GalleryPage_Live"."GalleryID", "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 "GalleryHub_Live" ON "GalleryHub_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "GalleryPage_Live" ON "GalleryPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("GalleryPage_Live"."GalleryID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0037s
0058: 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", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0031s
0059: SELECT DISTINCT "Gallery_Live"."ClassName", "Gallery_Live"."LastEdited", "Gallery_Live"."Created", "Gallery_Live"."Version", "Gallery_Live"."Name", "Gallery_Live"."Code", "Gallery_Live"."ID",
CASE WHEN "Gallery_Live"."ClassName" IS NOT NULL THEN "Gallery_Live"."ClassName"
ELSE 'DFT\\SilverStripe\\Gallery\\Model\\Gallery' END AS "RecordClassName"
FROM "Gallery_Live"
WHERE ("Gallery_Live"."ID" = ?)
LIMIT 1
0.0057s
0060: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "SiteTree_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" ELSE NULL END AS "FeaturedImageID", "SiteTree_Live"."ParentID", "Page_Live"."HomeSort", "Page_Live"."HomePageID", "GalleryHub_Live"."ShowSideBar", "GalleryHub_Live"."ShowImageTitles", "GalleryHub_Live"."ThumbnailWidth", "GalleryHub_Live"."ThumbnailHeight", "GalleryHub_Live"."ThumbnailResizeType", "GalleryHub_Live"."ThumbnailsPerPage", "GalleryHub_Live"."PaddedImageBackground", "GalleryPage_Live"."ImageWidth", "GalleryPage_Live"."ImageHeight", "GalleryPage_Live"."ImageResizeType", "GalleryPage_Live"."GalleryID", "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 "GalleryHub_Live" ON "GalleryHub_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "GalleryPage_Live" ON "GalleryPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("GalleryPage_Live"."GalleryID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0018s
0061: 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", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.004s
0062: SELECT DISTINCT "Gallery_Live"."ClassName", "Gallery_Live"."LastEdited", "Gallery_Live"."Created", "Gallery_Live"."Version", "Gallery_Live"."Name", "Gallery_Live"."Code", "Gallery_Live"."ID",
CASE WHEN "Gallery_Live"."ClassName" IS NOT NULL THEN "Gallery_Live"."ClassName"
ELSE 'DFT\\SilverStripe\\Gallery\\Model\\Gallery' END AS "RecordClassName"
FROM "Gallery_Live"
WHERE ("Gallery_Live"."ID" = ?)
LIMIT 1
0.0031s
0063: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "SiteTree_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" ELSE NULL END AS "FeaturedImageID", "SiteTree_Live"."ParentID", "Page_Live"."HomeSort", "Page_Live"."HomePageID", "GalleryHub_Live"."ShowSideBar", "GalleryHub_Live"."ShowImageTitles", "GalleryHub_Live"."ThumbnailWidth", "GalleryHub_Live"."ThumbnailHeight", "GalleryHub_Live"."ThumbnailResizeType", "GalleryHub_Live"."ThumbnailsPerPage", "GalleryHub_Live"."PaddedImageBackground", "GalleryPage_Live"."ImageWidth", "GalleryPage_Live"."ImageHeight", "GalleryPage_Live"."ImageResizeType", "GalleryPage_Live"."GalleryID", "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 "GalleryHub_Live" ON "GalleryHub_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "GalleryPage_Live" ON "GalleryPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("GalleryPage_Live"."GalleryID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.002s
0064: 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", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0025s
0065: SELECT DISTINCT "Gallery_Live"."ClassName", "Gallery_Live"."LastEdited", "Gallery_Live"."Created", "Gallery_Live"."Version", "Gallery_Live"."Name", "Gallery_Live"."Code", "Gallery_Live"."ID",
CASE WHEN "Gallery_Live"."ClassName" IS NOT NULL THEN "Gallery_Live"."ClassName"
ELSE 'DFT\\SilverStripe\\Gallery\\Model\\Gallery' END AS "RecordClassName"
FROM "Gallery_Live"
WHERE ("Gallery_Live"."ID" = ?)
LIMIT 1
0.0017s
0066: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "SiteTree_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" ELSE NULL END AS "FeaturedImageID", "SiteTree_Live"."ParentID", "Page_Live"."HomeSort", "Page_Live"."HomePageID", "GalleryHub_Live"."ShowSideBar", "GalleryHub_Live"."ShowImageTitles", "GalleryHub_Live"."ThumbnailWidth", "GalleryHub_Live"."ThumbnailHeight", "GalleryHub_Live"."ThumbnailResizeType", "GalleryHub_Live"."ThumbnailsPerPage", "GalleryHub_Live"."PaddedImageBackground", "GalleryPage_Live"."ImageWidth", "GalleryPage_Live"."ImageHeight", "GalleryPage_Live"."ImageResizeType", "GalleryPage_Live"."GalleryID", "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 "GalleryHub_Live" ON "GalleryHub_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "GalleryPage_Live" ON "GalleryPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("GalleryPage_Live"."GalleryID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.002s
0067: 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", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0051s
0068: SELECT DISTINCT "Gallery_Live"."ClassName", "Gallery_Live"."LastEdited", "Gallery_Live"."Created", "Gallery_Live"."Version", "Gallery_Live"."Name", "Gallery_Live"."Code", "Gallery_Live"."ID",
CASE WHEN "Gallery_Live"."ClassName" IS NOT NULL THEN "Gallery_Live"."ClassName"
ELSE 'DFT\\SilverStripe\\Gallery\\Model\\Gallery' END AS "RecordClassName"
FROM "Gallery_Live"
WHERE ("Gallery_Live"."ID" = ?)
LIMIT 1
0.005s
0069: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "SiteTree_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" ELSE NULL END AS "FeaturedImageID", "SiteTree_Live"."ParentID", "Page_Live"."HomeSort", "Page_Live"."HomePageID", "GalleryHub_Live"."ShowSideBar", "GalleryHub_Live"."ShowImageTitles", "GalleryHub_Live"."ThumbnailWidth", "GalleryHub_Live"."ThumbnailHeight", "GalleryHub_Live"."ThumbnailResizeType", "GalleryHub_Live"."ThumbnailsPerPage", "GalleryHub_Live"."PaddedImageBackground", "GalleryPage_Live"."ImageWidth", "GalleryPage_Live"."ImageHeight", "GalleryPage_Live"."ImageResizeType", "GalleryPage_Live"."GalleryID", "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 "GalleryHub_Live" ON "GalleryHub_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "GalleryPage_Live" ON "GalleryPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("GalleryPage_Live"."GalleryID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0023s
0070: 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", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0064s
0071: SELECT DISTINCT "Gallery_Live"."ClassName", "Gallery_Live"."LastEdited", "Gallery_Live"."Created", "Gallery_Live"."Version", "Gallery_Live"."Name", "Gallery_Live"."Code", "Gallery_Live"."ID",
CASE WHEN "Gallery_Live"."ClassName" IS NOT NULL THEN "Gallery_Live"."ClassName"
ELSE 'DFT\\SilverStripe\\Gallery\\Model\\Gallery' END AS "RecordClassName"
FROM "Gallery_Live"
WHERE ("Gallery_Live"."ID" = ?)
LIMIT 1
0.002s
0072: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "SiteTree_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" ELSE NULL END AS "FeaturedImageID", "SiteTree_Live"."ParentID", "Page_Live"."HomeSort", "Page_Live"."HomePageID", "GalleryHub_Live"."ShowSideBar", "GalleryHub_Live"."ShowImageTitles", "GalleryHub_Live"."ThumbnailWidth", "GalleryHub_Live"."ThumbnailHeight", "GalleryHub_Live"."ThumbnailResizeType", "GalleryHub_Live"."ThumbnailsPerPage", "GalleryHub_Live"."PaddedImageBackground", "GalleryPage_Live"."ImageWidth", "GalleryPage_Live"."ImageHeight", "GalleryPage_Live"."ImageResizeType", "GalleryPage_Live"."GalleryID", "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 "GalleryHub_Live" ON "GalleryHub_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "GalleryPage_Live" ON "GalleryPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("GalleryPage_Live"."GalleryID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0056s
0073: 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", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0023s
0074: SELECT DISTINCT "Gallery_Live"."ClassName", "Gallery_Live"."LastEdited", "Gallery_Live"."Created", "Gallery_Live"."Version", "Gallery_Live"."Name", "Gallery_Live"."Code", "Gallery_Live"."ID",
CASE WHEN "Gallery_Live"."ClassName" IS NOT NULL THEN "Gallery_Live"."ClassName"
ELSE 'DFT\\SilverStripe\\Gallery\\Model\\Gallery' END AS "RecordClassName"
FROM "Gallery_Live"
WHERE ("Gallery_Live"."ID" = ?)
LIMIT 1
0.0016s
0075: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "SiteTree_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" ELSE NULL END AS "FeaturedImageID", "SiteTree_Live"."ParentID", "Page_Live"."HomeSort", "Page_Live"."HomePageID", "GalleryHub_Live"."ShowSideBar", "GalleryHub_Live"."ShowImageTitles", "GalleryHub_Live"."ThumbnailWidth", "GalleryHub_Live"."ThumbnailHeight", "GalleryHub_Live"."ThumbnailResizeType", "GalleryHub_Live"."ThumbnailsPerPage", "GalleryHub_Live"."PaddedImageBackground", "GalleryPage_Live"."ImageWidth", "GalleryPage_Live"."ImageHeight", "GalleryPage_Live"."ImageResizeType", "GalleryPage_Live"."GalleryID", "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 "GalleryHub_Live" ON "GalleryHub_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "GalleryPage_Live" ON "GalleryPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("GalleryPage_Live"."GalleryID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0029s
0076: 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", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0072s
0077: SELECT DISTINCT "Gallery_Live"."ClassName", "Gallery_Live"."LastEdited", "Gallery_Live"."Created", "Gallery_Live"."Version", "Gallery_Live"."Name", "Gallery_Live"."Code", "Gallery_Live"."ID",
CASE WHEN "Gallery_Live"."ClassName" IS NOT NULL THEN "Gallery_Live"."ClassName"
ELSE 'DFT\\SilverStripe\\Gallery\\Model\\Gallery' END AS "RecordClassName"
FROM "Gallery_Live"
WHERE ("Gallery_Live"."ID" = ?)
LIMIT 1
0.0009s
0078: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "SiteTree_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" ELSE NULL END AS "FeaturedImageID", "SiteTree_Live"."ParentID", "Page_Live"."HomeSort", "Page_Live"."HomePageID", "GalleryHub_Live"."ShowSideBar", "GalleryHub_Live"."ShowImageTitles", "GalleryHub_Live"."ThumbnailWidth", "GalleryHub_Live"."ThumbnailHeight", "GalleryHub_Live"."ThumbnailResizeType", "GalleryHub_Live"."ThumbnailsPerPage", "GalleryHub_Live"."PaddedImageBackground", "GalleryPage_Live"."ImageWidth", "GalleryPage_Live"."ImageHeight", "GalleryPage_Live"."ImageResizeType", "GalleryPage_Live"."GalleryID", "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 "GalleryHub_Live" ON "GalleryHub_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "GalleryPage_Live" ON "GalleryPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("GalleryPage_Live"."GalleryID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0016s
0079: SELECT DISTINCT count(DISTINCT "File_Live"."ID") AS "Count"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN (SELECT DISTINCT "GalleryImage_Live"."ClassName", "GalleryImage_Live"."LastEdited", "GalleryImage_Live"."Created", "GalleryImage_Live"."Version", "GalleryImage_Live"."SortOrder", "GalleryImage_Live"."ImageID", "GalleryImage_Live"."GalleryID", "GalleryImage_Live"."ID",
CASE WHEN "GalleryImage_Live"."ClassName" IS NOT NULL THEN "GalleryImage_Live"."ClassName"
ELSE 'DFT\\SilverStripe\\Gallery\\Model\\GalleryImage' END AS "RecordClassName"
FROM "GalleryImage_Live"
WHERE ("GalleryImage_Live"."GalleryID" = ?)
ORDER BY "GalleryImage_Live"."SortOrder" ASC) AS "GalleryImage" ON "GalleryImage"."ImageID" = "File_Live"."ID"
WHERE ("File_Live"."ClassName" IN (?))
0.0018s
0080: SELECT DISTINCT "GalleryImage"."ClassName" AS "GalleryImage_ClassName", "GalleryImage"."LastEdited" AS "GalleryImage_LastEdited", "GalleryImage"."Created" AS "GalleryImage_Created", "GalleryImage"."Version" AS "GalleryImage_Version", "GalleryImage"."SortOrder" AS "GalleryImage_SortOrder", "GalleryImage"."ImageID" AS "GalleryImage_ImageID", "GalleryImage"."GalleryID" AS "GalleryImage_GalleryID", "GalleryImage"."ID" AS "GalleryImage_ID", "GalleryImage"."RecordClassName" AS "GalleryImage_RecordClassName", "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", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName", "SortOrder"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN (SELECT DISTINCT "GalleryImage_Live"."ClassName", "GalleryImage_Live"."LastEdited", "GalleryImage_Live"."Created", "GalleryImage_Live"."Version", "GalleryImage_Live"."SortOrder", "GalleryImage_Live"."ImageID", "GalleryImage_Live"."GalleryID", "GalleryImage_Live"."ID",
CASE WHEN "GalleryImage_Live"."ClassName" IS NOT NULL THEN "GalleryImage_Live"."ClassName"
ELSE 'DFT\\SilverStripe\\Gallery\\Model\\GalleryImage' END AS "RecordClassName"
FROM "GalleryImage_Live"
WHERE ("GalleryImage_Live"."GalleryID" = ?)
ORDER BY "GalleryImage_Live"."SortOrder" ASC) AS "GalleryImage" ON "GalleryImage"."ImageID" = "File_Live"."ID"
WHERE ("File_Live"."ClassName" IN (?))
ORDER BY "SortOrder" ASC
LIMIT 18
0.002s
0081: SELECT DISTINCT "GalleryImage"."ClassName" AS "GalleryImage_ClassName", "GalleryImage"."LastEdited" AS "GalleryImage_LastEdited", "GalleryImage"."Created" AS "GalleryImage_Created", "GalleryImage"."Version" AS "GalleryImage_Version", "GalleryImage"."SortOrder" AS "GalleryImage_SortOrder", "GalleryImage"."ImageID" AS "GalleryImage_ImageID", "GalleryImage"."GalleryID" AS "GalleryImage_GalleryID", "GalleryImage"."ID" AS "GalleryImage_ID", "GalleryImage"."RecordClassName" AS "GalleryImage_RecordClassName", "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", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName", "SortOrder"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN (SELECT DISTINCT "GalleryImage_Live"."ClassName", "GalleryImage_Live"."LastEdited", "GalleryImage_Live"."Created", "GalleryImage_Live"."Version", "GalleryImage_Live"."SortOrder", "GalleryImage_Live"."ImageID", "GalleryImage_Live"."GalleryID", "GalleryImage_Live"."ID",
CASE WHEN "GalleryImage_Live"."ClassName" IS NOT NULL THEN "GalleryImage_Live"."ClassName"
ELSE 'DFT\\SilverStripe\\Gallery\\Model\\GalleryImage' END AS "RecordClassName"
FROM "GalleryImage_Live"
WHERE ("GalleryImage_Live"."GalleryID" = ?)
ORDER BY "GalleryImage_Live"."SortOrder" ASC) AS "GalleryImage" ON "GalleryImage"."ImageID" = "File_Live"."ID"
WHERE ("File_Live"."ClassName" IN (?))
ORDER BY "SortOrder" ASC
LIMIT 18
0.0043s
0082: 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", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0025s
0083: SELECT DISTINCT "Gallery_Live"."ClassName", "Gallery_Live"."LastEdited", "Gallery_Live"."Created", "Gallery_Live"."Version", "Gallery_Live"."Name", "Gallery_Live"."Code", "Gallery_Live"."ID",
CASE WHEN "Gallery_Live"."ClassName" IS NOT NULL THEN "Gallery_Live"."ClassName"
ELSE 'DFT\\SilverStripe\\Gallery\\Model\\Gallery' END AS "RecordClassName"
FROM "Gallery_Live"
WHERE ("Gallery_Live"."ID" = ?)
LIMIT 1
0.0008s
0084: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "SiteTree_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" ELSE NULL END AS "FeaturedImageID", "SiteTree_Live"."ParentID", "Page_Live"."HomeSort", "Page_Live"."HomePageID", "GalleryHub_Live"."ShowSideBar", "GalleryHub_Live"."ShowImageTitles", "GalleryHub_Live"."ThumbnailWidth", "GalleryHub_Live"."ThumbnailHeight", "GalleryHub_Live"."ThumbnailResizeType", "GalleryHub_Live"."ThumbnailsPerPage", "GalleryHub_Live"."PaddedImageBackground", "GalleryPage_Live"."ImageWidth", "GalleryPage_Live"."ImageHeight", "GalleryPage_Live"."ImageResizeType", "GalleryPage_Live"."GalleryID", "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 "GalleryHub_Live" ON "GalleryHub_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "GalleryPage_Live" ON "GalleryPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("GalleryPage_Live"."GalleryID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0031s
0085: 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", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0037s
0086: SELECT DISTINCT "Gallery_Live"."ClassName", "Gallery_Live"."LastEdited", "Gallery_Live"."Created", "Gallery_Live"."Version", "Gallery_Live"."Name", "Gallery_Live"."Code", "Gallery_Live"."ID",
CASE WHEN "Gallery_Live"."ClassName" IS NOT NULL THEN "Gallery_Live"."ClassName"
ELSE 'DFT\\SilverStripe\\Gallery\\Model\\Gallery' END AS "RecordClassName"
FROM "Gallery_Live"
WHERE ("Gallery_Live"."ID" = ?)
LIMIT 1
0.0008s
0087: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "SiteTree_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" ELSE NULL END AS "FeaturedImageID", "SiteTree_Live"."ParentID", "Page_Live"."HomeSort", "Page_Live"."HomePageID", "GalleryHub_Live"."ShowSideBar", "GalleryHub_Live"."ShowImageTitles", "GalleryHub_Live"."ThumbnailWidth", "GalleryHub_Live"."ThumbnailHeight", "GalleryHub_Live"."ThumbnailResizeType", "GalleryHub_Live"."ThumbnailsPerPage", "GalleryHub_Live"."PaddedImageBackground", "GalleryPage_Live"."ImageWidth", "GalleryPage_Live"."ImageHeight", "GalleryPage_Live"."ImageResizeType", "GalleryPage_Live"."GalleryID", "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 "GalleryHub_Live" ON "GalleryHub_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "GalleryPage_Live" ON "GalleryPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("GalleryPage_Live"."GalleryID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0024s
0088: 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", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0013s
0089: SELECT DISTINCT "Gallery_Live"."ClassName", "Gallery_Live"."LastEdited", "Gallery_Live"."Created", "Gallery_Live"."Version", "Gallery_Live"."Name", "Gallery_Live"."Code", "Gallery_Live"."ID",
CASE WHEN "Gallery_Live"."ClassName" IS NOT NULL THEN "Gallery_Live"."ClassName"
ELSE 'DFT\\SilverStripe\\Gallery\\Model\\Gallery' END AS "RecordClassName"
FROM "Gallery_Live"
WHERE ("Gallery_Live"."ID" = ?)
LIMIT 1
0.0065s
0090: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "SiteTree_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" ELSE NULL END AS "FeaturedImageID", "SiteTree_Live"."ParentID", "Page_Live"."HomeSort", "Page_Live"."HomePageID", "GalleryHub_Live"."ShowSideBar", "GalleryHub_Live"."ShowImageTitles", "GalleryHub_Live"."ThumbnailWidth", "GalleryHub_Live"."ThumbnailHeight", "GalleryHub_Live"."ThumbnailResizeType", "GalleryHub_Live"."ThumbnailsPerPage", "GalleryHub_Live"."PaddedImageBackground", "GalleryPage_Live"."ImageWidth", "GalleryPage_Live"."ImageHeight", "GalleryPage_Live"."ImageResizeType", "GalleryPage_Live"."GalleryID", "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 "GalleryHub_Live" ON "GalleryHub_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "GalleryPage_Live" ON "GalleryPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("GalleryPage_Live"."GalleryID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.002s
0091: 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", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0031s
0092: SELECT DISTINCT "Gallery_Live"."ClassName", "Gallery_Live"."LastEdited", "Gallery_Live"."Created", "Gallery_Live"."Version", "Gallery_Live"."Name", "Gallery_Live"."Code", "Gallery_Live"."ID",
CASE WHEN "Gallery_Live"."ClassName" IS NOT NULL THEN "Gallery_Live"."ClassName"
ELSE 'DFT\\SilverStripe\\Gallery\\Model\\Gallery' END AS "RecordClassName"
FROM "Gallery_Live"
WHERE ("Gallery_Live"."ID" = ?)
LIMIT 1
0.0027s
0093: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "SiteTree_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" ELSE NULL END AS "FeaturedImageID", "SiteTree_Live"."ParentID", "Page_Live"."HomeSort", "Page_Live"."HomePageID", "GalleryHub_Live"."ShowSideBar", "GalleryHub_Live"."ShowImageTitles", "GalleryHub_Live"."ThumbnailWidth", "GalleryHub_Live"."ThumbnailHeight", "GalleryHub_Live"."ThumbnailResizeType", "GalleryHub_Live"."ThumbnailsPerPage", "GalleryHub_Live"."PaddedImageBackground", "GalleryPage_Live"."ImageWidth", "GalleryPage_Live"."ImageHeight", "GalleryPage_Live"."ImageResizeType", "GalleryPage_Live"."GalleryID", "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 "GalleryHub_Live" ON "GalleryHub_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "GalleryPage_Live" ON "GalleryPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("GalleryPage_Live"."GalleryID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0064s
0094: 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", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0011s
0095: SELECT DISTINCT "Gallery_Live"."ClassName", "Gallery_Live"."LastEdited", "Gallery_Live"."Created", "Gallery_Live"."Version", "Gallery_Live"."Name", "Gallery_Live"."Code", "Gallery_Live"."ID",
CASE WHEN "Gallery_Live"."ClassName" IS NOT NULL THEN "Gallery_Live"."ClassName"
ELSE 'DFT\\SilverStripe\\Gallery\\Model\\Gallery' END AS "RecordClassName"
FROM "Gallery_Live"
WHERE ("Gallery_Live"."ID" = ?)
LIMIT 1
0.002s
0096: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "SiteTree_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" ELSE NULL END AS "FeaturedImageID", "SiteTree_Live"."ParentID", "Page_Live"."HomeSort", "Page_Live"."HomePageID", "GalleryHub_Live"."ShowSideBar", "GalleryHub_Live"."ShowImageTitles", "GalleryHub_Live"."ThumbnailWidth", "GalleryHub_Live"."ThumbnailHeight", "GalleryHub_Live"."ThumbnailResizeType", "GalleryHub_Live"."ThumbnailsPerPage", "GalleryHub_Live"."PaddedImageBackground", "GalleryPage_Live"."ImageWidth", "GalleryPage_Live"."ImageHeight", "GalleryPage_Live"."ImageResizeType", "GalleryPage_Live"."GalleryID", "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 "GalleryHub_Live" ON "GalleryHub_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "GalleryPage_Live" ON "GalleryPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("GalleryPage_Live"."GalleryID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0037s
0097: 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", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0057s
0098: SELECT DISTINCT "Gallery_Live"."ClassName", "Gallery_Live"."LastEdited", "Gallery_Live"."Created", "Gallery_Live"."Version", "Gallery_Live"."Name", "Gallery_Live"."Code", "Gallery_Live"."ID",
CASE WHEN "Gallery_Live"."ClassName" IS NOT NULL THEN "Gallery_Live"."ClassName"
ELSE 'DFT\\SilverStripe\\Gallery\\Model\\Gallery' END AS "RecordClassName"
FROM "Gallery_Live"
WHERE ("Gallery_Live"."ID" = ?)
LIMIT 1
0.0037s
0099: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "SiteTree_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" ELSE NULL END AS "FeaturedImageID", "SiteTree_Live"."ParentID", "Page_Live"."HomeSort", "Page_Live"."HomePageID", "GalleryHub_Live"."ShowSideBar", "GalleryHub_Live"."ShowImageTitles", "GalleryHub_Live"."ThumbnailWidth", "GalleryHub_Live"."ThumbnailHeight", "GalleryHub_Live"."ThumbnailResizeType", "GalleryHub_Live"."ThumbnailsPerPage", "GalleryHub_Live"."PaddedImageBackground", "GalleryPage_Live"."ImageWidth", "GalleryPage_Live"."ImageHeight", "GalleryPage_Live"."ImageResizeType", "GalleryPage_Live"."GalleryID", "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 "GalleryHub_Live" ON "GalleryHub_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "GalleryPage_Live" ON "GalleryPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("GalleryPage_Live"."GalleryID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0021s
0100: 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", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0017s
0101: SELECT DISTINCT "Gallery_Live"."ClassName", "Gallery_Live"."LastEdited", "Gallery_Live"."Created", "Gallery_Live"."Version", "Gallery_Live"."Name", "Gallery_Live"."Code", "Gallery_Live"."ID",
CASE WHEN "Gallery_Live"."ClassName" IS NOT NULL THEN "Gallery_Live"."ClassName"
ELSE 'DFT\\SilverStripe\\Gallery\\Model\\Gallery' END AS "RecordClassName"
FROM "Gallery_Live"
WHERE ("Gallery_Live"."ID" = ?)
LIMIT 1
0.0011s
0102: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "SiteTree_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" ELSE NULL END AS "FeaturedImageID", "SiteTree_Live"."ParentID", "Page_Live"."HomeSort", "Page_Live"."HomePageID", "GalleryHub_Live"."ShowSideBar", "GalleryHub_Live"."ShowImageTitles", "GalleryHub_Live"."ThumbnailWidth", "GalleryHub_Live"."ThumbnailHeight", "GalleryHub_Live"."ThumbnailResizeType", "GalleryHub_Live"."ThumbnailsPerPage", "GalleryHub_Live"."PaddedImageBackground", "GalleryPage_Live"."ImageWidth", "GalleryPage_Live"."ImageHeight", "GalleryPage_Live"."ImageResizeType", "GalleryPage_Live"."GalleryID", "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 "GalleryHub_Live" ON "GalleryHub_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "GalleryPage_Live" ON "GalleryPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("GalleryPage_Live"."GalleryID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0021s
0103: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0023s
0104: SELECT DISTINCT "Gallery_Live"."ClassName", "Gallery_Live"."LastEdited", "Gallery_Live"."Created", "Gallery_Live"."Version", "Gallery_Live"."Name", "Gallery_Live"."Code", "Gallery_Live"."ID",
CASE WHEN "Gallery_Live"."ClassName" IS NOT NULL THEN "Gallery_Live"."ClassName"
ELSE 'DFT\\SilverStripe\\Gallery\\Model\\Gallery' END AS "RecordClassName"
FROM "Gallery_Live"
WHERE ("Gallery_Live"."ID" = ?)
LIMIT 1
0.0008s
0105: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "SiteTree_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" ELSE NULL END AS "FeaturedImageID", "SiteTree_Live"."ParentID", "Page_Live"."HomeSort", "Page_Live"."HomePageID", "GalleryHub_Live"."ShowSideBar", "GalleryHub_Live"."ShowImageTitles", "GalleryHub_Live"."ThumbnailWidth", "GalleryHub_Live"."ThumbnailHeight", "GalleryHub_Live"."ThumbnailResizeType", "GalleryHub_Live"."ThumbnailsPerPage", "GalleryHub_Live"."PaddedImageBackground", "GalleryPage_Live"."ImageWidth", "GalleryPage_Live"."ImageHeight", "GalleryPage_Live"."ImageResizeType", "GalleryPage_Live"."GalleryID", "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 "GalleryHub_Live" ON "GalleryHub_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "GalleryPage_Live" ON "GalleryPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("GalleryPage_Live"."GalleryID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0017s
0106: 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", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0012s
0107: SELECT DISTINCT "Gallery_Live"."ClassName", "Gallery_Live"."LastEdited", "Gallery_Live"."Created", "Gallery_Live"."Version", "Gallery_Live"."Name", "Gallery_Live"."Code", "Gallery_Live"."ID",
CASE WHEN "Gallery_Live"."ClassName" IS NOT NULL THEN "Gallery_Live"."ClassName"
ELSE 'DFT\\SilverStripe\\Gallery\\Model\\Gallery' END AS "RecordClassName"
FROM "Gallery_Live"
WHERE ("Gallery_Live"."ID" = ?)
LIMIT 1
0.0008s
0108: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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", CASE WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\CMS\\Model\\SiteTree', 'Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "SiteTree_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('Page', 'HomePage', 'DFT\\SilverStripe\\ChildHubPage\\ChildHubPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryHub', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'DFT\\SilverStripe\\Gallery\\Model\\GalleryPage', 'ContactPage') THEN "Page_Live"."FeaturedImageID" ELSE NULL END AS "FeaturedImageID", "SiteTree_Live"."ParentID", "Page_Live"."HomeSort", "Page_Live"."HomePageID", "GalleryHub_Live"."ShowSideBar", "GalleryHub_Live"."ShowImageTitles", "GalleryHub_Live"."ThumbnailWidth", "GalleryHub_Live"."ThumbnailHeight", "GalleryHub_Live"."ThumbnailResizeType", "GalleryHub_Live"."ThumbnailsPerPage", "GalleryHub_Live"."PaddedImageBackground", "GalleryPage_Live"."ImageWidth", "GalleryPage_Live"."ImageHeight", "GalleryPage_Live"."ImageResizeType", "GalleryPage_Live"."GalleryID", "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 "GalleryHub_Live" ON "GalleryHub_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "GalleryPage_Live" ON "GalleryPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("GalleryPage_Live"."GalleryID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0018s
0109: 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 'DFT\\SilverStripe\\CustomMenus\\Model\\CustomMenuHolder' END AS "RecordClassName"
FROM "CustomMenuHolder"
WHERE ("CustomMenuHolder"."SiteID" = ?)
AND ("CustomMenuHolder"."Slug" = ?)
LIMIT 1
0.0011s
0110: SELECT CASE WHEN EXISTS(SELECT *
FROM "CustomMenuLink"
WHERE ("CustomMenuLink"."MenuID" = ?)) THEN 1 ELSE 0 END
0.0008s
0111: 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 'DFT\\SilverStripe\\CustomMenus\\Model\\CustomMenuLink' END AS "RecordClassName"
FROM "CustomMenuLink"
WHERE ("CustomMenuLink"."MenuID" = ?)
ORDER BY "CustomMenuLink"."SortOrder" ASC
0.001s
0112: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."FeaturedImageID", "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
0113: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."FeaturedImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0008s
0114: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."FeaturedImageID", "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
0115: SELECT DISTINCT "CatalogueCategory_Live"."ClassName", "CatalogueCategory_Live"."LastEdited", "CatalogueCategory_Live"."Created", "CatalogueCategory_Live"."Version", "CatalogueCategory_Live"."URLSegment", "CatalogueCategory_Live"."MetaDescription", "CatalogueCategory_Live"."ExtraMeta", "CatalogueCategory_Live"."Title", "CatalogueCategory_Live"."Content", "CatalogueCategory_Live"."Sort", "CatalogueCategory_Live"."Disabled", "CatalogueCategory_Live"."ImageID", "CatalogueCategory_Live"."ParentID", "CatalogueCategory_Live"."ID",
CASE WHEN "CatalogueCategory_Live"."ClassName" IS NOT NULL THEN "CatalogueCategory_Live"."ClassName"
ELSE 'SilverCommerce\\CatalogueAdmin\\Model\\CatalogueCategory' END AS "RecordClassName"
FROM "CatalogueCategory_Live"
WHERE ("CatalogueCategory_Live"."ParentID" = ?)
AND ("CatalogueCategory_Live"."Disabled" = ?)
ORDER BY "CatalogueCategory_Live"."Sort" ASC
0.0014s
0116: SELECT DISTINCT "SocialNavLink"."ClassName", "SocialNavLink"."LastEdited", "SocialNavLink"."Created", "SocialNavLink"."Service", "SocialNavLink"."URL", "SocialNavLink"."ExtraClasses", "SocialNavLink"."ParentID", "SocialNavLink"."ID",
CASE WHEN "SocialNavLink"."ClassName" IS NOT NULL THEN "SocialNavLink"."ClassName"
ELSE 'DFT\\SilverStripe\\SocialNav\\Model\\SocialNavLink' END AS "RecordClassName"
FROM "SocialNavLink"
WHERE ("SocialNavLink"."ParentID" = ?)
0.0015s
0117: 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", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0013s
0118: SELECT "Version" FROM "SiteTree" WHERE "ID" = ?
0.0014s
0119: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."FeaturedImageID", "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
0120: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."FeaturedImageID", "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
0121: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."FeaturedImageID", "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
0122: SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", "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"."FeaturedImageID", "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.001s
0123: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."FeaturedImageID", "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
0124: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."FeaturedImageID", "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
Wildlife galleries » UK Nature Gifts
Wildlife galleries
Wildlife galleries
Welcome to my wildlife galleries. Choose from bees and bumblebees, birds, butterflies, mammals and mini-beasts. Browse the galleries to create your own bespoke dining order
