| 1 |
2.22 ms |
SELECT c0_.title_for_list AS title_for_list_0, c0_.alias AS alias_1, c0_.show_in_list AS show_in_list_2, c0_.public_date AS public_date_3, c0_.customblock AS customblock_4, c0_.id AS id_5, c0_.sort_num AS sort_num_6, c0_.status AS status_7, c0_.publish_at AS publish_at_8, c0_.expires_at AS expires_at_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11, c0_.title AS title_12, c0_.language_parent AS language_parent_13, c0_.language_alias AS language_alias_14, c0_.language_active AS language_active_15, c0_.revision_parent AS revision_parent_16, c0_.revision_version AS revision_version_17, c0_.post_type AS post_type_18, c0_.access_token AS access_token_19, c0_.image_pc AS image_pc_20, c0_.image_sp AS image_sp_21, c0_.thumbnail AS thumbnail_22, c0_.facility_id AS facility_id_23, c0_.created_by AS created_by_24, c0_.updated_by AS updated_by_25, c0_.language_id AS language_id_26, c0_.latest_approval_request_id AS latest_approval_request_id_27 FROM cms_mod_restaurant_genres c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2026-04-12 00:29:46") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2026-04-12 00:29:46") AND (c0_.public_date IS NULL OR c0_.public_date <= "2026-04-12")) ORDER BY c0_.sort_num ASC, c0_.id ASC
SELECT c0_.title_for_list AS title_for_list_0, c0_.alias AS alias_1, c0_.show_in_list AS show_in_list_2, c0_.public_date AS public_date_3, c0_.customblock AS customblock_4, c0_.id AS id_5, c0_.sort_num AS sort_num_6, c0_.status AS status_7, c0_.publish_at AS publish_at_8, c0_.expires_at AS expires_at_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11, c0_.title AS title_12, c0_.language_parent AS language_parent_13, c0_.language_alias AS language_alias_14, c0_.language_active AS language_active_15, c0_.revision_parent AS revision_parent_16, c0_.revision_version AS revision_version_17, c0_.post_type AS post_type_18, c0_.access_token AS access_token_19, c0_.image_pc AS image_pc_20, c0_.image_sp AS image_sp_21, c0_.thumbnail AS thumbnail_22, c0_.facility_id AS facility_id_23, c0_.created_by AS created_by_24, c0_.updated_by AS updated_by_25, c0_.language_id AS language_id_26, c0_.latest_approval_request_id AS latest_approval_request_id_27 FROM cms_mod_restaurant_genres c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2026-04-12 00:29:46") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2026-04-12 00:29:46") AND (c0_.public_date IS NULL OR c0_.public_date <= "2026-04-12")) ORDER BY c0_.sort_num ASC, c0_.id ASC;
|
| 2 |
4.81 ms |
SELECT t0.alt AS alt_1, t0.caption AS caption_2, t0.collation_code AS collation_code_3, t0.meta AS meta_4, t0.id AS id_5, t0.sort_num AS sort_num_6, t0.status AS status_7, t0.publish_at AS publish_at_8, t0.expires_at AS expires_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.title AS title_12, t0.item_id AS item_id_13, t14.alias AS alias_15, t14.path AS path_16, t14.mime AS mime_17, t14.file_size AS file_size_18, t14.width AS width_19, t14.height AS height_20, t14.alt AS alt_21, t14.caption AS caption_22, t14.link_url AS link_url_23, t14.content_data AS content_data_24, t14.thumb_path AS thumb_path_25, t14.hidden AS hidden_26, t14.collation_code AS collation_code_27, t14.is_locked AS is_locked_28, t14.meta AS meta_29, t14.cdn_domain AS cdn_domain_30, t14.id AS id_31, t14.sort_num AS sort_num_32, t14.status AS status_33, t14.publish_at AS publish_at_34, t14.expires_at AS expires_at_35, t14.created_at AS created_at_36, t14.updated_at AS updated_at_37, t14.title AS title_38, t14.revision_parent AS revision_parent_39, t14.revision_version AS revision_version_40, t14.post_type AS post_type_41, t14.access_token AS access_token_42, t14.category AS category_43, t14.facility_id AS facility_id_44, t14.original_id AS original_id_45, t14.created_by AS created_by_46, t14.updated_by AS updated_by_47, t14.latest_approval_request_id AS latest_approval_request_id_48, t0.thumb_item_id AS thumb_item_id_49, t50.alias AS alias_51, t50.path AS path_52, t50.mime AS mime_53, t50.file_size AS file_size_54, t50.width AS width_55, t50.height AS height_56, t50.alt AS alt_57, t50.caption AS caption_58, t50.link_url AS link_url_59, t50.content_data AS content_data_60, t50.thumb_path AS thumb_path_61, t50.hidden AS hidden_62, t50.collation_code AS collation_code_63, t50.is_locked AS is_locked_64, t50.meta AS meta_65, t50.cdn_domain AS cdn_domain_66, t50.id AS id_67, t50.sort_num AS sort_num_68, t50.status AS status_69, t50.publish_at AS publish_at_70, t50.expires_at AS expires_at_71, t50.created_at AS created_at_72, t50.updated_at AS updated_at_73, t50.title AS title_74, t50.revision_parent AS revision_parent_75, t50.revision_version AS revision_version_76, t50.post_type AS post_type_77, t50.access_token AS access_token_78, t50.category AS category_79, t50.facility_id AS facility_id_80, t50.original_id AS original_id_81, t50.created_by AS created_by_82, t50.updated_by AS updated_by_83, t50.latest_approval_request_id AS latest_approval_request_id_84, t0.group_id AS group_id_85, t0.created_by AS created_by_86, t87.username AS username_88, t87.username_canonical AS username_canonical_89, t87.enabled AS enabled_90, t87.last_login AS last_login_91, t87.confirmation_token AS confirmation_token_92, t87.password_requested_at AS password_requested_at_93, t87.roles AS roles_94, t87.id AS id_95, t87.display_name AS display_name_96, t87.sort_num AS sort_num_97, t87.email AS email_98, t87.email_canonical AS email_canonical_99, t87.salt AS salt_100, t87.password AS password_101, t87.group_id AS group_id_102, t87.facility_id AS facility_id_103, t0.updated_by AS updated_by_104, t105.username AS username_106, t105.username_canonical AS username_canonical_107, t105.enabled AS enabled_108, t105.last_login AS last_login_109, t105.confirmation_token AS confirmation_token_110, t105.password_requested_at AS password_requested_at_111, t105.roles AS roles_112, t105.id AS id_113, t105.display_name AS display_name_114, t105.sort_num AS sort_num_115, t105.email AS email_116, t105.email_canonical AS email_canonical_117, t105.salt AS salt_118, t105.password AS password_119, t105.group_id AS group_id_120, t105.facility_id AS facility_id_121 FROM cms_media_item_details t0 LEFT JOIN cms_media_items t14 ON t0.item_id = t14.id AND ((t14.post_type IN ("master")) AND (t14.status = 1 AND (t14.publish_at IS NULL OR t14.publish_at <= "2026-04-12 00:29:46") AND (t14.expires_at IS NULL OR t14.expires_at > "2026-04-12 00:29:46"))) LEFT JOIN cms_media_items t50 ON t0.thumb_item_id = t50.id AND ((t50.post_type IN ("master")) AND (t50.status = 1 AND (t50.publish_at IS NULL OR t50.publish_at <= "2026-04-12 00:29:46") AND (t50.expires_at IS NULL OR t50.expires_at > "2026-04-12 00:29:46"))) LEFT JOIN cms_user t87 ON t0.created_by = t87.id LEFT JOIN cms_user t105 ON t0.updated_by = t105.id WHERE t0.id IN (?) AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2026-04-12 00:29:46") AND (t0.expires_at IS NULL OR t0.expires_at > "2026-04-12 00:29:46")))
Parameters: [
[
405
406
409
410
413
414
]
]
SELECT
t0.alt AS alt_1,
t0.caption AS caption_2,
t0.collation_code AS collation_code_3,
t0.meta AS meta_4,
t0.id AS id_5,
t0.sort_num AS sort_num_6,
t0.status AS status_7,
t0.publish_at AS publish_at_8,
t0.expires_at AS expires_at_9,
t0.created_at AS created_at_10,
t0.updated_at AS updated_at_11,
t0.title AS title_12,
t0.item_id AS item_id_13,
t14.alias AS alias_15,
t14.path AS path_16,
t14.mime AS mime_17,
t14.file_size AS file_size_18,
t14.width AS width_19,
t14.height AS height_20,
t14.alt AS alt_21,
t14.caption AS caption_22,
t14.link_url AS link_url_23,
t14.content_data AS content_data_24,
t14.thumb_path AS thumb_path_25,
t14.hidden AS hidden_26,
t14.collation_code AS collation_code_27,
t14.is_locked AS is_locked_28,
t14.meta AS meta_29,
t14.cdn_domain AS cdn_domain_30,
t14.id AS id_31,
t14.sort_num AS sort_num_32,
t14.status AS status_33,
t14.publish_at AS publish_at_34,
t14.expires_at AS expires_at_35,
t14.created_at AS created_at_36,
t14.updated_at AS updated_at_37,
t14.title AS title_38,
t14.revision_parent AS revision_parent_39,
t14.revision_version AS revision_version_40,
t14.post_type AS post_type_41,
t14.access_token AS access_token_42,
t14.category AS category_43,
t14.facility_id AS facility_id_44,
t14.original_id AS original_id_45,
t14.created_by AS created_by_46,
t14.updated_by AS updated_by_47,
t14.latest_approval_request_id AS latest_approval_request_id_48,
t0.thumb_item_id AS thumb_item_id_49,
t50.alias AS alias_51,
t50.path AS path_52,
t50.mime AS mime_53,
t50.file_size AS file_size_54,
t50.width AS width_55,
t50.height AS height_56,
t50.alt AS alt_57,
t50.caption AS caption_58,
t50.link_url AS link_url_59,
t50.content_data AS content_data_60,
t50.thumb_path AS thumb_path_61,
t50.hidden AS hidden_62,
t50.collation_code AS collation_code_63,
t50.is_locked AS is_locked_64,
t50.meta AS meta_65,
t50.cdn_domain AS cdn_domain_66,
t50.id AS id_67,
t50.sort_num AS sort_num_68,
t50.status AS status_69,
t50.publish_at AS publish_at_70,
t50.expires_at AS expires_at_71,
t50.created_at AS created_at_72,
t50.updated_at AS updated_at_73,
t50.title AS title_74,
t50.revision_parent AS revision_parent_75,
t50.revision_version AS revision_version_76,
t50.post_type AS post_type_77,
t50.access_token AS access_token_78,
t50.category AS category_79,
t50.facility_id AS facility_id_80,
t50.original_id AS original_id_81,
t50.created_by AS created_by_82,
t50.updated_by AS updated_by_83,
t50.latest_approval_request_id AS latest_approval_request_id_84,
t0.group_id AS group_id_85,
t0.created_by AS created_by_86,
t87.username AS username_88,
t87.username_canonical AS username_canonical_89,
t87.enabled AS enabled_90,
t87.last_login AS last_login_91,
t87.confirmation_token AS confirmation_token_92,
t87.password_requested_at AS password_requested_at_93,
t87.roles AS roles_94,
t87.id AS id_95,
t87.display_name AS display_name_96,
t87.sort_num AS sort_num_97,
t87.email AS email_98,
t87.email_canonical AS email_canonical_99,
t87.salt AS salt_100,
t87.password AS password_101,
t87.group_id AS group_id_102,
t87.facility_id AS facility_id_103,
t0.updated_by AS updated_by_104,
t105.username AS username_106,
t105.username_canonical AS username_canonical_107,
t105.enabled AS enabled_108,
t105.last_login AS last_login_109,
t105.confirmation_token AS confirmation_token_110,
t105.password_requested_at AS password_requested_at_111,
t105.roles AS roles_112,
t105.id AS id_113,
t105.display_name AS display_name_114,
t105.sort_num AS sort_num_115,
t105.email AS email_116,
t105.email_canonical AS email_canonical_117,
t105.salt AS salt_118,
t105.password AS password_119,
t105.group_id AS group_id_120,
t105.facility_id AS facility_id_121
FROM
cms_media_item_details t0
LEFT JOIN cms_media_items t14 ON t0.item_id = t14.id
AND (
(
t14.post_type IN ("master")
)
AND (
t14.status = 1
AND (
t14.publish_at IS NULL
OR t14.publish_at <= "2026-04-12 00:29:46"
)
AND (
t14.expires_at IS NULL
OR t14.expires_at > "2026-04-12 00:29:46"
)
)
)
LEFT JOIN cms_media_items t50 ON t0.thumb_item_id = t50.id
AND (
(
t50.post_type IN ("master")
)
AND (
t50.status = 1
AND (
t50.publish_at IS NULL
OR t50.publish_at <= "2026-04-12 00:29:46"
)
AND (
t50.expires_at IS NULL
OR t50.expires_at > "2026-04-12 00:29:46"
)
)
)
LEFT JOIN cms_user t87 ON t0.created_by = t87.id
LEFT JOIN cms_user t105 ON t0.updated_by = t105.id
WHERE
t0.id IN (?)
AND (
(
t0.status = 1
AND (
t0.publish_at IS NULL
OR t0.publish_at <= "2026-04-12 00:29:46"
)
AND (
t0.expires_at IS NULL
OR t0.expires_at > "2026-04-12 00:29:46"
)
)
)
SELECT t0.alt AS alt_1, t0.caption AS caption_2, t0.collation_code AS collation_code_3, t0.meta AS meta_4, t0.id AS id_5, t0.sort_num AS sort_num_6, t0.status AS status_7, t0.publish_at AS publish_at_8, t0.expires_at AS expires_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.title AS title_12, t0.item_id AS item_id_13, t14.alias AS alias_15, t14.path AS path_16, t14.mime AS mime_17, t14.file_size AS file_size_18, t14.width AS width_19, t14.height AS height_20, t14.alt AS alt_21, t14.caption AS caption_22, t14.link_url AS link_url_23, t14.content_data AS content_data_24, t14.thumb_path AS thumb_path_25, t14.hidden AS hidden_26, t14.collation_code AS collation_code_27, t14.is_locked AS is_locked_28, t14.meta AS meta_29, t14.cdn_domain AS cdn_domain_30, t14.id AS id_31, t14.sort_num AS sort_num_32, t14.status AS status_33, t14.publish_at AS publish_at_34, t14.expires_at AS expires_at_35, t14.created_at AS created_at_36, t14.updated_at AS updated_at_37, t14.title AS title_38, t14.revision_parent AS revision_parent_39, t14.revision_version AS revision_version_40, t14.post_type AS post_type_41, t14.access_token AS access_token_42, t14.category AS category_43, t14.facility_id AS facility_id_44, t14.original_id AS original_id_45, t14.created_by AS created_by_46, t14.updated_by AS updated_by_47, t14.latest_approval_request_id AS latest_approval_request_id_48, t0.thumb_item_id AS thumb_item_id_49, t50.alias AS alias_51, t50.path AS path_52, t50.mime AS mime_53, t50.file_size AS file_size_54, t50.width AS width_55, t50.height AS height_56, t50.alt AS alt_57, t50.caption AS caption_58, t50.link_url AS link_url_59, t50.content_data AS content_data_60, t50.thumb_path AS thumb_path_61, t50.hidden AS hidden_62, t50.collation_code AS collation_code_63, t50.is_locked AS is_locked_64, t50.meta AS meta_65, t50.cdn_domain AS cdn_domain_66, t50.id AS id_67, t50.sort_num AS sort_num_68, t50.status AS status_69, t50.publish_at AS publish_at_70, t50.expires_at AS expires_at_71, t50.created_at AS created_at_72, t50.updated_at AS updated_at_73, t50.title AS title_74, t50.revision_parent AS revision_parent_75, t50.revision_version AS revision_version_76, t50.post_type AS post_type_77, t50.access_token AS access_token_78, t50.category AS category_79, t50.facility_id AS facility_id_80, t50.original_id AS original_id_81, t50.created_by AS created_by_82, t50.updated_by AS updated_by_83, t50.latest_approval_request_id AS latest_approval_request_id_84, t0.group_id AS group_id_85, t0.created_by AS created_by_86, t87.username AS username_88, t87.username_canonical AS username_canonical_89, t87.enabled AS enabled_90, t87.last_login AS last_login_91, t87.confirmation_token AS confirmation_token_92, t87.password_requested_at AS password_requested_at_93, t87.roles AS roles_94, t87.id AS id_95, t87.display_name AS display_name_96, t87.sort_num AS sort_num_97, t87.email AS email_98, t87.email_canonical AS email_canonical_99, t87.salt AS salt_100, t87.password AS password_101, t87.group_id AS group_id_102, t87.facility_id AS facility_id_103, t0.updated_by AS updated_by_104, t105.username AS username_106, t105.username_canonical AS username_canonical_107, t105.enabled AS enabled_108, t105.last_login AS last_login_109, t105.confirmation_token AS confirmation_token_110, t105.password_requested_at AS password_requested_at_111, t105.roles AS roles_112, t105.id AS id_113, t105.display_name AS display_name_114, t105.sort_num AS sort_num_115, t105.email AS email_116, t105.email_canonical AS email_canonical_117, t105.salt AS salt_118, t105.password AS password_119, t105.group_id AS group_id_120, t105.facility_id AS facility_id_121 FROM cms_media_item_details t0 LEFT JOIN cms_media_items t14 ON t0.item_id = t14.id AND ((t14.post_type IN ("master")) AND (t14.status = 1 AND (t14.publish_at IS NULL OR t14.publish_at <= "2026-04-12 00405, 406, 409, 410, 413, 414:46") AND (t14.expires_at IS NULL OR t14.expires_at > "2026-04-12 00:29:46"))) LEFT JOIN cms_media_items t50 ON t0.thumb_item_id = t50.id AND ((t50.post_type IN ("master")) AND (t50.status = 1 AND (t50.publish_at IS NULL OR t50.publish_at <= "2026-04-12 00:29:46") AND (t50.expires_at IS NULL OR t50.expires_at > "2026-04-12 00:29:46"))) LEFT JOIN cms_user t87 ON t0.created_by = t87.id LEFT JOIN cms_user t105 ON t0.updated_by = t105.id WHERE t0.id IN (?) AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2026-04-12 00:29:46") AND (t0.expires_at IS NULL OR t0.expires_at > "2026-04-12 00:29:46")));
|
| 3 |
2.39 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-12 00:29:46") AND (t0.expires_at IS NULL OR t0.expires_at > "2026-04-12 00:29:46")))
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-12 00:29:46"
)
AND (
t0.expires_at IS NULL
OR t0.expires_at > "2026-04-12 00:29:46"
)
)
)
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-12 00:29:46") AND (t0.expires_at IS NULL OR t0.expires_at > "2026-04-12 00:29:46")));
|
| 4 |
1.81 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);
|
| 5 |
2.54 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-12 00:29:46") AND (t0.expires_at IS NULL OR t0.expires_at > "2026-04-12 00:29:46")))
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-12 00:29:46"
)
AND (
t0.expires_at IS NULL
OR t0.expires_at > "2026-04-12 00:29:46"
)
)
)
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-12 00:29:46") AND (t0.expires_at IS NULL OR t0.expires_at > "2026-04-12 00:29:46")));
|
| 6 |
2.30 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-12 00:29:46") AND (t27.expires_at IS NULL OR t27.expires_at > "2026-04-12 00:29:46"))) 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-12 00:29:46"
)
AND (
t27.expires_at IS NULL
OR t27.expires_at > "2026-04-12 00:29:46"
)
)
)
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-12 001:46") AND (t27.expires_at IS NULL OR t27.expires_at > "2026-04-12 00:29:46"))) WHERE t0.id IN (?);
|
| 7 |
2.00 ms |
SELECT c0_.public_date AS public_date_0, c0_.customblock AS customblock_1, c0_.id AS id_2, c0_.sort_num AS sort_num_3, c0_.status AS status_4, c0_.publish_at AS publish_at_5, c0_.expires_at AS expires_at_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, c0_.title AS title_9, c0_.language_parent AS language_parent_10, c0_.language_alias AS language_alias_11, c0_.language_active AS language_active_12, c0_.revision_parent AS revision_parent_13, c0_.revision_version AS revision_version_14, c0_.post_type AS post_type_15, c0_.access_token AS access_token_16, c0_.thumbnail AS thumbnail_17, c0_.facility_id AS facility_id_18, c0_.created_by AS created_by_19, c0_.updated_by AS updated_by_20, c0_.language_id AS language_id_21, c0_.latest_approval_request_id AS latest_approval_request_id_22 FROM cms_mod_restaurant_time_by_cars c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2026-04-12 00:29:46") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2026-04-12 00:29:46") AND (c0_.public_date IS NULL OR c0_.public_date <= "2026-04-12")) ORDER BY c0_.sort_num ASC, c0_.id ASC
SELECT c0_.public_date AS public_date_0, c0_.customblock AS customblock_1, c0_.id AS id_2, c0_.sort_num AS sort_num_3, c0_.status AS status_4, c0_.publish_at AS publish_at_5, c0_.expires_at AS expires_at_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, c0_.title AS title_9, c0_.language_parent AS language_parent_10, c0_.language_alias AS language_alias_11, c0_.language_active AS language_active_12, c0_.revision_parent AS revision_parent_13, c0_.revision_version AS revision_version_14, c0_.post_type AS post_type_15, c0_.access_token AS access_token_16, c0_.thumbnail AS thumbnail_17, c0_.facility_id AS facility_id_18, c0_.created_by AS created_by_19, c0_.updated_by AS updated_by_20, c0_.language_id AS language_id_21, c0_.latest_approval_request_id AS latest_approval_request_id_22 FROM cms_mod_restaurant_time_by_cars c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2026-04-12 00:29:46") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2026-04-12 00:29:46") AND (c0_.public_date IS NULL OR c0_.public_date <= "2026-04-12")) ORDER BY c0_.sort_num ASC, c0_.id ASC;
|
| 8 |
2.03 ms |
SELECT c0_.alias AS alias_0, c0_.public_date AS public_date_1, c0_.customblock AS customblock_2, c0_.id AS id_3, c0_.sort_num AS sort_num_4, c0_.status AS status_5, c0_.publish_at AS publish_at_6, c0_.expires_at AS expires_at_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.title AS title_10, c0_.language_parent AS language_parent_11, c0_.language_alias AS language_alias_12, c0_.language_active AS language_active_13, c0_.revision_parent AS revision_parent_14, c0_.revision_version AS revision_version_15, c0_.post_type AS post_type_16, c0_.access_token AS access_token_17, c0_.thumbnail AS thumbnail_18, c0_.facility_id AS facility_id_19, c0_.created_by AS created_by_20, c0_.updated_by AS updated_by_21, c0_.language_id AS language_id_22, c0_.latest_approval_request_id AS latest_approval_request_id_23 FROM cms_mod_restaurant_scenes c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2026-04-12 00:29:46") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2026-04-12 00:29:46") AND (c0_.public_date IS NULL OR c0_.public_date <= "2026-04-12")) ORDER BY c0_.sort_num ASC, c0_.id ASC
SELECT c0_.alias AS alias_0, c0_.public_date AS public_date_1, c0_.customblock AS customblock_2, c0_.id AS id_3, c0_.sort_num AS sort_num_4, c0_.status AS status_5, c0_.publish_at AS publish_at_6, c0_.expires_at AS expires_at_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.title AS title_10, c0_.language_parent AS language_parent_11, c0_.language_alias AS language_alias_12, c0_.language_active AS language_active_13, c0_.revision_parent AS revision_parent_14, c0_.revision_version AS revision_version_15, c0_.post_type AS post_type_16, c0_.access_token AS access_token_17, c0_.thumbnail AS thumbnail_18, c0_.facility_id AS facility_id_19, c0_.created_by AS created_by_20, c0_.updated_by AS updated_by_21, c0_.language_id AS language_id_22, c0_.latest_approval_request_id AS latest_approval_request_id_23 FROM cms_mod_restaurant_scenes c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2026-04-12 00:29:46") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2026-04-12 00:29:46") AND (c0_.public_date IS NULL OR c0_.public_date <= "2026-04-12")) ORDER BY c0_.sort_num ASC, c0_.id ASC;
|
| 9 |
1.84 ms |
SELECT c0_.title_for_list AS title_for_list_0, c0_.alias AS alias_1, c0_.show_in_list AS show_in_list_2, c0_.background_color AS background_color_3, c0_.public_date AS public_date_4, c0_.customblock AS customblock_5, c0_.id AS id_6, c0_.sort_num AS sort_num_7, c0_.status AS status_8, c0_.publish_at AS publish_at_9, c0_.expires_at AS expires_at_10, c0_.created_at AS created_at_11, c0_.updated_at AS updated_at_12, c0_.title AS title_13, c0_.language_parent AS language_parent_14, c0_.language_alias AS language_alias_15, c0_.language_active AS language_active_16, c0_.revision_parent AS revision_parent_17, c0_.revision_version AS revision_version_18, c0_.post_type AS post_type_19, c0_.access_token AS access_token_20, c0_.thumbnail AS thumbnail_21, c0_.facility_id AS facility_id_22, c0_.created_by AS created_by_23, c0_.updated_by AS updated_by_24, c0_.language_id AS language_id_25, c0_.latest_approval_request_id AS latest_approval_request_id_26 FROM cms_mod_restaurant_feature c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2026-04-12 00:29:46") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2026-04-12 00:29:46") AND (c0_.public_date IS NULL OR c0_.public_date <= "2026-04-12")) ORDER BY c0_.sort_num ASC, c0_.id ASC
SELECT c0_.title_for_list AS title_for_list_0, c0_.alias AS alias_1, c0_.show_in_list AS show_in_list_2, c0_.background_color AS background_color_3, c0_.public_date AS public_date_4, c0_.customblock AS customblock_5, c0_.id AS id_6, c0_.sort_num AS sort_num_7, c0_.status AS status_8, c0_.publish_at AS publish_at_9, c0_.expires_at AS expires_at_10, c0_.created_at AS created_at_11, c0_.updated_at AS updated_at_12, c0_.title AS title_13, c0_.language_parent AS language_parent_14, c0_.language_alias AS language_alias_15, c0_.language_active AS language_active_16, c0_.revision_parent AS revision_parent_17, c0_.revision_version AS revision_version_18, c0_.post_type AS post_type_19, c0_.access_token AS access_token_20, c0_.thumbnail AS thumbnail_21, c0_.facility_id AS facility_id_22, c0_.created_by AS created_by_23, c0_.updated_by AS updated_by_24, c0_.language_id AS language_id_25, c0_.latest_approval_request_id AS latest_approval_request_id_26 FROM cms_mod_restaurant_feature c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2026-04-12 00:29:46") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2026-04-12 00:29:46") AND (c0_.public_date IS NULL OR c0_.public_date <= "2026-04-12")) ORDER BY c0_.sort_num ASC, c0_.id ASC;
|
| 10 |
2.00 ms |
SELECT c0_.title_for_list AS title_for_list_0, c0_.alias AS alias_1, c0_.show_in_list AS show_in_list_2, c0_.public_date AS public_date_3, c0_.customblock AS customblock_4, c0_.id AS id_5, c0_.sort_num AS sort_num_6, c0_.status AS status_7, c0_.publish_at AS publish_at_8, c0_.expires_at AS expires_at_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11, c0_.title AS title_12, c0_.language_parent AS language_parent_13, c0_.language_alias AS language_alias_14, c0_.language_active AS language_active_15, c0_.revision_parent AS revision_parent_16, c0_.revision_version AS revision_version_17, c0_.post_type AS post_type_18, c0_.access_token AS access_token_19, c0_.image_pc AS image_pc_20, c0_.image_sp AS image_sp_21, c0_.thumbnail AS thumbnail_22, c0_.facility_id AS facility_id_23, c0_.created_by AS created_by_24, c0_.updated_by AS updated_by_25, c0_.language_id AS language_id_26, c0_.latest_approval_request_id AS latest_approval_request_id_27 FROM cms_mod_restaurant_genres c0_ WHERE (c0_.alias = ?) AND (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2026-04-12 00:29:46") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2026-04-12 00:29:46") AND (c0_.public_date IS NULL OR c0_.public_date <= "2026-04-12")) ORDER BY c0_.sort_num ASC, c0_.id ASC
Parameters: [
"japanese_food"
]
SELECT c0_.title_for_list AS title_for_list_0, c0_.alias AS alias_1, c0_.show_in_list AS show_in_list_2, c0_.public_date AS public_date_3, c0_.customblock AS customblock_4, c0_.id AS id_5, c0_.sort_num AS sort_num_6, c0_.status AS status_7, c0_.publish_at AS publish_at_8, c0_.expires_at AS expires_at_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11, c0_.title AS title_12, c0_.language_parent AS language_parent_13, c0_.language_alias AS language_alias_14, c0_.language_active AS language_active_15, c0_.revision_parent AS revision_parent_16, c0_.revision_version AS revision_version_17, c0_.post_type AS post_type_18, c0_.access_token AS access_token_19, c0_.image_pc AS image_pc_20, c0_.image_sp AS image_sp_21, c0_.thumbnail AS thumbnail_22, c0_.facility_id AS facility_id_23, c0_.created_by AS created_by_24, c0_.updated_by AS updated_by_25, c0_.language_id AS language_id_26, c0_.latest_approval_request_id AS latest_approval_request_id_27 FROM cms_mod_restaurant_genres c0_ WHERE (c0_.alias = 'japanese_food') AND (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2026-04-12 00:29:46") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2026-04-12 00:29:46") AND (c0_.public_date IS NULL OR c0_.public_date <= "2026-04-12")) ORDER BY c0_.sort_num ASC, c0_.id ASC;
|
| 11 |
2.71 ms |
SELECT count(DISTINCT c0_.id) AS sclr_0 FROM cms_mod_restaurant_restaurants c0_ INNER JOIN cms_mod_restaurant_restaurants_genres c2_ ON c0_.id = c2_.restaurant_id INNER JOIN cms_mod_restaurant_genres c1_ ON c1_.id = c2_.genre_id AND (c1_.post_type IN ("master")) AND (c1_.status = 1 AND (c1_.publish_at IS NULL OR c1_.publish_at <= "2026-04-12 00:29:46") AND (c1_.expires_at IS NULL OR c1_.expires_at > "2026-04-12 00:29:46") AND (c1_.public_date IS NULL OR c1_.public_date <= "2026-04-12")) WHERE (c0_.status = ? AND c1_.alias = ?) AND (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2026-04-12 00:29:46") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2026-04-12 00:29:46") AND (c0_.public_date IS NULL OR c0_.public_date <= "2026-04-12"))
Parameters: [
1
"japanese_food"
]
SELECT count(DISTINCT c0_.id) AS sclr_0 FROM cms_mod_restaurant_restaurants c0_ INNER JOIN cms_mod_restaurant_restaurants_genres c2_ ON c0_.id = c2_.restaurant_id INNER JOIN cms_mod_restaurant_genres c1_ ON c1_.id = c2_.genre_id AND (c1_.post_type IN ("master")) AND (c1_.status = 1 AND (c1_.publish_at IS NULL OR c1_.publish_at <= "2026-04-12 001'japanese_food'") AND (c1_.expires_at IS NULL OR c1_.expires_at > "2026-04-12 00:29:46") AND (c1_.public_date IS NULL OR c1_.public_date <= "2026-04-12")) WHERE (c0_.status = ? AND c1_.alias = ?) AND (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2026-04-12 00:29:46") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2026-04-12 00:29:46") AND (c0_.public_date IS NULL OR c0_.public_date <= "2026-04-12"));
|
| 12 |
2.80 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.sort_num AS sort_num_1, c0_.this_month_recommendation AS this_month_recommendation_2 FROM cms_mod_restaurant_restaurants c0_ INNER JOIN cms_mod_restaurant_restaurants_genres c2_ ON c0_.id = c2_.restaurant_id INNER JOIN cms_mod_restaurant_genres c1_ ON c1_.id = c2_.genre_id AND (c1_.post_type IN ("master")) AND (c1_.status = 1 AND (c1_.publish_at IS NULL OR c1_.publish_at <= "2026-04-12 00:29:46") AND (c1_.expires_at IS NULL OR c1_.expires_at > "2026-04-12 00:29:46") AND (c1_.public_date IS NULL OR c1_.public_date <= "2026-04-12")) WHERE (c0_.status = ? AND c1_.alias = ?) AND (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2026-04-12 00:29:46") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2026-04-12 00:29:46") AND (c0_.public_date IS NULL OR c0_.public_date <= "2026-04-12")) ORDER BY c0_.sort_num ASC, c0_.this_month_recommendation DESC LIMIT 10
Parameters: [
1
"japanese_food"
]
SELECT DISTINCT c0_.id AS id_0, c0_.sort_num AS sort_num_1, c0_.this_month_recommendation AS this_month_recommendation_2 FROM cms_mod_restaurant_restaurants c0_ INNER JOIN cms_mod_restaurant_restaurants_genres c2_ ON c0_.id = c2_.restaurant_id INNER JOIN cms_mod_restaurant_genres c1_ ON c1_.id = c2_.genre_id AND (c1_.post_type IN ("master")) AND (c1_.status = 1 AND (c1_.publish_at IS NULL OR c1_.publish_at <= "2026-04-12 001'japanese_food'") AND (c1_.expires_at IS NULL OR c1_.expires_at > "2026-04-12 00:29:46") AND (c1_.public_date IS NULL OR c1_.public_date <= "2026-04-12")) WHERE (c0_.status = ? AND c1_.alias = ?) AND (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2026-04-12 00:29:46") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2026-04-12 00:29:46") AND (c0_.public_date IS NULL OR c0_.public_date <= "2026-04-12")) ORDER BY c0_.sort_num ASC, c0_.this_month_recommendation DESC LIMIT 10;
|
| 13 |
3.08 ms |
SELECT c0_.this_month_recommendation AS this_month_recommendation_0, c0_.title_kana AS title_kana_1, c0_.business_hours AS business_hours_2, c0_.business_hours_supplement AS business_hours_supplement_3, c0_.holiday AS holiday_4, c0_.holiday_supplement AS holiday_supplement_5, c0_.description AS description_6, c0_.map_url AS map_url_7, c0_.route AS route_8, c0_.tabelog_reserve AS tabelog_reserve_9, c0_.hotpepper_reserve AS hotpepper_reserve_10, c0_.ikyu_reserve AS ikyu_reserve_11, c0_.contact_etc AS contact_etc_12, c0_.tel AS tel_13, c0_.information AS information_14, c0_.budget AS budget_15, c0_.address AS address_16, c0_.access AS access_17, c0_.parking AS parking_18, c0_.seats AS seats_19, c0_.private_room AS private_room_20, c0_.payment AS payment_21, c0_.site_url_1 AS site_url_1_22, c0_.site_url_2 AS site_url_2_23, c0_.site_url_3 AS site_url_3_24, c0_.map_iframe AS map_iframe_25, c0_.public_date AS public_date_26, c0_.customblock AS customblock_27, c0_.id AS id_28, c0_.sort_num AS sort_num_29, c0_.status AS status_30, c0_.publish_at AS publish_at_31, c0_.expires_at AS expires_at_32, c0_.created_at AS created_at_33, c0_.updated_at AS updated_at_34, c0_.title AS title_35, c0_.language_parent AS language_parent_36, c0_.language_alias AS language_alias_37, c0_.language_active AS language_active_38, c0_.revision_parent AS revision_parent_39, c0_.revision_version AS revision_version_40, c0_.post_type AS post_type_41, c0_.access_token AS access_token_42, c0_.main_image AS main_image_43, c0_.time_by_car_id AS time_by_car_id_44, c0_.thumbnail AS thumbnail_45, c0_.facility_id AS facility_id_46, c0_.created_by AS created_by_47, c0_.updated_by AS updated_by_48, c0_.language_id AS language_id_49, c0_.latest_approval_request_id AS latest_approval_request_id_50 FROM cms_mod_restaurant_restaurants c0_ INNER JOIN cms_mod_restaurant_restaurants_genres c2_ ON c0_.id = c2_.restaurant_id INNER JOIN cms_mod_restaurant_genres c1_ ON c1_.id = c2_.genre_id AND (c1_.post_type IN ("master")) AND (c1_.status = 1 AND (c1_.publish_at IS NULL OR c1_.publish_at <= "2026-04-12 00:29:46") AND (c1_.expires_at IS NULL OR c1_.expires_at > "2026-04-12 00:29:46") AND (c1_.public_date IS NULL OR c1_.public_date <= "2026-04-12")) WHERE (c0_.status = ? AND c1_.alias = ? AND 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-12 00:29:46") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2026-04-12 00:29:46") AND (c0_.public_date IS NULL OR c0_.public_date <= "2026-04-12")) ORDER BY c0_.sort_num ASC, c0_.this_month_recommendation DESC
Parameters: [
1
"japanese_food"
[
29
45
30
46
31
77
32
78
33
79
]
]
SELECT
c0_.this_month_recommendation AS this_month_recommendation_0,
c0_.title_kana AS title_kana_1,
c0_.business_hours AS business_hours_2,
c0_.business_hours_supplement AS business_hours_supplement_3,
c0_.holiday AS holiday_4,
c0_.holiday_supplement AS holiday_supplement_5,
c0_.description AS description_6,
c0_.map_url AS map_url_7,
c0_.route AS route_8,
c0_.tabelog_reserve AS tabelog_reserve_9,
c0_.hotpepper_reserve AS hotpepper_reserve_10,
c0_.ikyu_reserve AS ikyu_reserve_11,
c0_.contact_etc AS contact_etc_12,
c0_.tel AS tel_13,
c0_.information AS information_14,
c0_.budget AS budget_15,
c0_.address AS address_16,
c0_.access AS access_17,
c0_.parking AS parking_18,
c0_.seats AS seats_19,
c0_.private_room AS private_room_20,
c0_.payment AS payment_21,
c0_.site_url_1 AS site_url_1_22,
c0_.site_url_2 AS site_url_2_23,
c0_.site_url_3 AS site_url_3_24,
c0_.map_iframe AS map_iframe_25,
c0_.public_date AS public_date_26,
c0_.customblock AS customblock_27,
c0_.id AS id_28,
c0_.sort_num AS sort_num_29,
c0_.status AS status_30,
c0_.publish_at AS publish_at_31,
c0_.expires_at AS expires_at_32,
c0_.created_at AS created_at_33,
c0_.updated_at AS updated_at_34,
c0_.title AS title_35,
c0_.language_parent AS language_parent_36,
c0_.language_alias AS language_alias_37,
c0_.language_active AS language_active_38,
c0_.revision_parent AS revision_parent_39,
c0_.revision_version AS revision_version_40,
c0_.post_type AS post_type_41,
c0_.access_token AS access_token_42,
c0_.main_image AS main_image_43,
c0_.time_by_car_id AS time_by_car_id_44,
c0_.thumbnail AS thumbnail_45,
c0_.facility_id AS facility_id_46,
c0_.created_by AS created_by_47,
c0_.updated_by AS updated_by_48,
c0_.language_id AS language_id_49,
c0_.latest_approval_request_id AS latest_approval_request_id_50
FROM
cms_mod_restaurant_restaurants c0_
INNER JOIN cms_mod_restaurant_restaurants_genres c2_ ON c0_.id = c2_.restaurant_id
INNER JOIN cms_mod_restaurant_genres c1_ ON c1_.id = c2_.genre_id
AND (
c1_.post_type IN ("master")
)
AND (
c1_.status = 1
AND (
c1_.publish_at IS NULL
OR c1_.publish_at <= "2026-04-12 00:29:46"
)
AND (
c1_.expires_at IS NULL
OR c1_.expires_at > "2026-04-12 00:29:46"
)
AND (
c1_.public_date IS NULL
OR c1_.public_date <= "2026-04-12"
)
)
WHERE
(
c0_.status = ?
AND c1_.alias = ?
AND 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-12 00:29:46"
)
AND (
c0_.expires_at IS NULL
OR c0_.expires_at > "2026-04-12 00:29:46"
)
AND (
c0_.public_date IS NULL
OR c0_.public_date <= "2026-04-12"
)
)
ORDER BY
c0_.sort_num ASC,
c0_.this_month_recommendation DESC
SELECT c0_.this_month_recommendation AS this_month_recommendation_0, c0_.title_kana AS title_kana_1, c0_.business_hours AS business_hours_2, c0_.business_hours_supplement AS business_hours_supplement_3, c0_.holiday AS holiday_4, c0_.holiday_supplement AS holiday_supplement_5, c0_.description AS description_6, c0_.map_url AS map_url_7, c0_.route AS route_8, c0_.tabelog_reserve AS tabelog_reserve_9, c0_.hotpepper_reserve AS hotpepper_reserve_10, c0_.ikyu_reserve AS ikyu_reserve_11, c0_.contact_etc AS contact_etc_12, c0_.tel AS tel_13, c0_.information AS information_14, c0_.budget AS budget_15, c0_.address AS address_16, c0_.access AS access_17, c0_.parking AS parking_18, c0_.seats AS seats_19, c0_.private_room AS private_room_20, c0_.payment AS payment_21, c0_.site_url_1 AS site_url_1_22, c0_.site_url_2 AS site_url_2_23, c0_.site_url_3 AS site_url_3_24, c0_.map_iframe AS map_iframe_25, c0_.public_date AS public_date_26, c0_.customblock AS customblock_27, c0_.id AS id_28, c0_.sort_num AS sort_num_29, c0_.status AS status_30, c0_.publish_at AS publish_at_31, c0_.expires_at AS expires_at_32, c0_.created_at AS created_at_33, c0_.updated_at AS updated_at_34, c0_.title AS title_35, c0_.language_parent AS language_parent_36, c0_.language_alias AS language_alias_37, c0_.language_active AS language_active_38, c0_.revision_parent AS revision_parent_39, c0_.revision_version AS revision_version_40, c0_.post_type AS post_type_41, c0_.access_token AS access_token_42, c0_.main_image AS main_image_43, c0_.time_by_car_id AS time_by_car_id_44, c0_.thumbnail AS thumbnail_45, c0_.facility_id AS facility_id_46, c0_.created_by AS created_by_47, c0_.updated_by AS updated_by_48, c0_.language_id AS language_id_49, c0_.latest_approval_request_id AS latest_approval_request_id_50 FROM cms_mod_restaurant_restaurants c0_ INNER JOIN cms_mod_restaurant_restaurants_genres c2_ ON c0_.id = c2_.restaurant_id INNER JOIN cms_mod_restaurant_genres c1_ ON c1_.id = c2_.genre_id AND (c1_.post_type IN ("master")) AND (c1_.status = 1 AND (c1_.publish_at IS NULL OR c1_.publish_at <= "2026-04-12 001'japanese_food'") AND (c1_.expires_at IS NULL OR c1_.expires_at > "2026-04-12 0029, 45, 30, 46, 31, 77, 32, 78, 33, 79:46") AND (c1_.public_date IS NULL OR c1_.public_date <= "2026-04-12")) WHERE (c0_.status = ? AND c1_.alias = ? AND 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-12 00:29:46") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2026-04-12 00:29:46") AND (c0_.public_date IS NULL OR c0_.public_date <= "2026-04-12")) ORDER BY c0_.sort_num ASC, c0_.this_month_recommendation DESC;
|
| 14 |
1.86 ms |
SELECT c0_.link_url AS link_url_0, c0_.target AS target_1, c0_.public_date AS public_date_2, c0_.customblock AS customblock_3, c0_.id AS id_4, c0_.sort_num AS sort_num_5, c0_.status AS status_6, c0_.publish_at AS publish_at_7, c0_.expires_at AS expires_at_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.title AS title_11, c0_.language_parent AS language_parent_12, c0_.language_alias AS language_alias_13, c0_.language_active AS language_active_14, c0_.revision_parent AS revision_parent_15, c0_.revision_version AS revision_version_16, c0_.post_type AS post_type_17, c0_.access_token AS access_token_18, c0_.image AS image_19, c0_.image_sp AS image_sp_20, c0_.thumbnail AS thumbnail_21, c0_.facility_id AS facility_id_22, c0_.created_by AS created_by_23, c0_.updated_by AS updated_by_24, c0_.language_id AS language_id_25, c0_.latest_approval_request_id AS latest_approval_request_id_26 FROM cms_mod_restaurant_banner c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2026-04-12 00:29:46") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2026-04-12 00:29:46") AND (c0_.public_date IS NULL OR c0_.public_date <= "2026-04-12")) ORDER BY c0_.sort_num ASC LIMIT 1
SELECT c0_.link_url AS link_url_0, c0_.target AS target_1, c0_.public_date AS public_date_2, c0_.customblock AS customblock_3, c0_.id AS id_4, c0_.sort_num AS sort_num_5, c0_.status AS status_6, c0_.publish_at AS publish_at_7, c0_.expires_at AS expires_at_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.title AS title_11, c0_.language_parent AS language_parent_12, c0_.language_alias AS language_alias_13, c0_.language_active AS language_active_14, c0_.revision_parent AS revision_parent_15, c0_.revision_version AS revision_version_16, c0_.post_type AS post_type_17, c0_.access_token AS access_token_18, c0_.image AS image_19, c0_.image_sp AS image_sp_20, c0_.thumbnail AS thumbnail_21, c0_.facility_id AS facility_id_22, c0_.created_by AS created_by_23, c0_.updated_by AS updated_by_24, c0_.language_id AS language_id_25, c0_.latest_approval_request_id AS latest_approval_request_id_26 FROM cms_mod_restaurant_banner c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2026-04-12 00:29:46") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2026-04-12 00:29:46") AND (c0_.public_date IS NULL OR c0_.public_date <= "2026-04-12")) ORDER BY c0_.sort_num ASC LIMIT 1;
|
| 15 |
2.89 ms |
SELECT t0.alt AS alt_1, t0.caption AS caption_2, t0.collation_code AS collation_code_3, t0.meta AS meta_4, t0.id AS id_5, t0.sort_num AS sort_num_6, t0.status AS status_7, t0.publish_at AS publish_at_8, t0.expires_at AS expires_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.title AS title_12, t0.item_id AS item_id_13, t14.alias AS alias_15, t14.path AS path_16, t14.mime AS mime_17, t14.file_size AS file_size_18, t14.width AS width_19, t14.height AS height_20, t14.alt AS alt_21, t14.caption AS caption_22, t14.link_url AS link_url_23, t14.content_data AS content_data_24, t14.thumb_path AS thumb_path_25, t14.hidden AS hidden_26, t14.collation_code AS collation_code_27, t14.is_locked AS is_locked_28, t14.meta AS meta_29, t14.cdn_domain AS cdn_domain_30, t14.id AS id_31, t14.sort_num AS sort_num_32, t14.status AS status_33, t14.publish_at AS publish_at_34, t14.expires_at AS expires_at_35, t14.created_at AS created_at_36, t14.updated_at AS updated_at_37, t14.title AS title_38, t14.revision_parent AS revision_parent_39, t14.revision_version AS revision_version_40, t14.post_type AS post_type_41, t14.access_token AS access_token_42, t14.category AS category_43, t14.facility_id AS facility_id_44, t14.original_id AS original_id_45, t14.created_by AS created_by_46, t14.updated_by AS updated_by_47, t14.latest_approval_request_id AS latest_approval_request_id_48, t0.thumb_item_id AS thumb_item_id_49, t50.alias AS alias_51, t50.path AS path_52, t50.mime AS mime_53, t50.file_size AS file_size_54, t50.width AS width_55, t50.height AS height_56, t50.alt AS alt_57, t50.caption AS caption_58, t50.link_url AS link_url_59, t50.content_data AS content_data_60, t50.thumb_path AS thumb_path_61, t50.hidden AS hidden_62, t50.collation_code AS collation_code_63, t50.is_locked AS is_locked_64, t50.meta AS meta_65, t50.cdn_domain AS cdn_domain_66, t50.id AS id_67, t50.sort_num AS sort_num_68, t50.status AS status_69, t50.publish_at AS publish_at_70, t50.expires_at AS expires_at_71, t50.created_at AS created_at_72, t50.updated_at AS updated_at_73, t50.title AS title_74, t50.revision_parent AS revision_parent_75, t50.revision_version AS revision_version_76, t50.post_type AS post_type_77, t50.access_token AS access_token_78, t50.category AS category_79, t50.facility_id AS facility_id_80, t50.original_id AS original_id_81, t50.created_by AS created_by_82, t50.updated_by AS updated_by_83, t50.latest_approval_request_id AS latest_approval_request_id_84, t0.group_id AS group_id_85, t0.created_by AS created_by_86, t87.username AS username_88, t87.username_canonical AS username_canonical_89, t87.enabled AS enabled_90, t87.last_login AS last_login_91, t87.confirmation_token AS confirmation_token_92, t87.password_requested_at AS password_requested_at_93, t87.roles AS roles_94, t87.id AS id_95, t87.display_name AS display_name_96, t87.sort_num AS sort_num_97, t87.email AS email_98, t87.email_canonical AS email_canonical_99, t87.salt AS salt_100, t87.password AS password_101, t87.group_id AS group_id_102, t87.facility_id AS facility_id_103, t0.updated_by AS updated_by_104, t105.username AS username_106, t105.username_canonical AS username_canonical_107, t105.enabled AS enabled_108, t105.last_login AS last_login_109, t105.confirmation_token AS confirmation_token_110, t105.password_requested_at AS password_requested_at_111, t105.roles AS roles_112, t105.id AS id_113, t105.display_name AS display_name_114, t105.sort_num AS sort_num_115, t105.email AS email_116, t105.email_canonical AS email_canonical_117, t105.salt AS salt_118, t105.password AS password_119, t105.group_id AS group_id_120, t105.facility_id AS facility_id_121 FROM cms_media_item_details t0 LEFT JOIN cms_media_items t14 ON t0.item_id = t14.id AND ((t14.post_type IN ("master")) AND (t14.status = 1 AND (t14.publish_at IS NULL OR t14.publish_at <= "2026-04-12 00:29:46") AND (t14.expires_at IS NULL OR t14.expires_at > "2026-04-12 00:29:46"))) LEFT JOIN cms_media_items t50 ON t0.thumb_item_id = t50.id AND ((t50.post_type IN ("master")) AND (t50.status = 1 AND (t50.publish_at IS NULL OR t50.publish_at <= "2026-04-12 00:29:46") AND (t50.expires_at IS NULL OR t50.expires_at > "2026-04-12 00:29:46"))) LEFT JOIN cms_user t87 ON t0.created_by = t87.id LEFT JOIN cms_user t105 ON t0.updated_by = t105.id WHERE t0.id IN (?) AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2026-04-12 00:29:46") AND (t0.expires_at IS NULL OR t0.expires_at > "2026-04-12 00:29:46")))
Parameters: [
[
323
324
]
]
SELECT
t0.alt AS alt_1,
t0.caption AS caption_2,
t0.collation_code AS collation_code_3,
t0.meta AS meta_4,
t0.id AS id_5,
t0.sort_num AS sort_num_6,
t0.status AS status_7,
t0.publish_at AS publish_at_8,
t0.expires_at AS expires_at_9,
t0.created_at AS created_at_10,
t0.updated_at AS updated_at_11,
t0.title AS title_12,
t0.item_id AS item_id_13,
t14.alias AS alias_15,
t14.path AS path_16,
t14.mime AS mime_17,
t14.file_size AS file_size_18,
t14.width AS width_19,
t14.height AS height_20,
t14.alt AS alt_21,
t14.caption AS caption_22,
t14.link_url AS link_url_23,
t14.content_data AS content_data_24,
t14.thumb_path AS thumb_path_25,
t14.hidden AS hidden_26,
t14.collation_code AS collation_code_27,
t14.is_locked AS is_locked_28,
t14.meta AS meta_29,
t14.cdn_domain AS cdn_domain_30,
t14.id AS id_31,
t14.sort_num AS sort_num_32,
t14.status AS status_33,
t14.publish_at AS publish_at_34,
t14.expires_at AS expires_at_35,
t14.created_at AS created_at_36,
t14.updated_at AS updated_at_37,
t14.title AS title_38,
t14.revision_parent AS revision_parent_39,
t14.revision_version AS revision_version_40,
t14.post_type AS post_type_41,
t14.access_token AS access_token_42,
t14.category AS category_43,
t14.facility_id AS facility_id_44,
t14.original_id AS original_id_45,
t14.created_by AS created_by_46,
t14.updated_by AS updated_by_47,
t14.latest_approval_request_id AS latest_approval_request_id_48,
t0.thumb_item_id AS thumb_item_id_49,
t50.alias AS alias_51,
t50.path AS path_52,
t50.mime AS mime_53,
t50.file_size AS file_size_54,
t50.width AS width_55,
t50.height AS height_56,
t50.alt AS alt_57,
t50.caption AS caption_58,
t50.link_url AS link_url_59,
t50.content_data AS content_data_60,
t50.thumb_path AS thumb_path_61,
t50.hidden AS hidden_62,
t50.collation_code AS collation_code_63,
t50.is_locked AS is_locked_64,
t50.meta AS meta_65,
t50.cdn_domain AS cdn_domain_66,
t50.id AS id_67,
t50.sort_num AS sort_num_68,
t50.status AS status_69,
t50.publish_at AS publish_at_70,
t50.expires_at AS expires_at_71,
t50.created_at AS created_at_72,
t50.updated_at AS updated_at_73,
t50.title AS title_74,
t50.revision_parent AS revision_parent_75,
t50.revision_version AS revision_version_76,
t50.post_type AS post_type_77,
t50.access_token AS access_token_78,
t50.category AS category_79,
t50.facility_id AS facility_id_80,
t50.original_id AS original_id_81,
t50.created_by AS created_by_82,
t50.updated_by AS updated_by_83,
t50.latest_approval_request_id AS latest_approval_request_id_84,
t0.group_id AS group_id_85,
t0.created_by AS created_by_86,
t87.username AS username_88,
t87.username_canonical AS username_canonical_89,
t87.enabled AS enabled_90,
t87.last_login AS last_login_91,
t87.confirmation_token AS confirmation_token_92,
t87.password_requested_at AS password_requested_at_93,
t87.roles AS roles_94,
t87.id AS id_95,
t87.display_name AS display_name_96,
t87.sort_num AS sort_num_97,
t87.email AS email_98,
t87.email_canonical AS email_canonical_99,
t87.salt AS salt_100,
t87.password AS password_101,
t87.group_id AS group_id_102,
t87.facility_id AS facility_id_103,
t0.updated_by AS updated_by_104,
t105.username AS username_106,
t105.username_canonical AS username_canonical_107,
t105.enabled AS enabled_108,
t105.last_login AS last_login_109,
t105.confirmation_token AS confirmation_token_110,
t105.password_requested_at AS password_requested_at_111,
t105.roles AS roles_112,
t105.id AS id_113,
t105.display_name AS display_name_114,
t105.sort_num AS sort_num_115,
t105.email AS email_116,
t105.email_canonical AS email_canonical_117,
t105.salt AS salt_118,
t105.password AS password_119,
t105.group_id AS group_id_120,
t105.facility_id AS facility_id_121
FROM
cms_media_item_details t0
LEFT JOIN cms_media_items t14 ON t0.item_id = t14.id
AND (
(
t14.post_type IN ("master")
)
AND (
t14.status = 1
AND (
t14.publish_at IS NULL
OR t14.publish_at <= "2026-04-12 00:29:46"
)
AND (
t14.expires_at IS NULL
OR t14.expires_at > "2026-04-12 00:29:46"
)
)
)
LEFT JOIN cms_media_items t50 ON t0.thumb_item_id = t50.id
AND (
(
t50.post_type IN ("master")
)
AND (
t50.status = 1
AND (
t50.publish_at IS NULL
OR t50.publish_at <= "2026-04-12 00:29:46"
)
AND (
t50.expires_at IS NULL
OR t50.expires_at > "2026-04-12 00:29:46"
)
)
)
LEFT JOIN cms_user t87 ON t0.created_by = t87.id
LEFT JOIN cms_user t105 ON t0.updated_by = t105.id
WHERE
t0.id IN (?)
AND (
(
t0.status = 1
AND (
t0.publish_at IS NULL
OR t0.publish_at <= "2026-04-12 00:29:46"
)
AND (
t0.expires_at IS NULL
OR t0.expires_at > "2026-04-12 00:29:46"
)
)
)
SELECT t0.alt AS alt_1, t0.caption AS caption_2, t0.collation_code AS collation_code_3, t0.meta AS meta_4, t0.id AS id_5, t0.sort_num AS sort_num_6, t0.status AS status_7, t0.publish_at AS publish_at_8, t0.expires_at AS expires_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.title AS title_12, t0.item_id AS item_id_13, t14.alias AS alias_15, t14.path AS path_16, t14.mime AS mime_17, t14.file_size AS file_size_18, t14.width AS width_19, t14.height AS height_20, t14.alt AS alt_21, t14.caption AS caption_22, t14.link_url AS link_url_23, t14.content_data AS content_data_24, t14.thumb_path AS thumb_path_25, t14.hidden AS hidden_26, t14.collation_code AS collation_code_27, t14.is_locked AS is_locked_28, t14.meta AS meta_29, t14.cdn_domain AS cdn_domain_30, t14.id AS id_31, t14.sort_num AS sort_num_32, t14.status AS status_33, t14.publish_at AS publish_at_34, t14.expires_at AS expires_at_35, t14.created_at AS created_at_36, t14.updated_at AS updated_at_37, t14.title AS title_38, t14.revision_parent AS revision_parent_39, t14.revision_version AS revision_version_40, t14.post_type AS post_type_41, t14.access_token AS access_token_42, t14.category AS category_43, t14.facility_id AS facility_id_44, t14.original_id AS original_id_45, t14.created_by AS created_by_46, t14.updated_by AS updated_by_47, t14.latest_approval_request_id AS latest_approval_request_id_48, t0.thumb_item_id AS thumb_item_id_49, t50.alias AS alias_51, t50.path AS path_52, t50.mime AS mime_53, t50.file_size AS file_size_54, t50.width AS width_55, t50.height AS height_56, t50.alt AS alt_57, t50.caption AS caption_58, t50.link_url AS link_url_59, t50.content_data AS content_data_60, t50.thumb_path AS thumb_path_61, t50.hidden AS hidden_62, t50.collation_code AS collation_code_63, t50.is_locked AS is_locked_64, t50.meta AS meta_65, t50.cdn_domain AS cdn_domain_66, t50.id AS id_67, t50.sort_num AS sort_num_68, t50.status AS status_69, t50.publish_at AS publish_at_70, t50.expires_at AS expires_at_71, t50.created_at AS created_at_72, t50.updated_at AS updated_at_73, t50.title AS title_74, t50.revision_parent AS revision_parent_75, t50.revision_version AS revision_version_76, t50.post_type AS post_type_77, t50.access_token AS access_token_78, t50.category AS category_79, t50.facility_id AS facility_id_80, t50.original_id AS original_id_81, t50.created_by AS created_by_82, t50.updated_by AS updated_by_83, t50.latest_approval_request_id AS latest_approval_request_id_84, t0.group_id AS group_id_85, t0.created_by AS created_by_86, t87.username AS username_88, t87.username_canonical AS username_canonical_89, t87.enabled AS enabled_90, t87.last_login AS last_login_91, t87.confirmation_token AS confirmation_token_92, t87.password_requested_at AS password_requested_at_93, t87.roles AS roles_94, t87.id AS id_95, t87.display_name AS display_name_96, t87.sort_num AS sort_num_97, t87.email AS email_98, t87.email_canonical AS email_canonical_99, t87.salt AS salt_100, t87.password AS password_101, t87.group_id AS group_id_102, t87.facility_id AS facility_id_103, t0.updated_by AS updated_by_104, t105.username AS username_106, t105.username_canonical AS username_canonical_107, t105.enabled AS enabled_108, t105.last_login AS last_login_109, t105.confirmation_token AS confirmation_token_110, t105.password_requested_at AS password_requested_at_111, t105.roles AS roles_112, t105.id AS id_113, t105.display_name AS display_name_114, t105.sort_num AS sort_num_115, t105.email AS email_116, t105.email_canonical AS email_canonical_117, t105.salt AS salt_118, t105.password AS password_119, t105.group_id AS group_id_120, t105.facility_id AS facility_id_121 FROM cms_media_item_details t0 LEFT JOIN cms_media_items t14 ON t0.item_id = t14.id AND ((t14.post_type IN ("master")) AND (t14.status = 1 AND (t14.publish_at IS NULL OR t14.publish_at <= "2026-04-12 00323, 324:46") AND (t14.expires_at IS NULL OR t14.expires_at > "2026-04-12 00:29:46"))) LEFT JOIN cms_media_items t50 ON t0.thumb_item_id = t50.id AND ((t50.post_type IN ("master")) AND (t50.status = 1 AND (t50.publish_at IS NULL OR t50.publish_at <= "2026-04-12 00:29:46") AND (t50.expires_at IS NULL OR t50.expires_at > "2026-04-12 00:29:46"))) LEFT JOIN cms_user t87 ON t0.created_by = t87.id LEFT JOIN cms_user t105 ON t0.updated_by = t105.id WHERE t0.id IN (?) AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2026-04-12 00:29:46") AND (t0.expires_at IS NULL OR t0.expires_at > "2026-04-12 00:29:46")));
|