fix in num,add sql index,change every 1s to every 10s

liuxiaolong

2019-05-23 86b189ee9072db4bf2648c16307eff1da077e8e4

 src/main/java/com/cloud/count/dao/CountDao.java

@@ -23,8 +23,8 @@
     * @return
     */
//    @Select("select COALESCE(sum(enters),0) from people where  timestamp BETWEEN #{begin} AND #{end}")
    @Select("SELECT COALESCE(p2.enters-p1.enters,0) FROM (SELECT enters from people where  timestamp BETWEEN #{begin} AND #{end} ORDER BY id ASC LIMIT 1)p1,(SELECT enters from people where  timestamp BETWEEN #{begin} AND #{end} ORDER BY id DESC LIMIT 1)p2")
    Integer countInPeople(@Param("begin") long begin,@Param("end") long end);
    @Select("SELECT COALESCE(p2.enters-p1.enters,0) FROM (SELECT enters from people where dateStr=#{todayStr} and timestamp BETWEEN #{begin} AND #{end} ORDER BY id ASC LIMIT 1)p1,(SELECT enters from people where dateStr=#{todayStr} and timestamp BETWEEN #{begin} AND #{end} ORDER BY id DESC LIMIT 1)p2")
    Integer countInPeople(@Param("begin") long begin,@Param("end") long end,@Param("todayStr") String todayStr);

    /**
     * 统计出去人数
@@ -32,8 +32,8 @@
     * @return
     */
   // @Select("select COALESCE(sum(exits),0) from people where timestamp BETWEEN #{begin} AND #{end}")
    @Select("SELECT COALESCE(p2.exits-p1.exits,0) FROM (SELECT exits from people where  timestamp BETWEEN #{begin} AND #{end} ORDER BY id ASC LIMIT 1)p1,(SELECT exits from people where  timestamp BETWEEN #{begin} AND #{end} ORDER BY id DESC LIMIT 1)p2")
    Integer countOutPeople( @Param("begin") long begin,@Param("end") long end);
    @Select("SELECT COALESCE(p2.exits-p1.exits,0) FROM (SELECT exits from people where dateStr=#{todayStr} and timestamp BETWEEN #{begin} AND #{end} ORDER BY id ASC LIMIT 1)p1,(SELECT exits from people where dateStr=#{todayStr} and timestamp BETWEEN #{begin} AND #{end} ORDER BY id DESC LIMIT 1)p2")
    Integer countOutPeople( @Param("begin") long begin,@Param("end") long end,@Param("todayStr") String todayStr);

    /**
     * 插入一条People数据