Time Before: 0.00099 seconds
Time After: 0.00134 seconds
Time Taken: 0.00035 seconds
Memory Before: 560.148 KB
Memory After: 673.313 KB
Memory Used: 113.164 KB
Time Before: 0.00141 seconds
Time After: 0.00289 seconds
Time Taken: 0.00148 seconds
Memory Before: 673.313 KB
Memory After: 674.258 KB
Memory Used: 0.945 KB
SET @@sql_mode = ''
Time Before: 0.00319 seconds
Time After: 0.00334 seconds
Time Taken: 0.00015 seconds
Memory Before: 674.922 KB
Memory After: 675.484 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.00394 seconds
Time After: 0.00486 seconds
Time Taken: 0.00092 seconds
Memory Before: 678.461 KB
Memory After: 678.727 KB
Memory Used: 0.266 KB
Time Before: 0.00340 seconds
Time After: 0.00986 seconds
Time Taken: 0.00646 seconds
Memory Before: 674.727 KB
Memory After: 3,152.969 KB
Memory Used: 2,478.242 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.01093 seconds
Time After: 0.01107 seconds
Time Taken: 0.00014 seconds
Memory Before: 3,614.508 KB
Memory After: 3,614.961 KB
Memory Used: 0.453 KB
SELECT * FROM rxsession WHERE userid = 0 AND host = '172.71.255.29' AND idhash = '464dba50fba5b607ab8db58051024ce9' 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.01165 seconds
Time After: 0.01195 seconds
Time Taken: 0.00029 seconds
Memory Before: 3,628.898 KB
Memory After: 3,629.266 KB
Memory Used: 0.367 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.01265 seconds
Time After: 0.01308 seconds
Time Taken: 0.00043 seconds
Memory Before: 3,640.023 KB
Memory After: 3,639.805 KB
Memory Used: -0.219 KB
Time Before: 0.01121 seconds
Time After: 0.01323 seconds
Time Taken: 0.00202 seconds
Memory Before: 3,621.844 KB
Memory After: 3,707.914 KB
Memory Used: 86.070 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.01765 seconds
Time After: 0.01802 seconds
Time Taken: 0.00037 seconds
Memory Before: 4,208.750 KB
Memory After: 4,209.141 KB
Memory Used: 0.391 KB
SELECT smilietext,smiliepath,smilie.title,imagecategory.title AS category FROM rxsmilie AS smilie LEFT JOIN rximagecategory AS imagecategory USING(imagecategoryid) ORDER BY imagecategory.displayorder, imagecategory.title, smilie.displayorder
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | smilie | ALL | 178 | Using temporary; Using filesort | ||||
1 | SIMPLE | imagecategory | eq_ref | PRIMARY | PRIMARY | 2 | 03forums.smilie.imagecategoryid | 1 |
Time Before: 0.02283 seconds
Time After: 0.05857 seconds
Time Taken: 0.03574 seconds
Memory Before: 4,768.578 KB
Memory After: 4,768.852 KB
Memory Used: 0.273 KB
SELECT title, template FROM rxtemplate WHERE templateid IN (10945,10947,10946,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 | 49 | Using where |
Time Before: 0.05982 seconds
Time After: 0.06068 seconds
Time Taken: 0.00085 seconds
Memory Before: 4,940.164 KB
Memory After: 4,940.359 KB
Memory Used: 0.195 KB
UPDATE rxsession SET lastactivity = 1722054418, location = '/misc.php?do=showsmilies&explain=1', badlocation = 0, bypass = 0 WHERE sessionhash = '4a1277a00f829bb413133807a34b41d0'
Time Before: 0.09118 seconds
Time After: 0.09139 seconds
Time Taken: 0.00021 seconds
Memory Before: 5,664.695 KB
Memory After: 5,664.898 KB
Memory Used: 0.203 KB