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 (7216470, 7215095, 7215085, 7211325, 7210941, 7209255, 7208796, 7207316, 7205585, 7193362, 7192147, 7188665, 7187402, 7185888, 7179992, 7179749, 7168042, 7167656, 7166880, 7165759, 7165301, 7165128, 7164803, 7159713, 7158936, 7156333, 7146590, 7146018, 7142159, 7140420, 7137027, 7135401, 7128783, 7114190, 7110811, 7108953, 7106278, 7104371, 7103016, 7102812, 7099312, 7090635, 7089928, 7089802, 7088778, 7085692, 7082904, 7082845, 7082297, 7081479, 7080909, 7077928, 7074549, 7067351, 7066812, 7061539, 7055584, 7047596, 7025265, 7010783, 6993931, 6986903, 232007, 188198, 174883, 8780, 7734, 6822, 5521, 5311, 4116, 1930, 1786, 1213, 516, 350))
Run Time: 0.004798
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 76 | 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: 358, 0, 1716159476, {"thread-7216470":["thread",7216470],"thread-7215095":["thread",7215095],"thread-7215085":["thread",7215085],"thread-7211325":["thread",7211325],"thread-7210941":["thread",7210941],"thread-7209255":["thread",7209255],"thread-7208796":["thread",7208796],"thread-7207316":["thread",7207316],"thread-7205585":["thread",7205585],"thread-7193362":["thread",7193362],"thread-7192147":["thread",7192147],"thread-7188665":["thread",7188665],"thread-7187402":["thread",7187402],"thread-7185888":["thread",7185888],"thread-7179992":["thread",7179992],"thread-7179749":["thread",7179749],"thread-7168042":["thread",7168042],"thread-7167656":["thread",7167656],"thread-7166880":["thread",7166880],"thread-7165759":["thread",7165759],"thread-7165301":["thread",7165301],"thread-7165128":["thread",7165128],"thread-7164803":["thread",7164803],"thread-7159713":["thread",7159713],"thread-7158936":["thread",7158936],"thread-7156333":["thread",7156333],"thread-7146590":["thread",7146590],"thread-7146018":["thread",7146018],"thread-7142159":["thread",7142159],"thread-7140420":["thread",7140420],"thread-7137027":["thread",7137027],"thread-7135401":["thread",7135401],"thread-7128783":["thread",7128783],"thread-7114190":["thread",7114190],"thread-7110811":["thread",7110811],"thread-7108953":["thread",7108953],"thread-7106278":["thread",7106278],"thread-7104371":["thread",7104371],"thread-7103016":["thread",7103016],"thread-7102812":["thread",7102812],"thread-7099312":["thread",7099312],"thread-7090635":["thread",7090635],"thread-7089928":["thread",7089928],"thread-7089802":["thread",7089802],"thread-7088778":["thread",7088778],"thread-7085692":["thread",7085692],"thread-7082904":["thread",7082904],"thread-7082845":["thread",7082845],"thread-7082297":["thread",7082297],"thread-7081479":["thread",7081479],"thread-7080909":["thread",7080909],"thread-7077928":["thread",7077928],"thread-7074549":["thread",7074549],"thread-7067351":["thread",7067351],"thread-7066812":["thread",7066812],"thread-7061539":["thread",7061539],"thread-7055584":["thread",7055584],"thread-7047596":["thread",7047596],"thread-7025265":["thread",7025265],"thread-7010783":["thread",7010783],"thread-6993931":["thread",6993931],"thread-6986903":["thread",6986903],"thread-232007":["thread",232007],"thread-188198":["thread",188198],"thread-174883":["thread",174883],"thread-8780":["thread",8780],"thread-7734":["thread",7734],"thread-6822":["thread",6822],"thread-5521":["thread",5521],"thread-5311":["thread",5311],"thread-4116":["thread",4116],"thread-1930":["thread",1930],"thread-1786":["thread",1786],"thread-1213":["thread",1213],"thread-516":["thread",516],"thread-350":["thread",350]}, NULL, 1716155876
Run Time: 0.000451
- 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