优化sqlSELECT pool SUM recordSUM_WORK_HOUR AS 总工时 sum recordSUM_WORK_WAGE AS 总工资 FROM labor_worker_pool AS pool RIGHT JOIN labor_work_record AS record ON poolID = recordWORKER_POOL_ID WHERE recordSETT

SELECT pool.*, COALESCE(SUM(record.SUM_WORK_HOUR), 0) AS 总工时, COALESCE(SUM(record.SUM_WORK_WAGE), 0) AS 总工资 FROM labor_worker_pool AS pool LEFT JOIN labor_work_record AS record ON pool.ID = record.WORKER_POOL_ID AND record.SETTLE_STATUS = 1 GROUP BY pool.ID