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 (23066, 23063, 23062, 23061, 23060, 23059, 23058, 23043, 23041, 23039, 23037, 23035, 23034, 23028, 23027, 23026, 23024, 23020, 23019, 23017, 23016, 23015, 22988, 22987, 22933, 22932, 22931, 22930, 22929, 22928, 22927, 22926, 22924, 22915, 22913, 22909, 22895, 22894, 22893, 22892, 22891, 22890, 22889, 22888, 22887, 22886, 22885, 22884, 22883, 22880, 22879, 22878, 22877, 22876, 22875, 22874, 22873, 22872, 22871, 22870, 22869, 22867, 22866, 22865, 22864, 22863, 22290, 22289, 22288, 22287, 22286, 22279, 22277, 22273, 22272, 22271, 22270, 22268, 22263, 22262, 22261, 22260, 21206, 21205, 21204, 21203, 21202, 21201, 21200, 21199, 21198, 21197, 21196, 21195, 21194, 21193, 21192, 21191, 21190, 21189, 21188, 21187, 21186, 21185, 21184, 21183, 21182, 21181, 21180, 21179, 21178, 20992, 20991, 20990, 20989, 20988, 20987, 20968, 20967, 20954, 20950, 20944, 20943, 20942, 20941, 20940, 20939, 20919, 20918, 20917, 20916, 20915, 20914, 20913, 20912, 20911, 20910, 20905, 20904, 20903, 20902, 20890, 20879, 20878, 20877, 20876, 20874, 20873, 20872, 20871, 20870, 20869, 20861, 20824, 20823, 20822, 20821, 20820, 20819, 20818, 20817, 20816, 20804, 20803, 20802, 20796, 20795, 20794, 20793, 20792, 20791, 20790, 20784, 20783, 20782, 20781, 20780, 20779, 20778, 20777, 20776, 20775, 20774, 20763, 20733, 20732, 20731, 20730, 20729, 20728, 20726, 20724, 20715, 20714, 20713, 20705, 20697, 20695, 20686, 20676)
Run Time: 0.051665
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: 2009, 0, 1714820926, 1714824526, [["thread",23066],["thread",23063],["thread",23062],["thread",23061],["thread",23060],["thread",23059],["thread",23058],["thread",23043],["thread",23041],["thread",23039],["thread",23037],["thread",23035],["thread",23034],["thread",23028],["thread",23027],["thread",23026],["thread",23024],["thread",23020],["thread",23019],["thread",23017],["thread",23016],["thread",23015],["thread",22988],["thread",22987],["thread",22933],["thread",22932],["thread",22931],["thread",22930],["thread",22929],["thread",22928],["thread",22927],["thread",22926],["thread",22924],["thread",22915],["thread",22913],["thread",22909],["thread",22895],["thread",22894],["thread",22893],["thread",22892],["thread",22891],["thread",22890],["thread",22889],["thread",22888],["thread",22887],["thread",22886],["thread",22885],["thread",22884],["thread",22883],["thread",22880],["thread",22879],["thread",22878],["thread",22877],["thread",22876],["thread",22875],["thread",22874],["thread",22873],["thread",22872],["thread",22871],["thread",22870],["thread",22869],["thread",22867],["thread",22866],["thread",22865],["thread",22864],["thread",22863],["thread",22290],["thread",22289],["thread",22288],["thread",22287],["thread",22286],["thread",22279],["thread",22277],["thread",22273],["thread",22272],["thread",22271],["thread",22270],["thread",22268],["thread",22263],["thread",22262],["thread",22261],["thread",22260],["thread",21206],["thread",21205],["thread",21204],["thread",21203],["thread",21202],["thread",21201],["thread",21200],["thread",21199],["thread",21198],["thread",21197],["thread",21196],["thread",21195],["thread",21194],["thread",21193],["thread",21192],["thread",21191],["thread",21190],["thread",21189],["thread",21188],["thread",21187],["thread",21186],["thread",21185],["thread",21184],["thread",21183],["thread",21182],["thread",21181],["thread",21180],["thread",21179],["thread",21178],["thread",20992],["thread",20991],["thread",20990],["thread",20989],["thread",20988],["thread",20987],["thread",20968],["thread",20967],["thread",20954],["thread",20950],["thread",20944],["thread",20943],["thread",20942],["thread",20941],["thread",20940],["thread",20939],["thread",20919],["thread",20918],["thread",20917],["thread",20916],["thread",20915],["thread",20914],["thread",20913],["thread",20912],["thread",20911],["thread",20910],["thread",20905],["thread",20904],["thread",20903],["thread",20902],["thread",20890],["thread",20879],["thread",20878],["thread",20877],["thread",20876],["thread",20874],["thread",20873],["thread",20872],["thread",20871],["thread",20870],["thread",20869],["thread",20861],["thread",20824],["thread",20823],["thread",20822],["thread",20821],["thread",20820],["thread",20819],["thread",20818],["thread",20817],["thread",20816],["thread",20804],["thread",20803],["thread",20802],["thread",20796],["thread",20795],["thread",20794],["thread",20793],["thread",20792],["thread",20791],["thread",20790],["thread",20784],["thread",20783],["thread",20782],["thread",20781],["thread",20780],["thread",20779],["thread",20778],["thread",20777],["thread",20776],["thread",20775],["thread",20774],["thread",20763],["thread",20733],["thread",20732],["thread",20731],["thread",20730],["thread",20729],["thread",20728],["thread",20726],["thread",20724],["thread",20715],["thread",20714],["thread",20713],["thread",20705],["thread",20697],["thread",20695],["thread",20686],["thread",20676]]
Run Time: 0.002454