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, 
    220320, 
    219237, 
    219238, 
    219239, 
    242973, 
    219241, 
    219249, 
    219250, 
    219252, 
    219253, 
    219254, 
    219255, 
    219256, 
    219257, 
    219258, 
    219259, 
    224299, 
    224269, 
    224270, 
    224271, 
    224272, 
    224294, 
    224287, 
    237092, 
    237093, 
    224273, 
    242692, 
    224274, 
    224275, 
    224276, 
    224277, 
    224278, 
    242693, 
    224279, 
    224280, 
    224281, 
    224282, 
    224283, 
    224284, 
    224285, 
    224286, 
    242694, 
    224288, 
    242695, 
    224289, 
    224290, 
    224291, 
    224292, 
    224293, 
    242696, 
    224295, 
    224296, 
    224297, 
    224298, 
    224331, 
    224332, 
    224333, 
    224334, 
    224335, 
    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, 
    224568, 
    224538, 
    224539, 
    224540, 
    224541, 
    224563, 
    224556, 
    237090, 
    237091, 
    224542, 
    242903, 
    224543, 
    224544, 
    224545, 
    224546, 
    224547, 
    242904, 
    224548, 
    224549, 
    224550, 
    224551, 
    224552, 
    224553, 
    224554, 
    224555, 
    242905, 
    224557, 
    242906, 
    224558, 
    224559, 
    224560, 
    224561, 
    224562, 
    242907, 
    224564, 
    224565, 
    224566, 
    224567, 
    224594, 
    224569, 
    224570, 
    224571, 
    242987, 
    224573, 
    224581, 
    224582, 
    224583, 
    224584, 
    224585, 
    224586, 
    224587, 
    224588, 
    224589, 
    224590, 
    224591, 
    224599, 
    224595, 
    224596, 
    224597, 
    224598
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00225

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": 178,
          "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,220320,219237,219238,219239,242973,219241,219249,219250,219252,219253,219254,219255,219256,219257,219258,219259,224299,224269,224270,224271,224272,224294,224287,237092,237093,224273,242692,224274,224275,224276,224277,224278,242693,224279,224280,224281,224282,224283,224284,224285,224286,242694,224288,242695,224289,224290,224291,224292,224293,242696,224295,224296,224297,224298,224331,224332,224333,224334,224335,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,224568,224538,224539,224540,224541,224563,224556,237090,237091,224542,242903,224543,224544,224545,224546,224547,242904,224548,224549,224550,224551,224552,224553,224554,224555,242905,224557,242906,224558,224559,224560,224561,224562,242907,224564,224565,224566,224567,224594,224569,224570,224571,242987,224573,224581,224582,224583,224584,224585,224586,224587,224588,224589,224590,224591,224599,224595,224596,224597,224598)"
        }
      }
    },
    "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
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
38738 219237 variant_image 50971 0 V 0 D 0 0
42578 224269 variant_image 54811 0 V 0 D 0 0
42579 224270 variant_image 54812 0 V 0 D 0 0
42580 224271 variant_image 54813 0 V 0 D 0 0
42581 224272 variant_image 54814 0 V 0 D 0 0
42582 224273 variant_image 54815 0 V 0 D 0 0
42583 224274 variant_image 54816 0 V 0 D 0 0
42584 224275 variant_image 54817 0 V 0 D 0 0
42585 224276 variant_image 54818 0 V 0 D 0 0
42586 224277 variant_image 54819 0 V 0 D 0 0
42587 224278 variant_image 54820 0 V 0 D 0 0
42588 224279 variant_image 54821 0 V 0 D 0 0
42589 224280 variant_image 54822 0 V 0 D 0 0
42590 224281 variant_image 54823 0 V 0 D 0 0
42591 224282 variant_image 54824 0 V 0 D 0 0
42592 224283 variant_image 54825 0 V 0 D 0 0
42593 224284 variant_image 54826 0 V 0 D 0 0
42594 224285 variant_image 54827 0 V 0 D 0 0
42595 224286 variant_image 54828 0 V 0 D 0 0
42596 224287 variant_image 54829 0 V 0 D 0 0
42597 224288 variant_image 54830 0 V 0 D 0 0
42598 224289 variant_image 54831 0 V 0 D 0 0
42599 224290 variant_image 54832 0 V 0 D 0 0
42600 224291 variant_image 54833 0 V 0 D 0 0
42601 224292 variant_image 54834 0 V 0 D 0 0
42602 224293 variant_image 54835 0 V 0 D 0 0
42603 224294 variant_image 54836 0 V 0 D 0 0
42604 224295 variant_image 54837 0 V 0 D 0 0
42605 224296 variant_image 54838 0 V 0 D 0 0
42606 224297 variant_image 54839 0 V 0 D 0 0
42607 224298 variant_image 54840 0 V 0 D 0 0
42638 224331 variant_image 54871 0 V 0 D 0 0
42639 224332 variant_image 54872 0 V 0 D 0 0
42640 224333 variant_image 54873 0 V 0 D 0 0
42641 224334 variant_image 54874 0 V 0 D 0 0
42642 224335 variant_image 54875 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
42832 224538 variant_image 55065 0 V 0 D 0 0
42833 224539 variant_image 55066 0 V 0 D 0 0
42834 224540 variant_image 55067 0 V 0 D 0 0
42835 224541 variant_image 55068 0 V 0 D 0 0
42836 224542 variant_image 55069 0 V 0 D 0 0
42837 224543 variant_image 55070 0 V 0 D 0 0
42838 224544 variant_image 55071 0 V 0 D 0 0
42839 224545 variant_image 55072 0 V 0 D 0 0
42840 224546 variant_image 55073 0 V 0 D 0 0
42841 224547 variant_image 55074 0 V 0 D 0 0
42842 224548 variant_image 55075 0 V 0 D 0 0
42843 224549 variant_image 55076 0 V 0 D 0 0
42844 224550 variant_image 55077 0 V 0 D 0 0
42845 224551 variant_image 55078 0 V 0 D 0 0
42846 224552 variant_image 55079 0 V 0 D 0 0
42847 224553 variant_image 55080 0 V 0 D 0 0
42848 224554 variant_image 55081 0 V 0 D 0 0
42849 224555 variant_image 55082 0 V 0 D 0 0
42850 224556 variant_image 55083 0 V 0 D 0 0
42851 224557 variant_image 55084 0 V 0 D 0 0
42852 224558 variant_image 55085 0 V 0 D 0 0
42853 224559 variant_image 55086 0 V 0 D 0 0
42854 224560 variant_image 55087 0 V 0 D 0 0
42855 224561 variant_image 55088 0 V 0 D 0 0
42856 224562 variant_image 55089 0 V 0 D 0 0
42857 224563 variant_image 55090 0 V 0 D 0 0
42858 224564 variant_image 55091 0 V 0 D 0 0
42859 224565 variant_image 55092 0 V 0 D 0 0
42860 224566 variant_image 55093 0 V 0 D 0 0
42861 224567 variant_image 55094 0 V 0 D 0 0
42862 224569 variant_image 55095 0 V 0 D 0 0
42863 224570 variant_image 55096 0 V 0 D 0 0
42864 224571 variant_image 55097 0 V 0 D 0 0
42866 224573 variant_image 55099 0 V 0 D 0 0
42874 224581 variant_image 55107 0 V 0 D 0 0
42875 224582 variant_image 55108 0 V 0 D 0 0
42876 224583 variant_image 55109 0 V 0 D 0 0
42877 224584 variant_image 55110 0 V 0 D 0 0
42878 224585 variant_image 55111 0 V 0 D 0 0
42879 224586 variant_image 55112 0 V 0 D 0 0
42880 224587 variant_image 55113 0 V 0 D 0 0
42881 224588 variant_image 55114 0 V 0 D 0 0
42882 224589 variant_image 55115 0 V 0 D 0 0
42883 224590 variant_image 55116 0 V 0 D 0 0
42884 224591 variant_image 55117 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
59827 237080 variant_image 72060 0 V 0 D 0 0
59828 237081 variant_image 72061 0 V 0 D 0 0
59837 237090 variant_image 72070 0 V 0 D 0 0
59838 237091 variant_image 72071 0 V 0 D 0 0
59839 237092 variant_image 72072 0 V 0 D 0 0
59840 237093 variant_image 72073 0 V 0 D 0 0
72301 242692 variant_image 84534 0 V 0 D 0 0
72302 242693 variant_image 84535 0 V 0 D 0 0
72303 242694 variant_image 84536 0 V 0 D 0 0
72304 242695 variant_image 84537 0 V 0 D 0 0
72305 242696 variant_image 84538 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
72512 242903 variant_image 84745 0 V 0 D 0 0
72513 242904 variant_image 84746 0 V 0 D 0 0
72514 242905 variant_image 84747 0 V 0 D 0 0
72515 242906 variant_image 84748 0 V 0 D 0 0
72516 242907 variant_image 84749 0 V 0 D 0 0
72617 242973 variant_image 84850 0 V 0 D 0 0
72631 242987 variant_image 84864 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