begin

Run Time: 0.000107

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:1679363505;i:5;i:1356858384;i:3;i:1356858467;i:4;i:1356858471;i:11;i:1679363505;i:12;i:1491319394;i:8;i:1679368188;i:9;i:1679368188;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.000363

commit

Run Time: 0.000189

SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?

Params: 1

Run Time: 0.006458

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

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

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

Run Time: 0.006340

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

Run Time: 0.000574

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

Run Time: 0.002171

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

Run Time: 0.000185

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

Params: 8, 9

Run Time: 0.000302

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_node	range	lft	lft	4		4	Using where

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

Run Time: 0.000455

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` = 39
ORDER BY RAND()
LIMIT 0, 15

Run Time: 0.003277

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	669	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=38122, 1679381519

Run Time: 0.000190

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

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

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

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

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

Run Time: 0.000413

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.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_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.000197

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

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

Memory: 5.2522 MB (Peak: 6.2497 MB)

Queries (24, time: 0.0238s, 10.4%)

Included Files (152, XenForo Classes: 63)