New Enhanced Website – Call Customer Service at 781-531-9164 for pricing and ordering information.

SchureMed
Innovative Solutions in Advanced Surgical Positioning

Affiliations

SchureMed’s channel partner for contract sales is CME Corp who is a Contract Holder for the Federal Government and most Major GPO’S.

Mike Abbott | Vice President, Vendor Relations
C: 617.694.4400 | O: 800.338.2372 x8220
mabbott@cmecorp.com


SchureMed is proud to be affiliated with the following companies. Please click on the logos below for further information.

  

×

Developer Tools

Database Activity Repeated Calls Shipping Rates Performance Tracking Cache Storage Session Storage
schuremeddev.braveriversolutions.com
2.0937323 seconds
# Seconds Since First Hit Trace Command Type Command Text Parameters Execution Time
1. 0 DBInterface.GetDataT show StoredProcedure SiteSettings_Load - 0.0263207
2. 0.0625469 DBInterface.GetDataT show StoredProcedure [dbo].[VirtualCatalogLoadBySiteDomain] @SiteDomain=schuremeddev.braveriversolutions.com
0.0156103
3. 0.0625469 DBInterface.get_oSQL show StoredProcedure [dbo].[VirtualSitePropertiesLoadBySiteID] @SiteID=1
0
4. 1.3316123 DBInterface.GetDataT show Text SELECT TOP(1) HTMLArticles.ID AS ArticleID, HTMLContent.ID, PageTitle, PageMetaDesc, PageMetaKwords, show - 0.0131887
5. 1.3952159 DBInterface.GetDataT show StoredProcedure Content_LoadMiscContent - 0.0156262
6. 1.3952159 DBInterface.GetDataT show Text SELECT TOP(1) HTMLArticles.ID AS ArticleID, HTMLContent.ID, PageTitle, PageMetaDesc, PageMetaKwords, show - 0
7. 1.3952159 DBInterface.GetDataT show Text SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Header - Alert Bar show - 0
8. 1.4129256 DBInterface.GetDataT show StoredProcedure Content_LoadPageLinks - 0
9. 1.4599004 DBInterface.GetDataT show Text DECLARE @StartingID INT; SET @StartingID = 0; DECLARE @Tree TABLE(TreeID INT IDENTITY PRIMARY KEY, show - 0.0156928
10. 1.491079 DBInterface.GetDataT show Text DECLARE @StartingID INT; SET @StartingID = 0; DECLARE @Tree TABLE(TreeID INT IDENTITY PRIMARY KEY, show - 0.0311786
11. 1.5241403 DBInterface.GetDataT show StoredProcedure Content_LoadByPageKey @PageKey=/affiliations/default.aspx
@SiteID=1
0
12. 1.6667261 DBInterface.GetDataT show StoredProcedure Content_LoadByPageKey @PageKey=/affiliations/default.aspx
@SiteID=1
0
13. 1.6980499 DBInterface.GetDataT show Text SELECT TOP(1) HTMLArticles.ID AS ArticleID, HTMLContent.ID, PageTitle, PageMetaDesc, PageMetaKwords, show - 0.0156331
14. 1.6980499 DBInterface.GetDataT show StoredProcedure HTMLContentBreadcrumb SiteID=1
ContentID=159
0
15. 1.7294834 DBInterface.GetDataT show StoredProcedure [dbo].[Cart_LoadByUserID] @UserID=46dd85f0-2930-4753-8297-2b3fa420f700
@SiteID=1
0
Total DB Execution Time 0.1332504
Command Hits
SELECT TOP(1) HTMLArticles.ID AS ArticleID, HTMLContent.ID, PageTitle, PageMetaDesc, PageMetaKwords, PageHeading, PageContent, PageContent2, PageContent3, PageContent4, PageContent5, PageContent6, StartDate, EndDate, HTMLContent.Thumbnail, NumLatestArticles, HasArticles, UserControl, COALESCE(PageLayout,0) As PageLayout FROM HTMLContent LEFT OUTER JOIN HTMLArticles ON HTMLContent.ID = HTMLArticles.ContentID WHERE HTMLContent.SiteID = 1 AND PageKey = '/affiliations/default.aspx' 3
DECLARE @StartingID INT; SET @StartingID = 0; DECLARE @Tree TABLE(TreeID INT IDENTITY PRIMARY KEY, Level INT, ParentTreeID INT, [Path] VARCHAR(2000), PageID_Path VARCHAR(2000), PageID INT NOT NULL); DECLARE @RowCount INT, @Level INT, @DelCount INT; SET NOCOUNT ON; SET @Level = 0; INSERT INTO @Tree(PageID, Level) VALUES (@StartingID, @Level); SET @RowCount = @@ROWCOUNT; UPDATE @Tree SET Path = STR(TreeID, 10, 0) + '.', PageID_Path = CAST(PageID AS VARCHAR(10)) + '\'; WHILE @RowCount > 0 BEGIN SET @Level = @Level + 1; INSERT INTO @Tree(Level, ParentTreeID, PageID) SELECT @Level, t.TreeId, PageURLs.ID FROM PageURLs LEFT OUTER JOIN @Tree t ON ISNULL(PageURLs.ParentID,0) = t.PageID AND t.Level = (@Level - 1) INNER JOIN HTMLContent ON HTMLContent.ID = PageURLs.EntityID LEFT OUTER JOIN HTMLContent_XREF ON HTMLContent.ID = HTMLContent_XREF.ContentID WHERE 1=1 AND ( 1=1 AND HTMLContent.SiteID = 1 AND PageURLs.[Type] = 'content' AND HTMLContent.IsMenuItem = 'True' AND @Level <= 20 ) ORDER BY COALESCE(OrderPriority, 1000), PageKey ; SET @RowCount = @@ROWCOUNT; UPDATE t1 SET t1.[Path] = t2.[Path] + STR(t1.TreeID, 10, 0) + '.', t1.PageID_Path = t2.PageID_Path + CAST(t1.PageID AS VARCHAR(10)) + '\' FROM @Tree t1 INNER JOIN @Tree t2 ON t1.ParentTreeID = t2.TreeID WHERE t1.Level = @Level AND t2.PageID_Path NOT LIKE '%' + CAST(t1.PageID AS VARCHAR(10)) + '\%'; DELETE FROM @Tree WHERE PageID_Path IS NULL; SET @DelCount = @@ROWCOUNT; SET @RowCount = (@RowCount - @DelCount); END; SELECT [Path], t.PageID, t.Level , (SELECT COUNT(HTMLContent_XREF1.ID) FROM HTMLContent_XREF AS HTMLContent_XREF1 LEFT JOIN HTMLArticles AS HTMLArticles1 ON HTMLContent_XREF1.ContentID = HTMLArticles1.ContentID LEFT JOIN HTMLContent AS HTMLContent1 ON HTMLContent1.ID = HTMLContent_XREF1.ContentID WHERE HTMLContent_XREF1.ParentContentID = HTMLContent.ID AND (HTMLContent1.IsMenuItem = 'True' OR HTMLContent1.ID IS NULL) AND HTMLArticles1.ID IS NULL) As NumChildren, HTMLContent.ID, HTMLContent.PageKey, HTMLContent.IsMenuItem, HTMLContent.MenuText, HTMLContent.MenuURL, HTMLContent.PageHeading, HTMLContent.HasArticles, HTMLContent_XREF.ParentContentID FROM @Tree t INNER JOIN PageURLs ON t.PageID = PageURLs.ID INNER JOIN HTMLContent ON HTMLContent.ID = PageURLs.EntityID LEFT OUTER JOIN HTMLContent_XREF ON HTMLContent.ID = HTMLContent_XREF.ContentID WHERE 1=1 ORDER BY [Path] ; 2
Content_LoadByPageKey 2
Cache Key Cache Value
PageManager_Cache_PageLinks
TopMenu
  • About Us
  • Become a Rep
  • Contact Us
  • Request a Catalog
  • Request a Quote
  • Videos
  • LeftMenu
  • About Us
  • Become a Rep
  • Contact Us
  • Request a Catalog
  • Request a Quote
  • Videos
  • VirtualSiteProperties-schuremeddev.braveriversolutions.com ECOM.WebForms.BRS.CMS.VirtualSiteProperties
    PageManager_Cache_MiscContent System.Collections.Generic.Dictionary`2[System.String,System.String]
    VirtualCatalogInfo-schuremeddev.braveriversolutions.com
    Session Key Session Value
    SubmissionSource -
    SubmissionLandingPage /affiliations/
    AdminLastSitePage /affiliations/default.aspx
    UserId 46dd85f0-2930-4753-8297-2b3fa420f700
    IsDynamicallyGeneratedUserId True
    AdminLastPage /GetContent.aspx?PageKey=%2faffiliations%2fdefault.aspx&unq=3/29/2024 5:25:41 AM
    OrderNumber
    Section Execution Time
    DBInterface.vb 2.6222831
    MasterPage.master 1.4619408
    DeveloperTools.ascx 0.050192
    Load Time:2.0937323s  |  Database Hits: 15