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.company_id as company_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_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_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_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_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 = 'en' 
  LEFT JOIN cscart_banner_images ON cscart_banner_images.banner_id = cscart_banners.banner_id 
  AND cscart_banner_images.lang_code = 'en' 
  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 = 'en' 
WHERE 
  cscart_banners.banner_id = 140 
  AND cscart_banners.status IN ('A', 'H')

Query time 0.00156

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
    },
    "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	company_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_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_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_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_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
140	A	Free Bars & Free Shipping	abt__ut2	B		1746507600			400	1	7		N	0	0	N	normal		N		N	#ffffff	Y	50px	900	div	cover	center	N	16px		N		N	image		N		light	bottom	left	Y	none	only_under_content	5		N	20px 20px 195px 40px	in_this_window	url	N	N	N	image			<span style="text-shadow: 0px 4px 6.8px rgba(0, 0, 0, 0.25);line-height: 100%;">"Best soap I've ever used!"</span>				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	5	N		N	N	N		N	N	N		N	N	N	Y	bottom	Y	left	Y	20px 20px 40px	Y	Y	Y		N	40px	Y	N	N		N	16px	N	N	image	N		N	Y	cover	N	center	N	N	N		N	none	N	only_under_content	N	5	N		N	N	N		N	N	N		N	N	N