1
1.34 ms
SELECT DISTINCT id_3 FROM (SELECT DISTINCT id_3 , entry_date_4 FROM (SELECT c0_ . created_at AS created_at_0 , c0_ . updated_at AS updated_at_1 , c0_ . deleted_at AS deleted_at_2 , c0_ . id AS id_3 , c0_ . entry_date AS entry_date_4 , c0_ . title AS title_5 , c0_ . title_en AS title_en_6 , c0_ . title_cn AS title_cn_7 , c0_ . title_tw AS title_tw_8 , c0_ . enable AS enable_9 , c0_ . pub_date AS pub_date_10 , c0_ . close_date AS close_date_11 , c0_ . main_img AS main_img_12 , c0_ . main_img_width AS main_img_width_13 , c0_ . main_img_height AS main_img_height_14 , c0_ . thumbnail AS thumbnail_15 , c0_ . description AS description_16 , c0_ . link_url AS link_url_17 , c0_ . link_newtab AS link_newtab_18 , c0_ . content AS content_19 , c0_ . content_en AS content_en_20 , c0_ . content_cn AS content_cn_21 , c0_ . content_tw AS content_tw_22 , e1_ . id AS id_23 , e1_ . is_draft AS is_draft_24 , e1_ . approval AS approval_25 , a2_ . id AS id_26 , a2_ . status AS status_27 FROM cms_entry_report_post c0_ LEFT JOIN entry_entry e1_ ON (c0_ . entry_id = e1_ . id ) AND (e1_ . deleted_at IS NULL ) LEFT JOIN account_owner a2_ ON (e1_ . owner_id = a2_ . id ) AND (a2_ . deleted_at IS NULL ) WHERE (c0_ . enable = ? AND (c0_ . pub_date IS NULL OR c0_ . pub_date < = ? ) AND (c0_ . close_date IS NULL OR c0_ . close_date > = ? ) AND e1_ . approval = ? AND e1_ . is_draft = ? AND a2_ . status = ? ) AND (c0_ . deleted_at IS NULL )) dctrn_result_inner ORDER BY entry_date_4 DESC , id_3 DESC ) dctrn_result LIMIT 12
Parameters :
[
1
"2025-12-20 21:59:58 "
"2025-12-20 21:59:58 "
1
0
1
]
SELECT DISTINCT id_3 FROM (SELECT DISTINCT id_3 , entry_date_4 FROM (SELECT c0_ . created_at AS created_at_0 , c0_ . updated_at AS updated_at_1 , c0_ . deleted_at AS deleted_at_2 , c0_ . id AS id_3 , c0_ . entry_date AS entry_date_4 , c0_ . title AS title_5 , c0_ . title_en AS title_en_6 , c0_ . title_cn AS title_cn_7 , c0_ . title_tw AS title_tw_8 , c0_ . enable AS enable_9 , c0_ . pub_date AS pub_date_10 , c0_ . close_date AS close_date_11 , c0_ . main_img AS main_img_12 , c0_ . main_img_width AS main_img_width_13 , c0_ . main_img_height AS main_img_height_14 , c0_ . thumbnail AS thumbnail_15 , c0_ . description AS description_16 , c0_ . link_url AS link_url_17 , c0_ . link_newtab AS link_newtab_18 , c0_ . content AS content_19 , c0_ . content_en AS content_en_20 , c0_ . content_cn AS content_cn_21 , c0_ . content_tw AS content_tw_22 , e1_ . id AS id_23 , e1_ . is_draft AS is_draft_24 , e1_ . approval AS approval_25 , a2_ . id AS id_26 , a2_ . status AS status_27 FROM cms_entry_report_post c0_ LEFT JOIN entry_entry e1_ ON (c0_ . entry_id = e1_ . id ) AND (e1_ . deleted_at IS NULL ) LEFT JOIN account_owner a2_ ON (e1_ . owner_id = a2_ . id ) AND (a2_ . deleted_at IS NULL ) WHERE (c0_ . enable = 1 AND (c0_ . pub_date IS NULL OR c0_ . pub_date < = '2025-12-20 21:59:58' ) AND (c0_ . close_date IS NULL OR c0_ . close_date > = '2025-12-20 21:59:58' ) AND e1_ . approval = 1 AND e1_ . is_draft = 0 AND a2_ . status = 1 ) AND (c0_ . deleted_at IS NULL )) dctrn_result_inner ORDER BY entry_date_4 DESC , id_3 DESC ) dctrn_result LIMIT 12 ; Copy
2
2.87 ms
SELECT c0_ . created_at AS created_at_0 , c0_ . updated_at AS updated_at_1 , c0_ . deleted_at AS deleted_at_2 , c0_ . id AS id_3 , c0_ . entry_date AS entry_date_4 , c0_ . title AS title_5 , c0_ . title_en AS title_en_6 , c0_ . title_cn AS title_cn_7 , c0_ . title_tw AS title_tw_8 , c0_ . enable AS enable_9 , c0_ . pub_date AS pub_date_10 , c0_ . close_date AS close_date_11 , c0_ . main_img AS main_img_12 , c0_ . main_img_width AS main_img_width_13 , c0_ . main_img_height AS main_img_height_14 , c0_ . thumbnail AS thumbnail_15 , c0_ . description AS description_16 , c0_ . link_url AS link_url_17 , c0_ . link_newtab AS link_newtab_18 , c0_ . content AS content_19 , c0_ . content_en AS content_en_20 , c0_ . content_cn AS content_cn_21 , c0_ . content_tw AS content_tw_22 , c0_ . entry_id AS entry_id_23 , c0_ . report_writer_id AS report_writer_id_24 FROM cms_entry_report_post c0_ LEFT JOIN entry_entry e1_ ON (c0_ . entry_id = e1_ . id ) AND (e1_ . deleted_at IS NULL ) LEFT JOIN account_owner a2_ ON (e1_ . owner_id = a2_ . id ) AND (a2_ . deleted_at IS NULL ) WHERE (c0_ . enable = ? AND (c0_ . pub_date IS NULL OR c0_ . pub_date < = ? ) AND (c0_ . close_date IS NULL OR c0_ . close_date > = ? ) AND e1_ . approval = ? AND e1_ . is_draft = ? AND a2_ . status = ? AND c0_ . id IN (? )) AND (c0_ . deleted_at IS NULL ) ORDER BY c0_ . entry_date DESC , c0_ . id DESC
Parameters :
[
1
"2025-12-20 21:59:58 "
"2025-12-20 21:59:58 "
1
0
1
[
1
2
]
]
SELECT c0_ . created_at AS created_at_0 , c0_ . updated_at AS updated_at_1 , c0_ . deleted_at AS deleted_at_2 , c0_ . id AS id_3 , c0_ . entry_date AS entry_date_4 , c0_ . title AS title_5 , c0_ . title_en AS title_en_6 , c0_ . title_cn AS title_cn_7 , c0_ . title_tw AS title_tw_8 , c0_ . enable AS enable_9 , c0_ . pub_date AS pub_date_10 , c0_ . close_date AS close_date_11 , c0_ . main_img AS main_img_12 , c0_ . main_img_width AS main_img_width_13 , c0_ . main_img_height AS main_img_height_14 , c0_ . thumbnail AS thumbnail_15 , c0_ . description AS description_16 , c0_ . link_url AS link_url_17 , c0_ . link_newtab AS link_newtab_18 , c0_ . content AS content_19 , c0_ . content_en AS content_en_20 , c0_ . content_cn AS content_cn_21 , c0_ . content_tw AS content_tw_22 , c0_ . entry_id AS entry_id_23 , c0_ . report_writer_id AS report_writer_id_24 FROM cms_entry_report_post c0_ LEFT JOIN entry_entry e1_ ON (c0_ . entry_id = e1_ . id ) AND (e1_ . deleted_at IS NULL ) LEFT JOIN account_owner a2_ ON (e1_ . owner_id = a2_ . id ) AND (a2_ . deleted_at IS NULL ) WHERE (c0_ . enable = 1 AND (c0_ . pub_date IS NULL OR c0_ . pub_date < = '2025-12-20 21:59:58' ) AND (c0_ . close_date IS NULL OR c0_ . close_date > = '2025-12-20 21:59:58' ) AND e1_ . approval = 1 AND e1_ . is_draft = 0 AND a2_ . status = 1 AND c0_ . id IN (1 , 2 )) AND (c0_ . deleted_at IS NULL ) ORDER BY c0_ . entry_date DESC , c0_ . id DESC ; Copy
3
0.21 ms
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . name AS name_3 , t0 . name_en AS name_en_4 , t0 . intro AS intro_5 , t0 . intro_en AS intro_en_6 , t0 . intro_cn AS intro_cn_7 , t0 . intro_tw AS intro_tw_8 , t0 . enable AS enable_9 , t0 . created_at AS created_at_10 , t0 . updated_at AS updated_at_11 , t0 . deleted_at AS deleted_at_12 FROM mst_master_reportwriter t0 WHERE t0 . id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . name AS name_3 , t0 . name_en AS name_en_4 , t0 . intro AS intro_5 , t0 . intro_en AS intro_en_6 , t0 . intro_cn AS intro_cn_7 , t0 . intro_tw AS intro_tw_8 , t0 . enable AS enable_9 , t0 . created_at AS created_at_10 , t0 . updated_at AS updated_at_11 , t0 . deleted_at AS deleted_at_12 FROM mst_master_reportwriter t0 WHERE t0 . id = 1 AND ((t0 . deleted_at IS NULL )); Copy
4
0.88 ms
SELECT t0 . id AS id_1 , t0 . category AS category_2 , t0 . title AS title_3 , t0 . main_image AS main_image_4 , t0 . thumbnail AS thumbnail_5 , t0 . summary_title AS summary_title_6 , t0 . summary_content AS summary_content_7 , t0 . pickup_content_description AS pickup_content_description_8 , t0 . title_en AS title_en_9 , t0 . title_cn AS title_cn_10 , t0 . summary_title_en AS summary_title_en_11 , t0 . summary_title_cn AS summary_title_cn_12 , t0 . summary_content_en AS summary_content_en_13 , t0 . summary_content_cn AS summary_content_cn_14 , t0 . pickup_contents_description_en AS pickup_contents_description_en_15 , t0 . pickup_contents_description_cn AS pickup_contents_description_cn_16 , t0 . title_tw AS title_tw_17 , t0 . summary_title_tw AS summary_title_tw_18 , t0 . summary_content_tw AS summary_content_tw_19 , t0 . pickup_contents_description_tw AS pickup_contents_description_tw_20 , t0 . add_life_experience AS add_life_experience_21 , t0 . life_experience_thumbnail AS life_experience_thumbnail_22 , t0 . is_draft AS is_draft_23 , t0 . approval AS approval_24 , t0 . created_at AS created_at_25 , t0 . updated_at AS updated_at_26 , t0 . deleted_at AS deleted_at_27 , t28 . created_at AS created_at_29 , t28 . updated_at AS updated_at_30 , t28 . deleted_at AS deleted_at_31 , t28 . id AS id_32 , t28 . lat AS lat_33 , t28 . lng AS lng_34 , t28 . entry_id AS entry_id_35 , t36 . created_at AS created_at_37 , t36 . updated_at AS updated_at_38 , t36 . deleted_at AS deleted_at_39 , t36 . id AS id_40 , t36 . number AS number_41 , t36 . parson_comment AS parson_comment_42 , t36 . parson_comment_en AS parson_comment_en_43 , t36 . parson_comment_cn AS parson_comment_cn_44 , t36 . parson_comment_tw AS parson_comment_tw_45 , t36 . inquiry_name AS inquiry_name_46 , t36 . inquiry_name_en AS inquiry_name_en_47 , t36 . inquiry_name_cn AS inquiry_name_cn_48 , t36 . inquiry_name_tw AS inquiry_name_tw_49 , t36 . inquiry_phone AS inquiry_phone_50 , t36 . inquiry_url AS inquiry_url_51 , t36 . inquiry_remark AS inquiry_remark_52 , t36 . inquiry_remark_en AS inquiry_remark_en_53 , t36 . inquiry_remark_cn AS inquiry_remark_cn_54 , t36 . inquiry_remark_tw AS inquiry_remark_tw_55 , t36 . is_recommend AS is_recommend_56 , t36 . entry_id AS entry_id_57 , t36 . parson_id AS parson_id_58 , t59 . created_at AS created_at_60 , t59 . updated_at AS updated_at_61 , t59 . deleted_at AS deleted_at_62 , t59 . id AS id_63 , t59 . description AS description_64 , t59 . postal AS postal_65 , t59 . address AS address_66 , t59 . phone AS phone_67 , t59 . business_time AS business_time_68 , t59 . parking AS parking_69 , t59 . website AS website_70 , t59 . transportation AS transportation_71 , t59 . description_en AS description_en_72 , t59 . description_cn AS description_cn_73 , t59 . description_tw AS description_tw_74 , t59 . address_en AS address_en_75 , t59 . address_cn AS address_cn_76 , t59 . address_tw AS address_tw_77 , t59 . business_time_en AS business_time_en_78 , t59 . business_time_cn AS business_time_cn_79 , t59 . business_time_tw AS business_time_tw_80 , t59 . parking_en AS parking_en_81 , t59 . parking_cn AS parking_cn_82 , t59 . parking_tw AS parking_tw_83 , t59 . transportation_en AS transportation_en_84 , t59 . transportation_cn AS transportation_cn_85 , t59 . transportation_tw AS transportation_tw_86 , t59 . life_summary AS life_summary_87 , t59 . life_summary_en AS life_summary_en_88 , t59 . life_summary_cn AS life_summary_cn_89 , t59 . life_summary_tw AS life_summary_tw_90 , t59 . parson_comment AS parson_comment_91 , t59 . parson_comment_en AS parson_comment_en_92 , t59 . parson_comment_cn AS parson_comment_cn_93 , t59 . parson_comment_tw AS parson_comment_tw_94 , t59 . entry_id AS entry_id_95 , t59 . parson_id AS parson_id_96 , t97 . created_at AS created_at_98 , t97 . updated_at AS updated_at_99 , t97 . deleted_at AS deleted_at_100 , t97 . id AS id_101 , t97 . description AS description_102 , t97 . postal AS postal_103 , t97 . address AS address_104 , t97 . phone AS phone_105 , t97 . business_time AS business_time_106 , t97 . parking AS parking_107 , t97 . website AS website_108 , t97 . transportation AS transportation_109 , t97 . description_en AS description_en_110 , t97 . description_cn AS description_cn_111 , t97 . description_tw AS description_tw_112 , t97 . address_en AS address_en_113 , t97 . address_cn AS address_cn_114 , t97 . address_tw AS address_tw_115 , t97 . business_time_en AS business_time_en_116 , t97 . business_time_cn AS business_time_cn_117 , t97 . business_time_tw AS business_time_tw_118 , t97 . parking_en AS parking_en_119 , t97 . parking_cn AS parking_cn_120 , t97 . parking_tw AS parking_tw_121 , t97 . transportation_en AS transportation_en_122 , t97 . transportation_cn AS transportation_cn_123 , t97 . transportation_tw AS transportation_tw_124 , t97 . life_summary AS life_summary_125 , t97 . life_summary_en AS life_summary_en_126 , t97 . life_summary_cn AS life_summary_cn_127 , t97 . life_summary_tw AS life_summary_tw_128 , t97 . parson_comment AS parson_comment_129 , t97 . parson_comment_en AS parson_comment_en_130 , t97 . parson_comment_cn AS parson_comment_cn_131 , t97 . parson_comment_tw AS parson_comment_tw_132 , t97 . entry_id AS entry_id_133 , t97 . parson_id AS parson_id_134 , t135 . created_at AS created_at_136 , t135 . updated_at AS updated_at_137 , t135 . deleted_at AS deleted_at_138 , t135 . id AS id_139 , t135 . description AS description_140 , t135 . postal AS postal_141 , t135 . address AS address_142 , t135 . phone AS phone_143 , t135 . business_time AS business_time_144 , t135 . parking AS parking_145 , t135 . website AS website_146 , t135 . transportation AS transportation_147 , t135 . description_en AS description_en_148 , t135 . description_cn AS description_cn_149 , t135 . description_tw AS description_tw_150 , t135 . address_en AS address_en_151 , t135 . address_cn AS address_cn_152 , t135 . address_tw AS address_tw_153 , t135 . business_time_en AS business_time_en_154 , t135 . business_time_cn AS business_time_cn_155 , t135 . business_time_tw AS business_time_tw_156 , t135 . parking_en AS parking_en_157 , t135 . parking_cn AS parking_cn_158 , t135 . parking_tw AS parking_tw_159 , t135 . transportation_en AS transportation_en_160 , t135 . transportation_cn AS transportation_cn_161 , t135 . transportation_tw AS transportation_tw_162 , t135 . life_summary AS life_summary_163 , t135 . life_summary_en AS life_summary_en_164 , t135 . life_summary_cn AS life_summary_cn_165 , t135 . life_summary_tw AS life_summary_tw_166 , t135 . parson_comment AS parson_comment_167 , t135 . parson_comment_en AS parson_comment_en_168 , t135 . parson_comment_cn AS parson_comment_cn_169 , t135 . parson_comment_tw AS parson_comment_tw_170 , t135 . entry_id AS entry_id_171 , t135 . parson_id AS parson_id_172 , t0 . slave_entry_id AS slave_entry_id_173 , t0 . owner_id AS owner_id_174 , t0 . area_id AS area_id_175 FROM entry_entry t0 LEFT JOIN entry_geolocation t28 ON t28 . entry_id = t0 . id LEFT JOIN entry_modelplan t36 ON t36 . entry_id = t0 . id LEFT JOIN entry_hotel t59 ON t59 . entry_id = t0 . id LEFT JOIN entry_workspace t97 ON t97 . entry_id = t0 . id LEFT JOIN entry_actibity t135 ON t135 . entry_id = t0 . id WHERE t0 . id = ? AND ((t0 . deleted_at IS NULL ))
SELECT
t0 . id AS id_1 ,
t0 . category AS category_2 ,
t0 . title AS title_3 ,
t0 . main_image AS main_image_4 ,
t0 . thumbnail AS thumbnail_5 ,
t0 . summary_title AS summary_title_6 ,
t0 . summary_content AS summary_content_7 ,
t0 . pickup_content_description AS pickup_content_description_8 ,
t0 . title_en AS title_en_9 ,
t0 . title_cn AS title_cn_10 ,
t0 . summary_title_en AS summary_title_en_11 ,
t0 . summary_title_cn AS summary_title_cn_12 ,
t0 . summary_content_en AS summary_content_en_13 ,
t0 . summary_content_cn AS summary_content_cn_14 ,
t0 . pickup_contents_description_en AS pickup_contents_description_en_15 ,
t0 . pickup_contents_description_cn AS pickup_contents_description_cn_16 ,
t0 . title_tw AS title_tw_17 ,
t0 . summary_title_tw AS summary_title_tw_18 ,
t0 . summary_content_tw AS summary_content_tw_19 ,
t0 . pickup_contents_description_tw AS pickup_contents_description_tw_20 ,
t0 . add_life_experience AS add_life_experience_21 ,
t0 . life_experience_thumbnail AS life_experience_thumbnail_22 ,
t0 . is_draft AS is_draft_23 ,
t0 . approval AS approval_24 ,
t0 . created_at AS created_at_25 ,
t0 . updated_at AS updated_at_26 ,
t0 . deleted_at AS deleted_at_27 ,
t28 . created_at AS created_at_29 ,
t28 . updated_at AS updated_at_30 ,
t28 . deleted_at AS deleted_at_31 ,
t28 . id AS id_32 ,
t28 . lat AS lat_33 ,
t28 . lng AS lng_34 ,
t28 . entry_id AS entry_id_35 ,
t36 . created_at AS created_at_37 ,
t36 . updated_at AS updated_at_38 ,
t36 . deleted_at AS deleted_at_39 ,
t36 . id AS id_40 ,
t36 . number AS number_41 ,
t36 . parson_comment AS parson_comment_42 ,
t36 . parson_comment_en AS parson_comment_en_43 ,
t36 . parson_comment_cn AS parson_comment_cn_44 ,
t36 . parson_comment_tw AS parson_comment_tw_45 ,
t36 . inquiry_name AS inquiry_name_46 ,
t36 . inquiry_name_en AS inquiry_name_en_47 ,
t36 . inquiry_name_cn AS inquiry_name_cn_48 ,
t36 . inquiry_name_tw AS inquiry_name_tw_49 ,
t36 . inquiry_phone AS inquiry_phone_50 ,
t36 . inquiry_url AS inquiry_url_51 ,
t36 . inquiry_remark AS inquiry_remark_52 ,
t36 . inquiry_remark_en AS inquiry_remark_en_53 ,
t36 . inquiry_remark_cn AS inquiry_remark_cn_54 ,
t36 . inquiry_remark_tw AS inquiry_remark_tw_55 ,
t36 . is_recommend AS is_recommend_56 ,
t36 . entry_id AS entry_id_57 ,
t36 . parson_id AS parson_id_58 ,
t59 . created_at AS created_at_60 ,
t59 . updated_at AS updated_at_61 ,
t59 . deleted_at AS deleted_at_62 ,
t59 . id AS id_63 ,
t59 . description AS description_64 ,
t59 . postal AS postal_65 ,
t59 . address AS address_66 ,
t59 . phone AS phone_67 ,
t59 . business_time AS business_time_68 ,
t59 . parking AS parking_69 ,
t59 . website AS website_70 ,
t59 . transportation AS transportation_71 ,
t59 . description_en AS description_en_72 ,
t59 . description_cn AS description_cn_73 ,
t59 . description_tw AS description_tw_74 ,
t59 . address_en AS address_en_75 ,
t59 . address_cn AS address_cn_76 ,
t59 . address_tw AS address_tw_77 ,
t59 . business_time_en AS business_time_en_78 ,
t59 . business_time_cn AS business_time_cn_79 ,
t59 . business_time_tw AS business_time_tw_80 ,
t59 . parking_en AS parking_en_81 ,
t59 . parking_cn AS parking_cn_82 ,
t59 . parking_tw AS parking_tw_83 ,
t59 . transportation_en AS transportation_en_84 ,
t59 . transportation_cn AS transportation_cn_85 ,
t59 . transportation_tw AS transportation_tw_86 ,
t59 . life_summary AS life_summary_87 ,
t59 . life_summary_en AS life_summary_en_88 ,
t59 . life_summary_cn AS life_summary_cn_89 ,
t59 . life_summary_tw AS life_summary_tw_90 ,
t59 . parson_comment AS parson_comment_91 ,
t59 . parson_comment_en AS parson_comment_en_92 ,
t59 . parson_comment_cn AS parson_comment_cn_93 ,
t59 . parson_comment_tw AS parson_comment_tw_94 ,
t59 . entry_id AS entry_id_95 ,
t59 . parson_id AS parson_id_96 ,
t97 . created_at AS created_at_98 ,
t97 . updated_at AS updated_at_99 ,
t97 . deleted_at AS deleted_at_100 ,
t97 . id AS id_101 ,
t97 . description AS description_102 ,
t97 . postal AS postal_103 ,
t97 . address AS address_104 ,
t97 . phone AS phone_105 ,
t97 . business_time AS business_time_106 ,
t97 . parking AS parking_107 ,
t97 . website AS website_108 ,
t97 . transportation AS transportation_109 ,
t97 . description_en AS description_en_110 ,
t97 . description_cn AS description_cn_111 ,
t97 . description_tw AS description_tw_112 ,
t97 . address_en AS address_en_113 ,
t97 . address_cn AS address_cn_114 ,
t97 . address_tw AS address_tw_115 ,
t97 . business_time_en AS business_time_en_116 ,
t97 . business_time_cn AS business_time_cn_117 ,
t97 . business_time_tw AS business_time_tw_118 ,
t97 . parking_en AS parking_en_119 ,
t97 . parking_cn AS parking_cn_120 ,
t97 . parking_tw AS parking_tw_121 ,
t97 . transportation_en AS transportation_en_122 ,
t97 . transportation_cn AS transportation_cn_123 ,
t97 . transportation_tw AS transportation_tw_124 ,
t97 . life_summary AS life_summary_125 ,
t97 . life_summary_en AS life_summary_en_126 ,
t97 . life_summary_cn AS life_summary_cn_127 ,
t97 . life_summary_tw AS life_summary_tw_128 ,
t97 . parson_comment AS parson_comment_129 ,
t97 . parson_comment_en AS parson_comment_en_130 ,
t97 . parson_comment_cn AS parson_comment_cn_131 ,
t97 . parson_comment_tw AS parson_comment_tw_132 ,
t97 . entry_id AS entry_id_133 ,
t97 . parson_id AS parson_id_134 ,
t135 . created_at AS created_at_136 ,
t135 . updated_at AS updated_at_137 ,
t135 . deleted_at AS deleted_at_138 ,
t135 . id AS id_139 ,
t135 . description AS description_140 ,
t135 . postal AS postal_141 ,
t135 . address AS address_142 ,
t135 . phone AS phone_143 ,
t135 . business_time AS business_time_144 ,
t135 . parking AS parking_145 ,
t135 . website AS website_146 ,
t135 . transportation AS transportation_147 ,
t135 . description_en AS description_en_148 ,
t135 . description_cn AS description_cn_149 ,
t135 . description_tw AS description_tw_150 ,
t135 . address_en AS address_en_151 ,
t135 . address_cn AS address_cn_152 ,
t135 . address_tw AS address_tw_153 ,
t135 . business_time_en AS business_time_en_154 ,
t135 . business_time_cn AS business_time_cn_155 ,
t135 . business_time_tw AS business_time_tw_156 ,
t135 . parking_en AS parking_en_157 ,
t135 . parking_cn AS parking_cn_158 ,
t135 . parking_tw AS parking_tw_159 ,
t135 . transportation_en AS transportation_en_160 ,
t135 . transportation_cn AS transportation_cn_161 ,
t135 . transportation_tw AS transportation_tw_162 ,
t135 . life_summary AS life_summary_163 ,
t135 . life_summary_en AS life_summary_en_164 ,
t135 . life_summary_cn AS life_summary_cn_165 ,
t135 . life_summary_tw AS life_summary_tw_166 ,
t135 . parson_comment AS parson_comment_167 ,
t135 . parson_comment_en AS parson_comment_en_168 ,
t135 . parson_comment_cn AS parson_comment_cn_169 ,
t135 . parson_comment_tw AS parson_comment_tw_170 ,
t135 . entry_id AS entry_id_171 ,
t135 . parson_id AS parson_id_172 ,
t0 . slave_entry_id AS slave_entry_id_173 ,
t0 . owner_id AS owner_id_174 ,
t0 . area_id AS area_id_175
FROM
entry_entry t0
LEFT JOIN entry_geolocation t28 ON t28 . entry_id = t0 . id
LEFT JOIN entry_modelplan t36 ON t36 . entry_id = t0 . id
LEFT JOIN entry_hotel t59 ON t59 . entry_id = t0 . id
LEFT JOIN entry_workspace t97 ON t97 . entry_id = t0 . id
LEFT JOIN entry_actibity t135 ON t135 . entry_id = t0 . id
WHERE
t0 . id = ?
AND (
(t0 . deleted_at IS NULL )
)Copy
SELECT t0 . id AS id_1 , t0 . category AS category_2 , t0 . title AS title_3 , t0 . main_image AS main_image_4 , t0 . thumbnail AS thumbnail_5 , t0 . summary_title AS summary_title_6 , t0 . summary_content AS summary_content_7 , t0 . pickup_content_description AS pickup_content_description_8 , t0 . title_en AS title_en_9 , t0 . title_cn AS title_cn_10 , t0 . summary_title_en AS summary_title_en_11 , t0 . summary_title_cn AS summary_title_cn_12 , t0 . summary_content_en AS summary_content_en_13 , t0 . summary_content_cn AS summary_content_cn_14 , t0 . pickup_contents_description_en AS pickup_contents_description_en_15 , t0 . pickup_contents_description_cn AS pickup_contents_description_cn_16 , t0 . title_tw AS title_tw_17 , t0 . summary_title_tw AS summary_title_tw_18 , t0 . summary_content_tw AS summary_content_tw_19 , t0 . pickup_contents_description_tw AS pickup_contents_description_tw_20 , t0 . add_life_experience AS add_life_experience_21 , t0 . life_experience_thumbnail AS life_experience_thumbnail_22 , t0 . is_draft AS is_draft_23 , t0 . approval AS approval_24 , t0 . created_at AS created_at_25 , t0 . updated_at AS updated_at_26 , t0 . deleted_at AS deleted_at_27 , t28 . created_at AS created_at_29 , t28 . updated_at AS updated_at_30 , t28 . deleted_at AS deleted_at_31 , t28 . id AS id_32 , t28 . lat AS lat_33 , t28 . lng AS lng_34 , t28 . entry_id AS entry_id_35 , t36 . created_at AS created_at_37 , t36 . updated_at AS updated_at_38 , t36 . deleted_at AS deleted_at_39 , t36 . id AS id_40 , t36 . number AS number_41 , t36 . parson_comment AS parson_comment_42 , t36 . parson_comment_en AS parson_comment_en_43 , t36 . parson_comment_cn AS parson_comment_cn_44 , t36 . parson_comment_tw AS parson_comment_tw_45 , t36 . inquiry_name AS inquiry_name_46 , t36 . inquiry_name_en AS inquiry_name_en_47 , t36 . inquiry_name_cn AS inquiry_name_cn_48 , t36 . inquiry_name_tw AS inquiry_name_tw_49 , t36 . inquiry_phone AS inquiry_phone_50 , t36 . inquiry_url AS inquiry_url_51 , t36 . inquiry_remark AS inquiry_remark_52 , t36 . inquiry_remark_en AS inquiry_remark_en_53 , t36 . inquiry_remark_cn AS inquiry_remark_cn_54 , t36 . inquiry_remark_tw AS inquiry_remark_tw_55 , t36 . is_recommend AS is_recommend_56 , t36 . entry_id AS entry_id_57 , t36 . parson_id AS parson_id_58 , t59 . created_at AS created_at_60 , t59 . updated_at AS updated_at_61 , t59 . deleted_at AS deleted_at_62 , t59 . id AS id_63 , t59 . description AS description_64 , t59 . postal AS postal_65 , t59 . address AS address_66 , t59 . phone AS phone_67 , t59 . business_time AS business_time_68 , t59 . parking AS parking_69 , t59 . website AS website_70 , t59 . transportation AS transportation_71 , t59 . description_en AS description_en_72 , t59 . description_cn AS description_cn_73 , t59 . description_tw AS description_tw_74 , t59 . address_en AS address_en_75 , t59 . address_cn AS address_cn_76 , t59 . address_tw AS address_tw_77 , t59 . business_time_en AS business_time_en_78 , t59 . business_time_cn AS business_time_cn_79 , t59 . business_time_tw AS business_time_tw_80 , t59 . parking_en AS parking_en_81 , t59 . parking_cn AS parking_cn_82 , t59 . parking_tw AS parking_tw_83 , t59 . transportation_en AS transportation_en_84 , t59 . transportation_cn AS transportation_cn_85 , t59 . transportation_tw AS transportation_tw_86 , t59 . life_summary AS life_summary_87 , t59 . life_summary_en AS life_summary_en_88 , t59 . life_summary_cn AS life_summary_cn_89 , t59 . life_summary_tw AS life_summary_tw_90 , t59 . parson_comment AS parson_comment_91 , t59 . parson_comment_en AS parson_comment_en_92 , t59 . parson_comment_cn AS parson_comment_cn_93 , t59 . parson_comment_tw AS parson_comment_tw_94 , t59 . entry_id AS entry_id_95 , t59 . parson_id AS parson_id_96 , t97 . created_at AS created_at_98 , t97 . updated_at AS updated_at_99 , t97 . deleted_at AS deleted_at_100 , t97 . id AS id_101 , t97 . description AS description_102 , t97 . postal AS postal_103 , t97 . address AS address_104 , t97 . phone AS phone_105 , t97 . business_time AS business_time_106 , t97 . parking AS parking_107 , t97 . website AS website_108 , t97 . transportation AS transportation_109 , t97 . description_en AS description_en_110 , t97 . description_cn AS description_cn_111 , t97 . description_tw AS description_tw_112 , t97 . address_en AS address_en_113 , t97 . address_cn AS address_cn_114 , t97 . address_tw AS address_tw_115 , t97 . business_time_en AS business_time_en_116 , t97 . business_time_cn AS business_time_cn_117 , t97 . business_time_tw AS business_time_tw_118 , t97 . parking_en AS parking_en_119 , t97 . parking_cn AS parking_cn_120 , t97 . parking_tw AS parking_tw_121 , t97 . transportation_en AS transportation_en_122 , t97 . transportation_cn AS transportation_cn_123 , t97 . transportation_tw AS transportation_tw_124 , t97 . life_summary AS life_summary_125 , t97 . life_summary_en AS life_summary_en_126 , t97 . life_summary_cn AS life_summary_cn_127 , t97 . life_summary_tw AS life_summary_tw_128 , t97 . parson_comment AS parson_comment_129 , t97 . parson_comment_en AS parson_comment_en_130 , t97 . parson_comment_cn AS parson_comment_cn_131 , t97 . parson_comment_tw AS parson_comment_tw_132 , t97 . entry_id AS entry_id_133 , t97 . parson_id AS parson_id_134 , t135 . created_at AS created_at_136 , t135 . updated_at AS updated_at_137 , t135 . deleted_at AS deleted_at_138 , t135 . id AS id_139 , t135 . description AS description_140 , t135 . postal AS postal_141 , t135 . address AS address_142 , t135 . phone AS phone_143 , t135 . business_time AS business_time_144 , t135 . parking AS parking_145 , t135 . website AS website_146 , t135 . transportation AS transportation_147 , t135 . description_en AS description_en_148 , t135 . description_cn AS description_cn_149 , t135 . description_tw AS description_tw_150 , t135 . address_en AS address_en_151 , t135 . address_cn AS address_cn_152 , t135 . address_tw AS address_tw_153 , t135 . business_time_en AS business_time_en_154 , t135 . business_time_cn AS business_time_cn_155 , t135 . business_time_tw AS business_time_tw_156 , t135 . parking_en AS parking_en_157 , t135 . parking_cn AS parking_cn_158 , t135 . parking_tw AS parking_tw_159 , t135 . transportation_en AS transportation_en_160 , t135 . transportation_cn AS transportation_cn_161 , t135 . transportation_tw AS transportation_tw_162 , t135 . life_summary AS life_summary_163 , t135 . life_summary_en AS life_summary_en_164 , t135 . life_summary_cn AS life_summary_cn_165 , t135 . life_summary_tw AS life_summary_tw_166 , t135 . parson_comment AS parson_comment_167 , t135 . parson_comment_en AS parson_comment_en_168 , t135 . parson_comment_cn AS parson_comment_cn_169 , t135 . parson_comment_tw AS parson_comment_tw_170 , t135 . entry_id AS entry_id_171 , t135 . parson_id AS parson_id_172 , t0 . slave_entry_id AS slave_entry_id_173 , t0 . owner_id AS owner_id_174 , t0 . area_id AS area_id_175 FROM entry_entry t0 LEFT JOIN entry_geolocation t28 ON t28 . entry_id = t0 . id LEFT JOIN entry_modelplan t36 ON t36 . entry_id = t0 . id LEFT JOIN entry_hotel t59 ON t59 . entry_id = t0 . id LEFT JOIN entry_workspace t97 ON t97 . entry_id = t0 . id LEFT JOIN entry_actibity t135 ON t135 . entry_id = t0 . id WHERE t0 . id = 16 AND ((t0 . deleted_at IS NULL )); Copy
5
0.69 ms
SELECT t0 . id AS id_1 , t0 . category AS category_2 , t0 . title AS title_3 , t0 . main_image AS main_image_4 , t0 . thumbnail AS thumbnail_5 , t0 . summary_title AS summary_title_6 , t0 . summary_content AS summary_content_7 , t0 . pickup_content_description AS pickup_content_description_8 , t0 . title_en AS title_en_9 , t0 . title_cn AS title_cn_10 , t0 . summary_title_en AS summary_title_en_11 , t0 . summary_title_cn AS summary_title_cn_12 , t0 . summary_content_en AS summary_content_en_13 , t0 . summary_content_cn AS summary_content_cn_14 , t0 . pickup_contents_description_en AS pickup_contents_description_en_15 , t0 . pickup_contents_description_cn AS pickup_contents_description_cn_16 , t0 . title_tw AS title_tw_17 , t0 . summary_title_tw AS summary_title_tw_18 , t0 . summary_content_tw AS summary_content_tw_19 , t0 . pickup_contents_description_tw AS pickup_contents_description_tw_20 , t0 . add_life_experience AS add_life_experience_21 , t0 . life_experience_thumbnail AS life_experience_thumbnail_22 , t0 . is_draft AS is_draft_23 , t0 . approval AS approval_24 , t0 . created_at AS created_at_25 , t0 . updated_at AS updated_at_26 , t0 . deleted_at AS deleted_at_27 , t28 . created_at AS created_at_29 , t28 . updated_at AS updated_at_30 , t28 . deleted_at AS deleted_at_31 , t28 . id AS id_32 , t28 . lat AS lat_33 , t28 . lng AS lng_34 , t28 . entry_id AS entry_id_35 , t36 . created_at AS created_at_37 , t36 . updated_at AS updated_at_38 , t36 . deleted_at AS deleted_at_39 , t36 . id AS id_40 , t36 . number AS number_41 , t36 . parson_comment AS parson_comment_42 , t36 . parson_comment_en AS parson_comment_en_43 , t36 . parson_comment_cn AS parson_comment_cn_44 , t36 . parson_comment_tw AS parson_comment_tw_45 , t36 . inquiry_name AS inquiry_name_46 , t36 . inquiry_name_en AS inquiry_name_en_47 , t36 . inquiry_name_cn AS inquiry_name_cn_48 , t36 . inquiry_name_tw AS inquiry_name_tw_49 , t36 . inquiry_phone AS inquiry_phone_50 , t36 . inquiry_url AS inquiry_url_51 , t36 . inquiry_remark AS inquiry_remark_52 , t36 . inquiry_remark_en AS inquiry_remark_en_53 , t36 . inquiry_remark_cn AS inquiry_remark_cn_54 , t36 . inquiry_remark_tw AS inquiry_remark_tw_55 , t36 . is_recommend AS is_recommend_56 , t36 . entry_id AS entry_id_57 , t36 . parson_id AS parson_id_58 , t59 . created_at AS created_at_60 , t59 . updated_at AS updated_at_61 , t59 . deleted_at AS deleted_at_62 , t59 . id AS id_63 , t59 . description AS description_64 , t59 . postal AS postal_65 , t59 . address AS address_66 , t59 . phone AS phone_67 , t59 . business_time AS business_time_68 , t59 . parking AS parking_69 , t59 . website AS website_70 , t59 . transportation AS transportation_71 , t59 . description_en AS description_en_72 , t59 . description_cn AS description_cn_73 , t59 . description_tw AS description_tw_74 , t59 . address_en AS address_en_75 , t59 . address_cn AS address_cn_76 , t59 . address_tw AS address_tw_77 , t59 . business_time_en AS business_time_en_78 , t59 . business_time_cn AS business_time_cn_79 , t59 . business_time_tw AS business_time_tw_80 , t59 . parking_en AS parking_en_81 , t59 . parking_cn AS parking_cn_82 , t59 . parking_tw AS parking_tw_83 , t59 . transportation_en AS transportation_en_84 , t59 . transportation_cn AS transportation_cn_85 , t59 . transportation_tw AS transportation_tw_86 , t59 . life_summary AS life_summary_87 , t59 . life_summary_en AS life_summary_en_88 , t59 . life_summary_cn AS life_summary_cn_89 , t59 . life_summary_tw AS life_summary_tw_90 , t59 . parson_comment AS parson_comment_91 , t59 . parson_comment_en AS parson_comment_en_92 , t59 . parson_comment_cn AS parson_comment_cn_93 , t59 . parson_comment_tw AS parson_comment_tw_94 , t59 . entry_id AS entry_id_95 , t59 . parson_id AS parson_id_96 , t97 . created_at AS created_at_98 , t97 . updated_at AS updated_at_99 , t97 . deleted_at AS deleted_at_100 , t97 . id AS id_101 , t97 . description AS description_102 , t97 . postal AS postal_103 , t97 . address AS address_104 , t97 . phone AS phone_105 , t97 . business_time AS business_time_106 , t97 . parking AS parking_107 , t97 . website AS website_108 , t97 . transportation AS transportation_109 , t97 . description_en AS description_en_110 , t97 . description_cn AS description_cn_111 , t97 . description_tw AS description_tw_112 , t97 . address_en AS address_en_113 , t97 . address_cn AS address_cn_114 , t97 . address_tw AS address_tw_115 , t97 . business_time_en AS business_time_en_116 , t97 . business_time_cn AS business_time_cn_117 , t97 . business_time_tw AS business_time_tw_118 , t97 . parking_en AS parking_en_119 , t97 . parking_cn AS parking_cn_120 , t97 . parking_tw AS parking_tw_121 , t97 . transportation_en AS transportation_en_122 , t97 . transportation_cn AS transportation_cn_123 , t97 . transportation_tw AS transportation_tw_124 , t97 . life_summary AS life_summary_125 , t97 . life_summary_en AS life_summary_en_126 , t97 . life_summary_cn AS life_summary_cn_127 , t97 . life_summary_tw AS life_summary_tw_128 , t97 . parson_comment AS parson_comment_129 , t97 . parson_comment_en AS parson_comment_en_130 , t97 . parson_comment_cn AS parson_comment_cn_131 , t97 . parson_comment_tw AS parson_comment_tw_132 , t97 . entry_id AS entry_id_133 , t97 . parson_id AS parson_id_134 , t135 . created_at AS created_at_136 , t135 . updated_at AS updated_at_137 , t135 . deleted_at AS deleted_at_138 , t135 . id AS id_139 , t135 . description AS description_140 , t135 . postal AS postal_141 , t135 . address AS address_142 , t135 . phone AS phone_143 , t135 . business_time AS business_time_144 , t135 . parking AS parking_145 , t135 . website AS website_146 , t135 . transportation AS transportation_147 , t135 . description_en AS description_en_148 , t135 . description_cn AS description_cn_149 , t135 . description_tw AS description_tw_150 , t135 . address_en AS address_en_151 , t135 . address_cn AS address_cn_152 , t135 . address_tw AS address_tw_153 , t135 . business_time_en AS business_time_en_154 , t135 . business_time_cn AS business_time_cn_155 , t135 . business_time_tw AS business_time_tw_156 , t135 . parking_en AS parking_en_157 , t135 . parking_cn AS parking_cn_158 , t135 . parking_tw AS parking_tw_159 , t135 . transportation_en AS transportation_en_160 , t135 . transportation_cn AS transportation_cn_161 , t135 . transportation_tw AS transportation_tw_162 , t135 . life_summary AS life_summary_163 , t135 . life_summary_en AS life_summary_en_164 , t135 . life_summary_cn AS life_summary_cn_165 , t135 . life_summary_tw AS life_summary_tw_166 , t135 . parson_comment AS parson_comment_167 , t135 . parson_comment_en AS parson_comment_en_168 , t135 . parson_comment_cn AS parson_comment_cn_169 , t135 . parson_comment_tw AS parson_comment_tw_170 , t135 . entry_id AS entry_id_171 , t135 . parson_id AS parson_id_172 , t0 . slave_entry_id AS slave_entry_id_173 , t0 . owner_id AS owner_id_174 , t0 . area_id AS area_id_175 FROM entry_entry t0 LEFT JOIN entry_geolocation t28 ON t28 . entry_id = t0 . id LEFT JOIN entry_modelplan t36 ON t36 . entry_id = t0 . id LEFT JOIN entry_hotel t59 ON t59 . entry_id = t0 . id LEFT JOIN entry_workspace t97 ON t97 . entry_id = t0 . id LEFT JOIN entry_actibity t135 ON t135 . entry_id = t0 . id WHERE t0 . id = ? AND ((t0 . deleted_at IS NULL ))
SELECT
t0 . id AS id_1 ,
t0 . category AS category_2 ,
t0 . title AS title_3 ,
t0 . main_image AS main_image_4 ,
t0 . thumbnail AS thumbnail_5 ,
t0 . summary_title AS summary_title_6 ,
t0 . summary_content AS summary_content_7 ,
t0 . pickup_content_description AS pickup_content_description_8 ,
t0 . title_en AS title_en_9 ,
t0 . title_cn AS title_cn_10 ,
t0 . summary_title_en AS summary_title_en_11 ,
t0 . summary_title_cn AS summary_title_cn_12 ,
t0 . summary_content_en AS summary_content_en_13 ,
t0 . summary_content_cn AS summary_content_cn_14 ,
t0 . pickup_contents_description_en AS pickup_contents_description_en_15 ,
t0 . pickup_contents_description_cn AS pickup_contents_description_cn_16 ,
t0 . title_tw AS title_tw_17 ,
t0 . summary_title_tw AS summary_title_tw_18 ,
t0 . summary_content_tw AS summary_content_tw_19 ,
t0 . pickup_contents_description_tw AS pickup_contents_description_tw_20 ,
t0 . add_life_experience AS add_life_experience_21 ,
t0 . life_experience_thumbnail AS life_experience_thumbnail_22 ,
t0 . is_draft AS is_draft_23 ,
t0 . approval AS approval_24 ,
t0 . created_at AS created_at_25 ,
t0 . updated_at AS updated_at_26 ,
t0 . deleted_at AS deleted_at_27 ,
t28 . created_at AS created_at_29 ,
t28 . updated_at AS updated_at_30 ,
t28 . deleted_at AS deleted_at_31 ,
t28 . id AS id_32 ,
t28 . lat AS lat_33 ,
t28 . lng AS lng_34 ,
t28 . entry_id AS entry_id_35 ,
t36 . created_at AS created_at_37 ,
t36 . updated_at AS updated_at_38 ,
t36 . deleted_at AS deleted_at_39 ,
t36 . id AS id_40 ,
t36 . number AS number_41 ,
t36 . parson_comment AS parson_comment_42 ,
t36 . parson_comment_en AS parson_comment_en_43 ,
t36 . parson_comment_cn AS parson_comment_cn_44 ,
t36 . parson_comment_tw AS parson_comment_tw_45 ,
t36 . inquiry_name AS inquiry_name_46 ,
t36 . inquiry_name_en AS inquiry_name_en_47 ,
t36 . inquiry_name_cn AS inquiry_name_cn_48 ,
t36 . inquiry_name_tw AS inquiry_name_tw_49 ,
t36 . inquiry_phone AS inquiry_phone_50 ,
t36 . inquiry_url AS inquiry_url_51 ,
t36 . inquiry_remark AS inquiry_remark_52 ,
t36 . inquiry_remark_en AS inquiry_remark_en_53 ,
t36 . inquiry_remark_cn AS inquiry_remark_cn_54 ,
t36 . inquiry_remark_tw AS inquiry_remark_tw_55 ,
t36 . is_recommend AS is_recommend_56 ,
t36 . entry_id AS entry_id_57 ,
t36 . parson_id AS parson_id_58 ,
t59 . created_at AS created_at_60 ,
t59 . updated_at AS updated_at_61 ,
t59 . deleted_at AS deleted_at_62 ,
t59 . id AS id_63 ,
t59 . description AS description_64 ,
t59 . postal AS postal_65 ,
t59 . address AS address_66 ,
t59 . phone AS phone_67 ,
t59 . business_time AS business_time_68 ,
t59 . parking AS parking_69 ,
t59 . website AS website_70 ,
t59 . transportation AS transportation_71 ,
t59 . description_en AS description_en_72 ,
t59 . description_cn AS description_cn_73 ,
t59 . description_tw AS description_tw_74 ,
t59 . address_en AS address_en_75 ,
t59 . address_cn AS address_cn_76 ,
t59 . address_tw AS address_tw_77 ,
t59 . business_time_en AS business_time_en_78 ,
t59 . business_time_cn AS business_time_cn_79 ,
t59 . business_time_tw AS business_time_tw_80 ,
t59 . parking_en AS parking_en_81 ,
t59 . parking_cn AS parking_cn_82 ,
t59 . parking_tw AS parking_tw_83 ,
t59 . transportation_en AS transportation_en_84 ,
t59 . transportation_cn AS transportation_cn_85 ,
t59 . transportation_tw AS transportation_tw_86 ,
t59 . life_summary AS life_summary_87 ,
t59 . life_summary_en AS life_summary_en_88 ,
t59 . life_summary_cn AS life_summary_cn_89 ,
t59 . life_summary_tw AS life_summary_tw_90 ,
t59 . parson_comment AS parson_comment_91 ,
t59 . parson_comment_en AS parson_comment_en_92 ,
t59 . parson_comment_cn AS parson_comment_cn_93 ,
t59 . parson_comment_tw AS parson_comment_tw_94 ,
t59 . entry_id AS entry_id_95 ,
t59 . parson_id AS parson_id_96 ,
t97 . created_at AS created_at_98 ,
t97 . updated_at AS updated_at_99 ,
t97 . deleted_at AS deleted_at_100 ,
t97 . id AS id_101 ,
t97 . description AS description_102 ,
t97 . postal AS postal_103 ,
t97 . address AS address_104 ,
t97 . phone AS phone_105 ,
t97 . business_time AS business_time_106 ,
t97 . parking AS parking_107 ,
t97 . website AS website_108 ,
t97 . transportation AS transportation_109 ,
t97 . description_en AS description_en_110 ,
t97 . description_cn AS description_cn_111 ,
t97 . description_tw AS description_tw_112 ,
t97 . address_en AS address_en_113 ,
t97 . address_cn AS address_cn_114 ,
t97 . address_tw AS address_tw_115 ,
t97 . business_time_en AS business_time_en_116 ,
t97 . business_time_cn AS business_time_cn_117 ,
t97 . business_time_tw AS business_time_tw_118 ,
t97 . parking_en AS parking_en_119 ,
t97 . parking_cn AS parking_cn_120 ,
t97 . parking_tw AS parking_tw_121 ,
t97 . transportation_en AS transportation_en_122 ,
t97 . transportation_cn AS transportation_cn_123 ,
t97 . transportation_tw AS transportation_tw_124 ,
t97 . life_summary AS life_summary_125 ,
t97 . life_summary_en AS life_summary_en_126 ,
t97 . life_summary_cn AS life_summary_cn_127 ,
t97 . life_summary_tw AS life_summary_tw_128 ,
t97 . parson_comment AS parson_comment_129 ,
t97 . parson_comment_en AS parson_comment_en_130 ,
t97 . parson_comment_cn AS parson_comment_cn_131 ,
t97 . parson_comment_tw AS parson_comment_tw_132 ,
t97 . entry_id AS entry_id_133 ,
t97 . parson_id AS parson_id_134 ,
t135 . created_at AS created_at_136 ,
t135 . updated_at AS updated_at_137 ,
t135 . deleted_at AS deleted_at_138 ,
t135 . id AS id_139 ,
t135 . description AS description_140 ,
t135 . postal AS postal_141 ,
t135 . address AS address_142 ,
t135 . phone AS phone_143 ,
t135 . business_time AS business_time_144 ,
t135 . parking AS parking_145 ,
t135 . website AS website_146 ,
t135 . transportation AS transportation_147 ,
t135 . description_en AS description_en_148 ,
t135 . description_cn AS description_cn_149 ,
t135 . description_tw AS description_tw_150 ,
t135 . address_en AS address_en_151 ,
t135 . address_cn AS address_cn_152 ,
t135 . address_tw AS address_tw_153 ,
t135 . business_time_en AS business_time_en_154 ,
t135 . business_time_cn AS business_time_cn_155 ,
t135 . business_time_tw AS business_time_tw_156 ,
t135 . parking_en AS parking_en_157 ,
t135 . parking_cn AS parking_cn_158 ,
t135 . parking_tw AS parking_tw_159 ,
t135 . transportation_en AS transportation_en_160 ,
t135 . transportation_cn AS transportation_cn_161 ,
t135 . transportation_tw AS transportation_tw_162 ,
t135 . life_summary AS life_summary_163 ,
t135 . life_summary_en AS life_summary_en_164 ,
t135 . life_summary_cn AS life_summary_cn_165 ,
t135 . life_summary_tw AS life_summary_tw_166 ,
t135 . parson_comment AS parson_comment_167 ,
t135 . parson_comment_en AS parson_comment_en_168 ,
t135 . parson_comment_cn AS parson_comment_cn_169 ,
t135 . parson_comment_tw AS parson_comment_tw_170 ,
t135 . entry_id AS entry_id_171 ,
t135 . parson_id AS parson_id_172 ,
t0 . slave_entry_id AS slave_entry_id_173 ,
t0 . owner_id AS owner_id_174 ,
t0 . area_id AS area_id_175
FROM
entry_entry t0
LEFT JOIN entry_geolocation t28 ON t28 . entry_id = t0 . id
LEFT JOIN entry_modelplan t36 ON t36 . entry_id = t0 . id
LEFT JOIN entry_hotel t59 ON t59 . entry_id = t0 . id
LEFT JOIN entry_workspace t97 ON t97 . entry_id = t0 . id
LEFT JOIN entry_actibity t135 ON t135 . entry_id = t0 . id
WHERE
t0 . id = ?
AND (
(t0 . deleted_at IS NULL )
)Copy
SELECT t0 . id AS id_1 , t0 . category AS category_2 , t0 . title AS title_3 , t0 . main_image AS main_image_4 , t0 . thumbnail AS thumbnail_5 , t0 . summary_title AS summary_title_6 , t0 . summary_content AS summary_content_7 , t0 . pickup_content_description AS pickup_content_description_8 , t0 . title_en AS title_en_9 , t0 . title_cn AS title_cn_10 , t0 . summary_title_en AS summary_title_en_11 , t0 . summary_title_cn AS summary_title_cn_12 , t0 . summary_content_en AS summary_content_en_13 , t0 . summary_content_cn AS summary_content_cn_14 , t0 . pickup_contents_description_en AS pickup_contents_description_en_15 , t0 . pickup_contents_description_cn AS pickup_contents_description_cn_16 , t0 . title_tw AS title_tw_17 , t0 . summary_title_tw AS summary_title_tw_18 , t0 . summary_content_tw AS summary_content_tw_19 , t0 . pickup_contents_description_tw AS pickup_contents_description_tw_20 , t0 . add_life_experience AS add_life_experience_21 , t0 . life_experience_thumbnail AS life_experience_thumbnail_22 , t0 . is_draft AS is_draft_23 , t0 . approval AS approval_24 , t0 . created_at AS created_at_25 , t0 . updated_at AS updated_at_26 , t0 . deleted_at AS deleted_at_27 , t28 . created_at AS created_at_29 , t28 . updated_at AS updated_at_30 , t28 . deleted_at AS deleted_at_31 , t28 . id AS id_32 , t28 . lat AS lat_33 , t28 . lng AS lng_34 , t28 . entry_id AS entry_id_35 , t36 . created_at AS created_at_37 , t36 . updated_at AS updated_at_38 , t36 . deleted_at AS deleted_at_39 , t36 . id AS id_40 , t36 . number AS number_41 , t36 . parson_comment AS parson_comment_42 , t36 . parson_comment_en AS parson_comment_en_43 , t36 . parson_comment_cn AS parson_comment_cn_44 , t36 . parson_comment_tw AS parson_comment_tw_45 , t36 . inquiry_name AS inquiry_name_46 , t36 . inquiry_name_en AS inquiry_name_en_47 , t36 . inquiry_name_cn AS inquiry_name_cn_48 , t36 . inquiry_name_tw AS inquiry_name_tw_49 , t36 . inquiry_phone AS inquiry_phone_50 , t36 . inquiry_url AS inquiry_url_51 , t36 . inquiry_remark AS inquiry_remark_52 , t36 . inquiry_remark_en AS inquiry_remark_en_53 , t36 . inquiry_remark_cn AS inquiry_remark_cn_54 , t36 . inquiry_remark_tw AS inquiry_remark_tw_55 , t36 . is_recommend AS is_recommend_56 , t36 . entry_id AS entry_id_57 , t36 . parson_id AS parson_id_58 , t59 . created_at AS created_at_60 , t59 . updated_at AS updated_at_61 , t59 . deleted_at AS deleted_at_62 , t59 . id AS id_63 , t59 . description AS description_64 , t59 . postal AS postal_65 , t59 . address AS address_66 , t59 . phone AS phone_67 , t59 . business_time AS business_time_68 , t59 . parking AS parking_69 , t59 . website AS website_70 , t59 . transportation AS transportation_71 , t59 . description_en AS description_en_72 , t59 . description_cn AS description_cn_73 , t59 . description_tw AS description_tw_74 , t59 . address_en AS address_en_75 , t59 . address_cn AS address_cn_76 , t59 . address_tw AS address_tw_77 , t59 . business_time_en AS business_time_en_78 , t59 . business_time_cn AS business_time_cn_79 , t59 . business_time_tw AS business_time_tw_80 , t59 . parking_en AS parking_en_81 , t59 . parking_cn AS parking_cn_82 , t59 . parking_tw AS parking_tw_83 , t59 . transportation_en AS transportation_en_84 , t59 . transportation_cn AS transportation_cn_85 , t59 . transportation_tw AS transportation_tw_86 , t59 . life_summary AS life_summary_87 , t59 . life_summary_en AS life_summary_en_88 , t59 . life_summary_cn AS life_summary_cn_89 , t59 . life_summary_tw AS life_summary_tw_90 , t59 . parson_comment AS parson_comment_91 , t59 . parson_comment_en AS parson_comment_en_92 , t59 . parson_comment_cn AS parson_comment_cn_93 , t59 . parson_comment_tw AS parson_comment_tw_94 , t59 . entry_id AS entry_id_95 , t59 . parson_id AS parson_id_96 , t97 . created_at AS created_at_98 , t97 . updated_at AS updated_at_99 , t97 . deleted_at AS deleted_at_100 , t97 . id AS id_101 , t97 . description AS description_102 , t97 . postal AS postal_103 , t97 . address AS address_104 , t97 . phone AS phone_105 , t97 . business_time AS business_time_106 , t97 . parking AS parking_107 , t97 . website AS website_108 , t97 . transportation AS transportation_109 , t97 . description_en AS description_en_110 , t97 . description_cn AS description_cn_111 , t97 . description_tw AS description_tw_112 , t97 . address_en AS address_en_113 , t97 . address_cn AS address_cn_114 , t97 . address_tw AS address_tw_115 , t97 . business_time_en AS business_time_en_116 , t97 . business_time_cn AS business_time_cn_117 , t97 . business_time_tw AS business_time_tw_118 , t97 . parking_en AS parking_en_119 , t97 . parking_cn AS parking_cn_120 , t97 . parking_tw AS parking_tw_121 , t97 . transportation_en AS transportation_en_122 , t97 . transportation_cn AS transportation_cn_123 , t97 . transportation_tw AS transportation_tw_124 , t97 . life_summary AS life_summary_125 , t97 . life_summary_en AS life_summary_en_126 , t97 . life_summary_cn AS life_summary_cn_127 , t97 . life_summary_tw AS life_summary_tw_128 , t97 . parson_comment AS parson_comment_129 , t97 . parson_comment_en AS parson_comment_en_130 , t97 . parson_comment_cn AS parson_comment_cn_131 , t97 . parson_comment_tw AS parson_comment_tw_132 , t97 . entry_id AS entry_id_133 , t97 . parson_id AS parson_id_134 , t135 . created_at AS created_at_136 , t135 . updated_at AS updated_at_137 , t135 . deleted_at AS deleted_at_138 , t135 . id AS id_139 , t135 . description AS description_140 , t135 . postal AS postal_141 , t135 . address AS address_142 , t135 . phone AS phone_143 , t135 . business_time AS business_time_144 , t135 . parking AS parking_145 , t135 . website AS website_146 , t135 . transportation AS transportation_147 , t135 . description_en AS description_en_148 , t135 . description_cn AS description_cn_149 , t135 . description_tw AS description_tw_150 , t135 . address_en AS address_en_151 , t135 . address_cn AS address_cn_152 , t135 . address_tw AS address_tw_153 , t135 . business_time_en AS business_time_en_154 , t135 . business_time_cn AS business_time_cn_155 , t135 . business_time_tw AS business_time_tw_156 , t135 . parking_en AS parking_en_157 , t135 . parking_cn AS parking_cn_158 , t135 . parking_tw AS parking_tw_159 , t135 . transportation_en AS transportation_en_160 , t135 . transportation_cn AS transportation_cn_161 , t135 . transportation_tw AS transportation_tw_162 , t135 . life_summary AS life_summary_163 , t135 . life_summary_en AS life_summary_en_164 , t135 . life_summary_cn AS life_summary_cn_165 , t135 . life_summary_tw AS life_summary_tw_166 , t135 . parson_comment AS parson_comment_167 , t135 . parson_comment_en AS parson_comment_en_168 , t135 . parson_comment_cn AS parson_comment_cn_169 , t135 . parson_comment_tw AS parson_comment_tw_170 , t135 . entry_id AS entry_id_171 , t135 . parson_id AS parson_id_172 , t0 . slave_entry_id AS slave_entry_id_173 , t0 . owner_id AS owner_id_174 , t0 . area_id AS area_id_175 FROM entry_entry t0 LEFT JOIN entry_geolocation t28 ON t28 . entry_id = t0 . id LEFT JOIN entry_modelplan t36 ON t36 . entry_id = t0 . id LEFT JOIN entry_hotel t59 ON t59 . entry_id = t0 . id LEFT JOIN entry_workspace t97 ON t97 . entry_id = t0 . id LEFT JOIN entry_actibity t135 ON t135 . entry_id = t0 . id WHERE t0 . id = 26 AND ((t0 . deleted_at IS NULL )); Copy
6
0.48 ms
SELECT COUNT (* ) AS dctrn_count FROM (SELECT DISTINCT id_3 FROM (SELECT c0_ . created_at AS created_at_0 , c0_ . updated_at AS updated_at_1 , c0_ . deleted_at AS deleted_at_2 , c0_ . id AS id_3 , c0_ . entry_date AS entry_date_4 , c0_ . title AS title_5 , c0_ . title_en AS title_en_6 , c0_ . title_cn AS title_cn_7 , c0_ . title_tw AS title_tw_8 , c0_ . enable AS enable_9 , c0_ . pub_date AS pub_date_10 , c0_ . close_date AS close_date_11 , c0_ . main_img AS main_img_12 , c0_ . main_img_width AS main_img_width_13 , c0_ . main_img_height AS main_img_height_14 , c0_ . thumbnail AS thumbnail_15 , c0_ . description AS description_16 , c0_ . link_url AS link_url_17 , c0_ . link_newtab AS link_newtab_18 , c0_ . content AS content_19 , c0_ . content_en AS content_en_20 , c0_ . content_cn AS content_cn_21 , c0_ . content_tw AS content_tw_22 FROM cms_entry_report_post c0_ LEFT JOIN entry_entry e1_ ON (c0_ . entry_id = e1_ . id ) AND (e1_ . deleted_at IS NULL ) LEFT JOIN account_owner a2_ ON (e1_ . owner_id = a2_ . id ) AND (a2_ . deleted_at IS NULL ) WHERE (c0_ . enable = ? AND (c0_ . pub_date IS NULL OR c0_ . pub_date < = ? ) AND (c0_ . close_date IS NULL OR c0_ . close_date > = ? ) AND e1_ . approval = ? AND e1_ . is_draft = ? AND a2_ . status = ? ) AND (c0_ . deleted_at IS NULL ) ORDER BY c0_ . entry_date DESC , c0_ . id DESC ) dctrn_result ) dctrn_table
Parameters :
[
1
"2025-12-20 21:59:58 "
"2025-12-20 21:59:58 "
1
0
1
]
SELECT COUNT (* ) AS dctrn_count FROM (SELECT DISTINCT id_3 FROM (SELECT c0_ . created_at AS created_at_0 , c0_ . updated_at AS updated_at_1 , c0_ . deleted_at AS deleted_at_2 , c0_ . id AS id_3 , c0_ . entry_date AS entry_date_4 , c0_ . title AS title_5 , c0_ . title_en AS title_en_6 , c0_ . title_cn AS title_cn_7 , c0_ . title_tw AS title_tw_8 , c0_ . enable AS enable_9 , c0_ . pub_date AS pub_date_10 , c0_ . close_date AS close_date_11 , c0_ . main_img AS main_img_12 , c0_ . main_img_width AS main_img_width_13 , c0_ . main_img_height AS main_img_height_14 , c0_ . thumbnail AS thumbnail_15 , c0_ . description AS description_16 , c0_ . link_url AS link_url_17 , c0_ . link_newtab AS link_newtab_18 , c0_ . content AS content_19 , c0_ . content_en AS content_en_20 , c0_ . content_cn AS content_cn_21 , c0_ . content_tw AS content_tw_22 FROM cms_entry_report_post c0_ LEFT JOIN entry_entry e1_ ON (c0_ . entry_id = e1_ . id ) AND (e1_ . deleted_at IS NULL ) LEFT JOIN account_owner a2_ ON (e1_ . owner_id = a2_ . id ) AND (a2_ . deleted_at IS NULL ) WHERE (c0_ . enable = 1 AND (c0_ . pub_date IS NULL OR c0_ . pub_date < = '2025-12-20 21:59:58' ) AND (c0_ . close_date IS NULL OR c0_ . close_date > = '2025-12-20 21:59:58' ) AND e1_ . approval = 1 AND e1_ . is_draft = 0 AND a2_ . status = 1 ) AND (c0_ . deleted_at IS NULL ) ORDER BY c0_ . entry_date DESC , c0_ . id DESC ) dctrn_result ) dctrn_table ; Copy