# |
Seconds Since First Hit |
Trace |
Command Type |
Command Text |
Parameters |
Execution Time |
1. |
0 |
DBInterface.GetDataTable; ProductDetail.GetDefaultSearchNameID; ProductDetail..ctor; usercontrols_store_catalog_productdetail_ascx..ctor; show |
StoredProcedure |
[dbo].[DefaultSearchNameID] |
- |
0.0030544 |
2. |
0.0135149 |
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 = '/repl-bedpro-undermattress-alarm-system-sensor-pads.html' AND PageURLs.Type='product' show |
- |
0.0135149 |
3. |
0.0172388 |
DBInterface.GetDataTable; HTMLContent.GetHTMLMiscContent; MasterPage.Page_Load; Control.OnLoad; show |
Text |
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Header - Alert Bar' show |
- |
0.0037239 |
4. |
0.0226923 |
DBInterface.GetDataTable; ProductDeprecated.LoadProductFromURL; ProductDeprecated..ctor; ProductDetail.LoadProductDetails; show |
StoredProcedure |
[dbo].[PageUrlLoadByPrimaryKey] |
@PageUrl=/repl-bedpro-undermattress-alarm-system-sensor-pads.html @Type=PRODUCT
|
0.0029172 |
5. |
0.0350605 |
DBInterface.get_oSQLDataReader; ProductDeprecated._FETCH; ProductDeprecated.LoadProductFromURL; ProductDeprecated..ctor; show |
StoredProcedure |
[dbo].[ProductLoadByPrimaryKey] |
@ProductID=852 @SiteID=1 @UserID=64ce8373-0ba4-4e52-9033-d2c98c6e6509
|
0.0123682 |
6. |
0.0397622 |
DBInterface.GetDataTable; Categories.LoadCategoryByProductId; Categories..ctor; ProductDeprecated..ctor; show |
StoredProcedure |
[dbo].[CategoryListByProductId] |
@ProductId=852 @SiteID=1 @ShowHidden=False
|
0.0047017 |
7. |
0.0430079 |
DBInterface.GetDataTable; Category.LoadCategoryFromURL; Category..ctor; ProductDetail.LoadProductDetails; show |
StoredProcedure |
[dbo].[PageUrlLoadByPrimaryKey] |
@Type=CATEGORY
|
0.0032457 |
8. |
0.0515218 |
DBInterface.GetDataTable; ProductDetail.LoadProductDetails; ProductDetail.Page_Load; Control.OnLoad; show |
StoredProcedure |
[dbo].[DocumentLoadByProductKey] |
@ProductID=852
|
0.0085139 |
9. |
0.0537719 |
DBInterface.get_oSQLDataReader; StoreImages.LoadImagesByProductKey; StoreImages..ctor; ProductDeprecated.get_Images; show |
StoredProcedure |
[dbo].[ImageLoadByProductKey] |
@ProductID=852
|
0.0017312 |
10. |
0.0594406 |
DBInterface.get_oSQLDataReader; Related_Products.LoadRelatedProductsByProductID; Related_Products..ctor; ProductDeprecated.get_RelatedProducts; show |
StoredProcedure |
[dbo].[ProductRelationshipListByProductID] |
@ProductID=852 @SiteID=1 @ShowHidden=False
|
0.0056687 |
11. |
0.0885924 |
DBInterface.get_oSQLDataReader; Skus.LoadSkusByCategory; Skus..ctor; ProductDeprecated.get_Skus; show |
StoredProcedure |
[dbo].[SKUListLoadByProductKey] |
@ProductID=852 @SiteID=1 @UserID=64ce8373-0ba4-4e52-9033-d2c98c6e6509 @ShowHidden=0
|
0.0291518 |
12. |
0.3143559 |
DBInterface.get_oSQLDataReader; Skus.LoadSkuPricing; Skus.LoadSkusByCategory; Skus..ctor; show |
StoredProcedure |
[dbo].[PriceListBySkuId] |
@SkuList=8171,8170,8169,8174,8173,8172,8147,8145,8143,8150,8149,8181,8133,8132,8136,8134 @UserID=64ce8373-0ba4-4e52-9033-d2c98c6e6509 @SiteID=1
|
0.115734 |
13. |
0.3171761 |
DBInterface.GetDataTable; BaseUser.GetDefaultSearch; UserSession.get_DefaultSearchAttribute; ProductDetail.LoadProductDetails; show |
StoredProcedure |
[dbo].[DefaultSearchAttributeGetByUserID] |
@g_UserID =64ce8373-0ba4-4e52-9033-d2c98c6e6509
|
0.0028202 |
14. |
0.319576 |
DBInterface.GetDataTable; ProductDeprecated.GetDistinctSKUAttributes; ProductDeprecated.get_DistinctSkuAttributes; ProductDetail.LoadProductDetails; show |
StoredProcedure |
[dbo].[AttributesDistinctByProductID] |
@ProductId=852
|
0.0023999 |
15. |
0.3268443 |
DBInterface.GetDataTable; BreadcrumbManager.GetBreadcrumbDataByPage; BreadcrumbManager.GetBreadcrumbDataByPage; BreadcrumbCtrl.Page_Load; show |
StoredProcedure |
BreadcrumbByPageUrlByUser |
@UserId=64ce8373-0ba4-4e52-9033-d2c98c6e6509 @SiteID=1 @PageURL=/repl-bedpro-undermattress-alarm-system-sensor-pads.html
|
0.0072683 |
16. |
0.3309813 |
DBInterface.GetDataTable; CartManager.LoadCartItems; CartManager.get_CartItems; MasterPage.UpdateCartTotals; show |
StoredProcedure |
[dbo].[Cart_LoadByUserID] |
@UserID=64ce8373-0ba4-4e52-9033-d2c98c6e6509 @SiteID=1
|
0.004137 |
|
|
|
|
|
Total DB Execution Time |
0.220951 |