Query1:SELECT * FROM modoer_dbcache WHERE cache_key IN ('comm_dbcache_expire','comm_task_nexttime','comm_session_expire','comm_session_online')
Time:0.002234
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 = 'e9cc418ad953a2730f6976d4fb387c85' LIMIT 0, 1
Time:0.002144
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='e9cc418ad953a2730f6976d4fb387c85',uid='0',ip_address='104.167.77.90',content='',last_time='1775688437',last_url='/baoding/gov/list-catid-742-aid-4077.html',is_mobile='0',user_agent='Mozilla/5.0 (Windows NT 10.0; WOW64; Trident/7.0; rv:11.0) like Gecko'
Time:0.002894
Query4:SELECT * FROM modoer_review_opt WHERE gid = '0' AND enable = '1' ORDER BY listorder,id
Time:0.002240
id
select_type
table
partitions
type
possible_keys
key
key_len
ref
rows
filtered
Extra
1
SIMPLE
modoer_review_opt
ALL
48
2.08
Using where; Using filesort
Query5:SELECT COUNT(*) FROM modoer_subject s WHERE status = '1' AND pid = '740' AND city_id = '2943'
Query6:SELECT s.sid,pid,catid,domain,name,avgsort,sort1,sort2,sort3,sort4,sort5,sort6,sort7,sort8,best,finer,pageviews,reviews,pictures,favorites,thumb,aid,map_lat,map_lng,subname,c_tab,c_fenlei,c_nianx,c_ziben,c_nashui,c_lianxiren,tel FROM modoer_subject s LEFT JOIN modoer_subject_zhr sf ON (s.sid = sf.sid) WHERE status = '1' AND pid = '740' AND city_id = '2943' LIMIT 0, 20
Query7:SELECT r.rid, r.id, r.content, r.uid, r.username
FROM modoer_review r
WHERE r.id IN (10473,10474,10475,10476,10477,10478,10479,10550)
AND r.status = 1
AND (
SELECT COUNT(*)
FROM modoer_review r2
WHERE r2.id = r.id
AND r2.status = 1
AND r2.posttime >= r.posttime
) <= 4
ORDER BY r.id, r.posttime DESC
Time:0.002296
id
select_type
table
partitions
type
possible_keys
key
key_len
ref
rows
filtered
Extra
1
PRIMARY
r
ALL
sid
1
100.00
Using where; Using filesort
Query8:SELECT * FROM modoer_category WHERE pid = '39'
Time:0.002123
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
Query9:SELECT * FROM modoer_category WHERE pid = '59'
Time:0.002160
id
select_type
table
partitions
type
possible_keys
key
key_len
ref
rows
filtered
Extra
1
SIMPLE
modoer_category
ref
pid
pid
3
const
12
100.00
Query10:SELECT * FROM modoer_category WHERE pid = '312'
Time:0.003620
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 = '313'
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
Query12:SELECT * FROM modoer_category WHERE pid = '314'
Time:0.002190
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 = '315'
Time:0.002161
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 = '316'
Time:0.008655
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
Query15:SELECT * FROM modoer_category WHERE pid = '317'
Time:0.002197
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 = '319'
Time:0.002080
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 = '682'
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
Query18:SELECT * FROM modoer_category WHERE pid = '727'
Time:0.003525
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 = '728'
Time:0.003705
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
Query20:SELECT * FROM modoer_category WHERE pid = '729'
Time:0.002184
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 = '749'
Time:0.008483
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 = '54'
Time:0.006290
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 = '193'
Time:0.002248
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 = '653'
Time:0.011908
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 = '63'
Time:0.002305
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 name,subname,sid,thumb FROM modoer_subject WHERE status=1 and catid IN (63) AND city_id IN (0,2943) ORDER BY finer DESC LIMIT 0,4