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 (
    220173, 
    215556, 
    215557, 
    215558, 
    215559, 
    215560, 
    215561, 
    215562, 
    215563, 
    215564, 
    215565, 
    215566, 
    215567, 
    215568, 
    215569, 
    243103, 
    243104, 
    243105, 
    243106, 
    220319, 
    219225, 
    219227, 
    242997, 
    219229, 
    220320, 
    219237, 
    219238, 
    219239, 
    242973, 
    219241, 
    219249, 
    219250, 
    219252, 
    219253, 
    219254, 
    219255, 
    219256, 
    219257, 
    219258, 
    219259, 
    224467, 
    224437, 
    224438, 
    224439, 
    224440, 
    224462, 
    224455, 
    237080, 
    237081, 
    224441, 
    242769, 
    224442, 
    224443, 
    224444, 
    224445, 
    224446, 
    242770, 
    224447, 
    224448, 
    224449, 
    224450, 
    224451, 
    224452, 
    224453, 
    224454, 
    242771, 
    224456, 
    242772, 
    224457, 
    224458, 
    224459, 
    224460, 
    224461, 
    242773, 
    224463, 
    224464, 
    224465, 
    224466, 
    224468, 
    224469, 
    224599, 
    224595, 
    224596, 
    224597, 
    224598, 
    226978, 
    226957, 
    226958, 
    226959, 
    226960, 
    227052, 
    227022, 
    227023, 
    227024, 
    227025, 
    227047, 
    227040, 
    237084, 
    237085, 
    227026, 
    241381, 
    227027, 
    227028, 
    227029, 
    227030, 
    227031, 
    241382, 
    227032, 
    227033, 
    227034, 
    227035, 
    227036, 
    227037, 
    227038, 
    227039, 
    241383, 
    227041, 
    241384, 
    227042, 
    227043, 
    227044, 
    227045, 
    227046, 
    241385, 
    227053, 
    227054, 
    242199, 
    242200, 
    242201, 
    242202, 
    228555, 
    228556, 
    228557, 
    228558, 
    228559, 
    228560, 
    228561, 
    228593, 
    228562, 
    228563, 
    228564, 
    228565, 
    228566, 
    228567, 
    228569, 
    237078, 
    237079, 
    228570, 
    242785, 
    241675, 
    228571, 
    228572, 
    228573, 
    228574, 
    228575, 
    241676, 
    228576, 
    228577, 
    228578, 
    228579, 
    228580, 
    228581, 
    228582, 
    228583, 
    241677, 
    228584, 
    241678, 
    228585, 
    228586, 
    242786, 
    242787, 
    228587, 
    228588, 
    242788, 
    241679, 
    228624, 
    228594, 
    228595, 
    228596, 
    228597, 
    228619, 
    228612, 
    237074, 
    237075, 
    228598, 
    242509, 
    241555, 
    228599, 
    228600, 
    228601, 
    228602, 
    228603, 
    241556, 
    228604, 
    228605, 
    228606, 
    228607, 
    228608, 
    228609, 
    228610, 
    228611, 
    241557, 
    228613, 
    241558, 
    228614, 
    228615, 
    242510, 
    242511, 
    228616, 
    228617, 
    228618, 
    242512, 
    241559, 
    228645, 
    228633, 
    228635, 
    242989, 
    228637, 
    228649, 
    228646, 
    228647, 
    228648
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00208

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": 222,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (220173,215556,215557,215558,215559,215560,215561,215562,215563,215564,215565,215566,215567,215568,215569,243103,243104,243105,243106,220319,219225,219227,242997,219229,220320,219237,219238,219239,242973,219241,219249,219250,219252,219253,219254,219255,219256,219257,219258,219259,224467,224437,224438,224439,224440,224462,224455,237080,237081,224441,242769,224442,224443,224444,224445,224446,242770,224447,224448,224449,224450,224451,224452,224453,224454,242771,224456,242772,224457,224458,224459,224460,224461,242773,224463,224464,224465,224466,224468,224469,224599,224595,224596,224597,224598,226978,226957,226958,226959,226960,227052,227022,227023,227024,227025,227047,227040,237084,237085,227026,241381,227027,227028,227029,227030,227031,241382,227032,227033,227034,227035,227036,227037,227038,227039,241383,227041,241384,227042,227043,227044,227045,227046,241385,227053,227054,242199,242200,242201,242202,228555,228556,228557,228558,228559,228560,228561,228593,228562,228563,228564,228565,228566,228567,228569,237078,237079,228570,242785,241675,228571,228572,228573,228574,228575,241676,228576,228577,228578,228579,228580,228581,228582,228583,241677,228584,241678,228585,228586,242786,242787,228587,228588,242788,241679,228624,228594,228595,228596,228597,228619,228612,237074,237075,228598,242509,241555,228599,228600,228601,228602,228603,241556,228604,228605,228606,228607,228608,228609,228610,228611,241557,228613,241558,228614,228615,242510,242511,228616,228617,228618,242512,241559,228645,228633,228635,242989,228637,228649,228646,228647,228648)"
        }
      }
    },
    "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
33513 215556 variant_image 45746 0 V 0 D 0 0
33514 215557 variant_image 45747 0 V 0 D 0 0
33515 215558 variant_image 45748 0 V 0 D 0 0
33516 215559 variant_image 45749 0 V 0 D 0 0
33517 215560 variant_image 45750 0 V 0 D 0 0
33518 215561 variant_image 45751 0 V 0 D 0 0
33519 215562 variant_image 45752 0 V 0 D 0 0
33520 215563 variant_image 45753 0 V 0 D 0 0
33521 215564 variant_image 45754 0 V 0 D 0 0
33522 215565 variant_image 45755 0 V 0 D 0 0
33523 215566 variant_image 45756 0 V 0 D 0 0
33524 215567 variant_image 45757 0 V 0 D 0 0
33525 215568 variant_image 45758 0 V 0 D 0 0
33526 215569 variant_image 45759 0 V 0 D 0 0
37889 219227 variant_image 50122 0 V 0 D 0 0
37891 219229 variant_image 50124 0 V 0 D 0 0
37901 219238 variant_image 50134 0 V 0 D 0 0
37904 219241 variant_image 50137 0 V 0 D 0 0
37912 219249 variant_image 50145 0 V 0 D 0 0
37913 219250 variant_image 50146 0 V 0 D 0 0
37915 219252 variant_image 50148 0 V 0 D 0 0
37916 219253 variant_image 50149 0 V 0 D 0 0
37917 219254 variant_image 50150 0 V 0 D 0 0
37918 219255 variant_image 50151 0 V 0 D 0 0
37919 219256 variant_image 50152 0 V 0 D 0 0
37920 219257 variant_image 50153 0 V 0 D 0 0
37921 219258 variant_image 50154 0 V 0 D 0 0
37922 219259 variant_image 50155 0 V 0 D 0 0
38008 219225 variant_image 50241 0 V 0 D 0 0
38738 219237 variant_image 50971 0 V 0 D 0 0
42735 224437 variant_image 54968 0 V 0 D 0 0
42736 224438 variant_image 54969 0 V 0 D 0 0
42737 224439 variant_image 54970 0 V 0 D 0 0
42738 224440 variant_image 54971 0 V 0 D 0 0
42739 224441 variant_image 54972 0 V 0 D 0 0
42740 224442 variant_image 54973 0 V 0 D 0 0
42741 224443 variant_image 54974 0 V 0 D 0 0
42742 224444 variant_image 54975 0 V 0 D 0 0
42743 224445 variant_image 54976 0 V 0 D 0 0
42744 224446 variant_image 54977 0 V 0 D 0 0
42745 224447 variant_image 54978 0 V 0 D 0 0
42746 224448 variant_image 54979 0 V 0 D 0 0
42747 224449 variant_image 54980 0 V 0 D 0 0
42748 224450 variant_image 54981 0 V 0 D 0 0
42749 224451 variant_image 54982 0 V 0 D 0 0
42750 224452 variant_image 54983 0 V 0 D 0 0
42751 224453 variant_image 54984 0 V 0 D 0 0
42752 224454 variant_image 54985 0 V 0 D 0 0
42753 224455 variant_image 54986 0 V 0 D 0 0
42754 224456 variant_image 54987 0 V 0 D 0 0
42755 224457 variant_image 54988 0 V 0 D 0 0
42756 224458 variant_image 54989 0 V 0 D 0 0
42757 224459 variant_image 54990 0 V 0 D 0 0
42758 224460 variant_image 54991 0 V 0 D 0 0
42759 224461 variant_image 54992 0 V 0 D 0 0
42760 224462 variant_image 54993 0 V 0 D 0 0
42761 224463 variant_image 54994 0 V 0 D 0 0
42762 224464 variant_image 54995 0 V 0 D 0 0
42763 224465 variant_image 54996 0 V 0 D 0 0
42764 224466 variant_image 54997 0 V 0 D 0 0
42765 224468 variant_image 54998 0 V 0 D 0 0
42766 224469 variant_image 54999 0 V 0 D 0 0
45082 226957 variant_image 57315 0 V 0 D 0 0
45083 226958 variant_image 57316 0 V 0 D 0 0
45084 226959 variant_image 57317 0 V 0 D 0 0
45085 226960 variant_image 57318 0 V 0 D 0 0
45162 227022 variant_image 57395 0 V 0 D 0 0
45163 227023 variant_image 57396 0 V 0 D 0 0
45164 227024 variant_image 57397 0 V 0 D 0 0
45165 227025 variant_image 57398 0 V 0 D 0 0
45166 227026 variant_image 57399 0 V 0 D 0 0
45167 227027 variant_image 57400 0 V 0 D 0 0
45168 227028 variant_image 57401 0 V 0 D 0 0
45169 227029 variant_image 57402 0 V 0 D 0 0
45170 227030 variant_image 57403 0 V 0 D 0 0
45171 227031 variant_image 57404 0 V 0 D 0 0
45172 227032 variant_image 57405 0 V 0 D 0 0
45173 227033 variant_image 57406 0 V 0 D 0 0
45174 227034 variant_image 57407 0 V 0 D 0 0
45175 227035 variant_image 57408 0 V 0 D 0 0
45176 227036 variant_image 57409 0 V 0 D 0 0
45177 227037 variant_image 57410 0 V 0 D 0 0
45178 227038 variant_image 57411 0 V 0 D 0 0
45179 227039 variant_image 57412 0 V 0 D 0 0
45180 227040 variant_image 57413 0 V 0 D 0 0
45181 227041 variant_image 57414 0 V 0 D 0 0
45182 227042 variant_image 57415 0 V 0 D 0 0
45183 227043 variant_image 57416 0 V 0 D 0 0
45184 227044 variant_image 57417 0 V 0 D 0 0
45185 227045 variant_image 57418 0 V 0 D 0 0
45186 227046 variant_image 57419 0 V 0 D 0 0
45187 227047 variant_image 57420 0 V 0 D 0 0
45192 227053 variant_image 57425 0 V 0 D 0 0
45193 227054 variant_image 57426 0 V 0 D 0 0
46719 228556 variant_image 58952 0 V 0 D 0 0
46720 228557 variant_image 58953 0 V 0 D 0 0
46721 228558 variant_image 58954 0 V 0 D 0 0
46722 228559 variant_image 58955 0 V 0 D 0 0
46723 228560 variant_image 58956 0 V 0 D 0 0
46724 228561 variant_image 58957 0 V 0 D 0 0
46725 228563 variant_image 58958 0 V 0 D 0 0
46726 228564 variant_image 58959 0 V 0 D 0 0
46727 228565 variant_image 58960 0 V 0 D 0 0
46728 228566 variant_image 58961 0 V 0 D 0 0
46729 228567 variant_image 58962 0 V 0 D 0 0
46731 228569 variant_image 58964 0 V 0 D 0 0
46732 228570 variant_image 58965 0 V 0 D 0 0
46733 228571 variant_image 58966 0 V 0 D 0 0
46734 228572 variant_image 58967 0 V 0 D 0 0
46735 228573 variant_image 58968 0 V 0 D 0 0
46736 228574 variant_image 58969 0 V 0 D 0 0
46737 228575 variant_image 58970 0 V 0 D 0 0
46738 228576 variant_image 58971 0 V 0 D 0 0
46739 228577 variant_image 58972 0 V 0 D 0 0
46740 228578 variant_image 58973 0 V 0 D 0 0
46741 228579 variant_image 58974 0 V 0 D 0 0
46742 228580 variant_image 58975 0 V 0 D 0 0
46743 228581 variant_image 58976 0 V 0 D 0 0
46744 228582 variant_image 58977 0 V 0 D 0 0
46745 228583 variant_image 58978 0 V 0 D 0 0
46746 228584 variant_image 58979 0 V 0 D 0 0
46747 228585 variant_image 58980 0 V 0 D 0 0
46748 228586 variant_image 58981 0 V 0 D 0 0
46749 228587 variant_image 58982 0 V 0 D 0 0
46750 228588 variant_image 58983 0 V 0 D 0 0
46755 228594 variant_image 58988 0 V 0 D 0 0
46756 228595 variant_image 58989 0 V 0 D 0 0
46757 228596 variant_image 58990 0 V 0 D 0 0
46758 228597 variant_image 58991 0 V 0 D 0 0
46759 228598 variant_image 58992 0 V 0 D 0 0
46760 228599 variant_image 58993 0 V 0 D 0 0
46761 228600 variant_image 58994 0 V 0 D 0 0
46762 228601 variant_image 58995 0 V 0 D 0 0
46763 228602 variant_image 58996 0 V 0 D 0 0
46764 228603 variant_image 58997 0 V 0 D 0 0
46765 228604 variant_image 58998 0 V 0 D 0 0
46766 228605 variant_image 58999 0 V 0 D 0 0
46767 228606 variant_image 59000 0 V 0 D 0 0
46768 228607 variant_image 59001 0 V 0 D 0 0
46769 228608 variant_image 59002 0 V 0 D 0 0
46770 228609 variant_image 59003 0 V 0 D 0 0
46771 228610 variant_image 59004 0 V 0 D 0 0
46772 228611 variant_image 59005 0 V 0 D 0 0
46773 228612 variant_image 59006 0 V 0 D 0 0
46774 228613 variant_image 59007 0 V 0 D 0 0
46775 228614 variant_image 59008 0 V 0 D 0 0
46776 228615 variant_image 59009 0 V 0 D 0 0
46777 228616 variant_image 59010 0 V 0 D 0 0
46778 228617 variant_image 59011 0 V 0 D 0 0
46779 228618 variant_image 59012 0 V 0 D 0 0
46780 228619 variant_image 59013 0 V 0 D 0 0
46793 228633 variant_image 59026 0 V 0 D 0 0
46795 228635 variant_image 59028 0 V 0 D 0 0
46797 228637 variant_image 59030 0 V 0 D 0 0
46806 228646 variant_image 59039 0 V 0 D 0 0
46807 228647 variant_image 59040 0 V 0 D 0 0
46808 228648 variant_image 59041 0 V 0 D 0 0
49023 224595 variant_image 61256 0 V 0 D 0 0
49024 224596 variant_image 61257 0 V 0 D 0 0
49025 224597 variant_image 61258 0 V 0 D 0 0
49026 224598 variant_image 61259 0 V 0 D 0 0
49791 219239 variant_image 62024 0 V 0 D 0 0
59821 237074 variant_image 72054 0 V 0 D 0 0
59822 237075 variant_image 72055 0 V 0 D 0 0
59825 237078 variant_image 72058 0 V 0 D 0 0
59826 237079 variant_image 72059 0 V 0 D 0 0
59827 237080 variant_image 72060 0 V 0 D 0 0
59828 237081 variant_image 72061 0 V 0 D 0 0
59831 237084 variant_image 72064 0 V 0 D 0 0
59832 237085 variant_image 72065 0 V 0 D 0 0
70916 241381 variant_image 83149 0 V 0 D 0 0
70917 241382 variant_image 83150 0 V 0 D 0 0
70918 241383 variant_image 83151 0 V 0 D 0 0
70919 241384 variant_image 83152 0 V 0 D 0 0
70920 241385 variant_image 83153 0 V 0 D 0 0
71105 241555 variant_image 83338 0 V 0 D 0 0
71106 241556 variant_image 83339 0 V 0 D 0 0
71107 241557 variant_image 83340 0 V 0 D 0 0
71108 241558 variant_image 83341 0 V 0 D 0 0
71109 241559 variant_image 83342 0 V 0 D 0 0
71229 241675 variant_image 83462 0 V 0 D 0 0
71230 241676 variant_image 83463 0 V 0 D 0 0
71231 241677 variant_image 83464 0 V 0 D 0 0
71232 241678 variant_image 83465 0 V 0 D 0 0
71233 241679 variant_image 83466 0 V 0 D 0 0
71762 242199 variant_image 83995 0 V 0 D 0 0
71763 242200 variant_image 83996 0 V 0 D 0 0
71764 242201 variant_image 83997 0 V 0 D 0 0
71765 242202 variant_image 83998 0 V 0 D 0 0
72104 242509 variant_image 84337 0 V 0 D 0 0
72105 242510 variant_image 84338 0 V 0 D 0 0
72106 242511 variant_image 84339 0 V 0 D 0 0
72107 242512 variant_image 84340 0 V 0 D 0 0
72378 242769 variant_image 84611 0 V 0 D 0 0
72379 242770 variant_image 84612 0 V 0 D 0 0
72380 242771 variant_image 84613 0 V 0 D 0 0
72381 242772 variant_image 84614 0 V 0 D 0 0
72382 242773 variant_image 84615 0 V 0 D 0 0
72394 242785 variant_image 84627 0 V 0 D 0 0
72395 242786 variant_image 84628 0 V 0 D 0 0
72396 242787 variant_image 84629 0 V 0 D 0 0
72397 242788 variant_image 84630 0 V 0 D 0 0
72617 242973 variant_image 84850 0 V 0 D 0 0
72633 242989 variant_image 84866 0 V 0 D 0 0
72641 242997 variant_image 84874 0 V 0 D 0 0
72819 243103 variant_image 85052 0 V 0 D 0 0
72820 243104 variant_image 85053 0 V 0 D 0 0
72821 243105 variant_image 85054 0 V 0 D 0 0
72822 243106 variant_image 85055 0 V 0 D 0 0