• slow sql 19438 millis. SELECT id,case_info_id,regist_no,claim_status,case_status,org_name,org_code,policy_no,bi_policy_no,ci_policy_no,report_time,report_type,delegate_mode,informant,informant_phone,linker_name,linker_phone,damage_time,damage_place,damage_province,damage_city,damage_district,damage_lng,damage_lat,damage_remark,damage_reason,damage_reason_code,survey_time,survey_place,fence_id,survey_lat,survey_lng,is_lock,lock_user_code,license_no,is_appoint,appoint_time,insured_name,insured_phone,vip_level,driver_name,driver_phone,is_history,is_auto_dispatch,insurance_type,dispatch_time,remark,channel_code,channel_name,create_by,create_time,update_by,update_time,case_type,is_proxy,fence_name,fence_org_code,fence_org_name,actual_org_code,actual_org_name,car_type,damage_type_code,damage_type_name,damage_num,seat_code,seat_name,agent_code,third_party_name,third_party_mobile,dispatch_fail_code,dispatch_fail_desc,subrogation,video_user,video_user_name,sponsor_type,is_auto_video_flag,forecast_case_no,is_new_policy_flag,is_black_list,black_list_type,black_list_type_desc,is_yzt,judge_charging,vin,black_list_spcustnme,black_list_insurednme,black_list_empcnm,black_list_empmobile,deal_type,has_commit_video,policy_hold_name,security_type,security_no,insured_addr,ressignment_flag FROM dd_case_info

WHERE (ressignment_flag = ?) ORDER BY report_time DESC LIMIT ?["1",10]