begin
Run Time: 0.000141
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:1614766979;i:5;i:1356858384;i:3;i:1356858467;i:4;i:1356858471;i:11;i:1614766979;i:12;i:1491319394;i:8;i:1614778559;i:9;i:1614778559;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.000408
commit
Run Time: 0.000220
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000200
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.000279
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)
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:1614766979;i:5;i:1356858384;i:3;i:1356858467;i:4;i:1356858471;i:11;i:1614766979;i:12;i:1491319394;i:8;i:1614778559;i:9;i:1614778559;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.000288
SELECT *
FROM xf_style
ORDER BY title
Run Time: 0.000427
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_style | ALL | | | | | 1 | Using filesort |
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, 65909339, 65909339, XenForo_ControllerPublic_Misc, Style, valid, , 1614808067
Run Time: 0.000217
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'wf_widget_wrapper', 'wf_widget_threads', 'style_chooser', 'EWRmedio_Navtabs', 'wf_hook_moderator_bar', 'wf_revealer', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 1, 2
Run Time: 0.000312
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 160 | | 8 | 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.000182
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.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 > 1612216067)
ORDER BY thread.reply_count DESC, thread.last_post_date DESC
LIMIT 8
Run Time: 0.017569
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 | | | | 11468 | 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.000421
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 | | | | 11468 | 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.000222
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.000190
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 | |