sanmanto-sds/laravel-query-log

Laravel SQL 查询日志库。

维护者

详细信息

github.com/sanmanto-sds/laravel-query-log

源代码

问题

安装次数: 119

依赖者: 0

建议者: 0

安全: 0

星标: 0

关注者: 1

分支: 0

公开问题: 0

v1.1.0 2023-06-02 14:14 UTC

Requires

MIT 7c27f09ca2e4a658e96c74eeb2f896b27c26ec4f

  • dev <dev.woop@sanmanto.com>

logsqlquerylaravel

This package is auto-updated.

Last update: 2024-09-19 23:22:59 UTC

README

Laravel SQL 查询日志库。

要求

  • PHP >= 7.4
  • Laravel >= 8.0

安装

通过 composer 安装此包

composer require sanmanto-sds/laravel-query-log

配置

将 true 定义为开始查询日志

QUERY_LOG_ENABLE=true

示例

Laravel 查询

DB::beginTransaction();

$user = User::create([
    'email' => 'john.doe@example.com',
    'password' => bcrypt('YP5fQDadZzjcm4E'),
]);

$sql = 'insert into "user_profiles" ("user_id", "first_name", "last_name", "country")';
$sql .= ' values (:user_id, :first_name, :last_name, :country)';

DB::insert($sql, [
    'user_id' => $user->id,
    'first_name' => 'John',
    'last_name' => 'Doe',
    'country' => 'Australia'
]);

DB::commit();

记录结果

[2022-03-06 18:16:31] local.DEBUG: Query from 'pgsql' connection:
TRANSACTION BEGIN

[2022-03-06 18:16:32] local.DEBUG: Query from 'pgsql' connection. Time 1.890000 ms. SQL:
insert into "users" ("email", "password", "updated_at", "created_at") values ('john.doe@example.com', 'y$xQgcnNqoxaanrF3tFh2YweNFr/rhr8jfUpbdrlNoe6rPf22xIqGxy', '2022-03-06 18:16:32', '2022-03-06 18:16:32') retu
rning "id"

[2022-03-06 18:16:32] local.DEBUG: Query from 'pgsql' connection. Time 1.600000 ms. SQL:
insert into "user_profiles" ("user_id", "first_name", "last_name", "country") values (1, 'John', 'Doe', 'Australia')

[2022-03-06 18:16:32] local.DEBUG: Query from 'pgsql' connection:
TRANSACTION COMMIT