|
12.20 ms
|
https://sessionfixture.sigmasolve.com/shop-all-commercial-sinks-2500?specs=3125%2C3480%2C3507%2C3871 — 11.40 ms
|
|
sql - Open
Controller: Catalog.Category
0.2 ms (T+12.2 ms)
|
NonQueryQuery > ExecuteNonQuery > SetCommand > SetQuery > GetParameters > AddParameter > get_Command > CreateCommand > EnsureConnection
Connection Open()
|
|
0.60 ms
|
Controller: Catalog.Category — 0.60 ms
|
|
sql - NonQuery
Controller: Catalog.Category
14.1 ms (T+13.0 ms)
|
OnActionExecuting > UpdateCustomer > Update > UpdateEntity > Query > <SetNonQueryQuery>b__0 > NonQueryQuery > ExecuteNonQuery
UPDATE
[t1]
SET
[t1].[ShippingAddress_Id] = null,
[t1].[BillingAddress_Id] = null,
[t1].[RegisteredInStoreId] = 0,
[t1].[LastActivityDateUtc] = 2025-04-17T07:48:55,
[t1].[LastLoginDateUtc] = null,
[t1].[CreatedOnUtc] = 2025-04-17T07:48:55,
[t1].[LastIpAddress] = '3.15.175.233',
[t1].[SystemName] = '',
[t1].[IsSystemAccount] = 0,
[t1].[Deleted] = 0,
[t1].[Active] = 1,
[t1].[CannotLoginUntilDateUtc] = null,
[t1].[FailedLoginAttempts] = 0,
[t1].[RequireReLogin] = 0,
[t1].[HasShoppingCartItems] = 0,
[t1].[VendorId] = 0,
[t1].[AffiliateId] = 0,
[t1].[IsTaxExempt] = 0,
[t1].[AdminComment] = '',
[t1].[EmailToRevalidate] = '',
[t1].[Email] = '',
[t1].[Username] = '',
[t1].[CustomerGuid] = ed4cda26-5dda-4078-a4dd-ce38b8a60d70
FROM
[Customer] [t1]
WHERE
[t1].[Id] = 11194796
|
|
0.10 ms
|
Controller: Catalog.Category — 0.10 ms
|
|
sql - Close
Controller: Catalog.Category
0.1 ms (T+27.2 ms)
|
InvokeNextActionFilterAsync > Next > InvokeNextActionFilterAsync > Next > OnActionExecuting > UpdateCustomer > Update > UpdateEntity > Close
Connection Close()
|
|
0.30 ms
|
Controller: Catalog.Category — 0.30 ms
|
|
sql - Open
Controller: Catalog.Category
0.1 ms (T+27.6 ms)
|
ExecuteScalar > SetCommand > SetCommand > SetQuery > GetParameters > AddParameter > get_Command > CreateCommand > EnsureConnection
Connection Open()
|
|
0.20 ms
|
Controller: Catalog.Category — 0.20 ms
|
|
sql - Scalar
Controller: Catalog.Category
12.2 ms (T+27.9 ms)
|
OnActionExecuting > SaveAttribute > InsertAttribute > Insert > InsertEntity > InsertWithInt32Identity > Query > ScalarQuery > ExecuteScalar
INSERT INTO [GenericAttribute]
(
[CreatedOrUpdatedDateUTC],
[StoreId],
[Value],
[Key],
[KeyGroup],
[EntityId]
)
VALUES
(
2025-04-17T07:48:55,
0,
'https://sessionfixture.sigmasolve.com/shop-all-commercial-sinks-2500?specs=3125%2C3480%2C3507%2C3871',
'LastVisitedPage',
'Customer',
11194796
)
SELECT SCOPE_IDENTITY()
|
|
0.10 ms
|
Controller: Catalog.Category — 0.10 ms
|
|
sql - Close
Controller: Catalog.Category
0.1 ms (T+40.2 ms)
|
InvokeNextActionFilterAsync > Next > OnActionExecuting > SaveAttribute > InsertAttribute > Insert > InsertEntity > Close
Connection Close()
|
|
36.00 ms
|
Controller: Catalog.Category — 36.00 ms
|
|
sql - Open
Controller: Catalog.Category
0.2 ms (T+76.3 ms)
|
ExecuteScalar > SetCommand > SetCommand > SetQuery > GetParameters > AddParameter > get_Command > CreateCommand > EnsureConnection
Connection Open()
|
|
0.30 ms
|
Controller: Catalog.Category — 0.30 ms
|
|
sql - Scalar
Controller: Catalog.Category
17.9 ms (T+76.8 ms)
|
Category > SaveAttribute > InsertAttribute > Insert > InsertEntity > InsertWithInt32Identity > Query > ScalarQuery > ExecuteScalar
INSERT INTO [GenericAttribute]
(
[CreatedOrUpdatedDateUTC],
[StoreId],
[Value],
[Key],
[KeyGroup],
[EntityId]
)
VALUES
(
2025-04-17T07:48:55,
1,
'https://sessionfixture.sigmasolve.com/shop-all-commercial-sinks-2500',
'LastContinueShoppingPage',
'Customer',
11194796
)
SELECT SCOPE_IDENTITY()
|
|
0.10 ms
|
Controller: Catalog.Category — 0.10 ms
|
|
sql - Close
Controller: Catalog.Category
0.1 ms (T+94.8 ms)
|
InvokeNextActionFilterAsync > Next > InvokeActionMethodAsync > Execute > Category > SaveAttribute > InsertAttribute > Insert > InsertEntity > Close
Connection Close()
|
|
20.60 ms
|
Controller: Catalog.Category — 20.60 ms
|
|
sql - Open
Controller: Catalog.Category
0.2 ms (T+115.5 ms)
|
SearchProducts > EntityFromSql > QueryProc > Query > InitCommand > InitCommand > get_Command > CreateCommand > EnsureConnection
Connection Open()
|
|
0.30 ms
|
Controller: Catalog.Category — 0.30 ms
|
|
sql - Reader
Controller: Catalog.Category
13.9 ms (T+116.0 ms)
First Result: 13.9 ms
|
<Get>b__0 > <PrepareCategoryModel>b__12 > SearchProducts > SearchProducts > EntityFromSql > QueryProc > Query > ExecuteReader
ProductLoadAllPaged
|
|
0.10 ms
|
Controller: Catalog.Category — 0.10 ms
|
|
sql - Close
Controller: Catalog.Category
0.2 ms (T+130.0 ms)
|
GetOrCreate > <Get>b__0 > <PrepareCategoryModel>b__12 > SearchProducts > SearchProducts > EntityFromSql > QueryProc > Close
Connection Close()
|
|
0.30 ms
|
Controller: Catalog.Category — 0.30 ms
|
|
sql - Open
Controller: Catalog.Category
0.2 ms (T+130.5 ms)
|
SearchProducts > EntityFromSql > QueryProc > Query > InitCommand > InitCommand > get_Command > CreateCommand > EnsureConnection
Connection Open()
|
|
0.20 ms
|
Controller: Catalog.Category — 0.20 ms
|
|
sql - Reader !
Controller: Catalog.Category
353.7 ms (T+130.9 ms)
First Result: 353.7 ms
|
InvokeActionMethodAsync > Execute > Category > PrepareCategoryModel > SearchProducts > EntityFromSql > QueryProc > Query > ExecuteReader
ProductLoadAllPaged
|
|
0.10 ms
|
Controller: Catalog.Category — 0.10 ms
|
|
sql - Close
Controller: Catalog.Category
0.2 ms (T+484.7 ms)
|
InvokeActionMethodAsync > Execute > Category > PrepareCategoryModel > SearchProducts > EntityFromSql > QueryProc > Close
Connection Close()
|
|
299.00 ms
|
https://sessionfixture.sigmasolve.com/shop-all-commercial-sinks-2500?specs=3125%2C3480%2C3507%2C3871 — 198.40 ms
|
