1 09:37:59 SQL Prepare: ORACLE - select A.*,B.PYSM00,B.YPBM00,B.YPMLBZ,B.YPJCL0,(select J.SCCJZW from BM_YPSCCJ J where J.SCCJBH=B.SCCJBH) SCCJZW ,B.CPID00,(select GHDWMC from BM_YPGHDW where GHDWNM=B.GHDWNM) GHDWMC from VW_YK_YPTJCX_ALLKF A,(select PYSM00, YPBM00,SCCJBH,LBBH00,YPNM00,YPJCL0,CPID00,GHDWNM,YPMLBZ FROM BM_YD0000) B WHERE A.YPNM00 = B.YPNM00 AND A.YKBMBH=12 and A.YKBMBH=A.YXBMBH AND B.LBBH00 LIKE :1 AND A.QRRQ00>=:2 AND A.QRRQ00<=:3 AND A.QRRQ00||A.QRSJ00>=:4 AND A.QRRQ00||A.QRSJ00<=:5 ORDER BY A.QRRQ00,A.YPTJPC,A.YPNM00 2 09:37:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 3 09:37:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20130301 4 09:37:59 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20130331 5 09:37:59 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2013030100:00:00 6 09:37:59 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2013033123:59:59 7 09:37:59 SQL Execute: ORACLE - select A.*,B.PYSM00,B.YPBM00,B.YPMLBZ,B.YPJCL0,(select J.SCCJZW from BM_YPSCCJ J where J.SCCJBH=B.SCCJBH) SCCJZW ,B.CPID00,(select GHDWMC from BM_YPGHDW where GHDWNM=B.GHDWNM) GHDWMC from VW_YK_YPTJCX_ALLKF A,(select PYSM00, YPBM00,SCCJBH,LBBH00,YPNM00,YPJCL0,CPID00,GHDWNM,YPMLBZ FROM BM_YD0000) B WHERE A.YPNM00 = B.YPNM00 AND A.YKBMBH=12 and A.YKBMBH=A.YXBMBH AND B.LBBH00 LIKE ? AND A.QRRQ00>=? AND A.QRRQ00<=? AND A.QRRQ00||A.QRSJ00>=? AND A.QRRQ00||A.QRSJ00<=? ORDER BY A.QRRQ00,A.YPTJPC,A.YPNM00 8 09:38:00 SQL Prepare: ORACLE - select A.*,B.BMMC00 AS YXYF00 from YK_YPTJMX A,BM_BMBM00 B where YPTJPC=:1 AND YPNM00=:2 AND A.YXBMBH=B.BMBH00 AND A.YXBMBH<>:3 ORDER BY YPMC00 9 09:38:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 004470 10 09:38:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8954.000000 11 09:38:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12.000000 12 09:38:00 SQL Execute: ORACLE - select A.*,B.BMMC00 AS YXYF00 from YK_YPTJMX A,BM_BMBM00 B where YPTJPC=? AND YPNM00=? AND A.YXBMBH=B.BMBH00 AND A.YXBMBH<>? ORDER BY YPMC00 13 09:38:00 SQL Prepare: ORACLE - select A.*,B.BMMC00 AS YXYF00 from YK_YPTJMX A,BM_BMBM00 B where YPTJPC=:1 AND YPNM00=:2 AND A.YXBMBH=B.BMBH00 AND A.YXBMBH<>:3 ORDER BY YPMC00 14 09:38:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 004470 15 09:38:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8954.000000 16 09:38:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12.000000 17 09:38:00 SQL Execute: ORACLE - select A.*,B.BMMC00 AS YXYF00 from YK_YPTJMX A,BM_BMBM00 B where YPTJPC=? AND YPNM00=? AND A.YXBMBH=B.BMBH00 AND A.YXBMBH<>? ORDER BY YPMC00 18 09:38:00 SQL Prepare: ORACLE - select A.*,B.BMMC00 AS YXYF00 from YK_YPTJMX A,BM_BMBM00 B where YPTJPC=:1 AND YPNM00=:2 AND A.YXBMBH=B.BMBH00 AND A.YXBMBH<>:3 ORDER BY YPMC00 19 09:38:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 004481 20 09:38:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 378.000000 21 09:38:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12.000000 22 09:38:00 SQL Execute: ORACLE - select A.*,B.BMMC00 AS YXYF00 from YK_YPTJMX A,BM_BMBM00 B where YPTJPC=? AND YPNM00=? AND A.YXBMBH=B.BMBH00 AND A.YXBMBH<>? ORDER BY YPMC00