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 = '7456' 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 (21996,21997,21998)
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.002452
id
select_type
table
partitions
type
possible_keys
key
key_len
ref
rows
filtered
Extra
1
PRIMARY
r
range
sid
sid
4
3
100.00
Using index condition; Using where; Using filesort
Query6:SELECT * FROM modoer_category WHERE pid = '39'
Time:0.002357
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,7456) ORDER BY finer DESC LIMIT 0,4
