XF 2.2 problem with thousands of database queries

[albertc.s]

Hi guys
I am trying to fix a problem since it seems that xenforo queries my database more than 30k for each query.
It seems that it is from some search engine in the forum, I have deactivated the search engines but it continues to make those queries.
I have spoken with my sysadmin, and he has provided me with the example code so that he can see what happens because he has told me that the problem comes from the forum, I don't know if it comes from a plugin, something wrongly configured, etc.
I leave the code here, I can't know which part of the forum it is from
If you can recognize which part of the forum or plugin it is, it would be perfect
any help is welcome to lower the load level of the server.

ECT xf_thread.*
FROM xf_thread

WHERE (xf_thread.title LIKE '%Better%') AND (xf_thread.discussion_state = 'visible') AND (xf_thread.discussion_type <> 'redirect') AND (xf_thread.post_date >= 0) AND (xf_thread.thread_id <> 59283) AND (1) AND ((xf_thread.node_id = 32) OR (xf_thread.node_id = 33) OR (xf_thread.node_id = 21) OR (xf_thread.node_id = 77) OR (xf_thread.node_id = 37) OR (xf_thread.node_id = 58) OR (xf_thread.node_id = 49) OR (xf_thread.node_id = 57) OR (xf_thread.node_id = 73) OR (xf_thread.node_id = 50) OR (xf_thread.node_id = 51) OR (xf_thread.node_id = 23) OR (xf_thread.node_id = 78) OR (xf_thread.node_id = 79) OR (xf_thread.node_id = 71) OR (xf_thread.node_id = 3) OR (xf_thread.node_id = 83) OR (xf_thread.node_id = 4) OR (xf_thread.node_id = 5) OR (xf_thread.node_id = 43) OR (xf_thread.node_id = 7) OR (xf_thread.node_id = 29) OR (xf_thread.node_id = 38) OR (xf_thread.node_id = 6) OR (xf_thread.node_id = 13) OR (xf_thread.node_id = 41) OR (xf_thread.node_id = 42) OR (xf_thread.node_id = 44) OR (xf_thread.node_id = 39) OR (xf_thread.node_id = 20) OR (xf_thread.node_id = 40) OR (xf_thread.node_id = 31) OR (xf_thread.node_id = 54) OR (xf_thread.node_id = 55) OR (xf_thread.node_id = 8) OR (xf_thread.node_id = 82) OR (xf_thread.node_id = 81) OR (xf_thread.node_id = 68))
ORDER BY xf_thread.post_date DESC

LIMIT 10 | 0.000 |
| 573415907 | forum_asgfhstdftghdf | localhost | forum_uetygfhfgdhfgsda | Execute | 0 | Sending data | SELECT xf_thread.*
FROM xf_thread

WHERE (xf_thread.title LIKE '%Better%') AND (xf_thread.title LIKE '%les%') AND (xf_thread.discussion_state = 'visible') AND (xf_thread.discussion_type <> 'redirect') AND (xf_thread.post_date >= 0) AND (xf_thread.thread_id <> 12620) AND (1) AND ((xf_thread.node_id = 32) OR (xf_thread.node_id = 33) OR (xf_thread.node_id = 21) OR (xf_thread.node_id = 77) OR (xf_thread.node_id = 37) OR (xf_thread.node_id = 58) OR (xf_thread.node_id = 49) OR (xf_thread.node_id = 57) OR (xf_thread.node_id = 73) OR (xf_thread.node_id = 50) OR (xf_thread.node_id = 51) OR (xf_thread.node_id = 23) OR (xf_thread.node_id = 78) OR (xf_thread.node_id = 79) OR (xf_thread.node_id = 71) OR (xf_thread.node_id = 3) OR (xf_thread.node_id = 83) OR (xf_thread.node_id = 4) OR (xf_thread.node_id = 5) OR (xf_thread.node_id = 43) OR (xf_thread.node_id = 7) OR (xf_thread.node_id = 29) OR (xf_thread.node_id = 38) OR (xf_thread.node_id = 6) OR (xf_thread.node_id = 13) OR (xf_thread.node_id = 41) OR (xf_thread.node_id = 42) OR (xf_thread.node_id = 44) OR (xf_thread.node_id = 39) OR (xf_thread.node_id = 20) OR (xf_thread.node_id = 40) OR (xf_thread.node_id = 31) OR (xf_thread.node_id = 54) OR (xf_thread.node_id = 55) OR (xf_thread.node_id = 8) OR (xf_thread.node_id = 82) OR (xf_thread.node_id = 81) OR (xf_thread.node_id = 68))
ORDER BY xf_thread.post_date DESC

LIMIT 10 | 0.000 |
| 573415934 | forum_asgfhstdftghdf | localhost | forum_uetygfhfgdhfgsda | Execute | 0 | Sending data | SELECT xf_thread.*
FROM xf_thread

WHERE (xf_thread.title LIKE '%man%') AND (xf_thread.title LIKE '%player%') AND (xf_thread.title LIKE '%better%') AND (xf_thread.discussion_state = 'visible') AND (xf_thread.discussion_type <> 'redirect') AND (xf_thread.post_date >= 0) AND (xf_thread.thread_id <> 54490) AND ((xf_thread.node_id = 32) OR (xf_thread.node_id = 33) OR (xf_thread.node_id = 21) OR (xf_thread.node_id = 77) OR (xf_thread.node_id = 37) OR (xf_thread.node_id = 58) OR (xf_thread.node_id = 49) OR (xf_thread.node_id = 57) OR (xf_thread.node_id = 73) OR (xf_thread.node_id = 50) OR (xf_thread.node_id = 51) OR (xf_thread.node_id = 23) OR (xf_thread.node_id = 78) OR (xf_thread.node_id = 79) OR (xf_thread.node_id = 71) OR (xf_thread.node_id = 3) OR (xf_thread.node_id = 83) OR (xf_thread.node_id = 4) OR (xf_thread.node_id = 5) OR (xf_thread.node_id = 43) OR (xf_thread.node_id = 7) OR (xf_thread.node_id = 29) OR (xf_thread.node_id = 38) OR (xf_thread.node_id = 6) OR (xf_thread.node_id = 13) OR (xf_thread.node_id = 41) OR (xf_thread.node_id = 42) OR (xf_thread.node_id = 44) OR (xf_thread.node_id = 39) OR (xf_thread.node_id = 20) OR (xf_thread.node_id = 40) OR (xf_thread.node_id = 31) OR (xf_thread.node_id = 54) OR (xf_thread.node_id = 55) OR (xf_thread.node_id = 8) OR (xf_thread.node_id = 82) OR (xf_thread.node_id = 81) OR (xf_thread.node_id = 68))
ORDER BY xf_thread.post_date DESC

 

[Kier]

At first glance, I’d say that this doesn’t look like core XenForo code, though I could be wrong - what add-ons do you have installed?

 

[albertc.s]

At first glance, I’d say that this doesn’t look like core XenForo code, though I could be wrong - what add-ons do you have installed?

I have around 8 add-ons but how can i identificate?

 

[Kier]

A screen-grab of your installed add-ons list from the admin control panel would suffice (admin.php?add-ons/)

 

[albertc.s]

A screen-grab of your installed add-ons list from the admin control panel would suffice (admin.php?add-ons/)

yes you can see

 

[Chris D]

Yeah this doesn't look like a query XF would run.

It seems to me like it would be a similar threads type add-on, it seems like you have one installed called Similar Threads.

You mentioned that you had 8 add-ons installed but from the screenshots you've provided it looks like it's actually 29 (although some are disabled).

We'd recommend you disable all of those and enable them one by one to see which the culprit is.

 

[albertc.s]

Yeah this doesn't look like a query XF would run.

It seems to me like it would be a similar threads type add-on, it seems like you have one installed called Similar Threads.

You mentioned that you had 8 add-ons installed but from the screenshots you've provided it looks like it's actually 29 (although some are disabled).

We'd recommend you disable all of those and enable them one by one to see which the culprit is.

ok I will do
thanks