SELECT thread.*
,
user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
node.title AS node_title, node.node_name,
post.message, post.attach_count,
NULL AS thread_read_date,
0 AS user_post_count,
permission.cache_value AS node_permission_cache
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
LEFT JOIN xf_node AS node ON
(node.node_id = thread.node_id)
LEFT JOIN xf_post AS post ON
(post.post_id = thread.first_post_id)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'node'
AND permission.content_id = thread.node_id)
WHERE thread.thread_id IN (24631, 24630, 24629, 24628, 24627, 24626, 24625, 24624, 24604, 24603, 24602, 24601, 24600, 24599, 24598, 24597, 24594, 24582, 24581, 24580, 24579, 24578, 24577, 24576, 24575, 24574, 24573, 24572, 24571, 24558, 24557, 24556, 24555, 24554, 24553, 24552, 24551, 24534, 24533, 24532, 24531, 24530, 24529, 24528, 24522, 24521, 24520, 23608, 23607, 23601, 14631, 14630, 14629, 14626, 14625, 14624, 14623, 14622, 14621, 14620, 14619, 14552, 14551, 14550, 14548, 14547, 14543, 14542, 14501, 14500, 14499, 14498, 14495, 14494, 14493, 14492, 14491, 14490, 14488, 14486, 14485, 14484, 14480, 14464, 14463, 14462, 14461, 14460, 14453, 14452, 14451, 14450, 14437, 14436, 14383, 14382, 14381, 14380, 14379, 14378, 14377, 14376, 14375, 14374, 14373, 14372, 14371, 14363, 14362, 14361, 14351, 14350, 14349, 14348, 14347, 14346, 14345, 14344, 14343, 14342, 14341, 14340, 14339, 14338, 14337, 14336, 14335, 14332, 14329, 14328, 14315, 14314, 14303, 14290, 14289, 14288, 14281, 14277, 14276, 14236, 14235)
Run Time: 0.032672
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 141 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | chanpro.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | chanpro.thread.node_id | 1 | |
SIMPLE | post | eq_ref | PRIMARY | PRIMARY | 4 | chanpro.thread.first_post_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,chanpro.thread.node_id | 1 | Using where |
INSERT INTO xf_tag_result_cache
(tag_id, user_id, cache_date, expiry_date, results)
VALUES
(?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE
cache_date = VALUES(cache_date),
expiry_date = VALUES(expiry_date),
results = VALUES(results)
Params: 1720, 0, 1714695628, 1714699228, [["thread",24631],["thread",24630],["thread",24629],["thread",24628],["thread",24627],["thread",24626],["thread",24625],["thread",24624],["thread",24604],["thread",24603],["thread",24602],["thread",24601],["thread",24600],["thread",24599],["thread",24598],["thread",24597],["thread",24594],["thread",24582],["thread",24581],["thread",24580],["thread",24579],["thread",24578],["thread",24577],["thread",24576],["thread",24575],["thread",24574],["thread",24573],["thread",24572],["thread",24571],["thread",24558],["thread",24557],["thread",24556],["thread",24555],["thread",24554],["thread",24553],["thread",24552],["thread",24551],["thread",24534],["thread",24533],["thread",24532],["thread",24531],["thread",24530],["thread",24529],["thread",24528],["thread",24522],["thread",24521],["thread",24520],["thread",23608],["thread",23607],["thread",23601],["thread",14631],["thread",14630],["thread",14629],["thread",14626],["thread",14625],["thread",14624],["thread",14623],["thread",14622],["thread",14621],["thread",14620],["thread",14619],["thread",14552],["thread",14551],["thread",14550],["thread",14548],["thread",14547],["thread",14543],["thread",14542],["thread",14501],["thread",14500],["thread",14499],["thread",14498],["thread",14495],["thread",14494],["thread",14493],["thread",14492],["thread",14491],["thread",14490],["thread",14488],["thread",14486],["thread",14485],["thread",14484],["thread",14480],["thread",14464],["thread",14463],["thread",14462],["thread",14461],["thread",14460],["thread",14453],["thread",14452],["thread",14451],["thread",14450],["thread",14437],["thread",14436],["thread",14383],["thread",14382],["thread",14381],["thread",14380],["thread",14379],["thread",14378],["thread",14377],["thread",14376],["thread",14375],["thread",14374],["thread",14373],["thread",14372],["thread",14371],["thread",14363],["thread",14362],["thread",14361],["thread",14351],["thread",14350],["thread",14349],["thread",14348],["thread",14347],["thread",14346],["thread",14345],["thread",14344],["thread",14343],["thread",14342],["thread",14341],["thread",14340],["thread",14339],["thread",14338],["thread",14337],["thread",14336],["thread",14335],["thread",14332],["thread",14329],["thread",14328],["thread",14315],["thread",14314],["thread",14303],["thread",14290],["thread",14289],["thread",14288],["thread",14281],["thread",14277],["thread",14276],["thread",14236],["thread",14235]]
Run Time: 0.002134