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 (
    220144, 
    215513, 
    215516, 
    220173, 
    215556, 
    215557, 
    215558, 
    215559, 
    215560, 
    215561, 
    215562, 
    215563, 
    215564, 
    215565, 
    215566, 
    215567, 
    215568, 
    215569, 
    243103, 
    243104, 
    243105, 
    243106, 
    220318, 
    215376, 
    215377, 
    226326, 
    226327, 
    226328, 
    226329, 
    226330, 
    226331, 
    226332, 
    226333, 
    226434, 
    226438, 
    226435, 
    226436, 
    226437, 
    226439, 
    226443, 
    226440, 
    226441, 
    226442, 
    226444, 
    226448, 
    226445, 
    226446, 
    226447, 
    226449, 
    226453, 
    226450, 
    226451, 
    226452, 
    226485, 
    226455, 
    226457, 
    226462, 
    226481, 
    244281, 
    226465, 
    226466, 
    244282, 
    239948, 
    226470, 
    226472, 
    226474, 
    226477, 
    226478, 
    226483, 
    226576, 
    226546, 
    226547, 
    226548, 
    226549, 
    226571, 
    226564, 
    237098, 
    237099, 
    226550, 
    241305, 
    226551, 
    226552, 
    226553, 
    226554, 
    226555, 
    241306, 
    226556, 
    226557, 
    226558, 
    226559, 
    226560, 
    226561, 
    226562, 
    226563, 
    241307, 
    226565, 
    241308, 
    226566, 
    226567, 
    226568, 
    226569, 
    226570, 
    241309, 
    242517, 
    242518, 
    242519, 
    242520, 
    229781, 
    229782, 
    229783, 
    229784, 
    229785, 
    226770, 
    226771, 
    226740, 
    226741, 
    226742, 
    226743, 
    226765, 
    226758, 
    237100, 
    237101, 
    226744, 
    241330, 
    226745, 
    226746, 
    226747, 
    226748, 
    226749, 
    241331, 
    226750, 
    226751, 
    226752, 
    226753, 
    226754, 
    226755, 
    226756, 
    226757, 
    241332, 
    226759, 
    241333, 
    226760, 
    226761, 
    226762, 
    226763, 
    226764, 
    241334, 
    242537, 
    242538, 
    242539, 
    242540
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00207

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": 151,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (220144,215513,215516,220173,215556,215557,215558,215559,215560,215561,215562,215563,215564,215565,215566,215567,215568,215569,243103,243104,243105,243106,220318,215376,215377,226326,226327,226328,226329,226330,226331,226332,226333,226434,226438,226435,226436,226437,226439,226443,226440,226441,226442,226444,226448,226445,226446,226447,226449,226453,226450,226451,226452,226485,226455,226457,226462,226481,244281,226465,226466,244282,239948,226470,226472,226474,226477,226478,226483,226576,226546,226547,226548,226549,226571,226564,237098,237099,226550,241305,226551,226552,226553,226554,226555,241306,226556,226557,226558,226559,226560,226561,226562,226563,241307,226565,241308,226566,226567,226568,226569,226570,241309,242517,242518,242519,242520,229781,229782,229783,229784,229785,226770,226771,226740,226741,226742,226743,226765,226758,237100,237101,226744,241330,226745,226746,226747,226748,226749,241331,226750,226751,226752,226753,226754,226755,226756,226757,241332,226759,241333,226760,226761,226762,226763,226764,241334,242537,242538,242539,242540)"
        }
      }
    },
    "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
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
44525 226327 variant_image 56758 0 V 0 D 0 0
44526 226328 variant_image 56759 0 V 0 D 0 0
44527 226329 variant_image 56760 0 V 0 D 0 0
44528 226330 variant_image 56761 0 V 0 D 0 0
44622 226435 variant_image 56855 0 V 0 D 0 0
44623 226436 variant_image 56856 0 V 0 D 0 0
44624 226437 variant_image 56857 0 V 0 D 0 0
44625 226438 variant_image 56858 0 V 0 D 0 0
44626 226440 variant_image 56859 0 V 0 D 0 0
44627 226441 variant_image 56860 0 V 0 D 0 0
44628 226442 variant_image 56861 0 V 0 D 0 0
44629 226443 variant_image 56862 0 V 0 D 0 0
44630 226445 variant_image 56863 0 V 0 D 0 0
44631 226446 variant_image 56864 0 V 0 D 0 0
44632 226447 variant_image 56865 0 V 0 D 0 0
44633 226448 variant_image 56866 0 V 0 D 0 0
44634 226450 variant_image 56867 0 V 0 D 0 0
44635 226451 variant_image 56868 0 V 0 D 0 0
44636 226452 variant_image 56869 0 V 0 D 0 0
44637 226453 variant_image 56870 0 V 0 D 0 0
44638 226455 variant_image 56871 0 V 0 D 0 0
44640 226457 variant_image 56873 0 V 0 D 0 0
44645 226462 variant_image 56878 0 V 0 D 0 0
44648 226465 variant_image 56881 0 V 0 D 0 0
44649 226466 variant_image 56882 0 V 0 D 0 0
44653 226470 variant_image 56886 0 V 0 D 0 0
44655 226472 variant_image 56888 0 V 0 D 0 0
44657 226474 variant_image 56890 0 V 0 D 0 0
44660 226477 variant_image 56893 0 V 0 D 0 0
44661 226478 variant_image 56894 0 V 0 D 0 0
44664 226481 variant_image 56897 0 V 0 D 0 0
44666 226483 variant_image 56899 0 V 0 D 0 0
44720 226546 variant_image 56953 0 V 0 D 0 0
44721 226547 variant_image 56954 0 V 0 D 0 0
44722 226548 variant_image 56955 0 V 0 D 0 0
44723 226549 variant_image 56956 0 V 0 D 0 0
44724 226550 variant_image 56957 0 V 0 D 0 0
44725 226551 variant_image 56958 0 V 0 D 0 0
44726 226552 variant_image 56959 0 V 0 D 0 0
44727 226553 variant_image 56960 0 V 0 D 0 0
44728 226554 variant_image 56961 0 V 0 D 0 0
44729 226555 variant_image 56962 0 V 0 D 0 0
44730 226556 variant_image 56963 0 V 0 D 0 0
44731 226557 variant_image 56964 0 V 0 D 0 0
44732 226558 variant_image 56965 0 V 0 D 0 0
44733 226559 variant_image 56966 0 V 0 D 0 0
44734 226560 variant_image 56967 0 V 0 D 0 0
44735 226561 variant_image 56968 0 V 0 D 0 0
44736 226562 variant_image 56969 0 V 0 D 0 0
44737 226563 variant_image 56970 0 V 0 D 0 0
44738 226564 variant_image 56971 0 V 0 D 0 0
44739 226565 variant_image 56972 0 V 0 D 0 0
44740 226566 variant_image 56973 0 V 0 D 0 0
44741 226567 variant_image 56974 0 V 0 D 0 0
44742 226568 variant_image 56975 0 V 0 D 0 0
44743 226569 variant_image 56976 0 V 0 D 0 0
44744 226570 variant_image 56977 0 V 0 D 0 0
44745 226571 variant_image 56978 0 V 0 D 0 0
44905 226740 variant_image 57138 0 V 0 D 0 0
44906 226741 variant_image 57139 0 V 0 D 0 0
44907 226742 variant_image 57140 0 V 0 D 0 0
44908 226743 variant_image 57141 0 V 0 D 0 0
44909 226744 variant_image 57142 0 V 0 D 0 0
44910 226745 variant_image 57143 0 V 0 D 0 0
44911 226746 variant_image 57144 0 V 0 D 0 0
44912 226747 variant_image 57145 0 V 0 D 0 0
44913 226748 variant_image 57146 0 V 0 D 0 0
44914 226749 variant_image 57147 0 V 0 D 0 0
44915 226750 variant_image 57148 0 V 0 D 0 0
44916 226751 variant_image 57149 0 V 0 D 0 0
44917 226752 variant_image 57150 0 V 0 D 0 0
44918 226753 variant_image 57151 0 V 0 D 0 0
44919 226754 variant_image 57152 0 V 0 D 0 0
44920 226755 variant_image 57153 0 V 0 D 0 0
44921 226756 variant_image 57154 0 V 0 D 0 0
44922 226757 variant_image 57155 0 V 0 D 0 0
44923 226758 variant_image 57156 0 V 0 D 0 0
44924 226759 variant_image 57157 0 V 0 D 0 0
44925 226760 variant_image 57158 0 V 0 D 0 0
44926 226761 variant_image 57159 0 V 0 D 0 0
44927 226762 variant_image 57160 0 V 0 D 0 0
44928 226763 variant_image 57161 0 V 0 D 0 0
44929 226764 variant_image 57162 0 V 0 D 0 0
44930 226765 variant_image 57163 0 V 0 D 0 0
48334 229781 variant_image 60567 0 V 0 D 0 0
48335 229782 variant_image 60568 0 V 0 D 0 0
48336 229783 variant_image 60569 0 V 0 D 0 0
48337 229784 variant_image 60570 0 V 0 D 0 0
48338 229785 variant_image 60571 0 V 0 D 0 0
59845 237098 variant_image 72078 0 V 0 D 0 0
59846 237099 variant_image 72079 0 V 0 D 0 0
59847 237100 variant_image 72080 0 V 0 D 0 0
59848 237101 variant_image 72081 0 V 0 D 0 0
68285 239948 variant_image 80518 0 V 0 D 0 0
70840 241305 variant_image 83073 0 V 0 D 0 0
70841 241306 variant_image 83074 0 V 0 D 0 0
70842 241307 variant_image 83075 0 V 0 D 0 0
70843 241308 variant_image 83076 0 V 0 D 0 0
70844 241309 variant_image 83077 0 V 0 D 0 0
70865 241330 variant_image 83098 0 V 0 D 0 0
70866 241331 variant_image 83099 0 V 0 D 0 0
70867 241332 variant_image 83100 0 V 0 D 0 0
70868 241333 variant_image 83101 0 V 0 D 0 0
70869 241334 variant_image 83102 0 V 0 D 0 0
72112 242517 variant_image 84345 0 V 0 D 0 0
72113 242518 variant_image 84346 0 V 0 D 0 0
72114 242519 variant_image 84347 0 V 0 D 0 0
72115 242520 variant_image 84348 0 V 0 D 0 0
72132 242537 variant_image 84365 0 V 0 D 0 0
72133 242538 variant_image 84366 0 V 0 D 0 0
72134 242539 variant_image 84367 0 V 0 D 0 0
72135 242540 variant_image 84368 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
74008 244281 variant_image 86241 0 V 0 D 0 0
74009 244282 variant_image 86242 0 V 0 D 0 0