ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68998fa846c1f: POST https://beta.jinchangxiao.com/vue/purchase-contract/save-remind-date at 2025-08-11 02:37:28 pm by 124.64.23.198

Performance Profiling

Total processing time: 50 ms; Peak memory: 5.412 MB. Show Profiling Timeline

总计46条数据
TimeDurationCategoryInfo
  
14:37:28.2932.3 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=5252
14:37:28.2911.9 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
14:37:28.2971.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
14:37:28.3111.1 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'purchaseContractPaymentCollectionRemindDates', 4042, 13, 1001, 'now()', '[["2025-07-18 260.52\u5143","2025-08-17 1718.016\u5143","2025-08-24 168.984\u5143"]]', '[["2025-07-18 260.52\u5143","2025-08-17 1718.016\u5143"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u4ed8\u6b3e\u8ba1\u5212","d4":["2025-07-18 260.52\u5143;2025-08-17 1718.016\u5143; <b>\u53d8\u4e3a<\/b> 2025-07-18 260.52\u5143;2025-08-17 1718.016\u5143;2025-08-24 168.984\u5143;"]}')
14:37:28.3141.1 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" ("contract_id", "remind_date", "amount", "pct", "reminded") VALUES (4042, '2025-07-18', '260.52', 12.13, FALSE) RETURNING "id"
14:37:28.3091.1 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\PurchaseContracts', 4042, 'a:2:{s:31:"payment_collection_remind_ahead";s:5:"0 day";s:18:"save_collection_at";s:5:"now()";}', '', 1001, '124.64.23.198')
14:37:28.3071.1 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_purchase_contracts" SET "updated_at"='now()', "payment_collection_remind_ahead"='0 day', "save_collection_at"='now()' WHERE "id"=4042
14:37:28.3221.0 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_contract_default_remind_users" ("user_id", "remind_user", "type") VALUES (1001, 1011, 2), (1001, 5360, 2)
14:37:28.3361.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-remind-date', '{"PurchaseContracts":{"id":"4042","budget":"2147.52","payment_collection_remind_ahead":"","purchaseContractPaymentCollectionRemindReceivers":["1011","5360"],"purchaseContractPaymentCollectionRemindDates":[{"remind_date":"2025-07-18","amount":"260.52","pct":"12.13"},{"remind_date":"2025-08-17","amount":"1718.016","pct":"80"},{"remind_date":"2025-08-24","amount":"168.984","pct":"7.8687"}]},"web_access_token":"HcPbdczjiT4Sp46OV0lNGsvc5AuI1uUw"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u91c7\u8d2d\u5408\u540c\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0}', FALSE, '2025-08-11 14:37:28') RETURNING "id"
14:37:28.3251.0 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_receivers" ("contract_id", "user_id") VALUES (4042, 1011) RETURNING "id"
14:37:28.3031.0 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "serial_no"='订单号: 4634557275452161702' LIMIT 2
14:37:28.3210.9 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_contract_default_remind_users" WHERE ("user_id"=1001) AND ("type"=2)
14:37:28.3320.9 msyii\db\Command::querySELECT r.amount, t.created_at FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4042) AND ("t"."status" IN (2, 5, 1))
14:37:28.3180.9 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\PurchaseContractPaymentCollectionRemindDates', 826, 'a:9:{s:2:"id";i:826;s:11:"contract_id";i:4042;s:11:"remind_date";s:10:"2025-08-17";s:8:"reminded";b:0;s:6:"amount";d:1718.0160000000001;s:11:"paid_amount";N;s:12:"overdue_days";N;s:6:"status";N;s:3:"pct";i:80;}', '', 1001, '124.64.23.198')
14:37:28.3170.9 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" ("contract_id", "remind_date", "amount", "pct", "reminded") VALUES (4042, '2025-08-17', '1718.016', 80, FALSE) RETURNING "id"
14:37:28.3340.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', 608, 12, 4042, 13, 1001, '[4042]', '[4042]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u8d39\u7528\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:\u8ba2\u5355\u53f7: 4634557275452161702"]}') RETURNING "id"
14:37:28.3150.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\PurchaseContractPaymentCollectionRemindDates', 825, 'a:9:{s:2:"id";i:825;s:11:"contract_id";i:4042;s:11:"remind_date";s:10:"2025-07-18";s:8:"reminded";b:0;s:6:"amount";d:260.51999999999998;s:11:"paid_amount";N;s:12:"overdue_days";N;s:6:"status";N;s:3:"pct";d:12.130000000000001;}', '', 1001, '124.64.23.198')
14:37:28.3260.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\PurchaseContractPaymentCollectionRemindReceivers', 1388, 'a:3:{s:2:"id";i:1388;s:11:"contract_id";i:4042;s:7:"user_id";s:4:"1011";}', '', 1001, '124.64.23.198')
14:37:28.3270.8 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_receivers" ("contract_id", "user_id") VALUES (4042, 5360) RETURNING "id"
14:37:28.3300.7 msyii\db\Command::querySELECT r.amount, t.created_at FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4042) AND ("t"."status" IN (2, 5, 1))
14:37:28.3290.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4042
14:37:28.3350.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', 551994, 'a:13:{s:2:"id";i:551994;s:9:"object_id";i:608;s:11:"object_type";i:12;s:9:"target_id";i:4042;s:18:"target_object_type";i:13;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[4042]";s:9:"new_value";s:6:"[4042]";s:11:"description";s:159:"{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u8d39\u7528\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:\u8ba2\u5355\u53f7: 4634557275452161702"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '124.64.23.198')
14:37:28.3190.7 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" ("contract_id", "remind_date", "amount", "pct", "reminded") VALUES (4042, '2025-08-24', '168.984', 7.8687, FALSE) RETURNING "id"
14:37:28.3240.7 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_receivers" WHERE "contract_id"=4042
14:37:28.3200.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\PurchaseContractPaymentCollectionRemindDates', 827, 'a:9:{s:2:"id";i:827;s:11:"contract_id";i:4042;s:11:"remind_date";s:10:"2025-08-24";s:8:"reminded";b:0;s:6:"amount";d:168.98400000000001;s:11:"paid_amount";N;s:12:"overdue_days";N;s:6:"status";N;s:3:"pct";d:7.8686999999999996;}', '', 1001, '124.64.23.198')
14:37:28.3280.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\PurchaseContractPaymentCollectionRemindReceivers', 1389, 'a:3:{s:2:"id";i:1389;s:11:"contract_id";i:4042;s:7:"user_id";s:4:"5360";}', '', 1001, '124.64.23.198')
14:37:28.3130.7 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE "contract_id"=4042
14:37:28.3310.7 msyii\db\Command::querySELECT r.amount, t.created_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4042) AND ("t"."status" IN (2, 5, 1))
14:37:28.3000.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"='4042'
14:37:28.3330.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=4042 ORDER BY "id"
14:37:28.3050.5 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "serial_no"='订单号: 4634557275452161702' LIMIT 2
14:37:28.2960.5 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
14:37:28.3040.5 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=608)
14:37:28.3110.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE "contract_id"=4042
14:37:28.3100.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=608
14:37:28.3230.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_receivers" WHERE "contract_id"=4042
14:37:28.3280.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4042
14:37:28.3050.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1011)
14:37:28.3050.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1011)
14:37:28.3330.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4042
14:37:28.3140.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4042)
14:37:28.3070.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1011)
14:37:28.3190.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4042)
14:37:28.3060.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1011)
14:37:28.3160.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4042)
14:37:28.3060.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=608)