What is the best way to implement the output of popular posts in 24 hours?

Question

MySQL

The popularity of a post is determined by the number of views it has.
It is necessary to display it with a sliding window for 24 hours.

Answer 1

Well ... like in science fiction films, apparently. You need to say in a voice: "Base, bring me popular entries in 24 hours." If the base is American, it's better to speak English, I think.

Answer 2

Look towards Sorted sets Redis.

Answer 3

Or simplify the task and throw out the concept of "floating", then this is a simple sorted set out of the box.
Otherwise, for each post, as an option, create a list and store each access time in it.
When viewing, read the entire list, from the end or beginning (how to store) delete everything that is more than 24 hours. The length of list will be a valid number of views over a floating 24 hours. But with a lot of views and a lot of posts, this option is most likely not very attractive.