【问题描述(我做了什么)】
目前我这个集群上就跑这一个sql,没有其他业务,表结构以及sql如图,帮忙看看可以在优化嘛
SELECT id,vin,sn,file_key,convert_file_key,md5,secret_key,account_id,convert_status,fail_reason,collect_time,convert_time,callback_time,receive_time FROM veh_can_message_file ORDER BY id DESC LIMIT 5000000, 1 ;
SELECT id,vin,sn,file_key,convert_file_key,md5,secret_key,account_id,convert_status,fail_reason,collect_time,convert_time,callback_time,receive_time FROM veh_can_message_file ORDER BY id DESC LIMIT 5000000, 1;