DBInterface.GetDataTable; VirtualCatalogInfoBASE.LoadVirtualCatalog; VirtualCatalogInfoBASE..ctor; VirtualCatalogInfo..ctor; show
StoredProcedure
[dbo].[VirtualCatalogLoadBySiteDomain]
@SiteDomain=laserstardev.braveriversolutions.com
0.0160362
2.
0
DBInterface.get_oSQLDataReader; VirtualSiteProperties.GetVirtualSiteProperties; VirtualSiteProperties..ctor; VirtualCatalogInfoBASE.LoadVirtualCatalog; show
StoredProcedure
[dbo].[VirtualSitePropertiesLoadBySiteID]
@SiteID=1
0
3.
0.1886844
DBInterface.GetDataTable; FormBuilderBASE.getformIDByPageKey; FormBuilderCtrl.Page_Init; Control.OnInit; show
Text
SELECT formID FROM FB_PageKeyMap WHERE PageKey = '/info/privacy/default.aspx';
-
0.0314155
4.
0.1886844
DBInterface.GetDataTable; FormBuilderBASE.getFormInputs; FormBuilderCtrl.generateFields; FormBuilderCtrl.Page_Init; show
Text
SELECT * FROM FB_Input WHERE formID = 0 ORDER BY sequence;
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 (212) AND (HTMLArticles.ExpirationDate IS NULL OR HTMLArticles.ExpirationDate='' OR HTMLArticles.ExpirationDate >= GETDATE()) ORDER BY HtmlContent.DateCreated DESC, HTMLArticles.OrderPriority ASCshow
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Sidebar Block 1'
-
0
10.
0.3781371
DBInterface.GetDataTable; LanguageManager.GetAvailableLanguagesForThisPage; MasterPage.Page_Load; Control.OnLoad; show
StoredProcedure
LanguagePageCheck
@PageUrl=/info/privacy/default.aspx
0
11.
0.3781371
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
12.
0.3938748
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.4250452
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.4297589
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.0047137
15.
0.4297589
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.4297589
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
17.
0.4297589
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.4297589
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.4297589
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.4297589
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.4474012
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.0019813
22.
0.4474012
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.4474012
DBInterface.GetDataTable; GlobalHTMLMiscContent.AddHTMLMiscContent; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; show
Text
SELECT ID FROM HTMLMiscContent_Proposed WHERE SiteID = 1 AND ContentKey = 'Footer Location 5'
-
0
24.
0.4474012
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.4474012
DBInterface.GetDataTable; GlobalHTMLMiscContent.AddHTMLMiscContent; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; show
Text
SELECT ID FROM HTMLMiscContent_Proposed WHERE SiteID = 1 AND ContentKey = 'Footer Location 6'
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 = 212 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 ASCshow
SELECT ID, PageKey, PageTitle, PageHeading, MenuText, IsMenuItem, CASE WHEN ID = 209 THEN 1 WHEN ID = 212 THEN 2 END AS Sorter FROM HTMLContent WHERE SiteID = 1 AND ID IN (209,212) ORDER BY Sortershow
-
0.0320625
28.
0.6536864
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.6536864
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.6536864
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.6536864
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.6713622
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.0176758
33.
0.6713622
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.6713622
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.PageHeadingshow
SiteID=1
0
35.
0.6713622
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.PageHeadingshow
SiteID=1
0
36.
0.6713622
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.6849303
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.7007973
DBInterface.GetDataTable; BaseUser.GetDefaultSearch; UserSession.get_DefaultSearchAttribute; CatalogGlobalItems.get_oCategoryMenu; show
StoredProcedure
[dbo].[DefaultSearchAttributeGetByUserID]
@g_UserID =f933e26d-30e6-4d25-8075-af9b804f6a14
0.015867
39.
0.7319082
DBInterface.get_oSQLDataReader; VirtualSiteProperties.GetVirtualSiteProperties; VirtualSiteProperties..ctor; MegaMenu.LoadMenu; show
StoredProcedure
[dbo].[VirtualSitePropertiesLoadBySiteID]
@SiteID=1
0
40.
0.7480027
DBInterface.GetDataTable; MegaMenu.LoadVideoData; MegaMenu.LoadMenu; MegaMenu.Page_Load; show
StoredProcedure
[dbo].[VideoMenu_Load]
-
0
41.
0.9998561
DBInterface.GetDataTable; MegaMenu.LoadMenu; MegaMenu.Page_Load; Control.OnLoad; show