diff options
| author | wangwei <[email protected]> | 2018-12-20 15:52:52 +0800 |
|---|---|---|
| committer | wangwei <[email protected]> | 2018-12-20 15:52:52 +0800 |
| commit | 5d9ca02dda6e9d705da07a40c69d0b900cf249c9 (patch) | |
| tree | e162300de9436b975bde6ef7ce4a799f2790a9a4 | |
| parent | 257633a80cb1c1ae04a32f2fe7434db78623d07b (diff) | |
修正互联网流量最近数据时间查询（使用传输层流量进行统计）
| -rw-r--r-- | src/main/resources/mybatis/mapper/NetflowTopNMapper.xml | 11 |
1 files changed, 10 insertions, 1 deletions
diff --git a/src/main/resources/mybatis/mapper/NetflowTopNMapper.xml b/src/main/resources/mybatis/mapper/NetflowTopNMapper.xml index 3a0e4fc..4806681 100644 --- a/src/main/resources/mybatis/mapper/NetflowTopNMapper.xml +++ b/src/main/resources/mybatis/mapper/NetflowTopNMapper.xml @@ -82,7 +82,7 @@ ]]> </select> <!--时间：1小时内互联网流量TOP10--> - <select id="getNetFlowWaterTop10LastTime" resultType="java.util.Date"> + <select id="getNetFlowWaterTop10LastTime_old" resultType="java.util.Date"> <![CDATA[ SELECT RECV_TIME FROM traffic_netflow_port_info @@ -91,4 +91,13 @@ LIMIT 1 ]]> </select> + <select id="getNetFlowWaterTop10LastTime" resultType="java.util.Date"> + <![CDATA[ + SELECT stat_time + FROM traffic_trans_statistic + WHERE stat_time < #{end} + ORDER BY stat_time DESC + LIMIT 1 + ]]> + </select> </mapper>
\ No newline at end of file |