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 (12017, 11427, 11411, 11314, 11305, 10749, 10490, 10341, 10140, 9962, 9811, 9742, 9682, 9550, 9161, 8959, 8525, 8500, 8396, 8349, 7821, 7417, 7407, 7306, 7154, 6893, 6580, 6343, 6189, 6181, 5898, 5880, 5834, 5709, 5686, 5657, 5621, 5437, 5362, 5255, 5196, 5121, 4847, 4829, 4744, 4723, 4690, 4631, 4506, 4497, 4344, 4340, 4287, 4201, 4186, 4150, 4103, 4098, 4088, 3883, 3847, 3633, 3578, 3577, 3319, 3195, 3125, 3106, 3064, 2962, 2894, 2876, 2866, 2865, 2806, 2629, 2626, 923, 861, 855, 842, 752, 719, 692, 640, 527, 495, 417, 397, 371, 357, 315, 150))
Run Time: 0.004141
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 93 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xencybim.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xencybim.xf_forum_Forum_1.node_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xencybim.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xencybim.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,admin_xencybim.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 1387
- 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 2729
- 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 137
- 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 2351
- XF\App->run() in src/XF.php at line 517
- 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: 308, 0, 1715934728, {"thread-12017":["thread",12017],"thread-11427":["thread",11427],"thread-11411":["thread",11411],"thread-11314":["thread",11314],"thread-11305":["thread",11305],"thread-10749":["thread",10749],"thread-10490":["thread",10490],"thread-10341":["thread",10341],"thread-10140":["thread",10140],"thread-9962":["thread",9962],"thread-9811":["thread",9811],"thread-9742":["thread",9742],"thread-9682":["thread",9682],"thread-9550":["thread",9550],"thread-9161":["thread",9161],"thread-8959":["thread",8959],"thread-8525":["thread",8525],"thread-8500":["thread",8500],"thread-8396":["thread",8396],"thread-8349":["thread",8349],"thread-7821":["thread",7821],"thread-7417":["thread",7417],"thread-7407":["thread",7407],"thread-7306":["thread",7306],"thread-7154":["thread",7154],"thread-6893":["thread",6893],"thread-6580":["thread",6580],"thread-6343":["thread",6343],"thread-6189":["thread",6189],"thread-6181":["thread",6181],"thread-5898":["thread",5898],"thread-5880":["thread",5880],"thread-5834":["thread",5834],"thread-5709":["thread",5709],"thread-5686":["thread",5686],"thread-5657":["thread",5657],"thread-5621":["thread",5621],"thread-5437":["thread",5437],"thread-5362":["thread",5362],"thread-5255":["thread",5255],"thread-5196":["thread",5196],"thread-5121":["thread",5121],"thread-4847":["thread",4847],"thread-4829":["thread",4829],"thread-4744":["thread",4744],"thread-4723":["thread",4723],"thread-4690":["thread",4690],"thread-4631":["thread",4631],"thread-4506":["thread",4506],"thread-4497":["thread",4497],"thread-4344":["thread",4344],"thread-4340":["thread",4340],"thread-4287":["thread",4287],"thread-4201":["thread",4201],"thread-4186":["thread",4186],"thread-4150":["thread",4150],"thread-4103":["thread",4103],"thread-4098":["thread",4098],"thread-4088":["thread",4088],"thread-3883":["thread",3883],"thread-3847":["thread",3847],"thread-3633":["thread",3633],"thread-3578":["thread",3578],"thread-3577":["thread",3577],"thread-3319":["thread",3319],"thread-3195":["thread",3195],"thread-3125":["thread",3125],"thread-3106":["thread",3106],"thread-3064":["thread",3064],"thread-2962":["thread",2962],"thread-2894":["thread",2894],"thread-2876":["thread",2876],"thread-2866":["thread",2866],"thread-2865":["thread",2865],"thread-2806":["thread",2806],"thread-2629":["thread",2629],"thread-2626":["thread",2626],"thread-923":["thread",923],"thread-861":["thread",861],"thread-855":["thread",855],"thread-842":["thread",842],"thread-752":["thread",752],"thread-719":["thread",719],"thread-692":["thread",692],"thread-640":["thread",640],"thread-527":["thread",527],"thread-495":["thread",495],"thread-417":["thread",417],"thread-397":["thread",397],"thread-371":["thread",371],"thread-357":["thread",357],"thread-315":["thread",315],"thread-150":["thread",150]}, , 1715931128
Run Time: 0.000220
- 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 1514
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1246
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 150
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20