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 (450327, 445574, 443753, 443082, 443053, 442229, 440961, 440733, 438355, 437815, 437679, 437036, 432734, 430009, 426949, 426931, 426681, 424569, 424105, 419135, 419104, 418853, 417284, 416920, 416707, 412934, 412574, 411105, 410763, 408830, 408797, 406501, 406483, 405407, 405300, 404681, 403546, 403499, 402900, 399459, 399387, 399157, 388595, 387398, 366975, 366553, 366046, 365982, 363499, 363131, 359065, 357747, 357070, 353639, 350881, 350880, 349338, 348752, 348027, 347944, 347925, 347214, 344618, 344066, 344035, 343440, 341709, 341559, 341538, 341209, 341180, 340140, 340110, 340108, 339509, 339499, 339496, 339484, 339156, 339152, 338724, 338662, 338637, 338407, 337802, 335049, 334984, 331998, 331187, 330917, 330688, 328743, 328629, 327936, 327851, 327826, 326955, 326056, 325890, 325813, 325781, 325421, 325360, 325117, 324795, 323859, 323581, 323528, 323524, 322817, 322813, 322459, 321526, 321511, 321445, 321434, 321428, 320999, 320982, 320965, 320746, 320569, 319746, 319494, 319491, 319422, 319399, 318973, 318884, 318880, 318757, 318233, 318136, 318135, 317687, 317226, 317216, 317212, 317018, 316097, 314806, 314706, 314691, 314474, 314469, 314429, 314427, 314423, 313730, 313627, 313366, 312918, 312898, 312476, 311988, 311838, 311437, 311435, 311432, 310537, 310307, 310081, 309989, 309954, 309951, 309946, 309650, 309013, 308786, 305933, 304853, 304729, 304687, 304238, 304235, 304216, 304215, 304202, 304109, 304097, 303670, 303323, 303297, 303104, 303099, 302416, 302375, 302355, 302157, 301839, 301614, 301388, 301355, 301354, 301157, 301079, 301068, 299988, 299812, 299806)
Run Time: 0.031704
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: 290, 0, 1679457969, 1679461569, [["thread",450327],["thread",445574],["thread",443753],["thread",443082],["thread",443053],["thread",442229],["thread",440961],["thread",440733],["thread",438355],["thread",437815],["thread",437679],["thread",437036],["thread",432734],["thread",430009],["thread",426949],["thread",426931],["thread",426681],["thread",424569],["thread",424105],["thread",419135],["thread",419104],["thread",418853],["thread",417284],["thread",416920],["thread",416707],["thread",412934],["thread",412574],["thread",411105],["thread",410763],["thread",408830],["thread",408797],["thread",406501],["thread",406483],["thread",405407],["thread",405300],["thread",404681],["thread",403546],["thread",403499],["thread",402900],["thread",399459],["thread",399387],["thread",399157],["thread",388595],["thread",387398],["thread",366975],["thread",366553],["thread",366046],["thread",365982],["thread",363499],["thread",363131],["thread",359065],["thread",357747],["thread",357070],["thread",353639],["thread",350881],["thread",350880],["thread",349338],["thread",348752],["thread",348027],["thread",347944],["thread",347925],["thread",347214],["thread",344618],["thread",344066],["thread",344035],["thread",343440],["thread",341709],["thread",341559],["thread",341538],["thread",341209],["thread",341180],["thread",340140],["thread",340110],["thread",340108],["thread",339509],["thread",339499],["thread",339496],["thread",339484],["thread",339156],["thread",339152],["thread",338724],["thread",338662],["thread",338637],["thread",338407],["thread",337802],["thread",335049],["thread",334984],["thread",331998],["thread",331187],["thread",330917],["thread",330688],["thread",328743],["thread",328629],["thread",327936],["thread",327851],["thread",327826],["thread",326955],["thread",326056],["thread",325890],["thread",325813],["thread",325781],["thread",325421],["thread",325360],["thread",325117],["thread",324795],["thread",323859],["thread",323581],["thread",323528],["thread",323524],["thread",322817],["thread",322813],["thread",322459],["thread",321526],["thread",321511],["thread",321445],["thread",321434],["thread",321428],["thread",320999],["thread",320982],["thread",320965],["thread",320746],["thread",320569],["thread",319746],["thread",319494],["thread",319491],["thread",319422],["thread",319399],["thread",318973],["thread",318884],["thread",318880],["thread",318757],["thread",318233],["thread",318136],["thread",318135],["thread",317687],["thread",317226],["thread",317216],["thread",317212],["thread",317018],["thread",316097],["thread",314806],["thread",314706],["thread",314691],["thread",314474],["thread",314469],["thread",314429],["thread",314427],["thread",314423],["thread",313730],["thread",313627],["thread",313366],["thread",312918],["thread",312898],["thread",312476],["thread",311988],["thread",311838],["thread",311437],["thread",311435],["thread",311432],["thread",310537],["thread",310307],["thread",310081],["thread",309989],["thread",309954],["thread",309951],["thread",309946],["thread",309650],["thread",309013],["thread",308786],["thread",305933],["thread",304853],["thread",304729],["thread",304687],["thread",304238],["thread",304235],["thread",304216],["thread",304215],["thread",304202],["thread",304109],["thread",304097],["thread",303670],["thread",303323],["thread",303297],["thread",303104],["thread",303099],["thread",302416],["thread",302375],["thread",302355],["thread",302157],["thread",301839],["thread",301614],["thread",301388],["thread",301355],["thread",301354],["thread",301157],["thread",301079],["thread",301068],["thread",299988],["thread",299812],["thread",299806]]
Run Time: 0.001331