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 (7129925, 6995942, 6957326, 205920, 193230, 165572, 165565, 160186, 158497, 13675, 13126, 12923, 12619, 12593, 12393, 12195, 12158, 12052, 11603, 11601, 11546, 11529, 11311, 11308, 11205, 11137, 10801, 10799, 10474, 10176, 10152, 10042, 10001, 9848, 9642, 9599, 9563, 8896, 8893, 8388, 8333, 8245, 8233, 8197, 8142, 8132, 7965, 7727, 7579, 7574, 7230, 7186, 7104, 7048, 7013, 6902, 6696, 6643, 6535, 6513, 6250, 6239, 6106, 5983, 5960, 5893, 5859, 5750, 5739, 5633, 5506, 5488, 5357, 5185, 4871, 4495, 4400, 4257, 4009, 3982, 3944, 3640, 3491, 3471, 3412, 3367, 3256, 3218, 3019, 2941, 2735, 2463, 2246, 1887, 1700, 1597, 1172, 1105, 864, 854, 744, 742, 723, 594, 541, 535, 399, 286, 141))
Run Time: 0.006354
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 109 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,production_xf.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 1430
- 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 2870
- 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 138
- 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 2487
- XF\App->run() in src/XF.php at line 524
- 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: 129, 0, 1714672125, {"thread-7129925":["thread",7129925],"thread-6995942":["thread",6995942],"thread-6957326":["thread",6957326],"thread-205920":["thread",205920],"thread-193230":["thread",193230],"thread-165572":["thread",165572],"thread-165565":["thread",165565],"thread-160186":["thread",160186],"thread-158497":["thread",158497],"thread-13675":["thread",13675],"thread-13126":["thread",13126],"thread-12923":["thread",12923],"thread-12619":["thread",12619],"thread-12593":["thread",12593],"thread-12393":["thread",12393],"thread-12195":["thread",12195],"thread-12158":["thread",12158],"thread-12052":["thread",12052],"thread-11603":["thread",11603],"thread-11601":["thread",11601],"thread-11546":["thread",11546],"thread-11529":["thread",11529],"thread-11311":["thread",11311],"thread-11308":["thread",11308],"thread-11205":["thread",11205],"thread-11137":["thread",11137],"thread-10801":["thread",10801],"thread-10799":["thread",10799],"thread-10474":["thread",10474],"thread-10176":["thread",10176],"thread-10152":["thread",10152],"thread-10042":["thread",10042],"thread-10001":["thread",10001],"thread-9848":["thread",9848],"thread-9642":["thread",9642],"thread-9599":["thread",9599],"thread-9563":["thread",9563],"thread-8896":["thread",8896],"thread-8893":["thread",8893],"thread-8388":["thread",8388],"thread-8333":["thread",8333],"thread-8245":["thread",8245],"thread-8233":["thread",8233],"thread-8197":["thread",8197],"thread-8142":["thread",8142],"thread-8132":["thread",8132],"thread-7965":["thread",7965],"thread-7727":["thread",7727],"thread-7579":["thread",7579],"thread-7574":["thread",7574],"thread-7230":["thread",7230],"thread-7186":["thread",7186],"thread-7104":["thread",7104],"thread-7048":["thread",7048],"thread-7013":["thread",7013],"thread-6902":["thread",6902],"thread-6696":["thread",6696],"thread-6643":["thread",6643],"thread-6535":["thread",6535],"thread-6513":["thread",6513],"thread-6250":["thread",6250],"thread-6239":["thread",6239],"thread-6106":["thread",6106],"thread-5983":["thread",5983],"thread-5960":["thread",5960],"thread-5893":["thread",5893],"thread-5859":["thread",5859],"thread-5750":["thread",5750],"thread-5739":["thread",5739],"thread-5633":["thread",5633],"thread-5506":["thread",5506],"thread-5488":["thread",5488],"thread-5357":["thread",5357],"thread-5185":["thread",5185],"thread-4871":["thread",4871],"thread-4495":["thread",4495],"thread-4400":["thread",4400],"thread-4257":["thread",4257],"thread-4009":["thread",4009],"thread-3982":["thread",3982],"thread-3944":["thread",3944],"thread-3640":["thread",3640],"thread-3491":["thread",3491],"thread-3471":["thread",3471],"thread-3412":["thread",3412],"thread-3367":["thread",3367],"thread-3256":["thread",3256],"thread-3218":["thread",3218],"thread-3019":["thread",3019],"thread-2941":["thread",2941],"thread-2735":["thread",2735],"thread-2463":["thread",2463],"thread-2246":["thread",2246],"thread-1887":["thread",1887],"thread-1700":["thread",1700],"thread-1597":["thread",1597],"thread-1172":["thread",1172],"thread-1105":["thread",1105],"thread-864":["thread",864],"thread-854":["thread",854],"thread-744":["thread",744],"thread-742":["thread",742],"thread-723":["thread",723],"thread-594":["thread",594],"thread-541":["thread",541],"thread-399":["thread",399],"thread-286":["thread",286],"thread-141":["thread",141]}, NULL, 1714668525
Run Time: 0.000480
- 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 1521
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1253
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 151
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20