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 = 'product' 
  AND cscart_images_links.type = 'M' 
  AND cscart_images_links.object_id IN (
    76582, 124500, 13315, 31964, 122622, 
    124267, 76718, 78107, 113387, 113408
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00075

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		10	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

Result

image_path	image_x	image_y	pair_id	object_id	object_type	detailed_id	type	images_image_id
50526532861381359721466510bb3fab54b5.jpg	1000	1000	13327	13315	product	16850	M	16850
5052653202879_qi5l-fe.jpg	1000	1000	31981	31964	product	35504	M	35504
5054284405575_9r3y-kk.jpg	1000	1000	79431	76582	product	82954	M	82954
5054284405506_e62c-v4.jpg	1000	1000	79567	76718	product	83090	M	83090
5054284423937_6w3k-m8.jpg	1000	1000	80965	78107	product	84488	M	84488
5054287171927.jpg	1000	1000	116556	113387	product	120079	M	120079
5054287176427_9ycy-9p.jpg	1000	1000	116577	113408	product	120100	M	120100
5054288053376_5llj-lo.jpg	1000	1000	125899	122622	product	129422	M	129422
5054288209087.jpg	1000	1000	127612	124267	product	131135	M	131135
5054288192778.jpg	1000	1000	127846	124500	product	131369	M	131369