68c3e15292166: POST https://beta.jinchangxiao.com/v2/project/save-edit at 2025-09-12 05:01:06 pm by 223.73.39.229
Database Queries
总计111条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 17:01:06.601 | 2.6 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om' |
| 17:01:06.605 | 1.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 17:01:06.608 | 0.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3959' |
| 17:01:06.610 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=3959 |
| 17:01:06.611 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (5, 226, 129, 136, 139, 142, 184, 189, 349)) ORDER BY "sort" |
| 17:01:06.612 | 0.4 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE ("client_id"='1661') AND ("project_title"='吉德科娃') AND ("id" != 3959)) |
| 17:01:06.613 | 0.3 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contract_types" WHERE "id"='1') |
| 17:01:06.614 | 0.5 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='1661') |
| 17:01:06.614 | 0.3 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_progresses" WHERE "id"='2') |
| 17:01:06.615 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"='3') |
| 17:01:06.615 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 17:01:06.615 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 17:01:06.616 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=3959 |
| 17:01:06.617 | 0.9 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=3959 |
| 17:01:06.618 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=7 |
| 17:01:06.618 | 1.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_project_product_types" ("project_id", "product_type_id", "name", "budget", "pct", "profit") VALUES (3959, 7, '软件', '788888', 99.98, '788730.2224') |
| 17:01:06.621 | 1.2 ms | UPDATE | UPDATE "a57be577deb434"."tbl_projects" SET "client_id"=1661, "project_status"=3, "project_progress"=2, "budget"='788888', "profit_pct"='99.98', "updated_at"='now()', "contract_type"=1, "used_client"=NULL, "from_contact"=NULL WHERE "id"=3959 |
| 17:01:06.622 | 2.0 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3959) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 17:01:06.625 | 2.3 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', 3959, 'a:0:{}', '', 1000, '223.73.39.229') |
| 17:01:06.627 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='1661' |
| 17:01:06.628 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 17:01:06.629 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_architects" WHERE "project_id"=3959 |
| 17:01:06.629 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5085 |
| 17:01:06.630 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1022 |
| 17:01:06.630 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1023 |
| 17:01:06.631 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5085 |
| 17:01:06.631 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5248 |
| 17:01:06.631 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1015 |
| 17:01:06.632 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1022 |
| 17:01:06.632 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1023 |
| 17:01:06.633 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 17:01:06.633 | 3.0 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, 'projectArchitects', 3959, 1, 1000, 'now()', '[["\u970d\u4e1c\u9633 10%","\u5f90\u7855 50%","\u5468\u5b50\u5065 40%"]]', '[["\u970d\u4e1c\u9633 10%","\u6587\u4f73\u9f99 0%","\u5434\u660a 0%","\u5f90\u7855 50%","\u5468\u5b50\u5065 40%"]]', '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u552e\u524d\u652f\u6301","d4":["\u970d\u4e1c\u9633 10%;\u6587\u4f73\u9f99 0%;\u5434\u660a 0%;\u5f90\u7855 50%;\u5468\u5b50\u5065 40%; <b>\u53d8\u4e3a<\/b> \u970d\u4e1c\u9633 10%;\u5f90\u7855 50%;\u5468\u5b50\u5065 40%;"]}') |
| 17:01:06.636 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='1661' |
| 17:01:06.637 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 17:01:06.637 | 1.0 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, 'projectArchitects', 3959, 1, 1000, 'now()', '[["\u970d\u4e1c\u9633 10%","\u5f90\u7855 50%","\u5468\u5b50\u5065 40%"]]', '[["\u970d\u4e1c\u9633 10%","\u6587\u4f73\u9f99 0%","\u5434\u660a 0%","\u5f90\u7855 50%","\u5468\u5b50\u5065 40%"]]', array[1001], '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u552e\u524d\u652f\u6301","d4":["\u970d\u4e1c\u9633 10%;\u6587\u4f73\u9f99 0%;\u5434\u660a 0%;\u5f90\u7855 50%;\u5468\u5b50\u5065 40%; <b>\u53d8\u4e3a<\/b> \u970d\u4e1c\u9633 10%;\u5f90\u7855 50%;\u5468\u5b50\u5065 40%;"]}') |
| 17:01:06.638 | 0.7 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_project_architects" WHERE "project_id"=3959 |
| 17:01:06.639 | 1.3 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_project_architects" ("project_id", "engineer_id", "contribution", "created_by") VALUES (3959, 5085, '0.1', 1000), (3959, 1022, '0.5', 1000), (3959, 1023, '0.4', 1000) |
| 17:01:06.641 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=3959 |
| 17:01:06.641 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (5, 226, 129, 136, 139, 142, 184, 189, 349)) ORDER BY "sort" |
| 17:01:06.641 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=129 |
| 17:01:06.642 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='129' |
| 17:01:06.642 | 0.7 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=3959) AND ("term_id"=9) |
| 17:01:06.643 | 2.7 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (9, 129, 3959) |
| 17:01:06.646 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=142 |
| 17:01:06.646 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='142' |
| 17:01:06.646 | 0.7 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=3959) AND ("term_id"=13) |
| 17:01:06.647 | 0.7 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (13, 142, 3959) |
| 17:01:06.648 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=3959 |
| 17:01:06.648 | 0.2 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=3959 |
| 17:01:06.649 | 0.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=3959 |
| 17:01:06.650 | 0.4 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=3959) |
| 17:01:06.650 | 1.1 ms | UPDATE | UPDATE "a57be577deb434"."tbl_sales_contracts" SET "amount"='788888', "contract_type"=1, "save_collection_at"='now()' WHERE "id"=4140 |
| 17:01:06.652 | 0.7 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\SalesContracts', 4140, 'a:1:{s:18:"save_collection_at";s:5:"now()";}', '', 1000, '223.73.39.229') |
| 17:01:06.653 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=1661 |
| 17:01:06.653 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3959 |
| 17:01:06.653 | 0.3 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_contract_default_remind_users" WHERE ("user_id"=1000) AND ("type"=1) |
| 17:01:06.654 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4140 |
| 17:01:06.654 | 0.2 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4140 |
| 17:01:06.655 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4140 |
| 17:01:06.655 | 0.2 ms | UPDATE | UPDATE "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4140 |
| 17:01:06.656 | 0.6 ms | SELECT | SELECT 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"=4140) AND ("t"."status" IN (2, 5, 1)) |
| 17:01:06.656 | 0.7 ms | SELECT | SELECT r.amount, t.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"=4140) AND ("t"."status" IN (2, 5, 1)) |
| 17:01:06.657 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3959 |
| 17:01:06.658 | 0.3 ms | SELECT | SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4140 |
| 17:01:06.659 | 1.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3959) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 17:01:06.660 | 0.9 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', 3959, 'a:0:{}', '', 1000, '223.73.39.229') |
| 17:01:06.661 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=1661 |
| 17:01:06.662 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4140 |
| 17:01:06.662 | 0.3 ms | SELECT | SELECT 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"=4140) AND ("t"."status" IN (2, 5)) |
| 17:01:06.662 | 0.4 ms | SELECT | SELECT 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"=4140) AND ("t"."status" IN (2, 5)) |
| 17:01:06.663 | 0.8 ms | SELECT | SELECT 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"=4140) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 17:01:06.664 | 0.3 ms | SELECT | SELECT 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"=4140) AND ("t"."status"=1)) |
| 17:01:06.664 | 0.4 ms | SELECT | SELECT 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"=4140) AND ("t"."status"=1)) |
| 17:01:06.665 | 0.4 ms | SELECT | SELECT 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"=4140) AND ("t"."status"=1)) |
| 17:01:06.665 | 0.7 ms | UPDATE | UPDATE "a57be577deb434"."tbl_sales_contracts" SET "erp_settle_amount"='0', "erp_un_settle_amount"='788888' WHERE "id"=4140 |
| 17:01:06.666 | 0.7 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\SalesContracts', 4140, 'a:0:{}', '', 1000, '223.73.39.229') |
| 17:01:06.667 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=1661 |
| 17:01:06.668 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3959 |
| 17:01:06.668 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3959 |
| 17:01:06.669 | 0.8 ms | UPDATE | UPDATE "a57be577deb434"."tbl_projects" SET "collected"='0' WHERE "id"=3959 |
| 17:01:06.670 | 1.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3959) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 17:01:06.671 | 0.7 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', 3959, 'a:0:{}', '', 1000, '223.73.39.229') |
| 17:01:06.672 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=1661 |
| 17:01:06.673 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4140 |
| 17:01:06.673 | 0.2 ms | UPDATE | UPDATE "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4140 |
| 17:01:06.673 | 0.3 ms | SELECT | SELECT 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"=4140) AND ("t"."status" IN (2, 5, 1)) |
| 17:01:06.674 | 0.4 ms | SELECT | SELECT r.amount, t.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"=4140) AND ("t"."status" IN (2, 5, 1)) |
| 17:01:06.674 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3959 |
| 17:01:06.675 | 0.2 ms | SELECT | SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4140 |
| 17:01:06.675 | 1.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3959) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 17:01:06.677 | 0.7 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', 3959, 'a:0:{}', '', 1000, '223.73.39.229') |
| 17:01:06.678 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=1661 |
| 17:01:06.678 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='1661' |
| 17:01:06.679 | 1.1 ms | UPDATE | UPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=1661 |
| 17:01:06.680 | 13.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=1661) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 17:01:06.694 | 1.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (1661, 1001, 'now()', NULL) RETURNING "id" |
| 17:01:06.696 | 0.7 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', 180845, 'a:5:{s:2:"id";i:180845;s:9:"client_id";i:1661;s:9:"sales_rep";i:1001;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1000, '223.73.39.229') |
| 17:01:06.696 | 0.7 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', 1661, 'a:0:{}', '', 1000, '223.73.39.229') |
| 17:01:06.697 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 17:01:06.698 | 0.8 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', 1661, 10, 3959, 1, 1000, '[3959]', '[3959]', '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a","d4":["\u5409\u5fb7\u79d1\u5a03"]}') RETURNING "id" |
| 17:01:06.699 | 0.7 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', 565239, 'a:13:{s:2:"id";i:565239;s:9:"object_id";s:4:"1661";s:11:"object_type";i:10;s:9:"target_id";i:3959;s:18:"target_object_type";i:1;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[3959]";s:9:"new_value";s:6:"[3959]";s:11:"description";s:107:"{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a","d4":["\u5409\u5fb7\u79d1\u5a03"]}";s:10:"created_by";i:1000;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1000, '223.73.39.229') |
| 17:01:06.699 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='1661' |
| 17:01:06.700 | 0.4 ms | SELECT | SELECT COUNT(*) FROM "a57be577deb434"."tbl_projects" WHERE ("project_status"=3) AND ("bargain_date" >= '2025-01-01 00:00:00') AND ("bargain_date" <= '2025-12-31 23:59:59') AND ("client_id"=1661) |
| 17:01:06.701 | 8.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=1661) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 17:01:06.710 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (1661, 1001, 'now()', NULL) RETURNING "id" |
| 17:01:06.711 | 0.7 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', 180846, 'a:5:{s:2:"id";i:180846;s:9:"client_id";i:1661;s:9:"sales_rep";i:1001;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1000, '223.73.39.229') |
| 17:01:06.711 | 0.7 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', 1661, 'a:0:{}', '', 1000, '223.73.39.229') |
| 17:01:06.713 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3959 |
| 17:01:06.713 | 0.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id"=3959) |
| 17:01:06.715 | 0.7 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', 1586, 'a:0:{}', '', 1000, '223.73.39.229') |
| 17:01:06.716 | 1.0 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, NULL, NULL, 'v2/project/save-edit', '{"Projects":{"purchaseType":"129","comment":"\u91d1\u5a1c\u5a1c","salesForecast":"142","projectArchitects":{"5085":"0.1","1022":"0.5","1023":"0.4"},"project_status":"3","used_client":"","project_progress":"2","contract_type":"1","projectProductTypes":{"7":{"pct":"99.98","budget":"788888"}},"project_title":"\u5409\u5fb7\u79d1\u5a03","projectRemindReceivers":"","description":"","salesContractPaymentCollectionRemindDates":"","from_contact":"","id":"3959","payment_collection_remind_ahead":"","bargain_date":"2025-09-11","client_id":"1661"},"access_token":"gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om","device_type":"0","version_code":"266","token":"abc93ed0ee98c8d968a0d9bb61d72473","posttime":"1757667667"}', '{"code":200,"data":"","status":1,"msg":[{"name":"success","success":"\u5546\u673a\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}]}', FALSE, '2025-09-12 17:01:06') RETURNING "id" |