回复详情

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

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