SELECT 
  category_id, 
  parent_id 
FROM 
  cscart_categories 
WHERE 
  parent_id IN(
    1618, 1636, 299, 1638, 1684, 1665, 1602, 
    1598, 1677, 1673, 1606, 1661, 1659, 
    700, 708, 1565, 1641, 1567, 1555, 1674, 
    1622, 1663, 1669, 1647, 1682, 1678, 
    1574, 1561, 1672, 1151, 775, 1562, 1585, 
    1646, 1630, 1662, 1644, 1651, 1671, 
    1614, 1656, 1652, 1650, 1668, 1666, 
    1657, 1571, 1570, 1683, 1612, 1664, 
    1643, 1601, 1637, 1648, 1675, 1584, 
    1579, 1619, 1676, 1681, 1658, 1660, 
    1591, 1685, 1649, 1655, 1654, 1680, 
    1645, 1687, 1629, 784, 1589, 1628, 1621, 
    1590, 1679, 787, 268, 277, 267, 455, 
    323, 271, 285, 265, 670, 266, 272, 280, 
    275, 273, 327, 325, 308, 313, 667, 309, 
    439, 291, 283, 286, 442, 370, 1688, 301
  )

Query time 0.00051

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_categories",
      "access_type": "ALL",
      "possible_keys": ["parent"],
      "rows": 217,
      "filtered": 80.64516449,
      "attached_condition": "cscart_categories.parent_id in (1618,1636,299,1638,1684,1665,1602,1598,1677,1673,1606,1661,1659,700,708,1565,1641,1567,1555,1674,1622,1663,1669,1647,1682,1678,1574,1561,1672,1151,775,1562,1585,1646,1630,1662,1644,1651,1671,1614,1656,1652,1650,1668,1666,1657,1571,1570,1683,1612,1664,1643,1601,1637,1648,1675,1584,1579,1619,1676,1681,1658,1660,1591,1685,1649,1655,1654,1680,1645,1687,1629,784,1589,1628,1621,1590,1679,787,268,277,267,455,323,271,285,265,670,266,272,280,275,273,327,325,308,313,667,309,439,291,283,286,442,370,1688,301)"
    }
  }
}