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 (136220, 135906, 135342, 131018, 130883, 130831, 130678, 130436, 130336, 130201, 130123, 130000, 129960, 129817, 129801, 129572, 129161, 128933, 128723, 128284, 127746, 127699, 127485, 127473, 127444, 127003, 126234, 125937, 125803, 125706, 125517, 123847, 123225, 123021, 122893, 122087, 121463, 121453, 121452, 121449, 121337, 120931, 120889, 120886, 120885, 120882, 120866, 119516, 119393, 119318, 119278, 119275, 119273, 119163, 118467, 118433, 118414, 118063, 117937, 117853, 117692, 117685, 117538, 117392, 117265, 116127, 115774, 115371, 114603, 114065, 112184, 112065, 112024, 109477, 107989, 107979, 106432, 104803, 101015, 100482, 99309))
Run Time: 0.049816
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 81 | 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: 25001, 0, 1716118048, {"ams_article-3002":["ams_article",3002],"thread-136220":["thread",136220],"thread-135906":["thread",135906],"thread-135342":["thread",135342],"thread-131018":["thread",131018],"thread-130883":["thread",130883],"thread-130831":["thread",130831],"thread-130678":["thread",130678],"thread-130436":["thread",130436],"thread-130336":["thread",130336],"thread-130201":["thread",130201],"thread-130123":["thread",130123],"thread-130000":["thread",130000],"thread-129960":["thread",129960],"thread-129817":["thread",129817],"thread-129801":["thread",129801],"thread-129572":["thread",129572],"thread-129161":["thread",129161],"thread-128933":["thread",128933],"thread-128723":["thread",128723],"thread-128284":["thread",128284],"thread-127746":["thread",127746],"thread-127699":["thread",127699],"thread-127485":["thread",127485],"thread-127473":["thread",127473],"thread-127444":["thread",127444],"thread-127003":["thread",127003],"thread-126234":["thread",126234],"thread-125937":["thread",125937],"thread-125803":["thread",125803],"thread-125706":["thread",125706],"thread-125517":["thread",125517],"thread-123847":["thread",123847],"thread-123225":["thread",123225],"thread-123021":["thread",123021],"thread-122893":["thread",122893],"thread-122087":["thread",122087],"thread-121463":["thread",121463],"thread-121453":["thread",121453],"thread-121452":["thread",121452],"thread-121449":["thread",121449],"thread-121337":["thread",121337],"thread-120931":["thread",120931],"thread-120889":["thread",120889],"thread-120886":["thread",120886],"thread-120885":["thread",120885],"thread-120882":["thread",120882],"thread-120866":["thread",120866],"thread-119516":["thread",119516],"thread-119393":["thread",119393],"thread-119318":["thread",119318],"thread-119278":["thread",119278],"thread-119275":["thread",119275],"thread-119273":["thread",119273],"thread-119163":["thread",119163],"thread-118467":["thread",118467],"thread-118433":["thread",118433],"thread-118414":["thread",118414],"thread-118063":["thread",118063],"thread-117937":["thread",117937],"thread-117853":["thread",117853],"thread-117692":["thread",117692],"thread-117685":["thread",117685],"thread-117538":["thread",117538],"thread-117392":["thread",117392],"thread-117265":["thread",117265],"thread-116127":["thread",116127],"thread-115774":["thread",115774],"thread-115371":["thread",115371],"thread-114603":["thread",114603],"thread-114065":["thread",114065],"thread-112184":["thread",112184],"thread-112065":["thread",112065],"thread-112024":["thread",112024],"thread-109477":["thread",109477],"thread-107989":["thread",107989],"thread-107979":["thread",107979],"thread-106432":["thread",106432],"thread-104803":["thread",104803],"thread-101015":["thread",101015],"thread-100482":["thread",100482],"thread-99309":["thread",99309]}, , 1716114448
Run Time: 0.000250
- 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