CREATE TABLE `statistic_prolonged` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `action` varchar(50) NOT NULL,
  `param` varchar(50) NOT NULL,
  `params` longtext,
  `device_id` int(11) NOT NULL,
  `date_end` datetime NOT NULL,
  `date_start` datetime NOT NULL,
  `duration` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `statistic_prolonged_9379346c` (`device_id`),
  KEY `statistic_prolonged_date_end_16701f89db4c810d` (`date_end`),
  KEY `statistic_prolonged_date_start_7a0cf9cf82ebf68a` (`date_start`)
) ENGINE=MyISAM AUTO_INCREMENT=25406353 DEFAULT CHARSET=utf8;

SELECT `statistic_prolonged`.`device_id`, COUNT(*) AS `total`
FROM `statistic_prolonged`
WHERE YEAR(`statistic_prolonged`.`date_start`) = 2017
GROUP BY `statistic_prolonged`.`device_id`

EXPLAIN SELECT `statistic_prolonged`.`device_id`, COUNT(*) AS `total`
FROM `statistic_prolonged`
WHERE `statistic_prolonged`.`date_start` >= '2017-01-01' 
  AND `statistic_prolonged`.`date_start` < '2018-01-01' 
GROUP BY `statistic_prolonged`.`device_id`