MySQL优化日期优化

MySQL优化：

1：日期优化：
原：SELECT count(id) as count,SUM(trade_money) as money FROM trade_data_vo WHERE date_format(pay_time,'%Y-%m-%d')>=date_format(:startTime,'%Y-%m-%d') AND date_format(pay_time,'%Y-%m-%d')<=date_format(:endTime,'%Y-%m-%d')
优化后：select count(id) AS count, SUM(trade_money) AS money from trade_data_vo u where pay_time BETWEEN '2021-09-25 00:00:00' and '2021-09-25 16:29:11';