@admin
主题页面
SQL查询 (24)
连接数据库 [耗时] 0.0113ms
SELECT * FROM "hy_user" WHERE "id" = '1' LIMIT 1 [耗时] 0.0005ms
SELECT * FROM "hy_forum" [耗时] 0.0006ms
SELECT * FROM "hy_usergroup" [耗时] 0.0006ms
SELECT COUNT(*) FROM "hy_post" [耗时] 0.0004ms
SELECT COUNT(*) FROM "hy_thread" [耗时] 0.0002ms
SELECT COUNT(*) FROM "hy_user" [耗时] 0.0002ms
SELECT COUNT(*) FROM "hy_thread" WHERE "atime" > 1469203200 [耗时] 1.7529ms
SELECT COUNT(*) FROM "hy_post" WHERE "atime" > 1469203200 [耗时] 14.1534ms
SELECT COUNT(*) FROM "hy_user" WHERE "atime" > 1469203200 [耗时] 0.0178ms
SELECT COUNT(*) FROM "hy_ol" [耗时] 0.0009ms
DELETE FROM "hy_ol" WHERE "atime" < 1469278469 [耗时] 0.0278ms
SELECT COUNT(*) FROM "hy_ol" [耗时] 0.0005ms
SELECT EXISTS(SELECT 1 FROM "hy_ol" WHERE "uid" = '1') [耗时] 0.0802ms
UPDATE "hy_ol" SET "atime" = '1469278669' WHERE "uid" = '1' [耗时] 0.0004ms
SELECT * FROM "hy_thread" ORDER BY "btime" DESC LIMIT 10 [耗时] 1.9981ms
SELECT * FROM "hy_thread" WHERE "img" != '' ORDER BY "id" DESC LIMIT 10 [耗时] 24.3555ms
SELECT * FROM "hy_thread" ORDER BY "posts" DESC LIMIT 10 [耗时] 3.3143ms
SELECT * FROM "hy_thread" WHERE "id" = 616400 LIMIT 1 [耗时] 1.1442ms
SELECT "user" FROM "hy_user" WHERE "id" = '1' LIMIT 1 [耗时] 0.0127ms
SELECT * FROM "hy_post" WHERE "tid" = 616400 AND "isthread" = 1 LIMIT 1 [耗时] 0.0174ms
SELECT * FROM "hy_post" WHERE "tid" = 616400 AND "isthread" = 0 ORDER BY "id" LIMIT 0,10 [耗时] 0.0007ms
SELECT * FROM "hy_fileinfo" WHERE "tid" = 616400 [耗时] 0.0005ms
SELECT EXISTS(SELECT 1 FROM "hy_post" WHERE "uid" = '1' AND "tid" = 616400) [耗时] 0.0007ms
UPDATE "hy_thread" SET "views" = "views" + 1 WHERE "id" = 616400 [耗时] 23.2158ms
后台
(话说进后台也会跑hy_thread,hy_post表会不会有点浪费资源)
SQL查询 (18)
连接数据库 [耗时] 0.0015ms
SELECT * FROM "hy_user" WHERE "id" = '1' LIMIT 1 [耗时] 0.0007ms
SELECT * FROM "hy_forum" [耗时] 0.0646ms
SELECT * FROM "hy_usergroup" [耗时] 0.0013ms
SELECT COUNT(*) FROM "hy_post" [耗时] 0.0006ms
SELECT COUNT(*) FROM "hy_thread" [耗时] 0.0002ms
SELECT COUNT(*) FROM "hy_user" [耗时] 0.0003ms
SELECT COUNT(*) FROM "hy_thread" WHERE "atime" > 1469203200 [耗时] 1.564ms
SELECT COUNT(*) FROM "hy_post" WHERE "atime" > 1469203200 [耗时] 15.597ms
SELECT COUNT(*) FROM "hy_user" WHERE "atime" > 1469203200 [耗时] 0.0116ms
SELECT COUNT(*) FROM "hy_ol" [耗时] 0.0003ms
DELETE FROM "hy_ol" WHERE "atime" < 1469278447 [耗时] 0.001ms
SELECT COUNT(*) FROM "hy_ol" [耗时] 0.0003ms
SELECT EXISTS(SELECT 1 FROM "hy_ol" WHERE "uid" = '1') [耗时] 0.0004ms
INSERT INTO "hy_ol" ("uid", "username", "ip", "group", "atime") VALUES ('1', 'admin', '1878879629', '1', '1469278647') [耗时] 0.0009ms
SELECT COUNT(*) FROM "hy_ol" [耗时] 0.0251ms
SELECT * FROM "hy_thread" ORDER BY "btime" DESC LIMIT 10 [耗时] 2.0389ms
SELECT * FROM "hy_thread" WHERE "img" != '' ORDER BY "id" DESC LIMIT 10 [耗时] 16.008ms
SELECT * FROM "hy_thread" ORDER BY "posts" DESC LIMIT 10 [耗时] 1.9007ms