select中的子查询遇到分页的limit

所有数据执行一遍子查询，再执行limit？？？

导致速度极慢。。。

      select
       
        (select sum(osld.quantity) from xxxx_stylelist_detail dWHERE d.OrderId=os.OrderId) orderQty
       
        from xxxxx_out_detail wmod
        left join xxxx_stylelist os on os.orderid=wob.orderid

        group by os.orderid
        limit ${startIndex},${pageSize}