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 (329216, 329215, 329214, 329213, 329212, 329211, 329210, 329209, 329208, 329207, 329206, 329205, 329204, 329202, 329201, 329200, 329199, 329198, 329197, 329196, 329195, 329194, 329193, 329192, 329191, 329190, 329189, 329188, 329187, 329186, 329185, 329184, 329183, 329182, 329181, 329180, 329179, 329177, 329176, 329175, 329174, 329172, 329171, 329170, 329169, 329168, 329167, 329165, 329164, 329163, 329162, 329161, 329160, 329159, 329158, 329157, 329155, 329154, 329153, 329152, 329151, 324864, 329150, 329149, 329148, 329147, 329146, 329145, 329144, 329143, 329142, 329141, 329140, 329139, 329138, 329137, 329136, 329135, 329134, 329133, 329132, 329131, 329130, 329129, 329128, 329127, 329126, 329125, 329124, 329123, 329122, 329121, 329120, 329119, 329117, 329116, 329115, 329114, 329113, 329112, 329111, 329110, 329109, 329108, 329107, 329106, 329105, 329104, 329103, 329102, 329101, 329100, 329099, 329098, 329097, 329096, 329095, 329094, 329093, 329092, 329091, 329090, 329088, 329087, 329086, 329085, 329083, 329082, 329081, 329080, 329079, 329078, 329077, 329076, 329075, 329074, 329073, 329072, 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)
Run Time: 0.004450
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",329216],["thread",329215],["thread",329214],["thread",329213],["thread",329212],["thread",329211],["thread",329210],["thread",329209],["thread",329208],["thread",329207],["thread",329206],["thread",329205],["thread",329204],["thread",329202],["thread",329201],["thread",329200],["thread",329199],["thread",329198],["thread",329197],["thread",329196],["thread",329195],["thread",329194],["thread",329193],["thread",329192],["thread",329191],["thread",329190],["thread",329189],["thread",329188],["thread",329187],["thread",329186],["thread",329185],["thread",329184],["thread",329183],["thread",329182],["thread",329181],["thread",329180],["thread",329179],["thread",329177],["thread",329176],["thread",329175],["thread",329174],["thread",329172],["thread",329171],["thread",329170],["thread",329169],["thread",329168],["thread",329167],["thread",329165],["thread",329164],["thread",329163],["thread",329162],["thread",329161],["thread",329160],["thread",329159],["thread",329158],["thread",329157],["thread",329155],["thread",329154],["thread",329153],["thread",329152],["thread",329151],["thread",324864],["thread",329150],["thread",329149],["thread",329148],["thread",329147],["thread",329146],["thread",329145],["thread",329144],["thread",329143],["thread",329142],["thread",329141],["thread",329140],["thread",329139],["thread",329138],["thread",329137],["thread",329136],["thread",329135],["thread",329134],["thread",329133],["thread",329132],["thread",329131],["thread",329130],["thread",329129],["thread",329128],["thread",329127],["thread",329126],["thread",329125],["thread",329124],["thread",329123],["thread",329122],["thread",329121],["thread",329120],["thread",329119],["thread",329117],["thread",329116],["thread",329115],["thread",329114],["thread",329113],["thread",329112],["thread",329111],["thread",329110],["thread",329109],["thread",329108],["thread",329107],["thread",329106],["thread",329105],["thread",329104],["thread",329103],["thread",329102],["thread",329101],["thread",329100],["thread",329099],["thread",329098],["thread",329097],["thread",329096],["thread",329095],["thread",329094],["thread",329093],["thread",329092],["thread",329091],["thread",329090],["thread",329088],["thread",329087],["thread",329086],["thread",329085],["thread",329083],["thread",329082],["thread",329081],["thread",329080],["thread",329079],["thread",329078],["thread",329077],["thread",329076],["thread",329075],["thread",329074],["thread",329073],["thread",329072],["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]], 200, recent-posts, , [], date, 0, , [], 0, 1714816108, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000213