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 (329602, 329601, 329600, 329599, 329598, 329596, 329597, 329595, 329594, 329593, 329592, 329591, 329590, 329589, 329588, 329587, 329586, 329585, 329584, 329582, 329581, 329580, 329578, 329577, 329576, 329575, 329574, 329573, 329572, 329571, 329570, 329569, 329568, 329567, 329566, 329565, 329564, 329563, 329562, 329561, 329560, 329559, 329558, 329557, 329556, 329555, 329554, 329553, 329552, 329551, 329550, 329549, 329548, 329547, 329546, 329545, 329544, 329543, 329542, 329541, 329540, 329539, 329538, 329537, 329536, 329535, 329534, 329533, 329532, 329531, 329530, 329529, 329528, 329527, 329526, 329525, 329524, 329523, 329522, 329521, 329520, 329519, 329518, 329517, 329516, 329515, 329514, 329513, 329512, 329510, 329509, 329508, 329507, 329506, 329505, 329504, 329503, 329502, 329501, 329500, 329499, 329498, 329497, 329496, 329495, 329494, 329493, 329492, 329491, 329490, 329489, 329488, 324864, 329487, 329486, 329485, 329484, 329483, 329482, 329481, 329480, 329478, 329477, 329476, 329475, 329474, 329473, 329472, 329471, 329469, 329468, 329467, 329466, 329465, 329464, 329463, 329462, 329461, 329460, 329459, 329458, 329457, 329456, 329455, 329454, 329453, 329452, 329451, 329449, 329448, 329447, 329446, 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)
Run Time: 0.002789
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",329602],["thread",329601],["thread",329600],["thread",329599],["thread",329598],["thread",329596],["thread",329597],["thread",329595],["thread",329594],["thread",329593],["thread",329592],["thread",329591],["thread",329590],["thread",329589],["thread",329588],["thread",329587],["thread",329586],["thread",329585],["thread",329584],["thread",329582],["thread",329581],["thread",329580],["thread",329578],["thread",329577],["thread",329576],["thread",329575],["thread",329574],["thread",329573],["thread",329572],["thread",329571],["thread",329570],["thread",329569],["thread",329568],["thread",329567],["thread",329566],["thread",329565],["thread",329564],["thread",329563],["thread",329562],["thread",329561],["thread",329560],["thread",329559],["thread",329558],["thread",329557],["thread",329556],["thread",329555],["thread",329554],["thread",329553],["thread",329552],["thread",329551],["thread",329550],["thread",329549],["thread",329548],["thread",329547],["thread",329546],["thread",329545],["thread",329544],["thread",329543],["thread",329542],["thread",329541],["thread",329540],["thread",329539],["thread",329538],["thread",329537],["thread",329536],["thread",329535],["thread",329534],["thread",329533],["thread",329532],["thread",329531],["thread",329530],["thread",329529],["thread",329528],["thread",329527],["thread",329526],["thread",329525],["thread",329524],["thread",329523],["thread",329522],["thread",329521],["thread",329520],["thread",329519],["thread",329518],["thread",329517],["thread",329516],["thread",329515],["thread",329514],["thread",329513],["thread",329512],["thread",329510],["thread",329509],["thread",329508],["thread",329507],["thread",329506],["thread",329505],["thread",329504],["thread",329503],["thread",329502],["thread",329501],["thread",329500],["thread",329499],["thread",329498],["thread",329497],["thread",329496],["thread",329495],["thread",329494],["thread",329493],["thread",329492],["thread",329491],["thread",329490],["thread",329489],["thread",329488],["thread",324864],["thread",329487],["thread",329486],["thread",329485],["thread",329484],["thread",329483],["thread",329482],["thread",329481],["thread",329480],["thread",329478],["thread",329477],["thread",329476],["thread",329475],["thread",329474],["thread",329473],["thread",329472],["thread",329471],["thread",329469],["thread",329468],["thread",329467],["thread",329466],["thread",329465],["thread",329464],["thread",329463],["thread",329462],["thread",329461],["thread",329460],["thread",329459],["thread",329458],["thread",329457],["thread",329456],["thread",329455],["thread",329454],["thread",329453],["thread",329452],["thread",329451],["thread",329449],["thread",329448],["thread",329447],["thread",329446],["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]], 200, recent-posts, , [], date, 0, , [], 0, 1715082372, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000250