ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a22999bcfd92: POST https://beta.jinchangxiao.com/vue/project/save-edit at 2026-06-05 05:40:43 pm by 221.216.117.119

Performance Profiling

Total processing time: 165 ms; Peak memory: 5.682 MB. Show Profiling Timeline

总计83条数据
TimeDurationCategoryInfo
  
17:40:43.91312.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_order_items" WHERE "project_id"=4024
17:40:44.0039.5 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":"4024","client_name":"\u5317\u4eac\u4e2d\u91d1\u4fdd\u9669\u7ecf\u7eaa\u6709\u9650\u516c\u53f8","client_id":"3415","project_status":"5","project_progress":"2","profit":"10000","profit_pct":"10","bargain_date":"2026-11-30","project_title":"\u6df1\u4fe1\u670d\u9632\u706b\u5899","from_contact_name":"","from_contact":"","salesForecast":"181","purchaseType":"128","opportunityFrom":"","contract_type":"1","comment":"2025\/10\/24\u636e\u5317\u4eac\u4e2d\u91d1\u4fdd\u9669\u7ecf\u7eaa\u6709\u9650\u516c\u53f8IT\u90e8\u7ecf\u7406\u620e\u6cfd\u9e9f\u4ecb\u7ecd\uff1a\u516c\u53f8\u4f7f\u7528\u8fea\u666e\u7684\u5b89\u5168\u4ea7\u54c1\uff0c\u540e\u671f\u60f3\u4f7f\u7528\u6df1\u4fe1\u670d\u4ea7\u54c1\uff0c\u516c\u53f8\u57282026\u5e74Q2 4\u6708\u521d\u4f1a\u91c7\u8d2d\u56fd\u4ea7\u5316\u7684\u8d1f\u8f7d\u5747\u8861\u4ea7\u54c1\uff0c\u4f1a\u9644\u5e26\u4e00\u4e9b\u9632\u706b\u5899\u4ea7\u54c1\uff0c\u5f53\u524d\u540c\u6b65\u505a\u5185\u90e8\u8bc4\u4f30\u548c\u65b0\u7f51\u5efa\u8bbe\u8bc4\u4f30\uff0c\u60f3\u770b\u4e0b\u6709\u54ea\u4e9b\u578b\u53f7\uff0c\u6bd4\u8f83\u5173\u6ce8\u6027\u80fd\u6307\u6807\uff0c\u770b\u8981\u7528\u591a\u5927\u6027\u80fd\u7684\uff0c\u9884\u7b97\u5b89\u5168\u90e8\u5206500-600\u4e07\uff0c\u62db\u6807\u5f62\u5f0f\uff0c\u662f\u5efa\u8bae\u4eba\uff0c\u540c\u610f\u540e\u671f\u9500\u552e\u8054\u7cfb\uff0c\u624b\u673a\u53f7:15801193167\u90ae\u7bb1\uff1aami2222@163.com\u3002","payment_collection_remind_ahead":"1 day","project_product_version_id":"","salesContractPaymentCollectionRemindReceivers":["1001"],"projectProductRels":"","projectContactPoints":"","projectContactPointRels":"","projectUsedClient":{"used_client":"","budget":"","profit":"","profit_pct":"","projectUsedClientPaymentCollectionRemindReceivers":"","projectUsedClientPaymentCollectionRemindDates":"","remind_ahead":"","projectUsedClientPayments":"","projectUsedClientInvoices":""},"salesContractPaymentCollectionRemindDates":"","projectProductTypes":{"5":{"budget":"100000","profit":"10000","pct":"10"}},"projectArchitects":"","projectRemindReceivers":""},"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 17:40:44', 151721216) RETURNING "id"
17:40:43.9477.7 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (9, 128, 4024)
17:40:43.8867.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_project_product_types" ("project_id", "product_type_id", "name", "budget", "pct", "profit") VALUES (4024, 5, '安全设备', '100000', 10, '10000')
17:40:43.8595.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='4024'
17:40:43.9585.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=4024
17:40:43.8995.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4024) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
17:40:43.9755.0 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, 'projectUsedClientRemindAhead', 4024, 1, 1001, 'now()', '[""]', '["\u4e0d\u63d0\u9192"]', array[1001], '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u7528\u6237\u6536\u6b3e\u63d0\u9192\u65f6\u95f4","d4":["\u4e0d\u63d0\u9192 <b>\u53d8\u4e3a<\/b> (\u672a\u8bbe\u7f6e)"]}')
17:40:43.9053.4 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', 4024, 'a:1:{s:6:"end_at";s:19:"2025-12-21 22:35:11";}', '', 1001, '221.216.117.119')
17:40:43.8753.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3415')
17:40:43.8722.8 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE ("client_id"='3415') AND ("project_title"='深信服防火墙') AND ("id" != 4024))
17:40:43.9702.6 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, 'projectUsedClientRemindAhead', 4024, 1, 1001, 'now()', '[""]', '["\u4e0d\u63d0\u9192"]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u7528\u6237\u6536\u6b3e\u63d0\u9192\u65f6\u95f4","d4":["\u4e0d\u63d0\u9192 <b>\u53d8\u4e3a<\/b> (\u672a\u8bbe\u7f6e)"]}')
17:40:43.9262.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4024) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
17:40:43.9872.2 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (3415, NULL, 'now()', NULL) RETURNING "id"
17:40:43.8941.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4024 ORDER BY "id"
17:40:43.8691.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (1, 128, 181, 184, 189, 349, 324)) ORDER BY "sort"
17:40:43.9291.4 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', 4024, 'a:1:{s:6:"end_at";s:19:"2025-12-21 22:35:11";}', '', 1001, '221.216.117.119')
17:40:43.9381.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4024) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
17:40:43.9361.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "client_id"=3415, "project_status"=5, "project_progress"=2, "budget"='100000', "profit_pct"='10', "updated_at"='now()', "contract_type"=1, "end_at"='now()', "from_contact"=NULL WHERE "id"=4024
17:40:44.0001.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id"=4024)
17:40:43.9341.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE "project_id"=4024
17:40:43.8791.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"='5')
17:40:43.9841.0 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=3415
17:40:43.9091.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3415
17:40:43.8540.8 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:40:43.8830.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=4024
17:40:43.9330.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id"=4024
17:40:43.8690.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=4024
17:40:43.9420.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_architects" WHERE "project_id"=4024
17:40:43.9690.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:40:43.9110.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4024 ORDER BY "id"
17:40:43.9310.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3415
17:40:43.8840.5 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=4024
17:40:43.8960.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4024 ORDER BY "id"
17:40:43.9410.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3415'
17:40:43.8560.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:40:43.9100.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4024
17:40:43.9850.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=3415) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
17:40:43.9930.5 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"=3415)
17:40:43.9570.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=4024
17:40:43.9630.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_clients" WHERE "project_id"=4024
17:40:43.8850.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=5
17:40:43.9730.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3415'
17:40:43.9830.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3415'
17:40:43.8820.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:40:43.9410.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:40:43.9740.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:40:43.9920.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3415'
17:40:43.9320.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4024
17:40:43.9810.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" WHERE "project_used_client_id"=223
17:40:43.8750.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contract_types" WHERE "id"='1')
17:40:44.0000.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4024
17:40:43.9910.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:40:43.8780.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_progresses" WHERE "id"='2')
17:40:43.9400.4 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', 4024, 'a:1:{s:6:"end_at";s:19:"1970-01-01 08:00:00";}', '', 1001, '221.216.117.119')
17:40:43.9910.4 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', 3415, 10, 4024, 1, 1001, '[4024]', '[4024]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a","d4":["\u6df1\u4fe1\u670d\u9632\u706b\u5899"]}') RETURNING "id"
17:40:43.8960.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4024
17:40:43.9950.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_client_am_change_logs" SET "end_at"='now()' WHERE "id"=199934
17:40:43.9810.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_payments" WHERE "project_used_client_id"=223
17:40:43.9800.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_receivers" WHERE "project_used_client_id"=223
17:40:43.9430.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (1, 128, 181, 184, 189, 349, 324)) ORDER BY "sort"
17:40:43.9820.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_invoices" WHERE "project_used_client_id"=223
17:40:43.8810.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1011)
17:40:43.8800.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1005)
17:40:43.9870.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\ClientAmChangeLogs', 199933, 'a:1:{s:6:"end_at";s:19:"1970-01-01 08:00:00";}', '', 1001, '221.216.117.119')
17:40:43.9560.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (13, 181, 4024)
17:40:43.9960.3 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (3415, NULL, 'now()', NULL) RETURNING "id"
17:40:43.9550.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=181
17:40:43.9900.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', 199934, 'a:5:{s:2:"id";i:199934;s:9:"client_id";i:3415;s:9:"sales_rep";N;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '221.216.117.119')
17:40:43.9900.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', 3415, 'a:0:{}', '', 1001, '221.216.117.119')
17:40:43.8540.3 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:40:43.9940.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=3415) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
17:40:43.9430.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=4024
17:40:43.9440.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=128
17:40:43.9860.2 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_client_am_change_logs" SET "end_at"='now()' WHERE "id"=199933
17:40:43.9960.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\ClientAmChangeLogs', 199934, 'a:1:{s:6:"end_at";s:19:"1970-01-01 08:00:00";}', '', 1001, '221.216.117.119')
17:40:43.9970.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', 3415, 'a:0:{}', '', 1001, '221.216.117.119')
17:40:43.9960.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', 199935, 'a:5:{s:2:"id";i:199935;s:9:"client_id";i:3415;s:9:"sales_rep";N;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '221.216.117.119')
17:40:43.9920.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', 641363, 'a:13:{s:2:"id";i:641363;s:9:"object_id";s:4:"3415";s:11:"object_type";i:10;s:9:"target_id";i:4024;s:18:"target_object_type";i:1;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[4024]";s:9:"new_value";s:6:"[4024]";s:11:"description";s:119:"{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a","d4":["\u6df1\u4fe1\u670d\u9632\u706b\u5899"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '221.216.117.119')
17:40:43.9440.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='128'
17:40:43.9560.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='181'
17:40:43.9450.2 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=4024) AND ("term_id"=9)
17:40:43.9560.2 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=4024) AND ("term_id"=13)