# |
Seconds Since First Hit |
Trace |
Command Type |
Command Text |
Parameters |
Execution Time |
1. |
0 |
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 = '/locations/default.aspx' show |
- |
0.0156385 |
2. |
0 |
DBInterface.GetDataTable; BaseUser.GetDefaultSearch; UserSession.get_DefaultSearchAttribute; PageManager.get_CategoryMenu; show |
StoredProcedure |
[dbo].[DefaultSearchAttributeGetByUserID] |
@g_UserID =ac1a82c2-9f2f-4d65-8f28-b93437eaf427
|
0 |
3. |
0.2187391 |
DBInterface.GetDataTable; CartManager.LoadCartItems; CartManager.get_CartItems; MiniCart.Page_Load; show |
StoredProcedure |
[dbo].[Cart_LoadByUserID] |
@UserID=ac1a82c2-9f2f-4d65-8f28-b93437eaf427 @SiteID=1 @AutoGeneratePriceList=False
|
0 |
4. |
0.2187391 |
DBInterface.GetDataTable; ContentPage.LoadContentByPageKey; ContentPage..ctor; PageLayoutController.Page_Load; show |
StoredProcedure |
Content_LoadByPageKey |
@PageKey=/locations/default.aspx @SiteID=1
|
0 |
5. |
0.2187391 |
DBInterface.GetDataTable; FormBuilder.getformIDByPageKey; FormBuilder_v2_0.Page_Init; Control.OnInit; show |
Text |
SELECT FormID FROM FormBuilderPageKeyMap WHERE PageKey = '/locations/default.aspx'; |
- |
0 |
6. |
0.234364 |
DBInterface.GetDataTable; ContentPage.LoadContentByPageKey; ContentPage..ctor; PageLayout0.Page_Load; show |
StoredProcedure |
Content_LoadByPageKey |
@PageKey=/locations/default.aspx @SiteID=1
|
0.0156249 |
7. |
0.3437553 |
DBInterface.GetDataTable; ContentPages.LoadArticlesByContentID; ContentPage.get_Articles; PageLayout0.Page_Load; show |
StoredProcedure |
Content_LoadPageArticles |
@ContentID=139 @SiteID=1 @MonthFilter=0 @YearFilter=0 @CategoryFilter= @TagFilter=
|
0.1093913 |
8. |
0.3593686 |
DBInterface.GetDataTable; ContentPages.LoadArticlesByContentID; ContentPage.get_Articles; PageLayout0.Page_Load; show |
StoredProcedure |
Content_LoadPageArticles |
@ContentID=139 @SiteID=1 @MonthFilter=0 @YearFilter=0 @CategoryFilter= @TagFilter=
|
0 |
9. |
0.3906339 |
DBInterface.GetDataTable; CMSUtility.LoadAllTagsForContentArticles; PageLayout0.Page_Load; Control.OnLoad; show |
StoredProcedure |
Content_LoadAllTagsForContentArticles |
@ContentID=139 @SiteID=1
|
0.0312653 |
10. |
0.4687464 |
DBInterface.GetDataTable; ContentPages.LoadArchiveDates; ContentPage.ArchiveDates; PageLayout0.Page_Load; show |
StoredProcedure |
Content_LoadArchiveDates |
@ContentID=139 @SiteID=1 @DateFormat=Auto
|
0.0625028 |
11. |
0.4912589 |
DBInterface.GetDataTable; ContentPages.LoadArticleTags; ContentPage.LoadArticleTags; ContentPage.get_ArticleCategories; show |
StoredProcedure |
Content_LoadTagsByContentID |
@ContentID=139 @SiteID=1 @TagType=All
|
0.0225125 |
12. |
0.4952534 |
DBInterface.GetDataTable; HTMLContent.GetHTMLContent; HTMLContent..ctor; Breadcrumb.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 = '/locations/default.aspx' show |
- |
0.0039945 |
13. |
0.4991609 |
DBInterface.GetDataTable; Breadcrumb.LoadBreadcrumb; Breadcrumb.Page_Load; Control.OnLoad; show |
StoredProcedure |
HTMLContentBreadcrumb |
SiteID=1 ContentID=139
|
0.0039075 |
|
|
|
|
|
Total DB Execution Time |
0.2648373 |