1       09:55:59  SQL Prepare: ORACLE - select  C.WBHLMC,B.PJXH00,B.PLMC00,(select brxm00 from bm_brxxb0 d where d.brid00=a.brid00) XM0000 
,A.*  from  sf_brjfb0 A,SF_PJSYQK B,BM_WBHLB0 C  where  A.PJH000 = B.PJH000(+)  and  A.WBHLID = C.WBHLID  and  A.JFJE00 <> 0 
 and  exists( select 1 from  bm_ygbm00 where ygbh00 = A.jfczy0 and xkh000 like :1 ) 
 and  A.JFRQ00 >=:2  and  A.JFRQ00 <=:3   and  A.JFRQ00||A.JFSJ00 >= :4    and  A.JFRQ00||A.JFSJ00 <= :5 
 and  A.ZFFS00 = 1 
 order by A.DJH000 

2       09:55:59  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = zz1%
3       09:55:59  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170703
4       09:55:59  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170703
5       09:55:59  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2017070300:00:00
6       09:55:59  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2017070323:59:59
7       09:55:59  SQL Execute: ORACLE - select  C.WBHLMC,B.PJXH00,B.PLMC00,(select brxm00 from bm_brxxb0 d where d.brid00=a.brid00) XM0000 
,A.*  from  sf_brjfb0 A,SF_PJSYQK B,BM_WBHLB0 C  where  A.PJH000 = B.PJH000(+)  and  A.WBHLID = C.WBHLID  and  A.JFJE00 <> 0 
 and  exists( select 1 from  bm_ygbm00 where ygbh00 = A.jfczy0 and xkh000 like ? ) 
 and  A.JFRQ00 >=?  and  A.JFRQ00 <=?   and  A.JFRQ00||A.JFSJ00 >= ?    and  A.JFRQ00||A.JFSJ00 <= ? 
 and  A.ZFFS00 = 1 
 order by A.DJH000