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.000448
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 26 | Using where |
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('brListenerClasses', 'brBriviumAddOns')
Run Time: 0.000158
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 2 | Using where |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000145
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: c2ad88e43fff7ce68ef8297dbe9dc8c8, a:8:{s:12:"sessionStart";i:1713490457;s:2:"ip";s:4:"¼ü";s:11:"sessionCsrf";s:16:"DBKwmlF5Uv8pfHU7";s:9:"userAgent";s:9:"claudebot";s:7:"robotId";s:0:"";s:16:"previousActivity";i:0;s:15:"isIpDiscouraged";a:2:{s:6:"result";b:0;s:7:"version";i:1487748357;}s:11:"sedoQuattro";a:1:{s:18:"noJsonRequestPaths";a:6:{s:8:"basePath";s:1:"/";s:4:"host";s:22:"diendanthammyvien.info";s:8:"protocol";s:4:"http";s:12:"fullBasePath";s:30:"http://diendanthammyvien.info/";s:10:"requestUri";s:10:"/?_debug=1";s:7:"fullUri";s:39:"http://diendanthammyvien.info/?_debug=1";}}}, 1713494057
Run Time: 0.000138
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, ¼ü, ¼ü, EWRporta_ControllerPublic_Portal, Index, valid, , 1713490457,
Run Time: 0.000085
SELECT *
FROM EWRporta_layouts
WHERE layout_id = ?
Params: portal
Run Time: 0.000120
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_layouts | const | PRIMARY | PRIMARY | 77 | const | 1 | |
SELECT *, 'disabled' AS position
FROM EWRporta_blocks
WHERE active = 1
ORDER BY block_id ASC
Run Time: 0.000252
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_blocks | index | | PRIMARY | 77 | | 17 | Using where |
SELECT * FROM EWRporta_caches
Run Time: 0.000200
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_caches | ALL | | | | | 7 | |
SELECT * FROM EWRporta_options
Run Time: 0.000271
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_options | ALL | | | | | 80 | |
SELECT xf_thread.*, xf_user.*, xf_post.message, xf_post.attach_count, xf_node.title AS node_title,
IF(xf_user.username IS NULL, xf_thread.username, xf_user.username) AS username,
IF(EWRporta_promotes.promote_date IS NULL, xf_thread.post_date, EWRporta_promotes.promote_date) AS promote_date,
EWRporta_promotes.promote_icon, EWRporta_promotes.promote_data
FROM xf_thread
LEFT JOIN xf_user ON (xf_user.user_id = xf_thread.user_id)
INNER JOIN xf_post ON (xf_post.post_id = xf_thread.first_post_id)
INNER JOIN xf_node ON (xf_node.node_id = xf_thread.node_id)
LEFT JOIN EWRporta_promotes ON (EWRporta_promotes.thread_id = xf_thread.thread_id)
WHERE ( xf_thread.node_id IN ('17', '16', '18', '20', '21', '19', '22', '23', '24', '25', '26', '27', '28') OR EWRporta_promotes.promote_date < ? )
AND xf_thread.discussion_state = 'visible'
AND IF(EWRporta_promotes.promote_date IS NULL, xf_thread.post_date, EWRporta_promotes.promote_date) < ?
ORDER BY sticky DESC, promote_date DESC
LIMIT ?, ?
Params: 1713490457, 1713490457, 0, 7
Run Time: 0.014181
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | ALL | node_id_last_post_date,node_id_sticky_state_last_post | | | | 2245 | Using where; Using temporary; Using filesort |
SIMPLE | EWRporta_promotes | ALL | PRIMARY | | | | 1 | Using where; Using join buffer (hash join) |
SIMPLE | xf_node | eq_ref | PRIMARY | PRIMARY | 4 | ddtm.xf_thread.node_id | 1 | |
SIMPLE | xf_user | eq_ref | PRIMARY | PRIMARY | 4 | ddtm.xf_thread.user_id | 1 | |
SIMPLE | xf_post | eq_ref | PRIMARY | PRIMARY | 4 | ddtm.xf_thread.first_post_id | 1 | |
SELECT attachment.*,
data.filename, data.file_size, data.file_hash, 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 (1218)
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.000267
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 | 2 | Using index condition |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | ddtm.attachment.data_id | 1 | |
SELECT attachment.*,
data.filename, data.file_size, data.file_hash, 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 (935)
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.000259
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 | 2 | Using index condition |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | ddtm.attachment.data_id | 1 | |
SELECT attachment.*,
data.filename, data.file_size, data.file_hash, 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 (923)
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.000225
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 | 2 | Using index condition |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | ddtm.attachment.data_id | 1 | |
SELECT COUNT(*) AS total
FROM xf_thread
LEFT JOIN EWRporta_promotes ON (EWRporta_promotes.thread_id = xf_thread.thread_id)
WHERE (xf_thread.node_id IN ('17', '16', '18', '20', '21', '19', '22', '23', '24', '25', '26', '27', '28') OR EWRporta_promotes.promote_date < ?)
AND xf_thread.discussion_state = 'visible'
AND IF(EWRporta_promotes.promote_date IS NULL, xf_thread.post_date, EWRporta_promotes.promote_date) < ?
Params: 1713490457, 1713490457
Run Time: 0.001816
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | ALL | node_id_last_post_date,node_id_sticky_state_last_post | | | | 2245 | Using where |
SIMPLE | EWRporta_promotes | ALL | PRIMARY | | | | 1 | Using where; Using join buffer (hash join) |
SELECT *
FROM EWRporta_caches
WHERE block_id = ?
Params: generalnews
Run Time: 0.000194
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_caches | const | PRIMARY | PRIMARY | 77 | const | 1 | |
SELECT *
FROM EWRporta_caches
WHERE block_id = ?
Params: generalnews
Run Time: 0.000149
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_caches | const | PRIMARY | PRIMARY | 77 | const | 1 | |
begin
Run Time: 0.000143
UPDATE `EWRporta_caches` SET `results` = ?, `date` = ? WHERE (block_id = 'generalnews')
Params: a:2:{s:6:"option";a:9:{s:5:"forum";a:13:{i:0;s:2:"17";i:1;s:2:"16";i:2;s:2:"18";i:3;s:2:"20";i:4;s:2:"21";i:5;s:2:"19";i:6;s:2:"22";i:7;s:2:"23";i:8;s:2:"24";i:9;s:2:"25";i:10;s:2:"26";i:11;s:2:"27";i:12;s:2:"28";}s:8:"leftdate";s:1:"0";s:5:"limit";s:1:"7";s:7:"pagenav";s:1:"0";s:6:"social";s:1:"1";s:6:"sticky";s:1:"1";s:8:"truncate";s:3:"200";s:7:"parseBB";b:1;s:5:"count";i:681;}s:11:"generalnews";a:7:{i:0;a:62:{s:9:"thread_id";i:986;s:7:"node_id";i:21;s:5:"title";s:28:"Công nghệ nâng mÅ©i 2016";s:11:"reply_count";i:1;s:10:"view_count";i:2231;s:7:"user_id";i:54;s:8:"username";s:6:"mrpham";s:9:"post_date";i:1480144676;s:6:"sticky";i:1;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:1218;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1516807143;s:12:"last_post_id";i:3437;s:17:"last_post_user_id";i:1018;s:18:"last_post_username";s:6:"Phuong";s:9:"prefix_id";i:0;s:13:"thumbnail_url";s:0:"";s:24:"thumbnail_cache_waindigo";s:0:"";s:18:"tinhte_xentag_tags";s:6:"a:0:{}";s:23:"tinhte_xentag_is_tagged";i:0;s:5:"email";s:24:"thanhquynh.tmv@gmail.com";s:6:"gender";s:4:"male";s:12:"custom_title";s:0:"";s:11:"language_id";i:2;s:8:"style_id";i:0;s:8:"timezone";s:12:"Asia/Bangkok";s:7:"visible";i:1;s:16:"activity_visible";i:1;s:13:"user_group_id";i:3;s:19:"secondary_group_ids";s:0:"";s:22:"display_style_group_id";i:3;s:25:"permission_combination_id";i:24;s:13:"message_count";i:223;s:20:"conversations_unread";i:0;s:13:"register_date";i:1466829656;s:13:"last_activity";i:1562206843;s:13:"trophy_points";i:16;s:13:"alerts_unread";i:10;s:11:"avatar_date";i:1466829752;s:12:"avatar_width";i:256;s:13:"avatar_height";i:192;s:8:"gravatar";s:0:"";s:10:"user_state";s:5:"valid";s:12:"is_moderator";i:0;s:8:"is_admin";i:1;s:9:"is_banned";i:0;s:10:"like_count";i:3;s:14:"warning_points";i:0;s:8:"is_staff";i:0;s:7:"message";s:259:"Công nghệ nâng mÅ©i má»›i nhất 2016 má»™t giải pháp nâng mÅ©i hoà n hảo đó chÃnh là công nghệ nâng mÅ©i s line giúp những ngÆ°á»i sống mÅ©i bị thấp, tẹt, lệch… có thể sở hữu dáng mÅ©i cao thẳng, là m cho khuôn...";s:12:"attach_count";i:2;s:10:"node_title";s:17:"Nâng mÅ©i đẹp";s:12:"promote_date";i:1480144676;s:12:"promote_icon";N;s:12:"promote_data";i:293;s:3:"day";s:2:"26";s:5:"month";O:14:"XenForo_Phrase":4:{s:14:"