Time Before: 0.00028 seconds
Time After: 0.00029 seconds
Time Taken: 0.00001 seconds
Memory Before: 433.711 KB
Memory After: 435.547 KB
Memory Used: 1.836 KB
Time Before: 0.00031 seconds
Time After: 0.01381 seconds
Time Taken: 0.01349 seconds
Memory Before: 435.531 KB
Memory After: 436.266 KB
Memory Used: 0.734 KB
SET @@sql_mode = ''
Time Before: 0.01402 seconds
Time After: 0.01421 seconds
Time Taken: 0.00019 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.01468 seconds
Time After: 0.01570 seconds
Time Taken: 0.00102 seconds
Memory Before: 437.703 KB
Memory After: 1,174.008 KB
Memory Used: 736.305 KB
Time Before: 0.01424 seconds
Time After: 0.02676 seconds
Time Taken: 0.01252 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.02706 seconds
Time After: 0.02739 seconds
Time Taken: 0.00033 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 | 351 | Using where |
Time Before: 0.02783 seconds
Time After: 0.02799 seconds
Time Taken: 0.00016 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.02824 seconds
Time After: 0.02845 seconds
Time Taken: 0.00022 seconds
Memory Before: 1,998.242 KB
Memory After: 2,190.930 KB
Memory Used: 192.688 KB
Time Before: 0.02749 seconds
Time After: 0.02849 seconds
Time Taken: 0.00100 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 = 299124
| 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.03026 seconds
Time After: 0.03044 seconds
Time Taken: 0.00017 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 = 173425
| 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.03064 seconds
Time After: 0.03084 seconds
Time Taken: 0.00020 seconds
Memory Before: 2,253.773 KB
Memory After: 2,270.063 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.03124 seconds
Time After: 0.03144 seconds
Time Taken: 0.00020 seconds
Memory Before: 2,260.609 KB
Memory After: 2,412.977 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.03282 seconds
Time After: 0.03359 seconds
Time Taken: 0.00077 seconds
Memory Before: 2,447.570 KB
Memory After: 2,865.375 KB
Memory Used: 417.805 KB
SELECT COUNT(*) AS posts FROM post AS post WHERE threadid = 173425 AND visible = 1 AND dateline <= 1224525808
| 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 | 50 | Using where; Using index |
Time Before: 0.03597 seconds
Time After: 0.03613 seconds
Time Taken: 0.00016 seconds
Memory Before: 2,847.219 KB
Memory After: 2,863.383 KB
Memory Used: 16.164 KB
SELECT post.postid, post.attach FROM post AS post WHERE post.threadid = 173425 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 | 211 | Using where; Using index |
Time Before: 0.03640 seconds
Time After: 0.03654 seconds
Time Taken: 0.00014 seconds
Memory Before: 2,849.797 KB
Memory After: 2,866.758 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,289726,289727,289735,289951,290230,290287,290483,290493,290511,290690,293942,294232,294283,294294,294316,294411,294447,294515,294527,296076,296088,296090,296103,296105,296109,296151,296164,296283,296323,296424,296437,296450,296453,296623,296640,296721,296727,297076,298457,298458,298460,298463,298465,298471,298482,298484,299021,299099,299120,299124) 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.03686 seconds
Time After: 0.03720 seconds
Time Taken: 0.00034 seconds
Memory Before: 2,854.664 KB
Memory After: 2,870.109 KB
Memory Used: 15.445 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 = 173425) LEFT JOIN modsys_licences AS licence ON(licence.modsys_licencesid = modification.mod_licence) WHERE post.postid IN (0,289726,289727,289735,289951,290230,290287,290483,290493,290511,290690,293942,294232,294283,294294,294316,294411,294447,294515,294527,296076,296088,296090,296103,296105,296109,296151,296164,296283,296323,296424,296437,296450,296453,296623,296640,296721,296727,297076,298457,298458,298460,298463,298465,298471,298482,298484,299021,299099,299120,299124) 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.03775 seconds
Time After: 0.03941 seconds
Time Taken: 0.00166 seconds
Memory Before: 2,882.125 KB
Memory After: 3,090.695 KB
Memory Used: 208.570 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=173425
| 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.03996 seconds
Time After: 0.04006 seconds
Time Taken: 0.00010 seconds
Memory Before: 3,178.703 KB
Memory After: 3,194.828 KB
Memory Used: 16.125 KB
SELECT * FROM modsys_user_notification WHERE userid=0 AND threadid=173425
| 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.04019 seconds
Time After: 0.04029 seconds
Time Taken: 0.00009 seconds
Memory Before: 3,184.609 KB
Memory After: 3,200.953 KB
Memory Used: 16.344 KB
SELECT manual_notify FROM modsys_user_notification WHERE threadid=173425 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 | 177 | Using where |
Time Before: 0.04083 seconds
Time After: 0.04152 seconds
Time Taken: 0.00069 seconds
Memory Before: 3,219.734 KB
Memory After: 3,235.828 KB
Memory Used: 16.094 KB
SELECT * FROM post_thanks AS post_thanks INNER JOIN user AS user USING (userid) WHERE post_thanks.postid IN (0,289726,289727,289735,289951,290230,290287,290483,290493,290511,290690,293942,294232,294283,294294,294316,294411,294447,294515,294527,296076,296088,296090,296103,296105,296109,296151,296164,296283,296323,296424,296437,296450,296453,296623,296640,296721,296727,297076,298457,298458,298460,298463,298465,298471,298482,298484,299021,299099,299120,299124) 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 | 127 | Using index condition; Using filesort | |
| 1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | wckediden_vb3.post_thanks.userid | 1 | Using where |
Time Before: 0.04190 seconds
Time After: 0.04309 seconds
Time Taken: 0.00119 seconds
Memory Before: 3,225.055 KB
Memory After: 3,323.156 KB
Memory Used: 98.102 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='build' 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.04405 seconds
Time After: 0.04426 seconds
Time Taken: 0.00021 seconds
Memory Before: 3,334.406 KB
Memory After: 3,349.586 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=' juicy' 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.04457 seconds
Time After: 0.04485 seconds
Time Taken: 0.00027 seconds
Memory Before: 3,350.586 KB
Memory After: 3,365.766 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=' kitchen' 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.04526 seconds
Time After: 0.04549 seconds
Time Taken: 0.00023 seconds
Memory Before: 3,350.586 KB
Memory After: 3,365.766 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=' rom' 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.04571 seconds
Time After: 0.04589 seconds
Time Taken: 0.00017 seconds
Memory Before: 3,350.586 KB
Memory After: 3,365.766 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 (289726) 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 | 49 | Using where; Using filesort |
| 1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | wckediden_vb3.post_thanks.userid | 1 | Using where |
Time Before: 0.05034 seconds
Time After: 0.05109 seconds
Time Taken: 0.00076 seconds
Memory Before: 3,339.273 KB
Memory After: 3,405.063 KB
Memory Used: 65.789 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=12801 AND threadid=173425
| 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.05274 seconds
Time After: 0.05287 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,358.008 KB
Memory After: 3,374.102 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=173425
| 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.05478 seconds
Time After: 0.05492 seconds
Time Taken: 0.00014 seconds
Memory Before: 3,382.227 KB
Memory After: 3,398.352 KB
Memory Used: 16.125 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=19259 AND threadid=173425
| 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.05665 seconds
Time After: 0.05680 seconds
Time Taken: 0.00014 seconds
Memory Before: 3,384.938 KB
Memory After: 3,401.031 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=19259 AND threadid=173425
| 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.05843 seconds
Time After: 0.05856 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,389.391 KB
Memory After: 3,405.484 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=173425
| 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.06023 seconds
Time After: 0.06036 seconds
Time Taken: 0.00014 seconds
Memory Before: 3,399.531 KB
Memory After: 3,415.656 KB
Memory Used: 16.125 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=19259 AND threadid=173425
| 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.06270 seconds
Time After: 0.06283 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,410.039 KB
Memory After: 3,426.133 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=22391 AND threadid=173425
| 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.06445 seconds
Time After: 0.06465 seconds
Time Taken: 0.00020 seconds
Memory Before: 3,415.039 KB
Memory After: 3,431.273 KB
Memory Used: 16.234 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=19259 AND threadid=173425
| 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.06634 seconds
Time After: 0.06647 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,426.719 KB
Memory After: 3,442.813 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=173425
| 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.06816 seconds
Time After: 0.06830 seconds
Time Taken: 0.00014 seconds
Memory Before: 3,436.898 KB
Memory After: 3,453.023 KB
Memory Used: 16.125 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=173425
| 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.07004 seconds
Time After: 0.07016 seconds
Time Taken: 0.00011 seconds
Memory Before: 3,446.383 KB
Memory After: 3,462.508 KB
Memory Used: 16.125 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=12801 AND threadid=173425
| 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.07187 seconds
Time After: 0.07202 seconds
Time Taken: 0.00015 seconds
Memory Before: 3,452.719 KB
Memory After: 3,468.813 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=9731 AND threadid=173425
| 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.07370 seconds
Time After: 0.07382 seconds
Time Taken: 0.00012 seconds
Memory Before: 3,463.445 KB
Memory After: 3,479.539 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=24820 AND threadid=173425
| 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.07536 seconds
Time After: 0.07548 seconds
Time Taken: 0.00012 seconds
Memory Before: 3,468.938 KB
Memory After: 3,485.031 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=173425
| 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.07724 seconds
Time After: 0.07737 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,481.883 KB
Memory After: 3,498.008 KB
Memory Used: 16.125 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=12801 AND threadid=173425
| 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.07910 seconds
Time After: 0.07922 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,489.453 KB
Memory After: 3,505.547 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=173425
| 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.08084 seconds
Time After: 0.08096 seconds
Time Taken: 0.00012 seconds
Memory Before: 3,498.742 KB
Memory After: 3,514.867 KB
Memory Used: 16.125 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=12307 AND threadid=173425
| 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.08260 seconds
Time After: 0.08273 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,505.750 KB
Memory After: 3,521.844 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=173425
| 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.08428 seconds
Time After: 0.08441 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,515.984 KB
Memory After: 3,532.109 KB
Memory Used: 16.125 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=173425
| 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.08607 seconds
Time After: 0.08620 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,524.102 KB
Memory After: 3,540.227 KB
Memory Used: 16.125 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=23343 AND threadid=173425
| 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.08777 seconds
Time After: 0.08790 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,530.867 KB
Memory After: 3,546.961 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=173425
| 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.08949 seconds
Time After: 0.08963 seconds
Time Taken: 0.00014 seconds
Memory Before: 3,540.961 KB
Memory After: 3,557.086 KB
Memory Used: 16.125 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=23343 AND threadid=173425
| 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.09126 seconds
Time After: 0.09138 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,551.266 KB
Memory After: 3,567.359 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=12801 AND threadid=173425
| 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.09302 seconds
Time After: 0.09316 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,560.281 KB
Memory After: 3,576.375 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=173425
| 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.09474 seconds
Time After: 0.09488 seconds
Time Taken: 0.00014 seconds
Memory Before: 3,569.422 KB
Memory After: 3,585.547 KB
Memory Used: 16.125 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=12801 AND threadid=173425
| 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.09649 seconds
Time After: 0.09664 seconds
Time Taken: 0.00015 seconds
Memory Before: 3,576.781 KB
Memory After: 3,592.875 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=173425
| 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.09857 seconds
Time After: 0.09868 seconds
Time Taken: 0.00012 seconds
Memory Before: 3,585.875 KB
Memory After: 3,602.000 KB
Memory Used: 16.125 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=12801 AND threadid=173425
| 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.10031 seconds
Time After: 0.10041 seconds
Time Taken: 0.00009 seconds
Memory Before: 3,593.883 KB
Memory After: 3,609.977 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=173425
| 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.10199 seconds
Time After: 0.10208 seconds
Time Taken: 0.00009 seconds
Memory Before: 3,607.078 KB
Memory After: 3,623.203 KB
Memory Used: 16.125 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=12801 AND threadid=173425
| 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.10371 seconds
Time After: 0.10380 seconds
Time Taken: 0.00009 seconds
Memory Before: 3,614.914 KB
Memory After: 3,631.008 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=173425
| 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.10549 seconds
Time After: 0.10561 seconds
Time Taken: 0.00012 seconds
Memory Before: 3,623.266 KB
Memory After: 3,639.391 KB
Memory Used: 16.125 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=12801 AND threadid=173425
| 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.10729 seconds
Time After: 0.10740 seconds
Time Taken: 0.00011 seconds
Memory Before: 3,634.633 KB
Memory After: 3,650.727 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=173425
| 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.10892 seconds
Time After: 0.10902 seconds
Time Taken: 0.00010 seconds
Memory Before: 3,644.477 KB
Memory After: 3,660.602 KB
Memory Used: 16.125 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=12387 AND threadid=173425
| 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.11063 seconds
Time After: 0.11077 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,651.648 KB
Memory After: 3,667.742 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=173425
| 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.11237 seconds
Time After: 0.11250 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,661.727 KB
Memory After: 3,677.852 KB
Memory Used: 16.125 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=34360 AND threadid=173425
| 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.11414 seconds
Time After: 0.11426 seconds
Time Taken: 0.00012 seconds
Memory Before: 3,667.836 KB
Memory After: 3,683.930 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=173425
| 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.11582 seconds
Time After: 0.11595 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,678.242 KB
Memory After: 3,694.367 KB
Memory Used: 16.125 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=12801 AND threadid=173425
| 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.11756 seconds
Time After: 0.11767 seconds
Time Taken: 0.00011 seconds
Memory Before: 3,685.922 KB
Memory After: 3,702.016 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=23343 AND threadid=173425
| 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.11932 seconds
Time After: 0.11947 seconds
Time Taken: 0.00014 seconds
Memory Before: 3,697.672 KB
Memory After: 3,713.766 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=12801 AND threadid=173425
| 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.12114 seconds
Time After: 0.12130 seconds
Time Taken: 0.00016 seconds
Memory Before: 3,707.289 KB
Memory After: 3,723.383 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=23343 AND threadid=173425
| 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.12310 seconds
Time After: 0.12319 seconds
Time Taken: 0.00010 seconds
Memory Before: 3,713.609 KB
Memory After: 3,729.703 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=12801 AND threadid=173425
| 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.12476 seconds
Time After: 0.12485 seconds
Time Taken: 0.00009 seconds
Memory Before: 3,722.914 KB
Memory After: 3,739.008 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=23343 AND threadid=173425
| 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.12662 seconds
Time Taken: 0.00009 seconds
Memory Before: 3,733.828 KB
Memory After: 3,749.922 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=12801 AND threadid=173425
| 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.12823 seconds
Time After: 0.12832 seconds
Time Taken: 0.00009 seconds
Memory Before: 3,743.102 KB
Memory After: 3,759.195 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=23343 AND threadid=173425
| 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.12999 seconds
Time After: 0.13013 seconds
Time Taken: 0.00014 seconds
Memory Before: 3,750.219 KB
Memory After: 3,766.313 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=12801 AND threadid=173425
| 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.13211 seconds
Time After: 0.13232 seconds
Time Taken: 0.00022 seconds
Memory Before: 3,759.383 KB
Memory After: 3,775.477 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=23343 AND threadid=173425
| 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.13400 seconds
Time After: 0.13413 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,766.891 KB
Memory After: 3,782.984 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=12801 AND threadid=173425
| 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.13580 seconds
Time After: 0.13593 seconds
Time Taken: 0.00012 seconds
Memory Before: 3,775.758 KB
Memory After: 3,791.852 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=36020 AND threadid=173425
| 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.13757 seconds
Time After: 0.13769 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,786.602 KB
Memory After: 3,802.695 KB
Memory Used: 16.094 KB
SELECT mod_installed FROM modsys_user_notification WHERE userid=5 AND threadid=173425
| 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.13929 seconds
Time After: 0.13943 seconds
Time Taken: 0.00014 seconds
Memory Before: 3,793.180 KB
Memory After: 3,809.305 KB
Memory Used: 16.125 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 > 1789846633 ORDER BY username ASC, lastactivity DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | session | ALL | 351 | Using where; Using temporary; Using filesort | ||||
| 1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | wckediden_vb3.session.userid | 1 |
Time Before: 0.14119 seconds
Time After: 0.14204 seconds
Time Taken: 0.00085 seconds
Memory Before: 3,544.500 KB
Memory After: 3,564.180 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 (186813, 187605, 187950, 193332, 182874) 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.14252 seconds
Time After: 0.14289 seconds
Time Taken: 0.00037 seconds
Memory Before: 3,544.242 KB
Memory After: 3,655.875 KB
Memory Used: 111.633 KB
SELECT userid, lastactivity, useragent FROM session WHERE lastactivity > 1789846633 AND userid = 0 AND inthread = 173425
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | session | ALL | 351 | Using where |
Time Before: 0.14447 seconds
Time After: 0.14478 seconds
Time Taken: 0.00031 seconds
Memory Before: 3,728.430 KB
Memory After: 3,744.422 KB
Memory Used: 15.992 KB
SELECT forumid, forumpermissions FROM forumpermission WHERE usergroupid = 1 AND forumid IN (491,528,4)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | forumpermission | range | ugid_fid | ugid_fid | 4 | 3 | Using index condition |
Time Before: 0.15208 seconds
Time After: 0.15225 seconds
Time Taken: 0.00017 seconds
Memory Before: 4,512.547 KB
Memory After: 4,528.617 KB
Memory Used: 16.070 KB
SELECT postid, userid, username, dateline, pagetext, visible FROM post WHERE postid = 289726 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.15254 seconds
Time After: 0.15274 seconds
Time Taken: 0.00020 seconds
Memory Before: 4,512.250 KB
Memory After: 4,568.570 KB
Memory Used: 56.320 KB
UPDATE session SET lastactivity = 1789847533, location = '/showthread.php?explain=1&p=299124', inforum = 491, inthread = 173425 WHERE sessionhash = '2b1b20e77785fbb1a30e93b4d0992918'
Time Before: 0.15552 seconds
Time After: 0.15592 seconds
Time Taken: 0.00040 seconds
Memory Before: 5,084.867 KB
Memory After: 5,084.820 KB
Memory Used: -0.047 KB
UPDATE thread SET views = views + 1 WHERE threadid = 173425
Time Before: 0.15596 seconds
Time After: 0.22540 seconds
Time Taken: 0.06944 seconds
Memory Before: 5,082.688 KB
Memory After: 5,082.813 KB
Memory Used: 0.125 KB