ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68672c1377c1e: POST https://beta.jinchangxiao.com/vue/purchase-contract/save-new-payment at 2025-07-04 09:19:15 am by 114.254.1.137

Performance Profiling

Total processing time: 53 ms; Peak memory: 3.493 MB. Show Profiling Timeline

总计44条数据
TimeDurationCategoryInfo
  
09:19:15.5013.6 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_purchase_contract_payments" ("contract_id", "collected_date", "description", "amount", "created_by", "created_at") VALUES (3850, '2025/07/04', '测试', '1', 1001, 'now()') RETURNING "id"
09:19:15.4932.2 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
09:19:15.4921.8 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
09:19:15.5251.3 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (2, 'update', 1331, 10, 3850, 13, 1001, '[3850]', '[3850]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u8d39\u7528\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:\u8d39\u7528\u5408\u540c\u7f16\u53f7"]}') RETURNING "id"
09:19:15.5161.3 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=110) AND ("object_id"=2098)
09:19:15.5071.2 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_purchase_contract_payments" SET "paid_amount"='0' WHERE "contract_id"=3850
09:19:15.4971.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
09:19:15.5081.1 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=3850
09:19:15.5101.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contract_payments" WHERE ("contract_id"=3850) AND (amount > 0) AND (amount > paid_amount) ORDER BY "collected_date", "created_at"
09:19:15.5371.1 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_unread_comments" ("object_id", "object_type", "comment_id", "remind_user_id") VALUES (3850, '13', 170227, 1011)
09:19:15.5271.0 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\ObjectChangeLogs', 509792, 'a:13:{s:2:"id";i:509792;s:9:"object_id";i:1331;s:11:"object_type";i:10;s:9:"target_id";i:3850;s:18:"target_object_type";i:13;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[3850]";s:9:"new_value";s:6:"[3850]";s:11:"description";s:156:"{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u8d39\u7528\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:\u8d39\u7528\u5408\u540c\u7f16\u53f7"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '114.254.1.137')
09:19:15.5051.0 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\PurchaseContractPayments', 2098, 'a:8:{s:2:"id";i:2098;s:11:"contract_id";i:3850;s:6:"amount";s:1:"1";s:10:"created_by";i:1001;s:10:"created_at";s:19:"1970-01-01 08:00:00";s:14:"collected_date";s:10:"2025/07/04";s:11:"description";s:6:"测试";s:11:"paid_amount";N;}', '', 1001, '114.254.1.137')
09:19:15.5191.0 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (1, 'create', 2098, 110, 1001, '2025-07-04 09:19:15', '{"id":2098,"contract_id":3850,"amount":"1","created_by":1001,"created_at":"2025-07-04 09:19:15","collected_date":"2025-07-04","description":"\u6d4b\u8bd5","paid_amount":"1"}', '{"id":2098,"contract_id":3850,"amount":"1","created_by":1001,"created_at":"2025-07-04 09:19:15","collected_date":"2025-07-04","description":"\u6d4b\u8bd5","paid_amount":"1"}', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u6536\u6b3e\u4fe1\u606f","d4":[]}') RETURNING "id"
09:19:15.5351.0 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "is_system", "description2") VALUES (1001, '13', 3850, '刘人诚提交了付款记录：费用合同编号付款金额1元', TRUE, '采购合同：费用合同编号') RETURNING "id"
09:19:15.5331.0 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\ObjectChangeLogs', 509795, 'a:13:{s:2:"id";i:509795;s:9:"object_id";i:3850;s:11:"object_type";i:13;s:9:"target_id";i:2098;s:18:"target_object_type";i:110;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:6:"[2098]";s:9:"new_value";s:6:"[2098]";s:11:"description";s:116:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u4ed8\u6b3e\u8bb0\u5f55","d4":["2025-07-04 \uffe51.00"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '114.254.1.137')
09:19:15.5401.0 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/purchase-contract/save-new-payment', '{"PurchaseContractPayments":{"id":"","contract_id":"3850","collected_date":"2025\/07\/04","description":"\u6d4b\u8bd5","files":["24805"],"amount":"1"},"contract_id":"3850","web_access_token":"er_liQPTz011rRwTshQzixBLTwcD6PCJ"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u65b0\u6536\u6b3e\u4fe1\u606f\u5df2\u521b\u5efa\u6210\u529f","error":""}],"mod":0}', FALSE, '2025-07-04 09:19:15') RETURNING "id"
09:19:15.5170.9 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_attachement_relationships" ("object_type", "object_id", "attachment_id") VALUES (110, 2098, 24805)
09:19:15.5140.9 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\PurchaseContractPayments', 2098, 'a:1:{s:11:"paid_amount";s:1:"0";}', '', 1001, '114.254.1.137')
09:19:15.5230.9 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (2, 'update', 1018, 1, 3850, 13, 1001, '[3850]', '[3850]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u8d39\u7528\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:\u8d39\u7528\u5408\u540c\u7f16\u53f7"]}') RETURNING "id"
09:19:15.5320.9 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (1, 'create', 3850, 13, 2098, 110, 1001, '[2098]', '[2098]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u4ed8\u6b3e\u8bb0\u5f55","d4":["2025-07-04 \uffe51.00"]}') RETURNING "id"
09:19:15.5220.8 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (2, 'update', 982, 10, 3850, 13, 1001, '[3850]', '[3850]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u8d39\u7528\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:\u8d39\u7528\u5408\u540c\u7f16\u53f7"]}') RETURNING "id"
09:19:15.5310.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\ObjectChangeLogs', 509794, 'a:13:{s:2:"id";i:509794;s:9:"object_id";i:689;s:11:"object_type";i:12;s:9:"target_id";i:3850;s:18:"target_object_type";i:13;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[3850]";s:9:"new_value";s:6:"[3850]";s:11:"description";s:156:"{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u8d39\u7528\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:\u8d39\u7528\u5408\u540c\u7f16\u53f7"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '114.254.1.137')
09:19:15.5280.8 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (2, 'update', 3404, 1, 3850, 13, 1001, '[3850]', '[3850]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u8d39\u7528\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:\u8d39\u7528\u5408\u540c\u7f16\u53f7"]}') RETURNING "id"
09:19:15.5120.8 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\PurchaseContractPaymentCollectionRemindDates', 624, 'a:1:{s:11:"paid_amount";i:1;}', '', 1001, '114.254.1.137')
09:19:15.5300.7 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (2, 'update', 689, 12, 3850, 13, 1001, '[3850]', '[3850]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u8d39\u7528\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:\u8d39\u7528\u5408\u540c\u7f16\u53f7"]}') RETURNING "id"
09:19:15.5200.7 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\ObjectChangeLogs', 509789, 'a:13:{s:2:"id";i:509789;s:9:"object_id";i:2098;s:11:"object_type";i:110;s:9:"target_id";N;s:18:"target_object_type";N;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:173:"{"id":2098,"contract_id":3850,"amount":"1","created_by":1001,"created_at":"2025-07-04 09:19:15","collected_date":"2025-07-04","description":"\u6d4b\u8bd5","paid_amount":"1"}";s:9:"new_value";s:173:"{"id":2098,"contract_id":3850,"amount":"1","created_by":1001,"created_at":"2025-07-04 09:19:15","collected_date":"2025-07-04","description":"\u6d4b\u8bd5","paid_amount":"1"}";s:11:"description";s:93:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u6536\u6b3e\u4fe1\u606f","d4":[]}";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2025-07-04 09:19:15";s:9:"is_delete";N;}', '', 1001, '114.254.1.137')
09:19:15.5240.7 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\ObjectChangeLogs', 509791, 'a:13:{s:2:"id";i:509791;s:9:"object_id";i:1018;s:11:"object_type";i:1;s:9:"target_id";i:3850;s:18:"target_object_type";i:13;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[3850]";s:9:"new_value";s:6:"[3850]";s:11:"description";s:156:"{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u8d39\u7528\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:\u8d39\u7528\u5408\u540c\u7f16\u53f7"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '114.254.1.137')
09:19:15.5230.7 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\ObjectChangeLogs', 509790, 'a:13:{s:2:"id";i:509790;s:9:"object_id";i:982;s:11:"object_type";i:10;s:9:"target_id";i:3850;s:18:"target_object_type";i:13;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[3850]";s:9:"new_value";s:6:"[3850]";s:11:"description";s:156:"{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u8d39\u7528\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:\u8d39\u7528\u5408\u540c\u7f16\u53f7"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '114.254.1.137')
09:19:15.5290.7 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\ObjectChangeLogs', 509793, 'a:13:{s:2:"id";i:509793;s:9:"object_id";i:3404;s:11:"object_type";i:1;s:9:"target_id";i:3850;s:18:"target_object_type";i:13;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[3850]";s:9:"new_value";s:6:"[3850]";s:11:"description";s:156:"{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u8d39\u7528\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:\u8d39\u7528\u5408\u540c\u7f16\u53f7"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '114.254.1.137')
09:19:15.5360.7 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\Comments', 170227, 'a:11:{s:2:"id";i:170227;s:9:"object_id";i:3850;s:11:"object_type";s:2:"13";s:6:"parent";N;s:11:"description";s:67:"刘人诚提交了付款记录：费用合同编号付款金额1元";s:10:"created_by";i:1001;s:10:"created_at";N;s:8:"reply_to";N;s:9:"is_system";b:1;s:8:"for_user";N;s:12:"description2";s:33:"采购合同：费用合同编号";}', '', 1001, '114.254.1.137')
09:19:15.5110.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" SET "paid_amount"='1' WHERE "id"=624
09:19:15.5130.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_purchase_contract_payments" SET "paid_amount"='1' WHERE "id"=2098
09:19:15.5150.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contract_payments" WHERE ("contract_id"=3850) AND (amount > 0) AND (amount > paid_amount) ORDER BY "collected_date", "created_at"
09:19:15.4990.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"='3850'
09:19:15.5210.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=3850 ORDER BY "id"
09:19:15.5390.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
09:19:15.5110.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE ("contract_id"=3850) AND (amount > paid_amount) ORDER BY "remind_date"
09:19:15.5010.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=3850)
09:19:15.5380.3 msyii\db\Command::querySELECT "channel_id" FROM "global"."tbl_logins" WHERE ("id"=1011) AND ("id" != 1001) AND (channel_id IS NOT NULL)
09:19:15.5340.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
09:19:15.5340.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=3850
09:19:15.5010.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=3850)
09:19:15.5070.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=3850
09:19:15.5180.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contract_payments" WHERE "id"=2098