The following query took 0.003s an returned row(s)
Triggered by: Convert::raw2sql:183 > Subsite::getSubsiteIDForDomain:257 > InitStateMiddleware->detectSubsiteId:97 > InitStateMiddleware->process:41
SET
sql_mode = 'ANSI'
The following query took 0.0011s an returned 1 row(s)
Triggered by: Convert::raw2sql:183 > Subsite::getSubsiteIDForDomain:257 > InitStateMiddleware->detectSubsiteId:97 > InitStateMiddleware->process:41
SHOW DATABASES LIKE 'silverstripe'
array:1 [
"Database (silverstripe)" => "silverstripe"
]
The following query took 0.0012s an returned 1 row(s)
Triggered by: Subsite::getSubsiteIDForDomain:281 > InitStateMiddleware->detectSubsiteId:97 > InitStateMiddleware->process:41 > LoginSessionMiddleware->process:30
SELECT
DISTINCT count(DISTINCT "SubsiteDomain"."ID") AS "Count"
FROM
"SubsiteDomain"
INNER JOIN "Subsite" ON "Subsite"."ID" = "SubsiteDomain"."SubsiteID"
AND "Subsite"."IsPublic" = 1
WHERE
(
'test.wellkiwis.co.nz' LIKE replace(
"SubsiteDomain"."Domain", '*', '%'
)
)
array:1 [
"Count" => 1
]
The following query took 0.0008s an returned 1 row(s)
Triggered by: Subsite::getSubsiteIDForDomain:282 > InitStateMiddleware->detectSubsiteId:97 > InitStateMiddleware->process:41 > LoginSessionMiddleware->process:30
SELECT
"SubsiteDomain"."SubsiteID",
"SubsiteDomain"."IsPrimary" AS "_SortColumn0"
FROM
"SubsiteDomain"
INNER JOIN "Subsite" ON "Subsite"."ID" = "SubsiteDomain"."SubsiteID"
AND "Subsite"."IsPublic" = 1
WHERE
(
'test.wellkiwis.co.nz' LIKE replace(
"SubsiteDomain"."Domain", '*', '%'
)
)
ORDER BY
"_SortColumn0" DESC
array:2 [
"SubsiteID" => 36
"_SortColumn0" => 0
]
The following query took 0.0007s an returned 1 row(s)
Triggered by: Subsite::getSubsiteIDForDomain:283 > InitStateMiddleware->detectSubsiteId:97 > InitStateMiddleware->process:41 > LoginSessionMiddleware->process:30
SELECT
"SubsiteDomain"."Domain",
"SubsiteDomain"."IsPrimary" AS "_SortColumn0"
FROM
"SubsiteDomain"
INNER JOIN "Subsite" ON "Subsite"."ID" = "SubsiteDomain"."SubsiteID"
AND "Subsite"."IsPublic" = 1
WHERE
(
'test.wellkiwis.co.nz' LIKE replace(
"SubsiteDomain"."Domain", '*', '%'
)
)
ORDER BY
"_SortColumn0" DESC
array:2 [
"Domain" => "test.wellkiwis.co.nz"
"_SortColumn0" => 0
]
The following query took 0.0059s an returned 35 row(s)
Triggered by: Security::database_is_ready:1113 > AuditHook->onAfterInit:362 > Extension->invokeExtension:142 > Controller->doInit:131
SHOW FULL FIELDS IN "Member"
"ID,ClassName,Created,LastEdited,FirstName,Surname,Email,Password,RememberLoginToken,NumVisit,LastVisited,AutoLoginHash,AutoLoginExpired,PasswordEncryption,Salt,PasswordExpiry,LockedOutUntil,Locale,FailedLoginCount,DateFormat,TimeFormat,ValidationKey,NeedsValidation,NeedsApproval,PublicFieldsRaw,ProfilePageID,Company,TempIDHash,TempIDExpired,URLSegment,BlogProfileSummary,BlogProfileImageID,SAMLSessionIndex,GUID,SsoAttributes"
The following query took 0.0012s an returned 1 row(s)
Triggered by: Security::database_is_ready:1113 > AuditHook->onAfterInit:362 > Extension->invokeExtension:142 > Controller->doInit:131
SHOW COLLATION LIKE 'utf8_general_ci'
array:6 [
"Collation" => "utf8_general_ci"
"Charset" => "utf8"
"Id" => 33
"Default" => "Yes"
"Compiled" => "Yes"
"Sortlen" => 1
]
The following query took 0.0009s an returned 12 row(s)
Triggered by: Security::database_is_ready:1113 > AuditHook->onAfterInit:362 > Extension->invokeExtension:142 > Controller->doInit:131
SHOW FULL FIELDS IN "Group"
"ID,ClassName,Created,LastEdited,Title,Description,Code,Locked,Sort,HtmlEditorConfig,AccessAllSubsites,ParentID"
The following query took 0.0009s an returned 8 row(s)
Triggered by: Security::database_is_ready:1113 > AuditHook->onAfterInit:362 > Extension->invokeExtension:142 > Controller->doInit:131
SHOW FULL FIELDS IN "Permission"
"ID,ClassName,Created,LastEdited,Code,Arg,Type,GroupID"
The following query took 0.0031s an returned 1 row(s)
Triggered by: ModelAsController->getNestedController:126
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" = 'weekly-surveys'
)
AND ("SiteTree_Live"."ParentID" = 0)
AND (
"SiteTree_Live"."SubsiteID" IN (36)
)
ORDER BY
"SiteTree_Live"."Sort" ASC
LIMIT
1
array:37 [
"ClassName" => "Page"
"LastEdited" => "2024-07-12 13:38:20"
"Created" => "2023-03-13 15:11:12"
"Priority" => null
"ShareTokenSalt" => null
"ContentReviewType" => "Inherit"
"ReviewPeriodDays" => 0
"NextReviewDate" => null
"LastEditedByName" => "Ruth Seeds"
"OwnerNames" => null
"ProvideComments" => 0
"ModerationRequired" => "None"
"CommentsRequireLogin" => 0
"ShowPageUtilities" => 0
"AlgoliaIndexed" => null
"AlgoliaError" => null
"AlgoliaUUID" => null
"CanViewType" => "Inherit"
"CanEditType" => "Inherit"
"Version" => 24
"URLSegment" => "weekly-surveys"
"Title" => "Weekly Survey"
"MenuTitle" => null
"Content" => null
"MetaDescription" => null
"ExtraMeta" => null
"ShowInMenus" => 1
"ShowInSearch" => 1
"Sort" => 8
"HasBrokenFile" => 0
"HasBrokenLink" => 0
"ReportClass" => null
"WorkflowDefinitionID" => 0
"SubsiteID" => 36
"ParentID" => 0
"ID" => 3300
"RecordClassName" => "Page"
]
The following query took 0.0023s an returned 1 row(s)
Triggered by: Subsite::currentSubsite:188 > SiteTreeSubsites::contentcontrollerInit:401 > Extension->invokeExtension:142 > ContentController->init:169
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" = 36)
ORDER BY
"Subsite"."Title" ASC
LIMIT
1
array:12 [
"ClassName" => "SilverStripe\Subsites\Model\Subsite"
"LastEdited" => "2021-06-08 16:43:18"
"Created" => "2021-05-07 13:47:27"
"Title" => "Wellkiwis2021"
"RedirectURL" => null
"DefaultSite" => 0
"Theme" => "wellkiwis"
"Language" => "en_US"
"IsPublic" => 1
"PageTypeBlacklist" => "["ESR\\ESR\\Pages\\EsrNewsHolder","ESR\\ESR\\Pages\\EsrPublicationPage","ESR\\ESR\\Pages\\EsrPublicationHolder","ESR\\ESR\\Pages\\EsrCaseStudyHolderPage","ESR\\ESR\\Pages\\EsrCaseStudyPage","ESR\\ESR\\Pages\\EsrDeptPage","ESR\\ESR\\Pages\\EsrFeatureHolder","ESR\\ESR\\Pages\\EsrFeedDisplayPage","ESR\\ESR\\Pages\\EsrFullWidthPage","ESR\\ESR\\Pages\\EsrHolder","ESR\\ESR\\Pages\\EsrHomePage","ESR\\ESR\\Pages\\EsrPage","ESR\\ESR\\Pages\\EsrProfileHolderPage","ESR\\ESR\\Pages\\EsrProfilePage","ESR\\ESR\\Pages\\EsrSectionPage","Strmix\\Strmix\\Pages\\StrmixCookiePolicyPage","Strmix\\Strmix\\Pages\\StrmixHomePage","Strmix\\Strmix\\Pages\\StrmixNewsHolder","Strmix\\Strmix\\Pages\\StrmixNewsPage","Strmix\\Strmix\\Pages\\StrmixPage"]"
"ID" => 36
"RecordClassName" => "SilverStripe\Subsites\Model\Subsite"
]
The following query took 0.0012s an returned 1 row(s)
Triggered by: SiteTreeSubsites->alternateSiteConfig:304 > Extension->invokeExtension:142 > SiteTree->getSiteConfig:1410 > SiteTree->canView:1212
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" = 36)
LIMIT
1
array:77 [
"ClassName" => "SilverStripe\SiteConfig\SiteConfig"
"LastEdited" => "2024-10-24 19:54:15"
"Created" => "2021-05-07 13:47:27"
"ReviewPeriodDays" => 0
"ReviewFrom" => "cwp@cloudmail.esr.cri.nz"
"ReviewSubject" => "Page(s) are due for content review"
"ReviewBody" => "<h2>Page(s) due for review</h2><p>There are $PagesCount pages that are due for review today by you.</p>"
"GACode" => "UA-5114971-29"
"FacebookURL" => null
"TwitterUsername" => null
"FooterLogoLink" => null
"FooterLogoDescription" => null
"FooterLogoSecondaryLink" => "https://www.esr.cri.nz"
"FooterLogoSecondaryDescription" => null
"EmptySearch" => null
"NoSearchResults" => null
"MainFontFamily" => "fira-sans"
"HeaderBackground" => "oasis"
"NavigationBarBackground" => "oasis"
"CarouselBackground" => "white"
"FooterBackground" => "rodeo-dust"
"AccentColor" => "vivid-pink"
"TextLinkColor" => "default-accent"
"CookieConsentTitle" => null
"CookieConsentContent" => null
"FacebookPixelID" => "1747838755393077"
"CustAlertTitle" => "To find out how the planned stri"
"CustAlertType" => "grass"
"CustAlertBody" => "<p>To find out how the planned strike action could affect sample collection, please click <a href="https://www.wellkiwis.co.nz/providing-blood-samples/scl-collection/">here</a>.</p>"
"CustAlertToggle" => 1
"RedirectAllSiteTrafficTo" => null
"NoIndex" => 0
"MethCalcTimeoutThreshold" => null
"MethCalcRequestThreshold" => null
"MethCalcWhitelist" => null
"MethCalcSwabAreaDesc" => null
"MethCalcRoomAreaDesc" => null
"MethCalcTestValueDesc" => null
"MethCalcUserTypeDesc" => null
"MethCalcDescription" => null
"MethCalcDisclaimer" => null
"MethCalcGTA" => null
"MethCalcGTM" => null
"IncludeSearch" => 0
"ContactTitle" => "Contact us"
"ContactText" => null
"ContactEmail" => "wellkiwis@esr.cri.nz"
"ContactPhone" => "0800 493555 (08004WELLKIWI)"
"HideContact" => 1
"LinkedinID" => null
"YoutubeURL" => null
"InstagramURL" => "wellkiwis"
"CopyrightText" => "<p><span>© 2023 Wellkiwis</span></p>"
"CopyrightLink" => null
"EnableNewFooter" => 1
"FooterColor" => null
"Title" => "Wellkiwis"
"Tagline" => null
"CanViewType" => "Anyone"
"CanEditType" => "LoggedInUsers"
"CanCreateTopLevelType" => "LoggedInUsers"
"SubsiteID" => 36
"LogoID" => 6506
"LogoRetinaID" => 0
"FooterLogoID" => 6521
"FooterLogoRetinaID" => 0
"FooterLogoSecondaryID" => 8355
"FavIconID" => 0
"AppleTouchIcon144ID" => 0
"AppleTouchIcon114ID" => 0
"AppleTouchIcon72ID" => 0
"AppleTouchIcon57ID" => 0
"WellKiwisLinkID" => 0
"MethCalcLogoID" => 0
"ContactLinkID" => 0
"ID" => 43
"RecordClassName" => "SilverStripe\SiteConfig\SiteConfig"
]
The following query took 0.0013s an returned 1 row(s)
Triggered by: Subsite::currentSubsite:188 > PageController->init:30
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" = 36)
ORDER BY
"Subsite"."Title" ASC
LIMIT
1
array:12 [
"ClassName" => "SilverStripe\Subsites\Model\Subsite"
"LastEdited" => "2021-06-08 16:43:18"
"Created" => "2021-05-07 13:47:27"
"Title" => "Wellkiwis2021"
"RedirectURL" => null
"DefaultSite" => 0
"Theme" => "wellkiwis"
"Language" => "en_US"
"IsPublic" => 1
"PageTypeBlacklist" => "["ESR\\ESR\\Pages\\EsrNewsHolder","ESR\\ESR\\Pages\\EsrPublicationPage","ESR\\ESR\\Pages\\EsrPublicationHolder","ESR\\ESR\\Pages\\EsrCaseStudyHolderPage","ESR\\ESR\\Pages\\EsrCaseStudyPage","ESR\\ESR\\Pages\\EsrDeptPage","ESR\\ESR\\Pages\\EsrFeatureHolder","ESR\\ESR\\Pages\\EsrFeedDisplayPage","ESR\\ESR\\Pages\\EsrFullWidthPage","ESR\\ESR\\Pages\\EsrHolder","ESR\\ESR\\Pages\\EsrHomePage","ESR\\ESR\\Pages\\EsrPage","ESR\\ESR\\Pages\\EsrProfileHolderPage","ESR\\ESR\\Pages\\EsrProfilePage","ESR\\ESR\\Pages\\EsrSectionPage","Strmix\\Strmix\\Pages\\StrmixCookiePolicyPage","Strmix\\Strmix\\Pages\\StrmixHomePage","Strmix\\Strmix\\Pages\\StrmixNewsHolder","Strmix\\Strmix\\Pages\\StrmixNewsPage","Strmix\\Strmix\\Pages\\StrmixPage"]"
"ID" => 36
"RecordClassName" => "SilverStripe\Subsites\Model\Subsite"
]
The following query took 0.0016s an returned 1 row(s)
Triggered by: SiteConfig::current_site_config:342 > PageController->init:43
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 (36)
)
LIMIT
1
array:77 [
"ClassName" => "SilverStripe\SiteConfig\SiteConfig"
"LastEdited" => "2024-10-24 19:54:15"
"Created" => "2021-05-07 13:47:27"
"ReviewPeriodDays" => 0
"ReviewFrom" => "cwp@cloudmail.esr.cri.nz"
"ReviewSubject" => "Page(s) are due for content review"
"ReviewBody" => "<h2>Page(s) due for review</h2><p>There are $PagesCount pages that are due for review today by you.</p>"
"GACode" => "UA-5114971-29"
"FacebookURL" => null
"TwitterUsername" => null
"FooterLogoLink" => null
"FooterLogoDescription" => null
"FooterLogoSecondaryLink" => "https://www.esr.cri.nz"
"FooterLogoSecondaryDescription" => null
"EmptySearch" => null
"NoSearchResults" => null
"MainFontFamily" => "fira-sans"
"HeaderBackground" => "oasis"
"NavigationBarBackground" => "oasis"
"CarouselBackground" => "white"
"FooterBackground" => "rodeo-dust"
"AccentColor" => "vivid-pink"
"TextLinkColor" => "default-accent"
"CookieConsentTitle" => null
"CookieConsentContent" => null
"FacebookPixelID" => "1747838755393077"
"CustAlertTitle" => "To find out how the planned stri"
"CustAlertType" => "grass"
"CustAlertBody" => "<p>To find out how the planned strike action could affect sample collection, please click <a href="https://www.wellkiwis.co.nz/providing-blood-samples/scl-collection/">here</a>.</p>"
"CustAlertToggle" => 1
"RedirectAllSiteTrafficTo" => null
"NoIndex" => 0
"MethCalcTimeoutThreshold" => null
"MethCalcRequestThreshold" => null
"MethCalcWhitelist" => null
"MethCalcSwabAreaDesc" => null
"MethCalcRoomAreaDesc" => null
"MethCalcTestValueDesc" => null
"MethCalcUserTypeDesc" => null
"MethCalcDescription" => null
"MethCalcDisclaimer" => null
"MethCalcGTA" => null
"MethCalcGTM" => null
"IncludeSearch" => 0
"ContactTitle" => "Contact us"
"ContactText" => null
"ContactEmail" => "wellkiwis@esr.cri.nz"
"ContactPhone" => "0800 493555 (08004WELLKIWI)"
"HideContact" => 1
"LinkedinID" => null
"YoutubeURL" => null
"InstagramURL" => "wellkiwis"
"CopyrightText" => "<p><span>© 2023 Wellkiwis</span></p>"
"CopyrightLink" => null
"EnableNewFooter" => 1
"FooterColor" => null
"Title" => "Wellkiwis"
"Tagline" => null
"CanViewType" => "Anyone"
"CanEditType" => "LoggedInUsers"
"CanCreateTopLevelType" => "LoggedInUsers"
"SubsiteID" => 36
"LogoID" => 6506
"LogoRetinaID" => 0
"FooterLogoID" => 6521
"FooterLogoRetinaID" => 0
"FooterLogoSecondaryID" => 8355
"FavIconID" => 0
"AppleTouchIcon144ID" => 0
"AppleTouchIcon114ID" => 0
"AppleTouchIcon72ID" => 0
"AppleTouchIcon57ID" => 0
"WellKiwisLinkID" => 0
"MethCalcLogoID" => 0
"ContactLinkID" => 0
"ID" => 43
"RecordClassName" => "SilverStripe\SiteConfig\SiteConfig"
]
The following query took 0.0021s an returned 0 row(s)
Triggered by: Hierarchy->Children:207 > ContentController->getMenu:279
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" = 3300
)
AND (
"SiteTree_Live"."ShowInMenus" = 1
)
AND (
"SiteTree_Live"."SubsiteID" IN (36)
)
ORDER BY
"SiteTree_Live"."Sort" ASC
The following query took 0.0016s an returned 1 row(s)
Triggered by: Header.ss > Page.ss > Controller->handleAction:290
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" = 6506)
AND (
"File_Live"."ClassName" IN ('SilverStripe\\Assets\\Image')
)
ORDER BY
"File_Live"."Name" ASC
LIMIT
1
array:19 [
"ClassName" => "SilverStripe\Assets\Image"
"LastEdited" => "2024-10-20 23:36:22"
"Created" => "2019-09-02 11:09:05"
"Version" => 16
"UserFormUpload" => "f"
"HasMigratedAndExists" => 1
"CanViewType" => "Inherit"
"CanEditType" => "Inherit"
"Name" => "Wellkiwis-logo-for-website-2-v2.png"
"Title" => "Wellkiwis logo for website 2 v2"
"ShowInSearch" => 1
"SubsiteID" => 0
"ParentID" => 6489
"OwnerID" => 161
"FileHash" => "e65b74a3e82a32ab141dd5cd44d171aea1a97b13"
"FileFilename" => "Uploads/Wellkiwis-logo-for-website-2-v2.png"
"FileVariant" => null
"ID" => 6506
"RecordClassName" => "SilverStripe\Assets\Image"
]
The following query took 0.0024s an returned 1 row(s)
Triggered by: MainNav.ss > Page.ss > Controller->handleAction:290
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 (
'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'
)
)
AND (
"SiteTree_Live"."SubsiteID" IN (36)
)
array:1 [
"MAX("SiteTree_Live"."LastEdited")" => "2024-10-23 20:22:48"
]
The following query took 0.0032s an returned 1 row(s)
Triggered by: WellkiwisHeroBanner.ss > Page.ss > Page.ss > Controller->handleAction:290
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" = 3300)
AND (
"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'
)
)
ORDER BY
"SiteTree_Live"."Sort" ASC
LIMIT
1
array:23 [
"ClassName" => "Page"
"LastEdited" => "2024-07-12 13:38:20"
"Created" => "2023-03-13 15:11:12"
"Intro" => null
"TeReoMenuTitle" => null
"AddInfoTitle" => null
"AdditionalInformation" => null
"RightMenuTitle" => null
"RightHandMenu" => null
"RightMenuVideo" => null
"AddInfoVideo" => null
"InFooter" => 0
"HideTitle" => 0
"HideInThisSection" => 0
"DisableRichLinks" => 0
"ElementalAreaID" => 2065
"AddInfoImageID" => 0
"RightMenuImageID" => 0
"HeroImageID" => 0
"HeroImageMobileID" => 0
"ID" => 3300
"RecordClassName" => "Page"
"Sort" => 8
]
The following query took 0.0016s an returned 1 row(s)
Triggered by: Page.ss > Page.ss > Controller->handleAction:290
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" = 2065)
LIMIT
1
array:8 [
"ClassName" => "DNADesign\Elemental\Models\ElementalArea"
"LastEdited" => "2023-03-14 11:53:06"
"Created" => "2023-03-13 15:11:12"
"Version" => 2
"OwnerClassName" => "Page"
"TopPageID" => 0
"ID" => 2065
"RecordClassName" => "DNADesign\Elemental\Models\ElementalArea"
]
The following query took 0.0021s an returned 1 row(s)
Triggered by: ElementalArea->ElementControllers:175 > ElementalArea.ss > ElementalArea->forTemplate:99 > Page.ss > Page.ss > Controller->handleAction:290
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" = 2065)
ORDER BY
"Element_Live"."Sort" ASC
array:13 [
"ClassName" => "DNADesign\Elemental\Models\ElementContent"
"LastEdited" => "2024-07-12 13:38:20"
"Created" => "2023-03-13 15:11:40"
"Version" => 33
"Title" => null
"ShowTitle" => 0
"Sort" => 1
"ExtraClass" => null
"Style" => null
"TopPageID" => 0
"ParentID" => 2065
"ID" => 2375
"RecordClassName" => "DNADesign\Elemental\Models\ElementContent"
]
The following query took 0.0013s an returned 1 row(s)
Triggered by: BaseElement->getPage:709 > BaseElement->canView:231 > ElementalArea->DNADesign\Elemental\Models\{closure}:176 > ElementalArea->ElementControllers:175
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" = 2065)
LIMIT
1
array:8 [
"ClassName" => "DNADesign\Elemental\Models\ElementalArea"
"LastEdited" => "2023-03-14 11:53:06"
"Created" => "2023-03-13 15:11:12"
"Version" => 2
"OwnerClassName" => "Page"
"TopPageID" => 0
"ID" => 2065
"RecordClassName" => "DNADesign\Elemental\Models\ElementalArea"
]
The following query took 0.0029s an returned 1 row(s)
Triggered by: ElementalArea->getOwnerPage:221 > BaseElement->getPage:712 > BaseElement->canView:231 > ElementalArea->DNADesign\Elemental\Models\{closure}:176
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" = 2065
)
AND (
"SiteTree_Live"."ClassName" = 'Page'
)
AND (
"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'
)
)
AND (
"SiteTree_Live"."SubsiteID" IN (36)
)
ORDER BY
"SiteTree_Live"."Sort" ASC
LIMIT
1
array:54 [
"ClassName" => "Page"
"LastEdited" => "2024-07-12 13:38:20"
"Created" => "2023-03-13 15:11:12"
"Priority" => null
"ShareTokenSalt" => null
"ContentReviewType" => "Inherit"
"ReviewPeriodDays" => 0
"NextReviewDate" => null
"LastEditedByName" => "Ruth Seeds"
"OwnerNames" => null
"ProvideComments" => 0
"ModerationRequired" => "None"
"CommentsRequireLogin" => 0
"ShowPageUtilities" => 0
"AlgoliaIndexed" => null
"AlgoliaError" => null
"AlgoliaUUID" => null
"CanViewType" => "Inherit"
"CanEditType" => "Inherit"
"Version" => 24
"URLSegment" => "weekly-surveys"
"Title" => "Weekly Survey"
"MenuTitle" => null
"Content" => null
"MetaDescription" => null
"ExtraMeta" => null
"ShowInMenus" => 1
"ShowInSearch" => 1
"Sort" => 8
"HasBrokenFile" => 0
"HasBrokenLink" => 0
"ReportClass" => null
"WorkflowDefinitionID" => 0
"SubsiteID" => 36
"ParentID" => 0
"Intro" => null
"TeReoMenuTitle" => null
"AddInfoTitle" => null
"AdditionalInformation" => null
"RightMenuTitle" => null
"RightHandMenu" => null
"RightMenuVideo" => null
"AddInfoVideo" => null
"InFooter" => 0
"HideTitle" => 0
"HideInThisSection" => 0
"DisableRichLinks" => 0
"ElementalAreaID" => 2065
"AddInfoImageID" => 0
"RightMenuImageID" => 0
"HeroImageID" => 0
"HeroImageMobileID" => 0
"ID" => 3300
"RecordClassName" => "Page"
]
The following query took 0.003s an returned 1 row(s)
Triggered by: BaseElement->getAreaRelationName:978 > BaseElement->getRenderTemplates:641 > BaseElement->forTemplate:607 > ElementHolder.ss > ElementController->forTemplate:87
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" = 2065)
LIMIT
1
array:8 [
"ClassName" => "DNADesign\Elemental\Models\ElementalArea"
"LastEdited" => "2023-03-14 11:53:06"
"Created" => "2023-03-13 15:11:12"
"Version" => 2
"OwnerClassName" => "Page"
"TopPageID" => 0
"ID" => 2065
"RecordClassName" => "DNADesign\Elemental\Models\ElementalArea"
]
The following query took 0.0017s an returned 1 row(s)
Triggered by: ElementContent.ss > BaseElement->forTemplate:610 > ElementHolder.ss > ElementController->forTemplate:87
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" = 2375)
AND (
"Element_Live"."ClassName" IN (
'DNADesign\\Elemental\\Models\\ElementContent',
'Strmix\\Strmix\\Element\\ElementColumns',
'Intelligence\\Intelligence\\Element\\ElementNewsPreview',
'Intelligence\\Intelligence\\Element\\ElementRelatedLinks',
'Intelligence\\Intelligence\\Element\\ElementTiles'
)
)
ORDER BY
"Element_Live"."Sort" ASC
LIMIT
1
array:7 [
"ClassName" => "DNADesign\Elemental\Models\ElementContent"
"LastEdited" => "2024-07-12 13:38:20"
"Created" => "2023-03-13 15:11:40"
"HTML" => """
<p>You will receive weekly surveys during the flu season only (usually April - September). Every Sunday, you will receive a link via text or email, whichever you have chosen as your preference. Please click the link to answer the survey questions.</p>\n
<p>You will be asked the question,<em> "Have you experienced any influenza-like illness (ILI) symptoms (such as fever, cough or running nose etc.) within the last week."</em></p>\n
<h5>Steps to completing your WellKiwis weekly survey:</h5>\n
<p><strong>1. Weekly survey link sent on Sunday, reminder sent on Wednesday</strong><br>Please complete the survey at least once per week (preferably Sunday) as it is important for us to receive your Yes/No response to estimate the weekly influenza-like illness rate. A reminder is sent on Wednesday only to those who have not completed the first survey sent on Sunday.<br><strong>2. Complete the survey as soon as symptoms appear<br></strong>Answering the survey questions as quickly and accurately as possible after symptoms appear, helps us identify if you may need to self-swab, which in turn means we can test for any potential viruses that may be making you unwell. <br><strong>3. Update the survey at any time<br></strong>You can update your survey multiple times within a week using the most recent survey link. For example, if you feel fine on Sunday and complete your survey to report no symptoms, but on Tuesday you wake with a cough and headache, you can use the most recent survey link to complete the survey again on Tuesday (or as soon as possible after you feel unwell). <br><strong>4. WellKiwis Clinical team will look over your completed survey</strong><br>If you answered yes to influenza-like illness symptoms, our Clinical team will assess your survey responses and determine if they need to call you, and whether you need to do a swab.<br><strong>5. Repeat weekly survey process</strong><br>This process is completed weekly until the end of the flu season (end of September).</p>\n
<h5><strong>SMS Access Codes</strong></h5>\n
<p>If you have opted to receive your weekly survey by SMS, you may be asked for an access code in order to complete the survey. If this happens, please contact the WellKiwis team and we can confirm your code. </p>\n
<p>The request for the code is an intermittent issue with SMS and means a different code will be generated each time. This doesn't happen when the survey link goes out via email, so if you'd like to change from SMS to email, please contact the WellKiwis team and we can do this for you - just let us know.</p>\n
<table class=" left" style="height: 340px; width: 100.18%; border-collapse: collapse; border-style: solid;" height="340">\n
<tbody>\n
<tr>\n
<td class="text-left" style="width: 100%; border-style: solid; vertical-align: top;">\n
<h4>Filling in the weekly survey as a WellKiwis Household representative</h4>\n
<p><span class="text-left">If you're the household representative, the process is slightly different as you will be sent the survey link for yourself and the survey link(s) for those you represent in the household. You will be asked the following question:</span><br><br><em><span class="text-left">“Have you or a member of your household experienced any influenza-like illness (ILI) symptoms (such as fever, cough or running nose etc.) within the last week?"</span></em><br><br><span class="text-left"><strong>By answering no</strong> on your survey, you are responding on behalf of yourself and the household members you represent, and <strong>you only need to fill in one survey link per week.</strong> </span></p>\n
<p><span class="text-left"><strong>If you answer yes</strong> to your survey, you also need to<strong> complete the survey for those who also have symptoms.</strong></span><br><br><span class="text-left">For example, if you are the household representative for three children but only one has symptoms, then only complete your personal survey and the survey for the child who has symptoms.</span></p>\n
<p><span class="text-left">You can update your survey at any time during the week if circumstances change. Please use the most recent survey link to complete the survey as soon as possible after symptoms start.</span></p>\n
</td>\n
</tr>\n
</tbody>\n
</table>\n
<p> </p>
"""
"ID" => 2375
"RecordClassName" => "DNADesign\Elemental\Models\ElementContent"
"Sort" => 1
]
The following query took 0.003s an returned 1 row(s)
Triggered by: RelatedPages.ss > Page.ss > Page.ss > Controller->handleAction:290
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" = 3300
)
) AS "BasePage_RelatedPages" ON "BasePage_RelatedPages"."ChildID" = "SiteTree_Live"."ID"
WHERE
(
"SiteTree_Live"."ClassName" IN (
'CWP\\CWP\\PageTypes\\BasePage',
'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'
)
)
AND (
"SiteTree_Live"."SubsiteID" IN (36)
)
) THEN
1
ELSE
0
END
array:1 [
"CASE WHEN EXISTS(SELECT *\n FROM "SiteTree_Live" INNER JOIN (SELECT DISTINCT "BasePage_RelatedPages_Live"."ClassName", "BasePage_RelatedPages_Live"."LastEdited", "BasePage_RelatedPages_Live"."Created", "BasePage_RelatedPages_Live"."Version", "BasePage_Relat" => 0
]
The following query took 0.0021s an returned 1 row(s)
Triggered by: Footer.ss > Page.ss > Controller->handleAction:290
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 (
'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'
)
)
AND (
"SiteTree_Live"."SubsiteID" IN (36)
)
array:1 [
"MAX("SiteTree_Live"."LastEdited")" => "2024-10-23 20:22:48"
]
The following query took 0.0018s an returned 1 row(s)
Triggered by: Versioned::determineVersionNumberByStage:2432 > Versioned::get_versionnumber_by_stage:2396 > Versioned->isOnDraft:2785 > Versioned->isArchived:2765
SELECT
"Version"
FROM
"SiteTree"
WHERE
"ID" = 3300
array:1 [
"Version" => 24
]
The following query took 0.0017s an returned 1 row(s)
Triggered by: SilverStripeNavigatorItem_LiveLink->getLivePage:87 > SilverStripeNavigatorItem_LiveLink->canView:63 > SilverStripeNavigator->getItems:57 > BetterNavigatorExtension->generateNavigator:92
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" = 3300)
ORDER BY
"SiteTree_Live"."Sort" ASC
LIMIT
1
array:37 [
"ClassName" => "Page"
"LastEdited" => "2024-07-12 13:38:20"
"Created" => "2023-03-13 15:11:12"
"Priority" => null
"ShareTokenSalt" => null
"ContentReviewType" => "Inherit"
"ReviewPeriodDays" => 0
"NextReviewDate" => null
"LastEditedByName" => "Ruth Seeds"
"OwnerNames" => null
"ProvideComments" => 0
"ModerationRequired" => "None"
"CommentsRequireLogin" => 0
"ShowPageUtilities" => 0
"AlgoliaIndexed" => null
"AlgoliaError" => null
"AlgoliaUUID" => null
"CanViewType" => "Inherit"
"CanEditType" => "Inherit"
"Version" => 24
"URLSegment" => "weekly-surveys"
"Title" => "Weekly Survey"
"MenuTitle" => null
"Content" => null
"MetaDescription" => null
"ExtraMeta" => null
"ShowInMenus" => 1
"ShowInSearch" => 1
"Sort" => 8
"HasBrokenFile" => 0
"HasBrokenLink" => 0
"ReportClass" => null
"WorkflowDefinitionID" => 0
"SubsiteID" => 36
"ParentID" => 0
"ID" => 3300
"RecordClassName" => "Page"
]
The following query took 0.002s an returned 1 row(s)
Triggered by: SilverStripeNavigatorItem_LiveLink->getLivePage:87 > SilverStripeNavigatorItem_LiveLink->getLink:51 > SilverStripeNavigatorItem_LiveLink->canView:64 > SilverStripeNavigator->getItems:57
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" = 3300)
ORDER BY
"SiteTree_Live"."Sort" ASC
LIMIT
1
array:37 [
"ClassName" => "Page"
"LastEdited" => "2024-07-12 13:38:20"
"Created" => "2023-03-13 15:11:12"
"Priority" => null
"ShareTokenSalt" => null
"ContentReviewType" => "Inherit"
"ReviewPeriodDays" => 0
"NextReviewDate" => null
"LastEditedByName" => "Ruth Seeds"
"OwnerNames" => null
"ProvideComments" => 0
"ModerationRequired" => "None"
"CommentsRequireLogin" => 0
"ShowPageUtilities" => 0
"AlgoliaIndexed" => null
"AlgoliaError" => null
"AlgoliaUUID" => null
"CanViewType" => "Inherit"
"CanEditType" => "Inherit"
"Version" => 24
"URLSegment" => "weekly-surveys"
"Title" => "Weekly Survey"
"MenuTitle" => null
"Content" => null
"MetaDescription" => null
"ExtraMeta" => null
"ShowInMenus" => 1
"ShowInSearch" => 1
"Sort" => 8
"HasBrokenFile" => 0
"HasBrokenLink" => 0
"ReportClass" => null
"WorkflowDefinitionID" => 0
"SubsiteID" => 36
"ParentID" => 0
"ID" => 3300
"RecordClassName" => "Page"
]
The following query took 0.0018s an returned 1 row(s)
Triggered by: SiteTreeSubsites->alternateAbsoluteLink:428 > SiteTree->AbsoluteLink:671 > SiteTree->PreviewLink:686 > SilverStripeNavigatorItem_LiveLink->getLink:51
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" = 36)
ORDER BY
"Subsite"."Title" ASC
LIMIT
1
array:12 [
"ClassName" => "SilverStripe\Subsites\Model\Subsite"
"LastEdited" => "2021-06-08 16:43:18"
"Created" => "2021-05-07 13:47:27"
"Title" => "Wellkiwis2021"
"RedirectURL" => null
"DefaultSite" => 0
"Theme" => "wellkiwis"
"Language" => "en_US"
"IsPublic" => 1
"PageTypeBlacklist" => "["ESR\\ESR\\Pages\\EsrNewsHolder","ESR\\ESR\\Pages\\EsrPublicationPage","ESR\\ESR\\Pages\\EsrPublicationHolder","ESR\\ESR\\Pages\\EsrCaseStudyHolderPage","ESR\\ESR\\Pages\\EsrCaseStudyPage","ESR\\ESR\\Pages\\EsrDeptPage","ESR\\ESR\\Pages\\EsrFeatureHolder","ESR\\ESR\\Pages\\EsrFeedDisplayPage","ESR\\ESR\\Pages\\EsrFullWidthPage","ESR\\ESR\\Pages\\EsrHolder","ESR\\ESR\\Pages\\EsrHomePage","ESR\\ESR\\Pages\\EsrPage","ESR\\ESR\\Pages\\EsrProfileHolderPage","ESR\\ESR\\Pages\\EsrProfilePage","ESR\\ESR\\Pages\\EsrSectionPage","Strmix\\Strmix\\Pages\\StrmixCookiePolicyPage","Strmix\\Strmix\\Pages\\StrmixHomePage","Strmix\\Strmix\\Pages\\StrmixNewsHolder","Strmix\\Strmix\\Pages\\StrmixNewsPage","Strmix\\Strmix\\Pages\\StrmixPage"]"
"ID" => 36
"RecordClassName" => "SilverStripe\Subsites\Model\Subsite"
]
The following query took 0.0013s an returned 1 row(s)
Triggered by: Subsite->getPrimarySubsiteDomain:874 > Subsite->domain:855 > SiteTreeSubsites->alternateAbsoluteLink:428 > SiteTree->AbsoluteLink:671
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" = 36)
ORDER BY
"SubsiteDomain"."IsPrimary" DESC
LIMIT
1
array:9 [
"ClassName" => "SilverStripe\Subsites\Model\SubsiteDomain"
"LastEdited" => "2024-12-03 00:10:31"
"Created" => "2024-12-03 00:10:31"
"Domain" => "www.wellkiwis.co.nz"
"Protocol" => "automatic"
"IsPrimary" => 1
"SubsiteID" => 36
"ID" => 81
"RecordClassName" => "SilverStripe\Subsites\Model\SubsiteDomain"
]
The following query took 0.0013s an returned 1 row(s)
Triggered by: SilverStripeNavigatorItem_StageLink->getDraftPage:94 > SilverStripeNavigatorItem_StageLink->canView:70 > SilverStripeNavigator->getItems:57 > BetterNavigatorExtension->generateNavigator:92
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" = 3300)
ORDER BY
"SiteTree"."Sort" ASC
LIMIT
1
array:37 [
"ClassName" => "Page"
"LastEdited" => "2024-07-12 13:38:20"
"Created" => "2023-03-13 15:11:12"
"Priority" => null
"ShareTokenSalt" => null
"ContentReviewType" => "Inherit"
"ReviewPeriodDays" => 0
"NextReviewDate" => null
"LastEditedByName" => "Ruth Seeds"
"OwnerNames" => null
"ProvideComments" => 0
"ModerationRequired" => "None"
"CommentsRequireLogin" => 0
"ShowPageUtilities" => 0
"AlgoliaIndexed" => null
"AlgoliaError" => null
"AlgoliaUUID" => null
"CanViewType" => "Inherit"
"CanEditType" => "Inherit"
"Version" => 24
"URLSegment" => "weekly-surveys"
"Title" => "Weekly Survey"
"MenuTitle" => null
"Content" => null
"MetaDescription" => null
"ExtraMeta" => null
"ShowInMenus" => 1
"ShowInSearch" => 1
"Sort" => 8
"HasBrokenFile" => 0
"HasBrokenLink" => 0
"ReportClass" => null
"WorkflowDefinitionID" => 0
"SubsiteID" => 36
"ParentID" => 0
"ID" => 3300
"RecordClassName" => "Page"
]
The following query took 0.002s an returned 1 row(s)
Triggered by: SiteTreeSubsites->alternateAbsoluteLink:428 > SiteTree->AbsoluteLink:671 > SiteTree->PreviewLink:686 > SilverStripeNavigatorItem_StageLink->getLink:51
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" = 36)
ORDER BY
"Subsite"."Title" ASC
LIMIT
1
array:12 [
"ClassName" => "SilverStripe\Subsites\Model\Subsite"
"LastEdited" => "2021-06-08 16:43:18"
"Created" => "2021-05-07 13:47:27"
"Title" => "Wellkiwis2021"
"RedirectURL" => null
"DefaultSite" => 0
"Theme" => "wellkiwis"
"Language" => "en_US"
"IsPublic" => 1
"PageTypeBlacklist" => "["ESR\\ESR\\Pages\\EsrNewsHolder","ESR\\ESR\\Pages\\EsrPublicationPage","ESR\\ESR\\Pages\\EsrPublicationHolder","ESR\\ESR\\Pages\\EsrCaseStudyHolderPage","ESR\\ESR\\Pages\\EsrCaseStudyPage","ESR\\ESR\\Pages\\EsrDeptPage","ESR\\ESR\\Pages\\EsrFeatureHolder","ESR\\ESR\\Pages\\EsrFeedDisplayPage","ESR\\ESR\\Pages\\EsrFullWidthPage","ESR\\ESR\\Pages\\EsrHolder","ESR\\ESR\\Pages\\EsrHomePage","ESR\\ESR\\Pages\\EsrPage","ESR\\ESR\\Pages\\EsrProfileHolderPage","ESR\\ESR\\Pages\\EsrProfilePage","ESR\\ESR\\Pages\\EsrSectionPage","Strmix\\Strmix\\Pages\\StrmixCookiePolicyPage","Strmix\\Strmix\\Pages\\StrmixHomePage","Strmix\\Strmix\\Pages\\StrmixNewsHolder","Strmix\\Strmix\\Pages\\StrmixNewsPage","Strmix\\Strmix\\Pages\\StrmixPage"]"
"ID" => 36
"RecordClassName" => "SilverStripe\Subsites\Model\Subsite"
]
The following query took 0.0011s an returned 1 row(s)
Triggered by: Subsite->getPrimarySubsiteDomain:874 > Subsite->domain:855 > SiteTreeSubsites->alternateAbsoluteLink:428 > SiteTree->AbsoluteLink:671
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" = 36)
ORDER BY
"SubsiteDomain"."IsPrimary" DESC
LIMIT
1
array:9 [
"ClassName" => "SilverStripe\Subsites\Model\SubsiteDomain"
"LastEdited" => "2024-12-03 00:10:31"
"Created" => "2024-12-03 00:10:31"
"Domain" => "www.wellkiwis.co.nz"
"Protocol" => "automatic"
"IsPrimary" => 1
"SubsiteID" => 36
"ID" => 81
"RecordClassName" => "SilverStripe\Subsites\Model\SubsiteDomain"
]
The following query took 0.0019s an returned 1 row(s)
Triggered by: Subsite->getPrimarySubsiteDomain:874 > Subsite->domain:855 > SiteTreeSubsites->alternateAbsoluteLink:428 > SiteTree->AbsoluteLink:671
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" = 36)
ORDER BY
"SubsiteDomain"."IsPrimary" DESC
LIMIT
1
array:9 [
"ClassName" => "SilverStripe\Subsites\Model\SubsiteDomain"
"LastEdited" => "2024-12-03 00:10:31"
"Created" => "2024-12-03 00:10:31"
"Domain" => "www.wellkiwis.co.nz"
"Protocol" => "automatic"
"IsPrimary" => 1
"SubsiteID" => 36
"ID" => 81
"RecordClassName" => "SilverStripe\Subsites\Model\SubsiteDomain"
]
The following query took 0.0012s an returned 1 row(s)
Triggered by: SilverStripeNavigatorItem_LiveLink->getLivePage:87 > SilverStripeNavigatorItem_LiveLink->getLink:51 > BetterNavigatorExtension->generateNavigator:97 > BetterNavigatorExtension->afterCallActionHandler:51
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" = 3300)
ORDER BY
"SiteTree_Live"."Sort" ASC
LIMIT
1
array:37 [
"ClassName" => "Page"
"LastEdited" => "2024-07-12 13:38:20"
"Created" => "2023-03-13 15:11:12"
"Priority" => null
"ShareTokenSalt" => null
"ContentReviewType" => "Inherit"
"ReviewPeriodDays" => 0
"NextReviewDate" => null
"LastEditedByName" => "Ruth Seeds"
"OwnerNames" => null
"ProvideComments" => 0
"ModerationRequired" => "None"
"CommentsRequireLogin" => 0
"ShowPageUtilities" => 0
"AlgoliaIndexed" => null
"AlgoliaError" => null
"AlgoliaUUID" => null
"CanViewType" => "Inherit"
"CanEditType" => "Inherit"
"Version" => 24
"URLSegment" => "weekly-surveys"
"Title" => "Weekly Survey"
"MenuTitle" => null
"Content" => null
"MetaDescription" => null
"ExtraMeta" => null
"ShowInMenus" => 1
"ShowInSearch" => 1
"Sort" => 8
"HasBrokenFile" => 0
"HasBrokenLink" => 0
"ReportClass" => null
"WorkflowDefinitionID" => 0
"SubsiteID" => 36
"ParentID" => 0
"ID" => 3300
"RecordClassName" => "Page"
]
The following query took 0.0013s an returned 1 row(s)
Triggered by: SiteTreeSubsites->alternateAbsoluteLink:428 > SiteTree->AbsoluteLink:671 > SiteTree->PreviewLink:686 > SilverStripeNavigatorItem_LiveLink->getLink:51
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" = 36)
ORDER BY
"Subsite"."Title" ASC
LIMIT
1
array:12 [
"ClassName" => "SilverStripe\Subsites\Model\Subsite"
"LastEdited" => "2021-06-08 16:43:18"
"Created" => "2021-05-07 13:47:27"
"Title" => "Wellkiwis2021"
"RedirectURL" => null
"DefaultSite" => 0
"Theme" => "wellkiwis"
"Language" => "en_US"
"IsPublic" => 1
"PageTypeBlacklist" => "["ESR\\ESR\\Pages\\EsrNewsHolder","ESR\\ESR\\Pages\\EsrPublicationPage","ESR\\ESR\\Pages\\EsrPublicationHolder","ESR\\ESR\\Pages\\EsrCaseStudyHolderPage","ESR\\ESR\\Pages\\EsrCaseStudyPage","ESR\\ESR\\Pages\\EsrDeptPage","ESR\\ESR\\Pages\\EsrFeatureHolder","ESR\\ESR\\Pages\\EsrFeedDisplayPage","ESR\\ESR\\Pages\\EsrFullWidthPage","ESR\\ESR\\Pages\\EsrHolder","ESR\\ESR\\Pages\\EsrHomePage","ESR\\ESR\\Pages\\EsrPage","ESR\\ESR\\Pages\\EsrProfileHolderPage","ESR\\ESR\\Pages\\EsrProfilePage","ESR\\ESR\\Pages\\EsrSectionPage","Strmix\\Strmix\\Pages\\StrmixCookiePolicyPage","Strmix\\Strmix\\Pages\\StrmixHomePage","Strmix\\Strmix\\Pages\\StrmixNewsHolder","Strmix\\Strmix\\Pages\\StrmixNewsPage","Strmix\\Strmix\\Pages\\StrmixPage"]"
"ID" => 36
"RecordClassName" => "SilverStripe\Subsites\Model\Subsite"
]
The following query took 0.0018s an returned 1 row(s)
Triggered by: Subsite->getPrimarySubsiteDomain:874 > Subsite->domain:855 > SiteTreeSubsites->alternateAbsoluteLink:428 > SiteTree->AbsoluteLink:671
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" = 36)
ORDER BY
"SubsiteDomain"."IsPrimary" DESC
LIMIT
1
array:9 [
"ClassName" => "SilverStripe\Subsites\Model\SubsiteDomain"
"LastEdited" => "2024-12-03 00:10:31"
"Created" => "2024-12-03 00:10:31"
"Domain" => "www.wellkiwis.co.nz"
"Protocol" => "automatic"
"IsPrimary" => 1
"SubsiteID" => 36
"ID" => 81
"RecordClassName" => "SilverStripe\Subsites\Model\SubsiteDomain"
]