ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a1d14eec329a: POST https://beta.jinchangxiao.com/vue/work-log/save-edit at 2026-06-01 01:13:18 pm by 221.216.117.119

Performance Profiling

Total processing time: 92 ms; Peak memory: 5.078 MB. Show Profiling Timeline

总计52条数据
TimeDurationCategoryInfo
  
13:13:18.86124.6 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=19) AND ("object_id"=39168) AND ("created_by"=5064))
13:13:18.8545.4 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_unread_comments" ("object_id", "object_type", "comment_id", "remind_user_id") VALUES (39168, '19', 220619, 5064)
13:13:18.8114.6 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (1, 'create', 39168, 19, 1001, '2026-06-01 13:12:33', '{"id":39168,"client_id":"","scenario_id":"1","scenario_option_id":"66","end_at":"2026-06-01 12:24:00","created_by":1001,"created_at":"2026-06-01 13:12:33","updated_at":"1970-01-01 08:00:00","start_at":"2026-06-01 12:12:00","description":"","escort":"","is_draft":"0","location_id":null,"project_id":"","location_in_id":null,"location_out_id":null,"status":0,"indistance":null,"outdistance":null}', '{"id":39168,"client_id":"","scenario_id":"1","scenario_option_id":"66","end_at":"2026-06-01 12:24:00","created_by":1001,"created_at":"2026-06-01 13:12:33","updated_at":"1970-01-01 08:00:00","start_at":"2026-06-01 12:12:00","description":"","escort":"","is_draft":"0","location_id":null,"project_id":"","location_in_id":null,"location_out_id":null,"status":0,"indistance":null,"outdistance":null}', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u5de5\u4f5c\u65e5\u5fd7","d4":[]}') RETURNING "id"
13:13:18.8443.3 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "is_system", "description2") VALUES (1001, '19', 39168, '刘人诚新建了一条客情增进的工作日志', TRUE, '') RETURNING "id"
13:13:18.8222.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=18) AND ("object_id"=39168)
13:13:18.8182.1 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_work_logs" SET "client_id"=NULL, "scenario_id"=1, "scenario_option_id"=66, "end_at"='2026/06/01 12:24', "updated_at"='now()', "start_at"='2026/06/01 12:12', "is_draft"=FALSE, "project_id"=NULL WHERE "id"=39168
13:13:18.8262.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=101) AND ("object_id"=39168)
13:13:18.8242.0 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=18) AND ("object_id"=39168)
13:13:18.8281.8 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=101) AND ("object_id"=39168)
13:13:18.8161.6 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\ObjectChangeLogs', 640858, 'a:13:{s:2:"id";i:640858;s:9:"object_id";i:39168;s:11:"object_type";i:19;s:9:"target_id";N;s:18:"target_object_type";N;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:395:"{"id":39168,"client_id":"","scenario_id":"1","scenario_option_id":"66","end_at":"2026-06-01 12:24:00","created_by":1001,"created_at":"2026-06-01 13:12:33","updated_at":"1970-01-01 08:00:00","start_at":"2026-06-01 12:12:00","description":"","escort":"","is_draft":"0","location_id":null,"project_id":"","location_in_id":null,"location_out_id":null,"status":0,"indistance":null,"outdistance":null}";s:9:"new_value";s:395:"{"id":39168,"client_id":"","scenario_id":"1","scenario_option_id":"66","end_at":"2026-06-01 12:24:00","created_by":1001,"created_at":"2026-06-01 13:12:33","updated_at":"1970-01-01 08:00:00","start_at":"2026-06-01 12:12:00","description":"","escort":"","is_draft":"0","location_id":null,"project_id":"","location_in_id":null,"location_out_id":null,"status":0,"indistance":null,"outdistance":null}";s:11:"description";s:93:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u5de5\u4f5c\u65e5\u5fd7","d4":[]}";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2026-06-01 13:12:33";s:9:"is_delete";N;}', '', 1001, '221.216.117.119')
13:13:18.8301.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_log_contacts" WHERE "work_log_id"=39168
13:13:18.8331.3 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_work_log_contacts" WHERE "work_log_id"=39168
13:13:18.8021.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
13:13:18.8391.0 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_work_log_verify_rels" WHERE "work_log_id"=39168
13:13:18.8400.9 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_work_log_verify_rels" ("work_log_id", "user_id", "status") VALUES (39168, 5064, 0)
13:13:18.8870.8 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\WorkLogs', 39168, 'a:3:{s:6:"end_at";s:19:"2026-06-01 12:24:00";s:8:"start_at";s:19:"2026-06-01 12:12:00";s:6:"status";i:-1;}', '', 1001, '221.216.117.119')
13:13:18.8530.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', 220619, 'a:11:{s:2:"id";i:220619;s:9:"object_id";i:39168;s:11:"object_type";s:2:"19";s:6:"parent";N;s:11:"description";s:57:"刘人诚有一条客情增进的工作日志需要审阅";s:10:"created_by";i:1001;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:0:"";}', '', 1001, '221.216.117.119')
13:13:18.8890.8 msyii\db\Command::queryINSERT 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/save-edit', '{"WorkLogs":{"id":"39168","client_id":"","client_name":"","end_at":"2026\/06\/01 12:24","start_at":"2026\/06\/01 12:12","description":"","scenario_id":"1","scenario_option_id":"66","escort":"","project_id":"","is_draft":"0","form_workLogVerifyRels":["5064"],"files":"","form_workLogCarbonCopyRels":""},"web_access_token":"YNQKwEYJYN8muCSh8ExnNlBf2oepDAlv"}', '{"code":2000,"result":{"id":39168},"status":1,"msg":[{"name":"success","success":"\u5de5\u4f5c\u65e5\u5fd7\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-01 13:13:18', 89279232) RETURNING "id"
13:13:18.8380.8 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 (2, 'workLogVerifyRels', 39168, 19, 1001, 'now()', '[["\u59da\u96ea\u7eaf"]]', '[["\u8463\u8363"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5ba1\u9605\u4eba","d4":["\u8463\u8363; <b>\u53d8\u4e3a<\/b> \u59da\u96ea\u7eaf;"]}')
13:13:18.8860.8 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\WorkLogVerifyRels', 16065, 'a:0:{}', '', 1001, '221.216.117.119')
13:13:18.8520.8 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "is_system", "description2") VALUES (1001, '19', 39168, '刘人诚有一条客情增进的工作日志需要审阅', TRUE, '') RETURNING "id"
13:13:18.8480.7 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', 220618, 'a:11:{s:2:"id";i:220618;s:9:"object_id";i:39168;s:11:"object_type";s:2:"19";s:6:"parent";N;s:11:"description";s:51:"刘人诚新建了一条客情增进的工作日志";s:10:"created_by";i:1001;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:0:"";}', '', 1001, '221.216.117.119')
13:13:18.8210.7 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\WorkLogs', 39168, 'a:3:{s:6:"end_at";s:19:"2026-06-01 12:24:00";s:8:"start_at";s:19:"2026-06-01 12:12:00";s:18:"scenario_option_id";s:2:"66";}', '', 1001, '221.216.117.119')
13:13:18.8860.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_work_logs" SET "status"=-1 WHERE "id"=39168
13:13:18.8350.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_log_verify_rels" WHERE "work_log_id"=39168 ORDER BY "id"
13:13:18.8340.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_log_carbon_copy_rels" WHERE "work_log_id"=39168
13:13:18.8010.6 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
13:13:18.8050.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_logs" WHERE "id"='39168'
13:13:18.8500.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_log_verify_rels" WHERE "work_log_id"=39168 ORDER BY "id"
13:13:18.8350.5 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_work_log_carbon_copy_rels" WHERE "work_log_id"=39168
13:13:18.8410.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_log_carbon_copy_rels" WHERE "work_log_id"=39168
13:13:18.8600.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_log_verify_rels" WHERE "work_log_id"=39168 ORDER BY "id"
13:13:18.8320.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_contacts" WHERE 0=1
13:13:18.8370.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
13:13:18.8100.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
13:13:18.8360.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='5064'
13:13:18.8370.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5250
13:13:18.8090.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
13:13:18.8000.3 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
13:13:18.8080.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
13:13:18.8090.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_work_log_scenario_options" WHERE "id"='66')
13:13:18.8440.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
13:13:18.8090.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_work_log_scenarios" WHERE "id"='1')
13:13:18.8520.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
13:13:18.8170.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
13:13:18.8420.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_logs" WHERE "id"=39168
13:13:18.8420.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_log_scenario_options" WHERE "id"='66'
13:13:18.8490.2 msyii\db\Command::querySELECT "channel_id" FROM "global"."tbl_logins" WHERE (0=1) AND ("id" != 1001) AND (channel_id IS NOT NULL)
13:13:18.8600.2 msyii\db\Command::querySELECT "channel_id" FROM "global"."tbl_logins" WHERE ("id"=5064) AND ("id" != 1001) AND (channel_id IS NOT NULL)
13:13:18.8510.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_logs" WHERE "id"=39168
13:13:18.8180.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_work_log_scenario_options" WHERE "id"='66')
13:13:18.8180.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_work_log_scenarios" WHERE "id"='1')