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?