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 (7215177, 7173722, 7097156, 7086139, 7085812, 7033185, 6967177, 205920, 199884, 160331, 13428, 13137, 13136, 13085, 12978, 11906, 11696, 11158, 11067, 10288, 10270, 10121, 10089, 9866, 9739, 9394, 9333, 9250, 9077, 8718, 8399, 8388, 8218, 7936, 7428, 7229, 7104, 6911, 6870, 6799, 6366, 6295, 6289, 6248, 6179, 6082, 5932, 5859, 5704, 5254, 4121, 4105, 4103, 3995, 3907, 3769, 3404, 3326, 3116, 2422, 2091, 2035, 1929, 1906, 1729, 1718, 1562, 1496, 1266, 1205, 1131, 1072, 933, 872, 601, 465, 296))
Run Time: 0.007755
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 77 | 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: 300, 0, 1715226590, {"thread-7215177":["thread",7215177],"thread-7173722":["thread",7173722],"thread-7097156":["thread",7097156],"thread-7086139":["thread",7086139],"thread-7085812":["thread",7085812],"thread-7033185":["thread",7033185],"thread-6967177":["thread",6967177],"thread-205920":["thread",205920],"thread-199884":["thread",199884],"thread-160331":["thread",160331],"thread-13428":["thread",13428],"thread-13137":["thread",13137],"thread-13136":["thread",13136],"thread-13085":["thread",13085],"thread-12978":["thread",12978],"thread-11906":["thread",11906],"thread-11696":["thread",11696],"thread-11158":["thread",11158],"thread-11067":["thread",11067],"thread-10288":["thread",10288],"thread-10270":["thread",10270],"thread-10121":["thread",10121],"thread-10089":["thread",10089],"thread-9866":["thread",9866],"thread-9739":["thread",9739],"thread-9394":["thread",9394],"thread-9333":["thread",9333],"thread-9250":["thread",9250],"thread-9077":["thread",9077],"thread-8718":["thread",8718],"thread-8399":["thread",8399],"thread-8388":["thread",8388],"thread-8218":["thread",8218],"thread-7936":["thread",7936],"thread-7428":["thread",7428],"thread-7229":["thread",7229],"thread-7104":["thread",7104],"thread-6911":["thread",6911],"thread-6870":["thread",6870],"thread-6799":["thread",6799],"thread-6366":["thread",6366],"thread-6295":["thread",6295],"thread-6289":["thread",6289],"thread-6248":["thread",6248],"thread-6179":["thread",6179],"thread-6082":["thread",6082],"thread-5932":["thread",5932],"thread-5859":["thread",5859],"thread-5704":["thread",5704],"thread-5254":["thread",5254],"thread-4121":["thread",4121],"thread-4105":["thread",4105],"thread-4103":["thread",4103],"thread-3995":["thread",3995],"thread-3907":["thread",3907],"thread-3769":["thread",3769],"thread-3404":["thread",3404],"thread-3326":["thread",3326],"thread-3116":["thread",3116],"thread-2422":["thread",2422],"thread-2091":["thread",2091],"thread-2035":["thread",2035],"thread-1929":["thread",1929],"thread-1906":["thread",1906],"thread-1729":["thread",1729],"thread-1718":["thread",1718],"thread-1562":["thread",1562],"thread-1496":["thread",1496],"thread-1266":["thread",1266],"thread-1205":["thread",1205],"thread-1131":["thread",1131],"thread-1072":["thread",1072],"thread-933":["thread",933],"thread-872":["thread",872],"thread-601":["thread",601],"thread-465":["thread",465],"thread-296":["thread",296]}, NULL, 1715222990
Run Time: 0.002117
- 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