PHPackages                             guanguans/laravel-dump-sql - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. guanguans/laravel-dump-sql

ActiveLaravel[Database & ORM](/categories/database)

guanguans/laravel-dump-sql
==========================

laravel 中轻松容易的输出完整的 SQL 语句。 - Easy output of complete SQL statements for laravel framework.

2.5.0(2y ago)3635.6k—9.4%5MITPHPPHP >=7.3CI passing

Since Jul 12Pushed 1mo ago1 watchersCompare

[ Source](https://github.com/guanguans/laravel-dump-sql)[ Packagist](https://packagist.org/packages/guanguans/laravel-dump-sql)[ Fund](https://www.guanguans.cn/images/wechat.jpeg)[ Patreon](https://www.patreon.com/guanguans)[ RSS](/packages/guanguans-laravel-dump-sql/feed)WikiDiscussions master Synced 1mo ago

READMEChangelog (8)Dependencies (17)Versions (35)Used By (0)

laravel-dump-sql
================

[](#laravel-dump-sql)

[![](docs/dump-server.gif)](docs/dump-server.gif)

[![tests](https://github.com/guanguans/laravel-dump-sql/workflows/tests/badge.svg)](https://github.com/guanguans/laravel-dump-sql/actions)[![check & fix styling](https://github.com/guanguans/laravel-dump-sql/actions/workflows/php-cs-fixer.yml/badge.svg)](https://github.com/guanguans/laravel-dump-sql/actions)[![codecov](https://camo.githubusercontent.com/d30bf6bf3c6b974e15bef04ba3648298b5c7810523b86ce634c4bccd5e54f7e4/68747470733a2f2f636f6465636f762e696f2f67682f6775616e6775616e732f6c61726176656c2d64756d702d73716c2f67726170682f62616467652e7376673f746f6b656e3d4b4a544947534b443044)](https://codecov.io/gh/guanguans/laravel-dump-sql)[![Latest Stable Version](https://camo.githubusercontent.com/b1343f9d71eef6af3bd7e400d46e3b81f4ec49c62508d830ba7406cce463de82/68747470733a2f2f706f7365722e707567782e6f72672f6775616e6775616e732f6c61726176656c2d64756d702d73716c2f76)](//packagist.org/packages/guanguans/laravel-dump-sql)[![Total Downloads](https://camo.githubusercontent.com/15f7a381e440411abdde1e578475b7c8b3a9cd82857e863377e9abee48c53d99/68747470733a2f2f706f7365722e707567782e6f72672f6775616e6775616e732f6c61726176656c2d64756d702d73716c2f646f776e6c6f616473)](//packagist.org/packages/guanguans/laravel-dump-sql)[![License](https://camo.githubusercontent.com/48876e067f1719a03e52f3ddcd9930ac84fde5c23df35b4ecb01aa3fa1f6fcdc/68747470733a2f2f706f7365722e707567782e6f72672f6775616e6775616e732f6c61726176656c2d64756d702d73716c2f6c6963656e7365)](//packagist.org/packages/guanguans/laravel-dump-sql)

> Assist laravel application to obtain complete sql statement. - 辅助 laravel 应用获取完整的 sql 语句。

> The sql statement obtained by the query construction method in laravel is not bound to the conditional parameters, similar to `select * from users where id= ?`. This expansion pack can help you get a complete sql statement. - laravel 中查询构造方法得到的 sql 语句没有绑定条件参数，类似于`select * from users where id= ?`。这个扩展包可辅助你获取完整的 sql 语句。

功能
--

[](#功能)

- 添加获取 sql 语句的查询构建便捷方法(`toRawSql`、`dumpSql`、`ddSql`、`logListenedSql`、`dumpListenedSql`、`ddListenedSql`)
- 添加监控 sql 语句的服务命令

环境要求
----

[](#环境要求)

- laravel || lumen >= 6.10

安装
--

[](#安装)

```
$ composer require guanguans/laravel-dump-sql -v
```

### lumen 中配置(laravel 中请忽略)

[](#lumen-中配置laravel-中请忽略)

将下面代码添加到 `bootstrap/app.php` 文件中的 `Register Service Providers` 部分

```
$app->register(\Guanguans\LaravelDumpSql\ServiceProvider::class);
```

使用
--

[](#使用)

### 监控 sql 语句的服务的使用

[](#监控-sql-语句的服务的使用)

```
$ php artisan server:dump-sql
```

[![](docs/dump-server.png)](docs/dump-server.png)

### 获取 sql 语句的查询构建便捷方法的使用

[](#获取-sql-语句的查询构建便捷方法的使用)

安装配置完毕后数据库查询构造方法会新增以下几个方法：

- toRawSql() - 获取完整的 sql
- dumpSql() - 打印完整的 sql
- ddSql() - 打印完整的 sql 并且退出
- logListenedSql() - 记录被监听到的 sql
- dumpListenedSql() - 打印被监听到的 sql
- ddListenedSql() - 打印被监听到的 sql 并且退出

#### toRawSql() - 获取完整的 sql

[](#torawsql---获取完整的-sql)

```
$sql = User::query()->where('id', 1)->toRawSql();
dd($sql);
```

```
"select * from `xb_users` where `id` = 1"
```

#### dumpSql() - 打印完整的 sql

[](#dumpsql---打印完整的-sql)

```
User::query()->where('id', 1)->dumpSql();
User::query()->where('id', 2)->dumpSql();
```

```
"select * from `xb_users` where `id` = 1"
"select * from `xb_users` where `id` = 2"
```

#### ddSql() - 打印完整的 sql 并且退出

[](#ddsql---打印完整的-sql-并且退出)

```
User::query()->where('id', 1)->ddSql();
User::query()->where('id', 2)->ddSql();
```

```
"select * from `xb_users` where `id` = 1"
```

#### logListenedSql() - 记录被监听到的 sql

[](#loglistenedsql---记录被监听到的-sql)

```
User::query()->where('id', 1)->logListenedSql()->first();
User::query()->where('id', 2)->first();
```

```
# 日志中
[Laravel] [39.97ms] select * from `xb_users` where `id` = '1' limit 1 | GET: /
[Laravel] [39.93ms] select * from `xb_users` where `id` = '2' limit 1 | GET: /
```

#### dumpListenedSql() - 打印被监听到的 sql

[](#dumplistenedsql---打印被监听到的-sql)

```
User::query()->where('id', 1)->dumpListenedSql()->first();
User::query()->where('id', 2)->first();
```

```
[Laravel] [39.97ms] select * from `xb_users` where `id` = '1' limit 1 | GET: /
[Laravel] [39.93ms] select * from `xb_users` where `id` = '2' limit 1 | GET: /
```

#### ddListenedSql() - 打印被监听到的 sql 并且退出

[](#ddlistenedsql---打印被监听到的-sql-并且退出)

```
User::query()->where('id', 1)->ddListenedSql()->first();
User::query()->where('id', 2)->first();
```

```
[Laravel] [39.97ms] select * from `xb_users` where `id` = '1' limit 1 | GET: /
```

安全漏洞
----

[](#安全漏洞)

请查看[我们的安全政策](../../security/policy)了解如何报告安全漏洞。

贡献者
---

[](#贡献者)

- [guanguans](https://github.com/guanguans)
- [所有贡献者](../../contributors)

协议
--

[](#协议)

MIT 许可证（MIT）。有关更多信息，请参见[协议文件](LICENSE)。

###  Health Score

47

—

FairBetter than 94% of packages

Maintenance59

Moderate activity, may be stable

Popularity40

Moderate usage in the ecosystem

Community14

Small or concentrated contributor base

Maturity61

Established project with proven stability

 Bus Factor1

Top contributor holds 73.7% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~44 days

Recently: every ~178 days

Total

31

Last Release

796d ago

Major Versions

v1.2.2 → v2.0.02021-11-03

PHP version history (3 changes)v1.1.1PHP >=7.1

v2.0.0PHP >=7.2

2.4.0PHP >=7.3

### Community

Maintainers

![](https://www.gravatar.com/avatar/a49e4a0625bdf47c4e2924dcf07a053538d0c3a1e9287e8d6bfe68ed4017aa6f?d=identicon)[guanguans](/maintainers/guanguans)

---

Top Contributors

[![guanguans](https://avatars.githubusercontent.com/u/22309277?v=4)](https://github.com/guanguans "guanguans (157 commits)")[![dependabot[bot]](https://avatars.githubusercontent.com/in/29110?v=4)](https://github.com/dependabot[bot] "dependabot[bot] (37 commits)")[![github-actions[bot]](https://avatars.githubusercontent.com/in/15368?v=4)](https://github.com/github-actions[bot] "github-actions[bot] (14 commits)")[![ImgBotApp](https://avatars.githubusercontent.com/u/31427850?v=4)](https://github.com/ImgBotApp "ImgBotApp (5 commits)")

---

Tags

dumplaravelmysqlsqllaraveldebugdumpmysqlsqldd

###  Code Quality

TestsPHPUnit

Static AnalysisPsalm, Rector

Code StylePHP CS Fixer

Type Coverage Yes

### Embed Badge

![Health badge](/badges/guanguans-laravel-dump-sql/health.svg)

```
[![Health](https://phpackages.com/badges/guanguans-laravel-dump-sql/health.svg)](https://phpackages.com/packages/guanguans-laravel-dump-sql)
```

###  Alternatives

[laravel/cashier

Laravel Cashier provides an expressive, fluent interface to Stripe's subscription billing services.

2.5k25.9M107](/packages/laravel-cashier)[roots/acorn

Framework for Roots WordPress projects built with Laravel components.

9682.1M97](/packages/roots-acorn)[tucker-eric/eloquentfilter

An Eloquent way to filter Eloquent Models

1.8k4.8M26](/packages/tucker-eric-eloquentfilter)[clickbar/laravel-magellan

This package provides functionality for working with the postgis extension in Laravel.

423715.4k1](/packages/clickbar-laravel-magellan)[toponepercent/baum

Baum is an implementation of the Nested Set pattern for Eloquent models.

3154.7k](/packages/toponepercent-baum)[aedart/athenaeum

Athenaeum is a mono repository; a collection of various PHP packages

245.2k](/packages/aedart-athenaeum)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)