柳州服务机构排行榜

SQL History (31)

Connect MySQL
Time:0.017585
Query1:SELECT * FROM modoer_dbcache WHERE cache_key IN ('comm_dbcache_expire','comm_task_nexttime','comm_session_expire','comm_session_online')
Time:0.002339
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 = 'c85e8ecf2dd4974c1533fb1e462558fa' LIMIT 0, 1
Time:0.002315
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='c85e8ecf2dd4974c1533fb1e462558fa',uid='0',ip_address='216.73.216.38',content='',last_time='1775691675',last_url='/liuzhou/mylist',is_mobile='0',user_agent='Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
Time:0.003214
Query4:SELECT COUNT(*) FROM modoer_mylist USE INDEX (city_time) WHERE city_id = '8520' AND num != '0'
Time:0.002587
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_mylist ref city_time city_time 3 const 1 90.00 Using where
Query5:SELECT * FROM modoer_category WHERE pid = '39'
Time:0.002455
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 name,subname,sid,thumb FROM modoer_subject WHERE status=1 and catid IN (39) AND city_id IN (0,8520) 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	4		2	50.00	Using index condition; Using where; Using filesort

Query7:SELECT * FROM modoer_category WHERE pid = '59'
Time:0.002405
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
Query8:SELECT * FROM modoer_category WHERE pid = '312'
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
Query9:SELECT * FROM modoer_category WHERE pid = '313'
Time:0.002344
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 = '314'
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
Query11:SELECT * FROM modoer_category WHERE pid = '315'
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
Query12:SELECT * FROM modoer_category WHERE pid = '316'
Time:0.002329
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 = '317'
Time:0.002346
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 = '319'
Time:0.002450
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 = '682'
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
Query16:SELECT * FROM modoer_category WHERE pid = '727'
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
Query17:SELECT * FROM modoer_category WHERE pid = '728'
Time:0.002307
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 = '729'
Time:0.002295
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 = '749'
Time:0.002329
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 (312,313,314,315,316,317,319,682,727,728,729,749,59) AND city_id IN (0,8520) ORDER BY finer DESC LIMIT 0,4
Time:0.002753

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

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

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

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

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 = '653'
Time:0.002329
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 name,subname,sid,thumb FROM modoer_subject WHERE status=1 and catid IN (653) AND city_id IN (0,8520) ORDER BY finer DESC LIMIT 0,4
Time:0.002423

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

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

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

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

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

Query31:SELECT m.* FROM modoer_mylist m WHERE m.city_id = '8520' AND m.status = '1' ORDER BY m.modifytime DESC LIMIT 0, 10
Time:0.002397
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE m ref city_time,cat_time city_time 3 const 1 10.00 Using where; Backward index scan

工商服务

资质审批

企业认证

财会服务

可行性报告

项目建议书

商业计划书

最新机构信息

SQL History (31)

file autoload (25)

file included_files (66)

helper include (5)

cache load (14)

cache write (1)

cache dbcache (4)

input GET (5)