SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_user_User_3`.*, `xf_post_FirstPost_4`.*, `xf_permission_cache_content_Permissions_5`.*
FROM `xf_thread`
LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_2` ON (`xf_node_Node_2`.`node_id` = `xf_forum_Forum_1`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_post` AS `xf_post_FirstPost_4` ON (`xf_post_FirstPost_4`.`post_id` = `xf_thread`.`first_post_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_2`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_thread`.`thread_id` IN (49680, 49015, 48996, 48883, 48737, 48265, 47348, 47161, 45274, 44087, 44027, 44026, 44025, 44022, 42912, 40133, 39941, 39566, 36849, 36848, 36847, 36846, 36845, 36843, 36842, 36841, 36840, 36839, 36838, 36837, 36836, 36835, 36834, 36833, 36832, 36831, 36830, 36829, 36828, 36827, 36826, 36825, 36824, 36823, 36822, 36821, 36820, 36819, 36818, 36817, 36816, 36815, 36814, 36813, 36812, 36811, 36809, 36808, 36807, 36806, 36805, 36804, 36803, 36802, 36801, 36800, 36799, 36798, 36797, 36795, 36794, 36793, 36792, 36791, 36790, 36789, 36788, 36787, 36786, 36785, 36784, 36783, 36782, 36781, 36780, 36779, 36778, 36777, 36776, 36775, 36774, 36773, 36772, 36771, 36770, 36769, 36768, 36767, 36766, 36765, 36764, 36763, 36762, 36761, 36760, 36759, 36758, 36756, 36755, 36754, 36753, 36752, 36751, 36750, 36749, 36748, 36747, 36746, 36745, 36744, 36743, 36742, 36741, 36740, 36739, 36738, 36737, 36736, 36735, 36734, 36733, 36732, 36731, 36730, 36729, 36728, 36727, 36726, 36725, 36724, 36723, 36722, 36721, 36720, 36718, 36717, 36716, 36715, 36714, 36713, 36712, 36711, 36710, 36709, 36708, 36707, 36706, 36705, 36704, 36703, 36702, 36701, 36700, 36699, 36698, 36697, 36695, 36694, 36693, 36692, 36691, 36690, 36689, 36688, 36687, 36686, 36685, 36684, 36683, 36682, 36681, 36680, 36679, 36678, 36677, 36676, 36675, 36674, 36673, 36672, 36671, 36670, 36669, 36668, 36666, 36665, 36664, 36663, 36662, 36661))
Run Time: 0.012197
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 200 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | import4.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | import4.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | import4.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | import4.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,import4.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1387
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2719
- XF\App->findByContentType() in src/XF/Tag/AbstractHandler.php at line 62
- XF\Tag\AbstractHandler->getContent() in src/XF/Repository/Tag.php at line 731
- XF\Repository\Tag->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/Pub/Controller/Tag.php at line 137
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2345
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
INSERT INTO `xf_tag_result_cache` (`tag_id`, `user_id`, `expiry_date`, `results`, `result_cache_id`, `cache_date`) VALUES (?, ?, ?, ?, ?, ?)
Params: 5976, 0, 1715662357, {"thread-49680":["thread",49680],"thread-49015":["thread",49015],"thread-48996":["thread",48996],"thread-48883":["thread",48883],"thread-48737":["thread",48737],"thread-48265":["thread",48265],"thread-47348":["thread",47348],"thread-47161":["thread",47161],"thread-45274":["thread",45274],"thread-44087":["thread",44087],"thread-44027":["thread",44027],"thread-44026":["thread",44026],"thread-44025":["thread",44025],"thread-44022":["thread",44022],"thread-42912":["thread",42912],"thread-40133":["thread",40133],"thread-39941":["thread",39941],"thread-39566":["thread",39566],"thread-36849":["thread",36849],"thread-36848":["thread",36848],"thread-36847":["thread",36847],"thread-36846":["thread",36846],"thread-36845":["thread",36845],"thread-36843":["thread",36843],"thread-36842":["thread",36842],"thread-36841":["thread",36841],"thread-36840":["thread",36840],"thread-36839":["thread",36839],"thread-36838":["thread",36838],"thread-36837":["thread",36837],"thread-36836":["thread",36836],"thread-36835":["thread",36835],"thread-36834":["thread",36834],"thread-36833":["thread",36833],"thread-36832":["thread",36832],"thread-36831":["thread",36831],"thread-36830":["thread",36830],"thread-36829":["thread",36829],"thread-36828":["thread",36828],"thread-36827":["thread",36827],"thread-36826":["thread",36826],"thread-36825":["thread",36825],"thread-36824":["thread",36824],"thread-36823":["thread",36823],"thread-36822":["thread",36822],"thread-36821":["thread",36821],"thread-36820":["thread",36820],"thread-36819":["thread",36819],"thread-36818":["thread",36818],"thread-36817":["thread",36817],"thread-36816":["thread",36816],"thread-36815":["thread",36815],"thread-36814":["thread",36814],"thread-36813":["thread",36813],"thread-36812":["thread",36812],"thread-36811":["thread",36811],"thread-36809":["thread",36809],"thread-36808":["thread",36808],"thread-36807":["thread",36807],"thread-36806":["thread",36806],"thread-36805":["thread",36805],"thread-36804":["thread",36804],"thread-36803":["thread",36803],"thread-36802":["thread",36802],"thread-36801":["thread",36801],"thread-36800":["thread",36800],"thread-36799":["thread",36799],"thread-36798":["thread",36798],"thread-36797":["thread",36797],"thread-36795":["thread",36795],"thread-36794":["thread",36794],"thread-36793":["thread",36793],"thread-36792":["thread",36792],"thread-36791":["thread",36791],"thread-36790":["thread",36790],"thread-36789":["thread",36789],"thread-36788":["thread",36788],"thread-36787":["thread",36787],"thread-36786":["thread",36786],"thread-36785":["thread",36785],"thread-36784":["thread",36784],"thread-36783":["thread",36783],"thread-36782":["thread",36782],"thread-36781":["thread",36781],"thread-36780":["thread",36780],"thread-36779":["thread",36779],"thread-36778":["thread",36778],"thread-36777":["thread",36777],"thread-36776":["thread",36776],"thread-36775":["thread",36775],"thread-36774":["thread",36774],"thread-36773":["thread",36773],"thread-36772":["thread",36772],"thread-36771":["thread",36771],"thread-36770":["thread",36770],"thread-36769":["thread",36769],"thread-36768":["thread",36768],"thread-36767":["thread",36767],"thread-36766":["thread",36766],"thread-36765":["thread",36765],"thread-36764":["thread",36764],"thread-36763":["thread",36763],"thread-36762":["thread",36762],"thread-36761":["thread",36761],"thread-36760":["thread",36760],"thread-36759":["thread",36759],"thread-36758":["thread",36758],"thread-36756":["thread",36756],"thread-36755":["thread",36755],"thread-36754":["thread",36754],"thread-36753":["thread",36753],"thread-36752":["thread",36752],"thread-36751":["thread",36751],"thread-36750":["thread",36750],"thread-36749":["thread",36749],"thread-36748":["thread",36748],"thread-36747":["thread",36747],"thread-36746":["thread",36746],"thread-36745":["thread",36745],"thread-36744":["thread",36744],"thread-36743":["thread",36743],"thread-36742":["thread",36742],"thread-36741":["thread",36741],"thread-36740":["thread",36740],"thread-36739":["thread",36739],"thread-36738":["thread",36738],"thread-36737":["thread",36737],"thread-36736":["thread",36736],"thread-36735":["thread",36735],"thread-36734":["thread",36734],"thread-36733":["thread",36733],"thread-36732":["thread",36732],"thread-36731":["thread",36731],"thread-36730":["thread",36730],"thread-36729":["thread",36729],"thread-36728":["thread",36728],"thread-36727":["thread",36727],"thread-36726":["thread",36726],"thread-36725":["thread",36725],"thread-36724":["thread",36724],"thread-36723":["thread",36723],"thread-36722":["thread",36722],"thread-36721":["thread",36721],"thread-36720":["thread",36720],"thread-36718":["thread",36718],"thread-36717":["thread",36717],"thread-36716":["thread",36716],"thread-36715":["thread",36715],"thread-36714":["thread",36714],"thread-36713":["thread",36713],"thread-36712":["thread",36712],"thread-36711":["thread",36711],"thread-36710":["thread",36710],"thread-36709":["thread",36709],"thread-36708":["thread",36708],"thread-36707":["thread",36707],"thread-36706":["thread",36706],"thread-36705":["thread",36705],"thread-36704":["thread",36704],"thread-36703":["thread",36703],"thread-36702":["thread",36702],"thread-36701":["thread",36701],"thread-36700":["thread",36700],"thread-36699":["thread",36699],"thread-36698":["thread",36698],"thread-36697":["thread",36697],"thread-36695":["thread",36695],"thread-36694":["thread",36694],"thread-36693":["thread",36693],"thread-36692":["thread",36692],"thread-36691":["thread",36691],"thread-36690":["thread",36690],"thread-36689":["thread",36689],"thread-36688":["thread",36688],"thread-36687":["thread",36687],"thread-36686":["thread",36686],"thread-36685":["thread",36685],"thread-36684":["thread",36684],"thread-36683":["thread",36683],"thread-36682":["thread",36682],"thread-36681":["thread",36681],"thread-36680":["thread",36680],"thread-36679":["thread",36679],"thread-36678":["thread",36678],"thread-36677":["thread",36677],"thread-36676":["thread",36676],"thread-36675":["thread",36675],"thread-36674":["thread",36674],"thread-36673":["thread",36673],"thread-36672":["thread",36672],"thread-36671":["thread",36671],"thread-36670":["thread",36670],"thread-36669":["thread",36669],"thread-36668":["thread",36668],"thread-36666":["thread",36666],"thread-36665":["thread",36665],"thread-36664":["thread",36664],"thread-36663":["thread",36663],"thread-36662":["thread",36662],"thread-36661":["thread",36661]}, , 1715658757
Run Time: 0.000921
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 220
- XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1512
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1244
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 150
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2345
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20