Time Before: 0.00070 seconds
Time After: 0.00097 seconds
Time Taken: 0.00027 seconds
Memory Before: 696.773 KB
Memory After: 809.961 KB
Memory Used: 113.188 KB
Time Before: 0.00102 seconds
Time After: 0.00220 seconds
Time Taken: 0.00118 seconds
Memory Before: 809.961 KB
Memory After: 810.906 KB
Memory Used: 0.945 KB
SET @@sql_mode = ''
Time Before: 0.00233 seconds
Time After: 0.00244 seconds
Time Taken: 0.00010 seconds
Memory Before: 811.570 KB
Memory After: 812.133 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.00286 seconds
Time After: 0.00375 seconds
Time Taken: 0.00089 seconds
Memory Before: 815.422 KB
Memory After: 815.633 KB
Memory Used: 0.211 KB
Time Before: 0.00247 seconds
Time After: 0.00765 seconds
Time Taken: 0.00517 seconds
Memory Before: 811.375 KB
Memory After: 3,575.289 KB
Memory Used: 2,763.914 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.00853 seconds
Time After: 0.00865 seconds
Time Taken: 0.00012 seconds
Memory Before: 4,036.766 KB
Memory After: 4,037.219 KB
Memory Used: 0.453 KB
SELECT * FROM rxsession WHERE userid = 0 AND host = '172.70.131.157' AND idhash = 'a5ae2d3c153c487611a2ffa8f9b20666' 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.00923 seconds
Time After: 0.00939 seconds
Time Taken: 0.00016 seconds
Memory Before: 4,057.180 KB
Memory After: 4,057.555 KB
Memory Used: 0.375 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.00999 seconds
Time After: 0.01031 seconds
Time Taken: 0.00032 seconds
Memory Before: 4,068.617 KB
Memory After: 4,068.242 KB
Memory Used: -0.375 KB
Time Before: 0.00887 seconds
Time After: 0.01044 seconds
Time Taken: 0.00157 seconds
Memory Before: 4,049.750 KB
Memory After: 4,147.977 KB
Memory Used: 98.227 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 = 37408 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.01368 seconds
Time After: 0.01388 seconds
Time Taken: 0.00020 seconds
Memory Before: 4,575.063 KB
Memory After: 4,575.320 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.01549 seconds
Time After: 0.01573 seconds
Time Taken: 0.00025 seconds
Memory Before: 4,631.156 KB
Memory After: 4,631.547 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.01780 seconds
Time After: 0.01851 seconds
Time Taken: 0.00071 seconds
Memory Before: 5,289.461 KB
Memory After: 5,289.453 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.01866 seconds
Time After: 0.02918 seconds
Time Taken: 0.01052 seconds
Memory Before: 5,325.719 KB
Memory After: 5,321.117 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.03021 seconds
Time After: 0.03037 seconds
Time Taken: 0.00016 seconds
Memory Before: 5,387.000 KB
Memory After: 5,387.398 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.03166 seconds
Time After: 0.03235 seconds
Time Taken: 0.00069 seconds
Memory Before: 5,698.492 KB
Memory After: 5,698.484 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.03874 seconds
Time After: 0.03889 seconds
Time Taken: 0.00015 seconds
Memory Before: 5,795.109 KB
Memory After: 5,795.555 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.03948 seconds
Time After: 0.03964 seconds
Time Taken: 0.00016 seconds
Memory Before: 5,796.781 KB
Memory After: 5,797.180 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.04030 seconds
Time After: 0.04043 seconds
Time Taken: 0.00013 seconds
Memory Before: 5,804.477 KB
Memory After: 5,804.875 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.04100 seconds
Time After: 0.04110 seconds
Time Taken: 0.00010 seconds
Memory Before: 5,811.438 KB
Memory After: 5,811.836 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.04190 seconds
Time After: 0.04204 seconds
Time Taken: 0.00014 seconds
Memory Before: 5,833.656 KB
Memory After: 5,834.055 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.04332 seconds
Time After: 0.04342 seconds
Time Taken: 0.00010 seconds
Memory Before: 5,922.305 KB
Memory After: 5,922.750 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.04469 seconds
Time After: 0.04542 seconds
Time Taken: 0.00073 seconds
Memory Before: 5,904.117 KB
Memory After: 5,904.109 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.04556 seconds
Time After: 0.05416 seconds
Time Taken: 0.00859 seconds
Memory Before: 5,928.047 KB
Memory After: 5,923.445 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.05495 seconds
Time After: 0.05508 seconds
Time Taken: 0.00013 seconds
Memory Before: 5,910.789 KB
Memory After: 5,911.234 KB
Memory Used: 0.445 KB
SELECT post.postid, post.attach FROM rxpost AS post WHERE post.threadid = 37408 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 | 31 | Using where |
Time Before: 0.06984 seconds
Time After: 0.07076 seconds
Time Taken: 0.00092 seconds
Memory Before: 6,041.867 KB
Memory After: 6,042.227 KB
Memory Used: 0.359 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.07152 seconds
Time After: 0.07170 seconds
Time Taken: 0.00018 seconds
Memory Before: 6,119.414 KB
Memory After: 6,119.844 KB
Memory Used: 0.430 KB
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 (1059987,1060028) AND a.contenttypeid = 1 ORDER BY a.contentid, a.displayorder
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | range | contentid,filedataid,contenttypeid | contentid | 4 | 2 | Using index condition; Using where; Using filesort | |
1 | SIMPLE | fd | eq_ref | PRIMARY | PRIMARY | 4 | 03forums.a.filedataid | 1 | |
1 | SIMPLE | at | eq_ref | PRIMARY | PRIMARY | 20 | 03forums.fd.extension | 1 | Using where |
Time Before: 0.07313 seconds
Time After: 0.07387 seconds
Time Taken: 0.00074 seconds
Memory Before: 6,168.273 KB
Memory After: 6,168.242 KB
Memory Used: -0.031 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 (01059987,1059996,1060028,1060037,1060056,1060131,1060166,1071307,1071311,1071526,1071527,1071530,1072099,1072372,1072377) ORDER BY post.dateline
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | range | PRIMARY | PRIMARY | 4 | 15 | Using where; Using filesort | |
1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | 03forums.post.userid | 1 | |
1 | SIMPLE | userfield | eq_ref | PRIMARY | PRIMARY | 4 | 03forums.user.userid | 1 | Using where |
1 | SIMPLE | usertextfield | eq_ref | PRIMARY | PRIMARY | 4 | 03forums.user.userid | 1 | Using where |
1 | SIMPLE | icon | eq_ref | PRIMARY | PRIMARY | 2 | 03forums.post.iconid | 1 | |
1 | SIMPLE | avatar | eq_ref | PRIMARY | PRIMARY | 2 | 03forums.user.avatarid | 1 | Using where |
1 | SIMPLE | customavatar | eq_ref | PRIMARY | PRIMARY | 4 | 03forums.user.userid | 1 | Using where |
1 | SIMPLE | editlog | eq_ref | PRIMARY | PRIMARY | 4 | 03forums.post.postid | 1 | |
1 | SIMPLE | postparsed | eq_ref | PRIMARY | PRIMARY | 8 | 03forums.post.postid,const,const | 1 | |
1 | SIMPLE | sigparsed | eq_ref | PRIMARY | PRIMARY | 8 | 03forums.user.userid,const,const | 1 | Using where |
1 | SIMPLE | sigpic | eq_ref | PRIMARY | PRIMARY | 4 | 03forums.post.userid | 1 |
Time Before: 0.07470 seconds
Time After: 0.07659 seconds
Time Taken: 0.00189 seconds
Memory Before: 6,178.789 KB
Memory After: 6,177.445 KB
Memory Used: -1.344 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.14871 seconds
Time After: 0.14884 seconds
Time Taken: 0.00013 seconds
Memory Before: 6,599.125 KB
Memory After: 6,599.625 KB
Memory Used: 0.500 KB
UPDATE rxsession SET lastactivity = 1713424444, location = 'showthread.php?t=37408', inforum = 6, inthread = 37408, badlocation = 0 WHERE sessionhash = '3d6123eae89cf5970590373fab5181ee'
Time Before: 0.15611 seconds
Time After: 0.15645 seconds
Time Taken: 0.00034 seconds
Memory Before: 7,687.742 KB
Memory After: 7,687.953 KB
Memory Used: 0.211 KB
UPDATE rxthread SET views = views + 1 WHERE threadid = 37408
Time Before: 0.15655 seconds
Time After: 0.16712 seconds
Time Taken: 0.01057 seconds
Memory Before: 7,682.188 KB
Memory After: 7,682.531 KB
Memory Used: 0.344 KB