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 (
    220318, 
    215376, 
    215377, 
    227161, 
    227152, 
    227153, 
    227154, 
    227191, 
    227193, 
    227192, 
    227194, 
    227195, 
    227196, 
    227197, 
    227233, 
    227198, 
    227199, 
    227200, 
    227201, 
    227202, 
    227203, 
    237054, 
    237055, 
    227204, 
    242736, 
    241974, 
    227205, 
    227206, 
    227207, 
    227208, 
    227209, 
    241975, 
    227210, 
    227211, 
    227212, 
    227213, 
    227214, 
    227215, 
    227216, 
    227217, 
    241976, 
    227218, 
    241977, 
    227219, 
    227220, 
    242737, 
    242738, 
    227221, 
    227222, 
    227223, 
    242739, 
    241978, 
    227228, 
    227229, 
    227230, 
    227231, 
    227232, 
    227344, 
    227345, 
    227346, 
    227347, 
    227348, 
    227349, 
    227359, 
    227360, 
    227361, 
    227392, 
    227362, 
    227363, 
    227364, 
    227365, 
    227366, 
    227367, 
    237060, 
    237061, 
    227368, 
    242744, 
    242009, 
    227369, 
    227370, 
    227371, 
    227372, 
    227373, 
    242010, 
    227374, 
    227375, 
    227376, 
    227377, 
    227378, 
    227379, 
    227380, 
    227381, 
    242011, 
    227382, 
    242012, 
    227383, 
    227384, 
    242745, 
    242746, 
    227385, 
    227386, 
    227387, 
    242747, 
    242013, 
    227746, 
    227714, 
    227715, 
    227716, 
    227717, 
    227718, 
    227719, 
    227720, 
    237146, 
    237147, 
    227721, 
    242740, 
    242049, 
    227722, 
    227723, 
    227724, 
    227725, 
    227726, 
    242050, 
    227727, 
    227728, 
    227729, 
    227730, 
    227731, 
    227732, 
    227733, 
    227734, 
    242051, 
    227735, 
    242052, 
    227736, 
    227737, 
    242741, 
    242742, 
    227738, 
    227739, 
    227740, 
    242743, 
    242053, 
    227741, 
    227742, 
    227743, 
    227744, 
    227745, 
    240507, 
    240506, 
    240508, 
    240509, 
    240536, 
    240514, 
    240515, 
    240516, 
    240517, 
    240518, 
    240526, 
    240535, 
    240519, 
    240520, 
    240521, 
    240522, 
    240523, 
    240524, 
    240525, 
    240527, 
    240528, 
    240529, 
    240530, 
    240559, 
    240537, 
    240538, 
    240539, 
    240540, 
    240541, 
    240549, 
    240558, 
    240542, 
    240543, 
    240544, 
    240545, 
    240546, 
    240547, 
    240548, 
    240550, 
    240551, 
    240552, 
    240553, 
    240582, 
    240560, 
    240561, 
    240562, 
    240563, 
    240564, 
    240572, 
    240581, 
    240565, 
    240566, 
    240567, 
    240568, 
    240569, 
    240570, 
    240571, 
    240573, 
    240574, 
    240575, 
    240576
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00231

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 (220318,215376,215377,227161,227152,227153,227154,227191,227193,227192,227194,227195,227196,227197,227233,227198,227199,227200,227201,227202,227203,237054,237055,227204,242736,241974,227205,227206,227207,227208,227209,241975,227210,227211,227212,227213,227214,227215,227216,227217,241976,227218,241977,227219,227220,242737,242738,227221,227222,227223,242739,241978,227228,227229,227230,227231,227232,227344,227345,227346,227347,227348,227349,227359,227360,227361,227392,227362,227363,227364,227365,227366,227367,237060,237061,227368,242744,242009,227369,227370,227371,227372,227373,242010,227374,227375,227376,227377,227378,227379,227380,227381,242011,227382,242012,227383,227384,242745,242746,227385,227386,227387,242747,242013,227746,227714,227715,227716,227717,227718,227719,227720,237146,237147,227721,242740,242049,227722,227723,227724,227725,227726,242050,227727,227728,227729,227730,227731,227732,227733,227734,242051,227735,242052,227736,227737,242741,242742,227738,227739,227740,242743,242053,227741,227742,227743,227744,227745,240507,240506,240508,240509,240536,240514,240515,240516,240517,240518,240526,240535,240519,240520,240521,240522,240523,240524,240525,240527,240528,240529,240530,240559,240537,240538,240539,240540,240541,240549,240558,240542,240543,240544,240545,240546,240547,240548,240550,240551,240552,240553,240582,240560,240561,240562,240563,240564,240572,240581,240565,240566,240567,240568,240569,240570,240571,240573,240574,240575,240576)"
        }
      }
    },
    "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
45339 227152 variant_image 57572 0 V 0 D 0 0
45340 227153 variant_image 57573 0 V 0 D 0 0
45341 227154 variant_image 57574 0 V 0 D 0 0
45365 227195 variant_image 57598 0 V 0 D 0 0
45366 227196 variant_image 57599 0 V 0 D 0 0
45367 227197 variant_image 57600 0 V 0 D 0 0
45368 227198 variant_image 57601 0 V 0 D 0 0
45369 227199 variant_image 57602 0 V 0 D 0 0
45370 227200 variant_image 57603 0 V 0 D 0 0
45371 227201 variant_image 57604 0 V 0 D 0 0
45372 227202 variant_image 57605 0 V 0 D 0 0
45373 227203 variant_image 57606 0 V 0 D 0 0
45374 227204 variant_image 57607 0 V 0 D 0 0
45375 227205 variant_image 57608 0 V 0 D 0 0
45376 227206 variant_image 57609 0 V 0 D 0 0
45377 227207 variant_image 57610 0 V 0 D 0 0
45378 227208 variant_image 57611 0 V 0 D 0 0
45379 227209 variant_image 57612 0 V 0 D 0 0
45380 227210 variant_image 57613 0 V 0 D 0 0
45381 227211 variant_image 57614 0 V 0 D 0 0
45382 227212 variant_image 57615 0 V 0 D 0 0
45383 227213 variant_image 57616 0 V 0 D 0 0
45384 227214 variant_image 57617 0 V 0 D 0 0
45385 227215 variant_image 57618 0 V 0 D 0 0
45386 227216 variant_image 57619 0 V 0 D 0 0
45387 227217 variant_image 57620 0 V 0 D 0 0
45388 227218 variant_image 57621 0 V 0 D 0 0
45389 227219 variant_image 57622 0 V 0 D 0 0
45390 227220 variant_image 57623 0 V 0 D 0 0
45391 227221 variant_image 57624 0 V 0 D 0 0
45392 227222 variant_image 57625 0 V 0 D 0 0
45393 227223 variant_image 57626 0 V 0 D 0 0
45398 227228 variant_image 57631 0 V 0 D 0 0
45399 227229 variant_image 57632 0 V 0 D 0 0
45400 227230 variant_image 57633 0 V 0 D 0 0
45401 227231 variant_image 57634 0 V 0 D 0 0
45402 227232 variant_image 57635 0 V 0 D 0 0
45506 227345 variant_image 57739 0 V 0 D 0 0
45507 227346 variant_image 57740 0 V 0 D 0 0
45508 227348 variant_image 57741 0 V 0 D 0 0
45509 227349 variant_image 57742 0 V 0 D 0 0
45516 227360 variant_image 57749 0 V 0 D 0 0
45517 227361 variant_image 57750 0 V 0 D 0 0
45518 227362 variant_image 57751 0 V 0 D 0 0
45519 227363 variant_image 57752 0 V 0 D 0 0
45520 227364 variant_image 57753 0 V 0 D 0 0
45521 227365 variant_image 57754 0 V 0 D 0 0
45522 227366 variant_image 57755 0 V 0 D 0 0
45523 227367 variant_image 57756 0 V 0 D 0 0
45524 227368 variant_image 57757 0 V 0 D 0 0
45525 227369 variant_image 57758 0 V 0 D 0 0
45526 227370 variant_image 57759 0 V 0 D 0 0
45527 227371 variant_image 57760 0 V 0 D 0 0
45528 227372 variant_image 57761 0 V 0 D 0 0
45529 227373 variant_image 57762 0 V 0 D 0 0
45530 227374 variant_image 57763 0 V 0 D 0 0
45531 227375 variant_image 57764 0 V 0 D 0 0
45532 227376 variant_image 57765 0 V 0 D 0 0
45533 227377 variant_image 57766 0 V 0 D 0 0
45534 227378 variant_image 57767 0 V 0 D 0 0
45535 227379 variant_image 57768 0 V 0 D 0 0
45536 227380 variant_image 57769 0 V 0 D 0 0
45537 227381 variant_image 57770 0 V 0 D 0 0
45538 227382 variant_image 57771 0 V 0 D 0 0
45539 227383 variant_image 57772 0 V 0 D 0 0
45540 227384 variant_image 57773 0 V 0 D 0 0
45541 227385 variant_image 57774 0 V 0 D 0 0
45542 227386 variant_image 57775 0 V 0 D 0 0
45543 227387 variant_image 57776 0 V 0 D 0 0
45806 227715 variant_image 58039 0 V 0 D 0 0
45807 227716 variant_image 58040 0 V 0 D 0 0
45808 227717 variant_image 58041 0 V 0 D 0 0
45809 227718 variant_image 58042 0 V 0 D 0 0
45810 227719 variant_image 58043 0 V 0 D 0 0
45811 227720 variant_image 58044 0 V 0 D 0 0
45812 227721 variant_image 58045 0 V 0 D 0 0
45813 227722 variant_image 58046 0 V 0 D 0 0
45814 227723 variant_image 58047 0 V 0 D 0 0
45815 227724 variant_image 58048 0 V 0 D 0 0
45816 227725 variant_image 58049 0 V 0 D 0 0
45817 227726 variant_image 58050 0 V 0 D 0 0
45818 227727 variant_image 58051 0 V 0 D 0 0
45819 227728 variant_image 58052 0 V 0 D 0 0
45820 227729 variant_image 58053 0 V 0 D 0 0
45821 227730 variant_image 58054 0 V 0 D 0 0
45822 227731 variant_image 58055 0 V 0 D 0 0
45823 227732 variant_image 58056 0 V 0 D 0 0
45824 227733 variant_image 58057 0 V 0 D 0 0
45825 227734 variant_image 58058 0 V 0 D 0 0
45826 227735 variant_image 58059 0 V 0 D 0 0
45827 227736 variant_image 58060 0 V 0 D 0 0
45828 227737 variant_image 58061 0 V 0 D 0 0
45829 227738 variant_image 58062 0 V 0 D 0 0
45830 227739 variant_image 58063 0 V 0 D 0 0
45831 227740 variant_image 58064 0 V 0 D 0 0
45832 227741 variant_image 58065 0 V 0 D 0 0
45833 227742 variant_image 58066 0 V 0 D 0 0
45834 227743 variant_image 58067 0 V 0 D 0 0
45835 227744 variant_image 58068 0 V 0 D 0 0
45836 227745 variant_image 58069 0 V 0 D 0 0
59801 237054 variant_image 72034 0 V 0 D 0 0
59802 237055 variant_image 72035 0 V 0 D 0 0
59807 237060 variant_image 72040 0 V 0 D 0 0
59808 237061 variant_image 72041 0 V 0 D 0 0
59893 237146 variant_image 72126 0 V 0 D 0 0
59894 237147 variant_image 72127 0 V 0 D 0 0
69896 240514 variant_image 82129 0 V 0 D 0 0
69897 240515 variant_image 82130 0 V 0 D 0 0
69898 240516 variant_image 82131 0 V 0 D 0 0
69899 240517 variant_image 82132 0 V 0 D 0 0
69900 240518 variant_image 82133 0 V 0 D 0 0
69901 240519 variant_image 82134 0 V 0 D 0 0
69902 240520 variant_image 82135 0 V 0 D 0 0
69903 240521 variant_image 82136 0 V 0 D 0 0
69904 240522 variant_image 82137 0 V 0 D 0 0
69905 240523 variant_image 82138 0 V 0 D 0 0
69906 240524 variant_image 82139 0 V 0 D 0 0
69907 240525 variant_image 82140 0 V 0 D 0 0
69908 240526 variant_image 82141 0 V 0 D 0 0
69909 240527 variant_image 82142 0 V 0 D 0 0
69910 240528 variant_image 82143 0 V 0 D 0 0
69911 240529 variant_image 82144 0 V 0 D 0 0
69912 240530 variant_image 82145 0 V 0 D 0 0
69917 240535 variant_image 82150 0 V 0 D 0 0
69918 240537 variant_image 82151 0 V 0 D 0 0
69919 240538 variant_image 82152 0 V 0 D 0 0
69920 240539 variant_image 82153 0 V 0 D 0 0
69921 240540 variant_image 82154 0 V 0 D 0 0
69922 240541 variant_image 82155 0 V 0 D 0 0
69923 240542 variant_image 82156 0 V 0 D 0 0
69924 240543 variant_image 82157 0 V 0 D 0 0
69925 240544 variant_image 82158 0 V 0 D 0 0
69926 240545 variant_image 82159 0 V 0 D 0 0
69927 240546 variant_image 82160 0 V 0 D 0 0
69928 240547 variant_image 82161 0 V 0 D 0 0
69929 240548 variant_image 82162 0 V 0 D 0 0
69930 240549 variant_image 82163 0 V 0 D 0 0
69931 240550 variant_image 82164 0 V 0 D 0 0
69932 240551 variant_image 82165 0 V 0 D 0 0
69933 240552 variant_image 82166 0 V 0 D 0 0
69934 240553 variant_image 82167 0 V 0 D 0 0
69939 240558 variant_image 82172 0 V 0 D 0 0
69940 240560 variant_image 82173 0 V 0 D 0 0
69941 240561 variant_image 82174 0 V 0 D 0 0
69942 240562 variant_image 82175 0 V 0 D 0 0
69943 240563 variant_image 82176 0 V 0 D 0 0
69944 240564 variant_image 82177 0 V 0 D 0 0
69945 240565 variant_image 82178 0 V 0 D 0 0
69946 240566 variant_image 82179 0 V 0 D 0 0
69947 240567 variant_image 82180 0 V 0 D 0 0
69948 240568 variant_image 82181 0 V 0 D 0 0
69949 240569 variant_image 82182 0 V 0 D 0 0
69950 240570 variant_image 82183 0 V 0 D 0 0
69951 240571 variant_image 82184 0 V 0 D 0 0
69952 240572 variant_image 82185 0 V 0 D 0 0
69953 240573 variant_image 82186 0 V 0 D 0 0
69954 240574 variant_image 82187 0 V 0 D 0 0
69955 240575 variant_image 82188 0 V 0 D 0 0
69956 240576 variant_image 82189 0 V 0 D 0 0
69961 240581 variant_image 82194 0 V 0 D 0 0
71527 241974 variant_image 83760 0 V 0 D 0 0
71528 241975 variant_image 83761 0 V 0 D 0 0
71529 241976 variant_image 83762 0 V 0 D 0 0
71530 241977 variant_image 83763 0 V 0 D 0 0
71531 241978 variant_image 83764 0 V 0 D 0 0
71562 242009 variant_image 83795 0 V 0 D 0 0
71563 242010 variant_image 83796 0 V 0 D 0 0
71564 242011 variant_image 83797 0 V 0 D 0 0
71565 242012 variant_image 83798 0 V 0 D 0 0
71566 242013 variant_image 83799 0 V 0 D 0 0
71602 242049 variant_image 83835 0 V 0 D 0 0
71603 242050 variant_image 83836 0 V 0 D 0 0
71604 242051 variant_image 83837 0 V 0 D 0 0
71605 242052 variant_image 83838 0 V 0 D 0 0
71606 242053 variant_image 83839 0 V 0 D 0 0
72345 242736 variant_image 84578 0 V 0 D 0 0
72346 242737 variant_image 84579 0 V 0 D 0 0
72347 242738 variant_image 84580 0 V 0 D 0 0
72348 242739 variant_image 84581 0 V 0 D 0 0
72349 242740 variant_image 84582 0 V 0 D 0 0
72350 242741 variant_image 84583 0 V 0 D 0 0
72351 242742 variant_image 84584 0 V 0 D 0 0
72352 242743 variant_image 84585 0 V 0 D 0 0
72353 242744 variant_image 84586 0 V 0 D 0 0
72354 242745 variant_image 84587 0 V 0 D 0 0
72355 242746 variant_image 84588 0 V 0 D 0 0
72356 242747 variant_image 84589 0 V 0 D 0 0