1 09:04:02 SQL Prepare: ORACLE - select decode(a.SFZFCG,'Y','是','否') SFZFCG,a.* from vw_SB_RCK000 a where (DJLX00='1' or DJLX00='2' ) and SHBZ00='2' and RZRQ00>='20100315' and RZRQ00<='20100322' and CKBH00=175 AND DYFKTZ='Y' order by CJID00,RCKID0 2 09:04:02 SQL Execute: ORACLE - select decode(a.SFZFCG,'Y','是','否') SFZFCG,a.* from vw_SB_RCK000 a where (DJLX00='1' or DJLX00='2' ) and SHBZ00='2' and RZRQ00>='20100315' and RZRQ00<='20100322' and CKBH00=175 AND DYFKTZ='Y' order by CJID00,RCKID0 3 09:04:09 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='26101') order by RCMXID,ZFBZ00 4 09:04:09 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='26101') order by RCMXID,ZFBZ00 5 09:04:09 SQL Prepare: ORACLE - Select COUNT(DISTINCT FPH000) as FPZS00 from vw_SB_RCKJFJ Where FPH000 is not null and rcmxid in (select rcmxid from SB_RCKMX0 where rckid0 in (26101)) 6 09:04:09 SQL Execute: ORACLE - Select COUNT(DISTINCT FPH000) as FPZS00 from vw_SB_RCKJFJ Where FPH000 is not null and rcmxid in (select rcmxid from SB_RCKMX0 where rckid0 in (26101)) 7 09:04:09 SQL Prepare: ORACLE - Select SUM(ZJE000) as HJJE00 from vw_SB_RCKJFJ Where rcmxid in (select rcmxid from SB_RCKMX0 where rckid0 in (26101)) 8 09:04:09 SQL Execute: ORACLE - Select SUM(ZJE000) as HJJE00 from vw_SB_RCKJFJ Where rcmxid in (select rcmxid from SB_RCKMX0 where rckid0 in (26101)) 9 09:04:10 SQL Prepare: ORACLE - Select DISTINCT ZWPM00 as ZWPM00 from vw_SB_RCKJFJ Where rcmxid in (select rcmxid from SB_RCKMX0 where rckid0 in (26101)) 10 09:04:10 SQL Execute: ORACLE - Select DISTINCT ZWPM00 as ZWPM00 from vw_SB_RCKJFJ Where rcmxid in (select rcmxid from SB_RCKMX0 where rckid0 in (26101)) 11 09:04:10 SQL Prepare: ORACLE - select Decode(a.SFZFCG,'Y',Decode('222137','222137','长乐市政府采购','政府采购')) ZFCGMC,'购入设备：偏斗四斗柜' HKSY00,'伍佰捌拾元整' RMBDX0,'580.00' RMBXX0,1 FPZS00, CJMC00 DWQC00,substr(a.DJRQ00,1,4)||'年'||substr(a.DJRQ00,5,2)||'月'||substr(a.DJRQ00,7,2)||'日' ZWDJRQ,a.* from vw_SB_RCK000 a where rckid0 in (26101) and rownum=1 12 09:04:10 SQL Execute: ORACLE - select Decode(a.SFZFCG,'Y',Decode('222137','222137','长乐市政府采购','政府采购')) ZFCGMC,'购入设备：偏斗四斗柜' HKSY00,'伍佰捌拾元整' RMBDX0,'580.00' RMBXX0,1 FPZS00, CJMC00 DWQC00,substr(a.DJRQ00,1,4)||'年'||substr(a.DJRQ00,5,2)||'月'||substr(a.DJRQ00,7,2)||'日' ZWDJRQ,a.* from vw_SB_RCK000 a where rckid0 in (26101) and rownum=1 13 09:04:10 SQL Prepare: ORACLE - select * from t_ctltemp where f_sysid='G' and f_tempid=4 14 09:04:10 SQL Execute: ORACLE - select * from t_ctltemp where f_sysid='G' and f_tempid=4 15 09:04:10 SQL Prepare: ORACLE - select * from t_CtlTemp1 where f_sysid='G' and f_tempid=4 order by F_Sequence 16 09:04:10 SQL Execute: ORACLE - select * from t_CtlTemp1 where f_sysid='G' and f_tempid=4 order by F_Sequence 17 09:04:10 SQL Prepare: ORACLE - select * from t_CtlLabel where f_sysid='G' and f_tempid=4 order by F_Sequence 18 09:04:10 SQL Execute: ORACLE - select * from t_CtlLabel where f_sysid='G' and f_tempid=4 order by F_Sequence 19 09:04:10 SQL Prepare: ORACLE - select * from t_CtlEdit where f_sysid='G' and f_tempid=4 order by F_Sequence 20 09:04:10 SQL Execute: ORACLE - select * from t_CtlEdit where f_sysid='G' and f_tempid=4 order by F_Sequence 21 09:04:10 SQL Prepare: ORACLE - select * from t_CtlDate where f_sysid='G' and f_tempid=4 order by F_Sequence 22 09:04:10 SQL Execute: ORACLE - select * from t_CtlDate where f_sysid='G' and f_tempid=4 order by F_Sequence 23 09:04:10 SQL Prepare: ORACLE - select * from t_CtlLine where f_sysid='G' and f_tempid=4 order by F_Sequence 24 09:04:10 SQL Execute: ORACLE - select * from t_CtlLine where f_sysid='G' and f_tempid=4 order by F_Sequence 25 09:04:10 SQL Prepare: ORACLE - select * from t_CtlGridCol where f_sysid='G' and f_tempid=4 order by F_Sequence 26 09:04:10 SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid='G' and f_tempid=4 order by F_Sequence 27 09:04:10 SQL Prepare: ORACLE - select * from t_CtlGrid where f_sysid='G' and f_tempid=4 order by F_Sequence 28 09:04:10 SQL Execute: ORACLE - select * from t_CtlGrid where f_sysid='G' and f_tempid=4 order by F_Sequence 29 09:04:10 SQL Prepare: ORACLE - select a.* from t_sqlparams a ,(select f_paramname,min(f_sequence) f_sequence,min(f_paramid) f_paramid from t_sqlparams where f_sysid='G' and f_tempid=4 group by f_paramname) b where a.f_sysid='G' and a.f_tempid=4 and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID 30 09:04:10 SQL Execute: ORACLE - select a.* from t_sqlparams a ,(select f_paramname,min(f_sequence) f_sequence,min(f_paramid) f_paramid from t_sqlparams where f_sysid='G' and f_tempid=4 group by f_paramname) b where a.f_sysid='G' and a.f_tempid=4 and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID 31 09:04:10 SQL Prepare: ORACLE - select * from t_SQLlist where f_sysid='G' and f_tempid=4 order by F_Sequence 32 09:04:10 SQL Execute: ORACLE - select * from t_SQLlist where f_sysid='G' and f_tempid=4 order by F_Sequence 33 09:04:10 SQL Prepare: ORACLE - select 1 from dual 34 09:04:10 SQL Execute: ORACLE - select 1 from dual