68707100961ed: POST https://beta.jinchangxiao.com/v2/project/save-edit at 2025-07-11 10:03:44 am by 223.104.40.121
Database Queries
总计42条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 10:03:44.618 | 2.7 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH' |
| 10:03:44.621 | 1.1 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 10:03:44.624 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3817' |
| 10:03:44.626 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=3817 |
| 10:03:44.627 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (5, 226, 129, 160, 142, 184, 189, 349)) ORDER BY "sort" |
| 10:03:44.628 | 0.4 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE ("client_id"='2815') AND ("project_title"='离开就好') AND ("id" != 3817)) |
| 10:03:44.629 | 0.3 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contract_types" WHERE "id"='1') |
| 10:03:44.629 | 0.5 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2815') |
| 10:03:44.630 | 0.3 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_progresses" WHERE "id"='6') |
| 10:03:44.630 | 0.3 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"='1') |
| 10:03:44.631 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004) |
| 10:03:44.631 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=3817 |
| 10:03:44.632 | 0.3 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=3817 |
| 10:03:44.632 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 10:03:44.633 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 10:03:44.634 | 1.1 ms | UPDATE | UPDATE "a57be577deb434"."tbl_projects" SET "client_id"=2815, "project_status"=1, "project_progress"=6, "budget"='0', "profit_pct"='0', "updated_at"='now()', "contract_type"=1, "used_client"=NULL, "from_contact"=NULL WHERE "id"=3817 |
| 10:03:44.636 | 1.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3817) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 10:03:44.638 | 1.1 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', 3817, 'a:0:{}', '', 1000, '223.104.40.121') |
| 10:03:44.639 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2815' |
| 10:03:44.640 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 10:03:44.641 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=3817 |
| 10:03:44.641 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (5, 226, 129, 160, 142, 184, 189, 349)) ORDER BY "sort" |
| 10:03:44.641 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=129 |
| 10:03:44.642 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='129' |
| 10:03:44.642 | 0.7 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=3817) AND ("term_id"=9) |
| 10:03:44.643 | 1.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (9, 129, 3817) |
| 10:03:44.644 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=142 |
| 10:03:44.644 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='142' |
| 10:03:44.645 | 0.7 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=3817) AND ("term_id"=13) |
| 10:03:44.645 | 0.7 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (13, 142, 3817) |
| 10:03:44.646 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=3817 |
| 10:03:44.647 | 0.7 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=3817 |
| 10:03:44.648 | 1.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_project_remind_receivers" ("project_id", "user_id") VALUES (3817, 1017) RETURNING "id" |
| 10:03:44.649 | 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\ProjectRemindReceivers', 1621, 'a:3:{s:2:"id";i:1621;s:10:"project_id";i:3817;s:7:"user_id";s:4:"1017";}', '', 1000, '223.104.40.121') |
| 10:03:44.650 | 0.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=3817 |
| 10:03:44.651 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2815' |
| 10:03:44.651 | 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"=2815) |
| 10:03:44.652 | 11.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=2815) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 10:03:44.664 | 1.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (2815, 1004, 'now()', NULL) RETURNING "id" |
| 10:03:44.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 ('INSERT', 'app\models\ClientAmChangeLogs', 165239, 'a:5:{s:2:"id";i:165239;s:9:"client_id";i:2815;s:9:"sales_rep";i:1004;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1000, '223.104.40.121') |
| 10:03:44.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\Clients', 2815, 'a:0:{}', '', 1000, '223.104.40.121') |
| 10:03:44.668 | 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, 2, 1141, 'v2/project/save-edit', '{"Projects":{"bargain_date":"2025-09-11","client_id":"2815","comment":"","contract_type":"1","from_contact":"","id":"3817","projectProductTypes":"","projectRemindReceivers":["1017"],"project_progress":"6","project_status":"1","project_title":"\u79bb\u5f00\u5c31\u597d","purchaseType":"129","salesForecast":"142","used_client":""},"access_token":"oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH","device_type":"2","posttime":"1752199424","token":"a386c0a40cdf1fccb239f6051671cadd","version_code":"1141"}', '{"code":200,"data":"","status":1,"msg":[{"name":"success","success":"\u5546\u673a\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}]}', FALSE, '2025-07-11 10:03:44') RETURNING "id" |