Time Before: 0.00086 seconds
Time After: 0.00117 seconds
Time Taken: 0.00031 seconds
Memory Before: 696.734 KB
Memory After: 809.914 KB
Memory Used: 113.180 KB
Time Before: 0.00123 seconds
Time After: 0.00328 seconds
Time Taken: 0.00205 seconds
Memory Before: 809.914 KB
Memory After: 810.859 KB
Memory Used: 0.945 KB
SET @@sql_mode = ''
Time Before: 0.00348 seconds
Time After: 0.00365 seconds
Time Taken: 0.00017 seconds
Memory Before: 811.523 KB
Memory After: 812.086 KB
Memory Used: 0.563 KB
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')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | rxdatastore | range | PRIMARY | PRIMARY | 50 | 20 | Using where |
Time Before: 0.00421 seconds
Time After: 0.00502 seconds
Time Taken: 0.00081 seconds
Memory Before: 815.375 KB
Memory After: 815.586 KB
Memory Used: 0.211 KB
Time Before: 0.00371 seconds
Time After: 0.00960 seconds
Time Taken: 0.00589 seconds
Memory Before: 811.328 KB
Memory After: 3,575.227 KB
Memory Used: 2,763.898 KB
SELECT * FROM rxdatastore WHERE title IN ('profilefield')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | Impossible WHERE noticed after reading const tables |
Time Before: 0.01056 seconds
Time After: 0.01073 seconds
Time Taken: 0.00017 seconds
Memory Before: 4,036.734 KB
Memory After: 4,037.188 KB
Memory Used: 0.453 KB
SELECT * FROM rxsession WHERE userid = 0 AND host = '172.69.7.54' AND idhash = '8d080882e4ca59fb7fdab6b7319eb9ce' LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | rxsession | ref | guest_lookup,user_activity | guest_lookup | 51 | const,const,const | 2 | Using where |
Time Before: 0.01147 seconds
Time After: 0.01176 seconds
Time Taken: 0.00030 seconds
Memory Before: 4,057.148 KB
Memory After: 4,057.516 KB
Memory Used: 0.367 KB
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
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | rxlanguage | system | PRIMARY | 1 |
Time Before: 0.01255 seconds
Time After: 0.01298 seconds
Time Taken: 0.00043 seconds
Memory Before: 4,068.656 KB
Memory After: 4,068.281 KB
Memory Used: -0.375 KB
Time Before: 0.01096 seconds
Time After: 0.01312 seconds
Time Taken: 0.00217 seconds
Memory Before: 4,049.719 KB
Memory After: 4,148.000 KB
Memory Used: 98.281 KB
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 = 29602 LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | post | const | PRIMARY | PRIMARY | 4 | const | 1 |
Time Before: 0.01702 seconds
Time After: 0.01734 seconds
Time Taken: 0.00032 seconds
Memory Before: 4,575.039 KB
Memory After: 4,575.297 KB
Memory Used: 0.258 KB
SELECT * FROM rxstyle WHERE (styleid = 21 AND userselect = 1) OR styleid = 21 ORDER BY styleid ASC LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | rxstyle | const | PRIMARY | PRIMARY | 2 | const | 1 |
Time Before: 0.01908 seconds
Time After: 0.01941 seconds
Time Taken: 0.00032 seconds
Memory Before: 4,630.844 KB
Memory After: 4,631.234 KB
Memory Used: 0.391 KB
SELECT block.*, blocktype.productid, blocktype.name AS blocktypename, blocktype.title AS blocktypetitle, blocktype.description as blocktypedescription, blocktype.allowcache FROM rxblock AS block LEFT JOIN rxblocktype AS blocktype ON (block.blocktypeid = blocktype.blocktypeid) WHERE 1 AND block.active = 1 AND blocktype.productid IN ('vbulletin','evbs_sstab_advanced','everywhere_sidebar','glowhostspamomatic','hn_masspm','mpdevs_ae_detector','skimlinks','tapatalk','vsachatbox','') ORDER BY block.displayorder, block.title
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | block | ALL | blocktypeid | 7 | Using where; Using temporary; Using filesort | |||
1 | SIMPLE | blocktype | ALL | PRIMARY,productid | 6 | Using where; Using join buffer (flat, BNL join) |
Time Before: 0.02178 seconds
Time After: 0.02292 seconds
Time Taken: 0.00114 seconds
Memory Before: 5,289.172 KB
Memory After: 5,289.164 KB
Memory Used: -0.008 KB
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\";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:\"\r\n \r\n\r\n\r\n \r\n
\r\n\r\n \r\n\r\n\r\n \r\n
\r\n\r\n\r\n \r\n\r\n\r\n \r\n
\r\n\r\n \r\n\r\n\r\n\r\n \r\n
\r\n\r\n\r\n\r\nFollow @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:\"\";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.02309 seconds
Time After: 0.03255 seconds
Time Taken: 0.00946 seconds
Memory Before: 5,325.453 KB
Memory After: 5,320.852 KB
Memory Used: -4.602 KB
SELECT data, expires, locktime, serialized FROM rxcache WHERE cacheid = 'forumblock.764771da005e7841bbf52d34841154b7'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | rxcache | const | PRIMARY | PRIMARY | 66 | const | 1 |
Time Before: 0.03339 seconds
Time After: 0.03358 seconds
Time Taken: 0.00019 seconds
Memory Before: 5,386.703 KB
Memory After: 5,387.102 KB
Memory Used: 0.398 KB
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)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | rxtemplate | range | PRIMARY | PRIMARY | 4 | 83 | Using where |
Time Before: 0.03456 seconds
Time After: 0.03525 seconds
Time Taken: 0.00068 seconds
Memory Before: 5,698.188 KB
Memory After: 5,698.180 KB
Memory Used: -0.008 KB
SELECT template FROM rxtemplate WHERE templateid = 10863
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | rxtemplate | const | PRIMARY | PRIMARY | 4 | const | 1 |
Time Before: 0.03970 seconds
Time After: 0.03985 seconds
Time Taken: 0.00015 seconds
Memory Before: 5,794.617 KB
Memory After: 5,795.063 KB
Memory Used: 0.445 KB
SELECT data, expires, locktime, serialized FROM rxcache WHERE cacheid = 'forumblock.9a970c532edd2f26e6ac3fabf8bc1550'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | rxcache | const | PRIMARY | PRIMARY | 66 | const | 1 |
Time Before: 0.04031 seconds
Time After: 0.04049 seconds
Time Taken: 0.00018 seconds
Memory Before: 5,796.289 KB
Memory After: 5,796.688 KB
Memory Used: 0.398 KB
SELECT data, expires, locktime, serialized FROM rxcache WHERE cacheid = 'forumblock.46cd2281d821f6ce5fcf02c6cb1e1eb1'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | rxcache | const | PRIMARY | PRIMARY | 66 | const | 1 |
Time Before: 0.04103 seconds
Time After: 0.04119 seconds
Time Taken: 0.00017 seconds
Memory Before: 5,803.969 KB
Memory After: 5,804.367 KB
Memory Used: 0.398 KB
SELECT data, expires, locktime, serialized FROM rxcache WHERE cacheid = 'forumblock.eecdb35f93eb6970ea11b09fa4da54e7'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | rxcache | const | PRIMARY | PRIMARY | 66 | const | 1 |
Time Before: 0.04166 seconds
Time After: 0.04176 seconds
Time Taken: 0.00010 seconds
Memory Before: 5,810.906 KB
Memory After: 5,811.305 KB
Memory Used: 0.398 KB
SELECT data, expires, locktime, serialized FROM rxcache WHERE cacheid = 'forumblock.fe61632f9dbe16b25f2c5a2d2c5b6d21'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | rxcache | const | PRIMARY | PRIMARY | 66 | const | 1 |
Time Before: 0.04232 seconds
Time After: 0.04243 seconds
Time Taken: 0.00011 seconds
Memory Before: 5,833.109 KB
Memory After: 5,833.508 KB
Memory Used: 0.398 KB
SELECT template FROM rxtemplate WHERE templateid = 10867
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | rxtemplate | const | PRIMARY | PRIMARY | 4 | const | 1 |
Time Before: 0.04356 seconds
Time After: 0.04368 seconds
Time Taken: 0.00013 seconds
Memory Before: 5,962.875 KB
Memory After: 5,963.320 KB
Memory Used: 0.445 KB
SELECT block.*, blocktype.productid, blocktype.name AS blocktypename, blocktype.title AS blocktypetitle, blocktype.description as blocktypedescription, blocktype.allowcache FROM rxblock AS block LEFT JOIN rxblocktype AS blocktype ON (block.blocktypeid = blocktype.blocktypeid) WHERE 1 AND block.active = 1 AND blocktype.productid IN ('vbulletin','evbs_sstab_advanced','everywhere_sidebar','glowhostspamomatic','hn_masspm','mpdevs_ae_detector','skimlinks','tapatalk','vsachatbox','') ORDER BY block.displayorder, block.title
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | block | ALL | blocktypeid | 7 | Using where; Using temporary; Using filesort | |||
1 | SIMPLE | blocktype | ALL | PRIMARY,productid | 6 | Using where; Using join buffer (flat, BNL join) |
Time Before: 0.04493 seconds
Time After: 0.04562 seconds
Time Taken: 0.00069 seconds
Memory Before: 5,934.258 KB
Memory After: 5,934.250 KB
Memory Used: -0.008 KB
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\";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:\"\r\n \r\n\r\n\r\n \r\n
\r\n\r\n \r\n\r\n\r\n \r\n
\r\n\r\n\r\n \r\n\r\n\r\n \r\n
\r\n\r\n \r\n\r\n\r\n\r\n \r\n
\r\n\r\n\r\n\r\nFollow @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:\"\";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.04575 seconds
Time After: 0.05574 seconds
Time Taken: 0.00999 seconds
Memory Before: 5,958.164 KB
Memory After: 5,953.563 KB
Memory Used: -4.602 KB
SELECT template FROM rxtemplate WHERE templateid = 2265
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | rxtemplate | const | PRIMARY | PRIMARY | 4 | const | 1 |
Time Before: 0.05631 seconds
Time After: 0.05652 seconds
Time Taken: 0.00021 seconds
Memory Before: 5,940.898 KB
Memory After: 5,941.344 KB
Memory Used: 0.445 KB
SELECT post.postid, post.attach FROM rxpost AS post WHERE post.threadid = 29602 AND post.visible = 1 ORDER BY post.dateline LIMIT 0, 15
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | threadid,threadid_visible_dateline | threadid_visible_dateline | 6 | const,const | 1 | Using where |
Time Before: 0.07187 seconds
Time After: 0.07208 seconds
Time Taken: 0.00022 seconds
Memory Before: 6,073.188 KB
Memory After: 6,073.547 KB
Memory Used: 0.359 KB
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 (0856911) ORDER BY post.dateline
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | userfield | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | usertextfield | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | icon | const | PRIMARY | PRIMARY | 2 | const | 0 | unique row not found |
1 | SIMPLE | avatar | const | PRIMARY | PRIMARY | 2 | const | 0 | unique row not found |
1 | SIMPLE | customavatar | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | editlog | const | PRIMARY | PRIMARY | 4 | const | 0 | unique row not found |
1 | SIMPLE | postparsed | const | PRIMARY | PRIMARY | 8 | const,const,const | 0 | unique row not found |
1 | SIMPLE | sigparsed | const | PRIMARY | PRIMARY | 8 | const,const,const | 0 | unique row not found |
1 | SIMPLE | sigpic | const | PRIMARY | PRIMARY | 4 | const | 0 | unique row not found |
Time Before: 0.07308 seconds
Time After: 0.07361 seconds
Time Taken: 0.00052 seconds
Memory Before: 6,080.641 KB
Memory After: 6,079.406 KB
Memory Used: -1.234 KB
SELECT data, expires, locktime, serialized FROM rxcache WHERE cacheid = 'vb_types.types'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | rxcache | const | PRIMARY | PRIMARY | 66 | const | 1 |
Time Before: 0.07652 seconds
Time After: 0.07668 seconds
Time Taken: 0.00015 seconds
Memory Before: 6,436.055 KB
Memory After: 6,436.484 KB
Memory Used: 0.430 KB
SELECT `enabled` FROM `rxskimlinks` WHERE `userid` = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | Impossible WHERE noticed after reading const tables |
Time Before: 0.08340 seconds
Time After: 0.08353 seconds
Time Taken: 0.00013 seconds
Memory Before: 6,497.484 KB
Memory After: 6,497.984 KB
Memory Used: 0.500 KB
UPDATE rxsession SET lastactivity = 1713985040, location = 'showthread.php?t=29602', inforum = 175, inthread = 29602, badlocation = 0 WHERE sessionhash = '37536a6734013750fab3c811af610b46'
Time Before: 0.08643 seconds
Time After: 0.08659 seconds
Time Taken: 0.00016 seconds
Memory Before: 7,052.695 KB
Memory After: 7,052.898 KB
Memory Used: 0.203 KB
UPDATE rxthread SET views = views + 1 WHERE threadid = 29602
Time Before: 0.08663 seconds
Time After: 0.09924 seconds
Time Taken: 0.01261 seconds
Memory Before: 7,047.039 KB
Memory After: 7,047.383 KB
Memory Used: 0.344 KB