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 (7203616, 7168536, 7167032, 7152409, 7140899, 7132989, 7117793, 7084927, 7084531, 7017776, 7005646, 6996751, 6996332, 6987413, 6987322, 6985187, 6978653, 6976122, 6972139, 6968338, 218241, 204876, 173649, 167662, 165396, 160425, 13821, 13737, 13705, 13535, 13444, 13436, 13097, 12993, 12811, 12708, 12661, 12457, 12319, 12198, 12093, 11344, 11184, 10915, 10911, 10400, 10258, 10047, 9543, 9475, 9353, 9313, 8699, 8691, 8537, 8468, 8271, 8232, 8221, 8151, 8122, 8063, 7564, 6977, 6883, 6569, 6478, 6417, 6169, 6012, 5722, 5573, 5499, 5138, 5123, 5045, 5022, 4704, 4588, 4536, 4092, 3937, 3926, 3918, 3835, 3822, 3704, 3631, 3536, 3500, 3350, 3224, 3098, 2945, 2938, 2879, 2864, 2791, 2754, 2440, 2376, 2016, 1850, 1781, 1589, 1526, 1490, 1405, 1014, 776, 417, 114))
Run Time: 0.006851
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 112 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,production_xf.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 1430
- 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 2870
- 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 138
- 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 2487
- XF\App->run() in src/XF.php at line 524
- 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: 81, 0, 1714857650, {"thread-7203616":["thread",7203616],"thread-7168536":["thread",7168536],"thread-7167032":["thread",7167032],"thread-7152409":["thread",7152409],"thread-7140899":["thread",7140899],"thread-7132989":["thread",7132989],"thread-7117793":["thread",7117793],"thread-7084927":["thread",7084927],"thread-7084531":["thread",7084531],"thread-7017776":["thread",7017776],"thread-7005646":["thread",7005646],"thread-6996751":["thread",6996751],"thread-6996332":["thread",6996332],"thread-6987413":["thread",6987413],"thread-6987322":["thread",6987322],"thread-6985187":["thread",6985187],"thread-6978653":["thread",6978653],"thread-6976122":["thread",6976122],"thread-6972139":["thread",6972139],"thread-6968338":["thread",6968338],"thread-218241":["thread",218241],"thread-204876":["thread",204876],"thread-173649":["thread",173649],"thread-167662":["thread",167662],"thread-165396":["thread",165396],"thread-160425":["thread",160425],"thread-13821":["thread",13821],"thread-13737":["thread",13737],"thread-13705":["thread",13705],"thread-13535":["thread",13535],"thread-13444":["thread",13444],"thread-13436":["thread",13436],"thread-13097":["thread",13097],"thread-12993":["thread",12993],"thread-12811":["thread",12811],"thread-12708":["thread",12708],"thread-12661":["thread",12661],"thread-12457":["thread",12457],"thread-12319":["thread",12319],"thread-12198":["thread",12198],"thread-12093":["thread",12093],"thread-11344":["thread",11344],"thread-11184":["thread",11184],"thread-10915":["thread",10915],"thread-10911":["thread",10911],"thread-10400":["thread",10400],"thread-10258":["thread",10258],"thread-10047":["thread",10047],"thread-9543":["thread",9543],"thread-9475":["thread",9475],"thread-9353":["thread",9353],"thread-9313":["thread",9313],"thread-8699":["thread",8699],"thread-8691":["thread",8691],"thread-8537":["thread",8537],"thread-8468":["thread",8468],"thread-8271":["thread",8271],"thread-8232":["thread",8232],"thread-8221":["thread",8221],"thread-8151":["thread",8151],"thread-8122":["thread",8122],"thread-8063":["thread",8063],"thread-7564":["thread",7564],"thread-6977":["thread",6977],"thread-6883":["thread",6883],"thread-6569":["thread",6569],"thread-6478":["thread",6478],"thread-6417":["thread",6417],"thread-6169":["thread",6169],"thread-6012":["thread",6012],"thread-5722":["thread",5722],"thread-5573":["thread",5573],"thread-5499":["thread",5499],"thread-5138":["thread",5138],"thread-5123":["thread",5123],"thread-5045":["thread",5045],"thread-5022":["thread",5022],"thread-4704":["thread",4704],"thread-4588":["thread",4588],"thread-4536":["thread",4536],"thread-4092":["thread",4092],"thread-3937":["thread",3937],"thread-3926":["thread",3926],"thread-3918":["thread",3918],"thread-3835":["thread",3835],"thread-3822":["thread",3822],"thread-3704":["thread",3704],"thread-3631":["thread",3631],"thread-3536":["thread",3536],"thread-3500":["thread",3500],"thread-3350":["thread",3350],"thread-3224":["thread",3224],"thread-3098":["thread",3098],"thread-2945":["thread",2945],"thread-2938":["thread",2938],"thread-2879":["thread",2879],"thread-2864":["thread",2864],"thread-2791":["thread",2791],"thread-2754":["thread",2754],"thread-2440":["thread",2440],"thread-2376":["thread",2376],"thread-2016":["thread",2016],"thread-1850":["thread",1850],"thread-1781":["thread",1781],"thread-1589":["thread",1589],"thread-1526":["thread",1526],"thread-1490":["thread",1490],"thread-1405":["thread",1405],"thread-1014":["thread",1014],"thread-776":["thread",776],"thread-417":["thread",417],"thread-114":["thread",114]}, NULL, 1714854050
Run Time: 0.000467
- 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 1521
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1253
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 151
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20