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 (409893, 409892, 409891, 409890, 409889, 409888, 409887, 409885, 409884, 409883, 409881, 409880, 409879, 409877, 409876, 409875, 409874, 409873, 409872, 409871, 409870, 409869, 409868, 409866, 409865, 409863, 409862, 409860, 409859, 409858, 409857, 409856, 409855, 409854, 409853, 409852, 409851, 409850, 409849, 409848, 409847, 409846, 409845, 409844, 409843, 409842, 409841, 409840, 409839, 409838, 409837, 409836, 409835, 409834, 409833, 409830, 409829, 409828, 409827, 409826, 409825, 409824, 409823, 409822, 409821, 409820, 409819, 409817, 409813, 409812, 409811, 409810, 409809, 409808, 409807, 409806, 409805, 409804, 409801, 409800, 409799, 409798, 409796, 409795, 409792, 409791, 409790, 409787, 409785, 409784, 409783, 409782, 409781, 409780, 409779, 409778, 409777, 409775, 409773, 409772, 409770, 409769, 409767, 409766, 409765, 409764, 409763, 409761, 409758, 409757, 409755, 409753, 409750, 409748, 409746, 409745, 409744, 409743, 409738, 409737, 409735, 409733, 409732, 409731, 409730, 409729, 409728, 409727, 409724, 409723, 409721, 409718, 409716, 409715, 409713, 409712, 409710, 409708, 409707, 409705, 409704, 409702, 409701, 409700, 409699, 409698, 409697, 409696, 409694, 409692, 409690, 409688, 409686, 409680, 409674, 409673, 409672, 409671, 409670, 409665, 409663, 409661, 409659, 409656, 409654, 409653, 409650, 409484, 409483, 409481, 409480, 409479, 409478, 409477, 409476, 409475, 409474, 409473, 409471, 409470, 409469, 409468, 409467, 409466, 409464, 409463, 409462, 409461, 409460, 409459, 409458, 409457, 409456, 409455, 409454, 409452, 409451, 409450, 409449, 409448)
Run Time: 0.045285
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: 2743, 0, 1652818640, 1652822240, [["thread",409893],["thread",409892],["thread",409891],["thread",409890],["thread",409889],["thread",409888],["thread",409887],["thread",409885],["thread",409884],["thread",409883],["thread",409881],["thread",409880],["thread",409879],["thread",409877],["thread",409876],["thread",409875],["thread",409874],["thread",409873],["thread",409872],["thread",409871],["thread",409870],["thread",409869],["thread",409868],["thread",409866],["thread",409865],["thread",409863],["thread",409862],["thread",409860],["thread",409859],["thread",409858],["thread",409857],["thread",409856],["thread",409855],["thread",409854],["thread",409853],["thread",409852],["thread",409851],["thread",409850],["thread",409849],["thread",409848],["thread",409847],["thread",409846],["thread",409845],["thread",409844],["thread",409843],["thread",409842],["thread",409841],["thread",409840],["thread",409839],["thread",409838],["thread",409837],["thread",409836],["thread",409835],["thread",409834],["thread",409833],["thread",409830],["thread",409829],["thread",409828],["thread",409827],["thread",409826],["thread",409825],["thread",409824],["thread",409823],["thread",409822],["thread",409821],["thread",409820],["thread",409819],["thread",409817],["thread",409813],["thread",409812],["thread",409811],["thread",409810],["thread",409809],["thread",409808],["thread",409807],["thread",409806],["thread",409805],["thread",409804],["thread",409801],["thread",409800],["thread",409799],["thread",409798],["thread",409796],["thread",409795],["thread",409792],["thread",409791],["thread",409790],["thread",409787],["thread",409785],["thread",409784],["thread",409783],["thread",409782],["thread",409781],["thread",409780],["thread",409779],["thread",409778],["thread",409777],["thread",409775],["thread",409773],["thread",409772],["thread",409770],["thread",409769],["thread",409767],["thread",409766],["thread",409765],["thread",409764],["thread",409763],["thread",409761],["thread",409758],["thread",409757],["thread",409755],["thread",409753],["thread",409750],["thread",409748],["thread",409746],["thread",409745],["thread",409744],["thread",409743],["thread",409738],["thread",409737],["thread",409735],["thread",409733],["thread",409732],["thread",409731],["thread",409730],["thread",409729],["thread",409728],["thread",409727],["thread",409724],["thread",409723],["thread",409721],["thread",409718],["thread",409716],["thread",409715],["thread",409713],["thread",409712],["thread",409710],["thread",409708],["thread",409707],["thread",409705],["thread",409704],["thread",409702],["thread",409701],["thread",409700],["thread",409699],["thread",409698],["thread",409697],["thread",409696],["thread",409694],["thread",409692],["thread",409690],["thread",409688],["thread",409686],["thread",409680],["thread",409674],["thread",409673],["thread",409672],["thread",409671],["thread",409670],["thread",409665],["thread",409663],["thread",409661],["thread",409659],["thread",409656],["thread",409654],["thread",409653],["thread",409650],["thread",409484],["thread",409483],["thread",409481],["thread",409480],["thread",409479],["thread",409478],["thread",409477],["thread",409476],["thread",409475],["thread",409474],["thread",409473],["thread",409471],["thread",409470],["thread",409469],["thread",409468],["thread",409467],["thread",409466],["thread",409464],["thread",409463],["thread",409462],["thread",409461],["thread",409460],["thread",409459],["thread",409458],["thread",409457],["thread",409456],["thread",409455],["thread",409454],["thread",409452],["thread",409451],["thread",409450],["thread",409449],["thread",409448]]
Run Time: 0.001069