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 (
    232064, 
    232065, 
    232066, 
    232067, 
    232068, 
    232069, 
    233977, 
    233978, 
    233979, 
    234341, 
    245046, 
    245047, 
    245048, 
    245049, 
    245050, 
    245051, 
    245052, 
    245053, 
    234311, 
    234312, 
    234313, 
    234314, 
    234315, 
    234316, 
    236970, 
    236971, 
    234317, 
    241884, 
    234318, 
    234319, 
    234320, 
    234321, 
    234322, 
    241885, 
    234323, 
    234324, 
    234325, 
    234326, 
    234327, 
    234328, 
    234329, 
    234330, 
    241886, 
    234331, 
    241887, 
    234332, 
    234333, 
    234342, 
    234334, 
    234335, 
    241888, 
    234336, 
    234337, 
    234338, 
    234339, 
    234340, 
    234369, 
    234343, 
    234344, 
    234345, 
    234346, 
    234347, 
    234348, 
    234368, 
    234349, 
    236972, 
    236973, 
    234350, 
    241889, 
    234351, 
    234352, 
    234353, 
    234354, 
    234355, 
    241890, 
    234356, 
    234357, 
    234358, 
    234359, 
    234360, 
    234361, 
    234362, 
    234363, 
    241891, 
    234364, 
    241892, 
    234365, 
    234366, 
    234370, 
    234371, 
    234367, 
    241893, 
    234386, 
    234372, 
    245038, 
    245039, 
    245040, 
    245041, 
    245042, 
    245043, 
    245044, 
    245045, 
    234393, 
    234387, 
    234388, 
    234389, 
    234390, 
    234391, 
    234392, 
    234394, 
    234395, 
    234396, 
    234430, 
    234399, 
    234400, 
    234401, 
    234402, 
    234403, 
    234429, 
    234404, 
    236974, 
    236975, 
    234405, 
    241894, 
    234406, 
    234407, 
    234408, 
    234409, 
    234410, 
    241895, 
    234411, 
    234412, 
    234413, 
    234414, 
    234415, 
    234416, 
    234417, 
    234418, 
    241896, 
    234419, 
    241897, 
    234420, 
    234421, 
    234431, 
    234422, 
    234423, 
    241898, 
    234424, 
    234425, 
    234426, 
    234427, 
    234428, 
    234446, 
    234432, 
    245054, 
    245055, 
    245056, 
    245057, 
    245058, 
    245059, 
    245060, 
    245061, 
    234479, 
    234447, 
    234448, 
    234449, 
    234450, 
    234451, 
    234452, 
    234478, 
    234453, 
    236976, 
    236977, 
    234454, 
    241899, 
    234455, 
    234456, 
    234457, 
    234458, 
    234459, 
    241900, 
    234460, 
    234461, 
    234462, 
    234463, 
    234464, 
    234465, 
    234466, 
    234467, 
    241901, 
    234468, 
    241902, 
    234469, 
    234470, 
    234480, 
    234471, 
    234472, 
    241903, 
    234473, 
    234474, 
    234475, 
    234476, 
    234477, 
    234486, 
    234481, 
    234483, 
    234484, 
    234485, 
    234495, 
    234487, 
    234488, 
    234489, 
    234506, 
    234498, 
    234499, 
    234500, 
    234517, 
    234509, 
    234510, 
    234511, 
    234546, 
    234520, 
    234521, 
    234522, 
    234523, 
    234524, 
    234525, 
    236978, 
    236979, 
    234526, 
    241904, 
    234527, 
    234528, 
    234529, 
    234530, 
    234531, 
    241905, 
    234532, 
    234533, 
    234534, 
    234535, 
    234536, 
    234537, 
    234538, 
    234539, 
    241906, 
    234540, 
    241907, 
    234541, 
    234542, 
    234543, 
    234544, 
    234545, 
    241908, 
    234559, 
    245062, 
    245063, 
    245064, 
    245065, 
    245066, 
    245067, 
    245068, 
    245069, 
    234574, 
    234566, 
    234567, 
    234568, 
    234680, 
    234677, 
    234678, 
    234679, 
    234714, 
    234715, 
    234716, 
    234717, 
    234718, 
    234719
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00251

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": 277,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (232064,232065,232066,232067,232068,232069,233977,233978,233979,234341,245046,245047,245048,245049,245050,245051,245052,245053,234311,234312,234313,234314,234315,234316,236970,236971,234317,241884,234318,234319,234320,234321,234322,241885,234323,234324,234325,234326,234327,234328,234329,234330,241886,234331,241887,234332,234333,234342,234334,234335,241888,234336,234337,234338,234339,234340,234369,234343,234344,234345,234346,234347,234348,234368,234349,236972,236973,234350,241889,234351,234352,234353,234354,234355,241890,234356,234357,234358,234359,234360,234361,234362,234363,241891,234364,241892,234365,234366,234370,234371,234367,241893,234386,234372,245038,245039,245040,245041,245042,245043,245044,245045,234393,234387,234388,234389,234390,234391,234392,234394,234395,234396,234430,234399,234400,234401,234402,234403,234429,234404,236974,236975,234405,241894,234406,234407,234408,234409,234410,241895,234411,234412,234413,234414,234415,234416,234417,234418,241896,234419,241897,234420,234421,234431,234422,234423,241898,234424,234425,234426,234427,234428,234446,234432,245054,245055,245056,245057,245058,245059,245060,245061,234479,234447,234448,234449,234450,234451,234452,234478,234453,236976,236977,234454,241899,234455,234456,234457,234458,234459,241900,234460,234461,234462,234463,234464,234465,234466,234467,241901,234468,241902,234469,234470,234480,234471,234472,241903,234473,234474,234475,234476,234477,234486,234481,234483,234484,234485,234495,234487,234488,234489,234506,234498,234499,234500,234517,234509,234510,234511,234546,234520,234521,234522,234523,234524,234525,236978,236979,234526,241904,234527,234528,234529,234530,234531,241905,234532,234533,234534,234535,234536,234537,234538,234539,241906,234540,241907,234541,234542,234543,234544,234545,241908,234559,245062,245063,245064,245065,245066,245067,245068,245069,234574,234566,234567,234568,234680,234677,234678,234679,234714,234715,234716,234717,234718,234719)"
        }
      }
    },
    "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
52343 232065 variant_image 64576 0 V 0 D 0 0
52344 232066 variant_image 64577 0 V 0 D 0 0
52345 232067 variant_image 64578 0 V 0 D 0 0
52346 232068 variant_image 64579 0 V 0 D 0 0
52347 232069 variant_image 64580 0 V 0 D 0 0
54899 234311 variant_image 67132 0 V 0 D 0 0
54900 234312 variant_image 67133 0 V 0 D 0 0
54901 234313 variant_image 67134 0 V 0 D 0 0
54902 234314 variant_image 67135 0 V 0 D 0 0
54903 234315 variant_image 67136 0 V 0 D 0 0
54904 234316 variant_image 67137 0 V 0 D 0 0
54905 234317 variant_image 67138 0 V 0 D 0 0
54906 234318 variant_image 67139 0 V 0 D 0 0
54907 234319 variant_image 67140 0 V 0 D 0 0
54908 234320 variant_image 67141 0 V 0 D 0 0
54909 234321 variant_image 67142 0 V 0 D 0 0
54910 234322 variant_image 67143 0 V 0 D 0 0
54911 234323 variant_image 67144 0 V 0 D 0 0
54912 234324 variant_image 67145 0 V 0 D 0 0
54913 234325 variant_image 67146 0 V 0 D 0 0
54914 234326 variant_image 67147 0 V 0 D 0 0
54915 234327 variant_image 67148 0 V 0 D 0 0
54916 234328 variant_image 67149 0 V 0 D 0 0
54917 234329 variant_image 67150 0 V 0 D 0 0
54918 234330 variant_image 67151 0 V 0 D 0 0
54919 234331 variant_image 67152 0 V 0 D 0 0
54920 234332 variant_image 67153 0 V 0 D 0 0
54921 234333 variant_image 67154 0 V 0 D 0 0
54922 234334 variant_image 67155 0 V 0 D 0 0
54923 234335 variant_image 67156 0 V 0 D 0 0
54924 234336 variant_image 67157 0 V 0 D 0 0
54925 234337 variant_image 67158 0 V 0 D 0 0
54926 234338 variant_image 67159 0 V 0 D 0 0
54927 234339 variant_image 67160 0 V 0 D 0 0
54928 234340 variant_image 67161 0 V 0 D 0 0
54929 234342 variant_image 67162 0 V 0 D 0 0
54930 234344 variant_image 67163 0 V 0 D 0 0
54931 234345 variant_image 67164 0 V 0 D 0 0
54932 234346 variant_image 67165 0 V 0 D 0 0
54933 234347 variant_image 67166 0 V 0 D 0 0
54934 234348 variant_image 67167 0 V 0 D 0 0
54935 234349 variant_image 67168 0 V 0 D 0 0
54936 234350 variant_image 67169 0 V 0 D 0 0
54937 234351 variant_image 67170 0 V 0 D 0 0
54938 234352 variant_image 67171 0 V 0 D 0 0
54939 234353 variant_image 67172 0 V 0 D 0 0
54940 234354 variant_image 67173 0 V 0 D 0 0
54941 234355 variant_image 67174 0 V 0 D 0 0
54942 234356 variant_image 67175 0 V 0 D 0 0
54943 234357 variant_image 67176 0 V 0 D 0 0
54944 234358 variant_image 67177 0 V 0 D 0 0
54945 234359 variant_image 67178 0 V 0 D 0 0
54946 234360 variant_image 67179 0 V 0 D 0 0
54947 234361 variant_image 67180 0 V 0 D 0 0
54948 234362 variant_image 67181 0 V 0 D 0 0
54949 234363 variant_image 67182 0 V 0 D 0 0
54950 234364 variant_image 67183 0 V 0 D 0 0
54951 234365 variant_image 67184 0 V 0 D 0 0
54952 234366 variant_image 67185 0 V 0 D 0 0
54953 234367 variant_image 67186 0 V 0 D 0 0
54954 234368 variant_image 67187 0 V 0 D 0 0
54955 234370 variant_image 67188 0 V 0 D 0 0
54956 234371 variant_image 67189 0 V 0 D 0 0
54972 234399 variant_image 67205 0 V 0 D 0 0
54973 234400 variant_image 67206 0 V 0 D 0 0
54974 234401 variant_image 67207 0 V 0 D 0 0
54975 234402 variant_image 67208 0 V 0 D 0 0
54976 234403 variant_image 67209 0 V 0 D 0 0
54977 234404 variant_image 67210 0 V 0 D 0 0
54978 234405 variant_image 67211 0 V 0 D 0 0
54979 234406 variant_image 67212 0 V 0 D 0 0
54980 234407 variant_image 67213 0 V 0 D 0 0
54981 234408 variant_image 67214 0 V 0 D 0 0
54982 234409 variant_image 67215 0 V 0 D 0 0
54983 234410 variant_image 67216 0 V 0 D 0 0
54984 234411 variant_image 67217 0 V 0 D 0 0
54985 234412 variant_image 67218 0 V 0 D 0 0
54986 234413 variant_image 67219 0 V 0 D 0 0
54987 234414 variant_image 67220 0 V 0 D 0 0
54988 234415 variant_image 67221 0 V 0 D 0 0
54989 234416 variant_image 67222 0 V 0 D 0 0
54990 234417 variant_image 67223 0 V 0 D 0 0
54991 234418 variant_image 67224 0 V 0 D 0 0
54992 234419 variant_image 67225 0 V 0 D 0 0
54993 234420 variant_image 67226 0 V 0 D 0 0
54994 234421 variant_image 67227 0 V 0 D 0 0
54995 234422 variant_image 67228 0 V 0 D 0 0
54996 234423 variant_image 67229 0 V 0 D 0 0
54997 234424 variant_image 67230 0 V 0 D 0 0
54998 234425 variant_image 67231 0 V 0 D 0 0
54999 234426 variant_image 67232 0 V 0 D 0 0
55000 234427 variant_image 67233 0 V 0 D 0 0
55001 234428 variant_image 67234 0 V 0 D 0 0
55002 234429 variant_image 67235 0 V 0 D 0 0
55003 234431 variant_image 67236 0 V 0 D 0 0
55017 234448 variant_image 67250 0 V 0 D 0 0
55018 234449 variant_image 67251 0 V 0 D 0 0
55019 234450 variant_image 67252 0 V 0 D 0 0
55020 234451 variant_image 67253 0 V 0 D 0 0
55021 234452 variant_image 67254 0 V 0 D 0 0
55022 234453 variant_image 67255 0 V 0 D 0 0
55023 234454 variant_image 67256 0 V 0 D 0 0
55024 234455 variant_image 67257 0 V 0 D 0 0
55025 234456 variant_image 67258 0 V 0 D 0 0
55026 234457 variant_image 67259 0 V 0 D 0 0
55027 234458 variant_image 67260 0 V 0 D 0 0
55028 234459 variant_image 67261 0 V 0 D 0 0
55029 234460 variant_image 67262 0 V 0 D 0 0
55030 234461 variant_image 67263 0 V 0 D 0 0
55031 234462 variant_image 67264 0 V 0 D 0 0
55032 234463 variant_image 67265 0 V 0 D 0 0
55033 234464 variant_image 67266 0 V 0 D 0 0
55034 234465 variant_image 67267 0 V 0 D 0 0
55035 234466 variant_image 67268 0 V 0 D 0 0
55036 234467 variant_image 67269 0 V 0 D 0 0
55037 234468 variant_image 67270 0 V 0 D 0 0
55038 234469 variant_image 67271 0 V 0 D 0 0
55039 234470 variant_image 67272 0 V 0 D 0 0
55040 234471 variant_image 67273 0 V 0 D 0 0
55041 234472 variant_image 67274 0 V 0 D 0 0
55042 234473 variant_image 67275 0 V 0 D 0 0
55043 234474 variant_image 67276 0 V 0 D 0 0
55044 234475 variant_image 67277 0 V 0 D 0 0
55045 234476 variant_image 67278 0 V 0 D 0 0
55046 234477 variant_image 67279 0 V 0 D 0 0
55047 234478 variant_image 67280 0 V 0 D 0 0
55048 234480 variant_image 67281 0 V 0 D 0 0
55049 234481 variant_image 67282 0 V 0 D 0 0
55051 234483 variant_image 67284 0 V 0 D 0 0
55052 234484 variant_image 67285 0 V 0 D 0 0
55053 234485 variant_image 67286 0 V 0 D 0 0
55054 234487 variant_image 67287 0 V 0 D 0 0
55055 234488 variant_image 67288 0 V 0 D 0 0
55056 234489 variant_image 67289 0 V 0 D 0 0
55064 234498 variant_image 67297 0 V 0 D 0 0
55065 234499 variant_image 67298 0 V 0 D 0 0
55066 234500 variant_image 67299 0 V 0 D 0 0
55074 234509 variant_image 67307 0 V 0 D 0 0
55075 234510 variant_image 67308 0 V 0 D 0 0
55076 234511 variant_image 67309 0 V 0 D 0 0
55084 234520 variant_image 67317 0 V 0 D 0 0
55085 234521 variant_image 67318 0 V 0 D 0 0
55086 234522 variant_image 67319 0 V 0 D 0 0
55087 234523 variant_image 67320 0 V 0 D 0 0
55088 234524 variant_image 67321 0 V 0 D 0 0
55089 234525 variant_image 67322 0 V 0 D 0 0
55090 234526 variant_image 67323 0 V 0 D 0 0
55091 234527 variant_image 67324 0 V 0 D 0 0
55092 234528 variant_image 67325 0 V 0 D 0 0
55093 234529 variant_image 67326 0 V 0 D 0 0
55094 234530 variant_image 67327 0 V 0 D 0 0
55095 234531 variant_image 67328 0 V 0 D 0 0
55096 234532 variant_image 67329 0 V 0 D 0 0
55097 234533 variant_image 67330 0 V 0 D 0 0
55098 234534 variant_image 67331 0 V 0 D 0 0
55099 234535 variant_image 67332 0 V 0 D 0 0
55100 234536 variant_image 67333 0 V 0 D 0 0
55101 234537 variant_image 67334 0 V 0 D 0 0
55102 234538 variant_image 67335 0 V 0 D 0 0
55103 234539 variant_image 67336 0 V 0 D 0 0
55104 234540 variant_image 67337 0 V 0 D 0 0
55105 234541 variant_image 67338 0 V 0 D 0 0
55106 234542 variant_image 67339 0 V 0 D 0 0
55107 234543 variant_image 67340 0 V 0 D 0 0
55108 234544 variant_image 67341 0 V 0 D 0 0
55109 234545 variant_image 67342 0 V 0 D 0 0
55122 234566 variant_image 67355 0 V 0 D 0 0
55123 234567 variant_image 67356 0 V 0 D 0 0
55124 234568 variant_image 67357 0 V 0 D 0 0
55347 234677 variant_image 67580 0 V 0 D 0 0
55348 234678 variant_image 67581 0 V 0 D 0 0
55349 234679 variant_image 67582 0 V 0 D 0 0
59714 236970 variant_image 71947 0 V 0 D 0 0
59715 236971 variant_image 71948 0 V 0 D 0 0
59716 236972 variant_image 71949 0 V 0 D 0 0
59717 236973 variant_image 71950 0 V 0 D 0 0
59718 236974 variant_image 71951 0 V 0 D 0 0
59719 236975 variant_image 71952 0 V 0 D 0 0
59720 236976 variant_image 71953 0 V 0 D 0 0
59721 236977 variant_image 71954 0 V 0 D 0 0
59722 236978 variant_image 71955 0 V 0 D 0 0
59723 236979 variant_image 71956 0 V 0 D 0 0
71437 241884 variant_image 83670 0 V 0 D 0 0
71438 241885 variant_image 83671 0 V 0 D 0 0
71439 241886 variant_image 83672 0 V 0 D 0 0
71440 241887 variant_image 83673 0 V 0 D 0 0
71441 241888 variant_image 83674 0 V 0 D 0 0
71442 241889 variant_image 83675 0 V 0 D 0 0
71443 241890 variant_image 83676 0 V 0 D 0 0
71444 241891 variant_image 83677 0 V 0 D 0 0
71445 241892 variant_image 83678 0 V 0 D 0 0
71446 241893 variant_image 83679 0 V 0 D 0 0
71447 241894 variant_image 83680 0 V 0 D 0 0
71448 241895 variant_image 83681 0 V 0 D 0 0
71449 241896 variant_image 83682 0 V 0 D 0 0
71450 241897 variant_image 83683 0 V 0 D 0 0
71451 241898 variant_image 83684 0 V 0 D 0 0
71452 241899 variant_image 83685 0 V 0 D 0 0
71453 241900 variant_image 83686 0 V 0 D 0 0
71454 241901 variant_image 83687 0 V 0 D 0 0
71455 241902 variant_image 83688 0 V 0 D 0 0
71456 241903 variant_image 83689 0 V 0 D 0 0
71457 241904 variant_image 83690 0 V 0 D 0 0
71458 241905 variant_image 83691 0 V 0 D 0 0
71459 241906 variant_image 83692 0 V 0 D 0 0
71460 241907 variant_image 83693 0 V 0 D 0 0
71461 241908 variant_image 83694 0 V 0 D 0 0
74830 245038 variant_image 87063 0 V 0 D 0 0
74831 245039 variant_image 87064 0 V 0 D 0 0
74832 245040 variant_image 87065 0 V 0 D 0 0
74833 245041 variant_image 87066 0 V 0 D 0 0
74834 245042 variant_image 87067 0 V 0 D 0 0
74835 245043 variant_image 87068 0 V 0 D 0 0
74836 245044 variant_image 87069 0 V 0 D 0 0
74837 245045 variant_image 87070 0 V 0 D 0 0
74838 245046 variant_image 87071 0 V 0 D 0 0
74839 245047 variant_image 87072 0 V 0 D 0 0
74840 245048 variant_image 87073 0 V 0 D 0 0
74841 245049 variant_image 87074 0 V 0 D 0 0
74842 245050 variant_image 87075 0 V 0 D 0 0
74843 245051 variant_image 87076 0 V 0 D 0 0
74844 245052 variant_image 87077 0 V 0 D 0 0
74845 245053 variant_image 87078 0 V 0 D 0 0
74846 245054 variant_image 87079 0 V 0 D 0 0
74847 245055 variant_image 87080 0 V 0 D 0 0
74848 245056 variant_image 87081 0 V 0 D 0 0
74849 245057 variant_image 87082 0 V 0 D 0 0
74850 245058 variant_image 87083 0 V 0 D 0 0
74851 245059 variant_image 87084 0 V 0 D 0 0
74852 245060 variant_image 87085 0 V 0 D 0 0
74853 245061 variant_image 87086 0 V 0 D 0 0
74854 245062 variant_image 87087 0 V 0 D 0 0
74855 245063 variant_image 87088 0 V 0 D 0 0
74856 245064 variant_image 87089 0 V 0 D 0 0
74857 245065 variant_image 87090 0 V 0 D 0 0
74858 245066 variant_image 87091 0 V 0 D 0 0
74859 245067 variant_image 87092 0 V 0 D 0 0
74860 245068 variant_image 87093 0 V 0 D 0 0
74861 245069 variant_image 87094 0 V 0 D 0 0