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 (2395374, 2395373, 2395372, 2395371, 2395370, 2395369, 2395368, 2395367, 2395366, 2395365, 2395364, 2395363, 2395362, 2395361, 2395360, 2395359, 2395358, 2395357, 2395356, 2395355, 2395354, 2395353, 2395352, 2395351, 2395350, 2395349, 2395348, 2395347, 2395346, 2395345, 2395344, 2395343, 2395342, 2395341, 2395340, 2395339, 2395338, 2395337, 2395336, 2395335, 2395334, 2395333, 2395332, 2395331, 2395330, 2395329, 2395328, 2395327, 2395326, 2395325, 2395324, 2395323, 2395322, 2395321, 2395320, 2395319, 2395318, 2395317, 2395316, 2395315, 2395314, 2395313, 2395312, 2395310, 2395311, 2395309, 2395308, 2395307, 2395306, 2395305, 2395304, 2395303, 2395302, 2395301, 2395300, 2395299, 2395298, 2395297, 2395296, 2395295, 2395294, 2395293, 2395292, 2395291, 2395290, 2395289, 2395288, 2395287, 2395286, 2395285, 2395284, 2395283, 2395282, 2395281, 2395280, 2395279, 2395278, 2395277, 2395276, 2395275, 2395274, 2395273, 2395272, 2395271, 2395270, 2395269, 2395268, 2395267, 2395266, 2395265, 2395264, 2395263, 2395262, 2395260, 2395261, 2395258, 2395259, 2395257, 2395256, 2395255, 2395254, 2395253, 2395252, 2395251, 2395250, 2395249, 2395248, 2395247, 2395246, 2395245, 2395244, 2395243, 2395242, 2395241, 2395240, 2395239, 2395238, 2395237, 2395236, 2395235, 2395234, 2395233, 2395232, 2395231, 2395230, 2395229, 2395228, 2395227, 2395226, 2395225, 2395224, 2395223, 2395222, 2395221, 2395220, 2395219, 2395218, 2395217, 2395216, 2395215, 2395214, 2395213, 2395212, 2395211, 2395210, 2395209, 2395208, 2395207, 2395206, 2395205, 2395204, 2395203, 2395202, 2395201, 2395200, 2395199, 2395198, 2395197, 2395196, 2395195, 2395194, 2395193, 2395192, 2395191, 2395190, 2395189, 2395188, 2395187, 2395186, 2395185, 2395184, 2395182, 2395183, 2395181, 2395180, 2395179, 2395178, 2395177, 2395176, 2395175)
Run Time: 0.003238
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",2395374],["thread",2395373],["thread",2395372],["thread",2395371],["thread",2395370],["thread",2395369],["thread",2395368],["thread",2395367],["thread",2395366],["thread",2395365],["thread",2395364],["thread",2395363],["thread",2395362],["thread",2395361],["thread",2395360],["thread",2395359],["thread",2395358],["thread",2395357],["thread",2395356],["thread",2395355],["thread",2395354],["thread",2395353],["thread",2395352],["thread",2395351],["thread",2395350],["thread",2395349],["thread",2395348],["thread",2395347],["thread",2395346],["thread",2395345],["thread",2395344],["thread",2395343],["thread",2395342],["thread",2395341],["thread",2395340],["thread",2395339],["thread",2395338],["thread",2395337],["thread",2395336],["thread",2395335],["thread",2395334],["thread",2395333],["thread",2395332],["thread",2395331],["thread",2395330],["thread",2395329],["thread",2395328],["thread",2395327],["thread",2395326],["thread",2395325],["thread",2395324],["thread",2395323],["thread",2395322],["thread",2395321],["thread",2395320],["thread",2395319],["thread",2395318],["thread",2395317],["thread",2395316],["thread",2395315],["thread",2395314],["thread",2395313],["thread",2395312],["thread",2395310],["thread",2395311],["thread",2395309],["thread",2395308],["thread",2395307],["thread",2395306],["thread",2395305],["thread",2395304],["thread",2395303],["thread",2395302],["thread",2395301],["thread",2395300],["thread",2395299],["thread",2395298],["thread",2395297],["thread",2395296],["thread",2395295],["thread",2395294],["thread",2395293],["thread",2395292],["thread",2395291],["thread",2395290],["thread",2395289],["thread",2395288],["thread",2395287],["thread",2395286],["thread",2395285],["thread",2395284],["thread",2395283],["thread",2395282],["thread",2395281],["thread",2395280],["thread",2395279],["thread",2395278],["thread",2395277],["thread",2395276],["thread",2395275],["thread",2395274],["thread",2395273],["thread",2395272],["thread",2395271],["thread",2395270],["thread",2395269],["thread",2395268],["thread",2395267],["thread",2395266],["thread",2395265],["thread",2395264],["thread",2395263],["thread",2395262],["thread",2395260],["thread",2395261],["thread",2395258],["thread",2395259],["thread",2395257],["thread",2395256],["thread",2395255],["thread",2395254],["thread",2395253],["thread",2395252],["thread",2395251],["thread",2395250],["thread",2395249],["thread",2395248],["thread",2395247],["thread",2395246],["thread",2395245],["thread",2395244],["thread",2395243],["thread",2395242],["thread",2395241],["thread",2395240],["thread",2395239],["thread",2395238],["thread",2395237],["thread",2395236],["thread",2395235],["thread",2395234],["thread",2395233],["thread",2395232],["thread",2395231],["thread",2395230],["thread",2395229],["thread",2395228],["thread",2395227],["thread",2395226],["thread",2395225],["thread",2395224],["thread",2395223],["thread",2395222],["thread",2395221],["thread",2395220],["thread",2395219],["thread",2395218],["thread",2395217],["thread",2395216],["thread",2395215],["thread",2395214],["thread",2395213],["thread",2395212],["thread",2395211],["thread",2395210],["thread",2395209],["thread",2395208],["thread",2395207],["thread",2395206],["thread",2395205],["thread",2395204],["thread",2395203],["thread",2395202],["thread",2395201],["thread",2395200],["thread",2395199],["thread",2395198],["thread",2395197],["thread",2395196],["thread",2395195],["thread",2395194],["thread",2395193],["thread",2395192],["thread",2395191],["thread",2395190],["thread",2395189],["thread",2395188],["thread",2395187],["thread",2395186],["thread",2395185],["thread",2395184],["thread",2395182],["thread",2395183],["thread",2395181],["thread",2395180],["thread",2395179],["thread",2395178],["thread",2395177],["thread",2395176],["thread",2395175]], 200, recent-posts, , [], date, 0, , [], 0, 1714117759, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.001693