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 (13693, 13520, 13419, 13235, 13062, 12642, 12143, 11843, 10973, 10969, 10754, 10652, 10637, 10127, 9819, 9787, 9742, 8758, 8104, 8103, 8057, 8056, 7508, 7421, 6962, 6947, 6504, 6424, 6233, 6209, 6121, 5938, 5542, 5007, 4995, 4953, 4818, 4505, 4473, 4323, 4262, 4055, 3666, 3665, 3356, 3113, 3111, 2876, 2858, 2815, 2491, 2374, 2269, 1858, 1764, 1342, 1139, 866, 531))
Run Time: 0.005239
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 59 | 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: 606, 0, 1716279912, {"thread-13693":["thread",13693],"thread-13520":["thread",13520],"thread-13419":["thread",13419],"thread-13235":["thread",13235],"thread-13062":["thread",13062],"thread-12642":["thread",12642],"thread-12143":["thread",12143],"thread-11843":["thread",11843],"thread-10973":["thread",10973],"thread-10969":["thread",10969],"thread-10754":["thread",10754],"thread-10652":["thread",10652],"thread-10637":["thread",10637],"thread-10127":["thread",10127],"thread-9819":["thread",9819],"thread-9787":["thread",9787],"thread-9742":["thread",9742],"thread-8758":["thread",8758],"thread-8104":["thread",8104],"thread-8103":["thread",8103],"thread-8057":["thread",8057],"thread-8056":["thread",8056],"thread-7508":["thread",7508],"thread-7421":["thread",7421],"thread-6962":["thread",6962],"thread-6947":["thread",6947],"thread-6504":["thread",6504],"thread-6424":["thread",6424],"thread-6233":["thread",6233],"thread-6209":["thread",6209],"thread-6121":["thread",6121],"thread-5938":["thread",5938],"thread-5542":["thread",5542],"thread-5007":["thread",5007],"thread-4995":["thread",4995],"thread-4953":["thread",4953],"thread-4818":["thread",4818],"thread-4505":["thread",4505],"thread-4473":["thread",4473],"thread-4323":["thread",4323],"thread-4262":["thread",4262],"thread-4055":["thread",4055],"thread-3666":["thread",3666],"thread-3665":["thread",3665],"thread-3356":["thread",3356],"thread-3113":["thread",3113],"thread-3111":["thread",3111],"thread-2876":["thread",2876],"thread-2815":["thread",2815],"thread-2491":["thread",2491],"thread-2374":["thread",2374],"thread-2269":["thread",2269],"thread-1858":["thread",1858],"thread-1764":["thread",1764],"thread-1342":["thread",1342],"thread-1139":["thread",1139],"thread-866":["thread",866],"thread-531":["thread",531]}, NULL, 1716276312
Run Time: 0.000345
- 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