Time: 0.0071558952331543 -- 26-06-06 09:48:06 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014
select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0014791488647461 -- 26-06-06 09:48:06 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014
select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p 
where p.appid='ww5262fb147810c303' and isenable=1  and publicno_type_id=2 limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0020060539245605 -- 26-06-06 09:48:06 -- /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='ChenBingHui' and b.cont_id >1 
and c.cont_isenable = 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0016961097717285 -- 26-06-06 09:48:06[陈炳徽-673] -- /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.014972925186157 -- 26-06-06 09:48:13[陈炳徽-673] -- /buz/wh/index.php/whmgmt/wh_stockcheck?wxMenu_id=1&agentid=1000014&appid=ww5262fb147810c303&para={%22agentid%22:%221000014%22,%22appid%22:%22ww5262fb147810c303%22}
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.077286958694458 -- 26-06-06 09:48:33[陈炳徽-673] -- /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 '%6940056113030%' OR m.material_no like '%6940056113030%' or m.model like '%6940056113030%')  
  group by l.lot_id,m.material_id limit 0,100
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0090470314025879 -- 26-06-06 11:08:35 -- /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.0017881393432617 -- 26-06-06 11:08:35 -- /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.0033078193664551 -- 26-06-06 11:08:35 -- /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='ChenZiHao' and b.cont_id >1 
and c.cont_isenable = 1
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.002100944519043 -- 26-06-06 11:08:35[陈梓豪-660] -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014
select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 14
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.0089199542999268 -- 26-06-06 11:08:37[陈梓豪-660] -- /buz/wh/index.php/whmgmt/wh_stockcheck?wxMenu_id=1&agentid=1000014&appid=ww5262fb147810c303&para={%22agentid%22:%221000014%22,%22appid%22:%22ww5262fb147810c303%22}
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.03386402130127 -- 26-06-06 11:08:47[陈梓豪-660] -- /buz/wh/index.php/whmgmt/wh_stockcheck?event=query
SELECT l.lot_name,m.material_id,m.material_no,m.model,m.spec,sum(b.avbl_pieces) avbl_pieces 

		FROM dbwh.wh_order_invbal b 

		left JOIN dbwh.wh_material m ON b.material_id = m.material_id 

		left JOIN dbwh.wh_lot l ON b.lot_id = l.lot_id 
  where b.acct_id = 14 and b.avbl_pieces > 0  and (l.lot_name like '%8966%' OR m.material_no like '%8966%' or m.model like '%8966%')  
  group by l.lot_id,m.material_id limit 0,100
------------------------------------------------------------------------------------------------------------------------------------------------------