SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000115
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT profile_post.*
,
posting_user.*,
IF(posting_user.username IS NULL, profile_post.username, posting_user.username) AS username,
receiving_user.username
AS profile_username,
receiving_user.gender
AS profile_gender,
receiving_user.user_state
AS profile_user_state,
receiving_user.user_group_id
AS profile_user_group_id,
receiving_user.secondary_group_ids
AS profile_secondary_group_ids,
receiving_user.display_style_group_id
AS profile_display_style_group_id,
receiving_user.is_banned
AS profile_is_banned,
receiving_user.is_admin
AS profile_is_admin,
receiving_user.is_moderator
AS profile_is_moderator,
receiving_user.avatar_date
AS profile_avatar_date,
receiving_user.gravatar
AS profile_gravatar,
receiving_user.warning_points
AS profile_warning_points,
receiving_user.permission_combination_id
AS profile_permission_combination_id,
receiving_user_privacy.allow_view_profile
AS profile_allow_view_profile,
receiving_user_privacy.allow_post_profile
AS profile_allow_post_profile,
receiving_user_privacy.allow_send_personal_conversation
AS profile_allow_send_personal_conversation,
receiving_user_privacy.allow_view_identities
AS profile_allow_view_identities,
receiving_user_privacy.allow_receive_news_feed
AS profile_allow_allow_receive_news_feed,
IF (receiving_user_follow.follow_user_id, 1, 0)
AS following_0
FROM xf_profile_post AS profile_post
LEFT JOIN xf_user AS posting_user ON
(posting_user.user_id = profile_post.user_id)
LEFT JOIN xf_user AS receiving_user ON
(receiving_user.user_id = profile_post.profile_user_id)
LEFT JOIN xf_user_privacy AS receiving_user_privacy ON
(receiving_user_privacy.user_id = profile_post.profile_user_id)
LEFT JOIN xf_user_follow AS receiving_user_follow ON
(receiving_user_follow.user_id = profile_post.profile_user_id AND follow_user_id = 0)
WHERE (profile_post.message_state IN ('visible'))
ORDER BY profile_post.post_date DESC
LIMIT 10Run Time: 0.001142
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | profile_post | ALL | | | | | 128 | Using where; Using filesort |
| SIMPLE | posting_user | eq_ref | PRIMARY | PRIMARY | 4 | vozer_net_53d0.profile_post.user_id | 1 | |
| SIMPLE | receiving_user | eq_ref | PRIMARY | PRIMARY | 4 | vozer_net_53d0.profile_post.profile_user_id | 1 | |
| SIMPLE | receiving_user_privacy | eq_ref | PRIMARY | PRIMARY | 4 | vozer_net_53d0.profile_post.profile_user_id | 1 | |
| SIMPLE | receiving_user_follow | eq_ref | PRIMARY,follow_user_id | PRIMARY | 8 | vozer_net_53d0.profile_post.profile_user_id,const | 1 | Using index |
SELECT thread.*
,
last_post_user.gender AS last_post_gender,
last_post_user.avatar_date AS last_post_avatar_date,
last_post_user.gravatar AS last_post_gravatar,
IF(last_post_user.username IS NULL, thread.last_post_username, last_post_user.username) AS last_post_username,
node.title AS node_title, node.node_name,
forum.*,
forum.last_post_id AS forum_last_post_id,
forum.last_post_date AS forum_last_post_date,
forum.last_post_user_id AS forum_last_post_user_id,
forum.last_post_username AS forum_last_post_username,
forum.last_thread_title AS forum_last_thread_title,
thread.last_post_id,
thread.last_post_date,
thread.last_post_user_id,
thread.last_post_username,
NULL AS thread_read_date,
permission.cache_value AS node_permission_cache
FROM xf_thread AS thread FORCE INDEX (last_post_date)
LEFT JOIN xf_user AS last_post_user ON
(last_post_user.user_id = thread.last_post_user_id)
LEFT JOIN xf_node AS node ON
(node.node_id = thread.node_id)
LEFT JOIN xf_forum AS forum ON
(forum.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.discussion_type <> 'redirect') AND (thread.discussion_state IN ('visible')) AND (thread.last_post_date > 1601346016) AND (forum.find_new = 1)
ORDER BY thread.last_post_date DESC
LIMIT 10Run Time: 0.001526
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | thread | range | last_post_date | last_post_date | 4 | | 24 | Using where |
| SIMPLE | forum | eq_ref | PRIMARY | PRIMARY | 4 | vozer_net_53d0.thread.node_id | 1 | Using where |
| SIMPLE | last_post_user | eq_ref | PRIMARY | PRIMARY | 4 | vozer_net_53d0.thread.last_post_user_id | 1 | |
| SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | vozer_net_53d0.thread.node_id | 1 | |
| SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,vozer_net_53d0.thread.node_id | 1 | Using where |
SELECT *
FROM xf_node
WHERE display_in_list = 1
ORDER BY lft ASC
Run Time: 0.000105
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_node | ALL | display_in_list | | | | 16 | Using where; Using filesort |
SELECT content_id, cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = 'node'
Params: 1
Run Time: 0.000101
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 16 | Using where |
SELECT forum.*
,
NULL AS forum_read_date
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
WHERE forum.node_id IN (10, 11, 4, 5, 14, 6, 7, 13, 8, 15)
Run Time: 0.000127
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | forum | ALL | PRIMARY | | | | 14 | Using where |
| SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | vozer_net_53d0.forum.node_id | 1 | Using index |
SELECT session_activity.*
,
user.*
FROM xf_session_activity AS session_activity
LEFT JOIN xf_user AS user ON
(user.user_id = session_activity.user_id)
WHERE (user.visible = 1 OR session_activity.user_id = 0) AND (user.user_state = 'valid' OR session_activity.user_id = 0) AND (session_activity.view_date > 1603934416)
ORDER BY session_activity.view_date DESC
Run Time: 0.000647
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | session_activity | range | PRIMARY,view_date | view_date | 4 | | 52 | Using where |
| SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | vozer_net_53d0.session_activity.user_id | 1 | Using where |
SELECT thread.*
FROM xf_thread AS thread
WHERE thread.thread_id = ?
Params: 447
Run Time: 0.000297
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT thread.*
FROM xf_thread AS thread
WHERE thread.thread_id = ?
Params: 16
Run Time: 0.000201
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT thread.*
FROM xf_thread AS thread
WHERE thread.thread_id = ?
Params: 465
Run Time: 0.000127
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT thread.*
FROM xf_thread AS thread
WHERE thread.thread_id = ?
Params: 465
Run Time: 0.000102
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT thread.*
FROM xf_thread AS thread
WHERE thread.thread_id = ?
Params: 469
Run Time: 0.000138
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT thread.*
FROM xf_thread AS thread
WHERE thread.thread_id = ?
Params: 13
Run Time: 0.000099
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT thread.*
FROM xf_thread AS thread
WHERE thread.thread_id = ?
Params: 74
Run Time: 0.000097
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT *
FROM xf_node
WHERE lft > ? AND rgt < ?
ORDER BY lft ASC
Params: 14, 17
Run Time: 0.000132
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_node | ALL | lft | | | | 16 | Using where; Using filesort |
SELECT *
FROM xf_node
WHERE lft > ? AND rgt < ?
ORDER BY lft ASC
Params: 20, 23
Run Time: 0.000107
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_node | ALL | lft | | | | 16 | Using where; Using filesort |
SELECT session_activity.*
,
user.*
FROM xf_session_activity AS session_activity
LEFT JOIN xf_user AS user ON
(user.user_id = session_activity.user_id)
WHERE (session_activity.view_date > 1603934416)
ORDER BY session_activity.view_date DESC
Run Time: 0.000603
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | session_activity | range | view_date | view_date | 4 | | 52 | Using where |
| SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | vozer_net_53d0.session_activity.user_id | 1 | |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 6bfd343f9f9c93ff41f3d53fc363b920, , 1603941616
Run Time: 0.000170
INSERT INTO xf_session_activity
(user_id, unique_key, ip, controller_name, controller_action, view_state, params, view_date, robot_key)
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),
robot_key = VALUES(robot_key)
Params: 0, , , XenForo_ControllerPublic_Forum, Index, valid, node_name=, 1603938016,
Run Time: 0.000280
select value, hits
from dark_azucloud_terms_pages pages
left join dark_azucloud_terms terms on pages.term_id = terms.id
where route = ? and terms.block = 0 and terms.value is not null and last_clicked > ?
order by hits desc, last_clicked desc
limit ?
Params: forums/, 1601346016, 10
Run Time: 0.000322
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | pages | ref | term_id_route,route,route_hits_last_clicked | route_hits_last_clicked | 452 | const | 10 | Using where |
| SIMPLE | terms | eq_ref | PRIMARY,value,block | PRIMARY | 4 | vozer_net_53d0.pages.term_id | 1 | Using where |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'BRC_sidebar_visitor_panel_stats', 'BRC_navigation_visitor_tabs_end', 'node_forum_level_2', 'node_category_level_1', 'node_forum_level_n', 'wf_widget_wrapper', 'wf_widget_poll', 'wf_widget_stats', 'wf_widget_share_page', 'forum_list', 'dark_taigachat_links', 'cng_topx_main', 'wf_hook_moderator_bar', 'wf_revealer', 'dark_taigachat', 'dark_taigachat_list', 'threadrating_rate', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?Params: 2, 2
Run Time: 0.000221
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 19 | Using where |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('BRC_action_login', 'BRC_action_login_description', 'BRC_action_exchange', 'BRC_action_exchange_description', 'BRC_action_withdraw', 'BRC_action_withdraw_description', 'BRC_action_steal', 'BRC_action_steal_description', 'BRC_action_paypalPayment', 'BRC_action_paypalPayment_description', 'BRC_action_paypalPaymentRe', 'BRC_action_paypalPaymentRe_description', 'BRC_action_registration', 'BRC_action_registration_description', 'BRC_action_facebookAssociate', 'BRC_action_facebookAssociate_description', 'BRC_action_facebookDisassociate', 'BRC_action_facebookDisassociate_description', 'BRC_action_twitterAssociate', 'BRC_action_twitterAssociate_description', 'BRC_action_twitterDisassociate', 'BRC_action_twitterDisassociate_description', 'BRC_action_googleAssociate', 'BRC_action_googleAssociate_description', 'BRC_action_googleDisassociate', 'BRC_action_googleDisassociate_description', 'BRC_action_birthday', 'BRC_action_birthday_description', 'BRC_action_importVbb', 'BRC_action_importVbb_description', 'BRC_action_interest', 'BRC_action_interest_description', 'BRC_action_updateFullProfile', 'BRC_action_updateFullProfile_description', 'BRC_action_updateFullProfileRe', 'BRC_action_updateFullProfileRe_description', 'BRC_action_uploadAvatar', 'BRC_action_uploadAvatar_description', 'BRC_action_uploadAvatarRe', 'BRC_action_uploadAvatarRe_description', 'BRC_action_updateStatus', 'BRC_action_updateStatus_description', 'BRC_action_follow', 'BRC_action_follow_description', 'BRC_action_followRe', 'BRC_action_followRe_description', 'BRC_action_getFollower', 'BRC_action_getFollower_description', 'BRC_action_getFollowerRe', 'BRC_action_getFollowerRe_description', 'BRC_action_profilePost', 'BRC_action_profilePost_description', 'BRC_action_getProfilePost', 'BRC_action_getProfilePost_description', 'BRC_action_likeProfilePost', 'BRC_action_likeProfilePost_description', 'BRC_action_likeProfilePostRe', 'BRC_action_likeProfilePostRe_description', 'BRC_action_receiveProfilePostLike', 'BRC_action_receiveProfilePostLike_description', 'BRC_action_receiveProfilePostLikeRe', 'BRC_action_receiveProfilePostLikeRe_description', 'BRC_action_createConversation', 'BRC_action_createConversation_description', 'BRC_action_createConversationRe', 'BRC_action_createConversationRe_description', 'BRC_action_receiveConversation', 'BRC_action_receiveConversation_description', 'BRC_action_replyConversation', 'BRC_action_replyConversation_description', 'BRC_action_conversationGetReply', 'BRC_action_conversationGetReply_description', 'BRC_action_trophyReward', 'BRC_action_trophyReward_description', 'BRC_action_dailyReward', 'BRC_action_dailyReward_description', 'BRC_action_salary', 'BRC_action_salary_description', 'BRC_action_createNewThread', 'BRC_action_createNewThread_description', 'BRC_action_threadDeleted', 'BRC_action_threadDeleted_description', 'BRC_action_threadGetReply', 'BRC_action_threadGetReply_description', 'BRC_action_threadViewed', 'BRC_action_threadViewed_description', 'BRC_action_readThread', 'BRC_action_readThread_description', 'BRC_action_watchThread', 'BRC_action_watchThread_description', 'BRC_action_watchThreadRe', 'BRC_action_watchThreadRe_description', 'BRC_action_threadGetWatched', 'BRC_action_threadGetWatched_description', 'BRC_action_threadGetWatchedRe', 'BRC_action_threadGetWatchedRe_description', 'BRC_action_createNewPoll', 'BRC_action_createNewPoll_description', 'BRC_action_votePoll', 'BRC_action_votePoll_description', 'BRC_action_pollGetVote', 'BRC_action_pollGetVote_description', 'BRC_action_threadSticky', 'BRC_action_threadSticky_description', 'BRC_action_threadStickyRe', 'BRC_action_threadStickyRe_description', 'BRC_action_newPost', 'BRC_action_newPost_description', 'BRC_action_postDeleted', 'BRC_action_postDeleted_description', 'BRC_action_uploadAttachment', 'BRC_action_uploadAttachment_description', 'BRC_action_uploadAttachmentRe', 'BRC_action_uploadAttachmentRe_description', 'BRC_action_downloadAttachment', 'BRC_action_downloadAttachment_description', 'BRC_action_attachmentDownloaded', 'BRC_action_attachmentDownloaded_description', 'BRC_action_likePost', 'BRC_action_likePost_description', 'BRC_action_likePostRe', 'BRC_action_likePostRe_description', 'BRC_action_receivePostLike', 'BRC_action_receivePostLike_description', 'BRC_action_receivePostLikeRe', 'BRC_action_receivePostLikeRe_description', 'BRC_action_reportPost', 'BRC_action_reportPost_description', 'BRC_action_postReported', 'BRC_action_postReported_description', 'BRC_action_BRRS_referral', 'BRC_action_BRRS_referral_explain', 'BRC_action_BRRSBuyReferralTimes', 'BRC_action_BRRS_referralCredit', 'BRC_action_BRRS_referralCredit_explain', 'BRC_action_BRCIPurchaseUserUpgrade', 'BRC_action_BRCIPurchaseUserUpgrade_explain')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 | 106 | | 137 | Using where |
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: simpleCache, a:4:{s:7:"widgets";a:17:{i:1;a:9:{s:9:"widget_id";i:1;s:5:"title";s:0:"";s:5:"class";s:36:"WidgetFramework_WidgetRenderer_Empty";s:8:"position";s:10:"forum_list";s:13:"display_order";i:10;s:6:"active";i:1;s:7:"options";a:0:{}s:18:"template_for_hooks";a:0:{}s:14:"widget_page_id";i:0;}i:7;a:9:{s:9:"widget_id";i:7;s:5:"title";s:0:"";s:5:"class";s:36:"WidgetFramework_WidgetRenderer_Empty";s:8:"position";s:14:"member_notable";s:13:"display_order";i:10;s:6:"active";i:1;s:7:"options";a:0:{}s:18:"template_for_hooks";a:0:{}s:14:"widget_page_id";i:0;}i:16;a:9:{s:9:"widget_id";i:16;s:5:"title";s:17:"Sidebar ADS - Top";s:5:"class";s:49:"WidgetFramework_WidgetRenderer_HtmlWithoutWrapper";s:8:"position";s:23:"forum_list, thread_view";s:13:"display_order";i:15;s:6:"active";i:1;s:7:"options";a:7:{s:4:"html";s:452:"<div style="margin-top:8px">
<!-- Side-Ads -->
<ins class="adsbygoogle"
style="display:inline-block;width:300px;height:250px"
data-ad-client="ca-pub-3771029988310366"
data-ad-slot="1144999167"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
</div>
<div style="margin:10px 0 0 0">
<a href="https://vnbit.org/binance/" target="_blank">
<img src="https://i.imgur.com/Q0a2mv2.png" width="100%">
</a>
</div>";s:10:"expression";s:0:"";s:21:"deactivate_for_mobile";i:0;s:10:"layout_row";i:0;s:10:"layout_col";i:0;s:14:"layout_sizeRow";i:0;s:14:"layout_sizeCol";i:0;}s:18:"template_for_hooks";a:0:{}s:14:"widget_page_id";i:0;}i:17;a:9:{s:9:"widget_id";i:17;s:5:"title";s:13:"Fanpage Vozer";s:5:"class";s:35:"WidgetFramework_WidgetRenderer_Html";s:8:"position";s:10:"forum_list";s:13:"display_order";i:15;s:6:"active";i:1;s:7:"options";a:8:{s:4:"html";s:418:"<div class="fb-page" style="max-width:298px; width:298px" data-href="https://www.facebook.com/vozer.net/" data-tabs="timeline" data-height="400" data-small-header="false" data-adapt-container-width="true" data-hide-cover="false" data-show-facepile="true"><blockquote cite="https://www.facebook.com/vozer.net/" class="fb-xfbml-parse-ignore"><a href="https://www.facebook.com/vozer.net/">Vozer.net</a></blockquote></div>";s:9:"tab_group";s:0:"";s:10:"expression";s:0:"";s:21:"deactivate_for_mobile";i:1;s:10:"layout_row";i:0;s:10:"layout_col";i:0;s:14:"layout_sizeRow";i:0;s:14:"layout_sizeCol";i:0;}s:18:"template_for_hooks";a:0:{}s:14:"widget_page_id";i:0;}i:8;a:9:{s:9:"widget_id";i:8;s:5:"title";s:0:"";s:5:"class";s:40:"WidgetFramework_WidgetRenderer_UsersFind";s:8:"position";s:14:"member_notable";s:13:"display_order";i:20;s:6:"active";i:1;s:7:"options";a:0:{}s:18:"template_for_hooks";a:0:{}s:14:"widget_page_id";i:0;}i:13;a:9:{s:9:"widget_id";i:13;s:5:"title";s:26:"Sôi Động Nhất Tuần";s:5:"class";s:38:"WidgetFramework_WidgetRenderer_Threads";s:8:"position";s:11:"thread_view";s:13:"display_order";i:20;s:6:"active";i:1;s:7:"options";a:18:{s:4:"type";s:12:"most_replied";s:6:"cutoff";i:5;s:6:"forums";a:0:{}s:6:"sticky";s:0:"";s:8:"prefixes";a:0:{}s:9:"open_only";i:0;s:8:"as_guest";i:0;s:6:"is_new";i:0;s:5:"limit";i:5;s:6:"layout";s:0:"";s:9:"tab_group";s:0:"";s:13:"cache_seconds";s:0:"";s:10:"expression";s:0:"";s:21:"deactivate_for_mobile";i:0;s:10:"layout_row";i:0;s:10:"layout_col";i:0;s:14:"layout_sizeRow";i:0;s:14:"layout_sizeCol";i:0;}s:18:"template_for_hooks";a:0:{}s:14:"widget_page_id";i:0;}i:15;a:9:{s:9:"widget_id";i:15;s:5:"title";s:11:"Khảo Sát";s:5:"class";s:35:"WidgetFramework_WidgetRenderer_Poll";s:8:"position";s:10:"forum_list";s:13:"display_order";i:20;s:6:"active";i:1;s:7:"options";a:8:{s:9:"thread_id";s:6:"random";s:9:"open_only";i:0;s:10:"expression";s:0:"";s:21:"deactivate_for_mobile";i:0;s:10:"layout_row";i:0;s:10:"layout_col";i:0;s:14:"layout_sizeRow";i:0;s:14:"layout_sizeCol";i:0;}s:18:"template_for_hooks";a:0:{}s:14:"widget_page_id";i:0;}i:3;a:9:{s:9:"widget_id";i:3;s:5:"title";s:0:"";s:5:"class";s:42:"WidgetFramework_WidgetRenderer_OnlineUsers";s:8:"position";s:10:"forum_list";s:13:"display_order";i:30;s:6:"active";i:0;s:7:"options";a:0:{}s:18:"template_for_hooks";a:0:{}s:14:"widget_page_id";i:0;}i:6;a:9:{s:9:"widget_id";i:6;s:5:"title";s:0:"";s:5:"class";s:43:"WidgetFramework_WidgetRenderer_ProfilePosts";s:8:"position";s:11:"member_view";s:13:"display_order";i:30;s:6:"active";i:1;s:7:"options";a:10:{s:16:"show_update_form";s:1:"1";s:5:"limit";i:5;s:9:"tab_group";s:0:"";s:13:"cache_seconds";s:0:"";s:10:"expression";s:0:"";s:21:"deactivate_for_mobile";i:0;s:10:"layout_row";i:0;s:10:"layout_col";i:0;s:14:"layout_sizeRow";i:0;s:14:"layout_sizeCol";i:0;}s:18:"template_for_hooks";a:0:{}s:14:"widget_page_id";i:0;}i:9;a:9:{s:9:"widget_id";i:9;s:5:"title";s:0:"";s:5:"class";s:39:"WidgetFramework_WidgetRenderer_Birthday";s:8:"position";s:14:"member_notable";s:13:"display_order";i:30;s:6:"active";i:1;s:7:"options";a:0:{}s:18:"template_for_hooks";a:0:{}s:14:"widget_page_id";i:0;}i:12;a:9:{s:9:"widget_id";i:12;s:5:"title";s:25:"Xem Nhiều Nhất Tuần";s:5:"class";s:38:"WidgetFramework_WidgetRenderer_Threads";s:8:"position";s:11:"thread_view";s:13:"display_order";i:30;s:6:"active";i:1;s:7:"options";a:18:{s:4:"type";s:7:"popular";s:6:"cutoff";i:5;s:6:"forums";a:0:{}s:6:"sticky";s:0:"";s:8:"prefixes";a:0:{}s:9:"open_only";i:0;s:8:"as_guest";i:0;s:6:"is_new";i:0;s:5:"limit";i:5;s:6:"layout";s:0:"";s:9:"tab_group";s:0:"";s:13:"cache_seconds";s:0:"";s:10:"expression";s:0:"";s:21:"deactivate_for_mobile";i:0;s:10:"layout_row";i:0;s:10:"layout_col";i:0;s:14:"layout_sizeRow";i:0;s:14:"layout_sizeCol";i:0;}s:18:"template_for_hooks";a:0:{}s:14:"widget_page_id";i:0;}i:4;a:9:{s:9:"widget_id";i:4;s:5:"title";s:0:"";s:5:"class";s:36:"WidgetFramework_WidgetRenderer_Stats";s:8:"position";s:10:"forum_list";s:13:"display_order";i:40;s:6:"active";i:1;s:7:"options";a:0:{}s:18:"template_for_hooks";a:0:{}s:14:"widget_page_id";i:0;}i:10;a:9:{s:9:"widget_id";i:10;s:5:"title";s:0:"";s:5:"class";s:41:"WidgetFramework_WidgetRenderer_UsersStaff";s:8:"position";s:14:"member_notable";s:13:"display_order";i:40;s:6:"active";i:1;s:7:"options";a:0:{}s:18:"template_for_hooks";a:0:{}s:14:"widget_page_id";i:0;}i:14;a:9:{s:9:"widget_id";i:14;s:5:"title";s:28:"Thích Nhiều Nhất Tuần";s:5:"class";s:38:"WidgetFramework_WidgetRenderer_Threads";s:8:"position";s:11:"thread_view";s:13:"display_order";i:40;s:6:"active";i:1;s:7:"options";a:18:{s:4:"type";s:10:"most_liked";s:6:"cutoff";i:5;s:6:"forums";a:0:{}s:6:"sticky";s:0:"";s:8:"prefixes";a:0:{}s:9:"open_only";i:0;s:8:"as_guest";i:0;s:6:"is_new";i:0;s:5:"limit";i:5;s:6:"layout";s:0:"";s:9:"tab_group";s:0:"";s:13:"cache_seconds";s:0:"";s:10:"expression";s:0:"";s:21:"deactivate_for_mobile";i:0;s:10:"layout_row";i:0;s:10:"layout_col";i:0;s:14:"layout_sizeRow";i:0;s:14:"layout_sizeCol";i:0;}s:18:"template_for_hooks";a:0:{}s:14:"widget_page_id";i:0;}i:5;a:9:{s:9:"widget_id";i:5;s:5:"title";s:0:"";s:5:"class";s:44:"WidgetFramework_WidgetRenderer_ShareThisPage";s:8:"position";s:10:"forum_list";s:13:"display_order";i:50;s:6:"active";i:1;s:7:"options";a:0:{}s:18:"template_for_hooks";a:0:{}s:14:"widget_page_id";i:0;}i:11;a:9:{s:9:"widget_id";i:11;s:5:"title";s:0:"";s:5:"class";s:47:"WidgetFramework_WidgetRenderer_FacebookFacepile";s:8:"position";s:14:"member_notable";s:13:"display_order";i:50;s:6:"active";i:1;s:7:"options";a:0:{}s:18:"template_for_hooks";a:0:{}s:14:"widget_page_id";i:0;}i:18;a:9:{s:9:"widget_id";i:18;s:5:"title";s:20:"Sidebar ADS - Bottom";s:5:"class";s:49:"WidgetFramework_WidgetRenderer_HtmlWithoutWrapper";s:8:"position";s:86:"dark_taigachat_full, forum_list, member_notable, member_view, online_list, thread_view";s:13:"display_order";i:60;s:6:"active";i:1;s:7:"options";a:7:{s:4:"html";s:136:"<div id="cng-fixed" style="margin-top:8px">
<a href="https://vnbit.org/remitano/"><img src="https://i.imgur.com/fDYxShk.jpg"></a>
</div>";s:10:"expression";s:0:"";s:21:"deactivate_for_mobile";i:1;s:10:"layout_row";i:0;s:10:"layout_col";i:0;s:14:"layout_sizeRow";i:0;s:14:"layout_sizeCol";i:0;}s:18:"template_for_hooks";a:0:{}s:14:"widget_page_id";i:0;}}s:17:"invalidated_cache";a:18:{i:1;i:1584295770;i:2;i:1584299754;i:3;i:1585215737;i:6;i:1595664048;i:4;i:1584295772;i:5;i:1584295773;i:7;i:1584295774;i:8;i:1584295774;i:9;i:1603936798;i:10;i:1584295775;i:11;i:1584295775;i:12;i:1603710410;i:13;i:1603710410;i:14;i:1603710410;i:15;i:1603710410;i:16;i:1603518411;i:17;i:1589881837;i:18;i:1595664174;}s:16:"userUpgradeCount";i:4;s:20:"taigachat_lastUpdate";i:1603938016;}
Run Time: 0.000266
SELECT *
FROM xf_node
ORDER BY lft ASC
Run Time: 0.000106
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_node | ALL | | | | | 16 | Using filesort |
SELECT content_id, cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = 'node'
Params: 1
Run Time: 0.000078
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 16 | Using where |
SELECT thread.*
,
poll.*,
forum.*
FROM xf_thread AS thread
LEFT JOIN xf_poll AS poll ON
(poll.content_type = 'thread' AND content_id = thread.thread_id)
INNER JOIN xf_forum AS forum ON
(forum.node_id = thread.node_id)
WHERE ((thread.node_id IN (9, 10, 11, 1, 4, 5, 14, 6, 7, 13, 2, 8, 15)) AND (thread.discussion_state IN ('visible'))) AND (thread.discussion_type = 'poll')
ORDER BY RAND()
LIMIT 3Run Time: 0.001456
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | forum | ALL | PRIMARY | | | | 14 | Using temporary; Using filesort |
| SIMPLE | thread | ref | node_id_last_post_date,node_id_sticky_state_last_post | node_id_last_post_date | 4 | vozer_net_53d0.forum.node_id | 8 | Using index condition; Using where |
| SIMPLE | poll | eq_ref | content_type_content_id | content_type_content_id | 31 | const,vozer_net_53d0.thread.thread_id | 1 | Using where |
SELECT *
FROM xf_poll
WHERE content_type = ?
AND content_id = ?
Params: thread, 12
Run Time: 0.000088
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_poll | const | content_type_content_id | content_type_content_id | 31 | const,const | 1 | |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 10
Run Time: 0.000068
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('forum_statistics')Params: 2
Run Time: 0.000069
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 | |