| # |
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 |
| 2. |
0 |
DBInterface.get_oSQLDataReader; VirtualSiteProperties.GetVirtualSiteProperties; VirtualSiteProperties..ctor; VirtualCatalogInfo.LoadVirtualCatalog; show |
StoredProcedure |
[dbo].[VirtualSitePropertiesLoadBySiteID] |
@SiteID=1
|
0 |
| 3. |
0.0312507 |
DBInterface.GetDataTable; HTMLContent.GetHTMLContent; HTMLContent..ctor; FormSubmissionManager.InitializeTracking; 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 = '/bariatric-hospital-rehab-products/default.aspx' AND PageURLs.Type='category' show |
- |
0.014091 |
| 4. |
0.0312507 |
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 = '/bariatric-hospital-rehab-products/default.aspx' AND PageURLs.Type='category' show |
- |
0 |
| 5. |
0.0312507 |
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 |
| 6. |
0.0476999 |
DBInterface.GetDataTable; BaseUser.GetDefaultSearch; UserSession.get_DefaultSearchAttribute; PageManager.get_CategoryMenu; show |
StoredProcedure |
[dbo].[DefaultSearchAttributeGetByUserID] |
@g_UserID =d3e2ce76-c30c-48d6-80dc-7a030a1e8730
|
0 |
| 7. |
0.0476999 |
DBInterface.GetDataTable; Category.LoadCategoryFromURL; Category..ctor; CategoryBrowse.Page_Load; show |
StoredProcedure |
[dbo].[PageUrlLoadByPrimaryKey] |
@PageUrl=/bariatric-hospital-rehab-products/default.aspx
@Type=CATEGORY
|
0 |
| 8. |
0.0476999 |
DBInterface.get_oSQLDataReader; Category._FETCH; Category.LoadCategoryFromURL; Category..ctor; show |
StoredProcedure |
[dbo].[CategoryLoadByPrimaryKey] |
@CategoryId=120
@SiteID=1
@RootID=0
@UserID=00000000-0000-0000-0000-000000000000
|
0 |
| 9. |
0.0476999 |
DBInterface.GetDataTable; BaseUser.GetDefaultSearch; Categories..ctor; Category.get_ChildCategories; show |
StoredProcedure |
[dbo].[DefaultSearchAttributeGetByUserID] |
@g_UserID =d3e2ce76-c30c-48d6-80dc-7a030a1e8730
|
0 |
| 10. |
0.0633544 |
DBInterface.GetDataTable; Categories.LoadCategoryByParentCategory; Categories..ctor; Category.get_ChildCategories; show |
StoredProcedure |
[dbo].[CategoryListByParentKey] |
@CategoryID=120
@SiteID=1
@ShowHidden=False
|
0.0156545 |
| 11. |
0.0633544 |
DBInterface.GetDataTable; BreadcrumbManager.GetBreadcrumbDataByPage; BreadcrumbManager.GetBreadcrumbDataByPage; BreadcrumbCtrl.Page_Load; show |
StoredProcedure |
BreadcrumbByPageUrlByUser |
@UserId=d3e2ce76-c30c-48d6-80dc-7a030a1e8730
@SiteID=1
@PageURL=/bariatric-hospital-rehab-products/default.aspx
|
0 |
| 12. |
0.0633544 |
DBInterface.GetDataTable; BaseUser.GetDefaultSearch; UserSession.get_DefaultSearchAttribute; ProductFilterResults.BuildFilters; show |
StoredProcedure |
[dbo].[DefaultSearchAttributeGetByUserID] |
@g_UserID =d3e2ce76-c30c-48d6-80dc-7a030a1e8730
|
0 |
| 13. |
0.0633544 |
DBInterface.GetDataTable; Category.LoadCategoryFromURL; Category..ctor; ProductFilterResults.BuildFilters; show |
StoredProcedure |
[dbo].[PageUrlLoadByPrimaryKey] |
@PageUrl=/bariatric-hospital-rehab-products/default.aspx
@Type=CATEGORY
|
0 |
| 14. |
0.0633544 |
DBInterface.get_oSQLDataReader; Category._FETCH; Category.LoadCategoryFromURL; Category..ctor; show |
StoredProcedure |
[dbo].[CategoryLoadByPrimaryKey] |
@CategoryId=120
@SiteID=1
@RootID=0
@UserID=00000000-0000-0000-0000-000000000000
|
0 |
| 15. |
0.0789803 |
DBInterface.GetDataTable; Category.LoadCategoryFromURL; Category..ctor; CurrentSearchFilters.LoadAppliedFilters; show |
StoredProcedure |
[dbo].[PageUrlLoadByPrimaryKey] |
@PageUrl=/bariatric-hospital-rehab-products/default.aspx
@Type=CATEGORY
|
0 |
| 16. |
0.0789803 |
DBInterface.get_oSQLDataReader; Category._FETCH; Category.LoadCategoryFromURL; Category..ctor; show |
StoredProcedure |
[dbo].[CategoryLoadByPrimaryKey] |
@CategoryId=120
@SiteID=1
@RootID=0
@UserID=00000000-0000-0000-0000-000000000000
|
0 |
| 17. |
0.0789803 |
DBInterface.GetDataTable; BaseUser.GetDefaultSearch; UserSession.get_DefaultSearchAttribute; ProductFilterResults.FillSearchResults; show |
StoredProcedure |
[dbo].[DefaultSearchAttributeGetByUserID] |
@g_UserID =d3e2ce76-c30c-48d6-80dc-7a030a1e8730
|
0 |
| 18. |
1.2317606 |
DBInterface.GetDataSet; Search.getFilteredProductList; ProductFilterResults.FillSearchResults; ProductFilterResults.Page_Load; show |
StoredProcedure |
[dbo].[getFilteredProductListWithPaging] |
@UserID=d3e2ce76-c30c-48d6-80dc-7a030a1e8730
@PageNumber=1
@PageSize=30
@SortOrder=featured
@SessionID=gqgbjdtos3c1u1bfsehmclcw
@SiteID=1
@FilterProductsXML=<filters />
@CategoryId=120
@IncludeSubCategories=0
@MaxProductsToReturn=1000
@AllowMultipleAttributesPerGroup=1
@AllowMultipleExclusionAttributesPerGroup=1
|
1.1527803 |
| 19. |
1.2473745 |
DBInterface.GetDataTable; ProductAttributeFilter.getProductAttributesList; Search.getFilteredProductList; ProductFilterResults.FillSearchResults; show |
StoredProcedure |
[dbo].[getProductAttributesList] |
- |
0.0156139 |
| 20. |
1.2951535 |
DBInterface.GetDataTable; CartManager.LoadCartItems; CartManager.get_CartItems; ProductFilterResults.GetQtyInCart; show |
StoredProcedure |
[dbo].[Cart_LoadByUserID] |
@UserID=d3e2ce76-c30c-48d6-80dc-7a030a1e8730
@SiteID=1
|
0 |
| 21. |
1.4231872 |
DBInterface.GetDataTable; BreadcrumbManager.GetBreadcrumbDataByPage; BreadcrumbManager.GetBreadcrumbDataByPage; BreadcrumbCtrl.Page_Load; show |
StoredProcedure |
BreadcrumbByPageUrlByUser |
@UserId=d3e2ce76-c30c-48d6-80dc-7a030a1e8730
@SiteID=1
@PageURL=/bariatric-hospital-rehab-products/default.aspx
|
0 |
|
|
|
|
|
Total DB Execution Time |
1.1981397 |