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 (7182772, 7157125, 7133306, 7133305, 13747, 13678, 13533, 13290, 13215, 13156, 13108, 13071, 12979, 12970, 12960, 12934, 12837, 12807, 12640, 12537, 12519, 12376, 12357, 12210, 11855, 11784, 11721, 11694, 11625, 11512, 11491, 11396, 11334, 11294, 11268, 11158, 11156, 11099, 11050, 10908, 10828, 10822, 10661, 10652, 10647, 10617, 10604, 10563, 10498, 10474, 10404, 10305, 10013, 9890, 9841, 9759, 9753, 9552, 9451, 9421, 9059, 9049, 8926, 8745, 8718, 8583, 8580, 8408, 8402, 8386, 8292, 8263, 8104, 8029, 7920, 7829, 7710, 7656, 7655, 7523, 7500, 7473, 7326, 7321, 7241, 7221, 7176, 7143, 7066, 7018, 6659, 6609, 6398, 6271, 6229, 6218, 6200, 6181, 5915, 5911, 5893, 5867, 5696, 5635, 5633, 5518, 5475, 5424, 5328, 5281, 5241, 5050, 5000, 4967, 4851, 4825, 4778, 4693, 4683, 4640, 4637, 4430, 4424, 4372, 4323, 4233, 4127, 4098, 4027, 4023, 4016, 3995, 3987, 3929, 3892, 3882, 3873, 3847, 3792, 3771, 3755, 3749, 3701, 3693, 3520, 3454, 3404, 3397, 3396, 3387, 3283, 3129, 3122, 2998, 2923, 2869, 2856, 2802, 2786, 2721, 2697, 2470, 2429, 2289, 2261, 2169, 2096, 2082, 2056, 2001, 1887, 1872, 1818, 1782, 1706, 1704, 1656, 1298, 1244, 1237, 1072, 1064, 954, 794, 742, 597, 519, 451, 369))
Run Time: 0.008267
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 189 | 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: 399, 0, 1714684950, {"thread-7182772":["thread",7182772],"thread-7157125":["thread",7157125],"thread-7133306":["thread",7133306],"thread-7133305":["thread",7133305],"thread-13747":["thread",13747],"thread-13678":["thread",13678],"thread-13533":["thread",13533],"thread-13290":["thread",13290],"thread-13215":["thread",13215],"thread-13156":["thread",13156],"thread-13108":["thread",13108],"thread-13071":["thread",13071],"thread-12979":["thread",12979],"thread-12970":["thread",12970],"thread-12960":["thread",12960],"thread-12934":["thread",12934],"thread-12837":["thread",12837],"thread-12807":["thread",12807],"thread-12640":["thread",12640],"thread-12537":["thread",12537],"thread-12519":["thread",12519],"thread-12376":["thread",12376],"thread-12357":["thread",12357],"thread-12210":["thread",12210],"thread-11855":["thread",11855],"thread-11784":["thread",11784],"thread-11721":["thread",11721],"thread-11694":["thread",11694],"thread-11625":["thread",11625],"thread-11512":["thread",11512],"thread-11491":["thread",11491],"thread-11396":["thread",11396],"thread-11334":["thread",11334],"thread-11294":["thread",11294],"thread-11268":["thread",11268],"thread-11158":["thread",11158],"thread-11156":["thread",11156],"thread-11099":["thread",11099],"thread-11050":["thread",11050],"thread-10908":["thread",10908],"thread-10828":["thread",10828],"thread-10822":["thread",10822],"thread-10661":["thread",10661],"thread-10652":["thread",10652],"thread-10647":["thread",10647],"thread-10617":["thread",10617],"thread-10604":["thread",10604],"thread-10563":["thread",10563],"thread-10498":["thread",10498],"thread-10474":["thread",10474],"thread-10404":["thread",10404],"thread-10305":["thread",10305],"thread-10013":["thread",10013],"thread-9890":["thread",9890],"thread-9841":["thread",9841],"thread-9759":["thread",9759],"thread-9753":["thread",9753],"thread-9552":["thread",9552],"thread-9451":["thread",9451],"thread-9421":["thread",9421],"thread-9059":["thread",9059],"thread-9049":["thread",9049],"thread-8926":["thread",8926],"thread-8745":["thread",8745],"thread-8718":["thread",8718],"thread-8583":["thread",8583],"thread-8580":["thread",8580],"thread-8408":["thread",8408],"thread-8402":["thread",8402],"thread-8386":["thread",8386],"thread-8292":["thread",8292],"thread-8263":["thread",8263],"thread-8104":["thread",8104],"thread-8029":["thread",8029],"thread-7920":["thread",7920],"thread-7829":["thread",7829],"thread-7710":["thread",7710],"thread-7656":["thread",7656],"thread-7655":["thread",7655],"thread-7523":["thread",7523],"thread-7500":["thread",7500],"thread-7473":["thread",7473],"thread-7326":["thread",7326],"thread-7321":["thread",7321],"thread-7241":["thread",7241],"thread-7221":["thread",7221],"thread-7176":["thread",7176],"thread-7143":["thread",7143],"thread-7066":["thread",7066],"thread-7018":["thread",7018],"thread-6659":["thread",6659],"thread-6609":["thread",6609],"thread-6398":["thread",6398],"thread-6271":["thread",6271],"thread-6229":["thread",6229],"thread-6218":["thread",6218],"thread-6200":["thread",6200],"thread-6181":["thread",6181],"thread-5915":["thread",5915],"thread-5911":["thread",5911],"thread-5893":["thread",5893],"thread-5867":["thread",5867],"thread-5696":["thread",5696],"thread-5635":["thread",5635],"thread-5633":["thread",5633],"thread-5518":["thread",5518],"thread-5475":["thread",5475],"thread-5424":["thread",5424],"thread-5328":["thread",5328],"thread-5281":["thread",5281],"thread-5241":["thread",5241],"thread-5050":["thread",5050],"thread-5000":["thread",5000],"thread-4967":["thread",4967],"thread-4851":["thread",4851],"thread-4825":["thread",4825],"thread-4778":["thread",4778],"thread-4693":["thread",4693],"thread-4683":["thread",4683],"thread-4640":["thread",4640],"thread-4637":["thread",4637],"thread-4430":["thread",4430],"thread-4424":["thread",4424],"thread-4372":["thread",4372],"thread-4323":["thread",4323],"thread-4233":["thread",4233],"thread-4127":["thread",4127],"thread-4098":["thread",4098],"thread-4027":["thread",4027],"thread-4023":["thread",4023],"thread-4016":["thread",4016],"thread-3995":["thread",3995],"thread-3987":["thread",3987],"thread-3929":["thread",3929],"thread-3892":["thread",3892],"thread-3882":["thread",3882],"thread-3873":["thread",3873],"thread-3847":["thread",3847],"thread-3792":["thread",3792],"thread-3771":["thread",3771],"thread-3755":["thread",3755],"thread-3749":["thread",3749],"thread-3701":["thread",3701],"thread-3693":["thread",3693],"thread-3520":["thread",3520],"thread-3454":["thread",3454],"thread-3404":["thread",3404],"thread-3397":["thread",3397],"thread-3396":["thread",3396],"thread-3387":["thread",3387],"thread-3283":["thread",3283],"thread-3129":["thread",3129],"thread-3122":["thread",3122],"thread-2998":["thread",2998],"thread-2923":["thread",2923],"thread-2869":["thread",2869],"thread-2856":["thread",2856],"thread-2802":["thread",2802],"thread-2786":["thread",2786],"thread-2721":["thread",2721],"thread-2697":["thread",2697],"thread-2470":["thread",2470],"thread-2429":["thread",2429],"thread-2289":["thread",2289],"thread-2261":["thread",2261],"thread-2169":["thread",2169],"thread-2096":["thread",2096],"thread-2082":["thread",2082],"thread-2056":["thread",2056],"thread-2001":["thread",2001],"thread-1887":["thread",1887],"thread-1872":["thread",1872],"thread-1818":["thread",1818],"thread-1782":["thread",1782],"thread-1706":["thread",1706],"thread-1704":["thread",1704],"thread-1656":["thread",1656],"thread-1298":["thread",1298],"thread-1244":["thread",1244],"thread-1237":["thread",1237],"thread-1072":["thread",1072],"thread-1064":["thread",1064],"thread-954":["thread",954],"thread-794":["thread",794],"thread-742":["thread",742],"thread-597":["thread",597],"thread-519":["thread",519],"thread-451":["thread",451],"thread-369":["thread",369]}, NULL, 1714681350
Run Time: 0.000496
- 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