mybatis存储过程中第二update执行速度很慢导致，最终在存储过程中没有执行，求解决方案

Question

create procedure assignOrder(in userId BIGINT,in arrangBy BIGINT,in meg VARCHAR(1000),out count BIGINT)
begin

IF userId is not NULL and arrangBy is not NULL
THEN
UPDATE apply_flow as a set arrange_by = userId,remark=meg,response_by=userId where arrange_by=arrangBy
and id in( select b.id from apply_base b where a.id=b.id and b.status_no=1 );

update queue_resume_conversion set deal_by=userId where is_archive=1 and id in (
select conversion_id from apply_base base LEFT JOIN apply_flow flow on base.id=flow.id and base.status_no=1
where arrange_by=arrangBy);

set count=1;
ELSE
set count=0;
end IF;

SELECT count;
END

第二个update太慢的缘故还是，什么缘故，反正存储过程执行结果，但是第二个update没有任何效果

Answer 1

https://www.baidu.com/link?url=tZT6sZ1AfFZPdA58mVFS_JQ71WtnAQM2lVVE9ingcVokmVTm9HTTTeNBrxHvTPzmdbXuLk5Nvw4GDg_z2wRNAm7cESE5TuF7UmDzdO3uvjSxXfnkF3Z3BSSOLNJBSYSnCTQcOeewabpxuVRSX4zDP3GqUWce5pUnCf3vufA8zYG&wd=&eqid=c6d467e2000126f3000000055839ab86