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 (
    94638, 94639, 94640, 94671, 94672, 94673, 
    94674, 94822, 94839, 94840, 94841, 
    94844, 94845, 94846, 94847, 94848, 
    94952, 94953, 94954, 94955, 95310, 
    95311, 95317, 95319, 95320, 95361, 
    95362, 95363, 95364, 95365, 95366, 
    95367, 95368, 95369, 95370, 95371, 
    95372, 95373, 95374, 95375, 95377, 
    95392, 95393, 95442, 95592, 95593, 
    95594, 95595, 95596, 95597, 95598, 
    95599, 95600, 95601, 95602, 95603, 
    95604, 95605, 95606, 95607, 95608, 
    95609, 95610, 95611, 95612, 95613, 
    95614, 95615, 95616, 95617, 95618, 
    95619, 95620, 95621, 95622, 95623, 
    95624, 95625, 95626, 95627, 95628, 
    95764, 95766, 95767, 95780, 95781, 
    95782, 95783, 95784, 95785, 95829, 
    95890, 95893, 95925, 95926, 95927
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00162

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 (94638,94639,94640,94671,94672,94673,94674,94822,94839,94840,94841,94844,94845,94846,94847,94848,94952,94953,94954,94955,95310,95311,95317,95319,95320,95361,95362,95363,95364,95365,95366,95367,95368,95369,95370,95371,95372,95373,95374,95375,95377,95392,95393,95442,95592,95593,95594,95595,95596,95597,95598,95599,95600,95601,95602,95603,95604,95605,95606,95607,95608,95609,95610,95611,95612,95613,95614,95615,95616,95617,95618,95619,95620,95621,95622,95623,95624,95625,95626,95627,95628,95764,95766,95767,95780,95781,95782,95783,95784,95785,95829,95890,95893,95925,95926,95927)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}