| 1 |
2.19 ms |
SELECT count(DISTINCT c0_.id) AS sclr_0 FROM cms_mod_sightseeing c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2026-04-11 06:03:12") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2026-04-11 06:03:12") AND (c0_.public_date IS NULL OR c0_.public_date <= "2026-04-11"))
SELECT count(DISTINCT c0_.id) AS sclr_0 FROM cms_mod_sightseeing c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2026-04-11 06:03:12") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2026-04-11 06:03:12") AND (c0_.public_date IS NULL OR c0_.public_date <= "2026-04-11"));
|
| 2 |
1.85 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.sort_num AS sort_num_1, c0_.id AS id_2 FROM cms_mod_sightseeing c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2026-04-11 06:03:12") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2026-04-11 06:03:12") AND (c0_.public_date IS NULL OR c0_.public_date <= "2026-04-11")) ORDER BY c0_.sort_num ASC, c0_.id DESC LIMIT 9 OFFSET 9
SELECT DISTINCT c0_.id AS id_0, c0_.sort_num AS sort_num_1, c0_.id AS id_2 FROM cms_mod_sightseeing c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2026-04-11 06:03:12") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2026-04-11 06:03:12") AND (c0_.public_date IS NULL OR c0_.public_date <= "2026-04-11")) ORDER BY c0_.sort_num ASC, c0_.id DESC LIMIT 9 OFFSET 9;
|
| 3 |
2.30 ms |
SELECT c0_.comment AS comment_0, c0_.access AS access_1, c0_.map AS map_2, c0_.link_button AS link_button_3, c0_.is_imported AS is_imported_4, c0_.map_link_url AS map_link_url_5, c0_.icon AS icon_6, c0_.public_date AS public_date_7, c0_.customblock AS customblock_8, c0_.id AS id_9, c0_.sort_num AS sort_num_10, c0_.status AS status_11, c0_.publish_at AS publish_at_12, c0_.expires_at AS expires_at_13, c0_.created_at AS created_at_14, c0_.updated_at AS updated_at_15, c0_.title AS title_16, c0_.language_parent AS language_parent_17, c0_.language_alias AS language_alias_18, c0_.language_active AS language_active_19, c0_.revision_parent AS revision_parent_20, c0_.revision_version AS revision_version_21, c0_.post_type AS post_type_22, c0_.access_token AS access_token_23, c0_.thumbnail AS thumbnail_24, c0_.facility_id AS facility_id_25, c0_.created_by AS created_by_26, c0_.updated_by AS updated_by_27, c0_.language_id AS language_id_28, c0_.latest_approval_request_id AS latest_approval_request_id_29 FROM cms_mod_sightseeing c0_ WHERE (c0_.id IN (?)) AND (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2026-04-11 06:03:12") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2026-04-11 06:03:12") AND (c0_.public_date IS NULL OR c0_.public_date <= "2026-04-11")) ORDER BY c0_.sort_num ASC, c0_.id DESC
SELECT c0_.comment AS comment_0, c0_.access AS access_1, c0_.map AS map_2, c0_.link_button AS link_button_3, c0_.is_imported AS is_imported_4, c0_.map_link_url AS map_link_url_5, c0_.icon AS icon_6, c0_.public_date AS public_date_7, c0_.customblock AS customblock_8, c0_.id AS id_9, c0_.sort_num AS sort_num_10, c0_.status AS status_11, c0_.publish_at AS publish_at_12, c0_.expires_at AS expires_at_13, c0_.created_at AS created_at_14, c0_.updated_at AS updated_at_15, c0_.title AS title_16, c0_.language_parent AS language_parent_17, c0_.language_alias AS language_alias_18, c0_.language_active AS language_active_19, c0_.revision_parent AS revision_parent_20, c0_.revision_version AS revision_version_21, c0_.post_type AS post_type_22, c0_.access_token AS access_token_23, c0_.thumbnail AS thumbnail_24, c0_.facility_id AS facility_id_25, c0_.created_by AS created_by_26, c0_.updated_by AS updated_by_27, c0_.language_id AS language_id_28, c0_.latest_approval_request_id AS latest_approval_request_id_29 FROM cms_mod_sightseeing c0_ WHERE (c0_.id IN (9, 7)) AND (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2026-04-11 06:03:12") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2026-04-11 06:03:12") AND (c0_.public_date IS NULL OR c0_.public_date <= "2026-04-11")) ORDER BY c0_.sort_num ASC, c0_.id DESC;
|
| 4 |
2.58 ms |
SELECT t0.code AS code_1, t0.title AS title_2, t0.intro_text AS intro_text_3, t0.zip AS zip_4, t0.address AS address_5, t0.building AS building_6, t0.google_maps_url AS google_maps_url_7, t0.phone AS phone_8, t0.website AS website_9, t0.opening_hours AS opening_hours_10, t0.holiday AS holiday_11, t0.access AS access_12, t0.access_car AS access_car_13, t0.access_train AS access_train_14, t0.id AS id_15, t0.sort_num AS sort_num_16, t0.status AS status_17, t0.publish_at AS publish_at_18, t0.expires_at AS expires_at_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.area_id AS area_id_22, t0.prefecture_id AS prefecture_id_23, t0.logo_image AS logo_image_24, t0.main_image AS main_image_25, t0.created_by AS created_by_26, t27.username AS username_28, t27.username_canonical AS username_canonical_29, t27.enabled AS enabled_30, t27.last_login AS last_login_31, t27.confirmation_token AS confirmation_token_32, t27.password_requested_at AS password_requested_at_33, t27.roles AS roles_34, t27.id AS id_35, t27.display_name AS display_name_36, t27.sort_num AS sort_num_37, t27.email AS email_38, t27.email_canonical AS email_canonical_39, t27.salt AS salt_40, t27.password AS password_41, t27.group_id AS group_id_42, t27.facility_id AS facility_id_43, t0.updated_by AS updated_by_44, t45.username AS username_46, t45.username_canonical AS username_canonical_47, t45.enabled AS enabled_48, t45.last_login AS last_login_49, t45.confirmation_token AS confirmation_token_50, t45.password_requested_at AS password_requested_at_51, t45.roles AS roles_52, t45.id AS id_53, t45.display_name AS display_name_54, t45.sort_num AS sort_num_55, t45.email AS email_56, t45.email_canonical AS email_canonical_57, t45.salt AS salt_58, t45.password AS password_59, t45.group_id AS group_id_60, t45.facility_id AS facility_id_61 FROM cms_facility t0 LEFT JOIN cms_user t27 ON t0.created_by = t27.id LEFT JOIN cms_user t45 ON t0.updated_by = t45.id WHERE t0.id IN (?) AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2026-04-11 06:03:12") AND (t0.expires_at IS NULL OR t0.expires_at > "2026-04-11 06:03:12")))
SELECT
t0.code AS code_1,
t0.title AS title_2,
t0.intro_text AS intro_text_3,
t0.zip AS zip_4,
t0.address AS address_5,
t0.building AS building_6,
t0.google_maps_url AS google_maps_url_7,
t0.phone AS phone_8,
t0.website AS website_9,
t0.opening_hours AS opening_hours_10,
t0.holiday AS holiday_11,
t0.access AS access_12,
t0.access_car AS access_car_13,
t0.access_train AS access_train_14,
t0.id AS id_15,
t0.sort_num AS sort_num_16,
t0.status AS status_17,
t0.publish_at AS publish_at_18,
t0.expires_at AS expires_at_19,
t0.created_at AS created_at_20,
t0.updated_at AS updated_at_21,
t0.area_id AS area_id_22,
t0.prefecture_id AS prefecture_id_23,
t0.logo_image AS logo_image_24,
t0.main_image AS main_image_25,
t0.created_by AS created_by_26,
t27.username AS username_28,
t27.username_canonical AS username_canonical_29,
t27.enabled AS enabled_30,
t27.last_login AS last_login_31,
t27.confirmation_token AS confirmation_token_32,
t27.password_requested_at AS password_requested_at_33,
t27.roles AS roles_34,
t27.id AS id_35,
t27.display_name AS display_name_36,
t27.sort_num AS sort_num_37,
t27.email AS email_38,
t27.email_canonical AS email_canonical_39,
t27.salt AS salt_40,
t27.password AS password_41,
t27.group_id AS group_id_42,
t27.facility_id AS facility_id_43,
t0.updated_by AS updated_by_44,
t45.username AS username_46,
t45.username_canonical AS username_canonical_47,
t45.enabled AS enabled_48,
t45.last_login AS last_login_49,
t45.confirmation_token AS confirmation_token_50,
t45.password_requested_at AS password_requested_at_51,
t45.roles AS roles_52,
t45.id AS id_53,
t45.display_name AS display_name_54,
t45.sort_num AS sort_num_55,
t45.email AS email_56,
t45.email_canonical AS email_canonical_57,
t45.salt AS salt_58,
t45.password AS password_59,
t45.group_id AS group_id_60,
t45.facility_id AS facility_id_61
FROM
cms_facility t0
LEFT JOIN cms_user t27 ON t0.created_by = t27.id
LEFT JOIN cms_user t45 ON t0.updated_by = t45.id
WHERE
t0.id IN (?)
AND (
(
t0.status = 1
AND (
t0.publish_at IS NULL
OR t0.publish_at <= "2026-04-11 06:03:12"
)
AND (
t0.expires_at IS NULL
OR t0.expires_at > "2026-04-11 06:03:12"
)
)
)
SELECT t0.code AS code_1, t0.title AS title_2, t0.intro_text AS intro_text_3, t0.zip AS zip_4, t0.address AS address_5, t0.building AS building_6, t0.google_maps_url AS google_maps_url_7, t0.phone AS phone_8, t0.website AS website_9, t0.opening_hours AS opening_hours_10, t0.holiday AS holiday_11, t0.access AS access_12, t0.access_car AS access_car_13, t0.access_train AS access_train_14, t0.id AS id_15, t0.sort_num AS sort_num_16, t0.status AS status_17, t0.publish_at AS publish_at_18, t0.expires_at AS expires_at_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.area_id AS area_id_22, t0.prefecture_id AS prefecture_id_23, t0.logo_image AS logo_image_24, t0.main_image AS main_image_25, t0.created_by AS created_by_26, t27.username AS username_28, t27.username_canonical AS username_canonical_29, t27.enabled AS enabled_30, t27.last_login AS last_login_31, t27.confirmation_token AS confirmation_token_32, t27.password_requested_at AS password_requested_at_33, t27.roles AS roles_34, t27.id AS id_35, t27.display_name AS display_name_36, t27.sort_num AS sort_num_37, t27.email AS email_38, t27.email_canonical AS email_canonical_39, t27.salt AS salt_40, t27.password AS password_41, t27.group_id AS group_id_42, t27.facility_id AS facility_id_43, t0.updated_by AS updated_by_44, t45.username AS username_46, t45.username_canonical AS username_canonical_47, t45.enabled AS enabled_48, t45.last_login AS last_login_49, t45.confirmation_token AS confirmation_token_50, t45.password_requested_at AS password_requested_at_51, t45.roles AS roles_52, t45.id AS id_53, t45.display_name AS display_name_54, t45.sort_num AS sort_num_55, t45.email AS email_56, t45.email_canonical AS email_canonical_57, t45.salt AS salt_58, t45.password AS password_59, t45.group_id AS group_id_60, t45.facility_id AS facility_id_61 FROM cms_facility t0 LEFT JOIN cms_user t27 ON t0.created_by = t27.id LEFT JOIN cms_user t45 ON t0.updated_by = t45.id WHERE t0.id IN (1) AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2026-04-11 06:03:12") AND (t0.expires_at IS NULL OR t0.expires_at > "2026-04-11 06:03:12")));
|
| 5 |
1.60 ms |
SELECT t0.id AS id_1, t0.is_wheel AS is_wheel_2, t0.is_system_admin AS is_system_admin_3, t0.level AS level_4, t0.name AS name_5, t0.display_name AS display_name_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM cms_user_groups t0 WHERE t0.id IN (?)
SELECT t0.id AS id_1, t0.is_wheel AS is_wheel_2, t0.is_system_admin AS is_system_admin_3, t0.level AS level_4, t0.name AS name_5, t0.display_name AS display_name_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM cms_user_groups t0 WHERE t0.id IN (1);
|
| 6 |
1.98 ms |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.enabled AS enabled_3, t0.last_login AS last_login_4, t0.confirmation_token AS confirmation_token_5, t0.password_requested_at AS password_requested_at_6, t0.roles AS roles_7, t0.id AS id_8, t0.display_name AS display_name_9, t0.sort_num AS sort_num_10, t0.email AS email_11, t0.email_canonical AS email_canonical_12, t0.salt AS salt_13, t0.password AS password_14, t0.group_id AS group_id_15, t16.id AS id_17, t16.is_wheel AS is_wheel_18, t16.is_system_admin AS is_system_admin_19, t16.level AS level_20, t16.name AS name_21, t16.display_name AS display_name_22, t16.description AS description_23, t16.created_at AS created_at_24, t16.updated_at AS updated_at_25, t0.facility_id AS facility_id_26, t27.code AS code_28, t27.title AS title_29, t27.intro_text AS intro_text_30, t27.zip AS zip_31, t27.address AS address_32, t27.building AS building_33, t27.google_maps_url AS google_maps_url_34, t27.phone AS phone_35, t27.website AS website_36, t27.opening_hours AS opening_hours_37, t27.holiday AS holiday_38, t27.access AS access_39, t27.access_car AS access_car_40, t27.access_train AS access_train_41, t27.id AS id_42, t27.sort_num AS sort_num_43, t27.status AS status_44, t27.publish_at AS publish_at_45, t27.expires_at AS expires_at_46, t27.created_at AS created_at_47, t27.updated_at AS updated_at_48, t27.area_id AS area_id_49, t27.prefecture_id AS prefecture_id_50, t27.logo_image AS logo_image_51, t27.main_image AS main_image_52, t27.created_by AS created_by_53, t27.updated_by AS updated_by_54 FROM cms_user t0 LEFT JOIN cms_user_groups t16 ON t0.group_id = t16.id LEFT JOIN cms_facility t27 ON t0.facility_id = t27.id AND ((t27.status = 1 AND (t27.publish_at IS NULL OR t27.publish_at <= "2026-04-11 06:03:12") AND (t27.expires_at IS NULL OR t27.expires_at > "2026-04-11 06:03:12"))) WHERE t0.id IN (?)
SELECT
t0.username AS username_1,
t0.username_canonical AS username_canonical_2,
t0.enabled AS enabled_3,
t0.last_login AS last_login_4,
t0.confirmation_token AS confirmation_token_5,
t0.password_requested_at AS password_requested_at_6,
t0.roles AS roles_7,
t0.id AS id_8,
t0.display_name AS display_name_9,
t0.sort_num AS sort_num_10,
t0.email AS email_11,
t0.email_canonical AS email_canonical_12,
t0.salt AS salt_13,
t0.password AS password_14,
t0.group_id AS group_id_15,
t16.id AS id_17,
t16.is_wheel AS is_wheel_18,
t16.is_system_admin AS is_system_admin_19,
t16.level AS level_20,
t16.name AS name_21,
t16.display_name AS display_name_22,
t16.description AS description_23,
t16.created_at AS created_at_24,
t16.updated_at AS updated_at_25,
t0.facility_id AS facility_id_26,
t27.code AS code_28,
t27.title AS title_29,
t27.intro_text AS intro_text_30,
t27.zip AS zip_31,
t27.address AS address_32,
t27.building AS building_33,
t27.google_maps_url AS google_maps_url_34,
t27.phone AS phone_35,
t27.website AS website_36,
t27.opening_hours AS opening_hours_37,
t27.holiday AS holiday_38,
t27.access AS access_39,
t27.access_car AS access_car_40,
t27.access_train AS access_train_41,
t27.id AS id_42,
t27.sort_num AS sort_num_43,
t27.status AS status_44,
t27.publish_at AS publish_at_45,
t27.expires_at AS expires_at_46,
t27.created_at AS created_at_47,
t27.updated_at AS updated_at_48,
t27.area_id AS area_id_49,
t27.prefecture_id AS prefecture_id_50,
t27.logo_image AS logo_image_51,
t27.main_image AS main_image_52,
t27.created_by AS created_by_53,
t27.updated_by AS updated_by_54
FROM
cms_user t0
LEFT JOIN cms_user_groups t16 ON t0.group_id = t16.id
LEFT JOIN cms_facility t27 ON t0.facility_id = t27.id
AND (
(
t27.status = 1
AND (
t27.publish_at IS NULL
OR t27.publish_at <= "2026-04-11 06:03:12"
)
AND (
t27.expires_at IS NULL
OR t27.expires_at > "2026-04-11 06:03:12"
)
)
)
WHERE
t0.id IN (?)
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.enabled AS enabled_3, t0.last_login AS last_login_4, t0.confirmation_token AS confirmation_token_5, t0.password_requested_at AS password_requested_at_6, t0.roles AS roles_7, t0.id AS id_8, t0.display_name AS display_name_9, t0.sort_num AS sort_num_10, t0.email AS email_11, t0.email_canonical AS email_canonical_12, t0.salt AS salt_13, t0.password AS password_14, t0.group_id AS group_id_15, t16.id AS id_17, t16.is_wheel AS is_wheel_18, t16.is_system_admin AS is_system_admin_19, t16.level AS level_20, t16.name AS name_21, t16.display_name AS display_name_22, t16.description AS description_23, t16.created_at AS created_at_24, t16.updated_at AS updated_at_25, t0.facility_id AS facility_id_26, t27.code AS code_28, t27.title AS title_29, t27.intro_text AS intro_text_30, t27.zip AS zip_31, t27.address AS address_32, t27.building AS building_33, t27.google_maps_url AS google_maps_url_34, t27.phone AS phone_35, t27.website AS website_36, t27.opening_hours AS opening_hours_37, t27.holiday AS holiday_38, t27.access AS access_39, t27.access_car AS access_car_40, t27.access_train AS access_train_41, t27.id AS id_42, t27.sort_num AS sort_num_43, t27.status AS status_44, t27.publish_at AS publish_at_45, t27.expires_at AS expires_at_46, t27.created_at AS created_at_47, t27.updated_at AS updated_at_48, t27.area_id AS area_id_49, t27.prefecture_id AS prefecture_id_50, t27.logo_image AS logo_image_51, t27.main_image AS main_image_52, t27.created_by AS created_by_53, t27.updated_by AS updated_by_54 FROM cms_user t0 LEFT JOIN cms_user_groups t16 ON t0.group_id = t16.id LEFT JOIN cms_facility t27 ON t0.facility_id = t27.id AND ((t27.status = 1 AND (t27.publish_at IS NULL OR t27.publish_at <= "2026-04-11 061:12") AND (t27.expires_at IS NULL OR t27.expires_at > "2026-04-11 06:03:12"))) WHERE t0.id IN (?);
|
| 7 |
3.12 ms |
SELECT t0.alias AS alias_1, t0.id AS id_2, t0.sort_num AS sort_num_3, t0.status AS status_4, t0.publish_at AS publish_at_5, t0.expires_at AS expires_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.title AS title_9, t0.language_parent AS language_parent_10, t0.language_alias AS language_alias_11, t0.language_active AS language_active_12, t0.facility_id AS facility_id_13, t14.code AS code_15, t14.title AS title_16, t14.intro_text AS intro_text_17, t14.zip AS zip_18, t14.address AS address_19, t14.building AS building_20, t14.google_maps_url AS google_maps_url_21, t14.phone AS phone_22, t14.website AS website_23, t14.opening_hours AS opening_hours_24, t14.holiday AS holiday_25, t14.access AS access_26, t14.access_car AS access_car_27, t14.access_train AS access_train_28, t14.id AS id_29, t14.sort_num AS sort_num_30, t14.status AS status_31, t14.publish_at AS publish_at_32, t14.expires_at AS expires_at_33, t14.created_at AS created_at_34, t14.updated_at AS updated_at_35, t14.area_id AS area_id_36, t14.prefecture_id AS prefecture_id_37, t14.logo_image AS logo_image_38, t14.main_image AS main_image_39, t14.created_by AS created_by_40, t14.updated_by AS updated_by_41, t0.created_by AS created_by_42, t43.username AS username_44, t43.username_canonical AS username_canonical_45, t43.enabled AS enabled_46, t43.last_login AS last_login_47, t43.confirmation_token AS confirmation_token_48, t43.password_requested_at AS password_requested_at_49, t43.roles AS roles_50, t43.id AS id_51, t43.display_name AS display_name_52, t43.sort_num AS sort_num_53, t43.email AS email_54, t43.email_canonical AS email_canonical_55, t43.salt AS salt_56, t43.password AS password_57, t43.group_id AS group_id_58, t43.facility_id AS facility_id_59, t0.updated_by AS updated_by_60, t61.username AS username_62, t61.username_canonical AS username_canonical_63, t61.enabled AS enabled_64, t61.last_login AS last_login_65, t61.confirmation_token AS confirmation_token_66, t61.password_requested_at AS password_requested_at_67, t61.roles AS roles_68, t61.id AS id_69, t61.display_name AS display_name_70, t61.sort_num AS sort_num_71, t61.email AS email_72, t61.email_canonical AS email_canonical_73, t61.salt AS salt_74, t61.password AS password_75, t61.group_id AS group_id_76, t61.facility_id AS facility_id_77, t0.language_id AS language_id_78, t79.alias AS alias_80, t79.translate_key AS translate_key_81, t79.target_key AS target_key_82, t79.id AS id_83, t79.sort_num AS sort_num_84, t79.status AS status_85, t79.publish_at AS publish_at_86, t79.expires_at AS expires_at_87, t79.created_at AS created_at_88, t79.updated_at AS updated_at_89, t79.title AS title_90, t79.created_by AS created_by_91, t79.updated_by AS updated_by_92 FROM cms_mod_sightseeing_tags t0 LEFT JOIN cms_facility t14 ON t0.facility_id = t14.id AND ((t14.status = 1 AND (t14.publish_at IS NULL OR t14.publish_at <= "2026-04-11 06:03:12") AND (t14.expires_at IS NULL OR t14.expires_at > "2026-04-11 06:03:12"))) LEFT JOIN cms_user t43 ON t0.created_by = t43.id LEFT JOIN cms_user t61 ON t0.updated_by = t61.id LEFT JOIN cms_master_languages t79 ON t0.language_id = t79.id AND ((t79.status = 1 AND (t79.publish_at IS NULL OR t79.publish_at <= "2026-04-11 06:03:12") AND (t79.expires_at IS NULL OR t79.expires_at > "2026-04-11 06:03:12"))) INNER JOIN cms_mod_sightseeing_items_tags ON t0.id = cms_mod_sightseeing_items_tags.tag_id WHERE cms_mod_sightseeing_items_tags.item_id = ? AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2026-04-11 06:03:12") AND (t0.expires_at IS NULL OR t0.expires_at > "2026-04-11 06:03:12")))
SELECT
t0.alias AS alias_1,
t0.id AS id_2,
t0.sort_num AS sort_num_3,
t0.status AS status_4,
t0.publish_at AS publish_at_5,
t0.expires_at AS expires_at_6,
t0.created_at AS created_at_7,
t0.updated_at AS updated_at_8,
t0.title AS title_9,
t0.language_parent AS language_parent_10,
t0.language_alias AS language_alias_11,
t0.language_active AS language_active_12,
t0.facility_id AS facility_id_13,
t14.code AS code_15,
t14.title AS title_16,
t14.intro_text AS intro_text_17,
t14.zip AS zip_18,
t14.address AS address_19,
t14.building AS building_20,
t14.google_maps_url AS google_maps_url_21,
t14.phone AS phone_22,
t14.website AS website_23,
t14.opening_hours AS opening_hours_24,
t14.holiday AS holiday_25,
t14.access AS access_26,
t14.access_car AS access_car_27,
t14.access_train AS access_train_28,
t14.id AS id_29,
t14.sort_num AS sort_num_30,
t14.status AS status_31,
t14.publish_at AS publish_at_32,
t14.expires_at AS expires_at_33,
t14.created_at AS created_at_34,
t14.updated_at AS updated_at_35,
t14.area_id AS area_id_36,
t14.prefecture_id AS prefecture_id_37,
t14.logo_image AS logo_image_38,
t14.main_image AS main_image_39,
t14.created_by AS created_by_40,
t14.updated_by AS updated_by_41,
t0.created_by AS created_by_42,
t43.username AS username_44,
t43.username_canonical AS username_canonical_45,
t43.enabled AS enabled_46,
t43.last_login AS last_login_47,
t43.confirmation_token AS confirmation_token_48,
t43.password_requested_at AS password_requested_at_49,
t43.roles AS roles_50,
t43.id AS id_51,
t43.display_name AS display_name_52,
t43.sort_num AS sort_num_53,
t43.email AS email_54,
t43.email_canonical AS email_canonical_55,
t43.salt AS salt_56,
t43.password AS password_57,
t43.group_id AS group_id_58,
t43.facility_id AS facility_id_59,
t0.updated_by AS updated_by_60,
t61.username AS username_62,
t61.username_canonical AS username_canonical_63,
t61.enabled AS enabled_64,
t61.last_login AS last_login_65,
t61.confirmation_token AS confirmation_token_66,
t61.password_requested_at AS password_requested_at_67,
t61.roles AS roles_68,
t61.id AS id_69,
t61.display_name AS display_name_70,
t61.sort_num AS sort_num_71,
t61.email AS email_72,
t61.email_canonical AS email_canonical_73,
t61.salt AS salt_74,
t61.password AS password_75,
t61.group_id AS group_id_76,
t61.facility_id AS facility_id_77,
t0.language_id AS language_id_78,
t79.alias AS alias_80,
t79.translate_key AS translate_key_81,
t79.target_key AS target_key_82,
t79.id AS id_83,
t79.sort_num AS sort_num_84,
t79.status AS status_85,
t79.publish_at AS publish_at_86,
t79.expires_at AS expires_at_87,
t79.created_at AS created_at_88,
t79.updated_at AS updated_at_89,
t79.title AS title_90,
t79.created_by AS created_by_91,
t79.updated_by AS updated_by_92
FROM
cms_mod_sightseeing_tags t0
LEFT JOIN cms_facility t14 ON t0.facility_id = t14.id
AND (
(
t14.status = 1
AND (
t14.publish_at IS NULL
OR t14.publish_at <= "2026-04-11 06:03:12"
)
AND (
t14.expires_at IS NULL
OR t14.expires_at > "2026-04-11 06:03:12"
)
)
)
LEFT JOIN cms_user t43 ON t0.created_by = t43.id
LEFT JOIN cms_user t61 ON t0.updated_by = t61.id
LEFT JOIN cms_master_languages t79 ON t0.language_id = t79.id
AND (
(
t79.status = 1
AND (
t79.publish_at IS NULL
OR t79.publish_at <= "2026-04-11 06:03:12"
)
AND (
t79.expires_at IS NULL
OR t79.expires_at > "2026-04-11 06:03:12"
)
)
)
INNER JOIN cms_mod_sightseeing_items_tags ON t0.id = cms_mod_sightseeing_items_tags.tag_id
WHERE
cms_mod_sightseeing_items_tags.item_id = ?
AND (
(
t0.status = 1
AND (
t0.publish_at IS NULL
OR t0.publish_at <= "2026-04-11 06:03:12"
)
AND (
t0.expires_at IS NULL
OR t0.expires_at > "2026-04-11 06:03:12"
)
)
)
SELECT t0.alias AS alias_1, t0.id AS id_2, t0.sort_num AS sort_num_3, t0.status AS status_4, t0.publish_at AS publish_at_5, t0.expires_at AS expires_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.title AS title_9, t0.language_parent AS language_parent_10, t0.language_alias AS language_alias_11, t0.language_active AS language_active_12, t0.facility_id AS facility_id_13, t14.code AS code_15, t14.title AS title_16, t14.intro_text AS intro_text_17, t14.zip AS zip_18, t14.address AS address_19, t14.building AS building_20, t14.google_maps_url AS google_maps_url_21, t14.phone AS phone_22, t14.website AS website_23, t14.opening_hours AS opening_hours_24, t14.holiday AS holiday_25, t14.access AS access_26, t14.access_car AS access_car_27, t14.access_train AS access_train_28, t14.id AS id_29, t14.sort_num AS sort_num_30, t14.status AS status_31, t14.publish_at AS publish_at_32, t14.expires_at AS expires_at_33, t14.created_at AS created_at_34, t14.updated_at AS updated_at_35, t14.area_id AS area_id_36, t14.prefecture_id AS prefecture_id_37, t14.logo_image AS logo_image_38, t14.main_image AS main_image_39, t14.created_by AS created_by_40, t14.updated_by AS updated_by_41, t0.created_by AS created_by_42, t43.username AS username_44, t43.username_canonical AS username_canonical_45, t43.enabled AS enabled_46, t43.last_login AS last_login_47, t43.confirmation_token AS confirmation_token_48, t43.password_requested_at AS password_requested_at_49, t43.roles AS roles_50, t43.id AS id_51, t43.display_name AS display_name_52, t43.sort_num AS sort_num_53, t43.email AS email_54, t43.email_canonical AS email_canonical_55, t43.salt AS salt_56, t43.password AS password_57, t43.group_id AS group_id_58, t43.facility_id AS facility_id_59, t0.updated_by AS updated_by_60, t61.username AS username_62, t61.username_canonical AS username_canonical_63, t61.enabled AS enabled_64, t61.last_login AS last_login_65, t61.confirmation_token AS confirmation_token_66, t61.password_requested_at AS password_requested_at_67, t61.roles AS roles_68, t61.id AS id_69, t61.display_name AS display_name_70, t61.sort_num AS sort_num_71, t61.email AS email_72, t61.email_canonical AS email_canonical_73, t61.salt AS salt_74, t61.password AS password_75, t61.group_id AS group_id_76, t61.facility_id AS facility_id_77, t0.language_id AS language_id_78, t79.alias AS alias_80, t79.translate_key AS translate_key_81, t79.target_key AS target_key_82, t79.id AS id_83, t79.sort_num AS sort_num_84, t79.status AS status_85, t79.publish_at AS publish_at_86, t79.expires_at AS expires_at_87, t79.created_at AS created_at_88, t79.updated_at AS updated_at_89, t79.title AS title_90, t79.created_by AS created_by_91, t79.updated_by AS updated_by_92 FROM cms_mod_sightseeing_tags t0 LEFT JOIN cms_facility t14 ON t0.facility_id = t14.id AND ((t14.status = 1 AND (t14.publish_at IS NULL OR t14.publish_at <= "2026-04-11 069:12") AND (t14.expires_at IS NULL OR t14.expires_at > "2026-04-11 06:03:12"))) LEFT JOIN cms_user t43 ON t0.created_by = t43.id LEFT JOIN cms_user t61 ON t0.updated_by = t61.id LEFT JOIN cms_master_languages t79 ON t0.language_id = t79.id AND ((t79.status = 1 AND (t79.publish_at IS NULL OR t79.publish_at <= "2026-04-11 06:03:12") AND (t79.expires_at IS NULL OR t79.expires_at > "2026-04-11 06:03:12"))) INNER JOIN cms_mod_sightseeing_items_tags ON t0.id = cms_mod_sightseeing_items_tags.tag_id WHERE cms_mod_sightseeing_items_tags.item_id = ? AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2026-04-11 06:03:12") AND (t0.expires_at IS NULL OR t0.expires_at > "2026-04-11 06:03:12")));
|
| 8 |
2.51 ms |
SELECT t0.alias AS alias_1, t0.id AS id_2, t0.sort_num AS sort_num_3, t0.status AS status_4, t0.publish_at AS publish_at_5, t0.expires_at AS expires_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.title AS title_9, t0.language_parent AS language_parent_10, t0.language_alias AS language_alias_11, t0.language_active AS language_active_12, t0.facility_id AS facility_id_13, t14.code AS code_15, t14.title AS title_16, t14.intro_text AS intro_text_17, t14.zip AS zip_18, t14.address AS address_19, t14.building AS building_20, t14.google_maps_url AS google_maps_url_21, t14.phone AS phone_22, t14.website AS website_23, t14.opening_hours AS opening_hours_24, t14.holiday AS holiday_25, t14.access AS access_26, t14.access_car AS access_car_27, t14.access_train AS access_train_28, t14.id AS id_29, t14.sort_num AS sort_num_30, t14.status AS status_31, t14.publish_at AS publish_at_32, t14.expires_at AS expires_at_33, t14.created_at AS created_at_34, t14.updated_at AS updated_at_35, t14.area_id AS area_id_36, t14.prefecture_id AS prefecture_id_37, t14.logo_image AS logo_image_38, t14.main_image AS main_image_39, t14.created_by AS created_by_40, t14.updated_by AS updated_by_41, t0.created_by AS created_by_42, t43.username AS username_44, t43.username_canonical AS username_canonical_45, t43.enabled AS enabled_46, t43.last_login AS last_login_47, t43.confirmation_token AS confirmation_token_48, t43.password_requested_at AS password_requested_at_49, t43.roles AS roles_50, t43.id AS id_51, t43.display_name AS display_name_52, t43.sort_num AS sort_num_53, t43.email AS email_54, t43.email_canonical AS email_canonical_55, t43.salt AS salt_56, t43.password AS password_57, t43.group_id AS group_id_58, t43.facility_id AS facility_id_59, t0.updated_by AS updated_by_60, t61.username AS username_62, t61.username_canonical AS username_canonical_63, t61.enabled AS enabled_64, t61.last_login AS last_login_65, t61.confirmation_token AS confirmation_token_66, t61.password_requested_at AS password_requested_at_67, t61.roles AS roles_68, t61.id AS id_69, t61.display_name AS display_name_70, t61.sort_num AS sort_num_71, t61.email AS email_72, t61.email_canonical AS email_canonical_73, t61.salt AS salt_74, t61.password AS password_75, t61.group_id AS group_id_76, t61.facility_id AS facility_id_77, t0.language_id AS language_id_78, t79.alias AS alias_80, t79.translate_key AS translate_key_81, t79.target_key AS target_key_82, t79.id AS id_83, t79.sort_num AS sort_num_84, t79.status AS status_85, t79.publish_at AS publish_at_86, t79.expires_at AS expires_at_87, t79.created_at AS created_at_88, t79.updated_at AS updated_at_89, t79.title AS title_90, t79.created_by AS created_by_91, t79.updated_by AS updated_by_92 FROM cms_mod_sightseeing_tags t0 LEFT JOIN cms_facility t14 ON t0.facility_id = t14.id AND ((t14.status = 1 AND (t14.publish_at IS NULL OR t14.publish_at <= "2026-04-11 06:03:12") AND (t14.expires_at IS NULL OR t14.expires_at > "2026-04-11 06:03:12"))) LEFT JOIN cms_user t43 ON t0.created_by = t43.id LEFT JOIN cms_user t61 ON t0.updated_by = t61.id LEFT JOIN cms_master_languages t79 ON t0.language_id = t79.id AND ((t79.status = 1 AND (t79.publish_at IS NULL OR t79.publish_at <= "2026-04-11 06:03:12") AND (t79.expires_at IS NULL OR t79.expires_at > "2026-04-11 06:03:12"))) INNER JOIN cms_mod_sightseeing_items_tags ON t0.id = cms_mod_sightseeing_items_tags.tag_id WHERE cms_mod_sightseeing_items_tags.item_id = ? AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2026-04-11 06:03:12") AND (t0.expires_at IS NULL OR t0.expires_at > "2026-04-11 06:03:12")))
SELECT
t0.alias AS alias_1,
t0.id AS id_2,
t0.sort_num AS sort_num_3,
t0.status AS status_4,
t0.publish_at AS publish_at_5,
t0.expires_at AS expires_at_6,
t0.created_at AS created_at_7,
t0.updated_at AS updated_at_8,
t0.title AS title_9,
t0.language_parent AS language_parent_10,
t0.language_alias AS language_alias_11,
t0.language_active AS language_active_12,
t0.facility_id AS facility_id_13,
t14.code AS code_15,
t14.title AS title_16,
t14.intro_text AS intro_text_17,
t14.zip AS zip_18,
t14.address AS address_19,
t14.building AS building_20,
t14.google_maps_url AS google_maps_url_21,
t14.phone AS phone_22,
t14.website AS website_23,
t14.opening_hours AS opening_hours_24,
t14.holiday AS holiday_25,
t14.access AS access_26,
t14.access_car AS access_car_27,
t14.access_train AS access_train_28,
t14.id AS id_29,
t14.sort_num AS sort_num_30,
t14.status AS status_31,
t14.publish_at AS publish_at_32,
t14.expires_at AS expires_at_33,
t14.created_at AS created_at_34,
t14.updated_at AS updated_at_35,
t14.area_id AS area_id_36,
t14.prefecture_id AS prefecture_id_37,
t14.logo_image AS logo_image_38,
t14.main_image AS main_image_39,
t14.created_by AS created_by_40,
t14.updated_by AS updated_by_41,
t0.created_by AS created_by_42,
t43.username AS username_44,
t43.username_canonical AS username_canonical_45,
t43.enabled AS enabled_46,
t43.last_login AS last_login_47,
t43.confirmation_token AS confirmation_token_48,
t43.password_requested_at AS password_requested_at_49,
t43.roles AS roles_50,
t43.id AS id_51,
t43.display_name AS display_name_52,
t43.sort_num AS sort_num_53,
t43.email AS email_54,
t43.email_canonical AS email_canonical_55,
t43.salt AS salt_56,
t43.password AS password_57,
t43.group_id AS group_id_58,
t43.facility_id AS facility_id_59,
t0.updated_by AS updated_by_60,
t61.username AS username_62,
t61.username_canonical AS username_canonical_63,
t61.enabled AS enabled_64,
t61.last_login AS last_login_65,
t61.confirmation_token AS confirmation_token_66,
t61.password_requested_at AS password_requested_at_67,
t61.roles AS roles_68,
t61.id AS id_69,
t61.display_name AS display_name_70,
t61.sort_num AS sort_num_71,
t61.email AS email_72,
t61.email_canonical AS email_canonical_73,
t61.salt AS salt_74,
t61.password AS password_75,
t61.group_id AS group_id_76,
t61.facility_id AS facility_id_77,
t0.language_id AS language_id_78,
t79.alias AS alias_80,
t79.translate_key AS translate_key_81,
t79.target_key AS target_key_82,
t79.id AS id_83,
t79.sort_num AS sort_num_84,
t79.status AS status_85,
t79.publish_at AS publish_at_86,
t79.expires_at AS expires_at_87,
t79.created_at AS created_at_88,
t79.updated_at AS updated_at_89,
t79.title AS title_90,
t79.created_by AS created_by_91,
t79.updated_by AS updated_by_92
FROM
cms_mod_sightseeing_tags t0
LEFT JOIN cms_facility t14 ON t0.facility_id = t14.id
AND (
(
t14.status = 1
AND (
t14.publish_at IS NULL
OR t14.publish_at <= "2026-04-11 06:03:12"
)
AND (
t14.expires_at IS NULL
OR t14.expires_at > "2026-04-11 06:03:12"
)
)
)
LEFT JOIN cms_user t43 ON t0.created_by = t43.id
LEFT JOIN cms_user t61 ON t0.updated_by = t61.id
LEFT JOIN cms_master_languages t79 ON t0.language_id = t79.id
AND (
(
t79.status = 1
AND (
t79.publish_at IS NULL
OR t79.publish_at <= "2026-04-11 06:03:12"
)
AND (
t79.expires_at IS NULL
OR t79.expires_at > "2026-04-11 06:03:12"
)
)
)
INNER JOIN cms_mod_sightseeing_items_tags ON t0.id = cms_mod_sightseeing_items_tags.tag_id
WHERE
cms_mod_sightseeing_items_tags.item_id = ?
AND (
(
t0.status = 1
AND (
t0.publish_at IS NULL
OR t0.publish_at <= "2026-04-11 06:03:12"
)
AND (
t0.expires_at IS NULL
OR t0.expires_at > "2026-04-11 06:03:12"
)
)
)
SELECT t0.alias AS alias_1, t0.id AS id_2, t0.sort_num AS sort_num_3, t0.status AS status_4, t0.publish_at AS publish_at_5, t0.expires_at AS expires_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.title AS title_9, t0.language_parent AS language_parent_10, t0.language_alias AS language_alias_11, t0.language_active AS language_active_12, t0.facility_id AS facility_id_13, t14.code AS code_15, t14.title AS title_16, t14.intro_text AS intro_text_17, t14.zip AS zip_18, t14.address AS address_19, t14.building AS building_20, t14.google_maps_url AS google_maps_url_21, t14.phone AS phone_22, t14.website AS website_23, t14.opening_hours AS opening_hours_24, t14.holiday AS holiday_25, t14.access AS access_26, t14.access_car AS access_car_27, t14.access_train AS access_train_28, t14.id AS id_29, t14.sort_num AS sort_num_30, t14.status AS status_31, t14.publish_at AS publish_at_32, t14.expires_at AS expires_at_33, t14.created_at AS created_at_34, t14.updated_at AS updated_at_35, t14.area_id AS area_id_36, t14.prefecture_id AS prefecture_id_37, t14.logo_image AS logo_image_38, t14.main_image AS main_image_39, t14.created_by AS created_by_40, t14.updated_by AS updated_by_41, t0.created_by AS created_by_42, t43.username AS username_44, t43.username_canonical AS username_canonical_45, t43.enabled AS enabled_46, t43.last_login AS last_login_47, t43.confirmation_token AS confirmation_token_48, t43.password_requested_at AS password_requested_at_49, t43.roles AS roles_50, t43.id AS id_51, t43.display_name AS display_name_52, t43.sort_num AS sort_num_53, t43.email AS email_54, t43.email_canonical AS email_canonical_55, t43.salt AS salt_56, t43.password AS password_57, t43.group_id AS group_id_58, t43.facility_id AS facility_id_59, t0.updated_by AS updated_by_60, t61.username AS username_62, t61.username_canonical AS username_canonical_63, t61.enabled AS enabled_64, t61.last_login AS last_login_65, t61.confirmation_token AS confirmation_token_66, t61.password_requested_at AS password_requested_at_67, t61.roles AS roles_68, t61.id AS id_69, t61.display_name AS display_name_70, t61.sort_num AS sort_num_71, t61.email AS email_72, t61.email_canonical AS email_canonical_73, t61.salt AS salt_74, t61.password AS password_75, t61.group_id AS group_id_76, t61.facility_id AS facility_id_77, t0.language_id AS language_id_78, t79.alias AS alias_80, t79.translate_key AS translate_key_81, t79.target_key AS target_key_82, t79.id AS id_83, t79.sort_num AS sort_num_84, t79.status AS status_85, t79.publish_at AS publish_at_86, t79.expires_at AS expires_at_87, t79.created_at AS created_at_88, t79.updated_at AS updated_at_89, t79.title AS title_90, t79.created_by AS created_by_91, t79.updated_by AS updated_by_92 FROM cms_mod_sightseeing_tags t0 LEFT JOIN cms_facility t14 ON t0.facility_id = t14.id AND ((t14.status = 1 AND (t14.publish_at IS NULL OR t14.publish_at <= "2026-04-11 067:12") AND (t14.expires_at IS NULL OR t14.expires_at > "2026-04-11 06:03:12"))) LEFT JOIN cms_user t43 ON t0.created_by = t43.id LEFT JOIN cms_user t61 ON t0.updated_by = t61.id LEFT JOIN cms_master_languages t79 ON t0.language_id = t79.id AND ((t79.status = 1 AND (t79.publish_at IS NULL OR t79.publish_at <= "2026-04-11 06:03:12") AND (t79.expires_at IS NULL OR t79.expires_at > "2026-04-11 06:03:12"))) INNER JOIN cms_mod_sightseeing_items_tags ON t0.id = cms_mod_sightseeing_items_tags.tag_id WHERE cms_mod_sightseeing_items_tags.item_id = ? AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2026-04-11 06:03:12") AND (t0.expires_at IS NULL OR t0.expires_at > "2026-04-11 06:03:12")));
|