Na0tyvu0

1EXPLAIN SELECT `time` , `vehicle_class` , `vehicle_speed` , `vehicle_lane` , `plate_confidence` , `plate_country`
2FROM `data_vehicles`
3WHERE `time`
4BETWEEN '2018-01-01'
5AND '2018-02-01'
6
7Shows
8
9id 	select_type 	table 	type 	possible_keys 	key 	key_len 	ref 	rows 	Extra
101 	SIMPLE 	data_vehicles 	ALL 	time,default 	NULL	NULL	NULL	5754714 	Using where
11
12CREATE TABLE IF NOT EXISTS `data_vehicles` (
13  `pid` int(11) NOT NULL AUTO_INCREMENT,
14  `id` varchar(127) COLLATE latin1_general_ci NOT NULL,
15  `time` datetime NOT NULL,
16  `place` varchar(127) COLLATE latin1_general_ci NOT NULL,
17  `vehicle_class` tinyint(3) NOT NULL,
18  `vehicle_speed` float NOT NULL,
19  `vehicle_lane` varchar(2) COLLATE latin1_general_ci NOT NULL,
20  `plate_confidence` int(3) NOT NULL,
21  `plate_country` varchar(3) COLLATE latin1_general_ci NOT NULL,
22  `plate_symbol` varchar(12) COLLATE latin1_general_ci NOT NULL,
23  `plate_checksum` varchar(127) COLLATE latin1_general_ci NOT NULL,
24  PRIMARY KEY (`pid`),
25  UNIQUE KEY `id` (`id`),
26  KEY `time` (`time`),
27  KEY `default` (`time`,`place`) COMMENT 'T'
28) ENGINE=InnoDB  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=9577748 ;