mysql关联另外一张表更新慢问题

update A set status = -3 where id in (
  select * from (
    select t.reg_id from (
      select reg.id reg_id,ref.id ref_id,ref.calc_at from A reg left join
      (
        select id,m_id,r_id,calc_at
        from B
        where calc_at  >= '2019-01-09' and calc_at  <  '2019-01-10'
      )ref
      on reg.r_id = ref.r_id and reg.m_id= ref.m_id
      where reg.status = 1
    )t where t.ref_id is null
  )tt
)

参考url：http://www.debugease.com/mssqlbasic/1614642.html