1       17:53:34  SQL Prepare: ORACLE - select * from (
select B.*,'1' JB0000 from VW_YK_YPFLMXZDYPCX B
 WHERE B.YPNM00=:1  AND B.YKBMBH+0=:2
 AND B.JZRQ00>=:3 AND B.JZRQ00<=:4 and B.JZRQ00||B.JZSJ00>=:5
 AND B.JZRQ00||B.JZSJ00<=:6  AND B.SFSH00 <> 'J' 
) D order by JZRQ00||JZSJ00,MXZLSH 

2       17:53:34  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 25722.000000
3       17:53:34  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 168.000000
4       17:53:34  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20240112
5       17:53:34  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20240112
6       17:53:34  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2024011200:00:00
7       17:53:34  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2024011223:59:59
8       17:53:34  SQL Execute: ORACLE - select * from (
select B.*,'1' JB0000 from VW_YK_YPFLMXZDYPCX B
 WHERE B.YPNM00=?  AND B.YKBMBH+0=?
 AND B.JZRQ00>=? AND B.JZRQ00<=? and B.JZRQ00||B.JZSJ00>=?
 AND B.JZRQ00||B.JZSJ00<=?  AND B.SFSH00 <> 'J' 
) D order by JZRQ00||JZSJ00,MXZLSH 

9       17:53:34  SQL Prepare: ORACLE -  select * from VW_YK_YPFLMXZDYPCX where 1=1 
 and mxzlsh=(select max(nvl(mxzlsh,0)) from yk_ypmxz0 where ypnm00=:1 
 and JZRQ00||JZSJ00<=:2 and ykbmbh+0=:3 and ((SFSH00 <> 'J') 
) ) 
 ORDER BY MXZLSH 

10      17:53:34  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 25722.000000
11      17:53:34  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2024011223:59:59
12      17:53:34  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 168.000000
13      17:53:34  SQL Execute: ORACLE -  select * from VW_YK_YPFLMXZDYPCX where 1=1 
 and mxzlsh=(select max(nvl(mxzlsh,0)) from yk_ypmxz0 where ypnm00=? 
 and JZRQ00||JZSJ00<=? and ykbmbh+0=? and ((SFSH00 <> 'J') 
) ) 
 ORDER BY MXZLSH