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 (160707, 160164, 158971, 154237, 153906, 153886, 153653, 153648, 153154, 152952, 151788, 151577, 151449, 151218, 150845, 150802, 150667, 150204, 150191, 149796, 148614, 148122, 147960, 147631, 146780, 146461, 146387, 146312, 146216, 145979, 145872, 145834, 145184, 144730, 143773, 143704, 143568, 143105, 142721, 142550, 141573, 141503, 138336, 138265, 138095, 137888, 136937, 136922, 136453, 136018, 135360, 135354, 135003, 134585, 132780, 132660, 132642, 132435, 131809, 131623, 131372, 131124, 131122, 130877, 130838, 130808, 130787, 130761, 130422, 130183, 130178, 130134, 129991, 129768, 129025, 128961, 128902, 128808, 128782, 128687, 128554, 128521, 128494, 128459, 128362, 128340, 128339, 128294, 128259, 128178, 127953, 127922, 127581, 127498, 127126, 127065, 127053, 127030, 126479, 126296, 126048, 125258, 125212, 125144, 124908, 124759, 123725, 123661, 123646, 123469, 123443, 123432, 123192, 121795, 121358, 121356, 121242, 120716, 120581, 120397, 120385, 119563, 119531, 119404, 118834, 118167, 117818, 117723, 117458, 117075, 117037, 116941, 116939, 116841, 116803, 115987, 115234, 115094, 114365, 113639, 113627, 113602, 113578, 113516, 113426, 113189, 113138, 113063, 113046, 112202, 111946, 111889, 111813, 111755, 111721, 111604, 111456, 111070, 110972, 110679, 110639, 110625, 110585, 110507, 110485, 110472, 110352, 110351, 110303, 110095, 109580, 109545, 109471, 109427, 109275, 108983, 108905, 108849, 108801, 108626, 108620))
Run Time: 0.139842
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 181 | 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: 804, 0, 1716025995, {"tl_group-328":["tl_group",328],"thread-160707":["thread",160707],"thread-160164":["thread",160164],"thread-158971":["thread",158971],"ams_article-4290":["ams_article",4290],"ams_article-4149":["ams_article",4149],"ams_article-4125":["ams_article",4125],"ams_article-4108":["ams_article",4108],"ams_article-4103":["ams_article",4103],"thread-154237":["thread",154237],"thread-153906":["thread",153906],"thread-153886":["thread",153886],"ams_article-4062":["ams_article",4062],"thread-153653":["thread",153653],"thread-153648":["thread",153648],"ams_article-4044":["ams_article",4044],"thread-153154":["thread",153154],"thread-152952":["thread",152952],"ams_article-3992":["ams_article",3992],"ams_article-3951":["ams_article",3951],"ams_article-3939":["ams_article",3939],"thread-151788":["thread",151788],"thread-151577":["thread",151577],"thread-151449":["thread",151449],"thread-151218":["thread",151218],"ams_article-3869":["ams_article",3869],"thread-150845":["thread",150845],"thread-150802":["thread",150802],"thread-150667":["thread",150667],"ams_article-3807":["ams_article",3807],"thread-150204":["thread",150204],"thread-150191":["thread",150191],"ams_article-3782":["ams_article",3782],"thread-149796":["thread",149796],"ams_article-3714":["ams_article",3714],"thread-148614":["thread",148614],"thread-148122":["thread",148122],"thread-147960":["thread",147960],"thread-147631":["thread",147631],"thread-146780":["thread",146780],"thread-146461":["thread",146461],"thread-146387":["thread",146387],"thread-146312":["thread",146312],"thread-146216":["thread",146216],"thread-145979":["thread",145979],"thread-145872":["thread",145872],"thread-145834":["thread",145834],"thread-145184":["thread",145184],"thread-144730":["thread",144730],"thread-143773":["thread",143773],"thread-143704":["thread",143704],"thread-143568":["thread",143568],"thread-143105":["thread",143105],"ams_article-3330":["ams_article",3330],"thread-142721":["thread",142721],"thread-142550":["thread",142550],"ams_article-3287":["ams_article",3287],"thread-141573":["thread",141573],"thread-141503":["thread",141503],"thread-138336":["thread",138336],"thread-138265":["thread",138265],"thread-138095":["thread",138095],"thread-137888":["thread",137888],"thread-136937":["thread",136937],"thread-136922":["thread",136922],"thread-136453":["thread",136453],"thread-136018":["thread",136018],"thread-135360":["thread",135360],"thread-135354":["thread",135354],"thread-135003":["thread",135003],"thread-134585":["thread",134585],"thread-132780":["thread",132780],"thread-132660":["thread",132660],"thread-132642":["thread",132642],"thread-132435":["thread",132435],"thread-131809":["thread",131809],"thread-131623":["thread",131623],"thread-131372":["thread",131372],"thread-131124":["thread",131124],"thread-131122":["thread",131122],"thread-130877":["thread",130877],"thread-130838":["thread",130838],"thread-130808":["thread",130808],"thread-130787":["thread",130787],"thread-130761":["thread",130761],"thread-130422":["thread",130422],"thread-130183":["thread",130183],"thread-130178":["thread",130178],"thread-130134":["thread",130134],"thread-129991":["thread",129991],"thread-129768":["thread",129768],"thread-129025":["thread",129025],"thread-128961":["thread",128961],"thread-128902":["thread",128902],"thread-128808":["thread",128808],"thread-128782":["thread",128782],"thread-128687":["thread",128687],"thread-128554":["thread",128554],"thread-128521":["thread",128521],"thread-128494":["thread",128494],"thread-128459":["thread",128459],"thread-128362":["thread",128362],"thread-128340":["thread",128340],"thread-128339":["thread",128339],"thread-128294":["thread",128294],"thread-128259":["thread",128259],"thread-128178":["thread",128178],"thread-127953":["thread",127953],"thread-127922":["thread",127922],"thread-127581":["thread",127581],"thread-127498":["thread",127498],"thread-127126":["thread",127126],"thread-127065":["thread",127065],"thread-127053":["thread",127053],"thread-127030":["thread",127030],"thread-126479":["thread",126479],"thread-126296":["thread",126296],"thread-126048":["thread",126048],"thread-125258":["thread",125258],"thread-125212":["thread",125212],"thread-125144":["thread",125144],"thread-124908":["thread",124908],"thread-124759":["thread",124759],"thread-123725":["thread",123725],"thread-123661":["thread",123661],"thread-123646":["thread",123646],"thread-123469":["thread",123469],"thread-123443":["thread",123443],"thread-123432":["thread",123432],"thread-123192":["thread",123192],"thread-121795":["thread",121795],"thread-121358":["thread",121358],"thread-121356":["thread",121356],"thread-121242":["thread",121242],"thread-120716":["thread",120716],"thread-120581":["thread",120581],"thread-120397":["thread",120397],"thread-120385":["thread",120385],"thread-119563":["thread",119563],"thread-119531":["thread",119531],"thread-119404":["thread",119404],"thread-118834":["thread",118834],"thread-118167":["thread",118167],"thread-117818":["thread",117818],"thread-117723":["thread",117723],"thread-117458":["thread",117458],"thread-117075":["thread",117075],"thread-117037":["thread",117037],"thread-116941":["thread",116941],"thread-116939":["thread",116939],"thread-116841":["thread",116841],"thread-116803":["thread",116803],"thread-115987":["thread",115987],"thread-115234":["thread",115234],"thread-115094":["thread",115094],"thread-114365":["thread",114365],"thread-113639":["thread",113639],"thread-113627":["thread",113627],"thread-113602":["thread",113602],"thread-113578":["thread",113578],"thread-113516":["thread",113516],"thread-113426":["thread",113426],"thread-113189":["thread",113189],"thread-113138":["thread",113138],"thread-113063":["thread",113063],"thread-113046":["thread",113046],"thread-112202":["thread",112202],"thread-111946":["thread",111946],"thread-111889":["thread",111889],"thread-111813":["thread",111813],"thread-111755":["thread",111755],"thread-111721":["thread",111721],"thread-111604":["thread",111604],"thread-111456":["thread",111456],"thread-111070":["thread",111070],"thread-110972":["thread",110972],"thread-110679":["thread",110679],"thread-110639":["thread",110639],"thread-110625":["thread",110625],"thread-110585":["thread",110585],"thread-110507":["thread",110507],"thread-110485":["thread",110485],"thread-110472":["thread",110472],"thread-110352":["thread",110352],"thread-110351":["thread",110351],"thread-110303":["thread",110303],"thread-110095":["thread",110095],"thread-109580":["thread",109580],"thread-109545":["thread",109545],"thread-109471":["thread",109471],"thread-109427":["thread",109427],"thread-109275":["thread",109275],"thread-108983":["thread",108983],"thread-108905":["thread",108905],"thread-108849":["thread",108849],"thread-108801":["thread",108801],"thread-108626":["thread",108626],"thread-108620":["thread",108620]}, , 1716022395
Run Time: 0.001344
- 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