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 (
    5618, 5676, 5661, 5634, 5619, 6216, 2458, 
    2457, 2456, 2455, 2454, 2451, 2450, 
    6164, 2443, 2448, 2447, 2446, 2445, 
    2444, 85065, 85064, 78818, 78817, 2441, 
    2440, 2439, 5885, 2442, 78201, 5897, 
    2434, 2435, 2437, 2438, 2436, 6059, 
    2433, 2432, 2431, 2430, 6189, 6130, 
    6129, 6126, 6125, 6124, 6123, 6122, 
    5940, 2428, 2427, 2426, 2425, 6183, 
    2422, 2423, 2421, 2420, 2424, 2419, 
    2418, 2416, 2414, 6181, 5985, 77579, 
    6321, 26680, 6174, 6306, 2408, 2412, 
    2413, 2411, 2410, 2409, 2407, 6186, 
    103458
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00150

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 2424 2407 product 4771 M 0
0 2425 2408 product 4773 M 0
0 2426 2409 product 4775 M 0
0 2427 2410 product 4777 M 0
0 2428 2411 product 4779 M 0
0 2429 2412 product 4781 M 0
0 2430 2413 product 4783 M 0
0 2431 2414 product 4785 M 0
0 2433 2416 product 4789 M 0
0 2435 2418 product 4793 M 0
0 2436 2419 product 4795 M 0
0 2437 2420 product 4797 M 0
0 2438 2421 product 4799 M 0
0 2439 2422 product 4801 M 0
0 2440 2423 product 4803 M 0
0 2441 2424 product 4805 M 0
0 2443 2426 product 4808 M 0
0 2444 2427 product 4810 M 0
0 2445 2428 product 4812 M 0
0 2447 2430 product 4816 M 0
0 2448 2431 product 4818 M 0
0 2449 2432 product 4820 M 0
0 2450 2433 product 4822 M 0
0 2451 2434 product 4824 M 0
0 2452 2435 product 4826 M 0
0 2453 2436 product 4828 M 0
0 2454 2437 product 4830 M 0
0 2455 2438 product 4832 M 0
0 2456 2439 product 4834 M 0
0 2457 2440 product 4836 M 0
0 2458 2441 product 4838 M 0
0 2459 2442 product 4840 M 0
0 2460 2443 product 4842 M 0
0 2461 2444 product 4844 M 0
0 2462 2445 product 4846 M 0
0 2463 2446 product 4848 M 0
0 2464 2447 product 4850 M 0
0 2465 2448 product 4852 M 0
0 2467 2450 product 4856 M 0
0 2468 2451 product 4858 M 0
0 2471 2454 product 4864 M 0
0 2472 2455 product 4866 M 0
0 2473 2456 product 4868 M 0
0 2474 2457 product 4870 M 0
0 2475 2458 product 4872 M 0
0 5629 5618 product 9152 M 0
0 5630 5619 product 9153 M 0
0 5645 5634 product 9168 M 0
0 5672 5661 product 9195 M 0
0 5687 5676 product 9210 M 0
0 5894 5885 product 9417 M 0
0 5906 5897 product 9429 M 0
0 5949 5940 product 9472 M 0
0 5994 5985 product 9517 M 0
0 6068 6059 product 9591 M 0
0 6131 6122 product 9654 M 0
0 6132 6123 product 9655 M 0
0 6133 6124 product 9656 M 0
0 6134 6125 product 9657 M 0
0 6135 6126 product 9658 M 0
0 6138 6129 product 9661 M 0
0 6139 6130 product 9662 M 0
0 6173 6164 product 9696 M 0
0 6183 6174 product 9706 M 0
0 6190 6181 product 9713 M 0
0 6192 6183 product 9715 M 0
0 6195 6186 product 9718 M 0
0 6198 6189 product 9721 M 0
0 6225 6216 product 9748 M 0
0 6315 6306 product 9838 M 0
0 6330 6321 product 9853 M 0
0 26697 26680 product 30220 M 0
0 50841 2425 product 54364 M 0
0 80437 77579 product 83960 M 0
0 81059 78201 product 84582 M 0
0 81675 78817 product 85198 M 0
0 81676 78818 product 85199 M 0
0 88006 85064 product 91529 M 0
0 88007 85065 product 91530 M 0
0 106554 103458 product 110077 M 0