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 (138651, 131689, 131270, 131241, 130748, 130741, 130672, 130424, 130419, 130359, 130348, 130252, 130248, 129242, 128015, 127976, 127789, 127730, 127725, 127714, 127707, 127385, 124643, 123442, 123298, 123276, 123216, 123214, 123160, 123156, 123147, 123141, 123106, 123105, 123104, 122430, 122428, 122367, 122356, 122347, 122315, 122310, 122227, 122028, 121751, 121667, 121655, 121650, 121642, 121618, 121616, 121580, 121575, 121515, 121502, 121477, 121425, 121160, 121159, 121124, 121030, 120821, 120654, 120652, 120363, 120354, 120328, 119311, 113331, 113127, 112981, 112786, 112440, 112401, 112158, 112116, 112113, 112039, 111568, 111517, 111452, 111363, 111362, 111217, 111027, 110248, 107986, 107869, 107857, 107813, 107457, 107432, 105878, 105641, 105637, 105634, 105133, 104948, 104679, 104612))
Run Time: 0.056383
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 100 | 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: 24434, 0, 1716153383, {"thread-138651":["thread",138651],"thread-131689":["thread",131689],"thread-131270":["thread",131270],"thread-131241":["thread",131241],"thread-130748":["thread",130748],"thread-130741":["thread",130741],"thread-130672":["thread",130672],"thread-130424":["thread",130424],"thread-130419":["thread",130419],"thread-130359":["thread",130359],"thread-130348":["thread",130348],"thread-130252":["thread",130252],"thread-130248":["thread",130248],"thread-129242":["thread",129242],"thread-128015":["thread",128015],"thread-127976":["thread",127976],"thread-127789":["thread",127789],"thread-127730":["thread",127730],"thread-127725":["thread",127725],"thread-127714":["thread",127714],"thread-127707":["thread",127707],"thread-127385":["thread",127385],"thread-124643":["thread",124643],"thread-123442":["thread",123442],"thread-123298":["thread",123298],"thread-123276":["thread",123276],"thread-123216":["thread",123216],"thread-123214":["thread",123214],"thread-123160":["thread",123160],"thread-123156":["thread",123156],"thread-123147":["thread",123147],"thread-123141":["thread",123141],"thread-123106":["thread",123106],"thread-123105":["thread",123105],"thread-123104":["thread",123104],"thread-122430":["thread",122430],"thread-122428":["thread",122428],"thread-122367":["thread",122367],"thread-122356":["thread",122356],"thread-122347":["thread",122347],"thread-122315":["thread",122315],"thread-122310":["thread",122310],"thread-122227":["thread",122227],"thread-122028":["thread",122028],"thread-121751":["thread",121751],"thread-121667":["thread",121667],"thread-121655":["thread",121655],"thread-121650":["thread",121650],"thread-121642":["thread",121642],"thread-121618":["thread",121618],"thread-121616":["thread",121616],"thread-121580":["thread",121580],"thread-121575":["thread",121575],"thread-121515":["thread",121515],"thread-121502":["thread",121502],"thread-121477":["thread",121477],"thread-121425":["thread",121425],"thread-121160":["thread",121160],"thread-121159":["thread",121159],"thread-121124":["thread",121124],"thread-121030":["thread",121030],"thread-120821":["thread",120821],"thread-120654":["thread",120654],"thread-120652":["thread",120652],"thread-120363":["thread",120363],"thread-120354":["thread",120354],"thread-120328":["thread",120328],"thread-119311":["thread",119311],"thread-113331":["thread",113331],"thread-113127":["thread",113127],"thread-112981":["thread",112981],"thread-112786":["thread",112786],"thread-112440":["thread",112440],"thread-112401":["thread",112401],"thread-112158":["thread",112158],"thread-112116":["thread",112116],"thread-112113":["thread",112113],"thread-112039":["thread",112039],"thread-111568":["thread",111568],"thread-111517":["thread",111517],"thread-111452":["thread",111452],"thread-111363":["thread",111363],"thread-111362":["thread",111362],"thread-111217":["thread",111217],"thread-111027":["thread",111027],"thread-110248":["thread",110248],"thread-107986":["thread",107986],"thread-107869":["thread",107869],"thread-107857":["thread",107857],"thread-107813":["thread",107813],"thread-107457":["thread",107457],"thread-107432":["thread",107432],"thread-105878":["thread",105878],"thread-105641":["thread",105641],"thread-105637":["thread",105637],"thread-105634":["thread",105634],"thread-105133":["thread",105133],"thread-104948":["thread",104948],"thread-104679":["thread",104679],"thread-104612":["thread",104612]}, , 1716149783
Run Time: 0.000348
- 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