Sandbox

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, 
  cscart_product_descriptions.meta_keywords, 
  cscart_product_descriptions.meta_description, 
  cscart_product_descriptions.search_words, 
  cscart_product_descriptions.promo_text, 
  cscart_product_descriptions.unit_name 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    3443, 3469, 3464, 3459, 6950, 3470, 3457, 
    3462, 3450, 3458, 3463, 3451
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00052

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "14.46"
    },
    "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": 12,
      "rows_produced_per_join": 12,
      "filtered": "100.00",
      "index_condition": "((`gaseus`.`cscart_product_descriptions`.`product_id` in (3443,3469,3464,3459,6950,3470,3457,3462,3450,3458,3463,3451)) and (`gaseus`.`cscart_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "13.26",
        "eval_cost": "1.20",
        "prefix_cost": "14.46",
        "data_read_per_join": "54K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description",
        "meta_keywords",
        "meta_description",
        "search_words",
        "promo_text",
        "unit_name"
      ]
    }
  }
}

Result

product_id	short_description	full_description	meta_keywords	meta_description	search_words	promo_text	unit_name
3443		acc. to ISO 2503, class 5, single stage, with high pressure compensation for constant working pressure, with safety gauges acc. to ISO 5171, with shut off valve,inlet pressure max.: 200 bar<br />outlet pressure: 0 – 20 bar adjustable<br />flow max.: 75 Nm³/h air at 10 bar working pressure<br />Inlet connection: W24,32x1/14RH nut acc. to DIN 477-1, no. 10<br />outlet connection: G 1/4 RHk x 6 mm tailpiece acc. to EN 560<br />inlet gauge: 0 - 315/200 bar<br />working gauge: 0 - 40/20 bar<br />width x height x depth: 210 x 210 x 75 mm<br />with Linde-Logo stamped on body, with Linde operating manual and Linde adhesive tape
3450		acc to DIN EN ISO 2503, single stage, with high pressure compensation for a constant working pressure on falling inlet pressure with safety gauges acc. to DIN ISO 5171inlet pressure max:200 bar<br />outlet pressure: 0 – 40 bar adjustable<br />flow max: 120 Nm³/h at 40 bar working pressure<br />inlet connection: W21,8x1/14LHf nut acc. to DIN 477-1, no. 1<br />outlet connection: G 3/8LH x 9mm tail-piece<br />inlet gauge: 0 – 315/200 bar<br />working gauge: 0 – 60/40 bar<br />width x height x depth: 210 x 210 x 75 mm<br />with Linde-Logo stamped on body, with Linde operating manual and Linde adhesive tape
3451		acc to DIN EN ISO 2503, single stage, with high pressure compensation for a constant working pressure on falling inlet pressure with safety gauges acc. to DIN ISO 5171inlet pressure max:200 bar<br />outlet pressure: 0 – 60 bar adjustable<br />flow max: 140 Nm³/h at 60 bar working pressure<br />inlet connection: W21,8x1/14LHf nut acc. to DIN 477-1, no. 1<br />outlet connection: G 3/8LHak acc. to EN560<br />inlet gauge: 0 – 315/200 bar<br />working gauge: 0 – 100/60 bar<br />width x height x depth: 210 x 210 x 75 mm<br />with Linde-Logo stamped on body, with Linde operating manual and Linde adhesive tape
3457		<p>acc to DIN EN ISO 2503, single stage, with high pressure compensation for a constant working pressure on falling inlet pressure with safety gauges acc. to DIN ISO 5171inlet pressure max: 200 bar</p><p>outlet pressure: 0 – 40 bar adjustable<br><br>flow max: 120 Nm³/h at 40 bar working pressure<br><br>inlet connection: W21,8x1/14RHf nut acc. to DIN 477-1, no. 6<br><br>outlet connection: G 1/4RH x 6mm tail-piece<br><br>inlet gauge: 0 – 315/200 bar<br><br>working gauge: 0 – 60/40 bar<br><br>width x height x depth: 210 x 210 x 75 mm<br><br>with Linde-Logo stamped on body, with Linde operating manual and Linde adhesive tape</p>
3458		<p>acc to DIN EN ISO 2503, single stage, with high pressure compensation for a constant working pressure on falling inlet pressure with safety gauges acc. to DIN ISO 5171inlet pressure max: 200 bar</p><p>outlet pressure: 0 – 60 bar adjustable<br><br>flow max: 140 Nm³/h at 60 bar working pressure<br><br>inlet connection: W21,8x1/14 RHf nut acc. to DIN 477-1, no. 6<br><br>outlet connection: G 1/4RHak acc. to EN560<br><br>inlet gauge: 0 – 315/200 bar<br><br>working gauge: 0 – 100/60 bar<br><br>width x height x depth: 210 x 210 x 75 mm<br><br>with Linde-Logo stamped on body, with Linde operating manual and Linde adhesive tape</p>
3459		acc. to ISO 2503, single stage with safety gauges acc. to EN562inlet pressure max:200 bar<br />outlet pressure: 10 - 200 bar adjustable<br />flow max: 380 Nm³/h at 50 bar outlet pressure <br />inlet connection: W 21,8x1/14 RH nut acc. to DIN 477-1, no. 6<br />outlet connection: W 21,8x1/14 RH male DIN 477-1, no. 6<br />inlet gauge: 0 – 315/200 bar<br />working gauge: 0 – 315/200 bar<br />width x height x depth: 170 x 140 x 180 mm<br />with Linde-Logo stamped on body, with Linde operating manual and Linde adhesive tape
3462		acc to DIN EN ISO 2503, single stage, with high pressure compensation for a constant working pressure on falling inlet pressure with safety gauges acc. to DIN ISO 5171inlet pressure max:200 bar<br />outlet pressure: 0 – 40 bar adjustable<br />flow max: 120 Nm³/h at 40 bar working pressure<br />inlet connection: G5/8RH screw acc. to DIN 477-1, no. 13<br />outlet connection: G 1/4RH x 6mm tail-piece<br />inlet gauge: 0 – 315/200 bar<br />working gauge: 0 – 60/40 bar<br />width x height x depth: 210 x 210 x 75 mm<br />with Linde-Logo stamped on body, with Linde operating manual and Linde adhesive tape
3463		acc to DIN EN ISO 2503, single stage, with high pressure compensation for a constant working pressure on falling inlet pressure with safety gauges acc. to DIN ISO 5171inlet pressure max:200 bar<br />outlet pressure: 0 – 60 bar adjustable<br />flow max: 140 Nm³/h at 60 bar working pressure<br />inlet connection: G5/8RH screw acc. to DIN 477-1, no. 13<br />outlet connection: G 1/4RH acc. to EN560<br />inlet gauge: 0 – 315/200 bar<br />working gauge: 0 – 100/60 bar<br />width x height x depth: 210 x 210 x 75 mm<br />with Linde-Logo stamped on body, with Linde operating manual and Linde adhesive tape
3464		acc. to ISO 2503, single stage with safety gauges acc. to EN562inlet pressure max:200 bar<br />outlet pressure: 10 - 200 bar adjustable<br />flow max: 380 Nm³/h at 50 bar outlet pressure <br />Inlet connection: G 5/8 RHaf screw acc. to DIN 477-1, no. 13<br />Outlet connection: G 5/8 RHif acc. to DIN 477-1, no. 13<br />inlet gauge: 0 – 315/200 bar<br />working gauge: 0 – 315/200 bar<br />width x height x depth: 210 x 190 x 75 mm<br />with Linde-Logo stamped on body, with Linde operating manual and Linde adhesive tape
3469		acc to DIN EN ISO 2503, class 5, single stage, adiabatic compression tested acc. to DIN EN ISO 2503, with high pressure compensation for a constant working pressure on falling inlet pressure with safety gauges acc. to DIN ISO 5171inlet pressure max:200 bar<br />outlet pressure: 0 – 20 bar adjustable<br />flow max: 75 Nm³/h at 20 bar working pressure<br />inlet connection: G3/4 RHf nut acc. to DIN 477-1, no. 9<br />outlet connection: G 1/4RH x 6mm tail-piece<br />inlet gauge: 0 – 315 /200 bar<br />working gauge: 0 – 40/ 20 bar<br />width x height x depth: 210 x 210 x 75 mm
3470		acc. to ISO 2503, single stage with safety gauges acc. to ISO 5171inlet pressure max:200 bar<br />outlet pressure: 10 - 200 bar adjustable<br />flow max: 380 Nm³/h at 50 bar outlet pressure <br />inlet connection: G3/4 RH nut acc. to DIN 477-1, no. 9<br />outlet connection: G 3/4 RH male acc. to DIN 477-1, no. 9<br />inlet gauge: 0 – 315/200 bar<br />working gauge: 0 – 315/200 bar<br />width x height x depth: 150 x 210 x 120 mm<br />with Linde-Logo stamped on body, with Linde operating manual and Linde adhesive tape
6950		acc. to ISO 2503, single stage with safety gauges acc. to EN562inlet pressure max:200 bar<br />outlet pressure: 10 - 200 bar adjustable<br />flow max: 380 Nm³/h at 50 bar outlet pressure <br />inlet connection: W 24,32x1/14 RH nut acc. to DIN 477-1, no. 10<br />outlet connection: W24,32x1/14RH male acc. to DIN 477-1, no. 10<br />inlet gauge: 0 – 315/200 bar<br />working gauge: 0 – 315/200 bar<br />width x height x depth: 210 x 190 x 75 mm<br />with Linde-Logo stamped on body, with Linde operating manual and Linde adhesive tape