vBulletin

Datastore Setup

SQL Query

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	datastore	range	PRIMARY	PRIMARY	52		14	Using index condition

Time Before: 0.01156 seconds
Time After: 0.01331 seconds
Time Taken: 0.00175 seconds

Memory Before: 1,958.375 KB
Memory After: 2,004.789 KB
Memory Used: 46.414 KB

Time Before: 0.01037 seconds
Time After: 0.01716 seconds
Time Taken: 0.00679 seconds

Memory Before: 1,954.977 KB
Memory After: 3,448.969 KB
Memory Used: 1,493.992 KB

SQL Query

SELECT *
FROM datastore
WHERE title IN ('ehdaa_userban','ehdaa')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	datastore	range	PRIMARY	PRIMARY	52		2	Using index condition

Time Before: 0.01915 seconds
Time After: 0.01969 seconds
Time Taken: 0.00054 seconds

Memory Before: 3,473.922 KB
Memory After: 3,476.430 KB
Memory Used: 2.508 KB

Session Handling

SQL Query

SELECT *
FROM session
WHERE userid = 0
	AND host = '216.73.216.51'
	AND idhash = 'ea5a359a73a8141a16de516480d33c34'
LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	session	ALL					190	Using where

Time Before: 0.02091 seconds
Time After: 0.02128 seconds
Time Taken: 0.00037 seconds

Memory Before: 3,499.250 KB
Memory After: 3,504.773 KB
Memory Used: 5.523 KB

SQL Query

SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_fronthelp AS phrasegroup_fronthelp,
			phrasegroup_register AS phrasegroup_register,
			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 = 2

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

Time Before: 0.02256 seconds
Time After: 0.02338 seconds
Time Taken: 0.00082 seconds

Memory Before: 3,510.227 KB
Memory After: 3,515.633 KB
Memory Used: 5.406 KB

Time Before: 0.01993 seconds
Time After: 0.02352 seconds
Time Taken: 0.00360 seconds

Memory Before: 3,494.477 KB
Memory After: 3,571.227 KB
Memory Used: 76.750 KB

SQL Query

SELECT IF(visible = 2, 1, 0) AS isdeleted,



thread.*


FROM thread AS thread






WHERE thread.threadid = 8148

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	thread	const	PRIMARY	PRIMARY	4	const	1

Time Before: 0.02597 seconds
Time After: 0.02628 seconds
Time Taken: 0.00031 seconds

Memory Before: 3,672.898 KB
Memory After: 3,683.594 KB
Memory Used: 10.695 KB

SQL Query

SELECT *
FROM style
WHERE (styleid = 72 AND userselect = 1)
	OR styleid = 72
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.02723 seconds
Time After: 0.02769 seconds
Time Taken: 0.00046 seconds

Memory Before: 3,689.078 KB
Memory After: 3,693.570 KB
Memory Used: 4.492 KB

SQL Query

SELECT title, template
FROM template
WHERE templateid IN (5571,5572,6838,6856,5592,5095,5094,5096,5091,5090,5367,5006,5319,5320,5321,5587,5590,5599,5340,5341,5342,5343,5541,5604,5603,5605,5608,4697,4702,4701,4703,4705,4684,4675,4676,4680,4683,4681,4677,4673,4682,4685,4686,4678,4674,4687,4679,4644,4645,4656,4669,4670,3211,4503,0,4504,4506,6848,6850,6849,4689,4690,4698,4699,4700,6034,6038,6037,6036,6035,6032,6031,5159,5160,5161,5162,5163,5164,5166,5329,5167,5177,6033,6039,6208,6210,6209,6211)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	template	range	PRIMARY	PRIMARY	4		88	Using index condition

Time Before: 0.02944 seconds
Time After: 0.03113 seconds
Time Taken: 0.00169 seconds

Memory Before: 3,912.734 KB
Memory After: 3,916.555 KB
Memory Used: 3.820 KB

SQL Query

SELECT threadid, title, lastpost, forumid, dateline, visible
FROM thread AS thread
WHERE NOT ISNULL(threadid)  AND visible = '1'
ORDER BY dateline DESC LIMIT 0, 5

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	thread	index	PRIMARY	dateline	4		5	Using where

Time Before: 0.07717 seconds
Time After: 0.07737 seconds
Time Taken: 0.00020 seconds

Memory Before: 4,976.172 KB
Memory After: 4,979.445 KB
Memory Used: 3.273 KB

SQL Query

SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, joindate, posts
FROM user AS user
WHERE userid > '0' 
ORDER BY joindate DESC LIMIT 0, 5

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	user	index	PRIMARY	joindate	4		5	Using where

Time Before: 0.07829 seconds
Time After: 0.07852 seconds
Time Taken: 0.00023 seconds

Memory Before: 4,983.875 KB
Memory After: 4,987.047 KB
Memory Used: 3.172 KB

SQL Query

SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, posts
FROM user AS user
WHERE posts > '0' 
ORDER BY posts DESC LIMIT 0, 5

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

Time Before: 0.07954 seconds
Time After: 0.08192 seconds
Time Taken: 0.00237 seconds

Memory Before: 4,992.094 KB
Memory After: 4,995.016 KB
Memory Used: 2.922 KB

SQL Query

SELECT COUNT(*) AS refnumber, user.username, user.userid, user.usergroupid, user.referrerid
FROM user AS refs
LEFT JOIN user AS user ON (refs.referrerid = user.userid)
WHERE refs.referrerid > '0' 
GROUP BY refs.referrerid
ORDER BY refnumber DESC LIMIT 0, 5

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	refs	range	referrerid	referrerid	4		285	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	user	eq_ref	PRIMARY	PRIMARY	4	abotglb_vb368.refs.referrerid	1

Time Before: 0.08269 seconds
Time After: 0.08347 seconds
Time Taken: 0.00078 seconds

Memory Before: 4,999.852 KB
Memory After: 5,002.734 KB
Memory Used: 2.883 KB

SQL Query

SELECT threadid, title, forumid, dateline, IF(views<=replycount, replycount+1, views) AS views, visible
FROM thread AS thread
WHERE NOT ISNULL(threadid) AND visible = '1' AND views > '0' AND forumid NOT IN (63,8,24,25,53,88,47)
ORDER BY views DESC LIMIT 0, 5

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	thread	range	PRIMARY,forumid	forumid	2		10887	Using index condition; Using where; Using filesort

Time Before: 0.08417 seconds
Time After: 0.11089 seconds
Time Taken: 0.02673 seconds

Memory Before: 5,006.789 KB
Memory After: 5,009.898 KB
Memory Used: 3.109 KB

SQL Query

SELECT threadid, title, lastpost, forumid, replycount, dateline, visible
FROM thread AS thread
WHERE NOT ISNULL(threadid) AND visible = '1' AND replycount > '0' AND forumid NOT IN (63,8,24,25,53,88,47)
ORDER BY replycount DESC LIMIT 0, 5

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	thread	range	PRIMARY,forumid	forumid	2		10887	Using index condition; Using where; Using filesort

Time Before: 0.11198 seconds
Time After: 0.13399 seconds
Time Taken: 0.02201 seconds

Memory Before: 5,013.688 KB
Memory After: 5,017.156 KB
Memory Used: 3.469 KB

SQL Query

SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, thread.visible, user.username, user.userid, user.usergroupid, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM thread AS thread
LEFT JOIN user AS user ON (user.username = thread.lastposter) 
WHERE NOT ISNULL(thread.threadid) AND thread.visible = '1' AND thread.forumid NOT IN (63,8,24,25,53,88,47)
ORDER BY lastpost DESC LIMIT 0, 10

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	thread	index	PRIMARY,forumid	lastpost	6		10	Using where
1	SIMPLE	user	ref	username	username	102	abotglb_vb368.thread.lastposter	1

Time Before: 0.13571 seconds
Time After: 0.13628 seconds
Time Taken: 0.00056 seconds

Memory Before: 5,022.273 KB
Memory After: 5,027.477 KB
Memory Used: 5.203 KB

SQL Query

SELECT *
FROM bbcode

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

Time Before: 0.14701 seconds
Time After: 0.14729 seconds
Time Taken: 0.00027 seconds

Memory Before: 5,564.766 KB
Memory After: 5,568.734 KB
Memory Used: 3.969 KB

SQL Query

SELECT *, LENGTH(smilietext) AS smilielen
FROM smilie
ORDER BY smilielen DESC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	smilie	ALL					80	Using filesort

Time Before: 0.14808 seconds
Time After: 0.14872 seconds
Time Taken: 0.00064 seconds

Memory Before: 5,583.242 KB
Memory After: 5,591.563 KB
Memory Used: 8.320 KB

SQL Query

SELECT userip
FROM cybvilxh_guests AS cybvilxh_guests
WHERE userip = '216.73.216.51'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cybvilxh_guests	ALL					1087	Using where

Time Before: 0.16426 seconds
Time After: 0.16508 seconds
Time Taken: 0.00081 seconds

Memory Before: 5,724.180 KB
Memory After: 5,726.180 KB
Memory Used: 2.000 KB

SQL Query

UPDATE cybvilxh_guests
SET dateline = '1759583035'
WHERE userip = '216.73.216.51'

Time Before: 0.16514 seconds
Time After: 0.17149 seconds
Time Taken: 0.00635 seconds

Memory Before: 5,726.336 KB
Memory After: 5,726.703 KB
Memory Used: 0.367 KB

SQL Query

DELETE FROM cybvilxh_guests WHERE dateline < '1759323835'

Time Before: 0.17155 seconds
Time After: 0.17233 seconds
Time Taken: 0.00078 seconds

Memory Before: 5,724.016 KB
Memory After: 5,724.305 KB
Memory Used: 0.289 KB

SQL Query

SELECT COUNT(postid) AS posts,
post.username AS postuser,user.userid,user.username
FROM post AS post
LEFT JOIN user AS user USING(userid)
WHERE threadid = 8148
	AND visible = 1
GROUP BY userid
ORDER BY posts DESC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	post	ref	threadid,threadid_2	threadid	4	const	5	Using where; Using temporary; Using filesort
1	SIMPLE	user	eq_ref	PRIMARY	PRIMARY	4	abotglb_vb368.post.userid	1

Time Before: 0.17738 seconds
Time After: 0.17788 seconds
Time Taken: 0.00050 seconds

Memory Before: 5,426.789 KB
Memory After: 5,429.430 KB
Memory Used: 2.641 KB

SQL Query

SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount, lastpostid, lastprefixid
	
FROM forum AS forum

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	forum	ALL					108

Time Before: 0.17993 seconds
Time After: 0.18025 seconds
Time Taken: 0.00032 seconds

Memory Before: 5,733.031 KB
Memory After: 5,746.227 KB
Memory Used: 13.195 KB

SQL Query

UPDATE session
SET location = '/vb/misc.php?do=whoposted&explain=1&t=8148', inthread = 8148, incalendar = 0, badlocation = 0, useragent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
WHERE sessionhash = '22cf1542b6754fc99cb18dd2586cf524'

Time Before: 0.18142 seconds
Time After: 0.18166 seconds
Time Taken: 0.00025 seconds

Memory Before: 5,919.359 KB
Memory After: 5,919.516 KB
Memory Used: 0.156 KB