Performance Profiling

Total processing time: 90 ms; Peak memory: 4.745 MB. Show Profiling Timeline

总计6条数据

Time	Duration	Category	Info

17:19:29.225	28.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:19:29.181	17.1 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:19:29.257	8.0 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":"2","token":"75ba85cd46ada4ae46e6184e696f91f4","posttime":"1757495969"}', '{"code":200,"data":{"list":[{"id":333,"title":"2025\u5e745\u6708-\u6280\u672f\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2025-05-30 08:00:00","close_at":"2025-05-30 16:07:42","created_by":1001,"created_at":"2025-05-21 16:31:53","updated_at":"2025-05-30 16:07:52","strategy_id":51,"description":null,"choice":null,"rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":false},{"id":332,"title":"2025\u5e745\u6708-\u7efc\u5408\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2025-05-30 08:00:00","close_at":"2025-05-30 16:07:45","created_by":1001,"created_at":"2025-05-21 16:31:06","updated_at":"2025-05-30 16:07:55","strategy_id":50,"description":null,"choice":null,"rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":false},{"id":331,"title":"2025\u5e744\u6708-\u9500\u552e\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2025-04-30 08:00:00","close_at":"2025-04-30 15:28:30","created_by":1001,"created_at":"2025-04-17 09:30:20","updated_at":"2025-04-30 15:28:40","strategy_id":52,"description":null,"choice":null,"rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":false},{"id":330,"title":"2025\u5e744\u6708-\u6280\u672f\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2025-04-30 08:00:00","close_at":"2025-05-06 08:38:29","created_by":1001,"created_at":"2025-04-17 09:29:29","updated_at":"2025-05-06 08:38:39","strategy_id":51,"description":null,"choice":null,"rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":false},{"id":329,"title":"2025\u5e744\u6708-\u7efc\u5408\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2025-04-30 08:00:00","close_at":"2025-05-06 08:38:35","created_by":1001,"created_at":"2025-04-17 09:28:44","updated_at":"2025-05-06 08:38:45","strategy_id":50,"description":null,"choice":null,"rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":false},{"id":328,"title":"2025\u5e743\u6708-\u9500\u552e\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2025-03-31 09:00:00","close_at":"2025-04-02 16:21:17","created_by":1001,"created_at":"2025-03-21 11:01:27","updated_at":"2025-04-02 16:21:27","strategy_id":52,"description":null,"choice":null,"rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":false},{"id":327,"title":"2025\u5e743\u6708-\u6280\u672f\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2025-03-31 09:00:00","close_at":"2025-04-02 16:21:19","created_by":1001,"created_at":"2025-03-21 11:00:39","updated_at":"2025-04-02 16:21:29","strategy_id":51,"description":null,"choice":null,"rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":false},{"id":326,"title":"2025\u5e743\u6708-\u7efc\u5408\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2025-03-31 09:00:00","close_at":"2025-04-02 16:21:22","created_by":1001,"created_at":"2025-03-21 10:59:50","updated_at":"2025-04-02 16:21:32","strategy_id":50,"description":null,"choice":null,"rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":false},{"id":325,"title":"2025\u5e742\u6708-\u9500\u552e\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2025-02-28 08:00:00","close_at":"2025-02-28 16:41:26","created_by":1001,"created_at":"2025-02-24 11:48:42","updated_at":"2025-02-28 16:41:36","strategy_id":52,"description":null,"choice":null,"rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":false},{"id":324,"title":"2025\u5e742\u6708-\u6280\u672f\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2025-02-28 08:00:00","close_at":"2025-03-03 08:55:09","created_by":1001,"created_at":"2025-02-24 11:47:46","updated_at":"2025-03-03 08:55:19","strategy_id":51,"description":null,"choice":null,"rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":false}],"pagenation":{"totalcount":234,"thispage":2,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-09-10 17:19:29') RETURNING "id"
17:19:29.198	7.7 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "access_token"='gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om'
17:19:29.207	2.1 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
17:19:29.255	1.2 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 10