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 (91540, 2025938, 2021554, 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, 2021086, 2024341, 2024340, 2024339, 2021744, 2021750, 2021740, 2021741, 2021742, 2021743, 2021738, 2021739, 2021735, 2021416, 2021737, 2021418, 2021734, 2021730, 2021731, 2021732, 2021727, 2021728, 2021723, 2021724, 2021725, 2021726, 2021722, 2021717, 2021718, 2021719, 2021720, 2021721, 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, 2025843, 2025842, 2025841, 2025840, 2025839, 2025838, 2025837, 2025836, 2025835, 2025834, 2025833, 2025832, 2025831, 2025830, 2025829, 2025828, 2025827, 2025826, 2025825, 2025824, 2025823, 2025822, 2025821, 2025820, 2025819, 2025818, 2025817, 2025816, 2025815, 2025814, 2025813, 2025812, 2025811, 2025810, 2025809, 2025808, 2025807, 2025806, 2025805, 2025804, 2025803, 2025802, 2025801, 2025800, 2025799, 2025798, 2025797, 2017907, 2008696, 2025796, 2025795, 2008697, 2025794, 2025793, 2025792, 2025791, 2025790, 2025789, 2025788, 2025787, 2025786, 2025785, 2025784, 2025783, 2025782, 2025781, 2025780, 2025779, 2025778, 2025777, 2025776)
Run Time: 0.005278
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",91540],["thread",2025938],["thread",2021554],["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",2021086],["thread",2024341],["thread",2024340],["thread",2024339],["thread",2021744],["thread",2021750],["thread",2021740],["thread",2021741],["thread",2021742],["thread",2021743],["thread",2021738],["thread",2021739],["thread",2021735],["thread",2021416],["thread",2021737],["thread",2021418],["thread",2021734],["thread",2021730],["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",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],["thread",2025843],["thread",2025842],["thread",2025841],["thread",2025840],["thread",2025839],["thread",2025838],["thread",2025837],["thread",2025836],["thread",2025835],["thread",2025834],["thread",2025833],["thread",2025832],["thread",2025831],["thread",2025830],["thread",2025829],["thread",2025828],["thread",2025827],["thread",2025826],["thread",2025825],["thread",2025824],["thread",2025823],["thread",2025822],["thread",2025821],["thread",2025820],["thread",2025819],["thread",2025818],["thread",2025817],["thread",2025816],["thread",2025815],["thread",2025814],["thread",2025813],["thread",2025812],["thread",2025811],["thread",2025810],["thread",2025809],["thread",2025808],["thread",2025807],["thread",2025806],["thread",2025805],["thread",2025804],["thread",2025803],["thread",2025802],["thread",2025801],["thread",2025800],["thread",2025799],["thread",2025798],["thread",2025797],["thread",2017907],["thread",2008696],["thread",2025796],["thread",2025795],["thread",2008697],["thread",2025794],["thread",2025793],["thread",2025792],["thread",2025791],["thread",2025790],["thread",2025789],["thread",2025788],["thread",2025787],["thread",2025786],["thread",2025785],["thread",2025784],["thread",2025783],["thread",2025782],["thread",2025781],["thread",2025780],["thread",2025779],["thread",2025778],["thread",2025777],["thread",2025776]], 200, recent-posts, , [], date, 0, , [], 0, 1713543784, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.003847