查询 park_charge_info 表
该表记录 40W+条 ，但是我在查询中却十分缓慢，需要10秒+
如下是我的sql语句：
SELECT
a.parking_type,
a.exit_type,
SUM(a.charge) charge,
SUM(a.realcharge) realcharge
FROM
(
SELECT parking_type,exit_type,charge,realcharge FROM park_charge_info WHERE
record_time BETWEEN '2013-12-04 00:00:00' AND '2016-12-13 14:30:14'
AND devicecode IN ('3702020101','3702020102','3700009103','3700009104',
'3700009105','3700009102','3700009178','3700009180','3700009179','3700098010','3700098011','3700098012','3700098013','3700098014', '3700098015',
'3700098016','3700098017','3700098018','3700098019')
) a
GROUP BY a.exit_type,a.parking_type ;
如下是我的这个表的sql 表及数据：
