ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a42417569a74: POST https://beta.jinchangxiao.com/ledger/report/list-balance-sheet at 2026-06-29 05:57:09 pm by 221.216.117.25

Database Queries

总计11条数据
TimeDurationTypeQuery
  
17:57:09.4370.9 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
17:57:09.4390.8 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "ledger_access_token"='O6Vr7bn3kQPZ5hlF6w1MM7SX_Njw-iTV'

[+] Explain
17:57:09.4410.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5252

[+] Explain
17:57:09.4410.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_ledgers" WHERE "id"='1'

[+] Explain
17:57:09.4430.9 msSELECTSELECT "id", "parent_id", "serial_no", "direction", "amount" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE "ledger_id"='1' ORDER BY "serial_no", "id"

[+] Explain
17:57:09.4440.8 msSELECTSELECT "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 ("t"."ticket_date" <= '2026-06-30') GROUP BY "i"."ledger_account_caption_id"

[+] Explain
17:57:09.4511.5 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_settles" WHERE ("ledger_id"='1') AND ("date"='2026-06-01') AND ("is_settle"=TRUE))

[+] Explain
17:57:09.4520.4 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_tickets" WHERE (("ledger_id"='1') AND ("type"=2) AND ("settle_caption_id"=8) AND ("status"=1)) AND ("settle_month"='2026-06-01'))

[+] Explain
17:57:09.4530.8 msSELECTSELECT "id", "parent_id", "serial_no", "year_debit_amount", "year_credit_amount" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE "ledger_id"='1' ORDER BY "serial_no", "id"

[+] Explain
17:57:09.4540.9 msSELECTSELECT "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 ("t"."ticket_date" >= '2026-05-01') AND ("t"."ticket_date" <= '2026-06-30') AND (NOT (("t"."type"=2) AND ("t"."settle_caption_id"=8))) GROUP BY "i"."ledger_account_caption_id"

[+] Explain
17:57:09.4581.9 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 5252, 6, 'ledger/report/list-balance-sheet', '{"access_token":"O6Vr7bn3kQPZ5hlF6w1MM7SX_Njw-iTV","ledger_id":"1","period_start":"2026-05","period_end":"2026-06","web_access_token":"O6Vr7bn3kQPZ5hlF6w1MM7SX_Njw-iTV"}', '{"code":2000,"result":{"is_balanced":false,"balance_debit_amount":-14245146.29,"balance_credit_amount":-16636835.62,"balance_diff_amount":2391689.33,"list":{"asset":[{"item_name":"\u6d41\u52a8\u8d44\u4ea7","line_no":"","level":0,"ending_amount":"","year_begin_amount":""},{"item_name":"\u8d27\u5e01\u8d44\u91d1","line_no":1,"level":1,"ending_amount":2390727.33,"year_begin_amount":2391689.33},{"item_name":"\u77ed\u671f\u6295\u8d44","line_no":2,"level":1,"ending_amount":"","year_begin_amount":""},{"item_name":"\u5e94\u6536\u7968\u636e","line_no":3,"level":1,"ending_amount":"","year_begin_amount":""},{"item_name":"\u5e94\u6536\u8d26\u6b3e","line_no":4,"level":1,"ending_amount":1019,"year_begin_amount":""},{"item_name":"\u9884\u4ed8\u8d26\u6b3e","line_no":5,"level":1,"ending_amount":"","year_begin_amount":""},{"item_name":"\u5e94\u6536\u80a1\u5229","line_no":6,"level":1,"ending_amount":"","year_begin_amount":""},{"item_name":"\u5e94\u6536\u5229\u606f","line_no":7,"level":1,"ending_amount":"","year_begin_amount":""},{"item_name":"\u5176\u4ed6\u5e94\u6536\u6b3e","line_no":8,"level":1,"ending_amount":"","year_begin_amount":""},{"item_name":"\u5b58\u8d27","line_no":9,"level":1,"ending_amount":-16636892.62,"year_begin_amount":""},{"item_name":"\u5176\u4e2d\uff1a\u539f\u6750\u6599","line_no":10,"level":2,"ending_amount":"","year_begin_amount":""},{"item_name":"\u5728\u4ea7\u54c1","line_no":11,"level":2,"ending_amount":"","year_begin_amount":""},{"item_name":"\u5e93\u5b58\u5546\u54c1","line_no":12,"level":2,"ending_amount":-16636892.62,"year_begin_amount":""},{"item_name":"\u5468\u8f6c\u6750\u6599","line_no":13,"level":2,"ending_amount":"","year_begin_amount":""},{"item_name":"\u5176\u4ed6\u6d41\u52a8\u8d44\u4ea7","line_no":14,"level":1,"ending_amount":"","year_begin_amount":""},{"item_name":"\u6d41\u52a8\u8d44\u4ea7\u5408\u8ba1","line_no":15,"level":1,"ending_amount":-14245146.29,"year_begin_amount":2391689.33},{"item_name":"\u975e\u6d41\u52a8\u8d44\u4ea7","line_no":"","level":0,"ending_amount":"","year_begin_amount":""},{"item_name":"\u957f\u671f\u503a\u5238\u6295\u8d44","line_no":16,"level":1,"ending_amount":"","year_begin_amount":""},{"item_name":"\u957f\u671f\u80a1\u6743\u6295\u8d44","line_no":17,"level":1,"ending_amount":"","year_begin_amount":""},{"item_name":"\u56fa\u5b9a\u8d44\u4ea7\u539f\u4ef7","line_no":18,"level":1,"ending_amount":"","year_begin_amount":""},{"item_name":"\u51cf\uff1a\u7d2f\u8ba1\u6298\u65e7","line_no":19,"level":1,"ending_amount":"","year_begin_amount":""},{"item_name":"\u56fa\u5b9a\u8d44\u4ea7\u8d26\u9762\u4ef7\u503c","line_no":20,"level":1,"ending_amount":"","year_begin_amount":""},{"item_name":"\u5728\u5efa\u5de5\u7a0b","line_no":21,"level":1,"ending_amount":"","year_begin_amount":""},{"item_name":"\u5de5\u7a0b\u7269\u8d44","line_no":22,"level":1,"ending_amount":"","year_begin_amount":""},{"item_name":"\u56fa\u5b9a\u8d44\u4ea7\u6e05\u7406","line_no":23,"level":1,"ending_amount":"","year_begin_amount":""},{"item_name":"\u751f\u4ea7\u6027\u751f\u7269\u8d44\u4ea7","line_no":24,"level":1,"ending_amount":"","year_begin_amount":""},{"item_name":"\u65e0\u5f62\u8d44\u4ea7","line_no":25,"level":1,"ending_amount":"","year_begin_amount":""},{"item_name":"\u5f00\u53d1\u652f\u51fa","line_no":26,"level":1,"ending_amount":"","year_begin_amount":""},{"item_name":"\u957f\u671f\u5f85\u644a\u8d39\u7528","line_no":27,"level":1,"ending_amount":"","year_begin_amount":""},{"item_name":"\u5176\u4ed6\u975e\u6d41\u52a8\u8d44\u4ea7","line_no":28,"level":1,"ending_amount":"","year_begin_amount":""},{"item_name":"\u975e\u6d41\u52a8\u8d44\u4ea7\u5408\u8ba1","line_no":29,"level":1,"ending_amount":"","year_begin_amount":""},{"item_name":"\u8d44\u4ea7\u603b\u8ba1","line_no":30,"level":0,"ending_amount":-14245146.29,"year_begin_amount":2391689.33}],"liability_equity":[{"item_name":"\u6d41\u52a8\u8d1f\u503a","line_no":"","level":0,"ending_amount":"","year_begin_amount":""},{"item_name":"\u77ed\u671f\u501f\u6b3e","line_no":31,"level":1,"ending_amount":"","year_begin_amount":""},{"item_name":"\u5e94\u4ed8\u7968\u636e","line_no":32,"level":1,"ending_amount":"","year_begin_amount":""},{"item_name":"\u5e94\u4ed8\u8d26\u6b3e","line_no":33,"level":1,"ending_amount":160776.1,"year_begin_amount":""},{"item_name":"\u9884\u6536\u8d26\u6b3e","line_no":34,"level":1,"ending_amount":"","year_begin_amount":""},{"item_name":"\u5e94\u4ed8\u804c\u5de5\u85aa\u916c","line_no":35,"level":1,"ending_amount":-46,"year_begin_amount":""},{"item_name":"\u5e94\u4ea4\u7a0e\u8d39","line_no":36,"level":1,"ending_amount":-18370.41,"year_begin_amount":""},{"item_name":"\u5e94\u4ed8\u5229\u606f","line_no":37,"level":1,"ending_amount":"","year_begin_amount":""},{"item_name":"\u5e94\u4ed8\u5229\u6da6","line_no":38,"level":1,"ending_amount":"","year_begin_amount":""},{"item_name":"\u5176\u4ed6\u5e94\u4ed8\u6b3e","line_no":39,"level":1,"ending_amount":10,"year_begin_amount":""},{},{},{},{},{"item_name":"\u5176\u4ed6\u6d41\u52a8\u8d1f\u503a","line_no":40,"level":1,"ending_amount":"","year_begin_amount":""},{"item_name":"\u6d41\u52a8\u8d1f\u503a\u5408\u8ba1","line_no":41,"level":1,"ending_amount":142369.69,"year_begin_amount":""},{"item_name":"\u975e\u6d41\u52a8\u8d1f\u503a","line_no":"","level":0,"ending_amount":"","year_begin_amount":""},{"item_name":"\u957f\u671f\u501f\u6b3e","line_no":42,"level":1,"ending_amount":"","year_begin_amount":""},{"item_name":"\u957f\u671f\u5e94\u4ed8\u6b3e","line_no":43,"level":1,"ending_amount":"","year_begin_amount":""},{"item_name":"\u9012\u5ef6\u6536\u76ca","line_no":44,"level":1,"ending_amount":"","year_begin_amount":""},{"item_name":"\u5176\u4ed6\u975e\u6d41\u52a8\u8d1f\u503a","line_no":45,"level":1,"ending_amount":"","year_begin_amount":""},{"item_name":"\u975e\u6d41\u52a8\u8d1f\u503a\u5408\u8ba1","line_no":46,"level":1,"ending_amount":"","year_begin_amount":""},{"item_name":"\u8d1f\u503a\u5408\u8ba1","line_no":47,"level":0,"ending_amount":142369.69,"year_begin_amount":""},{},{},{"item_name":"\u6240\u6709\u8005\u6743\u76ca\uff08\u6216\u80a1\u4e1c\u6743\u76ca\uff09","line_no":"","level":0,"ending_amount":"","year_begin_amount":""},{"item_name":"\u5b9e\u6536\u8d44\u672c\uff08\u6216\u80a1\u672c\uff09","line_no":48,"level":1,"ending_amount":"","year_begin_amount":""},{"item_name":"\u8d44\u672c\u516c\u79ef","line_no":49,"level":1,"ending_amount":"","year_begin_amount":""},{"item_name":"\u76c8\u4f59\u516c\u79ef","line_no":50,"level":1,"ending_amount":"","year_begin_amount":""},{"item_name":"\u672a\u5206\u914d\u5229\u6da6","line_no":51,"level":1,"ending_amount":-16779205.31,"year_begin_amount":""},{"item_name":"\u6240\u6709\u8005\u6743\u76ca\uff08\u6216\u80a1\u4e1c\u6743\u76ca\uff09\u5408\u8ba1","line_no":52,"level":1,"ending_amount":-16779205.31,"year_begin_amount":""},{"item_name":"\u8d1f\u503a\u548c\u6240\u6709\u8005\u6743\u76ca\uff08\u6216\u80a1\u4e1c\u6743\u76ca\uff09\u603b\u8ba1","line_no":53,"level":0,"ending_amount":-16636835.62,"year_begin_amount":""}]}},"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-29 17:57:09', 23872000) RETURNING "id"

[+] Explain