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 (183410, 183018, 180572, 180131, 180066, 178542, 178375, 176746, 175754, 172818, 171792, 169958, 169725, 169635, 168736, 167848, 166395, 166169, 166168, 160668, 160203, 160149, 159306, 157019, 155710, 155696, 155693, 154802, 154582, 153959, 152805, 143301, 143285, 136196, 132970, 131254, 130125, 129748, 125569, 123492, 121305, 113357, 112520, 110492, 104361, 97552, 92799, 91622, 77876, 75882, 75461, 75435, 75010, 74735, 74487, 74135, 73016, 72087, 71267, 71266, 54570, 27367, 11531))
Run Time: 0.023718
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 63 | 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: 1847, 0, 1716060407, {"thread-183410":["thread",183410],"thread-183018":["thread",183018],"thread-180572":["thread",180572],"thread-180131":["thread",180131],"thread-180066":["thread",180066],"thread-178542":["thread",178542],"thread-178375":["thread",178375],"thread-176746":["thread",176746],"thread-175754":["thread",175754],"thread-172818":["thread",172818],"thread-171792":["thread",171792],"thread-169958":["thread",169958],"thread-169725":["thread",169725],"thread-169635":["thread",169635],"thread-168736":["thread",168736],"thread-167848":["thread",167848],"thread-166395":["thread",166395],"thread-166169":["thread",166169],"thread-166168":["thread",166168],"thread-160668":["thread",160668],"thread-160203":["thread",160203],"thread-160149":["thread",160149],"thread-159306":["thread",159306],"thread-157019":["thread",157019],"thread-155710":["thread",155710],"thread-155696":["thread",155696],"thread-155693":["thread",155693],"thread-154802":["thread",154802],"thread-154582":["thread",154582],"thread-153959":["thread",153959],"thread-152805":["thread",152805],"thread-143301":["thread",143301],"thread-143285":["thread",143285],"thread-136196":["thread",136196],"thread-132970":["thread",132970],"thread-131254":["thread",131254],"thread-130125":["thread",130125],"thread-129748":["thread",129748],"thread-125569":["thread",125569],"thread-123492":["thread",123492],"thread-121305":["thread",121305],"thread-113357":["thread",113357],"thread-112520":["thread",112520],"thread-110492":["thread",110492],"thread-104361":["thread",104361],"thread-97552":["thread",97552],"thread-92799":["thread",92799],"thread-91622":["thread",91622],"thread-77876":["thread",77876],"thread-75882":["thread",75882],"thread-75461":["thread",75461],"thread-75435":["thread",75435],"thread-75010":["thread",75010],"thread-74735":["thread",74735],"thread-74487":["thread",74487],"thread-74135":["thread",74135],"thread-73016":["thread",73016],"thread-72087":["thread",72087],"thread-71267":["thread",71267],"thread-71266":["thread",71266],"thread-54570":["thread",54570],"thread-27367":["thread",27367],"thread-11531":["thread",11531]}, , 1716056807
Run Time: 0.000303
- 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