Symfony Profiler

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
  t0.icon AS icon_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,
  t0.is_model_plan AS is_model_plan_12,
  t0.is_hotel AS is_hotel_13,
  t0.is_workspace AS is_workspace_14,
  t0.is_activity AS is_activity_15
FROM
  mst_equipment t0
  INNER JOIN hotel_equipment ON t0.id = hotel_equipment.equipment_id
WHERE
  hotel_equipment.hotel_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.icon AS icon_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, t0.is_model_plan AS is_model_plan_12, t0.is_hotel AS is_hotel_13, t0.is_workspace AS is_workspace_14, t0.is_activity AS is_activity_15 FROM mst_equipment t0 INNER JOIN hotel_equipment ON t0.id = hotel_equipment.equipment_id WHERE hotel_equipment.hotel_id = 14 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
  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.entry_date AS entry_date_5,
  t0.title AS title_6,
  t0.title_en AS title_en_7,
  t0.title_cn AS title_cn_8,
  t0.title_tw AS title_tw_9,
  t0.enable AS enable_10,
  t0.pub_date AS pub_date_11,
  t0.close_date AS close_date_12,
  t0.main_img AS main_img_13,
  t0.main_img_width AS main_img_width_14,
  t0.main_img_height AS main_img_height_15,
  t0.thumbnail AS thumbnail_16,
  t0.description AS description_17,
  t0.link_url AS link_url_18,
  t0.link_newtab AS link_newtab_19,
  t0.content AS content_20,
  t0.content_en AS content_en_21,
  t0.content_cn AS content_cn_22,
  t0.content_tw AS content_tw_23,
  t0.entry_id AS entry_id_24,
  t0.report_writer_id AS report_writer_id_25
FROM
  cms_entry_report_post t0
WHERE
  t0.entry_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )
ORDER BY
  t0.entry_date DESC,
  t0.id DESC

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.entry_date AS entry_date_5, t0.title AS title_6, t0.title_en AS title_en_7, t0.title_cn AS title_cn_8, t0.title_tw AS title_tw_9, t0.enable AS enable_10, t0.pub_date AS pub_date_11, t0.close_date AS close_date_12, t0.main_img AS main_img_13, t0.main_img_width AS main_img_width_14, t0.main_img_height AS main_img_height_15, t0.thumbnail AS thumbnail_16, t0.description AS description_17, t0.link_url AS link_url_18, t0.link_newtab AS link_newtab_19, t0.content AS content_20, t0.content_en AS content_en_21, t0.content_cn AS content_cn_22, t0.content_tw AS content_tw_23, t0.entry_id AS entry_id_24, t0.report_writer_id AS report_writer_id_25 FROM cms_entry_report_post t0 WHERE t0.entry_id = 31 AND ((t0.deleted_at IS NULL)) ORDER BY t0.entry_date DESC, t0.id DESC;

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.image AS image_5,
  t0.title AS title_6,
  t0.caption AS caption_7,
  t0.sort AS sort_8,
  t0.title_en AS title_en_9,
  t0.title_cn AS title_cn_10,
  t0.caption_en AS caption_en_11,
  t0.caption_cn AS caption_cn_12,
  t0.to_simulation AS to_simulation_13,
  t0.title_tw AS title_tw_14,
  t0.caption_tw AS caption_tw_15,
  t0.entry_id AS entry_id_16
FROM
  entry_pickup_contents t0
WHERE
  t0.entry_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )
ORDER BY
  t0.sort ASC

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.image AS image_5, t0.title AS title_6, t0.caption AS caption_7, t0.sort AS sort_8, t0.title_en AS title_en_9, t0.title_cn AS title_cn_10, t0.caption_en AS caption_en_11, t0.caption_cn AS caption_cn_12, t0.to_simulation AS to_simulation_13, t0.title_tw AS title_tw_14, t0.caption_tw AS caption_tw_15, t0.entry_id AS entry_id_16 FROM entry_pickup_contents t0 WHERE t0.entry_id = 31 AND ((t0.deleted_at IS NULL)) ORDER BY t0.sort ASC;

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_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.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.image AS image_5,
  t0.sort AS sort_6,
  t0.entry_id AS entry_id_7
FROM
  entry_pickup_contents_image t0
WHERE
  t0.entry_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )
ORDER BY
  t0.sort ASC

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.image AS image_5, t0.sort AS sort_6, t0.entry_id AS entry_id_7 FROM entry_pickup_contents_image t0 WHERE t0.entry_id = 31 AND ((t0.deleted_at IS NULL)) ORDER BY t0.sort ASC;

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
  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
  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;