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.image_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.00206

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.image_id"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_images_links.image_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