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 (
    109476, 110290, 110148, 110032, 109711, 
    109710, 109709, 109708, 109707, 109706, 
    109705, 109704, 109703, 109885, 109762, 
    109761, 109685, 110147, 109668, 109667
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00058

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 20 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_id image_path image_x image_y pair_id object_id object_type detailed_id type position alt images_image_id
0 5054286887331.jpg 1400 1400 112631 109476 product 116154 M 0 116154
0 5054286899082_sxll-u7.jpg 1400 1400 112824 109667 product 116347 M 0 116347
0 5054286899082_2vfe-uv.jpg 1400 1400 112825 109668 product 116348 M 0 116348
0 5054286899099.jpg 1400 1400 112842 109685 product 116365 M 0 116365
0 5054286906698.jpg 1400 1400 112860 109703 product 116383 M 0 116383
0 5054286891451.jpg 1400 1400 112861 109704 product 116384 M 0 116384
0 5054286891451_0wou-7u.jpg 1400 1400 112862 109705 product 116385 M 0 116385
0 5054286891451_dluh-bz.jpg 1400 1400 112863 109706 product 116386 M 0 116386
0 5054286891451_qpwe-1v.jpg 1400 1400 112864 109707 product 116387 M 0 116387
0 5054286891451_hq6r-tg.jpg 1400 1400 112865 109708 product 116388 M 0 116388
0 5054286891451_wrem-o1.jpg 1400 1400 112866 109709 product 116389 M 0 116389
0 5054286891451_78yc-hd.jpg 1400 1400 112867 109710 product 116390 M 0 116390
0 5054286891451_s80u-zr.jpg 1400 1400 112868 109711 product 116391 M 0 116391
0 5054286918110.jpg 1400 1400 112919 109761 product 116442 M 0 116442
0 5054286918110_514l-kr.jpg 1400 1400 112920 109762 product 116443 M 0 116443
0 5028386720430.jpg 1400 1400 113045 109885 product 116568 M 0 116568
0 5054286947882.jpg 1400 1400 113192 110032 product 116715 M 0 116715
0 5054286962250.jpg 1400 1400 113307 110147 product 116830 M 0 116830
0 5054286962694.jpg 1400 1400 113308 110148 product 116831 M 0 116831
0 5054286974741.jpg 1400 1400 113451 110290 product 116974 M 0 116974