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 (176895, 176680, 176679, 176652, 176650, 176649, 176648, 176624, 176623, 176622, 176547, 176542, 176354, 176353, 176333, 176320, 176319, 176318, 176301, 176296, 153856, 153333, 153316, 153279, 148382, 142660, 139350, 127169, 126868, 126867, 126423, 125519, 125242, 125239, 124582, 123893, 123505, 123202, 122460, 122068, 121385, 120495, 120425, 119360, 116966, 116804, 116786, 116304, 116291, 116097, 115884, 115837, 115675, 115111, 114930, 114497, 113676, 112685, 112475, 111810, 109127, 108880, 108358, 106850, 106465, 105316, 104779, 103471, 103461, 103293, 103203, 102330, 102243, 102206, 102189, 102109, 101290, 101268, 100660, 100394, 99025, 97891, 93986, 91835, 91831, 91778, 91732, 91682, 91567, 91520, 91381, 90261, 90130, 90069, 90056, 89702, 89505, 89456, 89227, 89226, 89127, 87194, 85760, 85735, 85725, 84800, 84744, 84731, 82271, 81742, 81595, 81593, 78515, 76359, 73795, 64403, 64012, 63451, 63434, 63247, 63241, 63133, 63106, 63011, 62776, 62774, 60758, 60332, 60156, 59985, 59488, 58862, 58211, 57310, 57298, 57216, 56243, 54631))
Run Time: 0.082468
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 138 | 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: 9008, 0, 1715911878, {"thread-176895":["thread",176895],"ams_article-5119":["ams_article",5119],"thread-176680":["thread",176680],"thread-176679":["thread",176679],"thread-176652":["thread",176652],"thread-176650":["thread",176650],"thread-176649":["thread",176649],"thread-176648":["thread",176648],"thread-176624":["thread",176624],"thread-176623":["thread",176623],"thread-176622":["thread",176622],"thread-176547":["thread",176547],"thread-176542":["thread",176542],"thread-176354":["thread",176354],"thread-176353":["thread",176353],"thread-176333":["thread",176333],"thread-176320":["thread",176320],"thread-176319":["thread",176319],"thread-176318":["thread",176318],"thread-176301":["thread",176301],"thread-176296":["thread",176296],"ams_article-5106":["ams_article",5106],"thread-153856":["thread",153856],"thread-153333":["thread",153333],"thread-153316":["thread",153316],"thread-153279":["thread",153279],"thread-148382":["thread",148382],"ams_article-3416":["ams_article",3416],"thread-142660":["thread",142660],"thread-139350":["thread",139350],"thread-127169":["thread",127169],"thread-126868":["thread",126868],"thread-126867":["thread",126867],"thread-126423":["thread",126423],"thread-125519":["thread",125519],"thread-125242":["thread",125242],"thread-125239":["thread",125239],"thread-124582":["thread",124582],"thread-123893":["thread",123893],"thread-123505":["thread",123505],"thread-123202":["thread",123202],"thread-122460":["thread",122460],"thread-122068":["thread",122068],"thread-121385":["thread",121385],"thread-120495":["thread",120495],"thread-120425":["thread",120425],"thread-119360":["thread",119360],"thread-116966":["thread",116966],"thread-116804":["thread",116804],"thread-116786":["thread",116786],"thread-116304":["thread",116304],"thread-116291":["thread",116291],"thread-116097":["thread",116097],"thread-115884":["thread",115884],"thread-115837":["thread",115837],"thread-115675":["thread",115675],"thread-115111":["thread",115111],"thread-114930":["thread",114930],"thread-114497":["thread",114497],"thread-113676":["thread",113676],"thread-112685":["thread",112685],"thread-112475":["thread",112475],"thread-111810":["thread",111810],"thread-109127":["thread",109127],"thread-108880":["thread",108880],"thread-108358":["thread",108358],"thread-106850":["thread",106850],"thread-106465":["thread",106465],"thread-105316":["thread",105316],"thread-104779":["thread",104779],"thread-103471":["thread",103471],"thread-103461":["thread",103461],"thread-103293":["thread",103293],"thread-103203":["thread",103203],"thread-102330":["thread",102330],"thread-102243":["thread",102243],"thread-102206":["thread",102206],"thread-102189":["thread",102189],"thread-102109":["thread",102109],"thread-101290":["thread",101290],"thread-101268":["thread",101268],"thread-100660":["thread",100660],"thread-100394":["thread",100394],"thread-99025":["thread",99025],"thread-97891":["thread",97891],"thread-93986":["thread",93986],"thread-91835":["thread",91835],"thread-91831":["thread",91831],"thread-91778":["thread",91778],"thread-91732":["thread",91732],"thread-91682":["thread",91682],"thread-91567":["thread",91567],"thread-91520":["thread",91520],"thread-91381":["thread",91381],"thread-90261":["thread",90261],"thread-90130":["thread",90130],"thread-90069":["thread",90069],"thread-90056":["thread",90056],"thread-89702":["thread",89702],"thread-89505":["thread",89505],"thread-89456":["thread",89456],"thread-89227":["thread",89227],"thread-89226":["thread",89226],"thread-89127":["thread",89127],"thread-87194":["thread",87194],"thread-85760":["thread",85760],"thread-85735":["thread",85735],"thread-85725":["thread",85725],"thread-84800":["thread",84800],"thread-84744":["thread",84744],"thread-84731":["thread",84731],"thread-82271":["thread",82271],"thread-81742":["thread",81742],"thread-81595":["thread",81595],"thread-81593":["thread",81593],"thread-78515":["thread",78515],"thread-76359":["thread",76359],"thread-73795":["thread",73795],"thread-64403":["thread",64403],"thread-64012":["thread",64012],"thread-63451":["thread",63451],"thread-63434":["thread",63434],"thread-63247":["thread",63247],"thread-63241":["thread",63241],"thread-63133":["thread",63133],"thread-63106":["thread",63106],"thread-63011":["thread",63011],"thread-62776":["thread",62776],"thread-62774":["thread",62774],"thread-60758":["thread",60758],"thread-60332":["thread",60332],"thread-60156":["thread",60156],"thread-59985":["thread",59985],"thread-59488":["thread",59488],"thread-58862":["thread",58862],"thread-58211":["thread",58211],"thread-57310":["thread",57310],"thread-57298":["thread",57298],"thread-57216":["thread",57216],"thread-56243":["thread",56243],"thread-54631":["thread",54631]}, , 1715908278
Run Time: 0.000180
- 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