search

YAPP-Github / 24th-Web-Team-1-BE

9 stars 1 forks source link

SQL 로깅시 raw 쿼리로 로깅되도록 설정 #210

Open hun-ca opened 1 month ago

hun-ca commented 1 month ago

[AS-IS]

select `ARTICLE_MST`.`ID` as `articleId`, `ARTICLE_MST`.`MEMBER_ID` as `writerId`, `ARTICLE_MST`.`MAIN_IMAGE_URL` as `mainImageURL`, `ARTICLE_MST`.`TITLE` as `title`, `ARTICLE_MST`.`CATEGORY_CD` as `category`, `ARTICLE_IFO`.`CONTENT` as `content`, `ARTICLE_MST`.`CREATED_AT` as `createdAt` 
from `ARTICLE_MST` 
join `ARTICLE_IFO` 
on `ARTICLE_MST`.`ID` = `ARTICLE_IFO`.`ARTICLE_MST_ID` 
where (`ARTICLE_MST`.`ID` = 1 and `ARTICLE_MST`.`DELETED_AT` is null)