Time Before: 0.04042 seconds
Time After: 0.05649 seconds
Time Taken: 0.01607 seconds
Memory Before: 2,925.695 KB
Memory After: 4,875.633 KB
Memory Used: 1,949.938 KB
Time Before: 0.05673 seconds
Time After: 0.05849 seconds
Time Taken: 0.00176 seconds
Memory Before: 4,878.227 KB
Memory After: 4,880.719 KB
Memory Used: 2.492 KB
SELECT *
FROM sw_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 | sw_datastore | range | PRIMARY | PRIMARY | 50 | 18 | Using where |
Time Before: 0.06082 seconds
Time After: 0.06644 seconds
Time Taken: 0.00562 seconds
Memory Before: 4,891.742 KB
Memory After: 4,891.844 KB
Memory Used: 0.102 KB
Time Before: 0.05919 seconds
Time After: 0.06823 seconds
Time Taken: 0.00904 seconds
Memory Before: 4,881.703 KB
Memory After: 5,320.344 KB
Memory Used: 438.641 KB
SELECT * FROM sw_session WHERE userid = 0 AND host = '172.16.247.5' AND idhash = '3352b39f30318a601a5970f1bf69768c' LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | sw_session | ALL | 249 | Using where |
Time Before: 0.08357 seconds
Time After: 0.08425 seconds
Time Taken: 0.00069 seconds
Memory Before: 5,814.320 KB
Memory After: 5,814.422 KB
Memory Used: 0.102 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_vbnexus AS phrasegroup_vbnexus, 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 sw_language WHERE languageid = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | sw_language | system | PRIMARY | 1 |
Time Before: 0.08589 seconds
Time After: 0.08723 seconds
Time Taken: 0.00134 seconds
Memory Before: 5,824.453 KB
Memory After: 5,823.688 KB
Memory Used: -0.766 KB
Time Before: 0.08250 seconds
Time After: 0.08780 seconds
Time Taken: 0.00530 seconds
Memory Before: 5,804.273 KB
Memory After: 5,877.203 KB
Memory Used: 72.930 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 sw_post AS post LEFT JOIN sw_editlog AS editlog ON (editlog.postid = post.postid) WHERE post.postid = 450
| 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.09249 seconds
Time After: 0.09298 seconds
Time Taken: 0.00049 seconds
Memory Before: 5,946.242 KB
Memory After: 5,946.344 KB
Memory Used: 0.102 KB
SELECT IF(visible = 2, 1, 0) AS isdeleted, thread.* FROM sw_thread AS thread WHERE thread.threadid = 153
| 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.09432 seconds
Time After: 0.09478 seconds
Time Taken: 0.00046 seconds
Memory Before: 5,950.672 KB
Memory After: 5,951.266 KB
Memory Used: 0.594 KB
SELECT * FROM sw_style WHERE (styleid = 1 AND userselect = 1) OR styleid = 1 ORDER BY styleid ASC LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | sw_style | const | PRIMARY | PRIMARY | 2 | const | 1 |
Time Before: 0.09593 seconds
Time After: 0.09672 seconds
Time Taken: 0.00080 seconds
Memory Before: 5,956.125 KB
Memory After: 5,956.711 KB
Memory Used: 0.586 KB
SELECT title, template FROM sw_template WHERE templateid IN (623,624,626,625,708,1114,740,741,743,750,749,908,923,909,910,912,911,914,916,917,918,920,922,646,648,650,652,950,952,955,956,953,951,1024,1025,902,901,903,907,905,1052,686,685,687,688,1135,1112,1118,621,620,622,617,616,893,844,845,846,847,1113,1116,1125,866,867,868,869,1067,1130,1129,1131,1134,1194)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | sw_template | range | PRIMARY | PRIMARY | 4 | 71 | Using where |
Time Before: 0.09887 seconds
Time After: 0.10099 seconds
Time Taken: 0.00212 seconds
Memory Before: 6,109.398 KB
Memory After: 6,109.500 KB
Memory Used: 0.102 KB
SELECT * FROM sw_superpm_users WHERE userid = '0'
| 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.10517 seconds
Time After: 0.10555 seconds
Time Taken: 0.00038 seconds
Memory Before: 6,254.898 KB
Memory After: 6,255.477 KB
Memory Used: 0.578 KB
UPDATE sw_session SET lastactivity = 1283756057, location = '/vbnexus/showthread.php?p=450&explain=1' WHERE sessionhash = '12f7869dc794008316cb1121188bc006'
Time Before: 0.12403 seconds
Time After: 0.12451 seconds
Time Taken: 0.00048 seconds
Memory Before: 6,824.875 KB
Memory After: 6,825.516 KB
Memory Used: 0.641 KB