[2026-09-26 17:48:45] select xtlx from ipos_main limit 1[1054] Unknown column 'xtlx' in 'field list' [2026-09-26 17:48:46] select djbh, fkje as je, vpdm, 1 as zj, djbh as gldj, fkje as tzjf, 'ipos_czkczd' as db_name from ipos_czkczd where ifnull(vpdm, '') <> '' and ifnull(row_no, 0) = 0 union all select djbh, tkje as je, vpdm, -1 as zj, djbh as gldj, tkje as tzjf, 'ipos_zdczktkd' as db_name from ipos_zdczktkd where ifnull(vpdm, '') <> '' and ifnull(row_no, 0) = 0[1146] Table 'zzqr.ipos_zdczktkd' doesn't exist [2026-09-26 17:48:46] SELECT epc.* FROM ipos_dj_epc epc WHERE epc.dj_type='1' and epc.unbind=0 and epc.djbh!=''[1146] Table 'zzqr.ipos_dj_epc' doesn't exist [2026-09-26 17:48:46] SELECT epc.djbh FROM ipos_dj_epc epc inner join ipos_zdzxd zxd on zxd.djbh=epc.djbh inner join ipos_zdthd thd on thd.Id=zxd.thd_id WHERE epc.dj_type='2' and epc.update_owner=0 and thd.qr=1 and epc.djbh!=''[1146] Table 'zzqr.ipos_dj_epc' doesn't exist [2026-09-26 17:48:46] SELECT epc.djbh FROM ipos_dj_epc epc inner join ipos_zdzxd zxd on zxd.djbh=epc.djbh inner join ipos_zdthd thd on thd.Id=zxd.thd_id WHERE epc.dj_type='2' and epc.bind=0 and thd.qr=1 and epc.djbh!=''[1146] Table 'zzqr.ipos_dj_epc' doesn't exist [2026-09-26 17:48:47] SELECT Id from ipos_qtlsd where is_hkym = '0'[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:48:48] select * from ipos_vip where dqjf != 0 and zjrq < '1758816000' and qyrq < '1758816000' limit 0, 200[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:48:49] select pid,vp_id,vpdm,vpmc,zd_id,zddm,zdmc,sum(yxjf) as yxjf,lylx from ipos_vplsz where jfcz!=4 and (yxrq < 1790416129 and yxrq!=0) and yxjf <> 0 and is_ql=0 group by vpdm limit 0, 200[1146] Table 'zzqr.ipos_vplsz' doesn't exist [2026-09-26 17:48:53] SELECT Id from ipos_qtlsd where xpzs_is_fetch = 0 and (ifnull(gd,0) = 0) AND (ifnull(zf,0) = 0) ORDER BY rq DESC limit 100[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:49:13] select * from ipos_plan_task where task_status =1 and execute_status <> 2 AND task_type<>'icrm'[1146] Table 'zzqr.ipos_plan_task' doesn't exist [2026-09-26 17:49:13] select * from ipos_plan_task where execute_status = 2 and (now() > (UNIX_TIMESTAMP(update_time)+1800))[1146] Table 'zzqr.ipos_plan_task' doesn't exist [2026-09-26 17:49:18] select * from ipos_vip where tn_id <> 2 limit 0,3000[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:49:18] select * from ipos_vpczklsz where tn_id <> 2 limit 0,3000[1146] Table 'zzqr.ipos_vpczklsz' doesn't exist [2026-09-26 17:50:39] SELECT vp_id,sum(if(zj*jf<0,zj*jf,0)) as syjf FROM ipos_vplsz WHERE czsj>=1785513600 AND czsj<=1788191999 GROUP BY vp_id[1146] Table 'zzqr.ipos_vplsz' doesn't exist [2026-09-26 17:50:40] SELECT * FROM ipos_vplsz WHERE ifnull(row_no,0)!=1 AND jfcz!=1 AND jfcz!=0 AND jf<>0 AND czsj<=1790416240[1146] Table 'zzqr.ipos_vplsz' doesn't exist [2026-09-26 17:50:40] UPDATE ipos_vplsz set row_no=1 where czsj<=1790416240[1146] Table 'zzqr.ipos_vplsz' doesn't exist [2026-09-26 17:51:11] SELECT * FROM ipos_qtlsd WHERE cf_flag=0 AND zddm IN ('') AND gd=0 LIMIT 1000[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:51:24] select * from ipos_plan_task where task_url=''[1146] Table 'zzqr.ipos_plan_task' doesn't exist [2026-09-26 17:51:24] SELECT Id,sr1 FROM ipos_vip where length(sr1)>0[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:25] select * from ipos_plan_task where task_url=''[1146] Table 'zzqr.ipos_plan_task' doesn't exist [2026-09-26 17:51:25] update ipos_xsjlb set rj=1 where rj=0[1146] Table 'zzqr.ipos_xsjlb' doesn't exist [2026-09-26 17:51:25] select * from ipos_plan_task where task_url=''[1146] Table 'zzqr.ipos_plan_task' doesn't exist [2026-09-26 17:51:25] UPDATE ipos_kbcxd SET sydx='1,2' WHERE cxdx=0 AND sydx=''[1146] Table 'zzqr.ipos_kbcxd' doesn't exist [2026-09-26 17:51:25] UPDATE ipos_kbcxd SET sydx=1 WHERE cxdx=1 AND sydx=''[1146] Table 'zzqr.ipos_kbcxd' doesn't exist [2026-09-26 17:51:25] UPDATE ipos_kbcxd SET sydx=2 WHERE cxdx=2 AND sydx=''[1146] Table 'zzqr.ipos_kbcxd' doesn't exist [2026-09-26 17:51:25] UPDATE ipos_zdcxd SET sydx='1,2' WHERE cxdx=0 AND sydx=''[1146] Table 'zzqr.ipos_zdcxd' doesn't exist [2026-09-26 17:51:25] UPDATE ipos_zdcxd SET sydx=1 WHERE cxdx=1 AND sydx=''[1146] Table 'zzqr.ipos_zdcxd' doesn't exist [2026-09-26 17:51:25] UPDATE ipos_zdcxd SET sydx=2 WHERE cxdx=2 AND sydx=''[1146] Table 'zzqr.ipos_zdcxd' doesn't exist [2026-09-26 17:51:26] select * from ipos_plan_task where task_url=''[1146] Table 'zzqr.ipos_plan_task' doesn't exist [2026-09-26 17:51:26] select * from ipos_plan_task where task_url=''[1146] Table 'zzqr.ipos_plan_task' doesn't exist [2026-09-26 17:51:27] select * from ipos_plan_task where task_url=''[1146] Table 'zzqr.ipos_plan_task' doesn't exist [2026-09-26 17:51:27] SELECT Id from ipos_qtlsd where icrm_is_fetch = 1 and vpdm != '' and (ifnull(gd,0) = 0) AND (ifnull(zf,0) = 0) and (ifnull(ydjh,'')='' or ydjh = '0')[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:51:27] SELECT Id FROM ipos_kuwei WHERE kwdm='000'[1146] Table 'zzqr.ipos_kuwei' doesn't exist [2026-09-26 17:51:27] UPDATE ipos_zdkw SET kw_id=1 WHERE kw_id=[1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 [2026-09-26 17:51:27] SELECT Id from ipos_qtlsd where icrm_is_fetch = 1 and vpdm != '' and (ifnull(gd,0) = 0) AND (ifnull(zf,0) = 0) and ifnull(ydjh,'')<>'' and ydjh != '0'[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:51:27] SELECT user_id from admin_user where tj = 0 and user_type = 2 ORDER by user_id limit 100[1054] Unknown column 'tj' in 'where clause' [2026-09-26 17:51:29] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '15'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:29] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:29] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '16'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:29] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:29] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '17'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:29] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:29] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '18'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:29] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:29] SELECT Id from ipos_vpczklsz where crm_is_fetch = 1[1146] Table 'zzqr.ipos_vpczklsz' doesn't exist [2026-09-26 17:51:30] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '19'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:30] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:30] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '20'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:30] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:30] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '21'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:30] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:30] SELECT * FROM ipos_vip WHERE dqjf>0 AND qyrq<1790265600 AND (FROM_UNIXTIME(qyrq,'%m-%d')='03-26' or FROM_UNIXTIME(qyrq,'%m-%d')='09-26')[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:30] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '22'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:30] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:30] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '23'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:30] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:31] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '24'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:31] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:31] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '25'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:31] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:31] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '26'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:31] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:31] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '27'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:31] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:31] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '28'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:31] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:31] select platform_id,merchant_no from ipos_mszf_config where platform_id<>'' GROUP BY platform_id,merchant_no[1146] Table 'zzqr.ipos_mszf_config' doesn't exist [2026-09-26 17:51:31] select khdm,cbk.Id from com_base_kehu cbk INNER JOIN ipos_zdkzb iz ON iz.pid=cbk.Id where jktx=1[1054] Unknown column 'jktx' in 'where clause' [2026-09-26 17:51:31] SELECT Id,wc FROM ipos_pay_bill WHERE mch_id='' and yyrq='20260925' and type='cmbc'[1146] Table 'zzqr.ipos_pay_bill' doesn't exist [2026-09-26 17:51:31] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '29'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:31] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:32] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '30'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:32] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:32] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '31'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:32] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:32] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '32'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:32] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:32] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '33'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:32] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:32] SELECT Id,1 CXType,djbh CXDM,hdmc CXMC,rq_1 StartRQ,rq_2 EndRQ,cxlx CXLX,sp,zz from ipos_zdcxd where icrm_is_fetch=1 and sp=1 limit 10[1146] Table 'zzqr.ipos_zdcxd' doesn't exist [2026-09-26 17:51:32] SELECT Id,2 CXType,djbh CXDM,hdmc CXMC,rq_1 StartRQ,rq_2 EndRQ,cxlx CXLX,sp,zz from ipos_kbcxd where icrm_is_fetch=1 and sp=1 limit 10[1146] Table 'zzqr.ipos_kbcxd' doesn't exist [2026-09-26 17:51:32] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '34'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:32] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:32] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '35'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:32] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:33] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '36'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:33] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:33] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '37'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:33] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:33] select * from ipos_plan_task where task_url=''[1146] Table 'zzqr.ipos_plan_task' doesn't exist [2026-09-26 17:51:33] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '38'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:33] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:33] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '39'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:33] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:33] SELECT Id from ipos_qtlsd where icrm_is_fetch = 1 and (ifnull(gd,0) = 0) AND (ifnull(zf,0) = 0) and vpdm != ''[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:51:33] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '40'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:33] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:34] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '41'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:34] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:36] SELECT Id from ipos_qtlsd where icrm_is_fetch = 1 and IFNULL(gd,0)=0 and IFNULL(zf,0)=0 and ifnull(vpdm, '') <> ''[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:51:36] SELECT Id from ipos_kbcxd where sp = 1 and zz = 0 and icrm_is_fetch = 1 and jtvip = 1 limit 1[1146] Table 'zzqr.ipos_kbcxd' doesn't exist [2026-09-26 17:51:36] SELECT Id from ipos_zdcxd where sp = 1 and zz = 0 and icrm_is_fetch = 1 and jtvip = 1 limit 1[1146] Table 'zzqr.ipos_zdcxd' doesn't exist [2026-09-26 17:51:36] SELECT Id,sj from ipos_vip where icrm_is_fetch = 1 and status=1 order by lastchanged desc limit 100[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:37] SELECT Id from ipos_dianyuan where icrm_is_fetch = 1 and zd_id in (select pid from ipos_zdkzb where hy_icrm = 1) and ty = 0[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:37] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '42'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:37] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:37] SELECT lsz.Id from ipos_vplsz lsz where lsz.tj=0 and lsz.jf <> 0 and lsz.czsj >'1787673600'[1146] Table 'zzqr.ipos_vplsz' doesn't exist [2026-09-26 17:51:37] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '43'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:37] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:37] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '44'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:37] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:37] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '45'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:37] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:37] SELECT Id from ipos_qtlsd where icrm_is_fetch = 1 and zd_id in (select pid from ipos_zdkzb where hy_icrm = 1) and (ifnull(gd,0) = 0) AND (ifnull(zf,0) = 0)[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:51:37] SELECT Id,UNIX_TIMESTAMP(lastchanged) lastchanged from ipos_vip where lastchanged>= '2026-09-26'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:37] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '46'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:37] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:38] SELECT Id from ipos_vip where status = 1 and icrm_is_fetch = 1 and (zd_id in (select pid from ipos_zdkzb where hy_icrm = 1) or sszd_id in (select pid from ipos_zdkzb where hy_icrm = 1))[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:38] SELECT a.Id from ipos_qtlsd a inner join ipos_zdkzb b on a.zd_id = b.pid where a.icrm_is_fetch in ('1','0') and (ifnull(a.gd,0) = 0) AND (ifnull(a.zf,0) = 0) and a.vpdm != '' and a.yyrq > '1441036800'[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:51:38] SELECT DISTINCT(a.Id) as Id,a.zdrq FROM ipos_qtlsd a INNER JOIN ipos_zdkzb b ON a.zd_id = b.pid left join ipos_qtlsdmx c on c.pid = a.Id left join ipos_qtlsdjs d on d.pid = a.Id WHERE a.icrm_is_fetch IN ( '1', '0' ) AND a.gd= 0 AND a.zf = 0 AND a.yyrq > '1441036800' and (c.dzbh <> '' or d.dm <> '')[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:51:38] SELECT vp.vpdm OldCode,vp.vpmc NickName,vp.sj MobileNo,vp.vpmc NAME,vplb.lbmc Grade,CASE WHEN xb = 1 THEN 2 ELSE 1 END Sex, FROM_UNIXTIME(cus.sr1, '%Y-%m-%d') Birthday,'' WeibNo,cus.qq QqNo,'' TbNo,cus.Email Email,cus.province_id Province,cus.city_id City, cus.district_id County FROM ipos_customer cus INNER JOIN ipos_vip vp ON vp.gk_id = cus.Id inner join ipos_viplb vplb on vplb.Id=vp.lb_id where 1=1 and cus.Id='51' order by cus.lastchanged desc limit 1[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:38] SELECT Id from ipos_vpczd where icrm_is_fetch = 1 and sp = 1[1146] Table 'zzqr.ipos_vpczd' doesn't exist [2026-09-26 17:51:38] SELECT c.Id from ipos_customer c inner join ipos_zdkzb b on c.zd_id = b.pid where c.vip = 2 and c.icrm_is_fetch = 1 and b.is_owt = 1[1054] Unknown column 'b.is_owt' in 'where clause' [2026-09-26 17:51:39] SELECT Id from ipos_vpcztzd where icrm_is_fetch = 1 and sp = 1[1146] Table 'zzqr.ipos_vpcztzd' doesn't exist [2026-09-26 17:51:39] SELECT Id from ipos_refundorder where icrm_is_fetch = 1 and sp = 1[1146] Table 'zzqr.ipos_refundorder' doesn't exist [2026-09-26 17:51:41] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '47'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:41] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:41] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '48'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:41] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:41] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '49'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:41] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:41] select dm from ipos_o2okctbszd where Id='303'[1146] Table 'zzqr.ipos_o2okctbszd' doesn't exist [2026-09-26 17:51:41] SELECT qimen_store_id FROM com_base_kehu WHERE Id='39'[1054] Unknown column 'qimen_store_id' in 'field list' [2026-09-26 17:51:41] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '50'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:41] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:41] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '51'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:41] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:42] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '52'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:42] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:42] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '53'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:42] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:42] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '54'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:42] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:42] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '55'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:42] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:42] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '56'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:42] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:43] select czkdm from ipos_zdczkxsd where sp = 1 and ifnull(gk_id,0) = 0 and (gkdm != '' or sj != '')[1146] Table 'zzqr.ipos_zdczkxsd' doesn't exist [2026-09-26 17:51:44] select Id,dymc from ipos_dianyuan[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:44] SELECT lsz.Id, lsz.lxdj, xp.je, xp.sl, xp.syy_id FROM ipos_czklsz lsz LEFT JOIN ipos_qtlsd xp ON lsz.lxdj = xp.djbh WHERE lsz.czdm = 2 AND lsz.lxdj != '' AND xp.gd = 0 AND xp.zf = 0[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:51:45] select * from ipos_plan_task where task_url=''[1146] Table 'zzqr.ipos_plan_task' doesn't exist [2026-09-26 17:51:45] delete from ipos_qimen_notify where lastchanged < '2026-09-19'[1146] Table 'zzqr.ipos_qimen_notify' doesn't exist [2026-09-26 17:51:45] select * from ipos_plan_task where task_url=''[1146] Table 'zzqr.ipos_plan_task' doesn't exist [2026-09-26 17:51:46] select * from ipos_plan_task where task_url=''[1146] Table 'zzqr.ipos_plan_task' doesn't exist [2026-09-26 17:51:46] select zddm, orgdm, crm_id, sj, vpdm from ipos_vip where Id = '5'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:46] select zddm, orgdm, crm_id, sj, vpdm from ipos_vip where sj = '17737173359'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:47] select pid,dpck from ipos_zdkzb[1054] Unknown column 'dpck' in 'field list' [2026-09-26 17:51:47] select czk.Id,czk.czkdm,czk.jmw_pp,czk.lqlx,lb.lbdm from ipos_czk czk inner join ipos_czklb lb on czk.lb_id=lb.Id WHERE lb.lbdm in('EZR_XJQ_LB','EZR_ZKQ_LB','EZR_LPQ_LB') and czk.push_state=0 and czk.status=4[1054] Unknown column 'czk.jmw_pp' in 'field list' [2026-09-26 17:51:48] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:51:48] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:51:49] SELECT Id,sxmc FROM ipos_vpsx1[1146] Table 'zzqr.ipos_vpsx1' doesn't exist [2026-09-26 17:51:49] SELECT Id,sxmc FROM ipos_vpsx2[1146] Table 'zzqr.ipos_vpsx2' doesn't exist [2026-09-26 17:51:49] SELECT Id,sxmc FROM ipos_vpsx3[1146] Table 'zzqr.ipos_vpsx3' doesn't exist [2026-09-26 17:51:49] SELECT Id,sxmc FROM ipos_vpsx4[1146] Table 'zzqr.ipos_vpsx4' doesn't exist [2026-09-26 17:51:49] SELECT Id,sxmc FROM ipos_vpsx5[1146] Table 'zzqr.ipos_vpsx5' doesn't exist [2026-09-26 17:51:49] SELECT Id,sxmc FROM ipos_vpsx6[1146] Table 'zzqr.ipos_vpsx6' doesn't exist [2026-09-26 17:51:49] SELECT Id,sxmc FROM ipos_vpsx7[1146] Table 'zzqr.ipos_vpsx7' doesn't exist [2026-09-26 17:51:49] SELECT Id,sxmc FROM ipos_vpsx8[1146] Table 'zzqr.ipos_vpsx8' doesn't exist [2026-09-26 17:51:49] SELECT Id,sxmc FROM ipos_vpsx9[1146] Table 'zzqr.ipos_vpsx9' doesn't exist [2026-09-26 17:51:49] SELECT Id,sxmc FROM ipos_vpsx10[1146] Table 'zzqr.ipos_vpsx10' doesn't exist [2026-09-26 17:51:49] UPDATE ipos_gkxfmx0 mx, com_base_shangpin sp SET mx.pp_id=sp.pp_id WHERE mx.sp_id = sp.Id[1146] Table 'zzqr.ipos_gkxfmx0' doesn't exist [2026-09-26 17:51:49] UPDATE ipos_gkxfmx1 mx, com_base_shangpin sp SET mx.pp_id=sp.pp_id WHERE mx.sp_id = sp.Id[1146] Table 'zzqr.ipos_gkxfmx1' doesn't exist [2026-09-26 17:51:49] UPDATE ipos_gkxfmx2 mx, com_base_shangpin sp SET mx.pp_id=sp.pp_id WHERE mx.sp_id = sp.Id[1146] Table 'zzqr.ipos_gkxfmx2' doesn't exist [2026-09-26 17:51:49] UPDATE ipos_gkxfmx3 mx, com_base_shangpin sp SET mx.pp_id=sp.pp_id WHERE mx.sp_id = sp.Id[1146] Table 'zzqr.ipos_gkxfmx3' doesn't exist [2026-09-26 17:51:49] UPDATE ipos_gkxfmx4 mx, com_base_shangpin sp SET mx.pp_id=sp.pp_id WHERE mx.sp_id = sp.Id[1146] Table 'zzqr.ipos_gkxfmx4' doesn't exist [2026-09-26 17:51:49] UPDATE ipos_gkxfmx5 mx, com_base_shangpin sp SET mx.pp_id=sp.pp_id WHERE mx.sp_id = sp.Id[1146] Table 'zzqr.ipos_gkxfmx5' doesn't exist [2026-09-26 17:51:49] UPDATE ipos_gkxfmx6 mx, com_base_shangpin sp SET mx.pp_id=sp.pp_id WHERE mx.sp_id = sp.Id[1146] Table 'zzqr.ipos_gkxfmx6' doesn't exist [2026-09-26 17:51:49] UPDATE ipos_gkxfmx7 mx, com_base_shangpin sp SET mx.pp_id=sp.pp_id WHERE mx.sp_id = sp.Id[1146] Table 'zzqr.ipos_gkxfmx7' doesn't exist [2026-09-26 17:51:49] UPDATE ipos_gkxfmx8 mx, com_base_shangpin sp SET mx.pp_id=sp.pp_id WHERE mx.sp_id = sp.Id[1146] Table 'zzqr.ipos_gkxfmx8' doesn't exist [2026-09-26 17:51:49] UPDATE ipos_gkxfmx9 mx, com_base_shangpin sp SET mx.pp_id=sp.pp_id WHERE mx.sp_id = sp.Id[1146] Table 'zzqr.ipos_gkxfmx9' doesn't exist [2026-09-26 17:51:49] UPDATE ipos_qtlsdmx mx, com_base_shangpin sp SET mx.pp_id=sp.pp_id WHERE mx.sp_id = sp.Id[1146] Table 'zzqr.ipos_qtlsdmx' doesn't exist [2026-09-26 17:51:49] SELECT * FROM ipos_qtlsd_web WHERE qr=2 and qh=1 and finish=0[1146] Table 'zzqr.ipos_qtlsd_web' doesn't exist [2026-09-26 17:51:51] select * from ipos_gkzlbgsqd[1146] Table 'zzqr.ipos_gkzlbgsqd' doesn't exist [2026-09-26 17:51:51] SELECT * from ipos_qtlsd_web where bdxd=1 and bdfh=0 and tj=0 order by Id desc limit 100[1146] Table 'zzqr.ipos_qtlsd_web' doesn't exist [2026-09-26 17:51:51] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '57'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:51] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:52] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '58'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:52] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:52] select distinct lsz.vp_id, vip.sj, vip.dqjf, vip.lb_id, vip.passport_seller_name, vip.vpdm, vip.status from ipos_vplsz lsz, ipos_vip vip where lsz.vp_id=vip.Id AND vip.passport_is_bind=1 AND lsz.tj=0;[1146] Table 'zzqr.ipos_vplsz' doesn't exist [2026-09-26 17:51:52] TRUNCATE ipos_vip_zd[1146] Table 'zzqr.ipos_vip_zd' doesn't exist [2026-09-26 17:51:52] SELECT gk_id,zd_id,zddm,zdmc,je,sl,czsj,lxdj FROM ipos_gklsz WHERE xfcz>=1 and xfcz<=2 UNION ALL SELECT m.gk_id,lsz.zd_id,lsz.zddm,lsz.zdmc,lsz.je,lsz.sl,lsz.czsj,lsz.lxdj FROM ipos_vplsz lsz LEFT JOIN ipos_vip m ON m.Id = lsz.vp_id WHERE lsz.jfcz>=1 and lsz.jfcz<=3[1146] Table 'zzqr.ipos_gklsz' doesn't exist [2026-09-26 17:51:52] TRUNCATE ipos_vip_zd[1146] Table 'zzqr.ipos_vip_zd' doesn't exist [2026-09-26 17:51:52] INSERT INTO ipos_vip_zd(vp_id,vpdm,vpmc,zd_id,zddm,zdmc,xfsl,xfje,xfjf) select vp_id,vpdm,vpmc,zd_id,zddm,zdmc,sum(sl),sum(je),sum(jf*zj) from ipos_vplsz where jfcz>=1 and jfcz<=3 and zd_id>0 group by vp_id,zd_id[1146] Table 'zzqr.ipos_vip_zd' doesn't exist [2026-09-26 17:51:52] select * from ipos_vip_zd[1146] Table 'zzqr.ipos_vip_zd' doesn't exist [2026-09-26 17:51:53] TRUNCATE ipos_vip_yhinfo[1146] Table 'zzqr.ipos_vip_yhinfo' doesn't exist [2026-09-26 17:51:53] SELECT m.djbh,m.yyrq,m.vpdm,m.sryhsl,m.org_id,m.zd_id FROM ipos_qtlsd m WHERE m.gd=0 and m.vpdm!='' and m.sryhsl<>0 AND m.zf=0[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:51:53] SELECT djh,qrrq as yyrq,vpdm,org_id,zd_id,sum(sl) as vpxesl,sum(je) as je,sum(ckj*sl) as ckje FROM ipos_qtlsdmx WHERE gd=0 AND zf=0 AND vpxe=1 group by djh[1146] Table 'zzqr.ipos_qtlsdmx' doesn't exist [2026-09-26 17:51:54] select * from sys_app_user order by app_user_id desc[1146] Table 'zzqr.sys_app_user' doesn't exist [2026-09-26 17:51:54] select * from ipos_qtlsd where Id ='5'[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:51:54] select * from ipos_plan_task where task_url=''[1146] Table 'zzqr.ipos_plan_task' doesn't exist [2026-09-26 17:51:54] select * from ipos_qtlsdmx where pid ='5'[1146] Table 'zzqr.ipos_qtlsdmx' doesn't exist [2026-09-26 17:51:54] select * from ipos_qtlsdjs where Id ='5'[1146] Table 'zzqr.ipos_qtlsdjs' doesn't exist [2026-09-26 17:51:54] select * from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:54] select * from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:54] SELECT baison_unday_time FROM ipos_zdkzb[1054] Unknown column 'baison_unday_time' in 'field list' [2026-09-26 17:51:54] select pid,baison_unday from ipos_zdkzb where baison_unday >= 0[1054] Unknown column 'baison_unday' in 'field list' [2026-09-26 17:51:55] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '59'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:55] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:55] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '60'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:55] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:55] SELECT Id from ipos_qtlsd where qdmj_is_fetch = 1 and (ifnull(gd,0) = 0) AND (ifnull(zf,0) = 0) and lyxt = 99 UNION ALL SELECT Id from ipos_qtlsd where qdmj_is_fetch = 1 AND zf = 1 and lyxt = 99[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:51:55] select qy_retailo2o,retail_key,retail_secret,retail_url from ipos_main[1054] Unknown column 'qy_retailo2o' in 'field list' [2026-09-26 17:51:55] SELECT distinct zddm FROM ipos_o2okctb_tyzdsp WHERE status=0[1146] Table 'zzqr.ipos_o2okctb_tyzdsp' doesn't exist [2026-09-26 17:51:56] select pid,hdjcd_cl_num from ipos_zdkzb where hdjcd_cl_num > 0[1054] Unknown column 'hdjcd_cl_num' in 'field list' [2026-09-26 17:51:56] select qy_retailo2o,retail_key,retail_secret,retail_url from ipos_main[1054] Unknown column 'qy_retailo2o' in 'field list' [2026-09-26 17:51:56] SELECT webbh as ydjh, tihuoma_pt lylx, tihuoma th_taobao_yzm, Id, djbh from ipos_qtlsd_web a where (qr=2 || finish=1) and tihuoma_hx=0 and ifnull(tihuoma, '') != '' ORDER BY Id desc[1146] Table 'zzqr.ipos_qtlsd_web' doesn't exist [2026-09-26 17:51:56] select * from ipos_plan_task where task_url=''[1146] Table 'zzqr.ipos_plan_task' doesn't exist [2026-09-26 17:51:57] select * from ipos_qtlsd_web_qr where qr = 0[1146] Table 'zzqr.ipos_qtlsd_web_qr' doesn't exist [2026-09-26 17:51:57] select * from ipos_plan_task where task_url=''[1146] Table 'zzqr.ipos_plan_task' doesn't exist [2026-09-26 17:51:57] SELECT Id from ipos_qtlsd where icrm_is_fetch = 1 and (ifnull(gd,0) = 0) AND (ifnull(zf,0) = 0)[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:51:57] SELECT Id from ipos_qtlsd where icrm_is_fetch = 1 and vpdm != '' and (ifnull(gd,0) = 0) AND (ifnull(zf,0) = 0) and org_id in ( select 1 from ipos_main where sy_crm = 2 UNION ALL select pid from ipos_orgkzb where sy_crm = 2) limit 100[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:51:58] SELECT dj_id,zddm from RFID_INFO where tj = 0 AND last_upload=1[1146] Table 'zzqr.rfid_info' doesn't exist [2026-09-26 17:51:58] update RFID_INFO set tj=2,re_time='1790416318'WHERE dj_id in ('')[1146] Table 'zzqr.rfid_info' doesn't exist [2026-09-26 17:51:58] select * from ipos_plan_task where task_url=''[1146] Table 'zzqr.ipos_plan_task' doesn't exist [2026-09-26 17:51:58] SELECT Id from ipos_customer where icrm_is_fetch = 1 and org_id in ( select 1 from ipos_main where sy_crm = 2 UNION ALL select pid from ipos_orgkzb where sy_crm = 2)[1146] Table 'zzqr.ipos_orgkzb' doesn't exist [2026-09-26 17:51:58] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:51:58] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:51:58] select ppdm from ipos_jmw_pp ORDER BY ppdm asc LIMIT 1[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:51:58] select lsz.* from ipos_vpczklsz lsz where crm_is_fetch = 1 order by lsz.czsj limit 0, 100[1146] Table 'zzqr.ipos_vpczklsz' doesn't exist [2026-09-26 17:51:58] select DISTINCT pid as Id from ipos_qtlsdjs where pid in (SELECT Id from ipos_qtlsd where vpdm != '' and (ifnull(gd,0) = 0) AND (ifnull(zf,0) = 0) and org_id in ( select 1 from ipos_main where sy_crm = 2 UNION ALL select pid from ipos_orgkzb where sy_crm = 2)) and dm != '' and dm in (select czkdm from ipos_czk where lb_id in (select Id from ipos_czklb where lqlx = 1 and lq = 1)) and icrm_is_fetch = 1[1146] Table 'zzqr.ipos_qtlsdjs' doesn't exist [2026-09-26 17:51:58] SELECT Id from ipos_dianyuan where icrm_is_fetch = 1 and ty = 0[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:59] SELECT Id from ipos_qtlsd where gd=0 and zf=0 and icrm_is_fetch=1 limit 200[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:51:59] select lsz.* from ipos_vplsz lsz where (lsz.tj =0 or lsz.tj is null) and jfcz not IN () order by lsz.Id limit 0, 100[1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') order by lsz.Id limit 0, 100' at line 2 [2026-09-26 17:51:59] select * from ipos_qtlsd where icrm_is_fetch = 1 and ifnull(vpdm, '') != ''[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:51:59] select pid,vp_id,vpdm,vpmc,zd_id,zddm,zdmc,sum(yxjf) as yxjf,lylx from ipos_vplsz where jfcz!=4 and (yxrq < 1790416319 and yxrq!=0) and yxjf <> 0 group by vpdm[1146] Table 'zzqr.ipos_vplsz' doesn't exist [2026-09-26 17:51:59] SELECT vp.vpdm OldCode,vp.vpmc NickName,vp.sj MobileNo,vp.vpmc NAME,vplb.lbmc Grade,CASE WHEN xb = 1 THEN 2 ELSE 1 END Sex, FROM_UNIXTIME(cus.sr1, '%Y-%m-%d') Birthday,'' WeibNo,cus.qq QqNo,'' TbNo,cus.Email Email,cus.province_id Province,cus.city_id City, cus.district_id County FROM ipos_customer cus INNER JOIN ipos_vip vp ON vp.gk_id = cus.Id inner join ipos_viplb vplb on vplb.Id=vp.lb_id where 1=1 and cus.Id='157' order by cus.lastchanged desc limit 1[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:51:59] SELECT Id from ipos_dianyuan where icrm_is_fetch = 1 and ty = 0[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:51:59] SELECT xp.djbh FROM ipos_qtlsd xp INNER JOIN ipos_vip vp ON xp.vp_id=vp.Id WHERE xp.gd=0 and xp.zf=0 and (xp.status_code & 4) = 0 AND 1=1 LIMIT 0, 20[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:52:00] select count(*) from (select zddm ShopCode,FROM_UNIXTIME(yyrq,'%Y-%m-%d') SaleDate,sum(mx.sl) SaleQty,count(DISTINCT m.djbh) as SaleNum,ROUND(sum(mx.je),2) SaleMoney ,ROUND(sum(abs(mx.ckj)*mx.sl - mx.je),2) SaleDiscountMoney,ROUND(avg(mx.dj),2) AvgPrice,ROUND(avg(mx.zk),2) AvgDiscount from ipos_qtlsd m inner join ipos_qtlsdmx mx on m.Id=mx.pid where 1=1 and FROM_UNIXTIME(yyrq,'%Y-%m-%d') ='2026-09-26' group by zddm,FROM_UNIXTIME(yyrq,'%Y-%m-%d')) as tmp[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:52:00] select zddm ShopCode,FROM_UNIXTIME(yyrq,'%Y-%m-%d') SaleDate,sum(mx.sl) SaleQty,count(DISTINCT m.djbh) as SaleNum,ROUND(sum(mx.je),2) SaleMoney ,ROUND(sum(abs(mx.ckj)*mx.sl - mx.je),2) SaleDiscountMoney,ROUND(avg(mx.dj),2) AvgPrice,ROUND(avg(mx.zk),2) AvgDiscount from ipos_qtlsd m inner join ipos_qtlsdmx mx on m.Id=mx.pid where 1=1 and FROM_UNIXTIME(yyrq,'%Y-%m-%d') ='2026-09-26' group by zddm,FROM_UNIXTIME(yyrq,'%Y-%m-%d') order by zddm LIMIT 0 ,100[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:52:00] select count(1) from ( select zddm ShopCode,FROM_UNIXTIME(yyrq,'%Y-%m-%d') SaleDate,sum(mx.sl) SaleQty,count(DISTINCT m.djbh) as SaleNum,ROUND(sum(mx.je),2) SaleMoney ,ROUND(sum(abs(mx.ckj)*mx.sl - mx.je),2) SaleDiscountMoney,ROUND(avg(mx.dj),2) AvgPrice,ROUND(avg(mx.zk),2) AvgDiscount from ipos_qtlsd m inner join ipos_qtlsdmx mx on m.Id=mx.pid where 1=1 and FROM_UNIXTIME(yyrq,'%Y-%m-%d') ='2026-09-26' group by zddm,FROM_UNIXTIME(yyrq,'%Y-%m-%d') order by zddm LIMIT 0 ,100 ) a[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:52:00] select pid,vp_id,vpdm,vpmc,zd_id,zddm,zdmc,sum(yxjf) as yxjf,lylx from ipos_vplsz where jfcz!=4 and (yxrq < 1790416320 and yxrq!=0) and yxjf <> 0 group by vpdm[1146] Table 'zzqr.ipos_vplsz' doesn't exist [2026-09-26 17:52:00] select count(*) from (select kh.khdm as ShopCode,FROM_UNIXTIME(m.yyrq,'%Y-%m-%d') as SaleDate,sum(mx.sl) as SaleQty,count(DISTINCT m.djbh) as SaleNum,ROUND(sum(mx.je),2) as SaleMoney,ROUND(sum(abs(mx.ckj)*mx.sl-mx.je),2) as SaleDiscountMoney,ROUND(avg(mx.dj),2) as AvgPrice,ROUND(avg(mx.zk),2) as AvgDiscount from ipos_qtlsd m inner join ipos_qtlsdmx mx on m.Id=mx.pid inner join com_base_kehu kh on m.zd_id=kh.Id where m.yyrq='1790352000' and kh.jmw_pp='j1' group by m.zd_id,m.yyrq) as tmp[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:52:00] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:52:00] select zddm as ShopCode,FROM_UNIXTIME(yyrq,'%Y-%m-%d') as SaleDate,sum(mx.sl) as SaleQty,count(DISTINCT m.djbh) as SaleNum,ROUND(sum(mx.je),2) as SaleMoney, ROUND(sum(abs(mx.ckj)*mx.sl - mx.je),2) as SaleDiscountMoney,ROUND(avg(mx.dj),2) as AvgPrice,ROUND(avg(mx.zk),2) as AvgDiscount,kh.jmw_pp as Brand from ipos_qtlsd m inner join ipos_qtlsdmx mx on m.Id=mx.pid inner join com_base_kehu kh on m.zd_id=kh.Id where m.yyrq='1790352000' and kh.jmw_pp='j1' group by m.yyrq,m.zd_id LIMIT 0 ,100[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:52:00] select count(1) from (select zddm as ShopCode,FROM_UNIXTIME(yyrq,'%Y-%m-%d') as SaleDate,sum(mx.sl) as SaleQty,count(DISTINCT m.djbh) as SaleNum,ROUND(sum(mx.je),2) as SaleMoney, ROUND(sum(abs(mx.ckj)*mx.sl - mx.je),2) as SaleDiscountMoney,ROUND(avg(mx.dj),2) as AvgPrice,ROUND(avg(mx.zk),2) as AvgDiscount,kh.jmw_pp as Brand from ipos_qtlsd m inner join ipos_qtlsdmx mx on m.Id=mx.pid inner join com_base_kehu kh on m.zd_id=kh.Id where m.yyrq='1790352000' and kh.jmw_pp='j1' group by m.yyrq,m.zd_id LIMIT 0 ,100 ) a[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:52:00] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:52:01] select sp.Id as spId,sp.spmc,jg.*,UNIX_TIMESTAMP(jg.lastchanged) as lasttime,gg1.ggmc as gg1mc,gg2.ggmc as gg2mc from ipos_spjgb jg inner join com_base_shangpin sp on sp.Id=jg.sp_id inner join com_base_spgg1 gg1 on gg1.sp_id=sp.Id inner join com_base_spgg2 gg2 on gg2.sp_id=sp.Id where sp.lylx=0 and sp.ty=0 and UNIX_TIMESTAMP(jg.lastchanged) > 0[1146] Table 'zzqr.ipos_spjgb' doesn't exist [2026-09-26 17:52:04] select * from sys_app_user order by app_user_id desc[1146] Table 'zzqr.sys_app_user' doesn't exist [2026-09-26 17:52:04] select * from ipos_qtlsd where Id ='6'[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:52:04] select * from ipos_qtlsdmx where pid ='6'[1146] Table 'zzqr.ipos_qtlsdmx' doesn't exist [2026-09-26 17:52:04] select * from ipos_qtlsdjs where Id ='6'[1146] Table 'zzqr.ipos_qtlsdjs' doesn't exist [2026-09-26 17:52:04] select * from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:52:04] select * from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:52:04] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '61'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:52:04] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:52:04] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '62'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:52:04] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:52:04] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '63'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:52:04] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:52:06] select xtlx from ipos_main limit 1[1054] Unknown column 'xtlx' in 'field list' [2026-09-26 17:52:08] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '64'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:52:08] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:52:08] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:52:08] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:52:10] SELECT lsd.Id from ipos_qtlsd lsd inner join ipos_vip vp on vp.vpdm=lsd.vpdm inner join ipos_viplb lb on lb.Id = vp.lb_id where lsd.icrm_is_fetch = 1 and lb.Id in(11,12,13,14) and IFNULL(lsd.gd,0)=0 and IFNULL(lsd.zf,0)=0 and ifnull(lsd.vpdm, '') <> '' order by lsd.lastchanged desc[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:52:10] select count(*) from (select kh.khdm as ShopCode,FROM_UNIXTIME(yyrq,'%Y-%m-%d') as SaleDate,sum(mx.sl) as SaleQty,count(DISTINCT m.djbh) as SaleNum,ROUND(sum(mx.je),2) as SaleMoney,ROUND(sum(abs(mx.ckj)*mx.sl-mx.je),2) as SaleDiscountMoney,ROUND(avg(mx.dj),2) as AvgPrice,ROUND(avg(mx.zk),2) as AvgDiscount from ipos_qtlsd m inner join ipos_qtlsdmx mx on m.Id=mx.pid inner join com_base_kehu kh on m.zd_id=kh.Id where m.yyrq='1790352000' and kh.jmw_pp='joeone' group by m.zd_id,m.yyrq) as tmp[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:52:10] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:52:10] select zddm as ShopCode,FROM_UNIXTIME(yyrq,'%Y-%m-%d') as SaleDate,sum(mx.sl) as SaleQty,count(DISTINCT m.djbh) as SaleNum,ROUND(sum(mx.je),2) as SaleMoney, ROUND(sum(abs(mx.ckj)*mx.sl - mx.je),2) as SaleDiscountMoney,ROUND(avg(mx.dj),2) as AvgPrice,ROUND(avg(mx.zk),2) as AvgDiscount,kh.jmw_pp as Brand from ipos_qtlsd m inner join ipos_qtlsdmx mx on m.Id=mx.pid inner join com_base_kehu kh on m.zd_id=kh.Id where m.yyrq='1790352000' and kh.jmw_pp='joeone' group by m.yyrq,m.zd_id LIMIT 0 ,100[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:52:10] select count(1) from (select zddm as ShopCode,FROM_UNIXTIME(yyrq,'%Y-%m-%d') as SaleDate,sum(mx.sl) as SaleQty,count(DISTINCT m.djbh) as SaleNum,ROUND(sum(mx.je),2) as SaleMoney, ROUND(sum(abs(mx.ckj)*mx.sl - mx.je),2) as SaleDiscountMoney,ROUND(avg(mx.dj),2) as AvgPrice,ROUND(avg(mx.zk),2) as AvgDiscount,kh.jmw_pp as Brand from ipos_qtlsd m inner join ipos_qtlsdmx mx on m.Id=mx.pid inner join com_base_kehu kh on m.zd_id=kh.Id where m.yyrq='1790352000' and kh.jmw_pp='joeone' group by m.yyrq,m.zd_id LIMIT 0 ,100 ) a[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:52:10] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:52:10] SELECT lsd.Id,xl.jmw_pp from ipos_qtlsd lsd inner join ipos_vip vp on vp.vpdm=lsd.vpdm inner join ipos_viplb lb on lb.Id=vp.lb_id inner join ipos_hyxl xl on xl.Id = vp.xl_id where lsd.icrm_is_fetch=1 and lb.Id in(11,12,13,14) and lsd.gd=0 and lsd.zf=0 and lsd.vpdm<>''[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:52:11] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '65'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:52:11] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:52:11] select djbh, fkje as je, vpdm, 1 as zj, djbh as gldj, fkje as tzjf, 'ipos_czkczd' as db_name from ipos_czkczd where ifnull(vpdm, '') <> '' and ifnull(row_no, 0) = 0 union all select djbh, tkje as je, vpdm, -1 as zj, djbh as gldj, tkje as tzjf, 'ipos_zdczktkd' as db_name from ipos_zdczktkd where ifnull(vpdm, '') <> '' and ifnull(row_no, 0) = 0[1146] Table 'zzqr.ipos_zdczktkd' doesn't exist [2026-09-26 17:52:11] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:52:11] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:52:11] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '66'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:52:11] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:52:11] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '67'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:52:11] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:52:11] SELECT epc.* FROM ipos_dj_epc epc WHERE epc.dj_type='1' and epc.unbind=0 and epc.djbh!=''[1146] Table 'zzqr.ipos_dj_epc' doesn't exist [2026-09-26 17:52:11] SELECT epc.djbh FROM ipos_dj_epc epc inner join ipos_zdzxd zxd on zxd.djbh=epc.djbh inner join ipos_zdthd thd on thd.Id=zxd.thd_id WHERE epc.dj_type='2' and epc.update_owner=0 and thd.qr=1 and epc.djbh!=''[1146] Table 'zzqr.ipos_dj_epc' doesn't exist [2026-09-26 17:52:11] SELECT epc.djbh FROM ipos_dj_epc epc inner join ipos_zdzxd zxd on zxd.djbh=epc.djbh inner join ipos_zdthd thd on thd.Id=zxd.thd_id WHERE epc.dj_type='2' and epc.bind=0 and thd.qr=1 and epc.djbh!=''[1146] Table 'zzqr.ipos_dj_epc' doesn't exist [2026-09-26 17:52:11] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '68'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:52:11] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:52:12] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '69'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:52:12] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:52:12] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '70'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:52:12] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:52:12] SELECT Id from ipos_qtlsd where is_hkym = '0'[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:52:12] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '71'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:52:12] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:52:12] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '72'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:52:12] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:52:12] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '73'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:52:12] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:52:12] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '74'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:52:12] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:52:12] select * from ipos_vip where dqjf != 0 and zjrq < '1758816000' and qyrq < '1758816000' limit 0, 200[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:52:13] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '75'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:52:13] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:52:14] select pid,vp_id,vpdm,vpmc,zd_id,zddm,zdmc,sum(yxjf) as yxjf,lylx from ipos_vplsz where jfcz!=4 and (yxrq < 1790416334 and yxrq!=0) and yxjf <> 0 and is_ql=0 group by vpdm limit 0, 200[1146] Table 'zzqr.ipos_vplsz' doesn't exist [2026-09-26 17:52:14] select Id from ipos_lxfa WHERE state = 1[1146] Table 'zzqr.ipos_lxfa' doesn't exist [2026-09-26 17:52:16] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '76'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:52:16] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:52:16] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '77'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:52:16] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:52:16] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '78'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:52:16] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:52:18] SELECT Id from ipos_qtlsd where xpzs_is_fetch = 0 and (ifnull(gd,0) = 0) AND (ifnull(zf,0) = 0) ORDER BY rq DESC limit 100[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:52:18] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:52:18] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:52:21] SELECT vp.vpdm OldCode,vp.vpmc NickName,vp.sj MobileNo,vp.vpmc NAME,vplb.lbmc Grade,CASE WHEN xb = 1 THEN 2 ELSE 1 END Sex, FROM_UNIXTIME(cus.sr1, '%Y-%m-%d') Birthday,'' WeibNo,cus.qq QqNo,'' TbNo,cus.Email Email,cus.province_id Province,cus.city_id City, cus.district_id County FROM ipos_customer cus INNER JOIN ipos_vip vp ON vp.gk_id = cus.Id inner join ipos_viplb vplb on vplb.Id=vp.lb_id where 1=1 and cus.Id='296' order by cus.lastchanged desc limit 1[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:52:21] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:52:21] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:52:22] SELECT Id,jmw_pp from com_base_kehu where icrm_is_fetch = 1 and xzdm in (4,5)[1054] Unknown column 'jmw_pp' in 'field list' [2026-09-26 17:52:22] select ppdm from ipos_jmw_pp ORDER BY ppdm asc LIMIT 1[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:52:22] SELECT Id,jmw_pp from com_base_kehu where xzdm in (4,5) and ty=1 and row_no not in (2,3)[1054] Unknown column 'jmw_pp' in 'field list' [2026-09-26 17:52:23] select ppdm from ipos_jmw_pp ORDER BY ppdm asc LIMIT 1[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:52:23] SELECT vp.Id,vp.sj,xl.jmw_pp from ipos_vip vp inner join ipos_viplb lb on lb.Id = vp.lb_id inner join ipos_hyxl xl on xl.Id = vp.xl_id where vp.icrm_is_fetch=1 and vp.status=1 and lb.Id in(11,12,13,14) limit 100[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:52:24] SELECT lsz.*,xl.jmw_pp from ipos_vplsz lsz inner join ipos_vip vp on vp.Id=lsz.vp_id inner join ipos_viplb lb on lb.Id = vp.lb_id inner join ipos_hyxl xl on xl.Id = vp.xl_id where lsz.tj=0 and lsz.jf <> 0 and lb.Id in(11,12,13,14) and lsz.czsj >'1787673600'[1146] Table 'zzqr.ipos_vplsz' doesn't exist [2026-09-26 17:52:25] SELECT vp.Id,vp.gk_id,UNIX_TIMESTAMP(vp.lastchanged) as lastchanged,xl.jmw_pp as jmw_pp from ipos_vip vp inner join ipos_viplb lb on lb.Id = vp.lb_id inner join ipos_hyxl xl on xl.Id = vp.xl_id where vp.status=1 and lb.Id in(11,12,13,14,19,20,21,22) and vp.lastchanged>= '2026-09-26'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:52:25] SELECT last_time FROM ipos_yike_tran WHERE code='vipgradeupdate'[1146] Table 'zzqr.ipos_yike_tran' doesn't exist [2026-09-26 17:52:25] insert into ipos_yike_tran (`code`) values('vipgradeupdate')[1146] Table 'zzqr.ipos_yike_tran' doesn't exist [2026-09-26 17:52:25] select DISTINCT vpdm,ChangeTime,Remark from ( select vpdm,FROM_UNIXTIME(czsj) as ChangeTime,bz as Remark from ipos_vplsz where czsj>'1790352000' and lb_id in(11,12,13,14,19,20,21,22) and (bz like '%降级%' or bz like '%升级%') union all select vpdm,FROM_UNIXTIME(act_time) as ChangeTime,bz as Remark from ipos_vip_act where act_time>'1790352000' and lb_id in(11,12,13,14,19,20,21,22) and type in (2,9) ) tmp[1146] Table 'zzqr.ipos_vplsz' doesn't exist [2026-09-26 17:52:25] UPDATE ipos_yike_tran SET last_time='1790416345' WHERE code='vipgradeupdate'[1146] Table 'zzqr.ipos_yike_tran' doesn't exist [2026-09-26 17:52:26] SELECT cus.Id,xl.jmw_pp,vp.vpdm as OldCode,vp.vpmc as NickName,vp.sj as MobileNo,vp.vpmc as NAME,lb.lbmc as Grade,CASE WHEN cus.xb=0 THEN 1 WHEN cus.xb=1 THEN 2 ELSE 0 END as Sex, FROM_UNIXTIME(cus.sr1, '%Y-%m-%d') as Birthday,cus.qq as QqNo,cus.Email as Email,xl.jmw_pp as Brand from ipos_customer cus inner join ipos_vip vp on vp.gk_id=cus.Id inner join ipos_viplb lb on lb.Id = vp.lb_id inner join ipos_hyxl xl on xl.Id = vp.xl_id where cus.icrm_is_fetch=1 and cus.xgrq>0 and lb.Id in(11,12,13,14)[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:52:26] select lsz.*,xl.jmw_pp from ipos_vplsz lsz inner join ipos_hyxl xl on xl.Id = lsz.xl_id where lsz.jfcz > 0 and lsz.jf <> 0 and (lsz.tj =0 or lsz.tj is null) order by lsz.Id limit 0, 100[1146] Table 'zzqr.ipos_vplsz' doesn't exist [2026-09-26 17:52:28] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:52:28] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:52:29] select zddm, orgdm, crm_id, sj, vpdm from ipos_vip where Id = '5'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:52:29] select zddm, orgdm, crm_id, sj, vpdm from ipos_vip where sj = '17737173359'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:52:31] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:52:31] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:52:37] select * from ipos_plan_task where task_status =1 and execute_status <> 2 AND task_type<>'icrm'[1146] Table 'zzqr.ipos_plan_task' doesn't exist [2026-09-26 17:52:37] select * from ipos_plan_task where execute_status = 2 and (now() > (UNIX_TIMESTAMP(update_time)+1800))[1146] Table 'zzqr.ipos_plan_task' doesn't exist [2026-09-26 17:52:40] select Id,dydm from ipos_dianyuan[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:52:40] SELECT max(unix_timestamp(lastchanged)) FROM ipos_qdtjd[1146] Table 'zzqr.ipos_qdtjd' doesn't exist [2026-09-26 17:52:40] SELECT tjdxyxjb FROM ipos_main LIMIT 1[1054] Unknown column 'tjdxyxjb' in 'field list' [2026-09-26 17:52:40] SELECT xp.zd_id, xp.zddm, xp.yyrq, COUNT(DISTINCT xp.Id) AS xpsl, SUM(xp.sl) AS sl, SUM(xp.je) AS je, SUM(xp.bzje-xp.je) AS yhje, (SUM(xp.je)/SUM(xp.sl)) AS avg_price, (SUM(xp.je)/SUM(xp.bzje)) AS avg_discount FROM ipos_qtlsd xp WHERE xp.yyrq=1790265600 AND 1=1 AND 1=1 GROUP BY xp.zd_id LIMIT 0, 100[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:52:41] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:52:41] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:52:41] SELECT vp.Id,vp.sj from ipos_vip vp inner join ipos_viplb lb on lb.Id = vp.lb_id where vp.icrm_is_fetch = 1 and vp.status=1 and lb.Id in(11,12,13,14) order by vp.lastchanged desc limit 100[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:52:42] SELECT lsz.Id from ipos_vplsz lsz inner join ipos_vip vp on vp.Id=lsz.vp_id inner join ipos_viplb lb on lb.Id = vp.lb_id where lsz.tj=0 and lsz.jf <> 0 and lb.Id in(11,12,13,14) and lsz.czsj >'1787673600'[1146] Table 'zzqr.ipos_vplsz' doesn't exist [2026-09-26 17:52:42] select * from ipos_plan_task where task_url=''[1146] Table 'zzqr.ipos_plan_task' doesn't exist [2026-09-26 17:52:42] SELECT vp.Id,UNIX_TIMESTAMP(vp.lastchanged) lastchanged from ipos_vip vp inner join ipos_viplb lb on lb.Id = vp.lb_id where vp.status=1 and lb.Id in(11,12,13,14) and vp.lastchanged>= '2026-09-26'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:52:43] SELECT cus.Id from ipos_customer cus inner join ipos_vip vp on vp.gk_id=cus.Id inner join ipos_viplb lb on lb.Id = vp.lb_id where cus.icrm_is_fetch = 1 and IFNULL(cus.xgrq,0) > 0 and lb.Id in(11,12,13,14)[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:52:43] select * from ipos_vplsz where jfcz > 0 and jf <> 0 and (tj =0 or tj is null) order by Id limit 0, 100[1146] Table 'zzqr.ipos_vplsz' doesn't exist [2026-09-26 17:52:44] SELECT lsz.Id, lsz.czsj, lsz.vpdm, lsz.zj, lsz.jf, lsz.bz, lsz.yxrq FROM ipos_vplsz lsz INNER JOIN ipos_vip vp ON lsz.vp_id=vp.Id WHERE lsz.jf <> 0 AND lsz.status_code ^ 1 AND 1=1 ORDER BY lsz.Id ASC LIMIT 0, 50[1146] Table 'zzqr.ipos_vplsz' doesn't exist [2026-09-26 17:52:45] SELECT cus.Id,cus.tjgk_id,cus.jltjrjf,vp.lb_id,vp.scdh FROM ipos_vip vp inner join ipos_customer cus on vp.gk_id=cus.Id WHERE vp.scdh!='' AND cus.tjgk_id>0 AND cus.jltjrjf=0[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:52:46] select lxdj,zd_id from ipos_vplsz where lxdj!='' and dgy_list_mc=''[1146] Table 'zzqr.ipos_vplsz' doesn't exist [2026-09-26 17:52:46] select * from ipos_vip where tn_id <> 2 limit 0,3000[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:52:46] select * from ipos_vpczklsz where tn_id <> 2 limit 0,3000[1146] Table 'zzqr.ipos_vpczklsz' doesn't exist [2026-09-26 17:52:46] select * from ipos_plan_task where task_url=''[1146] Table 'zzqr.ipos_plan_task' doesn't exist [2026-09-26 17:52:51] select Id, kwdm from ipos_kuwei[1146] Table 'zzqr.ipos_kuwei' doesn't exist [2026-09-26 17:52:51] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:52:51] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:52:52] SELECT gk_id, SUM(je) as je, SUM(sl) as sl FROM ipos_gkxfmx0 WHERE zhyxf = 1 GROUP BY gk_id[1146] Table 'zzqr.ipos_gkxfmx0' doesn't exist [2026-09-26 17:52:52] SELECT gk_id, SUM(je) as je, SUM(sl) as sl FROM ipos_gkxfmx1 WHERE zhyxf = 1 GROUP BY gk_id[1146] Table 'zzqr.ipos_gkxfmx1' doesn't exist [2026-09-26 17:52:52] SELECT gk_id, SUM(je) as je, SUM(sl) as sl FROM ipos_gkxfmx2 WHERE zhyxf = 1 GROUP BY gk_id[1146] Table 'zzqr.ipos_gkxfmx2' doesn't exist [2026-09-26 17:52:52] SELECT gk_id, SUM(je) as je, SUM(sl) as sl FROM ipos_gkxfmx3 WHERE zhyxf = 1 GROUP BY gk_id[1146] Table 'zzqr.ipos_gkxfmx3' doesn't exist [2026-09-26 17:52:52] SELECT gk_id, SUM(je) as je, SUM(sl) as sl FROM ipos_gkxfmx4 WHERE zhyxf = 1 GROUP BY gk_id[1146] Table 'zzqr.ipos_gkxfmx4' doesn't exist [2026-09-26 17:52:52] SELECT gk_id, SUM(je) as je, SUM(sl) as sl FROM ipos_gkxfmx5 WHERE zhyxf = 1 GROUP BY gk_id[1146] Table 'zzqr.ipos_gkxfmx5' doesn't exist [2026-09-26 17:52:52] SELECT gk_id, SUM(je) as je, SUM(sl) as sl FROM ipos_gkxfmx6 WHERE zhyxf = 1 GROUP BY gk_id[1146] Table 'zzqr.ipos_gkxfmx6' doesn't exist [2026-09-26 17:52:52] SELECT gk_id, SUM(je) as je, SUM(sl) as sl FROM ipos_gkxfmx7 WHERE zhyxf = 1 GROUP BY gk_id[1146] Table 'zzqr.ipos_gkxfmx7' doesn't exist [2026-09-26 17:52:52] SELECT gk_id, SUM(je) as je, SUM(sl) as sl FROM ipos_gkxfmx8 WHERE zhyxf = 1 GROUP BY gk_id[1146] Table 'zzqr.ipos_gkxfmx8' doesn't exist [2026-09-26 17:52:52] SELECT gk_id, SUM(je) as je, SUM(sl) as sl FROM ipos_gkxfmx9 WHERE zhyxf = 1 GROUP BY gk_id[1146] Table 'zzqr.ipos_gkxfmx9' doesn't exist [2026-09-26 17:52:53] UPDATE ipos_vplsz SET yxrq=(UNIX_TIMESTAMP(date_add(FROM_UNIXTIME(yxrq, '%Y-%m-01'), interval 1 month)) - 86400) WHERE yxrq > 0 AND czsj >=1790265600 AND czsj < 1790352000[1146] Table 'zzqr.ipos_vplsz' doesn't exist [2026-09-26 17:54:04] SELECT * FROM ipos_qtlsd WHERE cf_flag=0 AND zddm IN ('') AND gd=0 LIMIT 1000[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:54:19] SELECT vp_id,sum(if(zj*jf<0,zj*jf,0)) as syjf FROM ipos_vplsz WHERE czsj>=1785513600 AND czsj<=1788191999 GROUP BY vp_id[1146] Table 'zzqr.ipos_vplsz' doesn't exist [2026-09-26 17:54:20] SELECT * FROM ipos_vplsz WHERE ifnull(row_no,0)!=1 AND jfcz!=1 AND jfcz!=0 AND jf<>0 AND czsj<=1790416460[1146] Table 'zzqr.ipos_vplsz' doesn't exist [2026-09-26 17:54:20] UPDATE ipos_vplsz set row_no=1 where czsj<=1790416460[1146] Table 'zzqr.ipos_vplsz' doesn't exist [2026-09-26 17:54:45] select * from ipos_plan_task where task_url=''[1146] Table 'zzqr.ipos_plan_task' doesn't exist [2026-09-26 17:54:46] select * from ipos_plan_task where task_url=''[1146] Table 'zzqr.ipos_plan_task' doesn't exist [2026-09-26 17:54:46] select * from ipos_plan_task where task_url=''[1146] Table 'zzqr.ipos_plan_task' doesn't exist [2026-09-26 17:54:46] SELECT user_id from admin_user where tj = 0 and user_type = 2 ORDER by user_id limit 100[1054] Unknown column 'tj' in 'where clause' [2026-09-26 17:54:46] SELECT Id,sr1 FROM ipos_vip where length(sr1)>0[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:54:47] SELECT Id from ipos_qtlsd where icrm_is_fetch = 1 and vpdm != '' and (ifnull(gd,0) = 0) AND (ifnull(zf,0) = 0) and (ifnull(ydjh,'')='' or ydjh = '0')[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:54:47] select * from ipos_plan_task where task_url=''[1146] Table 'zzqr.ipos_plan_task' doesn't exist [2026-09-26 17:54:47] update ipos_xsjlb set rj=1 where rj=0[1146] Table 'zzqr.ipos_xsjlb' doesn't exist [2026-09-26 17:54:47] select * from ipos_plan_task where task_url=''[1146] Table 'zzqr.ipos_plan_task' doesn't exist [2026-09-26 17:54:47] SELECT Id from ipos_qtlsd where icrm_is_fetch = 1 and vpdm != '' and (ifnull(gd,0) = 0) AND (ifnull(zf,0) = 0) and ifnull(ydjh,'')<>'' and ydjh != '0'[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:54:47] UPDATE ipos_kbcxd SET sydx='1,2' WHERE cxdx=0 AND sydx=''[1146] Table 'zzqr.ipos_kbcxd' doesn't exist [2026-09-26 17:54:47] UPDATE ipos_kbcxd SET sydx=1 WHERE cxdx=1 AND sydx=''[1146] Table 'zzqr.ipos_kbcxd' doesn't exist [2026-09-26 17:54:47] UPDATE ipos_kbcxd SET sydx=2 WHERE cxdx=2 AND sydx=''[1146] Table 'zzqr.ipos_kbcxd' doesn't exist [2026-09-26 17:54:47] UPDATE ipos_zdcxd SET sydx='1,2' WHERE cxdx=0 AND sydx=''[1146] Table 'zzqr.ipos_zdcxd' doesn't exist [2026-09-26 17:54:47] UPDATE ipos_zdcxd SET sydx=1 WHERE cxdx=1 AND sydx=''[1146] Table 'zzqr.ipos_zdcxd' doesn't exist [2026-09-26 17:54:47] UPDATE ipos_zdcxd SET sydx=2 WHERE cxdx=2 AND sydx=''[1146] Table 'zzqr.ipos_zdcxd' doesn't exist [2026-09-26 17:54:47] SELECT Id from ipos_vpczklsz where crm_is_fetch = 1[1146] Table 'zzqr.ipos_vpczklsz' doesn't exist [2026-09-26 17:54:47] select * from ipos_plan_task where task_url=''[1146] Table 'zzqr.ipos_plan_task' doesn't exist [2026-09-26 17:54:48] select platform_id,merchant_no from ipos_mszf_config where platform_id<>'' GROUP BY platform_id,merchant_no[1146] Table 'zzqr.ipos_mszf_config' doesn't exist [2026-09-26 17:54:48] select khdm,cbk.Id from com_base_kehu cbk INNER JOIN ipos_zdkzb iz ON iz.pid=cbk.Id where jktx=1[1054] Unknown column 'jktx' in 'where clause' [2026-09-26 17:54:48] SELECT Id,wc FROM ipos_pay_bill WHERE mch_id='' and yyrq='20260925' and type='cmbc'[1146] Table 'zzqr.ipos_pay_bill' doesn't exist [2026-09-26 17:54:48] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '15'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:54:48] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:54:49] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '16'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:54:49] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:54:49] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '17'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:54:49] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:54:49] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '18'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:54:49] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:54:49] SELECT Id FROM ipos_kuwei WHERE kwdm='000'[1146] Table 'zzqr.ipos_kuwei' doesn't exist [2026-09-26 17:54:49] UPDATE ipos_zdkw SET kw_id=1 WHERE kw_id=[1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 [2026-09-26 17:54:49] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '19'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:54:49] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:54:49] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '20'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:54:49] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:54:49] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '21'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:54:49] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:54:50] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '22'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:54:50] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:54:50] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '23'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:54:50] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:54:50] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '24'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:54:50] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:54:50] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '25'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:54:50] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:54:50] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '26'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:54:50] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:54:50] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '27'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:54:50] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:54:51] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '28'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:54:51] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:54:51] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '29'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:54:51] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:54:51] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '30'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:54:51] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:54:51] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '31'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:54:51] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:54:51] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '32'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:54:51] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:54:51] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '33'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:54:51] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:54:52] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '34'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:54:52] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:54:55] SELECT * FROM ipos_vip WHERE dqjf>0 AND qyrq<1790265600 AND (FROM_UNIXTIME(qyrq,'%m-%d')='03-26' or FROM_UNIXTIME(qyrq,'%m-%d')='09-26')[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:01] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '35'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:01] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:01] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '36'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:01] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:01] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '37'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:01] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:01] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '38'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:01] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:02] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '39'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:02] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:02] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '40'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:02] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:02] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '41'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:02] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:05] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '42'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:05] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:05] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '43'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:05] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:08] SELECT Id,1 CXType,djbh CXDM,hdmc CXMC,rq_1 StartRQ,rq_2 EndRQ,cxlx CXLX,sp,zz from ipos_zdcxd where icrm_is_fetch=1 and sp=1 limit 10[1146] Table 'zzqr.ipos_zdcxd' doesn't exist [2026-09-26 17:55:08] SELECT Id,2 CXType,djbh CXDM,hdmc CXMC,rq_1 StartRQ,rq_2 EndRQ,cxlx CXLX,sp,zz from ipos_kbcxd where icrm_is_fetch=1 and sp=1 limit 10[1146] Table 'zzqr.ipos_kbcxd' doesn't exist [2026-09-26 17:55:08] select * from ipos_plan_task where task_url=''[1146] Table 'zzqr.ipos_plan_task' doesn't exist [2026-09-26 17:55:08] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '44'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:08] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:09] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '45'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:09] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:09] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '46'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:09] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:09] SELECT Id from ipos_qtlsd where icrm_is_fetch = 1 and (ifnull(gd,0) = 0) AND (ifnull(zf,0) = 0) and vpdm != ''[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:55:09] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '47'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:09] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:09] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '48'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:09] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:09] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '49'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:09] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:09] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '50'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:09] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:11] SELECT Id from ipos_qtlsd where icrm_is_fetch = 1 and IFNULL(gd,0)=0 and IFNULL(zf,0)=0 and ifnull(vpdm, '') <> ''[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:55:11] SELECT Id,sj from ipos_vip where icrm_is_fetch = 1 and status=1 order by lastchanged desc limit 100[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:12] SELECT lsz.Id from ipos_vplsz lsz where lsz.tj=0 and lsz.jf <> 0 and lsz.czsj >'1787673600'[1146] Table 'zzqr.ipos_vplsz' doesn't exist [2026-09-26 17:55:13] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '51'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:13] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:13] select * from ipos_plan_task where task_url=''[1146] Table 'zzqr.ipos_plan_task' doesn't exist [2026-09-26 17:55:13] SELECT Id,UNIX_TIMESTAMP(lastchanged) lastchanged from ipos_vip where lastchanged>= '2026-09-26'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:13] SELECT Id from ipos_kbcxd where sp = 1 and zz = 0 and icrm_is_fetch = 1 and jtvip = 1 limit 1[1146] Table 'zzqr.ipos_kbcxd' doesn't exist [2026-09-26 17:55:13] SELECT Id from ipos_zdcxd where sp = 1 and zz = 0 and icrm_is_fetch = 1 and jtvip = 1 limit 1[1146] Table 'zzqr.ipos_zdcxd' doesn't exist [2026-09-26 17:55:13] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '52'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:13] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:13] SELECT Id from ipos_dianyuan where icrm_is_fetch = 1 and zd_id in (select pid from ipos_zdkzb where hy_icrm = 1) and ty = 0[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:13] SELECT vp.vpdm OldCode,vp.vpmc NickName,vp.sj MobileNo,vp.vpmc NAME,vplb.lbmc Grade,CASE WHEN xb = 1 THEN 2 ELSE 1 END Sex, FROM_UNIXTIME(cus.sr1, '%Y-%m-%d') Birthday,'' WeibNo,cus.qq QqNo,'' TbNo,cus.Email Email,cus.province_id Province,cus.city_id City, cus.district_id County FROM ipos_customer cus INNER JOIN ipos_vip vp ON vp.gk_id = cus.Id inner join ipos_viplb vplb on vplb.Id=vp.lb_id where 1=1 and cus.Id='51' order by cus.lastchanged desc limit 1[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:13] select * from ipos_plan_task where task_url=''[1146] Table 'zzqr.ipos_plan_task' doesn't exist [2026-09-26 17:55:14] SELECT a.Id from ipos_qtlsd a inner join ipos_zdkzb b on a.zd_id = b.pid where a.icrm_is_fetch in ('1','0') and (ifnull(a.gd,0) = 0) AND (ifnull(a.zf,0) = 0) and a.vpdm != '' and a.yyrq > '1441036800'[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:55:14] SELECT DISTINCT(a.Id) as Id,a.zdrq FROM ipos_qtlsd a INNER JOIN ipos_zdkzb b ON a.zd_id = b.pid left join ipos_qtlsdmx c on c.pid = a.Id left join ipos_qtlsdjs d on d.pid = a.Id WHERE a.icrm_is_fetch IN ( '1', '0' ) AND a.gd= 0 AND a.zf = 0 AND a.yyrq > '1441036800' and (c.dzbh <> '' or d.dm <> '')[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:55:14] SELECT c.Id from ipos_customer c inner join ipos_zdkzb b on c.zd_id = b.pid where c.vip = 2 and c.icrm_is_fetch = 1 and b.is_owt = 1[1054] Unknown column 'b.is_owt' in 'where clause' [2026-09-26 17:55:14] select * from ipos_plan_task where task_url=''[1146] Table 'zzqr.ipos_plan_task' doesn't exist [2026-09-26 17:55:14] SELECT Id from ipos_qtlsd where icrm_is_fetch = 1 and zd_id in (select pid from ipos_zdkzb where hy_icrm = 1) and (ifnull(gd,0) = 0) AND (ifnull(zf,0) = 0)[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:55:15] select Id,dymc from ipos_dianyuan[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:15] SELECT lsz.Id, lsz.lxdj, xp.je, xp.sl, xp.syy_id FROM ipos_czklsz lsz LEFT JOIN ipos_qtlsd xp ON lsz.lxdj = xp.djbh WHERE lsz.czdm = 2 AND lsz.lxdj != '' AND xp.gd = 0 AND xp.zf = 0[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:55:15] SELECT Id from ipos_vip where status = 1 and icrm_is_fetch = 1 and (zd_id in (select pid from ipos_zdkzb where hy_icrm = 1) or sszd_id in (select pid from ipos_zdkzb where hy_icrm = 1))[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:15] select zddm, orgdm, crm_id, sj, vpdm from ipos_vip where Id = '5'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:15] select zddm, orgdm, crm_id, sj, vpdm from ipos_vip where sj = '17737173359'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:15] select czkdm from ipos_zdczkxsd where sp = 1 and ifnull(gk_id,0) = 0 and (gkdm != '' or sj != '')[1146] Table 'zzqr.ipos_zdczkxsd' doesn't exist [2026-09-26 17:55:16] SELECT Id from ipos_vpczd where icrm_is_fetch = 1 and sp = 1[1146] Table 'zzqr.ipos_vpczd' doesn't exist [2026-09-26 17:55:16] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '53'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:16] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:16] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '54'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:16] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:16] select dm from ipos_o2okctbszd where Id='303'[1146] Table 'zzqr.ipos_o2okctbszd' doesn't exist [2026-09-26 17:55:16] SELECT qimen_store_id FROM com_base_kehu WHERE Id='39'[1054] Unknown column 'qimen_store_id' in 'field list' [2026-09-26 17:55:16] SELECT Id from ipos_vpcztzd where icrm_is_fetch = 1 and sp = 1[1146] Table 'zzqr.ipos_vpcztzd' doesn't exist [2026-09-26 17:55:16] select czk.Id,czk.czkdm,czk.jmw_pp,czk.lqlx,lb.lbdm from ipos_czk czk inner join ipos_czklb lb on czk.lb_id=lb.Id WHERE lb.lbdm in('EZR_XJQ_LB','EZR_ZKQ_LB','EZR_LPQ_LB') and czk.push_state=0 and czk.status=4[1054] Unknown column 'czk.jmw_pp' in 'field list' [2026-09-26 17:55:16] delete from ipos_qimen_notify where lastchanged < '2026-09-19'[1146] Table 'zzqr.ipos_qimen_notify' doesn't exist [2026-09-26 17:55:16] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '55'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:16] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:17] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '56'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:17] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:17] SELECT Id from ipos_refundorder where icrm_is_fetch = 1 and sp = 1[1146] Table 'zzqr.ipos_refundorder' doesn't exist [2026-09-26 17:55:17] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:55:17] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:55:17] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '57'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:17] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:18] select pid,dpck from ipos_zdkzb[1054] Unknown column 'dpck' in 'field list' [2026-09-26 17:55:20] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '58'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:20] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:20] SELECT Id,sxmc FROM ipos_vpsx1[1146] Table 'zzqr.ipos_vpsx1' doesn't exist [2026-09-26 17:55:20] SELECT Id,sxmc FROM ipos_vpsx2[1146] Table 'zzqr.ipos_vpsx2' doesn't exist [2026-09-26 17:55:20] SELECT Id,sxmc FROM ipos_vpsx3[1146] Table 'zzqr.ipos_vpsx3' doesn't exist [2026-09-26 17:55:20] SELECT Id,sxmc FROM ipos_vpsx4[1146] Table 'zzqr.ipos_vpsx4' doesn't exist [2026-09-26 17:55:20] SELECT Id,sxmc FROM ipos_vpsx5[1146] Table 'zzqr.ipos_vpsx5' doesn't exist [2026-09-26 17:55:20] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '59'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:20] SELECT Id,sxmc FROM ipos_vpsx6[1146] Table 'zzqr.ipos_vpsx6' doesn't exist [2026-09-26 17:55:20] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:20] SELECT Id,sxmc FROM ipos_vpsx7[1146] Table 'zzqr.ipos_vpsx7' doesn't exist [2026-09-26 17:55:20] SELECT Id,sxmc FROM ipos_vpsx8[1146] Table 'zzqr.ipos_vpsx8' doesn't exist [2026-09-26 17:55:20] SELECT Id,sxmc FROM ipos_vpsx9[1146] Table 'zzqr.ipos_vpsx9' doesn't exist [2026-09-26 17:55:20] SELECT Id,sxmc FROM ipos_vpsx10[1146] Table 'zzqr.ipos_vpsx10' doesn't exist [2026-09-26 17:55:20] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '60'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:20] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:20] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '61'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:20] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:20] SELECT * FROM ipos_qtlsd_web WHERE qr=2 and qh=1 and finish=0[1146] Table 'zzqr.ipos_qtlsd_web' doesn't exist [2026-09-26 17:55:21] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '62'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:21] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:21] UPDATE ipos_gkxfmx0 mx, com_base_shangpin sp SET mx.pp_id=sp.pp_id WHERE mx.sp_id = sp.Id[1146] Table 'zzqr.ipos_gkxfmx0' doesn't exist [2026-09-26 17:55:21] UPDATE ipos_gkxfmx1 mx, com_base_shangpin sp SET mx.pp_id=sp.pp_id WHERE mx.sp_id = sp.Id[1146] Table 'zzqr.ipos_gkxfmx1' doesn't exist [2026-09-26 17:55:21] UPDATE ipos_gkxfmx2 mx, com_base_shangpin sp SET mx.pp_id=sp.pp_id WHERE mx.sp_id = sp.Id[1146] Table 'zzqr.ipos_gkxfmx2' doesn't exist [2026-09-26 17:55:21] UPDATE ipos_gkxfmx3 mx, com_base_shangpin sp SET mx.pp_id=sp.pp_id WHERE mx.sp_id = sp.Id[1146] Table 'zzqr.ipos_gkxfmx3' doesn't exist [2026-09-26 17:55:21] UPDATE ipos_gkxfmx4 mx, com_base_shangpin sp SET mx.pp_id=sp.pp_id WHERE mx.sp_id = sp.Id[1146] Table 'zzqr.ipos_gkxfmx4' doesn't exist [2026-09-26 17:55:21] UPDATE ipos_gkxfmx5 mx, com_base_shangpin sp SET mx.pp_id=sp.pp_id WHERE mx.sp_id = sp.Id[1146] Table 'zzqr.ipos_gkxfmx5' doesn't exist [2026-09-26 17:55:21] UPDATE ipos_gkxfmx6 mx, com_base_shangpin sp SET mx.pp_id=sp.pp_id WHERE mx.sp_id = sp.Id[1146] Table 'zzqr.ipos_gkxfmx6' doesn't exist [2026-09-26 17:55:21] UPDATE ipos_gkxfmx7 mx, com_base_shangpin sp SET mx.pp_id=sp.pp_id WHERE mx.sp_id = sp.Id[1146] Table 'zzqr.ipos_gkxfmx7' doesn't exist [2026-09-26 17:55:21] UPDATE ipos_gkxfmx8 mx, com_base_shangpin sp SET mx.pp_id=sp.pp_id WHERE mx.sp_id = sp.Id[1146] Table 'zzqr.ipos_gkxfmx8' doesn't exist [2026-09-26 17:55:21] UPDATE ipos_gkxfmx9 mx, com_base_shangpin sp SET mx.pp_id=sp.pp_id WHERE mx.sp_id = sp.Id[1146] Table 'zzqr.ipos_gkxfmx9' doesn't exist [2026-09-26 17:55:21] UPDATE ipos_qtlsdmx mx, com_base_shangpin sp SET mx.pp_id=sp.pp_id WHERE mx.sp_id = sp.Id[1146] Table 'zzqr.ipos_qtlsdmx' doesn't exist [2026-09-26 17:55:21] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '63'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:21] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:21] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '64'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:21] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:21] SELECT * from ipos_qtlsd_web where bdxd=1 and bdfh=0 and tj=0 order by Id desc limit 100[1146] Table 'zzqr.ipos_qtlsd_web' doesn't exist [2026-09-26 17:55:21] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '65'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:21] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:21] select * from ipos_gkzlbgsqd[1146] Table 'zzqr.ipos_gkzlbgsqd' doesn't exist [2026-09-26 17:55:22] TRUNCATE ipos_vip_zd[1146] Table 'zzqr.ipos_vip_zd' doesn't exist [2026-09-26 17:55:22] SELECT gk_id,zd_id,zddm,zdmc,je,sl,czsj,lxdj FROM ipos_gklsz WHERE xfcz>=1 and xfcz<=2 UNION ALL SELECT m.gk_id,lsz.zd_id,lsz.zddm,lsz.zdmc,lsz.je,lsz.sl,lsz.czsj,lsz.lxdj FROM ipos_vplsz lsz LEFT JOIN ipos_vip m ON m.Id = lsz.vp_id WHERE lsz.jfcz>=1 and lsz.jfcz<=3[1146] Table 'zzqr.ipos_gklsz' doesn't exist [2026-09-26 17:55:22] TRUNCATE ipos_vip_zd[1146] Table 'zzqr.ipos_vip_zd' doesn't exist [2026-09-26 17:55:22] INSERT INTO ipos_vip_zd(vp_id,vpdm,vpmc,zd_id,zddm,zdmc,xfsl,xfje,xfjf) select vp_id,vpdm,vpmc,zd_id,zddm,zdmc,sum(sl),sum(je),sum(jf*zj) from ipos_vplsz where jfcz>=1 and jfcz<=3 and zd_id>0 group by vp_id,zd_id[1146] Table 'zzqr.ipos_vip_zd' doesn't exist [2026-09-26 17:55:22] select * from ipos_vip_zd[1146] Table 'zzqr.ipos_vip_zd' doesn't exist [2026-09-26 17:55:23] TRUNCATE ipos_vip_yhinfo[1146] Table 'zzqr.ipos_vip_yhinfo' doesn't exist [2026-09-26 17:55:23] SELECT m.djbh,m.yyrq,m.vpdm,m.sryhsl,m.org_id,m.zd_id FROM ipos_qtlsd m WHERE m.gd=0 and m.vpdm!='' and m.sryhsl<>0 AND m.zf=0[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:55:23] SELECT djh,qrrq as yyrq,vpdm,org_id,zd_id,sum(sl) as vpxesl,sum(je) as je,sum(ckj*sl) as ckje FROM ipos_qtlsdmx WHERE gd=0 AND zf=0 AND vpxe=1 group by djh[1146] Table 'zzqr.ipos_qtlsdmx' doesn't exist [2026-09-26 17:55:23] select * from ipos_plan_task where task_url=''[1146] Table 'zzqr.ipos_plan_task' doesn't exist [2026-09-26 17:55:23] select * from sys_app_user order by app_user_id desc[1146] Table 'zzqr.sys_app_user' doesn't exist [2026-09-26 17:55:23] select * from ipos_qtlsd where Id ='5'[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:55:23] select * from ipos_qtlsdmx where pid ='5'[1146] Table 'zzqr.ipos_qtlsdmx' doesn't exist [2026-09-26 17:55:23] select * from ipos_qtlsdjs where Id ='5'[1146] Table 'zzqr.ipos_qtlsdjs' doesn't exist [2026-09-26 17:55:23] select * from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:23] select * from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:24] select qy_retailo2o,retail_key,retail_secret,retail_url from ipos_main[1054] Unknown column 'qy_retailo2o' in 'field list' [2026-09-26 17:55:24] SELECT distinct zddm FROM ipos_o2okctb_tyzdsp WHERE status=0[1146] Table 'zzqr.ipos_o2okctb_tyzdsp' doesn't exist [2026-09-26 17:55:24] select qy_retailo2o,retail_key,retail_secret,retail_url from ipos_main[1054] Unknown column 'qy_retailo2o' in 'field list' [2026-09-26 17:55:24] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '66'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:24] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:24] SELECT webbh as ydjh, tihuoma_pt lylx, tihuoma th_taobao_yzm, Id, djbh from ipos_qtlsd_web a where (qr=2 || finish=1) and tihuoma_hx=0 and ifnull(tihuoma, '') != '' ORDER BY Id desc[1146] Table 'zzqr.ipos_qtlsd_web' doesn't exist [2026-09-26 17:55:24] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '67'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:24] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:25] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '68'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:25] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:25] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '69'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:25] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:25] select distinct lsz.vp_id, vip.sj, vip.dqjf, vip.lb_id, vip.passport_seller_name, vip.vpdm, vip.status from ipos_vplsz lsz, ipos_vip vip where lsz.vp_id=vip.Id AND vip.passport_is_bind=1 AND lsz.tj=0;[1146] Table 'zzqr.ipos_vplsz' doesn't exist [2026-09-26 17:55:25] select * from ipos_plan_task where task_url=''[1146] Table 'zzqr.ipos_plan_task' doesn't exist [2026-09-26 17:55:26] select * from ipos_qtlsd_web_qr where qr = 0[1146] Table 'zzqr.ipos_qtlsd_web_qr' doesn't exist [2026-09-26 17:55:26] select * from ipos_plan_task where task_url=''[1146] Table 'zzqr.ipos_plan_task' doesn't exist [2026-09-26 17:55:27] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:55:27] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:55:27] SELECT Id from ipos_qtlsd where icrm_is_fetch = 1 and (ifnull(gd,0) = 0) AND (ifnull(zf,0) = 0)[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:55:27] select ppdm from ipos_jmw_pp ORDER BY ppdm asc LIMIT 1[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:55:27] select * from ipos_plan_task where task_url=''[1146] Table 'zzqr.ipos_plan_task' doesn't exist [2026-09-26 17:55:27] SELECT Id from ipos_dianyuan where icrm_is_fetch = 1 and ty = 0[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:28] select lsz.* from ipos_vpczklsz lsz where crm_is_fetch = 1 order by lsz.czsj limit 0, 100[1146] Table 'zzqr.ipos_vpczklsz' doesn't exist [2026-09-26 17:55:28] select pid,vp_id,vpdm,vpmc,zd_id,zddm,zdmc,sum(yxjf) as yxjf,lylx from ipos_vplsz where jfcz!=4 and (yxrq < 1790416528 and yxrq!=0) and yxjf <> 0 group by vpdm[1146] Table 'zzqr.ipos_vplsz' doesn't exist [2026-09-26 17:55:28] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '70'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:28] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:28] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '71'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:28] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:28] select lsz.* from ipos_vplsz lsz where (lsz.tj =0 or lsz.tj is null) and jfcz not IN () order by lsz.Id limit 0, 100[1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') order by lsz.Id limit 0, 100' at line 2 [2026-09-26 17:55:28] SELECT baison_unday_time FROM ipos_zdkzb[1054] Unknown column 'baison_unday_time' in 'field list' [2026-09-26 17:55:28] select pid,baison_unday from ipos_zdkzb where baison_unday >= 0[1054] Unknown column 'baison_unday' in 'field list' [2026-09-26 17:55:28] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '72'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:28] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:28] select count(*) from (select kh.khdm as ShopCode,FROM_UNIXTIME(m.yyrq,'%Y-%m-%d') as SaleDate,sum(mx.sl) as SaleQty,count(DISTINCT m.djbh) as SaleNum,ROUND(sum(mx.je),2) as SaleMoney,ROUND(sum(abs(mx.ckj)*mx.sl-mx.je),2) as SaleDiscountMoney,ROUND(avg(mx.dj),2) as AvgPrice,ROUND(avg(mx.zk),2) as AvgDiscount from ipos_qtlsd m inner join ipos_qtlsdmx mx on m.Id=mx.pid inner join com_base_kehu kh on m.zd_id=kh.Id where m.yyrq='1790352000' and kh.jmw_pp='j1' group by m.zd_id,m.yyrq) as tmp[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:55:28] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:55:28] select zddm as ShopCode,FROM_UNIXTIME(yyrq,'%Y-%m-%d') as SaleDate,sum(mx.sl) as SaleQty,count(DISTINCT m.djbh) as SaleNum,ROUND(sum(mx.je),2) as SaleMoney, ROUND(sum(abs(mx.ckj)*mx.sl - mx.je),2) as SaleDiscountMoney,ROUND(avg(mx.dj),2) as AvgPrice,ROUND(avg(mx.zk),2) as AvgDiscount,kh.jmw_pp as Brand from ipos_qtlsd m inner join ipos_qtlsdmx mx on m.Id=mx.pid inner join com_base_kehu kh on m.zd_id=kh.Id where m.yyrq='1790352000' and kh.jmw_pp='j1' group by m.yyrq,m.zd_id LIMIT 0 ,100[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:55:28] select count(1) from (select zddm as ShopCode,FROM_UNIXTIME(yyrq,'%Y-%m-%d') as SaleDate,sum(mx.sl) as SaleQty,count(DISTINCT m.djbh) as SaleNum,ROUND(sum(mx.je),2) as SaleMoney, ROUND(sum(abs(mx.ckj)*mx.sl - mx.je),2) as SaleDiscountMoney,ROUND(avg(mx.dj),2) as AvgPrice,ROUND(avg(mx.zk),2) as AvgDiscount,kh.jmw_pp as Brand from ipos_qtlsd m inner join ipos_qtlsdmx mx on m.Id=mx.pid inner join com_base_kehu kh on m.zd_id=kh.Id where m.yyrq='1790352000' and kh.jmw_pp='j1' group by m.yyrq,m.zd_id LIMIT 0 ,100 ) a[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:55:28] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:55:29] select pid,hdjcd_cl_num from ipos_zdkzb where hdjcd_cl_num > 0[1054] Unknown column 'hdjcd_cl_num' in 'field list' [2026-09-26 17:55:29] SELECT Id from ipos_qtlsd where qdmj_is_fetch = 1 and (ifnull(gd,0) = 0) AND (ifnull(zf,0) = 0) and lyxt = 99 UNION ALL SELECT Id from ipos_qtlsd where qdmj_is_fetch = 1 AND zf = 1 and lyxt = 99[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:55:31] SELECT Id from ipos_qtlsd where gd=0 and zf=0 and icrm_is_fetch=1 limit 200[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:55:31] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '73'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:31] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:33] SELECT dj_id,zddm from RFID_INFO where tj = 0 AND last_upload=1[1146] Table 'zzqr.rfid_info' doesn't exist [2026-09-26 17:55:33] update RFID_INFO set tj=2,re_time='1790416533'WHERE dj_id in ('')[1146] Table 'zzqr.rfid_info' doesn't exist [2026-09-26 17:55:33] select * from sys_app_user order by app_user_id desc[1146] Table 'zzqr.sys_app_user' doesn't exist [2026-09-26 17:55:33] select * from ipos_qtlsd where Id ='6'[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:55:33] select * from ipos_qtlsdmx where pid ='6'[1146] Table 'zzqr.ipos_qtlsdmx' doesn't exist [2026-09-26 17:55:33] select * from ipos_qtlsdjs where Id ='6'[1146] Table 'zzqr.ipos_qtlsdjs' doesn't exist [2026-09-26 17:55:33] select * from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:33] select * from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:34] SELECT Id from ipos_dianyuan where icrm_is_fetch = 1 and ty = 0[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:35] select pid,vp_id,vpdm,vpmc,zd_id,zddm,zdmc,sum(yxjf) as yxjf,lylx from ipos_vplsz where jfcz!=4 and (yxrq < 1790416535 and yxrq!=0) and yxjf <> 0 group by vpdm[1146] Table 'zzqr.ipos_vplsz' doesn't exist [2026-09-26 17:55:35] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '74'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:35] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:35] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '75'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:35] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:35] SELECT vp.vpdm OldCode,vp.vpmc NickName,vp.sj MobileNo,vp.vpmc NAME,vplb.lbmc Grade,CASE WHEN xb = 1 THEN 2 ELSE 1 END Sex, FROM_UNIXTIME(cus.sr1, '%Y-%m-%d') Birthday,'' WeibNo,cus.qq QqNo,'' TbNo,cus.Email Email,cus.province_id Province,cus.city_id City, cus.district_id County FROM ipos_customer cus INNER JOIN ipos_vip vp ON vp.gk_id = cus.Id inner join ipos_viplb vplb on vplb.Id=vp.lb_id where 1=1 and cus.Id='157' order by cus.lastchanged desc limit 1[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:35] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '76'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:35] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:35] SELECT Id from ipos_qtlsd where icrm_is_fetch = 1 and vpdm != '' and (ifnull(gd,0) = 0) AND (ifnull(zf,0) = 0) and org_id in ( select 1 from ipos_main where sy_crm = 2 UNION ALL select pid from ipos_orgkzb where sy_crm = 2) limit 100[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:55:35] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '77'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:35] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:35] SELECT xp.djbh FROM ipos_qtlsd xp INNER JOIN ipos_vip vp ON xp.vp_id=vp.Id WHERE xp.gd=0 and xp.zf=0 and (xp.status_code & 4) = 0 AND 1=1 LIMIT 0, 20[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:55:35] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '78'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:35] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:35] SELECT Id from ipos_customer where icrm_is_fetch = 1 and org_id in ( select 1 from ipos_main where sy_crm = 2 UNION ALL select pid from ipos_orgkzb where sy_crm = 2)[1146] Table 'zzqr.ipos_orgkzb' doesn't exist [2026-09-26 17:55:36] select count(*) from (select zddm ShopCode,FROM_UNIXTIME(yyrq,'%Y-%m-%d') SaleDate,sum(mx.sl) SaleQty,count(DISTINCT m.djbh) as SaleNum,ROUND(sum(mx.je),2) SaleMoney ,ROUND(sum(abs(mx.ckj)*mx.sl - mx.je),2) SaleDiscountMoney,ROUND(avg(mx.dj),2) AvgPrice,ROUND(avg(mx.zk),2) AvgDiscount from ipos_qtlsd m inner join ipos_qtlsdmx mx on m.Id=mx.pid where 1=1 and FROM_UNIXTIME(yyrq,'%Y-%m-%d') ='2026-09-26' group by zddm,FROM_UNIXTIME(yyrq,'%Y-%m-%d')) as tmp[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:55:36] select zddm ShopCode,FROM_UNIXTIME(yyrq,'%Y-%m-%d') SaleDate,sum(mx.sl) SaleQty,count(DISTINCT m.djbh) as SaleNum,ROUND(sum(mx.je),2) SaleMoney ,ROUND(sum(abs(mx.ckj)*mx.sl - mx.je),2) SaleDiscountMoney,ROUND(avg(mx.dj),2) AvgPrice,ROUND(avg(mx.zk),2) AvgDiscount from ipos_qtlsd m inner join ipos_qtlsdmx mx on m.Id=mx.pid where 1=1 and FROM_UNIXTIME(yyrq,'%Y-%m-%d') ='2026-09-26' group by zddm,FROM_UNIXTIME(yyrq,'%Y-%m-%d') order by zddm LIMIT 0 ,100[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:55:36] select count(1) from ( select zddm ShopCode,FROM_UNIXTIME(yyrq,'%Y-%m-%d') SaleDate,sum(mx.sl) SaleQty,count(DISTINCT m.djbh) as SaleNum,ROUND(sum(mx.je),2) SaleMoney ,ROUND(sum(abs(mx.ckj)*mx.sl - mx.je),2) SaleDiscountMoney,ROUND(avg(mx.dj),2) AvgPrice,ROUND(avg(mx.zk),2) AvgDiscount from ipos_qtlsd m inner join ipos_qtlsdmx mx on m.Id=mx.pid where 1=1 and FROM_UNIXTIME(yyrq,'%Y-%m-%d') ='2026-09-26' group by zddm,FROM_UNIXTIME(yyrq,'%Y-%m-%d') order by zddm LIMIT 0 ,100 ) a[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:55:36] select DISTINCT pid as Id from ipos_qtlsdjs where pid in (SELECT Id from ipos_qtlsd where vpdm != '' and (ifnull(gd,0) = 0) AND (ifnull(zf,0) = 0) and org_id in ( select 1 from ipos_main where sy_crm = 2 UNION ALL select pid from ipos_orgkzb where sy_crm = 2)) and dm != '' and dm in (select czkdm from ipos_czk where lb_id in (select Id from ipos_czklb where lqlx = 1 and lq = 1)) and icrm_is_fetch = 1[1146] Table 'zzqr.ipos_qtlsdjs' doesn't exist [2026-09-26 17:55:37] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:55:37] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:55:37] select * from ipos_qtlsd where icrm_is_fetch = 1 and ifnull(vpdm, '') != ''[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:55:38] select sp.Id as spId,sp.spmc,jg.*,UNIX_TIMESTAMP(jg.lastchanged) as lasttime,gg1.ggmc as gg1mc,gg2.ggmc as gg2mc from ipos_spjgb jg inner join com_base_shangpin sp on sp.Id=jg.sp_id inner join com_base_spgg1 gg1 on gg1.sp_id=sp.Id inner join com_base_spgg2 gg2 on gg2.sp_id=sp.Id where sp.lylx=0 and sp.ty=0 and UNIX_TIMESTAMP(jg.lastchanged) > 0[1146] Table 'zzqr.ipos_spjgb' doesn't exist [2026-09-26 17:55:38] select count(*) from (select kh.khdm as ShopCode,FROM_UNIXTIME(yyrq,'%Y-%m-%d') as SaleDate,sum(mx.sl) as SaleQty,count(DISTINCT m.djbh) as SaleNum,ROUND(sum(mx.je),2) as SaleMoney,ROUND(sum(abs(mx.ckj)*mx.sl-mx.je),2) as SaleDiscountMoney,ROUND(avg(mx.dj),2) as AvgPrice,ROUND(avg(mx.zk),2) as AvgDiscount from ipos_qtlsd m inner join ipos_qtlsdmx mx on m.Id=mx.pid inner join com_base_kehu kh on m.zd_id=kh.Id where m.yyrq='1790352000' and kh.jmw_pp='joeone' group by m.zd_id,m.yyrq) as tmp[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:55:38] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:55:38] select zddm as ShopCode,FROM_UNIXTIME(yyrq,'%Y-%m-%d') as SaleDate,sum(mx.sl) as SaleQty,count(DISTINCT m.djbh) as SaleNum,ROUND(sum(mx.je),2) as SaleMoney, ROUND(sum(abs(mx.ckj)*mx.sl - mx.je),2) as SaleDiscountMoney,ROUND(avg(mx.dj),2) as AvgPrice,ROUND(avg(mx.zk),2) as AvgDiscount,kh.jmw_pp as Brand from ipos_qtlsd m inner join ipos_qtlsdmx mx on m.Id=mx.pid inner join com_base_kehu kh on m.zd_id=kh.Id where m.yyrq='1790352000' and kh.jmw_pp='joeone' group by m.yyrq,m.zd_id LIMIT 0 ,100[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:55:38] select count(1) from (select zddm as ShopCode,FROM_UNIXTIME(yyrq,'%Y-%m-%d') as SaleDate,sum(mx.sl) as SaleQty,count(DISTINCT m.djbh) as SaleNum,ROUND(sum(mx.je),2) as SaleMoney, ROUND(sum(abs(mx.ckj)*mx.sl - mx.je),2) as SaleDiscountMoney,ROUND(avg(mx.dj),2) as AvgPrice,ROUND(avg(mx.zk),2) as AvgDiscount,kh.jmw_pp as Brand from ipos_qtlsd m inner join ipos_qtlsdmx mx on m.Id=mx.pid inner join com_base_kehu kh on m.zd_id=kh.Id where m.yyrq='1790352000' and kh.jmw_pp='joeone' group by m.yyrq,m.zd_id LIMIT 0 ,100 ) a[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:55:38] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:55:38] SELECT lsd.Id,xl.jmw_pp from ipos_qtlsd lsd inner join ipos_vip vp on vp.vpdm=lsd.vpdm inner join ipos_viplb lb on lb.Id=vp.lb_id inner join ipos_hyxl xl on xl.Id = vp.xl_id where lsd.icrm_is_fetch=1 and lb.Id in(11,12,13,14) and lsd.gd=0 and lsd.zf=0 and lsd.vpdm<>''[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:55:38] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '79'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:38] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:39] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '80'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:39] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:39] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '81'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:39] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:55:39] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:39] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:55:39] select c.gkdm,c.gkmc,c.xb,c.sj,c.sr1,c.email,c.city_id,c.zd_id,c.dy_id,v.lb_id from ipos_customer c left join ipos_vip v on c.Id = v.gk_id where c.Id = '82'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:39] select dydm from ipos_dianyuan where Id=''[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:55:44] select Id from ipos_lxfa WHERE state = 1[1146] Table 'zzqr.ipos_lxfa' doesn't exist [2026-09-26 17:55:46] SELECT lsd.Id from ipos_qtlsd lsd inner join ipos_vip vp on vp.vpdm=lsd.vpdm inner join ipos_viplb lb on lb.Id = vp.lb_id where lsd.icrm_is_fetch = 1 and lb.Id in(11,12,13,14) and IFNULL(lsd.gd,0)=0 and IFNULL(lsd.zf,0)=0 and ifnull(lsd.vpdm, '') <> '' order by lsd.lastchanged desc[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:55:47] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:55:47] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:55:49] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:55:49] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:55:51] SELECT Id,jmw_pp from com_base_kehu where icrm_is_fetch = 1 and xzdm in (4,5)[1054] Unknown column 'jmw_pp' in 'field list' [2026-09-26 17:55:52] select ppdm from ipos_jmw_pp ORDER BY ppdm asc LIMIT 1[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:55:52] SELECT Id,jmw_pp from com_base_kehu where xzdm in (4,5) and ty=1 and row_no not in (2,3)[1054] Unknown column 'jmw_pp' in 'field list' [2026-09-26 17:55:53] select ppdm from ipos_jmw_pp ORDER BY ppdm asc LIMIT 1[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:55:54] SELECT vp.Id,vp.sj,xl.jmw_pp from ipos_vip vp inner join ipos_viplb lb on lb.Id = vp.lb_id inner join ipos_hyxl xl on xl.Id = vp.xl_id where vp.icrm_is_fetch=1 and vp.status=1 and lb.Id in(11,12,13,14) limit 100[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:54] SELECT lsz.*,xl.jmw_pp from ipos_vplsz lsz inner join ipos_vip vp on vp.Id=lsz.vp_id inner join ipos_viplb lb on lb.Id = vp.lb_id inner join ipos_hyxl xl on xl.Id = vp.xl_id where lsz.tj=0 and lsz.jf <> 0 and lb.Id in(11,12,13,14) and lsz.czsj >'1787673600'[1146] Table 'zzqr.ipos_vplsz' doesn't exist [2026-09-26 17:55:54] SELECT vp.Id,vp.gk_id,UNIX_TIMESTAMP(vp.lastchanged) as lastchanged,xl.jmw_pp as jmw_pp from ipos_vip vp inner join ipos_viplb lb on lb.Id = vp.lb_id inner join ipos_hyxl xl on xl.Id = vp.xl_id where vp.status=1 and lb.Id in(11,12,13,14,19,20,21,22) and vp.lastchanged>= '2026-09-26'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:55] SELECT last_time FROM ipos_yike_tran WHERE code='vipgradeupdate'[1146] Table 'zzqr.ipos_yike_tran' doesn't exist [2026-09-26 17:55:55] insert into ipos_yike_tran (`code`) values('vipgradeupdate')[1146] Table 'zzqr.ipos_yike_tran' doesn't exist [2026-09-26 17:55:55] select DISTINCT vpdm,ChangeTime,Remark from ( select vpdm,FROM_UNIXTIME(czsj) as ChangeTime,bz as Remark from ipos_vplsz where czsj>'1790352000' and lb_id in(11,12,13,14,19,20,21,22) and (bz like '%降级%' or bz like '%升级%') union all select vpdm,FROM_UNIXTIME(act_time) as ChangeTime,bz as Remark from ipos_vip_act where act_time>'1790352000' and lb_id in(11,12,13,14,19,20,21,22) and type in (2,9) ) tmp[1146] Table 'zzqr.ipos_vplsz' doesn't exist [2026-09-26 17:55:55] UPDATE ipos_yike_tran SET last_time='1790416555' WHERE code='vipgradeupdate'[1146] Table 'zzqr.ipos_yike_tran' doesn't exist [2026-09-26 17:55:56] SELECT cus.Id,xl.jmw_pp,vp.vpdm as OldCode,vp.vpmc as NickName,vp.sj as MobileNo,vp.vpmc as NAME,lb.lbmc as Grade,CASE WHEN cus.xb=0 THEN 1 WHEN cus.xb=1 THEN 2 ELSE 0 END as Sex, FROM_UNIXTIME(cus.sr1, '%Y-%m-%d') as Birthday,cus.qq as QqNo,cus.Email as Email,xl.jmw_pp as Brand from ipos_customer cus inner join ipos_vip vp on vp.gk_id=cus.Id inner join ipos_viplb lb on lb.Id = vp.lb_id inner join ipos_hyxl xl on xl.Id = vp.xl_id where cus.icrm_is_fetch=1 and cus.xgrq>0 and lb.Id in(11,12,13,14)[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:56] SELECT vp.vpdm OldCode,vp.vpmc NickName,vp.sj MobileNo,vp.vpmc NAME,vplb.lbmc Grade,CASE WHEN xb = 1 THEN 2 ELSE 1 END Sex, FROM_UNIXTIME(cus.sr1, '%Y-%m-%d') Birthday,'' WeibNo,cus.qq QqNo,'' TbNo,cus.Email Email,cus.province_id Province,cus.city_id City, cus.district_id County FROM ipos_customer cus INNER JOIN ipos_vip vp ON vp.gk_id = cus.Id inner join ipos_viplb vplb on vplb.Id=vp.lb_id where 1=1 and cus.Id='296' order by cus.lastchanged desc limit 1[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:57] select lsz.*,xl.jmw_pp from ipos_vplsz lsz inner join ipos_hyxl xl on xl.Id = lsz.xl_id where lsz.jfcz > 0 and lsz.jf <> 0 and (lsz.tj =0 or lsz.tj is null) order by lsz.Id limit 0, 100[1146] Table 'zzqr.ipos_vplsz' doesn't exist [2026-09-26 17:55:57] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:55:57] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:55:58] select zddm, orgdm, crm_id, sj, vpdm from ipos_vip where Id = '5'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:58] select zddm, orgdm, crm_id, sj, vpdm from ipos_vip where sj = '17737173359'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:55:59] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:55:59] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:56:05] select Id,dydm from ipos_dianyuan[1146] Table 'zzqr.ipos_dianyuan' doesn't exist [2026-09-26 17:56:08] select * from ipos_plan_task where task_url=''[1146] Table 'zzqr.ipos_plan_task' doesn't exist [2026-09-26 17:56:09] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:56:09] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:56:11] SELECT cus.Id,cus.tjgk_id,cus.jltjrjf,vp.lb_id,vp.scdh FROM ipos_vip vp inner join ipos_customer cus on vp.gk_id=cus.Id WHERE vp.scdh!='' AND cus.tjgk_id>0 AND cus.jltjrjf=0[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:56:11] select lxdj,zd_id from ipos_vplsz where lxdj!='' and dgy_list_mc=''[1146] Table 'zzqr.ipos_vplsz' doesn't exist [2026-09-26 17:56:12] select * from ipos_plan_task where task_url=''[1146] Table 'zzqr.ipos_plan_task' doesn't exist [2026-09-26 17:56:14] select Id, kwdm from ipos_kuwei[1146] Table 'zzqr.ipos_kuwei' doesn't exist [2026-09-26 17:56:15] SELECT gk_id, SUM(je) as je, SUM(sl) as sl FROM ipos_gkxfmx0 WHERE zhyxf = 1 GROUP BY gk_id[1146] Table 'zzqr.ipos_gkxfmx0' doesn't exist [2026-09-26 17:56:15] SELECT gk_id, SUM(je) as je, SUM(sl) as sl FROM ipos_gkxfmx1 WHERE zhyxf = 1 GROUP BY gk_id[1146] Table 'zzqr.ipos_gkxfmx1' doesn't exist [2026-09-26 17:56:15] SELECT gk_id, SUM(je) as je, SUM(sl) as sl FROM ipos_gkxfmx2 WHERE zhyxf = 1 GROUP BY gk_id[1146] Table 'zzqr.ipos_gkxfmx2' doesn't exist [2026-09-26 17:56:15] SELECT gk_id, SUM(je) as je, SUM(sl) as sl FROM ipos_gkxfmx3 WHERE zhyxf = 1 GROUP BY gk_id[1146] Table 'zzqr.ipos_gkxfmx3' doesn't exist [2026-09-26 17:56:15] SELECT gk_id, SUM(je) as je, SUM(sl) as sl FROM ipos_gkxfmx4 WHERE zhyxf = 1 GROUP BY gk_id[1146] Table 'zzqr.ipos_gkxfmx4' doesn't exist [2026-09-26 17:56:15] SELECT gk_id, SUM(je) as je, SUM(sl) as sl FROM ipos_gkxfmx5 WHERE zhyxf = 1 GROUP BY gk_id[1146] Table 'zzqr.ipos_gkxfmx5' doesn't exist [2026-09-26 17:56:15] SELECT gk_id, SUM(je) as je, SUM(sl) as sl FROM ipos_gkxfmx6 WHERE zhyxf = 1 GROUP BY gk_id[1146] Table 'zzqr.ipos_gkxfmx6' doesn't exist [2026-09-26 17:56:15] SELECT gk_id, SUM(je) as je, SUM(sl) as sl FROM ipos_gkxfmx7 WHERE zhyxf = 1 GROUP BY gk_id[1146] Table 'zzqr.ipos_gkxfmx7' doesn't exist [2026-09-26 17:56:15] SELECT gk_id, SUM(je) as je, SUM(sl) as sl FROM ipos_gkxfmx8 WHERE zhyxf = 1 GROUP BY gk_id[1146] Table 'zzqr.ipos_gkxfmx8' doesn't exist [2026-09-26 17:56:15] SELECT gk_id, SUM(je) as je, SUM(sl) as sl FROM ipos_gkxfmx9 WHERE zhyxf = 1 GROUP BY gk_id[1146] Table 'zzqr.ipos_gkxfmx9' doesn't exist [2026-09-26 17:56:17] UPDATE ipos_vplsz SET yxrq=(UNIX_TIMESTAMP(date_add(FROM_UNIXTIME(yxrq, '%Y-%m-01'), interval 1 month)) - 86400) WHERE yxrq > 0 AND czsj >=1790265600 AND czsj < 1790352000[1146] Table 'zzqr.ipos_vplsz' doesn't exist [2026-09-26 17:56:19] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:56:19] select ppdm,appid,token from ipos_jmw_pp[1146] Table 'zzqr.ipos_jmw_pp' doesn't exist [2026-09-26 17:56:20] SELECT max(unix_timestamp(lastchanged)) FROM ipos_qdtjd[1146] Table 'zzqr.ipos_qdtjd' doesn't exist [2026-09-26 17:56:20] SELECT tjdxyxjb FROM ipos_main LIMIT 1[1054] Unknown column 'tjdxyxjb' in 'field list' [2026-09-26 17:56:21] SELECT xp.zd_id, xp.zddm, xp.yyrq, COUNT(DISTINCT xp.Id) AS xpsl, SUM(xp.sl) AS sl, SUM(xp.je) AS je, SUM(xp.bzje-xp.je) AS yhje, (SUM(xp.je)/SUM(xp.sl)) AS avg_price, (SUM(xp.je)/SUM(xp.bzje)) AS avg_discount FROM ipos_qtlsd xp WHERE xp.yyrq=1790265600 AND 1=1 AND 1=1 GROUP BY xp.zd_id LIMIT 0, 100[1146] Table 'zzqr.ipos_qtlsd' doesn't exist [2026-09-26 17:56:22] SELECT vp.Id,vp.sj from ipos_vip vp inner join ipos_viplb lb on lb.Id = vp.lb_id where vp.icrm_is_fetch = 1 and vp.status=1 and lb.Id in(11,12,13,14) order by vp.lastchanged desc limit 100[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:56:22] SELECT lsz.Id from ipos_vplsz lsz inner join ipos_vip vp on vp.Id=lsz.vp_id inner join ipos_viplb lb on lb.Id = vp.lb_id where lsz.tj=0 and lsz.jf <> 0 and lb.Id in(11,12,13,14) and lsz.czsj >'1787673600'[1146] Table 'zzqr.ipos_vplsz' doesn't exist [2026-09-26 17:56:22] SELECT vp.Id,UNIX_TIMESTAMP(vp.lastchanged) lastchanged from ipos_vip vp inner join ipos_viplb lb on lb.Id = vp.lb_id where vp.status=1 and lb.Id in(11,12,13,14) and vp.lastchanged>= '2026-09-26'[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:56:23] SELECT cus.Id from ipos_customer cus inner join ipos_vip vp on vp.gk_id=cus.Id inner join ipos_viplb lb on lb.Id = vp.lb_id where cus.icrm_is_fetch = 1 and IFNULL(cus.xgrq,0) > 0 and lb.Id in(11,12,13,14)[1146] Table 'zzqr.ipos_vip' doesn't exist [2026-09-26 17:56:23] select * from ipos_vplsz where jfcz > 0 and jf <> 0 and (tj =0 or tj is null) order by Id limit 0, 100[1146] Table 'zzqr.ipos_vplsz' doesn't exist [2026-09-26 17:56:24] SELECT lsz.Id, lsz.czsj, lsz.vpdm, lsz.zj, lsz.jf, lsz.bz, lsz.yxrq FROM ipos_vplsz lsz INNER JOIN ipos_vip vp ON lsz.vp_id=vp.Id WHERE lsz.jf <> 0 AND lsz.status_code ^ 1 AND 1=1 ORDER BY lsz.Id ASC LIMIT 0, 50[1146] Table 'zzqr.ipos_vplsz' doesn't exist