Including Functions.php

Time Before: 0.00112 seconds
Time After: 0.00152 seconds
Time Taken: 0.00040 seconds

Memory Before: 697.477 KB
Memory After: 810.641 KB
Memory Used: 113.164 KB

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

Time Before: 0.00160 seconds
Time After: 0.00382 seconds
Time Taken: 0.00222 seconds

Memory Before: 810.641 KB
Memory After: 811.586 KB
Memory Used: 0.945 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.00410 seconds
Time After: 0.00433 seconds
Time Taken: 0.00024 seconds

Memory Before: 812.250 KB
Memory After: 812.813 KB
Memory Used: 0.563 KB

Datastore Setup
SQL Query
SELECT *
FROM rxdatastore
WHERE title IN ('smiliecache','bbcodecache','mailqueue','bookmarksitecache','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.00507 seconds
Time After: 0.00636 seconds
Time Taken: 0.00129 seconds

Memory Before: 816.102 KB
Memory After: 816.313 KB
Memory Used: 0.211 KB

Time Before: 0.00440 seconds
Time After: 0.01294 seconds
Time Taken: 0.00854 seconds

Memory Before: 812.055 KB
Memory After: 3,576.039 KB
Memory Used: 2,763.984 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.01423 seconds
Time After: 0.01447 seconds
Time Taken: 0.00024 seconds

Memory Before: 4,037.523 KB
Memory After: 4,037.977 KB
Memory Used: 0.453 KB

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

Time Before: 0.01542 seconds
Time After: 0.01569 seconds
Time Taken: 0.00027 seconds

Memory Before: 4,057.938 KB
Memory After: 4,058.313 KB
Memory Used: 0.375 KB

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

Time Before: 0.01663 seconds
Time After: 0.01711 seconds
Time Taken: 0.00047 seconds

Memory Before: 4,071.414 KB
Memory After: 4,071.039 KB
Memory Used: -0.375 KB

Time Before: 0.01478 seconds
Time After: 0.01730 seconds
Time Taken: 0.00251 seconds

Memory Before: 4,050.508 KB
Memory After: 4,150.328 KB
Memory Used: 99.820 KB

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



post.pagetext AS description,
thread.*


FROM rxthread AS thread




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


WHERE thread.threadid = 130045 LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEthreadconstPRIMARYPRIMARY4const1 
1SIMPLEpostconstPRIMARYPRIMARY4const1 

Time Before: 0.02250 seconds
Time After: 0.02289 seconds
Time Taken: 0.00039 seconds

Memory Before: 4,577.375 KB
Memory After: 4,577.625 KB
Memory Used: 0.250 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.02519 seconds
Time After: 0.02560 seconds
Time Taken: 0.00041 seconds

Memory Before: 4,631.242 KB
Memory After: 4,631.633 KB
Memory Used: 0.391 KB

End call of global.php: 0.027554035186768
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.02877 seconds
Time After: 0.02989 seconds
Time Taken: 0.00112 seconds

Memory Before: 5,289.484 KB
Memory After: 5,289.477 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.03012 seconds
Time After: 0.04051 seconds
Time Taken: 0.01040 seconds

Memory Before: 5,325.742 KB
Memory After: 5,321.141 KB
Memory Used: -4.602 KB

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

Time Before: 0.04168 seconds
Time After: 0.04186 seconds
Time Taken: 0.00018 seconds

Memory Before: 5,387.039 KB
Memory After: 5,387.438 KB
Memory Used: 0.398 KB

SQL Query
SELECT title, template
FROM rxtemplate
WHERE templateid IN (982,981,1600,1601,11377,10951,10952,10954,10960,10959,11154,11158,11144,11145,11147,11146,11149,11151,11152,11153,11156,10851,10853,10855,10857,10859,10682,11212,11213,11214,11211,11281,11132,11131,11133,11138,11136,11305,10913,10914,11080,10907,10906,10909,10910,10923,10921,10728,10723,11387,11407,977,976,978,973,972,1595,4948,10720,10699,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 83Using where

Time Before: 0.04318 seconds
Time After: 0.04440 seconds
Time Taken: 0.00122 seconds

Memory Before: 5,698.547 KB
Memory After: 5,698.539 KB
Memory Used: -0.008 KB

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

Time Before: 0.05035 seconds
Time After: 0.05054 seconds
Time Taken: 0.00019 seconds

Memory Before: 5,795.133 KB
Memory After: 5,795.578 KB
Memory Used: 0.445 KB

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

Time Before: 0.05114 seconds
Time After: 0.05131 seconds
Time Taken: 0.00017 seconds

Memory Before: 5,796.805 KB
Memory After: 5,797.203 KB
Memory Used: 0.398 KB

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

Time Before: 0.05196 seconds
Time After: 0.05212 seconds
Time Taken: 0.00016 seconds

Memory Before: 5,804.523 KB
Memory After: 5,804.922 KB
Memory Used: 0.398 KB

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

Time Before: 0.05276 seconds
Time After: 0.05292 seconds
Time Taken: 0.00016 seconds

Memory Before: 5,811.492 KB
Memory After: 5,811.891 KB
Memory Used: 0.398 KB

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

Time Before: 0.05366 seconds
Time After: 0.05383 seconds
Time Taken: 0.00017 seconds

Memory Before: 5,833.750 KB
Memory After: 5,834.148 KB
Memory Used: 0.398 KB

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

Time Before: 0.05496 seconds
Time After: 0.05512 seconds
Time Taken: 0.00016 seconds

Memory Before: 5,922.375 KB
Memory After: 5,922.820 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.05656 seconds
Time After: 0.05751 seconds
Time Taken: 0.00095 seconds

Memory Before: 5,904.211 KB
Memory After: 5,904.203 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.05769 seconds
Time After: 0.06552 seconds
Time Taken: 0.00783 seconds

Memory Before: 5,928.117 KB
Memory After: 5,923.516 KB
Memory Used: -4.602 KB

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

Time Before: 0.06637 seconds
Time After: 0.06653 seconds
Time Taken: 0.00017 seconds

Memory Before: 5,910.867 KB
Memory After: 5,911.313 KB
Memory Used: 0.445 KB

SQL Query
SELECT  post.postid, post.attach
FROM rxpost AS post

WHERE post.threadid = 130045
	AND post.visible = 1
	
	
ORDER BY post.dateline 
LIMIT 0, 15
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefthreadid,threadid_visible_datelinethreadid_visible_dateline6const,const1Using where

Time Before: 0.08718 seconds
Time After: 0.08749 seconds
Time Taken: 0.00031 seconds

Memory Before: 6,042.242 KB
Memory After: 6,042.602 KB
Memory Used: 0.359 KB

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

Time Before: 0.08810 seconds
Time After: 0.08826 seconds
Time Taken: 0.00016 seconds

Memory Before: 6,117.211 KB
Memory After: 6,117.641 KB
Memory Used: 0.430 KB

SQL Query
SELECT
				fd.thumbnail_dateline, fd.filesize, IF(fd.thumbnail_filesize > 0, 1, 0) AS hasthumbnail, fd.thumbnail_filesize,
				a.dateline, a.state, a.attachmentid, a.counter, a.contentid, a.filename, a.userid, a.settings, a.displayorder,
				at.contenttypes
FROM rxattachment AS a
			INNER JOIN rxfiledata AS fd ON (fd.filedataid = a.filedataid)
			LEFT JOIN rxattachmenttype AS at ON (at.extension = fd.extension)
			
			
				WHERE
					a.contentid IN (2060092)
						AND
					a.contenttypeid = 1

ORDER BY a.contentid, a.displayorder
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEarefcontentid,filedataid,contenttypeidcontentid4const1Using where; Using filesort
1SIMPLEfdeq_refPRIMARYPRIMARY403forums.a.filedataid1 
1SIMPLEateq_refPRIMARYPRIMARY2003forums.fd.extension1Using where

Time Before: 0.08893 seconds
Time After: 0.10814 seconds
Time Taken: 0.01920 seconds

Memory Before: 6,166.055 KB
Memory After: 6,166.031 KB
Memory Used: -0.023 KB

SQL Query
SELECT
	post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
	user.*, userfield.*, usertextfield.*,
	icon.title as icontitle, icon.iconpath,
	avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
	
	
	
	editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
	editlog.reason AS edit_reason, editlog.hashistory,
	postparsed.pagetext_html, postparsed.hasimages,
	sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
	sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
	IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid
	
	
FROM rxpost AS post
LEFT JOIN rxuser AS user ON(user.userid = post.userid)
LEFT JOIN rxuserfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN rxusertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN rxicon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN rxavatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN rxcustomavatar AS customavatar ON(customavatar.userid = user.userid)

	
LEFT JOIN rxeditlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN rxpostparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 21 AND postparsed.languageid = 1)
LEFT JOIN rxsigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 21 AND sigparsed.languageid = 1)
LEFT JOIN rxsigpic AS sigpic ON(sigpic.userid = post.userid)

	
WHERE post.postid IN (02060092)
ORDER BY post.dateline
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostconstPRIMARYPRIMARY4const1 
1SIMPLEuserconstPRIMARYPRIMARY4const1 
1SIMPLEuserfieldconstPRIMARYPRIMARY4const1 
1SIMPLEusertextfieldconstPRIMARYPRIMARY4const1 
1SIMPLEiconconstPRIMARYPRIMARY2const0unique row not found
1SIMPLEavatarconstPRIMARYPRIMARY2const0unique row not found
1SIMPLEcustomavatarconstPRIMARYPRIMARY4const1 
1SIMPLEeditlogconstPRIMARYPRIMARY4const0unique row not found
1SIMPLEpostparsedconstPRIMARYPRIMARY8const,const,const0unique row not found
1SIMPLEsigparsedconstPRIMARYPRIMARY8const,const,const1 
1SIMPLEsigpicconstPRIMARYPRIMARY4const1 

Time Before: 0.10940 seconds
Time After: 0.10999 seconds
Time Taken: 0.00059 seconds

Memory Before: 6,172.680 KB
Memory After: 6,171.445 KB
Memory Used: -1.234 KB

Time after parsing all posts: 0.11652112007141 Memory After: 6,313KB
SQL Query
SELECT `enabled` FROM `rxskimlinks` WHERE `userid` = 0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.12232 seconds
Time After: 0.12246 seconds
Time Taken: 0.00014 seconds

Memory Before: 6,482.102 KB
Memory After: 6,482.602 KB
Memory Used: 0.500 KB

SQL Query
INSERT IGNORE INTO rxsession
	(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate, apiclientid, apiaccesstoken)
VALUES
	('fb2d265bb42c1ba5fb50a7bdfdf23bdc', 0, '172.70.100.124', '214dfa735e5b40c91fd405b625318982', 1714301365, 'showthread.php?t=130045', 0, 0, 0, 273, 130045, 0, 0, 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])', 0, 0, 0, '')

Time Before: 0.12639 seconds
Time After: 0.12659 seconds
Time Taken: 0.00020 seconds

Memory Before: 7,047.031 KB
Memory After: 7,046.914 KB
Memory Used: -0.117 KB

SQL Query
UPDATE rxthread
SET views = views + 1
WHERE threadid = 130045

Time Before: 0.12667 seconds
Time After: 0.13774 seconds
Time Taken: 0.01107 seconds

Memory Before: 7,041.867 KB
Memory After: 7,042.203 KB
Memory Used: 0.336 KB

Page generated in 0.12500309944153 seconds with 27 queries, spending 0.060095071792603 doing MySQL queries and 0.064908027648926 doing PHP things.
Shutdown Queries: DISABLED