Time Before: 0.00301 seconds
Time After: 0.00423 seconds
Time Taken: 0.00122 seconds
Memory Before: 504.859 KB
Memory After: 527.633 KB
Memory Used: 22.773 KB
Time Before: 0.00434 seconds
Time After: 0.00508 seconds
Time Taken: 0.00074 seconds
Memory Before: 527.570 KB
Memory After: 528.484 KB
Memory Used: 0.914 KB
SET @@sql_mode = ''
Time Before: 0.00523 seconds
Time After: 0.00530 seconds
Time Taken: 0.00007 seconds
Memory Before: 529.039 KB
Memory After: 529.563 KB
Memory Used: 0.523 KB
SELECT * FROM datastore WHERE title IN ('iconcache','mailqueue','prefixcache','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | datastore | range | PRIMARY | PRIMARY | 50 | 17 | Using index condition |
Time Before: 0.00658 seconds
Time After: 0.00715 seconds
Time Taken: 0.00057 seconds
Memory Before: 532.484 KB
Memory After: 533.336 KB
Memory Used: 0.852 KB
Time Before: 0.00534 seconds
Time After: 0.00863 seconds
Time Taken: 0.00330 seconds
Memory Before: 528.813 KB
Memory After: 1,114.992 KB
Memory Used: 586.180 KB
SELECT * FROM session WHERE userid = 0 AND host = '18.219.102.189' AND idhash = '0254f74bf04713f8eb943ffe52b155e5' LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | session | ref | guest_lookup,user_activity | guest_lookup | 51 | const,const,const | 2 | Using where |
Time Before: 0.01081 seconds
Time After: 0.01101 seconds
Time Taken: 0.00021 seconds
Memory Before: 1,611.992 KB
Memory After: 1,612.438 KB
Memory Used: 0.445 KB
SELECT languageid, phrasegroup_global AS phrasegroup_global, phrasegroup_forumdisplay AS phrasegroup_forumdisplay, phrasegroup_inlinemod AS phrasegroup_inlinemod, 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 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.01219 seconds
Time After: 0.01268 seconds
Time Taken: 0.00049 seconds
Memory Before: 1,625.492 KB
Memory After: 1,625.453 KB
Memory Used: -0.039 KB
Time Before: 0.01025 seconds
Time After: 0.01281 seconds
Time Taken: 0.00256 seconds
Memory Before: 1,604.016 KB
Memory After: 1,677.875 KB
Memory Used: 73.859 KB
SELECT * FROM datastore WHERE title IN ('routes')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | datastore | const | PRIMARY | PRIMARY | 50 | const | 1 |
Time Before: 0.01336 seconds
Time After: 0.01352 seconds
Time Taken: 0.00017 seconds
Memory Before: 1,679.242 KB
Memory After: 1,679.820 KB
Memory Used: 0.578 KB
SELECT * FROM style WHERE (styleid = 2 AND userselect = 1) OR styleid = 2 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.01613 seconds
Time After: 0.01644 seconds
Time Taken: 0.00031 seconds
Memory Before: 1,986.078 KB
Memory After: 1,986.672 KB
Memory Used: 0.594 KB
SELECT moderator.*, user.username, IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid FROM moderator AS moderator INNER JOIN user AS user USING(userid)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | moderator | ALL | userid_forumid | 172 | ||||
1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | business_business.moderator.userid | 1 |
Time Before: 0.01841 seconds
Time After: 0.01962 seconds
Time Taken: 0.00122 seconds
Memory Before: 2,512.680 KB
Memory After: 2,513.406 KB
Memory Used: 0.727 KB
SELECT forum.forumid, forum.lastpost, forum.lastposter, forum.lastposterid, forum.lastthread, forum.lastthreadid, forum.lasticonid, forum.threadcount, forum.replycount, forum.lastpostid, forum.lastprefixid, user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend, user.lastactivity, user.lastvisit, IF(user.options & 512, 1, 0) AS invisible FROM forum AS forum LEFT JOIN user AS user ON (user.userid = forum.lastposterid) LEFT JOIN userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 0)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | forum | ALL | 36 | |||||
1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | business_business.forum.lastposterid | 1 | |
1 | SIMPLE | userlist | eq_ref | PRIMARY,relationid,userid | PRIMARY | 9 | const,business_business.user.userid,const | 1 | Using where |
Time Before: 0.02106 seconds
Time After: 0.02199 seconds
Time Taken: 0.00093 seconds
Memory Before: 2,534.102 KB
Memory After: 2,539.430 KB
Memory Used: 5.328 KB
SELECT title, template FROM template WHERE templateid IN (648,767,1155,1157,1156,778,779,775,777,774,776,770,1245,1195,1145,1254,1264,1205,1275,67,66,68,63,62,651,652,650,649,71,72,656,961,1257,907,911,908,909,910,1273,0,0,1236,1238,931,932,934,935,1158,1200,1199,1249,1201,758,757,761)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | template | range | PRIMARY | PRIMARY | 4 | 54 | Using index condition |
Time Before: 0.02368 seconds
Time After: 0.02472 seconds
Time Taken: 0.00104 seconds
Memory Before: 2,821.039 KB
Memory After: 2,822.586 KB
Memory Used: 1.547 KB
SELECT * FROM navigation WHERE state & 4 = 0 ORDER BY navtype, displayorder
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | navigation | ALL | 27 | Using where; Using filesort |
Time Before: 0.02844 seconds
Time After: 0.02888 seconds
Time Taken: 0.00044 seconds
Memory Before: 2,978.250 KB
Memory After: 2,981.711 KB
Memory Used: 3.461 KB
SELECT announcement.announcementid, startdate, title, announcement.views, user.username, user.userid, user.usertitle, user.customtitle, user.usergroupid, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid FROM announcement AS announcement LEFT JOIN user AS user ON(user.userid = announcement.userid) WHERE startdate <= 1716279241 AND enddate >= 1716279241 AND forumid IN (14,-1) ORDER BY startdate DESC, announcement.announcementid DESC LIMIT 1
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.03303 seconds
Time After: 0.03335 seconds
Time Taken: 0.00032 seconds
Memory Before: 3,116.500 KB
Memory After: 3,116.578 KB
Memory Used: 0.078 KB
SELECT COUNT(*) AS threads FROM thread AS thread WHERE thread.forumid = 14 AND sticky = 0 AND visible = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | thread | ref | forumid,forumid_lastpost | forumid | 6 | const,const,const | 1 | Using index |
Time Before: 0.03402 seconds
Time After: 0.03433 seconds
Time Taken: 0.00031 seconds
Memory Before: 3,121.367 KB
Memory After: 3,121.859 KB
Memory Used: 0.492 KB
SELECT COUNT(*) AS newthread FROM thread AS thread WHERE thread.forumid = 14 AND thread.lastpost > 1716279241 AND open <> 10 AND sticky = 0 AND visible = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | thread | range | forumid,forumid_lastpost,lastpost | forumid_lastpost | 6 | 1 | Using index condition; Using where |
Time Before: 0.03479 seconds
Time After: 0.03509 seconds
Time Taken: 0.00030 seconds
Memory Before: 3,122.094 KB
Memory After: 3,122.539 KB
Memory Used: 0.445 KB
SELECT thread.threadid, lastpost, open FROM thread AS thread WHERE forumid = 14 AND sticky = 1 AND visible = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | thread | ref | forumid,forumid_lastpost | forumid_lastpost | 2 | const | 1 | Using where |
Time Before: 0.03548 seconds
Time After: 0.03579 seconds
Time Taken: 0.00031 seconds
Memory Before: 3,122.125 KB
Memory After: 3,122.570 KB
Memory Used: 0.445 KB
SELECT thread.threadid, thread.lastpost, thread.lastposter, thread.lastposterid, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views FROM thread AS thread WHERE forumid = 14 AND sticky = 0 AND visible = 1 ORDER BY sticky DESC, lastpost LIMIT 0, 20
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | thread | ref | forumid,forumid_lastpost | forumid_lastpost | 2 | const | 1 | Using where |
Time Before: 0.03621 seconds
Time After: 0.03657 seconds
Time Taken: 0.00036 seconds
Memory Before: 3,123.898 KB
Memory After: 3,124.203 KB
Memory Used: 0.305 KB
SELECT IF(votenum >= 1, votenum, 0) AS votenum, IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg, post.pagetext AS preview, thread.threadid, thread.title AS threadtitle, thread.forumid, thread.pollid, thread.open, thread.postusername, thread.postuserid, thread.iconid AS threadiconid, thread.dateline, thread.notes, thread.visible, thread.sticky, thread.votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastposterid, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views, thread.prefixid, thread.taglist, thread.hiddencount, thread.deletedcount, user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend, user.lastactivity, user.lastvisit, IF(user.options & 512, 1, 0) AS invisible FROM thread AS thread LEFT JOIN user AS user ON (user.userid = thread.lastposterid) LEFT JOIN userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 0) LEFT JOIN post AS post ON(post.postid = thread.firstpostid) WHERE thread.threadid IN (0,2699) ORDER BY thread.sticky DESC, lastpost
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | 2 | Using index condition; Using filesort | |
1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | business_business.thread.lastposterid | 1 | |
1 | SIMPLE | userlist | eq_ref | PRIMARY,relationid,userid | PRIMARY | 9 | const,business_business.user.userid,const | 1 | Using where |
1 | SIMPLE | post | eq_ref | PRIMARY | PRIMARY | 4 | business_business.thread.firstpostid | 1 |
Time Before: 0.03752 seconds
Time After: 0.03838 seconds
Time Taken: 0.00086 seconds
Memory Before: 3,127.352 KB
Memory After: 3,127.000 KB
Memory Used: -0.352 KB
INSERT IGNORE INTO session (sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate, apiclientid, apiaccesstoken) VALUES ('d3524f582859ceefb04a16df90410abe', 0, '18.219.102.189', '0254f74bf04713f8eb943ffe52b155e5', 1716279241, 'forumdisplay.php?f=14', 0, 0, 0, 14, 0, 0, 0, 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 0, 0, 0, '')
Time Before: 0.04380 seconds
Time After: 0.04408 seconds
Time Taken: 0.00028 seconds
Memory Before: 3,445.539 KB
Memory After: 3,445.438 KB
Memory Used: -0.102 KB