Super simple mysql query taking too long
Create a compound index as follows:

ALTER TABLE autorepair ADD INDEX specialty_zipcode_ndx (specialty,zipcode);


and drop the single column specialty index

ALTER TABLE autorepair DROP INDEX specialty;