vBulletin

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

Session Handling

SQL Query

SELECT *
FROM rxsession
WHERE userid = 0
	AND host = '172.69.59.213'
	AND idhash = '12b03c22c59f2e9090dd02a3e908f77d'
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.01221 seconds
Time After: 0.01238 seconds
Time Taken: 0.00016 seconds

Memory Before: 3,911.977 KB
Memory After: 3,912.344 KB
Memory Used: 0.367 KB

SQL Query

SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_threadmanage AS phrasegroup_threadmanage,
			phrasegroup_posting AS phrasegroup_posting,
			phrasegroup_postbit AS phrasegroup_postbit,
			phrasegroup_reputationlevel AS phrasegroup_reputationlevel,
			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.01308 seconds
Time After: 0.01336 seconds
Time Taken: 0.00028 seconds

Memory Before: 3,925.273 KB
Memory After: 3,924.938 KB
Memory Used: -0.336 KB

Time Before: 0.01183 seconds
Time After: 0.01348 seconds
Time Taken: 0.00166 seconds

Memory Before: 3,904.922 KB
Memory After: 4,002.281 KB
Memory Used: 97.359 KB

SQL Query

SELECT post.*,
IF(post.visible = 2, 1, 0) AS isdeleted,


editlog.userid AS edit_userid, editlog.dateline AS edit_dateline, editlog.reason AS edit_reason, editlog.hashistory

FROM rxpost AS post

LEFT JOIN rxeditlog AS editlog ON (editlog.postid = post.postid)

WHERE post.postid = 2040885 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	post	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	editlog	const	PRIMARY	PRIMARY	4	const	0	unique row not found

Time Before: 0.01728 seconds
Time After: 0.01746 seconds
Time Taken: 0.00019 seconds

Memory Before: 4,421.047 KB
Memory After: 4,421.242 KB
Memory Used: 0.195 KB

SQL Query

SELECT IF(thread.visible = 2, 1, 0) AS isdeleted,


NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed, emailupdate, folderid,
post.pagetext AS description,
thread.*


FROM rxthread AS thread

LEFT JOIN rxsubscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = 0  AND subscribethread.canview = 1)


LEFT JOIN rxpost AS post ON(post.postid = thread.firstpostid)


WHERE thread.threadid = 125602 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	thread	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	subscribethread	const	threadid,userid	threadid	8	const,const	0	unique row not found
1	SIMPLE	post	const	PRIMARY	PRIMARY	4	const	1

Time Before: 0.03234 seconds
Time After: 0.03263 seconds
Time Taken: 0.00030 seconds

Memory Before: 4,430.672 KB
Memory After: 4,430.688 KB
Memory Used: 0.016 KB

SQL Query

SELECT *
FROM rxstyle
WHERE (styleid = 21)
	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.03500 seconds
Time After: 0.03526 seconds
Time Taken: 0.00026 seconds

Memory Before: 4,612.094 KB
Memory After: 4,612.508 KB
Memory Used: 0.414 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.03776 seconds
Time After: 0.03884 seconds
Time Taken: 0.00109 seconds

Memory Before: 5,311.305 KB
Memory After: 5,311.297 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.03902 seconds
Time After: 0.07501 seconds
Time Taken: 0.03599 seconds

Memory Before: 5,347.594 KB
Memory After: 5,342.992 KB
Memory Used: -4.602 KB

SQL Query

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

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.07620 seconds
Time After: 0.07634 seconds
Time Taken: 0.00015 seconds

Memory Before: 5,400.852 KB
Memory After: 5,401.250 KB
Memory Used: 0.398 KB

SQL Query

UPDATE rxcache
SET locktime = 1714282140
WHERE cacheid = 'forumblock.8563566ea61cf9077825cedd2d3aabab'

Time Before: 0.07642 seconds
Time After: 0.08329 seconds
Time Taken: 0.00687 seconds

Memory Before: 5,402.133 KB
Memory After: 5,402.422 KB
Memory Used: 0.289 KB

SQL Query

REPLACE INTO rxcache
SET cacheid = 'forumblock.8563566ea61cf9077825cedd2d3aabab',
	expires = 1714285740,
	created = 1714282140,
	locktime = 0,
	data = "Subscribe to RX on YouTube!
\r\n
\r\n\r\n\r\n",
	serialized = '0'

Time Before: 0.08340 seconds
Time After: 0.10643 seconds
Time Taken: 0.02304 seconds

Memory Before: 5,403.781 KB
Memory After: 5,403.766 KB
Memory Used: -0.016 KB

SQL Query

SELECT title, template
FROM rxtemplate
WHERE templateid IN (11087,11078,11088,11089,11090,11079,10951,10952,10954,10960,10959,11154,11158,11144,11145,11147,11146,11153,11156,10851,10853,10855,10857,10859,0,10923,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,10906,10911,10907,10913,10914,10909,10910,10912,11085,11080,11083,11084,11164,11165,11086,11081,11377)

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

Time Before: 0.10770 seconds
Time After: 0.11893 seconds
Time Taken: 0.01123 seconds

Memory Before: 5,588.141 KB
Memory After: 5,588.133 KB
Memory Used: -0.008 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.12419 seconds
Time After: 0.12432 seconds
Time Taken: 0.00014 seconds

Memory Before: 5,772.688 KB
Memory After: 5,773.133 KB
Memory Used: 0.445 KB

SQL Query

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

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.12493 seconds
Time After: 0.12508 seconds
Time Taken: 0.00015 seconds

Memory Before: 5,774.453 KB
Memory After: 5,774.852 KB
Memory Used: 0.398 KB

SQL Query

UPDATE rxcache
SET locktime = 1714282140
WHERE cacheid = 'forumblock.bb9601351543967872080f0b34449532'

Time Before: 0.12515 seconds
Time After: 0.13326 seconds
Time Taken: 0.00811 seconds

Memory Before: 5,775.938 KB
Memory After: 5,776.227 KB
Memory Used: 0.289 KB

SQL Query

REPLACE INTO rxcache
SET cacheid = 'forumblock.bb9601351543967872080f0b34449532',
	expires = 1714285740,
	created = 1714282140,
	locktime = 0,
	data = "\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
",
	serialized = '0'

Time Before: 0.13337 seconds
Time After: 0.14157 seconds
Time Taken: 0.00820 seconds

Memory Before: 5,777.906 KB
Memory After: 5,777.273 KB
Memory Used: -0.633 KB

SQL Query

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

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.14240 seconds
Time After: 0.14254 seconds
Time Taken: 0.00014 seconds

Memory Before: 5,781.938 KB
Memory After: 5,782.336 KB
Memory Used: 0.398 KB

SQL Query

UPDATE rxcache
SET locktime = 1714282140
WHERE cacheid = 'forumblock.6c7eb6d79364be1a36f022f55c5ebfbc'

Time Before: 0.14262 seconds
Time After: 0.14989 seconds
Time Taken: 0.00728 seconds

Memory Before: 5,783.047 KB
Memory After: 5,783.336 KB
Memory Used: 0.289 KB

SQL Query

REPLACE INTO rxcache
SET cacheid = 'forumblock.6c7eb6d79364be1a36f022f55c5ebfbc',
	expires = 1714285740,
	created = 1714282140,
	locktime = 0,
	data = "Follow @RXMuscledotcom\r\n\r\n\r\n",
	serialized = '0'

Time Before: 0.15000 seconds
Time After: 0.15823 seconds
Time Taken: 0.00823 seconds

Memory Before: 5,784.063 KB
Memory After: 5,783.867 KB
Memory Used: -0.195 KB

SQL Query

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

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.15906 seconds
Time After: 0.15920 seconds
Time Taken: 0.00014 seconds

Memory Before: 5,789.055 KB
Memory After: 5,789.453 KB
Memory Used: 0.398 KB

SQL Query

UPDATE rxcache
SET locktime = 1714282140
WHERE cacheid = 'forumblock.3358d45ae7868324d5cc7fe787665687'

Time Before: 0.15929 seconds
Time After: 0.16655 seconds
Time Taken: 0.00726 seconds

Memory Before: 5,790.172 KB
Memory After: 5,790.461 KB
Memory Used: 0.289 KB

SQL Query

REPLACE INTO rxcache
SET cacheid = 'forumblock.3358d45ae7868324d5cc7fe787665687',
	expires = 1714285740,
	created = 1714282140,
	locktime = 0,
	data = "Dave has built his reputation by helping others with his knowledge and experience. 
  Read More!",
	serialized = '0'

Time Before: 0.16665 seconds
Time After: 0.17488 seconds
Time Taken: 0.00824 seconds

Memory Before: 5,791.180 KB
Memory After: 5,790.992 KB
Memory Used: -0.188 KB

SQL Query

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

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.17582 seconds
Time After: 0.17601 seconds
Time Taken: 0.00019 seconds

Memory Before: 5,811.430 KB
Memory After: 5,811.828 KB
Memory Used: 0.398 KB

SQL Query

UPDATE rxcache
SET locktime = 1714282140
WHERE cacheid = 'forumblock.b9d8854250dadec0fc32344d68174fa3'

Time Before: 0.17615 seconds
Time After: 0.18323 seconds
Time Taken: 0.00708 seconds

Memory Before: 5,868.617 KB
Memory After: 5,868.906 KB
Memory Used: 0.289 KB

SQL Query

SELECT thread.threadid, thread.title, thread.prefixid, post.attach,
	thread.postusername, thread.dateline, thread.lastpostid, thread.lastpost AS threadlastpost, thread.lastposterid, thread.lastposter, thread.replycount,
	forum.forumid, forum.title_clean as forumtitle,
	post.pagetext AS message, post.allowsmilie, post.postid,
	user.*
	,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM rxthread AS thread
INNER JOIN rxforum AS forum ON(forum.forumid = thread.forumid)
LEFT JOIN rxpost AS post ON (post.postid = thread.firstpostid)
LEFT JOIN rxuser AS user ON (thread.postuserid = user.userid)
LEFT JOIN rxavatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN rxcustomavatar AS customavatar ON(customavatar.userid = user.userid)
			WHERE 1=1
AND thread.forumid IN(2)
AND thread.visible = 1
AND post.visible = 1
AND open <> 10
 AND thread.lastpost > 1711690140


			ORDER BY thread.lastpost DESC
			LIMIT 0,5

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	forum	const	PRIMARY	PRIMARY	2	const	1
1	SIMPLE	thread	range	forumid,forumid_lastpost,lastpost	forumid_lastpost	6		2	Using where
1	SIMPLE	user	eq_ref	PRIMARY	PRIMARY	4	03forums.thread.postuserid	1
1	SIMPLE	avatar	eq_ref	PRIMARY	PRIMARY	2	03forums.user.avatarid	1	Using where
1	SIMPLE	customavatar	eq_ref	PRIMARY	PRIMARY	4	03forums.user.userid	1	Using where
1	SIMPLE	post	eq_ref	PRIMARY	PRIMARY	4	03forums.thread.firstpostid	1	Using where

Time Before: 0.18484 seconds
Time After: 0.18594 seconds
Time Taken: 0.00110 seconds

Memory Before: 5,817.031 KB
Memory After: 5,816.461 KB
Memory Used: -0.570 KB

SQL Query

REPLACE INTO rxcache
SET cacheid = 'forumblock.b9d8854250dadec0fc32344d68174fa3',
	expires = 1714285740,
	created = 1714282140,
	locktime = 0,
	data = "a:2:{i:151384;a:104:{s:8:\"threadid\";s:6:\"151384\";s:5:\"title\";s:11:\"PFA Central\";s:8:\"prefixid\";s:0:\"\";s:6:\"attach\";s:1:\"0\";s:12:\"postusername\";s:14:\"Poker face Ace\";s:8:\"dateline\";s:10:\"1712403678\";s:10:\"lastpostid\";s:7:\"2209180\";s:14:\"threadlastpost\";s:10:\"1714270733\";s:12:\"lastposterid\";s:8:\"10153566\";s:10:\"lastposter\";s:14:\"Poker face Ace\";s:10:\"replycount\";s:3:\"216\";s:7:\"forumid\";s:1:\"2\";s:10:\"forumtitle\";s:14:\"MUSCLE CENTRAL\";s:7:\"message\";s:101:\"Is watching:[video=youtube_share;XX7rFlhovxI]https://youtu.be/XX7rFlhovxI?si=mWVzcWg0YfT7zJyA[/video]\";s:11:\"allowsmilie\";s:1:\"1\";s:6:\"postid\";s:7:\"2208683\";s:6:\"userid\";s:8:\"10153566\";s:11:\"usergroupid\";s:1:\"2\";s:14:\"membergroupids\";s:0:\"\";s:14:\"displaygroupid\";s:1:\"2\";s:8:\"username\";s:14:\"Poker face Ace\";s:8:\"password\";s:32:\"c7a02b9cf73bedc6feb8cb598c7f5385\";s:12:\"passworddate\";s:10:\"2016-05-05\";s:5:\"email\";s:18:\"[email protected]\";s:7:\"styleid\";s:1:\"0\";s:11:\"parentemail\";s:0:\"\";s:8:\"homepage\";s:0:\"\";s:3:\"icq\";s:0:\"\";s:3:\"aim\";s:7:\"RIP DMX\";s:5:\"yahoo\";s:32:\"DMX- "X gone give it to ya&\";s:3:\"msn\";s:0:\"\";s:5:\"skype\";s:0:\"\";s:10:\"showvbcode\";s:1:\"2\";s:12:\"showbirthday\";s:1:\"0\";s:9:\"usertitle\";s:6:\"LEGEND\";s:11:\"customtitle\";s:1:\"1\";s:8:\"joindate\";s:10:\"1381183080\";s:9:\"daysprune\";s:1:\"0\";s:9:\"lastvisit\";s:10:\"1714237962\";s:12:\"lastactivity\";s:10:\"1714276624\";s:8:\"lastpost\";s:10:\"1714270733\";s:5:\"posts\";s:4:\"8071\";s:10:\"reputation\";s:10:\"2147483647\";s:17:\"reputationlevelid\";s:2:\"19\";s:14:\"timezoneoffset\";s:2:\"-5\";s:7:\"pmpopup\";s:1:\"1\";s:8:\"avatarid\";s:1:\"0\";s:14:\"avatarrevision\";s:1:\"0\";s:18:\"profilepicrevision\";s:1:\"0\";s:14:\"sigpicrevision\";s:1:\"0\";s:7:\"options\";s:8:\"45637063\";s:8:\"birthday\";s:10:\"09-01-1981\";s:15:\"birthday_search\";s:10:\"1981-09-01\";s:8:\"maxposts\";s:2:\"-1\";s:11:\"startofweek\";s:1:\"1\";s:9:\"ipaddress\";s:12:\"69.121.80.46\";s:10:\"referrerid\";s:1:\"0\";s:10:\"languageid\";s:1:\"0\";s:10:\"emailstamp\";s:1:\"0\";s:12:\"threadedmode\";s:1:\"0\";s:13:\"autosubscribe\";s:2:\"-1\";s:7:\"pmtotal\";s:3:\"138\";s:8:\"pmunread\";s:1:\"0\";s:4:\"salt\";s:30:\"hz1H)RqKA\";s:7:\"ipoints\";s:1:\"1\";s:11:\"infractions\";s:1:\"1\";s:8:\"warnings\";s:1:\"0\";s:18:\"infractiongroupids\";s:0:\"\";s:17:\"infractiongroupid\";s:1:\"0\";s:12:\"adminoptions\";s:1:\"0\";s:13:\"profilevisits\";s:6:\"185502\";s:11:\"friendcount\";s:1:\"1\";s:14:\"friendreqcount\";s:1:\"0\";s:13:\"vmunreadcount\";s:1:\"0\";s:16:\"vmmoderatedcount\";s:1:\"0\";s:19:\"socgroupinvitecount\";s:1:\"0\";s:16:\"socgroupreqcount\";s:1:\"0\";s:13:\"pcunreadcount\";s:1:\"0\";s:16:\"pcmoderatedcount\";s:1:\"0\";s:16:\"gmmoderatedcount\";s:1:\"0\";s:13:\"assetposthash\";s:32:\"13218c7aaaa9a45cde46a4186e3ca563\";s:8:\"fbuserid\";s:0:\"\";s:10:\"fbjoindate\";s:1:\"0\";s:6:\"fbname\";s:0:\"\";s:9:\"logintype\";s:2:\"vb\";s:13:\"fbaccesstoken\";s:0:\"\";s:11:\"newrepcount\";s:1:\"0\";s:13:\"panjo_selling\";N;s:10:\"avatarpath\";N;s:15:\"hascustomavatar\";s:1:\"1\";s:14:\"avatardateline\";s:10:\"1410047015\";s:7:\"avwidth\";s:11:\"width=\"200\"\";s:8:\"avheight\";s:12:\"height=\"139\"\";s:4:\"date\";s:10:\"04-06-2024\";s:4:\"time\";s:8:\"07:41 AM\";s:12:\"lastpostdate\";s:9:\"Yesterday\";s:12:\"lastposttime\";s:8:\"10:18 PM\";s:11:\"adminavatar\";i:0;s:15:\"adminprofilepic\";i:0;s:9:\"avatarurl\";s:98:\"image.php?s=1dc32ca77d20cb47b85c8febebf870db&u=10153566&dateline=1410047015&type=thumb\";s:9:\"avwidthpx\";i:200;s:10:\"avheightpx\";i:139;s:11:\"permissions\";a:51:{s:11:\"usergroupid\";i:2;s:5:\"title\";s:9:\"RX MEMBER\";s:11:\"description\";s:8:\"New Here\";s:9:\"usertitle\";s:9:\"RX MEMBER\";s:15:\"passwordexpires\";i:0;s:15:\"passwordhistory\";i:0;s:7:\"pmquota\";i:200;s:9:\"pmsendmax\";i:5;s:7:\"opentag\";s:0:\"\";s:8:\"closetag\";s:0:\"\";s:11:\"canoverride\";i:0;s:13:\"ispublicgroup\";i:0;s:16:\"forumpermissions\";i:9105663;s:13:\"pmpermissions\";i:0;s:19:\"calendarpermissions\";i:49;s:14:\"wolpermissions\";i:1;s:16:\"adminpermissions\";i:0;s:18:\"genericpermissions\";i:203953091;s:19:\"genericpermissions2\";i:5;s:14:\"genericoptions\";i:62;s:20:\"signaturepermissions\";i:0;s:25:\"visitormessagepermissions\";i:63;s:11:\"attachlimit\";i:0;s:14:\"avatarmaxwidth\";i:80;s:15:\"avatarmaxheight\";i:100;s:13:\"avatarmaxsize\";i:190000;s:18:\"profilepicmaxwidth\";i:450;s:19:\"profilepicmaxheight\";i:600;s:17:\"profilepicmaxsize\";i:1105535;s:14:\"sigpicmaxwidth\";i:-1;s:15:\"sigpicmaxheight\";i:-1;s:13:\"sigpicmaxsize\";i:-1;s:12:\"sigmaximages\";i:-1;s:16:\"sigmaxsizebbcode\";i:-1;s:11:\"sigmaxchars\";i:-1;s:14:\"sigmaxrawchars\";i:-1;s:11:\"sigmaxlines\";i:-1;s:18:\"usercsspermissions\";i:0;s:16:\"albumpermissions\";i:255;s:16:\"albumpicmaxwidth\";i:600;s:17:\"albumpicmaxheight\";i:600;s:12:\"albummaxpics\";i:100;s:12:\"albummaxsize\";i:0;s:22:\"socialgrouppermissions\";i:181119;s:18:\"pmthrottlequantity\";i:0;s:16:\"groupiconmaxsize\";i:65535;s:19:\"maximumsocialgroups\";i:5;s:12:\"sigmaxvideos\";i:-1;s:14:\"panjo_can_sell\";i:1;s:21:\"panjo_transaction_fee\";N;s:17:\"panjo_listing_fee\";N;}s:10:\"showavatar\";b:1;}i:138240;a:102:{s:8:\"threadid\";s:6:\"138240\";s:5:\"title\";s:15:\"Muscular Women!\";s:8:\"prefixid\";s:0:\"\";s:6:\"attach\";s:1:\"0\";s:12:\"postusername\";s:8:\"Big Beat\";s:8:\"dateline\";s:10:\"1463082267\";s:10:\"lastpostid\";s:7:\"2191872\";s:14:\"threadlastpost\";s:10:\"1714141677\";s:12:\"lastposterid\";s:3:\"254\";s:10:\"lastposter\";s:13:\"BananaHammock\";s:10:\"replycount\";s:4:\"2003\";s:7:\"forumid\";s:1:\"2\";s:10:\"forumtitle\";s:14:\"MUSCLE CENTRAL\";s:7:\"message\";s:251:\"[B]Men...Do You Find Muscular Women Attractive?[/B]\r\n\r\nSo what does it for you?\r\n\r\nWhich of the below best suits your taste?\r\n\r\n1. No muscles Playboy \r\n2. Bikini Class\r\n3. Figure\r\n4. Physique\r\n5. Female Bodybuilding\r\n6. Don\'t find any woman attractive\";s:11:\"allowsmilie\";s:1:\"1\";s:6:\"postid\";s:7:\"2133024\";s:6:\"userid\";s:8:\"10190701\";s:11:\"usergroupid\";s:2:\"14\";s:14:\"membergroupids\";s:0:\"\";s:14:\"displaygroupid\";s:1:\"0\";s:8:\"username\";s:8:\"Big Beat\";s:8:\"password\";s:32:\"8b794fd004086ef8019189951e87cace\";s:12:\"passworddate\";s:10:\"2016-03-04\";s:5:\"email\";s:20:\"[email protected]\";s:7:\"styleid\";s:1:\"0\";s:11:\"parentemail\";s:0:\"\";s:8:\"homepage\";s:0:\"\";s:3:\"icq\";s:0:\"\";s:3:\"aim\";s:0:\"\";s:5:\"yahoo\";s:0:\"\";s:3:\"msn\";s:0:\"\";s:5:\"skype\";s:0:\"\";s:10:\"showvbcode\";s:1:\"2\";s:12:\"showbirthday\";s:1:\"0\";s:9:\"usertitle\";s:8:\"OLYMPIAN\";s:11:\"customtitle\";s:1:\"1\";s:8:\"joindate\";s:10:\"1457163840\";s:9:\"daysprune\";s:1:\"0\";s:9:\"lastvisit\";s:10:\"1609633720\";s:12:\"lastactivity\";s:10:\"1610326395\";s:8:\"lastpost\";s:10:\"1580028049\";s:5:\"posts\";s:4:\"1330\";s:10:\"reputation\";s:10:\"2147483647\";s:17:\"reputationlevelid\";s:2:\"19\";s:14:\"timezoneoffset\";s:1:\"0\";s:7:\"pmpopup\";s:1:\"0\";s:8:\"avatarid\";s:1:\"0\";s:14:\"avatarrevision\";s:1:\"0\";s:18:\"profilepicrevision\";s:1:\"0\";s:14:\"sigpicrevision\";s:1:\"0\";s:7:\"options\";s:8:\"36719687\";s:8:\"birthday\";s:10:\"01-01-1970\";s:15:\"birthday_search\";s:10:\"1970-01-01\";s:8:\"maxposts\";s:2:\"-1\";s:11:\"startofweek\";s:1:\"1\";s:9:\"ipaddress\";s:15:\"217.114.169.241\";s:10:\"referrerid\";s:1:\"0\";s:10:\"languageid\";s:1:\"0\";s:10:\"emailstamp\";s:1:\"0\";s:12:\"threadedmode\";s:1:\"0\";s:13:\"autosubscribe\";s:2:\"-1\";s:7:\"pmtotal\";s:2:\"19\";s:8:\"pmunread\";s:1:\"0\";s:4:\"salt\";s:30:\"+yXt/O?o-\"a#8w/%xZYM%ws+%9DwTime Before: 0.18636 seconds
Time After: 0.19999 seconds
Time Taken: 0.01363 seconds
Memory Before: 5,895.547 KB
Memory After: 5,885.609 KB
Memory Used: -9.938 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.20120 seconds
Time After: 0.20132 seconds
Time Taken: 0.00013 seconds

Memory Before: 5,897.352 KB
Memory After: 5,897.797 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.20226 seconds
Time After: 0.20293 seconds
Time Taken: 0.00067 seconds

Memory Before: 5,879.367 KB
Memory After: 5,879.359 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.20305 seconds
Time After: 0.20829 seconds
Time Taken: 0.00524 seconds

Memory Before: 5,903.250 KB
Memory After: 5,898.648 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.20885 seconds
Time After: 0.20899 seconds
Time Taken: 0.00014 seconds

Memory Before: 5,885.984 KB
Memory After: 5,886.430 KB
Memory Used: 0.445 KB

SQL Query

SELECT text, languageid, special
FROM rxphrase AS phrase
LEFT JOIN rxphrasetype USING (fieldname)
WHERE phrase.fieldname = 'error'
	AND varname = 'nopermission_loggedout' AND languageid IN (-1, 0, 1)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	phrase	range	name_lang_type,languageid	name_lang_type	276		3	Using index condition
1	SIMPLE	rxphrasetype	const	PRIMARY	PRIMARY	20	const	1	Using where

Time Before: 0.21004 seconds
Time After: 0.21055 seconds
Time Taken: 0.00051 seconds

Memory Before: 5,916.992 KB
Memory After: 5,917.305 KB
Memory Used: 0.313 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.21649 seconds
Time After: 0.21713 seconds
Time Taken: 0.00065 seconds

Memory Before: 6,039.453 KB
Memory After: 6,039.445 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.21726 seconds
Time After: 0.22495 seconds
Time Taken: 0.00768 seconds

Memory Before: 6,057.844 KB
Memory After: 6,053.242 KB
Memory Used: -4.602 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.22706 seconds
Time After: 0.22766 seconds
Time Taken: 0.00060 seconds

Memory Before: 6,053.891 KB
Memory After: 6,053.883 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.22778 seconds
Time After: 0.23326 seconds
Time Taken: 0.00549 seconds

Memory Before: 6,072.281 KB
Memory After: 6,067.680 KB
Memory Used: -4.602 KB