查询数据库100W万条数据，一直在查询不会结束

Question

List<VocabularySp> vocabularySpList = vocabularySpMapper.AllVocabularySp(indat, indatend, Make, vocabularyhy, activitys, sbspType, sjType, siteid, shopid);
indat = sdf.parse("2023-1-1");
 indatend=sdf.parse("2023-12-31");
//执行到这条语句，不会报错。一直在查询。数据库里150多万条数据，这个条件可以查询到65万条，我给时间字段增加了索引。数据库里这条SQL3.4秒就可以查询完成

SELECT  vo.id,sh.site,op.ShowId,sk.Make_Up,vo.activitys,vo.adGroup
    FROM vocabularysp vo
    LEFT JOIN  sp_sd_sb sp ON sp.id=vo.spsbsdid
    LEFT JOIN sku_make_up sk ON sk.Id=vo.skumakeid
    LEFT JOIN currency_rate cu on cu.id=vo.currencyid
    LEFT JOIN matching ma ON ma.id=vo.matchingid
    left join shop op on op.Id=sk.shop_id
    left join sh_site sh on sh.id=op.Site_id
 <where>
      <if test="indat != null and indatend!=null">
        vo.indat  between #{indat} AND #{indatend}
      </if>
</where>

Answer 1

试着在尾部加一条LIMIT #{pageSize} OFFSET #{offset}