select a.fid, a.lat, a.lon, a.curtime FROM plog a,(SELECT fid FROM flog WHERE name = '1234' AND time > 10) b where a.fid=b.fid
因为对每个记录MYSQL都去运算了一次 (SELECT fid FROM flog WHERE name = '1234' AND time > 10) 所以建议改为连接表 比如上面的,或者另一个种写法 select a.fid, a.lat, a.lon, a.curtime FROM plog a inner join (SELECT fid FROM flog WHERE name = '1234' AND time > 10) b on a.fid=b.fid order by a.fid, curtime
FROM plog a,(SELECT fid FROM flog WHERE name = '1234' AND time > 10) b
where a.fid=b.fid
select a.fid, a.lat, a.lon, a.curtime
FROM plog a inner join (SELECT fid FROM flog WHERE name = '1234' AND time > 10) b on a.fid=b.fid
order by a.fid, curtime