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.000676
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.000207
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.008789
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user_point | ALL | | | | | 10922 | |
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: 17764
Run Time: 0.000514
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: 64
Run Time: 0.000582
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: 17764
Run Time: 0.004090
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: 17764
Run Time: 0.000205
SELECT *
FROM xf_brivium_extra_thread_item
WHERE thread_id = ? AND user_id = ?
Params: 17764, 0
Run Time: 0.339455
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_brivium_extra_thread_item | ALL | | | | | 25050 | Using where |
SELECT thread.*
FROM xf_thread AS thread
WHERE ((thread.discussion_type <> 'redirect') AND (thread.discussion_state = 'visible') AND (thread.post_date < 1650263622)) AND (thread.thread_id <> 17764)
ORDER BY thread.post_date DESC
LIMIT 5
Run Time: 0.000704
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY,post_date | post_date | 4 | | 11661 | Using where |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 21
Run Time: 0.000254
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.000206
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, 284
Run Time: 0.000201
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, 344
Run Time: 0.000202
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 > 1650263622)) AND (thread.thread_id <> 17764)
ORDER BY thread.post_date ASC
LIMIT 5
Run Time: 0.000517
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY,post_date | post_date | 4 | | 7204 | 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, 20
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, 162
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 cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 138
Run Time: 0.000211
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, 222
Run Time: 0.000196
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, 226
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 thread.*
FROM xf_thread AS thread
WHERE ((thread.discussion_type <> 'redirect') AND (thread.discussion_state = 'visible')) AND (thread.thread_id <> 17764)
ORDER BY thread.post_date DESC
LIMIT 5
Run Time: 0.000475
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, 218
Run Time: 0.000224
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, 163
Run Time: 0.000221
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.000227
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 = 17764 AND user_id = 0)
Params: 1714634273, a:3:{s:12:"olderThreads";a:5:{i:17761;a:22:{s:9:"thread_id";i:17761;s:7:"node_id";i:21;s:5:"title";s:116:"Vườn thơ trăm hương sắc, Fujiwara No Teika, Hyakunin Isshu, Trần Thị Chung Toàn dịch và chú giải";s:11:"reply_count";i:0;s:10:"view_count";i:649;s:7:"user_id";i:3552;s:8:"username";s:7:"mod_van";s:9:"post_date";i:1650191840;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:20048;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1650191840;s:12:"last_post_id";i:20048;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:477:"a:6:{i:15917;a:2:{s:3:"tag";s:17:"fujiwara no teika";s:7:"tag_url";s:17:"fujiwara-no-teika";}i:15918;a:2:{s:3:"tag";s:14:"hyakunin isshu";s:7:"tag_url";s:14:"hyakunin-isshu";}i:370;a:2:{s:3:"tag";s:8:"japanese";s:7:"tag_url";s:8:"japanese";}i:467;a:2:{s:3:"tag";s:8:"nhat ban";s:7:"tag_url";s:8:"nhat-ban";}i:15916;a:2:{s:3:"tag";s:12:"tho nhat ban";s:7:"tag_url";s:12:"tho-nhat-ban";}i:7312;a:2:{s:3:"tag";s:19:"tran thi chung toan";s:7:"tag_url";s:19:"tran-thi-chung-toan";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:17760;a:22:{s:9:"thread_id";i:17760;s:7:"node_id";i:217;s:5:"title";s:96:"Từ điển văn phạm tiếng Anh, Th.S Võ Trọng Thuỷ, Võ Hồng Vân dịch, 652 trang";s:11:"reply_count";i:0;s:10:"view_count";i:488;s:7:"user_id";i:1;s:8:"username";s:5:"admin";s:9:"post_date";i:1650191276;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:20047;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1650191276;s:12:"last_post_id";i:20047;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:678:"a:8:{i:3849;a:2:{s:3:"tag";s:15:"english grammar";s:7:"tag_url";s:15:"english-grammar";}i:15915;a:2:{s:3:"tag";s:26:"english grammar dictionary";s:7:"tag_url";s:26:"english-grammar-dictionary";}i:185;a:2:{s:3:"tag";s:9:"tieng anh";s:7:"tag_url";s:9:"tieng-anh";}i:294;a:2:{s:3:"tag";s:7:"tu dien";s:7:"tag_url";s:7:"tu-dien";}i:15914;a:2:{s:3:"tag";s:26:"tu dien van pham tieng anh";s:7:"tag_url";s:26:"tu-dien-van-pham-tieng-anh";}i:7308;a:2:{s:3:"tag";s:18:"van pham tieng anh";s:7:"tag_url";s:18:"van-pham-tieng-anh";}i:15912;a:2:{s:3:"tag";s:11:"vo hong van";s:7:"tag_url";s:11:"vo-hong-van";}i:15913;a:2:{s:3:"tag";s:13:"vo trong thuy";s:7:"tag_url";s:13:"vo-trong-thuy";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:17759;a:22:{s:9:"thread_id";i:17759;s:7:"node_id";i:284;s:5:"title";s:102:"Siêu chăm học tiếng Anh, cùng cô Thu Oanh bứt phá kiến thức tiếng Anh THPT Quốc Gia";s:11:"reply_count";i:0;s:10:"view_count";i:713;s:7:"user_id";i:1;s:8:"username";s:5:"admin";s:9:"post_date";i:1650190848;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:20046;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1650190848;s:12:"last_post_id";i:20046;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:295:"a:4:{i:2357;a:2:{s:3:"tag";s:14:"on thi dai hoc";s:7:"tag_url";s:14:"on-thi-dai-hoc";}i:3097;a:2:{s:3:"tag";s:6:"thptqg";s:7:"tag_url";s:6:"thptqg";}i:15911;a:2:{s:3:"tag";s:8:"thu oanh";s:7:"tag_url";s:8:"thu-oanh";}i:6150;a:2:{s:3:"tag";s:12:"tieng anh 12";s:7:"tag_url";s:12:"tieng-anh-12";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:17757;a:22:{s:9:"thread_id";i:17757;s:7:"node_id";i:64;s:5:"title";s:134:"250 bài tập trung cấp có hướng dẫn sử dụng từ vựng tiếng Pháp kèm lời giải, Phạm Tuấn, Tăng Văn Hùng";s:11:"reply_count";i:0;s:10:"view_count";i:552;s:7:"user_id";i:1;s:8:"username";s:5:"admin";s:9:"post_date";i:1650187874;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:20044;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1650187874;s:12:"last_post_id";i:20044;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:689:"a:10:{i:2967;a:2:{s:3:"tag";s:3:"250";s:7:"tag_url";s:3:"250";}i:182;a:2:{s:3:"tag";s:7:"bai tap";s:7:"tag_url";s:7:"bai-tap";}i:4365;a:2:{s:3:"tag";s:8:"francais";s:7:"tag_url";s:8:"francais";}i:1603;a:2:{s:3:"tag";s:6:"french";s:7:"tag_url";s:6:"french";}i:9068;a:2:{s:3:"tag";s:9:"pham tuan";s:7:"tag_url";s:9:"pham-tuan";}i:15908;a:2:{s:3:"tag";s:13:"tang van hung";s:7:"tag_url";s:13:"tang-van-hung";}i:1861;a:2:{s:3:"tag";s:10:"tieng phap";s:7:"tag_url";s:10:"tieng-phap";}i:9572;a:2:{s:3:"tag";s:9:"trung cap";s:7:"tag_url";s:9:"trung-cap";}i:819;a:2:{s:3:"tag";s:7:"tu vung";s:7:"tag_url";s:7:"tu-vung";}i:14897;a:2:{s:3:"tag";s:11:"vocabulaire";s:7:"tag_url";s:11:"vocabulaire";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:17756;a:22:{s:9:"thread_id";i:17756;s:7:"node_id";i:344;s:5:"title";s:100:"Unlock 5 2nd Edition Listening, Speaking & Critical Thinking Student's Book, Jessica Williams, Sabin";s:11:"reply_count";i:0;s:10:"view_count";i:587;s:7:"user_id";i:1;s:8:"username";s:5:"admin";s:9:"post_date";i:1650186793;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:20043;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1650186793;s:12:"last_post_id";i:20043;s:17:"last_post_user_id";i:1;s:18:"last_post_username";s:5:"admin";s:9:"prefix_id";i:28;s:4:"tags";s:935:"a:12:{i:15907;a:2:{s:3:"tag";s:16:"cambridge unlock";s:7:"tag_url";s:16:"cambridge-unlock";}i:4743;a:2:{s:3:"tag";s:12:"chris sowton";s:7:"tag_url";s:12:"chris-sowton";}i:15905;a:2:{s:3:"tag";s:16:"christina cavage";s:7:"tag_url";s:16:"christina-cavage";}i:986;a:2:{s:3:"tag";s:17:"critical thinking";s:7:"tag_url";s:17:"critical-thinking";}i:15689;a:2:{s:3:"tag";s:3:"cup";s:7:"tag_url";s:3:"cup";}i:15904;a:2:{s:3:"tag";s:15:"jennifer farmer";s:7:"tag_url";s:15:"jennifer-farmer";}i:14527;a:2:{s:3:"tag";s:16:"jessica williams";s:7:"tag_url";s:16:"jessica-williams";}i:7318;a:2:{s:3:"tag";s:14:"laurie frazier";s:7:"tag_url";s:14:"laurie-frazier";}i:257;a:2:{s:3:"tag";s:9:"listening";s:7:"tag_url";s:9:"listening";}i:15903;a:2:{s:3:"tag";s:16:"sabina ostrowska";s:7:"tag_url";s:16:"sabina-ostrowska";}i:619;a:2:{s:3:"tag";s:8:"speaking";s:7:"tag_url";s:8:"speaking";}i:15277;a:2:{s:3:"tag";s:6:"unlock";s:7:"tag_url";s:6:"unlock";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}}s:12:"newerThreads";a:5:{i:17765;a:22:{s:9:"thread_id";i:17765;s:7:"node_id";i:20;s:5:"title";s:65:"Giáo trình báo chí điều tra, PGS TS Đỗ Thị Thu Hằng";s:11:"reply_count";i:0;s:10:"view_count";i:707;s:7:"user_id";i:3305;s:8:"username";s:9:"mod_luong";s:9:"post_date";i:1650265441;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:20054;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1650265441;s:12:"last_post_id";i:20054;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:423:"a:6:{i:8624;a:2:{s:3:"tag";s:7:"bao chi";s:7:"tag_url";s:7:"bao-chi";}i:1508;a:2:{s:3:"tag";s:8:"dieu tra";s:7:"tag_url";s:8:"dieu-tra";}i:15919;a:2:{s:3:"tag";s:15:"do thi thu hang";s:7:"tag_url";s:15:"do-thi-thu-hang";}i:1261;a:2:{s:3:"tag";s:10:"giao trinh";s:7:"tag_url";s:10:"giao-trinh";}i:10651;a:2:{s:3:"tag";s:7:"nha bao";s:7:"tag_url";s:7:"nha-bao";}i:13326;a:2:{s:3:"tag";s:5:"press";s:7:"tag_url";s:5:"press";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:17766;a:22:{s:9:"thread_id";i:17766;s:7:"node_id";i:162;s:5:"title";s:57:"Giáo trình pháp luật cạnh tranh, Tăng Văn Nghĩa";s:11:"reply_count";i:0;s:10:"view_count";i:673;s:7:"user_id";i:3305;s:8:"username";s:9:"mod_luong";s:9:"post_date";i:1650265911;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:20055;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1650265911;s:12:"last_post_id";i:20055;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:629:"a:8:{i:2490;a:2:{s:3:"tag";s:10:"canh tranh";s:7:"tag_url";s:10:"canh-tranh";}i:1819;a:2:{s:3:"tag";s:20:"dai hoc ngoai thuong";s:7:"tag_url";s:20:"dai-hoc-ngoai-thuong";}i:1818;a:2:{s:3:"tag";s:3:"ftu";s:7:"tag_url";s:3:"ftu";}i:1261;a:2:{s:3:"tag";s:10:"giao trinh";s:7:"tag_url";s:10:"giao-trinh";}i:15920;a:2:{s:3:"tag";s:20:"giao trinh phap luat";s:7:"tag_url";s:20:"giao-trinh-phap-luat";}i:2544;a:2:{s:3:"tag";s:15:"luat canh tranh";s:7:"tag_url";s:15:"luat-canh-tranh";}i:826;a:2:{s:3:"tag";s:9:"phap luat";s:7:"tag_url";s:9:"phap-luat";}i:15921;a:2:{s:3:"tag";s:14:"tang van nghia";s:7:"tag_url";s:14:"tang-van-nghia";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:17767;a:22:{s:9:"thread_id";i:17767;s:7:"node_id";i:138;s:5:"title";s:91:"Tìm hiểu văn chương Anh, Đắc Sơn biên soạn, tài liệu tự học tiếng Anh";s:11:"reply_count";i:0;s:10:"view_count";i:425;s:7:"user_id";i:3305;s:8:"username";s:9:"mod_luong";s:9:"post_date";i:1650266230;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:20056;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1650266230;s:12:"last_post_id";i:20056;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:440:"a:6:{i:15091;a:2:{s:3:"tag";s:7:"dac son";s:7:"tag_url";s:7:"dac-son";}i:87;a:2:{s:3:"tag";s:7:"english";s:7:"tag_url";s:7:"english";}i:7802;a:2:{s:3:"tag";s:18:"english literature";s:7:"tag_url";s:18:"english-literature";}i:711;a:2:{s:3:"tag";s:10:"literature";s:7:"tag_url";s:10:"literature";}i:228;a:2:{s:3:"tag";s:6:"tu hoc";s:7:"tag_url";s:6:"tu-hoc";}i:14740;a:2:{s:3:"tag";s:14:"van chuong anh";s:7:"tag_url";s:14:"van-chuong-anh";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:17768;a:22:{s:9:"thread_id";i:17768;s:7:"node_id";i:222;s:5:"title";s:90:"Từ vựng tiếng Việt, Từ điển Trung Việt Anh phân loại theo 50 chủ đề";s:11:"reply_count";i:0;s:10:"view_count";i:621;s:7:"user_id";i:3305;s:8:"username";s:9:"mod_luong";s:9:"post_date";i:1650266920;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:20057;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1650266920;s:12:"last_post_id";i:20057;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:595:"a:8:{i:279;a:2:{s:3:"tag";s:10:"dictionary";s:7:"tag_url";s:10:"dictionary";}i:572;a:2:{s:3:"tag";s:10:"tieng viet";s:7:"tag_url";s:10:"tieng-viet";}i:9584;a:2:{s:3:"tag";s:14:"trung anh viet";s:7:"tag_url";s:14:"trung-anh-viet";}i:7240;a:2:{s:3:"tag";s:10:"trung viet";s:7:"tag_url";s:10:"trung-viet";}i:294;a:2:{s:3:"tag";s:7:"tu dien";s:7:"tag_url";s:7:"tu-dien";}i:819;a:2:{s:3:"tag";s:7:"tu vung";s:7:"tag_url";s:7:"tu-vung";}i:15922;a:2:{s:3:"tag";s:18:"tu vung tieng viet";s:7:"tag_url";s:18:"tu-vung-tieng-viet";}i:1600;a:2:{s:3:"tag";s:10:"vietnamese";s:7:"tag_url";s:10:"vietnamese";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:17769;a:22:{s:9:"thread_id";i:17769;s:7:"node_id";i:226;s:5:"title";s:30:"McGraw-Hill Education SAT 2022";s:11:"reply_count";i:0;s:10:"view_count";i:674;s:7:"user_id";i:1;s:8:"username";s:5:"admin";s:9:"post_date";i:1650332254;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:20059;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1650332254;s:12:"last_post_id";i:20059;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:497:"a:7:{i:11076;a:2:{s:3:"tag";s:4:"2022";s:7:"tag_url";s:4:"2022";}i:9761;a:2:{s:3:"tag";s:17:"christopher black";s:7:"tag_url";s:17:"christopher-black";}i:9762;a:2:{s:3:"tag";s:12:"mark anestis";s:7:"tag_url";s:12:"mark-anestis";}i:1242;a:2:{s:3:"tag";s:11:"mcgraw hill";s:7:"tag_url";s:11:"mcgraw-hill";}i:1098;a:2:{s:3:"tag";s:3:"sat";s:7:"tag_url";s:3:"sat";}i:13466;a:2:{s:3:"tag";s:8:"sat 2022";s:7:"tag_url";s:8:"sat-2022";}i:5596;a:2:{s:3:"tag";s:8:"sat prep";s:7:"tag_url";s:8:"sat-prep";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}}s:13:"latestThreads";a:5:{i:25522;a:22:{s:9:"thread_id";i:25522;s:7:"node_id";i:218;s:5:"title";s:52:"Sadlier Vocabulary Workshop. Level E ,Jerome Shostak";s:11:"reply_count";i:0;s:10:"view_count";i:12;s:7:"user_id";i:3552;s:8:"username";s:7:"mod_van";s:9:"post_date";i:1714615139;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:30512;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1714615139;s:12:"last_post_id";i:30512;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:249:"a:3:{i:22309;a:2:{s:3:"tag";s:14:"jerome shostak";s:7:"tag_url";s:14:"jerome-shostak";}i:22308;a:2:{s:3:"tag";s:18:"sadlier vocabulary";s:7:"tag_url";s:18:"sadlier-vocabulary";}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;}i:25521;a:22:{s:9:"thread_id";i:25521;s:7:"node_id";i:163;s:5:"title";s:64:"The PMI Guide to Business Analysis ,Project Management Institute";s:11:"reply_count";i:0;s:10:"view_count";i:12;s:7:"user_id";i:3552;s:8:"username";s:7:"mod_van";s:9:"post_date";i:1714614805;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:30511;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1714614805;s:12:"last_post_id";i:30511;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:238:"a:3:{i:22307;a:2:{s:3:"tag";s:17:"business analysis";s:7:"tag_url";s:17:"business-analysis";}i:622;a:2:{s:3:"tag";s:3:"pmi";s:7:"tag_url";s:3:"pmi";}i:621;a:2:{s:3:"tag";s:18:"project management";s:7:"tag_url";s:18:"project-management";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:25520;a:22:{s:9:"thread_id";i:25520;s:7:"node_id";i:11;s:5:"title";s:87:"Hiệu Ứng Người Bảo Trợ: Dạy Chính Mình Bằng Cách Dạy Người Khác";s:11:"reply_count";i:0;s:10:"view_count";i:26;s:7:"user_id";i:3552;s:8:"username";s:7:"mod_van";s:9:"post_date";i:1714517221;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:30509;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1714517221;s:12:"last_post_id";i:30509;s:17:"last_post_user_id";i:3552;s:18:"last_post_username";s:7:"mod_van";s:9:"prefix_id";i:16;s:4:"tags";s:6:"a:0:{}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:25519;a:22:{s:9:"thread_id";i:25519;s:7:"node_id";i:11;s:5:"title";s:85:"Nghệ Thuật 'Fake It Till You Make It' Của Huyền Thoại Cờ Vua Thế Giới";s:11:"reply_count";i:0;s:10:"view_count";i:24;s:7:"user_id";i:3552;s:8:"username";s:7:"mod_van";s:9:"post_date";i:1714517172;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:30508;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1714517172;s:12:"last_post_id";i:30508;s:17:"last_post_user_id";i:3552;s:18:"last_post_username";s:7:"mod_van";s:9:"prefix_id";i:16;s:4:"tags";s:6:"a:0:{}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:25518;a:22:{s:9:"thread_id";i:25518;s:7:"node_id";i:11;s:5:"title";s:86:"35 BÍ QUYẾT ĐỌC SÁCH MÌNH HỌC ĐƯỢC SAU KHI ĐỌC HƠN 350 CUỐN SÁCH.";s:11:"reply_count";i:0;s:10:"view_count";i:28;s:7:"user_id";i:3552;s:8:"username";s:7:"mod_van";s:9:"post_date";i:1714517111;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:30507;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1714517111;s:12:"last_post_id";i:30507;s:17:"last_post_user_id";i:3552;s:18:"last_post_username";s:7:"mod_van";s:9:"prefix_id";i:16;s:4:"tags";s:6:"a:0:{}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}}}
Run Time: 0.688050
SELECT thread.*
,
MATCH(search_index.title) AGAINST ('Grammaire Expliquee Du Francais, Niveau Intermediaire, CLE international, 2nd edition' 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 <> 17764)
AND MATCH(search_index.title) AGAINST ('Grammaire Expliquee Du Francais, Niveau Intermediaire, CLE international, 2nd edition' IN BOOLEAN MODE)
AND search_index.content_type='thread'
HAVING similar_score >= 1
ORDER BY similar_score
LIMIT 5
Run Time: 0.228944
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, 19
Run Time: 0.000309
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, 18
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, 7
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 thread.thread_id
FROM xf_thread AS thread
WHERE ((thread.discussion_type <> 'redirect') AND (thread.discussion_state = 'visible')) AND (thread.thread_id <> 17764)
ORDER BY RAND()
LIMIT 5
Run Time: 0.023111
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | ALL | PRIMARY | | | | 23322 | 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 (7476, 190, 5328, 15825, 11835))
ORDER BY thread.post_date DESC
LIMIT 5
Run Time: 0.000836
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, 28
Run Time: 0.000233
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, 48
Run Time: 0.000185
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, 82
Run Time: 0.000240
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, 165
Run Time: 0.000201
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, 43
Run Time: 0.000174
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 = 17764)
Run Time: 0.021037
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | post_links | ALL | | | | | 25592 | Using where |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 5bcd80ef7df404246c740e365d4d4ff0, , 1714637873
Run Time: 0.000255
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=17764, 1714634273,
Run Time: 0.000138
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.000973
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.000334
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.000235
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.000252
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.000207
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |