ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
686748178f81c: POST https://beta.jinchangxiao.com/vue/purchase-contract/save-new-cost at 2025-07-04 11:18:47 am by 114.254.1.137

Database Queries

总计32条数据
TimeDurationTypeQuery
  
11:18:47.5923.3 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
11:18:47.5971.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
11:18:47.6031.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "serial_no"='42')

[+] Explain
11:18:47.6050.5 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='689')

[+] Explain
11:18:47.6060.3 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1011')

[+] Explain
11:18:47.6060.3 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)

[+] Explain
11:18:47.6073.0 msINSERTINSERT INTO "a57be577deb434"."tbl_purchase_contracts" ("amount", "created_by", "signed_at", "cost_type", "contract_type", "supplier_id", "handler", "serial_no", "description", "including_tax", "payment_collection_remind_ahead") VALUES ('544', 1001, '2025-07-04', 2, 4, 689, 1011, '42', '', TRUE, '0 day') RETURNING "id"

[+] Explain
11:18:47.6101.3 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\PurchaseContracts', 3853, 'a:21:{s:2:"id";i:3853;s:11:"supplier_id";s:3:"689";s:13:"contract_type";i:4;s:9:"signed_at";s:10:"2025-07-04";s:6:"amount";s:3:"544";s:7:"handler";s:4:"1011";s:11:"description";s:0:"";s:13:"contract_scan";N;s:10:"created_by";i:1001;s:10:"created_at";N;s:10:"updated_at";N;s:9:"client_id";N;s:10:"project_id";N;s:9:"sales_rep";N;s:9:"serial_no";s:2:"42";s:31:"payment_collection_remind_ahead";s:5:"0 day";s:13:"including_tax";s:1:"1";s:18:"is_save_collection";N;s:18:"save_collection_at";N;s:13:"is_chargeback";N;s:9:"cost_type";i:2;}', '', 1001, '114.254.1.137')

[+] Explain
11:18:47.6120.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='689'

[+] Explain
11:18:47.6131.2 msDELETEDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=3853) AND ("term_id"=18) AND ("object_type"=8)

[+] Explain
11:18:47.6166.0 msINSERTINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "object_type", "taxonomy_id", "out_amount", "value", "object_id", "extra_int") VALUES (18, 8, 369, '544', '', 3853, 185)

[+] Explain
11:18:47.6222.1 msDELETEDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id"=3853)

[+] Explain
11:18:47.6262.2 msDELETEDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=111) AND ("object_id"=3853)

[+] Explain
11:18:47.6280.5 msDELETEDELETE FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=3853

[+] Explain
11:18:47.6305.3 msDELETEDELETE FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "purchase_id"=3853

[+] Explain
11:18:47.6380.7 msSELECTSELECT "id" FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "contract_id"=3853

[+] Explain
11:18:47.6390.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=3853

[+] Explain
11:18:47.6390.2 msDELETEDELETE FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE 0=1

[+] Explain
11:18:47.6420.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=3853

[+] Explain
11:18:47.6430.3 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)

[+] Explain
11:18:47.6431.1 msINSERTINSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "is_system", "description2") VALUES (1001, '13', 3853, '刘人诚创建了一条费用合同', TRUE, '采购合同：42') RETURNING "id"

[+] Explain
11:18:47.6450.9 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Comments', 170249, 'a:11:{s:2:"id";i:170249;s:9:"object_id";i:3853;s:11:"object_type";s:2:"13";s:6:"parent";N;s:11:"description";s:36:"刘人诚创建了一条费用合同";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:17:"采购合同：42";}', '', 1001, '114.254.1.137')

[+] Explain
11:18:47.6461.1 msINSERTINSERT INTO "a57be577deb434"."tbl_unread_comments" ("object_id", "object_type", "comment_id", "remind_user_id") VALUES (3853, '13', 170249, '1011')

[+] Explain
11:18:47.6470.3 msSELECTSELECT "channel_id" FROM "global"."tbl_logins" WHERE ("id"='1011') AND ("id" != 1001) AND (channel_id IS NOT NULL)

[+] Explain
11:18:47.6480.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
11:18:47.6510.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=3853

[+] Explain
11:18:47.6521.2 msINSERTINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (1, 'create', 3853, 13, 1001, '2025-07-04 11:18:47', '{"id":3853,"supplier_id":689,"contract_type":4,"signed_at":"2025-07-04","amount":"544","handler":1011,"description":"","contract_scan":null,"created_by":1001,"created_at":"2025-07-04 11:18:47","updated_at":"2025-07-04 11:18:47","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"42","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":false,"save_collection_at":null,"is_chargeback":false,"cost_type":2}', '{"id":3853,"supplier_id":689,"contract_type":4,"signed_at":"2025-07-04","amount":"544","handler":1011,"description":"","contract_scan":null,"created_by":1001,"created_at":"2025-07-04 11:18:47","updated_at":"2025-07-04 11:18:47","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"42","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":false,"save_collection_at":null,"is_chargeback":false,"cost_type":2}', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u8d39\u7528\u5408\u540c","d4":[]}') RETURNING "id"

[+] Explain
11:18:47.6530.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', 509992, 'a:13:{s:2:"id";i:509992;s:9:"object_id";i:3853;s:11:"object_type";i:13;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:452:"{"id":3853,"supplier_id":689,"contract_type":4,"signed_at":"2025-07-04","amount":"544","handler":1011,"description":"","contract_scan":null,"created_by":1001,"created_at":"2025-07-04 11:18:47","updated_at":"2025-07-04 11:18:47","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"42","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":false,"save_collection_at":null,"is_chargeback":false,"cost_type":2}";s:9:"new_value";s:452:"{"id":3853,"supplier_id":689,"contract_type":4,"signed_at":"2025-07-04","amount":"544","handler":1011,"description":"","contract_scan":null,"created_by":1001,"created_at":"2025-07-04 11:18:47","updated_at":"2025-07-04 11:18:47","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"42","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":false,"save_collection_at":null,"is_chargeback":false,"cost_type":2}";s:11:"description";s:93:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u8d39\u7528\u5408\u540c","d4":[]}";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2025-07-04 11:18:47";s:9:"is_delete";N;}', '', 1001, '114.254.1.137')

[+] Explain
11:18:47.6540.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=3853 ORDER BY "id"

[+] Explain
11:18:47.6550.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 (1, 'create', 689, 12, 3853, 13, 1001, '[3853]', '[3853]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u8d39\u7528\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:42"]}') RETURNING "id"

[+] Explain
11:18:47.6560.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', 509993, 'a:13:{s:2:"id";i:509993;s:9:"object_id";i:689;s:11:"object_type";i:12;s:9:"target_id";i:3853;s:18:"target_object_type";i:13;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:6:"[3853]";s:9:"new_value";s:6:"[3853]";s:11:"description";s:122:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u8d39\u7528\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:42"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '114.254.1.137')

[+] Explain
11:18:47.6571.1 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-new-cost', '{"PurchaseContracts":{"id":"","supplier_id":"689","amount":"544","handler":"1011","serial_no":"42","signed_at":"2025-07-04","description":"","including_tax":"1","contractScans":"","receiptScans":"","purchaseClientRels":"","PurchaseContractInvoices":"","costContractAmounts":[{"id":"369","amount":"544","description":"","parent_id":"185"}]},"web_access_token":"er_liQPTz011rRwTshQzixBLTwcD6PCJ"}', '{"code":2000,"result":{"id":3853},"status":1,"msg":[{"name":"success","success":"\u65b0\u91c7\u8d2d\u5408\u540c\u5df2\u521b\u5efa\u6210\u529f","error":""}],"mod":0}', FALSE, '2025-07-04 11:18:47') RETURNING "id"

[+] Explain