Symfony Profiler

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 = 14 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 = 14 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 = 14 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 = 14 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 = 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_.category = ?
    AND e0_.approval = ?
    AND e0_.is_draft = ?
    AND a1_.status = ?
    AND e0_.id IN (?)
  )
  AND (e0_.deleted_at IS NULL)
ORDER BY
  e0_.id DESC

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_.category = 4 AND e0_.approval = 1 AND e0_.is_draft = 0 AND a1_.status = 1 AND e0_.id IN (63, 62, 61, 60)) AND (e0_.deleted_at IS NULL) ORDER BY e0_.id DESC;

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 = 24 AND ((t0.deleted_at IS NULL));

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        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,
          a1_.id AS id_27,
          a1_.status AS status_28,
          m2_.id AS 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_.category = ?
            AND e0_.approval = ?
            AND e0_.is_draft = ?
            AND a1_.status = ?
          )
          AND (e0_.deleted_at IS NULL)
      ) dctrn_result_inner
    ORDER BY
      id_0 DESC
  ) dctrn_result
LIMIT
  4

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (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, a1_.id AS id_27, a1_.status AS status_28, m2_.id AS 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_.category = 4 AND e0_.approval = 1 AND e0_.is_draft = 0 AND a1_.status = 1) AND (e0_.deleted_at IS NULL)) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 4;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        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
        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_.category = ?
            AND e0_.approval = ?
            AND e0_.is_draft = ?
            AND a1_.status = ?
          )
          AND (e0_.deleted_at IS NULL)
        ORDER BY
          e0_.id DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (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 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_.category = 4 AND e0_.approval = 1 AND e0_.is_draft = 0 AND a1_.status = 1) AND (e0_.deleted_at IS NULL) ORDER BY e0_.id DESC) dctrn_result) dctrn_table;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        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
        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_.category = ?
            AND e0_.approval = ?
            AND e0_.is_draft = ?
            AND a1_.status = ?
          )
          AND (e0_.deleted_at IS NULL)
        ORDER BY
          RAND() ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (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 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_.category = 1 AND e0_.approval = 1 AND e0_.is_draft = 0 AND a1_.status = 1) AND (e0_.deleted_at IS NULL) ORDER BY RAND() ASC) dctrn_result) dctrn_table;

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_.category = ?
    AND e0_.approval = ?
    AND e0_.is_draft = ?
    AND a1_.status = ?
    AND e0_.id IN (?)
  )
  AND (e0_.deleted_at IS NULL)
ORDER BY
  RAND() ASC

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_.category = 1 AND e0_.approval = 1 AND e0_.is_draft = 0 AND a1_.status = 1 AND e0_.id IN (2, 14, 12, 8)) AND (e0_.deleted_at IS NULL) ORDER BY RAND() ASC;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      RAND()
    FROM
      (
        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,
          a1_.id AS id_27,
          a1_.status AS status_28,
          m2_.id AS 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_.category = ?
            AND e0_.approval = ?
            AND e0_.is_draft = ?
            AND a1_.status = ?
          )
          AND (e0_.deleted_at IS NULL)
      ) dctrn_result_inner
    ORDER BY
      RAND() ASC
  ) dctrn_result
LIMIT
  4

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, RAND() FROM (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, a1_.id AS id_27, a1_.status AS status_28, m2_.id AS 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_.category = 1 AND e0_.approval = 1 AND e0_.is_draft = 0 AND a1_.status = 1) AND (e0_.deleted_at IS NULL)) dctrn_result_inner ORDER BY RAND() ASC) dctrn_result LIMIT 4;