Time Before: 0.00106 seconds
Time After: 0.00143 seconds
Time Taken: 0.00037 seconds
Memory Before: 561.898 KB
Memory After: 675.063 KB
Memory Used: 113.164 KB
Time Before: 0.00150 seconds
Time After: 0.00398 seconds
Time Taken: 0.00248 seconds
Memory Before: 675.063 KB
Memory After: 676.008 KB
Memory Used: 0.945 KB
SET @@sql_mode = ''
Time Before: 0.00428 seconds
Time After: 0.00453 seconds
Time Taken: 0.00025 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.00511 seconds
Time After: 0.00594 seconds
Time Taken: 0.00083 seconds
Memory Before: 680.242 KB
Memory After: 680.508 KB
Memory Used: 0.266 KB
Time Before: 0.00460 seconds
Time After: 0.01144 seconds
Time Taken: 0.00684 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.01265 seconds
Time After: 0.01285 seconds
Time Taken: 0.00020 seconds
Memory Before: 3,616.313 KB
Memory After: 3,616.766 KB
Memory Used: 0.453 KB
SELECT * FROM rxsession WHERE userid = 0 AND host = '172.70.135.202' 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.01357 seconds
Time After: 0.01386 seconds
Time Taken: 0.00029 seconds
Memory Before: 3,630.703 KB
Memory After: 3,631.078 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.01452 seconds
Time After: 0.01489 seconds
Time Taken: 0.00038 seconds
Memory Before: 3,641.664 KB
Memory After: 3,641.445 KB
Memory Used: -0.219 KB
Time Before: 0.01300 seconds
Time After: 0.01504 seconds
Time Taken: 0.00204 seconds
Memory Before: 3,623.617 KB
Memory After: 3,709.523 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.01994 seconds
Time After: 0.02039 seconds
Time Taken: 0.00045 seconds
Memory Before: 4,210.344 KB
Memory After: 4,210.734 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.02505 seconds
Time After: 0.02550 seconds
Time Taken: 0.00045 seconds
Memory Before: 4,843.391 KB
Memory After: 4,843.883 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.02589 seconds
Time After: 0.02610 seconds
Time Taken: 0.00021 seconds
Memory Before: 4,852.898 KB
Memory After: 4,853.367 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.02753 seconds
Time After: 0.02861 seconds
Time Taken: 0.00108 seconds
Memory Before: 5,037.766 KB
Memory After: 5,037.930 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 | 143 | Using filesort |
Time Before: 0.03605 seconds
Time After: 0.03727 seconds
Time Taken: 0.00122 seconds
Memory Before: 5,276.008 KB
Memory After: 5,276.438 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.04130 seconds
Time After: 0.04150 seconds
Time Taken: 0.00020 seconds
Memory Before: 5,595.273 KB
Memory After: 5,595.758 KB
Memory Used: 0.484 KB
UPDATE rxsession SET lastactivity = 1739057017, location = '/misc.php?do=bbcode&explain=1', inforum = 0, badlocation = 0 WHERE sessionhash = '0e9dea64aca3654d3f07464bd04ba5c5'
Time Before: 0.04761 seconds
Time After: 0.04781 seconds
Time Taken: 0.00020 seconds
Memory Before: 5,976.789 KB
Memory After: 5,977.000 KB
Memory Used: 0.211 KB