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 (7178736, 7178613, 7132525, 7130923, 7108984, 7101507, 7096824, 7089867, 7084331, 7063972, 7063313, 6996978, 199965, 199884, 162500, 160245, 13840, 13325, 13195, 13194, 13182, 13089, 13042, 12950, 12870, 12825, 12798, 12551, 12524, 12370, 12320, 12311, 12086, 11965, 11963, 11702, 11559, 11386, 11291, 11286, 11123, 11112, 11078, 10950, 10582, 10398, 10226, 10191, 10176, 9524, 9406, 9348, 8830, 8183, 8078, 8059, 8010, 7884, 7869, 7812, 7573, 7332, 7316, 7238, 6973, 6718, 6449, 6375, 6344, 6179, 5853, 5590, 5553, 5356, 5005, 4986, 4912, 4857, 4838, 4787, 4741, 4682, 4625, 4498, 4407, 4264, 4022, 3743, 3654, 3545, 3237, 3083, 2824, 2679, 2652, 2563, 2359, 2355, 2151, 1849, 1811, 1809, 1683, 1545, 1106, 1068, 948, 831, 636, 494))
Run Time: 0.006078
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 110 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,production_xf.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 1430
- 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 2870
- 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 138
- 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 2487
- XF\App->run() in src/XF.php at line 524
- 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: 558, 0, 1714728171, {"thread-7178736":["thread",7178736],"thread-7178613":["thread",7178613],"thread-7132525":["thread",7132525],"thread-7130923":["thread",7130923],"thread-7108984":["thread",7108984],"thread-7101507":["thread",7101507],"thread-7096824":["thread",7096824],"thread-7089867":["thread",7089867],"thread-7084331":["thread",7084331],"thread-7063972":["thread",7063972],"thread-7063313":["thread",7063313],"thread-6996978":["thread",6996978],"thread-199965":["thread",199965],"thread-199884":["thread",199884],"thread-162500":["thread",162500],"thread-160245":["thread",160245],"thread-13840":["thread",13840],"thread-13325":["thread",13325],"thread-13195":["thread",13195],"thread-13194":["thread",13194],"thread-13182":["thread",13182],"thread-13089":["thread",13089],"thread-13042":["thread",13042],"thread-12950":["thread",12950],"thread-12870":["thread",12870],"thread-12825":["thread",12825],"thread-12798":["thread",12798],"thread-12551":["thread",12551],"thread-12524":["thread",12524],"thread-12370":["thread",12370],"thread-12320":["thread",12320],"thread-12311":["thread",12311],"thread-12086":["thread",12086],"thread-11965":["thread",11965],"thread-11963":["thread",11963],"thread-11702":["thread",11702],"thread-11559":["thread",11559],"thread-11386":["thread",11386],"thread-11291":["thread",11291],"thread-11286":["thread",11286],"thread-11123":["thread",11123],"thread-11112":["thread",11112],"thread-11078":["thread",11078],"thread-10950":["thread",10950],"thread-10582":["thread",10582],"thread-10398":["thread",10398],"thread-10226":["thread",10226],"thread-10191":["thread",10191],"thread-10176":["thread",10176],"thread-9524":["thread",9524],"thread-9406":["thread",9406],"thread-9348":["thread",9348],"thread-8830":["thread",8830],"thread-8183":["thread",8183],"thread-8078":["thread",8078],"thread-8059":["thread",8059],"thread-8010":["thread",8010],"thread-7884":["thread",7884],"thread-7869":["thread",7869],"thread-7812":["thread",7812],"thread-7573":["thread",7573],"thread-7332":["thread",7332],"thread-7316":["thread",7316],"thread-7238":["thread",7238],"thread-6973":["thread",6973],"thread-6718":["thread",6718],"thread-6449":["thread",6449],"thread-6375":["thread",6375],"thread-6344":["thread",6344],"thread-6179":["thread",6179],"thread-5853":["thread",5853],"thread-5590":["thread",5590],"thread-5553":["thread",5553],"thread-5356":["thread",5356],"thread-5005":["thread",5005],"thread-4986":["thread",4986],"thread-4912":["thread",4912],"thread-4857":["thread",4857],"thread-4838":["thread",4838],"thread-4787":["thread",4787],"thread-4741":["thread",4741],"thread-4682":["thread",4682],"thread-4625":["thread",4625],"thread-4498":["thread",4498],"thread-4407":["thread",4407],"thread-4264":["thread",4264],"thread-4022":["thread",4022],"thread-3743":["thread",3743],"thread-3654":["thread",3654],"thread-3545":["thread",3545],"thread-3237":["thread",3237],"thread-3083":["thread",3083],"thread-2824":["thread",2824],"thread-2679":["thread",2679],"thread-2652":["thread",2652],"thread-2563":["thread",2563],"thread-2359":["thread",2359],"thread-2355":["thread",2355],"thread-2151":["thread",2151],"thread-1849":["thread",1849],"thread-1811":["thread",1811],"thread-1809":["thread",1809],"thread-1683":["thread",1683],"thread-1545":["thread",1545],"thread-1106":["thread",1106],"thread-1068":["thread",1068],"thread-948":["thread",948],"thread-831":["thread",831],"thread-636":["thread",636],"thread-494":["thread",494]}, NULL, 1714724571
Run Time: 0.000392
- 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 1521
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1253
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 151
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20