Performance Profiling

Total processing time: 250 ms; Peak memory: 3.346 MB. Show Profiling Timeline

总计8条数据

Time	Duration	Category	Info

17:43:09.915	19.1 ms	yii\db\Command::query	SELECT COUNT(*) FROM ((SELECT 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 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))) 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)) )) "option_rows"
17:43:09.977	13.5 ms	yii\db\Command::query	INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/voucher-center/list-account-caption', '{"keyword":"","page":"1","pageSize":"20","web_access_token":"G2-mdsiVx4ajd063Zd6C9RL7pLl9o1cd"}', '{"code":2000,"result":{"list":[{"name":"100101 \u73b0\u91d1","direction":1,"direction_display":"\u501f","ledger_account_caption_id":170,"auxiliary_item_id":"","balance":8610},{"name":"100102 \u62db\u5546\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c \u7fc1\u5bb6\u6210 6225880174507062","direction":1,"direction_display":"\u501f","ledger_account_caption_id":171,"auxiliary_item_id":"","balance":789952.68},{"name":"100103 \u5efa\u8bbe\u94f6\u884c\u5317\u4eac\u91d1\u6e90\u652f\u884c\u7fc1\u5bb6\u6210 6217000010081010749","direction":1,"direction_display":"\u501f","ledger_account_caption_id":172,"auxiliary_item_id":"","balance":345.48},{"name":"100104 \u6dd8\u5b9d\u7f51","direction":1,"direction_display":"\u501f","ledger_account_caption_id":173,"auxiliary_item_id":"","balance":0},{"name":"100201 \u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530","direction":1,"direction_display":"\u501f","ledger_account_caption_id":3,"auxiliary_item_id":"","balance":1513773.93},{"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":632136.5},{"name":"100203 \u4e2d\u56fd\u5de5\u5546\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u6d77\u6dc0\u897f\u533a\u4e16\u7eaa\u91d1\u6e90\u652f\u884c0200069919100105717","direction":1,"direction_display":"\u501f","ledger_account_caption_id":169,"auxiliary_item_id":"","balance":93723.6},{"name":"100204 22222222","direction":1,"direction_display":"\u501f","ledger_account_caption_id":174,"auxiliary_item_id":"","balance":0},{"name":"100205 222","direction":1,"direction_display":"\u501f","ledger_account_caption_id":175,"auxiliary_item_id":"","balance":0},{"name":"100206 2222","direction":1,"direction_display":"\u501f","ledger_account_caption_id":176,"auxiliary_item_id":"","balance":0},{"name":"100207 2223","direction":1,"direction_display":"\u501f","ledger_account_caption_id":177,"auxiliary_item_id":"","balance":0},{"name":"1012 \u5176\u4ed6\u8d27\u5e01\u8d44\u91d1","direction":1,"direction_display":"\u501f","ledger_account_caption_id":5,"auxiliary_item_id":"","balance":0},{"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":"1122 \u5e94\u6536\u8d26\u6b3e","direction":1,"direction_display":"\u501f","ledger_account_caption_id":11,"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}],"pagenation":{"totalcount":163,"thispage":1,"pagesize":20}},"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:43:09', 187897856) RETURNING "id"
17:43:09.945	12.2 ms	yii\db\Command::query	SELECT "name", "direction", "direction_display", "opening_amount", "debit_amount", "credit_amount", "ledger_account_caption_id", "auxiliary_item_id" FROM ((SELECT 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 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))) 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)) )) "option_rows" ORDER BY "caption_serial_no", "caption_id_sort", "row_sort", "auxiliary_type_sort", "auxiliary_sort", "auxiliary_id_sort" LIMIT 20
17:43:09.793	8.1 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:43:09.857	6.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_ledgers" WHERE "is_stop"=FALSE ORDER BY "id"
17:43:09.821	5.9 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:43:09.849	4.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:43:09.792	1.3 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta