로그인 후 첫페이지 로딩시 발생하는 쿼리를 확인한다.

[knae11]

이슈 설명

• DB replication 을 하면서 기존 데이터가 있을 때, 처음 로그인을 하고 페이지 랜딩까지 30여개의 쿼리가 나갔다.
• 적절한 쿼리가 발생하는지 확인한다.

[knae11]

쿼리발생 현황파악

• GET /api/labs/1/gpus
• local 환경, 데이터로더 적용된 환경 (lab 1개, 해당 랩에 gpuServer 4개, job 10개 등록되어 있는 상황)

-- 1
Hibernate: 
    select
        administra0_.id as col_0_0_ 
    from
        administrator administra0_ 
    where
        administra0_.email=? limit ?

-- 2
Hibernate: 
    select
        member0_.id as id1_5_,
        member0_.created_at as created_2_5_,
        member0_.updated_at as updated_3_5_,
        member0_.email as email4_5_,
        member0_.lab_id as lab_id8_5_,
        member0_.member_type as member_t5_5_,
        member0_.name as name6_5_,
        member0_.password as password7_5_ 
    from
        member member0_ 
    where
        member0_.email=?

-- 3
Hibernate: 
    select
        lab0_.id as id1_4_0_,
        lab0_.created_at as created_2_4_0_,
        lab0_.updated_at as updated_3_4_0_,
        lab0_.name as name4_4_0_ 
    from
        lab lab0_ 
    where
        lab0_.id=?

-- 4
Hibernate: 
    select
        member0_.id as id1_5_,
        member0_.created_at as created_2_5_,
        member0_.updated_at as updated_3_5_,
        member0_.email as email4_5_,
        member0_.lab_id as lab_id8_5_,
        member0_.member_type as member_t5_5_,
        member0_.name as name6_5_,
        member0_.password as password7_5_ 
    from
        member member0_ 
    where
        member0_.email=?

-- 5
Hibernate: 
    select
        lab0_.id as id1_4_0_,
        lab0_.created_at as created_2_4_0_,
        lab0_.updated_at as updated_3_4_0_,
        lab0_.name as name4_4_0_ 
    from
        lab lab0_ 
    where
        lab0_.id=?

-- 6
Hibernate: 
    select
        lab0_.id as id1_4_0_,
        lab0_.created_at as created_2_4_0_,
        lab0_.updated_at as updated_3_4_0_,
        lab0_.name as name4_4_0_ 
    from
        lab lab0_ 
    where
        lab0_.id=?

-- 7
Hibernate: 
    select
        member0_.id as id1_5_0_,
        member0_.created_at as created_2_5_0_,
        member0_.updated_at as updated_3_5_0_,
        member0_.email as email4_5_0_,
        member0_.lab_id as lab_id8_5_0_,
        member0_.member_type as member_t5_5_0_,
        member0_.name as name6_5_0_,
        member0_.password as password7_5_0_,
        lab1_.id as id1_4_1_,
        lab1_.created_at as created_2_4_1_,
        lab1_.updated_at as updated_3_4_1_,
        lab1_.name as name4_4_1_ 
    from
        member member0_ 
    left outer join
        lab lab1_ 
            on member0_.lab_id=lab1_.id 
    where
        member0_.id=?

-- 8
Hibernate: 
    select
        count(*) as col_0_0_ 
    from
        lab lab0_ 
    where
        lab0_.id=?

-- 9
Hibernate: 
    select
        gpuserver0_.id as id1_2_,
        gpuserver0_.created_at as created_2_2_,
        gpuserver0_.updated_at as updated_3_2_,
        gpuserver0_.disk_size as disk_siz4_2_,
        gpuserver0_.is_on as is_on5_2_,
        gpuserver0_.lab_id as lab_id9_2_,
        gpuserver0_.last_response as last_res6_2_,
        gpuserver0_.memory_size as memory_s7_2_,
        gpuserver0_.name as name8_2_ 
    from
        gpu_server gpuserver0_ 
    left outer join
        lab lab1_ 
            on gpuserver0_.lab_id=lab1_.id 
    where
        lab1_.id=?

-- 10
Hibernate: 
    select
        lab0_.id as id1_4_0_,
        lab0_.created_at as created_2_4_0_,
        lab0_.updated_at as updated_3_4_0_,
        lab0_.name as name4_4_0_ 
    from
        lab lab0_ 
    where
        lab0_.id=?

-- 11
Hibernate: 
    select
        gpuserver0_.id as id1_2_,
        gpuserver0_.created_at as created_2_2_,
        gpuserver0_.updated_at as updated_3_2_,
        gpuserver0_.disk_size as disk_siz4_2_,
        gpuserver0_.is_on as is_on5_2_,
        gpuserver0_.lab_id as lab_id9_2_,
        gpuserver0_.last_response as last_res6_2_,
        gpuserver0_.memory_size as memory_s7_2_,
        gpuserver0_.name as name8_2_ 
    from
        gpu_server gpuserver0_ 
    left outer join
        lab lab1_ 
            on gpuserver0_.lab_id=lab1_.id 
    where
        lab1_.id=?

-- 12
Hibernate: 
    select
        gpuboard0_.id as id1_1_,
        gpuboard0_.created_at as created_2_1_,
        gpuboard0_.updated_at as updated_3_1_,
        gpuboard0_.gpu_server_id as gpu_serv7_1_,
        gpuboard0_.is_working as is_worki4_1_,
        gpuboard0_.model_name as model_na5_1_,
        gpuboard0_.performance as performa6_1_ 
    from
        gpu_board gpuboard0_ 
    left outer join
        gpu_server gpuserver1_ 
            on gpuboard0_.gpu_server_id=gpuserver1_.id 
    where
        gpuserver1_.id=?

-- 13
Hibernate: 
    select
        job0_.id as id1_3_,
        job0_.created_at as created_2_3_,
        job0_.updated_at as updated_3_3_,
        job0_.completed_time as complete4_3_,
        job0_.expected_time as expected5_3_,
        job0_.gpu_board_id as gpu_boa10_3_,
        job0_.member_id as member_11_3_,
        job0_.meta_data as meta_dat6_3_,
        job0_.name as name7_3_,
        job0_.started_time as started_8_3_,
        job0_.status as status9_3_ 
    from
        job job0_ 
    left outer join
        gpu_board gpuboard1_ 
            on job0_.gpu_board_id=gpuboard1_.id 
    where
        gpuboard1_.id=? 
        and job0_.status=?

-- 14
Hibernate: 
    select
        member0_.id as id1_5_0_,
        member0_.created_at as created_2_5_0_,
        member0_.updated_at as updated_3_5_0_,
        member0_.email as email4_5_0_,
        member0_.lab_id as lab_id8_5_0_,
        member0_.member_type as member_t5_5_0_,
        member0_.name as name6_5_0_,
        member0_.password as password7_5_0_,
        lab1_.id as id1_4_1_,
        lab1_.created_at as created_2_4_1_,
        lab1_.updated_at as updated_3_4_1_,
        lab1_.name as name4_4_1_ 
    from
        member member0_ 
    left outer join
        lab lab1_ 
            on member0_.lab_id=lab1_.id 
    where
        member0_.id=?

--15
Hibernate: 
    select
        job0_.id as id1_3_,
        job0_.created_at as created_2_3_,
        job0_.updated_at as updated_3_3_,
        job0_.completed_time as complete4_3_,
        job0_.expected_time as expected5_3_,
        job0_.gpu_board_id as gpu_boa10_3_,
        job0_.member_id as member_11_3_,
        job0_.meta_data as meta_dat6_3_,
        job0_.name as name7_3_,
        job0_.started_time as started_8_3_,
        job0_.status as status9_3_ 
    from
        job job0_ 
    left outer join
        gpu_board gpuboard1_ 
            on job0_.gpu_board_id=gpuboard1_.id 
    where
        gpuboard1_.id=? 
        and job0_.status=?

--16
Hibernate: 
    select
        member0_.id as id1_5_0_,
        member0_.created_at as created_2_5_0_,
        member0_.updated_at as updated_3_5_0_,
        member0_.email as email4_5_0_,
        member0_.lab_id as lab_id8_5_0_,
        member0_.member_type as member_t5_5_0_,
        member0_.name as name6_5_0_,
        member0_.password as password7_5_0_,
        lab1_.id as id1_4_1_,
        lab1_.created_at as created_2_4_1_,
        lab1_.updated_at as updated_3_4_1_,
        lab1_.name as name4_4_1_ 
    from
        member member0_ 
    left outer join
        lab lab1_ 
            on member0_.lab_id=lab1_.id 
    where
        member0_.id=?

-- 17
Hibernate: 
    select
        gpuboard0_.id as id1_1_,
        gpuboard0_.created_at as created_2_1_,
        gpuboard0_.updated_at as updated_3_1_,
        gpuboard0_.gpu_server_id as gpu_serv7_1_,
        gpuboard0_.is_working as is_worki4_1_,
        gpuboard0_.model_name as model_na5_1_,
        gpuboard0_.performance as performa6_1_ 
    from
        gpu_board gpuboard0_ 
    left outer join
        gpu_server gpuserver1_ 
            on gpuboard0_.gpu_server_id=gpuserver1_.id 
    where
        gpuserver1_.id=?

-- 18
Hibernate: 
    select
        job0_.id as id1_3_,
        job0_.created_at as created_2_3_,
        job0_.updated_at as updated_3_3_,
        job0_.completed_time as complete4_3_,
        job0_.expected_time as expected5_3_,
        job0_.gpu_board_id as gpu_boa10_3_,
        job0_.member_id as member_11_3_,
        job0_.meta_data as meta_dat6_3_,
        job0_.name as name7_3_,
        job0_.started_time as started_8_3_,
        job0_.status as status9_3_ 
    from
        job job0_ 
    left outer join
        gpu_board gpuboard1_ 
            on job0_.gpu_board_id=gpuboard1_.id 
    where
        gpuboard1_.id=? 
        and job0_.status=?

-- 19
Hibernate: 
    select
        job0_.id as id1_3_,
        job0_.created_at as created_2_3_,
        job0_.updated_at as updated_3_3_,
        job0_.completed_time as complete4_3_,
        job0_.expected_time as expected5_3_,
        job0_.gpu_board_id as gpu_boa10_3_,
        job0_.member_id as member_11_3_,
        job0_.meta_data as meta_dat6_3_,
        job0_.name as name7_3_,
        job0_.started_time as started_8_3_,
        job0_.status as status9_3_ 
    from
        job job0_ 
    left outer join
        gpu_board gpuboard1_ 
            on job0_.gpu_board_id=gpuboard1_.id 
    where
        gpuboard1_.id=? 
        and job0_.status=?

-- 20
Hibernate: 
    select
        gpuboard0_.id as id1_1_,
        gpuboard0_.created_at as created_2_1_,
        gpuboard0_.updated_at as updated_3_1_,
        gpuboard0_.gpu_server_id as gpu_serv7_1_,
        gpuboard0_.is_working as is_worki4_1_,
        gpuboard0_.model_name as model_na5_1_,
        gpuboard0_.performance as performa6_1_ 
    from
        gpu_board gpuboard0_ 
    left outer join
        gpu_server gpuserver1_ 
            on gpuboard0_.gpu_server_id=gpuserver1_.id 
    where
        gpuserver1_.id=?

--21
Hibernate: 
    select
        job0_.id as id1_3_,
        job0_.created_at as created_2_3_,
        job0_.updated_at as updated_3_3_,
        job0_.completed_time as complete4_3_,
        job0_.expected_time as expected5_3_,
        job0_.gpu_board_id as gpu_boa10_3_,
        job0_.member_id as member_11_3_,
        job0_.meta_data as meta_dat6_3_,
        job0_.name as name7_3_,
        job0_.started_time as started_8_3_,
        job0_.status as status9_3_ 
    from
        job job0_ 
    left outer join
        gpu_board gpuboard1_ 
            on job0_.gpu_board_id=gpuboard1_.id 
    where
        gpuboard1_.id=? 
        and job0_.status=?

--22
Hibernate: 
    select
        job0_.id as id1_3_,
        job0_.created_at as created_2_3_,
        job0_.updated_at as updated_3_3_,
        job0_.completed_time as complete4_3_,
        job0_.expected_time as expected5_3_,
        job0_.gpu_board_id as gpu_boa10_3_,
        job0_.member_id as member_11_3_,
        job0_.meta_data as meta_dat6_3_,
        job0_.name as name7_3_,
        job0_.started_time as started_8_3_,
        job0_.status as status9_3_ 
    from
        job job0_ 
    left outer join
        gpu_board gpuboard1_ 
            on job0_.gpu_board_id=gpuboard1_.id 
    where
        gpuboard1_.id=? 
        and job0_.status=?

--23
Hibernate: 
    select
        gpuboard0_.id as id1_1_,
        gpuboard0_.created_at as created_2_1_,
        gpuboard0_.updated_at as updated_3_1_,
        gpuboard0_.gpu_server_id as gpu_serv7_1_,
        gpuboard0_.is_working as is_worki4_1_,
        gpuboard0_.model_name as model_na5_1_,
        gpuboard0_.performance as performa6_1_ 
    from
        gpu_board gpuboard0_ 
    left outer join
        gpu_server gpuserver1_ 
            on gpuboard0_.gpu_server_id=gpuserver1_.id 
    where
        gpuserver1_.id=?

--24
Hibernate: 
    select
        job0_.id as id1_3_,
        job0_.created_at as created_2_3_,
        job0_.updated_at as updated_3_3_,
        job0_.completed_time as complete4_3_,
        job0_.expected_time as expected5_3_,
        job0_.gpu_board_id as gpu_boa10_3_,
        job0_.member_id as member_11_3_,
        job0_.meta_data as meta_dat6_3_,
        job0_.name as name7_3_,
        job0_.started_time as started_8_3_,
        job0_.status as status9_3_ 
    from
        job job0_ 
    left outer join
        gpu_board gpuboard1_ 
            on job0_.gpu_board_id=gpuboard1_.id 
    where
        gpuboard1_.id=? 
        and job0_.status=?

-- 25
Hibernate: 
    select
        job0_.id as id1_3_,
        job0_.created_at as created_2_3_,
        job0_.updated_at as updated_3_3_,
        job0_.completed_time as complete4_3_,
        job0_.expected_time as expected5_3_,
        job0_.gpu_board_id as gpu_boa10_3_,
        job0_.member_id as member_11_3_,
        job0_.meta_data as meta_dat6_3_,
        job0_.name as name7_3_,
        job0_.started_time as started_8_3_,
        job0_.status as status9_3_ 
    from
        job job0_ 
    left outer join
        gpu_board gpuboard1_ 
            on job0_.gpu_board_id=gpuboard1_.id 
    where
        gpuboard1_.id=? 
        and job0_.status=?

• get /api/labs/1/jobs

-- 1
Hibernate: 
    select
        administra0_.id as col_0_0_ 
    from
        administrator administra0_ 
    where
        administra0_.email=? limit ?

-- 2
Hibernate: 
    select
        member0_.id as id1_5_,
        member0_.created_at as created_2_5_,
        member0_.updated_at as updated_3_5_,
        member0_.email as email4_5_,
        member0_.lab_id as lab_id8_5_,
        member0_.member_type as member_t5_5_,
        member0_.name as name6_5_,
        member0_.password as password7_5_ 
    from
        member member0_ 
    where
        member0_.email=?

-- 3
Hibernate: 
    select
        lab0_.id as id1_4_0_,
        lab0_.created_at as created_2_4_0_,
        lab0_.updated_at as updated_3_4_0_,
        lab0_.name as name4_4_0_ 
    from
        lab lab0_ 
    where
        lab0_.id=?

-- 4
Hibernate: 
    select
        gpuserver0_.id as id1_2_,
        gpuserver0_.created_at as created_2_2_,
        gpuserver0_.updated_at as updated_3_2_,
        gpuserver0_.disk_size as disk_siz4_2_,
        gpuserver0_.is_on as is_on5_2_,
        gpuserver0_.lab_id as lab_id9_2_,
        gpuserver0_.last_response as last_res6_2_,
        gpuserver0_.memory_size as memory_s7_2_,
        gpuserver0_.name as name8_2_ 
    from
        gpu_server gpuserver0_ 
    left outer join
        lab lab1_ 
            on gpuserver0_.lab_id=lab1_.id 
    where
        lab1_.id=?

-- 5
Hibernate: 
    select
        lab0_.id as id1_4_0_,
        lab0_.created_at as created_2_4_0_,
        lab0_.updated_at as updated_3_4_0_,
        lab0_.name as name4_4_0_ 
    from
        lab lab0_ 
    where
        lab0_.id=?

-- 6
Hibernate: 
    select
        gpuboard0_.id as id1_1_,
        gpuboard0_.created_at as created_2_1_,
        gpuboard0_.updated_at as updated_3_1_,
        gpuboard0_.gpu_server_id as gpu_serv7_1_,
        gpuboard0_.is_working as is_worki4_1_,
        gpuboard0_.model_name as model_na5_1_,
        gpuboard0_.performance as performa6_1_ 
    from
        gpu_board gpuboard0_ 
    left outer join
        gpu_server gpuserver1_ 
            on gpuboard0_.gpu_server_id=gpuserver1_.id 
    where
        gpuserver1_.id=?

-- 7
Hibernate: 
    select
        job0_.id as id1_3_,
        job0_.created_at as created_2_3_,
        job0_.updated_at as updated_3_3_,
        job0_.completed_time as complete4_3_,
        job0_.expected_time as expected5_3_,
        job0_.gpu_board_id as gpu_boa10_3_,
        job0_.member_id as member_11_3_,
        job0_.meta_data as meta_dat6_3_,
        job0_.name as name7_3_,
        job0_.started_time as started_8_3_,
        job0_.status as status9_3_ 
    from
        job job0_ 
    left outer join
        gpu_board gpuboard1_ 
            on job0_.gpu_board_id=gpuboard1_.id 
    where
        gpuboard1_.id=?

-- 8
Hibernate: 
    select
        member0_.id as id1_5_0_,
        member0_.created_at as created_2_5_0_,
        member0_.updated_at as updated_3_5_0_,
        member0_.email as email4_5_0_,
        member0_.lab_id as lab_id8_5_0_,
        member0_.member_type as member_t5_5_0_,
        member0_.name as name6_5_0_,
        member0_.password as password7_5_0_,
        lab1_.id as id1_4_1_,
        lab1_.created_at as created_2_4_1_,
        lab1_.updated_at as updated_3_4_1_,
        lab1_.name as name4_4_1_ 
    from
        member member0_ 
    left outer join
        lab lab1_ 
            on member0_.lab_id=lab1_.id 
    where
        member0_.id=?

-- 9
Hibernate: 
    select
        member0_.id as id1_5_0_,
        member0_.created_at as created_2_5_0_,
        member0_.updated_at as updated_3_5_0_,
        member0_.email as email4_5_0_,
        member0_.lab_id as lab_id8_5_0_,
        member0_.member_type as member_t5_5_0_,
        member0_.name as name6_5_0_,
        member0_.password as password7_5_0_,
        lab1_.id as id1_4_1_,
        lab1_.created_at as created_2_4_1_,
        lab1_.updated_at as updated_3_4_1_,
        lab1_.name as name4_4_1_ 
    from
        member member0_ 
    left outer join
        lab lab1_ 
            on member0_.lab_id=lab1_.id 
    where
        member0_.id=?

-- 10
Hibernate: 
    select
        gpuboard0_.id as id1_1_,
        gpuboard0_.created_at as created_2_1_,
        gpuboard0_.updated_at as updated_3_1_,
        gpuboard0_.gpu_server_id as gpu_serv7_1_,
        gpuboard0_.is_working as is_worki4_1_,
        gpuboard0_.model_name as model_na5_1_,
        gpuboard0_.performance as performa6_1_ 
    from
        gpu_board gpuboard0_ 
    left outer join
        gpu_server gpuserver1_ 
            on gpuboard0_.gpu_server_id=gpuserver1_.id 
    where
        gpuserver1_.id=?

-- 11
Hibernate: 
    select
        job0_.id as id1_3_,
        job0_.created_at as created_2_3_,
        job0_.updated_at as updated_3_3_,
        job0_.completed_time as complete4_3_,
        job0_.expected_time as expected5_3_,
        job0_.gpu_board_id as gpu_boa10_3_,
        job0_.member_id as member_11_3_,
        job0_.meta_data as meta_dat6_3_,
        job0_.name as name7_3_,
        job0_.started_time as started_8_3_,
        job0_.status as status9_3_ 
    from
        job job0_ 
    left outer join
        gpu_board gpuboard1_ 
            on job0_.gpu_board_id=gpuboard1_.id 
    where
        gpuboard1_.id=?

-- 12
Hibernate: 
    select
        gpuboard0_.id as id1_1_,
        gpuboard0_.created_at as created_2_1_,
        gpuboard0_.updated_at as updated_3_1_,
        gpuboard0_.gpu_server_id as gpu_serv7_1_,
        gpuboard0_.is_working as is_worki4_1_,
        gpuboard0_.model_name as model_na5_1_,
        gpuboard0_.performance as performa6_1_ 
    from
        gpu_board gpuboard0_ 
    left outer join
        gpu_server gpuserver1_ 
            on gpuboard0_.gpu_server_id=gpuserver1_.id 
    where
        gpuserver1_.id=?

-- 13
Hibernate: 
    select
        job0_.id as id1_3_,
        job0_.created_at as created_2_3_,
        job0_.updated_at as updated_3_3_,
        job0_.completed_time as complete4_3_,
        job0_.expected_time as expected5_3_,
        job0_.gpu_board_id as gpu_boa10_3_,
        job0_.member_id as member_11_3_,
        job0_.meta_data as meta_dat6_3_,
        job0_.name as name7_3_,
        job0_.started_time as started_8_3_,
        job0_.status as status9_3_ 
    from
        job job0_ 
    left outer join
        gpu_board gpuboard1_ 
            on job0_.gpu_board_id=gpuboard1_.id 
    where
        gpuboard1_.id=?

-- 14
Hibernate: 
    select
        gpuboard0_.id as id1_1_,
        gpuboard0_.created_at as created_2_1_,
        gpuboard0_.updated_at as updated_3_1_,
        gpuboard0_.gpu_server_id as gpu_serv7_1_,
        gpuboard0_.is_working as is_worki4_1_,
        gpuboard0_.model_name as model_na5_1_,
        gpuboard0_.performance as performa6_1_ 
    from
        gpu_board gpuboard0_ 
    left outer join
        gpu_server gpuserver1_ 
            on gpuboard0_.gpu_server_id=gpuserver1_.id 
    where
        gpuserver1_.id=?

-- 15
Hibernate: 
    select
        job0_.id as id1_3_,
        job0_.created_at as created_2_3_,
        job0_.updated_at as updated_3_3_,
        job0_.completed_time as complete4_3_,
        job0_.expected_time as expected5_3_,
        job0_.gpu_board_id as gpu_boa10_3_,
        job0_.member_id as member_11_3_,
        job0_.meta_data as meta_dat6_3_,
        job0_.name as name7_3_,
        job0_.started_time as started_8_3_,
        job0_.status as status9_3_ 
    from
        job job0_ 
    left outer join
        gpu_board gpuboard1_ 
            on job0_.gpu_board_id=gpuboard1_.id 
    where
        gpuboard1_.id=?