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 (
    95818, 95817, 95816, 95815, 95814, 95813, 
    95812, 95811, 95810, 95809, 95808, 
    95807, 95806, 95805, 95804, 95803, 
    95874, 95867, 95638, 95637
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00056

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 5054285882665.jpg 1000 1000 98559 95637 product 102082 M 0 102082
0 5054285882665_d848-9e.jpg 1000 1000 98560 95638 product 102083 M 0 102083
0 5054285893166.jpg 1000 1000 98727 95803 product 102250 M 0 102250
0 5054285893166_eouq-6d.jpg 1000 1000 98728 95804 product 102251 M 0 102251
0 5054285893166_d1n2-md.jpg 1000 1000 98729 95805 product 102252 M 0 102252
0 5054285893166_s7me-am.jpg 1000 1000 98730 95806 product 102253 M 0 102253
0 5054285893166_lef8-ie.jpg 1000 1000 98731 95807 product 102254 M 0 102254
0 5054285893166_myyk-pl.jpg 1000 1000 98732 95808 product 102255 M 0 102255
0 5054285893166_i83a-q8.jpg 1000 1000 98733 95809 product 102256 M 0 102256
0 5054285893166_2liv-b8.jpg 1000 1000 98734 95810 product 102257 M 0 102257
0 5054285893166_5wj8-hy.jpg 1000 1000 98735 95811 product 102258 M 0 102258
0 5054285893166_7vf9-uq.jpg 1000 1000 98736 95812 product 102259 M 0 102259
0 5054285893166_8z3j-1a.jpg 1000 1000 98737 95813 product 102260 M 0 102260
0 5054285893166_a89h-kg.jpg 1000 1000 98738 95814 product 102261 M 0 102261
0 5054285893166_wai4-if.jpg 1000 1000 98739 95815 product 102262 M 0 102262
0 5054285893166_xq2i-ar.jpg 1000 1000 98740 95816 product 102263 M 0 102263
0 5054285893166_aj5h-wu.jpg 1000 1000 98741 95817 product 102264 M 0 102264
0 5054285893166_dvb1-cq.jpg 1000 1000 98742 95818 product 102265 M 0 102265
0 5054285900901.jpg 1000 1000 98791 95867 product 102314 M 0 102314
0 5054285902295.jpg 1000 1000 98805 95874 product 102328 M 0 102328