Query1:SELECT * FROM modoer_dbcache WHERE cache_key IN ('comm_dbcache_expire','comm_task_nexttime','comm_session_expire','comm_session_online')
Time:0.002079
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 = 'e8a10f2c821d3576842eed08e280b99e' LIMIT 0, 1
Time:0.002067
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='e8a10f2c821d3576842eed08e280b99e',uid='0',ip_address='104.167.77.90',content='',last_time='1775693551',last_url='/ask/3650.html',is_mobile='0',user_agent='Mozilla/5.0 (Windows NT 10.0; WOW64; Trident/7.0; rv:11.0) like Gecko'
Time:0.002838
Query4:SELECT *,m.groupid FROM modoer_asks a left join modoer_members m ON (a.uid = m.uid) WHERE askid = '3650' LIMIT 0, 1
Time:0.002269
id
select_type
table
partitions
type
possible_keys
key
key_len
ref
rows
filtered
Extra
1
SIMPLE
a
const
PRIMARY
PRIMARY
4
const
1
100.00
Exec 5:UPDATE modoer_asks SET views=views+'1' WHERE askid = '3650'
Time:0.003001
Query6:SELECT * FROM modoer_subject WHERE sid = '13514' LIMIT 0, 1
Time:0.002141
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
Query7:SELECT * FROM modoer_subject_my WHERE sid = '13514' LIMIT 0, 1
Time:0.002115
id
select_type
table
partitions
type
possible_keys
key
key_len
ref
rows
filtered
Extra
1
SIMPLE
modoer_subject_my
const
PRIMARY
PRIMARY
3
const
1
100.00
Query8:SELECT * FROM modoer_subjectgrade
Time:0.002047
id
select_type
table
partitions
type
possible_keys
key
key_len
ref
rows
filtered
Extra
1
SIMPLE
modoer_subjectgrade
ALL
1
100.00
Query9:SELECT * FROM modoer_category WHERE pid = '745'
Time:0.002214
id
select_type
table
partitions
type
possible_keys
key
key_len
ref
rows
filtered
Extra
1
SIMPLE
modoer_category
ref
pid
pid
3
const
4
100.00
Query10:SELECT * FROM modoer_category WHERE pid = '747'
Time:0.002010
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
Query11:SELECT * FROM modoer_category WHERE pid = '754'
Time:0.002015
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
Query12:SELECT * FROM modoer_category WHERE pid = '769'
Time:0.001974
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
Query13:SELECT * FROM modoer_category WHERE pid = '871'
Time:0.002024
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
Query14:SELECT * FROM modoer_category WHERE pid = '704'
Time:0.002035
id
select_type
table
partitions
type
possible_keys
key
key_len
ref
rows
filtered
Extra
1
SIMPLE
modoer_category
ref
pid
pid
3
const
4
100.00
Query15:SELECT * FROM modoer_category WHERE pid = '765'
Time:0.002018
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
Query16:SELECT * FROM modoer_category WHERE pid = '766'
Time:0.002108
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
Query17:SELECT * FROM modoer_category WHERE pid = '767'
Time:0.002025
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
Query18:SELECT * FROM modoer_category WHERE pid = '768'
Time:0.002117
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
Query19:SELECT * FROM modoer_category WHERE pid = '282'
Time:0.002150
id
select_type
table
partitions
type
possible_keys
key
key_len
ref
rows
filtered
Extra
1
SIMPLE
modoer_category
ref
pid
pid
3
const
20
100.00
Query20:SELECT * FROM modoer_category WHERE pid = '776'
Time:0.002151
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
Query21:SELECT * FROM modoer_category WHERE pid = '777'
Time:0.002030
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
Query22:SELECT * FROM modoer_category WHERE pid = '778'
Time:0.002129
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
Query23:SELECT * FROM modoer_category WHERE pid = '779'
Time:0.002127
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
Query24:SELECT * FROM modoer_category WHERE pid = '780'
Time:0.002090
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
Query25:SELECT * FROM modoer_category WHERE pid = '781'
Time:0.002010
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
Query26:SELECT * FROM modoer_category WHERE pid = '782'
Time:0.001993
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
Query27:SELECT * FROM modoer_category WHERE pid = '783'
Time:0.002011
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
Query28:SELECT * FROM modoer_category WHERE pid = '784'
Time:0.002035
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
Query29:SELECT * FROM modoer_category WHERE pid = '785'
Time:0.002059
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
Query30:SELECT * FROM modoer_category WHERE pid = '786'
Time:0.002049
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
Query31:SELECT * FROM modoer_category WHERE pid = '787'
Time:0.002023
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
Query32:SELECT * FROM modoer_category WHERE pid = '788'
Time:0.002004
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
Query33:SELECT * FROM modoer_category WHERE pid = '789'
Time:0.001975
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
Query34:SELECT * FROM modoer_category WHERE pid = '790'
Time:0.002061
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
Query35:SELECT * FROM modoer_category WHERE pid = '791'
Time:0.002014
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
Query36:SELECT * FROM modoer_category WHERE pid = '792'
Time:0.002088
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
Query37:SELECT * FROM modoer_category WHERE pid = '793'
Time:0.002076
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
Query38:SELECT * FROM modoer_category WHERE pid = '810'
Time:0.002057
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
Query39:SELECT * FROM modoer_category WHERE pid = '811'
Time:0.002058
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
Query40:SELECT * FROM modoer_category WHERE pid = '752'
Time:0.002165
id
select_type
table
partitions
type
possible_keys
key
key_len
ref
rows
filtered
Extra
1
SIMPLE
modoer_category
ref
pid
pid
3
const
3
100.00
Query41:SELECT * FROM modoer_category WHERE pid = '875'
Time:0.002016
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
Query42:SELECT * FROM modoer_category WHERE pid = '876'
Time:0.002056
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
Query43:SELECT * FROM modoer_category WHERE pid = '877'
Time:0.001961
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
Query44:SELECT * FROM modoer_category WHERE pid = '750'
Time:0.002151
id
select_type
table
partitions
type
possible_keys
key
key_len
ref
rows
filtered
Extra
1
SIMPLE
modoer_category
ref
pid
pid
3
const
8
100.00
Query45:SELECT * FROM modoer_category WHERE pid = '770'
Time:0.002031
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
Query46:SELECT * FROM modoer_category WHERE pid = '771'
Time:0.001990
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
Query47:SELECT * FROM modoer_category WHERE pid = '772'
Time:0.002089
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
Query48:SELECT * FROM modoer_category WHERE pid = '773'
Time:0.002026
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
Query49:SELECT * FROM modoer_category WHERE pid = '774'
Time:0.001963
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
Query50:SELECT * FROM modoer_category WHERE pid = '775'
Time:0.001983
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
Query51:SELECT * FROM modoer_category WHERE pid = '806'
Time:0.001984
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
Query52:SELECT * FROM modoer_category WHERE pid = '874'
Time:0.001986
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
Query53:SELECT * FROM modoer_category WHERE pid = '755'
Time:0.002056
id
select_type
table
partitions
type
possible_keys
key
key_len
ref
rows
filtered
Extra
1
SIMPLE
modoer_category
ref
pid
pid
3
const
3
100.00
Query54:SELECT * FROM modoer_category WHERE pid = '756'
Time:0.001973
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
Query55:SELECT * FROM modoer_category WHERE pid = '757'
Time:0.001981
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
Query56:SELECT * FROM modoer_category WHERE pid = '758'
Time:0.001979
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
Query57:SELECT * FROM modoer_category WHERE pid = '726'
Time:0.001956
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
Query58:SELECT * FROM modoer_category WHERE pid = '794'
Time:0.001997
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
Query59:SELECT askid,subject,expiredtime,dateline FROM modoer_asks WHERE success=0 AND status=1 AND expiredtime>1775693551 AND city_id IN (0,2943) ORDER BY dateline DESC LIMIT 0,8