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.001s 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.0012s 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.0022s 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.0024s 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.0011s 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.0015s 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" = 'international'
)
AND ("SiteTree_Live"."ParentID" = 0)
AND (
"SiteTree_Live"."SubsiteID" IN (4)
)
ORDER BY
"SiteTree_Live"."Sort" ASC
LIMIT
1 array:37 [
"ClassName" => "Page"
"LastEdited" => "2019-08-30 15:55:47"
"Created" => "2013-06-19 09:47:18"
"Priority" => null
"ShareTokenSalt" => null
"ContentReviewType" => "Inherit"
"ReviewPeriodDays" => 0
"NextReviewDate" => null
"LastEditedByName" => "Elliot Sawyer"
"OwnerNames" => null
"ProvideComments" => 0
"ModerationRequired" => "None"
"CommentsRequireLogin" => 0
"ShowPageUtilities" => 1
"AlgoliaIndexed" => null
"AlgoliaError" => null
"AlgoliaUUID" => null
"CanViewType" => "Inherit"
"CanEditType" => "Inherit"
"Version" => 6
"URLSegment" => "international"
"Title" => "PulseNet International"
"MenuTitle" => "International"
"Content" => null
"MetaDescription" => null
"ExtraMeta" => null
"ShowInMenus" => 1
"ShowInSearch" => 1
"Sort" => 2
"HasBrokenFile" => 0
"HasBrokenLink" => 0
"ReportClass" => null
"WorkflowDefinitionID" => 0
"SubsiteID" => 4
"ParentID" => 0
"ID" => 120
"RecordClassName" => "Page"
]
The following query took 0.003s an returned 1 row(s)
Triggered by: ContentController->handleRequest:207
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" = 120)
AND (
"SiteTree_Live"."URLSegment" = 'pulsenetexplained'
)
AND (
"SiteTree_Live"."SubsiteID" IN (4)
)
ORDER BY
"SiteTree_Live"."Sort" ASC
LIMIT
1 array:37 [
"ClassName" => "Page"
"LastEdited" => "2019-08-30 15:55:53"
"Created" => "2013-06-19 09:47:23"
"Priority" => null
"ShareTokenSalt" => null
"ContentReviewType" => "Inherit"
"ReviewPeriodDays" => 0
"NextReviewDate" => null
"LastEditedByName" => "Elliot Sawyer"
"OwnerNames" => null
"ProvideComments" => 0
"ModerationRequired" => "None"
"CommentsRequireLogin" => 0
"ShowPageUtilities" => 1
"AlgoliaIndexed" => null
"AlgoliaError" => null
"AlgoliaUUID" => null
"CanViewType" => "Inherit"
"CanEditType" => "Inherit"
"Version" => 17
"URLSegment" => "pulsenetexplained"
"Title" => "PulseNet Explained"
"MenuTitle" => null
"Content" => null
"MetaDescription" => null
"ExtraMeta" => null
"ShowInMenus" => 1
"ShowInSearch" => 1
"Sort" => 7
"HasBrokenFile" => 0
"HasBrokenLink" => 1
"ReportClass" => null
"WorkflowDefinitionID" => 0
"SubsiteID" => 4
"ParentID" => 120
"ID" => 137
"RecordClassName" => "Page"
]
The following query took 0.0018s an returned 1 row(s)
Triggered by: SiteTree->RelativeLink:711 > RootURLController::should_be_on_root:59 > ContentController->init:153
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" = 120)
ORDER BY
"SiteTree_Live"."Sort" ASC
LIMIT
1 array:37 [
"ClassName" => "Page"
"LastEdited" => "2019-08-30 15:55:47"
"Created" => "2013-06-19 09:47:18"
"Priority" => null
"ShareTokenSalt" => null
"ContentReviewType" => "Inherit"
"ReviewPeriodDays" => 0
"NextReviewDate" => null
"LastEditedByName" => "Elliot Sawyer"
"OwnerNames" => null
"ProvideComments" => 0
"ModerationRequired" => "None"
"CommentsRequireLogin" => 0
"ShowPageUtilities" => 1
"AlgoliaIndexed" => null
"AlgoliaError" => null
"AlgoliaUUID" => null
"CanViewType" => "Inherit"
"CanEditType" => "Inherit"
"Version" => 6
"URLSegment" => "international"
"Title" => "PulseNet International"
"MenuTitle" => "International"
"Content" => null
"MetaDescription" => null
"ExtraMeta" => null
"ShowInMenus" => 1
"ShowInSearch" => 1
"Sort" => 2
"HasBrokenFile" => 0
"HasBrokenLink" => 0
"ReportClass" => null
"WorkflowDefinitionID" => 0
"SubsiteID" => 4
"ParentID" => 0
"ID" => 120
"RecordClassName" => "Page"
]
The following query took 0.0026s 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" = 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.0016s 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" = 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"
]
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" = 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.0008s 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"
]
The following query took 0.0017s an returned 1 row(s)
Triggered by: Favicon.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" = 11)
ORDER BY
"File_Live"."Name" ASC
LIMIT
1 array:19 [
"ClassName" => "SilverStripe\Assets\Image"
"LastEdited" => "2024-10-20 23:12:28"
"Created" => "2013-06-25 15:09:44"
"Version" => 6
"UserFormUpload" => "f"
"HasMigratedAndExists" => 1
"CanViewType" => "Inherit"
"CanEditType" => "Inherit"
"Name" => "favicon.ico"
"Title" => "favicon.ico"
"ShowInSearch" => 1
"SubsiteID" => 4
"ParentID" => 9
"OwnerID" => 1
"FileHash" => "7834376d1767e4670a3ee79d6ae178a11aabd90e"
"FileFilename" => "PulseNet/images/favicon.ico"
"FileVariant" => null
"ID" => 11
"RecordClassName" => "SilverStripe\Assets\Image"
]
The following query took 0.0023s an returned 5 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" = 120)
AND (
"SiteTree_Live"."ShowInMenus" = 1
)
AND (
"SiteTree_Live"."SubsiteID" IN (4)
)
ORDER BY
"SiteTree_Live"."Sort" ASC "Page,Page,Page,Page,Page"
The following query took 0.0018s an returned 1 row(s)
Triggered by: SiteTree->isOrphaned:836 > SiteTree->canView:1195 > Hierarchy->SilverStripe\ORM\Hierarchy\{closure}:208 > Hierarchy->Children:207SELECT
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" = 120)
ORDER BY
"SiteTree_Live"."Sort" ASC
LIMIT
1 array:37 [
"ClassName" => "Page"
"LastEdited" => "2019-08-30 15:55:47"
"Created" => "2013-06-19 09:47:18"
"Priority" => null
"ShareTokenSalt" => null
"ContentReviewType" => "Inherit"
"ReviewPeriodDays" => 0
"NextReviewDate" => null
"LastEditedByName" => "Elliot Sawyer"
"OwnerNames" => null
"ProvideComments" => 0
"ModerationRequired" => "None"
"CommentsRequireLogin" => 0
"ShowPageUtilities" => 1
"AlgoliaIndexed" => null
"AlgoliaError" => null
"AlgoliaUUID" => null
"CanViewType" => "Inherit"
"CanEditType" => "Inherit"
"Version" => 6
"URLSegment" => "international"
"Title" => "PulseNet International"
"MenuTitle" => "International"
"Content" => null
"MetaDescription" => null
"ExtraMeta" => null
"ShowInMenus" => 1
"ShowInSearch" => 1
"Sort" => 2
"HasBrokenFile" => 0
"HasBrokenLink" => 0
"ReportClass" => null
"WorkflowDefinitionID" => 0
"SubsiteID" => 4
"ParentID" => 0
"ID" => 120
"RecordClassName" => "Page"
]
The following query took 0.0032s an returned 1 row(s)
Triggered by: SiteTree->isOrphaned:836 > SiteTree->canView:1195 > Hierarchy->SilverStripe\ORM\Hierarchy\{closure}:208 > Hierarchy->Children:207SELECT
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" = 120)
ORDER BY
"SiteTree_Live"."Sort" ASC
LIMIT
1 array:37 [
"ClassName" => "Page"
"LastEdited" => "2019-08-30 15:55:47"
"Created" => "2013-06-19 09:47:18"
"Priority" => null
"ShareTokenSalt" => null
"ContentReviewType" => "Inherit"
"ReviewPeriodDays" => 0
"NextReviewDate" => null
"LastEditedByName" => "Elliot Sawyer"
"OwnerNames" => null
"ProvideComments" => 0
"ModerationRequired" => "None"
"CommentsRequireLogin" => 0
"ShowPageUtilities" => 1
"AlgoliaIndexed" => null
"AlgoliaError" => null
"AlgoliaUUID" => null
"CanViewType" => "Inherit"
"CanEditType" => "Inherit"
"Version" => 6
"URLSegment" => "international"
"Title" => "PulseNet International"
"MenuTitle" => "International"
"Content" => null
"MetaDescription" => null
"ExtraMeta" => null
"ShowInMenus" => 1
"ShowInSearch" => 1
"Sort" => 2
"HasBrokenFile" => 0
"HasBrokenLink" => 0
"ReportClass" => null
"WorkflowDefinitionID" => 0
"SubsiteID" => 4
"ParentID" => 0
"ID" => 120
"RecordClassName" => "Page"
]
The following query took 0.0018s an returned 1 row(s)
Triggered by: SiteTree->isOrphaned:836 > SiteTree->canView:1195 > Hierarchy->SilverStripe\ORM\Hierarchy\{closure}:208 > Hierarchy->Children:207SELECT
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" = 120)
ORDER BY
"SiteTree_Live"."Sort" ASC
LIMIT
1 array:37 [
"ClassName" => "Page"
"LastEdited" => "2019-08-30 15:55:47"
"Created" => "2013-06-19 09:47:18"
"Priority" => null
"ShareTokenSalt" => null
"ContentReviewType" => "Inherit"
"ReviewPeriodDays" => 0
"NextReviewDate" => null
"LastEditedByName" => "Elliot Sawyer"
"OwnerNames" => null
"ProvideComments" => 0
"ModerationRequired" => "None"
"CommentsRequireLogin" => 0
"ShowPageUtilities" => 1
"AlgoliaIndexed" => null
"AlgoliaError" => null
"AlgoliaUUID" => null
"CanViewType" => "Inherit"
"CanEditType" => "Inherit"
"Version" => 6
"URLSegment" => "international"
"Title" => "PulseNet International"
"MenuTitle" => "International"
"Content" => null
"MetaDescription" => null
"ExtraMeta" => null
"ShowInMenus" => 1
"ShowInSearch" => 1
"Sort" => 2
"HasBrokenFile" => 0
"HasBrokenLink" => 0
"ReportClass" => null
"WorkflowDefinitionID" => 0
"SubsiteID" => 4
"ParentID" => 0
"ID" => 120
"RecordClassName" => "Page"
]
The following query took 0.0015s an returned 1 row(s)
Triggered by: SiteTree->isOrphaned:836 > SiteTree->canView:1195 > Hierarchy->SilverStripe\ORM\Hierarchy\{closure}:208 > Hierarchy->Children:207SELECT
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" = 120)
ORDER BY
"SiteTree_Live"."Sort" ASC
LIMIT
1 array:37 [
"ClassName" => "Page"
"LastEdited" => "2019-08-30 15:55:47"
"Created" => "2013-06-19 09:47:18"
"Priority" => null
"ShareTokenSalt" => null
"ContentReviewType" => "Inherit"
"ReviewPeriodDays" => 0
"NextReviewDate" => null
"LastEditedByName" => "Elliot Sawyer"
"OwnerNames" => null
"ProvideComments" => 0
"ModerationRequired" => "None"
"CommentsRequireLogin" => 0
"ShowPageUtilities" => 1
"AlgoliaIndexed" => null
"AlgoliaError" => null
"AlgoliaUUID" => null
"CanViewType" => "Inherit"
"CanEditType" => "Inherit"
"Version" => 6
"URLSegment" => "international"
"Title" => "PulseNet International"
"MenuTitle" => "International"
"Content" => null
"MetaDescription" => null
"ExtraMeta" => null
"ShowInMenus" => 1
"ShowInSearch" => 1
"Sort" => 2
"HasBrokenFile" => 0
"HasBrokenLink" => 0
"ReportClass" => null
"WorkflowDefinitionID" => 0
"SubsiteID" => 4
"ParentID" => 0
"ID" => 120
"RecordClassName" => "Page"
]
The following query took 0.0016s an returned 1 row(s)
Triggered by: SiteTree->isOrphaned:836 > SiteTree->canView:1195 > Hierarchy->SilverStripe\ORM\Hierarchy\{closure}:208 > Hierarchy->Children:207SELECT
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" = 120)
ORDER BY
"SiteTree_Live"."Sort" ASC
LIMIT
1 array:37 [
"ClassName" => "Page"
"LastEdited" => "2019-08-30 15:55:47"
"Created" => "2013-06-19 09:47:18"
"Priority" => null
"ShareTokenSalt" => null
"ContentReviewType" => "Inherit"
"ReviewPeriodDays" => 0
"NextReviewDate" => null
"LastEditedByName" => "Elliot Sawyer"
"OwnerNames" => null
"ProvideComments" => 0
"ModerationRequired" => "None"
"CommentsRequireLogin" => 0
"ShowPageUtilities" => 1
"AlgoliaIndexed" => null
"AlgoliaError" => null
"AlgoliaUUID" => null
"CanViewType" => "Inherit"
"CanEditType" => "Inherit"
"Version" => 6
"URLSegment" => "international"
"Title" => "PulseNet International"
"MenuTitle" => "International"
"Content" => null
"MetaDescription" => null
"ExtraMeta" => null
"ShowInMenus" => 1
"ShowInSearch" => 1
"Sort" => 2
"HasBrokenFile" => 0
"HasBrokenLink" => 0
"ReportClass" => null
"WorkflowDefinitionID" => 0
"SubsiteID" => 4
"ParentID" => 0
"ID" => 120
"RecordClassName" => "Page"
]
The following query took 0.0017s 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" = 7239)
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:26:25"
"Created" => "2020-07-20 15:34:41"
"Version" => 6
"UserFormUpload" => "f"
"HasMigratedAndExists" => 1
"CanViewType" => "Inherit"
"CanEditType" => "Inherit"
"Name" => "pnionly.png"
"Title" => "pnionly"
"ShowInSearch" => 1
"SubsiteID" => 4
"ParentID" => 7235
"OwnerID" => 299
"FileHash" => "63839f174a994b4ad09c75112c5693772c79712d"
"FileFilename" => "PulseNet/images/picLogo/2020/pnionly.png"
"FileVariant" => null
"ID" => 7239
"RecordClassName" => "SilverStripe\Assets\Image"
]
The following query took 0.0022s 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 (4)
) array:1 [
"MAX("SiteTree_Live"."LastEdited")" => "2023-11-07 07:51:22"
]
The following query took 0.0035s an returned 1 row(s)
Triggered by: 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" = 137)
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" => "2019-08-30 15:55:53"
"Created" => "2013-06-19 09:47:23"
"Intro" => """
<p class="AdditionalInfoHeading">A nine-question introduction to PulseNet</p>\n
<ol>\n
<li class="spacious"><a href="#why" class="ss-broken">Why was PulseNet developed?</a></li>\n
<li class="spacious"><a href="#role" class="ss-broken">What is the Role of PulseNet?</a></li>\n
<li class="spacious"><a href="#important" class="ss-broken">Why is PulseNet important to public health?</a></li>\n
<li class="spacious"><a href="#work" class="ss-broken">How does PulseNet work?</a></li>\n
<li class="spacious"><a href="#pfge" class="ss-broken">What is the PFGE process?</a></li>\n
<li class="spacious"><a href="#advantages" class="ss-broken">Advantages</a></li>\n
<li class="spacious"><a href="#limitations" class="ss-broken">Limitations of PFGE</a></li>\n
<li class="spacious"><a href="#interlaboratory" class="ss-broken">What makes interlaboratory DNA patterns comparison possible?</a></li>\n
<li class="spacious"><a href="#future" class="ss-broken">Future objectives of PulseNet</a></li>\n
</ol>
"""
"TeReoMenuTitle" => null
"AddInfoTitle" => null
"AdditionalInformation" => null
"RightMenuTitle" => null
"RightHandMenu" => null
"RightMenuVideo" => null
"AddInfoVideo" => null
"InFooter" => 0
"HideTitle" => 0
"HideInThisSection" => 0
"DisableRichLinks" => 0
"ElementalAreaID" => 522
"AddInfoImageID" => 0
"RightMenuImageID" => 0
"HeroImageID" => 0
"HeroImageMobileID" => 0
"ID" => 137
"RecordClassName" => "Page"
"Sort" => 7
]
The following query took 0.0015s 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" = 522)
LIMIT
1 array:8 [
"ClassName" => "DNADesign\Elemental\Models\ElementalArea"
"LastEdited" => "2019-08-30 15:55:53"
"Created" => "2019-08-30 15:55:53"
"Version" => 2
"OwnerClassName" => "Page"
"TopPageID" => 0
"ID" => 522
"RecordClassName" => "DNADesign\Elemental\Models\ElementalArea"
]
The following query took 0.0074s 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" = 522)
ORDER BY
"Element_Live"."Sort" ASC array:13 [
"ClassName" => "DNADesign\Elemental\Models\ElementContent"
"LastEdited" => "2019-08-30 15:55:53"
"Created" => "2019-08-30 15:55:53"
"Version" => 2
"Title" => "Auto migrated content"
"ShowTitle" => 0
"Sort" => 1
"ExtraClass" => null
"Style" => null
"TopPageID" => 0
"ParentID" => 522
"ID" => 410
"RecordClassName" => "DNADesign\Elemental\Models\ElementContent"
]
The following query took 0.0023s an returned 1 row(s)
Triggered by: BaseElement->getPage:709 > BaseElement->canView:231 > ElementalArea->DNADesign\Elemental\Models\{closure}:176 > ElementalArea->ElementControllers:175SELECT
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" = 522)
LIMIT
1 array:8 [
"ClassName" => "DNADesign\Elemental\Models\ElementalArea"
"LastEdited" => "2019-08-30 15:55:53"
"Created" => "2019-08-30 15:55:53"
"Version" => 2
"OwnerClassName" => "Page"
"TopPageID" => 0
"ID" => 522
"RecordClassName" => "DNADesign\Elemental\Models\ElementalArea"
]
The following query took 0.0031s an returned 1 row(s)
Triggered by: ElementalArea->getOwnerPage:221 > BaseElement->getPage:712 > BaseElement->canView:231 > ElementalArea->DNADesign\Elemental\Models\{closure}:176SELECT
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" = 522
)
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 (4)
)
ORDER BY
"SiteTree_Live"."Sort" ASC
LIMIT
1 array:54 [
"ClassName" => "Page"
"LastEdited" => "2019-08-30 15:55:53"
"Created" => "2013-06-19 09:47:23"
"Priority" => null
"ShareTokenSalt" => null
"ContentReviewType" => "Inherit"
"ReviewPeriodDays" => 0
"NextReviewDate" => null
"LastEditedByName" => "Elliot Sawyer"
"OwnerNames" => null
"ProvideComments" => 0
"ModerationRequired" => "None"
"CommentsRequireLogin" => 0
"ShowPageUtilities" => 1
"AlgoliaIndexed" => null
"AlgoliaError" => null
"AlgoliaUUID" => null
"CanViewType" => "Inherit"
"CanEditType" => "Inherit"
"Version" => 17
"URLSegment" => "pulsenetexplained"
"Title" => "PulseNet Explained"
"MenuTitle" => null
"Content" => null
"MetaDescription" => null
"ExtraMeta" => null
"ShowInMenus" => 1
"ShowInSearch" => 1
"Sort" => 7
"HasBrokenFile" => 0
"HasBrokenLink" => 1
"ReportClass" => null
"WorkflowDefinitionID" => 0
"SubsiteID" => 4
"ParentID" => 120
"Intro" => """
<p class="AdditionalInfoHeading">A nine-question introduction to PulseNet</p>\n
<ol>\n
<li class="spacious"><a href="#why" class="ss-broken">Why was PulseNet developed?</a></li>\n
<li class="spacious"><a href="#role" class="ss-broken">What is the Role of PulseNet?</a></li>\n
<li class="spacious"><a href="#important" class="ss-broken">Why is PulseNet important to public health?</a></li>\n
<li class="spacious"><a href="#work" class="ss-broken">How does PulseNet work?</a></li>\n
<li class="spacious"><a href="#pfge" class="ss-broken">What is the PFGE process?</a></li>\n
<li class="spacious"><a href="#advantages" class="ss-broken">Advantages</a></li>\n
<li class="spacious"><a href="#limitations" class="ss-broken">Limitations of PFGE</a></li>\n
<li class="spacious"><a href="#interlaboratory" class="ss-broken">What makes interlaboratory DNA patterns comparison possible?</a></li>\n
<li class="spacious"><a href="#future" class="ss-broken">Future objectives of PulseNet</a></li>\n
</ol>
"""
"TeReoMenuTitle" => null
"AddInfoTitle" => null
"AdditionalInformation" => null
"RightMenuTitle" => null
"RightHandMenu" => null
"RightMenuVideo" => null
"AddInfoVideo" => null
"InFooter" => 0
"HideTitle" => 0
"HideInThisSection" => 0
"DisableRichLinks" => 0
"ElementalAreaID" => 522
"AddInfoImageID" => 0
"RightMenuImageID" => 0
"HeroImageID" => 0
"HeroImageMobileID" => 0
"ID" => 137
"RecordClassName" => "Page"
]
The following query took 0.0012s an returned 1 row(s)
Triggered by: SiteTree->isOrphaned:836 > SiteTree->canView:1195 > BaseElement->canView:232 > ElementalArea->DNADesign\Elemental\Models\{closure}:176SELECT
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" = 120)
ORDER BY
"SiteTree_Live"."Sort" ASC
LIMIT
1 array:37 [
"ClassName" => "Page"
"LastEdited" => "2019-08-30 15:55:47"
"Created" => "2013-06-19 09:47:18"
"Priority" => null
"ShareTokenSalt" => null
"ContentReviewType" => "Inherit"
"ReviewPeriodDays" => 0
"NextReviewDate" => null
"LastEditedByName" => "Elliot Sawyer"
"OwnerNames" => null
"ProvideComments" => 0
"ModerationRequired" => "None"
"CommentsRequireLogin" => 0
"ShowPageUtilities" => 1
"AlgoliaIndexed" => null
"AlgoliaError" => null
"AlgoliaUUID" => null
"CanViewType" => "Inherit"
"CanEditType" => "Inherit"
"Version" => 6
"URLSegment" => "international"
"Title" => "PulseNet International"
"MenuTitle" => "International"
"Content" => null
"MetaDescription" => null
"ExtraMeta" => null
"ShowInMenus" => 1
"ShowInSearch" => 1
"Sort" => 2
"HasBrokenFile" => 0
"HasBrokenLink" => 0
"ReportClass" => null
"WorkflowDefinitionID" => 0
"SubsiteID" => 4
"ParentID" => 0
"ID" => 120
"RecordClassName" => "Page"
]
The following query took 0.0012s 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" = 522)
LIMIT
1 array:8 [
"ClassName" => "DNADesign\Elemental\Models\ElementalArea"
"LastEdited" => "2019-08-30 15:55:53"
"Created" => "2019-08-30 15:55:53"
"Version" => 2
"OwnerClassName" => "Page"
"TopPageID" => 0
"ID" => 522
"RecordClassName" => "DNADesign\Elemental\Models\ElementalArea"
]
The following query took 0.0018s 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" = 410)
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" => "2019-08-30 15:55:53"
"Created" => "2019-08-30 15:55:53"
"HTML" => """
<h5><a id="why" name="why"></a> 1. Why was PulseNet developed?</h5>\n
<p>In the beginning of the 1990’s, an increasing number of outbreaks of foodborne infections was detected and investigated in the United States. Such an increase placed a strain on the resources available at the Central Reference Laboratory at the Foodborne and Diarrheal Diseases Branch, the Centers for Disease Control and Prevention (CDC) for subtyping of outbreak-related isolates. To cope with this situation, PulseNet was developed as a result of the geographic decentralization of molecular surveillance of foodborne infections.in the USA (see <a href="[sitetree_link,id=91]" target="_blank">PulseNet USA history</a>). This decentralization led to the transfer of subtyping by Pulsed-Field gel electrophoresis (PFGE) from the Central Reference Laboratory at CDC to the local Public Health Laboratories in the states. Subtyping data were analyzed locally and forwarded electronically to CDC for further analysis. Besides shifting some of the subtyping workload away from the CDC, this change benefited foodborne disease surveillance in others ways: isolates were subtyped more rapidly with no delay that would be incurred by transporting them to CDC and the results were simultaneously available for analysis both locally and at CDC. Today, most states perform subtyping for their own isolates, however, the CDC still acts as a national reference laboratory that offers its services to states requesting assistance.</p>\n
<h5><a id="role" name="role"></a> 2. What is the Role of PulseNet?</h5>\n
<ul>\n
<li>Detect foodborne disease case clusters by PFGE, thereby facilitating early identification of common source outbreaks</li>\n
<li>Separate outbreak-associated cases from sporadic cases (case definition)</li>\n
<li>Assist in identifying and confirming the source of the outbreak (culture confirmation)</li>\n
<li>Act as an efficient means of communcatiom between public health laboratories</li>\n
</ul>\n
<p><a href="#top" class="ss-broken">back to top</a></p>\n
<h5><a name="important"></a> 3. Why is PulseNet important to public health?</h5>\n
<p>PulseNet plays a vital role in the surveillance and investigation of foodborne illness outbreaks that were previously difficult to detect. By identifying bacterial isolates with indistinguishable subtype through PulseNet, scientists may link cases associated with the same outbreak even if the affected individuals are geographically distant. Outbreaks, along with their sources, can now be identified in a matter of days rather than weeks.</p>\n
<h5><a name="work"></a> 4. How does PulseNet work?</h5>\n
<div class="ImageFloatRight">\n
<div class="captionImage leftAlone" style="width: 187px;"><img class="leftAlone" title="Pulsed-Field Gel Elecrophoresis (PFGE) Fingerprint" src="assets/PulseNet/images/picTech/_resampled/ResizedImage187150-fingerprint_whole.gif" alt="Pulsed-Field Gel Elecrophoresis (PFGE) Fingerprint" height="150" width="187">\n
<p class="caption leftAlone">Pulsed-Field Gel Elecrophoresis (PFGE) Fingerprint</p>\n
</div>\n
</div>\n
<ol>\n
<li>PulseNet participants perform DNA "fingerprinting" by <strong>pulsed-field gel electrophoresis</strong> (PFGE, see next section) on disease-causing bacteria isolated from humans and from suspected food using standardized equipment and methods.</li>\n
<li>Once the PFGE patterns are generated, the laboratory enters them into an electronic database and analyzes the results at the local level. The analyzed patterns may also be uploaded to the regional PulseNet database. If a cluster with indistinguishable patterns is identified indicating an outbreak may be occurring, the laboratory consults with local epidemiologists and initiates an outbreak investigation. If the outbreak is suspected to extend beyond the local level an alert is posted on the regional PulseNet listserv and the PulseNet international forum.</li>\n
<li>Database curators at the regional level will also perform regular cluster searches. If a cluster that has not been reported by a local laboratory is identified and an outbreak is suspected, an investigation is initiated. An alert is posted on the regional PulseNet listserv and the <a href="http://www.aphl.org/conferences/proceedings/Documents/2008_12th_Annual_PulseNet_Update_Meeting/25-SmidtIntenatlCommuni.pdf" target="_blank">PulseNet international forum.</a></li>\n
</ol>\n
<p><a href="#top" class="ss-broken">back to top</a></p>\n
<h5><a name="pfge"></a> 5. What is the PFGE process?</h5>\n
<div class="ImageFloatRightShadowed">\n
<div class="captionImage leftAlone" style="width: 300px;"><img class="leftAlone" title="PFGE Process showing bacterial suspension, mix with aragose, plug mold, chemical lysis and washing, dna in plugs, restriction enzyme, electrophoresis, documentation capture gel image, data analysis" src="assets/PulseNet/images/picMisc/pfge_process.gif" alt="PFGE Process showing bacterial suspension, mix with aragose, plug mold, chemical lysis and washing, dna in plugs, restriction enzyme, electrophoresis, documentation capture gel image, data analysis" height="198" width="300">\n
<p class="caption leftAlone">PFGE Process showing bacterial suspension, mix with aragose, plug mold, chemical lysis and washing, dna in plugs, restriction enzyme, electrophoresis, documentation capture gel image, data analysis</p>\n
</div>\n
</div>\n
<p>PFGE is a subtyping method that detects polymorphism in restriction fragments of genomic DNA (macrorestriction). Genomic DNA is restricted by enzymes that recognize short DNA sequences and cut the DNA whenever such a sequence occurs. In this way genomic DNA is cut into a small number (usually 10-20) of restriction fragments in a very specific and reproducible manner.</p>\n
<p>These DNA fragments are usually too large to separate by conventional agarose gel electrophoresis. In stead, they can be effectively resolved according to their size by a process termed pulsed-field gel electrophoresis (PFGE), developed in the early 80’s.</p>\n
<p>PFGE facilitates the differential migration of large DNA fragments through agarose gels by constantly changing the direction of the electrical field during electrophoresis. The contour-clamped homogeneous electric field (CHEF) gel electrophoresis method has become the method of choice for resolving DNA macrorestriction fragments of bacterial genomic DNA.</p>\n
<h5><a id="advantages" name="advantages"></a> 6. Advantages of using PFGE</h5>\n
<p>PFGE is a universal method that may be used for subtyping of bacteria with small modifications dependent on the bacterial species investigated. Usually, only the choice of the restriction enzyme and conditions for electrophoresis need to be optimized for each species.</p>\n
<p>DNA restriction patterns generated by PFGE are stable and reproducible at the intra- and inter-laboratory levels when the method is highly standardized (see section 8 below). Due to its relative simplicity, high discriminatory power and reproducibility, PFGE has become the gold standard for bacterial subtyping.</p>\n
<p><a href="#top" class="ss-broken">back to top</a></p>\n
<h5><a name="limitations"></a> 7. Limitations of PFGE</h5>\n
<ul>\n
<li>Time consuming</li>\n
<li>Requires a high-level of skills</li>\n
<li>Does not work for everything (i.e. clonal patterns)</li>\n
<li>The DNA fragments are separated by their size, not by their sequence</li>\n
<li>Fragments with the same size may represent different parts of the genome</li>\n
<li>Observed differences in PFGE patterns may be difficult to interpret</li>\n
<li>Some strains are untypable by PFGE</li>\n
</ul>\n
<h5><a name="interlaboratory"></a> 8. What makes interlaboratory comparison of DNA patterns possible?</h5>\n
<p>For PulseNet, the quality and uniformity of the data is ensured by the implementation of a quality assurance and quality control (QA/QC) program. The components of the QA/QC program that allow for the comparison of DNA patterns across all laboratories participating in PulseNet are:</p>\n
<ul>\n
<li><a href="http://www.cdc.gov/pulsenet/pathogens/index.html" target="_blank">Standardised protocols</a></li>\n
<li>Same molecular size standard ( <em>S</em>. Braenderup H2812, ATCC BAA-664)</li>\n
<li>Standardized software used by all participants</li>\n
<li>Standardized nomenclature of PulseNet patterns</li>\n
<li>Training workshops (lab & software): most participating labs have attended a week of combined laboratory and analysis software training</li>\n
<li>Certification: all individuals who submit data must be certified by stringent PulseNet standards</li>\n
<li>Proficiency testing: all certified individuals must participate and pass annual proficiency testing in order to maintain certification</li>\n
<li><a href="http://www.aphl.org/conferences/proceedings/pages/default.aspx" target="_blank">Annual update meetings</a>: provide a forum for the live exchange of information</li>\n
</ul>\n
<h5><a name="future"></a> 9. Future objectives of PulseNet</h5>\n
<p>To do what we do but do it better:</p>\n
<ul>\n
<li>Maintain and strengthen collaboration during international outbreak investigation</li>\n
<li>Increase the number of PulseNet regional networks and the number of participants in each network</li>\n
<li>Achieve real-time subtyping and real-time communication in all PulseNet regional networks</li>\n
<li>Increase the level of communication between laboratorians and epidemiologists at the national and international levels</li>\n
<li>Strengthen collaborations and establish partnerships/affiliations with other stake holders for food safety, e.g. academia and the food industry, as well as non-profit national and international organizations worldwide</li>\n
<li>Improve the subtyping methods used by PulseNet</li>\n
<li>Develop <a href="[sitetree_link,id=107]" target="_blank" class="ss-broken">PFGE protocols</a> for more organisms such as Yersinia enterocolitica,and Enterobacter sakazakii</li>\n
<li>Develop new faster and more simple subtyping methods</li>\n
<li class="Nested">Multiple-locus variable-number tandem-repeats analysis ( <a href="[sitetree_link,id=108]" target="_blank">MLVA)</a></li>\n
<li class="Nested">Single nucleotide polymorphism (SNP) analysis</li>\n
<li class="Nested">Other</li>\n
<li>Use PulseNet data to study the geographic distribution of major clones of foodborne bacteria</li>\n
<li>Use PulseNet data to assist in studies attributing the sources of sporadic foodborne infections</li>\n
</ul>\n
<p><a href="#top" class="ss-broken">back to top</a></p>\n
<p> </p>
"""
"ID" => 410
"RecordClassName" => "DNADesign\Elemental\Models\ElementContent"
"Sort" => 1
]
The following query took 0.0016s an returned 1 row(s)
Triggered by: SiteTree::link_shortcode_handler:630 > ShortcodeParser->callShortcode:171 > ShortcodeParser->getShortcodeReplacementText:189 > ShortcodeParser->SilverStripe\View\Parsers\{closure}:482SELECT
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" = 91)
ORDER BY
"SiteTree_Live"."Sort" ASC
LIMIT
1 array:37 [
"ClassName" => "Page"
"LastEdited" => "2019-08-30 15:55:53"
"Created" => "2013-06-18 17:21:32"
"Priority" => null
"ShareTokenSalt" => null
"ContentReviewType" => "Inherit"
"ReviewPeriodDays" => 0
"NextReviewDate" => null
"LastEditedByName" => "Elliot Sawyer"
"OwnerNames" => null
"ProvideComments" => 0
"ModerationRequired" => "None"
"CommentsRequireLogin" => 0
"ShowPageUtilities" => 1
"AlgoliaIndexed" => null
"AlgoliaError" => null
"AlgoliaUUID" => null
"CanViewType" => "Inherit"
"CanEditType" => "Inherit"
"Version" => 6
"URLSegment" => "usa"
"Title" => "PulseNet USA"
"MenuTitle" => null
"Content" => null
"MetaDescription" => null
"ExtraMeta" => null
"ShowInMenus" => 1
"ShowInSearch" => 1
"Sort" => 7
"HasBrokenFile" => 0
"HasBrokenLink" => 0
"ReportClass" => null
"WorkflowDefinitionID" => 0
"SubsiteID" => 4
"ParentID" => 71
"ID" => 91
"RecordClassName" => "Page"
]
The following query took 0.0019s an returned 1 row(s)
Triggered by: SiteTree->RelativeLink:711 > SiteTree->Link:656 > SiteTree::link_shortcode_handler:636 > ShortcodeParser->callShortcode:171
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" = 71)
ORDER BY
"SiteTree_Live"."Sort" ASC
LIMIT
1 array:37 [
"ClassName" => "Page"
"LastEdited" => "2019-08-30 15:55:48"
"Created" => "2013-06-18 17:21:04"
"Priority" => null
"ShareTokenSalt" => null
"ContentReviewType" => "Inherit"
"ReviewPeriodDays" => 0
"NextReviewDate" => null
"LastEditedByName" => "Elliot Sawyer"
"OwnerNames" => null
"ProvideComments" => 0
"ModerationRequired" => "None"
"CommentsRequireLogin" => 0
"ShowPageUtilities" => 1
"AlgoliaIndexed" => null
"AlgoliaError" => null
"AlgoliaUUID" => null
"CanViewType" => "Inherit"
"CanEditType" => "Inherit"
"Version" => 8
"URLSegment" => "networks"
"Title" => "Networks"
"MenuTitle" => null
"Content" => null
"MetaDescription" => null
"ExtraMeta" => null
"ShowInMenus" => 1
"ShowInSearch" => 1
"Sort" => 3
"HasBrokenFile" => 0
"HasBrokenLink" => 0
"ReportClass" => null
"WorkflowDefinitionID" => 0
"SubsiteID" => 4
"ParentID" => 0
"ID" => 71
"RecordClassName" => "Page"
]
The following query took 0.0021s an returned 0 row(s)
Triggered by: SiteTree::link_shortcode_handler:630 > ShortcodeParser->callShortcode:171 > ShortcodeParser->getShortcodeReplacementText:189 > ShortcodeParser->SilverStripe\View\Parsers\{closure}:482SELECT
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" = 107)
ORDER BY
"SiteTree_Live"."Sort" ASC
LIMIT
1
The following query took 0.0034s an returned 1 row(s)
Triggered by: Versioned::get_latest_version:2676 > SiteTree::link_shortcode_handler:631 > ShortcodeParser->callShortcode:171 > ShortcodeParser->getShortcodeReplacementText:189
SELECT
DISTINCT "SiteTree_Versions"."ClassName",
"SiteTree_Versions"."LastEdited",
"SiteTree_Versions"."Created",
"SiteTree_Versions"."Priority",
"SiteTree_Versions"."ShareTokenSalt",
"SiteTree_Versions"."ContentReviewType",
"SiteTree_Versions"."ReviewPeriodDays",
"SiteTree_Versions"."NextReviewDate",
"SiteTree_Versions"."LastEditedByName",
"SiteTree_Versions"."OwnerNames",
"SiteTree_Versions"."ProvideComments",
"SiteTree_Versions"."ModerationRequired",
"SiteTree_Versions"."CommentsRequireLogin",
"SiteTree_Versions"."ShowPageUtilities",
"SiteTree_Versions"."AlgoliaIndexed",
"SiteTree_Versions"."AlgoliaError",
"SiteTree_Versions"."AlgoliaUUID",
"SiteTree_Versions"."CanViewType",
"SiteTree_Versions"."CanEditType",
"SiteTree_Versions"."Version",
"SiteTree_Versions"."URLSegment",
"SiteTree_Versions"."Title",
"SiteTree_Versions"."MenuTitle",
"SiteTree_Versions"."Content",
"SiteTree_Versions"."MetaDescription",
"SiteTree_Versions"."ExtraMeta",
"SiteTree_Versions"."ShowInMenus",
"SiteTree_Versions"."ShowInSearch",
"SiteTree_Versions"."Sort",
"SiteTree_Versions"."HasBrokenFile",
"SiteTree_Versions"."HasBrokenLink",
"SiteTree_Versions"."ReportClass",
"SiteTree_Versions"."WorkflowDefinitionID",
"SiteTree_Versions"."SubsiteID",
"SiteTree_Versions"."ParentID",
"SiteTree_Versions"."RecordID" AS "ID",
CASE WHEN "SiteTree_Versions"."ClassName" IS NOT NULL THEN
"SiteTree_Versions"."ClassName"
ELSE
'SilverStripe\\CMS\\Model\\SiteTree'
END AS "RecordClassName",
"SiteTree_Versions"."RecordID",
"SiteTree_Versions"."WasPublished",
"SiteTree_Versions"."WasDeleted",
"SiteTree_Versions"."WasDraft",
"SiteTree_Versions"."AuthorID",
"SiteTree_Versions"."PublisherID"
FROM
"SiteTree_Versions"
WHERE
(
"SiteTree_Versions"."WasDeleted" = 0
)
AND (
"SiteTree_Versions"."RecordID" = '107'
)
AND (
"SiteTree_Versions"."SubsiteID" IN (4)
)
ORDER BY
"SiteTree_Versions"."Version" DESC
LIMIT
1 array:43 [
"ClassName" => "Page"
"LastEdited" => "2014-03-07 13:51:59"
"Created" => "2013-06-18 17:25:44"
"Priority" => null
"ShareTokenSalt" => null
"ContentReviewType" => "Inherit"
"ReviewPeriodDays" => 0
"NextReviewDate" => null
"LastEditedByName" => null
"OwnerNames" => null
"ProvideComments" => 0
"ModerationRequired" => "None"
"CommentsRequireLogin" => 0
"ShowPageUtilities" => 1
"AlgoliaIndexed" => null
"AlgoliaError" => null
"AlgoliaUUID" => null
"CanViewType" => "Inherit"
"CanEditType" => "Inherit"
"Version" => 5
"URLSegment" => "default"
"Title" => "Molecular Typing\u{A0}By PFGE"
"MenuTitle" => "Molecular Typing"
"Content" => """
<p>Pulsed Field Gel Electrophoresis (PFGE) was selected by PulseNet as the primary genotyping methodology back in the mid 1990's. As a robust and reliable technique it has surpassed all expectations, and remains today the primary method for network participants. This page includes <a href="#protocols">PFGE protocols</a>, PulseNet under the Microscope <a href="#putm">newsletters</a> (currently covering Image acquisition, agaroses for PFGE, and DNA stains), a link to <a href="#youtube">YouTube videos</a> explaining PFGE (in Spanish only) \u{A0}\u{A0}useful information on the <i>Salmonella</i> serotype Braenderup (H9812) <a href="#sizestandard">universal standard strain</a>, and general information on <a href="#equipment">equipment needed for PFGE</a>. </p>\n
<h2>\n
<a id="protocols" name="protocols"></a>PFGE Protocols </h2>\n
<p>The following information provides the standard laboratory protocols for molecular subtyping of the pathogens under surveillance by PulseNet laboratories. Clicking on the name or photograph of an organism will link you to the Adobe Acrobat version of the PulseNet protocol for that organism.</p>\n
<p>\u{A0}</p>\n
<div class="ImageFloatLeftNoBorder"><a href="/assets/PulseNet/uploads/pfge/5.6_2009_PNetStandProtCampy.pdf"><img class="ImageWithLinkShadowBox" alt="photomicrograph of campylobacter jejuni link to PDF 185KB" src="/assets/PulseNet/images/picTech/campy_jejuni.gif" width="90" height="90" title=""></a></div>\n
<div class="DivTextColumn75">\n
<p><a class="InlineTitle" title="" href="/assets/PulseNet/uploads/pfge/PNL03_CampyPFGEprotocol.pdf" target="_blank"><img class="ms-asset-icon" border="0" src="/_layouts/IMAGES/icpdf.gif">\u{A0}Campylobacter jejuni</a> </p>\n
<p><strong>Updated March\u{A0}2013</strong>, PDF 204 KB</p>\n
</div>\n
<div class="DivClear"></div>\n
<div class="ImageFloatLeftNoBorder"><a href="/assets/PulseNet/uploads/pfge/5_201_202_204_2009_PNetStandProtEcolSalShig.pdf"><img style="border-bottom:0px solid;border-left:0px solid;width:90px;height:90px;border-top:0px solid;border-right:0px solid" class="ImageWithLinkShadowBox" border="0" alt="Clostridium botulinum" src="/assets/PulseNet/images/picTech/clostridium.jpg" title=""></a></div>\n
<div class="DivTextColumn75">\n
<p><a class="InlineTitle" title="Clostridium botulinum" href="/assets/PulseNet/uploads/pfge/CBotulinum2010.pdf" target="_blank"><img class="ms-asset-icon" border="0" src="/_layouts/IMAGES/icpdf.gif">\u{A0}Clostridium botulinum</a> </p>\n
<p>\u{A0}<strong>March 2010</strong>, PDF\u{A0}833 KB</p>\n
</div>\n
<div class="DivClear"></div>\n
<div class="ImageFloatLeftNoBorder"><a href="/assets/PulseNet/uploads/pfge/5_201_202_204_2009_PNetStandProtEcolSalShig.pdf"><img class="ImageWithLinkShadowBox" alt="photomicrograph of escherichia coli o157:h7 link to PDF 246KB" src="/assets/PulseNet/images/picTech/ecoli_157_h7.gif" width="90" height="90" title=""></a></div>\n
<div class="DivTextColumn75">\n
<p><a class="InlineTitle" title="" href="/assets/PulseNet/uploads/pfge/PNL05_Ec-Sal-ShigPFGEprotocol.pdf" target="_blank"><img class="ms-asset-icon" border="0" src="/_layouts/IMAGES/icpdf.gif">\u{A0}Escherichia coli (O157:H7 and non O157), Salmonella, Shigella sonnei and Shigella flexneri</a> </p>\n
<p><strong>Updated March 2013</strong>,\u{A0}PDF 173 KB</p>\n
</div>\n
<div class="DivClear"></div>\n
<div class="ImageFloatLeftNoBorder"><a href="/assets/PulseNet/uploads/pfge/5.3_2009_PNetStandProtLMonocytogenes.pdf"><img class="ImageWithLinkShadowBox" alt="photomicrograph of listeria monocytogenes PDF 57KB" src="/assets/PulseNet/images/picTech/listeria_monocytogenes.gif" width="90" height="90" title=""></a></div>\n
<div class="DivTextColumn75">\n
<p><a class="InlineTitle" title="" href="/assets/PulseNet/uploads/pfge/PNL04_ListeriaPFGEProtocol.pdf" target="_blank"><img class="ms-asset-icon" border="0" src="/_layouts/IMAGES/icpdf.gif">\u{A0}Listeria monocytogenes </a></p>\n
<p><strong>Updated March 2013</strong>, PDF 225 KB</p>\n
</div>\n
<div class="DivClear"></div>\n
<div class="DivClear"></div>\n
<div class="ImageFloatLeftNoBorder"><a href="/assets/PulseNet/uploads/pfge/5.72_2009_PNetStandProtVparahaem.pdf" target="_blank"><img class="ImageWithLinkShadowBox" alt="vibrio" src="assets/PulseNet/images/picTech/_resampled/ResizedImage9090-vparahaem.jpg" width="90" height="90" title=""></a></div>\n
<div class="DivTextColumn75">\n
<p><a class="InlineTitle" title="" href="/assets/PulseNet/uploads/pfge/PNL06_Vchol-VparahPFGEprotocol.pdf" target="_blank"><img class="ms-asset-icon" border="0" src="/_layouts/IMAGES/icpdf.gif">\u{A0}Vibrio cholerae and Vibrio parahemolyticus</a> </p>\n
<p><strong>Updated March 2013</strong>, PDF 173 KB</p>\n
</div>\n
<div class="DivClear"></div>\n
<div class="ImageFloatLeftNoBorder"><a href="/assets/PulseNet/uploads/pfge/yersinia_Apr2006.pdf" target="_blank"><img class="ImageWithLinkShadowBox" alt="yersinia" src="/assets/PulseNet/images/picTech/yersinia_pestis.gif" width="90" height="90" title=""></a></div>\n
<div class="DivTextColumn75">\n
<p><a class="InlineTitle" title="" href="/assets/PulseNet/uploads/pfge/yersinia_Apr2006.pdf" target="_blank"><img class="ms-asset-icon" border="0" src="/_layouts/IMAGES/icpdf.gif">\u{A0}Yersinia pestis</a> </p>\n
<p><strong>April 2006</strong>, PDF 210 KB</p>\n
</div>\n
<div class="DivClear"></div>\n
<p class="pBackToTop"><a class="LinkStdColour" href="#top">back to top</a> </p>\n
<h2>\n
<a id="putm" name="putm"></a>PulseNet: Under the Microscope</h2>\n
<p>A series of updates and hints from the PulseNet method development laboratory.</p>\n
<p>Volume 1: <a title="1878kb pdf file" href="/assets/PulseNet/uploads/Underthemicroscope/pulsenettipsvol1.pdf" target="_blank"><img class="ms-asset-icon" border="0" src="/_layouts/IMAGES/icpdf.gif">\u{A0}Capturing a Gel and Adjusting the Settings for Analysis </a></p>\n
<p>Volume 2: <a title="" href="/assets/PulseNet/uploads/Underthemicroscope/pulsenettipsvol2.pdf" target="_blank"><img class="ms-asset-icon" border="0" src="/_layouts/IMAGES/icpdf.gif">DNA stains for agarose gels\u{A0}(ethidium bromide, SYBR Safe, SYBR Gold, GelRed)</a></p>\n
<p>Volume 3: <a title="" href="/assets/PulseNet/uploads/Underthemicroscope/pulsenettipsvol3.pdf" target="_blank"><img class="ms-asset-icon" border="0" src="/_layouts/IMAGES/icpdf.gif">A comparison of agaroses for PFGE (Seakem Gold, Agarose III, Megabase, PFGE Agarose).</a></p>\n
<p class="pBackToTop"><a href="#top">back to top </a></p>\n
<h2>\n
<a id="youtube" name="YouTube"></a>PFGE YouTube videos</h2>\n
<p>PulseNet Latin America have produced a series of videos explaining PFGE. These have been uploaded to <a title="" href="http://www.youtube.com/user/pulsenetint?feature=watch" target="_blank">YouTube</a> where they are accessible to all - but at this stage only in Spanish!</p>\n
<p><a title="" href="http://www.youtube.com/user/pulsenetint?feature=watch" target="_blank"><img style="border-bottom:0px solid;border-left:0px solid;height:354px;border-top:0px solid;border-right:0px solid" border="0" src="assets/PulseNet/images/picMisc/_resampled/ResizedImage865373-YouTubeImage2.JPG" width="865" height="373" alt="" title=""></a></p>\n
<p>\u{A0}<a title="" href="http://www.youtube.com/user/pulsenetint?feature=watch" target="_blank"></a></p>\n
<p class="pBackToTop"><a class="LinkStdColour" href="#top">back to top</a> </p>\n
<h2>\n
<a id="SizeStandard" name="SizeStandard"></a><i>Salmonella</i> Braenderup H9812 Universal Size Standard </h2>\n
<p>For PFGE normalization and accurate comparison of gel images require the use of a well-characterized size standard in at least three lanes of each gel. PulseNet International has adopted a strain of <i>Salmonella</i> serotype Braenderup (H9812) restricted with XbaI was selected as a "universal" standard strain because of its even distribution of bands over the entire range of band sizes normally seen in the foodborne pathogens tracked by PulseNet. This strain was found to have a stable PFGE pattern upon subculture and was susceptible to antimicrobial agents commonly used to treat serious <i>Salmonella</i> infections. </p>\n
<p>This strain has been deposited with the <a class="InlineTitle" href="http://www.atcc.org/ATCCAdvancedCatalogSearch/ProductDetails/tabid/452/Default.aspx?ATCCNum=BAA-664&Template=bacteria" target="_blank">American Type Culture Collection (BAA-664)</a> to make it available for other laboratories to use. </p>\n
<div class="ImageFloatLeftShadowed"><img alt="<i>Salmonella</i>. braenderup H9812 Universal Size Standard" src="/assets/PulseNet/images/picTech/h9812a.jpg" title=""></div>\n
<div class="DivClear"></div>\n
<p class="AdditionalInfoHeading">Approximate band sizes in kilobases of the <i>Salmonella</i> serotype Braenderup reference standard (H9812) restricted with XbaI and run under the PulseNet standardized electrophoresis conditions specific for each organism. </p>\n
<p>\u{A0}</p>\n
<p>Details of the development of this standard have been described in the following paper:</p>\n
<p class="paraSpaceBefore"><a href="http://www.ncbi.nlm.nih.gov/sites/entrez?Db=pubmed&Cmd=ShowDetailView&TermToSearch=15750058&ordinalpos=38&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_RVDocSum">Hunter SB, Vauterin P, Lambert-Fair MA, Van Duyne MS, Kubota K, Graves L, Wrigley D, Barrett T, Ribot E.</a> <br>Establishment of a universal size standard strain for use with the PulseNet standardized pulsed-field gel electrophoresis protocols: converting the national databases to the new size standard.<br>J Clin Microbiol. 2005 Mar;43(3):1045-50. </p>\n
<p class="pBackToTop"><a class="LinkStdColour" href="#top">back to top</a> </p>\n
<div class="DivClear"></div>\n
<h2>\n
<a id="equipment" name="equipment"></a>Equipment & Reagents Required for PFGE </h2>\n
<p>PulseNet PFGE protocols have been developed and validated for use on Bio-Rad CHEF Mapper XA System or CHEF-DR III System.</p>\n
<p>A list of equipment and supplies needed for the molecular subtyping of foodborne bacterial pathogens by PulseNet´s Standardized PFGE Protocols can be downloaded <a href="/assets/PulseNet/uploads/pfge/PFGEequipment.pdf" target="_blank">here.</a></p>\n
<p>Costs given are approximate, are in US$, and were correct as of January 10, 2007</p>\n
<p class="AdditionalInfoHeading">Use of trade names and commercial sources is for identification only and does not imply endorsement by CDC, the U.S. Department of Health and Human Services, or any PulseNet International participant.</p>\n
<p class="pBackToTop"><a class="LinkStdColour" href="#top">back to top</a> </p>\n
<div></div>
"""
"MetaDescription" => null
"ExtraMeta" => null
"ShowInMenus" => 1
"ShowInSearch" => 1
"Sort" => 2
"HasBrokenFile" => 0
"HasBrokenLink" => 0
"ReportClass" => null
"WorkflowDefinitionID" => 0
"SubsiteID" => 4
"ParentID" => 538
"ID" => 107
"RecordClassName" => "Page"
"RecordID" => 107
"WasPublished" => 0
"WasDeleted" => 0
"WasDraft" => 0
"AuthorID" => 5
"PublisherID" => 0
]
The following query took 0.004s an returned 0 row(s)
Triggered by: SiteTree->RelativeLink:711 > SiteTree->Link:656 > SiteTree::link_shortcode_handler:636 > ShortcodeParser->callShortcode:171
SELECT
DISTINCT "SiteTree_Versions"."ClassName",
"SiteTree_Versions"."LastEdited",
"SiteTree_Versions"."Created",
"SiteTree_Versions"."Priority",
"SiteTree_Versions"."ShareTokenSalt",
"SiteTree_Versions"."ContentReviewType",
"SiteTree_Versions"."ReviewPeriodDays",
"SiteTree_Versions"."NextReviewDate",
"SiteTree_Versions"."LastEditedByName",
"SiteTree_Versions"."OwnerNames",
"SiteTree_Versions"."ProvideComments",
"SiteTree_Versions"."ModerationRequired",
"SiteTree_Versions"."CommentsRequireLogin",
"SiteTree_Versions"."ShowPageUtilities",
"SiteTree_Versions"."AlgoliaIndexed",
"SiteTree_Versions"."AlgoliaError",
"SiteTree_Versions"."AlgoliaUUID",
"SiteTree_Versions"."CanViewType",
"SiteTree_Versions"."CanEditType",
"SiteTree_Versions"."Version",
"SiteTree_Versions"."URLSegment",
"SiteTree_Versions"."Title",
"SiteTree_Versions"."MenuTitle",
"SiteTree_Versions"."Content",
"SiteTree_Versions"."MetaDescription",
"SiteTree_Versions"."ExtraMeta",
"SiteTree_Versions"."ShowInMenus",
"SiteTree_Versions"."ShowInSearch",
"SiteTree_Versions"."Sort",
"SiteTree_Versions"."HasBrokenFile",
"SiteTree_Versions"."HasBrokenLink",
"SiteTree_Versions"."ReportClass",
"SiteTree_Versions"."WorkflowDefinitionID",
"SiteTree_Versions"."SubsiteID",
"SiteTree_Versions"."ParentID",
"SiteTree_Versions"."RecordID" AS "ID",
CASE WHEN "SiteTree_Versions"."ClassName" IS NOT NULL THEN
"SiteTree_Versions"."ClassName"
ELSE
'SilverStripe\\CMS\\Model\\SiteTree'
END AS "RecordClassName",
"SiteTree_Versions"."RecordID",
"SiteTree_Versions"."WasPublished",
"SiteTree_Versions"."WasDeleted",
"SiteTree_Versions"."WasDraft",
"SiteTree_Versions"."AuthorID",
"SiteTree_Versions"."PublisherID"
FROM
"SiteTree_Versions"
WHERE
(
"SiteTree_Versions"."RecordID" = 538
)
AND (
"SiteTree_Versions"."WasDeleted" = 0
)
AND (
"SiteTree_Versions"."RecordID" = '107'
)
ORDER BY
"SiteTree_Versions"."Version" DESC
LIMIT
1
The following query took 0.0014s an returned 0 row(s)
Triggered by: Versioned::determineVersionNumberByStage:2432 > Versioned::get_versionnumber_by_stage:2396 > Versioned->isOnDraft:2785 > SiteTree->RelativeLink:713
SELECT
"Version"
FROM
"SiteTree"
WHERE
"ID" = 107
The following query took 0.0027s an returned 1 row(s)
Triggered by: Versioned::get_latest_version:2676 > SiteTree->RelativeLink:714 > SiteTree->Link:656 > SiteTree::link_shortcode_handler:636
SELECT
DISTINCT "SiteTree_Versions"."ClassName",
"SiteTree_Versions"."LastEdited",
"SiteTree_Versions"."Created",
"SiteTree_Versions"."Priority",
"SiteTree_Versions"."ShareTokenSalt",
"SiteTree_Versions"."ContentReviewType",
"SiteTree_Versions"."ReviewPeriodDays",
"SiteTree_Versions"."NextReviewDate",
"SiteTree_Versions"."LastEditedByName",
"SiteTree_Versions"."OwnerNames",
"SiteTree_Versions"."ProvideComments",
"SiteTree_Versions"."ModerationRequired",
"SiteTree_Versions"."CommentsRequireLogin",
"SiteTree_Versions"."ShowPageUtilities",
"SiteTree_Versions"."AlgoliaIndexed",
"SiteTree_Versions"."AlgoliaError",
"SiteTree_Versions"."AlgoliaUUID",
"SiteTree_Versions"."CanViewType",
"SiteTree_Versions"."CanEditType",
"SiteTree_Versions"."Version",
"SiteTree_Versions"."URLSegment",
"SiteTree_Versions"."Title",
"SiteTree_Versions"."MenuTitle",
"SiteTree_Versions"."Content",
"SiteTree_Versions"."MetaDescription",
"SiteTree_Versions"."ExtraMeta",
"SiteTree_Versions"."ShowInMenus",
"SiteTree_Versions"."ShowInSearch",
"SiteTree_Versions"."Sort",
"SiteTree_Versions"."HasBrokenFile",
"SiteTree_Versions"."HasBrokenLink",
"SiteTree_Versions"."ReportClass",
"SiteTree_Versions"."WorkflowDefinitionID",
"SiteTree_Versions"."SubsiteID",
"SiteTree_Versions"."ParentID",
"SiteTree_Versions"."RecordID" AS "ID",
CASE WHEN "SiteTree_Versions"."ClassName" IS NOT NULL THEN
"SiteTree_Versions"."ClassName"
ELSE
'SilverStripe\\CMS\\Model\\SiteTree'
END AS "RecordClassName",
"SiteTree_Versions"."RecordID",
"SiteTree_Versions"."WasPublished",
"SiteTree_Versions"."WasDeleted",
"SiteTree_Versions"."WasDraft",
"SiteTree_Versions"."AuthorID",
"SiteTree_Versions"."PublisherID"
FROM
"SiteTree_Versions"
WHERE
(
"SiteTree_Versions"."WasDeleted" = 0
)
AND (
"SiteTree_Versions"."RecordID" = 538
)
AND (
"SiteTree_Versions"."SubsiteID" IN (4)
)
ORDER BY
"SiteTree_Versions"."Version" DESC
LIMIT
1 array:43 [
"ClassName" => "Page"
"LastEdited" => "2014-03-07 13:50:11"
"Created" => "2014-03-07 13:49:46"
"Priority" => null
"ShareTokenSalt" => null
"ContentReviewType" => "Inherit"
"ReviewPeriodDays" => 0
"NextReviewDate" => null
"LastEditedByName" => null
"OwnerNames" => null
"ProvideComments" => 0
"ModerationRequired" => "None"
"CommentsRequireLogin" => 0
"ShowPageUtilities" => 1
"AlgoliaIndexed" => null
"AlgoliaError" => null
"AlgoliaUUID" => null
"CanViewType" => "Inherit"
"CanEditType" => "Inherit"
"Version" => 2
"URLSegment" => "backup-pages-drafts"
"Title" => "backup pages, drafts"
"MenuTitle" => null
"Content" => null
"MetaDescription" => null
"ExtraMeta" => null
"ShowInMenus" => 1
"ShowInSearch" => 1
"Sort" => 48
"HasBrokenFile" => 0
"HasBrokenLink" => 0
"ReportClass" => null
"WorkflowDefinitionID" => 0
"SubsiteID" => 4
"ParentID" => 0
"ID" => 538
"RecordClassName" => "Page"
"RecordID" => 538
"WasPublished" => 0
"WasDeleted" => 0
"WasDraft" => 0
"AuthorID" => 5
"PublisherID" => 0
]
The following query took 0.0016s an returned 1 row(s)
Triggered by: SiteTree::link_shortcode_handler:630 > ShortcodeParser->callShortcode:171 > ShortcodeParser->getShortcodeReplacementText:189 > ShortcodeParser->SilverStripe\View\Parsers\{closure}:482SELECT
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" = 108)
ORDER BY
"SiteTree_Live"."Sort" ASC
LIMIT
1 array:37 [
"ClassName" => "Page"
"LastEdited" => "2019-08-30 15:55:46"
"Created" => "2013-06-18 17:25:44"
"Priority" => null
"ShareTokenSalt" => null
"ContentReviewType" => "Inherit"
"ReviewPeriodDays" => 0
"NextReviewDate" => null
"LastEditedByName" => "Elliot Sawyer"
"OwnerNames" => null
"ProvideComments" => 0
"ModerationRequired" => "None"
"CommentsRequireLogin" => 0
"ShowPageUtilities" => 1
"AlgoliaIndexed" => null
"AlgoliaError" => null
"AlgoliaUUID" => null
"CanViewType" => "Inherit"
"CanEditType" => "Inherit"
"Version" => 17
"URLSegment" => "mlva"
"Title" => "Molecular Typing for MLVA"
"MenuTitle" => "MLVA"
"Content" => null
"MetaDescription" => null
"ExtraMeta" => null
"ShowInMenus" => 1
"ShowInSearch" => 1
"Sort" => 2
"HasBrokenFile" => 0
"HasBrokenLink" => 0
"ReportClass" => null
"WorkflowDefinitionID" => 0
"SubsiteID" => 4
"ParentID" => 104
"ID" => 108
"RecordClassName" => "Page"
]
The following query took 0.0022s an returned 1 row(s)
Triggered by: SiteTree->RelativeLink:711 > SiteTree->Link:656 > SiteTree::link_shortcode_handler:636 > ShortcodeParser->callShortcode:171
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" = 104)
ORDER BY
"SiteTree_Live"."Sort" ASC
LIMIT
1 array:37 [
"ClassName" => "Page"
"LastEdited" => "2019-08-30 15:55:51"
"Created" => "2013-06-18 17:25:05"
"Priority" => null
"ShareTokenSalt" => null
"ContentReviewType" => "Inherit"
"ReviewPeriodDays" => 0
"NextReviewDate" => null
"LastEditedByName" => "Elliot Sawyer"
"OwnerNames" => null
"ProvideComments" => 0
"ModerationRequired" => "None"
"CommentsRequireLogin" => 0
"ShowPageUtilities" => 1
"AlgoliaIndexed" => null
"AlgoliaError" => null
"AlgoliaUUID" => null
"CanViewType" => "Inherit"
"CanEditType" => "Inherit"
"Version" => 35
"URLSegment" => "protocols"
"Title" => "Molecular Typing"
"MenuTitle" => null
"Content" => null
"MetaDescription" => null
"ExtraMeta" => null
"ShowInMenus" => 1
"ShowInSearch" => 1
"Sort" => 5
"HasBrokenFile" => 0
"HasBrokenLink" => 0
"ReportClass" => null
"WorkflowDefinitionID" => 0
"SubsiteID" => 4
"ParentID" => 0
"ID" => 104
"RecordClassName" => "Page"
]
The following query took 0.0023s 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" = 137
)
) 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 (4)
)
) 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.0018s an returned 0 row(s)
Triggered by: Hierarchy->Children:207 > SidebarNav.ss > Page.ss > Page.ss > Controller->handleAction:290
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" = 137)
AND (
"SiteTree_Live"."ShowInMenus" = 1
)
AND (
"SiteTree_Live"."SubsiteID" IN (4)
)
ORDER BY
"SiteTree_Live"."Sort" ASC
The following query took 0.003s an returned 0 row(s)
Triggered by: BasePage->getFooter:97 > WateaFooter.ss > Page.ss > Controller->handleAction:290
SELECT
DISTINCT "SiteTree_Live"."ClassName",
"SiteTree_Live"."LastEdited",
"SiteTree_Live"."Created",
"SiteTree_Live"."Priority",
"SiteTree_Live"."ShareTokenSalt",
"SiteTree_Live"."ContentReviewType",
"SiteTree_Live"."ReviewPeriodDays",
"SiteTree_Live"."NextReviewDate",
"SiteTree_Live"."LastEditedByName",
"SiteTree_Live"."OwnerNames",
"SiteTree_Live"."ProvideComments",
"SiteTree_Live"."ModerationRequired",
"SiteTree_Live"."CommentsRequireLogin",
"SiteTree_Live"."ShowPageUtilities",
"SiteTree_Live"."AlgoliaIndexed",
"SiteTree_Live"."AlgoliaError",
"SiteTree_Live"."AlgoliaUUID",
"SiteTree_Live"."CanViewType",
"SiteTree_Live"."CanEditType",
"SiteTree_Live"."Version",
"SiteTree_Live"."URLSegment",
"SiteTree_Live"."Title",
"SiteTree_Live"."MenuTitle",
"SiteTree_Live"."Content",
"SiteTree_Live"."MetaDescription",
"SiteTree_Live"."ExtraMeta",
"SiteTree_Live"."ShowInMenus",
"SiteTree_Live"."ShowInSearch",
"SiteTree_Live"."Sort",
"SiteTree_Live"."HasBrokenFile",
"SiteTree_Live"."HasBrokenLink",
"SiteTree_Live"."ReportClass",
"SiteTree_Live"."WorkflowDefinitionID",
"SiteTree_Live"."SubsiteID",
"SiteTree_Live"."ParentID",
"Page_Live"."Intro",
"Page_Live"."TeReoMenuTitle",
"Page_Live"."AddInfoTitle",
"Page_Live"."AdditionalInformation",
"Page_Live"."RightMenuTitle",
"Page_Live"."RightHandMenu",
"Page_Live"."RightMenuVideo",
"Page_Live"."AddInfoVideo",
"Page_Live"."InFooter",
"Page_Live"."HideTitle",
"Page_Live"."HideInThisSection",
"Page_Live"."DisableRichLinks",
"Page_Live"."ElementalAreaID",
"Page_Live"."AddInfoImageID",
"Page_Live"."RightMenuImageID",
"Page_Live"."HeroImageID",
"Page_Live"."HeroImageMobileID",
"RedirectorPage_Live"."RedirectionType",
"RedirectorPage_Live"."ExternalURL",
"RedirectorPage_Live"."LinkToID",
"RedirectorPage_Live"."LinkToFileID",
"SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN
"SiteTree_Live"."ClassName"
ELSE
'SilverStripe\\CMS\\Model\\SiteTree'
END AS "RecordClassName"
FROM
"SiteTree_Live"
LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID"
LEFT JOIN "RedirectorPage_Live" ON "RedirectorPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE
(
"SiteTree_Live"."ClassName" IN (
'CWP\\CWP\\PageTypes\\FooterHolder'
)
)
AND (
"SiteTree_Live"."SubsiteID" IN (4)
)
ORDER BY
"SiteTree_Live"."Sort" ASC
LIMIT
1
The following query took 0.0015s 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" = 137
array:1 [
"Version" => 17
]
The following query took 0.002s 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" = 137)
ORDER BY
"SiteTree_Live"."Sort" ASC
LIMIT
1 array:37 [
"ClassName" => "Page"
"LastEdited" => "2019-08-30 15:55:53"
"Created" => "2013-06-19 09:47:23"
"Priority" => null
"ShareTokenSalt" => null
"ContentReviewType" => "Inherit"
"ReviewPeriodDays" => 0
"NextReviewDate" => null
"LastEditedByName" => "Elliot Sawyer"
"OwnerNames" => null
"ProvideComments" => 0
"ModerationRequired" => "None"
"CommentsRequireLogin" => 0
"ShowPageUtilities" => 1
"AlgoliaIndexed" => null
"AlgoliaError" => null
"AlgoliaUUID" => null
"CanViewType" => "Inherit"
"CanEditType" => "Inherit"
"Version" => 17
"URLSegment" => "pulsenetexplained"
"Title" => "PulseNet Explained"
"MenuTitle" => null
"Content" => null
"MetaDescription" => null
"ExtraMeta" => null
"ShowInMenus" => 1
"ShowInSearch" => 1
"Sort" => 7
"HasBrokenFile" => 0
"HasBrokenLink" => 1
"ReportClass" => null
"WorkflowDefinitionID" => 0
"SubsiteID" => 4
"ParentID" => 120
"ID" => 137
"RecordClassName" => "Page"
]
The following query took 0.0013s 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" = 137)
ORDER BY
"SiteTree_Live"."Sort" ASC
LIMIT
1 array:37 [
"ClassName" => "Page"
"LastEdited" => "2019-08-30 15:55:53"
"Created" => "2013-06-19 09:47:23"
"Priority" => null
"ShareTokenSalt" => null
"ContentReviewType" => "Inherit"
"ReviewPeriodDays" => 0
"NextReviewDate" => null
"LastEditedByName" => "Elliot Sawyer"
"OwnerNames" => null
"ProvideComments" => 0
"ModerationRequired" => "None"
"CommentsRequireLogin" => 0
"ShowPageUtilities" => 1
"AlgoliaIndexed" => null
"AlgoliaError" => null
"AlgoliaUUID" => null
"CanViewType" => "Inherit"
"CanEditType" => "Inherit"
"Version" => 17
"URLSegment" => "pulsenetexplained"
"Title" => "PulseNet Explained"
"MenuTitle" => null
"Content" => null
"MetaDescription" => null
"ExtraMeta" => null
"ShowInMenus" => 1
"ShowInSearch" => 1
"Sort" => 7
"HasBrokenFile" => 0
"HasBrokenLink" => 1
"ReportClass" => null
"WorkflowDefinitionID" => 0
"SubsiteID" => 4
"ParentID" => 120
"ID" => 137
"RecordClassName" => "Page"
]
The following query took 0.0013s an returned 1 row(s)
Triggered by: SiteTree->RelativeLink:711 > SiteTree->Link:656 > SiteTreeSubsites->alternateAbsoluteLink:426 > SiteTree->AbsoluteLink:671
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" = 120)
ORDER BY
"SiteTree_Live"."Sort" ASC
LIMIT
1 array:37 [
"ClassName" => "Page"
"LastEdited" => "2019-08-30 15:55:47"
"Created" => "2013-06-19 09:47:18"
"Priority" => null
"ShareTokenSalt" => null
"ContentReviewType" => "Inherit"
"ReviewPeriodDays" => 0
"NextReviewDate" => null
"LastEditedByName" => "Elliot Sawyer"
"OwnerNames" => null
"ProvideComments" => 0
"ModerationRequired" => "None"
"CommentsRequireLogin" => 0
"ShowPageUtilities" => 1
"AlgoliaIndexed" => null
"AlgoliaError" => null
"AlgoliaUUID" => null
"CanViewType" => "Inherit"
"CanEditType" => "Inherit"
"Version" => 6
"URLSegment" => "international"
"Title" => "PulseNet International"
"MenuTitle" => "International"
"Content" => null
"MetaDescription" => null
"ExtraMeta" => null
"ShowInMenus" => 1
"ShowInSearch" => 1
"Sort" => 2
"HasBrokenFile" => 0
"HasBrokenLink" => 0
"ReportClass" => null
"WorkflowDefinitionID" => 0
"SubsiteID" => 4
"ParentID" => 0
"ID" => 120
"RecordClassName" => "Page"
]
The following query took 0.0016s 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" = 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.0014s 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" = 4)
ORDER BY
"SubsiteDomain"."IsPrimary" DESC
LIMIT
1 array:9 [
"ClassName" => "SilverStripe\Subsites\Model\SubsiteDomain"
"LastEdited" => "2024-10-07 19:25:20"
"Created" => "2024-10-07 19:25:20"
"Domain" => "test.pulsenetinternational.org"
"Protocol" => "automatic"
"IsPrimary" => 1
"SubsiteID" => 4
"ID" => 75
"RecordClassName" => "SilverStripe\Subsites\Model\SubsiteDomain"
]
The following query took 0.0025s 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" = 137)
ORDER BY
"SiteTree"."Sort" ASC
LIMIT
1 array:37 [
"ClassName" => "Page"
"LastEdited" => "2019-08-30 15:55:53"
"Created" => "2013-06-19 09:47:23"
"Priority" => null
"ShareTokenSalt" => null
"ContentReviewType" => "Inherit"
"ReviewPeriodDays" => 0
"NextReviewDate" => null
"LastEditedByName" => "Elliot Sawyer"
"OwnerNames" => null
"ProvideComments" => 0
"ModerationRequired" => "None"
"CommentsRequireLogin" => 0
"ShowPageUtilities" => 1
"AlgoliaIndexed" => null
"AlgoliaError" => null
"AlgoliaUUID" => null
"CanViewType" => "Inherit"
"CanEditType" => "Inherit"
"Version" => 17
"URLSegment" => "pulsenetexplained"
"Title" => "PulseNet Explained"
"MenuTitle" => null
"Content" => null
"MetaDescription" => null
"ExtraMeta" => null
"ShowInMenus" => 1
"ShowInSearch" => 1
"Sort" => 7
"HasBrokenFile" => 0
"HasBrokenLink" => 1
"ReportClass" => null
"WorkflowDefinitionID" => 0
"SubsiteID" => 4
"ParentID" => 120
"ID" => 137
"RecordClassName" => "Page"
]
The following query took 0.0019s 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" = 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.0012s 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" = 4)
ORDER BY
"SubsiteDomain"."IsPrimary" DESC
LIMIT
1 array:9 [
"ClassName" => "SilverStripe\Subsites\Model\SubsiteDomain"
"LastEdited" => "2024-10-07 19:25:20"
"Created" => "2024-10-07 19:25:20"
"Domain" => "test.pulsenetinternational.org"
"Protocol" => "automatic"
"IsPrimary" => 1
"SubsiteID" => 4
"ID" => 75
"RecordClassName" => "SilverStripe\Subsites\Model\SubsiteDomain"
]
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" = 4)
ORDER BY
"SubsiteDomain"."IsPrimary" DESC
LIMIT
1 array:9 [
"ClassName" => "SilverStripe\Subsites\Model\SubsiteDomain"
"LastEdited" => "2024-10-07 19:25:20"
"Created" => "2024-10-07 19:25:20"
"Domain" => "test.pulsenetinternational.org"
"Protocol" => "automatic"
"IsPrimary" => 1
"SubsiteID" => 4
"ID" => 75
"RecordClassName" => "SilverStripe\Subsites\Model\SubsiteDomain"
]
The following query took 0.0015s 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" = 137)
ORDER BY
"SiteTree_Live"."Sort" ASC
LIMIT
1 array:37 [
"ClassName" => "Page"
"LastEdited" => "2019-08-30 15:55:53"
"Created" => "2013-06-19 09:47:23"
"Priority" => null
"ShareTokenSalt" => null
"ContentReviewType" => "Inherit"
"ReviewPeriodDays" => 0
"NextReviewDate" => null
"LastEditedByName" => "Elliot Sawyer"
"OwnerNames" => null
"ProvideComments" => 0
"ModerationRequired" => "None"
"CommentsRequireLogin" => 0
"ShowPageUtilities" => 1
"AlgoliaIndexed" => null
"AlgoliaError" => null
"AlgoliaUUID" => null
"CanViewType" => "Inherit"
"CanEditType" => "Inherit"
"Version" => 17
"URLSegment" => "pulsenetexplained"
"Title" => "PulseNet Explained"
"MenuTitle" => null
"Content" => null
"MetaDescription" => null
"ExtraMeta" => null
"ShowInMenus" => 1
"ShowInSearch" => 1
"Sort" => 7
"HasBrokenFile" => 0
"HasBrokenLink" => 1
"ReportClass" => null
"WorkflowDefinitionID" => 0
"SubsiteID" => 4
"ParentID" => 120
"ID" => 137
"RecordClassName" => "Page"
]
The following query took 0.0014s an returned 1 row(s)
Triggered by: SiteTree->RelativeLink:711 > SiteTree->Link:656 > SiteTreeSubsites->alternateAbsoluteLink:426 > SiteTree->AbsoluteLink:671
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" = 120)
ORDER BY
"SiteTree_Live"."Sort" ASC
LIMIT
1 array:37 [
"ClassName" => "Page"
"LastEdited" => "2019-08-30 15:55:47"
"Created" => "2013-06-19 09:47:18"
"Priority" => null
"ShareTokenSalt" => null
"ContentReviewType" => "Inherit"
"ReviewPeriodDays" => 0
"NextReviewDate" => null
"LastEditedByName" => "Elliot Sawyer"
"OwnerNames" => null
"ProvideComments" => 0
"ModerationRequired" => "None"
"CommentsRequireLogin" => 0
"ShowPageUtilities" => 1
"AlgoliaIndexed" => null
"AlgoliaError" => null
"AlgoliaUUID" => null
"CanViewType" => "Inherit"
"CanEditType" => "Inherit"
"Version" => 6
"URLSegment" => "international"
"Title" => "PulseNet International"
"MenuTitle" => "International"
"Content" => null
"MetaDescription" => null
"ExtraMeta" => null
"ShowInMenus" => 1
"ShowInSearch" => 1
"Sort" => 2
"HasBrokenFile" => 0
"HasBrokenLink" => 0
"ReportClass" => null
"WorkflowDefinitionID" => 0
"SubsiteID" => 4
"ParentID" => 0
"ID" => 120
"RecordClassName" => "Page"
]
The following query took 0.001s 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" = 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.0014s 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" = 4)
ORDER BY
"SubsiteDomain"."IsPrimary" DESC
LIMIT
1 array:9 [
"ClassName" => "SilverStripe\Subsites\Model\SubsiteDomain"
"LastEdited" => "2024-10-07 19:25:20"
"Created" => "2024-10-07 19:25:20"
"Domain" => "test.pulsenetinternational.org"
"Protocol" => "automatic"
"IsPrimary" => 1
"SubsiteID" => 4
"ID" => 75
"RecordClassName" => "SilverStripe\Subsites\Model\SubsiteDomain"
]