Dario

因为你每5秒测量一次 $date_start 第一个匹配测量值不能大于4。然后我们每600秒进行一次输入(考虑到时钟之间的某些差异…)

SELECT sensor_1 
  FROM sensor_table
 WHERE timestamp >= UNIX_TIMESTAMP($date_start) 
       AND 
       timestamp < UNIX_TIMESTAMP($date_stop) 
       AND
       ((timestamp - UNIX_TIMESTAMP($date_start)) % 600) BETWEEN 0 AND 4 
 ORDER BY timestamp;