id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	tour	NULL	range	PRIMARY,many_days	PRIMARY	4	NULL	74	5	Using where; Using filesort