mySql多表关联查询 分页优化的问题

Hansen1160

请问各位大神，我用mysql关联查询，limit进行分页 ，但是当数据过万时翻页就特别慢，请问有什么好的优化办法啊？
我的代码：


      SELECT
           c0.c_custnum AS cCustnum,
           c0.c_username AS cUsername,
       
        c10.cust_rank AS custRank,
        jifen30.rank_name AS rankName,
        c10.c_accdate AS cAccdate,
        c10.c_custname AS cCustname

      FROM
          capf00 AS c0
      LEFT JOIN capf10 AS c10 ON c0.c_custnum = c10.c_custnum
      LEFT JOIN capf30 AS c30 ON (c10.c_custnum = c30.c_custnum AND c30.is_del = 'N')
      LEFT JOIN capf120 ON capf120.cust_no = c10.c_custnum
      LEFT JOIN jifen30 ON c10.cust_rank = jifen30.cust_rank
      LEFT JOIN capf101 ON capf101.cust_no = c0.c_custnum

      WHERE
          capf120.create_time IS NULL
      AND c0.is_del = 'N'
      AND c10.is_del = 'N'


      LIMIT 9500 OFFSET 10