Performance Profiling

Total processing time: 367 ms; Peak memory: 2.207 MB. Show Profiling Timeline

总计8条数据

Time	Duration	Category	Info

16:09:36.062	83.7 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT FROM "a57be577deb434"."tbl_object_change_logs" WHERE ("object_id"='914') AND ("object_type"='10') ORDER BY "created_at" DESC) "c"
16:09:36.146	76.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_object_change_logs" WHERE ("object_id"='914') AND ("object_type"='10') ORDER BY "created_at" DESC LIMIT 20
16:09:36.054	3.3 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
16:09:36.052	2.4 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:09:36.059	2.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:09:36.226	1.6 ms	yii\db\Command::query	INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/change-log/of-object', '{"object_type":"10","object_id":"914","page":"1","web_access_token":"sXjqURNBCao5nldOR3zGEIU34GY49pIi"}', '{"code":2000,"result":{"list":[{"id":567226,"object_id":914,"object_type":10,"target_id":"","target_object_type":"","act":10,"attribute":"sales_rep","old_value":["\u5218\u4eba\u8bda"],"new_value":[""],"description":{"d1":"\u5218\u4eba\u8bda","d2":"\u5c06\u5ba2\u6237\u4ece\u516c\u6d77\u5ba2\u6237\u8f6c\u79fb\u7ed9","d3":"\u81ea\u5df1","d4":[]},"created_by":1001,"created_at":"2025-09-16 16:06:36","is_delete":false,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"need_hidden":true,"created_at_display":"3\u5206\u949f\u524d"},{"id":181500,"object_id":914,"object_type":10,"target_id":"","target_object_type":"","act":2,"attribute":"name","old_value":["\u5929\u6d25\u5e7f\u7535\u7f51\u7edc\u516c\u53f8"],"new_value":["\u5929\u6d25\u5e7f\u7535\u7f51\u7edc\u516c\u53f8-\u62d2\u7edd"],"description":{"d1":"\u9ad8\u5ce5","d2":"\u66f4\u65b0\u4e86","d3":"\u5ba2\u6237\u540d\u79f0","d4":["\u5929\u6d25\u5e7f\u7535\u7f51\u7edc\u516c\u53f8 <b>\u53d8\u4e3a<\/b> \u5929\u6d25\u5e7f\u7535\u7f51\u7edc\u516c\u53f8-\u62d2\u7edd"]},"created_by":5329,"created_at":"2022-07-21 11:37:57","is_delete":false,"createdBy":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"need_hidden":false,"created_at_display":"2022\u5e7407\u670821\u65e5"},{"id":181501,"object_id":914,"object_type":10,"target_id":"","target_object_type":"","act":2,"attribute":"client_class","old_value":[{}],"new_value":["C\u7ea7\u5ba2\u6237"],"description":{"d1":"\u9ad8\u5ce5","d2":"\u66f4\u65b0\u4e86","d3":"\u5ba2\u6237\u7ea7\u522b","d4":["(\u672a\u8bbe\u7f6e) <b>\u53d8\u4e3a<\/b> C\u7ea7\u5ba2\u6237"]},"created_by":5329,"created_at":"2022-07-21 11:37:57","is_delete":false,"createdBy":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"need_hidden":false,"created_at_display":"2022\u5e7407\u670821\u65e5"},{"id":181497,"object_id":914,"object_type":10,"target_id":19817,"target_object_type":19,"act":1,"attribute":"create","old_value":[19817],"new_value":[19817],"description":{"d1":"\u9ad8\u5ce5","d2":"\u521b\u5efa\u4e86","d3":"\u5de5\u4f5c\u65e5\u5fd7","d4":["\u5ba2\u6237\u7535\u8bdd\u6c9f\u901a"]},"created_by":5329,"created_at":"2022-07-21 11:36:13","is_delete":false,"createdBy":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"need_hidden":false,"created_at_display":"2022\u5e7407\u670821\u65e5"},{"id":171731,"object_id":914,"object_type":10,"target_id":"","target_object_type":"","act":5,"attribute":"sales_rep","old_value":["\u9ad8\u5ce5"],"new_value":[""],"description":{"d1":"\u9ad8\u5ce5","d2":"\u653e\u5f03\u4e86","d3":"\u5ba2\u6237","d4":[]},"created_by":5329,"created_at":"2022-06-02 15:17:00","is_delete":false,"createdBy":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"need_hidden":true,"created_at_display":"2022\u5e7406\u670802\u65e5"},{"id":167487,"object_id":914,"object_type":10,"target_id":18616,"target_object_type":19,"act":1,"attribute":"create","old_value":[18616],"new_value":[18616],"description":{"d1":"\u9ad8\u5ce5","d2":"\u521b\u5efa\u4e86","d3":"\u5de5\u4f5c\u65e5\u5fd7","d4":["\u5ba2\u6237\u7535\u8bdd\u6c9f\u901a"]},"created_by":5329,"created_at":"2022-04-28 15:50:56","is_delete":false,"createdBy":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"need_hidden":false,"created_at_display":"2022\u5e7404\u670828\u65e5"},{"id":165126,"object_id":914,"object_type":10,"target_id":18519,"target_object_type":19,"act":1,"attribute":"create","old_value":[18519],"new_value":[18519],"description":{"d1":"\u9ad8\u5ce5","d2":"\u521b\u5efa\u4e86","d3":"\u5de5\u4f5c\u65e5\u5fd7","d4":["\u5ba2\u6237\u7535\u8bdd\u6c9f\u901a"]},"created_by":5329,"created_at":"2022-04-19 17:16:56","is_delete":false,"createdBy":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"need_hidden":false,"created_at_display":"2022\u5e7404\u670819\u65e5"},{"id":164809,"object_id":914,"object_type":10,"target_id":"","target_object_type":"","act":10,"attribute":"sales_rep","old_value":["\u9ad8\u5ce5"],"new_value":[""],"description":{"d1":"\u8d75\u6657\u7131","d2":"\u5c06\u5ba2\u6237\u4ece\u516c\u6d77\u5ba2\u6237\u8f6c\u79fb\u7ed9","d3":"\u9ad8\u5ce5","d4":[]},"created_by":1005,"created_at":"2022-04-18 15:30:37","is_delete":false,"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"need_hidden":true,"created_at_display":"2022\u5e7404\u670818\u65e5"},{"id":79590,"object_id":914,"object_type":10,"target_id":"","target_object_type":"","act":10,"attribute":"sales_rep","old_value":["\u516c\u6d77\u5ba2\u6237"],"new_value":["\u5415\u6770"],"description":{"d1":"\u5218\u4eba\u8bda","d2":"\u5c06\u5ba2\u6237\u4ece\u5415\u6770\u8f6c\u79fb\u7ed9","d3":"\u516c\u6d77\u5ba2\u6237","d4":[]},"created_by":1001,"created_at":"2021-03-29 18:08:24","is_delete":false,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"need_hidden":true,"created_at_display":"2021\u5e7403\u670829\u65e5"},{"id":47488,"object_id":914,"object_type":10,"target_id":12915,"target_object_type":19,"act":1,"attribute":"create","old_value":[5124],"new_value":[5124],"description":{"d1":"\u5f90\u73b2\u73b2","d2":"\u521b\u5efa\u4e86","d3":"\u5de5\u4f5c\u65e5\u5fd7","d4":["\u5ba2\u6237\u7535\u8bdd\u6c9f\u901a"]},"created_by":5124,"created_at":"2019-11-14 16:39:15","is_delete":false,"createdBy":{"id":5124,"key":5124,"name":"\u5f90\u73b2\u73b2","sex":"F","avatar":{"id":61,"user_id":5124,"name":"\/files\/cdn\/a57be577deb434\/avatar\/99f32fef-5628-35b0-9be9-23eb0b507ddf.png"}},"need_hidden":false,"created_at_display":"2019\u5e7411\u670814\u65e5"},{"id":5079,"object_id":914,"object_type":10,"target_id":"","target_object_type":"","act":1,"attribute":"create","old_value":[{"id":914,"name":"\u5929\u6d25\u5e7f\u7535\u7f51\u7edc\u516c\u53f8","abbr":"","pinyin_shortcut":"tjgdwlgs","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":1295,"telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0","purchase_freq":"","company_nature":1,"client_class":"","client_industry":1,"client_type":1,"sales_rep":5208,"main_contact":"","created_by":5045,"created_at":"2018-03-02 16:12:12","updated_at":"2021-02-25 21:25:30","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":""}],"new_value":[{"id":914,"name":"\u5929\u6d25\u5e7f\u7535\u7f51\u7edc\u516c\u53f8","abbr":"","pinyin_shortcut":"tjgdwlgs","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":1295,"telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0","purchase_freq":"","company_nature":1,"client_class":"","client_industry":1,"client_type":1,"sales_rep":5208,"main_contact":"","created_by":5045,"created_at":"2018-03-02 16:12:12","updated_at":"2021-02-25 21:25:30","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":""}],"description":{"d1":"\u5218\u5c0a\u559c","d2":"\u521b\u5efa\u4e86","d3":"\u5ba2\u6237","d4":[]},"created_by":5045,"created_at":"2018-03-02 16:12:12","is_delete":false,"createdBy":{"id":5045,"key":5045,"name":"\u5218\u5c0a\u559c","sex":"M","avatar":{"id":29,"user_id":5045,"name":"\/files\/cdn\/a57be577deb434\/avatar\/6e8fd0a1-a836-309d-90a7-c16ee123e8aa.png"}},"need_hidden":true,"created_at_display":"2018\u5e7403\u670802\u65e5"}],"pagenation":{"totalcount":11,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-16 16:09:36') RETURNING "id"
16:09:36.224	0.7 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 1005, 5329, 5124, 5045))
16:09:36.223	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5329, 1005, 5124, 5045)