SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000072
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
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,
IF(rate.count IS NULL, 0, rate.count) AS thread_rate_count, IF(rate.sum IS NULL, 0, rate.sum) AS thread_rate_sum, IF(rate.avg IS NULL, 0, rate.avg) AS thread_rate_avg
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
LEFT JOIN tr_thread_rate AS rate ON (rate.thread_id = thread.thread_id)
WHERE thread.thread_id = ?
Params: 417
Run Time: 0.000291
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 | |
SIMPLE | rate | const | PRIMARY | PRIMARY | 4 | const | 0 | Unique row not found |
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: 67
Run Time: 0.000282
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.*,
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)
WHERE post.thread_id = ?
AND (post.position >= 0 AND post.position < 10)
AND (post.message_state IN ('visible'))
ORDER BY post.position ASC, post.post_date ASC
Params: 417
Run Time: 0.000920
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 | dembuon_vn_d58b.post.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | dembuon_vn_d58b.post.user_id | 1 | |
SIMPLE | user_privacy | eq_ref | PRIMARY | PRIMARY | 4 | dembuon_vn_d58b.post.user_id | 1 | |
INSERT DELAYED INTO xf_thread_view
(thread_id)
VALUES
(?)
Params: 417
Run Time: 0.000096
SELECT value.*, field.field_type
FROM xf_user_field_value AS value
INNER JOIN xf_user_field AS field ON (field.field_id = value.field_id)
WHERE value.user_id = ?
Params: 1
Run Time: 0.000061
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | field | ALL | PRIMARY | | | | 6 | |
SIMPLE | value | eq_ref | PRIMARY,field_id | PRIMARY | 31 | const,dembuon_vn_d58b.field.field_id | 1 | |
SELECT * FROM xf_post WHERE post_id = '417'
Run Time: 0.000150
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT *
FROM xf_node
ORDER BY lft ASC
Run Time: 0.000163
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | ALL | | | | | 231 | Using filesort |
SELECT content_id, cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = 'node'
Params: 1
Run Time: 0.000379
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 448 | Using where |
SELECT params
FROM xf_session_activity
WHERE user_id = ?
AND controller_action = 'CreateThread'
Params: 0
Run Time: 0.001496
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | ref | PRIMARY | PRIMARY | 4 | const | 3236 | Using where |
SELECT xf_thread.thread_id,
xf_thread.node_id,
xf_thread.title,
xf_thread.reply_count,
xf_thread.view_count,
xf_thread.username,
xf_thread.post_date,
xf_thread.last_post_date,
xf_thread.last_post_user_id,
xf_thread.last_post_username,
xf_thread.prefix_id,
xf_node.title AS nodeTitle,
xf_user.user_id,
xf_user.gender,
xf_user.avatar_date
FROM xf_thread
INNER JOIN xf_node ON xf_node.node_id = xf_thread.node_id
INNER JOIN xf_user ON xf_user.user_id = xf_thread.user_id
WHERE xf_thread.title LIKE 'Tay Côn Số %'
AND xf_thread.discussion_state = 'visible'
AND xf_thread.discussion_type <> 'redirect'
AND xf_thread.post_date >= ?
AND (xf_thread.node_id = 1 OR xf_thread.node_id = 8 OR xf_thread.node_id = 9 OR xf_thread.node_id = 10 OR xf_thread.node_id = 11 OR xf_thread.node_id = 13 OR xf_thread.node_id = 14 OR xf_thread.node_id = 15 OR xf_thread.node_id = 16 OR xf_thread.node_id = 17 OR xf_thread.node_id = 18 OR xf_thread.node_id = 19 OR xf_thread.node_id = 20 OR xf_thread.node_id = 21 OR xf_thread.node_id = 22 OR xf_thread.node_id = 23 OR xf_thread.node_id = 24 OR xf_thread.node_id = 25 OR xf_thread.node_id = 26 OR xf_thread.node_id = 27 OR xf_thread.node_id = 28 OR xf_thread.node_id = 29 OR xf_thread.node_id = 30 OR xf_thread.node_id = 31 OR xf_thread.node_id = 32 OR xf_thread.node_id = 2 OR xf_thread.node_id = 33 OR xf_thread.node_id = 34 OR xf_thread.node_id = 35 OR xf_thread.node_id = 36 OR xf_thread.node_id = 37 OR xf_thread.node_id = 38 OR xf_thread.node_id = 39 OR xf_thread.node_id = 40 OR xf_thread.node_id = 41 OR xf_thread.node_id = 42 OR xf_thread.node_id = 43 OR xf_thread.node_id = 44 OR xf_thread.node_id = 45 OR xf_thread.node_id = 46 OR xf_thread.node_id = 47 OR xf_thread.node_id = 48 OR xf_thread.node_id = 49 OR xf_thread.node_id = 50 OR xf_thread.node_id = 51 OR xf_thread.node_id = 52 OR xf_thread.node_id = 205 OR xf_thread.node_id = 206 OR xf_thread.node_id = 210 OR xf_thread.node_id = 211 OR xf_thread.node_id = 213 OR xf_thread.node_id = 244 OR xf_thread.node_id = 208 OR xf_thread.node_id = 220 OR xf_thread.node_id = 221 OR xf_thread.node_id = 222 OR xf_thread.node_id = 223 OR xf_thread.node_id = 224 OR xf_thread.node_id = 225 OR xf_thread.node_id = 226 OR xf_thread.node_id = 3 OR xf_thread.node_id = 63 OR xf_thread.node_id = 64 OR xf_thread.node_id = 65 OR xf_thread.node_id = 66 OR xf_thread.node_id = 67 OR xf_thread.node_id = 73 OR xf_thread.node_id = 74 OR xf_thread.node_id = 75 OR xf_thread.node_id = 76 OR xf_thread.node_id = 77 OR xf_thread.node_id = 78 OR xf_thread.node_id = 79 OR xf_thread.node_id = 80 OR xf_thread.node_id = 81 OR xf_thread.node_id = 82 OR xf_thread.node_id = 83 OR xf_thread.node_id = 84 OR xf_thread.node_id = 85 OR xf_thread.node_id = 86 OR xf_thread.node_id = 87 OR xf_thread.node_id = 88 OR xf_thread.node_id = 89 OR xf_thread.node_id = 90 OR xf_thread.node_id = 91 OR xf_thread.node_id = 92 OR xf_thread.node_id = 103 OR xf_thread.node_id = 104 OR xf_thread.node_id = 105 OR xf_thread.node_id = 106 OR xf_thread.node_id = 107 OR xf_thread.node_id = 246 OR xf_thread.node_id = 247 OR xf_thread.node_id = 248 OR xf_thread.node_id = 249 OR xf_thread.node_id = 250 OR xf_thread.node_id = 108 OR xf_thread.node_id = 109 OR xf_thread.node_id = 110 OR xf_thread.node_id = 111 OR xf_thread.node_id = 112 OR xf_thread.node_id = 4 OR xf_thread.node_id = 113 OR xf_thread.node_id = 114 OR xf_thread.node_id = 115 OR xf_thread.node_id = 116 OR xf_thread.node_id = 117 OR xf_thread.node_id = 123 OR xf_thread.node_id = 124 OR xf_thread.node_id = 125 OR xf_thread.node_id = 126 OR xf_thread.node_id = 127 OR xf_thread.node_id = 133 OR xf_thread.node_id = 134 OR xf_thread.node_id = 135 OR xf_thread.node_id = 136 OR xf_thread.node_id = 137 OR xf_thread.node_id = 138 OR xf_thread.node_id = 139 OR xf_thread.node_id = 140 OR xf_thread.node_id = 141 OR xf_thread.node_id = 142 OR xf_thread.node_id = 5 OR xf_thread.node_id = 143 OR xf_thread.node_id = 144 OR xf_thread.node_id = 145 OR xf_thread.node_id = 146 OR xf_thread.node_id = 147 OR xf_thread.node_id = 148 OR xf_thread.node_id = 149 OR xf_thread.node_id = 150 OR xf_thread.node_id = 151 OR xf_thread.node_id = 152 OR xf_thread.node_id = 153 OR xf_thread.node_id = 154 OR xf_thread.node_id = 155 OR xf_thread.node_id = 156 OR xf_thread.node_id = 157 OR xf_thread.node_id = 168 OR xf_thread.node_id = 169 OR xf_thread.node_id = 170 OR xf_thread.node_id = 171 OR xf_thread.node_id = 172 OR xf_thread.node_id = 173 OR xf_thread.node_id = 174 OR xf_thread.node_id = 175 OR xf_thread.node_id = 176 OR xf_thread.node_id = 177 OR xf_thread.node_id = 6 OR xf_thread.node_id = 178 OR xf_thread.node_id = 179 OR xf_thread.node_id = 180 OR xf_thread.node_id = 181 OR xf_thread.node_id = 182 OR xf_thread.node_id = 183 OR xf_thread.node_id = 184 OR xf_thread.node_id = 185 OR xf_thread.node_id = 186 OR xf_thread.node_id = 187 OR xf_thread.node_id = 188 OR xf_thread.node_id = 189 OR xf_thread.node_id = 190 OR xf_thread.node_id = 191 OR xf_thread.node_id = 192 OR xf_thread.node_id = 193 OR xf_thread.node_id = 194 OR xf_thread.node_id = 195 OR xf_thread.node_id = 196 OR xf_thread.node_id = 197 OR xf_thread.node_id = 198 OR xf_thread.node_id = 199 OR xf_thread.node_id = 200 OR xf_thread.node_id = 201 OR xf_thread.node_id = 202 OR xf_thread.node_id = 7 OR xf_thread.node_id = 68 OR xf_thread.node_id = 69 OR xf_thread.node_id = 70 OR xf_thread.node_id = 71 OR xf_thread.node_id = 72 OR xf_thread.node_id = 118 OR xf_thread.node_id = 119 OR xf_thread.node_id = 120 OR xf_thread.node_id = 121 OR xf_thread.node_id = 122 OR xf_thread.node_id = 158 OR xf_thread.node_id = 159 OR xf_thread.node_id = 160 OR xf_thread.node_id = 161 OR xf_thread.node_id = 162 OR xf_thread.node_id = 163 OR xf_thread.node_id = 164 OR xf_thread.node_id = 165 OR xf_thread.node_id = 166 OR xf_thread.node_id = 167 OR xf_thread.node_id = 233 OR xf_thread.node_id = 234 OR xf_thread.node_id = 236 OR xf_thread.node_id = 245 OR xf_thread.node_id = 254 OR xf_thread.node_id = 235 OR xf_thread.node_id = 240 OR xf_thread.node_id = 53 OR xf_thread.node_id = 203 OR xf_thread.node_id = 54 OR xf_thread.node_id = 55 OR xf_thread.node_id = 56 OR xf_thread.node_id = 57 OR xf_thread.node_id = 95 OR xf_thread.node_id = 96 OR xf_thread.node_id = 97 OR xf_thread.node_id = 99 OR xf_thread.node_id = 100 OR xf_thread.node_id = 93 OR xf_thread.node_id = 98 OR xf_thread.node_id = 101 OR xf_thread.node_id = 102 OR xf_thread.node_id = 58 OR xf_thread.node_id = 59 OR xf_thread.node_id = 60 OR xf_thread.node_id = 61 OR xf_thread.node_id = 62)
AND xf_thread.thread_id <> '417'
ORDER BY xf_thread.title DESC
LIMIT ?
Params: 0, 5
Run Time: 0.034545
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post,post_date,user_id | PRIMARY | 4 | | 41081 | Using where; Using filesort |
SIMPLE | xf_node | eq_ref | PRIMARY | PRIMARY | 4 | dembuon_vn_d58b.xf_thread.node_id | 1 | |
SIMPLE | xf_user | eq_ref | PRIMARY | PRIMARY | 4 | dembuon_vn_d58b.xf_thread.user_id | 1 | |
SELECT xf_thread.thread_id,
xf_thread.node_id,
xf_thread.title,
xf_thread.reply_count,
xf_thread.view_count,
xf_thread.username,
xf_thread.post_date,
xf_thread.last_post_date,
xf_thread.last_post_user_id,
xf_thread.last_post_username,
xf_thread.prefix_id,
xf_node.title AS nodeTitle,
xf_user.user_id,
xf_user.gender,
xf_user.avatar_date
FROM xf_thread
INNER JOIN xf_node ON xf_node.node_id = xf_thread.node_id
INNER JOIN xf_user ON xf_user.user_id = xf_thread.user_id
WHERE xf_thread.title LIKE '%Tay %'
AND xf_thread.title LIKE '% Côn %'
AND xf_thread.title LIKE '% Số%'
AND xf_thread.discussion_state = 'visible'
AND xf_thread.discussion_type <> 'redirect'
AND xf_thread.post_date >= ?
AND (xf_thread.node_id = 1 OR xf_thread.node_id = 8 OR xf_thread.node_id = 9 OR xf_thread.node_id = 10 OR xf_thread.node_id = 11 OR xf_thread.node_id = 13 OR xf_thread.node_id = 14 OR xf_thread.node_id = 15 OR xf_thread.node_id = 16 OR xf_thread.node_id = 17 OR xf_thread.node_id = 18 OR xf_thread.node_id = 19 OR xf_thread.node_id = 20 OR xf_thread.node_id = 21 OR xf_thread.node_id = 22 OR xf_thread.node_id = 23 OR xf_thread.node_id = 24 OR xf_thread.node_id = 25 OR xf_thread.node_id = 26 OR xf_thread.node_id = 27 OR xf_thread.node_id = 28 OR xf_thread.node_id = 29 OR xf_thread.node_id = 30 OR xf_thread.node_id = 31 OR xf_thread.node_id = 32 OR xf_thread.node_id = 2 OR xf_thread.node_id = 33 OR xf_thread.node_id = 34 OR xf_thread.node_id = 35 OR xf_thread.node_id = 36 OR xf_thread.node_id = 37 OR xf_thread.node_id = 38 OR xf_thread.node_id = 39 OR xf_thread.node_id = 40 OR xf_thread.node_id = 41 OR xf_thread.node_id = 42 OR xf_thread.node_id = 43 OR xf_thread.node_id = 44 OR xf_thread.node_id = 45 OR xf_thread.node_id = 46 OR xf_thread.node_id = 47 OR xf_thread.node_id = 48 OR xf_thread.node_id = 49 OR xf_thread.node_id = 50 OR xf_thread.node_id = 51 OR xf_thread.node_id = 52 OR xf_thread.node_id = 205 OR xf_thread.node_id = 206 OR xf_thread.node_id = 210 OR xf_thread.node_id = 211 OR xf_thread.node_id = 213 OR xf_thread.node_id = 244 OR xf_thread.node_id = 208 OR xf_thread.node_id = 220 OR xf_thread.node_id = 221 OR xf_thread.node_id = 222 OR xf_thread.node_id = 223 OR xf_thread.node_id = 224 OR xf_thread.node_id = 225 OR xf_thread.node_id = 226 OR xf_thread.node_id = 3 OR xf_thread.node_id = 63 OR xf_thread.node_id = 64 OR xf_thread.node_id = 65 OR xf_thread.node_id = 66 OR xf_thread.node_id = 67 OR xf_thread.node_id = 73 OR xf_thread.node_id = 74 OR xf_thread.node_id = 75 OR xf_thread.node_id = 76 OR xf_thread.node_id = 77 OR xf_thread.node_id = 78 OR xf_thread.node_id = 79 OR xf_thread.node_id = 80 OR xf_thread.node_id = 81 OR xf_thread.node_id = 82 OR xf_thread.node_id = 83 OR xf_thread.node_id = 84 OR xf_thread.node_id = 85 OR xf_thread.node_id = 86 OR xf_thread.node_id = 87 OR xf_thread.node_id = 88 OR xf_thread.node_id = 89 OR xf_thread.node_id = 90 OR xf_thread.node_id = 91 OR xf_thread.node_id = 92 OR xf_thread.node_id = 103 OR xf_thread.node_id = 104 OR xf_thread.node_id = 105 OR xf_thread.node_id = 106 OR xf_thread.node_id = 107 OR xf_thread.node_id = 246 OR xf_thread.node_id = 247 OR xf_thread.node_id = 248 OR xf_thread.node_id = 249 OR xf_thread.node_id = 250 OR xf_thread.node_id = 108 OR xf_thread.node_id = 109 OR xf_thread.node_id = 110 OR xf_thread.node_id = 111 OR xf_thread.node_id = 112 OR xf_thread.node_id = 4 OR xf_thread.node_id = 113 OR xf_thread.node_id = 114 OR xf_thread.node_id = 115 OR xf_thread.node_id = 116 OR xf_thread.node_id = 117 OR xf_thread.node_id = 123 OR xf_thread.node_id = 124 OR xf_thread.node_id = 125 OR xf_thread.node_id = 126 OR xf_thread.node_id = 127 OR xf_thread.node_id = 133 OR xf_thread.node_id = 134 OR xf_thread.node_id = 135 OR xf_thread.node_id = 136 OR xf_thread.node_id = 137 OR xf_thread.node_id = 138 OR xf_thread.node_id = 139 OR xf_thread.node_id = 140 OR xf_thread.node_id = 141 OR xf_thread.node_id = 142 OR xf_thread.node_id = 5 OR xf_thread.node_id = 143 OR xf_thread.node_id = 144 OR xf_thread.node_id = 145 OR xf_thread.node_id = 146 OR xf_thread.node_id = 147 OR xf_thread.node_id = 148 OR xf_thread.node_id = 149 OR xf_thread.node_id = 150 OR xf_thread.node_id = 151 OR xf_thread.node_id = 152 OR xf_thread.node_id = 153 OR xf_thread.node_id = 154 OR xf_thread.node_id = 155 OR xf_thread.node_id = 156 OR xf_thread.node_id = 157 OR xf_thread.node_id = 168 OR xf_thread.node_id = 169 OR xf_thread.node_id = 170 OR xf_thread.node_id = 171 OR xf_thread.node_id = 172 OR xf_thread.node_id = 173 OR xf_thread.node_id = 174 OR xf_thread.node_id = 175 OR xf_thread.node_id = 176 OR xf_thread.node_id = 177 OR xf_thread.node_id = 6 OR xf_thread.node_id = 178 OR xf_thread.node_id = 179 OR xf_thread.node_id = 180 OR xf_thread.node_id = 181 OR xf_thread.node_id = 182 OR xf_thread.node_id = 183 OR xf_thread.node_id = 184 OR xf_thread.node_id = 185 OR xf_thread.node_id = 186 OR xf_thread.node_id = 187 OR xf_thread.node_id = 188 OR xf_thread.node_id = 189 OR xf_thread.node_id = 190 OR xf_thread.node_id = 191 OR xf_thread.node_id = 192 OR xf_thread.node_id = 193 OR xf_thread.node_id = 194 OR xf_thread.node_id = 195 OR xf_thread.node_id = 196 OR xf_thread.node_id = 197 OR xf_thread.node_id = 198 OR xf_thread.node_id = 199 OR xf_thread.node_id = 200 OR xf_thread.node_id = 201 OR xf_thread.node_id = 202 OR xf_thread.node_id = 7 OR xf_thread.node_id = 68 OR xf_thread.node_id = 69 OR xf_thread.node_id = 70 OR xf_thread.node_id = 71 OR xf_thread.node_id = 72 OR xf_thread.node_id = 118 OR xf_thread.node_id = 119 OR xf_thread.node_id = 120 OR xf_thread.node_id = 121 OR xf_thread.node_id = 122 OR xf_thread.node_id = 158 OR xf_thread.node_id = 159 OR xf_thread.node_id = 160 OR xf_thread.node_id = 161 OR xf_thread.node_id = 162 OR xf_thread.node_id = 163 OR xf_thread.node_id = 164 OR xf_thread.node_id = 165 OR xf_thread.node_id = 166 OR xf_thread.node_id = 167 OR xf_thread.node_id = 233 OR xf_thread.node_id = 234 OR xf_thread.node_id = 236 OR xf_thread.node_id = 245 OR xf_thread.node_id = 254 OR xf_thread.node_id = 235 OR xf_thread.node_id = 240 OR xf_thread.node_id = 53 OR xf_thread.node_id = 203 OR xf_thread.node_id = 54 OR xf_thread.node_id = 55 OR xf_thread.node_id = 56 OR xf_thread.node_id = 57 OR xf_thread.node_id = 95 OR xf_thread.node_id = 96 OR xf_thread.node_id = 97 OR xf_thread.node_id = 99 OR xf_thread.node_id = 100 OR xf_thread.node_id = 93 OR xf_thread.node_id = 98 OR xf_thread.node_id = 101 OR xf_thread.node_id = 102 OR xf_thread.node_id = 58 OR xf_thread.node_id = 59 OR xf_thread.node_id = 60 OR xf_thread.node_id = 61 OR xf_thread.node_id = 62)
AND xf_thread.thread_id <> '417'
ORDER BY xf_thread.title DESC
LIMIT ?
Params: 0, 5
Run Time: 0.067650
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post,post_date,user_id | PRIMARY | 4 | | 41081 | Using where; Using filesort |
SIMPLE | xf_node | eq_ref | PRIMARY | PRIMARY | 4 | dembuon_vn_d58b.xf_thread.node_id | 1 | |
SIMPLE | xf_user | eq_ref | PRIMARY | PRIMARY | 4 | dembuon_vn_d58b.xf_thread.user_id | 1 | |
SELECT xf_thread.thread_id,
xf_thread.node_id,
xf_thread.title,
xf_thread.reply_count,
xf_thread.view_count,
xf_thread.username,
xf_thread.post_date,
xf_thread.last_post_date,
xf_thread.last_post_user_id,
xf_thread.last_post_username,
xf_thread.prefix_id,
xf_node.title AS nodeTitle,
xf_user.user_id,
xf_user.gender,
xf_user.avatar_date
FROM xf_thread
INNER JOIN xf_node ON xf_node.node_id = xf_thread.node_id
INNER JOIN xf_user ON xf_user.user_id = xf_thread.user_id
WHERE xf_thread.title LIKE '%Tay%'
AND xf_thread.title LIKE '%Côn%'
AND xf_thread.discussion_state = 'visible'
AND xf_thread.discussion_type <> 'redirect'
AND xf_thread.post_date >= ?
AND (xf_thread.node_id = 1 OR xf_thread.node_id = 8 OR xf_thread.node_id = 9 OR xf_thread.node_id = 10 OR xf_thread.node_id = 11 OR xf_thread.node_id = 13 OR xf_thread.node_id = 14 OR xf_thread.node_id = 15 OR xf_thread.node_id = 16 OR xf_thread.node_id = 17 OR xf_thread.node_id = 18 OR xf_thread.node_id = 19 OR xf_thread.node_id = 20 OR xf_thread.node_id = 21 OR xf_thread.node_id = 22 OR xf_thread.node_id = 23 OR xf_thread.node_id = 24 OR xf_thread.node_id = 25 OR xf_thread.node_id = 26 OR xf_thread.node_id = 27 OR xf_thread.node_id = 28 OR xf_thread.node_id = 29 OR xf_thread.node_id = 30 OR xf_thread.node_id = 31 OR xf_thread.node_id = 32 OR xf_thread.node_id = 2 OR xf_thread.node_id = 33 OR xf_thread.node_id = 34 OR xf_thread.node_id = 35 OR xf_thread.node_id = 36 OR xf_thread.node_id = 37 OR xf_thread.node_id = 38 OR xf_thread.node_id = 39 OR xf_thread.node_id = 40 OR xf_thread.node_id = 41 OR xf_thread.node_id = 42 OR xf_thread.node_id = 43 OR xf_thread.node_id = 44 OR xf_thread.node_id = 45 OR xf_thread.node_id = 46 OR xf_thread.node_id = 47 OR xf_thread.node_id = 48 OR xf_thread.node_id = 49 OR xf_thread.node_id = 50 OR xf_thread.node_id = 51 OR xf_thread.node_id = 52 OR xf_thread.node_id = 205 OR xf_thread.node_id = 206 OR xf_thread.node_id = 210 OR xf_thread.node_id = 211 OR xf_thread.node_id = 213 OR xf_thread.node_id = 244 OR xf_thread.node_id = 208 OR xf_thread.node_id = 220 OR xf_thread.node_id = 221 OR xf_thread.node_id = 222 OR xf_thread.node_id = 223 OR xf_thread.node_id = 224 OR xf_thread.node_id = 225 OR xf_thread.node_id = 226 OR xf_thread.node_id = 3 OR xf_thread.node_id = 63 OR xf_thread.node_id = 64 OR xf_thread.node_id = 65 OR xf_thread.node_id = 66 OR xf_thread.node_id = 67 OR xf_thread.node_id = 73 OR xf_thread.node_id = 74 OR xf_thread.node_id = 75 OR xf_thread.node_id = 76 OR xf_thread.node_id = 77 OR xf_thread.node_id = 78 OR xf_thread.node_id = 79 OR xf_thread.node_id = 80 OR xf_thread.node_id = 81 OR xf_thread.node_id = 82 OR xf_thread.node_id = 83 OR xf_thread.node_id = 84 OR xf_thread.node_id = 85 OR xf_thread.node_id = 86 OR xf_thread.node_id = 87 OR xf_thread.node_id = 88 OR xf_thread.node_id = 89 OR xf_thread.node_id = 90 OR xf_thread.node_id = 91 OR xf_thread.node_id = 92 OR xf_thread.node_id = 103 OR xf_thread.node_id = 104 OR xf_thread.node_id = 105 OR xf_thread.node_id = 106 OR xf_thread.node_id = 107 OR xf_thread.node_id = 246 OR xf_thread.node_id = 247 OR xf_thread.node_id = 248 OR xf_thread.node_id = 249 OR xf_thread.node_id = 250 OR xf_thread.node_id = 108 OR xf_thread.node_id = 109 OR xf_thread.node_id = 110 OR xf_thread.node_id = 111 OR xf_thread.node_id = 112 OR xf_thread.node_id = 4 OR xf_thread.node_id = 113 OR xf_thread.node_id = 114 OR xf_thread.node_id = 115 OR xf_thread.node_id = 116 OR xf_thread.node_id = 117 OR xf_thread.node_id = 123 OR xf_thread.node_id = 124 OR xf_thread.node_id = 125 OR xf_thread.node_id = 126 OR xf_thread.node_id = 127 OR xf_thread.node_id = 133 OR xf_thread.node_id = 134 OR xf_thread.node_id = 135 OR xf_thread.node_id = 136 OR xf_thread.node_id = 137 OR xf_thread.node_id = 138 OR xf_thread.node_id = 139 OR xf_thread.node_id = 140 OR xf_thread.node_id = 141 OR xf_thread.node_id = 142 OR xf_thread.node_id = 5 OR xf_thread.node_id = 143 OR xf_thread.node_id = 144 OR xf_thread.node_id = 145 OR xf_thread.node_id = 146 OR xf_thread.node_id = 147 OR xf_thread.node_id = 148 OR xf_thread.node_id = 149 OR xf_thread.node_id = 150 OR xf_thread.node_id = 151 OR xf_thread.node_id = 152 OR xf_thread.node_id = 153 OR xf_thread.node_id = 154 OR xf_thread.node_id = 155 OR xf_thread.node_id = 156 OR xf_thread.node_id = 157 OR xf_thread.node_id = 168 OR xf_thread.node_id = 169 OR xf_thread.node_id = 170 OR xf_thread.node_id = 171 OR xf_thread.node_id = 172 OR xf_thread.node_id = 173 OR xf_thread.node_id = 174 OR xf_thread.node_id = 175 OR xf_thread.node_id = 176 OR xf_thread.node_id = 177 OR xf_thread.node_id = 6 OR xf_thread.node_id = 178 OR xf_thread.node_id = 179 OR xf_thread.node_id = 180 OR xf_thread.node_id = 181 OR xf_thread.node_id = 182 OR xf_thread.node_id = 183 OR xf_thread.node_id = 184 OR xf_thread.node_id = 185 OR xf_thread.node_id = 186 OR xf_thread.node_id = 187 OR xf_thread.node_id = 188 OR xf_thread.node_id = 189 OR xf_thread.node_id = 190 OR xf_thread.node_id = 191 OR xf_thread.node_id = 192 OR xf_thread.node_id = 193 OR xf_thread.node_id = 194 OR xf_thread.node_id = 195 OR xf_thread.node_id = 196 OR xf_thread.node_id = 197 OR xf_thread.node_id = 198 OR xf_thread.node_id = 199 OR xf_thread.node_id = 200 OR xf_thread.node_id = 201 OR xf_thread.node_id = 202 OR xf_thread.node_id = 7 OR xf_thread.node_id = 68 OR xf_thread.node_id = 69 OR xf_thread.node_id = 70 OR xf_thread.node_id = 71 OR xf_thread.node_id = 72 OR xf_thread.node_id = 118 OR xf_thread.node_id = 119 OR xf_thread.node_id = 120 OR xf_thread.node_id = 121 OR xf_thread.node_id = 122 OR xf_thread.node_id = 158 OR xf_thread.node_id = 159 OR xf_thread.node_id = 160 OR xf_thread.node_id = 161 OR xf_thread.node_id = 162 OR xf_thread.node_id = 163 OR xf_thread.node_id = 164 OR xf_thread.node_id = 165 OR xf_thread.node_id = 166 OR xf_thread.node_id = 167 OR xf_thread.node_id = 233 OR xf_thread.node_id = 234 OR xf_thread.node_id = 236 OR xf_thread.node_id = 245 OR xf_thread.node_id = 254 OR xf_thread.node_id = 235 OR xf_thread.node_id = 240 OR xf_thread.node_id = 53 OR xf_thread.node_id = 203 OR xf_thread.node_id = 54 OR xf_thread.node_id = 55 OR xf_thread.node_id = 56 OR xf_thread.node_id = 57 OR xf_thread.node_id = 95 OR xf_thread.node_id = 96 OR xf_thread.node_id = 97 OR xf_thread.node_id = 99 OR xf_thread.node_id = 100 OR xf_thread.node_id = 93 OR xf_thread.node_id = 98 OR xf_thread.node_id = 101 OR xf_thread.node_id = 102 OR xf_thread.node_id = 58 OR xf_thread.node_id = 59 OR xf_thread.node_id = 60 OR xf_thread.node_id = 61 OR xf_thread.node_id = 62)
AND xf_thread.thread_id <> '417'
ORDER BY xf_thread.title DESC
LIMIT ?
Params: 0, 5
Run Time: 0.095629
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post,post_date,user_id | PRIMARY | 4 | | 41081 | Using where; Using filesort |
SIMPLE | xf_node | eq_ref | PRIMARY | PRIMARY | 4 | dembuon_vn_d58b.xf_thread.node_id | 1 | |
SIMPLE | xf_user | eq_ref | PRIMARY | PRIMARY | 4 | dembuon_vn_d58b.xf_thread.user_id | 1 | |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 6c062b17c97e82426a5a9294f7fb5709, , 1653749440
Run Time: 0.000167
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=417, 1653745840,
Run Time: 0.000095
select value, hits
from dark_azucloud_terms_pages pages
left join dark_azucloud_terms terms on pages.term_id = terms.id
where route = ? and terms.block = 0 and terms.value is not null and last_clicked > ?
order by hits desc, last_clicked desc
limit ?
Params: threads/tay-con-so-1-viet-nam-nhac-sy-hoai-an-mua-con-nhi-khuc.417/, 1622209840, 50
Run Time: 0.000389
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | pages | ref | term_id_route,route,route_hits_last_clicked | route_hits_last_clicked | 452 | const | 2 | Using where |
SIMPLE | terms | eq_ref | PRIMARY,value,block | PRIMARY | 4 | dembuon_vn_d58b.pages.term_id | 1 | Using where |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('BRC_action_login', 'BRC_action_login_description', 'BRC_action_exchange', 'BRC_action_exchange_description', 'BRC_action_transfer', 'BRC_action_transfer_description', 'BRC_action_withdraw', 'BRC_action_withdraw_description', 'BRC_action_steal', 'BRC_action_steal_description', 'BRC_action_paypalPayment', 'BRC_action_paypalPayment_description', 'BRC_action_paypalPaymentRe', 'BRC_action_paypalPaymentRe_description', 'BRC_action_registration', 'BRC_action_registration_description', 'BRC_action_facebookAssociate', 'BRC_action_facebookAssociate_description', 'BRC_action_facebookDisassociate', 'BRC_action_facebookDisassociate_description', 'BRC_action_twitterAssociate', 'BRC_action_twitterAssociate_description', 'BRC_action_twitterDisassociate', 'BRC_action_twitterDisassociate_description', 'BRC_action_googleAssociate', 'BRC_action_googleAssociate_description', 'BRC_action_googleDisassociate', 'BRC_action_googleDisassociate_description', 'BRC_action_birthday', 'BRC_action_birthday_description', 'BRC_action_importVbb', 'BRC_action_importVbb_description', 'BRC_action_interest', 'BRC_action_interest_description', 'BRC_action_updateFullProfile', 'BRC_action_updateFullProfile_description', 'BRC_action_updateFullProfileRe', 'BRC_action_updateFullProfileRe_description', 'BRC_action_uploadAvatar', 'BRC_action_uploadAvatar_description', 'BRC_action_uploadAvatarRe', 'BRC_action_uploadAvatarRe_description', 'BRC_action_updateStatus', 'BRC_action_updateStatus_description', 'BRC_action_follow', 'BRC_action_follow_description', 'BRC_action_followRe', 'BRC_action_followRe_description', 'BRC_action_getFollower', 'BRC_action_getFollower_description', 'BRC_action_getFollowerRe', 'BRC_action_getFollowerRe_description', 'BRC_action_profilePost', 'BRC_action_profilePost_description', 'BRC_action_getProfilePost', 'BRC_action_getProfilePost_description', 'BRC_action_likeProfilePost', 'BRC_action_likeProfilePost_description', 'BRC_action_likeProfilePostRe', 'BRC_action_likeProfilePostRe_description', 'BRC_action_receiveProfilePostLike', 'BRC_action_receiveProfilePostLike_description', 'BRC_action_receiveProfilePostLikeRe', 'BRC_action_receiveProfilePostLikeRe_description', 'BRC_action_createConversation', 'BRC_action_createConversation_description', 'BRC_action_createConversationRe', 'BRC_action_createConversationRe_description', 'BRC_action_receiveConversation', 'BRC_action_receiveConversation_description', 'BRC_action_replyConversation', 'BRC_action_replyConversation_description', 'BRC_action_conversationGetReply', 'BRC_action_conversationGetReply_description', 'BRC_action_trophyReward', 'BRC_action_trophyReward_description', 'BRC_action_dailyReward', 'BRC_action_dailyReward_description', 'BRC_action_salary', 'BRC_action_salary_description', 'BRC_action_createNewThread', 'BRC_action_createNewThread_description', 'BRC_action_threadDeleted', 'BRC_action_threadDeleted_description', 'BRC_action_threadGetReply', 'BRC_action_threadGetReply_description', 'BRC_action_threadViewed', 'BRC_action_threadViewed_description', 'BRC_action_readThread', 'BRC_action_readThread_description', 'BRC_action_watchThread', 'BRC_action_watchThread_description', 'BRC_action_watchThreadRe', 'BRC_action_watchThreadRe_description', 'BRC_action_threadGetWatched', 'BRC_action_threadGetWatched_description', 'BRC_action_threadGetWatchedRe', 'BRC_action_threadGetWatchedRe_description', 'BRC_action_createNewPoll', 'BRC_action_createNewPoll_description', 'BRC_action_votePoll', 'BRC_action_votePoll_description', 'BRC_action_pollGetVote', 'BRC_action_pollGetVote_description', 'BRC_action_threadSticky', 'BRC_action_threadSticky_description', 'BRC_action_threadStickyRe', 'BRC_action_threadStickyRe_description', 'BRC_action_newPost', 'BRC_action_newPost_description', 'BRC_action_postDeleted', 'BRC_action_postDeleted_description', 'BRC_action_uploadAttachment', 'BRC_action_uploadAttachment_description', 'BRC_action_uploadAttachmentRe', 'BRC_action_uploadAttachmentRe_description', 'BRC_action_downloadAttachment', 'BRC_action_downloadAttachment_description', 'BRC_action_attachmentDownloaded', 'BRC_action_attachmentDownloaded_description', 'BRC_action_likePost', 'BRC_action_likePost_description', 'BRC_action_likePostRe', 'BRC_action_likePostRe_description', 'BRC_action_receivePostLike', 'BRC_action_receivePostLike_description', 'BRC_action_receivePostLikeRe', 'BRC_action_receivePostLikeRe_description', 'BRC_action_reportPost', 'BRC_action_reportPost_description', 'BRC_action_postReported', 'BRC_action_postReported_description', 'BRC_action_AzuCloud', 'BRC_action_AzuCloud_explain', 'BRC_action_BRRS_referral', 'BRC_action_BRRS_referral_explain', 'BRC_action_BRRSBuyReferralTimes', 'BRC_action_BRCIPurchaseUserUpgrade', 'BRC_action_BRCIPurchaseUserUpgrade_explain', 'VNNET_action_NLATMPayment', 'VNNET_action_NLATMPayment_explain', 'BRC_action_getbbcodePay', 'BRC_action_getbbcodePay_explain', 'BRC_action_bbcodePay', 'BRC_action_bbcodePay_explain')
Params: 2
Run Time: 0.000125
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 145 | Using where |
SELECT thread.*
,
1 AS fetched_last_post_user, user.gender, user.avatar_date, user.gravatar
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.last_post_user_id)
WHERE (thread.node_id IN (67)) AND (thread.sticky = 1) AND (thread.discussion_state IN ('visible'))
ORDER BY thread.last_post_date DESC
LIMIT 15
Run Time: 0.000306
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | ref | node_id_last_post_date,node_id_sticky_state_last_post | node_id_sticky_state_last_post | 6 | const,const,const | 1 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | dembuon_vn_d58b.thread.last_post_user_id | 1 | |
SELECT content_id, cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = 'node'
Params: 1
Run Time: 0.000555
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 448 | Using where |
SELECT node.*, forum.*
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
WHERE node.node_id IN (67)
Run Time: 0.000721
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: wfc_s13_1_thread_view_f67, a:4:{s:18:"thread_view_f67_16";a:2:{s:4:"html";s:898:"<div class="avatarList">
<ul>
<li class="thread-58781 thread-node-67">
<a href="members/chin.36201/" class="avatar Av36201s" data-avatarhtml="true"><img src="data/avatars/s/36/36201.jpg?1643732317" width="48" height="48" alt="Chin" /></a>
<a title="Lưu Ý Khi Đăng Bài Viết Trong Box Video Clip" class="Tooltip"
href="posts/836334/">
Lưu Ý Khi Đăng Bài Viết Trong...
</a>
<div class="userTitle">
<a href="members/chin.36201/" class="username">Chin</a> replied <span class="DateTime" title="22 Tháng sáu 2021 lúc 3:32 PM">22 Tháng sáu 2021</span>
</div>
</li>
</ul>
</div>
<div id="PreviewTooltip">
<span class="arrow"><span></span></span>
<div class="section">
<div class="primaryContent previewContent">
<span class="PreviewContents">Đang tải...</span>
</div>
</div>
</div>";s:4:"time";i:1653745840;}s:17:"thread_view_f67_5";a:2:{s:4:"html";s:0:"";s:4:"time";i:1653745488;}s:17:"thread_view_f67_3";a:2:{s:4:"html";s:0:"";s:4:"time";i:1653745488;}s:18:"thread_view_f67_13";a:2:{s:4:"html";s:0:"";s:4:"time";i:1653745488;}}
Run Time: 0.000178
SELECT *
FROM xf_node
ORDER BY lft ASC
Run Time: 0.000236
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | ALL | | | | | 231 | Using filesort |
SELECT thread.*
,
user.gender, user.avatar_date, user.gravatar
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
WHERE ((thread.node_id IN (67)) AND (thread.sticky = 0) AND (thread.discussion_state IN ('visible'))) AND (thread.post_date > 1652536240)
ORDER BY thread.view_count DESC
LIMIT 15
Run Time: 0.001042
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | ref | node_id_last_post_date,node_id_sticky_state_last_post,post_date | node_id_sticky_state_last_post | 6 | const,const,const | 322 | Using index condition; Using where; Using filesort |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | dembuon_vn_d58b.thread.user_id | 1 | |
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: wfc_s13_1_thread_view_f67, a:4:{s:18:"thread_view_f67_16";a:2:{s:4:"html";s:898:"<div class="avatarList">
<ul>
<li class="thread-58781 thread-node-67">
<a href="members/chin.36201/" class="avatar Av36201s" data-avatarhtml="true"><img src="data/avatars/s/36/36201.jpg?1643732317" width="48" height="48" alt="Chin" /></a>
<a title="Lưu Ý Khi Đăng Bài Viết Trong Box Video Clip" class="Tooltip"
href="posts/836334/">
Lưu Ý Khi Đăng Bài Viết Trong...
</a>
<div class="userTitle">
<a href="members/chin.36201/" class="username">Chin</a> replied <span class="DateTime" title="22 Tháng sáu 2021 lúc 3:32 PM">22 Tháng sáu 2021</span>
</div>
</li>
</ul>
</div>
<div id="PreviewTooltip">
<span class="arrow"><span></span></span>
<div class="section">
<div class="primaryContent previewContent">
<span class="PreviewContents">Đang tải...</span>
</div>
</div>
</div>";s:4:"time";i:1653745840;}s:17:"thread_view_f67_5";a:2:{s:4:"html";s:0:"";s:4:"time";i:1653745840;}s:17:"thread_view_f67_3";a:2:{s:4:"html";s:0:"";s:4:"time";i:1653745488;}s:18:"thread_view_f67_13";a:2:{s:4:"html";s:0:"";s:4:"time";i:1653745488;}}
Run Time: 0.000144
SELECT thread.*
,
user.gender, user.avatar_date, user.gravatar
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
WHERE ((thread.node_id IN (67)) AND (thread.discussion_state IN ('visible'))) AND (thread.post_date > 1652536240)
ORDER BY thread.reply_count DESC, thread.last_post_date DESC
LIMIT 15
Run Time: 0.000867
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | ref | node_id_last_post_date,node_id_sticky_state_last_post,post_date | node_id_last_post_date | 4 | const | 323 | Using where; Using filesort |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | dembuon_vn_d58b.thread.user_id | 1 | |
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: wfc_s13_1_thread_view_f67, a:4:{s:18:"thread_view_f67_16";a:2:{s:4:"html";s:898:"<div class="avatarList">
<ul>
<li class="thread-58781 thread-node-67">
<a href="members/chin.36201/" class="avatar Av36201s" data-avatarhtml="true"><img src="data/avatars/s/36/36201.jpg?1643732317" width="48" height="48" alt="Chin" /></a>
<a title="Lưu Ý Khi Đăng Bài Viết Trong Box Video Clip" class="Tooltip"
href="posts/836334/">
Lưu Ý Khi Đăng Bài Viết Trong...
</a>
<div class="userTitle">
<a href="members/chin.36201/" class="username">Chin</a> replied <span class="DateTime" title="22 Tháng sáu 2021 lúc 3:32 PM">22 Tháng sáu 2021</span>
</div>
</li>
</ul>
</div>
<div id="PreviewTooltip">
<span class="arrow"><span></span></span>
<div class="section">
<div class="primaryContent previewContent">
<span class="PreviewContents">Đang tải...</span>
</div>
</div>
</div>";s:4:"time";i:1653745840;}s:17:"thread_view_f67_5";a:2:{s:4:"html";s:0:"";s:4:"time";i:1653745840;}s:17:"thread_view_f67_3";a:2:{s:4:"html";s:0:"";s:4:"time";i:1653745840;}s:18:"thread_view_f67_13";a:2:{s:4:"html";s:0:"";s:4:"time";i:1653745488;}}
Run Time: 0.000144
SELECT thread.*
,
user.gender, user.avatar_date, user.gravatar
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
WHERE ((thread.node_id IN (67)) AND (thread.sticky = 0) AND (thread.discussion_state IN ('visible'))) AND (thread.post_date > 1652536240)
ORDER BY thread.first_post_likes DESC, thread.last_post_date DESC
LIMIT 15
Run Time: 0.000976
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | ref | node_id_last_post_date,node_id_sticky_state_last_post,post_date | node_id_sticky_state_last_post | 6 | const,const,const | 322 | Using index condition; Using where; Using filesort |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | dembuon_vn_d58b.thread.user_id | 1 | |
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: wfc_s13_1_thread_view_f67, a:4:{s:18:"thread_view_f67_16";a:2:{s:4:"html";s:898:"<div class="avatarList">
<ul>
<li class="thread-58781 thread-node-67">
<a href="members/chin.36201/" class="avatar Av36201s" data-avatarhtml="true"><img src="data/avatars/s/36/36201.jpg?1643732317" width="48" height="48" alt="Chin" /></a>
<a title="Lưu Ý Khi Đăng Bài Viết Trong Box Video Clip" class="Tooltip"
href="posts/836334/">
Lưu Ý Khi Đăng Bài Viết Trong...
</a>
<div class="userTitle">
<a href="members/chin.36201/" class="username">Chin</a> replied <span class="DateTime" title="22 Tháng sáu 2021 lúc 3:32 PM">22 Tháng sáu 2021</span>
</div>
</li>
</ul>
</div>
<div id="PreviewTooltip">
<span class="arrow"><span></span></span>
<div class="section">
<div class="primaryContent previewContent">
<span class="PreviewContents">Đang tải...</span>
</div>
</div>
</div>";s:4:"time";i:1653745840;}s:17:"thread_view_f67_5";a:2:{s:4:"html";s:0:"";s:4:"time";i:1653745840;}s:17:"thread_view_f67_3";a:2:{s:4:"html";s:0:"";s:4:"time";i:1653745840;}s:18:"thread_view_f67_13";a:2:{s:4:"html";s:0:"";s:4:"time";i:1653745840;}}
Run Time: 0.000153
SELECT *
FROM xf_node
ORDER BY lft ASC
Run Time: 0.000201
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | ALL | | | | | 231 | Using filesort |
SELECT thread.*
,
poll.*,
forum.*
FROM xf_thread AS thread
LEFT JOIN xf_poll AS poll ON
(poll.content_type = 'thread' AND content_id = thread.thread_id)
INNER JOIN xf_forum AS forum ON
(forum.node_id = thread.node_id)
WHERE ((thread.node_id IN (1, 8, 9, 10, 11, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 2, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 205, 206, 210, 211, 213, 244, 208, 220, 221, 222, 223, 224, 225, 226, 3, 63, 64, 65, 66, 67, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 103, 104, 105, 106, 107, 246, 247, 248, 249, 250, 108, 109, 110, 111, 112, 4, 113, 114, 115, 116, 117, 123, 124, 125, 126, 127, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 5, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 6, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 7, 68, 69, 70, 71, 72, 118, 119, 120, 121, 122, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 233, 234, 236, 245, 254, 235, 240, 53, 203, 54, 55, 56, 57, 95, 96, 97, 99, 100, 93, 98, 101, 102, 58, 59, 60, 61, 62)) AND (thread.discussion_open = 1) AND (thread.discussion_state IN ('visible'))) AND (thread.discussion_type = 'poll')
ORDER BY RAND()
LIMIT 3
Run Time: 0.224046
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | forum | ALL | PRIMARY | | | | 227 | Using temporary; Using filesort |
SIMPLE | thread | ref | node_id_last_post_date,node_id_sticky_state_last_post | node_id_sticky_state_last_post | 4 | dembuon_vn_d58b.forum.node_id | 200 | Using index condition; Using where |
SIMPLE | poll | eq_ref | content_type_content_id | content_type_content_id | 31 | const,dembuon_vn_d58b.thread.thread_id | 1 | Using where |
SELECT *
FROM xf_poll
WHERE content_type = ?
AND content_id = ?
Params: thread, 949
Run Time: 0.000131
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_poll | const | content_type_content_id | content_type_content_id | 31 | const,const | 1 | |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 110
Run Time: 0.000387
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 | |