广州行业专家信息查询频道- 95商服网

顾问地图 | 商服顾问相册 | 最佳排行 | 最新点评 首页 / 商服顾问/行业专家 (39)

Connect MySQL
Time:0.018047
Query1:SELECT * FROM modoer_dbcache WHERE cache_key IN ('comm_dbcache_expire','comm_task_nexttime','comm_session_expire','comm_session_online')
Time:0.003196
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 = '1122007471de58a12dc64691746ede3e' LIMIT 0, 1
Time:0.002423
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 COUNT(*) FROM modoer_subject s WHERE status = '1' AND pid = '119' AND city_id = '3526'
Time:0.002713

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s		ref	list_aid,addtime,finer,tops,pid,aid,list_city,idx_status_sid,idx_status	list_city	5	const,const,const	39	100.00	Using index

Query4: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,description,c_shangchang FROM modoer_subject s LEFT JOIN modoer_subject_hangye sf ON (s.sid = sf.sid) WHERE status = '1' AND pid = '119' AND city_id = '3526' ORDER BY finer DESC LIMIT 0, 20
Time:0.002834

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s		ref	list_aid,addtime,finer,tops,pid,aid,list_city,idx_status_sid,idx_status	tops	5	const,const,const	39	100.00	Using filesort

Query5:SELECT r.rid, r.id, r.content, r.uid, r.username FROM modoer_review r WHERE r.id IN (6707,7122,8771,7006,9622,7007,7009,7010,7123,8287,9417,9418,9419,9420,9617,9618,9619,9620,9621,6706) 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.002417
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
Query6:SELECT * FROM modoer_category WHERE pid = '39'
Time:0.002353
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 name,subname,sid,thumb FROM modoer_subject WHERE status=1 and catid IN (39) AND city_id IN (0,3526) ORDER BY finer DESC LIMIT 0,4
Time:0.002486

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

Query8:SELECT * FROM modoer_category WHERE pid = '59'
Time:0.002325
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
Query9:SELECT * FROM modoer_category WHERE pid = '312'
Time:0.002332
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 = '313'
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
Query11:SELECT * FROM modoer_category WHERE pid = '314'
Time:0.002321
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 = '315'
Time:0.002268
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 = '316'
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
Query14:SELECT * FROM modoer_category WHERE pid = '317'
Time:0.002244
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 = '319'
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
Query16:SELECT * FROM modoer_category WHERE pid = '682'
Time:0.003866
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 = '727'
Time:0.002311
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 = '728'
Time:0.002370
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 = '729'
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
Query20:SELECT * FROM modoer_category WHERE pid = '749'
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
Query21: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,3526) ORDER BY finer DESC LIMIT 0,4
Time:0.002639

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

Query22: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
Query23:SELECT name,subname,sid,thumb FROM modoer_subject WHERE status=1 and catid IN (54) AND city_id IN (0,3526) ORDER BY finer DESC LIMIT 0,4
Time:0.002348

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

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

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

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

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.002272
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,3526) ORDER BY finer DESC LIMIT 0,4
Time:0.002375

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.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
Query31:SELECT name,subname,sid,thumb FROM modoer_subject WHERE status=1 and catid IN (58) AND city_id IN (0,3526) ORDER BY finer DESC LIMIT 0,4
Time:0.002425

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

工商服务

资质审批

企业认证

财会服务

可行性报告

项目建议书

商业计划书

顾新中(医疗器械战略专家)

陈梅花(法律顾问)

杨咏仪(广州总经理)

黄田慧敏(澳大利亚留学顾问)

林俊雄(技术与专利经理)

顾仲良(澳大利亚留学顾问)

肖媛(澳大利亚留学顾问)

陈楚华(亚洲留学顾问)

李君强(互联网顾问)

宋雨森(其他服务顾问)

陈美玲(专利顾问)

王彬(创业顾问)

刘绿妮(工商顾问)

何倩文(工商顾问)

周鸣晨(商标代理人)

郑英(高级知识产权规划师)

徐秋养(高级知识产权规划师)

廖珍珍(专利代理人)

李永敢(专利工程师)

钟志辉(香港医护学会法规顾问)

SQL History (31)

file autoload (30)

file included_files (80)

helper include (6)

cache load (21)

cache write (3)

cache dbcache (4)

input GET (6)