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 (7217002, 7216117, 7198644, 7176517, 7141938, 7113875, 7075600, 7070066, 7060194, 7040147, 7036704, 6969272, 6479007, 219247, 202180, 201658, 194634, 160912, 156947, 13841, 13623, 13440, 13438, 13293, 13188, 13098, 12939, 12652, 12568, 12209, 12056, 12031, 11586, 11579, 11090, 11009, 10848, 10630, 10401, 10026, 9990, 9885, 9630, 9385, 9380, 9016, 8587, 8569, 8567, 8332, 8238, 8190, 7735, 7564, 7529, 7459, 7371, 7072, 6852, 6676, 6585, 6214, 6140, 5743, 5453, 5101, 4858, 4777, 4767, 4606, 4404, 4344, 4327, 3841, 3475, 3391, 3281, 2942, 2691, 2659, 2582, 2043, 1990, 1911, 1852, 1341, 763, 380, 93))
Run Time: 0.004773
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 89 | 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: 33, 0, 1714859691, {"thread-7217002":["thread",7217002],"thread-7216117":["thread",7216117],"thread-7198644":["thread",7198644],"thread-7176517":["thread",7176517],"thread-7141938":["thread",7141938],"thread-7113875":["thread",7113875],"thread-7075600":["thread",7075600],"thread-7070066":["thread",7070066],"thread-7060194":["thread",7060194],"thread-7040147":["thread",7040147],"thread-7036704":["thread",7036704],"thread-6969272":["thread",6969272],"thread-6479007":["thread",6479007],"thread-219247":["thread",219247],"thread-202180":["thread",202180],"thread-201658":["thread",201658],"thread-194634":["thread",194634],"thread-156947":["thread",156947],"thread-13841":["thread",13841],"thread-13623":["thread",13623],"thread-13440":["thread",13440],"thread-13438":["thread",13438],"thread-13293":["thread",13293],"thread-13188":["thread",13188],"thread-13098":["thread",13098],"thread-12939":["thread",12939],"thread-12652":["thread",12652],"thread-12568":["thread",12568],"thread-12209":["thread",12209],"thread-12056":["thread",12056],"thread-12031":["thread",12031],"thread-11586":["thread",11586],"thread-11579":["thread",11579],"thread-11090":["thread",11090],"thread-11009":["thread",11009],"thread-10848":["thread",10848],"thread-10630":["thread",10630],"thread-10401":["thread",10401],"thread-10026":["thread",10026],"thread-9990":["thread",9990],"thread-9885":["thread",9885],"thread-9630":["thread",9630],"thread-9385":["thread",9385],"thread-9380":["thread",9380],"thread-9016":["thread",9016],"thread-8587":["thread",8587],"thread-8569":["thread",8569],"thread-8567":["thread",8567],"thread-8332":["thread",8332],"thread-8238":["thread",8238],"thread-8190":["thread",8190],"thread-7735":["thread",7735],"thread-7564":["thread",7564],"thread-7529":["thread",7529],"thread-7459":["thread",7459],"thread-7371":["thread",7371],"thread-7072":["thread",7072],"thread-6852":["thread",6852],"thread-6676":["thread",6676],"thread-6585":["thread",6585],"thread-6214":["thread",6214],"thread-6140":["thread",6140],"thread-5743":["thread",5743],"thread-5453":["thread",5453],"thread-5101":["thread",5101],"thread-4858":["thread",4858],"thread-4777":["thread",4777],"thread-4767":["thread",4767],"thread-4606":["thread",4606],"thread-4404":["thread",4404],"thread-4344":["thread",4344],"thread-4327":["thread",4327],"thread-3841":["thread",3841],"thread-3475":["thread",3475],"thread-3391":["thread",3391],"thread-3281":["thread",3281],"thread-2942":["thread",2942],"thread-2691":["thread",2691],"thread-2659":["thread",2659],"thread-2582":["thread",2582],"thread-2043":["thread",2043],"thread-1990":["thread",1990],"thread-1911":["thread",1911],"thread-1852":["thread",1852],"thread-1341":["thread",1341],"thread-763":["thread",763],"thread-380":["thread",380],"thread-93":["thread",93]}, NULL, 1714856091
Run Time: 0.000351
- 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