重现步骤
严重级别:一般
所属项目:CRM
问题原因:当前查询一次性查询数据量太多(20多万)(SELECT id,customer_id,platform,order_source_id,order_source_name,order_code,client_order_code,subject,client_message_time,message_create_time,return_reason,buyer_remark,email_exist,total_price,total_price_currency,refund_total,refund_total_currency,service_admin_id,service_admin_name,first_service_admin_id,first_service_admin_name,fba_service_admin_id,fba_service_admin_name,fbm_service_admin_id,fbm_service_admin_name,order_remark,remark,state,handler,handler_name,handler_time,ext_param,create_by,create_time,update_by,update_time,is_deleted,email,email_code FROM t_crm_return_order
WHERE (customer_id = 1 AND platform = 1) ORDER BY id ASC)
解决方案:建议分页查询(谨记避免深度分页问题)
问题原因:
授权退货,查询邮件关联的订单,没有判断订单号是否为空,导致查询了全表数据
解决方案:增加订单号是否为空判断,增加分页大小限制
