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

Database Queries

总计43条数据
TimeDurationTypeQuery
  
14:35:37.4903.3 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=5252

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

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

[+] Explain
14:35:37.5001.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"='4077'

[+] Explain
14:35:37.5040.5 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=431)

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

[+] Explain
14:35:37.5050.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)

[+] Explain
14:35:37.5050.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=431)

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

[+] Explain
14:35:37.5060.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)

[+] Explain
14:35:37.5061.2 msUPDATEUPDATE "a57be577deb434"."tbl_purchase_contracts" SET "updated_at"='now()', "payment_collection_remind_ahead"='0 day', "is_save_collection"=TRUE, "save_collection_at"='now()' WHERE "id"=4077

[+] Explain
14:35:37.5081.1 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\PurchaseContracts', 4077, '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:35:37.5090.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=431

[+] Explain
14:35:37.5100.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE "contract_id"=4077

[+] Explain
14:35:37.5101.1 msINSERTINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'purchaseContractPaymentCollectionRemindDates', 4077, 13, 1001, 'now()', '[["2025-08-12 1500\u5143","2025-08-16 1500\u5143"]]', '[[]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u4ed8\u6b3e\u8ba1\u5212","d4":["(\u672a\u8bbe\u7f6e) <b>\u53d8\u4e3a<\/b> 2025-08-12 1500\u5143;2025-08-16 1500\u5143;"]}')

[+] Explain
14:35:37.5120.2 msDELETEDELETE FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE "contract_id"=4077

[+] Explain
14:35:37.5120.3 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4077)

[+] Explain
14:35:37.5130.9 msINSERTINSERT INTO "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" ("contract_id", "remind_date", "amount", "pct", "reminded") VALUES (4077, '2025-08-12', '1500', 50, FALSE) RETURNING "id"

[+] Explain
14:35:37.5140.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', 816, 'a:9:{s:2:"id";i:816;s:11:"contract_id";i:4077;s:11:"remind_date";s:10:"2025-08-12";s:8:"reminded";b:0;s:6:"amount";i:1500;s:11:"paid_amount";N;s:12:"overdue_days";N;s:6:"status";N;s:3:"pct";i:50;}', '', 1001, '124.64.23.198')

[+] Explain
14:35:37.5150.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4077)

[+] Explain
14:35:37.5150.8 msINSERTINSERT INTO "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" ("contract_id", "remind_date", "amount", "pct", "reminded") VALUES (4077, '2025-08-16', '1500', 50, FALSE) RETURNING "id"

[+] Explain
14:35:37.5160.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', 817, 'a:9:{s:2:"id";i:817;s:11:"contract_id";i:4077;s:11:"remind_date";s:10:"2025-08-16";s:8:"reminded";b:0;s:6:"amount";i:1500;s:11:"paid_amount";N;s:12:"overdue_days";N;s:6:"status";N;s:3:"pct";i:50;}', '', 1001, '124.64.23.198')

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

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

[+] Explain
14:35:37.5190.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_receivers" WHERE "contract_id"=4077

[+] Explain
14:35:37.5200.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1011'

[+] Explain
14:35:37.5200.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='5360'

[+] Explain
14:35:37.5210.7 msINSERTINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'purchaseContractPaymentCollectionRemindReceivers', 4077, 13, 1001, 'now()', '[["\u97e9\u96c5\u82b3","\u5f20\u7ea2\u82b3"]]', '[[]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u4ed8\u6b3e\u63d0\u9192\u4eba","d4":["(\u672a\u8bbe\u7f6e) <b>\u53d8\u4e3a<\/b> \u97e9\u96c5\u82b3;\u5f20\u7ea2\u82b3;"]}')

[+] Explain
14:35:37.5210.2 msDELETEDELETE FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_receivers" WHERE "contract_id"=4077

[+] Explain
14:35:37.5221.0 msINSERTINSERT INTO "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_receivers" ("contract_id", "user_id") VALUES (4077, 1011) RETURNING "id"

[+] Explain
14:35:37.5230.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', 1376, 'a:3:{s:2:"id";i:1376;s:11:"contract_id";i:4077;s:7:"user_id";s:4:"1011";}', '', 1001, '124.64.23.198')

[+] Explain
14:35:37.5240.8 msINSERTINSERT INTO "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_receivers" ("contract_id", "user_id") VALUES (4077, 5360) RETURNING "id"

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

[+] Explain
14:35:37.5260.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4077

[+] Explain
14:35:37.5260.7 msUPDATEUPDATE "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4077

[+] Explain
14:35:37.5270.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"=4077) AND ("t"."status" IN (2, 5, 1))

[+] Explain
14:35:37.5280.6 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"=4077) AND ("t"."status" IN (2, 5, 1))

[+] Explain
14:35:37.5290.8 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"=4077) AND ("t"."status" IN (2, 5, 1))

[+] Explain
14:35:37.5300.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4077

[+] Explain
14:35:37.5300.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=4077 ORDER BY "id"

[+] Explain
14:35:37.5310.8 msINSERTINSERT 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', 431, 12, 4077, 13, 1001, '[4077]', '[4077]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u91c7\u8d2d\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:(\u672a\u8bbe\u7f6e)"]}') RETURNING "id"

[+] Explain
14:35:37.5320.8 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 551978, 'a:13:{s:2:"id";i:551978;s:9:"object_id";i:431;s:11:"object_type";i:12;s:9:"target_id";i:4077;s:18:"target_object_type";i:13;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[4077]";s:9:"new_value";s:6:"[4077]";s:11:"description";s:140:"{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u91c7\u8d2d\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:(\u672a\u8bbe\u7f6e)"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '124.64.23.198')

[+] Explain
14:35:37.5331.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":"4077","budget":"3000","payment_collection_remind_ahead":"","purchaseContractPaymentCollectionRemindReceivers":["1011","5360"],"purchaseContractPaymentCollectionRemindDates":[{"remind_date":"2025-08-12","amount":"1500","pct":"50"},{"remind_date":"2025-08-16","amount":"1500","pct":"50"}]},"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:35:37') RETURNING "id"

[+] Explain