ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a3930594aaaa: POST https://beta.jinchangxiao.com/v2/punch-leave/cancel-verify at 2026-06-22 08:53:45 pm by 120.33.105.174

Performance Profiling

Total processing time: 202 ms; Peak memory: 6.238 MB. Show Profiling Timeline

总计202条数据
TimeDurationCategoryInfo
  
20:53:45.34626.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_unread_comments" SET "is_read"=TRUE WHERE ("object_type"=40) AND ("object_id"=148) AND ("remind_user_id"=1000) AND ("is_read"=FALSE)
20:53:45.4622.7 msyii\db\Command::querySELECT *, overtime_end - overtime_start AS hours_spent FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("created_by"=5064) AND (("overtime_start" >= '2025-12-29 00:00:00') AND ("overtime_start" <= '2025-12-29 23:59:59')) AND ("status" IN (2, 5)) ORDER BY "verify_at" DESC
20:53:45.3221.9 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_punch_leave_cancel_verify_rels" SET "status"=1, "description"='通过', "verify_at"='now()' WHERE "id"=28
20:53:45.3241.5 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\PunchLeaveCancelVerifyRels', 28, 'a:3:{s:6:"status";i:1;s:11:"description";s:6:"通过";s:9:"verify_at";s:5:"now()";}', '', 1000, '120.33.105.174')
20:53:45.3371.5 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_unread_comments" ("object_id", "object_type", "comment_id", "remind_user_id") VALUES (148, '40', 220947, 5252), (148, '40', 220947, 5388), (148, '40', 220947, 5064)
20:53:45.4701.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_punch" SET "in_is_absent"=TRUE, "out_is_absent"=TRUE, "in_is_leave"=FALSE, "out_is_leave"=FALSE, "work_value"=0, "away_value"=0, "leave_value"=0, "travel_value"=0, "absent_value"=1, "in_leave_type"=NULL, "out_leave_type"=NULL WHERE ("day_at"='2025-12-29') AND ("user_id"=5064)
20:53:45.3441.4 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (16, 'status', 148, 40, 1000, 'now()', '["\u66f9\u6c38\u751f"]', '[]', '{"d1":"\u66f9\u6c38\u751f","d2":"\u540c\u610f\u4e86\u64a4\u9500","d3":"\u8bf7\u5047\u7533\u8bf7","d4":""}')
20:53:45.4511.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_punch" SET "work_value"=0, "away_value"=0, "leave_value"=0, "travel_value"=0, "absent_value"=0 WHERE ("day_at"='2025-12-28') AND ("user_id"=5064)
20:53:45.4341.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_punch" SET "work_value"=0, "away_value"=0, "leave_value"=0, "travel_value"=0, "absent_value"=0 WHERE ("day_at"='2025-12-27') AND ("user_id"=5064)
20:53:45.4171.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_punch" SET "in_is_absent"=TRUE, "out_is_absent"=TRUE, "in_is_leave"=FALSE, "out_is_leave"=FALSE, "work_value"=0, "away_value"=0, "leave_value"=0, "travel_value"=0, "absent_value"=1, "in_leave_type"=NULL, "out_leave_type"=NULL WHERE ("day_at"='2025-12-26') AND ("user_id"=5064)
20:53:45.3891.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_punch" SET "in_is_absent"=TRUE, "out_is_absent"=TRUE, "in_is_leave"=FALSE, "out_is_leave"=FALSE, "work_value"=0, "away_value"=0, "leave_value"=0, "travel_value"=0, "absent_value"=1, "in_leave_type"=NULL, "out_leave_type"=NULL WHERE ("day_at"='2025-12-24') AND ("user_id"=5064)
20:53:45.3731.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch" WHERE ("day_at"='2025-12-24') AND ("user_id"=5064)
20:53:45.4041.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Punch', 61738, 'a:2:{s:13:"in_leave_type";i:6;s:14:"out_leave_type";i:6;}', '', 1000, '120.33.105.174')
20:53:45.4031.2 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_punch" SET "in_is_absent"=TRUE, "out_is_absent"=TRUE, "in_is_leave"=FALSE, "out_is_leave"=FALSE, "work_value"=0, "away_value"=0, "leave_value"=0, "travel_value"=0, "absent_value"=1, "in_leave_type"=NULL, "out_leave_type"=NULL WHERE ("day_at"='2025-12-25') AND ("user_id"=5064)
20:53:45.4841.2 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_punch" SET "in_is_absent"=TRUE, "out_is_absent"=TRUE, "in_is_leave"=FALSE, "out_is_leave"=FALSE, "work_value"=0, "away_value"=0, "leave_value"=0, "travel_value"=0, "absent_value"=1, "in_leave_type"=NULL, "out_leave_type"=NULL WHERE ("day_at"='2025-12-30') AND ("user_id"=5064)
20:53:45.5021.2 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1000, 0, 273, 'v2/punch-leave/cancel-verify', '{"access_token":"R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC","description":"\u901a\u8fc7","device_type":"0","version_code":"273","id":"148","token":"1264a295a6377189fb25a77f07e83961","posttime":"1782132825"}', '{"code":200,"data":"","status":1,"msg":[{"name":"success","success":"\u8bf7\u5047\u7533\u8bf7\u5ba1\u6279\u901a\u8fc7","error":""}],"ip":"120.33.105.174","ua":"jinchangxiao\/2.3.173 (XiaomiMi 10; Android 13)"}', FALSE, '2026-06-22 20:53:45', 194594816) RETURNING "id"
20:53:45.4981.2 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_punch" SET "in_is_absent"=TRUE, "out_is_absent"=TRUE, "in_is_leave"=FALSE, "out_is_leave"=FALSE, "work_value"=0, "away_value"=0, "leave_value"=0, "travel_value"=0, "absent_value"=1, "in_leave_type"=NULL, "out_leave_type"=NULL WHERE ("day_at"='2025-12-31') AND ("user_id"=5064)
20:53:45.3351.2 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "is_system", "description2") VALUES (1000, '40', 148, '曹永生 通过了这个请假申请', TRUE, '年假') RETURNING "id"
20:53:45.4181.1 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Punch', 61739, 'a:2:{s:13:"in_leave_type";i:6;s:14:"out_leave_type";i:6;}', '', 1000, '120.33.105.174')
20:53:45.4301.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_leaves" WHERE ("created_by"=5064) AND ((("leave_start" < '2025-12-27') AND ("leave_end" > '2025-12-27')) OR (("leave_start"='2025-12-27') AND ("leave_start_type"=1)) OR ("leave_end"='2025-12-27') OR (("leave_start" <= '2025-12-27') AND ("leave_end" >= '2025-12-27') AND ("leave_start_time" IS NOT NULL))) AND ("status"=1))
20:53:45.4361.0 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Punch', 61740, 'a:0:{}', '', 1000, '120.33.105.174')
20:53:45.4531.0 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Punch', 61741, 'a:0:{}', '', 1000, '120.33.105.174')
20:53:45.3111.0 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC'
20:53:45.3901.0 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Punch', 61737, 'a:2:{s:13:"in_leave_type";i:6;s:14:"out_leave_type";i:6;}', '', 1000, '120.33.105.174')
20:53:45.3421.0 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\PunchLeaves', 148, 'a:1:{s:23:"next_cancel_verify_user";i:1000;}', '', 1000, '120.33.105.174')
20:53:45.3411.0 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_punch_leaves" SET "next_cancel_verify_user"=NULL WHERE "id"=148
20:53:45.3281.0 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\PunchLeaves', 148, 'a:2:{s:6:"status";i:5;s:9:"cancel_at";s:5:"now()";}', '', 1000, '120.33.105.174')
20:53:45.4990.9 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Punch', 61744, 'a:2:{s:13:"in_leave_type";i:6;s:14:"out_leave_type";i:6;}', '', 1000, '120.33.105.174')
20:53:45.4710.9 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Punch', 61742, 'a:2:{s:13:"in_leave_type";i:6;s:14:"out_leave_type";i:6;}', '', 1000, '120.33.105.174')
20:53:45.3270.9 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_punch_leaves" SET "status"=6, "cancel_at"='now()', "updated_at"='now()' WHERE "id"=148
20:53:45.4850.9 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Punch', 61743, 'a:2:{s:13:"in_leave_type";i:6;s:14:"out_leave_type";i:6;}', '', 1000, '120.33.105.174')
20:53:45.3760.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("status" IN (1, 2, 5)) AND ("day_at"='2025-12-24') AND ("away_type"=1) ORDER BY "away_time" DESC
20:53:45.3360.8 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Comments', 220947, 'a:11:{s:2:"id";i:220947;s:9:"object_id";i:148;s:11:"object_type";s:2:"40";s:6:"parent";N;s:11:"description";s:37:"曹永生 通过了这个请假申请";s:10:"created_by";i:1000;s:10:"created_at";N;s:8:"reply_to";N;s:9:"is_system";b:1;s:8:"for_user";N;s:12:"description2";s:6:"年假";}', '', 1000, '120.33.105.174')
20:53:45.3790.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_repairs" WHERE ("created_by"=5064) AND ("day_at"='2025-12-24') AND ("status" IN (2, 5)) AND ("repair_type"=1) ORDER BY "verify_at" DESC
20:53:45.3830.6 msyii\db\Command::querySELECT *, overtime_end - overtime_start AS hours_spent FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("created_by"=5064) AND (("overtime_start" >= '2025-12-24 00:00:00') AND ("overtime_start" <= '2025-12-24 23:59:59')) AND ("status" IN (2, 5)) ORDER BY "verify_at" DESC
20:53:45.4240.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_leaves" WHERE ("created_by"=5064) AND ((("leave_start" <= '2025-12-27') AND ("leave_end" >= '2025-12-27'))) AND ("status" IN (2, 5)) ORDER BY "verify_at" DESC
20:53:45.4540.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch" WHERE ("day_at"='2025-12-29') AND ("user_id"=5064)
20:53:45.3140.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
20:53:45.3810.6 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_travels" WHERE ("created_by"=5064) AND ((("travel_start" < '2025-12-24') AND ("travel_end" > '2025-12-24')) OR (("travel_start"='2025-12-24') AND ("travel_start_type"=1)) OR (("travel_start" != '2025-12-24') AND ("travel_end"='2025-12-24'))) AND ("status" IN (2, 5)))
20:53:45.4370.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch" WHERE ("day_at"='2025-12-28') AND ("user_id"=5064)
20:53:45.4860.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch" WHERE ("day_at"='2025-12-31') AND ("user_id"=5064)
20:53:45.4200.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch" WHERE ("day_at"='2025-12-27') AND ("user_id"=5064)
20:53:45.3910.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch" WHERE ("day_at"='2025-12-25') AND ("user_id"=5064)
20:53:45.4060.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch" WHERE ("day_at"='2025-12-26') AND ("user_id"=5064)
20:53:45.4720.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch" WHERE ("day_at"='2025-12-30') AND ("user_id"=5064)
20:53:45.4550.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("status" IN (1, 2, 5)) AND ("day_at"='2025-12-29') AND ("away_type"=1) ORDER BY "away_time" DESC
20:53:45.4480.5 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_leaves" WHERE ("created_by"=5064) AND ((("leave_start" < '2025-12-28') AND ("leave_end" > '2025-12-28')) OR (("leave_end"='2025-12-28') AND ("leave_end_type"=2)) OR (("leave_start"='2025-12-28') AND ("leave_start_type"=2)) OR (("leave_start"='2025-12-28') AND ("leave_start_type"=1) AND ("leave_end" != '2025-12-28')) OR (("leave_start" <= '2025-12-28') AND ("leave_end" >= '2025-12-28') AND ("leave_start_time" IS NOT NULL))) AND ("status"=1))
20:53:45.4320.5 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_leaves" WHERE ("created_by"=5064) AND ((("leave_start" < '2025-12-27') AND ("leave_end" > '2025-12-27')) OR (("leave_end"='2025-12-27') AND ("leave_end_type"=2)) OR (("leave_start"='2025-12-27') AND ("leave_start_type"=2)) OR (("leave_start"='2025-12-27') AND ("leave_start_type"=1) AND ("leave_end" != '2025-12-27')) OR (("leave_start" <= '2025-12-27') AND ("leave_end" >= '2025-12-27') AND ("leave_start_time" IS NOT NULL))) AND ("status"=1))
20:53:45.4610.5 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_travels" WHERE ("created_by"=5064) AND ((("travel_start" < '2025-12-29') AND ("travel_end" > '2025-12-29')) OR (("travel_end"='2025-12-29') AND ("travel_end_type"=2)) OR (("travel_start"='2025-12-29') AND ("travel_start_type"=2)) OR (("travel_start"='2025-12-29') AND ("travel_start_type"=1) AND ("travel_end" != '2025-12-29'))) AND ("status" IN (2, 5)))
20:53:45.4510.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_travels" WHERE ("created_by"=5064) AND ((("travel_start" < '2025-12-28') AND ("travel_end" > '2025-12-28')) OR (("travel_end"='2025-12-28') AND ("travel_end_type"=2)) OR (("travel_start"='2025-12-28') AND ("travel_start_type"=2)) OR (("travel_start"='2025-12-28') AND ("travel_start_type"=1) AND ("travel_end" != '2025-12-28'))) AND ("status"=1) ORDER BY "verify_at" DESC
20:53:45.3800.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_leaves" WHERE ("created_by"=5064) AND ((("leave_start" <= '2025-12-24') AND ("leave_end" >= '2025-12-24'))) AND ("status" IN (2, 5)) ORDER BY "verify_at" DESC
20:53:45.4480.5 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_leaves" WHERE ("created_by"=5064) AND ((("leave_start" < '2025-12-28') AND ("leave_end" > '2025-12-28')) OR (("leave_start"='2025-12-28') AND ("leave_start_type"=1)) OR ("leave_end"='2025-12-28') OR (("leave_start" <= '2025-12-28') AND ("leave_end" >= '2025-12-28') AND ("leave_start_time" IS NOT NULL))) AND ("status"=1))
20:53:45.4410.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_repairs" WHERE ("created_by"=5064) AND ("day_at"='2025-12-28') AND ("status" IN (2, 5)) AND ("repair_type"=2) ORDER BY "verify_at" DESC
20:53:45.4590.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_leaves" WHERE ("created_by"=5064) AND ((("leave_start" <= '2025-12-29') AND ("leave_end" >= '2025-12-29'))) AND ("status" IN (2, 5)) ORDER BY "verify_at" DESC
20:53:45.4380.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("status" IN (1, 2, 5)) AND ("day_at"='2025-12-28') AND ("away_type"=1) ORDER BY "away_time" DESC
20:53:45.4570.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("day_at"='2025-12-29') AND ("status" IN (2, 5)) AND ("away_type"=1) ORDER BY "away_time" DESC
20:53:45.4390.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("day_at"='2025-12-28') AND ("status" IN (1, 2, 5)) AND ("away_type"=2) ORDER BY "away_time" DESC
20:53:45.4410.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_repairs" WHERE ("created_by"=5064) AND ("day_at"='2025-12-28') AND ("status" IN (2, 5)) AND ("repair_type"=1) ORDER BY "verify_at" DESC
20:53:45.3870.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_leaves" WHERE ("created_by"=5064) AND ((("leave_start" < '2025-12-24') AND ("leave_end" > '2025-12-24')) OR (("leave_end"='2025-12-24') AND ("leave_end_type"=2)) OR (("leave_start"='2025-12-24') AND ("leave_start_type"=2)) OR (("leave_start"='2025-12-24') AND ("leave_start_type"=1) AND ("leave_end" != '2025-12-24')) OR (("leave_start" <= '2025-12-24') AND ("leave_end" >= '2025-12-24') AND ("leave_start_time" IS NOT NULL))) AND ("status"=1))
20:53:45.4220.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("day_at"='2025-12-27') AND ("status" IN (2, 5)) AND ("away_type"=2) ORDER BY "away_time" DESC
20:53:45.3180.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_leaves" WHERE "id"='148'
20:53:45.4230.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_repairs" WHERE ("created_by"=5064) AND ("day_at"='2025-12-27') AND ("status" IN (2, 5)) AND ("repair_type"=1) ORDER BY "verify_at" DESC
20:53:45.4240.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_repairs" WHERE ("created_by"=5064) AND ("day_at"='2025-12-27') AND ("status" IN (2, 5)) AND ("repair_type"=2) ORDER BY "verify_at" DESC
20:53:45.4680.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_leaves" WHERE ("created_by"=5064) AND ((("leave_start" < '2025-12-29') AND ("leave_end" > '2025-12-29')) OR (("leave_end"='2025-12-29') AND ("leave_end_type"=2)) OR (("leave_start"='2025-12-29') AND ("leave_start_type"=2)) OR (("leave_start"='2025-12-29') AND ("leave_start_type"=1) AND ("leave_end" != '2025-12-29')) OR (("leave_start" <= '2025-12-29') AND ("leave_end" >= '2025-12-29') AND ("leave_start_time" IS NOT NULL))) AND ("status"=1))
20:53:45.4430.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_travels" WHERE ("created_by"=5064) AND ((("travel_start" < '2025-12-28') AND ("travel_end" > '2025-12-28')) OR (("travel_end"='2025-12-28') AND ("travel_end_type"=2)) OR (("travel_start"='2025-12-28') AND ("travel_start_type"=2)) OR (("travel_start"='2025-12-28') AND ("travel_start_type"=1) AND ("travel_end" != '2025-12-28'))) AND ("status" IN (2, 5)))
20:53:45.4590.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_repairs" WHERE ("created_by"=5064) AND ("day_at"='2025-12-29') AND ("status" IN (2, 5)) AND ("repair_type"=2) ORDER BY "verify_at" DESC
20:53:45.4220.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("day_at"='2025-12-27') AND ("status" IN (2, 5)) AND ("away_type"=1) ORDER BY "away_time" DESC
20:53:45.4400.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("day_at"='2025-12-28') AND ("status" IN (2, 5)) AND ("away_type"=2) ORDER BY "away_time" DESC
20:53:45.3100.4 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
20:53:45.4570.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("day_at"='2025-12-29') AND ("status" IN (2, 5)) AND ("away_type"=2) ORDER BY "away_time" DESC
20:53:45.4580.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_repairs" WHERE ("created_by"=5064) AND ("day_at"='2025-12-29') AND ("status" IN (2, 5)) AND ("repair_type"=1) ORDER BY "verify_at" DESC
20:53:45.4390.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("day_at"='2025-12-28') AND ("status" IN (2, 5)) AND ("away_type"=1) ORDER BY "away_time" DESC
20:53:45.4420.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_leaves" WHERE ("created_by"=5064) AND ((("leave_start" <= '2025-12-28') AND ("leave_end" >= '2025-12-28'))) AND ("status" IN (2, 5)) ORDER BY "verify_at" DESC
20:53:45.4330.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_travels" WHERE ("created_by"=5064) AND ((("travel_start" < '2025-12-27') AND ("travel_end" > '2025-12-27')) OR (("travel_end"='2025-12-27') AND ("travel_end_type"=2)) OR (("travel_start"='2025-12-27') AND ("travel_start_type"=2)) OR (("travel_start"='2025-12-27') AND ("travel_start_type"=1) AND ("travel_end" != '2025-12-27'))) AND ("status"=1) ORDER BY "verify_at" DESC
20:53:45.4560.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("day_at"='2025-12-29') AND ("status" IN (1, 2, 5)) AND ("away_type"=2) ORDER BY "away_time" DESC
20:53:45.3770.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("day_at"='2025-12-24') AND ("status" IN (1, 2, 5)) AND ("away_type"=2) ORDER BY "away_time" DESC
20:53:45.4260.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_travels" WHERE ("created_by"=5064) AND ((("travel_start" < '2025-12-27') AND ("travel_end" > '2025-12-27')) OR (("travel_end"='2025-12-27') AND ("travel_end_type"=2)) OR (("travel_start"='2025-12-27') AND ("travel_start_type"=2)) OR (("travel_start"='2025-12-27') AND ("travel_start_type"=1) AND ("travel_end" != '2025-12-27'))) AND ("status" IN (2, 5)))
20:53:45.3430.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
20:53:45.4270.4 msyii\db\Command::querySELECT *, overtime_end - overtime_start AS hours_spent FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("created_by"=5064) AND (("overtime_start" >= '2025-12-27 00:00:00') AND ("overtime_start" <= '2025-12-27 23:59:59')) AND ("status" IN (2, 5)) ORDER BY "verify_at" DESC
20:53:45.4330.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_travels" WHERE ("created_by"=5064) AND ((("travel_start" < '2025-12-27') AND ("travel_end" > '2025-12-27')) OR (("travel_start"='2025-12-27') AND ("travel_start_type"=1)) OR ("travel_end"='2025-12-27')) AND ("status"=1) ORDER BY "verify_at" DESC
20:53:45.4250.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_travels" WHERE ("created_by"=5064) AND ((("travel_start" < '2025-12-27') AND ("travel_end" > '2025-12-27')) OR (("travel_start"='2025-12-27') AND ("travel_start_type"=1)) OR (("travel_start" != '2025-12-27') AND ("travel_end"='2025-12-27'))) AND ("status" IN (2, 5)))
20:53:45.3860.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_leaves" WHERE ("created_by"=5064) AND ((("leave_start" < '2025-12-24') AND ("leave_end" > '2025-12-24')) OR (("leave_start"='2025-12-24') AND ("leave_start_type"=1)) OR ("leave_end"='2025-12-24') OR (("leave_start" <= '2025-12-24') AND ("leave_end" >= '2025-12-24') AND ("leave_start_time" IS NOT NULL))) AND ("status"=1))
20:53:45.4210.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("status" IN (1, 2, 5)) AND ("day_at"='2025-12-27') AND ("away_type"=1) ORDER BY "away_time" DESC
20:53:45.4430.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_travels" WHERE ("created_by"=5064) AND ((("travel_start" < '2025-12-28') AND ("travel_end" > '2025-12-28')) OR (("travel_start"='2025-12-28') AND ("travel_start_type"=1)) OR (("travel_start" != '2025-12-28') AND ("travel_end"='2025-12-28'))) AND ("status" IN (2, 5)))
20:53:45.4870.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("status" IN (1, 2, 5)) AND ("day_at"='2025-12-31') AND ("away_type"=1) ORDER BY "away_time" DESC
20:53:45.4290.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_repairs" WHERE ("created_by"=5064) AND ("day_at"='2025-12-27') AND ("status"=1) AND ("repair_type"=1))
20:53:45.4460.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_repairs" WHERE ("created_by"=5064) AND ("day_at"='2025-12-28') AND ("status"=1) AND ("repair_type"=1))
20:53:45.3800.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_repairs" WHERE ("created_by"=5064) AND ("day_at"='2025-12-24') AND ("status" IN (2, 5)) AND ("repair_type"=2) ORDER BY "verify_at" DESC
20:53:45.4600.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_travels" WHERE ("created_by"=5064) AND ((("travel_start" < '2025-12-29') AND ("travel_end" > '2025-12-29')) OR (("travel_start"='2025-12-29') AND ("travel_start_type"=1)) OR (("travel_start" != '2025-12-29') AND ("travel_end"='2025-12-29'))) AND ("status" IN (2, 5)))
20:53:45.4950.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_leaves" WHERE ("created_by"=5064) AND ((("leave_start" < '2025-12-31') AND ("leave_end" > '2025-12-31')) OR (("leave_start"='2025-12-31') AND ("leave_start_type"=1)) OR ("leave_end"='2025-12-31') OR (("leave_start" <= '2025-12-31') AND ("leave_end" >= '2025-12-31') AND ("leave_start_time" IS NOT NULL))) AND ("status"=1))
20:53:45.4010.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_leaves" WHERE ("created_by"=5064) AND ((("leave_start" < '2025-12-25') AND ("leave_end" > '2025-12-25')) OR (("leave_end"='2025-12-25') AND ("leave_end_type"=2)) OR (("leave_start"='2025-12-25') AND ("leave_start_type"=2)) OR (("leave_start"='2025-12-25') AND ("leave_start_type"=1) AND ("leave_end" != '2025-12-25')) OR (("leave_start" <= '2025-12-25') AND ("leave_end" >= '2025-12-25') AND ("leave_start_time" IS NOT NULL))) AND ("status"=1))
20:53:45.4440.4 msyii\db\Command::querySELECT *, overtime_end - overtime_start AS hours_spent FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("created_by"=5064) AND (("overtime_start" >= '2025-12-28 00:00:00') AND ("overtime_start" <= '2025-12-28 23:59:59')) AND ("status" IN (2, 5)) ORDER BY "verify_at" DESC
20:53:45.4300.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_repairs" WHERE ("created_by"=5064) AND ("day_at"='2025-12-27') AND ("status"=1) AND ("repair_type"=2))
20:53:45.4750.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_repairs" WHERE ("created_by"=5064) AND ("day_at"='2025-12-30') AND ("status" IN (2, 5)) AND ("repair_type"=1) ORDER BY "verify_at" DESC
20:53:45.4490.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_travels" WHERE ("created_by"=5064) AND ((("travel_start" < '2025-12-28') AND ("travel_end" > '2025-12-28')) OR (("travel_start"='2025-12-28') AND ("travel_start_type"=1)) OR ("travel_end"='2025-12-28')) AND ("status"=1) ORDER BY "verify_at" DESC
20:53:45.4960.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_leaves" WHERE ("created_by"=5064) AND ((("leave_start" < '2025-12-31') AND ("leave_end" > '2025-12-31')) OR (("leave_end"='2025-12-31') AND ("leave_end_type"=2)) OR (("leave_start"='2025-12-31') AND ("leave_start_type"=2)) OR (("leave_start"='2025-12-31') AND ("leave_start_type"=1) AND ("leave_end" != '2025-12-31')) OR (("leave_start" <= '2025-12-31') AND ("leave_end" >= '2025-12-31') AND ("leave_start_time" IS NOT NULL))) AND ("status"=1))
20:53:45.4150.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_leaves" WHERE ("created_by"=5064) AND ((("leave_start" < '2025-12-26') AND ("leave_end" > '2025-12-26')) OR (("leave_end"='2025-12-26') AND ("leave_end_type"=2)) OR (("leave_start"='2025-12-26') AND ("leave_start_type"=2)) OR (("leave_start"='2025-12-26') AND ("leave_start_type"=1) AND ("leave_end" != '2025-12-26')) OR (("leave_start" <= '2025-12-26') AND ("leave_end" >= '2025-12-26') AND ("leave_start_time" IS NOT NULL))) AND ("status"=1))
20:53:45.4080.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("day_at"='2025-12-26') AND ("status" IN (2, 5)) AND ("away_type"=1) ORDER BY "away_time" DESC
20:53:45.4820.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_leaves" WHERE ("created_by"=5064) AND ((("leave_start" < '2025-12-30') AND ("leave_end" > '2025-12-30')) OR (("leave_end"='2025-12-30') AND ("leave_end_type"=2)) OR (("leave_start"='2025-12-30') AND ("leave_start_type"=2)) OR (("leave_start"='2025-12-30') AND ("leave_start_type"=1) AND ("leave_end" != '2025-12-30')) OR (("leave_start" <= '2025-12-30') AND ("leave_end" >= '2025-12-30') AND ("leave_start_time" IS NOT NULL))) AND ("status"=1))
20:53:45.4290.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("away_type"=2) AND ("day_at"='2025-12-27') AND ("status"=1))
20:53:45.3960.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_leaves" WHERE ("created_by"=5064) AND ((("leave_start" <= '2025-12-25') AND ("leave_end" >= '2025-12-25'))) AND ("status" IN (2, 5)) ORDER BY "verify_at" DESC
20:53:45.4280.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("away_type"=1) AND ("day_at"='2025-12-27') AND ("status"=1))
20:53:45.4730.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("status" IN (1, 2, 5)) AND ("day_at"='2025-12-30') AND ("away_type"=1) ORDER BY "away_time" DESC
20:53:45.3820.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_travels" WHERE ("created_by"=5064) AND ((("travel_start" < '2025-12-24') AND ("travel_end" > '2025-12-24')) OR (("travel_end"='2025-12-24') AND ("travel_end_type"=2)) OR (("travel_start"='2025-12-24') AND ("travel_start_type"=2)) OR (("travel_start"='2025-12-24') AND ("travel_start_type"=1) AND ("travel_end" != '2025-12-24'))) AND ("status" IN (2, 5)))
20:53:45.3390.4 msyii\db\Command::querySELECT "channel_id" FROM "global"."tbl_logins" WHERE ("id" IN (5252, 5388, 5064)) AND ("id" != 1000) AND (channel_id IS NOT NULL)
20:53:45.3780.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("day_at"='2025-12-24') AND ("status" IN (2, 5)) AND ("away_type"=2) ORDER BY "away_time" DESC
20:53:45.3190.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_leave_cancel_verify_rels" WHERE ("status"=0) AND ("punch_leave_id"=148) ORDER BY "id"
20:53:45.4060.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("status" IN (1, 2, 5)) AND ("day_at"='2025-12-26') AND ("away_type"=1) ORDER BY "away_time" DESC
20:53:45.4140.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_leaves" WHERE ("created_by"=5064) AND ((("leave_start" < '2025-12-26') AND ("leave_end" > '2025-12-26')) OR (("leave_start"='2025-12-26') AND ("leave_start_type"=1)) OR ("leave_end"='2025-12-26') OR (("leave_start" <= '2025-12-26') AND ("leave_end" >= '2025-12-26') AND ("leave_start_time" IS NOT NULL))) AND ("status"=1))
20:53:45.3770.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("day_at"='2025-12-24') AND ("status" IN (2, 5)) AND ("away_type"=1) ORDER BY "away_time" DESC
20:53:45.3920.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("status" IN (1, 2, 5)) AND ("day_at"='2025-12-25') AND ("away_type"=1) ORDER BY "away_time" DESC
20:53:45.4810.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_leaves" WHERE ("created_by"=5064) AND ((("leave_start" < '2025-12-30') AND ("leave_end" > '2025-12-30')) OR (("leave_start"='2025-12-30') AND ("leave_start_type"=1)) OR ("leave_end"='2025-12-30') OR (("leave_start" <= '2025-12-30') AND ("leave_end" >= '2025-12-30') AND ("leave_start_time" IS NOT NULL))) AND ("status"=1))
20:53:45.3300.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064
20:53:45.3870.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_travels" WHERE ("created_by"=5064) AND ((("travel_start" < '2025-12-24') AND ("travel_end" > '2025-12-24')) OR (("travel_start"='2025-12-24') AND ("travel_start_type"=1)) OR ("travel_end"='2025-12-24')) AND ("status"=1) ORDER BY "verify_at" DESC
20:53:45.4450.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("away_type"=1) AND ("day_at"='2025-12-28') AND ("status"=1))
20:53:45.4900.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_repairs" WHERE ("created_by"=5064) AND ("day_at"='2025-12-31') AND ("status" IN (2, 5)) AND ("repair_type"=1) ORDER BY "verify_at" DESC
20:53:45.4090.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_repairs" WHERE ("created_by"=5064) AND ("day_at"='2025-12-26') AND ("status" IN (2, 5)) AND ("repair_type"=1) ORDER BY "verify_at" DESC
20:53:45.4740.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("day_at"='2025-12-30') AND ("status" IN (1, 2, 5)) AND ("away_type"=2) ORDER BY "away_time" DESC
20:53:45.4910.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_leaves" WHERE ("created_by"=5064) AND ((("leave_start" <= '2025-12-31') AND ("leave_end" >= '2025-12-31'))) AND ("status" IN (2, 5)) ORDER BY "verify_at" DESC
20:53:45.4460.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("away_type"=2) AND ("day_at"='2025-12-28') AND ("status"=1))
20:53:45.4160.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_travels" WHERE ("created_by"=5064) AND ((("travel_start" < '2025-12-26') AND ("travel_end" > '2025-12-26')) OR (("travel_start"='2025-12-26') AND ("travel_start_type"=1)) OR ("travel_end"='2025-12-26')) AND ("status"=1) ORDER BY "verify_at" DESC
20:53:45.4770.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_leaves" WHERE ("created_by"=5064) AND ((("leave_start" <= '2025-12-30') AND ("leave_end" >= '2025-12-30'))) AND ("status" IN (2, 5)) ORDER BY "verify_at" DESC
20:53:45.4970.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_travels" WHERE ("created_by"=5064) AND ((("travel_start" < '2025-12-31') AND ("travel_end" > '2025-12-31')) OR (("travel_start"='2025-12-31') AND ("travel_start_type"=1)) OR ("travel_end"='2025-12-31')) AND ("status"=1) ORDER BY "verify_at" DESC
20:53:45.4470.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_repairs" WHERE ("created_by"=5064) AND ("day_at"='2025-12-28') AND ("status"=1) AND ("repair_type"=2))
20:53:45.4890.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("day_at"='2025-12-31') AND ("status" IN (2, 5)) AND ("away_type"=1) ORDER BY "away_time" DESC
20:53:45.4670.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_leaves" WHERE ("created_by"=5064) AND ((("leave_start" < '2025-12-29') AND ("leave_end" > '2025-12-29')) OR (("leave_start"='2025-12-29') AND ("leave_start_type"=1)) OR ("leave_end"='2025-12-29') OR (("leave_start" <= '2025-12-29') AND ("leave_end" >= '2025-12-29') AND ("leave_start_time" IS NOT NULL))) AND ("status"=1))
20:53:45.3940.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_repairs" WHERE ("created_by"=5064) AND ("day_at"='2025-12-25') AND ("status" IN (2, 5)) AND ("repair_type"=1) ORDER BY "verify_at" DESC
20:53:45.4100.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_leaves" WHERE ("created_by"=5064) AND ((("leave_start" <= '2025-12-26') AND ("leave_end" >= '2025-12-26'))) AND ("status" IN (2, 5)) ORDER BY "verify_at" DESC
20:53:45.4780.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_travels" WHERE ("created_by"=5064) AND ((("travel_start" < '2025-12-30') AND ("travel_end" > '2025-12-30')) OR (("travel_end"='2025-12-30') AND ("travel_end_type"=2)) OR (("travel_start"='2025-12-30') AND ("travel_start_type"=2)) OR (("travel_start"='2025-12-30') AND ("travel_start_type"=1) AND ("travel_end" != '2025-12-30'))) AND ("status" IN (2, 5)))
20:53:45.4690.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_travels" WHERE ("created_by"=5064) AND ((("travel_start" < '2025-12-29') AND ("travel_end" > '2025-12-29')) OR (("travel_end"='2025-12-29') AND ("travel_end_type"=2)) OR (("travel_start"='2025-12-29') AND ("travel_start_type"=2)) OR (("travel_start"='2025-12-29') AND ("travel_start_type"=1) AND ("travel_end" != '2025-12-29'))) AND ("status"=1) ORDER BY "verify_at" DESC
20:53:45.3930.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("day_at"='2025-12-25') AND ("status" IN (1, 2, 5)) AND ("away_type"=2) ORDER BY "away_time" DESC
20:53:45.3970.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_travels" WHERE ("created_by"=5064) AND ((("travel_start" < '2025-12-25') AND ("travel_end" > '2025-12-25')) OR (("travel_end"='2025-12-25') AND ("travel_end_type"=2)) OR (("travel_start"='2025-12-25') AND ("travel_start_type"=2)) OR (("travel_start"='2025-12-25') AND ("travel_start_type"=1) AND ("travel_end" != '2025-12-25'))) AND ("status" IN (2, 5)))
20:53:45.4000.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_leaves" WHERE ("created_by"=5064) AND ((("leave_start" < '2025-12-25') AND ("leave_end" > '2025-12-25')) OR (("leave_start"='2025-12-25') AND ("leave_start_type"=1)) OR ("leave_end"='2025-12-25') OR (("leave_start" <= '2025-12-25') AND ("leave_end" >= '2025-12-25') AND ("leave_start_time" IS NOT NULL))) AND ("status"=1))
20:53:45.4750.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("day_at"='2025-12-30') AND ("status" IN (2, 5)) AND ("away_type"=2) ORDER BY "away_time" DESC
20:53:45.4880.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("day_at"='2025-12-31') AND ("status" IN (1, 2, 5)) AND ("away_type"=2) ORDER BY "away_time" DESC
20:53:45.3340.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000)
20:53:45.4070.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("day_at"='2025-12-26') AND ("status" IN (1, 2, 5)) AND ("away_type"=2) ORDER BY "away_time" DESC
20:53:45.3940.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("day_at"='2025-12-25') AND ("status" IN (2, 5)) AND ("away_type"=2) ORDER BY "away_time" DESC
20:53:45.4210.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("day_at"='2025-12-27') AND ("status" IN (1, 2, 5)) AND ("away_type"=2) ORDER BY "away_time" DESC
20:53:45.4760.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_repairs" WHERE ("created_by"=5064) AND ("day_at"='2025-12-30') AND ("status" IN (2, 5)) AND ("repair_type"=2) ORDER BY "verify_at" DESC
20:53:45.4920.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_travels" WHERE ("created_by"=5064) AND ((("travel_start" < '2025-12-31') AND ("travel_end" > '2025-12-31')) OR (("travel_end"='2025-12-31') AND ("travel_end_type"=2)) OR (("travel_start"='2025-12-31') AND ("travel_start_type"=2)) OR (("travel_start"='2025-12-31') AND ("travel_start_type"=1) AND ("travel_end" != '2025-12-31'))) AND ("status" IN (2, 5)))
20:53:45.4450.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("created_by"=5064) AND (("overtime_start" >= '2025-12-28 00:00:00') AND ("overtime_start" <= '2025-12-28 23:59:59')) AND ("status"=1))
20:53:45.4890.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("day_at"='2025-12-31') AND ("status" IN (2, 5)) AND ("away_type"=2) ORDER BY "away_time" DESC
20:53:45.4740.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("day_at"='2025-12-30') AND ("status" IN (2, 5)) AND ("away_type"=1) ORDER BY "away_time" DESC
20:53:45.4080.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("day_at"='2025-12-26') AND ("status" IN (2, 5)) AND ("away_type"=2) ORDER BY "away_time" DESC
20:53:45.3880.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_travels" WHERE ("created_by"=5064) AND ((("travel_start" < '2025-12-24') AND ("travel_end" > '2025-12-24')) OR (("travel_end"='2025-12-24') AND ("travel_end_type"=2)) OR (("travel_start"='2025-12-24') AND ("travel_start_type"=2)) OR (("travel_start"='2025-12-24') AND ("travel_start_type"=1) AND ("travel_end" != '2025-12-24'))) AND ("status"=1) ORDER BY "verify_at" DESC
20:53:45.4900.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_repairs" WHERE ("created_by"=5064) AND ("day_at"='2025-12-31') AND ("status" IN (2, 5)) AND ("repair_type"=2) ORDER BY "verify_at" DESC
20:53:45.3950.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_repairs" WHERE ("created_by"=5064) AND ("day_at"='2025-12-25') AND ("status" IN (2, 5)) AND ("repair_type"=2) ORDER BY "verify_at" DESC
20:53:45.4110.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_travels" WHERE ("created_by"=5064) AND ((("travel_start" < '2025-12-26') AND ("travel_end" > '2025-12-26')) OR (("travel_end"='2025-12-26') AND ("travel_end_type"=2)) OR (("travel_start"='2025-12-26') AND ("travel_start_type"=2)) OR (("travel_start"='2025-12-26') AND ("travel_start_type"=1) AND ("travel_end" != '2025-12-26'))) AND ("status" IN (2, 5)))
20:53:45.3930.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("day_at"='2025-12-25') AND ("status" IN (2, 5)) AND ("away_type"=1) ORDER BY "away_time" DESC
20:53:45.4090.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_repairs" WHERE ("created_by"=5064) AND ("day_at"='2025-12-26') AND ("status" IN (2, 5)) AND ("repair_type"=2) ORDER BY "verify_at" DESC
20:53:45.4830.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_travels" WHERE ("created_by"=5064) AND ((("travel_start" < '2025-12-30') AND ("travel_end" > '2025-12-30')) OR (("travel_end"='2025-12-30') AND ("travel_end_type"=2)) OR (("travel_start"='2025-12-30') AND ("travel_start_type"=2)) OR (("travel_start"='2025-12-30') AND ("travel_start_type"=1) AND ("travel_end" != '2025-12-30'))) AND ("status"=1) ORDER BY "verify_at" DESC
20:53:45.4830.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_travels" WHERE ("created_by"=5064) AND ((("travel_start" < '2025-12-30') AND ("travel_end" > '2025-12-30')) OR (("travel_start"='2025-12-30') AND ("travel_start_type"=1)) OR ("travel_end"='2025-12-30')) AND ("status"=1) ORDER BY "verify_at" DESC
20:53:45.4020.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_travels" WHERE ("created_by"=5064) AND ((("travel_start" < '2025-12-25') AND ("travel_end" > '2025-12-25')) OR (("travel_end"='2025-12-25') AND ("travel_end_type"=2)) OR (("travel_start"='2025-12-25') AND ("travel_start_type"=2)) OR (("travel_start"='2025-12-25') AND ("travel_start_type"=1) AND ("travel_end" != '2025-12-25'))) AND ("status"=1) ORDER BY "verify_at" DESC
20:53:45.4160.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_travels" WHERE ("created_by"=5064) AND ((("travel_start" < '2025-12-26') AND ("travel_end" > '2025-12-26')) OR (("travel_end"='2025-12-26') AND ("travel_end_type"=2)) OR (("travel_start"='2025-12-26') AND ("travel_start_type"=2)) OR (("travel_start"='2025-12-26') AND ("travel_start_type"=1) AND ("travel_end" != '2025-12-26'))) AND ("status"=1) ORDER BY "verify_at" DESC
20:53:45.4970.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_travels" WHERE ("created_by"=5064) AND ((("travel_start" < '2025-12-31') AND ("travel_end" > '2025-12-31')) OR (("travel_end"='2025-12-31') AND ("travel_end_type"=2)) OR (("travel_start"='2025-12-31') AND ("travel_start_type"=2)) OR (("travel_start"='2025-12-31') AND ("travel_start_type"=1) AND ("travel_end" != '2025-12-31'))) AND ("status"=1) ORDER BY "verify_at" DESC
20:53:45.3260.3 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT * FROM "a57be577deb434"."tbl_punch_leave_cancel_verify_rels" WHERE ("status"=0) AND ("punch_leave_id"=148) ORDER BY "id") "c"
20:53:45.4110.3 msyii\db\Command::querySELECT *, overtime_end - overtime_start AS hours_spent FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("created_by"=5064) AND (("overtime_start" >= '2025-12-26 00:00:00') AND ("overtime_start" <= '2025-12-26 23:59:59')) AND ("status" IN (2, 5)) ORDER BY "verify_at" DESC
20:53:45.4000.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_repairs" WHERE ("created_by"=5064) AND ("day_at"='2025-12-25') AND ("status"=1) AND ("repair_type"=2))
20:53:45.4660.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_repairs" WHERE ("created_by"=5064) AND ("day_at"='2025-12-29') AND ("status"=1) AND ("repair_type"=2))
20:53:45.4270.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("created_by"=5064) AND (("overtime_start" >= '2025-12-27 00:00:00') AND ("overtime_start" <= '2025-12-27 23:59:59')) AND ("status"=1))
20:53:45.4770.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_travels" WHERE ("created_by"=5064) AND ((("travel_start" < '2025-12-30') AND ("travel_end" > '2025-12-30')) OR (("travel_start"='2025-12-30') AND ("travel_start_type"=1)) OR (("travel_start" != '2025-12-30') AND ("travel_end"='2025-12-30'))) AND ("status" IN (2, 5)))
20:53:45.4680.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_travels" WHERE ("created_by"=5064) AND ((("travel_start" < '2025-12-29') AND ("travel_end" > '2025-12-29')) OR (("travel_start"='2025-12-29') AND ("travel_start_type"=1)) OR ("travel_end"='2025-12-29')) AND ("status"=1) ORDER BY "verify_at" DESC
20:53:45.3840.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("away_type"=1) AND ("day_at"='2025-12-24') AND ("status"=1))
20:53:45.3850.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_repairs" WHERE ("created_by"=5064) AND ("day_at"='2025-12-24') AND ("status"=1) AND ("repair_type"=2))
20:53:45.3960.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_travels" WHERE ("created_by"=5064) AND ((("travel_start" < '2025-12-25') AND ("travel_end" > '2025-12-25')) OR (("travel_start"='2025-12-25') AND ("travel_start_type"=1)) OR (("travel_start" != '2025-12-25') AND ("travel_end"='2025-12-25'))) AND ("status" IN (2, 5)))
20:53:45.3990.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("away_type"=2) AND ("day_at"='2025-12-25') AND ("status"=1))
20:53:45.4650.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("away_type"=2) AND ("day_at"='2025-12-29') AND ("status"=1))
20:53:45.3840.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("away_type"=2) AND ("day_at"='2025-12-24') AND ("status"=1))
20:53:45.4910.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_travels" WHERE ("created_by"=5064) AND ((("travel_start" < '2025-12-31') AND ("travel_end" > '2025-12-31')) OR (("travel_start"='2025-12-31') AND ("travel_start_type"=1)) OR (("travel_start" != '2025-12-31') AND ("travel_end"='2025-12-31'))) AND ("status" IN (2, 5)))
20:53:45.4920.3 msyii\db\Command::querySELECT *, overtime_end - overtime_start AS hours_spent FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("created_by"=5064) AND (("overtime_start" >= '2025-12-31 00:00:00') AND ("overtime_start" <= '2025-12-31 23:59:59')) AND ("status" IN (2, 5)) ORDER BY "verify_at" DESC
20:53:45.3850.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_repairs" WHERE ("created_by"=5064) AND ("day_at"='2025-12-24') AND ("status"=1) AND ("repair_type"=1))
20:53:45.4010.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_travels" WHERE ("created_by"=5064) AND ((("travel_start" < '2025-12-25') AND ("travel_end" > '2025-12-25')) OR (("travel_start"='2025-12-25') AND ("travel_start_type"=1)) OR ("travel_end"='2025-12-25')) AND ("status"=1) ORDER BY "verify_at" DESC
20:53:45.4780.3 msyii\db\Command::querySELECT *, overtime_end - overtime_start AS hours_spent FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("created_by"=5064) AND (("overtime_start" >= '2025-12-30 00:00:00') AND ("overtime_start" <= '2025-12-30 23:59:59')) AND ("status" IN (2, 5)) ORDER BY "verify_at" DESC
20:53:45.3830.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("created_by"=5064) AND (("overtime_start" >= '2025-12-24 00:00:00') AND ("overtime_start" <= '2025-12-24 23:59:59')) AND ("status"=1))
20:53:45.4100.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_travels" WHERE ("created_by"=5064) AND ((("travel_start" < '2025-12-26') AND ("travel_end" > '2025-12-26')) OR (("travel_start"='2025-12-26') AND ("travel_start_type"=1)) OR (("travel_start" != '2025-12-26') AND ("travel_end"='2025-12-26'))) AND ("status" IN (2, 5)))
20:53:45.3970.3 msyii\db\Command::querySELECT *, overtime_end - overtime_start AS hours_spent FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("created_by"=5064) AND (("overtime_start" >= '2025-12-25 00:00:00') AND ("overtime_start" <= '2025-12-25 23:59:59')) AND ("status" IN (2, 5)) ORDER BY "verify_at" DESC
20:53:45.4650.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("away_type"=1) AND ("day_at"='2025-12-29') AND ("status"=1))
20:53:45.4660.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_repairs" WHERE ("created_by"=5064) AND ("day_at"='2025-12-29') AND ("status"=1) AND ("repair_type"=1))
20:53:45.4800.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("away_type"=2) AND ("day_at"='2025-12-30') AND ("status"=1))
20:53:45.3330.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_leaves" WHERE "id"=148
20:53:45.4800.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_repairs" WHERE ("created_by"=5064) AND ("day_at"='2025-12-30') AND ("status"=1) AND ("repair_type"=1))
20:53:45.3990.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_repairs" WHERE ("created_by"=5064) AND ("day_at"='2025-12-25') AND ("status"=1) AND ("repair_type"=1))
20:53:45.4940.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_repairs" WHERE ("created_by"=5064) AND ("day_at"='2025-12-31') AND ("status"=1) AND ("repair_type"=1))
20:53:45.4130.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_repairs" WHERE ("created_by"=5064) AND ("day_at"='2025-12-26') AND ("status"=1) AND ("repair_type"=1))
20:53:45.4140.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_repairs" WHERE ("created_by"=5064) AND ("day_at"='2025-12-26') AND ("status"=1) AND ("repair_type"=2))
20:53:45.4790.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("away_type"=1) AND ("day_at"='2025-12-30') AND ("status"=1))
20:53:45.4810.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_repairs" WHERE ("created_by"=5064) AND ("day_at"='2025-12-30') AND ("status"=1) AND ("repair_type"=2))
20:53:45.4130.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("away_type"=2) AND ("day_at"='2025-12-26') AND ("status"=1))
20:53:45.4930.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("away_type"=1) AND ("day_at"='2025-12-31') AND ("status"=1))
20:53:45.4940.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("away_type"=2) AND ("day_at"='2025-12-31') AND ("status"=1))
20:53:45.4950.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_repairs" WHERE ("created_by"=5064) AND ("day_at"='2025-12-31') AND ("status"=1) AND ("repair_type"=2))
20:53:45.4120.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("away_type"=1) AND ("day_at"='2025-12-26') AND ("status"=1))
20:53:45.4650.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("created_by"=5064) AND (("overtime_start" >= '2025-12-29 00:00:00') AND ("overtime_start" <= '2025-12-29 23:59:59')) AND ("status"=1))
20:53:45.3980.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_aways" WHERE ("created_by"=5064) AND ("away_type"=1) AND ("day_at"='2025-12-25') AND ("status"=1))
20:53:45.3980.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("created_by"=5064) AND (("overtime_start" >= '2025-12-25 00:00:00') AND ("overtime_start" <= '2025-12-25 23:59:59')) AND ("status"=1))
20:53:45.3290.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_leaves" WHERE "id"='148'
20:53:45.4790.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("created_by"=5064) AND (("overtime_start" >= '2025-12-30 00:00:00') AND ("overtime_start" <= '2025-12-30 23:59:59')) AND ("status"=1))
20:53:45.4930.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("created_by"=5064) AND (("overtime_start" >= '2025-12-31 00:00:00') AND ("overtime_start" <= '2025-12-31 23:59:59')) AND ("status"=1))
20:53:45.3310.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_leave_cancel_verify_rels" WHERE ("status"=0) AND ("punch_leave_id"=148) ORDER BY "id"
20:53:45.4120.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("created_by"=5064) AND (("overtime_start" >= '2025-12-26 00:00:00') AND ("overtime_start" <= '2025-12-26 23:59:59')) AND ("status"=1))
20:53:45.3310.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_leave_carbon_copy_rels" WHERE "punch_leave_id"=148