vBulletin

Including Functions.php

Time Before: 0.00036 seconds
Time After: 0.00050 seconds
Time Taken: 0.00015 seconds

Memory Before: 508.063 KB
Memory After: 532.773 KB
Memory Used: 24.711 KB

Connect to Database on Server: 127.0.0.1

Time Before: 0.00052 seconds
Time After: 0.00096 seconds
Time Taken: 0.00044 seconds

Memory Before: 532.711 KB
Memory After: 533.625 KB
Memory Used: 0.914 KB

SQL Query

SET @@sql_mode = ''

Time Before: 0.00110 seconds
Time After: 0.00120 seconds
Time Taken: 0.00010 seconds

Memory Before: 534.180 KB
Memory After: 534.703 KB
Memory Used: 0.523 KB

Datastore Setup

SQL Query

SELECT *
FROM datastore
WHERE title IN ('tagcloud','iconcache','navdata','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream','routes')

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	datastore		range	PRIMARY	PRIMARY	52		18	100.00	Using index condition

Time Before: 0.00160 seconds
Time After: 0.00304 seconds
Time Taken: 0.00145 seconds

Memory Before: 537.711 KB
Memory After: 538.602 KB
Memory Used: 0.891 KB

Time Before: 0.00122 seconds
Time After: 0.00471 seconds
Time Taken: 0.00349 seconds

Memory Before: 533.953 KB
Memory After: 2,878.836 KB
Memory Used: 2,344.883 KB

Session Handling

SQL Query

SELECT *
FROM session
WHERE userid = 0
	AND host = '3.140.195.28'
	AND idhash = 'a110cb93eaa471f923a81db53a750a51'
LIMIT 1

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	session		ref	guest_lookup,user_activity	guest_lookup	51	const,const,const	2	100.00

Time Before: 0.00534 seconds
Time After: 0.00550 seconds
Time Taken: 0.00016 seconds

Memory Before: 3,376.742 KB
Memory After: 3,377.375 KB
Memory Used: 0.633 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 = 1

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	language		system	PRIMARY				1	100.00

Time Before: 0.00593 seconds
Time After: 0.00617 seconds
Time Taken: 0.00025 seconds

Memory Before: 3,389.477 KB
Memory After: 3,389.469 KB
Memory Used: -0.008 KB

Time Before: 0.00501 seconds
Time After: 0.00625 seconds
Time Taken: 0.00124 seconds

Memory Before: 3,369.141 KB
Memory After: 3,451.469 KB
Memory Used: 82.328 KB

SQL Query

SELECT MAX(permissions & 1) AS perm
FROM cms_permissions
WHERE nodeid = 1 AND usergroupid IN (1)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cms_permissions		const	usergroupid,nodeid	usergroupid	8	const,const	1	100.00

Time Before: 0.00739 seconds
Time After: 0.00752 seconds
Time Taken: 0.00013 seconds

Memory Before: 3,831.367 KB
Memory After: 3,831.898 KB
Memory Used: 0.531 KB

SQL Query

SELECT *
FROM style
WHERE (styleid = 20 AND userselect = 1)
	OR styleid = 20
ORDER BY styleid ASC
LIMIT 1

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	style		const	PRIMARY	PRIMARY	2	const	1	100.00

Time Before: 0.01129 seconds
Time After: 0.01152 seconds
Time Taken: 0.00023 seconds

Memory Before: 3,835.313 KB
Memory After: 3,835.938 KB
Memory Used: 0.625 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	filtered	Extra
1	SIMPLE	package	ALL	PRIMARY				3	100.00
1	SIMPLE	product	eq_ref	PRIMARY	PRIMARY	27	xapexspeed.package.productid	1	100.00	Using where
1	SIMPLE	contenttype	ref	packageclass	packageclass	4	xapexspeed.package.packageid	9	50.00	Using where

Time Before: 0.02175 seconds
Time After: 0.02199 seconds
Time Taken: 0.00023 seconds

Memory Before: 4,619.063 KB
Memory After: 4,619.344 KB
Memory Used: 0.281 KB

SQL Query

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

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

Time Before: 0.02506 seconds
Time After: 0.02524 seconds
Time Taken: 0.00018 seconds

Memory Before: 4,735.633 KB
Memory After: 4,736.172 KB
Memory Used: 0.539 KB

SQL Query

SELECT data.tagid, SUM(data.searchcount) AS searchcount
FROM
	(
SELECT tagcontent.tagid, COUNT(*) AS searchcount
FROM tagcontent AS tagcontent INNER JOIN thread AS thread ON (tagcontent.contentid = thread.threadid)
WHERE tagcontent.contenttypeid IN (2) AND
	tagcontent.dateline > 1687047920 AND thread.open <> 10 AND thread.visible = 1 AND thread.forumid IN (197,50,51,54,136,180,12,52,143,101,26,111,142,222,229,80,122,57,199,53,118,228,240,246,178,243,245,66,244,105,104,79,174,55,134,230,231,188,112,186,187,200,81,88,82,13,84,58,83,164,87,184,185,201,95,96,97,98,99,202,106,100,125,107,108,109,203,90,91,92,93,94,204,153,124,170,154,173,155,156,205,3,9,123,10,18,11,146,141,147,223,133,44,103,119,37,20,206,4,22,23,32,24,33,126,127,226,128,34,35,207,73,74,78,76,77,208,176,144,129,145,210,209,67,68,117,151,221,171,172,157,150,70,69,72,71,102,211,5,38,42,224,225,41,63,212,8,48,59,49,61,213,167,168,169,193,194,198,158,159,160,161,162,219,234,165,235,236,113,179,131,115,114,192,189,149,116,152,177,190,130,135,196,148,120,121)
GROUP BY tagcontent.tagid
				 UNION ALL 
SELECT tagcontent.tagid, COUNT(*) AS searchcount
FROM tagcontent AS tagcontent JOIN cms_node AS cms_node ON
			tagcontent.contenttypeid = cms_node.contenttypeid AND tagcontent.contentid = cms_node.contentid
		
WHERE tagcontent.contenttypeid IN (24,26) AND
	tagcontent.dateline > 1687047920 AND cms_node.publishdate < 1718583920
GROUP BY tagcontent.tagid
				) AS data
GROUP BY data.tagid
ORDER BY searchcount DESC
LIMIT 70

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY		ALL					84	100.00	Using temporary; Using filesort
2	DERIVED	tagcontent	range	PRIMARY,id_type_user,dateline	dateline	4		949	10.00	Using index condition; Using where; Using temporary
2	DERIVED	thread	eq_ref	PRIMARY,forumid,forumid_lastpost	PRIMARY	4	xapexspeed.tagcontent.contentid	1	87.07	Using where
3	UNION	cms_node	range	contentid,contenttype,publishdate	contentid	4		4	83.33	Using index condition; Using where; Using temporary
3	UNION	tagcontent	ref	PRIMARY,id_type_user,dateline	id_type_user	8	xapexspeed.cms_node.contentid,xapexspeed.cms_node.contenttypeid	3	12.22	Using where

Time Before: 0.02750 seconds
Time After: 0.02934 seconds
Time Taken: 0.00184 seconds

Memory Before: 4,838.570 KB
Memory After: 4,839.273 KB
Memory Used: 0.703 KB

SQL Query

SELECT tag.tagid, tag.tagtext
						FROM tag AS tag
					   WHERE tag.tagid IN (50,89,20,45,122,3016,703,193,203,1414,2437,112,51,881,2674,46,3074,3065,593,41,1640,1465,847,2012,3123,1567,8,12,979,1729,24,1544,3061,35,1172,501,3038,3059,79,3075,1276,3076,76,3057,3056,3055,3133,3053,404,2319,1674,707,2876,219,946,100,283,3063,3062,3037,1658,2483,3073,3064,3068,3067,3060,3071,3072,3069)

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

Time Before: 0.02986 seconds
Time After: 0.03019 seconds
Time Taken: 0.00032 seconds

Memory Before: 4,850.242 KB
Memory After: 4,852.109 KB
Memory Used: 1.867 KB

SQL Query

REPLACE INTO datastore
	(title, data, unserialize)
VALUES
	('tagcloud', 'a:3:{s:4:\"tags\";a:70:{s:6:\"2liter\";a:5:{s:5:\"tagid\";s:4:\"3075\";s:11:\"searchcount\";s:1:\"1\";s:7:\"tagtext\";s:6:\"2liter\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:6:\"2liter\";}s:13:\"92 euro swift\";a:5:{s:5:\"tagid\";s:4:\"3073\";s:11:\"searchcount\";s:1:\"1\";s:7:\"tagtext\";s:13:\"92 euro swift\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:13:\"92+euro+swift\";}s:12:\"1996 runoffs\";a:5:{s:5:\"tagid\";s:4:\"3055\";s:11:\"searchcount\";s:1:\"1\";s:7:\"tagtext\";s:12:\"1996 runoffs\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:12:\"1996+runoffs\";}s:3:\"bir\";a:5:{s:5:\"tagid\";s:4:\"3071\";s:11:\"searchcount\";s:1:\"1\";s:7:\"tagtext\";s:3:\"bir\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:3:\"bir\";}s:12:\"bm autocross\";a:5:{s:5:\"tagid\";s:4:\"3068\";s:11:\"searchcount\";s:1:\"1\";s:7:\"tagtext\";s:12:\"bm autocross\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:12:\"bm+autocross\";}s:10:\"brake pads\";a:5:{s:5:\"tagid\";s:4:\"1465\";s:11:\"searchcount\";s:1:\"2\";s:7:\"tagtext\";s:10:\"brake pads\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:10:\"brake+pads\";}s:9:\"bruce may\";a:5:{s:5:\"tagid\";s:4:\"3056\";s:11:\"searchcount\";s:1:\"1\";s:7:\"tagtext\";s:9:\"bruce may\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:9:\"bruce+may\";}s:4:\"bt29\";a:5:{s:5:\"tagid\";s:4:\"3062\";s:11:\"searchcount\";s:1:\"1\";s:7:\"tagtext\";s:4:\"bt29\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:4:\"bt29\";}s:20:\"contingency stickers\";a:5:{s:5:\"tagid\";s:4:\"3057\";s:11:\"searchcount\";s:1:\"1\";s:7:\"tagtext\";s:20:\"contingency stickers\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:20:\"contingency+stickers\";}s:3:\"db1\";a:5:{s:5:\"tagid\";s:2:\"79\";s:11:\"searchcount\";s:1:\"1\";s:7:\"tagtext\";s:3:\"db1\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:3:\"db1\";}s:3:\"dp2\";a:5:{s:5:\"tagid\";s:4:\"3072\";s:11:\"searchcount\";s:1:\"1\";s:7:\"tagtext\";s:3:\"dp2\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:3:\"dp2\";}s:10:\"elden mk10\";a:5:{s:5:\"tagid\";s:4:\"3133\";s:11:\"searchcount\";s:1:\"1\";s:7:\"tagtext\";s:10:\"elden mk10\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:10:\"elden+mk10\";}s:11:\"electrathon\";a:5:{s:5:\"tagid\";s:4:\"3061\";s:11:\"searchcount\";s:1:\"2\";s:7:\"tagtext\";s:11:\"electrathon\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:11:\"electrathon\";}s:13:\"electromotive\";a:5:{s:5:\"tagid\";s:3:\"501\";s:11:\"searchcount\";s:1:\"1\";s:7:\"tagtext\";s:13:\"electromotive\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:13:\"electromotive\";}s:9:\"ev racing\";a:5:{s:5:\"tagid\";s:4:\"3060\";s:11:\"searchcount\";s:1:\"1\";s:7:\"tagtext\";s:9:\"ev racing\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:9:\"ev+racing\";}s:5:\"f1000\";a:5:{s:5:\"tagid\";s:2:\"89\";s:11:\"searchcount\";s:1:\"4\";s:7:\"tagtext\";s:5:\"f1000\";s:5:\"level\";d:5;s:11:\"tagtext_url\";s:5:\"f1000\";}s:5:\"f1600\";a:5:{s:5:\"tagid\";s:3:\"703\";s:11:\"searchcount\";s:1:\"3\";s:7:\"tagtext\";s:5:\"f1600\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:5:\"f1600\";}s:6:\"fc2000\";a:5:{s:5:\"tagid\";s:4:\"1414\";s:11:\"searchcount\";s:1:\"2\";s:7:\"tagtext\";s:6:\"fc2000\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:6:\"fc2000\";}s:9:\"ford 109e\";a:5:{s:5:\"tagid\";s:4:\"1674\";s:11:\"searchcount\";s:1:\"1\";s:7:\"tagtext\";s:9:\"ford 109e\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:9:\"ford+109e\";}s:9:\"ford kent\";a:5:{s:5:\"tagid\";s:4:\"3016\";s:11:\"searchcount\";s:1:\"3\";s:7:\"tagtext\";s:9:\"ford kent\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:9:\"ford+kent\";}s:7:\"formula\";a:5:{s:5:\"tagid\";s:2:\"35\";s:11:\"searchcount\";s:1:\"2\";s:7:\"tagtext\";s:7:\"formula\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:7:\"formula\";}s:12:\"formula 1000\";a:5:{s:5:\"tagid\";s:4:\"1544\";s:11:\"searchcount\";s:1:\"2\";s:7:\"tagtext\";s:12:\"formula 1000\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:12:\"formula+1000\";}s:12:\"formula 2000\";a:5:{s:5:\"tagid\";s:4:\"1276\";s:11:\"searchcount\";s:1:\"1\";s:7:\"tagtext\";s:12:\"formula 2000\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:12:\"formula+2000\";}s:16:\"formula atlantic\";a:5:{s:5:\"tagid\";s:3:\"193\";s:11:\"searchcount\";s:1:\"3\";s:7:\"tagtext\";s:16:\"formula atlantic\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:16:\"formula+atlantic\";}s:9:\"formula b\";a:5:{s:5:\"tagid\";s:3:\"283\";s:11:\"searchcount\";s:1:\"1\";s:7:\"tagtext\";s:9:\"formula b\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:9:\"formula+b\";}s:12:\"formula ford\";a:5:{s:5:\"tagid\";s:2:\"45\";s:11:\"searchcount\";s:1:\"3\";s:7:\"tagtext\";s:12:\"formula ford\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:12:\"formula+ford\";}s:10:\"formula jr\";a:5:{s:5:\"tagid\";s:4:\"2319\";s:11:\"searchcount\";s:1:\"1\";s:7:\"tagtext\";s:10:\"formula jr\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:10:\"formula+jr\";}s:11:\"formula vee\";a:5:{s:5:\"tagid\";s:2:\"51\";s:11:\"searchcount\";s:1:\"2\";s:7:\"tagtext\";s:11:\"formula vee\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:11:\"formula+vee\";}s:15:\"fv open trailer\";a:5:{s:5:\"tagid\";s:4:\"3064\";s:11:\"searchcount\";s:1:\"1\";s:7:\"tagtext\";s:15:\"fv open trailer\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:15:\"fv+open+trailer\";}s:6:\"gasket\";a:5:{s:5:\"tagid\";s:4:\"3123\";s:11:\"searchcount\";s:1:\"2\";s:7:\"tagtext\";s:6:\"gasket\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:6:\"gasket\";}s:7:\"gaskets\";a:5:{s:5:\"tagid\";s:2:\"24\";s:11:\"searchcount\";s:1:\"2\";s:7:\"tagtext\";s:7:\"gaskets\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:7:\"gaskets\";}s:7:\"gearbox\";a:5:{s:5:\"tagid\";s:2:\"12\";s:11:\"searchcount\";s:1:\"2\";s:7:\"tagtext\";s:7:\"gearbox\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:7:\"gearbox\";}s:7:\"hewland\";a:5:{s:5:\"tagid\";s:3:\"112\";s:11:\"searchcount\";s:1:\"2\";s:7:\"tagtext\";s:7:\"hewland\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:7:\"hewland\";}s:5:\"libre\";a:5:{s:5:\"tagid\";s:4:\"3076\";s:11:\"searchcount\";s:1:\"1\";s:7:\"tagtext\";s:5:\"libre\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:5:\"libre\";}s:8:\"long box\";a:5:{s:5:\"tagid\";s:4:\"3063\";s:11:\"searchcount\";s:1:\"1\";s:7:\"tagtext\";s:8:\"long box\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:8:\"long+box\";}s:9:\"minnesota\";a:5:{s:5:\"tagid\";s:4:\"3069\";s:11:\"searchcount\";s:1:\"1\";s:7:\"tagtext\";s:9:\"minnesota\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:9:\"minnesota\";}s:23:\"motorsports spares int.\";a:5:{s:5:\"tagid\";s:4:\"3059\";s:11:\"searchcount\";s:1:\"1\";s:7:\"tagtext\";s:23:\"motorsports spares int.\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:23:\"motorsports+spares+int.\";}s:19:\"open wheel race car\";a:5:{s:5:\"tagid\";s:4:\"2876\";s:11:\"searchcount\";s:1:\"1\";s:7:\"tagtext\";s:19:\"open wheel race car\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:19:\"open+wheel+race+car\";}s:14:\"p1 sport racer\";a:5:{s:5:\"tagid\";s:4:\"3067\";s:11:\"searchcount\";s:1:\"1\";s:7:\"tagtext\";s:14:\"p1 sport racer\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:14:\"p1+sport+racer\";}s:3:\"pfm\";a:5:{s:5:\"tagid\";s:3:\"946\";s:11:\"searchcount\";s:1:\"1\";s:7:\"tagtext\";s:3:\"pfm\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:3:\"pfm\";}s:17:\"pro formula mazda\";a:5:{s:5:\"tagid\";s:3:\"219\";s:11:\"searchcount\";s:1:\"1\";s:7:\"tagtext\";s:17:\"pro formula mazda\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:17:\"pro+formula+mazda\";}s:17:\"racecar transport\";a:5:{s:5:\"tagid\";s:4:\"3037\";s:11:\"searchcount\";s:1:\"1\";s:7:\"tagtext\";s:17:\"racecar transport\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:17:\"racecar+transport\";}s:6:\"racing\";a:5:{s:5:\"tagid\";s:3:\"847\";s:11:\"searchcount\";s:1:\"2\";s:7:\"tagtext\";s:6:\"racing\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:6:\"racing\";}s:10:\"rain tires\";a:5:{s:5:\"tagid\";s:2:\"41\";s:11:\"searchcount\";s:1:\"2\";s:7:\"tagtext\";s:10:\"rain tires\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:10:\"rain+tires\";}s:4:\"ralt\";a:5:{s:5:\"tagid\";s:3:\"593\";s:11:\"searchcount\";s:1:\"2\";s:7:\"tagtext\";s:4:\"ralt\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:4:\"ralt\";}s:9:\"ralt rt-4\";a:5:{s:5:\"tagid\";s:4:\"2674\";s:11:\"searchcount\";s:1:\"2\";s:7:\"tagtext\";s:9:\"ralt rt-4\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:9:\"ralt+rt-4\";}s:7:\"renault\";a:5:{s:5:\"tagid\";s:4:\"1172\";s:11:\"searchcount\";s:1:\"1\";s:7:\"tagtext\";s:7:\"renault\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:7:\"renault\";}s:4:\"rf97\";a:5:{s:5:\"tagid\";s:4:\"1729\";s:11:\"searchcount\";s:1:\"2\";s:7:\"tagtext\";s:4:\"rf97\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:4:\"rf97\";}s:6:\"roller\";a:5:{s:5:\"tagid\";s:2:\"46\";s:11:\"searchcount\";s:1:\"2\";s:7:\"tagtext\";s:6:\"roller\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:6:\"roller\";}s:4:\"rt-4\";a:5:{s:5:\"tagid\";s:4:\"3074\";s:11:\"searchcount\";s:1:\"2\";s:7:\"tagtext\";s:4:\"rt-4\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:4:\"rt-4\";}s:3:\"rt4\";a:5:{s:5:\"tagid\";s:4:\"1640\";s:11:\"searchcount\";s:1:\"2\";s:7:\"tagtext\";s:3:\"rt4\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:3:\"rt4\";}s:7:\"runoffs\";a:5:{s:5:\"tagid\";s:3:\"100\";s:11:\"searchcount\";s:1:\"1\";s:7:\"tagtext\";s:7:\"runoffs\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:7:\"runoffs\";}s:4:\"seat\";a:5:{s:5:\"tagid\";s:3:\"881\";s:11:\"searchcount\";s:1:\"2\";s:7:\"tagtext\";s:4:\"seat\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:4:\"seat\";}s:6:\"shocks\";a:5:{s:5:\"tagid\";s:3:\"707\";s:11:\"searchcount\";s:1:\"1\";s:7:\"tagtext\";s:6:\"shocks\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:6:\"shocks\";}s:12:\"sports racer\";a:5:{s:5:\"tagid\";s:3:\"979\";s:11:\"searchcount\";s:1:\"2\";s:7:\"tagtext\";s:12:\"sports racer\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:12:\"sports+racer\";}s:3:\"srf\";a:5:{s:5:\"tagid\";s:2:\"76\";s:11:\"searchcount\";s:1:\"1\";s:7:\"tagtext\";s:3:\"srf\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:3:\"srf\";}s:9:\"stohr wf1\";a:5:{s:5:\"tagid\";s:4:\"3065\";s:11:\"searchcount\";s:1:\"2\";s:7:\"tagtext\";s:9:\"stohr wf1\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:9:\"stohr+wf1\";}s:10:\"suspension\";a:5:{s:5:\"tagid\";s:3:\"122\";s:11:\"searchcount\";s:1:\"3\";s:7:\"tagtext\";s:10:\"suspension\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:10:\"suspension\";}s:5:\"swift\";a:5:{s:5:\"tagid\";s:1:\"8\";s:11:\"searchcount\";s:1:\"2\";s:7:\"tagtext\";s:5:\"swift\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:5:\"swift\";}s:13:\"tiga bodywork\";a:5:{s:5:\"tagid\";s:4:\"2483\";s:11:\"searchcount\";s:1:\"1\";s:7:\"tagtext\";s:13:\"tiga bodywork\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:13:\"tiga+bodywork\";}s:14:\"tires for sale\";a:5:{s:5:\"tagid\";s:4:\"1567\";s:11:\"searchcount\";s:1:\"2\";s:7:\"tagtext\";s:14:\"tires for sale\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:14:\"tires+for+sale\";}s:10:\"valve gear\";a:5:{s:5:\"tagid\";s:4:\"3053\";s:11:\"searchcount\";s:1:\"1\";s:7:\"tagtext\";s:10:\"valve gear\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:10:\"valve+gear\";}s:10:\"van diemen\";a:5:{s:5:\"tagid\";s:2:\"50\";s:11:\"searchcount\";s:1:\"4\";s:7:\"tagtext\";s:10:\"van diemen\";s:5:\"level\";d:5;s:11:\"tagtext_url\";s:10:\"van+diemen\";}s:7:\"vintage\";a:5:{s:5:\"tagid\";s:3:\"203\";s:11:\"searchcount\";s:1:\"3\";s:7:\"tagtext\";s:7:\"vintage\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:7:\"vintage\";}s:3:\"vir\";a:5:{s:5:\"tagid\";s:4:\"2437\";s:11:\"searchcount\";s:1:\"2\";s:7:\"tagtext\";s:3:\"vir\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:3:\"vir\";}s:4:\"wets\";a:5:{s:5:\"tagid\";s:4:\"2012\";s:11:\"searchcount\";s:1:\"2\";s:7:\"tagtext\";s:4:\"wets\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:4:\"wets\";}s:6:\"wheels\";a:5:{s:5:\"tagid\";s:2:\"20\";s:11:\"searchcount\";s:1:\"4\";s:7:\"tagtext\";s:6:\"wheels\";s:5:\"level\";d:5;s:11:\"tagtext_url\";s:6:\"wheels\";}s:15:\"wheels for sale\";a:5:{s:5:\"tagid\";s:3:\"404\";s:11:\"searchcount\";s:1:\"1\";s:7:\"tagtext\";s:15:\"wheels for sale\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:15:\"wheels+for+sale\";}s:10:\"wide track\";a:5:{s:5:\"tagid\";s:4:\"1658\";s:11:\"searchcount\";s:1:\"1\";s:7:\"tagtext\";s:10:\"wide track\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:10:\"wide+track\";}s:3:\"xdi\";a:5:{s:5:\"tagid\";s:4:\"3038\";s:11:\"searchcount\";s:1:\"1\";s:7:\"tagtext\";s:3:\"xdi\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:3:\"xdi\";}}s:5:\"count\";i:70;s:8:\"dateline\";i:1718583920;}', 1)

Time Before: 0.03080 seconds
Time After: 0.03348 seconds
Time Taken: 0.00268 seconds

Memory Before: 4,910.172 KB
Memory After: 4,898.570 KB
Memory Used: -11.602 KB

SQL Query

SELECT title, template
FROM template
WHERE templateid IN (0,6247,6818,0,6000,6001,6120,6122,6121,5893,6110,6109,6089,6087,6090,5753,6608,6606,6609,6211,4538,4537,4539,4534,4533,5615,5616,7020,6840,4542,4543,5620,5926,6200,6585,6586,5873,5874,5875,6230,0,0,6210,6171,5896,5897,5899,5900,6123,6242,6224,6174,6175,5723,5722,5726,6667,6625,6635,6633,6632)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	template		range	PRIMARY	PRIMARY	4		58	100.00	Using index condition

Time Before: 0.03439 seconds
Time After: 0.03493 seconds
Time Taken: 0.00054 seconds

Memory Before: 5,079.375 KB
Memory After: 5,080.953 KB
Memory Used: 1.578 KB

SQL Query

UPDATE session
SET lastactivity = 1718583920, location = '/tags.php?explain=1', badlocation = 0, useragent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
WHERE sessionhash = '22fc738d295e69ab22a1fa54a1f76864'

Time Before: 0.04055 seconds
Time After: 0.04250 seconds
Time Taken: 0.00195 seconds

Memory Before: 5,494.391 KB
Memory After: 5,494.508 KB
Memory Used: 0.117 KB