我明白了,这个查询可以获取每天花费的总时间:
SELECT visited_at, SUM(time_read * 60) AS total_user_secs FROM user_visits GROUP BY visited_at ORDER BY visited_at
我在论坛中的示例: