0002: SHOW DATABASES LIKE 'rockline\_iatric'
0.001s
0003: SHOW FULL TABLES WHERE Table_Type != 'VIEW'
0.0041s
0004: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."ShareTokenSalt", "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"."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" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0013s
0005: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."ShareTokenSalt", "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"."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" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0011s
0006: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."ShareTokenSalt", "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"."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.001s
0007: SELECT CASE WHEN EXISTS(SELECT *
FROM "SlideImage_Live"
WHERE ("SlideImage_Live"."PageID" = ?)) THEN 1 ELSE 0 END
0.001s
0008: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."Animation", "Page_Live"."Loop", "Page_Live"."Animate", "Page_Live"."ThumbnailNav", "Page_Live"."SliderControlNav", "Page_Live"."SliderDirectionNav", "Page_Live"."CarouselControlNav", "Page_Live"."CarouselDirectionNav", "Page_Live"."CarouselThumbnailCt", "Page_Live"."FlexSliderSpeed", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'Iatric\\Pages\\SearchPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'TractorCow\\Sitemap2\\SitemapPage', 'Dynamic\\Base\\Page\\BlockPage', 'Dynamic\\Base\\Page\\CampaignLandingPage', 'Dynamic\\Base\\Page\\HomePage', 'Dynamic\\Base\\Page\\SearchPage', 'SilverStripe\\Blog\\Model\\Blog', 'SilverStripe\\Blog\\Model\\BlogPost', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'Iatric\\Pages\\ContactPage') THEN "Page_Live"."ElementalAreaID" WHEN "SiteTree_Live"."ClassName" IN ('Dynamic\\Base\\Page\\BlockPage') THEN "BlockPage_Live"."ElementalAreaID" WHEN "SiteTree_Live"."ClassName" IN ('Dynamic\\Base\\Page\\CampaignLandingPage') THEN "CampaignLandingPage_Live"."ElementalAreaID" WHEN "SiteTree_Live"."ClassName" IN ('Dynamic\\Base\\Page\\HomePage') THEN "HomePage_Live"."ElementalAreaID" WHEN "SiteTree_Live"."ClassName" IN ('SilverStripe\\Blog\\Model\\BlogPost') THEN "BlogPost_Live"."ElementalAreaID" ELSE NULL END AS "ElementalAreaID", "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 "BlockPage_Live" ON "BlockPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "CampaignLandingPage_Live" ON "CampaignLandingPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "HomePage_Live" ON "HomePage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "BlogPost_Live" ON "BlogPost_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0014s
0009: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", "SiteConfig"."ReviewContent", "SiteConfig"."TitleLogo", "SiteConfig"."UseGA", "SiteConfig"."GACode", "SiteConfig"."UseGTM", "SiteConfig"."GTMHeadCode", "SiteConfig"."GTMBodyCode", "SiteConfig"."UseHubSpot", "SiteConfig"."HubSpotAccountID", "SiteConfig"."CompanyName", "SiteConfig"."Title", "SiteConfig"."Tagline", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."LogoID", "SiteConfig"."LogoRetinaID", "SiteConfig"."ID",
CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName"
ELSE 'SilverStripe\\SiteConfig\\SiteConfig' END AS "RecordClassName"
FROM "SiteConfig"
LIMIT 1
0.0008s
0010: SELECT DISTINCT "EditableFormField_Live"."ClassName", "EditableFormField_Live"."LastEdited", "EditableFormField_Live"."Created", "EditableFormField_Live"."Version", "EditableFormField_Live"."Name", "EditableFormField_Live"."Title", "EditableFormField_Live"."Default", "EditableFormField_Live"."Sort", "EditableFormField_Live"."Required", "EditableFormField_Live"."CustomErrorMessage", "EditableFormField_Live"."ExtraClass", "EditableFormField_Live"."RightTitle", "EditableFormField_Live"."ShowOnLoad", "EditableFormField_Live"."ShowInSummary", "EditableFormField_Live"."Placeholder", "EditableFormField_Live"."DisplayRulesConjunction", "EditableFormField_Live"."ParentID", "EditableFormField_Live"."ParentClass", "EditableFormField_Live"."ID",
CASE WHEN "EditableFormField_Live"."ClassName" IS NOT NULL THEN "EditableFormField_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableFormField' END AS "RecordClassName"
FROM "EditableFormField_Live"
WHERE ("ParentClass" IN ('SilverStripe\\UserForms\\Model\\UserDefinedForm', 'Iatric\\Pages\\ContactPage'))
AND ("EditableFormField_Live"."ParentID" = ?)
ORDER BY "EditableFormField_Live"."Sort" ASC
0.0013s
0011: SELECT DISTINCT "EditableFormField_Live"."ClassName", "EditableFormField_Live"."LastEdited", "EditableFormField_Live"."Created", "EditableTextField_Live"."MinLength", "EditableTextField_Live"."MaxLength", "EditableTextField_Live"."Rows", "EditableTextField_Live"."Autocomplete", "EditableFormField_Live"."ID",
CASE WHEN "EditableFormField_Live"."ClassName" IS NOT NULL THEN "EditableFormField_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableFormField' END AS "RecordClassName", "EditableFormField_Live"."Sort"
FROM "EditableFormField_Live" LEFT JOIN "EditableTextField_Live" ON "EditableTextField_Live"."ID" = "EditableFormField_Live"."ID"
WHERE ("EditableFormField_Live"."ID" = ?)
AND ("EditableFormField_Live"."ClassName" IN (?))
ORDER BY "EditableFormField_Live"."Sort" ASC
LIMIT 1
0.0013s
0012: SELECT DISTINCT "EditableFormField_Live"."ClassName", "EditableFormField_Live"."LastEdited", "EditableFormField_Live"."Created", "EditableTextField_Live"."MinLength", "EditableTextField_Live"."MaxLength", "EditableTextField_Live"."Rows", "EditableTextField_Live"."Autocomplete", "EditableFormField_Live"."ID",
CASE WHEN "EditableFormField_Live"."ClassName" IS NOT NULL THEN "EditableFormField_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableFormField' END AS "RecordClassName", "EditableFormField_Live"."Sort"
FROM "EditableFormField_Live" LEFT JOIN "EditableTextField_Live" ON "EditableTextField_Live"."ID" = "EditableFormField_Live"."ID"
WHERE ("EditableFormField_Live"."ID" = ?)
AND ("EditableFormField_Live"."ClassName" IN (?))
ORDER BY "EditableFormField_Live"."Sort" ASC
LIMIT 1
0.0012s
0013: SELECT DISTINCT "EditableFormField_Live"."ClassName", "EditableFormField_Live"."LastEdited", "EditableFormField_Live"."Created", "EditableTextField_Live"."MinLength", "EditableTextField_Live"."MaxLength", "EditableTextField_Live"."Rows", "EditableTextField_Live"."Autocomplete", "EditableFormField_Live"."ID",
CASE WHEN "EditableFormField_Live"."ClassName" IS NOT NULL THEN "EditableFormField_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableFormField' END AS "RecordClassName", "EditableFormField_Live"."Sort"
FROM "EditableFormField_Live" LEFT JOIN "EditableTextField_Live" ON "EditableTextField_Live"."ID" = "EditableFormField_Live"."ID"
WHERE ("EditableFormField_Live"."ID" = ?)
AND ("EditableFormField_Live"."ClassName" IN (?))
ORDER BY "EditableFormField_Live"."Sort" ASC
LIMIT 1
0.0011s
0014: SELECT DISTINCT "EditableFormField_Live"."ClassName", "EditableFormField_Live"."LastEdited", "EditableFormField_Live"."Created", "EditableTextField_Live"."MinLength", "EditableTextField_Live"."MaxLength", "EditableTextField_Live"."Rows", "EditableTextField_Live"."Autocomplete", "EditableFormField_Live"."ID",
CASE WHEN "EditableFormField_Live"."ClassName" IS NOT NULL THEN "EditableFormField_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableFormField' END AS "RecordClassName", "EditableFormField_Live"."Sort"
FROM "EditableFormField_Live" LEFT JOIN "EditableTextField_Live" ON "EditableTextField_Live"."ID" = "EditableFormField_Live"."ID"
WHERE ("EditableFormField_Live"."ID" = ?)
AND ("EditableFormField_Live"."ClassName" IN (?))
ORDER BY "EditableFormField_Live"."Sort" ASC
LIMIT 1
0.0012s
0015: SELECT DISTINCT "EditableOption_Live"."ClassName", "EditableOption_Live"."LastEdited", "EditableOption_Live"."Created", "EditableOption_Live"."Version", "EditableOption_Live"."Name", "EditableOption_Live"."Title", "EditableOption_Live"."Default", "EditableOption_Live"."Sort", "EditableOption_Live"."Value", "EditableOption_Live"."ParentID", "EditableOption_Live"."ID",
CASE WHEN "EditableOption_Live"."ClassName" IS NOT NULL THEN "EditableOption_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableFormField\\EditableOption' END AS "RecordClassName"
FROM "EditableOption_Live"
WHERE ("EditableOption_Live"."ParentID" = ?)
ORDER BY "EditableOption_Live"."Sort" ASC
0.0012s
0016: SELECT DISTINCT "EditableFormField_Live"."ClassName", "EditableFormField_Live"."LastEdited", "EditableFormField_Live"."Created", "EditableDropdown_Live"."UseEmptyString", "EditableDropdown_Live"."EmptyString", "EditableFormField_Live"."ID",
CASE WHEN "EditableFormField_Live"."ClassName" IS NOT NULL THEN "EditableFormField_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableFormField' END AS "RecordClassName", "EditableFormField_Live"."Sort"
FROM "EditableFormField_Live" LEFT JOIN "EditableDropdown_Live" ON "EditableDropdown_Live"."ID" = "EditableFormField_Live"."ID"
WHERE ("EditableFormField_Live"."ID" = ?)
AND ("EditableFormField_Live"."ClassName" IN (?))
ORDER BY "EditableFormField_Live"."Sort" ASC
LIMIT 1
0.0009s
0017: SELECT DISTINCT "EditableOption_Live"."ClassName", "EditableOption_Live"."LastEdited", "EditableOption_Live"."Created", "EditableOption_Live"."Version", "EditableOption_Live"."Name", "EditableOption_Live"."Title", "EditableOption_Live"."Default", "EditableOption_Live"."Sort", "EditableOption_Live"."Value", "EditableOption_Live"."ParentID", "EditableOption_Live"."ID",
CASE WHEN "EditableOption_Live"."ClassName" IS NOT NULL THEN "EditableOption_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableFormField\\EditableOption' END AS "RecordClassName"
FROM "EditableOption_Live"
WHERE ("EditableOption_Live"."ParentID" = ?)
AND ("EditableOption_Live"."Default" = ?)
ORDER BY "EditableOption_Live"."Sort" ASC
LIMIT 1
0.0012s
0018: SELECT DISTINCT "EditableOption_Live"."ClassName", "EditableOption_Live"."LastEdited", "EditableOption_Live"."Created", "EditableOption_Live"."Version", "EditableOption_Live"."Name", "EditableOption_Live"."Title", "EditableOption_Live"."Default", "EditableOption_Live"."Sort", "EditableOption_Live"."Value", "EditableOption_Live"."ParentID", "EditableOption_Live"."ID",
CASE WHEN "EditableOption_Live"."ClassName" IS NOT NULL THEN "EditableOption_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableFormField\\EditableOption' END AS "RecordClassName"
FROM "EditableOption_Live"
WHERE ("EditableOption_Live"."ParentID" = ?)
ORDER BY "EditableOption_Live"."Sort" ASC
0.0009s
0019: SELECT DISTINCT "EditableOption_Live"."ClassName", "EditableOption_Live"."LastEdited", "EditableOption_Live"."Created", "EditableOption_Live"."Version", "EditableOption_Live"."Name", "EditableOption_Live"."Title", "EditableOption_Live"."Default", "EditableOption_Live"."Sort", "EditableOption_Live"."Value", "EditableOption_Live"."ParentID", "EditableOption_Live"."ID",
CASE WHEN "EditableOption_Live"."ClassName" IS NOT NULL THEN "EditableOption_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableFormField\\EditableOption' END AS "RecordClassName"
FROM "EditableOption_Live"
WHERE ("EditableOption_Live"."ParentID" = ?)
AND ("EditableOption_Live"."Default" = ?)
ORDER BY "EditableOption_Live"."Sort" ASC
LIMIT 1
0.0012s
0020: SELECT DISTINCT "EditableFormField_Live"."ClassName", "EditableFormField_Live"."LastEdited", "EditableFormField_Live"."Created", "EditableTextField_Live"."MinLength", "EditableTextField_Live"."MaxLength", "EditableTextField_Live"."Rows", "EditableTextField_Live"."Autocomplete", "EditableFormField_Live"."ID",
CASE WHEN "EditableFormField_Live"."ClassName" IS NOT NULL THEN "EditableFormField_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableFormField' END AS "RecordClassName", "EditableFormField_Live"."Sort"
FROM "EditableFormField_Live" LEFT JOIN "EditableTextField_Live" ON "EditableTextField_Live"."ID" = "EditableFormField_Live"."ID"
WHERE ("EditableFormField_Live"."ID" = ?)
AND ("EditableFormField_Live"."ClassName" IN (?))
ORDER BY "EditableFormField_Live"."Sort" ASC
LIMIT 1
0.001s
0021: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "UserDefinedForm_Live"."SubmitButtonText", "UserDefinedForm_Live"."ClearButtonText", "UserDefinedForm_Live"."OnCompleteMessage", "UserDefinedForm_Live"."ShowClearButton", "UserDefinedForm_Live"."DisableSaveSubmissions", "UserDefinedForm_Live"."EnableLiveValidation", "UserDefinedForm_Live"."DisplayErrorMessagesAtTop", "UserDefinedForm_Live"."DisableAuthenicatedFinishAction", "UserDefinedForm_Live"."DisableCsrfSecurityToken", "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 "UserDefinedForm_Live" ON "UserDefinedForm_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.001s
0022: SELECT "EditableFormField_Live"."Name", "EditableFormField_Live"."Sort" AS "_SortColumn0"
FROM "EditableFormField_Live"
WHERE ("ParentClass" IN ('SilverStripe\\UserForms\\Model\\UserDefinedForm', 'Iatric\\Pages\\ContactPage'))
AND ("EditableFormField_Live"."ParentID" = ?)
AND ("EditableFormField_Live"."Required" = ?)
ORDER BY "_SortColumn0" ASC
0.0014s
0023: SELECT DISTINCT "UserDefinedForm_EmailRecipient"."ClassName", "UserDefinedForm_EmailRecipient"."LastEdited", "UserDefinedForm_EmailRecipient"."Created", "UserDefinedForm_EmailRecipient"."EmailAddress", "UserDefinedForm_EmailRecipient"."EmailSubject", "UserDefinedForm_EmailRecipient"."EmailFrom", "UserDefinedForm_EmailRecipient"."EmailReplyTo", "UserDefinedForm_EmailRecipient"."EmailBody", "UserDefinedForm_EmailRecipient"."EmailBodyHtml", "UserDefinedForm_EmailRecipient"."EmailTemplate", "UserDefinedForm_EmailRecipient"."SendPlain", "UserDefinedForm_EmailRecipient"."HideFormData", "UserDefinedForm_EmailRecipient"."HideInvisibleFields", "UserDefinedForm_EmailRecipient"."CustomRulesCondition", "UserDefinedForm_EmailRecipient"."SendEmailFromFieldID", "UserDefinedForm_EmailRecipient"."SendEmailToFieldID", "UserDefinedForm_EmailRecipient"."SendEmailSubjectFieldID", "UserDefinedForm_EmailRecipient"."FormID", "UserDefinedForm_EmailRecipient"."FormClass", "UserDefinedForm_EmailRecipient"."ID",
CASE WHEN "UserDefinedForm_EmailRecipient"."ClassName" IS NOT NULL THEN "UserDefinedForm_EmailRecipient"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\Recipient\\EmailRecipient' END AS "RecordClassName"
FROM "UserDefinedForm_EmailRecipient"
WHERE ("FormClass" IN ('SilverStripe\\UserForms\\Model\\UserDefinedForm', 'Iatric\\Pages\\ContactPage'))
AND ("UserDefinedForm_EmailRecipient"."FormID" = ?)
0.0013s
0024: SELECT DISTINCT "EditableFormField_Live"."ClassName", "EditableFormField_Live"."LastEdited", "EditableFormField_Live"."Created", "EditableFormField_Live"."Version", "EditableFormField_Live"."Name", "EditableFormField_Live"."Title", "EditableFormField_Live"."Default", "EditableFormField_Live"."Sort", "EditableFormField_Live"."Required", "EditableFormField_Live"."CustomErrorMessage", "EditableFormField_Live"."ExtraClass", "EditableFormField_Live"."RightTitle", "EditableFormField_Live"."ShowOnLoad", "EditableFormField_Live"."ShowInSummary", "EditableFormField_Live"."Placeholder", "EditableFormField_Live"."DisplayRulesConjunction", "EditableFormField_Live"."ParentID", "EditableFormField_Live"."ParentClass", "EditableFormField_Live"."ID",
CASE WHEN "EditableFormField_Live"."ClassName" IS NOT NULL THEN "EditableFormField_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableFormField' END AS "RecordClassName"
FROM "EditableFormField_Live"
WHERE ("EditableFormField_Live"."ID" = ?)
ORDER BY "EditableFormField_Live"."Sort" ASC
LIMIT 1
0.0007s
0025: SELECT DISTINCT "EditableFormField_Live"."ClassName", "EditableFormField_Live"."LastEdited", "EditableFormField_Live"."Created", "EditableFormField_Live"."Version", "EditableFormField_Live"."Name", "EditableFormField_Live"."Title", "EditableFormField_Live"."Default", "EditableFormField_Live"."Sort", "EditableFormField_Live"."Required", "EditableFormField_Live"."CustomErrorMessage", "EditableFormField_Live"."ExtraClass", "EditableFormField_Live"."RightTitle", "EditableFormField_Live"."ShowOnLoad", "EditableFormField_Live"."ShowInSummary", "EditableFormField_Live"."Placeholder", "EditableFormField_Live"."DisplayRulesConjunction", "EditableFormField_Live"."ParentID", "EditableFormField_Live"."ParentClass", "EditableFormField_Live"."ID",
CASE WHEN "EditableFormField_Live"."ClassName" IS NOT NULL THEN "EditableFormField_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableFormField' END AS "RecordClassName"
FROM "EditableFormField_Live"
WHERE ("EditableFormField_Live"."ID" = ?)
ORDER BY "EditableFormField_Live"."Sort" ASC
LIMIT 1
0.0011s
0026: SELECT DISTINCT "EditableFormField_Live"."ClassName", "EditableFormField_Live"."LastEdited", "EditableFormField_Live"."Created", "EditableFormField_Live"."Version", "EditableFormField_Live"."Name", "EditableFormField_Live"."Title", "EditableFormField_Live"."Default", "EditableFormField_Live"."Sort", "EditableFormField_Live"."Required", "EditableFormField_Live"."CustomErrorMessage", "EditableFormField_Live"."ExtraClass", "EditableFormField_Live"."RightTitle", "EditableFormField_Live"."ShowOnLoad", "EditableFormField_Live"."ShowInSummary", "EditableFormField_Live"."Placeholder", "EditableFormField_Live"."DisplayRulesConjunction", "EditableFormField_Live"."ParentID", "EditableFormField_Live"."ParentClass", "EditableFormField_Live"."ID",
CASE WHEN "EditableFormField_Live"."ClassName" IS NOT NULL THEN "EditableFormField_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableFormField' END AS "RecordClassName"
FROM "EditableFormField_Live"
WHERE ("EditableFormField_Live"."ID" = ?)
ORDER BY "EditableFormField_Live"."Sort" ASC
LIMIT 1
0.0007s
0027: SELECT DISTINCT "EditableFormField_Live"."ClassName", "EditableFormField_Live"."LastEdited", "EditableFormField_Live"."Created", "EditableFormField_Live"."Version", "EditableFormField_Live"."Name", "EditableFormField_Live"."Title", "EditableFormField_Live"."Default", "EditableFormField_Live"."Sort", "EditableFormField_Live"."Required", "EditableFormField_Live"."CustomErrorMessage", "EditableFormField_Live"."ExtraClass", "EditableFormField_Live"."RightTitle", "EditableFormField_Live"."ShowOnLoad", "EditableFormField_Live"."ShowInSummary", "EditableFormField_Live"."Placeholder", "EditableFormField_Live"."DisplayRulesConjunction", "EditableFormField_Live"."ParentID", "EditableFormField_Live"."ParentClass", "EditableFormField_Live"."ID",
CASE WHEN "EditableFormField_Live"."ClassName" IS NOT NULL THEN "EditableFormField_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableFormField' END AS "RecordClassName"
FROM "EditableFormField_Live"
WHERE ("ParentClass" IN ('SilverStripe\\UserForms\\Model\\UserDefinedForm', 'Iatric\\Pages\\ContactPage'))
AND ("EditableFormField_Live"."ParentID" = ?)
ORDER BY "EditableFormField_Live"."Sort" ASC
0.0011s
0028: SELECT DISTINCT "EditableCustomRule_Live"."ClassName", "EditableCustomRule_Live"."LastEdited", "EditableCustomRule_Live"."Created", "EditableCustomRule_Live"."Version", "EditableCustomRule_Live"."Display", "EditableCustomRule_Live"."ConditionOption", "EditableCustomRule_Live"."FieldValue", "EditableCustomRule_Live"."ParentID", "EditableCustomRule_Live"."ConditionFieldID", "EditableCustomRule_Live"."ID",
CASE WHEN "EditableCustomRule_Live"."ClassName" IS NOT NULL THEN "EditableCustomRule_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableCustomRule' END AS "RecordClassName"
FROM "EditableCustomRule_Live"
WHERE ("EditableCustomRule_Live"."ParentID" = ?)
0.001s
0029: SELECT DISTINCT "EditableCustomRule_Live"."ClassName", "EditableCustomRule_Live"."LastEdited", "EditableCustomRule_Live"."Created", "EditableCustomRule_Live"."Version", "EditableCustomRule_Live"."Display", "EditableCustomRule_Live"."ConditionOption", "EditableCustomRule_Live"."FieldValue", "EditableCustomRule_Live"."ParentID", "EditableCustomRule_Live"."ConditionFieldID", "EditableCustomRule_Live"."ID",
CASE WHEN "EditableCustomRule_Live"."ClassName" IS NOT NULL THEN "EditableCustomRule_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableCustomRule' END AS "RecordClassName"
FROM "EditableCustomRule_Live"
WHERE ("EditableCustomRule_Live"."ParentID" = ?)
0.0011s
0030: SELECT DISTINCT "EditableCustomRule_Live"."ClassName", "EditableCustomRule_Live"."LastEdited", "EditableCustomRule_Live"."Created", "EditableCustomRule_Live"."Version", "EditableCustomRule_Live"."Display", "EditableCustomRule_Live"."ConditionOption", "EditableCustomRule_Live"."FieldValue", "EditableCustomRule_Live"."ParentID", "EditableCustomRule_Live"."ConditionFieldID", "EditableCustomRule_Live"."ID",
CASE WHEN "EditableCustomRule_Live"."ClassName" IS NOT NULL THEN "EditableCustomRule_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableCustomRule' END AS "RecordClassName"
FROM "EditableCustomRule_Live"
WHERE ("EditableCustomRule_Live"."ParentID" = ?)
0.001s
0031: SELECT DISTINCT "EditableCustomRule_Live"."ClassName", "EditableCustomRule_Live"."LastEdited", "EditableCustomRule_Live"."Created", "EditableCustomRule_Live"."Version", "EditableCustomRule_Live"."Display", "EditableCustomRule_Live"."ConditionOption", "EditableCustomRule_Live"."FieldValue", "EditableCustomRule_Live"."ParentID", "EditableCustomRule_Live"."ConditionFieldID", "EditableCustomRule_Live"."ID",
CASE WHEN "EditableCustomRule_Live"."ClassName" IS NOT NULL THEN "EditableCustomRule_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableCustomRule' END AS "RecordClassName"
FROM "EditableCustomRule_Live"
WHERE ("EditableCustomRule_Live"."ParentID" = ?)
0.001s
0032: SELECT DISTINCT "EditableCustomRule_Live"."ClassName", "EditableCustomRule_Live"."LastEdited", "EditableCustomRule_Live"."Created", "EditableCustomRule_Live"."Version", "EditableCustomRule_Live"."Display", "EditableCustomRule_Live"."ConditionOption", "EditableCustomRule_Live"."FieldValue", "EditableCustomRule_Live"."ParentID", "EditableCustomRule_Live"."ConditionFieldID", "EditableCustomRule_Live"."ID",
CASE WHEN "EditableCustomRule_Live"."ClassName" IS NOT NULL THEN "EditableCustomRule_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableCustomRule' END AS "RecordClassName"
FROM "EditableCustomRule_Live"
WHERE ("EditableCustomRule_Live"."ParentID" = ?)
0.0009s
0033: SELECT DISTINCT "EditableCustomRule_Live"."ClassName", "EditableCustomRule_Live"."LastEdited", "EditableCustomRule_Live"."Created", "EditableCustomRule_Live"."Version", "EditableCustomRule_Live"."Display", "EditableCustomRule_Live"."ConditionOption", "EditableCustomRule_Live"."FieldValue", "EditableCustomRule_Live"."ParentID", "EditableCustomRule_Live"."ConditionFieldID", "EditableCustomRule_Live"."ID",
CASE WHEN "EditableCustomRule_Live"."ClassName" IS NOT NULL THEN "EditableCustomRule_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableCustomRule' END AS "RecordClassName"
FROM "EditableCustomRule_Live"
WHERE ("EditableCustomRule_Live"."ParentID" = ?)
0.0007s
0034: SELECT DISTINCT "EditableCustomRule_Live"."ClassName", "EditableCustomRule_Live"."LastEdited", "EditableCustomRule_Live"."Created", "EditableCustomRule_Live"."Version", "EditableCustomRule_Live"."Display", "EditableCustomRule_Live"."ConditionOption", "EditableCustomRule_Live"."FieldValue", "EditableCustomRule_Live"."ParentID", "EditableCustomRule_Live"."ConditionFieldID", "EditableCustomRule_Live"."ID",
CASE WHEN "EditableCustomRule_Live"."ClassName" IS NOT NULL THEN "EditableCustomRule_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableCustomRule' END AS "RecordClassName"
FROM "EditableCustomRule_Live"
WHERE ("EditableCustomRule_Live"."ParentID" = ?)
0.001s
0035: SELECT DISTINCT "EditableCustomRule_Live"."ClassName", "EditableCustomRule_Live"."LastEdited", "EditableCustomRule_Live"."Created", "EditableCustomRule_Live"."Version", "EditableCustomRule_Live"."Display", "EditableCustomRule_Live"."ConditionOption", "EditableCustomRule_Live"."FieldValue", "EditableCustomRule_Live"."ParentID", "EditableCustomRule_Live"."ConditionFieldID", "EditableCustomRule_Live"."ID",
CASE WHEN "EditableCustomRule_Live"."ClassName" IS NOT NULL THEN "EditableCustomRule_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableCustomRule' END AS "RecordClassName"
FROM "EditableCustomRule_Live"
WHERE ("EditableCustomRule_Live"."ParentID" = ?)
0.0007s
0036: SELECT DISTINCT "EditableCustomRule_Live"."ClassName", "EditableCustomRule_Live"."LastEdited", "EditableCustomRule_Live"."Created", "EditableCustomRule_Live"."Version", "EditableCustomRule_Live"."Display", "EditableCustomRule_Live"."ConditionOption", "EditableCustomRule_Live"."FieldValue", "EditableCustomRule_Live"."ParentID", "EditableCustomRule_Live"."ConditionFieldID", "EditableCustomRule_Live"."ID",
CASE WHEN "EditableCustomRule_Live"."ClassName" IS NOT NULL THEN "EditableCustomRule_Live"."ClassName"
ELSE 'SilverStripe\\UserForms\\Model\\EditableCustomRule' END AS "RecordClassName"
FROM "EditableCustomRule_Live"
WHERE ("EditableCustomRule_Live"."ParentID" = ?)
0.0009s
0037: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."ShareTokenSalt", "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"."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"."ShowInMenus" = ?)
AND ("SiteTree_Live"."ParentID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
0.0016s
0038: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."ShareTokenSalt", "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"."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.0009s
0039: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."ShareTokenSalt", "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"."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" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
0.0012s
0040: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."ShareTokenSalt", "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"."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" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
0.001s
0041: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."ShareTokenSalt", "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"."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" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
0.0012s
0042: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."ShareTokenSalt", "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"."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.0009s
0043: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."ShareTokenSalt", "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"."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.0008s
0044: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."ShareTokenSalt", "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"."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.0013s
0045: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."ShareTokenSalt", "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"."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" INNER JOIN "BlogPost_Live" ON "BlogPost_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ParentID" = ?)
AND (("SiteTree_Live"."ID" != ? OR "SiteTree_Live"."ID" IS NULL))
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND ("PublishDate" < '2026-06-28 07:35:32')
ORDER BY "SiteTree_Live"."Sort" ASC
0.0034s
0046: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."ShareTokenSalt", "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"."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" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
0.0015s
0047: SELECT CASE WHEN EXISTS(SELECT *
FROM "SiteTree_Live" INNER JOIN "SiteConfig_UtilityLinks" ON "SiteConfig_UtilityLinks"."SiteTreeID" = "SiteTree_Live"."ID"
WHERE ("SiteConfig_UtilityLinks"."SiteConfigID" = ?)) THEN 1 ELSE 0 END
0.001s
0048: SELECT DISTINCT "SiteConfig_UtilityLinks"."SortOrder", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."ShareTokenSalt", "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"."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" INNER JOIN "SiteConfig_UtilityLinks" ON "SiteConfig_UtilityLinks"."SiteTreeID" = "SiteTree_Live"."ID"
WHERE ("SiteConfig_UtilityLinks"."SiteConfigID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
0.0016s
0049: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."ShareTokenSalt", "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"."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.0013s
0050: SELECT CASE WHEN EXISTS(SELECT *
FROM "SlideImage_Live"
WHERE ("SlideImage_Live"."PageID" = ?)) THEN 1 ELSE 0 END
0.0007s
0051: SELECT CASE WHEN EXISTS(SELECT *
FROM "NavigationColumn"
WHERE ("NavigationColumn"."ConfigID" = ?)) THEN 1 ELSE 0 END
0.0008s
0052: SELECT DISTINCT "NavigationColumn"."ClassName", "NavigationColumn"."LastEdited", "NavigationColumn"."Created", "NavigationColumn"."Title", "NavigationColumn"."SortOrder", "NavigationColumn"."ConfigID", "NavigationColumn"."ID",
CASE WHEN "NavigationColumn"."ClassName" IS NOT NULL THEN "NavigationColumn"."ClassName"
ELSE 'Dynamic\\Base\\Model\\NavigationColumn' END AS "RecordClassName"
FROM "NavigationColumn"
WHERE ("NavigationColumn"."ConfigID" = ?)
LIMIT 3
0.0006s
0053: SELECT DISTINCT "NavigationGroup"."ClassName", "NavigationGroup"."LastEdited", "NavigationGroup"."Created", "NavigationGroup"."Title", "NavigationGroup"."SortOrder", "NavigationGroup"."NavigationColumnID", "NavigationGroup"."ID",
CASE WHEN "NavigationGroup"."ClassName" IS NOT NULL THEN "NavigationGroup"."ClassName"
ELSE 'Dynamic\\Base\\Model\\NavigationGroup' END AS "RecordClassName"
FROM "NavigationGroup"
WHERE ("NavigationGroup"."NavigationColumnID" = ?)
0.0006s
0054: SELECT DISTINCT "NavigationGroup_NavigationLinks"."SortOrder", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."ShareTokenSalt", "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"."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" INNER JOIN "NavigationGroup_NavigationLinks" ON "NavigationGroup_NavigationLinks"."SiteTreeID" = "SiteTree_Live"."ID"
WHERE ("NavigationGroup_NavigationLinks"."NavigationGroupID" = ?)
ORDER BY "SortOrder" ASC
0.001s
0055: SELECT DISTINCT "NavigationGroup"."ClassName", "NavigationGroup"."LastEdited", "NavigationGroup"."Created", "NavigationGroup"."Title", "NavigationGroup"."SortOrder", "NavigationGroup"."NavigationColumnID", "NavigationGroup"."ID",
CASE WHEN "NavigationGroup"."ClassName" IS NOT NULL THEN "NavigationGroup"."ClassName"
ELSE 'Dynamic\\Base\\Model\\NavigationGroup' END AS "RecordClassName"
FROM "NavigationGroup"
WHERE ("NavigationGroup"."NavigationColumnID" = ?)
0.0007s
0056: SELECT DISTINCT "NavigationGroup_NavigationLinks"."SortOrder", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."ShareTokenSalt", "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"."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" INNER JOIN "NavigationGroup_NavigationLinks" ON "NavigationGroup_NavigationLinks"."SiteTreeID" = "SiteTree_Live"."ID"
WHERE ("NavigationGroup_NavigationLinks"."NavigationGroupID" = ?)
ORDER BY "SortOrder" ASC
0.0012s
0057: SELECT DISTINCT "BaseCompanyAddress"."ClassName", "BaseCompanyAddress"."LastEdited", "BaseCompanyAddress"."Created", "BaseCompanyAddress"."Phone", "BaseCompanyAddress"."Phone2", "BaseCompanyAddress"."Fax", "BaseCompanyAddress"."Email", "BaseCompanyAddress"."Address", "BaseCompanyAddress"."Address2", "BaseCompanyAddress"."City", "BaseCompanyAddress"."State", "BaseCompanyAddress"."PostalCode", "BaseCompanyAddress"."Country", "BaseCompanyAddress"."LatLngOverride", "BaseCompanyAddress"."Lat", "BaseCompanyAddress"."Lng", "BaseCompanyAddress"."Title", "BaseCompanyAddress"."SortOrder", "BaseCompanyAddress"."IsPrimary", "BaseCompanyAddress"."SiteConfigID", "BaseCompanyAddress"."ID",
CASE WHEN "BaseCompanyAddress"."ClassName" IS NOT NULL THEN "BaseCompanyAddress"."ClassName"
ELSE 'Dynamic\\Base\\Model\\CompanyAddress' END AS "RecordClassName"
FROM "BaseCompanyAddress"
ORDER BY "BaseCompanyAddress"."IsPrimary" DESC
LIMIT 1
0.0009s
0058: SELECT "Version" FROM "SiteTree" WHERE "ID" = ?
0.0006s
0059: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."ShareTokenSalt", "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"."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.0009s
0060: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."ShareTokenSalt", "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"."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.0008s
0061: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."ShareTokenSalt", "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"."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.001s
0062: SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", "SiteTree"."SearchContent", "SiteTree"."Priority", "SiteTree"."HideOnSitemap", "SiteTree"."ShareTokenSalt", "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"."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.0007s
0063: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."ShareTokenSalt", "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"."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.0009s
0064: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."SearchContent", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."ShareTokenSalt", "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"."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.001s
What We Buy » IATRIC™ Manufacturing Solutions
What We Buy
"iatric's Strategic Sourcing organization is responsible for sourcing a wide range of raw material categories in the areas of substrates, packaging, and chemicals to support our operations.Feel free to review list below, fill out form submission, click "SEND" and an email will be sent to the proper sourcing group."