2023-10-17 09:53:17.582 ERROR (StatFilter.java:478) - slow sql 160390 millis. WITH temp2 AS ( SELECT * FROM ( SELECT getDateList.singleDay, ROW_NUMBER() OVER (ORDER BY getDateList.singleDay DESC) AS serialNum FROM ( SELECT CONVERT (VARCHAR(100), dateadd(d, number, '2018-07-18'),23) AS singleDay FROM master..spt_values WHERE type = 'p' ) getDateList WHERE getDateList.singleDay between ? and ? ) temp1 WHERE temp1.serialNum BETWEEN (0+1) AND (0/10+1)*10 ), jfListTemp AS(select * from z_integral_record_201611 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201701 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201702 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201703 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201707 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201708 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201709 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201710 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201711 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201712 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201801 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201802 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201803 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201804 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201805 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201806 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201807 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201809 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201810 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201811 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201812 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201901 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201903 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201904 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201905 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201906 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201907 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201908 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201909 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201910 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201911 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201912 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202002 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202003 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202004 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202005 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202006 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202007 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202008 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202009 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202010 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202011 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202012 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202101 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202102 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202103 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202104 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202105 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202106 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202109 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202110 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202111 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202112 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202201 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202202 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202203 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202204 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202205 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202206 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202207 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202208 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202209 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202210 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202211 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202212 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202301 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202302 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202303 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202304 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202305 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202306 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202308 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202309 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202310 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202307 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202108 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202107 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202001 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201902 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201808 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201706 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201705 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201704 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201612 (NOLOCK) where is_del = 0 ) SELECT temp.singleDay AS singleDay, ISNULL((select SUM(integral_num) FROM jfListTemp WHERE mode in(1,2,3,6,7) and datediff(day, record_time, temp.singleDay) = 0), 0)+ ISNULL((SELECT SUM(integral_num) FROM questionnaire_integral_record WITH(NOLOCK) WHERE datediff(day, create_time, temp.singleDay) = 0), 0)- ISNULL((select SUM(integral_num) FROM jfListTemp WHERE mode in(4) and web_user_ID like '%备案%' and datediff(day, record_time, temp.singleDay) = 0), 0) AS GrantCount, ISNULL((select SUM(to_ex_integral) FROM exchange_app WITH(NOLOCK) WHERE datediff(day, commit_time, temp.singleDay) = 0), 0) AS ApplyCount, ISNULL((select SUM(to_ex_integral) FROM exchange_app WITH(NOLOCK) WHERE ex_status = 2 and datediff(day, commit_time, temp.singleDay) = 0), 0) AS ApplySucCount, ISNULL((SELECT SUM( integral_num ) FROM jfListTemp WHERE mode = 10 AND datediff(day, record_time, temp.singleDay) = 0), 0 ) AS CancelCount, ISNULL((SELECT SUM(integral_num) FROM jfListTemp WHERE mode in(1,2,3,6,7) and record_time <= temp.singleDay), 0)+ ISNULL((SELECT SUM(integral_num) FROM questionnaire_integral_record WITH(NOLOCK) WHERE create_time <= temp.singleDay), 0)- ISNULL((SELECT SUM(to_ex_integral) FROM exchange_app WITH(NOLOCK) WHERE ex_status = 2 and commit_time <= temp.singleDay), 0)- ISNULL((SELECT SUM(integral_num) FROM jfListTemp WHERE mode in(4) and web_user_ID like '%备案%' and record_time <= temp.singleDay), 0)- ISNULL((SELECT SUM( integral_num ) FROM jfListTemp WHERE mode = 10 AND record_time <= temp.singleDay), 0 ) AS SurplusCount from temp2 temp["2018-07-18","2023-10-17"] 2023-10-17 09:57:44.522 ERROR (StatFilter.java:478) - slow sql 167683 millis. WITH temp2 AS ( SELECT * FROM ( SELECT getDateList.singleDay, ROW_NUMBER() OVER (ORDER BY getDateList.singleDay DESC) AS serialNum FROM ( SELECT CONVERT (VARCHAR(100), dateadd(d, number, '2018-07-18'),23) AS singleDay FROM master..spt_values WHERE type = 'p' ) getDateList WHERE getDateList.singleDay between ? and ? ) temp1 WHERE temp1.serialNum BETWEEN (10+1) AND (10/10+1)*10 ), jfListTemp AS(select * from z_integral_record_201611 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201612 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201701 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201702 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201703 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201704 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201705 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201706 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201707 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201708 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201709 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201710 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201711 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201712 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201801 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201802 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201803 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201804 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201805 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201806 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201807 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201808 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201809 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201810 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201811 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201812 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201901 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201902 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201903 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201904 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201905 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201906 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201907 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201908 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201909 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201910 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201911 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201912 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202001 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202002 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202003 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202004 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202005 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202006 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202007 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202008 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202009 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202010 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202011 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202012 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202101 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202102 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202103 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202104 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202105 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202106 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202107 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202108 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202109 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202110 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202111 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202112 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202201 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202202 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202203 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202204 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202205 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202206 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202207 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202208 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202209 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202210 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202211 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202212 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202301 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202302 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202303 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202304 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202305 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202306 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202307 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202308 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202309 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202310 (NOLOCK) where is_del = 0 ) SELECT temp.singleDay AS singleDay, ISNULL((select SUM(integral_num) FROM jfListTemp WHERE mode in(1,2,3,6,7) and datediff(day, record_time, temp.singleDay) = 0), 0)+ ISNULL((SELECT SUM(integral_num) FROM questionnaire_integral_record WITH(NOLOCK) WHERE datediff(day, create_time, temp.singleDay) = 0), 0)- ISNULL((select SUM(integral_num) FROM jfListTemp WHERE mode in(4) and web_user_ID like '%备案%' and datediff(day, record_time, temp.singleDay) = 0), 0) AS GrantCount, ISNULL((select SUM(to_ex_integral) FROM exchange_app WITH(NOLOCK) WHERE datediff(day, commit_time, temp.singleDay) = 0), 0) AS ApplyCount, ISNULL((select SUM(to_ex_integral) FROM exchange_app WITH(NOLOCK) WHERE ex_status = 2 and datediff(day, commit_time, temp.singleDay) = 0), 0) AS ApplySucCount, ISNULL((SELECT SUM( integral_num ) FROM jfListTemp WHERE mode = 10 AND datediff(day, record_time, temp.singleDay) = 0), 0 ) AS CancelCount, ISNULL((SELECT SUM(integral_num) FROM jfListTemp WHERE mode in(1,2,3,6,7) and record_time <= temp.singleDay), 0)+ ISNULL((SELECT SUM(integral_num) FROM questionnaire_integral_record WITH(NOLOCK) WHERE create_time <= temp.singleDay), 0)- ISNULL((SELECT SUM(to_ex_integral) FROM exchange_app WITH(NOLOCK) WHERE ex_status = 2 and commit_time <= temp.singleDay), 0)- ISNULL((SELECT SUM(integral_num) FROM jfListTemp WHERE mode in(4) and web_user_ID like '%备案%' and record_time <= temp.singleDay), 0)- ISNULL((SELECT SUM( integral_num ) FROM jfListTemp WHERE mode = 10 AND record_time <= temp.singleDay), 0 ) AS SurplusCount from temp2 temp["2018-07-18","2023-10-17"] 2023-10-17 10:02:33.731 ERROR (StatFilter.java:478) - slow sql 163763 millis. WITH temp2 AS ( SELECT * FROM ( SELECT getDateList.singleDay, ROW_NUMBER() OVER (ORDER BY getDateList.singleDay DESC) AS serialNum FROM ( SELECT CONVERT (VARCHAR(100), dateadd(d, number, '2018-07-18'),23) AS singleDay FROM master..spt_values WHERE type = 'p' ) getDateList WHERE getDateList.singleDay between ? and ? ) temp1 WHERE temp1.serialNum BETWEEN (20+1) AND (20/10+1)*10 ), jfListTemp AS(select * from z_integral_record_201611 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201612 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201701 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201702 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201703 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201704 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201705 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201706 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201707 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201708 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201709 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201710 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201711 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201712 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201801 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201802 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201803 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201804 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201805 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201806 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201807 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201808 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201809 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201810 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201811 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201812 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201901 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201902 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201903 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201904 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201905 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201906 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201907 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201908 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201909 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201910 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201911 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201912 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202001 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202002 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202003 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202004 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202005 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202006 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202007 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202008 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202009 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202010 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202011 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202012 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202101 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202102 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202103 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202104 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202105 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202106 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202107 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202108 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202109 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202110 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202111 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202112 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202201 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202202 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202203 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202204 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202205 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202206 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202207 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202208 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202209 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202210 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202211 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202212 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202301 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202302 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202303 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202304 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202305 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202306 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202307 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202308 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202309 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202310 (NOLOCK) where is_del = 0 ) SELECT temp.singleDay AS singleDay, ISNULL((select SUM(integral_num) FROM jfListTemp WHERE mode in(1,2,3,6,7) and datediff(day, record_time, temp.singleDay) = 0), 0)+ ISNULL((SELECT SUM(integral_num) FROM questionnaire_integral_record WITH(NOLOCK) WHERE datediff(day, create_time, temp.singleDay) = 0), 0)- ISNULL((select SUM(integral_num) FROM jfListTemp WHERE mode in(4) and web_user_ID like '%备案%' and datediff(day, record_time, temp.singleDay) = 0), 0) AS GrantCount, ISNULL((select SUM(to_ex_integral) FROM exchange_app WITH(NOLOCK) WHERE datediff(day, commit_time, temp.singleDay) = 0), 0) AS ApplyCount, ISNULL((select SUM(to_ex_integral) FROM exchange_app WITH(NOLOCK) WHERE ex_status = 2 and datediff(day, commit_time, temp.singleDay) = 0), 0) AS ApplySucCount, ISNULL((SELECT SUM( integral_num ) FROM jfListTemp WHERE mode = 10 AND datediff(day, record_time, temp.singleDay) = 0), 0 ) AS CancelCount, ISNULL((SELECT SUM(integral_num) FROM jfListTemp WHERE mode in(1,2,3,6,7) and record_time <= temp.singleDay), 0)+ ISNULL((SELECT SUM(integral_num) FROM questionnaire_integral_record WITH(NOLOCK) WHERE create_time <= temp.singleDay), 0)- ISNULL((SELECT SUM(to_ex_integral) FROM exchange_app WITH(NOLOCK) WHERE ex_status = 2 and commit_time <= temp.singleDay), 0)- ISNULL((SELECT SUM(integral_num) FROM jfListTemp WHERE mode in(4) and web_user_ID like '%备案%' and record_time <= temp.singleDay), 0)- ISNULL((SELECT SUM( integral_num ) FROM jfListTemp WHERE mode = 10 AND record_time <= temp.singleDay), 0 ) AS SurplusCount from temp2 temp["2018-07-18","2023-10-17"] 2023-10-17 10:05:38.589 ERROR (StatFilter.java:478) - slow sql 158882 millis. WITH temp2 AS ( SELECT * FROM ( SELECT getDateList.singleDay, ROW_NUMBER() OVER (ORDER BY getDateList.singleDay DESC) AS serialNum FROM ( SELECT CONVERT (VARCHAR(100), dateadd(d, number, '2018-07-18'),23) AS singleDay FROM master..spt_values WHERE type = 'p' ) getDateList WHERE getDateList.singleDay between ? and ? ) temp1 WHERE temp1.serialNum BETWEEN (30+1) AND (30/10+1)*10 ), jfListTemp AS(select * from z_integral_record_201611 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201612 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201701 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201702 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201703 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201704 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201705 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201706 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201707 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201708 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201709 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201710 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201711 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201712 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201801 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201802 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201803 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201804 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201805 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201806 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201807 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201808 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201809 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201810 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201811 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201812 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201901 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201902 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201903 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201904 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201905 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201906 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201907 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201908 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201909 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201910 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201911 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201912 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202001 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202002 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202003 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202004 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202005 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202006 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202007 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202008 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202009 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202010 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202011 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202012 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202101 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202102 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202103 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202104 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202105 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202106 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202107 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202108 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202109 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202110 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202111 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202112 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202201 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202202 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202203 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202204 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202205 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202206 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202207 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202208 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202209 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202210 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202211 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202212 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202301 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202302 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202303 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202304 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202305 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202306 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202307 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202308 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202309 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202310 (NOLOCK) where is_del = 0 ) SELECT temp.singleDay AS singleDay, ISNULL((select SUM(integral_num) FROM jfListTemp WHERE mode in(1,2,3,6,7) and datediff(day, record_time, temp.singleDay) = 0), 0)+ ISNULL((SELECT SUM(integral_num) FROM questionnaire_integral_record WITH(NOLOCK) WHERE datediff(day, create_time, temp.singleDay) = 0), 0)- ISNULL((select SUM(integral_num) FROM jfListTemp WHERE mode in(4) and web_user_ID like '%备案%' and datediff(day, record_time, temp.singleDay) = 0), 0) AS GrantCount, ISNULL((select SUM(to_ex_integral) FROM exchange_app WITH(NOLOCK) WHERE datediff(day, commit_time, temp.singleDay) = 0), 0) AS ApplyCount, ISNULL((select SUM(to_ex_integral) FROM exchange_app WITH(NOLOCK) WHERE ex_status = 2 and datediff(day, commit_time, temp.singleDay) = 0), 0) AS ApplySucCount, ISNULL((SELECT SUM( integral_num ) FROM jfListTemp WHERE mode = 10 AND datediff(day, record_time, temp.singleDay) = 0), 0 ) AS CancelCount, ISNULL((SELECT SUM(integral_num) FROM jfListTemp WHERE mode in(1,2,3,6,7) and record_time <= temp.singleDay), 0)+ ISNULL((SELECT SUM(integral_num) FROM questionnaire_integral_record WITH(NOLOCK) WHERE create_time <= temp.singleDay), 0)- ISNULL((SELECT SUM(to_ex_integral) FROM exchange_app WITH(NOLOCK) WHERE ex_status = 2 and commit_time <= temp.singleDay), 0)- ISNULL((SELECT SUM(integral_num) FROM jfListTemp WHERE mode in(4) and web_user_ID like '%备案%' and record_time <= temp.singleDay), 0)- ISNULL((SELECT SUM( integral_num ) FROM jfListTemp WHERE mode = 10 AND record_time <= temp.singleDay), 0 ) AS SurplusCount from temp2 temp["2018-07-18","2023-10-17"] 2023-10-17 10:09:08.470 ERROR (StatFilter.java:478) - slow sql 161619 millis. WITH temp2 AS ( SELECT * FROM ( SELECT getDateList.singleDay, ROW_NUMBER() OVER (ORDER BY getDateList.singleDay DESC) AS serialNum FROM ( SELECT CONVERT (VARCHAR(100), dateadd(d, number, '2018-07-18'),23) AS singleDay FROM master..spt_values WHERE type = 'p' ) getDateList WHERE getDateList.singleDay between ? and ? ) temp1 WHERE temp1.serialNum BETWEEN (40+1) AND (40/10+1)*10 ), jfListTemp AS(select * from z_integral_record_201611 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201612 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201701 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201702 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201703 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201704 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201705 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201706 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201707 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201708 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201709 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201710 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201711 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201712 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201801 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201802 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201803 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201804 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201805 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201806 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201807 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201808 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201809 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201810 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201811 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201812 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201901 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201902 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201903 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201904 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201905 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201906 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201907 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201908 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201909 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201910 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201911 (NOLOCK) where is_del = 0 union all select * from z_integral_record_201912 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202001 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202002 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202003 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202004 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202005 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202006 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202007 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202008 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202009 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202010 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202011 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202012 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202101 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202102 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202103 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202104 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202105 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202106 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202107 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202108 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202109 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202110 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202111 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202112 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202201 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202202 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202203 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202204 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202205 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202206 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202207 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202208 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202209 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202210 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202211 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202212 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202301 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202302 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202303 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202304 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202305 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202306 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202307 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202308 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202309 (NOLOCK) where is_del = 0 union all select * from z_integral_record_202310 (NOLOCK) where is_del = 0 ) SELECT temp.singleDay AS singleDay, ISNULL((select SUM(integral_num) FROM jfListTemp WHERE mode in(1,2,3,6,7) and datediff(day, record_time, temp.singleDay) = 0), 0)+ ISNULL((SELECT SUM(integral_num) FROM questionnaire_integral_record WITH(NOLOCK) WHERE datediff(day, create_time, temp.singleDay) = 0), 0)- ISNULL((select SUM(integral_num) FROM jfListTemp WHERE mode in(4) and web_user_ID like '%备案%' and datediff(day, record_time, temp.singleDay) = 0), 0) AS GrantCount, ISNULL((select SUM(to_ex_integral) FROM exchange_app WITH(NOLOCK) WHERE datediff(day, commit_time, temp.singleDay) = 0), 0) AS ApplyCount, ISNULL((select SUM(to_ex_integral) FROM exchange_app WITH(NOLOCK) WHERE ex_status = 2 and datediff(day, commit_time, temp.singleDay) = 0), 0) AS ApplySucCount, ISNULL((SELECT SUM( integral_num ) FROM jfListTemp WHERE mode = 10 AND datediff(day, record_time, temp.singleDay) = 0), 0 ) AS CancelCount, ISNULL((SELECT SUM(integral_num) FROM jfListTemp WHERE mode in(1,2,3,6,7) and record_time <= temp.singleDay), 0)+ ISNULL((SELECT SUM(integral_num) FROM questionnaire_integral_record WITH(NOLOCK) WHERE create_time <= temp.singleDay), 0)- ISNULL((SELECT SUM(to_ex_integral) FROM exchange_app WITH(NOLOCK) WHERE ex_status = 2 and commit_time <= temp.singleDay), 0)- ISNULL((SELECT SUM(integral_num) FROM jfListTemp WHERE mode in(4) and web_user_ID like '%备案%' and record_time <= temp.singleDay), 0)- ISNULL((SELECT SUM( integral_num ) FROM jfListTemp WHERE mode = 10 AND record_time <= temp.singleDay), 0 ) AS SurplusCount from temp2 temp["2018-07-18","2023-10-17"]