Performance Profiling

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

总计16条数据

Time	Duration	Category	Info

12:20:41.985	2.5 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"=1234) AND ("t"."status"=2) GROUP BY "esosps"."id", "t"."created_at" ORDER BY "t"."created_at", "esosps"."id"
12:20:41.990	1.9 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":"1234","group":"","web_access_token":"4PRqkvfbFxlQtWIcg4m99LDGwofOdZol"}', '{"code":2000,"result":{"model":{"id":1234,"name":"\u56fd\u7a961573 52%vol\uff08500mL \uff09","product_type":23,"product_component":194,"product_brand":196,"product_serie":818,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-01-12 17:09:38","updated_at":"2026-03-09 14:17:13","pinyin_shortcut":"gj157352vol500mL","product_unit":11,"is_renew":false,"in_out_at":"2026-03-09 14:17:13.804067+08","productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":194,"key":194,"name":"\u70df\u9152\u8336\u53f6"},"productBrand":{"id":196,"key":196,"name":"\u6cf8\u5dde\u8001\u7a96"},"productSerie":{"id":818,"key":818,"name":"\u56fd\u7a961573 52%vol"},"productMisc":"","productUnit":{"id":11,"key":11,"name":"\u74f6"},"productQa":"","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"}},"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:20:41', 23874816) RETURNING "id"
12:20:41.968	1.4 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
12:20:41.970	0.9 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=5250
12:20:41.977	0.9 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='1234'
12:20:41.987	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"=1234) AND ("t"."status"=2)
12:20:41.972	0.8 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
12:20:41.979	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id"=23
12:20:41.983	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=7
12:20:41.974	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
12:20:41.980	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id"=194
12:20:41.981	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id"=818
12:20:41.982	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id"=11
12:20:41.980	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=196
12:20:41.983	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"=1013)
12:20:41.982	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1013