RenderMvc/Store (20788.2 ms)  on Mon, 01 Aug 2016 07:05:07 GMT
duration (ms)	from start (ms)	query time (ms)
  [DatabaseServerMessenger] Syncing from databa...	292.4	+0.4	2 sql	98.4
  RazorView.Render: ~/Views/Store.cshtml	449.0	+295.0	3 sql	148.1
    RazorView.Render: ~/App_Plugins/Merchello/Vie...	4.2	+743.9
   RazorView.Render: ~/Views/Shared/_Header.csht...	20039.2	+748.4	! 136 sql	6770.2
show time with children	33.8 % in sql
client event	duration (ms)	from start (ms)
Response	1.0	+20791.0
Dom Content Loaded Event	23.0	+21002.0
Dom Complete		+21197.0
share show trivial
step
time from start
query type
duration	call stack
query
98.40 ms
[DatabaseServerMessenger] Syncing from database... — 98.00 ms
[DatabaseServerMessenger] Syncing from database...
T+98.4 ms
Reader
48.9 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Fetch ProcessDatabaseInstructions Sync UmbracoModule_RouteAttempt OnRouteAttempt ProcessRequest <Init>b__8
DECLARE @0 int = 34;

SELECT *
FROM [umbracoCacheInstruction]
WHERE (([umbracoCacheInstruction].[id] > @0))
ORDER BY ([umbracoCacheInstruction].[id])
96.00 ms
[DatabaseServerMessenger] Syncing from database... — 96.00 ms
[DatabaseServerMessenger] Syncing from database...
T+243.3 ms
NonQuery
49.5 ms
<ExecuteNonQueryWithRetry>b__0 ExecuteAction ExecuteNonQueryWithRetry ExecuteNonQueryWithRetry ExecuteNonQueryWithRetry Execute Execute PruneOldInstructions Sync UmbracoModule_RouteAttempt OnRouteAttempt ProcessRequest <Init>b__8
DECLARE @0 datetime = '2016-07-30T07:05:07';

DELETE FROM [umbracoCacheInstruction] WHERE [id] IN (SELECT [id] FROM (SELECT cacheIns.id
FROM umbracoCacheInstruction cacheIns
INNER JOIN (SELECT MAX(id) id FROM umbracoCacheInstruction) tMax
ON cacheIns.id <> tMax.id
WHERE (cacheIns.utcStamp < @0)) x)
99.20 ms
RazorView.Render: ~/Views/Store.cshtml — 97.00 ms
RazorView.Render: ~/Views/Store.cshtml
T+392.0 ms
Scalar
48.7 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue get_FeaturedProducts Execute ExecutePageHierarchy ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
99.30 ms
RazorView.Render: ~/Views/Store.cshtml — 99.30 ms
RazorView.Render: ~/Views/Store.cshtml
T+540.0 ms
Scalar
49.3 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue get_FeaturedProducts Execute ExecutePageHierarchy ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'3ffb92db-3259-4df8-a4d9-d7568a304fad';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

96.20 ms
RazorView.Render: ~/Views/Store.cshtml — 96.20 ms
RazorView.Render: ~/Views/Store.cshtml
T+685.5 ms
Reader
50.1 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue get_FeaturedProducts Execute ExecutePageHierarchy ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'3ffb92db-3259-4df8-a4d9-d7568a304fad',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
111.40 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 98.60 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+847.0 ms
Reader
49.2 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Fetch PerformGetByQuery GetByQuery GetChildren GetChildren Children Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'0d5c0969-1de8-4d3e-ab32-cf9d86d93d98';

SELECT *
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[parentKey] = @0)
98.30 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 98.30 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+994.5 ms
DUPLICATE Scalar
48.9 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
97.70 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.70 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+1141.1 ms
DUPLICATE Scalar
49.9 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'be945061-3696-48a9-8d39-c9c74e0c9053';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

97.10 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.10 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+1288.1 ms
DUPLICATE Reader
50.6 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'be945061-3696-48a9-8d39-c9c74e0c9053',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
97.40 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.40 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+1436.1 ms
DUPLICATE Scalar
49.6 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
97.90 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.90 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+1583.6 ms
DUPLICATE Scalar
53.8 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'acdc1019-50c9-4df8-9f02-3bb34729cf62';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

96.20 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 96.20 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+1733.6 ms
DUPLICATE Reader
50.0 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'acdc1019-50c9-4df8-9f02-3bb34729cf62',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
99.60 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 99.60 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+1883.2 ms
DUPLICATE Scalar
49.2 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
97.70 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.70 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+2030.1 ms
DUPLICATE Scalar
49.4 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'be945061-3696-48a9-8d39-c9c74e0c9053';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

98.70 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 98.70 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+2178.2 ms
DUPLICATE Reader
50.6 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'be945061-3696-48a9-8d39-c9c74e0c9053',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
101.00 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 101.00 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+2329.8 ms
DUPLICATE Scalar
49.3 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
100.10 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 100.10 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+2479.2 ms
DUPLICATE Scalar
49.7 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'acdc1019-50c9-4df8-9f02-3bb34729cf62';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

96.40 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 96.40 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+2625.3 ms
DUPLICATE Reader
50.2 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'acdc1019-50c9-4df8-9f02-3bb34729cf62',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
98.30 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 98.30 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+2773.8 ms
DUPLICATE Scalar
49.4 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
99.10 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 99.10 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+2922.3 ms
DUPLICATE Scalar
49.7 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'0b7f8cf6-0ffa-43c1-9877-68c28ed848af';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

97.50 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.50 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+3069.5 ms
DUPLICATE Reader
50.7 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'0b7f8cf6-0ffa-43c1-9877-68c28ed848af',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
98.80 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 98.80 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+3219.0 ms
DUPLICATE Scalar
48.9 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
97.70 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.70 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+3365.6 ms
DUPLICATE Scalar
49.6 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'be945061-3696-48a9-8d39-c9c74e0c9053';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

96.40 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 96.40 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+3511.6 ms
DUPLICATE Reader
50.1 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'be945061-3696-48a9-8d39-c9c74e0c9053',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
98.00 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 98.00 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+3659.7 ms
DUPLICATE Scalar
48.8 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
98.10 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 98.10 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+3806.6 ms
DUPLICATE Scalar
49.4 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'acdc1019-50c9-4df8-9f02-3bb34729cf62';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

96.10 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 96.10 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+3952.1 ms
DUPLICATE Reader
50.4 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'acdc1019-50c9-4df8-9f02-3bb34729cf62',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
97.80 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.80 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+4100.3 ms
DUPLICATE Scalar
50.8 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
98.00 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 98.00 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+4249.1 ms
DUPLICATE Scalar
49.3 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'0b7f8cf6-0ffa-43c1-9877-68c28ed848af';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

96.90 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 96.90 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+4395.3 ms
DUPLICATE Reader
50.4 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'0b7f8cf6-0ffa-43c1-9877-68c28ed848af',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
97.40 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.40 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+4543.1 ms
DUPLICATE Scalar
48.8 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
97.80 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.80 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+4689.7 ms
DUPLICATE Scalar
49.3 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'88cca002-23c7-48d2-8365-cf8adc4f1a97';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

96.40 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 96.40 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+4835.4 ms
DUPLICATE Reader
50.6 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'88cca002-23c7-48d2-8365-cf8adc4f1a97',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
99.30 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 99.30 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+4985.3 ms
DUPLICATE Scalar
49.2 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
97.70 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.70 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+5132.2 ms
DUPLICATE Scalar
55.8 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'be945061-3696-48a9-8d39-c9c74e0c9053';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

96.20 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 96.20 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+5284.2 ms
DUPLICATE Reader
50.1 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'be945061-3696-48a9-8d39-c9c74e0c9053',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
98.80 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 98.80 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+5433.1 ms
DUPLICATE Scalar
51.7 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
97.80 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.80 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+5582.6 ms
DUPLICATE Scalar
49.8 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'be945061-3696-48a9-8d39-c9c74e0c9053';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

96.70 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 96.70 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+5729.1 ms
DUPLICATE Reader
50.0 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'be945061-3696-48a9-8d39-c9c74e0c9053',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
97.50 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.50 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+5876.6 ms
DUPLICATE Scalar
49.2 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
97.80 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.80 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+6023.6 ms
DUPLICATE Scalar
51.3 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'acdc1019-50c9-4df8-9f02-3bb34729cf62';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

97.90 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.90 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+6172.8 ms
DUPLICATE Reader
51.8 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'acdc1019-50c9-4df8-9f02-3bb34729cf62',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
98.00 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 98.00 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+6322.6 ms
DUPLICATE Scalar
50.6 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
97.80 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.80 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+6471.0 ms
DUPLICATE Scalar
49.2 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'0b7f8cf6-0ffa-43c1-9877-68c28ed848af';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

96.70 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 96.70 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+6616.9 ms
DUPLICATE Reader
50.2 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'0b7f8cf6-0ffa-43c1-9877-68c28ed848af',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
97.70 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.70 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+6764.8 ms
DUPLICATE Scalar
48.9 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
97.80 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.80 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+6911.5 ms
DUPLICATE Scalar
49.4 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'88cca002-23c7-48d2-8365-cf8adc4f1a97';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

96.20 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 96.20 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+7057.1 ms
DUPLICATE Reader
49.9 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'88cca002-23c7-48d2-8365-cf8adc4f1a97',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
98.30 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 98.30 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+7205.3 ms
DUPLICATE Scalar
49.3 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
97.50 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.50 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+7352.1 ms
DUPLICATE Scalar
49.6 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'85c0bf49-5043-4c73-b6dd-7be0106c1a55';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

97.20 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.20 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+7498.9 ms
DUPLICATE Reader
50.1 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'85c0bf49-5043-4c73-b6dd-7be0106c1a55',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
99.10 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 99.10 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+7648.1 ms
DUPLICATE Scalar
51.5 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
101.10 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 101.10 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+7800.7 ms
DUPLICATE Scalar
49.8 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'be945061-3696-48a9-8d39-c9c74e0c9053';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

96.00 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 96.00 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+7946.5 ms
DUPLICATE Reader
49.7 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'be945061-3696-48a9-8d39-c9c74e0c9053',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
97.40 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.40 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+8093.6 ms
DUPLICATE Scalar
48.8 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
98.10 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 98.10 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+8240.5 ms
DUPLICATE Scalar
49.5 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'acdc1019-50c9-4df8-9f02-3bb34729cf62';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

98.60 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 98.60 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+8388.6 ms
DUPLICATE Reader
50.5 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'acdc1019-50c9-4df8-9f02-3bb34729cf62',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
97.50 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.50 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+8536.6 ms
DUPLICATE Scalar
49.1 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
97.90 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.90 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+8683.6 ms
DUPLICATE Scalar
50.0 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'0b7f8cf6-0ffa-43c1-9877-68c28ed848af';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

96.90 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 96.90 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+8830.5 ms
DUPLICATE Reader
49.5 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'0b7f8cf6-0ffa-43c1-9877-68c28ed848af',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
96.90 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 96.90 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+8976.9 ms
DUPLICATE Scalar
48.9 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
97.70 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.70 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+9123.5 ms
DUPLICATE Scalar
49.4 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'88cca002-23c7-48d2-8365-cf8adc4f1a97';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

96.30 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 96.30 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+9269.2 ms
DUPLICATE Reader
50.0 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'88cca002-23c7-48d2-8365-cf8adc4f1a97',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
97.30 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.30 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+9416.5 ms
DUPLICATE Scalar
48.9 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
97.60 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.60 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+9563.0 ms
DUPLICATE Scalar
49.3 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'85c0bf49-5043-4c73-b6dd-7be0106c1a55';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

96.30 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 96.30 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+9708.6 ms
DUPLICATE Reader
49.5 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'85c0bf49-5043-4c73-b6dd-7be0106c1a55',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
98.00 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 98.00 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+9856.1 ms
DUPLICATE Scalar
48.9 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
97.60 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.60 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+10002.6 ms
DUPLICATE Scalar
49.4 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'69d7528f-b478-4237-80bc-637d47dc2476';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

96.20 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 96.20 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+10148.2 ms
DUPLICATE Reader
49.9 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'69d7528f-b478-4237-80bc-637d47dc2476',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
98.60 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 98.60 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+10296.7 ms
DUPLICATE Scalar
49.3 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
97.70 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.70 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+10443.7 ms
DUPLICATE Scalar
49.8 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'be945061-3696-48a9-8d39-c9c74e0c9053';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

96.30 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 96.30 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+10589.8 ms
DUPLICATE Reader
50.5 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'be945061-3696-48a9-8d39-c9c74e0c9053',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
97.50 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.50 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+10737.8 ms
DUPLICATE Scalar
49.6 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
97.90 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.90 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+10885.3 ms
DUPLICATE Scalar
49.9 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'acdc1019-50c9-4df8-9f02-3bb34729cf62';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

98.40 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 98.40 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+11033.6 ms
DUPLICATE Reader
49.7 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'acdc1019-50c9-4df8-9f02-3bb34729cf62',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
97.50 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.50 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+11180.8 ms
DUPLICATE Scalar
49.1 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
97.80 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.80 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+11327.7 ms
DUPLICATE Scalar
49.7 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'0b7f8cf6-0ffa-43c1-9877-68c28ed848af';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

96.30 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 96.30 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+11473.7 ms
DUPLICATE Reader
50.3 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'0b7f8cf6-0ffa-43c1-9877-68c28ed848af',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
97.20 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.20 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+11621.2 ms
DUPLICATE Scalar
48.8 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
97.60 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.60 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+11767.6 ms
DUPLICATE Scalar
49.3 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'88cca002-23c7-48d2-8365-cf8adc4f1a97';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

96.40 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 96.40 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+11913.3 ms
DUPLICATE Reader
50.0 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'88cca002-23c7-48d2-8365-cf8adc4f1a97',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
97.40 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.40 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+12060.7 ms
DUPLICATE Scalar
48.9 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
97.60 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.60 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+12207.2 ms
DUPLICATE Scalar
49.5 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'85c0bf49-5043-4c73-b6dd-7be0106c1a55';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

95.90 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 95.90 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+12352.6 ms
DUPLICATE Reader
49.6 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'85c0bf49-5043-4c73-b6dd-7be0106c1a55',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
97.00 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.00 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+12499.2 ms
DUPLICATE Scalar
48.8 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
97.70 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.70 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+12645.7 ms
DUPLICATE Scalar
49.3 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'69d7528f-b478-4237-80bc-637d47dc2476';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

95.70 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 95.70 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+12790.7 ms
DUPLICATE Reader
49.4 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'69d7528f-b478-4237-80bc-637d47dc2476',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
97.10 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.10 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+12937.2 ms
DUPLICATE Scalar
48.8 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
97.80 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.80 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+13083.8 ms
DUPLICATE Scalar
49.6 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'b35da97c-41d0-479b-99ea-994df59d675b';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

96.70 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 96.70 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+13230.1 ms
DUPLICATE Reader
50.6 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'b35da97c-41d0-479b-99ea-994df59d675b',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
98.60 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 98.60 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+13379.3 ms
DUPLICATE Scalar
49.2 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
97.80 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.80 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+13526.3 ms
DUPLICATE Scalar
49.7 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'be945061-3696-48a9-8d39-c9c74e0c9053';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

96.40 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 96.40 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+13672.4 ms
DUPLICATE Reader
49.9 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'be945061-3696-48a9-8d39-c9c74e0c9053',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
97.60 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.60 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+13819.9 ms
DUPLICATE Scalar
50.9 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
98.60 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 98.60 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+13969.4 ms
DUPLICATE Scalar
49.8 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'acdc1019-50c9-4df8-9f02-3bb34729cf62';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

96.60 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 96.60 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+14115.8 ms
DUPLICATE Reader
52.2 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'acdc1019-50c9-4df8-9f02-3bb34729cf62',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
97.40 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.40 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+14265.4 ms
DUPLICATE Scalar
49.1 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
97.70 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.70 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+14412.2 ms
DUPLICATE Scalar
49.4 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'0b7f8cf6-0ffa-43c1-9877-68c28ed848af';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

96.30 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 96.30 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+14557.9 ms
DUPLICATE Reader
50.4 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'0b7f8cf6-0ffa-43c1-9877-68c28ed848af',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
97.70 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.70 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+14706.0 ms
DUPLICATE Scalar
49.2 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
97.80 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.80 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+14853.0 ms
DUPLICATE Scalar
51.1 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'88cca002-23c7-48d2-8365-cf8adc4f1a97';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

96.30 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 96.30 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+15000.4 ms
DUPLICATE Reader
49.9 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'88cca002-23c7-48d2-8365-cf8adc4f1a97',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
97.50 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.50 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+15147.8 ms
DUPLICATE Scalar
49.1 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
97.80 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.80 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+15294.7 ms
DUPLICATE Scalar
49.7 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'85c0bf49-5043-4c73-b6dd-7be0106c1a55';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

96.10 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 96.10 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+15440.5 ms
DUPLICATE Reader
50.1 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'85c0bf49-5043-4c73-b6dd-7be0106c1a55',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
97.50 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.50 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+15588.1 ms
DUPLICATE Scalar
48.7 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
97.20 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.20 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+15734.0 ms
DUPLICATE Scalar
49.3 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'69d7528f-b478-4237-80bc-637d47dc2476';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

96.30 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 96.30 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+15879.6 ms
DUPLICATE Reader
49.9 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'69d7528f-b478-4237-80bc-637d47dc2476',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
97.10 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.10 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+16026.6 ms
DUPLICATE Scalar
48.8 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
97.70 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.70 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+16173.1 ms
DUPLICATE Scalar
49.3 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'b35da97c-41d0-479b-99ea-994df59d675b';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

96.30 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 96.30 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+16318.7 ms
DUPLICATE Reader
50.0 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'b35da97c-41d0-479b-99ea-994df59d675b',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
97.40 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.40 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+16466.1 ms
DUPLICATE Scalar
48.6 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
97.90 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.90 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+16612.6 ms
DUPLICATE Scalar
49.9 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'4342485f-b584-43c0-b9f3-d7adf9d5d216';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

96.30 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 96.30 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+16758.8 ms
DUPLICATE Reader
50.4 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'4342485f-b584-43c0-b9f3-d7adf9d5d216',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
98.50 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 98.50 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+16907.7 ms
DUPLICATE Scalar
49.3 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
98.20 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 98.20 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+17055.2 ms
DUPLICATE Scalar
49.3 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'be945061-3696-48a9-8d39-c9c74e0c9053';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

97.70 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.70 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+17202.2 ms
DUPLICATE Reader
50.6 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'be945061-3696-48a9-8d39-c9c74e0c9053',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
97.30 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.30 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+17350.1 ms
DUPLICATE Scalar
49.0 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
102.20 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 102.20 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+17501.3 ms
DUPLICATE Scalar
49.8 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'acdc1019-50c9-4df8-9f02-3bb34729cf62';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

96.30 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 96.30 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+17647.4 ms
DUPLICATE Reader
50.2 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'acdc1019-50c9-4df8-9f02-3bb34729cf62',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
97.80 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.80 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+17795.4 ms
DUPLICATE Scalar
49.0 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
97.70 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.70 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+17942.1 ms
DUPLICATE Scalar
49.3 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'0b7f8cf6-0ffa-43c1-9877-68c28ed848af';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

96.40 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 96.40 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+18087.8 ms
DUPLICATE Reader
49.9 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'0b7f8cf6-0ffa-43c1-9877-68c28ed848af',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
97.50 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.50 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+18235.2 ms
DUPLICATE Scalar
49.1 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
97.90 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.90 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+18382.2 ms
DUPLICATE Scalar
49.4 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'88cca002-23c7-48d2-8365-cf8adc4f1a97';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

96.10 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 96.10 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+18527.7 ms
DUPLICATE Reader
49.9 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'88cca002-23c7-48d2-8365-cf8adc4f1a97',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
97.10 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.10 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+18674.7 ms
DUPLICATE Scalar
48.6 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
98.00 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 98.00 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+18821.3 ms
DUPLICATE Scalar
49.8 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'85c0bf49-5043-4c73-b6dd-7be0106c1a55';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

96.10 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 96.10 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+18967.2 ms
DUPLICATE Reader
49.6 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'85c0bf49-5043-4c73-b6dd-7be0106c1a55',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
97.40 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.40 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+19114.2 ms
DUPLICATE Scalar
48.7 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
97.20 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.20 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+19260.1 ms
DUPLICATE Scalar
49.4 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'69d7528f-b478-4237-80bc-637d47dc2476';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

96.50 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 96.50 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+19406.0 ms
DUPLICATE Reader
49.8 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'69d7528f-b478-4237-80bc-637d47dc2476',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
97.90 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.90 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+19553.7 ms
DUPLICATE Scalar
48.9 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
97.30 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.30 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+19699.9 ms
DUPLICATE Scalar
50.4 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'b35da97c-41d0-479b-99ea-994df59d675b';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

96.50 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 96.50 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+19846.8 ms
DUPLICATE Reader
50.6 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'b35da97c-41d0-479b-99ea-994df59d675b',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
97.50 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.50 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+19994.9 ms
DUPLICATE Scalar
49.1 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
100.80 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 100.80 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+20144.8 ms
DUPLICATE Scalar
51.3 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'4342485f-b584-43c0-b9f3-d7adf9d5d216';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

96.40 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 96.40 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+20292.5 ms
DUPLICATE Reader
50.2 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'4342485f-b584-43c0-b9f3-d7adf9d5d216',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
97.20 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.20 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+20439.9 ms
DUPLICATE Scalar
49.2 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar ExecuteScalar PerformCount GetAll GetAll Initialize EnsureInitialized GetProviderForCollection GetProviderForCollection GetEntityCollectionProvider GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'00000000-0000-0000-0000-000000000000';

SELECT COUNT(*)
FROM [merchEntityCollection]
WHERE ([merchEntityCollection].[pk] <> @0)
101.20 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 101.20 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+20590.3 ms
DUPLICATE Scalar
49.7 ms
<ExecuteScalarWithRetry>b__9 ExecuteAction ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalarWithRetry ExecuteScalar Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'1d009d45-1172-4ee9-b2e7-3ed1945a7976';

SELECT COUNT(*) FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1

97.10 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml — 97.10 ms
RazorView.Render: ~/Views/Shared/_Header.cshtml
T+20737.1 ms
DUPLICATE Reader
49.7 ms
<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch Page GetDtoPage GetPagedKeys GetKeysFromCollection GetKeysFromCollection PerformGetPagedEntityKeys GetFromCollection TypedProductContentFromCollection TypedProductContentFromCollection ConvertDataToSource <.ctor>b__0 CreateValue LazyInitValue get_Value <.ctor>b__1 CreateValue LazyInitValue get_Value get_Value GetValue GetPropertyValue GetPropertyValue <GetCategoryPageForCollection>b__0 FirstChild GetCategoryPageForCollection <CategoryLink>b__0 WriteTo Write Execute ExecutePageHierarchy ExecutePageHierarchy Render Execute ExecutePageHierarchy ExecutePageHierarchy <RenderPageCore>b__2 WriteTo Write RenderSurrounding PopContext ExecutePageHierarchy Render
DECLARE @0 nvarchar(40) = N'1d009d45-1172-4ee9-b2e7-3ed1945a7976',
        @1 bigint = 0,
        @2 bigint = 9223372036854775807;

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY name ASC) peta_rn, *
FROM [merchProductVariant]
WHERE [merchProductVariant].[productKey] IN (
SELECT DISTINCT([productKey])
FROM [merchProduct2EntityCollection]
WHERE [merchProduct2EntityCollection].[entityCollectionKey] = @0
)
AND [merchProductVariant].[master] = 1
) peta_paged WHERE peta_rn>@1 AND peta_rn<=@2
show trivial gaps