id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	tournaments_has_profiles	NULL	index_merge	PRIMARY,idx_tournaments_has_profiles_stage_id	idx_tournaments_has_profiles_stage_id,PRIMARY	9,4	NULL	1	100	Using intersect(idx_tournaments_has_profiles_stage_id,PRIMARY); Using where; Using filesort