Query1:SELECT * FROM modoer_dbcache WHERE cache_key IN ('comm_dbcache_expire','comm_task_nexttime','comm_session_expire','comm_session_online')
Time:0.002235
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 = '18b6675427302001f1470078322c0a1f' LIMIT 0, 1
Time:0.002249
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='18b6675427302001f1470078322c0a1f',uid='0',ip_address='216.73.216.38',content='',last_time='1775682807',last_url='/index-city.html',is_mobile='0',user_agent='Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
Time:0.002927
Query4:SELECT aid,name,province_name,province_initial FROM modoer_area WHERE enabled = '1' ORDER BY province_initial,listorder
Time:0.010331
id
select_type
table
partitions
type
possible_keys
key
key_len
ref
rows
filtered
Extra
1
SIMPLE
modoer_area
ALL
3803
10.00
Using where; Using filesort
Query5:SELECT * FROM modoer_category WHERE pid = '745'
Time:0.002278
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
Query6:SELECT * FROM modoer_category WHERE pid = '747'
Time:0.004254
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
Query7:SELECT * FROM modoer_category WHERE pid = '754'
Time:0.008265
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
Query8:SELECT * FROM modoer_category WHERE pid = '769'
Time:0.002179
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 = '871'
Time:0.002641
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
Query10:SELECT * FROM modoer_category WHERE pid = '704'
Time:0.002517
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
Query11:SELECT * FROM modoer_category WHERE pid = '765'
Time:0.002364
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 = '766'
Time:0.002926
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 = '767'
Time:0.002426
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 = '768'
Time:0.009876
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 = '282'
Time:0.002966
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
Query16:SELECT * FROM modoer_category WHERE pid = '776'
Time:0.003247
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 = '777'
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
Query18:SELECT * FROM modoer_category WHERE pid = '778'
Time:0.002273
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 = '779'
Time:0.003216
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 = '780'
Time:0.002415
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 = '781'
Time:0.002251
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 = '782'
Time:0.003245
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 = '783'
Time:0.003253
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 = '784'
Time:0.002211
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 = '785'
Time:0.002652
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 = '786'
Time:0.002243
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 = '787'
Time:0.002246
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 = '788'
Time:0.007276
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 = '789'
Time:0.002576
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 = '790'
Time:0.003531
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 = '791'
Time:0.002271
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 = '792'
Time:0.002235
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 = '793'
Time:0.002254
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 = '810'
Time:0.002281
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 = '811'
Time:0.002624
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 = '752'
Time:0.002277
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
Query37:SELECT * FROM modoer_category WHERE pid = '875'
Time:0.002216
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 = '876'
Time:0.002296
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 = '877'
Time:0.002303
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 = '750'
Time:0.003656
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
Query41:SELECT * FROM modoer_category WHERE pid = '770'
Time:0.002391
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 = '771'
Time:0.005016
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 = '772'
Time:0.002431
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 = '773'
Time:0.002498
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
Query45:SELECT * FROM modoer_category WHERE pid = '774'
Time:0.002469
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 = '775'
Time:0.002436
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 = '806'
Time:0.002461
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 = '874'
Time:0.002296
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 = '755'
Time:0.002279
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
Query50:SELECT * FROM modoer_category WHERE pid = '756'
Time:0.002191
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 = '757'
Time:0.002222
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 = '758'
Time:0.002212
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 = '726'
Time:0.002706
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
Query54:SELECT * FROM modoer_category WHERE pid = '794'
Time:0.002274
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 articleid,uid,author,catid,subject,thumb,picture,introduce,dateline FROM modoer_articles a WHERE catid IN ('134','72','78','113','88','79','174','122','123','77','167','124','133','114','172','168','176','177','73') AND city_id IN ('0','2943') AND a.status = '1' LIMIT 0, 10
Query56:SELECT articleid,uid,author,catid,subject,thumb,picture,introduce,dateline FROM modoer_articles a WHERE catid IN ('156','169','170','173','171','157') AND city_id IN ('0','2943') AND a.status = '1' LIMIT 0, 10
Query57:SELECT articleid,uid,author,catid,subject,thumb,picture,introduce,dateline FROM modoer_articles a WHERE catid IN ('110','93','109') AND city_id IN ('0','2943') AND a.status = '1' LIMIT 0, 10
Query58:SELECT articleid,uid,author,catid,subject,thumb,picture,introduce,dateline FROM modoer_articles a WHERE catid IN ('89','175','160','162','163') AND city_id IN ('0','2943') AND a.status = '1' LIMIT 0, 10
Query59:SELECT articleid,uid,author,catid,subject,thumb,picture,introduce,dateline FROM modoer_articles a WHERE catid IN ('143','164','141','145') AND city_id IN ('0','2943') AND a.status = '1' LIMIT 0, 10
Query60:SELECT articleid,uid,author,catid,subject,thumb,picture,introduce,dateline FROM modoer_articles a WHERE catid IN ('90','129','130') AND city_id IN ('0','2943') AND a.status = '1' LIMIT 0, 10
Query61:SELECT articleid,uid,author,catid,subject,thumb,picture,introduce,dateline FROM modoer_articles a WHERE catid IN ('31','39','32','40') AND city_id IN ('0','2943') AND a.status = '1' LIMIT 0, 10
Query62:SELECT articleid,uid,author,catid,subject,thumb,picture,introduce,dateline FROM modoer_articles a WHERE catid IN ('99','14','26','22','15','100','153','96','165') AND city_id IN ('0','2943') AND a.status = '1' LIMIT 0, 10