id select_type table type possible_keys key key_len ref rows Extra ------ ----------- --------- ------ ------------- ------ ------- ------ ------ ------------------------------- 1 SIMPLE stEvents ALL (NULL) (NULL) (NULL) (NULL) 3958 Using temporary; Using filesort 1 SIMPLE stRatings ALL (NULL) (NULL) (NULL) (NULL) 78 Using where 1 SIMPLE stSimilar ALL (NULL) (NULL) (NULL) (NULL) 21576 Using where 1 SIMPLE stZipData ALL (NULL) (NULL) (NULL) (NULL) 42741 Using where