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 (
    219927, 
    219928, 
    219929, 
    220135, 
    244918, 
    244919, 
    244920, 
    244921, 
    244922, 
    244923, 
    244924, 
    244925, 
    217391, 
    217392, 
    217393, 
    217394, 
    217395, 
    217396, 
    236870, 
    236871, 
    217397, 
    245301, 
    241058, 
    219829, 
    217398, 
    217399, 
    217400, 
    217401, 
    241059, 
    217402, 
    217403, 
    217404, 
    217405, 
    217406, 
    217407, 
    217408, 
    217409, 
    241060, 
    217410, 
    241061, 
    217411, 
    217412, 
    245302, 
    245303, 
    225914, 
    217413, 
    217414, 
    245304, 
    241062, 
    217415, 
    217416, 
    217417, 
    217418, 
    217419, 
    220179, 
    219555, 
    219556, 
    219557, 
    219558, 
    219559, 
    219560, 
    219561, 
    219562, 
    219563, 
    219564, 
    219565, 
    219566, 
    219567, 
    220200, 
    219568, 
    244934, 
    244935, 
    244936, 
    244937, 
    244938, 
    244939, 
    244940, 
    244941, 
    220201, 
    219582, 
    219583, 
    219584, 
    219585, 
    219586, 
    219587, 
    219588, 
    219589, 
    236946, 
    236947, 
    219590, 
    245309, 
    241068, 
    219591, 
    219592, 
    219593, 
    219594, 
    219595, 
    241069, 
    219596, 
    219597, 
    219598, 
    219599, 
    219600, 
    219601, 
    219602, 
    219603, 
    241070, 
    219604, 
    241071, 
    219605, 
    219606, 
    245310, 
    245311, 
    225919, 
    219607, 
    219608, 
    245312, 
    219609, 
    241072, 
    219613, 
    219611, 
    219612, 
    219610, 
    220202, 
    219614, 
    219615, 
    219616, 
    219617, 
    219618, 
    219619, 
    219620, 
    241078, 
    241079, 
    219621, 
    245313, 
    241073, 
    219622, 
    219623, 
    219624, 
    219625, 
    219626, 
    241074, 
    219627, 
    219628, 
    219629, 
    219630, 
    219631, 
    219632, 
    219633, 
    219634, 
    241075, 
    219635, 
    241076, 
    219636, 
    219637, 
    245314, 
    245315, 
    219638, 
    219639, 
    245316, 
    241077, 
    219640, 
    219641, 
    219642, 
    219643, 
    219644, 
    220204, 
    219648, 
    219649, 
    219650, 
    220206, 
    219651, 
    219652, 
    219653, 
    220213, 
    219645, 
    219646, 
    219647, 
    220310, 
    219654, 
    219655, 
    220311, 
    219656, 
    219657, 
    220318, 
    215376, 
    215377, 
    220320, 
    219237, 
    219238, 
    219239, 
    242973, 
    219241, 
    219249, 
    219250, 
    219252, 
    219253, 
    219254, 
    219255, 
    219256, 
    219257, 
    219258, 
    219259, 
    243047, 
    243043, 
    243044, 
    243045, 
    243046, 
    243048
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00302

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": 209,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (219927,219928,219929,220135,244918,244919,244920,244921,244922,244923,244924,244925,217391,217392,217393,217394,217395,217396,236870,236871,217397,245301,241058,219829,217398,217399,217400,217401,241059,217402,217403,217404,217405,217406,217407,217408,217409,241060,217410,241061,217411,217412,245302,245303,225914,217413,217414,245304,241062,217415,217416,217417,217418,217419,220179,219555,219556,219557,219558,219559,219560,219561,219562,219563,219564,219565,219566,219567,220200,219568,244934,244935,244936,244937,244938,244939,244940,244941,220201,219582,219583,219584,219585,219586,219587,219588,219589,236946,236947,219590,245309,241068,219591,219592,219593,219594,219595,241069,219596,219597,219598,219599,219600,219601,219602,219603,241070,219604,241071,219605,219606,245310,245311,225919,219607,219608,245312,219609,241072,219613,219611,219612,219610,220202,219614,219615,219616,219617,219618,219619,219620,241078,241079,219621,245313,241073,219622,219623,219624,219625,219626,241074,219627,219628,219629,219630,219631,219632,219633,219634,241075,219635,241076,219636,219637,245314,245315,219638,219639,245316,241077,219640,219641,219642,219643,219644,220204,219648,219649,219650,220206,219651,219652,219653,220213,219645,219646,219647,220310,219654,219655,220311,219656,219657,220318,215376,215377,220320,219237,219238,219239,242973,219241,219249,219250,219252,219253,219254,219255,219256,219257,219258,219259,243047,243043,243044,243045,243046,243048)"
        }
      }
    },
    "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
33339 215376 variant_image 45572 0 V 0 D 0 0
33340 215377 variant_image 45573 0 V 0 D 0 0
35604 217391 variant_image 47837 0 V 0 D 0 0
35605 217392 variant_image 47838 0 V 0 D 0 0
35606 217393 variant_image 47839 0 V 0 D 0 0
35607 217394 variant_image 47840 0 V 0 D 0 0
35608 217395 variant_image 47841 0 V 0 D 0 0
35609 217396 variant_image 47842 0 V 0 D 0 0
35610 217397 variant_image 47843 0 V 0 D 0 0
35611 217398 variant_image 47844 0 V 0 D 0 0
35612 217399 variant_image 47845 0 V 0 D 0 0
35613 217401 variant_image 47846 0 V 0 D 0 0
35614 217402 variant_image 47847 0 V 0 D 0 0
35615 217403 variant_image 47848 0 V 0 D 0 0
35616 217404 variant_image 47849 0 V 0 D 0 0
35617 217405 variant_image 47850 0 V 0 D 0 0
35618 217406 variant_image 47851 0 V 0 D 0 0
35619 217407 variant_image 47852 0 V 0 D 0 0
35620 217408 variant_image 47853 0 V 0 D 0 0
35621 217409 variant_image 47854 0 V 0 D 0 0
35622 217410 variant_image 47855 0 V 0 D 0 0
35623 217411 variant_image 47856 0 V 0 D 0 0
35624 217412 variant_image 47857 0 V 0 D 0 0
35625 217413 variant_image 47858 0 V 0 D 0 0
35626 217414 variant_image 47859 0 V 0 D 0 0
35627 217415 variant_image 47860 0 V 0 D 0 0
35628 217416 variant_image 47861 0 V 0 D 0 0
35629 217417 variant_image 47862 0 V 0 D 0 0
35630 217418 variant_image 47863 0 V 0 D 0 0
35631 217419 variant_image 47864 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
38230 219583 variant_image 50463 0 V 0 D 0 0
38231 219584 variant_image 50464 0 V 0 D 0 0
38232 219585 variant_image 50465 0 V 0 D 0 0
38233 219586 variant_image 50466 0 V 0 D 0 0
38234 219587 variant_image 50467 0 V 0 D 0 0
38235 219588 variant_image 50468 0 V 0 D 0 0
38236 219589 variant_image 50469 0 V 0 D 0 0
38237 219590 variant_image 50470 0 V 0 D 0 0
38238 219591 variant_image 50471 0 V 0 D 0 0
38239 219592 variant_image 50472 0 V 0 D 0 0
38240 219593 variant_image 50473 0 V 0 D 0 0
38241 219594 variant_image 50474 0 V 0 D 0 0
38242 219595 variant_image 50475 0 V 0 D 0 0
38243 219596 variant_image 50476 0 V 0 D 0 0
38244 219597 variant_image 50477 0 V 0 D 0 0
38245 219598 variant_image 50478 0 V 0 D 0 0
38246 219599 variant_image 50479 0 V 0 D 0 0
38247 219600 variant_image 50480 0 V 0 D 0 0
38248 219601 variant_image 50481 0 V 0 D 0 0
38249 219602 variant_image 50482 0 V 0 D 0 0
38250 219603 variant_image 50483 0 V 0 D 0 0
38251 219604 variant_image 50484 0 V 0 D 0 0
38252 219605 variant_image 50485 0 V 0 D 0 0
38253 219606 variant_image 50486 0 V 0 D 0 0
38254 219607 variant_image 50487 0 V 0 D 0 0
38255 219608 variant_image 50488 0 V 0 D 0 0
38256 219609 variant_image 50489 0 V 0 D 0 0
38257 219611 variant_image 50490 0 V 0 D 0 0
38258 219612 variant_image 50491 0 V 0 D 0 0
38259 219610 variant_image 50492 0 V 0 D 0 0
38260 219613 variant_image 50493 0 V 0 D 0 0
38261 219614 variant_image 50494 0 V 0 D 0 0
38262 219615 variant_image 50495 0 V 0 D 0 0
38263 219616 variant_image 50496 0 V 0 D 0 0
38264 219617 variant_image 50497 0 V 0 D 0 0
38265 219618 variant_image 50498 0 V 0 D 0 0
38266 219619 variant_image 50499 0 V 0 D 0 0
38267 219620 variant_image 50500 0 V 0 D 0 0
38268 219621 variant_image 50501 0 V 0 D 0 0
38269 219622 variant_image 50502 0 V 0 D 0 0
38270 219623 variant_image 50503 0 V 0 D 0 0
38271 219624 variant_image 50504 0 V 0 D 0 0
38272 219625 variant_image 50505 0 V 0 D 0 0
38273 219626 variant_image 50506 0 V 0 D 0 0
38274 219627 variant_image 50507 0 V 0 D 0 0
38275 219628 variant_image 50508 0 V 0 D 0 0
38276 219629 variant_image 50509 0 V 0 D 0 0
38277 219630 variant_image 50510 0 V 0 D 0 0
38278 219631 variant_image 50511 0 V 0 D 0 0
38279 219632 variant_image 50512 0 V 0 D 0 0
38280 219633 variant_image 50513 0 V 0 D 0 0
38281 219634 variant_image 50514 0 V 0 D 0 0
38282 219635 variant_image 50515 0 V 0 D 0 0
38283 219636 variant_image 50516 0 V 0 D 0 0
38284 219637 variant_image 50517 0 V 0 D 0 0
38285 219638 variant_image 50518 0 V 0 D 0 0
38286 219639 variant_image 50519 0 V 0 D 0 0
38287 219640 variant_image 50520 0 V 0 D 0 0
38288 219641 variant_image 50521 0 V 0 D 0 0
38289 219642 variant_image 50522 0 V 0 D 0 0
38290 219643 variant_image 50523 0 V 0 D 0 0
38291 219644 variant_image 50524 0 V 0 D 0 0
38292 219645 variant_image 50525 0 V 0 D 0 0
38293 219646 variant_image 50526 0 V 0 D 0 0
38294 219647 variant_image 50527 0 V 0 D 0 0
38295 219648 variant_image 50528 0 V 0 D 0 0
38296 219649 variant_image 50529 0 V 0 D 0 0
38297 219650 variant_image 50530 0 V 0 D 0 0
38298 219651 variant_image 50531 0 V 0 D 0 0
38299 219652 variant_image 50532 0 V 0 D 0 0
38300 219653 variant_image 50533 0 V 0 D 0 0
38301 219654 variant_image 50534 0 V 0 D 0 0
38302 219655 variant_image 50535 0 V 0 D 0 0
38303 219656 variant_image 50536 0 V 0 D 0 0
38304 219657 variant_image 50537 0 V 0 D 0 0
38476 217400 variant_image 50709 0 V 0 D 0 0
38489 219829 variant_image 50722 0 V 0 D 0 0
38738 219237 variant_image 50971 0 V 0 D 0 0
44124 225914 variant_image 56357 0 V 0 D 0 0
44129 225919 variant_image 56362 0 V 0 D 0 0
49791 219239 variant_image 62024 0 V 0 D 0 0
59612 236870 variant_image 71845 0 V 0 D 0 0
59613 236871 variant_image 71846 0 V 0 D 0 0
59689 236946 variant_image 71922 0 V 0 D 0 0
59690 236947 variant_image 71923 0 V 0 D 0 0
70593 241058 variant_image 82826 0 V 0 D 0 0
70594 241059 variant_image 82827 0 V 0 D 0 0
70595 241060 variant_image 82828 0 V 0 D 0 0
70596 241061 variant_image 82829 0 V 0 D 0 0
70597 241062 variant_image 82830 0 V 0 D 0 0
70603 241068 variant_image 82836 0 V 0 D 0 0
70604 241069 variant_image 82837 0 V 0 D 0 0
70605 241070 variant_image 82838 0 V 0 D 0 0
70606 241071 variant_image 82839 0 V 0 D 0 0
70607 241072 variant_image 82840 0 V 0 D 0 0
70608 241073 variant_image 82841 0 V 0 D 0 0
70609 241074 variant_image 82842 0 V 0 D 0 0
70610 241075 variant_image 82843 0 V 0 D 0 0
70611 241076 variant_image 82844 0 V 0 D 0 0
70612 241077 variant_image 82845 0 V 0 D 0 0
70613 241078 variant_image 82846 0 V 0 D 0 0
70614 241079 variant_image 82847 0 V 0 D 0 0
72617 242973 variant_image 84850 0 V 0 D 0 0
72700 243043 variant_image 84933 0 V 0 D 0 0
72701 243044 variant_image 84934 0 V 0 D 0 0
72702 243045 variant_image 84935 0 V 0 D 0 0
72703 243046 variant_image 84936 0 V 0 D 0 0
74710 244918 variant_image 86943 0 V 0 D 0 0
74711 244919 variant_image 86944 0 V 0 D 0 0
74712 244920 variant_image 86945 0 V 0 D 0 0
74713 244921 variant_image 86946 0 V 0 D 0 0
74714 244922 variant_image 86947 0 V 0 D 0 0
74715 244923 variant_image 86948 0 V 0 D 0 0
74716 244924 variant_image 86949 0 V 0 D 0 0
74717 244925 variant_image 86950 0 V 0 D 0 0
74726 244934 variant_image 86959 0 V 0 D 0 0
74727 244935 variant_image 86960 0 V 0 D 0 0
74728 244936 variant_image 86961 0 V 0 D 0 0
74729 244937 variant_image 86962 0 V 0 D 0 0
74730 244938 variant_image 86963 0 V 0 D 0 0
74731 244939 variant_image 86964 0 V 0 D 0 0
74732 244940 variant_image 86965 0 V 0 D 0 0
74733 244941 variant_image 86966 0 V 0 D 0 0
75103 245301 variant_image 87336 0 V 0 D 0 0
75104 245302 variant_image 87337 0 V 0 D 0 0
75105 245303 variant_image 87338 0 V 0 D 0 0
75106 245304 variant_image 87339 0 V 0 D 0 0
75113 245309 variant_image 87346 0 V 0 D 0 0
75114 245310 variant_image 87347 0 V 0 D 0 0
75115 245311 variant_image 87348 0 V 0 D 0 0
75116 245312 variant_image 87349 0 V 0 D 0 0
75117 245313 variant_image 87350 0 V 0 D 0 0
75118 245314 variant_image 87351 0 V 0 D 0 0
75119 245315 variant_image 87352 0 V 0 D 0 0
75120 245316 variant_image 87353 0 V 0 D 0 0