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 (328536, 328535, 328534, 328532, 328531, 328530, 328529, 328527, 328526, 328525, 328523, 328522, 328520, 328519, 328517, 328516, 328515, 328514, 328513, 328512, 328510, 328511, 328509, 328508, 328507, 328506, 328505, 328504, 328503, 328502, 328501, 328500, 328499, 328498, 328497, 328496, 328495, 328494, 328493, 328492, 328491, 328490, 328489, 328488, 328487, 328486, 328485, 328484, 328482, 328480, 328479, 328478, 328477, 328475, 328473, 328472, 328471, 328469, 328468, 328467, 328466, 328464, 328463, 328462, 328461, 328460, 328458, 328457, 328456, 328455, 328454, 328453, 328452, 328451, 328449, 328448, 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)
Run Time: 0.002731
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",328536],["thread",328535],["thread",328534],["thread",328532],["thread",328531],["thread",328530],["thread",328529],["thread",328527],["thread",328526],["thread",328525],["thread",328523],["thread",328522],["thread",328520],["thread",328519],["thread",328517],["thread",328516],["thread",328515],["thread",328514],["thread",328513],["thread",328512],["thread",328510],["thread",328511],["thread",328509],["thread",328508],["thread",328507],["thread",328506],["thread",328505],["thread",328504],["thread",328503],["thread",328502],["thread",328501],["thread",328500],["thread",328499],["thread",328498],["thread",328497],["thread",328496],["thread",328495],["thread",328494],["thread",328493],["thread",328492],["thread",328491],["thread",328490],["thread",328489],["thread",328488],["thread",328487],["thread",328486],["thread",328485],["thread",328484],["thread",328482],["thread",328480],["thread",328479],["thread",328478],["thread",328477],["thread",328475],["thread",328473],["thread",328472],["thread",328471],["thread",328469],["thread",328468],["thread",328467],["thread",328466],["thread",328464],["thread",328463],["thread",328462],["thread",328461],["thread",328460],["thread",328458],["thread",328457],["thread",328456],["thread",328455],["thread",328454],["thread",328453],["thread",328452],["thread",328451],["thread",328449],["thread",328448],["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]], 200, recent-posts, , [], date, 0, , [], 0, 1714393249, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000200