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 (7212168, 7209254, 7203709, 7125224, 7114285, 7107676, 7106478, 7093997, 7079593, 7072620, 7068279, 7066983, 6983806, 6975018, 6968557, 6956681, 222430, 196779, 188853, 60547, 13763, 13531, 13369, 13211, 13188, 13151, 13131, 12913, 12639, 12550, 12486, 12360, 12191, 11957, 11904, 11770, 11767, 11766, 11753, 11708, 11703, 11439, 11196, 11051, 11042, 10993, 10987, 10933, 10672, 10470, 10382, 9757, 9750, 9716, 9641, 9608, 9385, 9022, 8842, 8603, 8563, 8557, 8537, 8495, 8463, 8460, 8088, 7274, 7054, 6780, 6766, 6640, 6601, 6598, 6269, 6098, 5576, 5212, 4717, 4327, 4198, 4133, 3863, 3789, 3633, 3475, 3448, 3374, 3371, 3354, 3294, 3273, 3271, 3192, 3121, 3117, 3026, 2918, 2477, 2144, 2009, 1787, 1670, 1482, 1109, 1074, 815, 278))
Run Time: 0.006188
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 108 | 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: 264, 0, 1714541908, {"thread-7212168":["thread",7212168],"thread-7209254":["thread",7209254],"thread-7203709":["thread",7203709],"thread-7125224":["thread",7125224],"thread-7114285":["thread",7114285],"thread-7107676":["thread",7107676],"thread-7106478":["thread",7106478],"thread-7093997":["thread",7093997],"thread-7079593":["thread",7079593],"thread-7072620":["thread",7072620],"thread-7068279":["thread",7068279],"thread-7066983":["thread",7066983],"thread-6983806":["thread",6983806],"thread-6975018":["thread",6975018],"thread-6968557":["thread",6968557],"thread-6956681":["thread",6956681],"thread-222430":["thread",222430],"thread-196779":["thread",196779],"thread-188853":["thread",188853],"thread-60547":["thread",60547],"thread-13763":["thread",13763],"thread-13531":["thread",13531],"thread-13369":["thread",13369],"thread-13211":["thread",13211],"thread-13188":["thread",13188],"thread-13151":["thread",13151],"thread-13131":["thread",13131],"thread-12913":["thread",12913],"thread-12639":["thread",12639],"thread-12550":["thread",12550],"thread-12486":["thread",12486],"thread-12360":["thread",12360],"thread-12191":["thread",12191],"thread-11957":["thread",11957],"thread-11904":["thread",11904],"thread-11770":["thread",11770],"thread-11767":["thread",11767],"thread-11766":["thread",11766],"thread-11753":["thread",11753],"thread-11708":["thread",11708],"thread-11703":["thread",11703],"thread-11439":["thread",11439],"thread-11196":["thread",11196],"thread-11051":["thread",11051],"thread-11042":["thread",11042],"thread-10993":["thread",10993],"thread-10987":["thread",10987],"thread-10933":["thread",10933],"thread-10672":["thread",10672],"thread-10470":["thread",10470],"thread-10382":["thread",10382],"thread-9757":["thread",9757],"thread-9750":["thread",9750],"thread-9716":["thread",9716],"thread-9641":["thread",9641],"thread-9608":["thread",9608],"thread-9385":["thread",9385],"thread-9022":["thread",9022],"thread-8842":["thread",8842],"thread-8603":["thread",8603],"thread-8563":["thread",8563],"thread-8557":["thread",8557],"thread-8537":["thread",8537],"thread-8495":["thread",8495],"thread-8463":["thread",8463],"thread-8460":["thread",8460],"thread-8088":["thread",8088],"thread-7274":["thread",7274],"thread-7054":["thread",7054],"thread-6780":["thread",6780],"thread-6766":["thread",6766],"thread-6640":["thread",6640],"thread-6601":["thread",6601],"thread-6598":["thread",6598],"thread-6269":["thread",6269],"thread-6098":["thread",6098],"thread-5576":["thread",5576],"thread-5212":["thread",5212],"thread-4717":["thread",4717],"thread-4327":["thread",4327],"thread-4198":["thread",4198],"thread-4133":["thread",4133],"thread-3863":["thread",3863],"thread-3789":["thread",3789],"thread-3633":["thread",3633],"thread-3475":["thread",3475],"thread-3448":["thread",3448],"thread-3374":["thread",3374],"thread-3371":["thread",3371],"thread-3354":["thread",3354],"thread-3294":["thread",3294],"thread-3273":["thread",3273],"thread-3271":["thread",3271],"thread-3192":["thread",3192],"thread-3121":["thread",3121],"thread-3117":["thread",3117],"thread-3026":["thread",3026],"thread-2918":["thread",2918],"thread-2477":["thread",2477],"thread-2144":["thread",2144],"thread-2009":["thread",2009],"thread-1787":["thread",1787],"thread-1670":["thread",1670],"thread-1482":["thread",1482],"thread-1109":["thread",1109],"thread-1074":["thread",1074],"thread-815":["thread",815],"thread-278":["thread",278]}, NULL, 1714538308
Run Time: 0.000594
- 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