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_biaoDanBianHaoFROM 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.loginIdINNER JOIN km_review_main d ON a.fd_id = d.fd_idINNER JOIN sys_org_element e ON b.fd_xingMing=e.fd_idWHERE d.doc_status=30AND b.fd_sheBaoQuanLuJing like REPLACE('%%', ',', '_') AND a.fd_liuDongNianYue='202006' AND 1=1
