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 (35026, 35025, 35024, 35023, 35022, 35021, 34978, 34977, 34976, 34975, 34974, 34960, 34959, 34957, 34956, 34954, 34953, 34951, 34950, 34949, 34948, 34947, 34946, 34945, 34944, 34943, 34939, 34933, 34932, 34931, 34930, 34929, 34928, 34927, 34926, 34925, 34924, 34923, 34922, 34921, 34920, 34919, 34918, 34917, 34916, 34915, 34914, 34913, 34912, 34911, 34910, 34909, 34908, 34907, 34906, 34905, 34904, 34903, 34902, 34901, 34900, 34882, 34872, 34871, 34867, 34866, 34865, 34864, 34863, 34862, 34861, 34860, 34859, 34858, 34857, 34856, 34855, 34844, 34843, 34842, 34841, 34840, 34839, 34838, 34837, 34836, 34835, 34834, 34833, 34832, 34831, 34830, 34829, 34828, 34827, 34826, 34825, 34824, 34823, 34822, 34821, 34793, 34751, 34750, 34749, 34748, 34747, 34746, 34745, 34744, 34743, 34736, 34735, 34734, 34733, 34732, 34731, 34730, 34729, 34728, 34726, 34725, 34724, 34723, 34721, 34720, 34719, 34718, 34715, 34714, 34713, 34712, 34700, 34699, 34698, 34692, 34690, 34673, 34672, 34655, 34654, 34620, 34619, 34618, 34616, 34615, 34614, 34613, 34612, 34611, 34609, 34608, 34607, 34606, 34605, 34604, 34603, 34602, 34601, 34598, 34597, 34595, 34594, 34593, 34592, 34591, 34590, 34589, 34588, 34587, 34569, 34568, 34567, 34566, 34565, 34564, 34561, 34560, 34559, 34558, 34557, 34556, 34079, 34078, 34077, 34076, 34075, 34074, 34073, 34072, 34071, 34070, 34033, 34032, 34031, 34030, 34029, 34014, 34007, 34006)
Run Time: 0.025638
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 | chanpro.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | chanpro.thread.node_id | 1 | |
SIMPLE | post | eq_ref | PRIMARY | PRIMARY | 4 | chanpro.thread.first_post_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,chanpro.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: 1719, 0, 1713526774, 1713530374, [["thread",35026],["thread",35025],["thread",35024],["thread",35023],["thread",35022],["thread",35021],["thread",34978],["thread",34977],["thread",34976],["thread",34975],["thread",34974],["thread",34960],["thread",34959],["thread",34957],["thread",34956],["thread",34954],["thread",34953],["thread",34951],["thread",34950],["thread",34949],["thread",34948],["thread",34947],["thread",34946],["thread",34945],["thread",34944],["thread",34943],["thread",34939],["thread",34933],["thread",34932],["thread",34931],["thread",34930],["thread",34929],["thread",34928],["thread",34927],["thread",34926],["thread",34925],["thread",34924],["thread",34923],["thread",34922],["thread",34921],["thread",34920],["thread",34919],["thread",34918],["thread",34917],["thread",34916],["thread",34915],["thread",34914],["thread",34913],["thread",34912],["thread",34911],["thread",34910],["thread",34909],["thread",34908],["thread",34907],["thread",34906],["thread",34905],["thread",34904],["thread",34903],["thread",34902],["thread",34901],["thread",34900],["thread",34882],["thread",34872],["thread",34871],["thread",34867],["thread",34866],["thread",34865],["thread",34864],["thread",34863],["thread",34862],["thread",34861],["thread",34860],["thread",34859],["thread",34858],["thread",34857],["thread",34856],["thread",34855],["thread",34844],["thread",34843],["thread",34842],["thread",34841],["thread",34840],["thread",34839],["thread",34838],["thread",34837],["thread",34836],["thread",34835],["thread",34834],["thread",34833],["thread",34832],["thread",34831],["thread",34830],["thread",34829],["thread",34828],["thread",34827],["thread",34826],["thread",34825],["thread",34824],["thread",34823],["thread",34822],["thread",34821],["thread",34793],["thread",34751],["thread",34750],["thread",34749],["thread",34748],["thread",34747],["thread",34746],["thread",34745],["thread",34744],["thread",34743],["thread",34736],["thread",34735],["thread",34734],["thread",34733],["thread",34732],["thread",34731],["thread",34730],["thread",34729],["thread",34728],["thread",34726],["thread",34725],["thread",34724],["thread",34723],["thread",34721],["thread",34720],["thread",34719],["thread",34718],["thread",34715],["thread",34714],["thread",34713],["thread",34712],["thread",34700],["thread",34699],["thread",34698],["thread",34692],["thread",34690],["thread",34673],["thread",34672],["thread",34655],["thread",34654],["thread",34620],["thread",34619],["thread",34618],["thread",34616],["thread",34615],["thread",34614],["thread",34613],["thread",34612],["thread",34611],["thread",34609],["thread",34608],["thread",34607],["thread",34606],["thread",34605],["thread",34604],["thread",34603],["thread",34602],["thread",34601],["thread",34598],["thread",34597],["thread",34595],["thread",34594],["thread",34593],["thread",34592],["thread",34591],["thread",34590],["thread",34589],["thread",34588],["thread",34587],["thread",34569],["thread",34568],["thread",34567],["thread",34566],["thread",34565],["thread",34564],["thread",34561],["thread",34560],["thread",34559],["thread",34558],["thread",34557],["thread",34556],["thread",34079],["thread",34078],["thread",34077],["thread",34076],["thread",34075],["thread",34074],["thread",34073],["thread",34072],["thread",34071],["thread",34070],["thread",34033],["thread",34032],["thread",34031],["thread",34030],["thread",34029],["thread",34014],["thread",34007],["thread",34006]]
Run Time: 0.001600