Time: 0.022019863128662 -- 26-04-08 11:43: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.0019321441650391 -- 26-04-08 11:43: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.0028619766235352 -- 26-04-08 11:43: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='ChenZiHao' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002140998840332 -- 26-04-08 11:43:25[陈梓豪-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.015589952468872 -- 26-04-08 11:43:26[陈梓豪-660] -- /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.024662971496582 -- 26-04-08 11:43:39[陈梓豪-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 '%1097%' OR m.material_no like '%1097%' or m.model like '%1097%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0089750289916992 -- 26-04-08 11:44:58 -- /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.001723051071167 -- 26-04-08 11:44:58 -- /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.0026309490203857 -- 26-04-08 11:44:58 -- /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.0019700527191162 -- 26-04-08 11:44:58[韦德旺-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.002140998840332 -- 26-04-08 11:44:58[韦德旺-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.024715185165405 -- 26-04-08 11:45:02[韦德旺-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 '%101C-12M08-222|6940056123015|20|BS022603160244%' OR m.material_no like '%101C-12M08-222|6940056123015|20|BS022603160244%' or m.model like '%101C-12M08-222|6940056123015|20|BS022603160244%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030044794082642 -- 26-04-08 11:45:12[韦德旺-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 '%101C-12M08-222%' OR m.material_no like '%101C-12M08-222%' or m.model like '%101C-12M08-222%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013885021209717 -- 26-04-08 11:48:33[韦德旺-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.021983861923218 -- 26-04-08 11:48:36[韦德旺-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,G05-09-2%' OR m.material_no like '%CODE_128,G05-09-2%' or m.model like '%CODE_128,G05-09-2%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023606061935425 -- 26-04-08 11:48:41[韦德旺-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 '%G05-09-2%' OR m.material_no like '%G05-09-2%' or m.model like '%G05-09-2%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0084218978881836 -- 26-04-08 14:02:32 -- /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.0015869140625 -- 26-04-08 14:02:32 -- /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.0025210380554199 -- 26-04-08 14:02:32 -- /buz/wh/index.php/whmgmt/outTally_list?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014&wxMenu_id=115 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='MiaoZhiPei' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001863956451416 -- 26-04-08 14:02:32[苗志培-653] -- /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= 14 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014049053192139 -- 26-04-08 14:02:34[苗志培-653] -- /buz/wh/index.php/whmgmt/outTally_list?wxMenu_id=115&agentid=1000014&appid=ww5262fb147810c303&wxMenu_id=115¶={%22agentid%22:%221000014%22,%22appid%22:%22ww5262fb147810c303%22,%22wxMenu_id%22:%22115%22} select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=115 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018999576568604 -- 26-04-08 14:02:34[苗志培-653] -- /buz/wh/index.php/whmgmt/outTally_list?wxMenu_id=115&agentid=1000014&appid=ww5262fb147810c303&wxMenu_id=115¶={%22agentid%22:%221000014%22,%22appid%22:%22ww5262fb147810c303%22,%22wxMenu_id%22:%22115%22} select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 653 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003309965133667 -- 26-04-08 14:02:34[苗志培-653] -- /buz/wh/index.php/whmgmt/outTally_list?wxMenu_id=115&agentid=1000014&appid=ww5262fb147810c303&wxMenu_id=115¶={%22agentid%22:%221000014%22,%22appid%22:%22ww5262fb147810c303%22,%22wxMenu_id%22:%22115%22} select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 115 and cont_id = 653 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013174057006836 -- 26-04-08 14:02:46[苗志培-653] -- /buz/wh/index.php/whmgmt/outTally_list?wxMenu_id=115&agentid=1000014&appid=ww5262fb147810c303&wxMenu_id=115¶={%22agentid%22:%221000014%22,%22appid%22:%22ww5262fb147810c303%22,%22wxMenu_id%22:%22115%22} select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=115 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016298294067383 -- 26-04-08 14:02:46[苗志培-653] -- /buz/wh/index.php/whmgmt/outTally_list?wxMenu_id=115&agentid=1000014&appid=ww5262fb147810c303&wxMenu_id=115¶={%22agentid%22:%221000014%22,%22appid%22:%22ww5262fb147810c303%22,%22wxMenu_id%22:%22115%22} select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 653 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001662015914917 -- 26-04-08 14:02:46[苗志培-653] -- /buz/wh/index.php/whmgmt/outTally_list?wxMenu_id=115&agentid=1000014&appid=ww5262fb147810c303&wxMenu_id=115¶={%22agentid%22:%221000014%22,%22appid%22:%22ww5262fb147810c303%22,%22wxMenu_id%22:%22115%22} select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 115 and cont_id = 653 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0083341598510742 -- 26-04-08 14:02:54[苗志培-653] -- /buz/wh/index.php/whmgmt/outTally_list?wxMenu_id=115&agentid=1000014&appid=ww5262fb147810c303&wxMenu_id=115¶={%22agentid%22:%221000014%22,%22appid%22:%22ww5262fb147810c303%22,%22wxMenu_id%22:%22115%22} select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=115 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015280246734619 -- 26-04-08 14:02:54[苗志培-653] -- /buz/wh/index.php/whmgmt/outTally_list?wxMenu_id=115&agentid=1000014&appid=ww5262fb147810c303&wxMenu_id=115¶={%22agentid%22:%221000014%22,%22appid%22:%22ww5262fb147810c303%22,%22wxMenu_id%22:%22115%22} select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 653 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015099048614502 -- 26-04-08 14:02:54[苗志培-653] -- /buz/wh/index.php/whmgmt/outTally_list?wxMenu_id=115&agentid=1000014&appid=ww5262fb147810c303&wxMenu_id=115¶={%22agentid%22:%221000014%22,%22appid%22:%22ww5262fb147810c303%22,%22wxMenu_id%22:%22115%22} select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 115 and cont_id = 653 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017882108688354 -- 26-04-08 14:02:58[苗志培-653] -- /buz/wh/index.php/whmgmt/outTally_list?wxMenu_id=115&agentid=1000014&appid=ww5262fb147810c303&wxMenu_id=115¶={%22agentid%22:%221000014%22,%22appid%22:%22ww5262fb147810c303%22,%22wxMenu_id%22:%22115%22} select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=115 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015709400177002 -- 26-04-08 14:02:58[苗志培-653] -- /buz/wh/index.php/whmgmt/outTally_list?wxMenu_id=115&agentid=1000014&appid=ww5262fb147810c303&wxMenu_id=115¶={%22agentid%22:%221000014%22,%22appid%22:%22ww5262fb147810c303%22,%22wxMenu_id%22:%22115%22} select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 653 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015571117401123 -- 26-04-08 14:02:58[苗志培-653] -- /buz/wh/index.php/whmgmt/outTally_list?wxMenu_id=115&agentid=1000014&appid=ww5262fb147810c303&wxMenu_id=115¶={%22agentid%22:%221000014%22,%22appid%22:%22ww5262fb147810c303%22,%22wxMenu_id%22:%22115%22} select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 115 and cont_id = 653 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0079400539398193 -- 26-04-08 14:03:42[苗志培-653] -- /buz/wh/index.php/whmgmt/outTally_list?wxMenu_id=115&agentid=1000014&appid=ww5262fb147810c303&wxMenu_id=115¶={%22agentid%22:%221000014%22,%22appid%22:%22ww5262fb147810c303%22,%22wxMenu_id%22:%22115%22} select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=115 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001492977142334 -- 26-04-08 14:03:42[苗志培-653] -- /buz/wh/index.php/whmgmt/outTally_list?wxMenu_id=115&agentid=1000014&appid=ww5262fb147810c303&wxMenu_id=115¶={%22agentid%22:%221000014%22,%22appid%22:%22ww5262fb147810c303%22,%22wxMenu_id%22:%22115%22} select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 653 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018839836120605 -- 26-04-08 14:03:42[苗志培-653] -- /buz/wh/index.php/whmgmt/outTally_list?wxMenu_id=115&agentid=1000014&appid=ww5262fb147810c303&wxMenu_id=115¶={%22agentid%22:%221000014%22,%22appid%22:%22ww5262fb147810c303%22,%22wxMenu_id%22:%22115%22} select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 115 and cont_id = 653 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0089061260223389 -- 26-04-08 14:03:56[苗志培-653] -- /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.023026943206787 -- 26-04-08 14:04:14[苗志培-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 '%34189%' OR m.material_no like '%34189%' or m.model like '%34189%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022908926010132 -- 26-04-08 14:05:24[苗志培-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 '%23008%' OR m.material_no like '%23008%' or m.model like '%23008%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0091540813446045 -- 26-04-08 14:12: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.0018391609191895 -- 26-04-08 14:12: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.0023908615112305 -- 26-04-08 14:12: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='HuQi' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020780563354492 -- 26-04-08 14:12:47[胡琪-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.0023059844970703 -- 26-04-08 14:12:47[胡琪-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.024556875228882 -- 26-04-08 14:12:51[胡琪-911] -- /buz/wh/index.php/whmgmt/wh_stockcheck?event=query SELECT l.lot_name,m.material_id,m.material_no,m.model,m.spec,sum(b.avbl_pieces) avbl_pieces FROM dbwh.wh_order_invbal b left JOIN dbwh.wh_material m ON b.material_id = m.material_id left JOIN dbwh.wh_lot l ON b.lot_id = l.lot_id where b.acct_id = 14 and b.avbl_pieces > 0 and (l.lot_name like '%181909%' OR m.material_no like '%181909%' or m.model like '%181909%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0077099800109863 -- 26-04-08 14:22:58 -- /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.0079188346862793 -- 26-04-08 14:22:59 -- /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.0020639896392822 -- 26-04-08 14:22:59 -- /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.0024971961975098 -- 26-04-08 14:22:59 -- /buz/wh/index.php/whmgmt/wh_stockcheck?agentid=1000014&appid=ww5262fb147810c303&agentid=1000014 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='ChenPing' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018560886383057 -- 26-04-08 14:22:59[陈平-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.011411905288696 -- 26-04-08 14:23:04[陈平-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.029603958129883 -- 26-04-08 14:23:12[陈平-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 '%6863%' OR m.material_no like '%6863%' or m.model like '%6863%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0088260173797607 -- 26-04-08 14:38:44[苗志培-653] -- /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.010746002197266 -- 26-04-08 14:39:02[苗志培-653] -- /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.0088870525360107 -- 26-04-08 14:46:48[苗志培-653] -- /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 ------------------------------------------------------------------------------------------------------------------------------------------------------