1       08:57:21  SQL Execute: ORACLE - Select SYSDATE from Dual

2       08:57:21  SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH'

3       08:57:21  SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'SLE4442'
and KLDH00 not in ('CK','JMCK')

4       08:57:22  SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'YB-FZYB'
and KLDH00 not in ('CK','JMCK')

5       08:57:22  SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'YB-SBK'
and KLDH00 not in ('CK','JMCK')

6       08:57:23  SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00
where ICKH00 = 'FZYBA99166977'
and ICKNBH = 'FZYBA99166977'

7       08:57:23  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 银医通共享平台
8       08:57:23  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = payopen
9       08:57:23  SQL Execute: ORACLE -  select SF_SF_TYZD00(?,?)FHJG00 from dual

10      08:57:23  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = FZYBA99166977
11      08:57:23  SQL Execute: ORACLE - select SF_SF_GETBRID(?)FHJG00  from dual

12      08:57:23  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 601750.000000
13      08:57:23  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
14      08:57:23  SQL Execute: ORACLE -  select SF_SF_ZHDJZT(?,?)FHJG00 from dual

15      08:57:23  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = FZYBA99166977
16      08:57:23  SQL Execute: ORACLE - select SF_SF_GETBRID(?)FHJG00  from dual

17      08:57:23  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 601750.000000
18      08:57:23  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
19      08:57:23  SQL Execute: ORACLE -  select SF_SF_ZHDJZT(?,?)FHJG00 from dual

20      08:57:23  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = FZYBA99166977
21      08:57:23  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1000
22      08:57:23  SQL Execute: ORACLE -  select SF_SF_YYTOPEN(?,?)FHJG00 from dual

23      08:57:23  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = FZYBA99166977
24      08:57:23  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2001
25      08:57:23  SQL Execute: ORACLE -  select SF_SF_YYTOPEN(?,?)FHJG00 from dual

26      08:57:23  SQL Execute: ORACLE - Select a.BRXB00,a.BRCSRQ,a.BRJTDZ,SF_SF_CSRQTONL(trim(a.BRCSRQ)) BRNL,a.BRXM00,a.BRDH00,a.BRID00,
a.KYJE00,a.BRZJBH,a.BRLXDH 
 from vw_ys_brxxb0 a where a.brid00=601750 

27      08:57:23  SQL Execute: ORACLE - Select To_date('19800511','YYYY.MM.DD') from dual

28      08:57:23  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 601750
29      08:57:23  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 黄代民
30      08:57:23  SQL Execute: ORACLE - select a.*,decode(a.BRID00,0,'Y','N') FLAG00,decode(a.BRID00,0,'未对应','已对应') DYBZ00,
 (select SCKBH0 from BM_CKDY00 where DCKBH0=a.GHHZCK and rownum=1) FZCKBH 
,ceil((to_date(TO_char(sysdate, 'YYYYMMDD HH24:MI:SS'),'YYYYMMDD HH24:MI:SS')-to_date(YYRQ00||YYJSSJ,'YYYYMMDD HH24:MI:SS'))* 24 * 60) YYCDSJ 
, nvl((select TZBZ00 from SF_YSGHHB where GHHBID=a.GHHBID and rownum=1),'0') TZBZ00,YYQYZM,YYQH01,a.YYYGBH 
   from vw_yy_bryyxxcx a where 1=1 
 and (a.BRID00=? or a.BRXM00=?) 
 and a.YYRQ00=to_char(sysdate, 'YYYYMMDD') and ((a.YYJSSJ>'12:00:00' and to_char(sysdate, 'HH24:MI:SS')>'12:00:00' ) or (a.YYJSSJ<='12:00:00' and to_char(sysdate, 'HH24:MI:SS')<='12:00:00' ) )
 and a.YYZT00 in ('0','1')