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 (182146, 117083, 117076, 117038, 114212, 113656, 112522, 112054, 111868, 111691, 111664, 111650, 111649, 111647, 109267, 108650, 108468, 108320, 108080, 107129, 107103, 106804, 105896, 105833, 103900, 103032, 100524, 99592, 96372, 95009, 94472, 91317, 90859, 90284, 90073, 89298, 87216, 85764, 83069, 82530, 82382, 81558, 80897, 80048, 79412, 78855, 76627, 75910, 75712, 75506, 74414, 74407, 73265, 73260, 69597, 68004, 67642, 66157, 66061, 66060, 65968, 65948, 64186, 61196, 60691, 57750, 57614, 57613, 57608, 57522, 57517, 56872, 56821, 56730, 56717, 56713, 56664, 56614, 56574, 56529, 56443, 56305, 53986))
Run Time: 0.044993
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 83 | 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: 9462, 0, 1716123587, {"thread-182146":["thread",182146],"thread-117083":["thread",117083],"thread-117076":["thread",117076],"thread-117038":["thread",117038],"thread-114212":["thread",114212],"thread-113656":["thread",113656],"thread-112522":["thread",112522],"thread-112054":["thread",112054],"thread-111868":["thread",111868],"thread-111691":["thread",111691],"thread-111664":["thread",111664],"thread-111650":["thread",111650],"thread-111649":["thread",111649],"thread-111647":["thread",111647],"thread-109267":["thread",109267],"thread-108650":["thread",108650],"thread-108468":["thread",108468],"thread-108320":["thread",108320],"thread-108080":["thread",108080],"thread-107129":["thread",107129],"thread-107103":["thread",107103],"thread-106804":["thread",106804],"thread-105896":["thread",105896],"thread-105833":["thread",105833],"thread-103900":["thread",103900],"thread-103032":["thread",103032],"thread-100524":["thread",100524],"thread-99592":["thread",99592],"thread-96372":["thread",96372],"thread-95009":["thread",95009],"thread-94472":["thread",94472],"thread-91317":["thread",91317],"thread-90859":["thread",90859],"thread-90284":["thread",90284],"thread-90073":["thread",90073],"thread-89298":["thread",89298],"thread-87216":["thread",87216],"thread-85764":["thread",85764],"thread-83069":["thread",83069],"thread-82530":["thread",82530],"thread-82382":["thread",82382],"thread-81558":["thread",81558],"thread-80897":["thread",80897],"thread-80048":["thread",80048],"thread-79412":["thread",79412],"thread-78855":["thread",78855],"thread-76627":["thread",76627],"thread-75910":["thread",75910],"thread-75712":["thread",75712],"thread-75506":["thread",75506],"thread-74414":["thread",74414],"thread-74407":["thread",74407],"thread-73265":["thread",73265],"thread-73260":["thread",73260],"thread-69597":["thread",69597],"thread-68004":["thread",68004],"thread-67642":["thread",67642],"thread-66157":["thread",66157],"thread-66061":["thread",66061],"thread-66060":["thread",66060],"thread-65968":["thread",65968],"thread-65948":["thread",65948],"thread-64186":["thread",64186],"thread-61196":["thread",61196],"thread-60691":["thread",60691],"thread-57750":["thread",57750],"thread-57614":["thread",57614],"thread-57613":["thread",57613],"thread-57608":["thread",57608],"thread-57522":["thread",57522],"thread-57517":["thread",57517],"thread-56872":["thread",56872],"thread-56821":["thread",56821],"thread-56730":["thread",56730],"thread-56717":["thread",56717],"thread-56713":["thread",56713],"thread-56664":["thread",56664],"thread-56614":["thread",56614],"thread-56574":["thread",56574],"thread-56529":["thread",56529],"thread-56443":["thread",56443],"thread-56305":["thread",56305],"thread-53986":["thread",53986]}, , 1716119987
Run Time: 0.000370
- 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