Time Before: 0.00149 seconds
Time After: 0.00185 seconds
Time Taken: 0.00035 seconds
Memory Before: 504.352 KB
Memory After: 527.125 KB
Memory Used: 22.773 KB
Time Before: 0.00195 seconds
Time After: 0.00251 seconds
Time Taken: 0.00056 seconds
Memory Before: 527.063 KB
Memory After: 527.977 KB
Memory Used: 0.914 KB
SET @@sql_mode = ''
Time Before: 0.00282 seconds
Time After: 0.00293 seconds
Time Taken: 0.00011 seconds
Memory Before: 528.531 KB
Memory After: 529.055 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.00362 seconds
Time After: 0.00426 seconds
Time Taken: 0.00065 seconds
Memory Before: 531.977 KB
Memory After: 532.828 KB
Memory Used: 0.852 KB
Time Before: 0.00298 seconds
Time After: 0.00595 seconds
Time Taken: 0.00297 seconds
Memory Before: 528.305 KB
Memory After: 1,114.484 KB
Memory Used: 586.180 KB
SELECT * FROM session WHERE userid = 0 AND host = '18.117.72.224' AND idhash = '572d384874785ed2fbff2147f32c02e9' 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.00819 seconds
Time After: 0.00839 seconds
Time Taken: 0.00021 seconds
Memory Before: 1,611.508 KB
Memory After: 1,611.953 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.00926 seconds
Time After: 0.00960 seconds
Time Taken: 0.00034 seconds
Memory Before: 1,625.000 KB
Memory After: 1,624.961 KB
Memory Used: -0.039 KB
Time Before: 0.00761 seconds
Time After: 0.00975 seconds
Time Taken: 0.00214 seconds
Memory Before: 1,603.516 KB
Memory After: 1,677.383 KB
Memory Used: 73.867 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.01027 seconds
Time After: 0.01043 seconds
Time Taken: 0.00015 seconds
Memory Before: 1,678.750 KB
Memory After: 1,679.328 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.01316 seconds
Time After: 0.01349 seconds
Time Taken: 0.00033 seconds
Memory Before: 1,985.578 KB
Memory After: 1,986.172 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.01564 seconds
Time After: 0.01749 seconds
Time Taken: 0.00185 seconds
Memory Before: 2,512.188 KB
Memory After: 2,512.914 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.01850 seconds
Time After: 0.01913 seconds
Time Taken: 0.00063 seconds
Memory Before: 2,533.617 KB
Memory After: 2,538.945 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.02087 seconds
Time After: 0.02164 seconds
Time Taken: 0.00077 seconds
Memory Before: 2,820.570 KB
Memory After: 2,822.117 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.02571 seconds
Time After: 0.02595 seconds
Time Taken: 0.00025 seconds
Memory Before: 2,977.766 KB
Memory After: 2,981.227 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 <= 1714801136 AND enddate >= 1714801136 AND forumid IN (16,-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.03056 seconds
Time After: 0.03078 seconds
Time Taken: 0.00022 seconds
Memory Before: 3,116.023 KB
Memory After: 3,116.102 KB
Memory Used: 0.078 KB
SELECT COUNT(*) AS threads FROM thread AS thread WHERE thread.forumid = 16 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.03124 seconds
Time After: 0.03142 seconds
Time Taken: 0.00018 seconds
Memory Before: 3,120.883 KB
Memory After: 3,121.375 KB
Memory Used: 0.492 KB
SELECT COUNT(*) AS newthread FROM thread AS thread WHERE thread.forumid = 16 AND thread.lastpost > 1714801136 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.03178 seconds
Time After: 0.03197 seconds
Time Taken: 0.00019 seconds
Memory Before: 3,121.609 KB
Memory After: 3,122.055 KB
Memory Used: 0.445 KB
SELECT thread.threadid, lastpost, open FROM thread AS thread WHERE forumid = 16 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.03231 seconds
Time After: 0.03249 seconds
Time Taken: 0.00018 seconds
Memory Before: 3,121.641 KB
Memory After: 3,122.086 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 = 16 AND sticky = 0 AND visible = 1 ORDER BY sticky DESC, views DESC 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; Using filesort |
Time Before: 0.03287 seconds
Time After: 0.03310 seconds
Time Taken: 0.00023 seconds
Memory Before: 3,123.430 KB
Memory After: 3,123.734 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,16) ORDER BY thread.sticky DESC, views DESC
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.03370 seconds
Time After: 0.03416 seconds
Time Taken: 0.00046 seconds
Memory Before: 3,126.867 KB
Memory After: 3,126.516 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 ('d776f3bb2d47ba029080d5f497dc8126', 0, '18.117.72.224', '572d384874785ed2fbff2147f32c02e9', 1714801136, 'forumdisplay.php?f=16', 0, 0, 0, 16, 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.04012 seconds
Time After: 0.04032 seconds
Time Taken: 0.00020 seconds
Memory Before: 3,445.203 KB
Memory After: 3,445.102 KB
Memory Used: -0.102 KB