SELECT 
  variant_id, 
  yml2_unit 
FROM 
  cscart_product_feature_variant_descriptions 
WHERE 
  variant_id IN (
    '1661', 
    '1535', 
    '523', 
    '542', 
    '1544', 
    '597', 
    '1', 
    '3', 
    '1730', 
    '1719', 
    '252', 
    '366', 
    '1737', 
    '182', 
    '1753', 
    '1672', 
    '1697', 
    '1644', 
    '441', 
    '1769', 
    '1634', 
    '1652', 
    '125', 
    '1721', 
    '1693', 
    '1715', 
    '367', 
    '1308', 
    '1696', 
    '1649', 
    '429', 
    '1702', 
    '1746', 
    '1706', 
    '1708', 
    '1748', 
    '1642', 
    '1671', 
    '1567', 
    '433', 
    '513', 
    '1805', 
    '1709', 
    '1711', 
    '1712', 
    '1720', 
    '1717', 
    '1670', 
    '1669', 
    '1665', 
    '1667', 
    '1662', 
    '1745', 
    '1699', 
    '1773', 
    '1691', 
    '1731', 
    '1733', 
    '1694', 
    '1742', 
    '1735', 
    '1739', 
    '1680', 
    '1740', 
    '1682', 
    '1674', 
    '1678', 
    '1683', 
    '233', 
    '1556', 
    '276', 
    '1561', 
    '1633', 
    '1688', 
    '1783', 
    '1778', 
    '1763', 
    '1767', 
    '1798', 
    '1619', 
    '1714', 
    '460', 
    '1638', 
    '1686', 
    '1725', 
    '1751', 
    '1757', 
    '1761', 
    '1758', 
    '1790', 
    '374', 
    '447', 
    '379', 
    '383', 
    '391', 
    '1340', 
    '122', 
    '121', 
    '440', 
    '127', 
    '439', 
    '1349', 
    '362', 
    '438', 
    '149', 
    '246', 
    '120', 
    '270', 
    '234', 
    '1664', 
    '146', 
    '431', 
    '446', 
    '59', 
    '50', 
    '57', 
    '58', 
    '147', 
    '1557', 
    '237', 
    '98', 
    '280', 
    '1756', 
    '469', 
    '257', 
    '376', 
    '1673', 
    '201', 
    '1637', 
    '378', 
    '1627', 
    '1629', 
    '206', 
    '170', 
    '1396', 
    '1646', 
    '1628', 
    '154', 
    '1592', 
    '165'
  ) 
  AND lang_code = 'kk'

Query time 0.00126

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "98.01"
    },
    "table": {
      "table_name": "cscart_product_feature_variant_descriptions",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "variant_id",
        "lang_code"
      ],
      "key_length": "9",
      "rows_examined_per_scan": 140,
      "rows_produced_per_join": 140,
      "filtered": "100.00",
      "index_condition": "((`test_uchur_k`.`cscart_product_feature_variant_descriptions`.`variant_id` in ('1661','1535','523','542','1544','597','1','3','1730','1719','252','366','1737','182','1753','1672','1697','1644','441','1769','1634','1652','125','1721','1693','1715','367','1308','1696','1649','429','1702','1746','1706','1708','1748','1642','1671','1567','433','513','1805','1709','1711','1712','1720','1717','1670','1669','1665','1667','1662','1745','1699','1773','1691','1731','1733','1694','1742','1735','1739','1680','1740','1682','1674','1678','1683','233','1556','276','1561','1633','1688','1783','1778','1763','1767','1798','1619','1714','460','1638','1686','1725','1751','1757','1761','1758','1790','374','447','379','383','391','1340','122','121','440','127','439','1349','362','438','149','246','120','270','234','1664','146','431','446','59','50','57','58','147','1557','237','98','280','1756','469','257','376','1673','201','1637','378','1627','1629','206','170','1396','1646','1628','154','1592','165')) and (`test_uchur_k`.`cscart_product_feature_variant_descriptions`.`lang_code` = 'kk'))",
      "cost_info": {
        "read_cost": "84.01",
        "eval_cost": "14.00",
        "prefix_cost": "98.01",
        "data_read_per_join": "436K"
      },
      "used_columns": [
        "variant_id",
        "lang_code",
        "yml2_unit"
      ]
    }
  }
}