这是100万主题的 atime 范围 count 在phpmyadmin中 执行 SELECT COUNT(*) FROM "hy_thread" WHERE "atime" > 1469289600
注意上面的 单位是 (微妙) (µs) 也就是说这种查询 是微乎其微的速度
- SQL查询 (20)
- 连接数据库 [耗时] 0.0002ms
- SELECT * FROM "hy_user" WHERE "id" = '1' LIMIT 1 [耗时] 0.0001ms
- SELECT * FROM "hy_forum" [耗时] 0.0001ms
- SELECT * FROM "hy_usergroup" [耗时] 0.0001ms
- SELECT COUNT(*) FROM "hy_post" [耗时] 0ms
- SELECT COUNT(*) FROM "hy_thread" [耗时] 0ms
- SELECT COUNT(*) FROM "hy_user" [耗时] 0ms
- SELECT COUNT(*) FROM "hy_thread" WHERE "atime" > 1469289600 [耗时] 0.0001ms
- SELECT COUNT(*) FROM "hy_post" WHERE "atime" > 1469289600 [耗时] 0ms
- SELECT COUNT(*) FROM "hy_user" WHERE "atime" > 1469289600 [耗时] 0ms
- SELECT COUNT(*) FROM "hy_ol" [耗时] 0ms
- DELETE FROM "hy_ol" WHERE "atime" < 1469341428 [耗时] 0.0002ms
- SELECT COUNT(*) FROM "hy_ol" [耗时] 0ms
- DELETE FROM "hy_ol" WHERE "atime" < 1469341428 [耗时] 0.0001ms
- SELECT COUNT(*) FROM "hy_ol" [耗时] 0ms
- SELECT * FROM "hy_thread" WHERE "img_count" != 0 ORDER BY "id" DESC LIMIT 0,5 [耗时] 0.0001ms
- SELECT * FROM "hy_thread" WHERE "atime" > 1468736828 ORDER BY "views" DESC LIMIT 0,10 [耗时] 0.0004ms
- SELECT "user" FROM "hy_user" WHERE "id" = '1' LIMIT 1 [耗时] 0ms
- SELECT "user" FROM "hy_user" WHERE "id" = '2' LIMIT 1 [耗时] 0ms
- SELECT * FROM "hy_thread" WHERE "atime" > 1468736828 ORDER BY "posts" DESC LIMIT 0,10 [耗时] 0.0002ms
- SELECT * FROM "hy_thread" WHERE "atime" > 1468736828 ORDER BY "goods" DESC LIMIT 0,10 [耗时] 0.0003ms
|