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 (329713, 329712, 329711, 329710, 329709, 329708, 329707, 329706, 329702, 329701, 329700, 329699, 329698, 329696, 329695, 329694, 329693, 329692, 329691, 329690, 329687, 329686, 329685, 329684, 329683, 329682, 329681, 329680, 329679, 329678, 329677, 329676, 329675, 329674, 329673, 329672, 329671, 329670, 329669, 329668, 329667, 329666, 329665, 329664, 329663, 329662, 329661, 329660, 329659, 329658, 329657, 329656, 329655, 329653, 329652, 329651, 329650, 329649, 329648, 329647, 329646, 329645, 329644, 329642, 329641, 329640, 329639, 329638, 329635, 329634, 329633, 329631, 329629, 329628, 329627, 329626, 329625, 329624, 329623, 329622, 329621, 329620, 329619, 329617, 329615, 329614, 329613, 329610, 329609, 329608, 329607, 329606, 329605, 329604, 329603, 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)
Run Time: 0.002964
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",329713],["thread",329712],["thread",329711],["thread",329710],["thread",329709],["thread",329708],["thread",329707],["thread",329706],["thread",329702],["thread",329701],["thread",329700],["thread",329699],["thread",329698],["thread",329696],["thread",329695],["thread",329694],["thread",329693],["thread",329692],["thread",329691],["thread",329690],["thread",329687],["thread",329686],["thread",329685],["thread",329684],["thread",329683],["thread",329682],["thread",329681],["thread",329680],["thread",329679],["thread",329678],["thread",329677],["thread",329676],["thread",329675],["thread",329674],["thread",329673],["thread",329672],["thread",329671],["thread",329670],["thread",329669],["thread",329668],["thread",329667],["thread",329666],["thread",329665],["thread",329664],["thread",329663],["thread",329662],["thread",329661],["thread",329660],["thread",329659],["thread",329658],["thread",329657],["thread",329656],["thread",329655],["thread",329653],["thread",329652],["thread",329651],["thread",329650],["thread",329649],["thread",329648],["thread",329647],["thread",329646],["thread",329645],["thread",329644],["thread",329642],["thread",329641],["thread",329640],["thread",329639],["thread",329638],["thread",329635],["thread",329634],["thread",329633],["thread",329631],["thread",329629],["thread",329628],["thread",329627],["thread",329626],["thread",329625],["thread",329624],["thread",329623],["thread",329622],["thread",329621],["thread",329620],["thread",329619],["thread",329617],["thread",329615],["thread",329614],["thread",329613],["thread",329610],["thread",329609],["thread",329608],["thread",329607],["thread",329606],["thread",329605],["thread",329604],["thread",329603],["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]], 200, recent-posts, , [], date, 0, , [], 0, 1715144655, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000217