SELECT thread.*
,
user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
node.title AS node_title, node.node_name,
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_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 (2026009, 91540, 2021554, 2026008, 2026007, 2026006, 2026005, 2026004, 2026003, 2026002, 2026001, 2026000, 2025999, 2025998, 2025997, 2025996, 2025995, 2025994, 2025993, 2025992, 2025991, 2025990, 2025989, 2025988, 2025987, 2025986, 2025985, 2025984, 2025983, 2025982, 2025981, 2025980, 2025979, 2025978, 2025977, 2025976, 2025975, 2025974, 2025973, 2025972, 2025971, 2025970, 2025969, 2025968, 2021750, 2021744, 2024339, 2024340, 2024341, 2021086, 2021743, 2021741, 2021742, 2021740, 2021739, 2021738, 2021730, 2021416, 2021735, 2021734, 2025967, 2025966, 2025965, 2025964, 2025963, 2025962, 2025961, 2025960, 2025959, 2025958, 2025957, 2025956, 2025955, 2025954, 2025953, 2021737, 2021418, 2025952, 2021731, 2021732, 2021727, 2021728, 2021723, 2021724, 2021725, 2021726, 2021722, 2021717, 2021718, 2021719, 2021720, 2021721, 2025951, 2025950, 2025949, 2025948, 2025947, 2025946, 2025945, 2025944, 2025943, 2025942, 2025941, 2025940, 2025939, 2025938, 2025937, 2025936, 2025935, 2025934, 2025933, 2025932, 2025931, 2025930, 2025929, 2025928, 2025927, 2025926, 2025925, 2025924, 2025923, 2025922, 2025921, 2025920, 2025919, 2025918, 2025917, 2025916, 2025915, 2025914, 2025913, 2025912, 2025911, 2025910, 2025909, 2025908, 2025907, 2025906, 2025905, 2025904, 2025903, 2025902, 2025901, 2025900, 2025899, 2025898, 2025897, 2025896, 2025895, 2025894, 2025893, 2025892, 2025891, 2025890, 2025889, 2025888, 2025887, 2025886, 2025885, 2025884, 2025883, 2025882, 2025881, 2025880, 2025879, 2025878, 2025877, 2025876, 2025875, 2025874, 2025873, 2025872, 2025871, 2025870, 2025869, 2025868, 2025867, 2025866, 2025865, 2025864, 2025863, 2025862, 2025861, 2025860, 2025859, 2025858, 2025857, 2025856, 2025855, 2025854, 2025853, 2025852, 2025851, 2025850, 2025849, 2025848, 2025847, 2025846, 2025845, 2025844)
Run Time: 0.004688
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 | dirty.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | dirty.thread.node_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,dirty.thread.node_id | 1 | Using where |
INSERT INTO `xf_search` (`search_results`, `result_count`, `search_type`, `search_query`, `search_constraints`, `search_order`, `search_grouping`, `user_results`, `warnings`, `user_id`, `search_date`, `query_hash`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Params: [["thread",2026009],["thread",91540],["thread",2021554],["thread",2026008],["thread",2026007],["thread",2026006],["thread",2026005],["thread",2026004],["thread",2026003],["thread",2026002],["thread",2026001],["thread",2026000],["thread",2025999],["thread",2025998],["thread",2025997],["thread",2025996],["thread",2025995],["thread",2025994],["thread",2025993],["thread",2025992],["thread",2025991],["thread",2025990],["thread",2025989],["thread",2025988],["thread",2025987],["thread",2025986],["thread",2025985],["thread",2025984],["thread",2025983],["thread",2025982],["thread",2025981],["thread",2025980],["thread",2025979],["thread",2025978],["thread",2025977],["thread",2025976],["thread",2025975],["thread",2025974],["thread",2025973],["thread",2025972],["thread",2025971],["thread",2025970],["thread",2025969],["thread",2025968],["thread",2021750],["thread",2021744],["thread",2024339],["thread",2024340],["thread",2024341],["thread",2021086],["thread",2021743],["thread",2021741],["thread",2021742],["thread",2021740],["thread",2021739],["thread",2021738],["thread",2021730],["thread",2021416],["thread",2021735],["thread",2021734],["thread",2025967],["thread",2025966],["thread",2025965],["thread",2025964],["thread",2025963],["thread",2025962],["thread",2025961],["thread",2025960],["thread",2025959],["thread",2025958],["thread",2025957],["thread",2025956],["thread",2025955],["thread",2025954],["thread",2025953],["thread",2021737],["thread",2021418],["thread",2025952],["thread",2021731],["thread",2021732],["thread",2021727],["thread",2021728],["thread",2021723],["thread",2021724],["thread",2021725],["thread",2021726],["thread",2021722],["thread",2021717],["thread",2021718],["thread",2021719],["thread",2021720],["thread",2021721],["thread",2025951],["thread",2025950],["thread",2025949],["thread",2025948],["thread",2025947],["thread",2025946],["thread",2025945],["thread",2025944],["thread",2025943],["thread",2025942],["thread",2025941],["thread",2025940],["thread",2025939],["thread",2025938],["thread",2025937],["thread",2025936],["thread",2025935],["thread",2025934],["thread",2025933],["thread",2025932],["thread",2025931],["thread",2025930],["thread",2025929],["thread",2025928],["thread",2025927],["thread",2025926],["thread",2025925],["thread",2025924],["thread",2025923],["thread",2025922],["thread",2025921],["thread",2025920],["thread",2025919],["thread",2025918],["thread",2025917],["thread",2025916],["thread",2025915],["thread",2025914],["thread",2025913],["thread",2025912],["thread",2025911],["thread",2025910],["thread",2025909],["thread",2025908],["thread",2025907],["thread",2025906],["thread",2025905],["thread",2025904],["thread",2025903],["thread",2025902],["thread",2025901],["thread",2025900],["thread",2025899],["thread",2025898],["thread",2025897],["thread",2025896],["thread",2025895],["thread",2025894],["thread",2025893],["thread",2025892],["thread",2025891],["thread",2025890],["thread",2025889],["thread",2025888],["thread",2025887],["thread",2025886],["thread",2025885],["thread",2025884],["thread",2025883],["thread",2025882],["thread",2025881],["thread",2025880],["thread",2025879],["thread",2025878],["thread",2025877],["thread",2025876],["thread",2025875],["thread",2025874],["thread",2025873],["thread",2025872],["thread",2025871],["thread",2025870],["thread",2025869],["thread",2025868],["thread",2025867],["thread",2025866],["thread",2025865],["thread",2025864],["thread",2025863],["thread",2025862],["thread",2025861],["thread",2025860],["thread",2025859],["thread",2025858],["thread",2025857],["thread",2025856],["thread",2025855],["thread",2025854],["thread",2025853],["thread",2025852],["thread",2025851],["thread",2025850],["thread",2025849],["thread",2025848],["thread",2025847],["thread",2025846],["thread",2025845],["thread",2025844]], 200, recent-posts, , [], date, 0, , [], 0, 1713902432, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.003170