1       11:35:52  SQL Execute: ORACLE - select MC0000,BH0000 from VW_BM_gend

2       11:35:52  SQL Execute: ORACLE - select MC0000,BH0000 from VW_BM_psn_cert_type

3       11:35:52  SQL Execute: ORACLE - select MC0000,BH0000 from VW_BM_psn_type

4       11:35:52  SQL Execute: ORACLE - select MC0000,BH0000 from VW_BM_naty

5       11:35:52  SQL Execute: ORACLE - select MC0000,BH0000 from VW_BM_mrg_stas

6       11:35:52  SQL Execute: ORACLE - select MC0000,BH0000 from VW_BM_patn_rlts

7       11:35:52  SQL Execute: ORACLE - select MC0000,BH0000 from VW_BM_blotype_abo

8       11:35:52  SQL Execute: ORACLE - select MC0000,BH0000 from VW_BM_prfs

9       11:35:52  SQL Execute: ORACLE -  select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='4' and (MKDM00='4TSBZ' or MKDM00='4BLBF') and ( 
 (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='4' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=1))))

10      11:35:52  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
11      11:35:52  SQL Execute: ORACLE - select  *  from  BM_PJLYQK  where PJLXBM = 7  and  PJSYR0 = ?
 and  SYBZ00 = 'Y'

12      11:35:52  SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='1' AND SFMRZ0='0'

13      11:35:52  SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='2' AND SFMRZ0='0'

14      11:35:52  SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='3' AND SFMRZ0='0'

15      11:35:52  SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='4' AND SFMRZ0='0'

16      11:35:52  SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='5' AND SFMRZ0='0'

17      11:35:52  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
18      11:35:52  SQL Execute: ORACLE - select BH0000,MC0000,YXBZ00 from BM_TYZD00 where BH0000=? and ZDMC00='收费员建卡费别权限'

19      11:35:52  SQL Execute: ORACLE - select JFLBMC,JFLBID from VW_SF_BRJFLB
 where JFLBID <> 0

20      11:35:52  SQL Execute: ORACLE - select QTLBMC,QTLBBH from VW_BM_BRQTLB
 where 1=1 order BY QTLBBH

21      11:35:52  SQL Execute: ORACLE - select FBMC00,FBBH00 from VW_BM_BRFBB0

22      11:35:52  SQL Execute: ORACLE -  select *  from  BM_TYZD00  where ZDMC00='预交金转账单位维护' and trim(MC0000) is not null and YXBZ00='1' order by BH0000  

23      11:35:52  SQL Execute: ORACLE -  select * from  BM_YHKDM0 ORDER BY  YHKDH0 

24      11:35:52  SQL Execute: ORACLE -  select * from BM_TYZD00 where ZDMC00='新冠职业分类' order by XSXH00 

25      11:35:52  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 自费
26      11:35:52  SQL Execute: ORACLE - select A.* from ic_ybbrlb A,bm_brfbb0 B  where A.fbbh00 = B.fbbh00 and B.FBMC00 = ? order by  A.YBLB00  desc 

27      11:35:52  SQL Execute: ORACLE - select * from  VW_BM_BRZFFS  where 1=1
 and ZFFSBH<>18 
order by nvl(XSXH00,0),ZFFSBH

28      11:35:52  SQL Execute: ORACLE - select *  from  VW_BM_NEWYBJK_YBJKLX where SFYX00='1' 
 and 1=1
order by XSXH00

29      11:35:56  SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 
where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')
 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '4') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',51,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '51')
  AND (INSTR (',' || a.jsksbh || ',',',51,') > 0 or a.jsksbh is null)