|
@kxg3030 就以这段代码为例子,daily_sentence 、category 表总数据量低于 20 条,也会出现死锁,出现死锁的时候 mysql 和 redis 的资源利用率不超过 20%,:
```php
#[GetMapping(path: '')]
public function getSpecifyDailySentence(RequestInterface $request)
{
$date = $request->input('publish_at', date('Y-m-d'));
$dailySentence = DailySentence::where('publish_at', $date)->with(['category'])->first();
if (!$dailySentence) {
$dailySentence = DailySentence::orderBy('publish_at', 'desc')->with(['category'])->first();
}
return new DailySentenceResource($dailySentence);
}
```
想请教下,我这样是哪里使用方法有问题? |