Time: 0.016741991043091 -- 25-11-13 09:08:16 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033509731292725 -- 25-11-13 09:08:16 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038340091705322 -- 25-11-13 09:08:16 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='HuangWenJun' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003626823425293 -- 25-11-13 09:08:16[黄文军-2342] -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 14 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040922164916992 -- 25-11-13 09:08:17[黄文军-2342] -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select jsapi_ticket from dbwechat.wechat_token wt left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000014 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.031696081161499 -- 25-11-13 09:08:20[黄文军-2342] -- /buz/wh/index.php/whmgmt/wh_stockcheck?event=query SELECT l.lot_name,m.material_id,m.material_no,m.model,m.spec,sum(b.avbl_pieces) avbl_pieces FROM dbwh.wh_order_invbal b left JOIN dbwh.wh_material m ON b.material_id = m.material_id left JOIN dbwh.wh_lot l ON b.lot_id = l.lot_id where b.acct_id = 14 and b.avbl_pieces > 0 and (l.lot_name like '%4165%' OR m.material_no like '%4165%' or m.model like '%4165%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0177161693573 -- 25-11-13 10:26:44 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034730434417725 -- 25-11-13 10:26:44 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039680004119873 -- 25-11-13 10:26:44 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='ChenPing' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037660598754883 -- 25-11-13 10:26:44[陈平-1030] -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 14 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035738945007324 -- 25-11-13 10:26:44[陈平-1030] -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select jsapi_ticket from dbwechat.wechat_token wt left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000014 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.032647132873535 -- 25-11-13 10:26:59[陈平-1030] -- /buz/wh/index.php/whmgmt/wh_stockcheck?event=query SELECT l.lot_name,m.material_id,m.material_no,m.model,m.spec,sum(b.avbl_pieces) avbl_pieces FROM dbwh.wh_order_invbal b left JOIN dbwh.wh_material m ON b.material_id = m.material_id left JOIN dbwh.wh_lot l ON b.lot_id = l.lot_id where b.acct_id = 14 and b.avbl_pieces > 0 and (l.lot_name like '%133090%' OR m.material_no like '%133090%' or m.model like '%133090%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016424894332886 -- 25-11-13 11:11:49 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032382011413574 -- 25-11-13 11:11:49 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040678977966309 -- 25-11-13 11:11:49 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='ChenZiHao' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034959316253662 -- 25-11-13 11:11:49[陈梓豪-660] -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 14 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036230087280273 -- 25-11-13 11:11:49[陈梓豪-660] -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select jsapi_ticket from dbwechat.wechat_token wt left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000014 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030613899230957 -- 25-11-13 11:11:56[陈梓豪-660] -- /buz/wh/index.php/whmgmt/wh_stockcheck?event=query SELECT l.lot_name,m.material_id,m.material_no,m.model,m.spec,sum(b.avbl_pieces) avbl_pieces FROM dbwh.wh_order_invbal b left JOIN dbwh.wh_material m ON b.material_id = m.material_id left JOIN dbwh.wh_lot l ON b.lot_id = l.lot_id where b.acct_id = 14 and b.avbl_pieces > 0 and (l.lot_name like '%0476%' OR m.material_no like '%0476%' or m.model like '%0476%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.03549599647522 -- 25-11-13 11:15:47[陈梓豪-660] -- /buz/wh/index.php/whmgmt/wh_stockcheck?event=query SELECT l.lot_name,m.material_id,m.material_no,m.model,m.spec,sum(b.avbl_pieces) avbl_pieces FROM dbwh.wh_order_invbal b left JOIN dbwh.wh_material m ON b.material_id = m.material_id left JOIN dbwh.wh_lot l ON b.lot_id = l.lot_id where b.acct_id = 14 and b.avbl_pieces > 0 and (l.lot_name like '%7938%' OR m.material_no like '%7938%' or m.model like '%7938%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.031921148300171 -- 25-11-13 11:18:23[陈梓豪-660] -- /buz/wh/index.php/whmgmt/wh_stockcheck?event=query SELECT l.lot_name,m.material_id,m.material_no,m.model,m.spec,sum(b.avbl_pieces) avbl_pieces FROM dbwh.wh_order_invbal b left JOIN dbwh.wh_material m ON b.material_id = m.material_id left JOIN dbwh.wh_lot l ON b.lot_id = l.lot_id where b.acct_id = 14 and b.avbl_pieces > 0 and (l.lot_name like '%0476%' OR m.material_no like '%0476%' or m.model like '%0476%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017690896987915 -- 25-11-13 14:03:24 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035061836242676 -- 25-11-13 14:03:24 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040030479431152 -- 25-11-13 14:03:24 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='HuangWenJun' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037531852722168 -- 25-11-13 14:03:24[黄文军-2342] -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 14 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038878917694092 -- 25-11-13 14:03:24[黄文军-2342] -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select jsapi_ticket from dbwechat.wechat_token wt left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000014 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.031489133834839 -- 25-11-13 14:03:28[黄文军-2342] -- /buz/wh/index.php/whmgmt/wh_stockcheck?event=query SELECT l.lot_name,m.material_id,m.material_no,m.model,m.spec,sum(b.avbl_pieces) avbl_pieces FROM dbwh.wh_order_invbal b left JOIN dbwh.wh_material m ON b.material_id = m.material_id left JOIN dbwh.wh_lot l ON b.lot_id = l.lot_id where b.acct_id = 14 and b.avbl_pieces > 0 and (l.lot_name like '%4165%' OR m.material_no like '%4165%' or m.model like '%4165%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016488075256348 -- 25-11-13 14:53:06 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022355079650879 -- 25-11-13 14:53:06 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037798881530762 -- 25-11-13 14:53:06 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042369365692139 -- 25-11-13 14:53:06 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='ChenJin' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036511421203613 -- 25-11-13 14:53:06[陈锦-1032] -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 14 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038859844207764 -- 25-11-13 14:53:06[陈锦-1032] -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select jsapi_ticket from dbwechat.wechat_token wt left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000014 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.031726121902466 -- 25-11-13 14:53:10[陈锦-1032] -- /buz/wh/index.php/whmgmt/wh_stockcheck?event=query SELECT l.lot_name,m.material_id,m.material_no,m.model,m.spec,sum(b.avbl_pieces) avbl_pieces FROM dbwh.wh_order_invbal b left JOIN dbwh.wh_material m ON b.material_id = m.material_id left JOIN dbwh.wh_lot l ON b.lot_id = l.lot_id where b.acct_id = 14 and b.avbl_pieces > 0 and (l.lot_name like '%2834%' OR m.material_no like '%2834%' or m.model like '%2834%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016834020614624 -- 25-11-13 15:18:15 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033230781555176 -- 25-11-13 15:18:15 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038158893585205 -- 25-11-13 15:18:15 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='WeiDeWang' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035400390625 -- 25-11-13 15:18:15[韦德旺-657] -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 14 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037298202514648 -- 25-11-13 15:18:15[韦德旺-657] -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select jsapi_ticket from dbwechat.wechat_token wt left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000014 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.031982898712158 -- 25-11-13 15:18:27[韦德旺-657] -- /buz/wh/index.php/whmgmt/wh_stockcheck?event=query SELECT l.lot_name,m.material_id,m.material_no,m.model,m.spec,sum(b.avbl_pieces) avbl_pieces FROM dbwh.wh_order_invbal b left JOIN dbwh.wh_material m ON b.material_id = m.material_id left JOIN dbwh.wh_lot l ON b.lot_id = l.lot_id where b.acct_id = 14 and b.avbl_pieces > 0 and (l.lot_name like '%EAN_13,6940056111241%' OR m.material_no like '%EAN_13,6940056111241%' or m.model like '%EAN_13,6940056111241%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.032639026641846 -- 25-11-13 15:18:32[韦德旺-657] -- /buz/wh/index.php/whmgmt/wh_stockcheck?event=query SELECT l.lot_name,m.material_id,m.material_no,m.model,m.spec,sum(b.avbl_pieces) avbl_pieces FROM dbwh.wh_order_invbal b left JOIN dbwh.wh_material m ON b.material_id = m.material_id left JOIN dbwh.wh_lot l ON b.lot_id = l.lot_id where b.acct_id = 14 and b.avbl_pieces > 0 and (l.lot_name like '%6940056111241%' OR m.material_no like '%6940056111241%' or m.model like '%6940056111241%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01828408241272 -- 25-11-13 15:22:08 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036308765411377 -- 25-11-13 15:22:08 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040807723999023 -- 25-11-13 15:22:08 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='KuangChao' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038619041442871 -- 25-11-13 15:22:08[匡超-2313] -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 14 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042128562927246 -- 25-11-13 15:22:08[匡超-2313] -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select jsapi_ticket from dbwechat.wechat_token wt left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000014 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.03062105178833 -- 25-11-13 15:22:11[匡超-2313] -- /buz/wh/index.php/whmgmt/wh_stockcheck?event=query SELECT l.lot_name,m.material_id,m.material_no,m.model,m.spec,sum(b.avbl_pieces) avbl_pieces FROM dbwh.wh_order_invbal b left JOIN dbwh.wh_material m ON b.material_id = m.material_id left JOIN dbwh.wh_lot l ON b.lot_id = l.lot_id where b.acct_id = 14 and b.avbl_pieces > 0 and (l.lot_name like '%9567%' OR m.material_no like '%9567%' or m.model like '%9567%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.032027006149292 -- 25-11-13 15:22:18[匡超-2313] -- /buz/wh/index.php/whmgmt/wh_stockcheck?event=query SELECT l.lot_name,m.material_id,m.material_no,m.model,m.spec,sum(b.avbl_pieces) avbl_pieces FROM dbwh.wh_order_invbal b left JOIN dbwh.wh_material m ON b.material_id = m.material_id left JOIN dbwh.wh_lot l ON b.lot_id = l.lot_id where b.acct_id = 14 and b.avbl_pieces > 0 and (l.lot_name like '%9576%' OR m.material_no like '%9576%' or m.model like '%9576%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018013000488281 -- 25-11-13 15:30:18[韦德旺-657] -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select jsapi_ticket from dbwechat.wechat_token wt left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000014 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.035084962844849 -- 25-11-13 15:30:32[韦德旺-657] -- /buz/wh/index.php/whmgmt/wh_stockcheck?event=query SELECT l.lot_name,m.material_id,m.material_no,m.model,m.spec,sum(b.avbl_pieces) avbl_pieces FROM dbwh.wh_order_invbal b left JOIN dbwh.wh_material m ON b.material_id = m.material_id left JOIN dbwh.wh_lot l ON b.lot_id = l.lot_id where b.acct_id = 14 and b.avbl_pieces > 0 and (l.lot_name like '%EAN_13,6940056188212%' OR m.material_no like '%EAN_13,6940056188212%' or m.model like '%EAN_13,6940056188212%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.033195018768311 -- 25-11-13 15:30:37[韦德旺-657] -- /buz/wh/index.php/whmgmt/wh_stockcheck?event=query SELECT l.lot_name,m.material_id,m.material_no,m.model,m.spec,sum(b.avbl_pieces) avbl_pieces FROM dbwh.wh_order_invbal b left JOIN dbwh.wh_material m ON b.material_id = m.material_id left JOIN dbwh.wh_lot l ON b.lot_id = l.lot_id where b.acct_id = 14 and b.avbl_pieces > 0 and (l.lot_name like '%6940056188212%' OR m.material_no like '%6940056188212%' or m.model like '%6940056188212%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020164966583252 -- 25-11-13 15:30:39[韦德旺-657] -- /buz/wh/index.php/whmgmt/wh_stockcheck?event=query SELECT l.lot_name,m.material_id,m.material_no,m.model,m.spec,sum(b.avbl_pieces) avbl_pieces FROM dbwh.wh_order_invbal b left JOIN dbwh.wh_material m ON b.material_id = m.material_id left JOIN dbwh.wh_lot l ON b.lot_id = l.lot_id where b.acct_id = 14 and b.avbl_pieces > 0 and (l.lot_name like '%6940056188212%' OR m.material_no like '%6940056188212%' or m.model like '%6940056188212%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.04646897315979 -- 25-11-13 15:30:40[韦德旺-657] -- /buz/wh/index.php/whmgmt/wh_stockcheck?event=query SELECT l.lot_name,m.material_id,m.material_no,m.model,m.spec,sum(b.avbl_pieces) avbl_pieces FROM dbwh.wh_order_invbal b left JOIN dbwh.wh_material m ON b.material_id = m.material_id left JOIN dbwh.wh_lot l ON b.lot_id = l.lot_id where b.acct_id = 14 and b.avbl_pieces > 0 and (l.lot_name like '%6940056188212%' OR m.material_no like '%6940056188212%' or m.model like '%6940056188212%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022172927856445 -- 25-11-13 16:15:58 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029996871948242 -- 25-11-13 16:15:58 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041868686676025 -- 25-11-13 16:15:58 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042061805725098 -- 25-11-13 16:15:58 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='ChenPing' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039501190185547 -- 25-11-13 16:15:58[陈平-1030] -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 14 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040988922119141 -- 25-11-13 16:15:58[陈平-1030] -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select jsapi_ticket from dbwechat.wechat_token wt left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000014 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.042212963104248 -- 25-11-13 16:16:08[陈平-1030] -- /buz/wh/index.php/whmgmt/wh_stockcheck?event=query SELECT l.lot_name,m.material_id,m.material_no,m.model,m.spec,sum(b.avbl_pieces) avbl_pieces FROM dbwh.wh_order_invbal b left JOIN dbwh.wh_material m ON b.material_id = m.material_id left JOIN dbwh.wh_lot l ON b.lot_id = l.lot_id where b.acct_id = 14 and b.avbl_pieces > 0 and (l.lot_name like '%122865%' OR m.material_no like '%122865%' or m.model like '%122865%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.041344165802002 -- 25-11-13 16:16:10[陈平-1030] -- /buz/wh/index.php/whmgmt/wh_stockcheck?event=query SELECT l.lot_name,m.material_id,m.material_no,m.model,m.spec,sum(b.avbl_pieces) avbl_pieces FROM dbwh.wh_order_invbal b left JOIN dbwh.wh_material m ON b.material_id = m.material_id left JOIN dbwh.wh_lot l ON b.lot_id = l.lot_id where b.acct_id = 14 and b.avbl_pieces > 0 and (l.lot_name like '%122865%' OR m.material_no like '%122865%' or m.model like '%122865%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0328369140625 -- 25-11-13 16:17:11[匡超-2313] -- /buz/wh/index.php/whmgmt/wh_stockcheck?event=query SELECT l.lot_name,m.material_id,m.material_no,m.model,m.spec,sum(b.avbl_pieces) avbl_pieces FROM dbwh.wh_order_invbal b left JOIN dbwh.wh_material m ON b.material_id = m.material_id left JOIN dbwh.wh_lot l ON b.lot_id = l.lot_id where b.acct_id = 14 and b.avbl_pieces > 0 and (l.lot_name like '%9590%' OR m.material_no like '%9590%' or m.model like '%9590%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.031830072402954 -- 25-11-13 16:17:54[匡超-2313] -- /buz/wh/index.php/whmgmt/wh_stockcheck?event=query SELECT l.lot_name,m.material_id,m.material_no,m.model,m.spec,sum(b.avbl_pieces) avbl_pieces FROM dbwh.wh_order_invbal b left JOIN dbwh.wh_material m ON b.material_id = m.material_id left JOIN dbwh.wh_lot l ON b.lot_id = l.lot_id where b.acct_id = 14 and b.avbl_pieces > 0 and (l.lot_name like '%4134%' OR m.material_no like '%4134%' or m.model like '%4134%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028809070587158 -- 25-11-13 17:46:58 -- /buz/wh/index.php/whmgmt/outTally_list?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014&wxMenu_id=115 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034279823303223 -- 25-11-13 17:46:59 -- /buz/wh/index.php/whmgmt/outTally_list?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014&wxMenu_id=115 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039470195770264 -- 25-11-13 17:46:59 -- /buz/wh/index.php/whmgmt/outTally_list?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014&wxMenu_id=115 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='aShenYiYangDeNvWang' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037729740142822 -- 25-11-13 17:46:59[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_list?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014&wxMenu_id=115 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 9 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039489269256592 -- 25-11-13 17:46:59[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_list?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014&wxMenu_id=115 select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=115 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033881664276123 -- 25-11-13 17:46:59[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_list?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014&wxMenu_id=115 select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 365 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0058271884918213 -- 25-11-13 17:46:59[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_list?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014&wxMenu_id=115 select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 115 and cont_id = 365 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038700103759766 -- 25-11-13 17:46:59[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_list?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014&wxMenu_id=115 select jsapi_ticket from dbwechat.wechat_token wt left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000014 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.03276801109314 -- 25-11-13 17:46:59[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_list?event=query_outBound_list select o.*,c.cust_disp_name customer,IFNULL(op.outpkg_id,0) outpkg_id, date_format(o.order_date,'%Y-%m-%d') order_date,op.ship_pieces,op.ship_weight, op.ship_volume, s.stock_name from dbwh.v_wh_order o left join dbwh.v_wh_customer c on o.customer_id = c.customer_id left join dbwh.wh_orderex_ship os on os.order_id = o.order_id left join dbwh.wh_outpkgch_order op_o on op_o.order_id = o.order_id left join dbwh.wh_outpkg op on op.outpkg_id = op_o.outpkg_id left join dbwh.wh_stock s on o.stock_id = s.stock_id WHERE o.order_type_id = 2 and o.acct_id = 9 and os.is_self_carry = 1 AND (op.outpkg_id <= 1 or op.outpkg_id is null) AND o.order_date >= '2025/11/06' AND o.order_date <= '2025/11/13 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.032466888427734 -- 25-11-13 17:47:11[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_list?event=query_outBound_list select o.*,c.cust_disp_name customer,IFNULL(op.outpkg_id,0) outpkg_id, date_format(o.order_date,'%Y-%m-%d') order_date,op.ship_pieces,op.ship_weight, op.ship_volume, s.stock_name from dbwh.v_wh_order o left join dbwh.v_wh_customer c on o.customer_id = c.customer_id left join dbwh.wh_orderex_ship os on os.order_id = o.order_id left join dbwh.wh_outpkgch_order op_o on op_o.order_id = o.order_id left join dbwh.wh_outpkg op on op.outpkg_id = op_o.outpkg_id left join dbwh.wh_stock s on o.stock_id = s.stock_id WHERE o.order_type_id = 2 and o.acct_id = 9 and os.is_self_carry = 1 AND (op.outpkg_id <= 1 or op.outpkg_id is null) AND o.cust_no like '%630684%' AND o.order_date >= '2025/11/06' AND o.order_date <= '2025/11/13 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01849889755249 -- 25-11-13 17:47:12[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=954863&outpkg_id=0 select o.order_no,o.cust_no,c.cust_disp_name customer, o.owner_id from dbwh.wh_order o left join dbwh.v_wh_customer c on o.customer_id = c.customer_id where o.order_id = '954863 ' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017587900161743 -- 25-11-13 17:47:36[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?event=save_outpkg select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 365 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017653942108154 -- 25-11-13 17:47:39[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_list select jsapi_ticket from dbwechat.wechat_token wt left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000014 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029168128967285 -- 25-11-13 17:47:40[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_list?event=query_outBound_list select o.*,c.cust_disp_name customer,IFNULL(op.outpkg_id,0) outpkg_id, date_format(o.order_date,'%Y-%m-%d') order_date,op.ship_pieces,op.ship_weight, op.ship_volume, s.stock_name from dbwh.v_wh_order o left join dbwh.v_wh_customer c on o.customer_id = c.customer_id left join dbwh.wh_orderex_ship os on os.order_id = o.order_id left join dbwh.wh_outpkgch_order op_o on op_o.order_id = o.order_id left join dbwh.wh_outpkg op on op.outpkg_id = op_o.outpkg_id left join dbwh.wh_stock s on o.stock_id = s.stock_id WHERE o.order_type_id = 2 and o.acct_id = 9 and os.is_self_carry = 1 AND (op.outpkg_id <= 1 or op.outpkg_id is null) AND o.order_date >= '2025/11/06' AND o.order_date <= '2025/11/13 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02714991569519 -- 25-11-13 17:47:52[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_list?event=query_outBound_list select o.*,c.cust_disp_name customer,IFNULL(op.outpkg_id,0) outpkg_id, date_format(o.order_date,'%Y-%m-%d') order_date,op.ship_pieces,op.ship_weight, op.ship_volume, s.stock_name from dbwh.v_wh_order o left join dbwh.v_wh_customer c on o.customer_id = c.customer_id left join dbwh.wh_orderex_ship os on os.order_id = o.order_id left join dbwh.wh_outpkgch_order op_o on op_o.order_id = o.order_id left join dbwh.wh_outpkg op on op.outpkg_id = op_o.outpkg_id left join dbwh.wh_stock s on o.stock_id = s.stock_id WHERE o.order_type_id = 2 and o.acct_id = 9 and os.is_self_carry = 1 AND (op.outpkg_id <= 1 or op.outpkg_id is null) AND o.cust_no like '%630666%' AND o.order_date >= '2025/11/06' AND o.order_date <= '2025/11/13 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016964197158813 -- 25-11-13 17:47:53[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=954865&outpkg_id=0 select o.order_no,o.cust_no,c.cust_disp_name customer, o.owner_id from dbwh.wh_order o left join dbwh.v_wh_customer c on o.customer_id = c.customer_id where o.order_id = '954865 ' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016523122787476 -- 25-11-13 17:48:34[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?event=save_outpkg select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 365 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024652004241943 -- 25-11-13 17:48:38[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_list select jsapi_ticket from dbwechat.wechat_token wt left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000014 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.034982919692993 -- 25-11-13 17:48:39[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_list?event=query_outBound_list select o.*,c.cust_disp_name customer,IFNULL(op.outpkg_id,0) outpkg_id, date_format(o.order_date,'%Y-%m-%d') order_date,op.ship_pieces,op.ship_weight, op.ship_volume, s.stock_name from dbwh.v_wh_order o left join dbwh.v_wh_customer c on o.customer_id = c.customer_id left join dbwh.wh_orderex_ship os on os.order_id = o.order_id left join dbwh.wh_outpkgch_order op_o on op_o.order_id = o.order_id left join dbwh.wh_outpkg op on op.outpkg_id = op_o.outpkg_id left join dbwh.wh_stock s on o.stock_id = s.stock_id WHERE o.order_type_id = 2 and o.acct_id = 9 and os.is_self_carry = 1 AND (op.outpkg_id <= 1 or op.outpkg_id is null) AND o.order_date >= '2025/11/06' AND o.order_date <= '2025/11/13 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016674041748047 -- 25-11-13 17:48:44[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=954867&outpkg_id=0 select o.order_no,o.cust_no,c.cust_disp_name customer, o.owner_id from dbwh.wh_order o left join dbwh.v_wh_customer c on o.customer_id = c.customer_id where o.order_id = '954867 ' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017030000686646 -- 25-11-13 17:49:19[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?event=save_outpkg select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 365 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02154016494751 -- 25-11-13 17:49:20[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_list select jsapi_ticket from dbwechat.wechat_token wt left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000014 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030975103378296 -- 25-11-13 17:49:20[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_list?event=query_outBound_list select o.*,c.cust_disp_name customer,IFNULL(op.outpkg_id,0) outpkg_id, date_format(o.order_date,'%Y-%m-%d') order_date,op.ship_pieces,op.ship_weight, op.ship_volume, s.stock_name from dbwh.v_wh_order o left join dbwh.v_wh_customer c on o.customer_id = c.customer_id left join dbwh.wh_orderex_ship os on os.order_id = o.order_id left join dbwh.wh_outpkgch_order op_o on op_o.order_id = o.order_id left join dbwh.wh_outpkg op on op.outpkg_id = op_o.outpkg_id left join dbwh.wh_stock s on o.stock_id = s.stock_id WHERE o.order_type_id = 2 and o.acct_id = 9 and os.is_self_carry = 1 AND (op.outpkg_id <= 1 or op.outpkg_id is null) AND o.order_date >= '2025/11/06' AND o.order_date <= '2025/11/13 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026403903961182 -- 25-11-13 17:49:38[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_list?event=query_outBound_list select o.*,c.cust_disp_name customer,IFNULL(op.outpkg_id,0) outpkg_id, date_format(o.order_date,'%Y-%m-%d') order_date,op.ship_pieces,op.ship_weight, op.ship_volume, s.stock_name from dbwh.v_wh_order o left join dbwh.v_wh_customer c on o.customer_id = c.customer_id left join dbwh.wh_orderex_ship os on os.order_id = o.order_id left join dbwh.wh_outpkgch_order op_o on op_o.order_id = o.order_id left join dbwh.wh_outpkg op on op.outpkg_id = op_o.outpkg_id left join dbwh.wh_stock s on o.stock_id = s.stock_id WHERE o.order_type_id = 2 and o.acct_id = 9 and os.is_self_carry = 1 AND (op.outpkg_id <= 1 or op.outpkg_id is null) AND o.cust_no like '%630666%' AND o.order_date >= '2025/11/06' AND o.order_date <= '2025/11/13 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027762889862061 -- 25-11-13 17:49:41[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_list?event=query_outBound_list select o.*,c.cust_disp_name customer,IFNULL(op.outpkg_id,0) outpkg_id, date_format(o.order_date,'%Y-%m-%d') order_date,op.ship_pieces,op.ship_weight, op.ship_volume, s.stock_name from dbwh.v_wh_order o left join dbwh.v_wh_customer c on o.customer_id = c.customer_id left join dbwh.wh_orderex_ship os on os.order_id = o.order_id left join dbwh.wh_outpkgch_order op_o on op_o.order_id = o.order_id left join dbwh.wh_outpkg op on op.outpkg_id = op_o.outpkg_id left join dbwh.wh_stock s on o.stock_id = s.stock_id WHERE o.order_type_id = 2 and o.acct_id = 9 and os.is_self_carry = 1 AND op.outpkg_id > 1 AND o.cust_no like '%630666%' AND o.order_date >= '2025/11/06' AND o.order_date <= '2025/11/13 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018144130706787 -- 25-11-13 17:49:41[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=954865&outpkg_id=81383 select o.order_no,o.cust_no,c.cust_disp_name customer, o.owner_id from dbwh.wh_order o left join dbwh.v_wh_customer c on o.customer_id = c.customer_id where o.order_id = '954865 ' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040390491485596 -- 25-11-13 17:49:41[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=954865&outpkg_id=81383 select * from dbwh.wh_outpkg where outpkg_id = 81383 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035901069641113 -- 25-11-13 17:49:41[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=954865&outpkg_id=81383 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 5565021 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035150051116943 -- 25-11-13 17:49:41[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=954865&outpkg_id=81383 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 365 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018903970718384 -- 25-11-13 17:49:53[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?event=save_outpkg select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 365 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028654098510742 -- 25-11-13 17:49:55[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_list select jsapi_ticket from dbwechat.wechat_token wt left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000014 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029627084732056 -- 25-11-13 17:49:56[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_list?event=query_outBound_list select o.*,c.cust_disp_name customer,IFNULL(op.outpkg_id,0) outpkg_id, date_format(o.order_date,'%Y-%m-%d') order_date,op.ship_pieces,op.ship_weight, op.ship_volume, s.stock_name from dbwh.v_wh_order o left join dbwh.v_wh_customer c on o.customer_id = c.customer_id left join dbwh.wh_orderex_ship os on os.order_id = o.order_id left join dbwh.wh_outpkgch_order op_o on op_o.order_id = o.order_id left join dbwh.wh_outpkg op on op.outpkg_id = op_o.outpkg_id left join dbwh.wh_stock s on o.stock_id = s.stock_id WHERE o.order_type_id = 2 and o.acct_id = 9 and os.is_self_carry = 1 AND (op.outpkg_id <= 1 or op.outpkg_id is null) AND o.order_date >= '2025/11/06' AND o.order_date <= '2025/11/13 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019765138626099 -- 25-11-13 18:44:54[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_list?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014&wxMenu_id=115 select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=115 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003817081451416 -- 25-11-13 18:44:54[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_list?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014&wxMenu_id=115 select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 365 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042920112609863 -- 25-11-13 18:44:54[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_list?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014&wxMenu_id=115 select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 115 and cont_id = 365 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038981437683105 -- 25-11-13 18:44:54[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_list?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014&wxMenu_id=115 select jsapi_ticket from dbwechat.wechat_token wt left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000014 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.03125 -- 25-11-13 18:44:55[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_list?event=query_outBound_list select o.*,c.cust_disp_name customer,IFNULL(op.outpkg_id,0) outpkg_id, date_format(o.order_date,'%Y-%m-%d') order_date,op.ship_pieces,op.ship_weight, op.ship_volume, s.stock_name from dbwh.v_wh_order o left join dbwh.v_wh_customer c on o.customer_id = c.customer_id left join dbwh.wh_orderex_ship os on os.order_id = o.order_id left join dbwh.wh_outpkgch_order op_o on op_o.order_id = o.order_id left join dbwh.wh_outpkg op on op.outpkg_id = op_o.outpkg_id left join dbwh.wh_stock s on o.stock_id = s.stock_id WHERE o.order_type_id = 2 and o.acct_id = 9 and os.is_self_carry = 1 AND (op.outpkg_id <= 1 or op.outpkg_id is null) AND o.order_date >= '2025/11/06' AND o.order_date <= '2025/11/13 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020967960357666 -- 25-11-13 18:44:56[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=955065&outpkg_id=0 select o.order_no,o.cust_no,c.cust_disp_name customer, o.owner_id from dbwh.wh_order o left join dbwh.v_wh_customer c on o.customer_id = c.customer_id where o.order_id = '955065 ' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01704216003418 -- 25-11-13 18:45:41[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?event=save_outpkg select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 365 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017235040664673 -- 25-11-13 18:45:43[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_list select jsapi_ticket from dbwechat.wechat_token wt left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000014 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.032214879989624 -- 25-11-13 18:45:44[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_list?event=query_outBound_list select o.*,c.cust_disp_name customer,IFNULL(op.outpkg_id,0) outpkg_id, date_format(o.order_date,'%Y-%m-%d') order_date,op.ship_pieces,op.ship_weight, op.ship_volume, s.stock_name from dbwh.v_wh_order o left join dbwh.v_wh_customer c on o.customer_id = c.customer_id left join dbwh.wh_orderex_ship os on os.order_id = o.order_id left join dbwh.wh_outpkgch_order op_o on op_o.order_id = o.order_id left join dbwh.wh_outpkg op on op.outpkg_id = op_o.outpkg_id left join dbwh.wh_stock s on o.stock_id = s.stock_id WHERE o.order_type_id = 2 and o.acct_id = 9 and os.is_self_carry = 1 AND (op.outpkg_id <= 1 or op.outpkg_id is null) AND o.order_date >= '2025/11/06' AND o.order_date <= '2025/11/13 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028167963027954 -- 25-11-13 19:42:04 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035800933837891 -- 25-11-13 19:42:04 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044398307800293 -- 25-11-13 19:42:04 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='MaZhengKun' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038480758666992 -- 25-11-13 19:42:04[马正坤-2172] -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 14 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004011869430542 -- 25-11-13 19:42:04[马正坤-2172] -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select jsapi_ticket from dbwechat.wechat_token wt left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000014 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.031023025512695 -- 25-11-13 19:42:08[马正坤-2172] -- /buz/wh/index.php/whmgmt/wh_stockcheck?event=query SELECT l.lot_name,m.material_id,m.material_no,m.model,m.spec,sum(b.avbl_pieces) avbl_pieces FROM dbwh.wh_order_invbal b left JOIN dbwh.wh_material m ON b.material_id = m.material_id left JOIN dbwh.wh_lot l ON b.lot_id = l.lot_id where b.acct_id = 14 and b.avbl_pieces > 0 and (l.lot_name like '%4387%' OR m.material_no like '%4387%' or m.model like '%4387%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017714023590088 -- 25-11-13 19:54:38 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035059452056885 -- 25-11-13 19:54:38 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040478706359863 -- 25-11-13 19:54:38 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='ChenJin' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038130283355713 -- 25-11-13 19:54:38[陈锦-1032] -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 14 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040309429168701 -- 25-11-13 19:54:38[陈锦-1032] -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select jsapi_ticket from dbwechat.wechat_token wt left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000014 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.032518148422241 -- 25-11-13 19:54:42[陈锦-1032] -- /buz/wh/index.php/whmgmt/wh_stockcheck?event=query SELECT l.lot_name,m.material_id,m.material_no,m.model,m.spec,sum(b.avbl_pieces) avbl_pieces FROM dbwh.wh_order_invbal b left JOIN dbwh.wh_material m ON b.material_id = m.material_id left JOIN dbwh.wh_lot l ON b.lot_id = l.lot_id where b.acct_id = 14 and b.avbl_pieces > 0 and (l.lot_name like '%2834%' OR m.material_no like '%2834%' or m.model like '%2834%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------