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 (
    223755, 
    223756, 
    223757, 
    223758, 
    223759, 
    227161, 
    227152, 
    227153, 
    227154, 
    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, 
    227350, 
    227351, 
    227352, 
    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, 
    230828, 
    230827, 
    240507, 
    240506, 
    240508, 
    240509, 
    240605, 
    240583, 
    240584, 
    240585, 
    240586, 
    240587, 
    240595, 
    240604, 
    240588, 
    240589, 
    240590, 
    240591, 
    240592, 
    240593, 
    240594, 
    243079, 
    243080, 
    243081, 
    243082, 
    240628, 
    240606, 
    240607, 
    240608, 
    240609, 
    240610, 
    240618, 
    240627, 
    240611, 
    240612, 
    240613, 
    240614, 
    240615, 
    240616, 
    240617, 
    243083, 
    243084, 
    243085, 
    243086, 
    240651, 
    240629, 
    240630, 
    240631, 
    240632, 
    240633, 
    240641, 
    240650, 
    240634, 
    240635, 
    240636, 
    240637, 
    240638, 
    240639, 
    240640, 
    243087, 
    243088, 
    243089, 
    243090
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00317

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": 210,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (223755,223756,223757,223758,223759,227161,227152,227153,227154,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,227350,227351,227352,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,230828,230827,240507,240506,240508,240509,240605,240583,240584,240585,240586,240587,240595,240604,240588,240589,240590,240591,240592,240593,240594,243079,243080,243081,243082,240628,240606,240607,240608,240609,240610,240618,240627,240611,240612,240613,240614,240615,240616,240617,243083,243084,243085,243086,240651,240629,240630,240631,240632,240633,240641,240650,240634,240635,240636,240637,240638,240639,240640,243087,243088,243089,243090)"
        }
      }
    },
    "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
42039 223756 variant_image 54272 0 V 0 D 0 0
42040 223757 variant_image 54273 0 V 0 D 0 0
42041 223758 variant_image 54274 0 V 0 D 0 0
42042 223759 variant_image 54275 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
45510 227351 variant_image 57743 0 V 0 D 0 0
45511 227352 variant_image 57744 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
69962 240583 variant_image 82195 0 V 0 D 0 0
69963 240584 variant_image 82196 0 V 0 D 0 0
69964 240585 variant_image 82197 0 V 0 D 0 0
69965 240586 variant_image 82198 0 V 0 D 0 0
69966 240587 variant_image 82199 0 V 0 D 0 0
69967 240588 variant_image 82200 0 V 0 D 0 0
69968 240589 variant_image 82201 0 V 0 D 0 0
69969 240590 variant_image 82202 0 V 0 D 0 0
69970 240591 variant_image 82203 0 V 0 D 0 0
69971 240592 variant_image 82204 0 V 0 D 0 0
69972 240593 variant_image 82205 0 V 0 D 0 0
69973 240594 variant_image 82206 0 V 0 D 0 0
69974 240595 variant_image 82207 0 V 0 D 0 0
69983 240604 variant_image 82216 0 V 0 D 0 0
69984 240606 variant_image 82217 0 V 0 D 0 0
69985 240607 variant_image 82218 0 V 0 D 0 0
69986 240608 variant_image 82219 0 V 0 D 0 0
69987 240609 variant_image 82220 0 V 0 D 0 0
69988 240610 variant_image 82221 0 V 0 D 0 0
69989 240611 variant_image 82222 0 V 0 D 0 0
69990 240612 variant_image 82223 0 V 0 D 0 0
69991 240613 variant_image 82224 0 V 0 D 0 0
69992 240614 variant_image 82225 0 V 0 D 0 0
69993 240615 variant_image 82226 0 V 0 D 0 0
69994 240616 variant_image 82227 0 V 0 D 0 0
69995 240617 variant_image 82228 0 V 0 D 0 0
69996 240618 variant_image 82229 0 V 0 D 0 0
70005 240627 variant_image 82238 0 V 0 D 0 0
70006 240629 variant_image 82239 0 V 0 D 0 0
70007 240630 variant_image 82240 0 V 0 D 0 0
70008 240631 variant_image 82241 0 V 0 D 0 0
70009 240632 variant_image 82242 0 V 0 D 0 0
70010 240633 variant_image 82243 0 V 0 D 0 0
70011 240634 variant_image 82244 0 V 0 D 0 0
70012 240635 variant_image 82245 0 V 0 D 0 0
70013 240636 variant_image 82246 0 V 0 D 0 0
70014 240637 variant_image 82247 0 V 0 D 0 0
70015 240638 variant_image 82248 0 V 0 D 0 0
70016 240639 variant_image 82249 0 V 0 D 0 0
70017 240640 variant_image 82250 0 V 0 D 0 0
70018 240641 variant_image 82251 0 V 0 D 0 0
70027 240650 variant_image 82260 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
72795 243079 variant_image 85028 0 V 0 D 0 0
72796 243080 variant_image 85029 0 V 0 D 0 0
72797 243081 variant_image 85030 0 V 0 D 0 0
72798 243082 variant_image 85031 0 V 0 D 0 0
72799 243083 variant_image 85032 0 V 0 D 0 0
72800 243084 variant_image 85033 0 V 0 D 0 0
72801 243085 variant_image 85034 0 V 0 D 0 0
72802 243086 variant_image 85035 0 V 0 D 0 0
72803 243087 variant_image 85036 0 V 0 D 0 0
72804 243088 variant_image 85037 0 V 0 D 0 0
72805 243089 variant_image 85038 0 V 0 D 0 0
72806 243090 variant_image 85039 0 V 0 D 0 0