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 (
    32127, 32128, 32129, 48543, 48544, 48545, 
    31949, 32112, 32113, 32114, 32115, 
    32116, 32117, 32118, 32119, 31953, 
    32130, 32131, 32132, 32133, 32134, 
    32135, 32136, 32137, 31950, 32120, 
    32121, 32122, 31954, 32138, 32139, 
    32140, 32141, 32142, 32143, 32144, 
    32145, 32146, 31955, 32147, 32148, 
    32149, 32150, 32151, 32152, 33070, 
    33071, 33072, 33073, 33074, 33075, 
    33076, 33077, 33078, 33079, 33080, 
    31956, 32153, 32154, 32155, 32156, 
    32157, 32158, 32159
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00244

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": 58.18181992,
              "attached_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'M' and cscart_images_links.object_id in (32127,32128,32129,48543,48544,48545,31949,32112,32113,32114,32115,32116,32117,32118,32119,31953,32130,32131,32132,32133,32134,32135,32136,32137,31950,32120,32121,32122,31954,32138,32139,32140,32141,32142,32143,32144,32145,32146,31955,32147,32148,32149,32150,32151,32152,33070,33071,33072,33073,33074,33075,33076,33077,33078,33079,33080,31956,32153,32154,32155,32156,32157,32158,32159)"
            }
          }
        }
      },
      {
        "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))"
        }
      }
    ]
  }
}