where in 如何优化，是否需要建索引？

Question

SELECT id,name,url,site_id,u_id FROM aa_goods WHERE id in (528264,528825,528833,528996,529986,529997,530029,530289,530487,531611,532236,532417,533926,534975,535615,536062,536720,536996,537213,537387,537529,537721,537730,538594,540320,541781,542048,543248,543253,543895,545450,716705,716737,716748,716880,718013,718494,719050,742358,742750);

在慢日 志中查到这个语句很占时间，如何优化这个mysql语句？

Answer 1

id是主键吗？如果是主键应该不至于慢。 一般where in只建议用在主键，效果应该跟"where id=xx or id=yy or ..."无异

Answer 2

这也会慢吗？数据量有多少？你先explain执行一下；