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的索引影响排序。