Time Before: 0.00064 seconds
Time After: 0.00076 seconds
Time Taken: 0.00012 seconds
Memory Before: 525.770 KB
Memory After: 539.984 KB
Memory Used: 14.215 KB
Time Before: 0.00079 seconds
Time After: 0.00245 seconds
Time Taken: 0.00166 seconds
Memory Before: 539.910 KB
Memory After: 541.961 KB
Memory Used: 2.051 KB
SET @@sql_mode = ''
Time Before: 0.00286 seconds
Time After: 0.00321 seconds
Time Taken: 0.00036 seconds
Memory Before: 541.922 KB
Memory After: 542.227 KB
Memory Used: 0.305 KB
SELECT *
FROM datastore
WHERE title IN ('smiliecache','bbcodecache','mailqueue','bookmarksitecache','navdata','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream','routes')| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | datastore | range | PRIMARY | PRIMARY | 150 | 20 | 100.00 | Using index condition |
Time Before: 0.00471 seconds
Time After: 0.00847 seconds
Time Taken: 0.00376 seconds
Memory Before: 544.609 KB
Memory After: 546.027 KB
Memory Used: 1.418 KB
Time Before: 0.00323 seconds
Time After: 0.00914 seconds
Time Taken: 0.00591 seconds
Memory Before: 541.680 KB
Memory After: 1,170.512 KB
Memory Used: 628.832 KB
SELECT *
FROM datastore
WHERE title IN ('forumcache','usergroupcache')| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | datastore | range | PRIMARY | PRIMARY | 150 | 2 | 100.00 | Using index condition |
Time Before: 0.01025 seconds
Time After: 0.01185 seconds
Time Taken: 0.00160 seconds
Memory Before: 1,521.254 KB
Memory After: 1,522.629 KB
Memory Used: 1.375 KB
SELECT * FROM session WHERE userid = 0 AND host = '3.14.130.45' AND idhash = '3c09b83d90a29918aad3d53c27faf9ed' LIMIT 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | session | ref | guest_lookup,user_activity | guest_lookup | 145 | const,const,const | 2 | 100.00 |
Time Before: 0.01283 seconds
Time After: 0.01342 seconds
Time Taken: 0.00060 seconds
Memory Before: 1,530.215 KB
Memory After: 1,531.547 KB
Memory Used: 1.332 KB
SELECT languageid, phrasegroup_global AS phrasegroup_global, phrasegroup_posting AS phrasegroup_posting, phrasegroup_postbit AS phrasegroup_postbit, phrasegroup_showthread AS phrasegroup_showthread, phrasegroup_inlinemod AS phrasegroup_inlinemod, 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 = 2
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | language | const | PRIMARY | PRIMARY | 2 | const | 1 | 100.00 |
Time Before: 0.01472 seconds
Time After: 0.01636 seconds
Time Taken: 0.00163 seconds
Memory Before: 1,538.652 KB
Memory After: 1,539.383 KB
Memory Used: 0.730 KB
Time Before: 0.01199 seconds
Time After: 0.01642 seconds
Time Taken: 0.00443 seconds
Memory Before: 1,526.563 KB
Memory After: 1,636.551 KB
Memory Used: 109.988 KB
SELECT post.*, IF(post.visible = 2, 1, 0) AS isdeleted, editlog.userid AS edit_userid, editlog.dateline AS edit_dateline, editlog.reason AS edit_reason, editlog.hashistory FROM post AS post LEFT JOIN editlog AS editlog ON (editlog.postid = post.postid) WHERE post.postid = 1076591 LIMIT 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | post | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | ||
| 1 | SIMPLE | editlog | const | PRIMARY | PRIMARY | 4 | const | 0 | 0.00 | unique row not found |
Time Before: 0.01765 seconds
Time After: 0.01808 seconds
Time Taken: 0.00044 seconds
Memory Before: 1,568.793 KB
Memory After: 1,570.074 KB
Memory Used: 1.281 KB
SELECT IF(thread.visible = 2, 1, 0) AS isdeleted, post.pagetext AS description, thread.* FROM thread AS thread LEFT JOIN post AS post ON(post.postid = thread.firstpostid) WHERE thread.threadid = 81115 LIMIT 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | thread | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | ||
| 1 | SIMPLE | post | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 |
Time Before: 0.01878 seconds
Time After: 0.01925 seconds
Time Taken: 0.00047 seconds
Memory Before: 1,573.727 KB
Memory After: 1,575.145 KB
Memory Used: 1.418 KB
SELECT forum.*, NOT ISNULL(podcast.forumid) AS podcast FROM forum AS forum LEFT JOIN podcast AS podcast ON (forum.forumid = podcast.forumid AND podcast.enabled = 1) WHERE forum.forumid = 171 LIMIT 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | podcast | system | PRIMARY | 0 | 0.00 | const row not found | ||||
| 1 | SIMPLE | forum | const | PRIMARY | PRIMARY | 2 | const | 1 | 100.00 |
Time Before: 0.01994 seconds
Time After: 0.02042 seconds
Time Taken: 0.00048 seconds
Memory Before: 1,581.207 KB
Memory After: 1,582.684 KB
Memory Used: 1.477 KB
SELECT MAX(permissions & 1) AS perm FROM cms_permissions WHERE nodeid = 1 AND usergroupid IN (1)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | cms_permissions | const | usergroupid,nodeid | usergroupid | 8 | const,const | 1 | 100.00 |
Time Before: 0.02109 seconds
Time After: 0.02141 seconds
Time Taken: 0.00032 seconds
Memory Before: 1,595.508 KB
Memory After: 1,596.828 KB
Memory Used: 1.320 KB
SELECT text, languageid, special FROM phrase AS phrase LEFT JOIN phrasetype USING (fieldname) WHERE phrase.fieldname = 'error' AND varname = 'toobusy' AND languageid IN (-1, 0, 2)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phrase | range | name_lang_type,languageid | name_lang_type | 816 | 3 | 100.00 | Using index condition | ||
| 1 | SIMPLE | phrasetype | eq_ref | PRIMARY | PRIMARY | 60 | mediaworxwfc4d2.phrase.fieldname | 1 | 100.00 | Using where |
Time Before: 0.02233 seconds
Time After: 0.02295 seconds
Time Taken: 0.00062 seconds
Memory Before: 1,599.289 KB
Memory After: 1,600.551 KB
Memory Used: 1.262 KB
SELECT * FROM style WHERE (styleid = 1 AND userselect = 1) OR styleid = 1 ORDER BY styleid ASC LIMIT 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | style | const | PRIMARY | PRIMARY | 2 | const | 1 | 100.00 |
Time Before: 0.02477 seconds
Time After: 0.02544 seconds
Time Taken: 0.00067 seconds
Memory Before: 1,681.219 KB
Memory After: 1,682.625 KB
Memory Used: 1.406 KB
SELECT title, template FROM template WHERE templateid IN (83,82,84,85,2840,2404,2405,2407,2413,2412,1161,2611,2597,2598,2600,2599,2602,2604,2605,2606,2609,2304,2306,2308,2310,2312,2661,2665,2666,2667,2664,2734,2585,2584,2586,2591,2589,2758,2366,2367,2533,2360,2359,2362,2363,2376,2374,980,1823,3156,2831,78,77,79,69,68,75,76,74,73,2575,2860,3159,2525,2522,2523,2524,2868,0,0,2882,2823,2545,2546,2548,2549,2772,2852,2891,2844,2853,2372,2371,2375,1757,1001,1004,1195,1210,1284,2198)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | template | range | PRIMARY | PRIMARY | 4 | 90 | 100.00 | Using index condition |
Time Before: 0.02691 seconds
Time After: 0.02839 seconds
Time Taken: 0.00148 seconds
Memory Before: 2,239.684 KB
Memory After: 2,241.660 KB
Memory Used: 1.977 KB
SELECT t.tabid, t.title, t.url,t.tabmode, t.script, t.target, t.pusergroup, t.nusergroup, t.position, t.enable, c.title as ctitle, c.url as curl, c.target as ctarget, c.pusergroup as cpusergroup, c.nusergroup as cnusergroup,c.tipo,c.enable as cenable
FROM evbs_sstabs as t
LEFT JOIN evbs_sstabs_childs as c ON t.tabid=c.tabid
WHERE t.enable=1
ORDER BY t.displayorder,c.tipo, c.displayorder| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | t | ALL | 6 | 16.67 | Using where; Using temporary; Using filesort | |||||
| 1 | SIMPLE | c | ALL | 6 | 100.00 | Using where; Using join buffer (hash join) |
Time Before: 0.03037 seconds
Time After: 0.03102 seconds
Time Taken: 0.00065 seconds
Memory Before: 2,500.426 KB
Memory After: 2,501.848 KB
Memory Used: 1.422 KB
INSERT IGNORE INTO session
(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate, apiclientid, apiaccesstoken)
VALUES
('db2bb302ec7aecdecc0f3557af909176', 0, '3.14.130.45', '3c09b83d90a29918aad3d53c27faf9ed', 1730424642, '/showthread.php?explain=1&p=1076591', 0, 0, 0, 0, 0, 0, 3, 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 0, 0, 0, '')Time Before: 0.03316 seconds
Time After: 0.03372 seconds
Time Taken: 0.00056 seconds
Memory Before: 2,576.289 KB
Memory After: 2,576.059 KB
Memory Used: -0.230 KB