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 (329071, 329070, 329069, 329068, 329067, 329066, 329065, 329064, 329063, 329062, 329061, 329060, 329059, 329058, 329057, 329056, 329055, 329054, 329053, 329052, 329050, 329049, 329048, 329047, 329046, 329045, 329044, 329043, 329042, 329039, 329038, 329037, 329036, 329035, 329034, 329033, 329030, 329029, 329028, 329027, 329026, 329025, 329024, 329023, 329021, 329019, 329018, 329017, 329016, 329015, 329014, 329012, 329011, 329009, 329008, 329007, 329006, 329005, 329004, 329003, 329002, 329001, 329000, 328999, 328998, 328997, 328996, 328995, 328994, 328993, 328992, 328991, 328990, 328989, 328988, 328987, 328986, 328985, 328984, 328982, 328983, 328980, 328979, 328978, 328977, 328976, 328975, 328974, 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)
Run Time: 0.002785
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",329071],["thread",329070],["thread",329069],["thread",329068],["thread",329067],["thread",329066],["thread",329065],["thread",329064],["thread",329063],["thread",329062],["thread",329061],["thread",329060],["thread",329059],["thread",329058],["thread",329057],["thread",329056],["thread",329055],["thread",329054],["thread",329053],["thread",329052],["thread",329050],["thread",329049],["thread",329048],["thread",329047],["thread",329046],["thread",329045],["thread",329044],["thread",329043],["thread",329042],["thread",329039],["thread",329038],["thread",329037],["thread",329036],["thread",329035],["thread",329034],["thread",329033],["thread",329030],["thread",329029],["thread",329028],["thread",329027],["thread",329026],["thread",329025],["thread",329024],["thread",329023],["thread",329021],["thread",329019],["thread",329018],["thread",329017],["thread",329016],["thread",329015],["thread",329014],["thread",329012],["thread",329011],["thread",329009],["thread",329008],["thread",329007],["thread",329006],["thread",329005],["thread",329004],["thread",329003],["thread",329002],["thread",329001],["thread",329000],["thread",328999],["thread",328998],["thread",328997],["thread",328996],["thread",328995],["thread",328994],["thread",328993],["thread",328992],["thread",328991],["thread",328990],["thread",328989],["thread",328988],["thread",328987],["thread",328986],["thread",328985],["thread",328984],["thread",328982],["thread",328983],["thread",328980],["thread",328979],["thread",328978],["thread",328977],["thread",328976],["thread",328975],["thread",328974],["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]], 200, recent-posts, , [], date, 0, , [], 0, 1714698098, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000187