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 (7108685, 7086683, 7031100, 7020847, 13103, 13066, 12882, 12865, 12673, 12451, 12359, 12358, 12298, 11776, 11630, 11355, 11318, 11057, 10947, 10382, 10320, 10153, 9507, 9450, 9337, 9310, 9144, 9129, 8976, 8791, 7919, 7816, 7676, 7630, 7591, 7530, 7401, 7400, 7289, 7012, 6926, 6838, 6784, 6123, 6025, 6001, 5866, 5795, 5217, 5195, 4794, 4376, 4276, 4080, 3936, 3909, 3369, 3239, 3145, 2704, 2588, 2571, 2378, 2101, 1647, 1241, 1165, 846))
Run Time: 0.004835
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 68 | 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: 1010, 0, 1714805534, {"thread-7108685":["thread",7108685],"thread-7086683":["thread",7086683],"thread-7031100":["thread",7031100],"thread-7020847":["thread",7020847],"thread-13103":["thread",13103],"thread-13066":["thread",13066],"thread-12882":["thread",12882],"thread-12865":["thread",12865],"thread-12673":["thread",12673],"thread-12451":["thread",12451],"thread-12359":["thread",12359],"thread-12358":["thread",12358],"thread-12298":["thread",12298],"thread-11776":["thread",11776],"thread-11630":["thread",11630],"thread-11355":["thread",11355],"thread-11318":["thread",11318],"thread-11057":["thread",11057],"thread-10947":["thread",10947],"thread-10382":["thread",10382],"thread-10320":["thread",10320],"thread-10153":["thread",10153],"thread-9507":["thread",9507],"thread-9450":["thread",9450],"thread-9337":["thread",9337],"thread-9310":["thread",9310],"thread-9144":["thread",9144],"thread-9129":["thread",9129],"thread-8976":["thread",8976],"thread-8791":["thread",8791],"thread-7919":["thread",7919],"thread-7816":["thread",7816],"thread-7676":["thread",7676],"thread-7630":["thread",7630],"thread-7591":["thread",7591],"thread-7530":["thread",7530],"thread-7401":["thread",7401],"thread-7400":["thread",7400],"thread-7289":["thread",7289],"thread-7012":["thread",7012],"thread-6926":["thread",6926],"thread-6838":["thread",6838],"thread-6784":["thread",6784],"thread-6123":["thread",6123],"thread-6025":["thread",6025],"thread-6001":["thread",6001],"thread-5866":["thread",5866],"thread-5795":["thread",5795],"thread-5217":["thread",5217],"thread-5195":["thread",5195],"thread-4794":["thread",4794],"thread-4376":["thread",4376],"thread-4276":["thread",4276],"thread-4080":["thread",4080],"thread-3936":["thread",3936],"thread-3909":["thread",3909],"thread-3369":["thread",3369],"thread-3239":["thread",3239],"thread-3145":["thread",3145],"thread-2704":["thread",2704],"thread-2588":["thread",2588],"thread-2571":["thread",2571],"thread-2378":["thread",2378],"thread-2101":["thread",2101],"thread-1647":["thread",1647],"thread-1241":["thread",1241],"thread-1165":["thread",1165],"thread-846":["thread",846]}, NULL, 1714801934
Run Time: 0.000389
- 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