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 (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, 328550, 328549, 328548, 328547, 328546, 328545, 328544, 328543, 328542, 328541, 328540, 328539, 328538, 328537, 328536, 328535, 328534, 328532, 328531, 328530, 328529, 328527, 328526, 328525, 328523, 328522, 328520, 328519, 328517, 328516, 328515, 328514, 328513, 328512, 328510, 328511, 328509, 328508, 328507, 328506, 328505, 328504, 328503, 328502, 328501, 328500, 328499, 328498, 328497, 328496, 328495, 328494, 328493, 328492, 328491, 328490, 328489, 328488, 328487, 328486, 328485, 328484, 328482, 328480, 328479, 328478, 328477, 328475, 328473, 328472, 328471, 328469, 328468, 328467, 328466, 328464, 328463, 328462, 328461, 328460, 328458, 328457, 328456, 328455, 328454, 328453, 328452, 328451, 328449, 328448, 328447, 328446, 328445, 328444, 328443)
Run Time: 0.003500
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",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],["thread",328550],["thread",328549],["thread",328548],["thread",328547],["thread",328546],["thread",328545],["thread",328544],["thread",328543],["thread",328542],["thread",328541],["thread",328540],["thread",328539],["thread",328538],["thread",328537],["thread",328536],["thread",328535],["thread",328534],["thread",328532],["thread",328531],["thread",328530],["thread",328529],["thread",328527],["thread",328526],["thread",328525],["thread",328523],["thread",328522],["thread",328520],["thread",328519],["thread",328517],["thread",328516],["thread",328515],["thread",328514],["thread",328513],["thread",328512],["thread",328510],["thread",328511],["thread",328509],["thread",328508],["thread",328507],["thread",328506],["thread",328505],["thread",328504],["thread",328503],["thread",328502],["thread",328501],["thread",328500],["thread",328499],["thread",328498],["thread",328497],["thread",328496],["thread",328495],["thread",328494],["thread",328493],["thread",328492],["thread",328491],["thread",328490],["thread",328489],["thread",328488],["thread",328487],["thread",328486],["thread",328485],["thread",328484],["thread",328482],["thread",328480],["thread",328479],["thread",328478],["thread",328477],["thread",328475],["thread",328473],["thread",328472],["thread",328471],["thread",328469],["thread",328468],["thread",328467],["thread",328466],["thread",328464],["thread",328463],["thread",328462],["thread",328461],["thread",328460],["thread",328458],["thread",328457],["thread",328456],["thread",328455],["thread",328454],["thread",328453],["thread",328452],["thread",328451],["thread",328449],["thread",328448],["thread",328447],["thread",328446],["thread",328445],["thread",328444],["thread",328443]], 200, recent-posts, , [], date, 0, , [], 0, 1714478785, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000252