提前清偿 / 返还取消批给款项申请书(范文下载)- 95商服网

SQL History (11)

Connect MySQL
Time:0.015595
Query1:SELECT * FROM modoer_dbcache WHERE cache_key IN ('comm_dbcache_expire','comm_task_nexttime','comm_session_expire','comm_session_online')
Time:0.002405
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 = '9d39b0f51d24da03cf0e7077360fdebd' LIMIT 0, 1
Time:0.002319
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_subject WHERE sid = '16336' LIMIT 0, 1
Time:0.002465
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
Query4:SELECT * FROM modoer_subject_taoci WHERE sid = '16336' LIMIT 0, 1
Time:0.002234
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_subject_taoci const PRIMARY PRIMARY 3 const 1 100.00
Query5:SELECT * FROM modoer_subjectgrade
Time:0.002180
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_subjectgrade ALL 1 100.00
Query6:SELECT * FROM modoer_review_opt WHERE gid = '0' AND enable = '1' ORDER BY listorder,id
Time:0.002256
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 7:UPDATE modoer_subject SET pageviews=pageviews+'1' WHERE sid = '16336'
Time:0.003297
Query8:SELECT * FROM modoer_mysubject WHERE sid = '16336' LIMIT 0, 1
Time:0.002253
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
Query9:SELECT * FROM modoer_subjectgourd WHERE sid = '16336' ORDER BY id DESC LIMIT 0, 1
Time:0.002192
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
Query10:SELECT sid,name,subname,thumb,pageviews FROM modoer_subject WHERE city_id IN (0,3632) and pid=38 and status=1 and sid!=16336 ORDER BY addtime DESC LIMIT 0,3
Time:0.002710

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		18	74.65	Using index condition; Using filesort

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

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

提前清偿 / 返还取消批给款项申请书(范文下载)

范文下载

内容摘要

相关内容

最新动态

SQL History (11)

file autoload (38)

file included_files (87)

helper include (6)

cache load (20)

cache write (1)

cache dbcache (4)

input GET (7)