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 = 'ab__lc_catalog_icon' 
  AND cscart_images_links.type = 'M' 
  AND cscart_images_links.object_id IN (
    267, 271, 285, 286, 290, 294, 302, 311, 
    315, 326, 334, 342, 346, 350, 355, 361
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00144

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "44.86"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "19.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": 19,
            "rows_produced_per_join": 19,
            "filtered": "100.00",
            "index_condition": "((`zdrowy_db`.`cscart_images_links`.`object_type` = 'ab__lc_catalog_icon') and (`zdrowy_db`.`cscart_images_links`.`type` = 'M') and (`zdrowy_db`.`cscart_images_links`.`object_id` in (267,271,285,286,290,294,302,311,315,326,334,342,346,350,355,361)))",
            "cost_info": {
              "read_cost": "10.66",
              "eval_cost": "1.90",
              "prefix_cost": "12.56",
              "data_read_per_join": "1K"
            },
            "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": [
              "zdrowy_db.cscart_images_links.image_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 19,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "4.75",
              "eval_cost": "1.90",
              "prefix_cost": "19.21",
              "data_read_per_join": "14K"
            },
            "used_columns": [
              "image_id",
              "image_path",
              "image_x",
              "image_y",
              "is_high_res",
              "transparent"
            ]
          }
        },
        {
          "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": [
              "zdrowy_db.cscart_images.image_id",
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 19,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "4.75",
              "eval_cost": "1.90",
              "prefix_cost": "25.86",
              "data_read_per_join": "11K"
            },
            "used_columns": [
              "object_id",
              "description",
              "lang_code",
              "object_holder"
            ]
          }
        }
      ]
    }
  }
}

Result

image_id image_path image_x image_y is_high_res transparent pair_id object_id object_type detailed_id type position alt images_image_id
1039696 high-angle-delicious-food-pack__1_.jpg 6240 4160 N N 1041485 285 ab__lc_catalog_icon 0 M 0 1039696
1039699 бум_упак.jpg 740 493 N N 1041488 267 ab__lc_catalog_icon 0 M 0 1039699
1039706 одноразовая_посуда.jpg 740 470 N N 1041493 290 ab__lc_catalog_icon 0 M 0 1039706
1039716 lot-protection-elastic-surgical-gloves-white-black-blue-colors-flat-lay-close-up-view-hygiene-protective-gloves-hospital-medical-staff-pandemic-outbreak-quarantine_494000-61.jpg 740 493 N N 1041499 326 ab__lc_catalog_icon 0 M 0 1039716
1041541 plyonka_cast.jpeg 952 951 N N 1043324 311 ab__lc_catalog_icon 0 M 0 1041541
1093804 лотки.jpg 724 401 N N 1095586 286 ab__lc_catalog_icon 0 M 0 1093804
1093809 пакт_майка.webp 1000 1000 N N 1095591 302 ab__lc_catalog_icon 0 M 0 1093809
1093810 7f.jpg 1600 1600 N N 1095592 294 ab__lc_catalog_icon 0 M 0 1093810
1093812 санитарно_гиг_прод.jpg 1420 897 N N 1095594 315 ab__lc_catalog_icon 0 M 0 1093812
1101678 3kg_zeroplast24.ru.jpeg 1050 1248 N N 1103459 342 ab__lc_catalog_icon 0 M 0 1101678
1119418 flg1.jpg 225 225 N N 1121199 355 ab__lc_catalog_icon 0 M 0 1119418
1139189 76d85d64-ef2f-11e3-91c9-e811327f971d_5a257360-5096-11e9-a3ee-020ce70b0102.jpeg 400 400 N N 1140969 346 ab__lc_catalog_icon 0 M 0 1139189
1159007 nthv_2.jpeg 274 184 N N 1160787 334 ab__lc_catalog_icon 0 M 0 1159007