Time: 0.019442081451416 -- 26-01-20 09:22:33 -- /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.0035359859466553 -- 26-01-20 09:22:33 -- /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.0046970844268799 -- 26-01-20 09:22:33 -- /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.0039269924163818 -- 26-01-20 09:22:33[马正坤-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.0045709609985352 -- 26-01-20 09:22:33[马正坤-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.031235933303833 -- 26-01-20 09:22:39[马正坤-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 '%11-10-1%' OR m.material_no like '%11-10-1%' or m.model like '%11-10-1%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017692089080811 -- 26-01-20 09:29:25 -- /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.0034818649291992 -- 26-01-20 09:29:25 -- /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.0043849945068359 -- 26-01-20 09:29:25 -- /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.0037541389465332 -- 26-01-20 09:29:25[陈炳徽-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.028008222579956 -- 26-01-20 09:29:25 -- /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.018608093261719 -- 26-01-20 09:29:28[陈炳徽-673] -- /buz/wh/index.php/whmgmt/wh_stockcheck?wxMenu_id=1&agentid=1000014&appid=ww5262fb147810c303¶={%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.034694910049438 -- 26-01-20 09:29:38[陈炳徽-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 '%6940056126412%' OR m.material_no like '%6940056126412%' or m.model like '%6940056126412%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.03105092048645 -- 26-01-20 09:29:52[陈炳徽-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 '%6940056126504%' OR m.material_no like '%6940056126504%' or m.model like '%6940056126504%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.033288955688477 -- 26-01-20 09:34:35[陈炳徽-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 '%6940056128409%' OR m.material_no like '%6940056128409%' or m.model like '%6940056128409%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022842884063721 -- 26-01-20 10:05:39 -- /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.0028791427612305 -- 26-01-20 10:05:39 -- /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.0038611888885498 -- 26-01-20 10:05:39 -- /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='WeiDeWang' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003244161605835 -- 26-01-20 10:05:39[韦德旺-657] -- /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.0034008026123047 -- 26-01-20 10:05:39[韦德旺-657] -- /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.033156156539917 -- 26-01-20 10:05:44[韦德旺-657] -- /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 '%CODE_128,54859VH500A0461%' OR m.material_no like '%CODE_128,54859VH500A0461%' or m.model like '%CODE_128,54859VH500A0461%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.031491041183472 -- 26-01-20 10:05:48[韦德旺-657] -- /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 '%UPC_A,241114282801%' OR m.material_no like '%UPC_A,241114282801%' or m.model like '%UPC_A,241114282801%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.037830829620361 -- 26-01-20 10:05:55[韦德旺-657] -- /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 '%CODE_128,54859VH500A0480%' OR m.material_no like '%CODE_128,54859VH500A0480%' or m.model like '%CODE_128,54859VH500A0480%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.03865909576416 -- 26-01-20 10:06:00[韦德旺-657] -- /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 '%EAN_13,6940056182180%' OR m.material_no like '%EAN_13,6940056182180%' or m.model like '%EAN_13,6940056182180%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.038275003433228 -- 26-01-20 10:06:06[韦德旺-657] -- /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 '%6940056182180%' OR m.material_no like '%6940056182180%' or m.model like '%6940056182180%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018969058990479 -- 26-01-20 10:27:47[韦德旺-657] -- /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.033931970596313 -- 26-01-20 10:27:54[韦德旺-657] -- /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 '%EAN_13,6940056131997%' OR m.material_no like '%EAN_13,6940056131997%' or m.model like '%EAN_13,6940056131997%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.03279185295105 -- 26-01-20 10:28:01[韦德旺-657] -- /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 '%6940056131997%' OR m.material_no like '%6940056131997%' or m.model like '%6940056131997%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019450187683105 -- 26-01-20 14:05:11 -- /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.0038578510284424 -- 26-01-20 14:05:11 -- /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.004763126373291 -- 26-01-20 14:05:11 -- /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.0045409202575684 -- 26-01-20 14:05:11[匡超-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.0042600631713867 -- 26-01-20 14:05:11[匡超-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.035614967346191 -- 26-01-20 14:05: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 '%2180%' OR m.material_no like '%2180%' or m.model like '%2180%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024899005889893 -- 26-01-20 14:54:45[匡超-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.017518043518066 -- 26-01-20 14:54: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.0033390522003174 -- 26-01-20 14:54: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.0038690567016602 -- 26-01-20 14:54:47 -- /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.0036680698394775 -- 26-01-20 14:54:47[陈梓豪-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.021201133728027 -- 26-01-20 14:54:50[陈梓豪-660] -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select jsapi_ticket from dbwechat.wechat_token wt left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000014 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.034642934799194 -- 26-01-20 14:54:53[匡超-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 '%8693%' OR m.material_no like '%8693%' or m.model like '%8693%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.037184953689575 -- 26-01-20 14:54:54[陈梓豪-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 '%1011-07D62-800%' OR m.material_no like '%1011-07D62-800%' or m.model like '%1011-07D62-800%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.032918930053711 -- 26-01-20 14:55:02[匡超-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 '%8639%' OR m.material_no like '%8639%' or m.model like '%8639%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016432046890259 -- 26-01-20 19:59: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.0031900405883789 -- 26-01-20 19:59: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.0037209987640381 -- 26-01-20 19:59:38 -- /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='HuangWenJun' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034759044647217 -- 26-01-20 19:59:38[黄文军-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.029016971588135 -- 26-01-20 19:59:41[黄文军-2342] -- /buz/wh/index.php/whmgmt/wh_stockcheck?wxMenu_id=1&agentid=1000014&appid=ww5262fb147810c303¶={%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.031028032302856 -- 26-01-20 19:59: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 '%8365%' OR m.material_no like '%8365%' or m.model like '%8365%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015450000762939 -- 26-01-20 20:15: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.028645038604736 -- 26-01-20 20:15:49[苗志培-653] -- /buz/wh/index.php/whmgmt/wh_stockcheck?wxMenu_id=1&agentid=1000014&appid=ww5262fb147810c303¶={%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.043531894683838 -- 26-01-20 20:16:03[苗志培-653] -- /buz/wh/index.php/whmgmt/wh_stockcheck?event=query SELECT l.lot_name,m.material_id,m.material_no,m.model,m.spec,sum(b.avbl_pieces) avbl_pieces FROM dbwh.wh_order_invbal b left JOIN dbwh.wh_material m ON b.material_id = m.material_id left JOIN dbwh.wh_lot l ON b.lot_id = l.lot_id where b.acct_id = 14 and b.avbl_pieces > 0 and (l.lot_name like '%6940056169020%' OR m.material_no like '%6940056169020%' or m.model like '%6940056169020%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026648044586182 -- 26-01-20 20:16:17[苗志培-653] -- /buz/wh/index.php/whmgmt/wh_stockcheck?wxMenu_id=1&agentid=1000014&appid=ww5262fb147810c303¶={%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.029237031936646 -- 26-01-20 20:16:31[苗志培-653] -- /buz/wh/index.php/whmgmt/wh_stockcheck?event=query SELECT l.lot_name,m.material_id,m.material_no,m.model,m.spec,sum(b.avbl_pieces) avbl_pieces FROM dbwh.wh_order_invbal b left JOIN dbwh.wh_material m ON b.material_id = m.material_id left JOIN dbwh.wh_lot l ON b.lot_id = l.lot_id where b.acct_id = 14 and b.avbl_pieces > 0 and (l.lot_name like '%6940056125361%' OR m.material_no like '%6940056125361%' or m.model like '%6940056125361%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------