| # |
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 |
DBInterface.get_oSQLDataReader; VirtualSiteProperties.GetVirtualSiteProperties; VirtualSiteProperties..ctor; VirtualCatalogInfo.LoadVirtualCatalog; show |
StoredProcedure |
[dbo].[VirtualSitePropertiesLoadBySiteID] |
@SiteID=1
|
0 |
| 3. |
0.0156203 |
DBInterface.GetDataTable; HTMLContent.GetHTMLContent; HTMLContent..ctor; MasterPage.get_HtmlContent; show |
Text |
SELECT TOP(1) '0' AS ArticleID, 0 As ID, CASE WHEN Category.MetaTitle='' THEN Category.CategoryName ELSE Category.MetaTitle END As PageTitle, Category.MetaDescription As PageMetaDesc, Category.MetaKeywords As PageMetaKwords, Category.CategoryName 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 Category ON PageURLs.EntityID = Category.CategoryID WHERE PageURLs.PageURL = '/thread-color-cards/default.aspx' AND PageURLs.Type='category' show |
- |
0 |
| 4. |
0.0312393 |
DBInterface.GetDataTable; BaseUser.GetDefaultSearch; UserSession.get_DefaultSearchAttribute; PageManager.get_CategoryMenu; show |
StoredProcedure |
[dbo].[DefaultSearchAttributeGetByUserID] |
@g_UserID =d6d91be1-1d7c-4449-9751-673d3938510d
|
0 |
| 5. |
0.2656128 |
DBInterface.GetDataTable; CartManager.LoadCartItems; CartManager.get_CartItems; MiniCart.Page_Load; show |
StoredProcedure |
[dbo].[Cart_LoadByUserID] |
@UserID=d6d91be1-1d7c-4449-9751-673d3938510d
@SiteID=1
@AutoGeneratePriceList=False
|
0 |
| 6. |
0.2656128 |
DBInterface.GetDataTable; Category.LoadCategoryFromURL; Category..ctor; CategoryBrowse.Page_Load; show |
StoredProcedure |
[dbo].[PageUrlLoadByPrimaryKey] |
@PageUrl=/thread-color-cards/default.aspx
@Type=CATEGORY
|
0 |
| 7. |
0.2656128 |
DBInterface.get_oSQLDataReader; Category._FETCH; Category.LoadCategoryFromURL; Category..ctor; show |
StoredProcedure |
[dbo].[CategoryLoadByPrimaryKey] |
@CategoryId=148
@SiteID=1
@RootID=0
@UserID=00000000-0000-0000-0000-000000000000
|
0 |
| 8. |
0.281239 |
DBInterface.GetDataTable; BreadcrumbManager.GetBreadcrumbDataByPage; BreadcrumbManager.GetBreadcrumbDataByPage; BreadcrumbCtrl.Page_Load; show |
StoredProcedure |
BreadcrumbByPageUrlByUser |
@UserId=d6d91be1-1d7c-4449-9751-673d3938510d
@SiteID=1
@PageURL=/thread-color-cards/default.aspx
|
0.0156262 |
| 9. |
0.281239 |
DBInterface.GetDataTable; BaseUser.GetDefaultSearch; UserSession.get_DefaultSearchAttribute; ProductFilterResults.BuildFilters; show |
StoredProcedure |
[dbo].[DefaultSearchAttributeGetByUserID] |
@g_UserID =d6d91be1-1d7c-4449-9751-673d3938510d
|
0 |
| 10. |
0.281239 |
DBInterface.GetDataTable; Category.LoadCategoryFromURL; Category..ctor; ProductFilterResults.BuildFilters; show |
StoredProcedure |
[dbo].[PageUrlLoadByPrimaryKey] |
@PageUrl=/thread-color-cards/default.aspx
@Type=CATEGORY
|
0 |
| 11. |
0.281239 |
DBInterface.get_oSQLDataReader; Category._FETCH; Category.LoadCategoryFromURL; Category..ctor; show |
StoredProcedure |
[dbo].[CategoryLoadByPrimaryKey] |
@CategoryId=148
@SiteID=1
@RootID=0
@UserID=00000000-0000-0000-0000-000000000000
|
0 |
| 12. |
0.281239 |
DBInterface.GetDataTable; Category.LoadCategoryFromURL; Category..ctor; CurrentSearchFilters.LoadAppliedFilters; show |
StoredProcedure |
[dbo].[PageUrlLoadByPrimaryKey] |
@PageUrl=/thread-color-cards/default.aspx
@Type=CATEGORY
|
0 |
| 13. |
0.281239 |
DBInterface.get_oSQLDataReader; Category._FETCH; Category.LoadCategoryFromURL; Category..ctor; show |
StoredProcedure |
[dbo].[CategoryLoadByPrimaryKey] |
@CategoryId=148
@SiteID=1
@RootID=0
@UserID=00000000-0000-0000-0000-000000000000
|
0 |
| 14. |
0.281239 |
DBInterface.GetDataTable; BaseUser.GetDefaultSearch; UserSession.get_DefaultSearchAttribute; ProductFilterResults.FillSearchResults; show |
StoredProcedure |
[dbo].[DefaultSearchAttributeGetByUserID] |
@g_UserID =d6d91be1-1d7c-4449-9751-673d3938510d
|
0 |
| 15. |
0.6341893 |
DBInterface.GetDataSet; Search.getFilteredProductList; ProductFilterResults.FillSearchResults; ProductFilterResults.Page_Load; show |
StoredProcedure |
[dbo].[getFilteredProductListWithPaging] |
@UserID=d6d91be1-1d7c-4449-9751-673d3938510d
@PageNumber=1
@PageSize=24
@SortOrder=featured
@SessionID=r1qkrn0xb0z1rcjsvnfinwfv
@SiteID=1
@FilterProductsXML=<filters />
@CategoryId=148
@IncludeSubCategories=0
@MaxProductsToReturn=2000
@AllowMultipleAttributesPerGroup=1
@AllowMultipleExclusionAttributesPerGroup=1
|
0.3529503 |
| 16. |
0.6497894 |
DBInterface.GetDataTable; ProductAttributeFilter.getProductAttributesList; Search.getFilteredProductList; ProductFilterResults.FillSearchResults; show |
StoredProcedure |
[dbo].[getProductAttributesList] |
- |
0.0156001 |
| 17. |
0.6810561 |
DBInterface.GetDataTable; ProductFilterResults.GetSlideShowPath; ProductFilterResults.GetCategorySlideshow; ProductFilterResults.Page_Load; show |
StoredProcedure |
[dbo].[GetSliderByTitle] |
@SiteID=1
@Title=BannerAds
|
0.0156399 |
| 18. |
0.6810561 |
DBInterface.GetDataTable; BreadcrumbManager.GetBreadcrumbDataByPage; BreadcrumbManager.GetBreadcrumbDataByPage; BreadcrumbCtrl.Page_Load; show |
StoredProcedure |
BreadcrumbByPageUrlByUser |
@UserId=d6d91be1-1d7c-4449-9751-673d3938510d
@SiteID=1
@PageURL=/thread-color-cards/default.aspx
|
0 |
|
|
|
|
|
Total DB Execution Time |
0.3998165 |