# |
Seconds Since First Hit |
Trace |
Command Type |
Command Text |
Parameters |
Execution Time |
1. |
0 |
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) HTMLArticles.ID AS ArticleID, HTMLContent.ID, PageTitle, PageMetaDesc, PageMetaKwords, PageHeading, PageContent, PageContent2, PageContent3, PageContent4, PageContent5, PageContent6, StartDate, EndDate, HTMLContent.Thumbnail, NumLatestArticles, HasArticles, UserControl, COALESCE(PageLayout,0) As PageLayout FROM HTMLContent LEFT OUTER JOIN HTMLArticles ON HTMLContent.ID = HTMLArticles.ContentID WHERE HTMLContent.SiteID = 1 AND PageKey = '/account/login/default.aspx' show |
- |
0.0270362 |
2. |
0.1496135 |
SqlBASE.GetDataTable; HTMLContentBASE.GetRouteToContentID; HTMLContentBASE.GetBreadCrumbTrail; HTMLContentBASE.FillCMSLiteral; HTMLContentBASE.FillCMSLiterals; MasterPage.Page_Load; Control.OnLoad; Control.LoadRecursive; Control.LoadRecursive; Page.ProcessRequestMain; show |
Text |
WITH CatPath (ParentContentID, ContentID, Iteration) AS ( SELECT HTMLContent_XREF.ParentContentID, HTMLContent_XREF.ContentID, 0 FROM HTMLContent_XREF INNER JOIN HTMLContent ON HTMLContent.ID = HTMLContent_XREF.ContentID INNER JOIN HTMLContent AS HTMLContent_1 ON HTMLContent_1.ID = HTMLContent_XREF.ParentContentID WHERE ContentID = 0 UNION ALL SELECT a.ParentContentID, a.ContentID, b.Iteration + 1 FROM HTMLContent_XREF AS a INNER JOIN HTMLContent AS c ON c.ID=a.ContentID INNER JOIN HTMLContent AS d ON d.ID = a.ParentContentID INNER JOIN CatPath AS b ON a.ContentID = b.ParentContentID ) SELECT TOP 20 ParentContentID, ContentID, Iteration FROM CatPath ORDER BY Iteration ASC show |
- |
0.1496135 |
3. |
0.2043383 |
SqlBASE.GetDataTable; HTMLContentBASE.GetBreadCrumbTrail; HTMLContentBASE.FillCMSLiteral; HTMLContentBASE.FillCMSLiterals; MasterPage.Page_Load; Control.OnLoad; Control.LoadRecursive; Control.LoadRecursive; Page.ProcessRequestMain; Page.ProcessRequest; show |
Text |
SELECT ID, PageKey, PageTitle, PageHeading, MenuText, IsMenuItem, CASE WHEN ID = 0 THEN 1 WHEN ID = 0 THEN 2 END AS Sorter FROM HTMLContent WHERE SiteID = 1 AND ID IN (0,0) ORDER BY Sorter show |
- |
0.0547248 |
4. |
0.2093307 |
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.0049924 |
5. |
0.2119664 |
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.0021181 |
6. |
0.2138169 |
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.0018505 |
7. |
0.2154416 |
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.0016247 |
8. |
0.2169604 |
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.0004818 |
9. |
0.2178389 |
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.0008785 |
10. |
0.2203511 |
DBInterface.GetDataTable; BaseUser.GetDefaultSearch; UserSession.get_DefaultSearchAttribute; CatalogGlobalItems.get_oCategoryMenu; show |
StoredProcedure |
[dbo].[DefaultSearchAttributeGetByUserID] |
@g_UserID =488147ee-effe-4d2e-94e6-bdf25cb2ed5b
|
0.0025122 |
11. |
0.5167061 |
SqlBASE.GetDataTable; EventCalendarBASE.GetChildIDs; EventCalendar.SetData; EventCalendar.Page_Load; Control.OnLoad; Control.LoadRecursive; Control.LoadRecursive; Control.LoadRecursive; Control.LoadRecursive; Control.LoadRecursive; show |
Text |
SELECT ContentID FROM HTMLContent_XREF WHERE ParentContentID IN (84) |
- |
0.0451509 |
12. |
0.5427434 |
SqlBASE.GetDataTable; EventCalendarBASE.GetMonthDataTable; EventCalendar.SetData; EventCalendar.Page_Load; Control.OnLoad; Control.LoadRecursive; Control.LoadRecursive; Control.LoadRecursive; Control.LoadRecursive; Control.LoadRecursive; show |
Text |
SELECT HTMLContent.PageKey, HTMLContent.PageHeading, HTMLContent.PageContent, HTMLContent.NumLatestArticles, HTMLArticles.Thumbnail, HTMLArticles.StartDate, HTMLArticles.EndDate FROM HTMLContent INNER JOIN HTMLContent_XREF ON HTMLContent.ID = HTMLContent_XREF.ContentID INNER JOIN HTMLArticles ON HTMLContent.ID = HTMLArticles.ContentID WHERE HTMLArticles.Display <> 0 AND Month(HTMLArticles.StartDate) = 4 AND HTMLContent_XREF.ParentContentID IN (84) AND HTMLContent.SiteID = 1 show |
- |
0.0260373 |
13. |
0.5509824 |
DBInterface.get_oSQLDataReader; CartItems._FetchCartTotalFromDB; CartItems.FetchCartTotal; Cart.CartTotal; show |
StoredProcedure |
[dbo].[CartItemExtendedTotalSum] |
@UserID=488147ee-effe-4d2e-94e6-bdf25cb2ed5b @SiteID=1
|
0 |
|
|
|
|
|
Total DB Execution Time |
0.3170209 |