没有不值得去解决的问题,也没有不值得去学习的技术!

Investigating Why Some SQL Queries Are Not Logged in Laravel Telescope Job Queries

In Laravel Telescope's Job Queries, some SQL statements are not recorded. It shows Queries (22), but there are actually far more than 22

1. In Laravel Telescope’s Job Queries, some SQL statements are not recorded. It shows Queries (22), but there are actually far more than 22. See Figure 1.

In Laravel Telescope's Job Queries, some SQL statements are not recorded. It shows Queries (22), but there are actually far more than 22
Figure 1

2. Checking laravel/telescope in composer.json shows the version is v2.1.7. See Figure 2.

Checking laravel/telescope in composer.json shows the version is v2.1.7
Figure 2

3. After clearing the tables starting with telescope_ and re-running the Job, I found in Laravel Telescope’s Queries that all the SQL statements under Job Queries do exist, but some of them are not linked to the Job. I estimate there are over 1000 SQL statements in the Job, but Laravel Telescope’s Queries only shows 641, so it is still not displaying them all. See Figure 3.

After clearing the tables starting with telescope_ and re-running the Job, I found in Laravel Telescope's Queries that all the SQL statements under Job Queries do exist, but some of them are not linked to the Job. I estimate there are over 1000 SQL statements in the Job, but Laravel Telescope's Queries only shows 641, so it is still not displaying them all
Figure 3

4. Executing the SQL statement, SELECT count(*) FROM `table`.`telescope_entries` WHERE `type` = ‘query’, returns a result of 1375. This indicates that the SQL statements under the Job were fully recorded, just not displayed completely. See Figure 4.

Executing the SQL statement, SELECT count(*) FROM `table`.`telescope_entries` WHERE `type` = 'query', returns a result of 1375. This indicates that the SQL statements under the Job were fully recorded, just not displayed completely
Figure 4

5. Opening an unlinked SQL statement and clicking View Job redirects to the newest Job in Jobs, rather than the Job it should actually be linked to. However, I can confirm based on the Location value that this SQL statement belongs to the Job it should be linked to. See Figure 5.

Opening an unlinked SQL statement and clicking View Job redirects to the newest Job in Jobs, rather than the Job it should actually be linked to. However, I can confirm based on the Location value that this SQL statement belongs to the Job it should be linked to
Figure 5

6. I decided to comment out some unimportant SQL executions in the Job to reduce the number of SQL statements, making it easier to observe the more important ones.

关于作者 · 持续学习与技术实践

我是一名拥有 15 年以上开发经验的技术从业者,自 2013 年起持续运营个人技术博客,记录工作与个人项目中遇到的真实问题,以及解决问题过程中的探索、实践和思考。

除了技术写作,我也在持续开发和维护自己的独立项目,探索新技术和新工具在实际场景中的应用。我始终相信,没有不值得去解决的问题,也没有不值得去学习的技术。

如果这篇文章对你有所帮助,欢迎浏览博客中的其他文章,也欢迎交流技术经验与想法。

关于我  ·  GitHub  ·  邮件联系