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 (
    219052, 
    219053, 
    219054, 
    220129, 
    219055, 
    219056, 
    219057, 
    220143, 
    244558, 
    244559, 
    244560, 
    244561, 
    244562, 
    244563, 
    244564, 
    244565, 
    216947, 
    216948, 
    216949, 
    216950, 
    216951, 
    216952, 
    236882, 
    236883, 
    216953, 
    245122, 
    241590, 
    216954, 
    216955, 
    216956, 
    216957, 
    216958, 
    241591, 
    216959, 
    216960, 
    216961, 
    216962, 
    216963, 
    216964, 
    216965, 
    216966, 
    241592, 
    216967, 
    241593, 
    216968, 
    216969, 
    245123, 
    245124, 
    225920, 
    216970, 
    216971, 
    245125, 
    241594, 
    220240, 
    216999, 
    217000, 
    217001, 
    220241, 
    217009, 
    217010, 
    217011, 
    220264, 
    216983, 
    216984, 
    216985, 
    220267, 
    244574, 
    244575, 
    244576, 
    244577, 
    244578, 
    244579, 
    244580, 
    244581, 
    220268, 
    217069, 
    217070, 
    217071, 
    217072, 
    217073, 
    217074, 
    236884, 
    236885, 
    217075, 
    245130, 
    241600, 
    217076, 
    217077, 
    217078, 
    217079, 
    217080, 
    241601, 
    217081, 
    217082, 
    217083, 
    217084, 
    217085, 
    217086, 
    217087, 
    217088, 
    241602, 
    217089, 
    241603, 
    217090, 
    217091, 
    245131, 
    245132, 
    217092, 
    217093, 
    217094, 
    245133, 
    241604, 
    220269, 
    217095, 
    217096, 
    217097, 
    217098, 
    217099, 
    217100, 
    236886, 
    236887, 
    217101, 
    241605, 
    217102, 
    217103, 
    217104, 
    217105, 
    217106, 
    241606, 
    217107, 
    217108, 
    217109, 
    217110, 
    217111, 
    217112, 
    217113, 
    217114, 
    241607, 
    217115, 
    241608, 
    217116, 
    217117, 
    225921, 
    217118, 
    217119, 
    241609, 
    220270, 
    244582, 
    244583, 
    244584, 
    244585, 
    244586, 
    244587, 
    244588, 
    244589, 
    220300, 
    215616, 
    215617, 
    220307, 
    215660, 
    215661, 
    215662, 
    215663, 
    215664, 
    215665, 
    215666, 
    215667, 
    215668, 
    215669, 
    215670, 
    215671, 
    215672, 
    215673, 
    243095, 
    243096, 
    243097, 
    243098, 
    220308, 
    215618, 
    215619, 
    220317, 
    217132, 
    217133, 
    237785, 
    237779, 
    237781, 
    237782, 
    237783, 
    237784
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00238

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": 189,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (219052,219053,219054,220129,219055,219056,219057,220143,244558,244559,244560,244561,244562,244563,244564,244565,216947,216948,216949,216950,216951,216952,236882,236883,216953,245122,241590,216954,216955,216956,216957,216958,241591,216959,216960,216961,216962,216963,216964,216965,216966,241592,216967,241593,216968,216969,245123,245124,225920,216970,216971,245125,241594,220240,216999,217000,217001,220241,217009,217010,217011,220264,216983,216984,216985,220267,244574,244575,244576,244577,244578,244579,244580,244581,220268,217069,217070,217071,217072,217073,217074,236884,236885,217075,245130,241600,217076,217077,217078,217079,217080,241601,217081,217082,217083,217084,217085,217086,217087,217088,241602,217089,241603,217090,217091,245131,245132,217092,217093,217094,245133,241604,220269,217095,217096,217097,217098,217099,217100,236886,236887,217101,241605,217102,217103,217104,217105,217106,241606,217107,217108,217109,217110,217111,217112,217113,217114,241607,217115,241608,217116,217117,225921,217118,217119,241609,220270,244582,244583,244584,244585,244586,244587,244588,244589,220300,215616,215617,220307,215660,215661,215662,215663,215664,215665,215666,215667,215668,215669,215670,215671,215672,215673,243095,243096,243097,243098,220308,215618,215619,220317,217132,217133,237785,237779,237781,237782,237783,237784)"
        }
      }
    },
    "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
33769 215619 variant_image 46002 0 V 0 D 0 0
33807 215660 variant_image 46040 0 V 0 D 0 0
33808 215661 variant_image 46041 0 V 0 D 0 0
33809 215662 variant_image 46042 0 V 0 D 0 0
33810 215663 variant_image 46043 0 V 0 D 0 0
33811 215664 variant_image 46044 0 V 0 D 0 0
33812 215665 variant_image 46045 0 V 0 D 0 0
33813 215666 variant_image 46046 0 V 0 D 0 0
33814 215667 variant_image 46047 0 V 0 D 0 0
33815 215668 variant_image 46048 0 V 0 D 0 0
33816 215669 variant_image 46049 0 V 0 D 0 0
33817 215670 variant_image 46050 0 V 0 D 0 0
33818 215671 variant_image 46051 0 V 0 D 0 0
33819 215672 variant_image 46052 0 V 0 D 0 0
33820 215673 variant_image 46053 0 V 0 D 0 0
33840 215618 variant_image 46073 0 V 0 D 0 0
34161 215616 variant_image 46394 0 V 0 D 0 0
34162 215617 variant_image 46395 0 V 0 D 0 0
35143 216947 variant_image 47376 0 V 0 D 0 0
35144 216948 variant_image 47377 0 V 0 D 0 0
35145 216949 variant_image 47378 0 V 0 D 0 0
35146 216950 variant_image 47379 0 V 0 D 0 0
35147 216951 variant_image 47380 0 V 0 D 0 0
35148 216952 variant_image 47381 0 V 0 D 0 0
35149 216953 variant_image 47382 0 V 0 D 0 0
35150 216954 variant_image 47383 0 V 0 D 0 0
35151 216955 variant_image 47384 0 V 0 D 0 0
35152 216956 variant_image 47385 0 V 0 D 0 0
35153 216957 variant_image 47386 0 V 0 D 0 0
35154 216958 variant_image 47387 0 V 0 D 0 0
35155 216959 variant_image 47388 0 V 0 D 0 0
35156 216960 variant_image 47389 0 V 0 D 0 0
35157 216961 variant_image 47390 0 V 0 D 0 0
35158 216962 variant_image 47391 0 V 0 D 0 0
35159 216963 variant_image 47392 0 V 0 D 0 0
35160 216964 variant_image 47393 0 V 0 D 0 0
35161 216965 variant_image 47394 0 V 0 D 0 0
35162 216966 variant_image 47395 0 V 0 D 0 0
35163 216967 variant_image 47396 0 V 0 D 0 0
35164 216968 variant_image 47397 0 V 0 D 0 0
35165 216969 variant_image 47398 0 V 0 D 0 0
35166 216970 variant_image 47399 0 V 0 D 0 0
35167 216971 variant_image 47400 0 V 0 D 0 0
35178 216983 variant_image 47411 0 V 0 D 0 0
35179 216984 variant_image 47412 0 V 0 D 0 0
35180 216985 variant_image 47413 0 V 0 D 0 0
35195 216999 variant_image 47428 0 V 0 D 0 0
35196 217000 variant_image 47429 0 V 0 D 0 0
35197 217001 variant_image 47430 0 V 0 D 0 0
35205 217009 variant_image 47438 0 V 0 D 0 0
35206 217010 variant_image 47439 0 V 0 D 0 0
35207 217011 variant_image 47440 0 V 0 D 0 0
35264 217069 variant_image 47497 0 V 0 D 0 0
35265 217070 variant_image 47498 0 V 0 D 0 0
35266 217071 variant_image 47499 0 V 0 D 0 0
35267 217072 variant_image 47500 0 V 0 D 0 0
35268 217073 variant_image 47501 0 V 0 D 0 0
35269 217074 variant_image 47502 0 V 0 D 0 0
35270 217075 variant_image 47503 0 V 0 D 0 0
35271 217076 variant_image 47504 0 V 0 D 0 0
35272 217077 variant_image 47505 0 V 0 D 0 0
35273 217078 variant_image 47506 0 V 0 D 0 0
35274 217079 variant_image 47507 0 V 0 D 0 0
35275 217080 variant_image 47508 0 V 0 D 0 0
35276 217081 variant_image 47509 0 V 0 D 0 0
35277 217082 variant_image 47510 0 V 0 D 0 0
35278 217083 variant_image 47511 0 V 0 D 0 0
35279 217084 variant_image 47512 0 V 0 D 0 0
35280 217085 variant_image 47513 0 V 0 D 0 0
35281 217086 variant_image 47514 0 V 0 D 0 0
35282 217087 variant_image 47515 0 V 0 D 0 0
35283 217088 variant_image 47516 0 V 0 D 0 0
35284 217091 variant_image 47517 0 V 0 D 0 0
35285 217092 variant_image 47518 0 V 0 D 0 0
35286 217093 variant_image 47519 0 V 0 D 0 0
35287 217094 variant_image 47520 0 V 0 D 0 0
35288 217095 variant_image 47521 0 V 0 D 0 0
35289 217096 variant_image 47522 0 V 0 D 0 0
35290 217097 variant_image 47523 0 V 0 D 0 0
35291 217098 variant_image 47524 0 V 0 D 0 0
35292 217099 variant_image 47525 0 V 0 D 0 0
35293 217100 variant_image 47526 0 V 0 D 0 0
35294 217101 variant_image 47527 0 V 0 D 0 0
35295 217102 variant_image 47528 0 V 0 D 0 0
35296 217103 variant_image 47529 0 V 0 D 0 0
35297 217104 variant_image 47530 0 V 0 D 0 0
35298 217105 variant_image 47531 0 V 0 D 0 0
35299 217106 variant_image 47532 0 V 0 D 0 0
35300 217107 variant_image 47533 0 V 0 D 0 0
35301 217108 variant_image 47534 0 V 0 D 0 0
35302 217109 variant_image 47535 0 V 0 D 0 0
35303 217110 variant_image 47536 0 V 0 D 0 0
35304 217111 variant_image 47537 0 V 0 D 0 0
35305 217112 variant_image 47538 0 V 0 D 0 0
35306 217113 variant_image 47539 0 V 0 D 0 0
35307 217114 variant_image 47540 0 V 0 D 0 0
35308 217115 variant_image 47541 0 V 0 D 0 0
35309 217116 variant_image 47542 0 V 0 D 0 0
35310 217117 variant_image 47543 0 V 0 D 0 0
35311 217118 variant_image 47544 0 V 0 D 0 0
35312 217119 variant_image 47545 0 V 0 D 0 0
35325 217132 variant_image 47558 0 V 0 D 0 0
35326 217133 variant_image 47559 0 V 0 D 0 0
35328 217089 variant_image 47561 0 V 0 D 0 0
35329 217090 variant_image 47562 0 V 0 D 0 0
37613 219055 variant_image 49846 0 V 0 D 0 0
37614 219056 variant_image 49847 0 V 0 D 0 0
37615 219057 variant_image 49848 0 V 0 D 0 0
44137 225920 variant_image 56370 0 V 0 D 0 0
44138 225921 variant_image 56371 0 V 0 D 0 0
59624 236882 variant_image 71857 0 V 0 D 0 0
59625 236883 variant_image 71858 0 V 0 D 0 0
59626 236884 variant_image 71859 0 V 0 D 0 0
59627 236885 variant_image 71860 0 V 0 D 0 0
59628 236886 variant_image 71861 0 V 0 D 0 0
59629 236887 variant_image 71862 0 V 0 D 0 0
60856 237779 variant_image 73089 0 V 0 D 0 0
60858 237781 variant_image 73091 0 V 0 D 0 0
60859 237782 variant_image 73092 0 V 0 D 0 0
60860 237783 variant_image 73093 0 V 0 D 0 0
60861 237784 variant_image 73094 0 V 0 D 0 0
71144 241590 variant_image 83377 0 V 0 D 0 0
71145 241591 variant_image 83378 0 V 0 D 0 0
71146 241592 variant_image 83379 0 V 0 D 0 0
71147 241593 variant_image 83380 0 V 0 D 0 0
71148 241594 variant_image 83381 0 V 0 D 0 0
71154 241600 variant_image 83387 0 V 0 D 0 0
71155 241601 variant_image 83388 0 V 0 D 0 0
71156 241602 variant_image 83389 0 V 0 D 0 0
71157 241603 variant_image 83390 0 V 0 D 0 0
71158 241604 variant_image 83391 0 V 0 D 0 0
71159 241605 variant_image 83392 0 V 0 D 0 0
71160 241606 variant_image 83393 0 V 0 D 0 0
71161 241607 variant_image 83394 0 V 0 D 0 0
71162 241608 variant_image 83395 0 V 0 D 0 0
71163 241609 variant_image 83396 0 V 0 D 0 0
72811 243095 variant_image 85044 0 V 0 D 0 0
72812 243096 variant_image 85045 0 V 0 D 0 0
72813 243097 variant_image 85046 0 V 0 D 0 0
72814 243098 variant_image 85047 0 V 0 D 0 0
74350 244558 variant_image 86583 0 V 0 D 0 0
74351 244559 variant_image 86584 0 V 0 D 0 0
74352 244560 variant_image 86585 0 V 0 D 0 0
74353 244561 variant_image 86586 0 V 0 D 0 0
74354 244562 variant_image 86587 0 V 0 D 0 0
74355 244563 variant_image 86588 0 V 0 D 0 0
74356 244564 variant_image 86589 0 V 0 D 0 0
74357 244565 variant_image 86590 0 V 0 D 0 0
74366 244574 variant_image 86599 0 V 0 D 0 0
74367 244575 variant_image 86600 0 V 0 D 0 0
74368 244576 variant_image 86601 0 V 0 D 0 0
74369 244577 variant_image 86602 0 V 0 D 0 0
74370 244578 variant_image 86603 0 V 0 D 0 0
74371 244579 variant_image 86604 0 V 0 D 0 0
74372 244580 variant_image 86605 0 V 0 D 0 0
74373 244581 variant_image 86606 0 V 0 D 0 0
74374 244582 variant_image 86607 0 V 0 D 0 0
74375 244583 variant_image 86608 0 V 0 D 0 0
74376 244584 variant_image 86609 0 V 0 D 0 0
74377 244585 variant_image 86610 0 V 0 D 0 0
74378 244586 variant_image 86611 0 V 0 D 0 0
74379 244587 variant_image 86612 0 V 0 D 0 0
74380 244588 variant_image 86613 0 V 0 D 0 0
74381 244589 variant_image 86614 0 V 0 D 0 0
74917 245122 variant_image 87150 0 V 0 D 0 0
74918 245123 variant_image 87151 0 V 0 D 0 0
74919 245124 variant_image 87152 0 V 0 D 0 0
74920 245125 variant_image 87153 0 V 0 D 0 0
74925 245130 variant_image 87158 0 V 0 D 0 0
74926 245131 variant_image 87159 0 V 0 D 0 0
74927 245132 variant_image 87160 0 V 0 D 0 0
74928 245133 variant_image 87161 0 V 0 D 0 0