Time: 0.019459962844849 -- 25-11-29 11:44:46 -- /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.0038309097290039 -- 25-11-29 11:44:46 -- /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.0043179988861084 -- 25-11-29 11:44:46 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='HuangWenJun' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004082202911377 -- 25-11-29 11:44:46[黄文军-2342] -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 14 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042881965637207 -- 25-11-29 11:44:46[黄文军-2342] -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select jsapi_ticket from dbwechat.wechat_token wt left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000014 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.03345799446106 -- 25-11-29 11:44:51[黄文军-2342] -- /buz/wh/index.php/whmgmt/wh_stockcheck?event=query SELECT l.lot_name,m.material_id,m.material_no,m.model,m.spec,sum(b.avbl_pieces) avbl_pieces FROM dbwh.wh_order_invbal b left JOIN dbwh.wh_material m ON b.material_id = m.material_id left JOIN dbwh.wh_lot l ON b.lot_id = l.lot_id where b.acct_id = 14 and b.avbl_pieces > 0 and (l.lot_name like '%1886%' OR m.material_no like '%1886%' or m.model like '%1886%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019738912582397 -- 25-11-29 15:07:38 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039510726928711 -- 25-11-29 15:07:38 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044119358062744 -- 25-11-29 15:07:38 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='ChenBingHui' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042338371276855 -- 25-11-29 15:07:38[陈炳徽-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.0043408870697021 -- 25-11-29 15:07:38[陈炳徽-673] -- /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.032242059707642 -- 25-11-29 15:07:42[陈炳徽-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 '%5693%' OR m.material_no like '%5693%' or m.model like '%5693%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019582033157349 -- 25-11-29 16:41:53 -- /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.0038340091705322 -- 25-11-29 16:41:53 -- /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.0046710968017578 -- 25-11-29 16:41:53 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='KuangChao' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040960311889648 -- 25-11-29 16:41:53[匡超-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.0042450428009033 -- 25-11-29 16:41:53[匡超-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.03593111038208 -- 25-11-29 16:41:57[匡超-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 '%1069%' OR m.material_no like '%1069%' or m.model like '%1069%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.033824920654297 -- 25-11-29 16:42:08[匡超-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 '%1095%' OR m.material_no like '%1095%' or m.model like '%1095%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.037297964096069 -- 25-11-29 16:42:20[匡超-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 '%0695%' OR m.material_no like '%0695%' or m.model like '%0695%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018945932388306 -- 25-11-29 16:42:47 -- /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.0036940574645996 -- 25-11-29 16:42:47 -- /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.0045568943023682 -- 25-11-29 16:42:47 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='ChenPing' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039210319519043 -- 25-11-29 16:42:47[陈平-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.0040779113769531 -- 25-11-29 16:42:47[陈平-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.037075996398926 -- 25-11-29 16:43:16[陈平-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 '%34547%' OR m.material_no like '%34547%' or m.model like '%34547%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.034276962280273 -- 25-11-29 16:44:10[陈平-1030] -- /buz/wh/index.php/whmgmt/wh_stockcheck?event=query SELECT l.lot_name,m.material_id,m.material_no,m.model,m.spec,sum(b.avbl_pieces) avbl_pieces FROM dbwh.wh_order_invbal b left JOIN dbwh.wh_material m ON b.material_id = m.material_id left JOIN dbwh.wh_lot l ON b.lot_id = l.lot_id where b.acct_id = 14 and b.avbl_pieces > 0 and (l.lot_name like '%34585%' OR m.material_no like '%34585%' or m.model like '%34585%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.039280891418457 -- 25-11-29 16:44:59[陈平-1030] -- /buz/wh/index.php/whmgmt/wh_stockcheck?event=query SELECT l.lot_name,m.material_id,m.material_no,m.model,m.spec,sum(b.avbl_pieces) avbl_pieces FROM dbwh.wh_order_invbal b left JOIN dbwh.wh_material m ON b.material_id = m.material_id left JOIN dbwh.wh_lot l ON b.lot_id = l.lot_id where b.acct_id = 14 and b.avbl_pieces > 0 and (l.lot_name like '%4387%' OR m.material_no like '%4387%' or m.model like '%4387%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.038564920425415 -- 25-11-29 16:45:50[陈平-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 '%4578%' OR m.material_no like '%4578%' or m.model like '%4578%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.037052869796753 -- 25-11-29 16:46:17[陈平-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 '%1790%' OR m.material_no like '%1790%' or m.model like '%1790%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.034295797348022 -- 25-11-29 16:46:25[匡超-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 '%3519%' OR m.material_no like '%3519%' or m.model like '%3519%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.03422999382019 -- 25-11-29 16:47:09[陈平-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 '%34301%' OR m.material_no like '%34301%' or m.model like '%34301%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.039095878601074 -- 25-11-29 16:49:08[陈平-1030] -- /buz/wh/index.php/whmgmt/wh_stockcheck?event=query SELECT l.lot_name,m.material_id,m.material_no,m.model,m.spec,sum(b.avbl_pieces) avbl_pieces FROM dbwh.wh_order_invbal b left JOIN dbwh.wh_material m ON b.material_id = m.material_id left JOIN dbwh.wh_lot l ON b.lot_id = l.lot_id where b.acct_id = 14 and b.avbl_pieces > 0 and (l.lot_name like '%0688%' OR m.material_no like '%0688%' or m.model like '%0688%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02180004119873 -- 25-11-29 16:49:18 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042619705200195 -- 25-11-29 16:49:18 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0051138401031494 -- 25-11-29 16:49:18 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='HuangWenJun' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045101642608643 -- 25-11-29 16:49:18[黄文军-2342] -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 14 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004723072052002 -- 25-11-29 16:49:18[黄文军-2342] -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select jsapi_ticket from dbwechat.wechat_token wt left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000014 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.034469127655029 -- 25-11-29 16:49:27[黄文军-2342] -- /buz/wh/index.php/whmgmt/wh_stockcheck?event=query SELECT l.lot_name,m.material_id,m.material_no,m.model,m.spec,sum(b.avbl_pieces) avbl_pieces FROM dbwh.wh_order_invbal b left JOIN dbwh.wh_material m ON b.material_id = m.material_id left JOIN dbwh.wh_lot l ON b.lot_id = l.lot_id where b.acct_id = 14 and b.avbl_pieces > 0 and (l.lot_name like '%4295%' OR m.material_no like '%4295%' or m.model like '%4295%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.039239883422852 -- 25-11-29 16:49:37[陈平-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 '%3373%' OR m.material_no like '%3373%' or m.model like '%3373%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.034869909286499 -- 25-11-29 16:49:57[黄文军-2342] -- /buz/wh/index.php/whmgmt/wh_stockcheck?event=query SELECT l.lot_name,m.material_id,m.material_no,m.model,m.spec,sum(b.avbl_pieces) avbl_pieces FROM dbwh.wh_order_invbal b left JOIN dbwh.wh_material m ON b.material_id = m.material_id left JOIN dbwh.wh_lot l ON b.lot_id = l.lot_id where b.acct_id = 14 and b.avbl_pieces > 0 and (l.lot_name like '%4370%' OR m.material_no like '%4370%' or m.model like '%4370%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.036036968231201 -- 25-11-29 16:50:55[黄文军-2342] -- /buz/wh/index.php/whmgmt/wh_stockcheck?event=query SELECT l.lot_name,m.material_id,m.material_no,m.model,m.spec,sum(b.avbl_pieces) avbl_pieces FROM dbwh.wh_order_invbal b left JOIN dbwh.wh_material m ON b.material_id = m.material_id left JOIN dbwh.wh_lot l ON b.lot_id = l.lot_id where b.acct_id = 14 and b.avbl_pieces > 0 and (l.lot_name like '%8782%' OR m.material_no like '%8782%' or m.model like '%8782%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.045719861984253 -- 25-11-29 16:51:03[陈平-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 '%3601%' OR m.material_no like '%3601%' or m.model like '%3601%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.034404039382935 -- 25-11-29 16:51:30[陈平-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 '%8782%' OR m.material_no like '%8782%' or m.model like '%8782%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021091938018799 -- 25-11-29 16:51:48[匡超-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.021416902542114 -- 25-11-29 17:00:47[黄文军-2342] -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select jsapi_ticket from dbwechat.wechat_token wt left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000014 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.036808013916016 -- 25-11-29 17:00:52[黄文军-2342] -- /buz/wh/index.php/whmgmt/wh_stockcheck?event=query SELECT l.lot_name,m.material_id,m.material_no,m.model,m.spec,sum(b.avbl_pieces) avbl_pieces FROM dbwh.wh_order_invbal b left JOIN dbwh.wh_material m ON b.material_id = m.material_id left JOIN dbwh.wh_lot l ON b.lot_id = l.lot_id where b.acct_id = 14 and b.avbl_pieces > 0 and (l.lot_name like '%2881%' OR m.material_no like '%2881%' or m.model like '%2881%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------