Query Causing Site to Hang

[ad_1]

Our site seems to hang once in a while. The host says it because of a particular query but we can’t track down what is calling the query.

Here’s the query:

SELECT user\_id, meta\_key, meta\_value FROM wp\_usermeta WHERE user\_id IN (14870,14901,14880,14919,…,14896) ORDER BY umeta\_id ASC;

The user\_id list in parentheses is around 120,000+ IDs.

Any idea of what could be doing this or how we can go about finding what’s making these calls?

[ad_2]