0003: SELECT DISTINCT count(DISTINCT "SubsiteDomain"."ID") AS "Count"
FROM "SubsiteDomain" INNER JOIN "Subsite" ON "Subsite"."ID" = "SubsiteDomain"."SubsiteID" AND "Subsite"."IsPublic"=1
WHERE ('test.strmix.com' LIKE replace("SubsiteDomain"."Domain",'*','%'))
0.0012s
0004: SELECT "SubsiteDomain"."SubsiteID", "SubsiteDomain"."IsPrimary" AS "_SortColumn0"
FROM "SubsiteDomain" INNER JOIN "Subsite" ON "Subsite"."ID" = "SubsiteDomain"."SubsiteID" AND "Subsite"."IsPublic"=1
WHERE ('test.strmix.com' LIKE replace("SubsiteDomain"."Domain",'*','%'))
ORDER BY "_SortColumn0" DESC
0.0011s
0005: SELECT "SubsiteDomain"."Domain", "SubsiteDomain"."IsPrimary" AS "_SortColumn0"
FROM "SubsiteDomain" INNER JOIN "Subsite" ON "Subsite"."ID" = "SubsiteDomain"."SubsiteID" AND "Subsite"."IsPublic"=1
WHERE ('test.strmix.com' LIKE replace("SubsiteDomain"."Domain",'*','%'))
ORDER BY "_SortColumn0" DESC
0.0011s
0006: SHOW FULL FIELDS IN "Member"
0.003s
0007: SHOW COLLATION LIKE 'utf8_general_ci'
0.002s
0008: SHOW FULL FIELDS IN "Group"
0.0011s
0009: SHOW FULL FIELDS IN "Permission"
0.0014s
0010: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."AlgoliaIndexed", "SiteTree_Live"."AlgoliaError", "SiteTree_Live"."AlgoliaUUID", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."URLSegment" = ?)
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."SubsiteID" IN (33))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0024s
0011: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."AlgoliaIndexed", "SiteTree_Live"."AlgoliaError", "SiteTree_Live"."AlgoliaUUID", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."URLSegment" = ?)
AND ("SiteTree_Live"."SubsiteID" IN (33))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0025s
0012: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."AlgoliaIndexed", "SiteTree_Live"."AlgoliaError", "SiteTree_Live"."AlgoliaUUID", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0024s
0013: SELECT DISTINCT "Subsite"."ClassName", "Subsite"."LastEdited", "Subsite"."Created", "Subsite"."Title", "Subsite"."RedirectURL", "Subsite"."DefaultSite", "Subsite"."Theme", "Subsite"."Language", "Subsite"."IsPublic", "Subsite"."PageTypeBlacklist", "Subsite"."ID",
CASE WHEN "Subsite"."ClassName" IS NOT NULL THEN "Subsite"."ClassName"
ELSE 'SilverStripe\\Subsites\\Model\\Subsite' END AS "RecordClassName"
FROM "Subsite"
WHERE ("Subsite"."ID" = ?)
ORDER BY "Subsite"."Title" ASC
LIMIT 1
0.0031s
0015: SELECT DISTINCT "Subsite"."ClassName", "Subsite"."LastEdited", "Subsite"."Created", "Subsite"."Title", "Subsite"."RedirectURL", "Subsite"."DefaultSite", "Subsite"."Theme", "Subsite"."Language", "Subsite"."IsPublic", "Subsite"."PageTypeBlacklist", "Subsite"."ID",
CASE WHEN "Subsite"."ClassName" IS NOT NULL THEN "Subsite"."ClassName"
ELSE 'SilverStripe\\Subsites\\Model\\Subsite' END AS "RecordClassName"
FROM "Subsite"
WHERE ("Subsite"."ID" = ?)
ORDER BY "Subsite"."Title" ASC
LIMIT 1
0.0014s
0017: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."AlgoliaIndexed", "SiteTree_Live"."AlgoliaError", "SiteTree_Live"."AlgoliaUUID", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", "Page_Live"."Intro", "Page_Live"."TeReoMenuTitle", "Page_Live"."AddInfoTitle", "Page_Live"."AdditionalInformation", "Page_Live"."RightMenuTitle", "Page_Live"."RightHandMenu", "Page_Live"."RightMenuVideo", "Page_Live"."AddInfoVideo", "Page_Live"."InFooter", "Page_Live"."HideTitle", "Page_Live"."HideInThisSection", "Page_Live"."DisableRichLinks", "Page_Live"."ElementalAreaID", "Page_Live"."AddInfoImageID", "Page_Live"."RightMenuImageID", "Page_Live"."HeroImageID", "Page_Live"."HeroImageMobileID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ClassName" IN (?, ?))
AND ("SiteTree_Live"."SubsiteID" IN (33))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0031s
0018: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."AlgoliaIndexed", "SiteTree_Live"."AlgoliaError", "SiteTree_Live"."AlgoliaUUID", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0019s
0019: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."AlgoliaIndexed", "SiteTree_Live"."AlgoliaError", "SiteTree_Live"."AlgoliaUUID", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND ("SiteTree_Live"."SubsiteID" IN (33))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0026s
0020: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."AlgoliaIndexed", "SiteTree_Live"."AlgoliaError", "SiteTree_Live"."AlgoliaUUID", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", "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 ("SiteTree_Live"."ClassName" IN (?))
AND ("SiteTree_Live"."SubsiteID" IN (33))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0045s
0021: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited")
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND ("SiteTree_Live"."SubsiteID" IN (33))
0.0086s
0022: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", 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\\StrmixNewsPage') THEN "Strmix_Strmix_Pages_StrmixNewsPage_Live"."HideTitle" WHEN "SiteTree_Live"."ClassName" IN ('Strmix\\Strmix\\Pages\\StrmixNewsPage') THEN "Strmix_Strmix_Pages_StrmixNewsPage_Live"."HideTitle" ELSE NULL END AS "HideTitle", "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 "DatedUpdatePage_Live" ON "DatedUpdatePage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "NewsPage_Live" ON "NewsPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "Strmix_Strmix_Pages_StrmixNewsPage_Live" ON "Strmix_Strmix_Pages_StrmixNewsPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0046s
0023: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "DatedUpdatePage_Live"."Abstract", "DatedUpdatePage_Live"."Date", "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 "DatedUpdatePage_Live" ON "DatedUpdatePage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0029s
0024: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE WHEN "SiteTree_Live"."ClassName" IN ('CWP\\CWP\\PageTypes\\NewsPage', 'ESR\\ESR\\Pages\\EsrPublicationPage', 'Strmix\\Strmix\\Pages\\StrmixNewsPage') THEN "NewsPage_Live"."ContactTitle" WHEN "SiteTree_Live"."ClassName" IN ('ESR\\ESR\\Pages\\EsrPublicationPage') THEN "EsrPublicationPage_Live"."ContactTitle" ELSE NULL END AS "ContactTitle", CASE WHEN "SiteTree_Live"."ClassName" IN ('CWP\\CWP\\PageTypes\\NewsPage', 'ESR\\ESR\\Pages\\EsrPublicationPage', 'Strmix\\Strmix\\Pages\\StrmixNewsPage') THEN "NewsPage_Live"."ContactText" WHEN "SiteTree_Live"."ClassName" IN ('ESR\\ESR\\Pages\\EsrPublicationPage') THEN "EsrPublicationPage_Live"."ContactText" ELSE NULL END AS "ContactText", CASE WHEN "SiteTree_Live"."ClassName" IN ('CWP\\CWP\\PageTypes\\NewsPage', 'ESR\\ESR\\Pages\\EsrPublicationPage', 'Strmix\\Strmix\\Pages\\StrmixNewsPage') THEN "NewsPage_Live"."ContactEmail" WHEN "SiteTree_Live"."ClassName" IN ('ESR\\ESR\\Pages\\EsrPublicationPage') THEN "EsrPublicationPage_Live"."ContactEmail" ELSE NULL END AS "ContactEmail", CASE WHEN "SiteTree_Live"."ClassName" IN ('CWP\\CWP\\PageTypes\\NewsPage', 'ESR\\ESR\\Pages\\EsrPublicationPage', 'Strmix\\Strmix\\Pages\\StrmixNewsPage') THEN "NewsPage_Live"."ContactPhone" WHEN "SiteTree_Live"."ClassName" IN ('ESR\\ESR\\Pages\\EsrPublicationPage') THEN "EsrPublicationPage_Live"."ContactPhone" ELSE NULL END AS "ContactPhone", CASE WHEN "SiteTree_Live"."ClassName" IN ('CWP\\CWP\\PageTypes\\NewsPage', 'ESR\\ESR\\Pages\\EsrPublicationPage', 'Strmix\\Strmix\\Pages\\StrmixNewsPage') THEN "NewsPage_Live"."HideContact" WHEN "SiteTree_Live"."ClassName" IN ('ESR\\ESR\\Pages\\EsrPublicationPage') THEN "EsrPublicationPage_Live"."HideContact" ELSE NULL END AS "HideContact", "NewsPage_Live"."NewsContent", "NewsPage_Live"."Author", CASE WHEN "SiteTree_Live"."ClassName" IN ('CWP\\CWP\\PageTypes\\NewsPage', 'ESR\\ESR\\Pages\\EsrPublicationPage', 'Strmix\\Strmix\\Pages\\StrmixNewsPage') THEN "NewsPage_Live"."ContactLinkID" WHEN "SiteTree_Live"."ClassName" IN ('ESR\\ESR\\Pages\\EsrPublicationPage') THEN "EsrPublicationPage_Live"."ContactLinkID" ELSE NULL END AS "ContactLinkID", "NewsPage_Live"."FeaturedImageID", "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 "DatedUpdatePage_Live" ON "DatedUpdatePage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "NewsPage_Live" ON "NewsPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "EsrPublicationPage_Live" ON "EsrPublicationPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0036s
0025: 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", "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 "EsrHomePage_Live" ON "EsrHomePage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0029s
0026: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0019s
0027: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "Element_Live"."Version", "Element_Live"."Title", "Element_Live"."ShowTitle", "Element_Live"."Sort", "Element_Live"."ExtraClass", "Element_Live"."Style", "Element_Live"."TopPageID", "Element_Live"."ParentID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName"
FROM "Element_Live"
WHERE ("Element_Live"."ParentID" = ?)
ORDER BY "Element_Live"."Sort" ASC
0.0024s
0028: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0019s
0029: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."AlgoliaIndexed", "SiteTree_Live"."AlgoliaError", "SiteTree_Live"."AlgoliaUUID", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", "Page_Live"."Intro", "Page_Live"."TeReoMenuTitle", "Page_Live"."AddInfoTitle", "Page_Live"."AdditionalInformation", "Page_Live"."RightMenuTitle", "Page_Live"."RightHandMenu", "Page_Live"."RightMenuVideo", "Page_Live"."AddInfoVideo", "Page_Live"."InFooter", "Page_Live"."HideTitle", "Page_Live"."HideInThisSection", "Page_Live"."DisableRichLinks", "Page_Live"."ElementalAreaID", "Page_Live"."AddInfoImageID", "Page_Live"."RightMenuImageID", "Page_Live"."HeroImageID", "Page_Live"."HeroImageMobileID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("Page_Live"."ElementalAreaID" = ?)
AND ("SiteTree_Live"."ClassName" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND ("SiteTree_Live"."SubsiteID" IN (33))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.004s
0030: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."AlgoliaIndexed", "SiteTree_Live"."AlgoliaError", "SiteTree_Live"."AlgoliaUUID", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", "Page_Live"."Intro", "Page_Live"."TeReoMenuTitle", "Page_Live"."AddInfoTitle", "Page_Live"."AdditionalInformation", "Page_Live"."RightMenuTitle", "Page_Live"."RightHandMenu", "Page_Live"."RightMenuVideo", "Page_Live"."AddInfoVideo", "Page_Live"."InFooter", "Page_Live"."HideTitle", "Page_Live"."HideInThisSection", "Page_Live"."DisableRichLinks", "Page_Live"."ElementalAreaID", "Page_Live"."AddInfoImageID", "Page_Live"."RightMenuImageID", "Page_Live"."HeroImageID", "Page_Live"."HeroImageMobileID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID"
WHERE (("Page_Live"."ElementalAreaID" = ?))
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND ("SiteTree_Live"."SubsiteID" IN (33))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0078s
0031: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."AlgoliaIndexed", "SiteTree_Live"."AlgoliaError", "SiteTree_Live"."AlgoliaUUID", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0046s
0032: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0023s
0033: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementContent_Live"."HTML", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementContent_Live" ON "ElementContent_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?, ?, ?, ?, ?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0023s
0034: SELECT CASE WHEN EXISTS(SELECT *
FROM "TaxonomyTerm" INNER JOIN "BasePage_Terms" ON "BasePage_Terms"."TaxonomyTermID" = "TaxonomyTerm"."ID"
WHERE ("BasePage_Terms"."BasePageID" = ?)) THEN 1 ELSE 0 END
0.0019s
0035: SELECT CASE WHEN EXISTS(SELECT *
FROM "SiteTree_Live" INNER JOIN (SELECT DISTINCT "BasePage_RelatedPages_Live"."ClassName", "BasePage_RelatedPages_Live"."LastEdited", "BasePage_RelatedPages_Live"."Created", "BasePage_RelatedPages_Live"."Version", "BasePage_RelatedPages_Live"."SortOrder", "BasePage_RelatedPages_Live"."BasePageID", "BasePage_RelatedPages_Live"."ChildID", "BasePage_RelatedPages_Live"."ID",
CASE WHEN "BasePage_RelatedPages_Live"."ClassName" IS NOT NULL THEN "BasePage_RelatedPages_Live"."ClassName"
ELSE 'CWP\\CWP\\Model\\RelatedPageLink' END AS "RecordClassName"
FROM "BasePage_RelatedPages_Live"
WHERE ("BasePage_RelatedPages_Live"."BasePageID" = ?)) AS "BasePage_RelatedPages" ON "BasePage_RelatedPages"."ChildID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND ("SiteTree_Live"."SubsiteID" IN (33))) THEN 1 ELSE 0 END
0.0035s
0036: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited")
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND ("SiteTree_Live"."SubsiteID" IN (33))
0.003s
0037: SELECT "Version" FROM "SiteTree" WHERE "ID" = ?
0.0026s
0038: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."AlgoliaIndexed", "SiteTree_Live"."AlgoliaError", "SiteTree_Live"."AlgoliaUUID", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0023s
0039: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."AlgoliaIndexed", "SiteTree_Live"."AlgoliaError", "SiteTree_Live"."AlgoliaUUID", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0027s
0040: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."AlgoliaIndexed", "SiteTree_Live"."AlgoliaError", "SiteTree_Live"."AlgoliaUUID", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.002s
0041: SELECT DISTINCT "Subsite"."ClassName", "Subsite"."LastEdited", "Subsite"."Created", "Subsite"."Title", "Subsite"."RedirectURL", "Subsite"."DefaultSite", "Subsite"."Theme", "Subsite"."Language", "Subsite"."IsPublic", "Subsite"."PageTypeBlacklist", "Subsite"."ID",
CASE WHEN "Subsite"."ClassName" IS NOT NULL THEN "Subsite"."ClassName"
ELSE 'SilverStripe\\Subsites\\Model\\Subsite' END AS "RecordClassName"
FROM "Subsite"
WHERE ("Subsite"."ID" = ?)
ORDER BY "Subsite"."Title" ASC
LIMIT 1
0.0016s
0042: SELECT DISTINCT "SubsiteDomain"."ClassName", "SubsiteDomain"."LastEdited", "SubsiteDomain"."Created", "SubsiteDomain"."Domain", "SubsiteDomain"."Protocol", "SubsiteDomain"."IsPrimary", "SubsiteDomain"."SubsiteID", "SubsiteDomain"."ID",
CASE WHEN "SubsiteDomain"."ClassName" IS NOT NULL THEN "SubsiteDomain"."ClassName"
ELSE 'SilverStripe\\Subsites\\Model\\SubsiteDomain' END AS "RecordClassName"
FROM "SubsiteDomain"
WHERE ("SubsiteDomain"."SubsiteID" = ?)
ORDER BY "SubsiteDomain"."IsPrimary" DESC
LIMIT 1
0.0036s
0043: SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", "SiteTree"."Priority", "SiteTree"."ShareTokenSalt", "SiteTree"."ContentReviewType", "SiteTree"."ReviewPeriodDays", "SiteTree"."NextReviewDate", "SiteTree"."LastEditedByName", "SiteTree"."OwnerNames", "SiteTree"."ProvideComments", "SiteTree"."ModerationRequired", "SiteTree"."CommentsRequireLogin", "SiteTree"."ShowPageUtilities", "SiteTree"."AlgoliaIndexed", "SiteTree"."AlgoliaError", "SiteTree"."AlgoliaUUID", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."Version", "SiteTree"."URLSegment", "SiteTree"."Title", "SiteTree"."MenuTitle", "SiteTree"."Content", "SiteTree"."MetaDescription", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", "SiteTree"."ReportClass", "SiteTree"."WorkflowDefinitionID", "SiteTree"."SubsiteID", "SiteTree"."ParentID", "SiteTree"."ID",
CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree"
WHERE ("SiteTree"."ID" = ?)
ORDER BY "SiteTree"."Sort" ASC
LIMIT 1
0.0049s
0044: SELECT DISTINCT "Subsite"."ClassName", "Subsite"."LastEdited", "Subsite"."Created", "Subsite"."Title", "Subsite"."RedirectURL", "Subsite"."DefaultSite", "Subsite"."Theme", "Subsite"."Language", "Subsite"."IsPublic", "Subsite"."PageTypeBlacklist", "Subsite"."ID",
CASE WHEN "Subsite"."ClassName" IS NOT NULL THEN "Subsite"."ClassName"
ELSE 'SilverStripe\\Subsites\\Model\\Subsite' END AS "RecordClassName"
FROM "Subsite"
WHERE ("Subsite"."ID" = ?)
ORDER BY "Subsite"."Title" ASC
LIMIT 1
0.0032s
0045: SELECT DISTINCT "SubsiteDomain"."ClassName", "SubsiteDomain"."LastEdited", "SubsiteDomain"."Created", "SubsiteDomain"."Domain", "SubsiteDomain"."Protocol", "SubsiteDomain"."IsPrimary", "SubsiteDomain"."SubsiteID", "SubsiteDomain"."ID",
CASE WHEN "SubsiteDomain"."ClassName" IS NOT NULL THEN "SubsiteDomain"."ClassName"
ELSE 'SilverStripe\\Subsites\\Model\\SubsiteDomain' END AS "RecordClassName"
FROM "SubsiteDomain"
WHERE ("SubsiteDomain"."SubsiteID" = ?)
ORDER BY "SubsiteDomain"."IsPrimary" DESC
LIMIT 1
0.0019s
0046: SELECT DISTINCT "SubsiteDomain"."ClassName", "SubsiteDomain"."LastEdited", "SubsiteDomain"."Created", "SubsiteDomain"."Domain", "SubsiteDomain"."Protocol", "SubsiteDomain"."IsPrimary", "SubsiteDomain"."SubsiteID", "SubsiteDomain"."ID",
CASE WHEN "SubsiteDomain"."ClassName" IS NOT NULL THEN "SubsiteDomain"."ClassName"
ELSE 'SilverStripe\\Subsites\\Model\\SubsiteDomain' END AS "RecordClassName"
FROM "SubsiteDomain"
WHERE ("SubsiteDomain"."SubsiteID" = ?)
ORDER BY "SubsiteDomain"."IsPrimary" DESC
LIMIT 1
0.0025s
0047: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."AlgoliaIndexed", "SiteTree_Live"."AlgoliaError", "SiteTree_Live"."AlgoliaUUID", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0041s
0048: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ProvideComments", "SiteTree_Live"."ModerationRequired", "SiteTree_Live"."CommentsRequireLogin", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."AlgoliaIndexed", "SiteTree_Live"."AlgoliaError", "SiteTree_Live"."AlgoliaUUID", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0029s
0049: SELECT DISTINCT "Subsite"."ClassName", "Subsite"."LastEdited", "Subsite"."Created", "Subsite"."Title", "Subsite"."RedirectURL", "Subsite"."DefaultSite", "Subsite"."Theme", "Subsite"."Language", "Subsite"."IsPublic", "Subsite"."PageTypeBlacklist", "Subsite"."ID",
CASE WHEN "Subsite"."ClassName" IS NOT NULL THEN "Subsite"."ClassName"
ELSE 'SilverStripe\\Subsites\\Model\\Subsite' END AS "RecordClassName"
FROM "Subsite"
WHERE ("Subsite"."ID" = ?)
ORDER BY "Subsite"."Title" ASC
LIMIT 1
0.0059s
0050: SELECT DISTINCT "SubsiteDomain"."ClassName", "SubsiteDomain"."LastEdited", "SubsiteDomain"."Created", "SubsiteDomain"."Domain", "SubsiteDomain"."Protocol", "SubsiteDomain"."IsPrimary", "SubsiteDomain"."SubsiteID", "SubsiteDomain"."ID",
CASE WHEN "SubsiteDomain"."ClassName" IS NOT NULL THEN "SubsiteDomain"."ClassName"
ELSE 'SilverStripe\\Subsites\\Model\\SubsiteDomain' END AS "RecordClassName"
FROM "SubsiteDomain"
WHERE ("SubsiteDomain"."SubsiteID" = ?)
ORDER BY "SubsiteDomain"."IsPrimary" DESC
LIMIT 1
0.0024s
Survey Shows STRmix™ Used in More Than 120,000 Cases Worldwide | STRmix™
Cookies
In order to give you the best experience we use cookies to enable you to navigate our website and to analyse traffic and behaviour to improve our website. We use third party analytics to understand more about your use of our site (more information about this is available in our STRmix™ Cookie Policy available for review under the ‘Manage cookie settings’ button).
You consent to our cookies if you continue to use this website. – Accept all cookies OR Manage cookie settings
Survey Shows STRmix™ Used in More Than 120,000 Cases Worldwide
STRmix™ – sophisticated forensic software for resolving mixed DNA profiles previously thought to be too complex to interpret – has now been used in over 120,000 cases worldwide since 2012, according to a new survey.
The survey, conducted by New Zealand’s Institute of Environmental Science and Research (ESR), indicates that over 3,600 of the cases have been presented in court. In addition, STRmix™ evidence was presented in over 40 successful admissibility hearings.
The survey also shows that slightly more than half of the cases using STRmix™ (nearly 53%) were reported in North America. Of the remaining cases, nearly 90% occurred in Australia and New Zealand.
“That caseload distribution makes perfect sense, given those countries where STRmix™ is predominantly used,” says Jo-Anne Bright, PhD, Senior Science Leader at the New Zealand Institute of Environmental Science and Research (ESR), and one of the developers of STRmix™.
According to Dr. Bright, 46 agencies in the U.S. now use STRmix™, including the FBI, ATF, numerous state agencies, and even private companies such as Bode Cellmark Forensics. STRmix™ is also being used in all nine state and territory labs in Australia and New Zealand, as well as 12 forensic labs in England, Scotland, Ireland, Finland, Dubai, Denmark, and Canada.
John Buckleton, DSc, FRSNZ, Forensic Scientist at ESR, and one of the developers of STRmix™, attributes the widespread use of STRmix™ to the way in which “it has improved the usability of DNA. As a result, a growing number of forensic labs around the world are turning to STRmix™ to produce usable DNA evidence in a wide range of criminal cases.”
Dr. Buckleton notes that agencies using STRmix™ are reporting an increase of interpretable DNA in gun cases from about 40% to more than 70%. STRmix™ is also delivering a significantly higher rate of interpretable results in sexual assault cases, producing a strong return on investment while enabling staff to clear Sexual Assault Kit backlogs.
Looking to the future, the survey shows that over half of responding forensic labs would be interested in using STRmix™ in the cloud to interpret higher order mixtures for casework.
STRmix™ is expected to introduce a new version of its software later this year. It recently launched DBLR™, an application for rapidly calculating likelihood ratios, which are used to assess the strength of DNA evidence and how likely it is that DNA found at a crime scene belongs to specific individuals. Used in conjunction with STRmix™, DBLR™ can calculate millions of likelihood ratios in seconds.