id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rbac_auth_assignment	NULL	ref	PRIMARY	PRIMARY	194	const	295	100	Using index; Using temporary; Using filesort; Start temporary
1	SIMPLE	user	NULL	eq_ref	PRIMARY,idx_user_profile_rating	PRIMARY	4	playtennis_dev.rbac_auth_assignment.user_id	1	5	Using where; End temporary