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 (
    65584, 65590, 65672, 65673, 65770, 65616, 
    65674, 65803, 65814, 65815, 65720, 
    65732
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00153

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": 102,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (65584,65590,65672,65673,65770,65616,65674,65803,65814,65815,65720,65732)"
        }
      }
    },
    "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
64270 65584 product 0 76503 A 0 D 0 0
64869 65590 product 0 77102 A 0 D 0 0
64871 65590 product 0 77104 A 0 D 0 0
64872 65590 product 0 77105 A 0 D 0 0
64874 65590 product 0 77107 A 0 D 0 0
64875 65590 product 0 77108 A 0 D 0 0
64902 65616 product 0 77135 A 0 D 0 0
64904 65616 product 0 77137 A 0 D 0 0
64908 65616 product 0 77141 A 0 D 0 0
64909 65616 product 0 77142 A 0 D 0 0
66362 65674 product 0 78595 A 0 D 0 0
66375 65673 product 0 78608 A 0 D 0 0
66389 65672 product 0 78622 A 0 D 0 0
68052 65732 product 0 80285 A 0 D 0 0
68349 65770 product 0 80582 A 0 D 0 0
68569 65720 product 0 80802 A 0 D 0 0
69275 65803 product 0 81508 A 0 D 0 0
69348 65814 product 0 81581 A 0 D 0 0
69397 65815 product 0 81630 A 0 D 0 0
64271 65584 product 0 76504 A 1 D 0 0
66369 65674 product 0 78602 A 1 D 0 0
66371 65673 product 0 78604 A 1 D 0 0
68047 65732 product 0 80280 A 1 D 0 0
68354 65770 product 0 80587 A 1 D 0 0
68566 65720 product 0 80799 A 1 D 0 0
69273 65803 product 0 81506 A 1 D 0 0
69353 65814 product 0 81586 A 1 D 0 0
69403 65815 product 0 81636 A 1 D 0 0
64272 65584 product 0 76505 A 2 D 0 0
64905 65616 product 0 77138 A 2 D 0 0
66363 65674 product 0 78596 A 2 D 0 0
66373 65673 product 0 78606 A 2 D 0 0
66392 65672 product 0 78625 A 2 D 0 0
68051 65732 product 0 80284 A 2 D 0 0
68567 65720 product 0 80800 A 2 D 0 0
68992 65770 product 0 81225 A 2 D 0 0
69274 65803 product 0 81507 A 2 D 0 0
69350 65814 product 0 81583 A 2 D 0 0
69400 65815 product 0 81633 A 2 D 0 0
64275 65584 product 0 76508 A 3 D 0 0
64903 65616 product 0 77136 A 3 D 0 0
66365 65674 product 0 78598 A 3 D 0 0
68048 65732 product 0 80281 A 3 D 0 0
68351 65770 product 0 80584 A 3 D 0 0
68572 65720 product 0 80805 A 3 D 0 0
69276 65803 product 0 81509 A 3 D 0 0
69349 65814 product 0 81582 A 3 D 0 0
69398 65815 product 0 81631 A 3 D 0 0
64274 65584 product 0 76507 A 4 D 0 0
64907 65616 product 0 77140 A 4 D 0 0
66367 65674 product 0 78600 A 4 D 0 0
66374 65673 product 0 78607 A 4 D 0 0
66388 65672 product 0 78621 A 4 D 0 0
68049 65732 product 0 80282 A 4 D 0 0
68350 65770 product 0 80583 A 4 D 0 0
68570 65720 product 0 80803 A 4 D 0 0
69286 65803 product 0 81519 A 4 D 0 0
69347 65814 product 0 81580 A 4 D 0 0
69399 65815 product 0 81632 A 4 D 0 0
64268 65584 product 0 76501 A 5 D 0 0
64870 65590 product 0 77103 A 5 D 0 0
66364 65674 product 0 78597 A 5 D 0 0
66376 65673 product 0 78609 A 5 D 0 0
66391 65672 product 0 78624 A 5 D 0 0
68053 65732 product 0 80286 A 5 D 0 0
68353 65770 product 0 80586 A 5 D 0 0
68568 65720 product 0 80801 A 5 D 0 0
69272 65803 product 0 81505 A 5 D 0 0
69352 65814 product 0 81585 A 5 D 0 0
69402 65815 product 0 81635 A 5 D 0 0
64273 65584 product 0 76506 A 6 D 0 0
64873 65590 product 0 77106 A 6 D 0 0
65409 65590 product 0 77642 A 6 C 0 0
65410 65590 product 0 77643 A 6 C 0 0
66366 65674 product 0 78599 A 6 D 0 0
66393 65672 product 0 78626 A 6 D 0 0
68050 65732 product 0 80283 A 6 D 0 0
68121 65674 product 0 80354 A 6 C 0 0
68352 65770 product 0 80585 A 6 D 0 0
68571 65720 product 0 80804 A 6 D 0 0
69277 65803 product 0 81510 A 6 D 0 0
69351 65814 product 0 81584 A 6 D 0 0
69401 65815 product 0 81634 A 6 D 0 0
64269 65584 product 0 76502 A 7 D 0 0
64910 65616 product 0 77143 A 7 C 0 0
66390 65672 product 0 78623 A 7 D 0 0
68119 65672 product 0 80352 A 7 C 0 0
68130 65732 product 0 80363 A 7 C 0 0
68356 65770 product 0 80589 A 7 C 0 0
68561 65720 product 0 80794 A 7 C 0 0
69422 65732 product 0 81655 A 7 C 0 0
64911 65616 product 0 77144 A 8 C 0 0
68357 65770 product 0 80590 A 8 C 0 0
68562 65720 product 0 80795 A 8 C 0 0
68768 65584 product 0 81001 A 8 C 0 0
64296 65584 product 0 76529 A 9 C 0 0
64913 65616 product 0 77146 A 9 C 0 0
68358 65770 product 0 80591 A 9 C 0 0
68584 65720 product 0 80817 A 9 C 0 0
64297 65584 product 0 76530 A 10 C 0 0
64912 65616 product 0 77145 A 10 C 0 0
68585 65720 product 0 80818 A 10 C 0 0