Should I create an index on a timestamp?

Question

MySQL

Hello everyone, I came across that a seemingly simple request is being executed for a long time. I understood the reason - these are the conditions in inner joins, and here the question has matured whether it makes sense to create an index on a timestamp? (I use soft delete in laravel)

Below I gave 2 examples and execution time



The only difference is that I removed the condition in the last inner join'e