vBulletin

Datastore Setup

SQL Query

SELECT *
FROM datastore
WHERE title IN ('tagcloud','iconcache','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	50		15	Using index condition

Time Before: 0.00074 seconds
Time After: 0.00108 seconds
Time Taken: 0.00034 seconds

Memory Before: 461.383 KB
Memory After: 1,018.250 KB
Memory Used: 556.867 KB

Time Before: 0.00051 seconds
Time After: 0.00188 seconds
Time Taken: 0.00137 seconds

Memory Before: 458.945 KB
Memory After: 1,289.234 KB
Memory Used: 830.289 KB

SQL Query

SELECT *
FROM datastore
WHERE title IN ('dbtech_ajaxthreads_usergroup')

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.00213 seconds
Time After: 0.00216 seconds
Time Taken: 0.00003 seconds

Memory Before: 1,446.789 KB
Memory After: 1,462.859 KB
Memory Used: 16.070 KB

Session Handling

SQL Query

SELECT *
FROM session
WHERE userid = 0
	AND host = '18.224.67.149'
	AND idhash = '3c72b3b05cf103867106308297843dea'
LIMIT 1

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

Time Before: 0.00233 seconds
Time After: 0.00236 seconds
Time Taken: 0.00003 seconds

Memory Before: 1,451.297 KB
Memory After: 1,467.602 KB
Memory Used: 16.305 KB

SQL Query

SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_inlinemod AS phrasegroup_inlinemod,
			phrasegroup_search AS phrasegroup_search,
			phrasegroup_prefix AS phrasegroup_prefix,
			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 = 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.00268 seconds
Time After: 0.00287 seconds
Time Taken: 0.00019 seconds

Memory Before: 1,457.125 KB
Memory After: 1,674.023 KB
Memory Used: 216.898 KB

Time Before: 0.00218 seconds
Time After: 0.00289 seconds
Time Taken: 0.00071 seconds

Memory Before: 1,448.133 KB
Memory After: 1,563.008 KB
Memory Used: 114.875 KB

SQL Query

SELECT userip
FROM vsavilxh_guests AS vsavilxh_guests
WHERE userip = '18.224.67.149'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	vsavilxh_guests	ALL					550	Using where

Time Before: 0.00364 seconds
Time After: 0.00382 seconds
Time Taken: 0.00018 seconds

Memory Before: 1,718.414 KB
Memory After: 1,734.625 KB
Memory Used: 16.211 KB

SQL Query

UPDATE vsavilxh_guests
SET dateline = '1713241576'
WHERE userip = '18.224.67.149'

Time Before: 0.00383 seconds
Time After: 0.00410 seconds
Time Taken: 0.00027 seconds

Memory Before: 1,734.773 KB
Memory After: 1,734.758 KB
Memory Used: -0.016 KB

SQL Query

DELETE FROM vsavilxh_guests WHERE dateline < '1713155176'

Time Before: 0.00411 seconds
Time After: 0.00431 seconds
Time Taken: 0.00020 seconds

Memory Before: 1,718.070 KB
Memory After: 1,718.055 KB
Memory Used: -0.016 KB

SQL Query

SELECT *
FROM style
WHERE (styleid = 12 AND userselect = 1)
	OR styleid = 12
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.00445 seconds
Time After: 0.00451 seconds
Time Taken: 0.00005 seconds

Memory Before: 1,708.469 KB
Memory After: 1,917.117 KB
Memory Used: 208.648 KB

SQL Query

SELECT *
FROM datastore
WHERE title IN ('routes')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	datastore	const	PRIMARY	PRIMARY	50	const	1

Time Before: 0.00521 seconds
Time After: 0.00523 seconds
Time Taken: 0.00002 seconds

Memory Before: 2,124.383 KB
Memory After: 2,140.719 KB
Memory Used: 16.336 KB

SQL Query

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

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

Time Before: 0.00564 seconds
Time After: 0.00567 seconds
Time Taken: 0.00003 seconds

Memory Before: 2,304.711 KB
Memory After: 2,321.094 KB
Memory Used: 16.383 KB

SQL Query

SELECT tagid, tagtext, canonicaltagid, dateline FROM tag WHERE tagtext = 'sony'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tag	const	tagtext	tagtext	102	const	1

Time Before: 0.00596 seconds
Time After: 0.00603 seconds
Time Taken: 0.00007 seconds

Memory Before: 2,421.477 KB
Memory After: 2,437.859 KB
Memory Used: 16.383 KB

SQL Query

SELECT searchlog.*
FROM searchlog AS searchlog
WHERE searchhash = 'c8b3c1f81f2b7609cd402323251120ca' AND
	sortby =  '' AND
	sortorder =  'asc' AND
	dateline > 1713237976 AND
	userid = 0 AND
	completed = 1
ORDER BY dateline DESC
LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	searchlog	range	search,userfloodcheck	userfloodcheck	8		502	Using where

Time Before: 0.00628 seconds
Time After: 0.00799 seconds
Time Taken: 0.00171 seconds

Memory Before: 2,424.938 KB
Memory After: 2,440.805 KB
Memory Used: 15.867 KB

SQL Query

SELECT contenttypeid, tagcontent.contentid, tagcontent.contentid as threadid
FROM tagcontent as tagcontent
WHERE tagid = 67 
ORDER BY dateline DESC 
LIMIT 20000

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tagcontent	ref	PRIMARY	PRIMARY	4	const	3	Using where; Using filesort

Time Before: 0.00816 seconds
Time After: 0.00826 seconds
Time Taken: 0.00010 seconds

Memory Before: 2,426.781 KB
Memory After: 2,443.289 KB
Memory Used: 16.508 KB

SQL Query

REPLACE INTO searchlog
	(userid,ipaddress,searchhash,sortby,sortorder,searchtime,dateline,completed,criteria,results)
VALUES
	(0,'18.224.67.149','c8b3c1f81f2b7609cd402323251120ca','','asc',0,1713241576,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:1:{s:3:\"tag\";a:1:{s:2:\"eq\";s:2:\"67\";}}s:24:\"\0vB_Search_Criteria\0sort\";a:2:{i:0;s:0:\"\";i:1;s:3:\"asc\";}s:27:\"\0vB_Search_Criteria\0grouped\";i:3;s:31:\"\0vB_Search_Criteria\0searchterms\";N;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:1:{s:3:\"tag\";s:30:\"برچسب: sony\";}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:\"tag\";}','')

Time Before: 0.00830 seconds
Time After: 0.00852 seconds
Time Taken: 0.00022 seconds

Memory Before: 2,431.570 KB
Memory After: 2,431.570 KB
Memory Used: 0.000 KB

SQL Query

UPDATE searchlog
SET results = 'a:4:{i:0;a:3:{i:0;a:3:{i:0;s:1:\"2\";i:1;s:4:\"1602\";i:2;s:4:\"1602\";}i:1;a:3:{i:0;s:1:\"2\";i:1;s:4:\"1139\";i:2;s:4:\"1139\";}i:2;a:3:{i:0;s:1:\"2\";i:1;s:3:\"813\";i:2;s:3:\"813\";}}i:1;i:-1;i:2;N;i:3;N;}'
WHERE searchlogid = 5396832

Time Before: 0.00854 seconds
Time After: 0.00862 seconds
Time Taken: 0.00008 seconds

Memory Before: 2,428.227 KB
Memory After: 2,428.398 KB
Memory Used: 0.172 KB

SQL Query

UPDATE searchlog
SET searchtime = 0.00059,
	completed = 1
WHERE searchlogid = 5396832

Time Before: 0.00863 seconds
Time After: 0.00870 seconds
Time Taken: 0.00006 seconds

Memory Before: 2,427.648 KB
Memory After: 2,427.617 KB
Memory Used: -0.031 KB

SQL Query

INSERT INTO tagsearch (tagid, dateline) 
				VALUES (67, 1713241576)

Time Before: 0.00871 seconds
Time After: 0.00889 seconds
Time Taken: 0.00018 seconds

Memory Before: 2,427.625 KB
Memory After: 2,427.594 KB
Memory Used: -0.031 KB

SQL Query

SELECT title, template
FROM template
WHERE templateid IN (0,1572,1398,0,1411,1412,1531,1533,1532,1304,1521,1520,1500,1506,1408,1417,1167,2233,2231,2234,2235,0,0,79,73,72,2344,2347,2101,75,80,81,82,1337,1634,2221,2222,1286,1287,1650,0,0,1613,1615,1307,1308,1310,1311,1534,1577,1576,1626,1578,1137,1136,1140,2249,1931,1932,1129,1132,1130,1295,1131,2226)

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

Time Before: 0.00933 seconds
Time After: 0.00968 seconds
Time Taken: 0.00035 seconds

Memory Before: 2,534.594 KB
Memory After: 2,753.461 KB
Memory Used: 218.867 KB

SQL Query

SELECT * FROM molding ORDER BY molding.order ASC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	molding	ALL					11	Using filesort

Time Before: 0.01007 seconds
Time After: 0.01009 seconds
Time Taken: 0.00003 seconds

Memory Before: 2,714.414 KB
Memory After: 2,732.156 KB
Memory Used: 17.742 KB

SQL Query

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	moderator	ALL	userid_forumid				3
1	SIMPLE	user	eq_ref	PRIMARY	PRIMARY	4	mihangam_mforum.moderator.userid	1

Time Before: 0.01095 seconds
Time After: 0.01098 seconds
Time Taken: 0.00003 seconds

Memory Before: 2,741.906 KB
Memory After: 2,758.258 KB
Memory Used: 16.352 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 thread AS thread
	LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
LEFT JOIN user AS user ON (user.userid = thread.lastposterid)
LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid)
LEFT JOIN user AS first_user ON (first_user.userid = thread.postuserid)
LEFT JOIN avatar AS first_avatar ON (first_avatar.avatarid = first_user.avatarid)
LEFT JOIN customavatar AS first_customavatar ON (first_customavatar.userid = first_user.userid)
LEFT JOIN (
	SELECT threadid, MAX(dateline) AS lastposttime
	FROM post
	WHERE threadid IN (1602,1139,813)
		AND userid = 0
	GROUP BY threadid
) AS lastpost ON (lastpost.threadid = thread.threadid)
WHERE thread.threadid IN (1602,1139,813)

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	range	PRIMARY	PRIMARY	4		3	Using index condition
1	PRIMARY	post	eq_ref	PRIMARY	PRIMARY	4	mihangam_mforum.thread.firstpostid	1
1	PRIMARY	user	eq_ref	PRIMARY	PRIMARY	4	mihangam_mforum.thread.lastposterid	1
1	PRIMARY	customavatar	eq_ref	PRIMARY	PRIMARY	4	mihangam_mforum.user.userid	1	Using where
1	PRIMARY	first_user	eq_ref	PRIMARY	PRIMARY	4	mihangam_mforum.thread.postuserid	1
1	PRIMARY	first_customavatar	eq_ref	PRIMARY	PRIMARY	4	mihangam_mforum.first_user.userid	1	Using where
1	PRIMARY		ref	key0	key0	5	mihangam_mforum.thread.threadid	2
2	DERIVED	post	range	userid,threadid,threadid_visible_dateline,user_date	threadid	8		3	Using index condition; Using temporary; Using filesort

Time Before: 0.01142 seconds
Time After: 0.01187 seconds
Time Taken: 0.00046 seconds

Memory Before: 2,753.086 KB
Memory After: 2,850.555 KB
Memory Used: 97.469 KB

SQL Query

UPDATE searchlog
SET results = 'a:4:{i:0;a:2:{i:0;a:3:{i:0;s:1:\"2\";i:1;s:4:\"1139\";i:2;s:4:\"1139\";}i:1;a:3:{i:0;s:1:\"2\";i:1;s:3:\"813\";i:2;s:3:\"813\";}}i:1;i:1;i:2;a:1:{i:2;a:2:{i:0;s:4:\"1139\";i:1;s:3:\"813\";}}i:3;a:1:{i:2;a:0:{}}}'
WHERE searchlogid = 5396832

Time Before: 0.01243 seconds
Time After: 0.01253 seconds
Time Taken: 0.00009 seconds

Memory Before: 2,980.750 KB
Memory After: 2,980.922 KB
Memory Used: 0.172 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, topxtab, topxmenu, topxresult)
VALUES
	('827df9b92e42303f21357492d74df982', 0, '18.224.67.149', '3c72b3b05cf103867106308297843dea', 1713241576, '/forum/tags.php?tag=sony&explain=1', 0, 0, 0, 0, 0, 0, 0, 'claudebot', 0, 0, 0, '', '0', '0', 0)

Time Before: 0.01398 seconds
Time After: 0.01411 seconds
Time Taken: 0.00013 seconds

Memory Before: 3,276.523 KB
Memory After: 3,275.977 KB
Memory Used: -0.547 KB