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 (64723, 64275, 65083, 64276) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00075

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": 49,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (64723,64275,65083,64276)"
        }
      }
    },
    "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
29361 64276 product 0 41581 A 0 D 0 0
52461 65083 product 0 64694 A 0 D 0 0
63819 64723 product 0 76052 A 0 D 0 0
69566 64275 product 0 81799 A 0 D 0 0
29365 64276 product 0 41585 A 1 D 0 0
29369 64275 product 0 41589 A 1 D 0 0
63817 64723 product 0 76050 A 1 D 0 0
63823 65083 product 0 76056 A 1 D 0 0
52459 65083 product 0 64692 A 2 D 0 0
63814 64723 product 0 76047 A 2 D 0 0
69559 64276 product 0 81792 A 2 D 0 0
69568 64275 product 0 81801 A 2 D 0 0
36632 64723 product 0 48865 A 3 D 0 0
52460 65083 product 0 64693 A 3 D 0 0
69556 64276 product 0 81789 A 3 D 0 0
69565 64275 product 0 81798 A 3 D 0 0
29366 64275 product 0 41586 A 4 D 0 0
36633 64723 product 0 48866 A 4 D 0 0
63821 65083 product 0 76054 A 4 D 0 0
69557 64276 product 0 81790 A 4 D 0 0
29348 64275 product 0 41568 A 5 D 0 0
63816 64723 product 0 76049 A 5 D 0 0
63820 65083 product 0 76053 A 5 D 0 0
69558 64276 product 0 81791 A 5 D 0 0
63815 64723 product 0 76048 A 6 D 0 0
63822 65083 product 0 76055 A 6 D 0 0
65946 65083 product 0 78179 A 6 C 0 0
65952 65083 product 0 78185 A 6 C 0 0
65953 65083 product 0 78186 A 6 C 0 0
65954 65083 product 0 78187 A 6 C 0 0
69567 64275 product 0 81800 A 6 D 0 0
31984 64275 product 0 44217 A 7 C 0 0
63818 64723 product 0 76051 A 7 D 0 0
31983 64275 product 0 44216 A 8 C 0 0
36641 64723 product 0 48874 A 8 C 1 1781
36642 64723 product 0 48875 A 9 C 0 0
62807 64275 product 0 75040 A 9 C 0 0
36631 64723 product 0 48864 A 10 C 0 0
62808 64275 product 0 75041 A 10 C 0 0
52555 64723 product 0 64788 A 11 C 0 0
36630 64723 product 0 48863 A 12 C 0 0
36643 64723 product 0 48876 A 13 C 0 0
58538 64723 product 0 70771 A 14 C 0 0
66822 64723 product 0 79055 A 15 C 0 0
58539 64723 product 0 70772 A 16 C 0 0
61457 64723 product 0 73690 A 17 C 0 0
62126 64723 product 0 74359 A 18 C 0 0
60273 64723 product 0 72506 A 19 C 0 0
62127 64723 product 0 74360 A 20 C 0 0