Performance Profiling

Total processing time: 225 ms; Peak memory: 3.770 MB. Show Profiling Timeline

总计37条数据

Time	Duration	Category	Info

14:45:00.897	4.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=5250) AND ("object_type"=20000) AND ("visit_date"='2025-09-23')
14:45:00.847	4.0 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
14:45:00.851	3.8 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=5250
14:45:00.857	2.9 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5250
14:45:00.894	2.0 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_inventory_start_product_id" IN (42, 43)
14:45:00.904	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', 5250, 5, 'vue/erp-inventory-start/product-list', '{"id":"29","page":"1","web_access_token":"3uawlwxh65Fl0RYHt8Wv0NFz9kaCjHtV"}', '{"code":2000,"result":{"list":[{"id":42,"erp_inventory_start_id":29,"erp_store_id":1,"product_id":2087,"description":"","number":"2","outbound":"0","inventory":"0","amount":"70","total_amount":"140","cancel_number":"","cancel_amount":"","cancel_total_amount":"","lost_outbound":"","build_spent_outbound":"","sales_outbound":"","sales_gift_outbound":"","erpStore":{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"},"product":{"id":2087,"name":"\u4e1d\u7ef8\u9f20\u6807\u57ab","product_type":11,"product_component":179,"product_brand":134,"product_serie":1687,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1001,"created_at":"2025-08-08 18:02:20","updated_at":"2025-08-13 17:03:00","pinyin_shortcut":"scsbd","product_unit":3,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":179,"key":179,"name":"\u914d\u4ef6"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":1687,"key":1687,"name":"\u9f20\u6807\u57ab"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpInventoryStartProductSns":[],"erpInventoryProduct":{"id":42,"product_id":2087,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-08-08","number":"2","outbound":"2","inventory":"0","amount":"70","total_amount":"140","actual_amount":"70","actual_total_amount":"0","is_build":false,"created_at":"2025-08-08 18:09:45","lost_outbound":"","erp_inventory_start_id":29,"erp_inventory_start_product_id":42,"erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":""}},{"id":43,"erp_inventory_start_id":29,"erp_store_id":1,"product_id":2088,"description":"","number":"31","outbound":"0","inventory":"0","amount":"15.9","total_amount":"492.9","cancel_number":"","cancel_amount":"","cancel_total_amount":"","lost_outbound":"","build_spent_outbound":"","sales_outbound":"","sales_gift_outbound":"","erpStore":{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"},"product":{"id":2088,"name":"\u54c1\u80dc4\u5408\u4e00\u8bfb\u5361\u5668","product_type":23,"product_component":193,"product_brand":134,"product_serie":1688,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1001,"created_at":"2025-08-08 18:09:16","updated_at":"2025-08-13 17:03:00","pinyin_shortcut":"ps4hydkq","product_unit":3,"is_renew":false,"productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":193,"key":193,"name":"\u6570\u7801\u7535\u5b50\u4ea7\u54c1"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":1688,"key":1688,"name":"\u54c1\u80dc4\u5408\u4e00\u8bfb\u5361\u5668"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpInventoryStartProductSns":[],"erpInventoryProduct":{"id":43,"product_id":2088,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-08-08","number":"31","outbound":"31","inventory":"0","amount":"15.9","total_amount":"492.9","actual_amount":"15.9","actual_total_amount":"0.0","is_build":false,"created_at":"2025-08-08 18:09:45","lost_outbound":"","erp_inventory_start_id":29,"erp_inventory_start_product_id":43,"erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":""}}],"pagenation":{"totalcount":2,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-23 14:45:00') RETURNING "id"
14:45:00.883	1.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_inventory_start_product_id" IN (42, 43)
14:45:00.865	1.4 ms	yii\db\Command::query	SELECT sub.* FROM (SELECT ROW_NUMBER() OVER (ORDER BY created_at DESC) as idx, sub.* FROM (SELECT r.* FROM "a57be577deb434"."tbl_erp_inventory_starts" "r" GROUP BY "r"."id") "sub") "sub" WHERE "id"='29'
14:45:00.863	1.2 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT r. FROM "a57be577deb434"."tbl_erp_inventory_starts" "r" GROUP BY "r"."id") "c"
14:45:00.868	1.1 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)
14:45:00.875	1.1 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (2087, 2088)
14:45:00.902	1.0 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=13, "last_visit_at"='now()' WHERE "id"=56661
14:45:00.889	0.9 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (193, 179)
14:45:00.872	0.7 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "title" AS "name" FROM "a57be577deb434"."tbl_erp_stores" WHERE "id"=1
14:45:00.873	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_inventory_start_products" WHERE "erp_inventory_start_id"=29
14:45:00.878	0.6 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (193, 179)
14:45:00.877	0.6 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (23, 11)
14:45:00.869	0.6 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=4
14:45:00.880	0.6 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1688, 1687)
14:45:00.882	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_inventory_start_product_sns" WHERE "erp_inventory_start_product_id" IN (42, 43)
14:45:00.879	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=134
14:45:00.892	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1688, 1687)
14:45:00.887	0.5 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT FROM "a57be577deb434"."tbl_erp_inventory_start_products" WHERE "erp_inventory_start_id"=29 ORDER BY id) "c"
14:45:00.881	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3
14:45:00.887	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_inventory_start_products" WHERE "erp_inventory_start_id"=29 ORDER BY id LIMIT 20
14:45:00.867	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
14:45:00.870	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1011
14:45:00.866	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_inventory_starts" WHERE "id"='29'
14:45:00.888	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (2087, 2088)
14:45:00.871	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"=1011)
14:45:00.875	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "title" AS "name" FROM "a57be577deb434"."tbl_erp_stores" WHERE "id"=1
14:45:00.889	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (23, 11)
14:45:00.888	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "title" AS "name" FROM "a57be577deb434"."tbl_erp_stores" WHERE "id"=1
14:45:00.872	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=3
14:45:00.893	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_inventory_start_product_sns" WHERE "erp_inventory_start_product_id" IN (42, 43)
14:45:00.892	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3
14:45:00.890	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=134