vBulletin

Including Functions.php

Time Before: 0.00021 seconds
Time After: 0.00024 seconds
Time Taken: 0.00003 seconds

Memory Before: 461.961 KB
Memory After: 463.883 KB
Memory Used: 1.922 KB

Connect to Database on Server: localhost

Time Before: 0.00026 seconds
Time After: 0.00039 seconds
Time Taken: 0.00012 seconds

Memory Before: 463.859 KB
Memory After: 464.438 KB
Memory Used: 0.578 KB

SQL Query

SET @@sql_mode = ''

Time Before: 0.00048 seconds
Time After: 0.00054 seconds
Time Taken: 0.00007 seconds

Memory Before: 464.461 KB
Memory After: 464.516 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.00077 seconds
Time After: 0.00117 seconds
Time Taken: 0.00040 seconds

Memory Before: 466.750 KB
Memory After: 1,023.617 KB
Memory Used: 556.867 KB

Time Before: 0.00055 seconds
Time After: 0.00260 seconds
Time Taken: 0.00205 seconds

Memory Before: 464.281 KB
Memory After: 1,322.398 KB
Memory Used: 858.117 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.00292 seconds
Time After: 0.00301 seconds
Time Taken: 0.00009 seconds

Memory Before: 1,479.953 KB
Memory After: 1,496.023 KB
Memory Used: 16.070 KB

Session Handling

SQL Query

SELECT *
FROM session
WHERE userid = 0
	AND host = '3.17.74.227'
	AND idhash = '056a9225c68027a7657fde7f9c3d09b4'
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.00338 seconds
Time After: 0.00356 seconds
Time Taken: 0.00018 seconds

Memory Before: 1,484.773 KB
Memory After: 1,501.469 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.00405 seconds
Time After: 0.00419 seconds
Time Taken: 0.00014 seconds

Memory Before: 1,491.141 KB
Memory After: 1,876.000 KB
Memory Used: 384.859 KB

Time Before: 0.00309 seconds
Time After: 0.00424 seconds
Time Taken: 0.00115 seconds

Memory Before: 1,481.297 KB
Memory After: 1,684.750 KB
Memory Used: 203.453 KB

SQL Query

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

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

Time Before: 0.00587 seconds
Time After: 0.00639 seconds
Time Taken: 0.00052 seconds

Memory Before: 1,949.430 KB
Memory After: 1,965.672 KB
Memory Used: 16.242 KB

SQL Query

UPDATE vsavilxh_guests
SET dateline = '1714163226'
WHERE userip = '3.17.74.227'

Time Before: 0.00641 seconds
Time After: 0.00742 seconds
Time Taken: 0.00100 seconds

Memory Before: 1,965.820 KB
Memory After: 1,965.805 KB
Memory Used: -0.016 KB

SQL Query

DELETE FROM vsavilxh_guests WHERE dateline < '1714076826'

Time Before: 0.00744 seconds
Time After: 0.00794 seconds
Time Taken: 0.00050 seconds

Memory Before: 1,949.117 KB
Memory After: 1,949.102 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.00817 seconds
Time After: 0.00824 seconds
Time Taken: 0.00008 seconds

Memory Before: 1,939.516 KB
Memory After: 2,148.164 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.01004 seconds
Time After: 0.01008 seconds
Time Taken: 0.00004 seconds

Memory Before: 2,624.219 KB
Memory After: 2,640.602 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.01093 seconds
Time After: 0.01110 seconds
Time Taken: 0.00017 seconds

Memory Before: 2,773.117 KB
Memory After: 3,056.734 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.01185 seconds
Time After: 0.01190 seconds
Time Taken: 0.00005 seconds

Memory Before: 3,067.922 KB
Memory After: 3,085.664 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.01327 seconds
Time After: 0.01332 seconds
Time Taken: 0.00005 seconds

Memory Before: 3,102.789 KB
Memory After: 3,119.125 KB
Memory Used: 16.336 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.01733 seconds
Time After: 0.01736 seconds
Time Taken: 0.00003 seconds

Memory Before: 3,284.203 KB
Memory After: 3,300.008 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.01795 seconds
Time After: 0.01800 seconds
Time Taken: 0.00005 seconds

Memory Before: 3,300.789 KB
Memory After: 3,317.000 KB
Memory Used: 16.211 KB

SQL Query

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

Time Before: 0.01826 seconds
Time After: 0.02590 seconds
Time Taken: 0.00764 seconds

Memory Before: 3,302.547 KB
Memory After: 3,322.383 KB
Memory Used: 19.836 KB

SQL Query

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

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.02617 seconds
Time After: 0.02645 seconds
Time Taken: 0.00029 seconds

Memory Before: 3,335.094 KB
Memory After: 3,355.148 KB
Memory Used: 20.055 KB

SQL Query

REPLACE INTO datastore
	(title, data, unserialize)
VALUES
	('searchcloud', 'a:3:{s:4:\"tags\";a:70:{s:4:\"820m\";a:5:{s:5:\"tagid\";s:3:\"279\";s:11:\"searchcount\";s:3:\"101\";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:3:\"131\";s:7:\"tagtext\";s:5:\"alexa\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:5:\"alexa\";}s:9:\"alienware\";a:5:{s:5:\"tagid\";s:3:\"219\";s:11:\"searchcount\";s:2:\"90\";s:7:\"tagtext\";s:9:\"alienware\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:9:\"alienware\";}s:3:\"amd\";a:5:{s:5:\"tagid\";s:2:\"81\";s:11:\"searchcount\";s:3:\"128\";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:\"95\";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:3:\"121\";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:3:\"118\";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:3:\"139\";s:7:\"tagtext\";s:4:\"asus\";s:5:\"level\";d:5;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:3:\"105\";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:3:\"122\";s:7:\"tagtext\";s:4:\"case\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:4:\"case\";}s:3:\"cpu\";a:5:{s:5:\"tagid\";s:2:\"55\";s:11:\"searchcount\";s:2:\"89\";s:7:\"tagtext\";s:3:\"cpu\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:3:\"cpu\";}s:4:\"ddr4\";a:5:{s:5:\"tagid\";s:3:\"237\";s:11:\"searchcount\";s:3:\"124\";s:7:\"tagtext\";s:4:\"ddr4\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:4:\"ddr4\";}s:4:\"dell\";a:5:{s:5:\"tagid\";s:3:\"222\";s:11:\"searchcount\";s:3:\"135\";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:\"98\";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:3:\"134\";s:7:\"tagtext\";s:5:\"error\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:5:\"error\";}s:7:\"fujitsu\";a:5:{s:5:\"tagid\";s:3:\"220\";s:11:\"searchcount\";s:2:\"92\";s:7:\"tagtext\";s:7:\"fujitsu\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:7:\"fujitsu\";}s:4:\"game\";a:5:{s:5:\"tagid\";s:2:\"45\";s:11:\"searchcount\";s:3:\"103\";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:3:\"125\";s:7:\"tagtext\";s:8:\"gigabyte\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:8:\"gigabyte\";}s:3:\"gpu\";a:5:{s:5:\"tagid\";s:2:\"56\";s:11:\"searchcount\";s:2:\"93\";s:7:\"tagtext\";s:3:\"gpu\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:3:\"gpu\";}s:3:\"gta\";a:5:{s:5:\"tagid\";s:2:\"46\";s:11:\"searchcount\";s:2:\"92\";s:7:\"tagtext\";s:3:\"gta\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:3:\"gta\";}s:5:\"gta v\";a:5:{s:5:\"tagid\";s:3:\"145\";s:11:\"searchcount\";s:3:\"100\";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:3:\"117\";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:3:\"108\";s:7:\"tagtext\";s:3:\"hdd\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:3:\"hdd\";}s:9:\"headphone\";a:5:{s:5:\"tagid\";s:3:\"298\";s:11:\"searchcount\";s:2:\"93\";s:7:\"tagtext\";s:9:\"headphone\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:9:\"headphone\";}s:5:\"intel\";a:5:{s:5:\"tagid\";s:2:\"83\";s:11:\"searchcount\";s:3:\"130\";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:\"93\";s:7:\"tagtext\";s:10:\"isdone.dll\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:10:\"isdone.dll\";}s:6:\"laptop\";a:5:{s:5:\"tagid\";s:2:\"52\";s:11:\"searchcount\";s:2:\"98\";s:7:\"tagtext\";s:6:\"laptop\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:6:\"laptop\";}s:5:\"mihan\";a:5:{s:5:\"tagid\";s:3:\"332\";s:11:\"searchcount\";s:3:\"143\";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:3:\"131\";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:3:\"128\";s:7:\"tagtext\";s:3:\"msi\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:3:\"msi\";}s:8:\"nintendo\";a:5:{s:5:\"tagid\";s:2:\"78\";s:11:\"searchcount\";s:2:\"89\";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:3:\"105\";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:3:\"133\";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:3:\"122\";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:3:\"125\";s:7:\"tagtext\";s:13:\"pizza trainer\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:13:\"pizza+trainer\";}s:3:\"ps3\";a:5:{s:5:\"tagid\";s:2:\"34\";s:11:\"searchcount\";s:3:\"133\";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:3:\"108\";s:7:\"tagtext\";s:3:\"ps4\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:3:\"ps4\";}s:3:\"ram\";a:5:{s:5:\"tagid\";s:2:\"57\";s:11:\"searchcount\";s:3:\"126\";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:3:\"122\";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:3:\"110\";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:3:\"129\";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:3:\"124\";s:7:\"tagtext\";s:7:\"seagate\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:7:\"seagate\";}s:4:\"sony\";a:5:{s:5:\"tagid\";s:2:\"67\";s:11:\"searchcount\";s:3:\"126\";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:3:\"106\";s:7:\"tagtext\";s:6:\"tablet\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:6:\"tablet\";}s:7:\"toshina\";a:5:{s:5:\"tagid\";s:3:\"218\";s:11:\"searchcount\";s:2:\"96\";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:3:\"133\";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:\"99\";s:7:\"tagtext\";s:30:\"tungle،تانگل،اموزش\";s:5:\"level\";d:2;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:3:\"106\";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:3:\"131\";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:3:\"126\";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:\"95\";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:\"91\";s:7:\"tagtext\";s:7:\"xbox360\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:7:\"xbox360\";}s:8:\"xbox one\";a:5:{s:5:\"tagid\";s:2:\"36\";s:11:\"searchcount\";s:3:\"127\";s:7:\"tagtext\";s:8:\"xbox one\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:8:\"xbox+one\";}s:5:\"zotac\";a:5:{s:5:\"tagid\";s:3:\"269\";s:11:\"searchcount\";s:2:\"90\";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:3:\"115\";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:3:\"138\";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:10:\"ترینر\";a:5:{s:5:\"tagid\";s:3:\"444\";s:11:\"searchcount\";s:3:\"100\";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:8:\"خرید\";a:5:{s:5:\"tagid\";s:2:\"58\";s:11:\"searchcount\";s:2:\"88\";s:7:\"tagtext\";s:8:\"خرید\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:24:\"%D8%AE%D8%B1%DB%8C%D8%AF\";}s:12:\"دسکتاپ\";a:5:{s:5:\"tagid\";s:3:\"144\";s:11:\"searchcount\";s:3:\"113\";s:7:\"tagtext\";s:12:\"دسکتاپ\";s:5:\"level\";d:3;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:3:\"128\";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:6:\"عکس\";a:5:{s:5:\"tagid\";s:3:\"364\";s:11:\"searchcount\";s:2:\"89\";s:7:\"tagtext\";s:6:\"عکس\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:18:\"%D8%B9%DA%A9%D8%B3\";}s:34:\"عکس کیس های مود شده\";a:5:{s:5:\"tagid\";s:3:\"365\";s:11:\"searchcount\";s:3:\"131\";s:7:\"tagtext\";s:34:\"عکس کیس های مود شده\";s:5:\"level\";d:4;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:3:\"124\";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:12:\"مشاوره\";a:5:{s:5:\"tagid\";s:2:\"59\";s:11:\"searchcount\";s:2:\"93\";s:7:\"tagtext\";s:12:\"مشاوره\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:36:\"%D9%85%D8%B4%D8%A7%D9%88%D8%B1%D9%87\";}s:8:\"مشکل\";a:5:{s:5:\"tagid\";s:3:\"437\";s:11:\"searchcount\";s:2:\"96\";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:\"98\";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:3:\"129\";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:3:\"125\";s:7:\"tagtext\";s:12:\"کدتقلب\";s:5:\"level\";d:4;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:3:\"103\";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:3:\"135\";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:1714163226;}', 1)

Time Before: 0.02692 seconds
Time After: 0.02750 seconds
Time Taken: 0.00058 seconds

Memory Before: 3,419.195 KB
Memory After: 3,403.195 KB
Memory Used: -16.000 KB

SQL Query

UPDATE session
SET lastactivity = 1714163226, location = '/forum/search.php?search_type=1&contenttype=vBForum_Post&forumchoice%5B%5D=136&explain=1', inforum = 0, inthread = 0, badlocation = 0, useragent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
WHERE sessionhash = '6efe01f2d04dd160620759292229d90f'

Time Before: 0.02917 seconds
Time After: 0.02933 seconds
Time Taken: 0.00016 seconds

Memory Before: 3,508.875 KB
Memory After: 3,508.672 KB
Memory Used: -0.203 KB