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 (
    88461, 88412, 88396, 89357, 89198, 88514, 
    88484, 88483, 88482, 88463, 88462, 
    89197, 89196, 89013, 89012, 89011, 
    88992, 88991, 88990, 88989, 88988, 
    88987, 88986, 88985, 88984, 88983, 
    88982, 88952, 88951, 88950, 88949, 
    88948, 88947, 88946, 88841, 88840, 
    88831, 88830, 88829, 88828
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00078

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 91194 88396 product 94717 M 0
0 91210 88412 product 94733 M 0
0 91259 88461 product 94782 M 0
0 91260 88462 product 94783 M 0
0 91261 88463 product 94784 M 0
0 91280 88482 product 94803 M 0
0 91281 88483 product 94804 M 0
0 91282 88484 product 94805 M 0
0 91312 88514 product 94835 M 0
0 91627 88828 product 95150 M 0
0 91628 88829 product 95151 M 0
0 91629 88830 product 95152 M 0
0 91630 88831 product 95153 M 0
0 91639 88840 product 95162 M 0
0 91640 88841 product 95163 M 0
0 91747 88946 product 95270 M 0
0 91748 88947 product 95271 M 0
0 91749 88948 product 95272 M 0
0 91750 88949 product 95273 M 0
0 91751 88950 product 95274 M 0
0 91752 88951 product 95275 M 0
0 91753 88952 product 95276 M 0
0 91783 88982 product 95306 M 0
0 91784 88983 product 95307 M 0
0 91785 88984 product 95308 M 0
0 91786 88985 product 95309 M 0
0 91787 88986 product 95310 M 0
0 91788 88987 product 95311 M 0
0 91789 88988 product 95312 M 0
0 91790 88989 product 95313 M 0
0 91791 88990 product 95314 M 0
0 91792 88991 product 95315 M 0
0 91793 88992 product 95316 M 0
0 91813 89011 product 95336 M 0
0 91814 89012 product 95337 M 0
0 91815 89013 product 95338 M 0
0 91999 89196 product 95522 M 0
0 92000 89197 product 95523 M 0
0 92001 89198 product 95524 M 0
0 92165 89357 product 95688 M 0