Time Before: 0.00048 seconds
Time After: 0.00050 seconds
Time Taken: 0.00002 seconds
Memory Before: 433.711 KB
Memory After: 435.547 KB
Memory Used: 1.836 KB
Time Before: 0.00054 seconds
Time After: 0.01179 seconds
Time Taken: 0.01125 seconds
Memory Before: 435.531 KB
Memory After: 436.266 KB
Memory Used: 0.734 KB
SET @@sql_mode = ''
Time Before: 0.01217 seconds
Time After: 0.01248 seconds
Time Taken: 0.00031 seconds
Memory Before: 436.313 KB
Memory After: 436.367 KB
Memory Used: 0.055 KB
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','smiliecache','bbcodecache','mailqueue','bookmarksitecache')| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | datastore | range | PRIMARY | PRIMARY | 52 | 18 | Using where |
Time Before: 0.01325 seconds
Time After: 0.01551 seconds
Time Taken: 0.00225 seconds
Memory Before: 437.703 KB
Memory After: 1,174.008 KB
Memory Used: 736.305 KB
Time Before: 0.01252 seconds
Time After: 0.03918 seconds
Time Taken: 0.02666 seconds
Memory Before: 436.156 KB
Memory After: 1,805.445 KB
Memory Used: 1,369.289 KB
SELECT *
FROM datastore
WHERE title IN ('modstats_coder','modstats_designer','modstats_motm','modtitle_coder','modtitle_designer','wol_spiders','nex_crawlers_list_wgo_stats')| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | datastore | range | PRIMARY | PRIMARY | 52 | 7 | Using where |
Time Before: 0.03984 seconds
Time After: 0.04079 seconds
Time Taken: 0.00096 seconds
Memory Before: 1,807.148 KB
Memory After: 2,063.359 KB
Memory Used: 256.211 KB
SELECT * FROM session WHERE userid = 0 AND host = '216.73.217.115' AND idhash = '746d2c2e12532723401903d41921bd01' LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | session | ALL | 359 | Using where |
Time Before: 0.04148 seconds
Time After: 0.04186 seconds
Time Taken: 0.00038 seconds
Memory Before: 1,992.328 KB
Memory After: 2,008.523 KB
Memory Used: 16.195 KB
SELECT languageid, phrasegroup_global AS phrasegroup_global, phrasegroup_posting AS phrasegroup_posting, phrasegroup_postbit AS phrasegroup_postbit, phrasegroup_showthread AS phrasegroup_showthread, phrasegroup_inlinemod AS phrasegroup_inlinemod, phrasegroup_reputationlevel AS phrasegroup_reputationlevel, 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 | const | PRIMARY | PRIMARY | 2 | const | 1 |
Time Before: 0.04252 seconds
Time After: 0.04307 seconds
Time Taken: 0.00055 seconds
Memory Before: 1,998.242 KB
Memory After: 2,190.930 KB
Memory Used: 192.688 KB
Time Before: 0.04101 seconds
Time After: 0.04314 seconds
Time Taken: 0.00213 seconds
Memory Before: 1,990.086 KB
Memory After: 2,092.625 KB
Memory Used: 102.539 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 = 280255
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | editlog | const | PRIMARY | PRIMARY | 4 | const | 1 | Unique row not found |
Time Before: 0.04651 seconds
Time After: 0.04669 seconds
Time Taken: 0.00018 seconds
Memory Before: 2,250.563 KB
Memory After: 2,266.578 KB
Memory Used: 16.016 KB
SELECT IF(visible = 2, 1, 0) AS isdeleted, thread.* FROM thread AS thread WHERE thread.threadid = 170326
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | thread | const | PRIMARY | PRIMARY | 4 | const | 1 |
Time Before: 0.04696 seconds
Time After: 0.04713 seconds
Time Taken: 0.00016 seconds
Memory Before: 2,253.875 KB
Memory After: 2,270.164 KB
Memory Used: 16.289 KB
SELECT * FROM style WHERE (styleid = 78 AND userselect = 1) OR styleid = 78 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.04753 seconds
Time After: 0.04773 seconds
Time Taken: 0.00021 seconds
Memory Before: 2,260.813 KB
Memory After: 2,413.180 KB
Memory Used: 152.367 KB
SELECT title, template FROM template WHERE templateid IN (10,11,13,12,225,246,267,268,270,277,276,880,570,555,556,558,557,560,562,563,564,566,569,106,108,110,112,882,609,612,613,610,608,707,708,539,537,538,543,541,727,198,196,199,200,57,59,871,868,872,8,7,9,4,3,529,877,407,408,409,245,248,445,446,447,448,449,742,664,663,665,668,878,429,434,433,431,432,550,544,545,546,547,551,553,439,194,867,244,115,178,179,174,151,410,197,397,398,400,874,396,196,198,199,200,216,309,321,322,324,323,875,401,402,744,751,753,754,752,755,566,605,606,603,403)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | template | range | PRIMARY | PRIMARY | 4 | 120 | Using where |
Time Before: 0.04920 seconds
Time After: 0.05009 seconds
Time Taken: 0.00088 seconds
Memory Before: 2,447.773 KB
Memory After: 2,865.578 KB
Memory Used: 417.805 KB
SELECT COUNT(*) AS posts FROM post AS post WHERE threadid = 170326 AND visible = 1 AND dateline <= 1219980547
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | post | range | threadid,dateline,idx_dateline,idx_ksours | idx_ksours | 10 | 66 | Using where; Using index |
Time Before: 0.05248 seconds
Time After: 0.05269 seconds
Time Taken: 0.00021 seconds
Memory Before: 2,847.422 KB
Memory After: 2,863.586 KB
Memory Used: 16.164 KB
SELECT post.postid, post.visible, post.userid FROM post AS post WHERE post.threadid = 170326 AND post.visible IN (1 ) ORDER BY post.dateline ASC LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | post | ref | threadid,idx_ksours | idx_ksours | 6 | const,const | 121 | Using where; Using index |
Time Before: 0.05305 seconds
Time After: 0.05327 seconds
Time Taken: 0.00022 seconds
Memory Before: 2,852.039 KB
Memory After: 2,868.141 KB
Memory Used: 16.102 KB
SELECT post.postid, post.attach FROM post AS post WHERE post.threadid = 170326 AND post.visible = 1 ORDER BY post.dateline LIMIT 50, 50
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | post | ref | threadid,idx_ksours | idx_ksours | 6 | const,const | 121 | Using where; Using index |
Time Before: 0.05371 seconds
Time After: 0.05392 seconds
Time Taken: 0.00021 seconds
Memory Before: 2,849.133 KB
Memory After: 2,866.094 KB
Memory Used: 16.961 KB
SELECT dateline, thumbnail_dateline, filename, filesize, visible, attachmentid, counter, postid, IF(thumbnail_filesize > 0, 1, 0) AS hasthumbnail, thumbnail_filesize, attachmenttype.thumbnail AS build_thumbnail, attachmenttype.newwindow FROM attachment LEFT JOIN attachmenttype AS attachmenttype USING (extension) WHERE postid IN (0,275758,275802,275803,275822,275929,275930,275954,275971,275988,276105,278003,278759,278775,278827,279044,280255,280900,280918,280930,280978,280985,280992,280999,281002,281004,281021,281022,281591,282492,282493,282497,282580,284720,285601,285604,286872,286873,286876,286883,286890,286905,287092,287094,287717,287719,287720,287731,289081,289089,289209) ORDER BY attachmentid
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | attachment | range | postid | postid | 4 | 51 | Using index condition; Using filesort | |
| 1 | SIMPLE | attachmenttype | eq_ref | PRIMARY | PRIMARY | 22 | wckediden_vb3.attachment.extension | 1 |
Time Before: 0.05429 seconds
Time After: 0.05472 seconds
Time Taken: 0.00042 seconds
Memory Before: 2,853.570 KB
Memory After: 2,869.000 KB
Memory Used: 15.430 KB
SELECT post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted, user.*, userfield.*, usertextfield.*, icon.title as icontitle, icon.iconpath, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight, editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline, editlog.reason AS edit_reason, editlog.hashistory, postparsed.pagetext_html, postparsed.hasimages, sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages, sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight, IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid , '' AS field20, '' AS field27 ,modification.last_update,modification.author,modification.mod_productid,modification.mod_supported,modification.mod_dbchanges,modification.mod_usesplugins,modification.mod_edtemplates,modification.mod_autemplates,modification.mod_reuseable,modification.mod_codechange,modification.mod_additional,modification.mod_translation,modification.mod_licence,modification.mod_verified,modification.mod_external,modification.mod_betastage,modification.mod_version,modification.mod_coauthors,modification.mod_installcount,modification.mod_vbversion,modification.motm,licence.title AS licence_used,licence.licence FROM post AS post LEFT JOIN user AS user ON(user.userid = post.userid) LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid) LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid) LEFT JOIN icon AS icon ON(icon.iconid = post.iconid) LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid) LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 78 AND postparsed.languageid = 1) LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 78 AND sigparsed.languageid = 1) LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid) LEFT JOIN modsys_settings AS modification ON(modification.threadid = 170326) LEFT JOIN modsys_licences AS licence ON(licence.modsys_licencesid = modification.mod_licence) WHERE post.postid IN (0,275758,275802,275803,275822,275929,275930,275954,275971,275988,276105,278003,278759,278775,278827,279044,280255,280900,280918,280930,280978,280985,280992,280999,281002,281004,281021,281022,281591,282492,282493,282497,282580,284720,285601,285604,286872,286873,286876,286883,286890,286905,287092,287094,287717,287719,287720,287731,289081,289089,289209) ORDER BY post.dateline
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | post | range | PRIMARY | PRIMARY | 4 | 51 | Using where; Using filesort | |
| 1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | wckediden_vb3.post.userid | 1 | |
| 1 | SIMPLE | userfield | eq_ref | PRIMARY | PRIMARY | 4 | wckediden_vb3.user.userid | 1 | Using where |
| 1 | SIMPLE | usertextfield | eq_ref | PRIMARY | PRIMARY | 4 | wckediden_vb3.user.userid | 1 | Using where |
| 1 | SIMPLE | icon | eq_ref | PRIMARY | PRIMARY | 2 | wckediden_vb3.post.iconid | 1 | |
| 1 | SIMPLE | avatar | eq_ref | PRIMARY | PRIMARY | 2 | wckediden_vb3.user.avatarid | 1 | Using where |
| 1 | SIMPLE | customavatar | eq_ref | PRIMARY | PRIMARY | 4 | wckediden_vb3.user.userid | 1 | Using where |
| 1 | SIMPLE | editlog | eq_ref | PRIMARY | PRIMARY | 4 | wckediden_vb3.post.postid | 1 | |
| 1 | SIMPLE | postparsed | eq_ref | PRIMARY | PRIMARY | 8 | wckediden_vb3.post.postid,const,const | 1 | |
| 1 | SIMPLE | sigparsed | eq_ref | PRIMARY | PRIMARY | 8 | wckediden_vb3.user.userid,const,const | 1 | Using where |
| 1 | SIMPLE | sigpic | eq_ref | PRIMARY | PRIMARY | 4 | wckediden_vb3.post.userid | 1 | |
| 1 | SIMPLE | modification | const | uniq_threadid | uniq_threadid | 4 | const | 1 | |
| 1 | SIMPLE | licence | eq_ref | PRIMARY | PRIMARY | 4 | wckediden_vb3.modification.mod_licence | 1 | Using where |
Time Before: 0.05531 seconds
Time After: 0.05718 seconds
Time Taken: 0.00187 seconds
Memory Before: 2,879.344 KB
Memory After: 3,055.914 KB
Memory Used: 176.570 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=25741 AND threadid=170326
| 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.05793 seconds
Time After: 0.05807 seconds
Time Taken: 0.00014 seconds
Memory Before: 3,131.023 KB
Memory After: 3,147.117 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=13627 AND threadid=170326
| 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.06018 seconds
Time After: 0.06039 seconds
Time Taken: 0.00021 seconds
Memory Before: 3,188.906 KB
Memory After: 3,205.000 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=13627 AND threadid=170326
| 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.06215 seconds
Time After: 0.06229 seconds
Time Taken: 0.00014 seconds
Memory Before: 3,197.500 KB
Memory After: 3,213.594 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=13627 AND threadid=170326
| 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.06396 seconds
Time After: 0.06409 seconds
Time Taken: 0.00012 seconds
Memory Before: 3,209.500 KB
Memory After: 3,225.594 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=170326
| 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.06561 seconds
Time After: 0.06578 seconds
Time Taken: 0.00017 seconds
Memory Before: 3,219.688 KB
Memory After: 3,235.797 KB
Memory Used: 16.109 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=170326
| 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.06741 seconds
Time After: 0.06753 seconds
Time Taken: 0.00012 seconds
Memory Before: 3,228.719 KB
Memory After: 3,244.828 KB
Memory Used: 16.109 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=13627 AND threadid=170326
| 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.06916 seconds
Time After: 0.06928 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,235.969 KB
Memory After: 3,252.063 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=170326
| 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.07086 seconds
Time After: 0.07100 seconds
Time Taken: 0.00014 seconds
Memory Before: 3,246.031 KB
Memory After: 3,262.141 KB
Memory Used: 16.109 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=13627 AND threadid=170326
| 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.07262 seconds
Time After: 0.07275 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,256.563 KB
Memory After: 3,272.656 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=170326
| 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.07438 seconds
Time After: 0.07451 seconds
Time Taken: 0.00014 seconds
Memory Before: 3,266.656 KB
Memory After: 3,282.766 KB
Memory Used: 16.109 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=12373 AND threadid=170326
| 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.07615 seconds
Time After: 0.07628 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,272.711 KB
Memory After: 3,288.805 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=19114 AND threadid=170326
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | modsys_user_notification | const | uniq_thread_user,idx_user_thread | uniq_thread_user | 8 | const,const | 1 |
Time Before: 0.07783 seconds
Time After: 0.07797 seconds
Time Taken: 0.00014 seconds
Memory Before: 3,281.289 KB
Memory After: 3,297.523 KB
Memory Used: 16.234 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=170326
| 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.07952 seconds
Time After: 0.07966 seconds
Time Taken: 0.00015 seconds
Memory Before: 3,291.125 KB
Memory After: 3,307.234 KB
Memory Used: 16.109 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=16716 AND threadid=170326
| 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.08131 seconds
Time After: 0.08147 seconds
Time Taken: 0.00016 seconds
Memory Before: 3,298.219 KB
Memory After: 3,314.313 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=19114 AND threadid=170326
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | modsys_user_notification | const | uniq_thread_user,idx_user_thread | uniq_thread_user | 8 | const,const | 1 |
Time Before: 0.08312 seconds
Time After: 0.08325 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,310.711 KB
Memory After: 3,326.945 KB
Memory Used: 16.234 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=19114 AND threadid=170326
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | modsys_user_notification | const | uniq_thread_user,idx_user_thread | uniq_thread_user | 8 | const,const | 1 |
Time Before: 0.08489 seconds
Time After: 0.08507 seconds
Time Taken: 0.00017 seconds
Memory Before: 3,318.922 KB
Memory After: 3,335.156 KB
Memory Used: 16.234 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=30011 AND threadid=170326
| 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.08675 seconds
Time After: 0.08688 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,327.953 KB
Memory After: 3,344.047 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=16716 AND threadid=170326
| 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.08871 seconds
Time After: 0.08886 seconds
Time Taken: 0.00015 seconds
Memory Before: 3,337.203 KB
Memory After: 3,353.297 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=30011 AND threadid=170326
| 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.09054 seconds
Time After: 0.09069 seconds
Time Taken: 0.00014 seconds
Memory Before: 3,350.055 KB
Memory After: 3,366.148 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=30011 AND threadid=170326
| 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.09234 seconds
Time After: 0.09256 seconds
Time Taken: 0.00023 seconds
Memory Before: 3,357.844 KB
Memory After: 3,373.938 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=170326
| 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.09440 seconds
Time After: 0.09452 seconds
Time Taken: 0.00012 seconds
Memory Before: 3,367.406 KB
Memory After: 3,383.516 KB
Memory Used: 16.109 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=30011 AND threadid=170326
| 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.09621 seconds
Time After: 0.09632 seconds
Time Taken: 0.00011 seconds
Memory Before: 3,377.750 KB
Memory After: 3,393.844 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=20415 AND threadid=170326
| 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.09800 seconds
Time After: 0.09811 seconds
Time Taken: 0.00011 seconds
Memory Before: 3,385.773 KB
Memory After: 3,401.867 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=170326
| 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.09971 seconds
Time After: 0.09984 seconds
Time Taken: 0.00012 seconds
Memory Before: 3,395.969 KB
Memory After: 3,412.078 KB
Memory Used: 16.109 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=20434 AND threadid=170326
| 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.10154 seconds
Time After: 0.10167 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,402.633 KB
Memory After: 3,418.727 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=30011 AND threadid=170326
| 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.10337 seconds
Time After: 0.10357 seconds
Time Taken: 0.00020 seconds
Memory Before: 3,416.023 KB
Memory After: 3,432.117 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=170326
| 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.10531 seconds
Time After: 0.10543 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,425.563 KB
Memory After: 3,441.672 KB
Memory Used: 16.109 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=22711 AND threadid=170326
| 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.10711 seconds
Time After: 0.10723 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,430.977 KB
Memory After: 3,447.070 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=19114 AND threadid=170326
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | modsys_user_notification | const | uniq_thread_user,idx_user_thread | uniq_thread_user | 8 | const,const | 1 |
Time Before: 0.10885 seconds
Time After: 0.10898 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,439.648 KB
Memory After: 3,455.883 KB
Memory Used: 16.234 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=170326
| 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.11070 seconds
Time After: 0.11082 seconds
Time Taken: 0.00012 seconds
Memory Before: 3,453.563 KB
Memory After: 3,469.672 KB
Memory Used: 16.109 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=19114 AND threadid=170326
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | modsys_user_notification | const | uniq_thread_user,idx_user_thread | uniq_thread_user | 8 | const,const | 1 |
Time Before: 0.11258 seconds
Time After: 0.11272 seconds
Time Taken: 0.00014 seconds
Memory Before: 3,461.281 KB
Memory After: 3,477.516 KB
Memory Used: 16.234 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=170326
| 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.11438 seconds
Time After: 0.11450 seconds
Time Taken: 0.00012 seconds
Memory Before: 3,470.984 KB
Memory After: 3,487.094 KB
Memory Used: 16.109 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=29991 AND threadid=170326
| 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.11631 seconds
Time After: 0.11643 seconds
Time Taken: 0.00012 seconds
Memory Before: 3,477.695 KB
Memory After: 3,493.789 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=13519 AND threadid=170326
| 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.11791 seconds
Time After: 0.11802 seconds
Time Taken: 0.00012 seconds
Memory Before: 3,486.789 KB
Memory After: 3,502.883 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=13519 AND threadid=170326
| 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.11980 seconds
Time After: 0.12002 seconds
Time Taken: 0.00022 seconds
Memory Before: 3,495.031 KB
Memory After: 3,511.125 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=32204 AND threadid=170326
| 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.12161 seconds
Time After: 0.12174 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,503.281 KB
Memory After: 3,519.375 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=170326
| 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.12320 seconds
Time After: 0.12329 seconds
Time Taken: 0.00009 seconds
Memory Before: 3,513.383 KB
Memory After: 3,529.492 KB
Memory Used: 16.109 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=32204 AND threadid=170326
| 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.12494 seconds
Time After: 0.12506 seconds
Time Taken: 0.00012 seconds
Memory Before: 3,520.000 KB
Memory After: 3,536.094 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=170326
| 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.12653 seconds
Time After: 0.12665 seconds
Time Taken: 0.00012 seconds
Memory Before: 3,530.352 KB
Memory After: 3,546.461 KB
Memory Used: 16.109 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=32204 AND threadid=170326
| 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.12825 seconds
Time After: 0.12838 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,537.000 KB
Memory After: 3,553.094 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=170326
| 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.12996 seconds
Time After: 0.13010 seconds
Time Taken: 0.00014 seconds
Memory Before: 3,547.070 KB
Memory After: 3,563.180 KB
Memory Used: 16.109 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=31922 AND threadid=170326
| 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.13177 seconds
Time After: 0.13192 seconds
Time Taken: 0.00015 seconds
Memory Before: 3,552.500 KB
Memory After: 3,568.594 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=170326
| 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.13358 seconds
Time After: 0.13374 seconds
Time Taken: 0.00017 seconds
Memory Before: 3,562.977 KB
Memory After: 3,579.086 KB
Memory Used: 16.109 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=32204 AND threadid=170326
| 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.13541 seconds
Time After: 0.13554 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,569.484 KB
Memory After: 3,585.578 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=32204 AND threadid=170326
| 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.13716 seconds
Time After: 0.13727 seconds
Time Taken: 0.00011 seconds
Memory Before: 3,577.703 KB
Memory After: 3,593.797 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=16716 AND threadid=170326
| 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.13882 seconds
Time After: 0.13895 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,586.781 KB
Memory After: 3,602.875 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=170326
| 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.14062 seconds
Time After: 0.14074 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,596.055 KB
Memory After: 3,612.164 KB
Memory Used: 16.109 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=25624 AND threadid=170326
| 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.14240 seconds
Time After: 0.14253 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,602.852 KB
Memory After: 3,618.945 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=16716 AND threadid=170326
| 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.14415 seconds
Time After: 0.14439 seconds
Time Taken: 0.00023 seconds
Memory Before: 3,612.000 KB
Memory After: 3,628.094 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=25624 AND threadid=170326
| 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.14609 seconds
Time After: 0.14621 seconds
Time Taken: 0.00012 seconds
Memory Before: 3,624.047 KB
Memory After: 3,640.141 KB
Memory Used: 16.094 KB
SELECT user.username, user.usergroupid, user.membergroupids, session.userid, session.inthread, session.lastactivity, session.badlocation, IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid, IF(user.options & 512, 1, 0) AS invisible FROM session AS session LEFT JOIN user AS user ON(user.userid = session.userid) WHERE session.lastactivity > 1789846674 ORDER BY username ASC, lastactivity DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | session | ALL | 359 | Using where; Using temporary; Using filesort | ||||
| 1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | wckediden_vb3.session.userid | 1 |
Time Before: 0.14795 seconds
Time After: 0.14865 seconds
Time Taken: 0.00070 seconds
Memory Before: 3,407.297 KB
Memory After: 3,426.977 KB
Memory Used: 19.680 KB
SELECT thread.threadid, thread.forumid, thread.title, thread.prefixid, thread.taglist, postusername, postuserid, thread.lastpost, thread.replycount, forum.title AS forumtitle ,post.pagetext AS preview , 0 AS issubscribed FROM thread AS thread INNER JOIN forum AS forum ON (forum.forumid = thread.forumid) LEFT JOIN post AS post ON (post.postid = thread.firstpostid) WHERE thread.threadid IN (86689, 89636, 182258, 184568, 173002) AND thread.visible = 1 AND forum.password = '' ORDER BY lastpost DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | thread | range | PRIMARY,forumid | PRIMARY | 4 | 5 | Using where; Using filesort | |
| 1 | SIMPLE | forum | eq_ref | PRIMARY | PRIMARY | 2 | wckediden_vb3.thread.forumid | 1 | Using where |
| 1 | SIMPLE | post | eq_ref | PRIMARY | PRIMARY | 4 | wckediden_vb3.thread.firstpostid | 1 |
Time Before: 0.14914 seconds
Time After: 0.14942 seconds
Time Taken: 0.00028 seconds
Memory Before: 3,406.789 KB
Memory After: 3,438.672 KB
Memory Used: 31.883 KB
SELECT userid, lastactivity, useragent FROM session WHERE lastactivity > 1789846674 AND userid = 0 AND inthread = 170326
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | session | ALL | 359 | Using where |
Time Before: 0.15063 seconds
Time After: 0.15083 seconds
Time Taken: 0.00020 seconds
Memory Before: 3,499.750 KB
Memory After: 3,515.742 KB
Memory Used: 15.992 KB
SELECT forumid, forumpermissions FROM forumpermission WHERE usergroupid = 1 AND forumid IN (18,533,5,4)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | forumpermission | range | ugid_fid | ugid_fid | 4 | 4 | Using index condition |
Time Before: 0.15775 seconds
Time After: 0.15791 seconds
Time Taken: 0.00016 seconds
Memory Before: 4,219.219 KB
Memory After: 4,235.305 KB
Memory Used: 16.086 KB
SELECT postid, userid, username, dateline, pagetext, visible FROM post WHERE postid = 270588 LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | post | const | PRIMARY | PRIMARY | 4 | const | 1 |
Time Before: 0.15810 seconds
Time After: 0.15823 seconds
Time Taken: 0.00013 seconds
Memory Before: 4,218.922 KB
Memory After: 4,235.242 KB
Memory Used: 16.320 KB
UPDATE session SET lastactivity = 1789847574, location = '/showthread.php?explain=1&p=280255', inforum = 18, inthread = 170326 WHERE sessionhash = '2b1b20e77785fbb1a30e93b4d0992918'
Time Before: 0.15897 seconds
Time After: 0.15911 seconds
Time Taken: 0.00014 seconds
Memory Before: 4,739.508 KB
Memory After: 4,739.461 KB
Memory Used: -0.047 KB
UPDATE thread SET views = views + 1 WHERE threadid = 170326
Time Before: 0.15916 seconds
Time After: 0.25350 seconds
Time Taken: 0.09434 seconds
Memory Before: 4,737.328 KB
Memory After: 4,737.453 KB
Memory Used: 0.125 KB