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 (7204040, 7203709, 7201860, 7199005, 7198344, 7191102, 7186534, 7183523, 7177894, 7176517, 7175948, 7170849, 7169321, 7161803, 7160654, 7159961, 7157225, 7150030, 7149547, 7141080, 7139728, 7137582, 7137581, 7136393, 7126364, 7124754, 7124204, 7118038, 7113736, 7102432, 7089397, 7077955, 7062301, 7060546, 7027247, 7018720, 7012828, 7004312, 6998840, 6995347, 6990463, 6988688, 6978653, 6961923, 239435, 228535, 218241, 187092, 12797, 12101, 12064, 12010, 11803, 11524, 11248, 11246, 11056, 11023, 10032, 9719, 9493, 7553, 7463, 6019, 5927, 5838, 5492, 5378, 5315, 5075, 4535, 4115, 3962, 3653, 2730, 2635, 2588, 2328, 2282, 1763, 1032))
Run Time: 0.007227
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 81 | 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: 1224, 0, 1714479752, {"thread-7204040":["thread",7204040],"thread-7203709":["thread",7203709],"thread-7201860":["thread",7201860],"thread-7199005":["thread",7199005],"thread-7198344":["thread",7198344],"thread-7191102":["thread",7191102],"thread-7186534":["thread",7186534],"thread-7183523":["thread",7183523],"thread-7177894":["thread",7177894],"thread-7176517":["thread",7176517],"thread-7175948":["thread",7175948],"thread-7170849":["thread",7170849],"thread-7169321":["thread",7169321],"thread-7161803":["thread",7161803],"thread-7160654":["thread",7160654],"thread-7159961":["thread",7159961],"thread-7157225":["thread",7157225],"thread-7150030":["thread",7150030],"thread-7149547":["thread",7149547],"thread-7141080":["thread",7141080],"thread-7139728":["thread",7139728],"thread-7137582":["thread",7137582],"thread-7137581":["thread",7137581],"thread-7136393":["thread",7136393],"thread-7126364":["thread",7126364],"thread-7124754":["thread",7124754],"thread-7124204":["thread",7124204],"thread-7118038":["thread",7118038],"thread-7113736":["thread",7113736],"thread-7102432":["thread",7102432],"thread-7089397":["thread",7089397],"thread-7077955":["thread",7077955],"thread-7062301":["thread",7062301],"thread-7060546":["thread",7060546],"thread-7027247":["thread",7027247],"thread-7018720":["thread",7018720],"thread-7012828":["thread",7012828],"thread-7004312":["thread",7004312],"thread-6998840":["thread",6998840],"thread-6995347":["thread",6995347],"thread-6990463":["thread",6990463],"thread-6988688":["thread",6988688],"thread-6978653":["thread",6978653],"thread-6961923":["thread",6961923],"thread-239435":["thread",239435],"thread-228535":["thread",228535],"thread-218241":["thread",218241],"thread-187092":["thread",187092],"thread-12797":["thread",12797],"thread-12101":["thread",12101],"thread-12064":["thread",12064],"thread-12010":["thread",12010],"thread-11803":["thread",11803],"thread-11524":["thread",11524],"thread-11248":["thread",11248],"thread-11246":["thread",11246],"thread-11056":["thread",11056],"thread-11023":["thread",11023],"thread-10032":["thread",10032],"thread-9719":["thread",9719],"thread-9493":["thread",9493],"thread-7553":["thread",7553],"thread-7463":["thread",7463],"thread-6019":["thread",6019],"thread-5927":["thread",5927],"thread-5838":["thread",5838],"thread-5492":["thread",5492],"thread-5378":["thread",5378],"thread-5315":["thread",5315],"thread-5075":["thread",5075],"thread-4535":["thread",4535],"thread-4115":["thread",4115],"thread-3962":["thread",3962],"thread-3653":["thread",3653],"thread-2730":["thread",2730],"thread-2635":["thread",2635],"thread-2588":["thread",2588],"thread-2328":["thread",2328],"thread-2282":["thread",2282],"thread-1763":["thread",1763],"thread-1032":["thread",1032]}, NULL, 1714476152
Run Time: 0.000666
- 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