Performance Profiling

Total processing time: 44 ms; Peak memory: 3.235 MB. Show Profiling Timeline

总计7条数据

Time	Duration	Category	Info

20:43:46.129	6.4 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
20:43:46.136	4.5 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "access_token"='lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC'
20:43:46.143	2.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
20:43:46.159	2.6 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", "duration") VALUES (200, 'a57be577deb434', 1001, 7, 178, 'v2/punch-leave/get-spent', '{"PunchLeaves":{"leave_start":"2026-07-30","leave_start_type":"1","leave_end":"2026-07-30","leave_end_type":"2","leave_type":"1","leave_start_time":"","leave_end_time":""},"posttime":"1782132226","access_token":"lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC","device_type":"7","version_code":"178","token":"654bbe7bb07378f2b2e56b14ea1b43fc"}', '{"code":200,"data":{"spent":1,"hour_display":null},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"120.33.105.174","ua":"jinchangxiao\/1.0.42 (HUAWEI Mate 60 Pro ALN-AL00; HarmonyOS 6.1.0)"}', FALSE, '2026-06-22 20:43:46', 35064832) RETURNING "id"
20:43:46.153	1.9 ms	yii\db\Command::query	SELECT "ps".* FROM "a57be577deb434"."tbl_punch_strategies" "ps" LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.punch_strategy_id = ps.id WHERE "psrr"."user_id"=1001 GROUP BY "ps"."id"
20:43:46.156	0.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-07-30'
20:43:46.155	0.8 ms	yii\db\Command::query	SELECT "ps".* FROM "a57be577deb434"."tbl_punch_strategies" "ps" LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.punch_strategy_id = ps.id WHERE "psrr"."user_id"=1001 GROUP BY "ps"."id"