Performance Profiling

Total processing time: 46 ms; Peak memory: 3.344 MB. Show Profiling Timeline

总计7条数据

Time	Duration	Category	Info

15:56:27.273	7.7 ms	yii\db\Command::query	SELECT 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 '%12%') OR ("c"."title" LIKE '%12%') OR ("a"."serial_no" LIKE '%12%') OR ("a"."title" LIKE '%12%'))) 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 '%12%') OR ("c"."title" LIKE '%12%') OR ("a"."serial_no" LIKE '%12%') OR ("a"."title" LIKE '%12%')) )) "option_rows"
15:56:27.253	5.6 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:56:27.281	4.6 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 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 '%12%') OR ("c"."title" LIKE '%12%') OR ("a"."serial_no" LIKE '%12%') OR ("a"."title" LIKE '%12%'))) 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 '%12%') OR ("c"."title" LIKE '%12%') OR ("a"."serial_no" LIKE '%12%') OR ("a"."title" LIKE '%12%')) )) "option_rows" ORDER BY "caption_serial_no", "caption_id_sort", "row_sort", "auxiliary_type_sort", "auxiliary_sort", "auxiliary_id_sort" LIMIT 20
15:56:27.258	3.1 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
15:56:27.264	2.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:56:27.287	2.4 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":"12","page":"1","pageSize":"20"}', '{"code":2000,"result":{"list":[{"name":"1012 \u5176\u4ed6\u8d27\u5e01\u8d44\u91d1","direction":1,"direction_display":"\u501f","ledger_account_caption_id":5,"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":89240},{"name":"1123 \u9884\u4ed8\u8d26\u6b3e","direction":1,"direction_display":"\u501f","ledger_account_caption_id":12,"auxiliary_item_id":"","balance":0},{"name":"122101 \u77f3\u6cb9\u516c\u53f8","direction":1,"direction_display":"\u501f","ledger_account_caption_id":17,"auxiliary_item_id":"","balance":0},{"name":"122102 \u4e2a\u4eba\u793e\u4fdd","direction":1,"direction_display":"\u501f","ledger_account_caption_id":18,"auxiliary_item_id":"","balance":0},{"name":"222112 \u5e94\u4ea4\u8425\u4e1a\u7a0e","direction":2,"direction_display":"\u8d37","ledger_account_caption_id":78,"auxiliary_item_id":"","balance":0},{"name":"222120 \u5e94\u4ea4\u8f66\u8239\u4f7f\u7528\u7a0e","direction":2,"direction_display":"\u8d37","ledger_account_caption_id":86,"auxiliary_item_id":"","balance":0},{"name":"222121 \u5e94\u4ea4\u4e2a\u4eba\u6240\u5f97\u7a0e","direction":2,"direction_display":"\u8d37","ledger_account_caption_id":87,"auxiliary_item_id":"","balance":0},{"name":"222122 \u6559\u80b2\u8d39\u9644\u52a0","direction":2,"direction_display":"\u8d37","ledger_account_caption_id":88,"auxiliary_item_id":"","balance":-746.22},{"name":"222123 \u77ff\u4ea7\u8d44\u6e90\u8865\u507f\u8d39","direction":2,"direction_display":"\u8d37","ledger_account_caption_id":89,"auxiliary_item_id":"","balance":0},{"name":"222124 \u6392\u6c61\u8d39","direction":2,"direction_display":"\u8d37","ledger_account_caption_id":90,"auxiliary_item_id":"","balance":0},{"name":"222125 \u5e94\u4ea4\u5370\u82b1\u7a0e","direction":2,"direction_display":"\u8d37","ledger_account_caption_id":91,"auxiliary_item_id":"","balance":0},{"name":"222126 \u5730\u65b9\u6559\u80b2\u8d39\u9644\u52a0","direction":2,"direction_display":"\u8d37","ledger_account_caption_id":92,"auxiliary_item_id":"","balance":-497.48}],"pagenation":{"totalcount":14,"thispage":1,"pagesize":20}},"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-07-07 15:56:27', 37979904) RETURNING "id"
15:56:27.267	1.1 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_ledgers" WHERE "is_stop"=FALSE ORDER BY "id"