Query1:SELECT * FROM modoer_dbcache WHERE cache_key IN ('comm_dbcache_expire','comm_task_nexttime','comm_session_expire','comm_session_online')
Time:0.002380
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 = 'f1052eb83e91b049599fcc9906207d41' LIMIT 0, 1
Time:0.005064
id
select_type
table
partitions
type
possible_keys
key
key_len
ref
rows
filtered
Extra
1
SIMPLE
modoer_session
const
uniq
uniq
96
const
1
100.00
Query3:SELECT keyword FROM modoer_search_cache WHERE city_id IN (0,7403) ORDER BY dateline DESC LIMIT 0,3
Time:0.003485
id
select_type
table
partitions
type
possible_keys
key
key_len
ref
rows
filtered
Extra
1
SIMPLE
modoer_search_cache
ALL
2411
20.00
Using where; Using filesort
Query4:SELECT * FROM modoer_category WHERE pid = '745'
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
4
100.00
Query5:SELECT * FROM modoer_category WHERE pid = '747'
Time:0.002342
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
Query6:SELECT * FROM modoer_category WHERE pid = '754'
Time:0.002264
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 = '769'
Time:0.002328
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 = '871'
Time:0.002255
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 name,subname,sid,thumb FROM modoer_subject WHERE status=1 and catid IN (747,754,769,871,745) AND city_id IN (0,7403) ORDER BY finer DESC LIMIT 0,4
Using index condition; Using where; Using filesort
Query10:SELECT * FROM modoer_category WHERE pid = '704'
Time:0.002630
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.002267
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.002785
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.002269
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.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
Query15:SELECT name,subname,sid,thumb FROM modoer_subject WHERE status=1 and catid IN (765,766,767,768,704) AND city_id IN (0,7403) ORDER BY finer DESC LIMIT 0,4
Using index condition; Using where; Using filesort
Query16:SELECT * FROM modoer_category WHERE pid = '282'
Time:0.002403
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
Query17:SELECT * FROM modoer_category WHERE pid = '776'
Time:0.002291
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 = '777'
Time:0.002314
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 = '778'
Time:0.002313
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 = '779'
Time:0.002258
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 = '780'
Time:0.002312
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 = '781'
Time:0.002535
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 = '782'
Time:0.002260
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 = '783'
Time:0.002276
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 = '784'
Time:0.002318
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 = '785'
Time:0.002318
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 = '786'
Time:0.002304
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 = '787'
Time:0.002275
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 = '788'
Time:0.002300
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 = '789'
Time:0.002286
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 = '790'
Time:0.002829
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 = '791'
Time:0.002267
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 = '792'
Time:0.002330
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 = '793'
Time:0.002265
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 = '810'
Time:0.002563
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 = '811'
Time:0.002217
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 name,subname,sid,thumb FROM modoer_subject WHERE status=1 and catid IN (776,777,778,779,780,781,782,783,784,785,786,787,788,789,790,791,792,793,810,811,282) AND city_id IN (0,7403) ORDER BY finer DESC LIMIT 0,4
Using index condition; Using where; Using filesort
Query38:SELECT * FROM modoer_category WHERE pid = '752'
Time:0.002286
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
Query39:SELECT * FROM modoer_category WHERE pid = '875'
Time:0.002242
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 = '876'
Time:0.002275
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
Query41:SELECT * FROM modoer_category WHERE pid = '877'
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
Query42:SELECT name,subname,sid,thumb FROM modoer_subject WHERE status=1 and catid IN (875,876,877,752) AND city_id IN (0,7403) ORDER BY finer DESC LIMIT 0,4
Using index condition; Using where; Using filesort
Query43:SELECT * FROM modoer_category WHERE pid = '750'
Time:0.002253
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
Query44:SELECT * FROM modoer_category WHERE pid = '770'
Time:0.002198
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 = '771'
Time:0.002234
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 = '772'
Time:0.002232
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 = '773'
Time:0.002234
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 = '774'
Time:0.002270
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 = '775'
Time:0.002236
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 = '806'
Time:0.002238
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 = '874'
Time:0.002257
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 name,subname,sid,thumb FROM modoer_subject WHERE status=1 and catid IN (770,771,772,773,774,775,806,874,750) AND city_id IN (0,7403) ORDER BY finer DESC LIMIT 0,4
Using index condition; Using where; Using filesort
Query53:SELECT * FROM modoer_category WHERE pid = '755'
Time:0.002331
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.002252
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.002412
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.002359
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 name,subname,sid,thumb FROM modoer_subject WHERE status=1 and catid IN (756,757,758,755) AND city_id IN (0,7403) ORDER BY finer DESC LIMIT 0,4
Using index condition; Using where; Using filesort
Query61:SELECT * FROM modoer_adv_list WHERE apid = '22' AND city_id IN ('0','7403') AND enabled = 'Y' AND begintime<='1775664000' AND ( endtime >= 1775664000 OR endtime = 0 ) ORDER BY listorder LIMIT 0, 10
Time:0.002341
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
Query62:SELECT * FROM modoer_adv_list WHERE apid = '2' AND city_id IN ('0','7403') AND enabled = 'Y' AND begintime<='1775664000' AND ( endtime >= 1775664000 OR endtime = 0 ) ORDER BY listorder LIMIT 0, 10
Time:0.002292
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
Query63:SELECT articleid,subject,catid,thumb,picture FROM modoer_articles WHERE city_id IN (0,7403) AND att=1 AND status=1 AND havepic=1 ORDER BY dateline DESC LIMIT 0,1
Query64:SELECT articleid,subject,catid,thumb,picture FROM modoer_articles WHERE city_id IN (0,7403) AND att=1 AND status=1 AND havepic=1 ORDER BY dateline DESC LIMIT 1,5
Query65:SELECT name,subname,sid,thumb,description,avgsort,pageviews FROM modoer_subject WHERE status=1 and pid = 38 AND city_id IN (0,7403) ORDER BY addtime DESC LIMIT 0,3
Query66: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','7403') AND a.status = '1' LIMIT 0, 10
Query67: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','7403') AND a.status = '1' LIMIT 0, 10
Query68: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','7403') AND a.status = '1' LIMIT 0, 10
Query69: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','7403') AND a.status = '1' LIMIT 0, 10
Query70: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','7403') AND a.status = '1' LIMIT 0, 10
Query71: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','7403') AND a.status = '1' LIMIT 0, 10
Query72: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','7403') AND a.status = '1' LIMIT 0, 10
Query73: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','7403') AND a.status = '1' LIMIT 0, 10
Query74:SELECT * FROM modoer_tags WHERE city_id IN ('0','7403') AND closed = '0' ORDER BY dateline DESC LIMIT 0, 60
Time:0.004073
id
select_type
table
partitions
type
possible_keys
key
key_len
ref
rows
filtered
Extra
1
SIMPLE
modoer_tags
ALL
closed
9006
20.00
Using where; Using filesort
Query75:SELECT title,link,logo,des FROM modoer_mylinks WHERE ischeck = '1' AND logo != '' AND city_id IN ('0','7403') ORDER BY displayorder LIMIT 0, 100