The following query took 0.0044s 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.0008s 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.0017s 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.pulsenetinternational.org' LIKE replace(
      "SubsiteDomain"."Domain", '*', '%'
    )
  )

 array:1 [
  "Count" => 1
]

The following query took 0.0011s 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.pulsenetinternational.org' LIKE replace(
      "SubsiteDomain"."Domain", '*', '%'
    )
  )
ORDER BY
  "_SortColumn0" DESC

 array:2 [
  "SubsiteID" => 4
  "_SortColumn0" => 1
]

The following query took 0.0015s 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.pulsenetinternational.org' LIKE replace(
      "SubsiteDomain"."Domain", '*', '%'
    )
  )
ORDER BY
  "_SortColumn0" DESC

 array:2 [
  "Domain" => "test.pulsenetinternational.org"
  "_SortColumn0" => 1
]

The following query took 0.002s 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.0013s 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.0015s 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.0011s 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.0037s 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 (4)
  )
ORDER BY
  "SiteTree_Live"."Sort" ASC
LIMIT
  1

 array:37 [
  "ClassName" => "Page"
  "LastEdited" => "2023-11-07 07:51:22"
  "Created" => "2013-06-18 16:42:39"
  "Priority" => null
  "ShareTokenSalt" => null
  "ContentReviewType" => "Inherit"
  "ReviewPeriodDays" => 0
  "NextReviewDate" => null
  "LastEditedByName" => "Brent Gilpin"
  "OwnerNames" => null
  "ProvideComments" => 0
  "ModerationRequired" => "None"
  "CommentsRequireLogin" => 0
  "ShowPageUtilities" => 1
  "AlgoliaIndexed" => null
  "AlgoliaError" => null
  "AlgoliaUUID" => null
  "CanViewType" => "Inherit"
  "CanEditType" => "Inherit"
  "Version" => 36
  "URLSegment" => "home"
  "Title" => "PulseNet International"
  "MenuTitle" => "Home"
  "Content" => null
  "MetaDescription" => null
  "ExtraMeta" => null
  "ShowInMenus" => 1
  "ShowInSearch" => 1
  "Sort" => 1
  "HasBrokenFile" => 0
  "HasBrokenLink" => 0
  "ReportClass" => null
  "WorkflowDefinitionID" => 0
  "SubsiteID" => 4
  "ParentID" => 0
  "ID" => 34
  "RecordClassName" => "Page"
]

The following query took 0.0029s 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" = 4)
ORDER BY
  "Subsite"."Title" ASC
LIMIT
  1

 array:12 [
  "ClassName" => "SilverStripe\Subsites\Model\Subsite"
  "LastEdited" => "2013-09-20 11:33:40"
  "Created" => "2013-06-13 10:24:53"
  "Title" => "PulseNet Intl."
  "RedirectURL" => null
  "DefaultSite" => 0
  "Theme" => null
  "Language" => "en_GB"
  "IsPublic" => 1
  "PageTypeBlacklist" => null
  "ID" => 4
  "RecordClassName" => "SilverStripe\Subsites\Model\Subsite"
]

The following query took 0.0017s 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 (4)
  )
LIMIT
  1

 array:77 [
  "ClassName" => "SilverStripe\SiteConfig\SiteConfig"
  "LastEdited" => "2020-07-20 15:37:20"
  "Created" => "2013-06-13 10:27:19"
  "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-6"
  "FacebookURL" => "pages/Institute-of-Environmental-Science-and-Research/190262607674473"
  "TwitterUsername" => "esrnz"
  "FooterLogoLink" => null
  "FooterLogoDescription" => null
  "FooterLogoSecondaryLink" => null
  "FooterLogoSecondaryDescription" => null
  "EmptySearch" => null
  "NoSearchResults" => null
  "MainFontFamily" => "nunito-sans"
  "HeaderBackground" => "white"
  "NavigationBarBackground" => "white"
  "CarouselBackground" => "white"
  "FooterBackground" => "grey"
  "AccentColor" => "default-accent"
  "TextLinkColor" => "default-accent"
  "CookieConsentTitle" => null
  "CookieConsentContent" => null
  "FacebookPixelID" => null
  "CustAlertTitle" => null
  "CustAlertType" => "grass"
  "CustAlertBody" => null
  "CustAlertToggle" => 0
  "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" => null
  "ContactText" => null
  "ContactEmail" => null
  "ContactPhone" => null
  "HideContact" => 0
  "LinkedinID" => null
  "YoutubeURL" => null
  "InstagramURL" => null
  "CopyrightText" => null
  "CopyrightLink" => null
  "EnableNewFooter" => 0
  "FooterColor" => null
  "Title" => "PulseNet International"
  "Tagline" => null
  "CanViewType" => "Anyone"
  "CanEditType" => "OnlyTheseUsers"
  "CanCreateTopLevelType" => "LoggedInUsers"
  "SubsiteID" => 4
  "LogoID" => 7239
  "LogoRetinaID" => 0
  "FooterLogoID" => 0
  "FooterLogoRetinaID" => 0
  "FooterLogoSecondaryID" => 0
  "FavIconID" => 11
  "AppleTouchIcon144ID" => 0
  "AppleTouchIcon114ID" => 0
  "AppleTouchIcon72ID" => 0
  "AppleTouchIcon57ID" => 0
  "WellKiwisLinkID" => 0
  "MethCalcLogoID" => 0
  "ContactLinkID" => 0
  "ID" => 2
  "RecordClassName" => "SilverStripe\SiteConfig\SiteConfig"
]