ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
694a26e66307f: POST https://beta.jinchangxiao.com/vue/punch-strategy/get-calendar at 2025-12-23 01:21:42 pm by 223.104.39.212

Database Queries

总计6条数据
TimeDurationTypeQuery
  
13:21:42.4092.2 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
13:21:42.4120.5 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
13:21:42.4131.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
13:21:42.4171.8 msSELECTSELECT date(dt) as edate, CASE WHEN date_part('dow', date(dt)::timestamp) > 0 THEN date_part('dow', date(dt)::timestamp) ELSE 7 END as week, CASE WHEN lh.edate IS NOT NULL THEN true ELSE false END AS is_holiday, lh.title, lh.description, lh.is_exchange FROM generate_series(date_trunc('day', to_date('20251201', 'yyyymmdd')), date_trunc('day', to_date('20260111', 'yyyymmdd')), '1 day') tt(dt) LEFT JOIN "a57be577deb434"."tbl_legal_holidays" "lh" ON date(dt) = lh.edate GROUP BY "tt"."dt", "lh"."edate" ORDER BY "edate"

[+] Explain
13:21:42.4190.3 msSELECTSELECT "year" FROM "a57be577deb434"."tbl_legal_holidays" GROUP BY "year"

[+] Explain
13:21:42.4201.4 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/punch-strategy/get-calendar', '{"week":"31","legal_holiday":"1","thisMonth":"","year":"","holiday":"","web_access_token":"2WGAu5c-e3X8iWrTszdGFNSvMzxozBbD"}', '{"code":2000,"result":{"year":[{"key":2023,"name":"2023\u6cd5\u5b9a\u8282\u5047\u65e5"},{"key":2024,"name":"2024\u6cd5\u5b9a\u8282\u5047\u65e5"},{"key":2025,"name":"2025\u6cd5\u5b9a\u8282\u5047\u65e5"}],"calendar":[{"edate":"2025-12-01","week":1,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u5341\u4e8c","lunarMonth":"\u5341\u6708","need_work":true},{"edate":"2025-12-02","week":2,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u5341\u4e09","lunarMonth":"\u5341\u6708","need_work":true},{"edate":"2025-12-03","week":4,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u5341\u56db","lunarMonth":"\u5341\u6708","need_work":true},{"edate":"2025-12-04","week":8,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u5341\u4e94","lunarMonth":"\u5341\u6708","need_work":true},{"edate":"2025-12-05","week":16,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u5341\u516d","lunarMonth":"\u5341\u6708","need_work":true},{"edate":"2025-12-06","week":32,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u5341\u4e03","lunarMonth":"\u5341\u6708","need_work":false},{"edate":"2025-12-07","week":64,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u5341\u516b","lunarMonth":"\u5341\u6708","need_work":false},{"edate":"2025-12-08","week":1,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u5341\u4e5d","lunarMonth":"\u5341\u6708","need_work":true},{"edate":"2025-12-09","week":2,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u4e8c\u5341","lunarMonth":"\u5341\u6708","need_work":true},{"edate":"2025-12-10","week":4,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u5eff\u4e00","lunarMonth":"\u5341\u6708","need_work":true},{"edate":"2025-12-11","week":8,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u5eff\u4e8c","lunarMonth":"\u5341\u6708","need_work":true},{"edate":"2025-12-12","week":16,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u5eff\u4e09","lunarMonth":"\u5341\u6708","need_work":true},{"edate":"2025-12-13","week":32,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u5eff\u56db","lunarMonth":"\u5341\u6708","need_work":false},{"edate":"2025-12-14","week":64,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u5eff\u4e94","lunarMonth":"\u5341\u6708","need_work":false},{"edate":"2025-12-15","week":1,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u5eff\u516d","lunarMonth":"\u5341\u6708","need_work":true},{"edate":"2025-12-16","week":2,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u5eff\u4e03","lunarMonth":"\u5341\u6708","need_work":true},{"edate":"2025-12-17","week":4,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u5eff\u516b","lunarMonth":"\u5341\u6708","need_work":true},{"edate":"2025-12-18","week":8,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u5eff\u4e5d","lunarMonth":"\u5341\u6708","need_work":true},{"edate":"2025-12-19","week":16,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u4e09\u5341","lunarMonth":"\u5341\u6708","need_work":true},{"edate":"2025-12-20","week":32,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u521d\u4e00","lunarMonth":"\u51ac\u6708","need_work":false},{"edate":"2025-12-21","week":64,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u521d\u4e8c","lunarMonth":"\u51ac\u6708","need_work":false},{"edate":"2025-12-22","week":1,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u521d\u4e09","lunarMonth":"\u51ac\u6708","need_work":true},{"edate":"2025-12-23","week":2,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u521d\u56db","lunarMonth":"\u51ac\u6708","need_work":true},{"edate":"2025-12-24","week":4,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u521d\u4e94","lunarMonth":"\u51ac\u6708","need_work":true},{"edate":"2025-12-25","week":8,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u521d\u516d","lunarMonth":"\u51ac\u6708","need_work":true},{"edate":"2025-12-26","week":16,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u521d\u4e03","lunarMonth":"\u51ac\u6708","need_work":true},{"edate":"2025-12-27","week":32,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u521d\u516b","lunarMonth":"\u51ac\u6708","need_work":false},{"edate":"2025-12-28","week":64,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u521d\u4e5d","lunarMonth":"\u51ac\u6708","need_work":false},{"edate":"2025-12-29","week":1,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u521d\u5341 ","lunarMonth":"\u51ac\u6708","need_work":true},{"edate":"2025-12-30","week":2,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u5341\u4e00","lunarMonth":"\u51ac\u6708","need_work":true},{"edate":"2025-12-31","week":4,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u5341\u4e8c","lunarMonth":"\u51ac\u6708","need_work":true},{"edate":"2026-01-01","week":8,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u5341\u4e09","lunarMonth":"\u51ac\u6708","need_work":true},{"edate":"2026-01-02","week":16,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u5341\u56db","lunarMonth":"\u51ac\u6708","need_work":true},{"edate":"2026-01-03","week":32,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u5341\u4e94","lunarMonth":"\u51ac\u6708","need_work":false},{"edate":"2026-01-04","week":64,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u5341\u516d","lunarMonth":"\u51ac\u6708","need_work":false},{"edate":"2026-01-05","week":1,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u5341\u4e03","lunarMonth":"\u51ac\u6708","need_work":true},{"edate":"2026-01-06","week":2,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u5341\u516b","lunarMonth":"\u51ac\u6708","need_work":true},{"edate":"2026-01-07","week":4,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u5341\u4e5d","lunarMonth":"\u51ac\u6708","need_work":true},{"edate":"2026-01-08","week":8,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u4e8c\u5341","lunarMonth":"\u51ac\u6708","need_work":true},{"edate":"2026-01-09","week":16,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u5eff\u4e00","lunarMonth":"\u51ac\u6708","need_work":true},{"edate":"2026-01-10","week":32,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u5eff\u4e8c","lunarMonth":"\u51ac\u6708","need_work":false},{"edate":"2026-01-11","week":64,"is_holiday":false,"title":"","description":"","is_exchange":"","lunarDay":"\u5eff\u4e09","lunarMonth":"\u51ac\u6708","need_work":false}],"holiday":[{"key":"\u5143\u65e6","name":"\u5143\u65e6"},{"key":"\u6625\u8282","name":"\u6625\u8282"},{"key":"\u6e05\u660e\u8282","name":"\u6e05\u660e\u8282"},{"key":"\u52b3\u52a8\u8282","name":"\u52b3\u52a8\u8282"},{"key":"\u7aef\u5348\u8282","name":"\u7aef\u5348\u8282"},{"key":"\u4e2d\u79cb\u8282","name":"\u4e2d\u79cb\u8282"},{"key":"\u56fd\u5e86\u8282","name":"\u56fd\u5e86\u8282"}],"thisMonth":"2025-12"},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"223.104.39.212","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/605.1.15 (KHTML, like Gecko) Version\/15.6.1 Safari\/605.1.15"}', FALSE, '2025-12-23 13:21:42') RETURNING "id"

[+] Explain