问实体框架核心多次执行

EN

var query = from p in _productRepository.Table
            join s in _suplierProductSpecsMapRepository.Table on p.Id equals s.ProductId into sp
            from z in sp.DefaultIfEmpty()
            join c in _brandRepository.Table on p.Brand.Id equals c.Id into br
            from b in br.DefaultIfEmpty()
            where (p.Gtin.Contains(Keyword) || p.Sku.Contains(Keyword) || z.SupplierSku.Contains(Keyword))
            select new { p.Gtin, p.Name, b.Name };
return query.Distinct().Take(10);

var products = _productService.GetProductsByKeyword(keyword);
var response = products.ToList();
return Json(products);

Microsoft.EntityFrameworkCore.Database.Command:Information: Executed DbCommand (846ms) [Parameters=[@__p_3='?', @__Keyword_0='?' (Size = 4000), @__Keyword_1='?' (Size = 4000), @__Keyword_2='?' (Size = 4000)], CommandType='Text', CommandTimeout='30']
SELECT DISTINCT TOP(@__p_3) [p].[Gtin], [p].[Name], [c].[Name]
FROM [Products] AS [p]
LEFT JOIN [SupplierSpecs] AS [s] ON [p].[Id] = [s].[ProductId]
LEFT JOIN [Brands] AS [c] ON [p].[BrandId] = [c].[Id]
WHERE (((CHARINDEX(@__Keyword_0, [p].[Gtin]) > 0) OR (@__Keyword_0 = N'')) OR ((CHARINDEX(@__Keyword_1, [p].[Sku]) > 0) OR (@__Keyword_1 = N''))) OR ((CHARINDEX(@__Keyword_2, [s].[SupplierSku]) > 0) OR (@__Keyword_2 = N''))
Application Insights Telemetry (unconfigured): {"name":"Microsoft.ApplicationInsights.Dev.Message","time":"2018-06-20T21:34:52.5602316Z","tags":{"ai.location.ip":"127.0.0.1","ai.operation.name":"POST Product/*****","ai.internal.nodeName":"***","ai.operation.id":"c690445c-4f21f9b370fd66f2","ai.application.ver":"1.0.0.0","ai.cloud.roleInstance":"***","ai.operation.parentId":"|c690445c-4f21f9b370fd66f2.","ai.internal.sdkVersion":"aspnet5c:2.1.1"},"data":{"baseType":"MessageData","baseData":{"ver":2,"message":"Executed DbCommand (846ms) [Parameters=[@__p_3='?', @__Keyword_0='?' (Size = 4000), @__Keyword_1='?' (Size = 4000), @__Keyword_2='?' (Size = 4000)], CommandType='Text', CommandTimeout='30']\r\nSELECT DISTINCT TOP(@__p_3) [p].[Gtin], [p].[Name], [c].[Name]\r\nFROM [Products] AS [p]\r\nLEFT JOIN [SupplierSpecs] AS [s] ON [p].[Id] = [s].[ProductId]\r\nLEFT JOIN [Brands] AS [c] ON [p].[BrandId] = [c].[Id]\r\nWHERE (((CHARINDEX(@__Keyword_0, [p].[Gtin]) > 0) OR (@__Keyword_0 = N'')) OR ((CHARINDEX(@__Keyword_1, [p].[Sku]) > 0) OR (@__Keyword_1 = N''))) OR ((CHARINDEX(@__Keyword_2, [s].[SupplierSku]) > 0) OR (@__Keyword_2 = N''))","severityLevel":"Information","properties":{"{OriginalFormat}":"Executed DbCommand ({elapsed}ms) [Parameters=[{parameters}], CommandType='{commandType}', CommandTimeout='{commandTimeout}']{newLine}{commandText}","parameters":"@__p_3='?', @__Keyword_0='?' (Size = 4000), @__Keyword_1='?' (Size = 4000), @__Keyword_2='?' (Size = 4000)","CategoryName":"Microsoft.EntityFrameworkCore.Database.Command","DeveloperMode":"true","commandText":"SELECT DISTINCT TOP(@__p_3) [p].[Gtin], [p].[Name], [c].[Name]\r\nFROM [Products] AS [p]\r\nLEFT JOIN [SupplierSpecs] AS [s] ON [p].[Id] = [s].[ProductId]\r\nLEFT JOIN [Brands] AS [c] ON [p].[BrandId] = [c].[Id]\r\nWHERE (((CHARINDEX(@__Keyword_0, [p].[Gtin]) > 0) OR (@__Keyword_0 = N'')) OR ((CHARINDEX(@__Keyword_1, [p].[Sku]) > 0) OR (@__Keyword_1 = N''))) OR ((CHARINDEX(@__Keyword_2, [s].[SupplierSku]) > 0) OR (@__Keyword_2 = N''))","AspNetCoreEnvironment":"Development","elapsed":"846","commandTimeout":"30","commandType":"Text"}}}}
Microsoft.EntityFrameworkCore.Database.Command:Information: Executed DbCommand (846ms) [Parameters=[@__p_3='?', @__Keyword_0='?' (Size = 4000), @__Keyword_1='?' (Size = 4000), @__Keyword_2='?' (Size = 4000)], CommandType='Text', CommandTimeout='30']
SELECT DISTINCT TOP(@__p_3) [p].[Gtin], [p].[Name], [c].[Name]
FROM [Products] AS [p]
LEFT JOIN [SupplierSpecs] AS [s] ON [p].[Id] = [s].[ProductId]
LEFT JOIN [Brands] AS [c] ON [p].[BrandId] = [c].[Id]
WHERE (((CHARINDEX(@__Keyword_0, [p].[Gtin]) > 0) OR (@__Keyword_0 = N'')) OR ((CHARINDEX(@__Keyword_1, [p].[Sku]) > 0) OR (@__Keyword_1 = N''))) OR ((CHARINDEX(@__Keyword_2, [s].[SupplierSku]) > 0) OR (@__Keyword_2 = N''))
Microsoft.EntityFrameworkCore.Database.Command Information: 20101 : Executed DbCommand (846ms) [Parameters=[@__p_3='?', @__Keyword_0='?' (Size = 4000), @__Keyword_1='?' (Size = 4000), @__Keyword_2='?' (Size = 4000)], CommandType='Text', CommandTimeout='30']
SELECT DISTINCT TOP(@__p_3) [p].[Gtin], [p].[Name], [c].[Name]
FROM [Products] AS [p]
LEFT JOIN [SupplierSpecs] AS [s] ON [p].[Id] = [s].[ProductId]
LEFT JOIN [Brands] AS [c] ON [p].[BrandId] = [c].[Id]
WHERE (((CHARINDEX(@__Keyword_0, [p].[Gtin]) > 0) OR (@__Keyword_0 = N'')) OR ((CHARINDEX(@__Keyword_1, [p].[Sku]) > 0) OR (@__Keyword_1 = N''))) OR ((CHARINDEX(@__Keyword_2, [s].[SupplierSku]) > 0) OR (@__Keyword_2 = N''))
Microsoft.AspNetCore.Mvc.Formatters.Json.Internal.JsonResultExecutor:Information: Executing JsonResult, writing value Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryable`1[<>f__AnonymousType44`3[System.String,System.String,System.String]].
Application Insights Telemetry (unconfigured): {"name":"Microsoft.ApplicationInsights.Dev.Message","time":"2018-06-20T21:34:52.5661523Z","tags":{"ai.location.ip":"127.0.0.1","ai.operation.name":"POST Product/*****","ai.internal.nodeName":"***","ai.operation.id":"c690445c-4f21f9b370fd66f2","ai.application.ver":"1.0.0.0","ai.cloud.roleInstance":"***","ai.operation.parentId":"|c690445c-4f21f9b370fd66f2.","ai.internal.sdkVersion":"aspnet5c:2.1.1"},"data":{"baseType":"MessageData","baseData":{"ver":2,"message":"Executing JsonResult, writing value Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryable`1[<>f__AnonymousType44`3[System.String,System.String,System.String]].","severityLevel":"Information","properties":{"{OriginalFormat}":"Executing JsonResult, writing value {Value}.","Value":"Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryable`1[<>f__AnonymousType44`3[System.String,System.String,System.String]]","CategoryName":"Microsoft.AspNetCore.Mvc.Formatters.Json.Internal.JsonResultExecutor","DeveloperMode":"true","AspNetCoreEnvironment":"Development"}}}}
Microsoft.AspNetCore.Mvc.Formatters.Json.Internal.JsonResultExecutor:Information: Executing JsonResult, writing value Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryable`1[<>f__AnonymousType44`3[System.String,System.String,System.String]].
Microsoft.AspNetCore.Mvc.Formatters.Json.Internal.JsonResultExecutor Information: 1 : Executing JsonResult, writing value Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryable`1[<>f__AnonymousType44`3[System.String,System.String,System.String]].
Microsoft.EntityFrameworkCore.Database.Command:Information: Executed DbCommand (856ms) [Parameters=[@__p_3='?', @__Keyword_0='?' (Size = 4000), @__Keyword_1='?' (Size = 4000), @__Keyword_2='?' (Size = 4000)], CommandType='Text', CommandTimeout='30']
SELECT DISTINCT TOP(@__p_3) [p].[Gtin], [p].[Name], [c].[Name]
FROM [Products] AS [p]
LEFT JOIN [SupplierSpecs] AS [s] ON [p].[Id] = [s].[ProductId]
LEFT JOIN [Brands] AS [c] ON [p].[BrandId] = [c].[Id]
WHERE (((CHARINDEX(@__Keyword_0, [p].[Gtin]) > 0) OR (@__Keyword_0 = N'')) OR ((CHARINDEX(@__Keyword_1, [p].[Sku]) > 0) OR (@__Keyword_1 = N''))) OR ((CHARINDEX(@__Keyword_2, [s].[SupplierSku]) > 0) OR (@__Keyword_2 = N''))
Application Insights Telemetry (unconfigured): {"name":"Microsoft.ApplicationInsights.Dev.Message","time":"2018-06-20T21:34:54.4290810Z","tags":{"ai.location.ip":"127.0.0.1","ai.operation.name":"POST Product/*****","ai.internal.nodeName":"***","ai.operation.id":"c690445c-4f21f9b370fd66f2","ai.application.ver":"1.0.0.0","ai.cloud.roleInstance":"***","ai.operation.parentId":"|c690445c-4f21f9b370fd66f2.","ai.internal.sdkVersion":"aspnet5c:2.1.1"},"data":{"baseType":"MessageData","baseData":{"ver":2,"message":"Executed DbCommand (856ms) [Parameters=[@__p_3='?', @__Keyword_0='?' (Size = 4000), @__Keyword_1='?' (Size = 4000), @__Keyword_2='?' (Size = 4000)], CommandType='Text', CommandTimeout='30']\r\nSELECT DISTINCT TOP(@__p_3) [p].[Gtin], [p].[Name], [c].[Name]\r\nFROM [Products] AS [p]\r\nLEFT JOIN [SupplierSpecs] AS [s] ON [p].[Id] = [s].[ProductId]\r\nLEFT JOIN [Brands] AS [c] ON [p].[BrandId] = [c].[Id]\r\nWHERE (((CHARINDEX(@__Keyword_0, [p].[Gtin]) > 0) OR (@__Keyword_0 = N'')) OR ((CHARINDEX(@__Keyword_1, [p].[Sku]) > 0) OR (@__Keyword_1 = N''))) OR ((CHARINDEX(@__Keyword_2, [s].[SupplierSku]) > 0) OR (@__Keyword_2 = N''))","severityLevel":"Information","properties":{"{OriginalFormat}":"Executed DbCommand ({elapsed}ms) [Parameters=[{parameters}], CommandType='{commandType}', CommandTimeout='{commandTimeout}']{newLine}{commandText}","parameters":"@__p_3='?', @__Keyword_0='?' (Size = 4000), @__Keyword_1='?' (Size = 4000), @__Keyword_2='?' (Size = 4000)","CategoryName":"Microsoft.EntityFrameworkCore.Database.Command","DeveloperMode":"true","commandText":"SELECT DISTINCT TOP(@__p_3) [p].[Gtin], [p].[Name], [c].[Name]\r\nFROM [Products] AS [p]\r\nLEFT JOIN [SupplierSpecs] AS [s] ON [p].[Id] = [s].[ProductId]\r\nLEFT JOIN [Brands] AS [c] ON [p].[BrandId] = [c].[Id]\r\nWHERE (((CHARINDEX(@__Keyword_0, [p].[Gtin]) > 0) OR (@__Keyword_0 = N'')) OR ((CHARINDEX(@__Keyword_1, [p].[Sku]) > 0) OR (@__Keyword_1 = N''))) OR ((CHARINDEX(@__Keyword_2, [s].[SupplierSku]) > 0) OR (@__Keyword_2 = N''))","AspNetCoreEnvironment":"Development","elapsed":"856","commandTimeout":"30","commandType":"Text"}}}}
Microsoft.EntityFrameworkCore.Database.Command:Information: Executed DbCommand (856ms) [Parameters=[@__p_3='?', @__Keyword_0='?' (Size = 4000), @__Keyword_1='?' (Size = 4000), @__Keyword_2='?' (Size = 4000)], CommandType='Text', CommandTimeout='30']
SELECT DISTINCT TOP(@__p_3) [p].[Gtin], [p].[Name], [c].[Name]
FROM [Products] AS [p]
LEFT JOIN [SupplierSpecs] AS [s] ON [p].[Id] = [s].[ProductId]
LEFT JOIN [Brands] AS [c] ON [p].[BrandId] = [c].[Id]
WHERE (((CHARINDEX(@__Keyword_0, [p].[Gtin]) > 0) OR (@__Keyword_0 = N'')) OR ((CHARINDEX(@__Keyword_1, [p].[Sku]) > 0) OR (@__Keyword_1 = N''))) OR ((CHARINDEX(@__Keyword_2, [s].[SupplierSku]) > 0) OR (@__Keyword_2 = N''))
Microsoft.EntityFrameworkCore.Database.Command Information: 20101 : Executed DbCommand (856ms) [Parameters=[@__p_3='?', @__Keyword_0='?' (Size = 4000), @__Keyword_1='?' (Size = 4000), @__Keyword_2='?' (Size = 4000)], CommandType='Text', CommandTimeout='30']
SELECT DISTINCT TOP(@__p_3) [p].[Gtin], [p].[Name], [c].[Name]
FROM [Products] AS [p]
LEFT JOIN [SupplierSpecs] AS [s] ON [p].[Id] = [s].[ProductId]
LEFT JOIN [Brands] AS [c] ON [p].[BrandId] = [c].[Id]
WHERE (((CHARINDEX(@__Keyword_0, [p].[Gtin]) > 0) OR (@__Keyword_0 = N'')) OR ((CHARINDEX(@__Keyword_1, [p].[Sku]) > 0) OR (@__Keyword_1 = N''))) OR ((CHARINDEX(@__Keyword_2, [s].[SupplierSku]) > 0) OR (@__Keyword_2 = N''))
Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker:Information: Executed action ***.Controllers.ProductController.*** (***) in 3737.9813ms

SELECT DISTINCT Top(10) [p].[Gtin], [p].[Name], [c].[Name]
FROM [Products] AS [p]
Left JOIN [SupplierSpecs] AS [s] ON [p].[Id] = [s].[ProductId]
Left Join [Brands] as [C] ON [p].BrandId = [c].Id
WHERE (((CHARINDEX('test', [p].[Gtin]) > 0) OR ('test' = N'')) OR ((CHARINDEX('test', [s].[SupplierSku]) > 0) OR ('test' = N''))) OR ((CHARINDEX('test', [p].[Sku]) > 0) OR ('test' = N''))