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 (4710, 4709, 4708, 4707, 4706, 4705, 4703, 4702, 4701, 4700, 4696, 4695, 4694, 4693, 4692, 4691, 4690, 4689, 4688, 4687, 4686, 4685, 4684, 4682, 4679, 4678, 4677, 4676, 4675, 4674, 4673, 4672, 4671, 4670, 4669, 4668, 4667, 4666, 4665, 4664, 4663, 4662, 4661, 4660, 4659, 4658, 4657, 4656, 4654, 4652, 4651, 4649, 4648, 4644, 4643, 4642, 4641, 4640, 4639, 4638, 4637, 4636, 4635, 4634, 4633, 4632, 4631, 4630, 4629, 4628, 4627, 4625, 4624, 4620, 4619, 4618, 4617, 4616, 4615, 4614, 4613, 4612, 4611, 4610, 4609, 4608, 4607, 4606, 4604, 4603, 4602, 4601, 4600, 5, 4599, 4597, 4591, 4590, 4589, 4588, 4587, 4586, 4585, 4584, 4583, 4581, 4580, 4579, 4578, 4577, 4576, 4575, 4574, 4573, 4572, 4571, 4570, 4569, 4568, 4567, 4566, 4565, 3884, 4564, 4563, 4562, 4561, 4560, 4558, 4557, 4556, 4555, 4554, 4553, 4552, 4551, 4550, 4549, 4548, 4547, 4546, 4545, 4544, 4543, 4542, 4540, 4539, 4538, 4537)
Run Time: 0.001838
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 149 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | chiase_org_b978.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | chiase_org_b978.thread.node_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,chiase_org_b978.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",4710],["thread",4709],["thread",4708],["thread",4707],["thread",4706],["thread",4705],["thread",4703],["thread",4702],["thread",4701],["thread",4700],["thread",4696],["thread",4695],["thread",4694],["thread",4693],["thread",4692],["thread",4691],["thread",4690],["thread",4689],["thread",4688],["thread",4687],["thread",4686],["thread",4685],["thread",4684],["thread",4682],["thread",4679],["thread",4678],["thread",4677],["thread",4676],["thread",4675],["thread",4674],["thread",4673],["thread",4672],["thread",4671],["thread",4670],["thread",4669],["thread",4668],["thread",4667],["thread",4666],["thread",4665],["thread",4664],["thread",4663],["thread",4662],["thread",4661],["thread",4660],["thread",4659],["thread",4658],["thread",4657],["thread",4656],["thread",4654],["thread",4652],["thread",4651],["thread",4649],["thread",4648],["thread",4644],["thread",4643],["thread",4642],["thread",4641],["thread",4640],["thread",4639],["thread",4638],["thread",4637],["thread",4636],["thread",4635],["thread",4634],["thread",4633],["thread",4632],["thread",4631],["thread",4630],["thread",4629],["thread",4628],["thread",4627],["thread",4625],["thread",4624],["thread",4620],["thread",4619],["thread",4618],["thread",4617],["thread",4616],["thread",4615],["thread",4614],["thread",4613],["thread",4612],["thread",4611],["thread",4610],["thread",4609],["thread",4608],["thread",4607],["thread",4606],["thread",4604],["thread",4603],["thread",4602],["thread",4601],["thread",4600],["thread",5],["thread",4599],["thread",4597],["thread",4591],["thread",4590],["thread",4589],["thread",4588],["thread",4587],["thread",4586],["thread",4585],["thread",4584],["thread",4583],["thread",4581],["thread",4580],["thread",4579],["thread",4578],["thread",4577],["thread",4576],["thread",4575],["thread",4574],["thread",4573],["thread",4572],["thread",4571],["thread",4570],["thread",4569],["thread",4568],["thread",4567],["thread",4566],["thread",4565],["thread",3884],["thread",4564],["thread",4563],["thread",4562],["thread",4561],["thread",4560],["thread",4558],["thread",4557],["thread",4556],["thread",4555],["thread",4554],["thread",4553],["thread",4552],["thread",4551],["thread",4550],["thread",4549],["thread",4548],["thread",4547],["thread",4546],["thread",4545],["thread",4544],["thread",4543],["thread",4542],["thread",4540],["thread",4539],["thread",4538],["thread",4537]], 149, recent-posts, , [], date, 0, , [], 0, 1615087063, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000195