MYSQL5.7查询缓慢 Using where； Using join buffer (Block Nested Loop)

explain
select t1.company_name,t1.subject_name,t1.business_line,t1.dicker,t1.months,t1.amount '当月金额',t1.amount '累计金额'   from f_finance_business_2022 t1
inner join f_finance_business_2022 t2
on t1.company_name=t2.company_name
and t1.subject_name=t2.subject_name
and t1.business_line=t2.business_line
and t1.dicker=t2.dicker
and t1.months=t2.months
and t2.type='累计发生'
and t2.data_sources='执行'
where t1.type='当月发生'
and t1.data_sources='执行'

MySQL5.7执行计划

MySQL8.0执行计划

该表没有索引，数据量10w+，同一张表不存在字段类型不一致情况，那位大佬知道MySQL5.7为啥走 Block Nested Loop