Time Before: 0.00038 seconds
Time After: 0.00039 seconds
Time Taken: 0.00002 seconds
Memory Before: 433.711 KB
Memory After: 435.547 KB
Memory Used: 1.836 KB
Time Before: 0.00043 seconds
Time After: 0.02233 seconds
Time Taken: 0.02190 seconds
Memory Before: 435.531 KB
Memory After: 436.266 KB
Memory Used: 0.734 KB
SET @@sql_mode = ''
Time Before: 0.02274 seconds
Time After: 0.02301 seconds
Time Taken: 0.00027 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.02368 seconds
Time After: 0.02513 seconds
Time Taken: 0.00145 seconds
Memory Before: 437.703 KB
Memory After: 1,174.008 KB
Memory Used: 736.305 KB
Time Before: 0.02305 seconds
Time After: 0.03688 seconds
Time Taken: 0.01383 seconds
Memory Before: 436.156 KB
Memory After: 1,807.078 KB
Memory Used: 1,370.922 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.03732 seconds
Time After: 0.03771 seconds
Time Taken: 0.00039 seconds
Memory Before: 1,808.781 KB
Memory After: 2,064.992 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 | 587 | Using where |
Time Before: 0.03803 seconds
Time After: 0.03819 seconds
Time Taken: 0.00015 seconds
Memory Before: 1,993.961 KB
Memory After: 2,010.156 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.03844 seconds
Time After: 0.03866 seconds
Time Taken: 0.00022 seconds
Memory Before: 1,999.875 KB
Memory After: 2,192.563 KB
Memory Used: 192.688 KB
Time Before: 0.03782 seconds
Time After: 0.03870 seconds
Time Taken: 0.00088 seconds
Memory Before: 1,991.719 KB
Memory After: 2,094.258 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 = 214910
| 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.04049 seconds
Time After: 0.04067 seconds
Time Taken: 0.00019 seconds
Memory Before: 2,252.195 KB
Memory After: 2,268.211 KB
Memory Used: 16.016 KB
SELECT IF(visible = 2, 1, 0) AS isdeleted, thread.* FROM thread AS thread WHERE thread.threadid = 154136
| 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.04088 seconds
Time After: 0.04103 seconds
Time Taken: 0.00015 seconds
Memory Before: 2,255.563 KB
Memory After: 2,271.852 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.04141 seconds
Time After: 0.04160 seconds
Time Taken: 0.00020 seconds
Memory Before: 2,262.367 KB
Memory After: 2,414.688 KB
Memory Used: 152.320 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.04287 seconds
Time After: 0.04365 seconds
Time Taken: 0.00078 seconds
Memory Before: 2,449.289 KB
Memory After: 2,879.094 KB
Memory Used: 429.805 KB
SELECT COUNT(*) AS posts FROM post AS post WHERE threadid = 154136 AND visible = 1 AND dateline <= 1207022826
| 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 | 7 | Using where; Using index |
Time Before: 0.04585 seconds
Time After: 0.04601 seconds
Time Taken: 0.00017 seconds
Memory Before: 2,853.969 KB
Memory After: 2,870.133 KB
Memory Used: 16.164 KB
SELECT post.postid, post.attach FROM post AS post WHERE post.threadid = 154136 AND post.visible = 1 ORDER BY post.dateline LIMIT 0, 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 | 8 | Using where; Using index |
Time Before: 0.04629 seconds
Time After: 0.04644 seconds
Time Taken: 0.00016 seconds
Memory Before: 2,855.234 KB
Memory After: 2,871.445 KB
Memory Used: 16.211 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,213699,214874,214884,214902,214907,214908,214910,214925) ORDER BY attachmentid
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | attachment | range | postid | postid | 4 | 9 | Using index condition; Using filesort | |
| 1 | SIMPLE | attachmenttype | eq_ref | PRIMARY | PRIMARY | 22 | wckediden_vb3.attachment.extension | 1 |
Time Before: 0.04669 seconds
Time After: 0.04693 seconds
Time Taken: 0.00024 seconds
Memory Before: 2,857.023 KB
Memory After: 2,872.719 KB
Memory Used: 15.695 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 = 154136) LEFT JOIN modsys_licences AS licence ON(licence.modsys_licencesid = modification.mod_licence) WHERE post.postid IN (0,213699,214874,214884,214902,214907,214908,214910,214925) ORDER BY post.dateline
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | post | range | PRIMARY | PRIMARY | 4 | 9 | 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.04745 seconds
Time After: 0.04814 seconds
Time Taken: 0.00069 seconds
Memory Before: 2,884.992 KB
Memory After: 2,963.836 KB
Memory Used: 78.844 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=154136
| 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.04871 seconds
Time After: 0.04884 seconds
Time Taken: 0.00012 seconds
Memory Before: 3,032.563 KB
Memory After: 3,048.633 KB
Memory Used: 16.070 KB
SELECT * FROM modsys_user_notification WHERE userid=0 AND threadid=154136
| 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.04901 seconds
Time After: 0.04913 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,038.430 KB
Memory After: 3,054.539 KB
Memory Used: 16.109 KB
SELECT manual_notify FROM modsys_user_notification WHERE threadid=154136 AND manual_notify='1'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | modsys_user_notification | ref | uniq_thread_user | uniq_thread_user | 4 | const | 1 | Using where |
Time Before: 0.04931 seconds
Time After: 0.04945 seconds
Time Taken: 0.00014 seconds
Memory Before: 3,038.813 KB
Memory After: 3,054.867 KB
Memory Used: 16.055 KB
SELECT * FROM post_thanks AS post_thanks INNER JOIN user AS user USING (userid) WHERE post_thanks.postid IN (0,213699,214874,214884,214902,214907,214908,214910,214925) ORDER BY post_thanks.username ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | post_thanks | range | postid | postid | 4 | 9 | Using index condition; Using filesort | |
| 1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | wckediden_vb3.post_thanks.userid | 1 | Using where |
Time Before: 0.04970 seconds
Time After: 0.04993 seconds
Time Taken: 0.00022 seconds
Memory Before: 3,041.641 KB
Memory After: 3,090.258 KB
Memory Used: 48.617 KB
SELECT tag.tagid,tagthread.threadid FROM tag AS tag LEFT JOIN tagthread AS tagthread ON (tagthread.tagid = tag.tagid) LEFT JOIN thread AS thread ON (thread.threadid = tagthread.threadid) WHERE tag.tagtext='collection' AND thread.forumid IN(434, 6, 24, 481, 510, 480, 421, 423, 467, 33, 526, 458, 461, 3, 39, 11, 117, 499, 506, 411, 14, 509, 13, 473, 4, 5, 530, 91, 518, 532, 520, 521, 376, 69, 81, 80, 529, 548, 533, 18, 20, 412, 413, 15, 17, 496, 497, 498, 553, 44, 559, 429, 477, 502, 501, 513, 514, 519, 428, 431, 515, 558, 469, 471, 472, 466, 470, 512, 430, 23, 546, 547, 535, 90, 536, 354, 383, 385, 396, 384, 21, 386, 378, 418, 556, 555, 419, 539, 417, 540, 468, 503, 541, 494, 542, 524, 523, 544, 507, 508, 522, 538, 58, 500, 543, 504, 545, 121, 122, 528, 490, 557, 491, 525, 551, 391, 35, 120, 482, 102, 516, 45, 527, 405, 302, 294, 369, 105, 347, 50, 76, 517)
| 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.05036 seconds
Time After: 0.05054 seconds
Time Taken: 0.00017 seconds
Memory Before: 3,076.414 KB
Memory After: 3,091.594 KB
Memory Used: 15.180 KB
SELECT tag.tagid,tagthread.threadid FROM tag AS tag LEFT JOIN tagthread AS tagthread ON (tagthread.tagid = tag.tagid) LEFT JOIN thread AS thread ON (thread.threadid = tagthread.threadid) WHERE tag.tagtext=' guardians' AND thread.forumid IN(434, 6, 24, 481, 510, 480, 421, 423, 467, 33, 526, 458, 461, 3, 39, 11, 117, 499, 506, 411, 14, 509, 13, 473, 4, 5, 530, 91, 518, 532, 520, 521, 376, 69, 81, 80, 529, 548, 533, 18, 20, 412, 413, 15, 17, 496, 497, 498, 553, 44, 559, 429, 477, 502, 501, 513, 514, 519, 428, 431, 515, 558, 469, 471, 472, 466, 470, 512, 430, 23, 546, 547, 535, 90, 536, 354, 383, 385, 396, 384, 21, 386, 378, 418, 556, 555, 419, 539, 417, 540, 468, 503, 541, 494, 542, 524, 523, 544, 507, 508, 522, 538, 58, 500, 543, 504, 545, 121, 122, 528, 490, 557, 491, 525, 551, 391, 35, 120, 482, 102, 516, 45, 527, 405, 302, 294, 369, 105, 347, 50, 76, 517)
| 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.05074 seconds
Time After: 0.05091 seconds
Time Taken: 0.00017 seconds
Memory Before: 3,092.594 KB
Memory After: 3,107.773 KB
Memory Used: 15.180 KB
SELECT tag.tagid,tagthread.threadid FROM tag AS tag LEFT JOIN tagthread AS tagthread ON (tagthread.tagid = tag.tagid) LEFT JOIN thread AS thread ON (thread.threadid = tagthread.threadid) WHERE tag.tagtext=' ppc' AND thread.forumid IN(434, 6, 24, 481, 510, 480, 421, 423, 467, 33, 526, 458, 461, 3, 39, 11, 117, 499, 506, 411, 14, 509, 13, 473, 4, 5, 530, 91, 518, 532, 520, 521, 376, 69, 81, 80, 529, 548, 533, 18, 20, 412, 413, 15, 17, 496, 497, 498, 553, 44, 559, 429, 477, 502, 501, 513, 514, 519, 428, 431, 515, 558, 469, 471, 472, 466, 470, 512, 430, 23, 546, 547, 535, 90, 536, 354, 383, 385, 396, 384, 21, 386, 378, 418, 556, 555, 419, 539, 417, 540, 468, 503, 541, 494, 542, 524, 523, 544, 507, 508, 522, 538, 58, 500, 543, 504, 545, 121, 122, 528, 490, 557, 491, 525, 551, 391, 35, 120, 482, 102, 516, 45, 527, 405, 302, 294, 369, 105, 347, 50, 76, 517)
| 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.05112 seconds
Time After: 0.05128 seconds
Time Taken: 0.00016 seconds
Memory Before: 3,092.594 KB
Memory After: 3,107.773 KB
Memory Used: 15.180 KB
SELECT tag.tagid,tagthread.threadid FROM tag AS tag LEFT JOIN tagthread AS tagthread ON (tagthread.tagid = tag.tagid) LEFT JOIN thread AS thread ON (thread.threadid = tagthread.threadid) WHERE tag.tagtext=' resco' AND thread.forumid IN(434, 6, 24, 481, 510, 480, 421, 423, 467, 33, 526, 458, 461, 3, 39, 11, 117, 499, 506, 411, 14, 509, 13, 473, 4, 5, 530, 91, 518, 532, 520, 521, 376, 69, 81, 80, 529, 548, 533, 18, 20, 412, 413, 15, 17, 496, 497, 498, 553, 44, 559, 429, 477, 502, 501, 513, 514, 519, 428, 431, 515, 558, 469, 471, 472, 466, 470, 512, 430, 23, 546, 547, 535, 90, 536, 354, 383, 385, 396, 384, 21, 386, 378, 418, 556, 555, 419, 539, 417, 540, 468, 503, 541, 494, 542, 524, 523, 544, 507, 508, 522, 538, 58, 500, 543, 504, 545, 121, 122, 528, 490, 557, 491, 525, 551, 391, 35, 120, 482, 102, 516, 45, 527, 405, 302, 294, 369, 105, 347, 50, 76, 517)
| 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.05148 seconds
Time After: 0.05164 seconds
Time Taken: 0.00016 seconds
Memory Before: 3,092.594 KB
Memory After: 3,107.773 KB
Memory Used: 15.180 KB
SELECT tag.tagid,tagthread.threadid FROM tag AS tag LEFT JOIN tagthread AS tagthread ON (tagthread.tagid = tag.tagid) LEFT JOIN thread AS thread ON (thread.threadid = tagthread.threadid) WHERE tag.tagtext=' retail' AND thread.forumid IN(434, 6, 24, 481, 510, 480, 421, 423, 467, 33, 526, 458, 461, 3, 39, 11, 117, 499, 506, 411, 14, 509, 13, 473, 4, 5, 530, 91, 518, 532, 520, 521, 376, 69, 81, 80, 529, 548, 533, 18, 20, 412, 413, 15, 17, 496, 497, 498, 553, 44, 559, 429, 477, 502, 501, 513, 514, 519, 428, 431, 515, 558, 469, 471, 472, 466, 470, 512, 430, 23, 546, 547, 535, 90, 536, 354, 383, 385, 396, 384, 21, 386, 378, 418, 556, 555, 419, 539, 417, 540, 468, 503, 541, 494, 542, 524, 523, 544, 507, 508, 522, 538, 58, 500, 543, 504, 545, 121, 122, 528, 490, 557, 491, 525, 551, 391, 35, 120, 482, 102, 516, 45, 527, 405, 302, 294, 369, 105, 347, 50, 76, 517)
| 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.05185 seconds
Time After: 0.05202 seconds
Time Taken: 0.00016 seconds
Memory Before: 3,092.594 KB
Memory After: 3,107.773 KB
Memory Used: 15.180 KB
SELECT tag.tagid,tagthread.threadid FROM tag AS tag LEFT JOIN tagthread AS tagthread ON (tagthread.tagid = tag.tagid) LEFT JOIN thread AS thread ON (thread.threadid = tagthread.threadid) WHERE tag.tagtext=' ultimate' AND thread.forumid IN(434, 6, 24, 481, 510, 480, 421, 423, 467, 33, 526, 458, 461, 3, 39, 11, 117, 499, 506, 411, 14, 509, 13, 473, 4, 5, 530, 91, 518, 532, 520, 521, 376, 69, 81, 80, 529, 548, 533, 18, 20, 412, 413, 15, 17, 496, 497, 498, 553, 44, 559, 429, 477, 502, 501, 513, 514, 519, 428, 431, 515, 558, 469, 471, 472, 466, 470, 512, 430, 23, 546, 547, 535, 90, 536, 354, 383, 385, 396, 384, 21, 386, 378, 418, 556, 555, 419, 539, 417, 540, 468, 503, 541, 494, 542, 524, 523, 544, 507, 508, 522, 538, 58, 500, 543, 504, 545, 121, 122, 528, 490, 557, 491, 525, 551, 391, 35, 120, 482, 102, 516, 45, 527, 405, 302, 294, 369, 105, 347, 50, 76, 517)
| 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.05221 seconds
Time After: 0.05246 seconds
Time Taken: 0.00025 seconds
Memory Before: 3,092.594 KB
Memory After: 3,107.773 KB
Memory Used: 15.180 KB
SELECT tag.tagid,tagthread.threadid FROM tag AS tag LEFT JOIN tagthread AS tagthread ON (tagthread.tagid = tag.tagid) LEFT JOIN thread AS thread ON (thread.threadid = tagthread.threadid) WHERE tag.tagtext=' v20' AND thread.forumid IN(434, 6, 24, 481, 510, 480, 421, 423, 467, 33, 526, 458, 461, 3, 39, 11, 117, 499, 506, 411, 14, 509, 13, 473, 4, 5, 530, 91, 518, 532, 520, 521, 376, 69, 81, 80, 529, 548, 533, 18, 20, 412, 413, 15, 17, 496, 497, 498, 553, 44, 559, 429, 477, 502, 501, 513, 514, 519, 428, 431, 515, 558, 469, 471, 472, 466, 470, 512, 430, 23, 546, 547, 535, 90, 536, 354, 383, 385, 396, 384, 21, 386, 378, 418, 556, 555, 419, 539, 417, 540, 468, 503, 541, 494, 542, 524, 523, 544, 507, 508, 522, 538, 58, 500, 543, 504, 545, 121, 122, 528, 490, 557, 491, 525, 551, 391, 35, 120, 482, 102, 516, 45, 527, 405, 302, 294, 369, 105, 347, 50, 76, 517)
| 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.05266 seconds
Time After: 0.05283 seconds
Time Taken: 0.00016 seconds
Memory Before: 3,092.594 KB
Memory After: 3,107.773 KB
Memory Used: 15.180 KB
SELECT * FROM post_thanks AS post_thanks INNER JOIN user AS user USING (userid) WHERE post_thanks.postid IN (213699) ORDER BY post_thanks.username ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | post_thanks | ref | postid | postid | 4 | const | 1 | Using where; Using filesort |
| 1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | wckediden_vb3.post_thanks.userid | 1 | Using where |
Time Before: 0.05390 seconds
Time After: 0.05409 seconds
Time Taken: 0.00019 seconds
Memory Before: 3,103.922 KB
Memory After: 3,152.602 KB
Memory Used: 48.680 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=16204 AND threadid=154136
| 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.05548 seconds
Time After: 0.05556 seconds
Time Taken: 0.00009 seconds
Memory Before: 3,114.492 KB
Memory After: 3,130.547 KB
Memory Used: 16.055 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=154136
| 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.05706 seconds
Time After: 0.05715 seconds
Time Taken: 0.00009 seconds
Memory Before: 3,132.695 KB
Memory After: 3,148.766 KB
Memory Used: 16.070 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=11093 AND threadid=154136
| 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.05877 seconds
Time After: 0.05886 seconds
Time Taken: 0.00009 seconds
Memory Before: 3,139.516 KB
Memory After: 3,155.570 KB
Memory Used: 16.055 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=154136
| 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.06044 seconds
Time After: 0.06052 seconds
Time Taken: 0.00008 seconds
Memory Before: 3,149.578 KB
Memory After: 3,165.648 KB
Memory Used: 16.070 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=11093 AND threadid=154136
| 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.06207 seconds
Time After: 0.06216 seconds
Time Taken: 0.00008 seconds
Memory Before: 3,156.000 KB
Memory After: 3,172.055 KB
Memory Used: 16.055 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=154136
| 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.06386 seconds
Time After: 0.06399 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,166.141 KB
Memory After: 3,182.211 KB
Memory Used: 16.070 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=11093 AND threadid=154136
| 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.06568 seconds
Time After: 0.06581 seconds
Time Taken: 0.00014 seconds
Memory Before: 3,176.938 KB
Memory After: 3,192.992 KB
Memory Used: 16.055 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 > 1789850821 ORDER BY username ASC, lastactivity DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | session | ALL | 587 | Using where; Using temporary; Using filesort | ||||
| 1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | wckediden_vb3.session.userid | 1 |
Time Before: 0.06751 seconds
Time After: 0.06833 seconds
Time Taken: 0.00083 seconds
Memory Before: 3,058.719 KB
Memory After: 3,078.398 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 (170826, 162208, 172337, 175167, 183059) 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.06871 seconds
Time After: 0.06900 seconds
Time Taken: 0.00029 seconds
Memory Before: 3,058.461 KB
Memory After: 3,074.094 KB
Memory Used: 15.633 KB
SELECT userid, lastactivity, useragent FROM session WHERE lastactivity > 1789850821 AND userid = 0 AND inthread = 154136
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | session | ALL | 587 | Using where |
Time Before: 0.07037 seconds
Time After: 0.07059 seconds
Time Taken: 0.00022 seconds
Memory Before: 3,144.258 KB
Memory After: 3,160.250 KB
Memory Used: 15.992 KB
SELECT forumid, forumpermissions FROM forumpermission WHERE usergroupid = 1 AND forumid IN (20,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.07537 seconds
Time After: 0.07553 seconds
Time Taken: 0.00016 seconds
Memory Before: 3,518.328 KB
Memory After: 3,534.414 KB
Memory Used: 16.086 KB
SELECT postid, userid, username, dateline, pagetext, visible FROM post WHERE postid = 213699 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.07570 seconds
Time After: 0.07582 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,518.031 KB
Memory After: 3,534.352 KB
Memory Used: 16.320 KB
UPDATE session SET lastactivity = 1789851721, location = '/showthread.php?explain=1&p=214910', inforum = 20, inthread = 154136 WHERE sessionhash = '2b1b20e77785fbb1a30e93b4d0992918'
Time Before: 0.07613 seconds
Time After: 0.07628 seconds
Time Taken: 0.00014 seconds
Memory Before: 3,682.648 KB
Memory After: 3,682.602 KB
Memory Used: -0.047 KB
UPDATE thread SET views = views + 1 WHERE threadid = 154136
Time Before: 0.07630 seconds
Time After: 0.10094 seconds
Time Taken: 0.02465 seconds
Memory Before: 3,680.469 KB
Memory After: 3,680.594 KB
Memory Used: 0.125 KB