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 (91540, 2021730, 2021744, 2021739, 2021734, 2021738, 2021743, 2021742, 2021741, 2021740, 2025566, 2025565, 2025564, 2025563, 2025562, 2008659, 2025561, 2025560, 2025559, 2021724, 2021418, 2021416, 2021735, 2024341, 2024340, 2024339, 2025558, 2025557, 2008697, 2025556, 2025555, 2025554, 2025553, 2025552, 2025551, 2025550, 2025549, 2025548, 2025547, 2025546, 2017164, 2025545, 1953475, 2025544, 2025543, 2025542, 2025541, 2025540, 2025539, 2025538, 2025537, 2025536, 2025535, 2025534, 2025533, 2025532, 2025531, 2025530, 2025529, 2025528, 2025527, 2025526, 2025525, 2021086, 2021750, 2021737, 2021732, 2021731, 2021728, 2021727, 2021725, 2021723, 2021722, 2021726, 2021720, 2021719, 2021718, 2021717, 2021721, 2025524, 2025523, 2025522, 2025521, 2025520, 2025519, 2025518, 2025517, 2025516, 2025515, 2017907, 2025514, 2025513, 2025512, 2025511, 2025510, 2025509, 2025508, 2025507, 2025506, 2025505, 2025504, 2025503, 2025502, 2025501, 2025500, 2025499, 2025498, 2025497, 2025496, 2025495, 2025494, 2025493, 2025492, 2025491, 2025490, 2025489, 2025488, 2025487, 2025486, 2021554, 2025485, 2025484, 2025483, 2025482, 2025481, 2025480, 2025479, 2025478, 2025477, 2025476, 2025475, 2025474, 2025473, 2025472, 2025471, 2025470, 2025469, 2017355, 2025468, 2025467, 2025466, 2025465, 2025464, 2025463, 2025462, 2025461, 2025460, 2025459, 2025458, 2025457, 2025456, 2025455, 2025454, 2025453, 2025452, 2025451, 2025450, 2025449, 2025448, 2025447, 2025446, 2025445, 2008696, 2025444, 2025443, 2025442, 2025441, 2025440, 2025439, 2025438, 2025437, 2025436, 2025435, 2025434, 2025433, 2025432, 2025431, 2025430, 2025429, 2025428, 2025427, 2025426, 2025425, 2025424, 2025423, 2025422, 2025421, 2025420, 2025419, 2025418, 2025417, 2025416, 2025415, 2025414, 2025413, 2025412, 2025411, 2025410, 2017221, 2025409)
Run Time: 0.002832
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 | dirty.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | dirty.thread.node_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,dirty.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",91540],["thread",2021730],["thread",2021744],["thread",2021739],["thread",2021734],["thread",2021738],["thread",2021743],["thread",2021742],["thread",2021741],["thread",2021740],["thread",2025566],["thread",2025565],["thread",2025564],["thread",2025563],["thread",2025562],["thread",2008659],["thread",2025561],["thread",2025560],["thread",2025559],["thread",2021724],["thread",2021418],["thread",2021416],["thread",2021735],["thread",2024341],["thread",2024340],["thread",2024339],["thread",2025558],["thread",2025557],["thread",2008697],["thread",2025556],["thread",2025555],["thread",2025554],["thread",2025553],["thread",2025552],["thread",2025551],["thread",2025550],["thread",2025549],["thread",2025548],["thread",2025547],["thread",2025546],["thread",2017164],["thread",2025545],["thread",1953475],["thread",2025544],["thread",2025543],["thread",2025542],["thread",2025541],["thread",2025540],["thread",2025539],["thread",2025538],["thread",2025537],["thread",2025536],["thread",2025535],["thread",2025534],["thread",2025533],["thread",2025532],["thread",2025531],["thread",2025530],["thread",2025529],["thread",2025528],["thread",2025527],["thread",2025526],["thread",2025525],["thread",2021086],["thread",2021750],["thread",2021737],["thread",2021732],["thread",2021731],["thread",2021728],["thread",2021727],["thread",2021725],["thread",2021723],["thread",2021722],["thread",2021726],["thread",2021720],["thread",2021719],["thread",2021718],["thread",2021717],["thread",2021721],["thread",2025524],["thread",2025523],["thread",2025522],["thread",2025521],["thread",2025520],["thread",2025519],["thread",2025518],["thread",2025517],["thread",2025516],["thread",2025515],["thread",2017907],["thread",2025514],["thread",2025513],["thread",2025512],["thread",2025511],["thread",2025510],["thread",2025509],["thread",2025508],["thread",2025507],["thread",2025506],["thread",2025505],["thread",2025504],["thread",2025503],["thread",2025502],["thread",2025501],["thread",2025500],["thread",2025499],["thread",2025498],["thread",2025497],["thread",2025496],["thread",2025495],["thread",2025494],["thread",2025493],["thread",2025492],["thread",2025491],["thread",2025490],["thread",2025489],["thread",2025488],["thread",2025487],["thread",2025486],["thread",2021554],["thread",2025485],["thread",2025484],["thread",2025483],["thread",2025482],["thread",2025481],["thread",2025480],["thread",2025479],["thread",2025478],["thread",2025477],["thread",2025476],["thread",2025475],["thread",2025474],["thread",2025473],["thread",2025472],["thread",2025471],["thread",2025470],["thread",2025469],["thread",2017355],["thread",2025468],["thread",2025467],["thread",2025466],["thread",2025465],["thread",2025464],["thread",2025463],["thread",2025462],["thread",2025461],["thread",2025460],["thread",2025459],["thread",2025458],["thread",2025457],["thread",2025456],["thread",2025455],["thread",2025454],["thread",2025453],["thread",2025452],["thread",2025451],["thread",2025450],["thread",2025449],["thread",2025448],["thread",2025447],["thread",2025446],["thread",2025445],["thread",2008696],["thread",2025444],["thread",2025443],["thread",2025442],["thread",2025441],["thread",2025440],["thread",2025439],["thread",2025438],["thread",2025437],["thread",2025436],["thread",2025435],["thread",2025434],["thread",2025433],["thread",2025432],["thread",2025431],["thread",2025430],["thread",2025429],["thread",2025428],["thread",2025427],["thread",2025426],["thread",2025425],["thread",2025424],["thread",2025423],["thread",2025422],["thread",2025421],["thread",2025420],["thread",2025419],["thread",2025418],["thread",2025417],["thread",2025416],["thread",2025415],["thread",2025414],["thread",2025413],["thread",2025412],["thread",2025411],["thread",2025410],["thread",2017221],["thread",2025409]], 200, recent-posts, , [], date, 0, , [], 0, 1711705959, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.008190