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 (147285, 140145, 138008, 137157, 135749, 135732, 133395, 133366, 132559, 129890, 129116, 129015, 128415, 128198, 128035, 128008, 127820, 126087, 126086, 126085, 126084, 126082, 125955, 125404, 123141, 122611, 122604, 122598, 122590, 122582, 122541, 121071, 120738, 119751, 118111, 117804, 115749, 115599, 114778, 114384, 114009, 113588, 113199, 112950, 112796, 112730, 112576, 112500, 112461, 112458, 112261, 112202, 111539, 110575, 110422, 109768, 109589, 109587, 109513, 109247, 108734, 107775, 105447, 102626, 101557, 100901, 100645, 100354, 99306, 99019, 98916, 98914, 96237, 95726, 95211, 94590, 94552, 94543, 94268, 91340, 91224, 91212, 89839, 89829, 89240, 89030, 89029, 89019, 88854, 88377, 88210, 87975, 87949, 87941, 70203, 64070, 53825, 48371, 46138, 41357, 25878, 22556, 13773))
Run Time: 0.050437
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 103 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | carder_admin_bd.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | carder_admin_bd.xf_forum_Forum_1.node_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | carder_admin_bd.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | carder_admin_bd.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,carder_admin_bd.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 1392
- 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 2731
- 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 2353
- XF\App->run() in src/XF.php at line 524
- 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: 621, 0, 1716240899, {"thread-147285":["thread",147285],"thread-140145":["thread",140145],"thread-138008":["thread",138008],"thread-137157":["thread",137157],"thread-135749":["thread",135749],"thread-135732":["thread",135732],"thread-133395":["thread",133395],"thread-133366":["thread",133366],"thread-132559":["thread",132559],"thread-129890":["thread",129890],"thread-129116":["thread",129116],"thread-129015":["thread",129015],"thread-128415":["thread",128415],"thread-128198":["thread",128198],"thread-128035":["thread",128035],"thread-128008":["thread",128008],"thread-127820":["thread",127820],"thread-126087":["thread",126087],"thread-126086":["thread",126086],"thread-126085":["thread",126085],"thread-126084":["thread",126084],"thread-126082":["thread",126082],"thread-125955":["thread",125955],"thread-125404":["thread",125404],"thread-123141":["thread",123141],"thread-122611":["thread",122611],"thread-122604":["thread",122604],"thread-122598":["thread",122598],"thread-122590":["thread",122590],"thread-122582":["thread",122582],"thread-122541":["thread",122541],"thread-121071":["thread",121071],"thread-120738":["thread",120738],"thread-119751":["thread",119751],"thread-118111":["thread",118111],"thread-117804":["thread",117804],"thread-115749":["thread",115749],"thread-115599":["thread",115599],"thread-114778":["thread",114778],"thread-114384":["thread",114384],"thread-114009":["thread",114009],"thread-113588":["thread",113588],"thread-113199":["thread",113199],"thread-112950":["thread",112950],"thread-112796":["thread",112796],"thread-112730":["thread",112730],"thread-112576":["thread",112576],"thread-112500":["thread",112500],"thread-112461":["thread",112461],"thread-112458":["thread",112458],"thread-112261":["thread",112261],"thread-112202":["thread",112202],"thread-111539":["thread",111539],"thread-110575":["thread",110575],"thread-110422":["thread",110422],"thread-109768":["thread",109768],"thread-109589":["thread",109589],"thread-109587":["thread",109587],"thread-109513":["thread",109513],"thread-109247":["thread",109247],"thread-108734":["thread",108734],"thread-107775":["thread",107775],"thread-105447":["thread",105447],"thread-102626":["thread",102626],"thread-101557":["thread",101557],"thread-100901":["thread",100901],"thread-100645":["thread",100645],"thread-100354":["thread",100354],"thread-99306":["thread",99306],"thread-99019":["thread",99019],"thread-98916":["thread",98916],"thread-98914":["thread",98914],"thread-96237":["thread",96237],"thread-95726":["thread",95726],"thread-95211":["thread",95211],"thread-94590":["thread",94590],"thread-94552":["thread",94552],"thread-94543":["thread",94543],"thread-94268":["thread",94268],"xfmg_media-133":["xfmg_media",133],"xfmg_media-117":["xfmg_media",117],"xfmg_media-115":["xfmg_media",115],"xfmg_media-114":["xfmg_media",114],"xfmg_media-110":["xfmg_media",110],"xfmg_media-109":["xfmg_media",109],"xfmg_media-104":["xfmg_media",104],"xfmg_media-102":["xfmg_media",102],"xfmg_media-101":["xfmg_media",101],"thread-91340":["thread",91340],"thread-91224":["thread",91224],"thread-91212":["thread",91212],"thread-89839":["thread",89839],"thread-89829":["thread",89829],"thread-89240":["thread",89240],"thread-89030":["thread",89030],"thread-89029":["thread",89029],"thread-89019":["thread",89019],"thread-88854":["thread",88854],"thread-88377":["thread",88377],"thread-88210":["thread",88210],"thread-87975":["thread",87975],"thread-87949":["thread",87949],"thread-87941":["thread",87941],"thread-70203":["thread",70203],"thread-64070":["thread",64070],"thread-53825":["thread",53825],"thread-48371":["thread",48371],"thread-46138":["thread",46138],"thread-41357":["thread",41357],"thread-25878":["thread",25878],"thread-22556":["thread",22556],"thread-13773":["thread",13773]}, NULL, 1716237299
Run Time: 0.001233
- 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 1516
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1248
- 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 2353
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20