How to get rid of join() completely?

Question

SQL

After QueryBuilder becomes useless, and there are more than 25+ users per table , what to do? How to be? How to get rid of all joins and speed up fetches?

Answer 1

The number of joins is not at all an indicator of the badness / goodness of the request.
Long query execution time and consumed resources - this may be the reason.

Answer 2

as in Laravel - replace joins with select .... where .... in
but according to your mind - you need to optimize the table structure

Answer 3

I correctly understood that you have a JOIN with 25 other tables?
By chance, not in order to find out everything about the current user?