6PvJA3s6

1SELECT `id`,`totaldistance` FROM `alltrackers` WHERE `deviceid`='FT_99000083426364' AND (`gpsdatetime` BETWEEN 1341100800 AND 1342483200) ORDER BY `id` DESC LIMIT 1
2	
3CREATE TABLE IF NOT EXISTS `alltrackers` (
4  `id` int(11) NOT NULL AUTO_INCREMENT,
5  `deviceid` varchar(50) NOT NULL,
6  `lat` double NOT NULL,
7  `long` double NOT NULL,
8  `gpsdatetime` int(11) NOT NULL,
9  `version` int(11) DEFAULT NULL,
10  `totaldistance` int(11) NOT NULL DEFAULT '0',
11  `distanceprocessed` tinyint(1) NOT NULL DEFAULT '0',
12  PRIMARY KEY (`id`),
13  UNIQUE KEY `id_deviceid` (`id`,`deviceid`),
14  UNIQUE KEY `deviceid_id` (`deviceid`,`id`),
15  KEY `deviceid` (`deviceid`),
16  KEY `deviceid_gpsdatetime` (`deviceid`,`gpsdatetime`),
17  KEY `gpsdatetime_deviceid` (`gpsdatetime`,`deviceid`),
18  KEY `gpsdatetime` (`gpsdatetime`),
19  KEY `id_deviceid_gpsdatetime` (`id`,`deviceid`,`gpsdatetime`)
20) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=677242 ;
21	
22id  select_type  table  type  possible_keys  key  key_len  ref  rows  Extra  
231 SIMPLE alltrackers index deviceid_id,deviceid,deviceid_gpsdatetime,gpsdatet... PRIMARY 4 NULL 677238 Using where