SELECT 
  cscart_images.*, 
  cscart_images_links.*, 
  cscart_common_descriptions.description AS alt, 
  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 = 'product' 
  AND cscart_images_links.type = 'M' 
  AND cscart_images_links.object_id IN (
    21508, 21507, 21506, 2296, 16786, 16785, 
    16784, 16783, 16782, 5474, 37825, 32310, 
    32368, 19278, 31962, 32103, 32104, 
    32105, 16809, 16808, 16807, 16806, 
    16805, 16804, 16803, 5464, 18245, 4464, 
    31961, 32100, 32101, 32102, 32316, 
    32382, 32383, 26896, 32737, 32738, 
    32739, 32740, 32741, 32313, 32375, 
    32376, 32377, 38101, 38241, 38242, 
    38243, 38244, 38245, 38246, 18326, 
    18325, 18324, 4364, 25159, 18243, 4466, 
    49203, 49202, 49201, 49200, 49199, 
    22745, 22744, 22743, 22742, 1761, 47261, 
    47303, 47305, 47304, 37413, 37441, 
    37442, 37443, 37444, 37445, 18341, 
    18340, 18339, 4359, 37420, 37438, 37440, 
    16767, 16766, 16765, 16764, 16763, 
    5481, 16817, 16816, 16815, 16814, 5459
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00167

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "read_sorted_file": {
          "filesort": {
            "sort_key": "cscart_images_links.position, cscart_images_links.pair_id",
            "table": {
              "table_name": "cscart_images_links",
              "access_type": "ALL",
              "possible_keys": ["object_id"],
              "rows": 110,
              "filtered": 88.1818161,
              "attached_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'M' and cscart_images_links.object_id in (21508,21507,21506,2296,16786,16785,16784,16783,16782,5474,37825,32310,32368,19278,31962,32103,32104,32105,16809,16808,16807,16806,16805,16804,16803,5464,18245,4464,31961,32100,32101,32102,32316,32382,32383,26896,32737,32738,32739,32740,32741,32313,32375,32376,32377,38101,38241,38242,38243,38244,38245,38246,18326,18325,18324,4364,25159,18243,4466,49203,49202,49201,49200,49199,22745,22744,22743,22742,1761,47261,47303,47305,47304,37413,37441,37442,37443,37444,37445,18341,18340,18339,4359,37420,37438,37440,16767,16766,16765,16764,16763,5481,16817,16816,16815,16814,5459)"
            }
          }
        }
      },
      {
        "table": {
          "table_name": "cscart_images",
          "access_type": "eq_ref",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "4",
          "used_key_parts": ["image_id"],
          "ref": ["dev_db.cscart_images_links.detailed_id"],
          "rows": 1,
          "filtered": 100
        }
      },
      {
        "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": ["dev_db.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))"
        }
      }
    ]
  }
}