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 (183101, 182628, 182593, 182438, 181874, 181555, 181247, 181180, 181142, 180577, 180575, 180568, 180445, 179938, 179887, 179009, 178395, 178126, 177565, 176885, 176819, 176436, 176190, 176177, 176109, 175767, 175638, 175607, 175473, 174726, 174408, 174342, 173619, 173442, 173295, 173053, 172481, 172473, 172422, 171980, 171180, 171091, 171090, 171053, 170954, 170908, 169467, 168766, 168373, 167986, 167430, 167379, 167169, 166818, 166533, 166222, 165867, 165492, 165420, 165170, 164769, 164742, 164715, 164553, 164222, 163837, 163639, 163436, 163228, 163136, 162712, 162582, 161589, 161453, 160117, 159774, 159413, 159208, 158832, 158627, 157763, 157194, 156511, 156030, 155463, 154336, 153560, 153262, 152883, 152126, 151868, 151853, 151796, 141957, 135353, 135248, 135115, 135113, 131349, 130960, 130711, 127937, 115824, 109278, 108881, 108730, 108621, 105791, 105721, 103731, 103709, 98709, 92149, 88817, 87126, 80205, 72898, 70625, 69940, 65043, 60316, 58634, 56979, 54015, 53447, 50559, 49921, 49915, 49866, 49795, 49382, 49005, 48971, 48703, 48677, 48407, 48305, 44324, 41947, 39976, 31418, 24936, 23876, 20885, 18309, 5152))
Run Time: 0.089217
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 146 | 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: 1113, 0, 1715847901, {"thread-183101":["thread",183101],"thread-182628":["thread",182628],"thread-182593":["thread",182593],"thread-182438":["thread",182438],"thread-181874":["thread",181874],"thread-181555":["thread",181555],"thread-181247":["thread",181247],"thread-181180":["thread",181180],"thread-181142":["thread",181142],"thread-180577":["thread",180577],"thread-180575":["thread",180575],"thread-180568":["thread",180568],"thread-180445":["thread",180445],"thread-179938":["thread",179938],"thread-179887":["thread",179887],"thread-179009":["thread",179009],"thread-178395":["thread",178395],"thread-178126":["thread",178126],"thread-177565":["thread",177565],"thread-176885":["thread",176885],"thread-176819":["thread",176819],"thread-176436":["thread",176436],"thread-176190":["thread",176190],"thread-176177":["thread",176177],"thread-176109":["thread",176109],"thread-175767":["thread",175767],"thread-175638":["thread",175638],"thread-175607":["thread",175607],"thread-175473":["thread",175473],"thread-174726":["thread",174726],"thread-174408":["thread",174408],"thread-174342":["thread",174342],"thread-173619":["thread",173619],"thread-173442":["thread",173442],"thread-173295":["thread",173295],"thread-173053":["thread",173053],"ams_article-4926":["ams_article",4926],"thread-172481":["thread",172481],"thread-172473":["thread",172473],"thread-172422":["thread",172422],"thread-171980":["thread",171980],"thread-171180":["thread",171180],"thread-171091":["thread",171091],"thread-171090":["thread",171090],"thread-171053":["thread",171053],"thread-170954":["thread",170954],"thread-170908":["thread",170908],"thread-169467":["thread",169467],"thread-168766":["thread",168766],"thread-168373":["thread",168373],"thread-167986":["thread",167986],"thread-167430":["thread",167430],"thread-167379":["thread",167379],"thread-167169":["thread",167169],"thread-166818":["thread",166818],"thread-166533":["thread",166533],"thread-166222":["thread",166222],"thread-165867":["thread",165867],"thread-165492":["thread",165492],"thread-165420":["thread",165420],"thread-165170":["thread",165170],"thread-164769":["thread",164769],"thread-164742":["thread",164742],"thread-164715":["thread",164715],"thread-164553":["thread",164553],"thread-164222":["thread",164222],"thread-163837":["thread",163837],"thread-163639":["thread",163639],"thread-163436":["thread",163436],"thread-163228":["thread",163228],"thread-163136":["thread",163136],"thread-162712":["thread",162712],"thread-162582":["thread",162582],"thread-161589":["thread",161589],"thread-161453":["thread",161453],"thread-160117":["thread",160117],"thread-159774":["thread",159774],"thread-159413":["thread",159413],"thread-159208":["thread",159208],"thread-158832":["thread",158832],"thread-158627":["thread",158627],"thread-157763":["thread",157763],"thread-157194":["thread",157194],"thread-156511":["thread",156511],"thread-156030":["thread",156030],"thread-155463":["thread",155463],"thread-154336":["thread",154336],"thread-153560":["thread",153560],"thread-153262":["thread",153262],"thread-152883":["thread",152883],"thread-152126":["thread",152126],"thread-151868":["thread",151868],"thread-151853":["thread",151853],"thread-151796":["thread",151796],"thread-141957":["thread",141957],"thread-135353":["thread",135353],"thread-135248":["thread",135248],"thread-135115":["thread",135115],"thread-135113":["thread",135113],"thread-131349":["thread",131349],"thread-130960":["thread",130960],"thread-130711":["thread",130711],"thread-127937":["thread",127937],"thread-115824":["thread",115824],"thread-109278":["thread",109278],"thread-108881":["thread",108881],"thread-108730":["thread",108730],"thread-108621":["thread",108621],"thread-105791":["thread",105791],"thread-105721":["thread",105721],"thread-103731":["thread",103731],"thread-103709":["thread",103709],"thread-98709":["thread",98709],"thread-92149":["thread",92149],"thread-88817":["thread",88817],"thread-87126":["thread",87126],"thread-80205":["thread",80205],"thread-72898":["thread",72898],"thread-70625":["thread",70625],"thread-69940":["thread",69940],"thread-65043":["thread",65043],"thread-60316":["thread",60316],"thread-58634":["thread",58634],"thread-56979":["thread",56979],"thread-54015":["thread",54015],"thread-53447":["thread",53447],"thread-50559":["thread",50559],"thread-49921":["thread",49921],"thread-49915":["thread",49915],"thread-49866":["thread",49866],"thread-49795":["thread",49795],"thread-49382":["thread",49382],"thread-49005":["thread",49005],"thread-48971":["thread",48971],"thread-48703":["thread",48703],"thread-48677":["thread",48677],"thread-48407":["thread",48407],"thread-48305":["thread",48305],"thread-44324":["thread",44324],"thread-41947":["thread",41947],"thread-39976":["thread",39976],"thread-31418":["thread",31418],"thread-24936":["thread",24936],"thread-23876":["thread",23876],"thread-20885":["thread",20885],"thread-18309":["thread",18309],"thread-5152":["thread",5152]}, , 1715844301
Run Time: 0.000583
- 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