优化一下sqlSELECT taarrivaltime FROM SELECT cdtolerance FROM devicesensor as a LEFT JOIN sensor as c on asensorid = csensorid LEFT JOIN dataalarm as d on cdataalarmid = ddataalarmid WHERE adeviceid =F3210

SELECT t., a.arrivaltime FROM (SELECT c., d.tolerance FROM devicesensor AS a LEFT JOIN sensor AS c ON a.sensorid = c.sensorid LEFT JOIN dataalarm AS d ON c.dataalarmid = d.dataalarmid WHERE a.deviceid = 'F321003124779dd-0bf7-4f08-a0b1-f66c917e9ddf4G') t LEFT JOIN sensordata AS a ON t.sensorid = a.sensorid AND a.arrivaltime > NOW() - INTERVAL '480 MINUTE' ORDER BY a.arrivaltime DESC