Published on
•
👁️

P6Spy 로그가 2번 찍히는 경우

Authors
  • avatar
    Name
    River
    Twitter

p6spy 설정 시 하나의 쿼리문에 로그가 두 번 찍히는 경우

  • 이상하게 같은 로그가 두 번씩 찍히는 경우가 발생했다.

    1744014341679|0|statement|connection 1|url jdbc:p6spy:mysql://127.0.0.1:3306/pawpatrol_db?useUnicode=true&characterEncoding=utf8&autoReconnect=true&serverTimezone=Asia/Seoul|select m1_0.id,m1_0.address,m1_0.api_key,m1_0.birth_date,m1_0.created_at,m1_0.email,m1_0.gender,m1_0.login_type,m1_0.marketing_agree,m1_0.modified_at,m1_0.nickname,m1_0.password,m1_0.phone_number,m1_0.profile_image_url,m1_0.role,m1_0.status from members m1_0 where m1_0.email=?|select m1_0.id,m1_0.address,m1_0.api_key,m1_0.birth_date,m1_0.created_at,m1_0.email,m1_0.gender,m1_0.login_type,m1_0.marketing_agree,m1_0.modified_at,m1_0.nickname,m1_0.password,m1_0.phone_number,m1_0.profile_image_url,m1_0.role,m1_0.status from members m1_0 where m1_0.email='center2@test.com'
1744014341679|0|statement|connection 22|url jdbc:mysql://127.0.0.1:3306/pawpatrol_db?useUnicode=true&characterEncoding=utf8&autoReconnect=true&serverTimezone=Asia/Seoul|select m1_0.id,m1_0.address,m1_0.api_key,m1_0.birth_date,m1_0.created_at,m1_0.email,m1_0.gender,m1_0.login_type,m1_0.marketing_agree,m1_0.modified_at,m1_0.nickname,m1_0.password,m1_0.phone_number,m1_0.profile_image_url,m1_0.role,m1_0.status from members m1_0 where m1_0.email=?|select m1_0.id,m1_0.address,m1_0.api_key,m1_0.birth_date,m1_0.created_at,m1_0.email,m1_0.gender,m1_0.login_type,m1_0.marketing_agree,m1_0.modified_at,m1_0.nickname,m1_0.password,m1_0.phone_number,m1_0.profile_image_url,m1_0.role,m1_0.status from members m1_0 where m1_0.email='center2@test.com'
1744014341680|0|statement|connection 1|url jdbc:p6spy:mysql://127.0.0.1:3306/pawpatrol_db?useUnicode=true&characterEncoding=utf8&autoReconnect=true&serverTimezone=Asia/Seoul|select s1_0.id,s1_0.address,s1_0.business_registration_number,s1_0.created_at,s1_0.latitude,s1_0.longitude,s1_0.modified_at,s1_0.name,s1_0.closed_days,s1_0.weekday_time,s1_0.weekend_time,s1_0.owner,s1_0.save_target_animal,sm1_0.id,sm1_0.address,sm1_0.api_key,sm1_0.birth_date,sm1_0.created_at,sm1_0.email,sm1_0.gender,sm1_0.login_type,sm1_0.marketing_agree,sm1_0.modified_at,sm1_0.nickname,oap1_0.member_id,oap1_0.created_at,oap1_0.google_connected,oap1_0.google_connected_at,oap1_0.google_email,oap1_0.google_modified_at,oap1_0.google_provider_id,oap1_0.kakao_connected,oap1_0.kakao_connected_at,oap1_0.kakao_email,oap1_0.kakao_modified_at,oap1_0.kakao_provider_id,oap1_0.modified_at,oap1_0.naver_connected,oap1_0.naver_connected_at,oap1_0.naver_email,oap1_0.naver_modified_at,oap1_0.naver_provider_id,sm1_0.password,sm1_0.phone_number,sm1_0.profile_image_url,sm1_0.role,sm1_0.status,s1_0.tel,s1_0.vet_person_count from shelters s1_0 left join members sm1_0 on sm1_0.id=s1_0.member_id left join oauth_providers oap1_0 on sm1_0.id=oap1_0.member_id where s1_0.member_id=?|select s1_0.id,s1_0.address,s1_0.business_registration_number,s1_0.created_at,s1_0.latitude,s1_0.longitude,s1_0.modified_at,s1_0.name,s1_0.closed_days,s1_0.weekday_time,s1_0.weekend_time,s1_0.owner,s1_0.save_target_animal,sm1_0.id,sm1_0.address,sm1_0.api_key,sm1_0.birth_date,sm1_0.created_at,sm1_0.email,sm1_0.gender,sm1_0.login_type,sm1_0.marketing_agree,sm1_0.modified_at,sm1_0.nickname,oap1_0.member_id,oap1_0.created_at,oap1_0.google_connected,oap1_0.google_connected_at,oap1_0.google_email,oap1_0.google_modified_at,oap1_0.google_provider_id,oap1_0.kakao_connected,oap1_0.kakao_connected_at,oap1_0.kakao_email,oap1_0.kakao_modified_at,oap1_0.kakao_provider_id,oap1_0.modified_at,oap1_0.naver_connected,oap1_0.naver_connected_at,oap1_0.naver_email,oap1_0.naver_modified_at,oap1_0.naver_provider_id,sm1_0.password,sm1_0.phone_number,sm1_0.profile_image_url,sm1_0.role,sm1_0.status,s1_0.tel,s1_0.vet_person_count from shelters s1_0 left join members sm1_0 on sm1_0.id=s1_0.member_id left join oauth_providers oap1_0 on sm1_0.id=oap1_0.member_id where s1_0.member_id=2
1744014341680|0|statement|connection 22|url jdbc:mysql://127.0.0.1:3306/pawpatrol_db?useUnicode=true&characterEncoding=utf8&autoReconnect=true&serverTimezone=Asia/Seoul|select s1_0.id,s1_0.address,s1_0.business_registration_number,s1_0.created_at,s1_0.latitude,s1_0.longitude,s1_0.modified_at,s1_0.name,s1_0.closed_days,s1_0.weekday_time,s1_0.weekend_time,s1_0.owner,s1_0.save_target_animal,sm1_0.id,sm1_0.address,sm1_0.api_key,sm1_0.birth_date,sm1_0.created_at,sm1_0.email,sm1_0.gender,sm1_0.login_type,sm1_0.marketing_agree,sm1_0.modified_at,sm1_0.nickname,oap1_0.member_id,oap1_0.created_at,oap1_0.google_connected,oap1_0.google_connected_at,oap1_0.google_email,oap1_0.google_modified_at,oap1_0.google_provider_id,oap1_0.kakao_connected,oap1_0.kakao_connected_at,oap1_0.kakao_email,oap1_0.kakao_modified_at,oap1_0.kakao_provider_id,oap1_0.modified_at,oap1_0.naver_connected,oap1_0.naver_connected_at,oap1_0.naver_email,oap1_0.naver_modified_at,oap1_0.naver_provider_id,sm1_0.password,sm1_0.phone_number,sm1_0.profile_image_url,sm1_0.role,sm1_0.status,s1_0.tel,s1_0.vet_person_count from shelters s1_0 left join members sm1_0 on sm1_0.id=s1_0.member_id left join oauth_providers oap1_0 on sm1_0.id=oap1_0.member_id where s1_0.member_id=?|select s1_0.id,s1_0.address,s1_0.business_registration_number,s1_0.created_at,s1_0.latitude,s1_0.longitude,s1_0.modified_at,s1_0.name,s1_0.closed_days,s1_0.weekday_time,s1_0.weekend_time,s1_0.owner,s1_0.save_target_animal,sm1_0.id,sm1_0.address,sm1_0.api_key,sm1_0.birth_date,sm1_0.created_at,sm1_0.email,sm1_0.gender,sm1_0.login_type,sm1_0.marketing_agree,sm1_0.modified_at,sm1_0.nickname,oap1_0.member_id,oap1_0.created_at,oap1_0.google_connected,oap1_0.google_connected_at,oap1_0.google_email,oap1_0.google_modified_at,oap1_0.google_provider_id,oap1_0.kakao_connected,oap1_0.kakao_connected_at,oap1_0.kakao_email,oap1_0.kakao_modified_at,oap1_0.kakao_provider_id,oap1_0.modified_at,oap1_0.naver_connected,oap1_0.naver_connected_at,oap1_0.naver_email,oap1_0.naver_modified_at,oap1_0.naver_provider_id,sm1_0.password,sm1_0.phone_number,sm1_0.profile_image_url,sm1_0.role,sm1_0.status,s1_0.tel,s1_0.vet_person_count from shelters s1_0 left join members sm1_0 on sm1_0.id=s1_0.member_id left join oauth_providers oap1_0 on sm1_0.id=oap1_0.member_id where s1_0.member_id=2
1744014341682|0|statement|connection 1|url jdbc:p6spy:mysql://127.0.0.1:3306/pawpatrol_db?useUnicode=true&characterEncoding=utf8&autoReconnect=true&serverTimezone=Asia/Seoul|select op1_0.member_id,op1_0.created_at,op1_0.google_connected,op1_0.google_connected_at,op1_0.google_email,op1_0.google_modified_at,op1_0.google_provider_id,op1_0.kakao_connected,op1_0.kakao_connected_at,op1_0.kakao_email,op1_0.kakao_modified_at,op1_0.kakao_provider_id,m1_0.id,m1_0.address,m1_0.api_key,m1_0.birth_date,m1_0.created_at,m1_0.email,m1_0.gender,m1_0.login_type,m1_0.marketing_agree,m1_0.modified_at,m1_0.nickname,m1_0.password,m1_0.phone_number,m1_0.profile_image_url,m1_0.role,s1_0.id,s1_0.address,s1_0.business_registration_number,s1_0.created_at,s1_0.latitude,s1_0.longitude,s1_0.modified_at,s1_0.name,s1_0.closed_days,s1_0.weekday_time,s1_0.weekend_time,s1_0.owner,s1_0.save_target_animal,s1_0.tel,s1_0.vet_person_count,m1_0.status,op1_0.modified_at,op1_0.naver_connected,op1_0.naver_connected_at,op1_0.naver_email,op1_0.naver_modified_at,op1_0.naver_provider_id from oauth_providers op1_0 join members m1_0 on m1_0.id=op1_0.member_id left join shelters s1_0 on m1_0.id=s1_0.member_id where op1_0.member_id=?|select op1_0.member_id,op1_0.created_at,op1_0.google_connected,op1_0.google_connected_at,op1_0.google_email,op1_0.google_modified_at,op1_0.google_provider_id,op1_0.kakao_connected,op1_0.kakao_connected_at,op1_0.kakao_email,op1_0.kakao_modified_at,op1_0.kakao_provider_id,m1_0.id,m1_0.address,m1_0.api_key,m1_0.birth_date,m1_0.created_at,m1_0.email,m1_0.gender,m1_0.login_type,m1_0.marketing_agree,m1_0.modified_at,m1_0.nickname,m1_0.password,m1_0.phone_number,m1_0.profile_image_url,m1_0.role,s1_0.id,s1_0.address,s1_0.business_registration_number,s1_0.created_at,s1_0.latitude,s1_0.longitude,s1_0.modified_at,s1_0.name,s1_0.closed_days,s1_0.weekday_time,s1_0.weekend_time,s1_0.owner,s1_0.save_target_animal,s1_0.tel,s1_0.vet_person_count,m1_0.status,op1_0.modified_at,op1_0.naver_connected,op1_0.naver_connected_at,op1_0.naver_email,op1_0.naver_modified_at,op1_0.naver_provider_id from oauth_providers op1_0 join members m1_0 on m1_0.id=op1_0.member_id left join shelters s1_0 on m1_0.id=s1_0.member_id where op1_0.member_id=2
1744014341682|0|statement|connection 22|url jdbc:mysql://127.0.0.1:3306/pawpatrol_db?useUnicode=true&characterEncoding=utf8&autoReconnect=true&serverTimezone=Asia/Seoul|select op1_0.member_id,op1_0.created_at,op1_0.google_connected,op1_0.google_connected_at,op1_0.google_email,op1_0.google_modified_at,op1_0.google_provider_id,op1_0.kakao_connected,op1_0.kakao_connected_at,op1_0.kakao_email,op1_0.kakao_modified_at,op1_0.kakao_provider_id,m1_0.id,m1_0.address,m1_0.api_key,m1_0.birth_date,m1_0.created_at,m1_0.email,m1_0.gender,m1_0.login_type,m1_0.marketing_agree,m1_0.modified_at,m1_0.nickname,m1_0.password,m1_0.phone_number,m1_0.profile_image_url,m1_0.role,s1_0.id,s1_0.address,s1_0.business_registration_number,s1_0.created_at,s1_0.latitude,s1_0.longitude,s1_0.modified_at,s1_0.name,s1_0.closed_days,s1_0.weekday_time,s1_0.weekend_time,s1_0.owner,s1_0.save_target_animal,s1_0.tel,s1_0.vet_person_count,m1_0.status,op1_0.modified_at,op1_0.naver_connected,op1_0.naver_connected_at,op1_0.naver_email,op1_0.naver_modified_at,op1_0.naver_provider_id from oauth_providers op1_0 join members m1_0 on m1_0.id=op1_0.member_id left join shelters s1_0 on m1_0.id=s1_0.member_id where op1_0.member_id=?|select op1_0.member_id,op1_0.created_at,op1_0.google_connected,op1_0.google_connected_at,op1_0.google_email,op1_0.google_modified_at,op1_0.google_provider_id,op1_0.kakao_connected,op1_0.kakao_connected_at,op1_0.kakao_email,op1_0.kakao_modified_at,op1_0.kakao_provider_id,m1_0.id,m1_0.address,m1_0.api_key,m1_0.birth_date,m1_0.created_at,m1_0.email,m1_0.gender,m1_0.login_type,m1_0.marketing_agree,m1_0.modified_at,m1_0.nickname,m1_0.password,m1_0.phone_number,m1_0.profile_image_url,m1_0.role,s1_0.id,s1_0.address,s1_0.business_registration_number,s1_0.created_at,s1_0.latitude,s1_0.longitude,s1_0.modified_at,s1_0.name,s1_0.closed_days,s1_0.weekday_time,s1_0.weekend_time,s1_0.owner,s1_0.save_target_animal,s1_0.tel,s1_0.vet_person_count,m1_0.status,op1_0.modified_at,op1_0.naver_connected,op1_0.naver_connected_at,op1_0.naver_email,op1_0.naver_modified_at,op1_0.naver_provider_id from oauth_providers op1_0 join members m1_0 on m1_0.id=op1_0.member_id left join shelters s1_0 on m1_0.id=s1_0.member_id where op1_0.member_id=2
1744014341703|1|statement|connection 1|url jdbc:p6spy:mysql://127.0.0.1:3306/pawpatrol_db?useUnicode=true&characterEncoding=utf8&autoReconnect=true&serverTimezone=Asia/Seoul|select ac1_0.id,a1_0.id,a1_0.animal_type,a1_0.breed,a1_0.created_at,a1_0.estimated_age,a1_0.feature,a1_0.gender,a1_0.health_condition,a1_0.image_url,a1_0.is_lost,a1_0.modified_at,a1_0.name,a1_0.owner_id,a1_0.registration_no,a1_0.size,ac1_0.created_at,cf1_0.id,cf1_0.address,cf1_0.api_key,cf1_0.birth_date,cf1_0.created_at,cf1_0.email,cf1_0.gender,cf1_0.login_type,cf1_0.marketing_agree,cf1_0.modified_at,cf1_0.nickname,cf1_0.password,cf1_0.phone_number,cf1_0.profile_image_url,cf1_0.role,cf1_0.status,ac1_0.deleted_at,ac1_0.description,ac1_0.location,ac1_0.modified_at,ac1_0.shelter_id,ac1_0.status,ac1_0.title from animal_cases ac1_0 left join animals a1_0 on a1_0.id=ac1_0.animal_id left join members cf1_0 on cf1_0.id=ac1_0.current_foster_id where cf1_0.id=? and ac1_0.status in (?,?,?) and ac1_0.deleted_at is null order by ac1_0.created_at desc limit ?|select ac1_0.id,a1_0.id,a1_0.animal_type,a1_0.breed,a1_0.created_at,a1_0.estimated_age,a1_0.feature,a1_0.gender,a1_0.health_condition,a1_0.image_url,a1_0.is_lost,a1_0.modified_at,a1_0.name,a1_0.owner_id,a1_0.registration_no,a1_0.size,ac1_0.created_at,cf1_0.id,cf1_0.address,cf1_0.api_key,cf1_0.birth_date,cf1_0.created_at,cf1_0.email,cf1_0.gender,cf1_0.login_type,cf1_0.marketing_agree,cf1_0.modified_at,cf1_0.nickname,cf1_0.password,cf1_0.phone_number,cf1_0.profile_image_url,cf1_0.role,cf1_0.status,ac1_0.deleted_at,ac1_0.description,ac1_0.location,ac1_0.modified_at,ac1_0.shelter_id,ac1_0.status,ac1_0.title from animal_cases ac1_0 left join animals a1_0 on a1_0.id=ac1_0.animal_id left join members cf1_0 on cf1_0.id=ac1_0.current_foster_id where cf1_0.id=2 and ac1_0.status in ('PROTECT_WAITING','TEMP_PROTECTING','SHELTER_PROTECTING') and ac1_0.deleted_at is null order by ac1_0.created_at desc limit 10
1744014341704|1|statement|connection 23|url jdbc:mysql://127.0.0.1:3306/pawpatrol_db?useUnicode=true&characterEncoding=utf8&autoReconnect=true&serverTimezone=Asia/Seoul|select ac1_0.id,a1_0.id,a1_0.animal_type,a1_0.breed,a1_0.created_at,a1_0.estimated_age,a1_0.feature,a1_0.gender,a1_0.health_condition,a1_0.image_url,a1_0.is_lost,a1_0.modified_at,a1_0.name,a1_0.owner_id,a1_0.registration_no,a1_0.size,ac1_0.created_at,cf1_0.id,cf1_0.address,cf1_0.api_key,cf1_0.birth_date,cf1_0.created_at,cf1_0.email,cf1_0.gender,cf1_0.login_type,cf1_0.marketing_agree,cf1_0.modified_at,cf1_0.nickname,cf1_0.password,cf1_0.phone_number,cf1_0.profile_image_url,cf1_0.role,cf1_0.status,ac1_0.deleted_at,ac1_0.description,ac1_0.location,ac1_0.modified_at,ac1_0.shelter_id,ac1_0.status,ac1_0.title from animal_cases ac1_0 left join animals a1_0 on a1_0.id=ac1_0.animal_id left join members cf1_0 on cf1_0.id=ac1_0.current_foster_id where cf1_0.id=? and ac1_0.status in (?,?,?) and ac1_0.deleted_at is null order by ac1_0.created_at desc limit ?|select ac1_0.id,a1_0.id,a1_0.animal_type,a1_0.breed,a1_0.created_at,a1_0.estimated_age,a1_0.feature,a1_0.gender,a1_0.health_condition,a1_0.image_url,a1_0.is_lost,a1_0.modified_at,a1_0.name,a1_0.owner_id,a1_0.registration_no,a1_0.size,ac1_0.created_at,cf1_0.id,cf1_0.address,cf1_0.api_key,cf1_0.birth_date,cf1_0.created_at,cf1_0.email,cf1_0.gender,cf1_0.login_type,cf1_0.marketing_agree,cf1_0.modified_at,cf1_0.nickname,cf1_0.password,cf1_0.phone_number,cf1_0.profile_image_url,cf1_0.role,cf1_0.status,ac1_0.deleted_at,ac1_0.description,ac1_0.location,ac1_0.modified_at,ac1_0.shelter_id,ac1_0.status,ac1_0.title from animal_cases ac1_0 left join animals a1_0 on a1_0.id=ac1_0.animal_id left join members cf1_0 on cf1_0.id=ac1_0.current_foster_id where cf1_0.id=2 and ac1_0.status in ('PROTECT_WAITING','TEMP_PROTECTING','SHELTER_PROTECTING') and ac1_0.deleted_at is null order by ac1_0.created_at desc limit 10
1744014341705|0|statement|connection 1|url jdbc:p6spy:mysql://127.0.0.1:3306/pawpatrol_db?useUnicode=true&characterEncoding=utf8&autoReconnect=true&serverTimezone=Asia/Seoul|select s1_0.id,s1_0.address,s1_0.business_registration_number,s1_0.created_at,s1_0.latitude,s1_0.longitude,s1_0.modified_at,s1_0.name,s1_0.closed_days,s1_0.weekday_time,s1_0.weekend_time,s1_0.owner,s1_0.save_target_animal,sm1_0.id,sm1_0.address,sm1_0.api_key,sm1_0.birth_date,sm1_0.created_at,sm1_0.email,sm1_0.gender,sm1_0.login_type,sm1_0.marketing_agree,sm1_0.modified_at,sm1_0.nickname,oap1_0.member_id,oap1_0.created_at,oap1_0.google_connected,oap1_0.google_connected_at,oap1_0.google_email,oap1_0.google_modified_at,oap1_0.google_provider_id,oap1_0.kakao_connected,oap1_0.kakao_connected_at,oap1_0.kakao_email,oap1_0.kakao_modified_at,oap1_0.kakao_provider_id,oap1_0.modified_at,oap1_0.naver_connected,oap1_0.naver_connected_at,oap1_0.naver_email,oap1_0.naver_modified_at,oap1_0.naver_provider_id,sm1_0.password,sm1_0.phone_number,sm1_0.profile_image_url,sm1_0.role,sm1_0.status,s1_0.tel,s1_0.vet_person_count from shelters s1_0 left join members sm1_0 on sm1_0.id=s1_0.member_id left join oauth_providers oap1_0 on sm1_0.id=oap1_0.member_id where s1_0.member_id=?|select s1_0.id,s1_0.address,s1_0.business_registration_number,s1_0.created_at,s1_0.latitude,s1_0.longitude,s1_0.modified_at,s1_0.name,s1_0.closed_days,s1_0.weekday_time,s1_0.weekend_time,s1_0.owner,s1_0.save_target_animal,sm1_0.id,sm1_0.address,sm1_0.api_key,sm1_0.birth_date,sm1_0.created_at,sm1_0.email,sm1_0.gender,sm1_0.login_type,sm1_0.marketing_agree,sm1_0.modified_at,sm1_0.nickname,oap1_0.member_id,oap1_0.created_at,oap1_0.google_connected,oap1_0.google_connected_at,oap1_0.google_email,oap1_0.google_modified_at,oap1_0.google_provider_id,oap1_0.kakao_connected,oap1_0.kakao_connected_at,oap1_0.kakao_email,oap1_0.kakao_modified_at,oap1_0.kakao_provider_id,oap1_0.modified_at,oap1_0.naver_connected,oap1_0.naver_connected_at,oap1_0.naver_email,oap1_0.naver_modified_at,oap1_0.naver_provider_id,sm1_0.password,sm1_0.phone_number,sm1_0.profile_image_url,sm1_0.role,sm1_0.status,s1_0.tel,s1_0.vet_person_count from shelters s1_0 left join members sm1_0 on sm1_0.id=s1_0.member_id left join oauth_providers oap1_0 on sm1_0.id=oap1_0.member_id where s1_0.member_id=2
1744014341706|1|statement|connection 23|url jdbc:mysql://127.0.0.1:3306/pawpatrol_db?useUnicode=true&characterEncoding=utf8&autoReconnect=true&serverTimezone=Asia/Seoul|select s1_0.id,s1_0.address,s1_0.business_registration_number,s1_0.created_at,s1_0.latitude,s1_0.longitude,s1_0.modified_at,s1_0.name,s1_0.closed_days,s1_0.weekday_time,s1_0.weekend_time,s1_0.owner,s1_0.save_target_animal,sm1_0.id,sm1_0.address,sm1_0.api_key,sm1_0.birth_date,sm1_0.created_at,sm1_0.email,sm1_0.gender,sm1_0.login_type,sm1_0.marketing_agree,sm1_0.modified_at,sm1_0.nickname,oap1_0.member_id,oap1_0.created_at,oap1_0.google_connected,oap1_0.google_connected_at,oap1_0.google_email,oap1_0.google_modified_at,oap1_0.google_provider_id,oap1_0.kakao_connected,oap1_0.kakao_connected_at,oap1_0.kakao_email,oap1_0.kakao_modified_at,oap1_0.kakao_provider_id,oap1_0.modified_at,oap1_0.naver_connected,oap1_0.naver_connected_at,oap1_0.naver_email,oap1_0.naver_modified_at,oap1_0.naver_provider_id,sm1_0.password,sm1_0.phone_number,sm1_0.profile_image_url,sm1_0.role,sm1_0.status,s1_0.tel,s1_0.vet_person_count from shelters s1_0 left join members sm1_0 on sm1_0.id=s1_0.member_id left join oauth_providers oap1_0 on sm1_0.id=oap1_0.member_id where s1_0.member_id=?|select s1_0.id,s1_0.address,s1_0.business_registration_number,s1_0.created_at,s1_0.latitude,s1_0.longitude,s1_0.modified_at,s1_0.name,s1_0.closed_days,s1_0.weekday_time,s1_0.weekend_time,s1_0.owner,s1_0.save_target_animal,sm1_0.id,sm1_0.address,sm1_0.api_key,sm1_0.birth_date,sm1_0.created_at,sm1_0.email,sm1_0.gender,sm1_0.login_type,sm1_0.marketing_agree,sm1_0.modified_at,sm1_0.nickname,oap1_0.member_id,oap1_0.created_at,oap1_0.google_connected,oap1_0.google_connected_at,oap1_0.google_email,oap1_0.google_modified_at,oap1_0.google_provider_id,oap1_0.kakao_connected,oap1_0.kakao_connected_at,oap1_0.kakao_email,oap1_0.kakao_modified_at,oap1_0.kakao_provider_id,oap1_0.modified_at,oap1_0.naver_connected,oap1_0.naver_connected_at,oap1_0.naver_email,oap1_0.naver_modified_at,oap1_0.naver_provider_id,sm1_0.password,sm1_0.phone_number,sm1_0.profile_image_url,sm1_0.role,sm1_0.status,s1_0.tel,s1_0.vet_person_count from shelters s1_0 left join members sm1_0 on sm1_0.id=s1_0.member_id left join oauth_providers oap1_0 on sm1_0.id=oap1_0.member_id where s1_0.member_id=2
1744014341709|0|statement|connection 1|url jdbc:p6spy:mysql://127.0.0.1:3306/pawpatrol_db?useUnicode=true&characterEncoding=utf8&autoReconnect=true&serverTimezone=Asia/Seoul|select op1_0.member_id,op1_0.created_at,op1_0.google_connected,op1_0.google_connected_at,op1_0.google_email,op1_0.google_modified_at,op1_0.google_provider_id,op1_0.kakao_connected,op1_0.kakao_connected_at,op1_0.kakao_email,op1_0.kakao_modified_at,op1_0.kakao_provider_id,m1_0.id,m1_0.address,m1_0.api_key,m1_0.birth_date,m1_0.created_at,m1_0.email,m1_0.gender,m1_0.login_type,m1_0.marketing_agree,m1_0.modified_at,m1_0.nickname,m1_0.password,m1_0.phone_number,m1_0.profile_image_url,m1_0.role,s1_0.id,s1_0.address,s1_0.business_registration_number,s1_0.created_at,s1_0.latitude,s1_0.longitude,s1_0.modified_at,s1_0.name,s1_0.closed_days,s1_0.weekday_time,s1_0.weekend_time,s1_0.owner,s1_0.save_target_animal,s1_0.tel,s1_0.vet_person_count,m1_0.status,op1_0.modified_at,op1_0.naver_connected,op1_0.naver_connected_at,op1_0.naver_email,op1_0.naver_modified_at,op1_0.naver_provider_id from oauth_providers op1_0 join members m1_0 on m1_0.id=op1_0.member_id left join shelters s1_0 on m1_0.id=s1_0.member_id where op1_0.member_id=?|select op1_0.member_id,op1_0.created_at,op1_0.google_connected,op1_0.google_connected_at,op1_0.google_email,op1_0.google_modified_at,op1_0.google_provider_id,op1_0.kakao_connected,op1_0.kakao_connected_at,op1_0.kakao_email,op1_0.kakao_modified_at,op1_0.kakao_provider_id,m1_0.id,m1_0.address,m1_0.api_key,m1_0.birth_date,m1_0.created_at,m1_0.email,m1_0.gender,m1_0.login_type,m1_0.marketing_agree,m1_0.modified_at,m1_0.nickname,m1_0.password,m1_0.phone_number,m1_0.profile_image_url,m1_0.role,s1_0.id,s1_0.address,s1_0.business_registration_number,s1_0.created_at,s1_0.latitude,s1_0.longitude,s1_0.modified_at,s1_0.name,s1_0.closed_days,s1_0.weekday_time,s1_0.weekend_time,s1_0.owner,s1_0.save_target_animal,s1_0.tel,s1_0.vet_person_count,m1_0.status,op1_0.modified_at,op1_0.naver_connected,op1_0.naver_connected_at,op1_0.naver_email,op1_0.naver_modified_at,op1_0.naver_provider_id from oauth_providers op1_0 join members m1_0 on m1_0.id=op1_0.member_id left join shelters s1_0 on m1_0.id=s1_0.member_id where op1_0.member_id=2
1744014341709|0|statement|connection 23|url jdbc:mysql://127.0.0.1:3306/pawpatrol_db?useUnicode=true&characterEncoding=utf8&autoReconnect=true&serverTimezone=Asia/Seoul|select op1_0.member_id,op1_0.created_at,op1_0.google_connected,op1_0.google_connected_at,op1_0.google_email,op1_0.google_modified_at,op1_0.google_provider_id,op1_0.kakao_connected,op1_0.kakao_connected_at,op1_0.kakao_email,op1_0.kakao_modified_at,op1_0.kakao_provider_id,m1_0.id,m1_0.address,m1_0.api_key,m1_0.birth_date,m1_0.created_at,m1_0.email,m1_0.gender,m1_0.login_type,m1_0.marketing_agree,m1_0.modified_at,m1_0.nickname,m1_0.password,m1_0.phone_number,m1_0.profile_image_url,m1_0.role,s1_0.id,s1_0.address,s1_0.business_registration_number,s1_0.created_at,s1_0.latitude,s1_0.longitude,s1_0.modified_at,s1_0.name,s1_0.closed_days,s1_0.weekday_time,s1_0.weekend_time,s1_0.owner,s1_0.save_target_animal,s1_0.tel,s1_0.vet_person_count,m1_0.status,op1_0.modified_at,op1_0.naver_connected,op1_0.naver_connected_at,op1_0.naver_email,op1_0.naver_modified_at,op1_0.naver_provider_id from oauth_providers op1_0 join members m1_0 on m1_0.id=op1_0.member_id left join shelters s1_0 on m1_0.id=s1_0.member_id where op1_0.member_id=?|select op1_0.member_id,op1_0.created_at,op1_0.google_connected,op1_0.google_connected_at,op1_0.google_email,op1_0.google_modified_at,op1_0.google_provider_id,op1_0.kakao_connected,op1_0.kakao_connected_at,op1_0.kakao_email,op1_0.kakao_modified_at,op1_0.kakao_provider_id,m1_0.id,m1_0.address,m1_0.api_key,m1_0.birth_date,m1_0.created_at,m1_0.email,m1_0.gender,m1_0.login_type,m1_0.marketing_agree,m1_0.modified_at,m1_0.nickname,m1_0.password,m1_0.phone_number,m1_0.profile_image_url,m1_0.role,s1_0.id,s1_0.address,s1_0.business_registration_number,s1_0.created_at,s1_0.latitude,s1_0.longitude,s1_0.modified_at,s1_0.name,s1_0.closed_days,s1_0.weekday_time,s1_0.weekend_time,s1_0.owner,s1_0.save_target_animal,s1_0.tel,s1_0.vet_person_count,m1_0.status,op1_0.modified_at,op1_0.naver_connected,op1_0.naver_connected_at,op1_0.naver_email,op1_0.naver_modified_at,op1_0.naver_provider_id from oauth_providers op1_0 join members m1_0 on m1_0.id=op1_0.member_id left join shelters s1_0 on m1_0.id=s1_0.member_id where op1_0.member_id=2
1744014341714|0|statement|connection 1|url jdbc:p6spy:mysql://127.0.0.1:3306/pawpatrol_db?useUnicode=true&characterEncoding=utf8&autoReconnect=true&serverTimezone=Asia/Seoul|select p1_0.id,p1_0.animal_case_id,p1_0.applicant_id,a1_0.id,a1_0.address,a1_0.api_key,a1_0.birth_date,a1_0.created_at,a1_0.email,a1_0.gender,a1_0.login_type,a1_0.marketing_agree,a1_0.modified_at,a1_0.nickname,a1_0.password,a1_0.phone_number,a1_0.profile_image_url,a1_0.role,a1_0.status,p1_0.approved_date,p1_0.created_at,p1_0.deleted_at,p1_0.modified_at,p1_0.protection_status,p1_0.protection_type,p1_0.reason,p1_0.reject_reason from protections p1_0 join members a1_0 on a1_0.id=p1_0.applicant_id where p1_0.animal_case_id=? and p1_0.protection_status=? and p1_0.deleted_at is null|select p1_0.id,p1_0.animal_case_id,p1_0.applicant_id,a1_0.id,a1_0.address,a1_0.api_key,a1_0.birth_date,a1_0.created_at,a1_0.email,a1_0.gender,a1_0.login_type,a1_0.marketing_agree,a1_0.modified_at,a1_0.nickname,a1_0.password,a1_0.phone_number,a1_0.profile_image_url,a1_0.role,a1_0.status,p1_0.approved_date,p1_0.created_at,p1_0.deleted_at,p1_0.modified_at,p1_0.protection_status,p1_0.protection_type,p1_0.reason,p1_0.reject_reason from protections p1_0 join members a1_0 on a1_0.id=p1_0.applicant_id where p1_0.animal_case_id=2 and p1_0.protection_status='PENDING' and p1_0.deleted_at is null
1744014341714|0|statement|connection 23|url jdbc:mysql://127.0.0.1:3306/pawpatrol_db?useUnicode=true&characterEncoding=utf8&autoReconnect=true&serverTimezone=Asia/Seoul|select p1_0.id,p1_0.animal_case_id,p1_0.applicant_id,a1_0.id,a1_0.address,a1_0.api_key,a1_0.birth_date,a1_0.created_at,a1_0.email,a1_0.gender,a1_0.login_type,a1_0.marketing_agree,a1_0.modified_at,a1_0.nickname,a1_0.password,a1_0.phone_number,a1_0.profile_image_url,a1_0.role,a1_0.status,p1_0.approved_date,p1_0.created_at,p1_0.deleted_at,p1_0.modified_at,p1_0.protection_status,p1_0.protection_type,p1_0.reason,p1_0.reject_reason from protections p1_0 join members a1_0 on a1_0.id=p1_0.applicant_id where p1_0.animal_case_id=? and p1_0.protection_status=? and p1_0.deleted_at is null|select p1_0.id,p1_0.animal_case_id,p1_0.applicant_id,a1_0.id,a1_0.address,a1_0.api_key,a1_0.birth_date,a1_0.created_at,a1_0.email,a1_0.gender,a1_0.login_type,a1_0.marketing_agree,a1_0.modified_at,a1_0.nickname,a1_0.password,a1_0.phone_number,a1_0.profile_image_url,a1_0.role,a1_0.status,p1_0.approved_date,p1_0.created_at,p1_0.deleted_at,p1_0.modified_at,p1_0.protection_status,p1_0.protection_type,p1_0.reason,p1_0.reject_reason from protections p1_0 join members a1_0 on a1_0.id=p1_0.applicant_id where p1_0.animal_case_id=2 and p1_0.protection_status='PENDING' and p1_0.deleted_at is null
1744014341718|0|statement|connection 1|url jdbc:p6spy:mysql://127.0.0.1:3306/pawpatrol_db?useUnicode=true&characterEncoding=utf8&autoReconnect=true&serverTimezone=Asia/Seoul|select count(p1_0.id) from protections p1_0 left join animal_cases ac1_0 on ac1_0.id=p1_0.animal_case_id where ac1_0.id=? and p1_0.protection_status=? and p1_0.deleted_at is null|select count(p1_0.id) from protections p1_0 left join animal_cases ac1_0 on ac1_0.id=p1_0.animal_case_id where ac1_0.id=2 and p1_0.protection_status='PENDING' and p1_0.deleted_at is null
1744014341718|0|statement|connection 23|url jdbc:mysql://127.0.0.1:3306/pawpatrol_db?useUnicode=true&characterEncoding=utf8&autoReconnect=true&serverTimezone=Asia/Seoul|select count(p1_0.id) from protections p1_0 left join animal_cases ac1_0 on ac1_0.id=p1_0.animal_case_id where ac1_0.id=? and p1_0.protection_status=? and p1_0.deleted_at is null|select count(p1_0.id) from protections p1_0 left join animal_cases ac1_0 on ac1_0.id=p1_0.animal_case_id where ac1_0.id=2 and p1_0.protection_status='PENDING' and p1_0.deleted_at is null
1744014341721|0|statement|connection 1|url jdbc:p6spy:mysql://127.0.0.1:3306/pawpatrol_db?useUnicode=true&characterEncoding=utf8&autoReconnect=true&serverTimezone=Asia/Seoul|select p1_0.id,p1_0.animal_case_id,p1_0.applicant_id,a1_0.id,a1_0.address,a1_0.api_key,a1_0.birth_date,a1_0.created_at,a1_0.email,a1_0.gender,a1_0.login_type,a1_0.marketing_agree,a1_0.modified_at,a1_0.nickname,a1_0.password,a1_0.phone_number,a1_0.profile_image_url,a1_0.role,a1_0.status,p1_0.approved_date,p1_0.created_at,p1_0.deleted_at,p1_0.modified_at,p1_0.protection_status,p1_0.protection_type,p1_0.reason,p1_0.reject_reason from protections p1_0 join members a1_0 on a1_0.id=p1_0.applicant_id where p1_0.animal_case_id=? and p1_0.protection_status=? and p1_0.deleted_at is null|select p1_0.id,p1_0.animal_case_id,p1_0.applicant_id,a1_0.id,a1_0.address,a1_0.api_key,a1_0.birth_date,a1_0.created_at,a1_0.email,a1_0.gender,a1_0.login_type,a1_0.marketing_agree,a1_0.modified_at,a1_0.nickname,a1_0.password,a1_0.phone_number,a1_0.profile_image_url,a1_0.role,a1_0.status,p1_0.approved_date,p1_0.created_at,p1_0.deleted_at,p1_0.modified_at,p1_0.protection_status,p1_0.protection_type,p1_0.reason,p1_0.reject_reason from protections p1_0 join members a1_0 on a1_0.id=p1_0.applicant_id where p1_0.animal_case_id=1 and p1_0.protection_status='PENDING' and p1_0.deleted_at is null
1744014341721|0|statement|connection 23|url jdbc:mysql://127.0.0.1:3306/pawpatrol_db?useUnicode=true&characterEncoding=utf8&autoReconnect=true&serverTimezone=Asia/Seoul|select p1_0.id,p1_0.animal_case_id,p1_0.applicant_id,a1_0.id,a1_0.address,a1_0.api_key,a1_0.birth_date,a1_0.created_at,a1_0.email,a1_0.gender,a1_0.login_type,a1_0.marketing_agree,a1_0.modified_at,a1_0.nickname,a1_0.password,a1_0.phone_number,a1_0.profile_image_url,a1_0.role,a1_0.status,p1_0.approved_date,p1_0.created_at,p1_0.deleted_at,p1_0.modified_at,p1_0.protection_status,p1_0.protection_type,p1_0.reason,p1_0.reject_reason from protections p1_0 join members a1_0 on a1_0.id=p1_0.applicant_id where p1_0.animal_case_id=? and p1_0.protection_status=? and p1_0.deleted_at is null|select p1_0.id,p1_0.animal_case_id,p1_0.applicant_id,a1_0.id,a1_0.address,a1_0.api_key,a1_0.birth_date,a1_0.created_at,a1_0.email,a1_0.gender,a1_0.login_type,a1_0.marketing_agree,a1_0.modified_at,a1_0.nickname,a1_0.password,a1_0.phone_number,a1_0.profile_image_url,a1_0.role,a1_0.status,p1_0.approved_date,p1_0.created_at,p1_0.deleted_at,p1_0.modified_at,p1_0.protection_status,p1_0.protection_type,p1_0.reason,p1_0.reject_reason from protections p1_0 join members a1_0 on a1_0.id=p1_0.applicant_id where p1_0.animal_case_id=1 and p1_0.protection_status='PENDING' and p1_0.deleted_at is null
1744014341723|0|statement|connection 1|url jdbc:p6spy:mysql://127.0.0.1:3306/pawpatrol_db?useUnicode=true&characterEncoding=utf8&autoReconnect=true&serverTimezone=Asia/Seoul|select count(p1_0.id) from protections p1_0 left join animal_cases ac1_0 on ac1_0.id=p1_0.animal_case_id where ac1_0.id=? and p1_0.protection_status=? and p1_0.deleted_at is null|select count(p1_0.id) from protections p1_0 left join animal_cases ac1_0 on ac1_0.id=p1_0.animal_case_id where ac1_0.id=1 and p1_0.protection_status='PENDING' and p1_0.deleted_at is null
1744014341723|0|statement|connection 23|url jdbc:mysql://127.0.0.1:3306/pawpatrol_db?useUnicode=true&characterEncoding=utf8&autoReconnect=true&serverTimezone=Asia/Seoul|select count(p1_0.id) from protections p1_0 left join animal_cases ac1_0 on ac1_0.id=p1_0.animal_case_id where ac1_0.id=? and p1_0.protection_status=? and p1_0.deleted_at is null|select count(p1_0.id) from protections p1_0 left join animal_cases ac1_0 on ac1_0.id=p1_0.animal_case_id where ac1_0.id=1 and p1_0.protection_status='PENDING' and p1_0.deleted_at is null
1744014341727|0|statement|connection 1|url jdbc:p6spy:mysql://127.0.0.1:3306/pawpatrol_db?useUnicode=true&characterEncoding=utf8&autoReconnect=true&serverTimezone=Asia/Seoul|select count(ac1_0.id) from animal_cases ac1_0 where ac1_0.current_foster_id=? and ac1_0.status=?|select count(ac1_0.id) from animal_cases ac1_0 where ac1_0.current_foster_id=2 and ac1_0.status='PROTECT_WAITING'
1744014341727|0|statement|connection 23|url jdbc:mysql://127.0.0.1:3306/pawpatrol_db?useUnicode=true&characterEncoding=utf8&autoReconnect=true&serverTimezone=Asia/Seoul|select count(ac1_0.id) from animal_cases ac1_0 where ac1_0.current_foster_id=? and ac1_0.status=?|select count(ac1_0.id) from animal_cases ac1_0 where ac1_0.current_foster_id=2 and ac1_0.status='PROTECT_WAITING'
1744014341730|0|statement|connection 1|url jdbc:p6spy:mysql://127.0.0.1:3306/pawpatrol_db?useUnicode=true&characterEncoding=utf8&autoReconnect=true&serverTimezone=Asia/Seoul|select count(ac1_0.id) from animal_cases ac1_0 where ac1_0.current_foster_id=? and ac1_0.status=?|select count(ac1_0.id) from animal_cases ac1_0 where ac1_0.current_foster_id=2 and ac1_0.status='TEMP_PROTECTING'
1744014341730|0|statement|connection 23|url jdbc:mysql://127.0.0.1:3306/pawpatrol_db?useUnicode=true&characterEncoding=utf8&autoReconnect=true&serverTimezone=Asia/Seoul|select count(ac1_0.id) from animal_cases ac1_0 where ac1_0.current_foster_id=? and ac1_0.status=?|select count(ac1_0.id) from animal_cases ac1_0 where ac1_0.current_foster_id=2 and ac1_0.status='TEMP_PROTECTING'
1744014341732|0|statement|connection 1|url jdbc:p6spy:mysql://127.0.0.1:3306/pawpatrol_db?useUnicode=true&characterEncoding=utf8&autoReconnect=true&serverTimezone=Asia/Seoul|select count(ac1_0.id) from animal_cases ac1_0 where ac1_0.current_foster_id=? and ac1_0.status=?|select count(ac1_0.id) from animal_cases ac1_0 where ac1_0.current_foster_id=2 and ac1_0.status='SHELTER_PROTECTING'
1744014341732|0|statement|connection 23|url jdbc:mysql://127.0.0.1:3306/pawpatrol_db?useUnicode=true&characterEncoding=utf8&autoReconnect=true&serverTimezone=Asia/Seoul|select count(ac1_0.id) from animal_cases ac1_0 where ac1_0.current_foster_id=? and ac1_0.status=?|select count(ac1_0.id) from animal_cases ac1_0 where ac1_0.current_foster_id=2 and ac1_0.status='SHELTER_PROTECTING'
    • 현재 같은 쿼리문이 P6Spy를 거치는 경우와 P6Spy를 거치지지 않고 직접 MySQL을 거치는 경우 2번 발생하고 있다.
    • 사실상 둘 다 같은 SQL 실행이지만 다른 커넥션을 통해 나갔다.


  • 이것은 P6Spy 설정의 문제였다.
    [P6Spy] | 0ms | com.patrol.domain.member.member.service.MemberService.findByEmail:36 -> com.patrol.domain.member.member.service.MemberService$$SpringCGLIB$$0.findByEmail:-1 -> com.patrol.global.webMvc.LoginUserArgumentResolver.resolveArgument:50 | select m1_0.id,m1_0.address,m1_0.api_key,m1_0.birth_date,m1_0.created_at,m1_0.email,m1_0.gender,m1_0.login_type,m1_0.marketing_agree,m1_0.modified_at,m1_0.nickname,m1_0.password,m1_0.phone_number,m1_0.profile_image_url,m1_0.role,m1_0.status from members m1_0 where m1_0.email='center2@test.com'
[P6Spy] | 0ms | com.patrol.domain.member.member.service.MemberService.findByEmail:36 -> com.patrol.domain.member.member.service.MemberService$$SpringCGLIB$$0.findByEmail:-1 -> com.patrol.global.webMvc.LoginUserArgumentResolver.resolveArgument:50 | select s1_0.id,s1_0.address,s1_0.business_registration_number,s1_0.created_at,s1_0.latitude,s1_0.longitude,s1_0.modified_at,s1_0.name,s1_0.closed_days,s1_0.weekday_time,s1_0.weekend_time,s1_0.owner,s1_0.save_target_animal,sm1_0.id,sm1_0.address,sm1_0.api_key,sm1_0.birth_date,sm1_0.created_at,sm1_0.email,sm1_0.gender,sm1_0.login_type,sm1_0.marketing_agree,sm1_0.modified_at,sm1_0.nickname,oap1_0.member_id,oap1_0.created_at,oap1_0.google_connected,oap1_0.google_connected_at,oap1_0.google_email,oap1_0.google_modified_at,oap1_0.google_provider_id,oap1_0.kakao_connected,oap1_0.kakao_connected_at,oap1_0.kakao_email,oap1_0.kakao_modified_at,oap1_0.kakao_provider_id,oap1_0.modified_at,oap1_0.naver_connected,oap1_0.naver_connected_at,oap1_0.naver_email,oap1_0.naver_modified_at,oap1_0.naver_provider_id,sm1_0.password,sm1_0.phone_number,sm1_0.profile_image_url,sm1_0.role,sm1_0.status,s1_0.tel,s1_0.vet_person_count from shelters s1_0 left join members sm1_0 on sm1_0.id=s1_0.member_id left join oauth_providers oap1_0 on sm1_0.id=oap1_0.member_id where s1_0.member_id=2
[P6Spy] | 0ms | com.patrol.domain.member.member.service.MemberService.findByEmail:36 -> com.patrol.domain.member.member.service.MemberService$$SpringCGLIB$$0.findByEmail:-1 -> com.patrol.global.webMvc.LoginUserArgumentResolver.resolveArgument:50 | select op1_0.member_id,op1_0.created_at,op1_0.google_connected,op1_0.google_connected_at,op1_0.google_email,op1_0.google_modified_at,op1_0.google_provider_id,op1_0.kakao_connected,op1_0.kakao_connected_at,op1_0.kakao_email,op1_0.kakao_modified_at,op1_0.kakao_provider_id,m1_0.id,m1_0.address,m1_0.api_key,m1_0.birth_date,m1_0.created_at,m1_0.email,m1_0.gender,m1_0.login_type,m1_0.marketing_agree,m1_0.modified_at,m1_0.nickname,m1_0.password,m1_0.phone_number,m1_0.profile_image_url,m1_0.role,s1_0.id,s1_0.address,s1_0.business_registration_number,s1_0.created_at,s1_0.latitude,s1_0.longitude,s1_0.modified_at,s1_0.name,s1_0.closed_days,s1_0.weekday_time,s1_0.weekend_time,s1_0.owner,s1_0.save_target_animal,s1_0.tel,s1_0.vet_person_count,m1_0.status,op1_0.modified_at,op1_0.naver_connected,op1_0.naver_connected_at,op1_0.naver_email,op1_0.naver_modified_at,op1_0.naver_provider_id from oauth_providers op1_0 join members m1_0 on m1_0.id=op1_0.member_id left join shelters s1_0 on m1_0.id=s1_0.member_id where op1_0.member_id=2
[P6Spy] | 1ms | com.patrol.global.webMvc.RepositoryQueryMonitor.logQueryCount:37 -> com.patrol.domain.animalCase.service.AnimalCaseService.findAllByCurrentFosterAndStatus:88 -> com.patrol.domain.animalCase.service.AnimalCaseService$$SpringCGLIB$$0.findAllByCurrentFosterAndStatus:-1 | select ac1_0.id,a1_0.id,a1_0.animal_type,a1_0.breed,a1_0.created_at,a1_0.estimated_age,a1_0.feature,a1_0.gender,a1_0.health_condition,a1_0.image_url,a1_0.is_lost,a1_0.modified_at,a1_0.name,a1_0.owner_id,a1_0.registration_no,a1_0.size,ac1_0.created_at,cf1_0.id,cf1_0.address,cf1_0.api_key,cf1_0.birth_date,cf1_0.created_at,cf1_0.email,cf1_0.gender,cf1_0.login_type,cf1_0.marketing_agree,cf1_0.modified_at,cf1_0.nickname,cf1_0.password,cf1_0.phone_number,cf1_0.profile_image_url,cf1_0.role,cf1_0.status,ac1_0.deleted_at,ac1_0.description,ac1_0.location,ac1_0.modified_at,ac1_0.shelter_id,ac1_0.status,ac1_0.title from animal_cases ac1_0 left join animals a1_0 on a1_0.id=ac1_0.animal_id left join members cf1_0 on cf1_0.id=ac1_0.current_foster_id where cf1_0.id=2 and ac1_0.status in ('PROTECT_WAITING','TEMP_PROTECTING','SHELTER_PROTECTING') and ac1_0.deleted_at is null order by ac1_0.created_at desc limit 10
[P6Spy] | 0ms | com.patrol.global.webMvc.RepositoryQueryMonitor.logQueryCount:37 -> com.patrol.domain.animalCase.service.AnimalCaseService.findAllByCurrentFosterAndStatus:88 -> com.patrol.domain.animalCase.service.AnimalCaseService$$SpringCGLIB$$0.findAllByCurrentFosterAndStatus:-1 | select s1_0.id,s1_0.address,s1_0.business_registration_number,s1_0.created_at,s1_0.latitude,s1_0.longitude,s1_0.modified_at,s1_0.name,s1_0.closed_days,s1_0.weekday_time,s1_0.weekend_time,s1_0.owner,s1_0.save_target_animal,sm1_0.id,sm1_0.address,sm1_0.api_key,sm1_0.birth_date,sm1_0.created_at,sm1_0.email,sm1_0.gender,sm1_0.login_type,sm1_0.marketing_agree,sm1_0.modified_at,sm1_0.nickname,oap1_0.member_id,oap1_0.created_at,oap1_0.google_connected,oap1_0.google_connected_at,oap1_0.google_email,oap1_0.google_modified_at,oap1_0.google_provider_id,oap1_0.kakao_connected,oap1_0.kakao_connected_at,oap1_0.kakao_email,oap1_0.kakao_modified_at,oap1_0.kakao_provider_id,oap1_0.modified_at,oap1_0.naver_connected,oap1_0.naver_connected_at,oap1_0.naver_email,oap1_0.naver_modified_at,oap1_0.naver_provider_id,sm1_0.password,sm1_0.phone_number,sm1_0.profile_image_url,sm1_0.role,sm1_0.status,s1_0.tel,s1_0.vet_person_count from shelters s1_0 left join members sm1_0 on sm1_0.id=s1_0.member_id left join oauth_providers oap1_0 on sm1_0.id=oap1_0.member_id where s1_0.member_id=2
[P6Spy] | 0ms | com.patrol.global.webMvc.RepositoryQueryMonitor.logQueryCount:37 -> com.patrol.domain.animalCase.service.AnimalCaseService.findAllByCurrentFosterAndStatus:88 -> com.patrol.domain.animalCase.service.AnimalCaseService$$SpringCGLIB$$0.findAllByCurrentFosterAndStatus:-1 | select op1_0.member_id,op1_0.created_at,op1_0.google_connected,op1_0.google_connected_at,op1_0.google_email,op1_0.google_modified_at,op1_0.google_provider_id,op1_0.kakao_connected,op1_0.kakao_connected_at,op1_0.kakao_email,op1_0.kakao_modified_at,op1_0.kakao_provider_id,m1_0.id,m1_0.address,m1_0.api_key,m1_0.birth_date,m1_0.created_at,m1_0.email,m1_0.gender,m1_0.login_type,m1_0.marketing_agree,m1_0.modified_at,m1_0.nickname,m1_0.password,m1_0.phone_number,m1_0.profile_image_url,m1_0.role,s1_0.id,s1_0.address,s1_0.business_registration_number,s1_0.created_at,s1_0.latitude,s1_0.longitude,s1_0.modified_at,s1_0.name,s1_0.closed_days,s1_0.weekday_time,s1_0.weekend_time,s1_0.owner,s1_0.save_target_animal,s1_0.tel,s1_0.vet_person_count,m1_0.status,op1_0.modified_at,op1_0.naver_connected,op1_0.naver_connected_at,op1_0.naver_email,op1_0.naver_modified_at,op1_0.naver_provider_id from oauth_providers op1_0 join members m1_0 on m1_0.id=op1_0.member_id left join shelters s1_0 on m1_0.id=s1_0.member_id where op1_0.member_id=2
[P6Spy] | 0ms | com.patrol.global.webMvc.RepositoryQueryMonitor.logQueryCount:37 -> com.patrol.domain.protection.service.ProtectionService.getPendingProtections:291 -> com.patrol.domain.protection.service.ProtectionService.lambda$findMyAnimalCases$1:129 | select p1_0.id,p1_0.animal_case_id,p1_0.applicant_id,a1_0.id,a1_0.address,a1_0.api_key,a1_0.birth_date,a1_0.created_at,a1_0.email,a1_0.gender,a1_0.login_type,a1_0.marketing_agree,a1_0.modified_at,a1_0.nickname,a1_0.password,a1_0.phone_number,a1_0.profile_image_url,a1_0.role,a1_0.status,p1_0.approved_date,p1_0.created_at,p1_0.deleted_at,p1_0.modified_at,p1_0.protection_status,p1_0.protection_type,p1_0.reason,p1_0.reject_reason from protections p1_0 join members a1_0 on a1_0.id=p1_0.applicant_id where p1_0.animal_case_id=2 and p1_0.protection_status='PENDING' and p1_0.deleted_at is null
[P6Spy] | 0ms | com.patrol.global.webMvc.RepositoryQueryMonitor.logQueryCount:37 -> com.patrol.domain.protection.service.ProtectionService.lambda$findMyAnimalCases$1:131 -> com.patrol.domain.protection.service.ProtectionService.findMyAnimalCases:128 | select count(p1_0.id) from protections p1_0 left join animal_cases ac1_0 on ac1_0.id=p1_0.animal_case_id where ac1_0.id=2 and p1_0.protection_status='PENDING' and p1_0.deleted_at is null
[P6Spy] | 0ms | com.patrol.global.webMvc.RepositoryQueryMonitor.logQueryCount:37 -> com.patrol.domain.protection.service.ProtectionService.getPendingProtections:291 -> com.patrol.domain.protection.service.ProtectionService.lambda$findMyAnimalCases$1:129 | select p1_0.id,p1_0.animal_case_id,p1_0.applicant_id,a1_0.id,a1_0.address,a1_0.api_key,a1_0.birth_date,a1_0.created_at,a1_0.email,a1_0.gender,a1_0.login_type,a1_0.marketing_agree,a1_0.modified_at,a1_0.nickname,a1_0.password,a1_0.phone_number,a1_0.profile_image_url,a1_0.role,a1_0.status,p1_0.approved_date,p1_0.created_at,p1_0.deleted_at,p1_0.modified_at,p1_0.protection_status,p1_0.protection_type,p1_0.reason,p1_0.reject_reason from protections p1_0 join members a1_0 on a1_0.id=p1_0.applicant_id where p1_0.animal_case_id=1 and p1_0.protection_status='PENDING' and p1_0.deleted_at is null
[P6Spy] | 0ms | com.patrol.global.webMvc.RepositoryQueryMonitor.logQueryCount:37 -> com.patrol.domain.protection.service.ProtectionService.lambda$findMyAnimalCases$1:131 -> com.patrol.domain.protection.service.ProtectionService.findMyAnimalCases:128 | select count(p1_0.id) from protections p1_0 left join animal_cases ac1_0 on ac1_0.id=p1_0.animal_case_id where ac1_0.id=1 and p1_0.protection_status='PENDING' and p1_0.deleted_at is null
[P6Spy] | 0ms | com.patrol.global.webMvc.RepositoryQueryMonitor.logQueryCount:37 -> com.patrol.domain.animalCase.service.AnimalCaseService.countByCurrentFosterAndStatus:112 -> com.patrol.domain.animalCase.service.AnimalCaseService$$SpringCGLIB$$0.countByCurrentFosterAndStatus:-1 | select count(ac1_0.id) from animal_cases ac1_0 where ac1_0.current_foster_id=2 and ac1_0.status='PROTECT_WAITING'
[P6Spy] | 0ms | com.patrol.global.webMvc.RepositoryQueryMonitor.logQueryCount:37 -> com.patrol.domain.animalCase.service.AnimalCaseService.countByCurrentFosterAndStatus:112 -> com.patrol.domain.animalCase.service.AnimalCaseService$$SpringCGLIB$$0.countByCurrentFosterAndStatus:-1 | select count(ac1_0.id) from animal_cases ac1_0 where ac1_0.current_foster_id=2 and ac1_0.status='TEMP_PROTECTING'
[P6Spy] | 0ms | com.patrol.global.webMvc.RepositoryQueryMonitor.logQueryCount:37 -> com.patrol.domain.animalCase.service.AnimalCaseService.countByCurrentFosterAndStatus:112 -> com.patrol.domain.animalCase.service.AnimalCaseService$$SpringCGLIB$$0.countByCurrentFosterAndStatus:-1 | select count(ac1_0.id) from animal_cases ac1_0 where ac1_0.current_foster_id=2 and ac1_0.status='SHELTER_PROTECTING'
    • 문제가 해결되고 로그를 정리한 상태



문제 원인

  • build.gradle에서 P6Spy를 starter를 통해서 의존성을 가져왔었다.

    dependencies {
    implementation("com.github.gavlyukovskiy:p6spy-spring-boot-starter:1.9.0")
}


  • 이후 application.yml 설정에서 P6SpyDriver로 한 번 감싸주었다.

    spring:
  output:
    ansi:
      enabled: always
  datasource:
    driver-class-name: com.p6spy.engine.spy.P6SpyDriver
    url: jdbc:p6spy:mysql://127.0.0.1:3306/pawpatrol_db?useUnicode=true&characterEncoding=utf8&autoReconnect=true&serverTimezone=Asia/Seoul
    username: root
    password: 1234


  • 하지만, P6Spy의 의존성은 2종류가 있었고 각 종류에 따라 도입하는 방법이 달랐다.

    • 방법 1.
      implementation("com.github.gavlyukovskiy:p6spy-spring-boot-starter:1.9.0")
      • application.yml 설정
        spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3306/pawpatrol_db?useUnicode=true&characterEncoding=utf8&autoReconnect=true&serverTimezone=Asia/Seoul
    username: root
    password: 1234


    • 방법 2.
      implementation("p6spy:p6spy:3.9.1")
      • application.yml 설정
        spring:
  datasource:
    driver-class-name: com.p6spy.engine.spy.P6SpyDriver
    url: jdbc:p6spy:mysql://127.0.0.1:3306/pawpatrol_db?useUnicode=true&characterEncoding=utf8&autoReconnect=true&serverTimezone=Asia/Seoul
    username: root
    password: 1234


  • 즉, 방법 1로 의존성을 도입한 경우, datasource를 P6SpyDriver로 감싸지 않아도 P6Spy 로그가 나온다. 하지만 P6SpyDriver 감싸서 로그가 2번씩 발생한 것이다.
    1744014341679|0|statement|connection 1|url jdbc:p6spy:mysql://127.0.0.1:3306/pawpatrol_db?useUnicode=true&characterEncoding=utf8&autoReconnect=true&serverTimezone=Asia/Seoul|select m1_0.id,m1_0.address,m1_0.api_key,m1_0.birth_date,m1_0.created_at,m1_0.email,m1_0.gender,m1_0.login_type,m1_0.marketing_agree,m1_0.modified_at,m1_0.nickname,m1_0.password,m1_0.phone_number,m1_0.profile_image_url,m1_0.role,m1_0.status from members m1_0 where m1_0.email=?|select m1_0.id,m1_0.address,m1_0.api_key,m1_0.birth_date,m1_0.created_at,m1_0.email,m1_0.gender,m1_0.login_type,m1_0.marketing_agree,m1_0.modified_at,m1_0.nickname,m1_0.password,m1_0.phone_number,m1_0.profile_image_url,m1_0.role,m1_0.status from members m1_0 where m1_0.email='center2@test.com'
1744014341679|0|statement|connection 22|url jdbc:mysql://127.0.0.1:3306/pawpatrol_db?useUnicode=true&characterEncoding=utf8&autoReconnect=true&serverTimezone=Asia/Seoul|select m1_0.id,m1_0.address,m1_0.api_key,m1_0.birth_date,m1_0.created_at,m1_0.email,m1_0.gender,m1_0.login_type,m1_0.marketing_agree,m1_0.modified_at,m1_0.nickname,m1_0.password,m1_0.phone_number,m1_0.profile_image_url,m1_0.role,m1_0.status from members m1_0 where m1_0.email=?|select m1_0.id,m1_0.address,m1_0.api_key,m1_0.birth_date,m1_0.created_at,m1_0.email,m1_0.gender,m1_0.login_type,m1_0.marketing_agree,m1_0.modified_at,m1_0.nickname,m1_0.password,m1_0.phone_number,m1_0.profile_image_url,m1_0.role,m1_0.status from members m1_0 where m1_0.email='center2@test.com'


참고 문헌

Discuss on Twitter • View on GitHub