Including Functions.php

Time Before: 0.00066 seconds
Time After: 0.00090 seconds
Time Taken: 0.00024 seconds

Memory Before: 552.203 KB
Memory After: 665.367 KB
Memory Used: 113.164 KB

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

Time Before: 0.00094 seconds
Time After: 0.00320 seconds
Time Taken: 0.00225 seconds

Memory Before: 665.367 KB
Memory After: 666.313 KB
Memory Used: 0.945 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.00342 seconds
Time After: 0.00358 seconds
Time Taken: 0.00016 seconds

Memory Before: 667.008 KB
Memory After: 667.570 KB
Memory Used: 0.563 KB

Datastore Setup
SQL Query
SELECT *
FROM rxdatastore
WHERE title IN ('products','navdata','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream','routes')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxdatastorerangePRIMARYPRIMARY50 16Using where

Time Before: 0.00418 seconds
Time After: 0.00493 seconds
Time Taken: 0.00075 seconds

Memory Before: 670.602 KB
Memory After: 670.859 KB
Memory Used: 0.258 KB

Time Before: 0.00364 seconds
Time After: 0.00925 seconds
Time Taken: 0.00562 seconds

Memory Before: 666.781 KB
Memory After: 3,145.094 KB
Memory Used: 2,478.313 KB

SQL Query
SELECT *
FROM rxdatastore
WHERE title IN ('profilefield')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.01012 seconds
Time After: 0.01030 seconds
Time Taken: 0.00017 seconds

Memory Before: 3,606.648 KB
Memory After: 3,607.102 KB
Memory Used: 0.453 KB

Session Handling
SQL Query
SELECT *
FROM rxsession
WHERE userid = 0
	AND host = '172.70.38.71'
	AND idhash = 'a9a99dc22bc4a307a1ed049bf5c81c96'
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxsessionrefguest_lookup,user_activityguest_lookup51const,const,const2Using where

Time Before: 0.01074 seconds
Time After: 0.01090 seconds
Time Taken: 0.00016 seconds

Memory Before: 3,621.039 KB
Memory After: 3,621.406 KB
Memory Used: 0.367 KB

SQL Query
SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_fronthelp AS phrasegroup_fronthelp,
			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
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxlanguagesystemPRIMARY   1 

Time Before: 0.01143 seconds
Time After: 0.01177 seconds
Time Taken: 0.00034 seconds

Memory Before: 3,631.844 KB
Memory After: 3,631.672 KB
Memory Used: -0.172 KB

Time Before: 0.01041 seconds
Time After: 0.01189 seconds
Time Taken: 0.00148 seconds

Memory Before: 3,613.953 KB
Memory After: 3,690.688 KB
Memory Used: 76.734 KB

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

Time Before: 0.01495 seconds
Time After: 0.01526 seconds
Time Taken: 0.00031 seconds

Memory Before: 4,174.125 KB
Memory After: 4,174.516 KB
Memory Used: 0.391 KB

End call of global.php: 0.016552925109863
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
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEblockALLblocktypeid   7Using where; Using temporary; Using filesort
1SIMPLEblocktypeALLPRIMARY,productid   6Using where; Using join buffer (flat, BNL join)

Time Before: 0.01738 seconds
Time After: 0.01812 seconds
Time Taken: 0.00074 seconds

Memory Before: 4,770.523 KB
Memory After: 4,770.516 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\"Checkout\r\n\r\n\r\n
\r\n\r\n\r\n\r\n\"Muscle\r\n\r\n\r\n
\r\n\r\n\r\n\"evolutionary.org\"\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\'s

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.01826 seconds
Time After: 0.02767 seconds
Time Taken: 0.00941 seconds

Memory Before: 4,806.805 KB
Memory After: 4,802.203 KB
Memory Used: -4.602 KB

SQL Query
SELECT data, expires, locktime, serialized
FROM rxcache
WHERE cacheid = 'forumblock.39e20a199750ede57fa16eadc45018bf'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxcacheconstPRIMARYPRIMARY66const1 

Time Before: 0.02845 seconds
Time After: 0.02862 seconds
Time Taken: 0.00017 seconds

Memory Before: 4,860.031 KB
Memory After: 4,860.430 KB
Memory Used: 0.398 KB

SQL Query
UPDATE rxcache
SET locktime = 1739050673
WHERE cacheid = 'forumblock.39e20a199750ede57fa16eadc45018bf'

Time Before: 0.02869 seconds
Time After: 0.04431 seconds
Time Taken: 0.01562 seconds

Memory Before: 4,861.313 KB
Memory After: 4,861.602 KB
Memory Used: 0.289 KB

SQL Query
REPLACE INTO rxcache
SET cacheid = 'forumblock.39e20a199750ede57fa16eadc45018bf',
	expires = 1739054273,
	created = 1739050673,
	locktime = 0,
	data = "

Subscribe to RX on YouTube!

\r\n
\r\n\r\n\r\n
", serialized = '0'

Time Before: 0.04442 seconds
Time After: 0.06100 seconds
Time Taken: 0.01658 seconds

Memory Before: 4,862.961 KB
Memory After: 4,862.945 KB
Memory Used: -0.016 KB

SQL Query
SELECT title, template
FROM rxtemplate
WHERE templateid IN (10924,10926,10927,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)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxtemplaterangePRIMARYPRIMARY4 42Using where

Time Before: 0.06192 seconds
Time After: 0.06257 seconds
Time Taken: 0.00065 seconds

Memory Before: 5,030.570 KB
Memory After: 5,030.789 KB
Memory Used: 0.219 KB

SQL Query
SELECT template
FROM rxtemplate
WHERE templateid = 10863
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxtemplateconstPRIMARYPRIMARY4const1 

Time Before: 0.06633 seconds
Time After: 0.06646 seconds
Time Taken: 0.00013 seconds

Memory Before: 5,160.656 KB
Memory After: 5,161.102 KB
Memory Used: 0.445 KB

SQL Query
SELECT data, expires, locktime, serialized
FROM rxcache
WHERE cacheid = 'forumblock.5c48f3849a691369a5810c93cf242843'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxcacheconstPRIMARYPRIMARY66const1 

Time Before: 0.06689 seconds
Time After: 0.06703 seconds
Time Taken: 0.00014 seconds

Memory Before: 5,162.438 KB
Memory After: 5,162.836 KB
Memory Used: 0.398 KB

SQL Query
UPDATE rxcache
SET locktime = 1739050673
WHERE cacheid = 'forumblock.5c48f3849a691369a5810c93cf242843'

Time Before: 0.06711 seconds
Time After: 0.07754 seconds
Time Taken: 0.01043 seconds

Memory Before: 5,163.922 KB
Memory After: 5,164.211 KB
Memory Used: 0.289 KB

SQL Query
REPLACE INTO rxcache
SET cacheid = 'forumblock.5c48f3849a691369a5810c93cf242843',
	expires = 1739054273,
	created = 1739050673,
	locktime = 0,
	data = "
\r\n\r\n\r\n\r\n\r\n\r\n
\r\n\r\n\r\n\"Checkout\r\n\r\n\r\n
\r\n\r\n\r\n\r\n\"Muscle\r\n\r\n\r\n
\r\n\r\n\r\n\"evolutionary.org\"\r\n\r\n\r\n\r\n
\r\n\r\n\r\n\r\n
", serialized = '0'

Time Before: 0.07763 seconds
Time After: 0.08587 seconds
Time Taken: 0.00825 seconds

Memory Before: 5,165.891 KB
Memory After: 5,165.258 KB
Memory Used: -0.633 KB

SQL Query
SELECT data, expires, locktime, serialized
FROM rxcache
WHERE cacheid = 'forumblock.3cae99a144b75cf9be2bae5eba703a99'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxcacheconstPRIMARYPRIMARY66const1 

Time Before: 0.08636 seconds
Time After: 0.08650 seconds
Time Taken: 0.00014 seconds

Memory Before: 5,169.883 KB
Memory After: 5,170.281 KB
Memory Used: 0.398 KB

SQL Query
UPDATE rxcache
SET locktime = 1739050673
WHERE cacheid = 'forumblock.3cae99a144b75cf9be2bae5eba703a99'

Time Before: 0.08656 seconds
Time After: 0.09422 seconds
Time Taken: 0.00766 seconds

Memory Before: 5,170.992 KB
Memory After: 5,171.281 KB
Memory Used: 0.289 KB

SQL Query
REPLACE INTO rxcache
SET cacheid = 'forumblock.3cae99a144b75cf9be2bae5eba703a99',
	expires = 1739054273,
	created = 1739050673,
	locktime = 0,
	data = "
Follow @RXMuscledotcom\r\n\r\n
\r\n
", serialized = '0'

Time Before: 0.09429 seconds
Time After: 0.10253 seconds
Time Taken: 0.00824 seconds

Memory Before: 5,172.008 KB
Memory After: 5,171.813 KB
Memory Used: -0.195 KB

SQL Query
SELECT data, expires, locktime, serialized
FROM rxcache
WHERE cacheid = 'forumblock.9c1e509f040c70529e906190890d0bca'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxcacheconstPRIMARYPRIMARY66const1 

Time Before: 0.10308 seconds
Time After: 0.10323 seconds
Time Taken: 0.00014 seconds

Memory Before: 5,176.969 KB
Memory After: 5,177.367 KB
Memory Used: 0.398 KB

SQL Query
UPDATE rxcache
SET locktime = 1739050673
WHERE cacheid = 'forumblock.9c1e509f040c70529e906190890d0bca'

Time Before: 0.10330 seconds
Time After: 0.11091 seconds
Time Taken: 0.00761 seconds

Memory Before: 5,178.086 KB
Memory After: 5,178.375 KB
Memory Used: 0.289 KB

SQL Query
REPLACE INTO rxcache
SET cacheid = 'forumblock.9c1e509f040c70529e906190890d0bca',
	expires = 1739054273,
	created = 1739050673,
	locktime = 0,
	data = "
\"Dave\'s

Dave has built his reputation by helping others with his knowledge and experience.

Read More!
", serialized = '0'

Time Before: 0.11100 seconds
Time After: 0.11927 seconds
Time Taken: 0.00827 seconds

Memory Before: 5,179.094 KB
Memory After: 5,178.906 KB
Memory Used: -0.188 KB

SQL Query
SELECT data, expires, locktime, serialized
FROM rxcache
WHERE cacheid = 'forumblock.c3274171f21ea2e164d0bdba685e06ca'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxcacheconstPRIMARYPRIMARY66const1 

Time Before: 0.12003 seconds
Time After: 0.12022 seconds
Time Taken: 0.00019 seconds

Memory Before: 5,199.320 KB
Memory After: 5,199.719 KB
Memory Used: 0.398 KB

SQL Query
UPDATE rxcache
SET locktime = 1739050673
WHERE cacheid = 'forumblock.c3274171f21ea2e164d0bdba685e06ca'

Time Before: 0.12048 seconds
Time After: 0.12758 seconds
Time Taken: 0.00709 seconds

Memory Before: 5,313.406 KB
Memory After: 5,313.695 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 > 1736458673


			ORDER BY thread.lastpost DESC
			LIMIT 0,5
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEforumconstPRIMARYPRIMARY2const1 
1SIMPLEthreadrangeforumid,forumid_lastpost,lastpostforumid_lastpost6 4Using where
1SIMPLEusereq_refPRIMARYPRIMARY403forums.thread.postuserid1 
1SIMPLEavatareq_refPRIMARYPRIMARY203forums.user.avatarid1Using where
1SIMPLEcustomavatareq_refPRIMARYPRIMARY403forums.user.userid1Using where
1SIMPLEposteq_refPRIMARYPRIMARY403forums.thread.firstpostid1Using where

Time Before: 0.12950 seconds
Time After: 0.13117 seconds
Time Taken: 0.00168 seconds

Memory Before: 5,204.922 KB
Memory After: 5,204.352 KB
Memory Used: -0.570 KB

SQL Query
REPLACE INTO rxcache
SET cacheid = 'forumblock.c3274171f21ea2e164d0bdba685e06ca',
	expires = 1739054273,
	created = 1739050673,
	locktime = 0,
	data = "a:4:{i:151384;a:104:{s:8:\"threadid\";s:6:\"151384\";s:5:\"title\";s:21:\"PFA\'s eating schedule\";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:\"2212049\";s:14:\"threadlastpost\";s:10:\"1739047070\";s:12:\"lastposterid\";s:8:\"10153566\";s:10:\"lastposter\";s:14:\"Poker face Ace\";s:10:\"replycount\";s:4:\"2560\";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:\"1739034041\";s:12:\"lastactivity\";s:10:\"1739047070\";s:8:\"lastpost\";s:10:\"1739047070\";s:5:\"posts\";s:5:\"10428\";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:\"45636935\";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:\"276456\";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:\"08:41 AM\";s:12:\"lastpostdate\";s:5:\"Today\";s:12:\"lastposttime\";s:8:\"04:37 PM\";s:11:\"adminavatar\";i:0;s:15:\"adminprofilepic\";i:0;s:9:\"avatarurl\";s:98:\"image.php?s=f7914a19a9a5f46d2dfe5f6292bc4c52&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:129324;a:104:{s:8:\"threadid\";s:6:\"129324\";s:5:\"title\";s:33:\"Who do you think is loaded in bb?\";s:8:\"prefixid\";s:0:\"\";s:6:\"attach\";s:1:\"0\";s:12:\"postusername\";s:14:\"Poker face Ace\";s:8:\"dateline\";s:10:\"1414791783\";s:10:\"lastpostid\";s:7:\"2212049\";s:14:\"threadlastpost\";s:10:\"1738793648\";s:12:\"lastposterid\";s:8:\"10153566\";s:10:\"lastposter\";s:14:\"Poker face Ace\";s:10:\"replycount\";s:2:\"17\";s:7:\"forumid\";s:1:\"2\";s:10:\"forumtitle\";s:14:\"MUSCLE CENTRAL\";s:7:\"message\";s:165:\"Which bb do you think has the most cash and the least?\r\n\r\n[video=youtube;PBwAxmrE194]http://www.youtube.com/watch?feature=player_detailpage&v=PBwAxmrE194#t=0[/video]\";s:11:\"allowsmilie\";s:1:\"1\";s:6:\"postid\";s:7:\"2051144\";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:\"1739034041\";s:12:\"lastactivity\";s:10:\"1739047070\";s:8:\"lastpost\";s:10:\"1739047070\";s:5:\"posts\";s:5:\"10428\";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:\"45636935\";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:\"276456\";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:\"10-31-2014\";s:4:\"time\";s:8:\"06:43 PM\";s:12:\"lastpostdate\";s:10:\"02-05-2025\";s:12:\"lastposttime\";s:8:\"06:14 PM\";s:11:\"adminavatar\";i:0;s:15:\"adminprofilepic\";i:0;s:9:\"avatarurl\";s:98:\"image.php?s=f7914a19a9a5f46d2dfe5f6292bc4c52&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:\"1737320793\";s:12:\"lastposterid\";s:3:\"254\";s:10:\"lastposter\";s:13:\"BananaHammock\";s:10:\"replycount\";s:4:\"2030\";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+%9Dw\";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:\"276456\";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:\"01-11-2025\";s:4:\"time\";s:8:\"10:02 PM\";s:12:\"lastpostdate\";s:10:\"01-11-2025\";s:12:\"lastposttime\";s:8:\"10:02 PM\";s:11:\"adminavatar\";i:0;s:15:\"adminprofilepic\";i:0;s:9:\"avatarurl\";s:98:\"image.php?s=f7914a19a9a5f46d2dfe5f6292bc4c52&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;}}",
	serialized = '1'

Time Before: 0.13206 seconds
Time After: 0.14401 seconds
Time Taken: 0.01196 seconds

Memory Before: 5,364.961 KB
Memory After: 5,344.414 KB
Memory Used: -20.547 KB

SQL Query
SELECT template
FROM rxtemplate
WHERE templateid = 10867
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxtemplateconstPRIMARYPRIMARY4const1 

Time Before: 0.14537 seconds
Time After: 0.14552 seconds
Time Taken: 0.00014 seconds

Memory Before: 5,358.586 KB
Memory After: 5,359.031 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
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEblockALLblocktypeid   7Using where; Using temporary; Using filesort
1SIMPLEblocktypeALLPRIMARY,productid   6Using where; Using join buffer (flat, BNL join)

Time Before: 0.14704 seconds
Time After: 0.14777 seconds
Time Taken: 0.00073 seconds

Memory Before: 5,320.008 KB
Memory After: 5,320.000 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\"Checkout\r\n\r\n\r\n
\r\n\r\n\r\n\r\n\"Muscle\r\n\r\n\r\n
\r\n\r\n\r\n\"evolutionary.org\"\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\'s

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.14792 seconds
Time After: 0.15263 seconds
Time Taken: 0.00472 seconds

Memory Before: 5,343.898 KB
Memory After: 5,339.297 KB
Memory Used: -4.602 KB

SQL Query
SELECT template
FROM rxtemplate
WHERE templateid = 2265
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxtemplateconstPRIMARYPRIMARY4const1 

Time Before: 0.15312 seconds
Time After: 0.15326 seconds
Time Taken: 0.00014 seconds

Memory Before: 5,326.594 KB
Memory After: 5,327.039 KB
Memory Used: 0.445 KB

SQL Query
SELECT varname, text, languageid, fieldname
FROM rxphrase AS phrase
WHERE fieldname = 'faqtitle' AND
	languageid IN(-1, 0, 1)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEphraserangelanguageidlanguageid24 44Using index condition

Time Before: 0.15388 seconds
Time After: 0.15438 seconds
Time Taken: 0.00050 seconds

Memory Before: 5,340.875 KB
Memory After: 5,341.266 KB
Memory Used: 0.391 KB

SQL Query
SELECT faqname, faqparent, displayorder, volatile
	
FROM rxfaq AS faq

WHERE 1=1
	AND product IN ('', 'vbulletin', 'vbulletin', 'evbs_sstab_advanced', 'everywhere_sidebar', 'glowhostspamomatic', 'hn_masspm', 'mpdevs_ae_detector', 'skimlinks', 'tapatalk', 'vsachatbox')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEfaqALL    42Using where

Time Before: 0.15482 seconds
Time After: 0.15516 seconds
Time Taken: 0.00034 seconds

Memory Before: 5,404.156 KB
Memory After: 5,404.406 KB
Memory Used: 0.250 KB

SQL Query
SELECT varname, text, languageid
FROM rxphrase AS phrase
WHERE fieldname = 'faqtext' AND
	languageid IN(-1, 0, 1) AND
	varname IN('vb3_board_faq')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEphraserangename_lang_type,languageidname_lang_type276 3Using index condition

Time Before: 0.15576 seconds
Time After: 0.15613 seconds
Time Taken: 0.00037 seconds

Memory Before: 5,399.766 KB
Memory After: 5,400.141 KB
Memory Used: 0.375 KB

SQL Query
UPDATE rxsession
SET lastactivity = 1739050673, location = '/faq.php?explain=1', badlocation = 0
WHERE sessionhash = 'f7914a19a9a5f46d2dfe5f6292bc4c52'

Time Before: 0.16005 seconds
Time After: 0.16020 seconds
Time Taken: 0.00015 seconds

Memory Before: 5,696.664 KB
Memory After: 5,696.898 KB
Memory Used: 0.234 KB

Page generated in 0.15928983688354 seconds with 34 queries, spending 0.1263427734375 doing MySQL queries and 0.032947063446045 doing PHP things.
Shutdown Queries:
DISABLED