ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a57331b2bb40: POST https://beta.jinchangxiao.com/v2/search/work-log-by-self at 2026-07-15 03:13:31 pm by 223.104.40.7

Performance Profiling

Total processing time: 83 ms; Peak memory: 4.606 MB. Show Profiling Timeline

总计27条数据
TimeDurationCategoryInfo
  
15:13:31.20419.1 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=19) AND ("object_id" IN (39158, 39157, 20700)) GROUP BY "object_id"
15:13:31.23517.4 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=19) AND (remind_user_id = 1000 AND is_read = false) AND ("object_id" IN (39158, 39157, 20700)) GROUP BY "object_id"
15:13:31.1874.7 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 ("is_draft"=FALSE) AND ("s"."created_by"=1000) AND ("s"."client_id"='982') AND ("s"."project_id"='1111') GROUP BY "s"."id" ORDER BY "is_draft" DESC, "s"."end_at" DESC, "s"."updated_at" DESC) "c"
15:13:31.2243.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=18) AND ("object_id" IN (39158, 39157, 20700))
15:13:31.2003.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_log_contacts" WHERE "work_log_id" IN (39158, 39157, 20700)
15:13:31.2292.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=101) AND ("object_id" IN (39158, 39157, 20700))
15:13:31.1922.9 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 ("is_draft"=FALSE) AND ("s"."created_by"=1000) AND ("s"."client_id"='982') AND ("s"."project_id"='1111') GROUP BY "s"."id" ORDER BY "is_draft" DESC, "s"."end_at" DESC, "s"."updated_at" DESC LIMIT 20
15:13:31.2571.9 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, 2, 1161, 'v2/search/work-log-by-self', '{"access_token":"wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm","client_id":"982","device_type":"2","posttime":"1784099584","project_id":"1111","token":"77eef444fb9b166cfb3d937a3eaed0d6","version_code":"1161"}', '{"code":200,"data":{"list":[{"id":39158,"client_id":982,"scenario_id":1,"scenario_option_id":73,"end_at":"2026-04-30 11:38:00","created_by":1000,"created_at":"2026-04-30 11:37:20","updated_at":"2026-04-30 11:38:20","start_at":"2026-04-30 11:36:00","description":"\u8fd9\u4e2a\u63d0\u5347\u65e5\u8fd9\u4e5f\u3002","escort":"\u6ca1\u6709\uff0c\u4f60\u89c9\u5f97\u5f00\u901a\u4e0d\uff0c\u90a3\u662f\u5408\u5e76\uff0c\u597d\u50cf\u662f\u6ca1\u6709\u7684\uff0c\u5c31\u662f\u6837\u3002","is_draft":false,"location_id":"","project_id":1111,"location_in_id":21275,"location_out_id":21276,"status":0,"indistance":17512,"outdistance":17520,"hours_spent":"00:02:00","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"location":{},"scenarioOption":{"id":73,"key":73,"name":"\u552e\u540e\u670d\u52a1"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","client_class":1,"logo":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237"}},"project":{"id":1111,"key":1111,"name":"\u4ebf\u8054\u89c6\u9891\u4f1a\u8bae\u7edf\u4e00\u901a\u8baf"},"workLogContacts":[{"id":3837,"key":3837,"name":"\u5218\u6d77\u9759"}],"commentCount":{"object_id":39158,"comment":5},"attachmentRelationships":[{"id":57606,"object_type":18,"object_id":39158,"attachment_id":32657,"attachment":{"id":32657,"key":32657,"name":"8a2772f3-5d70-34e2-a010-1ead2cc306b9","extension":"png","path":"\/vue\/attachment\/view?name=8a2772f3-5d70-34e2-a010-1ead2cc306b9"}}],"locationIn":{"id":21275,"lng":"116.297969835069","lat":"39.8291663953993","address":"\u5317\u4eac\u5e02\u4e30\u53f0\u533a\u5357\u56db\u73af\u897f\u8def\u9760\u8fd1\u5317\u4eac\u8bfa\u5fb7\u4e2d\u5fc3\u4e00\u671f","time":"2026-04-30 11:36:00"},"locationOut":{"id":21276,"lng":"116.297979871962","lat":"39.8290828450521","address":"\u5317\u4eac\u5e02\u4e30\u53f0\u533a\u5357\u56db\u73af\u897f\u8def\u9760\u8fd1\u5317\u4eac\u8bfa\u5fb7\u4e2d\u5fc3\u4e00\u671f","time":"2026-04-30 11:38:00"},"files":[],"workLogCarbonCopyRels":[],"unreadComments":{},"hours_spent_display":"2\u5206\u949f","can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":39157,"client_id":982,"scenario_id":1,"scenario_option_id":72,"end_at":"2026-04-23 14:00:00","created_by":1000,"created_at":"2026-04-23 21:17:28","updated_at":"2026-04-23 21:17:53","start_at":"2026-04-23 12:00:00","description":"\u65b0\u5efa\u5de5\u4f5c\u65e5\u5fd7\u3002\u4eca\u5929\u6211\u53bb\u62dc\u8bbf\u4e86\u4e00\u4e2a\u5ba2\u6237\u3002","escort":"\u966a\u540c\u4eba\u5458\u662f\u9ad8\u4fca\u9633\u3002\u7f16\u8f91\u5de5\u4f5c\u65e5\u5fd7\u3002","is_draft":false,"location_id":"","project_id":1111,"location_in_id":"","location_out_id":"","status":0,"indistance":0,"outdistance":0,"hours_spent":"02:00:00","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"location":{},"scenarioOption":{"id":72,"key":72,"name":"\u6316\u6398\u5546\u673a"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","client_class":1,"logo":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237"}},"project":{"id":1111,"key":1111,"name":"\u4ebf\u8054\u89c6\u9891\u4f1a\u8bae\u7edf\u4e00\u901a\u8baf"},"workLogContacts":[{"id":3791,"key":3791,"name":"\u82cf\u6e05\u4e91"},{"id":3837,"key":3837,"name":"\u5218\u6d77\u9759"}],"commentCount":{"object_id":39157,"comment":2},"attachmentRelationships":[{"id":57584,"object_type":18,"object_id":39157,"attachment_id":32645,"attachment":{"id":32645,"key":32645,"name":"e07562e0-3849-39f9-a1ac-75158298ad7d","extension":"png","path":"\/vue\/attachment\/view?name=e07562e0-3849-39f9-a1ac-75158298ad7d"}}],"locationIn":{},"locationOut":{},"files":[],"workLogCarbonCopyRels":[],"unreadComments":{},"hours_spent_display":"2\u5c0f\u65f6","can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":20700,"client_id":982,"scenario_id":1,"scenario_option_id":7,"end_at":"2022-08-17 17:12:00","created_by":1000,"created_at":"2022-08-17 17:12:01","updated_at":"2022-08-17 17:13:03","start_at":"2022-08-17 15:00:00","description":"","escort":"","is_draft":false,"location_id":"","project_id":1111,"location_in_id":"","location_out_id":11646,"status":0,"indistance":0,"outdistance":0,"hours_spent":"02:12:00","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"location":{},"scenarioOption":{"id":7,"key":7,"name":"\u62dc\u8bbf\u5382\u5546"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","client_class":1,"logo":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237"}},"project":{"id":1111,"key":1111,"name":"\u4ebf\u8054\u89c6\u9891\u4f1a\u8bae\u7edf\u4e00\u901a\u8baf"},"workLogContacts":[{"id":3643,"key":3643,"name":"\u9ad8\u90e1\u9633(\u6d4b\u8bd5)"},{"id":4082,"key":4082,"name":"\u6d4b\u8bd5"}],"commentCount":{"object_id":20700,"comment":14},"attachmentRelationships":[],"locationIn":{},"locationOut":{"id":11646,"lng":"116.289040527344","lat":"39.9604722764757","address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u84dd\u975b\u5382\u4e1c\u8def\u9760\u8fd1\u5c45\u7136\u4e4b\u5bb6(\u91d1\u6e90\u5e97)","time":"2022-08-17 17:12:00"},"files":[],"workLogCarbonCopyRels":[{"id":1726,"work_log_id":20700,"user_id":5016,"user":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"}}},{"id":1727,"work_log_id":20700,"user_id":5064,"user":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"}}}],"unreadComments":{},"hours_spent_display":"2\u5c0f\u65f612\u5206\u949f","can_update":true,"can_delete":true,"bgcolor":"#89c541"}],"can_create":true,"pagenation":{"totalcount":3,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"223.104.40.7","ua":"jinchangxiao\/2.3.158 (iPhone 12; iOS 26.5.2; Scale\/3.00)"}', FALSE, '2026-07-15 15:13:31', 77150976) RETURNING "id"
15:13:31.2321.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_log_carbon_copy_rels" WHERE "work_log_id" IN (39158, 39157, 20700)
15:13:31.1820.7 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm'
15:13:31.2340.6 msyii\db\Command::querySELECT "id", "id" AS "key", CASE WHEN user_status = '-1' THEN name || '(已离职)' ELSE name END AS name, "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5016, 5064)
15:13:31.2040.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_contacts" WHERE "id" IN (4082, 3643, 3837, 3791)
15:13:31.2280.5 msyii\db\Command::querySELECT id, geolocation[0] AS lng, geolocation[1] AS lat, address, updated_at as time FROM "a57be577deb434"."tbl_location" WHERE "id"=21275
15:13:31.1970.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10
15:13:31.1840.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
15:13:31.1970.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_work_log_scenario_options" WHERE "id" IN (73, 72, 7)
15:13:31.1990.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_classes" WHERE "id"=1
15:13:31.1980.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "client_class", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id"=982
15:13:31.1950.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
15:13:31.2270.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (32645, 32657)
15:13:31.1980.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_work_log_scenarios" WHERE "id"=1
15:13:31.2290.3 msyii\db\Command::querySELECT id, geolocation[0] AS lng, geolocation[1] AS lat, address, updated_at as time FROM "a57be577deb434"."tbl_location" WHERE "id" IN (21276, 11646)
15:13:31.1960.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000)
15:13:31.2350.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5064, 5016))
15:13:31.1990.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:13:31.1820.3 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:13:31.2000.2 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id"=1111