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 (
    1385, 
    1477, 
    1291, 
    1530, 
    1363, 
    1421, 
    1387, 
    1637, 
    1483, 
    1444, 
    1527, 
    1476, 
    1331, 
    1636, 
    1451, 
    1310, 
    1350, 
    1448, 
    1405, 
    1267, 
    1406, 
    1373, 
    1408, 
    1315, 
    1264, 
    1407, 
    1336, 
    1364, 
    1362, 
    1482, 
    1306, 
    1324, 
    1222, 
    1220, 
    1343, 
    1555, 
    1479, 
    1327, 
    1213, 
    1491, 
    1381, 
    1217, 
    1275, 
    1236, 
    1554, 
    1490, 
    1308, 
    1224, 
    1234, 
    1489, 
    1229, 
    1488, 
    1370, 
    1356, 
    1252, 
    1359, 
    1532, 
    1402, 
    1226, 
    1460, 
    1249, 
    1211, 
    1245, 
    1633, 
    1346, 
    1273, 
    1384, 
    1247, 
    1642, 
    1396, 
    1531, 
    1239, 
    1390, 
    1368, 
    1492, 
    1485, 
    1307, 
    1487, 
    1638, 
    1641, 
    1357, 
    1630, 
    1632, 
    1640, 
    1360, 
    1369, 
    1371, 
    1231, 
    1644, 
    1629, 
    1538, 
    1287, 
    1643, 
    1354, 
    1631, 
    1372, 
    1634, 
    1635, 
    1543, 
    1383, 
    1386, 
    1639, 
    1534, 
    1242, 
    1361, 
    1391, 
    1442, 
    1533, 
    1434, 
    1456, 
    1441, 
    1541, 
    1544, 
    1468, 
    1455, 
    1253, 
    1470, 
    1466, 
    1443, 
    1464, 
    1539, 
    1435, 
    1438, 
    1469, 
    1474, 
    1439, 
    1465, 
    1535, 
    1537, 
    1536, 
    1440, 
    1398, 
    1471, 
    1540, 
    1453, 
    1452, 
    1467, 
    1454, 
    1436, 
    1437, 
    1473, 
    1472, 
    1542, 
    1449, 
    1529, 
    1528, 
    1358, 
    1427, 
    1263, 
    1423, 
    1258, 
    1426, 
    1345, 
    1425, 
    1355, 
    1424, 
    1428, 
    1299, 
    1429, 
    1251, 
    1320, 
    1431, 
    1301, 
    1260, 
    1433, 
    1340, 
    1304, 
    1319, 
    1337
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00483

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": 169,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'feature_variant' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (1385,1477,1291,1530,1363,1421,1387,1637,1483,1444,1527,1476,1331,1636,1451,1310,1350,1448,1405,1267,1406,1373,1408,1315,1264,1407,1336,1364,1362,1482,1306,1324,1222,1220,1343,1555,1479,1327,1213,1491,1381,1217,1275,1236,1554,1490,1308,1224,1234,1489,1229,1488,1370,1356,1252,1359,1532,1402,1226,1460,1249,1211,1245,1633,1346,1273,1384,1247,1642,1396,1531,1239,1390,1368,1492,1485,1307,1487,1638,1641,1357,1630,1632,1640,1360,1369,1371,1231,1644,1629,1538,1287,1643,1354,1631,1372,1634,1635,1543,1383,1386,1639,1534,1242,1361,1391,1442,1533,1434,1456,1441,1541,1544,1468,1455,1253,1470,1466,1443,1464,1539,1435,1438,1469,1474,1439,1465,1535,1537,1536,1440,1398,1471,1540,1453,1452,1467,1454,1436,1437,1473,1472,1542,1449,1529,1528,1358,1427,1263,1423,1258,1426,1345,1425,1355,1424,1428,1299,1429,1251,1320,1431,1301,1260,1433,1340,1304,1319,1337)"
        }
      }
    },
    "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))"
    }
  }
}