Performance Profiling

Total processing time: 23 ms; Peak memory: 2.223 MB. Show Profiling Timeline

总计7条数据

Time	Duration	Category	Info

17:46:02.136	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', 5252, 6, 'ledger/ticket/get-filter', '{"access_token":"O6Vr7bn3kQPZ5hlF6w1MM7SX_Njw-iTV","ledger_id":"1","web_access_token":"O6Vr7bn3kQPZ5hlF6w1MM7SX_Njw-iTV"}', '{"code":2000,"result":[{"key":"LedgerTicketSearch[keyword]","name":"\u641c\u7d22","type":"inputText","value":[],"default":""},{"key":{"from":"LedgerTicketSearch[ticket_date_from]","to":"LedgerTicketSearch[ticket_date_to]"},"name":"\u671f\u95f4","type":"DatePickerMonth","value":[],"default":{"from":"2026-06","to":"2026-06"}},{"key":"LedgerTicketSearch[summary]","name":"\u6458\u8981","type":"inputText","value":[],"default":""},{"key":"LedgerTicketSearch[created_by]","name":"\u5236\u5355\u4eba","type":"select","value":[{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}],"default":""},{"key":"LedgerTicketSearch[status]","name":"\u51ed\u8bc1\u72b6\u6001","type":"select","value":[{"id":0,"key":0,"name":"\u8349\u7a3f"},{"id":1,"key":1,"name":"\u5df2\u8bb0\u8d26"}],"default":""},{"key":"LedgerTicketSearch[ticket_word]","name":"\u51ed\u8bc1\u7c7b\u578b","type":"select","value":[{"id":4,"key":4,"name":"\u8bb0"},{"id":2,"key":2,"name":"\u4ed8"},{"id":3,"key":3,"name":"\u8f6c"},{"id":1,"key":1,"name":"\u6536"}],"default":""},{"key":{"min":"LedgerTicketSearch[entry_amount_min]","max":"LedgerTicketSearch[entry_amount_max]"},"name":"\u91d1\u989d","type":"amountRange","value":[],"default":{"min":"","max":""}},{"key":{"type":"LedgerTicketSearch[auxiliary_type]","item":"LedgerTicketSearch[auxiliary_item_id]"},"name":"\u8f85\u52a9\u6838\u7b97","type":"auxiliaryAccounting","value":[{"id":1,"key":1,"name":"\u5ba2\u6237"},{"id":2,"key":2,"name":"\u4f9b\u5e94\u5546"}],"default":{"type":"","item":null}}],"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:46:02', 14458112) RETURNING "id"
17:46:02.133	1.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (SELECT "created_by" FROM "a57be577deb434"."tbl_ledger_tickets" WHERE ("ledger_id"='1') AND (NOT ("created_by" IS NULL)) GROUP BY "created_by") ORDER BY "name", "id"
17:46:02.125	1.0 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:46:02.128	0.9 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "ledger_access_token"='O6Vr7bn3kQPZ5hlF6w1MM7SX_Njw-iTV'
17:46:02.131	0.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_ledgers" WHERE "id"='1'
17:46:02.124	0.6 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:46:02.130	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5252