一、

PHP慢查询问题是指施行时间较长的数据库查询，这可能会影响网站性能和用户体验。通过分析PHP日志，可以识别并解决这些慢查询问题，从而提高应用程序的性能。

二、 开启慢查询日志

1. MySQL配置

先说说需要确保MySQL的慢查询日志已开启。编辑MySQL配置文件， 并设置以下选项：

• slow_query_log = 1
• long_query_time = 2
• slow_query_log_file = /path/to/your/slow-query.log

其中，long_query_time定义了慢查询的时间阈值，默认为2秒。

2. PHP-FPM配置

对于PHP-FPM， 需要编辑php-fpm.conf文件，并设置以下选项：

• 找到request_slowlog_timeout并设置一个非零值，比方说5秒。
• 找到slowlog并确保其值指向正确的日志文件路径。

比方说：

request_slowlog_timeout = 5
slowlog = /path/to/your/php-fpm-slow.log

三、 分析慢查询日志

开启慢查询日志后可以通过以下步骤分析日志文件：

1. 使用文本编辑器打开慢查询日志文件。
2. 查找施行时间较长的查询。
3. 使用EXPLAIN语句分析查询施行计划，以了解查询的性能问题。

1065 0.0151 0 SELECT * FROM users WHERE id = 1
    # User@Host: user @ localhost  Id: 3
    # Querytime: 0.0151 Locktime: 0.0000 Rowssent: 1 Rowsexamined: 1
    # Rowsmatching: 1 Rowsaffected: 1 Rowsread: 1 Rowswritten: 0
    # Tablesindatabase: users
    # Tablesselected: users
    # Tablesincache: users
    # Rowsincache: 1
    # Rowsinindexcache: 0
    # Rowsinextracache: 0
    # Rowsintemptables: 0
    # Rowsintempondisk: 0
    # Rowsinjoincache: 0
    # Rowsinquerycache: 0
    # Rowsinselectcache: 0
    # Rowsinsortcache: 0
    # Rowsinsortcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroupcache: 0
    # Rowsingroup_cache: 

---