401-943-1164 / US & Canada Toll Free: 877-943-1164
×
Load Time:0.8125812s | Database Hits: 27
Developer Tools
Database Activity
Shipping Rates
Performance Tracking
Cache Storage
Session Storage
0.8125812 seconds
| # | 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.0156288 |
| 2. | 0 | DBInterface.GetDataT show | StoredProcedure | [dbo].[DefaultSearchAttributeGetByUserID] | @g_UserID =6c4bb266-638e-45bc-9cbd-4ae143b72851 |
0 |
| 3. | 0.0312483 | DBInterface.GetDataT show | StoredProcedure | [dbo].[PageUrlLoadByPrimaryKey] | @PageUrl=/custom-products/default.aspx @Type=CATEGORY |
0 |
| 4. | 0.0468792 | DBInterface.get_oSQL show | StoredProcedure | [dbo].[CategoryLoadByPrimaryKey] | @CategoryId=220 @SiteID=1 @RootID=0 @UserID=00000000-0000-0000-0000-000000000000 |
0.0156309 |
| 5. | 0.1875102 | DBInterface.GetDataT show | StoredProcedure | dbo.Breadcrumb | @PathList= @SiteID=1 |
0.0156265 |
| 6. | 0.2187668 | DBInterface.GetDataT show | StoredProcedure | [dbo].[DefaultSearchAttributeGetByUserID] | @g_UserID =6c4bb266-638e-45bc-9cbd-4ae143b72851 |
0 |
| 7. | 0.2187668 | DBInterface.GetDataT show | StoredProcedure | [dbo].[PageUrlLoadByPrimaryKey] | @PageUrl=/custom-products/default.aspx @Type=CATEGORY |
0 |
| 8. | 0.2187668 | DBInterface.get_oSQL show | StoredProcedure | [dbo].[CategoryLoadByPrimaryKey] | @CategoryId=220 @SiteID=1 @RootID=0 @UserID=00000000-0000-0000-0000-000000000000 |
0 |
| 9. | 0.2187668 | DBInterface.get_oSQL show | StoredProcedure | [dbo].[ImageLoadByCategoryKey] | @CategoryID=220 |
0 |
| 10. | 0.2500206 | DBInterface.GetDataT show | StoredProcedure | [dbo].[PageUrlLoadByPrimaryKey] | @PageUrl=/custom-products/default.aspx @Type=CATEGORY |
0 |
| 11. | 0.2656551 | DBInterface.get_oSQL show | StoredProcedure | [dbo].[CategoryLoadByPrimaryKey] | @CategoryId=220 @SiteID=1 @RootID=0 @UserID=00000000-0000-0000-0000-000000000000 |
0 |
| 12. | 0.2656551 | DBInterface.GetDataT show | StoredProcedure | [dbo].[DefaultSearchAttributeGetByUserID] | @g_UserID =6c4bb266-638e-45bc-9cbd-4ae143b72851 |
0 |
| 13. | 0.4688102 | DBInterface.GetDataS show | StoredProcedure | [dbo].[getFilteredProductListWithPaging] | @UserID=6c4bb266-638e-45bc-9cbd-4ae143b72851 @PageNumber=1 @PageSize=20 @SortOrder=best @SessionID=snkrmcm2derlaqi3qgf35h5c @SiteID=1 @FilterProductsXML=<filters /> @CategoryId=220 @IncludeSubCategories=0 @MaxProductsToReturn=1000 @AllowMultipleAttributesPerGroup=1 @AllowMultipleExclusionAttributesPerGroup=1 |
0.1719107 |
| 14. | 0.5156874 | DBInterface.GetDataT show | StoredProcedure | [dbo].[getProductAttributesList] | - | 0.0312381 |
| 15. | 0.5781888 | DBInterface.GetDataT show | StoredProcedure | PressReleaseSearch | @CategoryID=220 @PageNum=1 @PageSize=12 @SiteID=1 @GetExpired=0 |
0 |
| 16. | 0.6563164 | DBInterface.GetDataT show | StoredProcedure | [dbo].[Cart_LoadByUserID] | @UserID=6c4bb266-638e-45bc-9cbd-4ae143b72851 @SiteID=1 |
0 |
| 17. | 0.6563164 | DBInterface.GetDataT show | StoredProcedure | [dbo].[DocumentLoadByProductKey] | @ProductID=2300 |
0 |
| 18. | 0.6719369 | DBInterface.GetDataT show | StoredProcedure | [dbo].[DocumentLoadByProductKey] | @ProductID=2307 |
0 |
| 19. | 0.6875617 | DBInterface.GetDataT show | StoredProcedure | [dbo].[DocumentLoadByProductKey] | @ProductID=2301 |
0 |
| 20. | 0.6875617 | DBInterface.GetDataT show | StoredProcedure | [dbo].[DocumentLoadByProductKey] | @ProductID=2302 |
0 |
| 21. | 0.7031919 | DBInterface.GetDataT show | StoredProcedure | [dbo].[DocumentLoadByProductKey] | @ProductID=2303 |
0 |
| 22. | 0.7031919 | DBInterface.GetDataT show | StoredProcedure | [dbo].[DocumentLoadByProductKey] | @ProductID=2308 |
0 |
| 23. | 0.7031919 | DBInterface.GetDataT show | StoredProcedure | [dbo].[DocumentLoadByProductKey] | @ProductID=2304 |
0 |
| 24. | 0.7031919 | DBInterface.GetDataT show | StoredProcedure | [dbo].[DocumentLoadByProductKey] | @ProductID=2309 |
0 |
| 25. | 0.7344464 | DBInterface.GetDataT show | StoredProcedure | [dbo].[DocumentLoadByProductKey] | @ProductID=2310 |
0.0156368 |
| 26. | 0.7656987 | DBInterface.GetDataT show | StoredProcedure | [dbo].[DocumentLoadByProductKey] | @ProductID=2306 |
0.0156328 |
| 27. | 0.7656987 | DBInterface.GetDataT show | StoredProcedure | dbo.Breadcrumb | @PathList= @SiteID=1 |
0 |
| Total DB Execution Time | 0.2813046 |
| Cache Key | Cache Value |
|---|---|
| LeftMenu |
|
| PageManager_Cache_PageLinks | |
| TopMenu |
|
| VirtualSiteProperties-brscommercedev.braveriversolutions.com | E_Com_Web_App.BRS.CMS.VirtualSiteProperties |
| CategoryMenu_1 | |
| VirtualCatalogInfo-brscommercedev.braveriversolutions.com | |
| PageManager_Cache_MiscContent | System.Collections.Generic.Dictionary`2[System.String,System.String] |
| Session Key | Session Value |
|---|---|
| UserId | 6c4bb266-638e-45bc-9cbd-4ae143b72851 |
| IsDynamicallyGeneratedUserId | True |
| AdminLastSitePage | /custom-products/default.aspx |
| AdminLastPage | /GetCategory.aspx?PageKey=%2fcustom-products%2fdefault.aspx&unq=4/3/2025 2:21:43 AM |
| OrderNumber |
| Section | Execution Time |
|---|---|
| DBInterface.vb | 0 |
| MasterPage.master | 0.7813275 |
| DeveloperTools.ascx | 0 |