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 (452396, 451882, 451246, 450752, 450178, 449206, 449201, 448293, 448232, 448067, 446584, 446454, 446138, 444615, 441266, 439707, 438002, 437682, 435981, 434107, 434020, 432655, 432312, 432297, 432077, 430224, 430018, 428286, 427769, 426951, 421706, 421702, 420265, 419126, 418855, 418849, 417314, 417313, 416745, 413523, 408880, 408728, 406191, 401871, 398972, 396844, 395075, 395048, 394271, 389970, 389917, 388850, 387755, 387153, 384193, 382856, 378434, 378432, 368608, 367215, 365994, 365365, 364971, 363102, 360936, 359076, 357065, 353619, 352892, 351661, 351146, 350481, 349939, 348727, 347228, 343855, 343821, 343175, 340788, 340757, 340696, 340687, 338293, 338410, 336654, 334854, 332009, 331046, 330939, 330633, 328313, 328041, 326971, 325946, 324691, 323582, 323577, 321538, 321224, 320974, 320725, 320668, 319908, 319611, 319409, 319353, 318945, 318137, 317678, 317017, 316935, 316686, 316484, 316106, 315737, 315475, 314914, 313729, 313520, 312895, 312114, 311671, 310876, 310302, 308781, 305446, 304219, 303682, 302400, 302388, 302354, 301367, 301363, 298648, 296997, 295216, 294203, 293053, 292261, 292258, 292162, 291637, 290900, 290877, 290665, 289598, 289271, 287608, 287520, 287386, 287045, 287038, 287037, 287036, 287008, 287005, 286768, 286758, 286752, 286749, 286739, 286732, 286731, 286730, 286729, 286600, 286478, 286332, 286233, 286232, 286231, 286223, 285405, 285168, 285051, 283445, 283419, 283403, 283386, 283248, 283228, 283225, 283158, 282903, 282822, 282122, 282096, 281815, 281613, 280750, 278408, 278083, 274809, 273501, 269526, 263036, 258056, 253570, 249629, 247073)
Run Time: 0.033333
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: 299, 0, 1656111910, 1656115510, [["thread",452396],["thread",451882],["thread",451246],["thread",450752],["thread",450178],["thread",449206],["thread",449201],["thread",448293],["thread",448232],["thread",448067],["thread",446584],["thread",446454],["thread",446138],["thread",444615],["thread",441266],["thread",439707],["thread",438002],["thread",437682],["thread",435981],["thread",434107],["thread",434020],["thread",432655],["thread",432312],["thread",432297],["thread",432077],["thread",430224],["thread",430018],["thread",428286],["thread",427769],["thread",426951],["thread",421706],["thread",421702],["thread",420265],["thread",419126],["thread",418855],["thread",418849],["thread",417314],["thread",417313],["thread",416745],["thread",413523],["thread",408880],["thread",408728],["thread",406191],["thread",401871],["thread",398972],["thread",396844],["thread",395075],["thread",395048],["thread",394271],["thread",389970],["thread",389917],["thread",388850],["thread",387755],["thread",387153],["thread",384193],["thread",382856],["thread",378434],["thread",378432],["thread",368608],["thread",367215],["thread",365994],["thread",365365],["thread",364971],["thread",363102],["thread",360936],["thread",359076],["thread",357065],["thread",353619],["thread",352892],["thread",351661],["thread",351146],["thread",350481],["thread",349939],["thread",348727],["thread",347228],["thread",343855],["thread",343821],["thread",343175],["thread",340788],["thread",340757],["thread",340696],["thread",340687],["thread",338293],["thread",338410],["thread",336654],["thread",334854],["thread",332009],["thread",331046],["thread",330939],["thread",330633],["thread",328313],["thread",328041],["thread",326971],["thread",325946],["thread",324691],["thread",323582],["thread",323577],["thread",321538],["thread",321224],["thread",320974],["thread",320725],["thread",320668],["thread",319908],["thread",319611],["thread",319409],["thread",319353],["thread",318945],["thread",318137],["thread",317678],["thread",317017],["thread",316935],["thread",316686],["thread",316484],["thread",316106],["thread",315737],["thread",315475],["thread",314914],["thread",313729],["thread",313520],["thread",312895],["thread",312114],["thread",311671],["thread",310876],["thread",310302],["thread",308781],["thread",305446],["thread",304219],["thread",303682],["thread",302400],["thread",302388],["thread",302354],["thread",301367],["thread",301363],["thread",298648],["thread",296997],["thread",295216],["thread",294203],["thread",293053],["thread",292261],["thread",292258],["thread",292162],["thread",291637],["thread",290900],["thread",290877],["thread",290665],["thread",289598],["thread",289271],["thread",287608],["thread",287520],["thread",287386],["thread",287045],["thread",287038],["thread",287037],["thread",287036],["thread",287008],["thread",287005],["thread",286768],["thread",286758],["thread",286752],["thread",286749],["thread",286739],["thread",286732],["thread",286731],["thread",286730],["thread",286729],["thread",286600],["thread",286478],["thread",286332],["thread",286233],["thread",286232],["thread",286231],["thread",286223],["thread",285405],["thread",285168],["thread",285051],["thread",283445],["thread",283419],["thread",283403],["thread",283386],["thread",283248],["thread",283228],["thread",283225],["thread",283158],["thread",282903],["thread",282822],["thread",282122],["thread",282096],["thread",281815],["thread",281613],["thread",280750],["thread",278408],["thread",278083],["thread",274809],["thread",273501],["thread",269526],["thread",263036],["thread",258056],["thread",253570],["thread",249629],["thread",247073]]
Run Time: 0.003321