Time Before: 0.00057 seconds
Time After: 0.00079 seconds
Time Taken: 0.00022 seconds
Memory Before: 557.555 KB
Memory After: 670.719 KB
Memory Used: 113.164 KB
Time Before: 0.00083 seconds
Time After: 0.00296 seconds
Time Taken: 0.00213 seconds
Memory Before: 670.719 KB
Memory After: 671.664 KB
Memory Used: 0.945 KB
SET @@sql_mode = ''
Time Before: 0.00314 seconds
Time After: 0.00331 seconds
Time Taken: 0.00016 seconds
Memory Before: 672.328 KB
Memory After: 672.891 KB
Memory Used: 0.563 KB
SELECT * FROM rxdatastore WHERE title IN ('tagcloud','iconcache','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 | 18 | Using where |
Time Before: 0.00386 seconds
Time After: 0.00456 seconds
Time Taken: 0.00070 seconds
Memory Before: 676.070 KB
Memory After: 676.320 KB
Memory Used: 0.250 KB
Time Before: 0.00336 seconds
Time After: 0.00800 seconds
Time Taken: 0.00464 seconds
Memory Before: 672.133 KB
Memory After: 3,168.625 KB
Memory Used: 2,496.492 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.00876 seconds
Time After: 0.00889 seconds
Time Taken: 0.00012 seconds
Memory Before: 3,630.156 KB
Memory After: 3,630.609 KB
Memory Used: 0.453 KB
SELECT * FROM rxsession WHERE userid = 0 AND host = '172.71.191.130' AND idhash = '86b64c8f66ea7ad766056719c3d347a6' 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.00941 seconds
Time After: 0.00963 seconds
Time Taken: 0.00022 seconds
Memory Before: 3,644.547 KB
Memory After: 3,644.922 KB
Memory Used: 0.375 KB
SELECT languageid, phrasegroup_global AS phrasegroup_global, phrasegroup_inlinemod AS phrasegroup_inlinemod, phrasegroup_search AS phrasegroup_search, phrasegroup_prefix AS phrasegroup_prefix, 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.01026 seconds
Time After: 0.01065 seconds
Time Taken: 0.00039 seconds
Memory Before: 3,655.633 KB
Memory After: 3,655.375 KB
Memory Used: -0.258 KB
Time Before: 0.00900 seconds
Time After: 0.01078 seconds
Time Taken: 0.00178 seconds
Memory Before: 3,637.492 KB
Memory After: 3,719.570 KB
Memory Used: 82.078 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.01393 seconds
Time After: 0.01418 seconds
Time Taken: 0.00026 seconds
Memory Before: 4,249.711 KB
Memory After: 4,250.102 KB
Memory Used: 0.391 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.01658 seconds
Time After: 0.01674 seconds
Time Taken: 0.00016 seconds
Memory Before: 5,063.984 KB
Memory After: 5,064.414 KB
Memory Used: 0.430 KB
SELECT tagid, tagtext, canonicaltagid, dateline FROM rxtag WHERE tagtext = 'robert timms'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | rxtag | const | tagtext | tagtext | 102 | const | 1 |
Time Before: 0.01765 seconds
Time After: 0.01777 seconds
Time Taken: 0.00013 seconds
Memory Before: 5,286.086 KB
Memory After: 5,286.523 KB
Memory Used: 0.438 KB
SELECT searchlog.* FROM rxsearchlog AS searchlog WHERE searchhash = '167faea5ea7fac1ecf6af0744ff485ca' AND sortby = '' AND sortorder = 'asc' AND dateline > 1730602008 AND userid = 0 AND completed = 1 ORDER BY dateline DESC LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | searchlog | ref | search,userfloodcheck | search | 56 | const,const,const,const | 1 | Using index condition; Using where; Using filesort |
Time Before: 0.01846 seconds
Time After: 0.01876 seconds
Time Taken: 0.00030 seconds
Memory Before: 5,298.867 KB
Memory After: 5,299.133 KB
Memory Used: 0.266 KB
SELECT title, template FROM rxtemplate WHERE templateid IN (0,11443,11183,0,11196,11197,11316,11318,11317,11089,11306,11305,11285,11291,11193,11202,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 | 54 | Using where |
Time Before: 0.01952 seconds
Time After: 0.02058 seconds
Time Taken: 0.00105 seconds
Memory Before: 5,481.250 KB
Memory After: 5,481.406 KB
Memory Used: 0.156 KB
SELECT moderator.*, user.username, IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid FROM rxmoderator AS moderator INNER JOIN rxuser AS user USING(userid)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | moderator | ALL | userid_forumid | 137 | ||||
1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | 03forums.moderator.userid | 1 |
Time Before: 0.02534 seconds
Time After: 0.02589 seconds
Time Taken: 0.00055 seconds
Memory Before: 5,867.828 KB
Memory After: 5,868.141 KB
Memory Used: 0.313 KB
SELECT thread.*,post.pagetext AS preview,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, user.avatarrevision, customavatar.dateline AS avatardateline, customavatar.width AS width, customavatar.height AS height, customavatar.height_thumb AS height_thumb, customavatar.width_thumb AS width_thumb, customavatar.filedata_thumb, first_user.avatarrevision AS first_avatarrevision, first_avatar.avatarpath AS first_avatarpath, NOT ISNULL(first_customavatar.userid) AS first_hascustomavatar, first_customavatar.dateline AS first_avatardateline, first_customavatar.width AS first_width, first_customavatar.height AS first_height, first_customavatar.height_thumb AS first_height_thumb, first_customavatar.width_thumb AS first_width_thumb, first_customavatar.filedata_thumb AS first_filedata_thumb FROM rxthread AS thread LEFT JOIN rxpost AS post ON(post.postid = thread.firstpostid) LEFT JOIN rxuser AS user ON (user.userid = thread.lastposterid) LEFT JOIN rxavatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN rxcustomavatar AS customavatar ON (customavatar.userid = user.userid) LEFT JOIN rxuser AS first_user ON (first_user.userid = thread.postuserid) LEFT JOIN rxavatar AS first_avatar ON (first_avatar.avatarid = first_user.avatarid) LEFT JOIN rxcustomavatar AS first_customavatar ON (first_customavatar.userid = first_user.userid) WHERE thread.threadid IN (142588)
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 | |
1 | SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | avatar | const | PRIMARY | PRIMARY | 2 | const | 0 | unique row not found |
1 | SIMPLE | customavatar | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | first_user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | first_avatar | const | PRIMARY | PRIMARY | 2 | const | 0 | unique row not found |
1 | SIMPLE | first_customavatar | const | PRIMARY | PRIMARY | 4 | const | 1 |
Time Before: 0.02758 seconds
Time After: 0.02789 seconds
Time Taken: 0.00031 seconds
Memory Before: 6,200.898 KB
Memory After: 6,200.008 KB
Memory Used: -0.891 KB
UPDATE rxsearchlog SET results = 'a:4:{i:0;a:1:{i:0;a:3:{i:0;s:1:\"2\";i:1;s:6:\"142588\";i:2;s:6:\"142588\";}}i:1;i:0;i:2;a:1:{i:2;a:2:{i:0;s:6:\"142588\";i:1;s:6:\"142588\";}}i:3;a:1:{i:2;a:0:{}}}' WHERE searchlogid = 11138715
Time Before: 0.03445 seconds
Time After: 0.07527 seconds
Time Taken: 0.04082 seconds
Memory Before: 7,067.188 KB
Memory After: 7,067.344 KB
Memory Used: 0.156 KB
UPDATE rxsession SET lastactivity = 1730605608, location = '/tags.php?tag=robert%20timms&explain=1', badlocation = 0 WHERE sessionhash = '3e5fe5659a8b4de0a4096ae1daf8a35e'
Time Before: 0.08064 seconds
Time After: 0.08080 seconds
Time Taken: 0.00016 seconds
Memory Before: 7,569.109 KB
Memory After: 7,569.320 KB
Memory Used: 0.211 KB