Sandbox

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 (
    70862, 
    70863, 
    70878, 
    70879, 
    70934, 
    70935, 
    70964, 
    70965, 
    71138, 
    71139, 
    71140, 
    71141, 
    71146, 
    71147, 
    71148, 
    71149, 
    71152, 
    71153, 
    71154, 
    71155, 
    71178, 
    71179, 
    71180, 
    71181, 
    71248, 
    71249, 
    71250, 
    71251, 
    71252, 
    71253, 
    71254, 
    71255, 
    71256, 
    71257, 
    71264, 
    71265, 
    71266, 
    71267, 
    71288, 
    71289, 
    71290, 
    71291, 
    71312, 
    71313, 
    71324, 
    71325, 
    71354, 
    71355, 
    71366, 
    71367, 
    71368, 
    71369, 
    71370, 
    71371, 
    71466, 
    71467, 
    71482, 
    71483, 
    71568, 
    71569, 
    71576, 
    71577, 
    71578, 
    71579, 
    71580, 
    71581, 
    71604, 
    71605, 
    71606, 
    71607, 
    71608, 
    71609, 
    71610, 
    71611, 
    71612, 
    71613, 
    71614, 
    71615, 
    71616, 
    71617, 
    71618, 
    71619, 
    71620, 
    71621, 
    71622, 
    71623, 
    71824, 
    71825, 
    71838, 
    71839, 
    71844, 
    71845, 
    72182, 
    72183, 
    72184, 
    72185, 
    72186, 
    72187, 
    72188, 
    72189, 
    72190, 
    72191, 
    72192, 
    72193, 
    72194, 
    72195, 
    72196, 
    72197, 
    72198, 
    72199, 
    72200, 
    72201, 
    72202, 
    72203, 
    72204, 
    72205, 
    72206, 
    72207, 
    72208, 
    72209, 
    72210, 
    72211, 
    72214, 
    72215, 
    72216, 
    72217, 
    72218, 
    72219, 
    72220, 
    72221, 
    72222, 
    72223, 
    72224, 
    72225, 
    72226, 
    72227, 
    72228, 
    72229, 
    72230, 
    72231, 
    72232, 
    72233, 
    72234, 
    72235, 
    72236, 
    72237, 
    72238, 
    72239, 
    72240, 
    72241, 
    72242, 
    72243, 
    72244, 
    72245, 
    72246, 
    72247, 
    72248, 
    72249, 
    150172, 
    150173
  ) 
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