SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '', 
    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 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (64689, 64688) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00049

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": ["PRIMARY", "product_id"],
      "key": "product_id",
      "key_length": "9",
      "used_key_parts": ["product_id", "lang_code"],
      "rows": 2,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (64689,64688) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
64688 <p>To establish its imaginative design, this pendant’s shade is constructed from chicken wire and suspended from an eye-catching cord. With the authentic industrial details this shade provides, homes can obtain a fashionable farmhouse-inspired style, and businesses can possess the unique decorative features needed to stand out. Various powder coat finish colors let the Chicken Wire Pendant adapt to any space’s look!</p> <p>|break|</p> <ul> <li>Hand-built and American-made, this quality cord hung pendant is a lasting lighting option. </li> <li>Made-to-order, learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>.</li> <li>Read more about the Chicken Wire Pendant Light over on our <a href="https://www.barnlight.com/inspiration/chicken-wire-ceiling-pendants-right-at-home-down-on-the-farm/" target="_blank">blog</a>!</li> </ul> <p> </p> vintage cord pendant light, mid-century cord pendant light, commercial pendant lights, classic design commercial lighting, mid-century commercial lighting, vintage commercial lighting, chicken wire lighting Our Chicken Wire Pendant Light is an instant favorite in farmhouse and industrial décors! Fully customizable with different finish colors and cord options! new listing, chicken cord, chicken pendant, chicken wire, Chicken Wire, Chickenwire, Chicken Wire Pendant, Chicken Wire Pendants, Chicken Wire Cord pendant, Chicken Wire Cord Pendants, Chicken Wire Cord Pendant Light, Chicken Wire Cord, Chicken Wire Cord Pendant Lights, Chicken Wire Cord Pendant Lighting, BLE-C-EIO, Chicken Wire Ceiling Pendant, Chicken Wire Ceiling Pendants, Chicken Wire Ceiling Light, Chicken Wire Ceiling Lights, Chicken Wire Ceiling Lighting, Farmhouse, Farmhouse Lighting, Pendant island lights, chicken wire light, chicken wire lights, chicken wire lighting, chicken wire collection, chicken wire series, SPS-0451, SPS 0451, SPS0451, corded pendant, corded pendants, corded pendant light, corded pendant lights, corded pendant lighting, corded ceiling pendant, corded ceiling pendants, corded ceiling light, corded ceiling lights, corded ceiling lighting, corded pendant light fixture, corded pendant light fixtures, corded pendant lighting fixture, corded pendant lighting fixtures, corded light fixture, corded light fixtures, corded lighting fixture, corded lighting fixtures, corded, basket, chicken wire basket, basket light,
64689 <p>Discovering an imaginative new purpose for an agricultural staple, this pendant functions as a truly unique focal point in residential and commercial settings. Used to create the pendant’s shade, chicken wire lends an authentic industrial character to a décor. The fixture’s rugged stem mounting provides a more formal appearance to the design while protecting its wires. This aesthetic complements trendy farmhouse styles and offers eye-catching decorative touches to commercial buildings like bars, restaurants, and boutique stores.</p> <p>|break|</p> <ul> <li>Hand-built and American-made, this quality stem mount pendant is a lasting lighting option. </li> <li>Made-to-order, learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>.</li> </ul> Our Chicken Wire Stem Mount Pendant Light offers a unique focal point to homes and businesses! Choose a vivid finish color and revamp your décor today! new listing, chicken stem, chicken pendant, chicken wire, BLE-S-EIO, Chicken Wire Stem Mount Pendant Light, Chicken Wire Stem Mount Pendant Lights, Chicken Wire Stem Mount Pendant Lighting, Chicken Wire Stem Pendant, Chicken Wire Stem Pendants, Chicken Wire Stem Pendant Light, Chicken Wire Stem Pendant Lights, Chicken Wire Stem Ceiling Pendant, Chicken Wire Stem Ceiling Pendants, Chicken Wire Stem, Chicken Wire, Chickenwire, Chicken Wire Pendant, Chicken Wire Pendants, Chicken Wire stem pendant, Chicken Wire stem Pendants, Chicken Wire stem Pendant Light, Chicken Wire stem, Chicken Wire stem Pendant Lights, Chicken Wire stem Pendant Lighting, BLE-C-EIO, Chicken Wire Ceiling Pendant, Chicken Wire Ceiling Pendants, Chicken Wire Ceiling Light, Chicken Wire Ceiling Lights, Chicken Wire Ceiling Lighting, Farmhouse, Farmhouse Lighting, chicken wire light, chicken wire lights, chicken wire lighting, chicken wire collection, chicken wire series, SPS-0451, SPS 0451, SPS0451, stems, Stem pendant lights, stem light mount, stem light mounts, stem, basket, chicken wire basket, basket light,