Time Before: 0.00076 seconds
Time After: 0.00106 seconds
Time Taken: 0.00030 seconds
Memory Before: 561.898 KB
Memory After: 675.063 KB
Memory Used: 113.164 KB
Time Before: 0.00111 seconds
Time After: 0.00440 seconds
Time Taken: 0.00329 seconds
Memory Before: 675.063 KB
Memory After: 676.008 KB
Memory Used: 0.945 KB
SET @@sql_mode = ''
Time Before: 0.00469 seconds
Time After: 0.00514 seconds
Time Taken: 0.00044 seconds
Memory Before: 676.703 KB
Memory After: 677.266 KB
Memory Used: 0.563 KB
SELECT * FROM rxdatastore WHERE title IN ('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 | 16 | Using where |
Time Before: 0.00580 seconds
Time After: 0.00668 seconds
Time Taken: 0.00088 seconds
Memory Before: 680.242 KB
Memory After: 680.508 KB
Memory Used: 0.266 KB
Time Before: 0.00521 seconds
Time After: 0.01036 seconds
Time Taken: 0.00515 seconds
Memory Before: 676.477 KB
Memory After: 3,154.750 KB
Memory Used: 2,478.273 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.01125 seconds
Time After: 0.01143 seconds
Time Taken: 0.00018 seconds
Memory Before: 3,642.633 KB
Memory After: 3,643.086 KB
Memory Used: 0.453 KB
SELECT * FROM rxsession WHERE userid = 0 AND host = '172.70.135.118' AND idhash = 'de4868e2481bf0cdb092d9019cf8bce1' 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.01214 seconds
Time After: 0.01240 seconds
Time Taken: 0.00026 seconds
Memory Before: 3,657.023 KB
Memory After: 3,657.398 KB
Memory Used: 0.375 KB
SELECT languageid, phrasegroup_global AS phrasegroup_global, phrasegroup_fronthelp AS phrasegroup_fronthelp, phrasegroup_register AS phrasegroup_register, 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.01324 seconds
Time After: 0.01369 seconds
Time Taken: 0.00045 seconds
Memory Before: 3,667.984 KB
Memory After: 3,667.766 KB
Memory Used: -0.219 KB
Time Before: 0.01154 seconds
Time After: 0.01381 seconds
Time Taken: 0.00226 seconds
Memory Before: 3,649.938 KB
Memory After: 3,735.844 KB
Memory Used: 85.906 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.01753 seconds
Time After: 0.01798 seconds
Time Taken: 0.00044 seconds
Memory Before: 4,239.328 KB
Memory After: 4,239.719 KB
Memory Used: 0.391 KB
SELECT * FROM rxbbcode
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | rxbbcode | ALL | 2 |
Time Before: 0.02135 seconds
Time After: 0.02161 seconds
Time Taken: 0.00027 seconds
Memory Before: 4,872.367 KB
Memory After: 4,872.859 KB
Memory Used: 0.492 KB
SELECT * FROM rxbbcode ORDER BY bbcodetag, twoparams
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | rxbbcode | ALL | 2 | Using filesort |
Time Before: 0.02221 seconds
Time After: 0.02261 seconds
Time Taken: 0.00040 seconds
Memory Before: 4,881.883 KB
Memory After: 4,882.352 KB
Memory Used: 0.469 KB
SELECT title, template FROM rxtemplate WHERE templateid IN (10941,10942,10943,10851,10853,10855,10857,10859,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,8758,8761,8762,8760,8759,8763,8764)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | rxtemplate | range | PRIMARY | PRIMARY | 4 | 54 | Using where |
Time Before: 0.02396 seconds
Time After: 0.02501 seconds
Time Taken: 0.00105 seconds
Memory Before: 5,066.750 KB
Memory After: 5,066.914 KB
Memory Used: 0.164 KB
SELECT *, LENGTH(smilietext) AS smilielen FROM rxsmilie ORDER BY smilielen DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | rxsmilie | ALL | 178 | Using filesort |
Time Before: 0.03135 seconds
Time After: 0.03203 seconds
Time Taken: 0.00068 seconds
Memory Before: 5,305.094 KB
Memory After: 5,305.523 KB
Memory Used: 0.430 KB
SELECT MAX(postid) AS maxpostid FROM rxpost
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | Select tables optimized away |
Time Before: 0.03535 seconds
Time After: 0.03570 seconds
Time Taken: 0.00034 seconds
Memory Before: 5,624.344 KB
Memory After: 5,624.828 KB
Memory Used: 0.484 KB
UPDATE rxsession SET lastactivity = 1674892222, location = '/misc.php?do=bbcode&explain=1', badlocation = 0 WHERE sessionhash = '7969bcfb51cc0430cd7e040c3d17ea0f'
Time Before: 0.04106 seconds
Time After: 0.04126 seconds
Time Taken: 0.00020 seconds
Memory Before: 6,005.570 KB
Memory After: 6,005.789 KB
Memory Used: 0.219 KB