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.01153 seconds
Time After: 0.01221 seconds
Time Taken: 0.00068 seconds

Memory Before: 5,500.156 KB
Memory After: 5,502.461 KB
Memory Used: 2.305 KB

Time Before: 0.01101 seconds
Time After: 0.01306 seconds
Time Taken: 0.00205 seconds

Memory Before: 5,496.430 KB
Memory After: 6,247.438 KB
Memory Used: 751.008 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.01475 seconds
Time After: 0.01485 seconds
Time Taken: 0.00010 seconds

Memory Before: 7,026.586 KB
Memory After: 7,028.586 KB
Memory Used: 2.000 KB

Session Handling

SQL Query

SELECT *
FROM vb_session
WHERE userid = 0
	AND host = '216.73.216.107'
	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.01526 seconds
Time After: 0.01539 seconds
Time Taken: 0.00013 seconds

Memory Before: 7,038.922 KB
Memory After: 7,041.125 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.01661 seconds
Time After: 0.01722 seconds
Time Taken: 0.00061 seconds

Memory Before: 7,051.172 KB
Memory After: 7,052.625 KB
Memory Used: 1.453 KB

Time Before: 0.01495 seconds
Time After: 0.01735 seconds
Time Taken: 0.00240 seconds

Memory Before: 7,033.336 KB
Memory After: 7,222.805 KB
Memory Used: 189.469 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.02040 seconds
Time After: 0.02063 seconds
Time Taken: 0.00023 seconds

Memory Before: 7,690.773 KB
Memory After: 7,692.750 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.02190 seconds
Time After: 0.02213 seconds
Time Taken: 0.00023 seconds

Memory Before: 7,918.078 KB
Memory After: 7,920.242 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.03480 seconds
Time After: 0.03491 seconds
Time Taken: 0.00011 seconds

Memory Before: 12,433.164 KB
Memory After: 12,435.188 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 >= 1758039729
	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.04025 seconds
Time After: 0.04057 seconds
Time Taken: 0.00031 seconds

Memory Before: 13,611.070 KB
Memory After: 13,612.859 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.107','bc469a3ea61f025eda57102bfa876eaf','groupdateline','desc',0,1758126129,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:1758039729;}}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.04069 seconds
Time After: 0.04091 seconds
Time Taken: 0.00022 seconds

Memory Before: 13,611.984 KB
Memory After: 13,611.109 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:\"850\";i:2;s:3:\"850\";}}i:1;i:-1;i:2;N;i:3;N;}'
WHERE searchlogid = 5780591

Time Before: 0.04095 seconds
Time After: 0.04106 seconds
Time Taken: 0.00011 seconds

Memory Before: 13,605.930 KB
Memory After: 13,606.195 KB
Memory Used: 0.266 KB

SQL Query

UPDATE vb_searchlog
SET searchtime = 0.00231,
	completed = 1
WHERE searchlogid = 5780591

Time Before: 0.04109 seconds
Time After: 0.04118 seconds
Time Taken: 0.00009 seconds

Memory Before: 13,605.500 KB
Memory After: 13,605.844 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.04187 seconds
Time After: 0.04205 seconds
Time Taken: 0.00018 seconds

Memory Before: 13,669.773 KB
Memory After: 13,671.945 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 (850)
		AND userid = 0
	GROUP BY threadid
) AS lastpost ON (lastpost.threadid = thread.threadid)
WHERE thread.threadid IN (850)

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					0	const row not found
2	DERIVED	vb_post	ref	threadid,threadid_visible_dateline,userid,user_date	threadid	8	const,const	1

Time Before: 0.04291 seconds
Time After: 0.04331 seconds
Time Taken: 0.00040 seconds

Memory Before: 13,695.977 KB
Memory After: 13,697.164 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:\"850\";i:2;s:3:\"850\";}}i:1;i:0;i:2;a:1:{i:2;a:1:{i:0;s:3:\"850\";}}i:3;a:1:{i:2;a:0:{}}}'
WHERE searchlogid = 5780591

Time Before: 0.04364 seconds
Time After: 0.04380 seconds
Time Taken: 0.00015 seconds

Memory Before: 13,695.344 KB
Memory After: 13,695.578 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.04422 seconds
Time After: 0.04459 seconds
Time Taken: 0.00037 seconds

Memory Before: 13,695.445 KB
Memory After: 13,697.367 KB
Memory Used: 1.922 KB