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.detailed_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 = 'variant_image' 
  AND cscart_images_links.type = 'V' 
  AND cscart_images_links.object_id IN (
    220119, 
    218037, 
    218038, 
    218039, 
    223755, 
    223756, 
    223757, 
    223758, 
    223759, 
    223933, 
    233545, 
    223930, 
    223931, 
    223932, 
    230828, 
    230827, 
    233546, 
    233547, 
    233548, 
    233549, 
    235107, 
    244462, 
    244463, 
    244464, 
    244465, 
    244466, 
    244467, 
    244468, 
    244469, 
    235077, 
    235078, 
    235079, 
    235080, 
    235081, 
    235082, 
    237317, 
    237318, 
    235083, 
    245070, 
    240990, 
    235084, 
    235085, 
    235086, 
    235087, 
    235088, 
    240991, 
    235089, 
    235090, 
    235091, 
    235092, 
    235093, 
    235094, 
    235095, 
    235096, 
    240992, 
    235097, 
    240993, 
    235098, 
    235099, 
    245071, 
    245072, 
    235108, 
    235100, 
    235101, 
    245073, 
    240994, 
    235102, 
    235103, 
    235104, 
    235105, 
    235106, 
    235123, 
    235109, 
    244470, 
    244471, 
    244472, 
    244473, 
    244474, 
    244475, 
    244476, 
    244477, 
    235151, 
    235124, 
    235125, 
    235126, 
    235127, 
    235128, 
    235129, 
    235150, 
    235130, 
    237319, 
    237320, 
    235131, 
    245074, 
    241095, 
    235132, 
    235133, 
    235134, 
    235135, 
    235136, 
    241096, 
    235137, 
    235138, 
    235139, 
    235140, 
    235141, 
    235142, 
    235143, 
    235144, 
    241097, 
    235145, 
    241098, 
    235146, 
    235147, 
    245075, 
    245076, 
    235152, 
    235148, 
    235149, 
    245077, 
    241099, 
    235168, 
    235160, 
    235161, 
    235162, 
    235179, 
    235171, 
    235172, 
    235173, 
    235190, 
    235182, 
    235183, 
    235184, 
    235219, 
    235193, 
    235194, 
    235195, 
    235196, 
    235197, 
    235198, 
    241041, 
    241042, 
    235199, 
    245078, 
    240995, 
    235200, 
    235201, 
    235202, 
    235203, 
    235204, 
    240996, 
    235205, 
    235206, 
    235207, 
    235208, 
    235209, 
    235210, 
    235211, 
    235212, 
    240997, 
    235213, 
    240998, 
    235214, 
    235215, 
    245079, 
    245080, 
    235216, 
    235217, 
    235218, 
    245081, 
    240999, 
    235232, 
    244478, 
    244479, 
    244480, 
    244481, 
    244482, 
    244483, 
    244484, 
    244485
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00255

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": 180,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (220119,218037,218038,218039,223755,223756,223757,223758,223759,223933,233545,223930,223931,223932,230828,230827,233546,233547,233548,233549,235107,244462,244463,244464,244465,244466,244467,244468,244469,235077,235078,235079,235080,235081,235082,237317,237318,235083,245070,240990,235084,235085,235086,235087,235088,240991,235089,235090,235091,235092,235093,235094,235095,235096,240992,235097,240993,235098,235099,245071,245072,235108,235100,235101,245073,240994,235102,235103,235104,235105,235106,235123,235109,244470,244471,244472,244473,244474,244475,244476,244477,235151,235124,235125,235126,235127,235128,235129,235150,235130,237319,237320,235131,245074,241095,235132,235133,235134,235135,235136,241096,235137,235138,235139,235140,235141,235142,235143,235144,241097,235145,241098,235146,235147,245075,245076,235152,235148,235149,245077,241099,235168,235160,235161,235162,235179,235171,235172,235173,235190,235182,235183,235184,235219,235193,235194,235195,235196,235197,235198,241041,241042,235199,245078,240995,235200,235201,235202,235203,235204,240996,235205,235206,235207,235208,235209,235210,235211,235212,240997,235213,240998,235214,235215,245079,245080,235216,235217,235218,245081,240999,235232,244478,244479,244480,244481,244482,244483,244484,244485)"
        }
      }
    },
    "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.detailed_id"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_images_links.detailed_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
36462 218037 variant_image 48695 0 V 0 D 0 0
36463 218038 variant_image 48696 0 V 0 D 0 0
36464 218039 variant_image 48697 0 V 0 D 0 0
42039 223756 variant_image 54272 0 V 0 D 0 0
42040 223757 variant_image 54273 0 V 0 D 0 0
42041 223758 variant_image 54274 0 V 0 D 0 0
42042 223759 variant_image 54275 0 V 0 D 0 0
42239 223930 variant_image 54472 0 V 0 D 0 0
42240 223931 variant_image 54473 0 V 0 D 0 0
42241 223932 variant_image 54474 0 V 0 D 0 0
54103 233545 variant_image 66336 0 V 0 D 0 0
54104 233547 variant_image 66337 0 V 0 D 0 0
54105 233548 variant_image 66338 0 V 0 D 0 0
54106 233549 variant_image 66339 0 V 0 D 0 0
56652 235077 variant_image 68885 0 V 0 D 0 0
56653 235078 variant_image 68886 0 V 0 D 0 0
56654 235079 variant_image 68887 0 V 0 D 0 0
56655 235080 variant_image 68888 0 V 0 D 0 0
56656 235081 variant_image 68889 0 V 0 D 0 0
56657 235082 variant_image 68890 0 V 0 D 0 0
56658 235083 variant_image 68891 0 V 0 D 0 0
56659 235084 variant_image 68892 0 V 0 D 0 0
56660 235085 variant_image 68893 0 V 0 D 0 0
56661 235086 variant_image 68894 0 V 0 D 0 0
56662 235087 variant_image 68895 0 V 0 D 0 0
56663 235088 variant_image 68896 0 V 0 D 0 0
56664 235089 variant_image 68897 0 V 0 D 0 0
56665 235090 variant_image 68898 0 V 0 D 0 0
56666 235091 variant_image 68899 0 V 0 D 0 0
56667 235092 variant_image 68900 0 V 0 D 0 0
56668 235093 variant_image 68901 0 V 0 D 0 0
56669 235094 variant_image 68902 0 V 0 D 0 0
56670 235095 variant_image 68903 0 V 0 D 0 0
56671 235096 variant_image 68904 0 V 0 D 0 0
56672 235097 variant_image 68905 0 V 0 D 0 0
56673 235098 variant_image 68906 0 V 0 D 0 0
56674 235099 variant_image 68907 0 V 0 D 0 0
56675 235100 variant_image 68908 0 V 0 D 0 0
56676 235101 variant_image 68909 0 V 0 D 0 0
56677 235102 variant_image 68910 0 V 0 D 0 0
56678 235103 variant_image 68911 0 V 0 D 0 0
56679 235104 variant_image 68912 0 V 0 D 0 0
56680 235105 variant_image 68913 0 V 0 D 0 0
56681 235106 variant_image 68914 0 V 0 D 0 0
56682 235108 variant_image 68915 0 V 0 D 0 0
56696 235125 variant_image 68929 0 V 0 D 0 0
56697 235126 variant_image 68930 0 V 0 D 0 0
56698 235127 variant_image 68931 0 V 0 D 0 0
56699 235128 variant_image 68932 0 V 0 D 0 0
56700 235129 variant_image 68933 0 V 0 D 0 0
56701 235130 variant_image 68934 0 V 0 D 0 0
56702 235131 variant_image 68935 0 V 0 D 0 0
56703 235132 variant_image 68936 0 V 0 D 0 0
56704 235133 variant_image 68937 0 V 0 D 0 0
56705 235134 variant_image 68938 0 V 0 D 0 0
56706 235135 variant_image 68939 0 V 0 D 0 0
56707 235136 variant_image 68940 0 V 0 D 0 0
56708 235137 variant_image 68941 0 V 0 D 0 0
56709 235138 variant_image 68942 0 V 0 D 0 0
56710 235139 variant_image 68943 0 V 0 D 0 0
56711 235140 variant_image 68944 0 V 0 D 0 0
56712 235141 variant_image 68945 0 V 0 D 0 0
56713 235142 variant_image 68946 0 V 0 D 0 0
56714 235143 variant_image 68947 0 V 0 D 0 0
56715 235144 variant_image 68948 0 V 0 D 0 0
56716 235145 variant_image 68949 0 V 0 D 0 0
56717 235146 variant_image 68950 0 V 0 D 0 0
56718 235147 variant_image 68951 0 V 0 D 0 0
56719 235148 variant_image 68952 0 V 0 D 0 0
56720 235149 variant_image 68953 0 V 0 D 0 0
56721 235150 variant_image 68954 0 V 0 D 0 0
56722 235152 variant_image 68955 0 V 0 D 0 0
56750 235160 variant_image 68983 0 V 0 D 0 0
56751 235161 variant_image 68984 0 V 0 D 0 0
56752 235162 variant_image 68985 0 V 0 D 0 0
56760 235171 variant_image 68993 0 V 0 D 0 0
56761 235172 variant_image 68994 0 V 0 D 0 0
56762 235173 variant_image 68995 0 V 0 D 0 0
56770 235182 variant_image 69003 0 V 0 D 0 0
56771 235183 variant_image 69004 0 V 0 D 0 0
56772 235184 variant_image 69005 0 V 0 D 0 0
56780 235193 variant_image 69013 0 V 0 D 0 0
56781 235194 variant_image 69014 0 V 0 D 0 0
56782 235195 variant_image 69015 0 V 0 D 0 0
56783 235196 variant_image 69016 0 V 0 D 0 0
56784 235197 variant_image 69017 0 V 0 D 0 0
56785 235198 variant_image 69018 0 V 0 D 0 0
56786 235199 variant_image 69019 0 V 0 D 0 0
56787 235200 variant_image 69020 0 V 0 D 0 0
56788 235201 variant_image 69021 0 V 0 D 0 0
56789 235202 variant_image 69022 0 V 0 D 0 0
56790 235203 variant_image 69023 0 V 0 D 0 0
56791 235204 variant_image 69024 0 V 0 D 0 0
56792 235205 variant_image 69025 0 V 0 D 0 0
56793 235206 variant_image 69026 0 V 0 D 0 0
56794 235207 variant_image 69027 0 V 0 D 0 0
56795 235208 variant_image 69028 0 V 0 D 0 0
56796 235209 variant_image 69029 0 V 0 D 0 0
56797 235210 variant_image 69030 0 V 0 D 0 0
56798 235211 variant_image 69031 0 V 0 D 0 0
56799 235212 variant_image 69032 0 V 0 D 0 0
56800 235213 variant_image 69033 0 V 0 D 0 0
56801 235214 variant_image 69034 0 V 0 D 0 0
56802 235215 variant_image 69035 0 V 0 D 0 0
56803 235216 variant_image 69036 0 V 0 D 0 0
56804 235217 variant_image 69037 0 V 0 D 0 0
56805 235218 variant_image 69038 0 V 0 D 0 0
60261 237318 variant_image 72494 0 V 0 D 0 0
60262 237317 variant_image 72495 0 V 0 D 0 0
60263 237319 variant_image 72496 0 V 0 D 0 0
60264 237320 variant_image 72497 0 V 0 D 0 0
70525 240990 variant_image 82758 0 V 0 D 0 0
70526 240991 variant_image 82759 0 V 0 D 0 0
70527 240992 variant_image 82760 0 V 0 D 0 0
70528 240993 variant_image 82761 0 V 0 D 0 0
70529 240994 variant_image 82762 0 V 0 D 0 0
70530 240995 variant_image 82763 0 V 0 D 0 0
70531 240996 variant_image 82764 0 V 0 D 0 0
70532 240997 variant_image 82765 0 V 0 D 0 0
70533 240998 variant_image 82766 0 V 0 D 0 0
70534 240999 variant_image 82767 0 V 0 D 0 0
70576 241041 variant_image 82809 0 V 0 D 0 0
70577 241042 variant_image 82810 0 V 0 D 0 0
70630 241095 variant_image 82863 0 V 0 D 0 0
70631 241096 variant_image 82864 0 V 0 D 0 0
70632 241097 variant_image 82865 0 V 0 D 0 0
70633 241098 variant_image 82866 0 V 0 D 0 0
70634 241099 variant_image 82867 0 V 0 D 0 0
74254 244462 variant_image 86487 0 V 0 D 0 0
74255 244463 variant_image 86488 0 V 0 D 0 0
74256 244464 variant_image 86489 0 V 0 D 0 0
74257 244465 variant_image 86490 0 V 0 D 0 0
74258 244466 variant_image 86491 0 V 0 D 0 0
74259 244467 variant_image 86492 0 V 0 D 0 0
74260 244468 variant_image 86493 0 V 0 D 0 0
74261 244469 variant_image 86494 0 V 0 D 0 0
74262 244470 variant_image 86495 0 V 0 D 0 0
74263 244471 variant_image 86496 0 V 0 D 0 0
74264 244472 variant_image 86497 0 V 0 D 0 0
74265 244473 variant_image 86498 0 V 0 D 0 0
74266 244474 variant_image 86499 0 V 0 D 0 0
74267 244475 variant_image 86500 0 V 0 D 0 0
74268 244476 variant_image 86501 0 V 0 D 0 0
74269 244477 variant_image 86502 0 V 0 D 0 0
74270 244478 variant_image 86503 0 V 0 D 0 0
74271 244479 variant_image 86504 0 V 0 D 0 0
74272 244480 variant_image 86505 0 V 0 D 0 0
74273 244481 variant_image 86506 0 V 0 D 0 0
74274 244482 variant_image 86507 0 V 0 D 0 0
74275 244483 variant_image 86508 0 V 0 D 0 0
74276 244484 variant_image 86509 0 V 0 D 0 0
74277 244485 variant_image 86510 0 V 0 D 0 0
74862 245070 variant_image 87095 0 V 0 D 0 0
74863 245071 variant_image 87096 0 V 0 D 0 0
74864 245072 variant_image 87097 0 V 0 D 0 0
74865 245073 variant_image 87098 0 V 0 D 0 0
74866 245074 variant_image 87099 0 V 0 D 0 0
74867 245075 variant_image 87100 0 V 0 D 0 0
74868 245076 variant_image 87101 0 V 0 D 0 0
74869 245077 variant_image 87102 0 V 0 D 0 0
74870 245078 variant_image 87103 0 V 0 D 0 0
74871 245079 variant_image 87104 0 V 0 D 0 0
74872 245080 variant_image 87105 0 V 0 D 0 0
74873 245081 variant_image 87106 0 V 0 D 0 0