# | Seconds Since First Hit | Trace | Command Type | Command Text | Parameters | Execution Time |
---|---|---|---|---|---|---|
1. | 0 | DBInterface.GetDataTable; SiteSettings.LoadConfigurationData; SiteSettings.get_Config; Url..ctor; show | StoredProcedure | SiteSettings_Load | - | 0 |
2. | 0.0312564 | DBInterface.GetDataTable; VirtualCatalogInfo.LoadVirtualCatalog; VirtualCatalogInfo..ctor; Common.GetSiteID; show | StoredProcedure | [dbo].[VirtualCatalogLoadBySiteDomain] | @SiteDomain=brscommercedev.braveriversolutions.com |
0 |
3. | 0.0312564 | DBInterface.get_oSQLDataReader; VirtualSiteProperties.GetVirtualSiteProperties; VirtualSiteProperties..ctor; VirtualCatalogInfo.LoadVirtualCatalog; show | StoredProcedure | [dbo].[VirtualSitePropertiesLoadBySiteID] | @SiteID=1 |
0 |
4. | 0.3125554 | DBInterface.GetDataTable; PageManager.LoadMiscContent; PageManager.get_MiscContent; MasterPage.Page_Load; show | StoredProcedure | Content_LoadMiscContent | - | 0 |
5. | 0.3281735 | DBInterface.GetDataTable; HTMLContent.GetHTMLContent; HTMLContent..ctor; MasterPage.get_HtmlContent; show | Text | SELECT TOP(1) '0' AS ArticleID, 0 As ID, Product.MetaTitle As PageTitle, Product.MetaDescription As PageMetaDesc, Product.MetaKeywords As PageMetaKwords, Product.Title 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 Product ON PageURLs.EntityID = Product.ProductID WHERE PageURLs.PageURL = '/custom-daq-custom-data-acquisition-boards.html' AND PageURLs.Type='product' show | - | 0.0156181 |
6. | 0.3281735 | DBInterface.GetDataTable; PageManager.LoadPageLinks; PageManager.get_PageLinks; HTMLContent.GetHTMLHeaderLinks; show | StoredProcedure | Content_LoadPageLinks | - | 0 |
7. | 0.3437864 | DBInterface.GetDataTable; BaseUser.GetDefaultSearch; UserSession.get_DefaultSearchAttribute; PageManager.get_CategoryMenu; show | StoredProcedure | [dbo].[DefaultSearchAttributeGetByUserID] | @g_UserID =e94faf80-1766-434f-89ff-b2876f0d00ad |
0 |
8. | 0.3437864 | DBInterface.GetDataTable; CatalogCategoryMenu.LoadCategoryByParentCategory; CatalogCategoryMenu..ctor; PageManager.get_CategoryMenu; show | StoredProcedure | [dbo].[CatalogCategoryListForMenus] | @SiteID=1 @ShowHidden=False |
0 |
9. | 0.4375628 | DBInterface.GetDataTable; Menu.GetMenuContent; Menu.get_MenuContent; MasterPage.Page_Load; show | Text | 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] ; show | - | 0.062522 |
10. | 0.5000664 | DBInterface.GetDataTable; Menu.GetMenuContent; Menu.get_MenuContent; MasterPage.Page_Load; show | Text | 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] ; show | - | 0.0625036 |
11. | 0.5469228 | DBInterface.get_oSQLDataReader; RecentlyViewedProducts.LoadRecentProductsByProductID; RecentlyViewedProducts..ctor; ProductDetail.LoadProductDetails; show | StoredProcedure | [dbo].[RecentlyViewedListLoadByEntityType] | @UserID=e94faf80-1766-434f-89ff-b2876f0d00ad @EntityType=product @RowCount=5 @SiteID=1 |
0.0156158 |
12. | 0.5469228 | DBInterface.GetDataTable; ProductDeprecated.LoadProductFromURL; ProductDeprecated..ctor; ProductDetail.LoadProductDetails; show | StoredProcedure | [dbo].[PageUrlLoadByPrimaryKey] | @PageUrl=/custom-daq-custom-data-acquisition-boards.html @Type=PRODUCT |
0 |
13. | 0.562572 | DBInterface.get_oSQLDataReader; ProductDeprecated._FETCH; ProductDeprecated.LoadProductFromURL; ProductDeprecated..ctor; show | StoredProcedure | [dbo].[ProductLoadByPrimaryKey] | @ProductID=2301 @SiteID=1 @UserID=e94faf80-1766-434f-89ff-b2876f0d00ad |
0.0156492 |
14. | 0.562572 | DBInterface.GetDataTable; Categories.LoadCategoryByProductId; Categories..ctor; ProductDeprecated..ctor; show | StoredProcedure | [dbo].[CategoryListByProductId] | @ProductId=2301 @SiteID=1 @ShowHidden=False |
0 |
15. | 0.5781793 | DBInterface.GetDataTable; Category.LoadCategoryFromURL; Category..ctor; ProductDetail.LoadProductDetails; show | StoredProcedure | [dbo].[PageUrlLoadByPrimaryKey] | @Type=CATEGORY |
0 |
16. | 0.5781793 | DBInterface.GetDataTable; ProductDetail.LoadProductDetails; ProductDetail.Page_Load; Control.OnLoad; show | StoredProcedure | [dbo].[DocumentLoadByProductKey] | @ProductID=2301 |
0 |
17. | 0.5781793 | DBInterface.get_oSQLDataReader; StoreImages.LoadImagesByProductKey; StoreImages..ctor; ProductDeprecated.get_Images; show | StoredProcedure | [dbo].[ImageLoadByProductKey] | @ProductID=2301 |
0 |
18. | 0.6719573 | DBInterface.get_oSQLDataReader; Related_Products.LoadRelatedProductsByProductID; Related_Products..ctor; ProductDeprecated.get_RelatedProducts; show | StoredProcedure | [dbo].[ProductRelationshipListByProductID] | @ProductID=2301 @SiteID=1 |
0 |
19. | 0.6875764 | DBInterface.get_oSQLDataReader; Related_Products.LoadRelatedProductsByProductID; Related_Products..ctor; ProductDeprecated.get_RelatedProducts; show | StoredProcedure | [dbo].[ProductRelationshipListByProductID] | @ProductID=2301 @SiteID=1 |
0.0156191 |
20. | 0.6875764 | DBInterface.GetDataTable; ProductDetail.Repeater_RelatedProducts_ItemDataBound; Repeater.OnItemDataBound; Repeater.CreateItem; show | StoredProcedure | [dbo].[Pricing_OutputPricing] | @ItemCode=304328 |
0 |
21. | 0.6875764 | DBInterface.get_oSQLDataReader; Related_Products.LoadRelatedProductsByProductID; Related_Products..ctor; ProductDeprecated.get_RelatedProducts; show | StoredProcedure | [dbo].[ProductRelationshipListByProductID] | @ProductID=2301 @SiteID=1 |
0 |
22. | 0.7031874 | DBInterface.get_oSQLDataReader; Related_Products.LoadBoughtProducts; Related_Products..ctor; ProductDetail.LoadProductDetails; show | StoredProcedure | [dbo].[CL_procGetOtherProductsBought] | @ProductID=2301 @SiteID=1 |
0 |
23. | 0.7031874 | DBInterface.get_oSQLDataReader; Accessories.LoadAccessoriesByProductKey; Accessories..ctor; ProductDeprecated.get_Accessories; show | StoredProcedure | [dbo].[AccessoryListLoadByProductKey] | @ProductID=2301 @ShowHidden=0 |
0 |
24. | 0.7031874 | DBInterface.get_oSQLDataReader; Skus.LoadSkusByCategory; Skus..ctor; ProductDeprecated.get_Skus; show | StoredProcedure | [dbo].[SKUListLoadByProductKey] | @ProductID=2301 @SiteID=1 @UserID=e94faf80-1766-434f-89ff-b2876f0d00ad @ShowHidden=0 |
0 |
25. | 0.7344371 | DBInterface.get_oSQLDataReader; Skus.LoadSkuPricing; Skus.LoadSkusByCategory; Skus..ctor; show | StoredProcedure | [dbo].[PriceListBySkuId] | @SkuList=2302 @UserID=e94faf80-1766-434f-89ff-b2876f0d00ad @SiteID=1 |
0 |
26. | 0.7344371 | DBInterface.GetDataTable; BaseUser.GetDefaultSearch; UserSession.get_DefaultSearchAttribute; ProductDetail.LoadProductDetails; show | StoredProcedure | [dbo].[DefaultSearchAttributeGetByUserID] | @g_UserID =e94faf80-1766-434f-89ff-b2876f0d00ad |
0 |
27. | 0.7500645 | DBInterface.GetDataTable; ProductAttributes.LoadProductAttributes; ProductAttributes..ctor; Sku.get_Attributes; show | StoredProcedure | [dbo].[getProductAttributesBySkuId] | @SkuId=2302 |
0.0156274 |
28. | 0.7500645 | DBInterface.GetDataTable; ProductAttributes.LoadProductAttributes; ProductAttributes..ctor; ProductDeprecated.get_Attributes; show | StoredProcedure | [dbo].[getProductAttributesByProductId] | @ProductId=2301 |
0 |
29. | 0.7500645 | DBInterface.GetDataTable; ProductDeprecated.GetDistinctSKUAttributes; ProductDeprecated.get_DistinctSkuAttributes; ProductDetail.LoadProductDetails; show | StoredProcedure | [dbo].[AttributesDistinctByProductID] | @ProductId=2301 |
0 |
30. | 0.765698 | DBInterface.GetDataTable; RegionLists.CountryListALL; ProductDetail.LoadDropDowns; ProductDetail.LoadProductDetails; show | StoredProcedure | [dbo].[procGetAllCountryList] | - | 0 |
31. | 0.765698 | DBInterface.GetDataTable; RegionLists.StatesByCountryList; ProductDetail.UpdateStates; ProductDetail.LoadDropDowns; show | StoredProcedure | [dbo].[procGetCountryStatesList] | @CountryCode=USA |
0 |
32. | 0.7969428 | DBInterface.GetDataTable; ProductDeprecated.LoadProductFromURL; ProductDeprecated..ctor; QuickViewProductDetail.LoadProductDetails; show | StoredProcedure | [dbo].[PageUrlLoadByPrimaryKey] | @PageUrl=/custom-daq-custom-data-acquisition-boards.html @Type=PRODUCT |
0 |
33. | 0.8126247 | DBInterface.get_oSQLDataReader; ProductDeprecated._FETCH; ProductDeprecated.LoadProductFromURL; ProductDeprecated..ctor; show | StoredProcedure | [dbo].[ProductLoadByPrimaryKey] | @ProductID=2301 @SiteID=1 @UserID=e94faf80-1766-434f-89ff-b2876f0d00ad |
0.0156819 |
34. | 0.8282323 | DBInterface.GetDataTable; Categories.LoadCategoryByProductId; Categories..ctor; ProductDeprecated..ctor; show | StoredProcedure | [dbo].[CategoryListByProductId] | @ProductId=2301 @SiteID=1 @ShowHidden=False |
0.0156076 |
35. | 0.8282323 | DBInterface.GetDataTable; Category.LoadCategoryFromURL; Category..ctor; QuickViewProductDetail.LoadProductDetails; show | StoredProcedure | [dbo].[PageUrlLoadByPrimaryKey] | @Type=CATEGORY |
0 |
36. | 0.8282323 | DBInterface.get_oSQLDataReader; Skus.LoadSkusByCategory; Skus..ctor; ProductDeprecated.get_Skus; show | StoredProcedure | [dbo].[SKUListLoadByProductKey] | @ProductID=2301 @SiteID=1 @UserID=e94faf80-1766-434f-89ff-b2876f0d00ad @ShowHidden=0 |
0 |
37. | 0.8282323 | DBInterface.GetDataTable; ProductAttributes.LoadProductAttributes; ProductAttributes..ctor; Sku.get_Attributes; show | StoredProcedure | [dbo].[getProductAttributesBySkuId] | @SkuId=2302 |
0 |
38. | 0.8282323 | DBInterface.GetDataTable; QuickViewProductDetail.LoadProductDetails; QuickViewProductDetail.Page_Load; Control.OnLoad; show | StoredProcedure | [dbo].[DocumentLoadByProductKey] | @ProductID=2301 |
0 |
39. | 0.8282323 | DBInterface.get_oSQLDataReader; StoreImages.LoadImagesByProductKey; StoreImages..ctor; ProductDeprecated.get_Images; show | StoredProcedure | [dbo].[ImageLoadByProductKey] | @ProductID=2301 |
0 |
40. | 0.8282323 | DBInterface.get_oSQLDataReader; Related_Products.LoadRelatedProductsByProductID; Related_Products..ctor; ProductDeprecated.get_RelatedProducts; show | StoredProcedure | [dbo].[ProductRelationshipListByProductID] | @ProductID=2301 @SiteID=1 |
0 |
41. | 0.8438228 | DBInterface.get_oSQLDataReader; Related_Products.LoadRelatedProductsByProductID; Related_Products..ctor; ProductDeprecated.get_RelatedProducts; show | StoredProcedure | [dbo].[ProductRelationshipListByProductID] | @ProductID=2301 @SiteID=1 |
0 |
42. | 0.8438228 | DBInterface.get_oSQLDataReader; Skus.LoadSkusByCategory; Skus..ctor; ProductDeprecated.get_Skus; show | StoredProcedure | [dbo].[SKUListLoadByProductKey] | @ProductID=2301 @SiteID=1 @UserID=e94faf80-1766-434f-89ff-b2876f0d00ad @ShowHidden=0 |
0 |
43. | 0.8594488 | DBInterface.get_oSQLDataReader; Skus.LoadSkuPricing; Skus.LoadSkusByCategory; Skus..ctor; show | StoredProcedure | [dbo].[PriceListBySkuId] | @SkuList=2302 @UserID=e94faf80-1766-434f-89ff-b2876f0d00ad @SiteID=1 |
0 |
44. | 0.8594488 | DBInterface.GetDataTable; BaseUser.GetDefaultSearch; UserSession.get_DefaultSearchAttribute; QuickViewProductDetail.LoadProductDetails; show | StoredProcedure | [dbo].[DefaultSearchAttributeGetByUserID] | @g_UserID =e94faf80-1766-434f-89ff-b2876f0d00ad |
0 |
45. | 0.8594488 | DBInterface.GetDataTable; ProductAttributes.LoadProductAttributes; ProductAttributes..ctor; Sku.get_Attributes; show | StoredProcedure | [dbo].[getProductAttributesBySkuId] | @SkuId=2302 |
0 |
46. | 0.8594488 | DBInterface.GetDataTable; ProductAttributes.LoadProductAttributes; ProductAttributes..ctor; ProductDeprecated.get_Attributes; show | StoredProcedure | [dbo].[getProductAttributesByProductId] | @ProductId=2301 |
0 |
47. | 0.8594488 | DBInterface.GetDataTable; ProductDeprecated.GetDistinctSKUAttributes; ProductDeprecated.get_DistinctSkuAttributes; QuickViewProductDetail.LoadProductDetails; show | StoredProcedure | [dbo].[AttributesDistinctByProductID] | @ProductId=2301 |
0 |
48. | 0.9688324 | DBInterface.GetDataTable; CartManager.LoadCartItems; CartManager.get_CartItems; MasterPage.UpdateCartTotals; show | StoredProcedure | [dbo].[Cart_LoadByUserID] | @UserID=e94faf80-1766-434f-89ff-b2876f0d00ad @SiteID=1 |
0 |
Total DB Execution Time | 0.2344447 |
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 | e94faf80-1766-434f-89ff-b2876f0d00ad |
IsDynamicallyGeneratedUserId | True |
AdminLastSitePage | /custom-daq-custom-data-acquisition-boards.html |
AdminLastPage | /GetProduct.aspx?PageKey=%2fcustom-daq-custom-data-acquisition-boards.html&unq=4/4/2025 5:59:30 AM |
OrderNumber |
Section | Execution Time |
---|---|
DBInterface.vb | 2.4377184 |
MasterPage.master | 0.8750656 |
DeveloperTools.ascx | 0.0156237 |
Shipments are made via UPS Ground, unless otherwise specified. Freight charges are prepaid and added to your invoice. We can estimate the freight costs for you.
We can ship freight collect on your account, just provide your UPS Account Number.
We can also ship via the carrier of your choice. Provide the details and your account number.
Products shall be shipped F.O.B. Electro Standards' facility. Title to and risk of loss or damage to the products shall pass to you upon Electro Standards delivery of the products to a carrier for shipment. Title to software will remain with the applicable licensor. Electro Standards' prices do not include shipping and handling charges. Electro Standards reserves the right to use its own discretion in the manner and routing of shipments. Electro Standards shall be permitted to deliver products in separate lots.