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 (7210523, 7208819, 7162302, 7157125, 7155095, 7152692, 7142232, 7137753, 7133306, 7133305, 7126920, 7113459, 7112776, 7107660, 7098247, 7089397, 7088162, 7074069, 7059072, 7029740, 7010727, 6999333, 6997947, 6992080, 6985721, 6974987, 6966388, 6966384, 6649247, 6363898, 6279873, 228916, 227057, 225404, 223842, 221370, 214723, 196950, 194030, 187237, 187085, 186060, 184448, 182710, 161838, 160427, 13741, 13678, 13573, 13543, 13539, 13502, 13495, 13487, 13357, 13338, 13290, 13215, 13210, 13198, 13108, 13096, 13071, 13067, 12979, 12853, 12429, 12275, 12210, 12120, 12099, 12057, 12007, 11964, 11950, 11944, 11921, 11873, 11855, 11846, 11821, 11784, 11701, 11695, 11694, 11677, 11591, 11396, 11334, 11179, 11064, 10995, 10892, 10828, 10723, 10682, 10563, 10537, 10434, 10404, 10354, 10262, 10192, 10052, 10013, 9987, 9944, 9802, 9781, 9753, 9732, 9718, 9636, 9552, 9548, 9514, 9513, 9451, 9356, 9319, 9074, 9059, 9049, 8998, 8852, 8759, 8745, 8718, 8656, 8580, 8408, 8402, 8380, 8292, 8134, 8103, 8057, 8056, 8047, 8030, 8029, 7829, 7787, 7710, 7610, 7348, 7222, 7045, 7020, 7018, 6968, 6851, 6809, 6798, 6762, 6674, 6589, 6467, 6401, 6398, 6369, 6259, 6229, 6218, 6200, 6181, 6168, 6046, 6036, 6008, 5991, 5956, 5922, 5915, 5911, 5867, 5861, 5745, 5696, 5633, 5623, 5582, 5550, 5518, 5475, 5474, 5345, 5328, 5308, 5305, 5281, 5193, 5172, 5168, 5163, 5006, 5000, 4989, 4967, 4966))
Run Time: 0.010126
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 200 | 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: 180, 0, 1716108503, {"thread-7210523":["thread",7210523],"thread-7208819":["thread",7208819],"thread-7162302":["thread",7162302],"thread-7157125":["thread",7157125],"thread-7155095":["thread",7155095],"thread-7152692":["thread",7152692],"thread-7142232":["thread",7142232],"thread-7137753":["thread",7137753],"thread-7133306":["thread",7133306],"thread-7133305":["thread",7133305],"thread-7126920":["thread",7126920],"thread-7113459":["thread",7113459],"thread-7112776":["thread",7112776],"thread-7107660":["thread",7107660],"thread-7098247":["thread",7098247],"thread-7089397":["thread",7089397],"thread-7088162":["thread",7088162],"thread-7074069":["thread",7074069],"thread-7059072":["thread",7059072],"thread-7029740":["thread",7029740],"thread-7010727":["thread",7010727],"thread-6999333":["thread",6999333],"thread-6997947":["thread",6997947],"thread-6992080":["thread",6992080],"thread-6985721":["thread",6985721],"thread-6974987":["thread",6974987],"thread-6966388":["thread",6966388],"thread-6966384":["thread",6966384],"thread-6649247":["thread",6649247],"thread-6363898":["thread",6363898],"thread-6279873":["thread",6279873],"thread-228916":["thread",228916],"thread-227057":["thread",227057],"thread-225404":["thread",225404],"thread-223842":["thread",223842],"thread-221370":["thread",221370],"thread-214723":["thread",214723],"thread-196950":["thread",196950],"thread-194030":["thread",194030],"thread-187237":["thread",187237],"thread-187085":["thread",187085],"thread-186060":["thread",186060],"thread-184448":["thread",184448],"thread-182710":["thread",182710],"thread-161838":["thread",161838],"thread-160427":["thread",160427],"thread-13741":["thread",13741],"thread-13678":["thread",13678],"thread-13573":["thread",13573],"thread-13543":["thread",13543],"thread-13539":["thread",13539],"thread-13502":["thread",13502],"thread-13495":["thread",13495],"thread-13487":["thread",13487],"thread-13357":["thread",13357],"thread-13338":["thread",13338],"thread-13290":["thread",13290],"thread-13215":["thread",13215],"thread-13210":["thread",13210],"thread-13198":["thread",13198],"thread-13108":["thread",13108],"thread-13096":["thread",13096],"thread-13071":["thread",13071],"thread-13067":["thread",13067],"thread-12979":["thread",12979],"thread-12853":["thread",12853],"thread-12429":["thread",12429],"thread-12275":["thread",12275],"thread-12210":["thread",12210],"thread-12120":["thread",12120],"thread-12099":["thread",12099],"thread-12057":["thread",12057],"thread-12007":["thread",12007],"thread-11964":["thread",11964],"thread-11950":["thread",11950],"thread-11944":["thread",11944],"thread-11921":["thread",11921],"thread-11873":["thread",11873],"thread-11855":["thread",11855],"thread-11846":["thread",11846],"thread-11821":["thread",11821],"thread-11784":["thread",11784],"thread-11701":["thread",11701],"thread-11695":["thread",11695],"thread-11694":["thread",11694],"thread-11677":["thread",11677],"thread-11591":["thread",11591],"thread-11396":["thread",11396],"thread-11334":["thread",11334],"thread-11179":["thread",11179],"thread-11064":["thread",11064],"thread-10995":["thread",10995],"thread-10892":["thread",10892],"thread-10828":["thread",10828],"thread-10723":["thread",10723],"thread-10682":["thread",10682],"thread-10563":["thread",10563],"thread-10537":["thread",10537],"thread-10434":["thread",10434],"thread-10404":["thread",10404],"thread-10354":["thread",10354],"thread-10262":["thread",10262],"thread-10192":["thread",10192],"thread-10052":["thread",10052],"thread-10013":["thread",10013],"thread-9987":["thread",9987],"thread-9944":["thread",9944],"thread-9802":["thread",9802],"thread-9781":["thread",9781],"thread-9753":["thread",9753],"thread-9732":["thread",9732],"thread-9718":["thread",9718],"thread-9636":["thread",9636],"thread-9552":["thread",9552],"thread-9548":["thread",9548],"thread-9514":["thread",9514],"thread-9513":["thread",9513],"thread-9451":["thread",9451],"thread-9356":["thread",9356],"thread-9319":["thread",9319],"thread-9074":["thread",9074],"thread-9059":["thread",9059],"thread-9049":["thread",9049],"thread-8998":["thread",8998],"thread-8852":["thread",8852],"thread-8759":["thread",8759],"thread-8745":["thread",8745],"thread-8718":["thread",8718],"thread-8656":["thread",8656],"thread-8580":["thread",8580],"thread-8408":["thread",8408],"thread-8402":["thread",8402],"thread-8380":["thread",8380],"thread-8292":["thread",8292],"thread-8134":["thread",8134],"thread-8103":["thread",8103],"thread-8057":["thread",8057],"thread-8056":["thread",8056],"thread-8047":["thread",8047],"thread-8030":["thread",8030],"thread-8029":["thread",8029],"thread-7829":["thread",7829],"thread-7787":["thread",7787],"thread-7710":["thread",7710],"thread-7610":["thread",7610],"thread-7348":["thread",7348],"thread-7222":["thread",7222],"thread-7045":["thread",7045],"thread-7020":["thread",7020],"thread-7018":["thread",7018],"thread-6968":["thread",6968],"thread-6851":["thread",6851],"thread-6809":["thread",6809],"thread-6798":["thread",6798],"thread-6762":["thread",6762],"thread-6674":["thread",6674],"thread-6589":["thread",6589],"thread-6467":["thread",6467],"thread-6401":["thread",6401],"thread-6398":["thread",6398],"thread-6369":["thread",6369],"thread-6259":["thread",6259],"thread-6229":["thread",6229],"thread-6218":["thread",6218],"thread-6200":["thread",6200],"thread-6181":["thread",6181],"thread-6168":["thread",6168],"thread-6046":["thread",6046],"thread-6036":["thread",6036],"thread-6008":["thread",6008],"thread-5991":["thread",5991],"thread-5956":["thread",5956],"thread-5922":["thread",5922],"thread-5915":["thread",5915],"thread-5911":["thread",5911],"thread-5867":["thread",5867],"thread-5861":["thread",5861],"thread-5745":["thread",5745],"thread-5696":["thread",5696],"thread-5633":["thread",5633],"thread-5623":["thread",5623],"thread-5582":["thread",5582],"thread-5550":["thread",5550],"thread-5518":["thread",5518],"thread-5475":["thread",5475],"thread-5474":["thread",5474],"thread-5345":["thread",5345],"thread-5328":["thread",5328],"thread-5308":["thread",5308],"thread-5305":["thread",5305],"thread-5281":["thread",5281],"thread-5193":["thread",5193],"thread-5172":["thread",5172],"thread-5168":["thread",5168],"thread-5163":["thread",5163],"thread-5006":["thread",5006],"thread-5000":["thread",5000],"thread-4989":["thread",4989],"thread-4967":["thread",4967],"thread-4966":["thread",4966]}, NULL, 1716104903
Run Time: 0.000708
- 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