vBulletin

Including Functions.php

Time Before: 0.00019 seconds
Time After: 0.00022 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.00040 seconds
Time Taken: 0.00015 seconds

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

SQL Query

SET @@sql_mode = ''

Time Before: 0.00047 seconds
Time After: 0.00056 seconds
Time Taken: 0.00009 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.00079 seconds
Time After: 0.00089 seconds
Time Taken: 0.00010 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.00221 seconds
Time Taken: 0.00164 seconds

Memory Before: 463.516 KB
Memory After: 1,322.484 KB
Memory Used: 858.969 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.00264 seconds
Time After: 0.00268 seconds
Time Taken: 0.00004 seconds

Memory Before: 1,480.039 KB
Memory After: 1,496.109 KB
Memory Used: 16.070 KB

Session Handling

SQL Query

SELECT *
FROM session
WHERE userid = 0
	AND host = '52.14.130.13'
	AND idhash = 'bc01f8b450d54011c554a9bb88a57bfc'
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.00294 seconds
Time After: 0.00307 seconds
Time Taken: 0.00013 seconds

Memory Before: 1,484.859 KB
Memory After: 1,501.555 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.00357 seconds
Time After: 0.00365 seconds
Time Taken: 0.00007 seconds

Memory Before: 1,491.195 KB
Memory After: 1,876.055 KB
Memory Used: 384.859 KB

Time Before: 0.00272 seconds
Time After: 0.00370 seconds
Time Taken: 0.00098 seconds

Memory Before: 1,481.383 KB
Memory After: 1,684.805 KB
Memory Used: 203.422 KB

SQL Query

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

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

Time Before: 0.00508 seconds
Time After: 0.00561 seconds
Time Taken: 0.00054 seconds

Memory Before: 1,949.836 KB
Memory After: 1,966.047 KB
Memory Used: 16.211 KB

SQL Query

UPDATE vsavilxh_guests
SET dateline = '1713564486'
WHERE userip = '52.14.130.13'

Time Before: 0.00563 seconds
Time After: 0.00631 seconds
Time Taken: 0.00068 seconds

Memory Before: 1,966.195 KB
Memory After: 1,966.180 KB
Memory Used: -0.016 KB

SQL Query

DELETE FROM vsavilxh_guests WHERE dateline < '1713478086'

Time Before: 0.00633 seconds
Time After: 0.00670 seconds
Time Taken: 0.00037 seconds

Memory Before: 1,949.492 KB
Memory After: 1,949.477 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.00689 seconds
Time After: 0.00696 seconds
Time Taken: 0.00007 seconds

Memory Before: 1,939.891 KB
Memory After: 2,148.539 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.00861 seconds
Time After: 0.00868 seconds
Time Taken: 0.00007 seconds

Memory Before: 2,624.594 KB
Memory After: 2,640.977 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.00944 seconds
Time After: 0.00953 seconds
Time Taken: 0.00009 seconds

Memory Before: 2,774.516 KB
Memory After: 3,058.133 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.01002 seconds
Time After: 0.01006 seconds
Time Taken: 0.00005 seconds

Memory Before: 3,069.320 KB
Memory After: 3,087.063 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.01140 seconds
Time After: 0.01145 seconds
Time Taken: 0.00004 seconds

Memory Before: 3,116.141 KB
Memory After: 3,132.477 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 (2280)
		AND userid = 0
	GROUP BY threadid
) AS lastpost ON (lastpost.threadid = thread.threadid)
WHERE thread.threadid IN (2280)

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		ALL					2	Using where
2	DERIVED	post	ref	userid,threadid,threadid_visible_dateline,user_date	threadid	8	const,const	1

Time Before: 0.01259 seconds
Time After: 0.01320 seconds
Time Taken: 0.00061 seconds

Memory Before: 3,255.742 KB
Memory After: 3,287.555 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.01516 seconds
Time After: 0.01520 seconds
Time Taken: 0.00005 seconds

Memory Before: 3,306.219 KB
Memory After: 3,322.023 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.01564 seconds
Time After: 0.01568 seconds
Time Taken: 0.00003 seconds

Memory Before: 3,308.641 KB
Memory After: 3,324.852 KB
Memory Used: 16.211 KB

SQL Query

SELECT tagsearch.tagid, COUNT(*) AS searchcount
FROM tagsearch AS tagsearch
WHERE tagsearch.dateline > 1710972486
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		5527	Using index condition; Using temporary; Using filesort

Time Before: 0.01591 seconds
Time After: 0.01947 seconds
Time Taken: 0.00356 seconds

Memory Before: 3,310.398 KB
Memory After: 3,330.234 KB
Memory Used: 19.836 KB

SQL Query

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

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.01969 seconds
Time After: 0.01993 seconds
Time Taken: 0.00024 seconds

Memory Before: 3,342.945 KB
Memory After: 3,363.000 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:\"47\";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:\"44\";s:7:\"tagtext\";s:4:\"820m\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:4:\"820m\";}s:5:\"alexa\";a:5:{s:5:\"tagid\";s:3:\"331\";s:11:\"searchcount\";s:2:\"68\";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:\"65\";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:\"43\";s:7:\"tagtext\";s:7:\"android\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:7:\"android\";}s:3:\"app\";a:5:{s:5:\"tagid\";s:3:\"301\";s:11:\"searchcount\";s:2:\"62\";s:7:\"tagtext\";s:3:\"app\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:3:\"app\";}s:5:\"apple\";a:5:{s:5:\"tagid\";s:2:\"65\";s:11:\"searchcount\";s:2:\"56\";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:\"67\";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:\"48\";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:\"62\";s:7:\"tagtext\";s:4:\"case\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:4:\"case\";}s:4:\"ddr4\";a:5:{s:5:\"tagid\";s:3:\"237\";s:11:\"searchcount\";s:2:\"57\";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:\"71\";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:\"44\";s:7:\"tagtext\";s:7:\"digital\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:7:\"digital\";}s:5:\"error\";a:5:{s:5:\"tagid\";s:3:\"224\";s:11:\"searchcount\";s:2:\"64\";s:7:\"tagtext\";s:5:\"error\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:5:\"error\";}s:4:\"game\";a:5:{s:5:\"tagid\";s:2:\"45\";s:11:\"searchcount\";s:2:\"45\";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:\"61\";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:\"44\";s:7:\"tagtext\";s:3:\"gpu\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:3:\"gpu\";}s:5:\"gta v\";a:5:{s:5:\"tagid\";s:3:\"145\";s:11:\"searchcount\";s:2:\"45\";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:\"57\";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:\"58\";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:\"45\";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:\"66\";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:\"45\";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:\"49\";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:\"47\";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:\"77\";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:\"63\";s:7:\"tagtext\";s:6:\"mobile\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:6:\"mobile\";}s:3:\"msi\";a:5:{s:5:\"tagid\";s:3:\"217\";s:11:\"searchcount\";s:2:\"61\";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:\"41\";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:\"47\";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:\"66\";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:\"62\";s:7:\"tagtext\";s:9:\"pc gaming\";s:5:\"level\";d:4;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:\"60\";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:\"43\";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:\"72\";s:7:\"tagtext\";s:3:\"ps3\";s:5:\"level\";d:5;s:11:\"tagtext_url\";s:3:\"ps3\";}s:3:\"ps4\";a:5:{s:5:\"tagid\";s:2:\"35\";s:11:\"searchcount\";s:2:\"57\";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:\"69\";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:\"61\";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:\"54\";s:7:\"tagtext\";s:6:\"saints\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:6:\"saints\";}s:7:\"samsung\";a:5:{s:5:\"tagid\";s:2:\"66\";s:11:\"searchcount\";s:2:\"62\";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:\"60\";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:\"69\";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:\"53\";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:\"40\";s:7:\"tagtext\";s:8:\"tearaway\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:8:\"tearaway\";}s:12:\"the division\";a:5:{s:5:\"tagid\";s:3:\"151\";s:11:\"searchcount\";s:2:\"38\";s:7:\"tagtext\";s:12:\"the division\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:12:\"the+division\";}s:7:\"toshina\";a:5:{s:5:\"tagid\";s:3:\"218\";s:11:\"searchcount\";s:2:\"46\";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:\"67\";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:\"41\";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:10:\"ultra book\";a:5:{s:5:\"tagid\";s:3:\"215\";s:11:\"searchcount\";s:2:\"48\";s:7:\"tagtext\";s:10:\"ultra book\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:10:\"ultra+book\";}s:9:\"ultrabook\";a:5:{s:5:\"tagid\";s:3:\"256\";s:11:\"searchcount\";s:2:\"68\";s:7:\"tagtext\";s:9:\"ultrabook\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:9:\"ultrabook\";}s:3:\"wii\";a:5:{s:5:\"tagid\";s:2:\"80\";s:11:\"searchcount\";s:2:\"66\";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:\"46\";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:\"45\";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:\"64\";s:7:\"tagtext\";s:8:\"xbox one\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:8:\"xbox+one\";}s:7:\"yakuza0\";a:5:{s:5:\"tagid\";s:3:\"419\";s:11:\"searchcount\";s:2:\"37\";s:7:\"tagtext\";s:7:\"yakuza0\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:7:\"yakuza0\";}s:10:\"انجمن\";a:5:{s:5:\"tagid\";s:2:\"43\";s:11:\"searchcount\";s:2:\"56\";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:\"73\";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:\"39\";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:10:\"ترینر\";a:5:{s:5:\"tagid\";s:3:\"444\";s:11:\"searchcount\";s:2:\"47\";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:\"51\";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:\"63\";s:7:\"tagtext\";s:10:\"سیستم\";s:5:\"level\";d:4;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:\"59\";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:\"62\";s:7:\"tagtext\";s:8:\"قیمت\";s:5:\"level\";d:4;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:\"39\";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:\"44\";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:\"46\";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:\"67\";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:\"59\";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:\"50\";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:\"65\";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:1713564486;}', 1)

Time Before: 0.02021 seconds
Time After: 0.02059 seconds
Time Taken: 0.00038 seconds

Memory Before: 3,426.992 KB
Memory After: 3,410.992 KB
Memory Used: -16.000 KB

SQL Query

UPDATE session
SET lastactivity = 1713564486, location = '/forum/search.php?search_type=1&searchthreadid=2280&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 = 'c571438c588e9cf67899a1c65a46da1e'

Time Before: 0.02214 seconds
Time After: 0.02226 seconds
Time Taken: 0.00012 seconds

Memory Before: 3,516.805 KB
Memory After: 3,516.477 KB
Memory Used: -0.328 KB