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 (
    107397, 107396, 107395, 107394, 107393, 
    107392, 107391, 107381, 107675, 107493, 
    107492, 107491, 107729, 107728, 107555, 
    107390, 107389, 107388, 107387, 107280
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00067

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 5054286705420.jpg 1000 1000 110423 107280 product 113946 M 0 113946
0 5054286673729.jpg 1000 1000 110524 107381 product 114047 M 0 114047
0 5054286713487.jpg 1000 1000 110530 107387 product 114053 M 0 114053
0 5054286713487_wbv2-ni.jpg 1000 1000 110531 107388 product 114054 M 0 114054
0 5054286713487_qryh-b5.jpg 1000 1000 110532 107389 product 114055 M 0 114055
0 5054286713487_hl4g-s3.jpg 1000 1000 110533 107390 product 114056 M 0 114056
0 5054286615194.jpg 1000 1000 110534 107391 product 114057 M 0 114057
0 5054286615194_48w0-46.jpg 1000 1000 110535 107392 product 114058 M 0 114058
0 5054286615194_ben3-j2.jpg 1000 1000 110536 107393 product 114059 M 0 114059
0 5054286615194_lo06-b7.jpg 1000 1000 110537 107394 product 114060 M 0 114060
0 5054286615194_1eav-6o.jpg 1000 1000 110538 107395 product 114061 M 0 114061
0 5054286615194_pdn4-rf.jpg 1000 1000 110539 107396 product 114062 M 0 114062
0 5054286697893.jpg 1000 1000 110540 107397 product 114063 M 0 114063
0 5054286722717.jpg 1000 1000 110634 107491 product 114157 M 0 114157
0 5054286722717_zhgn-ag.jpg 1000 1000 110635 107492 product 114158 M 0 114158
0 5054286722717_4gdi-ck.jpg 1000 1000 110636 107493 product 114159 M 0 114159
0 5054286731917.jpg 1000 1000 110699 107555 product 114222 M 0 114222
0 FEER025_-_Tom_Basquil_-_Release_The_Pressure.jpg 2000 2000 110819 107675 product 114342 M 0 114342
0 5054286737308.jpg 1000 1000 110873 107728 product 114396 M 0 114396
0 5054286737308_nlni-46.jpg 1000 1000 110874 107729 product 114397 M 0 114397