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 (329445, 329444, 329443, 329441, 329436, 329435, 329434, 329433, 329432, 329431, 329430, 329429, 329428, 329427, 329426, 329425, 329424, 329422, 329421, 329420, 329419, 329418, 329417, 329416, 329415, 329414, 329413, 329412, 329411, 329410, 329409, 329408, 329407, 329406, 329405, 329404, 329403, 329402, 329400, 329399, 329398, 329397, 329396, 329395, 329394, 329393, 329392, 329391, 329390, 329389, 329388, 329387, 329386, 329385, 329384, 329383, 329381, 329380, 329379, 329378, 329377, 329376, 329375, 329374, 329373, 329372, 329371, 329370, 329369, 329368, 329367, 329366, 329364, 329363, 329362, 329361, 329360, 329359, 329358, 329357, 329356, 329355, 329354, 329353, 329352, 329351, 329350, 329349, 329348, 329347, 329346, 329345, 329344, 329343, 329342, 329341, 329340, 329339, 329338, 329337, 329335, 329334, 329333, 329332, 329331, 329330, 329328, 329327, 329326, 329325, 329324, 329322, 329321, 329320, 329319, 329318, 329317, 329316, 329315, 329314, 329313, 329312, 329311, 329310, 329309, 329308, 329307, 329306, 329305, 329302, 329301, 329300, 329299, 329297, 329296, 329295, 329294, 329293, 329292, 329291, 329290, 329289, 329288, 329287, 329285, 329284, 329283, 329282, 329281, 329280, 329279, 329278, 329277, 329276, 329275, 329274, 329273, 329272, 329271, 329270, 329269, 329268, 329267, 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)
Run Time: 0.002695
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",329445],["thread",329444],["thread",329443],["thread",329441],["thread",329436],["thread",329435],["thread",329434],["thread",329433],["thread",329432],["thread",329431],["thread",329430],["thread",329429],["thread",329428],["thread",329427],["thread",329426],["thread",329425],["thread",329424],["thread",329422],["thread",329421],["thread",329420],["thread",329419],["thread",329418],["thread",329417],["thread",329416],["thread",329415],["thread",329414],["thread",329413],["thread",329412],["thread",329411],["thread",329410],["thread",329409],["thread",329408],["thread",329407],["thread",329406],["thread",329405],["thread",329404],["thread",329403],["thread",329402],["thread",329400],["thread",329399],["thread",329398],["thread",329397],["thread",329396],["thread",329395],["thread",329394],["thread",329393],["thread",329392],["thread",329391],["thread",329390],["thread",329389],["thread",329388],["thread",329387],["thread",329386],["thread",329385],["thread",329384],["thread",329383],["thread",329381],["thread",329380],["thread",329379],["thread",329378],["thread",329377],["thread",329376],["thread",329375],["thread",329374],["thread",329373],["thread",329372],["thread",329371],["thread",329370],["thread",329369],["thread",329368],["thread",329367],["thread",329366],["thread",329364],["thread",329363],["thread",329362],["thread",329361],["thread",329360],["thread",329359],["thread",329358],["thread",329357],["thread",329356],["thread",329355],["thread",329354],["thread",329353],["thread",329352],["thread",329351],["thread",329350],["thread",329349],["thread",329348],["thread",329347],["thread",329346],["thread",329345],["thread",329344],["thread",329343],["thread",329342],["thread",329341],["thread",329340],["thread",329339],["thread",329338],["thread",329337],["thread",329335],["thread",329334],["thread",329333],["thread",329332],["thread",329331],["thread",329330],["thread",329328],["thread",329327],["thread",329326],["thread",329325],["thread",329324],["thread",329322],["thread",329321],["thread",329320],["thread",329319],["thread",329318],["thread",329317],["thread",329316],["thread",329315],["thread",329314],["thread",329313],["thread",329312],["thread",329311],["thread",329310],["thread",329309],["thread",329308],["thread",329307],["thread",329306],["thread",329305],["thread",329302],["thread",329301],["thread",329300],["thread",329299],["thread",329297],["thread",329296],["thread",329295],["thread",329294],["thread",329293],["thread",329292],["thread",329291],["thread",329290],["thread",329289],["thread",329288],["thread",329287],["thread",329285],["thread",329284],["thread",329283],["thread",329282],["thread",329281],["thread",329280],["thread",329279],["thread",329278],["thread",329277],["thread",329276],["thread",329275],["thread",329274],["thread",329273],["thread",329272],["thread",329271],["thread",329270],["thread",329269],["thread",329268],["thread",329267],["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]], 200, recent-posts, , [], date, 0, , [], 0, 1714939494, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000269