1 11:04:22 SQL Prepare: ORACLE - select SF_SF_HQQFXX('2509612','06','20086196','','0',0,0) from dual 2 11:04:22 SQL Execute: ORACLE - select SF_SF_HQQFXX('2509612','06','20086196','','0',0,0) from dual 3 11:04:22 SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 4 11:04:22 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 5 11:04:22 SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL 6 11:04:22 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL 7 11:04:22 SQL Prepare: ORACLE - select count(*) from JY_YW0000 where JYYWID = '2063473' and JGZT00='0' 8 11:04:22 SQL Execute: ORACLE - select count(*) from JY_YW0000 where JYYWID = '2063473' and JGZT00='0' 9 11:04:22 SQL Prepare: ORACLE - select distinct a.YJDJH0,XMZT00,SL0000,b.YJKSBH from JY_YW0000 a,YJ_YW0000 b where a.YJDJH0=b.YJDJH0 and b.XMZT00 in ('0','1','2') and a.YJDJH0 = '20086196' 10 11:04:22 SQL Execute: ORACLE - select distinct a.YJDJH0,XMZT00,SL0000,b.YJKSBH from JY_YW0000 a,YJ_YW0000 b where a.YJDJH0=b.YJDJH0 and b.XMZT00 in ('0','1','2') and a.YJDJH0 = '20086196' 11 11:04:22 SQL Prepare: ORACLE - update JY_YW0000 set TXM000 = '0611225544', JGZT00 = '1', SFFS00 = '0', SGCJQZ = '01',BBCYRQ = '20200413',BBCYSJ = '11:08:58',BBCJR0 = '2360', BBCJL0 = '', BBSM00 = '',YXBZ00 = 'N',CJBZ00 = '' where JYYWID = '2063473' and JGZT00='0' 12 11:04:22 SQL Execute: ORACLE - update JY_YW0000 set TXM000 = '0611225544', JGZT00 = '1', SFFS00 = '0', SGCJQZ = '01',BBCYRQ = '20200413',BBCYSJ = '11:08:58',BBCJR0 = '2360', BBCJL0 = '', BBSM00 = '',YXBZ00 = 'N',CJBZ00 = '' where JYYWID = '2063473' and JGZT00='0' 13 11:04:22 SQL Data In: ORACLE - Rows affected = 1 14 11:04:22 SQL Prepare: ORACLE - Commit 15 11:04:22 SQL Execute: ORACLE - Commit 16 11:04:22 SQL Data In: ORACLE - Rows affected = 0 17 11:04:23 SQL Prepare: ORACLE - select SEQ_JY_YW0000_QDXH00.NEXTVAL QDXH00 from dual 18 11:04:23 SQL Execute: ORACLE - select SEQ_JY_YW0000_QDXH00.NEXTVAL QDXH00 from dual 19 11:04:23 SQL Prepare: ORACLE - select BRID00 from JY_YW0000 where MZZYBZ='0' and ZYHGHH='4112309' and rownum=1 20 11:04:23 SQL Execute: ORACLE - select BRID00 from JY_YW0000 where MZZYBZ='0' and ZYHGHH='4112309' and rownum=1 21 11:04:23 SQL Prepare: ORACLE - update JY_YW0000 set QDXH00='2353' where MZZYBZ='0' and jgzt00='1' and BRID00='2509612' and YJDJH0 in ('20086196') 22 11:04:23 SQL Execute: ORACLE - update JY_YW0000 set QDXH00='2353' where MZZYBZ='0' and jgzt00='1' and BRID00='2509612' and YJDJH0 in ('20086196') 23 11:04:23 SQL Data In: ORACLE - Rows affected = 1 24 11:04:23 SQL Prepare: ORACLE - commit 25 11:04:23 SQL Execute: ORACLE - commit 26 11:04:23 SQL Data In: ORACLE - Rows affected = 0 27 11:04:23 SQL Prepare: ORACLE - Select * From XT_YYXX00 where FLAG00 in ('0','1') order by FLAG00 desc 28 11:04:23 SQL Execute: ORACLE - Select * From XT_YYXX00 where FLAG00 in ('0','1') order by FLAG00 desc 29 11:04:23 SQL Prepare: ORACLE - select distinct MZZYBZ,ZYHGHH from JY_YW0000 where MZZYBZ='0' and JGZT00='1' and BRID00='2509612' and YJDJH0 in ('20086196') 30 11:04:23 SQL Execute: ORACLE - select distinct MZZYBZ,ZYHGHH from JY_YW0000 where MZZYBZ='0' and JGZT00='1' and BRID00='2509612' and YJDJH0 in ('20086196') 31 11:04:23 SQL Prepare: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_BQDYBGDZS' and rownum=1 32 11:04:23 SQL Execute: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_BQDYBGDZS' and rownum=1 33 11:04:23 SQL Prepare: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_JYJGCXDYCSCCSZSFTS' and rownum=1 34 11:04:23 SQL Execute: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_JYJGCXDYCSCCSZSFTS' and rownum=1 35 11:04:23 SQL Prepare: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_HZBRJYJG' and rownum=1 36 11:04:23 SQL Execute: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_HZBRJYJG' and rownum=1 37 11:04:23 SQL Prepare: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_JYJGCXKDYSSFASQKSCX' and rownum=1 38 11:04:23 SQL Execute: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_JYJGCXKDYSSFASQKSCX' and rownum=1 39 11:04:23 SQL Prepare: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_JYJGCXSFZYXDYBKS' and rownum=1 40 11:04:23 SQL Execute: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_JYJGCXSFZYXDYBKS' and rownum=1 41 11:04:23 SQL Prepare: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_SFCKDGDBZ' and rownum=1 42 11:04:23 SQL Execute: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_SFCKDGDBZ' and rownum=1 43 11:04:23 SQL Prepare: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_JYJGCXDHFZLXZ' and rownum=1 44 11:04:23 SQL Execute: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_JYJGCXDHFZLXZ' and rownum=1 45 11:04:23 SQL Prepare: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_A4SFDYZDYSTBG' and rownum=1 46 11:04:23 SQL Execute: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_A4SFDYZDYSTBG' and rownum=1 47 11:04:23 SQL Prepare: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_JYJGCXFJYXTSXSJ' and rownum=1 48 11:04:23 SQL Execute: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_JYJGCXFJYXTSXSJ' and rownum=1 49 11:04:23 SQL Prepare: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_JYJGCXSFCXGBRSYJYD' and rownum=1 50 11:04:23 SQL Execute: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_JYJGCXSFCXGBRSYJYD' and rownum=1 51 11:04:23 SQL Prepare: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_FJYTJKS_PRINT' and rownum=1 52 11:04:23 SQL Execute: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_FJYTJKS_PRINT' and rownum=1 53 11:04:23 SQL Prepare: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_JYDYSFDYFCJG' and rownum=1 54 11:04:23 SQL Execute: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_JYDYSFDYFCJG' and rownum=1 55 11:04:23 SQL Prepare: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_JYBGDYSTSFCYGCTQNR' and rownum=1 56 11:04:23 SQL Execute: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_JYBGDYSTSFCYGCTQNR' and rownum=1 57 11:04:23 SQL Prepare: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_JGCLDYYLBDYSFGXZT' and rownum=1 58 11:04:23 SQL Execute: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_JGCLDYYLBDYSFGXZT' and rownum=1 59 11:04:23 SQL Prepare: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_LISDYDYCSSFJY' and rownum=1 60 11:04:23 SQL Execute: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_LISDYDYCSSFJY' and rownum=1 61 11:04:23 SQL Prepare: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_BGDYJLFS' and rownum=1 62 11:04:23 SQL Execute: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_BGDYJLFS' and rownum=1 63 11:04:23 SQL Prepare: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_DYJSZBCFS' and rownum=1 64 11:04:23 SQL Execute: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_DYJSZBCFS' and rownum=1 65 11:04:23 SQL Prepare: ORACLE - select VALUE0 from XT_YHCS00 where NAME00='JYBGDPRT' and YGBH00 = '2360' 66 11:04:23 SQL Execute: ORACLE - select VALUE0 from XT_YHCS00 where NAME00='JYBGDPRT' and YGBH00 = '2360' 67 11:04:23 SQL Prepare: ORACLE - select VALUE0 from XT_YHCS00 where NAME00='JYHZDPRT' and YGBH00 = '2360' 68 11:04:23 SQL Execute: ORACLE - select VALUE0 from XT_YHCS00 where NAME00='JYHZDPRT' and YGBH00 = '2360' 69 11:04:23 SQL Prepare: ORACLE - select VALUE0 from XT_YHCS00 where NAME00='JYZLXMPRT' and YGBH00 = '2360' 70 11:04:23 SQL Execute: ORACLE - select VALUE0 from XT_YHCS00 where NAME00='JYZLXMPRT' and YGBH00 = '2360' 71 11:04:23 SQL Prepare: ORACLE - select BRID00 from jy_yw0000 where MZZYBZ='0' and ZYHGHH='4112309' and rownum=1 72 11:04:23 SQL Execute: ORACLE - select BRID00 from jy_yw0000 where MZZYBZ='0' and ZYHGHH='4112309' and rownum=1 73 11:04:23 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 74 11:04:23 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 75 11:04:23 SQL Prepare: ORACLE - select DISTINCT MZZYBZ,ZYHGHH from JY_YW0000 where MZZYBZ='0' and jgzt00='1' and BRID00='2509612' and YJDJH0 in ('20086196') 76 11:04:23 SQL Execute: ORACLE - select DISTINCT MZZYBZ,ZYHGHH from JY_YW0000 where MZZYBZ='0' and jgzt00='1' and BRID00='2509612' and YJDJH0 in ('20086196') 77 11:04:23 SQL Prepare: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_BQDYBGDZS' and rownum=1 78 11:04:23 SQL Execute: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_BQDYBGDZS' and rownum=1 79 11:04:23 SQL Prepare: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_JYJGCXDYCSCCSZSFTS' and rownum=1 80 11:04:23 SQL Execute: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_JYJGCXDYCSCCSZSFTS' and rownum=1 81 11:04:23 SQL Prepare: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_HZBRJYJG' and rownum=1 82 11:04:23 SQL Execute: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_HZBRJYJG' and rownum=1 83 11:04:23 SQL Prepare: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_JYJGCXKDYSSFASQKSCX' and rownum=1 84 11:04:23 SQL Execute: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_JYJGCXKDYSSFASQKSCX' and rownum=1 85 11:04:23 SQL Prepare: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_JYJGCXSFZYXDYBKS' and rownum=1 86 11:04:23 SQL Execute: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_JYJGCXSFZYXDYBKS' and rownum=1 87 11:04:23 SQL Prepare: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_SFCKDGDBZ' and rownum=1 88 11:04:23 SQL Execute: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_SFCKDGDBZ' and rownum=1 89 11:04:23 SQL Prepare: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_JYJGCXDHFZLXZ' and rownum=1 90 11:04:23 SQL Execute: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_JYJGCXDHFZLXZ' and rownum=1 91 11:04:23 SQL Prepare: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_A4SFDYZDYSTBG' and rownum=1 92 11:04:23 SQL Execute: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_A4SFDYZDYSTBG' and rownum=1 93 11:04:23 SQL Prepare: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_JYJGCXFJYXTSXSJ' and rownum=1 94 11:04:23 SQL Execute: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_JYJGCXFJYXTSXSJ' and rownum=1 95 11:04:23 SQL Prepare: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_JYJGCXSFCXGBRSYJYD' and rownum=1 96 11:04:23 SQL Execute: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_JYJGCXSFCXGBRSYJYD' and rownum=1 97 11:04:23 SQL Prepare: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_FJYTJKS_PRINT' and rownum=1 98 11:04:23 SQL Execute: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_FJYTJKS_PRINT' and rownum=1 99 11:04:23 SQL Prepare: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_JYDYSFDYFCJG' and rownum=1 100 11:04:23 SQL Execute: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_JYDYSFDYFCJG' and rownum=1 101 11:04:23 SQL Prepare: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_JYBGDYSTSFCYGCTQNR' and rownum=1 102 11:04:23 SQL Execute: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_JYBGDYSTSFCYGCTQNR' and rownum=1 103 11:04:23 SQL Prepare: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_JGCLDYYLBDYSFGXZT' and rownum=1 104 11:04:23 SQL Execute: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_JGCLDYYLBDYSFGXZT' and rownum=1 105 11:04:23 SQL Prepare: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_LISDYDYCSSFJY' and rownum=1 106 11:04:23 SQL Execute: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_LISDYDYCSSFJY' and rownum=1 107 11:04:23 SQL Prepare: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_BGDYJLFS' and rownum=1 108 11:04:23 SQL Execute: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_BGDYJLFS' and rownum=1 109 11:04:23 SQL Prepare: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_DYJSZBCFS' and rownum=1 110 11:04:23 SQL Execute: ORACLE - select nvl(VALUE0,'0') from XT_XTCS00 where NAME00 = 'JY_DYJSZBCFS' and rownum=1 111 11:04:23 SQL Prepare: ORACLE - select VALUE0 from XT_YHCS00 where NAME00='JYBGDPRT' and YGBH00 = '2360' 112 11:04:23 SQL Execute: ORACLE - select VALUE0 from XT_YHCS00 where NAME00='JYBGDPRT' and YGBH00 = '2360' 113 11:04:23 SQL Prepare: ORACLE - select VALUE0 from XT_YHCS00 where NAME00='JYHZDPRT' and YGBH00 = '2360' 114 11:04:23 SQL Execute: ORACLE - select VALUE0 from XT_YHCS00 where NAME00='JYHZDPRT' and YGBH00 = '2360' 115 11:04:23 SQL Prepare: ORACLE - select VALUE0 from XT_YHCS00 where NAME00='JYZLXMPRT' and YGBH00 = '2360' 116 11:04:23 SQL Execute: ORACLE - select VALUE0 from XT_YHCS00 where NAME00='JYZLXMPRT' and YGBH00 = '2360' 117 11:04:23 SQL Prepare: ORACLE - select distinct '泉州医学高等专科学校附属人民医院检验诊疗项目信息' YYMC00,ZYHGHH,BRXM00,XB0000, BRID00,NL0000,ZLXMZH,CBGRQ0,CBGSJ0,BG0000 from VW_JY_YW0000 a where ZYHGHH=:1 and MZZYBZ=:2 and YJDJH0 in ('20086196') order by ZYHGHH 118 11:04:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4112309 119 11:04:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 120 11:04:23 SQL Execute: ORACLE - select distinct '泉州医学高等专科学校附属人民医院检验诊疗项目信息' YYMC00,ZYHGHH,BRXM00,XB0000, BRID00,NL0000,ZLXMZH,CBGRQ0,CBGSJ0,BG0000 from VW_JY_YW0000 a where ZYHGHH=? and MZZYBZ=? and YJDJH0 in ('20086196') order by ZYHGHH 121 11:04:23 SQL Prepare: ORACLE - select distinct CJRXM0, (select XKH000 from BM_YGBM00 where YGBH00=a.bbcjr0 and rownum=1) CJRXKH, ZYZBID,ZLXMJC,BBMC00,TXM000,SFJE00, to_char(SYSDATE,'YYYY-MM-DD HH24:MI') CJRQSJ, ZLXMZH,CBGRQ0,CBGSJ0,BG0000 from VW_JY_YW0000 a where ZYHGHH=:1 and MZZYBZ=:2 and YJDJH0 in ('20086196') order by ZYZBID 122 11:04:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4112309 123 11:04:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 124 11:04:23 SQL Execute: ORACLE - select distinct CJRXM0, (select XKH000 from BM_YGBM00 where YGBH00=a.bbcjr0 and rownum=1) CJRXKH, ZYZBID,ZLXMJC,BBMC00,TXM000,SFJE00, to_char(SYSDATE,'YYYY-MM-DD HH24:MI') CJRQSJ, ZLXMZH,CBGRQ0,CBGSJ0,BG0000 from VW_JY_YW0000 a where ZYHGHH=? and MZZYBZ=? and YJDJH0 in ('20086196') order by ZYZBID