Using index condition; Using where; Using filesort
Query5:SELECT sid,aid,name,subname,avgsort,reviews,thumb FROM modoer_subject WHERE city_id IN ('0','8440') AND pid = '281' AND status = '1' ORDER BY finer DESC LIMIT 0, 12
Query7:SELECT sid,aid,name,subname,avgsort,reviews,thumb FROM modoer_subject WHERE city_id IN ('0','8440') AND pid = '34' AND status = '1' ORDER BY finer DESC LIMIT 0, 12
Query9:SELECT sid,aid,name,subname,avgsort,reviews,thumb FROM modoer_subject WHERE city_id IN ('0','8440') AND pid = '669' AND status = '1' ORDER BY finer DESC LIMIT 0, 12
Query11:SELECT sid,aid,name,subname,avgsort,reviews,thumb FROM modoer_subject WHERE city_id IN ('0','8440') AND pid = '258' AND status = '1' ORDER BY finer DESC LIMIT 0, 12
Query13:SELECT sid,aid,name,subname,avgsort,reviews,thumb FROM modoer_subject WHERE city_id IN ('0','8440') AND pid = '306' AND status = '1' ORDER BY finer DESC LIMIT 0, 12
Query15:SELECT sid,aid,name,subname,avgsort,reviews,thumb FROM modoer_subject WHERE city_id IN ('0','8440') AND pid = '38' AND status = '1' ORDER BY finer DESC LIMIT 0, 12
Query17:SELECT sid,aid,name,subname,avgsort,reviews,thumb FROM modoer_subject WHERE city_id IN ('0','8440') AND pid = '740' AND status = '1' ORDER BY finer DESC LIMIT 0, 12
Query19:SELECT sid,aid,name,subname,avgsort,reviews,thumb FROM modoer_subject WHERE city_id IN ('0','8440') AND pid = '119' AND status = '1' ORDER BY finer DESC LIMIT 0, 12
Query21:SELECT sid,aid,name,subname,avgsort,reviews,thumb FROM modoer_subject WHERE city_id IN ('0','8440') AND pid = '1' AND status = '1' ORDER BY finer DESC LIMIT 0, 12