6.06 ms
(28.25%)
|
1 |
SELECT t0.this_month_recommendation AS this_month_recommendation_1, t0.title_kana AS title_kana_2, t0.business_hours AS business_hours_3, t0.business_hours_supplement AS business_hours_supplement_4, t0.holiday AS holiday_5, t0.holiday_supplement AS holiday_supplement_6, t0.description AS description_7, t0.map_url AS map_url_8, t0.route AS route_9, t0.tabelog_reserve AS tabelog_reserve_10, t0.hotpepper_reserve AS hotpepper_reserve_11, t0.ikyu_reserve AS ikyu_reserve_12, t0.contact_etc AS contact_etc_13, t0.tel AS tel_14, t0.information AS information_15, t0.budget AS budget_16, t0.address AS address_17, t0.access AS access_18, t0.parking AS parking_19, t0.seats AS seats_20, t0.private_room AS private_room_21, t0.payment AS payment_22, t0.site_url_1 AS site_url_1_23, t0.site_url_2 AS site_url_2_24, t0.site_url_3 AS site_url_3_25, t0.map_iframe AS map_iframe_26, t0.public_date AS public_date_27, t0.customblock AS customblock_28, t0.id AS id_29, t0.sort_num AS sort_num_30, t0.status AS status_31, t0.publish_at AS publish_at_32, t0.expires_at AS expires_at_33, t0.created_at AS created_at_34, t0.updated_at AS updated_at_35, t0.title AS title_36, t0.language_parent AS language_parent_37, t0.language_alias AS language_alias_38, t0.language_active AS language_active_39, t0.revision_parent AS revision_parent_40, t0.revision_version AS revision_version_41, t0.post_type AS post_type_42, t0.access_token AS access_token_43, t0.main_image AS main_image_44, t45.meta AS meta_46, t45.id AS id_47, t45.sort_num AS sort_num_48, t45.status AS status_49, t45.publish_at AS publish_at_50, t45.expires_at AS expires_at_51, t45.created_at AS created_at_52, t45.updated_at AS updated_at_53, t45.title AS title_54, t45.created_by AS created_by_55, t45.updated_by AS updated_by_56, t0.time_by_car_id AS time_by_car_id_57, t58.public_date AS public_date_59, t58.customblock AS customblock_60, t58.id AS id_61, t58.sort_num AS sort_num_62, t58.status AS status_63, t58.publish_at AS publish_at_64, t58.expires_at AS expires_at_65, t58.created_at AS created_at_66, t58.updated_at AS updated_at_67, t58.title AS title_68, t58.language_parent AS language_parent_69, t58.language_alias AS language_alias_70, t58.language_active AS language_active_71, t58.revision_parent AS revision_parent_72, t58.revision_version AS revision_version_73, t58.post_type AS post_type_74, t58.access_token AS access_token_75, t58.thumbnail AS thumbnail_76, t58.facility_id AS facility_id_77, t58.created_by AS created_by_78, t58.updated_by AS updated_by_79, t58.language_id AS language_id_80, t58.latest_approval_request_id AS latest_approval_request_id_81, t0.thumbnail AS thumbnail_82, t83.alt AS alt_84, t83.caption AS caption_85, t83.collation_code AS collation_code_86, t83.meta AS meta_87, t83.id AS id_88, t83.sort_num AS sort_num_89, t83.status AS status_90, t83.publish_at AS publish_at_91, t83.expires_at AS expires_at_92, t83.created_at AS created_at_93, t83.updated_at AS updated_at_94, t83.title AS title_95, t83.item_id AS item_id_96, t83.thumb_item_id AS thumb_item_id_97, t83.group_id AS group_id_98, t83.created_by AS created_by_99, t83.updated_by AS updated_by_100, t0.facility_id AS facility_id_101, t102.code AS code_103, t102.title AS title_104, t102.intro_text AS intro_text_105, t102.zip AS zip_106, t102.address AS address_107, t102.building AS building_108, t102.google_maps_url AS google_maps_url_109, t102.phone AS phone_110, t102.website AS website_111, t102.opening_hours AS opening_hours_112, t102.holiday AS holiday_113, t102.access AS access_114, t102.access_car AS access_car_115, t102.access_train AS access_train_116, t102.id AS id_117, t102.sort_num AS sort_num_118, t102.status AS status_119, t102.publish_at AS publish_at_120, t102.expires_at AS expires_at_121, t102.created_at AS created_at_122, t102.updated_at AS updated_at_123, t102.area_id AS area_id_124, t102.prefecture_id AS prefecture_id_125, t102.logo_image AS logo_image_126, t102.main_image AS main_image_127, t102.created_by AS created_by_128, t102.updated_by AS updated_by_129, t0.created_by AS created_by_130, t131.username AS username_132, t131.username_canonical AS username_canonical_133, t131.enabled AS enabled_134, t131.last_login AS last_login_135, t131.confirmation_token AS confirmation_token_136, t131.password_requested_at AS password_requested_at_137, t131.roles AS roles_138, t131.id AS id_139, t131.display_name AS display_name_140, t131.sort_num AS sort_num_141, t131.email AS email_142, t131.email_canonical AS email_canonical_143, t131.salt AS salt_144, t131.password AS password_145, t131.group_id AS group_id_146, t131.facility_id AS facility_id_147, t0.updated_by AS updated_by_148, t149.username AS username_150, t149.username_canonical AS username_canonical_151, t149.enabled AS enabled_152, t149.last_login AS last_login_153, t149.confirmation_token AS confirmation_token_154, t149.password_requested_at AS password_requested_at_155, t149.roles AS roles_156, t149.id AS id_157, t149.display_name AS display_name_158, t149.sort_num AS sort_num_159, t149.email AS email_160, t149.email_canonical AS email_canonical_161, t149.salt AS salt_162, t149.password AS password_163, t149.group_id AS group_id_164, t149.facility_id AS facility_id_165, t0.language_id AS language_id_166, t167.alias AS alias_168, t167.translate_key AS translate_key_169, t167.target_key AS target_key_170, t167.id AS id_171, t167.sort_num AS sort_num_172, t167.status AS status_173, t167.publish_at AS publish_at_174, t167.expires_at AS expires_at_175, t167.created_at AS created_at_176, t167.updated_at AS updated_at_177, t167.title AS title_178, t167.created_by AS created_by_179, t167.updated_by AS updated_by_180, t0.latest_approval_request_id AS latest_approval_request_id_181, t182.id AS id_183, t182.handler_name AS handler_name_184, t182.title AS title_185, t182.target_id AS target_id_186, t182.request_type AS request_type_187, t182.moderated_at AS moderated_at_188, t182.approval_status AS approval_status_189, t182.comment AS comment_190, t182.created_at AS created_at_191, t182.updated_at AS updated_at_192, t182.facility_id AS facility_id_193, t182.requested_by AS requested_by_194, t182.moderated_by AS moderated_by_195 FROM cms_mod_restaurant_restaurants t0 LEFT JOIN cms_media_groups t45 ON t0.main_image = t45.id AND ((t45.status = 1 AND (t45.publish_at IS NULL OR t45.publish_at <= "2025-09-17 08:12:40") AND (t45.expires_at IS NULL OR t45.expires_at > "2025-09-17 08:12:40"))) LEFT JOIN cms_mod_restaurant_time_by_cars t58 ON t0.time_by_car_id = t58.id AND ((t58.post_type IN ("master")) AND (t58.status = 1 AND (t58.publish_at IS NULL OR t58.publish_at <= "2025-09-17 08:12:40") AND (t58.expires_at IS NULL OR t58.expires_at > "2025-09-17 08:12:40") AND (t58.public_date IS NULL OR t58.public_date <= "2025-09-17"))) LEFT JOIN cms_media_item_details t83 ON t0.thumbnail = t83.id AND ((t83.status = 1 AND (t83.publish_at IS NULL OR t83.publish_at <= "2025-09-17 08:12:40") AND (t83.expires_at IS NULL OR t83.expires_at > "2025-09-17 08:12:40"))) LEFT JOIN cms_facility t102 ON t0.facility_id = t102.id AND ((t102.status = 1 AND (t102.publish_at IS NULL OR t102.publish_at <= "2025-09-17 08:12:40") AND (t102.expires_at IS NULL OR t102.expires_at > "2025-09-17 08:12:40"))) LEFT JOIN cms_user t131 ON t0.created_by = t131.id LEFT JOIN cms_user t149 ON t0.updated_by = t149.id LEFT JOIN cms_master_languages t167 ON t0.language_id = t167.id AND ((t167.status = 1 AND (t167.publish_at IS NULL OR t167.publish_at <= "2025-09-17 08:12:40") AND (t167.expires_at IS NULL OR t167.expires_at > "2025-09-17 08:12:40"))) LEFT JOIN cms_approval_requests t182 ON t0.latest_approval_request_id = t182.id WHERE t0.id = ? AND ((t0.post_type IN ("master")) AND (t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2025-09-17 08:12:40") AND (t0.expires_at IS NULL OR t0.expires_at > "2025-09-17 08:12:40") AND (t0.public_date IS NULL OR t0.public_date <= "2025-09-17"))) LIMIT 1
SELECT
t0.this_month_recommendation AS this_month_recommendation_1,
t0.title_kana AS title_kana_2,
t0.business_hours AS business_hours_3,
t0.business_hours_supplement AS business_hours_supplement_4,
t0.holiday AS holiday_5,
t0.holiday_supplement AS holiday_supplement_6,
t0.description AS description_7,
t0.map_url AS map_url_8,
t0.route AS route_9,
t0.tabelog_reserve AS tabelog_reserve_10,
t0.hotpepper_reserve AS hotpepper_reserve_11,
t0.ikyu_reserve AS ikyu_reserve_12,
t0.contact_etc AS contact_etc_13,
t0.tel AS tel_14,
t0.information AS information_15,
t0.budget AS budget_16,
t0.address AS address_17,
t0.access AS access_18,
t0.parking AS parking_19,
t0.seats AS seats_20,
t0.private_room AS private_room_21,
t0.payment AS payment_22,
t0.site_url_1 AS site_url_1_23,
t0.site_url_2 AS site_url_2_24,
t0.site_url_3 AS site_url_3_25,
t0.map_iframe AS map_iframe_26,
t0.public_date AS public_date_27,
t0.customblock AS customblock_28,
t0.id AS id_29,
t0.sort_num AS sort_num_30,
t0.status AS status_31,
t0.publish_at AS publish_at_32,
t0.expires_at AS expires_at_33,
t0.created_at AS created_at_34,
t0.updated_at AS updated_at_35,
t0.title AS title_36,
t0.language_parent AS language_parent_37,
t0.language_alias AS language_alias_38,
t0.language_active AS language_active_39,
t0.revision_parent AS revision_parent_40,
t0.revision_version AS revision_version_41,
t0.post_type AS post_type_42,
t0.access_token AS access_token_43,
t0.main_image AS main_image_44,
t45.meta AS meta_46,
t45.id AS id_47,
t45.sort_num AS sort_num_48,
t45.status AS status_49,
t45.publish_at AS publish_at_50,
t45.expires_at AS expires_at_51,
t45.created_at AS created_at_52,
t45.updated_at AS updated_at_53,
t45.title AS title_54,
t45.created_by AS created_by_55,
t45.updated_by AS updated_by_56,
t0.time_by_car_id AS time_by_car_id_57,
t58.public_date AS public_date_59,
t58.customblock AS customblock_60,
t58.id AS id_61,
t58.sort_num AS sort_num_62,
t58.status AS status_63,
t58.publish_at AS publish_at_64,
t58.expires_at AS expires_at_65,
t58.created_at AS created_at_66,
t58.updated_at AS updated_at_67,
t58.title AS title_68,
t58.language_parent AS language_parent_69,
t58.language_alias AS language_alias_70,
t58.language_active AS language_active_71,
t58.revision_parent AS revision_parent_72,
t58.revision_version AS revision_version_73,
t58.post_type AS post_type_74,
t58.access_token AS access_token_75,
t58.thumbnail AS thumbnail_76,
t58.facility_id AS facility_id_77,
t58.created_by AS created_by_78,
t58.updated_by AS updated_by_79,
t58.language_id AS language_id_80,
t58.latest_approval_request_id AS latest_approval_request_id_81,
t0.thumbnail AS thumbnail_82,
t83.alt AS alt_84,
t83.caption AS caption_85,
t83.collation_code AS collation_code_86,
t83.meta AS meta_87,
t83.id AS id_88,
t83.sort_num AS sort_num_89,
t83.status AS status_90,
t83.publish_at AS publish_at_91,
t83.expires_at AS expires_at_92,
t83.created_at AS created_at_93,
t83.updated_at AS updated_at_94,
t83.title AS title_95,
t83.item_id AS item_id_96,
t83.thumb_item_id AS thumb_item_id_97,
t83.group_id AS group_id_98,
t83.created_by AS created_by_99,
t83.updated_by AS updated_by_100,
t0.facility_id AS facility_id_101,
t102.code AS code_103,
t102.title AS title_104,
t102.intro_text AS intro_text_105,
t102.zip AS zip_106,
t102.address AS address_107,
t102.building AS building_108,
t102.google_maps_url AS google_maps_url_109,
t102.phone AS phone_110,
t102.website AS website_111,
t102.opening_hours AS opening_hours_112,
t102.holiday AS holiday_113,
t102.access AS access_114,
t102.access_car AS access_car_115,
t102.access_train AS access_train_116,
t102.id AS id_117,
t102.sort_num AS sort_num_118,
t102.status AS status_119,
t102.publish_at AS publish_at_120,
t102.expires_at AS expires_at_121,
t102.created_at AS created_at_122,
t102.updated_at AS updated_at_123,
t102.area_id AS area_id_124,
t102.prefecture_id AS prefecture_id_125,
t102.logo_image AS logo_image_126,
t102.main_image AS main_image_127,
t102.created_by AS created_by_128,
t102.updated_by AS updated_by_129,
t0.created_by AS created_by_130,
t131.username AS username_132,
t131.username_canonical AS username_canonical_133,
t131.enabled AS enabled_134,
t131.last_login AS last_login_135,
t131.confirmation_token AS confirmation_token_136,
t131.password_requested_at AS password_requested_at_137,
t131.roles AS roles_138,
t131.id AS id_139,
t131.display_name AS display_name_140,
t131.sort_num AS sort_num_141,
t131.email AS email_142,
t131.email_canonical AS email_canonical_143,
t131.salt AS salt_144,
t131.password AS password_145,
t131.group_id AS group_id_146,
t131.facility_id AS facility_id_147,
t0.updated_by AS updated_by_148,
t149.username AS username_150,
t149.username_canonical AS username_canonical_151,
t149.enabled AS enabled_152,
t149.last_login AS last_login_153,
t149.confirmation_token AS confirmation_token_154,
t149.password_requested_at AS password_requested_at_155,
t149.roles AS roles_156,
t149.id AS id_157,
t149.display_name AS display_name_158,
t149.sort_num AS sort_num_159,
t149.email AS email_160,
t149.email_canonical AS email_canonical_161,
t149.salt AS salt_162,
t149.password AS password_163,
t149.group_id AS group_id_164,
t149.facility_id AS facility_id_165,
t0.language_id AS language_id_166,
t167.alias AS alias_168,
t167.translate_key AS translate_key_169,
t167.target_key AS target_key_170,
t167.id AS id_171,
t167.sort_num AS sort_num_172,
t167.status AS status_173,
t167.publish_at AS publish_at_174,
t167.expires_at AS expires_at_175,
t167.created_at AS created_at_176,
t167.updated_at AS updated_at_177,
t167.title AS title_178,
t167.created_by AS created_by_179,
t167.updated_by AS updated_by_180,
t0.latest_approval_request_id AS latest_approval_request_id_181,
t182.id AS id_183,
t182.handler_name AS handler_name_184,
t182.title AS title_185,
t182.target_id AS target_id_186,
t182.request_type AS request_type_187,
t182.moderated_at AS moderated_at_188,
t182.approval_status AS approval_status_189,
t182.comment AS comment_190,
t182.created_at AS created_at_191,
t182.updated_at AS updated_at_192,
t182.facility_id AS facility_id_193,
t182.requested_by AS requested_by_194,
t182.moderated_by AS moderated_by_195
FROM
cms_mod_restaurant_restaurants t0
LEFT JOIN cms_media_groups t45 ON t0.main_image = t45.id
AND (
(
t45.status = 1
AND (
t45.publish_at IS NULL
OR t45.publish_at <= "2025-09-17 08:12:40"
)
AND (
t45.expires_at IS NULL
OR t45.expires_at > "2025-09-17 08:12:40"
)
)
)
LEFT JOIN cms_mod_restaurant_time_by_cars t58 ON t0.time_by_car_id = t58.id
AND (
(
t58.post_type IN ("master")
)
AND (
t58.status = 1
AND (
t58.publish_at IS NULL
OR t58.publish_at <= "2025-09-17 08:12:40"
)
AND (
t58.expires_at IS NULL
OR t58.expires_at > "2025-09-17 08:12:40"
)
AND (
t58.public_date IS NULL
OR t58.public_date <= "2025-09-17"
)
)
)
LEFT JOIN cms_media_item_details t83 ON t0.thumbnail = t83.id
AND (
(
t83.status = 1
AND (
t83.publish_at IS NULL
OR t83.publish_at <= "2025-09-17 08:12:40"
)
AND (
t83.expires_at IS NULL
OR t83.expires_at > "2025-09-17 08:12:40"
)
)
)
LEFT JOIN cms_facility t102 ON t0.facility_id = t102.id
AND (
(
t102.status = 1
AND (
t102.publish_at IS NULL
OR t102.publish_at <= "2025-09-17 08:12:40"
)
AND (
t102.expires_at IS NULL
OR t102.expires_at > "2025-09-17 08:12:40"
)
)
)
LEFT JOIN cms_user t131 ON t0.created_by = t131.id
LEFT JOIN cms_user t149 ON t0.updated_by = t149.id
LEFT JOIN cms_master_languages t167 ON t0.language_id = t167.id
AND (
(
t167.status = 1
AND (
t167.publish_at IS NULL
OR t167.publish_at <= "2025-09-17 08:12:40"
)
AND (
t167.expires_at IS NULL
OR t167.expires_at > "2025-09-17 08:12:40"
)
)
)
LEFT JOIN cms_approval_requests t182 ON t0.latest_approval_request_id = t182.id
WHERE
t0.id = ?
AND (
(
t0.post_type IN ("master")
)
AND (
t0.status = 1
AND (
t0.publish_at IS NULL
OR t0.publish_at <= "2025-09-17 08:12:40"
)
AND (
t0.expires_at IS NULL
OR t0.expires_at > "2025-09-17 08:12:40"
)
AND (
t0.public_date IS NULL
OR t0.public_date <= "2025-09-17"
)
)
)
LIMIT
1
SELECT t0.this_month_recommendation AS this_month_recommendation_1, t0.title_kana AS title_kana_2, t0.business_hours AS business_hours_3, t0.business_hours_supplement AS business_hours_supplement_4, t0.holiday AS holiday_5, t0.holiday_supplement AS holiday_supplement_6, t0.description AS description_7, t0.map_url AS map_url_8, t0.route AS route_9, t0.tabelog_reserve AS tabelog_reserve_10, t0.hotpepper_reserve AS hotpepper_reserve_11, t0.ikyu_reserve AS ikyu_reserve_12, t0.contact_etc AS contact_etc_13, t0.tel AS tel_14, t0.information AS information_15, t0.budget AS budget_16, t0.address AS address_17, t0.access AS access_18, t0.parking AS parking_19, t0.seats AS seats_20, t0.private_room AS private_room_21, t0.payment AS payment_22, t0.site_url_1 AS site_url_1_23, t0.site_url_2 AS site_url_2_24, t0.site_url_3 AS site_url_3_25, t0.map_iframe AS map_iframe_26, t0.public_date AS public_date_27, t0.customblock AS customblock_28, t0.id AS id_29, t0.sort_num AS sort_num_30, t0.status AS status_31, t0.publish_at AS publish_at_32, t0.expires_at AS expires_at_33, t0.created_at AS created_at_34, t0.updated_at AS updated_at_35, t0.title AS title_36, t0.language_parent AS language_parent_37, t0.language_alias AS language_alias_38, t0.language_active AS language_active_39, t0.revision_parent AS revision_parent_40, t0.revision_version AS revision_version_41, t0.post_type AS post_type_42, t0.access_token AS access_token_43, t0.main_image AS main_image_44, t45.meta AS meta_46, t45.id AS id_47, t45.sort_num AS sort_num_48, t45.status AS status_49, t45.publish_at AS publish_at_50, t45.expires_at AS expires_at_51, t45.created_at AS created_at_52, t45.updated_at AS updated_at_53, t45.title AS title_54, t45.created_by AS created_by_55, t45.updated_by AS updated_by_56, t0.time_by_car_id AS time_by_car_id_57, t58.public_date AS public_date_59, t58.customblock AS customblock_60, t58.id AS id_61, t58.sort_num AS sort_num_62, t58.status AS status_63, t58.publish_at AS publish_at_64, t58.expires_at AS expires_at_65, t58.created_at AS created_at_66, t58.updated_at AS updated_at_67, t58.title AS title_68, t58.language_parent AS language_parent_69, t58.language_alias AS language_alias_70, t58.language_active AS language_active_71, t58.revision_parent AS revision_parent_72, t58.revision_version AS revision_version_73, t58.post_type AS post_type_74, t58.access_token AS access_token_75, t58.thumbnail AS thumbnail_76, t58.facility_id AS facility_id_77, t58.created_by AS created_by_78, t58.updated_by AS updated_by_79, t58.language_id AS language_id_80, t58.latest_approval_request_id AS latest_approval_request_id_81, t0.thumbnail AS thumbnail_82, t83.alt AS alt_84, t83.caption AS caption_85, t83.collation_code AS collation_code_86, t83.meta AS meta_87, t83.id AS id_88, t83.sort_num AS sort_num_89, t83.status AS status_90, t83.publish_at AS publish_at_91, t83.expires_at AS expires_at_92, t83.created_at AS created_at_93, t83.updated_at AS updated_at_94, t83.title AS title_95, t83.item_id AS item_id_96, t83.thumb_item_id AS thumb_item_id_97, t83.group_id AS group_id_98, t83.created_by AS created_by_99, t83.updated_by AS updated_by_100, t0.facility_id AS facility_id_101, t102.code AS code_103, t102.title AS title_104, t102.intro_text AS intro_text_105, t102.zip AS zip_106, t102.address AS address_107, t102.building AS building_108, t102.google_maps_url AS google_maps_url_109, t102.phone AS phone_110, t102.website AS website_111, t102.opening_hours AS opening_hours_112, t102.holiday AS holiday_113, t102.access AS access_114, t102.access_car AS access_car_115, t102.access_train AS access_train_116, t102.id AS id_117, t102.sort_num AS sort_num_118, t102.status AS status_119, t102.publish_at AS publish_at_120, t102.expires_at AS expires_at_121, t102.created_at AS created_at_122, t102.updated_at AS updated_at_123, t102.area_id AS area_id_124, t102.prefecture_id AS prefecture_id_125, t102.logo_image AS logo_image_126, t102.main_image AS main_image_127, t102.created_by AS created_by_128, t102.updated_by AS updated_by_129, t0.created_by AS created_by_130, t131.username AS username_132, t131.username_canonical AS username_canonical_133, t131.enabled AS enabled_134, t131.last_login AS last_login_135, t131.confirmation_token AS confirmation_token_136, t131.password_requested_at AS password_requested_at_137, t131.roles AS roles_138, t131.id AS id_139, t131.display_name AS display_name_140, t131.sort_num AS sort_num_141, t131.email AS email_142, t131.email_canonical AS email_canonical_143, t131.salt AS salt_144, t131.password AS password_145, t131.group_id AS group_id_146, t131.facility_id AS facility_id_147, t0.updated_by AS updated_by_148, t149.username AS username_150, t149.username_canonical AS username_canonical_151, t149.enabled AS enabled_152, t149.last_login AS last_login_153, t149.confirmation_token AS confirmation_token_154, t149.password_requested_at AS password_requested_at_155, t149.roles AS roles_156, t149.id AS id_157, t149.display_name AS display_name_158, t149.sort_num AS sort_num_159, t149.email AS email_160, t149.email_canonical AS email_canonical_161, t149.salt AS salt_162, t149.password AS password_163, t149.group_id AS group_id_164, t149.facility_id AS facility_id_165, t0.language_id AS language_id_166, t167.alias AS alias_168, t167.translate_key AS translate_key_169, t167.target_key AS target_key_170, t167.id AS id_171, t167.sort_num AS sort_num_172, t167.status AS status_173, t167.publish_at AS publish_at_174, t167.expires_at AS expires_at_175, t167.created_at AS created_at_176, t167.updated_at AS updated_at_177, t167.title AS title_178, t167.created_by AS created_by_179, t167.updated_by AS updated_by_180, t0.latest_approval_request_id AS latest_approval_request_id_181, t182.id AS id_183, t182.handler_name AS handler_name_184, t182.title AS title_185, t182.target_id AS target_id_186, t182.request_type AS request_type_187, t182.moderated_at AS moderated_at_188, t182.approval_status AS approval_status_189, t182.comment AS comment_190, t182.created_at AS created_at_191, t182.updated_at AS updated_at_192, t182.facility_id AS facility_id_193, t182.requested_by AS requested_by_194, t182.moderated_by AS moderated_by_195 FROM cms_mod_restaurant_restaurants t0 LEFT JOIN cms_media_groups t45 ON t0.main_image = t45.id AND ((t45.status = 1 AND (t45.publish_at IS NULL OR t45.publish_at <= "2025-09-17 08'1':40") AND (t45.expires_at IS NULL OR t45.expires_at > "2025-09-17 08:12:40"))) LEFT JOIN cms_mod_restaurant_time_by_cars t58 ON t0.time_by_car_id = t58.id AND ((t58.post_type IN ("master")) AND (t58.status = 1 AND (t58.publish_at IS NULL OR t58.publish_at <= "2025-09-17 08:12:40") AND (t58.expires_at IS NULL OR t58.expires_at > "2025-09-17 08:12:40") AND (t58.public_date IS NULL OR t58.public_date <= "2025-09-17"))) LEFT JOIN cms_media_item_details t83 ON t0.thumbnail = t83.id AND ((t83.status = 1 AND (t83.publish_at IS NULL OR t83.publish_at <= "2025-09-17 08:12:40") AND (t83.expires_at IS NULL OR t83.expires_at > "2025-09-17 08:12:40"))) LEFT JOIN cms_facility t102 ON t0.facility_id = t102.id AND ((t102.status = 1 AND (t102.publish_at IS NULL OR t102.publish_at <= "2025-09-17 08:12:40") AND (t102.expires_at IS NULL OR t102.expires_at > "2025-09-17 08:12:40"))) LEFT JOIN cms_user t131 ON t0.created_by = t131.id LEFT JOIN cms_user t149 ON t0.updated_by = t149.id LEFT JOIN cms_master_languages t167 ON t0.language_id = t167.id AND ((t167.status = 1 AND (t167.publish_at IS NULL OR t167.publish_at <= "2025-09-17 08:12:40") AND (t167.expires_at IS NULL OR t167.expires_at > "2025-09-17 08:12:40"))) LEFT JOIN cms_approval_requests t182 ON t0.latest_approval_request_id = t182.id WHERE t0.id = ? AND ((t0.post_type IN ("master")) AND (t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2025-09-17 08:12:40") AND (t0.expires_at IS NULL OR t0.expires_at > "2025-09-17 08:12:40") AND (t0.public_date IS NULL OR t0.public_date <= "2025-09-17"))) LIMIT 1;
|
3.97 ms
(18.49%)
|
1 |
SELECT t0.title_for_list AS title_for_list_1, t0.alias AS alias_2, t0.show_in_list AS show_in_list_3, t0.public_date AS public_date_4, t0.customblock AS customblock_5, t0.id AS id_6, t0.sort_num AS sort_num_7, t0.status AS status_8, t0.publish_at AS publish_at_9, t0.expires_at AS expires_at_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.title AS title_13, t0.language_parent AS language_parent_14, t0.language_alias AS language_alias_15, t0.language_active AS language_active_16, t0.revision_parent AS revision_parent_17, t0.revision_version AS revision_version_18, t0.post_type AS post_type_19, t0.access_token AS access_token_20, t0.image_pc AS image_pc_21, t22.alt AS alt_23, t22.caption AS caption_24, t22.collation_code AS collation_code_25, t22.meta AS meta_26, t22.id AS id_27, t22.sort_num AS sort_num_28, t22.status AS status_29, t22.publish_at AS publish_at_30, t22.expires_at AS expires_at_31, t22.created_at AS created_at_32, t22.updated_at AS updated_at_33, t22.title AS title_34, t22.item_id AS item_id_35, t22.thumb_item_id AS thumb_item_id_36, t22.group_id AS group_id_37, t22.created_by AS created_by_38, t22.updated_by AS updated_by_39, t0.image_sp AS image_sp_40, t41.alt AS alt_42, t41.caption AS caption_43, t41.collation_code AS collation_code_44, t41.meta AS meta_45, t41.id AS id_46, t41.sort_num AS sort_num_47, t41.status AS status_48, t41.publish_at AS publish_at_49, t41.expires_at AS expires_at_50, t41.created_at AS created_at_51, t41.updated_at AS updated_at_52, t41.title AS title_53, t41.item_id AS item_id_54, t41.thumb_item_id AS thumb_item_id_55, t41.group_id AS group_id_56, t41.created_by AS created_by_57, t41.updated_by AS updated_by_58, t0.thumbnail AS thumbnail_59, t60.alt AS alt_61, t60.caption AS caption_62, t60.collation_code AS collation_code_63, t60.meta AS meta_64, t60.id AS id_65, t60.sort_num AS sort_num_66, t60.status AS status_67, t60.publish_at AS publish_at_68, t60.expires_at AS expires_at_69, t60.created_at AS created_at_70, t60.updated_at AS updated_at_71, t60.title AS title_72, t60.item_id AS item_id_73, t60.thumb_item_id AS thumb_item_id_74, t60.group_id AS group_id_75, t60.created_by AS created_by_76, t60.updated_by AS updated_by_77, t0.facility_id AS facility_id_78, t79.code AS code_80, t79.title AS title_81, t79.intro_text AS intro_text_82, t79.zip AS zip_83, t79.address AS address_84, t79.building AS building_85, t79.google_maps_url AS google_maps_url_86, t79.phone AS phone_87, t79.website AS website_88, t79.opening_hours AS opening_hours_89, t79.holiday AS holiday_90, t79.access AS access_91, t79.access_car AS access_car_92, t79.access_train AS access_train_93, t79.id AS id_94, t79.sort_num AS sort_num_95, t79.status AS status_96, t79.publish_at AS publish_at_97, t79.expires_at AS expires_at_98, t79.created_at AS created_at_99, t79.updated_at AS updated_at_100, t79.area_id AS area_id_101, t79.prefecture_id AS prefecture_id_102, t79.logo_image AS logo_image_103, t79.main_image AS main_image_104, t79.created_by AS created_by_105, t79.updated_by AS updated_by_106, t0.created_by AS created_by_107, t108.username AS username_109, t108.username_canonical AS username_canonical_110, t108.enabled AS enabled_111, t108.last_login AS last_login_112, t108.confirmation_token AS confirmation_token_113, t108.password_requested_at AS password_requested_at_114, t108.roles AS roles_115, t108.id AS id_116, t108.display_name AS display_name_117, t108.sort_num AS sort_num_118, t108.email AS email_119, t108.email_canonical AS email_canonical_120, t108.salt AS salt_121, t108.password AS password_122, t108.group_id AS group_id_123, t108.facility_id AS facility_id_124, t0.updated_by AS updated_by_125, t126.username AS username_127, t126.username_canonical AS username_canonical_128, t126.enabled AS enabled_129, t126.last_login AS last_login_130, t126.confirmation_token AS confirmation_token_131, t126.password_requested_at AS password_requested_at_132, t126.roles AS roles_133, t126.id AS id_134, t126.display_name AS display_name_135, t126.sort_num AS sort_num_136, t126.email AS email_137, t126.email_canonical AS email_canonical_138, t126.salt AS salt_139, t126.password AS password_140, t126.group_id AS group_id_141, t126.facility_id AS facility_id_142, t0.language_id AS language_id_143, t144.alias AS alias_145, t144.translate_key AS translate_key_146, t144.target_key AS target_key_147, t144.id AS id_148, t144.sort_num AS sort_num_149, t144.status AS status_150, t144.publish_at AS publish_at_151, t144.expires_at AS expires_at_152, t144.created_at AS created_at_153, t144.updated_at AS updated_at_154, t144.title AS title_155, t144.created_by AS created_by_156, t144.updated_by AS updated_by_157, t0.latest_approval_request_id AS latest_approval_request_id_158, t159.id AS id_160, t159.handler_name AS handler_name_161, t159.title AS title_162, t159.target_id AS target_id_163, t159.request_type AS request_type_164, t159.moderated_at AS moderated_at_165, t159.approval_status AS approval_status_166, t159.comment AS comment_167, t159.created_at AS created_at_168, t159.updated_at AS updated_at_169, t159.facility_id AS facility_id_170, t159.requested_by AS requested_by_171, t159.moderated_by AS moderated_by_172 FROM cms_mod_restaurant_genres t0 LEFT JOIN cms_media_item_details t22 ON t0.image_pc = t22.id AND ((t22.status = 1 AND (t22.publish_at IS NULL OR t22.publish_at <= "2025-09-17 08:12:40") AND (t22.expires_at IS NULL OR t22.expires_at > "2025-09-17 08:12:40"))) LEFT JOIN cms_media_item_details t41 ON t0.image_sp = t41.id AND ((t41.status = 1 AND (t41.publish_at IS NULL OR t41.publish_at <= "2025-09-17 08:12:40") AND (t41.expires_at IS NULL OR t41.expires_at > "2025-09-17 08:12:40"))) LEFT JOIN cms_media_item_details t60 ON t0.thumbnail = t60.id AND ((t60.status = 1 AND (t60.publish_at IS NULL OR t60.publish_at <= "2025-09-17 08:12:40") AND (t60.expires_at IS NULL OR t60.expires_at > "2025-09-17 08:12:40"))) LEFT JOIN cms_facility t79 ON t0.facility_id = t79.id AND ((t79.status = 1 AND (t79.publish_at IS NULL OR t79.publish_at <= "2025-09-17 08:12:40") AND (t79.expires_at IS NULL OR t79.expires_at > "2025-09-17 08:12:40"))) LEFT JOIN cms_user t108 ON t0.created_by = t108.id LEFT JOIN cms_user t126 ON t0.updated_by = t126.id LEFT JOIN cms_master_languages t144 ON t0.language_id = t144.id AND ((t144.status = 1 AND (t144.publish_at IS NULL OR t144.publish_at <= "2025-09-17 08:12:40") AND (t144.expires_at IS NULL OR t144.expires_at > "2025-09-17 08:12:40"))) LEFT JOIN cms_approval_requests t159 ON t0.latest_approval_request_id = t159.id INNER JOIN cms_mod_restaurant_restaurants_genres ON t0.id = cms_mod_restaurant_restaurants_genres.genre_id WHERE cms_mod_restaurant_restaurants_genres.restaurant_id = ? AND ((t0.post_type IN ("master")) AND (t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2025-09-17 08:12:40") AND (t0.expires_at IS NULL OR t0.expires_at > "2025-09-17 08:12:40") AND (t0.public_date IS NULL OR t0.public_date <= "2025-09-17"))) ORDER BY t0.sort_num ASC, t0.id ASC
SELECT
t0.title_for_list AS title_for_list_1,
t0.alias AS alias_2,
t0.show_in_list AS show_in_list_3,
t0.public_date AS public_date_4,
t0.customblock AS customblock_5,
t0.id AS id_6,
t0.sort_num AS sort_num_7,
t0.status AS status_8,
t0.publish_at AS publish_at_9,
t0.expires_at AS expires_at_10,
t0.created_at AS created_at_11,
t0.updated_at AS updated_at_12,
t0.title AS title_13,
t0.language_parent AS language_parent_14,
t0.language_alias AS language_alias_15,
t0.language_active AS language_active_16,
t0.revision_parent AS revision_parent_17,
t0.revision_version AS revision_version_18,
t0.post_type AS post_type_19,
t0.access_token AS access_token_20,
t0.image_pc AS image_pc_21,
t22.alt AS alt_23,
t22.caption AS caption_24,
t22.collation_code AS collation_code_25,
t22.meta AS meta_26,
t22.id AS id_27,
t22.sort_num AS sort_num_28,
t22.status AS status_29,
t22.publish_at AS publish_at_30,
t22.expires_at AS expires_at_31,
t22.created_at AS created_at_32,
t22.updated_at AS updated_at_33,
t22.title AS title_34,
t22.item_id AS item_id_35,
t22.thumb_item_id AS thumb_item_id_36,
t22.group_id AS group_id_37,
t22.created_by AS created_by_38,
t22.updated_by AS updated_by_39,
t0.image_sp AS image_sp_40,
t41.alt AS alt_42,
t41.caption AS caption_43,
t41.collation_code AS collation_code_44,
t41.meta AS meta_45,
t41.id AS id_46,
t41.sort_num AS sort_num_47,
t41.status AS status_48,
t41.publish_at AS publish_at_49,
t41.expires_at AS expires_at_50,
t41.created_at AS created_at_51,
t41.updated_at AS updated_at_52,
t41.title AS title_53,
t41.item_id AS item_id_54,
t41.thumb_item_id AS thumb_item_id_55,
t41.group_id AS group_id_56,
t41.created_by AS created_by_57,
t41.updated_by AS updated_by_58,
t0.thumbnail AS thumbnail_59,
t60.alt AS alt_61,
t60.caption AS caption_62,
t60.collation_code AS collation_code_63,
t60.meta AS meta_64,
t60.id AS id_65,
t60.sort_num AS sort_num_66,
t60.status AS status_67,
t60.publish_at AS publish_at_68,
t60.expires_at AS expires_at_69,
t60.created_at AS created_at_70,
t60.updated_at AS updated_at_71,
t60.title AS title_72,
t60.item_id AS item_id_73,
t60.thumb_item_id AS thumb_item_id_74,
t60.group_id AS group_id_75,
t60.created_by AS created_by_76,
t60.updated_by AS updated_by_77,
t0.facility_id AS facility_id_78,
t79.code AS code_80,
t79.title AS title_81,
t79.intro_text AS intro_text_82,
t79.zip AS zip_83,
t79.address AS address_84,
t79.building AS building_85,
t79.google_maps_url AS google_maps_url_86,
t79.phone AS phone_87,
t79.website AS website_88,
t79.opening_hours AS opening_hours_89,
t79.holiday AS holiday_90,
t79.access AS access_91,
t79.access_car AS access_car_92,
t79.access_train AS access_train_93,
t79.id AS id_94,
t79.sort_num AS sort_num_95,
t79.status AS status_96,
t79.publish_at AS publish_at_97,
t79.expires_at AS expires_at_98,
t79.created_at AS created_at_99,
t79.updated_at AS updated_at_100,
t79.area_id AS area_id_101,
t79.prefecture_id AS prefecture_id_102,
t79.logo_image AS logo_image_103,
t79.main_image AS main_image_104,
t79.created_by AS created_by_105,
t79.updated_by AS updated_by_106,
t0.created_by AS created_by_107,
t108.username AS username_109,
t108.username_canonical AS username_canonical_110,
t108.enabled AS enabled_111,
t108.last_login AS last_login_112,
t108.confirmation_token AS confirmation_token_113,
t108.password_requested_at AS password_requested_at_114,
t108.roles AS roles_115,
t108.id AS id_116,
t108.display_name AS display_name_117,
t108.sort_num AS sort_num_118,
t108.email AS email_119,
t108.email_canonical AS email_canonical_120,
t108.salt AS salt_121,
t108.password AS password_122,
t108.group_id AS group_id_123,
t108.facility_id AS facility_id_124,
t0.updated_by AS updated_by_125,
t126.username AS username_127,
t126.username_canonical AS username_canonical_128,
t126.enabled AS enabled_129,
t126.last_login AS last_login_130,
t126.confirmation_token AS confirmation_token_131,
t126.password_requested_at AS password_requested_at_132,
t126.roles AS roles_133,
t126.id AS id_134,
t126.display_name AS display_name_135,
t126.sort_num AS sort_num_136,
t126.email AS email_137,
t126.email_canonical AS email_canonical_138,
t126.salt AS salt_139,
t126.password AS password_140,
t126.group_id AS group_id_141,
t126.facility_id AS facility_id_142,
t0.language_id AS language_id_143,
t144.alias AS alias_145,
t144.translate_key AS translate_key_146,
t144.target_key AS target_key_147,
t144.id AS id_148,
t144.sort_num AS sort_num_149,
t144.status AS status_150,
t144.publish_at AS publish_at_151,
t144.expires_at AS expires_at_152,
t144.created_at AS created_at_153,
t144.updated_at AS updated_at_154,
t144.title AS title_155,
t144.created_by AS created_by_156,
t144.updated_by AS updated_by_157,
t0.latest_approval_request_id AS latest_approval_request_id_158,
t159.id AS id_160,
t159.handler_name AS handler_name_161,
t159.title AS title_162,
t159.target_id AS target_id_163,
t159.request_type AS request_type_164,
t159.moderated_at AS moderated_at_165,
t159.approval_status AS approval_status_166,
t159.comment AS comment_167,
t159.created_at AS created_at_168,
t159.updated_at AS updated_at_169,
t159.facility_id AS facility_id_170,
t159.requested_by AS requested_by_171,
t159.moderated_by AS moderated_by_172
FROM
cms_mod_restaurant_genres t0
LEFT JOIN cms_media_item_details t22 ON t0.image_pc = t22.id
AND (
(
t22.status = 1
AND (
t22.publish_at IS NULL
OR t22.publish_at <= "2025-09-17 08:12:40"
)
AND (
t22.expires_at IS NULL
OR t22.expires_at > "2025-09-17 08:12:40"
)
)
)
LEFT JOIN cms_media_item_details t41 ON t0.image_sp = t41.id
AND (
(
t41.status = 1
AND (
t41.publish_at IS NULL
OR t41.publish_at <= "2025-09-17 08:12:40"
)
AND (
t41.expires_at IS NULL
OR t41.expires_at > "2025-09-17 08:12:40"
)
)
)
LEFT JOIN cms_media_item_details t60 ON t0.thumbnail = t60.id
AND (
(
t60.status = 1
AND (
t60.publish_at IS NULL
OR t60.publish_at <= "2025-09-17 08:12:40"
)
AND (
t60.expires_at IS NULL
OR t60.expires_at > "2025-09-17 08:12:40"
)
)
)
LEFT JOIN cms_facility t79 ON t0.facility_id = t79.id
AND (
(
t79.status = 1
AND (
t79.publish_at IS NULL
OR t79.publish_at <= "2025-09-17 08:12:40"
)
AND (
t79.expires_at IS NULL
OR t79.expires_at > "2025-09-17 08:12:40"
)
)
)
LEFT JOIN cms_user t108 ON t0.created_by = t108.id
LEFT JOIN cms_user t126 ON t0.updated_by = t126.id
LEFT JOIN cms_master_languages t144 ON t0.language_id = t144.id
AND (
(
t144.status = 1
AND (
t144.publish_at IS NULL
OR t144.publish_at <= "2025-09-17 08:12:40"
)
AND (
t144.expires_at IS NULL
OR t144.expires_at > "2025-09-17 08:12:40"
)
)
)
LEFT JOIN cms_approval_requests t159 ON t0.latest_approval_request_id = t159.id
INNER JOIN cms_mod_restaurant_restaurants_genres ON t0.id = cms_mod_restaurant_restaurants_genres.genre_id
WHERE
cms_mod_restaurant_restaurants_genres.restaurant_id = ?
AND (
(
t0.post_type IN ("master")
)
AND (
t0.status = 1
AND (
t0.publish_at IS NULL
OR t0.publish_at <= "2025-09-17 08:12:40"
)
AND (
t0.expires_at IS NULL
OR t0.expires_at > "2025-09-17 08:12:40"
)
AND (
t0.public_date IS NULL
OR t0.public_date <= "2025-09-17"
)
)
)
ORDER BY
t0.sort_num ASC,
t0.id ASC
SELECT t0.title_for_list AS title_for_list_1, t0.alias AS alias_2, t0.show_in_list AS show_in_list_3, t0.public_date AS public_date_4, t0.customblock AS customblock_5, t0.id AS id_6, t0.sort_num AS sort_num_7, t0.status AS status_8, t0.publish_at AS publish_at_9, t0.expires_at AS expires_at_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.title AS title_13, t0.language_parent AS language_parent_14, t0.language_alias AS language_alias_15, t0.language_active AS language_active_16, t0.revision_parent AS revision_parent_17, t0.revision_version AS revision_version_18, t0.post_type AS post_type_19, t0.access_token AS access_token_20, t0.image_pc AS image_pc_21, t22.alt AS alt_23, t22.caption AS caption_24, t22.collation_code AS collation_code_25, t22.meta AS meta_26, t22.id AS id_27, t22.sort_num AS sort_num_28, t22.status AS status_29, t22.publish_at AS publish_at_30, t22.expires_at AS expires_at_31, t22.created_at AS created_at_32, t22.updated_at AS updated_at_33, t22.title AS title_34, t22.item_id AS item_id_35, t22.thumb_item_id AS thumb_item_id_36, t22.group_id AS group_id_37, t22.created_by AS created_by_38, t22.updated_by AS updated_by_39, t0.image_sp AS image_sp_40, t41.alt AS alt_42, t41.caption AS caption_43, t41.collation_code AS collation_code_44, t41.meta AS meta_45, t41.id AS id_46, t41.sort_num AS sort_num_47, t41.status AS status_48, t41.publish_at AS publish_at_49, t41.expires_at AS expires_at_50, t41.created_at AS created_at_51, t41.updated_at AS updated_at_52, t41.title AS title_53, t41.item_id AS item_id_54, t41.thumb_item_id AS thumb_item_id_55, t41.group_id AS group_id_56, t41.created_by AS created_by_57, t41.updated_by AS updated_by_58, t0.thumbnail AS thumbnail_59, t60.alt AS alt_61, t60.caption AS caption_62, t60.collation_code AS collation_code_63, t60.meta AS meta_64, t60.id AS id_65, t60.sort_num AS sort_num_66, t60.status AS status_67, t60.publish_at AS publish_at_68, t60.expires_at AS expires_at_69, t60.created_at AS created_at_70, t60.updated_at AS updated_at_71, t60.title AS title_72, t60.item_id AS item_id_73, t60.thumb_item_id AS thumb_item_id_74, t60.group_id AS group_id_75, t60.created_by AS created_by_76, t60.updated_by AS updated_by_77, t0.facility_id AS facility_id_78, t79.code AS code_80, t79.title AS title_81, t79.intro_text AS intro_text_82, t79.zip AS zip_83, t79.address AS address_84, t79.building AS building_85, t79.google_maps_url AS google_maps_url_86, t79.phone AS phone_87, t79.website AS website_88, t79.opening_hours AS opening_hours_89, t79.holiday AS holiday_90, t79.access AS access_91, t79.access_car AS access_car_92, t79.access_train AS access_train_93, t79.id AS id_94, t79.sort_num AS sort_num_95, t79.status AS status_96, t79.publish_at AS publish_at_97, t79.expires_at AS expires_at_98, t79.created_at AS created_at_99, t79.updated_at AS updated_at_100, t79.area_id AS area_id_101, t79.prefecture_id AS prefecture_id_102, t79.logo_image AS logo_image_103, t79.main_image AS main_image_104, t79.created_by AS created_by_105, t79.updated_by AS updated_by_106, t0.created_by AS created_by_107, t108.username AS username_109, t108.username_canonical AS username_canonical_110, t108.enabled AS enabled_111, t108.last_login AS last_login_112, t108.confirmation_token AS confirmation_token_113, t108.password_requested_at AS password_requested_at_114, t108.roles AS roles_115, t108.id AS id_116, t108.display_name AS display_name_117, t108.sort_num AS sort_num_118, t108.email AS email_119, t108.email_canonical AS email_canonical_120, t108.salt AS salt_121, t108.password AS password_122, t108.group_id AS group_id_123, t108.facility_id AS facility_id_124, t0.updated_by AS updated_by_125, t126.username AS username_127, t126.username_canonical AS username_canonical_128, t126.enabled AS enabled_129, t126.last_login AS last_login_130, t126.confirmation_token AS confirmation_token_131, t126.password_requested_at AS password_requested_at_132, t126.roles AS roles_133, t126.id AS id_134, t126.display_name AS display_name_135, t126.sort_num AS sort_num_136, t126.email AS email_137, t126.email_canonical AS email_canonical_138, t126.salt AS salt_139, t126.password AS password_140, t126.group_id AS group_id_141, t126.facility_id AS facility_id_142, t0.language_id AS language_id_143, t144.alias AS alias_145, t144.translate_key AS translate_key_146, t144.target_key AS target_key_147, t144.id AS id_148, t144.sort_num AS sort_num_149, t144.status AS status_150, t144.publish_at AS publish_at_151, t144.expires_at AS expires_at_152, t144.created_at AS created_at_153, t144.updated_at AS updated_at_154, t144.title AS title_155, t144.created_by AS created_by_156, t144.updated_by AS updated_by_157, t0.latest_approval_request_id AS latest_approval_request_id_158, t159.id AS id_160, t159.handler_name AS handler_name_161, t159.title AS title_162, t159.target_id AS target_id_163, t159.request_type AS request_type_164, t159.moderated_at AS moderated_at_165, t159.approval_status AS approval_status_166, t159.comment AS comment_167, t159.created_at AS created_at_168, t159.updated_at AS updated_at_169, t159.facility_id AS facility_id_170, t159.requested_by AS requested_by_171, t159.moderated_by AS moderated_by_172 FROM cms_mod_restaurant_genres t0 LEFT JOIN cms_media_item_details t22 ON t0.image_pc = t22.id AND ((t22.status = 1 AND (t22.publish_at IS NULL OR t22.publish_at <= "2025-09-17 081:40") AND (t22.expires_at IS NULL OR t22.expires_at > "2025-09-17 08:12:40"))) LEFT JOIN cms_media_item_details t41 ON t0.image_sp = t41.id AND ((t41.status = 1 AND (t41.publish_at IS NULL OR t41.publish_at <= "2025-09-17 08:12:40") AND (t41.expires_at IS NULL OR t41.expires_at > "2025-09-17 08:12:40"))) LEFT JOIN cms_media_item_details t60 ON t0.thumbnail = t60.id AND ((t60.status = 1 AND (t60.publish_at IS NULL OR t60.publish_at <= "2025-09-17 08:12:40") AND (t60.expires_at IS NULL OR t60.expires_at > "2025-09-17 08:12:40"))) LEFT JOIN cms_facility t79 ON t0.facility_id = t79.id AND ((t79.status = 1 AND (t79.publish_at IS NULL OR t79.publish_at <= "2025-09-17 08:12:40") AND (t79.expires_at IS NULL OR t79.expires_at > "2025-09-17 08:12:40"))) LEFT JOIN cms_user t108 ON t0.created_by = t108.id LEFT JOIN cms_user t126 ON t0.updated_by = t126.id LEFT JOIN cms_master_languages t144 ON t0.language_id = t144.id AND ((t144.status = 1 AND (t144.publish_at IS NULL OR t144.publish_at <= "2025-09-17 08:12:40") AND (t144.expires_at IS NULL OR t144.expires_at > "2025-09-17 08:12:40"))) LEFT JOIN cms_approval_requests t159 ON t0.latest_approval_request_id = t159.id INNER JOIN cms_mod_restaurant_restaurants_genres ON t0.id = cms_mod_restaurant_restaurants_genres.genre_id WHERE cms_mod_restaurant_restaurants_genres.restaurant_id = ? AND ((t0.post_type IN ("master")) AND (t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2025-09-17 08:12:40") AND (t0.expires_at IS NULL OR t0.expires_at > "2025-09-17 08:12:40") AND (t0.public_date IS NULL OR t0.public_date <= "2025-09-17"))) ORDER BY t0.sort_num ASC, t0.id ASC;
|
3.33 ms
(15.50%)
|
1 |
SELECT t0.title_for_list AS title_for_list_1, t0.alias AS alias_2, t0.show_in_list AS show_in_list_3, t0.background_color AS background_color_4, t0.public_date AS public_date_5, t0.customblock AS customblock_6, t0.id AS id_7, t0.sort_num AS sort_num_8, t0.status AS status_9, t0.publish_at AS publish_at_10, t0.expires_at AS expires_at_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.title AS title_14, t0.language_parent AS language_parent_15, t0.language_alias AS language_alias_16, t0.language_active AS language_active_17, t0.revision_parent AS revision_parent_18, t0.revision_version AS revision_version_19, t0.post_type AS post_type_20, t0.access_token AS access_token_21, t0.thumbnail AS thumbnail_22, t23.alt AS alt_24, t23.caption AS caption_25, t23.collation_code AS collation_code_26, t23.meta AS meta_27, t23.id AS id_28, t23.sort_num AS sort_num_29, t23.status AS status_30, t23.publish_at AS publish_at_31, t23.expires_at AS expires_at_32, t23.created_at AS created_at_33, t23.updated_at AS updated_at_34, t23.title AS title_35, t23.item_id AS item_id_36, t23.thumb_item_id AS thumb_item_id_37, t23.group_id AS group_id_38, t23.created_by AS created_by_39, t23.updated_by AS updated_by_40, t0.facility_id AS facility_id_41, t42.code AS code_43, t42.title AS title_44, t42.intro_text AS intro_text_45, t42.zip AS zip_46, t42.address AS address_47, t42.building AS building_48, t42.google_maps_url AS google_maps_url_49, t42.phone AS phone_50, t42.website AS website_51, t42.opening_hours AS opening_hours_52, t42.holiday AS holiday_53, t42.access AS access_54, t42.access_car AS access_car_55, t42.access_train AS access_train_56, t42.id AS id_57, t42.sort_num AS sort_num_58, t42.status AS status_59, t42.publish_at AS publish_at_60, t42.expires_at AS expires_at_61, t42.created_at AS created_at_62, t42.updated_at AS updated_at_63, t42.area_id AS area_id_64, t42.prefecture_id AS prefecture_id_65, t42.logo_image AS logo_image_66, t42.main_image AS main_image_67, t42.created_by AS created_by_68, t42.updated_by AS updated_by_69, t0.created_by AS created_by_70, t71.username AS username_72, t71.username_canonical AS username_canonical_73, t71.enabled AS enabled_74, t71.last_login AS last_login_75, t71.confirmation_token AS confirmation_token_76, t71.password_requested_at AS password_requested_at_77, t71.roles AS roles_78, t71.id AS id_79, t71.display_name AS display_name_80, t71.sort_num AS sort_num_81, t71.email AS email_82, t71.email_canonical AS email_canonical_83, t71.salt AS salt_84, t71.password AS password_85, t71.group_id AS group_id_86, t71.facility_id AS facility_id_87, t0.updated_by AS updated_by_88, t89.username AS username_90, t89.username_canonical AS username_canonical_91, t89.enabled AS enabled_92, t89.last_login AS last_login_93, t89.confirmation_token AS confirmation_token_94, t89.password_requested_at AS password_requested_at_95, t89.roles AS roles_96, t89.id AS id_97, t89.display_name AS display_name_98, t89.sort_num AS sort_num_99, t89.email AS email_100, t89.email_canonical AS email_canonical_101, t89.salt AS salt_102, t89.password AS password_103, t89.group_id AS group_id_104, t89.facility_id AS facility_id_105, t0.language_id AS language_id_106, t107.alias AS alias_108, t107.translate_key AS translate_key_109, t107.target_key AS target_key_110, t107.id AS id_111, t107.sort_num AS sort_num_112, t107.status AS status_113, t107.publish_at AS publish_at_114, t107.expires_at AS expires_at_115, t107.created_at AS created_at_116, t107.updated_at AS updated_at_117, t107.title AS title_118, t107.created_by AS created_by_119, t107.updated_by AS updated_by_120, t0.latest_approval_request_id AS latest_approval_request_id_121, t122.id AS id_123, t122.handler_name AS handler_name_124, t122.title AS title_125, t122.target_id AS target_id_126, t122.request_type AS request_type_127, t122.moderated_at AS moderated_at_128, t122.approval_status AS approval_status_129, t122.comment AS comment_130, t122.created_at AS created_at_131, t122.updated_at AS updated_at_132, t122.facility_id AS facility_id_133, t122.requested_by AS requested_by_134, t122.moderated_by AS moderated_by_135 FROM cms_mod_restaurant_feature t0 LEFT JOIN cms_media_item_details t23 ON t0.thumbnail = t23.id AND ((t23.status = 1 AND (t23.publish_at IS NULL OR t23.publish_at <= "2025-09-17 08:12:40") AND (t23.expires_at IS NULL OR t23.expires_at > "2025-09-17 08:12:40"))) LEFT JOIN cms_facility t42 ON t0.facility_id = t42.id AND ((t42.status = 1 AND (t42.publish_at IS NULL OR t42.publish_at <= "2025-09-17 08:12:40") AND (t42.expires_at IS NULL OR t42.expires_at > "2025-09-17 08:12:40"))) LEFT JOIN cms_user t71 ON t0.created_by = t71.id LEFT JOIN cms_user t89 ON t0.updated_by = t89.id LEFT JOIN cms_master_languages t107 ON t0.language_id = t107.id AND ((t107.status = 1 AND (t107.publish_at IS NULL OR t107.publish_at <= "2025-09-17 08:12:40") AND (t107.expires_at IS NULL OR t107.expires_at > "2025-09-17 08:12:40"))) LEFT JOIN cms_approval_requests t122 ON t0.latest_approval_request_id = t122.id INNER JOIN cms_mod_restaurant_restaurants_features ON t0.id = cms_mod_restaurant_restaurants_features.feature_id WHERE cms_mod_restaurant_restaurants_features.restaurant_id = ? AND ((t0.post_type IN ("master")) AND (t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2025-09-17 08:12:40") AND (t0.expires_at IS NULL OR t0.expires_at > "2025-09-17 08:12:40") AND (t0.public_date IS NULL OR t0.public_date <= "2025-09-17"))) ORDER BY t0.background_color DESC, t0.sort_num ASC
SELECT
t0.title_for_list AS title_for_list_1,
t0.alias AS alias_2,
t0.show_in_list AS show_in_list_3,
t0.background_color AS background_color_4,
t0.public_date AS public_date_5,
t0.customblock AS customblock_6,
t0.id AS id_7,
t0.sort_num AS sort_num_8,
t0.status AS status_9,
t0.publish_at AS publish_at_10,
t0.expires_at AS expires_at_11,
t0.created_at AS created_at_12,
t0.updated_at AS updated_at_13,
t0.title AS title_14,
t0.language_parent AS language_parent_15,
t0.language_alias AS language_alias_16,
t0.language_active AS language_active_17,
t0.revision_parent AS revision_parent_18,
t0.revision_version AS revision_version_19,
t0.post_type AS post_type_20,
t0.access_token AS access_token_21,
t0.thumbnail AS thumbnail_22,
t23.alt AS alt_24,
t23.caption AS caption_25,
t23.collation_code AS collation_code_26,
t23.meta AS meta_27,
t23.id AS id_28,
t23.sort_num AS sort_num_29,
t23.status AS status_30,
t23.publish_at AS publish_at_31,
t23.expires_at AS expires_at_32,
t23.created_at AS created_at_33,
t23.updated_at AS updated_at_34,
t23.title AS title_35,
t23.item_id AS item_id_36,
t23.thumb_item_id AS thumb_item_id_37,
t23.group_id AS group_id_38,
t23.created_by AS created_by_39,
t23.updated_by AS updated_by_40,
t0.facility_id AS facility_id_41,
t42.code AS code_43,
t42.title AS title_44,
t42.intro_text AS intro_text_45,
t42.zip AS zip_46,
t42.address AS address_47,
t42.building AS building_48,
t42.google_maps_url AS google_maps_url_49,
t42.phone AS phone_50,
t42.website AS website_51,
t42.opening_hours AS opening_hours_52,
t42.holiday AS holiday_53,
t42.access AS access_54,
t42.access_car AS access_car_55,
t42.access_train AS access_train_56,
t42.id AS id_57,
t42.sort_num AS sort_num_58,
t42.status AS status_59,
t42.publish_at AS publish_at_60,
t42.expires_at AS expires_at_61,
t42.created_at AS created_at_62,
t42.updated_at AS updated_at_63,
t42.area_id AS area_id_64,
t42.prefecture_id AS prefecture_id_65,
t42.logo_image AS logo_image_66,
t42.main_image AS main_image_67,
t42.created_by AS created_by_68,
t42.updated_by AS updated_by_69,
t0.created_by AS created_by_70,
t71.username AS username_72,
t71.username_canonical AS username_canonical_73,
t71.enabled AS enabled_74,
t71.last_login AS last_login_75,
t71.confirmation_token AS confirmation_token_76,
t71.password_requested_at AS password_requested_at_77,
t71.roles AS roles_78,
t71.id AS id_79,
t71.display_name AS display_name_80,
t71.sort_num AS sort_num_81,
t71.email AS email_82,
t71.email_canonical AS email_canonical_83,
t71.salt AS salt_84,
t71.password AS password_85,
t71.group_id AS group_id_86,
t71.facility_id AS facility_id_87,
t0.updated_by AS updated_by_88,
t89.username AS username_90,
t89.username_canonical AS username_canonical_91,
t89.enabled AS enabled_92,
t89.last_login AS last_login_93,
t89.confirmation_token AS confirmation_token_94,
t89.password_requested_at AS password_requested_at_95,
t89.roles AS roles_96,
t89.id AS id_97,
t89.display_name AS display_name_98,
t89.sort_num AS sort_num_99,
t89.email AS email_100,
t89.email_canonical AS email_canonical_101,
t89.salt AS salt_102,
t89.password AS password_103,
t89.group_id AS group_id_104,
t89.facility_id AS facility_id_105,
t0.language_id AS language_id_106,
t107.alias AS alias_108,
t107.translate_key AS translate_key_109,
t107.target_key AS target_key_110,
t107.id AS id_111,
t107.sort_num AS sort_num_112,
t107.status AS status_113,
t107.publish_at AS publish_at_114,
t107.expires_at AS expires_at_115,
t107.created_at AS created_at_116,
t107.updated_at AS updated_at_117,
t107.title AS title_118,
t107.created_by AS created_by_119,
t107.updated_by AS updated_by_120,
t0.latest_approval_request_id AS latest_approval_request_id_121,
t122.id AS id_123,
t122.handler_name AS handler_name_124,
t122.title AS title_125,
t122.target_id AS target_id_126,
t122.request_type AS request_type_127,
t122.moderated_at AS moderated_at_128,
t122.approval_status AS approval_status_129,
t122.comment AS comment_130,
t122.created_at AS created_at_131,
t122.updated_at AS updated_at_132,
t122.facility_id AS facility_id_133,
t122.requested_by AS requested_by_134,
t122.moderated_by AS moderated_by_135
FROM
cms_mod_restaurant_feature t0
LEFT JOIN cms_media_item_details t23 ON t0.thumbnail = t23.id
AND (
(
t23.status = 1
AND (
t23.publish_at IS NULL
OR t23.publish_at <= "2025-09-17 08:12:40"
)
AND (
t23.expires_at IS NULL
OR t23.expires_at > "2025-09-17 08:12:40"
)
)
)
LEFT JOIN cms_facility t42 ON t0.facility_id = t42.id
AND (
(
t42.status = 1
AND (
t42.publish_at IS NULL
OR t42.publish_at <= "2025-09-17 08:12:40"
)
AND (
t42.expires_at IS NULL
OR t42.expires_at > "2025-09-17 08:12:40"
)
)
)
LEFT JOIN cms_user t71 ON t0.created_by = t71.id
LEFT JOIN cms_user t89 ON t0.updated_by = t89.id
LEFT JOIN cms_master_languages t107 ON t0.language_id = t107.id
AND (
(
t107.status = 1
AND (
t107.publish_at IS NULL
OR t107.publish_at <= "2025-09-17 08:12:40"
)
AND (
t107.expires_at IS NULL
OR t107.expires_at > "2025-09-17 08:12:40"
)
)
)
LEFT JOIN cms_approval_requests t122 ON t0.latest_approval_request_id = t122.id
INNER JOIN cms_mod_restaurant_restaurants_features ON t0.id = cms_mod_restaurant_restaurants_features.feature_id
WHERE
cms_mod_restaurant_restaurants_features.restaurant_id = ?
AND (
(
t0.post_type IN ("master")
)
AND (
t0.status = 1
AND (
t0.publish_at IS NULL
OR t0.publish_at <= "2025-09-17 08:12:40"
)
AND (
t0.expires_at IS NULL
OR t0.expires_at > "2025-09-17 08:12:40"
)
AND (
t0.public_date IS NULL
OR t0.public_date <= "2025-09-17"
)
)
)
ORDER BY
t0.background_color DESC,
t0.sort_num ASC
SELECT t0.title_for_list AS title_for_list_1, t0.alias AS alias_2, t0.show_in_list AS show_in_list_3, t0.background_color AS background_color_4, t0.public_date AS public_date_5, t0.customblock AS customblock_6, t0.id AS id_7, t0.sort_num AS sort_num_8, t0.status AS status_9, t0.publish_at AS publish_at_10, t0.expires_at AS expires_at_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.title AS title_14, t0.language_parent AS language_parent_15, t0.language_alias AS language_alias_16, t0.language_active AS language_active_17, t0.revision_parent AS revision_parent_18, t0.revision_version AS revision_version_19, t0.post_type AS post_type_20, t0.access_token AS access_token_21, t0.thumbnail AS thumbnail_22, t23.alt AS alt_24, t23.caption AS caption_25, t23.collation_code AS collation_code_26, t23.meta AS meta_27, t23.id AS id_28, t23.sort_num AS sort_num_29, t23.status AS status_30, t23.publish_at AS publish_at_31, t23.expires_at AS expires_at_32, t23.created_at AS created_at_33, t23.updated_at AS updated_at_34, t23.title AS title_35, t23.item_id AS item_id_36, t23.thumb_item_id AS thumb_item_id_37, t23.group_id AS group_id_38, t23.created_by AS created_by_39, t23.updated_by AS updated_by_40, t0.facility_id AS facility_id_41, t42.code AS code_43, t42.title AS title_44, t42.intro_text AS intro_text_45, t42.zip AS zip_46, t42.address AS address_47, t42.building AS building_48, t42.google_maps_url AS google_maps_url_49, t42.phone AS phone_50, t42.website AS website_51, t42.opening_hours AS opening_hours_52, t42.holiday AS holiday_53, t42.access AS access_54, t42.access_car AS access_car_55, t42.access_train AS access_train_56, t42.id AS id_57, t42.sort_num AS sort_num_58, t42.status AS status_59, t42.publish_at AS publish_at_60, t42.expires_at AS expires_at_61, t42.created_at AS created_at_62, t42.updated_at AS updated_at_63, t42.area_id AS area_id_64, t42.prefecture_id AS prefecture_id_65, t42.logo_image AS logo_image_66, t42.main_image AS main_image_67, t42.created_by AS created_by_68, t42.updated_by AS updated_by_69, t0.created_by AS created_by_70, t71.username AS username_72, t71.username_canonical AS username_canonical_73, t71.enabled AS enabled_74, t71.last_login AS last_login_75, t71.confirmation_token AS confirmation_token_76, t71.password_requested_at AS password_requested_at_77, t71.roles AS roles_78, t71.id AS id_79, t71.display_name AS display_name_80, t71.sort_num AS sort_num_81, t71.email AS email_82, t71.email_canonical AS email_canonical_83, t71.salt AS salt_84, t71.password AS password_85, t71.group_id AS group_id_86, t71.facility_id AS facility_id_87, t0.updated_by AS updated_by_88, t89.username AS username_90, t89.username_canonical AS username_canonical_91, t89.enabled AS enabled_92, t89.last_login AS last_login_93, t89.confirmation_token AS confirmation_token_94, t89.password_requested_at AS password_requested_at_95, t89.roles AS roles_96, t89.id AS id_97, t89.display_name AS display_name_98, t89.sort_num AS sort_num_99, t89.email AS email_100, t89.email_canonical AS email_canonical_101, t89.salt AS salt_102, t89.password AS password_103, t89.group_id AS group_id_104, t89.facility_id AS facility_id_105, t0.language_id AS language_id_106, t107.alias AS alias_108, t107.translate_key AS translate_key_109, t107.target_key AS target_key_110, t107.id AS id_111, t107.sort_num AS sort_num_112, t107.status AS status_113, t107.publish_at AS publish_at_114, t107.expires_at AS expires_at_115, t107.created_at AS created_at_116, t107.updated_at AS updated_at_117, t107.title AS title_118, t107.created_by AS created_by_119, t107.updated_by AS updated_by_120, t0.latest_approval_request_id AS latest_approval_request_id_121, t122.id AS id_123, t122.handler_name AS handler_name_124, t122.title AS title_125, t122.target_id AS target_id_126, t122.request_type AS request_type_127, t122.moderated_at AS moderated_at_128, t122.approval_status AS approval_status_129, t122.comment AS comment_130, t122.created_at AS created_at_131, t122.updated_at AS updated_at_132, t122.facility_id AS facility_id_133, t122.requested_by AS requested_by_134, t122.moderated_by AS moderated_by_135 FROM cms_mod_restaurant_feature t0 LEFT JOIN cms_media_item_details t23 ON t0.thumbnail = t23.id AND ((t23.status = 1 AND (t23.publish_at IS NULL OR t23.publish_at <= "2025-09-17 081:40") AND (t23.expires_at IS NULL OR t23.expires_at > "2025-09-17 08:12:40"))) LEFT JOIN cms_facility t42 ON t0.facility_id = t42.id AND ((t42.status = 1 AND (t42.publish_at IS NULL OR t42.publish_at <= "2025-09-17 08:12:40") AND (t42.expires_at IS NULL OR t42.expires_at > "2025-09-17 08:12:40"))) LEFT JOIN cms_user t71 ON t0.created_by = t71.id LEFT JOIN cms_user t89 ON t0.updated_by = t89.id LEFT JOIN cms_master_languages t107 ON t0.language_id = t107.id AND ((t107.status = 1 AND (t107.publish_at IS NULL OR t107.publish_at <= "2025-09-17 08:12:40") AND (t107.expires_at IS NULL OR t107.expires_at > "2025-09-17 08:12:40"))) LEFT JOIN cms_approval_requests t122 ON t0.latest_approval_request_id = t122.id INNER JOIN cms_mod_restaurant_restaurants_features ON t0.id = cms_mod_restaurant_restaurants_features.feature_id WHERE cms_mod_restaurant_restaurants_features.restaurant_id = ? AND ((t0.post_type IN ("master")) AND (t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2025-09-17 08:12:40") AND (t0.expires_at IS NULL OR t0.expires_at > "2025-09-17 08:12:40") AND (t0.public_date IS NULL OR t0.public_date <= "2025-09-17"))) ORDER BY t0.background_color DESC, t0.sort_num ASC;
|
3.22 ms
(15.02%)
|
1 |
SELECT t0.alias AS alias_1, t0.public_date AS public_date_2, t0.customblock AS customblock_3, t0.id AS id_4, t0.sort_num AS sort_num_5, t0.status AS status_6, t0.publish_at AS publish_at_7, t0.expires_at AS expires_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.title AS title_11, t0.language_parent AS language_parent_12, t0.language_alias AS language_alias_13, t0.language_active AS language_active_14, t0.revision_parent AS revision_parent_15, t0.revision_version AS revision_version_16, t0.post_type AS post_type_17, t0.access_token AS access_token_18, t0.thumbnail AS thumbnail_19, t20.alt AS alt_21, t20.caption AS caption_22, t20.collation_code AS collation_code_23, t20.meta AS meta_24, t20.id AS id_25, t20.sort_num AS sort_num_26, t20.status AS status_27, t20.publish_at AS publish_at_28, t20.expires_at AS expires_at_29, t20.created_at AS created_at_30, t20.updated_at AS updated_at_31, t20.title AS title_32, t20.item_id AS item_id_33, t20.thumb_item_id AS thumb_item_id_34, t20.group_id AS group_id_35, t20.created_by AS created_by_36, t20.updated_by AS updated_by_37, t0.facility_id AS facility_id_38, t39.code AS code_40, t39.title AS title_41, t39.intro_text AS intro_text_42, t39.zip AS zip_43, t39.address AS address_44, t39.building AS building_45, t39.google_maps_url AS google_maps_url_46, t39.phone AS phone_47, t39.website AS website_48, t39.opening_hours AS opening_hours_49, t39.holiday AS holiday_50, t39.access AS access_51, t39.access_car AS access_car_52, t39.access_train AS access_train_53, t39.id AS id_54, t39.sort_num AS sort_num_55, t39.status AS status_56, t39.publish_at AS publish_at_57, t39.expires_at AS expires_at_58, t39.created_at AS created_at_59, t39.updated_at AS updated_at_60, t39.area_id AS area_id_61, t39.prefecture_id AS prefecture_id_62, t39.logo_image AS logo_image_63, t39.main_image AS main_image_64, t39.created_by AS created_by_65, t39.updated_by AS updated_by_66, t0.created_by AS created_by_67, t68.username AS username_69, t68.username_canonical AS username_canonical_70, t68.enabled AS enabled_71, t68.last_login AS last_login_72, t68.confirmation_token AS confirmation_token_73, t68.password_requested_at AS password_requested_at_74, t68.roles AS roles_75, t68.id AS id_76, t68.display_name AS display_name_77, t68.sort_num AS sort_num_78, t68.email AS email_79, t68.email_canonical AS email_canonical_80, t68.salt AS salt_81, t68.password AS password_82, t68.group_id AS group_id_83, t68.facility_id AS facility_id_84, t0.updated_by AS updated_by_85, t86.username AS username_87, t86.username_canonical AS username_canonical_88, t86.enabled AS enabled_89, t86.last_login AS last_login_90, t86.confirmation_token AS confirmation_token_91, t86.password_requested_at AS password_requested_at_92, t86.roles AS roles_93, t86.id AS id_94, t86.display_name AS display_name_95, t86.sort_num AS sort_num_96, t86.email AS email_97, t86.email_canonical AS email_canonical_98, t86.salt AS salt_99, t86.password AS password_100, t86.group_id AS group_id_101, t86.facility_id AS facility_id_102, t0.language_id AS language_id_103, t104.alias AS alias_105, t104.translate_key AS translate_key_106, t104.target_key AS target_key_107, t104.id AS id_108, t104.sort_num AS sort_num_109, t104.status AS status_110, t104.publish_at AS publish_at_111, t104.expires_at AS expires_at_112, t104.created_at AS created_at_113, t104.updated_at AS updated_at_114, t104.title AS title_115, t104.created_by AS created_by_116, t104.updated_by AS updated_by_117, t0.latest_approval_request_id AS latest_approval_request_id_118, t119.id AS id_120, t119.handler_name AS handler_name_121, t119.title AS title_122, t119.target_id AS target_id_123, t119.request_type AS request_type_124, t119.moderated_at AS moderated_at_125, t119.approval_status AS approval_status_126, t119.comment AS comment_127, t119.created_at AS created_at_128, t119.updated_at AS updated_at_129, t119.facility_id AS facility_id_130, t119.requested_by AS requested_by_131, t119.moderated_by AS moderated_by_132 FROM cms_mod_restaurant_scenes t0 LEFT JOIN cms_media_item_details t20 ON t0.thumbnail = t20.id AND ((t20.status = 1 AND (t20.publish_at IS NULL OR t20.publish_at <= "2025-09-17 08:12:40") AND (t20.expires_at IS NULL OR t20.expires_at > "2025-09-17 08:12:40"))) LEFT JOIN cms_facility t39 ON t0.facility_id = t39.id AND ((t39.status = 1 AND (t39.publish_at IS NULL OR t39.publish_at <= "2025-09-17 08:12:40") AND (t39.expires_at IS NULL OR t39.expires_at > "2025-09-17 08:12:40"))) LEFT JOIN cms_user t68 ON t0.created_by = t68.id LEFT JOIN cms_user t86 ON t0.updated_by = t86.id LEFT JOIN cms_master_languages t104 ON t0.language_id = t104.id AND ((t104.status = 1 AND (t104.publish_at IS NULL OR t104.publish_at <= "2025-09-17 08:12:40") AND (t104.expires_at IS NULL OR t104.expires_at > "2025-09-17 08:12:40"))) LEFT JOIN cms_approval_requests t119 ON t0.latest_approval_request_id = t119.id INNER JOIN cms_mod_restaurant_restaurants_scenes ON t0.id = cms_mod_restaurant_restaurants_scenes.scene_id WHERE cms_mod_restaurant_restaurants_scenes.restaurant_id = ? AND ((t0.post_type IN ("master")) AND (t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2025-09-17 08:12:40") AND (t0.expires_at IS NULL OR t0.expires_at > "2025-09-17 08:12:40") AND (t0.public_date IS NULL OR t0.public_date <= "2025-09-17"))) ORDER BY t0.sort_num ASC, t0.id ASC
SELECT
t0.alias AS alias_1,
t0.public_date AS public_date_2,
t0.customblock AS customblock_3,
t0.id AS id_4,
t0.sort_num AS sort_num_5,
t0.status AS status_6,
t0.publish_at AS publish_at_7,
t0.expires_at AS expires_at_8,
t0.created_at AS created_at_9,
t0.updated_at AS updated_at_10,
t0.title AS title_11,
t0.language_parent AS language_parent_12,
t0.language_alias AS language_alias_13,
t0.language_active AS language_active_14,
t0.revision_parent AS revision_parent_15,
t0.revision_version AS revision_version_16,
t0.post_type AS post_type_17,
t0.access_token AS access_token_18,
t0.thumbnail AS thumbnail_19,
t20.alt AS alt_21,
t20.caption AS caption_22,
t20.collation_code AS collation_code_23,
t20.meta AS meta_24,
t20.id AS id_25,
t20.sort_num AS sort_num_26,
t20.status AS status_27,
t20.publish_at AS publish_at_28,
t20.expires_at AS expires_at_29,
t20.created_at AS created_at_30,
t20.updated_at AS updated_at_31,
t20.title AS title_32,
t20.item_id AS item_id_33,
t20.thumb_item_id AS thumb_item_id_34,
t20.group_id AS group_id_35,
t20.created_by AS created_by_36,
t20.updated_by AS updated_by_37,
t0.facility_id AS facility_id_38,
t39.code AS code_40,
t39.title AS title_41,
t39.intro_text AS intro_text_42,
t39.zip AS zip_43,
t39.address AS address_44,
t39.building AS building_45,
t39.google_maps_url AS google_maps_url_46,
t39.phone AS phone_47,
t39.website AS website_48,
t39.opening_hours AS opening_hours_49,
t39.holiday AS holiday_50,
t39.access AS access_51,
t39.access_car AS access_car_52,
t39.access_train AS access_train_53,
t39.id AS id_54,
t39.sort_num AS sort_num_55,
t39.status AS status_56,
t39.publish_at AS publish_at_57,
t39.expires_at AS expires_at_58,
t39.created_at AS created_at_59,
t39.updated_at AS updated_at_60,
t39.area_id AS area_id_61,
t39.prefecture_id AS prefecture_id_62,
t39.logo_image AS logo_image_63,
t39.main_image AS main_image_64,
t39.created_by AS created_by_65,
t39.updated_by AS updated_by_66,
t0.created_by AS created_by_67,
t68.username AS username_69,
t68.username_canonical AS username_canonical_70,
t68.enabled AS enabled_71,
t68.last_login AS last_login_72,
t68.confirmation_token AS confirmation_token_73,
t68.password_requested_at AS password_requested_at_74,
t68.roles AS roles_75,
t68.id AS id_76,
t68.display_name AS display_name_77,
t68.sort_num AS sort_num_78,
t68.email AS email_79,
t68.email_canonical AS email_canonical_80,
t68.salt AS salt_81,
t68.password AS password_82,
t68.group_id AS group_id_83,
t68.facility_id AS facility_id_84,
t0.updated_by AS updated_by_85,
t86.username AS username_87,
t86.username_canonical AS username_canonical_88,
t86.enabled AS enabled_89,
t86.last_login AS last_login_90,
t86.confirmation_token AS confirmation_token_91,
t86.password_requested_at AS password_requested_at_92,
t86.roles AS roles_93,
t86.id AS id_94,
t86.display_name AS display_name_95,
t86.sort_num AS sort_num_96,
t86.email AS email_97,
t86.email_canonical AS email_canonical_98,
t86.salt AS salt_99,
t86.password AS password_100,
t86.group_id AS group_id_101,
t86.facility_id AS facility_id_102,
t0.language_id AS language_id_103,
t104.alias AS alias_105,
t104.translate_key AS translate_key_106,
t104.target_key AS target_key_107,
t104.id AS id_108,
t104.sort_num AS sort_num_109,
t104.status AS status_110,
t104.publish_at AS publish_at_111,
t104.expires_at AS expires_at_112,
t104.created_at AS created_at_113,
t104.updated_at AS updated_at_114,
t104.title AS title_115,
t104.created_by AS created_by_116,
t104.updated_by AS updated_by_117,
t0.latest_approval_request_id AS latest_approval_request_id_118,
t119.id AS id_120,
t119.handler_name AS handler_name_121,
t119.title AS title_122,
t119.target_id AS target_id_123,
t119.request_type AS request_type_124,
t119.moderated_at AS moderated_at_125,
t119.approval_status AS approval_status_126,
t119.comment AS comment_127,
t119.created_at AS created_at_128,
t119.updated_at AS updated_at_129,
t119.facility_id AS facility_id_130,
t119.requested_by AS requested_by_131,
t119.moderated_by AS moderated_by_132
FROM
cms_mod_restaurant_scenes t0
LEFT JOIN cms_media_item_details t20 ON t0.thumbnail = t20.id
AND (
(
t20.status = 1
AND (
t20.publish_at IS NULL
OR t20.publish_at <= "2025-09-17 08:12:40"
)
AND (
t20.expires_at IS NULL
OR t20.expires_at > "2025-09-17 08:12:40"
)
)
)
LEFT JOIN cms_facility t39 ON t0.facility_id = t39.id
AND (
(
t39.status = 1
AND (
t39.publish_at IS NULL
OR t39.publish_at <= "2025-09-17 08:12:40"
)
AND (
t39.expires_at IS NULL
OR t39.expires_at > "2025-09-17 08:12:40"
)
)
)
LEFT JOIN cms_user t68 ON t0.created_by = t68.id
LEFT JOIN cms_user t86 ON t0.updated_by = t86.id
LEFT JOIN cms_master_languages t104 ON t0.language_id = t104.id
AND (
(
t104.status = 1
AND (
t104.publish_at IS NULL
OR t104.publish_at <= "2025-09-17 08:12:40"
)
AND (
t104.expires_at IS NULL
OR t104.expires_at > "2025-09-17 08:12:40"
)
)
)
LEFT JOIN cms_approval_requests t119 ON t0.latest_approval_request_id = t119.id
INNER JOIN cms_mod_restaurant_restaurants_scenes ON t0.id = cms_mod_restaurant_restaurants_scenes.scene_id
WHERE
cms_mod_restaurant_restaurants_scenes.restaurant_id = ?
AND (
(
t0.post_type IN ("master")
)
AND (
t0.status = 1
AND (
t0.publish_at IS NULL
OR t0.publish_at <= "2025-09-17 08:12:40"
)
AND (
t0.expires_at IS NULL
OR t0.expires_at > "2025-09-17 08:12:40"
)
AND (
t0.public_date IS NULL
OR t0.public_date <= "2025-09-17"
)
)
)
ORDER BY
t0.sort_num ASC,
t0.id ASC
SELECT t0.alias AS alias_1, t0.public_date AS public_date_2, t0.customblock AS customblock_3, t0.id AS id_4, t0.sort_num AS sort_num_5, t0.status AS status_6, t0.publish_at AS publish_at_7, t0.expires_at AS expires_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.title AS title_11, t0.language_parent AS language_parent_12, t0.language_alias AS language_alias_13, t0.language_active AS language_active_14, t0.revision_parent AS revision_parent_15, t0.revision_version AS revision_version_16, t0.post_type AS post_type_17, t0.access_token AS access_token_18, t0.thumbnail AS thumbnail_19, t20.alt AS alt_21, t20.caption AS caption_22, t20.collation_code AS collation_code_23, t20.meta AS meta_24, t20.id AS id_25, t20.sort_num AS sort_num_26, t20.status AS status_27, t20.publish_at AS publish_at_28, t20.expires_at AS expires_at_29, t20.created_at AS created_at_30, t20.updated_at AS updated_at_31, t20.title AS title_32, t20.item_id AS item_id_33, t20.thumb_item_id AS thumb_item_id_34, t20.group_id AS group_id_35, t20.created_by AS created_by_36, t20.updated_by AS updated_by_37, t0.facility_id AS facility_id_38, t39.code AS code_40, t39.title AS title_41, t39.intro_text AS intro_text_42, t39.zip AS zip_43, t39.address AS address_44, t39.building AS building_45, t39.google_maps_url AS google_maps_url_46, t39.phone AS phone_47, t39.website AS website_48, t39.opening_hours AS opening_hours_49, t39.holiday AS holiday_50, t39.access AS access_51, t39.access_car AS access_car_52, t39.access_train AS access_train_53, t39.id AS id_54, t39.sort_num AS sort_num_55, t39.status AS status_56, t39.publish_at AS publish_at_57, t39.expires_at AS expires_at_58, t39.created_at AS created_at_59, t39.updated_at AS updated_at_60, t39.area_id AS area_id_61, t39.prefecture_id AS prefecture_id_62, t39.logo_image AS logo_image_63, t39.main_image AS main_image_64, t39.created_by AS created_by_65, t39.updated_by AS updated_by_66, t0.created_by AS created_by_67, t68.username AS username_69, t68.username_canonical AS username_canonical_70, t68.enabled AS enabled_71, t68.last_login AS last_login_72, t68.confirmation_token AS confirmation_token_73, t68.password_requested_at AS password_requested_at_74, t68.roles AS roles_75, t68.id AS id_76, t68.display_name AS display_name_77, t68.sort_num AS sort_num_78, t68.email AS email_79, t68.email_canonical AS email_canonical_80, t68.salt AS salt_81, t68.password AS password_82, t68.group_id AS group_id_83, t68.facility_id AS facility_id_84, t0.updated_by AS updated_by_85, t86.username AS username_87, t86.username_canonical AS username_canonical_88, t86.enabled AS enabled_89, t86.last_login AS last_login_90, t86.confirmation_token AS confirmation_token_91, t86.password_requested_at AS password_requested_at_92, t86.roles AS roles_93, t86.id AS id_94, t86.display_name AS display_name_95, t86.sort_num AS sort_num_96, t86.email AS email_97, t86.email_canonical AS email_canonical_98, t86.salt AS salt_99, t86.password AS password_100, t86.group_id AS group_id_101, t86.facility_id AS facility_id_102, t0.language_id AS language_id_103, t104.alias AS alias_105, t104.translate_key AS translate_key_106, t104.target_key AS target_key_107, t104.id AS id_108, t104.sort_num AS sort_num_109, t104.status AS status_110, t104.publish_at AS publish_at_111, t104.expires_at AS expires_at_112, t104.created_at AS created_at_113, t104.updated_at AS updated_at_114, t104.title AS title_115, t104.created_by AS created_by_116, t104.updated_by AS updated_by_117, t0.latest_approval_request_id AS latest_approval_request_id_118, t119.id AS id_120, t119.handler_name AS handler_name_121, t119.title AS title_122, t119.target_id AS target_id_123, t119.request_type AS request_type_124, t119.moderated_at AS moderated_at_125, t119.approval_status AS approval_status_126, t119.comment AS comment_127, t119.created_at AS created_at_128, t119.updated_at AS updated_at_129, t119.facility_id AS facility_id_130, t119.requested_by AS requested_by_131, t119.moderated_by AS moderated_by_132 FROM cms_mod_restaurant_scenes t0 LEFT JOIN cms_media_item_details t20 ON t0.thumbnail = t20.id AND ((t20.status = 1 AND (t20.publish_at IS NULL OR t20.publish_at <= "2025-09-17 081:40") AND (t20.expires_at IS NULL OR t20.expires_at > "2025-09-17 08:12:40"))) LEFT JOIN cms_facility t39 ON t0.facility_id = t39.id AND ((t39.status = 1 AND (t39.publish_at IS NULL OR t39.publish_at <= "2025-09-17 08:12:40") AND (t39.expires_at IS NULL OR t39.expires_at > "2025-09-17 08:12:40"))) LEFT JOIN cms_user t68 ON t0.created_by = t68.id LEFT JOIN cms_user t86 ON t0.updated_by = t86.id LEFT JOIN cms_master_languages t104 ON t0.language_id = t104.id AND ((t104.status = 1 AND (t104.publish_at IS NULL OR t104.publish_at <= "2025-09-17 08:12:40") AND (t104.expires_at IS NULL OR t104.expires_at > "2025-09-17 08:12:40"))) LEFT JOIN cms_approval_requests t119 ON t0.latest_approval_request_id = t119.id INNER JOIN cms_mod_restaurant_restaurants_scenes ON t0.id = cms_mod_restaurant_restaurants_scenes.scene_id WHERE cms_mod_restaurant_restaurants_scenes.restaurant_id = ? AND ((t0.post_type IN ("master")) AND (t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2025-09-17 08:12:40") AND (t0.expires_at IS NULL OR t0.expires_at > "2025-09-17 08:12:40") AND (t0.public_date IS NULL OR t0.public_date <= "2025-09-17"))) ORDER BY t0.sort_num ASC, t0.id ASC;
|
3.07 ms
(14.29%)
|
1 |
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 <= "2025-09-17 08:12:40") AND (t14.expires_at IS NULL OR t14.expires_at > "2025-09-17 08:12:40"))) 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 <= "2025-09-17 08:12:40") AND (t50.expires_at IS NULL OR t50.expires_at > "2025-09-17 08:12:40"))) LEFT JOIN cms_user t87 ON t0.created_by = t87.id LEFT JOIN cms_user t105 ON t0.updated_by = t105.id WHERE t0.group_id = ? AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2025-09-17 08:12:40") AND (t0.expires_at IS NULL OR t0.expires_at > "2025-09-17 08:12:40"))) ORDER BY t0.sort_num ASC
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 <= "2025-09-17 08:12:40"
)
AND (
t14.expires_at IS NULL
OR t14.expires_at > "2025-09-17 08:12:40"
)
)
)
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 <= "2025-09-17 08:12:40"
)
AND (
t50.expires_at IS NULL
OR t50.expires_at > "2025-09-17 08:12:40"
)
)
)
LEFT JOIN cms_user t87 ON t0.created_by = t87.id
LEFT JOIN cms_user t105 ON t0.updated_by = t105.id
WHERE
t0.group_id = ?
AND (
(
t0.status = 1
AND (
t0.publish_at IS NULL
OR t0.publish_at <= "2025-09-17 08:12:40"
)
AND (
t0.expires_at IS NULL
OR t0.expires_at > "2025-09-17 08:12:40"
)
)
)
ORDER BY
t0.sort_num ASC
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 <= "2025-09-17 08354:40") AND (t14.expires_at IS NULL OR t14.expires_at > "2025-09-17 08:12:40"))) 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 <= "2025-09-17 08:12:40") AND (t50.expires_at IS NULL OR t50.expires_at > "2025-09-17 08:12:40"))) LEFT JOIN cms_user t87 ON t0.created_by = t87.id LEFT JOIN cms_user t105 ON t0.updated_by = t105.id WHERE t0.group_id = ? AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2025-09-17 08:12:40") AND (t0.expires_at IS NULL OR t0.expires_at > "2025-09-17 08:12:40"))) ORDER BY t0.sort_num ASC;
|
1.81 ms
(8.45%)
|
1 |
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);
|