SELECT 
  cscart_banners.banner_id, 
  cscart_banners.status, 
  cscart_banner_descriptions.banner, 
  cscart_banners.type, 
  cscart_banners.target, 
  cscart_banners.localization, 
  cscart_banners.timestamp, 
  cscart_banners.position, 
  cscart_banner_descriptions.description, 
  cscart_banner_descriptions.url, 
  cscart_banner_images.banner_image_id, 
  cscart_banners.company_id as company_id, 
  cscart_banners.abt__yt_use_avail_period, 
  cscart_banners.abt__yt_avail_from, 
  cscart_banners.abt__yt_avail_till, 
  cscart_banners.abt__yt_button_use, 
  cscart_banners.abt__yt_button_text_color, 
  cscart_banners.abt__yt_button_text_color_use, 
  cscart_banners.abt__yt_button_color, 
  cscart_banners.abt__yt_button_color_use, 
  cscart_banners.abt__yt_title_color, 
  cscart_banners.abt__yt_title_color_use, 
  cscart_banners.abt__yt_title_font_size, 
  cscart_banners.abt__yt_title_font_weight, 
  cscart_banners.abt__yt_title_tag, 
  cscart_banners.abt__yt_title_shadow, 
  cscart_banners.abt__yt_description_font_size, 
  cscart_banners.abt__yt_description_color, 
  cscart_banners.abt__yt_description_color_use, 
  cscart_banners.abt__yt_description_bg_color, 
  cscart_banners.abt__yt_description_bg_color_use, 
  cscart_banners.abt__yt_object, 
  cscart_banners.abt__yt_background_color, 
  cscart_banners.abt__yt_background_color_use, 
  cscart_banners.abt__yt_class, 
  cscart_banners.abt__yt_color_scheme, 
  cscart_banners.abt__yt_content_valign, 
  cscart_banners.abt__yt_content_align, 
  cscart_banners.abt__yt_content_full_width, 
  cscart_banners.abt__yt_content_bg, 
  cscart_banners.abt__yt_padding, 
  cscart_banners.abt__yt_how_to_open, 
  cscart_banners.abt__yt_data_type, 
  cscart_banners.abt__yt_page_id, 
  cscart_banners.abt__yt_youtube_use, 
  cscart_banners.abt__yt_youtube_autoplay, 
  cscart_banners.abt__yt_youtube_loop, 
  cscart_banners.abt__yt_youtube_hide_controls, 
  cscart_banners.abt__yt_product_list_use, 
  cscart_banners.abt__yt_product_list, 
  cscart_banners.abt__yt_promotion_id, 
  cscart_banners.abt__yt_countdown_use, 
  cscart_banner_descriptions.abt__yt_button_text, 
  cscart_banner_descriptions.abt__yt_title, 
  cscart_banner_descriptions.abt__yt_url, 
  cscart_banner_descriptions.abt__yt_description, 
  cscart_banner_descriptions.abt__yt_youtube_id, 
  cscart_banner_descriptions.abt__yt_youtube_playlist, 
  cscart_banner_descriptions.abt__yt_product_list_title 
FROM 
  cscart_banners 
  LEFT JOIN cscart_banner_descriptions ON cscart_banner_descriptions.banner_id = cscart_banners.banner_id 
  AND cscart_banner_descriptions.lang_code = 'ru' 
  LEFT JOIN cscart_banner_images ON cscart_banner_images.banner_id = cscart_banners.banner_id 
  AND cscart_banner_images.lang_code = 'ru' 
WHERE 
  cscart_banners.banner_id = 59 
  AND cscart_banners.status IN ('A', 'H')

Query time 0.00029

JSON explain

{
  "query_block": {
    "select_id": 1,
    "const_condition": "1",
    "table": {
      "table_name": "cscart_banners",
      "access_type": "const",
      "possible_keys": ["PRIMARY", "status"],
      "key": "PRIMARY",
      "key_length": "3",
      "used_key_parts": ["banner_id"],
      "ref": ["const"],
      "rows": 1,
      "filtered": 100
    },
    "table": {
      "table_name": "cscart_banner_descriptions",
      "access_type": "const",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "9",
      "used_key_parts": ["banner_id", "lang_code"],
      "ref": ["const", "const"],
      "rows": 1,
      "filtered": 100
    },
    "table": {
      "table_name": "cscart_banner_images",
      "access_type": "const",
      "possible_keys": ["banner"],
      "key": "banner",
      "key_length": "9",
      "used_key_parts": ["banner_id", "lang_code"],
      "ref": ["const", "const"],
      "rows": 1,
      "filtered": 100
    }
  }
}

Result

banner_id status banner type target localization timestamp position description url banner_image_id company_id abt__yt_use_avail_period abt__yt_avail_from abt__yt_avail_till abt__yt_button_use abt__yt_button_text_color abt__yt_button_text_color_use abt__yt_button_color abt__yt_button_color_use abt__yt_title_color abt__yt_title_color_use abt__yt_title_font_size abt__yt_title_font_weight abt__yt_title_tag abt__yt_title_shadow abt__yt_description_font_size abt__yt_description_color abt__yt_description_color_use abt__yt_description_bg_color abt__yt_description_bg_color_use abt__yt_object abt__yt_background_color abt__yt_background_color_use abt__yt_class abt__yt_color_scheme abt__yt_content_valign abt__yt_content_align abt__yt_content_full_width abt__yt_content_bg abt__yt_padding abt__yt_how_to_open abt__yt_data_type abt__yt_page_id abt__yt_youtube_use abt__yt_youtube_autoplay abt__yt_youtube_loop abt__yt_youtube_hide_controls abt__yt_product_list_use abt__yt_product_list abt__yt_promotion_id abt__yt_countdown_use abt__yt_button_text abt__yt_title abt__yt_url abt__yt_description abt__yt_youtube_id abt__yt_youtube_playlist abt__yt_product_list_title
59 A Запись на массаж G T 1781557200 0 https://orbitlonglife.ru/zapisatsya-na-seans-besplatnogo-massazha/ 133 1 N 0 0 N N N N 18px 300 div N 13px N N image N light center center N N in_this_window url 0 N N N N N 0 N