SELECT 
  q_product_descriptions.product_id, 
  q_product_descriptions.short_description, 
  IF(
    q_product_descriptions.short_description = '', 
    q_product_descriptions.full_description, 
    ''
  ) AS full_description 
FROM 
  q_product_descriptions 
WHERE 
  q_product_descriptions.product_id IN (
    363, 364, 365, 366, 367, 368, 369, 370, 
    371, 372, 373, 374, 375, 376, 377, 378, 
    379, 380, 381, 382, 383, 384, 385, 386, 
    387, 388, 389, 390, 391, 392
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00068

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "72.01"
    },
    "table": {
      "table_name": "q_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": 30,
      "rows_produced_per_join": 30,
      "filtered": "100.00",
      "index_condition": "((`portal`.`q_product_descriptions`.`product_id` in (363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392)) and (`portal`.`q_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "66.01",
        "eval_cost": "6.00",
        "prefix_cost": "72.01",
        "data_read_per_join": "114K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ]
    }
  }
}

Result

product_id short_description full_description
363
364
365
366 <p>Dolce & Gabbana Rosa Excelsa for women launched in 2016. The composition begins with exotic fruity papaya blossom and fresh neroli leaves. The signature ingredient of the collection, white amaryllis, is located in the heart of the composition, together with white water lily and white daffodil. The heart further on seduces with two types of roses: the first time ever used African Dog rose and Turkish rose absolute. The musky, woody and slightly piquant base includes accords of sandalwood, musk and cashmere.</p><ul><li>Notes: Papaya Flower, Neroli leaves, White Amaryllis, White Daffodil, White water Lily, African Dog Rose, Turkish Rose Absolute, Cashmeran, Musk, Sandalwood</li> <li>Size: 50 ml</li> </ul>
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384 <p>Dolce & Gabbana launched The One for Men in 2008 as the fragrance intended to become a masculine classics. In 2015, The One for Men Eau de Parfum appears as an enhanced, denser version of the scent. The elegant top notes of coriander, basil and grapefruit are leading to the heart where there is a warm blend of ginger, orange blossom and cardamom. Tobacco, sensual amber and cedar leave their mark at the base of the perfume.</p>
385
386
387 <ul><li>After presenting more than successful fragrance for women,</li><li> The One, Dolce&Gabbana house launched a fragrance for men named The One for Men at the begining of March 2008.</li></ul>
388
389
390
391
392