# |
Seconds Since First Hit |
Trace |
Command Type |
Command Text |
Parameters |
Execution Time |
1. |
0 |
DBInterface.GetDataTable; VirtualCatalogInfo.LoadVirtualCatalog; VirtualCatalogInfo..ctor; Common.GetSiteID; show |
StoredProcedure |
[dbo].[VirtualCatalogLoadBySiteDomain] |
@SiteDomain=schuremeddev.braveriversolutions.com
|
0.0007852 |
2. |
0 |
DBInterface.get_oSQLDataReader; VirtualSiteProperties.GetVirtualSiteProperties; VirtualSiteProperties..ctor; VirtualCatalogInfo.LoadVirtualCatalog; show |
StoredProcedure |
[dbo].[VirtualSitePropertiesLoadBySiteID] |
@SiteID=1
|
0 |
3. |
0.1577617 |
DBInterface.GetDataTable; HTMLContent.GetHTMLContent; HTMLContent..ctor; FormSubmissionManager.InitializeTracking; 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 = '/choosing-the-right-apron-for-me/default.aspx' show |
- |
0.0952484 |
4. |
0.1577617 |
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 = '/choosing-the-right-apron-for-me/default.aspx' show |
- |
0 |
5. |
0.1577617 |
DBInterface.GetDataTable; HTMLContent.GetHTMLMiscContent; MasterPage.Page_Load; Control.OnLoad; show |
Text |
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Header - Alert Bar' show |
- |
0 |
6. |
0.781306 |
DBInterface.GetDataTable; ContentPage.LoadContentByPageKey; ContentPage..ctor; PageLayoutController.Page_Load; show |
StoredProcedure |
Content_LoadByPageKey |
@PageKey=/choosing-the-right-apron-for-me/default.aspx @SiteID=1
|
0.6079192 |
7. |
1.0720391 |
DBInterface.GetDataTable; ContentPage.LoadContentByPageKey; ContentPage..ctor; PageLayout5.Page_Load; show |
StoredProcedure |
Content_LoadByPageKey |
@PageKey=/choosing-the-right-apron-for-me/default.aspx @SiteID=1
|
0.0156225 |
8. |
1.087666 |
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 = '/choosing-the-right-apron-for-me/default.aspx' show |
- |
0 |
9. |
1.2662543 |
DBInterface.GetDataTable; Breadcrumb.LoadBreadcrumb; Breadcrumb.Page_Load; Control.OnLoad; show |
StoredProcedure |
HTMLContentBreadcrumb |
SiteID=1 ContentID=141
|
0.1622406 |
10. |
1.2969806 |
DBInterface.GetDataTable; CartManager.LoadCartItems; CartManager.get_CartItems; MasterPage.UpdateCartTotals; show |
StoredProcedure |
[dbo].[Cart_LoadByUserID] |
@UserID=b6f44ff0-6b18-483d-b451-880aec0cf1d1 @SiteID=1
|
0 |
|
|
|
|
|
Total DB Execution Time |
0.8818159 |