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 (182960, 182911, 182405, 182301, 181248, 180968, 180924, 180885, 179887, 179856, 179578, 178867, 178861, 178812, 178621, 178607, 178486, 178381, 177919, 177897, 177681, 177665, 177619, 177526, 177115, 177056, 177016, 176875, 176776, 175739, 175682, 175650, 174812, 174807, 174723, 173670, 173363, 173138, 173113, 172374, 171313, 171185, 171181, 171035, 170910, 170732, 170274, 170131, 169879, 169737, 168915, 168833, 168674, 168545, 168284, 167968, 167909, 167906, 167267, 165739, 164512, 164290, 163404, 162841, 162774, 162258, 162216, 160883, 160858, 159842, 158102, 157998, 157582, 157225, 157063, 157054, 155800, 155787, 155782, 155218, 154291, 152996, 152647, 152546, 152539, 152486, 152214, 152128, 152117, 152079, 150753, 150006, 148845, 147649, 146328, 146196, 142891, 141786, 141705, 139954, 113449, 111017, 109904, 109757, 109083, 107938, 105685, 103639, 102177, 102175, 99552, 98792, 98766, 98752, 98579, 96712, 92342, 91675, 91577, 83715, 83151, 83145, 82935, 80552, 78297, 76989, 72281, 70955, 70259, 70255, 69507, 66463, 65709, 65649, 65429, 64517, 61626, 61111, 60807, 60543, 58396, 57583, 57301, 56920, 54520, 54413, 53766, 53623, 53199, 53172, 53166, 53151, 53105, 52967, 52961, 52932, 52916, 52812, 47274, 36410, 33258))
Run Time: 0.080398
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 161 | 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: 4666, 0, 1715667925, {"thread-182960":["thread",182960],"thread-182911":["thread",182911],"thread-182405":["thread",182405],"thread-182301":["thread",182301],"ams_article-5317":["ams_article",5317],"thread-181248":["thread",181248],"thread-180968":["thread",180968],"thread-180924":["thread",180924],"thread-180885":["thread",180885],"thread-179887":["thread",179887],"thread-179856":["thread",179856],"thread-179578":["thread",179578],"thread-178867":["thread",178867],"thread-178861":["thread",178861],"thread-178812":["thread",178812],"thread-178621":["thread",178621],"thread-178607":["thread",178607],"thread-178486":["thread",178486],"thread-178381":["thread",178381],"thread-177919":["thread",177919],"thread-177897":["thread",177897],"thread-177681":["thread",177681],"thread-177665":["thread",177665],"thread-177619":["thread",177619],"thread-177526":["thread",177526],"thread-177115":["thread",177115],"thread-177056":["thread",177056],"thread-177016":["thread",177016],"thread-176875":["thread",176875],"thread-176776":["thread",176776],"thread-175739":["thread",175739],"thread-175682":["thread",175682],"thread-175650":["thread",175650],"thread-174812":["thread",174812],"thread-174807":["thread",174807],"thread-174723":["thread",174723],"thread-173670":["thread",173670],"thread-173363":["thread",173363],"thread-173138":["thread",173138],"thread-173113":["thread",173113],"thread-172374":["thread",172374],"thread-171313":["thread",171313],"thread-171185":["thread",171185],"thread-171181":["thread",171181],"thread-171035":["thread",171035],"thread-170910":["thread",170910],"thread-170732":["thread",170732],"thread-170274":["thread",170274],"thread-170131":["thread",170131],"thread-169879":["thread",169879],"thread-169737":["thread",169737],"thread-168915":["thread",168915],"thread-168833":["thread",168833],"thread-168674":["thread",168674],"thread-168545":["thread",168545],"thread-168284":["thread",168284],"thread-167968":["thread",167968],"thread-167909":["thread",167909],"thread-167906":["thread",167906],"thread-167267":["thread",167267],"ams_article-4725":["ams_article",4725],"thread-165739":["thread",165739],"thread-164512":["thread",164512],"thread-164290":["thread",164290],"ams_article-4564":["ams_article",4564],"thread-163404":["thread",163404],"thread-162841":["thread",162841],"thread-162774":["thread",162774],"thread-162258":["thread",162258],"thread-162216":["thread",162216],"ams_article-4463":["ams_article",4463],"thread-160883":["thread",160883],"thread-160858":["thread",160858],"ams_article-4441":["ams_article",4441],"ams_article-4425":["ams_article",4425],"thread-159842":["thread",159842],"ams_article-4331":["ams_article",4331],"thread-158102":["thread",158102],"thread-157998":["thread",157998],"thread-157582":["thread",157582],"thread-157225":["thread",157225],"ams_article-4272":["ams_article",4272],"thread-157063":["thread",157063],"thread-157054":["thread",157054],"thread-155800":["thread",155800],"thread-155787":["thread",155787],"thread-155782":["thread",155782],"ams_article-4193":["ams_article",4193],"thread-155218":["thread",155218],"thread-154291":["thread",154291],"thread-152996":["thread",152996],"thread-152647":["thread",152647],"thread-152546":["thread",152546],"thread-152539":["thread",152539],"thread-152486":["thread",152486],"thread-152214":["thread",152214],"thread-152128":["thread",152128],"ams_article-3951":["ams_article",3951],"thread-152117":["thread",152117],"thread-152079":["thread",152079],"tl_group-11":["tl_group",11],"thread-150753":["thread",150753],"ams_article-3820":["ams_article",3820],"thread-150006":["thread",150006],"ams_article-3763":["ams_article",3763],"ams_article-3714":["ams_article",3714],"thread-148845":["thread",148845],"ams_article-3687":["ams_article",3687],"ams_article-3641":["ams_article",3641],"thread-147649":["thread",147649],"thread-146328":["thread",146328],"thread-146196":["thread",146196],"ams_article-3479":["ams_article",3479],"thread-142891":["thread",142891],"thread-141786":["thread",141786],"thread-141705":["thread",141705],"thread-139954":["thread",139954],"thread-113449":["thread",113449],"thread-111017":["thread",111017],"thread-109904":["thread",109904],"thread-109757":["thread",109757],"thread-109083":["thread",109083],"thread-107938":["thread",107938],"thread-105685":["thread",105685],"thread-103639":["thread",103639],"thread-102177":["thread",102177],"thread-102175":["thread",102175],"thread-99552":["thread",99552],"thread-98792":["thread",98792],"thread-98766":["thread",98766],"thread-98752":["thread",98752],"thread-98579":["thread",98579],"thread-96712":["thread",96712],"thread-92342":["thread",92342],"thread-91675":["thread",91675],"thread-91577":["thread",91577],"thread-83715":["thread",83715],"thread-83151":["thread",83151],"thread-83145":["thread",83145],"thread-82935":["thread",82935],"thread-80552":["thread",80552],"thread-78297":["thread",78297],"thread-76989":["thread",76989],"thread-72281":["thread",72281],"thread-70955":["thread",70955],"thread-70259":["thread",70259],"thread-70255":["thread",70255],"thread-69507":["thread",69507],"thread-66463":["thread",66463],"thread-65709":["thread",65709],"thread-65649":["thread",65649],"thread-65429":["thread",65429],"thread-64517":["thread",64517],"thread-61626":["thread",61626],"thread-61111":["thread",61111],"thread-60807":["thread",60807],"thread-60543":["thread",60543],"thread-58396":["thread",58396],"thread-57583":["thread",57583],"thread-57301":["thread",57301],"thread-56920":["thread",56920],"thread-54520":["thread",54520],"thread-54413":["thread",54413],"thread-53766":["thread",53766],"thread-53623":["thread",53623],"thread-53199":["thread",53199],"thread-53172":["thread",53172],"thread-53166":["thread",53166],"thread-53151":["thread",53151],"thread-53105":["thread",53105],"thread-52967":["thread",52967],"thread-52961":["thread",52961],"thread-52932":["thread",52932],"thread-52916":["thread",52916],"thread-52812":["thread",52812],"thread-47274":["thread",47274],"thread-36410":["thread",36410],"thread-33258":["thread",33258]}, , 1715664325
Run Time: 0.000384
- 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