Time Before: 0.01366 seconds
Time After: 0.03623 seconds
Time Taken: 0.02256 seconds
Memory Before: 1,482.305 KB
Memory After: 2,662.063 KB
Memory Used: 1,179.758 KB
Time Before: 0.03636 seconds
Time After: 0.03661 seconds
Time Taken: 0.00025 seconds
Memory Before: 2,662.793 KB
Memory After: 2,664.520 KB
Memory Used: 1.727 KB
SET @@sql_mode = ''
Time Before: 0.03687 seconds
Time After: 0.03697 seconds
Time Taken: 0.00010 seconds
Memory Before: 2,663.449 KB
Memory After: 2,664.145 KB
Memory Used: 0.695 KB
SELECT *
FROM Club_datastore
WHERE title IN ('iconcache','noavatarperms','smiliecache','bbcodecache','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache')| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | Club_datastore | range | PRIMARY | PRIMARY | 50 | 17 | Using where |
Time Before: 0.03799 seconds
Time After: 0.08813 seconds
Time Taken: 0.05014 seconds
Memory Before: 2,666.191 KB
Memory After: 2,666.578 KB
Memory Used: 0.387 KB
Time Before: 0.03705 seconds
Time After: 0.09593 seconds
Time Taken: 0.05889 seconds
Memory Before: 2,662.957 KB
Memory After: 4,105.348 KB
Memory Used: 1,442.391 KB
SELECT * FROM Club_session WHERE sessionhash = '29041270d2e48d07cd04f31e16e7d637' AND lastactivity > 1284054572 AND idhash = 'd0b63444099757fedc3d79aa837e804c'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | Club_session | const | PRIMARY,guest_lookup | PRIMARY | 32 | const | 1 |
Time Before: 0.09819 seconds
Time After: 0.09929 seconds
Time Taken: 0.00110 seconds
Memory Before: 4,139.230 KB
Memory After: 4,139.719 KB
Memory Used: 0.488 KB
SELECT languageid, phrasegroup_global AS phrasegroup_global, phrasegroup_user AS phrasegroup_user, phrasegroup_infractionlevel AS phrasegroup_infractionlevel, 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 Club_language WHERE languageid = 3
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | Club_language | const | PRIMARY | PRIMARY | 2 | const | 1 |
Time Before: 0.10154 seconds
Time After: 0.11267 seconds
Time Taken: 0.01113 seconds
Memory Before: 4,146.219 KB
Memory After: 4,146.172 KB
Memory Used: -0.047 KB
Time Before: 0.09724 seconds
Time After: 0.11298 seconds
Time Taken: 0.01574 seconds
Memory Before: 4,135.133 KB
Memory After: 4,269.402 KB
Memory Used: 134.270 KB
SELECT * FROM Club_style WHERE (styleid = 6 AND userselect = 1) OR styleid = 6 ORDER BY styleid ASC LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | Club_style | const | PRIMARY | PRIMARY | 2 | const | 1 |
Time Before: 0.15978 seconds
Time After: 0.17026 seconds
Time Taken: 0.01048 seconds
Memory Before: 4,801.371 KB
Memory After: 4,801.902 KB
Memory Used: 0.531 KB
SELECT title, template FROM Club_template WHERE templateid IN (7623,7615,7620,5771,7225,7224,5716,7226,7232,7233,7234,7235,7228,7231,7230,7217,7406,7407,7408,7622,7638,7621,0,7619,7618,7515,7523,7524,7683,7673,7684,8009,0,0,7092,7086,5842,7090,7091,5845,7088,7413,7697,7359,7360,7361,7362,7676,7677,7678,7682,7699,7382,7383,7385,7386,7614,7717,7716,7718,7721,7206,7205,7209,5847,2925,2936,2937,2938,2940,2941,2939,5751,7810,0,7811,7812,7849,5891,7908,2797,2798,2886,0,2889,2890,2891,2892,2893,2898,2900,5892,2847,2848,2850,2851,2852,2853,2854,2855,2856,2857,2858,2859,2860,2861,2862,2863,2864,2865,2866,2867,2868,2849,2870,2871,2869,2879,2880,5433,5434,4041,5890,5887,5888,5333,5334,5335,5336,5337)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | Club_template | range | PRIMARY | PRIMARY | 4 | 126 | Using where |
Time Before: 0.17632 seconds
Time After: 0.19369 seconds
Time Taken: 0.01737 seconds
Memory Before: 5,419.172 KB
Memory After: 5,419.148 KB
Memory Used: -0.023 KB
SELECT MAX(permissions & 1) AS perm FROM Club_cms_permissions WHERE nodeid = 1 AND usergroupid in (1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | Club_cms_permissions | ref | nodeid | nodeid | 4 | const | 14 | Using where |
Time Before: 0.20518 seconds
Time After: 0.20537 seconds
Time Taken: 0.00019 seconds
Memory Before: 5,850.863 KB
Memory After: 5,851.430 KB
Memory Used: 0.566 KB
SELECT template FROM Club_template WHERE templateid = 2846
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | Club_template | const | PRIMARY | PRIMARY | 4 | const | 1 |
Time Before: 0.20819 seconds
Time After: 0.20836 seconds
Time Taken: 0.00017 seconds
Memory Before: 5,789.656 KB
Memory After: 5,790.250 KB
Memory Used: 0.594 KB
SELECT user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline, customavatar.width, customavatar.height, customavatar.width_thumb, customavatar.height_thumb FROM Club_user AS user LEFT JOIN Club_avatar AS avatar ON avatar.avatarid = user.avatarid LEFT JOIN Club_customavatar AS customavatar ON customavatar.userid = user.userid WHERE user.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.21394 seconds
Time After: 0.21426 seconds
Time Taken: 0.00032 seconds
Memory Before: 6,012.988 KB
Memory After: 6,013.246 KB
Memory Used: 0.258 KB
SELECT userip FROM Club_vsavilxh_guests AS vsavilxh_guests WHERE userip = '38.107.191.84'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | vsavilxh_guests | ALL | 50 | Using where |
Time Before: 0.21866 seconds
Time After: 0.21916 seconds
Time Taken: 0.00050 seconds
Memory Before: 6,130.270 KB
Memory After: 6,130.828 KB
Memory Used: 0.559 KB
UPDATE Club_vsavilxh_guests SET dateline = '1284055472' WHERE userip = '38.107.191.84'
Time Before: 0.21931 seconds
Time After: 0.22225 seconds
Time Taken: 0.00294 seconds
Memory Before: 6,130.457 KB
Memory After: 6,130.957 KB
Memory Used: 0.500 KB
DELETE FROM Club_vsavilxh_guests WHERE dateline < '1283969072'
Time Before: 0.22236 seconds
Time After: 0.22254 seconds
Time Taken: 0.00018 seconds
Memory Before: 6,130.031 KB
Memory After: 6,130.570 KB
Memory Used: 0.539 KB
SELECT text, languageid, special FROM Club_phrase AS phrase LEFT JOIN Club_phrasetype USING (fieldname) WHERE phrase.fieldname = 'error' AND varname = 'nopermission_loggedout' AND languageid IN (-1, 0, 3)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phrase | range | name_lang_type,languageid | name_lang_type | 276 | 3 | Using where | |
| 1 | SIMPLE | Club_phrasetype | const | PRIMARY | PRIMARY | 20 | const | 1 |
Time Before: 0.23025 seconds
Time After: 0.23054 seconds
Time Taken: 0.00028 seconds
Memory Before: 6,246.789 KB
Memory After: 6,247.238 KB
Memory Used: 0.449 KB
UPDATE Club_session SET lastactivity = 1284055472, location = '/usercp.php?explain=1', inforum = 0, inthread = 0, badlocation = 1, bypass = 0 WHERE sessionhash = '29041270d2e48d07cd04f31e16e7d637'
Time Before: 0.25530 seconds
Time After: 0.25578 seconds
Time Taken: 0.00047 seconds
Memory Before: 6,570.684 KB
Memory After: 6,571.078 KB
Memory Used: 0.395 KB