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 = 'ru' 
WHERE 
  cscart_images_links.object_type = 'product' 
  AND cscart_images_links.type = 'A' 
  AND cscart_images_links.object_id IN ('6', '4', '5', '3', '1', '2') 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00156

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "148.83"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "36.00"
      },
      "nested_loop": [
        {
          "table": {
            "table_name": "cscart_images_links",
            "access_type": "ALL",
            "possible_keys": [
              "object_id"
            ],
            "rows_examined_per_scan": 118,
            "rows_produced_per_join": 35,
            "filtered": "30.51",
            "cost_info": {
              "read_cost": "19.23",
              "eval_cost": "7.20",
              "prefix_cost": "26.43",
              "data_read_per_join": "3K"
            },
            "used_columns": [
              "pair_id",
              "object_id",
              "object_type",
              "image_id",
              "detailed_id",
              "type",
              "position"
            ],
            "attached_condition": "((`db_emaika1`.`cscart_images_links`.`object_type` = 'product') and (`db_emaika1`.`cscart_images_links`.`type` = 'A') and (`db_emaika1`.`cscart_images_links`.`object_id` in ('6','4','5','3','1','2')))"
          }
        },
        {
          "table": {
            "table_name": "cscart_images",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "image_id"
            ],
            "key_length": "4",
            "ref": [
              "db_emaika1.cscart_images_links.image_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 35,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "36.00",
              "eval_cost": "7.20",
              "prefix_cost": "69.63",
              "data_read_per_join": "27K"
            },
            "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": "107",
            "ref": [
              "db_emaika1.cscart_images.image_id",
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 35,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "36.00",
              "eval_cost": "7.20",
              "prefix_cost": "112.83",
              "data_read_per_join": "21K"
            },
            "used_columns": [
              "object_id",
              "description",
              "lang_code",
              "object_holder"
            ],
            "attached_condition": "<if>(is_not_null_compl(cscart_common_descriptions), (`db_emaika1`.`cscart_common_descriptions`.`object_id` = `db_emaika1`.`cscart_images`.`image_id`), true)"
          }
        }
      ]
    }
  }
}

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 94 1 product 1436 A 1
0 95 2 product 1437 A 1
0 201 6 product 1544 A 1
0 93 1 product 1435 A 2
0 97 2 product 1439 A 2
0 73 3 product 1415 A 3
0 92 1 product 1434 A 3
0 101 2 product 1443 A 3
0 132 4 product 1474 A 3
0 152 5 product 1494 A 3
0 103 2 product 1445 A 4
0 189 1 product 1532 A 4
0 71 3 product 1413 A 5
0 105 2 product 1447 A 5
0 134 4 product 1476 A 5
0 154 5 product 1496 A 5
0 190 1 product 1533 A 5
0 107 2 product 1449 A 6
0 72 3 product 1414 A 7
0 109 2 product 1451 A 7
0 136 4 product 1478 A 7
0 156 5 product 1498 A 7
0 111 2 product 1453 A 8
0 113 2 product 1455 A 9
0 138 4 product 1480 A 9
0 158 5 product 1500 A 9
0 115 2 product 1457 A 10
0 117 2 product 1459 A 11
0 140 4 product 1482 A 11
0 160 5 product 1502 A 11
0 119 2 product 1461 A 12
0 142 4 product 1484 A 13
0 162 5 product 1504 A 13
0 191 2 product 1534 A 13
0 192 2 product 1535 A 14
0 144 4 product 1486 A 15
0 164 5 product 1506 A 15
0 167 5 product 1510 A 16
0 146 4 product 1488 A 17
0 168 5 product 1511 A 17
0 169 5 product 1512 A 18
0 148 4 product 1490 A 19
0 170 5 product 1513 A 19
0 171 5 product 1514 A 20
0 198 4 product 1541 A 20
0 172 5 product 1515 A 21
0 199 4 product 1542 A 21
0 173 5 product 1516 A 22
0 174 5 product 1517 A 23
0 175 5 product 1518 A 24
0 176 5 product 1519 A 25
0 177 5 product 1520 A 26
0 178 5 product 1521 A 27
0 179 5 product 1522 A 28
0 180 5 product 1523 A 29
0 181 5 product 1524 A 30
0 182 5 product 1525 A 31
0 183 5 product 1526 A 32
0 184 5 product 1527 A 33
0 185 5 product 1528 A 34
0 186 5 product 1529 A 35
0 187 5 product 1530 A 36
0 188 5 product 1531 A 37
0 193 5 product 1536 A 38
0 194 5 product 1537 A 39
0 195 5 product 1538 A 40
0 196 5 product 1539 A 41
0 197 5 product 1540 A 42