begin

Run Time: 0.000121

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

commit

Run Time: 0.000162

SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?

Params: 1

Run Time: 0.000212

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

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

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

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

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	1098	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.001307

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	1098	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.000753

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

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 (122133, 122081, 110518, 110510, 110484, 110481, 110998, 122044, 122019, 2779, 121964, 121952, 121748, 121572, 121444, 121241)

Run Time: 0.000318

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 (122081, 121964, 121952, 121748, 121572, 121444, 121241)
ORDER BY attachment.content_id, attachment.attach_date

Params: post

Run Time: 0.000530

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	attachment	range	content_type_id_date	content_type_id_date	81		7	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, 315617510, 315617510, XenForo_ControllerPublic_Forum, Index, valid, node_id=13, 1594461317

Run Time: 0.000993

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

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

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

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

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

Run Time: 0.000263

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				11079	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.000283

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				11079	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.001236

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

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

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

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: 1.0334s

Memory: 5.4082 MB (Peak: 6.5014 MB)

Queries (24, time: 0.0118s, 1.1%)

Included Files (140, XenForo Classes: 60)