优化SQL语句：SELECT aId aRecordTime aEquipmentId eEquipmentName eEquipmentTypeId e0TypeName aRemarks aAlarmTime aAlarmCode aAlarmLevel aAlarmDescription aAlarmValue aAlarmCount aAlamType CASE WHEN aAlam

优化后的SQL语句如下：

SELECT a.Id, a.RecordTime, a.EquipmentId, e.EquipmentName, e.EquipmentTypeId, e0.TypeName, a.Remarks, a.AlarmTime, a.AlarmCode, a.AlarmLevel, a.AlarmDescription, a.AlarmValue, a.AlarmCount, a.AlamType, CASE WHEN a.AlamType = 0 THEN '报警' ELSE '故障' END AS AlamTypeName, a.SolveState, CASE WHEN a.SolveState = 0 THEN '待处理' ELSE '已处理' END AS SolveStateName, a.SolveUser, a.SolveTime, a.SolveResult FROM Alarm_History AS a LEFT JOIN Equipment_Info AS e ON a.EquipmentId = e.Id LEFT JOIN Equipment_Type AS e0 ON e.EquipmentTypeId = e0.Id WHERE NOT (a.Deleted) AND (e.EnterpriseId = '32a6060f-0914-11ee-84b7-6c3c8c6a422e')

UNION

SELECT a0.Id, a0.RecordTime, a0.EquipmentId, e1.EquipmentName, 'cdz' AS EquipmentTypeId, '充电桩' AS TypeName, a0.Remarks, a0.AlarmTime, a0.AlarmCode, a0.AlarmLevel, a0.AlarmDescription, a0.AlarmValue, a0.AlarmCount, a0.AlamType, CASE WHEN a0.AlamType = 0 THEN '报警' ELSE '故障' END AS AlamTypeName, a0.SolveState, CASE WHEN a0.SolveState = 0 THEN '待处理' ELSE '已处理' END AS SolveStateName, a0.SolveUser, a0.SolveTime, a0.SolveResult FROM Alarm_History AS a0 LEFT JOIN Equipment_ChargingPileInfo AS e1 ON a0.EquipmentId = e1.Id WHERE NOT (a0.Deleted) AND (e1.EnterpriseId = '32a6060f-0914-11ee-84b7-6c3c8c6a422e')

UNION

SELECT a1.Id, a1.RecordTime, a1.EquipmentId, e2.EquipmentName, 'cdq' AS EquipmentTypeId, '充电枪' AS TypeName, a1.Remarks, a1.AlarmTime, a1.AlarmCode, a1.AlarmLevel, a1.AlarmDescription, a1.AlarmValue, a1.AlarmCount, a1.AlamType, CASE WHEN a1.AlamType = 0 THEN '报警' ELSE '故障' END AS AlamTypeName, a1.SolveState, CASE WHEN a1.SolveState = 0 THEN '待处理' ELSE '已处理' END AS SolveStateName, a1.SolveUser, a1.SolveTime, a1.SolveResult FROM Alarm_History AS a1 LEFT JOIN Equipment_ChargingGunsInfo AS e2 ON a1.EquipmentId = e2.Id INNER JOIN Equipment_ChargingPileInfo AS e3 ON e2.ChargingPileId = e3.Id WHERE NOT (a1.Deleted) AND (e3.EnterpriseId = '32a6060f-0914-11ee-84b7-6c3c8c6a422e'