1 16:27:20 SQL Prepare: ORACLE - select b.* from zy_brfy00 a,zy_fymx00 b where a.zyid00=:1 and a.djh000=b.djh000 and (b.XMBH00 < 9999999990 or b.JMBZ00 <> 0) and b.kdks00=:2 2 16:27:20 SQL Execute: ORACLE - select b.* from zy_brfy00 a,zy_fymx00 b where a.zyid00=? and a.djh000=b.djh000 and (b.XMBH00 < 9999999990 or b.JMBZ00 <> 0) and b.kdks00=? 3 16:27:20 SQL Prepare: ORACLE - select (select ypbm00 from bm_yd0000 where ypnm00=b.ypnm00) ypbm00, b.ypmc00,b.ypgg00,b.lsdj00,b.cfdw00,b.ypzsl0,b.lsdj00*b.ypzsl0 je0000,a.ysxm00, (select zwxm00 from bm_ygbm00 where ygbh00=a.fyr000) fyrxm0,a.jzrq00||' '||a.jzsj00 jzrqsj from yf_zycf00 a,yf_zycfmx b where a.zyid00=:1 and a.dqks00=:2 and a.cflsh0=b.cflsh0 and a.cfzt00 not in('0','3') 4 16:27:20 SQL Execute: ORACLE - select (select ypbm00 from bm_yd0000 where ypnm00=b.ypnm00) ypbm00, b.ypmc00,b.ypgg00,b.lsdj00,b.cfdw00,b.ypzsl0,b.lsdj00*b.ypzsl0 je0000,a.ysxm00, (select zwxm00 from bm_ygbm00 where ygbh00=a.fyr000) fyrxm0,a.jzrq00||' '||a.jzsj00 jzrqsj from yf_zycf00 a,yf_zycfmx b where a.zyid00=? and a.dqks00=? and a.cflsh0=b.cflsh0 and a.cfzt00 not in('0','3') 5 16:27:20 SQL Prepare: ORACLE - select a.*,rpad(trim(SF_SS_YWMX00_ZLXMJC(a.ssdh00)),120) ssmc0m, (select yshsxm from SS_YSHSXX where SSDH00=a.SSDH00 and YSHSLB='手术助手1' ) SSZS01, (select yshsxm from SS_YSHSXX where SSDH00=a.SSDH00 and YSHSLB='手术助手2' ) SSZS02, (select yshsxm from SS_YSHSXX where SSDH00=a.SSDH00 and YSHSLB='手术助手3' ) SSZS03, (select yshsxm from SS_YSHSXX where SSDH00=a.SSDH00 and YSHSLB='手术助手4' ) SSZS04, (select sum(c.zje000) from SS_YW0000 d,SS_SSYJD0 b,YJ_YW0000 c where d.ssdh00=b.ssdh00 and b.yjdjh0=c.yjdjh0 and d.ssdh00=a.ssdh00 and c.XMZT00 IN ('2','3','5','4') and exists(select * from ss_ywmx00 where ssdh00=d.ssdh00 and ssbh00=c.zlxmid)) SSFY01, (select sum(hjje00) from (select b.hjje00,e.zyid00 zyghid,b.kdks00 from zy_brfy00 e,zy_fymx00 b,BM_YYSFXM c,BM_FPXM00 d where e.djh000=b.djh000 and (b.XMBH00 < 9999999990 or b.JMBZ00 <> 0) and b.xmbh00=c.sfxmid and c.mzfpid=d.fpxmid and d.BH0000=11 union all select b.hjje00,e.mzid00 zyghid,b.kdks00 from sf_brfy00 e,sf_fymx00 b,BM_YYSFXM c,BM_FPXM00 d where e.djh000=b.djh000 and ( b.XMBH00 < 9999999990 or b.JMBZ00 <> 0) and b.xmbh00=c.sfxmid and c.mzfpid=d.fpxmid and d.BH0000=11) where zyghid=a.zyghid and kdks00=a.SSKS00) SSF000 from vw_ss_yw0000 a where 1=1 and a.sqrq00 between :1 and :2 and a.SSZT00 in ('0','1','2','3','4') order by SSRQSJ 6 16:27:20 SQL Execute: ORACLE - select a.*,rpad(trim(SF_SS_YWMX00_ZLXMJC(a.ssdh00)),120) ssmc0m, (select yshsxm from SS_YSHSXX where SSDH00=a.SSDH00 and YSHSLB='手术助手1' ) SSZS01, (select yshsxm from SS_YSHSXX where SSDH00=a.SSDH00 and YSHSLB='手术助手2' ) SSZS02, (select yshsxm from SS_YSHSXX where SSDH00=a.SSDH00 and YSHSLB='手术助手3' ) SSZS03, (select yshsxm from SS_YSHSXX where SSDH00=a.SSDH00 and YSHSLB='手术助手4' ) SSZS04, (select sum(c.zje000) from SS_YW0000 d,SS_SSYJD0 b,YJ_YW0000 c where d.ssdh00=b.ssdh00 and b.yjdjh0=c.yjdjh0 and d.ssdh00=a.ssdh00 and c.XMZT00 IN ('2','3','5','4') and exists(select * from ss_ywmx00 where ssdh00=d.ssdh00 and ssbh00=c.zlxmid)) SSFY01, (select sum(hjje00) from (select b.hjje00,e.zyid00 zyghid,b.kdks00 from zy_brfy00 e,zy_fymx00 b,BM_YYSFXM c,BM_FPXM00 d where e.djh000=b.djh000 and (b.XMBH00 < 9999999990 or b.JMBZ00 <> 0) and b.xmbh00=c.sfxmid and c.mzfpid=d.fpxmid and d.BH0000=11 union all select b.hjje00,e.mzid00 zyghid,b.kdks00 from sf_brfy00 e,sf_fymx00 b,BM_YYSFXM c,BM_FPXM00 d where e.djh000=b.djh000 and ( b.XMBH00 < 9999999990 or b.JMBZ00 <> 0) and b.xmbh00=c.sfxmid and c.mzfpid=d.fpxmid and d.BH0000=11) where zyghid=a.zyghid and kdks00=a.SSKS00) SSF000 from vw_ss_yw0000 a where 1=1 and a.sqrq00 between ? and ? and a.SSZT00 in ('0','1','2','3','4') order by SSRQSJ 7 16:27:22 SQL Prepare: ORACLE - select b.* from zy_brfy00 a,zy_fymx00 b where a.zyid00=:1 and a.djh000=b.djh000 and (b.XMBH00 < 9999999990 or b.JMBZ00 <> 0) and b.kdks00=:2 8 16:27:22 SQL Execute: ORACLE - select b.* from zy_brfy00 a,zy_fymx00 b where a.zyid00=? and a.djh000=b.djh000 and (b.XMBH00 < 9999999990 or b.JMBZ00 <> 0) and b.kdks00=? 9 16:27:22 SQL Prepare: ORACLE - select (select ypbm00 from bm_yd0000 where ypnm00=b.ypnm00) ypbm00, b.ypmc00,b.ypgg00,b.lsdj00,b.cfdw00,b.ypzsl0,b.lsdj00*b.ypzsl0 je0000,a.ysxm00, (select zwxm00 from bm_ygbm00 where ygbh00=a.fyr000) fyrxm0,a.jzrq00||' '||a.jzsj00 jzrqsj from yf_zycf00 a,yf_zycfmx b where a.zyid00=:1 and a.dqks00=:2 and a.cflsh0=b.cflsh0 and a.cfzt00 not in('0','3') 10 16:27:22 SQL Execute: ORACLE - select (select ypbm00 from bm_yd0000 where ypnm00=b.ypnm00) ypbm00, b.ypmc00,b.ypgg00,b.lsdj00,b.cfdw00,b.ypzsl0,b.lsdj00*b.ypzsl0 je0000,a.ysxm00, (select zwxm00 from bm_ygbm00 where ygbh00=a.fyr000) fyrxm0,a.jzrq00||' '||a.jzsj00 jzrqsj from yf_zycf00 a,yf_zycfmx b where a.zyid00=? and a.dqks00=? and a.cflsh0=b.cflsh0 and a.cfzt00 not in('0','3') 11 16:27:22 SQL Prepare: ORACLE - select b.* from zy_brfy00 a,zy_fymx00 b where a.zyid00=:1 and a.djh000=b.djh000 and (b.XMBH00 < 9999999990 or b.JMBZ00 <> 0) and b.kdks00=:2 12 16:27:22 SQL Execute: ORACLE - select b.* from zy_brfy00 a,zy_fymx00 b where a.zyid00=? and a.djh000=b.djh000 and (b.XMBH00 < 9999999990 or b.JMBZ00 <> 0) and b.kdks00=? 13 16:27:22 SQL Prepare: ORACLE - select (select ypbm00 from bm_yd0000 where ypnm00=b.ypnm00) ypbm00, b.ypmc00,b.ypgg00,b.lsdj00,b.cfdw00,b.ypzsl0,b.lsdj00*b.ypzsl0 je0000,a.ysxm00, (select zwxm00 from bm_ygbm00 where ygbh00=a.fyr000) fyrxm0,a.jzrq00||' '||a.jzsj00 jzrqsj from yf_zycf00 a,yf_zycfmx b where a.zyid00=:1 and a.dqks00=:2 and a.cflsh0=b.cflsh0 and a.cfzt00 not in('0','3') 14 16:27:22 SQL Execute: ORACLE - select (select ypbm00 from bm_yd0000 where ypnm00=b.ypnm00) ypbm00, b.ypmc00,b.ypgg00,b.lsdj00,b.cfdw00,b.ypzsl0,b.lsdj00*b.ypzsl0 je0000,a.ysxm00, (select zwxm00 from bm_ygbm00 where ygbh00=a.fyr000) fyrxm0,a.jzrq00||' '||a.jzsj00 jzrqsj from yf_zycf00 a,yf_zycfmx b where a.zyid00=? and a.dqks00=? and a.cflsh0=b.cflsh0 and a.cfzt00 not in('0','3')