页面提示：“纳税人必须签名”

SQL History (68)

Connect MySQL
Time:0.016285
Query1:SELECT * FROM modoer_dbcache WHERE cache_key IN ('comm_dbcache_expire','comm_task_nexttime','comm_session_expire','comm_session_online')
Time:0.002046
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 = 'aca1b8044a4504dd1b85ae20ecb39db4' LIMIT 0, 1
Time:0.002042
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 *,m.groupid FROM modoer_asks a left join modoer_members m ON (a.uid = m.uid) WHERE askid = '3573' LIMIT 0, 1
Time:0.003261
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 4:UPDATE modoer_asks SET views=views+'1' WHERE askid = '3573'
Time:0.002985
Query5:SELECT a.*,m.groupid FROM modoer_ask_answer a left join modoer_members m ON (a.uid = m.uid) WHERE askid = '3573' AND bestanswer = '0' AND status = '1' ORDER BY a.dateline DESC LIMIT 0, 20
Time:0.002337
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE a ref dateline,askid dateline 3 const 1 5.00 Using where; Backward index scan
Query6:SELECT * FROM modoer_subject WHERE sid = '11759' LIMIT 0, 1
Time:0.002086
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 = '11759' LIMIT 0, 1
Time:0.008323
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.001996
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.002068
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.001977
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.002068
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.001977
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.001987
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 name,subname,sid,thumb FROM modoer_subject WHERE status=1 and catid IN (747,754,769,871,745) AND city_id IN (0,7175) ORDER BY finer DESC LIMIT 0,4
Time:0.002240

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	modoer_subject		range	catid,catid_2,addtime,finer,tops,idx_status_sid,idx_status	catid_2	2		12	0.42	Using index condition; Using where; Using filesort

Query15:SELECT * FROM modoer_category WHERE pid = '704'
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 4 100.00
Query16:SELECT * FROM modoer_category WHERE pid = '765'
Time:0.002047
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 = '766'
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
Query18:SELECT * FROM modoer_category WHERE pid = '767'
Time:0.002040
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 = '768'
Time:0.001996
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 name,subname,sid,thumb FROM modoer_subject WHERE status=1 and catid IN (765,766,767,768,704) AND city_id IN (0,7175) ORDER BY finer DESC LIMIT 0,4
Time:0.002244

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	modoer_subject		range	catid,catid_2,addtime,finer,tops,idx_status_sid,idx_status	catid_2	2		9	0.56	Using index condition; Using where; Using filesort

Query21:SELECT * FROM modoer_category WHERE pid = '282'
Time:0.002107
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
Query22:SELECT * FROM modoer_category WHERE pid = '776'
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
Query23:SELECT * FROM modoer_category WHERE pid = '777'
Time:0.002045
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 = '778'
Time:0.001966
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 = '779'
Time:0.002096
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 = '780'
Time:0.002034
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 = '781'
Time:0.002027
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 = '782'
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
Query29:SELECT * FROM modoer_category WHERE pid = '783'
Time:0.002048
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 = '784'
Time:0.002128
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 = '785'
Time:0.001982
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 = '786'
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
Query33:SELECT * FROM modoer_category WHERE pid = '787'
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
Query34:SELECT * FROM modoer_category WHERE pid = '788'
Time:0.002033
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 = '789'
Time:0.002043
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 = '790'
Time:0.001971
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 = '791'
Time:0.002078
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 = '792'
Time:0.002009
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 = '793'
Time:0.001982
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 = '810'
Time:0.002019
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 = '811'
Time:0.002013
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 (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,7175) ORDER BY finer DESC LIMIT 0,4
Time:0.002873

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	modoer_subject		range	catid,catid_2,addtime,finer,tops,idx_status_sid,idx_status	catid_2	2		131	0.15	Using index condition; Using where; Using filesort

Query43:SELECT * FROM modoer_category WHERE pid = '752'
Time:0.002124
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
Query44:SELECT * FROM modoer_category WHERE pid = '875'
Time:0.002095
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 = '876'
Time:0.002047
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 = '877'
Time:0.002045
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 name,subname,sid,thumb FROM modoer_subject WHERE status=1 and catid IN (875,876,877,752) AND city_id IN (0,7175) ORDER BY finer DESC LIMIT 0,4
Time:0.002301

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	modoer_subject		range	catid,catid_2,addtime,finer,tops,idx_status_sid,idx_status	catid_2	2		4	1.25	Using index condition; Using where; Using filesort

Query48:SELECT * FROM modoer_category WHERE pid = '750'
Time:0.002112
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
Query49:SELECT * FROM modoer_category WHERE pid = '770'
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
Query50:SELECT * FROM modoer_category WHERE pid = '771'
Time:0.002081
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 = '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
Query52:SELECT * FROM modoer_category WHERE pid = '773'
Time:0.002020
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 = '774'
Time:0.002201
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 = '775'
Time:0.002141
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 = '806'
Time:0.002037
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 = '874'
Time:0.002085
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 (770,771,772,773,774,775,806,874,750) AND city_id IN (0,7175) ORDER BY finer DESC LIMIT 0,4
Time:0.002506

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	modoer_subject		range	catid,catid_2,addtime,finer,tops,idx_status_sid,idx_status	catid_2	2		32	0.16	Using index condition; Using where; Using filesort

Query58:SELECT * FROM modoer_category WHERE pid = '755'
Time:0.002163
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
Query59:SELECT * FROM modoer_category WHERE pid = '756'
Time:0.002044
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
Query60:SELECT * FROM modoer_category WHERE pid = '757'
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
Query61:SELECT * FROM modoer_category WHERE pid = '758'
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
Query62:SELECT name,subname,sid,thumb FROM modoer_subject WHERE status=1 and catid IN (756,757,758,755) AND city_id IN (0,7175) ORDER BY finer DESC LIMIT 0,4
Time:0.002333

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	modoer_subject		range	catid,catid_2,addtime,finer,tops,idx_status_sid,idx_status	catid_2	2		9	0.56	Using index condition; Using where; Using filesort

Query63:SELECT * FROM modoer_category WHERE pid = '726'
Time:0.002071
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
Query64:SELECT * FROM modoer_category WHERE pid = '794'
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
Query65:SELECT name,subname,sid,thumb FROM modoer_subject WHERE status=1 and catid IN (794,726) AND city_id IN (0,7175) ORDER BY finer DESC LIMIT 0,4
Time:0.002276

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	modoer_subject		range	catid,catid_2,addtime,finer,tops,idx_status_sid,idx_status	catid_2	2		5	1.00	Using index condition; Using where; Using filesort

Query66:SELECT askid,subject,expiredtime,dateline FROM modoer_asks WHERE success=0 AND status=1 AND expiredtime>1775688869 AND city_id IN (0,7175) ORDER BY dateline DESC LIMIT 0,8
Time:0.004270
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_asks ALL expiredtime 4037 0.20 Using where; Using filesort
Query67:SELECT articleid,subject,catid,thumb,dateline,digg,comments FROM modoer_articles WHERE status=1 AND city_id IN (0,7175) ORDER BY dateline DESC LIMIT 0,5
Time:0.002239

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	modoer_articles		index	city_id,idx_city_id,idx_status_pic_city_pageview,idx_status_city_dateline	idx_dateline	4		10	25.01	Using where; Backward index scan

Query68:SELECT * FROM modoer_tags WHERE city_id IN ('0','7175') AND closed = '0' ORDER BY dateline DESC LIMIT 0, 60
Time:0.003904
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

我来回答：	回答即可获得积分，答案被采纳则获得悬赏分以及奖励 10 分。
	上传图片
参考资料：	如果您的答案是从其他地方引用，请表明出处。

工商服务

财会税务

资质审批

政府扶持

企业认证

知识产权

综合服务

页面提示：“纳税人必须签名”

其他回答

SQL History (68)

file autoload (33)

file included_files (85)

helper include (10)

cache load (19)

cache write (9)

cache dbcache (4)

input GET (5)