Time: 0.015758991241455 -- 26-01-09 09:40:14 -- /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.0031790733337402 -- 26-01-09 09:40:14 -- /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.0040950775146484 -- 26-01-09 09:40:14 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select b.cont_id, c.cont_name, c.acct_id, c.cont_password 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.003425121307373 -- 26-01-09 09:40:14[匡超-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.0032989978790283 -- 26-01-09 09:40:14[匡超-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.030093908309937 -- 26-01-09 09:40:21[匡超-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 '%3106%' OR m.material_no like '%3106%' or m.model like '%3106%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016867160797119 -- 26-01-09 09:44: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.015691041946411 -- 26-01-09 09:44: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.0037078857421875 -- 26-01-09 09:44: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.0041129589080811 -- 26-01-09 09:44:08 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select b.cont_id, c.cont_name, c.acct_id, c.cont_password 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.0034267902374268 -- 26-01-09 09:44:08[陈平-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.017061948776245 -- 26-01-09 09:44:12[陈平-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.030128002166748 -- 26-01-09 09:44:20[陈平-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 '%3451%' OR m.material_no like '%3451%' or m.model like '%3451%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017289876937866 -- 26-01-09 10:58:48 -- /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.0034210681915283 -- 26-01-09 10:58:48 -- /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.0042719841003418 -- 26-01-09 10:58:48 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='HuQi' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036489963531494 -- 26-01-09 10:58:48[胡琪-911] -- /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.0037870407104492 -- 26-01-09 10:58:48[胡琪-911] -- /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.040486097335815 -- 26-01-09 10:58:52[胡琪-911] -- /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 '%197429%' OR m.material_no like '%197429%' or m.model like '%197429%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021626949310303 -- 26-01-09 11:01:08[胡琪-911] -- /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.016717910766602 -- 26-01-09 12:00:01 -- /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.020787954330444 -- 26-01-09 14:20:56 -- /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.0032720565795898 -- 26-01-09 14:20:56 -- /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.0043561458587646 -- 26-01-09 14:20:56 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select b.cont_id, c.cont_name, c.acct_id, c.cont_password 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.0035300254821777 -- 26-01-09 14:20:56[马正坤-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.0037341117858887 -- 26-01-09 14:20:56[马正坤-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.031176090240479 -- 26-01-09 14:21:03[马正坤-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 '%3581%' OR m.material_no like '%3581%' or m.model like '%3581%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030993938446045 -- 26-01-09 14:24:10[马正坤-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 '%4618%' OR m.material_no like '%4618%' or m.model like '%4618%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025413036346436 -- 26-01-09 14:56:36 -- /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.0030941963195801 -- 26-01-09 14:56:36 -- /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.0037531852722168 -- 26-01-09 14:56:36 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='HuQi' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034859180450439 -- 26-01-09 14:56:36[胡琪-911] -- /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.0040361881256104 -- 26-01-09 14:56:36[胡琪-911] -- /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.03213095664978 -- 26-01-09 14:56:44[胡琪-911] -- /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 '%195203%' OR m.material_no like '%195203%' or m.model like '%195203%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0154128074646 -- 26-01-09 15:19:32[胡琪-911] -- /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.031623125076294 -- 26-01-09 15:19:51[胡琪-911] -- /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 '%132567%' OR m.material_no like '%132567%' or m.model like '%132567%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015357971191406 -- 26-01-09 17:16:57 -- /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.0030560493469238 -- 26-01-09 17:16:57 -- /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.003943920135498 -- 26-01-09 17:16:57 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='HuQi' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032880306243896 -- 26-01-09 17:16:57[胡琪-911] -- /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.0034849643707275 -- 26-01-09 17:16:57[胡琪-911] -- /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.030966997146606 -- 26-01-09 17:17:01[胡琪-911] -- /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 '%131829%' OR m.material_no like '%131829%' or m.model like '%131829%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025194883346558 -- 26-01-09 17:34:19 -- /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.0034370422363281 -- 26-01-09 17:34:19 -- /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.0043618679046631 -- 26-01-09 17:34:19 -- /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, c.cont_password 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.0037610530853271 -- 26-01-09 17:34:19[申彩连-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.00382399559021 -- 26-01-09 17:34:19[申彩连-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.0034329891204834 -- 26-01-09 17:34:19[申彩连-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.0038847923278809 -- 26-01-09 17:34:19[申彩连-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.0038530826568604 -- 26-01-09 17:34:19[申彩连-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.037807941436768 -- 26-01-09 17:34:19[申彩连-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 >= '2026/01/02' AND o.order_date <= '2026/01/09 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027125120162964 -- 26-01-09 17:34:25[申彩连-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 '%57097%' AND o.order_date >= '2026/01/02' AND o.order_date <= '2026/01/09 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02678394317627 -- 26-01-09 17:34:26[申彩连-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 '%57097%' AND o.order_date >= '2026/01/02' AND o.order_date <= '2026/01/09 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025585174560547 -- 26-01-09 17:34:27[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=988393&outpkg_id=85969 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 = '988393 ' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003572940826416 -- 26-01-09 17:34:27[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=988393&outpkg_id=85969 select * from dbwh.wh_outpkg where outpkg_id = 85969 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003148078918457 -- 26-01-09 17:34:27[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=988393&outpkg_id=85969 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5891756 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017280101776123 -- 26-01-09 17:34:44[申彩连-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.019339084625244 -- 26-01-09 17:34:46[申彩连-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.039982795715332 -- 26-01-09 17:34:47[申彩连-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 >= '2026/01/02' AND o.order_date <= '2026/01/09 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024778127670288 -- 26-01-09 17:34: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 AND o.cust_no like '%57095%' AND o.order_date >= '2026/01/02' AND o.order_date <= '2026/01/09 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016434907913208 -- 26-01-09 17:34:56[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=988392&outpkg_id=85968 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 = '988392 ' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032820701599121 -- 26-01-09 17:34:56[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=988392&outpkg_id=85968 select * from dbwh.wh_outpkg where outpkg_id = 85968 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032839775085449 -- 26-01-09 17:34:56[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=988392&outpkg_id=85968 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5891751 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016280889511108 -- 26-01-09 17:35: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.016895055770874 -- 26-01-09 17:35:16[申彩连-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.02947998046875 -- 26-01-09 17:35: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 >= '2026/01/02' AND o.order_date <= '2026/01/09 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024349927902222 -- 26-01-09 17:35:22[申彩连-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 '%57099%' AND o.order_date >= '2026/01/02' AND o.order_date <= '2026/01/09 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016938924789429 -- 26-01-09 17:35:22[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=988391&outpkg_id=85967 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 = '988391 ' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037431716918945 -- 26-01-09 17:35:22[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=988391&outpkg_id=85967 select * from dbwh.wh_outpkg where outpkg_id = 85967 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003364086151123 -- 26-01-09 17:35:22[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=988391&outpkg_id=85967 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5891743 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016551971435547 -- 26-01-09 17:35: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.016112089157104 -- 26-01-09 17:35:39[申彩连-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.016785860061646 -- 26-01-09 17:35:40[申彩连-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.036442995071411 -- 26-01-09 17:35: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 or op.outpkg_id is null) AND o.order_date >= '2026/01/02' AND o.order_date <= '2026/01/09 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023538112640381 -- 26-01-09 19:08:46 -- /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.0031130313873291 -- 26-01-09 19:08:46 -- /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.0041139125823975 -- 26-01-09 19:08:46 -- /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, c.cont_password 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.0034570693969727 -- 26-01-09 19:08:46[申彩连-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.0035390853881836 -- 26-01-09 19:08:46[申彩连-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.0031001567840576 -- 26-01-09 19:08:46[申彩连-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.0034871101379395 -- 26-01-09 19:08:46[申彩连-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.0031599998474121 -- 26-01-09 19:08:46[申彩连-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.028050899505615 -- 26-01-09 19:08:46[申彩连-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 >= '2026/01/02' AND o.order_date <= '2026/01/09 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017576932907104 -- 26-01-09 19:09:00[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=988435&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 = '988435 ' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017268180847168 -- 26-01-09 19:09:25[申彩连-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.017215967178345 -- 26-01-09 19:09:27[申彩连-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.032563209533691 -- 26-01-09 19:09:28[申彩连-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 >= '2026/01/02' AND o.order_date <= '2026/01/09 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017765998840332 -- 26-01-09 19:09:34[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=988406&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 = '988406 ' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016035079956055 -- 26-01-09 19:09:54[申彩连-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.015787124633789 -- 26-01-09 19:09: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.026907205581665 -- 26-01-09 19:09: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 >= '2026/01/02' AND o.order_date <= '2026/01/09 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016513109207153 -- 26-01-09 19:12:09[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=988408&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 = '988408 ' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016518831253052 -- 26-01-09 19:12:27[申彩连-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.021888017654419 -- 26-01-09 19:12:29[申彩连-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.029227018356323 -- 26-01-09 19:12:29[申彩连-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 >= '2026/01/02' AND o.order_date <= '2026/01/09 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016044855117798 -- 26-01-09 20:01:42[申彩连-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.0031459331512451 -- 26-01-09 20:01:42[申彩连-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.0034890174865723 -- 26-01-09 20:01:42[申彩连-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.0032038688659668 -- 26-01-09 20:01:42[申彩连-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.029768943786621 -- 26-01-09 20:01:43[申彩连-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 >= '2026/01/02' AND o.order_date <= '2026/01/09 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017253875732422 -- 26-01-09 20:01:45[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=988434&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 = '988434 ' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01661205291748 -- 26-01-09 20:02:07[申彩连-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.0153648853302 -- 26-01-09 20:02:09[申彩连-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.030781030654907 -- 26-01-09 20:02:09[申彩连-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 >= '2026/01/02' AND o.order_date <= '2026/01/09 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------