如何提高拣货和配送效率

页面:/news/view-3166736/ | 耗时:0.1090 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=3166736 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=3166736 LIMIT 0,1
select * from tbl_Articles_sphinx where id=3166736 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(344705,1115731,1126432,3213547,1081422,1998010,1126618,1115563,258774,257946,1128603,186758,284712,109204,394609,2714794,293746,146589,1132481,1101009,366120,394988,1127381,441388,2774686,236777,143073,140294,1062250,1071507) ORDER BY field (ArticleID,344705,1115731,1126432,3213547,1081422,1998010,1126618,1115563,258774,257946,1128603,186758,284712,109204,394609,2714794,293746,146589,1132481,1101009,366120,394988,1127381,441388,2774686,236777,143073,140294,1062250,1071507)