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 (182693, 182293, 181923, 178702, 178411, 178083, 175334, 175127, 174207, 171963, 168488, 166254, 166141, 165928, 164897, 164446, 163957, 163945, 163938, 163789, 163677, 161540, 161531, 161441, 160876, 160402, 160161, 157493, 155693, 155372, 154630, 154478, 154313, 153636, 153445, 152625, 152221, 152190, 151924, 151813, 146642, 135408, 131655, 131513, 114892, 113357, 112175, 111916, 111901, 110308, 110279, 110154, 107587, 105220, 105140, 104916, 101903, 98149, 93918, 87994, 75683, 75012, 75010, 74735, 74643, 70035, 66873, 64703, 51540, 46483, 40948, 27212))
Run Time: 0.038779
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 72 | 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: 3596, 0, 1716094307, {"thread-182693":["thread",182693],"thread-182293":["thread",182293],"thread-181923":["thread",181923],"thread-178702":["thread",178702],"thread-178411":["thread",178411],"thread-178083":["thread",178083],"thread-175334":["thread",175334],"thread-175127":["thread",175127],"thread-174207":["thread",174207],"thread-171963":["thread",171963],"thread-168488":["thread",168488],"thread-166254":["thread",166254],"thread-166141":["thread",166141],"thread-165928":["thread",165928],"thread-164897":["thread",164897],"thread-164446":["thread",164446],"thread-163957":["thread",163957],"thread-163945":["thread",163945],"thread-163938":["thread",163938],"thread-163789":["thread",163789],"thread-163677":["thread",163677],"thread-161540":["thread",161540],"thread-161531":["thread",161531],"thread-161441":["thread",161441],"thread-160876":["thread",160876],"thread-160402":["thread",160402],"thread-160161":["thread",160161],"thread-157493":["thread",157493],"thread-155693":["thread",155693],"thread-155372":["thread",155372],"thread-154630":["thread",154630],"thread-154478":["thread",154478],"thread-154313":["thread",154313],"thread-153636":["thread",153636],"thread-153445":["thread",153445],"thread-152625":["thread",152625],"thread-152221":["thread",152221],"thread-152190":["thread",152190],"thread-151924":["thread",151924],"thread-151813":["thread",151813],"thread-146642":["thread",146642],"thread-135408":["thread",135408],"thread-131655":["thread",131655],"thread-131513":["thread",131513],"thread-114892":["thread",114892],"thread-113357":["thread",113357],"thread-112175":["thread",112175],"thread-111916":["thread",111916],"thread-111901":["thread",111901],"thread-110308":["thread",110308],"thread-110279":["thread",110279],"thread-110154":["thread",110154],"thread-107587":["thread",107587],"thread-105220":["thread",105220],"thread-105140":["thread",105140],"thread-104916":["thread",104916],"thread-101903":["thread",101903],"thread-98149":["thread",98149],"thread-93918":["thread",93918],"thread-87994":["thread",87994],"thread-75683":["thread",75683],"thread-75012":["thread",75012],"thread-75010":["thread",75010],"thread-74735":["thread",74735],"thread-74643":["thread",74643],"thread-70035":["thread",70035],"thread-66873":["thread",66873],"thread-64703":["thread",64703],"thread-51540":["thread",51540],"thread-46483":["thread",46483],"thread-40948":["thread",40948],"thread-27212":["thread",27212]}, , 1716090707
Run Time: 0.000458
- 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