XF 2.1 Detecting Troublesome Query

[RoyalRumble]

Hello,

Our host has identified a query that's causing a problem with performance - it's below.

Any chance any kind soul can tell us what its from? Add-ons list below.

You seem to have a particular query causing the problem. Any ideas which one it is?

SELECT COUNT(*) FROM `xf_post`  WHERE (`xf_post`.`thread_id` = 104365) AND ((`xf_post`.`message_state` IN ('visible'))) AND ((`xf_post`.`message_state` IN ('visible'))) AND (`xf_post`.`user_id` = 10524) AND (`xf_post`.`position` < 21217);

 

[PatM]

I think it's from Signature Once add-on.

 

[Deebs]

Correct. I have been testing my XF 2 upgrade and this addon kills performance on threads with thousands of posts due to this query.