Performance Profiling

Total processing time: 19 ms; Peak memory: 2.516 MB. Show Profiling Timeline

总计12条数据

Time	Duration	Category	Info

10:50:48.203	2.2 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
10:50:48.201	1.9 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
10:50:48.215	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/erp-dashboard/list-log', '{"ErpTicketChangeLogSearch":{"wrote_date_period":"","status":"","created_by":""},"page":"7","web_access_token":"zUlYIhmNqLFz6ROnFIxdmrYIyKz8-OtA"}', '{"code":2000,"result":{"list":[{"id":3,"serial_no":"FK-20250804-00003","ticket_type":20012,"wrote_date":"2025-08-04","status":2,"supplier_id":676,"client_id":"","abstract":"","description":"","verify_at":"2025-08-04 17:09:32","created_by":1013,"created_at":"2025-08-04 17:09:32","updated_at":"2025-08-04 17:09:32","contact_id":"","user_id":"","amount":"1888000","object_id":2065,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"supplier":{"id":676,"key":676,"name":"\u5317\u4eac\u5b89\u8054\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"client":{},"user":{},"contact":{},"handlers":[{"id":3,"erp_ticket_change_log_id":3,"user_id":1011,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3"}}],"ticket_type_display":"\u4ed8\u6b3e\u5355","unit":{"id":676,"key":676,"name":"\u5317\u4eac\u5b89\u8054\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"}},{"id":4,"serial_no":"FK-20250804-00003","ticket_type":20012,"wrote_date":"2025-08-04","status":2,"supplier_id":676,"client_id":"","abstract":"","description":"","verify_at":"2025-08-04 17:10:40","created_by":1013,"created_at":"2025-08-04 17:09:32","updated_at":"2025-08-04 17:10:40","contact_id":"","user_id":"","amount":"1888000","object_id":2065,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"supplier":{"id":676,"key":676,"name":"\u5317\u4eac\u5b89\u8054\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"client":{},"user":{},"contact":{},"handlers":[{"id":4,"erp_ticket_change_log_id":4,"user_id":1011,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3"}}],"ticket_type_display":"\u4ed8\u6b3e\u5355","unit":{"id":676,"key":676,"name":"\u5317\u4eac\u5b89\u8054\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"}},{"id":2,"serial_no":"FK-20250804-00002","ticket_type":20012,"wrote_date":"2025-08-04","status":2,"supplier_id":659,"client_id":"","abstract":"","description":"","verify_at":"2025-08-04 16:13:20","created_by":1013,"created_at":"2025-08-04 16:13:20","updated_at":"2025-08-04 16:13:20","contact_id":"","user_id":"","amount":"9250","object_id":2064,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"supplier":{"id":659,"key":659,"name":"\u4f73\u6770\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"},"client":{},"user":{},"contact":{},"handlers":[{"id":2,"erp_ticket_change_log_id":2,"user_id":5360,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3"}}],"ticket_type_display":"\u4ed8\u6b3e\u5355","unit":{"id":659,"key":659,"name":"\u4f73\u6770\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"}},{"id":1,"serial_no":"FK-20250804-00001","ticket_type":20012,"wrote_date":"2025-08-04","status":2,"supplier_id":90,"client_id":"","abstract":"","description":"","verify_at":"2025-08-04 16:12:10","created_by":1013,"created_at":"2025-08-04 16:12:10","updated_at":"2025-08-04 16:12:10","contact_id":"","user_id":"","amount":"31580","object_id":2063,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"client":{},"user":{},"contact":{},"handlers":[{"id":1,"erp_ticket_change_log_id":1,"user_id":5360,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3"}}],"ticket_type_display":"\u4ed8\u6b3e\u5355","unit":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"}},{"id":9,"serial_no":"CGDD-20250804-00001","ticket_type":20001,"wrote_date":"2025-06-23","status":2,"supplier_id":678,"client_id":"","abstract":"","description":"","verify_at":"2025-08-04 11:44:23","created_by":1011,"created_at":"2025-08-04 11:44:23","updated_at":"2025-08-12 14:33:10","contact_id":"","user_id":"","amount":"257633191","object_id":2008,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"supplier":{"id":678,"key":678,"name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"client":{},"user":{},"contact":{},"handlers":[{"id":9,"erp_ticket_change_log_id":9,"user_id":1011,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3"}}],"ticket_type_display":"\u91c7\u8d2d\u8ba2\u5355","unit":{"id":678,"key":678,"name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8"}},{"id":56,"serial_no":"CGDD-20250801-00002","ticket_type":20001,"wrote_date":"2025-08-01","status":2,"supplier_id":676,"client_id":"","abstract":"","description":"","verify_at":"2025-08-01 13:27:49","created_by":1011,"created_at":"2025-08-01 13:27:49","updated_at":"2025-08-14 11:16:09","contact_id":"","user_id":"","amount":"1888000","object_id":2006,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"supplier":{"id":676,"key":676,"name":"\u5317\u4eac\u5b89\u8054\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"client":{},"user":{},"contact":{},"handlers":[{"id":50,"erp_ticket_change_log_id":56,"user_id":1011,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3"}}],"ticket_type_display":"\u91c7\u8d2d\u8ba2\u5355","unit":{"id":676,"key":676,"name":"\u5317\u4eac\u5b89\u8054\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"}},{"id":72,"serial_no":"XJFYD-20250814-00001","ticket_type":20018,"wrote_date":"","status":2,"supplier_id":"","client_id":"","abstract":"6\u6708\u7535\u8bdd\u8d39","description":"","verify_at":"2025-08-14 16:03:52","created_by":1005,"created_at":"2025-07-30 10:00:42","updated_at":"2025-08-14 16:03:52","contact_id":"","user_id":"","amount":"6643","object_id":7348,"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"supplier":{},"client":{},"user":{},"contact":{},"handlers":[{"id":62,"erp_ticket_change_log_id":72,"user_id":1005,"user":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131"}}],"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","unit":{}},{"id":65,"serial_no":"CGDD-20250716-00002","ticket_type":20001,"wrote_date":"2025-07-16","status":2,"supplier_id":715,"client_id":"","abstract":"","description":"","verify_at":"2025-07-16 10:18:43","created_by":1011,"created_at":"2025-07-16 10:18:43","updated_at":"2025-08-14 11:51:30","contact_id":"","user_id":"","amount":"44","object_id":1989,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"supplier":{"id":715,"key":715,"name":"\u5317\u4eac\u81fb\u7d2b\u8f69\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8"},"client":{},"user":{},"contact":{},"handlers":[{"id":56,"erp_ticket_change_log_id":65,"user_id":1011,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3"}}],"ticket_type_display":"\u91c7\u8d2d\u8ba2\u5355","unit":{"id":715,"key":715,"name":"\u5317\u4eac\u81fb\u7d2b\u8f69\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8"}},{"id":7,"serial_no":"CGDD-20240301-00004","ticket_type":20001,"wrote_date":"2024-01-22","status":2,"supplier_id":68,"client_id":"","abstract":"","description":"","verify_at":"2024-03-01 16:48:53","created_by":1011,"created_at":"2024-03-01 16:48:53","updated_at":"2025-08-12 14:21:24","contact_id":"","user_id":"","amount":"94500","object_id":1478,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"client":{},"user":{},"contact":{},"handlers":[{"id":7,"erp_ticket_change_log_id":7,"user_id":1011,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3"}}],"ticket_type_display":"\u91c7\u8d2d\u8ba2\u5355","unit":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"}}],"pagenation":{"totalcount":129,"thispage":7,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-19 10:50:48') RETURNING "id"
10:50:48.206	1.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:50:48.209	1.3 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT r. FROM "a57be577deb434"."tbl_erp_ticket_change_logs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_ticket_change_log_handlers" "rvr" ON rvr.erp_ticket_change_log_id = r.id GROUP BY "r"."id" ORDER BY r.created_at DESC) "c"
10:50:48.210	0.8 ms	yii\db\Command::query	SELECT r.* FROM "a57be577deb434"."tbl_erp_ticket_change_logs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_ticket_change_log_handlers" "rvr" ON rvr.erp_ticket_change_log_id = r.id GROUP BY "r"."id" ORDER BY r.created_at DESC LIMIT 20 OFFSET 120
10:50:48.212	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, 1005, 1013))
10:50:48.213	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (676, 659, 90, 678, 715, 68)
10:50:48.213	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (3, 1, 7)
10:50:48.211	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1013, 1011, 1005)
10:50:48.214	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_ticket_change_log_handlers" WHERE "erp_ticket_change_log_id" IN (3, 4, 2, 1, 9, 56, 72, 65, 7)
10:50:48.214	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5360, 1011, 1005)