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