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.image_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 (
    69132, 69131, 69252, 69412, 69405, 69404, 
    68938, 68937, 68936, 68934, 68933, 
    68932, 68931, 68930, 68929, 68928, 
    68927, 68926, 68925, 68924, 68923, 
    68922, 68918, 68917, 68915, 68913, 
    68857, 68856, 68855, 68854, 68853, 
    68852, 68851, 68849, 68846, 68842, 
    68841, 68840, 68839, 69286
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00061

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 40 Using index condition; Using filesort
1 SIMPLE cscart_images eq_ref PRIMARY PRIMARY 4 toolboxdigitalshop_dev.cscart_images_links.image_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 71109 68839 product 74632 M 0
0 71110 68840 product 74633 M 0
0 71111 68841 product 74634 M 0
0 71112 68842 product 74635 M 0
0 71116 68846 product 74639 M 0
0 71119 68849 product 74642 M 0
0 71121 68851 product 74644 M 0
0 71122 68852 product 74645 M 0
0 71123 68853 product 74646 M 0
0 71124 68854 product 74647 M 0
0 71125 68855 product 74648 M 0
0 71126 68856 product 74649 M 0
0 71127 68857 product 74650 M 0
0 71182 68913 product 74705 M 0
0 71184 68915 product 74707 M 0
0 71186 68917 product 74709 M 0
0 71187 68918 product 74710 M 0
0 71191 68922 product 74714 M 0
0 71192 68923 product 74715 M 0
0 71193 68924 product 74716 M 0
0 71194 68925 product 74717 M 0
0 71195 68926 product 74718 M 0
0 71196 68927 product 74719 M 0
0 71197 68928 product 74720 M 0
0 71198 68929 product 74721 M 0
0 71199 68930 product 74722 M 0
0 71200 68931 product 74723 M 0
0 71201 68932 product 74724 M 0
0 71202 68933 product 74725 M 0
0 71203 68934 product 74726 M 0
0 71205 68936 product 74728 M 0
0 71206 68937 product 74729 M 0
0 71207 68938 product 74730 M 0
0 71402 69131 product 74925 M 0
0 71403 69132 product 74926 M 0
0 71523 69252 product 75046 M 0
0 71558 69286 product 75081 M 0
0 71678 69404 product 75201 M 0
0 71679 69405 product 75202 M 0
0 71686 69412 product 75209 M 0