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 (2021554, 2021743, 2021738, 2021734, 2021744, 2021739, 2021741, 2021742, 2021740, 2021735, 2021730, 2021728, 2021418, 2021737, 2026166, 2026165, 91540, 2008697, 2026164, 2026163, 2026162, 2026161, 2026160, 2026159, 2026158, 2026157, 866760, 1946804, 2026156, 2026155, 2026154, 2026153, 2026152, 2026151, 2026150, 2026149, 2026148, 2026147, 2026146, 2026145, 2026144, 2026143, 2026142, 2026141, 2026140, 2021416, 2021731, 2021732, 2021727, 2024340, 2021086, 2021750, 2024341, 2024339, 2021724, 2021726, 2021723, 2021725, 2021722, 2021717, 2021718, 2021719, 2021720, 2021721, 2026139, 2026138, 2026137, 2026136, 2026135, 2026134, 2026133, 2026132, 2026131, 2026130, 2026129, 2026128, 2026127, 2026126, 2026125, 2026124, 2026123, 2026122, 2026121, 2026120, 2026119, 2026118, 2026117, 2026116, 2026115, 2026114, 2026113, 2026112, 2026111, 2026110, 2026109, 2026108, 2026107, 2026106, 2026105, 2026104, 2026103, 2026102, 2026101, 2026100, 2026099, 2026098, 2026097, 2026096, 2026095, 2026094, 2026093, 2026092, 2026091, 2026090, 2026089, 2026088, 2026087, 2026086, 2026085, 2026084, 2026083, 2026082, 2026081, 2026080, 2026079, 2026078, 2026077, 2026076, 2026075, 2026074, 2026073, 2026072, 2026071, 2026070, 2026069, 2026068, 2026067, 2026066, 2026065, 2026064, 2026063, 2026062, 2026061, 2026060, 2026059, 2026058, 2026057, 2026056, 2026055, 2026054, 2026053, 2026052, 2026051, 2026050, 2026049, 2026048, 2026047, 2026046, 2026045, 2026044, 2026043, 2026042, 2026041, 2026040, 2026039, 2026038, 2026037, 2026036, 2026035, 2026034, 2026033, 2026032, 2026031, 2026030, 2026029, 2026028, 2026027, 2026026, 2026025, 2026024, 2026023, 2026022, 2026021, 2026020, 2026019, 2026018, 2026017, 2026016, 2026015, 2026014, 2026013, 2026012, 2026011, 2026010, 2026009, 2026008, 2026007, 2026006, 2026005, 2026004)
Run Time: 0.003954
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 | dirty.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | dirty.thread.node_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,dirty.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",2021554],["thread",2021743],["thread",2021738],["thread",2021734],["thread",2021744],["thread",2021739],["thread",2021741],["thread",2021742],["thread",2021740],["thread",2021735],["thread",2021730],["thread",2021728],["thread",2021418],["thread",2021737],["thread",2026166],["thread",2026165],["thread",91540],["thread",2008697],["thread",2026164],["thread",2026163],["thread",2026162],["thread",2026161],["thread",2026160],["thread",2026159],["thread",2026158],["thread",2026157],["thread",866760],["thread",1946804],["thread",2026156],["thread",2026155],["thread",2026154],["thread",2026153],["thread",2026152],["thread",2026151],["thread",2026150],["thread",2026149],["thread",2026148],["thread",2026147],["thread",2026146],["thread",2026145],["thread",2026144],["thread",2026143],["thread",2026142],["thread",2026141],["thread",2026140],["thread",2021416],["thread",2021731],["thread",2021732],["thread",2021727],["thread",2024340],["thread",2021086],["thread",2021750],["thread",2024341],["thread",2024339],["thread",2021724],["thread",2021726],["thread",2021723],["thread",2021725],["thread",2021722],["thread",2021717],["thread",2021718],["thread",2021719],["thread",2021720],["thread",2021721],["thread",2026139],["thread",2026138],["thread",2026137],["thread",2026136],["thread",2026135],["thread",2026134],["thread",2026133],["thread",2026132],["thread",2026131],["thread",2026130],["thread",2026129],["thread",2026128],["thread",2026127],["thread",2026126],["thread",2026125],["thread",2026124],["thread",2026123],["thread",2026122],["thread",2026121],["thread",2026120],["thread",2026119],["thread",2026118],["thread",2026117],["thread",2026116],["thread",2026115],["thread",2026114],["thread",2026113],["thread",2026112],["thread",2026111],["thread",2026110],["thread",2026109],["thread",2026108],["thread",2026107],["thread",2026106],["thread",2026105],["thread",2026104],["thread",2026103],["thread",2026102],["thread",2026101],["thread",2026100],["thread",2026099],["thread",2026098],["thread",2026097],["thread",2026096],["thread",2026095],["thread",2026094],["thread",2026093],["thread",2026092],["thread",2026091],["thread",2026090],["thread",2026089],["thread",2026088],["thread",2026087],["thread",2026086],["thread",2026085],["thread",2026084],["thread",2026083],["thread",2026082],["thread",2026081],["thread",2026080],["thread",2026079],["thread",2026078],["thread",2026077],["thread",2026076],["thread",2026075],["thread",2026074],["thread",2026073],["thread",2026072],["thread",2026071],["thread",2026070],["thread",2026069],["thread",2026068],["thread",2026067],["thread",2026066],["thread",2026065],["thread",2026064],["thread",2026063],["thread",2026062],["thread",2026061],["thread",2026060],["thread",2026059],["thread",2026058],["thread",2026057],["thread",2026056],["thread",2026055],["thread",2026054],["thread",2026053],["thread",2026052],["thread",2026051],["thread",2026050],["thread",2026049],["thread",2026048],["thread",2026047],["thread",2026046],["thread",2026045],["thread",2026044],["thread",2026043],["thread",2026042],["thread",2026041],["thread",2026040],["thread",2026039],["thread",2026038],["thread",2026037],["thread",2026036],["thread",2026035],["thread",2026034],["thread",2026033],["thread",2026032],["thread",2026031],["thread",2026030],["thread",2026029],["thread",2026028],["thread",2026027],["thread",2026026],["thread",2026025],["thread",2026024],["thread",2026023],["thread",2026022],["thread",2026021],["thread",2026020],["thread",2026019],["thread",2026018],["thread",2026017],["thread",2026016],["thread",2026015],["thread",2026014],["thread",2026013],["thread",2026012],["thread",2026011],["thread",2026010],["thread",2026009],["thread",2026008],["thread",2026007],["thread",2026006],["thread",2026005],["thread",2026004]], 200, recent-posts, , [], date, 0, , [], 0, 1715128138, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.002919