优化SQL语句：SET __startTimeYear_1 = TIMESTAMP 2023-01-01 000000;SET __endTimeYear_2 = TIMESTAMP 2023-12-31 235959999999;SET __startTimeMonth_3 = TIMESTAMP 2023-07-01 000000;SET __endTimeMonth_4 = TIMESTAM

优化后的SQL语句： SELECT SUM(COALESCE(c0.ChargeCapacity, 0.0)) AS ChargeCapacityYear, SUM(COALESCE(c1.ChargeCapacity, 0.0)) AS ChargeCapacityMonth, SUM(COALESCE(c2.ChargeCapacity, 0.0)) AS ChargeCapacityDay FROM Charging_Order AS c LEFT JOIN Equipment_ChargingGunsInfo AS e ON c.ChargingGunId = e.Id LEFT JOIN Equipment_ChargingPileInfo AS e0 ON e.ChargingPileId = e0.Id LEFT JOIN Charging_Order AS c0 ON c0.ChargingGunId = e.Id LEFT JOIN Charging_Order AS c1 ON c1.ChargingGunId = e.Id LEFT JOIN Charging_Order AS c2 ON c2.ChargingGunId = e.Id WHERE (((((NOT (c.Deleted) AND (e.Deleted = FALSE)) AND (e.IsEnable = TRUE)) AND (e0.Deleted = FALSE)) AND (e0.IsEnable = TRUE)) AND (e0.EnterpriseId = '1638003434462388224')) AND ((c0.ChargingBeginTime >= TIMESTAMP '2023-01-01 00:00:00') AND (c0.ChargingBeginTime <= TIMESTAMP '2023-12-31 23:59:59.999999')) AND ((c1.ChargingBeginTime >= TIMESTAMP '2023-07-01 00:00:00') AND (c1.ChargingBeginTime <= TIMESTAMP '2023-07-31 23:59:59.999999')) AND ((c2.ChargingBeginTime >= TIMESTAMP '2023-07-04 00:00:00') AND (c2.ChargingBeginTime <= TIMESTAMP '2023-07-04 23:59:59.999999')