ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a589702d3b05: POST https://beta.jinchangxiao.com/ledger/ticket/list-account-caption at 2026-07-16 04:32:02 pm by 114.244.130.25

Performance Profiling

Total processing time: 25 ms; Peak memory: 2.322 MB. Show Profiling Timeline

总计8条数据
TimeDurationCategoryInfo
  
16:32:02.8803.9 msyii\db\Command::querySELECT "name", "direction", "direction_display", "opening_amount", "debit_amount", "credit_amount", "ledger_account_caption_id", "auxiliary_item_id" FROM ((SELECT DISTINCT c.serial_no || ' ' || c.title AS "name", c.direction::integer AS "direction", CASE WHEN c.direction = 1 THEN '借' WHEN c.direction = 2 THEN '贷' ELSE '' END AS "direction_display", COALESCE(c.amount, 0)::text AS "opening_amount", COALESCE(ca.debit_amount, 0)::text AS "debit_amount", COALESCE(ca.credit_amount, 0)::text AS "credit_amount", c.id::integer AS "ledger_account_caption_id", NULL::integer AS "auxiliary_item_id", "c"."serial_no" AS "caption_serial_no", c.id::integer AS "caption_id_sort", 0::integer AS "row_sort", 0::integer AS "auxiliary_type_sort", 0::integer AS "auxiliary_sort", 0::integer AS "auxiliary_id_sort" FROM "a57be577deb434"."tbl_ledger_account_captions" "c" LEFT JOIN (SELECT "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 (NOT ("i"."ledger_account_caption_id" IS NULL)) GROUP BY "i"."ledger_account_caption_id") "ca" ON ca.ledger_account_caption_id = c.id LEFT JOIN "a57be577deb434"."tbl_ledger_auxiliary_items" "a" ON (a.ledger_id = c.ledger_id AND a.is_delete = false AND ((c.is_auxiliary_customer = true AND a.type = 1) OR (c.is_auxiliary_supplier = true AND a.type = 2))) WHERE (("c"."ledger_id"='1') AND ("c"."is_delete"=FALSE)) AND (NOT EXISTS (SELECT 1 FROM a57be577deb434.tbl_ledger_account_captions child WHERE child.ledger_id = c.ledger_id AND child.parent_id = c.id AND child.is_delete = false)) AND ((COALESCE(c.is_auxiliary_customer, false) = false AND COALESCE(c.is_auxiliary_supplier, false) = false)) AND (("c"."serial_no" LIKE '%11%') OR ("c"."title" LIKE '%11%') OR ("a"."serial_no" LIKE '%11%') OR ("a"."title" LIKE '%11%'))) UNION ALL ( SELECT c.serial_no || '.' || a.serial_no || ' ' || c.title || '.' || a.title AS "name", c.direction::integer AS "direction", CASE WHEN c.direction = 1 THEN '借' WHEN c.direction = 2 THEN '贷' ELSE '' END AS "direction_display", COALESCE(o.amount, 0)::text AS "opening_amount", COALESCE(aa.debit_amount, 0)::text AS "debit_amount", COALESCE(aa.credit_amount, 0)::text AS "credit_amount", c.id::integer AS "ledger_account_caption_id", a.id::integer AS "auxiliary_item_id", "c"."serial_no" AS "caption_serial_no", c.id::integer AS "caption_id_sort", 1::integer AS "row_sort", a.type::integer AS "auxiliary_type_sort", a.sort::integer AS "auxiliary_sort", a.id::integer AS "auxiliary_id_sort" FROM "a57be577deb434"."tbl_ledger_account_captions" "c" INNER JOIN "a57be577deb434"."tbl_ledger_auxiliary_items" "a" ON (a.ledger_id = c.ledger_id AND a.is_delete = false AND ((c.is_auxiliary_customer = true AND a.type = 1) OR (c.is_auxiliary_supplier = true AND a.type = 2))) LEFT JOIN "a57be577deb434"."tbl_ledger_auxiliary_opening_balances" "o" ON o.ledger_id = c.ledger_id AND o.ledger_account_caption_id = c.id AND o.auxiliary_item_id = a.id LEFT JOIN (SELECT "i"."ledger_account_caption_id" AS "ledger_account_caption_id", "i"."auxiliary_item_id" AS "auxiliary_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 WHERE (("t"."ledger_id"='1') AND ("t"."status"=1)) AND (NOT ("i"."ledger_account_caption_id" IS NULL)) AND (NOT ("i"."auxiliary_item_id" IS NULL)) GROUP BY "i"."ledger_account_caption_id", "i"."auxiliary_item_id") "aa" ON aa.ledger_account_caption_id = c.id AND aa.auxiliary_item_id = a.id WHERE (("c"."ledger_id"='1') AND ("c"."is_delete"=FALSE)) AND (NOT EXISTS (SELECT 1 FROM a57be577deb434.tbl_ledger_account_captions child WHERE child.ledger_id = c.ledger_id AND child.parent_id = c.id AND child.is_delete = false)) AND (("c"."serial_no" LIKE '%11%') OR ("c"."title" LIKE '%11%') OR ("a"."serial_no" LIKE '%11%') OR ("a"."title" LIKE '%11%')) )) "option_rows" ORDER BY "caption_serial_no", "caption_id_sort", "row_sort", "auxiliary_type_sort", "auxiliary_sort", "auxiliary_id_sort" LIMIT 20
16:32:02.8763.8 msyii\db\Command::querySELECT COUNT(*) FROM ((SELECT DISTINCT c.serial_no || ' ' || c.title AS "name", c.direction::integer AS "direction", CASE WHEN c.direction = 1 THEN '借' WHEN c.direction = 2 THEN '贷' ELSE '' END AS "direction_display", COALESCE(c.amount, 0)::text AS "opening_amount", COALESCE(ca.debit_amount, 0)::text AS "debit_amount", COALESCE(ca.credit_amount, 0)::text AS "credit_amount", c.id::integer AS "ledger_account_caption_id", NULL::integer AS "auxiliary_item_id", "c"."serial_no" AS "caption_serial_no", c.id::integer AS "caption_id_sort", 0::integer AS "row_sort", 0::integer AS "auxiliary_type_sort", 0::integer AS "auxiliary_sort", 0::integer AS "auxiliary_id_sort" FROM "a57be577deb434"."tbl_ledger_account_captions" "c" LEFT JOIN (SELECT "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 (NOT ("i"."ledger_account_caption_id" IS NULL)) GROUP BY "i"."ledger_account_caption_id") "ca" ON ca.ledger_account_caption_id = c.id LEFT JOIN "a57be577deb434"."tbl_ledger_auxiliary_items" "a" ON (a.ledger_id = c.ledger_id AND a.is_delete = false AND ((c.is_auxiliary_customer = true AND a.type = 1) OR (c.is_auxiliary_supplier = true AND a.type = 2))) WHERE (("c"."ledger_id"='1') AND ("c"."is_delete"=FALSE)) AND (NOT EXISTS (SELECT 1 FROM a57be577deb434.tbl_ledger_account_captions child WHERE child.ledger_id = c.ledger_id AND child.parent_id = c.id AND child.is_delete = false)) AND ((COALESCE(c.is_auxiliary_customer, false) = false AND COALESCE(c.is_auxiliary_supplier, false) = false)) AND (("c"."serial_no" LIKE '%11%') OR ("c"."title" LIKE '%11%') OR ("a"."serial_no" LIKE '%11%') OR ("a"."title" LIKE '%11%'))) UNION ALL ( SELECT c.serial_no || '.' || a.serial_no || ' ' || c.title || '.' || a.title AS "name", c.direction::integer AS "direction", CASE WHEN c.direction = 1 THEN '借' WHEN c.direction = 2 THEN '贷' ELSE '' END AS "direction_display", COALESCE(o.amount, 0)::text AS "opening_amount", COALESCE(aa.debit_amount, 0)::text AS "debit_amount", COALESCE(aa.credit_amount, 0)::text AS "credit_amount", c.id::integer AS "ledger_account_caption_id", a.id::integer AS "auxiliary_item_id", "c"."serial_no" AS "caption_serial_no", c.id::integer AS "caption_id_sort", 1::integer AS "row_sort", a.type::integer AS "auxiliary_type_sort", a.sort::integer AS "auxiliary_sort", a.id::integer AS "auxiliary_id_sort" FROM "a57be577deb434"."tbl_ledger_account_captions" "c" INNER JOIN "a57be577deb434"."tbl_ledger_auxiliary_items" "a" ON (a.ledger_id = c.ledger_id AND a.is_delete = false AND ((c.is_auxiliary_customer = true AND a.type = 1) OR (c.is_auxiliary_supplier = true AND a.type = 2))) LEFT JOIN "a57be577deb434"."tbl_ledger_auxiliary_opening_balances" "o" ON o.ledger_id = c.ledger_id AND o.ledger_account_caption_id = c.id AND o.auxiliary_item_id = a.id LEFT JOIN (SELECT "i"."ledger_account_caption_id" AS "ledger_account_caption_id", "i"."auxiliary_item_id" AS "auxiliary_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 WHERE (("t"."ledger_id"='1') AND ("t"."status"=1)) AND (NOT ("i"."ledger_account_caption_id" IS NULL)) AND (NOT ("i"."auxiliary_item_id" IS NULL)) GROUP BY "i"."ledger_account_caption_id", "i"."auxiliary_item_id") "aa" ON aa.ledger_account_caption_id = c.id AND aa.auxiliary_item_id = a.id WHERE (("c"."ledger_id"='1') AND ("c"."is_delete"=FALSE)) AND (NOT EXISTS (SELECT 1 FROM a57be577deb434.tbl_ledger_account_captions child WHERE child.ledger_id = c.ledger_id AND child.parent_id = c.id AND child.is_delete = false)) AND (("c"."serial_no" LIKE '%11%') OR ("c"."title" LIKE '%11%') OR ("a"."serial_no" LIKE '%11%') OR ("a"."title" LIKE '%11%')) )) "option_rows"
16:32:02.8861.6 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/ticket/list-account-caption', '{"access_token":"fm5QrMzndTK8qE2wxJ4UQJeJaYto4p5c","ledger_id":"1","page":"1","pageSize":"20","keyword":"11","web_access_token":"fm5QrMzndTK8qE2wxJ4UQJeJaYto4p5c"}', '{"code":2000,"result":{"list":[{"name":"100202 \u4e2d\u56fd\u5efa\u8bbe\u94f6\u884c\u5317\u4eac\u91d1\u6e90\u652f\u884c11050161620000001495","direction":1,"direction_display":"\u501f","ledger_account_caption_id":4,"auxiliary_item_id":"","balance":23096.06},{"name":"110101 \u80a1\u7968","direction":1,"direction_display":"\u501f","ledger_account_caption_id":7,"auxiliary_item_id":"","balance":0},{"name":"110102 \u503a\u5238","direction":1,"direction_display":"\u501f","ledger_account_caption_id":8,"auxiliary_item_id":"","balance":0},{"name":"110103 \u57fa\u91d1","direction":1,"direction_display":"\u501f","ledger_account_caption_id":9,"auxiliary_item_id":"","balance":0},{"name":"1121 \u5e94\u6536\u7968\u636e","direction":1,"direction_display":"\u501f","ledger_account_caption_id":10,"auxiliary_item_id":"","balance":0},{"name":"1123 \u9884\u4ed8\u8d26\u6b3e","direction":1,"direction_display":"\u501f","ledger_account_caption_id":12,"auxiliary_item_id":"","balance":0},{"name":"1131 \u5e94\u6536\u80a1\u5229","direction":1,"direction_display":"\u501f","ledger_account_caption_id":13,"auxiliary_item_id":"","balance":0},{"name":"1132 \u5e94\u6536\u5229\u606f","direction":1,"direction_display":"\u501f","ledger_account_caption_id":14,"auxiliary_item_id":"","balance":0},{"name":"1133 \u5e94\u6536\u51fa\u53e3\u9000\u7a0e\u6b3e","direction":1,"direction_display":"\u501f","ledger_account_caption_id":15,"auxiliary_item_id":"","balance":0},{"name":"1411 \u5468\u8f6c\u6750\u6599","direction":1,"direction_display":"\u501f","ledger_account_caption_id":26,"auxiliary_item_id":"","balance":0},{"name":"1511 \u957f\u671f\u80a1\u6743\u6295\u8d44","direction":1,"direction_display":"\u501f","ledger_account_caption_id":29,"auxiliary_item_id":"","balance":0},{"name":"221101 \u5e94\u4ed8\u804c\u5de5\u5de5\u8d44","direction":2,"direction_display":"\u8d37","ledger_account_caption_id":46,"auxiliary_item_id":"","balance":-46},{"name":"221102 \u5e94\u4ed8\u5956\u91d1\u3001\u6d25\u8d34\u548c\u8865\u8d34","direction":2,"direction_display":"\u8d37","ledger_account_caption_id":47,"auxiliary_item_id":"","balance":0},{"name":"221103 \u5e94\u4ed8\u798f\u5229\u8d39","direction":2,"direction_display":"\u8d37","ledger_account_caption_id":48,"auxiliary_item_id":"","balance":0},{"name":"221104 \u5e94\u4ed8\u793e\u4f1a\u4fdd\u9669\u8d39","direction":2,"direction_display":"\u8d37","ledger_account_caption_id":49,"auxiliary_item_id":"","balance":0},{"name":"221105 \u5e94\u4ed8\u4f4f\u623f\u516c\u79ef\u91d1","direction":2,"direction_display":"\u8d37","ledger_account_caption_id":50,"auxiliary_item_id":"","balance":0},{"name":"221106 \u5e94\u4ed8\u5de5\u4f1a\u7ecf\u8d39","direction":2,"direction_display":"\u8d37","ledger_account_caption_id":51,"auxiliary_item_id":"","balance":0},{"name":"221107 \u5e94\u4ed8\u6559\u80b2\u7ecf\u8d39","direction":2,"direction_display":"\u8d37","ledger_account_caption_id":52,"auxiliary_item_id":"","balance":0},{"name":"221108 \u975e\u8d27\u5e01\u6027\u798f\u5229","direction":2,"direction_display":"\u8d37","ledger_account_caption_id":53,"auxiliary_item_id":"","balance":0},{"name":"221109 \u8f9e\u9000\u798f\u5229","direction":2,"direction_display":"\u8d37","ledger_account_caption_id":54,"auxiliary_item_id":"","balance":0}],"pagenation":{"totalcount":45,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"114.244.130.25","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-07-16 16:32:02', 17669888) RETURNING "id"
16:32:02.8700.7 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1013
16:32:02.8720.6 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "ledger_access_token"='fm5QrMzndTK8qE2wxJ4UQJeJaYto4p5c'
16:32:02.8730.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:32:02.8700.3 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:32:02.8740.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_ledgers" WHERE "id"='1'