id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	blog_posts	NULL	ref	idx-blog_posts-category_id	idx-blog_posts-category_id	4	const	23	100.00	Using index condition; Using filesort