begin
Run Time: 0.000120
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:1653636331;i:5;i:1356858384;i:3;i:1356858467;i:4;i:1356858471;i:11;i:1653636331;i:12;i:1491319394;i:8;i:1653650305;i:9;i:1653650305;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.000382
commit
Run Time: 0.000167
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000195
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)
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:1653636331;i:5;i:1356858384;i:3;i:1356858467;i:4;i:1356858471;i:11;i:1653636331;i:12;i:1491319394;i:8;i:1653650305;i:9;i:1653650305;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.000254
SELECT *
FROM xf_smilie
ORDER BY title
Run Time: 0.000216
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_smilie | ALL | | | | | 12 | 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, 598364831, 598364831, XenForo_ControllerPublic_Help, Smilies, valid, , 1653652422
Run Time: 0.000205
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'help_wrapper', 'wf_widget_wrapper', 'wf_widget_threads', 'help_smilies', 'EWRmedio_Navtabs', 'wf_hook_moderator_bar', 'wf_revealer', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 1, 2
Run Time: 0.000325
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 160 | | 9 | 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.000204
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.000329
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.000185
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 > 1651060422)
ORDER BY thread.reply_count DESC, thread.last_post_date DESC
LIMIT 6
Run Time: 0.018766
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 | node_id_last_post_date | 4 | | 6019 | 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.000406
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 | 603 | 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.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 ('footer_custom')
AND style_id = ?
AND language_id = ?
Params: 1, 2
Run Time: 0.000200
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.000184
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 160 | const,const,const | 1 | |