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 (7216417, 7159823, 7156842, 7101121, 7090030, 226953, 188310, 177665, 13807, 13615, 13603, 13504, 13311, 13287, 12594, 12345, 12296, 11953, 11652, 11535, 11387, 11159, 11007, 10851, 10793, 10782, 10753, 10687, 10666, 10029, 9714, 9620, 9593, 9537, 9461, 9356, 9329, 8438, 8258, 8228, 7989, 7842, 7629, 7362, 7295, 7025, 6943, 6534, 6043, 5753, 5644, 5399, 5226, 5201, 5135, 5108, 5050, 5020, 5008, 4956, 4757, 4666, 4483, 4433, 4413, 4192, 4086, 4078, 3987, 3705, 3698, 3595, 3169, 2997, 2916, 2894, 2771, 2750, 2522, 2278, 2039, 1800, 1776, 1509, 1457, 1266, 1180, 1124, 925, 873, 788, 368, 257))
Run Time: 0.006345
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 93 | 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: 222, 0, 1715076637, {"thread-7216417":["thread",7216417],"thread-7159823":["thread",7159823],"thread-7156842":["thread",7156842],"thread-7101121":["thread",7101121],"thread-7090030":["thread",7090030],"thread-226953":["thread",226953],"thread-188310":["thread",188310],"thread-177665":["thread",177665],"thread-13807":["thread",13807],"thread-13615":["thread",13615],"thread-13603":["thread",13603],"thread-13504":["thread",13504],"thread-13311":["thread",13311],"thread-13287":["thread",13287],"thread-12594":["thread",12594],"thread-12345":["thread",12345],"thread-12296":["thread",12296],"thread-11953":["thread",11953],"thread-11652":["thread",11652],"thread-11535":["thread",11535],"thread-11387":["thread",11387],"thread-11159":["thread",11159],"thread-11007":["thread",11007],"thread-10851":["thread",10851],"thread-10793":["thread",10793],"thread-10782":["thread",10782],"thread-10753":["thread",10753],"thread-10687":["thread",10687],"thread-10666":["thread",10666],"thread-10029":["thread",10029],"thread-9714":["thread",9714],"thread-9620":["thread",9620],"thread-9593":["thread",9593],"thread-9537":["thread",9537],"thread-9461":["thread",9461],"thread-9356":["thread",9356],"thread-9329":["thread",9329],"thread-8438":["thread",8438],"thread-8258":["thread",8258],"thread-8228":["thread",8228],"thread-7989":["thread",7989],"thread-7842":["thread",7842],"thread-7629":["thread",7629],"thread-7362":["thread",7362],"thread-7295":["thread",7295],"thread-7025":["thread",7025],"thread-6943":["thread",6943],"thread-6534":["thread",6534],"thread-6043":["thread",6043],"thread-5753":["thread",5753],"thread-5644":["thread",5644],"thread-5399":["thread",5399],"thread-5226":["thread",5226],"thread-5201":["thread",5201],"thread-5135":["thread",5135],"thread-5108":["thread",5108],"thread-5050":["thread",5050],"thread-5020":["thread",5020],"thread-5008":["thread",5008],"thread-4956":["thread",4956],"thread-4757":["thread",4757],"thread-4666":["thread",4666],"thread-4483":["thread",4483],"thread-4433":["thread",4433],"thread-4413":["thread",4413],"thread-4192":["thread",4192],"thread-4086":["thread",4086],"thread-4078":["thread",4078],"thread-3987":["thread",3987],"thread-3705":["thread",3705],"thread-3698":["thread",3698],"thread-3595":["thread",3595],"thread-3169":["thread",3169],"thread-2997":["thread",2997],"thread-2916":["thread",2916],"thread-2894":["thread",2894],"thread-2771":["thread",2771],"thread-2750":["thread",2750],"thread-2522":["thread",2522],"thread-2278":["thread",2278],"thread-2039":["thread",2039],"thread-1800":["thread",1800],"thread-1776":["thread",1776],"thread-1509":["thread",1509],"thread-1457":["thread",1457],"thread-1266":["thread",1266],"thread-1180":["thread",1180],"thread-1124":["thread",1124],"thread-925":["thread",925],"thread-873":["thread",873],"thread-788":["thread",788],"thread-368":["thread",368],"thread-257":["thread",257]}, NULL, 1715073037
Run Time: 0.000661
- 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