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 (
    40629, 79914, 40775, 40774, 40621, 40620, 
    40616, 40948, 40187, 40186, 40185, 
    40779, 40778, 40231, 40174, 79928, 
    40167, 40166, 40165, 40531, 40773, 
    40772, 40157, 40156, 40152, 40151, 
    40150, 40069, 40111, 40110, 40857, 
    40106, 40102, 40101, 40099, 40098, 
    40097, 40096, 40088, 40087, 40081, 
    40092, 40007, 40006, 40005, 39997, 
    39994, 39982, 39980, 39977, 39976, 
    39975, 39974, 39973, 39972, 39971, 
    39970, 39969, 39968, 39967, 39966, 
    39962, 39950, 79918, 40105, 39991, 
    39960, 39923, 39916, 39907, 39906, 
    91051, 91050, 91049, 91048, 91047, 
    91046, 91045, 91044, 91043
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00113

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 80 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 41380 39906 product 44903 M 0
0 41381 39907 product 44904 M 0
0 41389 39916 product 44912 M 0
0 41400 39923 product 44923 M 0
0 41427 39950 product 44950 M 0
0 41437 39960 product 44960 M 0
0 41439 39962 product 44962 M 0
0 41443 39966 product 44966 M 0
0 41444 39967 product 44967 M 0
0 41445 39968 product 44968 M 0
0 41446 39969 product 44969 M 0
0 41447 39970 product 44970 M 0
0 41448 39971 product 44971 M 0
0 41449 39972 product 44972 M 0
0 41450 39973 product 44973 M 0
0 41451 39974 product 44974 M 0
0 41452 39975 product 44975 M 0
0 41453 39976 product 44976 M 0
0 41454 39977 product 44977 M 0
0 41457 39980 product 44980 M 0
0 41459 39982 product 44982 M 0
0 41469 39991 product 44992 M 0
0 41472 39994 product 44995 M 0
0 41475 39997 product 44998 M 0
0 41483 40005 product 45006 M 0
0 41484 40006 product 45007 M 0
0 41485 40007 product 45008 M 0
0 41557 40081 product 45080 M 0
0 41563 40087 product 45086 M 0
0 41564 40088 product 45087 M 0
0 41568 40092 product 45091 M 0
0 41572 40096 product 45095 M 0
0 41573 40097 product 45096 M 0
0 41574 40098 product 45097 M 0
0 41575 40099 product 45098 M 0
0 41577 40101 product 45100 M 0
0 41578 40102 product 45101 M 0
0 41581 40105 product 45104 M 0
0 41582 40106 product 45105 M 0
0 41591 40110 product 45114 M 0
0 41592 40111 product 45115 M 0
0 41630 40150 product 45153 M 0
0 41631 40151 product 45154 M 0
0 41632 40152 product 45155 M 0
0 41636 40156 product 45159 M 0
0 41637 40157 product 45160 M 0
0 41645 40165 product 45168 M 0
0 41646 40166 product 45169 M 0
0 41647 40167 product 45170 M 0
0 41654 40174 product 45177 M 0
0 41665 40185 product 45188 M 0
0 41666 40186 product 45189 M 0
0 41667 40187 product 45190 M 0
0 41713 40231 product 45236 M 0
0 42013 40531 product 45536 M 0
0 42098 40616 product 45621 M 0
0 42102 40620 product 45625 M 0
0 42103 40621 product 45626 M 0
0 42111 40629 product 45634 M 0
0 42254 40772 product 45777 M 0
0 42255 40773 product 45778 M 0
0 42256 40774 product 45779 M 0
0 42257 40775 product 45780 M 0
0 42260 40778 product 45783 M 0
0 42261 40779 product 45784 M 0
0 42339 40857 product 45862 M 0
0 42432 40948 product 45955 M 0
0 42552 40069 product 46075 M 0
0 82813 79914 product 86336 M 0
0 82817 79918 product 86340 M 0
0 82827 79928 product 86350 M 0
0 93881 91043 product 97404 M 0
0 93882 91044 product 97405 M 0
0 93883 91045 product 97406 M 0
0 93884 91046 product 97407 M 0
0 93885 91047 product 97408 M 0
0 93886 91048 product 97409 M 0
0 93887 91049 product 97410 M 0
0 93888 91050 product 97411 M 0
0 93889 91051 product 97412 M 0