Developer forum

Forum » Dynamicweb 9.0 Upgrade issues » Detecting Extra slowness in cart page for logged in user 9.13.13

Detecting Extra slowness in cart page for logged in user 9.13.13

E-mail notifications
Shiwanka Chathuranga Dynamicweb Employee
Shiwanka Chathuranga
Reply
Posted on 04/10/2022 10:31:06

We are seens some slowness for logged in users in cart page after upgrading to 9.13.13


Replies

 
Nicolai Pedersen Dynamicweb Employee
Nicolai Pedersen
Posted on 04/10/2022 13:30:23
Reply

Hi Shiwanka

Can you provide the entire callstack? Also you might want to check the database indexes of the EcomNumbers table - seems like something is missing.

Thanks!

 
Shiwanka Chathuranga Dynamicweb Employee
Shiwanka Chathuranga
Posted on 04/10/2022 13:36:18
Reply

Hi Nicolai,

 

Table Index

here is the callstack

<!-- Exe time: 1.5782689 : <PageID (59)> <Designs/Kids21/_parsed/ContentPage.parsed.cshtml> ERROR: No content container found in this layout... -->

Time Event From last From start
7:31:53 PM.969 Begin Execution 
0 ms
 
0 ms
7:31:53 PM.969 Begin Pageview 
0 ms
 
0 ms
7:31:53 PM.969 Begin Pageview.Loads 
0 ms
 
0 ms
7:31:53 PM.969 Before checking publish 
0 ms
 
0 ms
7:31:53 PM.969 After checking publish 
0 ms
 
0 ms
7:31:53 PM.969 After lock domain 
0 ms
 
0 ms
7:31:53 PM.969 After setting ID's 
0 ms
 
0 ms
7:31:53 PM.969 After Tracking experiments 
0 ms
 
0 ms
7:31:53 PM.969 After checking SSL mode 
0 ms
 
0 ms
7:31:53 PM.969 After setting encoding 
0 ms
 
0 ms
7:31:53 PM.969 Before statistics 
0 ms
 
0 ms
7:31:53 PM.969 After setting content ID 
0 ms
 
0 ms
7:31:53 PM.969 After setting Item 
0 ms
 
0 ms
7:31:53 PM.969 After setting Metadata 
0 ms
 
0 ms
7:31:53 PM.969 After setting layout template 
0 ms
 
0 ms
7:31:53 PM.969 Before Extranet login 
0 ms
 
0 ms
7:31:53 PM.969 After Extranet login 
0 ms
 
0 ms
7:31:53 PM.970 After Notifications.Standard.Page.Loaded 
1 ms
 
1 ms
7:31:53 PM.970 Before visitor tracking... 
0 ms
 
1 ms
7:31:53 PM.972 After visitor tracking... 
2 ms
 
3 ms
7:31:53 PM.972 Start Output 
0 ms
 
3 ms
7:31:53 PM.972 Setting headers 
0 ms
 
3 ms
7:31:53 PM.972 Set Page Template Values 
0 ms
 
3 ms
7:31:53 PM.972 After Notifications.Standard.Page.PageTitle 
0 ms
 
3 ms
7:31:53 PM.972 PageViewModel.CreateInstance START 
0 ms
 
3 ms
7:31:53 PM.983 ItemViewModel.CreateInstance Start (ContentRow, 32) 
11 ms
 
14 ms
7:31:53 PM.984 ItemViewModel.CreateInstance End 
1 ms
 
15 ms
7:31:53 PM.984 Render Grid - ID: 'Pages', Container: 'Grid' 
0 ms
 
15 ms
7:31:53 PM.984 Render GridRow - ID: '33' 
0 ms
 
15 ms
7:31:53 PM.984 Starting template.output (C:\Server\Kids21\Custom\Files\Templates\Designs\Kids21\Grid\Pages\RowTemplates\12column.cshtml) 
0 ms
 
15 ms
7:31:53 PM.984 Render GridColumn - ID: '1', ParagraphID: '43' 
0 ms
 
15 ms
7:31:53 PM.984 RenderParagraph Start - ID: 43, Container: 
0 ms
 
15 ms
7:31:53 PM.984 RenderParagraph after permissions - ID: 43, Container: 
0 ms
 
15 ms
7:31:53 PM.985 RenderParagraph after template - ID: 43, Container: 
1 ms
 
16 ms
7:31:53 PM.985 ItemViewModel.CreateInstance Start (App, 21) 
0 ms
 
16 ms
7:31:53 PM.985 ItemViewModel.CreateInstance End 
0 ms
 
16 ms
7:31:53 PM.985 RenderParagraph after ParagraphViewModel - ID: 43, Container: 
0 ms
 
16 ms
7:31:53 PM.985 Render Paragraph - ID: 43, Container: , Template: Designs/Kids21/ContentPage/Paragraph/App.cshtml 
0 ms
 
16 ms
7:31:53 PM.985 Starting template.output (C:\Server\Kids21\Custom\Files\Templates\Designs\Kids21\ContentPage\Paragraph\App.cshtml) 
0 ms
 
16 ms
7:31:53 PM.985 Start module (PID = 43): eCom_CartV2 
0 ms
 
16 ms
7:31:53 PM.987 CreateDataReader - took: 0 ms.
USE [kids21new]
SELECT * FROM EcomOrderField ORDER BY OrderFieldSort
System.Data.IDataReader CreateDataReader(System.Data.IDbCommand, System.Data.CommandBehavior) (Dynamicweb.Data.dll) in :0
System.Data.IDataReader CreateDataReader(System.String, System.Data.IDbConnection, System.Data.IDbTransaction, System.Data.CommandBehavior, Int32, System.Collections.Generic.Dictionary`2[System.String,System.Tuple`2[System.Object,System.Data.DbType]]) (Dynamicweb.Data.dll) in :0
System.Data.IDataReader CreateDataReader(System.String, System.Data.IDbConnection, System.Data.IDbTransaction, Int32, System.Collections.Generic.Dictionary`2[System.String,System.Tuple`2[System.Object,System.Data.DbType]]) (Dynamicweb.Data.dll) in :0
Void Load(System.String) (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Ecommerce.Orders.OrderFieldCollection GetOrderFieldCollection(System.String) (Dynamicweb.Ecommerce.dll) in :0
System.Collections.Generic.List`1[Dynamicweb.Ecommerce.Orders.Validation.ValidationField] GetCustomOrderFields() (Dynamicweb.Ecommerce.dll) in :0
System.Collections.Generic.List`1[Dynamicweb.Ecommerce.Orders.Validation.ValidationField] GetAllFields() (Dynamicweb.Ecommerce.dll) in :0
System.String GetTranslatedName() (Dynamicweb.Ecommerce.dll) in :0
Void .ctor(Dynamicweb.Modules.Properties) (Dynamicweb.Ecommerce.dll) in :0
System.String GetContent() (Dynamicweb.Ecommerce.dll) in :0
System.String GetModuleOutput(Dynamicweb.Content.Paragraph, Dynamicweb.Frontend.PageView) (Dynamicweb.dll) in :0
Void Execute() (CompiledRazorTemplates.Dynamic.RazorEngine_8f8dc1e2e97a4e44a2ac960c4661797b.dll) in C:\Server\Kids21\Custom\Files\Templates\Designs\Kids21\ContentPage\Paragraph\App.cshtml:9
Void RazorEngine.Templating.ITemplate.Run(RazorEngine.Templating.ExecuteContext, System.IO.TextWriter) (RazorEngine.dll) in :0
Void RunCompile(RazorEngine.Templating.ITemplateKey, System.IO.TextWriter, System.Type, System.Object, RazorEngine.Templating.DynamicViewBag) (RazorEngine.dll) in :0
Void b__0(System.IO.TextWriter) (RazorEngine.dll) in :0
System.String WithWriter(System.Action`1[System.IO.TextWriter]) (RazorEngine.dll) in :0
System.String Render(Dynamicweb.Rendering.Template) (Dynamicweb.Rendering.Providers.dll) in :0
System.String Render(Dynamicweb.Rendering.Template) (Dynamicweb.dll) in :0
System.String RenderRazorTemplate() (Dynamicweb.dll) in :0
System.String Output() (Dynamicweb.dll) in :0
System.String RenderParagraph(Dynamicweb.Content.Paragraph, Dynamicweb.Frontend.ContainerInfo, Dynamicweb.Rendering.Designer.Layout, Dynamicweb.Frontend.GridColumnViewModel) (Dynamicweb.dll) in :0
System.String RenderParagraph(Dynamicweb.Content.Paragraph, Dynamicweb.Frontend.GridColumnViewModel) (Dynamicweb.dll) in :0
System.String RenderGridColumn(Dynamicweb.Frontend.GridColumnViewModel) (Dynamicweb.dll) in :0
Void Execute() (CompiledRazorTemplates.Dynamic.RazorEngine_4c68b1a3c0b74a96bc27f8e81bfc9821.dll) in C:\Server\Kids21\Custom\Files\Templates\Designs\Kids21\Grid\Pages\RowTemplates\12column.cshtml:4
Void RazorEngine.Templating.ITemplate.Run(RazorEngine.Templating.ExecuteContext, System.IO.TextWriter) (RazorEngine.dll) in :0
Void RunCompile(RazorEngine.Templating.ITemplateKey, System.IO.TextWriter, System.Type, System.Object, RazorEngine.Templating.DynamicViewBag) (RazorEngine.dll) in :0
Void b__0(System.IO.TextWriter) (RazorEngine.dll) in :0
System.String WithWriter(System.Action`1[System.IO.TextWriter]) (RazorEngine.dll) in :0
System.String Render(Dynamicweb.Rendering.Template) (Dynamicweb.Rendering.Providers.dll) in :0
System.String Render(Dynamicweb.Rendering.Template) (Dynamicweb.dll) in :0
System.String RenderRazorTemplate() (Dynamicweb.dll) in :0
System.String Output() (Dynamicweb.dll) in :0
System.String RenderGridRow(Dynamicweb.Frontend.GridRowViewModel) (Dynamicweb.dll) in :0
System.String RenderGrid(Dynamicweb.Frontend.GridViewModel, System.String, System.String) (Dynamicweb.dll) in :0
System.Collections.Generic.Dictionary`2[System.String,System.String] CreateGridContent(System.Collections.Generic.IEnumerable`1[Dynamicweb.Content.GridRow], System.Collections.Generic.IEnumerable`1[Dynamicweb.Content.Paragraph], Dynamicweb.Rendering.Designer.Layout) (Dynamicweb.dll) in :0
System.Collections.Generic.IDictionary`2[System.String,System.String] CreateGridContent(Int32, Boolean) (Dynamicweb.dll) in :0
Dynamicweb.Frontend.PageViewModel CreatePageViewModel(Dynamicweb.Frontend.PageView) (Dynamicweb.dll) in :0
Void SetPageTemplateValues() (Dynamicweb.dll) in :0
System.String Output() (Dynamicweb.dll) in :0
Void ProcessRequest(System.Web.HttpContext) (Dynamicweb.AspNet.dll) in :0		 
2 ms
 
18 ms
7:31:53 PM.991 CreateDataReader - took: 0 ms.
USE [kids21new]
DECLARE @p0 INT = 623, @p1 INT = 1, @p2 INT = 3, @p3 INT = 4, @p4 INT = 5, @p5 INT = 15
SELECT * FROM [AccessUser] WITH (NOLOCK) WHERE ( [AccessUser].[AccessUserID] = @p0 ) AND ( [AccessUser].[AccessUserType] IN (@p1,@p2,@p3,@p4,@p5) )
System.Data.IDataReader CreateDataReader(System.Data.IDbCommand, System.Data.CommandBehavior) (Dynamicweb.Data.dll) in :0
System.Data.IDataReader CreateDataReader(Dynamicweb.Data.CommandBuilder, System.Data.IDbConnection, System.Data.IDbTransaction, System.Data.CommandBehavior, Int32) (Dynamicweb.Data.dll) in :0
System.Data.IDataReader CreateDataReader(Dynamicweb.Data.CommandBuilder, System.Data.IDbConnection, System.Data.IDbTransaction, Int32) (Dynamicweb.Data.dll) in :0
Dynamicweb.Security.UserManagement.User GetUser(Dynamicweb.Data.CommandBuilder) (Dynamicweb.Security.dll) in :0
Dynamicweb.Security.UserManagement.User GetUserByID(Int32, Boolean) (Dynamicweb.Security.dll) in :0
Dynamicweb.Ecommerce.Prices.PriceContext GetPriceContext() (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Ecommerce.Prices.PriceInfo get_UnitPrice() (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Ecommerce.Prices.PriceInfo get_Price() (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Ecommerce.Prices.PriceInfo get_Price() (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Ecommerce.Prices.PriceInfo GetPriceBeforeFees(Boolean) (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Ecommerce.Prices.PriceInfo b__841_0() (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Ecommerce.Prices.PriceInfo get_PaymentFee() (Dynamicweb.Ecommerce.dll) in :0
Void Save(Dynamicweb.Ecommerce.Orders.Order) (Dynamicweb.Ecommerce.dll) in :0
Void Save(Dynamicweb.Ecommerce.Orders.Order, Boolean) (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Ecommerce.Orders.Order GetOrder() (Dynamicweb.Ecommerce.dll) in :0
System.String GetContent() (Dynamicweb.Ecommerce.dll) in :0
System.String GetModuleOutput(Dynamicweb.Content.Paragraph, Dynamicweb.Frontend.PageView) (Dynamicweb.dll) in :0
Void Execute() (CompiledRazorTemplates.Dynamic.RazorEngine_8f8dc1e2e97a4e44a2ac960c4661797b.dll) in C:\Server\Kids21\Custom\Files\Templates\Designs\Kids21\ContentPage\Paragraph\App.cshtml:9
Void RazorEngine.Templating.ITemplate.Run(RazorEngine.Templating.ExecuteContext, System.IO.TextWriter) (RazorEngine.dll) in :0
Void RunCompile(RazorEngine.Templating.ITemplateKey, System.IO.TextWriter, System.Type, System.Object, RazorEngine.Templating.DynamicViewBag) (RazorEngine.dll) in :0
Void b__0(System.IO.TextWriter) (RazorEngine.dll) in :0
System.String WithWriter(System.Action`1[System.IO.TextWriter]) (RazorEngine.dll) in :0
System.String Render(Dynamicweb.Rendering.Template) (Dynamicweb.Rendering.Providers.dll) in :0
System.String Render(Dynamicweb.Rendering.Template) (Dynamicweb.dll) in :0
System.String RenderRazorTemplate() (Dynamicweb.dll) in :0
System.String Output() (Dynamicweb.dll) in :0
System.String RenderParagraph(Dynamicweb.Content.Paragraph, Dynamicweb.Frontend.ContainerInfo, Dynamicweb.Rendering.Designer.Layout, Dynamicweb.Frontend.GridColumnViewModel) (Dynamicweb.dll) in :0
System.String RenderParagraph(Dynamicweb.Content.Paragraph, Dynamicweb.Frontend.GridColumnViewModel) (Dynamicweb.dll) in :0
System.String RenderGridColumn(Dynamicweb.Frontend.GridColumnViewModel) (Dynamicweb.dll) in :0
Void Execute() (CompiledRazorTemplates.Dynamic.RazorEngine_4c68b1a3c0b74a96bc27f8e81bfc9821.dll) in C:\Server\Kids21\Custom\Files\Templates\Designs\Kids21\Grid\Pages\RowTemplates\12column.cshtml:4
Void RazorEngine.Templating.ITemplate.Run(RazorEngine.Templating.ExecuteContext, System.IO.TextWriter) (RazorEngine.dll) in :0
Void RunCompile(RazorEngine.Templating.ITemplateKey, System.IO.TextWriter, System.Type, System.Object, RazorEngine.Templating.DynamicViewBag) (RazorEngine.dll) in :0
Void b__0(System.IO.TextWriter) (RazorEngine.dll) in :0
System.String WithWriter(System.Action`1[System.IO.TextWriter]) (RazorEngine.dll) in :0
System.String Render(Dynamicweb.Rendering.Template) (Dynamicweb.Rendering.Providers.dll) in :0
System.String Render(Dynamicweb.Rendering.Template) (Dynamicweb.dll) in :0
System.String RenderRazorTemplate() (Dynamicweb.dll) in :0
System.String Output() (Dynamicweb.dll) in :0
System.String RenderGridRow(Dynamicweb.Frontend.GridRowViewModel) (Dynamicweb.dll) in :0
System.String RenderGrid(Dynamicweb.Frontend.GridViewModel, System.String, System.String) (Dynamicweb.dll) in :0
System.Collections.Generic.Dictionary`2[System.String,System.String] CreateGridContent(System.Collections.Generic.IEnumerable`1[Dynamicweb.Content.GridRow], System.Collections.Generic.IEnumerable`1[Dynamicweb.Content.Paragraph], Dynamicweb.Rendering.Designer.Layout) (Dynamicweb.dll) in :0
System.Collections.Generic.IDictionary`2[System.String,System.String] CreateGridContent(Int32, Boolean) (Dynamicweb.dll) in :0
Dynamicweb.Frontend.PageViewModel CreatePageViewModel(Dynamicweb.Frontend.PageView) (Dynamicweb.dll) in :0
Void SetPageTemplateValues() (Dynamicweb.dll) in :0
System.String Output() (Dynamicweb.dll) in :0
Void ProcessRequest(System.Web.HttpContext) (Dynamicweb.AspNet.dll) in :0		 
4 ms
 
22 ms
7:31:54 PM.15 CreateDataReader - took: 0 ms.
USE [kids21new]
DECLARE @p0 NVARCHAR(12) = N'100293333WHT', @p1 NVARCHAR(5) = N'LANG1'
SELECT * FROM EcomProducts WITH (NOLOCK) WHERE ProductID = @p0 AND ProductLanguageID=@p1
System.Data.IDataReader CreateDataReader(System.Data.IDbCommand, System.Data.CommandBehavior) (Dynamicweb.Data.dll) in :0
System.Data.IDataReader CreateDataReader(Dynamicweb.Data.CommandBuilder, System.Data.IDbConnection, System.Data.IDbTransaction, System.Data.CommandBehavior, Int32) (Dynamicweb.Data.dll) in :0
System.Data.IDataReader CreateDataReader(Dynamicweb.Data.CommandBuilder, System.Data.IDbConnection, System.Data.IDbTransaction, Int32) (Dynamicweb.Data.dll) in :0
System.Collections.Generic.IEnumerable`1[Dynamicweb.Ecommerce.Products.Product] GetProductsBySql(Dynamicweb.Data.CommandBuilder, Boolean, Boolean, Boolean) (Dynamicweb.Ecommerce.dll) in :0
System.Collections.Generic.IEnumerable`1[Dynamicweb.Ecommerce.Products.Product] GetByProductIDs(System.String[], Boolean, System.String, Boolean, Boolean) (Dynamicweb.Ecommerce.dll) in :0
System.Collections.Generic.IEnumerable`1[System.String] RemoveNonExistingProductsFromCart(Dynamicweb.Ecommerce.Orders.Order) (Dynamicweb.Ecommerce.dll) in :0
System.String GetContent() (Dynamicweb.Ecommerce.dll) in :0
System.String GetModuleOutput(Dynamicweb.Content.Paragraph, Dynamicweb.Frontend.PageView) (Dynamicweb.dll) in :0
Void Execute() (CompiledRazorTemplates.Dynamic.RazorEngine_8f8dc1e2e97a4e44a2ac960c4661797b.dll) in C:\Server\Kids21\Custom\Files\Templates\Designs\Kids21\ContentPage\Paragraph\App.cshtml:9
Void RazorEngine.Templating.ITemplate.Run(RazorEngine.Templating.ExecuteContext, System.IO.TextWriter) (RazorEngine.dll) in :0
Void RunCompile(RazorEngine.Templating.ITemplateKey, System.IO.TextWriter, System.Type, System.Object, RazorEngine.Templating.DynamicViewBag) (RazorEngine.dll) in :0
Void b__0(System.IO.TextWriter) (RazorEngine.dll) in :0
System.String WithWriter(System.Action`1[System.IO.TextWriter]) (RazorEngine.dll) in :0
System.String Render(Dynamicweb.Rendering.Template) (Dynamicweb.Rendering.Providers.dll) in :0
System.String Render(Dynamicweb.Rendering.Template) (Dynamicweb.dll) in :0
System.String RenderRazorTemplate() (Dynamicweb.dll) in :0
System.String Output() (Dynamicweb.dll) in :0
System.String RenderParagraph(Dynamicweb.Content.Paragraph, Dynamicweb.Frontend.ContainerInfo, Dynamicweb.Rendering.Designer.Layout, Dynamicweb.Frontend.GridColumnViewModel) (Dynamicweb.dll) in :0
System.String RenderParagraph(Dynamicweb.Content.Paragraph, Dynamicweb.Frontend.GridColumnViewModel) (Dynamicweb.dll) in :0
System.String RenderGridColumn(Dynamicweb.Frontend.GridColumnViewModel) (Dynamicweb.dll) in :0
Void Execute() (CompiledRazorTemplates.Dynamic.RazorEngine_4c68b1a3c0b74a96bc27f8e81bfc9821.dll) in C:\Server\Kids21\Custom\Files\Templates\Designs\Kids21\Grid\Pages\RowTemplates\12column.cshtml:4
Void RazorEngine.Templating.ITemplate.Run(RazorEngine.Templating.ExecuteContext, System.IO.TextWriter) (RazorEngine.dll) in :0
Void RunCompile(RazorEngine.Templating.ITemplateKey, System.IO.TextWriter, System.Type, System.Object, RazorEngine.Templating.DynamicViewBag) (RazorEngine.dll) in :0
Void b__0(System.IO.TextWriter) (RazorEngine.dll) in :0
System.String WithWriter(System.Action`1[System.IO.TextWriter]) (RazorEngine.dll) in :0
System.String Render(Dynamicweb.Rendering.Template) (Dynamicweb.Rendering.Providers.dll) in :0
System.String Render(Dynamicweb.Rendering.Template) (Dynamicweb.dll) in :0
System.String RenderRazorTemplate() (Dynamicweb.dll) in :0
System.String Output() (Dynamicweb.dll) in :0
System.String RenderGridRow(Dynamicweb.Frontend.GridRowViewModel) (Dynamicweb.dll) in :0
System.String RenderGrid(Dynamicweb.Frontend.GridViewModel, System.String, System.String) (Dynamicweb.dll) in :0
System.Collections.Generic.Dictionary`2[System.String,System.String] CreateGridContent(System.Collections.Generic.IEnumerable`1[Dynamicweb.Content.GridRow], System.Collections.Generic.IEnumerable`1[Dynamicweb.Content.Paragraph], Dynamicweb.Rendering.Designer.Layout) (Dynamicweb.dll) in :0
System.Collections.Generic.IDictionary`2[System.String,System.String] CreateGridContent(Int32, Boolean) (Dynamicweb.dll) in :0
Dynamicweb.Frontend.PageViewModel CreatePageViewModel(Dynamicweb.Frontend.PageView) (Dynamicweb.dll) in :0
Void SetPageTemplateValues() (Dynamicweb.dll) in :0
System.String Output() (Dynamicweb.dll) in :0
Void ProcessRequest(System.Web.HttpContext) (Dynamicweb.AspNet.dll) in :0		 
24 ms
 
46 ms
7:31:54 PM.18 CreateDataReader - took: 0 ms.
USE [kids21new]
SELECT EcomPrices.* FROM EcomPrices WHERE (PriceUserCustomerNumber='' OR PriceUserCustomerNumber IS NULL) AND PriceProductID IN('100293333WHT') ORDER BY EcomPrices.PriceProductID
System.Data.IDataReader CreateDataReader(System.Data.IDbCommand, System.Data.CommandBehavior) (Dynamicweb.Data.dll) in :0
System.Data.IDataReader CreateDataReader(System.String, System.Data.IDbConnection, System.Data.IDbTransaction, System.Data.CommandBehavior, Int32, System.Collections.Generic.Dictionary`2[System.String,System.Tuple`2[System.Object,System.Data.DbType]]) (Dynamicweb.Data.dll) in :0
System.Data.IDataReader CreateDataReader(System.String, System.Data.IDbConnection, System.Data.IDbTransaction, Int32, System.Collections.Generic.Dictionary`2[System.String,System.Tuple`2[System.Object,System.Data.DbType]]) (Dynamicweb.Data.dll) in :0
System.Collections.Generic.Dictionary`2[System.String,System.Collections.Generic.List`1[Dynamicweb.Ecommerce.Prices.Price]] GetPrices(System.String) (Dynamicweb.Ecommerce.dll) in :0
Void LoadPricesOnProducts(System.Collections.Generic.IEnumerable`1[Dynamicweb.Ecommerce.Products.Product]) (Dynamicweb.Ecommerce.dll) in :0
Void PreparePrices(Dynamicweb.Ecommerce.Prices.PriceContext, System.Collections.Generic.IEnumerable`1[Dynamicweb.Ecommerce.Prices.PriceProductSelection]) (Dynamicweb.Ecommerce.dll) in :0
Void SetValuesOnOrder(Dynamicweb.Ecommerce.Orders.Order) (Dynamicweb.Ecommerce.dll) in :0
System.String GetContent() (Dynamicweb.Ecommerce.dll) in :0
System.String GetModuleOutput(Dynamicweb.Content.Paragraph, Dynamicweb.Frontend.PageView) (Dynamicweb.dll) in :0
Void Execute() (CompiledRazorTemplates.Dynamic.RazorEngine_8f8dc1e2e97a4e44a2ac960c4661797b.dll) in C:\Server\Kids21\Custom\Files\Templates\Designs\Kids21\ContentPage\Paragraph\App.cshtml:9
Void RazorEngine.Templating.ITemplate.Run(RazorEngine.Templating.ExecuteContext, System.IO.TextWriter) (RazorEngine.dll) in :0
Void RunCompile(RazorEngine.Templating.ITemplateKey, System.IO.TextWriter, System.Type, System.Object, RazorEngine.Templating.DynamicViewBag) (RazorEngine.dll) in :0
Void b__0(System.IO.TextWriter) (RazorEngine.dll) in :0
System.String WithWriter(System.Action`1[System.IO.TextWriter]) (RazorEngine.dll) in :0
System.String Render(Dynamicweb.Rendering.Template) (Dynamicweb.Rendering.Providers.dll) in :0
System.String Render(Dynamicweb.Rendering.Template) (Dynamicweb.dll) in :0
System.String RenderRazorTemplate() (Dynamicweb.dll) in :0
System.String Output() (Dynamicweb.dll) in :0
System.String RenderParagraph(Dynamicweb.Content.Paragraph, Dynamicweb.Frontend.ContainerInfo, Dynamicweb.Rendering.Designer.Layout, Dynamicweb.Frontend.GridColumnViewModel) (Dynamicweb.dll) in :0
System.String RenderParagraph(Dynamicweb.Content.Paragraph, Dynamicweb.Frontend.GridColumnViewModel) (Dynamicweb.dll) in :0
System.String RenderGridColumn(Dynamicweb.Frontend.GridColumnViewModel) (Dynamicweb.dll) in :0
Void Execute() (CompiledRazorTemplates.Dynamic.RazorEngine_4c68b1a3c0b74a96bc27f8e81bfc9821.dll) in C:\Server\Kids21\Custom\Files\Templates\Designs\Kids21\Grid\Pages\RowTemplates\12column.cshtml:4
Void RazorEngine.Templating.ITemplate.Run(RazorEngine.Templating.ExecuteContext, System.IO.TextWriter) (RazorEngine.dll) in :0
Void RunCompile(RazorEngine.Templating.ITemplateKey, System.IO.TextWriter, System.Type, System.Object, RazorEngine.Templating.DynamicViewBag) (RazorEngine.dll) in :0
Void b__0(System.IO.TextWriter) (RazorEngine.dll) in :0
System.String WithWriter(System.Action`1[System.IO.TextWriter]) (RazorEngine.dll) in :0
System.String Render(Dynamicweb.Rendering.Template) (Dynamicweb.Rendering.Providers.dll) in :0
System.String Render(Dynamicweb.Rendering.Template) (Dynamicweb.dll) in :0
System.String RenderRazorTemplate() (Dynamicweb.dll) in :0
System.String Output() (Dynamicweb.dll) in :0
System.String RenderGridRow(Dynamicweb.Frontend.GridRowViewModel) (Dynamicweb.dll) in :0
System.String RenderGrid(Dynamicweb.Frontend.GridViewModel, System.String, System.String) (Dynamicweb.dll) in :0
System.Collections.Generic.Dictionary`2[System.String,System.String] CreateGridContent(System.Collections.Generic.IEnumerable`1[Dynamicweb.Content.GridRow], System.Collections.Generic.IEnumerable`1[Dynamicweb.Content.Paragraph], Dynamicweb.Rendering.Designer.Layout) (Dynamicweb.dll) in :0
System.Collections.Generic.IDictionary`2[System.String,System.String] CreateGridContent(Int32, Boolean) (Dynamicweb.dll) in :0
Dynamicweb.Frontend.PageViewModel CreatePageViewModel(Dynamicweb.Frontend.PageView) (Dynamicweb.dll) in :0
Void SetPageTemplateValues() (Dynamicweb.dll) in :0
System.String Output() (Dynamicweb.dll) in :0
Void ProcessRequest(System.Web.HttpContext) (Dynamicweb.AspNet.dll) in :0		 
3 ms
 
49 ms
7:31:54 PM.25 ExecuteNonQuery - took: 0 ms.
USE [kids21new]
DECLARE @p0 NVARCHAR(7) = N'OL51267'
DELETE FROM EcomOrderLines WHERE OrderLineID = @p0; DELETE FROM EcomOrderLines WHERE OrderLineParentLineID = @p0;		 
7 ms
 
56 ms
7:31:54 PM.37 ExecuteScalar - took: 0 ms.
USE [kids21new]
DECLARE @p0 NVARCHAR(2) = N'43', @p1 INT = 623
select count(OrderAutoID) FROM EcomOrders inner join EcomOrderLines on EcomOrders.OrderID = EcomOrderLines.OrderLineOrderID where ecomorderlines.OrderLineDiscountID = @p0 and OrderComplete = 1 and EcomOrders.OrderCustomerAccessUserID = @p1		 
12 ms
 
68 ms
7:31:54 PM.40 ExecuteScalar - took: 0 ms.
USE [kids21new]
DECLARE @p0 NVARCHAR(2) = N'33', @p1 INT = 623
select count(OrderAutoID) FROM EcomOrders inner join EcomOrderLines on EcomOrders.OrderID = EcomOrderLines.OrderLineOrderID where ecomorderlines.OrderLineDiscountID = @p0 and OrderComplete = 1 and EcomOrders.OrderCustomerAccessUserID = @p1		 
3 ms
 
71 ms
7:31:54 PM.43 ExecuteScalar - took: 0 ms.
USE [kids21new]
DECLARE @p0 NVARCHAR(2) = N'46', @p1 INT = 623
select count(OrderAutoID) FROM EcomOrders inner join EcomOrderLines on EcomOrders.OrderID = EcomOrderLines.OrderLineOrderID where ecomorderlines.OrderLineDiscountID = @p0 and OrderComplete = 1 and EcomOrders.OrderCustomerAccessUserID = @p1		 
3 ms
 
74 ms
7:31:54 PM.46 ExecuteScalar - took: 0 ms.
USE [kids21new]
DECLARE @p0 NVARCHAR(2) = N'27', @p1 INT = 623
select count(OrderAutoID) FROM EcomOrders inner join EcomOrderLines on EcomOrders.OrderID = EcomOrderLines.OrderLineOrderID where ecomorderlines.OrderLineDiscountID = @p0 and OrderComplete = 1 and EcomOrders.OrderCustomerAccessUserID = @p1		 
3 ms
 
77 ms
7:31:54 PM.48 ExecuteScalar - took: 0 ms.
USE [kids21new]
DECLARE @p0 NVARCHAR(2) = N'28', @p1 INT = 623
select count(OrderAutoID) FROM EcomOrders inner join EcomOrderLines on EcomOrders.OrderID = EcomOrderLines.OrderLineOrderID where ecomorderlines.OrderLineDiscountID = @p0 and OrderComplete = 1 and EcomOrders.OrderCustomerAccessUserID = @p1		 
2 ms
 
79 ms
7:31:54 PM.50 ExecuteScalar - took: 15.626 ms.
USE [kids21new]
DECLARE @p0 NVARCHAR(2) = N'29', @p1 INT = 623
select count(OrderAutoID) FROM EcomOrders inner join EcomOrderLines on EcomOrders.OrderID = EcomOrderLines.OrderLineOrderID where ecomorderlines.OrderLineDiscountID = @p0 and OrderComplete = 1 and EcomOrders.OrderCustomerAccessUserID = @p1		 
2 ms
 
81 ms
7:31:54 PM.53 ExecuteScalar - took: 0 ms.
USE [kids21new]
DECLARE @p0 NVARCHAR(2) = N'73', @p1 INT = 623
select count(OrderAutoID) FROM EcomOrders inner join EcomOrderLines on EcomOrders.OrderID = EcomOrderLines.OrderLineOrderID where ecomorderlines.OrderLineDiscountID = @p0 and OrderComplete = 1 and EcomOrders.OrderCustomerAccessUserID = @p1		 
3 ms
 
84 ms
7:31:54 PM.55 ExecuteScalar - took: 0 ms.
USE [kids21new]
DECLARE @p0 NVARCHAR(2) = N'83', @p1 INT = 623
select count(OrderAutoID) FROM EcomOrders inner join EcomOrderLines on EcomOrders.OrderID = EcomOrderLines.OrderLineOrderID where ecomorderlines.OrderLineDiscountID = @p0 and OrderComplete = 1 and EcomOrders.OrderCustomerAccessUserID = @p1		 
2 ms
 
86 ms
7:31:54 PM.57 ExecuteScalar - took: 0 ms.
USE [kids21new]
DECLARE @p0 NVARCHAR(2) = N'84', @p1 INT = 623
select count(OrderAutoID) FROM EcomOrders inner join EcomOrderLines on EcomOrders.OrderID = EcomOrderLines.OrderLineOrderID where ecomorderlines.OrderLineDiscountID = @p0 and OrderComplete = 1 and EcomOrders.OrderCustomerAccessUserID = @p1		 
2 ms
 
88 ms
7:31:55 PM.152 CreateDataReader - took: 0 ms.
USE [kids21new]
DECLARE @p0 NVARCHAR(2) = N'OL'
SELECT * FROM EcomNumbers WHERE NumberType = @p0
System.Data.IDataReader CreateDataReader(System.Data.IDbCommand, System.Data.CommandBehavior) (Dynamicweb.Data.dll) in :0
System.Data.IDataReader CreateDataReader(Dynamicweb.Data.CommandBuilder, System.Data.IDbConnection, System.Data.IDbTransaction, System.Data.CommandBehavior, Int32) (Dynamicweb.Data.dll) in :0
System.Data.IDataReader CreateDataReader(Dynamicweb.Data.CommandBuilder, System.Data.IDbConnection, System.Data.IDbTransaction, Int32) (Dynamicweb.Data.dll) in :0
Void LoadFromType(System.String) (Dynamicweb.Ecommerce.dll) in :0
System.String GetNumber(System.String) (Dynamicweb.Ecommerce.dll) in :0
Void Save(System.String, System.Collections.Generic.IEnumerable`1[Dynamicweb.Ecommerce.Orders.OrderLine]) (Dynamicweb.Ecommerce.dll) in :0
Void Save(Dynamicweb.Ecommerce.Orders.Order, Boolean) (Dynamicweb.Ecommerce.dll) in :0
Void SaveCart(Dynamicweb.Ecommerce.Orders.Order, Dynamicweb.Security.UserManagement.User, Dynamicweb.Ecommerce.Orders.OrderContext) (Dynamicweb.Ecommerce.dll) in :0
Void CalculateDiscounts(Dynamicweb.Ecommerce.Orders.Order) (Dynamicweb.Ecommerce.dll) in :0
Void HandleDiscountAndTaxes(Dynamicweb.Ecommerce.Orders.Order, Boolean) (Dynamicweb.Ecommerce.dll) in :0
System.String GetContent() (Dynamicweb.Ecommerce.dll) in :0
System.String GetModuleOutput(Dynamicweb.Content.Paragraph, Dynamicweb.Frontend.PageView) (Dynamicweb.dll) in :0
Void Execute() (CompiledRazorTemplates.Dynamic.RazorEngine_8f8dc1e2e97a4e44a2ac960c4661797b.dll) in C:\Server\Kids21\Custom\Files\Templates\Designs\Kids21\ContentPage\Paragraph\App.cshtml:9
Void RazorEngine.Templating.ITemplate.Run(RazorEngine.Templating.ExecuteContext, System.IO.TextWriter) (RazorEngine.dll) in :0
Void RunCompile(RazorEngine.Templating.ITemplateKey, System.IO.TextWriter, System.Type, System.Object, RazorEngine.Templating.DynamicViewBag) (RazorEngine.dll) in :0
Void b__0(System.IO.TextWriter) (RazorEngine.dll) in :0
System.String WithWriter(System.Action`1[System.IO.TextWriter]) (RazorEngine.dll) in :0
System.String Render(Dynamicweb.Rendering.Template) (Dynamicweb.Rendering.Providers.dll) in :0
System.String Render(Dynamicweb.Rendering.Template) (Dynamicweb.dll) in :0
System.String RenderRazorTemplate() (Dynamicweb.dll) in :0
System.String Output() (Dynamicweb.dll) in :0
System.String RenderParagraph(Dynamicweb.Content.Paragraph, Dynamicweb.Frontend.ContainerInfo, Dynamicweb.Rendering.Designer.Layout, Dynamicweb.Frontend.GridColumnViewModel) (Dynamicweb.dll) in :0
System.String RenderParagraph(Dynamicweb.Content.Paragraph, Dynamicweb.Frontend.GridColumnViewModel) (Dynamicweb.dll) in :0
System.String RenderGridColumn(Dynamicweb.Frontend.GridColumnViewModel) (Dynamicweb.dll) in :0
Void Execute() (CompiledRazorTemplates.Dynamic.RazorEngine_4c68b1a3c0b74a96bc27f8e81bfc9821.dll) in C:\Server\Kids21\Custom\Files\Templates\Designs\Kids21\Grid\Pages\RowTemplates\12column.cshtml:4
Void RazorEngine.Templating.ITemplate.Run(RazorEngine.Templating.ExecuteContext, System.IO.TextWriter) (RazorEngine.dll) in :0
Void RunCompile(RazorEngine.Templating.ITemplateKey, System.IO.TextWriter, System.Type, System.Object, RazorEngine.Templating.DynamicViewBag) (RazorEngine.dll) in :0
Void b__0(System.IO.TextWriter) (RazorEngine.dll) in :0
System.String WithWriter(System.Action`1[System.IO.TextWriter]) (RazorEngine.dll) in :0
System.String Render(Dynamicweb.Rendering.Template) (Dynamicweb.Rendering.Providers.dll) in :0
System.String Render(Dynamicweb.Rendering.Template) (Dynamicweb.dll) in :0
System.String RenderRazorTemplate() (Dynamicweb.dll) in :0
System.String Output() (Dynamicweb.dll) in :0
System.String RenderGridRow(Dynamicweb.Frontend.GridRowViewModel) (Dynamicweb.dll) in :0
System.String RenderGrid(Dynamicweb.Frontend.GridViewModel, System.String, System.String) (Dynamicweb.dll) in :0
System.Collections.Generic.Dictionary`2[System.String,System.String] CreateGridContent(System.Collections.Generic.IEnumerable`1[Dynamicweb.Content.GridRow], System.Collections.Generic.IEnumerable`1[Dynamicweb.Content.Paragraph], Dynamicweb.Rendering.Designer.Layout) (Dynamicweb.dll) in :0
System.Collections.Generic.IDictionary`2[System.String,System.String] CreateGridContent(Int32, Boolean) (Dynamicweb.dll) in :0
Dynamicweb.Frontend.PageViewModel CreatePageViewModel(Dynamicweb.Frontend.PageView) (Dynamicweb.dll) in :0
Void SetPageTemplateValues() (Dynamicweb.dll) in :0
System.String Output() (Dynamicweb.dll) in :0
Void ProcessRequest(System.Web.HttpContext) (Dynamicweb.AspNet.dll) in :0		 
1,095 ms
 
1,183 ms
7:31:55 PM.152 ExecuteScalar - took: 0 ms.
USE [kids21new]
DECLARE @p0 NVARCHAR(7) = N'OL51268'
SELECT CASE WHEN EXISTS (SELECT TOP 1 NULL FROM [EcomOrderLines] WHERE OrderLineID = @p0) THEN 0 ELSE 1 END		 
0 ms
 
1,183 ms
7:31:55 PM.187 ExecuteScalar - took: 0 ms.
USE [kids21new]
SELECT @@IDENTITY		 
35 ms
 
1,218 ms
7:31:55 PM.191 ExecuteScalar - took: 15.6302 ms.
USE [kids21new]
SELECT @@IDENTITY		 
4 ms
 
1,222 ms
7:31:55 PM.199 CreateDataReader - took: 0 ms.
USE [kids21new]
DECLARE @p0 INT = 623
SELECT * FROM AccessUserCard WHERE AccessUserCardUserID = @p0 ORDER BY AccessUserCardUsedDate DESC
System.Data.IDataReader CreateDataReader(System.Data.IDbCommand, System.Data.CommandBehavior) (Dynamicweb.Data.dll) in :0
System.Data.IDataReader CreateDataReader(Dynamicweb.Data.CommandBuilder, System.Data.IDbConnection, System.Data.IDbTransaction, System.Data.CommandBehavior, Int32) (Dynamicweb.Data.dll) in :0
System.Data.IDataReader CreateDataReader(Dynamicweb.Data.CommandBuilder, System.Data.IDbConnection, System.Data.IDbTransaction, Int32) (Dynamicweb.Data.dll) in :0
System.Collections.Generic.IEnumerable`1[Dynamicweb.Ecommerce.Cart.PaymentCardToken] GetByUserId(Int32) (Dynamicweb.Ecommerce.dll) in :0
Void RenderSavedCard(Dynamicweb.Rendering.Template, Dynamicweb.Ecommerce.Orders.Order, Boolean, System.Collections.Generic.IEnumerable`1[System.String]) (Dynamicweb.Ecommerce.dll) in :0
Void RenderStep(Dynamicweb.Ecommerce.Orders.Order, Dynamicweb.Frontend.PageView, System.Collections.Generic.IEnumerable`1[Dynamicweb.Ecommerce.Orders.Validation.ValidationError], System.Collections.Generic.IEnumerable`1[System.String], Boolean, System.String, Boolean, System.Collections.Generic.IEnumerable`1[System.String], Boolean, System.Collections.Generic.IEnumerable`1[System.String], Dynamicweb.Rendering.Template) (Dynamicweb.Ecommerce.dll) in :0
System.String RenderStep(Dynamicweb.Ecommerce.Orders.Order, Dynamicweb.Ecommerce.Cart.ModuleSettings, Int32, Dynamicweb.Frontend.PageView, System.Collections.Generic.IEnumerable`1[Dynamicweb.Ecommerce.Orders.Validation.ValidationError], System.Collections.Generic.IEnumerable`1[System.String]) (Dynamicweb.Ecommerce.dll) in :0
System.String RenderStep(Dynamicweb.Ecommerce.Orders.Order, Int32, System.Collections.Generic.IEnumerable`1[System.String], System.Collections.Generic.IEnumerable`1[Dynamicweb.Ecommerce.Orders.Validation.ValidationError]) (Dynamicweb.Ecommerce.dll) in :0
System.String GetContent() (Dynamicweb.Ecommerce.dll) in :0
System.String GetModuleOutput(Dynamicweb.Content.Paragraph, Dynamicweb.Frontend.PageView) (Dynamicweb.dll) in :0
Void Execute() (CompiledRazorTemplates.Dynamic.RazorEngine_8f8dc1e2e97a4e44a2ac960c4661797b.dll) in C:\Server\Kids21\Custom\Files\Templates\Designs\Kids21\ContentPage\Paragraph\App.cshtml:9
Void RazorEngine.Templating.ITemplate.Run(RazorEngine.Templating.ExecuteContext, System.IO.TextWriter) (RazorEngine.dll) in :0
Void RunCompile(RazorEngine.Templating.ITemplateKey, System.IO.TextWriter, System.Type, System.Object, RazorEngine.Templating.DynamicViewBag) (RazorEngine.dll) in :0
Void b__0(System.IO.TextWriter) (RazorEngine.dll) in :0
System.String WithWriter(System.Action`1[System.IO.TextWriter]) (RazorEngine.dll) in :0
System.String Render(Dynamicweb.Rendering.Template) (Dynamicweb.Rendering.Providers.dll) in :0
System.String Render(Dynamicweb.Rendering.Template) (Dynamicweb.dll) in :0
System.String RenderRazorTemplate() (Dynamicweb.dll) in :0
System.String Output() (Dynamicweb.dll) in :0
System.String RenderParagraph(Dynamicweb.Content.Paragraph, Dynamicweb.Frontend.ContainerInfo, Dynamicweb.Rendering.Designer.Layout, Dynamicweb.Frontend.GridColumnViewModel) (Dynamicweb.dll) in :0
System.String RenderParagraph(Dynamicweb.Content.Paragraph, Dynamicweb.Frontend.GridColumnViewModel) (Dynamicweb.dll) in :0
System.String RenderGridColumn(Dynamicweb.Frontend.GridColumnViewModel) (Dynamicweb.dll) in :0
Void Execute() (CompiledRazorTemplates.Dynamic.RazorEngine_4c68b1a3c0b74a96bc27f8e81bfc9821.dll) in C:\Server\Kids21\Custom\Files\Templates\Designs\Kids21\Grid\Pages\RowTemplates\12column.cshtml:4
Void RazorEngine.Templating.ITemplate.Run(RazorEngine.Templating.ExecuteContext, System.IO.TextWriter) (RazorEngine.dll) in :0
Void RunCompile(RazorEngine.Templating.ITemplateKey, System.IO.TextWriter, System.Type, System.Object, RazorEngine.Templating.DynamicViewBag) (RazorEngine.dll) in :0
Void b__0(System.IO.TextWriter) (RazorEngine.dll) in :0
System.String WithWriter(System.Action`1[System.IO.TextWriter]) (RazorEngine.dll) in :0
System.String Render(Dynamicweb.Rendering.Template) (Dynamicweb.Rendering.Providers.dll) in :0
System.String Render(Dynamicweb.Rendering.Template) (Dynamicweb.dll) in :0
System.String RenderRazorTemplate() (Dynamicweb.dll) in :0
System.String Output() (Dynamicweb.dll) in :0
System.String RenderGridRow(Dynamicweb.Frontend.GridRowViewModel) (Dynamicweb.dll) in :0
System.String RenderGrid(Dynamicweb.Frontend.GridViewModel, System.String, System.String) (Dynamicweb.dll) in :0
System.Collections.Generic.Dictionary`2[System.String,System.String] CreateGridContent(System.Collections.Generic.IEnumerable`1[Dynamicweb.Content.GridRow], System.Collections.Generic.IEnumerable`1[Dynamicweb.Content.Paragraph], Dynamicweb.Rendering.Designer.Layout) (Dynamicweb.dll) in :0
System.Collections.Generic.IDictionary`2[System.String,System.String] CreateGridContent(Int32, Boolean) (Dynamicweb.dll) in :0
Dynamicweb.Frontend.PageViewModel CreatePageViewModel(Dynamicweb.Frontend.PageView) (Dynamicweb.dll) in :0
Void SetPageTemplateValues() (Dynamicweb.dll) in :0
System.String Output() (Dynamicweb.dll) in :0
Void ProcessRequest(System.Web.HttpContext) (Dynamicweb.AspNet.dll) in :0		 
8 ms
 
1,230 ms
7:31:55 PM.200 Starting template.output (C:\Server\Kids21\Custom\Files\Templates\Designs\Kids21\eCom7\CartV2\Step\Cart.cshtml) 
1 ms
 
1,231 ms
7:31:55 PM.201 Begin Pageview 
1 ms
 
1,232 ms
7:31:55 PM.201 Begin Pageview.Loads 
0 ms
 
1,232 ms
7:31:55 PM.201 Before checking publish 
0 ms
 
1,232 ms
7:31:55 PM.201 After checking publish 
0 ms
 
1,232 ms
7:31:55 PM.201 After lock domain 
0 ms
 
1,232 ms
7:31:55 PM.201 After setting ID's 
0 ms
 
1,232 ms
7:31:55 PM.201 After Tracking experiments 
0 ms
 
1,232 ms
7:31:55 PM.201 After checking SSL mode 
0 ms
 
1,232 ms
7:31:55 PM.201 After setting encoding 
0 ms
 
1,232 ms
7:31:55 PM.201 Before statistics 
0 ms
 
1,232 ms
7:31:55 PM.201 After setting content ID 
0 ms
 
1,232 ms
7:31:55 PM.201 After setting Item 
0 ms
 
1,232 ms
7:31:55 PM.201 After setting Metadata 
0 ms
 
1,232 ms
7:31:55 PM.201 After setting layout template 
0 ms
 
1,232 ms
7:31:55 PM.201 Before Extranet login 
0 ms
 
1,232 ms
7:31:55 PM.201 After Extranet login 
0 ms
 
1,232 ms
7:31:55 PM.202 After Notifications.Standard.Page.Loaded 
1 ms
 
1,233 ms
7:31:55 PM.202 ItemViewModel.CreateInstance Start (WebSite, 2) 
0 ms
 
1,233 ms
7:31:55 PM.202 ItemViewModel.CreateInstance End 
0 ms
 
1,233 ms
7:31:55 PM.202 Begin Pageview 
0 ms
 
1,233 ms
7:31:55 PM.202 Begin Pageview.Loads 
0 ms
 
1,233 ms
7:31:55 PM.202 Before checking publish 
0 ms
 
1,233 ms
7:31:55 PM.202 After checking publish 
0 ms
 
1,233 ms
7:31:55 PM.202 After lock domain 
0 ms
 
1,233 ms
7:31:55 PM.202 After setting ID's 
0 ms
 
1,233 ms
7:31:55 PM.202 After Tracking experiments 
0 ms
 
1,233 ms
7:31:55 PM.202 After checking SSL mode 
0 ms
 
1,233 ms
7:31:55 PM.202 After setting encoding 
0 ms
 
1,233 ms
7:31:55 PM.202 Before statistics 
0 ms
 
1,233 ms
7:31:55 PM.202 After setting content ID 
0 ms
 
1,233 ms
7:31:55 PM.202 After setting Item 
0 ms
 
1,233 ms
7:31:55 PM.202 After setting Metadata 
0 ms
 
1,233 ms
7:31:55 PM.203 After setting layout template 
1 ms
 
1,234 ms
7:31:55 PM.203 Before Extranet login 
0 ms
 
1,234 ms
7:31:55 PM.203 After Extranet login 
0 ms
 
1,234 ms
7:31:55 PM.203 After Notifications.Standard.Page.Loaded 
0 ms
 
1,234 ms
7:31:55 PM.203 ItemViewModel.CreateInstance Start (WebSite, 2) 
0 ms
 
1,234 ms
7:31:55 PM.203 ItemViewModel.CreateInstance End 
0 ms
 
1,234 ms
7:31:55 PM.204 ItemViewModel.CreateInstance Start (WebSite, 2) 
1 ms
 
1,235 ms
7:31:55 PM.204 ItemViewModel.CreateInstance End 
0 ms
 
1,235 ms
7:31:55 PM.205 After Run (C:\Server\Kids21\Custom\Files\Templates\Designs\Kids21\eCom7\CartV2\Step\Cart.cshtml) 
1 ms
 
1,236 ms
7:31:55 PM.205 Ending Template.Output (C:\Server\Kids21\Custom\Files\Templates\Designs\Kids21\eCom7\CartV2\Step\Cart.cshtml) - took: 0 ms. 
0 ms
 
1,236 ms
7:31:55 PM.205 After Run (C:\Server\Kids21\Custom\Files\Templates\Designs\Kids21\ContentPage\Paragraph\App.cshtml) 
0 ms
 
1,236 ms
7:31:55 PM.205 Ending Template.Output (C:\Server\Kids21\Custom\Files\Templates\Designs\Kids21\ContentPage\Paragraph\App.cshtml) - took: 1218.8681 ms. 
0 ms
 
1,236 ms
7:31:55 PM.205 After Run (C:\Server\Kids21\Custom\Files\Templates\Designs\Kids21\Grid\Pages\RowTemplates\12column.cshtml) 
0 ms
 
1,236 ms
7:31:55 PM.205 Ending Template.Output (C:\Server\Kids21\Custom\Files\Templates\Designs\Kids21\Grid\Pages\RowTemplates\12column.cshtml) - took: 1218.8681 ms. 
0 ms
 
1,236 ms
7:31:55 PM.205 PageViewModel.CreateInstance after PageViewModel 
0 ms
 
1,236 ms
7:31:55 PM.205 ItemViewModel.CreateInstance Start (ContentPage, 39) 
0 ms
 
1,236 ms
7:31:55 PM.205 ItemViewModel.CreateInstance End 
0 ms
 
1,236 ms
7:31:55 PM.205 PageViewModel.CreateInstance after ItemViewModel 
0 ms
 
1,236 ms
7:31:55 PM.205 ItemViewModel.CreateInstance Start (WebPage, 176) 
0 ms
 
1,236 ms
7:31:55 PM.205 ItemViewModel.CreateInstance End 
0 ms
 
1,236 ms
7:31:55 PM.205 PageViewModel.CreateInstance after PropertyItem 
0 ms
 
1,236 ms
7:31:55 PM.205 PageViewModel.CreateInstance after Path 
0 ms
 
1,236 ms
7:31:55 PM.205 PageViewModel.CreateInstance after Languages 
0 ms
 
1,236 ms
7:31:55 PM.205 PageViewModel.CreateInstance after languagePages 
0 ms
 
1,236 ms
7:31:55 PM.205 AreaViewModel.CreateInstance START 
0 ms
 
1,236 ms
7:31:55 PM.205 AreaViewModel.CreateInstance after AreaViewModel init 
0 ms
 
1,236 ms
7:31:55 PM.205 ItemViewModel.CreateInstance Start (WebSite, 2) 
0 ms
 
1,236 ms
7:31:55 PM.205 ItemViewModel.CreateInstance End 
0 ms
 
1,236 ms
7:31:55 PM.205 AreaViewModel.CreateInstance after ItemViewModel 
0 ms
 
1,236 ms
7:31:55 PM.205 AreaViewModel.CreateInstance after FirstPage 
0 ms
 
1,236 ms
7:31:55 PM.205 AreaViewModel.CreateInstance after FirstActivePage 
0 ms
 
1,236 ms
7:31:55 PM.205 AreaViewModel.CreateInstance after SearchPage 
0 ms
 
1,236 ms
7:31:55 PM.205 AreaViewModel.CreateInstance after CartPage 
0 ms
 
1,236 ms
7:31:55 PM.205 AreaViewModel.CreateInstance after Languages load 
0 ms
 
1,236 ms
7:31:55 PM.205 AreaViewModel.CreateInstance after Languages AreaLanguageViewModel 
0 ms
 
1,236 ms
7:31:55 PM.205 AreaViewModel.CreateInstance END 
0 ms
 
1,236 ms
7:31:55 PM.205 PageViewModel.CreateInstance after AreaViewModel 
0 ms
 
1,236 ms
7:31:55 PM.205 PageViewModel.CreateInstance after UserViewModel 
0 ms
 
1,236 ms
7:31:55 PM.205 PageViewModel.CreateInstance END 
0 ms
 
1,236 ms
7:31:55 PM.205 Before RenderPage 
0 ms
 
1,236 ms
7:31:55 PM.205 After setting page template values 
0 ms
 
1,236 ms
7:31:55 PM.206 CartViewModel.CreateInstance START 
1 ms
 
1,237 ms
7:31:55 PM.207 CreateDataReader - took: 0 ms.
USE [kids21new]
DECLARE @p0 NVARCHAR(12) = N'100293333WHT', @p1 INT = 0
SELECT * FROM EcomDetails WITH (NOLOCK) WHERE DetailProductID IN (@p0) AND DetailType = @p1 ORDER BY DetailLanguageID, DetailsGroupId, DetailSortOrder
System.Data.IDataReader CreateDataReader(System.Data.IDbCommand, System.Data.CommandBehavior) (Dynamicweb.Data.dll) in :0
System.Data.IDataReader CreateDataReader(Dynamicweb.Data.CommandBuilder, System.Data.IDbConnection, System.Data.IDbTransaction, System.Data.CommandBehavior, Int32) (Dynamicweb.Data.dll) in :0
System.Data.IDataReader CreateDataReader(Dynamicweb.Data.CommandBuilder, System.Data.IDbConnection, System.Data.IDbTransaction, Int32) (Dynamicweb.Data.dll) in :0
System.Collections.Generic.IEnumerable`1[Dynamicweb.Ecommerce.Products.InheritedDetail] GetInheritedDetailsBulk(System.Collections.Generic.List`1[System.String], System.String) (Dynamicweb.Ecommerce.dll) in :0
System.Collections.Generic.Dictionary`2[System.String,System.Collections.Generic.List`1[Dynamicweb.Ecommerce.Products.Detail]] GetDetailsBulk(System.Collections.Generic.IEnumerable`1[Dynamicweb.Ecommerce.Products.ProductKey], System.String, Boolean) (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Frontend.CartViewModel CreateCartViewModel(Dynamicweb.Ecommerce.Orders.Order, System.Nullable`1[System.Int32]) (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Frontend.CartViewModel CreateInstance(Dynamicweb.Ecommerce.Orders.Order, System.Nullable`1[System.Int32]) (Dynamicweb.Ecommerce.dll) in :0
Void OnNotify(System.String, Dynamicweb.Extensibility.Notifications.NotificationArgs) (Dynamicweb.Ecommerce.dll) in :0
Void Notify(System.String, Dynamicweb.Extensibility.Notifications.NotificationArgs) (Dynamicweb.Extensibility.dll) in :0
System.String Output() (Dynamicweb.dll) in :0
Void ProcessRequest(System.Web.HttpContext) (Dynamicweb.AspNet.dll) in :0		 
1 ms
 
1,238 ms
7:31:55 PM.214 CartViewModel.CreateInstance END 
7 ms
 
1,245 ms
7:31:55 PM.214 After Page.OnOutput notification 
0 ms
 
1,245 ms
7:31:55 PM.214 Starting template.output (C:\Server\Kids21\Custom\Files\Templates\Designs\Kids21\_parsed\ContentPage.parsed.cshtml) 
0 ms
 
1,245 ms
7:31:55 PM.444 After provider (Dynamicweb.Ecommerce.Frontend.NavigationProviders.GroupNavigationProvider) 
230 ms
 
1,475 ms
7:31:55 PM.506 After provider (Dynamicweb.Ecommerce.Frontend.NavigationProviders.GroupNavigationProvider) 
62 ms
 
1,537 ms
7:31:55 PM.539 After Run (C:\Server\Kids21\Custom\Files\Templates\Designs\Kids21\_parsed\ContentPage.parsed.cshtml) 
33 ms
 
1,570 ms
7:31:55 PM.539 Ending Template.Output (C:\Server\Kids21\Custom\Files\Templates\Designs\Kids21\_parsed\ContentPage.parsed.cshtml) - took: 328.1449 ms. 
0 ms
 
1,570 ms
7:31:55 PM.539 After template output 
0 ms
 
1,570 ms
7:31:55 PM.539 After navigation tags 
0 ms
 
1,570 ms
7:31:55 PM.539 After global paragraphs 
0 ms
 
1,570 ms
7:31:55 PM.539 After cdn replace 
0 ms
 
1,570 ms
7:31:55 PM.540 After snippets 
1 ms
 
1,571 ms
7:31:55 PM.540 After globalTemplate start 
0 ms
 
1,571 ms
7:31:55 PM.540 After Page.AfterOutput notification 
0 ms
 
1,571 ms
7:31:55 PM.540 Starting template.output (MEM) 
0 ms
 
1,571 ms
7:31:55 PM.540 Ending Template.Output (MEM) - took: 0 ms. 
0 ms
 
1,571 ms
7:31:55 PM.540 After globalTemplate.Output 
0 ms
 
1,571 ms
7:31:55 PM.540 Start URL Replace 
0 ms
 
1,571 ms
7:31:55 PM.540 window.open replace... 
0 ms
 
1,571 ms
7:31:55 PM.542 End URL Replace 
2 ms
 
1,573 ms
7:31:55 PM.543 Starting template.output (MEM) 
1 ms
 
1,574 ms
7:31:55 PM.543 Ending Template.Output (MEM) - took: 0 ms. 
0 ms
 
1,574 ms
7:31:55 PM.543 After Page.AfterRender notification 
0 ms
 
1,574 ms
7:31:55 PM.544 After MinifyHtml 
1 ms
 
1,575 ms
7:31:55 PM.544 End Execution 
0 ms
 
1,575 ms
 
Shiwanka Chathuranga Dynamicweb Employee
Shiwanka Chathuranga
Posted on 07/10/2022 04:49:12
Reply

HI

I face same issue in product detail page also when items in cart and user is logged in

Time Event From last From start
10:45:38 AM.544 Begin Execution 
0 ms
 
0 ms
10:45:38 AM.544 Begin Pageview 
0 ms
 
0 ms
10:45:38 AM.544 Begin Pageview.Loads 
0 ms
 
0 ms
10:45:38 AM.544 Before checking publish 
0 ms
 
0 ms
10:45:38 AM.544 After checking publish 
0 ms
 
0 ms
10:45:38 AM.544 After lock domain 
0 ms
 
0 ms
10:45:38 AM.544 After setting ID's 
0 ms
 
0 ms
10:45:38 AM.544 After Tracking experiments 
0 ms
 
0 ms
10:45:38 AM.544 After checking SSL mode 
0 ms
 
0 ms
10:45:38 AM.544 After setting encoding 
0 ms
 
0 ms
10:45:38 AM.544 Before statistics 
0 ms
 
0 ms
10:45:38 AM.544 After setting content ID 
0 ms
 
0 ms
10:45:38 AM.544 After setting Item 
0 ms
 
0 ms
10:45:38 AM.544 After setting Metadata 
0 ms
 
0 ms
10:45:38 AM.544 After setting layout template 
0 ms
 
0 ms
10:45:38 AM.544 Before Extranet login 
0 ms
 
0 ms
10:45:38 AM.544 After Extranet login 
0 ms
 
0 ms
10:45:38 AM.545 After Notifications.Standard.Page.Loaded 
1 ms
 
1 ms
10:45:38 AM.545 Start Output 
0 ms
 
1 ms
10:45:38 AM.545 Setting headers 
0 ms
 
1 ms
10:45:38 AM.545 Set Page Template Values 
0 ms
 
1 ms
10:45:38 AM.545 After Notifications.Standard.Page.PageTitle 
0 ms
 
1 ms
10:45:38 AM.545 PageViewModel.CreateInstance START 
0 ms
 
1 ms
10:45:38 AM.558 ItemViewModel.CreateInstance Start (ContentRow, 36) 
13 ms
 
14 ms
10:45:38 AM.558 ItemViewModel.CreateInstance End 
0 ms
 
14 ms
10:45:38 AM.558 ItemViewModel.CreateInstance Start (ContentRow, 17) 
0 ms
 
14 ms
10:45:38 AM.558 ItemViewModel.CreateInstance End 
0 ms
 
14 ms
10:45:38 AM.558 Render Grid - ID: 'Pages', Container: 'Grid' 
0 ms
 
14 ms
10:45:38 AM.558 Render GridRow - ID: '37' 
0 ms
 
14 ms
10:45:38 AM.558 Starting template.output (E:\LiveWeb\Custom\Files\Templates\Designs\Kids21\Grid\Pages\RowTemplates\12column.cshtml) 
0 ms
 
14 ms
10:45:38 AM.558 Render GridColumn - ID: '1', ParagraphID: '49' 
0 ms
 
14 ms
10:45:38 AM.558 RenderParagraph Start - ID: 49, Container: 
0 ms
 
14 ms
10:45:38 AM.559 RenderParagraph after permissions - ID: 49, Container: 
1 ms
 
15 ms
10:45:38 AM.559 RenderParagraph after template - ID: 49, Container: 
0 ms
 
15 ms
10:45:38 AM.559 ItemViewModel.CreateInstance Start (App, 26) 
0 ms
 
15 ms
10:45:38 AM.559 ItemViewModel.CreateInstance End 
0 ms
 
15 ms
10:45:38 AM.559 RenderParagraph after ParagraphViewModel - ID: 49, Container: 
0 ms
 
15 ms
10:45:38 AM.559 Render Paragraph - ID: 49, Container: , Template: Designs/Kids21/ContentPage/Paragraph/App.cshtml 
0 ms
 
15 ms
10:45:38 AM.559 Starting template.output (E:\LiveWeb\Custom\Files\Templates\Designs\Kids21\ContentPage\Paragraph\App.cshtml) 
0 ms
 
15 ms
10:45:38 AM.559 Start module (PID = 49): eCom_Catalog 
0 ms
 
15 ms
10:45:38 AM.560 <-- eCom: start GetContent --> 
1 ms
 
16 ms
10:45:38 AM.561 After: productVariantId 
1 ms
 
17 ms
10:45:38 AM.561 After: Ecom:Product.* fields 
0 ms
 
17 ms
10:45:38 AM.561 After: Ecom:Product.Meta 
0 ms
 
17 ms
10:45:38 AM.561 After: vatGroup 
0 ms
 
17 ms
10:45:38 AM.561 After: ImageParagraphPattern 
0 ms
 
17 ms
10:45:38 AM.561 After: ImageGlobalPattern 
0 ms
 
17 ms
10:45:38 AM.562 After: RenderImagePatterns 
1 ms
 
18 ms
10:45:38 AM.562 After: RenderCurrency 
0 ms
 
18 ms
10:45:38 AM.562 After: RenderCustomProductField 
0 ms
 
18 ms
10:45:38 AM.562 After: MyListsRenderer.RenderProduct 
0 ms
 
18 ms
10:45:38 AM.562 After: extended properties 
0 ms
 
18 ms
10:45:38 AM.562 After: RenderProductCategories 
0 ms
 
18 ms
10:45:38 AM.562 After: RenderOrderContexts 
0 ms
 
18 ms
10:45:38 AM.562 After: RenderLastAddedProduct 
0 ms
 
18 ms
10:45:38 AM.562 Applying product template extender (Dynamicweb.Ecommerce.DynamicwebLiveIntegration.TemplateExtenders.ProductTemplateExtender-Dynamicweb.Ecommerce.DynamicwebLiveIntegration, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null) 
0 ms
 
18 ms
10:45:38 AM.562 Applying done - took 0 ms. 
0 ms
 
18 ms
10:45:38 AM.562 After: RenderProductTemplateExtenders 
0 ms
 
18 ms
10:45:38 AM.562 Starting template.output (E:\LiveWeb\Custom\Files\Templates\) 
0 ms
 
18 ms
10:45:38 AM.562 Ending Template.Output (E:\LiveWeb\Custom\Files\Templates\) - took: 0 ms. 
0 ms
 
18 ms
10:45:38 AM.562 <-- eCom: end GetContent --> 
0 ms
 
18 ms
10:45:38 AM.562 After Run (E:\LiveWeb\Custom\Files\Templates\Designs\Kids21\ContentPage\Paragraph\App.cshtml) 
0 ms
 
18 ms
10:45:38 AM.562 Ending Template.Output (E:\LiveWeb\Custom\Files\Templates\Designs\Kids21\ContentPage\Paragraph\App.cshtml) - took: 0 ms. 
0 ms
 
18 ms
10:45:38 AM.562 After Run (E:\LiveWeb\Custom\Files\Templates\Designs\Kids21\Grid\Pages\RowTemplates\12column.cshtml) 
0 ms
 
18 ms
10:45:38 AM.562 Ending Template.Output (E:\LiveWeb\Custom\Files\Templates\Designs\Kids21\Grid\Pages\RowTemplates\12column.cshtml) - took: 0 ms. 
0 ms
 
18 ms
10:45:38 AM.562 Render GridRow - ID: '18' 
0 ms
 
18 ms
10:45:38 AM.562 Starting template.output (E:\LiveWeb\Custom\Files\Templates\Designs\Kids21\Grid\Pages\RowTemplates\12column.cshtml) 
0 ms
 
18 ms
10:45:38 AM.562 Render GridColumn - ID: '1', ParagraphID: '26' 
0 ms
 
18 ms
10:45:38 AM.562 RenderParagraph Start - ID: 26, Container: 
0 ms
 
18 ms
10:45:38 AM.563 RenderParagraph after permissions - ID: 26, Container: 
1 ms
 
19 ms
10:45:38 AM.563 RenderParagraph after template - ID: 26, Container: 
0 ms
 
19 ms
10:45:38 AM.563 ItemViewModel.CreateInstance Start (App, 4) 
0 ms
 
19 ms
10:45:38 AM.563 ItemViewModel.CreateInstance End 
0 ms
 
19 ms
10:45:38 AM.563 RenderParagraph after ParagraphViewModel - ID: 26, Container: 
0 ms
 
19 ms
10:45:38 AM.563 Render Paragraph - ID: 26, Container: , Template: Designs/Kids21/ContentPage/Paragraph/App.cshtml 
0 ms
 
19 ms
10:45:38 AM.563 Starting template.output (E:\LiveWeb\Custom\Files\Templates\Designs\Kids21\ContentPage\Paragraph\App.cshtml) 
0 ms
 
19 ms
10:45:38 AM.563 Start module (PID = 26): eCom_Catalog 
0 ms
 
19 ms
10:45:38 AM.564 <-- eCom: start GetContent --> 
1 ms
 
20 ms
10:45:38 AM.565 After: productVariantId 
1 ms
 
21 ms
10:45:38 AM.565 After: Ecom:Product.* fields 
0 ms
 
21 ms
10:45:38 AM.565 After: Ecom:Product.Meta 
0 ms
 
21 ms
10:45:38 AM.565 After: vatGroup 
0 ms
 
21 ms
10:45:38 AM.565 After: ImageParagraphPattern 
0 ms
 
21 ms
10:45:38 AM.565 After: ImageGlobalPattern 
0 ms
 
21 ms
10:45:38 AM.565 After: RenderImagePatterns 
0 ms
 
21 ms
10:45:38 AM.566 After: RenderCurrency 
1 ms
 
22 ms
10:45:38 AM.566 After: RenderCustomProductField 
0 ms
 
22 ms
10:45:38 AM.566 After: MyListsRenderer.RenderProduct 
0 ms
 
22 ms
10:45:38 AM.567 After: extended properties 
1 ms
 
23 ms
10:45:38 AM.567 After: RenderProductCategories 
0 ms
 
23 ms
10:45:38 AM.567 After: RenderOrderContexts 
0 ms
 
23 ms
10:45:38 AM.567 After: RenderLastAddedProduct 
0 ms
 
23 ms
10:45:38 AM.567 Applying product template extender (Dynamicweb.Ecommerce.DynamicwebLiveIntegration.TemplateExtenders.ProductTemplateExtender-Dynamicweb.Ecommerce.DynamicwebLiveIntegration, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null) 
0 ms
 
23 ms
10:45:38 AM.567 Applying done - took 0 ms. 
0 ms
 
23 ms
10:45:38 AM.567 After: RenderProductTemplateExtenders 
0 ms
 
23 ms
10:45:38 AM.568 Starting template.output (E:\LiveWeb\Custom\Files\Templates\Designs\Kids21\eCom\Product\ProductDetails.cshtml) 
1 ms
 
24 ms
10:45:38 AM.568 Begin Pageview 
0 ms
 
24 ms
10:45:38 AM.568 Begin Pageview.Loads 
0 ms
 
24 ms
10:45:38 AM.568 Before checking publish 
0 ms
 
24 ms
10:45:38 AM.568 After checking publish 
0 ms
 
24 ms
10:45:38 AM.568 After lock domain 
0 ms
 
24 ms
10:45:38 AM.568 After setting ID's 
0 ms
 
24 ms
10:45:38 AM.568 After Tracking experiments 
0 ms
 
24 ms
10:45:38 AM.568 After checking SSL mode 
0 ms
 
24 ms
10:45:38 AM.568 After setting encoding 
0 ms
 
24 ms
10:45:38 AM.568 Before statistics 
0 ms
 
24 ms
10:45:38 AM.568 After setting content ID 
0 ms
 
24 ms
10:45:38 AM.568 After setting Item 
0 ms
 
24 ms
10:45:38 AM.568 After setting Metadata 
0 ms
 
24 ms
10:45:38 AM.568 After setting layout template 
0 ms
 
24 ms
10:45:38 AM.568 Before Extranet login 
0 ms
 
24 ms
10:45:38 AM.568 After Extranet login 
0 ms
 
24 ms
10:45:38 AM.569 After Notifications.Standard.Page.Loaded 
1 ms
 
25 ms
10:45:38 AM.569 ItemViewModel.CreateInstance Start (WebSite, 1) 
0 ms
 
25 ms
10:45:38 AM.569 ItemViewModel.CreateInstance End 
0 ms
 
25 ms
10:45:38 AM.569 Begin Pageview 
0 ms
 
25 ms
10:45:38 AM.569 Begin Pageview.Loads 
0 ms
 
25 ms
10:45:38 AM.569 Before checking publish 
0 ms
 
25 ms
10:45:38 AM.569 After checking publish 
0 ms
 
25 ms
10:45:38 AM.569 After lock domain 
0 ms
 
25 ms
10:45:38 AM.570 After setting ID's 
1 ms
 
26 ms
10:45:38 AM.570 After Tracking experiments 
0 ms
 
26 ms
10:45:38 AM.570 After checking SSL mode 
0 ms
 
26 ms
10:45:38 AM.570 After setting encoding 
0 ms
 
26 ms
10:45:38 AM.570 Before statistics 
0 ms
 
26 ms
10:45:38 AM.570 After setting content ID 
0 ms
 
26 ms
10:45:38 AM.570 After setting Item 
0 ms
 
26 ms
10:45:38 AM.570 After setting Metadata 
0 ms
 
26 ms
10:45:38 AM.570 After setting layout template 
0 ms
 
26 ms
10:45:38 AM.570 Before Extranet login 
0 ms
 
26 ms
10:45:38 AM.570 After Extranet login 
0 ms
 
26 ms
10:45:38 AM.570 After Notifications.Standard.Page.Loaded 
0 ms
 
26 ms
10:45:38 AM.570 ItemViewModel.CreateInstance Start (WebSite, 1) 
0 ms
 
26 ms
10:45:38 AM.570 ItemViewModel.CreateInstance End 
0 ms
 
26 ms
10:45:38 AM.571 ItemViewModel.CreateInstance Start (WebSite, 1) 
1 ms
 
27 ms
10:45:38 AM.571 ItemViewModel.CreateInstance End 
0 ms
 
27 ms
10:45:38 AM.786 After provider (Dynamicweb.Ecommerce.Frontend.NavigationProviders.GroupNavigationProvider) 
215 ms
 
242 ms
10:45:38 AM.824 After Run (E:\LiveWeb\Custom\Files\Templates\Designs\Kids21\eCom\Product\ProductDetails.cshtml) 
38 ms
 
280 ms
10:45:38 AM.824 Ending Template.Output (E:\LiveWeb\Custom\Files\Templates\Designs\Kids21\eCom\Product\ProductDetails.cshtml) - took: 256.2054 ms. 
0 ms
 
280 ms
10:45:38 AM.824 <-- eCom: end GetContent --> 
0 ms
 
280 ms
10:45:38 AM.824 After Run (E:\LiveWeb\Custom\Files\Templates\Designs\Kids21\ContentPage\Paragraph\App.cshtml) 
0 ms
 
280 ms
10:45:38 AM.824 Ending Template.Output (E:\LiveWeb\Custom\Files\Templates\Designs\Kids21\ContentPage\Paragraph\App.cshtml) - took: 261.2022 ms. 
0 ms
 
280 ms
10:45:38 AM.825 After Run (E:\LiveWeb\Custom\Files\Templates\Designs\Kids21\Grid\Pages\RowTemplates\12column.cshtml) 
1 ms
 
281 ms
10:45:38 AM.825 Ending Template.Output (E:\LiveWeb\Custom\Files\Templates\Designs\Kids21\Grid\Pages\RowTemplates\12column.cshtml) - took: 261.2022 ms. 
0 ms
 
281 ms
10:45:38 AM.825 PageViewModel.CreateInstance after PageViewModel 
0 ms
 
281 ms
10:45:38 AM.825 ItemViewModel.CreateInstance Start (ContentPage, 4) 
0 ms
 
281 ms
10:45:38 AM.825 ItemViewModel.CreateInstance End 
0 ms
 
281 ms
10:45:38 AM.825 PageViewModel.CreateInstance after ItemViewModel 
0 ms
 
281 ms
10:45:38 AM.825 ItemViewModel.CreateInstance Start (WebPage, 90) 
0 ms
 
281 ms
10:45:38 AM.825 ItemViewModel.CreateInstance End 
0 ms
 
281 ms
10:45:38 AM.825 PageViewModel.CreateInstance after PropertyItem 
0 ms
 
281 ms
10:45:38 AM.825 PageViewModel.CreateInstance after Path 
0 ms
 
281 ms
10:45:38 AM.825 PageViewModel.CreateInstance after Languages 
0 ms
 
281 ms
10:45:38 AM.825 PageViewModel.CreateInstance after languagePages 
0 ms
 
281 ms
10:45:38 AM.825 AreaViewModel.CreateInstance START 
0 ms
 
281 ms
10:45:38 AM.825 AreaViewModel.CreateInstance after AreaViewModel init 
0 ms
 
281 ms
10:45:38 AM.825 ItemViewModel.CreateInstance Start (WebSite, 1) 
0 ms
 
281 ms
10:45:38 AM.825 ItemViewModel.CreateInstance End 
0 ms
 
281 ms
10:45:38 AM.825 AreaViewModel.CreateInstance after ItemViewModel 
0 ms
 
281 ms
10:45:38 AM.826 AreaViewModel.CreateInstance after FirstPage 
1 ms
 
282 ms
10:45:38 AM.826 AreaViewModel.CreateInstance after FirstActivePage 
0 ms
 
282 ms
10:45:38 AM.826 AreaViewModel.CreateInstance after SearchPage 
0 ms
 
282 ms
10:45:38 AM.826 AreaViewModel.CreateInstance after CartPage 
0 ms
 
282 ms
10:45:38 AM.826 AreaViewModel.CreateInstance after Languages load 
0 ms
 
282 ms
10:45:38 AM.826 AreaViewModel.CreateInstance after Languages AreaLanguageViewModel 
0 ms
 
282 ms
10:45:38 AM.826 AreaViewModel.CreateInstance END 
0 ms
 
282 ms
10:45:38 AM.826 PageViewModel.CreateInstance after AreaViewModel 
0 ms
 
282 ms
10:45:38 AM.826 PageViewModel.CreateInstance after UserViewModel 
0 ms
 
282 ms
10:45:38 AM.826 PageViewModel.CreateInstance END 
0 ms
 
282 ms
10:45:38 AM.826 Before RenderPage 
0 ms
 
282 ms
10:45:38 AM.826 After setting page template values 
0 ms
 
282 ms
10:45:38 AM.874 ExecuteNonQuery - took: 50.0327 ms.
USE [CB21LIVEDB]
DECLARE @p0 NVARCHAR(9) = N'OL1390286'
DELETE FROM EcomOrderLines WHERE OrderLineID = @p0; DELETE FROM EcomOrderLines WHERE OrderLineParentLineID = @p0;		 
48 ms
 
330 ms
10:45:38 AM.884 CreateDataReader - took: 1 ms.
USE [CB21LIVEDB]
DECLARE @p0 INT = 953, @p1 INT = 1, @p2 INT = 3, @p3 INT = 4, @p4 INT = 5, @p5 INT = 15
SELECT * FROM [AccessUser] WITH (NOLOCK) WHERE ( [AccessUser].[AccessUserID] = @p0 ) AND ( [AccessUser].[AccessUserType] IN (@p1,@p2,@p3,@p4,@p5) )
System.Data.IDataReader CreateDataReader(System.Data.IDbCommand, System.Data.CommandBehavior) (Dynamicweb.Data.dll) in :0
System.Data.IDataReader CreateDataReader(Dynamicweb.Data.CommandBuilder, System.Data.IDbConnection, System.Data.IDbTransaction, System.Data.CommandBehavior, Int32) (Dynamicweb.Data.dll) in :0
System.Data.IDataReader CreateDataReader(Dynamicweb.Data.CommandBuilder, System.Data.IDbConnection, System.Data.IDbTransaction, Int32) (Dynamicweb.Data.dll) in :0
Dynamicweb.Security.UserManagement.User GetUser(Dynamicweb.Data.CommandBuilder) (Dynamicweb.Security.dll) in :0
Dynamicweb.Security.UserManagement.User GetUserByID(Int32, Boolean) (Dynamicweb.Security.dll) in :0
Dynamicweb.Ecommerce.Prices.PriceContext GetPriceContext() (Dynamicweb.Ecommerce.dll) in :0
Void CalculateDiscounts(Dynamicweb.Ecommerce.Orders.Order) (Dynamicweb.Ecommerce.dll) in :0
Void HandleDiscountAndTaxes(Dynamicweb.Ecommerce.Orders.Order, Boolean) (Dynamicweb.Ecommerce.dll) in :0
Void OnNotify(System.String, Dynamicweb.Extensibility.Notifications.NotificationArgs) (Dynamicweb.Ecommerce.dll) in :0
Void Notify(System.String, Dynamicweb.Extensibility.Notifications.NotificationArgs) (Dynamicweb.Extensibility.dll) in :0
System.String Output() (Dynamicweb.dll) in :0
Void ProcessRequest(System.Web.HttpContext) (Dynamicweb.AspNet.dll) in :0		 
10 ms
 
340 ms
10:45:38 AM.911 ExecuteScalar - took: 24.9361 ms.
USE [CB21LIVEDB]
DECLARE @p0 NVARCHAR(2) = N'26', @p1 INT = 953
select count(OrderAutoID) FROM EcomOrders inner join EcomOrderLines on EcomOrders.OrderID = EcomOrderLines.OrderLineOrderID where ecomorderlines.OrderLineDiscountID = @p0 and OrderComplete = 1 and EcomOrders.OrderCustomerAccessUserID = @p1		 
27 ms
 
367 ms
10:45:38 AM.983 ExecuteScalar - took: 20.0284 ms.
USE [CB21LIVEDB]
DECLARE @p0 NVARCHAR(3) = N'348', @p1 INT = 953
select count(OrderAutoID) FROM EcomOrders inner join EcomOrderLines on EcomOrders.OrderID = EcomOrderLines.OrderLineOrderID where ecomorderlines.OrderLineDiscountID = @p0 and OrderComplete = 1 and EcomOrders.OrderCustomerAccessUserID = @p1		 
72 ms
 
439 ms
10:45:39 AM.20 ExecuteScalar - took: 30.0261 ms.
USE [CB21LIVEDB]
DECLARE @p0 NVARCHAR(2) = N'26', @p1 INT = 953
select count(OrderAutoID) FROM EcomOrders inner join EcomOrderLines on EcomOrders.OrderID = EcomOrderLines.OrderLineOrderID where ecomorderlines.OrderLineDiscountID = @p0 and OrderComplete = 1 and EcomOrders.OrderCustomerAccessUserID = @p1		 
37 ms
 
476 ms
10:45:39 AM.70 CreateDataReader - took: 2 ms.
USE [CB21LIVEDB]
SELECT EcomPrices.* FROM EcomPrices WHERE PriceProductID='100314283OWT' ORDER BY PriceID
System.Data.IDataReader CreateDataReader(System.Data.IDbCommand, System.Data.CommandBehavior) (Dynamicweb.Data.dll) in :0
System.Data.IDataReader CreateDataReader(System.String, System.Data.IDbConnection, System.Data.IDbTransaction, System.Data.CommandBehavior, Int32, System.Collections.Generic.Dictionary`2[System.String,System.Tuple`2[System.Object,System.Data.DbType]]) (Dynamicweb.Data.dll) in :0
System.Data.IDataReader CreateDataReader(System.String, System.Data.IDbConnection, System.Data.IDbTransaction, Int32, System.Collections.Generic.Dictionary`2[System.String,System.Tuple`2[System.Object,System.Data.DbType]]) (Dynamicweb.Data.dll) in :0
System.Collections.Generic.List`1[Dynamicweb.Ecommerce.Prices.Price] GetPricesBySql(System.String) (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Ecommerce.Prices.PriceCollection GetPriceCollection(System.String) (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Ecommerce.Prices.PriceCollection GetPrices(System.String) (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Ecommerce.Prices.PriceRaw FindPriceInternal(Dynamicweb.Ecommerce.Prices.PriceContext, Dynamicweb.Ecommerce.Prices.PriceProductSelection, Boolean) (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Ecommerce.Prices.PriceRaw FindPrice(Dynamicweb.Ecommerce.Prices.PriceContext, Dynamicweb.Ecommerce.Prices.PriceProductSelection) (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Ecommerce.Prices.PriceRaw FindPrice(Dynamicweb.Ecommerce.Products.Product, Double, System.String, Dynamicweb.Ecommerce.International.Currency, System.String, Dynamicweb.Security.UserManagement.User, Double, System.String, Dynamicweb.Ecommerce.Stocks.StockLocation) (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Ecommerce.Prices.PriceRaw FindPrice(Dynamicweb.Ecommerce.Products.Product, Double, System.String, Dynamicweb.Ecommerce.International.Currency, System.String, Dynamicweb.Security.UserManagement.User, Double, System.String) (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Ecommerce.Prices.PriceRaw FindPrice(Dynamicweb.Ecommerce.Products.Product, Double, System.String, Dynamicweb.Ecommerce.International.Currency, System.String, Dynamicweb.Security.UserManagement.User, Double) (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Ecommerce.Prices.PriceRaw FindPrice(Dynamicweb.Ecommerce.Products.Product, Double, System.String, Dynamicweb.Ecommerce.International.Currency, System.String, Dynamicweb.Security.UserManagement.User) (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Ecommerce.Prices.PriceRaw FindPrice(Dynamicweb.Ecommerce.Products.Product, Double, System.String, Dynamicweb.Ecommerce.International.Currency, System.String, Dynamicweb.Security.UserManagement.User) (Kids21.dll) in :0
Dynamicweb.Ecommerce.Prices.PriceRaw FindPrice(Dynamicweb.Ecommerce.Prices.PriceContext, Dynamicweb.Ecommerce.Prices.PriceProductSelection) (Dynamicweb.Ecommerce.dll) in :0
System.Object FindPriceInternal(Dynamicweb.Ecommerce.Prices.PriceProvider, Dynamicweb.Ecommerce.Prices.PriceContext, Dynamicweb.Ecommerce.Prices.PriceProductSelection, Boolean) (Dynamicweb.Ecommerce.dll) in :0
System.Object FindPrice(Dynamicweb.Ecommerce.Prices.PriceContext, Dynamicweb.Ecommerce.Prices.PriceProductSelection, Boolean) (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Ecommerce.Prices.PriceInfo FindPrice(Dynamicweb.Ecommerce.Prices.PriceContext, Boolean) (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Ecommerce.Prices.PriceInfo get_UnitPrice() (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Ecommerce.Prices.PriceInfo get_Price() (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Ecommerce.Prices.PriceInfo GetRequestCachedPrice(System.String, System.String, System.Func`1[Dynamicweb.Ecommerce.Prices.PriceInfo]) (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Ecommerce.Orders.OrderLine CreateOrderLine(Dynamicweb.Ecommerce.Orders.Discounts.Discount, Dynamicweb.Ecommerce.Orders.Order, Dynamicweb.Ecommerce.Orders.OrderLine) (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Ecommerce.Orders.OrderLine GetDiscountOrderLine(Dynamicweb.Ecommerce.Orders.Order, Dynamicweb.Ecommerce.Orders.Discounts.Discount, Dynamicweb.Ecommerce.Orders.OrderLine, System.DateTime, System.String, System.Collections.Generic.IList`1[Dynamicweb.Ecommerce.Orders.OrderLine]) (Dynamicweb.Ecommerce.dll) in :0
Boolean ProcessDiscounts(Dynamicweb.Ecommerce.Orders.Order, System.Collections.Generic.IList`1[Dynamicweb.Ecommerce.Orders.OrderLine]) (Dynamicweb.Ecommerce.dll) in :0
Void CalculateDiscounts(Dynamicweb.Ecommerce.Orders.Order) (Dynamicweb.Ecommerce.dll) in :0
Void HandleDiscountAndTaxes(Dynamicweb.Ecommerce.Orders.Order, Boolean) (Dynamicweb.Ecommerce.dll) in :0
Void OnNotify(System.String, Dynamicweb.Extensibility.Notifications.NotificationArgs) (Dynamicweb.Ecommerce.dll) in :0
Void Notify(System.String, Dynamicweb.Extensibility.Notifications.NotificationArgs) (Dynamicweb.Extensibility.dll) in :0
System.String Output() (Dynamicweb.dll) in :0
Void ProcessRequest(System.Web.HttpContext) (Dynamicweb.AspNet.dll) in :0		 
50 ms
 
526 ms
10:45:39 AM.83 CreateDataReader - took: 1 ms.
USE [CB21LIVEDB]
SELECT EcomPrices.* FROM EcomPrices WHERE PriceProductID='100282641WHT' ORDER BY PriceID
System.Data.IDataReader CreateDataReader(System.Data.IDbCommand, System.Data.CommandBehavior) (Dynamicweb.Data.dll) in :0
System.Data.IDataReader CreateDataReader(System.String, System.Data.IDbConnection, System.Data.IDbTransaction, System.Data.CommandBehavior, Int32, System.Collections.Generic.Dictionary`2[System.String,System.Tuple`2[System.Object,System.Data.DbType]]) (Dynamicweb.Data.dll) in :0
System.Data.IDataReader CreateDataReader(System.String, System.Data.IDbConnection, System.Data.IDbTransaction, Int32, System.Collections.Generic.Dictionary`2[System.String,System.Tuple`2[System.Object,System.Data.DbType]]) (Dynamicweb.Data.dll) in :0
System.Collections.Generic.List`1[Dynamicweb.Ecommerce.Prices.Price] GetPricesBySql(System.String) (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Ecommerce.Prices.PriceCollection GetPriceCollection(System.String) (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Ecommerce.Prices.PriceCollection GetPrices(System.String) (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Ecommerce.Prices.PriceRaw FindPriceInternal(Dynamicweb.Ecommerce.Prices.PriceContext, Dynamicweb.Ecommerce.Prices.PriceProductSelection, Boolean) (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Ecommerce.Prices.PriceRaw FindPrice(Dynamicweb.Ecommerce.Prices.PriceContext, Dynamicweb.Ecommerce.Prices.PriceProductSelection) (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Ecommerce.Prices.PriceRaw FindPrice(Dynamicweb.Ecommerce.Products.Product, Double, System.String, Dynamicweb.Ecommerce.International.Currency, System.String, Dynamicweb.Security.UserManagement.User, Double, System.String, Dynamicweb.Ecommerce.Stocks.StockLocation) (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Ecommerce.Prices.PriceRaw FindPrice(Dynamicweb.Ecommerce.Products.Product, Double, System.String, Dynamicweb.Ecommerce.International.Currency, System.String, Dynamicweb.Security.UserManagement.User, Double, System.String) (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Ecommerce.Prices.PriceRaw FindPrice(Dynamicweb.Ecommerce.Products.Product, Double, System.String, Dynamicweb.Ecommerce.International.Currency, System.String, Dynamicweb.Security.UserManagement.User, Double) (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Ecommerce.Prices.PriceRaw FindPrice(Dynamicweb.Ecommerce.Products.Product, Double, System.String, Dynamicweb.Ecommerce.International.Currency, System.String, Dynamicweb.Security.UserManagement.User) (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Ecommerce.Prices.PriceRaw FindPrice(Dynamicweb.Ecommerce.Products.Product, Double, System.String, Dynamicweb.Ecommerce.International.Currency, System.String, Dynamicweb.Security.UserManagement.User) (Kids21.dll) in :0
Dynamicweb.Ecommerce.Prices.PriceRaw FindPrice(Dynamicweb.Ecommerce.Prices.PriceContext, Dynamicweb.Ecommerce.Prices.PriceProductSelection) (Dynamicweb.Ecommerce.dll) in :0
System.Object FindPriceInternal(Dynamicweb.Ecommerce.Prices.PriceProvider, Dynamicweb.Ecommerce.Prices.PriceContext, Dynamicweb.Ecommerce.Prices.PriceProductSelection, Boolean) (Dynamicweb.Ecommerce.dll) in :0
System.Object FindPrice(Dynamicweb.Ecommerce.Prices.PriceContext, Dynamicweb.Ecommerce.Prices.PriceProductSelection, Boolean) (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Ecommerce.Prices.PriceInfo FindPrice(Dynamicweb.Ecommerce.Prices.PriceContext, Boolean) (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Ecommerce.Prices.PriceInfo get_UnitPrice() (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Ecommerce.Prices.PriceInfo get_Price() (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Ecommerce.Prices.PriceInfo get_Price() (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Ecommerce.Prices.PriceInfo GetPriceBeforeFees(Boolean) (Dynamicweb.Ecommerce.dll) in :0
Boolean CheckTotalPrice(Dynamicweb.Ecommerce.Orders.Discounts.Discount, Dynamicweb.Ecommerce.Orders.Order) (Dynamicweb.Ecommerce.dll) in :0
Boolean IsDiscountForOrder(Dynamicweb.Ecommerce.Orders.Order, Dynamicweb.Ecommerce.Orders.Discounts.Discount, Dynamicweb.Ecommerce.Orders.OrderLine, System.DateTime, System.String, System.Collections.Generic.IList`1[Dynamicweb.Ecommerce.Orders.OrderLine], Boolean) (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Ecommerce.Orders.OrderLine GetDiscountOrderLine(Dynamicweb.Ecommerce.Orders.Order, Dynamicweb.Ecommerce.Orders.Discounts.Discount, Dynamicweb.Ecommerce.Orders.OrderLine, System.DateTime, System.String, System.Collections.Generic.IList`1[Dynamicweb.Ecommerce.Orders.OrderLine]) (Dynamicweb.Ecommerce.dll) in :0
Boolean ProcessDiscounts(Dynamicweb.Ecommerce.Orders.Order, System.Collections.Generic.IList`1[Dynamicweb.Ecommerce.Orders.OrderLine]) (Dynamicweb.Ecommerce.dll) in :0
Void CalculateDiscounts(Dynamicweb.Ecommerce.Orders.Order) (Dynamicweb.Ecommerce.dll) in :0
Void HandleDiscountAndTaxes(Dynamicweb.Ecommerce.Orders.Order, Boolean) (Dynamicweb.Ecommerce.dll) in :0
Void OnNotify(System.String, Dynamicweb.Extensibility.Notifications.NotificationArgs) (Dynamicweb.Ecommerce.dll) in :0
Void Notify(System.String, Dynamicweb.Extensibility.Notifications.NotificationArgs) (Dynamicweb.Extensibility.dll) in :0
System.String Output() (Dynamicweb.dll) in :0
Void ProcessRequest(System.Web.HttpContext) (Dynamicweb.AspNet.dll) in :0		 
13 ms
 
539 ms
10:45:39 AM.120 ExecuteScalar - took: 24.967 ms.
USE [CB21LIVEDB]
DECLARE @p0 NVARCHAR(3) = N'158', @p1 INT = 953
select count(OrderAutoID) FROM EcomOrders inner join EcomOrderLines on EcomOrders.OrderID = EcomOrderLines.OrderLineOrderID where ecomorderlines.OrderLineDiscountID = @p0 and OrderComplete = 1 and EcomOrders.OrderCustomerAccessUserID = @p1		 
37 ms
 
576 ms
10:45:40 AM.165 CreateDataReader - took: 1 ms.
USE [CB21LIVEDB]
DECLARE @p0 NVARCHAR(2) = N'OL'
SELECT * FROM EcomNumbers WHERE NumberType = @p0
System.Data.IDataReader CreateDataReader(System.Data.IDbCommand, System.Data.CommandBehavior) (Dynamicweb.Data.dll) in :0
System.Data.IDataReader CreateDataReader(Dynamicweb.Data.CommandBuilder, System.Data.IDbConnection, System.Data.IDbTransaction, System.Data.CommandBehavior, Int32) (Dynamicweb.Data.dll) in :0
System.Data.IDataReader CreateDataReader(Dynamicweb.Data.CommandBuilder, System.Data.IDbConnection, System.Data.IDbTransaction, Int32) (Dynamicweb.Data.dll) in :0
Void LoadFromType(System.String) (Dynamicweb.Ecommerce.dll) in :0
System.String GetNumber(System.String) (Dynamicweb.Ecommerce.dll) in :0
Void Save(System.String, System.Collections.Generic.IEnumerable`1[Dynamicweb.Ecommerce.Orders.OrderLine]) (Dynamicweb.Ecommerce.dll) in :0
Void Save(Dynamicweb.Ecommerce.Orders.Order, Boolean) (Dynamicweb.Ecommerce.dll) in :0
Void SaveCart(Dynamicweb.Ecommerce.Orders.Order, Dynamicweb.Security.UserManagement.User, Dynamicweb.Ecommerce.Orders.OrderContext) (Dynamicweb.Ecommerce.dll) in :0
Void CalculateDiscounts(Dynamicweb.Ecommerce.Orders.Order) (Dynamicweb.Ecommerce.dll) in :0
Void HandleDiscountAndTaxes(Dynamicweb.Ecommerce.Orders.Order, Boolean) (Dynamicweb.Ecommerce.dll) in :0
Void OnNotify(System.String, Dynamicweb.Extensibility.Notifications.NotificationArgs) (Dynamicweb.Ecommerce.dll) in :0
Void Notify(System.String, Dynamicweb.Extensibility.Notifications.NotificationArgs) (Dynamicweb.Extensibility.dll) in :0
System.String Output() (Dynamicweb.dll) in :0
Void ProcessRequest(System.Web.HttpContext) (Dynamicweb.AspNet.dll) in :0		 
1,045 ms
 
1,621 ms
10:45:40 AM.167 ExecuteScalar - took: 0 ms.
USE [CB21LIVEDB]
DECLARE @p0 NVARCHAR(9) = N'OL1390287'
SELECT CASE WHEN EXISTS (SELECT TOP 1 NULL FROM [EcomOrderLines] WHERE OrderLineID = @p0) THEN 0 ELSE 1 END		 
2 ms
 
1,623 ms
10:45:40 AM.182 CartViewModel.CreateInstance START 
15 ms
 
1,638 ms
10:45:40 AM.184 CreateDataReader - took: 1 ms.
USE [CB21LIVEDB]
DECLARE @p0 NVARCHAR(12) = N'100282641WHT', @p1 NVARCHAR(12) = N'100314283OWT', @p2 INT = 0
SELECT * FROM EcomDetails WITH (NOLOCK) WHERE DetailProductID IN (@p0,@p1) AND DetailType = @p2 ORDER BY DetailLanguageID, DetailsGroupId, DetailSortOrder
System.Data.IDataReader CreateDataReader(System.Data.IDbCommand, System.Data.CommandBehavior) (Dynamicweb.Data.dll) in :0
System.Data.IDataReader CreateDataReader(Dynamicweb.Data.CommandBuilder, System.Data.IDbConnection, System.Data.IDbTransaction, System.Data.CommandBehavior, Int32) (Dynamicweb.Data.dll) in :0
System.Data.IDataReader CreateDataReader(Dynamicweb.Data.CommandBuilder, System.Data.IDbConnection, System.Data.IDbTransaction, Int32) (Dynamicweb.Data.dll) in :0
System.Collections.Generic.IEnumerable`1[Dynamicweb.Ecommerce.Products.InheritedDetail] GetInheritedDetailsBulk(System.Collections.Generic.List`1[System.String], System.String) (Dynamicweb.Ecommerce.dll) in :0
System.Collections.Generic.Dictionary`2[System.String,System.Collections.Generic.List`1[Dynamicweb.Ecommerce.Products.Detail]] GetDetailsBulk(System.Collections.Generic.IEnumerable`1[Dynamicweb.Ecommerce.Products.ProductKey], System.String, Boolean) (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Frontend.CartViewModel CreateCartViewModel(Dynamicweb.Ecommerce.Orders.Order, System.Nullable`1[System.Int32]) (Dynamicweb.Ecommerce.dll) in :0
Dynamicweb.Frontend.CartViewModel CreateInstance(Dynamicweb.Ecommerce.Orders.Order, System.Nullable`1[System.Int32]) (Dynamicweb.Ecommerce.dll) in :0
Void OnNotify(System.String, Dynamicweb.Extensibility.Notifications.NotificationArgs) (Dynamicweb.Ecommerce.dll) in :0
Void Notify(System.String, Dynamicweb.Extensibility.Notifications.NotificationArgs) (Dynamicweb.Extensibility.dll) in :0
System.String Output() (Dynamicweb.dll) in :0
Void ProcessRequest(System.Web.HttpContext) (Dynamicweb.AspNet.dll) in :0		 
2 ms
 
1,640 ms
10:45:40 AM.186 CartViewModel.CreateInstance END 
2 ms
 
1,642 ms
10:45:40 AM.186 After Page.OnOutput notification 
0 ms
 
1,642 ms
10:45:40 AM.186 Starting template.output (E:\LiveWeb\Custom\Files\Templates\Designs\Kids21\_parsed\ContentPage.parsed.cshtml) 
0 ms
 
1,642 ms
10:45:40 AM.211 After provider (Dynamicweb.Ecommerce.Frontend.NavigationProviders.GroupNavigationProvider) 
25 ms
 
1,667 ms
10:45:40 AM.248 After Run (E:\LiveWeb\Custom\Files\Templates\Designs\Kids21\_parsed\ContentPage.parsed.cshtml) 
37 ms
 
1,704 ms
10:45:40 AM.248 Ending Template.Output (E:\LiveWeb\Custom\Files\Templates\Designs\Kids21\_parsed\ContentPage.parsed.cshtml) - took: 65.0078 ms. 
0 ms
 
1,704 ms
10:45:40 AM.248 After template output 
0 ms
 
1,704 ms
10:45:40 AM.248 After navigation tags 
0 ms
 
1,704 ms
10:45:40 AM.249 After global paragraphs 
1 ms
 
1,705 ms
10:45:40 AM.249 After cdn replace 
0 ms
 
1,705 ms
10:45:40 AM.249 After snippets 
0 ms
 
1,705 ms
10:45:40 AM.249 After globalTemplate start 
0 ms
 
1,705 ms
10:45:40 AM.249 After Page.AfterOutput notification 
0 ms
 
1,705 ms
10:45:40 AM.249 Starting template.output (MEM) 
0 ms
 
1,705 ms
10:45:40 AM.250 Ending Template.Output (MEM) - took: 0 ms. 
1 ms
 
1,706 ms
10:45:40 AM.250 After globalTemplate.Output 
0 ms
 
1,706 ms
10:45:40 AM.250 Start URL Replace 
0 ms
 
1,706 ms
10:45:40 AM.250 window.open replace... 
0 ms
 
1,706 ms
10:45:40 AM.254 End URL Replace 
4 ms
 
1,710 ms
10:45:40 AM.255 Starting template.output (MEM) 
1 ms
 
1,711 ms
10:45:40 AM.255 Ending Template.Output (MEM) - took: 0 ms. 
0 ms
 
1,711 ms
10:45:40 AM.255 After Page.AfterRender notification 
0 ms
 
1,711 ms
10:45:40 AM.255 End Execution 
0 ms
 
1,711 ms
 
Nicolai Pedersen Dynamicweb Employee
Nicolai Pedersen
Posted on 07/10/2022 10:08:30
Reply

can you send me the URL? I find it very odd that this table that has less than 50 records is that slow...

 
Nicolai Pedersen Dynamicweb Employee
Nicolai Pedersen
Posted on 07/10/2022 11:24:06
Reply
This post has been marked as an answer

Thank you for the URL

I have looked at the solution and it is not the ecomnumbers table that is slow - you can see it is only 1ms if you look at the text.

But it is the step before and it is related to discount calculations - seems like  MemberDiscountsProvider in your code is applied and I would look into that and see if that is the cause - also you have some realtively expensive discounts wiht large lists of excluded products. Could also be the cause.

Votes for this answer: 1
 
Shiwanka Chathuranga Dynamicweb Employee
Shiwanka Chathuranga
Posted on 07/10/2022 12:00:07
Reply

Thanks Nicolai

i will check that

 

You must be logged in to post in the forum