show full processlist;
-- 原sql
select SQL_CALC_FOUND_ROWS * from tx_crm_custlibary_800075 where 1=1 order by modifytime desc,autoid desc limit 0,20;
-- 优化sql
SELECT t1.* FROM tx_crm_custlibary_800075 t1, (SELECT autoid FROM tx_crm_custlibary_800075 where autoid>(select min(autoid) from tx_crm_custlibary_800075 order by modifytime desc,autoid desc limit 20) ) t2
WHERE t1.autoid=t2.autoid limit 0,20;
-- 原sql
select SQL_CALC_FOUND_ROWS * from tx_crm_custlibary_800075 where 1=1 order by modifytime desc,autoid desc limit 0,20;
-- 优化sql
SELECT t1.* FROM tx_crm_custlibary_800075 t1, (SELECT autoid FROM tx_crm_custlibary_800075 where autoid>(select min(autoid) from tx_crm_custlibary_800075 order by modifytime desc,autoid desc limit 20) ) t2
WHERE t1.autoid=t2.autoid limit 0,20;