id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY newsfeed ALL user_id,type NULL NULL NULL 32371 Using where; Using filesort 2 DEPENDENT SUBQUERY user_goals index_subquery user_id,user_id_2 user_id_2 5 func 13 Using index; Using where 3 DEPENDENT SUBQUERY user_goals range user_id,user_id_2,goal_id user_id 5 NULL 13 Using where; Using index