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 (25210, 25209, 25041, 25045, 25211, 25099, 25208, 109, 25215, 25214, 25046, 25047, 25036, 25038, 25048, 25042, 25212, 25213, 25030, 25029, 25035, 25034, 25043, 25037, 25044, 25049, 25059, 25177, 1967, 24448, 25061, 25060, 25202, 25203, 25204, 25205, 25207, 25206, 25198, 25197, 25196, 25199, 25201, 25200, 25191, 25190, 25192, 25193, 25195, 25194, 25188, 25187, 25189, 25186, 25179, 25178, 25180, 25183, 25185, 25182, 25184, 25181, 25174, 25176, 25173, 25175, 25172, 25171, 25134, 25166, 25167, 25165, 25168, 25170, 25169, 25161, 25159, 25160, 25162, 25164, 25163, 20209, 25155, 25154, 25158, 25157, 25153, 25156, 25148, 25147, 25150, 25149, 25152, 25151, 25143, 25144, 25141, 25142, 25146, 25145, 25137, 25135, 25136, 25138, 25139, 25140, 25133, 25131, 25132, 25130, 25092, 25123, 25124, 25129, 25128, 25125, 25122, 25126, 25127, 25116, 25117, 25120, 25121, 25119, 25118, 25112, 25115, 25114, 25113, 25109, 25110, 25108, 25111, 25107, 25106, 25100, 25101, 25103, 25102, 25105, 25104, 25093, 25094, 25095, 25096, 25098, 25097, 25087, 25089, 25031, 25088, 25086, 25091, 25090, 25081, 25082, 25080, 25083, 25085, 25084, 25079, 25077, 25078, 25076, 25075, 25074, 25072, 25071, 25070, 25073, 25069, 25068, 25063, 25062, 25064, 25065, 25066, 25067, 25052, 25058, 25057, 25056, 25055, 25054, 25053, 25039, 25040, 25032, 25033, 25051, 25050, 20322, 24854, 24853, 24852, 25023, 25024, 24823, 25025, 25026)
Run Time: 0.010177
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 | ccxsccxs_dd.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | ccxsccxs_dd.thread.node_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,ccxsccxs_dd.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",25210],["thread",25209],["thread",25041],["thread",25045],["thread",25211],["thread",25099],["thread",25208],["thread",109],["thread",25215],["thread",25214],["thread",25046],["thread",25047],["thread",25036],["thread",25038],["thread",25048],["thread",25042],["thread",25212],["thread",25213],["thread",25030],["thread",25029],["thread",25035],["thread",25034],["thread",25043],["thread",25037],["thread",25044],["thread",25049],["thread",25059],["thread",25177],["thread",1967],["thread",24448],["thread",25061],["thread",25060],["thread",25202],["thread",25203],["thread",25204],["thread",25205],["thread",25207],["thread",25206],["thread",25198],["thread",25197],["thread",25196],["thread",25199],["thread",25201],["thread",25200],["thread",25191],["thread",25190],["thread",25192],["thread",25193],["thread",25195],["thread",25194],["thread",25188],["thread",25187],["thread",25189],["thread",25186],["thread",25179],["thread",25178],["thread",25180],["thread",25183],["thread",25185],["thread",25182],["thread",25184],["thread",25181],["thread",25174],["thread",25176],["thread",25173],["thread",25175],["thread",25172],["thread",25171],["thread",25134],["thread",25166],["thread",25167],["thread",25165],["thread",25168],["thread",25170],["thread",25169],["thread",25161],["thread",25159],["thread",25160],["thread",25162],["thread",25164],["thread",25163],["thread",20209],["thread",25155],["thread",25154],["thread",25158],["thread",25157],["thread",25153],["thread",25156],["thread",25148],["thread",25147],["thread",25150],["thread",25149],["thread",25152],["thread",25151],["thread",25143],["thread",25144],["thread",25141],["thread",25142],["thread",25146],["thread",25145],["thread",25137],["thread",25135],["thread",25136],["thread",25138],["thread",25139],["thread",25140],["thread",25133],["thread",25131],["thread",25132],["thread",25130],["thread",25092],["thread",25123],["thread",25124],["thread",25129],["thread",25128],["thread",25125],["thread",25122],["thread",25126],["thread",25127],["thread",25116],["thread",25117],["thread",25120],["thread",25121],["thread",25119],["thread",25118],["thread",25112],["thread",25115],["thread",25114],["thread",25113],["thread",25109],["thread",25110],["thread",25108],["thread",25111],["thread",25107],["thread",25106],["thread",25100],["thread",25101],["thread",25103],["thread",25102],["thread",25105],["thread",25104],["thread",25093],["thread",25094],["thread",25095],["thread",25096],["thread",25098],["thread",25097],["thread",25087],["thread",25089],["thread",25031],["thread",25088],["thread",25086],["thread",25091],["thread",25090],["thread",25081],["thread",25082],["thread",25080],["thread",25083],["thread",25085],["thread",25084],["thread",25079],["thread",25077],["thread",25078],["thread",25076],["thread",25075],["thread",25074],["thread",25072],["thread",25071],["thread",25070],["thread",25073],["thread",25069],["thread",25068],["thread",25063],["thread",25062],["thread",25064],["thread",25065],["thread",25066],["thread",25067],["thread",25052],["thread",25058],["thread",25057],["thread",25056],["thread",25055],["thread",25054],["thread",25053],["thread",25039],["thread",25040],["thread",25032],["thread",25033],["thread",25051],["thread",25050],["thread",20322],["thread",24854],["thread",24853],["thread",24852],["thread",25023],["thread",25024],["thread",24823],["thread",25025],["thread",25026]], 200, recent-posts, , [], date, 0, , [], 0, 1714211241, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000979