SELECT * FROM error_log
WHERE ( status
= 1 ) ORDER BY addtime desc LIMIT 10,10 [ RunTime:14.627021s ]
更改SQL查询方式如下:
SELECT * FROM error_log a JOIN (select id from error_log limit 10, 10) b ON a.id = b.id
执行时间为 0.050s
SELECT * FROM error_log
WHERE ( status
= 1 ) ORDER BY addtime desc LIMIT 10,10 [ RunTime:14.627021s ]
更改SQL查询方式如下:
SELECT * FROM error_log a JOIN (select id from error_log limit 10, 10) b ON a.id = b.id
执行时间为 0.050s