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 (330233, 330232, 330231, 330230, 330229, 330228, 330227, 330226, 330225, 330224, 330223, 330222, 330221, 330220, 330219, 330218, 330217, 330215, 330214, 330213, 330212, 330211, 330210, 330209, 324864, 330206, 330205, 330202, 330201, 330200, 330199, 330198, 330197, 330196, 330195, 330194, 330193, 330192, 330191, 330190, 330188, 330187, 330186, 330185, 330184, 330183, 330182, 330180, 330179, 330178, 330177, 330176, 330175, 330174, 330173, 330171, 330170, 330168, 330167, 330166, 330165, 330163, 330162, 330161, 330158, 330156, 330155, 330154, 330153, 330152, 330151, 330150, 330149, 330148, 330146, 330144, 330143, 330142, 330141, 330139, 330138, 330137, 330136, 330135, 330134, 330133, 330132, 330131, 330130, 330129, 330127, 330126, 330125, 330123, 330122, 330121, 330120, 330119, 330118, 330117, 330116, 330115, 330114, 330113, 330112, 330111, 330110, 330109, 330108, 330107, 330106, 330105, 330104, 330103, 330102, 330101, 330100, 330099, 330098, 330097, 330095, 330094, 330093, 330092, 330091, 330090, 330089, 330085, 330084, 330083, 330082, 330081, 330080, 330079, 330078, 330077, 330075, 330074, 330073, 330071, 330070, 330069, 330068, 330067, 330066, 330065, 330064, 330063, 330062, 330061, 330060, 330059, 330058, 330057, 330056, 330055, 330053, 330052, 330051, 330050, 330049, 330048, 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)
Run Time: 0.002749
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",330233],["thread",330232],["thread",330231],["thread",330230],["thread",330229],["thread",330228],["thread",330227],["thread",330226],["thread",330225],["thread",330224],["thread",330223],["thread",330222],["thread",330221],["thread",330220],["thread",330219],["thread",330218],["thread",330217],["thread",330215],["thread",330214],["thread",330213],["thread",330212],["thread",330211],["thread",330210],["thread",330209],["thread",324864],["thread",330206],["thread",330205],["thread",330202],["thread",330201],["thread",330200],["thread",330199],["thread",330198],["thread",330197],["thread",330196],["thread",330195],["thread",330194],["thread",330193],["thread",330192],["thread",330191],["thread",330190],["thread",330188],["thread",330187],["thread",330186],["thread",330185],["thread",330184],["thread",330183],["thread",330182],["thread",330180],["thread",330179],["thread",330178],["thread",330177],["thread",330176],["thread",330175],["thread",330174],["thread",330173],["thread",330171],["thread",330170],["thread",330168],["thread",330167],["thread",330166],["thread",330165],["thread",330163],["thread",330162],["thread",330161],["thread",330158],["thread",330156],["thread",330155],["thread",330154],["thread",330153],["thread",330152],["thread",330151],["thread",330150],["thread",330149],["thread",330148],["thread",330146],["thread",330144],["thread",330143],["thread",330142],["thread",330141],["thread",330139],["thread",330138],["thread",330137],["thread",330136],["thread",330135],["thread",330134],["thread",330133],["thread",330132],["thread",330131],["thread",330130],["thread",330129],["thread",330127],["thread",330126],["thread",330125],["thread",330123],["thread",330122],["thread",330121],["thread",330120],["thread",330119],["thread",330118],["thread",330117],["thread",330116],["thread",330115],["thread",330114],["thread",330113],["thread",330112],["thread",330111],["thread",330110],["thread",330109],["thread",330108],["thread",330107],["thread",330106],["thread",330105],["thread",330104],["thread",330103],["thread",330102],["thread",330101],["thread",330100],["thread",330099],["thread",330098],["thread",330097],["thread",330095],["thread",330094],["thread",330093],["thread",330092],["thread",330091],["thread",330090],["thread",330089],["thread",330085],["thread",330084],["thread",330083],["thread",330082],["thread",330081],["thread",330080],["thread",330079],["thread",330078],["thread",330077],["thread",330075],["thread",330074],["thread",330073],["thread",330071],["thread",330070],["thread",330069],["thread",330068],["thread",330067],["thread",330066],["thread",330065],["thread",330064],["thread",330063],["thread",330062],["thread",330061],["thread",330060],["thread",330059],["thread",330058],["thread",330057],["thread",330056],["thread",330055],["thread",330053],["thread",330052],["thread",330051],["thread",330050],["thread",330049],["thread",330048],["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]], 200, recent-posts, , [], date, 0, , [], 0, 1715728782, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000234