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 (
    49659, 49186, 49658, 22106, 22105, 1997, 
    18946, 18945, 18944, 3668, 19591, 3190, 
    4191, 40608, 40605, 40606, 40607, 20609, 
    20608, 20607, 20606, 20605, 20604, 
    20603, 20602, 20601, 20600, 20599, 
    20598, 2946, 19588, 3195, 22116, 22115, 
    1992, 47283, 47282, 47274, 47281, 38147, 
    38330, 28260, 28258, 28259, 28257, 
    28171, 36758, 36944, 36945, 36946, 
    36947, 36948, 36949, 36950, 36951, 
    36952, 36953, 36954, 36955, 38247, 
    38102, 38248, 38249, 38250, 38251, 
    38252, 38253, 38254, 38255, 22102, 
    22101, 1999, 22082, 22081, 2009, 22471, 
    22470, 22466, 21078, 2464, 22108, 22107, 
    1996
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00186

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": 75.45454407,
              "attached_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'M' and cscart_images_links.object_id in (49659,49186,49658,22106,22105,1997,18946,18945,18944,3668,19591,3190,4191,40608,40605,40606,40607,20609,20608,20607,20606,20605,20604,20603,20602,20601,20600,20599,20598,2946,19588,3195,22116,22115,1992,47283,47282,47274,47281,38147,38330,28260,28258,28259,28257,28171,36758,36944,36945,36946,36947,36948,36949,36950,36951,36952,36953,36954,36955,38247,38102,38248,38249,38250,38251,38252,38253,38254,38255,22102,22101,1999,22082,22081,2009,22471,22470,22466,21078,2464,22108,22107,1996)"
            }
          }
        }
      },
      {
        "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))"
        }
      }
    ]
  }
}