如何将debug json保存到laravel中的数据库？

Question

我用api_token编写了一个带有auth的rest API，并使用Lanin的调试器来显示错误发生的时间。如果api_token错误，调试程序将显示如下所示

{
"error": "Unauthenticated.",
"debug": {
    "database": {
        "total": 1,
        "items": [
            {
                "connection": "mysql",
                "query": "select * from `users` where `api_token` = '630dcedd96aa370891b1649a972b577b2f262c90093b1903ae0a2ea63cf2c07cs' limit 1;",
                "time": 2.89
            }
        ]
    },
    "cache": {
        "hit": {
            "keys": [
                "424f74a6a7ed4d4ed4761507ebcd209a6ef0937b"
            ],
            "total": 1
        },
        "miss": {
            "keys": [
                "424f74a6a7ed4d4ed4761507ebcd209a6ef0937b",
                "424f74a6a7ed4d4ed4761507ebcd209a6ef0937b:timer",
                "424f74a6a7ed4d4ed4761507ebcd209a6ef0937b"
            ],
            "total": 3
        },
        "write": {
            "keys": [
                "424f74a6a7ed4d4ed4761507ebcd209a6ef0937b:timer",
                "424f74a6a7ed4d4ed4761507ebcd209a6ef0937b"
            ],
            "total": 2
        },
        "forget": {
            "keys": [],
            "total": 0
        }
    },
    "profiling": [
        {
            "event": "request-time",
            "time": 0.2898838520050049
        }
    ],
    "memory": {
        "usage": 11831808,
        "peak": 11896088
    }
}

}

并且我想将错误日志保存到数据库中。如果要将此数据保存到表数据库中，如何保存和读取数据？我想保存查询

"debug": {
"database": {
    "total": 1,
    "items": [
        {
            "connection": "mysql",
            **"query": "select * from `users` where `api_token` = '630dcedd96aa370891b1649a972b577b2f262c90093b1903ae0a2ea63cf2c07cs' limit 1;",
            "time": 2.89**
        }
    ]
},

Answer 1

使用适当的模型(使用"connection“、"query”和"time“字段进行调试)，您可以将json解码为一个数组并从中创建模型。

如下所示：

$jsonArray = json_decode($rawJson, true);
$debug = Debug:create($jsonArray);