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 (
    221133, 
    221134, 
    221135, 
    221136, 
    221137, 
    221138, 
    221139, 
    229895, 
    245511, 
    245512, 
    245513, 
    245514, 
    245515, 
    245516, 
    245517, 
    245518, 
    229865, 
    229866, 
    229867, 
    229868, 
    229890, 
    229883, 
    237072, 
    237073, 
    229869, 
    241473, 
    229870, 
    229871, 
    229872, 
    229873, 
    229874, 
    241474, 
    229875, 
    229876, 
    229877, 
    229878, 
    229879, 
    229880, 
    229881, 
    229882, 
    241475, 
    229884, 
    241476, 
    229885, 
    229886, 
    229887, 
    229888, 
    229889, 
    241477, 
    242163, 
    242164, 
    242165, 
    242166, 
    229899, 
    229896, 
    229897, 
    229898, 
    230082, 
    230074, 
    230075, 
    230076, 
    230093, 
    230085, 
    230086, 
    230087, 
    230104, 
    230096, 
    230097, 
    230098, 
    230115, 
    230107, 
    230108, 
    230109, 
    230126, 
    230118, 
    230119, 
    230120, 
    230137, 
    230129, 
    230130, 
    230131, 
    230148, 
    230140, 
    230141, 
    230142, 
    230159, 
    230151, 
    230152, 
    230153, 
    230170, 
    230162, 
    230163, 
    230164, 
    230173, 
    230175, 
    230174, 
    230513, 
    230510, 
    230511, 
    230512, 
    230520, 
    230518, 
    230519, 
    230523, 
    230521, 
    230522, 
    230526, 
    230524, 
    230525, 
    245934, 
    245935, 
    245936, 
    245937, 
    245938, 
    245939, 
    245940, 
    245941, 
    245942, 
    245969, 
    245943, 
    245944, 
    245945, 
    245946, 
    245968, 
    245961, 
    245970, 
    245971, 
    245947, 
    245977, 
    245972, 
    245948, 
    245949, 
    245950, 
    245951, 
    245952, 
    245973, 
    245953, 
    245954, 
    245955, 
    245956, 
    245957, 
    245958, 
    245959, 
    245960, 
    245974, 
    245962, 
    245975, 
    245963, 
    245964, 
    245978, 
    245979, 
    245965, 
    245966, 
    245967, 
    245980, 
    245976, 
    246007, 
    245981, 
    245982, 
    245983, 
    245984, 
    246006, 
    245999, 
    246008, 
    246009, 
    245985, 
    246015, 
    246010, 
    245986, 
    245987, 
    245988, 
    245989, 
    245990, 
    246011, 
    245991, 
    245992, 
    245993, 
    245994, 
    245995, 
    245996, 
    245997, 
    245998, 
    246012, 
    246000, 
    246013, 
    246001, 
    246002, 
    246016, 
    246017, 
    246003, 
    246004, 
    246005, 
    246018, 
    246014
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00377

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": 194,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (221133,221134,221135,221136,221137,221138,221139,229895,245511,245512,245513,245514,245515,245516,245517,245518,229865,229866,229867,229868,229890,229883,237072,237073,229869,241473,229870,229871,229872,229873,229874,241474,229875,229876,229877,229878,229879,229880,229881,229882,241475,229884,241476,229885,229886,229887,229888,229889,241477,242163,242164,242165,242166,229899,229896,229897,229898,230082,230074,230075,230076,230093,230085,230086,230087,230104,230096,230097,230098,230115,230107,230108,230109,230126,230118,230119,230120,230137,230129,230130,230131,230148,230140,230141,230142,230159,230151,230152,230153,230170,230162,230163,230164,230173,230175,230174,230513,230510,230511,230512,230520,230518,230519,230523,230521,230522,230526,230524,230525,245934,245935,245936,245937,245938,245939,245940,245941,245942,245969,245943,245944,245945,245946,245968,245961,245970,245971,245947,245977,245972,245948,245949,245950,245951,245952,245973,245953,245954,245955,245956,245957,245958,245959,245960,245974,245962,245975,245963,245964,245978,245979,245965,245966,245967,245980,245976,246007,245981,245982,245983,245984,246006,245999,246008,246009,245985,246015,246010,245986,245987,245988,245989,245990,246011,245991,245992,245993,245994,245995,245996,245997,245998,246012,246000,246013,246001,246002,246016,246017,246003,246004,246005,246018,246014)"
        }
      }
    },
    "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
48464 229865 variant_image 60697 0 V 0 D 0 0
48465 229866 variant_image 60698 0 V 0 D 0 0
48466 229867 variant_image 60699 0 V 0 D 0 0
48467 229868 variant_image 60700 0 V 0 D 0 0
48468 229869 variant_image 60701 0 V 0 D 0 0
48469 229870 variant_image 60702 0 V 0 D 0 0
48470 229871 variant_image 60703 0 V 0 D 0 0
48471 229872 variant_image 60704 0 V 0 D 0 0
48472 229873 variant_image 60705 0 V 0 D 0 0
48473 229874 variant_image 60706 0 V 0 D 0 0
48474 229875 variant_image 60707 0 V 0 D 0 0
48475 229876 variant_image 60708 0 V 0 D 0 0
48476 229877 variant_image 60709 0 V 0 D 0 0
48477 229878 variant_image 60710 0 V 0 D 0 0
48478 229879 variant_image 60711 0 V 0 D 0 0
48479 229880 variant_image 60712 0 V 0 D 0 0
48480 229881 variant_image 60713 0 V 0 D 0 0
48481 229882 variant_image 60714 0 V 0 D 0 0
48482 229883 variant_image 60715 0 V 0 D 0 0
48483 229884 variant_image 60716 0 V 0 D 0 0
48484 229885 variant_image 60717 0 V 0 D 0 0
48485 229886 variant_image 60718 0 V 0 D 0 0
48486 229887 variant_image 60719 0 V 0 D 0 0
48487 229888 variant_image 60720 0 V 0 D 0 0
48488 229889 variant_image 60721 0 V 0 D 0 0
48489 229890 variant_image 60722 0 V 0 D 0 0
48494 229896 variant_image 60727 0 V 0 D 0 0
48495 229897 variant_image 60728 0 V 0 D 0 0
48496 229898 variant_image 60729 0 V 0 D 0 0
48657 230074 variant_image 60890 0 V 0 D 0 0
48658 230075 variant_image 60891 0 V 0 D 0 0
48659 230076 variant_image 60892 0 V 0 D 0 0
48667 230085 variant_image 60900 0 V 0 D 0 0
48668 230086 variant_image 60901 0 V 0 D 0 0
48669 230087 variant_image 60902 0 V 0 D 0 0
48677 230096 variant_image 60910 0 V 0 D 0 0
48678 230097 variant_image 60911 0 V 0 D 0 0
48679 230098 variant_image 60912 0 V 0 D 0 0
48687 230107 variant_image 60920 0 V 0 D 0 0
48688 230108 variant_image 60921 0 V 0 D 0 0
48689 230109 variant_image 60922 0 V 0 D 0 0
48697 230118 variant_image 60930 0 V 0 D 0 0
48698 230119 variant_image 60931 0 V 0 D 0 0
48699 230120 variant_image 60932 0 V 0 D 0 0
48707 230129 variant_image 60940 0 V 0 D 0 0
48708 230130 variant_image 60941 0 V 0 D 0 0
48709 230131 variant_image 60942 0 V 0 D 0 0
48717 230140 variant_image 60950 0 V 0 D 0 0
48718 230141 variant_image 60951 0 V 0 D 0 0
48719 230142 variant_image 60952 0 V 0 D 0 0
48727 230151 variant_image 60960 0 V 0 D 0 0
48728 230152 variant_image 60961 0 V 0 D 0 0
48729 230153 variant_image 60962 0 V 0 D 0 0
48738 230162 variant_image 60971 0 V 0 D 0 0
48739 230163 variant_image 60972 0 V 0 D 0 0
48740 230164 variant_image 60973 0 V 0 D 0 0
49241 230510 variant_image 61474 0 V 0 D 0 0
49242 230511 variant_image 61475 0 V 0 D 0 0
49243 230512 variant_image 61476 0 V 0 D 0 0
49251 230518 variant_image 61484 0 V 0 D 0 0
49252 230519 variant_image 61485 0 V 0 D 0 0
49253 230521 variant_image 61486 0 V 0 D 0 0
49254 230522 variant_image 61487 0 V 0 D 0 0
49274 230524 variant_image 61507 0 V 0 D 0 0
49275 230525 variant_image 61508 0 V 0 D 0 0
59819 237072 variant_image 72052 0 V 0 D 0 0
59820 237073 variant_image 72053 0 V 0 D 0 0
71008 241473 variant_image 83241 0 V 0 D 0 0
71009 241474 variant_image 83242 0 V 0 D 0 0
71010 241475 variant_image 83243 0 V 0 D 0 0
71011 241476 variant_image 83244 0 V 0 D 0 0
71012 241477 variant_image 83245 0 V 0 D 0 0
71726 242163 variant_image 83959 0 V 0 D 0 0
71727 242164 variant_image 83960 0 V 0 D 0 0
71728 242165 variant_image 83961 0 V 0 D 0 0
71729 242166 variant_image 83962 0 V 0 D 0 0
75529 245511 variant_image 87762 0 V 0 D 0 0
75530 245512 variant_image 87763 0 V 0 D 0 0
75531 245513 variant_image 87764 0 V 0 D 0 0
75532 245514 variant_image 87765 0 V 0 D 0 0
75533 245515 variant_image 87766 0 V 0 D 0 0
75534 245516 variant_image 87767 0 V 0 D 0 0
75535 245517 variant_image 87768 0 V 0 D 0 0
75536 245518 variant_image 87769 0 V 0 D 0 0
76080 245935 variant_image 88313 0 V 0 D 0 0
76081 245936 variant_image 88314 0 V 0 D 0 0
76082 245937 variant_image 88315 0 V 0 D 0 0
76083 245938 variant_image 88316 0 V 0 D 0 0
76084 245939 variant_image 88317 0 V 0 D 0 0
76085 245940 variant_image 88318 0 V 0 D 0 0
76086 245941 variant_image 88319 0 V 0 D 0 0
76087 245942 variant_image 88320 0 V 0 D 0 0
76149 245943 variant_image 88382 0 V 0 D 0 0
76150 245944 variant_image 88383 0 V 0 D 0 0
76151 245945 variant_image 88384 0 V 0 D 0 0
76152 245946 variant_image 88385 0 V 0 D 0 0
76153 245968 variant_image 88386 0 V 0 D 0 0
76154 245961 variant_image 88387 0 V 0 D 0 0
76155 245970 variant_image 88388 0 V 0 D 0 0
76156 245971 variant_image 88389 0 V 0 D 0 0
76157 245947 variant_image 88390 0 V 0 D 0 0
76158 245977 variant_image 88391 0 V 0 D 0 0
76159 245972 variant_image 88392 0 V 0 D 0 0
76160 245948 variant_image 88393 0 V 0 D 0 0
76161 245949 variant_image 88394 0 V 0 D 0 0
76162 245950 variant_image 88395 0 V 0 D 0 0
76163 245951 variant_image 88396 0 V 0 D 0 0
76164 245952 variant_image 88397 0 V 0 D 0 0
76165 245973 variant_image 88398 0 V 0 D 0 0
76166 245953 variant_image 88399 0 V 0 D 0 0
76167 245954 variant_image 88400 0 V 0 D 0 0
76168 245955 variant_image 88401 0 V 0 D 0 0
76169 245956 variant_image 88402 0 V 0 D 0 0
76170 245957 variant_image 88403 0 V 0 D 0 0
76171 245958 variant_image 88404 0 V 0 D 0 0
76172 245959 variant_image 88405 0 V 0 D 0 0
76173 245960 variant_image 88406 0 V 0 D 0 0
76174 245974 variant_image 88407 0 V 0 D 0 0
76175 245962 variant_image 88408 0 V 0 D 0 0
76176 245975 variant_image 88409 0 V 0 D 0 0
76177 245963 variant_image 88410 0 V 0 D 0 0
76178 245964 variant_image 88411 0 V 0 D 0 0
76179 245978 variant_image 88412 0 V 0 D 0 0
76180 245979 variant_image 88413 0 V 0 D 0 0
76181 245965 variant_image 88414 0 V 0 D 0 0
76182 245966 variant_image 88415 0 V 0 D 0 0
76183 245967 variant_image 88416 0 V 0 D 0 0
76184 245980 variant_image 88417 0 V 0 D 0 0
76185 245976 variant_image 88418 0 V 0 D 0 0
76186 245981 variant_image 88419 0 V 0 D 0 0
76187 245982 variant_image 88420 0 V 0 D 0 0
76188 245983 variant_image 88421 0 V 0 D 0 0
76189 245984 variant_image 88422 0 V 0 D 0 0
76190 245985 variant_image 88423 0 V 0 D 0 0
76191 245986 variant_image 88424 0 V 0 D 0 0
76192 245987 variant_image 88425 0 V 0 D 0 0
76193 245988 variant_image 88426 0 V 0 D 0 0
76194 245989 variant_image 88427 0 V 0 D 0 0
76195 245990 variant_image 88428 0 V 0 D 0 0
76196 245991 variant_image 88429 0 V 0 D 0 0
76197 245992 variant_image 88430 0 V 0 D 0 0
76198 245993 variant_image 88431 0 V 0 D 0 0
76199 245994 variant_image 88432 0 V 0 D 0 0
76200 245995 variant_image 88433 0 V 0 D 0 0
76201 245996 variant_image 88434 0 V 0 D 0 0
76202 245997 variant_image 88435 0 V 0 D 0 0
76203 245998 variant_image 88436 0 V 0 D 0 0
76204 245999 variant_image 88437 0 V 0 D 0 0
76205 246000 variant_image 88438 0 V 0 D 0 0
76206 246001 variant_image 88439 0 V 0 D 0 0
76207 246002 variant_image 88440 0 V 0 D 0 0
76208 246003 variant_image 88441 0 V 0 D 0 0
76209 246004 variant_image 88442 0 V 0 D 0 0
76210 246005 variant_image 88443 0 V 0 D 0 0
76211 246006 variant_image 88444 0 V 0 D 0 0
76212 246008 variant_image 88445 0 V 0 D 0 0
76213 246009 variant_image 88446 0 V 0 D 0 0
76214 246010 variant_image 88447 0 V 0 D 0 0
76215 246011 variant_image 88448 0 V 0 D 0 0
76216 246012 variant_image 88449 0 V 0 D 0 0
76217 246013 variant_image 88450 0 V 0 D 0 0
76218 246014 variant_image 88451 0 V 0 D 0 0
76219 246015 variant_image 88452 0 V 0 D 0 0
76220 246016 variant_image 88453 0 V 0 D 0 0
76221 246017 variant_image 88454 0 V 0 D 0 0
76222 246018 variant_image 88455 0 V 0 D 0 0