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

Database Queries

总计40条数据
TimeDurationTypeQuery
  
14:37:33.8722.3 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=5252

[+] Explain
14:37:33.8750.5 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
14:37:33.8761.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
14:37:33.8790.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"='4042'

[+] Explain
14:37:33.8820.9 msSELECTSELECT "id" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "serial_no"='订单号: 4634557275452161702' LIMIT 2

[+] Explain
14:37:33.8830.5 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=608)

[+] Explain
14:37:33.8830.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1011)

[+] Explain
14:37:33.8840.3 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1011)

[+] Explain
14:37:33.8840.5 msSELECTSELECT "id" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "serial_no"='订单号: 4634557275452161702' LIMIT 2

[+] Explain
14:37:33.8850.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=608)

[+] Explain
14:37:33.8850.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1011)

[+] Explain
14:37:33.8860.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1011)

[+] Explain
14:37:33.8861.1 msUPDATEUPDATE "a57be577deb434"."tbl_purchase_contracts" SET "updated_at"='now()', "payment_collection_remind_ahead"='0 day', "save_collection_at"='now()' WHERE "id"=4042

[+] Explain
14:37:33.8871.3 msINSERTINSERT 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')

[+] Explain
14:37:33.8890.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=608

[+] Explain
14:37:33.8900.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE "contract_id"=4042

[+] Explain
14:37:33.8900.7 msDELETEDELETE FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE "contract_id"=4042

[+] Explain
14:37:33.8910.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4042)

[+] Explain
14:37:33.8920.9 msINSERTINSERT 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"

[+] Explain
14:37:33.8930.8 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\PurchaseContractPaymentCollectionRemindDates', 828, 'a:9:{s:2:"id";i:828;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')

[+] Explain
14:37:33.8940.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4042)

[+] Explain
14:37:33.8940.7 msINSERTINSERT 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"

[+] Explain
14:37:33.8950.8 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\PurchaseContractPaymentCollectionRemindDates', 829, 'a:9:{s:2:"id";i:829;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')

[+] Explain
14:37:33.8960.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4042)

[+] Explain
14:37:33.8960.8 msINSERTINSERT INTO "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" ("contract_id", "remind_date", "amount", "pct", "reminded") VALUES (4042, '2025-08-24', '168.984', 7.87, FALSE) RETURNING "id"

[+] Explain
14:37:33.8970.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\PurchaseContractPaymentCollectionRemindDates', 830, 'a:9:{s:2:"id";i:830;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.8700000000000001;}', '', 1001, '124.64.23.198')

[+] Explain
14:37:33.8980.8 msDELETEDELETE FROM "a57be577deb434"."tbl_contract_default_remind_users" WHERE ("user_id"=1001) AND ("type"=2)

[+] Explain
14:37:33.8991.1 msINSERTINSERT INTO "a57be577deb434"."tbl_contract_default_remind_users" ("user_id", "remind_user", "type") VALUES (1001, 1011, 2), (1001, 5360, 2)

[+] Explain
14:37:33.9010.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_receivers" WHERE "contract_id"=4042

[+] Explain
14:37:33.9010.7 msDELETEDELETE FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_receivers" WHERE "contract_id"=4042

[+] Explain
14:37:33.9021.0 msINSERTINSERT INTO "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_receivers" ("contract_id", "user_id") VALUES (4042, 1011) RETURNING "id"

[+] Explain
14:37:33.9030.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\PurchaseContractPaymentCollectionRemindReceivers', 1390, 'a:3:{s:2:"id";i:1390;s:11:"contract_id";i:4042;s:7:"user_id";s:4:"1011";}', '', 1001, '124.64.23.198')

[+] Explain
14:37:33.9040.8 msINSERTINSERT INTO "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_receivers" ("contract_id", "user_id") VALUES (4042, 5360) RETURNING "id"

[+] Explain
14:37:33.9050.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\PurchaseContractPaymentCollectionRemindReceivers', 1391, 'a:3:{s:2:"id";i:1391;s:11:"contract_id";i:4042;s:7:"user_id";s:4:"5360";}', '', 1001, '124.64.23.198')

[+] Explain
14:37:33.9060.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4042

[+] Explain
14:37:33.9060.7 msUPDATEUPDATE "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4042

[+] Explain
14:37:33.9070.8 msSELECTSELECT 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))

[+] Explain
14:37:33.9080.7 msSELECTSELECT 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))

[+] Explain
14:37:33.9090.9 msSELECTSELECT 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))

[+] Explain
14:37:33.9101.0 msINSERTINSERT 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.87"}]},"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:33') RETURNING "id"

[+] Explain