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 (420759, 420758, 420757, 420756, 420755, 420754, 420753, 420752, 420751, 420750, 420749, 420748, 420747, 420746, 420745, 420744, 420743, 420742, 420741, 420740, 420739, 420738, 420737, 420736, 420735, 420734, 420733, 420732, 420731, 420730, 420729, 420728, 420727, 420726, 420725, 420724, 420723, 420722, 420721, 420720, 420719, 420718, 420717, 420716, 420715, 420714, 420713, 420712, 420711, 420710, 420709, 420708, 420707, 420706, 420705, 420704, 420703, 420702, 420701, 420700, 420699, 420698, 420697, 420696, 420695, 420694, 420693, 420692, 420691, 420690, 420689, 420688, 420687, 420686, 420685, 420684, 420683, 420682, 420681, 420680, 420679, 420678, 420677, 420676, 420675, 420674, 420673, 420672, 420671, 420670, 420669, 420668, 420667, 420666, 420665, 420664, 420663, 420662, 420661, 420660, 420659, 420658, 420657, 420656, 420655, 420654, 420653, 420652, 420651, 420650, 420649, 420648, 420647, 420646, 420645, 420644, 420643, 420642, 420641, 420640, 420639, 420638, 420637, 420636, 420635, 420634, 420633, 420632, 420631, 420630, 420629, 420628, 420627, 420626, 420625, 420624, 420623, 420622, 420621, 420620, 420619, 420618, 420617, 420616, 420615, 420614, 420613, 420612, 420611, 420610, 420609, 420608, 420607, 420606, 420605, 420604, 420603, 420602, 420601, 420600, 420599, 420598, 420597, 420596, 420595, 420594, 420593, 420592, 420591, 420590, 420589, 420509, 420507, 420506, 420505, 420504, 420503, 420502, 420501, 420500, 420499, 420497, 420496, 420494, 420492, 420455, 420454, 420453, 420452, 420451, 420450, 420449, 420448, 420447, 420446, 420445, 420444, 420443, 420442, 420441)
Run Time: 0.023695
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 200 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | hunsa.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | hunsa.thread.node_id | 1 | |
SIMPLE | post | eq_ref | PRIMARY | PRIMARY | 4 | hunsa.thread.first_post_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,hunsa.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: 36274, 0, 1660395857, 1660399457, [["thread",420759],["thread",420758],["thread",420757],["thread",420756],["thread",420755],["thread",420754],["thread",420753],["thread",420752],["thread",420751],["thread",420750],["thread",420749],["thread",420748],["thread",420747],["thread",420746],["thread",420745],["thread",420744],["thread",420743],["thread",420742],["thread",420741],["thread",420740],["thread",420739],["thread",420738],["thread",420737],["thread",420736],["thread",420735],["thread",420734],["thread",420733],["thread",420732],["thread",420731],["thread",420730],["thread",420729],["thread",420728],["thread",420727],["thread",420726],["thread",420725],["thread",420724],["thread",420723],["thread",420722],["thread",420721],["thread",420720],["thread",420719],["thread",420718],["thread",420717],["thread",420716],["thread",420715],["thread",420714],["thread",420713],["thread",420712],["thread",420711],["thread",420710],["thread",420709],["thread",420708],["thread",420707],["thread",420706],["thread",420705],["thread",420704],["thread",420703],["thread",420702],["thread",420701],["thread",420700],["thread",420699],["thread",420698],["thread",420697],["thread",420696],["thread",420695],["thread",420694],["thread",420693],["thread",420692],["thread",420691],["thread",420690],["thread",420689],["thread",420688],["thread",420687],["thread",420686],["thread",420685],["thread",420684],["thread",420683],["thread",420682],["thread",420681],["thread",420680],["thread",420679],["thread",420678],["thread",420677],["thread",420676],["thread",420675],["thread",420674],["thread",420673],["thread",420672],["thread",420671],["thread",420670],["thread",420669],["thread",420668],["thread",420667],["thread",420666],["thread",420665],["thread",420664],["thread",420663],["thread",420662],["thread",420661],["thread",420660],["thread",420659],["thread",420658],["thread",420657],["thread",420656],["thread",420655],["thread",420654],["thread",420653],["thread",420652],["thread",420651],["thread",420650],["thread",420649],["thread",420648],["thread",420647],["thread",420646],["thread",420645],["thread",420644],["thread",420643],["thread",420642],["thread",420641],["thread",420640],["thread",420639],["thread",420638],["thread",420637],["thread",420636],["thread",420635],["thread",420634],["thread",420633],["thread",420632],["thread",420631],["thread",420630],["thread",420629],["thread",420628],["thread",420627],["thread",420626],["thread",420625],["thread",420624],["thread",420623],["thread",420622],["thread",420621],["thread",420620],["thread",420619],["thread",420618],["thread",420617],["thread",420616],["thread",420615],["thread",420614],["thread",420613],["thread",420612],["thread",420611],["thread",420610],["thread",420609],["thread",420608],["thread",420607],["thread",420606],["thread",420605],["thread",420604],["thread",420603],["thread",420602],["thread",420601],["thread",420600],["thread",420599],["thread",420598],["thread",420597],["thread",420596],["thread",420595],["thread",420594],["thread",420593],["thread",420592],["thread",420591],["thread",420590],["thread",420589],["thread",420509],["thread",420507],["thread",420506],["thread",420505],["thread",420504],["thread",420503],["thread",420502],["thread",420501],["thread",420500],["thread",420499],["thread",420497],["thread",420496],["thread",420494],["thread",420492],["thread",420455],["thread",420454],["thread",420453],["thread",420452],["thread",420451],["thread",420450],["thread",420449],["thread",420448],["thread",420447],["thread",420446],["thread",420445],["thread",420444],["thread",420443],["thread",420442],["thread",420441]]
Run Time: 0.002076