By s80022 at 2016-07-24
1人收藏 • 1931人看过

• 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 
林先生可以做类似的功能吗?