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 (183354, 183259, 182196, 182128, 181708, 181553, 181521, 181431, 181360, 180445, 179929, 179742, 179710, 179582, 179456, 179386, 179322, 177984, 177717, 176357, 175258, 175247, 175212, 175132, 174426, 173944, 173426, 173209, 172987, 171666, 171516, 171515, 170999, 170800, 170603, 170576, 170574, 170523, 170420, 170233, 169915, 169594, 169151, 169134, 168976, 168624, 168323, 168044, 167979, 167885, 167884, 167832, 167805, 167782, 167322, 167232, 167229, 167184, 167027, 166648, 164891, 164890, 159337, 159291, 159290, 157978, 157936, 157899, 157898, 157815, 156750, 154321, 154043, 153969, 153835, 152749, 152683, 152674, 152211, 150880, 149425, 140745, 137325, 137007, 136184, 135175, 126748, 124805, 113648, 110439, 109343, 104894, 101666, 95933, 90944, 82037, 81751, 79964, 75709, 75384, 75355, 75354, 74945, 74263, 74140, 73912, 72294, 72281, 65910, 63728, 63658, 54134, 29891, 3081, 2495, 2494, 1827, 1237))
Run Time: 0.102992
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 118 | 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: 380, 0, 1716187026, {"thread-183354":["thread",183354],"thread-183259":["thread",183259],"thread-182196":["thread",182196],"thread-182128":["thread",182128],"thread-181708":["thread",181708],"thread-181553":["thread",181553],"thread-181521":["thread",181521],"thread-181431":["thread",181431],"thread-181360":["thread",181360],"thread-180445":["thread",180445],"thread-179929":["thread",179929],"thread-179742":["thread",179742],"thread-179710":["thread",179710],"thread-179582":["thread",179582],"thread-179456":["thread",179456],"thread-179386":["thread",179386],"thread-179322":["thread",179322],"thread-177984":["thread",177984],"thread-177717":["thread",177717],"thread-176357":["thread",176357],"thread-175258":["thread",175258],"thread-175247":["thread",175247],"thread-175212":["thread",175212],"thread-175132":["thread",175132],"thread-174426":["thread",174426],"thread-173944":["thread",173944],"thread-173426":["thread",173426],"thread-173209":["thread",173209],"thread-172987":["thread",172987],"ams_article-4921":["ams_article",4921],"tl_group-279":["tl_group",279],"thread-171516":["thread",171516],"thread-171515":["thread",171515],"thread-170999":["thread",170999],"thread-170800":["thread",170800],"thread-170603":["thread",170603],"thread-170576":["thread",170576],"thread-170574":["thread",170574],"thread-170523":["thread",170523],"thread-170420":["thread",170420],"thread-170233":["thread",170233],"thread-169915":["thread",169915],"thread-169594":["thread",169594],"thread-169151":["thread",169151],"thread-169134":["thread",169134],"thread-168976":["thread",168976],"thread-168624":["thread",168624],"thread-168323":["thread",168323],"thread-168044":["thread",168044],"thread-167979":["thread",167979],"thread-167885":["thread",167885],"thread-167884":["thread",167884],"thread-167832":["thread",167832],"thread-167805":["thread",167805],"thread-167782":["thread",167782],"thread-167322":["thread",167322],"thread-167232":["thread",167232],"thread-167229":["thread",167229],"thread-167184":["thread",167184],"thread-167027":["thread",167027],"thread-166648":["thread",166648],"thread-164891":["thread",164891],"thread-164890":["thread",164890],"thread-159337":["thread",159337],"thread-159291":["thread",159291],"thread-159290":["thread",159290],"thread-157978":["thread",157978],"thread-157936":["thread",157936],"thread-157899":["thread",157899],"thread-157898":["thread",157898],"thread-157815":["thread",157815],"thread-156750":["thread",156750],"thread-154321":["thread",154321],"thread-154043":["thread",154043],"thread-153969":["thread",153969],"tl_group-93":["tl_group",93],"thread-153835":["thread",153835],"ams_article-4045":["ams_article",4045],"thread-152749":["thread",152749],"thread-152683":["thread",152683],"thread-152674":["thread",152674],"thread-152211":["thread",152211],"tl_group-11":["tl_group",11],"thread-150880":["thread",150880],"thread-149425":["thread",149425],"thread-140745":["thread",140745],"ams_article-3050":["ams_article",3050],"thread-137325":["thread",137325],"thread-137007":["thread",137007],"thread-136184":["thread",136184],"thread-135175":["thread",135175],"thread-126748":["thread",126748],"thread-124805":["thread",124805],"thread-113648":["thread",113648],"thread-110439":["thread",110439],"thread-109343":["thread",109343],"thread-104894":["thread",104894],"thread-101666":["thread",101666],"thread-95933":["thread",95933],"thread-90944":["thread",90944],"thread-82037":["thread",82037],"thread-81751":["thread",81751],"thread-79964":["thread",79964],"thread-75709":["thread",75709],"thread-75384":["thread",75384],"thread-75355":["thread",75355],"thread-75354":["thread",75354],"thread-74945":["thread",74945],"thread-74263":["thread",74263],"thread-74140":["thread",74140],"thread-73912":["thread",73912],"thread-72294":["thread",72294],"thread-72281":["thread",72281],"thread-65910":["thread",65910],"thread-63728":["thread",63728],"thread-63658":["thread",63658],"thread-54134":["thread",54134],"thread-29891":["thread",29891],"thread-3081":["thread",3081],"thread-2495":["thread",2495],"thread-2494":["thread",2494],"thread-1827":["thread",1827],"thread-1237":["thread",1237]}, , 1716183426
Run Time: 0.000403
- 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