1 09:54:01 Log started for: 健康体检系统 2 09:54:04 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12985665 and KSBH00=151 and ZLXMID=16105 and YJDJH0=16278903 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 3 09:54:04 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12985665 and KSBH00=151 and ZLXMID=16105 and YJDJH0=16278903 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 4 09:54:04 SQL Prepare: ORACLE - select count(*) from TJ_PACSJG where ghid00=12985665 and KSBH00=151 and ZLXMID=16105 and YJDJH0=16278903 and JCRQ00 IS NOT NULL and rownum=1 5 09:54:04 SQL Execute: ORACLE - select count(*) from TJ_PACSJG where ghid00=12985665 and KSBH00=151 and ZLXMID=16105 and YJDJH0=16278903 and JCRQ00 IS NOT NULL and rownum=1 6 09:54:04 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12985665 and KSBH00=46 and ZLXMID=22589 and YJDJH0=16278910 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 7 09:54:04 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12985665 and KSBH00=46 and ZLXMID=22589 and YJDJH0=16278910 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 8 09:54:09 SQL Prepare: ORACLE - SELECT DWID00 FROM TJ_BRXXB0 WHERE GHID00 = (SELECT GHID00 FROM SF_BRXXB0 WHERE GHH000 = '6504156' AND ROWNUM = 1) 9 09:54:09 SQL Execute: ORACLE - SELECT DWID00 FROM TJ_BRXXB0 WHERE GHID00 = (SELECT GHID00 FROM SF_BRXXB0 WHERE GHH000 = '6504156' AND ROWNUM = 1) 10 09:54:09 SQL Prepare: ORACLE - SELECT TRIM(YYID00) FROM BM_TYDWB0 WHERE DWID00 = '596' 11 09:54:09 SQL Execute: ORACLE - SELECT TRIM(YYID00) FROM BM_TYDWB0 WHERE DWID00 = '596' 12 09:54:09 SQL Prepare: ORACLE - select a.ghid00 from tj_brxxb0 a,sf_brxxb0 b where a.grghid=b.ghid00 and b.ghh000='6504156' 13 09:54:09 SQL Execute: ORACLE - select a.ghid00 from tj_brxxb0 a,sf_brxxb0 b where a.grghid=b.ghid00 and b.ghh000='6504156' 14 09:54:09 SQL Prepare: ORACLE - SELECT * FROM VW_TJ_BRXXB0 WHERE GHID00>0 AND GHID00=(select ghid00 from sf_brxxb0 where ghh000='6504156') 15 09:54:09 SQL Execute: ORACLE - SELECT * FROM VW_TJ_BRXXB0 WHERE GHID00>0 AND GHID00=(select ghid00 from sf_brxxb0 where ghh000='6504156') 16 09:54:09 SQL Prepare: ORACLE - select GRGHID from TJ_BRXXB0 where GHID00=12985665 17 09:54:09 SQL Execute: ORACLE - select GRGHID from TJ_BRXXB0 where GHID00=12985665 18 09:54:09 SQL Prepare: ORACLE - SELECT TRIM(NVL(LQQK00,'')) FROM TJ_BRXXB0 WHERE GHID00 = '12985665' 19 09:54:09 SQL Execute: ORACLE - SELECT TRIM(NVL(LQQK00,'')) FROM TJ_BRXXB0 WHERE GHID00 = '12985665' 20 09:54:09 SQL Prepare: ORACLE - select ephoto from bm_brxxb0 where brid00='3686132' 21 09:54:09 SQL Execute: ORACLE - select ephoto from bm_brxxb0 where brid00='3686132' 22 09:54:09 SQL Prepare: ORACLE - BEGIN "SP_TJ_INSTJ_TJBG00" (PGHID00 => :PGHID00,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PYYID00 => :PYYID00); END; 23 09:54:09 SQL Data In: ORACLE - Param = 1, Name = PGHID00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 12985665 24 09:54:09 SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1143.000000 25 09:54:09 SQL Data In: ORACLE - Param = 3, Name = PCZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 杨家秀 26 09:54:09 SQL Data In: ORACLE - Param = 4, Name = PYYID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 222137 27 09:54:09 SQL Execute: ORACLE - BEGIN "SP_TJ_INSTJ_TJBG00" (PGHID00 => :PGHID00,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PYYID00 => :PYYID00); END; 28 09:54:09 SQL Prepare: ORACLE - select lpad(ksbh00,5,' ')||zlxmid ksxmid,zlxmid,nvl(yjdjh0,0) yjdjh0, ksbh00,zlxmjc,xh0000,lbbh00,bgys00,CKSBH0,YYID00 ,KSLX00, JGHQFS from ( select mc0000 zlxmjc,a.ksbh00,xh0000,0 zlxmid,0 yjdjh0, DECODE(LX0000,'2','4','0') lbbh00,a.bgys00,A.CKSBH0, B.YYID00, KSLX00, NULL JGHQFS from tj_kslb00 a, (select distinct ksbh00,zlxmid,yjdjh0, (SELECT YYID00 FROM TJ_ZHXM00 WHERE ZLXMID = D.ZLXMID AND ROWNUM = 1 AND BH0000 = D.KSBH00) YYID00, (SELECT LX0000 FROM TJ_KSLB00 where KSBH00 = D.KSBH00) KSLX00 from tj_tjbg00 D where ghid00=12985665) b where a.ksbh00=b.ksbh00 union select zlxmjc zlxmjc,b.ksbh00,c.xh0000,a.zlxmid,b.yjdjh0, TO_CHAR(a.lbbh00) LBBH00,c.bgys00,C.CKSBH0, B.YYID00, KSLX00, JGHQFS from bm_zlzd00 a,tj_kslb00 c, (select distinct ksbh00,zlxmid,yjdjh0, (SELECT YYID00 FROM TJ_ZHXM00 WHERE ZLXMID = E.ZLXMID AND ROWNUM = 1 AND BH0000 = E.KSBH00) YYID00, (SELECT LX0000 FROM TJ_KSLB00 where KSBH00 = E.KSBH00) KSLX00, (SELECT JGHQFS FROM TJ_ZHXM00 WHERE ZLXMID = E.ZLXMID AND BH0000 = E.KSBH00) JGHQFS from tj_tjbg00 E where ghid00=12985665) b where a.zlxmid=b.zlxmid and b.ksbh00=c.ksbh00 AND A.ZLXMID IN (SELECT ZLXMID FROM TJ_ZHXM00 WHERE SFYX00 = 'Y') ) where 1=1 AND YYID00 = '222137' order by xh0000,ksbh00,zlxmid, yjdjh0 29 09:54:09 SQL Execute: ORACLE - select lpad(ksbh00,5,' ')||zlxmid ksxmid,zlxmid,nvl(yjdjh0,0) yjdjh0, ksbh00,zlxmjc,xh0000,lbbh00,bgys00,CKSBH0,YYID00 ,KSLX00, JGHQFS from ( select mc0000 zlxmjc,a.ksbh00,xh0000,0 zlxmid,0 yjdjh0, DECODE(LX0000,'2','4','0') lbbh00,a.bgys00,A.CKSBH0, B.YYID00, KSLX00, NULL JGHQFS from tj_kslb00 a, (select distinct ksbh00,zlxmid,yjdjh0, (SELECT YYID00 FROM TJ_ZHXM00 WHERE ZLXMID = D.ZLXMID AND ROWNUM = 1 AND BH0000 = D.KSBH00) YYID00, (SELECT LX0000 FROM TJ_KSLB00 where KSBH00 = D.KSBH00) KSLX00 from tj_tjbg00 D where ghid00=12985665) b where a.ksbh00=b.ksbh00 union select zlxmjc zlxmjc,b.ksbh00,c.xh0000,a.zlxmid,b.yjdjh0, TO_CHAR(a.lbbh00) LBBH00,c.bgys00,C.CKSBH0, B.YYID00, KSLX00, JGHQFS from bm_zlzd00 a,tj_kslb00 c, (select distinct ksbh00,zlxmid,yjdjh0, (SELECT YYID00 FROM TJ_ZHXM00 WHERE ZLXMID = E.ZLXMID AND ROWNUM = 1 AND BH0000 = E.KSBH00) YYID00, (SELECT LX0000 FROM TJ_KSLB00 where KSBH00 = E.KSBH00) KSLX00, (SELECT JGHQFS FROM TJ_ZHXM00 WHERE ZLXMID = E.ZLXMID AND BH0000 = E.KSBH00) JGHQFS from tj_tjbg00 E where ghid00=12985665) b where a.zlxmid=b.zlxmid and b.ksbh00=c.ksbh00 AND A.ZLXMID IN (SELECT ZLXMID FROM TJ_ZHXM00 WHERE SFYX00 = 'Y') ) where 1=1 AND YYID00 = '222137' order by xh0000,ksbh00,zlxmid, yjdjh0 30 09:54:09 SQL Prepare: ORACLE - select GHID00,TJJL00,TJJY00,ZJYS00,ZJYSXM,BGRQ00,FCRQ00,CZY000,CZYXM0,TJSGJL from VW_TJ_BRXXB0 where GHID00='12985665' 31 09:54:09 SQL Execute: ORACLE - select GHID00,TJJL00,TJJY00,ZJYS00,ZJYSXM,BGRQ00,FCRQ00,CZY000,CZYXM0,TJSGJL from VW_TJ_BRXXB0 where GHID00='12985665' 32 09:54:09 SQL Prepare: ORACLE - SELECT "ID0000", "DWID00", "BRID00", "GHID00", "GHH000", "ICD900", "JBMC00", "JY0000", "SFDDDY" FROM "VW_TJ_TJJYB0" WHERE ((("DWID00") = ('596')) AND (("BRID00") = ('3686132'))) AND (("GHID00") = ('12985665')) 33 09:54:09 SQL Execute: ORACLE - SELECT "ID0000", "DWID00", "BRID00", "GHID00", "GHH000", "ICD900", "JBMC00", "JY0000", "SFDDDY" FROM "VW_TJ_TJJYB0" WHERE ((("DWID00") = ('596')) AND (("BRID00") = ('3686132'))) AND (("GHID00") = ('12985665')) 34 09:54:09 SQL Prepare: ORACLE - select JYJZKS,(select BMMC00 from BM_BMBM00 where BMBH00=JYJZKS) JYKSMC, JYJZYS,(select ZWXM00 from BM_YGBM00 where YGBH00=JYJZYS) JYYSXM, JYKS01,(select BMMC00 from BM_BMBM00 where BMBH00=JYKS01) JYMC01, JYYS01,(select ZWXM00 from BM_YGBM00 where YGBH00=JYYS01) JYXM01, JYKS02,(select BMMC00 from BM_BMBM00 where BMBH00=JYKS02) JYMC02, JYYS02,(select ZWXM00 from BM_YGBM00 where YGBH00=JYYS02) JYXM02, JYKS03,(select BMMC00 from BM_BMBM00 where BMBH00=JYKS03) JYMC03, JYYS03,(select ZWXM00 from BM_YGBM00 where YGBH00=JYYS03) JYXM03, JYKS04,(select BMMC00 from BM_BMBM00 where BMBH00=JYKS04) JYMC04, JYYS04,(select ZWXM00 from BM_YGBM00 where YGBH00=JYYS04) JYXM04 from TJ_BRXXB0 a where GHID00='12985665' 35 09:54:09 SQL Execute: ORACLE - select JYJZKS,(select BMMC00 from BM_BMBM00 where BMBH00=JYJZKS) JYKSMC, JYJZYS,(select ZWXM00 from BM_YGBM00 where YGBH00=JYJZYS) JYYSXM, JYKS01,(select BMMC00 from BM_BMBM00 where BMBH00=JYKS01) JYMC01, JYYS01,(select ZWXM00 from BM_YGBM00 where YGBH00=JYYS01) JYXM01, JYKS02,(select BMMC00 from BM_BMBM00 where BMBH00=JYKS02) JYMC02, JYYS02,(select ZWXM00 from BM_YGBM00 where YGBH00=JYYS02) JYXM02, JYKS03,(select BMMC00 from BM_BMBM00 where BMBH00=JYKS03) JYMC03, JYYS03,(select ZWXM00 from BM_YGBM00 where YGBH00=JYYS03) JYXM03, JYKS04,(select BMMC00 from BM_BMBM00 where BMBH00=JYKS04) JYMC04, JYYS04,(select ZWXM00 from BM_YGBM00 where YGBH00=JYYS04) JYXM04 from TJ_BRXXB0 a where GHID00='12985665' 36 09:54:09 SQL Prepare: ORACLE - select * from TJ_JKZJG0 where ghid00=12985665 37 09:54:09 SQL Execute: ORACLE - select * from TJ_JKZJG0 where ghid00=12985665 38 09:54:09 SQL Prepare: ORACLE - SELECT C.* FROM ( select yjdjh0,yjfzh0,a.zlxmid,b.zlxmjc,b.lbbh00,xmzt00,SL0000,YJKSBH, DECODE(XMZT00,'0','已申请','1','已计价','2','已收费','3','已执行', '6','已作废','7','已退费','D','已取消') XMZTMC, (SELECT YYID00 FROM TJ_ZHXM00 WHERE ZLXMID = A.ZLXMID AND ROWNUM = 1 AND BH0000 = A.YJKSBH) YYID00 from TJ_YJDJH0 a,bm_zlzd00 b where a.zlxmid=b.zlxmid and xmzt00 in('0','1','2','6','D') and (not exists (select 'y' from yj_yw0000 c where c.cxdjh0=a.yjdjh0)) and ((a.cxdjh0=0) or (a.cxdjh0 is null)) and (ghid00='12985665' or ghid00='') ) C WHERE YYID00 = '222137' 39 09:54:09 SQL Execute: ORACLE - SELECT C.* FROM ( select yjdjh0,yjfzh0,a.zlxmid,b.zlxmjc,b.lbbh00,xmzt00,SL0000,YJKSBH, DECODE(XMZT00,'0','已申请','1','已计价','2','已收费','3','已执行', '6','已作废','7','已退费','D','已取消') XMZTMC, (SELECT YYID00 FROM TJ_ZHXM00 WHERE ZLXMID = A.ZLXMID AND ROWNUM = 1 AND BH0000 = A.YJKSBH) YYID00 from TJ_YJDJH0 a,bm_zlzd00 b where a.zlxmid=b.zlxmid and xmzt00 in('0','1','2','6','D') and (not exists (select 'y' from yj_yw0000 c where c.cxdjh0=a.yjdjh0)) and ((a.cxdjh0=0) or (a.cxdjh0 is null)) and (ghid00='12985665' or ghid00='') ) C WHERE YYID00 = '222137' 40 09:54:09 SQL Prepare: ORACLE - select * from TJ_PACSJG where GHID00='12985665' and KSBH00='151' and YJDJH0 ='0' and ZLXMID='0' 41 09:54:09 SQL Execute: ORACLE - select * from TJ_PACSJG where GHID00='12985665' and KSBH00='151' and YJDJH0 ='0' and ZLXMID='0' 42 09:54:09 SQL Prepare: ORACLE - select TJURL0 from BM_ZLZD00 a,BM_JCLB00 b where a.JCLBID=b.JCLBID and TJURL0 is not null and a.ZLXMID='0' 43 09:54:09 SQL Execute: ORACLE - select TJURL0 from BM_ZLZD00 a,BM_JCLB00 b where a.JCLBID=b.JCLBID and TJURL0 is not null and a.ZLXMID='0' 44 09:54:09 SQL Prepare: ORACLE - delete from TJ_PACSPIC where GHID00='12985665' and KSBH00='151' and ZLXMID='0' 45 09:54:09 SQL Execute: ORACLE - delete from TJ_PACSPIC where GHID00='12985665' and KSBH00='151' and ZLXMID='0' 46 09:54:09 SQL Data In: ORACLE - Rows affected = 0 47 09:54:09 SQL Prepare: ORACLE - delete from TJ_PACSJGLJ where GHID00='12985665' and KSBH00='151' and ZLXMID='0' 48 09:54:09 SQL Execute: ORACLE - delete from TJ_PACSJGLJ where GHID00='12985665' and KSBH00='151' and ZLXMID='0' 49 09:54:09 SQL Data In: ORACLE - Rows affected = 0 50 09:54:09 SQL Prepare: ORACLE - COMMIT 51 09:54:09 SQL Execute: ORACLE - COMMIT 52 09:54:09 SQL Data In: ORACLE - Rows affected = 0 53 09:54:09 SQL Prepare: ORACLE - select ICD900,JBMC00,JY0000 from TJ_TJBGCF where GHID00='12985665' and ksbh00='151' order by JBMC00 54 09:54:09 SQL Execute: ORACLE - select ICD900,JBMC00,JY0000 from TJ_TJBGCF where GHID00='12985665' and ksbh00='151' order by JBMC00 55 09:54:09 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12985665 and KSBH00=151 and ZLXMID=16105 and YJDJH0=16278903 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 56 09:54:09 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12985665 and KSBH00=151 and ZLXMID=16105 and YJDJH0=16278903 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 57 09:54:09 SQL Prepare: ORACLE - select count(*) from TJ_PACSJG where ghid00=12985665 and KSBH00=151 and ZLXMID=16105 and YJDJH0=16278903 and JCRQ00 IS NOT NULL and rownum=1 58 09:54:09 SQL Execute: ORACLE - select count(*) from TJ_PACSJG where ghid00=12985665 and KSBH00=151 and ZLXMID=16105 and YJDJH0=16278903 and JCRQ00 IS NOT NULL and rownum=1 59 09:54:09 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12985665 and KSBH00=46 and ZLXMID=22589 and YJDJH0=16278910 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 60 09:54:09 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12985665 and KSBH00=46 and ZLXMID=22589 and YJDJH0=16278910 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 61 09:54:12 SQL Prepare: ORACLE - select * from ( select SJLX00,BGID00,XSSX00,A.ZLXMID,A.YJDJH0,A.JCXMID,XXZ000,SXZ000,XXTS00,SXTS00,CKZ000,JCRQ00,SFCSTS,XMMC00,CDZ000,DW0000,JGSM00,JCYS00,JCYSXM,B.XH0000 ZLXMXH,SFJRXJ,CDMS00,ICD900,JBMC00,A.SFDY00 from VW_TJ_TJBG00_DIS A,TJ_ZHXM00 B where A.ZLXMID=B.ZLXMID AND GHID00='12985665' and A.KSBH00='46' and A.YJDJH0='16278910' and A.ZLXMID='22589' AND A.KSBH00=B.BH0000 UNION select 'C' SJLX00,0 BGID00,0 XSSX00,A.ZLXMID,C.YJDJH0,0 JCXMID,0 XXZ000,0 SXZ000,'' XXTS00,'' SXTS00,'' CKZ000,C.JCRQ00,'' SFCSTS,B.ZLXMJC XMMC00,'' CDZ000,'' DW0000,'' JGSM00,C.JCYS00,C.JCYSXM,A.XH0000 ZLXMXH,'N' SFJRXJ,'' CDMS00,'' ICD900,'' JBMC00,'N' SFDY00 from TJ_ZHXM00 A,BM_ZLZD00 B,VW_TJ_TJBG00_DIS C WHERE C.GHID00='12985665' and C.KSBH00='46' and C.YJDJH0='16278910' and C.ZLXMID='22589' and A.ZLXMID=B.ZLXMID AND A.ZLXMID=C.ZLXMID and A.BH0000=C.KSBH00 and ((exists(select 1 from tj_tjbg00 where ghid00=c.ghid00 and zlxmid=c.zlxmid and ksbh00=c.ksbh00 and yjdjh0=c.yjdjh0 and jcys00 is not null) and jcys00 is not null) or (not exists(select 1 from tj_tjbg00 where ghid00=c.ghid00 and zlxmid=c.zlxmid and ksbh00=c.ksbh00 and yjdjh0=c.yjdjh0 and jcys00 is not null) and jcys00 is null)) )order by ZLXMXH,ZLXMID,XSSX00 62 09:54:12 SQL Execute: ORACLE - select * from ( select SJLX00,BGID00,XSSX00,A.ZLXMID,A.YJDJH0,A.JCXMID,XXZ000,SXZ000,XXTS00,SXTS00,CKZ000,JCRQ00,SFCSTS,XMMC00,CDZ000,DW0000,JGSM00,JCYS00,JCYSXM,B.XH0000 ZLXMXH,SFJRXJ,CDMS00,ICD900,JBMC00,A.SFDY00 from VW_TJ_TJBG00_DIS A,TJ_ZHXM00 B where A.ZLXMID=B.ZLXMID AND GHID00='12985665' and A.KSBH00='46' and A.YJDJH0='16278910' and A.ZLXMID='22589' AND A.KSBH00=B.BH0000 UNION select 'C' SJLX00,0 BGID00,0 XSSX00,A.ZLXMID,C.YJDJH0,0 JCXMID,0 XXZ000,0 SXZ000,'' XXTS00,'' SXTS00,'' CKZ000,C.JCRQ00,'' SFCSTS,B.ZLXMJC XMMC00,'' CDZ000,'' DW0000,'' JGSM00,C.JCYS00,C.JCYSXM,A.XH0000 ZLXMXH,'N' SFJRXJ,'' CDMS00,'' ICD900,'' JBMC00,'N' SFDY00 from TJ_ZHXM00 A,BM_ZLZD00 B,VW_TJ_TJBG00_DIS C WHERE C.GHID00='12985665' and C.KSBH00='46' and C.YJDJH0='16278910' and C.ZLXMID='22589' and A.ZLXMID=B.ZLXMID AND A.ZLXMID=C.ZLXMID and A.BH0000=C.KSBH00 and ((exists(select 1 from tj_tjbg00 where ghid00=c.ghid00 and zlxmid=c.zlxmid and ksbh00=c.ksbh00 and yjdjh0=c.yjdjh0 and jcys00 is not null) and jcys00 is not null) or (not exists(select 1 from tj_tjbg00 where ghid00=c.ghid00 and zlxmid=c.zlxmid and ksbh00=c.ksbh00 and yjdjh0=c.yjdjh0 and jcys00 is not null) and jcys00 is null)) )order by ZLXMXH,ZLXMID,XSSX00 63 09:54:12 SQL Prepare: ORACLE - select * from TJ_TJXJB0 where GHID00='12985665' and KSBH00='46' and SFDDDY='N' 64 09:54:12 SQL Execute: ORACLE - select * from TJ_TJXJB0 where GHID00='12985665' and KSBH00='46' and SFDDDY='N' 65 09:54:12 SQL Prepare: ORACLE - select ICD900,JBMC00,JY0000 from TJ_TJBGCF where GHID00='12985665' and ksbh00='46' order by ID0000 66 09:54:12 SQL Execute: ORACLE - select ICD900,JBMC00,JY0000 from TJ_TJBGCF where GHID00='12985665' and ksbh00='46' order by ID0000 67 09:54:12 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12985665 and KSBH00=46 and ZLXMID=22589 and YJDJH0=16278910 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 68 09:54:12 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12985665 and KSBH00=46 and ZLXMID=22589 and YJDJH0=16278910 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 69 09:54:12 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12985665 and KSBH00=151 and ZLXMID=16105 and YJDJH0=16278903 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 70 09:54:12 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12985665 and KSBH00=151 and ZLXMID=16105 and YJDJH0=16278903 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 71 09:54:12 SQL Prepare: ORACLE - select count(*) from TJ_PACSJG where ghid00=12985665 and KSBH00=151 and ZLXMID=16105 and YJDJH0=16278903 and JCRQ00 IS NOT NULL and rownum=1 72 09:54:12 SQL Execute: ORACLE - select count(*) from TJ_PACSJG where ghid00=12985665 and KSBH00=151 and ZLXMID=16105 and YJDJH0=16278903 and JCRQ00 IS NOT NULL and rownum=1 73 09:54:12 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12985665 and KSBH00=46 and ZLXMID=22589 and YJDJH0=16278910 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 74 09:54:12 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12985665 and KSBH00=46 and ZLXMID=22589 and YJDJH0=16278910 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 75 09:54:15 SQL Prepare: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12985665 and KSBH00=46 and ZLXMID=22589 and YJDJH0=16278910 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 76 09:54:15 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=12985665 and KSBH00=46 and ZLXMID=22589 and YJDJH0=16278910 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999