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 (15220, 15219, 15218, 15212, 15211, 15210, 15209, 15201, 15197, 15196, 15195, 15194, 15190, 15187, 15186, 15185, 15184, 15183, 15182, 15181, 15180, 15179, 15177, 15176, 15175, 15174, 15173, 15172, 15171, 15170, 15168, 15165, 15161, 15160, 15159, 15158, 15157, 15156, 15155, 15154, 15153, 15152, 15151, 15150, 15149, 15145, 15141, 15140, 15138, 15135, 15130, 15129, 15126, 15120, 15119, 15117, 15062, 15061, 15060, 15058, 15056, 15055, 15054, 15053, 15052, 15051, 15050, 15049, 15046, 15045, 15044, 15043, 15042, 15041, 15040, 15039, 15038, 15037, 15036, 15035, 15034, 15033, 15032, 15031, 15030, 15029, 15028, 15027, 15026, 15025, 15024, 15023, 15022, 15021, 15020, 15019, 15018, 15017, 15016, 15015, 15014, 15013, 15012, 15011, 15010, 15009, 15008, 15007, 15006, 15005, 15004, 15002, 15001, 15000, 14999, 14998, 14997, 14996, 14995, 14994, 14993, 14992, 14991, 14990, 14989, 14988, 14987, 14986, 14985, 14984, 14983, 14982, 14981, 14980, 14979, 14978, 14977, 14976, 14975, 14974, 14973, 14972, 14971, 14970, 14969, 14968, 14967, 14966, 14965, 14964, 14963, 14962, 14961, 14960, 14959, 14958, 14957, 14956, 14955, 14954, 14953, 14952, 14951, 14949, 14948, 14947, 14942, 14941, 14940, 14939, 14938, 14937, 14936, 14935, 14934, 14933, 14932, 14931, 14930, 14929, 14928, 14927, 14926, 14924, 14923, 14922, 14921, 14920, 14919, 14918, 14917, 14914, 14913, 14912, 14911, 14910, 14909, 14908, 14907, 14906)
Run Time: 0.047084
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: 1724, 0, 1714841540, 1714845140, [["thread",15220],["thread",15219],["thread",15218],["thread",15212],["thread",15211],["thread",15210],["thread",15209],["thread",15201],["thread",15197],["thread",15196],["thread",15195],["thread",15194],["thread",15190],["thread",15187],["thread",15186],["thread",15185],["thread",15184],["thread",15183],["thread",15182],["thread",15181],["thread",15180],["thread",15179],["thread",15177],["thread",15176],["thread",15175],["thread",15174],["thread",15173],["thread",15172],["thread",15171],["thread",15170],["thread",15168],["thread",15165],["thread",15161],["thread",15160],["thread",15159],["thread",15158],["thread",15157],["thread",15156],["thread",15155],["thread",15154],["thread",15153],["thread",15152],["thread",15151],["thread",15150],["thread",15149],["thread",15145],["thread",15141],["thread",15140],["thread",15138],["thread",15135],["thread",15130],["thread",15129],["thread",15126],["thread",15120],["thread",15119],["thread",15117],["thread",15062],["thread",15061],["thread",15060],["thread",15058],["thread",15056],["thread",15055],["thread",15054],["thread",15053],["thread",15052],["thread",15051],["thread",15050],["thread",15049],["thread",15046],["thread",15045],["thread",15044],["thread",15043],["thread",15042],["thread",15041],["thread",15040],["thread",15039],["thread",15038],["thread",15037],["thread",15036],["thread",15035],["thread",15034],["thread",15033],["thread",15032],["thread",15031],["thread",15030],["thread",15029],["thread",15028],["thread",15027],["thread",15026],["thread",15025],["thread",15024],["thread",15023],["thread",15022],["thread",15021],["thread",15020],["thread",15019],["thread",15018],["thread",15017],["thread",15016],["thread",15015],["thread",15014],["thread",15013],["thread",15012],["thread",15011],["thread",15010],["thread",15009],["thread",15008],["thread",15007],["thread",15006],["thread",15005],["thread",15004],["thread",15002],["thread",15001],["thread",15000],["thread",14999],["thread",14998],["thread",14997],["thread",14996],["thread",14995],["thread",14994],["thread",14993],["thread",14992],["thread",14991],["thread",14990],["thread",14989],["thread",14988],["thread",14987],["thread",14986],["thread",14985],["thread",14984],["thread",14983],["thread",14982],["thread",14981],["thread",14980],["thread",14979],["thread",14978],["thread",14977],["thread",14976],["thread",14975],["thread",14974],["thread",14973],["thread",14972],["thread",14971],["thread",14970],["thread",14969],["thread",14968],["thread",14967],["thread",14966],["thread",14965],["thread",14964],["thread",14963],["thread",14962],["thread",14961],["thread",14960],["thread",14959],["thread",14958],["thread",14957],["thread",14956],["thread",14955],["thread",14954],["thread",14953],["thread",14952],["thread",14951],["thread",14949],["thread",14948],["thread",14947],["thread",14942],["thread",14941],["thread",14940],["thread",14939],["thread",14938],["thread",14937],["thread",14936],["thread",14935],["thread",14934],["thread",14933],["thread",14932],["thread",14931],["thread",14930],["thread",14929],["thread",14928],["thread",14927],["thread",14926],["thread",14924],["thread",14923],["thread",14922],["thread",14921],["thread",14920],["thread",14919],["thread",14918],["thread",14917],["thread",14914],["thread",14913],["thread",14912],["thread",14911],["thread",14910],["thread",14909],["thread",14908],["thread",14907],["thread",14906]]
Run Time: 0.003450