id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	tour_calendar	NULL	ref	tc_tour,tc_day	tc_tour	5	const	2	2.5	Using where; Using filesort