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 (7211348, 7202855, 7199404, 7184970, 7171856, 7166876, 7156868, 7154544, 7142072, 7136813, 7130881, 7129112, 7128458, 7116198, 7085812, 7084156, 7073027, 7064732, 7062892, 7045352, 7043186, 7037445, 7032890, 7030305, 6974987, 216309, 204979, 191065, 13472, 13383, 13060, 13000, 12562, 12357, 12133, 11860, 11819, 11506, 11491, 11383, 11311, 11012, 10886, 10822, 10617, 10094, 9755, 9671, 9497, 9308, 9140, 8984, 8490, 8394, 8048, 6908, 6238, 5730, 5249, 5130, 4883, 4822, 4640, 4112, 4011, 3873, 3367, 3036, 2768, 2762, 2597, 2594, 2088, 1704, 1651, 965, 452, 370))
Run Time: 0.005061
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 78 | 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: 402, 0, 1715194923, {"thread-7211348":["thread",7211348],"thread-7202855":["thread",7202855],"thread-7199404":["thread",7199404],"thread-7184970":["thread",7184970],"thread-7171856":["thread",7171856],"thread-7166876":["thread",7166876],"thread-7156868":["thread",7156868],"thread-7154544":["thread",7154544],"thread-7142072":["thread",7142072],"thread-7136813":["thread",7136813],"thread-7130881":["thread",7130881],"thread-7129112":["thread",7129112],"thread-7128458":["thread",7128458],"thread-7116198":["thread",7116198],"thread-7085812":["thread",7085812],"thread-7084156":["thread",7084156],"thread-7073027":["thread",7073027],"thread-7064732":["thread",7064732],"thread-7062892":["thread",7062892],"thread-7045352":["thread",7045352],"thread-7043186":["thread",7043186],"thread-7037445":["thread",7037445],"thread-7032890":["thread",7032890],"thread-7030305":["thread",7030305],"thread-6974987":["thread",6974987],"thread-216309":["thread",216309],"thread-204979":["thread",204979],"thread-191065":["thread",191065],"thread-13472":["thread",13472],"thread-13383":["thread",13383],"thread-13060":["thread",13060],"thread-13000":["thread",13000],"thread-12562":["thread",12562],"thread-12357":["thread",12357],"thread-12133":["thread",12133],"thread-11860":["thread",11860],"thread-11819":["thread",11819],"thread-11506":["thread",11506],"thread-11491":["thread",11491],"thread-11383":["thread",11383],"thread-11311":["thread",11311],"thread-11012":["thread",11012],"thread-10886":["thread",10886],"thread-10822":["thread",10822],"thread-10617":["thread",10617],"thread-10094":["thread",10094],"thread-9755":["thread",9755],"thread-9671":["thread",9671],"thread-9497":["thread",9497],"thread-9308":["thread",9308],"thread-9140":["thread",9140],"thread-8984":["thread",8984],"thread-8490":["thread",8490],"thread-8394":["thread",8394],"thread-8048":["thread",8048],"thread-6908":["thread",6908],"thread-6238":["thread",6238],"thread-5730":["thread",5730],"thread-5249":["thread",5249],"thread-5130":["thread",5130],"thread-4883":["thread",4883],"thread-4822":["thread",4822],"thread-4640":["thread",4640],"thread-4112":["thread",4112],"thread-4011":["thread",4011],"thread-3873":["thread",3873],"thread-3367":["thread",3367],"thread-3036":["thread",3036],"thread-2768":["thread",2768],"thread-2762":["thread",2762],"thread-2597":["thread",2597],"thread-2594":["thread",2594],"thread-2088":["thread",2088],"thread-1704":["thread",1704],"thread-1651":["thread",1651],"thread-965":["thread",965],"thread-452":["thread",452],"thread-370":["thread",370]}, NULL, 1715191323
Run Time: 0.000578
- 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