laravel 打印完整sql语句

laravel5

用DB自带的getQueryLog方法直接打印：

DB::connection()->enableQueryLog();  // 开启QueryLog
\App\User::find(1);
dump(DB::getQueryLog());

• 1
• 2
• 3

得到的结果语句与参数是分开的，非常不方便验证

[
  0 => array:3 [▼
    "query" => "select * from `mall_users` where `mall_users`.`id` = ? limit 1"
    "bindings" => array:1 [▼
      0 => 1
    ]
    "time" => 11.87
  ]
]

• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9

---

若要打印出完整的sql语句，可将以下代码复制到AppServiceProvider中的boot方法中：

\DB::listen(
    function ($sql) {
        foreach ($sql->bindings as $i => $binding) {
            if ($binding instanceof \DateTime) {
                $sql->bindings[$i] = $binding->format('\'Y-m-d H:i:s\'');
            } else {
                if (is_string($binding)) {
                    $sql->bindings[$i] = "'$binding'";
                }
            }
        }

        // Insert bindings into query
        $query = str_replace(array('%', '?'), array('%%', '%s'), $sql->sql);

        $query = vsprintf($query, $sql->bindings);

        // Save the query to file
        $logFile = fopen(
            storage_path('logs' . DIRECTORY_SEPARATOR . date('Y-m-d') . '_query.log'),
            'a+'
        );
        fwrite($logFile, date('Y-m-d H:i:s') . ': ' . $query . PHP_EOL);
        fclose($logFile);
    }
);

• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26

日志在storage/log/xxx_query.log

---

　
转载来源：Laravel5：sql语句的正确打印方式_larvel中的打印方式-CSDN博客