0004: SHOW COLLATION LIKE 'utf8mb4_unicode_ci'
0.0004s
0005: SHOW FULL FIELDS IN "Page"
0.0007s
0006: SHOW FULL FIELDS IN "JoinNowHub"
0.0006s
0007: SHOW FULL FIELDS IN "OnlineForm"
0.0004s
0008: SHOW FULL FIELDS IN "OnlineFormManager"
0.0003s
0009: SHOW FULL FIELDS IN "BlogPost"
0.0004s
0010: SHOW FULL FIELDS IN "EmbedPage"
0.0004s
0011: SHOW FULL FIELDS IN "FundPage"
0.0004s
0012: SHOW FULL FIELDS IN "KiwisaverLoginPage"
0.0003s
0013: SHOW FULL FIELDS IN "LandingPage"
0.0004s
0014: SHOW FULL FIELDS IN "PartnersPage"
0.0003s
0015: SHOW FULL FIELDS IN "StaffPage"
0.0003s
0016: SHOW FULL FIELDS IN "ErrorPage"
0.0003s
0017: SHOW FULL FIELDS IN "RedirectorPage"
0.0003s
0018: SHOW FULL FIELDS IN "VirtualPage"
0.0003s
0019: SHOW FULL FIELDS IN "UserDefinedForm"
0.0004s
0020: SHOW FULL FIELDS IN "ChangeProfileForm"
0.0004s
0021: SHOW FULL FIELDS IN "KiwisaverApplicationForm"
0.0005s
0022: SHOW FULL FIELDS IN "KiwisaverWithdrawalForm"
0.0004s
0023: SHOW FULL FIELDS IN "MediaCentreArticle"
0.0004s
0024: SHOW FULL FIELDS IN "KiwisaverFormRedirectorPage"
0.0003s
0025: SHOW FULL FIELDS IN "ContactPage"
0.0008s
0026: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Fallback", "SiteTree_Live"."FallbackLink", "SiteTree_Live"."FallbackResponseCode", "SiteTree_Live"."SEOPageSchema", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "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"."VanityMappingID", "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.0004s
0027: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Fallback", "SiteTree_Live"."FallbackLink", "SiteTree_Live"."FallbackResponseCode", "SiteTree_Live"."SEOPageSchema", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "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"."VanityMappingID", "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.0004s
0028: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Fallback", "SiteTree_Live"."FallbackLink", "SiteTree_Live"."FallbackResponseCode", "SiteTree_Live"."SEOPageSchema", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "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"."VanityMappingID", "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.0003s
0029: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", "SiteConfig"."OGSiteName", "SiteConfig"."TwitterHandle", "SiteConfig"."CreatorTwitterHandle", "SiteConfig"."FacebookAppID", "SiteConfig"."UseTitleAsMetaTitle", "SiteConfig"."SchemaOrganisationName", "SiteConfig"."Address", "SiteConfig"."Suburb", "SiteConfig"."State", "SiteConfig"."Postcode", "SiteConfig"."Country", "SiteConfig"."Lat", "SiteConfig"."Lng", "SiteConfig"."Phone", "SiteConfig"."Fallback", "SiteConfig"."FallbackLink", "SiteConfig"."FallbackResponseCode", "SiteConfig"."CookieIsActive", "SiteConfig"."MustConsent", "SiteConfig"."ConsentNoticeTitle", "SiteConfig"."ConsentNoticeDescription", "SiteConfig"."ConsentNoticeOK", "SiteConfig"."ConsentModalTitle", "SiteConfig"."ConsentNoticeLearnMore", "SiteConfig"."ConsentModalDescription", "SiteConfig"."ConsentModalPrivacyPolicyName", "SiteConfig"."ConsentModalPrivacyPolicyText", "SiteConfig"."AcceptAll", "SiteConfig"."AcceptSelected", "SiteConfig"."Decline", "SiteConfig"."HideDeclineAll", "SiteConfig"."ContextualConsentAcceptAlways", "SiteConfig"."ContextualConsentAcceptOnce", "SiteConfig"."ContextualConsentDescription", "SiteConfig"."FooterPhoneText", "SiteConfig"."FooterPhone", "SiteConfig"."FooterOfficeHours", "SiteConfig"."FooterContent", "SiteConfig"."FundPricingImporter_ManualRun", "SiteConfig"."CriticalNotice_Title", "SiteConfig"."CriticalNotice_Content", "SiteConfig"."CriticalNotice_Enabled", "SiteConfig"."EmailRecipients", "SiteConfig"."Title", "SiteConfig"."Tagline", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."SchemaOrganisationImageID", "SiteConfig"."DefaultSocialImageID", "SiteConfig"."CookieLinkPrivacyID", "SiteConfig"."FundPricingImporter_ManualFileID", "SiteConfig"."ID",
CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName"
ELSE 'SilverStripe\\SiteConfig\\SiteConfig' END AS "RecordClassName"
FROM "SiteConfig"
LIMIT 1
0.0003s
0030: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Fallback", "SiteTree_Live"."FallbackLink", "SiteTree_Live"."FallbackResponseCode", "SiteTree_Live"."SEOPageSchema", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "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"."VanityMappingID", "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.0003s
0031: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Fallback", "SiteTree_Live"."FallbackLink", "SiteTree_Live"."FallbackResponseCode", "SiteTree_Live"."SEOPageSchema", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "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"."VanityMappingID", "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.0003s
0032: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."MetaTitle", "Page_Live"."MetaTitleLastEdited", "Page_Live"."MetaDescriptionLastEdited", "Page_Live"."Canonical", "Page_Live"."Robots", "Page_Live"."ManualSchema", "Page_Live"."Priority", "Page_Live"."ChangeFrequency", "Page_Live"."SitemapHide", "Page_Live"."XMLSitemapHide", "Page_Live"."HideSocial", "Page_Live"."OGtype", "Page_Live"."OGlocale", "Page_Live"."TwitterCard", "Page_Live"."PageViewCount", "Page_Live"."HideSubMenu", "Page_Live"."IncludeHotjarTracking", "Page_Live"."SocialImageID", "Page_Live"."ElementalAreaID", "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"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0004s
0033: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", "SiteConfig"."OGSiteName", "SiteConfig"."TwitterHandle", "SiteConfig"."CreatorTwitterHandle", "SiteConfig"."FacebookAppID", "SiteConfig"."UseTitleAsMetaTitle", "SiteConfig"."SchemaOrganisationName", "SiteConfig"."Address", "SiteConfig"."Suburb", "SiteConfig"."State", "SiteConfig"."Postcode", "SiteConfig"."Country", "SiteConfig"."Lat", "SiteConfig"."Lng", "SiteConfig"."Phone", "SiteConfig"."Fallback", "SiteConfig"."FallbackLink", "SiteConfig"."FallbackResponseCode", "SiteConfig"."CookieIsActive", "SiteConfig"."MustConsent", "SiteConfig"."ConsentNoticeTitle", "SiteConfig"."ConsentNoticeDescription", "SiteConfig"."ConsentNoticeOK", "SiteConfig"."ConsentModalTitle", "SiteConfig"."ConsentNoticeLearnMore", "SiteConfig"."ConsentModalDescription", "SiteConfig"."ConsentModalPrivacyPolicyName", "SiteConfig"."ConsentModalPrivacyPolicyText", "SiteConfig"."AcceptAll", "SiteConfig"."AcceptSelected", "SiteConfig"."Decline", "SiteConfig"."HideDeclineAll", "SiteConfig"."ContextualConsentAcceptAlways", "SiteConfig"."ContextualConsentAcceptOnce", "SiteConfig"."ContextualConsentDescription", "SiteConfig"."FooterPhoneText", "SiteConfig"."FooterPhone", "SiteConfig"."FooterOfficeHours", "SiteConfig"."FooterContent", "SiteConfig"."FundPricingImporter_ManualRun", "SiteConfig"."CriticalNotice_Title", "SiteConfig"."CriticalNotice_Content", "SiteConfig"."CriticalNotice_Enabled", "SiteConfig"."EmailRecipients", "SiteConfig"."Title", "SiteConfig"."Tagline", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."SchemaOrganisationImageID", "SiteConfig"."DefaultSocialImageID", "SiteConfig"."CookieLinkPrivacyID", "SiteConfig"."FundPricingImporter_ManualFileID", "SiteConfig"."ID",
CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName"
ELSE 'SilverStripe\\SiteConfig\\SiteConfig' END AS "RecordClassName"
FROM "SiteConfig"
LIMIT 1
0.0003s
0034: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."Description", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."IsFolder", "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.0003s
0035: SELECT DISTINCT "SeoHeadTag"."ClassName", "SeoHeadTag"."LastEdited", "SeoHeadTag"."Created", "SeoHeadTag"."Title", "SeoHeadTag"."Value", "SeoHeadTag"."Type", "SeoHeadTag"."PageID", "SeoHeadTag"."PageClass", "SeoHeadTag"."ID",
CASE WHEN "SeoHeadTag"."ClassName" IS NOT NULL THEN "SeoHeadTag"."ClassName"
ELSE 'PlasticStudio\\SEO\\Model\\SeoHeadTag' END AS "RecordClassName"
FROM "SeoHeadTag" INNER JOIN "Page_HeadTags" ON "Page_HeadTags"."SeoHeadTagID" = "SeoHeadTag"."ID"
WHERE ("Page_HeadTags"."PageID" = ?)
AND ("SeoHeadTag"."Type" = ?)
ORDER BY "SeoHeadTag"."Title" ASC
0.0004s
0036: SELECT DISTINCT count(DISTINCT "SeoHeadTag"."ID") AS "Count"
FROM "SeoHeadTag" INNER JOIN "Page_HeadTags" ON "Page_HeadTags"."SeoHeadTagID" = "SeoHeadTag"."ID"
WHERE ("Page_HeadTags"."PageID" = ?)
AND ("SeoHeadTag"."Type" = ?)
0.0002s
0037: SELECT DISTINCT "SeoHeadTag"."ClassName", "SeoHeadTag"."LastEdited", "SeoHeadTag"."Created", "SeoHeadTag"."Title", "SeoHeadTag"."Value", "SeoHeadTag"."Type", "SeoHeadTag"."PageID", "SeoHeadTag"."PageClass", "SeoHeadTag"."ID",
CASE WHEN "SeoHeadTag"."ClassName" IS NOT NULL THEN "SeoHeadTag"."ClassName"
ELSE 'PlasticStudio\\SEO\\Model\\SeoHeadTag' END AS "RecordClassName"
FROM "SeoHeadTag" INNER JOIN "Page_HeadTags" ON "Page_HeadTags"."SeoHeadTagID" = "SeoHeadTag"."ID"
WHERE ("Page_HeadTags"."PageID" = ?)
AND ("SeoHeadTag"."Type" = ?)
ORDER BY "SeoHeadTag"."Title" ASC
0.0003s
0038: SELECT DISTINCT count(DISTINCT "SeoHeadTag"."ID") AS "Count"
FROM "SeoHeadTag" INNER JOIN "Page_HeadTags" ON "Page_HeadTags"."SeoHeadTagID" = "SeoHeadTag"."ID"
WHERE ("Page_HeadTags"."PageID" = ?)
AND ("SeoHeadTag"."Type" = ?)
0.0002s
0039: SELECT DISTINCT "SeoHeadTag"."ClassName", "SeoHeadTag"."LastEdited", "SeoHeadTag"."Created", "SeoHeadTag"."Title", "SeoHeadTag"."Value", "SeoHeadTag"."Type", "SeoHeadTag"."PageID", "SeoHeadTag"."PageClass", "SeoHeadTag"."ID",
CASE WHEN "SeoHeadTag"."ClassName" IS NOT NULL THEN "SeoHeadTag"."ClassName"
ELSE 'PlasticStudio\\SEO\\Model\\SeoHeadTag' END AS "RecordClassName"
FROM "SeoHeadTag" INNER JOIN "Page_HeadTags" ON "Page_HeadTags"."SeoHeadTagID" = "SeoHeadTag"."ID"
WHERE ("Page_HeadTags"."PageID" = ?)
AND ("SeoHeadTag"."Type" = ?)
ORDER BY "SeoHeadTag"."Title" ASC
0.0003s
0040: SELECT DISTINCT count(DISTINCT "SeoHeadTag"."ID") AS "Count"
FROM "SeoHeadTag" INNER JOIN "Page_HeadTags" ON "Page_HeadTags"."SeoHeadTagID" = "SeoHeadTag"."ID"
WHERE ("Page_HeadTags"."PageID" = ?)
AND ("SeoHeadTag"."Type" = ?)
0.0002s
0041: SELECT 1 AS "1"
WHERE (EXISTS (SELECT *
FROM "Link" INNER JOIN "SiteConfig_MobileHeaderButtons" ON "SiteConfig_MobileHeaderButtons"."LinkID" = "Link"."ID"
WHERE ("SiteConfig_MobileHeaderButtons"."SiteConfigID" = ?)))
0.0003s
0042: SELECT DISTINCT "SiteConfig_MobileHeaderButtons"."Sort", "Link"."ClassName", "Link"."LastEdited", "Link"."Created", "Link"."Anchor", "Link"."ButtonColour", "Link"."ButtonStyle", "Link"."ButtonIcon", "Link"."ExtraClasses", "Link"."Title", "Link"."Type", "Link"."URL", "Link"."Email", "Link"."Phone", "Link"."OpenInNewWindow", "Link"."SelectedStyle", "Link"."SiteTreeID", "Link"."BlogCategoryID", "Link"."FileID", "Link"."ID",
CASE WHEN "Link"."ClassName" IS NOT NULL THEN "Link"."ClassName"
ELSE 'gorriecoe\\Link\\Models\\Link' END AS "RecordClassName"
FROM "Link" INNER JOIN "SiteConfig_MobileHeaderButtons" ON "SiteConfig_MobileHeaderButtons"."LinkID" = "Link"."ID"
WHERE ("SiteConfig_MobileHeaderButtons"."SiteConfigID" = ?)
0.0003s
0043: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited")
FROM "SiteTree_Live"
0.0002s
0044: SELECT DISTINCT count("SiteTree_Live"."ID") AS "Count"
FROM "SiteTree_Live"
0.0003s
0045: SELECT DISTINCT MAX("Link"."LastEdited")
FROM "Link" INNER JOIN "SiteConfig_HeadLinks" ON "SiteConfig_HeadLinks"."LinkID" = "Link"."ID"
WHERE ("SiteConfig_HeadLinks"."SiteConfigID" = ?)
0.0002s
0046: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" INNER JOIN "SiteConfig_HeadLinks" ON "SiteConfig_HeadLinks"."LinkID" = "Link"."ID"
WHERE ("SiteConfig_HeadLinks"."SiteConfigID" = ?)
0.0002s
0047: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Fallback", "SiteTree_Live"."FallbackLink", "SiteTree_Live"."FallbackResponseCode", "SiteTree_Live"."SEOPageSchema", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "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"."VanityMappingID", "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.0003s
0048: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Fallback", "SiteTree_Live"."FallbackLink", "SiteTree_Live"."FallbackResponseCode", "SiteTree_Live"."SEOPageSchema", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "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"."VanityMappingID", "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.0002s
0049: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Fallback", "SiteTree_Live"."FallbackLink", "SiteTree_Live"."FallbackResponseCode", "SiteTree_Live"."SEOPageSchema", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "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"."VanityMappingID", "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.0002s
0050: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Fallback", "SiteTree_Live"."FallbackLink", "SiteTree_Live"."FallbackResponseCode", "SiteTree_Live"."SEOPageSchema", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "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"."VanityMappingID", "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.0003s
0051: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Fallback", "SiteTree_Live"."FallbackLink", "SiteTree_Live"."FallbackResponseCode", "SiteTree_Live"."SEOPageSchema", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "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"."VanityMappingID", "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.0002s
0052: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0002s
0053: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "Element_Live"."AvailableGlobally", "Element_Live"."VirtualLookupTitle", "Element_Live"."BackgroundColour", "Element_Live"."Version", "Element_Live"."Title", "Element_Live"."ShowTitle", "Element_Live"."Sort", "Element_Live"."ExtraClass", "Element_Live"."Style", "Element_Live"."TopPageID", "Element_Live"."ParentID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName"
FROM "Element_Live"
WHERE ("Element_Live"."ParentID" = ?)
ORDER BY "Element_Live"."Sort" ASC
0.0003s
0054: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0001s
0055: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Fallback", "SiteTree_Live"."FallbackLink", "SiteTree_Live"."FallbackResponseCode", "SiteTree_Live"."SEOPageSchema", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "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"."VanityMappingID", "SiteTree_Live"."ParentID", "Page_Live"."MetaTitle", "Page_Live"."MetaTitleLastEdited", "Page_Live"."MetaDescriptionLastEdited", "Page_Live"."Canonical", "Page_Live"."Robots", "Page_Live"."ManualSchema", "Page_Live"."Priority", "Page_Live"."ChangeFrequency", "Page_Live"."SitemapHide", "Page_Live"."XMLSitemapHide", "Page_Live"."HideSocial", "Page_Live"."OGtype", "Page_Live"."OGlocale", "Page_Live"."TwitterCard", "Page_Live"."PageViewCount", "Page_Live"."HideSubMenu", "Page_Live"."IncludeHotjarTracking", "Page_Live"."SocialImageID", "Page_Live"."ElementalAreaID", "BlogPost_Live"."PublishDate", "BlogPost_Live"."FeatureImageID", "BlogPost_Live"."CategoryID", "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 "BlogPost_Live" ON "BlogPost_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("Page_Live"."ElementalAreaID" = ?)
AND ("SiteTree_Live"."ClassName" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0005s
0056: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Fallback", "SiteTree_Live"."FallbackLink", "SiteTree_Live"."FallbackResponseCode", "SiteTree_Live"."SEOPageSchema", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "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"."VanityMappingID", "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.0002s
0057: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Fallback", "SiteTree_Live"."FallbackLink", "SiteTree_Live"."FallbackResponseCode", "SiteTree_Live"."SEOPageSchema", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "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"."VanityMappingID", "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.0002s
0058: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0003s
0059: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "BannerElement_Live"."Content", "BannerElement_Live"."BannerLinkText", "BannerElement_Live"."BannerLinkIcon", "BannerElement_Live"."ColumnIconBackground", "BannerElement_Live"."ImageID", "BannerElement_Live"."AnimationFileID", "BannerElement_Live"."BannerLinkID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "BannerElement_Live" ON "BannerElement_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0003s
0060: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0002s
0061: SELECT 1 AS "1"
WHERE (EXISTS (SELECT *
FROM "Member" INNER JOIN "BlogPost_Authors" ON "BlogPost_Authors"."MemberID" = "Member"."ID"
WHERE ("BlogPost_Authors"."BlogPostID" = ?)))
0.0002s
0062: SELECT 1 AS "1"
WHERE (EXISTS (SELECT *
FROM "Link" INNER JOIN "BannerElement_Buttons" ON "BannerElement_Buttons"."LinkID" = "Link"."ID"
WHERE ("BannerElement_Buttons"."BannerElementID" = ?)))
0.0002s
0063: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementContent_Live"."BlockWidth", "ElementContent_Live"."HTML", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementContent_Live" ON "ElementContent_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0003s
0064: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementContent_Live"."BlockWidth", "ElementContent_Live"."HTML", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementContent_Live" ON "ElementContent_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0004s
0065: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementContent_Live"."BlockWidth", "ElementContent_Live"."HTML", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementContent_Live" ON "ElementContent_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0003s
0066: SELECT 1 AS "1"
WHERE (EXISTS (SELECT *
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "BlogPost_Live" ON "BlogPost_Live"."ID" = "SiteTree_Live"."ID" INNER JOIN "BlogPost_RelatedArticles" ON "BlogPost_RelatedArticles"."ChildID" = "SiteTree_Live"."ID"
WHERE ("BlogPost_RelatedArticles"."BlogPostID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))))
0.0004s
0067: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Fallback", "SiteTree_Live"."FallbackLink", "SiteTree_Live"."FallbackResponseCode", "SiteTree_Live"."SEOPageSchema", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "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"."VanityMappingID", "SiteTree_Live"."ParentID", "Page_Live"."MetaTitle", "Page_Live"."MetaTitleLastEdited", "Page_Live"."MetaDescriptionLastEdited", "Page_Live"."Canonical", "Page_Live"."Robots", "Page_Live"."ManualSchema", "Page_Live"."Priority", "Page_Live"."ChangeFrequency", "Page_Live"."SitemapHide", "Page_Live"."XMLSitemapHide", "Page_Live"."HideSocial", "Page_Live"."OGtype", "Page_Live"."OGlocale", "Page_Live"."TwitterCard", "Page_Live"."PageViewCount", "Page_Live"."HideSubMenu", "Page_Live"."IncludeHotjarTracking", "Page_Live"."SocialImageID", "Page_Live"."ElementalAreaID", "BlogPost_Live"."PublishDate", "BlogPost_Live"."FeatureImageID", "BlogPost_Live"."CategoryID", "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 "BlogPost_Live" ON "BlogPost_Live"."ID" = "SiteTree_Live"."ID" INNER JOIN "BlogPost_RelatedArticles" ON "BlogPost_RelatedArticles"."ChildID" = "SiteTree_Live"."ID"
WHERE ("BlogPost_RelatedArticles"."BlogPostID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 4
0.0005s
0068: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Fallback", "SiteTree_Live"."FallbackLink", "SiteTree_Live"."FallbackResponseCode", "SiteTree_Live"."SEOPageSchema", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "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"."VanityMappingID", "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.0003s
0069: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Fallback", "SiteTree_Live"."FallbackLink", "SiteTree_Live"."FallbackResponseCode", "SiteTree_Live"."SEOPageSchema", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "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"."VanityMappingID", "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.0002s
0070: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."Description", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."IsFolder", "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.0002s
0071: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Fallback", "SiteTree_Live"."FallbackLink", "SiteTree_Live"."FallbackResponseCode", "SiteTree_Live"."SEOPageSchema", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "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"."VanityMappingID", "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.0003s
0072: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Fallback", "SiteTree_Live"."FallbackLink", "SiteTree_Live"."FallbackResponseCode", "SiteTree_Live"."SEOPageSchema", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "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"."VanityMappingID", "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.0002s
0073: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."Description", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."IsFolder", "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.0002s
0074: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Fallback", "SiteTree_Live"."FallbackLink", "SiteTree_Live"."FallbackResponseCode", "SiteTree_Live"."SEOPageSchema", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "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"."VanityMappingID", "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.0003s
0075: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Fallback", "SiteTree_Live"."FallbackLink", "SiteTree_Live"."FallbackResponseCode", "SiteTree_Live"."SEOPageSchema", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "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"."VanityMappingID", "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.0003s
0076: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."Description", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."IsFolder", "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.0003s
0077: SELECT 1 AS "1"
WHERE (EXISTS (SELECT *
FROM "BlogTag" INNER JOIN "BlogPost_Tags" ON "BlogPost_Tags"."BlogTagID" = "BlogTag"."ID"
WHERE ("BlogPost_Tags"."BlogPostID" = ?)))
0.0003s
0078: SELECT DISTINCT "BlogTag"."ClassName", "BlogTag"."LastEdited", "BlogTag"."Created", "BlogTag"."Title", "BlogTag"."SortID", "BlogTag"."ID",
CASE WHEN "BlogTag"."ClassName" IS NOT NULL THEN "BlogTag"."ClassName"
ELSE 'FANZ\\DataObjects\\BlogTag' END AS "RecordClassName"
FROM "BlogTag" INNER JOIN "BlogPost_Tags" ON "BlogPost_Tags"."BlogTagID" = "BlogTag"."ID"
WHERE ("BlogPost_Tags"."BlogPostID" = ?)
ORDER BY "BlogTag"."SortID" ASC
0.0003s
0079: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Fallback", "SiteTree_Live"."FallbackLink", "SiteTree_Live"."FallbackResponseCode", "SiteTree_Live"."SEOPageSchema", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "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"."VanityMappingID", "SiteTree_Live"."ParentID", "Page_Live"."MetaTitle", "Page_Live"."MetaTitleLastEdited", "Page_Live"."MetaDescriptionLastEdited", "Page_Live"."Canonical", "Page_Live"."Robots", "Page_Live"."ManualSchema", "Page_Live"."Priority", "Page_Live"."ChangeFrequency", "Page_Live"."SitemapHide", "Page_Live"."XMLSitemapHide", "Page_Live"."HideSocial", "Page_Live"."OGtype", "Page_Live"."OGlocale", "Page_Live"."TwitterCard", "Page_Live"."PageViewCount", "Page_Live"."HideSubMenu", "Page_Live"."IncludeHotjarTracking", "Page_Live"."SocialImageID", "Page_Live"."ElementalAreaID", "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"
WHERE ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0004s
0080: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Fallback", "SiteTree_Live"."FallbackLink", "SiteTree_Live"."FallbackResponseCode", "SiteTree_Live"."SEOPageSchema", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "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"."VanityMappingID", "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.0002s
0081: SELECT 1 AS "1"
WHERE (EXISTS (SELECT *
FROM "SocialChannel"
WHERE ("SocialChannel"."SiteConfigID" = ?)
AND ("SocialChannel"."ShareLink" = ?)))
0.0003s
0082: SELECT "Version" FROM "SiteTree" WHERE "ID" = ?
0.0002s
0083: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Fallback", "SiteTree_Live"."FallbackLink", "SiteTree_Live"."FallbackResponseCode", "SiteTree_Live"."SEOPageSchema", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "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"."VanityMappingID", "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.0003s
0084: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Fallback", "SiteTree_Live"."FallbackLink", "SiteTree_Live"."FallbackResponseCode", "SiteTree_Live"."SEOPageSchema", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "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"."VanityMappingID", "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.0002s
0085: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Fallback", "SiteTree_Live"."FallbackLink", "SiteTree_Live"."FallbackResponseCode", "SiteTree_Live"."SEOPageSchema", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "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"."VanityMappingID", "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.0002s
0086: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Fallback", "SiteTree_Live"."FallbackLink", "SiteTree_Live"."FallbackResponseCode", "SiteTree_Live"."SEOPageSchema", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "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"."VanityMappingID", "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.0003s
0087: SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", "SiteTree"."Fallback", "SiteTree"."FallbackLink", "SiteTree"."FallbackResponseCode", "SiteTree"."SEOPageSchema", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."Version", "SiteTree"."Title", "SiteTree"."URLSegment", "SiteTree"."MenuTitle", "SiteTree"."Content", "SiteTree"."MetaDescription", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", "SiteTree"."ReportClass", "SiteTree"."VanityMappingID", "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.0003s
0088: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Fallback", "SiteTree_Live"."FallbackLink", "SiteTree_Live"."FallbackResponseCode", "SiteTree_Live"."SEOPageSchema", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "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"."VanityMappingID", "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.0003s
0089: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Fallback", "SiteTree_Live"."FallbackLink", "SiteTree_Live"."FallbackResponseCode", "SiteTree_Live"."SEOPageSchema", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "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"."VanityMappingID", "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.0002s
0090: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Fallback", "SiteTree_Live"."FallbackLink", "SiteTree_Live"."FallbackResponseCode", "SiteTree_Live"."SEOPageSchema", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."Title", "SiteTree_Live"."URLSegment", "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"."VanityMappingID", "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.0003s
0091: SELECT DISTINCT "LinkMapping"."ClassName", "LinkMapping"."LastEdited", "LinkMapping"."Created", "LinkMapping"."LinkType", "LinkMapping"."MappedLink", "LinkMapping"."IncludesHostname", "LinkMapping"."Priority", "LinkMapping"."RedirectType", "LinkMapping"."RedirectLink", "LinkMapping"."RedirectPageID", "LinkMapping"."ResponseCode", "LinkMapping"."HostnameRestriction", "LinkMapping"."ID",
CASE WHEN "LinkMapping"."ClassName" IS NOT NULL THEN "LinkMapping"."ClassName"
ELSE 'nglasl\\misdirection\\LinkMapping' END AS "RecordClassName"
FROM "LinkMapping"
WHERE ((HostnameRestriction IS NULL) OR (HostnameRestriction = 'www.fanz.sh2.plasticstudio.co'))
AND ("LinkMapping"."LinkType" = ?)
ORDER BY "LinkMapping"."ID" DESC
0.0004s
0092: SELECT DISTINCT "LinkMapping"."ClassName", "LinkMapping"."LastEdited", "LinkMapping"."Created", "LinkMapping"."LinkType", "LinkMapping"."MappedLink", "LinkMapping"."IncludesHostname", "LinkMapping"."Priority", "LinkMapping"."RedirectType", "LinkMapping"."RedirectLink", "LinkMapping"."RedirectPageID", "LinkMapping"."ResponseCode", "LinkMapping"."HostnameRestriction", "LinkMapping"."ID",
CASE WHEN "LinkMapping"."ClassName" IS NOT NULL THEN "LinkMapping"."ClassName"
ELSE 'nglasl\\misdirection\\LinkMapping' END AS "RecordClassName"
FROM "LinkMapping"
WHERE ((HostnameRestriction IS NULL) OR (HostnameRestriction = 'www.fanz.sh2.plasticstudio.co'))
AND ((LinkType = 'Simple') AND (((IncludesHostname = 0) AND ((MappedLink = 'financial-advice/articles/investment-funds-investor-update-april-2025') OR (MappedLink LIKE 'financial-advice/articles/investment-funds-investor-update-april-2025?%'))) OR ((IncludesHostname = 1) AND ((MappedLink = 'www.fanz.sh2.plasticstudio.co/financial-advice/articles/investment-funds-investor-update-april-2025') OR (MappedLink LIKE 'www.fanz.sh2.plasticstudio.co/financial-advice/articles/investment-funds-investor-update-april-2025?%')))))
ORDER BY "LinkMapping"."ID" DESC
0.0002s
Dear investor, welcome to the SBS Wealth Investment Funds Investor Update for April 2025. Below you will find the latest performance data and market commentary from your SBS Wealth Investment Management Team.
Performance data
Performance as at 31 March 2025.
Strategy
1M
3M
6M
High Growth Strategy
-4.08%
-4.36%
14.46%
Growth Strategy
-3.87%
-3.32%
7.26%
Balanced Strategy
-2.94%
-2.29%
0.47%
Conservative Strategy
-1.55%
0.76%
1.18%
Portfolio
1M
1Y
5Y pa
World Equity Portfolio
-5.28%
7.69%
14.46%
Australasian Equity Portfolio
-3.35%
0.44%
7.26%
World Bond Portfolio
-0.30%
3.66%
0.47%
New Zealand Bond Portfolio*
0.07%
6.46%
1.18%
* Previously Corporate Bond Portfolio
Performance is shown after fees and before tax. For more information about how performance is calculated and more performance periods, clickhere.
Market update
Financial markets spent most of March focused on and reacting to short-term events in Washington. US President Donald Trump’s further announcements of sweeping tariffs added to market volatility in March as a universal 10% tariff on all imports and higher rates on specific countries was digested. Retaliation added to the turbulence as the likes of Ontario Premier Doug Ford added a 25% export tariff to electricity exported to the US before prompt removal following Trump’s threat of raising the current 25% steel and aluminium tariff to 50% for Canada.
Elon Musk’s Department of Government Efficiency (DOGE) continued with increasing public sector layoffs and culling of government spending throughout the month which also weighed on recession concerns.
The Federal Reserve met again for its regular meeting, where no change was made to the benchmark Federal Funds Rate, citing higher levels of economic uncertainty.Outside the US, we saw 0.25% interest rate cuts from the European Central Bank and Bank of Canada. Elsewhere, the Bank of Japan and Bank of England also conducted their regular meetings but did not make any adjustments to their respective interest rates.
Trump’s new trade policy measures led to the S&P500 slipping further into negative territory during March (-5.6%), unfortunately taking the quarterly result into the red as well. Despite the ongoing rotation away from technology stocks toward other sectors like healthcare, consumer staples and financials in previous months, the key index experienced broad declines across all sectors, except for Energy (+2.7% for the month). Consumer Discretionary slid the most (-9.8%) followed by Information Technology (-9.8%) for the month.
The World Equity Fund fell 5.28% during March, on the back of the Tariff War, with many of the Technology, Communication Services and Consumer Discretionary darling stocks of 2024 down over 10% for the month (Apple, Nvidia, Xero, Amazon, Disney, Alphabet, Meta, Tesla, Eli Lilly, Novo Nordisk). Many of our defensive positions did their job though and helped the Fund from falling further. For example, United Health Group was up +9.6%, Kernel Global Infrastructure +3.0%, iShares Global Clean Energy +1.7%, Roche +1.2%, Sony +0.6%, and Schroders Emerging Markets +0.1%. Longer-term the three-year return is over 9%pa and the five-year return over 14%pa.
Domestically, the NZ sharemarket was down for the month, NZX50 -2.6%. Performance was again impacted by wider market tariff turbulence and continued slow economic performance at home. Increased trade tensions, including the establishment of a 10% US tariff on NZ exports and increased US tariffs on China (our key trading partner) also weighed on performance. Across the ditch, the ASX200 index finished the month down –3.4% on a total return basis, led by Information Technology (-9.7%). Commercial and Industrial property, and Healthcare also retreated, among most other sectors, returning –4.9% and 4.6% respectively. Fears over reduced export demand from Australia (a largely export dependent nation) and weak performance in the resource sector impacted by declining iron ore prices also affected performance.
On the back of this, the Australasian Equity Fund fell 3.35% during March. Worst hit was Macquarie Group, Mainfreight, Xero, and Goodman Group. Many of our defensive positions did their job though and helped the Fund from falling further. For example, QBE Insurance was up +3.9%, and Telstar, Auckland Airport and Transurban all up +1.0%. Longer-term the five-year return is over 7%pa.
The World Bond Fund fell 0.30% during March, with shorter duration positions protecting investors somewhat. The domestic bond market performed slightly better than its global counterpart, with the New Zealand Bond Fund returning a positive +0.07%.
The investment strategies were all negative for March, with the severity of the equity markets adversely affecting them all for the month and the quarter.