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 (183153, 182646, 182365, 180282, 180239, 180024, 180016, 179297, 178925, 178924, 178846, 176620, 176577, 176505, 176311, 175219, 174291, 170795, 170124, 169495, 168573, 167815, 167775, 167625, 167312, 167095, 166297, 166159, 165190, 165154, 164273, 163597, 163405, 163064, 161740, 161032, 158540, 156498, 156391, 156342, 154844, 154034, 147945, 147511, 143830, 143829, 135094, 130129, 129401, 128590, 127603, 125116, 122869, 122093, 121678, 121550, 121526, 121499, 121497, 121459, 121408, 121318, 120872, 120449, 119969, 119754, 118890, 117252, 115298, 113776, 109377, 106718, 105495, 104924, 100412, 98104, 97401, 97149, 96949, 96694, 95134, 92827, 82723, 79745, 74590, 74011, 73934, 73907, 73694, 72803, 71286, 69033, 66201, 61047, 61020, 42555, 35836, 35835))
Run Time: 0.068285
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 98 | 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: 5098, 0, 1715141787, {"thread-183153":["thread",183153],"thread-182646":["thread",182646],"tl_group-383":["tl_group",383],"thread-182365":["thread",182365],"thread-180282":["thread",180282],"thread-180239":["thread",180239],"thread-180024":["thread",180024],"thread-180016":["thread",180016],"thread-179297":["thread",179297],"thread-178925":["thread",178925],"thread-178924":["thread",178924],"thread-178846":["thread",178846],"thread-176620":["thread",176620],"thread-176577":["thread",176577],"thread-176505":["thread",176505],"thread-176311":["thread",176311],"thread-175219":["thread",175219],"thread-174291":["thread",174291],"thread-170795":["thread",170795],"thread-170124":["thread",170124],"thread-169495":["thread",169495],"thread-168573":["thread",168573],"thread-167815":["thread",167815],"thread-167775":["thread",167775],"thread-167625":["thread",167625],"thread-167312":["thread",167312],"thread-167095":["thread",167095],"thread-166297":["thread",166297],"thread-166159":["thread",166159],"thread-165190":["thread",165190],"thread-165154":["thread",165154],"thread-164273":["thread",164273],"thread-163597":["thread",163597],"thread-163405":["thread",163405],"thread-163064":["thread",163064],"thread-161740":["thread",161740],"thread-161032":["thread",161032],"thread-158540":["thread",158540],"thread-156498":["thread",156498],"thread-156391":["thread",156391],"thread-156342":["thread",156342],"thread-154844":["thread",154844],"thread-154034":["thread",154034],"thread-147945":["thread",147945],"thread-147511":["thread",147511],"thread-143830":["thread",143830],"thread-143829":["thread",143829],"thread-135094":["thread",135094],"thread-130129":["thread",130129],"thread-129401":["thread",129401],"thread-128590":["thread",128590],"thread-127603":["thread",127603],"thread-125116":["thread",125116],"thread-122869":["thread",122869],"thread-122093":["thread",122093],"thread-121678":["thread",121678],"thread-121550":["thread",121550],"thread-121526":["thread",121526],"thread-121499":["thread",121499],"thread-121497":["thread",121497],"thread-121459":["thread",121459],"thread-121408":["thread",121408],"thread-121318":["thread",121318],"thread-120872":["thread",120872],"thread-120449":["thread",120449],"thread-119969":["thread",119969],"thread-119754":["thread",119754],"thread-118890":["thread",118890],"thread-117252":["thread",117252],"thread-115298":["thread",115298],"thread-113776":["thread",113776],"thread-109377":["thread",109377],"thread-106718":["thread",106718],"thread-105495":["thread",105495],"thread-104924":["thread",104924],"thread-100412":["thread",100412],"thread-98104":["thread",98104],"thread-97401":["thread",97401],"thread-97149":["thread",97149],"thread-96949":["thread",96949],"thread-96694":["thread",96694],"thread-95134":["thread",95134],"thread-92827":["thread",92827],"thread-82723":["thread",82723],"thread-79745":["thread",79745],"thread-74590":["thread",74590],"thread-74011":["thread",74011],"thread-73934":["thread",73934],"thread-73907":["thread",73907],"thread-73694":["thread",73694],"thread-72803":["thread",72803],"thread-71286":["thread",71286],"thread-69033":["thread",69033],"thread-66201":["thread",66201],"thread-61047":["thread",61047],"thread-61020":["thread",61020],"thread-42555":["thread",42555],"thread-35836":["thread",35836],"thread-35835":["thread",35835]}, , 1715138187
Run Time: 0.000264
- 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