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 = 'variant_image' 
  AND cscart_images_links.type = 'V' 
  AND cscart_images_links.object_id IN (
    75998, 
    75999, 
    76000, 
    76001, 
    76002, 
    76003, 
    76012, 
    76013, 
    76014, 
    76015, 
    76016, 
    76017, 
    76018, 
    76019, 
    76020, 
    76021, 
    76024, 
    76025, 
    76088, 
    76089, 
    76090, 
    76091, 
    76094, 
    76095, 
    76100, 
    76101, 
    76102, 
    76103, 
    76104, 
    76105, 
    76106, 
    76107, 
    76108, 
    76109, 
    76110, 
    76111, 
    76112, 
    76113, 
    76114, 
    76115, 
    76116, 
    76117, 
    76118, 
    76119, 
    76120, 
    76121, 
    76122, 
    76123, 
    76130, 
    76131, 
    76132, 
    76133, 
    76134, 
    76135, 
    76188, 
    76189, 
    76190, 
    76191, 
    76252, 
    76253, 
    76254, 
    76255, 
    76256, 
    76257, 
    76266, 
    76267, 
    76274, 
    76275, 
    76280, 
    76281, 
    76448, 
    76449, 
    76458, 
    76459, 
    76472, 
    76473, 
    76482, 
    76483, 
    76484, 
    76485, 
    76486, 
    76487, 
    76488, 
    76489, 
    76490, 
    76491, 
    76492, 
    76493, 
    76498, 
    76499, 
    76500, 
    76501, 
    76522, 
    76523, 
    76524, 
    76525, 
    76526, 
    76527, 
    76534, 
    76535, 
    76536, 
    76537, 
    76540, 
    76541, 
    76664, 
    76665, 
    76954, 
    76955, 
    76956, 
    76957, 
    76958, 
    76959, 
    76960, 
    76961, 
    76962, 
    76963, 
    76964, 
    76965, 
    76966, 
    76967, 
    76968, 
    76969, 
    76970, 
    76971, 
    76972, 
    76973, 
    76974, 
    76975, 
    76976, 
    76977, 
    76978, 
    76979, 
    76980, 
    76981, 
    113982, 
    113983, 
    113984, 
    113985, 
    113986, 
    113987, 
    113988, 
    113989, 
    113990, 
    113991, 
    113992, 
    113993, 
    113994, 
    113995, 
    113996, 
    113997, 
    113998, 
    113999, 
    114000, 
    114001, 
    114002, 
    114003, 
    114004, 
    114005
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00093

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_images_links range object_id object_id 81 158 Using index condition; Using filesort
1 SIMPLE cscart_images eq_ref PRIMARY PRIMARY 4 toolboxdigitalshop_dev.cscart_images_links.detailed_id 1
1 SIMPLE cscart_common_descriptions eq_ref PRIMARY PRIMARY 108 toolboxdigitalshop_dev.cscart_images.image_id,const,const 1 Using where