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 = 'ru' 
WHERE 
  cscart_images_links.object_type = 'product' 
  AND cscart_images_links.type = 'M' 
  AND cscart_images_links.object_id IN (
    724, 723, 722, 721, 720, 726, 725, 727, 
    704, 703, 663, 710, 709, 708, 707, 706, 
    719, 718, 717, 716, 715, 714, 713, 711, 
    666
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00155

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "149.81"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "26.00"
      },
      "nested_loop": [
        {
          "table": {
            "table_name": "cscart_images_links",
            "access_type": "range",
            "possible_keys": [
              "object_id"
            ],
            "key": "object_id",
            "used_key_parts": [
              "object_id",
              "object_type",
              "type"
            ],
            "key_length": "81",
            "rows_examined_per_scan": 26,
            "rows_produced_per_join": 26,
            "filtered": "100.00",
            "index_condition": "((`cscart`.`cscart_images_links`.`object_type` = 'product') and (`cscart`.`cscart_images_links`.`type` = 'M') and (`cscart`.`cscart_images_links`.`object_id` in (724,723,722,721,720,726,725,727,704,703,663,710,709,708,707,706,719,718,717,716,715,714,713,711,666)))",
            "cost_info": {
              "read_cost": "56.21",
              "eval_cost": "5.20",
              "prefix_cost": "61.41",
              "data_read_per_join": "2K"
            },
            "used_columns": [
              "pair_id",
              "object_id",
              "object_type",
              "image_id",
              "detailed_id",
              "type",
              "position"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_images",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "image_id"
            ],
            "key_length": "4",
            "ref": [
              "cscart.cscart_images_links.detailed_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 26,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "26.00",
              "eval_cost": "5.20",
              "prefix_cost": "92.61",
              "data_read_per_join": "19K"
            },
            "used_columns": [
              "image_id",
              "image_path",
              "image_x",
              "image_y",
              "is_high_res"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_common_descriptions",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "object_id",
              "lang_code",
              "object_holder"
            ],
            "key_length": "108",
            "ref": [
              "cscart.cscart_images.image_id",
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 26,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "26.00",
              "eval_cost": "5.20",
              "prefix_cost": "123.81",
              "data_read_per_join": "15K"
            },
            "used_columns": [
              "object_id",
              "description",
              "lang_code",
              "object_holder"
            ]
          }
        }
      ]
    }
  }
}

Result

image_id image_path image_x image_y is_high_res pair_id object_id object_type detailed_id type position alt images_image_id
0 Render_Velutto_18_Top_9sx2-gq.png 1024 1024 N 7067 666 product 8818 M 0 8818
0 Render_white_velutto_18_bottom_7m2e-en.png 1024 1024 N 7310 720 product 9016 M 0 9016
0 Render_white_velutto_56_bottom.png 1024 1024 N 7311 722 product 9017 M 0 9017
0 Render_gold_premier_19_top.png 1024 1024 N 7312 723 product 9018 M 0 9018
0 Render_gold_premier_22_top.png 1024 1024 N 7313 721 product 9019 M 0 9019
0 Render_Diagonal_290_Bottom.png 1024 1024 N 7318 727 product 9021 M 0 9021
0 Render_white_Velutto_18_Bottom.png 1024 1024 N 7286 704 product 9001 M 1 9001
0 Render_Whie_Velutto_29_Bottom.png 1024 1024 N 7287 703 product 9002 M 1 9002
0 Render_Velutto_29_Bottom.png 1024 1024 N 7288 706 product 9003 M 1 9003
0 Render_Velutto_52_Bottom.png 1024 1024 N 7289 707 product 9004 M 1 9004
0 Render_White_Velutto_52_bottom.png 1024 1024 N 7290 708 product 9005 M 1 9005
0 Render_gold_Premier_19_bottom.png 1024 1024 N 7291 709 product 9006 M 1 9006
0 Render_gold_Premier_22_Bottom.png 1024 1024 N 7292 710 product 9007 M 1 9007
0 Render_white_Velutto_8_Bottom.png 1024 1024 N 7302 711 product 9008 M 1 9008
0 Render_white_Velutto_29_Bottom.png 1024 1024 N 7303 713 product 9009 M 1 9009
0 Render_Velutto_29_Bottom_o13r-oo.png 1024 1024 N 7304 714 product 9010 M 1 9010
0 Render_Velutto_56_Bottom.png 1024 1024 N 7305 715 product 9011 M 1 9011
0 Render_White_Velutto_56_Bottom.png 1024 1024 N 7306 716 product 9012 M 1 9012
0 Render_gold_premier_19_bottom.png 1024 1024 N 7307 717 product 9013 M 1 9013
0 Render_gold_premier_22_Bottom.png 1024 1024 N 7308 718 product 9014 M 1 9014
0 Render_gold_formual_134_bottom.png 1024 1024 N 7309 719 product 9015 M 1 9015
0 Render_white_velutto_29_bottom.png 1024 1024 N 7315 724 product 9020 M 1 9020
0 Render_Clarins_695_Bottom.png 1024 1024 N 7319 726 product 9022 M 1 9022
0 Render_Diagonal_540_Bottom.png 1024 1024 N 7320 725 product 9023 M 1 9023
0 Render_Velutto_18_Bottom.png 1024 1024 N 7963 663 product 9488 M 1 9488