| # |
Seconds Since First Hit |
Trace |
Command Type |
Command Text |
Parameters |
Execution Time |
| 1. |
0 |
DBInterface.GetDataTable; VirtualCatalogInfoBASE.LoadVirtualCatalog; VirtualCatalogInfoBASE..ctor; VirtualCatalogInfo..ctor; show |
StoredProcedure |
[dbo].[VirtualCatalogLoadBySiteDomain] |
@SiteDomain=aspdeltadev.braveriversolutions.com
|
0 |
| 2. |
0.0156259 |
DBInterface.get_oSQLDataReader; VirtualSiteProperties.GetVirtualSiteProperties; VirtualSiteProperties..ctor; VirtualCatalogInfoBASE.LoadVirtualCatalog; show |
StoredProcedure |
[dbo].[VirtualSitePropertiesLoadBySiteID] |
@SiteID=1
|
0 |
| 3. |
0.2054728 |
SqlBASE.GetDataTable; HTMLContent.GetHTMLContent; HTMLContentBASE..ctor; HTMLContent..ctor; MasterPage.get_HtmlContent; MasterPage.Page_Load; Control.OnLoad; Control.LoadRecursive; Control.LoadRecursive; Page.ProcessRequestMain; show |
Text |
SELECT TOP(1) '0' AS ArticleID, 0 As ID, Category.MetaTitle 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 = '/gloves/by-material/latex/white-lightning/default.aspx' AND PageURLs.Type='category' show |
- |
0 |
| 4. |
0.2210988 |
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetHTMLMiscContentFromList; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show |
Text |
SELECT ID, Content, ContentKey FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey IN ('Custom Footer Links','Footer Social Links','Footer Contact Info','Header Phone Number') show |
- |
0 |
| 5. |
0.2210988 |
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show |
Text |
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Phone Number' |
- |
0 |
| 6. |
0.2210988 |
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show |
Text |
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Phone Number' |
- |
0 |
| 7. |
0.2210988 |
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show |
Text |
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Header Tagline' |
- |
0 |
| 8. |
0.2210988 |
SqlBASE.GetDataTable; HTMLContent.GetHTMLHeaderLinks; MasterPage.Page_Load; Control.OnLoad; show |
Text |
SELECT HTMLHeaderLinks.LinkText, HTMLContent.PageHeading, HTMLContent.PageKey FROM dbo.HTMLHeaderLinks INNER JOIN dbo.HTMLContent ON HTMLHeaderLinks.ContentID = HTMLContent.ID WHERE HTMLContent.SiteID = @SiteID ORDER BY HTMLHeaderLinks.OrderPriority, HTMLHeaderLinks.LinkText, HTMLContent.PageHeading show |
SiteID=1
|
0 |
| 9. |
0.2210988 |
SqlBASE.GetDataTable; HTMLContent.GetHTMLHeaderLinks; MasterPage.Page_Load; Control.OnLoad; show |
Text |
SELECT HTMLHeaderLinks.LinkText, HTMLContent.PageHeading, HTMLContent.PageKey FROM dbo.HTMLHeaderLinks INNER JOIN dbo.HTMLContent ON HTMLHeaderLinks.ContentID = HTMLContent.ID WHERE HTMLContent.SiteID = @SiteID ORDER BY HTMLHeaderLinks.OrderPriority, HTMLHeaderLinks.LinkText, HTMLContent.PageHeading show |
SiteID=1
|
0 |
| 10. |
0.2367235 |
SqlBASE.GetDataTable; HTMLContent.GetHTMLFooterLinks; MasterPage.Page_Load; Control.OnLoad; show |
Text |
SELECT HTMLFooterLinks.LinkText, HTMLContent.PageHeading, HTMLContent.PageKey FROM dbo.HTMLFooterLinks INNER JOIN dbo.HTMLContent ON HTMLFooterLinks.ContentID = HTMLContent.ID WHERE HTMLContent.SiteID = @SiteID ORDER BY HTMLFooterLinks.OrderPriority, HTMLFooterLinks.LinkText, HTMLContent.PageHeading show |
SiteID=1
|
0 |
| 11. |
0.2367235 |
DBInterface.GetDataTable; BaseUser.GetDefaultSearch; UserSession.get_DefaultSearchAttribute; CatalogGlobalItems.get_oCategoryMenu; show |
StoredProcedure |
[dbo].[DefaultSearchAttributeGetByUserID] |
@g_UserID =2208d34f-d535-4cf9-80e9-5d27c31de36f
|
0 |
| 12. |
0.256635 |
DBInterface.GetDataTable; CatalogCategoryMenu.LoadCategoryByParentCategory; CatalogCategoryMenu..ctor; CatalogGlobalItems.get_oCategoryMenu; show |
StoredProcedure |
[dbo].[CatalogCategoryListForMenus] |
@SiteID=1
@ShowHidden=False
|
0.0199115 |
| 13. |
0.4055434 |
SqlBASE.GetDataTable; Menu.GetMenuContent; MenuBASE.get_MenuContent; MasterPage.Page_Load; show |
Text |
DECLARE @StartingID INT;
SET @StartingID = 0;
DECLARE @Tree TABLE(TreeID INT IDENTITY PRIMARY KEY, Level INT, ParentTreeID INT, [Path] VARCHAR(2000), PageID_Path VARCHAR(2000), PageID INT NOT NULL);
DECLARE @RowCount INT, @Level INT, @DelCount INT;
SET NOCOUNT ON;
SET @Level = 0;
INSERT INTO @Tree(PageID, Level) VALUES (@StartingID, @Level);
SET @RowCount = @@ROWCOUNT;
UPDATE @Tree SET Path = STR(TreeID, 10, 0) + '.', PageID_Path = CAST(PageID AS VARCHAR(10)) + '\';
WHILE @RowCount > 0
BEGIN
SET @Level = @Level + 1;
INSERT INTO @Tree(Level, ParentTreeID, PageID)
SELECT @Level, t.TreeId, PageURLs.ID
FROM PageURLs
LEFT OUTER JOIN @Tree t ON ISNULL(PageURLs.ParentID,0) = t.PageID AND t.Level = (@Level - 1)
INNER JOIN HTMLContent ON HTMLContent.ID = PageURLs.EntityID
LEFT OUTER JOIN HTMLContent_XREF ON HTMLContent.ID = HTMLContent_XREF.ContentID
WHERE 1=1
AND (
1=1
AND HTMLContent.SiteID = 1
AND PageURLs.[Type] = 'content'
AND HTMLContent.IsMenuItem = 'True'
AND @Level <= 20
)
ORDER BY COALESCE(OrderPriority, 1000), PageKey
;
SET @RowCount = @@ROWCOUNT;
UPDATE t1 SET t1.[Path] = t2.[Path] + STR(t1.TreeID, 10, 0) + '.', t1.PageID_Path = t2.PageID_Path + CAST(t1.PageID AS VARCHAR(10)) + '\' FROM @Tree t1 INNER JOIN @Tree t2 ON t1.ParentTreeID = t2.TreeID WHERE t1.Level = @Level AND t2.PageID_Path NOT LIKE '%' + CAST(t1.PageID AS VARCHAR(10)) + '\%';
DELETE FROM @Tree WHERE PageID_Path IS NULL;
SET @DelCount = @@ROWCOUNT;
SET @RowCount = (@RowCount - @DelCount);
END;
SELECT
[Path], t.PageID, t.Level
, (SELECT COUNT(HTMLContent_XREF1.ID) FROM HTMLContent_XREF AS HTMLContent_XREF1 LEFT JOIN HTMLArticles AS HTMLArticles1 ON HTMLContent_XREF1.ContentID = HTMLArticles1.ContentID LEFT JOIN HTMLContent AS HTMLContent1 ON HTMLContent1.ID = HTMLContent_XREF1.ContentID WHERE HTMLContent_XREF1.ParentContentID = HTMLContent.ID AND (HTMLContent1.IsMenuItem = 'True' OR HTMLContent1.ID IS NULL) AND HTMLArticles1.ID IS NULL) As NumChildren,
HTMLContent.ID,
HTMLContent.PageKey,
HTMLContent.IsMenuItem,
HTMLContent.MenuText,
HTMLContent.MenuURL,
HTMLContent.PageHeading,
HTMLContent.HasArticles,
HTMLContent_XREF.ParentContentID
FROM @Tree t
INNER JOIN PageURLs ON t.PageID = PageURLs.ID
INNER JOIN HTMLContent ON HTMLContent.ID = PageURLs.EntityID
LEFT OUTER JOIN HTMLContent_XREF ON HTMLContent.ID = HTMLContent_XREF.ContentID
WHERE 1=1
ORDER BY [Path]
; show |
- |
0.0156424 |
| 14. |
0.4211516 |
SqlBASE.GetDataTable; Menu.GetMenuContent; MenuBASE.get_MenuContent; MasterPage.Page_Load; show |
Text |
DECLARE @StartingID INT;
SET @StartingID = 0;
DECLARE @Tree TABLE(TreeID INT IDENTITY PRIMARY KEY, Level INT, ParentTreeID INT, [Path] VARCHAR(2000), PageID_Path VARCHAR(2000), PageID INT NOT NULL);
DECLARE @RowCount INT, @Level INT, @DelCount INT;
SET NOCOUNT ON;
SET @Level = 0;
INSERT INTO @Tree(PageID, Level) VALUES (@StartingID, @Level);
SET @RowCount = @@ROWCOUNT;
UPDATE @Tree SET Path = STR(TreeID, 10, 0) + '.', PageID_Path = CAST(PageID AS VARCHAR(10)) + '\';
WHILE @RowCount > 0
BEGIN
SET @Level = @Level + 1;
INSERT INTO @Tree(Level, ParentTreeID, PageID)
SELECT @Level, t.TreeId, PageURLs.ID
FROM PageURLs
LEFT OUTER JOIN @Tree t ON ISNULL(PageURLs.ParentID,0) = t.PageID AND t.Level = (@Level - 1)
INNER JOIN HTMLContent ON HTMLContent.ID = PageURLs.EntityID
LEFT OUTER JOIN HTMLContent_XREF ON HTMLContent.ID = HTMLContent_XREF.ContentID
WHERE 1=1
AND (
1=1
AND HTMLContent.SiteID = 1
AND PageURLs.[Type] = 'content'
AND HTMLContent.IsMenuItem = 'True'
AND @Level <= 20
)
ORDER BY COALESCE(OrderPriority, 1000), PageKey
;
SET @RowCount = @@ROWCOUNT;
UPDATE t1 SET t1.[Path] = t2.[Path] + STR(t1.TreeID, 10, 0) + '.', t1.PageID_Path = t2.PageID_Path + CAST(t1.PageID AS VARCHAR(10)) + '\' FROM @Tree t1 INNER JOIN @Tree t2 ON t1.ParentTreeID = t2.TreeID WHERE t1.Level = @Level AND t2.PageID_Path NOT LIKE '%' + CAST(t1.PageID AS VARCHAR(10)) + '\%';
DELETE FROM @Tree WHERE PageID_Path IS NULL;
SET @DelCount = @@ROWCOUNT;
SET @RowCount = (@RowCount - @DelCount);
END;
SELECT
[Path], t.PageID, t.Level
, (SELECT COUNT(HTMLContent_XREF1.ID) FROM HTMLContent_XREF AS HTMLContent_XREF1 LEFT JOIN HTMLArticles AS HTMLArticles1 ON HTMLContent_XREF1.ContentID = HTMLArticles1.ContentID LEFT JOIN HTMLContent AS HTMLContent1 ON HTMLContent1.ID = HTMLContent_XREF1.ContentID WHERE HTMLContent_XREF1.ParentContentID = HTMLContent.ID AND (HTMLContent1.IsMenuItem = 'True' OR HTMLContent1.ID IS NULL) AND HTMLArticles1.ID IS NULL) As NumChildren,
HTMLContent.ID,
HTMLContent.PageKey,
HTMLContent.IsMenuItem,
HTMLContent.MenuText,
HTMLContent.MenuURL,
HTMLContent.PageHeading,
HTMLContent.HasArticles,
HTMLContent_XREF.ParentContentID
FROM @Tree t
INNER JOIN PageURLs ON t.PageID = PageURLs.ID
INNER JOIN HTMLContent ON HTMLContent.ID = PageURLs.EntityID
LEFT OUTER JOIN HTMLContent_XREF ON HTMLContent.ID = HTMLContent_XREF.ContentID
WHERE 1=1
ORDER BY [Path]
; show |
- |
0.0156082 |
| 15. |
0.563169 |
DBInterface.GetDataTable; CategoryBase.LoadCategoryFromURL; Category..ctor; CategoryBrowse.Page_Load; show |
StoredProcedure |
[dbo].[PageUrlLoadByPrimaryKey] |
@PageUrl=/gloves/by-material/latex/white-lightning/default.aspx
@Type=CATEGORY
|
0 |
| 16. |
0.5789759 |
DBInterface.get_oSQLDataReader; CategoryBase._FETCH; CategoryBase.LoadCategoryFromURL; Category..ctor; show |
StoredProcedure |
[dbo].[CategoryLoadByPrimaryKey] |
@CategoryId=45
@SiteID=1
@RootID=0
@UserID=00000000-0000-0000-0000-000000000000
|
0.0158069 |
| 17. |
1.5729625 |
DBInterface.GetDataTable; CategoryBase.LoadCategoryFromURL; Category..ctor; CategoryBrowse.Page_Load; show |
StoredProcedure |
[dbo].[PageUrlLoadByPrimaryKey] |
@PageUrl=
@Type=CATEGORY
|
0.0146689 |
| 18. |
1.5739475 |
DBInterface.GetDataTable; BreadcrumbBASE.GetBreadcrumbData; BreadcrumbBASE.GetBreadcrumbFromCurrentPage; BreadcrumbControl.Page_Load; show |
StoredProcedure |
dbo.Breadcrumb |
@PathList=/gloves/default.aspx|/gloves/by-material/default.aspx|/gloves/by-material/latex/default.aspx
@SiteID=1
|
0 |
| 19. |
1.6364779 |
DBInterface.GetDataTable; BaseUser.GetDefaultSearch; UserSession.get_DefaultSearchAttribute; ProductFilterResults.BuildFilters; show |
StoredProcedure |
[dbo].[DefaultSearchAttributeGetByUserID] |
@g_UserID =2208d34f-d535-4cf9-80e9-5d27c31de36f
|
0 |
| 20. |
1.6364779 |
DBInterface.GetDataTable; CategoryBase.LoadCategoryFromURL; Category..ctor; ProductFilterResults.BuildFilters; show |
StoredProcedure |
[dbo].[PageUrlLoadByPrimaryKey] |
@PageUrl=/gloves/by-material/latex/white-lightning/default.aspx
@Type=CATEGORY
|
0 |
| 21. |
1.6364779 |
DBInterface.get_oSQLDataReader; CategoryBase._FETCH; CategoryBase.LoadCategoryFromURL; Category..ctor; show |
StoredProcedure |
[dbo].[CategoryLoadByPrimaryKey] |
@CategoryId=45
@SiteID=1
@RootID=0
@UserID=00000000-0000-0000-0000-000000000000
|
0 |
| 22. |
1.6521034 |
DBInterface.GetDataTable; CategoryBase.LoadCategoryFromURL; Category..ctor; CurrentSearchFilters.LoadAppliedFilters; show |
StoredProcedure |
[dbo].[PageUrlLoadByPrimaryKey] |
@PageUrl=/gloves/by-material/latex/white-lightning/default.aspx
@Type=CATEGORY
|
0 |
| 23. |
1.6521034 |
DBInterface.get_oSQLDataReader; CategoryBase._FETCH; CategoryBase.LoadCategoryFromURL; Category..ctor; show |
StoredProcedure |
[dbo].[CategoryLoadByPrimaryKey] |
@CategoryId=45
@SiteID=1
@RootID=0
@UserID=00000000-0000-0000-0000-000000000000
|
0 |
| 24. |
1.6677286 |
DBInterface.GetDataTable; BaseUser.GetDefaultSearch; UserSession.get_DefaultSearchAttribute; ProductFilterResults.FillSearchResults; show |
StoredProcedure |
[dbo].[DefaultSearchAttributeGetByUserID] |
@g_UserID =2208d34f-d535-4cf9-80e9-5d27c31de36f
|
0 |
| 25. |
2.3661047 |
DBInterface.GetDataSet; SearchBase.getFilteredProductList; ProductFilterResults.FillSearchResults; ProductFilterResults.Page_Load; show |
StoredProcedure |
[dbo].[getFilteredProductListWithPaging] |
@UserID=2208d34f-d535-4cf9-80e9-5d27c31de36f
@PageNumber=1
@PageSize=20
@SortOrder=title
@SessionID=lrtob4omsoaqlw4zwjwjx3es
@SiteID=1
@FilterProductsXML=<filters />
@CategoryId=45
@IncludeSubCategories=0
@MaxProductsToReturn=1000
@AllowMultipleAttributesPerGroup=1
@AllowMultipleExclusionAttributesPerGroup=1
|
0.6506757 |
| 26. |
2.4129752 |
DBInterface.GetDataTable; ProductAttributeFilterBASE.getProductAttributesList; SearchBase.getFilteredProductList; ProductFilterResults.FillSearchResults; show |
StoredProcedure |
[dbo].[getProductAttributesList] |
- |
0.0156152 |
| 27. |
2.6964815 |
DBInterface.GetDataTable; BreadcrumbBASE.GetBreadcrumbData; BreadcrumbBASE.GetBreadcrumbFromCurrentPage; BreadcrumbControl.Page_Load; show |
StoredProcedure |
dbo.Breadcrumb |
@PathList=/gloves/default.aspx|/gloves/by-material/default.aspx|/gloves/by-material/latex/default.aspx
@SiteID=1
|
0 |
| 28. |
2.7277654 |
DBInterface.get_oSQLDataReader; CartItems._FetchCartTotalFromDB; CartItems.FetchCartTotal; Cart.CartTotal; show |
StoredProcedure |
[dbo].[CartItemExtendedTotalSum] |
@UserID=2208d34f-d535-4cf9-80e9-5d27c31de36f
@SiteID=1
|
0 |
|
|
|
|
|
Total DB Execution Time |
0.7479288 |
A family of hand protection products under one roof.