Paging @Gummibeer Laravel guru. I know we have a few other Laravel pros here but can’t remember names. 😇
If nobody gets back to you on this thread may be worth making a new one specifically about slow laravel queries.
Search for MySQL slow query log. It will slow your DB more down but logs you EVERY slow query. There's also a tool, forgot the name, that analyses the log and gives recommendation to improve - add/remove indices, split queries and so on.
Some general things:
Laravel queries (MySQL at all) gets slow with joins, n+1 queries and really large result sets.
Ideas to fix: check if you can use subqueries instead of joins. Use eager loading instead of n+1 loading, paginate in DB not PHP.
You should also check if you Aggregate any values that you can store in cache/redis.
Deep relation loading via too complex accessors/mutators is a very common issue.
If you have any code or query I can try to help with more detailed recommendations.