如何使用纪元和mysql每小时进行计数？

[ID] [Time(epoch time)]

select from_unixtime(visittime,\'%H\') as h,count(*) as total
from table
where from_unixtime(visittime) >= now() - interval 1 day
group by h