# |
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.0156203 |
2. |
0.1426353 |
DBInterface.GetDataTable; HTMLContent.GetHTMLContent; HTMLContent..ctor; FormSubmissionManager.InitializeTracking; 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 = '/pediatric-lithotomy-stirrups.html' AND PageURLs.Type='product' show |
- |
0.015676 |
3. |
0.1426353 |
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 = '/pediatric-lithotomy-stirrups.html' AND PageURLs.Type='product' show |
- |
0 |
4. |
0.1582643 |
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 |
5. |
0.2227526 |
DBInterface.GetDataTable; ProductDeprecated.LoadProductFromURL; ProductDeprecated..ctor; ProductDetail.LoadProductDetails; show |
StoredProcedure |
[dbo].[PageUrlLoadByPrimaryKey] |
@PageUrl=/pediatric-lithotomy-stirrups.html @Type=PRODUCT
|
0.001402 |
6. |
0.2391057 |
DBInterface.get_oSQLDataReader; ProductDeprecated._FETCH; ProductDeprecated.LoadProductFromURL; ProductDeprecated..ctor; show |
StoredProcedure |
[dbo].[ProductLoadByPrimaryKey] |
@ProductID=174 @SiteID=1 @UserID=a1a048b0-70e0-4681-a8a7-e140c65ad2a0
|
0.0163531 |
7. |
0.2547788 |
DBInterface.GetDataTable; Categories.LoadCategoryByProductId; Categories..ctor; ProductDeprecated..ctor; show |
StoredProcedure |
[dbo].[CategoryListByProductId] |
@ProductId=174 @SiteID=1 @ShowHidden=False
|
0 |
8. |
0.3172789 |
DBInterface.GetDataTable; Category.LoadCategoryFromURL; Category..ctor; ProductDetail.LoadProductDetails; show |
StoredProcedure |
[dbo].[PageUrlLoadByPrimaryKey] |
@Type=CATEGORY
|
0 |
9. |
0.3492344 |
DBInterface.GetDataTable; ProductDetail.LoadProductDetails; ProductDetail.Page_Load; Control.OnLoad; show |
StoredProcedure |
[dbo].[DocumentLoadByProductKey] |
@ProductID=174
|
0.0319555 |
10. |
0.3492344 |
DBInterface.get_oSQLDataReader; StoreImages.LoadImagesByProductKey; StoreImages..ctor; ProductDeprecated.get_Images; show |
StoredProcedure |
[dbo].[ImageLoadByProductKey] |
@ProductID=174
|
0 |
11. |
0.3961539 |
DBInterface.get_oSQLDataReader; Related_Products.LoadRelatedProductsByProductID; Related_Products..ctor; ProductDeprecated.get_RelatedProducts; show |
StoredProcedure |
[dbo].[ProductRelationshipListByProductID] |
@ProductID=174 @SiteID=1 @ShowHidden=False
|
0 |
12. |
0.4769006 |
DBInterface.get_oSQLDataReader; Skus.LoadSkusByCategory; Skus..ctor; ProductDeprecated.get_Skus; show |
StoredProcedure |
[dbo].[SKUListLoadByProductKey] |
@ProductID=174 @SiteID=1 @UserID=a1a048b0-70e0-4681-a8a7-e140c65ad2a0 @ShowHidden=0
|
0.0807467 |
13. |
1.0477262 |
DBInterface.get_oSQLDataReader; Skus.LoadSkuPricing; Skus.LoadSkusByCategory; Skus..ctor; show |
StoredProcedure |
[dbo].[PriceListBySkuId] |
@SkuList=684,676,668 @UserID=a1a048b0-70e0-4681-a8a7-e140c65ad2a0 @SiteID=1
|
0.5239 |
14. |
1.1109473 |
DBInterface.GetDataTable; BaseUser.GetDefaultSearch; UserSession.get_DefaultSearchAttribute; ProductDetail.LoadProductDetails; show |
StoredProcedure |
[dbo].[DefaultSearchAttributeGetByUserID] |
@g_UserID =a1a048b0-70e0-4681-a8a7-e140c65ad2a0
|
0.0632211 |
15. |
1.142849 |
DBInterface.GetDataTable; ProductDeprecated.GetDistinctSKUAttributes; ProductDeprecated.get_DistinctSkuAttributes; ProductDetail.LoadProductDetails; show |
StoredProcedure |
[dbo].[AttributesDistinctByProductID] |
@ProductId=174
|
0.0319017 |
16. |
1.2859798 |
DBInterface.GetDataTable; BreadcrumbManager.GetBreadcrumbDataByPage; BreadcrumbManager.GetBreadcrumbDataByPage; BreadcrumbCtrl.Page_Load; show |
StoredProcedure |
BreadcrumbByPageUrlByUser |
@UserId=a1a048b0-70e0-4681-a8a7-e140c65ad2a0 @SiteID=1 @PageURL=/pediatric-lithotomy-stirrups.html
|
0.1274986 |
17. |
1.2859798 |
DBInterface.GetDataTable; CartManager.LoadCartItems; CartManager.get_CartItems; MasterPage.UpdateCartTotals; show |
StoredProcedure |
[dbo].[Cart_LoadByUserID] |
@UserID=a1a048b0-70e0-4681-a8a7-e140c65ad2a0 @SiteID=1
|
0 |
|
|
|
|
|
Total DB Execution Time |
0.908275 |