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 (329266, 329265, 329264, 329263, 329262, 329260, 329261, 329259, 329258, 329257, 329256, 329255, 329254, 329253, 329252, 329251, 329250, 329249, 329248, 329246, 329245, 329243, 329242, 329241, 329240, 329239, 329238, 329236, 329235, 329234, 329233, 329232, 329231, 329230, 329228, 329227, 329226, 329225, 329224, 329223, 329222, 329221, 329220, 329219, 329217, 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)
Run Time: 0.002752
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",329266],["thread",329265],["thread",329264],["thread",329263],["thread",329262],["thread",329260],["thread",329261],["thread",329259],["thread",329258],["thread",329257],["thread",329256],["thread",329255],["thread",329254],["thread",329253],["thread",329252],["thread",329251],["thread",329250],["thread",329249],["thread",329248],["thread",329246],["thread",329245],["thread",329243],["thread",329242],["thread",329241],["thread",329240],["thread",329239],["thread",329238],["thread",329236],["thread",329235],["thread",329234],["thread",329233],["thread",329232],["thread",329231],["thread",329230],["thread",329228],["thread",329227],["thread",329226],["thread",329225],["thread",329224],["thread",329223],["thread",329222],["thread",329221],["thread",329220],["thread",329219],["thread",329217],["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]], 200, recent-posts, , [], date, 0, , [], 0, 1714825451, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000193