로그를 이용해 SQL 쿼리 기록

/v1/maps/search

SELECT DISTINCT
    h1_0."id",
    h1_0."contract_term",
    h1_0."facility_img_description",
    h1_0."facility_img_url",
    h1_0."floor_img_url",
    h1_0."gender_policy",
    h1_0."ground_rule",
    h1_0."kitchen_facility",
    h1_0."latitude",
    h1_0."location",
    h1_0."location_description",
    h1_0."longitude",
    h1_0."main_img_description",
    h1_0."main_img_url",
    h1_0."mood_tag",
    h1_0."name",
    h1_0."room_mood",
    h1_0."safety_living_facility",
    h1_0."sub_mood_tag"
FROM
    "house" h1_0
LEFT JOIN
    "room" r1_0
    ON h1_0."id" = r1_0."house_id"
WHERE
    h1_0."location" = ?
    AND r1_0."deposit" BETWEEN ? AND ?
    AND r1_0."monthly_rent" BETWEEN ? AND ?
    AND r1_0."status" <> r1_0."occupancy_type"
    AND h1_0."mood_tag" = ?
    AND h1_0."gender_policy" IN (?, ?)
    AND h1_0."contract_term" IN (?, ?)
    AND r1_0."occupancy_type" IN (?, ?);

/v1/rooms/1/tour-requests

No queries executed.

/v1/houses/1/details

SELECT
    h1_0."id",
    h1_0."contract_term",
    h1_0."facility_img_description",
    h1_0."facility_img_url",
    h1_0."floor_img_url",
    h1_0."gender_policy",
    h1_0."ground_rule",
    h1_0."kitchen_facility",
    h1_0."latitude",
    h1_0."location",
    h1_0."location_description",
    h1_0."longitude",
    h1_0."main_img_description",
    h1_0."main_img_url",
    h1_0."mood_tag",
    h1_0."name",
    h1_0."room_mood",
    r1_0."house_id",
    r1_0."id",
    r1_0."contract_period",
    r1_0."deposit",
    r1_0."facility",
    r1_0."gender",
    r1_0."main_img_url",
    r1_0."management_fee",
    r1_0."monthly_rent",
    r1_0."name",
    r1_0."occupancy_type",
    r1_0."prepaid_utilities",
    r1_0."status",
    h1_0."safety_living_facility",
    h1_0."sub_mood_tag"
FROM
    "house" h1_0
LEFT JOIN
    "room" r1_0
    ON h1_0."id" = r1_0."house_id"
WHERE
    h1_0."id" = ?;

/v1/houses?moodTag=

SELECT
    u1_0."location"
FROM
    "user" u1_0
WHERE
    u1_0."id" = ?;

/v1/users/home

SELECT
    u1_0."id",
    u1_0."location",
    u1_0."name",
    rvh1_0."user_id",
    rvh1_0."id",
    rvh1_0."house_id",
    rvh1_0."viewed_at"
FROM
    "user" u1_0
LEFT JOIN
    "recently_viewed_house" rvh1_0
    ON u1_0."id" = rvh1_0."user_id"
WHERE
    u1_0."id" = ?;

/v1/locations?q=

No queries executed.

/v1/houses/1/details/images

SELECT
    h1_0."id",
    h1_0."contract_term",
    h1_0."facility_img_description",
    h1_0."facility_img_url",
    h1_0."floor_img_url",
    h1_0."gender_policy",
    h1_0."ground_rule",
    h1_0."kitchen_facility",
    h1_0."latitude",
    h1_0."location",
    h1_0."location_description",
    h1_0."longitude",
    h1_0."main_img_description",
    h1_0."main_img_url",
    h1_0."mood_tag",
    h1_0."name",
    h1_0."room_mood",
    h1_0."safety_living_facility",
    h1_0."sub_mood_tag"
FROM
    "house" h1_0
WHERE
    h1_0."id" = ?;

/v1/houses/1/details/rooms

SELECT
    r1_0."id",
    r1_0."contract_period",
    r1_0."deposit",
    r1_0."facility",
    r1_0."gender",
    r1_0."house_id",
    r1_0."main_img_url",
    r1_0."management_fee",
    r1_0."monthly_rent",
    r1_0."name",
    r1_0."occupancy_type",
    r1_0."prepaid_utilities",
    r1_0."status"
FROM
    "room" r1_0
WHERE
    r1_0."house_id" = ?;

/v1/houses/1/pins

Select Query

SELECT
    p1_0."id",
    p1_0."house_id",
    p1_0."user_id"
FROM
    "pin" p1_0
LEFT JOIN
    "user" u1_0
    ON u1_0."id" = p1_0."user_id"
LEFT JOIN
    "house" h1_0
    ON h1_0."id" = p1_0."house_id"
WHERE
    u1_0."id" = ?
    AND h1_0."id" = ?;