Performance Profiling

Total processing time: 34 ms; Peak memory: 4.956 MB. Show Profiling Timeline

总计8条数据

Time	Duration	Category	Info

15:48:16.491	4.1 ms	yii\db\Command::query	SELECT COUNT() FROM ((SELECT 20020 AS "object_type", "t"."id" AS "object_id", 2 AS "event_type", "e"."id" AS "event_id", '收款'::text AS "business_node", "t"."serial_no" AS "bill_no", CAST(e.settle_at AS date) AS "bill_date", "e"."settle_at" AS "completed_at", "e"."amount" AS "amount", "t"."client_id" AS "client_id", "t"."supplier_id" AS "supplier_id", "t"."contact_id" AS "contact_id", NULL::integer AS "department_id", "t"."handler" AS "handler_id", "t"."created_by" AS "created_by", "e"."erp_bank_id" AS "erp_bank_id", true AS "have_invoice", true AS "is_verified" FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "t" INNER JOIN "a57be577deb434"."tbl_erp_other_payment_ticket_bank_ins" "e" ON e.erp_other_payment_ticket_id = t.id WHERE ("t"."status" IN (2, 5)) AND (NOT ("e"."settle_at" IS NULL)) AND ("e"."amount" > 0) AND ("e"."settle_at" >= '2026-01-26') AND ("e"."settle_at" <= '2026-01-26 23:59:59')) UNION ALL ( SELECT 20020 AS "object_type", "t"."id" AS "object_id", 1 AS "event_type", "s"."id" AS "event_id", '付款'::text AS "business_node", "t"."serial_no" AS "bill_no", CAST(p.bank_settle_at AS date) AS "bill_date", "p"."bank_settle_at" AS "completed_at", "s"."amount" AS "amount", "t"."client_id" AS "client_id", "t"."supplier_id" AS "supplier_id", "t"."contact_id" AS "contact_id", NULL::integer AS "department_id", "t"."handler" AS "handler_id", "t"."created_by" AS "created_by", CASE WHEN COUNT(DISTINCT bo.erp_bank_id) = 1 THEN MIN(bo.erp_bank_id) ELSE NULL END AS "erp_bank_id", true AS "have_invoice", true AS "is_verified" FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "s" INNER JOIN "a57be577deb434"."tbl_erp_other_payment_tickets" "t" ON s.erp_other_payment_ticket_id = t.id INNER JOIN "a57be577deb434"."tbl_erp_payment_tickets" "p" ON s.erp_payment_ticket_id = p.id LEFT JOIN "a57be577deb434"."tbl_erp_payment_ticket_bank_outs" "bo" ON bo.erp_payment_ticket_id = p.id WHERE ("p"."status" IN (2, 5)) AND ("p"."is_payment_settle"=TRUE) AND (NOT ("p"."bank_settle_at" IS NULL)) AND ("s"."amount" > 0) AND ("p"."bank_settle_at" >= '2026-01-26') AND ("p"."bank_settle_at" <= '2026-01-26 23:59:59') GROUP BY "s"."id", "s"."amount", "t"."id", "t"."serial_no", "t"."client_id", "t"."supplier_id", "t"."contact_id", "t"."handler", "t"."created_by", "p"."bank_settle_at" )) "b" LEFT JOIN (SELECT "v"."object_type" AS "object_type", "v"."object_id" AS "object_id", COALESCE(v.event_type, 0) AS "event_type", COALESCE(v.event_id, 0) AS "event_id", COUNT() FILTER (WHERE v.status = 1) AS "success_count", COUNT(*) FILTER (WHERE v.status = 0) AS "fail_count", MAX(v.book_date) FILTER (WHERE v.status = 1) AS "last_book_date" FROM "a57be577deb434"."tbl_voucher_gen_items" "v" WHERE "v"."ledger_id"=1 GROUP BY "v"."object_type", "v"."object_id", COALESCE(v.event_type, 0), COALESCE(v.event_id, 0)) "g" ON g.object_type = b.object_type AND g.object_id = b.object_id AND g.event_type = b.event_type AND g.event_id = b.event_id WHERE (("g"."success_count" IS NULL) OR ("g"."success_count"=0)) AND (("b"."object_type" NOT IN (20, 20018)) OR ("b"."have_invoice"=TRUE) OR (EXISTS (SELECT 1 FROM a57be577deb434.tbl_term_taxonomy_relationships r INNER JOIN a57be577deb434.tbl_term_taxonomies tt ON r.taxonomy_id = tt.id WHERE r.term_id = 18 AND r.object_id = b.object_id AND tt.serial_no IN ('221106','640301','640302','640303','600704') AND ((b.object_type = 20 AND r.object_type = 7) OR (b.object_type = 20018 AND r.object_type = 11))))) AND ("b"."amount" > 0) AND (("b"."object_type" <> 109) OR ("b"."is_verified"=TRUE))
15:48:16.496	3.4 ms	yii\db\Command::query	SELECT COALESCE(SUM(b.amount), 0) AS "total_amount" FROM ((SELECT 20020 AS "object_type", "t"."id" AS "object_id", 2 AS "event_type", "e"."id" AS "event_id", '收款'::text AS "business_node", "t"."serial_no" AS "bill_no", CAST(e.settle_at AS date) AS "bill_date", "e"."settle_at" AS "completed_at", "e"."amount" AS "amount", "t"."client_id" AS "client_id", "t"."supplier_id" AS "supplier_id", "t"."contact_id" AS "contact_id", NULL::integer AS "department_id", "t"."handler" AS "handler_id", "t"."created_by" AS "created_by", "e"."erp_bank_id" AS "erp_bank_id", true AS "have_invoice", true AS "is_verified" FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "t" INNER JOIN "a57be577deb434"."tbl_erp_other_payment_ticket_bank_ins" "e" ON e.erp_other_payment_ticket_id = t.id WHERE ("t"."status" IN (2, 5)) AND (NOT ("e"."settle_at" IS NULL)) AND ("e"."amount" > 0) AND ("e"."settle_at" >= '2026-01-26') AND ("e"."settle_at" <= '2026-01-26 23:59:59')) UNION ALL ( SELECT 20020 AS "object_type", "t"."id" AS "object_id", 1 AS "event_type", "s"."id" AS "event_id", '付款'::text AS "business_node", "t"."serial_no" AS "bill_no", CAST(p.bank_settle_at AS date) AS "bill_date", "p"."bank_settle_at" AS "completed_at", "s"."amount" AS "amount", "t"."client_id" AS "client_id", "t"."supplier_id" AS "supplier_id", "t"."contact_id" AS "contact_id", NULL::integer AS "department_id", "t"."handler" AS "handler_id", "t"."created_by" AS "created_by", CASE WHEN COUNT(DISTINCT bo.erp_bank_id) = 1 THEN MIN(bo.erp_bank_id) ELSE NULL END AS "erp_bank_id", true AS "have_invoice", true AS "is_verified" FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "s" INNER JOIN "a57be577deb434"."tbl_erp_other_payment_tickets" "t" ON s.erp_other_payment_ticket_id = t.id INNER JOIN "a57be577deb434"."tbl_erp_payment_tickets" "p" ON s.erp_payment_ticket_id = p.id LEFT JOIN "a57be577deb434"."tbl_erp_payment_ticket_bank_outs" "bo" ON bo.erp_payment_ticket_id = p.id WHERE ("p"."status" IN (2, 5)) AND ("p"."is_payment_settle"=TRUE) AND (NOT ("p"."bank_settle_at" IS NULL)) AND ("s"."amount" > 0) AND ("p"."bank_settle_at" >= '2026-01-26') AND ("p"."bank_settle_at" <= '2026-01-26 23:59:59') GROUP BY "s"."id", "s"."amount", "t"."id", "t"."serial_no", "t"."client_id", "t"."supplier_id", "t"."contact_id", "t"."handler", "t"."created_by", "p"."bank_settle_at" )) "b" LEFT JOIN (SELECT "v"."object_type" AS "object_type", "v"."object_id" AS "object_id", COALESCE(v.event_type, 0) AS "event_type", COALESCE(v.event_id, 0) AS "event_id", COUNT() FILTER (WHERE v.status = 1) AS "success_count", COUNT() FILTER (WHERE v.status = 0) AS "fail_count", MAX(v.book_date) FILTER (WHERE v.status = 1) AS "last_book_date" FROM "a57be577deb434"."tbl_voucher_gen_items" "v" WHERE "v"."ledger_id"=1 GROUP BY "v"."object_type", "v"."object_id", COALESCE(v.event_type, 0), COALESCE(v.event_id, 0)) "g" ON g.object_type = b.object_type AND g.object_id = b.object_id AND g.event_type = b.event_type AND g.event_id = b.event_id WHERE (("g"."success_count" IS NULL) OR ("g"."success_count"=0)) AND (("b"."object_type" NOT IN (20, 20018)) OR ("b"."have_invoice"=TRUE) OR (EXISTS (SELECT 1 FROM a57be577deb434.tbl_term_taxonomy_relationships r INNER JOIN a57be577deb434.tbl_term_taxonomies tt ON r.taxonomy_id = tt.id WHERE r.term_id = 18 AND r.object_id = b.object_id AND tt.serial_no IN ('221106','640301','640302','640303','600704') AND ((b.object_type = 20 AND r.object_type = 7) OR (b.object_type = 20018 AND r.object_type = 11))))) AND ("b"."amount" > 0) AND (("b"."object_type" <> 109) OR ("b"."is_verified"=TRUE))
15:48:16.500	3.4 ms	yii\db\Command::query	SELECT "b"."object_type" AS "object_type", "b"."object_id" AS "object_id", "b"."event_type" AS "event_type", "b"."event_id" AS "event_id", "b"."business_node" AS "business_node", "b"."bill_no" AS "bill_no", "b"."bill_date" AS "bill_date", "b"."completed_at" AS "completed_at", "b"."amount" AS "amount", "b"."client_id" AS "client_id", "b"."supplier_id" AS "supplier_id", "b"."contact_id" AS "contact_id", "b"."department_id" AS "department_id", "b"."handler_id" AS "handler_id", "b"."created_by" AS "created_by", "b"."erp_bank_id" AS "erp_bank_id", "b"."have_invoice" AS "have_invoice", "b"."is_verified" AS "is_verified", COALESCE(g.success_count, 0) AS "gen_success_count", COALESCE(g.fail_count, 0) AS "gen_fail_count", COALESCE(CAST(g.last_book_date AS text), '') AS "gen_book_date" FROM ((SELECT 20020 AS "object_type", "t"."id" AS "object_id", 2 AS "event_type", "e"."id" AS "event_id", '收款'::text AS "business_node", "t"."serial_no" AS "bill_no", CAST(e.settle_at AS date) AS "bill_date", "e"."settle_at" AS "completed_at", "e"."amount" AS "amount", "t"."client_id" AS "client_id", "t"."supplier_id" AS "supplier_id", "t"."contact_id" AS "contact_id", NULL::integer AS "department_id", "t"."handler" AS "handler_id", "t"."created_by" AS "created_by", "e"."erp_bank_id" AS "erp_bank_id", true AS "have_invoice", true AS "is_verified" FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "t" INNER JOIN "a57be577deb434"."tbl_erp_other_payment_ticket_bank_ins" "e" ON e.erp_other_payment_ticket_id = t.id WHERE ("t"."status" IN (2, 5)) AND (NOT ("e"."settle_at" IS NULL)) AND ("e"."amount" > 0) AND ("e"."settle_at" >= '2026-01-26') AND ("e"."settle_at" <= '2026-01-26 23:59:59')) UNION ALL ( SELECT 20020 AS "object_type", "t"."id" AS "object_id", 1 AS "event_type", "s"."id" AS "event_id", '付款'::text AS "business_node", "t"."serial_no" AS "bill_no", CAST(p.bank_settle_at AS date) AS "bill_date", "p"."bank_settle_at" AS "completed_at", "s"."amount" AS "amount", "t"."client_id" AS "client_id", "t"."supplier_id" AS "supplier_id", "t"."contact_id" AS "contact_id", NULL::integer AS "department_id", "t"."handler" AS "handler_id", "t"."created_by" AS "created_by", CASE WHEN COUNT(DISTINCT bo.erp_bank_id) = 1 THEN MIN(bo.erp_bank_id) ELSE NULL END AS "erp_bank_id", true AS "have_invoice", true AS "is_verified" FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "s" INNER JOIN "a57be577deb434"."tbl_erp_other_payment_tickets" "t" ON s.erp_other_payment_ticket_id = t.id INNER JOIN "a57be577deb434"."tbl_erp_payment_tickets" "p" ON s.erp_payment_ticket_id = p.id LEFT JOIN "a57be577deb434"."tbl_erp_payment_ticket_bank_outs" "bo" ON bo.erp_payment_ticket_id = p.id WHERE ("p"."status" IN (2, 5)) AND ("p"."is_payment_settle"=TRUE) AND (NOT ("p"."bank_settle_at" IS NULL)) AND ("s"."amount" > 0) AND ("p"."bank_settle_at" >= '2026-01-26') AND ("p"."bank_settle_at" <= '2026-01-26 23:59:59') GROUP BY "s"."id", "s"."amount", "t"."id", "t"."serial_no", "t"."client_id", "t"."supplier_id", "t"."contact_id", "t"."handler", "t"."created_by", "p"."bank_settle_at" )) "b" LEFT JOIN (SELECT "v"."object_type" AS "object_type", "v"."object_id" AS "object_id", COALESCE(v.event_type, 0) AS "event_type", COALESCE(v.event_id, 0) AS "event_id", COUNT() FILTER (WHERE v.status = 1) AS "success_count", COUNT() FILTER (WHERE v.status = 0) AS "fail_count", MAX(v.book_date) FILTER (WHERE v.status = 1) AS "last_book_date" FROM "a57be577deb434"."tbl_voucher_gen_items" "v" WHERE "v"."ledger_id"=1 GROUP BY "v"."object_type", "v"."object_id", COALESCE(v.event_type, 0), COALESCE(v.event_id, 0)) "g" ON g.object_type = b.object_type AND g.object_id = b.object_id AND g.event_type = b.event_type AND g.event_id = b.event_id WHERE (("g"."success_count" IS NULL) OR ("g"."success_count"=0)) AND (("b"."object_type" NOT IN (20, 20018)) OR ("b"."have_invoice"=TRUE) OR (EXISTS (SELECT 1 FROM a57be577deb434.tbl_term_taxonomy_relationships r INNER JOIN a57be577deb434.tbl_term_taxonomies tt ON r.taxonomy_id = tt.id WHERE r.term_id = 18 AND r.object_id = b.object_id AND tt.serial_no IN ('221106','640301','640302','640303','600704') AND ((b.object_type = 20 AND r.object_type = 7) OR (b.object_type = 20018 AND r.object_type = 11))))) AND ("b"."amount" > 0) AND (("b"."object_type" <> 109) OR ("b"."is_verified"=TRUE)) ORDER BY "bill_date" DESC, "object_type", "object_id" DESC, "event_type", "event_id" DESC LIMIT 200
15:48:16.504	1.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/bill-list', '{"page":"1","pageSize":"200","object_type":"20020","generation_scope":"ungenerated","date_from":"2026-01-26","date_to":"2026-01-26"}', '{"code":2000,"result":{"list":[],"pagenation":{"totalcount":0,"thispage":1,"pagesize":200},"total_amount":0},"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:48:16', 27394816) RETURNING "id"
15:48:16.480	1.3 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
15:48:16.484	0.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:48:16.480	0.5 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:48:16.485	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_ledgers" WHERE "is_stop"=FALSE ORDER BY "id"