联表命中索引

select * from tblA as a left join tblB as b on a.id=b.a_id where 1 order by b.a_id desc limit 10;

order by，tblB的索引影响排序。