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 (
    220137, 
    217978, 
    217979, 
    217980, 
    217981, 
    217982, 
    217983, 
    237042, 
    237043, 
    217984, 
    242635, 
    241100, 
    217985, 
    217986, 
    217987, 
    217988, 
    217989, 
    241101, 
    217990, 
    217991, 
    217992, 
    217993, 
    217994, 
    217995, 
    217996, 
    217997, 
    241102, 
    217998, 
    241103, 
    217999, 
    218000, 
    242636, 
    242637, 
    218001, 
    218002, 
    218003, 
    242638, 
    241104, 
    218008, 
    218009, 
    218010, 
    218011, 
    218012, 
    220318, 
    215376, 
    215377, 
    223067, 
    223065, 
    223066, 
    223099, 
    223068, 
    223069, 
    223070, 
    223071, 
    223072, 
    223073, 
    223093, 
    223074, 
    237172, 
    237173, 
    223075, 
    242860, 
    241110, 
    223076, 
    223077, 
    223078, 
    223079, 
    223080, 
    241111, 
    223081, 
    223082, 
    223083, 
    223084, 
    223085, 
    223086, 
    223087, 
    223088, 
    241112, 
    223089, 
    241113, 
    223090, 
    223091, 
    242861, 
    234295, 
    242862, 
    234296, 
    223092, 
    242863, 
    241114, 
    223097, 
    223098, 
    223134, 
    223104, 
    223105, 
    223106, 
    223107, 
    223108, 
    223128, 
    223109, 
    237174, 
    237175, 
    223110, 
    242864, 
    241115, 
    223111, 
    223112, 
    223113, 
    223114, 
    223115, 
    241116, 
    223116, 
    223117, 
    223118, 
    223119, 
    223120, 
    223121, 
    223122, 
    223123, 
    241117, 
    223124, 
    241118, 
    223125, 
    223126, 
    242865, 
    242866, 
    234297, 
    234298, 
    223127, 
    242867, 
    241119, 
    223132, 
    223133, 
    223142, 
    223139, 
    223140, 
    223141, 
    223146, 
    223143, 
    223144, 
    223145, 
    223150, 
    223147, 
    223148, 
    223149, 
    223153, 
    223151, 
    223152, 
    228071, 
    228069, 
    228070, 
    228102, 
    228072, 
    228073, 
    228074, 
    228075, 
    228076, 
    228077, 
    237170, 
    237171, 
    228078, 
    242721, 
    241120, 
    228079, 
    228080, 
    228081, 
    228082, 
    228083, 
    241121, 
    228084, 
    228085, 
    228086, 
    228087, 
    228088, 
    228089, 
    228090, 
    228091, 
    241122, 
    228092, 
    241123, 
    228093, 
    228094, 
    242722, 
    242723, 
    228095, 
    228096, 
    228097, 
    242724, 
    241124, 
    228175, 
    228176, 
    228177, 
    228215, 
    228208, 
    228209, 
    228210, 
    239529, 
    239530, 
    239523, 
    239531, 
    239524, 
    239532, 
    239525, 
    239533, 
    239526, 
    239534, 
    239527, 
    239535, 
    239528, 
    239536
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00310

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 (220137,217978,217979,217980,217981,217982,217983,237042,237043,217984,242635,241100,217985,217986,217987,217988,217989,241101,217990,217991,217992,217993,217994,217995,217996,217997,241102,217998,241103,217999,218000,242636,242637,218001,218002,218003,242638,241104,218008,218009,218010,218011,218012,220318,215376,215377,223067,223065,223066,223099,223068,223069,223070,223071,223072,223073,223093,223074,237172,237173,223075,242860,241110,223076,223077,223078,223079,223080,241111,223081,223082,223083,223084,223085,223086,223087,223088,241112,223089,241113,223090,223091,242861,234295,242862,234296,223092,242863,241114,223097,223098,223134,223104,223105,223106,223107,223108,223128,223109,237174,237175,223110,242864,241115,223111,223112,223113,223114,223115,241116,223116,223117,223118,223119,223120,223121,223122,223123,241117,223124,241118,223125,223126,242865,242866,234297,234298,223127,242867,241119,223132,223133,223142,223139,223140,223141,223146,223143,223144,223145,223150,223147,223148,223149,223153,223151,223152,228071,228069,228070,228102,228072,228073,228074,228075,228076,228077,237170,237171,228078,242721,241120,228079,228080,228081,228082,228083,241121,228084,228085,228086,228087,228088,228089,228090,228091,241122,228092,241123,228093,228094,242722,242723,228095,228096,228097,242724,241124,228175,228176,228177,228215,228208,228209,228210,239529,239530,239523,239531,239524,239532,239525,239533,239526,239534,239527,239535,239528,239536)"
        }
      }
    },
    "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
36374 217978 variant_image 48607 0 V 0 D 0 0
36375 217979 variant_image 48608 0 V 0 D 0 0
36376 217980 variant_image 48609 0 V 0 D 0 0
36377 217981 variant_image 48610 0 V 0 D 0 0
36378 217982 variant_image 48611 0 V 0 D 0 0
36379 217983 variant_image 48612 0 V 0 D 0 0
36380 217984 variant_image 48613 0 V 0 D 0 0
36381 217985 variant_image 48614 0 V 0 D 0 0
36382 217986 variant_image 48615 0 V 0 D 0 0
36383 217987 variant_image 48616 0 V 0 D 0 0
36384 217988 variant_image 48617 0 V 0 D 0 0
36385 217989 variant_image 48618 0 V 0 D 0 0
36386 217990 variant_image 48619 0 V 0 D 0 0
36387 217991 variant_image 48620 0 V 0 D 0 0
36388 217992 variant_image 48621 0 V 0 D 0 0
36389 217993 variant_image 48622 0 V 0 D 0 0
36390 217994 variant_image 48623 0 V 0 D 0 0
36391 217995 variant_image 48624 0 V 0 D 0 0
36392 217996 variant_image 48625 0 V 0 D 0 0
36393 217997 variant_image 48626 0 V 0 D 0 0
36394 217998 variant_image 48627 0 V 0 D 0 0
36395 217999 variant_image 48628 0 V 0 D 0 0
36396 218000 variant_image 48629 0 V 0 D 0 0
36397 218001 variant_image 48630 0 V 0 D 0 0
36398 218002 variant_image 48631 0 V 0 D 0 0
36399 218003 variant_image 48632 0 V 0 D 0 0
36404 218008 variant_image 48637 0 V 0 D 0 0
36405 218009 variant_image 48638 0 V 0 D 0 0
36406 218010 variant_image 48639 0 V 0 D 0 0
36407 218011 variant_image 48640 0 V 0 D 0 0
36408 218012 variant_image 48641 0 V 0 D 0 0
41342 223065 variant_image 53575 0 V 0 D 0 0
41343 223066 variant_image 53576 0 V 0 D 0 0
41344 223069 variant_image 53577 0 V 0 D 0 0
41345 223070 variant_image 53578 0 V 0 D 0 0
41346 223071 variant_image 53579 0 V 0 D 0 0
41347 223072 variant_image 53580 0 V 0 D 0 0
41348 223073 variant_image 53581 0 V 0 D 0 0
41349 223074 variant_image 53582 0 V 0 D 0 0
41350 223075 variant_image 53583 0 V 0 D 0 0
41351 223076 variant_image 53584 0 V 0 D 0 0
41352 223077 variant_image 53585 0 V 0 D 0 0
41353 223078 variant_image 53586 0 V 0 D 0 0
41354 223079 variant_image 53587 0 V 0 D 0 0
41355 223080 variant_image 53588 0 V 0 D 0 0
41356 223081 variant_image 53589 0 V 0 D 0 0
41357 223082 variant_image 53590 0 V 0 D 0 0
41358 223083 variant_image 53591 0 V 0 D 0 0
41359 223084 variant_image 53592 0 V 0 D 0 0
41360 223085 variant_image 53593 0 V 0 D 0 0
41361 223086 variant_image 53594 0 V 0 D 0 0
41362 223087 variant_image 53595 0 V 0 D 0 0
41363 223088 variant_image 53596 0 V 0 D 0 0
41364 223089 variant_image 53597 0 V 0 D 0 0
41365 223090 variant_image 53598 0 V 0 D 0 0
41366 223091 variant_image 53599 0 V 0 D 0 0
41367 223092 variant_image 53600 0 V 0 D 0 0
41368 223093 variant_image 53601 0 V 0 D 0 0
41372 223097 variant_image 53605 0 V 0 D 0 0
41373 223098 variant_image 53606 0 V 0 D 0 0
41378 223104 variant_image 53611 0 V 0 D 0 0
41379 223105 variant_image 53612 0 V 0 D 0 0
41380 223106 variant_image 53613 0 V 0 D 0 0
41381 223107 variant_image 53614 0 V 0 D 0 0
41382 223108 variant_image 53615 0 V 0 D 0 0
41383 223109 variant_image 53616 0 V 0 D 0 0
41384 223110 variant_image 53617 0 V 0 D 0 0
41385 223111 variant_image 53618 0 V 0 D 0 0
41386 223112 variant_image 53619 0 V 0 D 0 0
41387 223113 variant_image 53620 0 V 0 D 0 0
41388 223114 variant_image 53621 0 V 0 D 0 0
41389 223115 variant_image 53622 0 V 0 D 0 0
41390 223116 variant_image 53623 0 V 0 D 0 0
41391 223117 variant_image 53624 0 V 0 D 0 0
41392 223118 variant_image 53625 0 V 0 D 0 0
41393 223119 variant_image 53626 0 V 0 D 0 0
41394 223120 variant_image 53627 0 V 0 D 0 0
41395 223121 variant_image 53628 0 V 0 D 0 0
41396 223122 variant_image 53629 0 V 0 D 0 0
41397 223123 variant_image 53630 0 V 0 D 0 0
41398 223124 variant_image 53631 0 V 0 D 0 0
41399 223125 variant_image 53632 0 V 0 D 0 0
41400 223126 variant_image 53633 0 V 0 D 0 0
41401 223127 variant_image 53634 0 V 0 D 0 0
41402 223128 variant_image 53635 0 V 0 D 0 0
41406 223132 variant_image 53639 0 V 0 D 0 0
41407 223133 variant_image 53640 0 V 0 D 0 0
41412 223139 variant_image 53645 0 V 0 D 0 0
41413 223140 variant_image 53646 0 V 0 D 0 0
41414 223141 variant_image 53647 0 V 0 D 0 0
41415 223143 variant_image 53648 0 V 0 D 0 0
41416 223144 variant_image 53649 0 V 0 D 0 0
41417 223145 variant_image 53650 0 V 0 D 0 0
41418 223147 variant_image 53651 0 V 0 D 0 0
41419 223148 variant_image 53652 0 V 0 D 0 0
41420 223149 variant_image 53653 0 V 0 D 0 0
41421 223151 variant_image 53654 0 V 0 D 0 0
41422 223152 variant_image 53655 0 V 0 D 0 0
46126 228069 variant_image 58359 0 V 0 D 0 0
46127 228070 variant_image 58360 0 V 0 D 0 0
46232 228176 variant_image 58465 0 V 0 D 0 0
46233 228177 variant_image 58466 0 V 0 D 0 0
46263 228208 variant_image 58496 0 V 0 D 0 0
46264 228209 variant_image 58497 0 V 0 D 0 0
46265 228210 variant_image 58498 0 V 0 D 0 0
54883 234295 variant_image 67116 0 V 0 D 0 0
54884 234296 variant_image 67117 0 V 0 D 0 0
54885 234297 variant_image 67118 0 V 0 D 0 0
54886 234298 variant_image 67119 0 V 0 D 0 0
59789 237042 variant_image 72022 0 V 0 D 0 0
59790 237043 variant_image 72023 0 V 0 D 0 0
59919 237172 variant_image 72152 0 V 0 D 0 0
59920 237173 variant_image 72153 0 V 0 D 0 0
59921 237174 variant_image 72154 0 V 0 D 0 0
59922 237175 variant_image 72155 0 V 0 D 0 0
70635 241100 variant_image 82868 0 V 0 D 0 0
70636 241101 variant_image 82869 0 V 0 D 0 0
70637 241102 variant_image 82870 0 V 0 D 0 0
70638 241103 variant_image 82871 0 V 0 D 0 0
70639 241104 variant_image 82872 0 V 0 D 0 0
70645 241110 variant_image 82878 0 V 0 D 0 0
70646 241111 variant_image 82879 0 V 0 D 0 0
70647 241112 variant_image 82880 0 V 0 D 0 0
70648 241113 variant_image 82881 0 V 0 D 0 0
70649 241114 variant_image 82882 0 V 0 D 0 0
70650 241115 variant_image 82883 0 V 0 D 0 0
70651 241116 variant_image 82884 0 V 0 D 0 0
70652 241117 variant_image 82885 0 V 0 D 0 0
70653 241118 variant_image 82886 0 V 0 D 0 0
70654 241119 variant_image 82887 0 V 0 D 0 0
72245 242635 variant_image 84478 0 V 0 D 0 0
72246 242636 variant_image 84479 0 V 0 D 0 0
72247 242637 variant_image 84480 0 V 0 D 0 0
72248 242638 variant_image 84481 0 V 0 D 0 0
72469 242860 variant_image 84702 0 V 0 D 0 0
72470 242861 variant_image 84703 0 V 0 D 0 0
72471 242862 variant_image 84704 0 V 0 D 0 0
72472 242863 variant_image 84705 0 V 0 D 0 0
72473 242864 variant_image 84706 0 V 0 D 0 0
72474 242865 variant_image 84707 0 V 0 D 0 0
72475 242866 variant_image 84708 0 V 0 D 0 0
72476 242867 variant_image 84709 0 V 0 D 0 0
75611 242721 variant_image 87844 0 V 0 D 0 0
75612 242722 variant_image 87845 0 V 0 D 0 0
75613 242723 variant_image 87846 0 V 0 D 0 0
75614 242724 variant_image 87847 0 V 0 D 0 0
75615 228072 variant_image 87848 0 V 0 D 0 0
75616 228073 variant_image 87849 0 V 0 D 0 0
75617 228074 variant_image 87850 0 V 0 D 0 0
75618 228075 variant_image 87851 0 V 0 D 0 0
75619 228076 variant_image 87852 0 V 0 D 0 0
75620 228077 variant_image 87853 0 V 0 D 0 0
75621 237170 variant_image 87854 0 V 0 D 0 0
75622 237171 variant_image 87855 0 V 0 D 0 0
75623 228078 variant_image 87856 0 V 0 D 0 0
75624 241120 variant_image 87857 0 V 0 D 0 0
75625 228079 variant_image 87858 0 V 0 D 0 0
75626 228080 variant_image 87859 0 V 0 D 0 0
75627 228081 variant_image 87860 0 V 0 D 0 0
75628 228082 variant_image 87861 0 V 0 D 0 0
75629 228083 variant_image 87862 0 V 0 D 0 0
75630 241121 variant_image 87863 0 V 0 D 0 0
75631 228084 variant_image 87864 0 V 0 D 0 0
75632 228085 variant_image 87865 0 V 0 D 0 0
75633 228086 variant_image 87866 0 V 0 D 0 0
75634 228087 variant_image 87867 0 V 0 D 0 0
75635 228088 variant_image 87868 0 V 0 D 0 0
75636 228089 variant_image 87869 0 V 0 D 0 0
75637 228090 variant_image 87870 0 V 0 D 0 0
75638 228091 variant_image 87871 0 V 0 D 0 0
75639 241122 variant_image 87872 0 V 0 D 0 0
75640 228092 variant_image 87873 0 V 0 D 0 0
75641 241123 variant_image 87874 0 V 0 D 0 0
75642 228093 variant_image 87875 0 V 0 D 0 0
75643 228094 variant_image 87876 0 V 0 D 0 0
75644 228095 variant_image 87877 0 V 0 D 0 0
75645 228096 variant_image 87878 0 V 0 D 0 0
75646 228097 variant_image 87879 0 V 0 D 0 0
75647 241124 variant_image 87880 0 V 0 D 0 0