Time: 0.018870115280151 -- 25-12-03 09:17:30 -- /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.0037291049957275 -- 25-12-03 09:17:30 -- /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.0045859813690186 -- 25-12-03 09:17:30 -- /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.0039870738983154 -- 25-12-03 09:17:30[匡超-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.0043158531188965 -- 25-12-03 09:17:30[匡超-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.031635046005249 -- 25-12-03 09:17:35[匡超-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 '%2888%' OR m.material_no like '%2888%' or m.model like '%2888%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018262147903442 -- 25-12-03 09:22:05 -- /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.0035619735717773 -- 25-12-03 09:22:05 -- /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.0044050216674805 -- 25-12-03 09:22:05 -- /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='MiaoZhiPei' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037939548492432 -- 25-12-03 09:22:05[苗志培-653] -- /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.0039529800415039 -- 25-12-03 09:22:05[苗志培-653] -- /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.0328369140625 -- 25-12-03 09:22:23[苗志培-653] -- /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 '%6940056128188%' OR m.material_no like '%6940056128188%' or m.model like '%6940056128188%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016412973403931 -- 25-12-03 09:28:59 -- /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.0032150745391846 -- 25-12-03 09:28:59 -- /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.0036849975585938 -- 25-12-03 09:28:59 -- /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.0034730434417725 -- 25-12-03 09:28:59[陈锦-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.0036261081695557 -- 25-12-03 09:28:59[陈锦-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.025329113006592 -- 25-12-03 09:29:00 -- /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.035481929779053 -- 25-12-03 09:29:04[陈锦-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 '%8188%' OR m.material_no like '%8188%' or m.model like '%8188%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022243976593018 -- 25-12-03 15:47:45 -- /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.0044620037078857 -- 25-12-03 15:47:45 -- /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.0052149295806885 -- 25-12-03 15:47:45 -- /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.0046350955963135 -- 25-12-03 15:47:45[马正坤-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.0048561096191406 -- 25-12-03 15:47:45[马正坤-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.034488916397095 -- 25-12-03 15:47:59[马正坤-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 '%07T16%' OR m.material_no like '%07T16%' or m.model like '%07T16%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.033920049667358 -- 25-12-03 15:48:50[马正坤-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 '%09H09%' OR m.material_no like '%09H09%' or m.model like '%09H09%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.034759044647217 -- 25-12-03 15:49:11[马正坤-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 '%12M11%' OR m.material_no like '%12M11%' or m.model like '%12M11%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.03344202041626 -- 25-12-03 15:49:35[马正坤-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 '%13C03%' OR m.material_no like '%13C03%' or m.model like '%13C03%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0361168384552 -- 25-12-03 15:50:01[马正坤-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 '%12F14%' OR m.material_no like '%12F14%' or m.model like '%12F14%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.034188032150269 -- 25-12-03 15:50:17[马正坤-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 '%13N07%' OR m.material_no like '%13N07%' or m.model like '%13N07%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.047228097915649 -- 25-12-03 15:50:43[马正坤-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 '%13N07%' OR m.material_no like '%13N07%' or m.model like '%13N07%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.040004014968872 -- 25-12-03 15:50:52[马正坤-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 '%13N05%' OR m.material_no like '%13N05%' or m.model like '%13N05%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.036190986633301 -- 25-12-03 15:50:59[马正坤-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 '%13M05%' OR m.material_no like '%13M05%' or m.model like '%13M05%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.032249927520752 -- 25-12-03 15:51:21[马正坤-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 '%13K16%' OR m.material_no like '%13K16%' or m.model like '%13K16%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.032437086105347 -- 25-12-03 15:51:40[马正坤-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 '%13Z00%' OR m.material_no like '%13Z00%' or m.model like '%13Z00%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.036590099334717 -- 25-12-03 15:52:05[马正坤-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 '%13L03%' OR m.material_no like '%13L03%' or m.model like '%13L03%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.032722949981689 -- 25-12-03 15:52:54[马正坤-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 '%13P05%' OR m.material_no like '%13P05%' or m.model like '%13P05%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.034235000610352 -- 25-12-03 15:53:15[马正坤-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 '%13M00%' OR m.material_no like '%13M00%' or m.model like '%13M00%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.034362077713013 -- 25-12-03 15:53:32[马正坤-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 '%13N01%' OR m.material_no like '%13N01%' or m.model like '%13N01%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.034362077713013 -- 25-12-03 15:53:52[马正坤-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 '%03200%' OR m.material_no like '%03200%' or m.model like '%03200%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021922826766968 -- 25-12-03 16:40: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.0042831897735596 -- 25-12-03 16:40: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.0051169395446777 -- 25-12-03 16:40: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='ChenZiHao' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045628547668457 -- 25-12-03 16:40:58[陈梓豪-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.0046911239624023 -- 25-12-03 16:40:58[陈梓豪-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.028801918029785 -- 25-12-03 16:43:10[陈梓豪-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.035154104232788 -- 25-12-03 16:43:26[陈梓豪-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 '%13K16-222%' OR m.material_no like '%13K16-222%' or m.model like '%13K16-222%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.031821012496948 -- 25-12-03 17:22:18 -- /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.0041649341583252 -- 25-12-03 17:22:18 -- /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.0046319961547852 -- 25-12-03 17:22:18 -- /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.0044269561767578 -- 25-12-03 17:22:18[陈梓豪-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.0041980743408203 -- 25-12-03 17:22:18[陈梓豪-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.018156051635742 -- 25-12-03 18:52:05 -- /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.003626823425293 -- 25-12-03 18:52:05 -- /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.0041220188140869 -- 25-12-03 18:52:05 -- /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.0039808750152588 -- 25-12-03 18:52:05[申彩连-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.0041749477386475 -- 25-12-03 18:52:05[申彩连-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.0035839080810547 -- 25-12-03 18:52:05[申彩连-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.0040559768676758 -- 25-12-03 18:52:05[申彩连-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.0036640167236328 -- 25-12-03 18:52:05[申彩连-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.035476922988892 -- 25-12-03 18:52:06[申彩连-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/26' AND o.order_date <= '2025/12/03 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01917290687561 -- 25-12-03 18:52:13[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=963888&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 = '963888 ' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018567085266113 -- 25-12-03 18:52:51[申彩连-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.020546197891235 -- 25-12-03 18:52:52[申彩连-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.036310911178589 -- 25-12-03 18:52:53[申彩连-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/26' AND o.order_date <= '2025/12/03 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016698122024536 -- 25-12-03 18:53:02[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=963886&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 = '963886 ' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019313812255859 -- 25-12-03 18:53:35[申彩连-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.016071081161499 -- 25-12-03 18:53: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.046175003051758 -- 25-12-03 18:53: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.order_date >= '2025/11/26' AND o.order_date <= '2025/12/03 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019524097442627 -- 25-12-03 18:53:47[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=963899&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 = '963899 ' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01939582824707 -- 25-12-03 18:54:14[申彩连-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.019352912902832 -- 25-12-03 18:54:15[申彩连-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.035744905471802 -- 25-12-03 18:54:16[申彩连-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/26' AND o.order_date <= '2025/12/03 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019573926925659 -- 25-12-03 18:54:25[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=963898&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 = '963898 ' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01667594909668 -- 25-12-03 18:55:00[申彩连-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.025738954544067 -- 25-12-03 18:55:01[申彩连-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.034982204437256 -- 25-12-03 18:55:02[申彩连-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/26' AND o.order_date <= '2025/12/03 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------