Performance Profiling

Total processing time: 555 ms; Peak memory: 2.208 MB. Show Profiling Timeline

总计9条数据

Time	Duration	Category	Info

16:40:00.694	110.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_object_change_logs" WHERE ("object_id"='9077') AND ("object_type"='18') ORDER BY "created_at" DESC LIMIT 20
16:40:00.587	106.0 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT FROM "a57be577deb434"."tbl_object_change_logs" WHERE ("object_id"='9077') AND ("object_type"='18') ORDER BY "created_at" DESC) "c"
16:40:00.578	2.8 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:40:00.584	2.0 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
16:40:00.806	2.0 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5360, 5248)
16:40:00.809	1.6 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 (5360, 5248))
16:40:00.811	1.0 ms	yii\db\Command::query	INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/change-log/of-object', '{"object_type":"18","object_id":"9077","page":"1","web_access_token":"YwFaPh8a1dbQrFwOp6grZ7RlSTuMSejO"}', '{"code":2000,"result":{"list":[{"id":608330,"object_id":9077,"object_type":18,"target_id":"","target_object_type":"","act":10,"attribute":"case_status","old_value":[4],"new_value":[5],"description":{"d1":"\u5f20\u7ea2\u82b3","d2":"\u5173\u95ed\u4e86","d3":"Case","d4":[]},"created_by":5360,"created_at":"2025-12-26 16:17:37","is_delete":false,"createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}},"need_hidden":true,"created_at_display":"2025\u5e7412\u670826\u65e5"},{"id":607549,"object_id":9077,"object_type":18,"target_id":"","target_object_type":"","act":13,"attribute":"case_status","old_value":[3],"new_value":[4],"description":{"d1":"\u6587\u4f73\u9f99","d2":"\u5b8c\u6210\u4e86","d3":"Case","d4":[]},"created_by":5248,"created_at":"2025-12-25 09:46:13","is_delete":false,"createdBy":{"id":5248,"key":5248,"name":"\u6587\u4f73\u9f99","sex":"M","avatar":{"id":135,"user_id":5248,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b4458545-7f88-3479-97be-6f43b2b50454.png"}},"need_hidden":true,"created_at_display":"2025\u5e7412\u670825\u65e5"},{"id":607548,"object_id":9077,"object_type":18,"target_id":7389,"target_object_type":5,"act":1,"attribute":"create","old_value":[7389],"new_value":[7389],"description":{"d1":"\u6587\u4f73\u9f99","d2":"\u521b\u5efa\u4e86","d3":"\u5b9e\u65bd\u5de5\u5355","d4":["\u5de5\u5355\u7f16\u53f7:IM251224004001"]},"created_by":5248,"created_at":"2025-12-25 09:46:07","is_delete":false,"createdBy":{"id":5248,"key":5248,"name":"\u6587\u4f73\u9f99","sex":"M","avatar":{"id":135,"user_id":5248,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b4458545-7f88-3479-97be-6f43b2b50454.png"}},"need_hidden":false,"created_at_display":"2025\u5e7412\u670825\u65e5"},{"id":607544,"object_id":9077,"object_type":18,"target_id":"","target_object_type":"","act":6,"attribute":"case_status","old_value":[2],"new_value":[3],"description":{"d1":"\u6587\u4f73\u9f99","d2":"\u63a5\u53d7\u4e86","d3":"Case","d4":[]},"created_by":5248,"created_at":"2025-12-25 09:43:26","is_delete":false,"createdBy":{"id":5248,"key":5248,"name":"\u6587\u4f73\u9f99","sex":"M","avatar":{"id":135,"user_id":5248,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b4458545-7f88-3479-97be-6f43b2b50454.png"}},"need_hidden":true,"created_at_display":"2025\u5e7412\u670825\u65e5"},{"id":607308,"object_id":9077,"object_type":18,"target_id":"","target_object_type":"","act":1,"attribute":"create","old_value":{"id":9077,"client_id":2545,"contact_id":4640,"project_id":3899,"last_engineer":5248,"case_type":2,"case_status":2,"start_at":"2025-12-24 14:00:00","closed_at":"","points":25,"deduct_points_from":1001,"created_by":5360,"created_at":"2025-12-24 14:38:17","updated_at":"2025-12-24 14:38:17","case_no":"IM251224004","description":"\u9632\u706b\u5899\u95ee\u9898\u5904\u7406","spent_time":"1 hour","alarm_before":"","suspend_at":"","completed_at":"","mp_submit_contact_id":"","attachment_id":"","need_push":true,"task_group_id":""},"new_value":{"id":9077,"client_id":2545,"contact_id":4640,"project_id":3899,"last_engineer":5248,"case_type":2,"case_status":2,"start_at":"2025-12-24 14:00:00","closed_at":"","points":25,"deduct_points_from":1001,"created_by":5360,"created_at":"2025-12-24 14:38:17","updated_at":"2025-12-24 14:38:17","case_no":"IM251224004","description":"\u9632\u706b\u5899\u95ee\u9898\u5904\u7406","spent_time":"1 hour","alarm_before":"","suspend_at":"","completed_at":"","mp_submit_contact_id":"","attachment_id":"","need_push":true,"task_group_id":""},"description":{"d1":"\u5f20\u7ea2\u82b3","d2":"\u521b\u5efa\u4e86","d3":"Case","d4":[]},"created_by":5360,"created_at":"2025-12-24 14:38:17","is_delete":false,"createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}},"need_hidden":true,"created_at_display":"2025\u5e7412\u670824\u65e5"}],"pagenation":{"totalcount":5,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"43.224.72.82","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-09 16:40:00', 548651008) RETURNING "id"
16:40:00.580	0.7 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=5493
16:40:00.586	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001