# |
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=laserstardev.braveriversolutions.com
|
0 |
2. |
0 |
DBInterface.get_oSQLDataReader; VirtualSiteProperties.GetVirtualSiteProperties; VirtualSiteProperties..ctor; VirtualCatalogInfoBASE.LoadVirtualCatalog; show |
StoredProcedure |
[dbo].[VirtualSitePropertiesLoadBySiteID] |
@SiteID=1
|
0 |
3. |
0.1045181 |
DBInterface.GetDataTable; FormBuilderBASE.getformIDByPageKey; FormBuilderCtrl.Page_Init; Control.OnInit; show |
Text |
SELECT formID FROM FB_PageKeyMap WHERE PageKey = '/laserstar-tv/default.aspx'; |
- |
0.0022835 |
4. |
0.1262677 |
DBInterface.GetDataTable; FormBuilderBASE.getFormInputs; FormBuilderCtrl.generateFields; FormBuilderCtrl.Page_Init; show |
Text |
SELECT * FROM FB_Input WHERE formID = 0 ORDER BY sequence; |
- |
0.0193202 |
5. |
0.1418986 |
SqlBASE.GetDataTable; HTMLContent.GetHTMLContent; HTMLContentBASE..ctor; HTMLContent..ctor; MasterPage.get_HtmlContent; GetContent.LoadUserControls; GetContent.Page_Init; Control.OnInit; Page.OnInit; Control.InitRecursive; 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 = '/laserstar-tv/default.aspx' show |
- |
0.0156309 |
6. |
0.2367215 |
SqlBASE.GetDataTable; HTMLContent.GetHTMLContent; HTMLContentBASE..ctor; HTMLContent..ctor; GetContent.Page_Load; Control.OnLoad; Control.LoadRecursive; Page.ProcessRequestMain; Page.ProcessRequest; Page.ProcessRequest; 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 = '/laserstar-tv/default.aspx' show |
- |
0 |
7. |
0.2523509 |
SqlBASE.GetDataTable; HTMLContentBASE.GetHTMLArticles; GetContent.Page_Load; Control.OnLoad; Control.LoadRecursive; Page.ProcessRequestMain; Page.ProcessRequest; Page.ProcessRequest; Page.ProcessRequest; CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute; show |
Text |
SELECT HTMLContent.PageKey, HTMLContent.PageHeading, HTMLContent.PageContent, HTMLContent.NumLatestArticles, HTMLContent.Thumbnail, HTMLContent.DateCreated, HTMLArticles.Thumbnail AS ArticleThumbnail, 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 ISNULL(HTMLArticles.Display,1) <> 0 AND HTMLContent.SiteID = 1 AND HTMLContent_XREF.ParentContentID IN (102) AND (HTMLArticles.ExpirationDate IS NULL OR HTMLArticles.ExpirationDate='' OR HTMLArticles.ExpirationDate >= GETDATE()) ORDER BY HtmlContent.DateCreated DESC, HTMLArticles.OrderPriority ASC show |
- |
0.0156294 |
8. |
0.2523509 |
SqlBASE.GetDataTable; HTMLContentBASE.GetHTMLMiscContent; GetContent.Page_Load; Control.OnLoad; Control.LoadRecursive; Page.ProcessRequestMain; Page.ProcessRequest; Page.ProcessRequest; Page.ProcessRequest; CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute; show |
Text |
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Sidebar Quick Links' show |
- |
0 |
9. |
0.2523509 |
SqlBASE.GetDataTable; HTMLContentBASE.GetHTMLMiscContent; GetContent.Page_Load; Control.OnLoad; Control.LoadRecursive; Page.ProcessRequestMain; Page.ProcessRequest; Page.ProcessRequest; Page.ProcessRequest; CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute; show |
Text |
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Sidebar Block 1' |
- |
0 |
10. |
0.2686429 |
DBInterface.GetDataTable; LanguageManager.GetAvailableLanguagesForThisPage; MasterPage.Page_Load; Control.OnLoad; show |
StoredProcedure |
LanguagePageCheck |
@PageUrl=/laserstar-tv/default.aspx
|
0 |
11. |
0.2849203 |
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.0162774 |
12. |
0.3162121 |
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 |
13. |
0.3326119 |
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 |
14. |
0.3326119 |
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 |
15. |
0.3326119 |
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 |
16. |
0.3495706 |
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.0013016 |
17. |
0.3495706 |
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 |
18. |
0.3495706 |
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 |
19. |
0.3495706 |
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 |
20. |
0.3495706 |
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 |
21. |
0.3495706 |
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 |
22. |
0.3495706 |
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 |
23. |
0.3652326 |
DBInterface.GetDataTable; GlobalHTMLMiscContent.AddHTMLMiscContent; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; show |
Text |
SELECT ID FROM HTMLMiscContent_Proposed WHERE SiteID = 1 AND ContentKey = 'Footer Location 5' |
- |
0.015662 |
24. |
0.3652326 |
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 |
25. |
0.3652326 |
DBInterface.GetDataTable; GlobalHTMLMiscContent.AddHTMLMiscContent; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; show |
Text |
SELECT ID FROM HTMLMiscContent_Proposed WHERE SiteID = 1 AND ContentKey = 'Footer Location 6' |
- |
0 |
26. |
0.3808578 |
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 = 102 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.0156252 |
27. |
0.3808578 |
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 = 102 THEN 1 WHEN ID = 102 THEN 2 END AS Sorter FROM HTMLContent WHERE SiteID = 1 AND ID IN (102,102) ORDER BY Sorter show |
- |
0 |
28. |
0.3808578 |
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 |
29. |
0.3808578 |
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 |
30. |
0.3964784 |
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 |
31. |
0.3964784 |
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 |
32. |
0.3964784 |
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 |
33. |
0.3964784 |
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 |
34. |
0.3964784 |
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 |
35. |
0.3964784 |
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 |
36. |
0.3964784 |
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 |
37. |
0.4278789 |
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 |
38. |
0.4440002 |
DBInterface.GetDataTable; BaseUser.GetDefaultSearch; UserSession.get_DefaultSearchAttribute; CatalogGlobalItems.get_oCategoryMenu; show |
StoredProcedure |
[dbo].[DefaultSearchAttributeGetByUserID] |
@g_UserID =d6293b6a-1d07-4923-a61b-c45a5fe9ba14
|
0.0161213 |
39. |
0.4596533 |
DBInterface.get_oSQLDataReader; VirtualSiteProperties.GetVirtualSiteProperties; VirtualSiteProperties..ctor; MegaMenu.LoadMenu; show |
StoredProcedure |
[dbo].[VirtualSitePropertiesLoadBySiteID] |
@SiteID=1
|
0 |
40. |
0.475283 |
DBInterface.GetDataTable; MegaMenu.LoadVideoData; MegaMenu.LoadMenu; MegaMenu.Page_Load; show |
StoredProcedure |
[dbo].[VideoMenu_Load] |
- |
0 |
41. |
0.6649067 |
DBInterface.GetDataTable; MegaMenu.LoadMenu; MegaMenu.Page_Load; Control.OnLoad; show |
StoredProcedure |
[dbo].[Menu_Load] |
SiteID=1 MenuOnly=1
|
0.1896237 |
42. |
0.6805827 |
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 = '/laserstar-tv/default.aspx' show |
- |
0.015676 |
43. |
0.7744868 |
DBInterface.GetDataTable; MegaVideoHome.Page_Load; Control.OnLoad; Control.LoadRecursive; show |
StoredProcedure |
VideoListingHomeVideos |
- |
0.0626696 |
44. |
0.8068328 |
DBInterface.GetDataTable; FeaturedVideos.Page_Load; Control.OnLoad; Control.LoadRecursive; show |
StoredProcedure |
VideoListingGetAllFeatured |
- |
0.032346 |
45. |
0.8855991 |
DBInterface.GetDataTable; VideoListings.BindVideosList; VideoListings.Page_Load; Control.OnLoad; show |
StoredProcedure |
VideoListingSelectAll |
- |
0.0631447 |
46. |
0.9168843 |
SqlBASE.GetDataTable; HTMLContent.GetHTMLContent; HTMLContentBASE..ctor; HTMLContent..ctor; CMSMenu.get_HtmlContent; CMSMenu.LoadMenu; CMSMenu.Page_Load; Control.OnLoad; Control.LoadRecursive; 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 = '/laserstar-tv/default.aspx' show |
- |
0 |
47. |
1.1248578 |
DBInterface.GetDataTable; CMSMenu.LoadMenu; CMSMenu.Page_Load; Control.OnLoad; show |
StoredProcedure |
[dbo].[Menu_Load] |
SiteID=1 MenuOnly=True StartingID=102 OwnersMenu=False
|
0.2079735 |
|
|
|
|
|
Total DB Execution Time |
0.689285 |