ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a43896c16f5b: POST https://beta.jinchangxiao.com/ledger/report/list-cash-flow at 2026-06-30 05:16:28 pm by 39.156.194.178

Performance Profiling

Total processing time: 40 ms; Peak memory: 2.411 MB. Show Profiling Timeline

总计11条数据
TimeDurationCategoryInfo
  
17:16:28.0995.5 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:16:28.1164.9 msyii\db\Command::querySELECT CASE WHEN COALESCE(i.credit_amount, 0) <> 0 THEN a.ledger_cash_in_item_id WHEN COALESCE(i.debit_amount, 0) <> 0 THEN a.ledger_cash_out_item_id ELSE NULL END AS "flow_item_id", COALESCE(sum(i.debit_amount), 0) AS "debit_amount", COALESCE(sum(i.credit_amount), 0) AS "credit_amount" FROM "a57be577deb434"."tbl_ledger_ticket_items" "i" INNER JOIN "a57be577deb434"."tbl_ledger_tickets" "t" ON i.ledger_ticket_id = t.id INNER JOIN "a57be577deb434"."tbl_ledger_account_captions" "a" ON i.ledger_account_caption_id = a.id WHERE (("t"."ledger_id"='1') AND ("t"."status"=1)) AND (("a"."ledger_id"='1') AND ("a"."is_cash_equivalent"=FALSE)) AND ("t"."ticket_date" >= '2026-06-01') AND ("t"."ticket_date" <= '2026-06-30') AND ("t"."id" IN (SELECT "i2"."ledger_ticket_id" FROM "a57be577deb434"."tbl_ledger_ticket_items" "i2" INNER JOIN "a57be577deb434"."tbl_ledger_account_captions" "a2" ON i2.ledger_account_caption_id = a2.id WHERE ("a2"."ledger_id"='1') AND ("a2"."is_cash_equivalent"=TRUE) GROUP BY "i2"."ledger_ticket_id")) AND (((NOT ("a"."ledger_cash_in_item_id" IS NULL)) AND ("i"."credit_amount" <> 0)) OR ((NOT ("a"."ledger_cash_out_item_id" IS NULL)) AND ("i"."debit_amount" <> 0))) GROUP BY CASE WHEN COALESCE(i.credit_amount, 0) <> 0 THEN a.ledger_cash_in_item_id WHEN COALESCE(i.debit_amount, 0) <> 0 THEN a.ledger_cash_out_item_id ELSE NULL END
17:16:28.1043.3 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "ledger_access_token"='fm5QrMzndTK8qE2wxJ4UQJeJaYto4p5c'
17:16:28.1282.3 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 6, 'ledger/report/list-cash-flow', '{"access_token":"fm5QrMzndTK8qE2wxJ4UQJeJaYto4p5c","ledger_id":"1","period_start":"2026-06","period_end":"2026-06","show_last_year_accumulated":"0","web_access_token":"fm5QrMzndTK8qE2wxJ4UQJeJaYto4p5c"}', '{"code":2000,"result":{"list":[{"item_name":"\u4e00\u3001\u7ecf\u8425\u6d3b\u52a8\u4ea7\u751f\u7684\u73b0\u91d1\u6d41\u91cf\uff1a","line_no":1,"index":1,"level":0,"year_amount":"","month_amount":""},{"item_name":"\u9500\u552e\u5546\u54c1\u3001\u63d0\u4f9b\u52b3\u52a1\u6536\u5230\u7684\u73b0\u91d1","line_no":2,"index":2,"level":1,"year_amount":103,"month_amount":0},{"item_name":"\u6536\u5230\u7684\u7a0e\u8d39\u8fd4\u8fd8","line_no":3,"index":2,"level":1,"year_amount":0,"month_amount":0},{"item_name":"\u6536\u5230\u5176\u4ed6\u4e0e\u7ecf\u8425\u6d3b\u52a8\u6709\u5173\u7684\u73b0\u91d1","line_no":4,"index":2,"level":1,"year_amount":9,"month_amount":0},{"item_name":"\u7ecf\u8425\u6d3b\u52a8\u73b0\u91d1\u6d41\u5165\u5c0f\u8ba1","line_no":5,"index":2,"level":1,"year_amount":112,"month_amount":0},{"item_name":"\u8d2d\u4e70\u5546\u54c1\u3001\u63a5\u53d7\u52b3\u52a1\u652f\u4ed8\u7684\u73b0\u91d1","line_no":6,"index":2,"level":1,"year_amount":1056,"month_amount":0},{"item_name":"\u652f\u4ed8\u7ed9\u804c\u5de5\u4ee5\u53ca\u4e3a\u804c\u5de5\u652f\u4ed8\u7684\u73b0\u91d1","line_no":7,"index":2,"level":1,"year_amount":23,"month_amount":0},{"item_name":"\u652f\u4ed8\u7684\u5404\u9879\u7a0e\u8d39","line_no":8,"index":2,"level":1,"year_amount":0,"month_amount":0},{"item_name":"\u652f\u4ed8\u5176\u4ed6\u4e0e\u7ecf\u8425\u6d3b\u52a8\u6709\u5173\u7684\u73b0\u91d1","line_no":9,"index":2,"level":1,"year_amount":0,"month_amount":0},{"item_name":"\u7ecf\u8425\u6d3b\u52a8\u73b0\u91d1\u6d41\u51fa\u5c0f\u8ba1","line_no":10,"index":2,"level":1,"year_amount":1079,"month_amount":0},{"item_name":"\u7ecf\u8425\u6d3b\u52a8\u4ea7\u751f\u7684\u73b0\u91d1\u6d41\u91cf\u51c0\u989d","line_no":11,"index":2,"level":1,"year_amount":-967,"month_amount":0},{"item_name":"\u4e8c\u3001\u6295\u8d44\u6d3b\u52a8\u4ea7\u751f\u7684\u73b0\u91d1\u6d41\u91cf\uff1a","line_no":12,"index":1,"level":0,"year_amount":"","month_amount":""},{"item_name":"\u6536\u56de\u6295\u8d44\u6536\u5230\u7684\u73b0\u91d1","line_no":13,"index":2,"level":1,"year_amount":0,"month_amount":0},{"item_name":"\u53d6\u5f97\u6295\u8d44\u6536\u76ca\u6536\u5230\u7684\u73b0\u91d1","line_no":14,"index":2,"level":1,"year_amount":0,"month_amount":0},{"item_name":"\u5904\u7f6e\u56fa\u5b9a\u8d44\u4ea7\u3001\u65e0\u5f62\u8d44\u4ea7\u548c\u5176\u4ed6\u957f\u671f\u8d44\u4ea7\u6536\u56de\u7684\u73b0\u91d1\u51c0\u989d","line_no":15,"index":2,"level":1,"year_amount":0,"month_amount":0},{"item_name":"\u5904\u7f6e\u5b50\u516c\u53f8\u53ca\u5176\u4ed6\u8425\u4e1a\u5355\u4f4d\u6536\u5230\u7684\u73b0\u91d1\u51c0\u989d","line_no":16,"index":2,"level":1,"year_amount":0,"month_amount":0},{"item_name":"\u6536\u5230\u5176\u4ed6\u4e0e\u6295\u8d44\u6d3b\u52a8\u6709\u5173\u7684\u73b0\u91d1","line_no":17,"index":2,"level":1,"year_amount":0,"month_amount":0},{"item_name":"\u6295\u8d44\u6d3b\u52a8\u73b0\u91d1\u6d41\u5165\u5c0f\u8ba1","line_no":18,"index":2,"level":1,"year_amount":0,"month_amount":0},{"item_name":"\u8d2d\u5efa\u56fa\u5b9a\u8d44\u4ea7\u3001\u65e0\u5f62\u8d44\u4ea7\u548c\u5176\u4ed6\u957f\u671f\u8d44\u4ea7\u6240\u652f\u4ed8\u7684\u73b0\u91d1","line_no":19,"index":2,"level":1,"year_amount":0,"month_amount":0},{"item_name":"\u6295\u8d44\u652f\u4ed8\u7684\u73b0\u91d1","line_no":20,"index":2,"level":1,"year_amount":0,"month_amount":0},{"item_name":"\u53d6\u5f97\u5b50\u516c\u53f8\u53ca\u5176\u4ed6\u8425\u4e1a\u5355\u4f4d\u652f\u4ed8\u7684\u73b0\u91d1\u51c0\u989d","line_no":21,"index":2,"level":1,"year_amount":0,"month_amount":0},{"item_name":"\u652f\u4ed8\u7684\u5176\u4ed6\u4e0e\u6295\u8d44\u6d3b\u52a8\u6709\u5173\u7684\u73b0\u91d1","line_no":22,"index":2,"level":1,"year_amount":0,"month_amount":0},{"item_name":"\u6295\u8d44\u6d3b\u52a8\u73b0\u91d1\u6d41\u51fa\u5c0f\u8ba1","line_no":23,"index":2,"level":1,"year_amount":0,"month_amount":0},{"item_name":"\u6295\u8d44\u6d3b\u52a8\u4ea7\u751f\u7684\u73b0\u91d1\u6d41\u91cf\u51c0\u989d","line_no":24,"index":2,"level":1,"year_amount":0,"month_amount":0},{"item_name":"\u4e09\u3001\u7b79\u8d44\u6d3b\u52a8\u4ea7\u751f\u7684\u73b0\u91d1\u6d41\u91cf\uff1a","line_no":25,"index":1,"level":0,"year_amount":"","month_amount":""},{"item_name":"\u5438\u6536\u6295\u8d44\u6536\u5230\u7684\u73b0\u91d1","line_no":26,"index":2,"level":1,"year_amount":0,"month_amount":0},{"item_name":"\u53d6\u5f97\u501f\u6b3e\u6536\u5230\u7684\u73b0\u91d1","line_no":27,"index":2,"level":1,"year_amount":0,"month_amount":0},{"item_name":"\u6536\u5230\u5176\u4ed6\u4e0e\u7b79\u8d44\u6d3b\u52a8\u6709\u5173\u7684\u73b0\u91d1","line_no":28,"index":2,"level":1,"year_amount":0,"month_amount":0},{"item_name":"\u7b79\u8d44\u6d3b\u52a8\u73b0\u91d1\u6d41\u5165\u5c0f\u8ba1","line_no":29,"index":2,"level":1,"year_amount":0,"month_amount":0},{"item_name":"\u507f\u8fd8\u503a\u52a1\u652f\u4ed8\u7684\u73b0\u91d1","line_no":30,"index":2,"level":1,"year_amount":0,"month_amount":0},{"item_name":"\u5206\u914d\u80a1\u5229\u3001\u5229\u6da6\u6216\u507f\u4ed8\u5229\u606f\u652f\u4ed8\u7684\u73b0\u91d1","line_no":31,"index":2,"level":1,"year_amount":-5,"month_amount":0},{"item_name":"\u652f\u4ed8\u5176\u4ed6\u4e0e\u7b79\u8d44\u6d3b\u52a8\u6709\u5173\u7684\u73b0\u91d1","line_no":32,"index":2,"level":1,"year_amount":0,"month_amount":0},{"item_name":"\u7b79\u8d44\u6d3b\u52a8\u73b0\u91d1\u6d41\u51fa\u5c0f\u8ba1","line_no":33,"index":2,"level":1,"year_amount":-5,"month_amount":0},{"item_name":"\u7b79\u8d44\u6d3b\u52a8\u4ea7\u751f\u7684\u73b0\u91d1\u6d41\u91cf\u51c0\u989d","line_no":34,"index":2,"level":1,"year_amount":5,"month_amount":0},{"item_name":"\u56db\u3001\u6c47\u7387\u53d8\u52a8\u5bf9\u73b0\u91d1\u53ca\u73b0\u91d1\u7b49\u4ef7\u7269\u7684\u5f71\u54cd","line_no":35,"index":2,"level":0,"year_amount":0,"month_amount":0},{"item_name":"\u4e94\u3001\u73b0\u91d1\u53ca\u73b0\u91d1\u7b49\u4ef7\u7269\u51c0\u589e\u52a0\u989d","line_no":36,"index":2,"level":0,"year_amount":-962,"month_amount":0},{"item_name":"\u52a0\uff1a\u671f\u521d\u73b0\u91d1\u53ca\u73b0\u91d1\u7b49\u4ef7\u7269\u4f59\u989d","line_no":37,"index":2,"level":1,"year_amount":2391689.33,"month_amount":2390727.33},{"item_name":"\u516d\u3001\u671f\u672b\u73b0\u91d1\u53ca\u73b0\u91d1\u7b49\u4ef7\u7269\u4f59\u989d","line_no":38,"index":2,"level":0,"year_amount":2390727.33,"month_amount":2390727.33}]},"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; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-06-30 17:16:28', 32846848) RETURNING "id"
17:16:28.1092.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:16:28.1211.6 msyii\db\Command::querySELECT CASE WHEN COALESCE(i.credit_amount, 0) <> 0 THEN a.ledger_cash_in_item_id WHEN COALESCE(i.debit_amount, 0) <> 0 THEN a.ledger_cash_out_item_id ELSE NULL END AS "flow_item_id", COALESCE(sum(i.debit_amount), 0) AS "debit_amount", COALESCE(sum(i.credit_amount), 0) AS "credit_amount" FROM "a57be577deb434"."tbl_ledger_ticket_items" "i" INNER JOIN "a57be577deb434"."tbl_ledger_tickets" "t" ON i.ledger_ticket_id = t.id INNER JOIN "a57be577deb434"."tbl_ledger_account_captions" "a" ON i.ledger_account_caption_id = a.id WHERE (("t"."ledger_id"='1') AND ("t"."status"=1)) AND (("a"."ledger_id"='1') AND ("a"."is_cash_equivalent"=FALSE)) AND ("t"."ticket_date" >= '2026-05-01') AND ("t"."ticket_date" <= '2026-06-30') AND ("t"."id" IN (SELECT "i2"."ledger_ticket_id" FROM "a57be577deb434"."tbl_ledger_ticket_items" "i2" INNER JOIN "a57be577deb434"."tbl_ledger_account_captions" "a2" ON i2.ledger_account_caption_id = a2.id WHERE ("a2"."ledger_id"='1') AND ("a2"."is_cash_equivalent"=TRUE) GROUP BY "i2"."ledger_ticket_id")) AND (((NOT ("a"."ledger_cash_in_item_id" IS NULL)) AND ("i"."credit_amount" <> 0)) OR ((NOT ("a"."ledger_cash_out_item_id" IS NULL)) AND ("i"."debit_amount" <> 0))) GROUP BY CASE WHEN COALESCE(i.credit_amount, 0) <> 0 THEN a.ledger_cash_in_item_id WHEN COALESCE(i.debit_amount, 0) <> 0 THEN a.ledger_cash_out_item_id ELSE NULL END
17:16:28.1141.0 msyii\db\Command::querySELECT "id", "serial_no", "type" FROM "a57be577deb434"."tbl_ledger_cash_items" WHERE (("ledger_id"='1') AND ("is_delete"=FALSE)) AND ("serial_no" IN (2001, 200101, 200102, 200103, 200104, 200105, 200106, 200107, 200108, 200109, 200110, 2002, 200201, 200202, 200203, 200204, 200205, 200206, 200207, 200208, 200209, 200210, 200211, 200212, 2003, 200301, 200302, 200303, 200304, 200305, 200306, 200307, 200308, 200309, 2004, 2005, 2006, 2007))
17:16:28.1231.0 msyii\db\Command::querySELECT "id", "parent_id", "direction", "amount", "is_cash_equivalent" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE "ledger_id"='1' ORDER BY "serial_no", "id"
17:16:28.1120.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_ledgers" WHERE "id"='1'
17:16:28.1240.7 msyii\db\Command::querySELECT "i"."ledger_account_caption_id" AS "ledger_account_caption_id", COALESCE(sum(i.debit_amount), 0) AS "debit_amount", COALESCE(sum(i.credit_amount), 0) AS "credit_amount" FROM "a57be577deb434"."tbl_ledger_ticket_items" "i" INNER JOIN "a57be577deb434"."tbl_ledger_tickets" "t" ON i.ledger_ticket_id = t.id WHERE (("t"."ledger_id"='1') AND ("t"."status"=1)) AND ("i"."ledger_account_caption_id" IN (170, 171, 172, 173, 3, 4, 169, 174, 175, 176, 177, 5)) AND ("t"."ticket_date" < '2026-06-01') GROUP BY "i"."ledger_account_caption_id"
17:16:28.1260.6 msyii\db\Command::querySELECT "i"."ledger_account_caption_id" AS "ledger_account_caption_id", COALESCE(sum(i.debit_amount), 0) AS "debit_amount", COALESCE(sum(i.credit_amount), 0) AS "credit_amount" FROM "a57be577deb434"."tbl_ledger_ticket_items" "i" INNER JOIN "a57be577deb434"."tbl_ledger_tickets" "t" ON i.ledger_ticket_id = t.id WHERE (("t"."ledger_id"='1') AND ("t"."status"=1)) AND ("i"."ledger_account_caption_id" IN (170, 171, 172, 173, 3, 4, 169, 174, 175, 176, 177, 5)) AND ("t"."ticket_date" < '2026-05-01') GROUP BY "i"."ledger_account_caption_id"