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 (
    18751, 18750, 296, 26107, 26108, 20932, 
    2568, 40270, 40154, 40267, 40268, 40269, 
    14959, 14958, 14957, 14956, 6529, 27130, 
    2130, 21080, 2462, 24018, 24019, 24020, 
    40246, 40245, 40244, 40148, 21018, 
    21017, 2512, 22074, 22073, 2013, 1437, 
    23200, 23201, 23202, 23203, 32127, 
    32128, 32129, 48543, 48544, 48545, 
    26672, 26673, 2253, 49198, 2304, 49195, 
    49197, 49196, 15230, 15229, 47523, 
    6353, 47524, 47525, 47526, 47527, 19171, 
    3617, 24126, 1053, 471, 25446, 25447, 
    25448, 25449, 25450, 25451, 25452, 
    25453, 25462
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00678

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": 68.1818161,
              "attached_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'M' and cscart_images_links.object_id in (18751,18750,296,26107,26108,20932,2568,40270,40154,40267,40268,40269,14959,14958,14957,14956,6529,27130,2130,21080,2462,24018,24019,24020,40246,40245,40244,40148,21018,21017,2512,22074,22073,2013,1437,23200,23201,23202,23203,32127,32128,32129,48543,48544,48545,26672,26673,2253,49198,2304,49195,49197,49196,15230,15229,47523,6353,47524,47525,47526,47527,19171,3617,24126,1053,471,25446,25447,25448,25449,25450,25451,25452,25453,25462)"
            }
          }
        }
      },
      {
        "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))"
        }
      }
    ]
  }
}