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 (329813, 329812, 329811, 329810, 329809, 329808, 329807, 329806, 329805, 329804, 329803, 329802, 329801, 329800, 329799, 329798, 329797, 329796, 329795, 329794, 329793, 329792, 329791, 329790, 329789, 329788, 329787, 329786, 329785, 329784, 329783, 329782, 329781, 329780, 329778, 329777, 329776, 329775, 329774, 329773, 329772, 329771, 329769, 329768, 329767, 329766, 329765, 329763, 329762, 329761, 329760, 329759, 329758, 329757, 329756, 329755, 329754, 329753, 329752, 329751, 329750, 329749, 329748, 329747, 329746, 329745, 329744, 329743, 329742, 329741, 329740, 329739, 329738, 329737, 329736, 329735, 329734, 329732, 329731, 329730, 329729, 329728, 329727, 329726, 329725, 329723, 329722, 329721, 329720, 329719, 329718, 329717, 329716, 329715, 329714, 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)
Run Time: 0.002743
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",329813],["thread",329812],["thread",329811],["thread",329810],["thread",329809],["thread",329808],["thread",329807],["thread",329806],["thread",329805],["thread",329804],["thread",329803],["thread",329802],["thread",329801],["thread",329800],["thread",329799],["thread",329798],["thread",329797],["thread",329796],["thread",329795],["thread",329794],["thread",329793],["thread",329792],["thread",329791],["thread",329790],["thread",329789],["thread",329788],["thread",329787],["thread",329786],["thread",329785],["thread",329784],["thread",329783],["thread",329782],["thread",329781],["thread",329780],["thread",329778],["thread",329777],["thread",329776],["thread",329775],["thread",329774],["thread",329773],["thread",329772],["thread",329771],["thread",329769],["thread",329768],["thread",329767],["thread",329766],["thread",329765],["thread",329763],["thread",329762],["thread",329761],["thread",329760],["thread",329759],["thread",329758],["thread",329757],["thread",329756],["thread",329755],["thread",329754],["thread",329753],["thread",329752],["thread",329751],["thread",329750],["thread",329749],["thread",329748],["thread",329747],["thread",329746],["thread",329745],["thread",329744],["thread",329743],["thread",329742],["thread",329741],["thread",329740],["thread",329739],["thread",329738],["thread",329737],["thread",329736],["thread",329735],["thread",329734],["thread",329732],["thread",329731],["thread",329730],["thread",329729],["thread",329728],["thread",329727],["thread",329726],["thread",329725],["thread",329723],["thread",329722],["thread",329721],["thread",329720],["thread",329719],["thread",329718],["thread",329717],["thread",329716],["thread",329715],["thread",329714],["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]], 200, recent-posts, , [], date, 0, , [], 0, 1715257538, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000342