begin

Run Time: 0.000099

INSERT INTO xf_data_registry
	(data_key, data_value)
VALUES
	(?, ?)
ON DUPLICATE KEY UPDATE
	data_value = VALUES(data_value)

Params: simpleCache, a:7:{s:33:"Vinavb_CustomNodeIcon_lastUpdated";i:1441301367;s:7:"widgets";a:10:{i:1;a:8:{s:9:"widget_id";i:1;s:5:"title";s:13:"Clear Sidebar";s:5:"class";s:36:"WidgetFramework_WidgetRenderer_Empty";s:7:"options";s:114:"a:4:{s:14:"noVisitorPanel";i:0;s:9:"tab_group";s:6:"random";s:10:"expression";s:0:"";s:16:"expression_debug";i:0;}";s:8:"position";s:10:"forum_list";s:13:"display_order";i:0;s:6:"active";i:1;s:18:"template_for_hooks";s:6:"a:0:{}";}i:2;a:8:{s:9:"widget_id";i:2;s:5:"title";s:16:"Staff Online Now";s:5:"class";s:42:"WidgetFramework_WidgetRenderer_OnlineStaff";s:7:"options";s:6:"a:0:{}";s:8:"position";s:10:"forum_list";s:13:"display_order";i:0;s:6:"active";i:1;s:18:"template_for_hooks";N;}i:6;a:8:{s:9:"widget_id";i:6;s:5:"title";s:0:"";s:5:"class";s:36:"WidgetFramework_WidgetRenderer_Empty";s:7:"options";s:6:"a:0:{}";s:8:"position";s:11:"member_list";s:13:"display_order";i:0;s:6:"active";i:0;s:18:"template_for_hooks";N;}i:7;a:8:{s:9:"widget_id";i:7;s:5:"title";s:11:"Find Member";s:5:"class";s:40:"WidgetFramework_WidgetRenderer_UsersFind";s:7:"options";s:6:"a:0:{}";s:8:"position";s:11:"member_list";s:13:"display_order";i:0;s:6:"active";i:0;s:18:"template_for_hooks";N;}i:8;a:8:{s:9:"widget_id";i:8;s:5:"title";s:23:"Highest-Posting Members";s:5:"class";s:36:"WidgetFramework_WidgetRenderer_Users";s:7:"options";s:202:"a:7:{s:5:"limit";i:12;s:5:"order";s:13:"message_count";s:9:"direction";s:4:"DESC";s:11:"displayMode";s:16:"avatarOnlyBigger";s:9:"tab_group";s:0:"";s:10:"expression";s:0:"";s:16:"expression_debug";i:0;}";s:8:"position";s:11:"member_list";s:13:"display_order";i:0;s:6:"active";i:0;s:18:"template_for_hooks";N;}i:9;a:8:{s:9:"widget_id";i:9;s:5:"title";s:14:"Newest Members";s:5:"class";s:36:"WidgetFramework_WidgetRenderer_Users";s:7:"options";s:188:"a:7:{s:5:"limit";i:8;s:5:"order";s:13:"register_date";s:9:"direction";s:4:"DESC";s:11:"displayMode";s:4:"list";s:9:"tab_group";s:0:"";s:10:"expression";s:0:"";s:16:"expression_debug";i:0;}";s:8:"position";s:11:"member_list";s:13:"display_order";i:0;s:6:"active";i:1;s:18:"template_for_hooks";s:6:"a:0:{}";}i:13;a:8:{s:9:"widget_id";i:13;s:5:"title";s:0:"";s:5:"class";s:42:"Tinhte_XenTag_WidgetRenderer_TaggedThreads";s:7:"options";s:135:"a:6:{s:4:"tags";s:0:"";s:5:"limit";i:5;s:8:"as_guest";i:0;s:9:"tab_group";s:0:"";s:10:"expression";s:0:"";s:16:"expression_debug";i:0;}";s:8:"position";s:3:"all";s:13:"display_order";i:0;s:6:"active";i:1;s:18:"template_for_hooks";s:6:"a:0:{}";}i:10;a:8:{s:9:"widget_id";i:10;s:5:"title";s:18:"Xem nhiều nhất";s:5:"class";s:38:"WidgetFramework_WidgetRenderer_Threads";s:7:"options";s:228:"a:10:{s:4:"type";s:12:"most_replied";s:6:"cutoff";i:30;s:6:"forums";a:0:{}s:8:"prefixes";a:0:{}s:8:"as_guest";i:0;s:5:"limit";i:6;s:7:"display";a:0:{}s:9:"tab_group";s:1:"2";s:10:"expression";s:0:"";s:16:"expression_debug";i:0;}";s:8:"position";s:3:"all";s:13:"display_order";i:1;s:6:"active";i:1;s:18:"template_for_hooks";s:6:"a:0:{}";}i:12;a:8:{s:9:"widget_id";i:12;s:5:"title";s:25:"Thành viên đang online";s:5:"class";s:42:"WidgetFramework_WidgetRenderer_OnlineUsers";s:7:"options";s:82:"a:3:{s:9:"tab_group";s:0:"";s:10:"expression";s:0:"";s:16:"expression_debug";i:0;}";s:8:"position";s:10:"forum_list";s:13:"display_order";i:1;s:6:"active";i:1;s:18:"template_for_hooks";s:6:"a:0:{}";}i:11;a:8:{s:9:"widget_id";i:11;s:5:"title";s:17:"Bài mới nhất";s:5:"class";s:38:"WidgetFramework_WidgetRenderer_Threads";s:7:"options";s:269:"a:10:{s:4:"type";s:3:"new";s:6:"cutoff";i:30;s:6:"forums";a:1:{i:0;s:1:"5";}s:8:"prefixes";a:1:{i:0;s:1:"3";}s:8:"as_guest";i:0;s:5:"limit";i:6;s:7:"display";a:1:{s:11:"show_prefix";s:1:"1";}s:9:"tab_group";s:1:"1";s:10:"expression";s:0:"";s:16:"expression_debug";i:0;}";s:8:"position";s:3:"all";s:13:"display_order";i:2;s:6:"active";i:1;s:18:"template_for_hooks";s:6:"a:0:{}";}}s:17:"invalidated_cache";a:13:{i:10;i:1679383533;i:5;i:1356858384;i:3;i:1356858467;i:4;i:1356858471;i:11;i:1679383533;i:12;i:1491319394;i:8;i:1679382653;i:9;i:1679382653;i:6;i:1402644867;i:7;i:1402644863;i:1;i:1491318740;i:2;i:1491318686;i:13;i:1492956465;}s:18:"EWRporta_MostUsers";a:2:{s:5:"total";i:14;s:4:"time";i:1358392238;}s:22:"waindigo_justInstalled";a:0:{}s:30:"waindigo_copyrightModification";i:0;s:26:"waindigo_lastXmlUploadDate";i:1402330594;}

Run Time: 0.000367

commit

Run Time: 0.000156

SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?

Params: 1

Run Time: 0.000193

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_permission_combination	const	PRIMARY	PRIMARY	4	const	1

SELECT *
FROM xf_addon
ORDER BY title

Run Time: 0.000255

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_addon	ALL					17	Using filesort

INSERT INTO xf_data_registry
	(data_key, data_value)
VALUES
	(?, ?)
ON DUPLICATE KEY UPDATE
	data_value = VALUES(data_value)

Run Time: 0.000261

SELECT thread.*
	,
		user.avatar_date, user.gravatar,
		NULL AS thread_read_date,
		0 AS thread_is_watched
FROM xf_thread AS thread

		LEFT JOIN xf_user AS user ON
			(user.user_id = thread.user_id)
WHERE thread.thread_id = ?

Params: 92156

Run Time: 0.000846

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	thread	const	PRIMARY	PRIMARY	4	const	1
SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1

SELECT node.*, forum.*
	,
	permission.cache_value AS node_permission_cache,
		NULL AS forum_read_date
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)

	LEFT JOIN xf_permission_cache_content AS permission
		ON (permission.permission_combination_id = 1
			AND permission.content_type = 'node'
			AND permission.content_id = forum.node_id)
WHERE node.node_id = ?

Params: 16

Run Time: 0.000560

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows
SIMPLE	forum	const	PRIMARY	PRIMARY	4	const	1
SIMPLE	node	const	PRIMARY	PRIMARY	4	const	1
SIMPLE	permission	const	PRIMARY	PRIMARY	85	const,const,const	1

SELECT post.*
	,
		user.*, IF(user.username IS NULL, post.username, user.username) AS username,
		user_profile.*,
		0 AS like_date
FROM xf_post AS post

		LEFT JOIN xf_user AS user ON
			(user.user_id = post.user_id)
		LEFT JOIN xf_user_profile AS user_profile ON
			(user_profile.user_id = post.user_id)
WHERE post.thread_id = ?
	 AND (post.position >= 0 AND post.position < 10) 
	AND (post.message_state IN ('visible'))
ORDER BY post.position ASC, post.post_date ASC

Params: 92156

Run Time: 0.002311

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	post	ref	thread_id_post_date,thread_id_position	thread_id_post_date	4	const	1	Using where; Using filesort
SIMPLE	user	eq_ref	PRIMARY	PRIMARY	4	nhanxetd_nxdg.post.user_id	1
SIMPLE	user_profile	eq_ref	PRIMARY	PRIMARY	4	nhanxetd_nxdg.post.user_id	1

INSERT DELAYED INTO xf_thread_view
	(thread_id)
VALUES
	(?)

Params: 92156

Run Time: 0.000176

SELECT *
FROM xf_node
WHERE lft < ? AND rgt > ?
ORDER BY lft ASC

Params: 16, 17

Run Time: 0.000305

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_node	ALL	lft				27	Using where; Using filesort

SELECT
	post.*
	
FROM xf_post AS post
WHERE post.post_id IN (123127)

Run Time: 0.000463

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	post	const	PRIMARY	PRIMARY	4	const	1

SELECT `thread_id`, `title`, `view_count`, `post_date`
FROM `xf_thread`
WHERE `node_id` = 16
ORDER BY RAND()
LIMIT 0, 15

Run Time: 0.003048

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_thread	ref	node_id_last_post_date,node_id_sticky_last_post_date	node_id_last_post_date	4	const	656	Using temporary; Using filesort

SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
	AND title IN ('xf_unknown_renderer', 'chip_morethread_random')

Params: 2

Run Time: 0.000178

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_phrase_compiled	range	PRIMARY	PRIMARY	231		2	Using where

INSERT INTO xf_session_activity
	(user_id, unique_key, ip, controller_name, controller_action, view_state, params, view_date)
VALUES
	(?, ?, ?, ?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE
	ip = VALUES(ip),
	controller_name = VALUES(controller_name),
	controller_action = VALUES(controller_action),
	view_state = VALUES(view_state),
	params = VALUES(params),
	view_date = VALUES(view_date)

Params: 0, 751394540, 751394540, XenForo_ControllerPublic_Thread, Index, valid, thread_id=92156, 1679383679

Run Time: 0.000203

SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'bb_code_tag_code', 'bb_code_tag_php', 'bb_code_tag_html', 'bb_code_tag_quote', 'bb_code_tag_attach', 'chip_morethreads', 'wf_widget_wrapper', 'wf_widget_threads', 'thread_view', 'EWRmedio_Navtabs', 'wf_hook_moderator_bar', 'wf_revealer', 'PAGE_CONTAINER')
	AND style_id = ?
	AND language_id = ?

Params: 1, 2

Run Time: 0.000349

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_template_compiled	range	PRIMARY	PRIMARY	160		14	Using where

SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
	AND title IN ('media')

Params: 2

Run Time: 0.000175

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_phrase_compiled	const	PRIMARY	PRIMARY	231	const,const	1

SELECT *
FROM xf_node

ORDER BY lft ASC

Run Time: 0.000310

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_node	ALL					27	Using filesort

SELECT cache_value
FROM xf_permission_cache_content_type
WHERE permission_combination_id = ?
	AND content_type = 'node'

Params: 1

Run Time: 0.000178

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_permission_cache_content_type	const	PRIMARY	PRIMARY	81	const,const	1

SELECT thread.*
	,
	user.avatar_date, user.gravatar
FROM xf_thread AS thread 

	LEFT JOIN xf_user AS user ON
		(user.user_id = thread.user_id)
WHERE ((thread.node_id IN (1, 2, 36, 38, 39, 40, 9, 10, 16, 32, 11, 3, 22, 4, 5, 12, 13, 14, 33, 34, 35, 17, 18, 19, 20, 37, 23)) AND (thread.discussion_state IN ('visible'))) AND (thread.post_date > 1676791679)
ORDER BY thread.reply_count DESC, thread.last_post_date DESC
 LIMIT 6

Run Time: 0.009231

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	thread	ALL	node_id_last_post_date,node_id_sticky_last_post_date				5024	Using where; Using filesort
SIMPLE	user	eq_ref	PRIMARY	PRIMARY	4	nhanxetd_nxdg.thread.user_id	1

SELECT thread.*
	,
	user.avatar_date, user.gravatar
FROM xf_thread AS thread 

	LEFT JOIN xf_user AS user ON
		(user.user_id = thread.user_id)
WHERE (thread.node_id IN ('5')) AND (thread.prefix_id IN ('3')) AND (thread.discussion_state IN ('visible'))
ORDER BY thread.post_date DESC
 LIMIT 6

Run Time: 0.000401

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	thread	ref	node_id_last_post_date,node_id_sticky_last_post_date	node_id_sticky_last_post_date	4	const	664	Using where; Using filesort
SIMPLE	user	eq_ref	PRIMARY	PRIMARY	4	nhanxetd_nxdg.thread.user_id	1

SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('social_connect_status_editor')
	AND style_id = ?
	AND language_id = ?

Params: 1, 2

Run Time: 0.000196

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_template_compiled	const	PRIMARY	PRIMARY	160	const,const,const	1

SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('footer_custom')
	AND style_id = ?
	AND language_id = ?

Params: 1, 2

Run Time: 0.000187

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_template_compiled	const	PRIMARY	PRIMARY	160	const,const,const	1

SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('GoToTop')
	AND style_id = ?
	AND language_id = ?

Params: 1, 2

Run Time: 0.000183

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_template_compiled	const	PRIMARY	PRIMARY	160	const,const,const	1

Page Time: 0.2087s

Memory: 5.2472 MB (Peak: 6.2371 MB)

Queries (24, time: 0.0206s, 9.9%)

Included Files (152, XenForo Classes: 63)