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 (7217294, 7216752, 7216116, 7216029, 7215774, 7215577, 7215368, 7215342, 7211432, 7208003, 7200206, 7193822, 7182751, 7182240, 7181892, 7176517, 7175318, 7172273, 7169486, 7164237, 7156665, 7153922, 7149674, 7126251, 7122609, 7114313, 7114305, 7102432, 7071848, 7062301, 7035620, 7004961, 6996918, 6987632, 6983093, 6968557, 6962909, 6961143, 6959567, 6957586, 13496, 13451, 13438, 12821, 12209, 10420, 9385, 9050, 8733, 8644, 8625, 8590, 8587, 7433, 6676, 6140, 5309, 5129, 4733, 4590, 4198, 3853, 3722, 3576, 2942, 2529, 2061, 1885, 1226, 1125, 685, 419, 111))
Run Time: 0.006014
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 73 | 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: 71, 0, 1715964012, {"thread-7217294":["thread",7217294],"thread-7216752":["thread",7216752],"thread-7216116":["thread",7216116],"thread-7216029":["thread",7216029],"thread-7215774":["thread",7215774],"thread-7215577":["thread",7215577],"thread-7215368":["thread",7215368],"thread-7215342":["thread",7215342],"thread-7211432":["thread",7211432],"thread-7208003":["thread",7208003],"thread-7200206":["thread",7200206],"thread-7193822":["thread",7193822],"thread-7182751":["thread",7182751],"thread-7182240":["thread",7182240],"thread-7181892":["thread",7181892],"thread-7176517":["thread",7176517],"thread-7175318":["thread",7175318],"thread-7172273":["thread",7172273],"thread-7169486":["thread",7169486],"thread-7164237":["thread",7164237],"thread-7156665":["thread",7156665],"thread-7153922":["thread",7153922],"thread-7149674":["thread",7149674],"thread-7126251":["thread",7126251],"thread-7122609":["thread",7122609],"thread-7114313":["thread",7114313],"thread-7114305":["thread",7114305],"thread-7102432":["thread",7102432],"thread-7071848":["thread",7071848],"thread-7062301":["thread",7062301],"thread-7035620":["thread",7035620],"thread-7004961":["thread",7004961],"thread-6996918":["thread",6996918],"thread-6987632":["thread",6987632],"thread-6983093":["thread",6983093],"thread-6968557":["thread",6968557],"thread-6962909":["thread",6962909],"thread-6961143":["thread",6961143],"thread-6959567":["thread",6959567],"thread-6957586":["thread",6957586],"thread-13496":["thread",13496],"thread-13451":["thread",13451],"thread-13438":["thread",13438],"thread-12821":["thread",12821],"thread-12209":["thread",12209],"thread-10420":["thread",10420],"thread-9385":["thread",9385],"thread-9050":["thread",9050],"thread-8733":["thread",8733],"thread-8644":["thread",8644],"thread-8625":["thread",8625],"thread-8590":["thread",8590],"thread-8587":["thread",8587],"thread-7433":["thread",7433],"thread-6676":["thread",6676],"thread-6140":["thread",6140],"thread-5309":["thread",5309],"thread-5129":["thread",5129],"thread-4733":["thread",4733],"thread-4590":["thread",4590],"thread-4198":["thread",4198],"thread-3853":["thread",3853],"thread-3722":["thread",3722],"thread-3576":["thread",3576],"thread-2942":["thread",2942],"thread-2529":["thread",2529],"thread-2061":["thread",2061],"thread-1885":["thread",1885],"thread-1226":["thread",1226],"thread-1125":["thread",1125],"thread-685":["thread",685],"thread-419":["thread",419],"thread-111":["thread",111]}, NULL, 1715960412
Run Time: 0.000421
- 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