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 (
    387038, 387037, 387036, 387035, 387034, 
    387033, 387032, 387031, 387030, 387029, 
    387028, 387027, 387026, 387025, 387024, 
    387023, 387022, 387021, 387020, 387019
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00167

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "28.04"
    },
    "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": 20,
      "rows_produced_per_join": 20,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "24.04",
        "eval_cost": "4.00",
        "prefix_cost": "28.04",
        "data_read_per_join": "136K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`webmarco`.`cscart_product_descriptions`.`product_id` in (387038,387037,387036,387035,387034,387033,387032,387031,387030,387029,387028,387027,387026,387025,387024,387023,387022,387021,387020,387019)) and (`webmarco`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
387019 <p style="font-size:15px;">Office Table With Resin Surface</p> <p style="font-size:15px;">Art Dru offers different, decorative and professional Woodwork for furnishing the environment where you live or your business. We work with variety and special attention to detail and in the processing and choice of colors, giving importance to decorative motifs and resistance. </p> <p></p>
387020 <p style="font-size:15px;">Wooden Work Table For Goldsmith</p> <p style="font-size:15px;">Art Dru offers different, decorative and professional Woodwork for furnishing the environment where you live or your business. We work with variety and special attention to detail and in the processing and choice of colors, giving importance to decorative motifs and resistance. </p> <p></p>
387021 <p style="font-size:15px;">Restaurant Porch Table</p> <p style="font-size:15px;">Art Dru offers different, decorative and professional Woodwork for furnishing the environment where you live or your business. We work with variety and special attention to detail and in the processing and choice of colors, giving importance to decorative motifs and resistance. </p>
387022 <p style="font-size:15px;">Solid Wood Dining Table</p> <p style="font-size:15px;">Art Dru offers different, decorative and professional Woodwork for furnishing the environment where you live or your business. We work with variety and special attention to detail and in the processing and choice of colors, giving importance to decorative motifs and resistance. </p>
387023 <p style="font-size:15px;">Resin Dining Table</p> <p style="font-size:15px;">Art Dru offers different, decorative and professional Woodwork for furnishing the environment where you live or your business. We work with variety and special attention to detail and in the processing and choice of colors, giving importance to decorative motifs and resistance. </p> <p><br /></p>
387024 <p style="font-size:15px;">Home Table With Resin</p> <p style="font-size:15px;">Art Dru offers different, decorative and professional Woodwork for furnishing the environment where you live or your business. We work with variety and special attention to detail and in the processing and choice of colors, giving importance to decorative motifs and resistance. </p> <p><br /></p>
387025 <p style="font-size:15px;">Antibacterial Resin Surface Table</p> <p style="font-size:15px;">Art Dru offers different, decorative and professional Woodwork for furnishing the environment where you live or your business. We work with variety and special attention to detail and in the processing and choice of colors, giving importance to decorative motifs and resistance. </p> <p><br /></p>
387026 <p style="font-size:15px;">Table With Colored Resin According To Request</p> <p style="font-size:15px;">Art Dru offers different, decorative and professional Woodwork for furnishing the environment where you live or your business. We work with variety and special attention to detail and in the processing and choice of colors, giving importance to decorative motifs and resistance. </p> <p><br /></p>
387027 <p style="font-size:15px;">Resin Table</p> <p style="font-size:15px;">Art Dru offers different, decorative and professional Woodwork for furnishing the environment where you live or your business. We work with variety and special attention to detail and in the processing and choice of colors, giving importance to decorative motifs and resistance. </p> <p></p>
387028 <p style="font-size:15px;">Ecological Resin Table</p> <p style="font-size:15px;">Art Dru offers different, decorative and professional Woodwork for furnishing the environment where you live or your business. We work with variety and special attention to detail and in the processing and choice of colors, giving importance to decorative motifs and resistance. </p> <p><br /></p>
387029 <p style="font-size:15px;">Custom Size Wood And Resin Square Table</p> <p style="font-size:15px;">Art Dru offers different, decorative and professional Woodwork for furnishing the environment where you live or your business. We work with variety and special attention to detail and in the processing and choice of colors, giving importance to decorative motifs and resistance. </p> <p><br /></p>
387030 <p style="font-size:15px;">Round Wooden Living Room Table</p> <p style="font-size:15px;">Art Dru offers different, decorative and professional Woodwork for furnishing the environment where you live or your business. We work with variety and special attention to detail and in the processing and choice of colors, giving importance to decorative motifs and resistance. </p> <p></p>
387031 <p style="font-size:15px;">Big Table With Solid Wood For Restaurant</p> <p style="font-size:15px;">Art Dru offers different, decorative and professional Woodwork for furnishing the environment where you live or your business. We work with variety and special attention to detail and in the processing and choice of colors, giving importance to decorative motifs and resistance. </p>
387032 <p style="font-size:15px;">Simple Wooden Dining Table For Home</p> <p style="font-size:15px;">Art Dru offers different, decorative and professional Woodwork for furnishing the environment where you live or your business. We work with variety and special attention to detail and in the processing and choice of colors, giving importance to decorative motifs and resistance. </p> <p></p>
387033 <p style="font-size:15px;">Solid Wood Table Made To Order</p> <p style="font-size:15px;">Art Dru offers different, decorative and professional Woodwork for furnishing the environment where you live or your business. We work with variety and special attention to detail and in the processing and choice of colors, giving importance to decorative motifs and resistance. </p> <p><br /></p>
387034 <p style="font-size:15px;">Decorative Engraved Wood Table</p> <p style="font-size:15px;">Art Dru offers different, decorative and professional Woodwork for furnishing the environment where you live or your business. We work with variety and special attention to detail and in the processing and choice of colors, giving importance to decorative motifs and resistance. </p>
387035 <p style="font-size:15px;">Two-Color Resin Bread Table</p> <p style="font-size:15px;">Art Dru offers different, decorative and professional Woodwork for furnishing the environment where you live or your business. We work with variety and special attention to detail and in the processing and choice of colors, giving importance to decorative motifs and resistance. </p> <p><br /></p>
387036 <p style="font-size:15px;">Side Table With Resin For The Living Room</p> <p style="font-size:15px;">Art Dru offers different, decorative and professional Woodwork for furnishing the environment where you live or your business. We work with variety and special attention to detail and in the processing and choice of colors, giving importance to decorative motifs and resistance. </p> <p><br /></p>
387037 <p style="font-size:15px;">Modern Wooden Houses For Coastal Areas</p> <p style="font-size:15px;">Art Dru offers different, decorative and professional Woodwork for furnishing the environment where you live or your business. We work with variety and special attention to detail and in the processing and choice of colors, giving importance to decorative motifs and resistance. </p> <p></p>
387038 <p style="font-size:15px;">Modern Wooden House According To Project</p> <p style="font-size:15px;">Art Dru offers different, decorative and professional Woodwork for furnishing the environment where you live or your business. We work with variety and special attention to detail and in the processing and choice of colors, giving importance to decorative motifs and resistance. </p> <p></p>