begin SQL,2025-12-13 14:01:32.867
 select JLBH,CUR_VAL from BFCONFIG where JLBH in (0,520000102,520000103,520000112,520000113,520000115,520000120,520000121,520000123,520000128,520000129,520000140,520000141,520000143)
 end 

 begin SQL,2025-12-13 14:01:32.913
 select CONTENT from XTXX where ID = 150 
 end 

 begin SQL,2025-12-13 14:01:32.960
 select USER_DM,USER_PSW,HTTPOK,WSOK,WCFOK from CRMUSER
 end 

 begin SQL,2025-12-13 14:01:32.975
 select IPADDR from CRMCLIENT where WSOK = 1 
 end 

 begin SQL,2025-12-13 14:01:33.007
 select JYID from MZK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-13 14:01:33.007
 select JYID from HYK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-13 14:01:33.023
 select SHDM,MDID from MDDY where MDDM = 'BG01'
 end 

 begin SQL,2025-12-13 14:01:33.290
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-13 14:01:33.290
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-13 14:01:33.295
 select count(*) from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX in (0,2)    and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-13 14:01:33.295
 select count(*) from CXMBJZDYD a  where a.SHDM = 'BG'   and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-13 14:01:33.295
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-13 14:01:33.295
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-13 14:01:33.306
 select count(*) from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX in (0,2)    and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-13 14:01:33.306
 select count(*) from CXMBJZDYD a  where a.SHDM = 'BG'   and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-13 14:02:29.827
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-13 14:02:29.827
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-13 14:02:29.827
 select count(*) from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX in (0,2)    and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-13 14:02:29.827
 select count(*) from CXMBJZDYD a  where a.SHDM = 'BG'   and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-13 14:02:29.938
 select XFJLID,STATUS,XFJLID_OLD from HYK_XFJL where MDID = 1  and SKTNO = '010010'  and JLBH = 100070
 end 

 begin SQL,2025-12-13 14:02:29.953
 select XFJLID from HYXFJL where MDID = 1  and SKTNO = '010010'  and JLBH = 100070
 end 

 begin SQL,2025-12-13 14:02:29.953
 select SHSPID from SHSPXX_DM where SHDM = 'BG' and SPDM = '0623898'
 end 

 begin SQL,2025-12-13 14:02:29.953
 select SHSHOPID,SHOPDM from SHWY_SHOPDEF where SHDM = 'BG' and SHOPID = 639
 end 

 begin SQL,2025-12-13 14:02:29.953
 select c.SPFLDM,b.SHSBID,b.SHHTID  ,(select GHSDM from SHHT d where b.SHHTID = d.SHHTID) as GHSDM,b.SX_JJ,b.SX_NLD,b.SX_LW,b.SX_SEX  from SHSPXX b,SHSPFL c where b.SHSPFLID = c.SHSPFLID and b.SHSPID = 14283290
 end 

 begin SQL,2025-12-13 14:02:29.963
 select b.SHHTID  ,(select GHSDM from SHHT d where b.SHHTID = d.SHHTID) as GHSDM  from SHSPXX_HT b where b.SHSPID = 14283290 and b.MDID = 1
 end 

 begin SQL,2025-12-13 14:02:29.970
 select a.YHQID,a.SHBMDM,a.JLBH,a.YXCLBJ,a.RQ1,a.RQ2,a.CXID,a.XFLJFQFS,a.QDZKL from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX = 0    and :SJ1  between RQ1 and RQ2   and ((a.SHBMDM = ' ') or (instr('011201021009',rtrim(a.SHBMDM)) = 1))  and a.STATUS = 2  order by a.YHQID,a.SHBMDM desc,a.YXCLBJ desc,a.JLBH desc
 end 

 begin SQL,2025-12-13 14:02:29.970
 select a.SHBMDM,a.JLBH,a.YXCLBJ,a.RQ1,a.RQ2,a.CXID,a.XFLJMJFS,a.MJJQ,b.CXHDBH from CXMBJZDYD a,CXHDDEF b  where a.SHDM = 'BG' and a.CXID = b.CXID    and :SJ1  between RQ1 and RQ2   and ((a.SHBMDM = ' ') or (instr('011201021009',rtrim(a.SHBMDM)) = 1))  and a.STATUS = 2  order by a.SHBMDM desc,a.YXCLBJ desc,a.JLBH desc
 end 

 begin SQL,2025-12-13 14:02:29.970
 update BHZT set REC_NUM = REC_NUM+1 where TBLNAME = 'HYK_XFJL'
 end 

 begin SQL,2025-12-13 14:02:29.985
 select REC_NUM from BHZT where TBLNAME = 'HYK_XFJL'
 end 

 begin SQL,2025-12-13 14:02:29.985
 insert into HYK_XFJL(XFJLID, SHDM, MDID, SKTNO, JLBH, DJLX,XFJLID_OLD, HYID,HYID_FQ, SKYDM, JZRQ,XFSJ,XFRQ_FQ,SCSJ,STATUS,BJ_WZSP,JFBS,JF,JE,ZK,ZK_HY,PGRYID,VIPTYPE,HYKNO,HYKNO_FQ,FXDW,BSFS,XSSL,TDJFDYDBH,JF_CZZ,ORDER_NO,BJ_HTBSK) values(3372292,'BG',1,'010010',100070,0,0,0,0,'999999',:JZRQ,:XFSJ,:XFRQ_FQ,:SCSJ,0,0,0.00,0.0000,118.00,0.00,0.00,0,0,'','',0,0,2.0000,0,0.0000,:ORDER_NO,0)
 end 

 begin SQL,2025-12-13 14:02:29.985
 insert into HYK_XFJL_SP(XFJLID,INX,INX_OLD,SHSPID,SPDM,BMDM,BJ_JF,ZKDYDBH,ZKL,XSSL,XSJE,ZKJE,ZKJE_HY,BJ_BCJHD,BJ_BCJMJ,BJ_BCJYQ,JFDYDBH,JFJS,BJ_JFBS,BS,XSJE_JF,XSJE_FQ,JF,FTBL,JFFBGZ,JFDYDBH_CZZ,JFJS_CZZ,BJ_JFBS_CZZ,BS_CZZ,JF_CZZ,JFFBGZ_CZZ,SHOP_ID,SHSHOPID) values(3372292,0,-1,14283290,'0623898','011201021009',1,0,1.0000,2.0000,118.00,0.00,0.00,0,0,0,0,0,0,1.0000,118.00,118.00,0.0000,0.0000,0,0,0,0,1.0000,0.0000,0,639,0)
 end 

 begin SQL,2025-12-13 14:02:46.318
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-13 14:02:46.318
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-13 14:02:46.318
 select count(*) from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX in (0,2)    and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-13 14:02:46.318
 select count(*) from CXMBJZDYD a  where a.SHDM = 'BG'   and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-13 14:02:46.349
 select XFJLID,STATUS,XFJLID_OLD from HYK_XFJL where MDID = 1  and SKTNO = '010010'  and JLBH = 100071
 end 

 begin SQL,2025-12-13 14:02:46.349
 select XFJLID from HYXFJL where MDID = 1  and SKTNO = '010010'  and JLBH = 100071
 end 

 begin SQL,2025-12-13 14:02:46.349
 select SHSPID from SHSPXX_DM where SHDM = 'BG' and SPDM = '0623898'
 end 

 begin SQL,2025-12-13 14:02:46.349
 select SHSHOPID,SHOPDM from SHWY_SHOPDEF where SHDM = 'BG' and SHOPID = 639
 end 

 begin SQL,2025-12-13 14:02:46.365
 select c.SPFLDM,b.SHSBID,b.SHHTID  ,(select GHSDM from SHHT d where b.SHHTID = d.SHHTID) as GHSDM,b.SX_JJ,b.SX_NLD,b.SX_LW,b.SX_SEX  from SHSPXX b,SHSPFL c where b.SHSPFLID = c.SHSPFLID and b.SHSPID = 14283290
 end 

 begin SQL,2025-12-13 14:02:46.365
 select b.SHHTID  ,(select GHSDM from SHHT d where b.SHHTID = d.SHHTID) as GHSDM  from SHSPXX_HT b where b.SHSPID = 14283290 and b.MDID = 1
 end 

 begin SQL,2025-12-13 14:02:46.365
 select a.YHQID,a.SHBMDM,a.JLBH,a.YXCLBJ,a.RQ1,a.RQ2,a.CXID,a.XFLJFQFS,a.QDZKL from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX = 0    and :SJ1  between RQ1 and RQ2   and ((a.SHBMDM = ' ') or (instr('011201021009',rtrim(a.SHBMDM)) = 1))  and a.STATUS = 2  order by a.YHQID,a.SHBMDM desc,a.YXCLBJ desc,a.JLBH desc
 end 

 begin SQL,2025-12-13 14:02:46.365
 select a.SHBMDM,a.JLBH,a.YXCLBJ,a.RQ1,a.RQ2,a.CXID,a.XFLJMJFS,a.MJJQ,b.CXHDBH from CXMBJZDYD a,CXHDDEF b  where a.SHDM = 'BG' and a.CXID = b.CXID    and :SJ1  between RQ1 and RQ2   and ((a.SHBMDM = ' ') or (instr('011201021009',rtrim(a.SHBMDM)) = 1))  and a.STATUS = 2  order by a.SHBMDM desc,a.YXCLBJ desc,a.JLBH desc
 end 

 begin SQL,2025-12-13 14:02:46.365
 update BHZT set REC_NUM = REC_NUM+1 where TBLNAME = 'HYK_XFJL'
 end 

 begin SQL,2025-12-13 14:02:46.365
 select REC_NUM from BHZT where TBLNAME = 'HYK_XFJL'
 end 

 begin SQL,2025-12-13 14:02:46.365
 insert into HYK_XFJL(XFJLID, SHDM, MDID, SKTNO, JLBH, DJLX,XFJLID_OLD, HYID,HYID_FQ, SKYDM, JZRQ,XFSJ,XFRQ_FQ,SCSJ,STATUS,BJ_WZSP,JFBS,JF,JE,ZK,ZK_HY,PGRYID,VIPTYPE,HYKNO,HYKNO_FQ,FXDW,BSFS,XSSL,TDJFDYDBH,JF_CZZ,ORDER_NO,BJ_HTBSK) values(3372293,'BG',1,'010010',100071,0,0,0,0,'999999',:JZRQ,:XFSJ,:XFRQ_FQ,:SCSJ,0,0,0.00,0.0000,236.00,1239.00,0.00,0,0,'','',0,0,25.0000,0,0.0000,:ORDER_NO,0)
 end 

 begin SQL,2025-12-13 14:02:46.365
 insert into HYK_XFJL_SP(XFJLID,INX,INX_OLD,SHSPID,SPDM,BMDM,BJ_JF,ZKDYDBH,ZKL,XSSL,XSJE,ZKJE,ZKJE_HY,BJ_BCJHD,BJ_BCJMJ,BJ_BCJYQ,JFDYDBH,JFJS,BJ_JFBS,BS,XSJE_JF,XSJE_FQ,JF,FTBL,JFFBGZ,JFDYDBH_CZZ,JFJS_CZZ,BJ_JFBS_CZZ,BS_CZZ,JF_CZZ,JFFBGZ_CZZ,SHOP_ID,SHSHOPID) values(3372293,0,-1,14283290,'0623898','011201021009',1,0,1.0000,25.0000,236.00,1239.00,0.00,0,0,0,0,0,0,1.0000,236.00,236.00,0.0000,0.0000,0,0,0,0,1.0000,0.0000,0,639,0)
 end 

 begin SQL,2025-12-13 14:03:01.284
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-13 14:03:01.284
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-13 14:03:01.297
 select count(*) from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX in (0,2)    and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-13 14:03:01.297
 select count(*) from CXMBJZDYD a  where a.SHDM = 'BG'   and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-13 14:03:01.297
 select XFJLID,STATUS,XFJLID_OLD from HYK_XFJL where MDID = 1  and SKTNO = '010010'  and JLBH = 100072
 end 

 begin SQL,2025-12-13 14:03:01.297
 select XFJLID from HYXFJL where MDID = 1  and SKTNO = '010010'  and JLBH = 100072
 end 

 begin SQL,2025-12-13 14:03:01.316
 select SHSPID from SHSPXX_DM where SHDM = 'BG' and SPDM = '0623898'
 end 

 begin SQL,2025-12-13 14:03:01.316
 select SHSHOPID,SHOPDM from SHWY_SHOPDEF where SHDM = 'BG' and SHOPID = 639
 end 

 begin SQL,2025-12-13 14:03:01.316
 select c.SPFLDM,b.SHSBID,b.SHHTID  ,(select GHSDM from SHHT d where b.SHHTID = d.SHHTID) as GHSDM,b.SX_JJ,b.SX_NLD,b.SX_LW,b.SX_SEX  from SHSPXX b,SHSPFL c where b.SHSPFLID = c.SHSPFLID and b.SHSPID = 14283290
 end 

 begin SQL,2025-12-13 14:03:01.316
 select b.SHHTID  ,(select GHSDM from SHHT d where b.SHHTID = d.SHHTID) as GHSDM  from SHSPXX_HT b where b.SHSPID = 14283290 and b.MDID = 1
 end 

 begin SQL,2025-12-13 14:03:01.324
 select a.YHQID,a.SHBMDM,a.JLBH,a.YXCLBJ,a.RQ1,a.RQ2,a.CXID,a.XFLJFQFS,a.QDZKL from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX = 0    and :SJ1  between RQ1 and RQ2   and ((a.SHBMDM = ' ') or (instr('011201021009',rtrim(a.SHBMDM)) = 1))  and a.STATUS = 2  order by a.YHQID,a.SHBMDM desc,a.YXCLBJ desc,a.JLBH desc
 end 

 begin SQL,2025-12-13 14:03:01.324
 select a.SHBMDM,a.JLBH,a.YXCLBJ,a.RQ1,a.RQ2,a.CXID,a.XFLJMJFS,a.MJJQ,b.CXHDBH from CXMBJZDYD a,CXHDDEF b  where a.SHDM = 'BG' and a.CXID = b.CXID    and :SJ1  between RQ1 and RQ2   and ((a.SHBMDM = ' ') or (instr('011201021009',rtrim(a.SHBMDM)) = 1))  and a.STATUS = 2  order by a.SHBMDM desc,a.YXCLBJ desc,a.JLBH desc
 end 

 begin SQL,2025-12-13 14:03:01.324
 update BHZT set REC_NUM = REC_NUM+1 where TBLNAME = 'HYK_XFJL'
 end 

 begin SQL,2025-12-13 14:03:01.324
 select REC_NUM from BHZT where TBLNAME = 'HYK_XFJL'
 end 

 begin SQL,2025-12-13 14:03:01.324
 insert into HYK_XFJL(XFJLID, SHDM, MDID, SKTNO, JLBH, DJLX,XFJLID_OLD, HYID,HYID_FQ, SKYDM, JZRQ,XFSJ,XFRQ_FQ,SCSJ,STATUS,BJ_WZSP,JFBS,JF,JE,ZK,ZK_HY,PGRYID,VIPTYPE,HYKNO,HYKNO_FQ,FXDW,BSFS,XSSL,TDJFDYDBH,JF_CZZ,ORDER_NO,BJ_HTBSK) values(3372294,'BG',1,'010010',100072,0,0,0,0,'999999',:JZRQ,:XFSJ,:XFRQ_FQ,:SCSJ,0,0,0.00,0.0000,236.00,59.00,0.00,0,0,'','',0,0,5.0000,0,0.0000,:ORDER_NO,0)
 end 

 begin SQL,2025-12-13 14:03:01.324
 insert into HYK_XFJL_SP(XFJLID,INX,INX_OLD,SHSPID,SPDM,BMDM,BJ_JF,ZKDYDBH,ZKL,XSSL,XSJE,ZKJE,ZKJE_HY,BJ_BCJHD,BJ_BCJMJ,BJ_BCJYQ,JFDYDBH,JFJS,BJ_JFBS,BS,XSJE_JF,XSJE_FQ,JF,FTBL,JFFBGZ,JFDYDBH_CZZ,JFJS_CZZ,BJ_JFBS_CZZ,BS_CZZ,JF_CZZ,JFFBGZ_CZZ,SHOP_ID,SHSHOPID) values(3372294,0,-1,14283290,'0623898','011201021009',1,0,1.0000,5.0000,236.00,59.00,0.00,0,0,0,0,0,0,1.0000,236.00,236.00,0.0000,0.0000,0,0,0,0,1.0000,0.0000,0,639,0)
 end 

 begin SQL,2025-12-13 14:03:19.689
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-13 14:03:19.689
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-13 14:03:19.689
 select count(*) from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX in (0,2)    and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-13 14:03:19.689
 select count(*) from CXMBJZDYD a  where a.SHDM = 'BG'   and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-13 14:03:19.705
 select XFJLID,STATUS,XFJLID_OLD from HYK_XFJL where MDID = 1  and SKTNO = '010010'  and JLBH = 100073
 end 

 begin SQL,2025-12-13 14:03:19.705
 select XFJLID from HYXFJL where MDID = 1  and SKTNO = '010010'  and JLBH = 100073
 end 

 begin SQL,2025-12-13 14:03:19.705
 select SHSPID from SHSPXX_DM where SHDM = 'BG' and SPDM = '0623898'
 end 

 begin SQL,2025-12-13 14:03:19.705
 select SHSHOPID,SHOPDM from SHWY_SHOPDEF where SHDM = 'BG' and SHOPID = 639
 end 

 begin SQL,2025-12-13 14:03:19.705
 select c.SPFLDM,b.SHSBID,b.SHHTID  ,(select GHSDM from SHHT d where b.SHHTID = d.SHHTID) as GHSDM,b.SX_JJ,b.SX_NLD,b.SX_LW,b.SX_SEX  from SHSPXX b,SHSPFL c where b.SHSPFLID = c.SHSPFLID and b.SHSPID = 14283290
 end 

 begin SQL,2025-12-13 14:03:19.705
 select b.SHHTID  ,(select GHSDM from SHHT d where b.SHHTID = d.SHHTID) as GHSDM  from SHSPXX_HT b where b.SHSPID = 14283290 and b.MDID = 1
 end 

 begin SQL,2025-12-13 14:03:19.705
 select a.YHQID,a.SHBMDM,a.JLBH,a.YXCLBJ,a.RQ1,a.RQ2,a.CXID,a.XFLJFQFS,a.QDZKL from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX = 0    and :SJ1  between RQ1 and RQ2   and ((a.SHBMDM = ' ') or (instr('011201021009',rtrim(a.SHBMDM)) = 1))  and a.STATUS = 2  order by a.YHQID,a.SHBMDM desc,a.YXCLBJ desc,a.JLBH desc
 end 

 begin SQL,2025-12-13 14:03:19.705
 select a.SHBMDM,a.JLBH,a.YXCLBJ,a.RQ1,a.RQ2,a.CXID,a.XFLJMJFS,a.MJJQ,b.CXHDBH from CXMBJZDYD a,CXHDDEF b  where a.SHDM = 'BG' and a.CXID = b.CXID    and :SJ1  between RQ1 and RQ2   and ((a.SHBMDM = ' ') or (instr('011201021009',rtrim(a.SHBMDM)) = 1))  and a.STATUS = 2  order by a.SHBMDM desc,a.YXCLBJ desc,a.JLBH desc
 end 

 begin SQL,2025-12-13 14:03:19.705
 update BHZT set REC_NUM = REC_NUM+1 where TBLNAME = 'HYK_XFJL'
 end 

 begin SQL,2025-12-13 14:03:19.705
 select REC_NUM from BHZT where TBLNAME = 'HYK_XFJL'
 end 

 begin SQL,2025-12-13 14:03:19.705
 insert into HYK_XFJL(XFJLID, SHDM, MDID, SKTNO, JLBH, DJLX,XFJLID_OLD, HYID,HYID_FQ, SKYDM, JZRQ,XFSJ,XFRQ_FQ,SCSJ,STATUS,BJ_WZSP,JFBS,JF,JE,ZK,ZK_HY,PGRYID,VIPTYPE,HYKNO,HYKNO_FQ,FXDW,BSFS,XSSL,TDJFDYDBH,JF_CZZ,ORDER_NO,BJ_HTBSK) values(3372295,'BG',1,'010010',100073,0,0,0,0,'999999',:JZRQ,:XFSJ,:XFRQ_FQ,:SCSJ,0,0,0.00,0.0000,236.00,118.00,0.00,0,0,'','',0,0,6.0000,0,0.0000,:ORDER_NO,0)
 end 

 begin SQL,2025-12-13 14:03:19.720
 insert into HYK_XFJL_SP(XFJLID,INX,INX_OLD,SHSPID,SPDM,BMDM,BJ_JF,ZKDYDBH,ZKL,XSSL,XSJE,ZKJE,ZKJE_HY,BJ_BCJHD,BJ_BCJMJ,BJ_BCJYQ,JFDYDBH,JFJS,BJ_JFBS,BS,XSJE_JF,XSJE_FQ,JF,FTBL,JFFBGZ,JFDYDBH_CZZ,JFJS_CZZ,BJ_JFBS_CZZ,BS_CZZ,JF_CZZ,JFFBGZ_CZZ,SHOP_ID,SHSHOPID) values(3372295,0,-1,14283290,'0623898','011201021009',1,0,1.0000,6.0000,236.00,118.00,0.00,0,0,0,0,0,0,1.0000,236.00,236.00,0.0000,0.0000,0,0,0,0,1.0000,0.0000,0,639,0)
 end 

 begin SQL,2025-12-13 14:03:35.277
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-13 14:03:35.277
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-13 14:03:35.277
 select count(*) from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX in (0,2)    and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-13 14:03:35.277
 select count(*) from CXMBJZDYD a  where a.SHDM = 'BG'   and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-13 14:03:35.293
 select XFJLID,STATUS,XFJLID_OLD from HYK_XFJL where MDID = 1  and SKTNO = '010010'  and JLBH = 100074
 end 

 begin SQL,2025-12-13 14:03:35.293
 select XFJLID from HYXFJL where MDID = 1  and SKTNO = '010010'  and JLBH = 100074
 end 

 begin SQL,2025-12-13 14:03:35.296
 select SHSPID from SHSPXX_DM where SHDM = 'BG' and SPDM = '0623898'
 end 

 begin SQL,2025-12-13 14:03:35.296
 select SHSHOPID,SHOPDM from SHWY_SHOPDEF where SHDM = 'BG' and SHOPID = 639
 end 

 begin SQL,2025-12-13 14:03:35.296
 select c.SPFLDM,b.SHSBID,b.SHHTID  ,(select GHSDM from SHHT d where b.SHHTID = d.SHHTID) as GHSDM,b.SX_JJ,b.SX_NLD,b.SX_LW,b.SX_SEX  from SHSPXX b,SHSPFL c where b.SHSPFLID = c.SHSPFLID and b.SHSPID = 14283290
 end 

 begin SQL,2025-12-13 14:03:35.296
 select b.SHHTID  ,(select GHSDM from SHHT d where b.SHHTID = d.SHHTID) as GHSDM  from SHSPXX_HT b where b.SHSPID = 14283290 and b.MDID = 1
 end 

 begin SQL,2025-12-13 14:03:35.296
 select a.YHQID,a.SHBMDM,a.JLBH,a.YXCLBJ,a.RQ1,a.RQ2,a.CXID,a.XFLJFQFS,a.QDZKL from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX = 0    and :SJ1  between RQ1 and RQ2   and ((a.SHBMDM = ' ') or (instr('011201021009',rtrim(a.SHBMDM)) = 1))  and a.STATUS = 2  order by a.YHQID,a.SHBMDM desc,a.YXCLBJ desc,a.JLBH desc
 end 

 begin SQL,2025-12-13 14:03:35.296
 select a.SHBMDM,a.JLBH,a.YXCLBJ,a.RQ1,a.RQ2,a.CXID,a.XFLJMJFS,a.MJJQ,b.CXHDBH from CXMBJZDYD a,CXHDDEF b  where a.SHDM = 'BG' and a.CXID = b.CXID    and :SJ1  between RQ1 and RQ2   and ((a.SHBMDM = ' ') or (instr('011201021009',rtrim(a.SHBMDM)) = 1))  and a.STATUS = 2  order by a.SHBMDM desc,a.YXCLBJ desc,a.JLBH desc
 end 

 begin SQL,2025-12-13 14:03:35.296
 update BHZT set REC_NUM = REC_NUM+1 where TBLNAME = 'HYK_XFJL'
 end 

 begin SQL,2025-12-13 14:03:35.296
 select REC_NUM from BHZT where TBLNAME = 'HYK_XFJL'
 end 

 begin SQL,2025-12-13 14:03:35.296
 insert into HYK_XFJL(XFJLID, SHDM, MDID, SKTNO, JLBH, DJLX,XFJLID_OLD, HYID,HYID_FQ, SKYDM, JZRQ,XFSJ,XFRQ_FQ,SCSJ,STATUS,BJ_WZSP,JFBS,JF,JE,ZK,ZK_HY,PGRYID,VIPTYPE,HYKNO,HYKNO_FQ,FXDW,BSFS,XSSL,TDJFDYDBH,JF_CZZ,ORDER_NO,BJ_HTBSK) values(3372296,'BG',1,'010010',100074,0,0,0,0,'999999',:JZRQ,:XFSJ,:XFRQ_FQ,:SCSJ,0,0,0.00,0.0000,236.00,354.00,0.00,0,0,'','',0,0,10.0000,0,0.0000,:ORDER_NO,0)
 end 

 begin SQL,2025-12-13 14:03:35.303
 insert into HYK_XFJL_SP(XFJLID,INX,INX_OLD,SHSPID,SPDM,BMDM,BJ_JF,ZKDYDBH,ZKL,XSSL,XSJE,ZKJE,ZKJE_HY,BJ_BCJHD,BJ_BCJMJ,BJ_BCJYQ,JFDYDBH,JFJS,BJ_JFBS,BS,XSJE_JF,XSJE_FQ,JF,FTBL,JFFBGZ,JFDYDBH_CZZ,JFJS_CZZ,BJ_JFBS_CZZ,BS_CZZ,JF_CZZ,JFFBGZ_CZZ,SHOP_ID,SHSHOPID) values(3372296,0,-1,14283290,'0623898','011201021009',1,0,1.0000,10.0000,236.00,354.00,0.00,0,0,0,0,0,0,1.0000,236.00,236.00,0.0000,0.0000,0,0,0,0,1.0000,0.0000,0,639,0)
 end 

 begin SQL,2025-12-13 14:05:43.911
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-13 14:05:43.911
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-13 14:05:43.911
 select count(*) from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX in (0,2)    and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-13 14:05:43.911
 select count(*) from CXMBJZDYD a  where a.SHDM = 'BG'   and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-13 14:05:43.911
 select XFJLID,STATUS,XFJLID_OLD from HYK_XFJL where MDID = 1  and SKTNO = '010010'  and JLBH = 100075
 end 

 begin SQL,2025-12-13 14:05:43.911
 select XFJLID from HYXFJL where MDID = 1  and SKTNO = '010010'  and JLBH = 100075
 end 

 begin SQL,2025-12-13 14:05:43.927
 select SHSPID from SHSPXX_DM where SHDM = 'BG' and SPDM = '0623898'
 end 

 begin SQL,2025-12-13 14:05:43.927
 select SHSHOPID,SHOPDM from SHWY_SHOPDEF where SHDM = 'BG' and SHOPID = 639
 end 

 begin SQL,2025-12-13 14:05:43.927
 select c.SPFLDM,b.SHSBID,b.SHHTID  ,(select GHSDM from SHHT d where b.SHHTID = d.SHHTID) as GHSDM,b.SX_JJ,b.SX_NLD,b.SX_LW,b.SX_SEX  from SHSPXX b,SHSPFL c where b.SHSPFLID = c.SHSPFLID and b.SHSPID = 14283290
 end 

 begin SQL,2025-12-13 14:05:43.927
 select b.SHHTID  ,(select GHSDM from SHHT d where b.SHHTID = d.SHHTID) as GHSDM  from SHSPXX_HT b where b.SHSPID = 14283290 and b.MDID = 1
 end 

 begin SQL,2025-12-13 14:05:43.929
 select a.YHQID,a.SHBMDM,a.JLBH,a.YXCLBJ,a.RQ1,a.RQ2,a.CXID,a.XFLJFQFS,a.QDZKL from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX = 0    and :SJ1  between RQ1 and RQ2   and ((a.SHBMDM = ' ') or (instr('011201021009',rtrim(a.SHBMDM)) = 1))  and a.STATUS = 2  order by a.YHQID,a.SHBMDM desc,a.YXCLBJ desc,a.JLBH desc
 end 

 begin SQL,2025-12-13 14:05:43.930
 select a.SHBMDM,a.JLBH,a.YXCLBJ,a.RQ1,a.RQ2,a.CXID,a.XFLJMJFS,a.MJJQ,b.CXHDBH from CXMBJZDYD a,CXHDDEF b  where a.SHDM = 'BG' and a.CXID = b.CXID    and :SJ1  between RQ1 and RQ2   and ((a.SHBMDM = ' ') or (instr('011201021009',rtrim(a.SHBMDM)) = 1))  and a.STATUS = 2  order by a.SHBMDM desc,a.YXCLBJ desc,a.JLBH desc
 end 

 begin SQL,2025-12-13 14:05:43.930
 update BHZT set REC_NUM = REC_NUM+1 where TBLNAME = 'HYK_XFJL'
 end 

 begin SQL,2025-12-13 14:05:43.930
 select REC_NUM from BHZT where TBLNAME = 'HYK_XFJL'
 end 

 begin SQL,2025-12-13 14:05:43.930
 insert into HYK_XFJL(XFJLID, SHDM, MDID, SKTNO, JLBH, DJLX,XFJLID_OLD, HYID,HYID_FQ, SKYDM, JZRQ,XFSJ,XFRQ_FQ,SCSJ,STATUS,BJ_WZSP,JFBS,JF,JE,ZK,ZK_HY,PGRYID,VIPTYPE,HYKNO,HYKNO_FQ,FXDW,BSFS,XSSL,TDJFDYDBH,JF_CZZ,ORDER_NO,BJ_HTBSK) values(3372297,'BG',1,'010010',100075,0,0,0,0,'999999',:JZRQ,:XFSJ,:XFRQ_FQ,:SCSJ,0,0,0.00,0.0000,236.00,354.00,0.00,0,0,'','',0,0,10.0000,0,0.0000,:ORDER_NO,0)
 end 

 begin SQL,2025-12-13 14:05:43.930
 insert into HYK_XFJL_SP(XFJLID,INX,INX_OLD,SHSPID,SPDM,BMDM,BJ_JF,ZKDYDBH,ZKL,XSSL,XSJE,ZKJE,ZKJE_HY,BJ_BCJHD,BJ_BCJMJ,BJ_BCJYQ,JFDYDBH,JFJS,BJ_JFBS,BS,XSJE_JF,XSJE_FQ,JF,FTBL,JFFBGZ,JFDYDBH_CZZ,JFJS_CZZ,BJ_JFBS_CZZ,BS_CZZ,JF_CZZ,JFFBGZ_CZZ,SHOP_ID,SHSHOPID) values(3372297,0,-1,14283290,'0623898','011201021009',1,0,1.0000,10.0000,236.00,354.00,0.00,0,0,0,0,0,0,1.0000,236.00,236.00,0.0000,0.0000,0,0,0,0,1.0000,0.0000,0,639,0)
 end 

 begin SQL,2025-12-13 14:05:49.416
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-13 14:05:49.416
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-13 14:05:49.432
 select count(*) from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX in (0,2)    and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-13 14:05:49.432
 select count(*) from CXMBJZDYD a  where a.SHDM = 'BG'   and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-13 14:05:49.443
 select XFJLID,STATUS,XFJLID_OLD from HYK_XFJL where MDID = 1  and SKTNO = '010010'  and JLBH = 100076
 end 

 begin SQL,2025-12-13 14:05:49.446
 select XFJLID from HYXFJL where MDID = 1  and SKTNO = '010010'  and JLBH = 100076
 end 

 begin SQL,2025-12-13 14:05:49.448
 select SHSPID from SHSPXX_DM where SHDM = 'BG' and SPDM = '0623898'
 end 

 begin SQL,2025-12-13 14:05:49.448
 select SHSHOPID,SHOPDM from SHWY_SHOPDEF where SHDM = 'BG' and SHOPID = 639
 end 

 begin SQL,2025-12-13 14:05:49.449
 select c.SPFLDM,b.SHSBID,b.SHHTID  ,(select GHSDM from SHHT d where b.SHHTID = d.SHHTID) as GHSDM,b.SX_JJ,b.SX_NLD,b.SX_LW,b.SX_SEX  from SHSPXX b,SHSPFL c where b.SHSPFLID = c.SHSPFLID and b.SHSPID = 14283290
 end 

 begin SQL,2025-12-13 14:05:49.449
 select b.SHHTID  ,(select GHSDM from SHHT d where b.SHHTID = d.SHHTID) as GHSDM  from SHSPXX_HT b where b.SHSPID = 14283290 and b.MDID = 1
 end 

 begin SQL,2025-12-13 14:05:49.450
 select a.YHQID,a.SHBMDM,a.JLBH,a.YXCLBJ,a.RQ1,a.RQ2,a.CXID,a.XFLJFQFS,a.QDZKL from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX = 0    and :SJ1  between RQ1 and RQ2   and ((a.SHBMDM = ' ') or (instr('011201021009',rtrim(a.SHBMDM)) = 1))  and a.STATUS = 2  order by a.YHQID,a.SHBMDM desc,a.YXCLBJ desc,a.JLBH desc
 end 

 begin SQL,2025-12-13 14:05:49.451
 select a.SHBMDM,a.JLBH,a.YXCLBJ,a.RQ1,a.RQ2,a.CXID,a.XFLJMJFS,a.MJJQ,b.CXHDBH from CXMBJZDYD a,CXHDDEF b  where a.SHDM = 'BG' and a.CXID = b.CXID    and :SJ1  between RQ1 and RQ2   and ((a.SHBMDM = ' ') or (instr('011201021009',rtrim(a.SHBMDM)) = 1))  and a.STATUS = 2  order by a.SHBMDM desc,a.YXCLBJ desc,a.JLBH desc
 end 

 begin SQL,2025-12-13 14:05:49.451
 update BHZT set REC_NUM = REC_NUM+1 where TBLNAME = 'HYK_XFJL'
 end 

 begin SQL,2025-12-13 14:05:49.451
 select REC_NUM from BHZT where TBLNAME = 'HYK_XFJL'
 end 

 begin SQL,2025-12-13 14:05:49.452
 insert into HYK_XFJL(XFJLID, SHDM, MDID, SKTNO, JLBH, DJLX,XFJLID_OLD, HYID,HYID_FQ, SKYDM, JZRQ,XFSJ,XFRQ_FQ,SCSJ,STATUS,BJ_WZSP,JFBS,JF,JE,ZK,ZK_HY,PGRYID,VIPTYPE,HYKNO,HYKNO_FQ,FXDW,BSFS,XSSL,TDJFDYDBH,JF_CZZ,ORDER_NO,BJ_HTBSK) values(3372298,'BG',1,'010010',100076,0,0,0,0,'999999',:JZRQ,:XFSJ,:XFRQ_FQ,:SCSJ,0,0,0.00,0.0000,236.00,354.00,0.00,0,0,'','',0,0,10.0000,0,0.0000,:ORDER_NO,0)
 end 

 begin SQL,2025-12-13 14:05:49.454
 insert into HYK_XFJL_SP(XFJLID,INX,INX_OLD,SHSPID,SPDM,BMDM,BJ_JF,ZKDYDBH,ZKL,XSSL,XSJE,ZKJE,ZKJE_HY,BJ_BCJHD,BJ_BCJMJ,BJ_BCJYQ,JFDYDBH,JFJS,BJ_JFBS,BS,XSJE_JF,XSJE_FQ,JF,FTBL,JFFBGZ,JFDYDBH_CZZ,JFJS_CZZ,BJ_JFBS_CZZ,BS_CZZ,JF_CZZ,JFFBGZ_CZZ,SHOP_ID,SHSHOPID) values(3372298,0,-1,14283290,'0623898','011201021009',1,0,1.0000,10.0000,236.00,354.00,0.00,0,0,0,0,0,0,1.0000,236.00,236.00,0.0000,0.0000,0,0,0,0,1.0000,0.0000,0,639,0)
 end 

 begin SQL,2025-12-13 14:06:09.542
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-13 14:06:09.542
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-13 14:06:09.542
 select count(*) from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX in (0,2)    and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-13 14:06:09.542
 select count(*) from CXMBJZDYD a  where a.SHDM = 'BG'   and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-13 14:06:09.557
 select XFJLID,STATUS,XFJLID_OLD from HYK_XFJL where MDID = 1  and SKTNO = '010010'  and JLBH = 100077
 end 

 begin SQL,2025-12-13 14:06:09.557
 select XFJLID from HYXFJL where MDID = 1  and SKTNO = '010010'  and JLBH = 100077
 end 

 begin SQL,2025-12-13 14:06:09.557
 select SHSPID from SHSPXX_DM where SHDM = 'BG' and SPDM = '0623898'
 end 

 begin SQL,2025-12-13 14:06:09.573
 select SHSHOPID,SHOPDM from SHWY_SHOPDEF where SHDM = 'BG' and SHOPID = 639
 end 

 begin SQL,2025-12-13 14:06:09.573
 select c.SPFLDM,b.SHSBID,b.SHHTID  ,(select GHSDM from SHHT d where b.SHHTID = d.SHHTID) as GHSDM,b.SX_JJ,b.SX_NLD,b.SX_LW,b.SX_SEX  from SHSPXX b,SHSPFL c where b.SHSPFLID = c.SHSPFLID and b.SHSPID = 14283290
 end 

 begin SQL,2025-12-13 14:06:09.573
 select b.SHHTID  ,(select GHSDM from SHHT d where b.SHHTID = d.SHHTID) as GHSDM  from SHSPXX_HT b where b.SHSPID = 14283290 and b.MDID = 1
 end 

 begin SQL,2025-12-13 14:06:09.573
 select a.YHQID,a.SHBMDM,a.JLBH,a.YXCLBJ,a.RQ1,a.RQ2,a.CXID,a.XFLJFQFS,a.QDZKL from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX = 0    and :SJ1  between RQ1 and RQ2   and ((a.SHBMDM = ' ') or (instr('011201021009',rtrim(a.SHBMDM)) = 1))  and a.STATUS = 2  order by a.YHQID,a.SHBMDM desc,a.YXCLBJ desc,a.JLBH desc
 end 

 begin SQL,2025-12-13 14:06:09.573
 select a.SHBMDM,a.JLBH,a.YXCLBJ,a.RQ1,a.RQ2,a.CXID,a.XFLJMJFS,a.MJJQ,b.CXHDBH from CXMBJZDYD a,CXHDDEF b  where a.SHDM = 'BG' and a.CXID = b.CXID    and :SJ1  between RQ1 and RQ2   and ((a.SHBMDM = ' ') or (instr('011201021009',rtrim(a.SHBMDM)) = 1))  and a.STATUS = 2  order by a.SHBMDM desc,a.YXCLBJ desc,a.JLBH desc
 end 

 begin SQL,2025-12-13 14:06:09.573
 update BHZT set REC_NUM = REC_NUM+1 where TBLNAME = 'HYK_XFJL'
 end 

 begin SQL,2025-12-13 14:06:09.573
 select REC_NUM from BHZT where TBLNAME = 'HYK_XFJL'
 end 

 begin SQL,2025-12-13 14:06:09.573
 insert into HYK_XFJL(XFJLID, SHDM, MDID, SKTNO, JLBH, DJLX,XFJLID_OLD, HYID,HYID_FQ, SKYDM, JZRQ,XFSJ,XFRQ_FQ,SCSJ,STATUS,BJ_WZSP,JFBS,JF,JE,ZK,ZK_HY,PGRYID,VIPTYPE,HYKNO,HYKNO_FQ,FXDW,BSFS,XSSL,TDJFDYDBH,JF_CZZ,ORDER_NO,BJ_HTBSK) values(3372299,'BG',1,'010010',100077,0,0,0,0,'999999',:JZRQ,:XFSJ,:XFRQ_FQ,:SCSJ,0,0,0.00,0.0000,236.00,649.00,0.00,0,0,'','',0,0,15.0000,0,0.0000,:ORDER_NO,0)
 end 

 begin SQL,2025-12-13 14:06:09.573
 insert into HYK_XFJL_SP(XFJLID,INX,INX_OLD,SHSPID,SPDM,BMDM,BJ_JF,ZKDYDBH,ZKL,XSSL,XSJE,ZKJE,ZKJE_HY,BJ_BCJHD,BJ_BCJMJ,BJ_BCJYQ,JFDYDBH,JFJS,BJ_JFBS,BS,XSJE_JF,XSJE_FQ,JF,FTBL,JFFBGZ,JFDYDBH_CZZ,JFJS_CZZ,BJ_JFBS_CZZ,BS_CZZ,JF_CZZ,JFFBGZ_CZZ,SHOP_ID,SHSHOPID) values(3372299,0,-1,14283290,'0623898','011201021009',1,0,1.0000,15.0000,236.00,649.00,0.00,0,0,0,0,0,0,1.0000,236.00,236.00,0.0000,0.0000,0,0,0,0,1.0000,0.0000,0,639,0)
 end 

 begin SQL,2025-12-13 14:06:33.079
 select JYID from MZK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-13 14:06:33.079
 select JYID from HYK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-13 14:08:37.488
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-13 14:08:37.488
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-13 14:08:37.488
 select count(*) from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX in (0,2)    and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-13 14:08:37.488
 select count(*) from CXMBJZDYD a  where a.SHDM = 'BG'   and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-13 14:08:37.503
 select XFJLID,STATUS,XFJLID_OLD from HYK_XFJL where MDID = 1  and SKTNO = '010010'  and JLBH = 100078
 end 

 begin SQL,2025-12-13 14:08:37.503
 select XFJLID from HYXFJL where MDID = 1  and SKTNO = '010010'  and JLBH = 100078
 end 

 begin SQL,2025-12-13 14:08:37.503
 select SHSPID from SHSPXX_DM where SHDM = 'BG' and SPDM = '0623898'
 end 

 begin SQL,2025-12-13 14:08:37.503
 select SHSHOPID,SHOPDM from SHWY_SHOPDEF where SHDM = 'BG' and SHOPID = 639
 end 

 begin SQL,2025-12-13 14:08:37.503
 select c.SPFLDM,b.SHSBID,b.SHHTID  ,(select GHSDM from SHHT d where b.SHHTID = d.SHHTID) as GHSDM,b.SX_JJ,b.SX_NLD,b.SX_LW,b.SX_SEX  from SHSPXX b,SHSPFL c where b.SHSPFLID = c.SHSPFLID and b.SHSPID = 14283290
 end 

 begin SQL,2025-12-13 14:08:37.503
 select b.SHHTID  ,(select GHSDM from SHHT d where b.SHHTID = d.SHHTID) as GHSDM  from SHSPXX_HT b where b.SHSPID = 14283290 and b.MDID = 1
 end 

 begin SQL,2025-12-13 14:08:37.503
 select a.YHQID,a.SHBMDM,a.JLBH,a.YXCLBJ,a.RQ1,a.RQ2,a.CXID,a.XFLJFQFS,a.QDZKL from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX = 0    and :SJ1  between RQ1 and RQ2   and ((a.SHBMDM = ' ') or (instr('011201021009',rtrim(a.SHBMDM)) = 1))  and a.STATUS = 2  order by a.YHQID,a.SHBMDM desc,a.YXCLBJ desc,a.JLBH desc
 end 

 begin SQL,2025-12-13 14:08:37.503
 select a.SHBMDM,a.JLBH,a.YXCLBJ,a.RQ1,a.RQ2,a.CXID,a.XFLJMJFS,a.MJJQ,b.CXHDBH from CXMBJZDYD a,CXHDDEF b  where a.SHDM = 'BG' and a.CXID = b.CXID    and :SJ1  between RQ1 and RQ2   and ((a.SHBMDM = ' ') or (instr('011201021009',rtrim(a.SHBMDM)) = 1))  and a.STATUS = 2  order by a.SHBMDM desc,a.YXCLBJ desc,a.JLBH desc
 end 

 begin SQL,2025-12-13 14:08:37.550
 update BHZT set REC_NUM = REC_NUM+1 where TBLNAME = 'HYK_XFJL'
 end 

 begin SQL,2025-12-13 14:08:37.550
 select REC_NUM from BHZT where TBLNAME = 'HYK_XFJL'
 end 

 begin SQL,2025-12-13 14:08:37.566
 insert into HYK_XFJL(XFJLID, SHDM, MDID, SKTNO, JLBH, DJLX,XFJLID_OLD, HYID,HYID_FQ, SKYDM, JZRQ,XFSJ,XFRQ_FQ,SCSJ,STATUS,BJ_WZSP,JFBS,JF,JE,ZK,ZK_HY,PGRYID,VIPTYPE,HYKNO,HYKNO_FQ,FXDW,BSFS,XSSL,TDJFDYDBH,JF_CZZ,ORDER_NO,BJ_HTBSK) values(3372300,'BG',1,'010010',100078,0,0,0,0,'999999',:JZRQ,:XFSJ,:XFRQ_FQ,:SCSJ,0,0,0.00,0.0000,708.00,177.00,0.00,0,0,'','',0,0,15.0000,0,0.0000,:ORDER_NO,0)
 end 

 begin SQL,2025-12-13 14:08:37.566
 insert into HYK_XFJL_SP(XFJLID,INX,INX_OLD,SHSPID,SPDM,BMDM,BJ_JF,ZKDYDBH,ZKL,XSSL,XSJE,ZKJE,ZKJE_HY,BJ_BCJHD,BJ_BCJMJ,BJ_BCJYQ,JFDYDBH,JFJS,BJ_JFBS,BS,XSJE_JF,XSJE_FQ,JF,FTBL,JFFBGZ,JFDYDBH_CZZ,JFJS_CZZ,BJ_JFBS_CZZ,BS_CZZ,JF_CZZ,JFFBGZ_CZZ,SHOP_ID,SHSHOPID) values(3372300,0,-1,14283290,'0623898','011201021009',1,0,1.0000,15.0000,708.00,177.00,0.00,0,0,0,0,0,0,1.0000,708.00,708.00,0.0000,0.0000,0,0,0,0,1.0000,0.0000,0,639,0)
 end 

 begin SQL,2025-12-13 14:08:56.986
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-13 14:08:56.986
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-13 14:08:56.986
 select count(*) from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX in (0,2)    and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-13 14:08:56.986
 select count(*) from CXMBJZDYD a  where a.SHDM = 'BG'   and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-13 14:08:56.986
 select XFJLID,STATUS,XFJLID_OLD from HYK_XFJL where MDID = 1  and SKTNO = '010010'  and JLBH = 100079
 end 

 begin SQL,2025-12-13 14:08:57.001
 select XFJLID from HYXFJL where MDID = 1  and SKTNO = '010010'  and JLBH = 100079
 end 

 begin SQL,2025-12-13 14:08:57.001
 select SHSPID from SHSPXX_DM where SHDM = 'BG' and SPDM = '0623898'
 end 

 begin SQL,2025-12-13 14:08:57.001
 select SHSHOPID,SHOPDM from SHWY_SHOPDEF where SHDM = 'BG' and SHOPID = 639
 end 

 begin SQL,2025-12-13 14:08:57.001
 select c.SPFLDM,b.SHSBID,b.SHHTID  ,(select GHSDM from SHHT d where b.SHHTID = d.SHHTID) as GHSDM,b.SX_JJ,b.SX_NLD,b.SX_LW,b.SX_SEX  from SHSPXX b,SHSPFL c where b.SHSPFLID = c.SHSPFLID and b.SHSPID = 14283290
 end 

 begin SQL,2025-12-13 14:08:57.006
 select b.SHHTID  ,(select GHSDM from SHHT d where b.SHHTID = d.SHHTID) as GHSDM  from SHSPXX_HT b where b.SHSPID = 14283290 and b.MDID = 1
 end 

 begin SQL,2025-12-13 14:08:57.006
 select a.YHQID,a.SHBMDM,a.JLBH,a.YXCLBJ,a.RQ1,a.RQ2,a.CXID,a.XFLJFQFS,a.QDZKL from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX = 0    and :SJ1  between RQ1 and RQ2   and ((a.SHBMDM = ' ') or (instr('011201021009',rtrim(a.SHBMDM)) = 1))  and a.STATUS = 2  order by a.YHQID,a.SHBMDM desc,a.YXCLBJ desc,a.JLBH desc
 end 

 begin SQL,2025-12-13 14:08:57.006
 select a.SHBMDM,a.JLBH,a.YXCLBJ,a.RQ1,a.RQ2,a.CXID,a.XFLJMJFS,a.MJJQ,b.CXHDBH from CXMBJZDYD a,CXHDDEF b  where a.SHDM = 'BG' and a.CXID = b.CXID    and :SJ1  between RQ1 and RQ2   and ((a.SHBMDM = ' ') or (instr('011201021009',rtrim(a.SHBMDM)) = 1))  and a.STATUS = 2  order by a.SHBMDM desc,a.YXCLBJ desc,a.JLBH desc
 end 

 begin SQL,2025-12-13 14:08:57.006
 update BHZT set REC_NUM = REC_NUM+1 where TBLNAME = 'HYK_XFJL'
 end 

 begin SQL,2025-12-13 14:08:57.006
 select REC_NUM from BHZT where TBLNAME = 'HYK_XFJL'
 end 

 begin SQL,2025-12-13 14:08:57.006
 insert into HYK_XFJL(XFJLID, SHDM, MDID, SKTNO, JLBH, DJLX,XFJLID_OLD, HYID,HYID_FQ, SKYDM, JZRQ,XFSJ,XFRQ_FQ,SCSJ,STATUS,BJ_WZSP,JFBS,JF,JE,ZK,ZK_HY,PGRYID,VIPTYPE,HYKNO,HYKNO_FQ,FXDW,BSFS,XSSL,TDJFDYDBH,JF_CZZ,ORDER_NO,BJ_HTBSK) values(3372301,'BG',1,'010010',100079,0,0,0,0,'999999',:JZRQ,:XFSJ,:XFRQ_FQ,:SCSJ,0,0,0.00,0.0000,472.00,59.00,0.00,0,0,'','',0,0,9.0000,0,0.0000,:ORDER_NO,0)
 end 

 begin SQL,2025-12-13 14:08:57.006
 insert into HYK_XFJL_SP(XFJLID,INX,INX_OLD,SHSPID,SPDM,BMDM,BJ_JF,ZKDYDBH,ZKL,XSSL,XSJE,ZKJE,ZKJE_HY,BJ_BCJHD,BJ_BCJMJ,BJ_BCJYQ,JFDYDBH,JFJS,BJ_JFBS,BS,XSJE_JF,XSJE_FQ,JF,FTBL,JFFBGZ,JFDYDBH_CZZ,JFJS_CZZ,BJ_JFBS_CZZ,BS_CZZ,JF_CZZ,JFFBGZ_CZZ,SHOP_ID,SHSHOPID) values(3372301,0,-1,14283290,'0623898','011201021009',1,0,1.0000,9.0000,472.00,59.00,0.00,0,0,0,0,0,0,1.0000,472.00,472.00,0.0000,0.0000,0,0,0,0,1.0000,0.0000,0,639,0)
 end 

 begin SQL,2025-12-13 14:11:33.084
 select JYID from MZK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-13 14:11:33.084
 select JYID from HYK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-13 14:16:33.122
 select JYID from MZK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-13 14:16:33.122
 select JYID from HYK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-13 14:21:33.279
 select JYID from MZK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-13 14:21:33.342
 select JYID from HYK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-13 14:26:33.188
 select JYID from MZK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-13 14:26:33.188
 select JYID from HYK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-13 21:28:45.886
 select JLBH,CUR_VAL from BFCONFIG where JLBH in (0,520000102,520000103,520000112,520000113,520000115,520000120,520000121,520000123,520000128,520000129,520000140,520000141,520000143)
 end 

 begin SQL,2025-12-13 21:28:45.918
 select CONTENT from XTXX where ID = 150 
 end 

 begin SQL,2025-12-13 21:28:45.981
 select USER_DM,USER_PSW,HTTPOK,WSOK,WCFOK from CRMUSER
 end 

 begin SQL,2025-12-13 21:28:46.138
 select IPADDR from CRMCLIENT where WSOK = 1 
 end 

 begin SQL,2025-12-13 21:28:46.170
 select JYID from MZK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-13 21:28:46.170
 select JYID from HYK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-13 21:33:46.207
 select JYID from MZK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-13 21:33:46.207
 select JYID from HYK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-13 21:38:46.243
 select JYID from MZK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-13 21:38:46.243
 select JYID from HYK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-13 21:43:46.320
 select JYID from MZK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-13 21:43:46.348
 select JYID from HYK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-13 21:48:46.329
 select JYID from MZK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-13 21:48:46.329
 select JYID from HYK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end