ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68c4252f71b44: POST https://beta.jinchangxiao.com/v2/project/save-edit at 2025-09-12 09:50:39 pm by 39.157.26.122

Performance Profiling

Total processing time: 66 ms; Peak memory: 4.972 MB. Show Profiling Timeline

总计47条数据
TimeDurationCategoryInfo
  
21:50:39.50616.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=93) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
21:50:39.4692.7 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om'
21:50:39.4671.9 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
21:50:39.4901.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3954) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
21:50:39.4721.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
21:50:39.5231.2 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (93, 1005, 'now()', NULL) RETURNING "id"
21:50:39.4861.1 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_project_product_types" ("project_id", "product_type_id", "name", "budget", "pct", "profit") VALUES (3954, 3, '存储设备', '130000', 11.53, '14989')
21:50:39.4921.1 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', 3954, 'a:0:{}', '', 1000, '39.157.26.122')
21:50:39.4881.1 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "client_id"=93, "project_status"=2, "project_progress"=4, "budget"='130000', "profit_pct"='11.53', "updated_at"='now()', "contract_type"=1, "used_client"=NULL, "from_contact"=NULL WHERE "id"=3954
21:50:39.5291.1 msyii\db\Command::queryINSERT 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":"164","comment":"","salesForecast":"142","project_status":"2","projectProductTypes":{"3":{"budget":"130000","pct":"11.53"}},"used_client":"","project_progress":"4","contract_type":"1","projectArchitects":{"1023":"1.0"},"project_title":"\u7fa4\u6656\u6269\u5bb9","projectRemindReceivers":"","description":"","from_contact":"","id":"3954","bargain_date":"2025-10-01","client_id":"93"},"access_token":"gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om","device_type":"0","version_code":"266","token":"a391b22ab03d1eca28611612199f7e9b","posttime":"1757685039"}', '{"code":200,"data":"","status":1,"msg":[{"name":"success","success":"\u5546\u673a\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}]}', FALSE, '2025-09-12 21:50:39') RETURNING "id"
21:50:39.4961.0 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_project_architects" ("project_id", "engineer_id", "contribution", "created_by") VALUES (3954, 1023, '1', 1000)
21:50:39.4991.0 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (9, 164, 3954)
21:50:39.4840.9 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=3954
21:50:39.5030.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=3954
21:50:39.4750.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3954'
21:50:39.5270.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id"=3954)
21:50:39.5240.8 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', 180853, 'a:5:{s:2:"id";i:180853;s:9:"client_id";i:93;s:9:"sales_rep";i:1005;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1000, '39.157.26.122')
21:50:39.5020.7 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (13, 142, 3954)
21:50:39.4950.7 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_architects" WHERE "project_id"=3954
21:50:39.4980.7 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=3954) AND ("term_id"=9)
21:50:39.5250.7 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', 93, 'a:0:{}', '', 1000, '39.157.26.122')
21:50:39.4790.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (215, 164, 142, 184, 189, 349)) ORDER BY "sort"
21:50:39.5010.7 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=3954) AND ("term_id"=13)
21:50:39.4930.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='93'
21:50:39.4840.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=3954
21:50:39.4810.5 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='93')
21:50:39.4780.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=3954
21:50:39.4800.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE ("client_id"='93') AND ("project_title"='群晖扩容') AND ("id" != 3954))
21:50:39.4940.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_architects" WHERE "project_id"=3954
21:50:39.5050.4 msyii\db\Command::querySELECT 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"=93)
21:50:39.4860.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=3
21:50:39.4810.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contract_types" WHERE "id"='1')
21:50:39.5040.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='93'
21:50:39.4830.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
21:50:39.4940.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
21:50:39.5030.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=3954
21:50:39.4820.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_progresses" WHERE "id"='4')
21:50:39.5270.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3954
21:50:39.4970.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (215, 164, 142, 184, 189, 349)) ORDER BY "sort"
21:50:39.4830.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1005)
21:50:39.4820.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"='2')
21:50:39.4970.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=3954
21:50:39.4980.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=164
21:50:39.5010.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=142
21:50:39.5010.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='142'
21:50:39.4980.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='164'
21:50:39.5030.1 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=3954