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