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

SchureMed
Innovative Solutions in Advanced Surgical Positioning

New User Registration

Email Address is Required Invalid Email Address Confirm Email Address is Required Invalid Confirm Email Address The Email and Confirm Email must match.
Password is Required Password must be at least 6 characters Confirm Password is Required The Password and Confirm Password must match.

User Details

First Name is Required
Last Name is Required
Phone is Required

Organization Details

 

Bill To Address

Address is Required
City is Required
Country is Required
State is Required
Postal Code is Required
×

Developer Tools

Database Activity Repeated Calls Shipping Rates Performance Tracking Cache Storage Session Storage
schuremeddev.braveriversolutions.com
0.6914161 seconds
# Seconds Since First Hit Trace Command Type Command Text Parameters Execution Time
1. 0 DBInterface.GetDataT show StoredProcedure [dbo].[procGetAllCountryList] - 0.1483865
2. 0.0117504 DBInterface.GetDataT show StoredProcedure [dbo].[procGetCountryStatesList] @CountryCode=USA
0.0117504
3. 0.0117504 DBInterface.GetDataT show StoredProcedure [dbo].[procGetAllCountryList] - 0
4. 0.0742823 DBInterface.GetDataT show StoredProcedure [dbo].[VirtualCatalogLoadBySiteDomain] @SiteDomain=schuremeddev.braveriversolutions.com
0
5. 0.0742823 DBInterface.get_oSQL show StoredProcedure [dbo].[VirtualSitePropertiesLoadBySiteID] @SiteID=1
0
6. 0.105533 DBInterface.GetDataT show Text SELECT TOP(1) HTMLArticles.ID AS ArticleID, HTMLContent.ID, PageTitle, PageMetaDesc, PageMetaKwords, show - 0.0156257
7. 0.105533 DBInterface.GetDataT show StoredProcedure Content_LoadMiscContent - 0
8. 0.1211569 DBInterface.GetDataT show Text SELECT TOP(1) HTMLArticles.ID AS ArticleID, HTMLContent.ID, PageTitle, PageMetaDesc, PageMetaKwords, show - 0
9. 0.1211569 DBInterface.GetDataT show Text SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Header - Alert Bar show - 0
10. 0.1524074 DBInterface.GetDataT show Text WITH CatPath (ParentContentID, ContentID, Iteration) AS ( SELECT HTMLContent_XREF.ParentContentID, H show - 0.0156251
11. 0.1524074 DBInterface.GetDataT show Text SELECT ID, PageKey, PageTitle, PageHeading, MenuText, IsMenuItem, CASE WHEN ID = 0 THEN 1 WHEN ID show - 0
12. 0.1680304 DBInterface.GetDataT show StoredProcedure Content_LoadPageLinks - 0
13. 0.2149072 DBInterface.GetDataT show Text DECLARE @StartingID INT; SET @StartingID = 0; DECLARE @Tree TABLE(TreeID INT IDENTITY PRIMARY KEY, show - 0.0312503
14. 0.230542 DBInterface.GetDataT show Text DECLARE @StartingID INT; SET @StartingID = 0; DECLARE @Tree TABLE(TreeID INT IDENTITY PRIMARY KEY, show - 0.0156348
15. 0.2617824 DBInterface.GetDataT show StoredProcedure [dbo].[Cart_LoadByUserID] @UserID=131b2b59-e8df-4b69-9e9d-58d334795047
@SiteID=1
0
Total DB Execution Time 0.2382728
Command Hits
[dbo].[procGetAllCountryList] 2
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 = '/account/createaccount/default.aspx' 2
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
Cache Key Cache Value
VirtualCatalogInfo-schuremeddev.braveriversolutions.com
PageManager_Cache_PageLinks
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]
    TopMenu
  • About Us
  • Become a Rep
  • Contact Us
  • Request a Catalog
  • Request a Quote
  • Videos
  • Session Key Session Value
    UserId 131b2b59-e8df-4b69-9e9d-58d334795047
    IsDynamicallyGeneratedUserId True
    SubmissionSource -
    SubmissionLandingPage /account/createaccount/
    AdminLastSitePage /account/createaccount/default.aspx
    AdminLastPage /account/createaccount/
    OrderNumber
    Section Execution Time
    DBInterface.vb 2.5225705
    MasterPage.master 0.5664179
    DeveloperTools.ascx 0.0625041
    Load Time:0.6914161s  |  Database Hits: 15