sql查询慢

– sql1
select from t_put_in_channel where (channel_code,sub_channel_code) in ( select channel,sub_channel from t_live_entry_record r left join t_live_record_source s on r.id=s.id where r.status=2 and camp_date_id=#{campDateId} and r.customer_id=#{customerId} ) limit 1

– sql2
SELECT t_put_in_channel.* FROM t_put_in_channel, ( SELECT channel, sub_channel FROM t_live_record_source WHERE id IN ( SELECT id FROM t_live_entry_record WHERE STATUS=2 AND camp_date_id=348178406087967236 AND customer_id=349160714526171545 – 换其他值后,查询就比较快 ) )t_one WHERE t_put_in_channel.channel_code = t_one.channel AND t_put_in_channel.sub_channel_code = t_one.sub_channel LIMIT 1;

mysql:查询一致
tidb:sql2查询较快,sql1较慢
如上,切换其他的值后,查询就比较快。
怀疑tidb配置问题

explain analyze sql 反馈下执行计划先看看,多谢。