Performance Profiling

Total processing time: 19 ms; Peak memory: 4.682 MB. Show Profiling Timeline

总计6条数据

Time	Duration	Category	Info

17:21:50.365	2.8 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "access_token"='gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om'
17:21:50.363	2.0 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:21:50.373	1.8 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT r., CASE WHEN rvr.id IS NULL THEN false ELSE true END as can_vote, CASE WHEN rvr.completed IS NULL THEN false ELSE true END as completed FROM "a57be577deb434"."tbl_ratings" "r" LEFT JOIN "a57be577deb434"."tbl_rating_voters" "rvr" ON r.id = rvr.rating_id AND rvr.user_id =1000 LEFT JOIN "a57be577deb434"."tbl_rating_candidates" "rc" ON r.id = rc.rating_id AND rc.user_id =1000 ORDER BY "open_from" DESC, "created_at" DESC) "c"
17:21:50.369	1.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
17:21:50.377	1.3 ms	yii\db\Command::query	INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, 0, 266, 'v2/rating/list', '{"access_token":"gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om","device_type":"0","version_code":"266","page":"21","token":"9302aae0ef42335b69c4dfc6c141b2d4","posttime":"1757496110"}', '{"code":200,"data":{"list":[{"id":55,"title":"2019\u5e741\u6708\u4efd \u6280\u672f\u90e8\u6700\u4f18\u79c0\u5458\u5de5\u8bc4\u9009","open_from":"2019-02-01 00:00:00","close_at":"2019-02-01 10:25:58","created_by":1001,"created_at":"2019-01-23 13:37:40","updated_at":"2019-02-01 10:26:08","strategy_id":12,"description":null,"choice":null,"rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":false},{"id":54,"title":"2019\u5e741\u6708\u4efd \u7efc\u5408\u7ba1\u7406\u90e8\u6700\u4f18\u79c0\u5458\u5de5\u8bc4\u9009","open_from":"2019-02-01 00:00:00","close_at":"2019-02-01 10:25:46","created_by":1001,"created_at":"2019-01-23 13:36:37","updated_at":"2019-02-01 10:25:56","strategy_id":11,"description":null,"choice":null,"rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":false},{"id":53,"title":"\u9500\u552e\u90e8\u96c6\u4f53\u5b66\u4e60\u65f6\u95f4","open_from":"2019-01-02 21:00:00","close_at":"2019-01-03 06:28:17","created_by":1001,"created_at":"2019-01-02 21:29:22","updated_at":"2019-01-03 06:28:27","strategy_id":null,"description":null,"choice":0,"rating_type":2,"is_notice":true,"is_public":false,"can_vote":false,"completed":false},{"id":52,"title":"12\u6708\u4efd\u9500\u552e\u90e8\u5458\u5de5\u4f18\u79c0\u5458\u5de5\u8bc4\u9009\u6295\u7968","open_from":"2019-01-02 09:00:00","close_at":"2019-01-02 15:40:17","created_by":1001,"created_at":"2019-01-02 12:18:32","updated_at":"2019-01-02 15:40:27","strategy_id":null,"description":null,"choice":0,"rating_type":2,"is_notice":true,"is_public":false,"can_vote":false,"completed":false},{"id":51,"title":"12\u6708\u4efd\u6280\u672f\u90e8\u6700\u4f18\u79c0\u5458\u5de5\u8bc4\u9009","open_from":"2019-01-01 00:00:00","close_at":"2019-01-02 12:18:43","created_by":1001,"created_at":"2018-12-24 17:02:48","updated_at":"2019-01-02 12:18:53","strategy_id":12,"description":null,"choice":null,"rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":false},{"id":50,"title":"12\u6708\u4efd\u9500\u552e\u90e8\u6700\u4f18\u79c0\u5458\u5de5\u8bc4\u9009","open_from":"2019-01-01 00:00:00","close_at":"2019-01-02 11:40:56","created_by":1001,"created_at":"2018-12-24 17:02:07","updated_at":"2019-01-02 11:41:06","strategy_id":10,"description":null,"choice":null,"rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":false},{"id":49,"title":"12\u6708\u4efd\u7efc\u5408\u7ba1\u7406\u90e8\u6700\u4f18\u79c0\u5458\u5de5\u8bc4\u9009","open_from":"2019-01-01 00:00:00","close_at":"2019-01-02 12:18:52","created_by":1001,"created_at":"2018-12-24 17:01:12","updated_at":"2019-01-02 12:19:02","strategy_id":11,"description":null,"choice":null,"rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":false},{"id":48,"title":"11\u6708\u4efd\u6280\u672f\u90e8\u6700\u4f18\u79c0\u5458\u5de5\u8bc4\u9009","open_from":"2018-12-01 00:00:00","close_at":"2018-12-03 13:33:00","created_by":1001,"created_at":"2018-11-26 18:11:24","updated_at":"2018-12-03 13:33:10","strategy_id":12,"description":null,"choice":null,"rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":false},{"id":47,"title":"11\u6708\u4efd\u7efc\u5408\u7ba1\u7406\u90e8\u6700\u4f18\u79c0\u5458\u5de5\u8bc4\u9009","open_from":"2018-12-01 00:00:00","close_at":"2018-12-03 13:32:53","created_by":1001,"created_at":"2018-11-26 18:10:34","updated_at":"2018-12-03 13:33:03","strategy_id":11,"description":null,"choice":null,"rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":false},{"id":46,"title":"11\u6708\u4efd\u9500\u552e\u90e8\u6700\u4f18\u79c0\u5458\u5de5\u8bc4\u9009","open_from":"2018-12-01 00:00:00","close_at":"2018-12-03 13:25:45","created_by":1001,"created_at":"2018-11-26 18:09:13","updated_at":"2018-12-03 13:25:55","strategy_id":10,"description":null,"choice":null,"rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":false}],"pagenation":{"totalcount":234,"thispage":21,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-09-10 17:21:50') RETURNING "id"
17:21:50.375	1.1 ms	yii\db\Command::query	SELECT r.*, CASE WHEN rvr.id IS NULL THEN false ELSE true END as can_vote, CASE WHEN rvr.completed IS NULL THEN false ELSE true END as completed FROM "a57be577deb434"."tbl_ratings" "r" LEFT JOIN "a57be577deb434"."tbl_rating_voters" "rvr" ON r.id = rvr.rating_id AND rvr.user_id =1000 LEFT JOIN "a57be577deb434"."tbl_rating_candidates" "rc" ON r.id = rc.rating_id AND rc.user_id =1000 ORDER BY "open_from" DESC, "created_at" DESC LIMIT 10 OFFSET 200