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 (183467, 182862, 180029, 179513, 179458, 178917, 178788, 178169, 176945, 176023, 174778, 174754, 174582, 174442, 173223, 173063, 172694, 170620, 169484, 168049, 167121, 167120, 166457, 165847, 164843, 164187, 163825, 163498, 163328, 162244, 162011, 161574, 161224, 161044, 160475, 160059, 159761, 155710, 155114, 150495, 147267, 147160, 145252, 143120, 134592, 133012, 132214, 131974, 131650, 131033, 129952, 129430, 127351, 126493, 124373, 124173, 120557, 120013, 117854, 116656, 114423, 114342, 113643, 113281, 113257, 113194, 113179, 113077, 112983, 110926, 110683, 110434, 110334, 110129, 109708, 109128, 109100, 108044, 107936, 107927, 107761, 107641, 107340, 106623, 106463, 106399, 106249, 106226, 105810, 105767, 105762, 105676, 105368, 105365, 105354, 105335, 105116, 104926, 104924, 104882, 104256, 102262, 100352, 99729, 99555, 97690, 97274, 96997, 94936, 93833, 93673, 93658, 89294, 88700, 86510, 85945, 84669, 84113, 82136, 78467, 78433, 75588, 74674, 73283, 70666, 70428, 68883, 68439, 65027, 64313, 64196, 62631, 61988, 61000, 60186, 59736, 59322, 57708, 57349, 56265, 54974, 51446, 45105, 40197, 38473, 35029, 34569, 33751, 29702, 24665, 23634, 23247, 21873, 20837, 15980, 1711, 1508, 1497, 1345))
Run Time: 0.073081
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 159 | 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
UPDATE `xf_tag_result_cache` SET `expiry_date` = ?, `results` = ? WHERE `result_cache_id` = 809234
Params: 1715673181, {"thread-183467":["thread",183467],"thread-182862":["thread",182862],"thread-180029":["thread",180029],"thread-179513":["thread",179513],"thread-179458":["thread",179458],"thread-178917":["thread",178917],"thread-178788":["thread",178788],"thread-178169":["thread",178169],"thread-176945":["thread",176945],"thread-176023":["thread",176023],"thread-174778":["thread",174778],"thread-174754":["thread",174754],"thread-174582":["thread",174582],"thread-174442":["thread",174442],"thread-173223":["thread",173223],"thread-173063":["thread",173063],"thread-172694":["thread",172694],"thread-170620":["thread",170620],"tl_group-266":["tl_group",266],"thread-169484":["thread",169484],"tl_group-256":["tl_group",256],"thread-168049":["thread",168049],"thread-167121":["thread",167121],"thread-167120":["thread",167120],"thread-166457":["thread",166457],"thread-165847":["thread",165847],"thread-164843":["thread",164843],"thread-164187":["thread",164187],"thread-163825":["thread",163825],"thread-163498":["thread",163498],"thread-163328":["thread",163328],"thread-162244":["thread",162244],"thread-162011":["thread",162011],"thread-161574":["thread",161574],"thread-161224":["thread",161224],"thread-161044":["thread",161044],"thread-160475":["thread",160475],"thread-160059":["thread",160059],"thread-159761":["thread",159761],"thread-155710":["thread",155710],"thread-155114":["thread",155114],"thread-150495":["thread",150495],"thread-147267":["thread",147267],"thread-147160":["thread",147160],"thread-145252":["thread",145252],"thread-143120":["thread",143120],"thread-134592":["thread",134592],"thread-133012":["thread",133012],"thread-132214":["thread",132214],"thread-131974":["thread",131974],"thread-131650":["thread",131650],"thread-131033":["thread",131033],"thread-129952":["thread",129952],"thread-129430":["thread",129430],"thread-127351":["thread",127351],"thread-126493":["thread",126493],"thread-124373":["thread",124373],"thread-124173":["thread",124173],"thread-120557":["thread",120557],"thread-120013":["thread",120013],"thread-117854":["thread",117854],"thread-116656":["thread",116656],"thread-114423":["thread",114423],"thread-114342":["thread",114342],"thread-113643":["thread",113643],"thread-113281":["thread",113281],"thread-113257":["thread",113257],"thread-113194":["thread",113194],"thread-113179":["thread",113179],"thread-113077":["thread",113077],"thread-112983":["thread",112983],"thread-110926":["thread",110926],"thread-110683":["thread",110683],"thread-110434":["thread",110434],"thread-110334":["thread",110334],"thread-110129":["thread",110129],"thread-109708":["thread",109708],"thread-109128":["thread",109128],"thread-109100":["thread",109100],"thread-108044":["thread",108044],"thread-107936":["thread",107936],"thread-107927":["thread",107927],"thread-107761":["thread",107761],"thread-107641":["thread",107641],"thread-107340":["thread",107340],"thread-106623":["thread",106623],"thread-106463":["thread",106463],"thread-106399":["thread",106399],"thread-106249":["thread",106249],"thread-106226":["thread",106226],"thread-105810":["thread",105810],"thread-105767":["thread",105767],"thread-105762":["thread",105762],"thread-105676":["thread",105676],"thread-105368":["thread",105368],"thread-105365":["thread",105365],"thread-105354":["thread",105354],"thread-105335":["thread",105335],"thread-105116":["thread",105116],"thread-104926":["thread",104926],"thread-104924":["thread",104924],"thread-104882":["thread",104882],"thread-104256":["thread",104256],"thread-102262":["thread",102262],"thread-100352":["thread",100352],"thread-99729":["thread",99729],"thread-99555":["thread",99555],"thread-97690":["thread",97690],"thread-97274":["thread",97274],"thread-96997":["thread",96997],"thread-94936":["thread",94936],"thread-93833":["thread",93833],"thread-93673":["thread",93673],"thread-93658":["thread",93658],"thread-89294":["thread",89294],"thread-88700":["thread",88700],"thread-86510":["thread",86510],"thread-85945":["thread",85945],"thread-84669":["thread",84669],"thread-84113":["thread",84113],"thread-82136":["thread",82136],"thread-78467":["thread",78467],"thread-78433":["thread",78433],"thread-75588":["thread",75588],"thread-74674":["thread",74674],"thread-73283":["thread",73283],"thread-70666":["thread",70666],"thread-70428":["thread",70428],"thread-68883":["thread",68883],"thread-68439":["thread",68439],"thread-65027":["thread",65027],"thread-64313":["thread",64313],"thread-64196":["thread",64196],"thread-62631":["thread",62631],"thread-61988":["thread",61988],"thread-61000":["thread",61000],"thread-60186":["thread",60186],"thread-59736":["thread",59736],"thread-59322":["thread",59322],"thread-57708":["thread",57708],"thread-57349":["thread",57349],"thread-56265":["thread",56265],"thread-54974":["thread",54974],"thread-51446":["thread",51446],"thread-45105":["thread",45105],"thread-40197":["thread",40197],"thread-38473":["thread",38473],"thread-35029":["thread",35029],"thread-34569":["thread",34569],"thread-33751":["thread",33751],"thread-29702":["thread",29702],"thread-24665":["thread",24665],"thread-23634":["thread",23634],"thread-23247":["thread",23247],"thread-21873":["thread",21873],"thread-20837":["thread",20837],"thread-15980":["thread",15980],"thread-1711":["thread",1711],"thread-1508":["thread",1508],"thread-1497":["thread",1497],"thread-1345":["thread",1345]}
Run Time: 0.000608
- 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 324
- XF\Db\AbstractAdapter->update() in src/XF/Mvc/Entity/Entity.php at line 1519
- 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