SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '' 
    OR cscart_product_descriptions.short_description IS NULL, 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    94273, 94274, 94275, 94276, 94277, 94278, 
    94279, 94280, 94281, 94282, 94283, 
    94284, 94285, 94286, 94287, 94288, 
    94289, 94290, 94291, 94292, 94293, 
    94294, 94295, 94296, 94297, 94298, 
    94299, 94300, 94301, 94302, 94303, 
    94304, 94305, 94306, 94307, 94308, 
    94309, 94310, 94311, 94312, 94313, 
    94314, 94315, 94316, 94317, 94318, 
    94319, 94320, 94321, 94322, 94323, 
    94324, 94325, 94326, 94327, 94328, 
    94329, 94330, 94331, 94332, 94958, 
    95034, 95096, 95097, 95098, 95099, 
    95683, 95702, 95703, 96193, 96194, 
    96841, 96917, 96918, 96919, 96981, 
    96982, 96983, 96984, 96998, 98538, 
    98539, 98540, 98541, 98542, 98543, 
    98544, 98545, 98546, 98547, 98548, 
    98549, 100923, 100924, 100925, 100926
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00137

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "43.24"
    },
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "product_id"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id",
        "lang_code"
      ],
      "key_length": "9",
      "rows_examined_per_scan": 96,
      "rows_produced_per_join": 96,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "33.64",
        "eval_cost": "9.60",
        "prefix_cost": "43.24",
        "data_read_per_join": "366K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`nuie_scalesta_net`.`cscart_product_descriptions`.`product_id` in (94273,94274,94275,94276,94277,94278,94279,94280,94281,94282,94283,94284,94285,94286,94287,94288,94289,94290,94291,94292,94293,94294,94295,94296,94297,94298,94299,94300,94301,94302,94303,94304,94305,94306,94307,94308,94309,94310,94311,94312,94313,94314,94315,94316,94317,94318,94319,94320,94321,94322,94323,94324,94325,94326,94327,94328,94329,94330,94331,94332,94958,95034,95096,95097,95098,95099,95683,95702,95703,96193,96194,96841,96917,96918,96919,96981,96982,96983,96984,96998,98538,98539,98540,98541,98542,98543,98544,98545,98546,98547,98548,98549,100923,100924,100925,100926)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}