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 (7214573, 7203809, 7192627, 7178980, 7176673, 7174537, 7163894, 7160434, 7155417, 7155213, 7154962, 7152646, 7151056, 7150913, 7150232, 7134240, 7130966, 7128147, 7127956, 7123231, 7122752, 7122711, 7118483, 7113736, 7113198, 7109108, 7099245, 7098195, 7094310, 7093213, 7075323, 7074638, 7065707, 7064558, 7049323, 7043426, 7041906, 7037308, 7032573, 7021425, 7000575, 6989451, 6982081, 6979879, 6979648, 6969808, 6969650, 6963874, 241940, 220378, 186850, 174354))
Run Time: 0.004097
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 52 | 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: 8737, 0, 1714577241, {"thread-7214573":["thread",7214573],"thread-7203809":["thread",7203809],"thread-7192627":["thread",7192627],"thread-7178980":["thread",7178980],"thread-7176673":["thread",7176673],"thread-7174537":["thread",7174537],"thread-7163894":["thread",7163894],"thread-7160434":["thread",7160434],"thread-7155417":["thread",7155417],"thread-7155213":["thread",7155213],"thread-7154962":["thread",7154962],"thread-7152646":["thread",7152646],"thread-7151056":["thread",7151056],"thread-7150913":["thread",7150913],"thread-7150232":["thread",7150232],"thread-7134240":["thread",7134240],"thread-7130966":["thread",7130966],"thread-7128147":["thread",7128147],"thread-7127956":["thread",7127956],"thread-7123231":["thread",7123231],"thread-7122752":["thread",7122752],"thread-7122711":["thread",7122711],"thread-7118483":["thread",7118483],"thread-7113736":["thread",7113736],"thread-7113198":["thread",7113198],"thread-7109108":["thread",7109108],"thread-7099245":["thread",7099245],"thread-7098195":["thread",7098195],"thread-7094310":["thread",7094310],"thread-7093213":["thread",7093213],"thread-7075323":["thread",7075323],"thread-7074638":["thread",7074638],"thread-7065707":["thread",7065707],"thread-7064558":["thread",7064558],"thread-7049323":["thread",7049323],"thread-7043426":["thread",7043426],"thread-7041906":["thread",7041906],"thread-7037308":["thread",7037308],"thread-7032573":["thread",7032573],"thread-7021425":["thread",7021425],"thread-7000575":["thread",7000575],"thread-6989451":["thread",6989451],"thread-6982081":["thread",6982081],"thread-6979879":["thread",6979879],"thread-6979648":["thread",6979648],"thread-6969808":["thread",6969808],"thread-6969650":["thread",6969650],"thread-6963874":["thread",6963874],"thread-241940":["thread",241940],"thread-220378":["thread",220378],"thread-186850":["thread",186850],"thread-174354":["thread",174354]}, NULL, 1714573641
Run Time: 0.000461
- 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