The following query took 0.008s 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.0012s 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.0011s 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.001s 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.0014s 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.0019s 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.0009s 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.0014s 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.0012s 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.0065s 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" = 'home'
  )
  AND ("SiteTree_Live"."ParentID" = 0)
  AND (
    "SiteTree_Live"."SubsiteID" IN (36)
  )
ORDER BY
  "SiteTree_Live"."Sort" ASC
LIMIT
  1

 array:37 [
  "ClassName" => "HomePage"
  "LastEdited" => "2024-10-23 20:22:48"
  "Created" => "2021-05-07 13:47:27"
  "Priority" => null
  "ShareTokenSalt" => null
  "ContentReviewType" => "Inherit"
  "ReviewPeriodDays" => 0
  "NextReviewDate" => null
  "LastEditedByName" => "Default Admin "
  "OwnerNames" => null
  "ProvideComments" => 0
  "ModerationRequired" => "None"
  "CommentsRequireLogin" => 0
  "ShowPageUtilities" => 0
  "AlgoliaIndexed" => null
  "AlgoliaError" => null
  "AlgoliaUUID" => null
  "CanViewType" => "Inherit"
  "CanEditType" => "Inherit"
  "Version" => 67
  "URLSegment" => "home"
  "Title" => "Home"
  "MenuTitle" => null
  "Content" => "<p>Welcome to SilverStripe! This is the default homepage. You can edit this page by opening <a href="admin/">the CMS</a>.</p><p>You can now access the <a href="http://docs.silverstripe.org">developer documentation</a>, or begin the <a href="http://www.silverstripe.org/learn/lessons">SilverStripe lessons</a>.</p>"
  "MetaDescription" => "gwar5yhrrfdll99gymf56dctuh5nuw\r\n"
  "ExtraMeta" => "<meta name="facebook-domain-verification" content="gwar5yhrrfdll99gymf56dctuh5nuw">"
  "ShowInMenus" => 1
  "ShowInSearch" => 1
  "Sort" => 1
  "HasBrokenFile" => 0
  "HasBrokenLink" => 0
  "ReportClass" => null
  "WorkflowDefinitionID" => 0
  "SubsiteID" => 36
  "ParentID" => 0
  "ID" => 2783
  "RecordClassName" => "HomePage"
]

The following query took 0.0016s 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.0019s 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"
]