vBulletin

Datastore Setup

SQL Query

SELECT *
FROM vb_datastore
WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','userstats','birthdaycache','maxloggedin','iconcache','eventcache','mailqueue')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	vb_datastore	ALL	PRIMARY				22	Using where

Time Before: 0.05813 seconds
Time After: 0.05911 seconds
Time Taken: 0.00098 seconds

Memory Before: 1,810.875 KB
Memory After: 1,810.723 KB
Memory Used: -0.152 KB

Time Before: 0.05671 seconds
Time After: 0.06175 seconds
Time Taken: 0.00504 seconds

Memory Before: 1,806.617 KB
Memory After: 1,927.027 KB
Memory Used: 120.410 KB

Session Handling

SQL Query

SELECT *
FROM vb_session
WHERE sessionhash = '08bffa6beb92d08f149e8eabe6f44fa9'
	AND lastactivity > 1283994119
	AND idhash = 'd0b63444099757fedc3d79aa837e804c'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	vb_session	const	PRIMARY	PRIMARY	32	const	1

Time Before: 0.06879 seconds
Time After: 0.06956 seconds
Time Taken: 0.00076 seconds

Memory Before: 1,960.488 KB
Memory After: 1,960.395 KB
Memory Used: -0.094 KB

SQL Query

SELECT languageid,
			phrasegroup_holiday AS phrasegroup_holiday,
			phrasegroup_global AS phrasegroup_global,
			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 vb_language
WHERE languageid = 1

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

Time Before: 0.07241 seconds
Time After: 0.07282 seconds
Time Taken: 0.00041 seconds

Memory Before: 1,965.883 KB
Memory After: 1,965.375 KB
Memory Used: -0.508 KB

Time Before: 0.06749 seconds
Time After: 0.07332 seconds
Time Taken: 0.00583 seconds

Memory Before: 1,955.367 KB
Memory After: 1,991.293 KB
Memory Used: 35.926 KB

SQL Query

SELECT calendarpermission.usergroupid, calendarpermission.calendarpermissions,calendar.calendarid,calendar.title, displayorder
FROM vb_calendar AS calendar
LEFT JOIN vb_calendarpermission AS calendarpermission ON (calendarpermission.calendarid=calendar.calendarid AND usergroupid IN(1))
ORDER BY displayorder ASC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	calendar	system					1
1	SIMPLE	calendarpermission	system					0	const row not found

Time Before: 0.07765 seconds
Time After: 0.07783 seconds
Time Taken: 0.00019 seconds

Memory Before: 2,008.746 KB
Memory After: 2,008.547 KB
Memory Used: -0.199 KB

SQL Query

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

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

Time Before: 0.07964 seconds
Time After: 0.08000 seconds
Time Taken: 0.00036 seconds

Memory Before: 2,011.059 KB
Memory After: 2,011.156 KB
Memory Used: 0.098 KB

SQL Query

SELECT title, template
FROM vb_template
WHERE templateid IN (132,133,134,135,136,137,138,139,141,142,143,144,145,140,382,411,383,241,407,208,378,381,390,227,228,229,230,341,395,394,396,399)

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

Time Before: 0.08258 seconds
Time After: 0.08303 seconds
Time Taken: 0.00045 seconds

Memory Before: 2,060.477 KB
Memory After: 2,060.371 KB
Memory Used: -0.105 KB

SQL Query

SELECT
	user.username, (user.options & 512) AS invisible, user.usergroupid,
	session.userid, session.inforum, session.lastactivity,
	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
FROM vb_session AS session
LEFT JOIN vb_user AS user ON(user.userid = session.userid)
WHERE session.lastactivity > 1283994119
ORDER BY username ASC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	session	ALL					159	Using where; Using temporary; Using filesort
1	SIMPLE	user	eq_ref	PRIMARY	PRIMARY	4	vb_internetcp.session.userid	1

Time Before: 0.15564 seconds
Time After: 0.15742 seconds
Time Taken: 0.00178 seconds

Memory Before: 2,426.809 KB
Memory After: 2,426.520 KB
Memory Used: -0.289 KB

SQL Query

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

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

Time Before: 0.15932 seconds
Time After: 0.15954 seconds
Time Taken: 0.00021 seconds

Memory Before: 2,426.836 KB
Memory After: 2,426.762 KB
Memory Used: -0.074 KB

SQL Query

SELECT moderator.*, user.username,
IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid
FROM vb_moderator AS moderator
INNER JOIN vb_user AS user USING(userid)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	moderator	system	userid				1
1	SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1

Time Before: 0.17231 seconds
Time After: 0.17253 seconds
Time Taken: 0.00022 seconds

Memory Before: 2,432.344 KB
Memory After: 2,432.211 KB
Memory Used: -0.133 KB

SQL Query

UPDATE vb_session
SET lastactivity = 1283997719, location = '/forums/?explain=1', inforum = 0, inthread = 0, incalendar = 0, badlocation = 0
WHERE sessionhash = '08bffa6beb92d08f149e8eabe6f44fa9'

Time Before: 0.18034 seconds
Time After: 0.18286 seconds
Time Taken: 0.00252 seconds

Memory Before: 2,598.121 KB
Memory After: 2,598.320 KB
Memory Used: 0.199 KB