|
yisildeai 发表于 2012-3-28 13:19 ![]()
mysql> show create table u_resale \G;
*************************** 1. row *********************** ...
ALTER TABLE recommend_houses_his DROP INDEX idx_sid_ws_hid_type;
ALTER TABLE recommend_houses_his ADD INDEX idx_sid_ws_type_hid(`source_id`,`website`,`type`,`houseid`);
EXPLAIN
SELECT r.id,r.estatename estatename,r.floor,r.totalfloor,r.title,r.phototiny,r.completion, r.area,r.price ,r.cityid,r.flattype,r.photobrowse,r.sourceid
FROM u_resale r INNER JOIN recommend_houses_his his
WHERE r.cityid=5633 AND r.photobrowse is not null AND r.photobrowse !=''
AND his.website='calculator.index' AND his.localid=5633 AND his.type=1
AND his.source_id=1 AND his.houseid<>r.id
ORDER BY r.id desc \G
|
|