原来的sql:
select a.id, a.orderName from a order by a.orderName limit 50, 5;
优化的sql:
select a.id, a.orderName from a
inner join (
select id from a
order by orderName limit 50, 5
) as b using(id);
原来的sql:
select a.id, a.orderName from a order by a.orderName limit 50, 5;
优化的sql:
select a.id, a.orderName from a
inner join (
select id from a
order by orderName limit 50, 5
) as b using(id);