Query4: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,subname,c_lianxiren,c_dianhua,description FROM modoer_subject s LEFT JOIN modoer_subject_shops sf ON (s.sid = sf.sid) WHERE status = '1' AND pid = '1' AND city_id = '8567' ORDER BY finer DESC LIMIT 0, 20
Query5:SELECT r.rid, r.id, r.content, r.uid, r.username
FROM modoer_review r
WHERE r.id IN (6708,8139,8328,22299,22300,22301)
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.002395
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
Query6: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
Query7:SELECT name,subname,sid,thumb FROM modoer_subject WHERE status=1 and catid IN (39) AND city_id IN (0,8567) ORDER BY finer DESC LIMIT 0,4
