1 15:58:48 SQL Prepare: ORACLE - select max(sj0000),RQ0000 from czk_zlxx00 where YSXM00='Öܹð·É' and RQ0000='20180416' GROUP BY RQ0000 2 15:58:48 SQL Execute: ORACLE - select max(sj0000),RQ0000 from czk_zlxx00 where YSXM00='Öܹð·É' and RQ0000='20180416' GROUP BY RQ0000 3 15:58:49 SQL Prepare: ORACLE - select XMID00 from czk_zlxx00 where RQ0000='20180416' and SJ0000='15:58:11' 4 15:58:49 SQL Execute: ORACLE - select XMID00 from czk_zlxx00 where RQ0000='20180416' and SJ0000='15:58:11' 5 15:58:49 SQL Prepare: ORACLE - select * from CZK_XMSJXZ where XMID00='534' 6 15:58:49 SQL Execute: ORACLE - select * from CZK_XMSJXZ where XMID00='534' 7 15:58:49 SQL Prepare: ORACLE - select SYCS00 from VW_CZK_ZLSYCS where VIP000='26110' and XMID00='3' AND KDYYID='A ' AND XMJG00='10' 8 15:58:49 SQL Execute: ORACLE - select SYCS00 from VW_CZK_ZLSYCS where VIP000='26110' and XMID00='3' AND KDYYID='A ' AND XMJG00='10' 9 15:58:51 SQL Prepare: ORACLE - select SYCS00 from VW_CZK_ZLSYCS where VIP000='26110' and XMID00='534' AND KDYYID='A ' AND XMJG00='70' 10 15:58:51 SQL Execute: ORACLE - select SYCS00 from VW_CZK_ZLSYCS where VIP000='26110' and XMID00='534' AND KDYYID='A ' AND XMJG00='70' 11 15:58:53 SQL Prepare: ORACLE - select * from VW_CZK_ZLSYCS where VIP000=:1 and XMID00=:2 and SYCS00>0 12 15:58:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26110 13 15:58:53 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 14 15:58:53 SQL Execute: ORACLE - select * from VW_CZK_ZLSYCS where VIP000=? and XMID00=? and SYCS00>0 15 15:58:55 SQL Prepare: ORACLE - select SYCS00 from VW_CZK_ZLSYCS where VIP000='26110' and XMID00='3' AND KDYYID='A ' AND XMJG00='10' 16 15:58:55 SQL Execute: ORACLE - select SYCS00 from VW_CZK_ZLSYCS where VIP000='26110' and XMID00='3' AND KDYYID='A ' AND XMJG00='10' 17 15:58:58 SQL Prepare: ORACLE - select MONEY0 from CZK_VIP000 where VIP000='26110' 18 15:58:58 SQL Execute: ORACLE - select MONEY0 from CZK_VIP000 where VIP000='26110' 19 15:58:58 SQL Prepare: ORACLE - update CZK_VIP000 set MONEY0=MONEY0-:1 where VIP000='26110' 20 15:58:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10.000000 21 15:58:58 SQL Execute: ORACLE - update CZK_VIP000 set MONEY0=MONEY0-? where VIP000='26110' 22 15:58:58 SQL Data In: ORACLE - Rows affected = 1 23 15:58:58 SQL Prepare: ORACLE - select sysdate from dual 24 15:58:58 SQL Execute: ORACLE - select sysdate from dual 25 15:58:58 SQL Prepare: ORACLE - select sysdate from dual 26 15:58:58 SQL Execute: ORACLE - select sysdate from dual 27 15:58:58 SQL Prepare: ORACLE - insert into CZK_ZLXX00(ID0000,DW0000,VIP000,XMID00,XM0000,XMMC00,XMJG00,CS0000,YSXM00,RQ0000,SJ0000,DJ0000,BZ0000,XG0000,KLX000,KDYYID,ZLYYID,SFSJC0,SFYY00,CZKS00) values(CZK_ZLXX00_ID0000.nextval,:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19) 28 15:58:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = ¸öÈË 29 15:58:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26110 30 15:58:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 31 15:58:58 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = ²ÌÔÆ·å 32 15:58:58 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = °Î¹ÞÁÆ·¨ 33 15:58:58 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 10 34 15:58:58 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 35 15:58:58 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = Öܹð·É 36 15:58:58 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20180416 37 15:58:58 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 15:58:59 38 15:58:58 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = »Æ½£»Ô 39 15:58:58 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 40 15:58:58 SQL Data In: ORACLE - Param = 13, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 41 15:58:58 SQL Data In: ORACLE - Param = 14, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 42 15:58:58 SQL Data In: ORACLE - Param = 15, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = A 43 15:58:58 SQL Data In: ORACLE - Param = 16, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = A 44 15:58:58 SQL Data In: ORACLE - Param = 17, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 45 15:58:58 SQL Data In: ORACLE - Param = 18, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 46 15:58:58 SQL Data In: ORACLE - Param = 19, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 91.000000 47 15:58:58 SQL Execute: ORACLE - insert into CZK_ZLXX00(ID0000,DW0000,VIP000,XMID00,XM0000,XMMC00,XMJG00,CS0000,YSXM00,RQ0000,SJ0000,DJ0000,BZ0000,XG0000,KLX000,KDYYID,ZLYYID,SFSJC0,SFYY00,CZKS00) values(CZK_ZLXX00_ID0000.nextval,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) 48 15:58:58 SQL Data In: ORACLE - Rows affected = 1 49 15:58:58 SQL Prepare: ORACLE - commit 50 15:58:58 SQL Execute: ORACLE - commit 51 15:58:58 SQL Data In: ORACLE - Rows affected = 0 52 15:58:58 SQL Prepare: ORACLE - select * from VW_CZK_ZLSYCS where VIP000=:1 and XMID00=:2 and SYCS00>0 53 15:58:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26110 54 15:58:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 534 55 15:58:58 SQL Execute: ORACLE - select * from VW_CZK_ZLSYCS where VIP000=? and XMID00=? and SYCS00>0 56 15:59:00 SQL Prepare: ORACLE - select SYCS00 from VW_CZK_ZLSYCS where VIP000='26110' and XMID00='534' AND KDYYID='A ' AND XMJG00='70' 57 15:59:00 SQL Execute: ORACLE - select SYCS00 from VW_CZK_ZLSYCS where VIP000='26110' and XMID00='534' AND KDYYID='A ' AND XMJG00='70' 58 15:59:02 SQL Prepare: ORACLE - select MONEY0 from CZK_VIP000 where VIP000='26110' 59 15:59:02 SQL Execute: ORACLE - select MONEY0 from CZK_VIP000 where VIP000='26110' 60 15:59:02 SQL Prepare: ORACLE - update CZK_VIP000 set MONEY0=MONEY0-:1 where VIP000='26110' 61 15:59:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 70.000000 62 15:59:02 SQL Execute: ORACLE - update CZK_VIP000 set MONEY0=MONEY0-? where VIP000='26110' 63 15:59:02 SQL Data In: ORACLE - Rows affected = 1 64 15:59:02 SQL Prepare: ORACLE - select sysdate from dual 65 15:59:02 SQL Execute: ORACLE - select sysdate from dual 66 15:59:02 SQL Prepare: ORACLE - select sysdate from dual 67 15:59:02 SQL Execute: ORACLE - select sysdate from dual 68 15:59:02 SQL Prepare: ORACLE - insert into CZK_ZLXX00(ID0000,DW0000,VIP000,XMID00,XM0000,XMMC00,XMJG00,CS0000,YSXM00,RQ0000,SJ0000,DJ0000,BZ0000,XG0000,KLX000,KDYYID,ZLYYID,SFSJC0,SFYY00,CZKS00) values(CZK_ZLXX00_ID0000.nextval,:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19) 69 15:59:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = ¸öÈË 70 15:59:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26110 71 15:59:02 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 534 72 15:59:02 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = ²ÌÔÆ·å 73 15:59:02 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = ÍÆÄà 74 15:59:02 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 70 75 15:59:02 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 76 15:59:02 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = Öܹð·É 77 15:59:02 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20180416 78 15:59:02 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 15:59:03 79 15:59:02 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = »Æ½£»Ô 80 15:59:02 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 81 15:59:02 SQL Data In: ORACLE - Param = 13, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 82 15:59:02 SQL Data In: ORACLE - Param = 14, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 83 15:59:02 SQL Data In: ORACLE - Param = 15, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = A 84 15:59:02 SQL Data In: ORACLE - Param = 16, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = A 85 15:59:02 SQL Data In: ORACLE - Param = 17, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 86 15:59:02 SQL Data In: ORACLE - Param = 18, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 87 15:59:02 SQL Data In: ORACLE - Param = 19, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 91.000000 88 15:59:02 SQL Execute: ORACLE - insert into CZK_ZLXX00(ID0000,DW0000,VIP000,XMID00,XM0000,XMMC00,XMJG00,CS0000,YSXM00,RQ0000,SJ0000,DJ0000,BZ0000,XG0000,KLX000,KDYYID,ZLYYID,SFSJC0,SFYY00,CZKS00) values(CZK_ZLXX00_ID0000.nextval,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) 89 15:59:02 SQL Data In: ORACLE - Rows affected = 1 90 15:59:02 SQL Prepare: ORACLE - commit 91 15:59:02 SQL Execute: ORACLE - commit 92 15:59:02 SQL Data In: ORACLE - Rows affected = 0 93 15:59:05 SQL Prepare: ORACLE - select 'N' XZ0000,A.*,(SELECT YYJC00 FROM XT_YYXX00 WHERE A.KDYYID=YYID00) KDYYJC,(SELECT YYJC00 FROM XT_YYXX00 WHERE A.ZLYYID=YYID00) ZLYYJC from CZK_zlxx00 A where VIP000=:1 order by rq0000 desc,sj0000 desc 94 15:59:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26110 95 15:59:05 SQL Execute: ORACLE - select 'N' XZ0000,A.*,(SELECT YYJC00 FROM XT_YYXX00 WHERE A.KDYYID=YYID00) KDYYJC,(SELECT YYJC00 FROM XT_YYXX00 WHERE A.ZLYYID=YYID00) ZLYYJC from CZK_zlxx00 A where VIP000=? order by rq0000 desc,sj0000 desc 96 15:59:05 SQL Prepare: ORACLE - select 'N' XZZT00,C.XMMC00,A.XMJG00,A.SYCS00,A.KDYYID,B.YYJC00,A.XMID00 from VW_CZK_ZLSYCS A,XT_YYXX00 B,CZK_XMXX00 C where A.XMID00=C.XMID00 AND A.SYCS00>0 and A.VIP000=:1 and A.KDYYID=B.YYID00(+) and (trim(A.KDYYID)='A' or A.KDYYID is null) 97 15:59:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26110 98 15:59:05 SQL Execute: ORACLE - select 'N' XZZT00,C.XMMC00,A.XMJG00,A.SYCS00,A.KDYYID,B.YYJC00,A.XMID00 from VW_CZK_ZLSYCS A,XT_YYXX00 B,CZK_XMXX00 C where A.XMID00=C.XMID00 AND A.SYCS00>0 and A.VIP000=? and A.KDYYID=B.YYID00(+) and (trim(A.KDYYID)='A' or A.KDYYID is null) 99 15:59:07 SQL Prepare: ORACLE - select * from CZK_VIP000 where VIP000=:1 100 15:59:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26110 101 15:59:07 SQL Execute: ORACLE - select * from CZK_VIP000 where VIP000=?