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 (443259, 368568, 366547, 365906, 365876, 365534, 365511, 365334, 365328, 364997, 364943, 363494, 363486, 363459, 363441, 363438, 363422, 363078, 363051, 362520, 362493, 361063, 360963, 358838, 357987, 357774, 357752, 357745, 354506, 353519, 353046, 352889, 352875, 352753, 352565, 352165, 351695, 351694, 351685, 351657, 351654, 351634, 351526, 351513, 351457, 351303, 351188, 351166, 351148, 351145, 351130, 350826, 350365, 350330, 349958, 349932, 349842, 349797, 349695, 349123, 348939, 348744, 348021, 347704, 346703, 346060, 342892, 342797, 341051, 339145, 338906, 332674, 327945, 325824, 323458, 323281, 323260, 323221, 323217, 322365, 321591, 321509, 321503, 321499, 321498, 319889, 319881, 319607, 319501, 319469, 319468, 319463, 319425, 319405, 319396, 319109, 319053, 319040, 319031, 318762, 318758, 318404, 318403, 318300, 318291, 318181, 318150, 318141, 318132, 317910, 317905, 317874, 317855, 317235, 317211, 317198, 317144, 317142, 317140, 317045, 316916, 316658, 316651, 316643, 316640, 316185, 316130, 316115, 316104, 315726, 315707, 315538, 315523, 315484, 315407, 315382, 315381, 315380, 315377, 314896, 314824, 314708, 314696, 314695, 314690, 314688, 314669, 314590, 314582, 314476, 314420, 314415, 314414, 314279, 314200, 314148, 313717, 313675, 313629, 313474, 313373, 313319, 312899, 312347, 312334, 312333, 312130, 311726, 311664, 311504, 308999, 304096, 303958, 301533, 298839, 298172, 298098, 297789, 297592, 296452, 295597, 295403, 294438, 294260, 294086, 293386, 292901, 291984, 290954, 290797, 289878, 289357, 288893, 288876, 288518, 288516, 275183, 275176, 267306, 262846)
Run Time: 0.021165
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: 304, 0, 1660095456, 1660099056, [["thread",443259],["thread",368568],["thread",366547],["thread",365906],["thread",365876],["thread",365534],["thread",365511],["thread",365334],["thread",365328],["thread",364997],["thread",364943],["thread",363494],["thread",363486],["thread",363459],["thread",363441],["thread",363438],["thread",363422],["thread",363078],["thread",363051],["thread",362520],["thread",362493],["thread",361063],["thread",360963],["thread",358838],["thread",357987],["thread",357774],["thread",357752],["thread",357745],["thread",354506],["thread",353519],["thread",353046],["thread",352889],["thread",352875],["thread",352753],["thread",352565],["thread",352165],["thread",351695],["thread",351694],["thread",351685],["thread",351657],["thread",351654],["thread",351634],["thread",351526],["thread",351513],["thread",351457],["thread",351303],["thread",351188],["thread",351166],["thread",351148],["thread",351145],["thread",351130],["thread",350826],["thread",350365],["thread",350330],["thread",349958],["thread",349932],["thread",349842],["thread",349797],["thread",349695],["thread",349123],["thread",348939],["thread",348744],["thread",348021],["thread",347704],["thread",346703],["thread",346060],["thread",342892],["thread",342797],["thread",341051],["thread",339145],["thread",338906],["thread",332674],["thread",327945],["thread",325824],["thread",323458],["thread",323281],["thread",323260],["thread",323221],["thread",323217],["thread",322365],["thread",321591],["thread",321509],["thread",321503],["thread",321499],["thread",321498],["thread",319889],["thread",319881],["thread",319607],["thread",319501],["thread",319469],["thread",319468],["thread",319463],["thread",319425],["thread",319405],["thread",319396],["thread",319109],["thread",319053],["thread",319040],["thread",319031],["thread",318762],["thread",318758],["thread",318404],["thread",318403],["thread",318300],["thread",318291],["thread",318181],["thread",318150],["thread",318141],["thread",318132],["thread",317910],["thread",317905],["thread",317874],["thread",317855],["thread",317235],["thread",317211],["thread",317198],["thread",317144],["thread",317142],["thread",317140],["thread",317045],["thread",316916],["thread",316658],["thread",316651],["thread",316643],["thread",316640],["thread",316185],["thread",316130],["thread",316115],["thread",316104],["thread",315726],["thread",315707],["thread",315538],["thread",315523],["thread",315484],["thread",315407],["thread",315382],["thread",315381],["thread",315380],["thread",315377],["thread",314896],["thread",314824],["thread",314708],["thread",314696],["thread",314695],["thread",314690],["thread",314688],["thread",314669],["thread",314590],["thread",314582],["thread",314476],["thread",314420],["thread",314415],["thread",314414],["thread",314279],["thread",314200],["thread",314148],["thread",313717],["thread",313675],["thread",313629],["thread",313474],["thread",313373],["thread",313319],["thread",312899],["thread",312347],["thread",312334],["thread",312333],["thread",312130],["thread",311726],["thread",311664],["thread",311504],["thread",308999],["thread",304096],["thread",303958],["thread",301533],["thread",298839],["thread",298172],["thread",298098],["thread",297789],["thread",297592],["thread",296452],["thread",295597],["thread",295403],["thread",294438],["thread",294260],["thread",294086],["thread",293386],["thread",292901],["thread",291984],["thread",290954],["thread",290797],["thread",289878],["thread",289357],["thread",288893],["thread",288876],["thread",288518],["thread",288516],["thread",275183],["thread",275176],["thread",267306],["thread",262846]]
Run Time: 0.001350