vBulletin

Including Functions.php

Time Before: 0.00020 seconds
Time After: 0.00023 seconds
Time Taken: 0.00003 seconds

Memory Before: 461.195 KB
Memory After: 463.117 KB
Memory Used: 1.922 KB

Connect to Database on Server: localhost

Time Before: 0.00025 seconds
Time After: 0.00041 seconds
Time Taken: 0.00016 seconds

Memory Before: 463.094 KB
Memory After: 463.672 KB
Memory Used: 0.578 KB

SQL Query

SET @@sql_mode = ''

Time Before: 0.00048 seconds
Time After: 0.00057 seconds
Time Taken: 0.00008 seconds

Memory Before: 463.695 KB
Memory After: 463.750 KB
Memory Used: 0.055 KB

Datastore Setup

SQL Query

SELECT *
FROM datastore
WHERE title IN ('iconcache','searchcloud','routes','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		16	Using index condition

Time Before: 0.00078 seconds
Time After: 0.05115 seconds
Time Taken: 0.05037 seconds

Memory Before: 465.984 KB
Memory After: 1,022.852 KB
Memory Used: 556.867 KB

Time Before: 0.00057 seconds
Time After: 0.05205 seconds
Time Taken: 0.05148 seconds

Memory Before: 463.516 KB
Memory After: 1,323.953 KB
Memory Used: 860.438 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.05234 seconds
Time After: 0.10256 seconds
Time Taken: 0.05022 seconds

Memory Before: 1,481.508 KB
Memory After: 1,497.578 KB
Memory Used: 16.070 KB

Session Handling

SQL Query

SELECT *
FROM session
WHERE userid = 0
	AND host = '13.58.252.8'
	AND idhash = '12c233645f55ee3621db64e07568ae72'
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.10291 seconds
Time After: 0.15318 seconds
Time Taken: 0.05027 seconds

Memory Before: 1,486.328 KB
Memory After: 1,503.023 KB
Memory Used: 16.695 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 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.15360 seconds
Time After: 0.20403 seconds
Time Taken: 0.05043 seconds

Memory Before: 1,492.664 KB
Memory After: 1,877.523 KB
Memory Used: 384.859 KB

Time Before: 0.10265 seconds
Time After: 0.20410 seconds
Time Taken: 0.10145 seconds

Memory Before: 1,482.852 KB
Memory After: 1,686.273 KB
Memory Used: 203.422 KB

SQL Query

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

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

Time Before: 0.20524 seconds
Time After: 0.25568 seconds
Time Taken: 0.05043 seconds

Memory Before: 1,951.367 KB
Memory After: 1,967.609 KB
Memory Used: 16.242 KB

SQL Query

UPDATE vsavilxh_guests
SET dateline = '1713512390'
WHERE userip = '13.58.252.8'

Time Before: 0.25573 seconds
Time After: 0.28962 seconds
Time Taken: 0.03389 seconds

Memory Before: 1,967.758 KB
Memory After: 1,967.742 KB
Memory Used: -0.016 KB

SQL Query

DELETE FROM vsavilxh_guests WHERE dateline < '1713425990'

Time Before: 0.28969 seconds
Time After: 0.29037 seconds
Time Taken: 0.00068 seconds

Memory Before: 1,951.055 KB
Memory After: 1,951.039 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.29071 seconds
Time After: 0.29097 seconds
Time Taken: 0.00026 seconds

Memory Before: 1,941.453 KB
Memory After: 2,150.102 KB
Memory Used: 208.648 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.29290 seconds
Time After: 0.29294 seconds
Time Taken: 0.00004 seconds

Memory Before: 2,626.266 KB
Memory After: 2,642.648 KB
Memory Used: 16.383 KB

SQL Query

SELECT title, template
FROM template
WHERE templateid IN (0,1572,1398,1408,1411,1412,1410,1416,1414,1415,1417,1309,1312,1313,1531,1533,1532,1304,1521,1520,1500,1499,1399,1404,1405,1498,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		71	Using index condition

Time Before: 0.29403 seconds
Time After: 0.29471 seconds
Time Taken: 0.00069 seconds

Memory Before: 2,776.320 KB
Memory After: 3,059.938 KB
Memory Used: 283.617 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.29540 seconds
Time After: 0.29550 seconds
Time Taken: 0.00009 seconds

Memory Before: 3,071.125 KB
Memory After: 3,088.867 KB
Memory Used: 17.742 KB

SQL Query

SELECT contenttype.contenttypeid AS itemid
	
FROM contenttype AS contenttype
	INNER JOIN package AS package
	ON package.packageid = contenttype.packageid LEFT JOIN product AS product
	ON product.productid = package.productid 
WHERE
	1 = 1 AND (product.active = '1' OR package.productid = 'vbulletin')  AND contenttype.cansearch = '1'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	package	system	PRIMARY				1
1	SIMPLE	product	const	PRIMARY	PRIMARY	27	const	0	Unique row not found
1	SIMPLE	contenttype	ALL	packageclass				18	Using where

Time Before: 0.29673 seconds
Time After: 0.29691 seconds
Time Taken: 0.00017 seconds

Memory Before: 3,117.945 KB
Memory After: 3,134.281 KB
Memory Used: 16.336 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 (961)
		AND userid = 0
	GROUP BY threadid
) AS lastpost ON (lastpost.threadid = thread.threadid)
WHERE thread.threadid IN (961)

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	0	Unique row not found
1	PRIMARY	first_user	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	first_customavatar	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY		ALL					2	Using where
2	DERIVED	post	ref	userid,threadid,threadid_visible_dateline,user_date	threadid	8	const,const	1

Time Before: 0.29867 seconds
Time After: 0.29941 seconds
Time Taken: 0.00074 seconds

Memory Before: 3,257.547 KB
Memory After: 3,289.359 KB
Memory Used: 31.813 KB

SQL Query

SELECT prefix.prefixsetid, prefix.prefixid, forumprefixset.forumid
FROM prefix AS prefix
	INNER JOIN prefixset AS prefixset ON (prefixset.prefixsetid = prefix.prefixsetid)
	INNER JOIN forumprefixset AS forumprefixset ON
		(forumprefixset.prefixsetid = prefixset.prefixsetid)
ORDER BY prefixset.displayorder, prefix.displayorder

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.30293 seconds
Time After: 0.30308 seconds
Time Taken: 0.00014 seconds

Memory Before: 3,307.359 KB
Memory After: 3,323.164 KB
Memory Used: 15.805 KB

SQL Query

SELECT contenttype.contenttypeid AS itemid
	
FROM contenttype AS contenttype
	INNER JOIN package AS package
	ON package.packageid = contenttype.packageid LEFT JOIN product AS product
	ON product.productid = package.productid 
WHERE
	1 = 1 AND (product.active = '1' OR package.productid = 'vbulletin')  AND contenttype.cantag = '1'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	package	system	PRIMARY				1
1	SIMPLE	product	const	PRIMARY	PRIMARY	27	const	0	Unique row not found
1	SIMPLE	contenttype	ALL	packageclass				18	Using where

Time Before: 0.30409 seconds
Time After: 0.30425 seconds
Time Taken: 0.00016 seconds

Memory Before: 3,310.445 KB
Memory After: 3,326.656 KB
Memory Used: 16.211 KB

SQL Query

SELECT tagsearch.tagid, COUNT(*) AS searchcount
FROM tagsearch AS tagsearch
WHERE tagsearch.dateline > 1710920390
GROUP BY tagsearch.tagid
ORDER BY searchcount DESC
LIMIT 70

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tagsearch	range	dateline	dateline	4		4877	Using index condition; Using temporary; Using filesort

Time Before: 0.30461 seconds
Time After: 0.30737 seconds
Time Taken: 0.00276 seconds

Memory Before: 3,312.203 KB
Memory After: 3,332.039 KB
Memory Used: 19.836 KB

SQL Query

SELECT tag.tagid, tag.tagtext
						FROM tag AS tag
					   WHERE tag.tagid IN (332,44,34,57,222,258,331,256,67,75,81,8,21,82,80,83,66,229,271,36,230,50,217,301,51,224,3,291,95,450,292,300,35,442,365,43,53,65,237,94,12,52,70,214,218,77,144,444,368,267,5,215,45,74,135,145,437,25,298,72,54,78,56,117,116,279,389,87,42,269)

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

Time Before: 0.30767 seconds
Time After: 0.30795 seconds
Time Taken: 0.00028 seconds

Memory Before: 3,344.750 KB
Memory After: 3,364.805 KB
Memory Used: 20.055 KB

SQL Query

REPLACE INTO datastore
	(title, data, unserialize)
VALUES
	('searchcloud', 'a:3:{s:4:\"tags\";a:70:{s:6:\"3d max\";a:5:{s:5:\"tagid\";s:3:\"267\";s:11:\"searchcount\";s:2:\"39\";s:7:\"tagtext\";s:6:\"3d max\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:6:\"3d+max\";}s:4:\"820m\";a:5:{s:5:\"tagid\";s:3:\"279\";s:11:\"searchcount\";s:2:\"34\";s:7:\"tagtext\";s:4:\"820m\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:4:\"820m\";}s:5:\"alexa\";a:5:{s:5:\"tagid\";s:3:\"331\";s:11:\"searchcount\";s:2:\"59\";s:7:\"tagtext\";s:5:\"alexa\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:5:\"alexa\";}s:3:\"amd\";a:5:{s:5:\"tagid\";s:2:\"81\";s:11:\"searchcount\";s:2:\"58\";s:7:\"tagtext\";s:3:\"amd\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:3:\"amd\";}s:7:\"android\";a:5:{s:5:\"tagid\";s:2:\"72\";s:11:\"searchcount\";s:2:\"36\";s:7:\"tagtext\";s:7:\"android\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:7:\"android\";}s:3:\"app\";a:5:{s:5:\"tagid\";s:3:\"301\";s:11:\"searchcount\";s:2:\"53\";s:7:\"tagtext\";s:3:\"app\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:3:\"app\";}s:5:\"apple\";a:5:{s:5:\"tagid\";s:2:\"65\";s:11:\"searchcount\";s:2:\"47\";s:7:\"tagtext\";s:5:\"apple\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:5:\"apple\";}s:4:\"asus\";a:5:{s:5:\"tagid\";s:2:\"75\";s:11:\"searchcount\";s:2:\"58\";s:7:\"tagtext\";s:4:\"asus\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:4:\"asus\";}s:25:\"battlefield bad company 2\";a:5:{s:5:\"tagid\";s:3:\"368\";s:11:\"searchcount\";s:2:\"39\";s:7:\"tagtext\";s:25:\"battlefield bad company 2\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:25:\"battlefield+bad+company+2\";}s:4:\"case\";a:5:{s:5:\"tagid\";s:3:\"271\";s:11:\"searchcount\";s:2:\"54\";s:7:\"tagtext\";s:4:\"case\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:4:\"case\";}s:4:\"ddr4\";a:5:{s:5:\"tagid\";s:3:\"237\";s:11:\"searchcount\";s:2:\"47\";s:7:\"tagtext\";s:4:\"ddr4\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:4:\"ddr4\";}s:4:\"dell\";a:5:{s:5:\"tagid\";s:3:\"222\";s:11:\"searchcount\";s:2:\"61\";s:7:\"tagtext\";s:4:\"dell\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:4:\"dell\";}s:7:\"digital\";a:5:{s:5:\"tagid\";s:2:\"54\";s:11:\"searchcount\";s:2:\"36\";s:7:\"tagtext\";s:7:\"digital\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:7:\"digital\";}s:5:\"error\";a:5:{s:5:\"tagid\";s:3:\"224\";s:11:\"searchcount\";s:2:\"53\";s:7:\"tagtext\";s:5:\"error\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:5:\"error\";}s:4:\"game\";a:5:{s:5:\"tagid\";s:2:\"45\";s:11:\"searchcount\";s:2:\"39\";s:7:\"tagtext\";s:4:\"game\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:4:\"game\";}s:8:\"gigabyte\";a:5:{s:5:\"tagid\";s:3:\"229\";s:11:\"searchcount\";s:2:\"54\";s:7:\"tagtext\";s:8:\"gigabyte\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:8:\"gigabyte\";}s:3:\"gpu\";a:5:{s:5:\"tagid\";s:2:\"56\";s:11:\"searchcount\";s:2:\"35\";s:7:\"tagtext\";s:3:\"gpu\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:3:\"gpu\";}s:5:\"gta v\";a:5:{s:5:\"tagid\";s:3:\"145\";s:11:\"searchcount\";s:2:\"37\";s:7:\"tagtext\";s:5:\"gta v\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:5:\"gta+v\";}s:4:\"hard\";a:5:{s:5:\"tagid\";s:3:\"300\";s:11:\"searchcount\";s:2:\"50\";s:7:\"tagtext\";s:4:\"hard\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:4:\"hard\";}s:3:\"hdd\";a:5:{s:5:\"tagid\";s:3:\"292\";s:11:\"searchcount\";s:2:\"50\";s:7:\"tagtext\";s:3:\"hdd\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:3:\"hdd\";}s:9:\"headphone\";a:5:{s:5:\"tagid\";s:3:\"298\";s:11:\"searchcount\";s:2:\"37\";s:7:\"tagtext\";s:9:\"headphone\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:9:\"headphone\";}s:5:\"intel\";a:5:{s:5:\"tagid\";s:2:\"83\";s:11:\"searchcount\";s:2:\"55\";s:7:\"tagtext\";s:5:\"intel\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:5:\"intel\";}s:10:\"isdone.dll\";a:5:{s:5:\"tagid\";s:2:\"25\";s:11:\"searchcount\";s:2:\"37\";s:7:\"tagtext\";s:10:\"isdone.dll\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:10:\"isdone.dll\";}s:6:\"laptop\";a:5:{s:5:\"tagid\";s:2:\"52\";s:11:\"searchcount\";s:2:\"43\";s:7:\"tagtext\";s:6:\"laptop\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:6:\"laptop\";}s:9:\"microsoft\";a:5:{s:5:\"tagid\";s:2:\"70\";s:11:\"searchcount\";s:2:\"43\";s:7:\"tagtext\";s:9:\"microsoft\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:9:\"microsoft\";}s:5:\"mihan\";a:5:{s:5:\"tagid\";s:3:\"332\";s:11:\"searchcount\";s:2:\"68\";s:7:\"tagtext\";s:5:\"mihan\";s:5:\"level\";d:5;s:11:\"tagtext_url\";s:5:\"mihan\";}s:6:\"mobile\";a:5:{s:5:\"tagid\";s:2:\"51\";s:11:\"searchcount\";s:2:\"53\";s:7:\"tagtext\";s:6:\"mobile\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:6:\"mobile\";}s:3:\"msi\";a:5:{s:5:\"tagid\";s:3:\"217\";s:11:\"searchcount\";s:2:\"53\";s:7:\"tagtext\";s:3:\"msi\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:3:\"msi\";}s:8:\"nintendo\";a:5:{s:5:\"tagid\";s:2:\"78\";s:11:\"searchcount\";s:2:\"36\";s:7:\"tagtext\";s:8:\"nintendo\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:8:\"nintendo\";}s:9:\"note book\";a:5:{s:5:\"tagid\";s:3:\"214\";s:11:\"searchcount\";s:2:\"43\";s:7:\"tagtext\";s:9:\"note book\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:9:\"note+book\";}s:6:\"nvidia\";a:5:{s:5:\"tagid\";s:2:\"82\";s:11:\"searchcount\";s:2:\"56\";s:7:\"tagtext\";s:6:\"nvidia\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:6:\"nvidia\";}s:9:\"pc gaming\";a:5:{s:5:\"tagid\";s:2:\"50\";s:11:\"searchcount\";s:2:\"53\";s:7:\"tagtext\";s:9:\"pc gaming\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:9:\"pc+gaming\";}s:13:\"pizza trainer\";a:5:{s:5:\"tagid\";s:3:\"450\";s:11:\"searchcount\";s:2:\"51\";s:7:\"tagtext\";s:13:\"pizza trainer\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:13:\"pizza+trainer\";}s:18:\"plants vs. zombies\";a:5:{s:5:\"tagid\";s:3:\"135\";s:11:\"searchcount\";s:2:\"37\";s:7:\"tagtext\";s:18:\"plants vs. zombies\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:18:\"plants+vs.+zombies\";}s:3:\"ps3\";a:5:{s:5:\"tagid\";s:2:\"34\";s:11:\"searchcount\";s:2:\"62\";s:7:\"tagtext\";s:3:\"ps3\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:3:\"ps3\";}s:3:\"ps4\";a:5:{s:5:\"tagid\";s:2:\"35\";s:11:\"searchcount\";s:2:\"50\";s:7:\"tagtext\";s:3:\"ps4\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:3:\"ps4\";}s:3:\"ram\";a:5:{s:5:\"tagid\";s:2:\"57\";s:11:\"searchcount\";s:2:\"61\";s:7:\"tagtext\";s:3:\"ram\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:3:\"ram\";}s:3:\"row\";a:5:{s:5:\"tagid\";s:2:\"95\";s:11:\"searchcount\";s:2:\"52\";s:7:\"tagtext\";s:3:\"row\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:3:\"row\";}s:6:\"saints\";a:5:{s:5:\"tagid\";s:2:\"94\";s:11:\"searchcount\";s:2:\"45\";s:7:\"tagtext\";s:6:\"saints\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:6:\"saints\";}s:7:\"samsung\";a:5:{s:5:\"tagid\";s:2:\"66\";s:11:\"searchcount\";s:2:\"55\";s:7:\"tagtext\";s:7:\"samsung\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:7:\"samsung\";}s:7:\"seagate\";a:5:{s:5:\"tagid\";s:3:\"291\";s:11:\"searchcount\";s:2:\"52\";s:7:\"tagtext\";s:7:\"seagate\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:7:\"seagate\";}s:4:\"sony\";a:5:{s:5:\"tagid\";s:2:\"67\";s:11:\"searchcount\";s:2:\"58\";s:7:\"tagtext\";s:4:\"sony\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:4:\"sony\";}s:6:\"tablet\";a:5:{s:5:\"tagid\";s:2:\"53\";s:11:\"searchcount\";s:2:\"47\";s:7:\"tagtext\";s:6:\"tablet\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:6:\"tablet\";}s:8:\"tearaway\";a:5:{s:5:\"tagid\";s:3:\"116\";s:11:\"searchcount\";s:2:\"34\";s:7:\"tagtext\";s:8:\"tearaway\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:8:\"tearaway\";}s:7:\"toshina\";a:5:{s:5:\"tagid\";s:3:\"218\";s:11:\"searchcount\";s:2:\"41\";s:7:\"tagtext\";s:7:\"toshina\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:7:\"toshina\";}s:5:\"touch\";a:5:{s:5:\"tagid\";s:3:\"258\";s:11:\"searchcount\";s:2:\"59\";s:7:\"tagtext\";s:5:\"touch\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:5:\"touch\";}s:30:\"tungle،تانگل،اموزش\";a:5:{s:5:\"tagid\";s:3:\"389\";s:11:\"searchcount\";s:2:\"33\";s:7:\"tagtext\";s:30:\"tungle،تانگل،اموزش\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:78:\"tungle%D8%8C%D8%AA%D8%A7%D9%86%DA%AF%D9%84%D8%8C%D8%A7%D9%85%D9%88%D8%B2%D8%B4\";}s:9:\"ultrabook\";a:5:{s:5:\"tagid\";s:3:\"256\";s:11:\"searchcount\";s:2:\"58\";s:7:\"tagtext\";s:9:\"ultrabook\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:9:\"ultrabook\";}s:10:\"ultra book\";a:5:{s:5:\"tagid\";s:3:\"215\";s:11:\"searchcount\";s:2:\"39\";s:7:\"tagtext\";s:10:\"ultra book\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:10:\"ultra+book\";}s:3:\"wii\";a:5:{s:5:\"tagid\";s:2:\"80\";s:11:\"searchcount\";s:2:\"55\";s:7:\"tagtext\";s:3:\"wii\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:3:\"wii\";}s:7:\"windows\";a:5:{s:5:\"tagid\";s:2:\"74\";s:11:\"searchcount\";s:2:\"38\";s:7:\"tagtext\";s:7:\"windows\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:7:\"windows\";}s:7:\"xbox360\";a:5:{s:5:\"tagid\";s:2:\"77\";s:11:\"searchcount\";s:2:\"40\";s:7:\"tagtext\";s:7:\"xbox360\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:7:\"xbox360\";}s:8:\"xbox one\";a:5:{s:5:\"tagid\";s:2:\"36\";s:11:\"searchcount\";s:2:\"54\";s:7:\"tagtext\";s:8:\"xbox one\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:8:\"xbox+one\";}s:5:\"zotac\";a:5:{s:5:\"tagid\";s:3:\"269\";s:11:\"searchcount\";s:2:\"32\";s:7:\"tagtext\";s:5:\"zotac\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:5:\"zotac\";}s:10:\"انجمن\";a:5:{s:5:\"tagid\";s:2:\"43\";s:11:\"searchcount\";s:2:\"48\";s:7:\"tagtext\";s:10:\"انجمن\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:30:\"%D8%A7%D9%86%D8%AC%D9%85%D9%86\";}s:8:\"بازی\";a:5:{s:5:\"tagid\";s:2:\"44\";s:11:\"searchcount\";s:2:\"64\";s:7:\"tagtext\";s:8:\"بازی\";s:5:\"level\";d:5;s:11:\"tagtext_url\";s:24:\"%D8%A8%D8%A7%D8%B2%DB%8C\";}s:21:\"بدترین بازی\";a:5:{s:5:\"tagid\";s:3:\"117\";s:11:\"searchcount\";s:2:\"34\";s:7:\"tagtext\";s:21:\"بدترین بازی\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:61:\"%D8%A8%D8%AF%D8%AA%D8%B1%DB%8C%D9%86+%D8%A8%D8%A7%D8%B2%DB%8C\";}s:21:\"تالار گفتگو\";a:5:{s:5:\"tagid\";s:2:\"42\";s:11:\"searchcount\";s:2:\"32\";s:7:\"tagtext\";s:21:\"تالار گفتگو\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:61:\"%D8%AA%D8%A7%D9%84%D8%A7%D8%B1+%DA%AF%D9%81%D8%AA%DA%AF%D9%88\";}s:10:\"ترینر\";a:5:{s:5:\"tagid\";s:3:\"444\";s:11:\"searchcount\";s:2:\"40\";s:7:\"tagtext\";s:10:\"ترینر\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:30:\"%D8%AA%D8%B1%DB%8C%D9%86%D8%B1\";}s:12:\"دسکتاپ\";a:5:{s:5:\"tagid\";s:3:\"144\";s:11:\"searchcount\";s:2:\"40\";s:7:\"tagtext\";s:12:\"دسکتاپ\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:36:\"%D8%AF%D8%B3%DA%A9%D8%AA%D8%A7%D9%BE\";}s:10:\"سیستم\";a:5:{s:5:\"tagid\";s:3:\"230\";s:11:\"searchcount\";s:2:\"54\";s:7:\"tagtext\";s:10:\"سیستم\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:30:\"%D8%B3%DB%8C%D8%B3%D8%AA%D9%85\";}s:34:\"عکس کیس های مود شده\";a:5:{s:5:\"tagid\";s:3:\"365\";s:11:\"searchcount\";s:2:\"49\";s:7:\"tagtext\";s:34:\"عکس کیس های مود شده\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:94:\"%D8%B9%DA%A9%D8%B3+%DA%A9%DB%8C%D8%B3+%D9%87%D8%A7%DB%8C+%D9%85%D9%88%D8%AF+%D8%B4%D8%AF%D9%87\";}s:8:\"قیمت\";a:5:{s:5:\"tagid\";s:1:\"3\";s:11:\"searchcount\";s:2:\"53\";s:7:\"tagtext\";s:8:\"قیمت\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:24:\"%D9%82%DB%8C%D9%85%D8%AA\";}s:23:\"مسابقات دوتا\";a:5:{s:5:\"tagid\";s:2:\"87\";s:11:\"searchcount\";s:2:\"33\";s:7:\"tagtext\";s:23:\"مسابقات دوتا\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:67:\"%D9%85%D8%B3%D8%A7%D8%A8%D9%82%D8%A7%D8%AA+%D8%AF%D9%88%D8%AA%D8%A7\";}s:8:\"مشکل\";a:5:{s:5:\"tagid\";s:3:\"437\";s:11:\"searchcount\";s:2:\"37\";s:7:\"tagtext\";s:8:\"مشکل\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:24:\"%D9%85%D8%B4%DA%A9%D9%84\";}s:12:\"موبایل\";a:5:{s:5:\"tagid\";s:1:\"5\";s:11:\"searchcount\";s:2:\"39\";s:7:\"tagtext\";s:12:\"موبایل\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:36:\"%D9%85%D9%88%D8%A8%D8%A7%DB%8C%D9%84\";}s:15:\"میهن گیم\";a:5:{s:5:\"tagid\";s:1:\"8\";s:11:\"searchcount\";s:2:\"57\";s:7:\"tagtext\";s:15:\"میهن گیم\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:43:\"%D9%85%DB%8C%D9%87%D9%86+%DA%AF%DB%8C%D9%85\";}s:12:\"کدتقلب\";a:5:{s:5:\"tagid\";s:3:\"442\";s:11:\"searchcount\";s:2:\"50\";s:7:\"tagtext\";s:12:\"کدتقلب\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:36:\"%DA%A9%D8%AF%D8%AA%D9%82%D9%84%D8%A8\";}s:10:\"گلگسی\";a:5:{s:5:\"tagid\";s:2:\"12\";s:11:\"searchcount\";s:2:\"44\";s:7:\"tagtext\";s:10:\"گلگسی\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:30:\"%DA%AF%D9%84%DA%AF%D8%B3%DB%8C\";}s:6:\"گیم\";a:5:{s:5:\"tagid\";s:2:\"21\";s:11:\"searchcount\";s:2:\"56\";s:7:\"tagtext\";s:6:\"گیم\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:18:\"%DA%AF%DB%8C%D9%85\";}}s:5:\"count\";i:70;s:8:\"dateline\";i:1713512390;}', 1)

Time Before: 0.30824 seconds
Time After: 0.30903 seconds
Time Taken: 0.00080 seconds

Memory Before: 3,428.789 KB
Memory After: 3,412.789 KB
Memory Used: -16.000 KB

SQL Query

UPDATE session
SET lastactivity = 1713512390, location = '/forum/search.php?search_type=1&searchthreadid=961&contenttype=vBForum_Post&explain=1', inforum = 0, badlocation = 0, useragent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
WHERE sessionhash = 'a3bc254ec2e763aed462262cf4a8c9ea'

Time Before: 0.31135 seconds
Time After: 0.31150 seconds
Time Taken: 0.00015 seconds

Memory Before: 3,518.602 KB
Memory After: 3,518.273 KB
Memory Used: -0.328 KB