mysql>  explain select * FROM data WHERE uid = '12589' AND timestamp < unix_timestamp('2007-03-01') AND DAY = '03' AND MONTH = '09' AND year = 2007 AND id != '1' AND ip != 'S';
+----+-------------+-----------+-------+-------------------------+---------+---------+------+-------+-------------+
| id | select_type | table     | type  | possible_keys           | key     | key_len | ref  | rows  | Extra       |
+----+-------------+-----------+-------+-------------------------+---------+---------+------+-------+-------------+
|  1 | SIMPLE      | data | range | PRIMARY,uidtime,idx_uid | uidtime |       8 | NULL | 65334 | Using where |
+----+-------------+-----------+-------+-------------------------+---------+---------+------+-------+-------------+
1 row in set (0.00 sec)