begin

Run Time: 0.000078

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

commit

Run Time: 0.000129

SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?

Params: 1

Run Time: 0.000153

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

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

SELECT *
FROM xf_search
WHERE search_id = ?

Params: 24798281

Run Time: 0.000911

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE								Impossible WHERE noticed after reading const tables

SELECT thread.*
	,
	forum.*
FROM xf_thread AS thread 

	INNER JOIN xf_forum AS forum ON
		(forum.node_id = thread.node_id)
WHERE (thread.discussion_state IN ('visible')) AND (thread.last_post_date > 1683825302) AND (forum.find_new = 1)
ORDER BY thread.last_post_date DESC
 LIMIT 200

Run Time: 0.000909

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	thread	range	node_id_last_post_date,node_id_sticky_last_post_date,last_post_date	last_post_date	4		76	Using where
SIMPLE	forum	eq_ref	PRIMARY	PRIMARY	4	nhanxetd_nxdg.thread.node_id	1	Using where

SELECT thread.*
	,
		user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
		node.title AS node_title,
	permission.cache_value AS node_permission_cache
FROM xf_thread AS thread
		LEFT JOIN xf_user AS user ON
			(user.user_id = thread.user_id)
		INNER JOIN xf_node AS node ON
			(node.node_id = thread.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 = thread.node_id)
WHERE thread.thread_id IN (108460, 108463, 108469, 108467, 108466, 104771, 107986, 108041, 108040, 103967, 107875, 108312, 108317, 108337, 107993, 108273, 108442, 63146, 104608, 108003, 56408, 108276, 108239, 54716, 107992, 108435, 107920, 107954, 107981, 107906, 108427, 108031, 1443, 105030, 104986, 107882, 105433, 66481, 25267, 106888, 1798, 108151, 108328, 108358, 107007, 106894, 107889, 108318, 108313, 107949, 108279, 107955)

Run Time: 0.000624

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	thread	range	PRIMARY,node_id_last_post_date,node_id_sticky_last_post_date	PRIMARY	4		52	Using where
SIMPLE	node	eq_ref	PRIMARY	PRIMARY	4	nhanxetd_nxdg.thread.node_id	1
SIMPLE	permission	eq_ref	PRIMARY	PRIMARY	85	const,const,nhanxetd_nxdg.node.node_id	1
SIMPLE	user	eq_ref	PRIMARY	PRIMARY	4	nhanxetd_nxdg.thread.user_id	1

INSERT INTO `xf_search` (`search_results`, `result_count`, `search_type`, `search_query`, `search_constraints`, `search_order`, `search_grouping`, `user_results`, `warnings`, `user_id`, `search_date`, `query_hash`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Params: [["thread",108460],["thread",108463],["thread",108469],["thread",108467],["thread",108466],["thread",104771],["thread",107986],["thread",108041],["thread",108040],["thread",103967],["thread",107875],["thread",108312],["thread",108317],["thread",108337],["thread",107993],["thread",108273],["thread",108442],["thread",63146],["thread",104608],["thread",108003],["thread",56408],["thread",108276],["thread",108239],["thread",54716],["thread",107992],["thread",108435],["thread",107920],["thread",107954],["thread",107981],["thread",107906],["thread",108427],["thread",108031],["thread",1443],["thread",105030],["thread",104986],["thread",107882],["thread",105433],["thread",66481],["thread",25267],["thread",106888],["thread",1798],["thread",108151],["thread",108328],["thread",108358],["thread",107007],["thread",106894],["thread",107889],["thread",108318],["thread",108313],["thread",107949],["thread",108279],["thread",107955]], 52, recent-threads, , [], date, 0, , [], 0, 1686417302, b956e81b6bb80d5de0e3955b72b3cadf

Run Time: 0.000869

Page Time: 0.0496s

Memory: 3.6854 MB (Peak: 3.8917 MB)

Queries (10, time: 0.0043s, 8.7%)

Included Files (104, XenForo Classes: 41)