原始写法:SELECT * FROM table_v2 LIMIT 0, 3412771;
优化写法:SELECT t1.* FROM table_v2 t1, (SELECT id FROM table_v2 LIMIT 0, 3412771) t2 WHERE t1.id=t2.id;
优化后的写法是原始的10倍至少
原始写法:SELECT * FROM table_v2 LIMIT 0, 3412771;
优化写法:SELECT t1.* FROM table_v2 t1, (SELECT id FROM table_v2 LIMIT 0, 3412771) t2 WHERE t1.id=t2.id;
优化后的写法是原始的10倍至少