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.image_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 (
    89338, 
    89339, 
    89464, 
    89465, 
    89466, 
    89467, 
    89468, 
    89469, 
    89542, 
    89543, 
    89638, 
    89639, 
    89746, 
    89747, 
    89772, 
    89773, 
    89872, 
    89873, 
    89874, 
    89875, 
    89922, 
    89923, 
    89930, 
    89931, 
    90020, 
    90021, 
    90022, 
    90023, 
    90024, 
    90025, 
    90026, 
    90027, 
    90028, 
    90029, 
    90070, 
    90071, 
    90072, 
    90073, 
    90074, 
    90075, 
    90076, 
    90077, 
    90088, 
    90089, 
    90118, 
    90119, 
    90120, 
    90121, 
    90122, 
    90123, 
    90124, 
    90125, 
    90126, 
    90127, 
    90150, 
    90151, 
    90158, 
    90159, 
    90164, 
    90165, 
    90166, 
    90167, 
    90168, 
    90169, 
    90172, 
    90173, 
    90174, 
    90175, 
    90176, 
    90177, 
    90178, 
    90179, 
    90180, 
    90181, 
    90182, 
    90183, 
    90184, 
    90185, 
    90204, 
    90205, 
    90206, 
    90207, 
    90222, 
    90223, 
    90226, 
    90227, 
    90232, 
    90233, 
    90244, 
    90245, 
    90254, 
    90255, 
    90256, 
    90257, 
    90262, 
    90263, 
    90264, 
    90265, 
    90314, 
    90315, 
    90320, 
    90321, 
    90322, 
    90323, 
    90324, 
    90325, 
    90430, 
    90431, 
    90526, 
    90527, 
    90542, 
    90543, 
    90600, 
    90601, 
    90606, 
    90607, 
    90614, 
    90615, 
    90616, 
    90617, 
    90650, 
    90651, 
    90788, 
    90789, 
    90902, 
    90903, 
    90904, 
    90905, 
    90906, 
    90907, 
    90908, 
    90909, 
    91532, 
    91533, 
    150224, 
    150225, 
    150232, 
    150233, 
    174340, 
    174341, 
    174342, 
    174343, 
    174344, 
    174345, 
    174346, 
    174347, 
    174348, 
    174349, 
    174350, 
    174351, 
    174352, 
    174353, 
    174354, 
    174355, 
    174356, 
    174357, 
    174358, 
    174359, 
    174360, 
    174361
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00078

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 160 Using index condition; Using filesort
1 SIMPLE cscart_images eq_ref PRIMARY PRIMARY 4 toolboxdigitalshop_dev.cscart_images_links.image_id 1
1 SIMPLE cscart_common_descriptions eq_ref PRIMARY PRIMARY 108 toolboxdigitalshop_dev.cscart_images.image_id,const,const 1 Using where