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 (7218200, 7218127, 7217620, 7215038, 7214679, 7214625, 7214334, 7197833, 7196949, 7192605, 7189128, 7189126, 7187241, 7180607, 7174645, 7170757, 7170740, 7155748, 7154031, 7151729, 7144772, 7140411, 7140069, 7138561, 7133570, 7130848, 7129005, 7127950, 7124076, 7120868, 7120016, 7118019, 7117021, 7115208, 7113412, 7113288, 7113284, 7111608, 7111090, 7111078, 7110825, 7110517, 7110246, 7109502, 7109187, 7107983, 7107157, 7104239, 7099311, 7094706, 7088950, 7088730, 7086881, 7081970, 7079679, 7078232, 7075638, 7073753, 7070937, 7070287, 7069594, 7067763, 7067167, 7066899, 7063749, 7052199, 7047572, 7046268, 7045384, 7012834, 6998209, 6998195, 6980216, 6969142, 6967496, 6965727, 239438, 13674, 13183, 12827, 12600, 12222, 11687, 11664, 11529, 11004, 10160, 9305, 8839, 8139, 7588, 7579, 7412, 7115, 7030, 6938, 6281, 6053, 5741, 5501, 4839, 4400, 4087, 3492, 3461, 2116, 1492))
Run Time: 0.006718
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 107 | 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: 1774, 0, 1715891196, {"thread-7218200":["thread",7218200],"thread-7218127":["thread",7218127],"thread-7217620":["thread",7217620],"thread-7215038":["thread",7215038],"thread-7214679":["thread",7214679],"thread-7214625":["thread",7214625],"thread-7214334":["thread",7214334],"thread-7197833":["thread",7197833],"thread-7196949":["thread",7196949],"thread-7192605":["thread",7192605],"thread-7189128":["thread",7189128],"thread-7189126":["thread",7189126],"thread-7187241":["thread",7187241],"thread-7180607":["thread",7180607],"thread-7174645":["thread",7174645],"thread-7170757":["thread",7170757],"thread-7170740":["thread",7170740],"thread-7155748":["thread",7155748],"thread-7154031":["thread",7154031],"thread-7151729":["thread",7151729],"thread-7144772":["thread",7144772],"thread-7140411":["thread",7140411],"thread-7140069":["thread",7140069],"thread-7138561":["thread",7138561],"thread-7133570":["thread",7133570],"thread-7130848":["thread",7130848],"thread-7129005":["thread",7129005],"thread-7127950":["thread",7127950],"thread-7124076":["thread",7124076],"thread-7120868":["thread",7120868],"thread-7120016":["thread",7120016],"thread-7118019":["thread",7118019],"thread-7117021":["thread",7117021],"thread-7115208":["thread",7115208],"thread-7113412":["thread",7113412],"thread-7113288":["thread",7113288],"thread-7113284":["thread",7113284],"thread-7111608":["thread",7111608],"thread-7111090":["thread",7111090],"thread-7111078":["thread",7111078],"thread-7110825":["thread",7110825],"thread-7110517":["thread",7110517],"thread-7110246":["thread",7110246],"thread-7109502":["thread",7109502],"thread-7109187":["thread",7109187],"thread-7107983":["thread",7107983],"thread-7107157":["thread",7107157],"thread-7104239":["thread",7104239],"thread-7099311":["thread",7099311],"thread-7094706":["thread",7094706],"thread-7088950":["thread",7088950],"thread-7088730":["thread",7088730],"thread-7086881":["thread",7086881],"thread-7081970":["thread",7081970],"thread-7079679":["thread",7079679],"thread-7078232":["thread",7078232],"thread-7075638":["thread",7075638],"thread-7073753":["thread",7073753],"thread-7070937":["thread",7070937],"thread-7070287":["thread",7070287],"thread-7069594":["thread",7069594],"thread-7067763":["thread",7067763],"thread-7067167":["thread",7067167],"thread-7066899":["thread",7066899],"thread-7063749":["thread",7063749],"thread-7052199":["thread",7052199],"thread-7047572":["thread",7047572],"thread-7046268":["thread",7046268],"thread-7045384":["thread",7045384],"thread-7012834":["thread",7012834],"thread-6998209":["thread",6998209],"thread-6998195":["thread",6998195],"thread-6980216":["thread",6980216],"thread-6969142":["thread",6969142],"thread-6967496":["thread",6967496],"thread-6965727":["thread",6965727],"thread-239438":["thread",239438],"thread-13674":["thread",13674],"thread-13183":["thread",13183],"thread-12827":["thread",12827],"thread-12600":["thread",12600],"thread-12222":["thread",12222],"thread-11687":["thread",11687],"thread-11664":["thread",11664],"thread-11529":["thread",11529],"thread-11004":["thread",11004],"thread-10160":["thread",10160],"thread-9305":["thread",9305],"thread-8839":["thread",8839],"thread-8139":["thread",8139],"thread-7588":["thread",7588],"thread-7579":["thread",7579],"thread-7412":["thread",7412],"thread-7115":["thread",7115],"thread-7030":["thread",7030],"thread-6938":["thread",6938],"thread-6281":["thread",6281],"thread-6053":["thread",6053],"thread-5741":["thread",5741],"thread-5501":["thread",5501],"thread-4839":["thread",4839],"thread-4400":["thread",4400],"thread-4087":["thread",4087],"thread-3492":["thread",3492],"thread-3461":["thread",3461],"thread-2116":["thread",2116],"thread-1492":["thread",1492]}, NULL, 1715887596
Run Time: 0.000430
- 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