ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a42416ed0be2: POST https://beta.jinchangxiao.com/ledger/report/list-income-statement at 2026-06-29 05:57:02 pm by 221.216.117.25

Database Queries

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

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

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

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

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

[+] Explain
17:57:02.8680.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-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:02.8700.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-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:02.8750.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:02.8760.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:02.8760.7 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-01') GROUP BY "i"."ledger_account_caption_id"

[+] Explain
17:57:02.8792.0 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-income-statement', '{"access_token":"O6Vr7bn3kQPZ5hlF6w1MM7SX_Njw-iTV","ledger_id":"1","period_start":"2026-06","period_end":"2026-06","web_access_token":"O6Vr7bn3kQPZ5hlF6w1MM7SX_Njw-iTV"}', '{"code":2000,"result":{"settle_status":{"code":"not_carried","name":"\u672a\u7ed3\u8f6c\u635f\u76ca","color":"orange","tips":[]},"list":[{"item_name":"\u4e00\u3001\u8425\u4e1a\u6536\u5165","line_no":1,"index":1,"level":0,"year_amount":-8695524,"month_amount":""},{"item_name":"\u51cf\uff1a\u8425\u4e1a\u6210\u672c","line_no":2,"index":2,"level":1,"year_amount":8318446.31,"month_amount":""},{"item_name":"\u7a0e\u91d1\u53ca\u9644\u52a0","line_no":3,"index":2,"level":1,"year_amount":"","month_amount":""},{"item_name":"\u5176\u4e2d\uff1a\u6d88\u8d39\u7a0e","line_no":4,"index":2,"level":2,"year_amount":"","month_amount":""},{"item_name":"\u8425\u4e1a\u7a0e","line_no":5,"index":2,"level":2,"year_amount":"","month_amount":""},{"item_name":"\u57ce\u5e02\u7ef4\u62a4\u5efa\u8bbe\u7a0e","line_no":6,"index":2,"level":2,"year_amount":"","month_amount":""},{"item_name":"\u8d44\u6e90\u7a0e","line_no":7,"index":2,"level":2,"year_amount":"","month_amount":""},{"item_name":"\u571f\u5730\u589e\u503c\u7a0e","line_no":8,"index":2,"level":2,"year_amount":"","month_amount":""},{"item_name":"\u57ce\u9547\u571f\u5730\u4f7f\u7528\u7a0e\u3001\u623f\u4ea7\u7a0e\u3001\u8f66\u8239\u7a0e\u3001\u5370\u82b1\u7a0e","line_no":9,"index":2,"level":2,"year_amount":"","month_amount":""},{"item_name":"\u6559\u80b2\u8d39\u9644\u52a0\u3001\u77ff\u4ea7\u8d44\u6e90\u8865\u507f\u8d39\u3001\u6392\u6c61\u8d39","line_no":10,"index":2,"level":2,"year_amount":"","month_amount":""},{"item_name":"\u9500\u552e\u8d39\u7528","line_no":11,"index":2,"level":1,"year_amount":"","month_amount":""},{"item_name":"\u5176\u4e2d\uff1a\u5546\u54c1\u7ef4\u4fee\u8d39","line_no":12,"index":2,"level":2,"year_amount":"","month_amount":""},{"item_name":"\u5e7f\u544a\u8d39\u548c\u4e1a\u52a1\u5ba3\u4f20\u8d39","line_no":13,"index":2,"level":2,"year_amount":"","month_amount":""},{"item_name":"\u7ba1\u7406\u8d39\u7528","line_no":14,"index":2,"level":1,"year_amount":-23,"month_amount":""},{"item_name":"\u5176\u4e2d\uff1a\u5f00\u529e\u8d39","line_no":15,"index":2,"level":2,"year_amount":"","month_amount":""},{"item_name":"\u4e1a\u52a1\u62db\u5f85\u8d39","line_no":16,"index":2,"level":2,"year_amount":"","month_amount":""},{"item_name":"\u7814\u7a76\u8d39\u7528","line_no":17,"index":2,"level":2,"year_amount":"","month_amount":""},{"item_name":"\u8d22\u52a1\u8d39\u7528","line_no":18,"index":2,"level":1,"year_amount":-5,"month_amount":""},{"item_name":"\u5176\u4e2d\uff1a\u5229\u606f\u8d39\u7528\uff08\u6536\u5165\u4ee5\u201c-\u201d\u53f7\u586b\u5217\uff09","line_no":19,"index":2,"level":2,"year_amount":-5,"month_amount":""},{"item_name":"\u52a0\uff1a\u6295\u8d44\u6536\u76ca\uff08\u635f\u5931\u4ee5\u201c-\u201d\u53f7\u586b\u5217\uff09","line_no":20,"index":2,"level":1,"year_amount":"","month_amount":""},{"item_name":"\u4e8c\u3001\u8425\u4e1a\u5229\u6da6\uff08\u4e8f\u635f\u4ee5\u201c-\u201d\u53f7\u586b\u5217\uff09","line_no":21,"index":1,"level":0,"year_amount":-17013942.31,"month_amount":0},{"item_name":"\u52a0\uff1a\u8425\u4e1a\u5916\u6536\u5165","line_no":22,"index":2,"level":1,"year_amount":234738,"month_amount":""},{"item_name":"\u5176\u4e2d\uff1a\u653f\u5e9c\u8865\u52a9","line_no":23,"index":2,"level":2,"year_amount":"","month_amount":""},{"item_name":"\u51cf\uff1a\u8425\u4e1a\u5916\u652f\u51fa","line_no":24,"index":2,"level":1,"year_amount":"","month_amount":""},{"item_name":"\u5176\u4e2d\uff1a\u574f\u8d26\u635f\u5931","line_no":25,"index":2,"level":2,"year_amount":"","month_amount":""},{"item_name":"\u65e0\u6cd5\u6536\u56de\u7684\u957f\u671f\u503a\u5238\u6295\u8d44\u635f\u5931","line_no":26,"index":2,"level":2,"year_amount":"","month_amount":""},{"item_name":"\u65e0\u6cd5\u6536\u56de\u7684\u957f\u671f\u80a1\u6743\u6295\u8d44\u635f\u5931","line_no":27,"index":2,"level":2,"year_amount":"","month_amount":""},{"item_name":"\u81ea\u7136\u707e\u5bb3\u7b49\u4e0d\u53ef\u6297\u529b\u56e0\u7d20\u9020\u6210\u7684\u635f\u5931","line_no":28,"index":2,"level":2,"year_amount":"","month_amount":""},{"item_name":"\u7a0e\u6536\u6ede\u7eb3\u91d1","line_no":29,"index":2,"level":2,"year_amount":"","month_amount":""},{"item_name":"\u4e09\u3001\u5229\u6da6\u603b\u989d\uff08\u4e8f\u635f\u603b\u989d\u4ee5\u201c-\u201d\u53f7\u586b\u5217\uff09","line_no":30,"index":1,"level":0,"year_amount":-16779204.31,"month_amount":0},{"item_name":"\u51cf\uff1a\u6240\u5f97\u7a0e\u8d39\u7528","line_no":31,"index":2,"level":1,"year_amount":1,"month_amount":""},{"item_name":"\u56db\u3001\u51c0\u5229\u6da6\uff08\u51c0\u4e8f\u635f\u4ee5\u201c-\u201d\u53f7\u586b\u5217\uff09","line_no":32,"index":1,"level":0,"year_amount":-16779205.31,"month_amount":0}]},"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:02', 22505984) RETURNING "id"

[+] Explain