com.fr.restriction.MemoryAlarmException: SQL执行时长超过180S

几个表总数据量在1万条，查询出来100条数据，这个SQL时间太长，如何优化呢？ 

SELECT '合同工' as '用工形式',CONVERT(CHAR(6),a.fd_tingQiJiaoNianYue,112) AS fd_time,e.fd_name,b.fd_zhengJianHaoMa,b.fd_xingMing,b.fd_huJi,b.fd_ruShenHuShiJian,b.fd_minZu,b.fd_shouJiHaoMa,b.fd_tongXunDiZhi,b.fd_geRenShenFen,b.fd_jiaoCunJiShu,b.fd_xueLi,b.fd_yiLiaoJiaoFeiDangCi,b.fd_shebaogongzuobumen,

c.depName, c.depCode, c.danweiName, c.danweiDepCode,b.fd_sheBaoBianDongLeiXing,  b.fd_sheBaoQuanLuJing,     a.fd_biaoDanBianHao

FROM ekp_073_sbgjj a INNER JOIN ekp_073_sbgjj_sb b ON a.fd_id=b.fd_parent_id 

INNER JOIN Z_UserBumenDanwei c ON b.fd_dengLuMing=c.loginId

INNER JOIN km_review_main d ON a.fd_id = d.fd_id

INNER JOIN sys_org_element e ON b.fd_xingMing=e.fd_id

WHERE d.doc_status=30

AND b.fd_sheBaoQuanLuJing like REPLACE('%%', ',', '_') 

AND a.fd_liuDongNianYue='202006' 

AND 1=1