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; |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|