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 (
    99478, 99477, 99705, 99426, 99423, 99422, 
    99419, 99418, 102526, 102525, 102524, 
    102523, 102522, 102521, 102520, 102519, 
    102518, 102517, 102516, 102515
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00077

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 5054286032243.jpg 1000 1000 102460 99418 product 105983 M 0 105983
0 5054286032243_ylzm-6i.jpg 1000 1000 102461 99419 product 105984 M 0 105984
0 5054286187028.jpg 1000 1000 102464 99422 product 105987 M 0 105987
0 5054286188582.jpg 1000 1000 102465 99423 product 105988 M 0 105988
0 5054286187493.jpg 1000 1000 102468 99426 product 105991 M 0 105991
0 5054286194309.jpg 1000 1000 102521 99477 product 106044 M 0 106044
0 5054286194309_j3ke-et.jpg 1000 1000 102522 99478 product 106045 M 0 106045
0 5054286225454.jpg 1000 1000 102772 99705 product 106295 M 0 106295
0 5054286474494_98y1-6x.jpg 1000 1000 105611 102515 product 109134 M 0 109134
0 5054286474494_xhbz-uy.jpg 1000 1000 105612 102516 product 109135 M 0 109135
0 5054286474494_wlha-3x.jpg 1000 1000 105613 102517 product 109136 M 0 109136
0 5054286474494_oivw-vb.jpg 1000 1000 105614 102518 product 109137 M 0 109137
0 5054286474494_0lft-mp.jpg 1000 1000 105615 102519 product 109138 M 0 109138
0 5054286474494_azl7-ab.jpg 1000 1000 105616 102520 product 109139 M 0 109139
0 5054286474494_hjg4-hd.jpg 1000 1000 105617 102521 product 109140 M 0 109140
0 5054286474494_50dr-5c.jpg 1000 1000 105618 102522 product 109141 M 0 109141
0 5054286474494_rg8k-op.jpg 1000 1000 105619 102523 product 109142 M 0 109142
0 5054286474494_8806-1f.jpg 1000 1000 105620 102524 product 109143 M 0 109143
0 5054286474494_gn66-oi.jpg 1000 1000 105621 102525 product 109144 M 0 109144
0 5054286474494_aua1-mx.jpg 1000 1000 105622 102526 product 109145 M 0 109145