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 (183094, 182849, 182722, 182721, 181252, 181018, 179937, 179368, 178578, 178528, 178524, 178465, 178464, 178462, 178304, 178203, 178028, 177448, 177407, 176984, 176539, 176338, 176269, 175864, 174447, 173475, 172816, 172722, 171658, 171569, 170241, 169157, 168813, 168786, 165415, 165252, 163906, 163772, 163513, 163392, 161455, 161399, 161172, 159927, 159904, 158773, 157831, 156963, 155857, 155503, 154623, 153814, 153368, 153026, 152987, 152807, 134936, 131002, 129458, 129452, 125970, 125444, 124886, 121303, 119152, 118585, 117542, 117464, 117451, 117434, 117414, 114179, 113319, 110171, 109773, 109675, 109222, 109074, 108351, 108069, 103378, 102880, 101373, 100906, 96235, 95928, 95349, 93527, 93249, 92349, 92343, 92318, 84049, 83348, 83347, 82379, 74021, 73197, 71494, 71283, 71280, 70656, 70652, 69554, 69127, 68839, 68040, 67291, 61615, 60988, 60510, 58648, 51755, 48653, 45422, 42283, 41140, 39218, 38324, 36184, 27706, 26309, 19888, 17677, 3079))
Run Time: 0.069125
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 125 | 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: 771, 0, 1715148130, {"thread-183094":["thread",183094],"thread-182849":["thread",182849],"thread-182722":["thread",182722],"thread-182721":["thread",182721],"thread-181252":["thread",181252],"thread-181018":["thread",181018],"thread-179937":["thread",179937],"thread-179368":["thread",179368],"thread-178578":["thread",178578],"thread-178528":["thread",178528],"thread-178524":["thread",178524],"thread-178465":["thread",178465],"thread-178464":["thread",178464],"thread-178462":["thread",178462],"thread-178304":["thread",178304],"thread-178028":["thread",178028],"thread-177448":["thread",177448],"thread-176984":["thread",176984],"ams_article-5126":["ams_article",5126],"thread-176539":["thread",176539],"thread-176338":["thread",176338],"thread-176269":["thread",176269],"thread-175864":["thread",175864],"thread-174447":["thread",174447],"thread-173475":["thread",173475],"thread-172816":["thread",172816],"thread-172722":["thread",172722],"thread-171658":["thread",171658],"thread-171569":["thread",171569],"thread-170241":["thread",170241],"thread-169157":["thread",169157],"thread-168813":["thread",168813],"thread-168786":["thread",168786],"thread-165415":["thread",165415],"thread-165252":["thread",165252],"thread-163906":["thread",163906],"thread-163772":["thread",163772],"thread-163513":["thread",163513],"thread-163392":["thread",163392],"tl_group-194":["tl_group",194],"thread-161455":["thread",161455],"thread-161399":["thread",161399],"thread-161172":["thread",161172],"thread-159927":["thread",159927],"thread-159904":["thread",159904],"thread-158773":["thread",158773],"tl_group-149":["tl_group",149],"thread-157831":["thread",157831],"thread-156963":["thread",156963],"thread-155857":["thread",155857],"thread-155503":["thread",155503],"thread-154623":["thread",154623],"thread-153814":["thread",153814],"thread-153368":["thread",153368],"thread-153026":["thread",153026],"thread-152987":["thread",152987],"thread-152807":["thread",152807],"thread-134936":["thread",134936],"thread-131002":["thread",131002],"thread-129458":["thread",129458],"thread-129452":["thread",129452],"thread-125970":["thread",125970],"thread-125444":["thread",125444],"thread-124886":["thread",124886],"thread-121303":["thread",121303],"thread-119152":["thread",119152],"thread-118585":["thread",118585],"thread-117542":["thread",117542],"thread-117464":["thread",117464],"thread-117451":["thread",117451],"thread-117434":["thread",117434],"thread-117414":["thread",117414],"thread-114179":["thread",114179],"thread-113319":["thread",113319],"thread-110171":["thread",110171],"thread-109773":["thread",109773],"thread-109675":["thread",109675],"thread-109222":["thread",109222],"thread-109074":["thread",109074],"thread-108351":["thread",108351],"thread-108069":["thread",108069],"thread-103378":["thread",103378],"thread-102880":["thread",102880],"thread-101373":["thread",101373],"thread-100906":["thread",100906],"thread-96235":["thread",96235],"thread-95928":["thread",95928],"thread-95349":["thread",95349],"thread-93527":["thread",93527],"thread-93249":["thread",93249],"thread-92349":["thread",92349],"thread-92343":["thread",92343],"thread-92318":["thread",92318],"thread-84049":["thread",84049],"thread-83348":["thread",83348],"thread-83347":["thread",83347],"thread-82379":["thread",82379],"thread-74021":["thread",74021],"thread-73197":["thread",73197],"thread-71494":["thread",71494],"thread-71283":["thread",71283],"thread-71280":["thread",71280],"thread-70656":["thread",70656],"thread-70652":["thread",70652],"thread-69554":["thread",69554],"thread-69127":["thread",69127],"thread-68839":["thread",68839],"thread-68040":["thread",68040],"thread-67291":["thread",67291],"thread-61615":["thread",61615],"thread-60988":["thread",60988],"thread-60510":["thread",60510],"thread-58648":["thread",58648],"thread-51755":["thread",51755],"thread-48653":["thread",48653],"thread-45422":["thread",45422],"thread-42283":["thread",42283],"thread-41140":["thread",41140],"thread-39218":["thread",39218],"thread-38324":["thread",38324],"thread-36184":["thread",36184],"thread-27706":["thread",27706],"thread-26309":["thread",26309],"thread-19888":["thread",19888],"thread-17677":["thread",17677],"thread-3079":["thread",3079]}, , 1715144530
Run Time: 0.000448
- 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