----------------------------------
Timestamp: 14:43:25.251
SELECT COUNT(1) COUNT0 FROM YS_XXJL00 WHERE HSFZT0=1 AND FSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') AND SFLL00='0' AND BZ0000='0'
Execution time: 0 ms
Runtime error occurred: 1036 (ORA-01036: 非法的变量名/编号)
----------------------------------
Timestamp: 14:43:25.288
SELECT COUNT(1) COUNT0 FROM YS_XXJL00 WHERE HSFZT0=1 AND FSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') AND SFLL00='0' AND BZ0000='0'
Execution time: 0 ms
----------------------------------
Timestamp: 14:43:26.078
Select t1.SCKBH0,t1.DCKBH0,t2.ckmc00 as sckmc0,t3.ckmc00 as dckmc0,t3.bmbh00, t4.bmmc00,t4.BH0000 from BM_CKDY00 t1,bm_ckbm00 
t2, bm_ckbm00 t3, bm_bmbm00 t4 where t1.sckbh0=t2.ckbh00 and t3.bmbh00=t4.bmbh00 and t2.flag00='0' and t1.dckbh0=t3.ckbh00 and 
t2.bmbh00='350' and t1.SCKBH0='1'
Execution time: 0 ms
Runtime error occurred: 1036 (ORA-01036: 非法的变量名/编号)
----------------------------------
Timestamp: 14:43:26.087
Select t1.SCKBH0,t1.DCKBH0,t2.ckmc00 as sckmc0,t3.ckmc00 as dckmc0,t3.bmbh00, t4.bmmc00,t4.BH0000 from BM_CKDY00 t1,bm_ckbm00 
t2, bm_ckbm00 t3, bm_bmbm00 t4 where t1.sckbh0=t2.ckbh00 and t3.bmbh00=t4.bmbh00 and t2.flag00='0' and t1.dckbh0=t3.ckbh00 and 
t2.bmbh00='350' and t1.SCKBH0='1'
Execution time: 0 ms
----------------------------------
Timestamp: 14:43:26.112
Select distinct t1.GHYSBH,t1.GHHZCK,t1.GHLBMC||substr(GHQSSJ,1,5)||'-'||substr(GHJSSJ,1,5) GHLBMC,t1.GHLBBH,t1.GHHBID,t1.GHHZCK,
t2.ZWXM00  from sf_ysghhb t1,bm_ygbm00 t2 where t1.ghksbh='183' and t1.GHHZCK='3' and t1.GHYSBH=t2.YGBH00 and 
t1.GHMZSJ=to_char(sysdate,'yyyymmdd')
Execution time: 0 ms
Runtime error occurred: 1036 (ORA-01036: 非法的变量名/编号)
----------------------------------
Timestamp: 14:43:26.131
Select distinct t1.GHYSBH,t1.GHHZCK,t1.GHLBMC||substr(GHQSSJ,1,5)||'-'||substr(GHJSSJ,1,5) GHLBMC,t1.GHLBBH,t1.GHHBID,t1.GHHZCK,
t2.ZWXM00  from sf_ysghhb t1,bm_ygbm00 t2 where t1.ghksbh='183' and t1.GHHZCK='3' and t1.GHYSBH=t2.YGBH00 and 
t1.GHMZSJ=to_char(sysdate,'yyyymmdd')
Execution time: 0 ms
----------------------------------
Timestamp: 14:43:26.151
Select distinct t1.GHYSBH,t1.GHHZCK,t1.GHLBMC||substr(GHQSSJ,1,5)||'-'||substr(GHJSSJ,1,5) GHLBMC,t1.GHLBBH,t1.GHHBID,t1.GHHZCK,
t2.ZWXM00  from sf_ysghhb t1,bm_ygbm00 t2 where t1.ghksbh='183' and t1.GHHZCK='4' and t1.GHYSBH=t2.YGBH00 and 
t1.GHMZSJ=to_char(sysdate,'yyyymmdd')
Execution time: 0 ms
Runtime error occurred: 1036 (ORA-01036: 非法的变量名/编号)
----------------------------------
Timestamp: 14:43:26.167
Select distinct t1.GHYSBH,t1.GHHZCK,t1.GHLBMC||substr(GHQSSJ,1,5)||'-'||substr(GHJSSJ,1,5) GHLBMC,t1.GHLBBH,t1.GHHBID,t1.GHHZCK,
t2.ZWXM00  from sf_ysghhb t1,bm_ygbm00 t2 where t1.ghksbh='183' and t1.GHHZCK='4' and t1.GHYSBH=t2.YGBH00 and 
t1.GHMZSJ=to_char(sysdate,'yyyymmdd')
Execution time: 0 ms
----------------------------------
Timestamp: 14:43:26.200
Select distinct t1.GHYSBH,t1.GHHZCK,t1.GHLBMC||substr(GHQSSJ,1,5)||'-'||substr(GHJSSJ,1,5) GHLBMC,t1.GHLBBH,t1.GHHBID,t1.GHHZCK,
t2.ZWXM00  from sf_ysghhb t1,bm_ygbm00 t2 where t1.ghksbh='183' and t1.GHHZCK='6' and t1.GHYSBH=t2.YGBH00 and 
t1.GHMZSJ=to_char(sysdate,'yyyymmdd')
Execution time: 0 ms
Runtime error occurred: 1036 (ORA-01036: 非法的变量名/编号)
----------------------------------
Timestamp: 14:43:26.249
Select distinct t1.GHYSBH,t1.GHHZCK,t1.GHLBMC||substr(GHQSSJ,1,5)||'-'||substr(GHJSSJ,1,5) GHLBMC,t1.GHLBBH,t1.GHHBID,t1.GHHZCK,
t2.ZWXM00  from sf_ysghhb t1,bm_ygbm00 t2 where t1.ghksbh='183' and t1.GHHZCK='6' and t1.GHYSBH=t2.YGBH00 and 
t1.GHMZSJ=to_char(sysdate,'yyyymmdd')
Execution time: 15 ms
----------------------------------
Timestamp: 14:43:26.284
Select distinct t1.GHYSBH,t1.GHHZCK,t1.GHLBMC||substr(GHQSSJ,1,5)||'-'||substr(GHJSSJ,1,5) GHLBMC,t1.GHLBBH,t1.GHHBID,t1.GHHZCK,
t2.ZWXM00  from sf_ysghhb t1,bm_ygbm00 t2 where t1.ghksbh='183' and t1.GHHZCK='7' and t1.GHYSBH=t2.YGBH00 and 
t1.GHMZSJ=to_char(sysdate,'yyyymmdd')
Execution time: 0 ms
Runtime error occurred: 1036 (ORA-01036: 非法的变量名/编号)
----------------------------------
Timestamp: 14:43:26.308
Select distinct t1.GHYSBH,t1.GHHZCK,t1.GHLBMC||substr(GHQSSJ,1,5)||'-'||substr(GHJSSJ,1,5) GHLBMC,t1.GHLBBH,t1.GHHBID,t1.GHHZCK,
t2.ZWXM00  from sf_ysghhb t1,bm_ygbm00 t2 where t1.ghksbh='183' and t1.GHHZCK='7' and t1.GHYSBH=t2.YGBH00 and 
t1.GHMZSJ=to_char(sysdate,'yyyymmdd')
Execution time: 0 ms
----------------------------------
Timestamp: 14:43:26.341
Select distinct t1.GHYSBH,t1.GHHZCK,t1.GHLBMC||substr(GHQSSJ,1,5)||'-'||substr(GHJSSJ,1,5) GHLBMC,t1.GHLBBH,t1.GHHBID,t1.GHHZCK,
t2.ZWXM00  from sf_ysghhb t1,bm_ygbm00 t2 where t1.ghksbh='183' and t1.GHHZCK='9' and t1.GHYSBH=t2.YGBH00 and 
t1.GHMZSJ=to_char(sysdate,'yyyymmdd')
Execution time: 0 ms
Runtime error occurred: 1036 (ORA-01036: 非法的变量名/编号)
----------------------------------
Timestamp: 14:43:26.371
Select distinct t1.GHYSBH,t1.GHHZCK,t1.GHLBMC||substr(GHQSSJ,1,5)||'-'||substr(GHJSSJ,1,5) GHLBMC,t1.GHLBBH,t1.GHHBID,t1.GHHZCK,
t2.ZWXM00  from sf_ysghhb t1,bm_ygbm00 t2 where t1.ghksbh='183' and t1.GHHZCK='9' and t1.GHYSBH=t2.YGBH00 and 
t1.GHMZSJ=to_char(sysdate,'yyyymmdd')
Execution time: 0 ms
----------------------------------
Timestamp: 14:43:26.407
Select distinct t1.GHYSBH,t1.GHHZCK,t1.GHLBMC||substr(GHQSSJ,1,5)||'-'||substr(GHJSSJ,1,5) GHLBMC,t1.GHLBBH,t1.GHHBID,t1.GHHZCK,
t2.ZWXM00  from sf_ysghhb t1,bm_ygbm00 t2 where t1.ghksbh='183' and t1.GHHZCK='10' and t1.GHYSBH=t2.YGBH00 and 
t1.GHMZSJ=to_char(sysdate,'yyyymmdd')
Execution time: 0 ms
Runtime error occurred: 1036 (ORA-01036: 非法的变量名/编号)
----------------------------------
Timestamp: 14:43:26.437
Select distinct t1.GHYSBH,t1.GHHZCK,t1.GHLBMC||substr(GHQSSJ,1,5)||'-'||substr(GHJSSJ,1,5) GHLBMC,t1.GHLBBH,t1.GHHBID,t1.GHHZCK,
t2.ZWXM00  from sf_ysghhb t1,bm_ygbm00 t2 where t1.ghksbh='183' and t1.GHHZCK='10' and t1.GHYSBH=t2.YGBH00 and 
t1.GHMZSJ=to_char(sysdate,'yyyymmdd')
Execution time: 0 ms
----------------------------------
Timestamp: 14:43:26.475
Select distinct t1.GHYSBH,t1.GHHZCK,t1.GHLBMC||substr(GHQSSJ,1,5)||'-'||substr(GHJSSJ,1,5) GHLBMC,t1.GHLBBH,t1.GHHBID,t1.GHHZCK,
t2.ZWXM00  from sf_ysghhb t1,bm_ygbm00 t2 where t1.ghksbh='183' and t1.GHHZCK='28' and t1.GHYSBH=t2.YGBH00 and 
t1.GHMZSJ=to_char(sysdate,'yyyymmdd')
Execution time: 0 ms
Runtime error occurred: 1036 (ORA-01036: 非法的变量名/编号)
----------------------------------
Timestamp: 14:43:26.500
Select distinct t1.GHYSBH,t1.GHHZCK,t1.GHLBMC||substr(GHQSSJ,1,5)||'-'||substr(GHJSSJ,1,5) GHLBMC,t1.GHLBBH,t1.GHHBID,t1.GHHZCK,
t2.ZWXM00  from sf_ysghhb t1,bm_ygbm00 t2 where t1.ghksbh='183' and t1.GHHZCK='28' and t1.GHYSBH=t2.YGBH00 and 
t1.GHMZSJ=to_char(sysdate,'yyyymmdd')
Execution time: 0 ms
----------------------------------
Timestamp: 14:43:26.531
Select distinct t1.GHYSBH,t1.GHHZCK,t1.GHLBMC||substr(GHQSSJ,1,5)||'-'||substr(GHJSSJ,1,5) GHLBMC,t1.GHLBBH,t1.GHHBID,t1.GHHZCK,
t2.ZWXM00  from sf_ysghhb t1,bm_ygbm00 t2 where t1.ghksbh='183' and t1.GHHZCK='41' and t1.GHYSBH=t2.YGBH00 and 
t1.GHMZSJ=to_char(sysdate,'yyyymmdd')
Execution time: 0 ms
Runtime error occurred: 1036 (ORA-01036: 非法的变量名/编号)
----------------------------------
Timestamp: 14:43:26.558
Select distinct t1.GHYSBH,t1.GHHZCK,t1.GHLBMC||substr(GHQSSJ,1,5)||'-'||substr(GHJSSJ,1,5) GHLBMC,t1.GHLBBH,t1.GHHBID,t1.GHHZCK,
t2.ZWXM00  from sf_ysghhb t1,bm_ygbm00 t2 where t1.ghksbh='183' and t1.GHHZCK='41' and t1.GHYSBH=t2.YGBH00 and 
t1.GHMZSJ=to_char(sysdate,'yyyymmdd')
Execution time: 0 ms
----------------------------------
Timestamp: 14:43:26.591
Select distinct t1.GHYSBH,t1.GHHZCK,t1.GHLBMC||substr(GHQSSJ,1,5)||'-'||substr(GHJSSJ,1,5) GHLBMC,t1.GHLBBH,t1.GHHBID,t1.GHHZCK,
t2.ZWXM00  from sf_ysghhb t1,bm_ygbm00 t2 where t1.ghksbh='183' and t1.GHHZCK='575' and t1.GHYSBH=t2.YGBH00 and 
t1.GHMZSJ=to_char(sysdate,'yyyymmdd')
Execution time: 0 ms
Runtime error occurred: 1036 (ORA-01036: 非法的变量名/编号)
----------------------------------
Timestamp: 14:43:26.621
Select distinct t1.GHYSBH,t1.GHHZCK,t1.GHLBMC||substr(GHQSSJ,1,5)||'-'||substr(GHJSSJ,1,5) GHLBMC,t1.GHLBBH,t1.GHHBID,t1.GHHZCK,
t2.ZWXM00  from sf_ysghhb t1,bm_ygbm00 t2 where t1.ghksbh='183' and t1.GHHZCK='575' and t1.GHYSBH=t2.YGBH00 and 
t1.GHMZSJ=to_char(sysdate,'yyyymmdd')
Execution time: 0 ms
----------------------------------
Timestamp: 14:43:26.652
Select distinct t1.GHYSBH,t1.GHHZCK,t1.GHLBMC||substr(GHQSSJ,1,5)||'-'||substr(GHJSSJ,1,5) GHLBMC,t1.GHLBBH,t1.GHHBID,t1.GHHZCK,
t2.ZWXM00  from sf_ysghhb t1,bm_ygbm00 t2 where t1.ghksbh='183' and t1.GHHZCK='1875' and t1.GHYSBH=t2.YGBH00 and 
t1.GHMZSJ=to_char(sysdate,'yyyymmdd')
Execution time: 0 ms
Runtime error occurred: 1036 (ORA-01036: 非法的变量名/编号)
----------------------------------
Timestamp: 14:43:26.687
Select distinct t1.GHYSBH,t1.GHHZCK,t1.GHLBMC||substr(GHQSSJ,1,5)||'-'||substr(GHJSSJ,1,5) GHLBMC,t1.GHLBBH,t1.GHHBID,t1.GHHZCK,
t2.ZWXM00  from sf_ysghhb t1,bm_ygbm00 t2 where t1.ghksbh='183' and t1.GHHZCK='1875' and t1.GHYSBH=t2.YGBH00 and 
t1.GHMZSJ=to_char(sysdate,'yyyymmdd')
Execution time: 16 ms
----------------------------------
Timestamp: 14:43:26.724
Select distinct t1.GHYSBH,t1.GHHZCK,t1.GHLBMC||substr(GHQSSJ,1,5)||'-'||substr(GHJSSJ,1,5) GHLBMC,t1.GHLBBH,t1.GHHBID,t1.GHHZCK,
t2.ZWXM00  from sf_ysghhb t1,bm_ygbm00 t2 where t1.ghksbh='183' and t1.GHHZCK='1975' and t1.GHYSBH=t2.YGBH00 and 
t1.GHMZSJ=to_char(sysdate,'yyyymmdd')
Execution time: 0 ms
Runtime error occurred: 1036 (ORA-01036: 非法的变量名/编号)
----------------------------------
Timestamp: 14:43:26.754
Select distinct t1.GHYSBH,t1.GHHZCK,t1.GHLBMC||substr(GHQSSJ,1,5)||'-'||substr(GHJSSJ,1,5) GHLBMC,t1.GHLBBH,t1.GHHBID,t1.GHHZCK,
t2.ZWXM00  from sf_ysghhb t1,bm_ygbm00 t2 where t1.ghksbh='183' and t1.GHHZCK='1975' and t1.GHYSBH=t2.YGBH00 and 
t1.GHMZSJ=to_char(sysdate,'yyyymmdd')
Execution time: 0 ms
----------------------------------
Timestamp: 14:43:26.792
Select distinct t1.GHYSBH,t1.GHHZCK,t1.GHLBMC||substr(GHQSSJ,1,5)||'-'||substr(GHJSSJ,1,5) GHLBMC,t1.GHLBBH,t1.GHHBID,t1.GHHZCK,
t2.ZWXM00  from sf_ysghhb t1,bm_ygbm00 t2 where t1.ghksbh='183' and t1.GHHZCK='2075' and t1.GHYSBH=t2.YGBH00 and 
t1.GHMZSJ=to_char(sysdate,'yyyymmdd')
Execution time: 0 ms
Runtime error occurred: 1036 (ORA-01036: 非法的变量名/编号)
----------------------------------
Timestamp: 14:43:26.821
Select distinct t1.GHYSBH,t1.GHHZCK,t1.GHLBMC||substr(GHQSSJ,1,5)||'-'||substr(GHJSSJ,1,5) GHLBMC,t1.GHLBBH,t1.GHHBID,t1.GHHZCK,
t2.ZWXM00  from sf_ysghhb t1,bm_ygbm00 t2 where t1.ghksbh='183' and t1.GHHZCK='2075' and t1.GHYSBH=t2.YGBH00 and 
t1.GHMZSJ=to_char(sysdate,'yyyymmdd')
Execution time: 0 ms
----------------------------------
Timestamp: 14:43:26.857
Select distinct t1.GHYSBH,t1.GHHZCK,t1.GHLBMC||substr(GHQSSJ,1,5)||'-'||substr(GHJSSJ,1,5) GHLBMC,t1.GHLBBH,t1.GHHBID,t1.GHHZCK,
t2.ZWXM00  from sf_ysghhb t1,bm_ygbm00 t2 where t1.ghksbh='183' and t1.GHHZCK='2175' and t1.GHYSBH=t2.YGBH00 and 
t1.GHMZSJ=to_char(sysdate,'yyyymmdd')
Execution time: 0 ms
Runtime error occurred: 1036 (ORA-01036: 非法的变量名/编号)
----------------------------------
Timestamp: 14:43:26.888
Select distinct t1.GHYSBH,t1.GHHZCK,t1.GHLBMC||substr(GHQSSJ,1,5)||'-'||substr(GHJSSJ,1,5) GHLBMC,t1.GHLBBH,t1.GHHBID,t1.GHHZCK,
t2.ZWXM00  from sf_ysghhb t1,bm_ygbm00 t2 where t1.ghksbh='183' and t1.GHHZCK='2175' and t1.GHYSBH=t2.YGBH00 and 
t1.GHMZSJ=to_char(sysdate,'yyyymmdd')
Execution time: 0 ms
----------------------------------
Timestamp: 14:43:26.925
Select distinct t1.GHYSBH,t1.GHHZCK,t1.GHLBMC||substr(GHQSSJ,1,5)||'-'||substr(GHJSSJ,1,5) GHLBMC,t1.GHLBBH,t1.GHHBID,t1.GHHZCK,
t2.ZWXM00  from sf_ysghhb t1,bm_ygbm00 t2 where t1.ghksbh='183' and t1.GHHZCK='2275' and t1.GHYSBH=t2.YGBH00 and 
t1.GHMZSJ=to_char(sysdate,'yyyymmdd')
Execution time: 0 ms
Runtime error occurred: 1036 (ORA-01036: 非法的变量名/编号)
----------------------------------
Timestamp: 14:43:26.955
Select distinct t1.GHYSBH,t1.GHHZCK,t1.GHLBMC||substr(GHQSSJ,1,5)||'-'||substr(GHJSSJ,1,5) GHLBMC,t1.GHLBBH,t1.GHHBID,t1.GHHZCK,
t2.ZWXM00  from sf_ysghhb t1,bm_ygbm00 t2 where t1.ghksbh='183' and t1.GHHZCK='2275' and t1.GHYSBH=t2.YGBH00 and 
t1.GHMZSJ=to_char(sysdate,'yyyymmdd')
Execution time: 0 ms
----------------------------------
Timestamp: 14:43:26.992
SELECT * FROM VW_YS_XXJLHS WHERE HSFZT0=1 AND FSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') order by FSSJ00
Execution time: 0 ms
Runtime error occurred: 1036 (ORA-01036: 非法的变量名/编号)
----------------------------------
Timestamp: 14:43:27.021
SELECT * FROM VW_YS_XXJLHS WHERE HSFZT0=1 AND FSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') order by FSSJ00
Execution time: 0 ms
----------------------------------
Timestamp: 14:43:29.063
SELECT * FROM VW_YS_XXJLHS WHERE HSFZT0=1 AND FSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') order by FSSJ00
Execution time: 0 ms
Runtime error occurred: 1036 (ORA-01036: 非法的变量名/编号)
----------------------------------
Timestamp: 14:43:29.085
SELECT * FROM VW_YS_XXJLHS WHERE HSFZT0=1 AND FSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') order by FSSJ00
Execution time: 0 ms