Time Before: 0.00013 seconds
Time After: 0.00014 seconds
Time Taken: 0.00001 seconds
Memory Before: 428.734 KB
Memory After: 430.570 KB
Memory Used: 1.836 KB
Time Before: 0.00016 seconds
Time After: 0.00040 seconds
Time Taken: 0.00024 seconds
Memory Before: 430.555 KB
Memory After: 431.445 KB
Memory Used: 0.891 KB
SET @@sql_mode = ''
Time Before: 0.00048 seconds
Time After: 0.00055 seconds
Time Taken: 0.00007 seconds
Memory Before: 431.492 KB
Memory After: 431.547 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 | 200 | 18 | Using where |
Time Before: 0.00089 seconds
Time After: 0.00112 seconds
Time Taken: 0.00024 seconds
Memory Before: 433.086 KB
Memory After: 650.266 KB
Memory Used: 217.180 KB
Time Before: 0.00057 seconds
Time After: 0.00553 seconds
Time Taken: 0.00497 seconds
Memory Before: 431.336 KB
Memory After: 967.000 KB
Memory Used: 535.664 KB
SELECT *
FROM datastore
WHERE title IN ('modstats_coder','modstats_designer','modstats_motm','modtitle_coder','modtitle_designer')| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | datastore | range | PRIMARY | PRIMARY | 200 | 5 | Using where |
Time Before: 0.00799 seconds
Time After: 0.00818 seconds
Time Taken: 0.00019 seconds
Memory Before: 968.734 KB
Memory After: 1,353.055 KB
Memory Used: 384.320 KB
SELECT * FROM session WHERE userid = 0 AND host = '18.219.150.195' AND idhash = '7a523ef25b5fdd5c5d07e8d56a01d65e' LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | session | ALL | 1782 | Using where |
Time Before: 0.00843 seconds
Time After: 0.00927 seconds
Time Taken: 0.00083 seconds
Memory Before: 1,159.242 KB
Memory After: 1,175.688 KB
Memory Used: 16.445 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, 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 | system | PRIMARY | 1 |
Time Before: 0.00960 seconds
Time After: 0.00975 seconds
Time Taken: 0.00015 seconds
Memory Before: 1,165.375 KB
Memory After: 1,310.320 KB
Memory Used: 144.945 KB
Time Before: 0.00825 seconds
Time After: 0.00981 seconds
Time Taken: 0.00156 seconds
Memory Before: 1,156.797 KB
Memory After: 1,235.617 KB
Memory Used: 78.820 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 = 488865
| 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 | 0 | Unique row not found |
Time Before: 0.01310 seconds
Time After: 0.01330 seconds
Time Taken: 0.00020 seconds
Memory Before: 1,366.039 KB
Memory After: 1,382.359 KB
Memory Used: 16.320 KB
SELECT IF(visible = 2, 1, 0) AS isdeleted, thread.* FROM thread AS thread WHERE thread.threadid = 62849
| 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.01349 seconds
Time After: 0.01364 seconds
Time Taken: 0.00015 seconds
Memory Before: 1,369.477 KB
Memory After: 1,386.047 KB
Memory Used: 16.570 KB
SELECT * FROM style WHERE (styleid = 2 AND userselect = 1) OR styleid = 2 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.01391 seconds
Time After: 0.01399 seconds
Time Taken: 0.00008 seconds
Memory Before: 1,374.398 KB
Memory After: 1,470.906 KB
Memory Used: 96.508 KB
SELECT title, template FROM template WHERE templateid IN (69,70,72,71,154,560,186,187,189,196,195,607,369,355,356,358,357,360,362,363,364,366,368,92,94,96,98,602,398,401,402,399,397,470,471,348,347,349,353,351,498,132,131,133,134,641,644,624,67,66,68,63,62,339,645,291,292,293,559,562,571,312,313,314,315,513,576,575,577,580,599,600,595,609,596,131,132,133,134,149,584,585,587,588,586,583,581,582,594,589,590,593,592,591,366,394,395,392,598,615,619,610,611,612,613,616,618)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | template | range | PRIMARY | PRIMARY | 4 | 102 | Using where |
Time Before: 0.01495 seconds
Time After: 0.01527 seconds
Time Taken: 0.00032 seconds
Memory Before: 1,527.422 KB
Memory After: 1,840.977 KB
Memory Used: 313.555 KB
SELECT post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted, user.*, userfield.* FROM post AS post LEFT JOIN user AS user ON(user.userid = post.userid) LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid) WHERE threadid = 62849 ORDER BY postid
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | post | ref | threadid | threadid | 4 | const | 385 | Using where; Using filesort |
| 1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | vbsupport_vborg.post.userid | 1 | |
| 1 | SIMPLE | userfield | eq_ref | PRIMARY | PRIMARY | 4 | vbsupport_vborg.user.userid | 1 | Using where |
Time Before: 0.02194 seconds
Time After: 0.03376 seconds
Time Taken: 0.01183 seconds
Memory Before: 1,894.117 KB
Memory After: 3,118.336 KB
Memory Used: 1,224.219 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,488831,488835,488840,488841,488842,488844,488845,488847,488849,488850,488851,488852,488854,488856,488858,488860,488861,488862,488863,488864,488865,488870,488871,488873,488874,488875,488878,488879,488880,488881,488883,488888,488891,488898,488901,488903,488904,488907,488908,488909,488911,488912,488913,488915,488916,488918,488920,488921,488922,488925,488926,488927,488928,488931,488932,488934,488935,488937,488939,488940,488941,488942,488943,488944,488946,488951,488955,488958,488959,488960,488961,488962,488964,488967,488970,488972,488974,488975,488976,488978,488981,488983,488986,488987,488994,488997,488998,489000,489001,489003,489022,489028,489029,489031,489035,489037,489038,489040,489044,489050,489058,489060,489061,489065,489067,489081,489087,489101,489106,489107,489108,489119,489127,489131,489132,489134,489142,489144,489147,489148,489150,489151,489153,489156,489157,489161,489165,489167,489170,489171,489173,489175,489178,489180,489184,489187,489191,489197,489202,489203,489205,489221,489223,489224,489226,489227,489228,489230,489237,489248,489250,489262,489263,489265,489267,489269,489270,489273,489274,489278,489281,489298,489301,489308,489312,489316,489320,489347,489349,489352,489354,489356,489357,489361,489383,489388,489390,489402,489406,489409,489411,489412,489425,489426,489434,489436,489441,489454,489458,489459,489473,489497,489500,489502,489514,489518,489523,489524,489530,489532,489534,489536,489539,489541,489544,489552,489553,489555,489558,489562,489568,489569,489571,489572,489574,489576,489579,489580,489581,489585,489586,489588,489600,489604,489605,489608,489609,489612,489615,489619,489621,489624,489625,489626,489635,489648,489650,489655,489656,489660,489663,489665,489668,489670,489671,489672,489679,489685,489688,489689,489691,489701,489702,489708,489712,489716,489720,489724,489725,489764,489767,489768,489769,489772,489775,489776,489777,489780,489781,489782,489784,489785,489787,489788,489790,489794,489796,489797,489799,489810,489821,489835,489840,489847,489850,489854,489859,489863,489869,489876,489891,489896,489909,489915,489919,489926,489935,489937,489951,489954,489973,489980,489982,489985,489992,489993,490001,490012,490021,490059,490061,490062,490066,490070,490077,490083,490087,490089,490093,490095,490123,490125,490134,490140,490142,490148,490156,490179,490195,490208,490255,490359,490374,490381,490440,490451,490457,490480,490508,490537,490545,490546,490549,490550,490552,490563,490600,490602,490603,490605,490607,490608,490612,490613,490614,490616,490617,490618,490620,490621,490622,490624,490645,490646,490650,490657,490658,490675,490692,490693,490700,490701,490703,490704,490706,490707,490714,490715,490716,490717,490722,490726,490728,490735,490742,490747,490749,490750,490751,490754)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | attachment | range | postid | postid | 4 | 391 | Using index condition | |
| 1 | SIMPLE | attachmenttype | eq_ref | PRIMARY | PRIMARY | 80 | vbsupport_vborg.attachment.extension | 1 | Using where |
Time Before: 0.03879 seconds
Time After: 0.04005 seconds
Time Taken: 0.00126 seconds
Memory Before: 5,748.938 KB
Memory After: 5,761.320 KB
Memory Used: 12.383 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, 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 ,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 = 2 AND postparsed.languageid = 1) LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 2 AND sigparsed.languageid = 1) LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid) LEFT JOIN modsys_settings AS modification ON(modification.threadid = 62849) LEFT JOIN modsys_licences AS licence ON(licence.modsys_licencesid = modification.mod_licence) WHERE post.postid IN (488851,488852,488854,488856,488858,488860,488861,488862,488863,488864,488865,488870,488871,488873,488874,488875,488878,488879,488880,488881,488883,488888,488891,488898,488901,488903,488904,488907,488908,488909,488911,488912,488913,488915,488916,488918,488920,488921,488922,488925,488926)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | post | range | PRIMARY | PRIMARY | 4 | 41 | Using index condition | |
| 1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | vbsupport_vborg.post.userid | 1 | |
| 1 | SIMPLE | userfield | eq_ref | PRIMARY | PRIMARY | 4 | vbsupport_vborg.user.userid | 1 | Using where |
| 1 | SIMPLE | usertextfield | eq_ref | PRIMARY | PRIMARY | 4 | vbsupport_vborg.user.userid | 1 | Using where |
| 1 | SIMPLE | icon | eq_ref | PRIMARY | PRIMARY | 2 | vbsupport_vborg.post.iconid | 1 | |
| 1 | SIMPLE | avatar | eq_ref | PRIMARY | PRIMARY | 2 | vbsupport_vborg.user.avatarid | 1 | Using where |
| 1 | SIMPLE | customavatar | eq_ref | PRIMARY | PRIMARY | 4 | vbsupport_vborg.user.userid | 1 | Using where |
| 1 | SIMPLE | editlog | eq_ref | PRIMARY | PRIMARY | 4 | vbsupport_vborg.post.postid | 1 | |
| 1 | SIMPLE | postparsed | eq_ref | PRIMARY | PRIMARY | 8 | vbsupport_vborg.post.postid,const,const | 1 | |
| 1 | SIMPLE | sigparsed | eq_ref | PRIMARY | PRIMARY | 8 | vbsupport_vborg.user.userid,const,const | 1 | Using where |
| 1 | SIMPLE | sigpic | eq_ref | PRIMARY | PRIMARY | 4 | vbsupport_vborg.post.userid | 1 | |
| 1 | SIMPLE | modification | ALL | 19206 | Using where; Using join buffer (flat, BNL join) | ||||
| 1 | SIMPLE | licence | eq_ref | PRIMARY | PRIMARY | 4 | vbsupport_vborg.modification.mod_licence | 1 | Using where |
Time Before: 0.04834 seconds
Time After: 0.06675 seconds
Time Taken: 0.01841 seconds
Memory Before: 5,782.117 KB
Memory After: 6,008.617 KB
Memory Used: 226.500 KB
SELECT * FROM post_thanks AS post_thanks INNER JOIN user AS user USING (userid) WHERE post_thanks.postid IN (0,0,488831,488835,488840,488841,488842,488844,488845,488847,488849,488850,488851,488852,488854,488856,488858,488860,488861,488862,488863,488864,488865,488870,488871,488873,488874,488875,488878,488879,488880,488881,488883,488888,488891,488898,488901,488903,488904,488907,488908,488909,488911,488912,488913,488915,488916,488918,488920,488921,488922,488925,488926,488927,488928,488931,488932,488934,488935,488937,488939,488940,488941,488942,488943,488944,488946,488951,488955,488958,488959,488960,488961,488962,488964,488967,488970,488972,488974,488975,488976,488978,488981,488983,488986,488987,488994,488997,488998,489000,489001,489003,489022,489028,489029,489031,489035,489037,489038,489040,489044,489050,489058,489060,489061,489065,489067,489081,489087,489101,489106,489107,489108,489119,489127,489131,489132,489134,489142,489144,489147,489148,489150,489151,489153,489156,489157,489161,489165,489167,489170,489171,489173,489175,489178,489180,489184,489187,489191,489197,489202,489203,489205,489221,489223,489224,489226,489227,489228,489230,489237,489248,489250,489262,489263,489265,489267,489269,489270,489273,489274,489278,489281,489298,489301,489308,489312,489316,489320,489347,489349,489352,489354,489356,489357,489361,489383,489388,489390,489402,489406,489409,489411,489412,489425,489426,489434,489436,489441,489454,489458,489459,489473,489497,489500,489502,489514,489518,489523,489524,489530,489532,489534,489536,489539,489541,489544,489552,489553,489555,489558,489562,489568,489569,489571,489572,489574,489576,489579,489580,489581,489585,489586,489588,489600,489604,489605,489608,489609,489612,489615,489619,489621,489624,489625,489626,489635,489648,489650,489655,489656,489660,489663,489665,489668,489670,489671,489672,489679,489685,489688,489689,489691,489701,489702,489708,489712,489716,489720,489724,489725,489764,489767,489768,489769,489772,489775,489776,489777,489780,489781,489782,489784,489785,489787,489788,489790,489794,489796,489797,489799,489810,489821,489835,489840,489847,489850,489854,489859,489863,489869,489876,489891,489896,489909,489915,489919,489926,489935,489937,489951,489954,489973,489980,489982,489985,489992,489993,490001,490012,490021,490059,490061,490062,490066,490070,490077,490083,490087,490089,490093,490095,490123,490125,490134,490140,490142,490148,490156,490179,490195,490208,490255,490359,490374,490381,490440,490451,490457,490480,490508,490537,490545,490546,490549,490550,490552,490563,490600,490602,490603,490605,490607,490608,490612,490613,490614,490616,490617,490618,490620,490621,490622,490624,490645,490646,490650,490657,490658,490675,490692,490693,490700,490701,490703,490704,490706,490707,490714,490715,490716,490717,490722,490726,490728,490735,490742,490747,490749,490750,490751,490754) 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 | 391 | Using index condition; Using filesort | |
| 1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | vbsupport_vborg.post_thanks.userid | 1 | Using where |
Time Before: 0.06839 seconds
Time After: 0.06956 seconds
Time Taken: 0.00117 seconds
Memory Before: 2,841.609 KB
Memory After: 2,870.984 KB
Memory Used: 29.375 KB
UPDATE session SET lastactivity = 1736326011, location = '/showthread.php?explain=1&mode=threaded&p=488865', inforum = 2, inthread = 62849 WHERE sessionhash = '0d71ed8feabc93bd2c15ff553a3a4578'
Time Before: 0.15598 seconds
Time After: 0.15610 seconds
Time Taken: 0.00012 seconds
Memory Before: 3,739.898 KB
Memory After: 3,739.820 KB
Memory Used: -0.078 KB
INSERT INTO threadviews (threadid) VALUES (62849)
Time Before: 0.15615 seconds
Time After: 0.15649 seconds
Time Taken: 0.00034 seconds
Memory Before: 3,737.469 KB
Memory After: 3,737.516 KB
Memory Used: 0.047 KB