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.000374

commit

Run Time: 0.000152

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.000254

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.000274

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: 369

Run Time: 0.000840

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.000551

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: 369

Run Time: 0.002400

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	post	range	thread_id_post_date,thread_id_position	thread_id_position	8		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: 369

Run Time: 0.000183

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

Params: 16, 17

Run Time: 0.000307

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 (373)

Run Time: 0.000708

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

SELECT attachment.*,
	data.filename, data.file_size, data.file_hash, data.width, data.height, data.thumbnail_width, data.thumbnail_height
FROM xf_attachment AS attachment
INNER JOIN xf_attachment_data AS data ON
	(data.data_id = attachment.data_id)
WHERE attachment.content_type = ?
	AND attachment.content_id IN (373)
ORDER BY attachment.content_id, attachment.attach_date

Params: post

Run Time: 0.000607

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	attachment	ref	content_type_id_date	content_type_id_date	81	const,const	1	Using where
SIMPLE	data	eq_ref	PRIMARY	PRIMARY	4	nhanxetd_nxdg.attachment.data_id	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.003047

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=369, 1679386859

Run Time: 0.000234

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.000651

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.000189

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.000321

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.000183

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 > 1676794859)
ORDER BY thread.reply_count DESC, thread.last_post_date DESC
 LIMIT 6

Run Time: 0.009178

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				5025	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.000423

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_last_post_date	4	const	665	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.000227

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.000194

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.000186

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.5134s

Memory: 5.3956 MB (Peak: 6.5463 MB)

Queries (25, time: 0.0220s, 4.3%)

Included Files (152, XenForo Classes: 63)