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 (
    106778, 106777, 106776, 106775, 106774, 
    106313, 106760, 106759, 106369, 106368, 
    106273, 106271, 106270, 106269, 106260, 
    106243, 106242, 106241, 106240, 106239
  ) 
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 5054286549147_3z85-xq.jpg 1000 1000 109374 106239 product 112897 M 0 112897
0 5054286549147_kk4s-j6.jpg 1000 1000 109375 106240 product 112898 M 0 112898
0 5054286549147_1uqr-q4.jpg 1000 1000 109376 106241 product 112899 M 0 112899
0 5054286549147_mv19-hm.jpg 1000 1000 109377 106242 product 112900 M 0 112900
0 5054286549147_feo0-xm.jpg 1000 1000 109378 106243 product 112901 M 0 112901
0 5054286572329.jpg 1000 1000 109395 106260 product 112918 M 0 112918
0 5054286592075.jpg 1000 1000 109404 106269 product 112927 M 0 112927
0 5054286564911.jpg 1000 1000 109405 106270 product 112928 M 0 112928
0 5054286564911_crwi-dv.jpg 1000 1000 109406 106271 product 112929 M 0 112929
0 5054286559160.jpg 1000 1000 109408 106273 product 112931 M 0 112931
0 5054286547389.jpg 1000 1000 109448 106313 product 112971 M 0 112971
0 5054286612162.jpg 1000 1000 109504 106368 product 113027 M 0 113027
0 5054286612162_nxz7-hk.jpg 1000 1000 109505 106369 product 113028 M 0 113028
0 5054286657040.jpg 1000 1000 109898 106759 product 113421 M 0 113421
0 5054286657040_is2w-jp.jpg 1000 1000 109899 106760 product 113422 M 0 113422
0 5054286659662.jpg 1400 1400 109915 106774 product 113438 M 0 113438
0 5054286659662_4t47-jl.jpg 1400 1400 109916 106775 product 113439 M 0 113439
0 5054286659662_j2c8-pu.jpg 1400 1400 109917 106776 product 113440 M 0 113440
0 5054286659662_0v6j-i8.jpg 1400 1400 109918 106777 product 113441 M 0 113441
0 5054286659662_0tgu-t5.jpg 1400 1400 109919 106778 product 113442 M 0 113442