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 (330047, 330046, 330045, 330044, 330043, 330042, 330041, 330040, 330039, 330038, 330037, 330036, 330035, 330034, 330033, 330032, 330031, 330030, 330029, 330028, 330027, 330026, 330025, 330024, 330023, 330022, 330021, 330020, 330019, 330018, 330017, 330016, 330015, 330013, 330012, 330011, 330010, 330009, 330008, 330007, 330006, 330005, 330004, 330003, 330002, 330001, 330000, 329999, 329998, 329997, 329996, 329995, 329994, 329993, 329992, 329991, 329990, 329989, 329988, 329987, 329986, 329985, 329984, 329983, 329982, 329981, 329980, 329979, 329978, 329977, 329976, 329975, 329974, 329973, 329972, 329971, 329970, 329968, 329967, 329966, 329964, 329963, 329962, 329961, 329960, 329958, 329956, 329955, 329954, 329953, 329952, 329951, 329950, 329949, 329948, 329947, 329946, 329945, 329944, 329943, 329942, 329941, 329940, 329939, 329937, 329936, 329935, 329933, 329932, 329931, 329929, 329927, 329926, 329925, 329924, 329923, 329922, 329921, 329920, 329919, 329918, 329917, 329916, 329915, 329914, 329913, 329912, 329911, 329910, 329909, 329908, 329907, 329906, 329905, 329903, 329902, 329901, 329900, 329898, 329896, 329895, 329894, 329893, 329892, 329891, 329890, 329888, 329887, 329886, 329885, 329884, 329883, 329881, 329880, 329879, 329878, 329877, 329875, 329873, 329872, 329870, 329868, 329866, 329865, 329864, 329863, 329862, 329861, 329860, 329859, 329858, 329856, 329855, 329854, 329853, 329852, 329851, 329850, 329849, 329848, 329847, 329846, 329845, 329844, 329843, 329842, 329841, 329840, 329839, 329838, 329837, 329835, 329834, 329833, 329831, 329830, 329829, 329828, 329827, 329826)
Run Time: 0.002887
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 | qbkdcom_new.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | qbkdcom_new.thread.node_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,qbkdcom_new.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",330047],["thread",330046],["thread",330045],["thread",330044],["thread",330043],["thread",330042],["thread",330041],["thread",330040],["thread",330039],["thread",330038],["thread",330037],["thread",330036],["thread",330035],["thread",330034],["thread",330033],["thread",330032],["thread",330031],["thread",330030],["thread",330029],["thread",330028],["thread",330027],["thread",330026],["thread",330025],["thread",330024],["thread",330023],["thread",330022],["thread",330021],["thread",330020],["thread",330019],["thread",330018],["thread",330017],["thread",330016],["thread",330015],["thread",330013],["thread",330012],["thread",330011],["thread",330010],["thread",330009],["thread",330008],["thread",330007],["thread",330006],["thread",330005],["thread",330004],["thread",330003],["thread",330002],["thread",330001],["thread",330000],["thread",329999],["thread",329998],["thread",329997],["thread",329996],["thread",329995],["thread",329994],["thread",329993],["thread",329992],["thread",329991],["thread",329990],["thread",329989],["thread",329988],["thread",329987],["thread",329986],["thread",329985],["thread",329984],["thread",329983],["thread",329982],["thread",329981],["thread",329980],["thread",329979],["thread",329978],["thread",329977],["thread",329976],["thread",329975],["thread",329974],["thread",329973],["thread",329972],["thread",329971],["thread",329970],["thread",329968],["thread",329967],["thread",329966],["thread",329964],["thread",329963],["thread",329962],["thread",329961],["thread",329960],["thread",329958],["thread",329956],["thread",329955],["thread",329954],["thread",329953],["thread",329952],["thread",329951],["thread",329950],["thread",329949],["thread",329948],["thread",329947],["thread",329946],["thread",329945],["thread",329944],["thread",329943],["thread",329942],["thread",329941],["thread",329940],["thread",329939],["thread",329937],["thread",329936],["thread",329935],["thread",329933],["thread",329932],["thread",329931],["thread",329929],["thread",329927],["thread",329926],["thread",329925],["thread",329924],["thread",329923],["thread",329922],["thread",329921],["thread",329920],["thread",329919],["thread",329918],["thread",329917],["thread",329916],["thread",329915],["thread",329914],["thread",329913],["thread",329912],["thread",329911],["thread",329910],["thread",329909],["thread",329908],["thread",329907],["thread",329906],["thread",329905],["thread",329903],["thread",329902],["thread",329901],["thread",329900],["thread",329898],["thread",329896],["thread",329895],["thread",329894],["thread",329893],["thread",329892],["thread",329891],["thread",329890],["thread",329888],["thread",329887],["thread",329886],["thread",329885],["thread",329884],["thread",329883],["thread",329881],["thread",329880],["thread",329879],["thread",329878],["thread",329877],["thread",329875],["thread",329873],["thread",329872],["thread",329870],["thread",329868],["thread",329866],["thread",329865],["thread",329864],["thread",329863],["thread",329862],["thread",329861],["thread",329860],["thread",329859],["thread",329858],["thread",329856],["thread",329855],["thread",329854],["thread",329853],["thread",329852],["thread",329851],["thread",329850],["thread",329849],["thread",329848],["thread",329847],["thread",329846],["thread",329845],["thread",329844],["thread",329843],["thread",329842],["thread",329841],["thread",329840],["thread",329839],["thread",329838],["thread",329837],["thread",329835],["thread",329834],["thread",329833],["thread",329831],["thread",329830],["thread",329829],["thread",329828],["thread",329827],["thread",329826]], 200, recent-posts, , [], date, 0, , [], 0, 1715647588, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000225