Performance Profiling

Total processing time: 163 ms; Peak memory: 2.249 MB. Show Profiling Timeline

总计8条数据

Time	Duration	Category	Info

17:33:58.761	75.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_object_change_logs" WHERE ("object_id"='4072') AND ("object_type"='13') ORDER BY "created_at" DESC LIMIT 20
17:33:58.689	72.4 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT FROM "a57be577deb434"."tbl_object_change_logs" WHERE ("object_id"='4072') AND ("object_type"='13') ORDER BY "created_at" DESC) "c"
17:33:58.683	2.3 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:33:58.681	1.8 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:33:58.687	1.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:33:58.840	1.5 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":"13","object_id":"4072","page":"1","web_access_token":"sXjqURNBCao5nldOR3zGEIU34GY49pIi"}', '{"code":2000,"result":{"list":[{"id":570638,"object_id":4072,"object_type":13,"target_id":"","target_object_type":"","act":2,"attribute":"costContractAmounts","old_value":[["\u529e\u516c\u7528\u54c1:8000\u5143"]],"new_value":[["\u529e\u516c\u7528\u54c1:80000\u5143"]],"description":{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u8d39\u7528\u4fe1\u606f","d4":["\u529e\u516c\u7528\u54c1:8000\u5143; <b>\u53d8\u4e3a<\/b> \u529e\u516c\u7528\u54c1:80000\u5143;"]},"created_by":1001,"created_at":"2025-09-16 17:33:58","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":false,"created_at_display":"\u521a\u521a"},{"id":570637,"object_id":4072,"object_type":13,"target_id":"","target_object_type":"","act":2,"attribute":"amount","old_value":["8000\u5143"],"new_value":["80000\u5143"],"description":{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5408\u540c\u603b\u989d","d4":["8000\u5143 <b>\u53d8\u4e3a<\/b> 80000\u5143"]},"created_by":1001,"created_at":"2025-09-16 17:33:58","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":false,"created_at_display":"\u521a\u521a"},{"id":570633,"object_id":4072,"object_type":13,"target_id":"","target_object_type":"","act":2,"attribute":"costContractAmounts","old_value":[["\u529e\u516c\u7528\u54c1:80000\u5143"]],"new_value":[["\u529e\u516c\u7528\u54c1:800000\u5143"]],"description":{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u8d39\u7528\u4fe1\u606f","d4":["\u529e\u516c\u7528\u54c1:80000\u5143; <b>\u53d8\u4e3a<\/b> \u529e\u516c\u7528\u54c1:800000\u5143;"]},"created_by":1001,"created_at":"2025-09-16 17:33: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":false,"created_at_display":"34\u79d2\u524d"},{"id":570632,"object_id":4072,"object_type":13,"target_id":"","target_object_type":"","act":2,"attribute":"amount","old_value":["80000\u5143"],"new_value":["800000\u5143"],"description":{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5408\u540c\u603b\u989d","d4":["80000\u5143 <b>\u53d8\u4e3a<\/b> 800000\u5143"]},"created_by":1001,"created_at":"2025-09-16 17:33: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":false,"created_at_display":"34\u79d2\u524d"},{"id":570629,"object_id":4072,"object_type":13,"target_id":"","target_object_type":"","act":2,"attribute":"costContractAmounts","old_value":[["\u529e\u516c\u7528\u54c1:8000\u5143"]],"new_value":[["\u529e\u516c\u7528\u54c1:80000\u5143"]],"description":{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u8d39\u7528\u4fe1\u606f","d4":["\u529e\u516c\u7528\u54c1:8000\u5143; <b>\u53d8\u4e3a<\/b> \u529e\u516c\u7528\u54c1:80000\u5143;"]},"created_by":1001,"created_at":"2025-09-16 17:32:23","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":false,"created_at_display":"1\u5206\u949f\u524d"},{"id":570627,"object_id":4072,"object_type":13,"target_id":"","target_object_type":"","act":2,"attribute":"amount","old_value":["8000\u5143"],"new_value":["80000\u5143"],"description":{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5408\u540c\u603b\u989d","d4":["8000\u5143 <b>\u53d8\u4e3a<\/b> 80000\u5143"]},"created_by":1001,"created_at":"2025-09-16 17:32:23","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":false,"created_at_display":"1\u5206\u949f\u524d"},{"id":570628,"object_id":4072,"object_type":13,"target_id":"","target_object_type":"","act":2,"attribute":"description","old_value":["boss\u76f4\u8058\u4e00\u5e74\u8d26\u53f7\u6743\u9650"],"new_value":["boss\u76f4\u8058\u4e00\u5e74\u8d26\u53f7\u6743\u9650\n\u7f16\u8f91\u62d2\u7edd\u540e\u53d8\u54738000"],"description":{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5907\u6ce8","d4":["boss\u76f4\u8058\u4e00\u5e74\u8d26\u53f7\u6743\u9650\n\u7f16\u8f91\u62d2\u7edd\u540e\u53d8\u54738000"]},"created_by":1001,"created_at":"2025-09-16 17:32:23","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":"1\u5206\u949f\u524d"},{"id":551842,"object_id":4072,"object_type":13,"target_id":2209,"target_object_type":110,"act":1,"attribute":"create","old_value":[2209],"new_value":[2209],"description":{"d1":"\u7fc1\u5bb6\u6210","d2":"\u521b\u5efa\u4e86","d3":"\u4ed8\u6b3e\u8bb0\u5f55","d4":["2025-07-31 \uffe58000.00"]},"created_by":1013,"created_at":"2025-07-31 09:43:52","is_delete":false,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}},"need_hidden":false,"created_at_display":"07\u670831\u65e5 09:43"},{"id":551639,"object_id":4072,"object_type":13,"target_id":2381,"target_object_type":109,"act":2,"attribute":"update","old_value":[2381],"new_value":[2381],"description":{"d1":"\u97e9\u96c5\u82b3","d2":"\u66f4\u65b0\u4e86","d3":"\u53d1\u7968\u4fe1\u606f","d4":[""]},"created_by":1011,"created_at":"2025-07-30 14:17:45","is_delete":false,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"need_hidden":false,"created_at_display":"07\u670830\u65e5 14:17"},{"id":551631,"object_id":4072,"object_type":13,"target_id":2381,"target_object_type":109,"act":1,"attribute":"create","old_value":[2381],"new_value":[2381],"description":{"d1":"\u97e9\u96c5\u82b3","d2":"\u521b\u5efa\u4e86","d3":"\u53d1\u7968\u4fe1\u606f","d4":["2025-07-30 \uffe58000.00"]},"created_by":1011,"created_at":"2025-07-30 14:16:57","is_delete":false,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"need_hidden":false,"created_at_display":"07\u670830\u65e5 14:16"},{"id":551608,"object_id":4072,"object_type":13,"target_id":"","target_object_type":"","act":2,"attribute":"contractScans","old_value":[[]],"new_value":[["27169"]],"description":{"d1":"\u97e9\u96c5\u82b3","d2":"\u66f4\u65b0\u4e86","d3":"\u5408\u540c","d4":[""]},"created_by":1011,"created_at":"2025-07-30 11:23:29","is_delete":false,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"need_hidden":true,"created_at_display":"07\u670830\u65e5 11:23"},{"id":551606,"object_id":4072,"object_type":13,"target_id":"","target_object_type":"","act":2,"attribute":"purchaseContractPaymentCollectionRemindReceivers","old_value":[[]],"new_value":[["\u97e9\u96c5\u82b3","\u5f20\u7ea2\u82b3"]],"description":{"d1":"\u97e9\u96c5\u82b3","d2":"\u66f4\u65b0\u4e86","d3":"\u4ed8\u6b3e\u63d0\u9192\u4eba","d4":["(\u672a\u8bbe\u7f6e) <b>\u53d8\u4e3a<\/b> \u97e9\u96c5\u82b3;\u5f20\u7ea2\u82b3;"]},"created_by":1011,"created_at":"2025-07-30 11:22:53","is_delete":false,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"need_hidden":false,"created_at_display":"07\u670830\u65e5 11:22"},{"id":551605,"object_id":4072,"object_type":13,"target_id":"","target_object_type":"","act":2,"attribute":"purchaseContractPaymentCollectionRemindDates","old_value":[[]],"new_value":[["2025-07-31 8000.00\u5143"]],"description":{"d1":"\u97e9\u96c5\u82b3","d2":"\u66f4\u65b0\u4e86","d3":"\u4ed8\u6b3e\u8ba1\u5212","d4":["(\u672a\u8bbe\u7f6e) <b>\u53d8\u4e3a<\/b> 2025-07-31 8000.00\u5143;"]},"created_by":1011,"created_at":"2025-07-30 11:22:53","is_delete":false,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"need_hidden":false,"created_at_display":"07\u670830\u65e5 11:22"},{"id":551603,"object_id":4072,"object_type":13,"target_id":"","target_object_type":"","act":1,"attribute":"create","old_value":{"id":4072,"supplier_id":289,"contract_type":4,"signed_at":"2025-07-30","amount":"8000","handler":1011,"description":"boss\u76f4\u8058\u4e00\u5e74\u8d26\u53f7\u6743\u9650","contract_scan":"","created_by":1011,"created_at":"2025-07-30 11:22:42","updated_at":"2025-07-30 11:22:42","client_id":"","project_id":"","sales_rep":"","serial_no":"EBJ02507293121709","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":false,"save_collection_at":"","is_chargeback":false,"cost_type":2},"new_value":{"id":4072,"supplier_id":289,"contract_type":4,"signed_at":"2025-07-30","amount":"8000","handler":1011,"description":"boss\u76f4\u8058\u4e00\u5e74\u8d26\u53f7\u6743\u9650","contract_scan":"","created_by":1011,"created_at":"2025-07-30 11:22:42","updated_at":"2025-07-30 11:22:42","client_id":"","project_id":"","sales_rep":"","serial_no":"EBJ02507293121709","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":false,"save_collection_at":"","is_chargeback":false,"cost_type":2},"description":{"d1":"\u97e9\u96c5\u82b3","d2":"\u521b\u5efa\u4e86","d3":"\u8d39\u7528\u5408\u540c","d4":[]},"created_by":1011,"created_at":"2025-07-30 11:22:42","is_delete":false,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"need_hidden":true,"created_at_display":"07\u670830\u65e5 11:22"}],"pagenation":{"totalcount":14,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-16 17:33:58') RETURNING "id"
17:33:58.838	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 (1011, 1001, 1013))
17:33:58.837	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1013, 1011)