Sandbox

SELECT 
  tmall_ec_livecommerce_videos.*, 
  tmall_ec_livecommerce_videos_descriptions.video_title, 
  tmall_ec_livecommerce_videos_descriptions.description, 
  tmall_ec_livecommerce_videos_descriptions.lang_code 
FROM 
  tmall_ec_livecommerce_videos 
  LEFT JOIN tmall_ec_livecommerce_videos_descriptions ON tmall_ec_livecommerce_videos_descriptions.video_id = tmall_ec_livecommerce_videos.video_id 
  AND tmall_ec_livecommerce_videos_descriptions.lang_code = 'en' 
WHERE 
  tmall_ec_livecommerce_videos.video_id = 1 
  AND tmall_ec_livecommerce_videos.status IN ('A', 'S') 
  AND tmall_ec_livecommerce_videos.storefront_id = 1

Query time 0.00759

JSON explain

{
  "query_block": {
    "select_id": 1,
    "const_condition": "1",
    "nested_loop": [
      {
        "table": {
          "table_name": "tmall_ec_livecommerce_videos",
          "access_type": "system",
          "possible_keys": ["PRIMARY", "idx_status_scheduled"],
          "rows": 1,
          "filtered": 100
        }
      },
      {
        "table": {
          "table_name": "tmall_ec_livecommerce_videos_descriptions",
          "access_type": "system",
          "possible_keys": ["PRIMARY"],
          "rows": 1,
          "filtered": 100
        }
      }
    ]
  }
}

Result

video_id	video_duration	rec_video_duration	yt_video_duration	company_id	storefront_id	status	product_ids	scheduled_time	timestamp	stream_type	yt_video	filename	video_title	description	lang_code
1	10140	0	169.00	1	1	A	17,148,187	1765468980	1765469125	Y	https://www.youtube.com/watch?v=iLkmG5hI1w0		test		en