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 (7216889, 7215162, 7214439, 7214202, 7211894, 7202575, 7196189, 7195979, 7193516, 7189560, 7189073, 7187368, 7181831, 7179514, 7175838, 7174592, 7174118, 7173138, 7171586, 7169308, 7167356, 7165271, 7159168, 7154022, 7153262, 7152044, 7143821, 7140263, 7138661, 7136911, 7135368, 7134168, 7134009, 7133538, 7131418, 7125055, 7124488, 7124101, 7122758, 7122709, 7117860, 7117390, 7109389, 7106214, 7105549, 7102971, 7100052, 7099376, 7094241, 7086437, 7086107, 7076282, 7074287, 7070034, 7055229, 7050577, 7031614, 7011234, 7003578, 7002722, 6996369, 6986678, 6984111, 6970432, 6969602, 6958152, 6852936, 201487, 190457, 181461, 181307, 179167, 164674, 162492, 161855, 160320, 158660, 13813, 13808, 13611, 13441, 13016, 12817, 12500, 12460, 12210, 12130, 11981, 11923, 11858, 11604, 11335, 11206, 11110, 10827, 10789, 10689, 10329, 10210, 10080, 9988, 9651, 9610, 9569, 9215, 9195, 9032, 8912, 8825, 8680, 8585, 8572, 8487, 8319, 7749, 7732, 7695, 7525, 7502, 7501, 7242, 6809, 6589, 6476, 6421, 6006, 5788, 5692, 5622, 5302, 5284, 5233, 5187, 4896, 4730, 4634, 4276, 4261, 3883, 3800, 3769, 3514, 3498, 3362, 2932, 2899, 2869, 2868, 2835, 2790, 2670, 2461, 2099, 2074, 2004, 1820, 1685, 1642, 1567, 1542, 1369, 1351, 1278, 1246, 1204, 889, 700, 539, 529, 233))
Run Time: 0.011501
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 170 | 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: 181, 0, 1714872333, {"thread-7216889":["thread",7216889],"thread-7215162":["thread",7215162],"thread-7214439":["thread",7214439],"thread-7214202":["thread",7214202],"thread-7211894":["thread",7211894],"thread-7202575":["thread",7202575],"thread-7196189":["thread",7196189],"thread-7195979":["thread",7195979],"thread-7193516":["thread",7193516],"thread-7189560":["thread",7189560],"thread-7189073":["thread",7189073],"thread-7187368":["thread",7187368],"thread-7181831":["thread",7181831],"thread-7179514":["thread",7179514],"thread-7175838":["thread",7175838],"thread-7174592":["thread",7174592],"thread-7174118":["thread",7174118],"thread-7173138":["thread",7173138],"thread-7171586":["thread",7171586],"thread-7169308":["thread",7169308],"thread-7167356":["thread",7167356],"thread-7165271":["thread",7165271],"thread-7159168":["thread",7159168],"thread-7154022":["thread",7154022],"thread-7153262":["thread",7153262],"thread-7152044":["thread",7152044],"thread-7143821":["thread",7143821],"thread-7140263":["thread",7140263],"thread-7138661":["thread",7138661],"thread-7136911":["thread",7136911],"thread-7135368":["thread",7135368],"thread-7134168":["thread",7134168],"thread-7134009":["thread",7134009],"thread-7133538":["thread",7133538],"thread-7131418":["thread",7131418],"thread-7125055":["thread",7125055],"thread-7124488":["thread",7124488],"thread-7124101":["thread",7124101],"thread-7122758":["thread",7122758],"thread-7122709":["thread",7122709],"thread-7117860":["thread",7117860],"thread-7117390":["thread",7117390],"thread-7109389":["thread",7109389],"thread-7106214":["thread",7106214],"thread-7105549":["thread",7105549],"thread-7102971":["thread",7102971],"thread-7100052":["thread",7100052],"thread-7099376":["thread",7099376],"thread-7094241":["thread",7094241],"thread-7086437":["thread",7086437],"thread-7086107":["thread",7086107],"thread-7076282":["thread",7076282],"thread-7074287":["thread",7074287],"thread-7070034":["thread",7070034],"thread-7055229":["thread",7055229],"thread-7050577":["thread",7050577],"thread-7031614":["thread",7031614],"thread-7011234":["thread",7011234],"thread-7003578":["thread",7003578],"thread-7002722":["thread",7002722],"xfmg_media-2452":["xfmg_media",2452],"thread-6996369":["thread",6996369],"thread-6986678":["thread",6986678],"thread-6984111":["thread",6984111],"thread-6970432":["thread",6970432],"thread-6969602":["thread",6969602],"thread-6958152":["thread",6958152],"thread-6852936":["thread",6852936],"thread-201487":["thread",201487],"thread-190457":["thread",190457],"thread-181461":["thread",181461],"thread-181307":["thread",181307],"thread-179167":["thread",179167],"thread-164674":["thread",164674],"thread-162492":["thread",162492],"thread-161855":["thread",161855],"thread-160320":["thread",160320],"thread-158660":["thread",158660],"thread-13813":["thread",13813],"thread-13808":["thread",13808],"thread-13611":["thread",13611],"thread-13441":["thread",13441],"thread-13016":["thread",13016],"thread-12817":["thread",12817],"thread-12500":["thread",12500],"thread-12460":["thread",12460],"thread-12210":["thread",12210],"thread-12130":["thread",12130],"thread-11981":["thread",11981],"thread-11923":["thread",11923],"thread-11858":["thread",11858],"thread-11604":["thread",11604],"thread-11335":["thread",11335],"thread-11206":["thread",11206],"thread-11110":["thread",11110],"thread-10827":["thread",10827],"thread-10789":["thread",10789],"thread-10689":["thread",10689],"thread-10329":["thread",10329],"thread-10210":["thread",10210],"thread-10080":["thread",10080],"thread-9988":["thread",9988],"thread-9651":["thread",9651],"thread-9610":["thread",9610],"thread-9569":["thread",9569],"thread-9215":["thread",9215],"thread-9195":["thread",9195],"thread-9032":["thread",9032],"thread-8912":["thread",8912],"thread-8825":["thread",8825],"thread-8680":["thread",8680],"thread-8585":["thread",8585],"thread-8572":["thread",8572],"thread-8487":["thread",8487],"thread-8319":["thread",8319],"thread-7749":["thread",7749],"thread-7732":["thread",7732],"thread-7695":["thread",7695],"thread-7525":["thread",7525],"thread-7502":["thread",7502],"thread-7501":["thread",7501],"thread-7242":["thread",7242],"thread-6809":["thread",6809],"thread-6589":["thread",6589],"thread-6476":["thread",6476],"thread-6421":["thread",6421],"thread-6006":["thread",6006],"thread-5788":["thread",5788],"thread-5692":["thread",5692],"thread-5622":["thread",5622],"thread-5302":["thread",5302],"thread-5284":["thread",5284],"thread-5233":["thread",5233],"thread-5187":["thread",5187],"thread-4896":["thread",4896],"thread-4730":["thread",4730],"thread-4634":["thread",4634],"thread-4276":["thread",4276],"thread-4261":["thread",4261],"thread-3883":["thread",3883],"thread-3800":["thread",3800],"thread-3769":["thread",3769],"thread-3514":["thread",3514],"thread-3498":["thread",3498],"thread-3362":["thread",3362],"thread-2932":["thread",2932],"thread-2899":["thread",2899],"thread-2869":["thread",2869],"thread-2868":["thread",2868],"thread-2835":["thread",2835],"thread-2790":["thread",2790],"thread-2670":["thread",2670],"thread-2461":["thread",2461],"thread-2099":["thread",2099],"thread-2074":["thread",2074],"thread-2004":["thread",2004],"thread-1820":["thread",1820],"thread-1685":["thread",1685],"thread-1642":["thread",1642],"thread-1567":["thread",1567],"thread-1542":["thread",1542],"thread-1369":["thread",1369],"thread-1351":["thread",1351],"thread-1278":["thread",1278],"thread-1246":["thread",1246],"thread-1204":["thread",1204],"thread-889":["thread",889],"thread-700":["thread",700],"thread-539":["thread",539],"thread-529":["thread",529],"thread-233":["thread",233]}, NULL, 1714868733
Run Time: 0.001027
- 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