Including Functions.php

Time Before: 0.00057 seconds
Time After: 0.00081 seconds
Time Taken: 0.00024 seconds

Memory Before: 559.094 KB
Memory After: 672.258 KB
Memory Used: 113.164 KB

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

Time Before: 0.00085 seconds
Time After: 0.00287 seconds
Time Taken: 0.00203 seconds

Memory Before: 672.258 KB
Memory After: 673.203 KB
Memory Used: 0.945 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.00299 seconds
Time After: 0.00311 seconds
Time Taken: 0.00012 seconds

Memory Before: 673.867 KB
Memory After: 674.430 KB
Memory Used: 0.563 KB

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

Time Before: 0.00352 seconds
Time After: 0.00421 seconds
Time Taken: 0.00069 seconds

Memory Before: 677.711 KB
Memory After: 677.922 KB
Memory Used: 0.211 KB

Time Before: 0.00315 seconds
Time After: 0.00927 seconds
Time Taken: 0.00612 seconds

Memory Before: 673.672 KB
Memory After: 3,449.969 KB
Memory Used: 2,776.297 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.01034 seconds
Time After: 0.01047 seconds
Time Taken: 0.00013 seconds

Memory Before: 3,911.461 KB
Memory After: 3,911.914 KB
Memory Used: 0.453 KB

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

Time Before: 0.01099 seconds
Time After: 0.01116 seconds
Time Taken: 0.00017 seconds

Memory Before: 3,925.852 KB
Memory After: 3,926.219 KB
Memory Used: 0.367 KB

SQL Query
SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_user AS phrasegroup_user,
			phrasegroup_infractionlevel AS phrasegroup_infractionlevel,
			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.01177 seconds
Time After: 0.01206 seconds
Time Taken: 0.00029 seconds

Memory Before: 3,936.836 KB
Memory After: 3,936.602 KB
Memory Used: -0.234 KB

Time Before: 0.01060 seconds
Time After: 0.01219 seconds
Time Taken: 0.00159 seconds

Memory Before: 3,918.797 KB
Memory After: 4,029.953 KB
Memory Used: 111.156 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.01675 seconds
Time After: 0.01698 seconds
Time Taken: 0.00023 seconds

Memory Before: 4,658.578 KB
Memory After: 4,658.969 KB
Memory Used: 0.391 KB

End call of global.php: 0.018532037734985
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)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEphraserangename_lang_type,languageidname_lang_type276 3Using index condition
1SIMPLErxphrasetypeconstPRIMARYPRIMARY20const1Using where

Time Before: 0.01915 seconds
Time After: 0.01957 seconds
Time Taken: 0.00042 seconds

Memory Before: 5,228.055 KB
Memory After: 5,228.367 KB
Memory Used: 0.313 KB

SQL Query
SELECT title, template
FROM rxtemplate
WHERE templateid IN (11325,11320,11323,11316,10686,10936,10935,10938,10937,10939,11116,11117,11324,11227,11235,11236,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 55Using where

Time Before: 0.02259 seconds
Time After: 0.06944 seconds
Time Taken: 0.04686 seconds

Memory Before: 5,558.945 KB
Memory After: 5,559.086 KB
Memory Used: 0.141 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.08178 seconds
Time After: 0.08243 seconds
Time Taken: 0.00065 seconds

Memory Before: 5,760.719 KB
Memory After: 5,760.711 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.08261 seconds
Time After: 0.21868 seconds
Time Taken: 0.13606 seconds

Memory Before: 5,797.070 KB
Memory After: 5,792.469 KB
Memory Used: -4.602 KB

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

Time Before: 0.21962 seconds
Time After: 0.21980 seconds
Time Taken: 0.00017 seconds

Memory Before: 5,850.305 KB
Memory After: 5,850.703 KB
Memory Used: 0.398 KB

SQL Query
UPDATE rxcache
SET locktime = 1718573316
WHERE cacheid = 'forumblock.a908a5b1e4e6efb6335f2b39f031673f'

Time Before: 0.21990 seconds
Time After: 0.34814 seconds
Time Taken: 0.12824 seconds

Memory Before: 5,851.586 KB
Memory After: 5,851.875 KB
Memory Used: 0.289 KB

SQL Query
REPLACE INTO rxcache
SET cacheid = 'forumblock.a908a5b1e4e6efb6335f2b39f031673f',
	expires = 1718576916,
	created = 1718573316,
	locktime = 0,
	data = "

Subscribe to RX on YouTube!

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

Time Before: 0.34843 seconds
Time After: 0.49691 seconds
Time Taken: 0.14848 seconds

Memory Before: 5,853.234 KB
Memory After: 5,853.219 KB
Memory Used: -0.016 KB

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

Time Before: 1.24701 seconds
Time After: 1.24731 seconds
Time Taken: 0.00030 seconds

Memory Before: 5,859.047 KB
Memory After: 5,859.492 KB
Memory Used: 0.445 KB

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

Time Before: 1.24851 seconds
Time After: 1.24873 seconds
Time Taken: 0.00022 seconds

Memory Before: 5,860.828 KB
Memory After: 5,861.227 KB
Memory Used: 0.398 KB

SQL Query
UPDATE rxcache
SET locktime = 1718573316
WHERE cacheid = 'forumblock.f6c0cf8e0e9ecc755612967df767f500'

Time Before: 1.24885 seconds
Time After: 1.38761 seconds
Time Taken: 0.13876 seconds

Memory Before: 5,862.313 KB
Memory After: 5,862.602 KB
Memory Used: 0.289 KB

SQL Query
REPLACE INTO rxcache
SET cacheid = 'forumblock.f6c0cf8e0e9ecc755612967df767f500',
	expires = 1718576916,
	created = 1718573316,
	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: 1.38779 seconds
Time After: 1.59171 seconds
Time Taken: 0.20392 seconds

Memory Before: 5,864.281 KB
Memory After: 5,863.648 KB
Memory Used: -0.633 KB

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

Time Before: 1.59250 seconds
Time After: 1.59262 seconds
Time Taken: 0.00012 seconds

Memory Before: 5,868.281 KB
Memory After: 5,868.680 KB
Memory Used: 0.398 KB

SQL Query
UPDATE rxcache
SET locktime = 1718573316
WHERE cacheid = 'forumblock.2d508f9178f7775bc32052bb7719e7c4'

Time Before: 1.59269 seconds
Time After: 1.74498 seconds
Time Taken: 0.15229 seconds

Memory Before: 5,869.391 KB
Memory After: 5,869.680 KB
Memory Used: 0.289 KB

SQL Query
REPLACE INTO rxcache
SET cacheid = 'forumblock.2d508f9178f7775bc32052bb7719e7c4',
	expires = 1718576916,
	created = 1718573316,
	locktime = 0,
	data = "
Follow @RXMuscledotcom\r\n\r\n
\r\n
", serialized = '0'

Time Before: 1.74522 seconds
Time After: 1.87040 seconds
Time Taken: 0.12519 seconds

Memory Before: 5,870.406 KB
Memory After: 5,870.211 KB
Memory Used: -0.195 KB

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

Time Before: 1.87138 seconds
Time After: 1.87148 seconds
Time Taken: 0.00011 seconds

Memory Before: 5,875.367 KB
Memory After: 5,875.766 KB
Memory Used: 0.398 KB

SQL Query
UPDATE rxcache
SET locktime = 1718573316
WHERE cacheid = 'forumblock.dc276a9f5dc73e3d6745b6419976ec80'

Time Before: 1.87155 seconds
Time After: 1.97726 seconds
Time Taken: 0.10571 seconds

Memory Before: 5,876.484 KB
Memory After: 5,876.773 KB
Memory Used: 0.289 KB

SQL Query
REPLACE INTO rxcache
SET cacheid = 'forumblock.dc276a9f5dc73e3d6745b6419976ec80',
	expires = 1718576916,
	created = 1718573316,
	locktime = 0,
	data = "
\"Dave\'s

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

Read More!
", serialized = '0'

Time Before: 1.97750 seconds
Time After: 2.08946 seconds
Time Taken: 0.11195 seconds

Memory Before: 5,877.516 KB
Memory After: 5,877.305 KB
Memory Used: -0.211 KB

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

Time Before: 2.10093 seconds
Time After: 2.10117 seconds
Time Taken: 0.00023 seconds

Memory Before: 5,897.742 KB
Memory After: 5,898.141 KB
Memory Used: 0.398 KB

SQL Query
UPDATE rxcache
SET locktime = 1718573316
WHERE cacheid = 'forumblock.70872a05c4601d6641dff1070d6b741b'

Time Before: 2.10134 seconds
Time After: 2.22328 seconds
Time Taken: 0.12194 seconds

Memory Before: 5,954.813 KB
Memory After: 5,955.102 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 > 1715981316


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

Time Before: 2.22549 seconds
Time After: 2.22652 seconds
Time Taken: 0.00102 seconds

Memory Before: 5,903.344 KB
Memory After: 5,902.773 KB
Memory Used: -0.570 KB

SQL Query
REPLACE INTO rxcache
SET cacheid = 'forumblock.70872a05c4601d6641dff1070d6b741b',
	expires = 1718576916,
	created = 1718573316,
	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:\"2209781\";s:14:\"threadlastpost\";s:10:\"1718571369\";s:12:\"lastposterid\";s:8:\"10153566\";s:10:\"lastposter\";s:14:\"Poker face Ace\";s:10:\"replycount\";s:3:\"690\";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:\"1718555065\";s:12:\"lastactivity\";s:10:\"1718572761\";s:8:\"lastpost\";s:10:\"1718571369\";s:5:\"posts\";s:4:\"8541\";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:\"193560\";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:5:\"Today\";s:12:\"lastposttime\";s:8:\"04:56 PM\";s:11:\"adminavatar\";i:0;s:15:\"adminprofilepic\";i:0;s:9:\"avatarurl\";s:98:\"image.php?s=11ebdf6cd96c83074bafcc13c756cd54&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:\"1717791914\";s:12:\"lastposterid\";s:3:\"254\";s:10:\"lastposter\";s:13:\"BananaHammock\";s:10:\"replycount\";s:4:\"2025\";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

Time Before: 2.22697 seconds
Time After: 2.30355 seconds
Time Taken: 0.07658 seconds

Memory Before: 5,981.844 KB
Memory After: 5,971.906 KB
Memory Used: -9.938 KB

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

Time Before: 2.30475 seconds
Time After: 2.30486 seconds
Time Taken: 0.00012 seconds

Memory Before: 5,983.617 KB
Memory After: 5,984.063 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: 2.30588 seconds
Time After: 2.31431 seconds
Time Taken: 0.00844 seconds

Memory Before: 5,963.547 KB
Memory After: 5,963.539 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: 2.31448 seconds
Time After: 2.36297 seconds
Time Taken: 0.04849 seconds

Memory Before: 5,987.453 KB
Memory After: 5,982.852 KB
Memory Used: -4.602 KB

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

Time Before: 2.36370 seconds
Time After: 2.36380 seconds
Time Taken: 0.00010 seconds

Memory Before: 5,970.156 KB
Memory After: 5,970.602 KB
Memory Used: 0.445 KB

SQL Query
UPDATE rxsession
SET lastactivity = 1718573316, location = '/usercp.php?explain=1'
WHERE sessionhash = '11ebdf6cd96c83074bafcc13c756cd54'

Time Before: 2.36698 seconds
Time After: 2.36711 seconds
Time Taken: 0.00014 seconds

Memory Before: 6,342.336 KB
Memory After: 6,342.594 KB
Memory Used: 0.258 KB

Page generated in 2.3662030696869 seconds with 32 queries, spending 1.5601761341095 doing MySQL queries and 0.80602693557739 doing PHP things.
Shutdown Queries:
DISABLED