vBulletin

Including Functions.php

Time Before: 0.00111 seconds
Time After: 0.00145 seconds
Time Taken: 0.00035 seconds

Memory Before: 588.578 KB
Memory After: 701.742 KB
Memory Used: 113.164 KB

Connect to Database on Server: www03.rxmuscle.ml.zerolag.com

Time Before: 0.00152 seconds
Time After: 0.00393 seconds
Time Taken: 0.00241 seconds

Memory Before: 701.742 KB
Memory After: 702.688 KB
Memory Used: 0.945 KB

SQL Query

SET @@sql_mode = ''

Time Before: 0.00417 seconds
Time After: 0.00430 seconds
Time Taken: 0.00013 seconds

Memory Before: 703.352 KB
Memory After: 703.914 KB
Memory Used: 0.563 KB

Datastore Setup

SQL Query

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rxdatastore	range	PRIMARY	PRIMARY	50		18	Using where

Time Before: 0.00501 seconds
Time After: 0.01593 seconds
Time Taken: 0.01092 seconds

Memory Before: 707.133 KB
Memory After: 707.367 KB
Memory Used: 0.234 KB

Time Before: 0.00435 seconds
Time After: 0.02179 seconds
Time Taken: 0.01743 seconds

Memory Before: 703.156 KB
Memory After: 3,281.680 KB
Memory Used: 2,578.523 KB

SQL Query

SELECT *
FROM rxdatastore
WHERE title IN ('profilefield')

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.02312 seconds
Time After: 0.02339 seconds
Time Taken: 0.00028 seconds

Memory Before: 3,743.211 KB
Memory After: 3,743.664 KB
Memory Used: 0.453 KB

Session Handling

SQL Query

SELECT *
FROM rxsession
WHERE userid = 0
	AND host = '172.69.7.54'
	AND idhash = '8d080882e4ca59fb7fdab6b7319eb9ce'
LIMIT 1

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

Time Before: 0.02416 seconds
Time After: 0.02450 seconds
Time Taken: 0.00034 seconds

Memory Before: 3,757.664 KB
Memory After: 3,758.031 KB
Memory Used: 0.367 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 rxlanguage
WHERE languageid = 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rxlanguage	system	PRIMARY				1

Time Before: 0.02539 seconds
Time After: 0.02608 seconds
Time Taken: 0.00068 seconds

Memory Before: 3,769.273 KB
Memory After: 3,768.875 KB
Memory Used: -0.398 KB

Time Before: 0.02357 seconds
Time After: 0.02628 seconds
Time Taken: 0.00272 seconds

Memory Before: 3,750.547 KB
Memory After: 3,894.031 KB
Memory Used: 143.484 KB

SQL Query

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rxstyle	const	PRIMARY	PRIMARY	2	const	1

Time Before: 0.03338 seconds
Time After: 0.03381 seconds
Time Taken: 0.00043 seconds

Memory Before: 4,633.242 KB
Memory After: 4,633.633 KB
Memory Used: 0.391 KB

SQL Query

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

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

Time Before: 0.06827 seconds
Time After: 0.06855 seconds
Time Taken: 0.00028 seconds

Memory Before: 5,533.500 KB
Memory After: 5,533.930 KB
Memory Used: 0.430 KB

SQL Query

SELECT block.*,
	blocktype.productid, blocktype.name AS blocktypename, blocktype.title AS blocktypetitle,
	blocktype.description as blocktypedescription, blocktype.allowcache
FROM rxblock AS block
LEFT JOIN rxblocktype AS blocktype ON (block.blocktypeid = blocktype.blocktypeid)
WHERE 1 AND block.active = 1 AND blocktype.productid IN ('vbulletin','evbs_sstab_advanced','everywhere_sidebar','glowhostspamomatic','hn_masspm','mpdevs_ae_detector','skimlinks','tapatalk','vsachatbox','')
ORDER BY block.displayorder, block.title

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	block	ALL	blocktypeid				7	Using where; Using temporary; Using filesort
1	SIMPLE	blocktype	ALL	PRIMARY,productid				6	Using where; Using join buffer (flat, BNL join)

Time Before: 0.07070 seconds
Time After: 0.07195 seconds
Time Taken: 0.00125 seconds

Memory Before: 5,719.945 KB
Memory After: 5,719.938 KB
Memory Used: -0.008 KB

SQL Query

REPLACE INTO rxdatastore
	(title, data, unserialize)
VALUES
	('activeblocks', 'a:5:{i:7;a:15:{s:7:\"blockid\";s:1:\"7\";s:11:\"blocktypeid\";s:1:\"1\";s:5:\"title\";s:18:\"Dont miss a video!\";s:11:\"description\";s:0:\"\";s:3:\"url\";s:0:\"\";s:8:\"cachettl\";s:2:\"60\";s:12:\"displayorder\";s:1:\"0\";s:6:\"active\";s:1:\"1\";s:11:\"configcache\";s:327:\"a:3:{s:12:\"html_content\";s:226:\"Subscribe to RX on YouTube!
\r\n
\r\n\r\n\r\n
\";s:13:\"html_template\";s:10:\"block_html\";s:9:\"html_type\";s:4:\"html\";}\";s:7:\"product\";s:9:\"vbulletin\";s:9:\"productid\";s:0:\"\";s:13:\"blocktypename\";s:4:\"html\";s:14:\"blocktypetitle\";s:14:\"blocktype_html\";s:20:\"blocktypedescription\";s:0:\"\";s:10:\"allowcache\";s:1:\"1\";}i:1;a:15:{s:7:\"blockid\";s:1:\"1\";s:11:\"blocktypeid\";s:1:\"1\";s:5:\"title\";s:21:\"Visit our Advertisers\";s:11:\"description\";s:0:\"\";s:3:\"url\";s:0:\"\";s:8:\"cachettl\";s:2:\"60\";s:12:\"displayorder\";s:2:\"10\";s:6:\"active\";s:1:\"1\";s:11:\"configcache\";s:881:\"a:3:{s:12:\"html_content\";s:780:\"\r\n\r\n\r\n\r\n\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n
\r\n\r\n\r\n\r\n
\";s:13:\"html_template\";s:10:\"block_html\";s:9:\"html_type\";s:4:\"html\";}\";s:7:\"product\";s:0:\"\";s:9:\"productid\";s:0:\"\";s:13:\"blocktypename\";s:4:\"html\";s:14:\"blocktypetitle\";s:14:\"blocktype_html\";s:20:\"blocktypedescription\";s:0:\"\";s:10:\"allowcache\";s:1:\"1\";}i:5;a:15:{s:7:\"blockid\";s:1:\"5\";s:11:\"blocktypeid\";s:1:\"1\";s:5:\"title\";s:17:\"Social Networking\";s:11:\"description\";s:0:\"\";s:3:\"url\";s:0:\"\";s:8:\"cachettl\";s:2:\"60\";s:12:\"displayorder\";s:2:\"20\";s:6:\"active\";s:1:\"1\";s:11:\"configcache\";s:500:\"a:3:{s:12:\"html_content\";s:399:\"Follow @RXMuscledotcom\r\n\r\n\r\n
\";s:13:\"html_template\";s:10:\"block_html\";s:9:\"html_type\";s:4:\"html\";}\";s:7:\"product\";s:0:\"\";s:9:\"productid\";s:0:\"\";s:13:\"blocktypename\";s:4:\"html\";s:14:\"blocktypetitle\";s:14:\"blocktype_html\";s:20:\"blocktypedescription\";s:0:\"\";s:10:\"allowcache\";s:1:\"1\";}i:3;a:15:{s:7:\"blockid\";s:1:\"3\";s:11:\"blocktypeid\";s:1:\"1\";s:5:\"title\";s:16:\"Ask Dave Palumbo\";s:11:\"description\";s:0:\"\";s:3:\"url\";s:0:\"\";s:8:\"cachettl\";s:2:\"60\";s:12:\"displayorder\";s:2:\"40\";s:6:\"active\";s:1:\"1\";s:11:\"configcache\";s:503:\"a:3:{s:12:\"html_content\";s:402:\"Dave has built his reputation by helping others with his knowledge and experience. 
  Read More!
\";s:13:\"html_template\";s:10:\"block_html\";s:9:\"html_type\";s:4:\"html\";}\";s:7:\"product\";s:0:\"\";s:9:\"productid\";s:0:\"\";s:13:\"blocktypename\";s:4:\"html\";s:14:\"blocktypetitle\";s:14:\"blocktype_html\";s:20:\"blocktypedescription\";s:0:\"\";s:10:\"allowcache\";s:1:\"1\";}i:4;a:15:{s:7:\"blockid\";s:1:\"4\";s:11:\"blocktypeid\";s:1:\"5\";s:5:\"title\";s:21:\"Newly Replied Threads\";s:11:\"description\";s:0:\"\";s:3:\"url\";s:0:\"\";s:8:\"cachettl\";s:2:\"60\";s:12:\"displayorder\";s:2:\"60\";s:6:\"active\";s:1:\"1\";s:11:\"configcache\";s:162:\"a:5:{s:7:\"datecut\";s:2:\"30\";s:16:\"threads_forumids\";a:1:{i:0;i:2;}s:13:\"threads_limit\";s:1:\"5\";s:21:\"threads_titlemaxchars\";s:2:\"35\";s:12:\"threads_type\";s:1:\"1\";}\";s:7:\"product\";s:0:\"\";s:9:\"productid\";s:0:\"\";s:13:\"blocktypename\";s:7:\"threads\";s:14:\"blocktypetitle\";s:17:\"blocktype_threads\";s:20:\"blocktypedescription\";s:0:\"\";s:10:\"allowcache\";s:1:\"1\";}}', 1)

Time Before: 0.07217 seconds
Time After: 0.11513 seconds
Time Taken: 0.04296 seconds

Memory Before: 5,756.195 KB
Memory After: 5,751.594 KB
Memory Used: -4.602 KB

SQL Query

SELECT data, expires, locktime, serialized
FROM rxcache
WHERE cacheid = 'forumblock.7166129774bf76162c1e50ecf5676aa8'

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

Time Before: 0.11605 seconds
Time After: 0.11635 seconds
Time Taken: 0.00031 seconds

Memory Before: 5,767.133 KB
Memory After: 5,767.531 KB
Memory Used: 0.398 KB

SQL Query

SELECT title, template
FROM rxtemplate
WHERE templateid IN (0,11443,11183,11193,11196,11197,11195,11201,11199,11200,11202,11094,11097,11098,11316,11318,11317,11089,11306,11305,11285,11284,11184,11189,11190,11283,10949,10728,10723,11387,11407,977,976,978,973,972,1595,4948,10720,10699,981,982,1600,11122,11396,11068,11072,11069,11070,11071,11426,0,0,11406,11367,11092,11093,11095,11096,11319,11438,11420,11370,11371,10919,10918,10922)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rxtemplate	range	PRIMARY	PRIMARY	4		65	Using where

Time Before: 0.11771 seconds
Time After: 0.13504 seconds
Time Taken: 0.01733 seconds

Memory Before: 5,944.641 KB
Memory After: 5,944.734 KB
Memory Used: 0.094 KB

SQL Query

SELECT template
FROM rxtemplate
WHERE templateid = 10863

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rxtemplate	const	PRIMARY	PRIMARY	4	const	1

Time Before: 0.14426 seconds
Time After: 0.14449 seconds
Time Taken: 0.00024 seconds

Memory Before: 6,163.344 KB
Memory After: 6,163.789 KB
Memory Used: 0.445 KB

SQL Query

SELECT data, expires, locktime, serialized
FROM rxcache
WHERE cacheid = 'forumblock.40e7ad94afacbee2e44b9b7384a76cd0'

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

Time Before: 0.14534 seconds
Time After: 0.14561 seconds
Time Taken: 0.00027 seconds

Memory Before: 6,165.516 KB
Memory After: 6,165.914 KB
Memory Used: 0.398 KB

SQL Query

SELECT data, expires, locktime, serialized
FROM rxcache
WHERE cacheid = 'forumblock.aa9431b777b27af03622ece2c024a466'

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

Time Before: 0.14657 seconds
Time After: 0.14680 seconds
Time Taken: 0.00023 seconds

Memory Before: 6,173.227 KB
Memory After: 6,173.625 KB
Memory Used: 0.398 KB

SQL Query

SELECT data, expires, locktime, serialized
FROM rxcache
WHERE cacheid = 'forumblock.bae1e0dfbae192b45b7ced3092a25f89'

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

Time Before: 0.14780 seconds
Time After: 0.14802 seconds
Time Taken: 0.00023 seconds

Memory Before: 6,180.188 KB
Memory After: 6,180.586 KB
Memory Used: 0.398 KB

SQL Query

SELECT data, expires, locktime, serialized
FROM rxcache
WHERE cacheid = 'forumblock.d4290e27a7eb11481137c1a17fe38416'

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

Time Before: 0.15760 seconds
Time After: 0.15792 seconds
Time Taken: 0.00031 seconds

Memory Before: 6,202.430 KB
Memory After: 6,202.828 KB
Memory Used: 0.398 KB

SQL Query

SELECT template
FROM rxtemplate
WHERE templateid = 10867

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rxtemplate	const	PRIMARY	PRIMARY	4	const	1

Time Before: 0.15930 seconds
Time After: 0.15952 seconds
Time Taken: 0.00023 seconds

Memory Before: 6,293.000 KB
Memory After: 6,293.445 KB
Memory Used: 0.445 KB

SQL Query

SELECT block.*,
	blocktype.productid, blocktype.name AS blocktypename, blocktype.title AS blocktypetitle,
	blocktype.description as blocktypedescription, blocktype.allowcache
FROM rxblock AS block
LEFT JOIN rxblocktype AS blocktype ON (block.blocktypeid = blocktype.blocktypeid)
WHERE 1 AND block.active = 1 AND blocktype.productid IN ('vbulletin','evbs_sstab_advanced','everywhere_sidebar','glowhostspamomatic','hn_masspm','mpdevs_ae_detector','skimlinks','tapatalk','vsachatbox','')
ORDER BY block.displayorder, block.title

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	block	ALL	blocktypeid				7	Using where; Using temporary; Using filesort
1	SIMPLE	blocktype	ALL	PRIMARY,productid				6	Using where; Using join buffer (flat, BNL join)

Time Before: 0.16110 seconds
Time After: 0.16220 seconds
Time Taken: 0.00111 seconds

Memory Before: 6,274.820 KB
Memory After: 6,274.813 KB
Memory Used: -0.008 KB

SQL Query

REPLACE INTO rxdatastore
	(title, data, unserialize)
VALUES
	('activeblocks', 'a:5:{i:7;a:15:{s:7:\"blockid\";s:1:\"7\";s:11:\"blocktypeid\";s:1:\"1\";s:5:\"title\";s:18:\"Dont miss a video!\";s:11:\"description\";s:0:\"\";s:3:\"url\";s:0:\"\";s:8:\"cachettl\";s:2:\"60\";s:12:\"displayorder\";s:1:\"0\";s:6:\"active\";s:1:\"1\";s:11:\"configcache\";s:327:\"a:3:{s:12:\"html_content\";s:226:\"Subscribe to RX on YouTube!
\r\n
\r\n\r\n\r\n
\";s:13:\"html_template\";s:10:\"block_html\";s:9:\"html_type\";s:4:\"html\";}\";s:7:\"product\";s:9:\"vbulletin\";s:9:\"productid\";s:0:\"\";s:13:\"blocktypename\";s:4:\"html\";s:14:\"blocktypetitle\";s:14:\"blocktype_html\";s:20:\"blocktypedescription\";s:0:\"\";s:10:\"allowcache\";s:1:\"1\";}i:1;a:15:{s:7:\"blockid\";s:1:\"1\";s:11:\"blocktypeid\";s:1:\"1\";s:5:\"title\";s:21:\"Visit our Advertisers\";s:11:\"description\";s:0:\"\";s:3:\"url\";s:0:\"\";s:8:\"cachettl\";s:2:\"60\";s:12:\"displayorder\";s:2:\"10\";s:6:\"active\";s:1:\"1\";s:11:\"configcache\";s:881:\"a:3:{s:12:\"html_content\";s:780:\"\r\n\r\n\r\n\r\n\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n
\r\n\r\n\r\n\r\n
\";s:13:\"html_template\";s:10:\"block_html\";s:9:\"html_type\";s:4:\"html\";}\";s:7:\"product\";s:0:\"\";s:9:\"productid\";s:0:\"\";s:13:\"blocktypename\";s:4:\"html\";s:14:\"blocktypetitle\";s:14:\"blocktype_html\";s:20:\"blocktypedescription\";s:0:\"\";s:10:\"allowcache\";s:1:\"1\";}i:5;a:15:{s:7:\"blockid\";s:1:\"5\";s:11:\"blocktypeid\";s:1:\"1\";s:5:\"title\";s:17:\"Social Networking\";s:11:\"description\";s:0:\"\";s:3:\"url\";s:0:\"\";s:8:\"cachettl\";s:2:\"60\";s:12:\"displayorder\";s:2:\"20\";s:6:\"active\";s:1:\"1\";s:11:\"configcache\";s:500:\"a:3:{s:12:\"html_content\";s:399:\"Follow @RXMuscledotcom\r\n\r\n\r\n
\";s:13:\"html_template\";s:10:\"block_html\";s:9:\"html_type\";s:4:\"html\";}\";s:7:\"product\";s:0:\"\";s:9:\"productid\";s:0:\"\";s:13:\"blocktypename\";s:4:\"html\";s:14:\"blocktypetitle\";s:14:\"blocktype_html\";s:20:\"blocktypedescription\";s:0:\"\";s:10:\"allowcache\";s:1:\"1\";}i:3;a:15:{s:7:\"blockid\";s:1:\"3\";s:11:\"blocktypeid\";s:1:\"1\";s:5:\"title\";s:16:\"Ask Dave Palumbo\";s:11:\"description\";s:0:\"\";s:3:\"url\";s:0:\"\";s:8:\"cachettl\";s:2:\"60\";s:12:\"displayorder\";s:2:\"40\";s:6:\"active\";s:1:\"1\";s:11:\"configcache\";s:503:\"a:3:{s:12:\"html_content\";s:402:\"Dave has built his reputation by helping others with his knowledge and experience. 
  Read More!
\";s:13:\"html_template\";s:10:\"block_html\";s:9:\"html_type\";s:4:\"html\";}\";s:7:\"product\";s:0:\"\";s:9:\"productid\";s:0:\"\";s:13:\"blocktypename\";s:4:\"html\";s:14:\"blocktypetitle\";s:14:\"blocktype_html\";s:20:\"blocktypedescription\";s:0:\"\";s:10:\"allowcache\";s:1:\"1\";}i:4;a:15:{s:7:\"blockid\";s:1:\"4\";s:11:\"blocktypeid\";s:1:\"5\";s:5:\"title\";s:21:\"Newly Replied Threads\";s:11:\"description\";s:0:\"\";s:3:\"url\";s:0:\"\";s:8:\"cachettl\";s:2:\"60\";s:12:\"displayorder\";s:2:\"60\";s:6:\"active\";s:1:\"1\";s:11:\"configcache\";s:162:\"a:5:{s:7:\"datecut\";s:2:\"30\";s:16:\"threads_forumids\";a:1:{i:0;i:2;}s:13:\"threads_limit\";s:1:\"5\";s:21:\"threads_titlemaxchars\";s:2:\"35\";s:12:\"threads_type\";s:1:\"1\";}\";s:7:\"product\";s:0:\"\";s:9:\"productid\";s:0:\"\";s:13:\"blocktypename\";s:7:\"threads\";s:14:\"blocktypetitle\";s:17:\"blocktype_threads\";s:20:\"blocktypedescription\";s:0:\"\";s:10:\"allowcache\";s:1:\"1\";}}', 1)

Time Before: 0.16239 seconds
Time After: 0.17329 seconds
Time Taken: 0.01090 seconds

Memory Before: 6,298.742 KB
Memory After: 6,294.141 KB
Memory Used: -4.602 KB

SQL Query

SELECT template
FROM rxtemplate
WHERE templateid = 2265

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rxtemplate	const	PRIMARY	PRIMARY	4	const	1

Time Before: 0.17411 seconds
Time After: 0.17429 seconds
Time Taken: 0.00018 seconds

Memory Before: 6,281.484 KB
Memory After: 6,281.930 KB
Memory Used: 0.445 KB

SQL Query

SELECT hvquestion.questionid, COUNT(*) AS answers
FROM rxhvquestion AS hvquestion
LEFT JOIN rxhvanswer AS hvanswer
	ON (hvquestion.questionid = hvanswer.questionid)
WHERE hvanswer.answerid IS NOT NULL
	OR hvquestion.regex <> ''
GROUP BY hvquestion.questionid
ORDER BY RAND()
LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hvquestion	index		PRIMARY	4		1	Using temporary; Using filesort
1	SIMPLE	hvanswer	ref	questionid	questionid	4	03forums.hvquestion.questionid	1	Using where; Using index

Time Before: 0.17555 seconds
Time After: 0.17582 seconds
Time Taken: 0.00027 seconds

Memory Before: 6,346.016 KB
Memory After: 6,346.227 KB
Memory Used: 0.211 KB

SQL Query

INSERT INTO rxhumanverify
	(hash, answer, dateline)
VALUES
	('5029d8f61bb9f844d2bc78309851cbce', '4', 1714283181)

Time Before: 0.17590 seconds
Time After: 0.18159 seconds
Time Taken: 0.00569 seconds

Memory Before: 6,345.781 KB
Memory After: 6,346.070 KB
Memory Used: 0.289 KB

SQL Query

SELECT text, languageid, special
FROM rxphrase AS phrase
LEFT JOIN rxphrasetype USING (fieldname)
WHERE phrase.fieldname = 'hvquestion'
	AND varname = 'question4'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	phrase	ref	name_lang_type	name_lang_type	252	const	1	Using index condition
1	SIMPLE	rxphrasetype	const	PRIMARY	PRIMARY	20	const	1	Using where

Time Before: 0.18209 seconds
Time After: 0.18238 seconds
Time Taken: 0.00029 seconds

Memory Before: 6,346.414 KB
Memory After: 6,346.766 KB
Memory Used: 0.352 KB

SQL Query

SELECT contenttype.contenttypeid AS itemid
	
FROM rxcontenttype AS contenttype
	INNER JOIN rxpackage AS package
	ON package.packageid = contenttype.packageid LEFT JOIN rxproduct 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	ALL	PRIMARY				1
1	SIMPLE	product	eq_ref	PRIMARY	PRIMARY	27	03forums.package.productid	1	Using where
1	SIMPLE	contenttype	ALL	packageclass				18	Using where; Using join buffer (flat, BNL join)

Time Before: 0.20053 seconds
Time After: 0.22697 seconds
Time Taken: 0.02644 seconds

Memory Before: 6,435.961 KB
Memory After: 6,436.117 KB
Memory Used: 0.156 KB

SQL Query

SELECT prefix.prefixsetid, prefix.prefixid, forumprefixset.forumid
FROM rxprefix AS prefix
	INNER JOIN rxprefixset AS prefixset ON (prefixset.prefixsetid = prefix.prefixsetid)
	INNER JOIN rxforumprefixset 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	prefix	index	prefixsetid	prefixsetid	33		1	Using index; Using temporary; Using filesort
1	SIMPLE	prefixset	eq_ref	PRIMARY	PRIMARY	27	03forums.prefix.prefixsetid	1
1	SIMPLE	forumprefixset	index		PRIMARY	31		1	Using where; Using index; Using join buffer (flat, BNL join)

Time Before: 0.25822 seconds
Time After: 0.27578 seconds
Time Taken: 0.01756 seconds

Memory Before: 6,911.953 KB
Memory After: 6,912.133 KB
Memory Used: 0.180 KB

SQL Query

SELECT hvquestion.questionid, COUNT(*) AS answers
FROM rxhvquestion AS hvquestion
LEFT JOIN rxhvanswer AS hvanswer
	ON (hvquestion.questionid = hvanswer.questionid)
WHERE hvanswer.answerid IS NOT NULL
	OR hvquestion.regex <> ''
GROUP BY hvquestion.questionid
ORDER BY RAND()
LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hvquestion	index		PRIMARY	4		1	Using temporary; Using filesort
1	SIMPLE	hvanswer	ref	questionid	questionid	4	03forums.hvquestion.questionid	1	Using where; Using index

Time Before: 0.27644 seconds
Time After: 0.27668 seconds
Time Taken: 0.00024 seconds

Memory Before: 6,916.398 KB
Memory After: 6,916.617 KB
Memory Used: 0.219 KB

SQL Query

DELETE FROM rxhumanverify WHERE hash = '5029d8f61bb9f844d2bc78309851cbce'

Time Before: 0.27677 seconds
Time After: 0.29532 seconds
Time Taken: 0.01855 seconds

Memory Before: 6,916.328 KB
Memory After: 6,916.656 KB
Memory Used: 0.328 KB

SQL Query

INSERT INTO rxhumanverify
	(hash, answer, dateline)
VALUES
	('90466d1ff725f9f2047cfc1bc1ba331c', '4', 1714283181)

Time Before: 0.29540 seconds
Time After: 0.31493 seconds
Time Taken: 0.01953 seconds

Memory Before: 6,919.313 KB
Memory After: 6,919.602 KB
Memory Used: 0.289 KB

SQL Query

SELECT contenttype.contenttypeid AS itemid
	
FROM rxcontenttype AS contenttype
	INNER JOIN rxpackage AS package
	ON package.packageid = contenttype.packageid LEFT JOIN rxproduct 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	ALL	PRIMARY				1
1	SIMPLE	product	eq_ref	PRIMARY	PRIMARY	27	03forums.package.productid	1	Using where
1	SIMPLE	contenttype	ALL	packageclass				18	Using where; Using join buffer (flat, BNL join)

Time Before: 0.31653 seconds
Time After: 0.31702 seconds
Time Taken: 0.00048 seconds

Memory Before: 6,940.492 KB
Memory After: 6,940.648 KB
Memory Used: 0.156 KB

SQL Query

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

Time Before: 0.33708 seconds
Time After: 0.37495 seconds
Time Taken: 0.03787 seconds

Memory Before: 6,957.594 KB
Memory After: 6,957.922 KB
Memory Used: 0.328 KB

SQL Query

SELECT tag.tagid, tag.tagtext
						FROM rxtag AS tag
					   WHERE tag.tagid IN (16,5,12,2,7,1,4,288,25,129,115,54,8,33,6,32,68,9,31,62,21,18,23,40,44,88,27,36,55,149,114,22,50,26,15,93,17,61,13,43,150,152,63,107,47,65,3,100,73,166,58,41,19,37,34,24,46,20,49,105,81,218,137,52,59,176,83,14,178,35)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tag	index	PRIMARY	tagtext	102		137	Using where; Using index

Time Before: 0.37567 seconds
Time After: 0.38168 seconds
Time Taken: 0.00601 seconds

Memory Before: 6,972.719 KB
Memory After: 6,972.953 KB
Memory Used: 0.234 KB

SQL Query

REPLACE INTO rxdatastore
	(title, data, unserialize)
VALUES
	('searchcloud', 'a:3:{s:4:\"tags\";a:70:{s:11:\"1legmonster\";a:5:{s:5:\"tagid\";s:2:\"20\";s:11:\"searchcount\";s:2:\"74\";s:7:\"tagtext\";s:11:\"1legmonster\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:11:\"1legmonster\";}s:18:\"700 rep challenge!\";a:5:{s:5:\"tagid\";s:2:\"21\";s:11:\"searchcount\";s:2:\"84\";s:7:\"tagtext\";s:18:\"700 rep challenge!\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:20:\"700+rep+challenge%21\";}s:19:\"2018 arnold classic\";a:5:{s:5:\"tagid\";s:2:\"55\";s:11:\"searchcount\";s:2:\"82\";s:7:\"tagtext\";s:19:\"2018 arnold classic\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:19:\"2018+arnold+classic\";}s:15:\"2018 mr olympia\";a:5:{s:5:\"tagid\";s:3:\"288\";s:11:\"searchcount\";s:2:\"95\";s:7:\"tagtext\";s:15:\"2018 mr olympia\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:15:\"2018+mr+olympia\";}s:10:\"ameen alai\";a:5:{s:5:\"tagid\";s:2:\"63\";s:11:\"searchcount\";s:2:\"80\";s:7:\"tagtext\";s:10:\"ameen alai\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:10:\"ameen+alai\";}s:14:\"andre ferguson\";a:5:{s:5:\"tagid\";s:3:\"176\";s:11:\"searchcount\";s:2:\"68\";s:7:\"tagtext\";s:14:\"andre ferguson\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:14:\"andre+ferguson\";}s:12:\"armwrestling\";a:5:{s:5:\"tagid\";s:2:\"18\";s:11:\"searchcount\";s:2:\"84\";s:7:\"tagtext\";s:12:\"armwrestling\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:12:\"armwrestling\";}s:19:\"arnold classic 2018\";a:5:{s:5:\"tagid\";s:3:\"107\";s:11:\"searchcount\";s:2:\"79\";s:7:\"tagtext\";s:19:\"arnold classic 2018\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:19:\"arnold+classic+2018\";}s:7:\"askdave\";a:5:{s:5:\"tagid\";s:2:\"26\";s:11:\"searchcount\";s:2:\"82\";s:7:\"tagtext\";s:7:\"askdave\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:7:\"askdave\";}s:12:\"bader boodai\";a:5:{s:5:\"tagid\";s:2:\"81\";s:11:\"searchcount\";s:2:\"73\";s:7:\"tagtext\";s:12:\"bader boodai\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:12:\"bader+boodai\";}s:9:\"big lenny\";a:5:{s:5:\"tagid\";s:2:\"50\";s:11:\"searchcount\";s:2:\"82\";s:7:\"tagtext\";s:9:\"big lenny\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:9:\"big+lenny\";}s:12:\"bodybuilding\";a:5:{s:5:\"tagid\";s:1:\"8\";s:11:\"searchcount\";s:2:\"88\";s:7:\"tagtext\";s:12:\"bodybuilding\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:12:\"bodybuilding\";}s:11:\"bostin loyd\";a:5:{s:5:\"tagid\";s:3:\"137\";s:11:\"searchcount\";s:2:\"70\";s:7:\"tagtext\";s:11:\"bostin loyd\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:11:\"bostin+loyd\";}s:10:\"brian shaw\";a:5:{s:5:\"tagid\";s:2:\"14\";s:11:\"searchcount\";s:2:\"66\";s:7:\"tagtext\";s:10:\"brian shaw\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:10:\"brian+shaw\";}s:5:\"carbs\";a:5:{s:5:\"tagid\";s:1:\"4\";s:11:\"searchcount\";s:3:\"103\";s:7:\"tagtext\";s:5:\"carbs\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:5:\"carbs\";}s:11:\"chris aceto\";a:5:{s:5:\"tagid\";s:2:\"44\";s:11:\"searchcount\";s:2:\"83\";s:7:\"tagtext\";s:11:\"chris aceto\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:11:\"chris+aceto\";}s:15:\"dallas mccarver\";a:5:{s:5:\"tagid\";s:2:\"34\";s:11:\"searchcount\";s:2:\"74\";s:7:\"tagtext\";s:15:\"dallas mccarver\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:15:\"dallas+mccarver\";}s:16:\"dana linn bailey\";a:5:{s:5:\"tagid\";s:2:\"32\";s:11:\"searchcount\";s:2:\"86\";s:7:\"tagtext\";s:16:\"dana linn bailey\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:16:\"dana+linn+bailey\";}s:13:\"daniel stisen\";a:5:{s:5:\"tagid\";s:3:\"115\";s:11:\"searchcount\";s:2:\"90\";s:7:\"tagtext\";s:13:\"daniel stisen\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:13:\"daniel+stisen\";}s:12:\"dave palumbo\";a:5:{s:5:\"tagid\";s:2:\"25\";s:11:\"searchcount\";s:2:\"92\";s:7:\"tagtext\";s:12:\"dave palumbo\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:12:\"dave+palumbo\";}s:8:\"deadlift\";a:5:{s:5:\"tagid\";s:2:\"17\";s:11:\"searchcount\";s:2:\"82\";s:7:\"tagtext\";s:8:\"deadlift\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:8:\"deadlift\";}s:13:\"dennis hopson\";a:5:{s:5:\"tagid\";s:2:\"93\";s:11:\"searchcount\";s:2:\"82\";s:7:\"tagtext\";s:13:\"dennis hopson\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:13:\"dennis+hopson\";}s:13:\"eugene mishin\";a:5:{s:5:\"tagid\";s:3:\"149\";s:11:\"searchcount\";s:2:\"82\";s:7:\"tagtext\";s:13:\"eugene mishin\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:13:\"eugene+mishin\";}s:3:\"fat\";a:5:{s:5:\"tagid\";s:1:\"5\";s:11:\"searchcount\";s:3:\"172\";s:7:\"tagtext\";s:3:\"fat\";s:5:\"level\";d:5;s:11:\"tagtext_url\";s:3:\"fat\";}s:20:\"finnish bodybuilding\";a:5:{s:5:\"tagid\";s:2:\"23\";s:11:\"searchcount\";s:2:\"84\";s:7:\"tagtext\";s:20:\"finnish bodybuilding\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:20:\"finnish+bodybuilding\";}s:4:\"food\";a:5:{s:5:\"tagid\";s:1:\"1\";s:11:\"searchcount\";s:3:\"104\";s:7:\"tagtext\";s:4:\"food\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:4:\"food\";}s:15:\"guilty pleasure\";a:5:{s:5:\"tagid\";s:2:\"19\";s:11:\"searchcount\";s:2:\"75\";s:7:\"tagtext\";s:15:\"guilty pleasure\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:15:\"guilty+pleasure\";}s:14:\"guy cisternino\";a:5:{s:5:\"tagid\";s:3:\"100\";s:11:\"searchcount\";s:2:\"78\";s:7:\"tagtext\";s:14:\"guy cisternino\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:14:\"guy+cisternino\";}s:4:\"ifbb\";a:5:{s:5:\"tagid\";s:1:\"7\";s:11:\"searchcount\";s:3:\"109\";s:7:\"tagtext\";s:4:\"ifbb\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:4:\"ifbb\";}s:9:\"iron rage\";a:5:{s:5:\"tagid\";s:2:\"88\";s:11:\"searchcount\";s:2:\"83\";s:7:\"tagtext\";s:9:\"iron rage\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:9:\"iron+rage\";}s:14:\"jimmy the bull\";a:5:{s:5:\"tagid\";s:2:\"59\";s:11:\"searchcount\";s:2:\"69\";s:7:\"tagtext\";s:14:\"jimmy the bull\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:14:\"jimmy+the+bull\";}s:11:\"john romano\";a:5:{s:5:\"tagid\";s:2:\"68\";s:11:\"searchcount\";s:2:\"86\";s:7:\"tagtext\";s:11:\"john romano\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:11:\"john+romano\";}s:10:\"kai greene\";a:5:{s:5:\"tagid\";s:2:\"37\";s:11:\"searchcount\";s:2:\"75\";s:7:\"tagtext\";s:10:\"kai greene\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:10:\"kai+greene\";}s:14:\"kamal elgargni\";a:5:{s:5:\"tagid\";s:2:\"65\";s:11:\"searchcount\";s:2:\"79\";s:7:\"tagtext\";s:14:\"kamal elgargni\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:14:\"kamal+elgargni\";}s:13:\"kevin levrone\";a:5:{s:5:\"tagid\";s:2:\"46\";s:11:\"searchcount\";s:2:\"74\";s:7:\"tagtext\";s:13:\"kevin levrone\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:13:\"kevin+levrone\";}s:12:\"larry wheels\";a:5:{s:5:\"tagid\";s:2:\"73\";s:11:\"searchcount\";s:2:\"76\";s:7:\"tagtext\";s:12:\"larry wheels\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:12:\"larry+wheels\";}s:10:\"lee priest\";a:5:{s:5:\"tagid\";s:2:\"52\";s:11:\"searchcount\";s:2:\"69\";s:7:\"tagtext\";s:10:\"lee priest\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:10:\"lee+priest\";}s:9:\"live with\";a:5:{s:5:\"tagid\";s:3:\"114\";s:11:\"searchcount\";s:2:\"82\";s:7:\"tagtext\";s:9:\"live with\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:9:\"live+with\";}s:11:\"matt jansen\";a:5:{s:5:\"tagid\";s:2:\"35\";s:11:\"searchcount\";s:2:\"64\";s:7:\"tagtext\";s:11:\"matt jansen\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:11:\"matt+jansen\";}s:11:\"matt porter\";a:5:{s:5:\"tagid\";s:2:\"36\";s:11:\"searchcount\";s:2:\"83\";s:7:\"tagtext\";s:11:\"matt porter\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:11:\"matt+porter\";}s:5:\"meals\";a:5:{s:5:\"tagid\";s:1:\"2\";s:11:\"searchcount\";s:3:\"109\";s:7:\"tagtext\";s:5:\"meals\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:5:\"meals\";}s:12:\"milos sarcev\";a:5:{s:5:\"tagid\";s:3:\"178\";s:11:\"searchcount\";s:2:\"65\";s:7:\"tagtext\";s:12:\"milos sarcev\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:12:\"milos+sarcev\";}s:14:\"nathan de asha\";a:5:{s:5:\"tagid\";s:3:\"166\";s:11:\"searchcount\";s:2:\"76\";s:7:\"tagtext\";s:14:\"nathan de asha\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:14:\"nathan+de+asha\";}s:13:\"nathan payton\";a:5:{s:5:\"tagid\";s:2:\"15\";s:11:\"searchcount\";s:2:\"82\";s:7:\"tagtext\";s:13:\"nathan payton\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:13:\"nathan+payton\";}s:12:\"nick trigili\";a:5:{s:5:\"tagid\";s:3:\"152\";s:11:\"searchcount\";s:2:\"80\";s:7:\"tagtext\";s:12:\"nick trigili\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:12:\"nick+trigili\";}s:10:\"nordic pro\";a:5:{s:5:\"tagid\";s:2:\"24\";s:11:\"searchcount\";s:2:\"74\";s:7:\"tagtext\";s:10:\"nordic pro\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:10:\"nordic+pro\";}s:3:\"npc\";a:5:{s:5:\"tagid\";s:2:\"12\";s:11:\"searchcount\";s:3:\"169\";s:7:\"tagtext\";s:3:\"npc\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:3:\"npc\";}s:7:\"npc2014\";a:5:{s:5:\"tagid\";s:2:\"13\";s:11:\"searchcount\";s:2:\"81\";s:7:\"tagtext\";s:7:\"npc2014\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:7:\"npc2014\";}s:10:\"phil heath\";a:5:{s:5:\"tagid\";s:3:\"218\";s:11:\"searchcount\";s:2:\"73\";s:7:\"tagtext\";s:10:\"phil heath\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:10:\"phil+heath\";}s:10:\"phoenixpro\";a:5:{s:5:\"tagid\";s:1:\"9\";s:11:\"searchcount\";s:2:\"85\";s:7:\"tagtext\";s:10:\"phoenixpro\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:10:\"phoenixpro\";}s:8:\"physique\";a:5:{s:5:\"tagid\";s:1:\"6\";s:11:\"searchcount\";s:2:\"87\";s:7:\"tagtext\";s:8:\"physique\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:8:\"physique\";}s:12:\"powerlifting\";a:5:{s:5:\"tagid\";s:2:\"33\";s:11:\"searchcount\";s:2:\"87\";s:7:\"tagtext\";s:12:\"powerlifting\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:12:\"powerlifting\";}s:7:\"protein\";a:5:{s:5:\"tagid\";s:1:\"3\";s:11:\"searchcount\";s:2:\"79\";s:7:\"tagtext\";s:7:\"protein\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:7:\"protein\";}s:12:\"robert timms\";a:5:{s:5:\"tagid\";s:2:\"61\";s:11:\"searchcount\";s:2:\"81\";s:7:\"tagtext\";s:12:\"robert timms\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:12:\"robert+timms\";}s:14:\"ronnie coleman\";a:5:{s:5:\"tagid\";s:2:\"47\";s:11:\"searchcount\";s:2:\"79\";s:7:\"tagtext\";s:14:\"ronnie coleman\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:14:\"ronnie+coleman\";}s:12:\"samir troudi\";a:5:{s:5:\"tagid\";s:2:\"49\";s:11:\"searchcount\";s:2:\"73\";s:7:\"tagtext\";s:12:\"samir troudi\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:12:\"samir+troudi\";}s:15:\"santiago aragon\";a:5:{s:5:\"tagid\";s:2:\"54\";s:11:\"searchcount\";s:2:\"90\";s:7:\"tagtext\";s:15:\"santiago aragon\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:15:\"santiago+aragon\";}s:9:\"sara back\";a:5:{s:5:\"tagid\";s:2:\"58\";s:11:\"searchcount\";s:2:\"76\";s:7:\"tagtext\";s:9:\"sara back\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:9:\"sara+back\";}s:14:\"shanique grant\";a:5:{s:5:\"tagid\";s:2:\"31\";s:11:\"searchcount\";s:2:\"85\";s:7:\"tagtext\";s:14:\"shanique grant\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:14:\"shanique+grant\";}s:12:\"shawn rhoden\";a:5:{s:5:\"tagid\";s:2:\"83\";s:11:\"searchcount\";s:2:\"68\";s:7:\"tagtext\";s:12:\"shawn rhoden\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:12:\"shawn+rhoden\";}s:11:\"steve kuclo\";a:5:{s:5:\"tagid\";s:2:\"41\";s:11:\"searchcount\";s:2:\"76\";s:7:\"tagtext\";s:11:\"steve kuclo\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:11:\"steve+kuclo\";}s:7:\"synthol\";a:5:{s:5:\"tagid\";s:2:\"27\";s:11:\"searchcount\";s:2:\"83\";s:7:\"tagtext\";s:7:\"synthol\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:7:\"synthol\";}s:15:\"terrence ruffin\";a:5:{s:5:\"tagid\";s:2:\"62\";s:11:\"searchcount\";s:2:\"84\";s:7:\"tagtext\";s:15:\"terrence ruffin\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:15:\"terrence+ruffin\";}s:9:\"tom platz\";a:5:{s:5:\"tagid\";s:2:\"43\";s:11:\"searchcount\";s:2:\"80\";s:7:\"tagtext\";s:9:\"tom platz\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:9:\"tom+platz\";}s:9:\"tony huge\";a:5:{s:5:\"tagid\";s:3:\"105\";s:11:\"searchcount\";s:2:\"73\";s:7:\"tagtext\";s:9:\"tony huge\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:9:\"tony+huge\";}s:15:\"victor martinez\";a:5:{s:5:\"tagid\";s:3:\"150\";s:11:\"searchcount\";s:2:\"80\";s:7:\"tagtext\";s:15:\"victor martinez\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:15:\"victor+martinez\";}s:14:\"wesley vissers\";a:5:{s:5:\"tagid\";s:3:\"129\";s:11:\"searchcount\";s:2:\"92\";s:7:\"tagtext\";s:14:\"wesley vissers\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:14:\"wesley+vissers\";}s:13:\"william bonac\";a:5:{s:5:\"tagid\";s:2:\"40\";s:11:\"searchcount\";s:2:\"84\";s:7:\"tagtext\";s:13:\"william bonac\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:13:\"william+bonac\";}s:21:\"worst in bodybuilding\";a:5:{s:5:\"tagid\";s:2:\"22\";s:11:\"searchcount\";s:2:\"82\";s:7:\"tagtext\";s:21:\"worst in bodybuilding\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:21:\"worst+in+bodybuilding\";}s:3:\"wsm\";a:5:{s:5:\"tagid\";s:2:\"16\";s:11:\"searchcount\";s:3:\"186\";s:7:\"tagtext\";s:3:\"wsm\";s:5:\"level\";d:5;s:11:\"tagtext_url\";s:3:\"wsm\";}}s:5:\"count\";i:70;s:8:\"dateline\";i:1714283181;}', 1)

Time Before: 0.38297 seconds
Time After: 0.40358 seconds
Time Taken: 0.02061 seconds

Memory Before: 7,055.891 KB
Memory After: 7,043.719 KB
Memory Used: -12.172 KB

SQL Query

UPDATE rxsession
SET lastactivity = 1714283181, location = '/search.php?search_type=1&contenttype=vBForum_Post&forumchoice[]=27&explain=1', incalendar = 0, badlocation = 0
WHERE sessionhash = '075fc9f2b1b4cdb14ed4cfe257fd8cf3'

Time Before: 0.41225 seconds
Time After: 0.41246 seconds
Time Taken: 0.00022 seconds

Memory Before: 7,391.375 KB
Memory After: 7,391.570 KB
Memory Used: 0.195 KB