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 (330789, 330788, 330787, 330786, 330784, 330783, 330782, 330781, 330780, 330779, 330778, 330775, 330772, 330771, 330769, 326160, 330768, 330767, 330766, 330765, 330764, 330763, 330762, 330761, 330760, 330759, 330757, 330756, 330755, 330753, 330752, 330751, 330750, 330749, 330748, 330747, 330746, 330744, 330742, 330739, 330738, 330737, 330736, 330735, 330734, 330733, 330732, 330731, 330730, 330729, 330728, 330727, 330726, 330725, 330724, 330723, 330722, 330720, 330719, 330718, 330717, 330716, 330714, 330713, 330712, 330710, 330709, 330705, 330704, 330703, 330701, 330700, 330699, 330698, 330697, 330696, 330695, 330694, 330693, 330692, 330691, 330690, 330689, 330687, 330686, 330685, 330684, 330682, 330681, 330680, 330679, 330678, 330677, 330676, 330675, 330674, 330673, 330671, 330670, 330669, 330668, 330667, 330666, 330665, 330664, 330662, 330661, 330660, 330659, 330658, 330657, 330656, 330655, 330654, 330653, 330652, 330651, 330650, 330649, 330648, 330647, 330646, 330645, 330644, 330643, 330642, 330641, 330638, 330637, 330636, 330635, 330634, 330633, 330632, 330631, 330630, 330629, 330628, 330627, 330626, 330625, 330624, 330623, 330622, 330621, 330619, 330617, 330616, 279347, 330615, 330614, 330612, 330611, 330610, 330609, 330608, 330607, 330606, 330605, 330604, 330603, 330602, 330601, 330600, 330599, 330598, 330597, 330596, 330595, 330593, 330591, 330590, 330589, 330588, 330587, 330585, 330583, 330582, 330581, 330578, 330577, 330576, 330575, 330574, 330573, 330572, 330571, 330570, 330569, 330568, 330567, 330566, 330565, 330563, 330562, 330561, 330559, 330558, 330557, 330556)
Run Time: 0.002818
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",330789],["thread",330788],["thread",330787],["thread",330786],["thread",330784],["thread",330783],["thread",330782],["thread",330781],["thread",330780],["thread",330779],["thread",330778],["thread",330775],["thread",330772],["thread",330771],["thread",330769],["thread",326160],["thread",330768],["thread",330767],["thread",330766],["thread",330765],["thread",330764],["thread",330763],["thread",330762],["thread",330761],["thread",330760],["thread",330759],["thread",330757],["thread",330756],["thread",330755],["thread",330753],["thread",330752],["thread",330751],["thread",330750],["thread",330749],["thread",330748],["thread",330747],["thread",330746],["thread",330744],["thread",330742],["thread",330739],["thread",330738],["thread",330737],["thread",330736],["thread",330735],["thread",330734],["thread",330733],["thread",330732],["thread",330731],["thread",330730],["thread",330729],["thread",330728],["thread",330727],["thread",330726],["thread",330725],["thread",330724],["thread",330723],["thread",330722],["thread",330720],["thread",330719],["thread",330718],["thread",330717],["thread",330716],["thread",330714],["thread",330713],["thread",330712],["thread",330710],["thread",330709],["thread",330705],["thread",330704],["thread",330703],["thread",330701],["thread",330700],["thread",330699],["thread",330698],["thread",330697],["thread",330696],["thread",330695],["thread",330694],["thread",330693],["thread",330692],["thread",330691],["thread",330690],["thread",330689],["thread",330687],["thread",330686],["thread",330685],["thread",330684],["thread",330682],["thread",330681],["thread",330680],["thread",330679],["thread",330678],["thread",330677],["thread",330676],["thread",330675],["thread",330674],["thread",330673],["thread",330671],["thread",330670],["thread",330669],["thread",330668],["thread",330667],["thread",330666],["thread",330665],["thread",330664],["thread",330662],["thread",330661],["thread",330660],["thread",330659],["thread",330658],["thread",330657],["thread",330656],["thread",330655],["thread",330654],["thread",330653],["thread",330652],["thread",330651],["thread",330650],["thread",330649],["thread",330648],["thread",330647],["thread",330646],["thread",330645],["thread",330644],["thread",330643],["thread",330642],["thread",330641],["thread",330638],["thread",330637],["thread",330636],["thread",330635],["thread",330634],["thread",330633],["thread",330632],["thread",330631],["thread",330630],["thread",330629],["thread",330628],["thread",330627],["thread",330626],["thread",330625],["thread",330624],["thread",330623],["thread",330622],["thread",330621],["thread",330619],["thread",330617],["thread",330616],["thread",279347],["thread",330615],["thread",330614],["thread",330612],["thread",330611],["thread",330610],["thread",330609],["thread",330608],["thread",330607],["thread",330606],["thread",330605],["thread",330604],["thread",330603],["thread",330602],["thread",330601],["thread",330600],["thread",330599],["thread",330598],["thread",330597],["thread",330596],["thread",330595],["thread",330593],["thread",330591],["thread",330590],["thread",330589],["thread",330588],["thread",330587],["thread",330585],["thread",330583],["thread",330582],["thread",330581],["thread",330578],["thread",330577],["thread",330576],["thread",330575],["thread",330574],["thread",330573],["thread",330572],["thread",330571],["thread",330570],["thread",330569],["thread",330568],["thread",330567],["thread",330566],["thread",330565],["thread",330563],["thread",330562],["thread",330561],["thread",330559],["thread",330558],["thread",330557],["thread",330556]], 200, recent-posts, , [], date, 0, , [], 0, 1716077602, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000193