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 (7205247, 7180632, 7168927, 7136609, 7134892, 7131917, 7091691, 7082998, 7005531, 242672, 165060, 162510, 156947, 13793, 13360, 13216, 13193, 13171, 12496, 12315, 12185, 11930, 11093, 11060, 10167, 9861, 9840, 9210, 8651, 8550, 8271, 8194, 8106, 7673, 7457, 6917, 6879, 6478, 6140, 5657, 5291, 4516, 4057, 3937, 3918, 3478, 2897, 2083, 1600, 1392, 841, 417, 261))
Run Time: 0.005909
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 53 | 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: 232, 0, 1713947036, {"thread-7205247":["thread",7205247],"thread-7180632":["thread",7180632],"thread-7168927":["thread",7168927],"thread-7136609":["thread",7136609],"thread-7134892":["thread",7134892],"thread-7131917":["thread",7131917],"thread-7091691":["thread",7091691],"thread-7082998":["thread",7082998],"thread-7005531":["thread",7005531],"thread-242672":["thread",242672],"thread-165060":["thread",165060],"thread-162510":["thread",162510],"thread-156947":["thread",156947],"thread-13793":["thread",13793],"thread-13360":["thread",13360],"thread-13216":["thread",13216],"thread-13193":["thread",13193],"thread-13171":["thread",13171],"thread-12496":["thread",12496],"thread-12315":["thread",12315],"thread-12185":["thread",12185],"thread-11930":["thread",11930],"thread-11093":["thread",11093],"thread-11060":["thread",11060],"thread-10167":["thread",10167],"thread-9861":["thread",9861],"thread-9840":["thread",9840],"thread-9210":["thread",9210],"thread-8651":["thread",8651],"thread-8550":["thread",8550],"thread-8271":["thread",8271],"thread-8194":["thread",8194],"thread-8106":["thread",8106],"thread-7673":["thread",7673],"thread-7457":["thread",7457],"thread-6917":["thread",6917],"thread-6879":["thread",6879],"thread-6478":["thread",6478],"thread-6140":["thread",6140],"thread-5657":["thread",5657],"thread-5291":["thread",5291],"thread-4516":["thread",4516],"thread-4057":["thread",4057],"thread-3937":["thread",3937],"thread-3918":["thread",3918],"thread-3478":["thread",3478],"thread-2897":["thread",2897],"thread-2083":["thread",2083],"thread-1600":["thread",1600],"thread-1392":["thread",1392],"thread-841":["thread",841],"thread-417":["thread",417],"thread-261":["thread",261]}, NULL, 1713943436
Run Time: 0.000474
- 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