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 (328781, 328780, 328779, 328778, 328777, 328776, 328775, 328774, 328773, 328772, 328771, 328767, 328766, 328765, 328764, 328763, 328761, 328760, 328759, 328758, 328757, 328755, 328754, 328753, 328752, 328751, 328750, 328749, 328748, 328747, 328746, 328745, 328744, 328743, 328742, 328741, 328740, 328739, 328738, 328737, 328736, 328734, 328733, 328732, 328731, 328730, 328729, 328728, 328727, 328726, 328725, 328724, 328723, 328722, 328721, 328719, 328718, 328717, 328716, 328715, 328714, 328713, 328711, 328710, 328709, 328708, 328707, 328706, 328705, 328704, 328703, 328702, 328698, 328696, 328695, 328694, 328693, 328692, 328689, 328688, 328687, 328685, 328684, 328682, 328681, 328680, 328679, 328678, 328677, 328676, 328675, 328674, 328673, 328672, 328671, 328669, 328668, 328667, 328666, 328665, 328664, 328663, 328662, 328661, 328660, 328659, 328658, 328657, 328656, 328655, 328654, 328653, 328652, 328651, 328650, 328649, 328648, 328647, 328646, 328645, 328644, 328641, 328639, 328637, 328635, 328633, 328632, 328631, 328630, 328629, 328628, 328627, 328625, 328624, 328623, 328622, 328621, 328620, 328619, 328618, 328617, 328615, 328614, 328612, 328611, 328610, 328609, 328607, 328606, 328605, 328604, 328603, 328602, 328601, 328600, 328599, 328598, 328597, 328596, 328595, 328594, 328593, 328592, 328591, 328590, 328589, 328588, 328587, 328586, 328585, 328584, 328583, 328582, 328580, 328579, 328578, 328577, 328576, 328575, 328574, 328573, 328572, 328571, 328570, 328568, 328567, 328566, 328565, 328563, 328562, 328561, 328560, 328559, 328558, 328556, 328555, 328554, 328553, 328552, 328551)
Run Time: 0.005264
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",328781],["thread",328780],["thread",328779],["thread",328778],["thread",328777],["thread",328776],["thread",328775],["thread",328774],["thread",328773],["thread",328772],["thread",328771],["thread",328767],["thread",328766],["thread",328765],["thread",328764],["thread",328763],["thread",328761],["thread",328760],["thread",328759],["thread",328758],["thread",328757],["thread",328755],["thread",328754],["thread",328753],["thread",328752],["thread",328751],["thread",328750],["thread",328749],["thread",328748],["thread",328747],["thread",328746],["thread",328745],["thread",328744],["thread",328743],["thread",328742],["thread",328741],["thread",328740],["thread",328739],["thread",328738],["thread",328737],["thread",328736],["thread",328734],["thread",328733],["thread",328732],["thread",328731],["thread",328730],["thread",328729],["thread",328728],["thread",328727],["thread",328726],["thread",328725],["thread",328724],["thread",328723],["thread",328722],["thread",328721],["thread",328719],["thread",328718],["thread",328717],["thread",328716],["thread",328715],["thread",328714],["thread",328713],["thread",328711],["thread",328710],["thread",328709],["thread",328708],["thread",328707],["thread",328706],["thread",328705],["thread",328704],["thread",328703],["thread",328702],["thread",328698],["thread",328696],["thread",328695],["thread",328694],["thread",328693],["thread",328692],["thread",328689],["thread",328688],["thread",328687],["thread",328685],["thread",328684],["thread",328682],["thread",328681],["thread",328680],["thread",328679],["thread",328678],["thread",328677],["thread",328676],["thread",328675],["thread",328674],["thread",328673],["thread",328672],["thread",328671],["thread",328669],["thread",328668],["thread",328667],["thread",328666],["thread",328665],["thread",328664],["thread",328663],["thread",328662],["thread",328661],["thread",328660],["thread",328659],["thread",328658],["thread",328657],["thread",328656],["thread",328655],["thread",328654],["thread",328653],["thread",328652],["thread",328651],["thread",328650],["thread",328649],["thread",328648],["thread",328647],["thread",328646],["thread",328645],["thread",328644],["thread",328641],["thread",328639],["thread",328637],["thread",328635],["thread",328633],["thread",328632],["thread",328631],["thread",328630],["thread",328629],["thread",328628],["thread",328627],["thread",328625],["thread",328624],["thread",328623],["thread",328622],["thread",328621],["thread",328620],["thread",328619],["thread",328618],["thread",328617],["thread",328615],["thread",328614],["thread",328612],["thread",328611],["thread",328610],["thread",328609],["thread",328607],["thread",328606],["thread",328605],["thread",328604],["thread",328603],["thread",328602],["thread",328601],["thread",328600],["thread",328599],["thread",328598],["thread",328597],["thread",328596],["thread",328595],["thread",328594],["thread",328593],["thread",328592],["thread",328591],["thread",328590],["thread",328589],["thread",328588],["thread",328587],["thread",328586],["thread",328585],["thread",328584],["thread",328583],["thread",328582],["thread",328580],["thread",328579],["thread",328578],["thread",328577],["thread",328576],["thread",328575],["thread",328574],["thread",328573],["thread",328572],["thread",328571],["thread",328570],["thread",328568],["thread",328567],["thread",328566],["thread",328565],["thread",328563],["thread",328562],["thread",328561],["thread",328560],["thread",328559],["thread",328558],["thread",328556],["thread",328555],["thread",328554],["thread",328553],["thread",328552],["thread",328551]], 200, recent-posts, , [], date, 0, , [], 0, 1714546861, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000276