# |
Seconds Since First Hit |
Trace |
Command Type |
Command Text |
Parameters |
Execution Time |
1. |
0 |
DBInterface.GetDataTable; VirtualCatalogInfo.LoadVirtualCatalog; VirtualCatalogInfo..ctor; Common.GetSiteID; show |
StoredProcedure |
[dbo].[VirtualCatalogLoadBySiteDomain] |
@SiteDomain=brscommercedev.braveriversolutions.com
|
0 |
2. |
0.0156224 |
DBInterface.get_oSQLDataReader; VirtualSiteProperties.GetVirtualSiteProperties; VirtualSiteProperties..ctor; VirtualCatalogInfo.LoadVirtualCatalog; show |
StoredProcedure |
[dbo].[VirtualSitePropertiesLoadBySiteID] |
@SiteID=1
|
0.0156224 |
3. |
0.1874858 |
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 = '/starter-pack-deluxe.html' AND PageURLs.Type='product' show |
- |
0.0156303 |
4. |
0.2343614 |
DBInterface.GetDataTable; BaseUser.GetDefaultSearch; UserSession.get_DefaultSearchAttribute; PageManager.get_CategoryMenu; show |
StoredProcedure |
[dbo].[DefaultSearchAttributeGetByUserID] |
@g_UserID =cf26b27a-9583-4ea5-8c8e-69ed5227b85f
|
0.0312504 |
5. |
0.531263 |
DBInterface.GetDataTable; CartManager.LoadCartItems; CartManager.get_CartItems; MiniCart.Page_Load; show |
StoredProcedure |
[dbo].[Cart_LoadByUserID] |
@UserID=cf26b27a-9583-4ea5-8c8e-69ed5227b85f @SiteID=1 @AutoGeneratePriceList=False
|
0.093781 |
6. |
0.6874837 |
DBInterface.GetDataTable; ProductDeprecated.LoadProductFromURL; ProductDeprecated..ctor; ProductDetail.LoadProductDetails; show |
StoredProcedure |
[dbo].[PageUrlLoadByPrimaryKey] |
@PageUrl=/starter-pack-deluxe.html @Type=PRODUCT
|
0.1094011 |
7. |
0.8877776 |
DBInterface.get_oSQLDataReader; ProductDeprecated._FETCH; ProductDeprecated.LoadProductFromURL; ProductDeprecated..ctor; show |
StoredProcedure |
[dbo].[ProductLoadByPrimaryKey] |
@ProductID=3877 @SiteID=1 @UserID=cf26b27a-9583-4ea5-8c8e-69ed5227b85f
|
0.2002939 |
8. |
0.9502775 |
DBInterface.GetDataTable; Categories.LoadCategoryByProductId; Categories..ctor; ProductDeprecated..ctor; show |
StoredProcedure |
[dbo].[CategoryListByProductId] |
@ProductId=3877 @SiteID=1 @ShowHidden=False
|
0.0624999 |
9. |
0.9502775 |
DBInterface.GetDataTable; Category.LoadCategoryFromURL; Category..ctor; ProductDetail.LoadProductDetails; show |
StoredProcedure |
[dbo].[PageUrlLoadByPrimaryKey] |
@Type=CATEGORY
|
0 |
10. |
0.9815239 |
DBInterface.get_oSQLDataReader; StoreImages.LoadImagesByProductKey; StoreImages..ctor; ProductDeprecated.get_Images; show |
StoredProcedure |
[dbo].[ImageLoadByProductKey] |
@ProductID=3877
|
0.0312464 |
11. |
1.2158992 |
DBInterface.get_oSQLDataReader; Related_Products.LoadRelatedProductsByProductID; Related_Products..ctor; ProductDeprecated.get_RelatedProducts; show |
StoredProcedure |
[dbo].[ProductRelationshipListByProductID] |
@ProductID=3877 @SiteID=1 @ShowHidden=False
|
0.2343753 |
12. |
1.4346525 |
DBInterface.get_oSQLDataReader; Skus.LoadSkusByCategory; Skus..ctor; ProductDeprecated.get_Skus; show |
StoredProcedure |
[dbo].[SKUListLoadByProductKey] |
@ProductID=3877 @SiteID=1 @UserID=cf26b27a-9583-4ea5-8c8e-69ed5227b85f @ShowHidden=0
|
0.1093858 |
13. |
1.7104982 |
DBInterface.get_oSQLDataReader; Skus.LoadSkuPricing; Skus.LoadSkusByCategory; Skus..ctor; show |
StoredProcedure |
[dbo].[PriceListBySkuId] |
@SkuList=3911 @UserID=cf26b27a-9583-4ea5-8c8e-69ed5227b85f @SiteID=1
|
0.2758457 |
14. |
1.7261181 |
DBInterface.GetDataTable; BaseUser.GetDefaultSearch; UserSession.get_DefaultSearchAttribute; ProductDetail.LoadProductDetails; show |
StoredProcedure |
[dbo].[DefaultSearchAttributeGetByUserID] |
@g_UserID =cf26b27a-9583-4ea5-8c8e-69ed5227b85f
|
0.0156199 |
15. |
1.7729976 |
DBInterface.GetDataTable; ProductAttributes.LoadProductAttributes; ProductAttributes..ctor; Sku.get_Attributes; show |
StoredProcedure |
[dbo].[getProductAttributesBySkuId] |
@SkuId=3911
|
0.0312621 |
16. |
1.8198732 |
DBInterface.GetDataTable; ProductDeprecated.GetDistinctSKUAttributes; ProductDeprecated.get_DistinctSkuAttributes; ProductDetail.LoadProductDetails; show |
StoredProcedure |
[dbo].[AttributesDistinctByProductID] |
@ProductId=3877
|
0.0468756 |
17. |
1.9761273 |
DBInterface.GetDataTable; BreadcrumbManager.GetBreadcrumbDataByPage; BreadcrumbManager.GetBreadcrumbDataByPage; BreadcrumbCtrl.Page_Load; show |
StoredProcedure |
BreadcrumbByPageUrlByUser |
@UserId=cf26b27a-9583-4ea5-8c8e-69ed5227b85f @SiteID=1 @PageURL=/starter-pack-deluxe.html
|
0.1562541 |
|
|
|
|
|
Total DB Execution Time |
1.4293439 |