How to collect data for statistics?

Question

Laravel

There is a table of visits:

1. Full name
   
2. date and time
   

You need to pull out the number of visits for: today, yesterday, etc.
The problem is that the only known way to do this is to pull out all the records using whereDate(), and count the number of records in the controller using count. It seems to me that this is not entirely correct, and with large amounts of data, there will be delays.

Answer 1

https://stackoverflow.com/questions/18533080/larav...