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 (182980, 181379, 180902, 180824, 180819, 180762, 180438, 180079, 180000, 179281, 179209, 178630, 177961, 177164, 177099, 177080, 176735, 176733, 175581, 175522, 175092, 172107, 171822, 171581, 168726, 168704, 168009, 166754, 166647, 166007, 164690, 164687, 163937, 162622, 160784, 159013, 158979, 158861, 157946, 156390, 156185, 155122, 155018, 154384, 153568, 153359, 152533, 151924, 151389, 150848, 150748, 150697, 150374, 149691, 149204, 146792, 146178, 146101, 146057, 145705, 144757, 144739, 144411, 144319, 144161, 143806, 143748, 141961, 141718, 140981, 140221, 139996, 139405, 139223, 138271, 137310, 136873, 136428, 134459, 134187, 133956, 133788, 133030, 131935, 131931, 131849, 131808, 131635, 131147, 131124, 131015, 130895, 130802, 130801, 130684, 130606, 130524, 130452, 130392, 130305, 130286, 130274, 130160, 130100, 130098, 129901, 129851, 129611, 129541, 129293, 129240, 129105, 129057, 129019, 129005, 128868, 128866, 128684, 128458, 127715, 127607, 127549, 127490, 127330, 127199, 127144, 127106, 126750, 126540, 126525, 126378, 126377, 126334, 126038, 123847, 123623, 123027, 123026, 123000, 122750, 122745, 122563, 122352, 121860, 121309, 120604, 120603, 120383, 119567, 119323, 118379, 118244, 118239, 117821, 115783, 115702, 115639, 115284, 115130, 114468, 114064, 113888, 113789, 113687, 113677, 113335, 113136, 113050, 113038, 112954, 112849, 112756, 112726, 112469, 112329, 112294, 112217, 112208, 111981, 110276, 110154, 110096, 110084, 110074, 109839, 109674, 109286, 109283, 109174, 109139, 109075, 108678, 108677, 108349, 108316, 108132, 107897, 107602, 107572, 107306))
Run Time: 0.151559
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 200 | 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: 825, 0, 1714884813, {"thread-182980":["thread",182980],"thread-181379":["thread",181379],"thread-180902":["thread",180902],"thread-180824":["thread",180824],"thread-180819":["thread",180819],"thread-180762":["thread",180762],"thread-180438":["thread",180438],"thread-180079":["thread",180079],"thread-180000":["thread",180000],"thread-179281":["thread",179281],"thread-179209":["thread",179209],"thread-178630":["thread",178630],"thread-177961":["thread",177961],"thread-177164":["thread",177164],"thread-177099":["thread",177099],"thread-177080":["thread",177080],"thread-176735":["thread",176735],"thread-176733":["thread",176733],"thread-175581":["thread",175581],"thread-175522":["thread",175522],"thread-175092":["thread",175092],"thread-172107":["thread",172107],"thread-171822":["thread",171822],"thread-171581":["thread",171581],"thread-168726":["thread",168726],"thread-168704":["thread",168704],"thread-168009":["thread",168009],"thread-166754":["thread",166754],"thread-166647":["thread",166647],"thread-166007":["thread",166007],"thread-164690":["thread",164690],"thread-164687":["thread",164687],"thread-163937":["thread",163937],"thread-162622":["thread",162622],"thread-160784":["thread",160784],"thread-159013":["thread",159013],"thread-158979":["thread",158979],"thread-158861":["thread",158861],"thread-157946":["thread",157946],"thread-156390":["thread",156390],"thread-156185":["thread",156185],"thread-155122":["thread",155122],"thread-155018":["thread",155018],"thread-154384":["thread",154384],"thread-153568":["thread",153568],"thread-153359":["thread",153359],"thread-152533":["thread",152533],"thread-151924":["thread",151924],"thread-151389":["thread",151389],"thread-150848":["thread",150848],"thread-150748":["thread",150748],"thread-150697":["thread",150697],"thread-150374":["thread",150374],"thread-149691":["thread",149691],"thread-149204":["thread",149204],"thread-146792":["thread",146792],"thread-146178":["thread",146178],"thread-146101":["thread",146101],"thread-146057":["thread",146057],"thread-145705":["thread",145705],"thread-144757":["thread",144757],"thread-144739":["thread",144739],"thread-144411":["thread",144411],"thread-144319":["thread",144319],"thread-144161":["thread",144161],"thread-143806":["thread",143806],"thread-143748":["thread",143748],"thread-141961":["thread",141961],"thread-141718":["thread",141718],"thread-140981":["thread",140981],"thread-140221":["thread",140221],"thread-139996":["thread",139996],"thread-139405":["thread",139405],"thread-139223":["thread",139223],"thread-138271":["thread",138271],"thread-137310":["thread",137310],"thread-136873":["thread",136873],"thread-136428":["thread",136428],"thread-134459":["thread",134459],"thread-134187":["thread",134187],"thread-133956":["thread",133956],"thread-133788":["thread",133788],"thread-133030":["thread",133030],"thread-131935":["thread",131935],"thread-131931":["thread",131931],"thread-131849":["thread",131849],"thread-131808":["thread",131808],"thread-131635":["thread",131635],"thread-131147":["thread",131147],"thread-131124":["thread",131124],"thread-131015":["thread",131015],"thread-130895":["thread",130895],"thread-130802":["thread",130802],"thread-130801":["thread",130801],"thread-130684":["thread",130684],"thread-130606":["thread",130606],"thread-130524":["thread",130524],"thread-130452":["thread",130452],"thread-130392":["thread",130392],"thread-130305":["thread",130305],"thread-130286":["thread",130286],"thread-130274":["thread",130274],"thread-130160":["thread",130160],"thread-130100":["thread",130100],"thread-130098":["thread",130098],"thread-129901":["thread",129901],"thread-129851":["thread",129851],"thread-129611":["thread",129611],"thread-129541":["thread",129541],"thread-129293":["thread",129293],"thread-129240":["thread",129240],"thread-129105":["thread",129105],"thread-129057":["thread",129057],"thread-129019":["thread",129019],"thread-129005":["thread",129005],"thread-128868":["thread",128868],"thread-128866":["thread",128866],"thread-128684":["thread",128684],"thread-128458":["thread",128458],"thread-127715":["thread",127715],"thread-127607":["thread",127607],"thread-127549":["thread",127549],"thread-127490":["thread",127490],"thread-127330":["thread",127330],"thread-127199":["thread",127199],"thread-127144":["thread",127144],"thread-127106":["thread",127106],"thread-126750":["thread",126750],"thread-126540":["thread",126540],"thread-126525":["thread",126525],"thread-126378":["thread",126378],"thread-126377":["thread",126377],"thread-126334":["thread",126334],"thread-126038":["thread",126038],"thread-123847":["thread",123847],"thread-123623":["thread",123623],"thread-123027":["thread",123027],"thread-123026":["thread",123026],"thread-123000":["thread",123000],"thread-122750":["thread",122750],"thread-122745":["thread",122745],"thread-122563":["thread",122563],"thread-122352":["thread",122352],"thread-121860":["thread",121860],"thread-121309":["thread",121309],"thread-120604":["thread",120604],"thread-120603":["thread",120603],"thread-120383":["thread",120383],"thread-119567":["thread",119567],"thread-119323":["thread",119323],"thread-118379":["thread",118379],"thread-118244":["thread",118244],"thread-118239":["thread",118239],"thread-117821":["thread",117821],"thread-115783":["thread",115783],"thread-115702":["thread",115702],"thread-115639":["thread",115639],"thread-115284":["thread",115284],"thread-115130":["thread",115130],"thread-114468":["thread",114468],"thread-114064":["thread",114064],"thread-113888":["thread",113888],"thread-113789":["thread",113789],"thread-113687":["thread",113687],"thread-113677":["thread",113677],"thread-113335":["thread",113335],"thread-113136":["thread",113136],"thread-113050":["thread",113050],"thread-113038":["thread",113038],"thread-112954":["thread",112954],"thread-112849":["thread",112849],"thread-112756":["thread",112756],"thread-112726":["thread",112726],"thread-112469":["thread",112469],"thread-112329":["thread",112329],"thread-112294":["thread",112294],"thread-112217":["thread",112217],"thread-112208":["thread",112208],"thread-111981":["thread",111981],"thread-110276":["thread",110276],"thread-110154":["thread",110154],"thread-110096":["thread",110096],"thread-110084":["thread",110084],"thread-110074":["thread",110074],"thread-109839":["thread",109839],"thread-109674":["thread",109674],"thread-109286":["thread",109286],"thread-109283":["thread",109283],"thread-109174":["thread",109174],"thread-109139":["thread",109139],"thread-109075":["thread",109075],"thread-108678":["thread",108678],"thread-108677":["thread",108677],"thread-108349":["thread",108349],"thread-108316":["thread",108316],"thread-108132":["thread",108132],"thread-107897":["thread",107897],"thread-107602":["thread",107602],"thread-107572":["thread",107572],"thread-107306":["thread",107306]}, , 1714881213
Run Time: 0.000338
- 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