1.LEFT JOIN 与 INNER JOIN
建议使用 INNER JOIN 查询数据量会小一点
2.分页id定位优化
select * from orders_history where type=2 and id between 1000000 and 1000100 limit 100;
select * from orders_history where id in (select order_id from trade_2 where goods = 'pen') limit 100;
3.使用子查询优化
select * from orders_history where type=8 and id>=(select id from orders_history where type=8 limit 100000,1) limit 100;