JavaScript-Multi-Table association query statement in inside a huge array of user IDs resulting in query time is too long how to optimize?

A large array of user IDs in inside a multi-table association query statement causes the query time to be too long how to optimize?

1, query statements such as, the execution time is 147.4ms.

Reply content:

A large array of user IDs in inside a multi-table association query statement causes the query time to be too long how to optimize?

1, query statements such as, the execution time is 147.4ms.

WHERE id IN (1,2,3)EquivalentWHERE id = 1 OR id = 2 OR id =3
If the or condition is so many, it is normal to have index slow on the ID.

The root of this problem is that the structure of the table is unreasonable, and the optimization of the query is not a cure.
So don't be too worried when you design the structure.
In addition, multi-use explain

