ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a424151b2d5d: POST https://beta.jinchangxiao.com/ledger/ticket/save-new at 2026-06-29 05:56:33 pm by 221.216.117.25

Performance Profiling

Total processing time: 60 ms; Peak memory: 3.028 MB. Show Profiling Timeline

总计67条数据
TimeDurationCategoryInfo
  
17:56:33.7741.6 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_ledger_ticket_items" ("ledger_ticket_id", "summary", "ledger_account_caption_id", "auxiliary_item_id", "debit_amount", "credit_amount", "sort", "created_at", "updated_at") VALUES (37, '结转本期损益', 104, NULL, '8695524', '0', 1, '2026-06-29 17:56:33', '2026-06-29 17:56:33'), (37, '结转本期损益', 117, NULL, '0', '8695524', 2, '2026-06-29 17:56:33', '2026-06-29 17:56:33'), (37, '结转本期损益', 124, NULL, '234738', '0', 3, '2026-06-29 17:56:33', '2026-06-29 17:56:33'), (37, '结转本期损益', 104, NULL, '0', '234738', 4, '2026-06-29 17:56:33', '2026-06-29 17:56:33'), (37, '结转本期损益', 104, NULL, '8318446.31', '0', 5, '2026-06-29 17:56:33', '2026-06-29 17:56:33'), (37, '结转本期损益', 131, NULL, '0', '8318446.31', 6, '2026-06-29 17:56:33', '2026-06-29 17:56:33'), (37, '结转本期损益', 141, NULL, '23', '0', 7, '2026-06-29 17:56:33', '2026-06-29 17:56:33'), (37, '结转本期损益', 104, NULL, '0', '23', 8, '2026-06-29 17:56:33', '2026-06-29 17:56:33'), (37, '结转本期损益', 152, NULL, '5', '0', 9, '2026-06-29 17:56:33', '2026-06-29 17:56:33'), (37, '结转本期损益', 104, NULL, '0', '5', 10, '2026-06-29 17:56:33', '2026-06-29 17:56:33'), (37, '结转本期损益', 104, NULL, '1', '0', 11, '2026-06-29 17:56:33', '2026-06-29 17:56:33'), (37, '结转本期损益', 168, NULL, '0', '1', 12, '2026-06-29 17:56:33', '2026-06-29 17:56:33')
17:56:33.7861.2 msyii\db\Command::queryINSERT 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/save-new', '{"access_token":"O6Vr7bn3kQPZ5hlF6w1MM7SX_Njw-iTV","ledger_id":"1","LedgerTickets":{"items":[{"summary":"\u7ed3\u8f6c\u672c\u671f\u635f\u76ca","ledger_account_caption_id":"104","auxiliary_item_id":"","debit_amount":"8695524","credit_amount":"0"},{"summary":"\u7ed3\u8f6c\u672c\u671f\u635f\u76ca","ledger_account_caption_id":"117","auxiliary_item_id":"","debit_amount":"0","credit_amount":"8695524"},{"summary":"\u7ed3\u8f6c\u672c\u671f\u635f\u76ca","ledger_account_caption_id":"124","auxiliary_item_id":"","debit_amount":"234738","credit_amount":"0"},{"summary":"\u7ed3\u8f6c\u672c\u671f\u635f\u76ca","ledger_account_caption_id":"104","auxiliary_item_id":"","debit_amount":"0","credit_amount":"234738"},{"summary":"\u7ed3\u8f6c\u672c\u671f\u635f\u76ca","ledger_account_caption_id":"104","auxiliary_item_id":"","debit_amount":"8318446.31","credit_amount":"0"},{"summary":"\u7ed3\u8f6c\u672c\u671f\u635f\u76ca","ledger_account_caption_id":"131","auxiliary_item_id":"","debit_amount":"0","credit_amount":"8318446.31"},{"summary":"\u7ed3\u8f6c\u672c\u671f\u635f\u76ca","ledger_account_caption_id":"141","auxiliary_item_id":"","debit_amount":"23","credit_amount":"0"},{"summary":"\u7ed3\u8f6c\u672c\u671f\u635f\u76ca","ledger_account_caption_id":"104","auxiliary_item_id":"","debit_amount":"0","credit_amount":"23"},{"summary":"\u7ed3\u8f6c\u672c\u671f\u635f\u76ca","ledger_account_caption_id":"152","auxiliary_item_id":"","debit_amount":"5","credit_amount":"0"},{"summary":"\u7ed3\u8f6c\u672c\u671f\u635f\u76ca","ledger_account_caption_id":"104","auxiliary_item_id":"","debit_amount":"0","credit_amount":"5"},{"summary":"\u7ed3\u8f6c\u672c\u671f\u635f\u76ca","ledger_account_caption_id":"104","auxiliary_item_id":"","debit_amount":"1","credit_amount":"0"},{"summary":"\u7ed3\u8f6c\u672c\u671f\u635f\u76ca","ledger_account_caption_id":"168","auxiliary_item_id":"","debit_amount":"0","credit_amount":"1"}],"ticket_word":"3","serial_no":"23","ticket_date":"2026-05-31","ticket_count":"0","type":"2","status":"1","settle_month":"2026-05-01","settle_caption_id":"8"},"web_access_token":"O6Vr7bn3kQPZ5hlF6w1MM7SX_Njw-iTV"}', '{"code":2000,"result":{"id":37},"status":1,"msg":[{"name":"success","success":"\u65b0\u51ed\u8bc1\u5df2\u521b\u5efa\u6210\u529f","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:56:33', 52904960) RETURNING "id"
17:56:33.7781.0 msyii\db\Command::querySELECT "i"."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" LEFT JOIN "a57be577deb434"."tbl_ledger_tickets" "t" ON i.ledger_ticket_id = t.id WHERE (("t"."ledger_id"='1') AND ("t"."status"=1)) AND ("i"."ledger_account_caption_id" IN (124, 141, 152)) GROUP BY "i"."ledger_account_caption_id"
17:56:33.7711.0 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_ledger_tickets" ("ticket_word", "serial_no", "ticket_date", "ticket_count", "type", "status", "settle_month", "settle_caption_id", "ledger_id", "created_by", "created_at", "booked_by", "is_settle", "updated_at") VALUES (3, 23, '2026-05-31', 0, 2, 1, '2026-05-01', 8, 1, 5252, 'now()', 5252, FALSE, 'now()') RETURNING "id"
17:56:33.7370.9 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:56:33.7390.8 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "ledger_access_token"='O6Vr7bn3kQPZ5hlF6w1MM7SX_Njw-iTV'
17:56:33.7720.8 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\LedgerTickets', 37, 'a:15:{s:2:"id";i:37;s:9:"ledger_id";s:1:"1";s:11:"ticket_word";s:1:"3";s:9:"serial_no";s:2:"23";s:12:"ticket_count";s:1:"0";s:11:"ticket_date";s:10:"2026-05-31";s:4:"type";s:1:"2";s:6:"status";s:1:"1";s:9:"is_settle";b:0;s:12:"settle_month";s:10:"2026-05-01";s:17:"settle_caption_id";s:1:"8";s:10:"created_by";i:5252;s:10:"created_at";s:19:"1970-01-01 08:00:00";s:10:"updated_at";s:19:"1970-01-01 08:00:00";s:9:"booked_by";i:5252;}', '', 5252, '221.216.117.25')
17:56:33.7840.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_ledger_banks" WHERE ("ledger_id"='1') AND ("ledger_account_caption_id" IN (124, 141, 152))
17:56:33.7410.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5252
17:56:33.7800.5 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\LedgerAccountCaptions', 124, 'a:1:{s:13:"actual_amount";s:6:"234738";}', '', 5252, '221.216.117.25')
17:56:33.7360.5 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:56:33.7460.5 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE "id"='104')
17:56:33.7670.5 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_settles" WHERE (("ledger_id"='1') AND ("is_settle"=TRUE)) AND ((("start_date" <= '2026-05-31') AND ("end_date" >= '2026-05-31')) OR (("date"='2026-05-01') AND (("start_date" IS NULL) OR ("end_date" IS NULL)))))
17:56:33.7770.4 msyii\db\Command::querySELECT "id", "parent_id", "amount", "direction", "actual_amount" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("ledger_id"='1') AND (("id" IN (124, 141, 152)) OR ("parent_id" IN (124, 141, 152))) ORDER BY "id"
17:56:33.7470.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("ledger_id"='1') AND ("parent_id"='104') AND ("is_delete"=FALSE))
17:56:33.7830.4 msyii\db\Command::querySELECT "id", "parent_id" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE "ledger_id"='1'
17:56:33.7820.4 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\LedgerAccountCaptions', 141, 'a:1:{s:13:"actual_amount";s:3:"-23";}', '', 5252, '221.216.117.25')
17:56:33.7790.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("ledger_id"='1') AND ("id" IN (124, 141, 152))
17:56:33.7670.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_tickets" WHERE ("ledger_id"='1') AND ("ticket_date"='2026-05-31') AND ("ticket_word"='3') AND ("serial_no"='23'))
17:56:33.7760.4 msyii\db\Command::querySELECT "id", "parent_id" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE "ledger_id"='1'
17:56:33.7680.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_tickets" WHERE ("ledger_id"='1') AND ("type"=2) AND ("settle_month"='2026-05-01') AND ("settle_caption_id"='8'))
17:56:33.7800.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_ledger_account_captions" SET "actual_amount"='0', "updated_at"='2026-06-29 17:56:33' WHERE "id"=124
17:56:33.7420.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_ledgers" WHERE "id"='1'
17:56:33.7480.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("ledger_id"='1') AND ("parent_id"='117') AND ("is_delete"=FALSE))
17:56:33.7520.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("ledger_id"='1') AND ("parent_id"='104') AND ("is_delete"=FALSE))
17:56:33.7660.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_ledgers" WHERE "id"='1'
17:56:33.7600.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("ledger_id"='1') AND ("parent_id"='152') AND ("is_delete"=FALSE))
17:56:33.7590.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE "id"='152')
17:56:33.7540.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("ledger_id"='1') AND ("parent_id"='104') AND ("is_delete"=FALSE))
17:56:33.7590.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("ledger_id"='1') AND ("parent_id"='104') AND ("is_delete"=FALSE))
17:56:33.7480.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE "id"='117')
17:56:33.7500.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("ledger_id"='1') AND ("parent_id"='124') AND ("is_delete"=FALSE))
17:56:33.7620.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("ledger_id"='1') AND ("parent_id"='104') AND ("is_delete"=FALSE))
17:56:33.7760.3 msyii\db\Command::querySELECT "ledger_account_caption_id" FROM "a57be577deb434"."tbl_ledger_ticket_items" WHERE ("ledger_ticket_id"=37) AND (NOT ("ledger_account_caption_id" IS NULL))
17:56:33.7550.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("ledger_id"='1') AND ("parent_id"='131') AND ("is_delete"=FALSE))
17:56:33.7570.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("ledger_id"='1') AND ("parent_id"='141') AND ("is_delete"=FALSE))
17:56:33.7460.3 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("id"='104') AND ("ledger_id"='1') AND ("is_delete"=FALSE)
17:56:33.7630.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("ledger_id"='1') AND ("parent_id"='104') AND ("is_delete"=FALSE))
17:56:33.7650.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("ledger_id"='1') AND ("parent_id"='168') AND ("is_delete"=FALSE))
17:56:33.7830.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\LedgerAccountCaptions', 152, 'a:1:{s:13:"actual_amount";s:2:"-5";}', '', 5252, '221.216.117.25')
17:56:33.7580.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE "id"='104')
17:56:33.7500.3 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("id"='124') AND ("ledger_id"='1') AND ("is_delete"=FALSE)
17:56:33.7630.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE "id"='104')
17:56:33.7540.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE "id"='131')
17:56:33.7690.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5252)
17:56:33.7700.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5252)
17:56:33.7510.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE "id"='104')
17:56:33.7530.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE "id"='104')
17:56:33.7610.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE "id"='104')
17:56:33.7490.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE "id"='124')
17:56:33.7560.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE "id"='141')
17:56:33.7570.3 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("id"='141') AND ("ledger_id"='1') AND ("is_delete"=FALSE)
17:56:33.7640.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE "id"='168')
17:56:33.7680.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_ledgers" WHERE "id"='1'
17:56:33.7630.3 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("id"='104') AND ("ledger_id"='1') AND ("is_delete"=FALSE)
17:56:33.7690.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledgers" WHERE "id"='1')
17:56:33.7650.3 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("id"='168') AND ("ledger_id"='1') AND ("is_delete"=FALSE)
17:56:33.7810.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_ledger_account_captions" SET "actual_amount"='0', "updated_at"='2026-06-29 17:56:33' WHERE "id"=141
17:56:33.7510.3 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("id"='104') AND ("ledger_id"='1') AND ("is_delete"=FALSE)
17:56:33.7600.3 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("id"='152') AND ("ledger_id"='1') AND ("is_delete"=FALSE)
17:56:33.7820.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_ledger_account_captions" SET "actual_amount"='0', "updated_at"='2026-06-29 17:56:33' WHERE "id"=152
17:56:33.7530.3 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("id"='104') AND ("ledger_id"='1') AND ("is_delete"=FALSE)
17:56:33.7480.3 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("id"='117') AND ("ledger_id"='1') AND ("is_delete"=FALSE)
17:56:33.7550.3 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("id"='131') AND ("ledger_id"='1') AND ("is_delete"=FALSE)
17:56:33.7580.3 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("id"='104') AND ("ledger_id"='1') AND ("is_delete"=FALSE)
17:56:33.7610.2 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("id"='104') AND ("ledger_id"='1') AND ("is_delete"=FALSE)
17:56:33.7730.2 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_ledger_ticket_items" WHERE "ledger_ticket_id"=37