Time Before: 0.00087 seconds
Time After: 0.00090 seconds
Time Taken: 0.00004 seconds
Memory Before: 433.711 KB
Memory After: 435.547 KB
Memory Used: 1.836 KB
Time Before: 0.00098 seconds
Time After: 0.00451 seconds
Time Taken: 0.00353 seconds
Memory Before: 435.531 KB
Memory After: 436.266 KB
Memory Used: 0.734 KB
SET @@sql_mode = ''
Time Before: 0.00516 seconds
Time After: 0.00575 seconds
Time Taken: 0.00059 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.00700 seconds
Time After: 0.01036 seconds
Time Taken: 0.00336 seconds
Memory Before: 437.703 KB
Memory After: 1,174.008 KB
Memory Used: 736.305 KB
Time Before: 0.00583 seconds
Time After: 0.02970 seconds
Time Taken: 0.02388 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.03034 seconds
Time After: 0.03107 seconds
Time Taken: 0.00073 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 | 586 | Using where |
Time Before: 0.03145 seconds
Time After: 0.03161 seconds
Time Taken: 0.00016 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.03193 seconds
Time After: 0.03244 seconds
Time Taken: 0.00051 seconds
Memory Before: 1,999.875 KB
Memory After: 2,192.563 KB
Memory Used: 192.688 KB
Time Before: 0.03120 seconds
Time After: 0.03259 seconds
Time Taken: 0.00138 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 = 214874
| 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.03497 seconds
Time After: 0.03523 seconds
Time Taken: 0.00026 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.03546 seconds
Time After: 0.03562 seconds
Time Taken: 0.00016 seconds
Memory Before: 2,255.148 KB
Memory After: 2,271.438 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.03606 seconds
Time After: 0.03629 seconds
Time Taken: 0.00023 seconds
Memory Before: 2,261.953 KB
Memory After: 2,414.273 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.03761 seconds
Time After: 0.03864 seconds
Time Taken: 0.00103 seconds
Memory Before: 2,448.875 KB
Memory After: 2,878.680 KB
Memory Used: 429.805 KB
SELECT COUNT(*) AS posts FROM post AS post WHERE threadid = 154136 AND visible = 1 AND dateline <= 1207019595
| 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 | 2 | Using where; Using index |
Time Before: 0.04109 seconds
Time After: 0.04130 seconds
Time Taken: 0.00021 seconds
Memory Before: 2,853.555 KB
Memory After: 2,869.719 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.04159 seconds
Time After: 0.04176 seconds
Time Taken: 0.00017 seconds
Memory Before: 2,854.820 KB
Memory After: 2,871.031 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.04203 seconds
Time After: 0.04229 seconds
Time Taken: 0.00026 seconds
Memory Before: 2,856.609 KB
Memory After: 2,872.305 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.04291 seconds
Time After: 0.04360 seconds
Time Taken: 0.00069 seconds
Memory Before: 2,884.578 KB
Memory After: 2,963.422 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.04425 seconds
Time After: 0.04435 seconds
Time Taken: 0.00009 seconds
Memory Before: 3,032.148 KB
Memory After: 3,048.219 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.04449 seconds
Time After: 0.04458 seconds
Time Taken: 0.00009 seconds
Memory Before: 3,038.016 KB
Memory After: 3,054.125 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.04484 seconds
Time After: 0.04499 seconds
Time Taken: 0.00015 seconds
Memory Before: 3,038.398 KB
Memory After: 3,054.453 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.04532 seconds
Time After: 0.04561 seconds
Time Taken: 0.00029 seconds
Memory Before: 3,041.227 KB
Memory After: 3,089.844 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.04610 seconds
Time After: 0.04633 seconds
Time Taken: 0.00023 seconds
Memory Before: 3,076.000 KB
Memory After: 3,091.180 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.04660 seconds
Time After: 0.04681 seconds
Time Taken: 0.00022 seconds
Memory Before: 3,092.180 KB
Memory After: 3,107.359 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.04707 seconds
Time After: 0.04729 seconds
Time Taken: 0.00022 seconds
Memory Before: 3,092.180 KB
Memory After: 3,107.359 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.04753 seconds
Time After: 0.04776 seconds
Time Taken: 0.00024 seconds
Memory Before: 3,092.180 KB
Memory After: 3,107.359 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.04804 seconds
Time After: 0.04825 seconds
Time Taken: 0.00020 seconds
Memory Before: 3,092.180 KB
Memory After: 3,107.359 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.04850 seconds
Time After: 0.04872 seconds
Time Taken: 0.00022 seconds
Memory Before: 3,092.180 KB
Memory After: 3,107.359 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.04895 seconds
Time After: 0.04922 seconds
Time Taken: 0.00027 seconds
Memory Before: 3,092.180 KB
Memory After: 3,107.359 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.05031 seconds
Time After: 0.05051 seconds
Time Taken: 0.00020 seconds
Memory Before: 3,103.508 KB
Memory After: 3,152.188 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.05194 seconds
Time After: 0.05205 seconds
Time Taken: 0.00011 seconds
Memory Before: 3,114.078 KB
Memory After: 3,130.133 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.05364 seconds
Time After: 0.05374 seconds
Time Taken: 0.00010 seconds
Memory Before: 3,132.500 KB
Memory After: 3,148.570 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.05544 seconds
Time After: 0.05557 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,139.320 KB
Memory After: 3,155.375 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.05724 seconds
Time After: 0.05737 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,149.383 KB
Memory After: 3,165.453 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.05900 seconds
Time After: 0.05913 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,155.805 KB
Memory After: 3,171.859 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.06079 seconds
Time After: 0.06092 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,165.945 KB
Memory After: 3,182.016 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.06259 seconds
Time After: 0.06272 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,176.523 KB
Memory After: 3,192.578 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 > 1789850811 ORDER BY username ASC, lastactivity DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | session | ALL | 586 | Using where; Using temporary; Using filesort | ||||
| 1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | wckediden_vb3.session.userid | 1 |
Time Before: 0.06423 seconds
Time After: 0.06501 seconds
Time Taken: 0.00078 seconds
Memory Before: 3,058.305 KB
Memory After: 3,077.984 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.06541 seconds
Time After: 0.06570 seconds
Time Taken: 0.00030 seconds
Memory Before: 3,058.047 KB
Memory After: 3,073.680 KB
Memory Used: 15.633 KB
SELECT userid, lastactivity, useragent FROM session WHERE lastactivity > 1789850811 AND userid = 0 AND inthread = 154136
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | session | ALL | 586 | Using where |
Time Before: 0.06719 seconds
Time After: 0.06740 seconds
Time Taken: 0.00021 seconds
Memory Before: 3,143.844 KB
Memory After: 3,159.836 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.07225 seconds
Time After: 0.07241 seconds
Time Taken: 0.00016 seconds
Memory Before: 3,517.914 KB
Memory After: 3,534.000 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.07262 seconds
Time After: 0.07276 seconds
Time Taken: 0.00014 seconds
Memory Before: 3,517.617 KB
Memory After: 3,533.938 KB
Memory Used: 16.320 KB
UPDATE session SET lastactivity = 1789851711, location = '/showthread.php?explain=1&p=214874', inforum = 20, inthread = 154136 WHERE sessionhash = '2b1b20e77785fbb1a30e93b4d0992918'
Time Before: 0.07313 seconds
Time After: 0.07328 seconds
Time Taken: 0.00015 seconds
Memory Before: 3,682.234 KB
Memory After: 3,682.188 KB
Memory Used: -0.047 KB
UPDATE thread SET views = views + 1 WHERE threadid = 154136
Time Before: 0.07330 seconds
Time After: 0.09104 seconds
Time Taken: 0.01774 seconds
Memory Before: 3,680.055 KB
Memory After: 3,680.180 KB
Memory Used: 0.125 KB