Performance Profiling

Total processing time: 33 ms; Peak memory: 5.102 MB. Show Profiling Timeline

总计13条数据

Time	Duration	Category	Info

17:17:47.276	2.1 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT 20012 AS "object_type", "e"."id" AS "object_id", 0 AS "event_type", 0 AS "event_id", ''::text AS "business_node", "e"."serial_no" AS "bill_no", "e"."wrote_date" AS "bill_date", NULL::timestamp without time zone AS "completed_at", "e"."amount" AS "amount", "e"."client_id" AS "client_id", "e"."supplier_id" AS "supplier_id", NULL::integer AS "contact_id", NULL::integer AS "department_id", "e"."handler" AS "handler_id", "e"."created_by" AS "created_by", NULL::integer AS "erp_bank_id", true AS "have_invoice", true AS "is_verified" FROM "a57be577deb434"."tbl_erp_payment_tickets" "e" WHERE ("e"."status"=2) AND ("e"."wrote_date" >= '2026-05-01') AND ("e"."wrote_date" <= '2026-07-31')) "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
17:17:47.286	2.0 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":"20012","generation_scope":"all","date_from":"2026-05-01","date_to":"2026-07-31","web_access_token":"niM9Np1xaU2lIsoGJh5qM6IxT9naEHjn"}', '{"code":2000,"result":{"list":[{"id":"20012_2365_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2365,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260707-00004","bill_date":"2026-07-07","completed_at":"","amount":10,"partner_name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8","department":"\u603b\u7ecf\u7406","handler_name":"\u5218\u4eba\u8bda","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2364_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2364,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260707-00003","bill_date":"2026-07-07","completed_at":"","amount":0,"partner_name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8","department":"\u603b\u7ecf\u7406","handler_name":"\u5218\u4eba\u8bda","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u4e0d\u7b26\u5408\u751f\u6210\u6761\u4ef6","can_select":false,"have_invoice":true,"is_verified":true,"is_error":true,"error_code":"zero_amount","error_display":"\u5355\u636e\u91d1\u989d=0\uff0c\u65e0\u9700\u751f\u6210\u51ed\u8bc1","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2363_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2363,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260707-00002","bill_date":"2026-07-07","completed_at":"","amount":800,"partner_name":"\u5317\u4eac\u795e\u5dde\u90a6\u90a6\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","department":"\u603b\u7ecf\u7406","handler_name":"\u5218\u4eba\u8bda","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2362_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2362,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260707-00001","bill_date":"2026-07-07","completed_at":"","amount":2,"partner_name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8","department":"\u603b\u7ecf\u7406","handler_name":"\u5218\u4eba\u8bda","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2360_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2360,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260520-00001","bill_date":"2026-05-20","completed_at":"","amount":200,"partner_name":"\u5317\u4eac\u4e5d\u5dde\u5b89\u548c\u673a\u7535\u8bbe\u5907\u5b89\u88c5\u5de5\u7a0b\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u5df2\u751f\u6210\u51ed\u8bc11\u6b21","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":1,"gen_fail_count":1,"book_date":"2026-05-31"},{"id":"20012_2358_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2358,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260512-00006","bill_date":"2026-05-12","completed_at":"","amount":50,"partner_name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u5df2\u751f\u6210\u51ed\u8bc11\u6b21","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":1,"gen_fail_count":1,"book_date":"2026-05-31"},{"id":"20012_2357_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2357,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260512-00005","bill_date":"2026-05-12","completed_at":"","amount":800,"partner_name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","department":"\u8f6f\u4ef6\u5f00\u53d1","handler_name":"\u66f9\u6c38\u751f","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u5df2\u751f\u6210\u51ed\u8bc11\u6b21","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":1,"gen_fail_count":1,"book_date":"2026-05-31"},{"id":"20012_2356_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2356,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260512-00004","bill_date":"2026-05-12","completed_at":"","amount":2,"partner_name":"\u5317\u4eac\u5730\u5e73\u7ebf\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u5b89\u4ead\u5730\u5e73\u7ebf\u667a\u80fd\u4ea4\u901a\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u7ea2\u897f\u74dc\u534a\u5bfc\u4f53\u6709\u9650\u516c\u53f8\/\u5b81\u6ce2\u5730\u5e73\u7ebf\u98d2\u817e\u79d1\u6280\u6709\u9650\u516c\u53f8(EDA)","department":"\u603b\u7ecf\u7406","handler_name":"\u5218\u4eba\u8bda","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u5df2\u751f\u6210\u51ed\u8bc11\u6b21","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":1,"gen_fail_count":1,"book_date":"2026-05-31"},{"id":"20012_2355_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2355,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260512-00003","bill_date":"2026-05-12","completed_at":"","amount":2,"partner_name":"\u5317\u4eac\u5730\u5e73\u7ebf\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u5b89\u4ead\u5730\u5e73\u7ebf\u667a\u80fd\u4ea4\u901a\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u7ea2\u897f\u74dc\u534a\u5bfc\u4f53\u6709\u9650\u516c\u53f8\/\u5b81\u6ce2\u5730\u5e73\u7ebf\u98d2\u817e\u79d1\u6280\u6709\u9650\u516c\u53f8(EDA)","department":"\u603b\u7ecf\u7406","handler_name":"\u5218\u4eba\u8bda","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u5df2\u751f\u6210\u51ed\u8bc11\u6b21","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":1,"gen_fail_count":1,"book_date":"2026-05-31"},{"id":"20012_2354_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2354,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260512-00002","bill_date":"2026-05-12","completed_at":"","amount":1,"partner_name":"\u5317\u4eac\u667a\u5fb7\u5929\u8bda\u79d1\u6280\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u5df2\u751f\u6210\u51ed\u8bc11\u6b21","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":1,"gen_fail_count":1,"book_date":"2026-05-31"},{"id":"20012_2353_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2353,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260512-00001","bill_date":"2026-05-12","completed_at":"","amount":1,"partner_name":"\u5317\u4eac\u667a\u5fb7\u5929\u8bda\u79d1\u6280\u6709\u9650\u516c\u53f8","department":"\u603b\u7ecf\u7406","handler_name":"\u5218\u4eba\u8bda","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u5df2\u751f\u6210\u51ed\u8bc11\u6b21","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":1,"gen_fail_count":1,"book_date":"2026-05-31"}],"pagenation":{"totalcount":11,"thispage":1,"pagesize":200},"total_amount":1868},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"114.244.130.20","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-07-07 17:17:47', 24763904) RETURNING "id"
17:17:47.280	1.5 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 20012 AS "object_type", "e"."id" AS "object_id", 0 AS "event_type", 0 AS "event_id", ''::text AS "business_node", "e"."serial_no" AS "bill_no", "e"."wrote_date" AS "bill_date", NULL::timestamp without time zone AS "completed_at", "e"."amount" AS "amount", "e"."client_id" AS "client_id", "e"."supplier_id" AS "supplier_id", NULL::integer AS "contact_id", NULL::integer AS "department_id", "e"."handler" AS "handler_id", "e"."created_by" AS "created_by", NULL::integer AS "erp_bank_id", true AS "have_invoice", true AS "is_verified" FROM "a57be577deb434"."tbl_erp_payment_tickets" "e" WHERE ("e"."status"=2) AND ("e"."wrote_date" >= '2026-05-01') AND ("e"."wrote_date" <= '2026-07-31')) "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 ORDER BY "bill_date" DESC, "object_type", "object_id" DESC, "event_type", "event_id" DESC LIMIT 200
17:17:47.278	1.3 ms	yii\db\Command::query	SELECT COALESCE(SUM(b.amount), 0) AS "total_amount" FROM (SELECT 20012 AS "object_type", "e"."id" AS "object_id", 0 AS "event_type", 0 AS "event_id", ''::text AS "business_node", "e"."serial_no" AS "bill_no", "e"."wrote_date" AS "bill_date", NULL::timestamp without time zone AS "completed_at", "e"."amount" AS "amount", "e"."client_id" AS "client_id", "e"."supplier_id" AS "supplier_id", NULL::integer AS "contact_id", NULL::integer AS "department_id", "e"."handler" AS "handler_id", "e"."created_by" AS "created_by", NULL::integer AS "erp_bank_id", true AS "have_invoice", true AS "is_verified" FROM "a57be577deb434"."tbl_erp_payment_tickets" "e" WHERE ("e"."status"=2) AND ("e"."wrote_date" >= '2026-05-01') AND ("e"."wrote_date" <= '2026-07-31')) "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
17:17:47.264	0.9 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:17:47.266	0.7 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:17:47.281	0.5 ms	yii\db\Command::query	SELECT "id", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3303, 2553, 2150)
17:17:47.263	0.5 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:17:47.268	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:17:47.282	0.4 ms	yii\db\Command::query	SELECT "id", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (431, 307, 756)
17:17:47.269	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_ledgers" WHERE "is_stop"=FALSE ORDER BY "id"
17:17:47.284	0.3 ms	yii\db\Command::query	SELECT "id", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (10, 3, 4)
17:17:47.283	0.3 ms	yii\db\Command::query	SELECT "id", "name", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1011, 1000)