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 (
    68835, 69400, 69349, 69324, 69291, 69257, 
    69256, 69255, 69123, 68831, 68697, 
    68696, 68879, 68906, 68576, 69176, 
    69175, 69174, 69033, 67842, 69173, 
    69172, 69100, 69099, 69032, 69022, 
    68905, 68408, 68368, 68367, 68695, 
    68547, 68555, 68904, 68903, 68834, 
    68833, 68725, 68605, 68292
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00086

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 70108 67842 product 73631 M 0
0 70561 68292 product 74084 M 0
0 70637 68367 product 74160 M 0
0 70638 68368 product 74161 M 0
0 70678 68408 product 74201 M 0
0 70817 68547 product 74340 M 0
0 70825 68555 product 74348 M 0
0 70846 68576 product 74369 M 0
0 70964 68695 product 74487 M 0
0 70965 68696 product 74488 M 0
0 70966 68697 product 74489 M 0
0 70995 68725 product 74518 M 0
0 71101 68831 product 74624 M 0
0 71103 68833 product 74626 M 0
0 71105 68835 product 74628 M 0
0 71149 68879 product 74672 M 0
0 71173 68903 product 74696 M 0
0 71174 68904 product 74697 M 0
0 71175 68905 product 74698 M 0
0 71212 68906 product 74735 M 0
0 71293 69022 product 74816 M 0
0 71303 69032 product 74826 M 0
0 71304 69033 product 74827 M 0
0 71370 69099 product 74893 M 0
0 71371 69100 product 74894 M 0
0 71443 69172 product 74966 M 0
0 71444 69173 product 74967 M 0
0 71445 69174 product 74968 M 0
0 71446 69175 product 74969 M 0
0 71447 69176 product 74970 M 0
0 71526 69255 product 75049 M 0
0 71528 69256 product 75051 M 0
0 71529 69257 product 75052 M 0
0 71563 69291 product 75086 M 0
0 71596 69324 product 75119 M 0
0 71623 69349 product 75146 M 0
0 71674 69400 product 75197 M 0
0 92225 68834 product 95748 M 0
0 100710 68605 product 104233 M 0
0 100711 69123 product 104234 M 0