# |
Seconds Since First Hit |
Trace |
Command Type |
Command Text |
Parameters |
Execution Time |
1. |
0 |
DBInterface.GetDataTable; _default.GetSlideShowPath; _default.GetHomepageSlideshow; _default.Page_Load; show |
StoredProcedure |
[dbo].[GetHomepageSlider] |
@SiteID=1
|
0 |
2. |
0.0156287 |
DBInterface.GetDataTable; HTMLContent.GetHTMLContent; HTMLContent..ctor; MasterPage.get_HtmlContent; 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 |
3. |
0.0156287 |
DBInterface.GetDataTable; BaseUser.GetDefaultSearch; UserSession.get_DefaultSearchAttribute; PageManager.get_CategoryMenu; show |
StoredProcedure |
[dbo].[DefaultSearchAttributeGetByUserID] |
@g_UserID =abbd5cd8-156e-452a-8cae-dcbe6eb4f7c1
|
0 |
4. |
0.0781669 |
DBInterface.GetDataTable; HTMLFeatured.GetFeatured; FeaturedContent_HPtop.LoadFeaturedBlock; FeaturedContent_HPtop.Page_Load; show |
Text |
SELECT TOP(3) 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.DateCreated, HTMLContent.ID show |
BlockID=4
|
0.0156539 |
5. |
0.1406476 |
DBInterface.GetDataSet; ProductManager.GetAllFeatured; Featured.LoadFeatured; Featured.Page_Load; show |
StoredProcedure |
[dbo].[Products_LoadAllFeatured] |
@UserID=abbd5cd8-156e-452a-8cae-dcbe6eb4f7c1 @SiteID=1 @MaxProductsToReturn=8
|
0.0156194 |
6. |
0.3906587 |
DBInterface.GetDataTable; HTMLFeatured.GetFeatured; FeaturedContent_Technologies.LoadFeaturedBlock; FeaturedContent_Technologies.Page_Load; show |
Text |
SELECT TOP(8) 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.DateCreated, HTMLContent.ID show |
BlockID=5
|
0.0156244 |
7. |
0.4219261 |
DBInterface.GetDataTable; ContentPage.LoadContentByPageKey; ContentPage..ctor; ArticleList_HPNewsLarge.Page_Load; show |
StoredProcedure |
Content_LoadByPageKey |
@PageKey=/news/press/ @SiteID=1
|
0.0156399 |
8. |
0.4375509 |
DBInterface.GetDataTable; ContentPages.LoadArticlesByContentID; ContentPage.get_Articles; ArticleList_HPNewsLarge.Page_Load; show |
StoredProcedure |
Content_LoadPageArticles |
@ContentID=126 @SiteID=1 @MonthFilter=0 @YearFilter=0 @CategoryFilter= @TagFilter=
|
0.0156248 |
9. |
0.4375509 |
DBInterface.GetDataTable; ContentPage.LoadContentByPageKey; ContentPage..ctor; ArticleList_HPNewsSmall.Page_Load; show |
StoredProcedure |
Content_LoadByPageKey |
@PageKey=/news/press/ @SiteID=1
|
0 |
10. |
0.4375509 |
DBInterface.GetDataTable; ContentPages.LoadArticlesByContentID; ContentPage.get_Articles; ArticleList_HPNewsSmall.Page_Load; show |
StoredProcedure |
Content_LoadPageArticles |
@ContentID=126 @SiteID=1 @MonthFilter=0 @YearFilter=0 @CategoryFilter= @TagFilter=
|
0 |
11. |
0.4531655 |
DBInterface.GetDataTable; CartManager.LoadCartItems; CartManager.get_CartItems; MasterPage.UpdateCartTotals; show |
StoredProcedure |
[dbo].[Cart_LoadByUserID] |
@UserID=abbd5cd8-156e-452a-8cae-dcbe6eb4f7c1 @SiteID=1
|
0.0156146 |
|
|
|
|
|
Total DB Execution Time |
0.093777 |