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 (7151720, 7137423, 7130935, 7130922, 7130919, 7130917, 7130808, 7130128, 7129987, 7129976, 7129741, 7129106, 7129005, 7129002, 7127590, 7127588, 7127553, 7109904, 7096677, 7070815, 7049809, 7046105, 7044316, 7025431, 7022532, 6789130, 234496, 226440, 209138, 203450, 201917, 188724, 172554, 172553, 165423, 160699, 13792, 13603, 12912, 12683, 11372, 11199, 10749, 9386, 6724, 5535, 4880, 4118, 2978, 1655, 1530, 1366, 889, 731, 623, 411))
Run Time: 0.005749
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 56 | 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: 460, 0, 1714929287, {"thread-7151720":["thread",7151720],"thread-7137423":["thread",7137423],"thread-7130935":["thread",7130935],"thread-7130922":["thread",7130922],"thread-7130919":["thread",7130919],"thread-7130917":["thread",7130917],"thread-7130808":["thread",7130808],"thread-7130128":["thread",7130128],"thread-7129987":["thread",7129987],"thread-7129976":["thread",7129976],"thread-7129741":["thread",7129741],"thread-7129106":["thread",7129106],"thread-7129005":["thread",7129005],"thread-7129002":["thread",7129002],"thread-7127590":["thread",7127590],"thread-7127588":["thread",7127588],"thread-7127553":["thread",7127553],"thread-7109904":["thread",7109904],"thread-7096677":["thread",7096677],"thread-7070815":["thread",7070815],"thread-7049809":["thread",7049809],"thread-7046105":["thread",7046105],"thread-7044316":["thread",7044316],"thread-7025431":["thread",7025431],"thread-7022532":["thread",7022532],"thread-6789130":["thread",6789130],"thread-234496":["thread",234496],"thread-226440":["thread",226440],"thread-209138":["thread",209138],"thread-203450":["thread",203450],"thread-201917":["thread",201917],"thread-188724":["thread",188724],"thread-172554":["thread",172554],"thread-172553":["thread",172553],"thread-165423":["thread",165423],"thread-160699":["thread",160699],"thread-13792":["thread",13792],"thread-13603":["thread",13603],"thread-12912":["thread",12912],"thread-12683":["thread",12683],"thread-11372":["thread",11372],"thread-11199":["thread",11199],"thread-10749":["thread",10749],"thread-9386":["thread",9386],"thread-6724":["thread",6724],"thread-5535":["thread",5535],"thread-4880":["thread",4880],"thread-4118":["thread",4118],"thread-2978":["thread",2978],"thread-1655":["thread",1655],"thread-1530":["thread",1530],"thread-1366":["thread",1366],"thread-889":["thread",889],"thread-731":["thread",731],"thread-623":["thread",623],"thread-411":["thread",411]}, NULL, 1714925687
Run Time: 0.000465
- 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