id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	major	NULL	ref	major_confirmStatusIndex	major_confirmStatusIndex	2	const	1	5.00	Using where