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

SchureMed
Innovative Solutions in Advanced Surgical Positioning

Exercise

4 Items found
Aqua Air Exerciser
Aqua Air Exerciser
Artic Thermal Sleeves
Artic Thermal Sleeves
Ex-Box w/Bands
Ex-Box w/Bands

Available Combo Deals

×

Developer Tools

Database Activity Repeated Calls Shipping Rates Performance Tracking Cache Storage Session Storage
schuremeddev.braveriversolutions.com
1.948801 seconds
# Seconds Since First Hit Trace Command Type Command Text Parameters Execution Time
1. 0 DBInterface.GetDataT show StoredProcedure SiteSettings_Load - 0.0312637
2. 0.0164518 DBInterface.GetDataT show StoredProcedure [dbo].[VirtualCatalogLoadBySiteDomain] @SiteDomain=schuremeddev.braveriversolutions.com
0
3. 0.0359871 DBInterface.get_oSQL show StoredProcedure [dbo].[VirtualSitePropertiesLoadBySiteID] @SiteID=1
0.0195353
4. 1.1241755 DBInterface.GetDataT show Text SELECT TOP(1) '0' AS ArticleID, 0 As ID, CASE WHEN Category.MetaTitle='' THEN Category.CategoryName show - 0.0162906
5. 1.1405296 DBInterface.GetDataT show StoredProcedure Content_LoadMiscContent - 0
6. 1.1405296 DBInterface.GetDataT show Text SELECT TOP(1) '0' AS ArticleID, 0 As ID, CASE WHEN Category.MetaTitle='' THEN Category.CategoryName show - 0
7. 1.1561846 DBInterface.GetDataT show Text SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Header - Alert Bar show - 0
8. 1.1718076 DBInterface.GetDataT show StoredProcedure Content_LoadPageLinks - 0
9. 1.2186813 DBInterface.GetDataT show Text DECLARE @StartingID INT; SET @StartingID = 0; DECLARE @Tree TABLE(TreeID INT IDENTITY PRIMARY KEY, show - 0.0156253
10. 1.2505716 DBInterface.GetDataT show Text DECLARE @StartingID INT; SET @StartingID = 0; DECLARE @Tree TABLE(TreeID INT IDENTITY PRIMARY KEY, show - 0.0318903
11. 1.2661936 DBInterface.GetDataT show StoredProcedure [dbo].[DefaultSearchAttributeGetByUserID] @g_UserID =c045540e-7b38-4f4a-9f22-0c438c445ac6
0
12. 1.2818177 DBInterface.GetDataT show StoredProcedure [dbo].[CatalogCategoryListForMenus] @SiteID=1
@ShowHidden=False
0
13. 1.2974438 DBInterface.GetDataT show StoredProcedure [dbo].[PageUrlLoadByPrimaryKey] @PageUrl=/exercise/default.aspx
@Type=CATEGORY
0
14. 1.3130682 DBInterface.get_oSQL show StoredProcedure [dbo].[CategoryLoadByPrimaryKey] @CategoryId=101
@SiteID=1
@RootID=0
@UserID=00000000-0000-0000-0000-000000000000
0
15. 1.3130682 DBInterface.GetDataT show StoredProcedure [dbo].[DefaultSearchAttributeGetByUserID] @g_UserID =c045540e-7b38-4f4a-9f22-0c438c445ac6
0
16. 1.3286923 DBInterface.GetDataT show StoredProcedure [dbo].[CategoryListByParentKey] @CategoryID=101
@SiteID=1
@ShowHidden=False
0.0156241
17. 1.4244828 DBInterface.GetDataT show StoredProcedure BreadcrumbByPageUrlByUser @UserId=c045540e-7b38-4f4a-9f22-0c438c445ac6
@SiteID=1
@PageURL=/exercise/default.aspx
0.0156238
18. 1.4401073 DBInterface.GetDataT show StoredProcedure [dbo].[DefaultSearchAttributeGetByUserID] @g_UserID =c045540e-7b38-4f4a-9f22-0c438c445ac6
0
19. 1.4567461 DBInterface.GetDataT show StoredProcedure [dbo].[PageUrlLoadByPrimaryKey] @PageUrl=/exercise/default.aspx
@Type=CATEGORY
0
20. 1.4567461 DBInterface.get_oSQL show StoredProcedure [dbo].[CategoryLoadByPrimaryKey] @CategoryId=101
@SiteID=1
@RootID=0
@UserID=00000000-0000-0000-0000-000000000000
0
21. 1.4567461 DBInterface.GetDataT show StoredProcedure [dbo].[PageUrlLoadByPrimaryKey] @PageUrl=/exercise/default.aspx
@Type=CATEGORY
0
22. 1.4723963 DBInterface.get_oSQL show StoredProcedure [dbo].[CategoryLoadByPrimaryKey] @CategoryId=101
@SiteID=1
@RootID=0
@UserID=00000000-0000-0000-0000-000000000000
0.0156502
23. 1.4723963 DBInterface.GetDataT show StoredProcedure [dbo].[DefaultSearchAttributeGetByUserID] @g_UserID =c045540e-7b38-4f4a-9f22-0c438c445ac6
0
24. 1.680573 DBInterface.GetDataS show StoredProcedure [dbo].[getFilteredProductListWithPaging] @UserID=c045540e-7b38-4f4a-9f22-0c438c445ac6
@PageNumber=1
@PageSize=30
@SortOrder=featured
@SessionID=0z0opki01wnsmdy3etduja15
@SiteID=1
@FilterProductsXML=<filters />
@CategoryId=101
@IncludeSubCategories=0
@MaxProductsToReturn=1000
@AllowMultipleAttributesPerGroup=1
@AllowMultipleExclusionAttributesPerGroup=1
0.1606812
25. 1.6962102 DBInterface.GetDataT show StoredProcedure [dbo].[getProductAttributesList] - 0.0156372
26. 1.7436862 DBInterface.GetDataT show StoredProcedure [dbo].[Cart_LoadByUserID] @UserID=c045540e-7b38-4f4a-9f22-0c438c445ac6
@SiteID=1
0
27. 1.7749477 DBInterface.GetDataT show StoredProcedure BreadcrumbByPageUrlByUser @UserId=c045540e-7b38-4f4a-9f22-0c438c445ac6
@SiteID=1
@PageURL=/exercise/default.aspx
0
Total DB Execution Time 0.3378217
Command Hits
SELECT TOP(1) '0' AS ArticleID, 0 As ID, CASE WHEN Category.MetaTitle='' THEN Category.CategoryName ELSE Category.MetaTitle END As PageTitle, Category.MetaDescription As PageMetaDesc, Category.MetaKeywords As PageMetaKwords, Category.CategoryName As PageHeading, '' As PageContent, '' As PageContent2, '' As PageContent3, '' As PageContent4, '' As PageContent5, '' As PageContent6, '' As StartDate, '' As EndDate, '' As Thumbnail, 0 As NumLatestArticles, 0 As HasArticles, '' As UserControl, 0 As PageLayout FROM PageURLs LEFT OUTER JOIN Category ON PageURLs.EntityID = Category.CategoryID WHERE PageURLs.PageURL = '/exercise/default.aspx' AND PageURLs.Type='category' 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
[dbo].[DefaultSearchAttributeGetByUserID] 4
[dbo].[PageUrlLoadByPrimaryKey] 3
[dbo].[CategoryLoadByPrimaryKey] 3
BreadcrumbByPageUrlByUser 2
Cache Key Cache Value
LeftMenu
  • About Us
  • Become a Rep
  • Contact Us
  • Request a Catalog
  • Request a Quote
  • Videos
  • PageManager_Cache_PageLinks
    TopMenu
  • About Us
  • Become a Rep
  • Contact Us
  • Request a Catalog
  • Request a Quote
  • Videos
  • VirtualSiteProperties-schuremeddev.braveriversolutions.com ECOM.WebForms.BRS.CMS.VirtualSiteProperties
    CategoryMenu_1
    PageManager_Cache_MiscContent System.Collections.Generic.Dictionary`2[System.String,System.String]
    VirtualCatalogInfo-schuremeddev.braveriversolutions.com
    Session Key Session Value
    SubmissionSource -
    SubmissionLandingPage /getcategory.aspx
    AdminLastSitePage /exercise/default.aspx
    UserId c045540e-7b38-4f4a-9f22-0c438c445ac6
    IsDynamicallyGeneratedUserId True
    AdminLastPage /GetCategory.aspx?PageKey=%2fexercise%2fdefault.aspx&unq=3/28/2024 12:57:49 PM
    OrderNumber
    Section Execution Time
    DBInterface.vb 2.5983771
    MasterPage.master 1.6959809
    DeveloperTools.ascx 0.015636
    Load Time:1.948801s  |  Database Hits: 27