# |
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=brscommercedev.braveriversolutions.com
|
0 |
2. |
0.0156557 |
DBInterface.get_oSQLDataReader; VirtualSiteProperties.GetVirtualSiteProperties; VirtualSiteProperties..ctor; VirtualCatalogInfo.LoadVirtualCatalog; show |
StoredProcedure |
[dbo].[VirtualSitePropertiesLoadBySiteID] |
@SiteID=1
|
0 |
3. |
0.0312807 |
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 = '/cart/default.aspx' show |
- |
0 |
4. |
0.0469044 |
DBInterface.GetDataTable; BaseUser.GetDefaultSearch; UserSession.get_DefaultSearchAttribute; PageManager.get_CategoryMenu; show |
StoredProcedure |
[dbo].[DefaultSearchAttributeGetByUserID] |
@g_UserID =3665edd1-6df6-4acc-a5d6-4c2f7210ee65
|
0 |
5. |
0.2969037 |
DBInterface.GetDataTable; CartManager.LoadCartItems; CartManager.get_CartItems; MiniCart.Page_Load; show |
StoredProcedure |
[dbo].[Cart_LoadByUserID] |
@UserID=3665edd1-6df6-4acc-a5d6-4c2f7210ee65 @SiteID=1 @AutoGeneratePriceList=False
|
0 |
6. |
0.2969037 |
DBInterface.GetDataTable; ContentPage.LoadContentByPageKey; ContentPage..ctor; PageLayoutController.Page_Load; show |
StoredProcedure |
Content_LoadByPageKey |
@PageKey=/cart/default.aspx @SiteID=1
|
0 |
7. |
0.3125287 |
DBInterface.GetDataTable; FormBuilder.getformIDByPageKey; FormBuilder_v2_0.Page_Init; Control.OnInit; show |
Text |
SELECT FormID FROM FormBuilderPageKeyMap WHERE PageKey = '/cart/default.aspx'; |
- |
0 |
8. |
0.3125287 |
DBInterface.GetDataTable; ContentPage.LoadContentByPageKey; ContentPage..ctor; PageLayout0.Page_Load; show |
StoredProcedure |
Content_LoadByPageKey |
@PageKey=/cart/default.aspx @SiteID=1
|
0 |
9. |
0.3437709 |
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 = '/cart/default.aspx' show |
- |
0 |
10. |
0.3437709 |
DBInterface.GetDataTable; Breadcrumb.LoadBreadcrumb; Breadcrumb.Page_Load; Control.OnLoad; show |
StoredProcedure |
HTMLContentBreadcrumb |
SiteID=1 ContentID=111
|
0 |
11. |
0.375022 |
DBInterface.get_oSQLDataReader; CheckOut._FETCH; CheckOut..ctor; PageManager.get_Checkout; show |
StoredProcedure |
[dbo].[CheckoutLoadByPrimaryKey] |
@g_UserID=3665edd1-6df6-4acc-a5d6-4c2f7210ee65 @SiteID=1
|
0.0312511 |
12. |
0.375022 |
DBInterface.get_oSQLDataReader; Organization.OrganizationObjectLoadByOrgID; Organization..ctor; CheckoutManager.CreateCheckout; show |
StoredProcedure |
[dbo].[OrganizationObjectLoadByOrgID] |
@g_OrgID=11c390ee-61ec-40fc-8ff4-1b9d0687c9f7
|
0 |
13. |
0.4218967 |
DBInterface.get_oSQLDataReader; CheckOut._FETCH; CheckOut..ctor; PageManager.get_Checkout; show |
StoredProcedure |
[dbo].[CheckoutLoadByPrimaryKey] |
@g_UserID=3665edd1-6df6-4acc-a5d6-4c2f7210ee65 @SiteID=1
|
0 |
14. |
0.4687727 |
DBInterface.get_oSQLDataReader; CheckOut._FETCH; CheckOut..ctor; PageManager.get_Checkout; show |
StoredProcedure |
[dbo].[CheckoutLoadByPrimaryKey] |
@g_UserID=3665edd1-6df6-4acc-a5d6-4c2f7210ee65 @SiteID=1
|
0 |
15. |
0.5156503 |
DBInterface.get_oSQLDataReader; RecentlyViewedProducts.LoadRecentProductsByProductID; RecentlyViewedProducts..ctor; UserControls_Store_Cart_ShoppingCart.LoadPage; show |
StoredProcedure |
[dbo].[RecentlyViewedListLoadByEntityType] |
@UserID=3665edd1-6df6-4acc-a5d6-4c2f7210ee65 @EntityType=product @RowCount=5 @SiteID=1
|
0.0312552 |
|
|
|
|
|
Total DB Execution Time |
0.0625063 |