SELECT 
  SQL_CALC_FOUND_ROWS * 
FROM 
  cscart_cp_videos 
  LEFT JOIN cscart_cp_video_descriptions ON cscart_cp_videos.video_id = cscart_cp_video_descriptions.video_id 
  AND cscart_cp_video_descriptions.lang_code = 'ru' 
WHERE 
  1 
  AND cscart_cp_videos.company_id = 1 
  AND cscart_cp_videos.video_id IN(
    1, 6, 7, 8, 9, 10, 11, 12, 14, 15, 16, 17, 
    18, 20, 21, 23, 24, 25, 26, 27, 28, 29, 
    30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 
    40, 41, 42, 44, 45, 46, 47, 49, 50, 51, 
    54, 55, 56, 57, 58
  ) 
  AND cscart_cp_videos.status = 'A' 
ORDER BY 
  cscart_cp_videos.position asc 
LIMIT 
  24, 12

Query time 0.00138

JSON explain

{
  "query_block": {
    "select_id": 1,
    "read_sorted_file": {
      "filesort": {
        "sort_key": "cscart_cp_videos.position",
        "table": {
          "table_name": "cscart_cp_videos",
          "access_type": "ALL",
          "possible_keys": ["PRIMARY"],
          "rows": 51,
          "filtered": 92.157,
          "attached_condition": "cscart_cp_videos.company_id = 1 and cscart_cp_videos.video_id in (1,6,7,8,9,10,11,12,14,15,16,17,18,20,21,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,44,45,46,47,49,50,51,54,55,56,57,58) and cscart_cp_videos.`status` = 'A'"
        }
      }
    },
    "table": {
      "table_name": "cscart_cp_video_descriptions",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "9",
      "used_key_parts": ["video_id", "lang_code"],
      "ref": ["orbit_cscart_orbit_cscart.cscart_cp_videos.video_id", "const"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_cp_video_descriptions.lang_code = 'ru')"
    }
  }
}