SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('options', 'languages', 'contentTypes', 'codeEventListeners', 'deferredRun', 'simpleCache', 'addOns', 'defaultStyleProperties', 'routeFiltersIn', 'routeFiltersOut', 'routesPublic', 'nodeTypes', 'bannedIps', 'discouragedIps', 'styles', 'displayStyles', 'userBanners', 'smilies', 'bbCode', 'threadPrefixes', 'userTitleLadder', 'reportCounts', 'moderationCounts', 'userModerationCounts', 'notices', 'userFieldsInfo')
Run Time: 0.001064
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | ALL | PRIMARY | | | | 34 | Using where |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000283
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT user_point.*
FROM xf_user_point AS user_point
WHERE 1=1
Run Time: 0.008823
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user_point | ALL | | | | | 10778 | |
SELECT thread.*
,
user.gender, user.avatar_date, user.gravatar,
NULL AS thread_read_date,
0 AS thread_reply_banned,
0 AS thread_is_watched,
'' AS draft_message, NULL AS draft_extra
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
WHERE thread.thread_id = ?
Params: 18138
Run Time: 0.001188
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
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: 215
Run Time: 0.000800
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | permission | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT post.*
,
user.*, IF(user.username IS NULL, post.username, user.username) AS username,
user_profile.*,
user_privacy.*,
session_activity.view_date AS last_view_date,
0 AS like_date
FROM xf_post AS post
LEFT JOIN xf_user AS user ON
(user.user_id = post.user_id)
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = post.user_id)
LEFT JOIN xf_user_privacy AS user_privacy ON
(user_privacy.user_id = post.user_id)
LEFT JOIN xf_session_activity AS session_activity ON
(post.user_id > 0 AND session_activity.user_id = post.user_id AND session_activity.unique_key = CAST(post.user_id AS BINARY))
WHERE post.thread_id = ?
AND (post.position >= 0 AND post.position < 20)
AND (post.message_state IN ('visible'))
ORDER BY post.position ASC, post.post_date ASC
Params: 18138
Run Time: 0.003037
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | post | ref | thread_id_post_date,thread_id_position | thread_id_post_date | 4 | const | 1 | Using where; Using filesort |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | dien7104_tailieu.post.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | dien7104_tailieu.post.user_id | 1 | |
SIMPLE | user_privacy | eq_ref | PRIMARY | PRIMARY | 4 | dien7104_tailieu.post.user_id | 1 | |
SIMPLE | session_activity | eq_ref | PRIMARY | PRIMARY | 22 | dien7104_tailieu.post.user_id,func | 1 | Using where |
INSERT DELAYED INTO xf_thread_view
(thread_id)
VALUES
(?)
Params: 18138
Run Time: 0.000249
SELECT *
FROM xf_brivium_extra_thread_item
WHERE thread_id = ? AND user_id = ?
Params: 18138, 0
Run Time: 0.397116
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_brivium_extra_thread_item | ALL | | | | | 24912 | Using where |
SELECT thread.*
FROM xf_thread AS thread
WHERE ((thread.discussion_type <> 'redirect') AND (thread.discussion_state = 'visible') AND (thread.post_date < 1653536823)) AND (thread.thread_id <> 18138)
ORDER BY thread.post_date DESC
LIMIT 5
Run Time: 0.001084
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY,post_date | post_date | 4 | | 11850 | Using where |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 153
Run Time: 0.000219
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 cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 151
Run Time: 0.000205
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 cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 150
Run Time: 0.000171
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 cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 211
Run Time: 0.000205
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 cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 141
Run Time: 0.000171
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 thread.*
FROM xf_thread AS thread
WHERE ((thread.discussion_type <> 'redirect') AND (thread.discussion_state = 'visible') AND (thread.post_date > 1653536823)) AND (thread.thread_id <> 18138)
ORDER BY thread.post_date ASC
LIMIT 5
Run Time: 0.000425
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY,post_date | post_date | 4 | | 6701 | Using index condition; Using where |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 242
Run Time: 0.000180
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 thread.*
FROM xf_thread AS thread
WHERE ((thread.discussion_type <> 'redirect') AND (thread.discussion_state = 'visible')) AND (thread.thread_id <> 18138)
ORDER BY thread.post_date DESC
LIMIT 5
Run Time: 0.000345
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | index | PRIMARY | post_date | 4 | | 5 | Using where |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 196
Run Time: 0.000192
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 cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 28
Run Time: 0.000170
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 cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 210
Run Time: 0.000181
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 cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 217
Run Time: 0.000172
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 cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 19
Run Time: 0.000316
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 | |
UPDATE `xf_brivium_extra_thread_item` SET `date_update` = ?, `extra_cache` = ? WHERE (thread_id = 18138 AND user_id = 0)
Params: 1713461379, a:3:{s:12:"olderThreads";a:5:{i:18137;a:22:{s:9:"thread_id";i:18137;s:7:"node_id";i:153;s:5:"title";s:76:"Simple writing 5, em học kỹ năng viết tiếng Anh thật đơn giản";s:11:"reply_count";i:0;s:10:"view_count";i:829;s:7:"user_id";i:3305;s:8:"username";s:9:"mod_luong";s:9:"post_date";i:1653445929;s:6:"sticky";i:0;s:16:"discussion_state";s:7:"visible";s:15:"discussion_open";i:1;s:15:"discussion_type";s:0:"";s:13:"first_post_id";i:20604;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1653445929;s:12:"last_post_id";i:20604;s:17:"last_post_user_id";i:3305;s:18:"last_post_username";s:9:"mod_luong";s:9:"prefix_id";i:2;s:4:"tags";s:368:"a:5:{i:5834;a:2:{s:3:"tag";s:7:"grade 5";s:7:"tag_url";s:7:"grade-5";}i:12757;a:2:{s:3:"tag";s:11:"kid writing";s:7:"tag_url";s:11:"kid-writing";}i:16165;a:2:{s:3:"tag";s:14:"simple writing";s:7:"tag_url";s:14:"simple-writing";}i:8580;a:2:{s:3:"tag";s:11:"tieng anh 5";s:7:"tag_url";s:11:"tieng-anh-5";}i:330;a:2:{s:3:"tag";s:7:"writing";s:7:"tag_url";s:7:"writing";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:18136;a:22:{s:9:"thread_id";i:18136;s:7:"node_id";i:151;s:5:"title";s:76:"Simple writing 4, em học kỹ năng viết tiếng Anh thật đơn giản";s:11:"reply_count";i:0;s:10:"view_count";i:857;s:7:"user_id";i:3305;s:8:"username";s:9:"mod_luong";s:9:"post_date";i:1653445807;s:6:"sticky";i:0;s:16:"discussion_state";s:7:"visible";s:15:"discussion_open";i:1;s:15:"discussion_type";s:0:"";s:13:"first_post_id";i:20603;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1653445807;s:12:"last_post_id";i:20603;s:17:"last_post_user_id";i:3305;s:18:"last_post_username";s:9:"mod_luong";s:9:"prefix_id";i:2;s:4:"tags";s:304:"a:4:{i:2993;a:2:{s:3:"tag";s:7:"grade 4";s:7:"tag_url";s:7:"grade-4";}i:12757;a:2:{s:3:"tag";s:11:"kid writing";s:7:"tag_url";s:11:"kid-writing";}i:16165;a:2:{s:3:"tag";s:14:"simple writing";s:7:"tag_url";s:14:"simple-writing";}i:4740;a:2:{s:3:"tag";s:11:"tieng anh 4";s:7:"tag_url";s:11:"tieng-anh-4";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:18135;a:22:{s:9:"thread_id";i:18135;s:7:"node_id";i:150;s:5:"title";s:76:"Simple writing 3, em học kỹ năng viết tiếng Anh thật đơn giản";s:11:"reply_count";i:0;s:10:"view_count";i:1070;s:7:"user_id";i:3305;s:8:"username";s:9:"mod_luong";s:9:"post_date";i:1653445657;s:6:"sticky";i:0;s:16:"discussion_state";s:7:"visible";s:15:"discussion_open";i:1;s:15:"discussion_type";s:0:"";s:13:"first_post_id";i:20602;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1653445657;s:12:"last_post_id";i:20602;s:17:"last_post_user_id";i:3305;s:18:"last_post_username";s:9:"mod_luong";s:9:"prefix_id";i:2;s:4:"tags";s:367:"a:5:{i:87;a:2:{s:3:"tag";s:7:"english";s:7:"tag_url";s:7:"english";}i:4177;a:2:{s:3:"tag";s:7:"grade 3";s:7:"tag_url";s:7:"grade-3";}i:12757;a:2:{s:3:"tag";s:11:"kid writing";s:7:"tag_url";s:11:"kid-writing";}i:16165;a:2:{s:3:"tag";s:14:"simple writing";s:7:"tag_url";s:14:"simple-writing";}i:6065;a:2:{s:3:"tag";s:11:"tieng anh 3";s:7:"tag_url";s:11:"tieng-anh-3";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:18134;a:22:{s:9:"thread_id";i:18134;s:7:"node_id";i:211;s:5:"title";s:82:"Tiếng Đức học trong 3 tháng dễ dàng và nhanh chóng, Sigrid, B. Martin";s:11:"reply_count";i:0;s:10:"view_count";i:622;s:7:"user_id";i:3305;s:8:"username";s:9:"mod_luong";s:9:"post_date";i:1653391922;s:6:"sticky";i:0;s:16:"discussion_state";s:7:"visible";s:15:"discussion_open";i:1;s:15:"discussion_type";s:0:"";s:13:"first_post_id";i:20598;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1653391922;s:12:"last_post_id";i:20598;s:17:"last_post_user_id";i:3305;s:18:"last_post_username";s:9:"mod_luong";s:9:"prefix_id";i:2;s:4:"tags";s:402:"a:6:{i:12710;a:2:{s:3:"tag";s:7:"3 thang";s:7:"tag_url";s:7:"3-thang";}i:16164;a:2:{s:3:"tag";s:9:"b. martin";s:7:"tag_url";s:8:"b-martin";}i:4830;a:2:{s:3:"tag";s:7:"deutsch";s:7:"tag_url";s:7:"deutsch";}i:1688;a:2:{s:3:"tag";s:6:"german";s:7:"tag_url";s:6:"german";}i:16163;a:2:{s:3:"tag";s:6:"sigrid";s:7:"tag_url";s:6:"sigrid";}i:2391;a:2:{s:3:"tag";s:9:"tieng duc";s:7:"tag_url";s:9:"tieng-duc";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:18133;a:22:{s:9:"thread_id";i:18133;s:7:"node_id";i:141;s:5:"title";s:89:"Quy hoạch thực nghiệm trong kỹ thuật, Nguyễn Văn Dự, Nguyễn Đăng Bình";s:11:"reply_count";i:0;s:10:"view_count";i:484;s:7:"user_id";i:3305;s:8:"username";s:9:"mod_luong";s:9:"post_date";i:1653390991;s:6:"sticky";i:0;s:16:"discussion_state";s:7:"visible";s:15:"discussion_open";i:1;s:15:"discussion_type";s:0:"";s:13:"first_post_id";i:20597;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1653390991;s:12:"last_post_id";i:20597;s:17:"last_post_user_id";i:3305;s:18:"last_post_username";s:9:"mod_luong";s:9:"prefix_id";i:2;s:4:"tags";s:476:"a:6:{i:1891;a:2:{s:3:"tag";s:8:"ky thuat";s:7:"tag_url";s:8:"ky-thuat";}i:16162;a:2:{s:3:"tag";s:16:"nguyen dang binh";s:7:"tag_url";s:16:"nguyen-dang-binh";}i:9647;a:2:{s:3:"tag";s:13:"nguyen van du";s:7:"tag_url";s:13:"nguyen-van-du";}i:1324;a:2:{s:3:"tag";s:9:"quy hoach";s:7:"tag_url";s:9:"quy-hoach";}i:16161;a:2:{s:3:"tag";s:21:"quy hoach thuc nghiem";s:7:"tag_url";s:21:"quy-hoach-thuc-nghiem";}i:1756;a:2:{s:3:"tag";s:10:"thi nghiem";s:7:"tag_url";s:10:"thi-nghiem";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}}s:12:"newerThreads";a:5:{i:18139;a:22:{s:9:"thread_id";i:18139;s:7:"node_id";i:215;s:5:"title";s:32:"Speak now itools Level 2, Oxford";s:11:"reply_count";i:0;s:10:"view_count";i:505;s:7:"user_id";i:1;s:8:"username";s:5:"admin";s:9:"post_date";i:1653536893;s:6:"sticky";i:0;s:16:"discussion_state";s:7:"visible";s:15:"discussion_open";i:1;s:15:"discussion_type";s:0:"";s:13:"first_post_id";i:20606;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1653536893;s:12:"last_post_id";i:20606;s:17:"last_post_user_id";i:1;s:18:"last_post_username";s:5:"admin";s:9:"prefix_id";i:32;s:4:"tags";s:442:"a:6:{i:5248;a:2:{s:3:"tag";s:16:"english speaking";s:7:"tag_url";s:16:"english-speaking";}i:2690;a:2:{s:3:"tag";s:6:"itools";s:7:"tag_url";s:6:"itools";}i:428;a:2:{s:3:"tag";s:6:"oxford";s:7:"tag_url";s:6:"oxford";}i:1222;a:2:{s:3:"tag";s:9:"speak now";s:7:"tag_url";s:9:"speak-now";}i:619;a:2:{s:3:"tag";s:8:"speaking";s:7:"tag_url";s:8:"speaking";}i:4345;a:2:{s:3:"tag";s:19:"tieng anh giao tiep";s:7:"tag_url";s:19:"tieng-anh-giao-tiep";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:18140;a:22:{s:9:"thread_id";i:18140;s:7:"node_id";i:215;s:5:"title";s:32:"Speak now Itools Level 3, Oxford";s:11:"reply_count";i:0;s:10:"view_count";i:679;s:7:"user_id";i:1;s:8:"username";s:5:"admin";s:9:"post_date";i:1653536941;s:6:"sticky";i:0;s:16:"discussion_state";s:7:"visible";s:15:"discussion_open";i:1;s:15:"discussion_type";s:0:"";s:13:"first_post_id";i:20607;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1653536941;s:12:"last_post_id";i:20607;s:17:"last_post_user_id";i:1;s:18:"last_post_username";s:5:"admin";s:9:"prefix_id";i:32;s:4:"tags";s:442:"a:6:{i:5248;a:2:{s:3:"tag";s:16:"english speaking";s:7:"tag_url";s:16:"english-speaking";}i:2690;a:2:{s:3:"tag";s:6:"itools";s:7:"tag_url";s:6:"itools";}i:428;a:2:{s:3:"tag";s:6:"oxford";s:7:"tag_url";s:6:"oxford";}i:1222;a:2:{s:3:"tag";s:9:"speak now";s:7:"tag_url";s:9:"speak-now";}i:619;a:2:{s:3:"tag";s:8:"speaking";s:7:"tag_url";s:8:"speaking";}i:4345;a:2:{s:3:"tag";s:19:"tieng anh giao tiep";s:7:"tag_url";s:19:"tieng-anh-giao-tiep";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:18141;a:22:{s:9:"thread_id";i:18141;s:7:"node_id";i:215;s:5:"title";s:32:"Speak now Itools Level 4, Oxford";s:11:"reply_count";i:0;s:10:"view_count";i:417;s:7:"user_id";i:1;s:8:"username";s:5:"admin";s:9:"post_date";i:1653536988;s:6:"sticky";i:0;s:16:"discussion_state";s:7:"visible";s:15:"discussion_open";i:1;s:15:"discussion_type";s:0:"";s:13:"first_post_id";i:20608;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1653536988;s:12:"last_post_id";i:20608;s:17:"last_post_user_id";i:1;s:18:"last_post_username";s:5:"admin";s:9:"prefix_id";i:32;s:4:"tags";s:442:"a:6:{i:5248;a:2:{s:3:"tag";s:16:"english speaking";s:7:"tag_url";s:16:"english-speaking";}i:2690;a:2:{s:3:"tag";s:6:"itools";s:7:"tag_url";s:6:"itools";}i:428;a:2:{s:3:"tag";s:6:"oxford";s:7:"tag_url";s:6:"oxford";}i:1222;a:2:{s:3:"tag";s:9:"speak now";s:7:"tag_url";s:9:"speak-now";}i:619;a:2:{s:3:"tag";s:8:"speaking";s:7:"tag_url";s:8:"speaking";}i:4345;a:2:{s:3:"tag";s:19:"tieng anh giao tiep";s:7:"tag_url";s:19:"tieng-anh-giao-tiep";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:18142;a:22:{s:9:"thread_id";i:18142;s:7:"node_id";i:242;s:5:"title";s:99:"The complete Turtle Trader, The Legend, the lessons, the results, Michael W. Covel, trend following";s:11:"reply_count";i:0;s:10:"view_count";i:649;s:7:"user_id";i:1;s:8:"username";s:5:"admin";s:9:"post_date";i:1653539411;s:6:"sticky";i:0;s:16:"discussion_state";s:7:"visible";s:15:"discussion_open";i:1;s:15:"discussion_type";s:0:"";s:13:"first_post_id";i:20609;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1653539411;s:12:"last_post_id";i:20609;s:17:"last_post_user_id";i:1;s:18:"last_post_username";s:5:"admin";s:9:"prefix_id";i:2;s:4:"tags";s:509:"a:7:{i:180;a:2:{s:3:"tag";s:7:"finance";s:7:"tag_url";s:7:"finance";}i:16167;a:2:{s:3:"tag";s:16:"michael w. covel";s:7:"tag_url";s:15:"michael-w-covel";}i:2832;a:2:{s:3:"tag";s:5:"stock";s:7:"tag_url";s:5:"stock";}i:10691;a:2:{s:3:"tag";s:6:"trader";s:7:"tag_url";s:6:"trader";}i:2833;a:2:{s:3:"tag";s:7:"trading";s:7:"tag_url";s:7:"trading";}i:16168;a:2:{s:3:"tag";s:15:"trend following";s:7:"tag_url";s:15:"trend-following";}i:16166;a:2:{s:3:"tag";s:13:"turtle trader";s:7:"tag_url";s:13:"turtle-trader";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:18143;a:22:{s:9:"thread_id";i:18143;s:7:"node_id";i:242;s:5:"title";s:76:"Mathematics of Finance, An Intuitive Introduction, Donald G. Saari, Springer";s:11:"reply_count";i:0;s:10:"view_count";i:450;s:7:"user_id";i:1;s:8:"username";s:5:"admin";s:9:"post_date";i:1653539677;s:6:"sticky";i:0;s:16:"discussion_state";s:7:"visible";s:15:"discussion_open";i:1;s:15:"discussion_type";s:0:"";s:13:"first_post_id";i:20610;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1653539677;s:12:"last_post_id";i:20610;s:17:"last_post_user_id";i:1;s:18:"last_post_username";s:5:"admin";s:9:"prefix_id";i:2;s:4:"tags";s:393:"a:5:{i:16169;a:2:{s:3:"tag";s:15:"donald g. saari";s:7:"tag_url";s:14:"donald-g-saari";}i:180;a:2:{s:3:"tag";s:7:"finance";s:7:"tag_url";s:7:"finance";}i:1000;a:2:{s:3:"tag";s:11:"mathematics";s:7:"tag_url";s:11:"mathematics";}i:16170;a:2:{s:3:"tag";s:22:"mathematics of finance";s:7:"tag_url";s:22:"mathematics-of-finance";}i:2890;a:2:{s:3:"tag";s:8:"springer";s:7:"tag_url";s:8:"springer";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}}s:13:"latestThreads";a:5:{i:25384;a:22:{s:9:"thread_id";i:25384;s:7:"node_id";i:196;s:5:"title";s:133:"Tuyển chọn đề thi toán vào lớp 10 của một số trường chuyên và chất lượng cao, có đáp án chi tiết, Ng";s:11:"reply_count";i:0;s:10:"view_count";i:0;s:7:"user_id";i:96834;s:8:"username";s:7:"Mod_QAn";s:9:"post_date";i:1713460724;s:6:"sticky";i:0;s:16:"discussion_state";s:7:"visible";s:15:"discussion_open";i:1;s:15:"discussion_type";s:0:"";s:13:"first_post_id";i:30322;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1713460724;s:12:"last_post_id";i:30322;s:17:"last_post_user_id";i:96834;s:18:"last_post_username";s:7:"Mod_QAn";s:9:"prefix_id";i:2;s:4:"tags";s:752:"a:9:{i:8869;a:2:{s:3:"tag";s:14:"chat luong cao";s:7:"tag_url";s:14:"chat-luong-cao";}i:11260;a:2:{s:3:"tag";s:11:"chuyen toan";s:7:"tag_url";s:11:"chuyen-toan";}i:22070;a:2:{s:3:"tag";s:20:"nguyen thi quynh mai";s:7:"tag_url";s:20:"nguyen-thi-quynh-mai";}i:11597;a:2:{s:3:"tag";s:16:"nguyen van thanh";s:7:"tag_url";s:16:"nguyen-van-thanh";}i:22068;a:2:{s:3:"tag";s:18:"nguyen xuan nguyen";s:7:"tag_url";s:18:"nguyen-xuan-nguyen";}i:8813;a:2:{s:3:"tag";s:17:"on thi vao lop 10";s:7:"tag_url";s:17:"on-thi-vao-lop-10";}i:22069;a:2:{s:3:"tag";s:21:"phung thi thuy nguyen";s:7:"tag_url";s:21:"phung-thi-thuy-nguyen";}i:8512;a:2:{s:3:"tag";s:6:"toan 9";s:7:"tag_url";s:6:"toan-9";}i:8079;a:2:{s:3:"tag";s:10:"tuyen chon";s:7:"tag_url";s:10:"tuyen-chon";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:25383;a:22:{s:9:"thread_id";i:25383;s:7:"node_id";i:28;s:5:"title";s:104:"Phương pháp rèn luyện bộ não tập trung tức thì, Kenichiro Mogi, Hoàng Thị Hồng dịch";s:11:"reply_count";i:1;s:10:"view_count";i:0;s:7:"user_id";i:96834;s:8:"username";s:7:"Mod_QAn";s:9:"post_date";i:1713460381;s:6:"sticky";i:0;s:16:"discussion_state";s:7:"visible";s:15:"discussion_open";i:1;s:15:"discussion_type";s:0:"";s:13:"first_post_id";i:30320;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1713460389;s:12:"last_post_id";i:30321;s:17:"last_post_user_id";i:96834;s:18:"last_post_username";s:7:"Mod_QAn";s:9:"prefix_id";i:2;s:4:"tags";s:379:"a:5:{i:22067;a:2:{s:3:"tag";s:14:"hoang thi hong";s:7:"tag_url";s:14:"hoang-thi-hong";}i:22065;a:2:{s:3:"tag";s:14:"kenichiro mogi";s:7:"tag_url";s:14:"kenichiro-mogi";}i:11042;a:2:{s:3:"tag";s:6:"nao bo";s:7:"tag_url";s:6:"nao-bo";}i:2063;a:2:{s:3:"tag";s:11:"phuong phap";s:7:"tag_url";s:11:"phuong-phap";}i:22066;a:2:{s:3:"tag";s:9:"tap trung";s:7:"tag_url";s:9:"tap-trung";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:25382;a:22:{s:9:"thread_id";i:25382;s:7:"node_id";i:210;s:5:"title";s:87:"Những vấn đề ngữ pháp tiếng Việt hiện đại, Giáo Sư Lưu Vân Lăng";s:11:"reply_count";i:1;s:10:"view_count";i:0;s:7:"user_id";i:96834;s:8:"username";s:7:"Mod_QAn";s:9:"post_date";i:1713459938;s:6:"sticky";i:0;s:16:"discussion_state";s:7:"visible";s:15:"discussion_open";i:1;s:15:"discussion_type";s:0:"";s:13:"first_post_id";i:30318;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1713460048;s:12:"last_post_id";i:30319;s:17:"last_post_user_id";i:96834;s:18:"last_post_username";s:7:"Mod_QAn";s:9:"prefix_id";i:2;s:4:"tags";s:415:"a:5:{i:22064;a:2:{s:3:"tag";s:12:"luu van lang";s:7:"tag_url";s:12:"luu-van-lang";}i:7900;a:2:{s:3:"tag";s:12:"ngon ngu hoc";s:7:"tag_url";s:12:"ngon-ngu-hoc";}i:12220;a:2:{s:3:"tag";s:19:"ngu phap tieng viet";s:7:"tag_url";s:19:"ngu-phap-tieng-viet";}i:572;a:2:{s:3:"tag";s:10:"tieng viet";s:7:"tag_url";s:10:"tieng-viet";}i:13887;a:2:{s:3:"tag";s:18:"vietnamese grammar";s:7:"tag_url";s:18:"vietnamese-grammar";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:25381;a:22:{s:9:"thread_id";i:25381;s:7:"node_id";i:217;s:5:"title";s:117:"Các lỗi thường gặp trong ngữ pháp tiếng Anh, Ngô Quốc Ân, Common mistakes in English Grammar and how";s:11:"reply_count";i:0;s:10:"view_count";i:0;s:7:"user_id";i:96834;s:8:"username";s:7:"Mod_QAn";s:9:"post_date";i:1713459495;s:6:"sticky";i:0;s:16:"discussion_state";s:7:"visible";s:15:"discussion_open";i:1;s:15:"discussion_type";s:0:"";s:13:"first_post_id";i:30317;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1713459495;s:12:"last_post_id";i:30317;s:17:"last_post_user_id";i:96834;s:18:"last_post_username";s:7:"Mod_QAn";s:9:"prefix_id";i:2;s:4:"tags";s:313:"a:4:{i:4020;a:2:{s:3:"tag";s:15:"common mistakes";s:7:"tag_url";s:15:"common-mistakes";}i:3849;a:2:{s:3:"tag";s:15:"english grammar";s:7:"tag_url";s:15:"english-grammar";}i:1516;a:2:{s:3:"tag";s:7:"mistake";s:7:"tag_url";s:7:"mistake";}i:22063;a:2:{s:3:"tag";s:11:"ngo quoc an";s:7:"tag_url";s:11:"ngo-quoc-an";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:25380;a:22:{s:9:"thread_id";i:25380;s:7:"node_id";i:19;s:5:"title";s:60:"Chiêu bài quản lý vàng của Bill Gates, Thương Mỗ";s:11:"reply_count";i:0;s:10:"view_count";i:0;s:7:"user_id";i:96834;s:8:"username";s:7:"Mod_QAn";s:9:"post_date";i:1713459046;s:6:"sticky";i:0;s:16:"discussion_state";s:7:"visible";s:15:"discussion_open";i:1;s:15:"discussion_type";s:0:"";s:13:"first_post_id";i:30316;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1713459046;s:12:"last_post_id";i:30316;s:17:"last_post_user_id";i:96834;s:18:"last_post_username";s:7:"Mod_QAn";s:9:"prefix_id";i:2;s:4:"tags";s:424:"a:6:{i:1202;a:2:{s:3:"tag";s:8:"bi quyet";s:7:"tag_url";s:8:"bi-quyet";}i:22060;a:2:{s:3:"tag";s:10:"bill gates";s:7:"tag_url";s:10:"bill-gates";}i:22061;a:2:{s:3:"tag";s:9:"billgates";s:7:"tag_url";s:9:"billgates";}i:2169;a:2:{s:3:"tag";s:10:"kinh doanh";s:7:"tag_url";s:10:"kinh-doanh";}i:649;a:2:{s:3:"tag";s:7:"quan ly";s:7:"tag_url";s:7:"quan-ly";}i:22062;a:2:{s:3:"tag";s:9:"thuong mo";s:7:"tag_url";s:9:"thuong-mo";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}}}
Run Time: 0.876645
SELECT thread.*
,
MATCH(search_index.title) AGAINST ('Speak now Itools Level 1, Oxford' IN BOOLEAN MODE) AS similar_score
FROM xf_search_index AS search_index
LEFT JOIN xf_thread AS thread ON (thread.thread_id=search_index.content_id)
WHERE ((thread.discussion_type <> 'redirect') AND (thread.discussion_state = 'visible')) AND (thread.thread_id <> 18138)
AND MATCH(search_index.title) AGAINST ('Speak now Itools Level 1, Oxford' IN BOOLEAN MODE)
AND search_index.content_type='thread'
HAVING similar_score >= 1
ORDER BY similar_score
LIMIT 5
Run Time: 0.282754
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | search_index | ref | PRIMARY | PRIMARY | 77 | const | 497 | Using index condition; Using where; Using temporary; Using filesort |
SIMPLE | thread | eq_ref | PRIMARY | PRIMARY | 4 | dien7104_tailieu.search_index.content_id | 1 | Using where |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 7
Run Time: 0.000297
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 cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 17
Run Time: 0.000255
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 cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 85
Run Time: 0.000246
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 cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 62
Run Time: 0.000238
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 thread.thread_id
FROM xf_thread AS thread
WHERE ((thread.discussion_type <> 'redirect') AND (thread.discussion_state = 'visible')) AND (thread.thread_id <> 18138)
ORDER BY RAND()
LIMIT 5
Run Time: 0.017777
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | ALL | PRIMARY | | | | 23700 | Using where; Using temporary; Using filesort |
SELECT thread.*
,
user.*, IF(user.username IS NULL, thread.username, user.username) AS username
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
WHERE ((thread.discussion_type <> 'redirect') AND (thread.discussion_state = 'visible')) AND (thread.thread_id IN (619, 18822, 24218, 2960, 5878))
ORDER BY thread.post_date DESC
LIMIT 5
Run Time: 0.000898
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 5 | Using where; Using filesort |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | dien7104_tailieu.thread.user_id | 1 | |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 302
Run Time: 0.000232
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 cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 306
Run Time: 0.000204
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 cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 26
Run Time: 0.000197
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 post_links.*
FROM xf_post_links AS post_links
WHERE (post_links.thread_id = 18138)
Run Time: 0.024239
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | post_links | ALL | | | | | 25461 | Using where |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: d6e8533ac501bd5a2c9266564809edc4, a:7:{s:12:"sessionStart";i:1713461379;s:2:"ip";s:4:"uĸ";s:11:"sessionCsrf";s:16:"pfWQshuPnnqdfdKK";s:9:"userAgent";s:9:"claudebot";s:7:"robotId";s:0:"";s:16:"previousActivity";i:0;s:10:"isIpBanned";a:2:{s:6:"result";b:0;s:7:"version";i:1587171455;}}, 1713464979
Run Time: 0.000229
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, uĸ, uĸ, XenForo_ControllerPublic_Thread, Index, valid, thread_id=18138, 1713461379,
Run Time: 0.000207
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'bb_code_tag_code', 'bb_code_tag_php', 'bb_code_tag_html', 'bb_code_tag_quote', 'bb_code_tag_attach', 'bb_code_tag_spoiler', 'BRETI_message_below', 'thread_view', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 3, 2
Run Time: 0.000853
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 10 | Using where |
SELECT adv.*
FROM xf_advertisement AS adv
WHERE (adv.active = 1) AND (adv.positive = 1)
Run Time: 0.000508
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | adv | ALL | | | | | 5 | Using where |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('tailieu_advertisement_top')
AND style_id = ?
AND language_id = ?
Params: 3, 2
Run Time: 0.000310
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |
SELECT adv.*
FROM xf_advertisement AS adv
WHERE (adv.active = 1) AND (adv.positive = 3)
Run Time: 0.000348
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | adv | ALL | | | | | 5 | Using where |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('tailieu_advertisement_bottom')
AND style_id = ?
AND language_id = ?
Params: 3, 2
Run Time: 0.000264
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |