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 (
    720, 721, 722, 723, 724, 725, 726, 727, 
    663, 703, 704, 706, 707, 708, 709, 710, 
    666, 711, 713, 714, 715, 716, 717, 718, 
    719, 623, 624, 962, 963, 964, 960, 961, 
    603, 604, 965, 966, 601, 602, 607, 608, 
    1013, 1014, 802, 803, 804, 805, 806, 
    797, 798, 799, 800, 801, 813, 814, 807, 
    808, 809, 810, 822, 823
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00211

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "352.81"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "61.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": 61,
            "rows_produced_per_join": 61,
            "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 (720,721,722,723,724,725,726,727,663,703,704,706,707,708,709,710,666,711,713,714,715,716,717,718,719,623,624,962,963,964,960,961,603,604,965,966,601,602,607,608,1013,1014,802,803,804,805,806,797,798,799,800,801,813,814,807,808,809,810,822,823)))",
            "cost_info": {
              "read_cost": "133.21",
              "eval_cost": "12.20",
              "prefix_cost": "145.41",
              "data_read_per_join": "5K"
            },
            "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": 61,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "61.00",
              "eval_cost": "12.20",
              "prefix_cost": "218.61",
              "data_read_per_join": "46K"
            },
            "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": 61,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "61.00",
              "eval_cost": "12.20",
              "prefix_cost": "291.81",
              "data_read_per_join": "36K"
            },
            "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_G_Bottom_zdts-u3.png 1024 1024 N 6975 601 product 8753 M 0 8753
0 Render_G_Top_mitd-5q.png 1024 1024 N 6978 603 product 8755 M 0 8755
0 Render_G_Top_dpcp-4c.png 1024 1024 N 6984 607 product 8759 M 0 8759
0 Render_Votan_Bottom.png 1024 1024 N 7007 623 product 8775 M 0 8775
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_Bottom_oo2h-j5.png 1024 1024 N 7452 802 product 9101 M 0 9101
0 Render_cLP01_Marbl_Bottom.png 1024 1024 N 7461 807 product 9106 M 0 9106
0 Render_G_Bottom.png 1024 1024 N 7471 813 product 9112 M 0 9112
0 Rendedr_White_Bottom.png 1024 1024 N 7484 822 product 9121 M 0 9121
0 Render_5083_shelving_unit_white_bottom.png 1024 1024 N 7699 960 product 9261 M 0 9261
0 Render_White_Gold_Bottom.png 1024 1024 N 7702 962 product 9263 M 0 9263
0 Render_White_Bottom_o7ik-fm.png 1024 1024 N 7707 965 product 9266 M 0 9266
0 Render_White_Bottom_wzip-1w.png 1024 1024 N 7784 1013 product 9314 M 0 9314
0 Render_R_Bottom_s7me-ib.png 1024 1024 N 6977 602 product 8754 M 1 8754
0 Render_R_Top.png 1024 1024 N 6980 604 product 8756 M 1 8756
0 Render_White_Bottom.png 1024 1024 N 7009 624 product 8776 M 1 8776
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_White_Bottom_wo1r-cb.png 1024 1024 N 7447 797 product 9096 M 1 9096
0 Render_Aok_Kan_White_Bottom.png 1024 1024 N 7448 798 product 9097 M 1 9097
0 Render_Aok_Kan_Bottom.png 1024 1024 N 7449 799 product 9098 M 1 9098
0 Render_Aok_Vintag_Bottom.png 1024 1024 N 7450 800 product 9099 M 1 9099
0 Render_Coffee_Bottom.png 1024 1024 N 7451 801 product 9100 M 1 9100
0 Render_Aok_Kan_White_Bottom_s089-vy.png 1024 1024 N 7457 803 product 9102 M 1 9102
0 Render_Aok_Kan_Bottom_4yzo-g7.png 1024 1024 N 7458 804 product 9103 M 1 9103
0 Render_Aok_Vintag_Bottom_qcog-l7.png 1024 1024 N 7459 805 product 9104 M 1 9104
0 Render_Coffee_Bottom_k04s-yo.png 1024 1024 N 7460 806 product 9105 M 1 9105
0 Render_cLP01_Wotan_Bottom.png 1024 1024 N 7465 808 product 9107 M 1 9107
0 Render_cLP01_Birch_Bottom.png 1024 1024 N 7466 809 product 9108 M 1 9108
0 Render_cLP01_Marble_Black_Bottom.png 1024 1024 N 7467 810 product 9109 M 1 9109
0 Render_R_Bottom.png 1024 1024 N 7473 814 product 9113 M 1 9113
0 Rendedr_Satin_Bottom.png 1024 1024 N 7486 823 product 9122 M 1 9122
0 Render_5083_shelving_unit_grey_bottom.png 1024 1024 N 7701 961 product 9262 M 1 9262
0 Render_Oak_Gold_Bottom.png 1024 1024 N 7705 963 product 9264 M 1 9264
0 Render_Oak_Aprel_Bottom.png 1024 1024 N 7706 964 product 9265 M 1 9265
0 Render_Satin_Bottom_tkix-dr.png 1024 1024 N 7709 966 product 9267 M 1 9267
0 Render_Satin_Bottom_xabx-qb.png 1024 1024 N 7786 1014 product 9315 M 1 9315
0 Render_Velutto_18_Bottom.png 1024 1024 N 7963 663 product 9488 M 1 9488
0 Render_R_Top_9yyd-kt.png 1024 1024 N 6986 608 product 8760 M 2 8760