Eu descobri, esta consulta obtém o tempo total gasto por dia:
SELECT visited_at, SUM(time_read * 60) AS total_user_secs FROM user_visits GROUP BY visited_at ORDER BY visited_at
Exemplo no meu fórum:
