索引生效:
EXPLAIN SELECT id, car_no, car_type, pic_url, duty_peo, tel_no, cap_type, cap_time, present_time, create_time FROM car_pass_record WHERE create_time > CURDATE()
不生效:
EXPLAIN SELECT id, car_no, car_type, pic_url, duty_peo, tel_no, cap_type, cap_time, present_time, create_time FROM car_pass_record WHERE DATE(create_time) = CURDATE()