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 (7215115, 7215024, 7214400, 7205982, 7205773, 7202172, 7200915, 7200457, 7198412, 7195146, 7185267, 7179895, 7179894, 7174311, 7164803, 7146158, 7126124, 7118148, 7112361, 7111169, 7107676, 7106292, 7102978, 7093215, 7092794, 7057927, 7044544, 7037581, 7014511, 7002550, 6982770, 6962109, 186053, 182251, 176015, 174354, 160398, 13208, 13203, 13091, 13052, 12879, 12819, 12029, 12013, 11988, 11939, 11929, 11853, 11751, 11744, 11695, 11515, 11499, 11318, 11171, 11170, 11146, 11127, 11118, 10921, 10790, 10771, 10743, 10618, 10553, 10534, 10532, 10478, 10444, 10323, 10309, 10292, 10269, 10112, 10053, 9969, 9720, 9715, 9595, 9384, 9275, 9207, 9103, 9085, 8943, 8931, 8869, 8843, 8825, 8576, 8456, 8042, 7409, 7087, 7066, 6857, 6592, 6323, 6008, 5905, 5890, 5711, 5504, 5036, 4890, 4884, 4762, 4446, 4222, 3951, 3928, 3908, 3861, 3594, 3293, 3062, 2779, 2642, 2598, 2571, 2570, 2418, 2150, 2084, 2047, 1972, 1916, 1902, 1777, 1662, 1586, 1420, 1167, 835, 766, 701, 654, 539, 375))
Run Time: 0.007278
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 140 | 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: 411, 0, 1714744050, {"thread-7215115":["thread",7215115],"thread-7215024":["thread",7215024],"thread-7214400":["thread",7214400],"thread-7205982":["thread",7205982],"thread-7205773":["thread",7205773],"thread-7202172":["thread",7202172],"thread-7200915":["thread",7200915],"thread-7200457":["thread",7200457],"thread-7198412":["thread",7198412],"thread-7195146":["thread",7195146],"thread-7185267":["thread",7185267],"thread-7179895":["thread",7179895],"thread-7179894":["thread",7179894],"thread-7174311":["thread",7174311],"thread-7164803":["thread",7164803],"thread-7146158":["thread",7146158],"thread-7126124":["thread",7126124],"thread-7118148":["thread",7118148],"thread-7112361":["thread",7112361],"thread-7111169":["thread",7111169],"thread-7107676":["thread",7107676],"thread-7106292":["thread",7106292],"thread-7102978":["thread",7102978],"thread-7093215":["thread",7093215],"thread-7092794":["thread",7092794],"thread-7057927":["thread",7057927],"thread-7044544":["thread",7044544],"thread-7037581":["thread",7037581],"thread-7014511":["thread",7014511],"thread-7002550":["thread",7002550],"thread-6982770":["thread",6982770],"thread-6962109":["thread",6962109],"thread-186053":["thread",186053],"thread-182251":["thread",182251],"thread-176015":["thread",176015],"thread-174354":["thread",174354],"thread-160398":["thread",160398],"thread-13208":["thread",13208],"thread-13203":["thread",13203],"thread-13091":["thread",13091],"thread-13052":["thread",13052],"thread-12879":["thread",12879],"thread-12819":["thread",12819],"thread-12029":["thread",12029],"thread-12013":["thread",12013],"thread-11988":["thread",11988],"thread-11939":["thread",11939],"thread-11929":["thread",11929],"thread-11853":["thread",11853],"thread-11751":["thread",11751],"thread-11744":["thread",11744],"thread-11695":["thread",11695],"thread-11515":["thread",11515],"thread-11499":["thread",11499],"thread-11318":["thread",11318],"thread-11171":["thread",11171],"thread-11170":["thread",11170],"thread-11146":["thread",11146],"thread-11127":["thread",11127],"thread-11118":["thread",11118],"thread-10921":["thread",10921],"thread-10790":["thread",10790],"thread-10771":["thread",10771],"thread-10743":["thread",10743],"thread-10618":["thread",10618],"thread-10553":["thread",10553],"thread-10534":["thread",10534],"thread-10532":["thread",10532],"thread-10478":["thread",10478],"thread-10444":["thread",10444],"thread-10323":["thread",10323],"thread-10309":["thread",10309],"thread-10292":["thread",10292],"thread-10269":["thread",10269],"thread-10112":["thread",10112],"thread-10053":["thread",10053],"thread-9969":["thread",9969],"thread-9720":["thread",9720],"thread-9715":["thread",9715],"thread-9595":["thread",9595],"thread-9384":["thread",9384],"thread-9275":["thread",9275],"thread-9207":["thread",9207],"thread-9103":["thread",9103],"thread-9085":["thread",9085],"thread-8943":["thread",8943],"thread-8931":["thread",8931],"thread-8869":["thread",8869],"thread-8843":["thread",8843],"thread-8825":["thread",8825],"thread-8576":["thread",8576],"thread-8456":["thread",8456],"thread-8042":["thread",8042],"thread-7409":["thread",7409],"thread-7087":["thread",7087],"thread-7066":["thread",7066],"thread-6857":["thread",6857],"thread-6592":["thread",6592],"thread-6323":["thread",6323],"thread-6008":["thread",6008],"thread-5905":["thread",5905],"thread-5890":["thread",5890],"thread-5711":["thread",5711],"thread-5504":["thread",5504],"thread-5036":["thread",5036],"thread-4890":["thread",4890],"thread-4884":["thread",4884],"thread-4762":["thread",4762],"thread-4446":["thread",4446],"thread-4222":["thread",4222],"thread-3951":["thread",3951],"thread-3928":["thread",3928],"thread-3908":["thread",3908],"thread-3861":["thread",3861],"thread-3594":["thread",3594],"thread-3293":["thread",3293],"thread-3062":["thread",3062],"thread-2779":["thread",2779],"thread-2642":["thread",2642],"thread-2598":["thread",2598],"thread-2571":["thread",2571],"thread-2570":["thread",2570],"thread-2418":["thread",2418],"thread-2150":["thread",2150],"thread-2084":["thread",2084],"thread-2047":["thread",2047],"thread-1972":["thread",1972],"thread-1916":["thread",1916],"thread-1902":["thread",1902],"thread-1777":["thread",1777],"thread-1662":["thread",1662],"thread-1586":["thread",1586],"thread-1420":["thread",1420],"thread-1167":["thread",1167],"thread-835":["thread",835],"thread-766":["thread",766],"thread-701":["thread",701],"thread-654":["thread",654],"thread-539":["thread",539],"thread-375":["thread",375]}, NULL, 1714740450
Run Time: 0.000540
- 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