asp.net-mvc-3 – Glimpse HUD和SQL选项卡中数据库查询计数之间

这个问题涉及Glimpse.MVC3和Glimpse.EF5包.我正在尝试在旧的MVC3站点上调试性能问题.根据Glimpse的HUD,一个特定的GET请求共有12个查询,总共28ms – 但是当我展开以打开主面板,然后单击SQL选项卡时,它说只有6个查询,总共10.41ms.顶部的计数都是6,当我计算它列出的查询时,有6个.当我看到编写的代码时,这也是有意义的. (无论哪种方式,我都可以看到太多是懒惰加载,它需要修复.)

没有来自Glimpse的指标,相同的6个查询正在被执行两次(当我看到HUD显示的面板数量是面板的两倍时,这就是我的大脑所在的位置).

此外,HUD显示0个Ajax请求,但历史部分实际显示1(这绝对是准确的).

有什么想法会出现差异吗？ (请记住,我更关心与查询的差异.)

编辑 – 请求的文件中的JSON：

glimpse_sql:
{
  data:
  {
    "SQL Statistics":
    [
      {
        connectionCount: 6
        queryCount: 6
        transactionCount: 0
        queryExecutionTime: 6.91
        connectionOpenTime: 116.08
      }
    ]
    Queries:
    [
      [
        Commands per Connection
        Duration
      ]

hud:
  {
    sql:
    {
      data:
      {
        queryCount: 12
        connectionCount: 12
        transactionCount: 0
        queryExecutionTime: 41.87
        connectionOpenTime: 242.96
      }
      name: sql
    }

编辑2 – 查询

"Queries":[["Commands per Connection","Duration"],[[["Transaction Start","Ordinal","Command","Parameters","Records","Duration","Offset","Async","Transaction End","Errors"],[null,"1","SELECT TOP (2) rn[Extent1].[TrxnID] AS [TrxnID],rn[Extent1].[StartTime] AS [StartTime],rn[Extent1].[Lane] AS [Lane],rn[Extent1].[EmployeeID] AS [EmployeeID],rn[Extent1].[OptionsCompleted] AS [OptionsCompleted],rn[Extent1].[StoreID] AS [StoreID],rn[Extent1].[NoVehicleTireCheck] AS [NoVehicleTireCheck],rnFROM [Activity].[Trxn] AS [Extent1]rnWHERE [Extent1].[TrxnID] = 353 /* @p__linq__0 */",[["Name","Value","Type","Size"],["@p__linq__0",353,"Int32",0]],1,1.12,76.67,false,null,""]],5.85],"SELECT rn[Extent1].[TrxnID] AS [TrxnID],rn[Extent1].[CustomerID] AS [CustomerID],rn[Extent1].[FirstName] AS [FirstName],rn[Extent1].[LastName] AS [LastName],rn[Extent1].[RewardAccountID] AS [RewardAccountID],rn[Extent1].[CustomerEmail] AS [CustomerEmail],rn[Extent1].[HomePhone] AS [HomePhone]rnFROM [Activity].[Trxn_Customers] AS [Extent1]rnWHERE [Extent1].[TrxnID] = 353 /* @EntityKeyValue1 */",["@EntityKeyValue1",1.18,102.7,21.7],rn[Extent1].[VehicleID] AS [VehicleID],rn[Extent1].[VehicleVIN] AS [VehicleVIN],rn[Extent1].[VehicleOdometer] AS [VehicleOdometer],rn[Extent1].[VehicleEngineID] AS [VehicleEngineID],rn[Extent1].[VehicleMakeID] AS [VehicleMakeID],rn[Extent1].[ModelYear] AS [ModelYear]rnFROM [Activity].[Trxn_Vehicles] AS [Extent1]rnWHERE [Extent1].[TrxnID] = 353 /* @EntityKeyValue1 */",1.26,2301.56,27.72],rn[Extent1].[SecondaryVehicleID] AS [SecondaryVehicleID],rn[Extent1].[SecondaryVehicleVIN] AS [SecondaryVehicleVIN],rn[Extent1].[SecondaryVehicleTypeID] AS [SecondaryVehicleTypeID],rn FROM [Activity].[Trxn_SecondaryVehicles] AS [Extent1]rn WHERE [Extent1].[TrxnID] = 353 /* @EntityKeyValue1 */",1.15,2325.95,23.15],"SELECT rn[Extent1].[TrxnServiceID] AS [TrxnServiceID],rn[Extent1].[TrxnID] AS [TrxnID],rn[Extent1].[PackageID] AS [PackageID],rn[Extent1].[PartID] AS [PartID],rn[Extent1].[Qty] AS [Qty]rnFROM [Activity].[Trxn_Services] AS [Extent1]rnWHERE [Extent1].[TrxnID] = 353 /* @EntityKeyValue1 */",1.02,2342.92,15.74],"SELECT rn[Extent1].[TrxnNoteID] AS [TrxnNoteID],rn[Extent1].[NoteText] AS [NoteText],rn[Extent1].[NoteNumber] AS [NoteNumber],rn[Extent1].[SendToInvoice] AS [SendToInvoice]rnFROM [Activity].[Trxn_Notes] AS [Extent1]rnWHERE [Extent1].[TrxnID] = 353 /* @EntityKeyValue1 */",1.19,4689.34,21.92]

]},"name":"SQL"}