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 (7195920, 7176135, 7168316, 7138176, 7125176, 7121396, 7116198, 7110124, 7095213, 7086860, 7086774, 7078558, 7078065, 7063958, 7058281, 7030773, 7030772, 7003456, 6978816, 6973648, 6466843, 231013, 224508, 218241, 216114, 191002, 169338, 167144, 163183, 160299, 13734, 13485, 13409, 13007, 12816, 12718, 12587, 12456, 11971, 11846, 11634, 11618, 11617, 11608, 11299, 11239, 10883, 10879, 10381, 10329, 10298, 9958, 9913, 9863, 9580, 9264, 9261, 9138, 8333, 8265, 8117, 8091, 7508, 7275, 7273, 7123, 7063, 6918, 6887, 6778, 6100, 5933, 5747, 5713, 5666, 5648, 5632, 5593, 5469, 5406, 5279, 5201, 5058, 4971, 4938, 4224, 3900, 3519, 3499, 3335, 3280, 2590, 2143, 1801, 1277, 1165, 1015, 376, 247))
Run Time: 0.006882
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 99 | 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: 204, 0, 1714402574, {"thread-7195920":["thread",7195920],"thread-7176135":["thread",7176135],"thread-7168316":["thread",7168316],"thread-7138176":["thread",7138176],"thread-7125176":["thread",7125176],"thread-7121396":["thread",7121396],"thread-7116198":["thread",7116198],"thread-7110124":["thread",7110124],"thread-7095213":["thread",7095213],"thread-7086860":["thread",7086860],"thread-7086774":["thread",7086774],"thread-7078558":["thread",7078558],"thread-7078065":["thread",7078065],"thread-7063958":["thread",7063958],"thread-7058281":["thread",7058281],"thread-7030773":["thread",7030773],"thread-7030772":["thread",7030772],"thread-7003456":["thread",7003456],"thread-6978816":["thread",6978816],"thread-6973648":["thread",6973648],"thread-6466843":["thread",6466843],"thread-231013":["thread",231013],"thread-224508":["thread",224508],"thread-218241":["thread",218241],"thread-216114":["thread",216114],"thread-191002":["thread",191002],"thread-169338":["thread",169338],"thread-167144":["thread",167144],"thread-163183":["thread",163183],"thread-160299":["thread",160299],"thread-13734":["thread",13734],"thread-13485":["thread",13485],"thread-13409":["thread",13409],"thread-13007":["thread",13007],"thread-12816":["thread",12816],"thread-12718":["thread",12718],"thread-12587":["thread",12587],"thread-12456":["thread",12456],"thread-11971":["thread",11971],"thread-11846":["thread",11846],"thread-11634":["thread",11634],"thread-11618":["thread",11618],"thread-11617":["thread",11617],"thread-11608":["thread",11608],"thread-11299":["thread",11299],"thread-11239":["thread",11239],"thread-10883":["thread",10883],"thread-10879":["thread",10879],"thread-10381":["thread",10381],"thread-10329":["thread",10329],"thread-10298":["thread",10298],"thread-9958":["thread",9958],"thread-9913":["thread",9913],"thread-9863":["thread",9863],"thread-9580":["thread",9580],"thread-9264":["thread",9264],"thread-9261":["thread",9261],"thread-9138":["thread",9138],"thread-8333":["thread",8333],"thread-8265":["thread",8265],"thread-8117":["thread",8117],"thread-8091":["thread",8091],"thread-7508":["thread",7508],"thread-7275":["thread",7275],"thread-7273":["thread",7273],"thread-7123":["thread",7123],"thread-7063":["thread",7063],"thread-6918":["thread",6918],"thread-6887":["thread",6887],"thread-6778":["thread",6778],"thread-6100":["thread",6100],"thread-5933":["thread",5933],"thread-5747":["thread",5747],"thread-5713":["thread",5713],"thread-5666":["thread",5666],"thread-5648":["thread",5648],"thread-5632":["thread",5632],"thread-5593":["thread",5593],"thread-5469":["thread",5469],"thread-5406":["thread",5406],"thread-5279":["thread",5279],"thread-5201":["thread",5201],"thread-5058":["thread",5058],"thread-4971":["thread",4971],"thread-4938":["thread",4938],"thread-4224":["thread",4224],"thread-3900":["thread",3900],"thread-3519":["thread",3519],"thread-3499":["thread",3499],"thread-3335":["thread",3335],"thread-3280":["thread",3280],"thread-2590":["thread",2590],"thread-2143":["thread",2143],"thread-1801":["thread",1801],"thread-1277":["thread",1277],"thread-1165":["thread",1165],"thread-1015":["thread",1015],"thread-376":["thread",376],"thread-247":["thread",247]}, NULL, 1714398974
Run Time: 0.000810
- 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