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 (
    41098, 37884, 41099, 44573, 44592, 16539, 
    5594, 41132, 41133, 33835, 41119, 41118, 
    42347, 41378, 41391, 32315, 32380, 
    32381, 24713, 24714, 37417, 37467, 
    37468, 37469, 37470, 37471, 37472, 
    37473, 37474, 37475, 37476, 37477, 
    37478, 43653, 43865, 43867, 43869, 
    43871, 43864, 48676, 48696, 48697, 
    48698, 32314, 32378, 32379, 45575, 
    45855, 45856, 45857, 45858, 45859, 
    45860, 45861, 45862, 45863, 45864, 
    45865, 45866, 45867, 45868, 45869, 
    45870, 45871, 45872, 45873, 37414, 
    37447, 37448, 37449, 46199, 46153, 
    46198, 46197, 14979, 6471, 46619, 46590, 
    46620
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00146

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": 71.8181839,
              "attached_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'M' and cscart_images_links.object_id in (41098,37884,41099,44573,44592,16539,5594,41132,41133,33835,41119,41118,42347,41378,41391,32315,32380,32381,24713,24714,37417,37467,37468,37469,37470,37471,37472,37473,37474,37475,37476,37477,37478,43653,43865,43867,43869,43871,43864,48676,48696,48697,48698,32314,32378,32379,45575,45855,45856,45857,45858,45859,45860,45861,45862,45863,45864,45865,45866,45867,45868,45869,45870,45871,45872,45873,37414,37447,37448,37449,46199,46153,46198,46197,14979,6471,46619,46590,46620)"
            }
          }
        }
      },
      {
        "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))"
        }
      }
    ]
  }
}