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.196790
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.002256
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.032308
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user_point | ALL | | | | | 10890 | |
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: 18951
Run Time: 0.002747
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: 156
Run Time: 0.004238
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: 18951
Run Time: 0.034317
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: 18951
Run Time: 0.000276
SELECT *
FROM xf_brivium_extra_thread_item
WHERE thread_id = ? AND user_id = ?
Params: 18951, 0
Run Time: 0.881315
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_brivium_extra_thread_item | ALL | | | | | 25041 | Using where |
SELECT thread.*
FROM xf_thread AS thread
WHERE ((thread.discussion_type <> 'redirect') AND (thread.discussion_state = 'visible') AND (thread.post_date < 1661062545)) AND (thread.thread_id <> 18951)
ORDER BY thread.post_date DESC
LIMIT 5
Run Time: 0.024464
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY,post_date | post_date | 4 | | 12758 | Using where |
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.002220
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.001364
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, 136
Run Time: 0.000951
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.000365
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, 57
Run Time: 0.000786
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 > 1661062545)) AND (thread.thread_id <> 18951)
ORDER BY thread.post_date ASC
LIMIT 5
Run Time: 0.003724
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY,post_date | post_date | 4 | | 6069 | 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, 240
Run Time: 0.000859
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, 207
Run Time: 0.000341
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, 218
Run Time: 0.000250
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 <> 18951)
ORDER BY thread.post_date DESC
LIMIT 5
Run Time: 0.001099
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, 230
Run Time: 0.000260
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, 302
Run Time: 0.001002
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, 79
Run Time: 0.000761
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, 216
Run Time: 0.000213
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 = 18951 AND user_id = 0)
Params: 1714303861, a:3:{s:12:"olderThreads";a:5:{i:18950;a:22:{s:9:"thread_id";i:18950;s:7:"node_id";i:28;s:5:"title";s:118:"Nguyên lý kim tự tháp Minto, the Minto Pyramid Principle, cho bạn cách viết, tư duy và giải quyết vấ";s:11:"reply_count";i:0;s:10:"view_count";i:854;s:7:"user_id";i:3552;s:8:"username";s:7:"mod_van";s:9:"post_date";i:1661060510;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:21853;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1661060510;s:12:"last_post_id";i:21853;s:17:"last_post_user_id";i:3552;s:18:"last_post_username";s:7:"mod_van";s:9:"prefix_id";i:2;s:4:"tags";s:499:"a:7:{i:17014;a:2:{s:3:"tag";s:12:"babara minto";s:7:"tag_url";s:12:"babara-minto";}i:17013;a:2:{s:3:"tag";s:17:"giai quyet van de";s:7:"tag_url";s:17:"giai-quyet-van-de";}i:2176;a:2:{s:3:"tag";s:5:"logic";s:7:"tag_url";s:5:"logic";}i:17012;a:2:{s:3:"tag";s:5:"minto";s:7:"tag_url";s:5:"minto";}i:8716;a:2:{s:3:"tag";s:9:"nguyen ly";s:7:"tag_url";s:9:"nguyen-ly";}i:327;a:2:{s:3:"tag";s:10:"principles";s:7:"tag_url";s:10:"principles";}i:1044;a:2:{s:3:"tag";s:6:"tu duy";s:7:"tag_url";s:6:"tu-duy";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:18949;a:22:{s:9:"thread_id";i:18949;s:7:"node_id";i:211;s:5:"title";s:114:"Nâng cao vốn từ vựng tiếng Đức theo chủ đề bằng hình ảnh, Phan Kim Khánh Duy, Phương Dung";s:11:"reply_count";i:0;s:10:"view_count";i:1821;s:7:"user_id";i:3552;s:8:"username";s:7:"mod_van";s:9:"post_date";i:1661060102;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:21852;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1661060102;s:12:"last_post_id";i:21852;s:17:"last_post_user_id";i:3552;s:18:"last_post_username";s:7:"mod_van";s:9:"prefix_id";i:28;s:4:"tags";s:411:"a:6:{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:709;a:2:{s:3:"tag";s:11:"illustrated";s:7:"tag_url";s:11:"illustrated";}i:2391;a:2:{s:3:"tag";s:9:"tieng duc";s:7:"tag_url";s:9:"tieng-duc";}i:819;a:2:{s:3:"tag";s:7:"tu vung";s:7:"tag_url";s:7:"tu-vung";}i:16001;a:2:{s:3:"tag";s:9:"vocabular";s:7:"tag_url";s:9:"vocabular";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:18948;a:22:{s:9:"thread_id";i:18948;s:7:"node_id";i:136;s:5:"title";s:42:"Giáo trình thiết kế đồ gia dụng";s:11:"reply_count";i:0;s:10:"view_count";i:678;s:7:"user_id";i:3552;s:8:"username";s:7:"mod_van";s:9:"post_date";i:1661059757;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:21851;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1661059757;s:12:"last_post_id";i:21851;s:17:"last_post_user_id";i:3552;s:18:"last_post_username";s:7:"mod_van";s:9:"prefix_id";i:2;s:4:"tags";s:221:"a:3:{i:17011;a:2:{s:3:"tag";s:11:"do gia dung";s:7:"tag_url";s:11:"do-gia-dung";}i:1261;a:2:{s:3:"tag";s:10:"giao trinh";s:7:"tag_url";s:10:"giao-trinh";}i:282;a:2:{s:3:"tag";s:8:"thiet ke";s:7:"tag_url";s:8:"thiet-ke";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:18947;a:22:{s:9:"thread_id";i:18947;s:7:"node_id";i:217;s:5:"title";s:62:"Từ nối trong tiếng anh, Vũ Dung, Vũ Thủy, Jack Crean";s:11:"reply_count";i:0;s:10:"view_count";i:613;s:7:"user_id";i:1;s:8:"username";s:5:"admin";s:9:"post_date";i:1661010320;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:21840;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1661010320;s:12:"last_post_id";i:21840;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:356:"a:5:{i:17010;a:2:{s:3:"tag";s:10:"jack crean";s:7:"tag_url";s:10:"jack-crean";}i:10145;a:2:{s:3:"tag";s:13:"linking words";s:7:"tag_url";s:13:"linking-words";}i:12826;a:2:{s:3:"tag";s:6:"tu noi";s:7:"tag_url";s:6:"tu-noi";}i:13058;a:2:{s:3:"tag";s:7:"vu dung";s:7:"tag_url";s:7:"vu-dung";}i:17009;a:2:{s:3:"tag";s:7:"vu thuy";s:7:"tag_url";s:7:"vu-thuy";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:18946;a:22:{s:9:"thread_id";i:18946;s:7:"node_id";i:57;s:5:"title";s:88:"Giáo trình khẩu ngữ tiếng Hoa trong du lịch, Lý Đôn Hậu, Hạ Thụ Hành";s:11:"reply_count";i:0;s:10:"view_count";i:365;s:7:"user_id";i:3305;s:8:"username";s:9:"mod_luong";s:9:"post_date";i:1660985927;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:21837;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1660985927;s:12:"last_post_id";i:21837;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:527:"a:7:{i:1919;a:2:{s:3:"tag";s:7:"du lich";s:7:"tag_url";s:7:"du-lich";}i:1261;a:2:{s:3:"tag";s:10:"giao trinh";s:7:"tag_url";s:10:"giao-trinh";}i:17007;a:2:{s:3:"tag";s:11:"ha thu hanh";s:7:"tag_url";s:11:"ha-thu-hanh";}i:3154;a:2:{s:3:"tag";s:8:"khau ngu";s:7:"tag_url";s:8:"khau-ngu";}i:17006;a:2:{s:3:"tag";s:10:"ly don hau";s:7:"tag_url";s:10:"ly-don-hau";}i:231;a:2:{s:3:"tag";s:11:"tieng trung";s:7:"tag_url";s:11:"tieng-trung";}i:17008;a:2:{s:3:"tag";s:19:"tieng trung du lich";s:7:"tag_url";s:19:"tieng-trung-du-lich";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}}s:12:"newerThreads";a:5:{i:18952;a:22:{s:9:"thread_id";i:18952;s:7:"node_id";i:240;s:5:"title";s:100:"Teaching English as a Foreign or Second Language, A self-development and Methodology Guide, Jerry G.";s:11:"reply_count";i:0;s:10:"view_count";i:480;s:7:"user_id";i:3552;s:8:"username";s:7:"mod_van";s:9:"post_date";i:1661062897;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:21855;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1661062897;s:12:"last_post_id";i:21855;s:17:"last_post_user_id";i:3552;s:18:"last_post_username";s:7:"mod_van";s:9:"prefix_id";i:2;s:4:"tags";s:442:"a:6:{i:729;a:2:{s:3:"tag";s:3:"esl";s:7:"tag_url";s:3:"esl";}i:17016;a:2:{s:3:"tag";s:16:"jerry g. gebhard";s:7:"tag_url";s:15:"jerry-g-gebhard";}i:9820;a:2:{s:3:"tag";s:11:"methodology";s:7:"tag_url";s:11:"methodology";}i:10768;a:2:{s:3:"tag";s:8:"michigan";s:7:"tag_url";s:8:"michigan";}i:4114;a:2:{s:3:"tag";s:16:"teacher training";s:7:"tag_url";s:16:"teacher-training";}i:1215;a:2:{s:3:"tag";s:8:"teaching";s:7:"tag_url";s:8:"teaching";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:18953;a:22:{s:9:"thread_id";i:18953;s:7:"node_id";i:57;s:5:"title";s:63:"Tiếng Hoa giao tiếp Trang Phục & Ẩm Thực, Yến Bình";s:11:"reply_count";i:0;s:10:"view_count";i:523;s:7:"user_id";i:3552;s:8:"username";s:7:"mod_van";s:9:"post_date";i:1661063333;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:21856;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1661063333;s:12:"last_post_id";i:21856;s:17:"last_post_user_id";i:3552;s:18:"last_post_username";s:7:"mod_van";s:9:"prefix_id";i:2;s:4:"tags";s:419:"a:6:{i:7242;a:2:{s:3:"tag";s:7:"am thuc";s:7:"tag_url";s:7:"am-thuc";}i:359;a:2:{s:3:"tag";s:7:"chinese";s:7:"tag_url";s:7:"chinese";}i:2649;a:2:{s:3:"tag";s:9:"giao tiep";s:7:"tag_url";s:9:"giao-tiep";}i:231;a:2:{s:3:"tag";s:11:"tieng trung";s:7:"tag_url";s:11:"tieng-trung";}i:9498;a:2:{s:3:"tag";s:10:"trang phuc";s:7:"tag_url";s:10:"trang-phuc";}i:17017;a:2:{s:3:"tag";s:8:"yen binh";s:7:"tag_url";s:8:"yen-binh";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:18954;a:22:{s:9:"thread_id";i:18954;s:7:"node_id";i:28;s:5:"title";s:60:"Questions are the answers, Allan Pease, bản tiếng Việt";s:11:"reply_count";i:0;s:10:"view_count";i:711;s:7:"user_id";i:3552;s:8:"username";s:7:"mod_van";s:9:"post_date";i:1661075462;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:21857;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1661075462;s:12:"last_post_id";i:21857;s:17:"last_post_user_id";i:3552;s:18:"last_post_username";s:7:"mod_van";s:9:"prefix_id";i:2;s:4:"tags";s:219:"a:3:{i:17018;a:2:{s:3:"tag";s:11:"allan pease";s:7:"tag_url";s:11:"allan-pease";}i:2169;a:2:{s:3:"tag";s:10:"kinh doanh";s:7:"tag_url";s:10:"kinh-doanh";}i:682;a:2:{s:3:"tag";s:7:"ky nang";s:7:"tag_url";s:7:"ky-nang";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:18955;a:22:{s:9:"thread_id";i:18955;s:7:"node_id";i:207;s:5:"title";s:39:"Tự học tiếng Hàn Quóc, Lê Vân";s:11:"reply_count";i:0;s:10:"view_count";i:578;s:7:"user_id";i:3552;s:8:"username";s:7:"mod_van";s:9:"post_date";i:1661075592;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:21858;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1661075592;s:12:"last_post_id";i:21858;s:17:"last_post_user_id";i:3552;s:18:"last_post_username";s:7:"mod_van";s:9:"prefix_id";i:2;s:4:"tags";s:198:"a:3:{i:1367;a:2:{s:3:"tag";s:8:"han quoc";s:7:"tag_url";s:8:"han-quoc";}i:1329;a:2:{s:3:"tag";s:6:"korean";s:7:"tag_url";s:6:"korean";}i:228;a:2:{s:3:"tag";s:6:"tu hoc";s:7:"tag_url";s:6:"tu-hoc";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:18956;a:22:{s:9:"thread_id";i:18956;s:7:"node_id";i:218;s:5:"title";s:65:"Test it fix it, Vocabulary Kenna Bourke, Oxford, Pre-intermediate";s:11:"reply_count";i:0;s:10:"view_count";i:517;s:7:"user_id";i:3552;s:8:"username";s:7:"mod_van";s:9:"post_date";i:1661075800;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:21859;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1661075800;s:12:"last_post_id";i:21859;s:17:"last_post_user_id";i:3552;s:18:"last_post_username";s:7:"mod_van";s:9:"prefix_id";i:2;s:4:"tags";s:301:"a:4:{i:12940;a:2:{s:3:"tag";s:12:"kenna bourke";s:7:"tag_url";s:12:"kenna-bourke";}i:428;a:2:{s:3:"tag";s:6:"oxford";s:7:"tag_url";s:6:"oxford";}i:202;a:2:{s:3:"tag";s:16:"pre-intermediate";s:7:"tag_url";s:16:"pre-intermediate";}i:89;a:2:{s:3:"tag";s:10:"vocabulary";s:7:"tag_url";s:10:"vocabulary";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}}s:13:"latestThreads";a:5:{i:25513;a:22:{s:9:"thread_id";i:25513;s:7:"node_id";i:230;s:5:"title";s:37:"Text-based Writing Grade 4, Evan-Moor";s:11:"reply_count";i:0;s:10:"view_count";i:22;s:7:"user_id";i:96834;s:8:"username";s:7:"Mod_QAn";s:9:"post_date";i:1714215962;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:30498;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1714215962;s:12:"last_post_id";i:30498;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:310:"a:4:{i:11008;a:2:{s:3:"tag";s:9:"evan-moor";s:7:"tag_url";s:11:"evan-moor-2";}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:22306;a:2:{s:3:"tag";s:18:"text-based writing";s:7:"tag_url";s:18:"text-based-writing";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:25512;a:22:{s:9:"thread_id";i:25512;s:7:"node_id";i:136;s:5:"title";s:100:"BUSINESS COMMUNICATION: MAKING CONNECTIONS IN A DIGITAL WORLD, 11th edition, Raymond V. Lesikar, Mar";s:11:"reply_count";i:0;s:10:"view_count";i:24;s:7:"user_id";i:96834;s:8:"username";s:7:"Mod_QAn";s:9:"post_date";i:1714213621;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:30497;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1714213621;s:12:"last_post_id";i:30497;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:438:"a:5:{i:18535;a:2:{s:3:"tag";s:22:"business communication";s:7:"tag_url";s:22:"business-communication";}i:22302;a:2:{s:3:"tag";s:13:"digital world";s:7:"tag_url";s:13:"digital-world";}i:22305;a:2:{s:3:"tag";s:13:"kathryn rentz";s:7:"tag_url";s:13:"kathryn-rentz";}i:22304;a:2:{s:3:"tag";s:16:"marie e. flatley";s:7:"tag_url";s:15:"marie-e-flatley";}i:22303;a:2:{s:3:"tag";s:18:"raymond v. lesikar";s:7:"tag_url";s:17:"raymond-v-lesikar";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:25511;a:22:{s:9:"thread_id";i:25511;s:7:"node_id";i:302;s:5:"title";s:41:"Prosodic Patterns in English Conversation";s:11:"reply_count";i:0;s:10:"view_count";i:21;s:7:"user_id";i:96834;s:8:"username";s:7:"Mod_QAn";s:9:"post_date";i:1714212596;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:30496;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1714212596;s:12:"last_post_id";i:30496;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:492:"a:6:{i:15103;a:2:{s:3:"tag";s:20:"english conversation";s:7:"tag_url";s:20:"english-conversation";}i:22298;a:2:{s:3:"tag";s:13:"nigel g. ward";s:7:"tag_url";s:12:"nigel-g-ward";}i:4746;a:2:{s:3:"tag";s:8:"phonetic";s:7:"tag_url";s:8:"phonetic";}i:22301;a:2:{s:3:"tag";s:9:"pragmatic";s:7:"tag_url";s:9:"pragmatic";}i:22300;a:2:{s:3:"tag";s:17:"pragmatic studies";s:7:"tag_url";s:17:"pragmatic-studies";}i:22299;a:2:{s:3:"tag";s:17:"prosodic patterns";s:7:"tag_url";s:17:"prosodic-patterns";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:25510;a:22:{s:9:"thread_id";i:25510;s:7:"node_id";i:79;s:5:"title";s:39:"The Phantom of the Opera ,Leroux Gaston";s:11:"reply_count";i:0;s:10:"view_count";i:28;s:7:"user_id";i:3305;s:8:"username";s:9:"mod_luong";s:9:"post_date";i:1714157342;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:30495;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1714157342;s:12:"last_post_id";i:30495;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:188:"a:2:{i:22296;a:2:{s:3:"tag";s:13:"leroux gaston";s:7:"tag_url";s:13:"leroux-gaston";}i:22297;a:2:{s:3:"tag";s:24:"the phantom of the opera";s:7:"tag_url";s:24:"the-phantom-of-the-opera";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:25509;a:22:{s:9:"thread_id";i:25509;s:7:"node_id";i:216;s:5:"title";s:85:"Ready to write 2, 4th edition, Perfecting Paragraphs, Karen Blanchard, Christine Root";s:11:"reply_count";i:0;s:10:"view_count";i:28;s:7:"user_id";i:3305;s:8:"username";s:9:"mod_luong";s:9:"post_date";i:1714157208;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:30494;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1714157208;s:12:"last_post_id";i:30494;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:414:"a:5:{i:17481;a:2:{s:3:"tag";s:14:"christine root";s:7:"tag_url";s:14:"christine-root";}i:17480;a:2:{s:3:"tag";s:15:"karen blanchard";s:7:"tag_url";s:15:"karen-blanchard";}i:22295;a:2:{s:3:"tag";s:10:"paragraphs";s:7:"tag_url";s:10:"paragraphs";}i:17479;a:2:{s:3:"tag";s:14:"ready to write";s:7:"tag_url";s:14:"ready-to-write";}i:22055;a:2:{s:3:"tag";s:16:"ready to write 2";s:7:"tag_url";s:16:"ready-to-write-2";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}}}
Run Time: 1.023401
SELECT thread.*
,
MATCH(search_index.title) AGAINST ('Tuyển chọn các bài luyện dịch Việt Anh theo chủ điểm, Selections of Vietnamese - English Translatati' 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 <> 18951)
AND MATCH(search_index.title) AGAINST ('Tuyển chọn các bài luyện dịch Việt Anh theo chủ điểm, Selections of Vietnamese - English Translatati' IN BOOLEAN MODE)
AND search_index.content_type='thread'
HAVING similar_score >= 1
ORDER BY similar_score
LIMIT 5
Run Time: 1.758096
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, 10
Run Time: 0.007381
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, 11
Run Time: 0.003580
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, 34
Run Time: 0.000899
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, 36
Run Time: 0.000346
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, 32
Run Time: 0.001122
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 <> 18951)
ORDER BY RAND()
LIMIT 5
Run Time: 0.176015
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | ALL | PRIMARY | | | | 25517 | 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 (19125, 16934, 17125, 3324, 5280))
ORDER BY thread.post_date DESC
LIMIT 5
Run Time: 0.003783
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, 220
Run Time: 0.001286
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, 224
Run Time: 0.000589
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, 29
Run Time: 0.000136
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.000131
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 = 18951)
Run Time: 0.730206
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | post_links | ALL | | | | | 25589 | Using where |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 8b8298e3588fd1396c4be0a2b57485f2, , 1714307461
Run Time: 0.000356
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_Thread, Index, valid, thread_id=18951, 1714303861,
Run Time: 0.000186
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.020490
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.000890
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.011687
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.000486
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.000295
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |