| # | Seconds Since First Hit | Trace | Command Type | Command Text | Parameters | Execution Time |
|---|---|---|---|---|---|---|
| 1. | 0 | DBInterface.GetDataT show | Text | SELECT TOP(1) '0' AS ArticleID, 0 As ID, CASE WHEN Category.MetaTitle='' THEN Category.PageTitle ELS show | - | 0.0847446 |
| 2. | 0 | DBInterface.GetDataT show | StoredProcedure | [dbo].[DefaultSearchAttributeGetByUserID] | @g_UserID =e8ae6100-beba-4753-b468-29d236aae9f7 |
0 |
| 3. | 0.0624723 | DBInterface.GetDataT show | StoredProcedure | [dbo].[PageUrlLoadByPrimaryKey] | @PageUrl=/network-switches/default.aspx @Type=CATEGORY |
0 |
| 4. | 0.0624723 | DBInterface.get_oSQL show | StoredProcedure | [dbo].[CategoryLoadByPrimaryKey] | @CategoryId=209 @SiteID=1 @RootID=0 @UserID=00000000-0000-0000-0000-000000000000 |
0 |
| 5. | 0.0781098 | DBInterface.GetDataT show | StoredProcedure | dbo.Breadcrumb | @PathList= @SiteID=1 |
0.0156375 |
| 6. | 0.0781098 | DBInterface.GetDataT show | StoredProcedure | [dbo].[DefaultSearchAttributeGetByUserID] | @g_UserID =e8ae6100-beba-4753-b468-29d236aae9f7 |
0 |
| 7. | 0.0781098 | DBInterface.GetDataT show | StoredProcedure | [dbo].[PageUrlLoadByPrimaryKey] | @PageUrl=/network-switches/default.aspx @Type=CATEGORY |
0 |
| 8. | 0.0781098 | DBInterface.get_oSQL show | StoredProcedure | [dbo].[CategoryLoadByPrimaryKey] | @CategoryId=209 @SiteID=1 @RootID=0 @UserID=00000000-0000-0000-0000-000000000000 |
0 |
| 9. | 0.0846245 | DBInterface.get_oSQL show | StoredProcedure | [dbo].[ImageLoadByCategoryKey] | @CategoryID=209 |
0 |
| 10. | 0.1002835 | DBInterface.GetDataT show | StoredProcedure | [dbo].[PageUrlLoadByPrimaryKey] | @PageUrl=/network-switches/default.aspx @Type=CATEGORY |
0 |
| 11. | 0.1002835 | DBInterface.get_oSQL show | StoredProcedure | [dbo].[CategoryLoadByPrimaryKey] | @CategoryId=209 @SiteID=1 @RootID=0 @UserID=00000000-0000-0000-0000-000000000000 |
0 |
| 12. | 0.1002835 | DBInterface.GetDataT show | StoredProcedure | [dbo].[DefaultSearchAttributeGetByUserID] | @g_UserID =e8ae6100-beba-4753-b468-29d236aae9f7 |
0 |
| 13. | 2.1566964 | DBInterface.GetDataS show | StoredProcedure | [dbo].[getFilteredProductListWithPaging] | @UserID=e8ae6100-beba-4753-b468-29d236aae9f7 @PageNumber=1 @PageSize=20 @SortOrder=best @SessionID=3oodldece0fnczwfd4dpnqog @SiteID=1 @FilterProductsXML=<filters /> @CategoryId=209 @IncludeSubCategories=0 @MaxProductsToReturn=1000 @AllowMultipleAttributesPerGroup=1 @AllowMultipleExclusionAttributesPerGroup=1 |
2.0408095 |
| 14. | 2.1723229 | DBInterface.GetDataT show | StoredProcedure | [dbo].[getProductAttributesList] | - | 0.0156265 |
| 15. | 2.1879453 | DBInterface.GetDataT show | StoredProcedure | PressReleaseSearch | @CategoryID=209 @PageNum=1 @PageSize=12 @SiteID=1 @GetExpired=0 |
0.0156224 |
| 16. | 2.1944613 | DBInterface.GetDataT show | StoredProcedure | [dbo].[Cart_LoadByUserID] | @UserID=e8ae6100-beba-4753-b468-29d236aae9f7 @SiteID=1 |
0 |
| 17. | 2.1944613 | DBInterface.GetDataT show | StoredProcedure | [dbo].[DocumentLoadByProductKey] | @ProductID=39 |
0 |
| 18. | 2.2101104 | DBInterface.GetDataT show | StoredProcedure | [dbo].[DocumentLoadByProductKey] | @ProductID=178 |
0 |
| 19. | 2.2101104 | DBInterface.GetDataT show | StoredProcedure | [dbo].[DocumentLoadByProductKey] | @ProductID=180 |
0 |
| 20. | 2.2413712 | DBInterface.GetDataT show | StoredProcedure | [dbo].[DocumentLoadByProductKey] | @ProductID=649 |
0 |
| 21. | 2.2570087 | DBInterface.GetDataT show | StoredProcedure | [dbo].[DocumentLoadByProductKey] | @ProductID=2298 |
0.0156375 |
| 22. | 2.2570087 | DBInterface.GetDataT show | StoredProcedure | [dbo].[DocumentLoadByProductKey] | @ProductID=34 |
0 |
| 23. | 2.288326 | DBInterface.GetDataT show | StoredProcedure | [dbo].[DocumentLoadByProductKey] | @ProductID=35 |
0 |
| 24. | 2.2948521 | DBInterface.GetDataT show | StoredProcedure | [dbo].[DocumentLoadByProductKey] | @ProductID=36 |
0.0065261 |
| 25. | 2.2948521 | DBInterface.GetDataT show | StoredProcedure | [dbo].[DocumentLoadByProductKey] | @ProductID=40 |
0 |
| 26. | 2.3105168 | DBInterface.GetDataT show | StoredProcedure | [dbo].[DocumentLoadByProductKey] | @ProductID=42 |
0.0156647 |
| 27. | 2.3105168 | DBInterface.GetDataT show | StoredProcedure | [dbo].[DocumentLoadByProductKey] | @ProductID=45 |
0 |
| 28. | 2.3105168 | DBInterface.GetDataT show | StoredProcedure | [dbo].[DocumentLoadByProductKey] | @ProductID=46 |
0 |
| 29. | 2.3261592 | DBInterface.GetDataT show | StoredProcedure | [dbo].[DocumentLoadByProductKey] | @ProductID=48 |
0 |
| 30. | 2.3261592 | DBInterface.GetDataT show | StoredProcedure | [dbo].[DocumentLoadByProductKey] | @ProductID=49 |
0 |
| 31. | 2.341786 | DBInterface.GetDataT show | StoredProcedure | [dbo].[DocumentLoadByProductKey] | @ProductID=50 |
0 |
| 32. | 2.3575679 | DBInterface.GetDataT show | StoredProcedure | [dbo].[DocumentLoadByProductKey] | @ProductID=51 |
0 |
| 33. | 2.3730292 | DBInterface.GetDataT show | StoredProcedure | [dbo].[DocumentLoadByProductKey] | @ProductID=52 |
0 |
| 34. | 2.3952023 | DBInterface.GetDataT show | StoredProcedure | [dbo].[DocumentLoadByProductKey] | @ProductID=53 |
0 |
| 35. | 2.3952023 | DBInterface.GetDataT show | StoredProcedure | [dbo].[DocumentLoadByProductKey] | @ProductID=54 |
0 |
| 36. | 2.4108729 | DBInterface.GetDataT show | StoredProcedure | [dbo].[DocumentLoadByProductKey] | @ProductID=55 |
0 |
| 37. | 2.4108729 | DBInterface.GetDataT show | StoredProcedure | dbo.Breadcrumb | @PathList= @SiteID=1 |
0 |
| Total DB Execution Time | 2.2102688 |
| Cache Key | Cache Value |
|---|---|
| LeftMenu |
|
| PageManager_Cache_PageLinks | |
| TopMenu |
|
| VirtualSiteProperties-brscommercedev.braveriversolutions.com | E_Com_Web_App.BRS.CMS.VirtualSiteProperties |
| PageManager_Cache_MiscContent | System.Collections.Generic.Dictionary`2[System.String,System.String] |
| VirtualCatalogInfo-brscommercedev.braveriversolutions.com | |
| CategoryMenu_1 |
| Session Key | Session Value |
|---|---|
| UserId | e8ae6100-beba-4753-b468-29d236aae9f7 |
| IsDynamicallyGeneratedUserId | True |
| AdminLastSitePage | /network-switches/default.aspx |
| AdminLastPage | /GetCategory.aspx?PageKey=%2fnetwork-switches%2fdefault.aspx&unq=8/7/2026 1:14:33 AM |
| OrderNumber |
| Section | Execution Time |
|---|---|
| DBInterface.vb | 0 |
| MasterPage.master | 2.4956175 |
| DeveloperTools.ascx | 0 |