Time: 0.016901969909668 -- 25-11-24 10:28: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.0033419132232666 -- 25-11-24 10:28: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.0042169094085693 -- 25-11-24 10:28: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='HuQi' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036289691925049 -- 25-11-24 10:28:05[胡琪-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.0033888816833496 -- 25-11-24 10:28:05[胡琪-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.036887884140015 -- 25-11-24 10:28:12[胡琪-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 '%193469%' OR m.material_no like '%193469%' or m.model like '%193469%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020480871200562 -- 25-11-24 17:45:10 -- /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.0041611194610596 -- 25-11-24 17:45:10 -- /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.0046169757843018 -- 25-11-24 17:45:10 -- /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.0044710636138916 -- 25-11-24 17:45:10[申彩连-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.0046470165252686 -- 25-11-24 17:45:10[申彩连-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.0041048526763916 -- 25-11-24 17:45:10[申彩连-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.0065610408782959 -- 25-11-24 17:45:10[申彩连-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.0045161247253418 -- 25-11-24 17:45:10[申彩连-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.041379928588867 -- 25-11-24 17:45:12[申彩连-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/17' AND o.order_date <= '2025/11/24 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.031051158905029 -- 25-11-24 17:45:17[申彩连-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 '%34262%' AND o.order_date >= '2025/11/17' AND o.order_date <= '2025/11/24 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01679801940918 -- 25-11-24 17:45:18[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=958865&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 = '958865 ' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01816987991333 -- 25-11-24 17:45:40[申彩连-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.020761013031006 -- 25-11-24 17:45:43[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_list select jsapi_ticket from dbwechat.wechat_token wt left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000014 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.034755945205688 -- 25-11-24 17:45: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 >= '2025/11/17' AND o.order_date <= '2025/11/24 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.032839059829712 -- 25-11-24 17:46:58[申彩连-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 '%634846%' AND o.order_date >= '2025/11/17' AND o.order_date <= '2025/11/24 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030017137527466 -- 25-11-24 17:47:00[申彩连-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 '%634846%' AND o.order_date >= '2025/11/17' AND o.order_date <= '2025/11/24 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020251989364624 -- 25-11-24 17:47:01[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=959007&outpkg_id=81976 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 = '959007 ' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004025936126709 -- 25-11-24 17:47:01[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=959007&outpkg_id=81976 select * from dbwh.wh_outpkg where outpkg_id = 81976 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040519237518311 -- 25-11-24 17:47:01[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=959007&outpkg_id=81976 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 5617783 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020187854766846 -- 25-11-24 17:47: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.022243022918701 -- 25-11-24 17:47: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.032700061798096 -- 25-11-24 17:47: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/17' AND o.order_date <= '2025/11/24 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.038506031036377 -- 25-11-24 17:47:45[申彩连-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 '%35047%' AND o.order_date >= '2025/11/17' AND o.order_date <= '2025/11/24 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.032964944839478 -- 25-11-24 17:47: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 AND o.cust_no like '%35047%' AND o.order_date >= '2025/11/17' AND o.order_date <= '2025/11/24 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023586988449097 -- 25-11-24 17:47:47[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=959092&outpkg_id=82037 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 = '959092 ' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046310424804688 -- 25-11-24 17:47:47[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=959092&outpkg_id=82037 select * from dbwh.wh_outpkg where outpkg_id = 82037 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046679973602295 -- 25-11-24 17:47:47[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=959092&outpkg_id=82037 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 5619227 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021703004837036 -- 25-11-24 17:48:02[申彩连-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.017897844314575 -- 25-11-24 17:48:03[申彩连-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.035721063613892 -- 25-11-24 17:48:04[申彩连-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/17' AND o.order_date <= '2025/11/24 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.033898830413818 -- 25-11-24 17:49:08[申彩连-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.order_date >= '2025/11/17' AND o.order_date <= '2025/11/24 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030141830444336 -- 25-11-24 17:49:12[申彩连-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 '%35042%' AND o.order_date >= '2025/11/17' AND o.order_date <= '2025/11/24 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022948026657104 -- 25-11-24 17:49:13[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=959090&outpkg_id=82036 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 = '959090 ' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045030117034912 -- 25-11-24 17:49:13[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=959090&outpkg_id=82036 select * from dbwh.wh_outpkg where outpkg_id = 82036 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045418739318848 -- 25-11-24 17:49:13[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=959090&outpkg_id=82036 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 5619222 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019623994827271 -- 25-11-24 17:49:23[申彩连-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.016484022140503 -- 25-11-24 17:49:26[申彩连-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.032310009002686 -- 25-11-24 17:49: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 or op.outpkg_id is null) AND o.order_date >= '2025/11/17' AND o.order_date <= '2025/11/24 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019006013870239 -- 25-11-24 17:59:31[申彩连-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.0036489963531494 -- 25-11-24 17:59:31[申彩连-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.0041670799255371 -- 25-11-24 17:59:31[申彩连-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.0043981075286865 -- 25-11-24 17:59:31[申彩连-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.032022953033447 -- 25-11-24 17:59:32[申彩连-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/17' AND o.order_date <= '2025/11/24 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.031632900238037 -- 25-11-24 17:59:38[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_list?event=query_outBound_list select o.*,c.cust_disp_name customer,IFNULL(op.outpkg_id,0) outpkg_id, date_format(o.order_date,'%Y-%m-%d') order_date,op.ship_pieces,op.ship_weight, op.ship_volume, s.stock_name from dbwh.v_wh_order o left join dbwh.v_wh_customer c on o.customer_id = c.customer_id left join dbwh.wh_orderex_ship os on os.order_id = o.order_id left join dbwh.wh_outpkgch_order op_o on op_o.order_id = o.order_id left join dbwh.wh_outpkg op on op.outpkg_id = op_o.outpkg_id left join dbwh.wh_stock s on o.stock_id = s.stock_id WHERE o.order_type_id = 2 and o.acct_id = 9 and os.is_self_carry = 1 AND (op.outpkg_id <= 1 or op.outpkg_id is null) AND o.cust_no like '%634149%' AND o.order_date >= '2025/11/17' AND o.order_date <= '2025/11/24 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020534992218018 -- 25-11-24 17:59:38[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=959097&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 = '959097 ' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018831014633179 -- 25-11-24 18:00: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.0208580493927 -- 25-11-24 18:00:30[申彩连-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.045869827270508 -- 25-11-24 18:00:31[申彩连-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/17' AND o.order_date <= '2025/11/24 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.032221078872681 -- 25-11-24 18:55:59[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_list?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014&wxMenu_id=115 select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=115 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042128562927246 -- 25-11-24 18:55:59[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_list?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014&wxMenu_id=115 select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 365 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047578811645508 -- 25-11-24 18:55:59[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_list?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014&wxMenu_id=115 select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 115 and cont_id = 365 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046911239624023 -- 25-11-24 18:55:59[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_list?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014&wxMenu_id=115 select jsapi_ticket from dbwechat.wechat_token wt left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000014 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.032872915267944 -- 25-11-24 18:56:00[申彩连-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/17' AND o.order_date <= '2025/11/24 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029797077178955 -- 25-11-24 18:56:08[申彩连-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 '%35149%' AND o.order_date >= '2025/11/17' AND o.order_date <= '2025/11/24 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028739929199219 -- 25-11-24 18:56:10[申彩连-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 '%35149%' AND o.order_date >= '2025/11/17' AND o.order_date <= '2025/11/24 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024891138076782 -- 25-11-24 18:56:11[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=959149&outpkg_id=82043 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 = '959149 ' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038459300994873 -- 25-11-24 18:56:11[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=959149&outpkg_id=82043 select * from dbwh.wh_outpkg where outpkg_id = 82043 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038509368896484 -- 25-11-24 18:56:11[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=959149&outpkg_id=82043 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 5619579 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022513151168823 -- 25-11-24 18:56:42[申彩连-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.01823902130127 -- 25-11-24 18:56:44[申彩连-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.038489103317261 -- 25-11-24 18:56:45[申彩连-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/17' AND o.order_date <= '2025/11/24 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------