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 (182997, 182522, 180406, 179093, 178435, 178267, 177725, 176313, 175247, 175241, 175236, 172159, 170393, 170128, 170016, 169476, 169406, 168446, 166585, 165836, 163229, 162906, 161620, 161017, 160984, 160904, 160067, 160000, 159023, 156811, 156721, 156567, 156142, 155094, 153893, 153312, 151725, 130752, 129929, 125628, 123635, 123555, 122635, 121163, 115822, 115752, 115224, 115113, 114616, 107633, 96191, 76886, 41763, 16854, 1432))
Run Time: 0.043945
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 55 | 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: 382, 0, 1716009987, {"thread-182997":["thread",182997],"thread-182522":["thread",182522],"thread-180406":["thread",180406],"thread-179093":["thread",179093],"thread-178435":["thread",178435],"thread-178267":["thread",178267],"thread-177725":["thread",177725],"thread-176313":["thread",176313],"thread-175247":["thread",175247],"thread-175241":["thread",175241],"thread-175236":["thread",175236],"tl_group-306":["tl_group",306],"thread-172159":["thread",172159],"thread-170393":["thread",170393],"thread-170128":["thread",170128],"thread-170016":["thread",170016],"thread-169476":["thread",169476],"thread-169406":["thread",169406],"thread-168446":["thread",168446],"thread-166585":["thread",166585],"thread-165836":["thread",165836],"thread-163229":["thread",163229],"thread-162906":["thread",162906],"thread-161620":["thread",161620],"thread-161017":["thread",161017],"thread-160984":["thread",160984],"thread-160904":["thread",160904],"thread-160067":["thread",160067],"thread-160000":["thread",160000],"thread-159023":["thread",159023],"thread-156811":["thread",156811],"thread-156721":["thread",156721],"thread-156567":["thread",156567],"thread-156142":["thread",156142],"thread-155094":["thread",155094],"thread-153893":["thread",153893],"thread-153312":["thread",153312],"thread-151725":["thread",151725],"thread-130752":["thread",130752],"thread-129929":["thread",129929],"thread-125628":["thread",125628],"thread-123635":["thread",123635],"thread-123555":["thread",123555],"thread-122635":["thread",122635],"thread-121163":["thread",121163],"thread-115822":["thread",115822],"thread-115752":["thread",115752],"thread-115224":["thread",115224],"thread-115113":["thread",115113],"thread-114616":["thread",114616],"thread-107633":["thread",107633],"thread-96191":["thread",96191],"thread-76886":["thread",76886],"thread-41763":["thread",41763],"thread-16854":["thread",16854],"thread-1432":["thread",1432]}, , 1716006387
Run Time: 0.000903
- 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