Sandbox

SELECT 
  vi_ab__video_gallery_descriptions.video_path, 
  videos.video_id, 
  videos.product_id, 
  videos.status, 
  videos.pos, 
  videos.product_pos_type, 
  videos.product_pos, 
  videos.type, 
  videos.autoplay, 
  videos.show_in_list, 
  videos.settings, 
  videos.icon_type, 
  videos.storefront_id, 
  vi_ab__video_gallery_descriptions.title, 
  vi_ab__video_gallery_descriptions.description 
FROM 
  vi_ab__video_gallery AS videos 
  LEFT JOIN vi_ab__video_gallery_descriptions ON vi_ab__video_gallery_descriptions.video_id = videos.video_id 
  AND vi_ab__video_gallery_descriptions.lang_code = 'en' 
WHERE 
  1 
  AND videos.storefront_id IN (1, 0) 
  AND videos.autoplay = 'Y' 
  AND videos.show_in_list = 'Y' 
  AND videos.status = 'A' 
  AND videos.product_id = 13 
ORDER BY 
  videos.pos ASC 
LIMIT 
  0, 1

Query time 0.00012

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}