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 (
    91767, 91766, 91765, 91763, 92157, 91716, 
    92113, 92112, 92111, 92110, 92109, 
    92108, 92107, 92106, 91627, 91623, 
    91622, 91621, 91620, 91619
  ) 
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 5054285535356_l27i-bv.jpg 1000 1000 94465 91619 product 97988 M 0 97988
0 5054285535356_c818-qg.jpg 1000 1000 94466 91620 product 97989 M 0 97989
0 5054285535356_ucjs-9y.jpg 1000 1000 94467 91621 product 97990 M 0 97990
0 5054285535356_knwv-ck.jpg 1000 1000 94468 91622 product 97991 M 0 97991
0 5054285535356_03a6-86.jpg 1000 1000 94469 91623 product 97992 M 0 97992
0 5054285535356_39tu-hg.jpg 1000 1000 94473 91627 product 97996 M 0 97996
0 5054285532249_g82n-hz.jpg 1000 1000 94562 91716 product 98085 M 0 98085
0 5054285552780.jpg 1000 1000 94610 91763 product 98133 M 0 98133
0 5054285545836.jpg 1000 1000 94612 91765 product 98135 M 0 98135
0 5054285545836_czmw-9n.jpg 1000 1000 94613 91766 product 98136 M 0 98136
0 5054285545836_axsq-gg.jpg 1000 1000 94614 91767 product 98137 M 0 98137
0 5054285590690_zsvc-qq.jpg 1000 1000 94958 92106 product 98481 M 0 98481
0 5054285590690_bkxu-47.jpg 1000 1000 94959 92107 product 98482 M 0 98482
0 5054285590690_pkw3-pg.jpg 1000 1000 94960 92108 product 98483 M 0 98483
0 5054285590690_tffm-jc.jpg 1000 1000 94961 92109 product 98484 M 0 98484
0 5054285590690_vyb7-i1.jpg 1000 1000 94962 92110 product 98485 M 0 98485
0 5054285590690_ms36-wy.jpg 1000 1000 94963 92111 product 98486 M 0 98486
0 5054285590690_z4iq-l0.jpg 1000 1000 94964 92112 product 98487 M 0 98487
0 5054285590690_i4jr-gz.jpg 1000 1000 94965 92113 product 98488 M 0 98488
0 5054285592618.jpg 1000 1000 95009 92157 product 98532 M 0 98532