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 (183314, 182911, 182825, 179856, 179413, 179317, 178976, 178621, 177195, 176875, 176855, 176830, 176653, 176556, 175739, 175650, 175366, 173670, 173138, 172929, 172842, 169166, 168953, 165564, 160631, 158643, 157868, 152486, 151454, 149574, 140351, 137007, 136850, 135238, 133445, 124909, 119649, 117498, 116914, 116789, 111799, 109864, 103932, 103792, 102298, 99730, 99552, 99217, 98876, 97833, 96969, 94819, 85285, 81938, 76291, 70903, 69625, 66054, 60977, 60267, 59081, 57989, 57542, 56946, 56847, 56379, 54889, 54742, 54094, 54059, 53102, 53101, 52807, 52268, 52116, 51244, 50871, 50836, 50835, 50266, 49948, 49061, 48060, 47815, 41022, 36990, 32304, 27799, 23672, 20319, 18897, 18891))
Run Time: 0.054382
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 92 | 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: 2568, 0, 1715706618, {"thread-183314":["thread",183314],"thread-182911":["thread",182911],"thread-182825":["thread",182825],"thread-179856":["thread",179856],"thread-179413":["thread",179413],"tl_group-352":["tl_group",352],"thread-179317":["thread",179317],"thread-178976":["thread",178976],"thread-178621":["thread",178621],"thread-177195":["thread",177195],"thread-176875":["thread",176875],"thread-176855":["thread",176855],"thread-176830":["thread",176830],"thread-176653":["thread",176653],"thread-176556":["thread",176556],"thread-175739":["thread",175739],"thread-175650":["thread",175650],"thread-175366":["thread",175366],"thread-173670":["thread",173670],"thread-173138":["thread",173138],"thread-172929":["thread",172929],"thread-172842":["thread",172842],"thread-169166":["thread",169166],"ams_article-4792":["ams_article",4792],"thread-168953":["thread",168953],"tl_group-235":["tl_group",235],"thread-165564":["thread",165564],"ams_article-4463":["ams_article",4463],"thread-160631":["thread",160631],"thread-158643":["thread",158643],"thread-157868":["thread",157868],"thread-152486":["thread",152486],"thread-151454":["thread",151454],"thread-149574":["thread",149574],"thread-140351":["thread",140351],"thread-137007":["thread",137007],"thread-136850":["thread",136850],"thread-135238":["thread",135238],"thread-133445":["thread",133445],"thread-124909":["thread",124909],"thread-119649":["thread",119649],"thread-117498":["thread",117498],"thread-116914":["thread",116914],"thread-116789":["thread",116789],"thread-111799":["thread",111799],"thread-109864":["thread",109864],"thread-103932":["thread",103932],"thread-103792":["thread",103792],"thread-102298":["thread",102298],"thread-99730":["thread",99730],"thread-99552":["thread",99552],"thread-99217":["thread",99217],"thread-98876":["thread",98876],"thread-97833":["thread",97833],"thread-96969":["thread",96969],"thread-94819":["thread",94819],"thread-85285":["thread",85285],"thread-81938":["thread",81938],"thread-76291":["thread",76291],"thread-70903":["thread",70903],"thread-69625":["thread",69625],"thread-66054":["thread",66054],"thread-60977":["thread",60977],"thread-60267":["thread",60267],"thread-59081":["thread",59081],"thread-57989":["thread",57989],"thread-57542":["thread",57542],"thread-56946":["thread",56946],"thread-56847":["thread",56847],"thread-56379":["thread",56379],"thread-54889":["thread",54889],"thread-54742":["thread",54742],"thread-54094":["thread",54094],"thread-54059":["thread",54059],"thread-53102":["thread",53102],"thread-53101":["thread",53101],"thread-52807":["thread",52807],"thread-52268":["thread",52268],"thread-52116":["thread",52116],"thread-51244":["thread",51244],"thread-50871":["thread",50871],"thread-50836":["thread",50836],"thread-50835":["thread",50835],"thread-50266":["thread",50266],"thread-49948":["thread",49948],"thread-49061":["thread",49061],"thread-48060":["thread",48060],"thread-47815":["thread",47815],"thread-41022":["thread",41022],"thread-36990":["thread",36990],"thread-32304":["thread",32304],"thread-27799":["thread",27799],"thread-23672":["thread",23672],"thread-20319":["thread",20319],"thread-18897":["thread",18897],"thread-18891":["thread",18891]}, , 1715703018
Run Time: 0.000392
- 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