Symfony Profiler

SELECT
  e0_.id AS id_0,
  e0_.category AS category_1,
  e0_.title AS title_2,
  e0_.main_image AS main_image_3,
  e0_.thumbnail AS thumbnail_4,
  e0_.summary_title AS summary_title_5,
  e0_.summary_content AS summary_content_6,
  e0_.pickup_content_description AS pickup_content_description_7,
  e0_.title_en AS title_en_8,
  e0_.title_cn AS title_cn_9,
  e0_.summary_title_en AS summary_title_en_10,
  e0_.summary_title_cn AS summary_title_cn_11,
  e0_.summary_content_en AS summary_content_en_12,
  e0_.summary_content_cn AS summary_content_cn_13,
  e0_.pickup_contents_description_en AS pickup_contents_description_en_14,
  e0_.pickup_contents_description_cn AS pickup_contents_description_cn_15,
  e0_.title_tw AS title_tw_16,
  e0_.summary_title_tw AS summary_title_tw_17,
  e0_.summary_content_tw AS summary_content_tw_18,
  e0_.pickup_contents_description_tw AS pickup_contents_description_tw_19,
  e0_.add_life_experience AS add_life_experience_20,
  e0_.life_experience_thumbnail AS life_experience_thumbnail_21,
  e0_.is_draft AS is_draft_22,
  e0_.approval AS approval_23,
  e0_.created_at AS created_at_24,
  e0_.updated_at AS updated_at_25,
  e0_.deleted_at AS deleted_at_26,
  e0_.slave_entry_id AS slave_entry_id_27,
  e0_.owner_id AS owner_id_28,
  e0_.area_id AS area_id_29
FROM
  entry_entry e0_
  LEFT JOIN account_owner a1_ ON (e0_.owner_id = a1_.id)
  AND (a1_.deleted_at IS NULL)
WHERE
  (
    e0_.approval = ?
    AND e0_.is_draft = ?
    AND a1_.status = ?
    AND e0_.id = ?
    AND e0_.category = ?
  )
  AND (e0_.deleted_at IS NULL)

SELECT e0_.id AS id_0, e0_.category AS category_1, e0_.title AS title_2, e0_.main_image AS main_image_3, e0_.thumbnail AS thumbnail_4, e0_.summary_title AS summary_title_5, e0_.summary_content AS summary_content_6, e0_.pickup_content_description AS pickup_content_description_7, e0_.title_en AS title_en_8, e0_.title_cn AS title_cn_9, e0_.summary_title_en AS summary_title_en_10, e0_.summary_title_cn AS summary_title_cn_11, e0_.summary_content_en AS summary_content_en_12, e0_.summary_content_cn AS summary_content_cn_13, e0_.pickup_contents_description_en AS pickup_contents_description_en_14, e0_.pickup_contents_description_cn AS pickup_contents_description_cn_15, e0_.title_tw AS title_tw_16, e0_.summary_title_tw AS summary_title_tw_17, e0_.summary_content_tw AS summary_content_tw_18, e0_.pickup_contents_description_tw AS pickup_contents_description_tw_19, e0_.add_life_experience AS add_life_experience_20, e0_.life_experience_thumbnail AS life_experience_thumbnail_21, e0_.is_draft AS is_draft_22, e0_.approval AS approval_23, e0_.created_at AS created_at_24, e0_.updated_at AS updated_at_25, e0_.deleted_at AS deleted_at_26, e0_.slave_entry_id AS slave_entry_id_27, e0_.owner_id AS owner_id_28, e0_.area_id AS area_id_29 FROM entry_entry e0_ LEFT JOIN account_owner a1_ ON (e0_.owner_id = a1_.id) AND (a1_.deleted_at IS NULL) WHERE (e0_.approval = 1 AND e0_.is_draft = 0 AND a1_.status = 1 AND e0_.id = 31 AND e0_.category = 2) AND (e0_.deleted_at IS NULL);

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.deleted_at AS deleted_at_3,
  t0.id AS id_4,
  t0.lat AS lat_5,
  t0.lng AS lng_6,
  t0.entry_id AS entry_id_7
FROM
  entry_geolocation t0
WHERE
  t0.entry_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.lat AS lat_5, t0.lng AS lng_6, t0.entry_id AS entry_id_7 FROM entry_geolocation t0 WHERE t0.entry_id = 31 AND ((t0.deleted_at IS NULL));

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.deleted_at AS deleted_at_3,
  t0.id AS id_4,
  t0.number AS number_5,
  t0.parson_comment AS parson_comment_6,
  t0.parson_comment_en AS parson_comment_en_7,
  t0.parson_comment_cn AS parson_comment_cn_8,
  t0.parson_comment_tw AS parson_comment_tw_9,
  t0.inquiry_name AS inquiry_name_10,
  t0.inquiry_name_en AS inquiry_name_en_11,
  t0.inquiry_name_cn AS inquiry_name_cn_12,
  t0.inquiry_name_tw AS inquiry_name_tw_13,
  t0.inquiry_phone AS inquiry_phone_14,
  t0.inquiry_url AS inquiry_url_15,
  t0.inquiry_remark AS inquiry_remark_16,
  t0.inquiry_remark_en AS inquiry_remark_en_17,
  t0.inquiry_remark_cn AS inquiry_remark_cn_18,
  t0.inquiry_remark_tw AS inquiry_remark_tw_19,
  t0.is_recommend AS is_recommend_20,
  t0.entry_id AS entry_id_21,
  t0.parson_id AS parson_id_22
FROM
  entry_modelplan t0
WHERE
  t0.entry_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.number AS number_5, t0.parson_comment AS parson_comment_6, t0.parson_comment_en AS parson_comment_en_7, t0.parson_comment_cn AS parson_comment_cn_8, t0.parson_comment_tw AS parson_comment_tw_9, t0.inquiry_name AS inquiry_name_10, t0.inquiry_name_en AS inquiry_name_en_11, t0.inquiry_name_cn AS inquiry_name_cn_12, t0.inquiry_name_tw AS inquiry_name_tw_13, t0.inquiry_phone AS inquiry_phone_14, t0.inquiry_url AS inquiry_url_15, t0.inquiry_remark AS inquiry_remark_16, t0.inquiry_remark_en AS inquiry_remark_en_17, t0.inquiry_remark_cn AS inquiry_remark_cn_18, t0.inquiry_remark_tw AS inquiry_remark_tw_19, t0.is_recommend AS is_recommend_20, t0.entry_id AS entry_id_21, t0.parson_id AS parson_id_22 FROM entry_modelplan t0 WHERE t0.entry_id = 31 AND ((t0.deleted_at IS NULL));

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.deleted_at AS deleted_at_3,
  t0.id AS id_4,
  t0.description AS description_5,
  t0.postal AS postal_6,
  t0.address AS address_7,
  t0.phone AS phone_8,
  t0.business_time AS business_time_9,
  t0.parking AS parking_10,
  t0.website AS website_11,
  t0.transportation AS transportation_12,
  t0.description_en AS description_en_13,
  t0.description_cn AS description_cn_14,
  t0.description_tw AS description_tw_15,
  t0.address_en AS address_en_16,
  t0.address_cn AS address_cn_17,
  t0.address_tw AS address_tw_18,
  t0.business_time_en AS business_time_en_19,
  t0.business_time_cn AS business_time_cn_20,
  t0.business_time_tw AS business_time_tw_21,
  t0.parking_en AS parking_en_22,
  t0.parking_cn AS parking_cn_23,
  t0.parking_tw AS parking_tw_24,
  t0.transportation_en AS transportation_en_25,
  t0.transportation_cn AS transportation_cn_26,
  t0.transportation_tw AS transportation_tw_27,
  t0.life_summary AS life_summary_28,
  t0.life_summary_en AS life_summary_en_29,
  t0.life_summary_cn AS life_summary_cn_30,
  t0.life_summary_tw AS life_summary_tw_31,
  t0.parson_comment AS parson_comment_32,
  t0.parson_comment_en AS parson_comment_en_33,
  t0.parson_comment_cn AS parson_comment_cn_34,
  t0.parson_comment_tw AS parson_comment_tw_35,
  t0.entry_id AS entry_id_36,
  t0.parson_id AS parson_id_37
FROM
  entry_hotel t0
WHERE
  t0.entry_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.description AS description_5, t0.postal AS postal_6, t0.address AS address_7, t0.phone AS phone_8, t0.business_time AS business_time_9, t0.parking AS parking_10, t0.website AS website_11, t0.transportation AS transportation_12, t0.description_en AS description_en_13, t0.description_cn AS description_cn_14, t0.description_tw AS description_tw_15, t0.address_en AS address_en_16, t0.address_cn AS address_cn_17, t0.address_tw AS address_tw_18, t0.business_time_en AS business_time_en_19, t0.business_time_cn AS business_time_cn_20, t0.business_time_tw AS business_time_tw_21, t0.parking_en AS parking_en_22, t0.parking_cn AS parking_cn_23, t0.parking_tw AS parking_tw_24, t0.transportation_en AS transportation_en_25, t0.transportation_cn AS transportation_cn_26, t0.transportation_tw AS transportation_tw_27, t0.life_summary AS life_summary_28, t0.life_summary_en AS life_summary_en_29, t0.life_summary_cn AS life_summary_cn_30, t0.life_summary_tw AS life_summary_tw_31, t0.parson_comment AS parson_comment_32, t0.parson_comment_en AS parson_comment_en_33, t0.parson_comment_cn AS parson_comment_cn_34, t0.parson_comment_tw AS parson_comment_tw_35, t0.entry_id AS entry_id_36, t0.parson_id AS parson_id_37 FROM entry_hotel t0 WHERE t0.entry_id = 31 AND ((t0.deleted_at IS NULL));

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.deleted_at AS deleted_at_3,
  t0.id AS id_4,
  t0.description AS description_5,
  t0.postal AS postal_6,
  t0.address AS address_7,
  t0.phone AS phone_8,
  t0.business_time AS business_time_9,
  t0.parking AS parking_10,
  t0.website AS website_11,
  t0.transportation AS transportation_12,
  t0.description_en AS description_en_13,
  t0.description_cn AS description_cn_14,
  t0.description_tw AS description_tw_15,
  t0.address_en AS address_en_16,
  t0.address_cn AS address_cn_17,
  t0.address_tw AS address_tw_18,
  t0.business_time_en AS business_time_en_19,
  t0.business_time_cn AS business_time_cn_20,
  t0.business_time_tw AS business_time_tw_21,
  t0.parking_en AS parking_en_22,
  t0.parking_cn AS parking_cn_23,
  t0.parking_tw AS parking_tw_24,
  t0.transportation_en AS transportation_en_25,
  t0.transportation_cn AS transportation_cn_26,
  t0.transportation_tw AS transportation_tw_27,
  t0.life_summary AS life_summary_28,
  t0.life_summary_en AS life_summary_en_29,
  t0.life_summary_cn AS life_summary_cn_30,
  t0.life_summary_tw AS life_summary_tw_31,
  t0.parson_comment AS parson_comment_32,
  t0.parson_comment_en AS parson_comment_en_33,
  t0.parson_comment_cn AS parson_comment_cn_34,
  t0.parson_comment_tw AS parson_comment_tw_35,
  t0.entry_id AS entry_id_36,
  t0.parson_id AS parson_id_37
FROM
  entry_workspace t0
WHERE
  t0.entry_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.description AS description_5, t0.postal AS postal_6, t0.address AS address_7, t0.phone AS phone_8, t0.business_time AS business_time_9, t0.parking AS parking_10, t0.website AS website_11, t0.transportation AS transportation_12, t0.description_en AS description_en_13, t0.description_cn AS description_cn_14, t0.description_tw AS description_tw_15, t0.address_en AS address_en_16, t0.address_cn AS address_cn_17, t0.address_tw AS address_tw_18, t0.business_time_en AS business_time_en_19, t0.business_time_cn AS business_time_cn_20, t0.business_time_tw AS business_time_tw_21, t0.parking_en AS parking_en_22, t0.parking_cn AS parking_cn_23, t0.parking_tw AS parking_tw_24, t0.transportation_en AS transportation_en_25, t0.transportation_cn AS transportation_cn_26, t0.transportation_tw AS transportation_tw_27, t0.life_summary AS life_summary_28, t0.life_summary_en AS life_summary_en_29, t0.life_summary_cn AS life_summary_cn_30, t0.life_summary_tw AS life_summary_tw_31, t0.parson_comment AS parson_comment_32, t0.parson_comment_en AS parson_comment_en_33, t0.parson_comment_cn AS parson_comment_cn_34, t0.parson_comment_tw AS parson_comment_tw_35, t0.entry_id AS entry_id_36, t0.parson_id AS parson_id_37 FROM entry_workspace t0 WHERE t0.entry_id = 31 AND ((t0.deleted_at IS NULL));

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.deleted_at AS deleted_at_3,
  t0.id AS id_4,
  t0.description AS description_5,
  t0.postal AS postal_6,
  t0.address AS address_7,
  t0.phone AS phone_8,
  t0.business_time AS business_time_9,
  t0.parking AS parking_10,
  t0.website AS website_11,
  t0.transportation AS transportation_12,
  t0.description_en AS description_en_13,
  t0.description_cn AS description_cn_14,
  t0.description_tw AS description_tw_15,
  t0.address_en AS address_en_16,
  t0.address_cn AS address_cn_17,
  t0.address_tw AS address_tw_18,
  t0.business_time_en AS business_time_en_19,
  t0.business_time_cn AS business_time_cn_20,
  t0.business_time_tw AS business_time_tw_21,
  t0.parking_en AS parking_en_22,
  t0.parking_cn AS parking_cn_23,
  t0.parking_tw AS parking_tw_24,
  t0.transportation_en AS transportation_en_25,
  t0.transportation_cn AS transportation_cn_26,
  t0.transportation_tw AS transportation_tw_27,
  t0.life_summary AS life_summary_28,
  t0.life_summary_en AS life_summary_en_29,
  t0.life_summary_cn AS life_summary_cn_30,
  t0.life_summary_tw AS life_summary_tw_31,
  t0.parson_comment AS parson_comment_32,
  t0.parson_comment_en AS parson_comment_en_33,
  t0.parson_comment_cn AS parson_comment_cn_34,
  t0.parson_comment_tw AS parson_comment_tw_35,
  t0.entry_id AS entry_id_36,
  t0.parson_id AS parson_id_37
FROM
  entry_actibity t0
WHERE
  t0.entry_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.description AS description_5, t0.postal AS postal_6, t0.address AS address_7, t0.phone AS phone_8, t0.business_time AS business_time_9, t0.parking AS parking_10, t0.website AS website_11, t0.transportation AS transportation_12, t0.description_en AS description_en_13, t0.description_cn AS description_cn_14, t0.description_tw AS description_tw_15, t0.address_en AS address_en_16, t0.address_cn AS address_cn_17, t0.address_tw AS address_tw_18, t0.business_time_en AS business_time_en_19, t0.business_time_cn AS business_time_cn_20, t0.business_time_tw AS business_time_tw_21, t0.parking_en AS parking_en_22, t0.parking_cn AS parking_cn_23, t0.parking_tw AS parking_tw_24, t0.transportation_en AS transportation_en_25, t0.transportation_cn AS transportation_cn_26, t0.transportation_tw AS transportation_tw_27, t0.life_summary AS life_summary_28, t0.life_summary_en AS life_summary_en_29, t0.life_summary_cn AS life_summary_cn_30, t0.life_summary_tw AS life_summary_tw_31, t0.parson_comment AS parson_comment_32, t0.parson_comment_en AS parson_comment_en_33, t0.parson_comment_cn AS parson_comment_cn_34, t0.parson_comment_tw AS parson_comment_tw_35, t0.entry_id AS entry_id_36, t0.parson_id AS parson_id_37 FROM entry_actibity t0 WHERE t0.entry_id = 31 AND ((t0.deleted_at IS NULL));

SELECT
  m0_.icon AS icon_0,
  m0_.created_at AS created_at_1,
  m0_.updated_at AS updated_at_2,
  m0_.deleted_at AS deleted_at_3,
  m0_.id AS id_4,
  m0_.name AS name_5,
  m0_.name_en AS name_en_6,
  m0_.name_cn AS name_cn_7,
  m0_.name_tw AS name_tw_8,
  m0_.enable AS enable_9,
  m0_.sort AS sort_10,
  m0_.is_model_plan AS is_model_plan_11,
  m0_.is_hotel AS is_hotel_12,
  m0_.is_workspace AS is_workspace_13,
  m0_.is_activity AS is_activity_14
FROM
  mst_equipment m0_
WHERE
  (
    m0_.enable = ?
    AND m0_.is_hotel = 1
  )
  AND (m0_.deleted_at IS NULL)
ORDER BY
  m0_.sort ASC

SELECT m0_.icon AS icon_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.deleted_at AS deleted_at_3, m0_.id AS id_4, m0_.name AS name_5, m0_.name_en AS name_en_6, m0_.name_cn AS name_cn_7, m0_.name_tw AS name_tw_8, m0_.enable AS enable_9, m0_.sort AS sort_10, m0_.is_model_plan AS is_model_plan_11, m0_.is_hotel AS is_hotel_12, m0_.is_workspace AS is_workspace_13, m0_.is_activity AS is_activity_14 FROM mst_equipment m0_ WHERE (m0_.enable = 1 AND m0_.is_hotel = 1) AND (m0_.deleted_at IS NULL) ORDER BY m0_.sort ASC;

SELECT
  m0_.created_at AS created_at_0,
  m0_.updated_at AS updated_at_1,
  m0_.deleted_at AS deleted_at_2,
  m0_.id AS id_3,
  m0_.name AS name_4,
  m0_.name_en AS name_en_5,
  m0_.name_cn AS name_cn_6,
  m0_.name_tw AS name_tw_7,
  m0_.enable AS enable_8,
  m0_.sort AS sort_9,
  m0_.is_model_plan AS is_model_plan_10,
  m0_.is_hotel AS is_hotel_11,
  m0_.is_workspace AS is_workspace_12,
  m0_.is_activity AS is_activity_13
FROM
  mst_service m0_
WHERE
  (
    m0_.enable = ?
    AND m0_.is_hotel = 1
  )
  AND (m0_.deleted_at IS NULL)
ORDER BY
  m0_.sort ASC

SELECT m0_.created_at AS created_at_0, m0_.updated_at AS updated_at_1, m0_.deleted_at AS deleted_at_2, m0_.id AS id_3, m0_.name AS name_4, m0_.name_en AS name_en_5, m0_.name_cn AS name_cn_6, m0_.name_tw AS name_tw_7, m0_.enable AS enable_8, m0_.sort AS sort_9, m0_.is_model_plan AS is_model_plan_10, m0_.is_hotel AS is_hotel_11, m0_.is_workspace AS is_workspace_12, m0_.is_activity AS is_activity_13 FROM mst_service m0_ WHERE (m0_.enable = 1 AND m0_.is_hotel = 1) AND (m0_.deleted_at IS NULL) ORDER BY m0_.sort ASC;

SELECT
  m0_.created_at AS created_at_0,
  m0_.updated_at AS updated_at_1,
  m0_.deleted_at AS deleted_at_2,
  m0_.id AS id_3,
  m0_.name AS name_4,
  m0_.name_en AS name_en_5,
  m0_.name_cn AS name_cn_6,
  m0_.name_tw AS name_tw_7,
  m0_.enable AS enable_8,
  m0_.sort AS sort_9,
  m0_.is_model_plan AS is_model_plan_10,
  m0_.is_hotel AS is_hotel_11,
  m0_.is_workspace AS is_workspace_12,
  m0_.is_activity AS is_activity_13
FROM
  mst_target m0_
WHERE
  (
    m0_.enable = ?
    AND m0_.is_hotel = 1
  )
  AND (m0_.deleted_at IS NULL)
ORDER BY
  m0_.sort ASC

SELECT m0_.created_at AS created_at_0, m0_.updated_at AS updated_at_1, m0_.deleted_at AS deleted_at_2, m0_.id AS id_3, m0_.name AS name_4, m0_.name_en AS name_en_5, m0_.name_cn AS name_cn_6, m0_.name_tw AS name_tw_7, m0_.enable AS enable_8, m0_.sort AS sort_9, m0_.is_model_plan AS is_model_plan_10, m0_.is_hotel AS is_hotel_11, m0_.is_workspace AS is_workspace_12, m0_.is_activity AS is_activity_13 FROM mst_target m0_ WHERE (m0_.enable = 1 AND m0_.is_hotel = 1) AND (m0_.deleted_at IS NULL) ORDER BY m0_.sort ASC;

SELECT
  t0.area_group AS area_group_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.id AS id_5,
  t0.name AS name_6,
  t0.name_en AS name_en_7,
  t0.name_cn AS name_cn_8,
  t0.name_tw AS name_tw_9,
  t0.enable AS enable_10,
  t0.sort AS sort_11
FROM
  mst_area t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.area_group AS area_group_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.id AS id_5, t0.name AS name_6, t0.name_en AS name_en_7, t0.name_cn AS name_cn_8, t0.name_tw AS name_tw_9, t0.enable AS enable_10, t0.sort AS sort_11 FROM mst_area t0 WHERE t0.id = 23 AND ((t0.deleted_at IS NULL));

SELECT
  e0_.id AS id_0,
  e0_.category AS category_1,
  e0_.title AS title_2,
  e0_.main_image AS main_image_3,
  e0_.thumbnail AS thumbnail_4,
  e0_.summary_title AS summary_title_5,
  e0_.summary_content AS summary_content_6,
  e0_.pickup_content_description AS pickup_content_description_7,
  e0_.title_en AS title_en_8,
  e0_.title_cn AS title_cn_9,
  e0_.summary_title_en AS summary_title_en_10,
  e0_.summary_title_cn AS summary_title_cn_11,
  e0_.summary_content_en AS summary_content_en_12,
  e0_.summary_content_cn AS summary_content_cn_13,
  e0_.pickup_contents_description_en AS pickup_contents_description_en_14,
  e0_.pickup_contents_description_cn AS pickup_contents_description_cn_15,
  e0_.title_tw AS title_tw_16,
  e0_.summary_title_tw AS summary_title_tw_17,
  e0_.summary_content_tw AS summary_content_tw_18,
  e0_.pickup_contents_description_tw AS pickup_contents_description_tw_19,
  e0_.add_life_experience AS add_life_experience_20,
  e0_.life_experience_thumbnail AS life_experience_thumbnail_21,
  e0_.is_draft AS is_draft_22,
  e0_.approval AS approval_23,
  e0_.created_at AS created_at_24,
  e0_.updated_at AS updated_at_25,
  e0_.deleted_at AS deleted_at_26,
  e0_.slave_entry_id AS slave_entry_id_27,
  e0_.owner_id AS owner_id_28,
  e0_.area_id AS area_id_29
FROM
  entry_entry e0_
  LEFT JOIN account_owner a1_ ON (e0_.owner_id = a1_.id)
  AND (a1_.deleted_at IS NULL)
  LEFT JOIN mst_area m2_ ON (e0_.area_id = m2_.id)
  AND (m2_.deleted_at IS NULL)
WHERE
  (
    e0_.approval = ?
    AND e0_.is_draft = ?
    AND a1_.status = ?
    AND e0_.category = ?
    AND m2_.area_group = ?
    AND e0_.id <> ?
  )
  AND (e0_.deleted_at IS NULL)
ORDER BY
  RAND() ASC
LIMIT
  3

SELECT e0_.id AS id_0, e0_.category AS category_1, e0_.title AS title_2, e0_.main_image AS main_image_3, e0_.thumbnail AS thumbnail_4, e0_.summary_title AS summary_title_5, e0_.summary_content AS summary_content_6, e0_.pickup_content_description AS pickup_content_description_7, e0_.title_en AS title_en_8, e0_.title_cn AS title_cn_9, e0_.summary_title_en AS summary_title_en_10, e0_.summary_title_cn AS summary_title_cn_11, e0_.summary_content_en AS summary_content_en_12, e0_.summary_content_cn AS summary_content_cn_13, e0_.pickup_contents_description_en AS pickup_contents_description_en_14, e0_.pickup_contents_description_cn AS pickup_contents_description_cn_15, e0_.title_tw AS title_tw_16, e0_.summary_title_tw AS summary_title_tw_17, e0_.summary_content_tw AS summary_content_tw_18, e0_.pickup_contents_description_tw AS pickup_contents_description_tw_19, e0_.add_life_experience AS add_life_experience_20, e0_.life_experience_thumbnail AS life_experience_thumbnail_21, e0_.is_draft AS is_draft_22, e0_.approval AS approval_23, e0_.created_at AS created_at_24, e0_.updated_at AS updated_at_25, e0_.deleted_at AS deleted_at_26, e0_.slave_entry_id AS slave_entry_id_27, e0_.owner_id AS owner_id_28, e0_.area_id AS area_id_29 FROM entry_entry e0_ LEFT JOIN account_owner a1_ ON (e0_.owner_id = a1_.id) AND (a1_.deleted_at IS NULL) LEFT JOIN mst_area m2_ ON (e0_.area_id = m2_.id) AND (m2_.deleted_at IS NULL) WHERE (e0_.approval = 1 AND e0_.is_draft = 0 AND a1_.status = 1 AND e0_.category = 2 AND m2_.area_group = 4 AND e0_.id <> 31) AND (e0_.deleted_at IS NULL) ORDER BY RAND() ASC LIMIT 3;

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.deleted_at AS deleted_at_3,
  t0.id AS id_4,
  t0.lat AS lat_5,
  t0.lng AS lng_6,
  t0.entry_id AS entry_id_7
FROM
  entry_geolocation t0
WHERE
  t0.entry_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.lat AS lat_5, t0.lng AS lng_6, t0.entry_id AS entry_id_7 FROM entry_geolocation t0 WHERE t0.entry_id = 49 AND ((t0.deleted_at IS NULL));

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.deleted_at AS deleted_at_3,
  t0.id AS id_4,
  t0.number AS number_5,
  t0.parson_comment AS parson_comment_6,
  t0.parson_comment_en AS parson_comment_en_7,
  t0.parson_comment_cn AS parson_comment_cn_8,
  t0.parson_comment_tw AS parson_comment_tw_9,
  t0.inquiry_name AS inquiry_name_10,
  t0.inquiry_name_en AS inquiry_name_en_11,
  t0.inquiry_name_cn AS inquiry_name_cn_12,
  t0.inquiry_name_tw AS inquiry_name_tw_13,
  t0.inquiry_phone AS inquiry_phone_14,
  t0.inquiry_url AS inquiry_url_15,
  t0.inquiry_remark AS inquiry_remark_16,
  t0.inquiry_remark_en AS inquiry_remark_en_17,
  t0.inquiry_remark_cn AS inquiry_remark_cn_18,
  t0.inquiry_remark_tw AS inquiry_remark_tw_19,
  t0.is_recommend AS is_recommend_20,
  t0.entry_id AS entry_id_21,
  t0.parson_id AS parson_id_22
FROM
  entry_modelplan t0
WHERE
  t0.entry_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.number AS number_5, t0.parson_comment AS parson_comment_6, t0.parson_comment_en AS parson_comment_en_7, t0.parson_comment_cn AS parson_comment_cn_8, t0.parson_comment_tw AS parson_comment_tw_9, t0.inquiry_name AS inquiry_name_10, t0.inquiry_name_en AS inquiry_name_en_11, t0.inquiry_name_cn AS inquiry_name_cn_12, t0.inquiry_name_tw AS inquiry_name_tw_13, t0.inquiry_phone AS inquiry_phone_14, t0.inquiry_url AS inquiry_url_15, t0.inquiry_remark AS inquiry_remark_16, t0.inquiry_remark_en AS inquiry_remark_en_17, t0.inquiry_remark_cn AS inquiry_remark_cn_18, t0.inquiry_remark_tw AS inquiry_remark_tw_19, t0.is_recommend AS is_recommend_20, t0.entry_id AS entry_id_21, t0.parson_id AS parson_id_22 FROM entry_modelplan t0 WHERE t0.entry_id = 49 AND ((t0.deleted_at IS NULL));

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.deleted_at AS deleted_at_3,
  t0.id AS id_4,
  t0.description AS description_5,
  t0.postal AS postal_6,
  t0.address AS address_7,
  t0.phone AS phone_8,
  t0.business_time AS business_time_9,
  t0.parking AS parking_10,
  t0.website AS website_11,
  t0.transportation AS transportation_12,
  t0.description_en AS description_en_13,
  t0.description_cn AS description_cn_14,
  t0.description_tw AS description_tw_15,
  t0.address_en AS address_en_16,
  t0.address_cn AS address_cn_17,
  t0.address_tw AS address_tw_18,
  t0.business_time_en AS business_time_en_19,
  t0.business_time_cn AS business_time_cn_20,
  t0.business_time_tw AS business_time_tw_21,
  t0.parking_en AS parking_en_22,
  t0.parking_cn AS parking_cn_23,
  t0.parking_tw AS parking_tw_24,
  t0.transportation_en AS transportation_en_25,
  t0.transportation_cn AS transportation_cn_26,
  t0.transportation_tw AS transportation_tw_27,
  t0.life_summary AS life_summary_28,
  t0.life_summary_en AS life_summary_en_29,
  t0.life_summary_cn AS life_summary_cn_30,
  t0.life_summary_tw AS life_summary_tw_31,
  t0.parson_comment AS parson_comment_32,
  t0.parson_comment_en AS parson_comment_en_33,
  t0.parson_comment_cn AS parson_comment_cn_34,
  t0.parson_comment_tw AS parson_comment_tw_35,
  t0.entry_id AS entry_id_36,
  t0.parson_id AS parson_id_37
FROM
  entry_hotel t0
WHERE
  t0.entry_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.description AS description_5, t0.postal AS postal_6, t0.address AS address_7, t0.phone AS phone_8, t0.business_time AS business_time_9, t0.parking AS parking_10, t0.website AS website_11, t0.transportation AS transportation_12, t0.description_en AS description_en_13, t0.description_cn AS description_cn_14, t0.description_tw AS description_tw_15, t0.address_en AS address_en_16, t0.address_cn AS address_cn_17, t0.address_tw AS address_tw_18, t0.business_time_en AS business_time_en_19, t0.business_time_cn AS business_time_cn_20, t0.business_time_tw AS business_time_tw_21, t0.parking_en AS parking_en_22, t0.parking_cn AS parking_cn_23, t0.parking_tw AS parking_tw_24, t0.transportation_en AS transportation_en_25, t0.transportation_cn AS transportation_cn_26, t0.transportation_tw AS transportation_tw_27, t0.life_summary AS life_summary_28, t0.life_summary_en AS life_summary_en_29, t0.life_summary_cn AS life_summary_cn_30, t0.life_summary_tw AS life_summary_tw_31, t0.parson_comment AS parson_comment_32, t0.parson_comment_en AS parson_comment_en_33, t0.parson_comment_cn AS parson_comment_cn_34, t0.parson_comment_tw AS parson_comment_tw_35, t0.entry_id AS entry_id_36, t0.parson_id AS parson_id_37 FROM entry_hotel t0 WHERE t0.entry_id = 49 AND ((t0.deleted_at IS NULL));

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.deleted_at AS deleted_at_3,
  t0.id AS id_4,
  t0.description AS description_5,
  t0.postal AS postal_6,
  t0.address AS address_7,
  t0.phone AS phone_8,
  t0.business_time AS business_time_9,
  t0.parking AS parking_10,
  t0.website AS website_11,
  t0.transportation AS transportation_12,
  t0.description_en AS description_en_13,
  t0.description_cn AS description_cn_14,
  t0.description_tw AS description_tw_15,
  t0.address_en AS address_en_16,
  t0.address_cn AS address_cn_17,
  t0.address_tw AS address_tw_18,
  t0.business_time_en AS business_time_en_19,
  t0.business_time_cn AS business_time_cn_20,
  t0.business_time_tw AS business_time_tw_21,
  t0.parking_en AS parking_en_22,
  t0.parking_cn AS parking_cn_23,
  t0.parking_tw AS parking_tw_24,
  t0.transportation_en AS transportation_en_25,
  t0.transportation_cn AS transportation_cn_26,
  t0.transportation_tw AS transportation_tw_27,
  t0.life_summary AS life_summary_28,
  t0.life_summary_en AS life_summary_en_29,
  t0.life_summary_cn AS life_summary_cn_30,
  t0.life_summary_tw AS life_summary_tw_31,
  t0.parson_comment AS parson_comment_32,
  t0.parson_comment_en AS parson_comment_en_33,
  t0.parson_comment_cn AS parson_comment_cn_34,
  t0.parson_comment_tw AS parson_comment_tw_35,
  t0.entry_id AS entry_id_36,
  t0.parson_id AS parson_id_37
FROM
  entry_workspace t0
WHERE
  t0.entry_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.description AS description_5, t0.postal AS postal_6, t0.address AS address_7, t0.phone AS phone_8, t0.business_time AS business_time_9, t0.parking AS parking_10, t0.website AS website_11, t0.transportation AS transportation_12, t0.description_en AS description_en_13, t0.description_cn AS description_cn_14, t0.description_tw AS description_tw_15, t0.address_en AS address_en_16, t0.address_cn AS address_cn_17, t0.address_tw AS address_tw_18, t0.business_time_en AS business_time_en_19, t0.business_time_cn AS business_time_cn_20, t0.business_time_tw AS business_time_tw_21, t0.parking_en AS parking_en_22, t0.parking_cn AS parking_cn_23, t0.parking_tw AS parking_tw_24, t0.transportation_en AS transportation_en_25, t0.transportation_cn AS transportation_cn_26, t0.transportation_tw AS transportation_tw_27, t0.life_summary AS life_summary_28, t0.life_summary_en AS life_summary_en_29, t0.life_summary_cn AS life_summary_cn_30, t0.life_summary_tw AS life_summary_tw_31, t0.parson_comment AS parson_comment_32, t0.parson_comment_en AS parson_comment_en_33, t0.parson_comment_cn AS parson_comment_cn_34, t0.parson_comment_tw AS parson_comment_tw_35, t0.entry_id AS entry_id_36, t0.parson_id AS parson_id_37 FROM entry_workspace t0 WHERE t0.entry_id = 49 AND ((t0.deleted_at IS NULL));