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 (
    223749, 223750, 223751, 223752, 223753, 
    223754, 223755, 223756, 223757, 223758, 
    223759, 223760, 223761, 223762, 227176, 
    227163, 227164, 227165, 227166, 227167, 
    227168, 227169, 227170, 227171, 227172, 
    227173, 227174, 240138, 240106, 240107, 
    240108, 240109, 240110, 240111, 240139, 
    240140, 240112, 242920, 241680, 240113, 
    240114, 240115, 240116, 240117, 241681, 
    240118, 240119, 240120, 240121, 240122, 
    240123, 240124, 240125, 241682, 240126, 
    241683, 240127, 240128, 242921, 242922, 
    240129, 240130, 240131, 242923, 241684, 
    240136, 240137, 240287, 240288, 240500, 
    240501, 240502, 240208, 240179, 240180, 
    240181, 240182, 240183, 240184, 240185, 
    240213, 240214, 240186, 242924, 241690, 
    240187, 240188, 240189, 240190, 240191, 
    241691, 240192, 240193, 240194, 240195, 
    240196, 240197, 240198, 240199, 241692, 
    240200, 241693, 240201, 240202, 242925, 
    242926, 240203, 240204, 240205, 242927, 
    241694, 240206, 240207, 240504, 240505, 
    240448
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00174

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": 116,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (223749,223750,223751,223752,223753,223754,223755,223756,223757,223758,223759,223760,223761,223762,227176,227163,227164,227165,227166,227167,227168,227169,227170,227171,227172,227173,227174,240138,240106,240107,240108,240109,240110,240111,240139,240140,240112,242920,241680,240113,240114,240115,240116,240117,241681,240118,240119,240120,240121,240122,240123,240124,240125,241682,240126,241683,240127,240128,242921,242922,240129,240130,240131,242923,241684,240136,240137,240287,240288,240500,240501,240502,240208,240179,240180,240181,240182,240183,240184,240185,240213,240214,240186,242924,241690,240187,240188,240189,240190,240191,241691,240192,240193,240194,240195,240196,240197,240198,240199,241692,240200,241693,240201,240202,242925,242926,240203,240204,240205,242927,241694,240206,240207,240504,240505,240448)"
        }
      }
    },
    "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
42043 223761 variant_image 54276 0 V 0 D 0 0
42044 223762 variant_image 54277 0 V 0 D 0 0
68778 240106 variant_image 81011 0 V 0 D 0 0
68779 240107 variant_image 81012 0 V 0 D 0 0
68780 240108 variant_image 81013 0 V 0 D 0 0
68781 240109 variant_image 81014 0 V 0 D 0 0
68782 240110 variant_image 81015 0 V 0 D 0 0
68783 240111 variant_image 81016 0 V 0 D 0 0
68784 240112 variant_image 81017 0 V 0 D 0 0
68785 240113 variant_image 81018 0 V 0 D 0 0
68786 240114 variant_image 81019 0 V 0 D 0 0
68787 240115 variant_image 81020 0 V 0 D 0 0
68788 240116 variant_image 81021 0 V 0 D 0 0
68789 240117 variant_image 81022 0 V 0 D 0 0
68790 240118 variant_image 81023 0 V 0 D 0 0
68791 240119 variant_image 81024 0 V 0 D 0 0
68792 240120 variant_image 81025 0 V 0 D 0 0
68793 240121 variant_image 81026 0 V 0 D 0 0
68794 240122 variant_image 81027 0 V 0 D 0 0
68795 240123 variant_image 81028 0 V 0 D 0 0
68796 240124 variant_image 81029 0 V 0 D 0 0
68797 240125 variant_image 81030 0 V 0 D 0 0
68798 240126 variant_image 81031 0 V 0 D 0 0
68799 240127 variant_image 81032 0 V 0 D 0 0
68800 240128 variant_image 81033 0 V 0 D 0 0
68801 240129 variant_image 81034 0 V 0 D 0 0
68802 240130 variant_image 81035 0 V 0 D 0 0
68803 240131 variant_image 81036 0 V 0 D 0 0
68808 240136 variant_image 81041 0 V 0 D 0 0
68809 240137 variant_image 81042 0 V 0 D 0 0
68810 240139 variant_image 81043 0 V 0 D 0 0
68811 240140 variant_image 81044 0 V 0 D 0 0
68848 240180 variant_image 81081 0 V 0 D 0 0
68849 240181 variant_image 81082 0 V 0 D 0 0
68850 240182 variant_image 81083 0 V 0 D 0 0
68851 240183 variant_image 81084 0 V 0 D 0 0
68852 240184 variant_image 81085 0 V 0 D 0 0
68853 240185 variant_image 81086 0 V 0 D 0 0
68854 240186 variant_image 81087 0 V 0 D 0 0
68855 240187 variant_image 81088 0 V 0 D 0 0
68856 240188 variant_image 81089 0 V 0 D 0 0
68857 240189 variant_image 81090 0 V 0 D 0 0
68858 240190 variant_image 81091 0 V 0 D 0 0
68859 240191 variant_image 81092 0 V 0 D 0 0
68860 240192 variant_image 81093 0 V 0 D 0 0
68861 240193 variant_image 81094 0 V 0 D 0 0
68862 240194 variant_image 81095 0 V 0 D 0 0
68863 240195 variant_image 81096 0 V 0 D 0 0
68864 240196 variant_image 81097 0 V 0 D 0 0
68865 240197 variant_image 81098 0 V 0 D 0 0
68866 240198 variant_image 81099 0 V 0 D 0 0
68867 240199 variant_image 81100 0 V 0 D 0 0
68868 240200 variant_image 81101 0 V 0 D 0 0
68869 240201 variant_image 81102 0 V 0 D 0 0
68870 240202 variant_image 81103 0 V 0 D 0 0
68871 240203 variant_image 81104 0 V 0 D 0 0
68872 240204 variant_image 81105 0 V 0 D 0 0
68873 240205 variant_image 81106 0 V 0 D 0 0
68874 240206 variant_image 81107 0 V 0 D 0 0
68875 240207 variant_image 81108 0 V 0 D 0 0
68880 240213 variant_image 81113 0 V 0 D 0 0
68881 240214 variant_image 81114 0 V 0 D 0 0
68950 240287 variant_image 81183 0 V 0 D 0 0
68951 240288 variant_image 81184 0 V 0 D 0 0
69574 240500 variant_image 81807 0 V 0 D 0 0
69575 240501 variant_image 81808 0 V 0 D 0 0
69576 240502 variant_image 81809 0 V 0 D 0 0
69578 240504 variant_image 81811 0 V 0 D 0 0
69579 240505 variant_image 81812 0 V 0 D 0 0
71234 241680 variant_image 83467 0 V 0 D 0 0
71235 241681 variant_image 83468 0 V 0 D 0 0
71236 241682 variant_image 83469 0 V 0 D 0 0
71237 241683 variant_image 83470 0 V 0 D 0 0
71238 241684 variant_image 83471 0 V 0 D 0 0
71244 241690 variant_image 83477 0 V 0 D 0 0
71245 241691 variant_image 83478 0 V 0 D 0 0
71246 241692 variant_image 83479 0 V 0 D 0 0
71247 241693 variant_image 83480 0 V 0 D 0 0
71248 241694 variant_image 83481 0 V 0 D 0 0
72529 242920 variant_image 84762 0 V 0 D 0 0
72530 242921 variant_image 84763 0 V 0 D 0 0
72531 242922 variant_image 84764 0 V 0 D 0 0
72532 242923 variant_image 84765 0 V 0 D 0 0
72533 242924 variant_image 84766 0 V 0 D 0 0
72534 242925 variant_image 84767 0 V 0 D 0 0
72535 242926 variant_image 84768 0 V 0 D 0 0
72536 242927 variant_image 84769 0 V 0 D 0 0