ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a222f31e0be9: POST https://beta.jinchangxiao.com/vue/project/save-edit at 2026-06-05 10:06:41 am by 221.216.117.119

Performance Profiling

Total processing time: 646 ms; Peak memory: 7.497 MB. Show Profiling Timeline

总计219条数据
TimeDurationCategoryInfo
  
10:06:42.126228.1 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_object_change_logs" SET "is_delete"=TRUE WHERE (("object_id"=4490) AND ("object_type"=7)) OR (("target_id"=4490) AND ("target_object_type"=7))
10:06:42.35447.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_user_action_logs" SET "is_delete"=TRUE WHERE (("object_id"=4490) AND ("object_type"=7)) OR (("target_id"=4490) AND ("target_object_type"=7))
10:06:41.99237.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=3311) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
10:06:42.43436.3 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4490
10:06:42.49825.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=3311) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
10:06:42.09219.3 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_comments" WHERE ("object_id"=4490) AND ("object_type"=7)
10:06:42.40317.7 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_comments" WHERE ("object_id"=4490) AND ("object_type"=7)
10:06:42.47616.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=3311) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
10:06:42.11213.4 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_id"=4490) AND ("object_type"=7)
10:06:42.42112.8 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_id"=4490) AND ("object_type"=7)
10:06:42.0632.7 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_unread_comments" ("object_id", "object_type", "comment_id", "remind_user_id") VALUES (1714, '20007', 220728, 1013), (1714, '20007', 220728, 5388), (1714, '20007', 220728, 5252)
10:06:41.9432.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4173) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
10:06:41.9602.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4173) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
10:06:41.9782.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4173) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
10:06:42.0662.2 msyii\db\Command::querySELECT "channel_id" FROM "global"."tbl_logins" WHERE ("id" IN (1013, 5388, 5252, 1001)) AND ("id" != 1001) AND (channel_id IS NOT NULL)
10:06:41.9862.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4173) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
10:06:42.5432.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4173) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
10:06:42.5512.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4173) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
10:06:42.0802.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4173) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
10:06:42.0391.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4173) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
10:06:42.0761.5 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_project_status_logs" ("project_id", "old_status", "new_status", "created_by", "created_at") VALUES (4173, 3, 2, 1001, 'now()') RETURNING "id"
10:06:42.4721.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4173) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
10:06:41.9761.2 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "collected"='0' WHERE "id"=4173
10:06:41.9721.2 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contracts" SET "erp_settle_amount"='0', "erp_un_settle_amount"='88221', "erp_all_settle_amount"='0' WHERE "id"=4490
10:06:41.9491.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=4173
10:06:41.9281.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='4173'
10:06:42.0461.0 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE "erp_sales_order_id"=1714
10:06:42.0521.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_carbon_copy_rels" WHERE "erp_sales_order_id"=1714
10:06:42.4971.0 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_clients" SET "cooperate_count"=0 WHERE "id"=3311
10:06:42.0691.0 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "status"=8, "cancel_at"='now()' WHERE "id"=1714
10:06:42.5620.9 msyii\db\Command::queryINSERT 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":"4173","project_status":"2"},"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 10:06:42', 641862912) RETURNING "id"
10:06:41.9810.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_status_logs" WHERE "project_id"=4173 ORDER BY "created_at" DESC
10:06:41.9380.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id"=4173)
10:06:42.0360.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=4173
10:06:42.0790.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "project_status"=2, "change_status_to"=NULL, "is_verify"=FALSE WHERE "id"=4173
10:06:41.9420.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "updated_at"='now()', "status_updated_at"='now()', "forecast_updated_at"='now()', "change_status_to"=2 WHERE "id"=4173
10:06:42.5560.8 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_ticket_change_logs" ("status", "ticket_type", "serial_no", "wrote_date", "description", "abstract", "amount", "client_id", "supplier_id", "contact_id", "user_id", "created_by", "created_at", "updated_at", "object_id", "verify_at") VALUES (8, 20007, 'XSDD-20260605-00003', '2026-06-01', NULL, NULL, '88221', 3311, NULL, NULL, NULL, 1001, '2026-06-05 10:06:37', '2026-06-05 10:06:41', 1714, '2026-06-05 10:06:37.493298+08') RETURNING "id"
10:06:42.0430.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contracts" SET "is_chargeback_verify"=TRUE WHERE "id"=4490
10:06:41.9460.8 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4173, 'a:1:{s:16:"change_status_to";s:1:"2";}', '', 1001, '221.216.117.119')
10:06:42.0380.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "is_verify"=TRUE WHERE "id"=4173
10:06:42.0310.8 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (3311, 1001, 'now()', NULL) RETURNING "id"
10:06:42.0540.7 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
10:06:42.0860.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sources" SET "project_status"=2 WHERE "project_id"=4173
10:06:42.0340.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id"=4173)
10:06:42.5290.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id"=4173)
10:06:41.9660.7 msyii\db\Command::querySELECT SUM(r.amount) 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"."sales_contract_id"=4490) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE)
10:06:42.0370.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "sales_contract_id"=4490 ORDER BY "id" DESC
10:06:42.0720.7 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'project_status', 4173, 1, 1001, 'now()', '["\u660e\u786e\u9700\u6c42"]', '["\u5546\u673a\u6210\u4ea4"]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a\u72b6\u6001","d4":["\u5546\u673a\u6210\u4ea4 <b>\u53d8\u4e3a<\/b> \u660e\u786e\u9700\u6c42"]}')
10:06:42.5420.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "collected"='0' WHERE "id"=4173
10:06:42.5340.7 msyii\db\Command::querySELECT SUM(r.amount) 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"."sales_contract_id"=4490) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE)
10:06:41.9690.7 msyii\db\Command::querySELECT EXISTS(SELECT "r".* 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"."sales_contract_id"=4490) AND ("t"."status"=1))
10:06:41.9650.7 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."sales_contract_id"=4490) AND ("t"."status" IN (2, 5))
10:06:41.9570.7 msyii\db\Command::querySELECT r.amount, t.wrote_date as created_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."sales_contract_id"=4490) AND ("t"."status" IN (2, 5, 1))
10:06:42.5330.7 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."sales_contract_id"=4490) AND ("t"."status" IN (2, 5))
10:06:42.5470.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_status_logs" WHERE "project_id"=4173 ORDER BY "created_at" DESC
10:06:42.0750.7 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_user_action_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "users", "description") VALUES (2, 'project_status', 4173, 1, 1001, 'now()', '["\u660e\u786e\u9700\u6c42"]', '["\u5546\u673a\u6210\u4ea4"]', array[1001], '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a\u72b6\u6001","d4":["\u5546\u673a\u6210\u4ea4 <b>\u53d8\u4e3a<\/b> \u660e\u786e\u9700\u6c42"]}')
10:06:41.9710.6 msyii\db\Command::querySELECT SUM(r.amount) 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"."sales_contract_id"=4490) AND ("t"."status" IN (1, 2, 5))
10:06:41.9680.6 msyii\db\Command::querySELECT EXISTS(SELECT "r".* FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."sales_contract_id"=4490) AND ("t"."status"=1))
10:06:42.5360.6 msyii\db\Command::querySELECT EXISTS(SELECT "r".* 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"."sales_contract_id"=4490) AND ("t"."status"=1))
10:06:41.9250.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:06:41.9700.6 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."sales_contract_id"=4490) AND ("t"."status" IN (1, 2, 5))
10:06:42.5350.6 msyii\db\Command::querySELECT EXISTS(SELECT "r".* FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."sales_contract_id"=4490) AND ("t"."status"=1))
10:06:42.5380.6 msyii\db\Command::querySELECT SUM(r.amount) 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"."sales_contract_id"=4490) AND ("t"."status" IN (1, 2, 5))
10:06:41.9840.6 msyii\db\Command::querySELECT r.amount, t.wrote_date as created_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."sales_contract_id"=4490) AND ("t"."status" IN (2, 5, 1))
10:06:42.5370.6 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."sales_contract_id"=4490) AND ("t"."status" IN (1, 2, 5))
10:06:42.5490.6 msyii\db\Command::querySELECT r.amount, t.wrote_date as created_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."sales_contract_id"=4490) AND ("t"."status" IN (2, 5, 1))
10:06:41.9520.6 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contracts" SET "save_collection_at"='now()' WHERE "id"=4490
10:06:41.9220.6 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
10:06:42.0920.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=4173
10:06:42.5580.6 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_erp_ticket_change_log_handlers" ("erp_ticket_change_log_id", "user_id") VALUES (2929, 1001)
10:06:42.4750.6 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=3311
10:06:42.0550.6 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "is_system", "description2") VALUES (1001, '20007', 1714, '刘人诚通过了这个审批', TRUE, 'XSDD-20260605-00003') RETURNING "id"
10:06:42.0880.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=3
10:06:42.0840.5 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_project_change_logs" ("project_id", "project_status", "budget", "profit_pct", "collected", "start_from", "end_at") VALUES (4173, 2, '88221', '10', '0', 'now()', NULL) RETURNING "id"
10:06:41.9630.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE ("contract_id"=4490) AND (amount > paid_amount) ORDER BY "remind_date"
10:06:42.4710.5 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "collected"='0' WHERE "id"=4173
10:06:41.9900.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE ("contract_id"=4490) AND (amount > paid_amount) ORDER BY "remind_date"
10:06:42.0860.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3311
10:06:42.5550.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE ("contract_id"=4490) AND (amount > paid_amount) ORDER BY "remind_date"
10:06:41.9510.5 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4173 ORDER BY "id")
10:06:41.9330.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (1, 165, 181, 184, 189, 349, 410)) ORDER BY "sort"
10:06:42.0490.5 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "status"=7, "next_cancel_verify_user"=NULL, "updated_at"='now()' WHERE "id"=1714
10:06:42.0460.5 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_order_verify_rels" SET "status"=3 WHERE ("erp_sales_order_id"=1714) AND ("status"=0)
10:06:42.5240.5 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (3311, 1001, 'now()', NULL) RETURNING "id"
10:06:41.9470.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3311
10:06:42.0590.5 msyii\db\Command::querySELECT "user_id" FROM "a57be577deb434"."tbl_auth_assignments" WHERE "item_name"='Treasurer'
10:06:42.0440.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3311
10:06:41.9530.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3311
10:06:41.9480.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:06:41.9650.5 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."sales_contract_id"=4490) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5))
10:06:42.0740.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3311
10:06:42.0500.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:06:42.0780.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3311
10:06:42.0570.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3311
10:06:42.0420.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3311
10:06:42.5320.4 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."sales_contract_id"=4490) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5))
10:06:41.9390.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:06:42.0600.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4490
10:06:42.0870.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:06:41.9630.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3311
10:06:41.9740.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3311
10:06:42.0620.4 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "is_system", "description2") VALUES (1001, '20007', 1714, '(2026-06-05-001)已退单，请关注退款金额', TRUE, 'XSDD-20260605-00003') RETURNING "id"
10:06:41.9560.4 msyii\db\Command::querySELECT r.amount, t.created_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."sales_contract_id"=4490) AND ("t"."status" IN (2, 5, 1))
10:06:42.4020.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3311
10:06:42.5370.4 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."sales_contract_id"=4490) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (1, 2, 5))
10:06:42.1260.4 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_visit_object_histories" WHERE ("object_id"=4490) AND ("object_type"=7)
10:06:42.5400.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3311
10:06:42.5310.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3311
10:06:41.9340.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE ("client_id"=3311) AND ("project_title"='测试工单人工成本问题') AND ("id" != 4173))
10:06:42.0700.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:06:41.9800.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3311
10:06:41.9700.4 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."sales_contract_id"=4490) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (1, 2, 5))
10:06:42.5460.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3311
10:06:42.0540.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "id"=1714
10:06:41.9890.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3311
10:06:41.9560.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4490
10:06:42.5340.4 msyii\db\Command::querySELECT EXISTS(SELECT "r".* FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."sales_contract_id"=4490) AND ("t"."status"=1))
10:06:42.5600.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:06:42.5590.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:06:41.9910.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3311
10:06:42.5540.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3311
10:06:41.9540.4 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_contract_default_remind_users" WHERE ("user_id"=1001) AND ("type"=1)
10:06:41.9670.4 msyii\db\Command::querySELECT EXISTS(SELECT "r".* FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."sales_contract_id"=4490) AND ("t"."status"=1))
10:06:41.9640.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4490
10:06:41.9820.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4490
10:06:42.5280.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4173
10:06:41.9830.4 msyii\db\Command::querySELECT r.amount, t.created_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."sales_contract_id"=4490) AND ("t"."status" IN (2, 5, 1))
10:06:41.9550.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4490
10:06:41.9370.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
10:06:42.0580.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4173
10:06:42.0330.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4173
10:06:41.9540.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4173
10:06:42.0600.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "id"=1714
10:06:42.5480.3 msyii\db\Command::querySELECT r.amount, t.created_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."sales_contract_id"=4490) AND ("t"."status" IN (2, 5, 1))
10:06:41.9590.3 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4490
10:06:42.0490.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE ("erp_sales_order_id"=1714) AND ("status"=0) ORDER BY "id"
10:06:41.9530.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4490, 'a:1:{s:18:"save_collection_at";s:5:"now()";}', '', 1001, '221.216.117.119')
10:06:42.0450.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4173
10:06:41.9350.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3311)
10:06:42.5300.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contracts" SET "is_chargeback_verify"=FALSE WHERE "id"=4490
10:06:42.5470.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4490
10:06:42.5550.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "id"=1714
10:06:42.0610.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
10:06:41.9890.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4173, 'a:0:{}', '', 1001, '221.216.117.119')
10:06:42.4930.3 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (3311, 1001, 'now()', NULL) RETURNING "id"
10:06:42.4940.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:06:41.9370.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
10:06:41.9850.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4173
10:06:41.9910.3 msyii\db\Command::querySELECT 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"=3311)
10:06:42.5390.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contracts" SET "erp_settle_amount"='0', "erp_un_settle_amount"='88221', "erp_all_settle_amount"='0' WHERE "id"=4490
10:06:42.5320.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4173
10:06:42.5480.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4490
10:06:42.4740.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3311
10:06:41.9580.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4173
10:06:41.9830.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4490
10:06:41.9740.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4173
10:06:41.9850.3 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4490
10:06:42.5570.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpTicketChangeLogs', 2929, 'a:17:{s:2:"id";i:2929;s:9:"serial_no";s:19:"XSDD-20260605-00003";s:11:"ticket_type";i:20007;s:10:"wrote_date";s:10:"2026-06-01";s:6:"status";i:8;s:11:"supplier_id";N;s:9:"client_id";i:3311;s:8:"abstract";N;s:11:"description";N;s:9:"verify_at";s:29:"2026-06-05 10:06:37.493298+08";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2026-06-05 10:06:37";s:10:"updated_at";s:19:"2026-06-05 10:06:41";s:10:"contact_id";N;s:7:"user_id";N;s:6:"amount";s:5:"88221";s:9:"object_id";i:1714;}', '', 1001, '221.216.117.119')
10:06:42.5500.3 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4490
10:06:41.9730.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4490, 'a:0:{}', '', 1001, '221.216.117.119')
10:06:42.5500.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4173
10:06:42.5400.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4173
10:06:41.9320.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=4173
10:06:41.9620.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4173, 'a:0:{}', '', 1001, '221.216.117.119')
10:06:41.9800.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4173, 'a:0:{}', '', 1001, '221.216.117.119')
10:06:42.0620.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Comments', 220728, 'a:11:{s:2:"id";i:220728;s:9:"object_id";i:1714;s:11:"object_type";s:5:"20007";s:6:"parent";N;s:11:"description";s:49:"(2026-06-05-001)已退单，请关注退款金额";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:19:"XSDD-20260605-00003";}', '', 1001, '221.216.117.119')
10:06:42.4740.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3311
10:06:42.5410.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4173
10:06:41.9750.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4173
10:06:42.5600.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (15, 'status', 1714, 20007, 1001, 'now()', '["\u5218\u4eba\u8bda"]', '[]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u9000\u5355\u4e86","d3":"\u9500\u552e\u8ba2\u5355\u7533\u8bf7","d4":""}')
10:06:42.4950.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3311
10:06:42.0320.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Clients', 3311, 'a:0:{}', '', 1001, '221.216.117.119')
10:06:42.0910.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:06:42.4030.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4173
10:06:42.0320.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ClientAmChangeLogs', 199894, 'a:5:{s:2:"id";i:199894;s:9:"client_id";i:3311;s:9:"sales_rep";i:1001;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '221.216.117.119')
10:06:42.0830.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_change_logs" SET "end_at"='now()' WHERE "id"=17861
10:06:42.0500.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrders', 1714, 'a:1:{s:6:"status";i:7;}', '', 1001, '221.216.117.119')
10:06:42.0470.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrders', 1714, 'a:0:{}', '', 1001, '221.216.117.119')
10:06:42.0780.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ProjectStatusLogs', 4366, 'a:6:{s:2:"id";i:4366;s:10:"project_id";i:4173;s:10:"new_status";i:2;s:10:"old_status";i:3;s:10:"created_by";i:1001;s:10:"created_at";s:19:"1970-01-01 08:00:00";}', '', 1001, '221.216.117.119')
10:06:42.0530.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE "erp_sales_order_id"=1714 ORDER BY "id"
10:06:42.4960.3 msyii\db\Command::querySELECT 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"=3311)
10:06:42.0510.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE ("status"=0) AND ("erp_sales_order_id"=1714) ORDER BY "id"
10:06:42.0710.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=2
10:06:42.0900.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
10:06:42.0480.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_verify_processes" WHERE "id"=6
10:06:42.0830.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectChangeLogs', 17861, 'a:1:{s:6:"end_at";s:19:"1970-01-01 08:00:00";}', '', 1001, '221.216.117.119')
10:06:42.0900.3 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "is_system", "description", "description2") VALUES (1001, '1', 4173, TRUE, '刘人诚更新了一条商机状态商机成交变为明确需求', '') RETURNING "id"
10:06:42.0350.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrders', 1714, 'a:0:{}', '', 1001, '221.216.117.119')
10:06:42.0410.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4173, 'a:0:{}', '', 1001, '221.216.117.119')
10:06:42.4940.2 msyii\db\Command::queryINSERT 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', 3311, 10, 4173, 1, 1001, '[4173]', '[4173]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a","d4":["\u6d4b\u8bd5\u5de5\u5355\u4eba\u5de5\u6210\u672c\u95ee\u9898"]}') RETURNING "id"
10:06:42.5240.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ClientAmChangeLogs', 199896, 'a:5:{s:2:"id";i:199896;s:9:"client_id";i:3311;s:9:"sales_rep";i:1001;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '221.216.117.119')
10:06:42.0560.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Comments', 220727, 'a:11:{s:2:"id";i:220727;s:9:"object_id";i:1714;s:11:"object_type";s:5:"20007";s:6:"parent";N;s:11:"description";s:30:"刘人诚通过了这个审批";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:19:"XSDD-20260605-00003";}', '', 1001, '221.216.117.119')
10:06:41.9360.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_progresses" WHERE "id"=3)
10:06:42.0840.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ProjectChangeLogs', 17862, 'a:8:{s:2:"id";i:17862;s:10:"project_id";i:4173;s:14:"project_status";i:2;s:6:"budget";s:5:"88221";s:10:"profit_pct";s:2:"10";s:9:"collected";s:1:"0";s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '221.216.117.119')
10:06:42.0700.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrders', 1714, 'a:1:{s:6:"status";i:8;}', '', 1001, '221.216.117.119')
10:06:42.5310.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4490, 'a:0:{}', '', 1001, '221.216.117.119')
10:06:42.5540.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4173, 'a:0:{}', '', 1001, '221.216.117.119')
10:06:42.5460.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4173, 'a:0:{}', '', 1001, '221.216.117.119')
10:06:42.0430.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4490, 'a:0:{}', '', 1001, '221.216.117.119')
10:06:42.0890.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4173
10:06:42.5250.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Clients', 3311, 'a:0:{}', '', 1001, '221.216.117.119')
10:06:42.0850.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4173, 'a:0:{}', '', 1001, '221.216.117.119')
10:06:42.0730.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=2
10:06:42.5390.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4490, 'a:0:{}', '', 1001, '221.216.117.119')
10:06:41.9350.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contract_types" WHERE "id"=1)
10:06:41.9360.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"='2')
10:06:42.0720.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=3
10:06:42.0570.2 msyii\db\Command::querySELECT "channel_id" FROM "global"."tbl_logins" WHERE (0=1) AND ("id" != 1001) AND (channel_id IS NOT NULL)
10:06:42.4950.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 641262, 'a:13:{s:2:"id";i:641262;s:9:"object_id";i:3311;s:11:"object_type";i:10;s:9:"target_id";i:4173;s:18:"target_object_type";i:1;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[4173]";s:9:"new_value";s:6:"[4173]";s:11:"description";s:143:"{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a","d4":["\u6d4b\u8bd5\u5de5\u5355\u4eba\u5de5\u6210\u672c\u95ee\u9898"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '221.216.117.119')
10:06:42.0740.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=3
10:06:42.4700.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('DELETE', 'app\models\SalesContracts', 4490, '', '', 1001, '221.216.117.119')
10:06:42.0890.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=4173
10:06:42.4930.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ClientAmChangeLogs', 199895, 'a:5:{s:2:"id";i:199895;s:9:"client_id";i:3311;s:9:"sales_rep";i:1001;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '221.216.117.119')
10:06:41.9220.2 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
10:06:42.4930.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Clients', 3311, 'a:0:{}', '', 1001, '221.216.117.119')
10:06:42.4740.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4173, 'a:0:{}', '', 1001, '221.216.117.119')
10:06:42.0910.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Comments', 220729, 'a:11:{s:2:"id";i:220729;s:9:"object_id";i:4173;s:11:"object_type";s:1:"1";s:6:"parent";N;s:11:"description";s:66:"刘人诚更新了一条商机状态商机成交变为明确需求";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:0:"";}', '', 1001, '221.216.117.119')
10:06:42.0890.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=2
10:06:42.0910.1 msyii\db\Command::querySELECT "channel_id" FROM "global"."tbl_logins" WHERE (0=1) AND ("id" != 1001) AND (channel_id IS NOT NULL)