Query4:SELECT sid,pid,catid,name,subname,reviews,avgsort,pageviews,thumb FROM modoer_subject WHERE pid='119' AND pageviews>0 ORDER BY pageviews DESC LIMIT 0,5
Time:0.005041
id
select_type
table
partitions
type
possible_keys
key
key_len
ref
rows
filtered
Extra
1
SIMPLE
modoer_subject
ref
list_aid,pid,aid,list_city
list_aid
2
const
1236
33.33
Using where; Using filesort
Query5:SELECT catid,pid,name,total FROM modoer_category WHERE pid=119 AND total>0 ORDER BY total DESC LIMIT 0,10