vBulletin

Datastore Setup

SQL Query

SELECT *
FROM datastore
WHERE title IN ('navdata','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream','routes')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	datastore	range	PRIMARY	PRIMARY	52		16	Using where

Time Before: 0.00875 seconds
Time After: 0.01177 seconds
Time Taken: 0.00302 seconds

Memory Before: 550.047 KB
Memory After: 550.898 KB
Memory Used: 0.852 KB

Time Before: 0.00802 seconds
Time After: 0.01412 seconds
Time Taken: 0.00610 seconds

Memory Before: 546.969 KB
Memory After: 1,257.938 KB
Memory Used: 710.969 KB

Session Handling

SQL Query

SELECT *
FROM session
WHERE userid = 0
	AND host = '192.168.0.1'
	AND idhash = 'ce294c5626a6c3c128594a952859491f'
LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	session	ref	idhash,host,userid,guest_lookup,user_activity	idhash	32	const	2	Using where

Time Before: 0.01636 seconds
Time After: 0.01669 seconds
Time Taken: 0.00034 seconds

Memory Before: 1,752.977 KB
Memory After: 1,753.430 KB
Memory Used: 0.453 KB

SQL Query

SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_user AS phrasegroup_user,
			phrasegroup_search AS phrasegroup_search,
			phrasegroup_cprofilefield AS phrasegroup_cprofilefield,
			phrasegroup_reputationlevel AS phrasegroup_reputationlevel,
			phrasegroupinfo AS lang_phrasegroupinfo,
			options AS lang_options,
			languagecode AS lang_code,
			charset AS lang_charset,
			locale AS lang_locale,
			imagesoverride AS lang_imagesoverride,
			dateoverride AS lang_dateoverride,
			timeoverride AS lang_timeoverride,
			registereddateoverride AS lang_registereddateoverride,
			calformat1override AS lang_calformat1override,
			calformat2override AS lang_calformat2override,
			logdateoverride AS lang_logdateoverride,
			decimalsep AS lang_decimalsep,
			thousandsep AS lang_thousandsep
FROM language
WHERE languageid = 3

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	language	system	PRIMARY				1

Time Before: 0.01977 seconds
Time After: 0.02270 seconds
Time Taken: 0.00293 seconds

Memory Before: 1,766.313 KB
Memory After: 1,766.227 KB
Memory Used: -0.086 KB

Time Before: 0.01575 seconds
Time After: 0.02297 seconds
Time Taken: 0.00722 seconds

Memory Before: 1,745.125 KB
Memory After: 1,858.484 KB
Memory Used: 113.359 KB

SQL Query

SELECT MAX(permissions & 1) AS perm
FROM cms_permissions
WHERE nodeid = 1 AND usergroupid IN (1)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cms_permissions	const	usergroupid,nodeid	usergroupid	8	const,const	1

Time Before: 0.03113 seconds
Time After: 0.03132 seconds
Time Taken: 0.00018 seconds

Memory Before: 2,330.633 KB
Memory After: 2,331.148 KB
Memory Used: 0.516 KB

SQL Query

SELECT *
FROM style
WHERE (styleid = 5 AND userselect = 1)
	OR styleid = 5
ORDER BY styleid ASC
LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	style	const	PRIMARY	PRIMARY	2	const	1

Time Before: 0.03482 seconds
Time After: 0.03606 seconds
Time Taken: 0.00125 seconds

Memory Before: 2,418.938 KB
Memory After: 2,419.531 KB
Memory Used: 0.594 KB

SQL Query

SELECT profilefieldid, type, data, optional, memberlist, searchable
FROM profilefield
WHERE form = 0 
ORDER BY displayorder

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	profilefield	ALL					25	Using where; Using filesort

Time Before: 0.04294 seconds
Time After: 0.04347 seconds
Time Taken: 0.00053 seconds

Memory Before: 3,134.531 KB
Memory After: 3,136.367 KB
Memory Used: 1.836 KB

SQL Query

SELECT COUNT(*) AS users
FROM user AS user


WHERE 1=1
	AND (user.usergroupid IN (-1,6,11,14,17,16,7,13,9,15,2,10,5,12))

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	user	range	usergroupid	usergroupid	2		147550	Using where; Using index

Time Before: 0.04491 seconds
Time After: 0.09721 seconds
Time Taken: 0.05229 seconds

Memory Before: 3,178.281 KB
Memory After: 3,178.766 KB
Memory Used: 0.484 KB

SQL Query

SELECT title, template
FROM template
WHERE templateid IN (61914,61916,61918,61917,61860,61861,61863,61869,61868,61840,55071,57273,57295,62316,0,0,6082,38961,42855,57213,38966,57292,5992,38968,38969,57230,62031,62305,45486,61981,53288,61979,61980,62335,0,0,62315,62276,62001,62002,62004,62005,62228,62347,62329,62279,62280,61828,61827,61831,61391,61659)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	template	range	PRIMARY	PRIMARY	4		49	Using where

Time Before: 0.09953 seconds
Time After: 0.10140 seconds
Time Taken: 0.00187 seconds

Memory Before: 3,446.828 KB
Memory After: 3,448.203 KB
Memory Used: 1.375 KB

SQL Query

SELECT user.*,usertextfield.*,userfield.*, user.userid, options,
	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
,IF((NOT(options & 1024) AND (user.usergroupid IN (-1,6,11,14,17,16,7,13,9,15,2,10,5,12) OR FIND_IN_SET('6', membergroupids) OR FIND_IN_SET('11', membergroupids) OR FIND_IN_SET('14', membergroupids) OR FIND_IN_SET('17', membergroupids) OR FIND_IN_SET('16', membergroupids) OR FIND_IN_SET('7', membergroupids) OR FIND_IN_SET('13', membergroupids) OR FIND_IN_SET('9', membergroupids) OR FIND_IN_SET('15', membergroupids) OR FIND_IN_SET('2', membergroupids) OR FIND_IN_SET('10', membergroupids) OR FIND_IN_SET('5', membergroupids) OR FIND_IN_SET('12', membergroupids))), 0, reputation) AS reputationscore
,avatar.avatarpath,NOT ISNULL(customavatar.userid) AS hascustomavatar,customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight

 , IF((options & 512 AND user.userid <> 0), 0, lastactivity) AS lastvisittime 
, IF(YEAR(user.birthday_search) > 0 AND user.showbirthday IN (1,2) AND YEAR(user.birthday_search) < YEAR(CURDATE()), user.birthday_search, '1000-01-01') AS agesort


FROM user AS user
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid=user.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid=user.userid)
LEFT JOIN reputationlevel AS reputationlevel ON(user.reputationlevelid=reputationlevel.reputationlevelid) 
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)



WHERE 1=1
	AND (user.usergroupid IN (-1,6,11,14,17,16,7,13,9,15,2,10,5,12))
	
ORDER BY user.username asc 
LIMIT 100, 100

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	avatar	system	PRIMARY				0	const row not found
1	SIMPLE	customavatar	system	PRIMARY				0	const row not found
1	SIMPLE	user	index	usergroupid	username	102		200	Using where
1	SIMPLE	usertextfield	eq_ref	PRIMARY	PRIMARY	4	cmnt.user.userid	1
1	SIMPLE	userfield	eq_ref	PRIMARY	PRIMARY	4	cmnt.user.userid	1
1	SIMPLE	reputationlevel	eq_ref	PRIMARY	PRIMARY	4	cmnt.user.reputationlevelid	1	Using index

Time Before: 0.11492 seconds
Time After: 0.12248 seconds
Time Taken: 0.00756 seconds

Memory Before: 3,589.070 KB
Memory After: 3,689.516 KB
Memory Used: 100.445 KB

SQL Query

INSERT IGNORE INTO session
	(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate, apiclientid, apiaccesstoken)
VALUES
	('b910b85238c3231bdc641e11d90490dd', 0, '192.168.0.1', 'ce294c5626a6c3c128594a952859491f', 1784693609, '/forums/memberlist.php?explain=1&page=2', 0, 0, 0, 0, 0, 0, 0, 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 0, 0, 0, '')

Time Before: 0.33760 seconds
Time After: 0.33804 seconds
Time Taken: 0.00044 seconds

Memory Before: 8,156.102 KB
Memory After: 8,155.977 KB
Memory Used: -0.125 KB