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 (2396113, 2396112, 2396111, 2396110, 2396109, 2396108, 2396107, 2396106, 2396105, 2396104, 2396103, 2396102, 2396101, 2396100, 2396099, 2396098, 2396097, 2396096, 2396095, 2396094, 2396093, 2396092, 2396091, 2396090, 2396089, 2396088, 2396087, 2396086, 2396085, 2396084, 2396083, 2396082, 2396081, 2396080, 2396079, 2396078, 2396077, 2396076, 2396075, 2396074, 2396073, 2396072, 2396071, 2396070, 2396069, 2396068, 2396067, 2396066, 2396065, 2396064, 2396063, 2396062, 2396061, 2396060, 2396059, 2396058, 2396057, 2396056, 2396055, 2396054, 2396053, 2396052, 2396051, 2396050, 2396049, 2396048, 2396047, 2396046, 2396045, 2396044, 2396043, 2396042, 2396041, 2396040, 2396039, 2396038, 2396037, 2396036, 2396035, 2396034, 2396033, 2396032, 2396031, 2396030, 2396029, 2396028, 2396027, 2396026, 2396025, 2396024, 2396023, 2396022, 2396021, 2396020, 2396019, 2396018, 2396016, 2396017, 2396015, 2396014, 2396013, 2396012, 2396011, 2396010, 2396009, 2396008, 2396007, 2396006, 2396005, 2396004, 2396003, 2396002, 2396001, 2396000, 2395999, 2395998, 2395997, 2395996, 2395995, 2395994, 2395993, 2395992, 2395991, 2395990, 2395989, 2395988, 2395987, 2395986, 2395985, 2395984, 2395983, 2395982, 2395981, 2395980, 2395979, 2395978, 2395977, 2395976, 2395975, 2395974, 2395973, 2395972, 2395971, 2395970, 2395969, 2395968, 2395967, 2395966, 2395965, 2395964, 2395963, 2395962, 2395961, 2395960, 2395959, 2395958, 2395957, 2395956, 2395955, 2395954, 2395953, 2395952, 2395951, 2395950, 2395949, 2395948, 2395947, 2395946, 2395945, 2395944, 2395943, 2395942, 2395941, 2395940, 2395939, 2395938, 2395937, 2395936, 2395935, 2395934, 2395933, 2395932, 2395931, 2395930, 2395929, 2395928, 2395927, 2395926, 2395925, 2395924, 2395923, 2395922, 2395921, 2395920, 2395919, 2395918, 2395917, 2395916, 2395915, 2395914)
Run Time: 0.005893
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 | teenusernamesdb.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | teenusernamesdb.thread.node_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,teenusernamesdb.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",2396113],["thread",2396112],["thread",2396111],["thread",2396110],["thread",2396109],["thread",2396108],["thread",2396107],["thread",2396106],["thread",2396105],["thread",2396104],["thread",2396103],["thread",2396102],["thread",2396101],["thread",2396100],["thread",2396099],["thread",2396098],["thread",2396097],["thread",2396096],["thread",2396095],["thread",2396094],["thread",2396093],["thread",2396092],["thread",2396091],["thread",2396090],["thread",2396089],["thread",2396088],["thread",2396087],["thread",2396086],["thread",2396085],["thread",2396084],["thread",2396083],["thread",2396082],["thread",2396081],["thread",2396080],["thread",2396079],["thread",2396078],["thread",2396077],["thread",2396076],["thread",2396075],["thread",2396074],["thread",2396073],["thread",2396072],["thread",2396071],["thread",2396070],["thread",2396069],["thread",2396068],["thread",2396067],["thread",2396066],["thread",2396065],["thread",2396064],["thread",2396063],["thread",2396062],["thread",2396061],["thread",2396060],["thread",2396059],["thread",2396058],["thread",2396057],["thread",2396056],["thread",2396055],["thread",2396054],["thread",2396053],["thread",2396052],["thread",2396051],["thread",2396050],["thread",2396049],["thread",2396048],["thread",2396047],["thread",2396046],["thread",2396045],["thread",2396044],["thread",2396043],["thread",2396042],["thread",2396041],["thread",2396040],["thread",2396039],["thread",2396038],["thread",2396037],["thread",2396036],["thread",2396035],["thread",2396034],["thread",2396033],["thread",2396032],["thread",2396031],["thread",2396030],["thread",2396029],["thread",2396028],["thread",2396027],["thread",2396026],["thread",2396025],["thread",2396024],["thread",2396023],["thread",2396022],["thread",2396021],["thread",2396020],["thread",2396019],["thread",2396018],["thread",2396016],["thread",2396017],["thread",2396015],["thread",2396014],["thread",2396013],["thread",2396012],["thread",2396011],["thread",2396010],["thread",2396009],["thread",2396008],["thread",2396007],["thread",2396006],["thread",2396005],["thread",2396004],["thread",2396003],["thread",2396002],["thread",2396001],["thread",2396000],["thread",2395999],["thread",2395998],["thread",2395997],["thread",2395996],["thread",2395995],["thread",2395994],["thread",2395993],["thread",2395992],["thread",2395991],["thread",2395990],["thread",2395989],["thread",2395988],["thread",2395987],["thread",2395986],["thread",2395985],["thread",2395984],["thread",2395983],["thread",2395982],["thread",2395981],["thread",2395980],["thread",2395979],["thread",2395978],["thread",2395977],["thread",2395976],["thread",2395975],["thread",2395974],["thread",2395973],["thread",2395972],["thread",2395971],["thread",2395970],["thread",2395969],["thread",2395968],["thread",2395967],["thread",2395966],["thread",2395965],["thread",2395964],["thread",2395963],["thread",2395962],["thread",2395961],["thread",2395960],["thread",2395959],["thread",2395958],["thread",2395957],["thread",2395956],["thread",2395955],["thread",2395954],["thread",2395953],["thread",2395952],["thread",2395951],["thread",2395950],["thread",2395949],["thread",2395948],["thread",2395947],["thread",2395946],["thread",2395945],["thread",2395944],["thread",2395943],["thread",2395942],["thread",2395941],["thread",2395940],["thread",2395939],["thread",2395938],["thread",2395937],["thread",2395936],["thread",2395935],["thread",2395934],["thread",2395933],["thread",2395932],["thread",2395931],["thread",2395930],["thread",2395929],["thread",2395928],["thread",2395927],["thread",2395926],["thread",2395925],["thread",2395924],["thread",2395923],["thread",2395922],["thread",2395921],["thread",2395920],["thread",2395919],["thread",2395918],["thread",2395917],["thread",2395916],["thread",2395915],["thread",2395914]], 200, recent-posts, , [], date, 0, , [], 0, 1714146873, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.001700