There is no problem not worth solving, and no technology not worth learning!

In Laravel TeleScope’s Job Queries, some SQL statements are not documented

在 Laravel Telescope 的 Job Queries 中,一些 SQL 语句未被记录。Queries (22) ,实际上远不止 22 条

1. In Laravel TeleScope’s Job queries, some SQL statements are not recorded. Queries (22) is actually far more than 22. as shown in Figure 1

在 Laravel Telescope 的 Job Queries 中,一些 SQL 语句未被记录。Queries (22) ,实际上远不止 22 条
Figure 1

2. Check Laravel/Tescope in composer.json, its version is: v2.1.7 . as shown in Figure 2

在 composer.json 中查看 laravel/telescope,其版本为:v2.1.7
Figure 2

Clear the table starting with Telescope_ and re-execute the Job. In Laravel Telescope’s queries, find all the sql under the job queries All exist, but some SQL is not associated with the job. It is estimated that there are more than 1000 SQL in the job, but in Laravel Telescope’s queries, there are only 641 sql, and it is still not fully displayed. as shown in Figure 3

清空 telescope_ 开头的表,重新执行 Job,在 Laravel Telescope 的 Queries 中,发现 Job Queries 下的 所有 SQL 皆是存在的,只不过一些 SQL 并未与 Job 关联起来。预估 job 中存在的 SQL 是超过 1000 条的,但是在 Laravel Telescope 的 Queries 中,仅存在 641 条 SQL,仍然没有显示完全
Figure 3

4. Execute sql, select count(*) from `table`.`teleScope_entries` where `Type` =query, the result is 1375. Note that the SQL under the Job is fully documented, but not fully displayed. as shown in Figure 4

执行 SQL,SELECT count(*) FROM `table`.`telescope_entries` WHERE `type` = 'query',结果为 1375。说明 Job 下的 SQL 是完全记录了的,只不过未显示完全
Figure 4

5. Enter an unrelated SQL, click View job, and it will jump to the latest job in the jobs, not the job it should be associated with. However, it is possible to confirm that this SQL is a Job that should have been associated with the value of the location. as shown in Figure 5

进入一条未被关联的 SQL,点击 View Job,其跳转至 Jobs 中的最新一个 Job,并非其本应关联到的 Job。不过,可以基于 Location 的值确认此 SQL 是属于本应关联到的 Job 的
Figure 5

6. Decide to comment out some unimportant SQL execution in the job to reduce the number of SQL so that you can observe more important SQL.

PHP / Laravel / Yii2 Legacy Project Maintenance & Long-Term Technical Support

If your PHP / Laravel / Yii2 project is already in production but needs bug fixing, API troubleshooting, performance optimization, developer handover support, or long-term maintenance, feel free to contact me for remote technical support.

Ideal For:
✅ PHP legacy systems without active maintenance
✅ Laravel / Yii2 project bug fixes
✅ Admin panel feature iterations
✅ RESTful API troubleshooting
✅ MySQL / Redis / Nginx performance issues
✅ Long-term remote part-time maintenance

We can start with a small task:
✅ Production error troubleshooting
✅ API issue analysis
✅ Slow query and performance bottleneck diagnosis
✅ Initial code structure review
✅ Deployment environment and log inspection

If you would like to discuss your project, please contact me and mention: PHP Maintenance Consultation.

Contact Me:
Telegram: @shuijingwan
WeChat: 13980074657
Email: shuijingwanwq@gmail.com

评论

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.