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 (7214689, 7209508, 7198543, 7193827, 7192926, 7190792, 7190338, 7190222, 7185217, 7180978, 7178238, 7177686, 7177592, 7176983, 7176689, 7175890, 7174312, 7173851, 7168932, 7168536, 7165618, 7163894, 7161429, 7158524, 7154022, 7152188, 7151200, 7141698, 7138661, 7137379, 7137028, 7136911, 7129449, 7129108, 7120461, 7120063, 7118490, 7112776, 7112557, 7111834, 7108516, 7106223, 7096561, 7091080, 7088162, 7084978, 7061623, 7048862, 7036002, 7034952, 7024946, 7016196, 6983349, 6975239, 6973808, 174450))
Run Time: 0.004804
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: 8738, 0, 1714672841, {"thread-7214689":["thread",7214689],"thread-7209508":["thread",7209508],"thread-7198543":["thread",7198543],"thread-7193827":["thread",7193827],"thread-7192926":["thread",7192926],"thread-7190792":["thread",7190792],"thread-7190338":["thread",7190338],"thread-7190222":["thread",7190222],"thread-7185217":["thread",7185217],"thread-7180978":["thread",7180978],"thread-7178238":["thread",7178238],"thread-7177686":["thread",7177686],"thread-7177592":["thread",7177592],"thread-7176983":["thread",7176983],"thread-7176689":["thread",7176689],"thread-7175890":["thread",7175890],"thread-7174312":["thread",7174312],"thread-7173851":["thread",7173851],"thread-7168932":["thread",7168932],"thread-7168536":["thread",7168536],"thread-7165618":["thread",7165618],"thread-7163894":["thread",7163894],"thread-7161429":["thread",7161429],"thread-7158524":["thread",7158524],"thread-7154022":["thread",7154022],"thread-7152188":["thread",7152188],"thread-7151200":["thread",7151200],"thread-7141698":["thread",7141698],"thread-7138661":["thread",7138661],"thread-7137379":["thread",7137379],"thread-7137028":["thread",7137028],"thread-7136911":["thread",7136911],"thread-7129449":["thread",7129449],"thread-7129108":["thread",7129108],"thread-7120461":["thread",7120461],"thread-7120063":["thread",7120063],"thread-7118490":["thread",7118490],"thread-7112776":["thread",7112776],"thread-7112557":["thread",7112557],"thread-7111834":["thread",7111834],"thread-7108516":["thread",7108516],"thread-7106223":["thread",7106223],"thread-7096561":["thread",7096561],"thread-7091080":["thread",7091080],"thread-7088162":["thread",7088162],"thread-7084978":["thread",7084978],"thread-7061623":["thread",7061623],"thread-7048862":["thread",7048862],"thread-7036002":["thread",7036002],"thread-7034952":["thread",7034952],"thread-7024946":["thread",7024946],"thread-7016196":["thread",7016196],"thread-6983349":["thread",6983349],"thread-6975239":["thread",6975239],"thread-6973808":["thread",6973808],"thread-174450":["thread",174450]}, NULL, 1714669241
Run Time: 0.000338
- 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