vBulletin

Datastore Setup

SQL Query

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	vb_datastore	range	PRIMARY	PRIMARY	150		17	Using index condition

Time Before: 0.01841 seconds
Time After: 0.01895 seconds
Time Taken: 0.00054 seconds

Memory Before: 5,504.367 KB
Memory After: 5,506.672 KB
Memory Used: 2.305 KB

Time Before: 0.01800 seconds
Time After: 0.01976 seconds
Time Taken: 0.00177 seconds

Memory Before: 5,500.641 KB
Memory After: 6,251.641 KB
Memory Used: 751.000 KB

SQL Query

SELECT *
FROM vb_datastore
WHERE title IN ('profilefield')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE noticed after reading const tables

Time Before: 0.02146 seconds
Time After: 0.02157 seconds
Time Taken: 0.00011 seconds

Memory Before: 7,030.766 KB
Memory After: 7,032.766 KB
Memory Used: 2.000 KB

Session Handling

SQL Query

SELECT *
FROM vb_session
WHERE userid = 0
	AND host = '216.73.216.213'
	AND idhash = 'ea5a359a73a8141a16de516480d33c34'
LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	vb_session	ref	guest_lookup,user_activity	guest_lookup	145	const,const,const	2	Using where

Time Before: 0.02202 seconds
Time After: 0.02220 seconds
Time Taken: 0.00017 seconds

Memory Before: 7,042.648 KB
Memory After: 7,044.852 KB
Memory Used: 2.203 KB

SQL Query

SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_search AS phrasegroup_search,
			phrasegroup_inlinemod AS phrasegroup_inlinemod,
			phrasegroup_prefix AS phrasegroup_prefix,
			phrasegroup_socialgroups AS phrasegroup_socialgroups,
			phrasegroup_prefix AS phrasegroup_prefix,
			phrasegroup_user AS phrasegroup_user,
			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 vb_language
WHERE languageid = 4

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

Time Before: 0.02293 seconds
Time After: 0.02356 seconds
Time Taken: 0.00063 seconds

Memory Before: 7,054.859 KB
Memory After: 7,056.328 KB
Memory Used: 1.469 KB

Time Before: 0.02168 seconds
Time After: 0.02367 seconds
Time Taken: 0.00199 seconds

Memory Before: 7,037.063 KB
Memory After: 7,226.469 KB
Memory Used: 189.406 KB

SQL Query

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

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

Time Before: 0.02670 seconds
Time After: 0.02684 seconds
Time Taken: 0.00014 seconds

Memory Before: 7,694.672 KB
Memory After: 7,696.648 KB
Memory Used: 1.977 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	const	PRIMARY	PRIMARY	2	const	1

Time Before: 0.02796 seconds
Time After: 0.02820 seconds
Time Taken: 0.00024 seconds

Memory Before: 7,921.984 KB
Memory After: 7,924.148 KB
Memory Used: 2.164 KB

SQL Query

SELECT data, expires, locktime, serialized
FROM vb_cache
WHERE cacheid = 'vb_types.types'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	vb_cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 0.04048 seconds
Time After: 0.04064 seconds
Time Taken: 0.00016 seconds

Memory Before: 12,437.008 KB
Memory After: 12,439.031 KB
Memory Used: 2.023 KB

SQL Query

SELECT thread.threadid
FROM vb_thread AS thread

WHERE thread.forumid IN(27, 1, 2, 16, 17, 23, 3, 13, 15, 19, 4, 5, 6, 7, 8, 9, 10, 11, 12, 14, 18, 38, 28, 33, 36, 20, 21, 22, 34)
	AND thread.lastpost >= 1751354861
	AND thread.open <> 10
ORDER BY thread.lastpost desc
LIMIT 500

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	thread	range	forumid,forumid_lastpost,lastpost	lastpost	4		2	Using index condition; Using where

Time Before: 0.04610 seconds
Time After: 0.04644 seconds
Time Taken: 0.00035 seconds

Memory Before: 13,614.852 KB
Memory After: 13,616.641 KB
Memory Used: 1.789 KB

SQL Query

REPLACE INTO vb_searchlog
	(userid,ipaddress,searchhash,sortby,sortorder,searchtime,dateline,completed,criteria,results)
VALUES
	(0,'216.73.216.213','abe48cd8d0dc5b4edfd6c43eec782edc','groupdateline','desc',0,1751441261,0,'O:18:\"vB_Search_Criteria\":15:{s:28:\"\0vB_Search_Criteria\0keywords\";a:0:{}s:32:\"\0vB_Search_Criteria\0raw_keywords\";s:0:\"\";s:29:\"\0vB_Search_Criteria\0titleonly\";b:0;s:27:\"\0vB_Search_Criteria\0filters\";a:2:{s:11:\"contenttype\";a:1:{s:2:\"eq\";a:1:{i:0;i:1;}}s:7:\"datecut\";a:1:{s:2:\"gt\";i:1751354861;}}s:24:\"\0vB_Search_Criteria\0sort\";a:2:{i:0;s:13:\"groupdateline\";i:1;s:4:\"desc\";}s:27:\"\0vB_Search_Criteria\0grouped\";i:1;s:31:\"\0vB_Search_Criteria\0searchterms\";a:4:{s:10:\"searchdate\";i:1;s:13:\"contenttypeid\";s:1:\"1\";s:11:\"search_type\";i:1;s:9:\"showposts\";i:0;}s:32:\"\0vB_Search_Criteria\0criteria_set\";b:1;s:35:\"\0vB_Search_Criteria\0advanced_typeid\";b:0;s:35:\"\0vB_Search_Criteria\0display_strings\";a:2:{s:4:\"type\";s:26:\"Тип: Сообщения\";s:7:\"newitem\";s:41:\"Сегодняшние сообщения\";}s:32:\"\0vB_Search_Criteria\0common_words\";a:0:{}s:30:\"\0vB_Search_Criteria\0highlights\";a:0:{}s:33:\"\0vB_Search_Criteria\0search_string\";N;s:26:\"\0vB_Search_Criteria\0errors\";a:0:{}s:11:\"search_type\";s:3:\"new\";}','')

Time Before: 0.04658 seconds
Time After: 0.04704 seconds
Time Taken: 0.00046 seconds

Memory Before: 13,615.766 KB
Memory After: 13,614.891 KB
Memory Used: -0.875 KB

SQL Query

UPDATE vb_searchlog
SET results = 'a:4:{i:0;a:1:{i:0;a:3:{i:0;s:1:\"2\";i:1;s:3:\"111\";i:2;s:3:\"111\";}}i:1;i:-1;i:2;N;i:3;N;}'
WHERE searchlogid = 5571013

Time Before: 0.04708 seconds
Time After: 0.04722 seconds
Time Taken: 0.00014 seconds

Memory Before: 13,609.711 KB
Memory After: 13,609.977 KB
Memory Used: 0.266 KB

SQL Query

UPDATE vb_searchlog
SET searchtime = 0.00268,
	completed = 1
WHERE searchlogid = 5571013

Time Before: 0.04726 seconds
Time After: 0.04738 seconds
Time Taken: 0.00012 seconds

Memory Before: 13,609.281 KB
Memory After: 13,609.625 KB
Memory Used: 0.344 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	ALL	userid_forumid				4
1	SIMPLE	user	eq_ref	PRIMARY	PRIMARY	4	zabvo_db.moderator.userid	1

Time Before: 0.04802 seconds
Time After: 0.04826 seconds
Time Taken: 0.00025 seconds

Memory Before: 13,673.578 KB
Memory After: 13,675.750 KB
Memory Used: 2.172 KB

SQL Query

SELECT thread.*,post.pagetext AS preview,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, user.avatarrevision,
			customavatar.dateline AS avatardateline, customavatar.width AS width, customavatar.height AS height,
			customavatar.height_thumb AS height_thumb, customavatar.width_thumb AS width_thumb, customavatar.filedata_thumb,
			first_user.avatarrevision AS first_avatarrevision, first_avatar.avatarpath AS first_avatarpath,
			NOT ISNULL(first_customavatar.userid) AS first_hascustomavatar, first_customavatar.dateline AS first_avatardateline,
			first_customavatar.width AS first_width, first_customavatar.height AS first_height, first_customavatar.height_thumb
			AS first_height_thumb, first_customavatar.width_thumb AS first_width_thumb, first_customavatar.filedata_thumb AS
			first_filedata_thumb,lastpost.lastposttime
FROM vb_thread AS thread
	LEFT JOIN vb_post AS post ON(post.postid = thread.firstpostid)
LEFT JOIN vb_user AS user ON (user.userid = thread.lastposterid)
LEFT JOIN vb_avatar AS avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN vb_customavatar AS customavatar ON (customavatar.userid = user.userid)
LEFT JOIN vb_user AS first_user ON (first_user.userid = thread.postuserid)
LEFT JOIN vb_avatar AS first_avatar ON (first_avatar.avatarid = first_user.avatarid)
LEFT JOIN vb_customavatar AS first_customavatar ON (first_customavatar.userid = first_user.userid)
LEFT JOIN (
	SELECT threadid, MAX(dateline) AS lastposttime
	FROM vb_post
	WHERE threadid IN (111)
		AND userid = 0
	GROUP BY threadid
) AS lastpost ON (lastpost.threadid = thread.threadid)
WHERE thread.threadid IN (111)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	avatar	system	PRIMARY				0	const row not found
1	PRIMARY	first_avatar	system	PRIMARY				0	const row not found
1	PRIMARY	thread	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	post	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	user	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	customavatar	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	first_user	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	first_customavatar	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY		system					1
2	DERIVED	vb_post	ref	threadid,threadid_visible_dateline,userid,user_date	threadid	8	const,const	5

Time Before: 0.04952 seconds
Time After: 0.05011 seconds
Time Taken: 0.00059 seconds

Memory Before: 13,699.766 KB
Memory After: 13,700.953 KB
Memory Used: 1.188 KB

SQL Query

UPDATE vb_searchlog
SET results = 'a:4:{i:0;a:1:{i:0;a:3:{i:0;s:1:\"2\";i:1;s:3:\"111\";i:2;s:3:\"111\";}}i:1;i:0;i:2;a:1:{i:2;a:1:{i:0;s:3:\"111\";}}i:3;a:1:{i:2;a:0:{}}}'
WHERE searchlogid = 5571013

Time Before: 0.05031 seconds
Time After: 0.05047 seconds
Time Taken: 0.00016 seconds

Memory Before: 13,700.180 KB
Memory After: 13,700.414 KB
Memory Used: 0.234 KB

SQL Query

SELECT text, languageid, special
FROM vb_phrase AS phrase
LEFT JOIN vb_phrasetype USING (fieldname)
WHERE phrase.fieldname = 'frontredirect'
	AND varname = 'search' AND languageid IN (-1, 0, 4)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	phrase	range	name_lang_type,languageid	name_lang_type	816		3	Using index condition
1	SIMPLE	vb_phrasetype	eq_ref	PRIMARY	PRIMARY	60	zabvo_db.phrase.fieldname	1	Using where

Time Before: 0.05101 seconds
Time After: 0.05147 seconds
Time Taken: 0.00046 seconds

Memory Before: 13,700.242 KB
Memory After: 13,702.164 KB
Memory Used: 1.922 KB