# |
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 = '/videologin.aspx' show |
- |
0.0156131 |
2. |
0 |
DBInterface.GetDataTable; LanguageManager.GetAvailableLanguagesForThisPage; MasterPage.Page_Load; Control.OnLoad; show |
StoredProcedure |
LanguagePageCheck |
@PageUrl=/videologin.aspx
|
0 |
3. |
0.0156388 |
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show |
Text |
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Header Social Links' show |
- |
0 |
4. |
0.031257 |
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show |
Text |
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Header Social Links' show |
- |
0 |
5. |
0.0476392 |
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show |
Text |
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Custom Footer Links 1' show |
- |
0 |
6. |
0.0476392 |
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show |
Text |
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Custom Footer Links 2' show |
- |
0 |
7. |
0.0476392 |
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show |
Text |
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Custom Footer Links 3' show |
- |
0 |
8. |
0.063831 |
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show |
Text |
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Custom Footer Links 4' show |
- |
0 |
9. |
0.063831 |
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show |
Text |
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Custom Footer Links 5' show |
- |
0 |
10. |
0.063831 |
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show |
Text |
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Footer Location 1' |
- |
0 |
11. |
0.063831 |
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show |
Text |
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Footer Location 2' |
- |
0 |
12. |
0.063831 |
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show |
Text |
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Footer Location 3' |
- |
0 |
13. |
0.0789178 |
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show |
Text |
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Footer Location 4' |
- |
0.0150868 |
14. |
0.0789178 |
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show |
Text |
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Footer Location 5' |
- |
0 |
15. |
0.0789178 |
DBInterface.GetDataTable; GlobalHTMLMiscContent.AddHTMLMiscContent; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; show |
Text |
SELECT ID FROM HTMLMiscContent_Proposed WHERE SiteID = 1 AND ContentKey = 'Footer Location 5' |
- |
0 |
16. |
0.0789178 |
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show |
Text |
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Footer Location 6' |
- |
0 |
17. |
0.0789178 |
DBInterface.GetDataTable; GlobalHTMLMiscContent.AddHTMLMiscContent; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; show |
Text |
SELECT ID FROM HTMLMiscContent_Proposed WHERE SiteID = 1 AND ContentKey = 'Footer Location 6' |
- |
0 |
18. |
0.0789178 |
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show |
Text |
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Header Phone Number - RI' show |
- |
0 |
19. |
0.0789178 |
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show |
Text |
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Header Phone Number - CA' show |
- |
0 |
20. |
0.0945559 |
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show |
Text |
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Header Phone Number - FL' show |
- |
0.0156381 |
21. |
0.0945559 |
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show |
Text |
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Header Phone Number - RI' show |
- |
0 |
22. |
0.0945559 |
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show |
Text |
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Header Phone Number - CA' show |
- |
0 |
23. |
0.1101982 |
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show |
Text |
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Header Phone Number - FL' show |
- |
0.0156423 |
24. |
0.1258174 |
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 |
25. |
0.1258174 |
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 |
26. |
0.1258174 |
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show |
Text |
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Header - Custom Links' show |
- |
0 |
27. |
0.1414381 |
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show |
Text |
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Header - Custom Links' show |
- |
0 |
28. |
0.1577454 |
DBInterface.GetDataTable; BaseUser.GetDefaultSearch; UserSession.get_DefaultSearchAttribute; CatalogGlobalItems.get_oCategoryMenu; show |
StoredProcedure |
[dbo].[DefaultSearchAttributeGetByUserID] |
@g_UserID =247a3e7c-7e56-4c50-a9ce-83ebb24bd2ed
|
0.0163073 |
29. |
0.1890423 |
DBInterface.get_oSQLDataReader; VirtualSiteProperties.GetVirtualSiteProperties; VirtualSiteProperties..ctor; MegaMenu.LoadMenu; show |
StoredProcedure |
[dbo].[VirtualSitePropertiesLoadBySiteID] |
@SiteID=1
|
0.0155794 |
30. |
0.1890423 |
DBInterface.GetDataTable; MegaMenu.LoadVideoData; MegaMenu.LoadMenu; MegaMenu.Page_Load; show |
StoredProcedure |
[dbo].[VideoMenu_Load] |
- |
0 |
31. |
0.3796954 |
DBInterface.GetDataTable; MegaMenu.LoadMenu; MegaMenu.Page_Load; Control.OnLoad; show |
StoredProcedure |
[dbo].[Menu_Load] |
SiteID=1 MenuOnly=1
|
0.1906531 |
32. |
0.3953649 |
SqlBASE.GetDataTable; HTMLContent.GetHTMLContent; HTMLContentBASE..ctor; HTMLContent..ctor; MegaMenu.get_HtmlContent; MegaMenu.ProcessMenuLevel; MegaMenu.LoadMenu; MegaMenu.Page_Load; Control.OnLoad; Control.LoadRecursive; 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 = '/videologin.aspx' show |
- |
0.0156695 |
|
|
|
|
|
Total DB Execution Time |
0.3001896 |