SELECT 
  cscart_product_descriptions.product_id, 
  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 (64849, 62844, 62840, 62839) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00045

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": 4,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (64849,62844,62840,62839) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
62839 multi-light chandelier, industrial pendant light, industrial lighting, bare bulb light, bare bulb lighting fixture, bare bulb chandelier, industrial multi-light, industrial chandelier Inspired by vintage industrial pendant lighting the bare-bulb look of this multi-light chandelier offers modern style for both residential and commercial lighting. BLE-C-SCP01, The Indy Industrial Multi-Light Chandelier, multi-light chandelier, multi-light pendant, cluster pendant, cluster light, indy industrial, indy light, chandelier, industrial chandelier, cord hung chandelier, minimalist lighting, bare bulb, bare bulb lighting, bare bulb pendant, bare bulb chandelier, indy chandelier, indy light fixture, indy lighting fixtures, BLE multi light chandelier, ble chandelier, 3 and 5 light chandelier, 3 5 light chandelier, 3 5 chandelier, 3-light chandelier, 3-light chandeliers, Triple Pendant lights, Triple Pendant lights, Triple Pendant lighting, Triple Pendant light,
62840 multi-light chandeliers, pendant lighting, chandelier lighting, cord hung pendant lighting, ball jar lighting, mason jar lighting fixture, recycled lighting, upcycled lighting, recycled chandelier, ball jar chandelier, ball jar lighting fixture, cluster c Recycled Ball Jars make up this multi-light chandelier’s cord hung pendants. The unique look of the pendant light adds something special to residential spaces. BLE-C-SCP02, The Ball Jar Multi-Light Chandelier, ball jar chandelier, ball jar light, ball jar pendant, ball jar pendant lighting, ball jar cord light, mason jar light, jar light, jar pendant, multi-light chandelier, multi light chandelier, cluster pendant, cluster lighting, ball light, ball chandelier, ball pendant, cord hung chandelier, cord pendant chandelier, cord chandelier, multi light pendant, multi-light pendant, BLE multi light chandelier, ble chandelier, 3 and 5 light chandelier, 3 5 light chandelier, 3 5 chandelier, BLE-C-LCP02, C-LCP02, LCP02, 3-light chandelier, 3-light chandeliers, 5-light chandelier, 5-light chandeliers, new listing, mason jar collection, mason jar series, ball jar collection, ball jar series, jar collection, jar series, jar light collection, jar light series, the mason jar collection, the mason jar series, the ball jar collection, the ball jar series, the jar collection, the jar series, the jar light collection, the jar light series, SPS-0212, SPS 0212, SPS0212, multi-light chandelier collection, multi light chandelier collection, multilight chandelier collection, multi-light chandelier series, multi light chandelier series, multilight chandelier series, Triple Pendant lights, Triple Pendant lighting, Triple Pendant light, mason jar pendants,
62844 raw brass multi light, multi light chandelier, multi-light chandelier, multi light, bare bulb lighting, industrial chandelier With a brass socket, this multi-light chandelier matches ceiling lighting with industrial pendants. This lighting fixture brings its style to commercial lighting. BLE-C-SCP05, The Raw Brass Multi-Light Chandelier, multi light chandelier, raw brass multi light, multi-light, multi-light chandelier, bare bulb light, bare bulb multi light, raw brass chandelier, raw brass lighting, brass socket, brass socket pendant light, brass socket multi light, brass socket multi-light, barebulb multi-light, bare bulb multi-light, exposed bulb lighting, exposed bulb chandelier, multi light pendant, multi light pendant lighting, multi pendant light, multi pendant lighting, multiple light chandelier, multiple light pendant, multiple pendant chandelier, cluster pendant, cluster lighting, BLE multi light chandelier, ble chandelier, 3 and 5 light chandelier, 3 5 light chandelier, 3 5 chandelier, 3-light chandelier, 3-light chandeliers, Triple Pendant lights, Triple Pendant lighting, Triple Pendant light,
64849 Fully customizable, this multi-light pendant features an authentic industrial character. Give any space a rugged, eye-catching style! new listing, new mig, BLE-C-MLP3-MIG, Mig Multi-Light Pendant, Mig Multi-Light Pendants, The Mig Multi-Light Pendant, The Mig Multi-Light Pendants, Mig, The mig, Mig Chandelier, Mig Pendant, Mig Pendants, Multi-light pendant, multi-light pendants, multi-light chandelier, multi-light chandeliers, Mig 3-light Pendant, Mig 3-light chandelier, Mig multilight pendant, mig multilight chandelier, multilight pendant, multilight chandelier, cluster pendant, cluster chandelier, multi-light cluster pendant, multilight cluster pendant, multi-light cluster chandelier, multilight cluster chandelier, Mig Multi Light Pendant, Mig Multi Light Pendants, The Mig Multi Light Pendant, The Mig Multi Light Pendants, Multi Light Pendant, Multi Light Chandelier, Multi Light Cluster Pendant, Multi Light Cluster Chandelier, mig multi light chandelier, mig multilight chandelier, Mig cluster chandelier, SPS-0473, SPS 0473, SPS0473, Mig Collection, The Mig Collection, Mig Series, The Mig Series, Triple Pendant lights, Triple Pendant lighting, Triple Pendant light, the mig retro, gas cap,