| # |
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=schuremeddev.braveriversolutions.com
|
0.0338147 |
| 2. |
0.0156653 |
DBInterface.get_oSQLDataReader; VirtualSiteProperties.GetVirtualSiteProperties; VirtualSiteProperties..ctor; VirtualCatalogInfo.LoadVirtualCatalog; show |
StoredProcedure |
[dbo].[VirtualSitePropertiesLoadBySiteID] |
@SiteID=1
|
0.0156653 |
| 3. |
0.1264553 |
DBInterface.GetDataTable; ProductDetail.GetDefaultSearchNameID; ProductDetail..ctor; usercontrols_store_catalog_productdetail_ascx..ctor; show |
StoredProcedure |
[dbo].[DefaultSearchNameID] |
- |
0 |
| 4. |
0.1584594 |
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 = '/repl-great-white-platinum-boot-pads.html' AND PageURLs.Type='product' show |
- |
0.0320041 |
| 5. |
0.1584594 |
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-great-white-platinum-boot-pads.html' AND PageURLs.Type='product' show |
- |
0 |
| 6. |
0.1740787 |
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.0156193 |
| 7. |
0.268658 |
DBInterface.GetDataTable; ProductDeprecated.LoadProductFromURL; ProductDeprecated..ctor; ProductDetail.LoadProductDetails; show |
StoredProcedure |
[dbo].[PageUrlLoadByPrimaryKey] |
@PageUrl=/repl-great-white-platinum-boot-pads.html
@Type=PRODUCT
|
0.0320798 |
| 8. |
0.4029955 |
DBInterface.get_oSQLDataReader; ProductDeprecated._FETCH; ProductDeprecated.LoadProductFromURL; ProductDeprecated..ctor; show |
StoredProcedure |
[dbo].[ProductLoadByPrimaryKey] |
@ProductID=93
@SiteID=1
@UserID=1174e926-dc72-4895-b6b2-2433a829e496
|
0.1343375 |
| 9. |
0.4186902 |
DBInterface.GetDataTable; Categories.LoadCategoryByProductId; Categories..ctor; ProductDeprecated..ctor; show |
StoredProcedure |
[dbo].[CategoryListByProductId] |
@ProductId=93
@SiteID=1
@ShowHidden=False
|
0.0156947 |
| 10. |
0.4342818 |
DBInterface.GetDataTable; Category.LoadCategoryFromURL; Category..ctor; ProductDetail.LoadProductDetails; show |
StoredProcedure |
[dbo].[PageUrlLoadByPrimaryKey] |
@Type=CATEGORY
|
0.0155916 |
| 11. |
0.4499294 |
DBInterface.GetDataTable; ProductDetail.LoadProductDetails; ProductDetail.Page_Load; Control.OnLoad; show |
StoredProcedure |
[dbo].[DocumentLoadByProductKey] |
@ProductID=93
|
0.0156476 |
| 12. |
0.4974343 |
DBInterface.get_oSQLDataReader; StoreImages.LoadImagesByProductKey; StoreImages..ctor; ProductDeprecated.get_Images; show |
StoredProcedure |
[dbo].[ImageLoadByProductKey] |
@ProductID=93
|
0.031905 |
| 13. |
0.7182915 |
DBInterface.get_oSQLDataReader; Related_Products.LoadRelatedProductsByProductID; Related_Products..ctor; ProductDeprecated.get_RelatedProducts; show |
StoredProcedure |
[dbo].[ProductRelationshipListByProductID] |
@ProductID=93
@SiteID=1
@ShowHidden=False
|
0.2052218 |
| 14. |
0.8595661 |
DBInterface.get_oSQLDataReader; Skus.LoadSkusByCategory; Skus..ctor; ProductDeprecated.get_Skus; show |
StoredProcedure |
[dbo].[SKUListLoadByProductKey] |
@ProductID=93
@SiteID=1
@UserID=1174e926-dc72-4895-b6b2-2433a829e496
@ShowHidden=0
|
0.1412746 |
| 15. |
1.3997156 |
DBInterface.get_oSQLDataReader; Skus.LoadSkuPricing; Skus.LoadSkusByCategory; Skus..ctor; show |
StoredProcedure |
[dbo].[PriceListBySkuId] |
@SkuList=7777
@UserID=1174e926-dc72-4895-b6b2-2433a829e496
@SiteID=1
|
0.5401495 |
| 16. |
1.4153951 |
DBInterface.GetDataTable; BaseUser.GetDefaultSearch; UserSession.get_DefaultSearchAttribute; ProductDetail.LoadProductDetails; show |
StoredProcedure |
[dbo].[DefaultSearchAttributeGetByUserID] |
@g_UserID =1174e926-dc72-4895-b6b2-2433a829e496
|
0.0156795 |
| 17. |
1.4629081 |
DBInterface.GetDataTable; ProductDeprecated.GetDistinctSKUAttributes; ProductDeprecated.get_DistinctSkuAttributes; ProductDetail.LoadProductDetails; show |
StoredProcedure |
[dbo].[AttributesDistinctByProductID] |
@ProductId=93
|
0.047513 |
| 18. |
1.5567159 |
DBInterface.GetDataTable; BreadcrumbManager.GetBreadcrumbDataByPage; BreadcrumbManager.GetBreadcrumbDataByPage; BreadcrumbCtrl.Page_Load; show |
StoredProcedure |
BreadcrumbByPageUrlByUser |
@UserId=1174e926-dc72-4895-b6b2-2433a829e496
@SiteID=1
@PageURL=/repl-great-white-platinum-boot-pads.html
|
0.0938078 |
| 19. |
1.6681782 |
DBInterface.GetDataTable; CartManager.LoadCartItems; CartManager.get_CartItems; MasterPage.UpdateCartTotals; show |
StoredProcedure |
[dbo].[Cart_LoadByUserID] |
@UserID=1174e926-dc72-4895-b6b2-2433a829e496
@SiteID=1
|
0.1114623 |
|
|
|
|
|
Total DB Execution Time |
1.4974681 |