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 (328973, 328971, 328970, 328969, 328968, 328967, 328966, 328965, 328963, 328962, 328961, 328960, 328959, 328958, 328957, 328954, 328953, 328952, 328951, 328950, 328949, 328948, 328947, 328946, 328945, 328944, 328943, 328942, 328941, 328940, 328937, 328938, 328936, 328935, 328934, 328933, 328932, 328930, 328929, 328928, 328927, 328926, 328925, 328924, 328923, 328922, 328920, 328919, 328918, 328917, 328915, 328914, 328913, 328912, 328911, 328910, 328909, 328908, 328907, 328906, 328905, 328903, 328902, 328901, 328900, 328899, 328898, 328897, 328896, 328895, 328894, 328893, 328892, 328891, 328890, 328888, 328887, 328885, 328884, 328883, 328882, 328881, 328880, 328879, 328878, 328876, 328875, 328874, 328873, 328872, 328871, 328870, 328869, 328868, 328867, 328866, 328863, 328862, 328861, 328860, 328859, 328858, 328857, 328856, 328855, 328854, 328853, 328852, 328851, 328850, 328849, 328848, 328847, 328846, 328845, 328844, 328843, 328842, 328841, 328840, 328839, 328838, 328837, 328836, 328834, 328833, 328832, 328830, 328829, 328828, 328827, 328826, 328825, 328824, 328822, 328821, 328820, 328819, 328818, 328816, 328817, 328815, 328814, 328813, 328812, 328811, 328810, 328809, 328808, 328807, 328804, 328803, 328802, 328801, 328800, 328799, 328797, 328794, 328789, 328787, 328786, 328785, 328784, 328783, 328782, 328781, 328780, 328779, 328778, 328777, 328776, 328775, 328774, 328773, 328772, 328771, 328767, 328766, 328765, 328764, 328763, 328761, 328760, 328759, 328758, 328757, 328755, 328754, 328753, 328752, 328751, 328750, 328749, 328748, 328747, 328746, 328745, 328744, 328743, 328742)
Run Time: 0.002697
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",328973],["thread",328971],["thread",328970],["thread",328969],["thread",328968],["thread",328967],["thread",328966],["thread",328965],["thread",328963],["thread",328962],["thread",328961],["thread",328960],["thread",328959],["thread",328958],["thread",328957],["thread",328954],["thread",328953],["thread",328952],["thread",328951],["thread",328950],["thread",328949],["thread",328948],["thread",328947],["thread",328946],["thread",328945],["thread",328944],["thread",328943],["thread",328942],["thread",328941],["thread",328940],["thread",328937],["thread",328938],["thread",328936],["thread",328935],["thread",328934],["thread",328933],["thread",328932],["thread",328930],["thread",328929],["thread",328928],["thread",328927],["thread",328926],["thread",328925],["thread",328924],["thread",328923],["thread",328922],["thread",328920],["thread",328919],["thread",328918],["thread",328917],["thread",328915],["thread",328914],["thread",328913],["thread",328912],["thread",328911],["thread",328910],["thread",328909],["thread",328908],["thread",328907],["thread",328906],["thread",328905],["thread",328903],["thread",328902],["thread",328901],["thread",328900],["thread",328899],["thread",328898],["thread",328897],["thread",328896],["thread",328895],["thread",328894],["thread",328893],["thread",328892],["thread",328891],["thread",328890],["thread",328888],["thread",328887],["thread",328885],["thread",328884],["thread",328883],["thread",328882],["thread",328881],["thread",328880],["thread",328879],["thread",328878],["thread",328876],["thread",328875],["thread",328874],["thread",328873],["thread",328872],["thread",328871],["thread",328870],["thread",328869],["thread",328868],["thread",328867],["thread",328866],["thread",328863],["thread",328862],["thread",328861],["thread",328860],["thread",328859],["thread",328858],["thread",328857],["thread",328856],["thread",328855],["thread",328854],["thread",328853],["thread",328852],["thread",328851],["thread",328850],["thread",328849],["thread",328848],["thread",328847],["thread",328846],["thread",328845],["thread",328844],["thread",328843],["thread",328842],["thread",328841],["thread",328840],["thread",328839],["thread",328838],["thread",328837],["thread",328836],["thread",328834],["thread",328833],["thread",328832],["thread",328830],["thread",328829],["thread",328828],["thread",328827],["thread",328826],["thread",328825],["thread",328824],["thread",328822],["thread",328821],["thread",328820],["thread",328819],["thread",328818],["thread",328816],["thread",328817],["thread",328815],["thread",328814],["thread",328813],["thread",328812],["thread",328811],["thread",328810],["thread",328809],["thread",328808],["thread",328807],["thread",328804],["thread",328803],["thread",328802],["thread",328801],["thread",328800],["thread",328799],["thread",328797],["thread",328794],["thread",328789],["thread",328787],["thread",328786],["thread",328785],["thread",328784],["thread",328783],["thread",328782],["thread",328781],["thread",328780],["thread",328779],["thread",328778],["thread",328777],["thread",328776],["thread",328775],["thread",328774],["thread",328773],["thread",328772],["thread",328771],["thread",328767],["thread",328766],["thread",328765],["thread",328764],["thread",328763],["thread",328761],["thread",328760],["thread",328759],["thread",328758],["thread",328757],["thread",328755],["thread",328754],["thread",328753],["thread",328752],["thread",328751],["thread",328750],["thread",328749],["thread",328748],["thread",328747],["thread",328746],["thread",328745],["thread",328744],["thread",328743],["thread",328742]], 200, recent-posts, , [], date, 0, , [], 0, 1714644330, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000216