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 (183275, 183251, 182232, 181732, 180982, 178425, 178087, 177585, 177366, 175434, 174721, 167313, 166975, 162419, 161094, 159871, 157423, 157415, 157329, 156038, 155944, 155942, 154338, 153767, 153147, 152651, 151887, 147418, 145374, 141498, 136054, 135463, 130798, 127522, 127162, 126880, 126631, 125160, 122012, 118186, 117027, 116289, 107743, 107690, 107443, 103975, 103806, 101522, 98066, 96285, 91909, 90940, 88612, 87830, 87216, 86988, 86952, 86513, 85347, 85327, 85102, 85077, 84766, 83341, 83057, 82914, 82284, 82270, 82231, 82058, 81719, 81426, 81352, 81126, 81095, 79766, 78493, 78473, 77775, 77056, 77055, 76797, 73275, 70742, 66871, 66063, 66042, 64761, 63775, 63099, 60883, 56946, 53779, 51261, 51122, 47767, 39660, 30290, 26827, 23464, 19088, 9299, 4240, 3507))
Run Time: 0.071285
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 104 | 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: 853, 0, 1715234218, {"thread-183275":["thread",183275],"thread-183251":["thread",183251],"thread-182232":["thread",182232],"thread-181732":["thread",181732],"ams_article-5267":["ams_article",5267],"ams_article-5258":["ams_article",5258],"thread-180982":["thread",180982],"tl_group-338":["tl_group",338],"tl_group-334":["tl_group",334],"thread-178425":["thread",178425],"thread-178087":["thread",178087],"thread-177585":["thread",177585],"thread-177366":["thread",177366],"thread-175434":["thread",175434],"tl_group-302":["tl_group",302],"thread-174721":["thread",174721],"tl_group-263":["tl_group",263],"tl_group-257":["tl_group",257],"thread-167313":["thread",167313],"thread-166975":["thread",166975],"tl_group-209":["tl_group",209],"thread-162419":["thread",162419],"thread-161094":["thread",161094],"thread-159871":["thread",159871],"ams_article-4347":["ams_article",4347],"tl_group-143":["tl_group",143],"thread-157423":["thread",157423],"thread-157415":["thread",157415],"thread-157329":["thread",157329],"thread-156038":["thread",156038],"thread-155944":["thread",155944],"thread-155942":["thread",155942],"thread-154338":["thread",154338],"ams_article-4077":["ams_article",4077],"thread-153767":["thread",153767],"thread-153147":["thread",153147],"ams_article-3992":["ams_article",3992],"thread-152651":["thread",152651],"ams_article-3941":["ams_article",3941],"thread-151887":["thread",151887],"tl_group-26":["tl_group",26],"ams_article-3710":["ams_article",3710],"thread-147418":["thread",147418],"thread-145374":["thread",145374],"thread-141498":["thread",141498],"thread-136054":["thread",136054],"thread-135463":["thread",135463],"thread-130798":["thread",130798],"thread-127522":["thread",127522],"thread-127162":["thread",127162],"thread-126880":["thread",126880],"thread-126631":["thread",126631],"thread-125160":["thread",125160],"thread-122012":["thread",122012],"thread-118186":["thread",118186],"thread-117027":["thread",117027],"thread-116289":["thread",116289],"thread-107743":["thread",107743],"thread-107690":["thread",107690],"thread-107443":["thread",107443],"thread-103975":["thread",103975],"thread-103806":["thread",103806],"thread-101522":["thread",101522],"thread-98066":["thread",98066],"thread-96285":["thread",96285],"thread-91909":["thread",91909],"thread-90940":["thread",90940],"thread-88612":["thread",88612],"thread-87830":["thread",87830],"thread-87216":["thread",87216],"thread-86988":["thread",86988],"thread-86952":["thread",86952],"thread-86513":["thread",86513],"thread-85347":["thread",85347],"thread-85327":["thread",85327],"thread-85102":["thread",85102],"thread-85077":["thread",85077],"thread-84766":["thread",84766],"thread-83341":["thread",83341],"thread-83057":["thread",83057],"thread-82914":["thread",82914],"thread-82284":["thread",82284],"thread-82270":["thread",82270],"thread-82231":["thread",82231],"thread-82058":["thread",82058],"thread-81719":["thread",81719],"thread-81426":["thread",81426],"thread-81352":["thread",81352],"thread-81126":["thread",81126],"thread-81095":["thread",81095],"thread-79766":["thread",79766],"thread-78493":["thread",78493],"thread-78473":["thread",78473],"thread-77775":["thread",77775],"thread-77056":["thread",77056],"thread-77055":["thread",77055],"thread-76797":["thread",76797],"thread-73275":["thread",73275],"thread-70742":["thread",70742],"thread-66871":["thread",66871],"thread-66063":["thread",66063],"thread-66042":["thread",66042],"thread-64761":["thread",64761],"thread-63775":["thread",63775],"thread-63099":["thread",63099],"thread-60883":["thread",60883],"thread-56946":["thread",56946],"thread-53779":["thread",53779],"thread-51261":["thread",51261],"thread-51122":["thread",51122],"thread-47767":["thread",47767],"thread-39660":["thread",39660],"thread-30290":["thread",30290],"thread-26827":["thread",26827],"thread-23464":["thread",23464],"thread-19088":["thread",19088],"thread-9299":["thread",9299],"thread-4240":["thread",4240],"thread-3507":["thread",3507]}, , 1715230618
Run Time: 0.000270
- 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