id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	<subquery4>	NULL	ALL	NULL	NULL	NULL	NULL	NULL	100.00	Using temporary; Using filesort
1	PRIMARY	blog	NULL	eq_ref	PRIMARY	PRIMARY	4	<subquery4>.BlogID	1	10.00	Using where
1	PRIMARY	nut_posts	NULL	ALL	NULL	NULL	NULL	NULL	3234	1.00	Using where; Using join buffer (hash join)
4	MATERIALIZED	nut_blogs_subscribe	NULL	ref	UserID	UserID	5	const	1	100.00	NULL
3	DEPENDENT SUBQUERY	nut_posts_likes	NULL	ref	PostID	PostID	10	bombardirdb.nut_posts.PostID,const	2	100.00	Using index
2	DEPENDENT SUBQUERY	nut_posts_likes	NULL	ref	PostID	PostID	10	bombardirdb.nut_posts.PostID,const	2	100.00	Using index