Are there any useful data statistics plug-ins in the laravel framework?

the problem we are facing now:
opening the home page of the website requires statistics of a lot of tables, and each temporary summary will be very slow.
if you do a data statistics function alone, you will need a lot of extra workload and redundant data. Sometimes the demand changes quickly, and you have to modify the statistics, which is too troublesome.

Is there a good way to solve this problem? Does the laravel framework I use have laravel plug-ins or tools that break away from the laravel framework?


sql optimization, indexing, caching


this has nothing to do with the framework, mainly the optimization of the database, and those on the home page are simply put into redis and the like, do some job regularly throw in what you think you need, no matter how the requirements change, the rest is just to organize the data, of course, the cache is also divided into primary cache, secondary cache and so on. The system is not complex and cannot be used


first of all, the home page data should be written to the cache, even for 1 minute, you don't have to be slow to open it every time. Secondly, you should use software such as xhprof to analyze your code and find the most time-consuming place to optimize

.
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1be9938-319ad.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1be9938-319ad.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?