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 (7211098, 7187143, 7012224, 234655, 228996, 179610, 176286, 160368, 13411, 12652, 12641, 12409, 12118, 12115, 11676, 11506, 11346, 11090, 10881, 10812, 10607, 10385, 10355, 10337, 10079, 10057, 10053, 10044, 9868, 9847, 9629, 9549, 9547, 9447, 9390, 9166, 9153, 9080, 8748, 8453, 8030, 7778, 7668, 7500, 7357, 7322, 6763, 6762, 6738, 6291, 5661, 5504, 5406, 5363, 5205, 4998, 4958, 4827, 4450, 4229, 4046, 3681, 3140, 3085, 2950, 2457, 2452, 2379, 2066, 1999, 1841, 1748, 1501, 1295))
Run Time: 0.005250
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 74 | 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: 1565, 0, 1713513405, {"thread-7211098":["thread",7211098],"thread-7187143":["thread",7187143],"thread-7012224":["thread",7012224],"thread-234655":["thread",234655],"thread-228996":["thread",228996],"thread-179610":["thread",179610],"thread-176286":["thread",176286],"thread-160368":["thread",160368],"thread-13411":["thread",13411],"thread-12652":["thread",12652],"thread-12641":["thread",12641],"thread-12409":["thread",12409],"thread-12118":["thread",12118],"thread-12115":["thread",12115],"thread-11676":["thread",11676],"thread-11506":["thread",11506],"thread-11346":["thread",11346],"thread-11090":["thread",11090],"thread-10881":["thread",10881],"thread-10812":["thread",10812],"thread-10607":["thread",10607],"thread-10385":["thread",10385],"thread-10355":["thread",10355],"thread-10337":["thread",10337],"thread-10079":["thread",10079],"thread-10057":["thread",10057],"thread-10053":["thread",10053],"thread-10044":["thread",10044],"thread-9868":["thread",9868],"thread-9847":["thread",9847],"thread-9629":["thread",9629],"thread-9549":["thread",9549],"thread-9547":["thread",9547],"thread-9447":["thread",9447],"thread-9390":["thread",9390],"thread-9166":["thread",9166],"thread-9153":["thread",9153],"thread-9080":["thread",9080],"thread-8748":["thread",8748],"thread-8453":["thread",8453],"thread-8030":["thread",8030],"thread-7778":["thread",7778],"thread-7668":["thread",7668],"thread-7500":["thread",7500],"thread-7357":["thread",7357],"thread-7322":["thread",7322],"thread-6763":["thread",6763],"thread-6762":["thread",6762],"thread-6738":["thread",6738],"thread-6291":["thread",6291],"thread-5661":["thread",5661],"thread-5504":["thread",5504],"thread-5406":["thread",5406],"thread-5363":["thread",5363],"thread-5205":["thread",5205],"thread-4998":["thread",4998],"thread-4958":["thread",4958],"thread-4827":["thread",4827],"thread-4450":["thread",4450],"thread-4229":["thread",4229],"thread-4046":["thread",4046],"thread-3681":["thread",3681],"thread-3140":["thread",3140],"thread-3085":["thread",3085],"thread-2950":["thread",2950],"thread-2457":["thread",2457],"thread-2452":["thread",2452],"thread-2379":["thread",2379],"thread-2066":["thread",2066],"thread-1999":["thread",1999],"thread-1841":["thread",1841],"thread-1748":["thread",1748],"thread-1501":["thread",1501],"thread-1295":["thread",1295]}, NULL, 1713509805
Run Time: 0.000581
- 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