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 (415305, 427823, 415306) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00055

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "4.21"
    },
    "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": 3,
      "rows_produced_per_join": 3,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "3.62",
        "eval_cost": "0.60",
        "prefix_cost": "4.22",
        "data_read_per_join": "20K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`webmarco`.`cscart_product_descriptions`.`product_id` in (415305,427823,415306)) and (`webmarco`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
415305 <p>EDAR®️ electric device for injecting tobacco into cigarette tubes</p> <p>Electric cigarette machine, ideal for people who want the cigarettes to start "rolling" by themselves and therefore save time for smoking.<br />It is very easy to use - you just need to press the handle on the guide, insert the sheet, add tobacco to the container, set the filling density of the cigarette, press the blue button and soon smoke the finished cigarette.<br />Cigarette maker or automatic machine<br />The device is powered by the 220V socket via the power supply included in the package. This way you save at least 50% of the money spent on cigarettes in the store!<br />cigarette making machine<br />Box Contents:<br />- electrical appliance -<br />220V - 12 V power supply<br />- cleaning brush<br />Dimensions: length 15.5 cm, width 7.5 cm, height 7 cm<br />We recommend you follow the steps below to make your own cigarettes:<br />1. Put tobacco in the tub. Do not stuff the tobacco.<br />2. Press the cigarette tube over the metal tube holder using a rotating motion, slide all the way and release the lever.<br />3. Press the tobacco stuffing button and the metal tube will gradually fill. The cigarette tube is pushed to one side by the tobacco and it is a normal action. The side button adjusts the consistency of the tobacco in the cigarette.<br />Capacity up to 5 cigarettes per minute.<br />The package contains<br />- Electric filter<br />- AC power adapter<br />- Brush cleaning<br />- A tobacco spatula</p> <p></p>
415306 <p>Electric cigarette maker Gerui 002 professional tobacco injector<br /></p> <p>Electric cigarette maker GR 002 professional tobacco injector</p> <p>Follow some very simple steps:<br />1. Add tobacco to the tub.. 2. Attach the empty tube to the cigarette. 3. Adjust the tobacco density from the side button. (3 adjustment levels) 4. Press the Start button.<br />The package contains: Cigarette maker Power supply socket 230V Cleaning brush. Instructions for use.<br />Technical data: Adapter input: AC230V 50~60Hz 0.15A Adapter output: DC7.5V 3W Dimensions: 22.5*7*8.2cm.</p> <p></p>
427823 <p><font style="vertical-align:inherit;"><font style="vertical-align:inherit;"></font></font></p>