Performance Profiling

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

总计8条数据

Time	Duration	Category	Info

13:58:43.035	2.6 ms	yii\db\Command::query	SELECT gc.id AS dim_key, gc.name AS name, COALESCE(SUM(eipss.total_amount), 0) AS budget, COALESCE(SUM(eipss.total_amount - COALESCE(eipss.actual_total_amount, 0)), 0) AS profit FROM "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" INNER JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "t" ON t.id = eipss.erp_sales_outbound_id INNER JOIN "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "sp" ON sp.id = eipss.erp_sales_outbound_spent_product_id INNER JOIN "a57be577deb434"."tbl_products" "prod" ON prod.id = sp.product_id LEFT JOIN "a57be577deb434"."tbl_product_components" "gc" ON gc.id = prod.product_component WHERE ("t"."status"=2) AND ("eipss"."erp_sales_outbound_spent_product_id" IS NOT NULL) AND ("t"."created_at" >= '2025-07-11') AND ("t"."created_at" <= '2025-12-31 23:59:59') GROUP BY "gc"."id", "gc"."name"
13:58:43.032	2.2 ms	yii\db\Command::query	SELECT gc.id AS dim_key, gc.name AS name, COALESCE(SUM(eipss.total_amount), 0) AS budget, COALESCE(SUM(eipss.total_amount - COALESCE(eipss.actual_total_amount, 0)), 0) AS profit FROM "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" INNER JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "t" ON t.id = eipss.erp_sales_outbound_id INNER JOIN "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "sp" ON sp.id = eipss.erp_sales_outbound_spent_product_id INNER JOIN "a57be577deb434"."tbl_products" "prod" ON prod.id = sp.product_id LEFT JOIN "a57be577deb434"."tbl_product_components" "gc" ON gc.id = prod.product_component WHERE ("t"."status"=2) AND ("eipss"."erp_sales_outbound_spent_product_id" IS NOT NULL) AND ("t"."created_at" >= '2026-01-01') AND ("t"."created_at" <= '2026-12-31 23:59:59') GROUP BY "gc"."id", "gc"."name"
13:58:43.041	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/smart-board/product-component-list', '{"period":"currentfascalyear","page":"1","Filter":{"name":"budget","sort":"DESC"},"web_access_token":"s1xKbg9e3rlah-dvFsDEWCxiJPk9VpSm"}', '{"code":2000,"result":{"list":[{"key":52,"name":"\u534f\u4f5c","budget":"13036952","profit":"12749644.795","prev_budget":"0","prev_profit":"0","prev_budget_growth":"1","prev_profit_growth":"1","last_budget":"0","last_profit":"0","budget_growth":"1","profit_growth":"1"},{"key":151,"name":"\u4eba\u5de5\u670d\u52a1","budget":"2710226","profit":"165808","prev_budget":"1665729","prev_profit":"1065151","prev_budget_growth":0.627,"prev_profit_growth":-0.8443,"last_budget":"0","last_profit":"0","budget_growth":"1","profit_growth":"1"},{"key":226,"name":"\u667a\u7b97\u4e00\u4f53\u673a","budget":"1220108","profit":"36604","prev_budget":"0","prev_profit":"0","prev_budget_growth":"1","prev_profit_growth":"1","last_budget":"0","last_profit":"0","budget_growth":"1","profit_growth":"1"},{"key":30,"name":"\u5907\u4efd\u8f6f\u4ef6","budget":"654621.2","profit":"355829.2","prev_budget":"136950","prev_profit":"85690","prev_budget_growth":3.78,"prev_profit_growth":3.1525,"last_budget":"0","last_profit":"0","budget_growth":"1","profit_growth":"1"},{"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a","budget":"621501","profit":"177718.8","prev_budget":"527660","prev_profit":"109897.00","prev_budget_growth":0.1778,"prev_profit_growth":0.6171,"last_budget":"0","last_profit":"0","budget_growth":"1","profit_growth":"1"},{"key":36,"name":"PA\u8bb8\u53ef\u8bc1","budget":"553118","profit":"206590","prev_budget":"629020.99","prev_profit":"92868.99","prev_budget_growth":-0.1206,"prev_profit_growth":1.2245,"last_budget":"0","last_profit":"0","budget_growth":"1","profit_growth":"1"},{"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6","budget":"443712","profit":"129316","prev_budget":"354219.4","prev_profit":"53191.00","prev_budget_growth":0.2526,"prev_profit_growth":1.4311,"last_budget":"0","last_profit":"0","budget_growth":"1","profit_growth":"1"},{"key":214,"name":"\u9632\u706b\u5899\u670d\u52a1","budget":"210375","profit":"82097","prev_budget":"457510","prev_profit":"373937.00","prev_budget_growth":-0.5401,"prev_profit_growth":-0.7804,"last_budget":"0","last_profit":"0","budget_growth":"1","profit_growth":"1"},{"key":48,"name":"\u6570\u636e\u5e93","budget":"137520","profit":"31520","prev_budget":"0","prev_profit":"0","prev_budget_growth":"1","prev_profit_growth":"1","last_budget":"0","last_profit":"0","budget_growth":"1","profit_growth":"1"},{"key":169,"name":"\u5b89\u5168\u6258\u7ba1\u670d\u52a1","budget":"117000","profit":"40080","prev_budget":"0","prev_profit":"0","prev_budget_growth":"1","prev_profit_growth":"1","last_budget":"0","last_profit":"0","budget_growth":"1","profit_growth":"1"}],"pagenation":{"totalcount":35,"thispage":1,"pagesize":10}},"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; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-06-23 13:58:43', 24047872) RETURNING "id"
13:58:43.038	1.2 ms	yii\db\Command::query	SELECT gc.id AS dim_key, gc.name AS name, COALESCE(SUM(eipss.total_amount), 0) AS budget, COALESCE(SUM(eipss.total_amount - COALESCE(eipss.actual_total_amount, 0)), 0) AS profit FROM "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" INNER JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "t" ON t.id = eipss.erp_sales_outbound_id INNER JOIN "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "sp" ON sp.id = eipss.erp_sales_outbound_spent_product_id INNER JOIN "a57be577deb434"."tbl_products" "prod" ON prod.id = sp.product_id LEFT JOIN "a57be577deb434"."tbl_product_components" "gc" ON gc.id = prod.product_component WHERE ("t"."status"=2) AND ("eipss"."erp_sales_outbound_spent_product_id" IS NOT NULL) AND ("t"."created_at" >= '2025-01-01') AND ("t"."created_at" <= '2025-06-23 23:59:59') GROUP BY "gc"."id", "gc"."name"
13:58:43.020	1.0 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
13:58:43.023	0.8 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
13:58:43.024	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
13:58:43.020	0.5 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta