id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	extra
1	SIMPLE	cities	NULL	range	PRIMARY,code	PRIMARY	14	NULL	31	100.00	Using where