# |
Seconds Since First Hit |
Trace |
Command Type |
Command Text |
Parameters |
Execution Time |
1. |
0 |
SqlBASE.GetDataTable; HTMLContentBASE.GetNumLatestArticles; HTMLContentBASE.GetHTMLArticles2; _default.Page_Load; Control.OnLoad; Control.LoadRecursive; Page.ProcessRequestMain; Page.ProcessRequest; Page.ProcessRequest; Page.ProcessRequest; show |
Text |
SELECT HTMLContent.NumLatestArticles FROM HTMLContent WHERE HTMLContent.SiteID = 1 AND HTMLContent.ID = '109' show |
- |
0 |
2. |
0.0313745 |
SqlBASE.GetDataTable; HTMLContentBASE.GetHTMLArticles2; _default.Page_Load; Control.OnLoad; Control.LoadRecursive; Page.ProcessRequestMain; Page.ProcessRequest; Page.ProcessRequest; Page.ProcessRequest; CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute; show |
Text |
SELECT TOP(100) 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 (109) AND (HTMLArticles.ExpirationDate IS NULL OR HTMLArticles.ExpirationDate='' OR HTMLArticles.ExpirationDate >= GETDATE()) ORDER BY HtmlContent.DateCreated DESC, HTMLArticles.OrderPriority ASC show |
- |
0.031184 |
3. |
0.0482149 |
SqlBASE.GetDataTable; HTMLContentBASE.GetPageContentID; _default.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 FROM HTMLContent WHERE SiteID = 1 AND PageKey = '/about/news/default.aspx' |
- |
0.0163201 |
4. |
0.0482149 |
SqlBASE.GetDataTable; HTMLContentBASE.GetNumLatestArticles; HTMLContentBASE.GetHTMLArticles3; _default.Page_Load; Control.OnLoad; Control.LoadRecursive; Page.ProcessRequestMain; Page.ProcessRequest; Page.ProcessRequest; Page.ProcessRequest; show |
Text |
SELECT HTMLContent.NumLatestArticles FROM HTMLContent WHERE HTMLContent.SiteID = 1 AND HTMLContent.ID = '118' show |
- |
0 |
5. |
0.0638733 |
SqlBASE.GetDataTable; HTMLContentBASE.GetHTMLArticles3; _default.Page_Load; Control.OnLoad; Control.LoadRecursive; Page.ProcessRequestMain; Page.ProcessRequest; Page.ProcessRequest; Page.ProcessRequest; CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute; show |
Text |
SELECT TOP(100) 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 (118) AND (HTMLArticles.ExpirationDate IS NULL OR HTMLArticles.ExpirationDate='' OR HTMLArticles.ExpirationDate >= GETDATE()) ORDER BY HtmlContent.DateCreated DESC, HTMLArticles.OrderPriority ASC show |
- |
0.0156584 |
6. |
0.1263667 |
SqlBASE.GetDataTable; HTMLFeaturedBASE.GetFeatured; _default.Page_Load; Control.OnLoad; show |
Text |
SELECT HTMLFeaturedBlocks.ImageWidth, HTMLFeaturedBlocks.ImageHeight, HTMLFeaturedBlocks.ImageCornerRadius, HTMLFeaturedBlocks.ImageCornerColor, HTMLFeaturedBlocks.BlockName, '' AS FeaturedImageSrcPath, '' AS FeaturedImageOutputPath, '' AS ArticleThumbnailSrcPath, '' AS ArticleThumbnailOutputPath, '' AS PageThumbnailSrcPath, '' AS PageThumbnailOutputPath, '' AS FeaturedImageResized, HTMLContent.ID, HTMLContent.PageKey, HTMLContent.PageHeading, HTMLContent.PageContent, HTMLContent.FeaturedImage, HTMLContent.FeaturedHeading, HTMLContent.FeaturedPreview, HTMLContent.Thumbnail, HTMLArticles.ExpirationDate, HTMLArticles.StartDate, HTMLArticles.EndDate, HTMLArticles.Thumbnail AS ArticleThumbnail FROM HTMLContent INNER JOIN HTMLFeaturedBlocks ON HTMLFeaturedBlocks.ID = @BlockID LEFT OUTER JOIN HTMLArticles ON HTMLArticles.ContentID = HTMLContent.ID WHERE ISNULL(HTMLArticles.Display,1) <> 0 AND (HTMLArticles.ExpirationDate IS NULL OR HTMLArticles.ExpirationDate >= GETDATE()) AND ISNULL(HTMLFeaturedBlocks.Enabled,1) = 1 AND CHARINDEX(',' + CAST(@BlockID AS VARCHAR(100)) + ',',',' + HTMLContent.FeaturedBlocks + ',') > 0 AND HTMLContent.SiteID = 1 ORDER BY HTMLContent.FeaturedOrderPriority, HTMLContent.ID show |
BlockID=1
|
0.0156265 |
7. |
0.1576162 |
SqlBASE.GetDataTable; HTMLFeaturedBASE.GetFeatured; _default.Page_Load; Control.OnLoad; show |
Text |
SELECT HTMLFeaturedBlocks.ImageWidth, HTMLFeaturedBlocks.ImageHeight, HTMLFeaturedBlocks.ImageCornerRadius, HTMLFeaturedBlocks.ImageCornerColor, HTMLFeaturedBlocks.BlockName, '' AS FeaturedImageSrcPath, '' AS FeaturedImageOutputPath, '' AS ArticleThumbnailSrcPath, '' AS ArticleThumbnailOutputPath, '' AS PageThumbnailSrcPath, '' AS PageThumbnailOutputPath, '' AS FeaturedImageResized, HTMLContent.ID, HTMLContent.PageKey, HTMLContent.PageHeading, HTMLContent.PageContent, HTMLContent.FeaturedImage, HTMLContent.FeaturedHeading, HTMLContent.FeaturedPreview, HTMLContent.Thumbnail, HTMLArticles.ExpirationDate, HTMLArticles.StartDate, HTMLArticles.EndDate, HTMLArticles.Thumbnail AS ArticleThumbnail FROM HTMLContent INNER JOIN HTMLFeaturedBlocks ON HTMLFeaturedBlocks.ID = @BlockID LEFT OUTER JOIN HTMLArticles ON HTMLArticles.ContentID = HTMLContent.ID WHERE ISNULL(HTMLArticles.Display,1) <> 0 AND (HTMLArticles.ExpirationDate IS NULL OR HTMLArticles.ExpirationDate >= GETDATE()) AND ISNULL(HTMLFeaturedBlocks.Enabled,1) = 1 AND CHARINDEX(',' + CAST(@BlockID AS VARCHAR(100)) + ',',',' + HTMLContent.FeaturedBlocks + ',') > 0 AND HTMLContent.SiteID = 1 ORDER BY HTMLContent.FeaturedOrderPriority, HTMLContent.ID show |
BlockID=2
|
0.0156193 |
8. |
0.1743451 |
SqlBASE.GetDataTable; HTMLFeaturedBASE.GetFeatured; _default.Page_Load; Control.OnLoad; show |
Text |
SELECT HTMLFeaturedBlocks.ImageWidth, HTMLFeaturedBlocks.ImageHeight, HTMLFeaturedBlocks.ImageCornerRadius, HTMLFeaturedBlocks.ImageCornerColor, HTMLFeaturedBlocks.BlockName, '' AS FeaturedImageSrcPath, '' AS FeaturedImageOutputPath, '' AS ArticleThumbnailSrcPath, '' AS ArticleThumbnailOutputPath, '' AS PageThumbnailSrcPath, '' AS PageThumbnailOutputPath, '' AS FeaturedImageResized, HTMLContent.ID, HTMLContent.PageKey, HTMLContent.PageHeading, HTMLContent.PageContent, HTMLContent.FeaturedImage, HTMLContent.FeaturedHeading, HTMLContent.FeaturedPreview, HTMLContent.Thumbnail, HTMLArticles.ExpirationDate, HTMLArticles.StartDate, HTMLArticles.EndDate, HTMLArticles.Thumbnail AS ArticleThumbnail FROM HTMLContent INNER JOIN HTMLFeaturedBlocks ON HTMLFeaturedBlocks.ID = @BlockID LEFT OUTER JOIN HTMLArticles ON HTMLArticles.ContentID = HTMLContent.ID WHERE ISNULL(HTMLArticles.Display,1) <> 0 AND (HTMLArticles.ExpirationDate IS NULL OR HTMLArticles.ExpirationDate >= GETDATE()) AND ISNULL(HTMLFeaturedBlocks.Enabled,1) = 1 AND CHARINDEX(',' + CAST(@BlockID AS VARCHAR(100)) + ',',',' + HTMLContent.FeaturedBlocks + ',') > 0 AND HTMLContent.SiteID = 1 ORDER BY HTMLContent.FeaturedOrderPriority, HTMLContent.ID show |
BlockID=3
|
0 |
9. |
0.1743451 |
SqlBASE.GetDataTable; HTMLFeaturedBASE.GetFeatured; _default.Page_Load; Control.OnLoad; show |
Text |
SELECT HTMLFeaturedBlocks.ImageWidth, HTMLFeaturedBlocks.ImageHeight, HTMLFeaturedBlocks.ImageCornerRadius, HTMLFeaturedBlocks.ImageCornerColor, HTMLFeaturedBlocks.BlockName, '' AS FeaturedImageSrcPath, '' AS FeaturedImageOutputPath, '' AS ArticleThumbnailSrcPath, '' AS ArticleThumbnailOutputPath, '' AS PageThumbnailSrcPath, '' AS PageThumbnailOutputPath, '' AS FeaturedImageResized, HTMLContent.ID, HTMLContent.PageKey, HTMLContent.PageHeading, HTMLContent.PageContent, HTMLContent.FeaturedImage, HTMLContent.FeaturedHeading, HTMLContent.FeaturedPreview, HTMLContent.Thumbnail, HTMLArticles.ExpirationDate, HTMLArticles.StartDate, HTMLArticles.EndDate, HTMLArticles.Thumbnail AS ArticleThumbnail FROM HTMLContent INNER JOIN HTMLFeaturedBlocks ON HTMLFeaturedBlocks.ID = @BlockID LEFT OUTER JOIN HTMLArticles ON HTMLArticles.ContentID = HTMLContent.ID WHERE ISNULL(HTMLArticles.Display,1) <> 0 AND (HTMLArticles.ExpirationDate IS NULL OR HTMLArticles.ExpirationDate >= GETDATE()) AND ISNULL(HTMLFeaturedBlocks.Enabled,1) = 1 AND CHARINDEX(',' + CAST(@BlockID AS VARCHAR(100)) + ',',',' + HTMLContent.FeaturedBlocks + ',') > 0 AND HTMLContent.SiteID = 1 ORDER BY HTMLContent.FeaturedOrderPriority, HTMLContent.ID show |
BlockID=4
|
0 |
10. |
0.1897202 |
SqlBASE.GetDataTable; HTMLFeaturedBASE.GetFeatured; _default.Page_Load; Control.OnLoad; show |
Text |
SELECT HTMLFeaturedBlocks.ImageWidth, HTMLFeaturedBlocks.ImageHeight, HTMLFeaturedBlocks.ImageCornerRadius, HTMLFeaturedBlocks.ImageCornerColor, HTMLFeaturedBlocks.BlockName, '' AS FeaturedImageSrcPath, '' AS FeaturedImageOutputPath, '' AS ArticleThumbnailSrcPath, '' AS ArticleThumbnailOutputPath, '' AS PageThumbnailSrcPath, '' AS PageThumbnailOutputPath, '' AS FeaturedImageResized, HTMLContent.ID, HTMLContent.PageKey, HTMLContent.PageHeading, HTMLContent.PageContent, HTMLContent.FeaturedImage, HTMLContent.FeaturedHeading, HTMLContent.FeaturedPreview, HTMLContent.Thumbnail, HTMLArticles.ExpirationDate, HTMLArticles.StartDate, HTMLArticles.EndDate, HTMLArticles.Thumbnail AS ArticleThumbnail FROM HTMLContent INNER JOIN HTMLFeaturedBlocks ON HTMLFeaturedBlocks.ID = @BlockID LEFT OUTER JOIN HTMLArticles ON HTMLArticles.ContentID = HTMLContent.ID WHERE ISNULL(HTMLArticles.Display,1) <> 0 AND (HTMLArticles.ExpirationDate IS NULL OR HTMLArticles.ExpirationDate >= GETDATE()) AND ISNULL(HTMLFeaturedBlocks.Enabled,1) = 1 AND CHARINDEX(',' + CAST(@BlockID AS VARCHAR(100)) + ',',',' + HTMLContent.FeaturedBlocks + ',') > 0 AND HTMLContent.SiteID = 1 ORDER BY HTMLContent.FeaturedOrderPriority, HTMLContent.ID show |
BlockID=5
|
0 |
11. |
0.2209772 |
SqlBASE.GetDataTable; HTMLFeaturedBASE.GetFeatured; _default.Page_Load; Control.OnLoad; show |
Text |
SELECT HTMLFeaturedBlocks.ImageWidth, HTMLFeaturedBlocks.ImageHeight, HTMLFeaturedBlocks.ImageCornerRadius, HTMLFeaturedBlocks.ImageCornerColor, HTMLFeaturedBlocks.BlockName, '' AS FeaturedImageSrcPath, '' AS FeaturedImageOutputPath, '' AS ArticleThumbnailSrcPath, '' AS ArticleThumbnailOutputPath, '' AS PageThumbnailSrcPath, '' AS PageThumbnailOutputPath, '' AS FeaturedImageResized, HTMLContent.ID, HTMLContent.PageKey, HTMLContent.PageHeading, HTMLContent.PageContent, HTMLContent.FeaturedImage, HTMLContent.FeaturedHeading, HTMLContent.FeaturedPreview, HTMLContent.Thumbnail, HTMLArticles.ExpirationDate, HTMLArticles.StartDate, HTMLArticles.EndDate, HTMLArticles.Thumbnail AS ArticleThumbnail FROM HTMLContent INNER JOIN HTMLFeaturedBlocks ON HTMLFeaturedBlocks.ID = @BlockID LEFT OUTER JOIN HTMLArticles ON HTMLArticles.ContentID = HTMLContent.ID WHERE ISNULL(HTMLArticles.Display,1) <> 0 AND (HTMLArticles.ExpirationDate IS NULL OR HTMLArticles.ExpirationDate >= GETDATE()) AND ISNULL(HTMLFeaturedBlocks.Enabled,1) = 1 AND CHARINDEX(',' + CAST(@BlockID AS VARCHAR(100)) + ',',',' + HTMLContent.FeaturedBlocks + ',') > 0 AND HTMLContent.SiteID = 1 ORDER BY HTMLContent.FeaturedOrderPriority, HTMLContent.ID show |
BlockID=6
|
0.0156317 |
12. |
0.2522267 |
SqlBASE.GetDataTable; HTMLFeaturedBASE.GetFeatured; _default.Page_Load; Control.OnLoad; show |
Text |
SELECT HTMLFeaturedBlocks.ImageWidth, HTMLFeaturedBlocks.ImageHeight, HTMLFeaturedBlocks.ImageCornerRadius, HTMLFeaturedBlocks.ImageCornerColor, HTMLFeaturedBlocks.BlockName, '' AS FeaturedImageSrcPath, '' AS FeaturedImageOutputPath, '' AS ArticleThumbnailSrcPath, '' AS ArticleThumbnailOutputPath, '' AS PageThumbnailSrcPath, '' AS PageThumbnailOutputPath, '' AS FeaturedImageResized, HTMLContent.ID, HTMLContent.PageKey, HTMLContent.PageHeading, HTMLContent.PageContent, HTMLContent.FeaturedImage, HTMLContent.FeaturedHeading, HTMLContent.FeaturedPreview, HTMLContent.Thumbnail, HTMLArticles.ExpirationDate, HTMLArticles.StartDate, HTMLArticles.EndDate, HTMLArticles.Thumbnail AS ArticleThumbnail FROM HTMLContent INNER JOIN HTMLFeaturedBlocks ON HTMLFeaturedBlocks.ID = @BlockID LEFT OUTER JOIN HTMLArticles ON HTMLArticles.ContentID = HTMLContent.ID WHERE ISNULL(HTMLArticles.Display,1) <> 0 AND (HTMLArticles.ExpirationDate IS NULL OR HTMLArticles.ExpirationDate >= GETDATE()) AND ISNULL(HTMLFeaturedBlocks.Enabled,1) = 1 AND CHARINDEX(',' + CAST(@BlockID AS VARCHAR(100)) + ',',',' + HTMLContent.FeaturedBlocks + ',') > 0 AND HTMLContent.SiteID = 1 ORDER BY HTMLContent.FeaturedOrderPriority, HTMLContent.ID show |
BlockID=7
|
0.0312495 |
13. |
0.2685082 |
SqlBASE.GetDataTable; HTMLFeaturedBASE.GetFeatured; _default.Page_Load; Control.OnLoad; show |
Text |
SELECT HTMLFeaturedBlocks.ImageWidth, HTMLFeaturedBlocks.ImageHeight, HTMLFeaturedBlocks.ImageCornerRadius, HTMLFeaturedBlocks.ImageCornerColor, HTMLFeaturedBlocks.BlockName, '' AS FeaturedImageSrcPath, '' AS FeaturedImageOutputPath, '' AS ArticleThumbnailSrcPath, '' AS ArticleThumbnailOutputPath, '' AS PageThumbnailSrcPath, '' AS PageThumbnailOutputPath, '' AS FeaturedImageResized, HTMLContent.ID, HTMLContent.PageKey, HTMLContent.PageHeading, HTMLContent.PageContent, HTMLContent.FeaturedImage, HTMLContent.FeaturedHeading, HTMLContent.FeaturedPreview, HTMLContent.Thumbnail, HTMLArticles.ExpirationDate, HTMLArticles.StartDate, HTMLArticles.EndDate, HTMLArticles.Thumbnail AS ArticleThumbnail FROM HTMLContent INNER JOIN HTMLFeaturedBlocks ON HTMLFeaturedBlocks.ID = @BlockID LEFT OUTER JOIN HTMLArticles ON HTMLArticles.ContentID = HTMLContent.ID WHERE ISNULL(HTMLArticles.Display,1) <> 0 AND (HTMLArticles.ExpirationDate IS NULL OR HTMLArticles.ExpirationDate >= GETDATE()) AND ISNULL(HTMLFeaturedBlocks.Enabled,1) = 1 AND CHARINDEX(',' + CAST(@BlockID AS VARCHAR(100)) + ',',',' + HTMLContent.FeaturedBlocks + ',') > 0 AND HTMLContent.SiteID = 1 ORDER BY HTMLContent.FeaturedOrderPriority, HTMLContent.ID show |
BlockID=8
|
0.0162815 |
14. |
0.3009966 |
SqlBASE.GetDataTable; HTMLFeaturedBASE.GetFeatured; _default.Page_Load; Control.OnLoad; show |
Text |
SELECT HTMLFeaturedBlocks.ImageWidth, HTMLFeaturedBlocks.ImageHeight, HTMLFeaturedBlocks.ImageCornerRadius, HTMLFeaturedBlocks.ImageCornerColor, HTMLFeaturedBlocks.BlockName, '' AS FeaturedImageSrcPath, '' AS FeaturedImageOutputPath, '' AS ArticleThumbnailSrcPath, '' AS ArticleThumbnailOutputPath, '' AS PageThumbnailSrcPath, '' AS PageThumbnailOutputPath, '' AS FeaturedImageResized, HTMLContent.ID, HTMLContent.PageKey, HTMLContent.PageHeading, HTMLContent.PageContent, HTMLContent.FeaturedImage, HTMLContent.FeaturedHeading, HTMLContent.FeaturedPreview, HTMLContent.Thumbnail, HTMLArticles.ExpirationDate, HTMLArticles.StartDate, HTMLArticles.EndDate, HTMLArticles.Thumbnail AS ArticleThumbnail FROM HTMLContent INNER JOIN HTMLFeaturedBlocks ON HTMLFeaturedBlocks.ID = @BlockID LEFT OUTER JOIN HTMLArticles ON HTMLArticles.ContentID = HTMLContent.ID WHERE ISNULL(HTMLArticles.Display,1) <> 0 AND (HTMLArticles.ExpirationDate IS NULL OR HTMLArticles.ExpirationDate >= GETDATE()) AND ISNULL(HTMLFeaturedBlocks.Enabled,1) = 1 AND CHARINDEX(',' + CAST(@BlockID AS VARCHAR(100)) + ',',',' + HTMLContent.FeaturedBlocks + ',') > 0 AND HTMLContent.SiteID = 1 ORDER BY HTMLContent.FeaturedOrderPriority, HTMLContent.ID show |
BlockID=9
|
0.0156619 |
15. |
0.3322427 |
SqlBASE.GetDataTable; HTMLFeaturedBASE.GetFeatured; _default.Page_Load; Control.OnLoad; show |
Text |
SELECT HTMLFeaturedBlocks.ImageWidth, HTMLFeaturedBlocks.ImageHeight, HTMLFeaturedBlocks.ImageCornerRadius, HTMLFeaturedBlocks.ImageCornerColor, HTMLFeaturedBlocks.BlockName, '' AS FeaturedImageSrcPath, '' AS FeaturedImageOutputPath, '' AS ArticleThumbnailSrcPath, '' AS ArticleThumbnailOutputPath, '' AS PageThumbnailSrcPath, '' AS PageThumbnailOutputPath, '' AS FeaturedImageResized, HTMLContent.ID, HTMLContent.PageKey, HTMLContent.PageHeading, HTMLContent.PageContent, HTMLContent.FeaturedImage, HTMLContent.FeaturedHeading, HTMLContent.FeaturedPreview, HTMLContent.Thumbnail, HTMLArticles.ExpirationDate, HTMLArticles.StartDate, HTMLArticles.EndDate, HTMLArticles.Thumbnail AS ArticleThumbnail FROM HTMLContent INNER JOIN HTMLFeaturedBlocks ON HTMLFeaturedBlocks.ID = @BlockID LEFT OUTER JOIN HTMLArticles ON HTMLArticles.ContentID = HTMLContent.ID WHERE ISNULL(HTMLArticles.Display,1) <> 0 AND (HTMLArticles.ExpirationDate IS NULL OR HTMLArticles.ExpirationDate >= GETDATE()) AND ISNULL(HTMLFeaturedBlocks.Enabled,1) = 1 AND CHARINDEX(',' + CAST(@BlockID AS VARCHAR(100)) + ',',',' + HTMLContent.FeaturedBlocks + ',') > 0 AND HTMLContent.SiteID = 1 ORDER BY HTMLContent.FeaturedOrderPriority, HTMLContent.ID show |
BlockID=10
|
0.0312461 |
16. |
0.3798779 |
SqlBASE.GetDataTable; HTMLFeaturedBASE.GetFeatured; _default.Page_Load; Control.OnLoad; show |
Text |
SELECT HTMLFeaturedBlocks.ImageWidth, HTMLFeaturedBlocks.ImageHeight, HTMLFeaturedBlocks.ImageCornerRadius, HTMLFeaturedBlocks.ImageCornerColor, HTMLFeaturedBlocks.BlockName, '' AS FeaturedImageSrcPath, '' AS FeaturedImageOutputPath, '' AS ArticleThumbnailSrcPath, '' AS ArticleThumbnailOutputPath, '' AS PageThumbnailSrcPath, '' AS PageThumbnailOutputPath, '' AS FeaturedImageResized, HTMLContent.ID, HTMLContent.PageKey, HTMLContent.PageHeading, HTMLContent.PageContent, HTMLContent.FeaturedImage, HTMLContent.FeaturedHeading, HTMLContent.FeaturedPreview, HTMLContent.Thumbnail, HTMLArticles.ExpirationDate, HTMLArticles.StartDate, HTMLArticles.EndDate, HTMLArticles.Thumbnail AS ArticleThumbnail FROM HTMLContent INNER JOIN HTMLFeaturedBlocks ON HTMLFeaturedBlocks.ID = @BlockID LEFT OUTER JOIN HTMLArticles ON HTMLArticles.ContentID = HTMLContent.ID WHERE ISNULL(HTMLArticles.Display,1) <> 0 AND (HTMLArticles.ExpirationDate IS NULL OR HTMLArticles.ExpirationDate >= GETDATE()) AND ISNULL(HTMLFeaturedBlocks.Enabled,1) = 1 AND CHARINDEX(',' + CAST(@BlockID AS VARCHAR(100)) + ',',',' + HTMLContent.FeaturedBlocks + ',') > 0 AND HTMLContent.SiteID = 1 ORDER BY HTMLContent.FeaturedOrderPriority, HTMLContent.ID show |
BlockID=11
|
0.0320077 |
17. |
0.411157 |
SqlBASE.GetDataTable; HTMLFeaturedBASE.GetFeatured; _default.Page_Load; Control.OnLoad; show |
Text |
SELECT HTMLFeaturedBlocks.ImageWidth, HTMLFeaturedBlocks.ImageHeight, HTMLFeaturedBlocks.ImageCornerRadius, HTMLFeaturedBlocks.ImageCornerColor, HTMLFeaturedBlocks.BlockName, '' AS FeaturedImageSrcPath, '' AS FeaturedImageOutputPath, '' AS ArticleThumbnailSrcPath, '' AS ArticleThumbnailOutputPath, '' AS PageThumbnailSrcPath, '' AS PageThumbnailOutputPath, '' AS FeaturedImageResized, HTMLContent.ID, HTMLContent.PageKey, HTMLContent.PageHeading, HTMLContent.PageContent, HTMLContent.FeaturedImage, HTMLContent.FeaturedHeading, HTMLContent.FeaturedPreview, HTMLContent.Thumbnail, HTMLArticles.ExpirationDate, HTMLArticles.StartDate, HTMLArticles.EndDate, HTMLArticles.Thumbnail AS ArticleThumbnail FROM HTMLContent INNER JOIN HTMLFeaturedBlocks ON HTMLFeaturedBlocks.ID = @BlockID LEFT OUTER JOIN HTMLArticles ON HTMLArticles.ContentID = HTMLContent.ID WHERE ISNULL(HTMLArticles.Display,1) <> 0 AND (HTMLArticles.ExpirationDate IS NULL OR HTMLArticles.ExpirationDate >= GETDATE()) AND ISNULL(HTMLFeaturedBlocks.Enabled,1) = 1 AND CHARINDEX(',' + CAST(@BlockID AS VARCHAR(100)) + ',',',' + HTMLContent.FeaturedBlocks + ',') > 0 AND HTMLContent.SiteID = 1 ORDER BY HTMLContent.FeaturedOrderPriority, HTMLContent.ID show |
BlockID=12
|
0.0156583 |
18. |
0.679761 |
DBInterface.GetDataTable; _default.GetHomepageSlideshow; _default.Page_Load; Control.OnLoad; show |
StoredProcedure |
Slideshow_LoadForHomePage |
@SiteId=1
|
0.268604 |
19. |
0.679761 |
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 = '/default.aspx' show |
- |
0 |
20. |
0.7117398 |
DBInterface.GetDataTable; LanguageManager.GetAvailableLanguagesForThisPage; MasterPage.Page_Load; Control.OnLoad; show |
StoredProcedure |
LanguagePageCheck |
@PageUrl=/default.aspx
|
0.0319788 |
21. |
0.7450263 |
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 |
22. |
0.7606866 |
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 |
23. |
0.7763095 |
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 |
24. |
0.7763095 |
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 |
25. |
0.7763095 |
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 |
26. |
0.7925639 |
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.0162544 |
27. |
0.7925639 |
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 |
28. |
0.7925639 |
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 |
29. |
0.7925639 |
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 |
30. |
0.7925639 |
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 |
31. |
0.7925639 |
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 |
32. |
0.7925639 |
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 |
33. |
0.7925639 |
DBInterface.GetDataTable; GlobalHTMLMiscContent.AddHTMLMiscContent; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; show |
Text |
SELECT ID FROM HTMLMiscContent_Proposed WHERE SiteID = 1 AND ContentKey = 'Footer Location 5' |
- |
0 |
34. |
0.8082172 |
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.0156533 |
35. |
0.8082172 |
DBInterface.GetDataTable; GlobalHTMLMiscContent.AddHTMLMiscContent; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; show |
Text |
SELECT ID FROM HTMLMiscContent_Proposed WHERE SiteID = 1 AND ContentKey = 'Footer Location 6' |
- |
0 |
36. |
0.8082172 |
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 |
37. |
0.8082172 |
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 |
38. |
0.8082172 |
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 |
39. |
0.8082172 |
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 |
40. |
0.8082172 |
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 |
41. |
0.8082172 |
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 |
42. |
0.8246362 |
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.016419 |
43. |
0.8246362 |
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 |
44. |
0.8246362 |
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 |
45. |
0.8402903 |
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 |
46. |
0.8715468 |
DBInterface.GetDataTable; BaseUser.GetDefaultSearch; UserSession.get_DefaultSearchAttribute; CatalogGlobalItems.get_oCategoryMenu; show |
StoredProcedure |
[dbo].[DefaultSearchAttributeGetByUserID] |
@g_UserID =01c5da11-b83b-477d-b2d9-54e077914754
|
0.0312565 |
47. |
0.9184186 |
DBInterface.get_oSQLDataReader; VirtualSiteProperties.GetVirtualSiteProperties; VirtualSiteProperties..ctor; MegaMenu.LoadMenu; show |
StoredProcedure |
[dbo].[VirtualSitePropertiesLoadBySiteID] |
@SiteID=1
|
0.0312475 |
48. |
0.9352501 |
DBInterface.GetDataTable; MegaMenu.LoadVideoData; MegaMenu.LoadMenu; MegaMenu.Page_Load; show |
StoredProcedure |
[dbo].[VideoMenu_Load] |
- |
0 |
49. |
1.2820738 |
DBInterface.GetDataTable; MegaMenu.LoadMenu; MegaMenu.Page_Load; Control.OnLoad; show |
StoredProcedure |
[dbo].[Menu_Load] |
SiteID=1 MenuOnly=1
|
0.3468237 |
50. |
1.2820738 |
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 = '/default.aspx' show |
- |
0 |
|
|
|
|
|
Total DB Execution Time |
1.0103822 |