6a223effd1cee: POST https://beta.jinchangxiao.com/vue/project/save-edit at 2026-06-05 11:14:07 am by 221.216.117.119
Database Queries
总计111条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 11:14:07.861 | 0.6 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 11:14:07.862 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 11:14:07.864 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3957' |
| 11:14:07.867 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=3957 |
| 11:14:07.867 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (1, 128, 142, 184, 189, 349)) ORDER BY "sort" |
| 11:14:07.868 | 0.4 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE ("client_id"='2130') AND ("project_title"='中国人民解放军总参谋部第五十一研究所试制工厂-高性能') AND ("id" != 3957)) |
| 11:14:07.869 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contract_types" WHERE "id"='1') |
| 11:14:07.869 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2130') |
| 11:14:07.869 | 0.1 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_progresses" WHERE "id"='2') |
| 11:14:07.869 | 0.1 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"='3') |
| 11:14:07.870 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5087) |
| 11:14:07.870 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5087) |
| 11:14:07.871 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id"=3957) |
| 11:14:07.871 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 11:14:07.872 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=3957 |
| 11:14:07.872 | 0.3 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=3957 |
| 11:14:07.873 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=2 |
| 11:14:07.873 | 0.5 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_project_product_types" ("project_id", "product_type_id", "name", "budget", "pct", "profit") VALUES (3957, 2, '服务器', '20000000', 20, '4000000') |
| 11:14:07.874 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=3957 ORDER BY "id" |
| 11:14:07.874 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3957 |
| 11:14:07.875 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=3957 ORDER BY "id" |
| 11:14:07.876 | 1.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3957) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 11:14:07.878 | 0.5 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 3957, 'a:0:{}', '', 1001, '221.216.117.119') |
| 11:14:07.879 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2130 |
| 11:14:07.880 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3957 |
| 11:14:07.880 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=3957 ORDER BY "id" |
| 11:14:07.881 | 2.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_order_items" WHERE "project_id"=3957 |
| 11:14:07.884 | 1.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3957) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 11:14:07.885 | 0.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 3957, 'a:0:{}', '', 1001, '221.216.117.119') |
| 11:14:07.886 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2130 |
| 11:14:07.886 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3957 |
| 11:14:07.887 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id"=3957 |
| 11:14:07.887 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE "project_id"=3957 |
| 11:14:07.888 | 2.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'bargain_date', 3957, 1, 1001, 'now()', '["2026-06-05"]', '["2026-10-31"]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u6210\u4ea4\u65e5\u671f","d4":["2026-10-31 <b>\u53d8\u4e3a<\/b> 2026-06-05"]}') |
| 11:14:07.890 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2130' |
| 11:14:07.891 | 0.5 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_user_action_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "users", "description") VALUES (2, 'bargain_date', 3957, 1, 1001, 'now()', '["2026-06-05"]', '["2026-10-31"]', array[5087], '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u6210\u4ea4\u65e5\u671f","d4":["2026-10-31 <b>\u53d8\u4e3a<\/b> 2026-06-05"]}') |
| 11:14:07.892 | 2.4 ms | UPDATE | UPDATE "a57be577deb434"."tbl_projects" SET "client_id"=2130, "project_progress"=2, "budget"='20000000', "profit_pct"='20', "bargain_date"='2026-06-05', "updated_at"='now()', "status_updated_at"='now()', "contract_type"=1, "from_contact"=NULL, "change_status_to"=3 WHERE "id"=3957 |
| 11:14:07.894 | 1.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3957) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 11:14:07.896 | 0.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 3957, 'a:2:{s:12:"bargain_date";s:10:"2026-06-05";s:16:"change_status_to";i:3;}', '', 1001, '221.216.117.119') |
| 11:14:07.896 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2130' |
| 11:14:07.896 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 11:14:07.897 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_architects" WHERE "project_id"=3957 |
| 11:14:07.897 | 0.2 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_project_architects" WHERE "project_id"=3957 |
| 11:14:07.898 | 0.5 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_project_architects" ("project_id", "engineer_id", "contribution", "created_by") VALUES (3957, 1015, '1', 1001) |
| 11:14:07.898 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=3957 |
| 11:14:07.899 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (1, 128, 142, 184, 189, 349)) ORDER BY "sort" |
| 11:14:07.899 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=128 |
| 11:14:07.899 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='128' |
| 11:14:07.900 | 0.1 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=3957) AND ("term_id"=9) |
| 11:14:07.900 | 0.5 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (9, 128, 3957) |
| 11:14:07.901 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=142 |
| 11:14:07.901 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='142' |
| 11:14:07.901 | 0.1 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=3957) AND ("term_id"=13) |
| 11:14:07.901 | 0.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (13, 142, 3957) |
| 11:14:07.902 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=3957 |
| 11:14:07.902 | 0.2 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=3957 |
| 11:14:07.903 | 0.4 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_project_remind_receivers" ("project_id", "user_id") VALUES (3957, 1001) RETURNING "id" |
| 11:14:07.903 | 0.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ProjectRemindReceivers', 2192, 'a:3:{s:2:"id";i:2192;s:10:"project_id";i:3957;s:7:"user_id";s:4:"1001";}', '', 1001, '221.216.117.119') |
| 11:14:07.903 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=3957 |
| 11:14:07.904 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_used_clients" WHERE "project_id"=3957 |
| 11:14:07.905 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_receivers" WHERE 0=1 |
| 11:14:07.905 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" WHERE 0=1 |
| 11:14:07.906 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_used_client_payments" WHERE 0=1 |
| 11:14:07.906 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_used_client_invoices" WHERE 0=1 |
| 11:14:07.906 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2130' |
| 11:14:07.907 | 2.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=2130 |
| 11:14:07.910 | 17.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=2130) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 11:14:07.928 | 1.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (2130, 5087, 'now()', NULL) RETURNING "id" |
| 11:14:07.929 | 0.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ClientAmChangeLogs', 199911, 'a:5:{s:2:"id";i:199911;s:9:"client_id";i:2130;s:9:"sales_rep";i:5087;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '221.216.117.119') |
| 11:14:07.929 | 0.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Clients', 2130, 'a:0:{}', '', 1001, '221.216.117.119') |
| 11:14:07.930 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 11:14:07.930 | 0.3 ms | INSERT | INSERT 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', 2130, 10, 3957, 1, 1001, '[3957]', '[3957]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a","d4":["\u4e2d\u56fd\u4eba\u6c11\u89e3\u653e\u519b\u603b\u53c2\u8c0b\u90e8\u7b2c\u4e94\u5341\u4e00\u7814\u7a76\u6240\u8bd5\u5236\u5de5\u5382-\u9ad8\u6027\u80fd"]}') RETURNING "id" |
| 11:14:07.931 | 0.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 641307, 'a:13:{s:2:"id";i:641307;s:9:"object_id";s:4:"2130";s:11:"object_type";i:10;s:9:"target_id";i:3957;s:18:"target_object_type";i:1;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[3957]";s:9:"new_value";s:6:"[3957]";s:11:"description";s:234:"{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a","d4":["\u4e2d\u56fd\u4eba\u6c11\u89e3\u653e\u519b\u603b\u53c2\u8c0b\u90e8\u7b2c\u4e94\u5341\u4e00\u7814\u7a76\u6240\u8bd5\u5236\u5de5\u5382-\u9ad8\u6027\u80fd"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '221.216.117.119') |
| 11:14:07.931 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2130' |
| 11:14:07.931 | 0.3 ms | SELECT | SELECT COUNT(*) FROM "a57be577deb434"."tbl_projects" WHERE ("project_status"=3) AND ("bargain_date" >= '2026-01-01 00:00:00') AND ("bargain_date" <= '2026-12-31 23:59:59') AND ("client_id"=2130) |
| 11:14:07.933 | 16.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=2130) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 11:14:07.949 | 0.3 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (2130, 5087, 'now()', NULL) RETURNING "id" |
| 11:14:07.949 | 0.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ClientAmChangeLogs', 199912, 'a:5:{s:2:"id";i:199912;s:9:"client_id";i:2130;s:9:"sales_rep";i:5087;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '221.216.117.119') |
| 11:14:07.950 | 0.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Clients', 2130, 'a:0:{}', '', 1001, '221.216.117.119') |
| 11:14:07.951 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3957 |
| 11:14:07.951 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id"=3957) |
| 11:14:07.952 | 0.7 ms | UPDATE | UPDATE "a57be577deb434"."tbl_projects" SET "is_verify"=TRUE WHERE "id"=3957 |
| 11:14:07.953 | 1.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3957) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 11:14:07.955 | 0.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 3957, 'a:0:{}', '', 1001, '221.216.117.119') |
| 11:14:07.955 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2130 |
| 11:14:07.955 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=3957 |
| 11:14:07.956 | 3.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("created_at" >= '2026-06-05 00:00:00') AND ("created_at" <= '2026-06-05 23:59:59') AND ("serial_no" ILIKE '%XSDD-20260605-%') AND (LENGTH(serial_no) = 19) ORDER BY "serial_no" DESC |
| 11:14:07.961 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=3957 ORDER BY "id" |
| 11:14:07.962 | 4.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_verify_processes" WHERE "id"=6 |
| 11:14:07.967 | 1.3 ms | SELECT | SELECT "id" FROM "a57be577deb434"."tbl_users" WHERE ("id"='1001') AND ("user_status"='1') ORDER BY array_position(array[1001], id) |
| 11:14:07.968 | 6.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_erp_sales_orders" ("serial_no", "handler", "created_by", "amount", "wrote_date", "created_at", "verify_type", "status", "client_id", "project_id", "description", "extra", "outbound_status") VALUES ('XSDD-20260605-00006', 5087, 5087, '20000000', '2026-06-05', 'now()', 2, 1, 2130, 3957, NULL, '{"payment_collection_remind_ahead":"1 day","salesContractPaymentCollectionRemindReceivers":["1001","5087"],"salesContractPaymentCollectionRemindDates":null}', FALSE) RETURNING "id" |
| 11:14:07.974 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpSalesOrders', 1717, 'a:37:{s:2:"id";i:1717;s:9:"serial_no";s:19:"XSDD-20260605-00006";s:9:"from_date";N;s:10:"wrote_date";s:10:"2026-06-05";s:7:"handler";i:5087;s:9:"client_id";i:2130;s:20:"purchase_contract_id";N;s:10:"project_id";i:3957;s:17:"sales_contract_id";N;s:12:"erp_store_id";N;s:6:"status";i:1;s:16:"erp_send_type_id";N;s:8:"abstract";N;s:11:"description";N;s:11:"verify_type";s:1:"2";s:16:"next_verify_user";N;s:21:"next_stop_verify_user";N;s:23:"next_cancel_verify_user";N;s:9:"verify_at";N;s:7:"stop_at";N;s:9:"cancel_at";N;s:18:"refuse_description";N;s:14:"is_resubmitted";N;s:7:"is_done";N;s:6:"number";N;s:6:"amount";s:8:"20000000";s:10:"created_by";i:5087;s:16:"stop_description";N;s:5:"extra";s:156:"{"payment_collection_remind_ahead":"1 day","salesContractPaymentCollectionRemindReceivers":["1001","5087"],"salesContractPaymentCollectionRemindDates":null}";s:15:"outbound_status";b:0;s:7:"is_used";N;s:9:"is_cancel";N;s:9:"is_settle";N;s:6:"is_old";N;s:10:"created_at";s:19:"1970-01-01 08:00:00";s:10:"updated_at";N;s:11:"print_times";N;}', '', 1001, '221.216.117.119') |
| 11:14:07.975 | 0.8 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE "erp_sales_order_id"=1717 |
| 11:14:07.976 | 1.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_erp_sales_order_verify_rels" ("erp_sales_order_id", "user_id", "status") VALUES (1717, 1001, 0) |
| 11:14:07.978 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE ("status"=0) AND ("erp_sales_order_id"=1717) ORDER BY "id" |
| 11:14:07.978 | 0.6 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "amount"='0', "number"='0', "next_verify_user"=1001 WHERE "id"=1717 |
| 11:14:07.979 | 0.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrders', 1717, 'a:3:{s:6:"amount";i:0;s:16:"next_verify_user";i:1001;s:6:"number";i:0;}', '', 1001, '221.216.117.119') |
| 11:14:07.979 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "id"=1717 |
| 11:14:07.979 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5087 |
| 11:14:07.980 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE ("status"=0) AND ("erp_sales_order_id"=1717) ORDER BY "id" |
| 11:14:07.980 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE ("status"=0) AND ("erp_sales_order_id"=1717) ORDER BY "id" |
| 11:14:07.981 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 11:14:07.981 | 0.3 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (1, 'create', 1717, 20007, 1001, '2026-06-05 11:14:07', '{"id":1717,"serial_no":"XSDD-20260605-00006","from_date":null,"wrote_date":"2026-06-05","handler":5087,"client_id":2130,"purchase_contract_id":null,"project_id":3957,"sales_contract_id":null,"erp_store_id":null,"status":1,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":1001,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":null,"stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"0","created_by":5087,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"1001\",\"5087\"],\"salesContractPaymentCollectionRemindDates\":null}","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2026-06-05 11:14:07","updated_at":"2026-06-05 11:14:07","print_times":null}', '{"id":1717,"serial_no":"XSDD-20260605-00006","from_date":null,"wrote_date":"2026-06-05","handler":5087,"client_id":2130,"purchase_contract_id":null,"project_id":3957,"sales_contract_id":null,"erp_store_id":null,"status":1,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":1001,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":null,"stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"0","created_by":5087,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"1001\",\"5087\"],\"salesContractPaymentCollectionRemindDates\":null}","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2026-06-05 11:14:07","updated_at":"2026-06-05 11:14:07","print_times":null}', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u8ba2\u5355\u7533\u8bf7","d4":[]}') RETURNING "id" |
| 11:14:07.982 | 0.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 641308, 'a:13:{s:2:"id";i:641308;s:9:"object_id";i:1717;s:11:"object_type";i:20007;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:922:"{"id":1717,"serial_no":"XSDD-20260605-00006","from_date":null,"wrote_date":"2026-06-05","handler":5087,"client_id":2130,"purchase_contract_id":null,"project_id":3957,"sales_contract_id":null,"erp_store_id":null,"status":1,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":1001,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":null,"stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"0","created_by":5087,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"1001\",\"5087\"],\"salesContractPaymentCollectionRemindDates\":null}","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2026-06-05 11:14:07","updated_at":"2026-06-05 11:14:07","print_times":null}";s:9:"new_value";s:922:"{"id":1717,"serial_no":"XSDD-20260605-00006","from_date":null,"wrote_date":"2026-06-05","handler":5087,"client_id":2130,"purchase_contract_id":null,"project_id":3957,"sales_contract_id":null,"erp_store_id":null,"status":1,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":1001,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":null,"stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"0","created_by":5087,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"1001\",\"5087\"],\"salesContractPaymentCollectionRemindDates\":null}","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2026-06-05 11:14:07","updated_at":"2026-06-05 11:14:07","print_times":null}";s:11:"description";s:105:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u8ba2\u5355\u7533\u8bf7","d4":[]}";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2026-06-05 11:14:07";s:9:"is_delete";N;}', '', 1001, '221.216.117.119') |
| 11:14:07.982 | 0.5 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "amount"='20000000' WHERE "id"=1717 |
| 11:14:07.983 | 0.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrders', 1717, 'a:1:{s:6:"amount";s:8:"20000000";}', '', 1001, '221.216.117.119') |
| 11:14:07.983 | 1.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "erp_sales_order_id"=1717 |
| 11:14:07.985 | 0.5 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "is_used"=FALSE WHERE "id"=1717 |
| 11:14:07.986 | 0.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrders', 1717, 'a:0:{}', '', 1001, '221.216.117.119') |
| 11:14:07.986 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE 0=1 |
| 11:14:07.987 | 0.8 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/project/save-edit', '{"Projects":{"id":"3957","client_name":"\u5317\u4eac\u4eac\u822a\u8ba1\u7b97\u901a\u8baf\u7814\u7a76\u6240304","client_id":"2130","project_status":"3","project_progress":"2","profit":"4000000","profit_pct":"20","bargain_date":"2026-06-05","project_title":"\u4e2d\u56fd\u4eba\u6c11\u89e3\u653e\u519b\u603b\u53c2\u8c0b\u90e8\u7b2c\u4e94\u5341\u4e00\u7814\u7a76\u6240\u8bd5\u5236\u5de5\u5382-\u9ad8\u6027\u80fd","from_contact_name":"","from_contact":"","salesForecast":"142","purchaseType":"128","opportunityFrom":"","contract_type":"1","projectArchitects":{"1015":"1"},"comment":"\u9884\u7b972000\u4e07","projectRemindReceivers":["1001"],"payment_collection_remind_ahead":"1 day","project_product_version_id":"","projectProductRels":"","projectContactPoints":"","projectContactPointRels":"","projectUsedClient":{"used_client":"","budget":"","profit":"","profit_pct":"","projectUsedClientPaymentCollectionRemindReceivers":"","projectUsedClientPaymentCollectionRemindDates":"","remind_ahead":"","projectUsedClientPayments":"","projectUsedClientInvoices":""},"projectProductTypes":{"2":{"budget":"20000000","profit":"4000000","pct":"20"}},"salesContractPaymentCollectionRemindReceivers":["1001","5087"],"salesContractPaymentCollectionRemindDates":""},"web_access_token":"l4p3M_87vSdo8QF-blMLH4iPaepKw7vp"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u5546\u673a\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-05 11:14:07', 127696896) RETURNING "id" |