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 (525, 524, 522, 516, 514, 513, 504, 502, 500, 499, 497, 495, 494, 493, 492, 490, 489, 488, 486, 485, 484, 482, 481, 480, 479, 477, 476, 474, 473, 472, 467, 466, 463, 460, 456, 455, 454, 452, 451, 450, 449, 447, 446, 443, 441, 440, 439, 438, 436, 435, 432, 431, 429, 428, 427, 426, 425, 423, 422, 421, 420, 419, 417, 416, 414, 413, 412, 411, 410, 408, 407, 406, 404, 403, 402, 401, 400, 399, 398, 396, 395, 394, 393, 392, 391, 390, 388, 387, 386, 385, 384, 382, 381, 380, 378, 377, 375, 374, 373, 371, 370, 369, 367, 366, 365, 363, 362, 360, 358, 355, 354, 351, 348, 345, 342, 339, 337, 333, 330, 328, 325, 323, 316, 313, 311, 306, 304, 302, 299, 296, 292, 289, 286, 284, 280, 278, 273, 268, 265, 250, 241, 233, 225, 221, 215, 209, 206, 203, 201, 198, 197, 195, 193, 190, 188, 185, 182, 177, 174, 170, 169, 168, 165, 162, 161, 156, 153, 151, 146, 144, 142)
Run Time: 0.020272
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | ALL | PRIMARY | | | | 438 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | diendanv_db.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | diendanv_db.thread.node_id | 1 | |
SIMPLE | post | eq_ref | PRIMARY | PRIMARY | 4 | diendanv_db.thread.first_post_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,diendanv_db.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: 36, 0, 1714006249, 1714009849, [["thread",525],["thread",524],["thread",522],["thread",516],["thread",514],["thread",513],["thread",504],["thread",502],["thread",500],["thread",499],["thread",497],["thread",495],["thread",494],["thread",493],["thread",492],["thread",490],["thread",489],["thread",488],["thread",486],["thread",485],["thread",484],["thread",482],["thread",481],["thread",480],["thread",479],["thread",477],["thread",476],["thread",474],["thread",473],["thread",472],["thread",467],["thread",466],["thread",463],["thread",460],["thread",456],["thread",455],["thread",454],["thread",452],["thread",451],["thread",450],["thread",449],["thread",447],["thread",446],["thread",443],["thread",441],["thread",440],["thread",439],["thread",438],["thread",436],["thread",435],["thread",432],["thread",431],["thread",429],["thread",428],["thread",427],["thread",426],["thread",425],["thread",423],["thread",422],["thread",421],["thread",420],["thread",419],["thread",417],["thread",416],["thread",414],["thread",413],["thread",412],["thread",411],["thread",410],["thread",408],["thread",407],["thread",406],["thread",404],["thread",403],["thread",402],["thread",401],["thread",400],["thread",399],["thread",398],["thread",396],["thread",395],["thread",394],["thread",393],["thread",392],["thread",391],["thread",390],["thread",388],["thread",387],["thread",386],["thread",385],["thread",384],["thread",382],["thread",381],["thread",380],["thread",378],["thread",377],["thread",375],["thread",374],["thread",373],["thread",371],["thread",370],["thread",369],["thread",367],["thread",366],["thread",365],["thread",363],["thread",362],["thread",360],["thread",358],["thread",355],["thread",354],["thread",351],["thread",348],["thread",345],["thread",342],["thread",339],["thread",337],["thread",333],["thread",330],["thread",328],["thread",325],["thread",323],["thread",316],["thread",313],["thread",311],["thread",306],["thread",304],["thread",302],["thread",299],["thread",296],["thread",292],["thread",289],["thread",286],["thread",284],["thread",280],["thread",278],["thread",273],["thread",268],["thread",265],["thread",250],["thread",241],["thread",233],["thread",225],["thread",221],["thread",215],["thread",209],["thread",206],["thread",203],["thread",201],["thread",198],["thread",197],["thread",195],["thread",193],["thread",190],["thread",188],["thread",185],["thread",182],["thread",177],["thread",174],["thread",170],["thread",169],["thread",168],["thread",165],["thread",162],["thread",161],["thread",156],["thread",153],["thread",151],["thread",146],["thread",144],["thread",142]]
Run Time: 0.000946