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

SchureMed
Innovative Solutions in Advanced Surgical Positioning

Oasis Gel Positioning Pads

×

Developer Tools

Database Activity Repeated Calls Shipping Rates Performance Tracking Cache Storage Session Storage
schuremeddev.braveriversolutions.com
1.3996884 seconds
# Seconds Since First Hit Trace Command Type Command Text Parameters Execution Time
1. 0 DBInterface.GetDataT show StoredProcedure SiteSettings_Load - 0.0162388
2. 0.015637 DBInterface.GetDataT show StoredProcedure [dbo].[VirtualCatalogLoadBySiteDomain] @SiteDomain=schuremeddev.braveriversolutions.com
0
3. 0.015637 DBInterface.get_oSQL show StoredProcedure [dbo].[VirtualSitePropertiesLoadBySiteID] @SiteID=1
0
4. 0.5159697 DBInterface.GetDataT show Text SELECT TOP(1) '0' AS ArticleID, 0 As ID, CASE WHEN Category.MetaTitle='' THEN Category.CategoryName show - 0.0156357
5. 0.5159697 DBInterface.GetDataT show StoredProcedure Content_LoadMiscContent - 0
6. 0.5316093 DBInterface.GetDataT show Text SELECT TOP(1) '0' AS ArticleID, 0 As ID, CASE WHEN Category.MetaTitle='' THEN Category.CategoryName show - 0.0156396
7. 0.5316093 DBInterface.GetDataT show Text SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Header - Alert Bar show - 0
8. 0.5472212 DBInterface.GetDataT show StoredProcedure Content_LoadPageLinks - 0
9. 0.5628463 DBInterface.GetDataT show Text DECLARE @StartingID INT; SET @StartingID = 0; DECLARE @Tree TABLE(TreeID INT IDENTITY PRIMARY KEY, show - 0.0156251
10. 0.5784857 DBInterface.GetDataT show Text DECLARE @StartingID INT; SET @StartingID = 0; DECLARE @Tree TABLE(TreeID INT IDENTITY PRIMARY KEY, show - 0.0156394
11. 0.5940974 DBInterface.GetDataT show StoredProcedure [dbo].[DefaultSearchAttributeGetByUserID] @g_UserID =11b54963-547a-4cde-9576-b9fa27b5a1a2
0
12. 0.6571964 DBInterface.GetDataT show StoredProcedure [dbo].[CatalogCategoryListForMenus] @SiteID=1
@ShowHidden=False
0.063099
13. 0.6571964 DBInterface.GetDataT show StoredProcedure [dbo].[PageUrlLoadByPrimaryKey] @PageUrl=/oasis-gel-positioning-pads/default.aspx
@Type=CATEGORY
0
14. 0.6728217 DBInterface.get_oSQL show StoredProcedure [dbo].[CategoryLoadByPrimaryKey] @CategoryId=34
@SiteID=1
@RootID=0
@UserID=00000000-0000-0000-0000-000000000000
0.0156253
15. 0.6728217 DBInterface.GetDataT show StoredProcedure [dbo].[DefaultSearchAttributeGetByUserID] @g_UserID =11b54963-547a-4cde-9576-b9fa27b5a1a2
0
16. 0.7046349 DBInterface.GetDataT show StoredProcedure [dbo].[CategoryListByParentKey] @CategoryID=34
@SiteID=1
@ShowHidden=False
0.0318132
17. 0.7366004 DBInterface.GetDataT show StoredProcedure BreadcrumbByPageUrlByUser @UserId=11b54963-547a-4cde-9576-b9fa27b5a1a2
@SiteID=1
@PageURL=/oasis-gel-positioning-pads/default.aspx
0
18. 0.7522279 DBInterface.GetDataT show StoredProcedure [dbo].[DefaultSearchAttributeGetByUserID] @g_UserID =11b54963-547a-4cde-9576-b9fa27b5a1a2
0
19. 0.7522279 DBInterface.GetDataT show StoredProcedure [dbo].[PageUrlLoadByPrimaryKey] @PageUrl=/oasis-gel-positioning-pads/default.aspx
@Type=CATEGORY
0
20. 0.7522279 DBInterface.get_oSQL show StoredProcedure [dbo].[CategoryLoadByPrimaryKey] @CategoryId=34
@SiteID=1
@RootID=0
@UserID=00000000-0000-0000-0000-000000000000
0
21. 0.7678527 DBInterface.GetDataT show StoredProcedure [dbo].[PageUrlLoadByPrimaryKey] @PageUrl=/oasis-gel-positioning-pads/default.aspx
@Type=CATEGORY
0
22. 0.7678527 DBInterface.get_oSQL show StoredProcedure [dbo].[CategoryLoadByPrimaryKey] @CategoryId=34
@SiteID=1
@RootID=0
@UserID=00000000-0000-0000-0000-000000000000
0
23. 0.7678527 DBInterface.GetDataT show StoredProcedure [dbo].[DefaultSearchAttributeGetByUserID] @g_UserID =11b54963-547a-4cde-9576-b9fa27b5a1a2
0
24. 1.1774413 DBInterface.GetDataS show StoredProcedure [dbo].[getFilteredProductListWithPaging] @UserID=11b54963-547a-4cde-9576-b9fa27b5a1a2
@PageNumber=1
@PageSize=30
@SortOrder=featured
@SessionID=0ekpswb15paeeor4elwbw5qq
@SiteID=1
@FilterProductsXML=<filters />
@CategoryId=34
@IncludeSubCategories=0
@MaxProductsToReturn=1000
@AllowMultipleAttributesPerGroup=1
@AllowMultipleExclusionAttributesPerGroup=1
0.3939635
25. 1.193285 DBInterface.GetDataT show StoredProcedure [dbo].[getProductAttributesList] - 0.0158437
26. 1.2098107 DBInterface.GetDataT show StoredProcedure [dbo].[Cart_LoadByUserID] @UserID=11b54963-547a-4cde-9576-b9fa27b5a1a2
@SiteID=1
0
27. 1.2410607 DBInterface.GetDataT show StoredProcedure BreadcrumbByPageUrlByUser @UserId=11b54963-547a-4cde-9576-b9fa27b5a1a2
@SiteID=1
@PageURL=/oasis-gel-positioning-pads/default.aspx
0
Total DB Execution Time 0.5991233
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 = '/oasis-gel-positioning-pads/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 /oasis-gel-positioning-pads/default.aspx
    UserId 11b54963-547a-4cde-9576-b9fa27b5a1a2
    IsDynamicallyGeneratedUserId True
    AdminLastPage /GetCategory.aspx?PageKey=%2foasis-gel-positioning-pads%2fdefault.aspx&unq=3/29/2024 4:24:02 AM
    OrderNumber
    Section Execution Time
    DBInterface.vb 1.567137
    MasterPage.master 1.1779715
    DeveloperTools.ascx 0.0162024
    Load Time:1.3996884s  |  Database Hits: 27