update sys_ycl_local_skill s1
set xhsl = (
  with tp1 as (
  select t2.md005,
  (select count(1) from sys_yclbom t4 where t4.s_barcode = t3.bc_code) num,
  t3.bc_code
  from sys_cx_model_mach t1
  join sys_ggbom t2 on t1.wlxx_id = t2.md007 and t1.flag = t2.flag
  join sys_ycl_local_skill t3 on t1.sbid = t3.sbid and t3.yclid = t2.md001
  where t1.sbid = 67)
  select md005*num from tp1 where s1.bc_code = tp1.bc_code
)
where s1.sbid = 67;