begin

Run Time: 0.000119

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:8;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:245:"a:10:{s:4:"type";s:3:"new";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:8;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:1576076471;i:5;i:1356858384;i:3;i:1356858467;i:4;i:1356858471;i:11;i:1576076471;i:12;i:1491319394;i:8;i:1576084002;i:9;i:1576084002;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.000390

commit

Run Time: 0.000174

SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?

Params: 1

Run Time: 0.000185

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

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

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

Run Time: 0.000520

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 COUNT(*)
FROM xf_thread AS thread

WHERE (thread.node_id = 13) AND (thread.sticky = 0) AND (thread.discussion_state IN ('visible'))

Run Time: 0.000130

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	989	Using where

SELECT thread.*
	,
	user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
	NULL AS thread_read_date,
	0 AS user_post_count
FROM xf_thread AS thread 

	LEFT JOIN xf_user AS user ON
		(user.user_id = thread.user_id)
WHERE (thread.node_id = 13) AND (thread.sticky = 0) AND (thread.discussion_state IN ('visible'))
ORDER BY thread.last_post_date DESC
 LIMIT 16

Run Time: 0.000819

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	989	Using where
SIMPLE	user	eq_ref	PRIMARY	PRIMARY	4	nhanxetd_nxdg.thread.user_id	1

SELECT thread.*
	,
	user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
	NULL AS thread_read_date,
	0 AS user_post_count
FROM xf_thread AS thread 

	LEFT JOIN xf_user AS user ON
		(user.user_id = thread.user_id)
WHERE (thread.node_id = 13) AND (thread.sticky = 1) AND (thread.discussion_state IN ('visible'))
ORDER BY thread.last_post_date DESC

Run Time: 0.000782

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	5	const,const	1	Using where
SIMPLE	user	eq_ref	PRIMARY	PRIMARY	4	nhanxetd_nxdg.thread.user_id	1

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

Params: 32, 33

Run Time: 0.000292

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 (117004, 116988, 71107, 116949, 116900, 116887, 116815, 116715, 116629, 116615, 116552, 116376, 116304, 116210, 73418, 116236)

Run Time: 0.000367

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	post	range	PRIMARY	PRIMARY	4		16	Using where

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 (116615)
ORDER BY attachment.content_id, attachment.attach_date

Params: post

Run Time: 0.000306

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

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, 1679470774, 1679470774, XenForo_ControllerPublic_Forum, Index, valid, node_id=13, 1576091252

Run Time: 0.002164

SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'wf_widget_wrapper', 'wf_widget_threads', 'thread_list_item', 'waindigo_thread_list_avatar_replace_thread_thumbs', 'waindigo_thread_list_thumbnail_thread_thumbs', 'waindigo_thread_list_avatar_last_post_avatar', 'forum_view', 'EWRmedio_Navtabs', 'wf_hook_moderator_bar', 'wf_revealer', 'PAGE_CONTAINER')
	AND style_id = ?
	AND language_id = ?

Params: 1, 2

Run Time: 0.000334

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

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

Params: 2

Run Time: 0.000163

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

SELECT *
FROM xf_node

ORDER BY lft ASC

Run Time: 0.000273

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

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

Run Time: 0.014151

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				9927	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 (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'))
ORDER BY thread.post_date DESC
 LIMIT 8

Run Time: 0.000362

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				9927	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 ('waindigo_thread_list_thread_thumbs')
	AND style_id = ?
	AND language_id = ?

Params: 1, 2

Run Time: 0.000204

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 ('social_connect_status_editor')
	AND style_id = ?
	AND language_id = ?

Params: 1, 2

Run Time: 0.000205

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

Memory: 5.0073 MB (Peak: 6.1034 MB)

Queries (23, time: 0.0228s, 5.5%)

Included Files (139, XenForo Classes: 60)