ALTER TABLE `syslog` ADD KEY `device_id-timestamp` (`device_id`,`timestamp`);