ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68c42fddd0fa5: POST https://beta.jinchangxiao.com/v2/project/save-edit at 2025-09-12 10:36:13 pm by 39.157.26.122

Performance Profiling

Total processing time: 109 ms; Peak memory: 5.179 MB. Show Profiling Timeline

总计64条数据
TimeDurationCategoryInfo
  
22:36:13.91318.0 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
22:36:13.94015.4 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
22:36:13.8592.7 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om'
22:36:13.8892.0 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
22:36:13.8571.9 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
22:36:13.8871.8 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
22:36:13.8921.6 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')
22:36:13.8841.4 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')
22:36:13.8751.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE ("client_id"='93') AND ("project_title"='群晖扩容') AND ("id" != 3954))
22:36:13.8631.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
22:36:13.9341.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', 93, 'a:0:{}', '', 1000, '39.157.26.122')
22:36:13.9621.2 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","projectArchitects":{"5085":"0.3","1023":"0.7"},"project_status":"2","projectProductTypes":{"3":{"budget":"130000","pct":"11.53"}},"used_client":"","project_progress":"4","contract_type":"1","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":"edc33acf3b2683b04c54542b17148a14","posttime":"1757687773"}', '{"code":200,"data":"","status":1,"msg":[{"name":"success","success":"\u5546\u673a\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}]}', FALSE, '2025-09-12 22:36:13') RETURNING "id"
22:36:13.9321.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"
22:36:13.9021.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_project_architects" ("project_id", "engineer_id", "contribution", "created_by") VALUES (3954, 5085, '0.3', 1000), (3954, 1023, '0.7', 1000)
22:36:13.9601.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id"=3954)
22:36:13.9551.1 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"
22:36:13.9121.1 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=93
22:36:13.8821.1 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=3954
22:36:13.8701.1 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"
22:36:13.8981.1 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, 'projectArchitects', 3954, 1, 1000, 'now()', '[["\u970d\u4e1c\u9633 30%","\u5468\u5b50\u5065 70%"]]', '[["\u5468\u5b50\u5065 100%"]]', '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u552e\u524d\u652f\u6301","d4":["\u5468\u5b50\u5065 100%; <b>\u53d8\u4e3a<\/b> \u970d\u4e1c\u9633 30%;\u5468\u5b50\u5065 70%;"]}')
22:36:13.9061.0 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (9, 164, 3954)
22:36:13.9001.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, 'projectArchitects', 3954, 1, 1000, 'now()', '[["\u970d\u4e1c\u9633 30%","\u5468\u5b50\u5065 70%"]]', '[["\u5468\u5b50\u5065 100%"]]', array[1005], '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u552e\u524d\u652f\u6301","d4":["\u5468\u5b50\u5065 100%; <b>\u53d8\u4e3a<\/b> \u970d\u4e1c\u9633 30%;\u5468\u5b50\u5065 70%;"]}')
22:36:13.8660.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3954'
22:36:13.9100.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=3954
22:36:13.9050.8 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=3954) AND ("term_id"=9)
22:36:13.9330.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', 180854, 'a:5:{s:2:"id";i:180854;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')
22:36:13.8810.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=3954
22:36:13.9570.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', 180855, 'a:5:{s:2:"id";i:180855;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')
22:36:13.9370.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\ObjectChangeLogs', 565258, 'a:13:{s:2:"id";i:565258;s:9:"object_id";s:2:"93";s:11:"object_type";i:10;s:9:"target_id";i:3954;s:18:"target_object_type";i:1;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[3954]";s:9:"new_value";s:6:"[3954]";s:11:"description";s:107:"{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a","d4":["\u7fa4\u6656\u6269\u5bb9"]}";s:10:"created_by";i:1000;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1000, '39.157.26.122')
22:36:13.9360.8 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', 93, 10, 3954, 1, 1000, '[3954]', '[3954]', '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a","d4":["\u7fa4\u6656\u6269\u5bb9"]}') RETURNING "id"
22:36:13.9080.8 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (13, 142, 3954)
22:36:13.9010.7 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_architects" WHERE "project_id"=3954
22:36:13.9580.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')
22:36:13.8690.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=3954
22:36:13.9070.7 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=3954) AND ("term_id"=13)
22:36:13.8770.6 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='93')
22:36:13.8940.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='93'
22:36:13.8770.5 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contract_types" WHERE "id"='1')
22:36:13.8800.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
22:36:13.8830.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=3
22:36:13.8780.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_progresses" WHERE "id"='4')
22:36:13.8950.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_architects" WHERE "project_id"=3954
22:36:13.9380.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)
22:36:13.8790.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1005)
22:36:13.8790.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"='2')
22:36:13.9380.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='93'
22:36:13.8990.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='93'
22:36:13.9110.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='93'
22:36:13.8960.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5085
22:36:13.8950.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
22:36:13.9350.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
22:36:13.8970.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
22:36:13.9090.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=3954
22:36:13.9590.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3954
22:36:13.8990.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
22:36:13.8960.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1023
22:36:13.8970.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1023
22:36:13.9040.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"
22:36:13.9030.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=3954
22:36:13.9040.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=164
22:36:13.9070.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='142'
22:36:13.9070.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=142
22:36:13.9040.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='164'
22:36:13.9090.1 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=3954