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 (172718, 172502, 165026, 155320, 153937, 153155, 151701, 151700, 151699, 146052, 142243, 142097, 140925, 140887, 131360, 131356, 130292, 130291, 130287, 129808, 123870, 123868, 123858, 122045, 120225, 120065, 119406, 119025, 114891, 113907, 113574, 111485, 109319, 109021, 104039, 104032, 104021, 103519, 102077, 101370, 98824, 76830, 76402, 76105, 75712, 75665, 75659, 75280, 75233, 75081, 74665, 74596, 74529, 74478, 74465, 74321, 73885, 73545, 73542, 71607, 71606, 71575, 71294, 68891, 66590, 63464, 63300, 62712, 62426, 62422, 62245, 61990, 61792, 60416, 60273, 59860, 58227, 58057, 51681, 51556, 51555, 50954, 50635, 50634))
Run Time: 0.048513
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 84 | 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: 7984, 0, 1714666268, {"thread-172718":["thread",172718],"thread-172502":["thread",172502],"thread-165026":["thread",165026],"thread-155320":["thread",155320],"thread-153937":["thread",153937],"thread-153155":["thread",153155],"thread-146052":["thread",146052],"thread-142243":["thread",142243],"ams_article-3282":["ams_article",3282],"thread-142097":["thread",142097],"thread-140925":["thread",140925],"thread-140887":["thread",140887],"thread-131360":["thread",131360],"thread-131356":["thread",131356],"thread-130292":["thread",130292],"thread-130291":["thread",130291],"thread-130287":["thread",130287],"thread-129808":["thread",129808],"thread-123870":["thread",123870],"thread-123868":["thread",123868],"thread-123858":["thread",123858],"thread-122045":["thread",122045],"thread-120225":["thread",120225],"thread-120065":["thread",120065],"thread-119406":["thread",119406],"thread-119025":["thread",119025],"thread-114891":["thread",114891],"thread-113907":["thread",113907],"thread-113574":["thread",113574],"thread-111485":["thread",111485],"thread-109319":["thread",109319],"thread-109021":["thread",109021],"thread-104039":["thread",104039],"thread-104032":["thread",104032],"thread-104021":["thread",104021],"thread-103519":["thread",103519],"thread-102077":["thread",102077],"thread-101370":["thread",101370],"thread-98824":["thread",98824],"thread-76830":["thread",76830],"thread-76402":["thread",76402],"thread-76105":["thread",76105],"thread-75712":["thread",75712],"thread-75665":["thread",75665],"thread-75659":["thread",75659],"thread-75280":["thread",75280],"thread-75233":["thread",75233],"thread-75081":["thread",75081],"thread-74665":["thread",74665],"thread-74596":["thread",74596],"thread-74529":["thread",74529],"thread-74478":["thread",74478],"thread-74465":["thread",74465],"thread-74321":["thread",74321],"thread-73885":["thread",73885],"thread-73545":["thread",73545],"thread-73542":["thread",73542],"thread-71607":["thread",71607],"thread-71606":["thread",71606],"thread-71575":["thread",71575],"thread-71294":["thread",71294],"thread-68891":["thread",68891],"thread-66590":["thread",66590],"thread-63464":["thread",63464],"thread-63300":["thread",63300],"thread-62712":["thread",62712],"thread-62426":["thread",62426],"thread-62422":["thread",62422],"thread-62245":["thread",62245],"thread-61990":["thread",61990],"thread-61792":["thread",61792],"thread-60416":["thread",60416],"thread-60273":["thread",60273],"thread-59860":["thread",59860],"thread-58227":["thread",58227],"thread-58057":["thread",58057],"thread-51681":["thread",51681],"thread-51556":["thread",51556],"thread-51555":["thread",51555],"thread-50954":["thread",50954],"thread-50635":["thread",50635],"thread-50634":["thread",50634]}, , 1714662668
Run Time: 0.000181
- 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