id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	NULL	NULL	NULL	NULL	NULL	NULL	NULL	No tables used
2	SUBQUERY	post_tag_assn	ref	PRIMARY,tag_id,post_id	tag_id	4	const	8	Using index
2	SUBQUERY	post	eq_ref	PRIMARY,idx-post-type,idx-post-is_public	PRIMARY	4	bsr.post_tag_assn.post_id	1	Using where