Time Before: 0.00017 seconds
Time After: 0.00019 seconds
Time Taken: 0.00002 seconds
Memory Before: 431.461 KB
Memory After: 433.297 KB
Memory Used: 1.836 KB
Time Before: 0.00021 seconds
Time After: 0.00054 seconds
Time Taken: 0.00033 seconds
Memory Before: 433.281 KB
Memory After: 434.172 KB
Memory Used: 0.891 KB
SET @@sql_mode = ''
Time Before: 0.00062 seconds
Time After: 0.00068 seconds
Time Taken: 0.00006 seconds
Memory Before: 434.219 KB
Memory After: 434.273 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.00105 seconds
Time After: 0.00126 seconds
Time Taken: 0.00021 seconds
Memory Before: 435.813 KB
Memory After: 652.992 KB
Memory Used: 217.180 KB
Time Before: 0.00070 seconds
Time After: 0.00593 seconds
Time Taken: 0.00523 seconds
Memory Before: 434.063 KB
Memory After: 969.727 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.00617 seconds
Time After: 0.00638 seconds
Time Taken: 0.00021 seconds
Memory Before: 971.461 KB
Memory After: 1,355.781 KB
Memory Used: 384.320 KB
SELECT * FROM session WHERE userid = 0 AND host = '18.117.94.180' AND idhash = '9b3e278e71cc860dc949a36845e27d4f' LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | session | ALL | 1630 | Using where |
Time Before: 0.00671 seconds
Time After: 0.00757 seconds
Time Taken: 0.00086 seconds
Memory Before: 1,161.969 KB
Memory After: 1,178.414 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.00795 seconds
Time After: 0.00806 seconds
Time Taken: 0.00012 seconds
Memory Before: 1,167.914 KB
Memory After: 1,312.859 KB
Memory Used: 144.945 KB
Time Before: 0.00649 seconds
Time After: 0.00811 seconds
Time Taken: 0.00162 seconds
Memory Before: 1,159.523 KB
Memory After: 1,237.969 KB
Memory Used: 78.445 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.00975 seconds
Time After: 0.00991 seconds
Time Taken: 0.00017 seconds
Memory Before: 1,367.836 KB
Memory After: 1,384.406 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.01022 seconds
Time After: 0.01031 seconds
Time Taken: 0.00009 seconds
Memory Before: 1,372.445 KB
Memory After: 1,468.953 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.01139 seconds
Time After: 0.01187 seconds
Time Taken: 0.00048 seconds
Memory Before: 1,525.781 KB
Memory After: 1,839.336 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.01385 seconds
Time After: 0.02455 seconds
Time Taken: 0.01070 seconds
Memory Before: 1,892.414 KB
Memory After: 3,116.633 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.02917 seconds
Time After: 0.03055 seconds
Time Taken: 0.00138 seconds
Memory Before: 5,747.234 KB
Memory After: 5,759.617 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 (488831)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | userfield | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | usertextfield | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | icon | const | PRIMARY | PRIMARY | 2 | const | 0 | Unique row not found |
| 1 | SIMPLE | avatar | const | PRIMARY | PRIMARY | 2 | const | 0 | Unique row not found |
| 1 | SIMPLE | customavatar | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | editlog | const | PRIMARY | PRIMARY | 4 | const | 0 | Unique row not found |
| 1 | SIMPLE | postparsed | const | PRIMARY | PRIMARY | 8 | const,const,const | 0 | Unique row not found |
| 1 | SIMPLE | sigparsed | const | PRIMARY | PRIMARY | 8 | const,const,const | 0 | Unique row not found |
| 1 | SIMPLE | sigpic | const | PRIMARY | PRIMARY | 4 | const | 0 | Unique row not found |
| 1 | SIMPLE | modification | ALL | 19206 | Using where | ||||
| 1 | SIMPLE | licence | eq_ref | PRIMARY | PRIMARY | 4 | vbsupport_vborg.modification.mod_licence | 1 | Using where |
Time Before: 0.03880 seconds
Time After: 0.05590 seconds
Time Taken: 0.01710 seconds
Memory Before: 5,765.789 KB
Memory After: 5,838.555 KB
Memory Used: 72.766 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.05740 seconds
Time After: 0.05866 seconds
Time Taken: 0.00126 seconds
Memory Before: 2,125.977 KB
Memory After: 2,155.352 KB
Memory Used: 29.375 KB
UPDATE session SET lastactivity = 1736325423, location = '/showthread.php?explain=1&mode=hybrid&t=62849', inforum = 2, inthread = 62849 WHERE sessionhash = '87ac597c63704d3b9aa7c42999b3bbbd'
Time Before: 0.06134 seconds
Time After: 0.06151 seconds
Time Taken: 0.00017 seconds
Memory Before: 2,402.523 KB
Memory After: 2,402.445 KB
Memory Used: -0.078 KB
INSERT INTO threadviews (threadid) VALUES (62849)
Time Before: 0.06154 seconds
Time After: 0.06225 seconds
Time Taken: 0.00071 seconds
Memory Before: 2,400.117 KB
Memory After: 2,400.164 KB
Memory Used: 0.047 KB