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 (7209610, 7203316, 7200820, 7200004, 7198036, 7197838, 7196444, 7195168, 7195146, 7191769, 7188922, 7187477, 7187090, 7185729, 7180879, 7180419, 7179895, 7179894, 7177953, 7177588, 7177404, 7170486, 7169140, 7168563, 7167656, 7167411, 7164803, 7156791, 7153934, 7146590, 7143455, 7138569, 7136610, 7134545, 7133314, 7133208, 7129741, 7127768, 7127394, 7125307, 7120008, 7098509, 7098289, 7097885, 7092851, 7092746, 7090677, 7089279, 7083220, 7075803, 7073283, 7072748, 7068522, 7068464, 7066207, 7065054, 7064089, 7051006, 7047578, 7038445, 7038411, 7037909, 7028512, 7000992, 6983649, 6979013, 6978507, 6975360, 6438640, 195987, 193842, 178539, 9118, 6367, 3844))
Run Time: 0.007471
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 75 | 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: 3656, 0, 1714315104, {"thread-7209610":["thread",7209610],"thread-7203316":["thread",7203316],"thread-7200820":["thread",7200820],"thread-7200004":["thread",7200004],"thread-7198036":["thread",7198036],"thread-7197838":["thread",7197838],"thread-7196444":["thread",7196444],"thread-7195168":["thread",7195168],"thread-7195146":["thread",7195146],"thread-7191769":["thread",7191769],"thread-7188922":["thread",7188922],"thread-7187477":["thread",7187477],"thread-7187090":["thread",7187090],"thread-7185729":["thread",7185729],"thread-7180879":["thread",7180879],"thread-7180419":["thread",7180419],"thread-7179895":["thread",7179895],"thread-7179894":["thread",7179894],"thread-7177953":["thread",7177953],"thread-7177588":["thread",7177588],"thread-7177404":["thread",7177404],"thread-7170486":["thread",7170486],"thread-7169140":["thread",7169140],"thread-7168563":["thread",7168563],"thread-7167656":["thread",7167656],"thread-7167411":["thread",7167411],"thread-7164803":["thread",7164803],"thread-7156791":["thread",7156791],"thread-7153934":["thread",7153934],"thread-7146590":["thread",7146590],"thread-7143455":["thread",7143455],"thread-7138569":["thread",7138569],"thread-7136610":["thread",7136610],"thread-7134545":["thread",7134545],"thread-7133314":["thread",7133314],"thread-7133208":["thread",7133208],"thread-7129741":["thread",7129741],"thread-7127768":["thread",7127768],"thread-7127394":["thread",7127394],"thread-7125307":["thread",7125307],"thread-7120008":["thread",7120008],"thread-7098509":["thread",7098509],"thread-7098289":["thread",7098289],"thread-7097885":["thread",7097885],"thread-7092851":["thread",7092851],"thread-7092746":["thread",7092746],"thread-7090677":["thread",7090677],"thread-7089279":["thread",7089279],"thread-7083220":["thread",7083220],"thread-7075803":["thread",7075803],"thread-7073283":["thread",7073283],"thread-7072748":["thread",7072748],"thread-7068522":["thread",7068522],"thread-7068464":["thread",7068464],"thread-7066207":["thread",7066207],"thread-7065054":["thread",7065054],"thread-7064089":["thread",7064089],"thread-7051006":["thread",7051006],"thread-7047578":["thread",7047578],"thread-7038445":["thread",7038445],"thread-7038411":["thread",7038411],"thread-7037909":["thread",7037909],"thread-7028512":["thread",7028512],"thread-7000992":["thread",7000992],"thread-6983649":["thread",6983649],"thread-6979013":["thread",6979013],"thread-6978507":["thread",6978507],"thread-6975360":["thread",6975360],"thread-6438640":["thread",6438640],"thread-195987":["thread",195987],"thread-178539":["thread",178539],"thread-9118":["thread",9118],"thread-6367":["thread",6367],"thread-3844":["thread",3844]}, NULL, 1714311504
Run Time: 0.000354
- 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