Time Before: 0.00062 seconds
Time After: 0.00073 seconds
Time Taken: 0.00011 seconds
Memory Before: 524.008 KB
Memory After: 538.223 KB
Memory Used: 14.215 KB
Time Before: 0.00076 seconds
Time After: 0.00271 seconds
Time Taken: 0.00196 seconds
Memory Before: 538.148 KB
Memory After: 540.199 KB
Memory Used: 2.051 KB
SET @@sql_mode = ''
Time Before: 0.00319 seconds
Time After: 0.00361 seconds
Time Taken: 0.00042 seconds
Memory Before: 540.160 KB
Memory After: 540.465 KB
Memory Used: 0.305 KB
SELECT *
FROM datastore
WHERE title IN ('smiliecache','bbcodecache','ranks','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 | 19 | 100.00 | Using index condition |
Time Before: 0.00522 seconds
Time After: 0.00927 seconds
Time Taken: 0.00405 seconds
Memory Before: 542.781 KB
Memory After: 544.203 KB
Memory Used: 1.422 KB
Time Before: 0.00363 seconds
Time After: 0.01003 seconds
Time Taken: 0.00639 seconds
Memory Before: 539.918 KB
Memory After: 1,164.832 KB
Memory Used: 624.914 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.01115 seconds
Time After: 0.01259 seconds
Time Taken: 0.00144 seconds
Memory Before: 1,515.613 KB
Memory After: 1,516.988 KB
Memory Used: 1.375 KB
SELECT * FROM session WHERE userid = 0 AND host = '18.119.160.42' AND idhash = '4fae545c6eddbc8db64212368c1b8f8d' 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.01339 seconds
Time After: 0.01381 seconds
Time Taken: 0.00043 seconds
Memory Before: 1,522.535 KB
Memory After: 1,523.863 KB
Memory Used: 1.328 KB
SELECT languageid, phrasegroup_global AS phrasegroup_global, phrasegroup_threadmanage AS phrasegroup_threadmanage, phrasegroup_posting AS phrasegroup_posting, phrasegroup_postbit AS phrasegroup_postbit, 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.01520 seconds
Time After: 0.01689 seconds
Time Taken: 0.00169 seconds
Memory Before: 1,530.852 KB
Memory After: 1,531.617 KB
Memory Used: 0.766 KB
Time Before: 0.01269 seconds
Time After: 0.01695 seconds
Time Taken: 0.00426 seconds
Memory Before: 1,519.059 KB
Memory After: 1,626.059 KB
Memory Used: 107.000 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 = 1064500 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 | 1 | 100.00 |
Time Before: 0.01825 seconds
Time After: 0.01887 seconds
Time Taken: 0.00062 seconds
Memory Before: 1,562.543 KB
Memory After: 1,563.824 KB
Memory Used: 1.281 KB
SELECT IF(thread.visible = 2, 1, 0) AS isdeleted, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed, emailupdate, folderid, post.pagetext AS description, thread.* FROM thread AS thread LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = 0 AND subscribethread.canview = 1) LEFT JOIN post AS post ON(post.postid = thread.firstpostid) WHERE thread.threadid = 80924 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 | subscribethread | const | threadid,userid | threadid | 8 | const,const | 0 | 0.00 | unique row not found | |
| 1 | SIMPLE | post | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 |
Time Before: 0.02160 seconds
Time After: 0.02225 seconds
Time Taken: 0.00065 seconds
Memory Before: 1,568.266 KB
Memory After: 1,569.465 KB
Memory Used: 1.199 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 = 80 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.02297 seconds
Time After: 0.02353 seconds
Time Taken: 0.00056 seconds
Memory Before: 1,574.203 KB
Memory After: 1,575.680 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.02426 seconds
Time After: 0.02467 seconds
Time Taken: 0.00041 seconds
Memory Before: 1,588.215 KB
Memory After: 1,589.535 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.02583 seconds
Time After: 0.02657 seconds
Time Taken: 0.00074 seconds
Memory Before: 1,591.988 KB
Memory After: 1,593.250 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.02842 seconds
Time After: 0.02913 seconds
Time Taken: 0.00070 seconds
Memory Before: 1,673.797 KB
Memory After: 1,675.211 KB
Memory Used: 1.414 KB
SELECT title, template FROM template WHERE templateid IN (2540,2531,2541,2542,2543,2532,2404,2405,2407,2413,2412,1161,2611,2597,2598,2600,2599,2606,2609,2304,2306,2308,2310,2312,0,2376,2402,980,1823,3156,2831,78,77,79,69,68,75,76,74,73,82,83,84,2575,2860,3159,2525,2522,2523,2524,2868,0,0,2882,2823,2545,2546,2548,2549,2772,2852,2891,2844,2853,2372,2371,2375,2359,2364,2360,2366,2367,2362,2363,2365,2538,2533,2536,2537,2617,2618,2539,2534,2840,1757,1001,1004,1195,1284,2198)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | template | range | PRIMARY | PRIMARY | 4 | 88 | 100.00 | Using index condition |
Time Before: 0.03094 seconds
Time After: 0.03231 seconds
Time Taken: 0.00137 seconds
Memory Before: 2,233.914 KB
Memory After: 2,235.871 KB
Memory Used: 1.957 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.03512 seconds
Time After: 0.03613 seconds
Time Taken: 0.00101 seconds
Memory Before: 2,457.617 KB
Memory After: 2,459.039 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
('d434e83a91008bb995531d12a8f8e81f', 0, '18.119.160.42', '4fae545c6eddbc8db64212368c1b8f8d', 1730424429, '/newreply.php?do=newreply&explain=1&p=1064500', 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.03814 seconds
Time After: 0.03901 seconds
Time Taken: 0.00087 seconds
Memory Before: 2,520.484 KB
Memory After: 2,520.230 KB
Memory Used: -0.254 KB