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 (328447, 328446, 328445, 328444, 328443, 328442, 328441, 328440, 328437, 328434, 328433, 328432, 328431, 328430, 328429, 328428, 328427, 328426, 328425, 328424, 328423, 328422, 328421, 328419, 328418, 328417, 328416, 328415, 328414, 328412, 328411, 328410, 328409, 328408, 328407, 328406, 328405, 328404, 328403, 328402, 328401, 328400, 328399, 328398, 328397, 328396, 328395, 328394, 328393, 328392, 328391, 328390, 328389, 328388, 328387, 328386, 328385, 328384, 328383, 328382, 328381, 328380, 328379, 328378, 328377, 328376, 328375, 328374, 328373, 328372, 328371, 328369, 328370, 328368, 328367, 328366, 328365, 328364, 324864, 328362, 328361, 328360, 328359, 328358, 328357, 328356, 328355, 328354, 328353, 328351, 328350, 328349, 328348, 328347, 328346, 326130, 328345, 328344, 328343, 328342, 328341, 328340, 328339, 328337, 328336, 328335, 328334, 328333, 328332, 328331, 328330, 328329, 328327, 328325, 328324, 328322, 328321, 328319, 328318, 328317, 328316, 328315, 328314, 328313, 328312, 328311, 328310, 328309, 328308, 328307, 328306, 328305, 328304, 328303, 328302, 328301, 328300, 328299, 328298, 328297, 328296, 328295, 328294, 328293, 328292, 328291, 328290, 328289, 328288, 328287, 328285, 328284, 328283, 328282, 328280, 328279, 328278, 328277, 328276, 328275, 328274, 328273, 328272, 328271, 328270, 328269, 328268, 328267, 328266, 328265, 328264, 328263, 328262, 328261, 328260, 328259, 328258, 328257, 328256, 328255, 328254, 328253, 328252, 328251, 328250, 328249, 328248, 328247, 328246, 328245, 328244, 328243, 328242, 76715, 328241, 328240, 328239, 328238, 328237, 328236)
Run Time: 0.002829
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",328447],["thread",328446],["thread",328445],["thread",328444],["thread",328443],["thread",328442],["thread",328441],["thread",328440],["thread",328437],["thread",328434],["thread",328433],["thread",328432],["thread",328431],["thread",328430],["thread",328429],["thread",328428],["thread",328427],["thread",328426],["thread",328425],["thread",328424],["thread",328423],["thread",328422],["thread",328421],["thread",328419],["thread",328418],["thread",328417],["thread",328416],["thread",328415],["thread",328414],["thread",328412],["thread",328411],["thread",328410],["thread",328409],["thread",328408],["thread",328407],["thread",328406],["thread",328405],["thread",328404],["thread",328403],["thread",328402],["thread",328401],["thread",328400],["thread",328399],["thread",328398],["thread",328397],["thread",328396],["thread",328395],["thread",328394],["thread",328393],["thread",328392],["thread",328391],["thread",328390],["thread",328389],["thread",328388],["thread",328387],["thread",328386],["thread",328385],["thread",328384],["thread",328383],["thread",328382],["thread",328381],["thread",328380],["thread",328379],["thread",328378],["thread",328377],["thread",328376],["thread",328375],["thread",328374],["thread",328373],["thread",328372],["thread",328371],["thread",328369],["thread",328370],["thread",328368],["thread",328367],["thread",328366],["thread",328365],["thread",328364],["thread",324864],["thread",328362],["thread",328361],["thread",328360],["thread",328359],["thread",328358],["thread",328357],["thread",328356],["thread",328355],["thread",328354],["thread",328353],["thread",328351],["thread",328350],["thread",328349],["thread",328348],["thread",328347],["thread",328346],["thread",326130],["thread",328345],["thread",328344],["thread",328343],["thread",328342],["thread",328341],["thread",328340],["thread",328339],["thread",328337],["thread",328336],["thread",328335],["thread",328334],["thread",328333],["thread",328332],["thread",328331],["thread",328330],["thread",328329],["thread",328327],["thread",328325],["thread",328324],["thread",328322],["thread",328321],["thread",328319],["thread",328318],["thread",328317],["thread",328316],["thread",328315],["thread",328314],["thread",328313],["thread",328312],["thread",328311],["thread",328310],["thread",328309],["thread",328308],["thread",328307],["thread",328306],["thread",328305],["thread",328304],["thread",328303],["thread",328302],["thread",328301],["thread",328300],["thread",328299],["thread",328298],["thread",328297],["thread",328296],["thread",328295],["thread",328294],["thread",328293],["thread",328292],["thread",328291],["thread",328290],["thread",328289],["thread",328288],["thread",328287],["thread",328285],["thread",328284],["thread",328283],["thread",328282],["thread",328280],["thread",328279],["thread",328278],["thread",328277],["thread",328276],["thread",328275],["thread",328274],["thread",328273],["thread",328272],["thread",328271],["thread",328270],["thread",328269],["thread",328268],["thread",328267],["thread",328266],["thread",328265],["thread",328264],["thread",328263],["thread",328262],["thread",328261],["thread",328260],["thread",328259],["thread",328258],["thread",328257],["thread",328256],["thread",328255],["thread",328254],["thread",328253],["thread",328252],["thread",328251],["thread",328250],["thread",328249],["thread",328248],["thread",328247],["thread",328246],["thread",328245],["thread",328244],["thread",328243],["thread",328242],["thread",76715],["thread",328241],["thread",328240],["thread",328239],["thread",328238],["thread",328237],["thread",328236]], 200, recent-posts, , [], date, 0, , [], 0, 1714326854, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000207