Laravel权限查询缓存

Question

我正在使用Laravel权限包(https://github.com/spatie/laravel-permission)来管理Laravel项目的角色权限。

在应用程序的每个页面上，我可以从Laravel调试器中看到以下两个查询正在运行。角色和权限没有那么频繁地更改，我想缓存这些查询。你能告诉我我该怎么做吗？

select `roles`.*, `model_has_roles`.`model_id` as `pivot_model_id`, `model_has_roles`.`role_id` as `pivot_role_id`, `model_has_roles`.`model_type` as `pivot_model_type` from `roles` inner join `model_has_roles` on `roles`.`id` = `model_has_roles`.`role_id` where `model_has_roles`.`model_id` = 1 and `model_has_roles`.`model_type` = 'App\Models\User'

select `permissions`.*, `model_has_permissions`.`model_id` as `pivot_model_id`, `model_has_permissions`.`permission_id` as `pivot_permission_id`, `model_has_permissions`.`model_type` as `pivot_model_type` from `permissions` inner join `model_has_permissions` on `permissions`.`id` = `model_has_permissions`.`permission_id` where `model_has_permissions`.`model_id` = 1 and `model_has_permissions`.`model_type` = 'App\Models\User'

Answer 1

您可以使用this package缓存您的查询。

要在特定查询上启用缓存，您可以执行以下操作：

DB::cacheFor(now()->addHours(24))->raw('YOUR QUERY GOES HERE');