Time Before: 0.00038 seconds
Time After: 0.00048 seconds
Time Taken: 0.00010 seconds
Memory Before: 520.172 KB
Memory After: 545.102 KB
Memory Used: 24.930 KB
Time Before: 0.00050 seconds
Time After: 0.00072 seconds
Time Taken: 0.00022 seconds
Memory Before: 545.039 KB
Memory After: 545.953 KB
Memory Used: 0.914 KB
SET @@sql_mode = ''
Time Before: 0.00083 seconds
Time After: 0.00090 seconds
Time Taken: 0.00008 seconds
Memory Before: 546.508 KB
Memory After: 547.031 KB
Memory Used: 0.523 KB
SELECT * FROM datastore 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 | datastore | range | PRIMARY | PRIMARY | 52 | 16 | Using index condition |
Time Before: 0.00119 seconds
Time After: 0.00150 seconds
Time Taken: 0.00030 seconds
Memory Before: 549.766 KB
Memory After: 550.617 KB
Memory Used: 0.852 KB
Time Before: 0.00092 seconds
Time After: 0.00204 seconds
Time Taken: 0.00111 seconds
Memory Before: 546.281 KB
Memory After: 1,263.961 KB
Memory Used: 717.680 KB
SELECT * FROM datastore WHERE title IN ('dbtech_downloads_category','dbtech_downloads_domain','dbtech_downloads_extension','dbtech_downloads_extensiongroup')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | datastore | range | PRIMARY | PRIMARY | 52 | 4 | Using index condition |
Time Before: 0.00327 seconds
Time After: 0.00337 seconds
Time Taken: 0.00011 seconds
Memory Before: 1,829.672 KB
Memory After: 1,830.172 KB
Memory Used: 0.500 KB
SELECT * FROM session WHERE sessionhash = 'afd29b30713c209d54d474b338cb787e' AND lastactivity > 1746033214 AND idhash = 'ab571baf4e5676a75eff7ab619acef3b'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | session | const | PRIMARY,guest_lookup,last_activity | PRIMARY | 34 | const | 1 |
Time Before: 0.00364 seconds
Time After: 0.00375 seconds
Time Taken: 0.00011 seconds
Memory Before: 1,851.992 KB
Memory After: 1,852.570 KB
Memory Used: 0.578 KB
SELECT languageid, phrasegroup_global AS phrasegroup_global, phrasegroup_user AS phrasegroup_user, phrasegroup_search AS phrasegroup_search, 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 language WHERE languageid = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | language | system | PRIMARY | 1 |
Time Before: 0.00409 seconds
Time After: 0.00425 seconds
Time Taken: 0.00016 seconds
Memory Before: 1,863.484 KB
Memory After: 1,863.453 KB
Memory Used: -0.031 KB
Time Before: 0.00345 seconds
Time After: 0.00431 seconds
Time Taken: 0.00086 seconds
Memory Before: 1,844.883 KB
Memory After: 1,959.758 KB
Memory Used: 114.875 KB
SELECT * FROM datastore WHERE title IN ('dbtech_downloads_domain','dbtech_downloads_extension')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | datastore | range | PRIMARY | PRIMARY | 52 | 2 | Using index condition |
Time Before: 0.00468 seconds
Time After: 0.00475 seconds
Time Taken: 0.00008 seconds
Memory Before: 2,008.188 KB
Memory After: 2,008.680 KB
Memory Used: 0.492 KB
SELECT * FROM style WHERE (styleid = 4 AND userselect = 1) OR styleid = 4 ORDER BY styleid ASC LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | style | const | PRIMARY | PRIMARY | 2 | const | 1 |
Time Before: 0.03416 seconds
Time After: 0.03427 seconds
Time Taken: 0.00012 seconds
Memory Before: 2,471.141 KB
Memory After: 2,471.734 KB
Memory Used: 0.594 KB
SELECT profilefieldid, type, data, optional, memberlist, searchable FROM profilefield WHERE form = 0 AND hidden = 0 ORDER BY displayorder
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | profilefield | ALL | 4 | Using where; Using filesort |
Time Before: 0.03509 seconds
Time After: 0.03518 seconds
Time Taken: 0.00009 seconds
Memory Before: 3,076.102 KB
Memory After: 3,076.773 KB
Memory Used: 0.672 KB
SELECT COUNT(*) AS users FROM user AS user WHERE 1=1 AND username LIKE("I%") AND (user.usergroupid IN (-1,6,8,7,2,5))
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | user | range|filter | usergroupid,username | usergroupid|username | 2|102 | 93 (3%) | Using index condition; Using where; Using rowid filter |
Time Before: 0.03551 seconds
Time After: 0.03582 seconds
Time Taken: 0.00032 seconds
Memory Before: 3,092.281 KB
Memory After: 3,092.773 KB
Memory Used: 0.492 KB
SELECT text, languageid, special FROM phrase AS phrase LEFT JOIN phrasetype USING (fieldname) WHERE phrase.fieldname = 'error' AND varname = 'searchnoresults' AND languageid IN (-1, 0, 1)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | phrase | range | name_lang_type,languageid | name_lang_type | 276 | 3 | Using index condition | |
1 | SIMPLE | phrasetype | const | PRIMARY | PRIMARY | 22 | const | 1 | Using where |
Time Before: 0.03611 seconds
Time After: 0.04480 seconds
Time Taken: 0.00869 seconds
Memory Before: 3,094.445 KB
Memory After: 3,094.883 KB
Memory Used: 0.438 KB
SELECT title, template FROM template WHERE templateid IN (15351,15353,15355,15354,15297,15298,15300,15306,15305,15277,15073,15072,15723,15724,12126,12125,12127,12122,12121,12713,12714,12712,12711,12130,12131,12718,15468,15753,15070,15418,15415,15416,15417,15761,0,0,15775,15716,15438,15439,15441,15442,15665,15745,15784,15737,15746,15265,15264,15268)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | template | range | PRIMARY | PRIMARY | 4 | 49 | Using index condition |
Time Before: 0.04548 seconds
Time After: 0.04590 seconds
Time Taken: 0.00041 seconds
Memory Before: 3,269.109 KB
Memory After: 3,270.484 KB
Memory Used: 1.375 KB
UPDATE session SET location = '/memberlist.php?explain=1<r=I&pp=30', badlocation = 3, useragent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' WHERE sessionhash = 'afd29b30713c209d54d474b338cb787e'
Time Before: 0.04911 seconds
Time After: 0.04921 seconds
Time Taken: 0.00010 seconds
Memory Before: 3,597.828 KB
Memory After: 3,597.953 KB
Memory Used: 0.125 KB