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 (7214498, 7214274, 7213096, 7207276, 7206590, 7206583, 7205200, 7204086, 7200465, 7199817, 7198710, 7198335, 7197397, 7196191, 7195624, 7195293, 7194069, 7193118, 7193090, 7192286, 7192217, 7191046, 7190194, 7189870, 7189356, 7153876, 7152318, 7147475, 7129982, 7127282, 7125479, 7124641, 7121278, 7114834, 7050609, 7031055, 7030370, 7028846, 7005641, 6979561, 6979036, 6960297, 164019, 13399, 13334, 12786, 11749, 11493, 10612, 6723, 3856, 1725, 1382, 602, 276))
Run Time: 0.004548
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 55 | 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: 262, 0, 1715062545, {"thread-7214498":["thread",7214498],"thread-7214274":["thread",7214274],"thread-7213096":["thread",7213096],"thread-7207276":["thread",7207276],"thread-7206590":["thread",7206590],"thread-7206583":["thread",7206583],"thread-7205200":["thread",7205200],"thread-7204086":["thread",7204086],"thread-7200465":["thread",7200465],"thread-7199817":["thread",7199817],"thread-7198710":["thread",7198710],"thread-7198335":["thread",7198335],"thread-7197397":["thread",7197397],"thread-7196191":["thread",7196191],"thread-7195624":["thread",7195624],"thread-7195293":["thread",7195293],"thread-7194069":["thread",7194069],"thread-7193118":["thread",7193118],"thread-7193090":["thread",7193090],"thread-7192286":["thread",7192286],"thread-7192217":["thread",7192217],"thread-7191046":["thread",7191046],"thread-7190194":["thread",7190194],"thread-7189870":["thread",7189870],"thread-7189356":["thread",7189356],"thread-7153876":["thread",7153876],"thread-7152318":["thread",7152318],"thread-7147475":["thread",7147475],"thread-7129982":["thread",7129982],"thread-7127282":["thread",7127282],"thread-7125479":["thread",7125479],"thread-7124641":["thread",7124641],"thread-7121278":["thread",7121278],"thread-7114834":["thread",7114834],"thread-7050609":["thread",7050609],"thread-7031055":["thread",7031055],"thread-7030370":["thread",7030370],"thread-7028846":["thread",7028846],"thread-7005641":["thread",7005641],"thread-6979561":["thread",6979561],"thread-6979036":["thread",6979036],"thread-6960297":["thread",6960297],"thread-164019":["thread",164019],"thread-13399":["thread",13399],"thread-13334":["thread",13334],"thread-12786":["thread",12786],"thread-11749":["thread",11749],"thread-11493":["thread",11493],"thread-10612":["thread",10612],"thread-6723":["thread",6723],"thread-3856":["thread",3856],"thread-1725":["thread",1725],"thread-1382":["thread",1382],"thread-602":["thread",602],"thread-276":["thread",276]}, NULL, 1715058945
Run Time: 0.000374
- 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