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 (177347, 167758, 165293, 165219, 151289, 139885, 137756, 130528, 129908, 128310, 124287, 123114, 113181, 105767, 105441, 104931, 103154, 102952, 89154, 84837, 83030, 72431, 70818, 69689, 68549, 51125, 47447, 47205, 46111, 45972, 45071, 44724, 44634, 43967, 43966, 43702, 43426, 43397, 43057, 42269, 42094, 39698, 39678, 38191, 36161, 34699, 34698, 34559, 32804, 27476, 27384, 10461, 7338))
Run Time: 0.029238
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 53 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,admin_xen.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 1387
- 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 2729
- 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 137
- 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 2351
- XF\App->run() in src/XF.php at line 517
- 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: 1360, 0, 1715949120, {"thread-177347":["thread",177347],"ams_article-4982":["ams_article",4982],"thread-167758":["thread",167758],"thread-165293":["thread",165293],"thread-165219":["thread",165219],"ams_article-4540":["ams_article",4540],"thread-151289":["thread",151289],"thread-139885":["thread",139885],"thread-137756":["thread",137756],"thread-130528":["thread",130528],"thread-129908":["thread",129908],"thread-128310":["thread",128310],"thread-124287":["thread",124287],"thread-123114":["thread",123114],"thread-113181":["thread",113181],"thread-105767":["thread",105767],"thread-105441":["thread",105441],"thread-104931":["thread",104931],"thread-103154":["thread",103154],"thread-102952":["thread",102952],"thread-89154":["thread",89154],"thread-84837":["thread",84837],"thread-83030":["thread",83030],"thread-72431":["thread",72431],"thread-70818":["thread",70818],"thread-69689":["thread",69689],"thread-68549":["thread",68549],"thread-51125":["thread",51125],"thread-47447":["thread",47447],"thread-47205":["thread",47205],"thread-46111":["thread",46111],"thread-45972":["thread",45972],"thread-45071":["thread",45071],"thread-44724":["thread",44724],"thread-44634":["thread",44634],"thread-43967":["thread",43967],"thread-43966":["thread",43966],"thread-43702":["thread",43702],"thread-43426":["thread",43426],"thread-43397":["thread",43397],"thread-43057":["thread",43057],"thread-42269":["thread",42269],"thread-42094":["thread",42094],"thread-39698":["thread",39698],"thread-39678":["thread",39678],"thread-38191":["thread",38191],"thread-36161":["thread",36161],"thread-34699":["thread",34699],"thread-34698":["thread",34698],"thread-34559":["thread",34559],"thread-32804":["thread",32804],"thread-27476":["thread",27476],"thread-27384":["thread",27384],"thread-10461":["thread",10461],"thread-7338":["thread",7338]}, , 1715945520
Run Time: 0.000903
- 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 1514
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1246
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 150
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20