Performance Profiling

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

总计9条数据

Time	Duration	Category	Info

13:59:26.976	2.7 ms	yii\db\Command::query	SELECT prod.id AS dim_key, prod.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 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 "prod"."id", "prod"."name"
13:59:26.972	2.3 ms	yii\db\Command::query	SELECT prod.id AS dim_key, prod.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 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 "prod"."id", "prod"."name"
13:59:26.981	2.1 ms	yii\db\Command::query	SELECT "prod"."id", gb.name AS brand_name, gt.name AS type_name, gc.name AS component_name, gs.name AS serie_name FROM "a57be577deb434"."tbl_products" "prod" LEFT JOIN "a57be577deb434"."tbl_product_brands" "gb" ON gb.id = prod.product_brand LEFT JOIN "a57be577deb434"."tbl_product_types" "gt" ON gt.id = prod.product_type LEFT JOIN "a57be577deb434"."tbl_product_components" "gc" ON gc.id = prod.product_component LEFT JOIN "a57be577deb434"."tbl_product_series" "gs" ON gs.id = prod.product_serie WHERE "prod"."id" IN (2231, 984, 1528, 868, 2253, 1774, 867, 2269, 2227, 1671, 2244, 1890, 2241, 1876, 1148, 1973, 855, 1007, 2228, 870, 1880, 942, 941, 2261, 1882, 1558, 2237, 1096, 851, 2258, 2243, 1942, 2232, 2041, 2230, 2171, 1511, 1340, 1928, 41, 2238, 2233, 587, 1562, 2224, 2259, 2235, 2225, 989, 2236, 1925, 922, 2240, 994, 154, 1929, 1927, 2239, 2257, 969, 1737, 1780, 2177, 1923, 1275, 960, 2260, 2226, 1339)
13:59:26.985	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-model-list', '{"period":"currentfascalyear","page":"1","Filter":{"name":"budget","sort":"DESC"},"web_access_token":"s1xKbg9e3rlah-dvFsDEWCxiJPk9VpSm"}', '{"code":2000,"result":{"list":[{"key":2261,"name":"MK-MC300","budget":"12703072","profit":"12702289.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","brand_name":"\u8054\u60f3","type_name":"\u7f51\u7edc\u8bbe\u5907 ","component_name":"\u534f\u4f5c","serie_name":"\u5168\u5411\u9ea6\u514b\u98ce"},{"key":2238,"name":"WS-S1-MD","budget":"1759616","profit":"52788","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","brand_name":"\u4e2d\u535a\u6570\u667a","type_name":"\u6280\u672f\u670d\u52a1","component_name":"\u4eba\u5de5\u670d\u52a1","serie_name":"\u4e2d\u535a\u6570\u667a\u6280\u672f\u670d\u52a1"},{"key":2237,"name":"ZB-W8G40PXL","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","brand_name":"\u4e2d\u535a\u6570\u667a","type_name":"\u670d\u52a1\u5668","component_name":"\u667a\u7b97\u4e00\u4f53\u673a","serie_name":"\u5168\u6db2\u51b7\u667a\u7b97\u4e00\u4f53\u673a"},{"key":2240,"name":"WS-S1-SNGIO","budget":"678046","profit":"20342","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","brand_name":"\u4e2d\u535a\u6570\u667a","type_name":"\u6280\u672f\u670d\u52a1","component_name":"\u4eba\u5de5\u670d\u52a1","serie_name":"\u4e2d\u535a\u6570\u667a\u6280\u672f\u670d\u52a1"},{"key":1942,"name":"\u58f9\u8fdb\u5236\u9ed1\u65b9\u5bb9\u707e\u5907\u4efd\u4e0e\u6062\u590d\u7cfb\u7edf\u8f6f\u4ef6 V6","budget":"568521","profit":"318521","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","brand_name":"\u58f9\u8fdb\u5236","type_name":"\u8f6f\u4ef6","component_name":"\u5907\u4efd\u8f6f\u4ef6","serie_name":"\u58f9\u8fdb\u5236\u9ed1\u65b9\u5bb9\u707e\u5907\u4efd\u4e0e\u6062\u590d\u7cfb\u7edf\u8f6f\u4ef6 V6.0"},{"key":2231,"name":"PAN-PA-3440-ATP-3YR","budget":"399484","profit":"155896","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","brand_name":"PaloAlto","type_name":"\u5b89\u5168\u8bbe\u5907","component_name":"PA\u8bb8\u53ef\u8bc1","serie_name":"PA3440\u8f6f\u4ef6\u6388\u6743"},{"key":2241,"name":"XMS1000","budget":"312000","profit":"47700","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","brand_name":"\u5c0f\u9c7c\u6613\u8fde","type_name":"\u7f51\u7edc\u8bbe\u5907 ","component_name":"\u534f\u4f5c","serie_name":"\u89c6\u9891\u4f1a\u8bae\u5e73\u53f0"},{"key":2230,"name":"PAN-PA-3440","budget":"275603","profit":"106055","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","brand_name":"PaloAlto","type_name":"\u5b89\u5168\u8bbe\u5907","component_name":"\u9632\u706b\u5899\u4e3b\u673a","serie_name":"PA-3440\u9632\u706b\u5899\u4e3b\u673a"},{"key":1973,"name":"PAN-PA-1410-BND-CORESEC-3YR","budget":"260000","profit":"81864","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","brand_name":"PaloAlto","type_name":"\u5b89\u5168\u8bbe\u5907","component_name":"\u9632\u706b\u5899\u8f6f\u4ef6","serie_name":"PA-1410\u4e09\u5e74\u670d\u52a1"},{"key":2232,"name":"PAN-SVC-BKLN-3440-3YR","budget":"210375","profit":"82097","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","brand_name":"PaloAlto","type_name":"\u5b89\u5168\u8bbe\u5907","component_name":"\u9632\u706b\u5899\u670d\u52a1","serie_name":"\u4e09\u5e74\u670d\u52a1"}],"pagenation":{"totalcount":69,"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:59:26', 26729984) RETURNING "id"
13:59:26.961	1.0 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
13:59:26.979	1.0 ms	yii\db\Command::query	SELECT prod.id AS dim_key, prod.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 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 "prod"."id", "prod"."name"
13:59:26.964	0.8 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
13:59:26.966	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
13:59:26.961	0.5 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta