6a1e34df580a1: POST https://beta.jinchangxiao.com/vue/punch-leave/get-spent at 2026-06-02 09:41:51 am by 221.216.117.119
Performance Profiling
Total processing time: 24 ms; Peak memory: 3.617 MB. Show Profiling Timeline
总计67条数据
| Time | Duration | Category | Info |
|---|---|---|---|
| 09:41:51.382 | 0.9 ms | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/punch-leave/get-spent', '{"PunchLeaves":{"leave_start":"2026-06-01","leave_end":"2026-07-31","leave_type":"1","leave_start_type":"1","leave_end_type":"2"},"web_access_token":"wTKilqflq6B-eOSFd1z6EzcpqcAU3V6m"}', '{"code":2000,"result":{"spent":61,"hour_display":null},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/148.0.0.0 Safari\/537.36"}', FALSE, '2026-06-02 09:41:51', 20861696) RETURNING "id" |
| 09:41:51.362 | 0.6 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 09:41:51.366 | 0.5 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" |
| 09:41:51.367 | 0.4 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" |
| 09:41:51.367 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-06-01' |
| 09:41:51.363 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 09:41:51.372 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-06-21' |
| 09:41:51.376 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-07-09' |
| 09:41:51.375 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-07-04' |
| 09:41:51.380 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-07-27' |
| 09:41:51.377 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-07-14' |
| 09:41:51.380 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-07-26' |
| 09:41:51.368 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-06-02' |
| 09:41:51.370 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-06-11' |
| 09:41:51.371 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-06-17' |
| 09:41:51.371 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-06-16' |
| 09:41:51.372 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-06-20' |
| 09:41:51.378 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-07-19' |
| 09:41:51.379 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-07-22' |
| 09:41:51.380 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-07-28' |
| 09:41:51.369 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-06-07' |
| 09:41:51.376 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-07-10' |
| 09:41:51.368 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-06-03' |
| 09:41:51.377 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-07-13' |
| 09:41:51.372 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-06-22' |
| 09:41:51.379 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-07-24' |
| 09:41:51.373 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-06-27' |
| 09:41:51.371 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-06-18' |
| 09:41:51.374 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-06-29' |
| 09:41:51.375 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-07-06' |
| 09:41:51.369 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-06-09' |
| 09:41:51.374 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-07-01' |
| 09:41:51.370 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-06-12' |
| 09:41:51.378 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-07-17' |
| 09:41:51.370 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-06-13' |
| 09:41:51.368 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-06-05' |
| 09:41:51.372 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-06-19' |
| 09:41:51.362 | 0.1 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 09:41:51.379 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-07-23' |
| 09:41:51.368 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-06-04' |
| 09:41:51.373 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-06-25' |
| 09:41:51.376 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-07-07' |
| 09:41:51.369 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-06-06' |
| 09:41:51.370 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-06-10' |
| 09:41:51.380 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-07-25' |
| 09:41:51.381 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-07-31' |
| 09:41:51.370 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-06-14' |
| 09:41:51.373 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-06-23' |
| 09:41:51.375 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-07-05' |
| 09:41:51.377 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-07-11' |
| 09:41:51.377 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-07-15' |
| 09:41:51.369 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-06-08' |
| 09:41:51.373 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-06-26' |
| 09:41:51.374 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-06-30' |
| 09:41:51.374 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-07-02' |
| 09:41:51.378 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-07-20' |
| 09:41:51.374 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-06-28' |
| 09:41:51.375 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-07-03' |
| 09:41:51.381 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-07-29' |
| 09:41:51.371 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-06-15' |
| 09:41:51.373 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-06-24' |
| 09:41:51.376 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-07-08' |
| 09:41:51.378 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-07-16' |
| 09:41:51.378 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-07-18' |
| 09:41:51.379 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-07-21' |
| 09:41:51.381 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-07-30' |
| 09:41:51.377 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='2026-07-12' |