XF 2.1 xf_user_profile_Profile_1 and xf_user_privacy_Privacy_2 slow

[m1ne]

MySQL slow query log has been getting hammered by this for a while, also using an entire cpu thread non-stop. Any idea how to find the issue? Addon maybe?

# Query_time: 15.766250 Lock_time: 0.000022 Rows_sent: 2000 Rows_examined: 12000
# Rows_affected: 0 Bytes_sent: 948118
SET timestamp=1569459469;
SELECT xf_user., xf_user_profile_Profile_1., xf_user_privacy_Privacy_2.*
FROM xf_user
LEFT JOIN xf_user_profile AS xf_user_profile_Profile_1 ON (xf_user_profile_Profile_1.user_id = xf_user.user_id)
LEFT JOIN xf_user_privacy AS xf_user_privacy_Privacy_2 ON (xf_user_privacy_Privacy_2.user_id = xf_user.user_id)
WHERE (xf_user.user_id IN (3530, 3531, 3532, 3533, 3534, 3535, 3536, 3537, 3538, 3539, 3540, 3541, 3542, 3543, 3544, 3545, 3546, 3547, 3548, 3549, 355$
ORDER BY xf_user.user_id ASC;

 

[Dretax]

MySQL slow query log has been getting hammered by this for a while, also using an entire cpu thread non-stop. Any idea how to find the issue? Addon maybe?

# Query_time: 15.766250 Lock_time: 0.000022 Rows_sent: 2000 Rows_examined: 12000
# Rows_affected: 0 Bytes_sent: 948118
SET timestamp=1569459469;
SELECT xf_user., xf_user_profile_Profile_1., xf_user_privacy_Privacy_2.*
FROM xf_user
LEFT JOIN xf_user_profile AS xf_user_profile_Profile_1 ON (xf_user_profile_Profile_1.user_id = xf_user.user_id)
LEFT JOIN xf_user_privacy AS xf_user_privacy_Privacy_2 ON (xf_user_privacy_Privacy_2.user_id = xf_user.user_id)
WHERE (xf_user.user_id IN (3530, 3531, 3532, 3533, 3534, 3535, 3536, 3537, 3538, 3539, 3540, 3541, 3542, 3543, 3544, 3545, 3546, 3547, 3548, 3549, 355$
ORDER BY xf_user.user_id ASC;

I am actually having the same issue on one of my xenforo sites. Have you found any solutions to this?