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 (182171, 181958, 180171, 179724, 179204, 177571, 172653, 172603, 168928, 168258, 167511, 166092, 165099, 164953, 164875, 164873, 163906, 163742, 162915, 161455, 159693, 158575, 156340, 152676, 138005, 126380, 122018, 122017, 121062, 118128, 117143, 111094, 102218, 101002, 97167, 90974, 90894, 87172, 86763, 74566, 73652, 71327, 67945, 66973, 65420, 61269, 49904, 49262, 48496, 46142, 40625, 38113, 27848, 19965, 13547, 9695, 3738))
Run Time: 0.035130
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 57 | 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: 2069, 0, 1715212550, {"thread-182171":["thread",182171],"thread-181958":["thread",181958],"thread-180171":["thread",180171],"thread-179724":["thread",179724],"thread-179204":["thread",179204],"thread-177571":["thread",177571],"thread-172653":["thread",172653],"thread-172603":["thread",172603],"thread-168928":["thread",168928],"thread-168258":["thread",168258],"thread-167511":["thread",167511],"thread-166092":["thread",166092],"thread-165099":["thread",165099],"thread-164953":["thread",164953],"thread-164875":["thread",164875],"thread-164873":["thread",164873],"thread-163906":["thread",163906],"thread-163742":["thread",163742],"thread-162915":["thread",162915],"thread-161455":["thread",161455],"thread-159693":["thread",159693],"thread-158575":["thread",158575],"thread-156340":["thread",156340],"thread-152676":["thread",152676],"thread-138005":["thread",138005],"thread-126380":["thread",126380],"thread-122018":["thread",122018],"thread-122017":["thread",122017],"thread-121062":["thread",121062],"thread-118128":["thread",118128],"thread-117143":["thread",117143],"thread-111094":["thread",111094],"thread-102218":["thread",102218],"thread-101002":["thread",101002],"thread-97167":["thread",97167],"thread-90974":["thread",90974],"thread-90894":["thread",90894],"thread-87172":["thread",87172],"thread-86763":["thread",86763],"thread-74566":["thread",74566],"thread-73652":["thread",73652],"thread-71327":["thread",71327],"thread-67945":["thread",67945],"thread-66973":["thread",66973],"thread-65420":["thread",65420],"thread-61269":["thread",61269],"thread-49904":["thread",49904],"thread-49262":["thread",49262],"thread-48496":["thread",48496],"thread-46142":["thread",46142],"thread-40625":["thread",40625],"thread-38113":["thread",38113],"thread-27848":["thread",27848],"thread-19965":["thread",19965],"thread-13547":["thread",13547],"thread-9695":["thread",9695],"thread-3738":["thread",3738]}, , 1715208950
Run Time: 0.000928
- 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