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>