0001: SET sql_mode = ? 0.0031s
0002: SHOW DATABASES LIKE 'silverstripe' 0.0014s
0003: SELECT DISTINCT count(DISTINCT "SubsiteDomain"."ID") AS "Count" FROM "SubsiteDomain" INNER JOIN "Subsite" ON "Subsite"."ID" = "SubsiteDomain"."SubsiteID" AND "Subsite"."IsPublic"=1 WHERE ('test.pulsenetinternational.org' LIKE replace("SubsiteDomain"."Domain",'*','%')) 0.0026s
0004: SELECT "SubsiteDomain"."SubsiteID", "SubsiteDomain"."IsPrimary" AS "_SortColumn0" FROM "SubsiteDomain" INNER JOIN "Subsite" ON "Subsite"."ID" = "SubsiteDomain"."SubsiteID" AND "Subsite"."IsPublic"=1 WHERE ('test.pulsenetinternational.org' LIKE replace("SubsiteDomain"."Domain",'*','%')) ORDER BY "_SortColumn0" DESC 0.0025s
0005: SELECT "SubsiteDomain"."Domain", "SubsiteDomain"."IsPrimary" AS "_SortColumn0" FROM "SubsiteDomain" INNER JOIN "Subsite" ON "Subsite"."ID" = "SubsiteDomain"."SubsiteID" AND "Subsite"."IsPublic"=1 WHERE ('test.pulsenetinternational.org' LIKE replace("SubsiteDomain"."Domain",'*','%')) ORDER BY "_SortColumn0" DESC 0.0011s
0006: SHOW FULL FIELDS IN "Member" 0.0022s
0007: SHOW COLLATION LIKE 'utf8_general_ci' 0.0024s
0008: SHOW FULL FIELDS IN "Group" 0.0025s
0009: SHOW FULL FIELDS IN "Permission" 0.0019s
0010: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."AlgoliaIndexed", "SiteTree_Live"."AlgoliaError", "SiteTree_Live"."AlgoliaUUID", "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"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "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" = ?) AND ("SiteTree_Live"."SubsiteID" IN (4)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0024s
0011: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."AlgoliaIndexed", "SiteTree_Live"."AlgoliaError", "SiteTree_Live"."AlgoliaUUID", "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"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "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" = ?) AND ("SiteTree_Live"."SubsiteID" IN (4)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0023s
0012: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."AlgoliaIndexed", "SiteTree_Live"."AlgoliaError", "SiteTree_Live"."AlgoliaUUID", "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"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0021s
0013: SELECT DISTINCT "Subsite"."ClassName", "Subsite"."LastEdited", "Subsite"."Created", "Subsite"."Title", "Subsite"."RedirectURL", "Subsite"."DefaultSite", "Subsite"."Theme", "Subsite"."Language", "Subsite"."IsPublic", "Subsite"."PageTypeBlacklist", "Subsite"."ID", CASE WHEN "Subsite"."ClassName" IS NOT NULL THEN "Subsite"."ClassName" ELSE 'SilverStripe\\Subsites\\Model\\Subsite' END AS "RecordClassName" FROM "Subsite" WHERE ("Subsite"."ID" = ?) ORDER BY "Subsite"."Title" ASC LIMIT 1 0.0025s
0014: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", "SiteConfig"."ReviewPeriodDays", "SiteConfig"."ReviewFrom", "SiteConfig"."ReviewSubject", "SiteConfig"."ReviewBody", "SiteConfig"."GACode", "SiteConfig"."FacebookURL", "SiteConfig"."TwitterUsername", "SiteConfig"."FooterLogoLink", "SiteConfig"."FooterLogoDescription", "SiteConfig"."FooterLogoSecondaryLink", "SiteConfig"."FooterLogoSecondaryDescription", "SiteConfig"."EmptySearch", "SiteConfig"."NoSearchResults", "SiteConfig"."MainFontFamily", "SiteConfig"."HeaderBackground", "SiteConfig"."NavigationBarBackground", "SiteConfig"."CarouselBackground", "SiteConfig"."FooterBackground", "SiteConfig"."AccentColor", "SiteConfig"."TextLinkColor", "SiteConfig"."CookieConsentTitle", "SiteConfig"."CookieConsentContent", "SiteConfig"."FacebookPixelID", "SiteConfig"."CustAlertTitle", "SiteConfig"."CustAlertType", "SiteConfig"."CustAlertBody", "SiteConfig"."CustAlertToggle", "SiteConfig"."RedirectAllSiteTrafficTo", "SiteConfig"."NoIndex", "SiteConfig"."MethCalcTimeoutThreshold", "SiteConfig"."MethCalcRequestThreshold", "SiteConfig"."MethCalcWhitelist", "SiteConfig"."MethCalcSwabAreaDesc", "SiteConfig"."MethCalcRoomAreaDesc", "SiteConfig"."MethCalcTestValueDesc", "SiteConfig"."MethCalcUserTypeDesc", "SiteConfig"."MethCalcDescription", "SiteConfig"."MethCalcDisclaimer", "SiteConfig"."MethCalcGTA", "SiteConfig"."MethCalcGTM", "SiteConfig"."IncludeSearch", "SiteConfig"."ContactTitle", "SiteConfig"."ContactText", "SiteConfig"."ContactEmail", "SiteConfig"."ContactPhone", "SiteConfig"."HideContact", "SiteConfig"."LinkedinID", "SiteConfig"."YoutubeURL", "SiteConfig"."InstagramURL", "SiteConfig"."CopyrightText", "SiteConfig"."CopyrightLink", "SiteConfig"."EnableNewFooter", "SiteConfig"."FooterColor", "SiteConfig"."Title", "SiteConfig"."Tagline", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."SubsiteID", "SiteConfig"."LogoID", "SiteConfig"."LogoRetinaID", "SiteConfig"."FooterLogoID", "SiteConfig"."FooterLogoRetinaID", "SiteConfig"."FooterLogoSecondaryID", "SiteConfig"."FavIconID", "SiteConfig"."AppleTouchIcon144ID", "SiteConfig"."AppleTouchIcon114ID", "SiteConfig"."AppleTouchIcon72ID", "SiteConfig"."AppleTouchIcon57ID", "SiteConfig"."WellKiwisLinkID", "SiteConfig"."MethCalcLogoID", "SiteConfig"."ContactLinkID", "SiteConfig"."ID", CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName" ELSE 'SilverStripe\\SiteConfig\\SiteConfig' END AS "RecordClassName" FROM "SiteConfig" WHERE ("SubsiteID" = 4) LIMIT 1 0.0017s
0015: SELECT DISTINCT "Subsite"."ClassName", "Subsite"."LastEdited", "Subsite"."Created", "Subsite"."Title", "Subsite"."RedirectURL", "Subsite"."DefaultSite", "Subsite"."Theme", "Subsite"."Language", "Subsite"."IsPublic", "Subsite"."PageTypeBlacklist", "Subsite"."ID", CASE WHEN "Subsite"."ClassName" IS NOT NULL THEN "Subsite"."ClassName" ELSE 'SilverStripe\\Subsites\\Model\\Subsite' END AS "RecordClassName" FROM "Subsite" WHERE ("Subsite"."ID" = ?) ORDER BY "Subsite"."Title" ASC LIMIT 1 0.002s
0016: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", "SiteConfig"."ReviewPeriodDays", "SiteConfig"."ReviewFrom", "SiteConfig"."ReviewSubject", "SiteConfig"."ReviewBody", "SiteConfig"."GACode", "SiteConfig"."FacebookURL", "SiteConfig"."TwitterUsername", "SiteConfig"."FooterLogoLink", "SiteConfig"."FooterLogoDescription", "SiteConfig"."FooterLogoSecondaryLink", "SiteConfig"."FooterLogoSecondaryDescription", "SiteConfig"."EmptySearch", "SiteConfig"."NoSearchResults", "SiteConfig"."MainFontFamily", "SiteConfig"."HeaderBackground", "SiteConfig"."NavigationBarBackground", "SiteConfig"."CarouselBackground", "SiteConfig"."FooterBackground", "SiteConfig"."AccentColor", "SiteConfig"."TextLinkColor", "SiteConfig"."CookieConsentTitle", "SiteConfig"."CookieConsentContent", "SiteConfig"."FacebookPixelID", "SiteConfig"."CustAlertTitle", "SiteConfig"."CustAlertType", "SiteConfig"."CustAlertBody", "SiteConfig"."CustAlertToggle", "SiteConfig"."RedirectAllSiteTrafficTo", "SiteConfig"."NoIndex", "SiteConfig"."MethCalcTimeoutThreshold", "SiteConfig"."MethCalcRequestThreshold", "SiteConfig"."MethCalcWhitelist", "SiteConfig"."MethCalcSwabAreaDesc", "SiteConfig"."MethCalcRoomAreaDesc", "SiteConfig"."MethCalcTestValueDesc", "SiteConfig"."MethCalcUserTypeDesc", "SiteConfig"."MethCalcDescription", "SiteConfig"."MethCalcDisclaimer", "SiteConfig"."MethCalcGTA", "SiteConfig"."MethCalcGTM", "SiteConfig"."IncludeSearch", "SiteConfig"."ContactTitle", "SiteConfig"."ContactText", "SiteConfig"."ContactEmail", "SiteConfig"."ContactPhone", "SiteConfig"."HideContact", "SiteConfig"."LinkedinID", "SiteConfig"."YoutubeURL", "SiteConfig"."InstagramURL", "SiteConfig"."CopyrightText", "SiteConfig"."CopyrightLink", "SiteConfig"."EnableNewFooter", "SiteConfig"."FooterColor", "SiteConfig"."Title", "SiteConfig"."Tagline", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."SubsiteID", "SiteConfig"."LogoID", "SiteConfig"."LogoRetinaID", "SiteConfig"."FooterLogoID", "SiteConfig"."FooterLogoRetinaID", "SiteConfig"."FooterLogoSecondaryID", "SiteConfig"."FavIconID", "SiteConfig"."AppleTouchIcon144ID", "SiteConfig"."AppleTouchIcon114ID", "SiteConfig"."AppleTouchIcon72ID", "SiteConfig"."AppleTouchIcon57ID", "SiteConfig"."WellKiwisLinkID", "SiteConfig"."MethCalcLogoID", "SiteConfig"."ContactLinkID", "SiteConfig"."ID", CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName" ELSE 'SilverStripe\\SiteConfig\\SiteConfig' END AS "RecordClassName" FROM "SiteConfig" WHERE ("SiteConfig"."SubsiteID" IN (4)) LIMIT 1 0.0012s
0017: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."HasMigratedAndExists", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."SubsiteID", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" WHERE ("File_Live"."ID" = ?) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0032s
0018: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."AlgoliaIndexed", "SiteTree_Live"."AlgoliaError", "SiteTree_Live"."AlgoliaUUID", "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"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "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" = ?) AND ("SiteTree_Live"."SubsiteID" IN (4)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0032s
0019: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."AlgoliaIndexed", "SiteTree_Live"."AlgoliaError", "SiteTree_Live"."AlgoliaUUID", "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"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.002s
0020: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."AlgoliaIndexed", "SiteTree_Live"."AlgoliaError", "SiteTree_Live"."AlgoliaUUID", "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"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "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.0018s
0021: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."AlgoliaIndexed", "SiteTree_Live"."AlgoliaError", "SiteTree_Live"."AlgoliaUUID", "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"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "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.0041s
0022: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."AlgoliaIndexed", "SiteTree_Live"."AlgoliaError", "SiteTree_Live"."AlgoliaUUID", "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"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "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.0019s
0023: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."AlgoliaIndexed", "SiteTree_Live"."AlgoliaError", "SiteTree_Live"."AlgoliaUUID", "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"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0021s
0024: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."AlgoliaIndexed", "SiteTree_Live"."AlgoliaError", "SiteTree_Live"."AlgoliaUUID", "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"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "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.0026s
0025: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."AlgoliaIndexed", "SiteTree_Live"."AlgoliaError", "SiteTree_Live"."AlgoliaUUID", "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"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0021s
0026: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."HasMigratedAndExists", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."SubsiteID", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0026s
0027: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited") FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND ("SiteTree_Live"."SubsiteID" IN (4)) 0.0049s
0028: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."Intro", "Page_Live"."TeReoMenuTitle", "Page_Live"."AddInfoTitle", "Page_Live"."AdditionalInformation", "Page_Live"."RightMenuTitle", "Page_Live"."RightHandMenu", "Page_Live"."RightMenuVideo", "Page_Live"."AddInfoVideo", "Page_Live"."InFooter", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlocksPage', 'Intelligence\\Intelligence\\Page\\ContactPage', 'ESR\\ESR\\Pages\\EsrPage', 'Intelligence\\Intelligence\\Page\\IndexPage', 'ESR\\ESR\\Page\\SearchPage', 'Strmix\\Strmix\\Pages\\StrmixPage', 'Wellkiwis\\Wellkiwis\\Pages\\TeamPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\IFrame\\IFramePage', 'SilverStripe\\Registry\\RegistryPage', 'Broarm\\CookieConsent\\Model\\CookiePolicyPage', 'Broarm\\CookieConsent\\Model\\PrivacyPolicyPage', 'Broarm\\CookieConsent\\Model\\TermsAndConditionsPage', 'CWP\\CWP\\PageTypes\\BaseHomePage', 'CWP\\CWP\\PageTypes\\DatedUpdateHolder', 'CWP\\CWP\\PageTypes\\DatedUpdatePage', 'CWP\\CWP\\PageTypes\\SitemapPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'ESR\\ESR\\Pages\\EsrCaseStudyPage', 'ESR\\ESR\\Pages\\EsrFeedDisplayPage', 'ESR\\ESR\\Pages\\EsrFullWidthPage', 'ESR\\ESR\\Pages\\EsrHolder', 'ESR\\ESR\\Pages\\EsrHomePage', 'ESR\\ESR\\Pages\\EsrProfilePage', 'ESR\\ESR\\Pages\\EsrSectionPage', 'ESR\\ESR\\Pages\\EsrCaseStudyHolderPage', 'ESR\\ESR\\Pages\\EsrFeatureHolder', 'ESR\\ESR\\Pages\\EsrProfileHolderPage', 'Strmix\\Strmix\\Pages\\StrmixCookiePolicyPage', 'HomePage', 'Strmix\\Strmix\\Pages\\StrmixHomePage', 'CWP\\CWP\\PageTypes\\EventHolder', 'CWP\\CWP\\PageTypes\\NewsHolder', 'ESR\\ESR\\Pages\\EsrNewsHolder', 'Strmix\\Strmix\\Pages\\StrmixNewsHolder', 'ESR\\ESR\\Pages\\EsrPublicationHolder', 'CWP\\CWP\\PageTypes\\EventPage', 'CWP\\CWP\\PageTypes\\NewsPage', 'ESR\\ESR\\Pages\\EsrPublicationPage', 'Strmix\\Strmix\\Pages\\StrmixNewsPage', 'CWP\\CWP\\PageTypes\\FooterHolder', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."HideTitle" WHEN "SiteTree_Live"."ClassName" IN ('Strmix\\Strmix\\Pages\\StrmixPage') THEN "Strmix_Strmix_Pages_StrmixPage_Live"."HideTitle" WHEN "SiteTree_Live"."ClassName" IN ('Wellkiwis\\Wellkiwis\\Pages\\TeamPage') THEN "WellKiwisTeamPage_Live"."HideTitle" WHEN "SiteTree_Live"."ClassName" IN ('Strmix\\Strmix\\Pages\\StrmixHomePage') THEN "StrmixHomePage_Live"."HideTitle" WHEN "SiteTree_Live"."ClassName" IN ('Strmix\\Strmix\\Pages\\StrmixNewsPage') THEN "Strmix_Strmix_Pages_StrmixNewsPage_Live"."HideTitle" ELSE NULL END AS "HideTitle", "Page_Live"."HideInThisSection", "Page_Live"."DisableRichLinks", "Page_Live"."ElementalAreaID", "Page_Live"."AddInfoImageID", "Page_Live"."RightMenuImageID", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BlocksPage', 'Intelligence\\Intelligence\\Page\\ContactPage', 'ESR\\ESR\\Pages\\EsrPage', 'Intelligence\\Intelligence\\Page\\IndexPage', 'ESR\\ESR\\Page\\SearchPage', 'Strmix\\Strmix\\Pages\\StrmixPage', 'Wellkiwis\\Wellkiwis\\Pages\\TeamPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\IFrame\\IFramePage', 'SilverStripe\\Registry\\RegistryPage', 'Broarm\\CookieConsent\\Model\\CookiePolicyPage', 'Broarm\\CookieConsent\\Model\\PrivacyPolicyPage', 'Broarm\\CookieConsent\\Model\\TermsAndConditionsPage', 'CWP\\CWP\\PageTypes\\BaseHomePage', 'CWP\\CWP\\PageTypes\\DatedUpdateHolder', 'CWP\\CWP\\PageTypes\\DatedUpdatePage', 'CWP\\CWP\\PageTypes\\SitemapPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'ESR\\ESR\\Pages\\EsrCaseStudyPage', 'ESR\\ESR\\Pages\\EsrFeedDisplayPage', 'ESR\\ESR\\Pages\\EsrFullWidthPage', 'ESR\\ESR\\Pages\\EsrHolder', 'ESR\\ESR\\Pages\\EsrHomePage', 'ESR\\ESR\\Pages\\EsrProfilePage', 'ESR\\ESR\\Pages\\EsrSectionPage', 'ESR\\ESR\\Pages\\EsrCaseStudyHolderPage', 'ESR\\ESR\\Pages\\EsrFeatureHolder', 'ESR\\ESR\\Pages\\EsrProfileHolderPage', 'Strmix\\Strmix\\Pages\\StrmixCookiePolicyPage', 'HomePage', 'Strmix\\Strmix\\Pages\\StrmixHomePage', 'CWP\\CWP\\PageTypes\\EventHolder', 'CWP\\CWP\\PageTypes\\NewsHolder', 'ESR\\ESR\\Pages\\EsrNewsHolder', 'Strmix\\Strmix\\Pages\\StrmixNewsHolder', 'ESR\\ESR\\Pages\\EsrPublicationHolder', 'CWP\\CWP\\PageTypes\\EventPage', 'CWP\\CWP\\PageTypes\\NewsPage', 'ESR\\ESR\\Pages\\EsrPublicationPage', 'Strmix\\Strmix\\Pages\\StrmixNewsPage', 'CWP\\CWP\\PageTypes\\FooterHolder', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."HeroImageID" WHEN "SiteTree_Live"."ClassName" IN ('ESR\\ESR\\Pages\\EsrHomePage') THEN "EsrHomePage_Live"."HeroImageID" ELSE NULL END AS "HeroImageID", "Page_Live"."HeroImageMobileID", "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 "Strmix_Strmix_Pages_StrmixPage_Live" ON "Strmix_Strmix_Pages_StrmixPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "WellKiwisTeamPage_Live" ON "WellKiwisTeamPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "EsrHomePage_Live" ON "EsrHomePage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "StrmixHomePage_Live" ON "StrmixHomePage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "Strmix_Strmix_Pages_StrmixNewsPage_Live" ON "Strmix_Strmix_Pages_StrmixNewsPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ID" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0052s
0029: 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.0025s
0030: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "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.0028s
0031: 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.0025s
0032: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."AlgoliaIndexed", "SiteTree_Live"."AlgoliaError", "SiteTree_Live"."AlgoliaUUID", "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"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", "Page_Live"."Intro", "Page_Live"."TeReoMenuTitle", "Page_Live"."AddInfoTitle", "Page_Live"."AdditionalInformation", "Page_Live"."RightMenuTitle", "Page_Live"."RightHandMenu", "Page_Live"."RightMenuVideo", "Page_Live"."AddInfoVideo", "Page_Live"."InFooter", "Page_Live"."HideTitle", "Page_Live"."HideInThisSection", "Page_Live"."DisableRichLinks", "Page_Live"."ElementalAreaID", "Page_Live"."AddInfoImageID", "Page_Live"."RightMenuImageID", "Page_Live"."HeroImageID", "Page_Live"."HeroImageMobileID", "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 ("Page_Live"."ElementalAreaID" = ?) AND ("SiteTree_Live"."ClassName" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND ("SiteTree_Live"."SubsiteID" IN (4)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0052s
0033: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."AlgoliaIndexed", "SiteTree_Live"."AlgoliaError", "SiteTree_Live"."AlgoliaUUID", "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"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0023s
0034: 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.0022s
0035: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "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.003s
0036: SELECT CASE WHEN EXISTS(SELECT * FROM "SiteTree_Live" INNER JOIN (SELECT DISTINCT "BasePage_RelatedPages_Live"."ClassName", "BasePage_RelatedPages_Live"."LastEdited", "BasePage_RelatedPages_Live"."Created", "BasePage_RelatedPages_Live"."Version", "BasePage_RelatedPages_Live"."SortOrder", "BasePage_RelatedPages_Live"."BasePageID", "BasePage_RelatedPages_Live"."ChildID", "BasePage_RelatedPages_Live"."ID", CASE WHEN "BasePage_RelatedPages_Live"."ClassName" IS NOT NULL THEN "BasePage_RelatedPages_Live"."ClassName" ELSE 'CWP\\CWP\\Model\\RelatedPageLink' END AS "RecordClassName" FROM "BasePage_RelatedPages_Live" WHERE ("BasePage_RelatedPages_Live"."BasePageID" = ?)) AS "BasePage_RelatedPages" ON "BasePage_RelatedPages"."ChildID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND ("SiteTree_Live"."SubsiteID" IN (4))) THEN 1 ELSE 0 END 0.0049s
0037: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."AlgoliaIndexed", "SiteTree_Live"."AlgoliaError", "SiteTree_Live"."AlgoliaUUID", "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"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "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" = ?) AND ("SiteTree_Live"."SubsiteID" IN (4)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0038s
0038: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."AlgoliaIndexed", "SiteTree_Live"."AlgoliaError", "SiteTree_Live"."AlgoliaUUID", "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"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", "Page_Live"."Intro", "Page_Live"."TeReoMenuTitle", "Page_Live"."AddInfoTitle", "Page_Live"."AdditionalInformation", "Page_Live"."RightMenuTitle", "Page_Live"."RightHandMenu", "Page_Live"."RightMenuVideo", "Page_Live"."AddInfoVideo", "Page_Live"."InFooter", "Page_Live"."HideTitle", "Page_Live"."HideInThisSection", "Page_Live"."DisableRichLinks", "Page_Live"."ElementalAreaID", "Page_Live"."AddInfoImageID", "Page_Live"."RightMenuImageID", "Page_Live"."HeroImageID", "Page_Live"."HeroImageMobileID", "RedirectorPage_Live"."RedirectionType", "RedirectorPage_Live"."ExternalURL", "RedirectorPage_Live"."LinkToID", "RedirectorPage_Live"."LinkToFileID", "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 "RedirectorPage_Live" ON "RedirectorPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?)) AND ("SiteTree_Live"."SubsiteID" IN (4)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0045s
0039: SELECT "Version" FROM "SiteTree" WHERE "ID" = ? 0.0036s
0040: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."AlgoliaIndexed", "SiteTree_Live"."AlgoliaError", "SiteTree_Live"."AlgoliaUUID", "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"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "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.004s
0041: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."AlgoliaIndexed", "SiteTree_Live"."AlgoliaError", "SiteTree_Live"."AlgoliaUUID", "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"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "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
0042: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."AlgoliaIndexed", "SiteTree_Live"."AlgoliaError", "SiteTree_Live"."AlgoliaUUID", "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"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "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.0029s
0043: SELECT DISTINCT "Subsite"."ClassName", "Subsite"."LastEdited", "Subsite"."Created", "Subsite"."Title", "Subsite"."RedirectURL", "Subsite"."DefaultSite", "Subsite"."Theme", "Subsite"."Language", "Subsite"."IsPublic", "Subsite"."PageTypeBlacklist", "Subsite"."ID", CASE WHEN "Subsite"."ClassName" IS NOT NULL THEN "Subsite"."ClassName" ELSE 'SilverStripe\\Subsites\\Model\\Subsite' END AS "RecordClassName" FROM "Subsite" WHERE ("Subsite"."ID" = ?) ORDER BY "Subsite"."Title" ASC LIMIT 1 0.0055s
0044: SELECT DISTINCT "SubsiteDomain"."ClassName", "SubsiteDomain"."LastEdited", "SubsiteDomain"."Created", "SubsiteDomain"."Domain", "SubsiteDomain"."Protocol", "SubsiteDomain"."IsPrimary", "SubsiteDomain"."SubsiteID", "SubsiteDomain"."ID", CASE WHEN "SubsiteDomain"."ClassName" IS NOT NULL THEN "SubsiteDomain"."ClassName" ELSE 'SilverStripe\\Subsites\\Model\\SubsiteDomain' END AS "RecordClassName" FROM "SubsiteDomain" WHERE ("SubsiteDomain"."SubsiteID" = ?) ORDER BY "SubsiteDomain"."IsPrimary" DESC LIMIT 1 0.003s
0045: SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", "SiteTree"."Priority", "SiteTree"."ShareTokenSalt", "SiteTree"."ContentReviewType", "SiteTree"."ReviewPeriodDays", "SiteTree"."NextReviewDate", "SiteTree"."LastEditedByName", "SiteTree"."OwnerNames", "SiteTree"."ProvideComments", "SiteTree"."ModerationRequired", "SiteTree"."CommentsRequireLogin", "SiteTree"."ShowPageUtilities", "SiteTree"."AlgoliaIndexed", "SiteTree"."AlgoliaError", "SiteTree"."AlgoliaUUID", "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"."WorkflowDefinitionID", "SiteTree"."SubsiteID", "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.0023s
0046: SELECT DISTINCT "Subsite"."ClassName", "Subsite"."LastEdited", "Subsite"."Created", "Subsite"."Title", "Subsite"."RedirectURL", "Subsite"."DefaultSite", "Subsite"."Theme", "Subsite"."Language", "Subsite"."IsPublic", "Subsite"."PageTypeBlacklist", "Subsite"."ID", CASE WHEN "Subsite"."ClassName" IS NOT NULL THEN "Subsite"."ClassName" ELSE 'SilverStripe\\Subsites\\Model\\Subsite' END AS "RecordClassName" FROM "Subsite" WHERE ("Subsite"."ID" = ?) ORDER BY "Subsite"."Title" ASC LIMIT 1 0.0033s
0047: SELECT DISTINCT "SubsiteDomain"."ClassName", "SubsiteDomain"."LastEdited", "SubsiteDomain"."Created", "SubsiteDomain"."Domain", "SubsiteDomain"."Protocol", "SubsiteDomain"."IsPrimary", "SubsiteDomain"."SubsiteID", "SubsiteDomain"."ID", CASE WHEN "SubsiteDomain"."ClassName" IS NOT NULL THEN "SubsiteDomain"."ClassName" ELSE 'SilverStripe\\Subsites\\Model\\SubsiteDomain' END AS "RecordClassName" FROM "SubsiteDomain" WHERE ("SubsiteDomain"."SubsiteID" = ?) ORDER BY "SubsiteDomain"."IsPrimary" DESC LIMIT 1 0.0045s
0048: SELECT DISTINCT "SubsiteDomain"."ClassName", "SubsiteDomain"."LastEdited", "SubsiteDomain"."Created", "SubsiteDomain"."Domain", "SubsiteDomain"."Protocol", "SubsiteDomain"."IsPrimary", "SubsiteDomain"."SubsiteID", "SubsiteDomain"."ID", CASE WHEN "SubsiteDomain"."ClassName" IS NOT NULL THEN "SubsiteDomain"."ClassName" ELSE 'SilverStripe\\Subsites\\Model\\SubsiteDomain' END AS "RecordClassName" FROM "SubsiteDomain" WHERE ("SubsiteDomain"."SubsiteID" = ?) ORDER BY "SubsiteDomain"."IsPrimary" DESC LIMIT 1 0.0029s
0049: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."AlgoliaIndexed", "SiteTree_Live"."AlgoliaError", "SiteTree_Live"."AlgoliaUUID", "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"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0023s
0050: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."AlgoliaIndexed", "SiteTree_Live"."AlgoliaError", "SiteTree_Live"."AlgoliaUUID", "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"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "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.0044s
0051: SELECT DISTINCT "Subsite"."ClassName", "Subsite"."LastEdited", "Subsite"."Created", "Subsite"."Title", "Subsite"."RedirectURL", "Subsite"."DefaultSite", "Subsite"."Theme", "Subsite"."Language", "Subsite"."IsPublic", "Subsite"."PageTypeBlacklist", "Subsite"."ID", CASE WHEN "Subsite"."ClassName" IS NOT NULL THEN "Subsite"."ClassName" ELSE 'SilverStripe\\Subsites\\Model\\Subsite' END AS "RecordClassName" FROM "Subsite" WHERE ("Subsite"."ID" = ?) ORDER BY "Subsite"."Title" ASC LIMIT 1 0.0024s
0052: SELECT DISTINCT "SubsiteDomain"."ClassName", "SubsiteDomain"."LastEdited", "SubsiteDomain"."Created", "SubsiteDomain"."Domain", "SubsiteDomain"."Protocol", "SubsiteDomain"."IsPrimary", "SubsiteDomain"."SubsiteID", "SubsiteDomain"."ID", CASE WHEN "SubsiteDomain"."ClassName" IS NOT NULL THEN "SubsiteDomain"."ClassName" ELSE 'SilverStripe\\Subsites\\Model\\SubsiteDomain' END AS "RecordClassName" FROM "SubsiteDomain" WHERE ("SubsiteDomain"."SubsiteID" = ?) ORDER BY "SubsiteDomain"."IsPrimary" DESC LIMIT 1 0.003s
PulseNet Canada was formally established as the country’s National Molecular Subtyping Network for Foodborne Disease Surveillance in the year 2000. Currently, the network includes the public health laboratories of all ten provinces (British Columbia, Alberta, Saskatchewan, Manitoba, Ontario, Quebec, Nova Scotia, New Brunswick, Prince Edward Island, and Newfoundland & Labrador) plus two federal laboratories (the Public Health Agency of Canada’s Laboratory for Foodborne Zoonoses and Health Canada’s Bureau of Microbial Hazards). The network is coordinated by the Public Health Agency of Canada’s National Microbiology Laboratory(external link) located in Winnipeg, Manitoba. The PulseNet Canada team at NML houses and manages the national databases. All cases of E. coli O157:H7 in Canada are characterized by PFGE and shared through the PulseNet system, as well as the majority of Salmonella cases. Shigella and Campylobacter are also characterized by standardized PFGE when and outbreak is suspected.
PulseNet Canada utilizes a secure Internet-based discussion board as the primary means of communication. The discussion board is hosted by the Canadian Network for Public Health Intelligence and has been used for PulseNet Canada communications since early 2005. Participating laboratories post clusters of cases with indistinguishable PFGE patterns found within their jurisdictions to the discussion board. NML provides training on PFGE and BioNumerics to participating laboratories as needed. Most recently, individuals from all participating labs attended at 2-day workshop by Applied Maths hosted by NML in May 2007.
PulseNet Canada headquarters began issuing a weekly program report to all participating laboratories in late 2006. The weekly report provides a summary table of current clusters as well as a compilation of database activity, and any news items, issues and tips for the week. The report is posted to the discussion board and is available electronically to all participating laboratories. By having a summary of active clusters available “at-a-glance”, participating laboratories and epidemiologists use the weekly report to stay on top of current events.
Participating laboratories meet annually at the PulseNet Canada Annual Meeting held in Winnipeg. In February 2007 NML hosted a joint meeting with the Foodborne Epidemiologists Conference, formally bringing PulseNet laboratories and provincial and federal foodborne epidemiologists together for the first time. Co-Chaired by PulseNet Canada and PHAC’s Outbreak Response and Issues Management, Foodborne, Waterborne and Zoonotic Infections Division, one of the primary themes of the meeting was enhancing communication between laboratories and epidemiologists. The joint laboratory-epidemiology general session comprised approximately half of the conference time. Presentations were delivered on topics including “The Challenges of Interjurisdictional Foodborne Outbreak Investigations”, “Prioritizing Salmonella Serotypes for PFGE Subtyping”, “Information Flow Between Labs and Epis: What Works Well and What We Can Improve” and “National Level Cluster Detection and Interpretation”. Lively and useful discussions followed as the laboratories and epidemiologists discussed issues of mutual concern and interest.
Canada and the United States signed a Memorandum of Understanding (MOU) in August 2005 that describes both countries’ recognition of the importance and commitment to sharing PFGE data for foodborne disease surveillance. Since the agreement was signed, PulseNet USA and PulseNet Canada headquarters jointly drafted a protocol to describe our data-sharing and notification procedures. The agreement was fully implemented in March 2007, when PulseNet USA and Canada database managers achieved direct access to each other’s national databases (on a read-only basis). This arrangement between the two national networks facilitates the early identification of cross-border clusters and has further enhanced the communication between PulseNet Canada and PulseNet USA.
For further information please contact:
Dr Celine Nadon, PulseNet Canada, National Microbiology Laboratory, Winnipeg, Canada.
Last modified: