Query5:SELECT s.sid,pid,catid,domain,name,avgsort,sort1,sort2,sort3,sort4,sort5,sort6,sort7,sort8,best,finer,pageviews,reviews,pictures,favorites,thumb,aid,map_lat,map_lng,c_jiguan,subname,description FROM modoer_subject s LEFT JOIN modoer_subject_yuqi sf ON (s.sid = sf.sid) WHERE status = '1' AND pid = '306' AND city_id = '3960' ORDER BY finer DESC LIMIT 0, 20
Query6:SELECT r.rid, r.id, r.content, r.uid, r.username
FROM modoer_review r
WHERE r.id IN (19172,74530,74293,74292,74291,74290,74289,69813,26275,26107,19203,19200,19197,19194,19187,19178,18163,19149,19137,19124)
AND r.status = 1
AND (
SELECT COUNT(*)
FROM modoer_review r2
WHERE r2.id = r.id
AND r2.status = 1
AND r2.posttime >= r.posttime
) <= 4
ORDER BY r.id, r.posttime DESC
Time:0.002575
id
select_type
table
partitions
type
possible_keys
key
key_len
ref
rows
filtered
Extra
1
PRIMARY
r
ALL
sid
1
100.00
Using where; Using filesort
Query7:SELECT * FROM modoer_category WHERE pid = '39'
Time:0.002315
id
select_type
table
partitions
type
possible_keys
key
key_len
ref
rows
filtered
Extra
1
SIMPLE
modoer_category
ref
pid
pid
3
const
1
100.00
Query8:SELECT name,subname,sid,thumb FROM modoer_subject WHERE status=1 and catid IN (39) AND city_id IN (0,3960) ORDER BY finer DESC LIMIT 0,4
