Time Before: 0.00075 seconds
Time After: 0.00104 seconds
Time Taken: 0.00029 seconds
Memory Before: 569.672 KB
Memory After: 682.836 KB
Memory Used: 113.164 KB
Time Before: 0.00109 seconds
Time After: 0.02168 seconds
Time Taken: 0.02059 seconds
Memory Before: 682.836 KB
Memory After: 683.781 KB
Memory Used: 0.945 KB
SET @@sql_mode = ''
Time Before: 0.02190 seconds
Time After: 0.02207 seconds
Time Taken: 0.00017 seconds
Memory Before: 684.445 KB
Memory After: 685.008 KB
Memory Used: 0.563 KB
SELECT * FROM rxdatastore WHERE title IN ('smiliecache','bbcodecache','banemail','ranks','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.02254 seconds
Time After: 0.02346 seconds
Time Taken: 0.00092 seconds
Memory Before: 688.250 KB
Memory After: 688.477 KB
Memory Used: 0.227 KB
Time Before: 0.02211 seconds
Time After: 0.02767 seconds
Time Taken: 0.00556 seconds
Memory Before: 684.250 KB
Memory After: 3,443.344 KB
Memory Used: 2,759.094 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.02857 seconds
Time After: 0.02875 seconds
Time Taken: 0.00019 seconds
Memory Before: 3,904.813 KB
Memory After: 3,905.266 KB
Memory Used: 0.453 KB
SELECT * FROM rxsession WHERE userid = 0 AND host = '172.70.38.191' AND idhash = 'a9a99dc22bc4a307a1ed049bf5c81c96' 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.02926 seconds
Time After: 0.02944 seconds
Time Taken: 0.00018 seconds
Memory Before: 4,047.117 KB
Memory After: 4,047.484 KB
Memory Used: 0.367 KB
SELECT languageid, phrasegroup_global AS phrasegroup_global, phrasegroup_timezone AS phrasegroup_timezone, phrasegroup_user AS phrasegroup_user, phrasegroup_register AS phrasegroup_register, phrasegroup_cprofilefield AS phrasegroup_cprofilefield, 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.03019 seconds
Time After: 0.03063 seconds
Time Taken: 0.00044 seconds
Memory Before: 3,932.344 KB
Memory After: 3,932.023 KB
Memory Used: -0.320 KB
Time Before: 0.02886 seconds
Time After: 0.03076 seconds
Time Taken: 0.00190 seconds
Memory Before: 3,912.148 KB
Memory After: 4,036.484 KB
Memory Used: 124.336 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.03545 seconds
Time After: 0.03579 seconds
Time Taken: 0.00034 seconds
Memory Before: 4,689.938 KB
Memory After: 4,690.328 KB
Memory Used: 0.391 KB
SELECT title, template FROM rxtemplate WHERE templateid IN (0,11170,11173,11174,11172,11334,11326,11327,11328,11329,11330,11332,11331,11333,11335,11044,11050,10916,10917,10920,11383,10949,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)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | rxtemplate | range | PRIMARY | PRIMARY | 4 | 60 | Using where |
Time Before: 0.03823 seconds
Time After: 0.03974 seconds
Time Taken: 0.00152 seconds
Memory Before: 5,426.766 KB
Memory After: 5,426.875 KB
Memory Used: 0.109 KB
SELECT * FROM rxprofilefield WHERE editable > 0 AND required <> 0 ORDER BY displayorder
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | rxprofilefield | ALL | editable | 4 | Using where; Using filesort |
Time Before: 0.04452 seconds
Time After: 0.04479 seconds
Time Taken: 0.00027 seconds
Memory Before: 5,606.602 KB
Memory After: 5,607.023 KB
Memory Used: 0.422 KB
INSERT IGNORE INTO rxsession (sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate, apiclientid, apiaccesstoken) VALUES ('aeff4d285ca118f1e42e3fd31517ece0', 0, '172.70.38.191', 'a9a99dc22bc4a307a1ed049bf5c81c96', 1702324624, '/register.php?explain=1', 0, 0, 0, 0, 0, 0, 0, 'CCBot/2.0 (https://commoncrawl.org/faq/)', 0, 0, 0, '')
Time Before: 0.04826 seconds
Time After: 0.04857 seconds
Time Taken: 0.00030 seconds
Memory Before: 5,858.805 KB
Memory After: 5,858.734 KB
Memory Used: -0.070 KB