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 (
    84392, 
    84393, 
    84394, 
    84395, 
    84396, 
    84397, 
    84398, 
    84399, 
    84400, 
    84401, 
    84402, 
    84403, 
    84404, 
    84405, 
    84406, 
    84407, 
    84472, 
    84473, 
    84570, 
    84571, 
    84636, 
    84637, 
    84672, 
    84673, 
    84674, 
    84675, 
    84676, 
    84677, 
    84680, 
    84681, 
    84706, 
    84707, 
    84708, 
    84709, 
    84710, 
    84711, 
    84712, 
    84713, 
    84736, 
    84737, 
    84738, 
    84739, 
    84740, 
    84741, 
    84742, 
    84743, 
    84800, 
    84801, 
    84804, 
    84805, 
    84810, 
    84811, 
    84812, 
    84813, 
    84814, 
    84815, 
    84820, 
    84821, 
    84854, 
    84855, 
    84880, 
    84881, 
    84882, 
    84883, 
    84884, 
    84885, 
    84890, 
    84891, 
    84900, 
    84901, 
    84934, 
    84935, 
    84936, 
    84937, 
    84938, 
    84939, 
    85178, 
    85179, 
    85196, 
    85197, 
    85202, 
    85203, 
    85208, 
    85209, 
    85210, 
    85211, 
    85212, 
    85213, 
    85248, 
    85249, 
    85832, 
    85833, 
    85834, 
    85835, 
    85836, 
    85837, 
    85838, 
    85839, 
    85840, 
    85841, 
    85842, 
    85843, 
    85844, 
    85845, 
    85846, 
    85847, 
    85848, 
    85849, 
    85850, 
    85851, 
    85852, 
    85853, 
    85854, 
    85855, 
    85856, 
    85857, 
    85858, 
    85859, 
    85860, 
    85861, 
    85862, 
    85863, 
    85864, 
    85865, 
    85866, 
    85867, 
    85868, 
    85869, 
    85870, 
    85871, 
    85872, 
    85873, 
    85874, 
    85875, 
    85876, 
    85877, 
    85878, 
    85879, 
    132368, 
    132369, 
    132370, 
    132371, 
    132372, 
    132373, 
    132374, 
    132375, 
    171598, 
    171599, 
    171600, 
    171601, 
    171602, 
    171603, 
    171604, 
    171605, 
    171606, 
    171607, 
    171608, 
    171609, 
    171610, 
    171611
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00095

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.detailed_id 1
1 SIMPLE cscart_common_descriptions eq_ref PRIMARY PRIMARY 108 toolboxdigitalshop_dev.cscart_images.image_id,const,const 1 Using where