数据库根据时间字段查询优化
mysql数据库
SELECT sw_id FROM link_update_record WHERE create_time BETWEEN '2020-2-1 00:00:00' AND '2020-2-12 23:59:59';
将时间字段比较值改成时间格式
select sw_id from link_update_record where create_time between str_to_date('2020-2-1 00:00:00', '%Y-%m-%d %H:%i:%s') and str_to_date('2020-2-12 23:59:59', '%Y-%m-%d %H:%i:%s');