1       15:31:57  SQL Execute: ORACLE - select userenv('SESSIONID') JCID00 from dual 

2       15:31:57  SQL Execute: ORACLE - select (select VALUE0 from XT_XTCS00 where NAME00='XT_XNDK') VALUE0,SF_BM_SQXQTSXX('XT_XNDK','0',1,'20385804') TSXX00   from dual 

3       15:31:57  SQL Execute: ORACLE - Select SYSDATE from Dual

4       15:31:57  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')

5       15:31:57  SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00
where ICKH00 = 'PTYBB20064917'
and ICKNBH = 'PTYBB20064917'

6       15:31:57  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 28, Scale = 0, Data = 福建诊疗失信人员信息字典参数
7       15:31:57  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 11, Scale = 0, Data = FJZLSX_Open
8       15:31:57  SQL Execute: ORACLE -  select SF_SF_TYZD00(?,?)FHJG00 from dual

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

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

14      15:31:57  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1266246.000000
15      15:31:57  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
16      15:31:57  SQL Execute: ORACLE -  select SF_SF_ZHDJZT(?,?)FHJG00 from dual

17      15:31:57  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = PTYBB20064917
18      15:31:57  SQL Execute: ORACLE - select SF_SF_GETBRID(?)FHJG00  from dual

19      15:31:57  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1266246.000000
20      15:31:57  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
21      15:31:57  SQL Execute: ORACLE -  select SF_SF_ZHDJZT(?,?)FHJG00 from dual

22      15:31:57  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = PTYBB20064917
23      15:31:57  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1000
24      15:31:57  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
25      15:31:57  SQL Execute: ORACLE -  select SF_SF_YYTOPEN(?,?,?) FHJG00 from dual

26      15:31:57  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = PTYBB20064917
27      15:31:57  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2001
28      15:31:57  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
29      15:31:57  SQL Execute: ORACLE -  select SF_SF_YYTOPEN(?,?,?) FHJG00 from dual

30      15:31:57  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=1266246 

31      15:31:57  SQL Execute: ORACLE - Select To_date('19570120','YYYY.MM.DD') from dual

32      15:31:57  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1266246
33      15:31:57  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 林秀珍
34      15:31:57  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,nvl(a.BRLXDH,a.BRDH00) DH0000
   from vw_yy_bryyxxcx a where 1=1 
 and (a.BRID00=? or a.BRXM00=?) 
 and a.YYRQ00=to_char(sysdate, 'YYYYMMDD')and a.YYJSSJ between '00:00:01' and '23:59:59' 
 and a.YYZT00 in ('0','1')
 and a.DPFYID='223455'