优化MySQL语句：获取最新记录的聚合数据

优化后的MySQL语句：\nSELECT SUM(COALESCE(i1.PowerInverter, 0.0)) AS PowerInverter, SUM(COALESCE(i1.ThisPower, 0.0)) AS ThisPower\nFROM (\n SELECT i.EquipmentId, MAX(i0.Id) AS Id\n FROM Inverter_History AS i\n INNER JOIN (\n SELECT MAX(Id) AS MaxId\n FROM Inverter_History\n WHERE NOT Deleted\n GROUP BY EquipmentId\n ) AS i0 ON i.Id = i0.MaxId\n WHERE NOT i.Deleted\n GROUP BY i.EquipmentId\n) AS t\nLEFT JOIN Inverter_History AS i1 ON t.Id = i1.Id\nLEFT JOIN Equipment_Info AS e ON t.EquipmentId = e.Id\nLEFT JOIN Equipment_Type AS e0 ON e.EquipmentTypeId = e0.Id\nLEFT JOIN Base_Enterprise AS b ON e.EnterpriseId = b.Id\nWHERE i1.Deleted = FALSE AND e.Deleted = FALSE AND e.IsEnable = TRUE AND e0.Deleted = FALSE AND e0.IsEnable = TRUE AND b.Deleted = FALSE AND b.IsEnable = TRUE AND e.EnterpriseId = '32a6060f-0914-11ee-84b7-6c3c8c6a422e'\nGROUP BY e.EnterpriseId