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 = 'feature_variant' 
  AND cscart_images_links.type = 'V' 
  AND cscart_images_links.object_id IN (
    1446, 
    1512, 
    1511, 
    1513, 
    1214, 
    1646, 
    1218, 
    1475, 
    1522, 
    1237, 
    1506, 
    1651, 
    1225, 
    1516, 
    1505, 
    1232, 
    1352, 
    1648, 
    1509, 
    1262, 
    1501, 
    1518, 
    1227, 
    1243, 
    1410, 
    1250, 
    1212, 
    1246, 
    1208, 
    1248, 
    1462, 
    1480, 
    1497, 
    1496, 
    1203, 
    1206, 
    1432, 
    1367, 
    1645, 
    1463, 
    1500, 
    1447, 
    1504, 
    1445, 
    1507, 
    1524, 
    1303, 
    1458, 
    1400, 
    1302, 
    1450, 
    1502, 
    1494, 
    1380, 
    1378, 
    1392, 
    1399, 
    1503, 
    1517, 
    1404, 
    1459, 
    1519, 
    1374, 
    1305, 
    1376, 
    1461, 
    1526, 
    1521, 
    1388, 
    1382, 
    1377, 
    1403, 
    1481, 
    1652, 
    1498, 
    1523, 
    1510, 
    1499, 
    1493, 
    1379, 
    1401, 
    1393, 
    1556, 
    1649, 
    1650, 
    1351, 
    1484, 
    1486, 
    1375, 
    1514, 
    1394, 
    1395, 
    1223, 
    1647, 
    1478, 
    1515, 
    1508, 
    1520, 
    1525, 
    1221, 
    1533, 
    1434, 
    1456, 
    1441, 
    1541, 
    1544, 
    1468, 
    1455, 
    1253, 
    1470, 
    1466, 
    1443, 
    1464, 
    1539, 
    1435, 
    1438, 
    1469, 
    1474, 
    1439, 
    1210, 
    1465, 
    1535, 
    1537, 
    1536, 
    1440, 
    1398, 
    1471, 
    1540, 
    1453, 
    1452, 
    1467, 
    1454, 
    1436, 
    1437, 
    1473, 
    1472, 
    1542, 
    1449, 
    1495, 
    1207, 
    1427, 
    1423, 
    1209, 
    1426, 
    1548, 
    1425, 
    1424, 
    1428, 
    1429, 
    1431, 
    1433
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00222

JSON explain

{
  "query_block": {
    "select_id": 1,
    "read_sorted_file": {
      "filesort": {
        "sort_key": "cscart_images_links.position, cscart_images_links.pair_id",
        "table": {
          "table_name": "cscart_images_links",
          "access_type": "range",
          "possible_keys": ["object_id"],
          "key": "object_id",
          "key_length": "81",
          "used_key_parts": ["object_id", "object_type", "type"],
          "rows": 151,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'feature_variant' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (1446,1512,1511,1513,1214,1646,1218,1475,1522,1237,1506,1651,1225,1516,1505,1232,1352,1648,1509,1262,1501,1518,1227,1243,1410,1250,1212,1246,1208,1248,1462,1480,1497,1496,1203,1206,1432,1367,1645,1463,1500,1447,1504,1445,1507,1524,1303,1458,1400,1302,1450,1502,1494,1380,1378,1392,1399,1503,1517,1404,1459,1519,1374,1305,1376,1461,1526,1521,1388,1382,1377,1403,1481,1652,1498,1523,1510,1499,1493,1379,1401,1393,1556,1649,1650,1351,1484,1486,1375,1514,1394,1395,1223,1647,1478,1515,1508,1520,1525,1221,1533,1434,1456,1441,1541,1544,1468,1455,1253,1470,1466,1443,1464,1539,1435,1438,1469,1474,1439,1210,1465,1535,1537,1536,1440,1398,1471,1540,1453,1452,1467,1454,1436,1437,1473,1472,1542,1449,1495,1207,1427,1423,1209,1426,1548,1425,1424,1428,1429,1431,1433)"
        }
      }
    },
    "table": {
      "table_name": "cscart_images",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "4",
      "used_key_parts": ["image_id"],
      "ref": ["noframes_kz_new.cscart_images_links.detailed_id"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_images_links.detailed_id = cscart_images.image_id)"
    },
    "table": {
      "table_name": "cscart_common_descriptions",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "107",
      "used_key_parts": ["object_id", "lang_code", "object_holder"],
      "ref": ["noframes_kz_new.cscart_images.image_id", "const", "const"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_common_descriptions.object_id = cscart_images.image_id and cscart_common_descriptions.object_holder = 'images' and cscart_common_descriptions.lang_code = 'ru' and trigcond(cscart_images.image_id is not null))"
    }
  }
}