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.000770
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.000222
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.005366
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user_point | ALL | | | | | 10833 | |
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: 909
Run Time: 0.009126
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: 47
Run Time: 0.000690
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: 909
Run Time: 0.010858
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 |
SELECT attachment.*,
data.filename, data.file_size, data.file_hash, data.file_path, data.width, data.height, data.thumbnail_width, data.thumbnail_height
FROM xf_attachment AS attachment
INNER JOIN xf_attachment_data AS data ON
(data.data_id = attachment.data_id)
WHERE attachment.content_type = ?
AND attachment.content_id IN (1145)
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.003981
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using index condition; Using where |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | dien7104_tailieu.attachment.data_id | 1 | |
INSERT DELAYED INTO xf_thread_view
(thread_id)
VALUES
(?)
Params: 909
Run Time: 0.000178
SELECT *
FROM xf_brivium_extra_thread_item
WHERE thread_id = ? AND user_id = ?
Params: 909, 0
Run Time: 0.535761
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 < 1527962038)) AND (thread.thread_id <> 909)
ORDER BY thread.post_date DESC
LIMIT 5
Run Time: 0.007342
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY,post_date | post_date | 4 | | 861 | Using where |
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.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, 50
Run Time: 0.000289
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, 10
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, 11
Run Time: 0.000169
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.000182
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 > 1527962038)) AND (thread.thread_id <> 909)
ORDER BY thread.post_date ASC
LIMIT 5
Run Time: 0.026210
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY,post_date | post_date | 4 | | 12758 | 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, 21
Run Time: 0.009260
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.000330
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.000330
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, 22
Run Time: 0.000348
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 <> 909)
ORDER BY thread.post_date DESC
LIMIT 5
Run Time: 0.000625
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.000304
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.000267
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.000266
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.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 cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 216
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 | |
UPDATE `xf_brivium_extra_thread_item` SET `date_update` = ?, `extra_cache` = ? WHERE (thread_id = 909 AND user_id = 0)
Params: 1714222211, a:3:{s:12:"olderThreads";a:5:{i:908;a:22:{s:9:"thread_id";i:908;s:7:"node_id";i:26;s:5:"title";s:103:"Các nhà khoa bảng Việt Nam 1075 - 1919 của Ngô Đức Thọ biên soạn, NXB Văn học 2006";s:11:"reply_count";i:0;s:10:"view_count";i:989;s:7:"user_id";i:1;s:8:"username";s:5:"admin";s:9:"post_date";i:1527961574;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:1144;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1527961574;s:12:"last_post_id";i:1144;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:528:"a:8:{i:1653;a:2:{s:3:"tag";s:4:"1075";s:7:"tag_url";s:4:"1075";}i:1654;a:2:{s:3:"tag";s:4:"1919";s:7:"tag_url";s:4:"1919";}i:1650;a:2:{s:3:"tag";s:4:"2006";s:7:"tag_url";s:4:"2006";}i:1652;a:2:{s:3:"tag";s:9:"khoa bang";s:7:"tag_url";s:9:"khoa-bang";}i:40;a:2:{s:3:"tag";s:7:"lich su";s:7:"tag_url";s:7:"lich-su";}i:1651;a:2:{s:3:"tag";s:11:"ngo duc tho";s:7:"tag_url";s:11:"ngo-duc-tho";}i:53;a:2:{s:3:"tag";s:11:"nxb van hoc";s:7:"tag_url";s:11:"nxb-van-hoc";}i:72;a:2:{s:3:"tag";s:8:"viet nam";s:7:"tag_url";s:8:"viet-nam";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:907;a:22:{s:9:"thread_id";i:907;s:7:"node_id";i:50;s:5:"title";s:75:"Thẹn thùng xem tranh Bùi Xuân Phái minh họa thơ Hồ Xuân Hương";s:11:"reply_count";i:0;s:10:"view_count";i:1234;s:7:"user_id";i:1;s:8:"username";s:5:"admin";s:9:"post_date";i:1527961162;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:1143;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1527961162;s:12:"last_post_id";i:1143;s:17:"last_post_user_id";i:1;s:18:"last_post_username";s:5:"admin";s:9:"prefix_id";i:0;s:4:"tags";s:293:"a:4:{i:808;a:2:{s:3:"tag";s:13:"bui xuan phai";s:7:"tag_url";s:13:"bui-xuan-phai";}i:1649;a:2:{s:3:"tag";s:13:"ho xuan huong";s:7:"tag_url";s:13:"ho-xuan-huong";}i:117;a:2:{s:3:"tag";s:7:"hoi hoa";s:7:"tag_url";s:7:"hoi-hoa";}i:539;a:2:{s:3:"tag";s:8:"my thuat";s:7:"tag_url";s:8:"my-thuat";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:906;a:22:{s:9:"thread_id";i:906;s:7:"node_id";i:10;s:5:"title";s:81:"BẮT TRẺ ĐỒNG XANH (tiếng Anh: The Catcher in the Rye) by J. D. Salinger";s:11:"reply_count";i:1;s:10:"view_count";i:1036;s:7:"user_id";i:1;s:8:"username";s:5:"admin";s:9:"post_date";i:1527960996;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:1141;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1527961094;s:12:"last_post_id";i:1142;s:17:"last_post_user_id";i:1;s:18:"last_post_username";s:5:"admin";s:9:"prefix_id";i:8;s:4:"tags";s:269:"a:3:{i:1647;a:2:{s:3:"tag";s:17:"bat tre dong xanh";s:7:"tag_url";s:17:"bat-tre-dong-xanh";}i:1646;a:2:{s:3:"tag";s:14:"j. d. salinger";s:7:"tag_url";s:12:"j-d-salinger";}i:1648;a:2:{s:3:"tag";s:22:"the catcher in the rye";s:7:"tag_url";s:22:"the-catcher-in-the-rye";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:905;a:22:{s:9:"thread_id";i:905;s:7:"node_id";i:11;s:5:"title";s:55:"Độc đáo các bản dịch Tam quốc diễn nghĩa";s:11:"reply_count";i:0;s:10:"view_count";i:830;s:7:"user_id";i:1;s:8:"username";s:5:"admin";s:9:"post_date";i:1527960725;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:1140;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1527960725;s:12:"last_post_id";i:1140;s:17:"last_post_user_id";i:1;s:18:"last_post_username";s:5:"admin";s:9:"prefix_id";i:0;s:4:"tags";s:163:"a:2:{i:592;a:2:{s:3:"tag";s:8:"tam quoc";s:7:"tag_url";s:8:"tam-quoc";}i:1612;a:2:{s:3:"tag";s:19:"tam quoc dien nghia";s:7:"tag_url";s:19:"tam-quoc-dien-nghia";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:904;a:22:{s:9:"thread_id";i:904;s:7:"node_id";i:36;s:5:"title";s:35:"Lịch sử kiến trúc Việt Nam";s:11:"reply_count";i:0;s:10:"view_count";i:1316;s:7:"user_id";i:1;s:8:"username";s:5:"admin";s:9:"post_date";i:1527960587;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:1139;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1527960587;s:12:"last_post_id";i:1139;s:17:"last_post_user_id";i:1;s:18:"last_post_username";s:5:"admin";s:9:"prefix_id";i:0;s:4:"tags";s:435:"a:6:{i:1644;a:2:{s:3:"tag";s:4:"1998";s:7:"tag_url";s:4:"1998";}i:1323;a:2:{s:3:"tag";s:9:"kien truc";s:7:"tag_url";s:9:"kien-truc";}i:40;a:2:{s:3:"tag";s:7:"lich su";s:7:"tag_url";s:7:"lich-su";}i:1645;a:2:{s:3:"tag";s:13:"ngo huy quynh";s:7:"tag_url";s:13:"ngo-huy-quynh";}i:520;a:2:{s:3:"tag";s:21:"nxb van hoa thong tin";s:7:"tag_url";s:21:"nxb-van-hoa-thong-tin";}i:72;a:2:{s:3:"tag";s:8:"viet nam";s:7:"tag_url";s:8:"viet-nam";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}}s:12:"newerThreads";a:5:{i:911;a:22:{s:9:"thread_id";i:911;s:7:"node_id";i:10;s:5:"title";s:43:"Tiểu thuyết "Những Kẻ Tủi Nhục"";s:11:"reply_count";i:0;s:10:"view_count";i:1111;s:7:"user_id";i:1;s:8:"username";s:5:"admin";s:9:"post_date";i:1527964687;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:1147;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1527964687;s:12:"last_post_id";i:1147;s:17:"last_post_user_id";i:1;s:18:"last_post_username";s:5:"admin";s:9:"prefix_id";i:8;s:4:"tags";s:156:"a:2:{i:557;a:2:{s:3:"tag";s:10:"dostoevsky";s:7:"tag_url";s:10:"dostoevsky";}i:1660;a:2:{s:3:"tag";s:13:"f. dostoevsky";s:7:"tag_url";s:12:"f-dostoevsky";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:912;a:22:{s:9:"thread_id";i:912;s:7:"node_id";i:21;s:5:"title";s:87:"Art Nude Photography Explained - How to Photograph and Understand Great Art Nude Images";s:11:"reply_count";i:0;s:10:"view_count";i:855;s:7:"user_id";i:1;s:8:"username";s:5:"admin";s:9:"post_date";i:1527965273;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:1148;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1527965273;s:12:"last_post_id";i:1148;s:17:"last_post_user_id";i:1;s:18:"last_post_username";s:5:"admin";s:9:"prefix_id";i:18;s:4:"tags";s:324:"a:5:{i:116;a:2:{s:3:"tag";s:3:"art";s:7:"tag_url";s:3:"art";}i:1663;a:2:{s:3:"tag";s:8:"art nude";s:7:"tag_url";s:8:"art-nude";}i:1664;a:2:{s:3:"tag";s:5:"image";s:7:"tag_url";s:5:"image";}i:1661;a:2:{s:3:"tag";s:4:"nude";s:7:"tag_url";s:4:"nude";}i:1662;a:2:{s:3:"tag";s:11:"photography";s:7:"tag_url";s:11:"photography";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:913;a:22:{s:9:"thread_id";i:913;s:7:"node_id";i:28;s:5:"title";s:88:"Activate Your Brain - How Understanding Your Brain Can Improve Your Work - and Your Life";s:11:"reply_count";i:0;s:10:"view_count";i:834;s:7:"user_id";i:1;s:8:"username";s:5:"admin";s:9:"post_date";i:1527965393;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:1149;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1527965393;s:12:"last_post_id";i:1149;s:17:"last_post_user_id";i:1;s:18:"last_post_username";s:5:"admin";s:9:"prefix_id";i:18;s:4:"tags";s:216:"a:3:{i:1510;a:2:{s:3:"tag";s:5:"brain";s:7:"tag_url";s:5:"brain";}i:1665;a:2:{s:3:"tag";s:7:"improve";s:7:"tag_url";s:7:"improve";}i:1666;a:2:{s:3:"tag";s:16:"scott g. halford";s:7:"tag_url";s:15:"scott-g-halford";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:914;a:22:{s:9:"thread_id";i:914;s:7:"node_id";i:48;s:5:"title";s:73:"269 Amazing Sex Games - Naughty Sex Games for Couples to Feel Horny Again";s:11:"reply_count";i:0;s:10:"view_count";i:748;s:7:"user_id";i:1;s:8:"username";s:5:"admin";s:9:"post_date";i:1527965645;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:1150;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1527965645;s:12:"last_post_id";i:1150;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:186:"a:3:{i:1667;a:2:{s:3:"tag";s:6:"couple";s:7:"tag_url";s:6:"couple";}i:1249;a:2:{s:3:"tag";s:5:"games";s:7:"tag_url";s:5:"games";}i:497;a:2:{s:3:"tag";s:3:"sex";s:7:"tag_url";s:3:"sex";}}";s:13:"titleCensored";b:1;s:10:"hasPreview";b:1;}i:915;a:22:{s:9:"thread_id";i:915;s:7:"node_id";i:22;s:5:"title";s:65:"Mẫu CV tiếng Nhật (dùng cho xin việc và tuyển dụng)";s:11:"reply_count";i:0;s:10:"view_count";i:691;s:7:"user_id";i:1;s:8:"username";s:5:"admin";s:9:"post_date";i:1527972924;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:1152;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1527972924;s:12:"last_post_id";i:1152;s:17:"last_post_user_id";i:1;s:18:"last_post_username";s:5:"admin";s:9:"prefix_id";i:3;s:4:"tags";s:284:"a:4:{i:371;a:2:{s:3:"tag";s:10:"tieng nhat";s:7:"tag_url";s:10:"tieng-nhat";}i:159;a:2:{s:3:"tag";s:10:"tuyen dung";s:7:"tag_url";s:10:"tuyen-dung";}i:1669;a:2:{s:3:"tag";s:8:"viec lam";s:7:"tag_url";s:8:"viec-lam";}i:1668;a:2:{s:3:"tag";s:8:"xin viec";s:7:"tag_url";s:8:"xin-viec";}}";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:10;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:10;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:10;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:20;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:21;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: 0.991015
SELECT thread.*
,
MATCH(search_index.title) AGAINST ('Việt Nam Văn Phạm (Trần Trọng Kim cùng làm với Bùi Kỷ và Phạm Duy Khiêm)' 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 <> 909)
AND MATCH(search_index.title) AGAINST ('Việt Nam Văn Phạm (Trần Trọng Kim cùng làm với Bùi Kỷ và Phạm Duy Khiêm)' IN BOOLEAN MODE)
AND search_index.content_type='thread'
HAVING similar_score >= 1
ORDER BY similar_score
LIMIT 5
Run Time: 0.657021
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, 34
Run Time: 0.000310
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 <> 909)
ORDER BY RAND()
LIMIT 5
Run Time: 0.060158
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 (4992, 8117, 5589, 25288, 25189))
ORDER BY thread.post_date DESC
LIMIT 5
Run Time: 0.001275
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, 217
Run Time: 0.000203
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, 96
Run Time: 0.000182
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.000208
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, 126
Run Time: 0.000191
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 = 909)
Run Time: 0.189744
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: 0b180c32ccb62e7a7580fd833e43f587, , 1714225811
Run Time: 0.000225
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=909, 1714222211,
Run Time: 0.000156
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.009207
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.000797
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.000657
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.000210
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.000249
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |