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 (183783, 182945, 182919, 181946, 181155, 181007, 180654, 180653, 178874, 178347, 178160, 175922, 174531, 173758, 173513, 173450, 172577, 172365, 169208, 166706, 166689, 160613, 158115, 154838, 151813, 148299, 145577, 141301, 140816, 136898, 131701, 131466, 129766, 129626, 129227, 126278, 124086, 122621, 122508, 120970, 120249, 118638, 118379, 114798, 113937, 113693, 113599, 107292, 105325, 104619, 104306, 97804, 96366, 94807, 93994, 93941, 89720, 72941, 64815, 64084, 60556, 60552, 56643, 55073, 46483, 46083, 17981, 16467))
Run Time: 0.035988
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 68 | 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: 2327, 0, 1716620745, {"thread-183783":["thread",183783],"thread-182945":["thread",182945],"thread-182919":["thread",182919],"thread-181946":["thread",181946],"thread-181155":["thread",181155],"thread-181007":["thread",181007],"thread-180654":["thread",180654],"thread-180653":["thread",180653],"thread-178874":["thread",178874],"thread-178347":["thread",178347],"thread-178160":["thread",178160],"thread-175922":["thread",175922],"thread-174531":["thread",174531],"thread-173758":["thread",173758],"thread-173513":["thread",173513],"thread-173450":["thread",173450],"thread-172577":["thread",172577],"thread-172365":["thread",172365],"thread-169208":["thread",169208],"thread-166706":["thread",166706],"thread-166689":["thread",166689],"thread-160613":["thread",160613],"thread-158115":["thread",158115],"thread-154838":["thread",154838],"thread-151813":["thread",151813],"thread-148299":["thread",148299],"thread-145577":["thread",145577],"thread-141301":["thread",141301],"thread-140816":["thread",140816],"thread-136898":["thread",136898],"thread-131701":["thread",131701],"thread-131466":["thread",131466],"thread-129766":["thread",129766],"thread-129626":["thread",129626],"thread-129227":["thread",129227],"thread-126278":["thread",126278],"thread-124086":["thread",124086],"thread-122621":["thread",122621],"thread-122508":["thread",122508],"thread-120970":["thread",120970],"thread-120249":["thread",120249],"thread-118638":["thread",118638],"thread-118379":["thread",118379],"thread-114798":["thread",114798],"thread-113937":["thread",113937],"thread-113693":["thread",113693],"thread-113599":["thread",113599],"thread-107292":["thread",107292],"thread-105325":["thread",105325],"thread-104619":["thread",104619],"thread-104306":["thread",104306],"thread-97804":["thread",97804],"thread-96366":["thread",96366],"thread-94807":["thread",94807],"thread-93994":["thread",93994],"thread-93941":["thread",93941],"thread-89720":["thread",89720],"thread-72941":["thread",72941],"thread-64815":["thread",64815],"thread-64084":["thread",64084],"thread-60556":["thread",60556],"thread-60552":["thread",60552],"thread-56643":["thread",56643],"thread-55073":["thread",55073],"thread-46483":["thread",46483],"thread-46083":["thread",46083],"thread-17981":["thread",17981],"thread-16467":["thread",16467]}, , 1716617145
Run Time: 0.000176
- 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