ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a50bb02c2cf6: POST https://beta.jinchangxiao.com/vue/work-log/list at 2026-07-10 05:27:30 pm by 124.232.142.234

Database Queries

总计33条数据
TimeDurationTypeQuery
  
17:27:30.8051.0 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC'

[+] Explain
17:27:30.8080.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
17:27:30.81372.6 msSELECTSELECT COUNT(*) FROM (SELECT s.*, s.end_at - s.start_at AS hours_spent, CASE WHEN rvr.status = 0 THEN 1 ELSE 0 END as approvesort FROM "a57be577deb434"."tbl_work_logs" "s" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = s.client_id AND client.deleted = FALSE LEFT JOIN "a57be577deb434"."tbl_location" "lin" ON s.location_in_id = lin.id LEFT JOIN "a57be577deb434"."tbl_location" "lout" ON s.location_out_id = lout.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON "p"."id" = "s"."project_id" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON "u"."id" = "s"."created_by" LEFT JOIN "a57be577deb434"."tbl_work_log_verify_rels" "rvr" ON rvr.work_log_id = s.id LEFT JOIN "a57be577deb434"."tbl_work_log_carbon_copy_rels" "ccr" ON ccr.work_log_id = s.id LEFT JOIN "a57be577deb434"."tbl_work_log_verify_rels" "rvr2" ON rvr2.work_log_id = s.id and rvr2.user_id = 1001 and rvr2.status = 0 WHERE ("rvr2"."user_id" IS NOT NULL) AND ("s"."is_draft"=FALSE) GROUP BY "s"."id", "lin"."id", "lout"."id", "approvesort" ORDER BY "is_draft" DESC, "approvesort" DESC, "s"."end_at", s.updated_at DESC nulls last, "s"."created_at" DESC) "c"

[+] Explain
17:27:30.89361.0 msSELECTSELECT s.*, s.end_at - s.start_at AS hours_spent, CASE WHEN rvr.status = 0 THEN 1 ELSE 0 END as approvesort FROM "a57be577deb434"."tbl_work_logs" "s" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = s.client_id AND client.deleted = FALSE LEFT JOIN "a57be577deb434"."tbl_location" "lin" ON s.location_in_id = lin.id LEFT JOIN "a57be577deb434"."tbl_location" "lout" ON s.location_out_id = lout.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON "p"."id" = "s"."project_id" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON "u"."id" = "s"."created_by" LEFT JOIN "a57be577deb434"."tbl_work_log_verify_rels" "rvr" ON rvr.work_log_id = s.id LEFT JOIN "a57be577deb434"."tbl_work_log_carbon_copy_rels" "ccr" ON ccr.work_log_id = s.id LEFT JOIN "a57be577deb434"."tbl_work_log_verify_rels" "rvr2" ON rvr2.work_log_id = s.id and rvr2.user_id = 1001 and rvr2.status = 0 WHERE ("rvr2"."user_id" IS NOT NULL) AND ("s"."is_draft"=FALSE) GROUP BY "s"."id", "lin"."id", "lout"."id", "approvesort" ORDER BY "is_draft" DESC, "approvesort" DESC, "s"."end_at", s.updated_at DESC nulls last, "s"."created_at" DESC LIMIT 20

[+] Explain
17:27:30.9560.7 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5300

[+] Explain
17:27:30.9570.5 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5300)

[+] Explain
17:27:30.9580.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1

[+] Explain
17:27:30.9596.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_work_log_scenario_options" WHERE "id" IN (72, 67)

[+] Explain
17:27:30.9650.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_work_log_scenarios" WHERE "id"=1

[+] Explain
17:27:30.9660.4 msSELECTSELECT "id", "id" AS "key", "name", "client_class", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (12, 402, 18, 530)

[+] Explain
17:27:30.9660.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5311, 5300)

[+] Explain
17:27:30.9670.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_classes" WHERE "id" IN (43, 80, 47)

[+] Explain
17:27:30.9670.3 msSELECTSELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3496, 3673)

[+] Explain
17:27:30.9683.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_work_log_contacts" WHERE "work_log_id" IN (35860, 35859, 35858, 35857, 35856, 35855, 35854)

[+] Explain
17:27:30.9720.4 msSELECTSELECT "id", "id" AS "key", "name", "department", "job_position" FROM "a57be577deb434"."tbl_contacts" WHERE "id" IN (5248, 24, 5286, 1022)

[+] Explain
17:27:30.9731.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id" IN (24, 1022, 5248, 5286)

[+] Explain
17:27:30.97562.1 msSELECTSELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=19) AND ("object_id" IN (35860, 35859, 35858, 35857, 35856, 35855, 35854)) GROUP BY "object_id"

[+] Explain
17:27:31.0373.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=18) AND ("object_id" IN (35860, 35859, 35858, 35857, 35856, 35855, 35854))

[+] Explain
17:27:31.0413.8 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=101) AND ("object_id" IN (35860, 35859, 35858, 35857, 35856, 35855, 35854))

[+] Explain
17:27:31.0451.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_work_log_carbon_copy_rels" WHERE "work_log_id" IN (35860, 35859, 35858, 35857, 35856, 35855, 35854)

[+] Explain
17:27:31.0471.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_work_log_verify_rels" WHERE "work_log_id" IN (35860, 35859, 35858, 35857, 35856, 35855, 35854) ORDER BY "id"

[+] Explain
17:27:31.0490.3 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
17:27:31.0490.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)

[+] Explain
17:27:31.05021.5 msSELECTSELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=19) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id" IN (35860, 35859, 35858, 35857, 35856, 35855, 35854)) GROUP BY "object_id"

[+] Explain
17:27:31.0723.2 msSELECTSELECT "work_log_id", sum(amount) as count FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (0, 1, 2, 3)) AND ("work_log_id" IN (35860, 35859, 35858, 35857, 35856, 35855, 35854)) GROUP BY "work_log_id"

[+] Explain
17:27:31.0794.8 msSELECTSELECT "id" FROM "a57be577deb434"."tbl_clients" WHERE ("sales_rep" IN (1001, 5049, 5500, 5301, 5499, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))

[+] Explain
17:27:31.0854.9 msSELECTSELECT "id" FROM "a57be577deb434"."tbl_clients" WHERE ("sales_rep" IN (1001, 5049, 5500, 5301, 5499, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))

[+] Explain
17:27:31.0915.0 msSELECTSELECT "id" FROM "a57be577deb434"."tbl_clients" WHERE ("sales_rep" IN (1001, 5049, 5500, 5301, 5499, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))

[+] Explain
17:27:31.0974.8 msSELECTSELECT "id" FROM "a57be577deb434"."tbl_clients" WHERE ("sales_rep" IN (1001, 5049, 5500, 5301, 5499, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))

[+] Explain
17:27:31.1034.7 msSELECTSELECT "id" FROM "a57be577deb434"."tbl_clients" WHERE ("sales_rep" IN (1001, 5049, 5500, 5301, 5499, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))

[+] Explain
17:27:31.1094.6 msSELECTSELECT "id" FROM "a57be577deb434"."tbl_clients" WHERE ("sales_rep" IN (1001, 5049, 5500, 5301, 5499, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))

[+] Explain
17:27:31.1144.4 msSELECTSELECT "id" FROM "a57be577deb434"."tbl_clients" WHERE ("sales_rep" IN (1001, 5049, 5500, 5301, 5499, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))

[+] Explain
17:27:31.1223.7 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/work-log/list', '{"Filter":{"name":"end_at","sort":"ASC"},"WorkLogSearch":{"filterUser":"","has_client":"","has_project":"","status":"","is_arrive":"","description":"","period":"","filter":"approve","is_draft":""},"page":"1","web_access_token":"wDahkMIsEuHhAvKCnlYJe0vzWaI3UM9g","access_token":"lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC","posttime":"1783675650","token":"d6d07a3dedb157a540b3538bb865f852"}', '{"code":2000,"result":{"list":[{"id":35860,"client_id":12,"scenario_id":1,"scenario_option_id":72,"end_at":"2024-10-14 11:00:00","created_by":5300,"created_at":"2024-10-14 21:01:29","updated_at":"2024-10-14 21:01:29","start_at":"2024-10-14 10:00:00","description":"\u76ee\u6807\uff1a\u5e2e\u52a9\u5ba2\u6237\u89e3\u51b3\u4e9a\u7ec8\u7aef\u5165\u7f51\u63a7\u5236\uff0c\u4fdd\u969c\u8bbf\u95ee\u5b89\u5168\u548c\u4e1a\u52a1\u7a33\u5b9a\u7684\u95ee\u9898\n\u52a8\u4f5c\uff1a\u817e\u8baf\u4f1a\u8bae\uff0c\u5b89\u6392\u5382\u5546\u6280\u672f\u548c\u5ba2\u6237\u5bf9\u63a5\u9700\u6c42\uff0c\u5e2e\u52a9\u63d0\u4f9b\u89e3\u51b3\u65b9\u6848\n\u7ed3\u679c\uff1a\u8fbe\u5230\u9884\u671f\uff0c\n\u5ba2\u6237\u73b0\u72b6\uff1a\u4f7f\u7528\u601d\u79d1ISE\uff0c\u901a\u8fc7Mac\u5730\u5740\u7ed1\u5b9a\u4e9a\u7ec8\u7aef\uff0c\u8bbe\u7f6evlan\u3002\u73b0\u5728\u7684\u95ee\u9898\uff1a1\u3001ISE\u670d\u52a1\u5668\u4e0d\u591f\uff0c\u5982\u5355\u673a\u6545\u969c\uff0c\u4f1a\u9020\u6210\u4e1a\u52a1\u4e2d\u65ad\u30022\u3001\u73b0\u5728\u5347\u7ea7\u540e\u53d8\u6210\u8ba2\u9605\u5f0f\uff08\u4e4b\u524d\u4e70\u7684\u662f\u5e76\u53d1\uff0c800-1000\u5e76\u53d1\uff09\u3002\u73b0\u5728\u6539\u6210\u8ba2\u9605\u6a21\u5f0f\u540e\uff0c\u6bcf\u5e74\u7684\u6210\u672c\u6bd4\u8f83\u9ad8\u3002\n\u5ba2\u6237\u9700\u6c42\uff1a\n1\u3001\u5458\u5de5\u3001\u4e9a\u7ec8\u7aef\u3001\u8bbf\u5ba2\u5165\u7f51\u8ba4\u8bc1\u3002\uff08\u6df1\u4fe1\u670d\uff1a\u53ea\u505a\u51c6\u5165\u65c1\u6302\u5373\u53ef\uff09\u3002\n1\uff09\u5929\u6d25\u5458\u5de5\uff1a600\u4e2aPC\u6216\u8005\u7b14\u8bb0\u672c\uff0c\u4e9a\u7ec8\u7aef2000-3000\uff0c\u4e9a\u7ec8\u7aef\u7c7b\u578b\uff1a\u65e0\u7ebf\u4fe1\u53f7\u91c7\u96c6\u76d2\u3001\u6761\u7801\u67aa\u7b49\uff0c\u7c7b\u578b\u975e\u5e38\u591a\uff0c\u6682\u65f6\u65e0\u6cd5\u51c6\u786e\u7edf\u8ba1\u3002\n2\uff09\u5e38\u5dde\uff1a3000\u4e2a\u4e9a\u7ec8\u7aef\n2\u3001\u5e0c\u671b\u5c3d\u91cf\u505a\u7eaf\u8f6f\u4ea4\u4ed8\u3002\n3\u3001\u652f\u6301HA\u67b6\u6784\uff0c\u907f\u514d\u7f51\u7edc\u4e2d\u65ad\uff0c\u5f71\u54cd\u4e1a\u52a1\u3002\u6709\u53ef\u80fd\u4e00\u4e2a\u5730\u65b9\u4e70\u4e24\u53f0\uff0c\u6216\u8005\u4e24\u4e2a\u5730\u70b9\u8fdb\u884c\u4e92\u5907\u3002\u770b\u89e3\u51b3\u65b9\u6848\u7684\u6210\u672c\u60c5\u51b5\u3002\uff08\u6df1\u4fe1\u670d\u505a\u5f02\u5730\u4e92\u5907\uff0c\u9700\u8981\u4e24\u8fb9\u7684\u7ec8\u7aef\u6570\u91cf\u76f8\u540c\u6216\u8005\u76f8\u8fd1\u4e14\u7f51\u7edc\u7a33\u5b9a\uff0c\u96be\u5ea6\u6bd4\u8f83\u5927\uff0c\u672c\u5730\u4e92\u5907\u6210\u672c\u9ad8\u4e8e\u601d\u79d1\uff0c\u6b63\u5728\u5546\u8ba8\u7eaf\u8f6f\u4ea4\u4ed8\u7684\u4ef7\u683c\uff09","escort":"","is_draft":0,"location_id":"","project_id":"","location_in_id":"","location_out_id":"","status":-1,"indistance":0,"outdistance":0,"hours_spent":"01:00:00","approvesort":1,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"location":{},"scenarioOption":{"id":72,"key":72,"name":"\u6316\u6398\u5546\u673a"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","client_class":80,"logo":"","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"},"clientClass":{"id":80,"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237"},"can_visit":true},"project":{},"workLogContacts":[{"id":1022,"key":1022,"name":"\u674e\u7194\u53cb","department":"\u7535\u7b97\u5ba4","job_position":"\u5de5\u7a0b\u5e08","mobiles":[{"id":5574,"contact_id":1022,"mobile":"15311444022","mp_open_id":"oagch6STIcr4Xg3n38Njq9ZI3Kwg"}]}],"commentCount":{"object_id":35860,"comment":2},"attachmentRelationships":[],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":13043,"work_log_id":35860,"user_id":1001,"status":0,"description":"","verify_at":"","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"1\u5c0f\u65f6","read":0,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"},{"id":35859,"client_id":402,"scenario_id":1,"scenario_option_id":67,"end_at":"2024-10-14 14:00:00","created_by":5300,"created_at":"2024-10-14 20:59:54","updated_at":"2024-10-14 20:59:54","start_at":"2024-10-14 13:00:00","description":"\u76ee\u6807\uff1a\u5e2e\u52a9\u5ba2\u6237\u89e3\u51b3\u63a2\u9488\u6388\u6743\u5230\u671f\uff0c\u65e0\u6cd5\u7ee7\u7eed\u6d4b\u8bd5\u7684\u95ee\u9898\n\u52a8\u4f5c\uff1a\u7535\u8bdd\u5ba2\u6237 \uff0c\u5e2e\u52a9\u5ba2\u6237\u534f\u8c03\u5382\u5546\uff0c\u5b89\u6392\u6388\u6743\u66f4\u65b0\n\u7ed3\u679c\uff1a\u8fbe\u5230\u9884\u671f\uff0c\u5728\u6df1\u4fe1\u670d\u7cfb\u7edf\u5185\u5982\u679c\u6388\u6743\u4f7f\u7528\u5df2\u7ecf\u8d85180\u5929\uff0c\u7531\u4e8e\u7248\u672c\u66f4\u65b0\u65e0\u6cd5\u7ee7\u7eed\u7533\u8bf7\u6388\u6743\uff0c\u5df2\u8054\u7cfb\u5382\u5546\u505a\u5185\u90e8\u534f\u8c03\uff0c\u786e\u5b9a\u5982\u4f55\u89e3\u51b3\u3002","escort":"","is_draft":0,"location_id":"","project_id":3496,"location_in_id":"","location_out_id":"","status":-1,"indistance":0,"outdistance":0,"hours_spent":"01:00:00","approvesort":1,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"location":{},"scenarioOption":{"id":67,"key":67,"name":"\u5546\u673a\u63a8\u52a8"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":402,"key":402,"name":"\u5317\u4eac\u6676\u6fb3\u592a\u9633\u80fd\u5149\u4f0f\u79d1\u6280\u6709\u9650\u516c\u53f8","client_class":47,"logo":"","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237"},"can_visit":true},"project":{"id":3496,"key":3496,"name":"\u6df1\u4fe1\u670d\u6001\u52bf\u611f\u77e5-2024-G"},"workLogContacts":[{"id":5286,"key":5286,"name":"\u738b\u65ed\u6668","department":"","job_position":"","mobiles":[{"id":6074,"contact_id":5286,"mobile":"17860562122","mp_open_id":"oagch6bfKv3plroFNhNo-Plw7Ckw"}]}],"commentCount":{"object_id":35859,"comment":2},"attachmentRelationships":[],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":13042,"work_log_id":35859,"user_id":1001,"status":0,"description":"","verify_at":"","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"1\u5c0f\u65f6","read":0,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"},{"id":35858,"client_id":402,"scenario_id":1,"scenario_option_id":67,"end_at":"2024-10-14 14:00:00","created_by":5300,"created_at":"2024-10-14 20:59:43","updated_at":"2024-10-14 20:59:43","start_at":"2024-10-14 13:00:00","description":"\u76ee\u6807\uff1a\u5e2e\u52a9\u5ba2\u6237\u89e3\u51b3\u63a2\u9488\u6388\u6743\u5230\u671f\uff0c\u65e0\u6cd5\u7ee7\u7eed\u6d4b\u8bd5\u7684\u95ee\u9898\n\u52a8\u4f5c\uff1a\u7535\u8bdd\u5ba2\u6237 \uff0c\u5e2e\u52a9\u5ba2\u6237\u534f\u8c03\u5382\u5546\uff0c\u5b89\u6392\u6388\u6743\u66f4\u65b0\n\u7ed3\u679c\uff1a\u8fbe\u5230\u9884\u671f\uff0c\u5728\u6df1\u4fe1\u670d\u7cfb\u7edf\u5185\u5982\u679c\u6388\u6743\u4f7f\u7528\u5df2\u7ecf\u8d85180\u5929\uff0c\u7531\u4e8e\u7248\u672c\u66f4\u65b0\u65e0\u6cd5\u7ee7\u7eed\u7533\u8bf7\u6388\u6743\uff0c\u5df2\u8054\u7cfb\u5382\u5546\u505a\u5185\u90e8\u534f\u8c03\uff0c\u786e\u5b9a\u5982\u4f55\u89e3\u51b3\u3002","escort":"","is_draft":0,"location_id":"","project_id":3496,"location_in_id":"","location_out_id":"","status":-1,"indistance":0,"outdistance":0,"hours_spent":"01:00:00","approvesort":1,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"location":{},"scenarioOption":{"id":67,"key":67,"name":"\u5546\u673a\u63a8\u52a8"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":402,"key":402,"name":"\u5317\u4eac\u6676\u6fb3\u592a\u9633\u80fd\u5149\u4f0f\u79d1\u6280\u6709\u9650\u516c\u53f8","client_class":47,"logo":"","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237"},"can_visit":true},"project":{"id":3496,"key":3496,"name":"\u6df1\u4fe1\u670d\u6001\u52bf\u611f\u77e5-2024-G"},"workLogContacts":[{"id":5286,"key":5286,"name":"\u738b\u65ed\u6668","department":"","job_position":"","mobiles":[{"id":6074,"contact_id":5286,"mobile":"17860562122","mp_open_id":"oagch6bfKv3plroFNhNo-Plw7Ckw"}]}],"commentCount":{"object_id":35858,"comment":2},"attachmentRelationships":[],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":13041,"work_log_id":35858,"user_id":1001,"status":0,"description":"","verify_at":"","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"1\u5c0f\u65f6","read":0,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"},{"id":35857,"client_id":402,"scenario_id":1,"scenario_option_id":67,"end_at":"2024-10-14 14:00:00","created_by":5300,"created_at":"2024-10-14 20:59:40","updated_at":"2024-10-14 20:59:40","start_at":"2024-10-14 13:00:00","description":"\u76ee\u6807\uff1a\u5e2e\u52a9\u5ba2\u6237\u89e3\u51b3\u63a2\u9488\u6388\u6743\u5230\u671f\uff0c\u65e0\u6cd5\u7ee7\u7eed\u6d4b\u8bd5\u7684\u95ee\u9898\n\u52a8\u4f5c\uff1a\u7535\u8bdd\u5ba2\u6237 \uff0c\u5e2e\u52a9\u5ba2\u6237\u534f\u8c03\u5382\u5546\uff0c\u5b89\u6392\u6388\u6743\u66f4\u65b0\n\u7ed3\u679c\uff1a\u8fbe\u5230\u9884\u671f\uff0c\u5728\u6df1\u4fe1\u670d\u7cfb\u7edf\u5185\u5982\u679c\u6388\u6743\u4f7f\u7528\u5df2\u7ecf\u8d85180\u5929\uff0c\u7531\u4e8e\u7248\u672c\u66f4\u65b0\u65e0\u6cd5\u7ee7\u7eed\u7533\u8bf7\u6388\u6743\uff0c\u5df2\u8054\u7cfb\u5382\u5546\u505a\u5185\u90e8\u534f\u8c03\uff0c\u786e\u5b9a\u5982\u4f55\u89e3\u51b3\u3002","escort":"","is_draft":0,"location_id":"","project_id":3496,"location_in_id":"","location_out_id":"","status":-1,"indistance":0,"outdistance":0,"hours_spent":"01:00:00","approvesort":1,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"location":{},"scenarioOption":{"id":67,"key":67,"name":"\u5546\u673a\u63a8\u52a8"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":402,"key":402,"name":"\u5317\u4eac\u6676\u6fb3\u592a\u9633\u80fd\u5149\u4f0f\u79d1\u6280\u6709\u9650\u516c\u53f8","client_class":47,"logo":"","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237"},"can_visit":true},"project":{"id":3496,"key":3496,"name":"\u6df1\u4fe1\u670d\u6001\u52bf\u611f\u77e5-2024-G"},"workLogContacts":[{"id":5286,"key":5286,"name":"\u738b\u65ed\u6668","department":"","job_position":"","mobiles":[{"id":6074,"contact_id":5286,"mobile":"17860562122","mp_open_id":"oagch6bfKv3plroFNhNo-Plw7Ckw"}]}],"commentCount":{"object_id":35857,"comment":2},"attachmentRelationships":[],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":13040,"work_log_id":35857,"user_id":1001,"status":0,"description":"","verify_at":"","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"1\u5c0f\u65f6","read":0,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"},{"id":35856,"client_id":402,"scenario_id":1,"scenario_option_id":67,"end_at":"2024-10-14 14:00:00","created_by":5300,"created_at":"2024-10-14 20:59:36","updated_at":"2024-10-14 20:59:36","start_at":"2024-10-14 13:00:00","description":"\u76ee\u6807\uff1a\u5e2e\u52a9\u5ba2\u6237\u89e3\u51b3\u63a2\u9488\u6388\u6743\u5230\u671f\uff0c\u65e0\u6cd5\u7ee7\u7eed\u6d4b\u8bd5\u7684\u95ee\u9898\n\u52a8\u4f5c\uff1a\u7535\u8bdd\u5ba2\u6237 \uff0c\u5e2e\u52a9\u5ba2\u6237\u534f\u8c03\u5382\u5546\uff0c\u5b89\u6392\u6388\u6743\u66f4\u65b0\n\u7ed3\u679c\uff1a\u8fbe\u5230\u9884\u671f\uff0c\u5728\u6df1\u4fe1\u670d\u7cfb\u7edf\u5185\u5982\u679c\u6388\u6743\u4f7f\u7528\u5df2\u7ecf\u8d85180\u5929\uff0c\u7531\u4e8e\u7248\u672c\u66f4\u65b0\u65e0\u6cd5\u7ee7\u7eed\u7533\u8bf7\u6388\u6743\uff0c\u5df2\u8054\u7cfb\u5382\u5546\u505a\u5185\u90e8\u534f\u8c03\uff0c\u786e\u5b9a\u5982\u4f55\u89e3\u51b3\u3002","escort":"","is_draft":0,"location_id":"","project_id":3496,"location_in_id":"","location_out_id":"","status":-1,"indistance":0,"outdistance":0,"hours_spent":"01:00:00","approvesort":1,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"location":{},"scenarioOption":{"id":67,"key":67,"name":"\u5546\u673a\u63a8\u52a8"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":402,"key":402,"name":"\u5317\u4eac\u6676\u6fb3\u592a\u9633\u80fd\u5149\u4f0f\u79d1\u6280\u6709\u9650\u516c\u53f8","client_class":47,"logo":"","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237"},"can_visit":true},"project":{"id":3496,"key":3496,"name":"\u6df1\u4fe1\u670d\u6001\u52bf\u611f\u77e5-2024-G"},"workLogContacts":[{"id":5286,"key":5286,"name":"\u738b\u65ed\u6668","department":"","job_position":"","mobiles":[{"id":6074,"contact_id":5286,"mobile":"17860562122","mp_open_id":"oagch6bfKv3plroFNhNo-Plw7Ckw"}]}],"commentCount":{"object_id":35856,"comment":2},"attachmentRelationships":[],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":13039,"work_log_id":35856,"user_id":1001,"status":0,"description":"","verify_at":"","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"1\u5c0f\u65f6","read":0,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"},{"id":35855,"client_id":18,"scenario_id":1,"scenario_option_id":72,"end_at":"2024-10-14 16:00:00","created_by":5300,"created_at":"2024-10-14 20:59:03","updated_at":"2024-10-14 20:59:03","start_at":"2024-10-14 15:00:00","description":"\u76ee\u6807\uff1a\u5e2e\u52a9\u5ba2\u6237\u63d0\u4f9b\u6709\u6548\u7684\u52d2\u7d22\u75c5\u6bd2\u89e3\u51b3\u65b9\u6848\n\u52a8\u4f5c\uff1a\u7535\u8bdd\u5ba2\u6237\uff0c\u7ea6\u5ba2\u6237\u65f6\u95f4\u5b89\u6392\u65b9\u6848\u4ea4\u6d41\n\u7ed3\u679c\uff1a\u8fbe\u5230\u9884\u671f\uff0c\u672c\u5468\u516c\u53f8\u6709\u68c0\u67e5\uff0c\u5b89\u6392\u5728\u4e0b\u5468\u505a\u4ea4\u6d41\u3002","escort":"","is_draft":0,"location_id":"","project_id":"","location_in_id":"","location_out_id":"","status":-1,"indistance":0,"outdistance":0,"hours_spent":"01:00:00","approvesort":1,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"location":{},"scenarioOption":{"id":72,"key":72,"name":"\u6316\u6398\u5546\u673a"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":18,"key":18,"name":"\u4e2d\u5fb7\u8bc1\u5238\u6709\u9650\u8d23\u4efb\u516c\u53f8","client_class":43,"logo":"","sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"can_visit":true},"project":{},"workLogContacts":[{"id":24,"key":24,"name":"\u90b1\u91d1\u731b","department":"IT\u8fd0\u7ef4\u90e8","job_position":"\u7ecf\u7406","mobiles":[{"id":31,"contact_id":24,"mobile":"18910071652","mp_open_id":""}]}],"commentCount":{"object_id":35855,"comment":2},"attachmentRelationships":[],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":13038,"work_log_id":35855,"user_id":1001,"status":0,"description":"","verify_at":"","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"1\u5c0f\u65f6","read":0,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"},{"id":35854,"client_id":530,"scenario_id":1,"scenario_option_id":67,"end_at":"2024-10-14 17:00:00","created_by":5300,"created_at":"2024-10-14 20:58:25","updated_at":"2024-10-14 20:58:25","start_at":"2024-10-14 16:00:00","description":"\u76ee\u6807\uff1a\u8ddf\u5ba2\u6237\u6c9f\u901a\u4e24\u5e74\u7684\u4ef7\u683c\uff0c\u5e2e\u52a9\u5ba2\u6237\u63a7\u5236\u91c7\u8d2d\u6210\u672c\n\u52a8\u4f5c\uff1a\u7535\u8bdd\u5ba2\u6237\uff0c\u8ddf\u5ba2\u6237\u6c9f\u901a\u4e24\u5e74\u4e0b\u5355\u7684\u4ed8\u6b3e\u65b9\u5f0f\n\u7ed3\u679c\uff1a\u8fbe\u5230\u9884\u671f\u3002\u8ddf\u5ba2\u6237\u6c9f\u901a\u5982\u679c\u4e0b\u5355\u4e24\u5e74\uff0c\u9700\u8981\u4e00\u6b21\u6027\u4ed8\u6b3e\u4e24\u5e74\u7684\u8d39\u7528\uff0c\u65e0\u6cd5\u7b7e\u8ba2\u4e24\u5e74\u7684\u5408\u540c\uff0c\u9010\u5e74\u6536\u8d39\uff0c\u6211\u4eec\u9700\u8981\u4e00\u6b21\u6027\u548c\u5382\u5546\u4e0b\u5355\u4e24\u5e74\u65b9\u53ef\u4eab\u53d7\u4eca\u5e74\u7684\u4ef7\u683c\uff0c\u7b49\u5f85\u5ba2\u6237\u53cd\u9988\u3002","escort":"","is_draft":0,"location_id":"","project_id":3673,"location_in_id":"","location_out_id":"","status":-1,"indistance":0,"outdistance":0,"hours_spent":"01:00:00","approvesort":1,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"location":{},"scenarioOption":{"id":67,"key":67,"name":"\u5546\u673a\u63a8\u52a8"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":530,"key":530,"name":"\u54c8\u7f57\u56fd\u9645\u5b66\u6821(\u5317\u4eac\u5e02\u671d\u9633\u533a\u793c\u5fb7\u5b66\u6821)","client_class":43,"logo":"","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"can_visit":true},"project":{"id":3673,"key":3673,"name":"PA3220\u7eed\u4fdd1\u5e74-G-2024"},"workLogContacts":[{"id":5248,"key":5248,"name":"Alice","department":"\u91c7\u8d2d","job_position":"","mobiles":[{"id":6036,"contact_id":5248,"mobile":"15618229663","mp_open_id":""}]}],"commentCount":{"object_id":35854,"comment":2},"attachmentRelationships":[],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[{"id":13037,"work_log_id":35854,"user_id":1001,"status":0,"description":"","verify_at":"","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"unreadComments":{},"reimbursementCount":{},"hours_spent_display":"1\u5c0f\u65f6","read":0,"total":1,"can_update":true,"can_delete":true,"can_create_reimbursement":false,"can_create_project":true,"bgcolor":"#89c541"}],"can_create":true,"pagenation":{"totalcount":7,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"124.232.142.234","ua":"Mozilla\/5.0 (compatible; Andy\/get-log; +http:\/\/jinchangxiao.com)"}', FALSE, '2026-07-10 17:27:31', 320379904) RETURNING "id"

[+] Explain