Performance Profiling

Total processing time: 99 ms; Peak memory: 5.495 MB. Show Profiling Timeline

总计61条数据

Time	Duration	Category	Info

15:15:11.508	3.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=20000) AND ("visit_date"='2025-09-03')
15:15:11.465	3.2 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
15:15:11.481	2.4 ms	yii\db\Command::query	SELECT SUM(amount - settle_amount) FROM "a57be577deb434"."tbl_erp_cash_cost_tickets"
15:15:11.463	2.4 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:15:11.470	2.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:15:11.513	1.7 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', 1001, 5, 'vue/erp-analysis/boss', '{"web_access_token":"0jSj1j1zfu5hwB0xpQULAh1cJmt2onlX"}', '{"code":2000,"result":{"un_collect":19020733.06,"un_payment":89012646382.52,"balance_amount":"88690121152.08","inventory_amount":"89494393.9736","profit":24150800.08,"in":33876933.336,"out":9794478.92,"banksCircle":[{"key":1,"name":"\u652f\u4ed8\u5b9d","value":"88681121076.08","y":99.99},{"key":3,"name":"\u73b0\u91d1","value":"8999998","y":0.01},{"key":2,"name":"\u94f6\u884c\u5b58\u6b3e","value":"78","y":0}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-03 15:15:11') RETURNING "id"
15:15:11.475	1.5 ms	yii\db\Command::query	SELECT SUM(erp_un_settle_amount) FROM "a57be577deb434"."tbl_sales_contracts"
15:15:11.494	1.5 ms	yii\db\Command::query	SELECT SUM(t.settle_amount) FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-20 17:41:03')
15:15:11.503	1.4 ms	yii\db\Command::query	SELECT SUM(t.settle_amount) FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-20 17:41:03')
15:15:11.491	0.9 ms	yii\db\Command::query	SELECT SUM(esrps.total_actual_amount) FROM "a57be577deb434"."tbl_erp_sales_return_products" "esrps" LEFT JOIN "a57be577deb434"."tbl_erp_sales_returns" "t" ON esrps.erp_sales_return_id = t.id WHERE "t"."status"=2
15:15:11.478	0.9 ms	yii\db\Command::query	SELECT SUM(erp_un_settle_amount) FROM "a57be577deb434"."tbl_purchase_contracts"
15:15:11.512	0.9 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=124, "last_visit_at"='now()' WHERE "id"=55437
15:15:11.487	0.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"=410406
15:15:11.489	0.6 ms	yii\db\Command::query	SELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE "t"."status"=2
15:15:11.497	0.5 ms	yii\db\Command::query	SELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = t.id WHERE "t"."status"=2
15:15:11.477	0.5 ms	yii\db\Command::query	SELECT SUM(amount - settle_amount) FROM "a57be577deb434"."tbl_erp_other_income_tickets"
15:15:11.489	0.5 ms	yii\db\Command::query	SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" WHERE "t"."status"=2
15:15:11.505	0.4 ms	yii\db\Command::query	SELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = t.id WHERE "t"."status"=2
15:15:11.490	0.4 ms	yii\db\Command::query	SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_purchase_returns" "t" WHERE "t"."status"=2
15:15:11.480	0.4 ms	yii\db\Command::query	SELECT SUM(amount - settle_amount) FROM "a57be577deb434"."tbl_erp_other_payment_tickets"
15:15:11.479	0.4 ms	yii\db\Command::query	SELECT SUM(amount - settle_amount) FROM "a57be577deb434"."tbl_erp_advance_payment_tickets"
15:15:11.483	0.4 ms	yii\db\Command::query	SELECT SUM(amount - settle_amount) FROM "a57be577deb434"."tbl_erp_wage_tickets"
15:15:11.484	0.4 ms	yii\db\Command::query	SELECT SUM(amount - settle_amount) FROM "a57be577deb434"."tbl_erp_social_insurances"
15:15:11.495	0.4 ms	yii\db\Command::query	SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_losts" "t" WHERE "t"."status"=2
15:15:11.484	0.4 ms	yii\db\Command::query	SELECT SUM(amount - settle_amount) FROM "a57be577deb434"."tbl_erp_provident_funds"
15:15:11.499	0.4 ms	yii\db\Command::query	SELECT SUM(t.out_amount) FROM "a57be577deb434"."tbl_erp_inventory_builds" "t" WHERE "t"."status"=2
15:15:11.485	0.4 ms	yii\db\Command::query	SELECT SUM(amount - settle_amount) FROM "a57be577deb434"."tbl_erp_personal_taxs"
15:15:11.497	0.4 ms	yii\db\Command::query	SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_purchase_gifts" "t" WHERE "t"."status"=2
15:15:11.485	0.4 ms	yii\db\Command::query	SELECT SUM(amount - settle_amount) FROM "a57be577deb434"."tbl_erp_wage_prizes"
15:15:11.496	0.3 ms	yii\db\Command::query	SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" WHERE "t"."status"=2
15:15:11.486	0.3 ms	yii\db\Command::query	SELECT SUM(inventory * actual_amount) FROM "a57be577deb434"."tbl_erp_inventory_products"
15:15:11.502	0.3 ms	yii\db\Command::query	SELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE "t"."status"=2
15:15:11.480	0.3 ms	yii\db\Command::query	SELECT SUM(amount - settle_amount) FROM "a57be577deb434"."tbl_erp_cost_tickets"
15:15:11.502	0.3 ms	yii\db\Command::query	SELECT SUM(esrps.total_actual_amount) FROM "a57be577deb434"."tbl_erp_sales_return_products" "esrps" LEFT JOIN "a57be577deb434"."tbl_erp_sales_returns" "t" ON esrps.erp_sales_return_id = t.id WHERE "t"."status"=2
15:15:11.500	0.3 ms	yii\db\Command::query	SELECT SUM(esrps.total_actual_amount) FROM "a57be577deb434"."tbl_erp_sales_return_products" "esrps" LEFT JOIN "a57be577deb434"."tbl_erp_sales_returns" "t" ON esrps.erp_sales_return_id = t.id WHERE "t"."status"=2
15:15:11.486	0.3 ms	yii\db\Command::query	SELECT SUM(balance_amount) FROM "a57be577deb434"."tbl_erp_banks"
15:15:11.488	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"=410102
15:15:11.506	0.2 ms	yii\db\Command::query	SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_personal_taxs" "t" WHERE "t"."status"=2
15:15:11.492	0.2 ms	yii\db\Command::query	SELECT SUM(t.settle_amount) FROM "a57be577deb434"."tbl_erp_other_income_tickets" "t" WHERE "t"."status"=2
15:15:11.496	0.2 ms	yii\db\Command::query	SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_wage_tickets" "t" WHERE "t"."status"=2
15:15:11.498	0.2 ms	yii\db\Command::query	SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_personal_taxs" "t" WHERE "t"."status"=2
15:15:11.502	0.2 ms	yii\db\Command::query	SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_purchase_returns" "t" WHERE "t"."status"=2
15:15:11.492	0.2 ms	yii\db\Command::query	SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE "t"."status"=2
15:15:11.507	0.2 ms	yii\db\Command::query	SELECT b.id as key, b.title as name, balance_amount as value FROM "a57be577deb434"."tbl_erp_banks" "b" WHERE "is_delete"=FALSE
15:15:11.503	0.2 ms	yii\db\Command::query	SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE "t"."status"=2
15:15:11.500	0.2 ms	yii\db\Command::query	SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" WHERE "t"."status"=2
15:15:11.498	0.2 ms	yii\db\Command::query	SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_social_insurances" "t" WHERE "t"."status"=2
15:15:11.505	0.2 ms	yii\db\Command::query	SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_wage_tickets" "t" WHERE "t"."status"=2
15:15:11.488	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"=410101
15:15:11.500	0.2 ms	yii\db\Command::query	SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_builds" "t" WHERE "t"."status"=2
15:15:11.507	0.2 ms	yii\db\Command::query	SELECT SUM(t.out_amount) FROM "a57be577deb434"."tbl_erp_inventory_builds" "t" WHERE "t"."status"=2
15:15:11.499	0.2 ms	yii\db\Command::query	SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_provident_funds" "t" WHERE "t"."status"=2
15:15:11.506	0.2 ms	yii\db\Command::query	SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_social_insurances" "t" WHERE "t"."status"=2
15:15:11.501	0.2 ms	yii\db\Command::query	SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" WHERE "t"."status"=2
15:15:11.501	0.2 ms	yii\db\Command::query	SELECT SUM(t.settle_amount) FROM "a57be577deb434"."tbl_erp_other_income_tickets" "t" WHERE "t"."status"=2
15:15:11.505	0.2 ms	yii\db\Command::query	SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_losts" "t" WHERE "t"."status"=2
15:15:11.501	0.2 ms	yii\db\Command::query	SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_builds" "t" WHERE "t"."status"=2
15:15:11.498	0.2 ms	yii\db\Command::query	SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_wage_prizes" "t" WHERE "t"."status"=2
15:15:11.506	0.2 ms	yii\db\Command::query	SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_wage_prizes" "t" WHERE "t"."status"=2
15:15:11.501	0.2 ms	yii\db\Command::query	SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_purchase_gifts" "t" WHERE "t"."status"=2
15:15:11.507	0.2 ms	yii\db\Command::query	SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_provident_funds" "t" WHERE "t"."status"=2