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 (183224, 182337, 178408, 177587, 174578, 174344, 174236, 174227, 172175, 164501, 164020, 161082, 159273, 159116, 153285, 151948, 143797, 140629, 140179, 139203, 138463, 128086, 125312, 123227, 123074, 121888, 121717, 120509, 119730, 119392, 118613, 118401, 118395, 118184, 112686, 109889, 109657, 107443, 107313, 102767, 102483, 102481, 100574, 100091, 99639, 99477, 99433, 99276, 97226, 93220, 92428, 89549, 84378, 84249, 84244, 82489, 82467, 80298, 79766, 79573, 76138, 76047, 75616, 75447, 73636, 73547, 72843, 69431, 68738, 68505, 65644, 64401, 61889, 56298, 56098, 49145, 35715, 33112, 31704, 27781, 26507, 26073, 25610, 25434, 13424, 7866, 6084, 4488, 3503, 169))
Run Time: 0.043848
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 90 | 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: 20, 0, 1716123188, {"thread-183224":["thread",183224],"thread-182337":["thread",182337],"thread-178408":["thread",178408],"thread-177587":["thread",177587],"thread-174578":["thread",174578],"thread-174344":["thread",174344],"thread-174236":["thread",174236],"thread-174227":["thread",174227],"thread-172175":["thread",172175],"tl_group-253":["tl_group",253],"thread-164501":["thread",164501],"thread-164020":["thread",164020],"thread-161082":["thread",161082],"thread-159273":["thread",159273],"thread-159116":["thread",159116],"thread-153285":["thread",153285],"thread-151948":["thread",151948],"thread-143797":["thread",143797],"thread-140629":["thread",140629],"thread-140179":["thread",140179],"thread-139203":["thread",139203],"thread-138463":["thread",138463],"thread-128086":["thread",128086],"thread-125312":["thread",125312],"thread-123227":["thread",123227],"thread-123074":["thread",123074],"thread-121888":["thread",121888],"thread-121717":["thread",121717],"thread-120509":["thread",120509],"thread-119730":["thread",119730],"thread-119392":["thread",119392],"thread-118613":["thread",118613],"thread-118401":["thread",118401],"thread-118395":["thread",118395],"thread-118184":["thread",118184],"thread-112686":["thread",112686],"thread-109889":["thread",109889],"thread-109657":["thread",109657],"thread-107443":["thread",107443],"thread-107313":["thread",107313],"thread-102767":["thread",102767],"thread-102483":["thread",102483],"thread-102481":["thread",102481],"thread-100574":["thread",100574],"thread-100091":["thread",100091],"thread-99639":["thread",99639],"thread-99477":["thread",99477],"thread-99433":["thread",99433],"thread-99276":["thread",99276],"thread-97226":["thread",97226],"thread-93220":["thread",93220],"thread-92428":["thread",92428],"thread-89549":["thread",89549],"thread-84378":["thread",84378],"thread-84249":["thread",84249],"thread-84244":["thread",84244],"thread-82489":["thread",82489],"thread-82467":["thread",82467],"thread-80298":["thread",80298],"thread-79766":["thread",79766],"thread-79573":["thread",79573],"thread-76138":["thread",76138],"thread-76047":["thread",76047],"thread-75616":["thread",75616],"thread-75447":["thread",75447],"thread-73636":["thread",73636],"thread-73547":["thread",73547],"thread-72843":["thread",72843],"thread-69431":["thread",69431],"thread-68738":["thread",68738],"thread-68505":["thread",68505],"thread-65644":["thread",65644],"thread-64401":["thread",64401],"thread-61889":["thread",61889],"thread-56298":["thread",56298],"thread-56098":["thread",56098],"thread-49145":["thread",49145],"thread-35715":["thread",35715],"thread-33112":["thread",33112],"thread-31704":["thread",31704],"thread-27781":["thread",27781],"thread-26507":["thread",26507],"thread-26073":["thread",26073],"thread-25610":["thread",25610],"thread-25434":["thread",25434],"thread-13424":["thread",13424],"thread-7866":["thread",7866],"thread-6084":["thread",6084],"thread-4488":["thread",4488],"thread-3503":["thread",3503],"thread-169":["thread",169]}, , 1716119588
Run Time: 0.000220
- 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