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 (182672, 180474, 179920, 178521, 176802, 175617, 174788, 174443, 167885, 162718, 162070, 158843, 158800, 157660, 153094, 150495, 139807, 136695, 132509, 130549, 130265, 127473, 121250, 120312, 118454, 115931, 114008, 112649, 111745, 111596, 111581, 111206, 110924, 109633, 102362, 102263, 100821, 85187, 84859, 81592, 75318, 73868, 70961, 69333, 69303, 64188, 61466, 59849, 59180, 59009, 59008, 58802, 58206, 57424, 57414, 53366, 47521, 41932, 33224, 31298, 12346, 3222))
Run Time: 0.038607
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 62 | 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: 799, 0, 1715320574, {"thread-182672":["thread",182672],"tl_group-385":["tl_group",385],"thread-180474":["thread",180474],"thread-179920":["thread",179920],"tl_group-335":["tl_group",335],"thread-178521":["thread",178521],"thread-176802":["thread",176802],"thread-175617":["thread",175617],"thread-174788":["thread",174788],"thread-174443":["thread",174443],"thread-167885":["thread",167885],"thread-162718":["thread",162718],"thread-162070":["thread",162070],"thread-158843":["thread",158843],"thread-158800":["thread",158800],"thread-157660":["thread",157660],"thread-153094":["thread",153094],"thread-150495":["thread",150495],"thread-139807":["thread",139807],"thread-136695":["thread",136695],"thread-132509":["thread",132509],"thread-130549":["thread",130549],"thread-130265":["thread",130265],"thread-127473":["thread",127473],"thread-121250":["thread",121250],"thread-120312":["thread",120312],"thread-118454":["thread",118454],"thread-115931":["thread",115931],"thread-114008":["thread",114008],"thread-112649":["thread",112649],"thread-111745":["thread",111745],"thread-111596":["thread",111596],"thread-111581":["thread",111581],"thread-111206":["thread",111206],"thread-110924":["thread",110924],"thread-109633":["thread",109633],"thread-102362":["thread",102362],"thread-102263":["thread",102263],"thread-100821":["thread",100821],"thread-85187":["thread",85187],"thread-84859":["thread",84859],"thread-81592":["thread",81592],"thread-75318":["thread",75318],"thread-73868":["thread",73868],"thread-70961":["thread",70961],"thread-69333":["thread",69333],"thread-69303":["thread",69303],"thread-64188":["thread",64188],"thread-61466":["thread",61466],"thread-59849":["thread",59849],"thread-59180":["thread",59180],"thread-59009":["thread",59009],"thread-59008":["thread",59008],"thread-58802":["thread",58802],"thread-58206":["thread",58206],"thread-57424":["thread",57424],"thread-57414":["thread",57414],"thread-53366":["thread",53366],"thread-47521":["thread",47521],"thread-41932":["thread",41932],"thread-33224":["thread",33224],"thread-31298":["thread",31298],"thread-12346":["thread",12346],"thread-3222":["thread",3222]}, , 1715316974
Run Time: 0.000776
- 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