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 (182618, 182200, 181993, 181808, 181362, 180747, 180071, 180068, 179834, 179812, 178782, 178136, 177720, 177708, 177707, 177164, 176747, 176705, 175967, 175944, 172242, 167846, 167844, 166133, 165167, 164633, 162941, 161321, 161080, 160853, 160850, 160843, 160842, 160841, 160840, 160839, 160838, 160837, 160458, 160401, 160177, 160068, 160065, 160063, 160027, 160026, 160025, 160023, 160021, 159426, 158825, 156757, 156756, 156088, 154994, 154983, 153057, 153056, 153023, 153022, 152939, 152911, 152551, 152452, 152443, 152441, 152420, 152416, 152390, 152388, 152378, 149995, 149109, 142589, 142128, 141064, 133329, 132337, 132336, 131071, 130953, 126634, 125371, 124515, 123877, 123450, 123204, 122848, 121974, 121836, 121648, 121024, 120939, 120761, 117164, 115638, 107956, 106442, 104666, 103373, 102277, 102067, 101054, 100322, 98743, 95656, 93909, 92492, 91748, 90887, 86886, 85254, 80969, 80499, 73190, 71128, 71113, 58405, 58110, 57992, 56584, 56330, 42693, 39044, 30146, 25116, 21190, 12845, 9863, 9860))
Run Time: 0.217823
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 130 | 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: 1664, 0, 1715153278, {"thread-182618":["thread",182618],"thread-182200":["thread",182200],"thread-181993":["thread",181993],"thread-181808":["thread",181808],"thread-181362":["thread",181362],"thread-180747":["thread",180747],"thread-180071":["thread",180071],"thread-180068":["thread",180068],"thread-179834":["thread",179834],"thread-179812":["thread",179812],"thread-178782":["thread",178782],"thread-178136":["thread",178136],"thread-177720":["thread",177720],"thread-177708":["thread",177708],"thread-177707":["thread",177707],"thread-177164":["thread",177164],"thread-176747":["thread",176747],"thread-176705":["thread",176705],"thread-175967":["thread",175967],"thread-175944":["thread",175944],"thread-172242":["thread",172242],"thread-167846":["thread",167846],"thread-167844":["thread",167844],"thread-166133":["thread",166133],"thread-165167":["thread",165167],"thread-164633":["thread",164633],"thread-162941":["thread",162941],"thread-161321":["thread",161321],"thread-161080":["thread",161080],"thread-160853":["thread",160853],"thread-160850":["thread",160850],"thread-160843":["thread",160843],"thread-160842":["thread",160842],"thread-160841":["thread",160841],"thread-160840":["thread",160840],"thread-160839":["thread",160839],"thread-160838":["thread",160838],"thread-160837":["thread",160837],"thread-160458":["thread",160458],"thread-160401":["thread",160401],"thread-160177":["thread",160177],"thread-160068":["thread",160068],"thread-160065":["thread",160065],"thread-160063":["thread",160063],"thread-160027":["thread",160027],"thread-160026":["thread",160026],"thread-160025":["thread",160025],"thread-160023":["thread",160023],"thread-160021":["thread",160021],"thread-159426":["thread",159426],"thread-158825":["thread",158825],"thread-156757":["thread",156757],"thread-156756":["thread",156756],"thread-156088":["thread",156088],"thread-154994":["thread",154994],"thread-154983":["thread",154983],"thread-153057":["thread",153057],"thread-153056":["thread",153056],"thread-153023":["thread",153023],"thread-153022":["thread",153022],"thread-152939":["thread",152939],"thread-152911":["thread",152911],"thread-152551":["thread",152551],"thread-152452":["thread",152452],"thread-152443":["thread",152443],"thread-152441":["thread",152441],"thread-152420":["thread",152420],"thread-152416":["thread",152416],"thread-152390":["thread",152390],"thread-152388":["thread",152388],"thread-152378":["thread",152378],"thread-149995":["thread",149995],"thread-149109":["thread",149109],"thread-142589":["thread",142589],"thread-142128":["thread",142128],"thread-141064":["thread",141064],"thread-133329":["thread",133329],"thread-132337":["thread",132337],"thread-132336":["thread",132336],"thread-131071":["thread",131071],"thread-130953":["thread",130953],"thread-126634":["thread",126634],"thread-125371":["thread",125371],"thread-124515":["thread",124515],"thread-123877":["thread",123877],"thread-123450":["thread",123450],"thread-123204":["thread",123204],"thread-122848":["thread",122848],"thread-121974":["thread",121974],"thread-121836":["thread",121836],"thread-121648":["thread",121648],"thread-121024":["thread",121024],"thread-120939":["thread",120939],"thread-120761":["thread",120761],"thread-117164":["thread",117164],"thread-115638":["thread",115638],"thread-107956":["thread",107956],"thread-106442":["thread",106442],"thread-104666":["thread",104666],"thread-103373":["thread",103373],"thread-102277":["thread",102277],"thread-102067":["thread",102067],"thread-101054":["thread",101054],"thread-100322":["thread",100322],"thread-98743":["thread",98743],"thread-95656":["thread",95656],"thread-93909":["thread",93909],"thread-92492":["thread",92492],"thread-91748":["thread",91748],"thread-90887":["thread",90887],"thread-86886":["thread",86886],"thread-85254":["thread",85254],"thread-80969":["thread",80969],"thread-80499":["thread",80499],"thread-73190":["thread",73190],"thread-71128":["thread",71128],"thread-71113":["thread",71113],"thread-58405":["thread",58405],"thread-58110":["thread",58110],"thread-57992":["thread",57992],"thread-56584":["thread",56584],"thread-56330":["thread",56330],"thread-42693":["thread",42693],"thread-39044":["thread",39044],"thread-30146":["thread",30146],"thread-25116":["thread",25116],"thread-21190":["thread",21190],"thread-12845":["thread",12845],"thread-9863":["thread",9863],"thread-9860":["thread",9860]}, , 1715149678
Run Time: 0.000215
- 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