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 (182473, 182205, 180788, 180115, 179814, 179167, 176980, 176886, 176158, 176071, 176058, 176014, 175984, 175860, 175206, 174639, 174553, 174355, 174273, 174182, 173837, 173164, 173143, 172199, 170450, 168423, 168077, 166956, 166275, 166179, 165628, 162724, 158450, 158393, 158376, 158082, 157966, 157611, 154909, 154363, 153448, 153309, 153062, 152460, 149761, 148912, 145433, 140966, 139884, 137600, 136342, 135622, 134678, 133910, 133614, 133472, 132842, 131122, 130484, 129553, 129411, 129011, 127803, 126748, 126739, 126724, 125457, 123818, 120847, 120750, 120574, 120539, 119590, 118364, 116382, 116095, 116027, 113664, 109925, 109375, 109192, 109125, 109124, 109095, 109053, 108993, 107169, 105777, 105713, 105588, 105507, 103659, 103285, 103209, 102473, 102251, 102081, 100676, 99787, 99593, 99294, 96065, 91260, 90822, 90776, 89757, 85348, 85039, 84848, 84292, 83213, 83171, 81909, 81644, 79180, 76108, 74825, 73453, 72613, 72435, 72305, 71279, 70657, 70432, 70348, 65389, 60857, 59985, 55067, 53791, 52498, 51553, 50898, 49338, 49040, 47756, 47295, 30600, 30045, 29657, 24840, 24616, 20527, 1540, 1496, 1370, 1367))
Run Time: 0.097177
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 147 | 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: 350, 0, 1714453423, {"thread-182473":["thread",182473],"thread-182205":["thread",182205],"thread-180788":["thread",180788],"thread-180115":["thread",180115],"thread-179814":["thread",179814],"thread-179167":["thread",179167],"thread-176980":["thread",176980],"thread-176886":["thread",176886],"thread-176158":["thread",176158],"thread-176071":["thread",176071],"thread-176058":["thread",176058],"thread-176014":["thread",176014],"thread-175984":["thread",175984],"thread-175860":["thread",175860],"thread-175206":["thread",175206],"thread-174639":["thread",174639],"thread-174553":["thread",174553],"thread-174355":["thread",174355],"thread-174273":["thread",174273],"thread-174182":["thread",174182],"thread-173837":["thread",173837],"thread-173164":["thread",173164],"thread-173143":["thread",173143],"thread-172199":["thread",172199],"thread-170450":["thread",170450],"thread-168423":["thread",168423],"thread-168077":["thread",168077],"thread-166956":["thread",166956],"thread-166275":["thread",166275],"thread-166179":["thread",166179],"thread-165628":["thread",165628],"thread-162724":["thread",162724],"thread-158450":["thread",158450],"thread-158393":["thread",158393],"thread-158376":["thread",158376],"thread-158082":["thread",158082],"thread-157966":["thread",157966],"thread-157611":["thread",157611],"thread-154909":["thread",154909],"thread-154363":["thread",154363],"thread-153448":["thread",153448],"thread-153309":["thread",153309],"thread-153062":["thread",153062],"thread-152460":["thread",152460],"tl_group-61":["tl_group",61],"thread-149761":["thread",149761],"thread-148912":["thread",148912],"thread-145433":["thread",145433],"thread-140966":["thread",140966],"thread-139884":["thread",139884],"thread-137600":["thread",137600],"thread-136342":["thread",136342],"thread-135622":["thread",135622],"thread-134678":["thread",134678],"thread-133910":["thread",133910],"thread-133614":["thread",133614],"thread-133472":["thread",133472],"thread-132842":["thread",132842],"thread-131122":["thread",131122],"thread-130484":["thread",130484],"thread-129553":["thread",129553],"thread-129411":["thread",129411],"thread-129011":["thread",129011],"thread-127803":["thread",127803],"thread-126748":["thread",126748],"thread-126739":["thread",126739],"thread-126724":["thread",126724],"thread-125457":["thread",125457],"thread-123818":["thread",123818],"thread-120847":["thread",120847],"thread-120750":["thread",120750],"thread-120574":["thread",120574],"thread-120539":["thread",120539],"thread-119590":["thread",119590],"thread-118364":["thread",118364],"thread-116382":["thread",116382],"thread-116095":["thread",116095],"thread-116027":["thread",116027],"thread-113664":["thread",113664],"thread-109925":["thread",109925],"thread-109375":["thread",109375],"thread-109192":["thread",109192],"thread-109125":["thread",109125],"thread-109124":["thread",109124],"thread-109095":["thread",109095],"thread-109053":["thread",109053],"thread-108993":["thread",108993],"thread-107169":["thread",107169],"thread-105777":["thread",105777],"thread-105713":["thread",105713],"thread-105588":["thread",105588],"thread-105507":["thread",105507],"thread-103659":["thread",103659],"thread-103285":["thread",103285],"thread-103209":["thread",103209],"thread-102473":["thread",102473],"thread-102251":["thread",102251],"thread-102081":["thread",102081],"thread-100676":["thread",100676],"thread-99787":["thread",99787],"thread-99593":["thread",99593],"thread-99294":["thread",99294],"thread-96065":["thread",96065],"thread-91260":["thread",91260],"thread-90822":["thread",90822],"thread-90776":["thread",90776],"thread-89757":["thread",89757],"thread-85348":["thread",85348],"thread-85039":["thread",85039],"thread-84848":["thread",84848],"thread-84292":["thread",84292],"thread-83213":["thread",83213],"thread-83171":["thread",83171],"thread-81909":["thread",81909],"thread-81644":["thread",81644],"thread-79180":["thread",79180],"thread-76108":["thread",76108],"thread-74825":["thread",74825],"thread-73453":["thread",73453],"thread-72613":["thread",72613],"thread-72435":["thread",72435],"thread-72305":["thread",72305],"thread-71279":["thread",71279],"thread-70657":["thread",70657],"thread-70432":["thread",70432],"thread-70348":["thread",70348],"thread-65389":["thread",65389],"thread-60857":["thread",60857],"thread-59985":["thread",59985],"thread-55067":["thread",55067],"thread-53791":["thread",53791],"thread-52498":["thread",52498],"thread-51553":["thread",51553],"thread-50898":["thread",50898],"thread-49338":["thread",49338],"thread-49040":["thread",49040],"thread-47756":["thread",47756],"thread-47295":["thread",47295],"thread-30600":["thread",30600],"thread-30045":["thread",30045],"thread-29657":["thread",29657],"thread-24840":["thread",24840],"thread-24616":["thread",24616],"thread-20527":["thread",20527],"thread-1540":["thread",1540],"thread-1496":["thread",1496],"thread-1370":["thread",1370],"thread-1367":["thread",1367]}, , 1714449823
Run Time: 0.001002
- 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