Query in my slow query log

[mindhunter77]

Is there a way to optimize this at all? This one keeps showing up in my slow query log over and over again.

# Query_time: 5  Lock_time: 0  Rows_sent: 25  Rows_examined: 43681
SELECT *,
IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid
 FROM vbuser WHERE usergroupid = '2' ORDER BY RAND() LIMIT 25;

[Marco van Herwaarden]

That doesn't seem to be a default vB query. I suggest you contact the author of the modification that uses this query.

[mindhunter77]

any idea how to track down what mod may be using it ?

[Lynne]

Do a search through your plugins (there is a mod that allows you to do this).

[mindhunter77]

I ok, I looked through the search and came up with no mods, do you remember the name, or maybe a search word I could use to try and find it lol..

[Lynne]

<a href="https://vborg.vbsupport.ru/showthread.php?t=203933" target="_blank">Search the plugincode</a>

[mindhunter77]

Thanks Lynne!