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 (5695, 5694, 5668, 5667, 5650, 5649, 5627, 5625, 5597, 5596, 5572, 5571, 5546, 5545, 5544, 5513, 5512, 5489, 5488, 5465, 5464, 5444, 5443, 5442, 5422, 5421, 5420, 5369, 5368, 5367, 5344, 5343, 5321, 5320, 5319, 5288, 5287, 5286, 5260, 5259, 5242, 5241, 5240, 5219, 5218, 5217, 5198, 5197, 5196, 5175, 5174, 5145, 5144, 5143, 5109, 5108, 5107, 5077, 5076, 5075, 5057, 5056, 5055, 5024, 5023, 4989, 4988, 4987, 4961, 4960, 4959, 4958, 4932, 4931, 4930, 4901, 4900, 4899, 4875, 4874, 4873, 4856, 4855, 4854, 4823, 4822, 4821, 4794, 4793, 4792, 4759, 4758, 4757, 4728, 4727, 4726, 4687, 4686, 4685, 4656, 4644, 4643, 4614, 4608, 4607, 4576, 4575, 4548, 4546, 4523, 4519, 4509, 4508, 4504, 4474, 4473, 4471, 4442, 4421, 4391, 4378, 4355, 4331, 4267, 4266, 4245, 4244, 4207, 4206, 4171, 4169))
Run Time: 0.002197
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 131 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | foru_12.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | foru_12.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | foru_12.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | foru_12.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,foru_12.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: 533, 0, 1714111718, {"thread-5695":["thread",5695],"thread-5694":["thread",5694],"thread-5668":["thread",5668],"thread-5667":["thread",5667],"thread-5650":["thread",5650],"thread-5649":["thread",5649],"thread-5627":["thread",5627],"thread-5625":["thread",5625],"thread-5597":["thread",5597],"thread-5596":["thread",5596],"thread-5572":["thread",5572],"thread-5571":["thread",5571],"thread-5546":["thread",5546],"thread-5545":["thread",5545],"thread-5544":["thread",5544],"thread-5513":["thread",5513],"thread-5512":["thread",5512],"thread-5489":["thread",5489],"thread-5488":["thread",5488],"thread-5465":["thread",5465],"thread-5464":["thread",5464],"thread-5444":["thread",5444],"thread-5443":["thread",5443],"thread-5442":["thread",5442],"thread-5422":["thread",5422],"thread-5421":["thread",5421],"thread-5420":["thread",5420],"thread-5369":["thread",5369],"thread-5368":["thread",5368],"thread-5367":["thread",5367],"thread-5344":["thread",5344],"thread-5343":["thread",5343],"thread-5321":["thread",5321],"thread-5320":["thread",5320],"thread-5319":["thread",5319],"thread-5288":["thread",5288],"thread-5287":["thread",5287],"thread-5286":["thread",5286],"thread-5260":["thread",5260],"thread-5259":["thread",5259],"thread-5242":["thread",5242],"thread-5241":["thread",5241],"thread-5240":["thread",5240],"thread-5219":["thread",5219],"thread-5218":["thread",5218],"thread-5217":["thread",5217],"thread-5198":["thread",5198],"thread-5197":["thread",5197],"thread-5196":["thread",5196],"thread-5175":["thread",5175],"thread-5174":["thread",5174],"thread-5145":["thread",5145],"thread-5144":["thread",5144],"thread-5143":["thread",5143],"thread-5109":["thread",5109],"thread-5108":["thread",5108],"thread-5107":["thread",5107],"thread-5077":["thread",5077],"thread-5076":["thread",5076],"thread-5075":["thread",5075],"thread-5057":["thread",5057],"thread-5056":["thread",5056],"thread-5055":["thread",5055],"thread-5024":["thread",5024],"thread-5023":["thread",5023],"thread-4989":["thread",4989],"thread-4988":["thread",4988],"thread-4987":["thread",4987],"thread-4961":["thread",4961],"thread-4960":["thread",4960],"thread-4959":["thread",4959],"thread-4958":["thread",4958],"thread-4932":["thread",4932],"thread-4931":["thread",4931],"thread-4930":["thread",4930],"thread-4901":["thread",4901],"thread-4900":["thread",4900],"thread-4899":["thread",4899],"thread-4875":["thread",4875],"thread-4874":["thread",4874],"thread-4873":["thread",4873],"thread-4856":["thread",4856],"thread-4855":["thread",4855],"thread-4854":["thread",4854],"thread-4823":["thread",4823],"thread-4822":["thread",4822],"thread-4821":["thread",4821],"thread-4794":["thread",4794],"thread-4793":["thread",4793],"thread-4792":["thread",4792],"thread-4759":["thread",4759],"thread-4758":["thread",4758],"thread-4757":["thread",4757],"thread-4728":["thread",4728],"thread-4727":["thread",4727],"thread-4726":["thread",4726],"thread-4687":["thread",4687],"thread-4686":["thread",4686],"thread-4685":["thread",4685],"thread-4656":["thread",4656],"thread-4644":["thread",4644],"thread-4643":["thread",4643],"thread-4614":["thread",4614],"thread-4608":["thread",4608],"thread-4607":["thread",4607],"thread-4576":["thread",4576],"thread-4575":["thread",4575],"thread-4548":["thread",4548],"thread-4546":["thread",4546],"thread-4523":["thread",4523],"thread-4519":["thread",4519],"thread-4509":["thread",4509],"thread-4508":["thread",4508],"thread-4504":["thread",4504],"thread-4474":["thread",4474],"thread-4473":["thread",4473],"thread-4471":["thread",4471],"thread-4442":["thread",4442],"thread-4421":["thread",4421],"thread-4391":["thread",4391],"thread-4378":["thread",4378],"thread-4355":["thread",4355],"thread-4331":["thread",4331],"thread-4267":["thread",4267],"thread-4266":["thread",4266],"thread-4245":["thread",4245],"thread-4244":["thread",4244],"thread-4207":["thread",4207],"thread-4206":["thread",4206],"thread-4171":["thread",4171],"thread-4169":["thread",4169]}, NULL, 1714108118
Run Time: 0.000121
- 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