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 (
    22098, 22097, 2001, 16786, 16785, 16784, 
    16783, 16782, 5474, 27854, 32747, 32748, 
    32749, 32750, 32751, 46183, 46273, 
    46274, 46275, 40580, 40579, 40578, 
    40577, 40576, 40575, 40535, 18382, 
    4293, 15668, 15667, 15666, 15665, 15664, 
    15663, 5962, 16809, 16808, 16807, 16806, 
    16805, 16804, 16803, 5464, 21089, 2453, 
    48683, 48719, 48720, 48721, 25849, 
    25848, 25847, 353, 22084, 22083, 2008, 
    44753, 44790, 44791, 44792, 36295, 
    36687, 36688, 36689, 17909, 17908, 
    4872, 48677, 48699, 48700, 48701, 48684, 
    48722, 48723, 48724, 18245, 4464, 16538, 
    16537, 5595, 18101, 18097, 18096, 18095, 
    18094
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00219

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": 77.27272797,
              "attached_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'M' and cscart_images_links.object_id in (22098,22097,2001,16786,16785,16784,16783,16782,5474,27854,32747,32748,32749,32750,32751,46183,46273,46274,46275,40580,40579,40578,40577,40576,40575,40535,18382,4293,15668,15667,15666,15665,15664,15663,5962,16809,16808,16807,16806,16805,16804,16803,5464,21089,2453,48683,48719,48720,48721,25849,25848,25847,353,22084,22083,2008,44753,44790,44791,44792,36295,36687,36688,36689,17909,17908,4872,48677,48699,48700,48701,48684,48722,48723,48724,18245,4464,16538,16537,5595,18101,18097,18096,18095,18094)"
            }
          }
        }
      },
      {
        "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))"
        }
      }
    ]
  }
}