Query1:SELECT * FROM modoer_dbcache WHERE cache_key IN ('comm_dbcache_expire','comm_task_nexttime','comm_session_expire','comm_session_online')
Time:0.002251
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 = '9b702aa39ab933db38a22bec96057149' LIMIT 0, 1
Time:0.002240
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='9b702aa39ab933db38a22bec96057149',uid='0',ip_address='104.167.77.90',content='',last_time='1775844251',last_url='/ask/list-catid-20-key-zero.html',is_mobile='0',user_agent='Mozilla/5.0 (Windows NT 10.0; WOW64; Trident/7.0; rv:11.0) like Gecko'
Time:0.003231
Query4:SELECT COUNT(*) FROM modoer_asks WHERE catid = '20' AND city_id = '_NULL_CITYID_' AND status = '1' AND replies = '0'
Time:0.002344
id
select_type
table
partitions
type
possible_keys
key
key_len
ref
rows
filtered
Extra
1
SIMPLE
modoer_asks
ref
disorder
disorder
4
const,const
36
1.00
Using where
Query5:SELECT s.name,s.subname,s.sid,s.description,s.thumb,st.tel,st.c_youjian,st.address FROM modoer_subject s left join modoer_subject_youhua st on(s.sid=st.sid) WHERE s.status=1 and s.finer=9 AND s.pid=258 AND city_id IN (0,2943) ORDER BY s.addtime DESC LIMIT 0,3