Time Before: 0.00027 seconds
Time After: 0.00030 seconds
Time Taken: 0.00003 seconds
Memory Before: 440.883 KB
Memory After: 442.719 KB
Memory Used: 1.836 KB
Time Before: 0.00036 seconds
Time After: 0.00176 seconds
Time Taken: 0.00140 seconds
Memory Before: 442.703 KB
Memory After: 443.594 KB
Memory Used: 0.891 KB
SET @@sql_mode = ''
Time Before: 0.00200 seconds
Time After: 0.00220 seconds
Time Taken: 0.00020 seconds
Memory Before: 443.641 KB
Memory After: 443.695 KB
Memory Used: 0.055 KB
SELECT * FROM vb_datastore WHERE title IN ('noavatarperms')
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.00397 seconds
Time After: 0.00429 seconds
Time Taken: 0.00031 seconds
Memory Before: 569.602 KB
Memory After: 585.797 KB
Memory Used: 16.195 KB
Time Before: 0.00223 seconds
Time After: 0.00433 seconds
Time Taken: 0.00210 seconds
Memory Before: 443.484 KB
Memory After: 569.336 KB
Memory Used: 125.852 KB
SELECT * FROM vb_session WHERE userid = 0 AND host = '3.145.8.27' AND idhash = '59f38f25218908d08984d1ebae09a2bb' LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | vb_session | ALL | 258 | Using where |
Time Before: 0.00511 seconds
Time After: 0.00575 seconds
Time Taken: 0.00065 seconds
Memory Before: 575.641 KB
Memory After: 592.086 KB
Memory Used: 16.445 KB
SELECT languageid, phrasegroup_global AS phrasegroup_global, phrasegroup_user AS phrasegroup_user, phrasegroup_timezone AS phrasegroup_timezone, phrasegroup_posting AS phrasegroup_posting, phrasegroup_cprofilefield AS phrasegroup_cprofilefield, phrasegroup_cppermission AS phrasegroup_cppermission, 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 vb_language WHERE languageid = 2
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | vb_language | const | PRIMARY | PRIMARY | 2 | const | 1 |
Time Before: 0.00680 seconds
Time After: 0.00767 seconds
Time Taken: 0.00087 seconds
Memory Before: 581.523 KB
Memory After: 894.531 KB
Memory Used: 313.008 KB
Time Before: 0.00447 seconds
Time After: 0.00778 seconds
Time Taken: 0.00331 seconds
Memory Before: 573.195 KB
Memory After: 739.148 KB
Memory Used: 165.953 KB
REPLACE INTO vb_datastore (title, data, unserialize) VALUES ('loadcache', 'a:2:{s:7:\"loadavg\";s:5:\"0.12,\";s:9:\"lastcheck\";i:1719000074;}', 1)
Time Before: 0.01365 seconds
Time After: 0.01510 seconds
Time Taken: 0.00145 seconds
Memory Before: 738.086 KB
Memory After: 738.023 KB
Memory Used: -0.063 KB
SELECT * FROM vb_style WHERE (styleid = 1 AND userselect = 1) OR styleid = 1 ORDER BY styleid ASC LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | vb_style | const | PRIMARY | PRIMARY | 2 | const | 1 |
Time Before: 0.01710 seconds
Time After: 0.01768 seconds
Time Taken: 0.00059 seconds
Memory Before: 869.898 KB
Memory After: 950.406 KB
Memory Used: 80.508 KB
SELECT title, template FROM vb_template WHERE templateid IN (1690,1687,1397,1444,1445,1446,1447,1448,1449,1450,1438,1733,1728,1734,1236,1235,1237,1232,1231,1509,1460,1461,1462,1463,1729,1732,1741,1482,1483,1484,1485,1683,1746,1745,1747,1750,1776,1777,1778)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | vb_template | range | PRIMARY | PRIMARY | 4 | 39 | Using where |
Time Before: 0.01937 seconds
Time After: 0.02021 seconds
Time Taken: 0.00085 seconds
Memory Before: 981.758 KB
Memory After: 1,095.500 KB
Memory Used: 113.742 KB
SELECT text, languageid, special FROM vb_phrase AS phrase LEFT JOIN vb_phrasetype USING (fieldname) WHERE phrase.fieldname = 'error' AND varname = 'nopermission_loggedout' AND languageid IN (-1, 0, 2)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | phrase | range | name_lang_type,languageid | name_lang_type | 816 | 3 | Using index condition | |
1 | SIMPLE | vb_phrasetype | eq_ref | PRIMARY | PRIMARY | 60 | vbtorrents.phrase.fieldname | 1 | Using where |
Time Before: 0.02267 seconds
Time After: 0.02435 seconds
Time Taken: 0.00168 seconds
Memory Before: 1,095.734 KB
Memory After: 1,111.914 KB
Memory Used: 16.180 KB
UPDATE vb_session SET lastactivity = 1719000074, location = '/profile.php?do=customize&explain=1', incalendar = 0, badlocation = 1, useragent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' WHERE sessionhash = '61abb77dcdf8b3fb40ea31cceabe8a84'
Time Before: 0.02602 seconds
Time After: 0.02654 seconds
Time Taken: 0.00052 seconds
Memory Before: 1,165.789 KB
Memory After: 1,165.523 KB
Memory Used: -0.266 KB