修正网络流量监控查询sql

1 files changed, 2 insertions, 0 deletions

diff --git a/src/main/resources/mybatis/mapper/MonitorMapper.xml b/src/main/resources/mybatis/mapper/MonitorMapper.xml
index be2edfc..0fe6b16 100644
--- a/src/main/resources/mybatis/mapper/MonitorMapper.xml
+++ b/src/main/resources/mybatis/mapper/MonitorMapper.xml
@@ -35,11 +35,13 @@
         FROM traffic_trans_statistic
         where stat_time >= #{start}
             and stat_time < #{end}
+        group by area
 	    UNION ALL
         SELECT entrance_id AS area,'IN' AS type,ifnull(c2s_byte_len,0) AS count,#{push} AS time
         FROM traffic_trans_statistic
         where stat_time >= #{start}
             and stat_time < #{end}
+        group by area
         ]]>
     </select>
     <!--时间:网络流量监控_5min-->