id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE schedules range idspectacle_2, date idspectacle_2 8 9 Using index condition; Using where