SELECT 
  cscart_at_videos.video_id, 
  cscart_at_videos.status, 
  cscart_at_videos.position, 
  cscart_at_videos.type, 
  cscart_at_video_descriptions.name, 
  cscart_at_videos.autoplay, 
  cscart_at_videos.loop, 
  cscart_at_videos.muted, 
  cscart_at_videos.filesize, 
  cscart_at_videos.user_id, 
  cscart_at_videos.timestamp, 
  cscart_at_videos.filename, 
  cscart_at_video_descriptions.description, 
  cscart_at_video_descriptions.html_code, 
  cscart_at_product_video.* 
FROM 
  cscart_at_videos cscart_at_videos 
  LEFT JOIN cscart_at_product_video ON cscart_at_videos.video_id = cscart_at_product_video.video_id 
  LEFT JOIN cscart_at_video_descriptions ON cscart_at_video_descriptions.video_id = cscart_at_videos.video_id 
  AND cscart_at_video_descriptions.lang_code = 'en' 
WHERE 
  1 
  AND cscart_at_product_video.product_id = 556119 
  AND cscart_at_videos.status = 'A' 
ORDER BY 
  cscart_at_videos.position asc

Query time 0.00093

JSON explain

{
  "query_block": {
    "select_id": 1,
    "filesort": {
      "sort_key": "cscart_at_videos.position",
      "temporary_table": {
        "table": {
          "table_name": "cscart_at_product_video",
          "access_type": "ref",
          "possible_keys": ["product_id"],
          "key": "product_id",
          "key_length": "3",
          "used_key_parts": ["product_id"],
          "ref": ["const"],
          "rows": 1,
          "filtered": 100,
          "using_index": true
        },
        "table": {
          "table_name": "cscart_at_videos",
          "access_type": "eq_ref",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "3",
          "used_key_parts": ["video_id"],
          "ref": ["staging2_wesave_com.cscart_at_product_video.video_id"],
          "rows": 1,
          "filtered": 100,
          "attached_condition": "cscart_at_videos.`status` = 'A'"
        },
        "table": {
          "table_name": "cscart_at_video_descriptions",
          "access_type": "eq_ref",
          "possible_keys": ["video_id"],
          "key": "video_id",
          "key_length": "11",
          "used_key_parts": ["video_id", "lang_code"],
          "ref": ["staging2_wesave_com.cscart_at_product_video.video_id", "const"],
          "rows": 1,
          "filtered": 100,
          "attached_condition": "trigcond(cscart_at_video_descriptions.lang_code = 'en')"
        }
      }
    }
  }
}