国家强制认证相关资质查询频道

SQL History (31)

Connect MySQL
Time:0.018261
Query1:SELECT * FROM modoer_dbcache WHERE cache_key IN ('comm_dbcache_expire','comm_task_nexttime','comm_session_expire','comm_session_online')
Time:0.002394
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 = '573b5d2b8f0fe11bc0b0f48437e99ba9' LIMIT 0, 1
Time:0.002288
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 * FROM modoer_review_opt WHERE gid = '0' AND enable = '1' ORDER BY listorder,id
Time:0.002414
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
Query4:SELECT COUNT(*) FROM modoer_subject s WHERE status = '1' AND pid = '281' AND aid = '0'
Time:0.002933
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE s ref list_aid,addtime,finer,pid,aid,list_city,idx_status_sid,idx_status list_aid 5 const,const,const 164 100.00 Using index
Query5:SELECT s.sid,pid,catid,domain,name,avgsort,sort1,sort2,sort3,sort4,sort5,sort6,sort7,sort8,best,finer,pageviews,reviews,pictures,favorites,thumb,content FROM modoer_subject s LEFT JOIN modoer_subject_baike sf ON (s.sid = sf.sid) WHERE status = '1' AND pid = '281' AND aid = '0' ORDER BY finer DESC LIMIT 0, 20
Time:0.020058

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s		index_merge	list_aid,addtime,finer,pid,aid,list_city,idx_status_sid,idx_status	aid,idx_status_sid	4,1		82	100.00	Using intersect(aid,idx_status_sid); Using where; Using filesort

Query6:SELECT r.rid, r.id, r.content, r.uid, r.username FROM modoer_review r WHERE r.id IN (6519,7458,5984,6718,6324,6320,6188,6744,7277,6145,6011,7329,5879,7389,5979,5943,7351,5923,5921,5920) 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.002412
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
Query7:SELECT * FROM modoer_category WHERE pid = '39'
Time:0.004124
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 name,subname,sid,thumb FROM modoer_subject WHERE status=1 and catid IN (39) AND city_id IN (0,7130) ORDER BY finer DESC LIMIT 0,4
Time:0.002879

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	4		2	50.00	Using index condition; Using where; Using filesort

Query9:SELECT * FROM modoer_category WHERE pid = '59'
Time:0.003076
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.002323
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.002292
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.010927
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.003441
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.002249
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.002289
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.002402
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.002947
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.002299
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.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 = '729'
Time:0.002237
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.002355
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 name,subname,sid,thumb FROM modoer_subject WHERE status=1 and catid IN (312,313,314,315,316,317,319,682,727,728,729,749,59) AND city_id IN (0,7130) ORDER BY finer DESC LIMIT 0,4
Time:0.006945

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	4		26	50.00	Using index condition; Using where; Using filesort

Query23:SELECT * FROM modoer_category WHERE pid = '54'
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 1 100.00
Query24:SELECT name,subname,sid,thumb FROM modoer_subject WHERE status=1 and catid IN (54) AND city_id IN (0,7130) ORDER BY finer DESC LIMIT 0,4
Time:0.002379

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	4		2	50.00	Using index condition; Using where; Using filesort

Query25:SELECT * FROM modoer_category WHERE pid = '193'
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
Query26:SELECT * FROM modoer_category WHERE pid = '653'
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
Query27:SELECT name,subname,sid,thumb FROM modoer_subject WHERE status=1 and catid IN (653) AND city_id IN (0,7130) ORDER BY finer DESC LIMIT 0,4
Time:0.002436

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	4		2	50.00	Using index condition; Using where; Using filesort

Query28:SELECT * FROM modoer_category WHERE pid = '63'
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
Query29:SELECT name,subname,sid,thumb FROM modoer_subject WHERE status=1 and catid IN (63) AND city_id IN (0,7130) ORDER BY finer DESC LIMIT 0,4
Time:0.002417

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	modoer_subject		ref	catid,catid_2,addtime,finer,tops,idx_status_sid,idx_status	catid_2	2	const	3	1.67	Using where; Using filesort

Query30:SELECT * FROM modoer_category WHERE pid = '58'
Time:0.002767
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 name,subname,sid,thumb FROM modoer_subject WHERE status=1 and catid IN (58) AND city_id IN (0,7130) ORDER BY finer DESC LIMIT 0,4
Time:0.002395

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	modoer_subject		ref	catid,catid_2,addtime,finer,tops,idx_status_sid,idx_status	catid_2	2	const	3	1.67	Using where; Using filesort

工商服务

资质审批

企业认证

财会服务

可行性报告

项目建议书

商业计划书

ICP经营许可证

AS9100航空基础质量体系认证

CDN经营许可证

安全生产许可证

网络文化经营许可证

sp经营许可证

ISP许可证

北京积分落户

高新技术企业认定

IP-VPN许可证

EDI许可证

食品经营许可证

信息网络传播视听节目许可证

可信网站认证

医疗器械经营许可证

互联网药品信息服务许可证

烟草专卖许可证

食品流通许可证

公司注册

医疗器械注册证

SQL History (31)

file autoload (31)

file included_files (80)

helper include (6)

cache load (19)

cache dbcache (4)

input GET (6)