68999642c2688: POST https://beta.jinchangxiao.com/v2/project/save-edit at 2025-08-11 03:05:38 pm by 39.107.117.60
Database Queries
总计86条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 15:05:38.799 | 2.7 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='lFICiryH6q1PKzl6ykU2iPsev0bYyy6d' |
| 15:05:38.803 | 1.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 15:05:38.806 | 0.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3935' |
| 15:05:38.808 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=3935 |
| 15:05:38.809 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (2, 165, 181, 184, 189, 349)) ORDER BY "sort" |
| 15:05:38.811 | 0.4 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE ("client_id"='982') AND ("project_title"='快快快') AND ("id" != 3935)) |
| 15:05:38.811 | 0.3 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contract_types" WHERE "id"='1') |
| 15:05:38.812 | 0.5 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='982') |
| 15:05:38.812 | 0.3 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_progresses" WHERE "id"='9') |
| 15:05:38.813 | 0.3 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"='3') |
| 15:05:38.813 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 15:05:38.814 | 0.3 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contacts" WHERE "id"='4640') |
| 15:05:38.814 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=3935 |
| 15:05:38.815 | 0.9 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=3935 |
| 15:05:38.816 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=4 |
| 15:05:38.817 | 1.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_project_product_types" ("project_id", "product_type_id", "name", "budget", "pct", "profit") VALUES (3935, 4, '网络设备 ', '35558', 11, '3911.38') |
| 15:05:38.818 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 15:05:38.818 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 15:05:38.820 | 1.0 ms | UPDATE | UPDATE "a57be577deb434"."tbl_projects" SET "client_id"=982, "project_status"=3, "project_progress"=9, "budget"='35558', "profit_pct"='11', "updated_at"='now()', "contract_type"=1, "used_client"=NULL, "from_contact"=4640 WHERE "id"=3935 |
| 15:05:38.821 | 1.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3935) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 15:05:38.823 | 1.0 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', 3935, 'a:0:{}', '', 1001, '39.107.117.60') |
| 15:05:38.824 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='982' |
| 15:05:38.825 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 15:05:38.826 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_architects" WHERE "project_id"=3935 |
| 15:05:38.827 | 0.7 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_project_architects" WHERE "project_id"=3935 |
| 15:05:38.827 | 1.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_project_architects" ("project_id", "engineer_id", "contribution", "created_by") VALUES (3935, 1017, '0.6', 1001), (3935, 5085, '0.4', 1001) |
| 15:05:38.829 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=3935 |
| 15:05:38.829 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (2, 165, 181, 184, 189, 349)) ORDER BY "sort" |
| 15:05:38.830 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=165 |
| 15:05:38.830 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='165' |
| 15:05:38.830 | 0.7 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=3935) AND ("term_id"=9) |
| 15:05:38.831 | 1.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (9, 165, 3935) |
| 15:05:38.832 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=181 |
| 15:05:38.833 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='181' |
| 15:05:38.833 | 0.7 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=3935) AND ("term_id"=13) |
| 15:05:38.834 | 0.7 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (13, 181, 3935) |
| 15:05:38.835 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=3935 |
| 15:05:38.835 | 0.8 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=3935 |
| 15:05:38.836 | 1.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_project_remind_receivers" ("project_id", "user_id") VALUES (3935, 1001) RETURNING "id" |
| 15:05:38.837 | 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\ProjectRemindReceivers', 1701, 'a:3:{s:2:"id";i:1701;s:10:"project_id";i:3935;s:7:"user_id";s:4:"1001";}', '', 1001, '39.107.117.60') |
| 15:05:38.838 | 6.1 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=3935 |
| 15:05:38.845 | 0.4 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=3935) |
| 15:05:38.845 | 1.0 ms | UPDATE | UPDATE "a57be577deb434"."tbl_sales_contracts" SET "amount"='35558', "contract_type"=1, "save_collection_at"='now()' WHERE "id"=4082 |
| 15:05:38.846 | 0.8 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', 4082, 'a:1:{s:18:"save_collection_at";s:5:"now()";}', '', 1001, '39.107.117.60') |
| 15:05:38.847 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982 |
| 15:05:38.848 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3935 |
| 15:05:38.848 | 0.3 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_contract_default_remind_users" WHERE ("user_id"=1001) AND ("type"=1) |
| 15:05:38.849 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4082 |
| 15:05:38.849 | 0.7 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4082 |
| 15:05:38.850 | 0.3 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4082) |
| 15:05:38.851 | 0.9 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" ("contract_id", "remind_date", "amount", "pct", "reminded") VALUES (4082, '2025-08-11', '35558', 1, FALSE) RETURNING "id" |
| 15:05:38.852 | 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\SalesContractPaymentCollectionRemindDates', 2551, 'a:9:{s:2:"id";i:2551;s:11:"contract_id";i:4082;s:11:"remind_date";s:10:"2025-08-11";s:8:"reminded";b:0;s:6:"amount";i:35558;s:11:"paid_amount";N;s:12:"overdue_days";N;s:6:"status";N;s:3:"pct";d:1;}', '', 1001, '39.107.117.60') |
| 15:05:38.852 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4082 |
| 15:05:38.853 | 0.7 ms | UPDATE | UPDATE "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4082 |
| 15:05:38.854 | 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"=4082) AND ("t"."status" IN (2, 5, 1)) |
| 15:05:38.855 | 1.3 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"=4082) AND ("t"."status" IN (2, 5, 1)) |
| 15:05:38.856 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3935 |
| 15:05:38.856 | 0.3 ms | SELECT | SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4082 |
| 15:05:38.858 | 1.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3935) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 15:05:38.859 | 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', 3935, 'a:0:{}', '', 1001, '39.107.117.60') |
| 15:05:38.860 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982 |
| 15:05:38.860 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4082 |
| 15:05:38.861 | 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"=4082) AND ("t"."status" IN (2, 5, 1)) |
| 15:05:38.861 | 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"=4082) AND ("t"."status" IN (2, 5, 1)) |
| 15:05:38.862 | 0.7 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"=4082) AND ("t"."status" IN (2, 5, 1)) |
| 15:05:38.863 | 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"=4082) AND ("t"."status"=1)) |
| 15:05:38.863 | 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"=4082) AND ("t"."status"=1)) |
| 15:05:38.864 | 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"=4082) AND ("t"."status"=1)) |
| 15:05:38.864 | 0.8 ms | UPDATE | UPDATE "a57be577deb434"."tbl_sales_contracts" SET "erp_settle_amount"='0', "erp_un_settle_amount"='35558' WHERE "id"=4082 |
| 15:05:38.865 | 0.8 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', 4082, 'a:0:{}', '', 1001, '39.107.117.60') |
| 15:05:38.866 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982 |
| 15:05:38.866 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3935 |
| 15:05:38.867 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3935 |
| 15:05:38.868 | 0.8 ms | UPDATE | UPDATE "a57be577deb434"."tbl_projects" SET "collected"='0' WHERE "id"=3935 |
| 15:05:38.869 | 1.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3935) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 15:05:38.870 | 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', 3935, 'a:0:{}', '', 1001, '39.107.117.60') |
| 15:05:38.871 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982 |
| 15:05:38.871 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='982' |
| 15:05:38.872 | 0.3 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"=982) |
| 15:05:38.873 | 16.1 ms | SELECT | SELECT * 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 |
| 15:05:38.890 | 1.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (982, 1001, 'now()', NULL) RETURNING "id" |
| 15:05:38.891 | 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', 177452, 'a:5:{s:2:"id";i:177452;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, '39.107.117.60') |
| 15:05:38.892 | 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', 982, 'a:0:{}', '', 1001, '39.107.117.60') |
| 15:05:38.894 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3935 |
| 15:05:38.894 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id"=3935) |
| 15:05:38.895 | 1.1 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', 1001, NULL, NULL, 'v2/project/save-edit', '{"Projects":{"payment_collection_remind_ahead":"","bargain_date":"2025-08-11","client_id":"982","comment":"\u4eac\u6d25\u5180","contract_type":"1","from_contact":"4640","id":"3935","projectArchitects":{"1017":"0.6","5085":"0.4"},"projectProductTypes":{"4":{"budget":"35558","pct":"11"}},"projectRemindReceivers":["1001"],"project_progress":"9","project_status":"3","project_title":"\u5feb\u5feb\u5feb","purchaseType":"165","salesContractPaymentCollectionRemindDates":{"2025-08-11":"35558"},"salesForecast":"181","used_client":""},"access_token":"lFICiryH6q1PKzl6ykU2iPsev0bYyy6d","device_type":"2","posttime":"1754895938","version_code":"1148","token":"4b6ce100049e4e9584d900596e4e8f2b"}', '{"code":200,"data":"","status":1,"msg":[{"name":"success","success":"\u5546\u673a\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}]}', FALSE, '2025-08-11 15:05:38') RETURNING "id" |