6942eca925e23: GET https://beta.jinchangxiao.com/andy/save-punch at 2025-12-18 01:47:21 am by 74.7.241.39
Database Queries
总计7条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 01:47:21.159 | 2.4 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=5083 |
| 01:47:21.162 | 1.0 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_punch" WHERE ("user_id" IS NULL) AND ("day_at"='1970-01-01') |
| 01:47:21.164 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_legal_holidays" "lh" WHERE "edate"='1970-01-01' |
| 01:47:21.166 | 1.2 ms | SELECT | 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" IS NULL GROUP BY "ps"."id" |
| 01:47:21.168 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_punch_strategy_schedules" "p" WHERE ("edate"='1970-01-01') AND ("punch_strategy_id"=1) |
| 01:47:21.169 | 0.3 ms | SELECT | SELECT "psr".* FROM "a57be577deb434"."tbl_punch_strategy_points" "psr" WHERE "psr"."punch_strategy_id"=1 |
| 01:47:21.170 | 0.7 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_punch" ("user_id", "day_at", "strategy_time_on", "strategy_time_off", "strategy_distance", "strategy_punch_type", "strategy_time_on_overdue", "strategy_time_off_overdue", "strategy_work_hour", "need_work", "strategy_lng", "strategy_lat") VALUES (NULL, '1970-01-01', '09:00', '18:00', 100, 1, 60, 60, NULL, TRUE, '116.298454', '39.829527') RETURNING "day_at", "user_id" |