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 (61693, 64365, 61531, 61684) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00055

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": 36,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (61693,64365,61531,61684)"
        }
      }
    },
    "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
16715 61531 product 0 28282 A 0 D 0 0
16716 61531 product 0 28283 A 0 D 0 0
16871 61531 product 0 28457 A 0 D 0 0
16875 61531 product 0 28461 A 0 D 0 0
30678 64365 product 0 42910 A 0 D 0 0
64089 61684 product 0 76322 A 0 D 0 0
64646 61531 product 0 76879 A 0 D 0 0
64647 61531 product 0 76880 A 0 D 0 0
64650 61693 product 0 76883 A 0 D 0 0
17302 61693 product 0 28888 A 1 D 0 0
30679 64365 product 0 42911 A 1 D 0 0
64090 61684 product 0 76323 A 1 D 0 0
17077 61684 product 0 28610 A 2 D 0 0
30680 64365 product 0 42912 A 2 D 0 0
64648 61693 product 0 76881 A 2 D 0 0
17075 61684 product 0 28608 A 3 D 0 0
30681 64365 product 0 42913 A 3 D 0 0
64652 61693 product 0 76885 A 3 D 0 0
17076 61684 product 0 28609 A 4 D 0 0
30684 64365 product 0 42916 A 4 D 0 0
64649 61693 product 0 76882 A 4 D 0 0
17303 61693 product 0 28889 A 5 D 0 0
30682 64365 product 0 42914 A 5 D 0 0
64087 61684 product 0 76320 A 5 D 0 0
17220 61684 product 0 28787 A 6 D 0 0
30683 64365 product 0 42915 A 6 D 0 0
64651 61693 product 0 76884 A 6 D 0 0
30685 64365 product 0 42917 A 7 D 0 0
64088 61684 product 0 76321 A 7 D 0 0
67772 61693 product 0 80005 A 7 C 0 0
17634 61684 product 0 29259 A 8 D 0 0
64389 64365 product 0 76622 A 8 C 0 0
67773 61693 product 0 80006 A 8 C 0 0
48383 64365 product 0 60616 A 9 C 0 0
30760 64365 product 0 42992 A 10 C 0 0
65637 64365 product 0 77870 A 10 C 0 0