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, 
    221140, 
    221141, 
    221142, 
    223755, 
    223756, 
    223757, 
    223758, 
    223759, 
    225700, 
    225702, 
    225703, 
    225704, 
    225705, 
    225706, 
    226434, 
    226438, 
    226435, 
    226436, 
    226437, 
    226439, 
    226443, 
    226440, 
    226441, 
    226442, 
    226444, 
    226448, 
    226445, 
    226446, 
    226447, 
    226449, 
    226453, 
    226450, 
    226451, 
    226452, 
    226485, 
    226455, 
    226457, 
    226462, 
    226481, 
    244281, 
    226465, 
    226466, 
    244282, 
    239948, 
    226470, 
    226472, 
    226474, 
    226477, 
    226478, 
    226483, 
    226883, 
    226884, 
    226885, 
    226886, 
    226887, 
    226888, 
    240513, 
    226889, 
    226890, 
    226891, 
    226892, 
    226893, 
    229899, 
    229896, 
    229897, 
    229898, 
    230049, 
    230041, 
    230042, 
    230043, 
    230060, 
    230052, 
    230053, 
    230054, 
    230071, 
    230063, 
    230064, 
    230065, 
    230173, 
    230175, 
    230174, 
    230215, 
    230216, 
    230217, 
    230218, 
    230335, 
    245591, 
    245592, 
    245593, 
    245594, 
    245595, 
    245596, 
    245597, 
    245598, 
    230305, 
    230306, 
    230307, 
    230308, 
    230330, 
    230323, 
    237082, 
    237083, 
    230309, 
    242155, 
    241585, 
    230310, 
    230311, 
    230312, 
    230313, 
    230314, 
    241586, 
    230315, 
    230316, 
    230317, 
    230318, 
    230319, 
    230320, 
    230321, 
    230322, 
    241587, 
    230324, 
    241588, 
    230325, 
    230326, 
    242156, 
    242157, 
    230327, 
    230328, 
    230329, 
    242158, 
    241589, 
    230513, 
    230510, 
    230511, 
    230512, 
    230828, 
    230827, 
    239298, 
    239263, 
    239264, 
    239265, 
    239266, 
    239267, 
    239268, 
    239299, 
    239300, 
    239269, 
    241376, 
    239270, 
    239271, 
    239272, 
    239273, 
    239274, 
    241377, 
    239275, 
    239276, 
    239277, 
    239278, 
    239279, 
    239280, 
    239281, 
    239282, 
    241378, 
    239283, 
    241379, 
    239284, 
    239285, 
    239286, 
    239287, 
    239288, 
    241380, 
    242191, 
    242192, 
    242193, 
    242194, 
    245914, 
    245926, 
    245927, 
    245928, 
    245929, 
    245930, 
    245931, 
    245932, 
    245933, 
    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
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00213

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": 229,
          "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,221140,221141,221142,223755,223756,223757,223758,223759,225700,225702,225703,225704,225705,225706,226434,226438,226435,226436,226437,226439,226443,226440,226441,226442,226444,226448,226445,226446,226447,226449,226453,226450,226451,226452,226485,226455,226457,226462,226481,244281,226465,226466,244282,239948,226470,226472,226474,226477,226478,226483,226883,226884,226885,226886,226887,226888,240513,226889,226890,226891,226892,226893,229899,229896,229897,229898,230049,230041,230042,230043,230060,230052,230053,230054,230071,230063,230064,230065,230173,230175,230174,230215,230216,230217,230218,230335,245591,245592,245593,245594,245595,245596,245597,245598,230305,230306,230307,230308,230330,230323,237082,237083,230309,242155,241585,230310,230311,230312,230313,230314,241586,230315,230316,230317,230318,230319,230320,230321,230322,241587,230324,241588,230325,230326,242156,242157,230327,230328,230329,242158,241589,230513,230510,230511,230512,230828,230827,239298,239263,239264,239265,239266,239267,239268,239299,239300,239269,241376,239270,239271,239272,239273,239274,241377,239275,239276,239277,239278,239279,239280,239281,239282,241378,239283,241379,239284,239285,239286,239287,239288,241380,242191,242192,242193,242194,245914,245926,245927,245928,245929,245930,245931,245932,245933,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)"
        }
      }
    },
    "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
39609 221141 variant_image 51842 0 V 0 D 0 0
39610 221142 variant_image 51843 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
44622 226435 variant_image 56855 0 V 0 D 0 0
44623 226436 variant_image 56856 0 V 0 D 0 0
44624 226437 variant_image 56857 0 V 0 D 0 0
44625 226438 variant_image 56858 0 V 0 D 0 0
44626 226440 variant_image 56859 0 V 0 D 0 0
44627 226441 variant_image 56860 0 V 0 D 0 0
44628 226442 variant_image 56861 0 V 0 D 0 0
44629 226443 variant_image 56862 0 V 0 D 0 0
44630 226445 variant_image 56863 0 V 0 D 0 0
44631 226446 variant_image 56864 0 V 0 D 0 0
44632 226447 variant_image 56865 0 V 0 D 0 0
44633 226448 variant_image 56866 0 V 0 D 0 0
44634 226450 variant_image 56867 0 V 0 D 0 0
44635 226451 variant_image 56868 0 V 0 D 0 0
44636 226452 variant_image 56869 0 V 0 D 0 0
44637 226453 variant_image 56870 0 V 0 D 0 0
44638 226455 variant_image 56871 0 V 0 D 0 0
44640 226457 variant_image 56873 0 V 0 D 0 0
44645 226462 variant_image 56878 0 V 0 D 0 0
44648 226465 variant_image 56881 0 V 0 D 0 0
44649 226466 variant_image 56882 0 V 0 D 0 0
44653 226470 variant_image 56886 0 V 0 D 0 0
44655 226472 variant_image 56888 0 V 0 D 0 0
44657 226474 variant_image 56890 0 V 0 D 0 0
44660 226477 variant_image 56893 0 V 0 D 0 0
44661 226478 variant_image 56894 0 V 0 D 0 0
44664 226481 variant_image 56897 0 V 0 D 0 0
44666 226483 variant_image 56899 0 V 0 D 0 0
45037 226884 variant_image 57270 0 V 0 D 0 0
45038 226885 variant_image 57271 0 V 0 D 0 0
45039 226886 variant_image 57272 0 V 0 D 0 0
45040 226887 variant_image 57273 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
48627 230041 variant_image 60860 0 V 0 D 0 0
48628 230042 variant_image 60861 0 V 0 D 0 0
48629 230043 variant_image 60862 0 V 0 D 0 0
48637 230052 variant_image 60870 0 V 0 D 0 0
48638 230053 variant_image 60871 0 V 0 D 0 0
48639 230054 variant_image 60872 0 V 0 D 0 0
48647 230063 variant_image 60880 0 V 0 D 0 0
48648 230064 variant_image 60881 0 V 0 D 0 0
48649 230065 variant_image 60882 0 V 0 D 0 0
48789 230216 variant_image 61022 0 V 0 D 0 0
48790 230217 variant_image 61023 0 V 0 D 0 0
48791 230218 variant_image 61024 0 V 0 D 0 0
48887 230305 variant_image 61120 0 V 0 D 0 0
48888 230306 variant_image 61121 0 V 0 D 0 0
48889 230307 variant_image 61122 0 V 0 D 0 0
48890 230308 variant_image 61123 0 V 0 D 0 0
48891 230309 variant_image 61124 0 V 0 D 0 0
48892 230310 variant_image 61125 0 V 0 D 0 0
48893 230311 variant_image 61126 0 V 0 D 0 0
48894 230312 variant_image 61127 0 V 0 D 0 0
48895 230313 variant_image 61128 0 V 0 D 0 0
48896 230314 variant_image 61129 0 V 0 D 0 0
48897 230315 variant_image 61130 0 V 0 D 0 0
48898 230316 variant_image 61131 0 V 0 D 0 0
48899 230317 variant_image 61132 0 V 0 D 0 0
48900 230318 variant_image 61133 0 V 0 D 0 0
48901 230319 variant_image 61134 0 V 0 D 0 0
48902 230320 variant_image 61135 0 V 0 D 0 0
48903 230321 variant_image 61136 0 V 0 D 0 0
48904 230322 variant_image 61137 0 V 0 D 0 0
48905 230323 variant_image 61138 0 V 0 D 0 0
48906 230324 variant_image 61139 0 V 0 D 0 0
48907 230325 variant_image 61140 0 V 0 D 0 0
48908 230326 variant_image 61141 0 V 0 D 0 0
48909 230327 variant_image 61142 0 V 0 D 0 0
48910 230328 variant_image 61143 0 V 0 D 0 0
48911 230329 variant_image 61144 0 V 0 D 0 0
48912 230330 variant_image 61145 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
59829 237082 variant_image 72062 0 V 0 D 0 0
59830 237083 variant_image 72063 0 V 0 D 0 0
65423 239263 variant_image 77656 0 V 0 D 0 0
65424 239264 variant_image 77657 0 V 0 D 0 0
65425 239265 variant_image 77658 0 V 0 D 0 0
65426 239266 variant_image 77659 0 V 0 D 0 0
65427 239267 variant_image 77660 0 V 0 D 0 0
65428 239268 variant_image 77661 0 V 0 D 0 0
65429 239269 variant_image 77662 0 V 0 D 0 0
65430 239270 variant_image 77663 0 V 0 D 0 0
65431 239271 variant_image 77664 0 V 0 D 0 0
65432 239272 variant_image 77665 0 V 0 D 0 0
65433 239273 variant_image 77666 0 V 0 D 0 0
65434 239274 variant_image 77667 0 V 0 D 0 0
65435 239275 variant_image 77668 0 V 0 D 0 0
65436 239276 variant_image 77669 0 V 0 D 0 0
65437 239277 variant_image 77670 0 V 0 D 0 0
65438 239278 variant_image 77671 0 V 0 D 0 0
65439 239279 variant_image 77672 0 V 0 D 0 0
65440 239280 variant_image 77673 0 V 0 D 0 0
65441 239281 variant_image 77674 0 V 0 D 0 0
65442 239282 variant_image 77675 0 V 0 D 0 0
65443 239283 variant_image 77676 0 V 0 D 0 0
65444 239284 variant_image 77677 0 V 0 D 0 0
65445 239285 variant_image 77678 0 V 0 D 0 0
65446 239286 variant_image 77679 0 V 0 D 0 0
65447 239287 variant_image 77680 0 V 0 D 0 0
65448 239288 variant_image 77681 0 V 0 D 0 0
65458 239299 variant_image 77691 0 V 0 D 0 0
65459 239300 variant_image 77692 0 V 0 D 0 0
68285 239948 variant_image 80518 0 V 0 D 0 0
70911 241376 variant_image 83144 0 V 0 D 0 0
70912 241377 variant_image 83145 0 V 0 D 0 0
70913 241378 variant_image 83146 0 V 0 D 0 0
70914 241379 variant_image 83147 0 V 0 D 0 0
70915 241380 variant_image 83148 0 V 0 D 0 0
71139 241585 variant_image 83372 0 V 0 D 0 0
71140 241586 variant_image 83373 0 V 0 D 0 0
71141 241587 variant_image 83374 0 V 0 D 0 0
71142 241588 variant_image 83375 0 V 0 D 0 0
71143 241589 variant_image 83376 0 V 0 D 0 0
71718 242155 variant_image 83951 0 V 0 D 0 0
71719 242156 variant_image 83952 0 V 0 D 0 0
71720 242157 variant_image 83953 0 V 0 D 0 0
71721 242158 variant_image 83954 0 V 0 D 0 0
71754 242191 variant_image 83987 0 V 0 D 0 0
71755 242192 variant_image 83988 0 V 0 D 0 0
71756 242193 variant_image 83989 0 V 0 D 0 0
71757 242194 variant_image 83990 0 V 0 D 0 0
74008 244281 variant_image 86241 0 V 0 D 0 0
74009 244282 variant_image 86242 0 V 0 D 0 0
75718 245591 variant_image 87951 0 V 0 D 0 0
75719 245592 variant_image 87952 0 V 0 D 0 0
75720 245593 variant_image 87953 0 V 0 D 0 0
75721 245594 variant_image 87954 0 V 0 D 0 0
75722 245595 variant_image 87955 0 V 0 D 0 0
75723 245596 variant_image 87956 0 V 0 D 0 0
75724 245597 variant_image 87957 0 V 0 D 0 0
75725 245598 variant_image 87958 0 V 0 D 0 0
76072 245926 variant_image 88305 0 V 0 D 0 0
76073 245927 variant_image 88306 0 V 0 D 0 0
76074 245928 variant_image 88307 0 V 0 D 0 0
76075 245929 variant_image 88308 0 V 0 D 0 0
76076 245930 variant_image 88309 0 V 0 D 0 0
76077 245931 variant_image 88310 0 V 0 D 0 0
76078 245932 variant_image 88311 0 V 0 D 0 0
76079 245933 variant_image 88312 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