MySQL查询按日期范围对结果进行分组？

I got a system that pings to the database every 2 to 5 seconds when he is connected the application. Depending on his connection, the ping timeframe can be bigger, like 10 seconds or so.I got a system that pings to the database every