SELECT id, member_id, running_time, location, member_group FROM ibf_sessions WHERE id='62fc0e2d0790f7674a0a6c7e7d6351b0' AND ip_address='38.107.191.96' | |||||||
| table | type | possible_keys | key | key_len | ref | rows | Extra |
| Impossible WHERE noticed after reading const tables | |||||||
| 0.00131 | |||||||
| DELETE FROM ibf_sessions WHERE running_time < 1283880664 or ip_address='38.107.191.96' or id='62fc0e2d0790f7674a0a6c7e7d6351b0' |
| 0.00054 |
| INSERT INTO ibf_sessions (id, member_name, member_id, ip_address, browser, running_time, location, login_type, member_group) VALUES ('34e352db588cfc049120050036e16b90', '', 0, '38.107.191.96', 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)', 1283884264, ',,', 0, 2) |
| 0.00070 |
SELECT * FROM ibf_groups WHERE g_id=2 | |||||||
| table | type | possible_keys | key | key_len | ref | rows | Extra |
| ibf_groups | ref | PRIMARY | PRIMARY | 2 | const | 1 | |
| 0.00059 (New cache) | |||||||
SELECT s.uid, s.sname, s.sid, s.set_id, s.tmpl_id, s.macro_id, s.css_id, s.img_dir, s.hidden, s.default_set, t.template FROM ibf_skins s LEFT JOIN ibf_templates t ON (t.tmid=s.tmpl_id) WHERE s.default_set=1 | |||||||
| table | type | possible_keys | key | key_len | ref | rows | Extra |
| s | ref | default_set | default_set | 1 | const | 1 | |
| t | eq_ref | PRIMARY | PRIMARY | 4 | d60339128.s.tmpl_id | 1 | |
| 0.00209 (New cache) | |||||||
SELECT macro_value, macro_replace FROM ibf_macro WHERE macro_set=5 | |||||||
| table | type | possible_keys | key | key_len | ref | rows | Extra |
| ibf_macro | ref | macro_set | macro_set | 2 | const | 94 | |
| 0.00085 | |||||||