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

SchureMed
Innovative Solutions in Advanced Surgical Positioning
×

Developer Tools

Database Activity Repeated Calls Shipping Rates Performance Tracking Cache Storage Session Storage
schuremeddev.braveriversolutions.com
0.6857227 seconds
# Seconds Since First Hit Trace Command Type Command Text Parameters Execution Time
1. 0 DBInterface.GetDataT show StoredProcedure [dbo].[VirtualCatalogLoadBySiteDomain] @SiteDomain=schuremeddev.braveriversolutions.com
0
2. 0 DBInterface.get_oSQL show StoredProcedure [dbo].[VirtualSitePropertiesLoadBySiteID] @SiteID=1
0
3. 0.0641928 DBInterface.GetDataT show Text SELECT TOP(1) '0' AS ArticleID, 0 As ID, CASE WHEN Category.MetaTitle='' THEN Category.CategoryName show - 0.0221416
4. 0.0657192 DBInterface.GetDataT show Text SELECT TOP(1) '0' AS ArticleID, 0 As ID, CASE WHEN Category.MetaTitle='' THEN Category.CategoryName show - 0.0015264
5. 0.0671332 DBInterface.GetDataT show Text SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Header - Alert Bar show - 0.001414
6. 0.082124 DBInterface.GetDataT show Text DECLARE @StartingID INT; SET @StartingID = 0; DECLARE @Tree TABLE(TreeID INT IDENTITY PRIMARY KEY, show - 0.0132799
7. 0.0934523 DBInterface.GetDataT show Text DECLARE @StartingID INT; SET @StartingID = 0; DECLARE @Tree TABLE(TreeID INT IDENTITY PRIMARY KEY, show - 0.0113283
8. 0.0964516 DBInterface.GetDataT show StoredProcedure [dbo].[DefaultSearchAttributeGetByUserID] @g_UserID =10140aed-86d3-489c-a066-4bcd7f68faae
0.0029993
9. 0.1076997 DBInterface.GetDataT show StoredProcedure [dbo].[CatalogCategoryListForMenus] @SiteID=1
@ShowHidden=False
0.0107387
10. 0.1076997 DBInterface.GetDataT show StoredProcedure [dbo].[PageUrlLoadByPrimaryKey] @PageUrl=/medication-carts/default.aspx
@Type=CATEGORY
0
11. 0.1221776 DBInterface.get_oSQL show StoredProcedure [dbo].[CategoryLoadByPrimaryKey] @CategoryId=59
@SiteID=1
@RootID=0
@UserID=00000000-0000-0000-0000-000000000000
0.0144779
12. 0.1221776 DBInterface.GetDataT show StoredProcedure [dbo].[DefaultSearchAttributeGetByUserID] @g_UserID =10140aed-86d3-489c-a066-4bcd7f68faae
0
13. 0.1329255 DBInterface.GetDataT show StoredProcedure [dbo].[CategoryListByParentKey] @CategoryID=59
@SiteID=1
@ShowHidden=False
0.0107479
14. 0.1681994 DBInterface.GetDataT show StoredProcedure BreadcrumbByPageUrlByUser @UserId=10140aed-86d3-489c-a066-4bcd7f68faae
@SiteID=1
@PageURL=/medication-carts/default.aspx
0.0040112
15. 0.1795652 DBInterface.GetDataT show StoredProcedure [dbo].[DefaultSearchAttributeGetByUserID] @g_UserID =10140aed-86d3-489c-a066-4bcd7f68faae
0.0108576
16. 0.1814394 DBInterface.GetDataT show StoredProcedure [dbo].[PageUrlLoadByPrimaryKey] @PageUrl=/medication-carts/default.aspx
@Type=CATEGORY
0.0018742
17. 0.1814394 DBInterface.get_oSQL show StoredProcedure [dbo].[CategoryLoadByPrimaryKey] @CategoryId=59
@SiteID=1
@RootID=0
@UserID=00000000-0000-0000-0000-000000000000
0
18. 0.186759 DBInterface.GetDataT show StoredProcedure [dbo].[PageUrlLoadByPrimaryKey] @PageUrl=/medication-carts/default.aspx
@Type=CATEGORY
0.0053196
19. 0.187714 DBInterface.get_oSQL show StoredProcedure [dbo].[CategoryLoadByPrimaryKey] @CategoryId=59
@SiteID=1
@RootID=0
@UserID=00000000-0000-0000-0000-000000000000
0.000955
20. 0.1927421 DBInterface.GetDataT show StoredProcedure [dbo].[DefaultSearchAttributeGetByUserID] @g_UserID =10140aed-86d3-489c-a066-4bcd7f68faae
0.0045202
21. 0.530558 DBInterface.GetDataS show StoredProcedure [dbo].[getFilteredProductListWithPaging] @UserID=10140aed-86d3-489c-a066-4bcd7f68faae
@PageNumber=1
@PageSize=30
@SortOrder=featured
@SessionID=1rbtotpswc03nsognoq5yanz
@SiteID=1
@FilterProductsXML=<filters />
@CategoryId=59
@IncludeSubCategories=0
@MaxProductsToReturn=1000
@AllowMultipleAttributesPerGroup=1
@AllowMultipleExclusionAttributesPerGroup=1
0.3271883
22. 0.5404078 DBInterface.GetDataT show StoredProcedure [dbo].[getProductAttributesList] - 0.0040476
23. 0.5872912 DBInterface.GetDataT show StoredProcedure [dbo].[Cart_LoadByUserID] @UserID=10140aed-86d3-489c-a066-4bcd7f68faae
@SiteID=1
0.0040866
24. 0.6714122 DBInterface.GetDataT show StoredProcedure BreadcrumbByPageUrlByUser @UserId=10140aed-86d3-489c-a066-4bcd7f68faae
@SiteID=1
@PageURL=/medication-carts/default.aspx
0.0187134
Total DB Execution Time 0.4702277
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 = '/medication-carts/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 /medication-carts/default.aspx
    UserId 10140aed-86d3-489c-a066-4bcd7f68faae
    IsDynamicallyGeneratedUserId True
    AdminLastPage /GetCategory.aspx?PageKey=%2fmedication-carts%2fdefault.aspx&unq=3/29/2024 10:58:33 AM
    OrderNumber
    Section Execution Time
    DBInterface.vb 0
    MasterPage.master 0.629361
    DeveloperTools.ascx 0
    Load Time:0.6857227s  |  Database Hits: 24