我们有一个新增接口每次调用的速度都比较慢,要将近5秒多。
并没有其他复杂逻辑,直接调用的生成代码的save接口,看日志数据库执行的时间也并不长。
Entity里面有几个数据转换的注解,是因为直接影响了速度吗?
/** * 培训的id */ @ApiModelProperty(value = "培训的id") private Long planId; /** * 签到名字 */ @ApiModelProperty(value = "签到名字") private String name; /** * 签到开始时间 */ @JsonFormat( pattern = "yyyy-MM-dd HH:mm:ss" ) @ApiModelProperty(value = "签到开始时间") private LocalDateTime startTime; /** * 签到结束时间 */ @JsonFormat( pattern = "yyyy-MM-dd HH:mm:ss" ) @ApiModelProperty(value = "签到结束时间") private LocalDateTime endTime; /** * 是否校验地理位置信息1是0否 */ @JsonSerialize(using = ToStringSerializer.class) private Integer isCheckGeolocation; /** * 地址名 */ private String addressName; /** * 经度 */ private String longitude; /** * 纬度 */ private String latitude; /** * 范围信息 */ private String geolocationRange;
接口请求日志
================ Request Start ================ ===> POST: /plansign/save ====Body===== {"id":null,"createUser":null,"createDept":null,"createTime":null,"updateUser":null,"updateTime":null,"status":null,"isDeleted":null,"tenantId":null,"planId":1465167353176719362,"name":null,"startTime":null,"endTime":null,"isCheckGeolocation":null,"addressName":null,"longitude":null,"latitude":null,"geolocationRange":null} ===Headers=== Origin: http://192.168.99.182:1888 ===Headers=== Cookie: JIDENTITY=1e82e23e-efcb-40c2-a734-6118ded6dd39; Hm_lvt_a95f4d7c757c7240eb70bb597b827cd7=1633947789; 122_vq=197; sensorsdata2015jssdkcross=%7B%22distinct_id%22%3A%2217d45b05974863-0d89c4511b348-b7a1b38-2073600-17d45b059756fa%22%2C%22first_id%22%3A%22%22%2C%22props%22%3A%7B%22%24latest_traffic_source_type%22%3A%22url%E7%9A%84domain%E8%A7%A3%E6%9E%90%E5%A4%B1%E8%B4%A5%22%2C%22%24latest_search_keyword%22%3A%22url%E7%9A%84domain%E8%A7%A3%E6%9E%90%E5%A4%B1%E8%B4%A5%22%2C%22%24latest_referrer%22%3A%22url%E7%9A%84domain%E8%A7%A3%E6%9E%90%E5%A4%B1%E8%B4%A5%22%7D%2C%22%24device_id%22%3A%2217d45b05974863-0d89c4511b348-b7a1b38-2073600-17d45b059756fa%22%7D; Hm_lvt_74b340479d1126865f1756ac4a438494=1637551723,1638163059,1638234638; bladex-ui-access-token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ0ZW5hbnRfaWQiOiI5NTYxNzYiLCJpY29uQ29sb3IyIjoiI0ZGQUQ0OCIsInVzZXJfbmFtZSI6ImFkbWluIiwiaWRDYXJkIjoiIiwicmVhbF9uYW1lIjoiYWRtaW4iLCJjbGllbnRfaWQiOiJsaWJyYS11aSIsImljb25Db2xvcjEiOiIjM2Y2MWZmIiwicm9sZV9pZCI6IjE0NjUxNjE5Mzg1NzE0MDczNjEiLCJzY29wZSI6WyJhbGwiXSwicG9zdE5hbWUiOiLpppbluK3miafooYzlrpgiLCJvYXV0aF9pZCI6IiIsImV4cCI6MTYzODU3NDc4NCwianRpIjoiMzQ2MjQwNjItMzAwOS00YTc0LTgxZjItZTViZmY0YjhkZDIxIiwic2V4IjoxLCJhdmF0YXIiOiIiLCJhdXRob3JpdGllcyI6WyJhZG1pbiJdLCJjaGVja0ZsYWciOjAsInJvbGVfbmFtZSI6ImFkbWluIiwibGljZW5zZSI6InBvd2VyZWQgYnkgbGlicmEiLCJwb3N0X2lkIjoiMTQ2NTE2MTk0MDk3NDc0MzU1NCIsImN1c3RvbVRoZW1lIjoiIzNmNjFmZiIsInVzZXJfaWQiOiIxNDY1MTYxOTQ4OTc0OTExNDg5IiwicGhvbmUiOiIiLCJuaWNrX25hbWUiOiJ1c2VySE93SjVwZGoiLCJkZXRhaWwiOnsidHlwZSI6IndlYiIsInVzZXJEZXRhaWxJZCI6IjE0NjUxNjE5NDg5NDk3NDU2NjUifSwiZGVwdF9pZCI6IjE0NjUxNjE5NDA5NjYzNTQ5NDUiLCJhY2NvdW50IjoiYWRtaW4ifQ.r3eoqwlc_AxBZEmSD0NeiyukfycYl2JfQo28_NB7T08; bladex-ui-refresh-token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ0ZW5hbnRfaWQiOiI5NTYxNzYiLCJpY29uQ29sb3IyIjoiI0ZGQUQ0OCIsInVzZXJfbmFtZSI6ImFkbWluIiwiaWRDYXJkIjoiIiwicmVhbF9uYW1lIjoiYWRtaW4iLCJjbGllbnRfaWQiOiJsaWJyYS11aSIsImljb25Db2xvcjEiOiIjM2Y2MWZmIiwicm9sZV9pZCI6IjE0NjUxNjE5Mzg1NzE0MDczNjEiLCJzY29wZSI6WyJhbGwiXSwicG9zdE5hbWUiOiLpppbluK3miafooYzlrpgiLCJhdGkiOiIzNDYyNDA2Mi0zMDA5LTRhNzQtODFmMi1lNWJmZjRiOGRkMjEiLCJvYXV0aF9pZCI6IiIsImV4cCI6MTYzOTA5NzE3NywianRpIjoiNGE1M2IzZjUtMTBlNC00NzRmLTkzZGUtMzY5MzkyNWVjNzBhIiwic2V4IjoxLCJhdmF0YXIiOiIiLCJhdXRob3JpdGllcyI6WyJhZG1pbiJdLCJjaGVja0ZsYWciOjAsInJvbGVfbmFtZSI6ImFkbWluIiwibGljZW5zZSI6InBvd2VyZWQgYnkgbGlicmEiLCJwb3N0X2lkIjoiMTQ2NTE2MTk0MDk3NDc0MzU1NCIsImN1c3RvbVRoZW1lIjoiIzNmNjFmZiIsInVzZXJfaWQiOiIxNDY1MTYxOTQ4OTc0OTExNDg5IiwicGhvbmUiOiIiLCJuaWNrX25hbWUiOiJ1c2VySE93SjVwZGoiLCJkZXRhaWwiOnsidHlwZSI6IndlYiIsInVzZXJEZXRhaWxJZCI6IjE0NjUxNjE5NDg5NDk3NDU2NjUifSwiZGVwdF9pZCI6IjE0NjUxNjE5NDA5NjYzNTQ5NDUiLCJhY2NvdW50IjoiYWRtaW4ifQ.HYh8Vxgi6KsNY6bi3vA2Db9ucw8MnKQcBZMegaPJjCI ===Headers=== X-Forwarded-Prefix: /bladex-plan ===Headers=== Accept: application/json, text/plain, */* ===Headers=== Referer: http://192.168.99.182:1888/ ===Headers=== X-Forwarded-Host: 192.168.99.152 ===Headers=== User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.71 Safari/537.36 ===Headers=== X-Forwarded-Proto: http ===Headers=== Accept-Encoding: gzip ===Headers=== X-Forwarded-Port: 80 ===Headers=== Authorization: Basic bGlicmEtdWk6bGlicmEtdWlfc2VjcmV0 ===Headers=== host: 192.168.99.152:8113 ===Headers=== Forwarded: proto=http;host=192.168.99.152;for="192.168.99.107:55776" ===Headers=== X-Forwarded-For: 192.168.99.107 ===Headers=== bladex-Auth: bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ0ZW5hbnRfaWQiOiI5NTYxNzYiLCJpY29uQ29sb3IyIjoiI0ZGQUQ0OCIsInVzZXJfbmFtZSI6ImFkbWluIiwiaWRDYXJkIjoiIiwicmVhbF9uYW1lIjoiYWRtaW4iLCJjbGllbnRfaWQiOiJsaWJyYS11aSIsImljb25Db2xvcjEiOiIjM2Y2MWZmIiwicm9sZV9pZCI6IjE0NjUxNjE5Mzg1NzE0MDczNjEiLCJzY29wZSI6WyJhbGwiXSwicG9zdE5hbWUiOiLpppbluK3miafooYzlrpgiLCJvYXV0aF9pZCI6IiIsImV4cCI6MTYzODU3NDc4NCwianRpIjoiMzQ2MjQwNjItMzAwOS00YTc0LTgxZjItZTViZmY0YjhkZDIxIiwic2V4IjoxLCJhdmF0YXIiOiIiLCJhdXRob3JpdGllcyI6WyJhZG1pbiJdLCJjaGVja0ZsYWciOjAsInJvbGVfbmFtZSI6ImFkbWluIiwibGljZW5zZSI6InBvd2VyZWQgYnkgbGlicmEiLCJwb3N0X2lkIjoiMTQ2NTE2MTk0MDk3NDc0MzU1NCIsImN1c3RvbVRoZW1lIjoiIzNmNjFmZiIsInVzZXJfaWQiOiIxNDY1MTYxOTQ4OTc0OTExNDg5IiwicGhvbmUiOiIiLCJuaWNrX25hbWUiOiJ1c2VySE93SjVwZGoiLCJkZXRhaWwiOnsidHlwZSI6IndlYiIsInVzZXJEZXRhaWxJZCI6IjE0NjUxNjE5NDg5NDk3NDU2NjUifSwiZGVwdF9pZCI6IjE0NjUxNjE5NDA5NjYzNTQ5NDUiLCJhY2NvdW50IjoiYWRtaW4ifQ.r3eoqwlc_AxBZEmSD0NeiyukfycYl2JfQo28_NB7T08 ===Headers=== Accept-Language: zh-CN,zh;q=0.9 ===Headers=== Content-Length: 32 ===Headers=== Content-Type: application/json;charset=UTF-8 ================ Request End ================ [XNIO-1 task-29] INFO org.springblade.bladex.core.mp.plugins.SqlLogInterceptor - ============== Sql Start ============== Execute SQL : insert into plan_sign (id, plan_id, create_user, create_dept, create_time , update_user, update_time, status, is_deleted, tenant_id) values (1466602446770946049, 1465167353176719362, 1465161948974911489, 1465161940966354945, TIMESTAMP '2021-12-03 10:57:26.123' , 1465161948974911489, TIMESTAMP '2021-12-03 10:57:26.123', 1, 0, '956176') Execute Time: 110.467ms ============== Sql End ============== [XNIO-1 task-29] INFO org.springblade.bladex.core.mp.plugins.SqlLogInterceptor - ============== Sql Start ============== Execute SQL : select id, plan_id, user_id, user_detail_id, create_user , create_dept, create_time, update_user, update_time, status , is_deleted from plan_middle_user where is_deleted = 0 and plan_id = 1465167353176719362 Execute Time: 3.819ms ============== Sql End ============== [XNIO-1 task-29] INFO org.springblade.bladex.core.log.aspect.RequestLogAspect - ================ Response Start ================ ===Result=== {"code":200,"success":true,"data":null,"msg":"操作成功"} <=== POST: /plansign/save (3652 ms)
扫一扫访问 Blade技术社区 移动端