如何优化库存管理

页面:/news/view-2984795/ | 耗时:0.4822 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=2984795 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=2984795 LIMIT 0,1
select * from tbl_Articles_sphinx where id=2984795 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(3202427,1494420,2379872,1790507,1079307,2139224,1611590,198415,420893,1050207,499007,1372671,1999854,1068264,1093062,1117055,1736896,2152035,1745514,2217448,2738588,1835546,1542757,3004068,1474373,1552030,213561,1657474,1130298,2667807) ORDER BY field (ArticleID,3202427,1494420,2379872,1790507,1079307,2139224,1611590,198415,420893,1050207,499007,1372671,1999854,1068264,1093062,1117055,1736896,2152035,1745514,2217448,2738588,1835546,1542757,3004068,1474373,1552030,213561,1657474,1130298,2667807)