The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Query in my slow query log
Is there a way to optimize this at all? This one keeps showing up in my slow query log over and over again.
Code:
# 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; |
#2
|
|||
|
|||
That doesn't seem to be a default vB query. I suggest you contact the author of the modification that uses this query.
|
#3
|
|||
|
|||
any idea how to track down what mod may be using it ?
|
#4
|
||||
|
||||
Do a search through your plugins (there is a mod that allows you to do this).
|
#5
|
|||
|
|||
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..
|
#6
|
||||
|
||||
<a href="https://vborg.vbsupport.ru/showthread.php?t=203933" target="_blank">Search the plugincode</a>
|
#7
|
|||
|
|||
Thanks Lynne!
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|