转让甘肃**食品加工有限责任公司- 95商服网

SQL History (14)

Connect MySQL
Time:0.014497
Query1:SELECT * FROM modoer_dbcache WHERE cache_key IN ('comm_dbcache_expire','comm_task_nexttime','comm_session_expire','comm_session_online')
Time:0.002194
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 = '3d0ccc2fb470e7028e93f299ebce3fe8' LIMIT 0, 1
Time:0.002032
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='3d0ccc2fb470e7028e93f299ebce3fe8',uid='0',ip_address='17.246.15.106',content='',last_time='1775689817',last_url='/lanzhou/gov/8646.html',is_mobile='0',user_agent='Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.4 Safari/605.1.15 (Applebot/0.1; +http://www.apple.com/go/applebot)'
Time:0.002857
Query4:SELECT * FROM modoer_subject WHERE sid = '8646' LIMIT 0, 1
Time:0.002125
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
Query5:SELECT * FROM modoer_subject_zhr WHERE sid = '8646' LIMIT 0, 1
Time:0.002029
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_subject_zhr const PRIMARY PRIMARY 3 const 1 100.00
Query6:SELECT * FROM modoer_subjectgrade
Time:0.001989
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_subjectgrade ALL 1 100.00
Query7:SELECT * FROM modoer_review_opt WHERE gid = '0' AND enable = '1' ORDER BY listorder,id
Time:0.002047
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
Exec 8:UPDATE modoer_subject SET pageviews=pageviews+'1' WHERE sid = '8646'
Time:0.002803
Query9:SELECT * FROM modoer_mysubject WHERE sid = '8646' LIMIT 0, 1
Time:0.002058
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_mysubject ref sid sid 3 const 1 100.00
Query10:SELECT * FROM modoer_subjectgourd WHERE sid = '8646' ORDER BY id DESC LIMIT 0, 1
Time:0.002001
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_subjectgourd ref sid sid 3 const 1 100.00 Using filesort
Query11:SELECT * FROM modoer_area ORDER BY level,listorder
Time:0.020127
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_area ALL 3803 100.00 Using filesort
Query12:SELECT sid,thumb,name,subname,avgsort,reviews FROM modoer_subject WHERE city_id IN (0,3895) and status=1 and sid!=8646 ORDER BY addtime 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		range	PRIMARY,addtime,finer,tops,idx_status_sid,idx_status	addtime	1		41712	0.45	Using index condition; Using where

Query13:SELECT sid,name,subname,thumb,pageviews FROM modoer_subject WHERE city_id IN (0,3895) and pid=740 and status=1 and sid!=8646 ORDER BY addtime DESC LIMIT 0,5
Time:0.002306

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	modoer_subject		range	PRIMARY,list_aid,addtime,finer,tops,pid,aid,list_city,idx_status_sid,idx_status	tops	5		9	56.27	Using index condition; Using filesort

Query14:SELECT articleid,subject,catid,thumb,picture,dateline FROM modoer_articles WHERE status=1 AND havepic=1 AND city_id IN (0,3895) ORDER BY dateline DESC LIMIT 0,5
Time:0.002230

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		9	0.56	Using where; Backward index scan

甘肃**食品加工有限责任公司

详细内容

你可能还喜欢

评论（0）

综合 好评 差评 图文 精华

点赞 热门 最新

最新转让

最新动态

SQL History (14)

file autoload (39)

file included_files (89)

helper include (5)

cache load (19)

cache write (353)

cache dbcache (4)

input GET (7)

甘肃**食品加工有限责任公司

详细内容

你可能还喜欢

评论（0）

综合 好评 差评 图文 精华 点赞 热门 最新

最新转让

最新动态

SQL History (14)

file autoload (39)

file included_files (89)

helper include (5)

cache load (19)

cache write (353)

cache dbcache (4)

input GET (7)

综合好评差评图文精华

点赞热门最新