SELECT 
  cscart_images_links.*, 
  cscart_images.image_path, 
  cscart_common_descriptions.description AS alt, 
  cscart_images.image_x, 
  cscart_images.image_y, 
  cscart_images.image_id as images_image_id 
FROM 
  cscart_images_links 
  LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id 
  LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id 
  AND cscart_common_descriptions.object_holder = 'images' 
  AND cscart_common_descriptions.lang_code = 'en' 
WHERE 
  cscart_images_links.object_type = 'product' 
  AND cscart_images_links.type = 'A' 
  AND cscart_images_links.object_id IN (
    65703, 65684, 65705, 65704, 65686, 65701, 
    65698, 65700, 65691, 65685, 65688, 
    65694, 65696, 65702, 65697, 65695, 
    65690, 65689, 65693, 65692
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00112

JSON explain

{
  "query_block": {
    "select_id": 1,
    "read_sorted_file": {
      "filesort": {
        "sort_key": "cscart_images_links.position, cscart_images_links.pair_id",
        "table": {
          "table_name": "cscart_images_links",
          "access_type": "range",
          "possible_keys": ["object_id"],
          "key": "object_id",
          "key_length": "81",
          "used_key_parts": ["object_id", "object_type", "type"],
          "rows": 113,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (65703,65684,65705,65704,65686,65701,65698,65700,65691,65685,65688,65694,65696,65702,65697,65695,65690,65689,65693,65692)"
        }
      }
    },
    "table": {
      "table_name": "cscart_images",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "3",
      "used_key_parts": ["image_id"],
      "ref": ["cscart_migrate.cscart_images_links.image_id"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_images_links.image_id = cscart_images.image_id)"
    },
    "table": {
      "table_name": "cscart_common_descriptions",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "107",
      "used_key_parts": ["object_id", "lang_code", "object_holder"],
      "ref": ["cscart_migrate.cscart_images.image_id", "const", "const"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_common_descriptions.object_id = cscart_images.image_id and cscart_common_descriptions.object_holder = 'images' and cscart_common_descriptions.lang_code = 'en' and trigcond(cscart_images.image_id is not null))"
    }
  }
}

Result

pair_id object_id object_type image_id detailed_id type position image_type show_gallery gallery_category_id image_path alt image_x image_y images_image_id
66913 65684 product 0 79146 A 0 D 0 0
66921 65686 product 0 79154 A 0 D 0 0
67047 65698 product 0 79280 A 0 D 0 0
67048 65698 product 0 79281 A 0 D 0 0
67049 65698 product 0 79282 A 0 D 0 0
67052 65693 product 0 79285 A 0 D 0 0
67057 65691 product 0 79290 A 0 D 0 0
67061 65692 product 0 79294 A 0 D 0 0
67062 65692 product 0 79295 A 0 D 0 0
67063 65692 product 0 79296 A 0 D 0 0
67066 65697 product 0 79299 A 0 D 0 0
67074 65685 product 0 79307 A 0 D 0 0
67079 65690 product 0 79312 A 0 D 0 0
67081 65688 product 0 79314 A 0 D 0 0
67082 65688 product 0 79315 A 0 D 0 0
67083 65688 product 0 79316 A 0 D 0 0
67086 65689 product 0 79319 A 0 D 0 0
67091 65696 product 0 79324 A 0 D 0 0
67093 65694 product 0 79326 A 0 D 0 0
67094 65694 product 0 79327 A 0 D 0 0
67095 65694 product 0 79328 A 0 D 0 0
67097 65695 product 0 79330 A 0 D 0 0
67248 65688 product 0 79481 A 0 C 0 0
67265 65702 product 0 79498 A 0 D 0 0
67266 65702 product 0 79499 A 0 D 0 0
67269 65705 product 0 79502 A 0 D 0 0
67273 65700 product 0 79506 A 0 D 0 0
67277 65703 product 0 79510 A 0 D 0 0
67278 65703 product 0 79511 A 0 D 0 0
67279 65703 product 0 79512 A 0 D 0 0
67283 65701 product 0 79516 A 0 D 0 0
67287 65704 product 0 79520 A 0 D 0 0
67977 65703 product 0 80210 A 0 C 0 0
67978 65703 product 0 80211 A 0 C 0 0
68596 65703 product 0 80829 A 0 C 0 0
68597 65703 product 0 80830 A 0 C 0 0
66908 65684 product 0 79141 A 1 D 0 0
66915 65685 product 0 79148 A 1 D 0 0
67055 65693 product 0 79288 A 1 D 0 0
67058 65691 product 0 79291 A 1 D 0 0
67070 65697 product 0 79303 A 1 D 0 0
67071 65686 product 0 79304 A 1 D 0 0
67078 65690 product 0 79311 A 1 D 0 0
67087 65689 product 0 79320 A 1 D 0 0
67090 65696 product 0 79323 A 1 D 0 0
67098 65695 product 0 79331 A 1 D 0 0
67270 65705 product 0 79503 A 1 D 0 0
67274 65700 product 0 79507 A 1 D 0 0
67281 65701 product 0 79514 A 1 D 0 0
67286 65704 product 0 79519 A 1 D 0 0
67054 65693 product 0 79287 A 2 D 0 0
67059 65691 product 0 79292 A 2 D 0 0
67069 65697 product 0 79302 A 2 D 0 0
67072 65686 product 0 79305 A 2 D 0 0
67073 65684 product 0 79306 A 2 D 0 0
67075 65685 product 0 79308 A 2 D 0 0
67077 65690 product 0 79310 A 2 D 0 0
67085 65689 product 0 79318 A 2 D 0 0
67089 65696 product 0 79322 A 2 D 0 0
67099 65695 product 0 79332 A 2 D 0 0
67251 65696 product 0 79484 A 2 C 0 0
67252 65696 product 0 79485 A 2 C 0 0
67253 65696 product 0 79486 A 2 C 0 0
67254 65696 product 0 79487 A 2 C 0 0
67259 65689 product 0 79492 A 2 C 0 0
67260 65689 product 0 79493 A 2 C 0 0
67267 65702 product 0 79500 A 2 D 0 0
67271 65705 product 0 79504 A 2 D 0 0
67275 65700 product 0 79508 A 2 D 0 0
67282 65701 product 0 79515 A 2 D 0 0
67285 65704 product 0 79518 A 2 D 0 0
68586 65701 product 0 80819 A 2 C 0 0
68587 65701 product 0 80820 A 2 C 0 0
68588 65701 product 0 80821 A 2 C 0 0
68589 65701 product 0 80822 A 2 C 0 0
66923 65686 product 0 79156 A 3 C 0 0
67051 65693 product 0 79284 A 3 D 0 0
67068 65697 product 0 79301 A 3 D 0 0
67122 65700 product 0 79355 A 3 C 0 0
67132 65702 product 0 79365 A 3 C 0 0
67176 65705 product 0 79409 A 3 C 0 0
67249 65695 product 0 79482 A 3 C 0 0
67258 65685 product 0 79491 A 3 C 0 0
68019 65684 product 0 80252 A 3 C 0 0
66910 65684 product 0 79143 A 4 C 0 0
66922 65686 product 0 79155 A 4 C 0 0
67053 65693 product 0 79286 A 4 D 0 0
67067 65697 product 0 79300 A 4 D 0 0
67133 65702 product 0 79366 A 4 C 0 0
67177 65705 product 0 79410 A 4 C 0 0
67234 65695 product 0 79467 A 4 C 0 0
67241 65686 product 0 79474 A 4 C 0 0
67242 65686 product 0 79475 A 4 C 0 0
67257 65685 product 0 79490 A 4 C 0 0
67261 65693 product 0 79494 A 4 C 0 0
68551 65700 product 0 80784 A 4 C 0 0
67065 65697 product 0 79298 A 5 D 0 0
67134 65702 product 0 79367 A 5 C 0 0
67244 65684 product 0 79477 A 5 C 0 0
67247 65697 product 0 79480 A 5 C 0 0
67250 65695 product 0 79483 A 5 C 0 0
67255 65685 product 0 79488 A 5 C 0 0
68553 65700 product 0 80786 A 5 C 0 0
68590 65705 product 0 80823 A 5 C 0 0
67135 65702 product 0 79368 A 6 C 0 0
67178 65705 product 0 79411 A 6 C 0 0
67243 65684 product 0 79476 A 6 C 0 0
67256 65685 product 0 79489 A 6 C 0 0
68552 65700 product 0 80785 A 6 C 0 0
68598 65705 product 0 80831 A 6 C 0 0
68599 65700 product 0 80832 A 6 C 0 0
67245 65684 product 0 79478 A 7 C 0 0
67246 65684 product 0 79479 A 8 C 0 0