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 (183141, 181887, 180919, 179842, 178988, 178773, 177737, 176096, 173960, 168531, 166638, 166502, 165812, 165609, 165447, 164439, 160305, 160181, 155918, 155745, 155317, 154827, 154487, 153688, 152215, 152128, 151742, 132155, 132105, 132096, 132089, 132049, 132028, 131997, 131846, 131812, 131759, 131587, 131586, 131540, 131510, 131279, 131277, 131211, 131200, 131111, 131104, 131099, 130853, 130607, 130567, 130312, 129942, 129839, 129520, 129456, 129026, 128928, 128878, 128830, 128429, 128286, 128174, 128130, 127890, 127829, 127779, 127767, 127734, 127708, 127644, 127641, 127628, 127579, 127525, 127393, 127346, 127181, 127154, 127107, 126945, 126888, 126840, 126765, 126764, 126648, 126261, 126174, 126146, 126108, 126090, 125622, 125355, 124958, 124890, 124658, 124414, 124353, 124074, 124057, 124010, 123991, 123963, 123931, 123928, 123855, 123849, 123848, 123088, 122984, 122800, 122795, 122762, 122731, 121613, 121612, 121040, 120840, 120759, 120706, 120605, 120572, 120440, 120035, 120016, 120010, 120002, 119653, 119331, 119212, 118881, 118192, 118127, 118119, 118037, 118002, 117952, 117534, 117353, 117339, 117156, 117148, 117043, 116905, 116658, 116500, 116118, 116043, 115999, 115913, 115406, 115156, 114882, 114861, 114734, 114110, 113891, 113853, 113790, 113765, 113745, 113472, 113265, 113235, 113181, 112751, 112461, 112353, 112121, 111783, 111751, 111729, 111165, 111024, 110854, 110840, 110770, 110692, 110650, 110632, 110157, 110070, 109954, 109598, 109572, 109536, 109475, 109407, 109308, 109241, 108977, 108937, 108823, 108789, 108742, 108741, 108670, 108653, 108619, 108573))
Run Time: 0.079024
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
UPDATE `xf_tag_result_cache` SET `expiry_date` = ?, `results` = ? WHERE `result_cache_id` = 799498
Params: 1714794371, {"thread-183141":["thread",183141],"thread-181887":["thread",181887],"thread-180919":["thread",180919],"thread-179842":["thread",179842],"thread-178988":["thread",178988],"thread-178773":["thread",178773],"thread-177737":["thread",177737],"thread-176096":["thread",176096],"thread-173960":["thread",173960],"thread-166638":["thread",166638],"thread-166502":["thread",166502],"thread-165812":["thread",165812],"thread-165609":["thread",165609],"thread-165447":["thread",165447],"thread-164439":["thread",164439],"thread-160305":["thread",160305],"thread-160181":["thread",160181],"thread-155918":["thread",155918],"thread-155745":["thread",155745],"thread-155317":["thread",155317],"thread-154827":["thread",154827],"thread-154487":["thread",154487],"thread-153688":["thread",153688],"thread-152215":["thread",152215],"thread-152128":["thread",152128],"thread-132155":["thread",132155],"thread-132105":["thread",132105],"thread-132096":["thread",132096],"thread-132049":["thread",132049],"thread-132028":["thread",132028],"thread-131997":["thread",131997],"thread-131846":["thread",131846],"thread-131812":["thread",131812],"thread-131759":["thread",131759],"thread-131587":["thread",131587],"thread-131586":["thread",131586],"thread-131540":["thread",131540],"thread-131510":["thread",131510],"thread-131279":["thread",131279],"thread-131277":["thread",131277],"thread-131211":["thread",131211],"thread-131200":["thread",131200],"thread-131111":["thread",131111],"thread-131104":["thread",131104],"thread-131099":["thread",131099],"thread-130853":["thread",130853],"thread-130567":["thread",130567],"thread-130312":["thread",130312],"thread-129942":["thread",129942],"thread-129839":["thread",129839],"thread-129520":["thread",129520],"thread-129456":["thread",129456],"thread-129026":["thread",129026],"thread-128928":["thread",128928],"thread-128830":["thread",128830],"thread-128429":["thread",128429],"thread-128174":["thread",128174],"thread-127890":["thread",127890],"thread-127829":["thread",127829],"thread-127779":["thread",127779],"thread-127767":["thread",127767],"thread-127734":["thread",127734],"thread-127708":["thread",127708],"thread-127644":["thread",127644],"thread-127641":["thread",127641],"thread-127628":["thread",127628],"thread-127579":["thread",127579],"thread-127393":["thread",127393],"thread-127346":["thread",127346],"thread-127181":["thread",127181],"thread-127154":["thread",127154],"thread-127107":["thread",127107],"thread-126945":["thread",126945],"thread-126888":["thread",126888],"thread-126840":["thread",126840],"thread-126765":["thread",126765],"thread-126764":["thread",126764],"thread-126648":["thread",126648],"thread-126261":["thread",126261],"thread-126174":["thread",126174],"thread-126146":["thread",126146],"thread-126108":["thread",126108],"thread-126090":["thread",126090],"thread-125622":["thread",125622],"thread-125355":["thread",125355],"thread-124958":["thread",124958],"thread-124890":["thread",124890],"thread-124658":["thread",124658],"thread-124414":["thread",124414],"thread-124353":["thread",124353],"thread-124074":["thread",124074],"thread-124057":["thread",124057],"thread-124010":["thread",124010],"thread-123991":["thread",123991],"thread-123963":["thread",123963],"thread-123931":["thread",123931],"thread-123928":["thread",123928],"thread-123855":["thread",123855],"thread-123849":["thread",123849],"thread-122984":["thread",122984],"thread-122800":["thread",122800],"thread-122795":["thread",122795],"thread-122762":["thread",122762],"thread-122731":["thread",122731],"thread-121613":["thread",121613],"thread-121612":["thread",121612],"thread-121040":["thread",121040],"thread-120840":["thread",120840],"thread-120759":["thread",120759],"thread-120706":["thread",120706],"thread-120605":["thread",120605],"thread-120572":["thread",120572],"thread-120440":["thread",120440],"thread-120035":["thread",120035],"thread-120016":["thread",120016],"thread-120010":["thread",120010],"thread-120002":["thread",120002],"thread-119653":["thread",119653],"thread-119331":["thread",119331],"thread-119212":["thread",119212],"thread-118881":["thread",118881],"thread-118192":["thread",118192],"thread-118127":["thread",118127],"thread-118119":["thread",118119],"thread-118037":["thread",118037],"thread-118002":["thread",118002],"thread-117952":["thread",117952],"thread-117534":["thread",117534],"thread-117353":["thread",117353],"thread-117339":["thread",117339],"thread-117156":["thread",117156],"thread-117148":["thread",117148],"thread-117043":["thread",117043],"thread-116905":["thread",116905],"thread-116658":["thread",116658],"thread-116500":["thread",116500],"thread-116118":["thread",116118],"thread-116043":["thread",116043],"thread-115999":["thread",115999],"thread-115913":["thread",115913],"thread-115406":["thread",115406],"thread-115156":["thread",115156],"thread-114882":["thread",114882],"thread-114861":["thread",114861],"thread-114734":["thread",114734],"thread-114110":["thread",114110],"thread-113891":["thread",113891],"thread-113853":["thread",113853],"thread-113790":["thread",113790],"thread-113765":["thread",113765],"thread-113745":["thread",113745],"thread-113472":["thread",113472],"thread-113265":["thread",113265],"thread-113235":["thread",113235],"thread-113181":["thread",113181],"thread-112751":["thread",112751],"thread-112461":["thread",112461],"thread-112353":["thread",112353],"thread-112121":["thread",112121],"thread-111783":["thread",111783],"thread-111751":["thread",111751],"thread-111729":["thread",111729],"thread-111165":["thread",111165],"thread-111024":["thread",111024],"thread-110854":["thread",110854],"thread-110840":["thread",110840],"thread-110770":["thread",110770],"thread-110692":["thread",110692],"thread-110650":["thread",110650],"thread-110632":["thread",110632],"thread-110157":["thread",110157],"thread-109954":["thread",109954],"thread-109598":["thread",109598],"thread-109572":["thread",109572],"thread-109475":["thread",109475],"thread-109407":["thread",109407],"thread-109308":["thread",109308],"thread-109241":["thread",109241],"thread-108977":["thread",108977],"thread-108937":["thread",108937],"thread-108823":["thread",108823],"thread-108789":["thread",108789],"thread-108742":["thread",108742],"thread-108741":["thread",108741],"thread-108670":["thread",108670],"thread-108653":["thread",108653],"thread-108619":["thread",108619],"thread-108573":["thread",108573]}
Run Time: 0.000688
- 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