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 (
    67790, 
    67791, 
    67848, 
    67849, 
    67850, 
    67851, 
    67852, 
    67853, 
    67854, 
    67855, 
    67856, 
    67857, 
    67858, 
    67859, 
    67948, 
    67949, 
    67950, 
    67951, 
    67952, 
    67953, 
    67954, 
    67955, 
    67972, 
    67973, 
    67974, 
    67975, 
    67976, 
    67977, 
    67978, 
    67979, 
    67980, 
    67981, 
    67982, 
    67983, 
    67984, 
    67985, 
    67986, 
    67987, 
    67988, 
    67989, 
    67990, 
    67991, 
    67992, 
    67993, 
    67994, 
    67995, 
    67996, 
    67997, 
    67998, 
    67999, 
    68000, 
    68001, 
    68002, 
    68003, 
    68004, 
    68005, 
    68006, 
    68007, 
    68010, 
    68011, 
    68080, 
    68081, 
    68082, 
    68083, 
    68158, 
    68159, 
    68160, 
    68161, 
    68162, 
    68163, 
    68204, 
    68205, 
    68206, 
    68207, 
    68220, 
    68221, 
    68228, 
    68229, 
    68230, 
    68231, 
    68236, 
    68237, 
    68238, 
    68239, 
    68240, 
    68241, 
    68242, 
    68243, 
    68244, 
    68245, 
    68250, 
    68251, 
    68332, 
    68333, 
    68342, 
    68343, 
    68344, 
    68345, 
    68368, 
    68369, 
    68452, 
    68453, 
    68460, 
    68461, 
    68462, 
    68463, 
    68464, 
    68465, 
    68468, 
    68469, 
    68472, 
    68473, 
    68476, 
    68477, 
    68478, 
    68479, 
    68480, 
    68481, 
    68484, 
    68485, 
    68492, 
    68493, 
    68584, 
    68585, 
    68698, 
    68699, 
    68700, 
    68701, 
    68948, 
    68949, 
    68954, 
    68955, 
    69104, 
    69105, 
    70210, 
    70211, 
    70212, 
    70213, 
    70214, 
    70215, 
    70216, 
    70217, 
    70218, 
    70219, 
    70220, 
    70221, 
    70222, 
    70223, 
    132492, 
    132493, 
    132494, 
    132495, 
    132496, 
    132497, 
    132498, 
    132499, 
    150170, 
    150171, 
    150216, 
    150217
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00090

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