林先生可以考虑一下做DEBUG模式吗??
SQL查询 (14)
连接数据库 [耗时] 0.0005ms
SELECT * FROM "hy_user" WHERE "id" = '1' LIMIT 1 [耗时] 0.0005ms
SELECT * FROM "hy_forum" [耗时] 0.0009ms
SELECT * FROM "hy_usergroup" [耗时] 0.0006ms
SELECT COUNT(*) FROM "hy_post" [耗时] 0.0003ms
SELECT COUNT(*) FROM "hy_thread" [耗时] 0.0002ms
SELECT COUNT(*) FROM "hy_user" [耗时] 0.0003ms
SELECT COUNT(*) FROM "hy_thread" WHERE "atime" > 1469289600 [耗时] 0.4284ms
SELECT COUNT(*) FROM "hy_post" WHERE "atime" > 1469289600 [耗时] 0.4231ms
SELECT COUNT(*) FROM "hy_user" WHERE "atime" > 1469289600 [耗时] 0.0005ms
SELECT COUNT(*) FROM "hy_ol" [耗时] 0.0002ms
DELETE FROM "hy_ol" WHERE "atime" < 1469328890 [耗时] 0.0004ms
SELECT COUNT(*) FROM "hy_ol" [耗时] 0.0002ms
DELETE FROM "hy_ol" WHERE "atime" < 1469328890 [耗时] 0.0004ms
SELECT COUNT(*) FROM "hy_ol" [耗时] 0.0002ms
hyphp的DEBUG模式看起来很好用,开启后暂时关闭缓存。
然后马上就能看出哪一个SQL语句耗时太重。
@lincanbin
林先生可以做类似的功能吗?
登录后方可回帖
开慢查询日志或者SQL的profile,都是一样的。