dz query

Discuz! X1.5 20110627 / php:5.3.8 firefox:8.0 mozilla:5.0
Memory usage 6,598,704 bytes, peak 7,097,528 bytes / Queries 13 in 0.220896s / Include files 16 / ModID forum::viewthread
[TOP]    Queries Ajax Queries Envionment Include Files $_COOKIE  |   update.php

Queries: 13

1. 
   0.000534s • SELECT * FROM pre_common_session WHERE sid='1b5JG2' AND CONCAT_WS('.', ip1,ip2,ip3,ip4)='127.0.0.1'
   

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pre_common_session	system	sid				1

File	Line	Function
source\class\class_core.php	661	db_mysql->query()
source\class\class_core.php	863	db_mysql->fetch_first()
source\class\class_core.php	823	DB->_execute()
source\class\class_core.php	1024	DB->fetch_first()
source\class\class_core.php	331	discuz_session->init()
source\class\class_core.php	68	discuz_core->_init_session()
forum.php	50	discuz_core->init()

0.001243s • SELECT /*!40001 SQL_CACHE */ * FROM pre_common_syscache WHERE cname IN ('smilies','smileytypes','forums','usergroups','ranks','stamps','bbcodes','custominfo','groupicon','threadtableids','threadtable_info','usergroup_7','setting','style_default','cronnextrun')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pre_common_syscache	range	PRIMARY	PRIMARY	66		15	Using where

File	Line	Function
source\class\class_core.php	863	db_mysql->query()
source\class\class_core.php	837	DB::_execute()
source\function\function_core.php	617	DB::query()
source\function\function_core.php	557	cachedata()
source\class\class_core.php	524	loadcache()
source\class\class_core.php	69	discuz_core->_init_setting()
forum.php	50	discuz_core->init()

0.000553s • SELECT /*!40001 SQL_CACHE */ * FROM pre_common_syscache WHERE cname IN ('usergroup_10')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pre_common_syscache	const	PRIMARY	PRIMARY	66	const	1

File	Line	Function
source\class\class_core.php	863	db_mysql->query()
source\class\class_core.php	837	DB::_execute()
source\function\function_core.php	617	DB::query()
source\function\function_core.php	557	cachedata()
source\class\class_core.php	531	loadcache()
source\class\class_core.php	69	discuz_core->_init_setting()
forum.php	50	discuz_core->init()

0.000905s • SELECT t.tid, t.closed, f.*, ff.* , f.fid AS fid
FROM pre_forum_thread t
INNER JOIN pre_forum_forum f ON f.fid=t.fid
LEFT JOIN pre_forum_forumfield ff ON ff.fid=f.fid
WHERE t.tid='29802' AND (t.displayorder>='0' OR (t.displayorder IN ('-4', '-3', '-2') AND t.authorid='0')) LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	const	PRIMARY,displayorder,typeid,authorid	PRIMARY	3	const	1
1	SIMPLE	f	const	PRIMARY	PRIMARY	3	const	1
1	SIMPLE	ff	const	PRIMARY	PRIMARY	3	const	1

File	Line	Function
source\class\class_core.php	661	db_mysql->query()
source\class\class_core.php	863	db_mysql->fetch_first()
source\class\class_core.php	823	DB::_execute()
source\function\function_forum.php	425	DB::fetch_first()
forum.php	52	loadforum()

0.000608s • SELECT * FROM pre_forum_thread t WHERE tid='29802' AND (displayorder>='0' )

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	const	PRIMARY	PRIMARY	3	const	1

File	Line	Function
source\class\class_core.php	661	db_mysql->query()
source\class\class_core.php	863	db_mysql->fetch_first()
source\class\class_core.php	823	DB::_execute()
source\module\forum\forum_viewthread.php	33	DB::fetch_first()
forum.php	59	require()

0.000654s • SELECT /*!40001 SQL_CACHE */ * FROM pre_common_syscache WHERE cname IN ('threadsort_option_3','threadsort_template_3')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pre_common_syscache	range	PRIMARY	PRIMARY	66		2	Using where

File	Line	Function
source\class\class_core.php	863	db_mysql->query()
source\class\class_core.php	837	DB::_execute()
source\function\function_core.php	617	DB::query()
source\function\function_core.php	557	cachedata()
source\function\function_threadsort.php	267	loadcache()
source\module\forum\forum_viewthread.php	175	threadsortshow()
forum.php	59	require()

0.000310s • SELECT optionid, value, expiration FROM pre_forum_typeoptionvar WHERE tid='29802'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pre_forum_typeoptionvar	ref	tid	tid	3	const	11

File	Line	Function
source\class\class_core.php	863	db_mysql->query()
source\class\class_core.php	837	DB::_execute()
source\function\function_threadsort.php	273	DB::query()
source\module\forum\forum_viewthread.php	175	threadsortshow()
forum.php	59	require()

0.000584s • UPDATE LOW_PRIORITY pre_forum_thread SET views=views+1 WHERE tid='29802'

File	Line	Function
source\class\class_core.php	863	db_mysql->query()
source\class\class_core.php	837	DB::_execute()
source\module\forum\forum_viewthread.php	715	DB::query()
source\module\forum\forum_viewthread.php	331	viewthread_updateviews()
forum.php	59	require()

0.057817s • SELECT p.*
FROM pre_forum_post p
WHERE p.tid='29802' AND p.invisible='0' ORDER BY p.dateline LIMIT 0, 10

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	ref	invisible,displayorder,first	displayorder	4	const,const	9	Using where

File	Line	Function
source\class\class_core.php	863	db_mysql->query()
source\class\class_core.php	837	DB::_execute()
source\module\forum\forum_viewthread.php	468	DB::query()
forum.php	59	require()

0.000545s • SELECT /*!40001 SQL_CACHE */ * FROM pre_common_syscache WHERE cname IN ('bbcodes_display','smileycodes','icons','domainwhitelist')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pre_common_syscache	range	PRIMARY	PRIMARY	66		4	Using where

File	Line	Function
source\class\class_core.php	863	db_mysql->query()
source\class\class_core.php	837	DB::_execute()
source\function\function_core.php	617	DB::query()
source\function\function_core.php	557	cachedata()
source\function\function_post.php	466	loadcache()
source\module\forum\forum_viewthread.php	475	messagecutstr()
forum.php	59	require()

0.107385s • SELECT m.uid, m.username, m.groupid, m.adminid, m.regdate, m.credits, m.email, m.status AS memberstatus,
ms.lastactivity, ms.lastactivity, ms.invisible AS authorinvisible,
mc.*, mp.gender, mp.site, mp.icq, mp.qq, mp.yahoo, mp.msn, mp.taobao, mp.alipay,
mf.medals, mf.sightml AS signature, mf.customstatus
FROM pre_common_member m
LEFT JOIN pre_common_member_field_forum mf USING(uid)
LEFT JOIN pre_common_member_status ms USING(uid)
LEFT JOIN pre_common_member_count mc USING(uid)
LEFT JOIN pre_common_member_profile mp USING(uid)

WHERE m.uid IN ('10540','14531','14440','13419')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	range	PRIMARY	PRIMARY	3		4	Using where
1	SIMPLE	mf	eq_ref	PRIMARY	PRIMARY	3	ultrax.m.uid	1
1	SIMPLE	ms	eq_ref	PRIMARY	PRIMARY	3	ultrax.m.uid	1
1	SIMPLE	mc	eq_ref	PRIMARY	PRIMARY	3	ultrax.m.uid	1
1	SIMPLE	mp	eq_ref	PRIMARY	PRIMARY	3	ultrax.m.uid	1

File	Line	Function
source\class\class_core.php	863	db_mysql->query()
source\class\class_core.php	837	DB::_execute()
source\module\forum\forum_viewthread.php	501	DB::query()
forum.php	59	require()

0.000567s • SELECT /*!40001 SQL_CACHE */ * FROM pre_common_syscache WHERE cname IN ('advs')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pre_common_syscache	const	PRIMARY	PRIMARY	66	const	1

File	Line	Function
source\class\class_core.php	863	db_mysql->query()
source\class\class_core.php	837	DB::_execute()
source\function\function_core.php	617	DB::query()
source\function\function_core.php	557	cachedata()
source\function\function_core.php	1420	loadcache()
data\template\1_diy_forum_viewthread.tpl.php	143	adshow()
source\module\forum\forum_viewthread.php	673	include()
forum.php	59	require()

0.000471s • UPDATE pre_common_session SET `sid`='1b5JG2',`ip1`='127',`ip2`='0',`ip3`='0',`ip4`='1',`uid`='0',`username`='',`groupid`='7',`invisible`='0',`action`='2',`lastactivity`='1322638850',`fid`='17',`tid`='29802',`lastolupdate`='0' WHERE sid='1b5JG2'

File	Line	Function
source\class\class_core.php	863	db_mysql->query()
source\class\class_core.php	837	DB->_execute()
source\class\class_core.php	800	DB->query()
source\class\class_core.php	1072	DB->update()
source\function\function_core.php	61	discuz_session->update()
data\template\1_diy_forum_viewthread.tpl.php	1035	updatesession()
source\module\forum\forum_viewthread.php	673	include()
forum.php	59	require()

转载于:https://my.oschina.net/u/147492/blog/693817