Query1:SELECT * FROM modoer_dbcache WHERE cache_key IN ('comm_dbcache_expire','comm_task_nexttime','comm_session_expire','comm_session_online')
Time:0.002321
id
select_type
table
partitions
type
possible_keys
key
key_len
ref
rows
filtered
Extra
1
SIMPLE
modoer_dbcache
range
PRIMARY
PRIMARY
600
4
100.00
Using where
Query2:SELECT * FROM modoer_session WHERE uniq = '36a2f99b14950f3d5b783834c06a7497' LIMIT 0, 1
Time:0.002277
id
select_type
table
partitions
type
possible_keys
key
key_len
ref
rows
filtered
Extra
1
SIMPLE
no matching row in const table
Exec 3:INSERT modoer_session SET uniq='36a2f99b14950f3d5b783834c06a7497',uid='0',ip_address='17.22.237.187',content='',last_time='1775844790',last_url='/nanning/gov/9401.html',is_mobile='0',user_agent='Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.4 Safari/605.1.15 (Applebot/0.1; +http://www.apple.com/go/applebot)'
Time:0.003738
Query4:SELECT * FROM modoer_subject WHERE sid = '9401' LIMIT 0, 1
Time:0.002355
id
select_type
table
partitions
type
possible_keys
key
key_len
ref
rows
filtered
Extra
1
SIMPLE
modoer_subject
const
PRIMARY
PRIMARY
3
const
1
100.00
Query5:SELECT * FROM modoer_subject_hangye WHERE sid = '9401' LIMIT 0, 1
Time:0.002364
id
select_type
table
partitions
type
possible_keys
key
key_len
ref
rows
filtered
Extra
1
SIMPLE
modoer_subject_hangye
const
PRIMARY,idx_sid
PRIMARY
3
const
1
100.00
Query6:SELECT * FROM modoer_subjectgrade
Time:0.002293
id
select_type
table
partitions
type
possible_keys
key
key_len
ref
rows
filtered
Extra
1
SIMPLE
modoer_subjectgrade
ALL
1
100.00
Exec 7:UPDATE modoer_subject SET pageviews=pageviews+'1' WHERE sid = '9401'
Time:0.002970
Query8:SELECT * FROM modoer_mysubject WHERE sid = '9401' LIMIT 0, 1
Time:0.002258
id
select_type
table
partitions
type
possible_keys
key
key_len
ref
rows
filtered
Extra
1
SIMPLE
modoer_mysubject
ref
sid
sid
3
const
1
100.00
Query9:SELECT * FROM modoer_subjectgourd WHERE sid = '9401' ORDER BY id DESC LIMIT 0, 1
Time:0.002302
id
select_type
table
partitions
type
possible_keys
key
key_len
ref
rows
filtered
Extra
1
SIMPLE
modoer_subjectgourd
ref
sid
sid
3
const
1
100.00
Using filesort
Query10:SELECT * FROM modoer_adv_list WHERE apid = '2' AND city_id IN ('0','4002') AND enabled = 'Y' AND begintime<='1775836800' AND ( endtime >= 1775836800 OR endtime = 0 ) ORDER BY listorder LIMIT 0, 10
Time:0.002424
id
select_type
table
partitions
type
possible_keys
key
key_len
ref
rows
filtered
Extra
1
SIMPLE
modoer_adv_list
ALL
13
7.69
Using where; Using filesort
Query11:SELECT * FROM modoer_subject s LEFT JOIN modoer_subject_baike sf ON (s.sid = sf.sid) WHERE s.sid IN ('5921','6720','7082','7472','8186','8222') AND s.status = '1' LIMIT 0, 10
Time:0.009095
id
select_type
table
partitions
type
possible_keys
key
key_len
ref
rows
filtered
Extra
1
SIMPLE
s
range
PRIMARY,addtime,finer,idx_status_sid,idx_status
PRIMARY
3
6
50.00
Using where
Query12:SELECT articleid,catid,subject,author,comments,digg,a.dateline FROM modoer_subjectlink sl JOIN modoer_articles a ON (sl.flagid = a.articleid) WHERE sl.sid = '9401' AND sl.flag = 'article' AND a.status = '1' ORDER BY sl.dateline DESC LIMIT 0, 10
Time:0.002526
id
select_type
table
partitions
type
possible_keys
key
key_len
ref
rows
filtered
Extra
1
SIMPLE
sl
ref
flagid,sid
sid
96
const,const
1
100.00
Backward index scan
Query13:SELECT * FROM modoer_subject WHERE pid=119 AND aid=4003 AND sid!=9401 ORDER BY reviews DESC LIMIT 0,3
Time:0.002634
id
select_type
table
partitions
type
possible_keys
key
key_len
ref
rows
filtered
Extra
1
SIMPLE
modoer_subject
ref
PRIMARY,list_aid,pid,aid,list_city
list_aid
4
const,const
14
58.28
Using index condition; Using filesort
Query14:SELECT name,subname,finer,sid,thumb,avgsort,pageviews FROM modoer_subject WHERE status=1 and pid = 1 AND city_id IN (0,4002) ORDER BY addtime DESC LIMIT 0,3