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 (453163, 449169, 448277, 448272, 448267, 447979, 447590, 447294, 447174, 447032, 446983, 446880, 446833, 445386, 445385, 445384, 445381, 445378, 445241, 445149, 444850, 444844, 444829, 444827, 444812, 444406, 444391, 444339, 443836, 443823, 442050, 442049, 442047, 438290, 437780, 437668, 426112, 425160, 409626, 338772, 338763, 302925, 302923, 302922, 298087, 293480, 292278, 292099, 286762, 286755, 279934, 279257, 278469, 276046, 274957, 273062, 232175, 232132, 231951, 231944, 231617, 231012, 230774, 230771, 230767, 222949, 218796, 218417, 217622, 217618, 217385, 217379, 217322, 213308, 213302, 212877, 212028, 212004, 211981, 211477, 210685, 210656, 210437, 210255, 210237, 210232, 210229, 210180, 210073, 210039, 210037, 209590, 209479, 209264, 209240, 208532, 208372, 208113, 208008, 207759, 207563, 207505, 207418, 207341, 206674, 205835, 205734, 205688, 203518, 193260, 183494, 179958, 153957, 153945, 150038, 149995, 146363, 137024, 135748, 135119, 133824, 133792, 133745, 133741, 133434, 133422, 133287, 133254, 133208, 133204, 133183, 133162, 133160, 133124, 133021, 133006)
Run Time: 0.026789
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 136 | 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: 47521, 0, 1652947518, 1652951118, [["thread",453163],["thread",449169],["thread",448277],["thread",448272],["thread",448267],["thread",447979],["thread",447590],["thread",447294],["thread",447174],["thread",447032],["thread",446983],["thread",446880],["thread",446833],["thread",445386],["thread",445385],["thread",445384],["thread",445381],["thread",445378],["thread",445241],["thread",445149],["thread",444850],["thread",444844],["thread",444829],["thread",444827],["thread",444812],["thread",444406],["thread",444391],["thread",444339],["thread",443836],["thread",443823],["thread",442050],["thread",442049],["thread",442047],["thread",438290],["thread",437780],["thread",437668],["thread",426112],["thread",425160],["thread",409626],["thread",338772],["thread",338763],["thread",302925],["thread",302923],["thread",302922],["thread",298087],["thread",293480],["thread",292278],["thread",292099],["thread",286762],["thread",286755],["thread",279934],["thread",279257],["thread",278469],["thread",276046],["thread",274957],["thread",273062],["thread",232175],["thread",232132],["thread",231951],["thread",231944],["thread",231617],["thread",231012],["thread",230774],["thread",230771],["thread",230767],["thread",222949],["thread",218796],["thread",218417],["thread",217622],["thread",217618],["thread",217385],["thread",217379],["thread",217322],["thread",213308],["thread",213302],["thread",212877],["thread",212028],["thread",212004],["thread",211981],["thread",211477],["thread",210685],["thread",210656],["thread",210437],["thread",210255],["thread",210237],["thread",210232],["thread",210229],["thread",210180],["thread",210073],["thread",210039],["thread",210037],["thread",209590],["thread",209479],["thread",209264],["thread",209240],["thread",208532],["thread",208372],["thread",208113],["thread",208008],["thread",207759],["thread",207563],["thread",207505],["thread",207418],["thread",207341],["thread",206674],["thread",205835],["thread",205734],["thread",205688],["thread",203518],["thread",193260],["thread",183494],["thread",179958],["thread",153957],["thread",153945],["thread",150038],["thread",149995],["thread",146363],["thread",137024],["thread",135748],["thread",135119],["thread",133824],["thread",133792],["thread",133745],["thread",133741],["thread",133434],["thread",133422],["thread",133287],["thread",133254],["thread",133208],["thread",133204],["thread",133183],["thread",133162],["thread",133160],["thread",133124],["thread",133021],["thread",133006]]
Run Time: 0.001474