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 (7217639, 7182245, 7168927, 156947, 13473, 13444, 13135, 12703, 12421, 12343, 11954, 11838, 11817, 11352, 11180, 10820, 10645, 10100, 9935, 9345, 9295, 9226, 8917, 8788, 8608, 8552, 8461, 8229, 8224, 7917, 7587, 7312, 6840, 6503, 6361, 6233, 6139, 5975, 5965, 5931, 5865, 5638, 5238, 5013, 4519, 4488, 4409, 4403, 3822, 3669, 3584, 3539, 3000, 2937, 2468, 2221, 2101, 1852, 1225, 1191, 688, 682, 380, 354))
Run Time: 0.005160
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 64 | 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: 365, 0, 1715981171, {"thread-7217639":["thread",7217639],"thread-7182245":["thread",7182245],"thread-7168927":["thread",7168927],"thread-156947":["thread",156947],"thread-13473":["thread",13473],"thread-13444":["thread",13444],"thread-13135":["thread",13135],"thread-12703":["thread",12703],"thread-12421":["thread",12421],"thread-12343":["thread",12343],"thread-11954":["thread",11954],"thread-11838":["thread",11838],"thread-11817":["thread",11817],"thread-11352":["thread",11352],"thread-11180":["thread",11180],"thread-10820":["thread",10820],"thread-10645":["thread",10645],"thread-10100":["thread",10100],"thread-9935":["thread",9935],"thread-9345":["thread",9345],"thread-9295":["thread",9295],"thread-9226":["thread",9226],"thread-8917":["thread",8917],"thread-8788":["thread",8788],"thread-8608":["thread",8608],"thread-8552":["thread",8552],"thread-8461":["thread",8461],"thread-8229":["thread",8229],"thread-8224":["thread",8224],"thread-7917":["thread",7917],"thread-7587":["thread",7587],"thread-7312":["thread",7312],"thread-6840":["thread",6840],"thread-6503":["thread",6503],"thread-6361":["thread",6361],"thread-6233":["thread",6233],"thread-6139":["thread",6139],"thread-5975":["thread",5975],"thread-5965":["thread",5965],"thread-5931":["thread",5931],"thread-5865":["thread",5865],"thread-5638":["thread",5638],"thread-5238":["thread",5238],"thread-5013":["thread",5013],"thread-4519":["thread",4519],"thread-4488":["thread",4488],"thread-4409":["thread",4409],"thread-4403":["thread",4403],"thread-3822":["thread",3822],"thread-3669":["thread",3669],"thread-3584":["thread",3584],"thread-3539":["thread",3539],"thread-3000":["thread",3000],"thread-2937":["thread",2937],"thread-2468":["thread",2468],"thread-2221":["thread",2221],"thread-2101":["thread",2101],"thread-1852":["thread",1852],"thread-1225":["thread",1225],"thread-1191":["thread",1191],"thread-688":["thread",688],"thread-682":["thread",682],"thread-380":["thread",380],"thread-354":["thread",354]}, NULL, 1715977571
Run Time: 0.000476
- 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