Performance Profiling

Total processing time: 28 ms; Peak memory: 3.369 MB. Show Profiling Timeline

总计16条数据

Time	Duration	Category	Info

12:11:45.783	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", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-inventory-product/product-line', '{"id":"2086","group":"","web_access_token":"4PRqkvfbFxlQtWIcg4m99LDGwofOdZol"}', '{"code":2000,"result":{"model":{"id":2086,"name":"INTEL S3520 \u7cfb\u5217\u56fa\u6001\u786c\u76d82.5\u82f1\u5bf8 240G","product_type":2,"product_component":5,"product_brand":5,"product_serie":1686,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1001,"created_at":"2025-08-08 17:55:14","updated_at":"2025-08-08 17:55:30","pinyin_shortcut":"INTELS3520xlgtyp25yc240G","product_unit":3,"is_renew":false,"in_out_at":"2025-08-08 17:55:30+08","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":5,"key":5,"name":"\u670d\u52a1\u5668\u786c\u76d8"},"productBrand":{"id":5,"key":5,"name":"\u82f1\u7279\u5c14"},"productSerie":{"id":1686,"key":1686,"name":"\u56fa\u6001\u786c\u76d8"},"productMisc":"","productUnit":{"id":3,"key":3,"name":"\u4e2a"},"productQa":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"sales_cost":"0","sales_amount":"0","profit":0,"profit_pct":0},"category":{"amountCategory":[],"costCategory":[]},"seriesAmount":[],"seriesCost":[]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.25","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/149.0.0.0 Safari\/537.36"}', FALSE, '2026-06-25 12:11:45', 20847104) RETURNING "id"
12:11:45.779	1.0 ms	yii\db\Command::query	SELECT esosps.id, esosps.erp_sales_outbound_id, esosps.product_id, t.created_at, sum(eipss.total_amount) as amount, sum(eipss.actual_total_amount) as cost FROM "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "esosps" LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "t" ON esosps.erp_sales_outbound_id = t.id LEFT JOIN "a57be577deb434"."tbl_projects" "project" ON project.id = t.project_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_spent_product_id = esosps.id WHERE ("esosps"."product_id"=2086) AND ("t"."status"=2) GROUP BY "esosps"."id", "t"."created_at" ORDER BY "t"."created_at", "esosps"."id"
12:11:45.765	0.9 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=5250
12:11:45.774	0.8 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id"=2
12:11:45.781	0.8 ms	yii\db\Command::query	SELECT COALESCE(sum(eipss.actual_total_amount), 0) as outbound_cost, COALESCE(sum(eipss.total_amount), 0) as outbound_amount FROM "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "esosps" LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "t" ON esosps.erp_sales_outbound_id = t.id LEFT JOIN "a57be577deb434"."tbl_projects" "project" ON project.id = t.project_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_spent_product_id = esosps.id WHERE ("esosps"."product_id"=2086) AND ("t"."status"=2)
12:11:45.767	0.7 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
12:11:45.769	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
12:11:45.765	0.4 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
12:11:45.773	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2086'
12:11:45.776	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id"=1686
12:11:45.778	0.3 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"=1001)
12:11:45.775	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id"=5
12:11:45.776	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=5
12:11:45.777	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
12:11:45.777	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3
12:11:45.779	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=4