Sandbox

SELECT 
  a.*, 
  b.option_name, 
  b.internal_option_name, 
  b.option_text, 
  b.description, 
  b.inner_hint, 
  b.incorrect_message, 
  b.comment 
FROM 
  cscart_product_options as a 
  LEFT JOIN cscart_product_options_descriptions as b ON a.option_id = b.option_id 
  AND b.lang_code = 'en' 
  INNER JOIN cscart_ult_objects_sharing ON (
    cscart_ult_objects_sharing.share_object_id = a.option_id 
    AND cscart_ult_objects_sharing.share_company_id = 1 
    AND cscart_ult_objects_sharing.share_object_type = 'product_options'
  ) 
WHERE 
  a.product_id IN (
    403, 1414, 151, 57, 58, 29, 1947, 683, 
    1377, 1166, 358, 1167, 708, 1177, 1195, 
    1208, 1178, 1849, 1846, 1848, 1847, 
    1171, 1322, 1448, 789, 1375, 1230, 1227, 
    1770, 1769, 1420, 77, 1449, 1235, 1442, 
    1958, 67, 1252, 803, 1169, 1712, 1759, 
    1341, 1592, 1474, 1733, 1002, 1930, 
    1561, 1705, 1704, 1609, 1935, 1936, 
    1929, 1528, 1527, 1526, 1508, 1534, 
    1533, 1841, 1531, 1529, 1530, 1843, 
    1532, 1515, 1904, 1873, 1897, 1896, 
    1728, 1607, 1608, 1606, 1703, 1578, 
    1396, 1605, 1206, 1586, 1934, 1932, 
    1933, 1656, 1542, 1640, 1543, 1655, 
    1927, 1926, 1815, 1808, 1541, 1829
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position

Query time 0.00098

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}