Zeug

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