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 (115773, 115649, 115148, 112067, 112009, 111799, 111706, 111621, 111607, 111484, 111460, 111314, 110806, 110181, 108978, 107170, 107169, 107118, 107117, 107115, 107033, 106990, 106790, 106747, 106746, 106577, 106260, 105978, 105972, 105967, 105966, 105871, 105866, 105863, 105861, 105840, 105836, 105809, 105764, 105625, 105623, 105620, 105618, 105615, 105612, 105611, 105608, 105607, 105496, 105489, 105488, 105487, 105396, 105363, 105356, 105355, 105311, 105248, 105247, 105246, 105235, 105229, 105151, 104985, 104907, 104872, 104828, 104730, 104729, 104698, 104627, 104616, 104614, 104572, 104475, 104449, 104295, 104293, 104287, 104193, 104132, 104059, 104034, 103968, 103805, 103760, 103744, 103475, 103474))
Run Time: 0.053091
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 89 | 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: 24035, 0, 1714893525, {"thread-115773":["thread",115773],"thread-115649":["thread",115649],"thread-115148":["thread",115148],"thread-112067":["thread",112067],"thread-112009":["thread",112009],"thread-111799":["thread",111799],"thread-111706":["thread",111706],"thread-111621":["thread",111621],"thread-111607":["thread",111607],"thread-111484":["thread",111484],"thread-111460":["thread",111460],"thread-111314":["thread",111314],"thread-110806":["thread",110806],"thread-110181":["thread",110181],"thread-108978":["thread",108978],"thread-107170":["thread",107170],"thread-107169":["thread",107169],"thread-107118":["thread",107118],"thread-107117":["thread",107117],"thread-107115":["thread",107115],"thread-107033":["thread",107033],"thread-106990":["thread",106990],"thread-106790":["thread",106790],"thread-106747":["thread",106747],"thread-106746":["thread",106746],"thread-106577":["thread",106577],"thread-106260":["thread",106260],"thread-105978":["thread",105978],"thread-105972":["thread",105972],"thread-105967":["thread",105967],"thread-105966":["thread",105966],"thread-105871":["thread",105871],"thread-105866":["thread",105866],"thread-105863":["thread",105863],"thread-105861":["thread",105861],"thread-105840":["thread",105840],"thread-105836":["thread",105836],"thread-105809":["thread",105809],"thread-105764":["thread",105764],"thread-105625":["thread",105625],"thread-105623":["thread",105623],"thread-105620":["thread",105620],"thread-105618":["thread",105618],"thread-105615":["thread",105615],"thread-105612":["thread",105612],"thread-105611":["thread",105611],"thread-105608":["thread",105608],"thread-105607":["thread",105607],"thread-105496":["thread",105496],"thread-105489":["thread",105489],"thread-105488":["thread",105488],"thread-105487":["thread",105487],"thread-105396":["thread",105396],"thread-105363":["thread",105363],"thread-105356":["thread",105356],"thread-105355":["thread",105355],"thread-105311":["thread",105311],"thread-105248":["thread",105248],"thread-105247":["thread",105247],"thread-105246":["thread",105246],"thread-105235":["thread",105235],"thread-105229":["thread",105229],"thread-105151":["thread",105151],"thread-104985":["thread",104985],"thread-104907":["thread",104907],"thread-104872":["thread",104872],"thread-104828":["thread",104828],"thread-104730":["thread",104730],"thread-104729":["thread",104729],"thread-104698":["thread",104698],"thread-104627":["thread",104627],"thread-104616":["thread",104616],"thread-104614":["thread",104614],"thread-104572":["thread",104572],"thread-104475":["thread",104475],"thread-104449":["thread",104449],"thread-104295":["thread",104295],"thread-104293":["thread",104293],"thread-104287":["thread",104287],"thread-104193":["thread",104193],"thread-104132":["thread",104132],"thread-104059":["thread",104059],"thread-104034":["thread",104034],"thread-103968":["thread",103968],"thread-103805":["thread",103805],"thread-103760":["thread",103760],"thread-103744":["thread",103744],"thread-103475":["thread",103475],"thread-103474":["thread",103474]}, , 1714889925
Run Time: 0.000213
- 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