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.0021s
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.0021s
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.0028s
0006: SHOW FULL FIELDS IN "Member"
0.0025s
0007: SHOW COLLATION LIKE 'utf8_general_ci'
0.0021s
0008: SHOW FULL FIELDS IN "Group"
0.0017s
0009: SHOW FULL FIELDS IN "Permission"
0.0012s
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.0033s
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.0026s
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.0019s
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.0028s
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.0055s
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.0034s
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.0037s
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.0055s
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.0078s
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.0036s
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.0035s
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.0027s
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.0025s
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.0033s
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.003s
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.0027s
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.0062s
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", 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", "Page_Live"."HideInThisSection", "Page_Live"."DisableRichLinks", "Page_Live"."ElementalAreaID", "Page_Live"."AddInfoImageID", "Page_Live"."RightMenuImageID", "Page_Live"."HeroImageID", "Page_Live"."HeroImageMobileID", "DatedUpdatePage_Live"."Abstract", "DatedUpdatePage_Live"."Date", "NewsPage_Live"."ContactTitle", "NewsPage_Live"."ContactText", "NewsPage_Live"."ContactEmail", "NewsPage_Live"."ContactPhone", "NewsPage_Live"."HideContact", "NewsPage_Live"."NewsContent", "NewsPage_Live"."Author", "NewsPage_Live"."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"
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 ("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.0061s
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", "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
0031: 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
0032: 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.0052s
0033: 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.0034s
0034: 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.0032s
0035: 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.0032s
0036: SELECT "Version" FROM "SiteTree" WHERE "ID" = ?
0.0063s
0037: 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.0044s
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.0047s
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.0032s
0040: 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.0034s
0041: 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.0031s
0042: 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.0036s
0043: 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.0057s
0044: 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
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.0034s
0046: 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.0039s
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.0025s
0048: 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.0024s
0049: 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.0022s
STRmix™ v2.11 Features Enhancements to Groundbreaking Forensic Software | 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
STRmix™ v2.11 Features Enhancements to Groundbreaking Forensic Software
Improvements Make It Easier to Produce Usable, Interpretable DNA Results
The STRmix team has launched the latest version of its groundbreaking software for resolving low-level, degraded, or mixed DNA samples from multiple contributors.
STRmix™ version 2.11 features enhancements to memory use, general improvements to the models and Model maker, and the inclusion of an upper bound to the HPD likelihood ratio (LR). Its most significant change, however, is the addition of Amelogenin into the deconvolution and LR.
“These changes, coupled with other recent improvements such as v2.10’s introduction of a Visualize Weights module to help analysts investigate DNA interpretation results, make it easier for forensic labs to produce highly usable, interpretable, and legally admissible DNA results in a wide range of criminal cases, including violent crime, sexual assault, and cold cases,” says STRmix team Senior Science Leader and co-developer of STRmix™, Dr. Jo-Anne Bright.
The new features in STRmix™ v2.11 were made primarily in response to recommendations made by the forensic laboratories currently using the software, allowing them to better address on-the-job needs they regularly encounter.
Unlike previous methods of DNA analysis, which depended entirely on the application of fixed stochastic thresholds and other biological parameters to manually analyze DNA samples, STRmix™ assesses how closely a multitude of potential DNA profiles resemble or can explain an observed DNA mixture.
Relying on proven methodologies routinely used in computational biology, physics, engineering, and weather prediction, STRmix™ calculates the probability of observed DNA evidence by assuming the DNA originated from either a person of interest or an unknown donor. These two probabilities are then presented as a LR, which infers the value of the findings and the level of support for one proposition over the other.
The success of that methodology in resolving DNA profiles previously considered too complex to interpret has led to the adoption and use of STRmix™ by 106 forensic organizations around the world, including 80 local, state, and federal agencies in the U.S. Since its introduction in 2012, STRmix™ has been used to interpret DNA evidence in more than 380,000 cases worldwide.
In addition to STRmix™ v2.11, the STRmix team has developed and previously launched two related software applications:
DBLR™, an application which when used with STRmix™ allows forensic laboratories to undertake extensive kinship analysis, carry out rapid database searches, visualize the value of their DNA mixture evidence, and carry out mixture-to-mixture matches; and
FaSTR™ DNA, expert forensic software which seamlessly integrates with STRmix™ (when in use) to rapidly analyze raw DNA data generated by genetic analyzers and standard profiling kits and assigns a number of contributors (NoC) estimate.
In combination with STRmix™, these applications complete the full workflow(external link) from analysis to interpretation and database matching.
STRmix Limited recently announced that all three of its software packages will continue to be distributed in North, South, and Central America by Ohio-based NicheVision Forensics, LLC. Founded in 2007, NicheVision has had exclusive distribution rights to STRmix™ in the Americas since 2014.