Slow query in mysql 5.7.20

[Murawweh Daher]

Hi All,

The below query take 58 second and that long time for such data. i created indexes but still no enhancement on data fetching time.

are there any suggestions?

explain SELECT count(adjustmentamount) totalRefill , DATE(airtimestamp) FROM air_drs a ,sdp_drs b
where b.ISDUPLICATED='1' and VOUCHERBASEDR='0' and REFILLPROFILEID='7'
and UPPER (a.extdata1) IN ('ADD', 'D_ADD') and upper(a.AIRRECORDTYPE)='REFILL'
and a.accounteventid = b.accounteventid group by DATE(airtimestamp)


1 SIMPLE b ref accounteventid,isduplicated isduplicated 5 const 2162416 100.00 Using where; Using temporary; Using filesort
1 SIMPLE a eq_ref PRIMARY,accounteventid_UNIQUE,accounteventid,airtimestamp,voucherbasedr PRIMARY 302 jndr_sch.b.accounteventid 1 5.00 Using where



Thanks.