Performance Profiling

Total processing time: 34 ms; Peak memory: 5.045 MB. Show Profiling Timeline

总计8条数据

Time	Duration	Category	Info

11:10:50.021	3.1 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT COALESCE(sum(eipss.actual_total_amount), 0) as total_cost, avg(eipss.actual_amount) as cost, esosps.id, esosps.erp_sales_outbound_id, esosps.product_id, esosps.amount - COALESCE(esosps.cancel_amount, 0) as amount, esosps.number - COALESCE(esosps.cancel_number, 0) as number, esosps.total_amount - COALESCE(esosps.cancel_total_amount, 0) as total_amount, project.bargain_date, (sum(eipss.total_amount) - sum(eipss.actual_total_amount)) as total_profit, CASE WHEN sum(eipss.total_amount) > 0 THEN (sum(eipss.total_amount) - sum(eipss.actual_total_amount)) / sum(eipss.total_amount) 100 ELSE null END as profit_pct 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_products" "p" ON esosps.product_id = p.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_spent_product_id = esosps.id WHERE ("t"."status"=2) AND ("project"."created_by" IN (1001, 5049, 5500, 5301, 5499, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND ("p"."id"='2238') AND (eipss.outbound > 0) AND ("project"."bargain_date" >= '2026-01-01 00:00:00') AND ("project"."bargain_date" <= '2026-12-31 23:59:59') AND (((project.budget > project.collected) AND ("project"."project_status" IN ('3', '-1'))) OR ((project.budget <= project.collected) AND ("project"."project_status"=3))) GROUP BY "esosps"."id", "project"."id" ORDER BY "bargain_date" DESC) "c"
11:10:50.031	2.3 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-analysis/sales-product-project-list', '{"produect":"product_name","series":"seriesBudget","project_status":["3","-1"],"period":"currentfascalyear","product_id":"2238","page":"2","web_access_token":"x0LWxNxY1IWpHbWh_3nnhDQVjp8ngz97"}', '{"code":2000,"result":{"list":[],"countArr":{"total_amount":"1759616","total_profit":"52788","profit_pct":"2.99997272132101549400"},"pagenation":{"totalcount":1,"thispage":2,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"39.156.194.178","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/147.0.0.0 Safari\/537.36"}', FALSE, '2026-06-30 11:10:50', 25736960) RETURNING "id"
11:10:50.025	2.2 ms	yii\db\Command::query	SELECT COALESCE(sum(eipss.actual_total_amount), 0) as total_cost, avg(eipss.actual_amount) as cost, esosps.id, esosps.erp_sales_outbound_id, esosps.product_id, esosps.amount - COALESCE(esosps.cancel_amount, 0) as amount, esosps.number - COALESCE(esosps.cancel_number, 0) as number, esosps.total_amount - COALESCE(esosps.cancel_total_amount, 0) as total_amount, project.bargain_date, (sum(eipss.total_amount) - sum(eipss.actual_total_amount)) as total_profit, CASE WHEN sum(eipss.total_amount) > 0 THEN (sum(eipss.total_amount) - sum(eipss.actual_total_amount)) / sum(eipss.total_amount) * 100 ELSE null END as profit_pct 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_products" "p" ON esosps.product_id = p.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_spent_product_id = esosps.id WHERE ("t"."status"=2) AND ("project"."created_by" IN (1001, 5049, 5500, 5301, 5499, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND ("p"."id"='2238') AND (eipss.outbound > 0) AND ("project"."bargain_date" >= '2026-01-01 00:00:00') AND ("project"."bargain_date" <= '2026-12-31 23:59:59') AND (((project.budget > project.collected) AND ("project"."project_status" IN ('3', '-1'))) OR ((project.budget <= project.collected) AND ("project"."project_status"=3))) GROUP BY "esosps"."id", "project"."id" ORDER BY "bargain_date" DESC LIMIT 20 OFFSET 20
11:10:50.027	1.9 ms	yii\db\Command::query	SELECT sum(total_amount) as total_amount, sum(total_profit) as total_profit, CASE WHEN sum(total_amount) > 0 THEN sum(total_profit) / sum(total_amount) * 100 ELSE NULL END as profit_pct FROM (SELECT COALESCE(sum(eipss.actual_total_amount), 0) as total_cost, avg(eipss.actual_amount) as cost, esosps.id, esosps.erp_sales_outbound_id, esosps.product_id, esosps.amount - COALESCE(esosps.cancel_amount, 0) as amount, esosps.number - COALESCE(esosps.cancel_number, 0) as number, esosps.total_amount - COALESCE(esosps.cancel_total_amount, 0) as total_amount, project.bargain_date, (sum(eipss.total_amount) - sum(eipss.actual_total_amount)) as total_profit, CASE WHEN sum(eipss.total_amount) > 0 THEN (sum(eipss.total_amount) - sum(eipss.actual_total_amount)) / sum(eipss.total_amount) * 100 ELSE null END as profit_pct 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_products" "p" ON esosps.product_id = p.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_spent_product_id = esosps.id WHERE ("t"."status"=2) AND ("project"."created_by" IN (1001, 5049, 5500, 5301, 5499, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND ("p"."id"='2238') AND (eipss.outbound > 0) AND ("project"."bargain_date" >= '2026-01-01 00:00:00') AND ("project"."bargain_date" <= '2026-12-31 23:59:59') AND (((project.budget > project.collected) AND ("project"."project_status" IN ('3', '-1'))) OR ((project.budget <= project.collected) AND ("project"."project_status"=3))) GROUP BY "esosps"."id", "project"."id") "sub"
11:10:50.010	0.9 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
11:10:50.012	0.8 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
11:10:50.014	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:10:50.009	0.4 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta