【服务运行监控】-->接口服务诊断界面上查看趋势图时，后台报出连接超时，无法查看结果。通过客户端使用SQL语句查询，可以查询出数据，用时1分30秒，数据库的最大超时为500。请帮忙分析下sql语句，能否进行优化。另外，统计综合查询问题与此情况类似，也应该为sql效率问题

select '$queryEntityId$' as column1_89_0_, this_.SRC_APP_CODE as SRC2_89_0_, this_.DEST_OPERATION_CODE as DEST3_89_0_, this_.STATISTICS_TIME as STATISTICS4_89_0_, this_.SUCCESS_NUM as SUCCESS5_89_0_, this_.SYSTEM_EXCEPTION_NUM as SYSTEM6_89_0_, this_.BUSI_EXCEPTION_NUM as BUSI7_89_0_, this_.TIMEOUT_NUM as TIMEOUT8_89_0_, this_.TOTAL_DURATION as TOTAL9_89_0_, this_.TOTAL_REQ_SIZE as TOTAL10_89_0_, this_.TOTAL_RESP_SIZE as TOTAL11_89_0_, this_.SRC_IP as SRC12_89_0_, this_.TOTAL_ILLEGAL_USE_NUM as TOTAL13_89_0_, this_.TOTAL_ILLEGAL_IP_NUM as TOTAL14_89_0_ from (SELECT T.SRC_APP_CODE , 
T.DEST_OPERATION_CODE , 
T.SRC_IP, 
STR_TO_DATE(T.STATISTICS_TIME, '%Y-%m-%d %H:%i:%s') STATISTICS_TIME , 
SUM(T.TOTAL_DURATION ) TOTAL_DURATION , 
SUM(T.SUCCESS_NUM) SUCCESS_NUM, 
SUM(T.SYSTEM_EXCEPTION_NUM) SYSTEM_EXCEPTION_NUM, 
SUM(T.BUSI_EXCEPTION_NUM) BUSI_EXCEPTION_NUM, 
SUM(T.TIMEOUT_NUM) TIMEOUT_NUM, 
SUM(T.TOTAL_REQ_SIZE) TOTAL_REQ_SIZE, 
SUM(T.TOTAL_RESP_SIZE) TOTAL_RESP_SIZE , 
SUM(T.ILLEGAL_USE_NUM) TOTAL_ILLEGAL_USE_NUM, 
SUM(T.ILLEGAL_IP_NUM) TOTAL_ILLEGAL_IP_NUM 
FROM SSM_SERVICE_STATISTICS T 
GROUP BY T.SRC_APP_CODE , 
T.DEST_OPERATION_CODE , 
T.SRC_IP, 
STR_TO_DATE(T.STATISTICS_TIME, '%Y-%m-%d %H:%i:%s')) this_ where this_.SRC_APP_CODE=? and this_.DEST_OPERATION_CODE=? and this_.STATISTICS_TIME>=? order by this_.STATISTICS_TIME asc limit ?