Time Before: 0.00020 seconds
Time After: 0.00024 seconds
Time Taken: 0.00004 seconds
Memory Before: 463.180 KB
Memory After: 465.414 KB
Memory Used: 2.234 KB
Time Before: 0.00026 seconds
Time After: 0.00083 seconds
Time Taken: 0.00057 seconds
Memory Before: 465.391 KB
Memory After: 465.969 KB
Memory Used: 0.578 KB
SET @@sql_mode = ''
Time Before: 0.00088 seconds
Time After: 0.00095 seconds
Time Taken: 0.00007 seconds
Memory Before: 465.992 KB
Memory After: 466.047 KB
Memory Used: 0.055 KB
SELECT * FROM datastore WHERE title IN ('userstats','birthdaycache','maxloggedin','iconcache','eventcache','mailqueue','activeblocks','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | datastore | range | PRIMARY | PRIMARY | 50 | 20 | Using index condition |
Time Before: 0.00116 seconds
Time After: 0.00159 seconds
Time Taken: 0.00042 seconds
Memory Before: 468.406 KB
Memory After: 1,025.648 KB
Memory Used: 557.242 KB
Time Before: 0.00097 seconds
Time After: 0.00233 seconds
Time Taken: 0.00137 seconds
Memory Before: 465.813 KB
Memory After: 1,281.570 KB
Memory Used: 815.758 KB
SELECT * FROM datastore WHERE title IN ('dbtech_ajaxthreads_usergroup')
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.00264 seconds
Time After: 0.00268 seconds
Time Taken: 0.00003 seconds
Memory Before: 1,438.563 KB
Memory After: 1,454.633 KB
Memory Used: 16.070 KB
SELECT * FROM session WHERE userid = 0 AND host = '3.144.248.8' AND idhash = 'b5b4c275801ed44d113cc5f40ef4ab5a' LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | session | ref | user_activity,guest_lookup | guest_lookup | 51 | const,const,const | 2 | Using where |
Time Before: 0.00288 seconds
Time After: 0.00301 seconds
Time Taken: 0.00013 seconds
Memory Before: 1,443.070 KB
Memory After: 1,459.766 KB
Memory Used: 16.695 KB
SELECT languageid, phrasegroup_global AS phrasegroup_global, phrasegroup_holiday AS phrasegroup_holiday, 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 | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | language | const | PRIMARY | PRIMARY | 2 | const | 1 |
Time Before: 0.00337 seconds
Time After: 0.00373 seconds
Time Taken: 0.00036 seconds
Memory Before: 1,448.914 KB
Memory After: 1,625.469 KB
Memory Used: 176.555 KB
Time Before: 0.00270 seconds
Time After: 0.00375 seconds
Time Taken: 0.00105 seconds
Memory Before: 1,439.906 KB
Memory After: 1,531.203 KB
Memory Used: 91.297 KB
SELECT userip FROM vsavilxh_guests AS vsavilxh_guests WHERE userip = '3.144.248.8'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | vsavilxh_guests | ALL | 1166 | Using where |
Time Before: 0.00453 seconds
Time After: 0.00485 seconds
Time Taken: 0.00032 seconds
Memory Before: 1,682.188 KB
Memory After: 1,698.430 KB
Memory Used: 16.242 KB
UPDATE vsavilxh_guests SET dateline = '1713483552' WHERE userip = '3.144.248.8'
Time Before: 0.00486 seconds
Time After: 0.00550 seconds
Time Taken: 0.00064 seconds
Memory Before: 1,698.578 KB
Memory After: 1,698.563 KB
Memory Used: -0.016 KB
DELETE FROM vsavilxh_guests WHERE dateline < '1713397152'
Time Before: 0.00551 seconds
Time After: 0.00605 seconds
Time Taken: 0.00055 seconds
Memory Before: 1,681.875 KB
Memory After: 1,681.859 KB
Memory Used: -0.016 KB
SELECT * FROM style WHERE (styleid = 12 AND userselect = 1) OR styleid = 12 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.00624 seconds
Time After: 0.00629 seconds
Time Taken: 0.00005 seconds
Memory Before: 1,672.273 KB
Memory After: 1,880.922 KB
Memory Used: 208.648 KB
SELECT title, template FROM template WHERE templateid IN (70,71,1079,1080,1082,1083,1084,1085,1081,2214,1152,1158,2216,2217,2218,2219,2220,1500,2233,2231,2234,2235,0,0,79,73,72,2344,2347,2101,75,80,81,82,1337,1634,2221,2222,1286,1287,1650,0,0,1613,1615,1307,1308,1310,1311,1534,1577,1576,1626,1578,1137,1136,1140,2249,1931,1932,2246,1956,1952,1943,1958,1942,1950,1945,1953,1963,1949,1955,1966,1964,1965,1957,1961,1960,1946,1962,1947,1948,1954,1944,1959,2331,2335,2336,2334,2333,2332,2337,2084,1129,1132,1130,1295,1131,2226)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | template | range | PRIMARY | PRIMARY | 4 | 96 | Using index condition |
Time Before: 0.00756 seconds
Time After: 0.00859 seconds
Time Taken: 0.00103 seconds
Memory Before: 2,231.375 KB
Memory After: 2,515.680 KB
Memory Used: 284.305 KB
SELECT * FROM molding ORDER BY molding.order ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | molding | ALL | 11 | Using filesort |
Time Before: 0.00909 seconds
Time After: 0.00912 seconds
Time Taken: 0.00004 seconds
Memory Before: 2,489.063 KB
Memory After: 2,506.805 KB
Memory Used: 17.742 KB
SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.postusername, thread.postuserid, thread.lastposter, thread.lastposterid, thread.dateline, thread.views, thread.visible, thread.open, user.usergroupid, user.displaygroupid FROM thread AS thread LEFT JOIN user AS user ON (user.userid = thread.lastposterid) WHERE NOT ISNULL(thread.threadid) AND thread.visible = '1' AND thread.open!='10' AND thread.forumid NOT IN(14,114,154,155,156,77,103,104,105,107) ORDER BY lastpost DESC LIMIT 0, 15
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | thread | index | PRIMARY,forumid,forumid_lastpost | lastpost | 4 | 15 | Using where | |
1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | mihangam_mforum.thread.lastposterid | 1 |
Time Before: 0.01030 seconds
Time After: 0.01076 seconds
Time Taken: 0.00046 seconds
Memory Before: 2,526.961 KB
Memory After: 2,546.766 KB
Memory Used: 19.805 KB
SELECT userid, usergroupid, displaygroupid, username, posts FROM user AS user WHERE posts > '0' ORDER BY posts DESC LIMIT 0, 15
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | user | ALL | 19470 | Using where; Using filesort |
Time Before: 0.01269 seconds
Time After: 0.02383 seconds
Time Taken: 0.01115 seconds
Memory Before: 2,554.555 KB
Memory After: 2,572.172 KB
Memory Used: 17.617 KB
SELECT userid,options,usergroupid,displaygroupid,joindate,username FROM user WHERE joindate > 1713472200 ORDER BY username
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | user | range | joindate | joindate | 4 | 14 | Using index condition; Using filesort |
Time Before: 0.02482 seconds
Time After: 0.02491 seconds
Time Taken: 0.00009 seconds
Memory Before: 2,563.563 KB
Memory After: 2,579.711 KB
Memory Used: 16.148 KB
SELECT user.username, (user.options & 512) AS invisible, user.usergroupid, user.lastvisit, session.userid, session.inforum, session.lastactivity, session.badlocation, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid FROM session AS session LEFT JOIN user AS user ON(user.userid = session.userid) WHERE session.lastactivity > 1713482652 ORDER BY username ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | session | range | last_activity | last_activity | 4 | 160 | Using where; Using temporary; Using filesort | |
1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | mihangam_mforum.session.userid | 1 |
Time Before: 0.02549 seconds
Time After: 0.02637 seconds
Time Taken: 0.00087 seconds
Memory Before: 2,570.961 KB
Memory After: 2,650.641 KB
Memory Used: 79.680 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 | 131 | |||||
1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | mihangam_mforum.forum.lastposterid | 1 | |
1 | SIMPLE | userlist | eq_ref | PRIMARY,relationid,userid | PRIMARY | 9 | const,mihangam_mforum.user.userid,const | 1 | Using where |
Time Before: 0.02691 seconds
Time After: 0.02696 seconds
Time Taken: 0.00005 seconds
Memory Before: 2,580.203 KB
Memory After: 2,654.883 KB
Memory Used: 74.680 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 | 3 | ||||
1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | mihangam_mforum.moderator.userid | 1 |
Time Before: 0.02750 seconds
Time After: 0.02752 seconds
Time Taken: 0.00003 seconds
Memory Before: 2,814.602 KB
Memory After: 2,830.953 KB
Memory Used: 16.352 KB