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 (183918, 183625, 183376, 183134, 182775, 182555, 182522, 182520, 182412, 182280, 182035, 182023, 181256, 180957, 180903, 180767, 179579, 179414, 178974, 178930, 178882, 178635, 178098, 178077, 177385, 177196, 177053, 176739, 176595, 176064, 176024, 175835, 175356, 175191, 174661, 174549, 173959, 173505, 173136, 173025, 172867, 172853, 172474, 172345, 170919, 170290, 170191, 168661, 168393, 168346, 168304, 168170, 168161, 168125, 168124, 168110, 168104, 168103, 167881, 167435, 167154, 167115, 166915, 166617, 166530, 166452, 166451, 166372, 166078, 166045, 166004, 166003, 165952, 165835, 165326, 165325, 165035, 164202, 163984, 163887, 163886, 163781, 163535, 162701, 161952, 161858, 161283, 161137, 160963, 160836, 160835, 160834, 160830, 160829, 160823, 160821, 160777, 160724, 160723, 160574, 160566, 160561, 160525, 159899, 159763, 159662, 158545, 158051, 158046, 158045, 157374, 157074, 156856, 156143, 156075, 156063, 155618, 155479, 155042, 154441, 153700, 152700, 152487, 152485, 152211, 151806, 148505, 148475, 147069, 146101, 143704, 143347, 140781, 140143, 140058, 139991, 139350, 138072, 136543, 136470, 134743, 134459, 133893, 133058, 132564, 132084, 131849, 131379, 131175, 131170, 131124, 130658, 130569, 130456, 130455, 130287, 129737, 129319, 129275, 128895, 128860, 128807, 128427, 127989, 127144, 126885, 126647, 126230, 126109, 124880, 124786, 124512, 124271, 124268, 124179, 124109, 124108, 124107, 122832, 122555, 122545, 122498, 122325, 122010, 121857, 121310, 121219, 120938, 120893, 120521, 120121, 119618, 118875, 118811, 118751, 118709, 118543, 118030))
Run Time: 0.146052
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 198 | 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` = 820466
Params: 1716818825, {"thread-183918":["thread",183918],"thread-183625":["thread",183625],"thread-183376":["thread",183376],"thread-183134":["thread",183134],"thread-182775":["thread",182775],"thread-182555":["thread",182555],"thread-182522":["thread",182522],"thread-182520":["thread",182520],"thread-182412":["thread",182412],"thread-182280":["thread",182280],"thread-182035":["thread",182035],"thread-182023":["thread",182023],"thread-181256":["thread",181256],"thread-180957":["thread",180957],"thread-180903":["thread",180903],"thread-180767":["thread",180767],"thread-179579":["thread",179579],"thread-179414":["thread",179414],"thread-178974":["thread",178974],"thread-178930":["thread",178930],"thread-178882":["thread",178882],"thread-178635":["thread",178635],"thread-178098":["thread",178098],"thread-178077":["thread",178077],"thread-177385":["thread",177385],"thread-177196":["thread",177196],"thread-177053":["thread",177053],"thread-176739":["thread",176739],"thread-176595":["thread",176595],"thread-176064":["thread",176064],"thread-176024":["thread",176024],"thread-175835":["thread",175835],"ams_article-5080":["ams_article",5080],"thread-175356":["thread",175356],"thread-175191":["thread",175191],"thread-174661":["thread",174661],"thread-174549":["thread",174549],"thread-173959":["thread",173959],"thread-173505":["thread",173505],"thread-173136":["thread",173136],"thread-173025":["thread",173025],"thread-172867":["thread",172867],"thread-172853":["thread",172853],"thread-172474":["thread",172474],"thread-172345":["thread",172345],"ams_article-4840":["ams_article",4840],"thread-170919":["thread",170919],"thread-170290":["thread",170290],"thread-170191":["thread",170191],"thread-168661":["thread",168661],"thread-168393":["thread",168393],"thread-168346":["thread",168346],"thread-168304":["thread",168304],"thread-168170":["thread",168170],"thread-168161":["thread",168161],"thread-168125":["thread",168125],"thread-168124":["thread",168124],"thread-168110":["thread",168110],"thread-168104":["thread",168104],"thread-168103":["thread",168103],"thread-167881":["thread",167881],"thread-167435":["thread",167435],"thread-167154":["thread",167154],"thread-167115":["thread",167115],"thread-166915":["thread",166915],"thread-166617":["thread",166617],"thread-166530":["thread",166530],"thread-166452":["thread",166452],"thread-166451":["thread",166451],"thread-166372":["thread",166372],"thread-166078":["thread",166078],"thread-166045":["thread",166045],"thread-166004":["thread",166004],"thread-166003":["thread",166003],"thread-165952":["thread",165952],"thread-165835":["thread",165835],"thread-165326":["thread",165326],"thread-165325":["thread",165325],"thread-165035":["thread",165035],"thread-164202":["thread",164202],"thread-163984":["thread",163984],"thread-163887":["thread",163887],"thread-163886":["thread",163886],"thread-163781":["thread",163781],"thread-163535":["thread",163535],"thread-162701":["thread",162701],"thread-161952":["thread",161952],"thread-161858":["thread",161858],"thread-161283":["thread",161283],"thread-161137":["thread",161137],"thread-160963":["thread",160963],"thread-160836":["thread",160836],"thread-160835":["thread",160835],"thread-160834":["thread",160834],"thread-160830":["thread",160830],"thread-160829":["thread",160829],"thread-160823":["thread",160823],"thread-160821":["thread",160821],"thread-160777":["thread",160777],"thread-160724":["thread",160724],"thread-160723":["thread",160723],"thread-160574":["thread",160574],"thread-160566":["thread",160566],"thread-160561":["thread",160561],"thread-160525":["thread",160525],"thread-159899":["thread",159899],"thread-159763":["thread",159763],"thread-159662":["thread",159662],"thread-158545":["thread",158545],"thread-158051":["thread",158051],"thread-158046":["thread",158046],"thread-158045":["thread",158045],"thread-157374":["thread",157374],"thread-157074":["thread",157074],"thread-156856":["thread",156856],"thread-156143":["thread",156143],"thread-156075":["thread",156075],"thread-156063":["thread",156063],"thread-155618":["thread",155618],"thread-155479":["thread",155479],"thread-155042":["thread",155042],"thread-154441":["thread",154441],"thread-153700":["thread",153700],"thread-152700":["thread",152700],"thread-152487":["thread",152487],"thread-152485":["thread",152485],"thread-152211":["thread",152211],"thread-151806":["thread",151806],"thread-148505":["thread",148505],"thread-148475":["thread",148475],"thread-147069":["thread",147069],"thread-146101":["thread",146101],"thread-143704":["thread",143704],"thread-143347":["thread",143347],"thread-140781":["thread",140781],"thread-140143":["thread",140143],"thread-140058":["thread",140058],"thread-139991":["thread",139991],"thread-139350":["thread",139350],"thread-138072":["thread",138072],"thread-136543":["thread",136543],"thread-136470":["thread",136470],"thread-134743":["thread",134743],"thread-134459":["thread",134459],"thread-133893":["thread",133893],"thread-133058":["thread",133058],"thread-132564":["thread",132564],"thread-132084":["thread",132084],"thread-131849":["thread",131849],"thread-131379":["thread",131379],"thread-131175":["thread",131175],"thread-131170":["thread",131170],"thread-131124":["thread",131124],"thread-130658":["thread",130658],"thread-130569":["thread",130569],"thread-130456":["thread",130456],"thread-130455":["thread",130455],"thread-130287":["thread",130287],"thread-129737":["thread",129737],"thread-129319":["thread",129319],"thread-129275":["thread",129275],"thread-128895":["thread",128895],"thread-128860":["thread",128860],"thread-128807":["thread",128807],"thread-128427":["thread",128427],"thread-127989":["thread",127989],"thread-127144":["thread",127144],"thread-126885":["thread",126885],"thread-126647":["thread",126647],"thread-126230":["thread",126230],"thread-126109":["thread",126109],"thread-124880":["thread",124880],"thread-124786":["thread",124786],"thread-124512":["thread",124512],"thread-124271":["thread",124271],"thread-124268":["thread",124268],"thread-124179":["thread",124179],"thread-124109":["thread",124109],"thread-124108":["thread",124108],"thread-124107":["thread",124107],"thread-122832":["thread",122832],"thread-122555":["thread",122555],"thread-122545":["thread",122545],"thread-122498":["thread",122498],"thread-122325":["thread",122325],"thread-122010":["thread",122010],"thread-121857":["thread",121857],"thread-121310":["thread",121310],"thread-121219":["thread",121219],"thread-120938":["thread",120938],"thread-120893":["thread",120893],"thread-120521":["thread",120521],"thread-120121":["thread",120121],"thread-119618":["thread",119618],"thread-118875":["thread",118875],"thread-118811":["thread",118811],"thread-118751":["thread",118751],"thread-118709":["thread",118709],"thread-118543":["thread",118543],"thread-118030":["thread",118030]}
Run Time: 0.000325
- 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