ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68673b97978b0: POST https://beta.jinchangxiao.com/vue/purchase-contract/save-edit-cost at 2025-07-04 10:25:27 am by 114.254.1.137

Database Queries

总计59条数据
TimeDurationTypeQuery
  
10:25:27.6242.3 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
10:25:27.6271.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
10:25:27.6290.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"='3851'

[+] Explain
10:25:27.6320.4 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='689')

[+] Explain
10:25:27.6330.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1011')

[+] Explain
10:25:27.6330.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)

[+] Explain
10:25:27.6341.2 msINSERTINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'amount', 3851, 13, 1001, 'now()', '["867867\u5143"]', '["875845\u5143"]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5408\u540c\u603b\u989d","d4":["875845\u5143 <b>\u53d8\u4e3a<\/b> 867867\u5143"]}')

[+] Explain
10:25:27.6350.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("term_id"=18) AND ("object_type"=8) AND ("object_id"=3851) ORDER BY "id"

[+] Explain
10:25:27.6360.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=369

[+] Explain
10:25:27.6360.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=372

[+] Explain
10:25:27.6370.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='372'

[+] Explain
10:25:27.6370.8 msINSERTINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'costContractAmounts', 3851, 13, 1001, 'now()', '[["\u98de\u673a\u7968:867867\u5143"]]', '[["\u9910\u996e\u8d39:7978\u5143","\u98de\u673a\u7968:867867\u5143"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u8d39\u7528\u4fe1\u606f","d4":["\u9910\u996e\u8d39:7978\u5143;\u98de\u673a\u7968:867867\u5143; <b>\u53d8\u4e3a<\/b> \u98de\u673a\u7968:867867\u5143;"]}')

[+] Explain
10:25:27.6380.7 msDELETEDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=3851) AND ("term_id"=18) AND ("object_type"=8)

[+] Explain
10:25:27.6391.0 msINSERTINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "object_type", "taxonomy_id", "out_amount", "value", "object_id", "extra_int") VALUES (18, 8, 372, '867867', '', 3851, 183)

[+] Explain
10:25:27.6401.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id"=3851)

[+] Explain
10:25:27.6411.1 msDELETEDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id"=3851)

[+] Explain
10:25:27.6431.0 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=111) AND ("object_id"=3851)

[+] Explain
10:25:27.6441.0 msDELETEDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=111) AND ("object_id"=3851)

[+] Explain
10:25:27.6450.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=3851

[+] Explain
10:25:27.6450.7 msDELETEDELETE FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=3851

[+] Explain
10:25:27.6460.3 msDELETEDELETE FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "purchase_id"=3851

[+] Explain
10:25:27.6471.5 msINSERTINSERT INTO "a57be577deb434"."tbl_purchase_client_rels" ("contract_id", "client_id", "project_id") VALUES (3851, 982, 1018) RETURNING "id"

[+] Explain
10:25:27.6491.0 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\PurchaseClientRels', 3143, 'a:4:{s:2:"id";i:3143;s:11:"contract_id";i:3851;s:9:"client_id";s:3:"982";s:10:"project_id";s:4:"1018";}', '', 1001, '114.254.1.137')

[+] Explain
10:25:27.6500.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"='1018'

[+] Explain
10:25:27.6510.4 msSELECTSELECT "id" FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "contract_id"=3851

[+] Explain
10:25:27.6510.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=3851

[+] Explain
10:25:27.6510.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE 0=1

[+] Explain
10:25:27.6520.1 msDELETEDELETE FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE 0=1

[+] Explain
10:25:27.6520.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='689')

[+] Explain
10:25:27.6520.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1011')

[+] Explain
10:25:27.6530.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)

[+] Explain
10:25:27.6530.8 msUPDATEUPDATE "a57be577deb434"."tbl_purchase_contracts" SET "supplier_id"=689, "amount"='867867', "handler"=1011, "updated_at"='now()', "including_tax"=TRUE WHERE "id"=3851

[+] Explain
10:25:27.6540.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\PurchaseContracts', 3851, 'a:1:{s:6:"amount";i:867867;}', '', 1001, '114.254.1.137')

[+] Explain
10:25:27.6550.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='689'

[+] Explain
10:25:27.6550.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='689')

[+] Explain
10:25:27.6560.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1011')

[+] Explain
10:25:27.6560.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)

[+] Explain
10:25:27.6560.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\PurchaseContracts', 3851, 'a:0:{}', '', 1001, '114.254.1.137')

[+] Explain
10:25:27.6570.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='689'

[+] Explain
10:25:27.6570.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=3851

[+] Explain
10:25:27.6580.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=3851 ORDER BY "id"

[+] Explain
10:25:27.6580.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982

[+] Explain
10:25:27.6601.0 msUPDATEUPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=982

[+] Explain
10:25:27.66114.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=982) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1

[+] Explain
10:25:27.6761.0 msINSERTINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (982, 1001, 'now()', NULL) RETURNING "id"

[+] Explain
10:25:27.6770.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ClientAmChangeLogs', 165061, 'a:5:{s:2:"id";i:165061;s:9:"client_id";i:982;s:9:"sales_rep";i:1001;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '114.254.1.137')

[+] Explain
10:25:27.6780.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Clients', 982, 'a:0:{}', '', 1001, '114.254.1.137')

[+] Explain
10:25:27.6790.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', 982, 10, 3851, 13, 1001, '[3851]', '[3851]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u8d39\u7528\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:(\u672a\u8bbe\u7f6e)"]}') RETURNING "id"

[+] Explain
10:25:27.6801.0 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 509886, 'a:13:{s:2:"id";i:509886;s:9:"object_id";i:982;s:11:"object_type";i:10;s:9:"target_id";i:3851;s:18:"target_object_type";i:13;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[3851]";s:9:"new_value";s:6:"[3851]";s:11:"description";s:140:"{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u8d39\u7528\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, '114.254.1.137')

[+] Explain
10:25:27.6810.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=1018

[+] Explain
10:25:27.6820.9 msUPDATEUPDATE "a57be577deb434"."tbl_projects" SET "updated_at"='now()' WHERE "id"=1018

[+] Explain
10:25:27.6831.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=1018) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1

[+] Explain
10:25:27.6850.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 1018, 'a:1:{s:6:"end_at";s:19:"2022-08-02 11:44:02";}', '', 1001, '114.254.1.137')

[+] Explain
10:25:27.6860.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982

[+] Explain
10:25:27.6860.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', 1018, 1, 3851, 13, 1001, '[3851]', '[3851]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u8d39\u7528\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:(\u672a\u8bbe\u7f6e)"]}') RETURNING "id"

[+] Explain
10:25:27.6870.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 509887, 'a:13:{s:2:"id";i:509887;s:9:"object_id";i:1018;s:11:"object_type";i:1;s:9:"target_id";i:3851;s:18:"target_object_type";i:13;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[3851]";s:9:"new_value";s:6:"[3851]";s:11:"description";s:140:"{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u8d39\u7528\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, '114.254.1.137')

[+] Explain
10:25:27.6880.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', 689, 12, 3851, 13, 1001, '[3851]', '[3851]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u8d39\u7528\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:(\u672a\u8bbe\u7f6e)"]}') RETURNING "id"

[+] Explain
10:25:27.6890.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 509888, 'a:13:{s:2:"id";i:509888;s:9:"object_id";i:689;s:11:"object_type";i:12;s:9:"target_id";i:3851;s:18:"target_object_type";i:13;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[3851]";s:9:"new_value";s:6:"[3851]";s:11:"description";s:140:"{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u8d39\u7528\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, '114.254.1.137')

[+] Explain
10:25:27.6901.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-edit-cost', '{"PurchaseContracts":{"id":"3851","supplier_id":"689","amount":"867867","handler":"1011","serial_no":"","signed_at":"2025-07-04","description":"","including_tax":"1","contractScans":"","receiptScans":"","purchaseClientRels":[{"client_id":"982","project_id":"1018"}],"PurchaseContractInvoices":"","costContractAmounts":[{"id":"372","amount":"867867","description":"","parent_id":"183"}]},"web_access_token":"er_liQPTz011rRwTshQzixBLTwcD6PCJ"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u91c7\u8d2d\u5408\u540c\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0}', FALSE, '2025-07-04 10:25:27') RETURNING "id"

[+] Explain