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 (183076, 122628, 121382, 110546, 103780, 69098, 51571, 50774, 50765, 50436, 38060, 36927, 36649, 36560, 33810, 33427, 32997, 32994, 30498, 29165, 29057, 28387, 28227, 28137, 27629, 27589, 27587, 27584, 27451, 26667, 26662, 26617, 26391, 26230, 26017, 25923, 25921, 25920, 25912, 25905, 25903, 25308, 25128, 24082, 23041, 23030, 22921, 22698, 18163, 17818, 17810, 17809, 17552, 17084, 16926, 14900, 14654, 13984, 11662, 3800))
Run Time: 0.035540
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 60 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,admin_xen.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: 892, 0, 1715804497, {"thread-183076":["thread",183076],"thread-122628":["thread",122628],"thread-121382":["thread",121382],"thread-110546":["thread",110546],"thread-103780":["thread",103780],"thread-69098":["thread",69098],"thread-51571":["thread",51571],"thread-50774":["thread",50774],"thread-50765":["thread",50765],"thread-50436":["thread",50436],"thread-38060":["thread",38060],"thread-36927":["thread",36927],"thread-36649":["thread",36649],"thread-36560":["thread",36560],"thread-33810":["thread",33810],"thread-33427":["thread",33427],"thread-32997":["thread",32997],"thread-32994":["thread",32994],"thread-30498":["thread",30498],"thread-29165":["thread",29165],"thread-29057":["thread",29057],"thread-28387":["thread",28387],"thread-28227":["thread",28227],"thread-28137":["thread",28137],"thread-27629":["thread",27629],"thread-27589":["thread",27589],"thread-27587":["thread",27587],"thread-27584":["thread",27584],"thread-27451":["thread",27451],"thread-26667":["thread",26667],"thread-26662":["thread",26662],"thread-26617":["thread",26617],"thread-26391":["thread",26391],"thread-26230":["thread",26230],"thread-26017":["thread",26017],"thread-25923":["thread",25923],"thread-25921":["thread",25921],"thread-25920":["thread",25920],"thread-25912":["thread",25912],"thread-25905":["thread",25905],"thread-25903":["thread",25903],"thread-25308":["thread",25308],"thread-25128":["thread",25128],"thread-24082":["thread",24082],"thread-23041":["thread",23041],"thread-23030":["thread",23030],"thread-22921":["thread",22921],"thread-22698":["thread",22698],"thread-18163":["thread",18163],"thread-17818":["thread",17818],"thread-17810":["thread",17810],"thread-17809":["thread",17809],"thread-17552":["thread",17552],"thread-17084":["thread",17084],"thread-16926":["thread",16926],"thread-14900":["thread",14900],"thread-14654":["thread",14654],"thread-13984":["thread",13984],"thread-11662":["thread",11662],"thread-3800":["thread",3800]}, , 1715800897
Run Time: 0.000359
- 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