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 (
    20841, 20840, 20839, 20838, 2627, 42346, 
    41136, 41137, 42362, 41146, 41147, 
    20859, 20858, 2623, 41101, 41100, 37897, 
    37890, 41115, 41126, 41127, 41107, 
    37892, 41129, 41425, 41465, 41466, 
    41467, 36522, 36658, 47432, 47431, 
    47416, 41116, 37891, 41117, 42345, 
    37883, 41140, 41141, 42350, 41098, 
    37884, 41099, 41132, 41133, 41119, 
    41118, 42347, 42349, 41121, 41120, 
    42341, 37893, 41110, 41111, 41109, 
    47433, 47414, 47434, 47415, 47429, 
    47412, 47430
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00346

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": 125,
              "filtered": 51.20000076,
              "attached_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'M' and cscart_images_links.object_id in (20841,20840,20839,20838,2627,42346,41136,41137,42362,41146,41147,20859,20858,2623,41101,41100,37897,37890,41115,41126,41127,41107,37892,41129,41425,41465,41466,41467,36522,36658,47432,47431,47416,41116,37891,41117,42345,37883,41140,41141,42350,41098,37884,41099,41132,41133,41119,41118,42347,42349,41121,41120,42341,37893,41110,41111,41109,47433,47414,47434,47415,47429,47412,47430)"
            }
          }
        }
      },
      {
        "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))"
        }
      }
    ]
  }
}