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 (180104, 180103, 180101, 132972, 131529, 130812, 130811, 130303, 129727, 128100, 127196, 127132, 126574, 126512, 126178, 125580, 125150, 125093, 124969, 124607, 124468, 123544, 123086, 122655, 121605, 121227, 119434, 118893, 118457, 118327, 118326, 118249, 118204, 118003, 117858, 117676, 117494, 117386, 117325, 116945, 116783, 116781, 116401, 116270, 116260, 116160, 115989, 115841, 115737, 115688, 114576, 114181, 113845, 113533, 113092, 112123, 111643, 111322, 110910, 110753, 110049, 109482, 108315, 108006, 106976, 104743, 104713))
Run Time: 0.066977
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 67 | 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: 25705, 0, 1714912871, {"thread-180104":["thread",180104],"thread-180103":["thread",180103],"thread-180101":["thread",180101],"thread-132972":["thread",132972],"thread-131529":["thread",131529],"thread-130812":["thread",130812],"thread-130811":["thread",130811],"thread-130303":["thread",130303],"thread-129727":["thread",129727],"thread-128100":["thread",128100],"thread-127196":["thread",127196],"thread-127132":["thread",127132],"thread-126574":["thread",126574],"thread-126512":["thread",126512],"thread-126178":["thread",126178],"thread-125580":["thread",125580],"thread-125150":["thread",125150],"thread-125093":["thread",125093],"thread-124969":["thread",124969],"thread-124607":["thread",124607],"thread-124468":["thread",124468],"thread-123544":["thread",123544],"thread-123086":["thread",123086],"thread-122655":["thread",122655],"thread-121605":["thread",121605],"thread-121227":["thread",121227],"thread-119434":["thread",119434],"thread-118893":["thread",118893],"thread-118457":["thread",118457],"thread-118327":["thread",118327],"thread-118326":["thread",118326],"thread-118249":["thread",118249],"thread-118204":["thread",118204],"thread-118003":["thread",118003],"thread-117858":["thread",117858],"thread-117676":["thread",117676],"thread-117494":["thread",117494],"thread-117386":["thread",117386],"thread-117325":["thread",117325],"thread-116945":["thread",116945],"thread-116783":["thread",116783],"thread-116781":["thread",116781],"thread-116401":["thread",116401],"thread-116270":["thread",116270],"thread-116260":["thread",116260],"thread-116160":["thread",116160],"thread-115989":["thread",115989],"thread-115841":["thread",115841],"thread-115737":["thread",115737],"thread-115688":["thread",115688],"thread-114576":["thread",114576],"thread-114181":["thread",114181],"thread-113845":["thread",113845],"thread-113533":["thread",113533],"thread-113092":["thread",113092],"thread-112123":["thread",112123],"thread-111643":["thread",111643],"thread-111322":["thread",111322],"thread-110910":["thread",110910],"thread-110753":["thread",110753],"thread-110049":["thread",110049],"thread-109482":["thread",109482],"thread-108315":["thread",108315],"thread-108006":["thread",108006],"thread-106976":["thread",106976],"thread-104743":["thread",104743],"thread-104713":["thread",104713]}, , 1714909271
Run Time: 0.000409
- 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