Time: 0.011197090148926 -- 26-04-17 09:13: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.0021669864654541 -- 26-04-17 09:13: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.0030989646911621 -- 26-04-17 09:13:46 -- /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.0023949146270752 -- 26-04-17 09:13:46[马正坤-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.0026750564575195 -- 26-04-17 09:13:46[马正坤-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.023744821548462 -- 26-04-17 09:13:56[马正坤-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 '%13A20%' OR m.material_no like '%13A20%' or m.model like '%13A20%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026589870452881 -- 26-04-17 09:14:11[马正坤-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 '%13A19%' OR m.material_no like '%13A19%' or m.model like '%13A19%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026955842971802 -- 26-04-17 09:14:32[马正坤-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 '%13A123%' OR m.material_no like '%13A123%' or m.model like '%13A123%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024779081344604 -- 26-04-17 09:14:36[马正坤-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 '%13A23%' OR m.material_no like '%13A23%' or m.model like '%13A23%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02640700340271 -- 26-04-17 09:14:50[马正坤-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 '%13A21%' OR m.material_no like '%13A21%' or m.model like '%13A21%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0095019340515137 -- 26-04-17 09:16:37 -- /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.0018980503082275 -- 26-04-17 09:16:37 -- /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.0023889541625977 -- 26-04-17 09:16:37 -- /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='ChenJin' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020649433135986 -- 26-04-17 09:16:37[陈锦-1032] -- /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.0077910423278809 -- 26-04-17 09:16:42[陈锦-1032] -- /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.023519039154053 -- 26-04-17 09:16:49[陈锦-1032] -- /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 '%7254%' OR m.material_no like '%7254%' or m.model like '%7254%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01462197303772 -- 26-04-17 09:19:41[陈锦-1032] -- /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.008613109588623 -- 26-04-17 09:25:07 -- /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.0016448497772217 -- 26-04-17 09:25:07 -- /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.0025551319122314 -- 26-04-17 09:25:07 -- /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.0018398761749268 -- 26-04-17 09:25:07[匡超-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.0020060539245605 -- 26-04-17 09:25:07[匡超-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.028589963912964 -- 26-04-17 09:25:13[匡超-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 '%7424%' OR m.material_no like '%7424%' or m.model like '%7424%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028136014938354 -- 26-04-17 09:25:21[匡超-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 '%7247%' OR m.material_no like '%7247%' or m.model like '%7247%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010394811630249 -- 26-04-17 09:32:08[匡超-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.036396980285645 -- 26-04-17 09:32:12[匡超-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 '%7247%' OR m.material_no like '%7247%' or m.model like '%7247%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010837078094482 -- 26-04-17 10:01:27 -- /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.0016441345214844 -- 26-04-17 10:01:27 -- /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.0025689601898193 -- 26-04-17 10:01:27 -- /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.0018758773803711 -- 26-04-17 10:01:27[陈梓豪-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.016685009002686 -- 26-04-17 10:01:31[陈梓豪-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.024118900299072 -- 26-04-17 10:01:37[陈梓豪-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 '%101E-13M06-800%' OR m.material_no like '%101E-13M06-800%' or m.model like '%101E-13M06-800%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019570112228394 -- 26-04-17 10:21:17 -- /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.0018489360809326 -- 26-04-17 10:21:17 -- /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.002730131149292 -- 26-04-17 10:21:17 -- /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.0020761489868164 -- 26-04-17 10:21:17[陈梓豪-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.0091979503631592 -- 26-04-17 10:21:19[陈梓豪-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.023478031158447 -- 26-04-17 10:21:46[陈梓豪-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 '%1064-10200-800%' OR m.material_no like '%1064-10200-800%' or m.model like '%1064-10200-800%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0085630416870117 -- 26-04-17 10:24:32[马正坤-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.036707878112793 -- 26-04-17 10:24:42[马正坤-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 '%13A20%' OR m.material_no like '%13A20%' or m.model like '%13A20%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022939920425415 -- 26-04-17 10:24:57[马正坤-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 '%13A19%' OR m.material_no like '%13A19%' or m.model like '%13A19%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026264190673828 -- 26-04-17 10:25:14[马正坤-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 '%13A23%' OR m.material_no like '%13A23%' or m.model like '%13A23%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024095058441162 -- 26-04-17 10:25:23[马正坤-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 '%13A21%' OR m.material_no like '%13A21%' or m.model like '%13A21%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025144100189209 -- 26-04-17 10:27:43[陈梓豪-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 '%101E-13M06-800%' OR m.material_no like '%101E-13M06-800%' or m.model like '%101E-13M06-800%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016633987426758 -- 26-04-17 11:30: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.014195919036865 -- 26-04-17 11:30:10[陈锦-1032] -- /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.028548002243042 -- 26-04-17 11:30:16[陈锦-1032] -- /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 '%3437%' OR m.material_no like '%3437%' or m.model like '%3437%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017796039581299 -- 26-04-17 14:00:52[匡超-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.024327039718628 -- 26-04-17 14:01: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 '%3690%' OR m.material_no like '%3690%' or m.model like '%3690%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016101121902466 -- 26-04-17 14:27:26 -- /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.0079271793365479 -- 26-04-17 14:27:26[陈锦-1032] -- /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.029113054275513 -- 26-04-17 14:27:31[陈锦-1032] -- /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 '%2033%' OR m.material_no like '%2033%' or m.model like '%2033%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029039144515991 -- 26-04-17 14:28:20[陈锦-1032] -- /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 '%3437%' OR m.material_no like '%3437%' or m.model like '%3437%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010105133056641 -- 26-04-17 14:47:23 -- /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.0019381046295166 -- 26-04-17 14:47:23 -- /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.002824068069458 -- 26-04-17 14:47:23 -- /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.0021669864654541 -- 26-04-17 14:47:23[匡超-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.0023279190063477 -- 26-04-17 14:47:23[匡超-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.025157928466797 -- 26-04-17 14:47:27[匡超-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 '%5487%' OR m.material_no like '%5487%' or m.model like '%5487%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014508008956909 -- 26-04-17 14:54:29 -- /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.0016570091247559 -- 26-04-17 14:54:29 -- /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.0025749206542969 -- 26-04-17 14:54:29 -- /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.0018939971923828 -- 26-04-17 14:54:29[马正坤-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.0020279884338379 -- 26-04-17 14:54:29[马正坤-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.026687145233154 -- 26-04-17 14:54:35[马正坤-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 '%13F06%' OR m.material_no like '%13F06%' or m.model like '%13F06%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0091819763183594 -- 26-04-17 16:21:20 -- /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.0017220973968506 -- 26-04-17 16:21:20 -- /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.0026319026947021 -- 26-04-17 16:21:20 -- /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.0019779205322266 -- 26-04-17 16:21:20[陈平-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.012565851211548 -- 26-04-17 16:21:24[陈平-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.023041009902954 -- 26-04-17 16:21:36[陈平-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 '%5590%' OR m.material_no like '%5590%' or m.model like '%5590%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010879039764404 -- 26-04-17 16:54:42 -- /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.0015819072723389 -- 26-04-17 16:54:42 -- /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.0021531581878662 -- 26-04-17 16:54:42 -- /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.0018038749694824 -- 26-04-17 16:54:42[陈平-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.011033058166504 -- 26-04-17 16:54:45[陈平-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.026154041290283 -- 26-04-17 16:54:52[陈平-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 '%5590%' OR m.material_no like '%5590%' or m.model like '%5590%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0096800327301025 -- 26-04-17 16:57:09 -- /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.0018911361694336 -- 26-04-17 16:57:09 -- /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.0028281211853027 -- 26-04-17 16:57:09 -- /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.0020830631256104 -- 26-04-17 16:57:09[匡超-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.0022561550140381 -- 26-04-17 16:57:09[匡超-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.024924039840698 -- 26-04-17 16:57:13[匡超-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 '%5590%' OR m.material_no like '%5590%' or m.model like '%5590%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011649131774902 -- 26-04-17 17:06:23 -- /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.0015430450439453 -- 26-04-17 17:06:23 -- /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.0024769306182861 -- 26-04-17 17:06:23 -- /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='ChenJin' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017738342285156 -- 26-04-17 17:06:23[陈锦-1032] -- /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.019629001617432 -- 26-04-17 17:06:27[陈锦-1032] -- /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.037681102752686 -- 26-04-17 17:06:33[陈锦-1032] -- /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 '%1340%' OR m.material_no like '%1340%' or m.model like '%1340%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026224136352539 -- 26-04-17 17:06:41[陈锦-1032] -- /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 '%11340%' OR m.material_no like '%11340%' or m.model like '%11340%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017524003982544 -- 26-04-17 18:11: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.002100944519043 -- 26-04-17 18:11: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.003026008605957 -- 26-04-17 18:11:46 -- /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.0023360252380371 -- 26-04-17 18:11:46[马正坤-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.0025131702423096 -- 26-04-17 18:11:46[马正坤-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.025825023651123 -- 26-04-17 18:11:51[马正坤-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 '%1845%' OR m.material_no like '%1845%' or m.model like '%1845%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023508071899414 -- 26-04-17 18:36:40[马正坤-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 '%4240%' OR m.material_no like '%4240%' or m.model like '%4240%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0071480274200439 -- 26-04-17 18:43:34 -- /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.0014281272888184 -- 26-04-17 18:43:34 -- /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.0019690990447998 -- 26-04-17 18:43:34 -- /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='aShenYiYangDeNvWang' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017249584197998 -- 26-04-17 18:43:34[申彩连-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.001945972442627 -- 26-04-17 18:43:34[申彩连-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.0013978481292725 -- 26-04-17 18:43:34[申彩连-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.0024821758270264 -- 26-04-17 18:43:34[申彩连-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.0018138885498047 -- 26-04-17 18:43:34[申彩连-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.037483930587769 -- 26-04-17 18:43:35[申彩连-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 >= '2026/04/10' AND o.order_date <= '2026/04/17 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010755062103271 -- 26-04-17 18:43:36[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=1024473&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 = '1024473 ' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017745971679688 -- 26-04-17 18:43:48[申彩连-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 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01042103767395 -- 26-04-17 18:43:50[申彩连-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.021849155426025 -- 26-04-17 18:43:51[申彩连-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 >= '2026/04/10' AND o.order_date <= '2026/04/17 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02876091003418 -- 26-04-17 18:45:57[马正坤-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 '%7556%' OR m.material_no like '%7556%' or m.model like '%7556%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.042360067367554 -- 26-04-17 18:48:36[马正坤-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 '%0778%' OR m.material_no like '%0778%' or m.model like '%0778%') group by l.lot_id,m.material_id limit 0,100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012706995010376 -- 26-04-17 19:11:07[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=1024392&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 = '1024392 ' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010901927947998 -- 26-04-17 19:11:33[申彩连-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 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012434005737305 -- 26-04-17 19:11:35[申彩连-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.028094053268433 -- 26-04-17 19:11:36[申彩连-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 >= '2026/04/10' AND o.order_date <= '2026/04/17 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010169982910156 -- 26-04-17 19:11:44[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=1024349&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 = '1024349 ' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0095720291137695 -- 26-04-17 19:12:08[申彩连-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 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0075509548187256 -- 26-04-17 19:12:09[申彩连-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.03571891784668 -- 26-04-17 19:12: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 or op.outpkg_id is null) AND o.order_date >= '2026/04/10' AND o.order_date <= '2026/04/17 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0094130039215088 -- 26-04-17 19:12:18[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=1024350&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 = '1024350 ' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010217905044556 -- 26-04-17 19:12:43[申彩连-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 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0092699527740479 -- 26-04-17 19:12:46[申彩连-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.024327039718628 -- 26-04-17 19:12: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 or op.outpkg_id is null) AND o.order_date >= '2026/04/10' AND o.order_date <= '2026/04/17 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0099139213562012 -- 26-04-17 19:20:22[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=1024353&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 = '1024353 ' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016870021820068 -- 26-04-17 19:20:41[申彩连-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 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.009019136428833 -- 26-04-17 19:20:45[申彩连-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 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012259006500244 -- 26-04-17 19:20:46[申彩连-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.020655870437622 -- 26-04-17 19:20:47[申彩连-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 >= '2026/04/10' AND o.order_date <= '2026/04/17 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0083529949188232 -- 26-04-17 19:20:48[申彩连-365] -- /buz/wh/index.php/whmgmt/outTally_edit?order_id=1024352&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 = '1024352 ' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013154983520508 -- 26-04-17 19:21: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 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024115085601807 -- 26-04-17 19:21:17[申彩连-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 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022104024887085 -- 26-04-17 19:21:17[申彩连-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.023991107940674 -- 26-04-17 19:21:18[申彩连-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 >= '2026/04/10' AND o.order_date <= '2026/04/17 23:59:59 ' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------