0003: SHOW DATABASES LIKE 'iqstaging\_socra'
0.0007s
0004: SHOW FULL TABLES WHERE Table_Type != 'VIEW'
0.0026s
0005: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."LegacyData", "SiteTree_Live"."LegacyID", "SiteTree_Live"."ImportStatus", "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.0007s
0006: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."LegacyData", "SiteTree_Live"."LegacyID", "SiteTree_Live"."ImportStatus", "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.0007s
0007: SELECT "Page_Live"."NavigationCacheKey", "SiteTree_Live"."ID" AS "_SortColumn0"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID"
ORDER BY "_SortColumn0" ASC
0.0014s
0008: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."LegacyData", "SiteTree_Live"."LegacyID", "SiteTree_Live"."ImportStatus", "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.0006s
0009: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", "SiteConfig"."VideoGallery_YouTubeApiKey", "SiteConfig"."SiteTreeCacheEnabled", "SiteConfig"."GoogleMapsApiKey", "SiteConfig"."UseFacebook", "SiteConfig"."UseTwitter", "SiteConfig"."UseLinkedIn", "SiteConfig"."UsePinterest", "SiteConfig"."UseInstagram", "SiteConfig"."UseGoogleMyBusiness", "SiteConfig"."UseBlog", "SiteConfig"."UseFlickr", "SiteConfig"."UseYouTube", "SiteConfig"."UseVimeo", "SiteConfig"."UseYelp", "SiteConfig"."UseTumblr", "SiteConfig"."UseHouzz", "SiteConfig"."UseAngiesList", "SiteConfig"."FacebookURL", "SiteConfig"."TwitterURL", "SiteConfig"."LinkedInURL", "SiteConfig"."PinterestURL", "SiteConfig"."InstagramURL", "SiteConfig"."GoogleMyBusinessURL", "SiteConfig"."BlogURL", "SiteConfig"."FlickrURL", "SiteConfig"."YouTubeURL", "SiteConfig"."VimeoURL", "SiteConfig"."YelpURL", "SiteConfig"."TumblrURL", "SiteConfig"."HouzzURL", "SiteConfig"."AngiesListURL", "SiteConfig"."EnableGDPR", "SiteConfig"."GDPRNotice", "SiteConfig"."AdditionalHeaderCode", "SiteConfig"."AdditionalFooterCode", "SiteConfig"."GoogleTrackingUniversal", "SiteConfig"."GoogleTagManagerHeadCode", "SiteConfig"."GoogleTagManagerBodyCode", "SiteConfig"."EnabledPaymentMethods", "SiteConfig"."PageStructure", "SiteConfig"."SubmissionsReportEmailTo", "SiteConfig"."SubmissionsReportEmailFrom", "SiteConfig"."Title", "SiteConfig"."Tagline", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."EventCalendarLinkID", "SiteConfig"."MemberPortalLinkID", "SiteConfig"."ID",
CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName"
ELSE 'SilverStripe\\SiteConfig\\SiteConfig' END AS "RecordClassName"
FROM "SiteConfig"
LIMIT 1
0.0007s
0010: SELECT DISTINCT "PageBuilderSection"."ClassName", "PageBuilderSection"."LastEdited", "PageBuilderSection"."Created", "PageBuilderSection"."SortOrder", "PageBuilderSection"."BackgroundColor", "PageBuilderSection"."AdditionalCssClasses", "PageBuilderSection"."Borders", "PageBuilderSection"."PageID", "PageBuilderSection"."BackgroundImageLargeID", "PageBuilderSection"."BackgroundImageMediumID", "PageBuilderSection"."BackgroundImageSmallID", "PageBuilderSection"."ID",
CASE WHEN "PageBuilderSection"."ClassName" IS NOT NULL THEN "PageBuilderSection"."ClassName"
ELSE 'IQnection\\PageBuilder\\Section\\PageBuilderSection' END AS "RecordClassName"
FROM "PageBuilderSection"
WHERE ("PageBuilderSection"."PageID" = ?)
ORDER BY "PageBuilderSection"."SortOrder" ASC
0.0006s
0011: SELECT DISTINCT "ContentBuilderBlock"."ClassName", "ContentBuilderBlock"."LastEdited", "ContentBuilderBlock"."Created", "ContentBuilderBlock"."SortOrder", "ContentBuilderBlock"."AdditionalCssClasses", "ContentBuilderBlock"."Width", "ContentBuilderBlock"."ContentBuilderSectionID", "ContentBuilderBlock"."ID",
CASE WHEN "ContentBuilderBlock"."ClassName" IS NOT NULL THEN "ContentBuilderBlock"."ClassName"
ELSE 'IQnection\\PageBuilder\\ContentBuilder\\Block\\Block' END AS "RecordClassName"
FROM "ContentBuilderBlock"
WHERE ("ContentBuilderBlock"."ContentBuilderSectionID" = ?)
ORDER BY "ContentBuilderBlock"."SortOrder" ASC
0.0005s
0012: SELECT DISTINCT "ContentBuilderBlock"."ClassName", "ContentBuilderBlock"."LastEdited", "ContentBuilderBlock"."Created", "ContentBuilderBlock"."SortOrder", "ContentBuilderBlock"."AdditionalCssClasses", "ContentBuilderBlock"."Width", "ContentBuilderBlock"."ContentBuilderSectionID", "ContentBuilderBlock"."ID",
CASE WHEN "ContentBuilderBlock"."ClassName" IS NOT NULL THEN "ContentBuilderBlock"."ClassName"
ELSE 'IQnection\\PageBuilder\\ContentBuilder\\Block\\Block' END AS "RecordClassName"
FROM "ContentBuilderBlock"
WHERE ("ContentBuilderBlock"."ContentBuilderSectionID" = ?)
ORDER BY "ContentBuilderBlock"."SortOrder" ASC
0.0002s
0013: SELECT DISTINCT "ContentBuilderBlock"."ClassName", "ContentBuilderBlock"."LastEdited", "ContentBuilderBlock"."Created", "ContentBuilderBlock"."SortOrder", "ContentBuilderBlock"."AdditionalCssClasses", "ContentBuilderBlock"."Width", "ContentBuilderBlock"."ContentBuilderSectionID", "ContentBuilderBlock"."ID",
CASE WHEN "ContentBuilderBlock"."ClassName" IS NOT NULL THEN "ContentBuilderBlock"."ClassName"
ELSE 'IQnection\\PageBuilder\\ContentBuilder\\Block\\Block' END AS "RecordClassName"
FROM "ContentBuilderBlock"
WHERE ("ContentBuilderBlock"."ContentBuilderSectionID" = ?)
ORDER BY "ContentBuilderBlock"."SortOrder" ASC
0.0002s
0014: SELECT DISTINCT "ContentBuilderBlock"."ClassName", "ContentBuilderBlock"."LastEdited", "ContentBuilderBlock"."Created", "ContentBuilderBlock"."SortOrder", "ContentBuilderBlock"."AdditionalCssClasses", "ContentBuilderBlock"."Width", "ContentBuilderBlock"."ContentBuilderSectionID", "ContentBuilderBlock"."ID",
CASE WHEN "ContentBuilderBlock"."ClassName" IS NOT NULL THEN "ContentBuilderBlock"."ClassName"
ELSE 'IQnection\\PageBuilder\\ContentBuilder\\Block\\Block' END AS "RecordClassName"
FROM "ContentBuilderBlock"
WHERE ("ContentBuilderBlock"."ContentBuilderSectionID" = ?)
ORDER BY "ContentBuilderBlock"."SortOrder" ASC
0.0001s
0015: SELECT DISTINCT "ContentBuilderBlock"."ClassName", "ContentBuilderBlock"."LastEdited", "ContentBuilderBlock"."Created", "ContentBuilderBlock"."SortOrder", "ContentBuilderBlock"."AdditionalCssClasses", "ContentBuilderBlock"."Width", "ContentBuilderBlock"."ContentBuilderSectionID", "ContentBuilderBlock"."ID",
CASE WHEN "ContentBuilderBlock"."ClassName" IS NOT NULL THEN "ContentBuilderBlock"."ClassName"
ELSE 'IQnection\\PageBuilder\\ContentBuilder\\Block\\Block' END AS "RecordClassName"
FROM "ContentBuilderBlock"
WHERE ("ContentBuilderBlock"."ContentBuilderSectionID" = ?)
ORDER BY "ContentBuilderBlock"."SortOrder" ASC
0.0001s
0016: SELECT DISTINCT "ContentBuilderBlock"."ClassName", "ContentBuilderBlock"."LastEdited", "ContentBuilderBlock"."Created", "ContentBuilderBlock"."SortOrder", "ContentBuilderBlock"."AdditionalCssClasses", "ContentBuilderBlock"."Width", "ContentBuilderBlock"."ContentBuilderSectionID", "ContentBuilderBlock"."ID",
CASE WHEN "ContentBuilderBlock"."ClassName" IS NOT NULL THEN "ContentBuilderBlock"."ClassName"
ELSE 'IQnection\\PageBuilder\\ContentBuilder\\Block\\Block' END AS "RecordClassName"
FROM "ContentBuilderBlock"
WHERE ("ContentBuilderBlock"."ContentBuilderSectionID" = ?)
ORDER BY "ContentBuilderBlock"."SortOrder" ASC
0.0002s
0017: SELECT DISTINCT "ContentBuilderBlock"."ClassName", "ContentBuilderBlock"."LastEdited", "ContentBuilderBlock"."Created", "ContentBuilderBlock"."SortOrder", "ContentBuilderBlock"."AdditionalCssClasses", "ContentBuilderBlock"."Width", "ContentBuilderBlock"."ContentBuilderSectionID", "ContentBuilderBlock"."ID",
CASE WHEN "ContentBuilderBlock"."ClassName" IS NOT NULL THEN "ContentBuilderBlock"."ClassName"
ELSE 'IQnection\\PageBuilder\\ContentBuilder\\Block\\Block' END AS "RecordClassName"
FROM "ContentBuilderBlock"
WHERE ("ContentBuilderBlock"."ContentBuilderSectionID" = ?)
ORDER BY "ContentBuilderBlock"."SortOrder" ASC
0.0002s
0018: SELECT DISTINCT "ContentBuilderBlock"."ClassName", "ContentBuilderBlock"."LastEdited", "ContentBuilderBlock"."Created", "ContentBuilderBlock"."SortOrder", "ContentBuilderBlock"."AdditionalCssClasses", "ContentBuilderBlock"."Width", "ContentBuilderBlock"."ContentBuilderSectionID", "ContentBuilderBlock"."ID",
CASE WHEN "ContentBuilderBlock"."ClassName" IS NOT NULL THEN "ContentBuilderBlock"."ClassName"
ELSE 'IQnection\\PageBuilder\\ContentBuilder\\Block\\Block' END AS "RecordClassName"
FROM "ContentBuilderBlock"
WHERE ("ContentBuilderBlock"."ContentBuilderSectionID" = ?)
ORDER BY "ContentBuilderBlock"."SortOrder" ASC
0.0002s
0019: SELECT DISTINCT "ContentBuilderBlock"."ClassName", "ContentBuilderBlock"."LastEdited", "ContentBuilderBlock"."Created", "ContentBuilderBlock"."SortOrder", "ContentBuilderBlock"."AdditionalCssClasses", "ContentBuilderBlock"."Width", "ContentBuilderBlock"."ContentBuilderSectionID", "ContentBuilderBlock"."ID",
CASE WHEN "ContentBuilderBlock"."ClassName" IS NOT NULL THEN "ContentBuilderBlock"."ClassName"
ELSE 'IQnection\\PageBuilder\\ContentBuilder\\Block\\Block' END AS "RecordClassName"
FROM "ContentBuilderBlock"
WHERE ("ContentBuilderBlock"."ContentBuilderSectionID" = ?)
ORDER BY "ContentBuilderBlock"."SortOrder" ASC
0.0002s
0020: SELECT DISTINCT "ContentBuilderBlock"."ClassName", "ContentBuilderBlock"."LastEdited", "ContentBuilderBlock"."Created", "ContentBuilderBlock"."SortOrder", "ContentBuilderBlock"."AdditionalCssClasses", "ContentBuilderBlock"."Width", "ContentBuilderBlock"."ContentBuilderSectionID", "ContentBuilderBlock"."ID",
CASE WHEN "ContentBuilderBlock"."ClassName" IS NOT NULL THEN "ContentBuilderBlock"."ClassName"
ELSE 'IQnection\\PageBuilder\\ContentBuilder\\Block\\Block' END AS "RecordClassName"
FROM "ContentBuilderBlock"
WHERE ("ContentBuilderBlock"."ContentBuilderSectionID" = ?)
ORDER BY "ContentBuilderBlock"."SortOrder" ASC
0.0002s
0021: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."ActivateMinisite", "Page_Live"."HideMinisiteSidebar", "Page_Live"."ShowMultiLevelMinisite", "Page_Live"."SidebarContent", "Page_Live"."LeftColumn", "Page_Live"."CenterColumn", "Page_Live"."RightColumn", "Page_Live"."AdditionalCode", "Page_Live"."Target", "Page_Live"."HideDesktopMenu", "Page_Live"."HideMobileMenu", "Page_Live"."NavigationCacheKey", "Page_Live"."MetaTitle", "Page_Live"."NoFollow", "Page_Live"."URLRedirects", "Page_Live"."MetaKeywords", "Page_Live"."TopNav", "Page_Live"."DropdownMenuIconLink", "Page_Live"."DropdownMenuIconLinkText", "Page_Live"."DropdownMenuIconID", "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"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0008s
0022: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."ActivateMinisite", "Page_Live"."HideMinisiteSidebar", "Page_Live"."ShowMultiLevelMinisite", "Page_Live"."SidebarContent", "Page_Live"."LeftColumn", "Page_Live"."CenterColumn", "Page_Live"."RightColumn", "Page_Live"."AdditionalCode", "Page_Live"."Target", "Page_Live"."HideDesktopMenu", "Page_Live"."HideMobileMenu", "Page_Live"."NavigationCacheKey", "Page_Live"."MetaTitle", "Page_Live"."NoFollow", "Page_Live"."URLRedirects", "Page_Live"."MetaKeywords", "Page_Live"."TopNav", "Page_Live"."DropdownMenuIconLink", "Page_Live"."DropdownMenuIconLinkText", "Page_Live"."DropdownMenuIconID", "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"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
0023: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."LegacyData", "SiteTree_Live"."LegacyID", "SiteTree_Live"."ImportStatus", "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.0003s
0024: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."LegacyData", "SiteTree_Live"."LegacyID", "SiteTree_Live"."ImportStatus", "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", "Page_Live"."ActivateMinisite", "Page_Live"."HideMinisiteSidebar", "Page_Live"."ShowMultiLevelMinisite", "Page_Live"."SidebarContent", "Page_Live"."LeftColumn", "Page_Live"."CenterColumn", "Page_Live"."RightColumn", "Page_Live"."AdditionalCode", "Page_Live"."Target", "Page_Live"."HideDesktopMenu", "Page_Live"."HideMobileMenu", "Page_Live"."NavigationCacheKey", "Page_Live"."MetaTitle", "Page_Live"."NoFollow", "Page_Live"."URLRedirects", "Page_Live"."MetaKeywords", "Page_Live"."TopNav", "Page_Live"."DropdownMenuIconLink", "Page_Live"."DropdownMenuIconLinkText", "Page_Live"."DropdownMenuIconID", "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 (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0008s
0025: SELECT DISTINCT "LinkableLink"."ClassName", "LinkableLink"."LastEdited", "LinkableLink"."Created", "LinkableLink"."Anchor", "LinkableLink"."Title", "LinkableLink"."Type", "LinkableLink"."URL", "LinkableLink"."Email", "LinkableLink"."Phone", "LinkableLink"."OpenInNewWindow", "LinkableLink"."Template", "LinkableLink"."SiteTreeID", "LinkableLink"."FileID", "LinkableLink"."ID",
CASE WHEN "LinkableLink"."ClassName" IS NOT NULL THEN "LinkableLink"."ClassName"
ELSE 'Sheadawson\\Linkable\\Models\\Link' END AS "RecordClassName"
FROM "LinkableLink"
WHERE ("LinkableLink"."ID" = ?)
LIMIT 1
0.0005s
0026: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."LegacyData", "SiteTree_Live"."LegacyID", "SiteTree_Live"."ImportStatus", "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.0002s
0027: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."LegacyData", "SiteTree_Live"."LegacyID", "SiteTree_Live"."ImportStatus", "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.0002s
0028: SELECT DISTINCT "LinkableLink"."ClassName", "LinkableLink"."LastEdited", "LinkableLink"."Created", "LinkableLink"."Anchor", "LinkableLink"."Title", "LinkableLink"."Type", "LinkableLink"."URL", "LinkableLink"."Email", "LinkableLink"."Phone", "LinkableLink"."OpenInNewWindow", "LinkableLink"."Template", "LinkableLink"."SiteTreeID", "LinkableLink"."FileID", "LinkableLink"."ID",
CASE WHEN "LinkableLink"."ClassName" IS NOT NULL THEN "LinkableLink"."ClassName"
ELSE 'Sheadawson\\Linkable\\Models\\Link' END AS "RecordClassName"
FROM "LinkableLink"
WHERE ("LinkableLink"."ID" = ?)
LIMIT 1
0.0594s
0029: SELECT "Page_Live"."NavigationCacheKey", "SiteTree_Live"."ID" AS "_SortColumn0"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID"
ORDER BY "_SortColumn0" ASC
0.0602s
0030: SELECT DISTINCT "PageBuilderSection"."ClassName", "PageBuilderSection"."LastEdited", "PageBuilderSection"."Created", "PageBuilderSection"."SortOrder", "PageBuilderSection"."BackgroundColor", "PageBuilderSection"."AdditionalCssClasses", "PageBuilderSection"."Borders", "PageBuilderSection"."PageID", "PageBuilderSection"."BackgroundImageLargeID", "PageBuilderSection"."BackgroundImageMediumID", "PageBuilderSection"."BackgroundImageSmallID", "PageBuilderSection"."ID",
CASE WHEN "PageBuilderSection"."ClassName" IS NOT NULL THEN "PageBuilderSection"."ClassName"
ELSE 'IQnection\\PageBuilder\\Section\\PageBuilderSection' END AS "RecordClassName"
FROM "PageBuilderSection"
WHERE ("PageBuilderSection"."PageID" = ?)
ORDER BY "PageBuilderSection"."SortOrder" ASC
0.0003s
0031: SELECT DISTINCT "ContentBuilderBlock"."ClassName", "ContentBuilderBlock"."LastEdited", "ContentBuilderBlock"."Created", "ContentBuilderBlock"."SortOrder", "ContentBuilderBlock"."AdditionalCssClasses", "ContentBuilderBlock"."Width", "ContentBuilderBlock"."ContentBuilderSectionID", "ContentBuilderBlock"."ID",
CASE WHEN "ContentBuilderBlock"."ClassName" IS NOT NULL THEN "ContentBuilderBlock"."ClassName"
ELSE 'IQnection\\PageBuilder\\ContentBuilder\\Block\\Block' END AS "RecordClassName"
FROM "ContentBuilderBlock"
WHERE ("ContentBuilderBlock"."ContentBuilderSectionID" = ?)
ORDER BY "ContentBuilderBlock"."SortOrder" ASC
0.0002s
0032: SELECT DISTINCT "ContentBuilderBlock"."ClassName", "ContentBuilderBlock"."LastEdited", "ContentBuilderBlock"."Created", "ContentBuilderContent"."Content", "ContentBuilderBlock"."ID",
CASE WHEN "ContentBuilderBlock"."ClassName" IS NOT NULL THEN "ContentBuilderBlock"."ClassName"
ELSE 'IQnection\\PageBuilder\\ContentBuilder\\Block\\Block' END AS "RecordClassName", "ContentBuilderBlock"."SortOrder"
FROM "ContentBuilderBlock" LEFT JOIN "ContentBuilderContent" ON "ContentBuilderContent"."ID" = "ContentBuilderBlock"."ID"
WHERE ("ContentBuilderBlock"."ID" = ?)
AND ("ContentBuilderBlock"."ClassName" IN (?))
ORDER BY "ContentBuilderBlock"."SortOrder" ASC
LIMIT 1
0.0005s
0033: SELECT DISTINCT "ContentBuilderBlock"."ClassName", "ContentBuilderBlock"."LastEdited", "ContentBuilderBlock"."Created", "ContentBuilderBlock"."SortOrder", "ContentBuilderBlock"."AdditionalCssClasses", "ContentBuilderBlock"."Width", "ContentBuilderBlock"."ContentBuilderSectionID", "ContentBuilderBlock"."ID",
CASE WHEN "ContentBuilderBlock"."ClassName" IS NOT NULL THEN "ContentBuilderBlock"."ClassName"
ELSE 'IQnection\\PageBuilder\\ContentBuilder\\Block\\Block' END AS "RecordClassName"
FROM "ContentBuilderBlock"
WHERE ("ContentBuilderBlock"."ContentBuilderSectionID" = ?)
ORDER BY "ContentBuilderBlock"."SortOrder" ASC
0.0002s
0034: SELECT DISTINCT "ContentBuilderBlock"."ClassName", "ContentBuilderBlock"."LastEdited", "ContentBuilderBlock"."Created", "ContentBuilderContentContent"."LeftContent", "ContentBuilderContentContent"."RightContent", "ContentBuilderContentContent"."Split", "ContentBuilderBlock"."ID",
CASE WHEN "ContentBuilderBlock"."ClassName" IS NOT NULL THEN "ContentBuilderBlock"."ClassName"
ELSE 'IQnection\\PageBuilder\\ContentBuilder\\Block\\Block' END AS "RecordClassName", "ContentBuilderBlock"."SortOrder"
FROM "ContentBuilderBlock" LEFT JOIN "ContentBuilderContentContent" ON "ContentBuilderContentContent"."ID" = "ContentBuilderBlock"."ID"
WHERE ("ContentBuilderBlock"."ID" = ?)
AND ("ContentBuilderBlock"."ClassName" IN (?, ?))
ORDER BY "ContentBuilderBlock"."SortOrder" ASC
LIMIT 1
0.0005s
0035: SELECT DISTINCT "ContentBuilderBlock"."ClassName", "ContentBuilderBlock"."LastEdited", "ContentBuilderBlock"."Created", "ContentBuilderContent"."Content", "ContentBuilderBlock"."ID",
CASE WHEN "ContentBuilderBlock"."ClassName" IS NOT NULL THEN "ContentBuilderBlock"."ClassName"
ELSE 'IQnection\\PageBuilder\\ContentBuilder\\Block\\Block' END AS "RecordClassName", "ContentBuilderBlock"."SortOrder"
FROM "ContentBuilderBlock" LEFT JOIN "ContentBuilderContent" ON "ContentBuilderContent"."ID" = "ContentBuilderBlock"."ID"
WHERE ("ContentBuilderBlock"."ID" = ?)
AND ("ContentBuilderBlock"."ClassName" IN (?))
ORDER BY "ContentBuilderBlock"."SortOrder" ASC
LIMIT 1
0.0002s
0036: SELECT DISTINCT "ContentBuilderBlock"."ClassName", "ContentBuilderBlock"."LastEdited", "ContentBuilderBlock"."Created", "ContentBuilderBlock"."SortOrder", "ContentBuilderBlock"."AdditionalCssClasses", "ContentBuilderBlock"."Width", "ContentBuilderBlock"."ContentBuilderSectionID", "ContentBuilderBlock"."ID",
CASE WHEN "ContentBuilderBlock"."ClassName" IS NOT NULL THEN "ContentBuilderBlock"."ClassName"
ELSE 'IQnection\\PageBuilder\\ContentBuilder\\Block\\Block' END AS "RecordClassName"
FROM "ContentBuilderBlock"
WHERE ("ContentBuilderBlock"."ContentBuilderSectionID" = ?)
ORDER BY "ContentBuilderBlock"."SortOrder" ASC
0.0002s
0037: SELECT DISTINCT "ContentBuilderBlock"."ClassName", "ContentBuilderBlock"."LastEdited", "ContentBuilderBlock"."Created", "ContentBuilderContentContent"."LeftContent", "ContentBuilderContentContent"."RightContent", "ContentBuilderContentContent"."Split", "ContentBuilderBlock"."ID",
CASE WHEN "ContentBuilderBlock"."ClassName" IS NOT NULL THEN "ContentBuilderBlock"."ClassName"
ELSE 'IQnection\\PageBuilder\\ContentBuilder\\Block\\Block' END AS "RecordClassName", "ContentBuilderBlock"."SortOrder"
FROM "ContentBuilderBlock" LEFT JOIN "ContentBuilderContentContent" ON "ContentBuilderContentContent"."ID" = "ContentBuilderBlock"."ID"
WHERE ("ContentBuilderBlock"."ID" = ?)
AND ("ContentBuilderBlock"."ClassName" IN (?, ?))
ORDER BY "ContentBuilderBlock"."SortOrder" ASC
LIMIT 1
0.0002s
0038: SELECT DISTINCT "ContentBuilderBlock"."ClassName", "ContentBuilderBlock"."LastEdited", "ContentBuilderBlock"."Created", "ContentBuilderContent"."Content", "ContentBuilderBlock"."ID",
CASE WHEN "ContentBuilderBlock"."ClassName" IS NOT NULL THEN "ContentBuilderBlock"."ClassName"
ELSE 'IQnection\\PageBuilder\\ContentBuilder\\Block\\Block' END AS "RecordClassName", "ContentBuilderBlock"."SortOrder"
FROM "ContentBuilderBlock" LEFT JOIN "ContentBuilderContent" ON "ContentBuilderContent"."ID" = "ContentBuilderBlock"."ID"
WHERE ("ContentBuilderBlock"."ID" = ?)
AND ("ContentBuilderBlock"."ClassName" IN (?))
ORDER BY "ContentBuilderBlock"."SortOrder" ASC
LIMIT 1
0.0002s
0039: SELECT DISTINCT "ContentBuilderBlock"."ClassName", "ContentBuilderBlock"."LastEdited", "ContentBuilderBlock"."Created", "ContentBuilderBlock"."SortOrder", "ContentBuilderBlock"."AdditionalCssClasses", "ContentBuilderBlock"."Width", "ContentBuilderBlock"."ContentBuilderSectionID", "ContentBuilderBlock"."ID",
CASE WHEN "ContentBuilderBlock"."ClassName" IS NOT NULL THEN "ContentBuilderBlock"."ClassName"
ELSE 'IQnection\\PageBuilder\\ContentBuilder\\Block\\Block' END AS "RecordClassName"
FROM "ContentBuilderBlock"
WHERE ("ContentBuilderBlock"."ContentBuilderSectionID" = ?)
ORDER BY "ContentBuilderBlock"."SortOrder" ASC
0.0002s
0040: SELECT DISTINCT "ContentBuilderBlock"."ClassName", "ContentBuilderBlock"."LastEdited", "ContentBuilderBlock"."Created", "ContentBuilderContentContent"."LeftContent", "ContentBuilderContentContent"."RightContent", "ContentBuilderContentContent"."Split", "ContentBuilderBlock"."ID",
CASE WHEN "ContentBuilderBlock"."ClassName" IS NOT NULL THEN "ContentBuilderBlock"."ClassName"
ELSE 'IQnection\\PageBuilder\\ContentBuilder\\Block\\Block' END AS "RecordClassName", "ContentBuilderBlock"."SortOrder"
FROM "ContentBuilderBlock" LEFT JOIN "ContentBuilderContentContent" ON "ContentBuilderContentContent"."ID" = "ContentBuilderBlock"."ID"
WHERE ("ContentBuilderBlock"."ID" = ?)
AND ("ContentBuilderBlock"."ClassName" IN (?, ?))
ORDER BY "ContentBuilderBlock"."SortOrder" ASC
LIMIT 1
0.0002s
0041: SELECT DISTINCT "ContentBuilderBlock"."ClassName", "ContentBuilderBlock"."LastEdited", "ContentBuilderBlock"."Created", "ContentBuilderContent"."Content", "ContentBuilderBlock"."ID",
CASE WHEN "ContentBuilderBlock"."ClassName" IS NOT NULL THEN "ContentBuilderBlock"."ClassName"
ELSE 'IQnection\\PageBuilder\\ContentBuilder\\Block\\Block' END AS "RecordClassName", "ContentBuilderBlock"."SortOrder"
FROM "ContentBuilderBlock" LEFT JOIN "ContentBuilderContent" ON "ContentBuilderContent"."ID" = "ContentBuilderBlock"."ID"
WHERE ("ContentBuilderBlock"."ID" = ?)
AND ("ContentBuilderBlock"."ClassName" IN (?))
ORDER BY "ContentBuilderBlock"."SortOrder" ASC
LIMIT 1
0.0002s
0042: SELECT DISTINCT "ContentBuilderBlock"."ClassName", "ContentBuilderBlock"."LastEdited", "ContentBuilderBlock"."Created", "ContentBuilderBlock"."SortOrder", "ContentBuilderBlock"."AdditionalCssClasses", "ContentBuilderBlock"."Width", "ContentBuilderBlock"."ContentBuilderSectionID", "ContentBuilderBlock"."ID",
CASE WHEN "ContentBuilderBlock"."ClassName" IS NOT NULL THEN "ContentBuilderBlock"."ClassName"
ELSE 'IQnection\\PageBuilder\\ContentBuilder\\Block\\Block' END AS "RecordClassName"
FROM "ContentBuilderBlock"
WHERE ("ContentBuilderBlock"."ContentBuilderSectionID" = ?)
ORDER BY "ContentBuilderBlock"."SortOrder" ASC
0.0002s
0043: SELECT DISTINCT "ContentBuilderBlock"."ClassName", "ContentBuilderBlock"."LastEdited", "ContentBuilderBlock"."Created", "ContentBuilderContentContent"."LeftContent", "ContentBuilderContentContent"."RightContent", "ContentBuilderContentContent"."Split", "ContentBuilderBlock"."ID",
CASE WHEN "ContentBuilderBlock"."ClassName" IS NOT NULL THEN "ContentBuilderBlock"."ClassName"
ELSE 'IQnection\\PageBuilder\\ContentBuilder\\Block\\Block' END AS "RecordClassName", "ContentBuilderBlock"."SortOrder"
FROM "ContentBuilderBlock" LEFT JOIN "ContentBuilderContentContent" ON "ContentBuilderContentContent"."ID" = "ContentBuilderBlock"."ID"
WHERE ("ContentBuilderBlock"."ID" = ?)
AND ("ContentBuilderBlock"."ClassName" IN (?, ?))
ORDER BY "ContentBuilderBlock"."SortOrder" ASC
LIMIT 1
0.0002s
0044: SELECT DISTINCT "ContentBuilderBlock"."ClassName", "ContentBuilderBlock"."LastEdited", "ContentBuilderBlock"."Created", "ContentBuilderContent"."Content", "ContentBuilderBlock"."ID",
CASE WHEN "ContentBuilderBlock"."ClassName" IS NOT NULL THEN "ContentBuilderBlock"."ClassName"
ELSE 'IQnection\\PageBuilder\\ContentBuilder\\Block\\Block' END AS "RecordClassName", "ContentBuilderBlock"."SortOrder"
FROM "ContentBuilderBlock" LEFT JOIN "ContentBuilderContent" ON "ContentBuilderContent"."ID" = "ContentBuilderBlock"."ID"
WHERE ("ContentBuilderBlock"."ID" = ?)
AND ("ContentBuilderBlock"."ClassName" IN (?))
ORDER BY "ContentBuilderBlock"."SortOrder" ASC
LIMIT 1
0.0002s
0045: SELECT DISTINCT "ContentBuilderBlock"."ClassName", "ContentBuilderBlock"."LastEdited", "ContentBuilderBlock"."Created", "ContentBuilderBlock"."SortOrder", "ContentBuilderBlock"."AdditionalCssClasses", "ContentBuilderBlock"."Width", "ContentBuilderBlock"."ContentBuilderSectionID", "ContentBuilderBlock"."ID",
CASE WHEN "ContentBuilderBlock"."ClassName" IS NOT NULL THEN "ContentBuilderBlock"."ClassName"
ELSE 'IQnection\\PageBuilder\\ContentBuilder\\Block\\Block' END AS "RecordClassName"
FROM "ContentBuilderBlock"
WHERE ("ContentBuilderBlock"."ContentBuilderSectionID" = ?)
ORDER BY "ContentBuilderBlock"."SortOrder" ASC
0.0002s
0046: SELECT DISTINCT "ContentBuilderBlock"."ClassName", "ContentBuilderBlock"."LastEdited", "ContentBuilderBlock"."Created", "ContentBuilderContentContent"."LeftContent", "ContentBuilderContentContent"."RightContent", "ContentBuilderContentContent"."Split", "ContentBuilderBlock"."ID",
CASE WHEN "ContentBuilderBlock"."ClassName" IS NOT NULL THEN "ContentBuilderBlock"."ClassName"
ELSE 'IQnection\\PageBuilder\\ContentBuilder\\Block\\Block' END AS "RecordClassName", "ContentBuilderBlock"."SortOrder"
FROM "ContentBuilderBlock" LEFT JOIN "ContentBuilderContentContent" ON "ContentBuilderContentContent"."ID" = "ContentBuilderBlock"."ID"
WHERE ("ContentBuilderBlock"."ID" = ?)
AND ("ContentBuilderBlock"."ClassName" IN (?, ?))
ORDER BY "ContentBuilderBlock"."SortOrder" ASC
LIMIT 1
0.0002s
0047: SELECT DISTINCT "ContentBuilderBlock"."ClassName", "ContentBuilderBlock"."LastEdited", "ContentBuilderBlock"."Created", "ContentBuilderContent"."Content", "ContentBuilderBlock"."ID",
CASE WHEN "ContentBuilderBlock"."ClassName" IS NOT NULL THEN "ContentBuilderBlock"."ClassName"
ELSE 'IQnection\\PageBuilder\\ContentBuilder\\Block\\Block' END AS "RecordClassName", "ContentBuilderBlock"."SortOrder"
FROM "ContentBuilderBlock" LEFT JOIN "ContentBuilderContent" ON "ContentBuilderContent"."ID" = "ContentBuilderBlock"."ID"
WHERE ("ContentBuilderBlock"."ID" = ?)
AND ("ContentBuilderBlock"."ClassName" IN (?))
ORDER BY "ContentBuilderBlock"."SortOrder" ASC
LIMIT 1
0.0002s
0048: SELECT DISTINCT "ContentBuilderBlock"."ClassName", "ContentBuilderBlock"."LastEdited", "ContentBuilderBlock"."Created", "ContentBuilderBlock"."SortOrder", "ContentBuilderBlock"."AdditionalCssClasses", "ContentBuilderBlock"."Width", "ContentBuilderBlock"."ContentBuilderSectionID", "ContentBuilderBlock"."ID",
CASE WHEN "ContentBuilderBlock"."ClassName" IS NOT NULL THEN "ContentBuilderBlock"."ClassName"
ELSE 'IQnection\\PageBuilder\\ContentBuilder\\Block\\Block' END AS "RecordClassName"
FROM "ContentBuilderBlock"
WHERE ("ContentBuilderBlock"."ContentBuilderSectionID" = ?)
ORDER BY "ContentBuilderBlock"."SortOrder" ASC
0.0002s
0049: SELECT DISTINCT "ContentBuilderBlock"."ClassName", "ContentBuilderBlock"."LastEdited", "ContentBuilderBlock"."Created", "ContentBuilderContentContent"."LeftContent", "ContentBuilderContentContent"."RightContent", "ContentBuilderContentContent"."Split", "ContentBuilderBlock"."ID",
CASE WHEN "ContentBuilderBlock"."ClassName" IS NOT NULL THEN "ContentBuilderBlock"."ClassName"
ELSE 'IQnection\\PageBuilder\\ContentBuilder\\Block\\Block' END AS "RecordClassName", "ContentBuilderBlock"."SortOrder"
FROM "ContentBuilderBlock" LEFT JOIN "ContentBuilderContentContent" ON "ContentBuilderContentContent"."ID" = "ContentBuilderBlock"."ID"
WHERE ("ContentBuilderBlock"."ID" = ?)
AND ("ContentBuilderBlock"."ClassName" IN (?, ?))
ORDER BY "ContentBuilderBlock"."SortOrder" ASC
LIMIT 1
0.0002s
0050: SELECT DISTINCT "ContentBuilderBlock"."ClassName", "ContentBuilderBlock"."LastEdited", "ContentBuilderBlock"."Created", "ContentBuilderContent"."Content", "ContentBuilderBlock"."ID",
CASE WHEN "ContentBuilderBlock"."ClassName" IS NOT NULL THEN "ContentBuilderBlock"."ClassName"
ELSE 'IQnection\\PageBuilder\\ContentBuilder\\Block\\Block' END AS "RecordClassName", "ContentBuilderBlock"."SortOrder"
FROM "ContentBuilderBlock" LEFT JOIN "ContentBuilderContent" ON "ContentBuilderContent"."ID" = "ContentBuilderBlock"."ID"
WHERE ("ContentBuilderBlock"."ID" = ?)
AND ("ContentBuilderBlock"."ClassName" IN (?))
ORDER BY "ContentBuilderBlock"."SortOrder" ASC
LIMIT 1
0.0002s
0051: SELECT DISTINCT "ContentBuilderBlock"."ClassName", "ContentBuilderBlock"."LastEdited", "ContentBuilderBlock"."Created", "ContentBuilderBlock"."SortOrder", "ContentBuilderBlock"."AdditionalCssClasses", "ContentBuilderBlock"."Width", "ContentBuilderBlock"."ContentBuilderSectionID", "ContentBuilderBlock"."ID",
CASE WHEN "ContentBuilderBlock"."ClassName" IS NOT NULL THEN "ContentBuilderBlock"."ClassName"
ELSE 'IQnection\\PageBuilder\\ContentBuilder\\Block\\Block' END AS "RecordClassName"
FROM "ContentBuilderBlock"
WHERE ("ContentBuilderBlock"."ContentBuilderSectionID" = ?)
ORDER BY "ContentBuilderBlock"."SortOrder" ASC
0.0002s
0052: SELECT DISTINCT "ContentBuilderBlock"."ClassName", "ContentBuilderBlock"."LastEdited", "ContentBuilderBlock"."Created", "ContentBuilderContentContent"."LeftContent", "ContentBuilderContentContent"."RightContent", "ContentBuilderContentContent"."Split", "ContentBuilderBlock"."ID",
CASE WHEN "ContentBuilderBlock"."ClassName" IS NOT NULL THEN "ContentBuilderBlock"."ClassName"
ELSE 'IQnection\\PageBuilder\\ContentBuilder\\Block\\Block' END AS "RecordClassName", "ContentBuilderBlock"."SortOrder"
FROM "ContentBuilderBlock" LEFT JOIN "ContentBuilderContentContent" ON "ContentBuilderContentContent"."ID" = "ContentBuilderBlock"."ID"
WHERE ("ContentBuilderBlock"."ID" = ?)
AND ("ContentBuilderBlock"."ClassName" IN (?, ?))
ORDER BY "ContentBuilderBlock"."SortOrder" ASC
LIMIT 1
0.0002s
0053: SELECT DISTINCT "ContentBuilderBlock"."ClassName", "ContentBuilderBlock"."LastEdited", "ContentBuilderBlock"."Created", "ContentBuilderContent"."Content", "ContentBuilderBlock"."ID",
CASE WHEN "ContentBuilderBlock"."ClassName" IS NOT NULL THEN "ContentBuilderBlock"."ClassName"
ELSE 'IQnection\\PageBuilder\\ContentBuilder\\Block\\Block' END AS "RecordClassName", "ContentBuilderBlock"."SortOrder"
FROM "ContentBuilderBlock" LEFT JOIN "ContentBuilderContent" ON "ContentBuilderContent"."ID" = "ContentBuilderBlock"."ID"
WHERE ("ContentBuilderBlock"."ID" = ?)
AND ("ContentBuilderBlock"."ClassName" IN (?))
ORDER BY "ContentBuilderBlock"."SortOrder" ASC
LIMIT 1
0.0002s
0054: SELECT DISTINCT "ContentBuilderBlock"."ClassName", "ContentBuilderBlock"."LastEdited", "ContentBuilderBlock"."Created", "ContentBuilderBlock"."SortOrder", "ContentBuilderBlock"."AdditionalCssClasses", "ContentBuilderBlock"."Width", "ContentBuilderBlock"."ContentBuilderSectionID", "ContentBuilderBlock"."ID",
CASE WHEN "ContentBuilderBlock"."ClassName" IS NOT NULL THEN "ContentBuilderBlock"."ClassName"
ELSE 'IQnection\\PageBuilder\\ContentBuilder\\Block\\Block' END AS "RecordClassName"
FROM "ContentBuilderBlock"
WHERE ("ContentBuilderBlock"."ContentBuilderSectionID" = ?)
ORDER BY "ContentBuilderBlock"."SortOrder" ASC
0.0002s
0055: SELECT DISTINCT "ContentBuilderBlock"."ClassName", "ContentBuilderBlock"."LastEdited", "ContentBuilderBlock"."Created", "ContentBuilderContentContent"."LeftContent", "ContentBuilderContentContent"."RightContent", "ContentBuilderContentContent"."Split", "ContentBuilderBlock"."ID",
CASE WHEN "ContentBuilderBlock"."ClassName" IS NOT NULL THEN "ContentBuilderBlock"."ClassName"
ELSE 'IQnection\\PageBuilder\\ContentBuilder\\Block\\Block' END AS "RecordClassName", "ContentBuilderBlock"."SortOrder"
FROM "ContentBuilderBlock" LEFT JOIN "ContentBuilderContentContent" ON "ContentBuilderContentContent"."ID" = "ContentBuilderBlock"."ID"
WHERE ("ContentBuilderBlock"."ID" = ?)
AND ("ContentBuilderBlock"."ClassName" IN (?, ?))
ORDER BY "ContentBuilderBlock"."SortOrder" ASC
LIMIT 1
0.0002s
0056: SELECT DISTINCT "ContentBuilderBlock"."ClassName", "ContentBuilderBlock"."LastEdited", "ContentBuilderBlock"."Created", "ContentBuilderBlock"."SortOrder", "ContentBuilderBlock"."AdditionalCssClasses", "ContentBuilderBlock"."Width", "ContentBuilderBlock"."ContentBuilderSectionID", "ContentBuilderBlock"."ID",
CASE WHEN "ContentBuilderBlock"."ClassName" IS NOT NULL THEN "ContentBuilderBlock"."ClassName"
ELSE 'IQnection\\PageBuilder\\ContentBuilder\\Block\\Block' END AS "RecordClassName"
FROM "ContentBuilderBlock"
WHERE ("ContentBuilderBlock"."ContentBuilderSectionID" = ?)
ORDER BY "ContentBuilderBlock"."SortOrder" ASC
0.0002s
0057: SELECT DISTINCT "ContentBuilderBlock"."ClassName", "ContentBuilderBlock"."LastEdited", "ContentBuilderBlock"."Created", "ContentBuilderContent"."Content", "ContentBuilderBlock"."ID",
CASE WHEN "ContentBuilderBlock"."ClassName" IS NOT NULL THEN "ContentBuilderBlock"."ClassName"
ELSE 'IQnection\\PageBuilder\\ContentBuilder\\Block\\Block' END AS "RecordClassName", "ContentBuilderBlock"."SortOrder"
FROM "ContentBuilderBlock" LEFT JOIN "ContentBuilderContent" ON "ContentBuilderContent"."ID" = "ContentBuilderBlock"."ID"
WHERE ("ContentBuilderBlock"."ID" = ?)
AND ("ContentBuilderBlock"."ClassName" IN (?))
ORDER BY "ContentBuilderBlock"."SortOrder" ASC
LIMIT 1
0.0002s
0058: SELECT "Version" FROM "SiteTree" WHERE "ID" = ?
0.0003s
0059: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."LegacyData", "SiteTree_Live"."LegacyID", "SiteTree_Live"."ImportStatus", "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.0003s
0060: SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", "SiteTree"."Priority", "SiteTree"."LegacyData", "SiteTree"."LegacyID", "SiteTree"."ImportStatus", "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.0005s
0061: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."LegacyData", "SiteTree_Live"."LegacyID", "SiteTree_Live"."ImportStatus", "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.0003s
0062: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."LegacyData", "SiteTree_Live"."LegacyID", "SiteTree_Live"."ImportStatus", "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.0002s
The healthcare industry is constantly evolving—shouldn’t your skills be, too? The University of Chicago offers professional development certificates in Clinical Trials Management and Regulatory Compliance, Medical Writing and Editing, and now Regulatory Writing.
These part-time online programs cover everything from understanding and applying the strictest ethical guidelines during clinical research to collaborating on writing biomedical regulatory packets, and navigating the editing and submission processes for the FDA. Taught by seasoned industry professionals with extensive experience writing on regulatory and compliance tasks, and with every phase of the clinical trials process, you will build your skills while also building your professional network for the future.
Our healthcare professional development certificate programs provide a rigorous training environment that can accelerate your career. Join expert instructors and fellow students as committed to learning as you are in live, intimate, synchronous sessions designed to help you make connections and develop relationships that extend beyond the classroom.
The Waldron College of Health and Human Services, Department of Public Health and Healthcare Leadership at Radford University Carilion offers a Master of Science in Health Sciences (MSHS) with a concentration in Clinical Research Administration. Radford University Carilion is a vibrant interprofessional healthcare learning community located in downtown Roanoke, Virginia within Carilion Roanoke Community Hospital.
The MSHS graduate program is available 100% online. It includes 36 credits with five courses in the Clinical Research Administration concentration: • Clinical Research Methods • Clinical Research Administration I • Clinical Research Administration II • Medical Product Development and Regulation, and • Clinical Research Administration Internship
The program assists individuals to work towards meeting the eligibility criteria for the Society for Clinical Research Associates (SOCRA) certification exam.
Join industry professionals for a 14-week interactive and hands-on course that will provide you with the skills to effectively integrate into a variety of clinical data management and electronic data capture design roles.
Using a combination of in class training and REDCap – an EDC system used in over 5600 non-profit institutions worldwide – you will learn key skills central to data management activities, from design and development of an effective EDC program for clinical researchers, industry requirements and documentation, and data handling concepts.
Using a combination of in class training and REDCap – an EDC system used in over 5600 non-profit institutions worldwide – you will learn key skills central to data management activities, from design and development of an effective EDC program for clinical researchers, industry requirements and documentation, and data handling concepts.
Course topics include:
What is clinical data management and why is it more important than ever?
Gathering requirements and understanding database specifications
How to build and test a robust REDCap database based on a clinical trial protocol
Data management plans and why you need them
Other essential data management principles including data handling and reporting, user management, study data coding and the other key skills to help you become an effective data manager.
Study Data Analysis and Submission or Reporting
Previous experience with clinical research principles is required to fully benefit from the program and students are expected to have a firm grasp of ICH-GCP prior to starting the course.
Campbell University’s Master’s in Clinical Research is 100% online, making it a flexible option for working professionals looking to grow their career. Accelerated 8-week courses allow students to complete the degree in as little as 2 years.
SOCRA members can apply for free using the code SOCRA2021 and SOCRA members who register for at least 4 credit hours in a semester are eligible for a $500scholarship for two semesters
Graduates are prepared for leadership positions in pharmaceutical and biotechnology industries, government agencies, medical institutions, academic institutions and hospitals. Students can simultaneously earn a dual degree in pharmacy or business.
The Master of Science in Clinical Research (MSCR) is a rigorous program designed to meet the needs of health care professionals engaged in the full spectrum of patient-oriented research as well as students that are interested in clinical research coordination and management. Our mission is to provide students with a rigorous academic experience, hands-on exposure to, and practical experience in clinical research. MSCR graduates will be well prepared to enter the workforce as completely trained research professionals.
Degree coursework, offered full or part-time, covers aspects of clinical trial methodology and regulatory sciences, as well as an immersion in the use of medical bioinformatics and associated metadata to perform big-data analyses. The didactic portion of this program can be completed in one year. Students can choose to participate in an Internship/Practicum, or Independent Study in Clinical Research in addition to their capstone/thesis research project.
At the Rush University Graduate College we are here to help you achieve your educational and career goals, you can reach us at gc_admissions@rush.edu Let us show you how, apply today.
Updated June 2021
Boston College Clinical Research Certificate Program
Now is the time to join the growing Biotech, Pharmaceutical and Clinical Research field!
Classes are held Live on Zoom.
The clinical research field is a new, stimulating, and innovative career choice with many job opportunities. As the development of drug and medical devices increases, there is a need for scientifically trained professionals to coordinate research studies.
This program will give you an understanding of the landscape of clinical research including the duties of the following roles: clinical research associate (CRA), clinical research coordinator (CRC), data specialist, subject recruiter, research billing officer, compliance administrator, and other specialties. Our Clinical Research Certificate Program includes a rigorous curriculum to prepare you for today's competitive marketplace.
Clinical Research: Principles, Protocols and Procedures
Project Management in Clinical Research
Transitioning into a Career in Clinical Research
All instructors are currently working in the topic area they are teaching. They work at organizations including: Boston Children's Hospital, Takeda, Harvard School of Public Health, Centrexion Therapeutics, ImmunoGen, EMD Serono, Epizyme, Propel Careers, Moderna, Medidata.
All courses can be completed in less than three months or you can spread them out over two years. This is a Continuing Education program; it does not have an application process, and offers contact hours.
As a member of SOCRA, you are eligible to receive a 10-40% reduction off the regular on-campus tuition rate at Drexel University when you take courses online. As an added benefit, spouses and immediate family members of SOCRA members are also eligible to receive the same tuition reduction for Drexel's online programs through this educational collaboration. Pursuing a degree has never been easier, or more affordable!
SOCRA-related online programs include MS in Clinical Research Organization and Management, Master of Laboratory Animal Science, MSN in Clinical Research and well as shorter certificate programs. Additional discounted programs include undergraduate and graduate programs in business, human resources, nursing, engineering, information systems, education and health sciences.
Delivered fully online, Drexel's programs are highly interactive and are designed for working professionals seeking to earn a degree or additional certification. The online programs follow the same high academic standards and lead to the same quality degrees as on-campus, with no commuting or career interruption.
To learn more about this collaboration and Drexel’s online programs, please visit the SOCRA partner page at www.drexel.com/socra or contact the SOCRA partnership liaison, Amy Holvey, at 215.895.0535, alh449@drexel.edu.
To qualify for these reduced tuition rates, members and their spouses should use "SOCRA" as your affiliation code when you complete an application.
The Master of Business & Science degree (MBS) combines a traditional STEM Master of Science degree with business courses, experiential learning and networking opportunities. Our programs are flexible and customizable to fit your career goals and students can attend classes online or on-campus, part-time or full-time. We are a part of the Professional Science Master's network that includes more than 150 academic institutions across the country.
Medical writing is a growing and essential skill to meet the needs of the changing healthcare landscape. We’ve curated a comprehensive online program designed to empower professionals with the skills and insights needed to excel in medical communications roles. UChicago’s Healthcare Communications certificate program provides expert instructors, cutting-edge curriculum, interactive and flexible learning, networking opportunities, and stackable training options within a healthcare certificate portfolio.