Sandbox

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_banner_descriptions.description, 
  cscart_banner_descriptions.url, 
  cscart_banner_images.banner_image_id, 
  cscart_banners.group_id, 
  cscart_abt__ut2_banner_images.abt__ut2_banner_image_id, 
  cscart_banners.abt__ut2_usergroup_ids, 
  cscart_banners.abt__ut2_use_avail_period, 
  cscart_banners.abt__ut2_avail_from, 
  cscart_banners.abt__ut2_avail_till, 
  cscart_banners.abt__ut2_button_use, 
  cscart_banners.abt__ut2_button_style, 
  cscart_banners.abt__ut2_button_text_color, 
  cscart_banners.abt__ut2_button_text_color_use, 
  cscart_banners.abt__ut2_button_color, 
  cscart_banners.abt__ut2_button_color_use, 
  cscart_banners.abt__ut2_title_color, 
  cscart_banners.abt__ut2_title_color_use, 
  cscart_banners.abt__ut2_title_font_size, 
  cscart_banners.abt__ut2_title_font_weight, 
  cscart_banners.abt__ut2_title_tag, 
  cscart_banners.abt__ut2_background_image_size, 
  cscart_banners.abt__ut2_image_position, 
  cscart_banners.abt__ut2_title_shadow, 
  cscart_banners.abt__ut2_description_font_size, 
  cscart_banners.abt__ut2_description_color, 
  cscart_banners.abt__ut2_description_color_use, 
  cscart_banners.abt__ut2_description_bg_color, 
  cscart_banners.abt__ut2_description_bg_color_use, 
  cscart_banners.abt__ut2_object, 
  cscart_banners.abt__ut2_background_color, 
  cscart_banners.abt__ut2_background_color_use, 
  cscart_banners.abt__ut2_class, 
  cscart_banners.abt__ut2_color_scheme, 
  cscart_banners.abt__ut2_content_valign, 
  cscart_banners.abt__ut2_content_align, 
  cscart_banners.abt__ut2_content_full_width, 
  cscart_banners.abt__ut2_content_bg, 
  cscart_banners.abt__ut2_content_bg_position, 
  cscart_banners.abt__ut2_content_bg_align, 
  cscart_banners.abt__ut2_content_bg_opacity, 
  cscart_banners.abt__ut2_content_bg_color, 
  cscart_banners.abt__ut2_content_bg_color_use, 
  cscart_banners.abt__ut2_padding, 
  cscart_banners.abt__ut2_how_to_open, 
  cscart_banners.abt__ut2_data_type, 
  cscart_banners.abt__ut2_youtube_use, 
  cscart_banners.abt__ut2_youtube_autoplay, 
  cscart_banners.abt__ut2_youtube_hide_controls, 
  cscart_banners.abt__ut2_background_type, 
  cscart_banners.abt__ut2_background_mp4_video, 
  cscart_banner_descriptions.abt__ut2_button_text, 
  cscart_banner_descriptions.abt__ut2_title, 
  cscart_banner_descriptions.abt__ut2_url, 
  cscart_banner_descriptions.abt__ut2_description, 
  cscart_banner_descriptions.abt__ut2_youtube_id, 
  cscart_banners.abt__ut2_products_template, 
  cscart_banners.abt__ut2_products_links_thumb_columns, 
  cscart_banners.abt__ut2_products_links_thumb_rows, 
  cscart_banners.abt__ut2_products_small_items_columns, 
  cscart_banners.abt__ut2_products_small_items_rows, 
  cscart_banners.abt__ut2_products_grid_columns, 
  cscart_banners.abt__ut2_products_list, 
  cscart_banners.abt__ut2_tablet_use, 
  cscart_banners.abt__ut2_tablet_content_valign, 
  cscart_banners.abt__ut2_tablet_content_valign_use_own, 
  cscart_banners.abt__ut2_tablet_content_align, 
  cscart_banners.abt__ut2_tablet_content_align_use_own, 
  cscart_banners.abt__ut2_tablet_padding, 
  cscart_banners.abt__ut2_tablet_padding_use_own, 
  cscart_banners.abt__ut2_tablet_content_full_width, 
  cscart_banners.abt__ut2_tablet_content_full_width_use_own, 
  cscart_banner_descriptions.abt__ut2_tablet_title, 
  cscart_banner_descriptions.abt__ut2_tablet_title_use_own, 
  cscart_banners.abt__ut2_tablet_title_font_size, 
  cscart_banners.abt__ut2_tablet_title_font_size_use_own, 
  cscart_banners.abt__ut2_tablet_title_shadow, 
  cscart_banners.abt__ut2_tablet_title_shadow_use_own, 
  cscart_banner_descriptions.abt__ut2_tablet_description, 
  cscart_banner_descriptions.abt__ut2_tablet_description_use_own, 
  cscart_banners.abt__ut2_tablet_description_font_size, 
  cscart_banners.abt__ut2_tablet_description_font_size_use_own, 
  cscart_banners.abt__ut2_tablet_main_image_use_own, 
  cscart_banners.abt__ut2_tablet_background_type, 
  cscart_banners.abt__ut2_tablet_background_type_use_own, 
  cscart_banners.abt__ut2_tablet_background_mp4_video, 
  cscart_banners.abt__ut2_tablet_background_mp4_video_use_own, 
  cscart_banners.abt__ut2_tablet_background_image_use_own, 
  cscart_banners.abt__ut2_tablet_background_image_size, 
  cscart_banners.abt__ut2_tablet_background_image_size_use_own, 
  cscart_banners.abt__ut2_tablet_image_position, 
  cscart_banners.abt__ut2_tablet_image_position_use_own, 
  cscart_banners.abt__ut2_tablet_button_use, 
  cscart_banners.abt__ut2_tablet_button_use_use_own, 
  cscart_banner_descriptions.abt__ut2_tablet_button_text, 
  cscart_banner_descriptions.abt__ut2_tablet_button_text_use_own, 
  cscart_banners.abt__ut2_tablet_content_bg, 
  cscart_banners.abt__ut2_tablet_content_bg_use_own, 
  cscart_banners.abt__ut2_tablet_content_bg_position, 
  cscart_banners.abt__ut2_tablet_content_bg_position_use_own, 
  cscart_banners.abt__ut2_tablet_content_bg_align, 
  cscart_banners.abt__ut2_tablet_content_bg_align_use_own, 
  cscart_banners.abt__ut2_tablet_content_bg_opacity, 
  cscart_banners.abt__ut2_tablet_content_bg_opacity_use_own, 
  cscart_banners.abt__ut2_tablet_content_bg_color, 
  cscart_banners.abt__ut2_tablet_content_bg_color_use_own, 
  cscart_banners.abt__ut2_tablet_content_bg_color_use, 
  cscart_banners.abt__ut2_tablet_content_bg_color_use_use_own, 
  cscart_banners.abt__ut2_tablet_button_text_color, 
  cscart_banners.abt__ut2_tablet_button_text_color_use_own, 
  cscart_banners.abt__ut2_tablet_button_text_color_use, 
  cscart_banners.abt__ut2_tablet_button_text_color_use_use_own, 
  cscart_banners.abt__ut2_tablet_button_color, 
  cscart_banners.abt__ut2_tablet_button_color_use_own, 
  cscart_banners.abt__ut2_tablet_button_color_use, 
  cscart_banners.abt__ut2_tablet_button_color_use_use_own, 
  cscart_banners.abt__ut2_mobile_use, 
  cscart_banners.abt__ut2_mobile_content_valign, 
  cscart_banners.abt__ut2_mobile_content_valign_use_own, 
  cscart_banners.abt__ut2_mobile_content_align, 
  cscart_banners.abt__ut2_mobile_content_align_use_own, 
  cscart_banners.abt__ut2_mobile_padding, 
  cscart_banners.abt__ut2_mobile_padding_use_own, 
  cscart_banners.abt__ut2_mobile_content_full_width, 
  cscart_banners.abt__ut2_mobile_content_full_width_use_own, 
  cscart_banner_descriptions.abt__ut2_mobile_title, 
  cscart_banner_descriptions.abt__ut2_mobile_title_use_own, 
  cscart_banners.abt__ut2_mobile_title_font_size, 
  cscart_banners.abt__ut2_mobile_title_font_size_use_own, 
  cscart_banners.abt__ut2_mobile_title_shadow, 
  cscart_banners.abt__ut2_mobile_title_shadow_use_own, 
  cscart_banner_descriptions.abt__ut2_mobile_description, 
  cscart_banner_descriptions.abt__ut2_mobile_description_use_own, 
  cscart_banners.abt__ut2_mobile_description_font_size, 
  cscart_banners.abt__ut2_mobile_description_font_size_use_own, 
  cscart_banners.abt__ut2_mobile_main_image_use_own, 
  cscart_banners.abt__ut2_mobile_background_type, 
  cscart_banners.abt__ut2_mobile_background_type_use_own, 
  cscart_banners.abt__ut2_mobile_background_mp4_video, 
  cscart_banners.abt__ut2_mobile_background_mp4_video_use_own, 
  cscart_banners.abt__ut2_mobile_background_image_use_own, 
  cscart_banners.abt__ut2_mobile_background_image_size, 
  cscart_banners.abt__ut2_mobile_background_image_size_use_own, 
  cscart_banners.abt__ut2_mobile_image_position, 
  cscart_banners.abt__ut2_mobile_image_position_use_own, 
  cscart_banners.abt__ut2_mobile_button_use, 
  cscart_banners.abt__ut2_mobile_button_use_use_own, 
  cscart_banner_descriptions.abt__ut2_mobile_button_text, 
  cscart_banner_descriptions.abt__ut2_mobile_button_text_use_own, 
  cscart_banners.abt__ut2_mobile_content_bg, 
  cscart_banners.abt__ut2_mobile_content_bg_use_own, 
  cscart_banners.abt__ut2_mobile_content_bg_position, 
  cscart_banners.abt__ut2_mobile_content_bg_position_use_own, 
  cscart_banners.abt__ut2_mobile_content_bg_align, 
  cscart_banners.abt__ut2_mobile_content_bg_align_use_own, 
  cscart_banners.abt__ut2_mobile_content_bg_opacity, 
  cscart_banners.abt__ut2_mobile_content_bg_opacity_use_own, 
  cscart_banners.abt__ut2_mobile_content_bg_color, 
  cscart_banners.abt__ut2_mobile_content_bg_color_use_own, 
  cscart_banners.abt__ut2_mobile_content_bg_color_use, 
  cscart_banners.abt__ut2_mobile_content_bg_color_use_use_own, 
  cscart_banners.abt__ut2_mobile_button_text_color, 
  cscart_banners.abt__ut2_mobile_button_text_color_use_own, 
  cscart_banners.abt__ut2_mobile_button_text_color_use, 
  cscart_banners.abt__ut2_mobile_button_text_color_use_use_own, 
  cscart_banners.abt__ut2_mobile_button_color, 
  cscart_banners.abt__ut2_mobile_button_color_use_own, 
  cscart_banners.abt__ut2_mobile_button_color_use, 
  cscart_banners.abt__ut2_mobile_button_color_use_use_own 
FROM 
  cscart_banners 
  LEFT JOIN cscart_banner_descriptions ON cscart_banner_descriptions.banner_id = cscart_banners.banner_id 
  AND cscart_banner_descriptions.lang_code = 'de' 
  LEFT JOIN cscart_banner_images ON cscart_banner_images.banner_id = cscart_banners.banner_id 
  AND cscart_banner_images.lang_code = 'de' 
  LEFT JOIN cscart_abt__ut2_banner_images ON cscart_abt__ut2_banner_images.banner_id = cscart_banners.banner_id 
  AND cscart_abt__ut2_banner_images.lang_code = 'de' 
WHERE 
  cscart_banners.banner_id = 49 
  AND cscart_banners.status IN ('A', 'H')

Query time 0.00045

JSON explain

{
  "query_block": {
    "select_id": 1,
    "const_condition": "1",
    "nested_loop": [
      {
        "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,
          "unique_row_not_found": true
        }
      },
      {
        "table": {
          "table_name": "cscart_abt__ut2_banner_images",
          "access_type": "const",
          "possible_keys": ["banner_lang_code"],
          "key": "banner_lang_code",
          "key_length": "9",
          "used_key_parts": ["banner_id", "lang_code"],
          "ref": ["const", "const"],
          "rows": 1,
          "filtered": 100,
          "using_index": true
        }
      }
    ]
  }
}

Result

banner_id	status	banner	type	target	localization	timestamp	description	url	banner_image_id	group_id	abt__ut2_banner_image_id	abt__ut2_usergroup_ids	abt__ut2_use_avail_period	abt__ut2_avail_from	abt__ut2_avail_till	abt__ut2_button_use	abt__ut2_button_style	abt__ut2_button_text_color	abt__ut2_button_text_color_use	abt__ut2_button_color	abt__ut2_button_color_use	abt__ut2_title_color	abt__ut2_title_color_use	abt__ut2_title_font_size	abt__ut2_title_font_weight	abt__ut2_title_tag	abt__ut2_background_image_size	abt__ut2_image_position	abt__ut2_title_shadow	abt__ut2_description_font_size	abt__ut2_description_color	abt__ut2_description_color_use	abt__ut2_description_bg_color	abt__ut2_description_bg_color_use	abt__ut2_object	abt__ut2_background_color	abt__ut2_background_color_use	abt__ut2_class	abt__ut2_color_scheme	abt__ut2_content_valign	abt__ut2_content_align	abt__ut2_content_full_width	abt__ut2_content_bg	abt__ut2_content_bg_position	abt__ut2_content_bg_align	abt__ut2_content_bg_opacity	abt__ut2_content_bg_color	abt__ut2_content_bg_color_use	abt__ut2_padding	abt__ut2_how_to_open	abt__ut2_data_type	abt__ut2_youtube_use	abt__ut2_youtube_autoplay	abt__ut2_youtube_hide_controls	abt__ut2_background_type	abt__ut2_background_mp4_video	abt__ut2_button_text	abt__ut2_title	abt__ut2_url	abt__ut2_description	abt__ut2_youtube_id	abt__ut2_products_template	abt__ut2_products_links_thumb_columns	abt__ut2_products_links_thumb_rows	abt__ut2_products_small_items_columns	abt__ut2_products_small_items_rows	abt__ut2_products_grid_columns	abt__ut2_products_list	abt__ut2_tablet_use	abt__ut2_tablet_content_valign	abt__ut2_tablet_content_valign_use_own	abt__ut2_tablet_content_align	abt__ut2_tablet_content_align_use_own	abt__ut2_tablet_padding	abt__ut2_tablet_padding_use_own	abt__ut2_tablet_content_full_width	abt__ut2_tablet_content_full_width_use_own	abt__ut2_tablet_title	abt__ut2_tablet_title_use_own	abt__ut2_tablet_title_font_size	abt__ut2_tablet_title_font_size_use_own	abt__ut2_tablet_title_shadow	abt__ut2_tablet_title_shadow_use_own	abt__ut2_tablet_description	abt__ut2_tablet_description_use_own	abt__ut2_tablet_description_font_size	abt__ut2_tablet_description_font_size_use_own	abt__ut2_tablet_main_image_use_own	abt__ut2_tablet_background_type	abt__ut2_tablet_background_type_use_own	abt__ut2_tablet_background_mp4_video	abt__ut2_tablet_background_mp4_video_use_own	abt__ut2_tablet_background_image_use_own	abt__ut2_tablet_background_image_size	abt__ut2_tablet_background_image_size_use_own	abt__ut2_tablet_image_position	abt__ut2_tablet_image_position_use_own	abt__ut2_tablet_button_use	abt__ut2_tablet_button_use_use_own	abt__ut2_tablet_button_text	abt__ut2_tablet_button_text_use_own	abt__ut2_tablet_content_bg	abt__ut2_tablet_content_bg_use_own	abt__ut2_tablet_content_bg_position	abt__ut2_tablet_content_bg_position_use_own	abt__ut2_tablet_content_bg_align	abt__ut2_tablet_content_bg_align_use_own	abt__ut2_tablet_content_bg_opacity	abt__ut2_tablet_content_bg_opacity_use_own	abt__ut2_tablet_content_bg_color	abt__ut2_tablet_content_bg_color_use_own	abt__ut2_tablet_content_bg_color_use	abt__ut2_tablet_content_bg_color_use_use_own	abt__ut2_tablet_button_text_color	abt__ut2_tablet_button_text_color_use_own	abt__ut2_tablet_button_text_color_use	abt__ut2_tablet_button_text_color_use_use_own	abt__ut2_tablet_button_color	abt__ut2_tablet_button_color_use_own	abt__ut2_tablet_button_color_use	abt__ut2_tablet_button_color_use_use_own	abt__ut2_mobile_use	abt__ut2_mobile_content_valign	abt__ut2_mobile_content_valign_use_own	abt__ut2_mobile_content_align	abt__ut2_mobile_content_align_use_own	abt__ut2_mobile_padding	abt__ut2_mobile_padding_use_own	abt__ut2_mobile_content_full_width	abt__ut2_mobile_content_full_width_use_own	abt__ut2_mobile_title	abt__ut2_mobile_title_use_own	abt__ut2_mobile_title_font_size	abt__ut2_mobile_title_font_size_use_own	abt__ut2_mobile_title_shadow	abt__ut2_mobile_title_shadow_use_own	abt__ut2_mobile_description	abt__ut2_mobile_description_use_own	abt__ut2_mobile_description_font_size	abt__ut2_mobile_description_font_size_use_own	abt__ut2_mobile_main_image_use_own	abt__ut2_mobile_background_type	abt__ut2_mobile_background_type_use_own	abt__ut2_mobile_background_mp4_video	abt__ut2_mobile_background_mp4_video_use_own	abt__ut2_mobile_background_image_use_own	abt__ut2_mobile_background_image_size	abt__ut2_mobile_background_image_size_use_own	abt__ut2_mobile_image_position	abt__ut2_mobile_image_position_use_own	abt__ut2_mobile_button_use	abt__ut2_mobile_button_use_use_own	abt__ut2_mobile_button_text	abt__ut2_mobile_button_text_use_own	abt__ut2_mobile_content_bg	abt__ut2_mobile_content_bg_use_own	abt__ut2_mobile_content_bg_position	abt__ut2_mobile_content_bg_position_use_own	abt__ut2_mobile_content_bg_align	abt__ut2_mobile_content_bg_align_use_own	abt__ut2_mobile_content_bg_opacity	abt__ut2_mobile_content_bg_opacity_use_own	abt__ut2_mobile_content_bg_color	abt__ut2_mobile_content_bg_color_use_own	abt__ut2_mobile_content_bg_color_use	abt__ut2_mobile_content_bg_color_use_use_own	abt__ut2_mobile_button_text_color	abt__ut2_mobile_button_text_color_use_own	abt__ut2_mobile_button_text_color_use	abt__ut2_mobile_button_text_color_use_use_own	abt__ut2_mobile_button_color	abt__ut2_mobile_button_color_use_own	abt__ut2_mobile_button_color_use	abt__ut2_mobile_button_color_use_use_own
49	A	Banner (Bang & Olufsen)	abt__ut2	B		0				0	45	0	N	0	0	Y	normal	#ffffff	Y	#8e664f	Y		N	28px	900	div	cover	center	N	14px	#8e664f	Y		N	image	#eee8de	Y		light	bottom	left	N	none	only_under_content	auto	5		N	20px 20px 20px 20px	in_this_window	url	N	N	N	image		Buy	<small>Bang & Olufsen</small>Beoplay HX Timber	categories.view&category_id=166	Comfortable headphones in all conditions.			0	0	0	0	0		N	center	N	center	N	20px 20px 20px 20px	N	N	N		N	24px	N	N	N		N	16px	N	N	image	N		N	N	cover	N	center	N	N	N		N	none	N	only_under_content	N	auto	N	5	N		N	N	N		N	N	N		N	N	N	N	center	N	center	N	20px 20px 20px 20px	N	N	N		N	24px	N	N	N		N	16px	N	N	image	N		N	N	cover	N	center	N	N	N		N	none	N	only_under_content	N	auto	N	5	N		N	N	N		N	N	N		N	N	N