Time Before: 0.00394 seconds
Time After: 0.01047 seconds
Time Taken: 0.00653 seconds
Memory Before: 412.625 KB
Memory After: 421.195 KB
Memory Used: 8.570 KB
Time Before: 0.01052 seconds
Time After: 0.01074 seconds
Time Taken: 0.00023 seconds
Memory Before: 421.180 KB
Memory After: 422.141 KB
Memory Used: 0.961 KB
SET @@sql_mode = ''
Time Before: 0.01082 seconds
Time After: 0.01087 seconds
Time Taken: 0.00005 seconds
Memory Before: 422.805 KB
Memory After: 423.375 KB
Memory Used: 0.570 KB
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','tagcloud','iconcache')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | datastore | range | PRIMARY | PRIMARY | 50 | 16 | Using where |
Time Before: 0.01115 seconds
Time After: 0.01199 seconds
Time Taken: 0.00084 seconds
Memory Before: 426.188 KB
Memory After: 427.648 KB
Memory Used: 1.461 KB
Time Before: 0.01089 seconds
Time After: 0.01810 seconds
Time Taken: 0.00721 seconds
Memory Before: 422.617 KB
Memory After: 5,383.516 KB
Memory Used: 4,960.898 KB
SELECT * FROM session WHERE userid = 0 AND host = '18.225.11.98' AND idhash = 'cb58b1490eec13dfd1ae0e15574b7889' LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | session | ALL | 3534 | Using where |
Time Before: 0.01874 seconds
Time After: 0.01964 seconds
Time Taken: 0.00091 seconds
Memory Before: 5,399.727 KB
Memory After: 5,401.047 KB
Memory Used: 1.320 KB
SELECT languageid, phrasegroup_global AS phrasegroup_global, phrasegroup_inlinemod AS phrasegroup_inlinemod, phrasegroup_search AS phrasegroup_search, 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.01994 seconds
Time After: 0.02001 seconds
Time Taken: 0.00007 seconds
Memory Before: 5,410.898 KB
Memory After: 5,411.672 KB
Memory Used: 0.773 KB
Time Before: 0.01853 seconds
Time After: 0.02007 seconds
Time Taken: 0.00154 seconds
Memory Before: 5,394.492 KB
Memory After: 5,495.453 KB
Memory Used: 100.961 KB
SELECT * FROM style WHERE (styleid = 13 AND userselect = 1) OR styleid = 13 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.02099 seconds
Time After: 0.02103 seconds
Time Taken: 0.00004 seconds
Memory Before: 5,686.273 KB
Memory After: 5,687.563 KB
Memory Used: 1.289 KB
SELECT title, template FROM template WHERE templateid IN (480,499,918,977,1011,991,67,66,68,63,62,339,648,291,292,293,559,562,571,312,313,314,315,513,576,575,577,580,1012,1013,649,920,921,922,923,924)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | template | range | PRIMARY | PRIMARY | 4 | 36 | Using where |
Time Before: 0.02150 seconds
Time After: 0.02188 seconds
Time Taken: 0.00038 seconds
Memory Before: 5,866.391 KB
Memory After: 5,868.250 KB
Memory Used: 1.859 KB
SELECT id, type, title, url, banner, duration, height, width, active, clicks, bannord FROM cybbanners AS cybbanners WHERE active = 1 ORDER BY RAND() LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | cybbanners | ALL | 13 | Using where; Using temporary; Using filesort |
Time Before: 0.02268 seconds
Time After: 0.02278 seconds
Time Taken: 0.00010 seconds
Memory Before: 6,045.570 KB
Memory After: 6,046.680 KB
Memory Used: 1.109 KB
SELECT * FROM tag WHERE tagtext = 'soup'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | tag | const | tagtext | tagtext | 102 | const | 1 |
Time Before: 0.02601 seconds
Time After: 0.02608 seconds
Time Taken: 0.00007 seconds
Memory Before: 6,016.984 KB
Memory After: 6,018.188 KB
Memory Used: 1.203 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 | 118 | ||||
1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | gentlemo_community.moderator.userid | 1 |
Time Before: 0.02772 seconds
Time After: 0.02777 seconds
Time Taken: 0.00005 seconds
Memory Before: 6,081.766 KB
Memory After: 6,091.508 KB
Memory Used: 9.742 KB
SELECT thread.threadid, thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views FROM thread AS thread INNER JOIN tagthread AS tagthread ON (tagthread.tagid = 145 AND tagthread.threadid = thread.threadid) WHERE thread.forumid IN(396, 440, 387, 402, 388, 416, 418, 419, 417, 389, 420, 526, 421, 422, 601, 390, 429, 431, 515, 430, 538, 539, 540, 541, 542, 543, 544, 545, 547, 548, 549, 551, 550, 432, 433, 391, 437, 529, 438, 603, 493) AND thread.visible = 1 AND thread.sticky IN (0, 1) AND thread.open <> 10 ORDER BY lastpost DESC LIMIT 500
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | tagthread | ref | PRIMARY,threadid | PRIMARY | 4 | const | 1 | Using index; Using temporary; Using filesort |
1 | SIMPLE | thread | eq_ref | PRIMARY,forumid | PRIMARY | 4 | gentlemo_community.tagthread.threadid | 1 | Using where |
Time Before: 0.02850 seconds
Time After: 0.02871 seconds
Time Taken: 0.00021 seconds
Memory Before: 6,400.516 KB
Memory After: 6,401.156 KB
Memory Used: 0.641 KB
INSERT INTO tagsearch (tagid, dateline) VALUES (145, 1714297875)
Time Before: 0.02875 seconds
Time After: 0.02917 seconds
Time Taken: 0.00042 seconds
Memory Before: 6,399.469 KB
Memory After: 6,399.813 KB
Memory Used: 0.344 KB
SELECT thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, postusername, postuserid, thread.iconid AS threadiconid, thread.dateline, notes, thread.visible, sticky, votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views, thread.prefixid, thread.taglist, hiddencount, deletedcount , post.pagetext AS preview FROM thread AS thread LEFT JOIN post AS post ON(post.postid = thread.firstpostid) WHERE thread.threadid IN (526604)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | post | const | PRIMARY | PRIMARY | 4 | const | 1 |
Time Before: 0.02942 seconds
Time After: 0.02956 seconds
Time Taken: 0.00014 seconds
Memory Before: 6,401.844 KB
Memory After: 6,402.828 KB
Memory Used: 0.984 KB
UPDATE session SET lastactivity = 1714297875, location = '/community/tags.php?tag=soup&explain=1', inforum = 0, inthread = 0, incalendar = 0, badlocation = 0, useragent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' WHERE sessionhash = '76a92c810541ce0145520694f1b62465'
Time Before: 0.03211 seconds
Time After: 0.03242 seconds
Time Taken: 0.00031 seconds
Memory Before: 6,750.578 KB
Memory After: 6,750.633 KB
Memory Used: 0.055 KB