ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a57438ded9a7: POST https://beta.jinchangxiao.com/v2/work-log/list at 2026-07-15 04:23:41 pm by 39.156.194.178

Performance Profiling

Total processing time: 117 ms; Peak memory: 5.336 MB. Show Profiling Timeline

总计28条数据
TimeDurationCategoryInfo
  
16:23:42.01219.5 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=19) AND ("object_id" IN (8712, 8711, 8710, 8707, 8704, 8701, 8700, 8699, 8696, 8691)) GROUP BY "object_id"
16:23:42.04317.8 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=19) AND (remind_user_id = 1015 AND is_read = false) AND ("object_id" IN (8712, 8711, 8710, 8707, 8704, 8701, 8700, 8699, 8696, 8691)) GROUP BY "object_id"
16:23:41.9877.6 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT s.*, s.end_at - s.start_at AS hours_spent 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_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 WHERE (("s"."created_by" IN (1015, 1015, 1022, 1023, 5248)) OR ("ccr"."user_id"=1015)) AND ("s"."created_by"='1015') AND ("u"."department_id"='2') GROUP BY "s"."id" ORDER BY "is_draft" DESC, "s"."end_at" DESC, "s"."updated_at" DESC) "c"
16:23:41.9957.4 msyii\db\Command::querySELECT s.*, s.end_at - s.start_at AS hours_spent 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_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 WHERE (("s"."created_by" IN (1015, 1015, 1022, 1023, 5248)) OR ("ccr"."user_id"=1015)) AND ("s"."created_by"='1015') AND ("u"."department_id"='2') GROUP BY "s"."id" ORDER BY "is_draft" DESC, "s"."end_at" DESC, "s"."updated_at" DESC LIMIT 10 OFFSET 30
16:23:42.0084.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_log_contacts" WHERE "work_log_id" IN (8712, 8711, 8710, 8707, 8704, 8701, 8700, 8699, 8696, 8691)
16:23:42.0783.3 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_clients" WHERE ("sales_rep" IN (5500, 5301, 5499, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5096, 5448, 5420, 1001, 5087, 1008, 5230, 5088, 5208, 1003, 5467, 5294, 5357, 5076, 5300, 5089, 5311, 5364, 5295, 1013, 5128, 5203, 5476, 1004, 5072, 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"=1015))
16:23:42.0323.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=18) AND ("object_id" IN (8712, 8711, 8710, 8707, 8704, 8701, 8700, 8699, 8696, 8691))
16:23:42.0363.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=101) AND ("object_id" IN (8712, 8711, 8710, 8707, 8704, 8701, 8700, 8699, 8696, 8691))
16:23:42.0683.1 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_clients" WHERE ("sales_rep" IN (5500, 5301, 5499, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5096, 5448, 5420, 1001, 5087, 1008, 5230, 5088, 5208, 1003, 5467, 5294, 5357, 5076, 5300, 5089, 5311, 5364, 5295, 1013, 5128, 5203, 5476, 1004, 5072, 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"=1015))
16:23:42.0713.0 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_clients" WHERE ("sales_rep" IN (5500, 5301, 5499, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5096, 5448, 5420, 1001, 5087, 1008, 5230, 5088, 5208, 1003, 5467, 5294, 5357, 5076, 5300, 5089, 5311, 5364, 5295, 1013, 5128, 5203, 5476, 1004, 5072, 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"=1015))
16:23:42.0753.0 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_clients" WHERE ("sales_rep" IN (5500, 5301, 5499, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5096, 5448, 5420, 1001, 5087, 1008, 5230, 5088, 5208, 1003, 5467, 5294, 5357, 5076, 5300, 5089, 5311, 5364, 5295, 1013, 5128, 5203, 5476, 1004, 5072, 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"=1015))
16:23:42.0612.7 msyii\db\Command::querySELECT "work_log_id", sum(amount) as count FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (0, 1, 2, 3)) AND ("work_log_id" IN (8712, 8711, 8710, 8707, 8704, 8701, 8700, 8699, 8696, 8691)) GROUP BY "work_log_id"
16:23:42.0642.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (0, 1, 2, 3)) AND ("work_log_id" IN (8712, 8711, 8710, 8707, 8704, 8701, 8700, 8699, 8696, 8691))
16:23:42.0842.4 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', 1015, 0, 276, 'v2/work-log/list', '{"access_token":"Q_7DD5LA0njCol9o5skCibRkap3ZqeYZ","device_type":"0","version_code":"276","WorkLogSearch":{"scenario_option_id":"","scenario_id":"","filterUser":"1015","status":"","filterDepartment":"2"},"page":"4","token":"758f83c73e174a9d22e6b928010c274a","posttime":"1784103821","pagesize":"10"}', '{"code":200,"data":{"list":[{"id":8712,"client_id":null,"scenario_id":2,"scenario_option_id":16,"end_at":"2017-12-12 15:00:00","created_by":1015,"created_at":"2017-12-13 09:20:33","updated_at":"","start_at":"2017-12-12 14:00:00","description":"\u96f6\u6563\u6280\u672f\u652f\u6301","escort":"","is_draft":0,"location_id":null,"project_id":null,"location_in_id":null,"location_out_id":null,"status":0,"indistance":999999999,"outdistance":999999999,"hours_spent":"01:00:00","createdBy":{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","department_id":2,"avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"location":null,"scenarioOption":{"id":16,"key":16,"name":"\u62a5\u544a\/\u65b9\u6848\u7f16\u5199"},"scenarios":{"id":2,"key":2,"name":"\u5de5\u7a0b\u5e08\u65e5\u5fd7"},"client":null,"project":null,"workLogContacts":[],"commentCount":null,"attachmentRelationships":[],"locationIn":null,"locationOut":null,"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":null,"reimbursementCount":null,"reimbursements":[],"hours_spent_display":"1\u5c0f\u65f6","read":0,"total":0,"can_update":true,"can_delete":false,"can_create_reimbursement":true,"can_create_project":false,"can_location_in":false,"can_location_out":false},{"id":8711,"client_id":null,"scenario_id":2,"scenario_option_id":20,"end_at":"2017-12-12 12:30:00","created_by":1015,"created_at":"2017-12-13 09:19:56","updated_at":"","start_at":"2017-12-12 09:00:00","description":"\u9605\u8bfb\u96f6\u552e\u884c\u4e1a\u4fe1\u606f\u5316\u53d1\u5c55\u8d8b\u52bf","escort":"","is_draft":0,"location_id":null,"project_id":null,"location_in_id":null,"location_out_id":null,"status":0,"indistance":999999999,"outdistance":999999999,"hours_spent":"03:30:00","createdBy":{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","department_id":2,"avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"location":null,"scenarioOption":{"id":20,"key":20,"name":"\u516c\u53f8\u5185\u9605\u8bfb\u8d44\u6599"},"scenarios":{"id":2,"key":2,"name":"\u5de5\u7a0b\u5e08\u65e5\u5fd7"},"client":null,"project":null,"workLogContacts":[],"commentCount":null,"attachmentRelationships":[],"locationIn":null,"locationOut":null,"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":null,"reimbursementCount":null,"reimbursements":[],"hours_spent_display":"3\u5c0f\u65f630\u5206\u949f","read":0,"total":0,"can_update":true,"can_delete":false,"can_create_reimbursement":true,"can_create_project":false,"can_location_in":false,"can_location_out":false},{"id":8710,"client_id":null,"scenario_id":2,"scenario_option_id":19,"end_at":"2017-12-11 12:00:00","created_by":1015,"created_at":"2017-12-13 09:18:05","updated_at":"","start_at":"2017-12-11 09:00:00","description":"\u8de8\u90e8\u95e8\u4f1a\u8bae\u3001\u6280\u672f\u90e8\u4f8b\u4f1a","escort":"","is_draft":0,"location_id":null,"project_id":null,"location_in_id":null,"location_out_id":null,"status":0,"indistance":999999999,"outdistance":999999999,"hours_spent":"03:00:00","createdBy":{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","department_id":2,"avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"location":null,"scenarioOption":{"id":19,"key":19,"name":"\u516c\u53f8\u5185\u90e8\u4f1a\u8bae"},"scenarios":{"id":2,"key":2,"name":"\u5de5\u7a0b\u5e08\u65e5\u5fd7"},"client":null,"project":null,"workLogContacts":[],"commentCount":null,"attachmentRelationships":[],"locationIn":null,"locationOut":null,"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":null,"reimbursementCount":null,"reimbursements":[],"hours_spent_display":"3\u5c0f\u65f6","read":0,"total":0,"can_update":true,"can_delete":false,"can_create_reimbursement":true,"can_create_project":false,"can_location_in":false,"can_location_out":false},{"id":8707,"client_id":592,"scenario_id":2,"scenario_option_id":16,"end_at":"2017-12-08 11:00:00","created_by":1015,"created_at":"2017-12-08 11:21:54","updated_at":"","start_at":"2017-12-08 09:30:00","description":"\u4eac\u6c49\u5927\u53a6\u65b9\u6848\u914d\u7f6e\u7f16\u5199","escort":"","is_draft":0,"location_id":null,"project_id":null,"location_in_id":null,"location_out_id":null,"status":0,"indistance":999999999,"outdistance":999999999,"hours_spent":"01:30:00","createdBy":{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","department_id":2,"avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"location":null,"scenarioOption":{"id":16,"key":16,"name":"\u62a5\u544a\/\u65b9\u6848\u7f16\u5199"},"scenarios":{"id":2,"key":2,"name":"\u5de5\u7a0b\u5e08\u65e5\u5fd7"},"client":{"id":592,"key":592,"name":"\u4eac\u6c49\u7f6e\u4e1a\u96c6\u56e2\u6709\u9650\u8d23\u4efb\u516c\u53f8-\u5220\u9664","client_class":1,"logo":null,"sales_rep":null,"salesRep":null,"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237"},"can_visit":true},"project":null,"workLogContacts":[],"commentCount":null,"attachmentRelationships":[],"locationIn":null,"locationOut":null,"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":null,"reimbursementCount":null,"reimbursements":[],"hours_spent_display":"1\u5c0f\u65f630\u5206\u949f","read":0,"total":0,"can_update":true,"can_delete":false,"can_create_reimbursement":true,"can_create_project":false,"can_location_in":false,"can_location_out":false},{"id":8704,"client_id":null,"scenario_id":2,"scenario_option_id":16,"end_at":"2017-12-07 11:45:00","created_by":1015,"created_at":"2017-12-07 12:19:20","updated_at":"","start_at":"2017-12-07 09:00:00","description":"31\u6240EMC UNITY\u4ea7\u54c1\u5bf9\u6bd4\u8868\u7f16\u5199\uff1bA10\u5382\u5546\u6e20\u9053\u63a5\u89e6","escort":"","is_draft":0,"location_id":null,"project_id":null,"location_in_id":null,"location_out_id":null,"status":0,"indistance":999999999,"outdistance":999999999,"hours_spent":"02:45:00","createdBy":{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","department_id":2,"avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"location":null,"scenarioOption":{"id":16,"key":16,"name":"\u62a5\u544a\/\u65b9\u6848\u7f16\u5199"},"scenarios":{"id":2,"key":2,"name":"\u5de5\u7a0b\u5e08\u65e5\u5fd7"},"client":null,"project":null,"workLogContacts":[],"commentCount":null,"attachmentRelationships":[],"locationIn":null,"locationOut":null,"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":null,"reimbursementCount":null,"reimbursements":[],"hours_spent_display":"2\u5c0f\u65f645\u5206\u949f","read":0,"total":0,"can_update":true,"can_delete":false,"can_create_reimbursement":true,"can_create_project":false,"can_location_in":false,"can_location_out":false},{"id":8701,"client_id":5,"scenario_id":2,"scenario_option_id":16,"end_at":"2017-12-06 16:00:00","created_by":1015,"created_at":"2017-12-06 17:17:28","updated_at":"","start_at":"2017-12-06 14:00:00","description":"\u666e\u5929\u592a\u529b\u5b58\u50a8NFS\u534f\u8bae\u8bbf\u95ee\u6539\u9020\u65b9\u6848\u6c9f\u901a","escort":"","is_draft":0,"location_id":null,"project_id":null,"location_in_id":null,"location_out_id":null,"status":0,"indistance":999999999,"outdistance":999999999,"hours_spent":"02:00:00","createdBy":{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","department_id":2,"avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"location":null,"scenarioOption":{"id":16,"key":16,"name":"\u62a5\u544a\/\u65b9\u6848\u7f16\u5199"},"scenarios":{"id":2,"key":2,"name":"\u5de5\u7a0b\u5e08\u65e5\u5fd7"},"client":{"id":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8","client_class":47,"logo":null,"sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237"},"can_visit":true},"project":null,"workLogContacts":[],"commentCount":null,"attachmentRelationships":[],"locationIn":null,"locationOut":null,"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":null,"reimbursementCount":null,"reimbursements":[],"hours_spent_display":"2\u5c0f\u65f6","read":0,"total":0,"can_update":true,"can_delete":false,"can_create_reimbursement":true,"can_create_project":false,"can_location_in":false,"can_location_out":false},{"id":8700,"client_id":549,"scenario_id":2,"scenario_option_id":16,"end_at":"2017-12-06 10:30:00","created_by":1015,"created_at":"2017-12-06 17:14:52","updated_at":"2017-12-06 17:15:34","start_at":"2017-12-06 09:00:00","description":"\u534e\u5174Veeam\u5907\u4efd\u548c\u5bb9\u707e\u65b9\u6848\u7f16\u5199","escort":"","is_draft":0,"location_id":null,"project_id":null,"location_in_id":null,"location_out_id":null,"status":0,"indistance":999999999,"outdistance":999999999,"hours_spent":"01:30:00","createdBy":{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","department_id":2,"avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"location":null,"scenarioOption":{"id":16,"key":16,"name":"\u62a5\u544a\/\u65b9\u6848\u7f16\u5199"},"scenarios":{"id":2,"key":2,"name":"\u5de5\u7a0b\u5e08\u65e5\u5fd7"},"client":{"id":549,"key":549,"name":"\u534e\u5174\u8d44\u672c","client_class":null,"logo":null,"sales_rep":null,"salesRep":null,"clientClass":null,"can_visit":true},"project":null,"workLogContacts":[],"commentCount":null,"attachmentRelationships":[],"locationIn":null,"locationOut":null,"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":null,"reimbursementCount":null,"reimbursements":[],"hours_spent_display":"1\u5c0f\u65f630\u5206\u949f","read":0,"total":0,"can_update":true,"can_delete":false,"can_create_reimbursement":true,"can_create_project":false,"can_location_in":false,"can_location_out":false},{"id":8699,"client_id":null,"scenario_id":2,"scenario_option_id":24,"end_at":"2017-12-05 17:00:00","created_by":1015,"created_at":"2017-12-06 10:08:34","updated_at":"","start_at":"2017-12-05 09:00:00","description":"\u53c2\u52a0\u4e2d\u56fd\u5b58\u50a8\u5cf0\u4f1a","escort":"","is_draft":0,"location_id":null,"project_id":null,"location_in_id":null,"location_out_id":null,"status":0,"indistance":999999999,"outdistance":999999999,"hours_spent":"08:00:00","createdBy":{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","department_id":2,"avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"location":null,"scenarioOption":{"id":24,"key":24,"name":"\u516c\u53f8\u5916\u90e8\u57f9\u8bad"},"scenarios":{"id":2,"key":2,"name":"\u5de5\u7a0b\u5e08\u65e5\u5fd7"},"client":null,"project":null,"workLogContacts":[],"commentCount":null,"attachmentRelationships":[],"locationIn":null,"locationOut":null,"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":null,"reimbursementCount":null,"reimbursements":[],"hours_spent_display":"8\u5c0f\u65f6","read":0,"total":0,"can_update":true,"can_delete":false,"can_create_reimbursement":true,"can_create_project":false,"can_location_in":false,"can_location_out":false},{"id":8696,"client_id":549,"scenario_id":2,"scenario_option_id":25,"end_at":"2017-12-04 16:45:00","created_by":1015,"created_at":"2017-12-04 22:21:23","updated_at":"","start_at":"2017-12-04 14:30:00","description":"\u534e\u5174\u8d44\u672cVeeam \u5907\u4efd\u65b9\u6848\u7f16\u5199","escort":"","is_draft":0,"location_id":null,"project_id":null,"location_in_id":null,"location_out_id":null,"status":0,"indistance":999999999,"outdistance":999999999,"hours_spent":"02:15:00","createdBy":{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","department_id":2,"avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"location":null,"scenarioOption":{"id":25,"key":25,"name":"\u516c\u53f8\u5185\u505a\u5b9e\u9a8c"},"scenarios":{"id":2,"key":2,"name":"\u5de5\u7a0b\u5e08\u65e5\u5fd7"},"client":{"id":549,"key":549,"name":"\u534e\u5174\u8d44\u672c","client_class":null,"logo":null,"sales_rep":null,"salesRep":null,"clientClass":null,"can_visit":true},"project":null,"workLogContacts":[],"commentCount":null,"attachmentRelationships":[],"locationIn":null,"locationOut":null,"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":null,"reimbursementCount":null,"reimbursements":[],"hours_spent_display":"2\u5c0f\u65f615\u5206\u949f","read":0,"total":0,"can_update":true,"can_delete":false,"can_create_reimbursement":true,"can_create_project":false,"can_location_in":false,"can_location_out":false},{"id":8691,"client_id":null,"scenario_id":2,"scenario_option_id":19,"end_at":"2017-12-04 12:00:00","created_by":1015,"created_at":"2017-12-04 12:17:30","updated_at":"2017-12-04 12:17:30","start_at":"2017-12-04 09:00:00","description":"\u8de8\u90e8\u95e8\u4f1a\u8bae\uff0c\u6280\u672f\u90e8\u4f8b\u4f1a\n","escort":"","is_draft":0,"location_id":null,"project_id":null,"location_in_id":null,"location_out_id":null,"status":0,"indistance":999999999,"outdistance":999999999,"hours_spent":"03:00:00","createdBy":{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","department_id":2,"avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"location":null,"scenarioOption":{"id":19,"key":19,"name":"\u516c\u53f8\u5185\u90e8\u4f1a\u8bae"},"scenarios":{"id":2,"key":2,"name":"\u5de5\u7a0b\u5e08\u65e5\u5fd7"},"client":null,"project":null,"workLogContacts":[],"commentCount":null,"attachmentRelationships":[],"locationIn":null,"locationOut":null,"files":[],"workLogCarbonCopyRels":[],"workLogVerifyRels":[],"unreadComments":null,"reimbursementCount":null,"reimbursements":[],"hours_spent_display":"3\u5c0f\u65f6","read":0,"total":0,"can_update":true,"can_delete":false,"can_create_reimbursement":true,"can_create_project":false,"can_location_in":false,"can_location_out":false}],"pagenation":{"totalcount":185,"thispage":4,"pagesize":10},"can_create":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"39.156.194.178","ua":"jinchangxiao\/2.3.176 (HUAWEIVOG-AL00; Android 10)"}', FALSE, '2026-07-15 16:23:42', 110307072) RETURNING "id"
16:23:42.0391.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_log_carbon_copy_rels" WHERE "work_log_id" IN (8712, 8711, 8710, 8707, 8704, 8701, 8700, 8699, 8696, 8691)
16:23:42.0411.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_log_verify_rels" WHERE "work_log_id" IN (8712, 8711, 8710, 8707, 8704, 8701, 8700, 8699, 8696, 8691) ORDER BY "id"
16:23:41.9860.7 msyii\db\Command::querySELECT "s"."accessible_user" FROM "a57be577deb434"."tbl_visible_work_logs" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.accessible_user WHERE ("s"."user_id"=1015) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."id"
16:23:41.9770.7 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='Q_7DD5LA0njCol9o5skCibRkap3ZqeYZ'
16:23:41.9790.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1015
16:23:42.0040.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1015
16:23:42.0050.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1015)
16:23:42.0070.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "client_class", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (592, 5, 549)
16:23:42.0070.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1004
16:23:42.0060.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_work_log_scenario_options" WHERE "id" IN (16, 20, 19, 24, 25)
16:23:41.9770.2 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:23:42.0050.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=2
16:23:42.0080.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_classes" WHERE "id" IN (47, 1)
16:23:42.0060.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_work_log_scenarios" WHERE "id"=2