摘要:
傻瓜级的。此sql语句存在于分销王系统中。查阅slow log ,时间设置1s发现很多SELECT r.*, goods_id, bn, name FROM sdb_goods_rate r, sdb_goods WHERE ((goods_2 = goods_id AND goods_1=4799) OR (goods_1 = goods_id AND goods_2 = 4799 AND manual='both')) AND rate > 99;主要是2个表的联立,相当于inner join吧。 条件是 goods_2= xx and goods_1=zzm... 阅读全文