Including Functions.php

Time Before: 0.00096 seconds
Time After: 0.00131 seconds
Time Taken: 0.00036 seconds

Memory Before: 561.250 KB
Memory After: 674.414 KB
Memory Used: 113.164 KB

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

Time Before: 0.00137 seconds
Time After: 0.00281 seconds
Time Taken: 0.00144 seconds

Memory Before: 674.414 KB
Memory After: 675.359 KB
Memory Used: 0.945 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.00298 seconds
Time After: 0.00312 seconds
Time Taken: 0.00014 seconds

Memory Before: 676.023 KB
Memory After: 676.586 KB
Memory Used: 0.563 KB

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

Time Before: 0.00441 seconds
Time After: 0.00820 seconds
Time Taken: 0.00379 seconds

Memory Before: 679.813 KB
Memory After: 680.047 KB
Memory Used: 0.234 KB

Time Before: 0.00317 seconds
Time After: 0.01517 seconds
Time Taken: 0.01200 seconds

Memory Before: 675.828 KB
Memory After: 3,171.789 KB
Memory Used: 2,495.961 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.01669 seconds
Time After: 0.01683 seconds
Time Taken: 0.00014 seconds

Memory Before: 3,633.281 KB
Memory After: 3,633.734 KB
Memory Used: 0.453 KB

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

Time Before: 0.01764 seconds
Time After: 0.01783 seconds
Time Taken: 0.00019 seconds

Memory Before: 3,653.547 KB
Memory After: 3,653.922 KB
Memory Used: 0.375 KB

SQL Query
SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_forumdisplay AS phrasegroup_forumdisplay,
			phrasegroup_inlinemod AS phrasegroup_inlinemod,
			phrasegroup_prefix AS phrasegroup_prefix,
			phrasegroupinfo AS lang_phrasegroupinfo,
			options AS lang_options,
			languagecode AS lang_code,
			charset AS lang_charset,
			locale AS lang_locale,
			imagesoverride AS lang_imagesoverride,
			dateoverride AS lang_dateoverride,
			timeoverride AS lang_timeoverride,
			registereddateoverride AS lang_registereddateoverride,
			calformat1override AS lang_calformat1override,
			calformat2override AS lang_calformat2override,
			logdateoverride AS lang_logdateoverride,
			decimalsep AS lang_decimalsep,
			thousandsep AS lang_thousandsep
FROM rxlanguage
WHERE languageid = 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxlanguagesystemPRIMARY   1 

Time Before: 0.01865 seconds
Time After: 0.01901 seconds
Time Taken: 0.00036 seconds

Memory Before: 3,666.578 KB
Memory After: 3,666.297 KB
Memory Used: -0.281 KB

Time Before: 0.01715 seconds
Time After: 0.01919 seconds
Time Taken: 0.00205 seconds

Memory Before: 3,646.117 KB
Memory After: 3,726.563 KB
Memory Used: 80.445 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.02650 seconds
Time After: 0.02684 seconds
Time Taken: 0.00034 seconds

Memory Before: 4,231.477 KB
Memory After: 4,231.867 KB
Memory Used: 0.391 KB

End call of global.php: 0.030334949493408
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.03231 seconds
Time After: 0.03344 seconds
Time Taken: 0.00113 seconds

Memory Before: 4,837.672 KB
Memory After: 4,837.664 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.03367 seconds
Time After: 0.09391 seconds
Time Taken: 0.06023 seconds

Memory Before: 4,873.953 KB
Memory After: 4,869.352 KB
Memory Used: -4.602 KB

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

Time Before: 0.09570 seconds
Time After: 0.09590 seconds
Time Taken: 0.00019 seconds

Memory Before: 4,927.188 KB
Memory After: 4,927.586 KB
Memory Used: 0.398 KB

SQL Query
SELECT title, template
FROM rxtemplate
WHERE templateid IN (1592,10683,11316,11318,11317,10939,10686,10936,10938,10935,10937,10931,11377,11443,11306,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 54Using where

Time Before: 0.09718 seconds
Time After: 0.10081 seconds
Time Taken: 0.00363 seconds

Memory Before: 5,099.781 KB
Memory After: 5,099.930 KB
Memory Used: 0.148 KB

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

Time Before: 0.10764 seconds
Time After: 0.10778 seconds
Time Taken: 0.00014 seconds

Memory Before: 5,296.164 KB
Memory After: 5,296.609 KB
Memory Used: 0.445 KB

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

Time Before: 0.10858 seconds
Time After: 0.10872 seconds
Time Taken: 0.00014 seconds

Memory Before: 5,297.836 KB
Memory After: 5,298.234 KB
Memory Used: 0.398 KB

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

Time Before: 0.10936 seconds
Time After: 0.10950 seconds
Time Taken: 0.00013 seconds

Memory Before: 5,305.516 KB
Memory After: 5,305.914 KB
Memory Used: 0.398 KB

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

Time Before: 0.11009 seconds
Time After: 0.11023 seconds
Time Taken: 0.00013 seconds

Memory Before: 5,312.461 KB
Memory After: 5,312.859 KB
Memory Used: 0.398 KB

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

Time Before: 0.11101 seconds
Time After: 0.11117 seconds
Time Taken: 0.00016 seconds

Memory Before: 5,334.664 KB
Memory After: 5,335.063 KB
Memory Used: 0.398 KB

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

Time Before: 0.11250 seconds
Time After: 0.11263 seconds
Time Taken: 0.00013 seconds

Memory Before: 5,425.266 KB
Memory After: 5,425.711 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.11414 seconds
Time After: 0.11514 seconds
Time Taken: 0.00101 seconds

Memory Before: 5,406.250 KB
Memory After: 5,406.242 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.11548 seconds
Time After: 0.18023 seconds
Time Taken: 0.06475 seconds

Memory Before: 5,430.141 KB
Memory After: 5,425.539 KB
Memory Used: -4.602 KB

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

Time Before: 0.18123 seconds
Time After: 0.18138 seconds
Time Taken: 0.00015 seconds

Memory Before: 5,421.375 KB
Memory After: 5,421.820 KB
Memory Used: 0.445 KB

SQL Query
SELECT moderator.*, user.username,
IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid
FROM rxmoderator AS moderator
INNER JOIN rxuser AS user USING(userid)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEmoderatorALLuserid_forumid   137 
1SIMPLEusereq_refPRIMARYPRIMARY403forums.moderator.userid1 

Time Before: 0.18275 seconds
Time After: 0.18652 seconds
Time Taken: 0.00377 seconds

Memory Before: 5,470.813 KB
Memory After: 5,471.125 KB
Memory Used: 0.313 KB

SQL Query
SELECT forum.forumid, forum.lastpost, forum.lastposter, forum.lastposterid, forum.lastthread, forum.lastthreadid, forum.lasticonid, forum.threadcount, forum.replycount, forum.lastpostid, forum.lastprefixid, user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend,
	user.lastactivity, user.lastvisit, IF(user.options & 512, 1, 0) AS invisible
	
FROM rxforum AS forum

LEFT JOIN rxuser AS user ON (user.userid = forum.lastposterid)
LEFT JOIN rxuserlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 0)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEforumALL    169 
1SIMPLEusereq_refPRIMARYPRIMARY403forums.forum.lastposterid1 
1SIMPLEuserlisteq_refPRIMARY,relationid,useridPRIMARY9const,03forums.user.userid,const1Using where

Time Before: 0.18974 seconds
Time After: 0.20215 seconds
Time Taken: 0.01241 seconds

Memory Before: 5,798.016 KB
Memory After: 5,797.914 KB
Memory Used: -0.102 KB

SQL Query
SELECT
	announcement.announcementid, startdate, title, announcement.views,
	user.username, user.userid, user.usertitle, user.customtitle, user.usergroupid,
	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
	
	
FROM rxannouncement AS announcement

LEFT JOIN rxuser AS user ON(user.userid = announcement.userid)

WHERE startdate <= 1716475862
	AND enddate >= 1716475862
	AND forumid IN (168,142,133,197,-1)
	
ORDER BY startdate DESC, announcement.announcementid DESC
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEannouncementrangeforumid,startdatestartdate6 1Using index condition; Using filesort
1SIMPLEusereq_refPRIMARYPRIMARY403forums.announcement.userid1 

Time Before: 0.22574 seconds
Time After: 0.22603 seconds
Time Taken: 0.00029 seconds

Memory Before: 6,806.695 KB
Memory After: 6,806.672 KB
Memory Used: -0.023 KB

SQL Query
SELECT COUNT(*) AS threads

FROM rxthread AS thread


WHERE thread.forumid = 168
	AND sticky = 0
	
	 AND visible = 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEthreadrefforumid,forumid_lastpostforumid6const,const,const2Using index

Time Before: 0.22675 seconds
Time After: 0.22693 seconds
Time Taken: 0.00018 seconds

Memory Before: 6,813.094 KB
Memory After: 6,813.484 KB
Memory Used: 0.391 KB

SQL Query
SELECT COUNT(*) AS newthread
FROM rxthread AS thread


WHERE thread.forumid = 168
	AND thread.lastpost > 1716475862
	AND open <> 10
	AND sticky = 0
	
	 AND visible = 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEthreadrangeforumid,forumid_lastpost,lastpostforumid10 1Using index condition; Using where

Time Before: 0.22745 seconds
Time After: 0.22765 seconds
Time Taken: 0.00021 seconds

Memory Before: 6,813.836 KB
Memory After: 6,814.164 KB
Memory Used: 0.328 KB

SQL Query
SELECT thread.threadid, lastpost, open
FROM rxthread AS thread
WHERE forumid = 168
	AND sticky = 1
	
	 AND visible = 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEthreadrefforumid,forumid_lastpostforumid6const,const,const1 

Time Before: 0.22801 seconds
Time After: 0.22818 seconds
Time Taken: 0.00017 seconds

Memory Before: 6,813.945 KB
Memory After: 6,814.328 KB
Memory Used: 0.383 KB

SQL Query
SELECT  thread.threadid,
	thread.lastpost, thread.lastposter, thread.lastposterid, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views
	
FROM rxthread AS thread


WHERE forumid = 168
	AND sticky = 0
	
	 AND visible = 1 
	
	
	
	
ORDER BY sticky DESC, lastpost DESC
LIMIT 0, 45
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEthreadrefforumid,forumid_lastpostforumid6const,const,const2Using where

Time Before: 0.22862 seconds
Time After: 0.22891 seconds
Time Taken: 0.00029 seconds

Memory Before: 6,815.742 KB
Memory After: 6,815.898 KB
Memory Used: 0.156 KB

SQL Query
SELECT 
	IF(votenum >= 1, votenum, 0) AS votenum,
	IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
 post.pagetext AS preview,
	thread.threadid, thread.title AS threadtitle, thread.forumid, thread.pollid, thread.open, thread.postusername, thread.postuserid, thread.iconid AS threadiconid,
	thread.dateline, thread.notes, thread.visible, thread.sticky, thread.votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastposterid, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
	thread.prefixid, thread.taglist, thread.hiddencount, thread.deletedcount, user.userid,
	user.membergroupids, user.infractiongroupids, user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend,
	user.lastactivity, user.lastvisit, IF(user.options & 512, 1, 0) AS invisible
	
	
	
	
	
	
FROM rxthread AS thread
	LEFT JOIN rxuser AS user ON (user.userid = thread.lastposterid)
	LEFT JOIN rxuserlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 0)
	
	
	
	
	LEFT JOIN rxpost AS post ON(post.postid = thread.firstpostid)
	
	
	
WHERE thread.threadid IN (0,29376,27633) 
ORDER BY thread.sticky DESC, lastpost DESC
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEthreadrangePRIMARYPRIMARY4 3Using where; Using filesort
1SIMPLEusereq_refPRIMARYPRIMARY403forums.thread.lastposterid1 
1SIMPLEuserlisteq_refPRIMARY,relationid,useridPRIMARY9const,03forums.user.userid,const1Using where
1SIMPLEposteq_refPRIMARYPRIMARY403forums.thread.firstpostid1 

Time Before: 0.22960 seconds
Time After: 0.23040 seconds
Time Taken: 0.00080 seconds

Memory Before: 6,819.563 KB
Memory After: 6,818.750 KB
Memory Used: -0.813 KB

RX Muscle Forums Database Error
Database Error Database error
The RX Muscle Forums database has encountered a problem.

Please try the following:
  • Load the page again by clicking the Refresh button in your web browser.
  • Open the forums.rxmuscle.com home page, then try to open another page.
  • Click the Back button to try another link.
The forums.rxmuscle.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
 
We apologise for any inconvenience.